Sunapto

Start your own business plan »

Medicine Dispenser 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
MedCabinet PMA 0% 0 0 0 0 0 0 0 0 0 0 0 0
MedCabinet Monitor & Notification Service 0% 0 0 0 0 0 0 0 0 0 0 0 0
MedCabinet M&N Service Renewal 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 0 0 0 0 0 0 0 0 0
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
MedCabinet PMA $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00
MedCabinet Monitor & Notification Service $19.95 $19.95 $19.95 $19.95 $19.95 $19.95 $19.95 $19.95 $19.95 $19.95 $19.95 $19.95
MedCabinet M&N Service Renewal $19.95 $19.95 $19.95 $19.95 $19.95 $19.95 $19.95 $19.95 $19.95 $19.95 $19.95 $19.95
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
MedCabinet PMA $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
MedCabinet Monitor & Notification Service $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
MedCabinet M&N Service Renewal $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 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
MedCabinet PMA 0.00% $420.00 $420.00 $420.00 $420.00 $420.00 $420.00 $420.00 $420.00 $420.00 $420.00 $420.00 $420.00
MedCabinet Monitor & Notification Service 0.00% $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00
MedCabinet M&N Service Renewal 0.00% $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.00 $2.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
MedCabinet PMA $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
MedCabinet Monitor & Notification Service $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
MedCabinet M&N Service Renewal $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 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
Engineering Manager $7,909 $7,909 $7,909 $7,909 $7,909 $7,909 $7,909 $7,909 $7,909 $7,909 $7,909 $7,909
Software Engineer III $0 $0 $0 $1 $5,447 $5,447 $5,447 $5,447 $5,447 $5,447 $5,447 $5,447
Software Engineer II $0 $0 $0 $0 $0 $0 $4,254 $4,254 $4,254 $4,254 $4,254 $4,254
Database Administrator $0 $0 $0 $0 $0 $0 $4,776 $4,776 $4,776 $4,776 $4,776 $4,776
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $7,909 $7,909 $7,909 $7,910 $13,356 $13,356 $22,386 $22,386 $22,386 $22,386 $22,386 $22,386
Sales and Marketing Personnel
Sales and Marketing Director $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160
General and Administrative Personnel
President $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250
Business Office Manager $0 $0 $0 $0 $0 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800 $3,800
Administrative Assistant $0 $0 $0 $0 $0 $2,292 $2,292 $2,292 $2,292 $2,292 $2,292 $2,292
Controller $7,941 $7,941 $7,941 $7,941 $7,941 $7,941 $7,941 $7,941 $7,941 $7,941 $7,941 $7,941
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $14,191 $14,191 $14,191 $14,191 $14,191 $20,283 $20,283 $20,283 $20,283 $20,283 $20,283 $20,283
Other Personnel
Customer Service / Call Center Manager $0 $0 $0 $0 $0 $0 $3,795 $3,795 $3,795 $3,795 $3,795 $3,795
Customer Service Rep $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Customer Service Rep $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Customer Service Rep $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Customer Service Rep $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Customer Service Rep $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Webmaster $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 $3,795 $3,795 $3,795 $3,795 $3,795 $3,795
Total People 4 4 4 5 5 7 10 10 10 10 10 10
Total Payroll $29,260 $29,260 $29,260 $29,261 $34,707 $40,799 $53,624 $53,624 $53,624 $53,624 $53,624 $53,624
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% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Production Payroll $7,909 $7,909 $7,909 $7,910 $13,356 $13,356 $22,386 $22,386 $22,386 $22,386 $22,386 $22,386
Research and Development $43,750 $0 $0 $43,750 $0 $0 $43,750 $0 $0 $43,750 $0 $0
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $51,659 $7,909 $7,909 $51,660 $13,356 $13,356 $66,136 $22,386 $22,386 $66,136 $22,386 $22,386
Gross Margin ($51,659) ($7,909) ($7,909) ($51,660) ($13,356) ($13,356) ($66,136) ($22,386) ($22,386) ($66,136) ($22,386) ($22,386)
Gross Margin % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160 $7,160
Contract Sales Organization $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $25,000 $25,000
Advertising/Promotions $0 $0 $0 $47,925 $0 $0 $47,925 $0 $0 $47,925 $0 $0
Travel $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Sales Commissions $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Legal $0 $0 $0 $0 $0 $0 $12,000 $0 $0 $0 $0 $0
Miscellaneous $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Total Sales and Marketing Expenses $7,860 $7,860 $7,860 $55,785 $7,860 $7,860 $67,785 $7,860 $7,860 $55,785 $32,860 $32,860
Sales and Marketing % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
General and Administrative Expenses
General and Administrative Payroll $14,191 $14,191 $14,191 $14,191 $14,191 $20,283 $20,283 $20,283 $20,283 $20,283 $20,283 $20,283
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 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Insurance $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Office Equipment $12,000 $0 $0 $3,000 $0 $6,000 $9,000 $0 $0 $0 $0 $0
Office Supplies $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Rent $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Payroll Taxes 30% $8,778 $8,778 $8,778 $8,778 $10,412 $12,240 $16,087 $16,087 $16,087 $16,087 $16,087 $16,087
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $44,469 $32,469 $32,469 $35,469 $34,103 $48,023 $54,870 $45,870 $45,870 $45,870 $45,870 $45,870
General and Administrative % 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 Expenses:
Other Payroll $0 $0 $0 $0 $0 $0 $3,795 $3,795 $3,795 $3,795 $3,795 $3,795
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 $0 $0 $0 $0 $0 $0 $3,795 $3,795 $3,795 $3,795 $3,795 $3,795
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 $52,329 $40,329 $40,329 $91,254 $41,963 $55,883 $126,450 $57,525 $57,525 $105,450 $82,525 $82,525
Profit Before Interest and Taxes ($103,988) ($48,238) ($48,238) ($142,914) ($55,319) ($69,239) ($192,586) ($79,911) ($79,911) ($171,586) ($104,911) ($104,911)
EBITDA ($103,988) ($48,238) ($48,238) ($142,914) ($55,319) ($69,239) ($192,586) ($79,911) ($79,911) ($171,586) ($104,911) ($104,911)
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 ($103,988) ($48,238) ($48,238) ($142,914) ($55,319) ($69,239) ($192,586) ($79,911) ($79,911) ($171,586) ($104,911) ($104,911)
Net Profit/Sales 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
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 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash from Operations $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $710,000 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $0 $0 $0 $0 $0 $710,000 $0 $0 $0 $0 $0
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 $29,260 $29,260 $29,260 $29,261 $34,707 $40,799 $53,624 $53,624 $53,624 $53,624 $53,624 $53,624
Bill Payments $2,491 $72,870 $18,978 $22,134 $110,552 $20,873 $32,124 $135,207 $26,287 $29,343 $115,740 $51,287
Subtotal Spent on Operations $31,751 $102,130 $48,238 $51,395 $145,259 $61,672 $85,748 $188,831 $79,911 $82,967 $169,364 $104,911
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 $31,751 $102,130 $48,238 $51,395 $145,259 $61,672 $85,748 $188,831 $79,911 $82,967 $169,364 $104,911
Net Cash Flow ($31,751) ($102,130) ($48,238) ($51,395) ($145,259) ($61,672) $624,252 ($188,831) ($79,911) ($82,967) ($169,364) ($104,911)
Cash Balance $438,249 $336,119 $287,881 $236,487 $91,227 $29,555 $653,808 $464,977 $385,066 $302,099 $132,735 $27,824
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 $470,000 $438,249 $336,119 $287,881 $236,487 $91,227 $29,555 $653,808 $464,977 $385,066 $302,099 $132,735 $27,824
Accounts Receivable $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Inventory $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $470,000 $438,249 $336,119 $287,881 $236,487 $91,227 $29,555 $653,808 $464,977 $385,066 $302,099 $132,735 $27,824
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 $470,000 $438,249 $336,119 $287,881 $236,487 $91,227 $29,555 $653,808 $464,977 $385,066 $302,099 $132,735 $27,824
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 $72,237 $18,345 $18,345 $109,865 $19,925 $27,492 $134,330 $25,411 $25,411 $114,030 $49,578 $49,578
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 $72,237 $18,345 $18,345 $109,865 $19,925 $27,492 $134,330 $25,411 $25,411 $114,030 $49,578 $49,578
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $72,237 $18,345 $18,345 $109,865 $19,925 $27,492 $134,330 $25,411 $25,411 $114,030 $49,578 $49,578
Paid-in Capital $472,713 $472,713 $472,713 $472,713 $472,713 $472,713 $472,713 $1,182,713 $1,182,713 $1,182,713 $1,182,713 $1,182,713 $1,182,713
Retained Earnings ($2,713) ($2,713) ($2,713) ($2,713) ($2,713) ($2,713) ($2,713) ($2,713) ($2,713) ($2,713) ($2,713) ($2,713) ($2,713)
Earnings $0 ($103,988) ($152,226) ($200,464) ($343,378) ($398,698) ($467,936) ($660,523) ($740,434) ($820,345) ($991,931) ($1,096,843) ($1,201,754)
Total Capital $470,000 $366,012 $317,774 $269,536 $126,622 $71,302 $2,064 $519,477 $439,566 $359,655 $188,069 $83,157 ($21,754)
Total Liabilities and Capital $470,000 $438,249 $336,119 $287,881 $236,487 $91,227 $29,555 $653,808 $464,977 $385,066 $302,099 $132,735 $27,824
Net Worth $470,000 $366,012 $317,774 $269,536 $126,622 $71,302 $2,064 $519,477 $439,566 $359,655 $188,069 $83,157 ($21,754)