Question: F G H Please complete the assignment in the shaded cells below. Be sure to use (and show) Excel formulas to obtain full points! Laura's

F G H Please complete the assignment in the shaded cells below. Be sure to use (and show) Excel formulas to obtain full points! Laura's Restaurant Profit/Loss Forecast Revenue Forecast S 900,000 $ 1,000,000 $ 1,100,000 $ 1,200,000 Cost Forecast Variable costs S 585,000 Fixed costs 350,000 Total costs 935,000 Pre-tax Profit/Loss A. What will be Laura's pre-tax profit/loss if she achieves sales of $900,000 next year? B. What is Laura's forecasted break-even point for next year? C. What will be taura's pre-tax profit/loss if she achieves sales of $1,200,000 next year
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
