Reorder point is a distribution, not a date

A buyer called me in March because her 9 mm screw-thread vials ran out on a Tuesday morning with 11,000 injections still on the week’s schedule. The supplier’s quoted lead time was 15 working days. The actual delivery took 27. Her reorder point had been set at two weeks of cover, which is exactly the number you get when you divide lead time by seven and stop thinking. The gap between 15 and 27 was not a supplier failure. It was a planning failure, and it is the most common one I see in HPLC autosampler vial procurement.

This article is about the arithmetic behind hplc autosampler vial MOQ, lead time, and reorder point planning. Not the price per vial, not the freight terms (those live elsewhere), but the three numbers that decide whether you have vials on the shelf when the run starts: the minimum order quantity you are forced to buy, the lead time you actually experience rather than the one you are quoted, and the reorder point that connects them to your consumption rate. Get those three right and procurement becomes boring. Get them wrong and you spend your mornings on the phone.

The standard formula taught in every inventory course is reorder point equals average daily consumption times lead time, plus safety stock. That formula is correct and almost useless on its own, because it treats lead time as a fixed number. It is not. Lead time for a glass vial is a distribution with a mean and a spread, and the spread is what kills you.

A 2 mL clear crimp vial in 11 mm crimp format, with a 6 mm opening and a 1 mm wall, is a molded glass part made on a forming line and then washed, depyrogenated, and packed in a cleanroom. That chain has a stable nominal lead time and an unstable tail. When the forming line is running well, your order ships in 12 to 15 working days. When a mold goes down for a gob weight drift, or when the wash line is requalified, or when a distributor is allocating stock across three regions, that same order takes 25 to 35 working days. The mean might be 17 days. The 95th percentile might be 32.

Build the reorder point from the 95th percentile, not the mean

If you set your reorder point from the mean lead time, you will stock out roughly half the time. Set it from the 95th percentile and you stock out once in twenty cycles. The formula I use is:

Reorder point = (average daily consumption × 95th-percentile lead time in days) + safety stock

Safety stock covers consumption variance during the lead time. If your daily consumption is stable (a validated method running a fixed batch), safety stock can be small, maybe three to five days of cover. If your consumption swings with project load, you need a buffer sized to the swing, not to the mean. A contract lab running 40 batches a week at 60 injections per batch uses about 2,400 vials a week, or 480 a working day. A 95th-percentile lead time of 32 working days gives a reorder point of 15,360 vials before you add any safety stock. That number looks alarming until you realize it is simply the truth of a 32-day tail.

Measure lead time from PO release, not from order acknowledgement

Most labs measure lead time from the day the supplier confirms the order. That is the wrong start date. Your clock starts when you decide you need vials, because that is when the risk begins. Measure from PO release to goods receipt, including receiving inspection and quarantine release. If your QA team holds incoming vials for a two-day identity check (and they should, per your own SOP), that is two days of lead time that the supplier never sees and your reorder point must include.

I have seen labs with a quoted 14-day lead time and a measured 21-day lead time where the entire seven-day gap was internal: three days to raise the PO because it sat in an approval queue, two days in receiving, two days in QA release. Fixing the approval queue was cheaper than any inventory buffer.

What MOQ does to your carrying cost

Minimum order quantity is the number that quietly decides how much capital sits in your stockroom. Vial MOQs are set by the case pack, not by the supplier’s goodwill. A standard case of 2 mL vials is often 100 vials per pack, 10 packs per case, 1,000 vials per case. Some suppliers quote MOQ in cases, some in pallets, some in the smallest sellable pack. The number you must plan around is the smallest increment you can actually order, because that increment sets your order quantity floor.

Here is the trade-off in numbers. Suppose your consumption is 480 vials per working day and your supplier’s MOQ is 10,000 vials. Your economic order quantity (EOQ), the point where ordering cost and holding cost balance, might be 6,000 vials. The MOQ forces you to 10,000. That extra 4,000 vials is not free. It sits on a shelf, occupies a shelf position, gets counted in cycle counts, and carries a holding cost typically estimated at 20 to 25 percent of unit value per year (storage, insurance, obsolescence, capital). If the unit price is $0.12, the extra 4,000 vials represent $480 of tied capital and roughly $100 to $120 of annual carrying cost. That is small per order. Multiply by 24 orders a year and it becomes a real line item.

The MOQ you should negotiate is the case pack, not the pallet

Most distributors will sell below a full pallet if you ask. The pallet MOQ is a logistics default, not a manufacturing constraint. The manufacturing constraint is the case pack, because that is how the vials come off the packing line. If a supplier insists on a pallet MOQ, ask what the case pack is and whether they will ship cases. If the answer is no, you are talking to a reseller who buys by the pallet and cannot break it. That is a legitimate business model, but you should know which one you are buying from, because it changes your lead time and your reorder point.

For the vial itself, the case pack is usually the honest floor. A HPLC autosampler vial in 2 mL format is a commodity part with a stable mold, so case-pack MOQs are reasonable. For specialty formats (large-volume 10 mL vials, or vials with a specific septa coating), the MOQ can jump to a full production run, often 20,000 to 50,000 units, because the coating or the mold change is amortized across the run. That is where MOQ planning actually bites.

Carrying cost is not the only cost MOQ creates

There is a second cost that does not show up in the carrying-cost formula: the cost of being wrong about the lot. If you buy 50,000 vials to hit a production-run MOQ and the lot has a dimensional drift in the crimp neck (a 0.2 mm variation in the 11 mm crimp diameter is enough to cause cap seating problems on some crimpers), you now own 50,000 vials you cannot use. The MOQ that saved you 8 percent on unit price has just cost you the entire lot. This is why I argue that for a validated method, the right MOQ is the smallest quantity that covers your lead-time tail, not the largest quantity that gets you a discount.

If you want a second opinion on the dimensional tolerances that matter for your specific autosampler, the instrument vendor’s consumables documentation is the place to start. Agilent publishes vial and cap dimensions against its autosampler models at Agilent chromatography consumables and columns, and Thermo Fisher documents sample handling specs at Thermo Fisher chromatography and sample handling. Those documents are more reliable than any distributor’s datasheet, because the vendor has to make the vial fit the instrument.

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

When a buyer says “lead time,” they usually mean one number. Operationally there are three: supplier lead time (PO to shipment), transit time (shipment to dock), and internal lead time (dock to shelf). The supplier controls the first. The carrier controls the second. You control the third, and it is usually the most fixable.

I audited a pharma QC lab last year that had a measured total lead time of 34 working days against a quoted 18. The breakdown: supplier 17 days, transit 4 days, receiving 2 days, QA release 6 days, and 5 days of PO approval queue. The lab had been blaming the supplier for a year. The fix was a standing PO with a quarterly release schedule, which removed the approval queue entirely and cut the total to 29 days. The supplier’s number never changed.

Transit time is where the tail hides

For a domestic order, transit is 2 to 5 days and predictable. For an import order, transit is where the 95th percentile blows out. A container from an overseas vial manufacturer can sit at port for a week on a customs query, and a single missed sailing adds 14 days. If you import, your reorder point must use the import tail, not the domestic tail. That is a different number, and it is the number that matters if your supply is Aijiren-sourced or any other overseas manufacturer.

The practical rule: if more than 20 percent of your vial supply is imported, add 10 working days to your 95th-percentile lead time as a port buffer. It sounds crude. It has saved more stockouts than any refined model I have built.

A working reorder-point model you can set up in a spreadsheet

Here is the model I use. It takes about an hour to set up and five minutes a month to maintain. Columns: date, opening stock, receipts, consumption, closing stock. From that history, calculate average daily consumption over the last 90 days and the standard deviation of daily consumption. Then pull your last 12 purchase orders and calculate actual lead time for each (PO release to shelf). Take the mean and the standard deviation of lead time. The reorder point is:

ROP = (average daily consumption × average lead time) + Z × √(average lead time × σ²_consumption + average consumption² × σ²_lead time)

where Z is the service-level factor (1.65 for 95 percent, 2.33 for 99 percent). The square-root term is the combined safety stock, and it accounts for both consumption variance and lead-time variance. If you only remember one thing from this article, remember that the lead-time variance term is usually the larger of the two, and it is the one most labs ignore.

Parameter Example value How to measure it
Average daily consumption 480 vials/day 90-day history, working days only
σ of daily consumption 60 vials/day Standard deviation of the same 90 days
Average lead time 17 working days Last 12 POs, PO release to shelf
σ of lead time 6 working days Same 12 POs
Service level 95% (Z = 1.65) Set by QA and production risk
Safety stock ≈ 3,240 vials Z × √(17 × 60² + 480² × 6²)
Reorder point ≈ 11,400 vials (480 × 17) + 3,240
MOQ constraint 10,000 vials (10 cases) Supplier’s case pack × 10
Order quantity 12,000 vials Round ROP up to the next MOQ increment

Notice what the table shows: the reorder point (11,400) is close to the MOQ (10,000). That is not a coincidence in a high-consumption lab. It means the MOQ is not really constraining you, because you were going to order about that much anyway. The MOQ problem is worst in low-consumption labs, where the reorder point might be 1,200 vials and the MOQ is 10,000. That is where you need to negotiate, share stock with a sister lab, or accept the carrying cost.

When the reorder point and the MOQ collide, change the order structure

Low-consumption labs get squeezed. A small contract lab running 30 injections a day uses about 7,000 vials a year. Its reorder point might be 900 vials. Its supplier’s MOQ is 5,000. If it orders 5,000 at a time, it holds 8 months of stock, which is a lot of shelf space and a lot of obsolescence risk if the method changes. If it orders below MOQ, it pays a premium or cannot buy at all.

The fix is not a bigger buffer. The fix is a different order structure. Three options, in order of preference:

  • Standing order with scheduled releases. Commit to an annual quantity (say 7,000 vials) but take delivery in quarterly drops of 1,750. The supplier gets a forecast and a single PO; you get a smaller MOQ per delivery. Most distributors will do this for a committed annual volume, because it lets them plan production.
  • Consignment or vendor-managed inventory. The supplier holds stock at your site or in a local warehouse, and you are invoiced on consumption. This shifts the carrying cost to the supplier and removes the MOQ constraint from your balance sheet. It is common in high-volume pharma and increasingly available for vials.
  • Group purchasing with a sister site. If your organization has two labs, combine the MOQ and split the delivery. The administrative overhead is small and the MOQ constraint disappears.

If none of those work, accept the MOQ and plan your shelf space around it. A case of 1,000 2 mL vials occupies roughly 0.03 cubic meters. Five cases is a shelf. Twenty cases is a pallet position. Know which one you are committing to before you sign the PO.

Two field cases where the planning number was the failure

Case 1: the 27-day delivery that was really a 6-day QA hold

A food-safety lab running EPA method work (the methods are published at U.S. EPA SW-846 test methods for waste and materials) stocked out on 10 mL vials in the middle of a compliance batch. The symptom was a reorder point that had been set at 14 days of cover against a quoted 15-day lead time. The measurement that identified the problem was a simple audit of the last 10 POs: actual lead time ranged from 19 to 31 working days, and the gap was not transit. The lab’s QA team had added a 6-day lot-release hold after a previous supplier’s dimensional issue, and nobody had updated the reorder point. The fix was to rebuild the reorder point from the measured 95th percentile (31 days) and to move the QA hold to a parallel process (inspect on receipt, release against a pre-approved COA). The reorder point went from 14 days to 32 days of cover. The stockout stopped.

Case 2: the MOQ that bought a year of the wrong cap

A cannabis testing lab bought 24,000 vials to hit a production-run MOQ and get a 9 percent unit-price reduction. Three months later it switched autosamplers, and the new instrument’s gripper required a different cap height. The 24,000 vials had the old cap. The lab was left with 18,000 unusable vials and a carrying cost it had not planned for. The measurement that would have prevented it was a simple question to the instrument vendor before the PO: what cap height does the new model accept? The fix was a standing order at the case-pack MOQ (1,000 units) with a quarterly review, which cost about 6 percent more per vial and eliminated the obsolescence risk. The lesson is that the MOQ discount is a bet on your method and your instrument not changing. In a lab that changes methods, that bet is bad.

Both cases share a pattern: the planning number was set once and never revisited. Reorder points and MOQs are not set-and-forget. They are parameters that drift with your consumption, your supplier, and your method. Review them quarterly. If you want a supplier who will sit down with you and review them, that is a different conversation than buying on unit price, and it is the conversation worth having. The sample vial market has enough suppliers that you can afford to choose one who plans with you.

The decision rule

Set your reorder point from the 95th percentile of measured lead time (PO release to shelf, not quote to dock), not from the mean. Size safety stock with the combined variance formula so lead-time spread is counted, not just consumption spread. Treat the case pack as your real MOQ and negotiate delivery frequency, not unit price, when the MOQ exceeds your reorder point. Review all three numbers every quarter, because the supplier’s lead time and your consumption both drift. If your reorder point is below your MOQ, change the order structure (standing order, consignment, or group purchase) before you change the buffer. And when a stockout happens, measure the lead time before you blame the supplier, because the missing days are usually inside your own building. For the wider set of consumables that share this planning logic, see chromatography products and the technical notes at Restek technical resources for chromatography.

References & further reading

Related resources from our lab consumables network:

External references and standards: