Project 2 Su17 (2) - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in AutoSum Calibri General Paste B 1 u. m . 2 .A. fE E Merge & Certer. $. 96 , 58.8 conditional Format as Cell Insert Delete Format Sort & Find & Filter Select" Formatting v Table Styles w Clear Clipboard Font Alignment Number Cells Editing 0 4 Name: Class time 6 Enter the last 4 digits of your student ID number: (These digits will be used to for some variables in the project) projec Highest- 8 Save this file in EXCEL FORMAT as: P2Lastname 9 Round all dollar amounts to whole dollars, except for per unit amounts. Per unit amounts should be Lowest other than 0- 10 rounded to the nearest cent. Percentages should be rounded as follows: 20.75% or .2075 11 Do not change rows or colums on this spreadsheet. Input areas are in yellow 12 You MUST show your work in the areas indicated to get credit for the problem. 13 14 Presented below is Trident Company's Income Statement prepared on the traditional (functional) basis: 15 16 Requirement 1: Replace the two unknown amounts (?) in A. and B. as directed. To find the unknown for B, you l have to complete Requirement 2. Then, complete the totals on the income statement. 18 19 20 21 Trident Company Income Statement For the Year Ended December 31, 2016 Sales $350,000 23 Cost of Goods Sold $60,000 Direct Materials (variable) Direct Labor (variable) Manufacturing Overhead (mixed) 25 64,000 176,500 173,500 Gross Margin Operating Expenses 29 30 Commissions (variable) Shipping (variable) 21,000 A. Multiply the HIGHEST digit entered above ? Multiply the HIGHEST digit entered above above by 1,000 and enter here enter the result A. 90,000 35 36 Advertising (fixed) Billing (mixed) Sales and Administrative Salaries (fixed) ? B. Complete Requirement 2 below and insert result 60,000 Total Operating Expenses 38 39 Net Operating Income (Loss) Proj 2 100% 1033 AM Type here to search 7/19/2017 2