Food traceability/Multi-site purchasing

Commissary inventory cost: follow a batch from kitchen to site

Keep one ingredient-cost basis from production through a completed site transfer.

Central-kitchen worker arranging covered stainless food trays on a dispatch trolley.

At a glance

Keep one ingredient-cost basis from production through a completed site transfer. Divide the actual batch cost by actual output, move the relevant quantity and cost together, and reconcile what remains at both sites. A transfer changes location; it does not establish consumption or profit.

Define the costing boundary

This record follows ingredient cost only. Keep recipe version, batch reference, production date, output unit and cost basis visible. Labour, energy, transport, packaging and internal markups are excluded unless you add a separately documented method. This is an operational illustration, not a prescription for statutory inventory valuation or local tax treatment.

BCcampus · Basic Inventory Procedures

Example record and review decision

Fictional example: ingredients cost 120 monetary units and produce 30 kg of usable finished output. Unit ingredient cost is 120 ÷ 30 = 4 per kg. Record the actual output rather than using a planned yield after a different result. Do not add the same ingredients again when the finished batch enters stock.

BCcampus · Controlling Food Costs

Follow the completed delivery

A completed delivery of 12 kg carries ingredient cost 12 × 4 = 48 to the receiving site. The kitchen retains 18 kg with cost 72. Across both locations, 18 + 12 = 30 kg and 72 + 48 = 120. Preserve batch identity and the transfer reference. An internal transfer is not an external sale or evidence that the food was used.

Test a lower output

If the same ingredient cost produces only 24 kg, cost becomes 5 per kg. A completed 12 kg transfer then carries 60 and the remaining 12 kg carries 60. The transfer quantity did not change, but its cost basis did. Investigate measured yield and recipe inputs before copying yesterday’s unit cost into today’s record.

Reconcile records before adjusting stock

Compare the sender’s decrease with the receiver’s increase in the same unit and currency. Review counts, open delivery questions and duplicate records before posting a correction. The CSV includes both scenarios and a blank row; it stores values and does not recalculate. Never divide by zero output, and do not conceal an unknown batch cost with a zero.

Use the record with Kivloo

Kivloo’s procurement beta records recipe production using eligible ingredient lots and output quantity. A completed physical transfer preserves lot cost between compatible site items in the same unit and currency. Set up the records on the web and use an active connection. In-transit inventory, reservations and automatic allocation are not implemented; internal approval does not dispatch a supplier order.

Kivloo · Procurement beta

Commissary inventory cost: follow a batch from kitchen to site

Worked example

Batch costOutput kgCost per kgTransferred kgTransfer costRemaining kgRemaining cost
12030412481872
Batch cost
120
Output kg
30
Cost per kg
4
Transferred kg
12
Transfer cost
48
Remaining kg
18
Remaining cost
72

Your record

Download the worked CSV

A few useful answers

Does the CSV recalculate?

No. It contains worked values and a blank row. Recalculate after editing and verify both quantity and cost conservation.

Does a transfer prove consumption?

No. Receiving stock changes its location. Consumption or waste needs its own supported record.

Sources and further reading

Markdown

Explore starter templates

Start with a useful checklist

English