Inventory Reorder Point Calculator

Estimate the number of units you need to reorder (and when to order them) for your eCommerce business.

Got feedback about this tool? Please let us know.

Inventory Reorder Point Calculator User Guide

This tool is designed to help you calculate the reorder point for products in your inventory.

After inputting your sales and inventory data it will tell you how much stock to reorder and when you should place the order by.

The reorder point formula is a way to decide when it’s time to order more inventory so you don’t run out.

Visual representation of the reorder point formula

Here’s how it works:

Reorder Point Formula = Lead Time Demand + Safety Stock

  • Lead Time Demand: This is how many units you sell during the time it takes to get new stock. For example, if it takes 50 days for new stock to arrive after you place an order and you sell 10 units each day, your lead time demand is 500 units (because 50 days x 10 units/day = 500 units).
  • Safety Stock: This is extra ‘buffer’ stock you keep just in case something unexpected happens like you sell more than usual or there’s a delay in getting new stock.

So, if your lead time demand is 500 units and your safety stock is 30 days, your reorder point is when your inventory hits 800 units (30 days safety stock = 300 units at 10 units/day).

This means when your inventory gets down to 800 units, it’s time to order more.

This formula helps make sure you have enough inventory to sell until the new stock comes in, plus a little extra just in case. It’s like a safety net to help you avoid running out of stuff to sell!

Of course, you also need to consider your existing inventory levels, but that’s where this reorder point calculator tool will help.

Understanding your reorder point is a crucial factor in successful inventory management.

It helps with:

  • Stock Levels: By knowing your reorder point you can find a healthy balance between having too much inventory and too little.
  • Efficiency: Holding too much inventory ties up crucial capital in a physical product business. Maintaining a healthy stock level allows your business to use the capital available in the most efficient way possible.
  • Profitability: Overstocking inventory can negatively impact profits due to increased storage fees and an over-reliance on discounted sales, while understocking can result in missed opportunities for increased average order values and negatively impact organic ranking on platforms like Amazon.

Want a detailed guide on how to use this reorder point calculator? Let’s look at each key step.

Step 1: Adding inventory info

Start by adding information about the inventory you want to calculate a reorder point for.

NOTE

Calculate the reorder point one product at a time to ensure the data is accurate.

1. Unit Cost

Enter the price you pay to have one unit of the product manufactured. Don’t include shipping costs or taxes.

2. 30 Day Sales

Enter the total number of units you have sold of this product in the last 30 days across all channels.

To find this on Shopify, go to Analytics and sort by the last 30 days.

To find this on Amazon, go to Reports > Business Reports > Detail page sales and traffic by child item.

This helps calculate your 30-day velocity and therefore the size of order you should place to meet customer demand and avoid stocking out.

3. Lead Time

Finally, add your lead time in days.

This should be the total time expected between placing an order with your supplier and having the stock available to sell.

This is vital for forecasting your optimal reorder point.

Step 2: Adding current inventory levels

Next, it’s time to add information about the stock you’re currently holding.

The optimal reorder point formula we use takes into account the stock level you are carrying in order to provide the most accurate forecast possible.

Add the number of units you currently have:

  • At Amazon: Stock that is being stored at an Amazon fulfillment center.
  • At Your 3PL(s): Stock that is being stored at a 3PL warehouse or your own warehouse.
  • En Route: Stock that is either in production or on its way to you already.

Step 3: Determining inventory coverage

The third and final section in the reorder point calculator asks for your desired inventory coverage.

This is the number of days worth of inventory you’d like to order.

Some businesses prefer to order several months’ worth of inventory at a time to maximize the economies of scale, whereas others prefer to order smaller quantities on a regular schedule to keep inventory trickling in at a good pace.

Use the slider to select the best fit for your business, and the calculator will then be able to advise on the best order quantity for you.

Step 4: Understanding your results

Once you’ve entered all the required data you’ll be presented with a range of results:

visual representation on understanding your results
  • 30-Day Velocity: The average number of units this product has sold each day over the last 30-day period.
  • Lead Time Demand: How many units you sell during the time it takes to get new stock. For example, if it takes 50 days for new stock to arrive after you place an order and you sell 10 units each day, your lead time demand is 500 units (because 50 days x 10 units/day = 500 units).
  • Inventory Runway: How many days’ worth of inventory you have remaining at current sales volumes. This does not include safety stock, so if you are factoring safety stock in then this would add an extra buffer beyond this figure.
  • Suggested Order Quantity: The size of order the tool recommends you place based on the data you have entered.
  • Suggested Order Timeframe: A recommendation on when you should place your order based on current stock levels, sales volumes, and lead time.
  • Cost Of Order: The total cost of the suggested order quantity based on your unit cost and broken down by a relatively standard payment term of 30% deposit (pre-production) and a 70% balance once production is completed.

NOTE

This tool is designed to give estimates to help with planning and is not a financial modeling tool. Sales volume and lead time can fluctuate based on a number of factors so it is always best to err on the side of caution.

Frequently Asked Questions

Safety stock is like having a backup plan for your inventory and is all about being prepared. It’s extra stock that you keep just in case something unexpected happens. This can be measured in a number of units or a number of days that is calculated by average daily usage or sales. This reorder point calculator helps you factor in safety stock to your reorders.

The safety stock levels you need for your business will depend on the complexity of your supply chain. If you have a lot of moving parts and an unpredictable lead time then you should carry more safety stock than you might if you have a simple supply chain. We’d recommend a minimum of 10 days worth of safety stock, but if you can maintain 30 days that’s great too.

A product’s lead time is very much dependent on two main factors:

  • Manufacturing Time: How long your factory take from placing an order to having it ready to ship.
  • Shipping Time: How long your goods take to get to your warehouse after being collected from your factory. This will vary greatly depending on the method. For example, air shipping will be much faster than ocean.

A common supply chain setup is having products manufactured in Asia (e.g. China) and shipped by ocean freight to the U.S. Using this as an example, you might expect your goods to take 30 days to be manufactured and another 30 days to ship to your warehouse. As mentioned, this can be affected by several factors, but gives a guide to work from.

The best way to forecast customer demand is by analyzing sales history of each product in your inventory. You can export sales reports from platforms like Shopify or Amazon to do this, or use inventory management software. If you are aiming to forecast demand for a product you don’t have sales history for you can study the sales trends of your competitors by using tools like XRay by Helium 10.

THE ECOM MEMO

Stay eCommerce sharp in 5 minutes per week

Subscribe