AMT Computers

Start your own business plan »

Computer Hardware Reseller Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Unit Sales
Systems 0% 85 115 145 190 245 175 120 100 180 275 350 275
Service 0% 200 200 200 200 244 256 269 282 296 311 327 343
Software 0% 150 200 250 330 430 310 210 180 320 490 620 490
Training 0% 145 155 165 170 225 200 150 150 200 220 250 200
Other 0% 160 176 192 240 200 175 125 100 104 200 250 200
Total Unit Sales 740 846 952 1,130 1,344 1,116 874 812 1,100 1,496 1,797 1,508
Unit Prices Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Systems $2,000.00 $2,000.00 $2,000.00 $1,828.95 $1,890.63 $1,966.17 $2,131.58 $2,115.38 $2,083.33 $1,966.40 $1,980.29 $1,984.50
Service $75.00 $69.00 $58.00 $46.00 $50.00 $47.00 $50.00 $50.00 $91.00 $124.00 $75.00 $67.00
Software $200.00 $200.00 $200.00 $200.00 $223.00 $217.00 $242.00 $253.00 $220.00 $211.00 $204.00 $207.00
Training $37.00 $35.00 $39.00 $41.00 $56.00 $50.00 $33.00 $33.00 $50.00 $55.00 $60.00 $50.00
Other $300.00 $300.00 $300.00 $1,133.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00
Sales
Systems $170,000 $230,000 $290,000 $347,501 $463,204 $344,080 $255,790 $211,538 $374,999 $540,760 $693,102 $545,738
Service $15,000 $13,800 $11,600 $9,200 $12,200 $12,032 $13,450 $14,100 $26,936 $38,564 $24,525 $22,981
Software $30,000 $40,000 $50,000 $66,000 $95,890 $67,270 $50,820 $45,540 $70,400 $103,390 $126,480 $101,430
Training $5,365 $5,425 $6,435 $6,970 $12,600 $10,000 $4,950 $4,950 $10,000 $12,100 $15,000 $10,000
Other $48,000 $52,800 $57,600 $271,920 $60,000 $52,500 $37,500 $30,000 $31,200 $60,000 $75,000 $60,000
Total Sales $268,365 $342,025 $415,635 $701,591 $643,894 $485,882 $362,510 $306,128 $513,535 $754,814 $934,107 $740,149
Direct Unit Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Systems 0.00% $1,700.00 $1,700.00 $1,700.00 $1,700.00 $1,700.00 $1,700.00 $1,700.00 $1,700.00 $1,700.00 $1,700.00 $1,700.00 $1,700.00
Service 0.00% $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00
Software 0.00% $120.00 $120.00 $120.00 $120.00 $120.00 $120.00 $120.00 $120.00 $120.00 $120.00 $120.00 $120.00
Training 0.00% $11.10 $11.10 $11.10 $11.10 $11.10 $11.10 $11.10 $11.10 $11.10 $11.10 $11.10 $11.10
Other 0.00% $90.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00 $90.00
Direct Cost of Sales
Systems $144,500 $195,500 $246,500 $323,000 $416,500 $297,500 $204,000 $170,000 $306,000 $467,500 $595,000 $467,500
Service $6,000 $6,000 $6,000 $6,000 $7,320 $7,680 $8,070 $8,460 $8,880 $9,330 $9,810 $10,290
Software $18,000 $24,000 $30,000 $39,600 $51,600 $37,200 $25,200 $21,600 $38,400 $58,800 $74,400 $58,800
Training $1,610 $1,721 $1,832 $1,887 $2,498 $2,220 $1,665 $1,665 $2,220 $2,442 $2,775 $2,220
Other $14,400 $15,840 $17,280 $21,600 $18,000 $15,750 $11,250 $9,000 $9,360 $18,000 $22,500 $18,000
Subtotal Direct Cost of Sales $184,510 $243,061 $301,612 $392,087 $495,918 $360,350 $250,185 $210,725 $364,860 $556,072 $704,485 $556,810
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Production Personnel
Manager $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 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Technical $0 $0 $0 $0 $0 $0 $0 $2,500 $2,500 $2,500 $2,500 $2,500
Technical $0 $0 $0 $0 $0 $0 $0 $2,500 $2,500 $2,500 $2,500 $2,500
Technical $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Fulfillment $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Fulfillment $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Subtotal $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $14,500 $14,500 $14,500 $14,500 $14,500
Sales and Marketing Personnel
Manager $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Technical Sales $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Technical Sales $3,500 $3,500 $3,500 $3,500 $3,500 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Salesperson $2,500 $2,500 $2,500 $2,500 $2,500 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Salesperson $2,500 $2,500 $2,500 $2,500 $2,500 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Salesperson $2,500 $2,500 $2,500 $2,500 $2,500 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Salesperson $2,000 $2,000 $2,000 $2,000 $2,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Salesperson $0 $0 $0 $0 $0 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Salesperson $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $24,000 $24,000 $24,000 $24,000 $24,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000
General and Administrative Personnel
President $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500
Finance $0 $0 $0 $0 $0 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Admin Assistant $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Bookkeeping $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Clerical $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Clerical $0 $0 $0 $0 $0 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Clerical $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $10,000 $10,000 $10,000 $10,000 $10,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Other Personnel
Programming $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Other Technical $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $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 19 19 19 19 19 26 26 26 26 26 26 26
Total Payroll $46,500 $46,500 $46,500 $46,500 $46,500 $59,500 $59,500 $64,500 $64,500 $64,500 $64,500 $64,500
Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $268,365 $342,025 $415,635 $701,591 $643,894 $485,882 $362,510 $306,128 $513,535 $754,814 $934,107 $740,149
Direct Cost of Sales $184,510 $243,061 $301,612 $392,087 $495,918 $360,350 $250,185 $210,725 $364,860 $556,072 $704,485 $556,810
Production Payroll $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500 $14,500 $14,500 $14,500 $14,500 $14,500
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $194,010 $252,561 $311,112 $401,587 $505,418 $369,850 $259,685 $225,225 $379,360 $570,572 $718,985 $571,310
Gross Margin $74,356 $89,465 $104,524 $300,004 $138,477 $116,032 $102,825 $80,903 $134,175 $184,242 $215,122 $168,839
Gross Margin % 27.71% 26.16% 25.15% 42.76% 21.51% 23.88% 28.36% 26.43% 26.13% 24.41% 23.03% 22.81%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $24,000 $24,000 $24,000 $24,000 $24,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000
Ads $5,000 $5,000 $7,000 $10,000 $15,000 $10,000 $4,000 $4,000 $20,000 $15,000 $20,000 $10,000
Catalog $2,000 $3,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Mailing $3,000 $11,800 $5,500 $10,500 $10,500 $5,500 $10,500 $10,500 $10,500 $22,000 $8,000 $5,000
Promo $0 $0 $0 $0 $0 $0 $0 $0 $1,000 $0 $15,000 $0
Shows $0 $0 $0 $0 $0 $0 $3,200 $0 $10,000 $7,000 $0 $0
Literature $0 $7,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
PR $0 $0 $0 $1,000 $0 $0 $0 $0 $0 $0 $0 $0
Seminar $1,000 $0 $0 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $0 $0 $0
Service $2,000 $1,000 $1,000 $500 $2,500 $500 $500 $500 $500 $500 $500 $250
Training $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450
Total Sales and Marketing Expenses $37,450 $52,250 $39,950 $53,450 $59,450 $55,450 $57,650 $54,450 $81,450 $78,950 $77,950 $49,700
Sales and Marketing % 13.95% 15.28% 9.61% 7.62% 9.23% 11.41% 15.90% 17.79% 15.86% 10.46% 8.34% 6.71%
General and Administrative Expenses
General and Administrative Payroll $10,000 $10,000 $10,000 $10,000 $10,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Marketing/Promotion $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $1,000 $1,010 $1,020 $1,030 $1,040 $1,050 $1,061 $1,072 $1,083 $1,094 $1,105 $1,116
Leased Equipment $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Rent $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000
Utilities $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Insurance $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other General and Administrative Expenses $500 $505 $510 $515 $520 $525 $530 $535 $540 $545 $550 $556
Total General and Administrative Expenses $22,250 $22,265 $22,280 $22,295 $22,310 $27,325 $27,341 $27,357 $27,373 $27,389 $27,405 $27,422
General and Administrative % 8.29% 6.51% 5.36% 3.18% 3.46% 5.62% 7.54% 8.94% 5.33% 3.63% 2.93% 3.70%
Other Expenses:
Other Payroll $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Contract/Consultants $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125
Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Expenses $3,125 $3,125 $3,125 $3,125 $3,125 $3,125 $3,125 $3,125 $3,125 $3,125 $3,125 $3,125
Other % 1.16% 0.91% 0.75% 0.45% 0.49% 0.64% 0.86% 1.02% 0.61% 0.41% 0.33% 0.42%
Total Operating Expenses $62,825 $77,640 $65,355 $78,870 $84,885 $85,900 $88,116 $84,932 $111,948 $109,464 $108,480 $80,247
Profit Before Interest and Taxes $11,531 $11,825 $39,169 $221,134 $53,592 $30,132 $14,709 ($4,029) $22,227 $74,778 $106,642 $88,592
EBITDA $12,531 $12,835 $40,189 $222,164 $54,632 $31,182 $15,770 ($2,957) $23,310 $75,872 $107,747 $89,708
Interest Expense $2,580 $2,543 $3,213 $3,175 $3,137 $3,099 $3,060 $3,022 $2,983 $2,944 $2,919 $2,893
Taxes Incurred $1,790 $1,856 $7,191 $43,592 $10,091 $5,407 $3,494 ($1,410) $3,849 $14,367 $20,745 $17,140
Net Profit $7,160 $7,426 $28,764 $174,367 $40,364 $21,626 $8,154 ($5,641) $15,395 $57,467 $82,978 $68,559
Net Profit/Sales 2.67% 2.17% 6.92% 24.85% 6.27% 4.45% 2.25% -1.84% 3.00% 7.61% 8.88% 9.26%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $40,255 $51,304 $62,345 $105,239 $96,584 $72,882 $54,376 $45,919 $77,030 $113,222 $140,116 $111,022
Cash from Receivables $197,554 $205,157 $230,197 $292,807 $361,392 $594,717 $542,833 $409,504 $306,536 $266,085 $443,341 $646,672
Subtotal Cash from Operations $237,808 $256,461 $292,543 $398,045 $457,976 $667,599 $597,210 $455,423 $383,566 $379,307 $583,457 $757,694
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 $100,000 $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 $237,808 $256,461 $392,543 $398,045 $457,976 $667,599 $597,210 $455,423 $383,566 $379,307 $583,457 $757,694
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $46,500 $46,500 $46,500 $46,500 $46,500 $59,500 $59,500 $64,500 $64,500 $64,500 $64,500 $64,500
Bill Payments $224,870 $29,690 $51,343 $273,659 $573,158 $646,765 $265,321 $184,400 $219,402 $594,568 $826,664 $918,082
Subtotal Spent on Operations $271,370 $76,190 $97,843 $320,159 $619,658 $706,265 $324,821 $248,900 $283,902 $659,068 $891,164 $982,582
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 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $500 $500
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $2,942 $2,962 $2,983 $3,005 $3,026 $3,047 $3,069 $3,091 $3,113 $3,135 $3,157 $3,179
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 $276,812 $81,652 $103,326 $325,664 $625,184 $711,812 $330,390 $254,491 $289,515 $664,703 $894,821 $986,261
Net Cash Flow ($39,004) $174,809 $289,217 $72,382 ($167,208) ($44,212) $266,820 $200,932 $94,051 ($285,395) ($311,364) ($228,566)
Cash Balance $16,428 $191,237 $480,454 $552,836 $385,628 $341,416 $608,235 $809,167 $903,218 $617,823 $306,459 $77,893
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $55,432 $16,428 $191,237 $480,454 $552,836 $385,628 $341,416 $608,235 $809,167 $903,218 $617,823 $306,459 $77,893
Accounts Receivable $395,107 $425,664 $511,228 $634,320 $937,865 $1,123,784 $942,066 $707,366 $558,071 $688,040 $1,063,547 $1,414,196 $1,396,650
Inventory $805,098 $620,589 $377,528 $301,612 $392,087 $495,918 $360,350 $250,185 $210,725 $364,860 $556,072 $704,485 $556,810
Other Current Assets $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Total Current Assets $1,280,637 $1,087,680 $1,104,993 $1,441,386 $1,907,788 $2,030,329 $1,668,832 $1,590,786 $1,602,963 $1,981,119 $2,262,442 $2,450,140 $2,056,353
Long-term Assets
Long-term Assets $350,000 $350,000 $350,000 $350,000 $350,000 $350,000 $350,000 $350,000 $350,000 $350,000 $350,000 $350,000 $350,000
Accumulated Depreciation $50,000 $51,000 $52,010 $53,030 $54,060 $55,100 $56,150 $57,211 $58,283 $59,366 $60,460 $61,565 $62,681
Total Long-term Assets $300,000 $299,000 $297,990 $296,970 $295,940 $294,900 $293,850 $292,789 $291,717 $290,634 $289,540 $288,435 $287,319
Total Assets $1,580,637 $1,386,680 $1,402,983 $1,738,356 $2,203,728 $2,325,229 $1,962,682 $1,883,575 $1,894,680 $2,271,753 $2,551,982 $2,738,575 $2,343,672
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $223,897 $28,222 $42,561 $254,653 $551,164 $637,827 $259,200 $177,509 $199,845 $567,136 $795,533 $902,805 $443,022
Current Borrowing $90,000 $87,500 $85,000 $82,500 $80,000 $77,500 $75,000 $72,500 $70,000 $67,500 $65,000 $64,500 $64,000
Other Current Liabilities $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Subtotal Current Liabilities $328,897 $130,722 $142,561 $352,153 $646,164 $730,327 $349,200 $265,009 $284,845 $649,636 $875,533 $982,305 $522,022
Long-term Liabilities $284,862 $281,920 $278,958 $375,975 $372,970 $369,944 $366,897 $363,828 $360,737 $357,624 $354,489 $351,332 $348,153
Total Liabilities $613,759 $412,642 $421,519 $728,128 $1,019,134 $1,100,271 $716,097 $628,837 $645,582 $1,007,260 $1,230,022 $1,333,637 $870,175
Paid-in Capital $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000
Retained Earnings $418,355 $466,878 $466,878 $466,878 $466,878 $466,878 $466,878 $466,878 $466,878 $466,878 $466,878 $466,878 $466,878
Earnings $48,523 $7,160 $14,586 $43,350 $217,717 $258,080 $279,707 $287,860 $282,220 $297,615 $355,082 $438,060 $506,619
Total Capital $966,878 $974,038 $981,464 $1,010,228 $1,184,595 $1,224,958 $1,246,585 $1,254,738 $1,249,098 $1,264,493 $1,321,960 $1,404,938 $1,473,497
Total Liabilities and Capital $1,580,637 $1,386,680 $1,402,983 $1,738,356 $2,203,728 $2,325,229 $1,962,682 $1,883,575 $1,894,680 $2,271,753 $2,551,982 $2,738,575 $2,343,672
Net Worth $966,878 $974,038 $981,464 $1,010,228 $1,184,595 $1,224,958 $1,246,585 $1,254,738 $1,249,098 $1,264,493 $1,321,960 $1,404,938 $1,473,497