This is an excel assignment, so please show formulas if possible

0 - ZOOM 02 CVP (CM and BE) Assignment You are provided with the following data for Company A, B, and C. Please answer the questions below by entering a formula into cach of the cells marked with a "?" below. Data Company A Company B Unit salos 20,000 16,000 Selling price per unit $60 $80 Variable expenses per unit $45 $55 Fixed expenses $240,000 $100,000 Note: Please enter a formule into each of the cells marked with a "?" below 7. Do not add or delete rows/columns. Company C 26,000 $75 $60 $290,000 Company A Company B Company C a) Compute the CM ratio and variable expense ratio. Selling price per unit Variable expenses per unit Contribution margin per unit ? ? ? CM ratio Variable expense ratio ? b) Compute the break-even point. Break-even point in units Break-even point in dollars Company A Company B ? ? ? 2 Company C ? Company C ? c) Compute the net operating income. Sales Variable exponses Contribution margin Fixed expenses Nel operaling income Company A Company B ? 2 ? 2 ? 7 2 2 ? ? ? ? Company C 2 d) Create a 3D chart titled "Net Operating Income for Companies A, B, and C. Company A Company Net operating income ? ? Pa 1 To create a 3D chart: Select "Insert," then 3D Column." Please include the 3D chart below this line