S.BARRETT AC306_A2 2+ Share oDoo = Home Insert Page Layout Formulas fx . . 2A Insert AutoSum Recently Financial Logical Text Function Data O Review 9 View 0 . Define Name Creata from Selection Trace Precedents Trace Dependents 1 Show Error Formulas Checking T. Calculation Calculate Now Calculate Sheet Data & Time Lookup & Math & Reference Trg More Functions Used Remove Arrows Options 1 Enter titles, accounts and comments in the green cells Enter Numbers in the blue cells Enter your calculations in the yellow cells Unit 2 Cost Volume Profit le Farge owns Fargo Quid tube and do wants to know what is monthly break even sales are and what is Margin of Safety Ratio is. On average Fargo's Quick Lube performs 450 total services at an average cost of $50 each. Monthly Red costs are 11,200 Variable costs were son of sales 1 Calculate the contribution margin 2 Calculate the contribution margin ratio 3 Calculate the break even in units and in sales $ 4 Prepare a CVP Income Statement 5 Calculate the margin of safety 6 Comment on Bender's profitablity given the information that you have calculated Per Unit i 3 Break Even in Units Fleed Corts Contributin Margin per un Units Sales Variable Costs Contribution margin Combat Margin Rate Break even in Sales Makes Fhed Costs Contribution Margheratie CVP Income Stmt Total Units Resources Problem 1 Problem 2 Problem 3 Problem 4 + Ready E B - 90% 900098-11-07TOO@A@O 1:10? MacBook Pro 30. 888 A * AO More Functions Create from Selection Trace Dependents Remove Arrows Show Formulas Insert Function ASI A 2 AutoSum Recently Financial Logical Text Date & Lookup & Math & Used Time Reference Trig X v for B C D E F CVP Income Stmt Total # Units Sales $ Variable costs $ Contribution Margin $ Fbxed Costs $ Net Income $ Margin of Safety % Acutal Sales 22,500 Break Even sales Margin of Safety 22,500 Margin of Safety Acutal sales 100.00% Margin of Safety Ratio 22,500 22,500 - 6 Comment on Fargo's operations and profitability Resources Problem 1 Problem 2 Problem 3 Problem 4 > Ready ECA