Need the answers before 8pm!! please add the cell reference as the calculs explanation!!

B D E F 1 Operating data for Siesta Company and its absorption costing income statements for 2 the last two years are presented below: 3 a) V 4 5 Year 1 Year 2 7 Units in beginning inventory Units produced Units sold 2,000 14,000 15,000 1,000 14,000 12,000 9 10 $ 240,000 $ 320,000 T b) 11 12 13 14 15 Sales Cost of Goods Sold Beginning inventory Add: Cost of Goods Manufactured Goods available for sale Less: Ending inventory Cost of Goods Sold Gross margin Selling and administrative expenses Operating income 23,194 162,360 185,554 11,597 173,957 66,043 89,000 (22,957) $ 11,597 162,360 173,957 34,791 139,166 180,834 81,200 99,634 Tu 16 17 18 $ 19 20 A EF 16 17 18 B Cost of Goods Sold Gross margin Selling and administrative expenses Operating income 173,957 66,043 89,000 (22,957) $ 139,166 180,834 81,200 99,634 $ ga 19 20 21 22 23 24 25 26 Fixed manufacturing overhead Direct material per unit Direct labour per unit Variable Manufacturing overhead per unit Variable Selling & Admin costs per unit $ $ $ $ 62,400 $ 2.00 $ 3.00 $ 2.14 $ 2.60 $ 62,400 2.00 3.00 2.14 2.60 29 30 31 c) F G H Required: a) What was the unit product cost in each year under variable costing Year 1 Year 2 Total unit product cost b) Prepare new income statements for each year using variable costing. Siesta Company H EF G b) Prepare new income statements for each year using variable costing Siesta Company Variable Costing Income Statement Year 1 Year 2 Sales Less: Variable expenses Contribution margin Operating income (loss) c) Reconcile the difference in Operating Income between variable costing and absorption costing EF G H Reconcile the difference in Operating Income between variable costing and absorption costing Variable costing operating income Absorption costing operating income