Food Cost Calculator & Menu Planner

Build an inspectable menu budget from supplier packs, measured ingredient yields and recipe quantities. This food cost calculator connects up to eight recipes to a shared ingredient catalog, so stock and purchases are counted once for the menu. Compare exact scaling with whole-batch production, see the cost of prepared but unsold portions, and trace food, labor, packaging and revenue-based fees. Separate ingredient consumption from new purchase cash and remaining raw inventory. The examples use hypothetical prices and sales assumptions; this is standard recipe costing, not a live supplier quote, demand forecast or complete business-profit calculation.

Menu costing lab

Know the cost behind every portion

Trace ingredient yields, compare production with sales, and separate food consumed from the cash needed to restock.

Build your menu plan

Start from hypothetical prices, then enter your recipes, measured yields and sales assumptions. Contribution is revenue less the entered production and selling costs; it is not net profit. No taxes, live supplier prices or prepared-leftover reuse are assumed.

The menu at a glance

Contribution before fixed overhead
USD 43
Revenue less food, labor, packaging and entered revenue fees.
Food consumed
USD 18
Includes existing stock valued at the entered pack unit price.
New purchase cash
USD 27
Whole packs after available raw stock; not an extra food expense.
Raw inventory remaining
USD 9.6
Standard value of unused raw stock, not prepared leftovers.

10 sold · 10 prepared · 0 prepared but unsold. Mode: exact scaling to sales.

Sales revenue
USD 80
Food consumed
USD 18
Production labor
USD 10
Packaging on sold portions
USD 5
Revenue-based fees
USD 4
Entered fixed overhead
USD 20
Amount after entered overhead
USD 23

Production food cost / sales revenue: 22.5%. The amount after entered overhead still excludes all unentered expenses. Purchase cash is shown separately to avoid double-counting ingredients.

Sales mix and contribution

Horizontal: planned portions sold, 0–10. Vertical: contribution per sold portion, USD 0 to USD 4.3. The dashed line is zero; the outlined point is the inspected recipe. Zero-sales recipes have no per-sale value and are omitted from the plot.
Planned sales versus contribution per sold portion. Exact values for every recipe follow in the menu table.
Every recipe in the plan — amounts in USD
RecipeSold / prepared / unsoldRevenueFoodLaborPackagingRevenue feesContributionContribution per sold portionProduction food %
Chicken rice bowls10 / 10 / 0USD 80USD 18USD 10USD 5USD 4USD 43USD 4.322.5%

Trace a recipe’s cost

Standard food cost per prepared portion
USD 1.8
Full recipe food cost divided by its portion yield.
Food cost per sold portion
USD 1.8
Includes food in all prepared portions, even unsold ones.
Prepared but unsold
0
1 recipe batches prepared.
Ingredient share of produced food cost: USD 18. Each ingredient’s exact quantity and value is listed below.
Chicken rice bowls produced food cost USD 18. Ingredient costs follow in the table.
Recipe ingredient quantities in g, ml or each
Ingredient / unitUsable per batchRaw per batchFood cost per batchRaw needed for productionFood cost for production
Chicken / g10001250USD 12.51250USD 12.5
Rice / g500500USD 1.5500USD 1.5
Vegetables / g8001000USD 41000USD 4

Price implied by your 30% food-cost target

Standard recipe basis: USD 6 per portion. With this production plan: USD 6 per sold portion.

These prices cover a food-cost percentage only. They do not establish a profit margin or account for demand. Standard food / current selling price: 22.5%; actual production food / revenue: 22.5%.

Buy once for the whole menu

Raw requirements are combined across all recipes before stock is used and whole packs are purchased. Existing stock uses the entered pack unit price for costing. No shelf-life, spoilage or supplier availability is inferred.

Shared purchasing — quantities in g, ml or each
Ingredient / unitRaw neededStock usedShortfallPacks to buyNew quantityPurchase cashRaw remainingRemaining value
Chicken / g12500125012000USD 20750USD 7.5
Rice / g50020030011000USD 3700USD 2.1
Vegetables / g10000100011000USD 40USD 0

Inventory value check: opening USD 0.6 + purchases USD 27 − food consumed USD 18 = remaining USD 9.6. Displayed amounts may round; the calculation and CSV retain exact values.

What changes when this recipe sells more?

Only Chicken rice bowls planned sales changes. Other recipes and all cost assumptions stay fixed; shared purchasing is recalculated. The 21 discrete samples include nearby batch thresholds. They are not a demand forecast, every breakpoint or an optimum.

At 10 sales: whole-menu contribution USD 43, new purchase cash USD 27.

Circles: contribution before overhead. Squares: new purchase cash. Vertical range USD 0 to USD 86; dashed line marks zero. Do not subtract purchase cash from contribution again.
Whole-menu contribution and purchase cash for Chicken rice bowls sales from 0 through 20. Discrete sample values follow in the table.
0 portions sold20 portions sold
Full sales sensitivity table (21 samples)
Selected recipe salesSelected recipe preparedWhole-menu food costWhole-menu contributionNew purchase cashRaw inventory value remaining
00USD 0USD 0USD 0USD 0.6
11USD 1.8USD 4.3USD 24USD 22.8
22USD 3.6USD 8.6USD 24USD 21
33USD 5.4USD 12.9USD 24USD 19.2
44USD 7.2USD 17.2USD 24USD 17.4
55USD 9USD 21.5USD 27USD 18.6
66USD 10.8USD 25.8USD 27USD 16.8
77USD 12.6USD 30.1USD 27USD 15
88USD 14.4USD 34.4USD 27USD 13.2
99USD 16.2USD 38.7USD 27USD 11.4
1010USD 18USD 43USD 27USD 9.6
1111USD 19.8USD 47.3USD 31USD 11.8
1212USD 21.6USD 51.6USD 31USD 10
1313USD 23.4USD 55.9USD 31USD 8.2
1414USD 25.2USD 60.2USD 31USD 6.4
1515USD 27USD 64.5USD 31USD 4.6
1616USD 28.8USD 68.8USD 31USD 2.8
1717USD 30.6USD 73.1USD 51USD 21
1818USD 32.4USD 77.4USD 51USD 19.2
1919USD 34.2USD 81.7USD 51USD 17.4
2020USD 36USD 86USD 51USD 15.6

Keep the menu worksheet

Export exact inputs, recipe and purchasing ledgers, totals and every sensitivity sample for the inspected recipe. Quantities use g, ml or each; fractions preserve precision.

How to use this calculator

  1. Load Ten portions, exact scaling or Twelve sales, whole batches, then open Edit ingredients and recipes. Select the production method, currency, food-only cost target and fixed overhead for the same period as planned sales.
  2. In Shared ingredient catalog, enter each supplier pack’s raw quantity and price, measured usable yield and raw stock on hand. Select mass, volume or count and a matching unit. Unit changes convert every linked quantity; measurement-type changes require new quantities and yield.
  3. For each recipe, enter portions per batch, planned portions sold, selling price excluding sales tax, packaging per sold portion, batch labor and the entered revenue-based fee. Add its usable ingredient quantities for one complete batch. Keep raw and usable quantities distinct to avoid applying the yield loss twice.
  4. Update menu costs. Review contribution separately from purchase cash, then inspect a recipe’s ingredient ledger, prepared-versus-sold quantities and food-only target prices. The shared purchasing table combines ingredient needs across the entire menu.
  5. Choose a sampled sales count to inspect how batches and purchases change. Read the complete sales sensitivity table or download menu CSV to retain exact inputs, recipe and purchasing ledgers, totals and every sample for the inspected recipe. A selectable CSV copy is also available.

The Formula

The mathematical logic powering this calculation is:

For each ingredient, raw quantity per recipe batch = usable recipe quantity / (measured usable yield % / 100). Raw unit cost = pack price / raw quantity per pack. Standard recipe food cost is the sum of raw ingredient quantities × their raw unit costs. Standard food cost per portion = recipe food cost / portions per batch. Yield uses the same measurement dimension on both sides; a value above 100% explicitly represents usable-output gain. No ingredient density is inferred.
Exact scaling uses batches = planned portions sold / portions per batch. Whole-batch production uses batches = ceil(planned portions sold / portions per batch). Prepared portions = batches × portions per batch; prepared but unsold = prepared − sold. Zero sales produces zero batches in either mode. Food and labor are incurred for every prepared portion, with no reuse credit for unsold prepared food. Labor per batch = entered minutes × hourly cost / 60. Packaging is charged only on sold portions.
Revenue = selling price × planned portions sold. Revenue-based fee = revenue × fee % / 100. Contribution before fixed overhead = revenue − produced food cost − production labor − sold-portion packaging − revenue fees. Amount after entered overhead = contribution − entered fixed overhead. These figures omit unentered costs and are not complete net profit. Negative contribution is valid and remains visible.
Aggregate each ingredient’s raw need across every recipe before purchasing. Stock used = min(raw stock on hand, raw need). Shortfall = raw need − stock used. Packs to buy = ceil(shortfall / quantity per pack); purchase cash = packs × pack price. Remaining raw quantity = opening raw stock + new pack quantity − raw need. Existing stock and remaining stock use the current entered pack unit price. Inventory value identity: opening stock value + new purchase cash − food consumed = remaining raw stock value. Purchase cash is not deducted from contribution again: doing so would count ingredients twice. This is a standard-cost planning identity, not inventory lot accounting.
Standard food-cost percentage = 100 × standard food cost per portion / selling price. Production food-cost percentage = 100 × produced food cost / sales revenue. A zero denominator makes the percentage unavailable, not zero. Standard price at a food-cost target = standard food per portion / (target % / 100). Production-adjusted price at that target = (produced food cost / portions sold) / (target % / 100), unavailable when no portions are sold. These food-only target prices do not establish a profit margin or predict customer demand.
The sensitivity view changes only one recipe’s planned sales and recalculates shared purchasing. It uses up to 59 distinct integer samples from zero through min(1,000,000, max(20, twice current sales, twice batch portions)). A 41-point rounded grid is supplemented with the current count, adjacent counts and nearby batch edges. It does not enumerate every breakpoint or solve for an optimum. Contribution and purchase cash are separate series, not quantities to subtract again.
Units: canonical mass is grams, volume is millilitres and counts are each. Exact conversions include 1 lb = 453.59237 g, 1 oz = 28.349523125 g, 1 US cup = 236.5882365 ml and 1 US fluid ounce = 29.5735295625 ml. Changing an ingredient’s unit converts its pack size, raw stock and every linked recipe quantity together. Changing measurement dimension or replacing a recipe ingredient clears affected quantities rather than reinterpreting them. Arithmetic uses exact rational values; CSV retains fractions and displayed rounding does not feed back into totals.
Supported inputs: 1–24 ingredients, 1–8 recipes, 1–24 unique ingredient references per recipe; integer portions per batch 1–10,000 and planned sales 0–1,000,000 per recipe. Pack and recipe ingredient quantities are positive through 1 billion canonical units, raw stock is 0–1 trillion canonical units, measured usable yield is above 0 through 1,000%, food-cost target above 0 through 100%, and revenue fee 0–100%. Quantities allow nine-place decimals or bounded exact fractions; money and percentages allow six-place decimals. Money is in one entered currency, excluding sales tax. No currency conversion, spoilage, perishability, prepared-leftover inventory, nutritional calculation, supplier availability, recipe suitability or wage/tax rule is modeled.

Worked Example

If you input:

  • Recipe: 10 chicken rice bowls: 1,000 g usable chicken, 500 g rice and 800 g usable vegetables per batch; 10 planned sales.
  • Packs and yields: Chicken: 2,000 g for USD 20, 80% yield. Rice: 1,000 g for USD 3, 100% yield, 200 g stock. Vegetables: 1,000 g for USD 4, 80% yield.
  • Sales and other costs: USD 8 per portion, USD 0.50 packaging per sale, 30 labor minutes per batch at USD 20/hour, 5% of revenue in fees, USD 20 entered fixed overhead; food-cost target 30%.

Result:

The batch needs 1,250 g raw chicken, 500 g rice and 1,000 g raw vegetables. Consumed food costs USD 12.50 + USD 1.50 + USD 4 = USD 18, or USD 1.80 per portion. Revenue is USD 80; labor is USD 10, packaging USD 5 and revenue fees USD 4. Contribution is USD 80 − 18 − 10 − 5 − 4 = USD 43 before fixed overhead, or USD 23 after the entered USD 20 overhead. One pack of each ingredient costs USD 27 in new purchases. Opening rice stock is valued at USD 0.60, so remaining raw inventory is USD 0.60 + 27 − 18 = USD 9.60. Food cost is 22.5% of revenue; the standard price at a 30% food-only target is USD 6. For the whole-batch example with 12 sales, two batches prepare 20 portions: food costs USD 36, contribution is USD 29.20, and eight prepared portions are unsold.

Frequently Asked Questions

What is the difference between food cost and purchase cash?

Food cost values the raw ingredients consumed by the production plan, including existing stock. Purchase cash pays for whole new packs after stock is used. A pack may leave unused raw inventory. Deducting both consumed food cost and all purchases from contribution would count some ingredients twice.

Why does whole-batch production lower contribution in the example?

Twelve planned sales require two 10-portion batches. The planner incurs food and labor for all 20 prepared portions, while revenue, packaging and revenue fees apply to 12 sold portions. The eight unsold portions receive no reuse or inventory credit. Actual operations may handle leftovers differently; that is outside this model.

What does usable yield mean, and can it exceed 100%?

It is your measured usable-output quantity divided by raw input quantity, in the same dimension. An 80% yield means 100 raw units supply 80 usable units; 200% means the output quantity doubles. Enter a yield matching the exact ingredient form used in the recipe. The planner provides no universal ingredient-yield database or mass-to-volume density conversion.

Does a 30% food-cost target guarantee profit?

No. The target only relates food cost to a selling price. Labor, packaging, revenue fees, overhead, unentered expenses and demand also matter. The calculator separately shows entered costs and contribution, but does not recommend a universal target or certify a profitable menu price.

Why is a percentage unavailable when sales or price is zero?

Food-cost percentage divides food cost by revenue or selling price. A zero denominator has no defined percentage. Zero sales remains a valid plan with no production or purchasing, while theoretical recipe costs remain available. Complimentary portions can incur costs and negative contribution even though their selling price is zero.

How are ingredients shared between recipes?

Each recipe references the shared catalog. Raw needs are added before stock is used and whole packs are purchased. Changing an ingredient’s pack price or yield affects every recipe that uses it. The same ingredient may appear once per recipe; combine duplicate quantities into that line.

Are the sensitivity points a break-even or demand forecast?

No. They are discrete recalculations with only the inspected recipe’s sales count changed. Nearby batch thresholds are included to reveal jumps, but not every possible breakpoint is sampled. Other recipes, prices and stock remain fixed; neither demand nor an optimal menu is predicted.

Does this calculate accounting net profit or actual inventory usage?

No. It uses entered standard recipe quantities and current pack unit prices. It omits inventory lot costs, spoilage, theft, prepared-leftover reuse, unentered expenses and tax rules. Contribution is before entered fixed overhead; the amount after that overhead is still not a complete business-profit statement. Compare assumptions with actual purchasing and sales records.

Similar Calculators