Small Business Inventory Calculator
How to Use This Calculator
- 1
Enter inventory at the start and end of the period
Fill in Beginning Inventory ($) and Ending Inventory ($) using inventory values recorded at cost, not retail selling prices.
- 2
Add purchases, sales revenue, and inventory settings
Enter Purchases ($) and Annual Revenue ($), then set Holding Cost (%) and Lead Time (days). The calculator estimates reorder and safety stock using cost of goods sold as a daily-demand proxy.
- 3
Compare turnover, days, and reorder estimates
Review the six result cards and the metrics. The inventory chart is a simplified monthly projection based on evenly distributed usage and purchases.
Example Calculation
A retailer starts with $45,000 of inventory, buys $180,000 during the year, and ends with $38,000. Annual revenue is $320,000, holding cost is 20%, and supplier lead time is 14 days.
Beginning Inventory ($)
45,000
Purchases ($)
180,000
Ending Inventory ($)
38,000
Annual Revenue ($)
320,000
Holding Cost (%)
20
Lead Time (days)
14
Results
Inventory Turnover
4.51x per year
Days in Inventory
81 days
Cost of Goods Sold
$187,000.00
Annual Holding Cost
$8,300.00
Reorder Point
$7,172.60
Safety Stock
$3,586.30
Insights card shows turnover, days in inventory, gross margin, and holding-cost benchmarks.
Tips
A $7,172.60 reorder point assumes 14 days of lead time
Change Lead Time (days) from 14 to 21 to test a reorder point of $10,758.90. The estimate rises because the calculator uses daily COGS multiplied by lead time.
An ending inventory of $30,000 raises turnover to about 4.99x
Change Ending Inventory ($) from $38,000 to $30,000 while leaving the other inputs unchanged. Average inventory falls to $37,500, increasing turnover and reducing the calculated holding cost to $7,500.
A 25% holding-cost assumption produces an annual estimate of $10,375
Change Holding Cost (%) from 20 to 25 to see the effect of a higher storage, insurance, and shrinkage assumption on average inventory of $41,500.
What this calculator estimates
This calculator estimates how quickly inventory is used, how much it costs to hold, and when to reorder based on cost of goods sold (COGS). Its reorder estimate uses COGS as a proxy for daily demand, so it is not a unit-level purchasing plan.
How the inventory calculations work
COGS = Beginning inventory + Purchases − Ending inventory
Average inventory = (Beginning inventory + Ending inventory) / 2
Inventory turnover = COGS / Average inventory
Days in inventory = 365 / Inventory turnover
Annual holding cost = Average inventory × Holding-cost rate
Reorder point = (COGS / 365) × Lead time in days
Safety stock = (COGS / 365) × (Lead time in days × 0.5)
Gross margin (%) = (Annual revenue − COGS) / Annual revenue × 100
For the example, COGS is $45,000 + $180,000 − $38,000 = $187,000. Average inventory is ($45,000 + $38,000) ÷ 2 = $41,500, so turnover is $187,000 ÷ $41,500 = 4.506, or 4.51 times per year. Days in inventory is 365 ÷ 4.506 = about 81 days.
The annual holding-cost estimate is $41,500 × 20% = $8,300. Daily COGS is $187,000 ÷ 365 = $512.33; multiplying by 14 lead-time days gives a reorder point of $7,172.60. The 50% buffer produces safety stock of $512.33 × 7 = $3,586.30.
How the inputs change inventory estimates
| Change from the example | Average inventory | Turnover | Annual holding cost |
|---|---|---|---|
| Ending inventory falls to $30,000 | $37,500 | 4.99x | $7,500 |
| Ending inventory rises to $50,000 | $47,500 | 3.94x | $9,500 |
| Holding cost rises to 25% | $41,500 | 4.51x | $10,375 |
Faster turnover can reduce carrying costs, but it can also increase stockout risk if demand or supplier lead times vary. The calculator assumes the year’s COGS is spread evenly across 365 days and applies a fixed 50% safety-stock buffer; replace those assumptions with product-level sales and supplier data when making purchase orders.
For a more focused turnover calculation, use the small business inventory turnover calculator. To trace how operating expenses affect profitability, use the small business expense calculator.
When to use a different calculator
- Turnover and days-in-inventory analysis by reporting period → small business inventory turnover calculator
- Inventory-driven cash needs → small business cash flow calculator
- Revenue planning → small business revenue calculator
- Financing a stock purchase → small business loan calculator
Before reducing stock, check which products drive sales and whether suppliers can replenish them reliably. A lower average inventory can improve turnover statistics while making fulfillment less dependable.
Frequently Asked Questions
How do I calculate cost of goods sold from inventory?
1. Add beginning inventory to purchases. 2. Subtract ending inventory. 3. The result is COGS for the period. For this calculator's example, $45,000 + $180,000 − $38,000 = $187,000.
What is a good inventory turnover ratio?
This calculator uses 4–8 turns per year as a general benchmark, but a suitable rate varies by product, industry, and replenishment time. Compare businesses with similar products and avoid raising turnover by cutting stock so far that you miss sales.
Does reorder point include safety stock?
No, the calculator displays Reorder Point and Safety Stock as separate estimates. Reorder Point is daily COGS multiplied by lead time; Safety Stock is set to half of that lead-time demand as a fixed 50% buffer.
Are inventory values entered at retail price?
No, use the cost value of inventory so the beginning, purchases, and ending figures align with COGS. Retail values include markup and would distort turnover and reorder estimates.
How should a business account for inventory?
Inventory accounting affects reported assets and cost of goods sold, so use a consistent method and follow applicable accounting and tax rules. The SBA guide to managing business finances explains why accurate financial records matter; ask a qualified tax professional about your business's filing treatment.
