please show working as it is excel based

4 This year 6 Sales G H N 1 Stuart Mandfacturing produces metallare from The company's income statements for the last two years are presented below 2 1 Last year 5 Units sold 54.900 79,800 $800,000 $1,120,000 7 Less Cost of goods sold 550.000 720.000 Gross margin 250.000 410,000 9 Lex Operating expenses 150.000 190.000 10 Operating income $100,000 $220,000 11 12. The company has been de ending inventories, therefore cost of goods sold wil equal cost of good manufactured. All activity in this problem is within the company's relevant range of operation 13 14 Regated 15. (a) 10. Using the high-low method estimate the cout formula for TOTAL variable cost per unit and as TOTAL, fixed costs (Remember that this is a manufacturing firm) 17 18 19 TOTAL variable cost per unit 20 TOTAL fixed costs 21 22 bi 24 Calculate the total contribuon main for this year 25