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.
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.
Three uppercase letters, such as USD. All prices use this currency; no exchange-rate conversion.
Exact scaling prepares only planned sales. Whole batches incur food and labor for every prepared portion, including unsold portions.
Your target, above 0 through 100%. It covers food only; it is not a profit-margin guarantee.
Cost for the same period as planned sales. Contribution is shown before this cost; the remaining amount still excludes unentered expenses.
Shared ingredient catalog
Enter supplier pack prices and measured usable yields. Recipes share these ingredients and raw stock. Buying a whole pack creates purchase cash and possible leftover inventory; it does not add a second food expense.
Recipes and planned sales
Use one planning period for the entire menu. Ingredient quantities describe one complete recipe batch. A forecast is an assumption, not a demand prediction.
The menu at a glance
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
| Recipe | Sold / prepared / unsold | Revenue | Food | Labor | Packaging | Revenue fees | Contribution | Contribution per sold portion | Production food % |
|---|---|---|---|---|---|---|---|---|---|
| Chicken rice bowls | 10 / 10 / 0 | USD 80 | USD 18 | USD 10 | USD 5 | USD 4 | USD 43 | USD 4.3 | 22.5% |
Trace a recipe’s cost
| Ingredient / unit | Usable per batch | Raw per batch | Food cost per batch | Raw needed for production | Food cost for production |
|---|---|---|---|---|---|
| Chicken / g | 1000 | 1250 | USD 12.5 | 1250 | USD 12.5 |
| Rice / g | 500 | 500 | USD 1.5 | 500 | USD 1.5 |
| Vegetables / g | 800 | 1000 | USD 4 | 1000 | USD 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.
| Ingredient / unit | Raw needed | Stock used | Shortfall | Packs to buy | New quantity | Purchase cash | Raw remaining | Remaining value |
|---|---|---|---|---|---|---|---|---|
| Chicken / g | 1250 | 0 | 1250 | 1 | 2000 | USD 20 | 750 | USD 7.5 |
| Rice / g | 500 | 200 | 300 | 1 | 1000 | USD 3 | 700 | USD 2.1 |
| Vegetables / g | 1000 | 0 | 1000 | 1 | 1000 | USD 4 | 0 | USD 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.
Full sales sensitivity table (21 samples)
| Selected recipe sales | Selected recipe prepared | Whole-menu food cost | Whole-menu contribution | New purchase cash | Raw inventory value remaining |
|---|---|---|---|---|---|
| 0 | 0 | USD 0 | USD 0 | USD 0 | USD 0.6 |
| 1 | 1 | USD 1.8 | USD 4.3 | USD 24 | USD 22.8 |
| 2 | 2 | USD 3.6 | USD 8.6 | USD 24 | USD 21 |
| 3 | 3 | USD 5.4 | USD 12.9 | USD 24 | USD 19.2 |
| 4 | 4 | USD 7.2 | USD 17.2 | USD 24 | USD 17.4 |
| 5 | 5 | USD 9 | USD 21.5 | USD 27 | USD 18.6 |
| 6 | 6 | USD 10.8 | USD 25.8 | USD 27 | USD 16.8 |
| 7 | 7 | USD 12.6 | USD 30.1 | USD 27 | USD 15 |
| 8 | 8 | USD 14.4 | USD 34.4 | USD 27 | USD 13.2 |
| 9 | 9 | USD 16.2 | USD 38.7 | USD 27 | USD 11.4 |
| 10 | 10 | USD 18 | USD 43 | USD 27 | USD 9.6 |
| 11 | 11 | USD 19.8 | USD 47.3 | USD 31 | USD 11.8 |
| 12 | 12 | USD 21.6 | USD 51.6 | USD 31 | USD 10 |
| 13 | 13 | USD 23.4 | USD 55.9 | USD 31 | USD 8.2 |
| 14 | 14 | USD 25.2 | USD 60.2 | USD 31 | USD 6.4 |
| 15 | 15 | USD 27 | USD 64.5 | USD 31 | USD 4.6 |
| 16 | 16 | USD 28.8 | USD 68.8 | USD 31 | USD 2.8 |
| 17 | 17 | USD 30.6 | USD 73.1 | USD 51 | USD 21 |
| 18 | 18 | USD 32.4 | USD 77.4 | USD 51 | USD 19.2 |
| 19 | 19 | USD 34.2 | USD 81.7 | USD 51 | USD 17.4 |
| 20 | 20 | USD 36 | USD 86 | USD 51 | USD 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
- 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.
- 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.
- 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.
- 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.
- 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
Recipe Scaling Calculator
Scale ingredient quantities from original servings to desired servings with fraction-friendly kitchen output.
Profit Margin Calculator
Calculate gross, operating, and net profit margin percentages for your business or product.
EOQ & Inventory Ordering Planner
Compare economic order quantities with pack sizes, all-units discounts, storage and order budgets. Visualize carrying costs, stock cycles and supplier tradeoffs.
Wedding & Event Beverage Calculator
Plan wedding and event beverage purchases by guest group and event phase. Compare demand scenarios, whole-pack orders, stock shortages, leftovers and costs.
