Sec used to calculate some variables ter the last 4 digits of your student ID number wpe your answers on this excel sheet and print it out for submission, Pleuraho submit an actronic copy to the instructer' These digits will found 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 enume that Ashton Compeny sells all units it prodeduces Requirement 1: Replace the two unknown amounts in A and B as directed. To find the unknown for you will hav 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 unit Cost of Goods Seld Direct materials able 24 Direct labor (variabi 25 Manufacturing Overhead mixed) 26 27 Gross Margin 28 35 $450,000 $90,000 78,300 38.500 26.800 183,200 Operating Expens Comme Shipping Aveng Sales and Adminis Total Operating Exper Net Operating Inte Requirement 2 Billing cos 27,000 58,900.00 A. Multiply the HIGHEST dit hom the y 1,000 and enter thes 100000 40.000.000&Complete Requirement 2 below and in 40,000 400000