Income Statement

Month $1\%$

Sales Average Check DIRECTIONS $-$ Use Formula's to fill in calculations for the grey cells

Cost of Goods Sold Table Turns $$14\mathrm{.}00$ $$16\mathrm{.}00$ $$18\mathrm{.}00$ $$20\mathrm{.}00$ $$22\mathrm{.}00$ $$24\mathrm{.}00$ Blue numbers are given amounts

Food Cost $0\mathrm{.}75$ x Use Calcualtions! Do NOT hard code numbers that can be calcualted by Excel in the cell

Labor $1\mathrm{.}00$ x

Total Prime Costs $1\mathrm{.}25$ x

$1\mathrm{.}50$ x

Gross Margin $1\mathrm{.}75$ x

$2\mathrm{.}00$ x

Other Operating Expenses

SG&A

Dep & Amort

Utilities Average Check

Rent Covers per Day

Maintenance

Total Other Operating Expenses

Operating Profit $($EBIT$)$

EBITDA

ASSUMPTIONS

Seats $200$

Average Check $$20\mathrm{.}00$

Days per Month $30$

Avg Table Turns $1\mathrm{.}25$

Food Cost $\%33\mathrm{.}0\%$

FT Employees

Number $13$

Salary $$50,000$ per yr

CEO

Number $1$

Salary $$100,000$ per yr

PT Employees

Number $20$

Wage $$7\mathrm{.}00$ per hr

Days$/$Mo $20$

Hrs$/$Day $8$

Utilities $$3,000$ per mo

Rent $$10,000$ per mo

D&A $$50,000$ per yr

Maintenance $1\%$ of sales

FT

PT

Daily

Monthly