How do I measure how much of a minimum lot is likely to outlast its usable shelf window?
Consume usable opening stock first. This simplified exposure model assumes constant demand and one expiry window.
Open Minimum order exposureTry the worked example
These are the example inputs from Minimum order exposure. Replace them in the tool to run your own case.
| Minimum order (units) | Current usable stock (units) | Weekly draw (units/wk) | Usable weeks on arrival (wk) | Unit cost (€/unit) |
|---|---|---|---|---|
| 600 | 85 | 35 | 12 | 2.8 |
Example result
New units exposed · 265 units
Who uses this?
Consumables buyer. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
A person reviews the output and handles exceptions before buying. This independent application adapts that idea to measure how much of a minimum lot is likely to outlast its usable shelf window.
Original video