please show working as it is excel based

J 135,874 A A B B C E F G G H | 1 Operating data for Siesta Company and its absorption costing income statements for Required: 2 the last two years are presented below: a) What was the unit product cost in each year under variable costing 3 3 4 4 5 Year 1 Year 2 Year 1 Year 2 b Units in beginning inventory 2,000 1,000 7 Units produced 14,000 14,000 8 Units sold 15,000 12,000 9 10 Sales $ 240,000 $ 320,000 Total unit product cost 11 Cost of Goods Sold 12 Beginning inventory 22,646 11,323 b) Prepare new income statements for each year using variable costing. 13 Add: Cost of Goods Manufactured 158,520 158,520 Siesta Company 14 Goods available for sale 181,166 169,843 Variable Costing Income Statement 15 Less: Ending inventory 11,323 33,969 Year 1 Year 2 16 Cost of Goods Sold 169,843 Sales 11 Gross margin 70,157 184,126 Less: Variable expenses 18 Selling and administrative expenses 89,000 81,200 19 Operating income $ (18,843) $ ) 102,926 20 21 22 Fixed manufacturing overhead $ 60,800 $ 60,800 23 Direct material per unit $ 2.00 $ 2.00 24 Direct labour per unit $ 3.00 $ 3.00 25 Variable Manufacturing overhead per unit $ 1.98 $ 1.98 Contribution margin 26 Variable Selling & Admin costs per unit $ 2.60 $ 2.60 27 28 29 Operating income (loss) 30 31 c) Reconcile the difference in Operating Income between variable costing and absorption costing 32 33 Variable costing operating income 34 35 36 37 38 39 Absorption costing operating income 40