Act on the result
Investigate the largest controllable usage or waste source before changing menu prices or sales targets.
Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: No account is required. Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
What this planner helps you decide
Best for
Hospitality operators reconciling food usage and waste with sales for one stock-count period.
Outputs
Food usage, food-cost and waste shares, gross profit, target gap and the required cost, sales or portion-price response.
Start here
Use opening and closing stock counts on the same cost basis, and do not add waste that is already included in usage.
Use a different tool when: Do not use this to set a menu price from recipe yield and loaded portion cost; use Menu Pricing Planner for that decision. Use this tool to reconcile food usage with sales and a user-entered food-cost target.
Profit & break-even
Food Cost Percentage: food usage
Food usage, food-cost and waste shares, gross profit, target gap and the required cost, sales or portion-price response.
Amounts use the same currency as your inputs. No currency conversion is performed.
Period food-cost records
Enter one stock-count period on a consistent ex-tax cost basis. Waste is disclosed inside usage, not added again.
Food-cost decision
Use the gap to decide whether to verify stock records, reduce usage or test the sales needed at the current usage level.
PDF and CSV exports stay on this device. Clean page links contain no inputs.
- Food-cost gap to target
- 100.00
- Actual food-cost rate
- 50%
- Food usage cost
- 500.00
- Waste share of usage
- 10%
- Gross profit before other costs
- 500.00
- Target food cost
- 400.00
- Required food-cost reduction
- 100.00
- Required sales at current usage
- 1,250.00
- Additional sales required
- 250.00
- Required average price per portion
- 12.50
The inventory identity produces 500.00 of usage. The entered waste label is 50 within that amount and is not double counted.
Saved food-cost comparison
Save this exact period, change an assumption, then compare the cost and sales recovery gap.
ScenarioResultDifference
Food-cost gap to target100.00Baseline
Required food-cost reduction100.00Baseline
Additional sales required250.00Baseline
Save these results, change an input, then compare the updated figures with this baseline.
The baseline is temporary in this tab and is not added to shared scenario links or generated reports.
Calculation details
View calculation detailsView the formulas and inputs used for these results.
Food usage cost
Food usage cost
opening inventory + purchases − closing inventory500Result500.00
Uses one consistent stock-count period and ex-tax commercial basis. Raw engine precision is retained until display.
Food-cost percentage formulas →Inputs used by these formula steps
- Food usage costFood Sales Ex Tax
- 1,000
- Food usage costOpening Inventory Cost
- 200
- Food usage costPurchases Cost
- 400
- Food usage costClosing Inventory Cost
- 100
- Food usage costWaste Cost Included In Usage
- 50
- Food usage costTarget Food Cost Rate
- 0.4
- Food usage costPortions Sold
- 100
Waste share of usage
Waste share of usage
waste already included in usage ÷ food usage0.1Result10%
Uses one consistent stock-count period and ex-tax commercial basis. Raw engine precision is retained until display.
Food-cost percentage formulas →Inputs used by these formula steps
- Waste share of usageFood Sales Ex Tax
- 1,000
- Waste share of usageOpening Inventory Cost
- 200
- Waste share of usagePurchases Cost
- 400
- Waste share of usageClosing Inventory Cost
- 100
- Waste share of usageWaste Cost Included In Usage
- 50
- Waste share of usageTarget Food Cost Rate
- 0.4
- Waste share of usagePortions Sold
- 100
Food-cost rate
Food-cost rate
food usage ÷ ex-tax food sales0.5Result50%
Uses one consistent stock-count period and ex-tax commercial basis. Raw engine precision is retained until display.
Food-cost percentage formulas →Inputs used by these formula steps
- Food-cost rateFood Sales Ex Tax
- 1,000
- Food-cost rateOpening Inventory Cost
- 200
- Food-cost ratePurchases Cost
- 400
- Food-cost rateClosing Inventory Cost
- 100
- Food-cost rateWaste Cost Included In Usage
- 50
- Food-cost rateTarget Food Cost Rate
- 0.4
- Food-cost ratePortions Sold
- 100
Gross profit before other costs
Gross profit before other costs
ex-tax food sales − food usage500Result500.00
Uses one consistent stock-count period and ex-tax commercial basis. Raw engine precision is retained until display.
Food-cost percentage formulas →Inputs used by these formula steps
- Gross profit before other costsFood Sales Ex Tax
- 1,000
- Gross profit before other costsOpening Inventory Cost
- 200
- Gross profit before other costsPurchases Cost
- 400
- Gross profit before other costsClosing Inventory Cost
- 100
- Gross profit before other costsWaste Cost Included In Usage
- 50
- Gross profit before other costsTarget Food Cost Rate
- 0.4
- Gross profit before other costsPortions Sold
- 100
Target food cost
Target food cost
ex-tax food sales × target food-cost rate400Result400.00
Uses one consistent stock-count period and ex-tax commercial basis. Raw engine precision is retained until display.
Food-cost percentage formulas →Inputs used by these formula steps
- Target food costFood Sales Ex Tax
- 1,000
- Target food costOpening Inventory Cost
- 200
- Target food costPurchases Cost
- 400
- Target food costClosing Inventory Cost
- 100
- Target food costWaste Cost Included In Usage
- 50
- Target food costTarget Food Cost Rate
- 0.4
- Target food costPortions Sold
- 100
Food-cost gap to target
Food-cost gap to target
food usage − target food cost100Result100.00
Uses one consistent stock-count period and ex-tax commercial basis. Raw engine precision is retained until display.
Food-cost percentage formulas →Inputs used by these formula steps
- Food-cost gap to targetFood Sales Ex Tax
- 1,000
- Food-cost gap to targetOpening Inventory Cost
- 200
- Food-cost gap to targetPurchases Cost
- 400
- Food-cost gap to targetClosing Inventory Cost
- 100
- Food-cost gap to targetWaste Cost Included In Usage
- 50
- Food-cost gap to targetTarget Food Cost Rate
- 0.4
- Food-cost gap to targetPortions Sold
- 100
Required food-cost reduction
Required food-cost reduction
maximum of zero and the food-cost gap100Result100.00
Uses one consistent stock-count period and ex-tax commercial basis. Raw engine precision is retained until display.
Food-cost percentage formulas →Inputs used by these formula steps
- Required food-cost reductionFood Sales Ex Tax
- 1,000
- Required food-cost reductionOpening Inventory Cost
- 200
- Required food-cost reductionPurchases Cost
- 400
- Required food-cost reductionClosing Inventory Cost
- 100
- Required food-cost reductionWaste Cost Included In Usage
- 50
- Required food-cost reductionTarget Food Cost Rate
- 0.4
- Required food-cost reductionPortions Sold
- 100
Required sales at current usage
Required sales at current usage
food usage ÷ target food-cost rate1,250Result1,250.00
Uses one consistent stock-count period and ex-tax commercial basis. Raw engine precision is retained until display.
Food-cost percentage formulas →Inputs used by these formula steps
- Required sales at current usageFood Sales Ex Tax
- 1,000
- Required sales at current usageOpening Inventory Cost
- 200
- Required sales at current usagePurchases Cost
- 400
- Required sales at current usageClosing Inventory Cost
- 100
- Required sales at current usageWaste Cost Included In Usage
- 50
- Required sales at current usageTarget Food Cost Rate
- 0.4
- Required sales at current usagePortions Sold
- 100
Additional sales required
Additional sales required
maximum of zero and required sales less current sales250Result250.00
Uses one consistent stock-count period and ex-tax commercial basis. Raw engine precision is retained until display.
Food-cost percentage formulas →Inputs used by these formula steps
- Additional sales requiredFood Sales Ex Tax
- 1,000
- Additional sales requiredOpening Inventory Cost
- 200
- Additional sales requiredPurchases Cost
- 400
- Additional sales requiredClosing Inventory Cost
- 100
- Additional sales requiredWaste Cost Included In Usage
- 50
- Additional sales requiredTarget Food Cost Rate
- 0.4
- Additional sales requiredPortions Sold
- 100
Required average price per portion
Required average price per portion
required sales ÷ portions sold12.5Result12.50
Uses one consistent stock-count period and ex-tax commercial basis. Raw engine precision is retained until display.
Food-cost percentage formulas →Inputs used by these formula steps
- Required average price per portionFood Sales Ex Tax
- 1,000
- Required average price per portionOpening Inventory Cost
- 200
- Required average price per portionPurchases Cost
- 400
- Required average price per portionClosing Inventory Cost
- 100
- Required average price per portionWaste Cost Included In Usage
- 50
- Required average price per portionTarget Food Cost Rate
- 0.4
- Required average price per portionPortions Sold
- 100
Inputs used
- Food sales, ex tax
- 1,000
- Opening inventory at cost
- 200
- Purchases at cost
- 400
- Closing inventory at cost
- 100
- Waste included in usage
- 50
- Target food-cost rate
- 0.4
- Portions sold
- 100
Open this calculator with preset values
This calculator supports documented, shareable scenario URLs. Compatible assistants and applications can construct links using the parameters below.
Scenario links contain only allowlisted numeric and closed-choice inputs shown in the URL; Margin101 excludes free text and identifying fields. Anyone you share the URL with can read those numbers, so do not include private or identifying data.
| Parameter | Meaning | Unit | Allowed values | Presence | Default |
|---|---|---|---|---|---|
| closingInventoryCost | Use the closing count on the same valuation basis as opening inventory. | currency units at cost | 0 to 10000000000 | Required | 100 |
| foodSalesExTax | Use food and beverage sales for the same stock-count period. | currency units/period ex tax | 0 to 10000000000 | Required | 1000 |
| openingInventoryCost | Use the recorded opening food inventory on one consistent cost basis. | currency units at cost | 0 to 10000000000 | Required | 200 |
| portionsSold | Use whole saleable portions for the same period when assessing required average price. | whole portions/period | 0 to 100000000 | Required | 100 |
| purchasesCost | Include food purchases received into inventory during the selected period. | currency units at cost | 0 to 10000000000 | Required | 400 |
| targetFoodCostRate | Enter your own operating target; Margin101 does not insert an industry benchmark. | percent of food sales | 0 to 1 | Required | 0.4 |
| wasteCostIncludedInUsage | Label the waste already contained in the inventory roll-forward. It is not added to food usage again. | currency units at cost | 0 to 10000000000 | Required | 50 |
Food Cost Percentage: food usage
Use the inventory roll-forward to distinguish food usage from the waste already contained in that usage; the entered target is not an industry benchmark.
Formula summary
- Primary formula
- food usage = opening inventory + purchases − closing inventory; food-cost rate = food usage ÷ food sales.
Data used here
- The estimate uses your inputs and the general business formula documented in the methodology.
Decision checks
Stress-test the decision
Retest a lower sales period and a higher closing-stock count before acting on the target gap.
When this estimate can be misleading
- Use one consistent stock-count period, cost valuation method, currency and ex-tax basis.
- Waste is a labelled subset of usage; adding it again would overstate food cost.
- Targets, portion volume and future sales are owner-entered scenarios, not industry benchmarks or forecasts.
- The result excludes labour, occupancy, financing and other operating costs.
- Use the inventory roll-forward to distinguish food usage from the waste already contained in that usage; the entered target is not an industry benchmark.
Educational estimate, not advice. See all assumptions & limitations →
Related reading
Guides to interpret the decision and its assumptions.
- Food Cost Percentage Versus Gross Margin
See when food cost and gross margin are complements and when a different numerator, period, tax basis or cost scope breaks the shortcut.
Read guide
Frequently asked questions
How do I reconcile food usage with sales and a user-entered food-cost target?
Investigate the largest controllable usage or waste source before changing menu prices or sales targets.
Which planning assumptions should I stress-test?
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.