Skip to content

Retail Replenishment Quantity Calculator

Calculate how many units to order based on sellable inventory, confirmed incoming stock, weekly sales, supplier lead time, and your target weeks of cover.

Your inputs

View results

Use on-hand stock after reservations, outgoing transfers, and unsellable units.

Count uncommitted units from existing orders and transfers due by the new order’s arrival.

Start with average weekly unit sales while the item was in stock.

Count from placing the new order until those units are ready to sell.

Enter how long you want stock to last from the time the new order is ready to sell.

Example results

Suggested order quantity
69 units

Whole units to order to reach your target when the new delivery arrives.

Demand before receipt
45 units

Expected sales while the new order is on its way.

Projected stock at receipt
3 units

Estimated units left when the new order arrives, before adding that delivery.

Target stock at receipt
72 units

Units needed to cover the requested weeks after arrival.

Estimated shortfall before receipt
0 units

Expected demand above current and confirmed incoming supply. Check individual delivery dates for earlier gaps.

This order would bring sellable stock up to your coverage target when it arrives. Check supplier pack sizes and minimums before ordering.

The estimate uses a steady weekly sales rate and treats unmet demand before receipt as missed sales. Compare demand with each receipt date to spot shorter gaps.

Why use this calculator?

The right replenishment quantity depends on how much you expect to sell while you wait for the new order and what stock will still be available when it arrives. A store might have plenty of a size today and be down to a few units by the next delivery. An open purchase order may already supply part of what you need. Estimating both helps you decide how many additional units to buy and avoid committing cash to stock you already have on the way.

Calculate the order for one SKU and one store, warehouse, or shared stock pool. Check the expected shortfall before receipt too. If a bestseller may run out next week and a new order takes two weeks to arrive, look at faster ways to cover next week’s demand while you plan the regular buy.

How this calculator works

Estimate sales during the supplier lead time, then apply the same weekly sales rate to the number of weeks you want to cover after receipt. Enter partial weeks as decimals. For example, 17.5 days is 2.5 weeks.

  1. Demand before receipt = expected weekly sales × lead time in weeks.
  2. Projected stock at receipt = sellable units now + confirmed incoming units − demand before receipt, with a minimum of zero.
  3. Target stock at receipt = expected weekly sales × target weeks of cover after receipt.
  4. Suggested order quantity = target stock − projected stock at receipt, rounded up to a whole unit with a minimum of zero.
  5. Estimated shortfall before receipt = demand before receipt − sellable units now − confirmed incoming units, with a minimum of zero.

Worked example. A footwear store has 36 pairs of a popular size available and 12 pairs due next week. It expects to sell 18 pairs per week. With a 2.5-week lead time, buyers expect 45 pairs to sell before the new order arrives, leaving 3 pairs. The store wants 4 weeks of cover after the delivery, so it needs 72 pairs at receipt. Order 69 pairs to reach that target.

The estimate pools expected receipts and demand up to the new arrival date. Check what you can sell between each receipt, particularly when a large shipment is due late in the lead time. This order-up-to approach compares the projected balance with a target and credits supply already on order. Microsoft Business Central reordering policies

Who this calculator is for

Retail buyers and inventory planners can use it to draft purchase quantities for repeat styles, sizes, and colors. Start with an item whose lead time and sales pace you know, then adjust the target for the selling season and how often you can reorder. Sqquid’s guide to planning how much inventory to buy

Store managers and ecommerce operations teams can compare a normal supplier order with an earlier transfer or delivery. When several channels draw from the same warehouse, include their expected sales and count the shared inventory once. When each store stocks the item independently, calculate which locations actually need more units before allocating a combined purchase.

Frequently asked questions

What stock should I include in available units?

Use inventory ready to sell from the store, warehouse, or shared stock pool you are planning for. Subtract units already reserved for orders or outbound transfers, as well as damaged units and stock on hold.

Which purchase orders and transfers should I count?

Include confirmed, uncommitted units due to be received and ready to sell by the time the new order is available. Check each arrival date and quantity. If a shipment is likely to be late or partial, test the plan with a smaller inbound quantity.

How should I estimate weekly demand when the item was out of stock?

Start with comparable periods when customers could buy the item and include ordinary slow days. If the sales history is sparse, compare similar stores or variants. Adjust your estimate for known promotions, weather, and seasonal changes.

What’s the difference between a reorder point and a replenishment quantity?

A reorder point gives you an inventory level that triggers a purchase review. Once you decide to buy, the replenishment quantity tells you how many units to order to reach your coverage target. Inventory reorder point calculator

What should I do if I see a shortfall before receipt?

Review whether an existing purchase order can arrive earlier or a nearby store can spare stock. If customers are waiting on backorders that the new receipt must fulfill, account for them in the order separately so the stock you receive can also cover future demand.

Can the estimate show zero shortfall even if I could stock out?

Yes. Adding up demand and receipts averages over the entire lead time. If a shipment is due late in that window, you could run out earlier. Compare current stock and sales with the date of your first inbound receipt. Inventory stock cover calculator

How do I allow for safety stock?

You can add the desired buffer to your target as extra weeks of cover. For example, add half a week if you want 9 safety units and expect to sell 18 per week. Check how much buffer is already available while you wait for the new order.

How do I handle case packs and vendor minimums?

The suggested quantity rounds up to the next whole unit. Compare it with your supplier’s case pack and minimum order quantity. If the supplier only sells packs of 12, a 69-unit suggestion becomes 72 units. Check that your buying budget and stockroom can absorb the extra units.

Can I calculate a single order for multiple stores?

Use combined sales and inventory if the locations truly share stock and can move it when needed. For stores with different sales patterns or transfer delays, calculate by SKU and location before combining buying quantities on a purchase order.

How many weeks of cover should I target?

Start with the time between deliveries, then adjust for how reliably you can replenish and how long the item has left to sell. For a seasonal item, use the remaining selling weeks after delivery to check whether a larger order would leave excess stock.

Important retail metrics

Review these measures together by SKU and location. They help you see whether to order more, change the delivery date, or revisit the coverage target.

In-stock weekly sales

Units sold per week in comparable periods when the item was available.

Estimate future demand and check whether a seasonal or promotional adjustment is warranted.

Supplier lead time

Time from placing a purchase order until the units are ready to sell.

Estimate how much stock you need before the next shipment and track delays by supplier.

Demand during lead time

Expected weekly unit sales × weeks until the receipt is ready to sell.

Compare expected demand against available inventory and deliveries due before the new order.

Weeks of stock cover

Sellable units ÷ expected weekly unit sales.

Compare how long current or projected stock can support demand at a specific location.

On-time inbound fill rate

Units received and ready to sell by their scheduled date ÷ units due × 100.

Check how much confidence to place in confirmed quantities and delivery dates.