OSS Telecom Technology telecommunications products business plan appendix. OSS Telecom Technology is an established steel conglomerate which is now branching out into the telecommunications sector.

OSS Telecom Technology

Start your own business plan »

Telecommunications Products Business Plan

Appendix

Personnel Plan
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Production Personnel
Technical Services Management $33,900 $33,900 $33,900 $33,900 $33,900 $33,900 $33,900 $33,900 $33,900 $33,900 $33,900 $33,900
Technical Services Personnel $25,500 $25,500 $25,500 $25,500 $25,500 $25,500 $25,500 $25,500 $25,500 $25,500 $25,500 $25,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $59,400 $59,400 $59,400 $59,400 $59,400 $59,400 $59,400 $59,400 $59,400 $59,400 $59,400 $59,400
Sales and Marketing Personnel
Sales Management $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000
Account Executives $142,500 $142,500 $142,500 $142,500 $142,500 $142,500 $142,500 $142,500 $142,500 $142,500 $142,500 $142,500
Marketing Personnel $245,000 $245,000 $245,000 $245,000 $245,000 $245,000 $245,000 $245,000 $245,000 $245,000 $245,000 $245,000
Marketing Management $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000 $38,000
Subtotal $465,500 $465,500 $465,500 $465,500 $465,500 $465,500 $465,500 $465,500 $465,500 $465,500 $465,500 $465,500
General and Administrative Personnel
Administration $44,900 $44,900 $44,900 $44,900 $44,900 $44,900 $44,900 $44,900 $44,900 $44,900 $44,900 $44,900
Human Resources & Training Personnel $57,800 $57,800 $57,800 $57,800 $57,800 $57,800 $57,800 $57,800 $57,800 $57,800 $57,800 $57,800
Financial Management $28,900 $28,900 $28,900 $28,900 $28,900 $28,900 $28,900 $28,900 $28,900 $28,900 $28,900 $28,900
Finance & Accounting Personnel $66,900 $66,900 $66,900 $66,900 $66,900 $66,900 $66,900 $66,900 $66,900 $66,900 $66,900 $66,900
Subtotal $198,500 $198,500 $198,500 $198,500 $198,500 $198,500 $198,500 $198,500 $198,500 $198,500 $198,500 $198,500
Other Personnel
Product Development Management $35,700 $35,700 $35,700 $35,700 $35,700 $35,700 $35,700 $35,700 $35,700 $35,700 $35,700 $35,700
Product Development Personnel $83,500 $83,500 $83,500 $83,500 $83,500 $83,500 $83,500 $83,500 $83,500 $83,500 $83,500 $83,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $119,200 $119,200 $119,200 $119,200 $119,200 $119,200 $119,200 $119,200 $119,200 $119,200 $119,200 $119,200
Total People 397 411 425 439 453 467 481 495 509 523 537 548
Total Payroll $842,600 $842,600 $842,600 $842,600 $842,600 $842,600 $842,600 $842,600 $842,600 $842,600 $842,600 $842,600
General Assumptions
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
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 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Sales $1,378,850 $1,387,850 $1,396,740 $1,405,790 $1,414,910 $1,424,080 $1,433,310 $1,442,620 $1,451,965 $1,461,360 $1,470,855 $1,480,400
Direct Cost of Sales $172,357 $173,481 $174,593 $175,724 $176,863 $178,010 $179,164 $180,328 $181,496 $182,670 $183,857 $185,050
Production Payroll $59,400 $59,400 $59,400 $59,400 $59,400 $59,400 $59,400 $59,400 $59,400 $59,400 $59,400 $59,400
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $231,757 $232,881 $233,993 $235,124 $236,263 $237,410 $238,564 $239,728 $240,896 $242,070 $243,257 $244,450
Gross Margin $1,147,093 $1,154,969 $1,162,747 $1,170,666 $1,178,647 $1,186,670 $1,194,746 $1,202,892 $1,211,069 $1,219,290 $1,227,598 $1,235,950
Gross Margin % 83.19% 83.22% 83.25% 83.27% 83.30% 83.33% 83.36% 83.38% 83.41% 83.44% 83.46% 83.49%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $465,500 $465,500 $465,500 $465,500 $465,500 $465,500 $465,500 $465,500 $465,500 $465,500 $465,500 $465,500
Advertising/Promotion $78,900 $78,900 $78,900 $78,900 $78,900 $78,900 $78,900 $78,900 $78,900 $78,900 $78,900 $78,900
Travel $255,000 $255,000 $255,000 $255,000 $255,000 $255,000 $255,000 $255,000 $255,000 $255,000 $255,000 $255,000
Total Sales and Marketing Expenses $799,400 $799,400 $799,400 $799,400 $799,400 $799,400 $799,400 $799,400 $799,400 $799,400 $799,400 $799,400
Sales and Marketing % 57.98% 57.60% 57.23% 56.86% 56.50% 56.13% 55.77% 55.41% 55.06% 54.70% 54.35% 54.00%
General and Administrative Expenses
General and Administrative Payroll $198,500 $198,500 $198,500 $198,500 $198,500 $198,500 $198,500 $198,500 $198,500 $198,500 $198,500 $198,500
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Rent $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
Depreciation $23,000 $23,000 $23,000 $23,000 $23,000 $23,000 $23,000 $23,000 $23,000 $23,000 $23,000 $23,000
Leased Equipment $13,200 $13,200 $13,200 $13,200 $13,200 $13,200 $13,200 $13,200 $13,200 $13,200 $13,200 $13,200
Utilities 15% $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $243,700 $243,700 $243,700 $243,700 $243,700 $243,700 $243,700 $243,700 $243,700 $243,700 $243,700 $243,700
General and Administrative % 17.67% 17.56% 17.45% 17.34% 17.22% 17.11% 17.00% 16.89% 16.78% 16.68% 16.57% 16.46%
Other Expenses:
Other Payroll $119,200 $119,200 $119,200 $119,200 $119,200 $119,200 $119,200 $119,200 $119,200 $119,200 $119,200 $119,200
Contract/Consultants $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000
Total Other Expenses $126,200 $126,200 $126,200 $126,200 $126,200 $126,200 $126,200 $126,200 $126,200 $126,200 $126,200 $126,200
Other % 9.15% 9.09% 9.04% 8.98% 8.92% 8.86% 8.80% 8.75% 8.69% 8.64% 8.58% 8.52%
Total Operating Expenses $1,169,300 $1,169,300 $1,169,300 $1,169,300 $1,169,300 $1,169,300 $1,169,300 $1,169,300 $1,169,300 $1,169,300 $1,169,300 $1,169,300
Profit Before Interest and Taxes ($22,207) ($14,331) ($6,553) $1,366 $9,347 $17,370 $25,446 $33,592 $41,769 $49,990 $58,298 $66,650
EBITDA ($20,007) ($12,131) ($4,353) $3,566 $11,547 $19,570 $27,646 $35,792 $43,969 $52,190 $60,498 $68,850
Interest Expense $8,514 $8,444 $8,375 $8,306 $8,236 $8,167 $8,097 $8,028 $7,958 $7,889 $7,819 $7,750
Taxes Incurred ($7,680) ($5,694) ($3,732) ($1,735) $278 $2,301 $4,337 $6,391 $8,453 $10,525 $12,620 $14,725
Net Profit ($23,041) ($17,082) ($11,196) ($5,205) $833 $6,902 $13,012 $19,173 $25,358 $31,576 $37,859 $44,175
Net Profit/Sales -1.67% -1.23% -0.80% -0.37% 0.06% 0.48% 0.91% 1.33% 1.75% 2.16% 2.57% 2.98%
Pro Forma Cash Flow
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Cash Received
Cash from Operations
Cash Sales $344,713 $346,963 $349,185 $351,448 $353,728 $356,020 $358,328 $360,655 $362,991 $365,340 $367,714 $370,100
Cash from Receivables $927,000 $961,471 $1,034,363 $1,041,110 $1,047,781 $1,054,571 $1,061,412 $1,068,291 $1,075,215 $1,082,199 $1,089,209 $1,096,257
Subtotal Cash from Operations $1,271,713 $1,308,434 $1,383,548 $1,392,557 $1,401,509 $1,410,591 $1,419,739 $1,428,946 $1,438,207 $1,447,539 $1,456,922 $1,466,357
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 $20,000,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $21,271,713 $1,308,434 $1,383,548 $1,392,557 $1,401,509 $1,410,591 $1,419,739 $1,428,946 $1,438,207 $1,447,539 $1,456,922 $1,466,357
Expenditures Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Expenditures from Operations
Cash Spending $842,600 $842,600 $842,600 $842,600 $842,600 $842,600 $842,600 $842,600 $842,600 $842,600 $842,600 $842,600
Bill Payments $2,133,570 $557,192 $560,232 $563,238 $566,297 $569,380 $572,482 $575,603 $578,752 $581,913 $585,091 $588,304
Subtotal Spent on Operations $2,976,170 $1,399,792 $1,402,832 $1,405,838 $1,408,897 $1,411,980 $1,415,082 $1,418,203 $1,421,352 $1,424,513 $1,427,691 $1,430,904
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 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,337
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 $2,984,503 $1,408,125 $1,411,165 $1,414,171 $1,417,230 $1,420,313 $1,423,415 $1,426,536 $1,429,685 $1,432,846 $1,436,024 $1,439,241
Net Cash Flow $18,287,210 ($99,691) ($27,617) ($21,614) ($15,722) ($9,723) ($3,675) $2,409 $8,521 $14,693 $20,898 $27,117
Cash Balance $1,515,210 $1,415,519 $1,387,901 $1,366,288 $1,350,566 $1,340,843 $1,337,168 $1,339,577 $1,348,099 $1,362,791 $1,383,689 $1,410,806
Pro Forma Balance Sheet
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Assets Starting Balances
Current Assets
Cash ($16,772,000) $1,515,210 $1,415,519 $1,387,901 $1,366,288 $1,350,566 $1,340,843 $1,337,168 $1,339,577 $1,348,099 $1,362,791 $1,383,689 $1,410,806
Accounts Receivable $1,854,000 $1,961,138 $2,040,554 $2,053,746 $2,066,979 $2,080,380 $2,093,870 $2,107,441 $2,121,115 $2,134,873 $2,148,695 $2,162,627 $2,176,670
Other Current Assets $1,511,000 $1,511,000 $1,511,000 $1,511,000 $1,511,000 $1,511,000 $1,511,000 $1,511,000 $1,511,000 $1,511,000 $1,511,000 $1,511,000 $1,511,000
Total Current Assets ($13,407,000) $4,987,347 $4,967,072 $4,952,648 $4,944,267 $4,941,946 $4,945,713 $4,955,608 $4,971,692 $4,993,972 $5,022,486 $5,057,317 $5,098,476
Long-term Assets
Long-term Assets $8,917,000 $8,917,000 $8,917,000 $8,917,000 $8,917,000 $8,917,000 $8,917,000 $8,917,000 $8,917,000 $8,917,000 $8,917,000 $8,917,000 $8,917,000
Accumulated Depreciation $1,694,000 $1,696,200 $1,698,400 $1,700,600 $1,702,800 $1,705,000 $1,707,200 $1,709,400 $1,711,600 $1,713,800 $1,716,000 $1,718,200 $1,720,400
Total Long-term Assets $7,223,000 $7,220,800 $7,218,600 $7,216,400 $7,214,200 $7,212,000 $7,209,800 $7,207,600 $7,205,400 $7,203,200 $7,201,000 $7,198,800 $7,196,600
Total Assets ($6,184,000) $12,208,147 $12,185,672 $12,169,048 $12,158,467 $12,153,946 $12,155,513 $12,163,208 $12,177,092 $12,197,172 $12,223,486 $12,256,117 $12,295,076
Liabilities and Capital Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Current Liabilities
Accounts Payable $2,115,000 $538,521 $541,461 $544,365 $547,322 $550,301 $553,298 $556,315 $559,359 $562,413 $565,485 $568,590 $571,711
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,115,000 $538,521 $541,461 $544,365 $547,322 $550,301 $553,298 $556,315 $559,359 $562,413 $565,485 $568,590 $571,711
Long-term Liabilities $1,030,000 $1,021,667 $1,013,334 $1,005,001 $996,668 $988,335 $980,002 $971,669 $963,336 $955,003 $946,670 $938,337 $930,000
Total Liabilities $3,145,000 $1,560,188 $1,554,795 $1,549,366 $1,543,990 $1,538,636 $1,533,300 $1,527,984 $1,522,695 $1,517,416 $1,512,155 $1,506,927 $1,501,711
Paid-in Capital $1,667,000 $21,667,000 $21,667,000 $21,667,000 $21,667,000 $21,667,000 $21,667,000 $21,667,000 $21,667,000 $21,667,000 $21,667,000 $21,667,000 $21,667,000
Retained Earnings ($10,996,000) ($10,996,000) ($10,996,000) ($10,996,000) ($10,996,000) ($10,996,000) ($10,996,000) ($10,996,000) ($10,996,000) ($10,996,000) ($10,996,000) ($10,996,000) ($10,996,000)
Earnings $0 ($23,041) ($40,122) ($51,318) ($56,523) ($55,690) ($48,787) ($35,776) ($16,603) $8,755 $40,331 $78,190 $122,365
Total Capital ($9,329,000) $10,647,959 $10,630,878 $10,619,682 $10,614,477 $10,615,310 $10,622,213 $10,635,224 $10,654,397 $10,679,755 $10,711,331 $10,749,190 $10,793,365
Total Liabilities and Capital ($6,184,000) $12,208,147 $12,185,672 $12,169,048 $12,158,467 $12,153,946 $12,155,513 $12,163,208 $12,177,092 $12,197,172 $12,223,486 $12,256,117 $12,295,076
Net Worth ($9,329,000) $10,647,959 $10,630,878 $10,619,682 $10,614,477 $10,615,310 $10,622,213 $10,635,224 $10,654,397 $10,679,755 $10,711,331 $10,749,190 $10,793,365
Sales Forecast
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Sales
CCB (CARIBOU & MEDUSA combined) 0% $1,078,940 $1,086,105 $1,093,350 $1,100,645 $1,107,995 $1,115,385 $1,122,830 $1,130,325 $1,137,870 $1,145,465 $1,153,110 $1,160,805
Pre-Paid IN 0% $299,910 $301,745 $303,390 $305,145 $306,915 $308,695 $310,480 $312,295 $314,095 $315,895 $317,745 $319,595
Total Sales $1,378,850 $1,387,850 $1,396,740 $1,405,790 $1,414,910 $1,424,080 $1,433,310 $1,442,620 $1,451,965 $1,461,360 $1,470,855 $1,480,400
Direct Cost of Sales Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
CCB (CARIBOU & MEDUSA combined) $134,868 $135,763 $136,669 $137,581 $138,499 $139,423 $140,354 $141,291 $142,234 $143,183 $144,139 $145,101
Pre-Paid IN $37,489 $37,718 $37,924 $38,143 $38,364 $38,587 $38,810 $39,037 $39,262 $39,487 $39,718 $39,949
Subtotal Direct Cost of Sales $172,357 $173,481 $174,593 $175,724 $176,863 $178,010 $179,164 $180,328 $181,496 $182,670 $183,857 $185,050
OSS Telecom Technology telecommunications products business plan appendix. OSS Telecom Technology is an established steel conglomerate which is now branching out into the telecommunications sector.