Parkdale Meats

Start your own business plan »

Butcher Shop 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
Retail Regular Sales $5,000 $6,000 $7,200 $8,640 $10,368 $12,442 $14,930 $17,916 $21,499 $25,799 $30,959 $37,151
Retail Special Orders $2,000 $2,400 $2,880 $3,456 $4,147 $4,976 $5,971 $7,165 $8,598 $10,318 $12,382 $14,858
Catering Business Sales $0 $1,000 $1,675 $2,252 $2,887 $3,911 $5,601 $6,756 $8,546 $9,932 $12,588 $16,693
Restaurant Sales $0 $2,000 $3,291 $4,446 $6,063 $7,769 $10,289 $13,333 $15,853 $19,213 $21,942 $25,617
Total Sales $7,000 $11,400 $15,046 $18,794 $23,465 $29,098 $36,790 $45,170 $54,496 $65,261 $77,871 $94,319
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
Retail Meats $2,500 $3,000 $3,600 $4,320 $5,184 $6,221 $7,465 $8,958 $10,750 $12,900 $15,480 $18,576
Special Order Meats $1,200 $1,440 $1,728 $2,074 $2,488 $2,986 $3,583 $4,299 $5,159 $6,191 $7,429 $8,915
Business Meats $0 $1,800 $2,980 $4,019 $5,370 $7,008 $9,534 $12,053 $14,639 $17,487 $20,718 $25,386
Subtotal Direct Cost of Sales $3,700 $6,240 $8,308 $10,413 $13,042 $16,214 $20,581 $25,310 $30,548 $36,577 $43,627 $52,876
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
CEO $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
COO $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Assistant Butcher $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200
Sales & Operations Staff $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Total People 4 4 4 4 4 4 4 4 4 4 4 4
Total Payroll $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200
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 $7,000 $11,400 $15,046 $18,794 $23,465 $29,098 $36,790 $45,170 $54,496 $65,261 $77,871 $94,319
Direct Cost of Sales $3,700 $6,240 $8,308 $10,413 $13,042 $16,214 $20,581 $25,310 $30,548 $36,577 $43,627 $52,876
Other Costs of Sales $350 $570 $752 $940 $1,173 $1,455 $1,840 $2,259 $2,725 $3,263 $3,894 $4,716
Total Cost of Sales $4,050 $6,810 $9,060 $11,352 $14,216 $17,669 $22,421 $27,569 $33,272 $39,840 $47,520 $57,592
Gross Margin $2,950 $4,590 $5,986 $7,442 $9,250 $11,428 $14,370 $17,601 $21,223 $25,421 $30,351 $36,727
Gross Margin % 42.14% 40.26% 39.79% 39.60% 39.42% 39.28% 39.06% 38.97% 38.95% 38.95% 38.98% 38.94%
Expenses
Payroll $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200
Marketing/Promotion $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Depreciation $670 $670 $670 $670 $670 $670 $670 $670 $670 $670 $670 $670
Rent $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Insurance $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Payroll Taxes 15% $1,830 $1,830 $1,830 $1,830 $1,830 $1,830 $1,830 $1,830 $1,830 $1,830 $1,830 $1,830
Other $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Total Operating Expenses $18,700 $18,700 $18,700 $18,700 $18,700 $18,700 $18,700 $18,700 $18,700 $18,700 $18,700 $18,700
Profit Before Interest and Taxes ($15,750) ($14,110) ($12,714) ($11,258) ($9,450) ($7,272) ($4,330) ($1,099) $2,523 $6,721 $11,651 $18,027
EBITDA ($15,080) ($13,440) ($12,044) ($10,588) ($8,780) ($6,602) ($3,660) ($429) $3,193 $7,391 $12,321 $18,697
Interest Expense $804 $775 $746 $717 $688 $658 $629 $600 $571 $542 $513 $483
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($16,554) ($14,885) ($13,460) ($11,975) ($10,138) ($7,930) ($4,960) ($1,699) $1,953 $6,180 $11,138 $17,543
Net Profit/Sales -236.49% -130.57% -89.46% -63.71% -43.20% -27.25% -13.48% -3.76% 3.58% 9.47% 14.30% 18.60%
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 $7,000 $11,400 $15,046 $18,794 $23,465 $29,098 $36,790 $45,170 $54,496 $65,261 $77,871 $94,319
Subtotal Cash from Operations $7,000 $11,400 $15,046 $18,794 $23,465 $29,098 $36,790 $45,170 $54,496 $65,261 $77,871 $94,319
Additional Cash Received
Sales Tax, VAT, HST/GST Received 7.00% $490 $798 $1,053 $1,316 $1,643 $2,037 $2,575 $3,162 $3,815 $4,568 $5,451 $6,602
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 $7,490 $12,198 $16,099 $20,110 $25,108 $31,135 $39,366 $48,332 $58,311 $69,830 $83,322 $100,921
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 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200 $12,200
Bill Payments $5,120 $9,757 $14,120 $16,228 $18,524 $21,509 $25,118 $30,145 $35,375 $41,207 $47,983 $55,978
Subtotal Spent on Operations $17,320 $21,957 $26,320 $28,428 $30,724 $33,709 $37,318 $42,345 $47,575 $53,407 $60,183 $68,178
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $490 $798 $1,053 $1,316 $1,643 $2,037 $2,575 $3,162 $3,815 $4,568 $5,451 $6,602
Principal Repayment of Current Borrowing $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
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 $20,310 $25,255 $29,873 $32,244 $34,867 $38,246 $42,393 $48,007 $53,889 $60,475 $68,133 $77,281
Net Cash Flow ($12,820) ($13,057) ($13,774) ($12,134) ($9,759) ($7,111) ($3,028) $325 $4,421 $9,354 $15,189 $23,640
Cash Balance $67,180 $54,122 $40,348 $28,214 $18,455 $11,344 $8,316 $8,641 $13,062 $22,417 $37,605 $61,246
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 $80,000 $67,180 $54,122 $40,348 $28,214 $18,455 $11,344 $8,316 $8,641 $13,062 $22,417 $37,605 $61,246
Inventory $2,000 $925 $1,560 $2,077 $2,603 $3,261 $4,054 $5,145 $6,328 $7,637 $9,144 $10,907 $13,219
Other Current 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
Total Current Assets $102,000 $88,105 $75,683 $62,425 $50,818 $41,716 $35,398 $33,462 $34,969 $40,699 $51,561 $68,512 $94,465
Long-term Assets
Long-term Assets $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000
Accumulated Depreciation $0 $670 $1,340 $2,010 $2,680 $3,350 $4,020 $4,690 $5,360 $6,030 $6,700 $7,370 $8,040
Total Long-term Assets $80,000 $79,330 $78,660 $77,990 $77,320 $76,650 $75,980 $75,310 $74,640 $73,970 $73,300 $72,630 $71,960
Total Assets $182,000 $167,435 $154,343 $140,415 $128,138 $118,366 $111,378 $108,772 $109,609 $114,669 $124,861 $141,142 $166,425
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 $4,800 $9,289 $13,582 $15,614 $17,811 $20,677 $24,119 $28,973 $34,009 $39,617 $46,128 $53,771 $64,010
Current Borrowing $40,000 $38,000 $36,000 $34,000 $32,000 $30,000 $28,000 $26,000 $24,000 $22,000 $20,000 $18,000 $16,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $44,800 $47,289 $49,582 $49,614 $49,811 $50,677 $52,119 $54,973 $58,009 $61,617 $66,128 $71,771 $80,010
Long-term Liabilities $40,000 $39,500 $39,000 $38,500 $38,000 $37,500 $37,000 $36,500 $36,000 $35,500 $35,000 $34,500 $34,000
Total Liabilities $84,800 $86,789 $88,582 $88,114 $87,811 $88,177 $89,119 $91,473 $94,009 $97,117 $101,128 $106,271 $114,010
Paid-in Capital $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 $130,000 $130,000
Retained Earnings ($32,800) ($32,800) ($32,800) ($32,800) ($32,800) ($32,800) ($32,800) ($32,800) ($32,800) ($32,800) ($32,800) ($32,800) ($32,800)
Earnings $0 ($16,554) ($31,439) ($44,899) ($56,874) ($67,011) ($74,941) ($79,901) ($81,600) ($79,647) ($73,467) ($62,329) ($44,786)
Total Capital $97,200 $80,646 $65,761 $52,301 $40,326 $30,189 $22,259 $17,299 $15,600 $17,553 $23,733 $34,871 $52,414
Total Liabilities and Capital $182,000 $167,435 $154,343 $140,415 $128,138 $118,366 $111,378 $108,772 $109,609 $114,669 $124,861 $141,142 $166,425
Net Worth $97,200 $80,646 $65,761 $52,301 $40,326 $30,189 $22,259 $17,299 $15,600 $17,553 $23,733 $34,871 $52,414