Income Statement Sales Cost of Goods Sold Food Cost Labor Total Prime Costs Gross Margin Other Operating Expenses SG&A Dep & Amort Utilities Rent Maintenance Total Other Operating Expenses Operating Profit (EBIT) EBITDA ASSUMPTIONS Seats Average Check S 200 20.00 Days per Month 30 Avg Table Turns 1.25 Food Cost % FT Employees 33.0% Month 1 % Number Salary 13 $ 50,000 per yr CEO Number 1 Salary S 100,000 per yr PT Employees Number 20 Wage S 7.00 per hr Days/Mo 20 Hrs/Day 8 Utilities $ 3,000 per mo Rent S 10,000 per mo D&A $ 50,000 per yr Maintenance 1% of sales INTERMEDIATE CALCULATIONS Labor FT PT Covers Daily Monthly Covers per Day Table Turns $ 14.00 $ 16.00 0.75 x $10.50 $12.00 1.00 x $ 14.00 1.25 x $ 16.00 $17.50 Average Check $ 18.00 $20.00 $ 22.00 $ 24.00 $13.50 $ 15.00 $ 16.50 $ 18.00 $ 18.00 $ 20.00 $ 22.00 $ 24.00 $ 20.00 $ 22.50 $ 25.00 $27.50 $ 30.00 $ 27.00 $ 30.00 $ 33.00 $ 31.50 $ 35.00 $ 38.50 $ 36.00 $ 40.00 $ 44.00 1.50 x $21.00 $ 24.00 1.75 x $24.50 $ 28.00 2.00 x $28.00 $ 32.00 DIRECTIONS - Use Formula's to fill in calculations for the grey cells Blue numbers are given amounts Use Calcualtions! Do NOT hard code numbers that can be calcualted by Excel in the cell $ 36.00 $ 42.00 1.5 4.5 $ 48.00 6.75 Average Check