Question: D 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
D 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 $ 900,000 $ 1,000,000 $1,100,000 $ 1,200,000 Cost Forecast Variable costs $ 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? 8. What is Laura's forecasted break-even point for next year? C. What will be Laura'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
