How much should you order on a last time buy of a chemical?

This method sizes a one-time purchase of one discontinued chemical that you use as bought. It does not cover a supplier that only reformulates and keeps the product name, or a chemical whose use must end on a regulatory sunset date, where the date and not the substitute sets the bridge.

What is the formula for a chemical last time buy quantity?

The chemical last time buy quantity is monthly usage times the bridge months until a qualified substitute is in use, plus safety stock, minus stock on hand and open orders, then capped by shelf life and storage. Write it as: buy = (usage per month x bridge months) + safety stock - stock on hand - open orders. Then take the smallest of that number, the quantity you can consume before the retest or expiry date, and the quantity you can store. Round to the supplier's pack size and minimum order last. Stock on hand counts only if it is within its own date and stored correctly, and open orders count only if the supplier has confirmed them before the last order date.

The input table below decides each term of the formula and what to do when an input is uncertain.

The key row is qualification time: each extra month of qualification adds one month of usage to the buy.

How do you forecast chemical usage through a last time buy period?

Forecast chemical usage through a last time buy period from at least 12 months of actual issue or consumption records, then adjust for known changes in the customers or lines that use the chemical. Twelve months is the shortest window that includes one full seasonal cycle, so a shorter history can miss a peak (illustrative rule of thumb). Use issues from stock, not purchases, because purchases include stock building.

Check three things before you settle on a rate. First, the trend: a product line that is growing or being phased out changes the rate month by month, so use the expected average over the bridge period, not the last month. Second, demand that will move with the discontinuation: a customer that hears the chemical is ending may order ahead, or may switch early. Third, one-off events in the history, such as a trial batch or a spill, which should be removed.

Safety stock covers the error in this forecast and any delay in qualification. A simple approach is to hold one to two months of usage as safety stock, set by how far actual monthly usage has strayed from the average in the history (illustrative). A wider spread in past usage calls for more months.

How does shelf life cap a last time buy of a chemical?

Shelf life caps a chemical last time buy at the quantity you can consume between delivery and the retest or expiry date on the material delivered. Compute it as monthly usage times the months of shelf life left at delivery, minus the months that stock on hand will cover first. Anything above that cap will reach its date before you can use it.

The type of date matters. ICH Q7, the GMP guide for active pharmaceutical ingredients (APIs), defines a retest date as "the date when a material should be re-examined to ensure that it is still suitable for use" (ICH, 2000). The same guide defines an expiry date as the date after which the API "should not be used" (ICH, 2000), and says common practice for APIs is a retest date, not an expiration date (ICH, 2000). Industrial chemicals follow the supplier's own label and CoA, so ask the supplier which date applies and whether retesting can extend use.

When the bridge period is longer than the shelf life, split the buy into scheduled deliveries up to the last delivery date in the notice, plan a retest for material that carries a retest date, or shorten the bridge by speeding up qualification.

How long does qualifying a substitute chemical take, and how does it set the buy?

Qualifying a substitute chemical takes as long as your own plan and your customers' approvals take, and that duration sets the bridge months in the buy. No general figure applies across chemicals: a cleaning agent used in-house may need one plant trial, while a chemical written into a customer specification may need sample approval, a production trial and the customer's formal change approval.

Build the qualification time from its steps. List finding candidates, lab screening, a plant or line trial, the customer's sample review and any formal change notice, and give each step a duration and an owner. Add the time to switch over stock and labels once approval arrives. The sum is the bridge period, and the buy covers it.

Treat the qualification estimate as the main risk in the buy. A buy sized on an optimistic plan runs out before approval, while a buy sized on a pessimistic plan leaves stock that ages on the shelf. Before you fix the number, check the supplier and customer risks of the change itself, as covered in how to assess supplier risk when changing a raw material, because a substitute that fails late resets the bridge.

How do you work out a chemical last time buy in an example?

A worked chemical last time buy multiplies usage by bridge months, adds safety stock, subtracts stock on hand and then applies the shelf life and storage caps in turn. The example below uses illustrative values for a liquid additive bought in 200 kg drums.

The calculation table below shows each step and which cap binds (all values illustrative).

In this illustrative example shelf life binds: the buy is 3,400 kg, which covers the 3,600 kg of bridge usage but leaves only 400 kg of the planned 800 kg safety stock. Close the gap by asking the supplier to split the delivery across the delivery period, or by planning a retest for the last drums. If the storage cap had been lower than the shelf life cap, more space or a second delivery would be the fix instead. Recheck the calculation each time the qualification plan slips, because the bridge months drive every later step.

Where does the last time buy formula not fit chemicals?

The last time buy formula does not fit chemicals well when quantity is not the main limit: when the supplier can cut your order, when the usage rate itself is uncertain, or when the substitute decision is still open. Notices from one electronics maker say that last time buy orders for limited-availability products are filled first come, first served (NXP, 2023), so a sized order may still be cut.

Leftover stock is the other limit. If the substitute is approved early, the extra drums either age out or become waste. Disposal follows SDS section 13, disposal considerations, where the supplier includes it (OSHA 29 CFR 1910.1200 Appendix D), and the waste rules of your jurisdiction. In the US, the amount of hazardous waste a site generates in a calendar month sets its generator category under RCRA (US EPA, accessed 2026), so scrapping a large lot at once can change which rules apply.

When several options are open, such as buying the full bridge, buying less and accelerating qualification, or moving customers to a new grade, compare them side by side rather than sizing one. In Lubinpla, the feasibility review Task compares ways to absorb a discontinuation as scenarios, reading the project's product usage records first.