The basic reorder point formula is: expected demand during replenishment lead time + safety stock. With steady daily demand, that becomes (average daily units × lead time in days) + safety stock. It tells an ice-pack buyer when to review or trigger replenishment; it does not tell you how many units to buy.
For a distributor or private-label brand, the difficult inputs are often the selling unit, the full time until stock is usable, and how much incoming supply can actually be relied on. This guide includes a worked example and spreadsheet formulas for a single SKU.
On this page
The reorder point formula and its three inputs
Reorder point = (D × L) + S
D: expected daily demand in sellable units.
L: replenishment lead time measured on the same day basis.
S: safety stock in the same sellable units.
Oracle NetSuite’s inventory calculation documentation uses the same demand-times-lead-time-plus-safety-stock structure. The simple version below assumes a reasonably steady demand rate. A seasonal forecast needs demand across the actual replenishment period instead of an annual average.
Define a sellable unit before calculating demand
If a retail set contains two gel pouches and one cover, track demand and inventory in complete sets. Count loose pouches separately until the remaining components and packing work are available. One hundred pouches do not automatically mean one hundred sellable sets.
Calculate the demand rate for each SKU and stocking location. Avoid combining different colors, sizes or packaging versions unless you can fulfill the same customer demand with them. Review stockout periods: recorded sales during unavailable days may understate what customers wanted.
Measure the full replenishment interval
Use the time from your defined order-release event until the received goods are available to fulfill orders. Record internal approval, supplier processing, transport and receiving/release steps without double-counting overlapping work. The Oracle Inventory planning explanation includes preprocessing and postprocessing in addition to processing time.
Keep calendars consistent. Demand per calendar day cannot be multiplied directly by a supplier’s business-day production quote. Cryozin’s regular-product production lead time is 18–25 business days; custom projects take longer as confirmed for the project. This is not a door-to-door replenishment promise. Confirm the starting event and add the other applicable steps using your working calendar and route.
Choose safety stock from your own risk and records
Safety stock is a buffer for demand and supply uncertainty. Its size needs a stated basis: demand variation, delivery variation and the service level your business is trying to support. Do not insert an unexplained percentage simply because a spreadsheet has an empty cell.
NetSuite’s documentation also explains that statistical results can be approximate for intermittent, promotional, strongly seasonal or skewed demand. If records are sparse, label the buffer as a provisional planning assumption and review it against actual orders and receipts.
Worked example: a 660-unit reorder point
Assume a distributor sells one ice-pack SKU at a forecast rate of 12 retail sets per calendar day. Its planning lead time is 45 calendar days and its chosen safety stock is 120 sets. These are hypothetical teaching inputs, not Cryozin sales, transit times or a recommended buffer.
| Input or result | Calculation | Units |
|---|---|---|
| Demand during lead time | 12 × 45 = 540 | Retail sets |
| Safety stock | 120 | Retail sets |
| Reorder point | 540 + 120 = 660 | Retail sets |
| Usable on hand | 710 | Retail sets |
| Reliable open receipts | 200 | Retail sets |
| Unfulfilled committed demand | 320 | Retail sets |
| Inventory position | 710 + 200 − 320 = 590 | Retail sets |
Under the inventory-position policy in this example, 590 is below the 660-set trigger, so the buyer reviews replenishment now. If your system has already deducted commitments from its available-stock field, do not subtract them again.
Check incoming dates as well as the total
For the example, inventory position means usable on-hand stock plus reliable open receipts, minus unfulfilled committed demand. Define the equivalent fields in your own system; inventory software can treat allocations, backorders and planned receipts differently.
Exclude leaking, quarantined, unapproved or otherwise unavailable units from usable stock. Avoid counting an unconfirmed order twice through both an open PO and an in-transit record.
A total can hide a shortage before the next delivery. Plot expected receipts and commitments by date. If stock will run out before the 200 sets arrive, a healthy-looking total does not solve the gap. Review the affected customer commitments and realistic supply options with the responsible teams.
Reorder point is different from order quantity and MOQ
The trigger answers “when?” Order quantity answers “how much?” After a trigger, decide the quantity from the demand horizon, existing open orders, warehouse space, carrying cost and supplier order conditions. An economic order quantity (EOQ) model is one possible quantity method; it is not another name for the reorder point.
Cryozin’s standard MOQ is 500 pcs for most product families, and 300 pcs for pet cooling mats/pads and PCM cooling vests. Confirm the unit definition, SKU and packaging conditions before comparing these figures with a calculation in retail sets. The 300-pc exception does not apply generally to PCM neck rings or helmet liners.
Do not set the reorder point equal to MOQ without a demand-and-lead-time reason. Use the ice-pack MOQ guide for order constraints and the production lead-time guide for schedule inputs; neither replaces your own replenishment calculation.
A copyable spreadsheet layout
Use one sheet row per SKU and location. The formulas below assume English-language Excel function names and comma separators; adapt separators to your spreadsheet settings.
- B2: daily demand, using the agreed time and selling-unit basis.
- C2: full replenishment lead time on the same day basis.
- D2: safety stock, with its rationale recorded nearby.
- E2: usable on-hand units; F2: reliable open receipts; G2: unfulfilled commitments not already deducted.
- H2 — reorder point:
=ROUNDUP(B2*C2+D2,0) - I2 — inventory position:
=E2+F2-G2 - J2 — review flag:
=IF(I2<=H2,"Review replenishment","Monitor")
Enter the worked example as B2=12, C2=45, D2=120, E2=710, F2=200 and G2=320. H2 becomes 660, I2 becomes 590 and J2 reads “Review replenishment.” Validate inputs as nonnegative numbers and record receipt dates separately. This worksheet is an editorial planning aid, not an automatic purchase authorization.
When should you recalculate?
Review the inputs when demand, promotions, supplier timing, transport route or the product configuration changes. A new package may change the selling unit; a new approval step may change the interval. Keep the assumption date and owner with the calculation.
If you only review stock weekly, a continuous-review trigger can be crossed between checks. Use a planning method that accounts for the review interval and demand until the next opportunity to replenish, rather than assuming a daily alert is being monitored.
Can a new product use the formula?
Yes, as a planning estimate using a documented forecast and provisional lead time/buffer. It is not a validated demand model. Replace assumptions with observed records as the product accumulates sales and receipts.
Does a higher reorder point guarantee no stockouts?
No. Forecast errors, late arrivals, unavailable components and inaccurate stock records can still create shortages. Review dated availability and the assumptions behind the number.
Turn the trigger into a clear replenishment request
Calculate when supply needs attention, check arrival dates, then decide a workable order quantity. Keep those three decisions visible instead of treating MOQ as an inventory policy.
For repeat bulk ice-pack purchasing, send the SKU, selling-unit definition, proposed quantity, destination and required availability date. Cryozin can discuss project conditions; your demand forecast and warehouse stock policy remain buyer inputs.
Images are AI-assisted editorial scenes based on catalog product references. They do not show actual stock, warehouse operations or shipping performance.
