pls helpThank you. if you could compress the document so i can see it. I have chegg on my phone so if the document is large i can only see half. Thank you. pls use excel and explain the formula. im sorry im asking for alot .

Product Line Elimination Quiet Feet Inc, produces three different types of shoes. Complete the below contribution margin income statement for each product line. Allocate total fixed costs to each shoe type based on units as a percent of total unitsie. use units sold as the cost driver) Boots Sandals Relevant? Sales units) 6,000 15,000 4,000 25,000 Price 50,00 25.00 5 5.00 Sneakers Total $ 180.000 300.000 26,000 504,000 Sales revenue Variable costs Contribution margin Fixed costs all allocated) Operating income 113,300 HH ME What is operating income if Quiet Feet Inc, stopped selling Boots? What is operating income if Quiet Feet Inc, stopped selling Sneakers? What is operating income if Qulet Feet Inc. stopped selling Sandals? What product line (if any should Golet Feet Ine. stop producing? Dropdown lists: Yes No Manufacture Outsource None Boots Sneakers Sandals Boots & Sneakers Boots & Sandals