Sarrica's Market

Start your own business plan »

Gourmet Food Store 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
Grocery Items 0% $8,000 $7,800 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $7,800 $8,000
Delicatessen - Cheese, meat, produce 0% $8,000 $7,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $7,000 $8,000
Drinks 0% $4,000 $3,500 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $3,500 $4,000
Frozen 0% $2,000 $1,800 $4,000 $3,500 $4,000 $3,500 $4,000 $4,000 $3,500 $4,000 $1,800 $2,000
Gift Merchandise 0% $2,500 $2,000 $3,000 $2,000 $3,000 $2,000 $3,000 $3,000 $2,000 $3,000 $2,000 $2,500
Other 0% $300 $300 $500 $500 $500 $500 $500 $500 $500 $500 $300 $300
Total Sales $24,800 $22,400 $46,500 $45,000 $46,500 $45,000 $46,500 $46,500 $45,000 $46,500 $22,400 $24,800
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
Grocery Items $4,800 $4,680 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $4,680 $4,800
Delicatessen - cheese, meat, produce $4,800 $4,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $7,200 $4,200 $4,800
Drinks $2,400 $2,100 $5,400 $5,400 $5,400 $5,400 $5,400 $5,400 $5,400 $5,400 $2,100 $2,400
Frozen $1,200 $1,080 $2,400 $2,100 $2,400 $2,100 $2,400 $2,400 $2,100 $2,400 $1,080 $1,200
Gift Merchandise $1,500 $1,200 $1,800 $1,200 $1,800 $1,200 $1,800 $1,800 $1,200 $1,800 $1,200 $1,500
Other $180 $180 $300 $300 $300 $300 $300 $300 $300 $300 $180 $180
Subtotal Direct Cost of Sales $14,880 $13,440 $27,900 $27,000 $27,900 $27,000 $27,900 $27,900 $27,000 $27,900 $13,440 $14,880
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
Owners: Managers (2) 0% $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Clerks (1-2) 0% $1,280 $1,280 $2,560 $2,560 $2,560 $2,560 $2,560 $2,560 $2,560 $2,560 $1,280 $1,280
Accounting/Books (1) 0% $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Cooks/Kitchen (1) 0% $0 $0 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $0 $0
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 4 4 6 6 6 6 6 6 6 6 4 4
Total Payroll $5,480 $5,480 $8,040 $8,040 $8,040 $8,040 $8,040 $8,040 $8,040 $8,040 $5,480 $5,480
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 $24,800 $22,400 $46,500 $45,000 $46,500 $45,000 $46,500 $46,500 $45,000 $46,500 $22,400 $24,800
Direct Cost of Sales $14,880 $13,440 $27,900 $27,000 $27,900 $27,000 $27,900 $27,900 $27,000 $27,900 $13,440 $14,880
Hidden Row $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $14,880 $13,440 $27,900 $27,000 $27,900 $27,000 $27,900 $27,900 $27,000 $27,900 $13,440 $14,880
Gross Margin $9,920 $8,960 $18,600 $18,000 $18,600 $18,000 $18,600 $18,600 $18,000 $18,600 $8,960 $9,920
Gross Margin % 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00%
Expenses
Payroll $5,480 $5,480 $8,040 $8,040 $8,040 $8,040 $8,040 $8,040 $8,040 $8,040 $5,480 $5,480
Marketing/Postage/Other $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Depreciation $208 $208 $208 $208 $208 $208 $208 $208 $208 $208 $208 $208
Legal $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Books/Accounting $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Licenses/Permits/Memberships $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75
Delivery/Transportation $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Insurance $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Rent $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Utilities $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Equipment/Supplies $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Building/Equipment Maintenence $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Total Operating Expenses $11,263 $11,263 $13,823 $13,823 $13,823 $13,823 $13,823 $13,823 $13,823 $13,823 $11,263 $11,263
Profit Before Interest and Taxes ($1,343) ($2,303) $4,777 $4,177 $4,777 $4,177 $4,777 $4,777 $4,177 $4,777 ($2,303) ($1,343)
EBITDA ($1,135) ($2,095) $4,985 $4,385 $4,985 $4,385 $4,985 $4,985 $4,385 $4,985 ($2,095) ($1,135)
Interest Expense $535 $529 $522 $516 $509 $503 $497 $490 $484 $477 $471 $464
Taxes Incurred ($564) ($850) $1,276 $1,098 $1,280 $1,102 $1,284 $1,286 $1,108 $1,290 ($832) ($542)
Net Profit ($1,315) ($1,982) $2,978 $2,563 $2,987 $2,572 $2,996 $3,001 $2,585 $3,010 ($1,942) ($1,265)
Net Profit/Sales -5.30% -8.85% 6.40% 5.69% 6.42% 5.71% 6.44% 6.45% 5.74% 6.47% -8.67% -5.10%
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 $24,800 $22,400 $46,500 $45,000 $46,500 $45,000 $46,500 $46,500 $45,000 $46,500 $22,400 $24,800
Subtotal Cash from Operations $24,800 $22,400 $46,500 $45,000 $46,500 $45,000 $46,500 $46,500 $45,000 $46,500 $22,400 $24,800
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 $24,800 $22,400 $46,500 $45,000 $46,500 $45,000 $46,500 $46,500 $45,000 $46,500 $22,400 $24,800
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 $5,480 $5,480 $8,040 $8,040 $8,040 $8,040 $8,040 $8,040 $8,040 $8,040 $5,480 $5,480
Bill Payments $560 $16,805 $18,246 $50,580 $33,301 $36,152 $33,292 $36,212 $35,182 $33,278 $35,198 $5,690
Subtotal Spent on Operations $6,040 $22,285 $26,286 $58,620 $41,341 $44,192 $41,332 $44,252 $43,222 $41,318 $40,678 $11,170
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 $1,191 $1,191 $1,191 $1,191 $1,191 $1,191 $1,191 $1,191 $1,191 $1,191 $1,191 $1,191
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 $7,230 $23,476 $27,476 $59,811 $42,531 $45,383 $42,522 $45,443 $44,412 $42,509 $41,869 $12,360
Net Cash Flow $17,570 ($1,076) $19,024 ($14,811) $3,969 ($383) $3,978 $1,057 $588 $3,991 ($19,469) $12,440
Cash Balance $33,270 $32,194 $51,218 $36,407 $40,375 $39,993 $43,970 $45,027 $45,615 $49,606 $30,137 $42,577
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 $15,700 $33,270 $32,194 $51,218 $36,407 $40,375 $39,993 $43,970 $45,027 $45,615 $49,606 $30,137 $42,577
Inventory $20,000 $16,368 $14,784 $30,690 $29,700 $30,690 $29,700 $30,690 $30,690 $29,700 $30,690 $17,250 $16,368
Other Current Assets $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Total Current Assets $40,700 $54,638 $51,978 $86,908 $71,107 $76,065 $74,693 $79,660 $80,717 $80,315 $85,296 $52,387 $63,945
Long-term Assets
Long-term Assets $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Accumulated Depreciation $0 $208 $417 $625 $833 $1,042 $1,250 $1,458 $1,667 $1,875 $2,083 $2,292 $2,500
Total Long-term Assets $20,000 $19,792 $19,583 $19,375 $19,167 $18,958 $18,750 $18,542 $18,333 $18,125 $17,917 $17,708 $17,500
Total Assets $60,700 $74,429 $71,561 $106,283 $90,274 $95,024 $93,443 $98,202 $99,051 $98,440 $103,213 $70,096 $81,445
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 $16,235 $16,540 $49,474 $32,092 $35,046 $32,084 $35,037 $34,076 $32,071 $35,024 $5,040 $18,845
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $16,235 $16,540 $49,474 $32,092 $35,046 $32,084 $35,037 $34,076 $32,071 $35,024 $5,040 $18,845
Long-term Liabilities $100,000 $98,810 $97,619 $96,429 $95,238 $94,048 $92,857 $91,667 $90,476 $89,286 $88,095 $86,905 $85,714
Total Liabilities $100,000 $115,044 $114,159 $145,902 $127,330 $129,094 $124,941 $126,704 $124,552 $121,356 $123,119 $91,944 $104,559
Paid-in Capital $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000
Retained Earnings ($63,300) ($63,300) ($63,300) ($63,300) ($63,300) ($63,300) ($63,300) ($63,300) ($63,300) ($63,300) ($63,300) ($63,300) ($63,300)
Earnings $0 ($1,315) ($3,297) ($319) $2,243 $5,230 $7,802 $10,798 $13,799 $16,384 $19,393 $17,451 $16,186
Total Capital ($39,300) ($40,615) ($42,597) ($39,619) ($37,057) ($34,070) ($31,498) ($28,502) ($25,501) ($22,916) ($19,907) ($21,849) ($23,114)
Total Liabilities and Capital $60,700 $74,429 $71,561 $106,283 $90,274 $95,024 $93,443 $98,202 $99,051 $98,440 $103,213 $70,096 $81,445
Net Worth ($39,300) ($40,615) ($42,597) ($39,619) ($37,057) ($34,070) ($31,498) ($28,502) ($25,501) ($22,916) ($19,907) ($21,849) ($23,114)