Choose a count boundary the team can repeat
A weekly food-cost report needs opening and closing stock values that describe the same operating scope. Choose a consistent cutoff and define how deliveries, transfers and production around that time are treated. The goal is to make the period reproducible, not simply to finish counting quickly.
Count through storage in a consistent order. Include all relevant locations so an item is neither missed nor counted twice after being moved. If receiving continues during the count, separate goods that belong before and after the cutoff and reconcile them with the purchase record.
Keep the count sheet's units clear. A case, inner pack, kilogram and each are different quantities. The person valuing the count should not have to guess whether a handwritten number refers to full cases or loose units.
Prepare the inventory list
Use a stable item name and purchase specification. When a supplier changes a pack, update the conversion before extending the stock value. A correct physical count multiplied by the wrong pack price can create a misleading food-usage result.
Record partial packs on a sensible basis. Weigh or measure them consistently rather than changing estimation methods between periods. The method should be practical enough to repeat and precise enough for the materiality of the ingredient.
Separate purchased ingredients from prepared batches. If raw ingredients have become a sauce, they should not remain counted as raw stock as well as appearing in the sauce value. Keep the recipe cost and finished quantity available to value prepared food consistently.
Reconcile purchases received
Use the deliveries received within the period, with the appropriate credits and adjustments. Invoice payment timing is a different record. A supplier invoice paid this week may relate to food received earlier, and a current delivery may not yet have been paid.
Check returns, shortages and substitutions. A credit that has been agreed but omitted from the operating record can leave usage overstated. A substitute pack with a different net quantity needs a conversion check even if the invoice line price looks familiar.
Keep transfers visible. Food moved between departments or locations should not appear as consumption in one place without the corresponding treatment in the other. The combined business total and individual location reports should be reconcilable.
Calculate usage before the percentage
The basic relationship is opening inventory plus purchases less closing inventory, with documented adjustments. Calculate the dollars first, then divide by matching net sales if you need a percentage.
The following example uses assumed inputs and no transfers or credits. It is a demonstration of the method, not a target food-cost result.
| Weekly record | Example amount |
|---|---|
| Opening inventory | $4,000 |
| Purchases received | $12,000 |
| Closing inventory | $3,500 |
| Calculated usage | $12,500 |
| Matching net sales | $40,000 |
| Food usage as a share of sales | 31.25% |
The usage calculation is $4,000 + $12,000 − $3,500. The percentage is $12,500 ÷ $40,000 × 100. If the sales scope excludes beverages while the usage scope includes them, the ratio needs reconciliation before it can be interpreted.
Inspect unusual results before reacting
A missed stock area lowers the closing value and raises apparent usage. A duplicated count does the opposite. A large delivery near the cutoff can also expose timing inconsistencies between purchases and physical stock.
Check those possibilities before concluding that the kitchen suddenly used more food. Compare material items with their prior counts and receipt records. An exception should lead to a specific recount or document check rather than a broad instruction to reduce cost.
Keep the original entry and the correction in the working record. Quietly replacing a number can make the final total look tidy while removing the explanation needed for the next review. The team should be able to see why the result changed.
Compare actual usage with the recipe model
Theoretical usage is the sum of current portion cost multiplied by items sold. It estimates what the documented recipes would consume for the recorded sales. It does not automatically include staff meals, discarded batches or other non-sale usage.
Assume the example week's theoretical usage is $11,500. Actual stock-based usage of $12,500 leaves a $1,000 difference. Call that an unexplained gap until the records identify its components. It is not proof of waste or misconduct.
Review recipe quantities, price dates and sales mappings as well as physical usage. An outdated recipe cost can create a gap even when portions are consistent. A modifier or substitute ingredient can also make the sales count differ from the model's expected recipe.
Record legitimate non-sale movements
Staff meals, tastings, production tests and known waste should be recorded under the operation's chosen categories. The purpose is to explain where stock went without pretending that every use became a sale.
Distinguish preparation trim from avoidable production loss and plate returns. A measured ingredient yield may already account for normal trim in the recipe model. Adding the same loss again as unexplained waste can duplicate the effect.
Use ingredient cost when valuing discarded food, with the appropriate prepared or edible basis. Potential selling price is a separate revenue concept. Keeping those measures distinct helps the team evaluate whether a change reduces cost, recovers sales or both.
Make the review actionable
Select a material issue and trace it through the records. For an expensive protein, confirm receipts, usable yield, recipe portion, items sold and closing stock. For a shared sauce, inspect the batch output and every menu item that uses it.
Assign a practical follow-up such as a recount, supplier credit check or portion measurement. Retain the result so the next report can distinguish a corrected data issue from an operating improvement. A percentage without a cause is an incomplete management conclusion.
Do not hide difficult weeks by changing the definition. Annotate unusual events, opening patterns and stock adjustments. Consistency makes the internal history useful even when the operation is not identical every week.
Keep the recipe and count systems in their proper roles
Costed Plate stores ingredients and recipes but is not a perpetual inventory or purchase-order system. Use the ledger for the theoretical recipe model and maintain receiving and physical counts in a suitable stock record. The broader software comparisons identify options when those connected controls are required.
Use the actual-versus-theoretical calculator for a reconciled period and the inventory-turnover calculator for a clearly defined usage and average-stock comparison. Export the current recipe ledger after material price or recipe changes so the basis of the theoretical calculation can be retained.
Close the period deliberately
Once the report is reviewed, retain the count, purchase list, adjustments and resulting calculation together. If a late invoice or credit changes the period, record the revision and its reason. The next opening inventory should agree with the prior closing basis after documented corrections. This continuity is what turns individual counts into a useful operating history. Without it, a tidy weekly percentage can hide inconsistent balances that make later comparisons unreliable.
Questions from the kitchen
Should stock be counted during a delivery?
Use a clear cutoff and separate received goods accordingly. Mixing receipt and count timing can distort usage.
Do I count prepared food?
Include material prepared stock consistently without also counting the raw ingredients that became it.
Is a variance proof of waste?
No. Reconcile counts, prices, credits, transfers and legitimate non-sale usage before assigning a cause.
Sources and method
Checked October 29, 2026. Example inputs and computed results are identified in the text.
- Basic Inventory Procedures. BC Cook Articulation Committee / BCcampus. Stock records, par stock and FIFO; original examples on Costed Plate. Checked 2026-10-29.
- Monthly Food Costs. BC Cook Articulation Committee / BCcampus. Opening stock plus purchases less closing stock. Checked 2026-10-29.