Manufacturing - Custom Parts Business Plan

Start your plan
Start my business plan

Start your own manufacturing - custom parts business plan

JTB Products and Services

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
Auto Body products 0% $0 $0 $1,200 $1,400 $1,800 $4,000 $5,800 $7,200 $8,400 $10,200 $11,800 $14,200
Auto Body services 0% $0 $315 $360 $510 $540 $1,200 $1,740 $2,160 $2,520 $3,060 $3,540 $4,260
Commercial Drilling 0% $0 $600 $1,800 $3,800 $4,200 $4,800 $6,200 $6,800 $6,980 $7,200 $7,700 $7,800
Sporting Goods products 0% $0 $0 $1,200 $3,400 $5,400 $7,800 $9,400 $10,400 $11,700 $12,900 $13,200 $14,400
Sporting Goods services 0% $0 $0 $460 $1,360 $2,160 $3,120 $3,760 $4,160 $4,600 $5,160 $5,280 $5,760
Prototype Services 0% $0 $0 $0 $0 $600 $600 $800 $800 $1,000 $1,000 $1,200 $1,200
Metalworking and Manufacturing 0% $1,000 $1,000 $1,200 $1,800 $3,800 $5,400 $6,600 $7,800 $10,200 $12,000 $12,800 $14,200
Total Sales $1,000 $1,915 $6,220 $12,270 $18,500 $26,920 $34,300 $39,320 $45,400 $51,520 $55,520 $61,820
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
Auto body products and Services $0 $0 $936 $1,146 $1,404 $3,120 $3,770 $4,680 $5,460 $6,630 $7,170 $9,230
Commercial Drilling $0 $290 $870 $1,900 $2,600 $2,990 $3,800 $3,980 $4,848 $5,328 $5,633 $5,700
Sporting Goods $0 $0 $664 $1,920 $3,024 $4,368 $5,922 $6,990 $7,700 $9,100 $10,800 $11,900
Prototype Services 27% $0 $0 $0 $0 $159 $159 $212 $212 $265 $265 $318 $318
Metalworking and Manufacturing $490 $760 $870 $1,100 $2,400 $3,900 $4,950 $5,400 $6,300 $8,400 $8,800 $9,900
Subtotal Direct Cost of Sales $490 $1,050 $3,340 $6,066 $9,587 $14,537 $18,654 $21,262 $24,573 $29,723 $32,721 $37,048
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
Service Team Manager $0 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200
Service Team Member $0 $0 $0 $0 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100
Subtotal $0 $3,200 $3,200 $3,200 $4,300 $4,300 $4,300 $4,300 $4,300 $4,300 $4,300 $4,300
Sales and Marketing Personnel
Shared Marketing Associate $0 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
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 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
General and Administrative Personnel
Production Manager/Service Team Coordinator $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600
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 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600
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 2 3 3 3 4 4 4 4 4 4 4 4
Total Payroll $3,600 $7,050 $7,050 $7,050 $8,150 $8,150 $8,150 $8,150 $8,150 $8,150 $8,150 $8,150

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 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
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 $1,000 $1,915 $6,220 $12,270 $18,500 $26,920 $34,300 $39,320 $45,400 $51,520 $55,520 $61,820
Direct Cost of Sales $490 $1,050 $3,340 $6,066 $9,587 $14,537 $18,654 $21,262 $24,573 $29,723 $32,721 $37,048
Production Payroll $0 $3,200 $3,200 $3,200 $4,300 $4,300 $4,300 $4,300 $4,300 $4,300 $4,300 $4,300
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $490 $4,250 $6,540 $9,266 $13,887 $18,837 $22,954 $25,562 $28,873 $34,023 $37,021 $41,348
Gross Margin $510 ($2,335) ($320) $3,004 $4,613 $8,083 $11,346 $13,758 $16,527 $17,497 $18,499 $20,472
Gross Margin % 51.00% -121.93% -5.14% 24.48% 24.94% 30.03% 33.08% 34.99% 36.40% 33.96% 33.32% 33.12%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $0 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Advertising/Promotion $0 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450
Other Sales and Marketing Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales and Marketing Expenses $0 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
Sales and Marketing % 0.00% 36.55% 11.25% 5.70% 3.78% 2.60% 2.04% 1.78% 1.54% 1.36% 1.26% 1.13%
General and Administrative Expenses
General and Administrative Payroll $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600
Sales and Marketing and Other Expenses $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450
Depreciation $646 $646 $646 $646 $646 $646 $646 $646 $646 $646 $646 $646
Rent $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
Equipment Lease $2,999 $2,999 $2,999 $2,999 $2,999 $2,999 $2,999 $2,999 $2,999 $2,999 $2,999 $2,999
Utilities $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Insurance $350 $350 $350 $350 $350 $350 $450 $450 $450 $450 $450 $450
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $9,345 $9,345 $9,345 $9,345 $9,345 $9,345 $9,445 $9,445 $9,445 $9,445 $9,445 $9,445
General and Administrative % 934.48% 487.98% 150.24% 76.16% 50.51% 34.71% 27.54% 24.02% 20.80% 18.33% 17.01% 15.28%
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
Other Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Total Operating Expenses $9,345 $10,045 $10,045 $10,045 $10,045 $10,045 $10,145 $10,145 $10,145 $10,145 $10,145 $10,145
Profit Before Interest and Taxes ($8,835) ($12,380) ($10,365) ($7,041) ($5,432) ($1,962) $1,201 $3,613 $6,382 $7,352 $8,354 $10,327
EBITDA ($8,189) ($11,734) ($9,719) ($6,395) ($4,786) ($1,316) $1,847 $4,259 $7,028 $7,998 $9,000 $10,973
Interest Expense $372 $370 $367 $365 $362 $359 $357 $354 $352 $349 $346 $344
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($9,207) ($12,750) ($10,732) ($7,405) ($5,794) ($2,321) $844 $3,259 $6,031 $7,003 $8,008 $9,983
Net Profit/Sales -920.72% -665.78% -172.54% -60.35% -31.32% -8.62% 2.46% 8.29% 13.28% 13.59% 14.42% 16.15%

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 $250 $479 $1,555 $3,068 $4,625 $6,730 $8,575 $9,830 $11,350 $12,880 $13,880 $15,455
Cash from Receivables $0 $525 $1,230 $3,696 $7,841 $12,473 $18,296 $24,065 $28,361 $32,682 $37,263 $40,740
Subtotal Cash from Operations $250 $1,004 $2,785 $6,764 $12,466 $19,203 $26,871 $33,895 $39,711 $45,562 $51,143 $56,195
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 $250 $1,004 $2,785 $6,764 $12,466 $19,203 $26,871 $33,895 $39,711 $45,562 $51,143 $56,195
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 $3,600 $7,050 $7,050 $7,050 $8,150 $8,150 $8,150 $8,150 $8,150 $8,150 $8,150 $8,150
Bill Payments $182 $5,539 $7,643 $11,652 $14,849 $19,232 $25,508 $28,813 $30,007 $34,117 $40,899 $41,902
Subtotal Spent on Operations $3,782 $12,589 $14,693 $18,702 $22,999 $27,382 $33,658 $36,963 $38,157 $42,267 $49,049 $50,052
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 $313 $313 $313 $313 $313 $313 $313 $313 $313 $313 $313 $313
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 $4,095 $12,902 $15,006 $19,014 $23,312 $27,694 $33,971 $37,276 $38,469 $42,580 $49,362 $50,365
Net Cash Flow ($3,845) ($11,898) ($12,220) ($12,250) ($10,846) ($8,491) ($7,100) ($3,381) $1,241 $2,982 $1,781 $5,830
Cash Balance $166,805 $154,907 $142,687 $130,436 $119,591 $111,100 $104,000 $100,619 $101,860 $104,842 $106,623 $112,453
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 $170,650 $166,805 $154,907 $142,687 $130,436 $119,591 $111,100 $104,000 $100,619 $101,860 $104,842 $106,623 $112,453
Accounts Receivable $0 $750 $1,661 $5,096 $10,602 $16,636 $24,353 $31,782 $37,208 $42,897 $48,855 $53,232 $58,857
Inventory $1,000 $510 $1,050 $3,340 $6,066 $9,587 $14,537 $18,654 $21,262 $24,573 $29,723 $32,721 $37,048
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 $176,650 $173,065 $162,618 $156,122 $152,104 $150,814 $154,990 $159,436 $164,088 $174,330 $188,420 $197,576 $213,358
Long-term Assets
Long-term Assets $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000
Accumulated Depreciation $0 $646 $1,292 $1,937 $2,583 $3,229 $3,875 $4,521 $5,167 $5,812 $6,458 $7,104 $7,750
Total Long-term Assets $45,000 $44,354 $43,708 $43,063 $42,417 $41,771 $41,125 $40,479 $39,833 $39,188 $38,542 $37,896 $37,250
Total Assets $221,650 $217,419 $206,327 $199,185 $194,521 $192,584 $196,115 $199,915 $203,922 $213,517 $226,962 $235,472 $250,608
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 $5,289 $7,258 $11,161 $14,215 $18,385 $24,549 $27,818 $28,877 $32,755 $39,509 $40,323 $45,789
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 $5,289 $7,258 $11,161 $14,215 $18,385 $24,549 $27,818 $28,877 $32,755 $39,509 $40,323 $45,789
Long-term Liabilities $45,000 $44,688 $44,375 $44,063 $43,750 $43,438 $43,125 $42,813 $42,500 $42,188 $41,875 $41,563 $41,250
Total Liabilities $45,000 $49,977 $51,633 $55,224 $57,965 $61,823 $67,674 $70,630 $71,377 $74,943 $81,384 $81,886 $87,039
Paid-in Capital $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000 $230,000
Retained Earnings ($53,350) ($53,350) ($53,350) ($53,350) ($53,350) ($53,350) ($53,350) ($53,350) ($53,350) ($53,350) ($53,350) ($53,350) ($53,350)
Earnings $0 ($9,207) ($21,957) ($32,689) ($40,094) ($45,888) ($48,209) ($47,365) ($44,106) ($38,075) ($31,072) ($23,064) ($13,081)
Total Capital $176,650 $167,443 $154,693 $143,961 $136,556 $130,762 $128,441 $129,285 $132,544 $138,575 $145,578 $153,586 $163,569
Total Liabilities and Capital $221,650 $217,419 $206,327 $199,185 $194,521 $192,584 $196,115 $199,915 $203,922 $213,517 $226,962 $235,472 $250,608
Net Worth $176,650 $167,443 $154,693 $143,961 $136,556 $130,762 $128,441 $129,285 $132,544 $138,575 $145,578 $153,586 $163,569

Long-term
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10
Sales $354,705 $461,550 $601,569 $729,944 $902,842 $905,618 $959,956 $998,354 $1,058,255 $1,105,876
Cost of Sales $243,051 $286,974 $338,739 $405,839 $485,700 $479,978 $508,777 $529,128 $560,875 $586,114
Gross Margin $111,654 $174,576 $262,830 $324,105 $417,142 $425,640 $451,179 $469,226 $497,380 $519,762
Gross Margin % 31.48% 37.82% 43.69% 44.40% 46.20% 47.00% 47.00% 47.00% 47.00% 47.00%
Operating Expenses $120,438 $131,438 $138,538 $145,338 $149,638 $157,120 $164,976 $173,225 $181,886 $190,980
Operating Income ($8,784) $43,138 $124,292 $178,767 $267,504 $268,521 $286,203 $296,002 $315,494 $328,781
Net Income ($13,081) $27,440 $84,511 $122,906 $185,284 $179,909 $191,756 $198,321 $211,381 $220,284
Current Assets $213,358 $225,937 $301,184 $385,061 $503,335 $629,169 $755,003 $868,253 $998,491 $1,098,340
Long-term Assets $37,250 $29,500 $21,750 $14,000 $6,250 $0 $0 $0 $0 $0
Current Liabilities $45,789 $26,927 $33,663 $40,636 $49,625 $51,610 $53,675 $55,822 $58,054 $60,377
Long-term Liabilities $41,250 $37,500 $33,750 $30,000 $26,250 $13,338 $426 $0 $0 $0
Equity $163,569 $191,010 $255,520 $328,426 $433,710 $590,897 $701,754 $812,432 $940,437 $1,037,964

Download link edge graphic Download this plan

Start your own manufacturing - custom parts business plan

Start your own business plan

LivePlan logo Start planning

Your business plan can look as polished and professional as this sample plan. It's fast and easy, with LivePlan.

Get the Bplans newsletter:

Expert business tips and advice delivered weekly.