Reorder point is a lead-time variance problem, not a lead-time average problem

Last March a QC lab in Ohio ran out of 40 mL clear 24-400 vials with PTFE-lined silicone septa on a Tuesday morning, three days into a 12-day Agilent autosampler sequence. The purchasing manager had set the reorder point at 200 units because “that felt like two weeks.” Actual consumption was 340 per week. The lot had shipped on a 21-day lead time from a distributor that quoted 10. That is the entire failure: reagent bottle MOQ, lead time, and reorder point planning is arithmetic, and the arithmetic was never done. What follows is how I set those three numbers now, after watching that same mistake play out in four different labs.

Most labs calculate reorder point as average daily consumption times average lead time. That formula fails the first time a shipment sits in customs or a glass lot gets quarantined on a dimensional check. The number you need is the one that covers the tail of the lead-time distribution, not its middle.

The working formula I use is:

ROP = (average daily consumption × average lead time in days) + safety stock

Safety stock is where the real work lives. For a normal-ish lead-time distribution, safety stock ≈ Z × σ_LT × average daily consumption, where Z is your service-level multiplier (1.65 for 95%, 2.33 for 99%) and σ_LT is the standard deviation of lead time in days. If you have never recorded lead-time variance, pull the last 12 purchase order receipt dates and compute the standard deviation. It is usually larger than anyone expects.

Run the Ohio case through it. Consumption 340/week = 48.6/day. Quoted lead time 10 days, but actual receipts ranged from 10 to 31 days over the prior year, giving σ_LT ≈ 7.2 days. At a 99% service level:

• Cycle stock: 48.6 × 10 = 486 units
• Safety stock: 2.33 × 7.2 × 48.6 = 815 units
• Reorder point: 1,301 units, not 200

That is a 6.5× miss. The lab had been running on luck for months before the luck ran out. If your ERP only accepts a single reorder point per SKU and you carry the same bottle across two methods, split the SKUs or accept the higher number for both.

Measure consumption in the unit the bottle is actually consumed in

A 500 mL amber glass bottle with a GL45 PP cap and PTFE-faced silicone liner is not consumed one bottle at a time. It is consumed in aliquots. If your method pulls 25 mL per injection and runs 40 injections per batch, one bottle covers 20 batches, minus dead volume. A 500 mL bottle with a pour ring and a dip tube typically leaves 15 to 25 mL unrecoverable at the bottom, so plan on 475 mL usable, not 500. That 5% dead volume matters when you are computing reorder point on a high-frequency SKU.

I keep a consumption sheet per SKU with three columns: units opened per week, units received per week, and the variance between the two. If the variance exceeds 10% for two consecutive months, either the method changed or someone is hoarding. Both distort the reorder point.

What an MOQ actually costs you in carrying cost

MOQ is not a purchasing convenience. It is a working-capital decision disguised as a minimum order quantity. When a supplier quotes an MOQ of 2,000 units on a 40 mL vial you consume at 340 per week, you are committing to roughly six weeks of inventory whether you need it or not.

Carrying cost runs 18% to 25% of inventory value per year for lab consumables, once you include storage footprint, insurance, obsolescence, and the cost of capital. Use 22% as a planning number. On a $0.42 vial, a 2,000-unit MOQ ties up $840 in stock and generates about $185 per year in carrying cost. That is trivial per SKU. Multiply it across 40 SKUs and you are carrying $7,400 in annual carrying cost on inventory you did not need this quarter.

The MOQ problem gets worse on slow movers. A 1 L borosilicate bottle with a GL45 cap that you consume at 4 per month, quoted at an MOQ of 48, is a four-year supply. Glass does not expire, but the PTFE-faced liner does. Silicone liners compress and take a set; after 24 months in storage, a liner that was 1.5 mm thick may not seal reliably at the torque you use. I have seen liners fail a leak check after 30 months in a warehouse that swung between 18°C and 34°C. So the MOQ on a slow mover is not just a cash cost. It is a shelf-life cost.

The MOQ break-even, worked

Compare two suppliers on a 250 mL amber bottle with GL45 PP cap and PTFE-faced liner. Supplier A quotes $1.85 at MOQ 500. Supplier B quotes $1.62 at MOQ 2,000. Annual consumption is 600 units.

Supplier A wins on total cost by about $96 per year despite the higher unit price. That is the MOQ effect in one table. The discount is real, but it is smaller than the carrying cost on the extra 700 units you did not need. Run this table before you accept any MOQ above two months of consumption.

There is a second MOQ lever most buyers miss: the case pack. Many suppliers quote MOQ in cases of 24 or 48, and the “MOQ” is really a case-pack multiple. Ask whether the case pack can be broken. A supplier that will ship 12 cases at the case price instead of 24 is often more valuable than one that will shave 3% off the unit price for a 24-case commitment.

Lead time has three components and only one of them is the supplier’s fault

When a distributor quotes 10 days, they usually mean 10 working days from order acknowledgment, not from your PO. The three components are:

• Order processing (1 to 3 days): PO receipt, credit check, allocation against stock. This is where orders sit when a rep is on vacation.
• Production or allocation (0 to 30 days): zero if the SKU is in stock, 20 to 30 days if it is a molded lot with a custom liner or a non-standard neck finish.
• Transit (2 to 10 days domestic, 3 to 8 weeks ocean freight): this is where the variance lives.

The variance is almost never in the supplier’s quoted production window. It is in transit and in the receipt inspection queue. A 24-400 vial that arrives with a dimensional check pending sits in receiving for three days. That is 3 days of lead time you did not quote, and if it happens every order, it is 3 days of σ_LT you need to build into safety stock.

Custom liner and non-standard neck finish reset the clock

A standard 40 mL clear vial with a 24-400 neck and a 1.5 mm PTFE-faced silicone septum is a stock item at most distributors. A 40 mL vial with a 24-400 neck and a 3.0 mm molded PTFE-lined septum, or one with a bonded septa configuration for a specific autosampler, is often a 4 to 6 week lead time. If your method specifies a bonded septum because the standard liner coring rate exceeded your acceptance limit, you have just converted a stock SKU into a made-to-order SKU. That is a lead-time decision, not just a quality decision.

Coring is the metric that drives it. A standard 1.5 mm silicone septum on a 22-gauge needle typically cores after 50 to 80 punctures if the needle is not sharp or the septum is not pre-pierced. A bonded or pre-slit septum can push that past 200. If your autosampler runs 96-well plates at 200 injections per plate, you are replacing septa mid-plate on the standard liner. The fix is either a bonded septum (longer lead time, higher MOQ) or a septum change protocol (more labor). Track your puncture count against your method’s RSD% and you will see the coring before the chromatogram shows it. Agilent publishes puncture guidance for its autosampler septa and it is worth reading against your own method: Agilent chromatography consumables and columns.

Set the reorder point from a rolling 13-week consumption window

A 12-month average hides seasonality. A 13-week rolling window captures the quarter you are actually in. I use 13 weeks because it is long enough to smooth a single bad week and short enough to catch a method ramp before it eats your safety stock.

The procedure:

1. Pull weekly consumption for the last 13 weeks per SKU. Include units opened, not units ordered.
2. Compute the mean and the standard deviation of weekly consumption.
3. Convert to daily: mean ÷ 7, σ ÷ √7.
4. Compute σ_LT from the last 12 receipt dates (actual receipt minus PO date).
5. Set ROP = (mean daily × mean LT) + Z × √(LT × σ_daily² + mean daily² × σ_LT²).

That last formula combines consumption variance and lead-time variance, which is the version you want when both are noisy. If your spreadsheet only does one, use the lead-time variance term. It dominates for most labs.

Worked example on a 1 L amber glass bottle with GL45 PP cap and PTFE-faced liner, used as a mobile phase reservoir:

• Mean weekly consumption: 6 units (σ = 1.8)
• Mean lead time: 14 days (σ_LT = 5.5 days)
• Daily mean: 0.857; daily σ: 0.68
• Z at 95%: 1.65
• Cycle stock: 0.857 × 14 = 12 units
• Safety stock: 1.65 × √(14 × 0.68² + 0.857² × 5.5²) = 1.65 × √(6.47 + 22.2) = 1.65 × 5.35 = 8.8 units
• ROP: 21 units

Most labs would have set this at 12 (one lead time of cover) and been surprised twice a year. The extra 9 units cost about $40 in inventory and eliminate the surprise.

Review the reorder point quarterly, not annually

A reorder point set in January is wrong by July if the method changed. I put a calendar reminder to recompute ROP on the first Monday of each quarter, using the trailing 13 weeks. If the new ROP differs from the old one by more than 20%, update it. If it differs by less, leave it alone and save the change-management paperwork.

Two field cases where the numbers, not the supplier, were the problem

Case 1: the 24-400 vial that “shipped late”

A contract lab running EPA SW-846 method 8260 flagged that 40 mL vials were arriving 8 to 11 days after the quoted 7-day lead time. The purchasing manager blamed the distributor. The receipt log told a different story: the distributor shipped on day 3 every time, and the vials sat in the receiving dock for 4 to 7 days waiting for a dimensional check that only one technician was trained to perform. The lead time was not 7 days. It was 7 days plus a 5-day inspection queue. The fix was to move the dimensional check to a sampling plan (AQL 1.0, general inspection level II per ANSI/ASQ Z1.4) so that most lots cleared in a day, and to cross-train a second technician. Lead time dropped to a mean of 9 days with σ_LT of 1.8. The reorder point fell by 40%.

The lesson: measure lead time from PO to available for use, not PO to dock. The SW-846 methods themselves do not specify vial inspection, but the QC lab’s own SOP did, and the SOP was the bottleneck: U.S. EPA SW-846 test methods for waste and materials.

Case 2: the MOQ that created a liner failure

A food-and-beverage lab bought a 2,000-unit MOQ of 125 mL amber bottles with GL45 caps and PTFE-faced silicone liners to capture a 12% unit discount. Consumption was 90 per month. At month 26, leak checks on the caps started failing at the specified 1.5 N·m torque. The liners had taken a compression set in a warehouse that hit 36°C in summer. The lab had 380 bottles left from the original lot and had to scrap them. The 12% discount was worth $168. The scrap was $410, plus the labor to re-test. The fix was a 400-unit MOQ (about 4.5 months of cover) and a first-in-first-out rotation with a 24-month liner age limit written into the SOP.

If you buy through a distributor that also supplies your autosampler vials, check whether the liner material matches across product lines. A PTFE-faced silicone liner and a pure PTFE liner have different compression behavior, and mixing them in the same cap inventory is how you get a torque spec that works on half your bottles. For the autosampler side of the same problem, see HPLC autosampler vial selection notes.

A decision checklist you can run in one sitting

Before you place the next reagent bottle order, run these eight checks. Each one has a number attached because a checklist without numbers is a wish list.

Check 8 is the one most labs skip. A single-source reagent bottle is a single point of failure, and the qualification is not just a purchase order. It is a dimensional check on the neck finish (GPI 24-400 and 45-400 are the common ones, per the Glass Packaging Institute thread standards), a leak check at the specified torque, and a run on your own method to confirm the septum does not introduce a ghost peak in the retention window you care about. Restek publishes a good baseline for ghost-peak troubleshooting if you need a reference: Restek technical resources for chromatography.

What to put in the purchase order note

I add three lines to every reagent bottle PO, and they have saved more arguments than any contract clause:

• Required on-dock date and the receiving inspection turnaround you expect (e.g., 2 business days).
• Liner material and thickness, stated in mm, plus the lot date code requirement.
• Case-pack quantity and confirmation that partial cases ship at the case price.

That last line is where MOQ flexibility actually lives. A supplier that will ship 12 cases at the 24-case price is worth more than a 5% unit discount. For a broader view of how these consumables fit into a full method, the Thermo Fisher chromatography and sample handling library is a reasonable cross-check on septum and cap compatibility.

Where the three numbers converge: a single planning rule

Here is the decision rule I use, and it has held across four labs and roughly 60 SKUs. Set the reorder point from the 13-week rolling consumption mean and the 12-receipt lead-time σ_LT at a 95% service level. Cap MOQ at two months of consumption, and if the supplier will not go below that, treat the excess as a carrying cost line in the total-cost comparison and require a unit discount that beats 22% annual carrying cost on the excess. Recompute quarterly. If you cannot get σ_LT below 5 days on a stock SKU, the problem is in your receiving process, not your supplier, and no MOQ negotiation will fix it.

If you are rebuilding a bottle program from scratch, start with the reagent bottle specification baseline at Reagent Bottle, then layer the planning numbers on top. The bottles do not change. The arithmetic does, every quarter, and that is the part most labs never put on a calendar.

References & further reading

Related resources from our lab consumables network:

• Reagent Bottle at reagentbottleforsale.com
• Hplc Autosampler Vial at hplcautosamplervials.com
• Sample Vial at samplevialprice.com
• Chromatography Products at chromatographyselling.com

External references and standards:

• Agilent chromatography consumables and columns
• Thermo Fisher chromatography and sample handling
• U.S. EPA SW-846 test methods for waste and materials
• Restek technical resources for chromatography