Food traceabilityMulti-site purchasing
Commissary inventory cost: follow a batch from kitchen to site
Keep one ingredient-cost basis from production through a completed site transfer.

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.
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.
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.
Commissary inventory cost: follow a batch from kitchen to site
Worked example
| Batch cost | Output kg | Cost per kg | Transferred kg | Transfer cost | Remaining kg | Remaining cost |
|---|---|---|---|---|---|---|
| 120 | 30 | 4 | 12 | 48 | 18 | 72 |
- 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 CSVA 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
MarkdownExplore starter templates
Start with a useful checklist
English


