Full of Bologna

Start your own business plan »

Italian Renaissance Theme 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
Unit Sales
Lunch Sales 0% 0 0 0 0 0 600 5,850 5,850 5,850 5,850 5,850 5,850
Dinner Sales 0% 0 0 0 0 0 0 5,850 5,850 3,900 3,900 3,900 3,900
Gift Shop Item Sales 0% 0 0 0 0 0 0 180 180 180 180 180 180
Web Shop Sales 0% 0 0 0 0 0 6 20 25 25 25 25 25
Catering Sales 0% 0 0 0 0 0 0 1 1 1 1 1 1
Liquor Sales 0% 0 0 0 0 0 0 2,330 2,330 1,940 1,940 1,940 1,940
Wine Bottle Sales 0% 0 0 0 0 0 0 240 240 240 240 240 240
Wine by the Glass Sales 0% 0 0 0 0 0 0 2,050 2,050 1,450 1,450 1,450 1,450
Beer Sales 0% 0 0 0 0 0 0 2,770 2,770 2,380 2,380 2,380 2,380
Chef's Table in the Vault Sales 0% 0 0 0 0 0 0 15 15 15 15 15 15
Total Unit Sales 0 0 0 0 0 606 19,306 19,311 15,981 15,981 15,981 15,981
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Lunch Sales $10.50 $10.50 $10.50 $10.50 $10.50 $10.50 $10.50 $10.50 $10.50 $10.50 $10.50 $10.50
Dinner Sales $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00
Gift Shop Item Sales $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00
Web Shop Sales $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00
Catering Sales $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00
Liquor Sales $4.50 $4.50 $4.50 $4.50 $4.50 $4.50 $4.50 $4.50 $4.50 $4.50 $4.50 $4.50
Wine Bottle Sales $16.00 $16.00 $16.00 $16.00 $16.00 $16.00 $16.00 $16.00 $16.00 $16.00 $16.00 $16.00
Wine by the Glass Sales $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00
Beer Sales $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00 $3.00
Chef's Table in the Vault Sales $520.00 $520.00 $520.00 $520.00 $520.00 $520.00 $520.00 $520.00 $520.00 $520.00 $520.00 $520.00
Sales
Lunch Sales $0 $0 $0 $0 $0 $6,300 $61,425 $61,425 $61,425 $61,425 $61,425 $61,425
Dinner Sales $0 $0 $0 $0 $0 $0 $117,000 $117,000 $78,000 $78,000 $78,000 $78,000
Gift Shop Item Sales $0 $0 $0 $0 $0 $0 $1,080 $1,080 $1,080 $1,080 $1,080 $1,080
Web Shop Sales $0 $0 $0 $0 $0 $36 $120 $150 $150 $150 $150 $150
Catering Sales $0 $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Liquor Sales $0 $0 $0 $0 $0 $0 $10,485 $10,485 $8,730 $8,730 $8,730 $8,730
Wine Bottle Sales $0 $0 $0 $0 $0 $0 $3,840 $3,840 $3,840 $3,840 $3,840 $3,840
Wine by the Glass Sales $0 $0 $0 $0 $0 $0 $8,200 $8,200 $5,800 $5,800 $5,800 $5,800
Beer Sales $0 $0 $0 $0 $0 $0 $8,310 $8,310 $7,140 $7,140 $7,140 $7,140
Chef's Table in the Vault Sales $0 $0 $0 $0 $0 $0 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800
Total Sales $0 $0 $0 $0 $0 $6,336 $220,260 $220,290 $175,965 $175,965 $175,965 $175,965
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Lunch Sales 32.00% $3.36 $3.36 $3.36 $3.36 $3.36 $3.36 $3.36 $3.36 $3.36 $3.36 $3.36 $3.36
Dinner Sales 33.00% $6.60 $6.60 $6.60 $6.60 $6.60 $6.60 $6.60 $6.60 $6.60 $6.60 $6.60 $6.60
Gift Shop Item Sales 48.00% $1.92 $1.92 $1.92 $1.92 $1.92 $1.92 $1.92 $1.92 $1.92 $1.92 $1.92 $1.92
Web Shop Sales 45.00% $1.92 $1.92 $1.92 $1.92 $1.92 $1.92 $1.92 $1.92 $1.92 $1.92 $1.92 $1.92
Catering Sales 34.00% $640.00 $640.00 $640.00 $640.00 $640.00 $640.00 $640.00 $640.00 $640.00 $640.00 $640.00 $640.00
Liquor Sales 20.00% $1.44 $1.44 $1.44 $1.44 $1.44 $1.44 $1.44 $1.44 $1.44 $1.44 $1.44 $1.44
Wine Bottle Sales 30.00% $5.12 $5.12 $5.12 $5.12 $5.12 $5.12 $5.12 $5.12 $5.12 $5.12 $5.12 $5.12
Wine by the Glass Sales 20.00% $1.28 $1.28 $1.28 $1.28 $1.28 $1.28 $1.28 $1.28 $1.28 $1.28 $1.28 $1.28
Beer Sales 20.00% $0.96 $0.96 $0.96 $0.96 $0.96 $0.96 $0.96 $0.96 $0.96 $0.96 $0.96 $0.96
Chef's Table in the Vault Sales 35.00% $182.00 $182.00 $182.00 $182.00 $182.00 $182.00 $182.00 $182.00 $182.00 $182.00 $182.00 $182.00
Direct Cost of Sales
Lunch Sales $0 $0 $0 $0 $0 $2,016 $19,656 $19,656 $19,656 $19,656 $19,656 $19,656
Dinner Sales $0 $0 $0 $0 $0 $0 $38,610 $38,610 $25,740 $25,740 $25,740 $25,740
Gift Shop Item Sales $0 $0 $0 $0 $0 $0 $346 $346 $346 $346 $346 $346
Web Shop Sales $0 $0 $0 $0 $0 $12 $38 $48 $48 $48 $48 $48
Catering Sales $0 $0 $0 $0 $0 $0 $640 $640 $640 $640 $640 $640
Liquor Sales $0 $0 $0 $0 $0 $0 $3,355 $3,355 $2,794 $2,794 $2,794 $2,794
Wine Bottle Sales $0 $0 $0 $0 $0 $0 $1,229 $1,229 $1,229 $1,229 $1,229 $1,229
Wine by the Glass Sales $0 $0 $0 $0 $0 $0 $2,624 $2,624 $1,856 $1,856 $1,856 $1,856
Beer Sales $0 $0 $0 $0 $0 $0 $2,659 $2,659 $2,285 $2,285 $2,285 $2,285
Chef's Table in the Vault Sales $0 $0 $0 $0 $0 $0 $2,730 $2,730 $2,730 $2,730 $2,730 $2,730
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $2,028 $71,887 $71,897 $57,323 $57,323 $57,323 $57,323
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
Manager Day 0% $0 $0 $0 $0 $0 $0 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Manager Night 0% $0 $0 $0 $0 $0 $0 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Manager Lounge/Bar 0% $0 $0 $0 $0 $0 $0 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Wait Staff day & night - 16 x 40 hrs x 4.00 p/hr 0% $0 $0 $0 $0 $0 $1,280 $2,560 $2,560 $2,560 $2,560 $2,560 $2,560
Dishwasher - 2 x 40 hrs x 7.00 p/hr 0% $0 $0 $0 $0 $0 $280 $2,240 $2,240 $2,240 $2,240 $2,240 $2,240
Cooks - 2 day & 3 night = 7 x 40 hrs x 10.00 p/hr 0% $0 $0 $0 $0 $0 $2,800 $11,200 $11,200 $11,200 $11,200 $11,200 $11,200
Bartenders - 4 flex x 40 hrs x 2.50 p/hr 0% $0 $0 $0 $0 $0 $400 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Executive Chef 0% $0 $0 $0 $0 $0 $4,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $0 $0 $0 $0 $0 $8,760 $32,600 $32,600 $32,600 $32,600 $32,600 $32,600
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 $6,336 $220,260 $220,290 $175,965 $175,965 $175,965 $175,965
Direct Cost of Sales $0 $0 $0 $0 $0 $2,028 $71,887 $71,897 $57,323 $57,323 $57,323 $57,323
Staff Meals $0 $0 $0 $0 $0 $400 $400 $400 $400 $400 $400 $400
Other Costs of Goods/DESCOMM/Bank $0 $0 $0 $0 $0 $0 $5,000 $5,000 $3,500 $3,500 $3,500 $3,500
Total Cost of Sales $0 $0 $0 $0 $0 $2,428 $77,287 $77,297 $61,223 $61,223 $61,223 $61,223
Gross Margin $0 $0 $0 $0 $0 $3,908 $142,973 $142,993 $114,742 $114,742 $114,742 $114,742
Gross Margin % 0.00% 0.00% 0.00% 0.00% 0.00% 61.69% 64.91% 64.91% 65.21% 65.21% 65.21% 65.21%
Expenses
Payroll $0 $0 $0 $0 $0 $8,760 $32,600 $32,600 $32,600 $32,600 $32,600 $32,600
Marketing/Promotion $0 $0 $0 $0 $0 $10,000 $10,000 $10,000 $5,000 $5,000 $5,000 $5,000
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Employee Healthcare $0 $0 $0 $0 $0 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Rent $0 $0 $0 $0 $0 $0 $1,500 $2,000 $2,500 $3,000 $3,500 $4,000
Utilities and Security Services $0 $0 $0 $500 $1,000 $3,600 $3,600 $3,600 $2,600 $2,600 $2,600 $2,600
Ceramic, Glass and Silver Upkeep $0 $0 $0 $0 $0 $0 $0 $200 $200 $200 $200 $200
Accounting Fees $0 $0 $0 $0 $0 $0 $400 $400 $400 $400 $400 $500
Manager Comps & Grease Handouts $0 $0 $0 $0 $0 $0 $5,000 $2,500 $2,500 $2,500 $2,500 $2,500
Dues and Subscriptions $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $600 $0
Legal Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Flowers $0 $0 $0 $0 $0 $0 $400 $400 $400 $400 $400 $400
Travel Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Exterminating $0 $0 $0 $0 $0 $0 $25 $25 $25 $25 $25 $25
Fines and Penalties $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $100
Payroll Processing $0 $0 $0 $0 $190 $60 $60 $60 $60 $60 $60 $60
Insurance, Licensure & RE Taxes $0 $0 $0 $0 $0 $700 $700 $700 $700 $700 $700 $700
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Maintenance Costs/Repairs $0 $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Linen and Dry Cleaning $0 $0 $0 $0 $0 $175 $175 $175 $150 $150 $150 $150
Computer Upkeep/Upgrade $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dish and Cleaning Supplies $0 $0 $0 $0 $0 $0 $400 $400 $400 $400 $400 $400
Office Products Upkeep 15% $0 $0 $0 $0 $0 $0 $200 $200 $200 $200 $200 $200
Paper Product Deliveries $0 $0 $0 $0 $0 $0 $800 $800 $800 $800 $800 $800
Total Operating Expenses $0 $0 $0 $500 $1,190 $26,295 $60,860 $59,060 $53,535 $54,035 $55,135 $55,235
Profit Before Interest and Taxes $0 $0 $0 ($500) ($1,190) ($22,387) $82,113 $83,933 $61,207 $60,707 $59,607 $59,507
EBITDA $0 $0 $0 ($500) ($1,190) ($22,387) $82,113 $83,933 $61,207 $60,707 $59,607 $59,507
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 ($150) ($357) ($6,716) $24,634 $25,180 $18,362 $18,212 $17,882 $17,852
Net Profit $0 $0 $0 ($350) ($833) ($15,671) $57,479 $58,753 $42,845 $42,495 $41,725 $41,655
Net Profit/Sales 0.00% 0.00% 0.00% 0.00% 0.00% -247.33% 26.10% 26.67% 24.35% 24.15% 23.71% 23.67%
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 $6,336 $220,260 $220,290 $175,965 $175,965 $175,965 $175,965
Subtotal Cash from Operations $0 $0 $0 $0 $0 $6,336 $220,260 $220,290 $175,965 $175,965 $175,965 $175,965
Additional Cash Received
Sales Tax, VAT, HST/GST Received 6.00% $0 $0 $0 $0 $0 $380 $13,216 $13,217 $10,558 $10,558 $10,558 $10,558
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 $1,000 $1,000 $1,000 $1,000 $1,100 $1,200 $1,400 $1,300 $1,300
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 $1,000 $1,000 $7,716 $234,476 $234,607 $187,723 $187,923 $187,823 $187,823
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 $8,760 $32,600 $32,600 $32,600 $32,600 $32,600 $32,600
Bill Payments $0 $0 $0 $12 $366 $1,179 $15,055 $126,390 $127,870 $97,010 $100,896 $101,642
Subtotal Spent on Operations $0 $0 $0 $12 $366 $9,939 $47,655 $158,990 $160,470 $129,610 $133,496 $134,242
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $0 $0 $0 $12 $366 $9,939 $47,655 $158,990 $160,470 $129,610 $133,496 $134,242
Net Cash Flow $0 $0 $0 $988 $634 ($2,223) $186,820 $75,618 $27,252 $58,313 $54,327 $53,581
Cash Balance $40,000 $40,000 $40,000 $40,988 $41,622 $39,399 $226,220 $301,837 $329,090 $387,403 $441,730 $495,311
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 $40,000 $40,000 $40,000 $40,000 $40,988 $41,622 $39,399 $226,220 $301,837 $329,090 $387,403 $441,730 $495,311
Inventory $23,878 $23,878 $23,878 $23,878 $23,878 $23,878 $21,851 $17,972 $17,974 $14,331 $14,331 $14,331 $14,331
Other Current Assets $0 $0 $0 $0 ($1,000) ($2,000) ($3,000) ($4,000) ($5,100) ($6,300) ($7,700) ($9,000) ($10,300)
Total Current Assets $63,878 $63,878 $63,878 $63,878 $63,867 $63,501 $58,250 $240,191 $314,711 $337,120 $394,034 $447,061 $499,342
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $63,878 $63,878 $63,878 $63,878 $63,867 $63,501 $58,250 $240,191 $314,711 $337,120 $394,034 $447,061 $499,342
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 $0 $0 $0 $0 $338 $805 $10,845 $122,092 $124,641 $93,647 $97,508 $98,252 $98,320
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $380 $13,596 $26,813 $37,371 $47,929 $58,487 $69,045
Subtotal Current Liabilities $0 $0 $0 $0 $338 $805 $11,225 $135,688 $151,454 $131,018 $145,437 $156,739 $167,364
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $0 $0 $0 $338 $805 $11,225 $135,688 $151,454 $131,018 $145,437 $156,739 $167,364
Paid-in Capital $379,309 $379,309 $379,309 $379,309 $379,309 $379,309 $379,309 $379,309 $379,309 $379,309 $379,309 $379,309 $379,309
Retained Earnings ($315,431) ($315,431) ($315,431) ($315,431) ($315,431) ($315,431) ($315,431) ($315,431) ($315,431) ($315,431) ($315,431) ($315,431) ($315,431)
Earnings $0 $0 $0 $0 ($350) ($1,183) ($16,854) $40,625 $99,379 $142,224 $184,719 $226,444 $268,099
Total Capital $63,878 $63,878 $63,878 $63,878 $63,528 $62,695 $47,025 $104,504 $163,257 $206,102 $248,597 $290,322 $331,977
Total Liabilities and Capital $63,878 $63,878 $63,878 $63,878 $63,867 $63,501 $58,250 $240,191 $314,711 $337,120 $394,034 $447,061 $499,342
Net Worth $63,878 $63,878 $63,878 $63,878 $63,528 $62,695 $47,025 $104,504 $163,257 $206,102 $248,597 $290,322 $331,977