Name: Enter the last 4 digits of your student ID number: 5 (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. Presented below is Ashton Company's Income Statement prepared using absorption costing: (Please assume that Ashton Company sells all units it prododuces) 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. Ashton Company Income Statement For the Year Ended December 31, 2013 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) Advertising (fixed) $450,000 $90,000 78,300 98,500 266,800 183,200 27,000 6,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 Billing (mixed) Sales and Administrative salaries Total Operating Expenses Net Operating Income (Loss) 199,500.00 $ (16,300.00) 40 Requirement 2: Billing costs for the past 5 years along with total units sold follows: Year Sales in Units Billing Costs 2012 47,500 $ 6,750 2011 44,000 $ 6,300 AALR ASANA 1