Food Cost Percentage Calculator

What this calculator includes

• Calculate privately in this tab without an account.
• Use one connected workflow for recipe cost, period food usage and selling-price decisions.
• Keep ingredients, variable contribution and monthly funding requirements distinct.
• Use explicit weight, volume and count units without assuming ingredient density.
• View worked examples, formulas and source references.

How to calculate actual food cost percentage

1. Choose one completed period and use its opening/closing inventory counts at cost.
2. Enter received food purchases and supplier credits only once.
3. Enter net food sales for those dates; do not dilute a food-only numerator with beverage-inclusive sales.
4. Optionally enter theoretical ingredients for the dishes actually sold, at relevant recipe prices.
5. Reconcile the gap before changing prices. Compare counts, receipts, yields, portions and non-sale usage.

Food usage and variance formulas

Food used = opening inventory + purchases − supplier credits − closing inventory. Actual food-cost percentage = food used ÷ net food sales × 100.

Theoretical percentage = matched recipe usage ÷ food sales × 100. Dollar variance = actual food used − theoretical usage. Percentage-point gap = dollar variance ÷ food sales × 100.

The optional field distinguishes blank (unknown) from zero (a stated zero). Negative usage is rejected as a reconciliation problem. Sales must be positive to calculate a percentage.

Checked inventory-period examples

The default period gives $20,000 actual food used and 33.33% food cost. The $18,200 theoretical model gives 30.33%; the gap is $1,800 and 3.00 percentage points.

If closing inventory is $4,000 rather than $6,000 with every other input unchanged, usage rises to $22,000 and the actual rate to 36.67%. That movement is not automatically all waste.

If the original $20,000 food usage is divided by $72,000 beverage-inclusive total sales, the result appears to improve to 27.78%. That mixes the input boundaries rather than improving ingredient consumption.

Investigate the gap before repricing

1. Recheck expensive-item counts, purchase cutoff and supplier credits first.
2. Compare the sold mix with recipe quantities, ingredient prices and actual prep yield.
3. Record waste and staff meals to explain consumption; do not add their cost again when already captured in stock usage.
4. Use recipe costing for one dish and menu pricing for full per-unit contribution; neither is this period reconciliation.

Assumptions and limits

Use one period, inventory valuation basis and food-sales boundary. Credits are subtracted only when purchases have not already been reduced. Inventory usage can include waste, staff meals and count errors; it is not automatically cost of normal paid meals alone. Theoretical usage must represent the actual sold mix. Beverage sales, labor, packaging, tax and fixed overhead are excluded unless you deliberately redefine both inputs consistently.

Frequently asked questions

Method references

• Restaurant recipe costing — RestoMetrics
• Weight and volume conversions — NIST
• Break-even contribution method — SBA