Start-up | |
Requirements | |
Start-up Expenses | |
Legal | $1,000 |
Stationery etc. | $500 |
Insurance | $1,000 |
Rent | $1,000 |
Research and Development | $100,000 |
Expensed Equipment | $12,000 |
Total Start-up Expenses | $115,500 |
Start-up Assets | |
Cash Required | $174,500 |
Other Current Assets | $10,000 |
Long-term Assets | $0 |
Total Assets | $184,500 |
Total Requirements | $300,000 |
Royal’s Software products and services include the following:
In addition to selling software, the company will provide extensive customization services to meet the unique needs of its business customers.
Software products for inventory management are a $1 billion dollar industry. The lions share of the sales are with the largest companies with billions of dollars of inventory. This is where there is the greatest competition between inventory software products.
This category of the industry also faces competition from the enterprise resource planning software vendors. At the low end, with small and emerging businesses, there is very little competition.
Usually, the smaller businesses will spend no more than $5,000 on an inventory solution which will include software and hardware. Royal’s Software believes this a tremendous opportunity for a software product with a $2,500 price tag.
Another opportunity area is the growing demand for software interfaces that improve the portability of data. The interface improves the ability of businesses to move data between systems. In an age where new management products are introduced each year, a company’s ability to move its data quickly and efficiently is becoming essential to a successful business.
MAS 90 portable data collection interface is designed to be used by accounting firms to improve the portability of data the firms stores for customers.
Royal’s Software is targeting small- and medium-sized businesses. Specifically it will focus on these two target groups:
Market Analysis | |||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||
Potential Customers | Growth | CAGR | |||||
Smaller Businesses | 10% | 5,000 | 5,500 | 6,050 | 6,655 | 7,321 | 10.00% |
Accounting Firms | 15% | 150 | 173 | 199 | 229 | 263 | 15.07% |
Total | 10.16% | 5,150 | 5,673 | 6,249 | 6,884 | 7,584 | 10.16% |
During the first two months of operation, the company will focus on completing and testing beta copies of Royal’s Inventory Basic and the MAS 90 portable data collection interface. Sales will begin in May and grow steadily for the next 10 months.
Royal’s Software will not do any direct selling, instead it will work closely with Pursuit Solutions’ VARs to sell and service Royal’s Inventory Basic. The two owners have existing relationships with a number of VARs through their existing positions, and since this product is unique in its price range, it is not expected that it will be difficult to find VARs to represent it.
MAS 90 customers will be developed by the CPA firm, Johnson and Roe. It is projected that the MAS 90 product will have over a 100 customers by June of 2003. A large number of small- to medium-sized businesses use MAS 90 in their dealings with Johnson and Roe, and it is expected that sales will be healthy through this channel.
The following is the sales forecast for the next three years.
Sales Forecast | |||
Year 1 | Year 2 | Year 3 | |
Sales | |||
MAS-90 | $194,000 | $230,000 | $280,000 |
Royal’s Inventory Basic | $179,000 | $220,000 | $270,000 |
Custom Consultation/Adptation | $151,000 | $200,000 | $230,000 |
Total Sales | $524,000 | $650,000 | $780,000 |
Direct Cost of Sales | Year 1 | Year 2 | Year 3 |
MAS-90 | $5,820 | $6,900 | $8,400 |
Royal’s Inventory Basic | $5,370 | $6,600 | $8,100 |
Custom Consultation/Adptation | $0 | $0 | $0 |
Subtotal Direct Cost of Sales | $11,190 | $13,500 | $16,500 |
The current staff of Royal’s Software are the two co-owners of the company. The owners have been working on developing the product on their own time over the past year, are beta testing the product and now feel that they are only a couple of months away from having a final product. It is envisioned that Royal’s will need to ramp up significantly as sales take off and they are pulled away from product development and support in order to run the company. Three new hires are planned in March to meet the anticipated demands of software sales. The following positions will be filled:
To keep fixed costs to a minium and to keep existing technical staff committed to the development of new products, much of the customization will be done by outside consultants. This expense is illustrated in the profit and loss table.
In addition, we will not have large sales and marketing costs, because VARS will take on this role on our behalf, and their large commissions shall reflect this.
Personnel Plan | |||
Year 1 | Year 2 | Year 3 | |
CEO | $0 | $100,000 | $150,000 |
John Royal | $65,000 | $68,000 | $71,000 |
Dan Whiteaker | $65,000 | $68,000 | $71,000 |
Application Engineer | $60,000 | $63,000 | $66,000 |
Support Engineer | $50,000 | $52,000 | $54,000 |
Tech Support Staff | $30,000 | $32,000 | $34,000 |
Total People | 6 | 6 | 6 |
Total Payroll | $270,000 | $383,000 | $446,000 |
The following is the financial plan for Royal’s Software. The plan includes:
The estimated monthly fixed cost and monthly break-even point are shown below.
Break-even Analysis | |
Monthly Revenue Break-even | $37,152 |
Assumptions: | |
Average Percent Variable Cost | 2% |
Estimated Monthly Fixed Cost | $36,358 |
The following table and charts highlight the projected profit and loss for the next three years.
Pro Forma Profit and Loss | |||
Year 1 | Year 2 | Year 3 | |
Sales | $524,000 | $650,000 | $780,000 |
Direct Cost of Sales | $11,190 | $13,500 | $16,500 |
Other Production Expenses | $0 | $0 | $0 |
Total Cost of Sales | $11,190 | $13,500 | $16,500 |
Gross Margin | $512,810 | $636,500 | $763,500 |
Gross Margin % | 97.86% | 97.92% | 97.88% |
Expenses | |||
Payroll | $270,000 | $383,000 | $446,000 |
Sales and Marketing and Other Expenses | $101,600 | $146,000 | $174,000 |
Depreciation | $0 | $0 | $0 |
Leased Equipment | $5,000 | $0 | $0 |
Utilities | $4,800 | $4,800 | $4,800 |
Insurance | $2,400 | $2,400 | $2,400 |
Rent | $12,000 | $12,000 | $12,000 |
Payroll Taxes | $40,500 | $57,450 | $66,900 |
Other | $0 | $0 | $0 |
Total Operating Expenses | $436,300 | $605,650 | $706,100 |
Profit Before Interest and Taxes | $76,510 | $30,850 | $57,400 |
EBITDA | $76,510 | $30,850 | $57,400 |
Interest Expense | $8,917 | $7,001 | $5,002 |
Taxes Incurred | $20,278 | $7,155 | $15,719 |
Net Profit | $47,315 | $16,694 | $36,679 |
Net Profit/Sales | 9.03% | 2.57% | 4.70% |
The following table and chart highlight the projected cash flow for the next three years.
Pro Forma Cash Flow | |||
Year 1 | Year 2 | Year 3 | |
Cash Received | |||
Cash from Operations | |||
Cash Sales | $131,000 | $162,500 | $195,000 |
Cash from Receivables | $307,375 | $466,911 | $563,757 |
Subtotal Cash from Operations | $438,375 | $629,411 | $758,757 |
Additional Cash Received | |||
Sales Tax, VAT, HST/GST Received | $0 | $0 | $0 |
New Current Borrowing | $0 | $0 | $0 |
New Other Liabilities (interest-free) | $0 | $0 | $0 |
New Long-term Liabilities | $0 | $0 | $0 |
Sales of Other Current Assets | $0 | $0 | $0 |
Sales of Long-term Assets | $0 | $0 | $0 |
New Investment Received | $0 | $0 | $0 |
Subtotal Cash Received | $438,375 | $629,411 | $758,757 |
Expenditures | Year 1 | Year 2 | Year 3 |
Expenditures from Operations | |||
Cash Spending | $270,000 | $383,000 | $446,000 |
Bill Payments | $177,952 | $258,466 | $293,457 |
Subtotal Spent on Operations | $447,952 | $641,466 | $739,457 |
Additional Cash Spent | |||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 |
Principal Repayment of Current Borrowing | $0 | $0 | $0 |
Other Liabilities Principal Repayment | $0 | $0 | $0 |
Long-term Liabilities Principal Repayment | $19,992 | $19,992 | $19,992 |
Purchase Other Current Assets | $0 | $0 | $0 |
Purchase Long-term Assets | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 |
Subtotal Cash Spent | $467,944 | $661,458 | $759,449 |
Net Cash Flow | ($29,569) | ($32,047) | ($692) |
Cash Balance | $144,931 | $112,884 | $112,192 |
The following table highlights the projected balance sheet for the next three years.
Pro Forma Balance Sheet | |||
Year 1 | Year 2 | Year 3 | |
Assets | |||
Current Assets | |||
Cash | $144,931 | $112,884 | $112,192 |
Accounts Receivable | $85,625 | $106,214 | $127,457 |
Other Current Assets | $10,000 | $10,000 | $10,000 |
Total Current Assets | $240,556 | $229,098 | $249,649 |
Long-term Assets | |||
Long-term Assets | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $0 | $0 |
Total Long-term Assets | $0 | $0 | $0 |
Total Assets | $240,556 | $229,098 | $249,649 |
Liabilities and Capital | Year 1 | Year 2 | Year 3 |
Current Liabilities | |||
Accounts Payable | $28,733 | $20,573 | $24,437 |
Current Borrowing | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 |
Subtotal Current Liabilities | $28,733 | $20,573 | $24,437 |
Long-term Liabilities | $80,008 | $60,016 | $40,024 |
Total Liabilities | $108,741 | $80,589 | $64,461 |
Paid-in Capital | $200,000 | $200,000 | $200,000 |
Retained Earnings | ($115,500) | ($68,185) | ($51,491) |
Earnings | $47,315 | $16,694 | $36,679 |
Total Capital | $131,815 | $148,509 | $185,188 |
Total Liabilities and Capital | $240,556 | $229,098 | $249,649 |
Net Worth | $131,815 | $148,509 | $185,188 |
Industry profile ratios based on the Standard Industrial Classification (SIC) code 7372, Prepackaged Software, are shown for comparison.
Ratio Analysis | ||||
Year 1 | Year 2 | Year 3 | Industry Profile | |
Sales Growth | 0.00% | 24.05% | 20.00% | 9.70% |
Percent of Total Assets | ||||
Accounts Receivable | 35.59% | 46.36% | 51.05% | 21.50% |
Other Current Assets | 4.16% | 4.36% | 4.01% | 45.70% |
Total Current Assets | 100.00% | 100.00% | 100.00% | 70.20% |
Long-term Assets | 0.00% | 0.00% | 0.00% | 29.80% |
Total Assets | 100.00% | 100.00% | 100.00% | 100.00% |
Current Liabilities | 11.94% | 8.98% | 9.79% | 42.40% |
Long-term Liabilities | 33.26% | 26.20% | 16.03% | 19.20% |
Total Liabilities | 45.20% | 35.18% | 25.82% | 61.60% |
Net Worth | 54.80% | 64.82% | 74.18% | 38.40% |
Percent of Sales | ||||
Sales | 100.00% | 100.00% | 100.00% | 100.00% |
Gross Margin | 97.86% | 97.92% | 97.88% | 100.00% |
Selling, General & Administrative Expenses | 88.83% | 95.35% | 93.18% | 79.40% |
Advertising Expenses | 10.00% | 10.00% | 10.00% | 1.30% |
Profit Before Interest and Taxes | 14.60% | 4.75% | 7.36% | 2.20% |
Main Ratios | ||||
Current | 8.37 | 11.14 | 10.22 | 1.51 |
Quick | 8.37 | 11.14 | 10.22 | 1.16 |
Total Debt to Total Assets | 45.20% | 35.18% | 25.82% | 61.60% |
Pre-tax Return on Net Worth | 51.28% | 16.06% | 28.29% | 3.50% |
Pre-tax Return on Assets | 28.10% | 10.41% | 20.99% | 9.20% |
Additional Ratios | Year 1 | Year 2 | Year 3 | |
Net Profit Margin | 9.03% | 2.57% | 4.70% | n.a |
Return on Equity | 35.90% | 11.24% | 19.81% | n.a |
Activity Ratios | ||||
Accounts Receivable Turnover | 4.59 | 4.59 | 4.59 | n.a |
Collection Days | 56 | 72 | 73 | n.a |
Accounts Payable Turnover | 7.19 | 12.17 | 12.17 | n.a |
Payment Days | 31 | 36 | 28 | n.a |
Total Asset Turnover | 2.18 | 2.84 | 3.12 | n.a |
Debt Ratios | ||||
Debt to Net Worth | 0.82 | 0.54 | 0.35 | n.a |
Current Liab. to Liab. | 0.26 | 0.26 | 0.38 | n.a |
Liquidity Ratios | ||||
Net Working Capital | $211,823 | $208,525 | $225,212 | n.a |
Interest Coverage | 8.58 | 4.41 | 11.48 | n.a |
Additional Ratios | ||||
Assets to Sales | 0.46 | 0.35 | 0.32 | n.a |
Current Debt/Total Assets | 12% | 9% | 10% | n.a |
Acid Test | 5.39 | 5.97 | 5.00 | n.a |
Sales/Net Worth | 3.98 | 4.38 | 4.21 | n.a |
Dividend Payout | 0.00 | 0.00 | 0.00 | n.a |
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 | |||||||||||||
MAS-90 | 0% | $0 | $0 | $12,000 | $15,000 | $18,000 | $20,000 | $20,000 | $22,000 | $24,000 | $20,000 | $21,000 | $22,000 |
Royal’s Inventory Basic | 0% | $0 | $0 | $12,000 | $15,000 | $18,000 | $21,000 | $20,000 | $21,000 | $20,000 | $15,000 | $17,000 | $20,000 |
Custom Consultation/Adptation | 0% | $0 | $0 | $6,000 | $9,000 | $12,000 | $18,000 | $20,000 | $18,000 | $14,000 | $18,000 | $17,000 | $19,000 |
Total Sales | $0 | $0 | $30,000 | $39,000 | $48,000 | $59,000 | $60,000 | $61,000 | $58,000 | $53,000 | $55,000 | $61,000 | |
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 | |
MAS-90 | $0 | $0 | $360 | $450 | $540 | $600 | $600 | $660 | $720 | $600 | $630 | $660 | |
Royal’s Inventory Basic | $0 | $0 | $360 | $450 | $540 | $630 | $600 | $630 | $600 | $450 | $510 | $600 | |
Custom Consultation/Adptation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $0 | $720 | $900 | $1,080 | $1,230 | $1,200 | $1,290 | $1,320 | $1,050 | $1,140 | $1,260 |
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 | ||
CEO | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
John Royal | 0% | $5,000 | $5,000 | $7,500 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $7,500 | $5,000 | $5,000 |
Dan Whiteaker | 0% | $5,000 | $5,000 | $7,500 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $7,500 | $5,000 | $5,000 |
Application Engineer | 0% | $4,615 | $4,615 | $6,922 | $4,615 | $4,615 | $4,615 | $4,615 | $4,617 | $4,616 | $6,924 | $4,616 | $4,615 |
Support Engineer | 0% | $3,842 | $3,842 | $5,769 | $3,848 | $3,850 | $3,842 | $3,842 | $3,850 | $3,850 | $5,769 | $3,850 | $3,846 |
Tech Support Staff | 0% | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
Total Payroll | $20,957 | $20,957 | $30,191 | $20,963 | $20,965 | $20,957 | $20,957 | $20,967 | $20,966 | $30,193 | $20,966 | $20,961 |
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 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 | $30,000 | $39,000 | $48,000 | $59,000 | $60,000 | $61,000 | $58,000 | $53,000 | $55,000 | $61,000 | |
Direct Cost of Sales | $0 | $0 | $720 | $900 | $1,080 | $1,230 | $1,200 | $1,290 | $1,320 | $1,050 | $1,140 | $1,260 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $720 | $900 | $1,080 | $1,230 | $1,200 | $1,290 | $1,320 | $1,050 | $1,140 | $1,260 | |
Gross Margin | $0 | $0 | $29,280 | $38,100 | $46,920 | $57,770 | $58,800 | $59,710 | $56,680 | $51,950 | $53,860 | $59,740 | |
Gross Margin % | 0.00% | 0.00% | 97.60% | 97.69% | 97.75% | 97.92% | 98.00% | 97.89% | 97.72% | 98.02% | 97.93% | 97.93% | |
Expenses | |||||||||||||
Payroll | $20,957 | $20,957 | $30,191 | $20,963 | $20,965 | $20,957 | $20,957 | $20,967 | $20,966 | $30,193 | $20,966 | $20,961 | |
Sales and Marketing and Other Expenses | $0 | $0 | $6,000 | $6,900 | $8,300 | $9,800 | $10,000 | $10,200 | $9,600 | $12,200 | $13,400 | $15,200 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Leased Equipment | $5,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Insurance | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Rent | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Payroll Taxes | 15% | $3,144 | $3,144 | $4,529 | $3,144 | $3,145 | $3,144 | $3,144 | $3,145 | $3,145 | $4,529 | $3,145 | $3,144 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $30,701 | $25,701 | $42,320 | $32,607 | $34,010 | $35,501 | $35,701 | $35,912 | $35,311 | $48,522 | $39,111 | $40,905 | |
Profit Before Interest and Taxes | ($30,701) | ($25,701) | ($13,040) | $5,493 | $12,910 | $22,269 | $23,099 | $23,798 | $21,369 | $3,428 | $14,749 | $18,835 | |
EBITDA | ($30,701) | ($25,701) | ($13,040) | $5,493 | $12,910 | $22,269 | $23,099 | $23,798 | $21,369 | $3,428 | $14,749 | $18,835 | |
Interest Expense | $819 | $806 | $792 | $778 | $764 | $750 | $736 | $722 | $708 | $695 | $681 | $667 | |
Taxes Incurred | ($9,456) | ($7,952) | ($4,149) | $1,414 | $3,644 | $6,456 | $6,709 | $6,923 | $6,198 | $820 | $4,221 | $5,450 | |
Net Profit | ($22,064) | ($18,554) | ($9,682) | $3,300 | $8,502 | $15,064 | $15,654 | $16,153 | $14,463 | $1,913 | $9,848 | $12,718 | |
Net Profit/Sales | 0.00% | 0.00% | -32.27% | 8.46% | 17.71% | 25.53% | 26.09% | 26.48% | 24.94% | 3.61% | 17.91% | 20.85% |
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 | $7,500 | $9,750 | $12,000 | $14,750 | $15,000 | $15,250 | $14,500 | $13,250 | $13,750 | $15,250 | |
Cash from Receivables | $0 | $0 | $0 | $750 | $22,725 | $29,475 | $36,275 | $44,275 | $45,025 | $45,675 | $43,375 | $39,800 | |
Subtotal Cash from Operations | $0 | $0 | $7,500 | $10,500 | $34,725 | $44,225 | $51,275 | $59,525 | $59,525 | $58,925 | $57,125 | $55,050 | |
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 | $7,500 | $10,500 | $34,725 | $44,225 | $51,275 | $59,525 | $59,525 | $58,925 | $57,125 | $55,050 | |
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 | $20,957 | $20,957 | $30,191 | $20,963 | $20,965 | $20,957 | $20,957 | $20,967 | $20,966 | $30,193 | $20,966 | $20,961 | |
Bill Payments | $37 | ($1,333) | ($2,006) | $9,666 | $14,863 | $18,681 | $22,993 | $23,405 | $23,836 | $22,516 | $21,003 | $24,291 | |
Subtotal Spent on Operations | $20,994 | $19,624 | $28,185 | $30,629 | $35,828 | $39,638 | $43,950 | $44,372 | $44,802 | $52,709 | $41,969 | $45,252 | |
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 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | $1,666 | |
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 | $22,660 | $21,290 | $29,851 | $32,295 | $37,494 | $41,304 | $45,616 | $46,038 | $46,468 | $54,375 | $43,635 | $46,918 | |
Net Cash Flow | ($22,660) | ($21,290) | ($22,351) | ($21,795) | ($2,769) | $2,921 | $5,659 | $13,487 | $13,057 | $4,550 | $13,490 | $8,132 | |
Cash Balance | $151,840 | $130,550 | $108,199 | $86,404 | $83,635 | $86,556 | $92,215 | $105,702 | $118,759 | $123,309 | $136,799 | $144,931 |
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 | $174,500 | $151,840 | $130,550 | $108,199 | $86,404 | $83,635 | $86,556 | $92,215 | $105,702 | $118,759 | $123,309 | $136,799 | $144,931 |
Accounts Receivable | $0 | $0 | $0 | $22,500 | $51,000 | $64,275 | $79,050 | $87,775 | $89,250 | $87,725 | $81,800 | $79,675 | $85,625 |
Other Current Assets | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
Total Current Assets | $184,500 | $161,840 | $140,550 | $140,699 | $147,404 | $157,910 | $175,606 | $189,990 | $204,952 | $216,484 | $215,109 | $226,474 | $240,556 |
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 | $184,500 | $161,840 | $140,550 | $140,699 | $147,404 | $157,910 | $175,606 | $189,990 | $204,952 | $216,484 | $215,109 | $226,474 | $240,556 |
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,070 | $0 | $11,497 | $16,568 | $20,237 | $24,536 | $24,932 | $25,407 | $24,142 | $22,520 | $25,702 | $28,733 |
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 | $1,070 | $0 | $11,497 | $16,568 | $20,237 | $24,536 | $24,932 | $25,407 | $24,142 | $22,520 | $25,702 | $28,733 |
Long-term Liabilities | $100,000 | $98,334 | $96,668 | $95,002 | $93,336 | $91,670 | $90,004 | $88,338 | $86,672 | $85,006 | $83,340 | $81,674 | $80,008 |
Total Liabilities | $100,000 | $99,404 | $96,668 | $106,499 | $109,904 | $111,907 | $114,540 | $113,270 | $112,079 | $109,148 | $105,860 | $107,376 | $108,741 |
Paid-in Capital | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 |
Retained Earnings | ($115,500) | ($115,500) | ($115,500) | ($115,500) | ($115,500) | ($115,500) | ($115,500) | ($115,500) | ($115,500) | ($115,500) | ($115,500) | ($115,500) | ($115,500) |
Earnings | $0 | ($22,064) | ($40,618) | ($50,300) | ($47,000) | ($38,497) | ($23,434) | ($7,780) | $8,373 | $22,836 | $24,749 | $34,597 | $47,315 |
Total Capital | $84,500 | $62,436 | $43,882 | $34,200 | $37,500 | $46,003 | $61,066 | $76,720 | $92,873 | $107,336 | $109,249 | $119,097 | $131,815 |
Total Liabilities and Capital | $184,500 | $161,840 | $140,550 | $140,699 | $147,404 | $157,910 | $175,606 | $189,990 | $204,952 | $216,484 | $215,109 | $226,474 | $240,556 |
Net Worth | $84,500 | $62,436 | $43,882 | $34,200 | $37,500 | $46,003 | $61,066 | $76,720 | $92,873 | $107,336 | $109,249 | $119,097 | $131,815 |
Fill-in-the-blanks and automatic financials make it easy.
No thanks, I prefer writing 40-page documents.
Discover the world’s #1 plan building software
Related Pages
Everything you need to know to stay on top of the inventory management process..
Managing inventory strategically has never been more important, and it only gets more challenging as you grow in both product development and units sold.
Let’s talk. our experts can help you boost your order volume by 30% year over year..
A fulfillment expert will get back to you shortly. Privacy Policy
Inventory management is the management and monitoring process of a company’s stocked goods (inventory). Inventory management is vital for supply chain management in online, omnichannel, and brick-and-mortar businesses, and includes ordering and restocking inventory, storing inventory, adjusting frequency, order quantity, and inventory forecasting for the final point of sale.
Managing inventory the right way is crucial, especially for growing ecommerce businesses. Here’s why.
Part of inventory management is figuring out how much inventory you should have on hand at all times. Too much inventory, and you risk ‘ dead stock ’: inventory that can no longer be sold due to being outdated. Too little, and you’ll run out of stock, fail to meet customer demands, and miss out on potential sales.
By using a reorder point formula , you can ensure that you keep an eye on your inventory so that it doesn’t dip below a critical level. (More on this later.)
Too much inventory can result in too much money spent on storage space. Storing inventory is a variable cost — it’s based on how much space your beginning inventory takes up at any given time. When you have more product on hand than you need, you end up paying more for inventory storage . Being smart about inventory levels can help you reallocate those funds.
It pays to be prepared. Do you know what you’d do if any of the following supply chain mishaps took place tomorrow?
Strategic inventory solutions can help you get out of these sticky situations. Tracking inventory over time and having contingency plans in place for potential inventory problems will prepare you for situations that would otherwise seriously impact your business.
Keeping track of what inventory sells like hotcakes versus what ends up covered in metaphorical cobwebs can share some important insight about what your customers are — and aren’t — into. You can also gauge the success of prior promotions or product launches by assessing inventory levels before and after those events.
Well, kind of. Good inventory management lends itself to good inventory forecasting, which can help you predict and plan for demand. You can leverage past inventory trends on a monthly, seasonal, or SKU-by-SKU level to better prepare for future levels of sales and demand. Make sure to keep any planned marketing promotions or new product launches in mind, too.
Inventory accounting is when you track and account for changes in the value of inventory over time as it relates to manufacturing and costs of goods sold. If you don’t have an accurate method for keeping track of the value of your inventory, you can’t properly value your assets or goods sold and budget for the inventory you need to buy for your business.
There are countless inventory management techniques to employ, but here are some of the basics that ecommerce teams need to get right in today’s world.
Also called par levels, reorder points are the minimum quantity of each product that must be on hand that signals it’s time to order more inventory in order to prevent stockouts. When your inventory level hit the reorder point, it’s time to order more products from your manufacturer.
To calculate reorder points for your products, add up the following (in days):
Then, multiply the sum of 1, 2, and 3 by your average units of the product sold per day. This number is your reorder point.
Although it requires some math upfront, setting reorder points will help streamline and take the guess out of restocking inventory.
Make sure that you check your reorder points over time and adjust as necessary, especially before peak times like the holidays when you’re likely to need more holiday inventory on hand. At this time, you might need to increase both your reorder points and reorder quantity .
“First-in, first-out,” aka FIFO, is an inventory management principle that means that your oldest inventory (first-in) gets sold and shipped out first (first-out). This is especially important if you’re selling perishable products or those with expiration dates.
Even if your goods are shelf-stable, FIFO can still be a good strategy. Because packaging, design and branding, and product features tend to change over time, it’s important to change out inventory so you don’t end up with obsolete products.
If you’re storing inventory and fulfilling purchase orders in-house, you’ll have to monitor this manually. If you’re outsourcing to a third-party logistics (3PL) provider, they’ll likely be able to implement a FIFO system for you.
While auditing physical inventory is often tedious, it’s important to check actual inventory levels against the amount of inventory you have listed electronically. If you work with a third-party provider, you’ll probably be relying on their software system and reporting to keep track of inventory levels. However, it’s important to make sure that the system’s numbers match up with your physical stock.
Spot checking can be a more manageable way to keep inventory audits under control in between full physical inventory audits. This means choosing a specific product, counting the number of units on hand, and comparing it to the number of units listed in the system or inventory sheet .
This is especially helpful if you have a large product catalog with lots of different SKUs. Inventory management technology can help simplify this process by prompting a spot check when the system marks the product stock as zero.
After checking your inventory levels, it’s important to have regularly updated backups of this data. This can be as simple as exporting the data from your inventory management software to a CSV file at least once per week. Additionally, you can set up automatic backups of the inventory levels provided in your ecommerce platform using apps like this one .
Choosing the right manufacturer is a huge step for growing businesses to find the most cost-effective and efficient partner that can help elevate growth. But finding the right supplier for your business is just the beginning. Maintaining a good relationship with your manufacturer will ensure they’re a partner in inventory management rather than an obstacle.
Make sure to communicate frequently with your manufacturer, especially when you’re anticipating an increase in sales or they’re running behind schedule on production.
If you have inventory quality issues, a product that won’t sell, a product that sells out more quickly than anticipated, or any other situation that calls for production adjustments, having a good relationship with your supplier will help your retail supply chain run more smoothly.
Software that is specifically designed to help you manage your inventory, whether in-house or in a 3PL’s warehouse, can help avoid losing money from unsold products, inventory reports on stock levels and trends in real-time, and offer suggestions for inventory distribution. It can also help automate several of the techniques above, saving time and potential human errors for your business.
“We have a Shopify store but do not use Shopify to track inventory. In terms of tracking inventory, we use ShipBob for everything — to be able to track each bottle of perfume, what we have left, and what we’ve shipped, while getting a lot more information on each order.” Ines Guien, Vice President of Operations at Dossier
Knowing which SKUs you have in your possession, their locations in storage, and the quantities available at each location is mission critical for ecommerce brands. Real-time inventory management involves implementing technology that enables the ability to track inventory flow , and view and manage inventory levels throughout the ecommerce supply chain on demand.
This level of inventory visibility is the first inventory management technique to nail, as without it, you can’t measure efficiency and improvements, know when to order more products, or refine your strategy as you grow.
The right tools, technology, processes, and infrastructure can help you not only forecast demand and optimize storage but also understand when you should expand into another fulfillment center, or even in new markets.
Inventory allocation involves strategically tracking inventory levels across a distribution network to meet customer demand efficiently, while accounting for each unit sold across each channel and fulfilled from each location.
With global supply chain shortages, manufacturer shutdowns due to COVID outbreaks, and rising costs, diversifying your supplier or manufacturer mix is another great way to optimize inventory control and reduce risk.
Once you’ve optimized your inventory, you should be able to understand whether it makes sense to expand your product line by selling complementary or supplemental products. Common examples include introducing a best-selling item in a variety of new colors, or expanding from selling just peanut butter, to a variety of jellies and jams.
SKU proliferation refers to the process of adding more products to your inventory based on changes in the market and to attract more buyers to increase your sales.
One of the best things some brands can do to optimize inventory management is to cut back on the products they sell (yes, you read that correctly!).
SKU rationalization is the process of identifying whether a product at the SKU level should be discontinued due to declining sales and overall profitability.
By understanding this, in addition to having the ability to track inventory performance, you can focus on your fastest-moving products and double down on profitability.
Inventory analytics are metrics that gauge the movement and performance of your physical products. The ongoing assessment and evaluation of inventory provides:
Check out our 15 most valuable inventory KPIs to keep track of and example Inventory reports .
An inventory management system is a necessity for growing ecommerce businesses. Here’s why.
With inventory tracking software in place, your orders and inventory are synced in real-time. At any given time, you can view the status of inventory you send to various partners, the quantity on hand at your storage facility, and total units sold per day. This provides reassurance and visibility into what is available to ship to your customers, as well as the real-time impact of promotions and product launches.
Using historical data, inventory management software can help project when you should order more inventory to prevent stockouts. This helps take the guesswork out of reorder points. Some inventory systems also allow you to set reorder notification points that automatically alert you to restock.
Inventory software can automate reporting on product trends and inventory forecasting for your retail business.
An inventory management solution can help you better predict future demand and sales. Monitoring which products are purchased together can help you understand your customers’ behavior and help you decide how to group your products for new offers or promotions. You may find patterns of how one SKU drives demand for another. You can also monitor the inventory you have on hand and units sold per day, run reports to see which SKUs and sales channels are your highest sellers, and see which products aren’t as popular, costing you higher warehousing fees. This can save business owners money in the long-run and keep inventory carrying costs down .
There’s no one-size-fits-all inventory management system; every small business or large corporation has different needs, especially when it comes to ecommerce. Here are some of the most popular inventory management software for online stores.
ShipBob is not a standalone inventory management system, but rather an order fulfillment solution that has inventory management software built in. Merchants get the tools, guidance, and reporting necessary to efficiently manage their inventory across multiple stores and ShipBob’s fulfillment centers .https://www.youtube.com/embed/YdTbM4XlizY?feature=oembed
Inventory tracking tools are included at no extra cost for merchants who use ShipBob to fulfill orders. Having order fulfillment synced up with inventory management helps optimize your supply chain and keep data and reporting in one place.
Some businesses — especially enterprise retailers who have been operating for many years — choose legacy providers like SAP to track inventory. These include warehouse management and enterprise resource planning systems (WMS and ERP respectively).
Many WMS and ERP systems use legacy technology. While these systems record and manage stock levels, there is not always an automation or optimization component. These options also tend to be expensive, incurring significant overhead in exchange for limited functionality, thus geared toward very large companies.
There are many statuses or types of inventory depending on the phase of the lifecycle it’s in. Below is a breakdown of a few common types of inventory throughout the supply chain.
These are your materials or ingredients that come together to eventually make up a product you sell. Also known as production inventory, or manufacturing inventory, they get transformed into end products during the manufacturing process. These are different from partially-finished and finished goods.
Work in process inventory refers to partly finished materials within any production round, or the total cost of unfinished goods currently in production. WIP inventory is considered an asset on a company’s balance sheet. They are different from finished goods.
These are your final products that are done being manufactured and are ready to be sold to your customers as-is.
The difference between supplies and inventory is:
You may think that outsourcing inventory storage and ecommerce order fulfillment to a 3PL provider means turning inventory management over to them. In reality, a good 3PL partner provides merchants the tools, data, and transparency they need to manage their inventory efficiently and cost-effectively.
“Off the bat, I liked that I would be able to control multiple warehouses through one page with ShipBob. With my old 3PL, I could never just open a page and get the info I wanted. I had to click several times, then export it, and try to make sense of it. ShipBob lets you manage your inventory while providing important data in a very digestible way.” Wes Brown, Head of Operations at Black Claw LLC
Inventory management involves much more than just warehousing your products. Fulfillment and inventory management go hand in hand. Here’s how a 3PL helps you manage your inventory.
A tech-enabled 3PL ’s software seamlessly integrates with all major ecommerce platforms and marketplaces. This enables merchants to connect their store in just a few clicks without needing a developer.
Connecting these channels provides a cohesive view of all orders, inventory, fulfillment centers, sales channels, and customers in one place. You can easily pull over all of your SKUs from your store into your 3PL’s system. And as you add new products, you can easily sync your new SKUs.
“We roll out new products and designs on our website 1-3 times a month and send new inventory to ShipBob each week. It’s really easy to create new SKUs and restock existing ones using ShipBob’s technology, which is especially important with high inventory turnover.” Carl Protsch, Co-Founder of FLEO Shorts
Once your 3PL has your inventory at their fulfillment centers, you can check the quantity on hand and units sold per day at any given time for direct visibility into what is available to ship to your customers.
For instance, from the ShipBob dashboard, you can:
This type of real-time visibility allows you to view historical inventory levels and how much inventory is remaining at each distribution center :
“So many 3PLs have either bad or no front-facing software, making it impossible to keep track of what’s leaving or entering the warehouse. On the supply chain side, I just throw in what we placed at the factory into a WRO in the ShipBob dashboard, and I can see how many units we have on-hand, what’s incoming, what’s at docks, and so on. I can see all of those numbers in a few seconds, and it makes life so much easier.” Harley Abrams, Operations Manager of SuperSpeed Golf, LLC
Tech-based fulfillment uses historical data to help project when you should reorder inventory to prevent stockouts and backorders . You can set reorder notification points for the stock levels at which you want to be automatically reminded to restock.
For instance, SHipBob provides access to daily inventory history data at any point in time. You can search by item, filter by specific lot number, and account for inventory in transit:
This helps you connect the upstream activities of purchasing and manufacturing to the downstream activities of sales and product demand, ultimately helping you make more accurate purchasing and production decisions to save on inventory and logistics costs .
If your 3PL has multiple fulfillment centers, they should be able to help you determine the optimal fulfillment center locations based on your customers’ shipping destinations.
Your customers most likely don’t all reside in one geographic area. Using one fulfillment center can make it difficult to efficiently reach the majority of people who buy from you. Instead, distributing your inventory to major hubs or cities can ensure you ship to lower shipping zones , delivering orders more quickly and at a reduced shipping cost .
Each time an order is placed on your online store, the 3PL’s order management system will automatically choose the fulfillment center closest to the end customer to draw inventory and ship the order. Additionally, if you run out of inventory at one fulfillment center, you’ll have backup at another.
For instance, ShipBob makes it easy to optimize inventory distribution. By aggregating historical order data, you get an analysis of which fulfillment centers you should stock to best leverage ShipBob’s network of fulfillment centers for the most cost-effective and fast deliveries (see example below).
As we mentioned above, having accurate insights about your customers’ purchasing trends can help you figure out the optimal inventory levels for your products.
For example, understanding which products aren’t selling but instead incurring storage costs — as well as those that are selling more quickly than you can keep them in stock — can empower you to make better supply chain decisions.
Some 3PLs provide built-in reports that let you view a trend analysis of your products and give you more control of your inventory and the key metrics that drive business growth. These include peak fulfillment times, revenue of orders shipped by day, sales by channel, and sales and quantity of orders by USPS shipping zone.
A 3PL’s technology gives you the power to select how you group your warehouse inventory. This includes:
Today, outsourced order fulfillment often means receiving the tools needed to manage inventory from within their warehouse(s). A good 3PL shouldn’t be a cost center but rather a partner that helps prevent stockouts and can accurately forecast demand to increase sales and reduce storage costs.
Request a fulfillment quote from ShipBob to learn how we manage your inventory and order fulfillment for you.
Below is a handy table summarizing several basic inventory management terms you’ll come across.
Cost of goods sold (COGS) | The direct costs of producing your sellable inventory, including labor, materials, and other direct costs |
A calculation used to figure out the optimal order quantity you should have with the goal to minimize logistics costs, warehousing space, and stockouts | |
The fewest number of units that are required to be purchased at one time | |
The total number of units you request from a manufacturer or supplier on an inventory replenishment purchase order | |
Lead time | The amount of time it takes for an order to be completed, whether it be a , a shipping carrier transit time, or other turnaround time that involves inventory |
The value of finished goods ordered from a supplier or manufacturer that is currently in transit and has yet to reach a physical store or distribution center (also known as ) | |
Where a business’s inventory is held — both its physical location in a storage space, and its position in the overall supply chain | |
The quantities of products that you have in a fulfillment center(s) or store at any given time | |
Inventory that is and no longer sellable | |
The excess product you keep on hand in case of an emergency (also known as ) | |
The process of calculating the inventory needed to fulfill future customer orders based on how much product you predict you will sell over a specific period of time | |
When inventory is unavailable, preventing an item from being purchased or shipped | |
A method designed to cut costs, increase efficiency, and decrease waste by receiving goods just when they are needed | |
The process of at the right time and at the right place based on demand and projected sales | |
A system used to trace parts or ingredients associated with a group of products back to a manufacturer or supplier, or organize inventory by production batch or expiration date | |
The minimum unit count or stock level for a specific product that triggers the reordering of more inventory when reached | |
A ratio that measures how many times inventory is sold and then replaced in a specific time period |
Below are some inventory accounting and inventory valuation terms as well:
When the amount of inventory on hand is different from current inventory records (can also be expressed as ) | |
When actual inventory levels are less than accounting has them recorded as | |
The process of removing or reducing the value of inventory that has no value from accounting records | |
When your inventory’s market value falls below the book value, but it still considered sellable (also known as inventory impairment) | |
The process of comparing counts with records of inventory on hand (e.g., during an ) | |
The total cost of all expenses related to storing unsold goods (also known as ) | |
An inventory valuation method that uses a weighted average to determine the amount of money that goes into COGS and inventory | |
The total value of a business’s current inventory in stock at the beginning of an accounting period | |
An inventory valuation method that records when stock is sold or received in real-time | |
An inventory valuation system where the business’s inventory and COGS are not updated in the accounting records after each sale and/or inventory purchase, but instead when a designated accounting period has passed | |
An inventory valuation method that assumes goods purchased or produced first are sold first (this also means the oldest inventory gets shipped out to customers before newer inventory) |
Inventory management affects every aspect of a business’s operations. Choosing the right inventory management system and techniques can help your business save money, meet customer demand, and stay efficient and effective in the fast-moving ecommerce landscape.
If you’re in need of a 3PL that will help you manage your inventory in real-time, check out ShipBob. With ShipBob’s technology and network of fulfillment centers, you can manage inventory and order fulfillment efficiently and effectively from one central platform.
Now that you’ve gotten more familiar with managing inventory for an ecommerce business, here are some frequently asked questions you may want to know.
Calculate reorder points either manually or through your inventory management system’s software. Some inventory management software allows you to enable automatic reorder notifications when stock drops below the designated reorder point.
Stocking the right amount of inventory is a delicate balance you have to strike. If you order too much inventory, you’ll end up with extra stock for which you have to pay for storage; too little, and your customers will look elsewhere.Analyzing historical data and trends from previous months will help you determine how much stock you’ll need moving forward. If you’re launching a new product, make sure to clear storage space for excess inventory before it arrives.
If you frequently find your products selling out, make sure that you order a higher quantity of inventory the next time you restock. If you’re in the situation where you’ve run out, keep customers in the loop on when they can expect your product to be back in stock by displaying inventory restock dates on the product page and offer them the option to be notified when it’s back in stock.
Seasonal variations in supply and demand can put a lot of pressure on a growing business. If your business has been around for over a year, analyzing previous years’ seasonal trends can help you plan properly for upcoming seasonality.If your business is brand new, you can research seasonal trends in your industry to help you form predictions. For example, if your product is meant for winter use only, you’re likely to find that demand is highest just before and during the winter months, while you’ll want to have less stock on hand in the summer.
If you are operating several of your own warehouses or inventory storage locations, make sure to set up a WMS and inventory management system that allows you to keep track of inventory across locations. Having the right technology in place can streamline in-house inventory management.
If you outsource supply chain management and the warehouses are all owned and operated by the same 3PL, they should be able to provide visibility into all of your orders, stock levels across fulfillment centers, and shipments in one place.
If your inventory is stored in warehouses operated by several different fulfillment providers (e.g., in different countries), an inventory management system can help you manage all sales channels, locations, and currencies to streamline inventory control from a single dashboard.
A SKU, or Stock Keeping Unit , is an alphanumeric code number assigned used to identify a product. The code represents different product characteristics, such as color, size, and brand. Each product variation is assigned a SKU, and the SKU is used to keep track of inventory (e.g., a Large red shirt is a different SKU than a Medium red shirt, and thus, should be stored in a separate location).
An inventory turnover ratio measures how quickly your company is selling inventory. It can be a useful comparison to industry averages to measure the strength of your company’s sales volume and performance. Knowing your inventory turnover rate can provide valuable insight into how your company manages inventory, sales, and costs.
A fulfillment expert will get back to you shortly.
Job description:.
A modern warehouse must respond quickly to changing business conditions. With our modern, flexible warehouse management system (WMS), you can manage a high volume of goods and run sustainable, risk-resilient operations with digitalized warehouse processes in the cloud.
With SAP EWM, you can manage high-volume warehouse operations and integrate complex supply chain logistics with your warehouse and distribution processes, delivering high levels of visibility and control.
Learn how Dis-Chem navigates expansion with SAP Extended Warehouse Management.
Register now
Reduce inventory and labor cost.
Speed fulfillment by optimizing resources and heading off problems before they impact operations.
Spot risks, avoid disruptions, and see deep into operations with stock, resource, and process transparency.
Identify available space and use it to drive costs down, speed fulfillment, and optimize inventory.
Move toward zero emissions and waste with SAP Sustainability solutions.
Start your journey
Build speed and sustainability into supply chain logistics.
Read the Oxford Economics survey to learn how faster, reliable, personalized, and sustainable delivery is transforming logistics.
See why Gartner® named SAP EWM in its Magic Quadrant™ for Warehouse Management Systems.*
* Gartner, Magic Quadrant for Warehouse Management Systems, Simon Tunstall, Dwight Klappich, Rishabh Narang, Federica Stufano, 2 May 2024
GARTNER is a registered trademark and service mark of Gartner, Inc. and/or its affiliates in the U.S. and internationally, MAGIC QUADRANT is a registered trademark of Gartner, Inc. and/or its affiliates and are used herein with permission. All rights reserved.
Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.
This graphic was published by Gartner, Inc. as part of a larger research document and should be evaluated in the context of the entire document. The Gartner document is available upon request from SAP.
Keeping track of your business inventory, whether it's stock to sell to customers or key assets for your business, is very important. Using Excel makes this task easier. You can use a free downloadable template or build out your own, helping you save time and stay on top of your inventory.
What will I learn?
How to find an inventory template
How to set up basic column headers
Common Excel features to use to help with inventory tracking
What do I need?
Excel (web or desktop)
Before you start to create your own inventory in Excel, it's a great idea to check out some of the existing templates that you can download and use. These templates can be changed to work however you need.
Open Excel or if Excel is already open, select File > New .
In the search box, type "inventory" or something similar.
Once you've found the one you like, select Create .
The template will open in Excel. Start to use it as-is or make updates to the template for whatever you need.
Looking for other templates? Go to create.microsoft.com and find tons of different templates for Microsoft 365 apps.
Maybe the most important part of an inventory list to help you track everything is choosing the right column headers. It's impossible to know what your specific business needs are, but there are some common column headers that we recommend using. Here's a list with some descriptions of each:
Inventory ID - use this to create a unique ID for your items.
Item name - the name of the items. Inventory IDs help distinguish between similar items or replacement items when an item is discontinued and a new version replaces it.
Item category - category for the item, such as "Accessory".
Quantity in stock - quantity currently in stock for that specific item.
Cost per item - this could be used as your business cost per item or it could be the current price of an item. You might want to add an additional column to track both if that's needed.
Total inventory value - quantity in stock multiplied by the cost per item. It's useful to use a simple multiplication formula so that Excel automatically calculates this as your quantity changes or the cost per item changes.
Reorder limit - use this to set a limit for when you should reorder an item before it becomes out of stock.
Last Reorder date - keep track of when the last time you ordered an item to refill stock. It can be useful to know, especially if you're frequently reordering certain items, which can lead to you increase your Reorder limit.
Discontinued - it can be helpful to track when you no longer carry an item in your inventory.
Notes - add any extra information you want to keep track of or someone should know, like if it's challenging to reorder certain items from suppliers.
Excel is a powerful tool that can transform your work and save you time and money. But it also can be overwhelming to figure out all the features you might want to use. Here are a few suggestions that can be useful with links to articles explaining how you use the feature:
Create a drop-down list in your categories column to limit the options someone can choose. This limits potential mistakes or typos.
Use Excel as your calculator so things like inventory value and more are automatically calculated.
Freeze panes to lock rows and columns so it's easier to see your column headers even when you're scrolling far down your inventory list.
Use conditional formatting to highlight information , like when you need to reorder an item because it's below your reorder limit.
Filter data in your inventory list to help you focus on specific categories or items.
Excel help & learning
Free Excel templates
Want more options.
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Microsoft 365 subscription benefits
Microsoft 365 training
Microsoft security
Accessibility center
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
Ask the Microsoft Community
Microsoft Tech Community
Windows Insiders
Microsoft 365 Insiders
Thank you for your feedback.
Creating a comprehensive business plan is crucial for launching and running a successful self storage business. This plan serves as your roadmap, detailing your vision, operational strategies, and financial plan. It helps establish your self storage business’s identity, navigate the competitive market, and secure funding for growth.
This article not only breaks down the critical components of a self storage business plan, but also provides an example of a business plan to help you craft your own.
Whether you’re an experienced entrepreneur or new to the services industry, this guide, complete with a business plan example, lays the groundwork for turning your self storage business concept into reality. Let’s dive in!
Our self-storage business plan is structured to cover all essential aspects needed for a comprehensive strategy. It outlines the business’s operations, marketing strategy , market environment, competitors, management team, and financial forecasts.
Fully editable 30+ slides Powerpoint presentation business plan template.
Download an expert-built 30+ slides Powerpoint business plan template
The Executive Summary introduces your self storage business plan, offering a concise overview of your storage facility and its services. It should detail your market positioning, the range of storage solutions you offer, its location, size, and an outline of day-to-day operations.
This section should also explore how your self storage business will integrate into the local market, including the number of direct competitors within the area, identifying who they are, along with your facility’s unique selling points that differentiate it from these competitors.
Furthermore, you should include information about the management and co-founding team, detailing their roles and contributions to the business’s success. Additionally, a summary of your financial projections, including revenue and profits over the next five years, should be presented here to provide a clear picture of your storage facility’s financial plan.
Make sure to cover here _ Business Overview _ Market Overview _ Management Team _ Financial Plan
For a Self storage business, the Business Overview section can be concisely divided into 2 main slides:
Briefly describe the storage facility’s physical environment, emphasizing its security, cleanliness, and the overall ease of access that welcomes clients. Mention the facility’s location, highlighting its accessibility and the convenience it offers to clients, such as proximity to residential areas or ease of access from main roads. Explain why this location is advantageous in attracting your target clientele.
Detail the range of storage options and services offered, from small lockers and medium-sized units to large units suitable for vehicle storage. Outline your pricing strategy , ensuring it reflects the quality of services provided and matches the market you’re targeting. Highlight any packages, discounts for long-term rentals, or additional services such as climate control, 24/7 access, or insurance options that provide added value to your clients, encouraging repeat business and customer loyalty.
Make sure to cover here _ Facility & Location _ Services & Rates
Industry size & growth.
In the Market Overview of your self storage business plan, start by examining the size of the self storage industry and its growth potential. This analysis is crucial for understanding the market’s scope and identifying expansion opportunities.
Proceed to discuss recent market trends , such as the increasing demand for personal and business storage solutions, the rise of e-commerce leading to a need for inventory storage, and the growing trend of downsizing and decluttering among consumers. Highlight the demand for specialized storage options like climate-controlled units, and the increasing focus on security features and convenient access.
Then, consider the competitive landscape, which includes a range of storage facilities from high-end, full-service options to budget-friendly alternatives, as well as DIY storage solutions like portable storage containers. Emphasize what makes your storage facility distinctive, whether it’s through superior security measures, exceptional customer service, a wide range of unit sizes, or specialized storage options. This section will help articulate the demand for self storage services, the competitive environment, and how your facility is positioned to thrive within this dynamic market.
Make sure to cover here _ Industry size & growth _ Key competitors _ Key market trends
Dive deeper into Key competitors
First, conduct a SWOT analysis for the self storage business, highlighting Strengths (such as prime location and robust security measures), Weaknesses (including high operational costs and strong competition), Opportunities (for example, increasing demand for storage solutions due to downsizing and e-commerce growth), and Threats (such as economic downturns that may decrease consumer spending on storage services).
Next, develop a marketing strategy that outlines how to attract and retain clients through targeted advertising, promotional discounts, engaging social media presence, and community involvement.
Finally, create a detailed timeline that outlines critical milestones for the storage facility’s opening, marketing efforts, client base growth, and expansion objectives, ensuring the business moves forward with clear direction and purpose.
Make sure to cover here _ SWOT _ Marketing Plan _ Timeline
Dive deeper into SWOT
Dive deeper into Marketing Plan
The Management section focuses on the storage business’s management and their direct roles in daily operations and strategic direction. This part is crucial for understanding who is responsible for making key decisions and driving the storage business toward its financial and operational goals.
For your self storage business plan, list the core team members, their specific responsibilities, and how their expertise supports the business.
The Financial Plan section is a comprehensive analysis of your financial projections for revenue, expenses, and profitability. It lays out your self storage business’s approach to securing funding, managing cash flow, and achieving breakeven.
This section typically includes detailed forecasts for the first 5 years of operation, highlighting expected revenue, operating costs and capital expenditures.
For your self storage business plan, provide a snapshot of your financial statement (profit and loss, balance sheet, cash flow statement), as well as your key assumptions (e.g. number of customers and prices, expenses, etc.).
Make sure to cover here _ Profit and Loss _ Cash Flow Statement _ Balance Sheet _ Use of Funds
Cookie | Duration | Description |
---|---|---|
BIGipServerwww_ou_edu_cms_servers | session | This cookie is associated with a computer network load balancer by the website host to ensure requests are routed to the correct endpoint and required sessions are managed. |
cookielawinfo-checkbox-advertisement | 1 year | Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Advertisement" category . |
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
CookieLawInfoConsent | 1 year | Records the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie. |
elementor | never | This cookie is used by the website's WordPress theme. It allows the website owner to implement or change the website's content in real-time. |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |
Cookie | Duration | Description |
---|---|---|
__cf_bm | 30 minutes | This cookie, set by Cloudflare, is used to support Cloudflare Bot Management. |
language | session | This cookie is used to store the language preference of the user. |
Cookie | Duration | Description |
---|---|---|
_ga | 2 years | The _ga cookie, installed by Google Analytics, calculates visitor, session and campaign data and also keeps track of site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognize unique visitors. |
_ga_QP2X5FY328 | 2 years | This cookie is installed by Google Analytics. |
_gat_UA-189374473-1 | 1 minute | A variation of the _gat cookie set by Google Analytics and Google Tag Manager to allow website owners to track visitor behaviour and measure site performance. The pattern element in the name contains the unique identity number of the account or website it relates to. |
_gid | 1 day | Installed by Google Analytics, _gid cookie stores information on how visitors use a website, while also creating an analytics report of the website's performance. Some of the data that are collected include the number of visitors, their source, and the pages they visit anonymously. |
browser_id | 5 years | This cookie is used for identifying the visitor browser on re-visit to the website. |
WMF-Last-Access | 1 month 18 hours 11 minutes | This cookie is used to calculate unique devices accessing the website. |
COMMENTS
Here's a seven-step approach to creating an inventory management plan with procedures, controls and tools tailored to your business's unique needs. 1. Define Product Sourcing and Storage ...
Inventory Planning. Inventory planning helps companies buy the right amount of stock and decide how often to reorder. Inventory planning helps lower the costs of keeping items in stock and helps make sure there is enough stock for making and selling items. Inventory planning is an essential part of supply chain management.
Further, storage costs are lower, and if your business moves fast, having only the minimum levels of stock may be more suitable. ... Purchasing a software system that addresses your warehouse stock is not enough. A good inventory control plan addresses your orders from production or purchasing to selling the items and ultimately removing them ...
Inventory Control Overview. Inventory control is the maintenance of a business's inventory level to fulfill orders and minimize costs. It involves managing inventory storage, movement, and maintenance. It also includes using data to make decisions that can increase the profit you make off this inventory.
8 Restaurant Inventory Management Best Practices. Categorizing and organizing stock, setting automated reorder points, establishing safeguards against inventory mistakes and using technology to forecast demand are some key methods to help you manage inventory more effectively. Here are some best practices.
According to a study by the Gartner Group, companies with effective inventory control practices can reduce inventory carrying costs by up to 30% and improve service levels by up to 20% . Inventory control is a central aspect of supply chain management that helps businesses optimize stock levels, minimize costs, and meet customer demand effectively.
Inventory management can be a challenge, especially when you've got store inventory control to consider, with several warehouses and retail stores to maintain. It often involves a stock-take day, when you count each item of stock in your warehouse and record the results. Although store management and inventory control can sometimes be tedious, it's vitally important for a business to stay ...
1. Perpetual system. The perpetual system is an inventory management method for continuous inventory management. The amount of inventory is taken in real-time as things are moving in and out. Because of its immediate nature, this system is considered the most favorable by stakeholders, retailers, and business owners.
Inventory management refers to the process of ordering, storing and using a company's inventory: raw materials, components and finished products.
Inventory—while an important asset for your business—can be a huge risk. Inventory management systems (especially automated software solutions) are vital cost-saving measures that can help you minimize loss, lower your storage costs, and sell more items.. Once you order and pay for your products, the capital you spent to acquire those products is essentially tied up in your inventory.
Start with an inventory control plan - This plan should address the movement of goods from production to sales and removal from the inventory database. Put it into practice - Carrying out the inventory control plan includes establishing metrics and forecasts for succeeding months. You can also adjust your stock management strategy as needed.
As we already discussed, today, inventory control is a lot more than simply counting stock. 1. Two bin method. To avoid inventory shortage, the items are stored in two bins. When the first bin becomes empty, stock from the second bin starts getting used and at the same time, replenishment is done in the second bin. 2.
Just-in-Time Management (JIT) is a strategy where inventory is delivered only as it is needed in the production process, reducing the cost of storing inventory. Significant for industries like automotive manufacturing, JIT can lead to reduced inventory levels and associated costs, promoting an efficient supply chain.
3) Arranging inventory. Another key part of inventory storage is determining the exact location each product should be stored within your warehouse. Ideally, sales volume should be taken into account for this. Veeqo research found that 60% of a company's sales tend to come from just 20% of their products.
Storage and Inventory Control Best Practices. Kate Vitasek. May 17, 2021. Storage and inventory control processes include activities related to holding material and the processes of counting and transacting it as it moves through a fulfillment or distribution center. The layout of a facility supporting an adjoining manufacturing operation will ...
Download our template file (this includes your entire item library). Open the file and add your inventory by item in the column labeled New Quantity [Location]. You can also update your Stock Alert Enabled [Location]. Save the file, then drag and drop it into the Import Inventory window and click Upload.
Inventory planning and control is the pillar of successful e-commerce. That's because a business without a solid inventory plan or inventory planning solution to support it is significantly more vulnerable to overselling, understocking, and delayed order fulfillment. At the end of the day, this all comes crashing down on customer experience. 1.
Conversely, inadequate storage control can lead to food spoilage, overstocking, increased expenses, and compromised quality. Let's explore some essential best practices to elevate your storage and inventory management game in the F&B realm. 1. Implement FIFO (First In, First Out) Methodology. FIFO isn't just an accounting term; it's a golden ...
Economic order quantity (EOQ) provides a mathematical approach to store inventory control. The goal of the EOQ equation is to calculate the ideal order amount. With this approach, companies attempt to minimize their inventory and storage costs while still maintaining profitability. The formula for economic order quantity is: EOQ = √ (2DK / H ...
The new product is scheduled to be released in May and will be sold by Pursuit Solutions. Pursuit Solutions, a $50 million company hardware integration reseller, will distribute Royal's Inventory Basic to over 1,100 Valued Added Resellers (VARs). The product will sell for $2,499. Royal's Software will receive $1,250 on each unit sold.
Inventory methods include a set of three priorities: Sell inventory for maximum profit. Hold the smallest possible amount of inventory. Keep your customers happy. Here are some tips to help you navigate these priorities. Don't take a one-size-fits-all approach. Sophisticated inventory control is a delicate balance.
Apply the 80/20 Rule. One of the best ways to approach small business inventory management is to apply the 80/20 rule —also known as the Pareto Principle—which says 80% of a business's revenue typically comes from 20% of its product. In other words, certain items in your self storage inventory will sell more frequently than others.
5. Use inventory management software. Software that is specifically designed to help you manage your inventory, whether in-house or in a 3PL's warehouse, can help avoid losing money from unsold products, inventory reports on stock levels and trends in real-time, and offer suggestions for inventory distribution.
Inventory management benefits. Inventory management helps ensure there is rarely too much or too little stock on hand, limiting the risk of running out of stock or paying to store stock in warehouses that you aren't selling. It helps you save money, improve cash flow, and meet the needs of your customers.
With our modern, flexible warehouse management system (WMS), you can manage a high volume of goods and run sustainable, risk-resilient operations with digitalized warehouse processes in the cloud. With SAP EWM, you can manage high-volume warehouse operations and integrate complex supply chain logistics with your warehouse and distribution ...
Our Partnered Carrier Program (PCP) can help you connect with trusted carriers and take advantage of pre-negotiated rates when you send inventory to FBA.; Amazon Stickerless lets you send eligible products to FBA using manufacturer barcodes—no Amazon barcode labelling required. Save up to an estimated $0.11 per unit. With Ships in Product Packaging, your FBA orders are delivered in your own ...
Maybe the most important part of an inventory list to help you track everything is choosing the right column headers. It's impossible to know what your specific business needs are, but there are some common column headers that we recommend using. Here's a list with some descriptions of each: Inventory ID - use this to create a unique ID for ...
Business, Industrial, and Scientific Supplies. 12%. $0.30. Clothing and Accessories. · 5% for products with a total sales price of $15.00 or less. · 10% for products with a total sales price greater than $15.00 and less than or equal to $20.00. · 17% for products with a total sales price greater than $20.00. $0.30.
Manufacturing inventory management is the practice of keeping enough stock on hand so production lines can fulfill orders. The process helps managers see stock levels at a glance and tracks raw materials, parts, work-in-progress and finished goods. Find out more about manufacturing inventory management.
Proceed to discuss recent market trends, such as the increasing demand for personal and business storage solutions, the rise of e-commerce leading to a need for inventory storage, and the growing trend of downsizing and decluttering among consumers. Highlight the demand for specialized storage options like climate-controlled units, and the ...