O E 0 000 N B D 02 CVP (CM and BE) Assignment 2 You are provided with the following data for Company A, B, and C. 3 Please answer the questions below by entering a formula into each of the cells marked with a "?" below. 4 5 Data Unit sales Company A Company B Company C 20,000 16,000 26,000 7 Selling price per unit $60 $80 $75 8 Variable expenses per unit $45 $55 $60 9 Fixed expenses $240,000 $100,000 $290,000 10 11 Note: Please enter a formula into each of the cells marked with a "?" below. 12 Do not add or delete rows/columns 13 14 a) Compute the CM ratio and variable expense ratio. Company A Company B Company C 15 Selling price per unit ? ? ? 16 Variable expenses per unit ? 2 ? 12 Contribution margin per unit 2 ? ? 18 19 CM ratio 20 Variable expense ratio 21 22 b) Compute the break-even point. Company A Company B Company C 23 Break-even point in units ? ? ? 24 Break-even point in dollars ? ? 2 25 26 c) Compute the net operating income. Company A Company B Company C 27 Sales ? ? ? 28 Variable expenses ? ? 2 29 Contribution margin ? ? ? 30 Fixed expenses ? 2 ? 31 Net operating income ? ? ? 32 33 d) Create a 3D chart titled "Net Operating Income" for Companies A, B, and C. 34 Company A Company B Company C 35 Net operating income ? ? 36 To create a 3D chart 38 Select "Insert," then 3D Column." Please include the 3D chart below this line 37