Ideal vs. Actual Food Cost: Which Inputs Explain the Gap?

By Marji · Published August 10, 2026 · Updated September 12, 2026 · 4 min read

Calculate ideal food cost by multiplying each reviewed recipe cost by the quantity sold in the same period. Calculate actual food cost from opening inventory plus net purchases minus closing inventory. Compare both against matching food sales. Investigate a gap by checking dates, units, invoice costs and portions before assigning a cause; missing records make the comparison incomplete.

Build the theoretical amount from matching recipes and sales

Ideal food cost in dollars

Sum of each recipe ingredient cost × dishes sold during the period

Use comparable ingredient scope and preparation state for every recipe. A sample recipe or AI draft remains an estimate until its inputs are reviewed.

Synthetic one-week menu; counts are manually supplied assumptions
Dish	Reviewed recipe cost assumption	Assumed dishes sold	Theoretical ingredient cost
Burger	$4.20	220	$924.00
Salad	$2.10	140	$294.00
Salmon	$8.29	95	$787.55
Pasta	$2.90	180	$522.00
Total	—	635	$2,527.55

If matching food sales for these four dishes are $11,295, the ideal food cost is $2,527.55 ÷ $11,295 × 100 = 22.38%. The dollar total preserves cents before calculating the percentage. Compare this amount with the same four dishes’ sales scope; it cannot by itself represent a restaurant with other food categories or uncounted menu items.

Obtain dish counts from your own item-sales report or other reliable sales records and retain the date range. Record whether refunded items, comps, staff meals and modifiers are included. Marji does not ingest POS sales. A number typed into a worksheet is not a verified live feed, even when it was originally copied from a POS export.

Calculate actual consumption, not just purchasing

Actual period food cost

Opening food inventory value + net food purchases − closing food inventory value

Align inventory count boundaries and sales dates. Handle transfers, returns and credits consistently with your records; keep beverage or packaging scope explicit. The same counts give inventory turnover and days on hand.

Separate synthetic whole-restaurant week; not the four-dish subset above
Input	Amount
Opening food inventory	$8,000
Net food purchases	$12,000
Closing food inventory	$7,310
Actual food consumption	$12,690
Ideal cost for all dishes in this example	$11,180
Matching food sales	$41,400

The ideal percentage is 27.0048%; actual is 30.6522%. The $1,510 difference is 3.6473 percentage points, displayed as 3.65 points when calculated before rounding. Subtracting separately rounded one-decimal percentages would show 3.7 points, which is a display artifact. Use the unrounded figures when costing the gap and preserve the chosen rounding rule in the worksheet.

Use the gap to choose evidence, not a culprit

Checks that make the comparison more reliable
Question	Evidence to collect	What the finding changes
Do the periods match?	Count timestamps, invoices received near the boundary and sales dates	Correct the period before interpreting variance
Are purchase and recipe units consistent?	Pack labels, unit conversions and yield state	Resolve wrong case, each, mass or volume bases
Are recipe prices current?	Matched, dated supplier invoices	Recost affected recipes using a consistent method
Do served portions match the recipe?	Representative weighed portion record	Separate measured overage from assumed standards
Was food consumed without a normal sale?	Waste, remake, comp and staff-meal records	Explain consumption without inventing sales
Were deliveries or credits unresolved?	Receiving record and confirmed adjustments	Correct the affected amount and retain its evidence

The invoice audit is useful when a sudden difference follows a pack change or substitution. The yield calculator checks raw-to-usable quantities. Neither establishes the cause of an entire restaurant’s variance. Different inventory valuation methods or cost timing can also create differences even when portioning is consistent.

Measure a portion scenario separately

For a synthetic ingredient priced at $9.40 per usable pound, serving 6.5 oz instead of a 6 oz standard adds 0.5 ÷ 16 × $9.40 = $0.29375 per dish. At an assumed 200 dishes per week, that adds $58.75. Extending the same assumptions for 52 weeks gives $3,055. This is a scenario contribution to investigate, not proof that portioning caused the measured period gap.

A negative variance also needs review. It can reflect recipe costs that are too high, count timing, inventory valuation, over-counted closing stock or other differences. It is not automatically a saving or automatically an error. Keep the observation, reconcile the inputs and describe what remains unknown rather than labeling a percentage healthy without context.

Repeat with a documented method

Choose the period and matching food scope, then retain its count and sales evidence.
Resolve the largest unknown recipe or invoice inputs before comparing a complete total.
Record explanations separately from confirmed adjustments. A plausible story does not close a variance.
Repeat the same method and compare the next observation, accounting for menu mix and operating changes.

Marji can help maintain reviewed recipe costs from mapped invoices; it does not supply inventory counts, accounting reconciliation or POS sales imports. Those actual-period inputs remain in your existing process. Use the variance calculator for the arithmetic after collecting them, and keep theoretical estimates distinct from observed inventory consumption.

Compare matching period totals

Enter your complete theoretical cost, actual consumption and food sales. Keep the source period with the result.

Calculate the variance