P$13\mathrm{.}3$

Pro$-$forma Income Statement

Food sales revenue

Monday through Saturday:

Lunch

Dinner

Sunday Dinner

Banquets:

Total food sales revenue $$0$

Beverage sales revenue

Lunch

Dinner $$0$

Banquets

Total beverage revenue $$0$

Total Sales Revenue $$0$

Operating expenses

Food cost

Beverage cost

Wages

Benefits

Other expenses

Overhead costs

Total expenses $$0$

Operating Income $($BT$)$ $$0$

Complete problem P$13\mathrm{.}3$

Also, answer the following question: How important is the estimated food cost to the pro$-$forma? If food costs rise to $45\%$ is the business viable?

fill in the areas with $$0\mathrm{.}00$ with hypothetical numbers to make the statement work

please set it up in a excel sheet format