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?

Transcribed Image Text:

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 $ Cost Forecast Variable costs Fixed costs Total costs Pre-tax Profit/Loss $ ss $ $ 900,000 $ 1,000,000 $1,100,000 $ 1,200,000 585,000 350,000 935,000 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 $ Cost Forecast Variable costs Fixed costs Total costs Pre-tax Profit/Loss $ ss $ $ 900,000 $ 1,000,000 $1,100,000 $ 1,200,000 585,000 350,000 935,000

Answer rating: 100% (QA)

A To determine Lauras pretax profitloss if she achieves sales of 900000 next year we need to first c... View the full answer