JTB Industrial Sales

Start your own business plan »

Commercial Catalog Sales 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
Tooling 0% $400 $600 $800 $1,500 $1,900 $2,100 $2,600 $2,850 $3,100 $3,210 $3,460 $3,800
Commercial, Contractor, Utilities 0% $350 $500 $600 $900 $1,100 $1,400 $1,800 $2,400 $2,700 $3,150 $3,600 $3,800
Safety Products 0% $250 $540 $600 $780 $820 $1,100 $1,400 $1,800 $2,100 $2,210 $2,330 $2,400
Holding Products 0% $200 $350 $400 $500 $600 $700 $800 $900 $1,000 $1,100 $1,200 $1,300
Precision Measuring Products 0% $200 $350 $400 $500 $600 $700 $800 $900 $1,000 $1,100 $1,200 $1,300
Catalog Industrial Products 0% $700 $1,400 $2,800 $5,400 $6,800 $7,900 $10,200 $11,800 $12,700 $14,100 $15,100 $16,300
Specialty Purchased Components 0% $0 $0 $0 $375 $475 $575 $675 $775 $875 $975 $1,075 $1,175
Tool Related Services 0% $0 $0 $0 $300 $600 $900 $1,100 $1,300 $1,500 $1,700 $1,900 $2,000
Manufacturing Services 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Manufacturing Partners 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Military and Governmental 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $2,100 $3,740 $5,600 $10,255 $12,895 $15,375 $19,375 $22,725 $24,975 $27,545 $29,865 $32,075
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
Metal Cutting Tools $240 $360 $480 $900 $1,140 $1,260 $1,560 $1,710 $1,860 $1,926 $2,076 $2,280
Commercial, Contractor, Utilities $210 $300 $360 $540 $660 $840 $1,080 $1,440 $1,620 $1,890 $2,160 $2,280
Safety Products $150 $324 $360 $468 $492 $660 $840 $1,080 $1,260 $1,326 $1,398 $1,440
Work Holding Products $120 $210 $240 $300 $360 $420 $480 $540 $600 $660 $720 $780
Precision Measuring Products $120 $210 $240 $300 $360 $420 $480 $540 $600 $660 $720 $780
Catalog Industrial Products $455 $910 $1,820 $3,510 $4,420 $5,135 $6,630 $7,670 $8,255 $9,165 $9,815 $10,595
Specialty Puchased Components $0 $0 $0 $206 $261 $316 $371 $426 $481 $536 $591 $646
Cutting Tool related Services $0 $0 $0 $165 $330 $495 $605 $715 $825 $935 $1,045 $1,100
Channel Partner Services $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Internet Distributorships $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Military and Governmental $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $1,295 $2,314 $3,500 $6,389 $8,023 $9,546 $12,046 $14,121 $15,501 $17,098 $18,525 $19,901
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
Shipping and Receiving $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Name or Title or Group $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Sales and Marketing Personnel
Sales Team Leader $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Sales Associate $0 $0 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Sales and Marketing Associate (shared) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $2,500 $2,500 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400
General and Administrative Personnel
Sales Manager $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
Other Personnel
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 2 3 3 3 3 3 3 3 3 3 3
Total Payroll $3,300 $3,300 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200
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 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 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 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 $2,100 $3,740 $5,600 $10,255 $12,895 $15,375 $19,375 $22,725 $24,975 $27,545 $29,865 $32,075
Direct Cost of Sales $1,295 $2,314 $3,500 $6,389 $8,023 $9,546 $12,046 $14,121 $15,501 $17,098 $18,525 $19,901
Production Payroll $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $2,095 $3,114 $4,300 $7,189 $8,823 $10,346 $12,846 $14,921 $16,301 $17,898 $19,325 $20,701
Gross Margin $5 $626 $1,300 $3,066 $4,072 $5,029 $6,529 $7,804 $8,674 $9,647 $10,540 $11,374
Gross Margin % 0.24% 16.74% 23.21% 29.90% 31.58% 32.71% 33.70% 34.34% 34.73% 35.02% 35.29% 35.46%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $2,500 $2,500 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400
Advertising/Promotion $0 $200 $200 $200 $300 $300 $300 $300 $300 $300 $300 $300
Other Sales and Marketing Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales and Marketing Expenses $2,500 $2,700 $3,600 $3,600 $3,700 $3,700 $3,700 $3,700 $3,700 $3,700 $3,700 $3,700
Sales and Marketing % 119.05% 72.19% 64.29% 35.10% 28.69% 24.07% 19.10% 16.28% 14.81% 13.43% 12.39% 11.54%
General and Administrative Expenses
General and Administrative Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $163 $163 $163 $163 $163 $163 $163 $163 $163 $163 $163 $163
Rent $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Utilities $300 $300 $300 $300 $300 $300 $300 $400 $400 $400 $400 $400
Insurance $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Payroll Taxes 15% $270 $450 $585 $585 $585 $585 $585 $585 $585 $585 $585 $585
CPA - Accounting and Payroll 15% $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $2,033 $2,213 $2,348 $2,348 $2,348 $2,348 $2,348 $2,448 $2,448 $2,448 $2,448 $2,448
General and Administrative % 96.79% 59.16% 41.92% 22.89% 18.20% 15.27% 12.12% 10.77% 9.80% 8.89% 8.20% 7.63%
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 $4,533 $4,913 $5,948 $5,948 $6,048 $6,048 $6,048 $6,148 $6,148 $6,148 $6,148 $6,148
Profit Before Interest and Taxes ($4,528) ($4,287) ($4,648) ($2,882) ($1,976) ($1,019) $482 $1,657 $2,527 $3,500 $4,393 $5,227
EBITDA ($4,365) ($4,124) ($4,485) ($2,719) ($1,813) ($856) $644 $1,819 $2,689 $3,662 $4,555 $5,389
Interest Expense $1,501 $1,494 $1,487 $1,479 $1,472 $1,465 $1,458 $1,450 $1,443 $1,436 $1,429 $1,422
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($6,029) ($5,780) ($6,134) ($4,361) ($3,448) ($2,483) ($976) $206 $1,083 $2,064 $2,964 $3,805
Net Profit/Sales -287.08% -154.56% -109.54% -42.52% -26.74% -16.15% -5.04% 0.91% 4.34% 7.49% 9.92% 11.86%
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 $210 $374 $560 $1,026 $1,290 $1,538 $1,938 $2,273 $2,498 $2,755 $2,987 $3,208
Cash from Receivables $0 $1,197 $2,825 $4,426 $7,693 $10,734 $13,019 $16,118 $19,347 $21,735 $23,942 $26,113
Subtotal Cash from Operations $210 $1,571 $3,385 $5,452 $8,983 $12,272 $14,957 $18,390 $21,845 $24,490 $26,929 $29,320
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 $210 $1,571 $3,385 $5,452 $8,983 $12,272 $14,957 $18,390 $21,845 $24,490 $26,929 $29,320
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,300 $3,300 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200
Bill Payments $2,612 $3,384 $3,748 $3,974 $7,195 $14,476 $15,912 $19,790 $21,280 $21,663 $23,553 $24,722
Subtotal Spent on Operations $5,912 $6,684 $7,948 $8,174 $11,395 $18,676 $20,112 $23,990 $25,480 $25,863 $27,753 $28,922
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 $868 $868 $868 $868 $868 $868 $868 $868 $868 $868 $868 $868
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 $6,780 $7,552 $8,816 $9,042 $12,263 $19,544 $20,980 $24,858 $26,348 $26,731 $28,621 $29,790
Net Cash Flow ($6,570) ($5,981) ($5,431) ($3,590) ($3,281) ($7,272) ($6,024) ($6,468) ($4,503) ($2,242) ($1,692) ($470)
Cash Balance $109,030 $103,049 $97,618 $94,027 $90,747 $83,474 $77,451 $70,983 $66,480 $64,238 $62,546 $62,076
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 $115,600 $109,030 $103,049 $97,618 $94,027 $90,747 $83,474 $77,451 $70,983 $66,480 $64,238 $62,546 $62,076
Accounts Receivable $0 $1,890 $4,059 $6,274 $11,078 $14,990 $18,093 $22,511 $26,846 $29,977 $33,032 $35,968 $38,723
Inventory $20,000 $18,705 $16,391 $12,891 $9,584 $12,035 $14,319 $18,069 $21,182 $23,252 $25,647 $27,788 $29,852
Other Current Assets $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500
Total Current Assets $141,100 $135,125 $128,999 $122,283 $120,188 $123,271 $121,386 $123,531 $124,511 $125,208 $128,417 $131,801 $136,150
Long-term Assets
Long-term Assets $19,500 $19,500 $19,500 $19,500 $19,500 $19,500 $19,500 $19,500 $19,500 $19,500 $19,500 $19,500 $19,500
Accumulated Depreciation $0 $163 $325 $488 $650 $813 $975 $1,138 $1,300 $1,463 $1,625 $1,788 $1,950
Total Long-term Assets $19,500 $19,338 $19,175 $19,013 $18,850 $18,688 $18,525 $18,363 $18,200 $18,038 $17,875 $17,713 $17,550
Total Assets $160,600 $154,462 $148,174 $141,295 $139,038 $141,958 $139,911 $141,893 $142,711 $143,245 $146,292 $149,514 $153,700
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 $2,500 $3,259 $3,619 $3,743 $6,714 $13,950 $15,254 $19,081 $20,560 $20,879 $22,731 $23,857 $25,106
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 $2,500 $3,259 $3,619 $3,743 $6,714 $13,950 $15,254 $19,081 $20,560 $20,879 $22,731 $23,857 $25,106
Long-term Liabilities $181,000 $180,132 $179,264 $178,396 $177,528 $176,660 $175,792 $174,924 $174,056 $173,188 $172,320 $171,452 $170,584
Total Liabilities $183,500 $183,391 $182,883 $182,139 $184,242 $190,610 $191,046 $194,005 $194,616 $194,067 $195,051 $195,309 $195,690
Paid-in Capital $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Retained Earnings ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900) ($22,900)
Earnings $0 ($6,029) ($11,809) ($17,943) ($22,304) ($25,752) ($28,235) ($29,211) ($29,005) ($27,922) ($25,859) ($22,895) ($19,090)
Total Capital ($22,900) ($28,929) ($34,709) ($40,843) ($45,204) ($48,652) ($51,135) ($52,111) ($51,905) ($50,822) ($48,759) ($45,795) ($41,990)
Total Liabilities and Capital $160,600 $154,462 $148,174 $141,295 $139,038 $141,958 $139,911 $141,893 $142,711 $143,245 $146,292 $149,514 $153,700
Net Worth ($22,900) ($28,929) ($34,709) ($40,843) ($45,204) ($48,652) ($51,135) ($52,111) ($51,905) ($50,822) ($48,758) ($45,795) ($41,990)
Long-term
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10
Sales $206,525 $347,300 $433,420 $542,963 $674,518 $714,989 $787,898 $811,234 $841,790 $877,349
Cost of Sales $137,859 $221,785 $282,261 $334,220 $429,883 $455,448 $501,891 $516,756 $536,220 $558,871
Gross Margin $68,666 $125,515 $151,159 $208,743 $244,635 $259,541 $286,007 $294,478 $305,570 $318,478
Gross Margin % 33.25% 36.14% 34.88% 38.45% 36.27% 36.30% 36.30% 36.30% 36.30% 36.30%
Operating Expenses $70,220 $84,255 $105,600 $115,650 $124,950 $136,196 $148,453 $161,814 $176,377 $192,251
Operating Income ($1,554) $41,260 $45,559 $93,093 $119,685 $123,346 $137,554 $132,664 $129,193 $126,227
Net Income ($19,090) $17,306 $21,044 $55,047 $74,391 $109,778 $122,423 $118,071 $114,981 $112,342
Current Assets $136,150 $143,387 $160,582 $213,082 $287,688 $373,994 $411,394 $452,533 $497,787 $547,565
Long-term Assets $17,550 $15,600 $13,650 $11,700 $9,750 $7,800 $5,850 $3,900 $1,950 $0
Current Liabilities $25,106 $23,503 $28,120 $34,039 $42,720 $80,235 $92,270 $103,342 $118,326 $137,258
Long-term Liabilities $170,584 $160,168 $149,752 $139,336 $128,920 $118,504 $108,088 $97,672 $87,256 $76,840
Equity ($41,990) ($24,684) ($3,640) $51,407 $125,798 $183,055 $216,886 $255,419 $294,155 $333,467