Fire Fountain Grille

Start your own business plan »

Steak Restaurant Business Plan

Appendix

Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales
Food 0% $0 $0 $0 $0 $0 $163,188 $144,048 $154,627 $135,464 $138,591 $138,591 $183,844
Beverage 0% $0 $0 $0 $0 $0 $7,582 $6,903 $7,155 $4,956 $5,133 $5,133 $6,726
Liquor 0% $0 $0 $0 $0 $0 $9,127 $7,911 $8,439 $7,764 $7,955 $7,955 $10,739
Beer 0% $0 $0 $0 $0 $0 $12,677 $11,646 $12,517 $10,308 $11,018 $11,018 $14,617
Wine 0% $0 $0 $0 $0 $0 $8,024 $6,460 $6,060 $6,707 $8,401 $8,401 $8,272
Total Sales $0 $0 $0 $0 $0 $200,598 $176,968 $188,798 $165,199 $171,098 $171,098 $224,198
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Food $0 $0 $0 $0 $0 $59,500 $52,500 $56,000 $47,600 $47,850 $46,400 $49,856
Beverage $0 $0 $0 $0 $0 $514 $468 $485 $336 $348 $348 $456
Liquor $0 $0 $0 $0 $0 $1,315 $1,139 $1,215 $1,052 $1,011 $943 $1,274
Beer $0 $0 $0 $0 $0 $2,471 $2,270 $2,439 $1,921 $2,054 $1,960 $2,601
Wine $0 $0 $0 $0 $0 $1,566 $1,478 $1,386 $1,477 $1,780 $1,566 $1,542
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $65,366 $57,855 $61,525 $52,386 $53,043 $51,217 $55,729
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Production Personnel
Assistant Chef $0 $0 $0 $0 $0 $300 $240 $240 $240 $240 $240 $250
Lead Cook/Grill $0 $0 $0 $0 $0 $1,700 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440
Grill Two $0 $0 $0 $0 $0 $700 $580 $580 $580 $580 $580 $580
Broiler Cook One $0 $0 $0 $0 $0 $1,600 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440
Broiler Cook Two $0 $0 $0 $0 $0 $700 $580 $580 $580 $580 $580 $580
Fry Cook One $0 $0 $0 $0 $0 $1,400 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Fry Cook Two $0 $0 $0 $0 $0 $700 $600 $600 $600 $600 $600 $600
Wheel Man One $0 $0 $0 $0 $0 $700 $600 $600 $600 $600 $600 $600
Wheel Man Two $0 $0 $0 $0 $0 $500 $380 $380 $380 $380 $380 $380
Salad Cook One $0 $0 $0 $0 $0 $1,400 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Salad Cook Two $0 $0 $0 $0 $0 $700 $600 $600 $600 $600 $600 $600
Prep Cook One $0 $0 $0 $0 $0 $1,300 $1,160 $1,160 $1,160 $1,160 $1,160 $1,160
Prep Cook Two $0 $0 $0 $0 $0 $1,300 $1,160 $1,160 $1,160 $1,160 $1,160 $1,160
Prep Cook Three $0 $0 $0 $0 $0 $1,300 $1,160 $1,160 $1,160 $1,160 $1,160 $1,160
Dish One $0 $0 $0 $0 $0 $1,200 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040
Dish Two $0 $0 $0 $0 $0 $750 $600 $600 $600 $600 $600 $600
Subtotal $0 $0 $0 $0 $0 $16,250 $13,980 $13,980 $13,980 $13,980 $13,980 $13,990
Sales and Marketing Personnel
One (1) Floor Supervisor $0 $0 $0 $0 $0 $300 $280 $280 $280 $280 $280 $280
One (1) Window Expediter $0 $0 $0 $0 $0 $500 $480 $480 $480 $480 $480 $480
Ten (10) Full-time Servers $0 $0 $0 $0 $0 $4,260 $3,834 $3,834 $3,834 $3,834 $3,834 $3,834
Ten (10) Part-time Servers $0 $0 $0 $0 $0 $2,130 $1,917 $1,917 $1,917 $1,917 $1,917 $1,917
Four (4) Full-time Bartenders $0 $0 $0 $0 $0 $2,500 $2,240 $2,240 $2,240 $2,240 $2,240 $2,240
Two (2) Full-time Hostesses $0 $0 $0 $0 $0 $800 $720 $720 $720 $720 $720 $720
Three (3) Part-time Hostesses $0 $0 $0 $0 $0 $400 $360 $360 $360 $360 $360 $360
Four (4) Bussers $0 $0 $0 $0 $0 $400 $350 $350 $350 $350 $350 $350
Food Runner $0 $0 $0 $0 $0 $500 $500 $500 $500 $500 $500 $500
Subtotal $0 $0 $0 $0 $0 $11,790 $10,681 $10,681 $10,681 $10,681 $10,681 $10,681
General and Administrative Personnel
Managing Partner 1 $0 $0 $0 $0 $0 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Managing Partner 2 $0 $0 $0 $0 $0 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Managing Partner 3 $0 $0 $0 $0 $0 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Managing Partner 4 $0 $0 $0 $0 $0 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Bookkeeper $0 $0 $0 $0 $0 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Subtotal $0 $0 $0 $0 $0 $11,600 $11,600 $11,600 $11,600 $11,600 $11,600 $11,600
Other Personnel
Event by Event Basis TBD $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Event by Event Basis TBD $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $0 $0 $0 $0 $0 $39,640 $36,261 $36,261 $36,261 $36,261 $36,261 $36,271
General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00%
Long-term Interest Rate 11.00% 11.00% 11.00% 11.00% 11.00% 11.00% 11.00% 11.00% 11.00% 11.00% 11.00% 11.00%
Tax Rate 30.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $0 $0 $0 $0 $0 $200,598 $176,968 $188,798 $165,199 $171,098 $171,098 $224,198
Direct Cost of Sales $0 $0 $0 $0 $0 $65,366 $57,855 $61,525 $52,386 $53,043 $51,217 $55,729
Production Payroll $0 $0 $0 $0 $0 $16,250 $13,980 $13,980 $13,980 $13,980 $13,980 $13,990
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $0 $0 $81,616 $71,835 $75,505 $66,366 $67,023 $65,197 $69,719
Gross Margin $0 $0 $0 $0 $0 $118,982 $105,133 $113,293 $98,833 $104,075 $105,901 $154,479
Gross Margin % 0.00% 0.00% 0.00% 0.00% 0.00% 59.31% 59.41% 60.01% 59.83% 60.83% 61.89% 68.90%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $0 $0 $0 $0 $0 $11,790 $10,681 $10,681 $10,681 $10,681 $10,681 $10,681
Operating Supplies $0 $0 $0 $0 $0 $2,000 $1,760 $1,890 $1,650 $1,720 $1,720 $2,200
Janitorial $0 $0 $0 $0 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Repairs $0 $0 $0 $0 $0 $250 $250 $250 $250 $250 $250 $250
Aprons, Towels & Napkins $0 $0 $0 $0 $0 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Menus $0 $0 $0 $0 $0 $150 $150 $150 $150 $150 $150 $150
Miscellaneous Supplies $0 $0 $0 $0 $0 $250 $250 $250 $250 $250 $250 $250
Miscellaneous Purchases $0 $0 $0 $0 $0 $50,000 $250 $250 $250 $250 $250 $250
Complimentary Meals or Drinks For PR $0 $0 $0 $0 $0 $750 $750 $750 $750 $750 $750 $750
Advertising/Promotion $0 $0 $0 $0 $0 $500 $500 $500 $500 $500 $0 $500
Credit Card Charges $0 $0 $0 $0 $0 $1,760 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Fraud Credit Cards/Checks $0 $0 $0 $0 $0 $150 $150 $150 $150 $150 $150 $150
Professional Fees $0 $0 $0 $0 $0 $250 $250 $250 $0 $0 $0 $250
Membership Fees $0 $0 $0 $0 $0 $75 $75 $75 $75 $75 $75 $75
Uniforms $0 $0 $0 $0 $0 $150 $150 $150 $0 $0 $0 $150
Travel $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Employee Discounts $0 $0 $0 $0 $0 $500 $500 $500 $500 $500 $500 $500
Total Sales and Marketing Expenses $0 $0 $0 $0 $0 $71,075 $19,716 $19,846 $19,206 $19,276 $18,776 $20,156
Sales and Marketing % 0.00% 0.00% 0.00% 0.00% 0.00% 35.43% 11.14% 10.51% 11.63% 11.27% 10.97% 8.99%
General and Administrative Expenses
General and Administrative Payroll $0 $0 $0 $0 $0 $11,600 $11,600 $11,600 $11,600 $11,600 $11,600 $11,600
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation ($100) ($100) ($100) ($100) ($100) $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Leased Equipment $0 $0 $0 $0 $0 $150 $150 $150 $150 $150 $150 $150
Utilities $0 $0 $0 $0 $0 $8,000 $7,500 $8,500 $8,000 $8,500 $8,500 $9,000
Amortization $0 $0 $0 $0 $0 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Debt Service $0 $0 $0 $0 $0 $0 $0 $0 $0 . $0 $25,000
Insurance $0 $0 $0 $0 $0 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Excess Insurance $0 $0 $0 $0 $0 $500 $500 $500 $500 $500 $500 $500
Property Taxes $0 $0 $0 $0 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Excess Taxes $0 $0 $0 $0 $0 $500 $500 $500 $500 $500 $500 $500
Vacation Accrual $0 $0 $0 $0 $0 $350 $350 $350 $350 $350 $350 $350
Base Rent $0 $0 $0 $0 $0 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Percentage Rent $0 $0 $0 $0 $0 $2,000 $1,760 $1,887 $1,650 $1,710 $1,710 $2,241
CAM Rent $0 $0 $0 $0 $0 $750 $750 $750 $750 $750 $750 $750
Payroll Taxes 10% $0 $0 $0 $0 $0 $3,964 $3,626 $3,626 $3,626 $3,626 $3,626 $3,627
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses ($100) ($100) ($100) ($100) ($100) $45,314 $44,236 $45,363 $44,626 $45,186 $45,186 $71,218
General and Administrative % 0.00% 0.00% 0.00% 0.00% 0.00% 22.59% 25.00% 24.03% 27.01% 26.41% 26.41% 31.77%
Other Expenses:
Other Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Expansion Fund $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $10,000
Total Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $10,000
Other % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 4.46%
Total Operating Expenses ($100) ($100) ($100) ($100) ($100) $116,389 $63,952 $65,209 $63,832 $64,462 $63,962 $101,374
Profit Before Interest and Taxes $100 $100 $100 $100 $100 $2,593 $41,181 $48,084 $35,001 $39,613 $41,939 $53,105
EBITDA $0 $0 $0 $0 $0 $4,593 $43,181 $50,084 $37,001 $41,613 $43,939 $55,105
Interest Expense $451 $444 $436 $429 $422 $414 $407 $400 $392 $385 $378 $370
Taxes Incurred ($105) ($52) ($50) ($49) ($48) $327 $6,116 $7,153 $5,191 $5,884 $6,234 $7,910
Net Profit ($246) ($292) ($286) ($280) ($273) $1,852 $34,658 $40,532 $29,417 $33,344 $35,327 $44,824
Net Profit/Sales 0.00% 0.00% 0.00% 0.00% 0.00% 0.92% 19.58% 21.47% 17.81% 19.49% 20.65% 19.99%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $0 $0 $0 $0 $0 $200,598 $176,968 $188,798 $165,199 $171,098 $171,098 $224,198
Subtotal Cash from Operations $0 $0 $0 $0 $0 $200,598 $176,968 $188,798 $165,199 $171,098 $171,098 $224,198
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $0 $0 $0 $0 $200,598 $176,968 $188,798 $165,199 $171,098 $171,098 $224,198
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $0 $0 $0 $0 $0 $39,640 $36,261 $36,261 $36,261 $36,261 $36,261 $36,271
Bill Payments $10,012 $347 $392 $386 $379 $7,995 $224,568 $96,396 $113,157 $87,893 $100,059 $97,187
Subtotal Spent on Operations $10,012 $347 $392 $386 $379 $47,635 $260,829 $132,657 $149,418 $124,154 $136,320 $133,458
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $10,812 $1,147 $1,192 $1,186 $1,179 $48,435 $261,629 $133,457 $150,218 $124,954 $137,120 $134,258
Net Cash Flow ($10,812) ($1,147) ($1,192) ($1,186) ($1,179) $152,163 ($84,661) $55,341 $14,981 $46,144 $33,978 $89,940
Cash Balance $569,688 $568,541 $567,349 $566,164 $564,984 $717,148 $632,487 $687,828 $702,809 $748,954 $782,932 $872,872
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $580,500 $569,688 $568,541 $567,349 $566,164 $564,984 $717,148 $632,487 $687,828 $702,809 $748,954 $782,932 $872,872
Inventory $0 $0 $0 $0 $0 $0 $71,903 $63,641 $67,678 $57,625 $58,347 $56,339 $61,302
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $580,500 $569,688 $568,541 $567,349 $566,164 $564,984 $789,050 $696,127 $755,506 $760,434 $807,301 $839,271 $934,174
Long-term Assets
Long-term Assets $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000 $65,000
Accumulated Depreciation $0 ($100) ($200) ($300) ($400) ($500) $1,500 $3,500 $5,500 $7,500 $9,500 $11,500 $13,500
Total Long-term Assets $65,000 $65,100 $65,200 $65,300 $65,400 $65,500 $63,500 $61,500 $59,500 $57,500 $55,500 $53,500 $51,500
Total Assets $645,500 $634,788 $633,741 $632,649 $631,564 $630,484 $852,550 $757,627 $815,006 $817,934 $862,801 $892,771 $985,674
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable $10,000 $334 $379 $373 $367 $361 $221,375 $92,594 $110,241 $84,552 $96,875 $92,318 $141,197
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Subtotal Current Liabilities $20,000 $10,334 $10,379 $10,373 $10,367 $10,361 $231,375 $102,594 $120,241 $94,552 $106,875 $102,318 $151,197
Long-term Liabilities $50,000 $49,200 $48,400 $47,600 $46,800 $46,000 $45,200 $44,400 $43,600 $42,800 $42,000 $41,200 $40,400
Total Liabilities $70,000 $59,534 $58,779 $57,973 $57,167 $56,361 $276,575 $146,994 $163,841 $137,352 $148,875 $143,518 $191,597
Paid-in Capital $900,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000 $900,000
Retained Earnings ($324,500) ($324,500) ($324,500) ($324,500) ($324,500) ($324,500) ($324,500) ($324,500) ($324,500) ($324,500) ($324,500) ($324,500) ($324,500)
Earnings $0 ($246) ($538) ($824) ($1,103) ($1,377) $475 $35,133 $75,665 $105,082 $138,426 $173,753 $218,577
Total Capital $575,500 $575,254 $574,962 $574,676 $574,397 $574,123 $575,975 $610,633 $651,165 $680,582 $713,926 $749,253 $794,077
Total Liabilities and Capital $645,500 $634,788 $633,741 $632,649 $631,564 $630,484 $852,550 $757,627 $815,006 $817,934 $862,801 $892,771 $985,674
Net Worth $575,500 $575,254 $574,962 $574,676 $574,397 $574,123 $575,975 $610,633 $651,165 $680,582 $713,926 $749,253 $794,077