New Zoom Add Category Insert Table Chart Text Shape Media Comment CVP Project Mr PRUJELI LVP ANALT33 Name: Chase Calloway H Sec Enter the last 4 digits of your student ID number: (These digits will be used to calculate some variables) Type your answers on this excel sheet and print it out for submission. Please also submit an elctronic copy to the instructor's email. Round all answers to 2 decimal places. Do not change rows or colums on this spreadsheet. Input areas are in yellow. 2 Presented below is Ashton Company's Income Statement prepared using absorption costing 13 (Please assume that Ashton Company sells all units it prododuces) 14 Requirement 1: Replace the two unknown amounts (?) in A. and B. as directed. To find the unknown for B, you will have to complete Requirement 2. Then, complete the totals on the income statement. 15 16 17 Ashton Company Income Statement For the Year Ended December 31, 2013 20 21 Sales (45,000 units) Cost of Goods Sold Direct materials (variable) Direct labor (variable) Manufacturing Overhead (mixed) Gross Margin Operating Expenses Commissions (variable) Shipping (variable) 33 34 $450,000 $90,000 78,300 98,500 266,800 183,200 27,000 1 M Colla Advertising (fixed] Billing (mixed) Sales and Administrative salaries 7,000.00 A. Multiply the HIGHEST digit from the last four digits of your student ID entered above by 1,000 and enter the result here 100,000 6,500.00 B.Complete Requirement 2 below and insert result 60,000 35 Total Operating Expenses 200,500.00 CO 37 30 Net Operating Income (Loss) C30 40 Requirement 2: line costs for the.nast Swear alone with total units sold follows Yeat Sales in inits Iniline Couts 22 dtv