An inventory calculator helps you avoid the two costly extremes of stock control: running out, and tying up cash in goods that sit on a shelf. Enter how many units you sell each day and how long your supplier takes to deliver, and this inventory calculator tells you the stock level at which you should reorder. Add your current stock to see how many days it will last. If you have the figures, it also works out your inventory turnover, your days sales of inventory and an economic order quantity, so that you can plan both when and how much to buy.
How the inventory calculator works
- Reorder point: daily sales × lead time + safety stock
- Days of stock left: current stock ÷ daily sales
- Inventory turnover: cost of goods sold ÷ average inventory
- Days sales of inventory: 365 ÷ inventory turnover
- Economic order quantity: √(2 × annual demand × cost per order ÷ yearly holding cost per unit)
How to use the calculator
- Enter your average daily sales.
- Enter your supplier's lead time.
- Add safety stock and current stock if you have them.
- Fill in the optional pairs for turnover and order quantity.
- Press Calculate.
A worked example
A store sells 20 units a day, and its supplier takes 7 days to deliver. It keeps 50 units of safety stock. The reorder point is 20 × 7 + 50, which is 190 units. With 300 units on hand, the stock would last 15 days, and there's no need to order yet. If yearly cost of goods sold is $120,000 and average inventory is $20,000, turnover is 6 times a year, which is about 60.8 days of inventory. With an order cost of $50 and a holding cost of $2 per unit, annual demand of 7,300 units gives an economic order quantity of about 604 units.
What is a reorder point?
The reorder point is the level of inventory that triggers an action to replenish it. When stock falls to this amount, the item must be reordered. The idea is to place an order early enough that new goods arrive before the shelves are empty. Selling 20 units a day with a 7-day delivery time means that you'll sell 140 units while you wait, so you have to order before you get down to that level.
Why keep safety stock?
Real demand isn't perfectly steady, and suppliers are sometimes late. Safety stock is a buffer that protects you against those surprises. A simple approach is to multiply your daily sales by a number of buffer days. More safety stock lowers your risk of running out, but it also ties up more money and space, so choose an amount that reflects how much a missed sale would cost you, along with how reliable your supplier has been.
Understanding turnover
Shopify describes inventory formulas as calculations that help a business owner control costs, reduce waste from spoilage or obsolescence and maximize profitability. Turnover shows how many times you sell through your stock in a year. A high number generally means that goods are moving quickly, whereas a low number may point to overstocking. What counts as good depends on your industry. A grocer turns stock over much faster than a jewelry store, so compare yourself with similar businesses and with your own past results.
What is economic order quantity?
Economic order quantity, or EOQ, is the order quantity that minimizes the total holding costs and ordering costs. Ordering a little at a time keeps storage costs low, but it means paying the ordering costs more frequently. Ordering a lot at once does the opposite. EOQ finds the balance between the two. The model was developed by Ford W. Harris in 1913, and it applies only when demand is constant, so treat the result as a guide. Supplier minimums and pack sizes might push your real order up or down.
Reviewing your numbers
Businesses typically review their inventory formulas monthly or quarterly, and more often if daily sales are high. Use recent sales for your daily average, and treat each product separately, because a single figure for your entire store will hide fast and slow sellers. Adjust ahead of the holidays or a promotion, when demand can change sharply.
Putting the numbers to work
Start with your best-selling items, as these are the ones that hurt the most when they run out. Record a reorder point for each of them, and check your stock against it every day or every week. A simple spreadsheet is enough at first. When a product reaches its reorder point, place an order for the quantity that you've chosen, and write down the date that it arrives. Over time, those dates show you how long your supplier really takes, which may be different from what was promised. Update your lead time accordingly, and your reorder points will become steadily more reliable.
Common mistakes
- Forgetting lead time. Order before you run low.
- Using sales value in turnover. Use the cost of goods sold.
- Treating every product alike. Calculate each one separately.
Related business tools
Check your profit with the gross margin calculator, set selling prices with the markup calculator, and plan orders with the shipping cost calculator.
What next
Use this often? Add Inventory to your Home screen.
Frequently asked questions
How does the inventory calculator work?
It multiplies daily sales by lead time and adds safety stock to find your reorder point.
What is a good inventory turnover ratio?
It depends on your industry, so compare yourself with similar businesses.
What is safety stock?
It's a buffer of extra units that protects you against late deliveries or sudden demand.
What is economic order quantity?
It's the order size that minimizes the total of holding and ordering costs.
Does it work for seasonal products?
Only roughly. The formulas assume steady demand, so adjust for peak periods.
Sources
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.