prepare in excel sheet

Arthur Nery - Pag. 1) Contribution margin, gross margin, and margin of safety Mirabel Cosmetics manufactures and sells a face cream to small family-run store in Montreal area. It presents the monthly operating statement of comprehensive income shown here: Mirabel Cosmetics Statement of Operating Income For the Month of June Units Sold 10,000 Revenue $100,000 Cost of Goods Sold Variable Manufacturing Costs $55,000 Fixed Manufacturing Costs 20,000 Total 75,000 Gross Margin 25,000 Operating Costs Variable Marketing Costs $ 5,000 Fixed Marketing & Administration Costs 10,000 Total Operating Costs 15,000 Operating Income $ 10,000 Required: 1. Recast the statement of comprehensive income to emphasize contribution margin 2. Calculate the contribution margin percentage and breakeven point in units and revenue for June 2019 3. What is the margin of safety (in units) for June 2019