Food traceability/Procurement 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

Small and larger produce crates filled with tomatoes on a kitchen receiving worktop.

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.

BCcampus · Basic Inventory Procedures

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.

Kivloo · Procurement beta

When the cheaper case creates more perishable stock than you can use

Worked example

Offer A cashOffer B cashB leftoverB expiry exposure
€20€427 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 CSV

A 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

Markdown