Bottlieb Innovations

Start your own business plan »

Surveyor Instrument 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
Unit Sales
Digital Geographer[DG-1] 0% 0 0 0 5 10 15 25 35 50 60 80 100
Digital Geographer[DG-2] 0% 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 0
Total Unit Sales 0 0 0 5 10 15 25 35 50 60 80 100
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Digital Geographer[DG-1] $0.00 $0.00 $0.00 $425.00 $425.00 $425.00 $425.00 $425.00 $425.00 $425.00 $425.00 $425.00
Digital Geographer[DG-2] $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
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
Sales
Digital Geographer[DG-1] $0 $0 $0 $2,125 $4,250 $6,375 $10,625 $14,875 $21,250 $25,500 $34,000 $42,500
Digital Geographer[DG-2] $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
Total Sales $0 $0 $0 $2,125 $4,250 $6,375 $10,625 $14,875 $21,250 $25,500 $34,000 $42,500
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Digital Geographer[DG-1] 0.00% $0.00 $0.00 $0.00 $280.00 $280.00 $280.00 $270.00 $270.00 $270.00 $260.00 $260.00 $260.00
Digital Geographer[DG-2] 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
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 $0.00
Direct Cost of Sales
Digital Geographer[DG-1] $0 $0 $0 $1,400 $2,800 $4,200 $6,750 $9,450 $13,500 $15,600 $20,800 $26,000
Digital Geographer[DG-2] $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 Direct Cost of Sales $0 $0 $0 $1,400 $2,800 $4,200 $6,750 $9,450 $13,500 $15,600 $20,800 $26,000
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
Supervisor $0 $0 $0 $0 $0 $0 $0 $0 $1,200 $1,200 $1,200 $2,400
Assembler 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Assembler 2 $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 $1,200 $1,200 $1,200 $2,400
Sales and Marketing Personnel
Product 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
General and Administrative Personnel
George Bottlieb, President $0 $0 $0 $0 $2,500 $3,000 $3,500 $4,000 $4,500 $5,000 $5,000 $5,000
Jay Rosenburg, Vice-President $0 $0 $0 $0 $0 $0 $0 $0 $0 $4,500 $4,500 $4,500
Receptionist / Administrative Assistant $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 $2,500 $3,000 $3,500 $4,000 $4,500 $9,500 $9,500 $9,500
Other Personnel
Contractor, Mechanical Design $0 $0 $0 $1,000 $0 $0 $0 $0 $0 $0 $0 $0
Contractor, PCB Design $2,000 $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 $2,000 $0 $0 $1,000 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 0 0 2 2 2 2 2 2 3 3 3
Total Payroll $2,000 $0 $0 $1,000 $2,500 $3,000 $3,500 $4,000 $5,700 $10,700 $10,700 $11,900
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 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 $97,000 $94,960 $93,767 $92,767 $92,342 $91,450 $90,650 $88,580 $85,911 $84,330 $76,479 $75,606 $72,410
Accounts Receivable $0 $0 $0 $0 $531 $1,576 $2,621 $4,197 $6,286 $8,907 $11,510 $14,663 $18,842
Inventory $6,000 $6,000 $6,000 $6,000 $4,600 $3,080 $4,620 $7,425 $10,395 $14,850 $17,160 $22,880 $28,600
Other Current Assets $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800
Total Current Assets $104,800 $102,760 $101,567 $100,567 $99,273 $97,906 $99,690 $102,002 $104,393 $109,888 $106,949 $114,949 $121,651
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $104,800 $102,760 $101,567 $100,567 $99,273 $97,906 $99,690 $102,002 $104,393 $109,888 $106,949 $114,949 $121,651
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 $1,160 $967 $967 $1,498 $2,881 $7,240 $10,977 $13,843 $19,358 $20,039 $28,459 $33,601
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000
Subtotal Current Liabilities $40,000 $41,160 $40,967 $40,967 $41,498 $42,881 $47,240 $50,977 $53,843 $59,358 $60,039 $68,459 $73,601
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $40,000 $41,160 $40,967 $40,967 $41,498 $42,881 $47,240 $50,977 $53,843 $59,358 $60,039 $68,459 $73,601
Paid-in Capital $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Retained Earnings ($35,200) ($35,200) ($35,200) ($35,200) ($35,200) ($35,200) ($35,200) ($35,200) ($35,200) ($35,200) ($35,200) ($35,200) ($35,200)
Earnings $0 ($3,200) ($4,200) ($5,200) ($7,025) ($9,775) ($12,350) ($13,775) ($14,250) ($14,270) ($17,890) ($18,310) ($16,750)
Total Capital $64,800 $61,600 $60,600 $59,600 $57,775 $55,025 $52,450 $51,025 $50,550 $50,530 $46,910 $46,490 $48,050
Total Liabilities and Capital $104,800 $102,760 $101,567 $100,567 $99,273 $97,906 $99,690 $102,002 $104,393 $109,888 $106,949 $114,949 $121,651
Net Worth $64,800 $61,600 $60,600 $59,600 $57,775 $55,025 $52,450 $51,025 $50,550 $50,530 $46,910 $46,490 $48,050
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 $0 $0 $0 $2,125 $4,250 $6,375 $10,625 $14,875 $21,250 $25,500 $34,000 $42,500
Direct Cost of Sales $0 $0 $0 $1,400 $2,800 $4,200 $6,750 $9,450 $13,500 $15,600 $20,800 $26,000
Production Payroll $0 $0 $0 $0 $0 $0 $0 $0 $1,200 $1,200 $1,200 $2,400
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $1,400 $2,800 $4,200 $6,750 $9,450 $14,700 $16,800 $22,000 $28,400
Gross Margin $0 $0 $0 $725 $1,450 $2,175 $3,875 $5,425 $6,550 $8,700 $12,000 $14,100
Gross Margin % 0.00% 0.00% 0.00% 34.12% 34.12% 34.12% 36.47% 36.47% 30.82% 34.12% 35.29% 33.18%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Advertising/Promotion $0 $0 $0 $100 $100 $100 $100 $150 $150 $150 $250 $250
Travel $0 $0 $0 $250 $250 $250 $250 $250 $250 $500 $500 $500
Miscellaneous $0 $0 $0 $100 $100 $100 $100 $100 $100 $100 $100 $100
Total Sales and Marketing Expenses $0 $0 $0 $450 $450 $450 $450 $500 $500 $750 $850 $850
Sales and Marketing % 0.00% 0.00% 0.00% 21.18% 10.59% 7.06% 4.24% 3.36% 2.35% 2.94% 2.50% 2.00%
General and Administrative Expenses
General and Administrative Payroll $0 $0 $0 $0 $2,500 $3,000 $3,500 $4,000 $4,500 $9,500 $9,500 $9,500
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Insurance $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Rent $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
Payroll Taxes 10% $200 $0 $0 $100 $250 $300 $350 $400 $570 $1,070 $1,070 $1,190
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $1,200 $1,000 $1,000 $1,100 $3,750 $4,300 $4,850 $5,400 $6,070 $11,570 $11,570 $11,690
General and Administrative % 0.00% 0.00% 0.00% 51.76% 88.24% 67.45% 45.65% 36.30% 28.56% 45.37% 34.03% 27.51%
Other Expenses:
Other Payroll $2,000 $0 $0 $1,000 $0 $0 $0 $0 $0 $0 $0 $0
Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Contract/Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Expenses $2,000 $0 $0 $1,000 $0 $0 $0 $0 $0 $0 $0 $0
Other % 0.00% 0.00% 0.00% 47.06% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Total Operating Expenses $3,200 $1,000 $1,000 $2,550 $4,200 $4,750 $5,300 $5,900 $6,570 $12,320 $12,420 $12,540
Profit Before Interest and Taxes ($3,200) ($1,000) ($1,000) ($1,825) ($2,750) ($2,575) ($1,425) ($475) ($20) ($3,620) ($420) $1,560
EBITDA ($3,200) ($1,000) ($1,000) ($1,825) ($2,750) ($2,575) ($1,425) ($475) ($20) ($3,620) ($420) $1,560
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($3,200) ($1,000) ($1,000) ($1,825) ($2,750) ($2,575) ($1,425) ($475) ($20) ($3,620) ($420) $1,560
Net Profit/Sales 0.00% 0.00% 0.00% -85.88% -64.71% -40.39% -13.41% -3.19% -0.09% -14.20% -1.24% 3.67%
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 $0 $0 $0 $1,594 $3,188 $4,781 $7,969 $11,156 $15,938 $19,125 $25,500 $31,875
Cash from Receivables $0 $0 $0 $0 $18 $549 $1,080 $1,629 $2,692 $3,772 $5,348 $6,446
Subtotal Cash from Operations $0 $0 $0 $1,594 $3,205 $5,330 $9,049 $12,785 $18,629 $22,897 $30,848 $38,321
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 $0 $0 $0 $1,594 $3,205 $5,330 $9,049 $12,785 $18,629 $22,897 $30,848 $38,321
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 $2,000 $0 $0 $1,000 $2,500 $3,000 $3,500 $4,000 $5,700 $10,700 $10,700 $11,900
Bill Payments $40 $1,193 $1,000 $1,018 $1,598 $3,130 $7,619 $11,454 $14,510 $20,049 $21,020 $29,617
Subtotal Spent on Operations $2,040 $1,193 $1,000 $2,018 $4,098 $6,130 $11,119 $15,454 $20,210 $30,749 $31,720 $41,517
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 $2,040 $1,193 $1,000 $2,018 $4,098 $6,130 $11,119 $15,454 $20,210 $30,749 $31,720 $41,517
Net Cash Flow ($2,040) ($1,193) ($1,000) ($425) ($892) ($800) ($2,070) ($2,668) ($1,581) ($7,852) ($872) ($3,197)
Cash Balance $94,960 $93,767 $92,767 $92,342 $91,450 $90,650 $88,580 $85,911 $84,330 $76,479 $75,606 $72,410