Advanced Technology Pallets

Start your own business plan »

Pallet Manufacturer 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
RST-PAL pallets $18.50/$22.50 (5th yr) $646,464 $1,292,928 $1,864,800 $1,939,392 $1,864,800 $1,864,800 $1,939,392 $1,939,392 $1,939,392 $1,939,392 $1,864,800 $1,939,392
Subsidies $30/ton $26,208 $52,416 $75,600 $78,624 $75,600 $75,600 $78,624 $78,624 $78,624 $78,624 $78,624 $75,600
Total Sales $672,672 $1,345,344 $1,940,400 $2,018,016 $1,940,400 $1,940,400 $2,018,016 $2,018,016 $2,018,016 $2,018,016 $1,943,424 $2,014,992
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
Recycled Rubber 125% $43,680 $87,360 $126,025 $131,040 $126,000 $126,000 $131,040 $131,040 $131,040 $131,040 $126,000 $131,040
Recycled Plastic 90% $31,450 $62,899 $90,738 $94,349 $90,720 $90,720 $94,349 $94,349 $94,349 $94,349 $90,720 $94,349
Binders System 650% $227,136 $454,272 $655,330 $681,408 $655,200 $655,200 $681,408 $681,408 $681,408 $681,408 $655,200 $681,408
Subtotal Direct Cost of Sales $302,266 $604,531 $872,093 $906,797 $871,920 $871,920 $906,797 $906,797 $906,797 $906,797 $871,920 $906,797
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
Texas plant manager $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Texas office worker $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Receptionist (x2) $6.50/hr $1,040 $2,080 $2,080 $2,080 $2,080 $2,080 $2,080 $2,080 $2,080 $2,080 $2,080 $2,080
Data entry (x1) $6.50/hr $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040 $1,040
Foreman (x3) $2,200/mo $2,200 $4,400 $6,600 $6,600 $6,600 $6,600 $6,800 $7,000 $7,200 $7,200 $7,200 $7,200
Line operator (x6) $8.25/hr $3,432 $6,864 $10,296 $10,296 $10,296 $10,296 $10,296 $10,296 $10,296 $10,296 $10,296 $10,296
Loader (x6) $7.25/hr $3,016 $6,032 $9,048 $9,048 $9,048 $9,048 $9,048 $9,048 $9,048 $9,048 $9,048 $9,048
Batcher (x6) $7.50/hr $3,120 $6,240 $9,360 $9,360 $9,360 $9,360 $9,360 $9,360 $9,360 $9,360 $9,360 $9,360
Conveyer worker (x12) $6.50/hr $5,408 $10,816 $16,224 $16,224 $16,224 $16,224 $16,224 $16,224 $16,224 $16,224 $16,224 $16,224
Assembly lead (x4) $7.25/hr $3,016 $3,016 $6,032 $6,032 $6,032 $6,032 $6,032 $6,032 $6,032 $6,032 $6,032 $6,032
Assembly helper (x4) $6.50/hr $2,704 $2,704 $5,408 $5,408 $5,408 $5,408 $5,408 $5,408 $5,408 $5,408 $5,408 $5,408
Cutter (x12) $7.25/hr $12,064 $18,096 $18,096 $18,096 $18,096 $18,096 $18,096 $18,096 $18,096 $18,096 $18,096 $18,096
Forklift operator (x6) $7.25/hr $6,032 $9,048 $9,048 $9,048 $9,048 $9,048 $9,048 $9,048 $9,048 $9,048 $9,048 $9,048
Maint. Supervisor $7.50/hr $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560
Maint. helper (x3) $6.50/hr $1,352 $2,704 $4,056 $4,056 $4,056 $4,056 $4,056 $4,056 $4,056 $4,056 $4,056 $4,056
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $51,184 $79,800 $104,048 $104,048 $104,048 $104,048 $104,248 $104,448 $104,648 $104,648 $104,648 $104,648
Sales and Marketing Personnel
Marketing Director $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
Marketing Secretary $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,700 $6,700 $6,700 $6,700 $6,700 $6,700
General and Administrative Personnel
President - Dan Radke $6,000 $6,000 $6,500 $6,500 $7,500 $7,500 $8,000 $8,000 $8,500 $8,500 $8,500 $8,500
Vice Pres. - Elie Banenson $6,000 $6,000 $6,000 $6,000 $7,000 $7,000 $7,500 $7,500 $8,000 $8,000 $8,000 $8,000
Office Manager $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,300 $3,300 $3,300 $3,300 $3,300 $3,300
Receptionist (x2) $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Office workers (x2) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $16,500 $16,500 $17,000 $17,000 $19,000 $19,000 $21,800 $21,800 $22,800 $22,800 $22,800 $22,800
Other Personnel
Name or Title $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or Title $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $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 33 56 74 74 74 74 75 75 75 75 75 75
Total Payroll $73,684 $102,300 $127,048 $127,048 $129,048 $129,048 $132,748 $132,948 $134,148 $134,148 $134,148 $134,148
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 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Long-term Interest Rate 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Tax Rate 30.00% 34.00% 34.00% 34.00% 34.00% 34.00% 34.00% 34.00% 34.00% 34.00% 34.00% 34.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 $672,672 $1,345,344 $1,940,400 $2,018,016 $1,940,400 $1,940,400 $2,018,016 $2,018,016 $2,018,016 $2,018,016 $1,943,424 $2,014,992
Direct Cost of Sales $302,266 $604,531 $872,093 $906,797 $871,920 $871,920 $906,797 $906,797 $906,797 $906,797 $871,920 $906,797
Production Payroll $51,184 $79,800 $104,048 $104,048 $104,048 $104,048 $104,248 $104,448 $104,648 $104,648 $104,648 $104,648
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $353,450 $684,331 $976,141 $1,010,845 $975,968 $975,968 $1,011,045 $1,011,245 $1,011,445 $1,011,445 $976,568 $1,011,445
Gross Margin $319,222 $661,013 $964,259 $1,007,171 $964,432 $964,432 $1,006,971 $1,006,771 $1,006,571 $1,006,571 $966,856 $1,003,547
Gross Margin % 47.46% 49.13% 49.69% 49.91% 49.70% 49.70% 49.90% 49.89% 49.88% 49.88% 49.75% 49.80%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,700 $6,700 $6,700 $6,700 $6,700 $6,700
Advertising/Promotion $3,500 $3,500 $4,500 $4,500 $5,000 $5,000 $6,000 $6,000 $7,500 $7,500 $10,000 $10,000
Royalties $0 $0 $0 $0 $0 $0 $96,970 $96,970 $96,970 $96,970 $93,240 $96,970
Other Sales and Marketing Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales and Marketing Expenses $9,500 $9,500 $10,500 $10,500 $11,000 $11,000 $109,670 $109,670 $111,170 $111,170 $109,940 $113,670
Sales and Marketing % 1.41% 0.71% 0.54% 0.52% 0.57% 0.57% 5.43% 5.43% 5.51% 5.51% 5.66% 5.64%
General and Administrative Expenses
General and Administrative Payroll $16,500 $16,500 $17,000 $17,000 $19,000 $19,000 $21,800 $21,800 $22,800 $22,800 $22,800 $22,800
Sales and Marketing and Other Expenses $6,000 $6,000 $7,000 $7,000 $7,500 $7,500 $105,470 $105,470 $106,970 $106,970 $105,740 $109,470
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Office Expenses $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Accounting $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Legal $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Travel $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Insurance (property & casualty) $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Payroll Taxes & Benefits Payroll Burden 23% $27,675 $27,675 $28,290 $28,290 $30,750 $30,750 $35,055 $35,055 $36,285 $36,285 $36,285 $36,285
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $64,675 $64,675 $66,790 $66,790 $71,750 $71,750 $176,825 $176,825 $180,555 $180,555 $179,325 $183,055
General and Administrative % 9.61% 4.81% 3.44% 3.31% 3.70% 3.70% 8.76% 8.76% 8.95% 8.95% 9.23% 9.08%
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
Machine Maintenance $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Miscellaneous Expenses $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Total Other Expenses $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500
Other % 1.86% 0.93% 0.64% 0.62% 0.64% 0.64% 0.62% 0.62% 0.62% 0.62% 0.64% 0.62%
Total Operating Expenses $86,675 $86,675 $89,790 $89,790 $95,250 $95,250 $298,995 $298,995 $304,225 $304,225 $301,765 $309,225
Profit Before Interest and Taxes $232,547 $574,338 $874,469 $917,381 $869,182 $869,182 $707,976 $707,776 $702,346 $702,346 $665,091 $694,322
EBITDA $232,547 $574,338 $874,469 $917,381 $869,182 $869,182 $707,976 $707,776 $702,346 $702,346 $665,091 $694,322
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $69,764 $195,275 $297,319 $311,910 $295,522 $295,522 $240,712 $240,644 $238,798 $238,798 $226,131 $236,069
Net Profit $162,783 $379,063 $577,150 $605,471 $573,660 $573,660 $467,264 $467,132 $463,548 $463,548 $438,960 $458,253
Net Profit/Sales 24.20% 28.18% 29.74% 30.00% 29.56% 29.56% 23.15% 23.15% 22.97% 22.97% 22.59% 22.74%
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 $672,672 $1,345,344 $1,940,400 $2,018,016 $1,940,400 $1,940,400 $2,018,016 $2,018,016 $2,018,016 $2,018,016 $1,943,424 $2,014,992
Cash from Receivables $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash from Operations $672,672 $1,345,344 $1,940,400 $2,018,016 $1,940,400 $1,940,400 $2,018,016 $2,018,016 $2,018,016 $2,018,016 $1,943,424 $2,014,992
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 $672,672 $1,345,344 $1,940,400 $2,018,016 $1,940,400 $1,940,400 $2,018,016 $2,018,016 $2,018,016 $2,018,016 $1,943,424 $2,014,992
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 $73,684 $102,300 $127,048 $127,048 $129,048 $129,048 $132,748 $132,948 $134,148 $134,148 $134,148 $134,148
Bill Payments $25,623 $782,957 $1,207,607 $1,523,626 $1,319,526 $1,200,606 $1,244,981 $1,455,087 $1,418,015 $1,420,320 $1,417,374 $1,336,251
Subtotal Spent on Operations $99,307 $885,257 $1,334,655 $1,650,674 $1,448,574 $1,329,654 $1,377,729 $1,588,035 $1,552,163 $1,554,468 $1,551,522 $1,470,399
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 $99,307 $885,257 $1,334,655 $1,650,674 $1,448,574 $1,329,654 $1,377,729 $1,588,035 $1,552,163 $1,554,468 $1,551,522 $1,470,399
Net Cash Flow $573,365 $460,087 $605,745 $367,342 $491,826 $610,746 $640,287 $429,981 $465,853 $463,548 $391,902 $544,593
Cash Balance $1,327,265 $1,787,352 $2,393,097 $2,760,439 $3,252,265 $3,863,011 $4,503,298 $4,933,278 $5,399,131 $5,862,679 $6,254,581 $6,799,174
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 $753,900 $1,327,265 $1,787,352 $2,393,097 $2,760,439 $3,252,265 $3,863,011 $4,503,298 $4,933,278 $5,399,131 $5,862,679 $6,254,581 $6,799,174
Accounts Receivable $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Inventory $0 $332,493 $664,984 $959,302 $997,477 $959,112 $959,112 $997,477 $997,477 $997,477 $997,477 $959,112 $997,477
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $753,900 $1,659,757 $2,452,336 $3,352,399 $3,757,916 $4,211,377 $4,822,123 $5,500,774 $5,930,755 $6,396,608 $6,860,156 $7,213,693 $7,796,650
Long-term Assets
Long-term Assets $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200 $4,033,200
Total Assets $4,787,100 $5,692,957 $6,485,536 $7,385,599 $7,791,116 $8,244,577 $8,855,323 $9,533,974 $9,963,955 $10,429,808 $10,893,356 $11,246,893 $11,829,850
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 $743,074 $1,156,590 $1,479,503 $1,279,549 $1,159,350 $1,196,435 $1,407,823 $1,370,671 $1,372,976 $1,372,976 $1,287,553 $1,412,258
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 $743,074 $1,156,590 $1,479,503 $1,279,549 $1,159,350 $1,196,435 $1,407,823 $1,370,671 $1,372,976 $1,372,976 $1,287,553 $1,412,258
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $743,074 $1,156,590 $1,479,503 $1,279,549 $1,159,350 $1,196,435 $1,407,823 $1,370,671 $1,372,976 $1,372,976 $1,287,553 $1,412,258
Paid-in Capital $6,000,000 $6,000,000 $6,000,000 $6,000,000 $6,000,000 $6,000,000 $6,000,000 $6,000,000 $6,000,000 $6,000,000 $6,000,000 $6,000,000 $6,000,000
Retained Earnings ($1,212,900) ($1,212,900) ($1,212,900) ($1,212,900) ($1,212,900) ($1,212,900) ($1,212,900) ($1,212,900) ($1,212,900) ($1,212,900) ($1,212,900) ($1,212,900) ($1,212,900)
Earnings $0 $162,783 $541,846 $1,118,996 $1,724,467 $2,298,127 $2,871,787 $3,339,051 $3,806,184 $4,269,732 $4,733,280 $5,172,240 $5,630,493
Total Capital $4,787,100 $4,949,883 $5,328,946 $5,906,096 $6,511,567 $7,085,227 $7,658,887 $8,126,151 $8,593,284 $9,056,832 $9,520,380 $9,959,340 $10,417,593
Total Liabilities and Capital $4,787,100 $5,692,957 $6,485,536 $7,385,599 $7,791,116 $8,244,577 $8,855,323 $9,533,974 $9,963,955 $10,429,808 $10,893,356 $11,246,893 $11,829,850
Net Worth $4,787,100 $4,949,883 $5,328,946 $5,906,096 $6,511,567 $7,085,227 $7,658,887 $8,126,151 $8,593,284 $9,056,832 $9,520,380 $9,959,340 $10,417,593