Food cost variance tracker India
Compare actual food cost (consumption method: opening + purchases − closing) against theoretical cost (recipe-based) by ingredient category. Variance, actual FC%, and theoretical FC% auto-computed per category and in total. Identify where waste, over-portioning, or theft is eating into margins. Print monthly variance report or export CSV. No signup.
| Category | Opening (₹) | Purchases (₹) | Closing (₹) | Actual cost | Theoretical | Variance | Revenue (₹) | Act FC% | Th FC% | Var % | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ₹0.00 | ₹0.00 | — | — | — | |||||||
| ₹0.00 | ₹0.00 | — | — | — | |||||||
| ₹0.00 | ₹0.00 | — | — | — | |||||||
| Total | ₹0.00 | ₹0.00 | ₹0.00 | ₹0.00 | ₹0.00 | ₹0.00 | ₹0.00 | 0.0% | 0.0% | 0.0% |
| Category | Opening | Purchases | Closing | Actual | Theoretical | Variance | Act FC% | Th FC% | Var% |
|---|---|---|---|---|---|---|---|---|---|
| Vegetables & Produce | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | — | — | — |
| Dairy & Eggs | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | — | — | — |
| Meat & Poultry | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | — | — | — |
| Total | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.0% | 0.0% | 0.0% |
Actual vs theoretical food cost: why the gap exists
The gap between actual food cost and theoretical food cost is one of the most important metrics in restaurant operations. The theoretical food cost is what food should cost if every portion were made exactly to recipe, with no waste, no theft, and no over-portioning. The actual food cost is what you actually spent, measured via the consumption method (opening stock + purchases − closing stock).
A well-run restaurant kitchen typically has a variance of 1–3% between actual and theoretical food cost percentage. A variance above 3% is a signal that something is wrong and needs investigation. A variance below 0% (actual less than theoretical) usually means under-recording of sales or an error in the recipe cost calculation.
Common causes of food cost variance
- Over-portioning. The most common cause in Indian restaurants. A recipe calls for 150g of paneer per portion; the cook uses 175–200g. At scale, a 20% over-portion on a high-cost ingredient adds 2–3% to overall food cost. Solution: portion scales on every station, visual reference guides, and random spot-checks.
- Unrecorded wastage. Trim waste (vegetable peels, meat fat, broken biscuits), cooking errors (burnt dishes, dropped plates), and spoilage. Should be logged daily but often isn't. Solution: a daily waste log with cause code (trim, error, spoilage, expired).
- Theft. Raw material theft (ingredients taken home), finished product theft (free meals for staff beyond policy), and POS voids and comps not matching management approval. A category that consistently shows 4–5% variance above theoretical despite controlled portioning is often a theft signal. Solution: random inventory counts mid-month, CCTV coverage of the store, manager approval required for every void and comp.
- Incorrect recipe costs. If the recipe cost card was built 6 months ago and ingredient prices have risen 15%, the theoretical cost is understated — the variance appears negative when food cost is actually well-managed. Solution: update recipe costs whenever a key ingredient price changes by more than 5%.
- Yield variance. A recipe assumes 70% yield from chicken; the actual yield from your supplier's birds is 62%. The theoretical cost is calculated on 70% yield but you're buying 13% more than planned. Solution: track yield per supplier batch and adjust recipe costs for actual yield.
- Closing stock error. The closing stock count is manual — miscounting or deliberately over-stating closing stock reduces the apparent food cost (actual = opening + purchases − closing; inflating closing deflates actual). Solution: two-person stock counts, with the manager and the head cook counting independently.
Where this fits
- Recipe cost card — the theoretical cost in this tracker comes from summing recipe cost per portion × portions sold; build and maintain recipe cards for every menu item
- Inventory count — the opening and closing stock values come from physical inventory counts; the count must be accurate for the variance calculation to be meaningful
- Wastage tracker — a portion of the variance is explainable by recorded waste; reconcile the two registers to separate planned waste from unaccounted variance
- Food cost calculator — compute overall food cost % for the restaurant; this tracker adds the category-level breakdown to identify where the cost is coming from
- Purchase order — purchases entered in this tracker should match purchase orders + GRNs for the period; reconcile both for completeness
- P6 — Unit economics pillar — complete guide to restaurant unit economics in India: food cost, labour cost, prime cost, and contribution margin