Skip to main content

Methodology

Food Cost Percentage Planner methodology

This methodology reconciles food usage from period inventory records, measures the share of ex-tax food sales consumed by usage and compares that result with an owner-entered target.
Duc Nguyen X.By Duc Nguyen X.· Founder, Margin101Last reviewed: View update historyMethodology

Educational only: Business decision support, not accounting, tax or legal advice.

Privacy: Calculations run locally; Margin101 does not receive your commercial inputs.

Update policy: Reviewed when formulas or official dependencies change.

Scope: Market-neutral small-business planning using your own assumptions.

1. Formulas and units

Food usage
U = O + P − C

Where

O
Opening inventory at cost (currency units)Source: Business record
P
Purchases at cost (currency units)Source: Business record
C
Closing inventory at cost (currency units)Source: Business record
U
Food usage cost (currency units)Source: Calculated output
Food-cost rate
FCR = U ÷ S

Where

U
Food usage cost (currency units)Source: Calculated output
S
Food sales, ex tax (currency units/period)Source: Business record
FCR
Food-cost rate (decimal rate)Source: Calculated output
Waste share of usage
WS = W ÷ U

Where

U
Food usage cost (currency units)Source: Calculated output
W
Waste already included in usage (currency units)Source: Business record
WS
Waste share of usage (decimal rate)Source: Calculated output
Gross profit before other costs
GP = S − U

Where

U
Food usage cost (currency units)Source: Calculated output
S
Food sales, ex tax (currency units/period)Source: Business record
GP
Gross profit before other costs (currency units)Source: Calculated output
Target cost and gap
TC = S × T; G = U − TC

Where

U
Food usage cost (currency units)Source: Calculated output
S
Food sales, ex tax (currency units/period)Source: Business record
T
Target food-cost rate (decimal rate)Source: User decision
TC
Target food cost (currency units)Source: Calculated output
G
Cost gap (currency units)Source: Calculated output
Required food-cost reduction
R = (G + |G|) ÷ 2

Where

G
Cost gap (currency units)Source: Calculated output
R
Required food-cost reduction (currency units)Source: Calculated output
Sales recovery
RS = U ÷ T; AS = ((RS − S) + |RS − S|) ÷ 2; AP = RS ÷ Q

Where

U
Food usage cost (currency units)Source: Calculated output
S
Food sales, ex tax (currency units/period)Source: Business record
T
Target food-cost rate (decimal rate)Source: User decision
Q
Portions sold (whole portions)Source: Business record
RS
Required sales at current usage (currency units)Source: Calculated output
AS
Required additional sales (currency units)Source: Calculated output
AP
Required average price per portion (currency units/portion)Source: Calculated output

Money inputs and outputs use the currency selected in the scenario without changing the canonical methodology. Rates, margins, utilisation and buffers are entered as percentages and converted to decimal values for calculation.

2. Worked example

Input assumptions

A period has 1,000 of ex-tax food sales, 200 opening inventory, 400 purchases, 100 closing inventory, 50 waste already included in usage, a 40% target and 100 portions.

Calculation and outputs

Example

A period has 1,000 of ex-tax food sales, 200 opening inventory, 400 purchases, 100 closing inventory, 50 waste already included in usage, a 40% target and 100 portions.

Food usage cost
500.00
Food-cost rate
50%
Waste share of usage
10%
Gross profit before other costs
500.00
Target food cost
400.00
Food-cost gap
100.00
Required food-cost reduction
100.00
Required sales at current usage
1,250.00
Required additional sales
250.00
Required average price per portion
12.50

The engine returns 500.00 usage, 50% food cost, a 100.00 target gap and 12.50 required average price per portion.

Interpretation

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.

3. Validation and boundary checks

  • Every money input must be finite and non-negative.
  • Closing inventory cannot exceed opening inventory plus purchases.
  • Waste cannot exceed usage because waste is already included within the inventory roll-forward.
  • Target rate must stay between 0% and 100%; a zero target makes sales-recovery outputs unavailable.
  • Portions sold must be a non-negative whole number; zero portions makes price-per-portion unavailable.
  • Zero sales returns an explicit unavailable rate rather than Infinity or a fabricated percentage.

4. Assumptions and source classification

  • Inventory and purchases use one consistent cost valuation basis.
  • Sales, stock records and portions cover the same period.
  • All money values use one currency and consistent ex-tax treatment.
  • The target rate and any future sales comparison are user decisions, not external benchmarks.

This planner has no current policy-data dependency. Its commercial assumptions are user supplied. Registered family-level regression suites exercise the shared business-logic engine and worked-result reconciliation.

5. Limitations

  • The planner does not estimate missing stock counts, recipe yields or unexplained inventory adjustments.
  • Gross profit here is sales less food usage only; labour and other operating costs are excluded.
  • Required sales and average price hold current usage fixed and are scenarios, not forecasts.
  • Investigate data-quality issues before treating a calculated gap as an operating recommendation.

This is educational decision support, not tax, accounting, legal or financial advice. Check the treatment of your actual transactions under the rules that apply to your business and seek qualified advice where appropriate.

6. Update and evidence policy

Registered family-level suites test formula invariants and example reconciliation; the release ledger records that coverage without claiming a separate oracle for every line of public copy. There is no official threshold or benchmark to refresh for this planner. Commercial inputs remain user-supplied because they vary by business and contract.

Change history

  1. : Initial public release of the Food Cost Percentage planner and methodology.

Related reading

Guides to interpret the decision and its assumptions.

Return to the planner