Jean's Tofu Delight

Start your own business plan »

Wholesale Food Manufacturer Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Supermarkets 0% $40,000 $40,000 $45,000 $45,000 $50,000 $60,000 $60,000 $60,000 $65,000 $65,000 $65,000 $65,000
Large Upscale Natural Food Stores 0% $15,000 $15,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $25,000 $25,000 $25,000 $25,000
Small Natural Food Stores 0% $5,000 $5,000 $5,000 $5,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $60,000 $60,000 $70,000 $70,000 $80,000 $90,000 $90,000 $90,000 $100,000 $100,000 $100,000 $100,000
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Supermarkets $8,500 $8,500 $10,000 $10,000 $12,000 $14,000 $14,000 $14,000 $15,000 $15,000 $15,000 $15,000
Large Upscale Natural Food Stores $3,000 $3,500 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $6,000 $6,000 $6,000 $6,000
Small Natural Food Stores $1,000 $1,000 $1,000 $1,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $12,500 $13,000 $15,900 $15,900 $18,900 $20,900 $20,900 $20,900 $23,000 $23,000 $23,000 $23,000
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Jean Simmons 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Sales Manager 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Production Staff 0% $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Distribution Staff 0% $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Sales Staff 0% $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000
Total People 15 15 15 15 15 15 15 15 15 15 15 15
Total Payroll $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $60,000 $60,000 $70,000 $70,000 $80,000 $90,000 $90,000 $90,000 $100,000 $100,000 $100,000 $100,000
Direct Cost of Sales $12,500 $13,000 $15,900 $15,900 $18,900 $20,900 $20,900 $20,900 $23,000 $23,000 $23,000 $23,000
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $12,500 $13,000 $15,900 $15,900 $18,900 $20,900 $20,900 $20,900 $23,000 $23,000 $23,000 $23,000
Gross Margin $47,500 $47,000 $54,100 $54,100 $61,100 $69,100 $69,100 $69,100 $77,000 $77,000 $77,000 $77,000
Gross Margin % 79.17% 78.33% 77.29% 77.29% 76.38% 76.78% 76.78% 76.78% 77.00% 77.00% 77.00% 77.00%
Expenses
Payroll $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000
Sales and Marketing and Other Expenses $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Depreciation $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
Insurance $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Rent $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Payroll Taxes 15% $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $55,300 $55,300 $55,300 $55,300 $55,300 $55,300 $55,300 $55,300 $55,300 $55,300 $55,300 $55,300
Profit Before Interest and Taxes ($7,800) ($8,300) ($1,200) ($1,200) $5,800 $13,800 $13,800 $13,800 $21,700 $21,700 $21,700 $21,700
EBITDA ($7,000) ($7,500) ($400) ($400) $6,600 $14,600 $14,600 $14,600 $22,500 $22,500 $22,500 $22,500
Interest Expense $401 $469 $538 $606 $674 $742 $810 $878 $946 $1,014 $1,082 $1,151
Taxes Incurred ($2,460) ($2,631) ($521) ($542) $1,538 $3,917 $3,897 $3,877 $6,226 $6,206 $6,185 $6,165
Net Profit ($5,741) ($6,139) ($1,216) ($1,264) $3,588 $9,141 $9,093 $9,046 $14,528 $14,480 $14,433 $14,384
Net Profit/Sales -9.57% -10.23% -1.74% -1.81% 4.49% 10.16% 10.10% 10.05% 14.53% 14.48% 14.43% 14.38%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $15,000 $15,000 $17,500 $17,500 $20,000 $22,500 $22,500 $22,500 $25,000 $25,000 $25,000 $25,000
Cash from Receivables $40,000 $41,500 $45,000 $45,250 $52,500 $52,750 $60,250 $67,500 $67,500 $67,750 $75,000 $75,000
Subtotal Cash from Operations $55,000 $56,500 $62,500 $62,750 $72,500 $75,250 $82,750 $90,000 $92,500 $92,750 $100,000 $100,000
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 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,500
New Other Liabilities (interest-free) $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
New Long-term Liabilities $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
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 $69,333 $70,833 $76,833 $77,083 $86,833 $89,583 $97,083 $104,333 $106,833 $107,083 $114,333 $114,500
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000
Bill Payments $21,023 $30,598 $28,146 $35,502 $32,745 $41,023 $44,187 $42,108 $42,382 $48,907 $46,721 $46,769
Subtotal Spent on Operations $59,023 $68,598 $66,146 $73,502 $70,745 $79,023 $82,187 $80,108 $80,382 $86,907 $84,721 $84,769
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 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Purchase Other Current Assets $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Purchase Long-term Assets $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $66,189 $75,764 $73,312 $80,668 $77,911 $86,189 $89,353 $87,274 $87,548 $94,073 $91,887 $91,935
Net Cash Flow $3,144 ($4,931) $3,521 ($3,585) $8,922 $3,394 $7,730 $17,059 $19,285 $13,010 $22,446 $22,565
Cash Balance $43,144 $38,213 $41,735 $38,150 $47,072 $50,465 $58,195 $75,254 $94,539 $107,549 $129,995 $152,560
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $40,000 $43,144 $38,213 $41,735 $38,150 $47,072 $50,465 $58,195 $75,254 $94,539 $107,549 $129,995 $152,560
Accounts Receivable $80,000 $85,000 $88,500 $96,000 $103,250 $110,750 $125,500 $132,750 $132,750 $140,250 $147,500 $147,500 $147,500
Inventory $10,000 $13,750 $14,300 $17,490 $17,490 $20,790 $22,990 $22,990 $22,990 $25,300 $25,300 $25,300 $25,300
Other Current Assets $5,000 $7,000 $9,000 $11,000 $13,000 $15,000 $17,000 $19,000 $21,000 $23,000 $25,000 $27,000 $29,000
Total Current Assets $135,000 $148,894 $150,013 $166,225 $171,890 $193,612 $215,955 $232,935 $251,994 $283,089 $305,349 $329,795 $354,360
Long-term Assets
Long-term Assets $50,000 $52,000 $54,000 $56,000 $58,000 $60,000 $62,000 $64,000 $66,000 $68,000 $70,000 $72,000 $74,000
Accumulated Depreciation $12,000 $12,800 $13,600 $14,400 $15,200 $16,000 $16,800 $17,600 $18,400 $19,200 $20,000 $20,800 $21,600
Total Long-term Assets $38,000 $39,200 $40,400 $41,600 $42,800 $44,000 $45,200 $46,400 $47,600 $48,800 $50,000 $51,200 $52,400
Total Assets $173,000 $188,094 $190,413 $207,825 $214,690 $237,612 $261,155 $279,335 $299,594 $331,889 $355,349 $380,995 $406,760
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $20,000 $29,668 $26,959 $34,419 $31,382 $39,548 $42,784 $40,703 $40,749 $47,349 $45,162 $45,208 $45,255
Current Borrowing $0 $6,667 $13,334 $20,001 $26,668 $33,335 $40,002 $46,669 $53,336 $60,003 $66,670 $73,337 $80,171
Other Current Liabilities $0 $3,000 $6,000 $9,000 $12,000 $15,000 $18,000 $21,000 $24,000 $27,000 $30,000 $33,000 $36,000
Subtotal Current Liabilities $20,000 $39,335 $46,293 $63,420 $70,050 $87,883 $100,786 $108,372 $118,085 $134,352 $141,832 $151,545 $161,426
Long-term Liabilities $40,000 $41,500 $43,000 $44,500 $46,000 $47,500 $49,000 $50,500 $52,000 $53,500 $55,000 $56,500 $58,000
Total Liabilities $60,000 $80,835 $89,293 $107,920 $116,050 $135,383 $149,786 $158,872 $170,085 $187,852 $196,832 $208,045 $219,426
Paid-in Capital $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
Retained Earnings $9,000 $33,000 $33,000 $33,000 $33,000 $33,000 $33,000 $33,000 $33,000 $33,000 $33,000 $33,000 $33,000
Earnings $24,000 ($5,741) ($11,880) ($13,096) ($14,360) ($10,771) ($1,630) $7,463 $16,508 $31,036 $45,516 $59,949 $74,333
Total Capital $113,000 $107,259 $101,120 $99,904 $98,640 $102,229 $111,370 $120,463 $129,508 $144,036 $158,516 $172,949 $187,333
Total Liabilities and Capital $173,000 $188,094 $190,413 $207,825 $214,690 $237,612 $261,155 $279,335 $299,594 $331,889 $355,349 $380,995 $406,760
Net Worth $113,000 $107,259 $101,120 $99,904 $98,640 $102,229 $111,370 $120,463 $129,508 $144,036 $158,516 $172,949 $187,333