Inventory replenishment: how to work out what to buy and when
A practical inventory replenishment method: set a cut-off, net reserved and incoming stock once, then size each order from lead time, pack and MOQ.
Free app. Runs on your Mac with the Claude or Codex plan you already have.
What inventory replenishment is
Inventory replenishment is the work of deciding what to buy or move, how much, and when, so that each item at each site has stock when customers need it without tying up cash in slow sellers. Done well, it produces a short list of dated orders with a reason for each. Done badly, it orders the same shortage twice, or misses one because stock that was already promised looked free.
Most replenishment errors happen before any formula runs: reserved stock counted as available, a purchase order counted both as incoming and as received, a lead time quoted in business days used as calendar days. The method below is how an experienced inventory planner does the work by hand. Each step says what to do and why, then how 10folds carries it out.
What it does for the business
- Fewer stockouts on the items that matterA dated projection shows the first day each item falls below its buffer. You see the shortage while there is still time to order, instead of when a customer finds an empty shelf.
- Less cash sitting on shelvesWhen incoming stock is counted once and reservations are netted out, orders match the real gap. You stop buying cover for shortages that were already covered.
- Orders a buyer can defendEach proposed quantity comes with its opening stock, demand, incoming supply, pack and lead time. A buyer or finance lead can check the reasoning line by line before committing money.
- Late orders surface earlyWhen the order date for a shortage has already passed, the plan says so. That leaves time to expedite, move stock between sites or warn customers, rather than discovering the gap on arrival day.
Inventory replenishment, step by step
Fix the cut-off and the stock basis
Stock from Monday and demand from Friday will never add up to a true answer.
What to do
- Choose one cut-off date and pull on-hand, held and reserved stock as of that moment.
- Define each line by SKU, variant, site and unit of measure.
- Confirm pack sizes from supplier documents before converting cases to units.
- Compute available stock as on hand minus unusable minus reserved.
- Check whether your system's available field already deducts reservations before you subtract them again.
Why
Available stock, the quantity you can still promise, is the starting point of every calculation. If damaged or quarantined stock is counted, or reservations are subtracted twice, every order that follows is wrong by the same amount, and the error looks like a forecasting problem.
Lay out demand day by day
A missing day of demand is unknown, and unknown is never zero.
What to do
- Use incremental demand: remove orders already covered by reserved stock.
- Remove firm customer orders from the forecast so the same demand is not counted twice.
- Spread demand across each day of the planning horizon, writing zero only where zero is expected.
- Record which forecast version you used.
- Write down the safety buffer, minimum order quantity, pack size and lead time for each item.
Why
A daily demand line shows when stock runs out, which a monthly total hides. Netting reserved orders and firm orders against the forecast prevents the most common double count in planning. Writing the buffer and supplier rules down keeps them from drifting each time someone runs the numbers.
Reconcile incoming supply without double counting
An order that is confirmed, shipped and partly received is easy to count three times.
What to do
- For each open purchase order or transfer, take the quantity still outstanding after partial receipts and cancellations.
- Remove receipts that are already in on-hand stock.
- Count only confirmed lines with a date when the stock becomes usable at the destination.
- Leave canceled, held and overdue lines without a new date out of the plan, and list them for follow-up.
- Use stock at another site only when a specific quantity has been set aside for this destination.
Why
Open purchase orders are where most phantom stock comes from. An original order total, a receipt already booked, or a delivery date that passed last week all make the plan look safer than it is. Surplus at another site helps only once it is reserved for one destination; otherwise two sites both plan on the same units.
Project stock and size each order
Lead time decides the order date; the shortage only tells you the arrival date.
What to do
- For each day, closing stock equals the previous closing plus confirmed receipts minus demand.
- Where the projection drops below the safety buffer, the required receipt is the gap.
- Round the quantity up to the minimum order quantity, then to a full pack.
- Subtract the lead time from the needed arrival date to get the order date.
- If that order date has already passed, mark the shortage for an expedite or transfer decision.
Why
This is the time-phased form of a reorder point: instead of one trigger level, you see the exact day stock would fall below the buffer and work back by the lead time. Rounding to pack and minimum order quantity can push stock well above the buffer, and the overage should be visible so a buyer can decide whether it is acceptable.
Hand over the queue, then check it
A plan proposes; a person with authority orders.
What to do
- List proposals by first shortage date, then by priority.
- For each buy, give SKU, variant, destination, unit, pack, minimum order, quantity, order date and arrival date.
- For each gap, ask the smallest question that resolves it: count the held stock, confirm the late delivery, supply the missing demand day.
- Have a second person recheck the first proposal, every unknown and every excluded receipt.
- Record what was approved or declined so the next cycle counts accepted orders once.
Why
A buyer needs a queue, not a spreadsheet of daily rows. A second check catches the errors that matter most in this work, such as a reservation deducted twice or a proposed buy treated as real stock. Keeping decisions between cycles stops an accepted order from being proposed again.
Common mistakes
- Counting reserved stock as freeStock promised to an order cannot cover a new one.
- Using the original purchase order quantityOnly the open balance after partial receipts and cancellations is still coming.
- Trusting a delivery date that has passedAn overdue order is not stock on the shelf until it is received.
- Filling gaps with rules of thumbAn assumed lead time or pack size produces a confident number that is wrong.
- Ordering the same shortage twiceOnce a buy is planned, carry it forward in the projection so later days see it.
What a good result looks like
- One cut-off date shared by every record.
- Opening available stock for each item and site, with the deductions shown.
- A dated list of buys and transfers, each with pack, minimum order, order date and arrival date.
- Excluded incoming orders listed with the reason and who should follow up.
- Items with missing data flagged with the one question that would resolve them.
And then what? Using the result
- Send the buy proposals to the purchasing owner for approval in your own system.
- Chase the overdue and unconfirmed orders listed as excluded.
- Answer the open questions, such as a missing lead time, so those items can be planned next cycle.
- Expedite or transfer stock for shortages whose order date has already passed.
- Run the plan again at the next cut-off with this run's decisions.
When to run it
- Before a weekly or monthly buying cycleA fresh stock bridge gives the buyer a dated queue to approve instead of a list of low-stock alerts.
- Ahead of a peak season or promotionLaying out higher daily demand against lead times shows which items must be ordered now to arrive in time.
- When a supplier's deliveries start slippingExcluding overdue orders without a new date shows the real exposure and which items to cover another way.
- When you add a site or a warehousePlanning by item and site makes clear where stock sits and which transfers are actually reserved.
Questions people ask
How do you calculate inventory replenishment?
Start from available stock at a fixed cut-off, add confirmed incoming supply, subtract daily demand, and find the first day stock falls below your safety buffer. The gap, rounded up to the minimum order and pack, is the quantity, and the arrival date minus the lead time is the order date.
What is a reorder point?
A reorder point is the stock level at which you place a new order, usually expected demand during the lead time plus safety stock. Min-max planning is a close cousin: below a minimum level, you order up to a maximum. A day-by-day projection gives the same answer as a date, which is easier to act on when demand or deliveries are uneven.
How much safety stock should I keep?
Enough to cover the demand and delivery variation you are not willing to risk, set per item from its history and importance. It is a business decision, so it should be written down and owned. The 10folds job uses the buffer you supply and never assumes one.
What is the difference between on-hand and available stock?
On-hand stock is everything physically in the location. Available stock is on hand minus damaged, held or expired stock and minus quantities already reserved for orders.
Does 10folds place purchase orders?
No. It proposes buys and transfers with the reasoning behind each. It does not raise purchase orders, reserve stock, contact suppliers or change any system.
What data does the job need?
Current on-hand stock, reservations, dated demand and incoming supply, plus the entity, the cut-off date and your rules for buffer, lead time, pack and minimum order. Decisions from the last run are optional. One entity and one cut-off date per run.
More jobs in E-commerce
Plan inventory replenishment, on your own Mac.Free app. Runs on your Mac with the Claude or Codex plan you already have. Your files stay on your computer.
Download for Mac