Food traceabilityProcurement planning
When the cheaper case creates more perishable stock than you can use
Compare the cash required for a complete supplier pack with the quantity you can use before its real expiry cutoff

At a glance
Compare the cash required for a complete supplier pack with the quantity you can use before its real expiry cutoff. Subtract usable opening stock from dated demand, round the purchase to valid packs and show the projected leftover separately from booked waste.
Define the measurement
Start with a dated demand window and the actual lot expiry and arrival times. Count only usable opening stock. Treat every supplier offer as an alternative scenario, not as another delivery to add to the same plan. Confirm minimum quantities, pack multiples and freight. The lowest displayed price per kilogram may require purchasing more kilograms than the kitchen can use.
Example record and review decision
Fictional alternatives: 1 kg usable opening stock, 6 kg expected consumption before the incoming lot expires, and no other receipts. Net need is 5 kg. Offer A is a 5 kg case at €4/kg with no freight: buy 5 kg for €20, and total available 6 kg matches demand. Offer B is a 12 kg case at €3.50/kg with no freight: buy 12 kg for €42, leaving 7 kg after the same demand.
Check the result and its limits
Assume the existing 1 kg is used first and all seven leftover kilograms belong to the new lot at its expiry cutoff. In scenario B, €17.50 of the purchase is used and €24.50 is exposed to expiry; together they reconcile to the €42 purchase. This is a forecast exposure, not an actual waste entry. The €22 difference in cash outlay between alternatives is not a guaranteed saving or a measured profit increase.
Choose the next action
Ask whether the supplier can offer a smaller case, split delivery or a different confirmed date, then recalculate any freight and minimum. Do not assume a split is available at the same price. Check a demand increase against capacity and the approved service plan rather than inventing consumption to justify the case. A larger order arriving later cannot repair a shortage before that arrival.
Use the downloadable record
The CSV contains the two alternative offers and a blank comparison. It shows opening stock, demand, net need, pack size, unit price, purchased quantity, cash outlay, leftover and its cost exposure. Plain values do not update automatically after editing. Keep opening inventory cost outside this incremental-purchase comparison because the same opening stock is present in both alternatives; do not add it twice.
Check the workflow in Kivloo
Kivloo's procurement beta considers usable lots, dated demand, approved incoming orders, lead time, review interval, shelf life, packs, minimums and delivery costs. It shows warnings about pre-arrival shortages and possible excess. The ranking is a transparent heuristic, not a global optimum guarantee. Review actual supplier terms and dates before approving internally. Web setup and an active connection are required; supplier dispatch is arranged separately.
When the cheaper case creates more perishable stock than you can use
Worked example
| Offer A cash | Offer B cash | B leftover | B expiry exposure |
|---|---|---|---|
| €20 | €42 | 7 kg | €24.50 |
- Offer A cash
- €20
- Offer B cash
- €42
- B leftover
- 7 kg
- B expiry exposure
- €24.50
Your record
Download the worked CSVA few useful answers
Does the CSV recalculate after editing?
No. It contains plain worked values and a blank record. Recalculate after changing inputs, keep units consistent and verify the result before using it.
Are the examples measured business results?
No. They are fictional planning examples with explicit assumptions, not evidence of savings or a guaranteed outcome.
Sources and further reading
MarkdownExplore starter templates
Start with a useful checklist
English

