Methodology
Restaurant Prime Cost Planner methodology
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
costOfGoodsExTax = food cost + beverage costWhere
- costOfGoodsExTax
- Food and beverage cost (currency units, ex tax)Source: Calculated output
labourCostExTax = wages + payroll on-costsWhere
- payrollOnCostsExTax
- Payroll on-costs (currency units/review period, ex tax)Source: Business record
- labourCostExTax
- Restaurant labour cost (currency units, ex tax)Source: Calculated output
primeCostExTax = food and beverage cost + labour costWhere
- costOfGoodsExTax
- Food and beverage cost (currency units, ex tax)Source: Calculated output
- labourCostExTax
- Restaurant labour cost (currency units, ex tax)Source: Calculated output
- primeCostExTax
- Restaurant prime cost (currency units, ex tax)Source: Calculated output
primeCostRate = restaurant prime cost / net restaurant salesWhere
- netRestaurantSalesExTax
- Net restaurant sales (currency units/review period, ex tax)Source: Business record
- primeCostExTax
- Restaurant prime cost (currency units, ex tax)Source: Calculated output
- primeCostRate
- Restaurant prime-cost rate (decimal rate)Source: Calculated output
targetPrimeCostExTax = net restaurant sales * target prime-cost rateWhere
- netRestaurantSalesExTax
- Net restaurant sales (currency units/review period, ex tax)Source: Business record
- targetPrimeCostRate
- Target prime-cost rate (decimal fraction of net restaurant sales)Source: Business record
- primeCostExTax
- Restaurant prime cost (currency units, ex tax)Source: Calculated output
- primeCostRate
- Restaurant prime-cost rate (decimal rate)Source: Calculated output
- targetPrimeCostExTax
- Prime cost at target (currency units, ex tax)Source: Calculated output
primeCostGapExTax = actual prime cost - prime cost at targetWhere
- primeCostExTax
- Restaurant prime cost (currency units, ex tax)Source: Calculated output
- targetPrimeCostExTax
- Prime cost at target (currency units, ex tax)Source: Calculated output
- primeCostGapExTax
- Gap above or below target (currency units, ex tax)Source: Calculated output
operatingHeadroomExTax = net restaurant sales - prime cost - other operating costsWhere
- netRestaurantSalesExTax
- Net restaurant sales (currency units/review period, ex tax)Source: Business record
- otherOperatingCostsExTax
- Other restaurant operating costs (currency units/review period, ex tax)Source: Business record
- primeCostExTax
- Restaurant prime cost (currency units, ex tax)Source: Calculated output
- operatingHeadroomExTax
- Operating headroom after entered other costs (currency units, ex tax)Source: Calculated output
operatingHeadroomRate = operating headroom / net restaurant salesWhere
- netRestaurantSalesExTax
- Net restaurant sales (currency units/review period, ex tax)Source: Business record
- operatingHeadroomExTax
- Operating headroom after entered other costs (currency units, ex tax)Source: Calculated output
- operatingHeadroomRate
- Operating headroom rate (decimal rate)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
The worked rows below are evaluated at render time by the same shared engine and visible default fixture as the interactive workflow.
- Net restaurant sales
- 125,000 currency units/review period, ex tax
- Food cost of sales
- 27,000 currency units/review period, ex tax
- Beverage cost of sales
- 9,000 currency units/review period, ex tax
- Restaurant wages
- 39,000 currency units/review period, ex tax
- Payroll on-costs
- 4,000 currency units/review period, ex tax
- Other restaurant operating costs
- 28,000 currency units/review period, ex tax
- Target prime-cost rate
- 0.62 decimal fraction of net restaurant sales
Calculation and outputs
Food and beverage cost
costOfGoodsExTax = food cost + beverage cost- Food cost of sales
- 27,000 currency units/review period, ex tax
- Beverage cost of sales
- 9,000 currency units/review period, ex tax
- Target prime-cost rate
- 0.62 decimal fraction of net restaurant sales
- Restaurant labour cost
- 43,000 money
- Restaurant prime cost
- 79,000 money
- Restaurant prime-cost rate
- 0.632 percent
- Prime cost at target
- 77,500 money
- Gap above or below target
- 1,500 money
Engine result: 36,000 money
Restaurant labour cost
labourCostExTax = wages + payroll on-costs- Restaurant wages
- 39,000 currency units/review period, ex tax
- Payroll on-costs
- 4,000 currency units/review period, ex tax
- Other restaurant operating costs
- 28,000 currency units/review period, ex tax
- Operating headroom after entered other costs
- 18,000 money
Engine result: 43,000 money
Restaurant prime cost
primeCostExTax = food and beverage cost + labour cost- Food cost of sales
- 27,000 currency units/review period, ex tax
- Beverage cost of sales
- 9,000 currency units/review period, ex tax
- Target prime-cost rate
- 0.62 decimal fraction of net restaurant sales
- Food and beverage cost
- 36,000 money
- Restaurant labour cost
- 43,000 money
- Restaurant prime-cost rate
- 0.632 percent
- Prime cost at target
- 77,500 money
- Gap above or below target
- 1,500 money
Engine result: 79,000 money
Restaurant prime-cost rate
primeCostRate = restaurant prime cost / net restaurant sales- Net restaurant sales
- 125,000 currency units/review period, ex tax
- Food cost of sales
- 27,000 currency units/review period, ex tax
- Beverage cost of sales
- 9,000 currency units/review period, ex tax
- Restaurant wages
- 39,000 currency units/review period, ex tax
- Other restaurant operating costs
- 28,000 currency units/review period, ex tax
- Target prime-cost rate
- 0.62 decimal fraction of net restaurant sales
- Food and beverage cost
- 36,000 money
- Restaurant labour cost
- 43,000 money
- Restaurant prime cost
- 79,000 money
- Prime cost at target
- 77,500 money
- Gap above or below target
- 1,500 money
Engine result: 0.632 percent
Prime cost at target
targetPrimeCostExTax = net restaurant sales * target prime-cost rate- Net restaurant sales
- 125,000 currency units/review period, ex tax
- Food cost of sales
- 27,000 currency units/review period, ex tax
- Beverage cost of sales
- 9,000 currency units/review period, ex tax
- Restaurant wages
- 39,000 currency units/review period, ex tax
- Other restaurant operating costs
- 28,000 currency units/review period, ex tax
- Target prime-cost rate
- 0.62 decimal fraction of net restaurant sales
- Food and beverage cost
- 36,000 money
- Restaurant labour cost
- 43,000 money
- Restaurant prime cost
- 79,000 money
- Restaurant prime-cost rate
- 0.632 percent
- Gap above or below target
- 1,500 money
- Operating headroom rate
- 0.144 percent
Engine result: 77,500 money
Gap above or below target
primeCostGapExTax = actual prime cost - prime cost at target- Food cost of sales
- 27,000 currency units/review period, ex tax
- Beverage cost of sales
- 9,000 currency units/review period, ex tax
- Target prime-cost rate
- 0.62 decimal fraction of net restaurant sales
- Food and beverage cost
- 36,000 money
- Restaurant labour cost
- 43,000 money
- Restaurant prime cost
- 79,000 money
- Restaurant prime-cost rate
- 0.632 percent
- Prime cost at target
- 77,500 money
Engine result: 1,500 money
Operating headroom after entered other costs
operatingHeadroomExTax = net restaurant sales - prime cost - other operating costs- Net restaurant sales
- 125,000 currency units/review period, ex tax
- Food cost of sales
- 27,000 currency units/review period, ex tax
- Beverage cost of sales
- 9,000 currency units/review period, ex tax
- Restaurant wages
- 39,000 currency units/review period, ex tax
- Payroll on-costs
- 4,000 currency units/review period, ex tax
- Other restaurant operating costs
- 28,000 currency units/review period, ex tax
- Target prime-cost rate
- 0.62 decimal fraction of net restaurant sales
- Food and beverage cost
- 36,000 money
- Restaurant labour cost
- 43,000 money
- Restaurant prime cost
- 79,000 money
- Restaurant prime-cost rate
- 0.632 percent
- Prime cost at target
- 77,500 money
- Gap above or below target
- 1,500 money
- Operating headroom rate
- 0.144 percent
Engine result: 18,000 money
Operating headroom rate
operatingHeadroomRate = operating headroom / net restaurant sales- Net restaurant sales
- 125,000 currency units/review period, ex tax
- Food cost of sales
- 27,000 currency units/review period, ex tax
- Beverage cost of sales
- 9,000 currency units/review period, ex tax
- Restaurant wages
- 39,000 currency units/review period, ex tax
- Other restaurant operating costs
- 28,000 currency units/review period, ex tax
- Restaurant labour cost
- 43,000 money
- Restaurant prime cost
- 79,000 money
- Restaurant prime-cost rate
- 0.632 percent
- Operating headroom after entered other costs
- 18,000 money
Engine result: 0.144 percent
Example
The worked rows below are evaluated at render time by the same shared engine and visible default fixture as the interactive workflow.
- Food and beverage cost
- 36,000 currency units
- Restaurant labour cost
- 43,000 currency units
- Restaurant prime cost
- 79,000 currency units
- Restaurant prime-cost rate
- 63.2%
- Prime cost at target
- 77,500 currency units
- Gap above or below target
- 1,500 currency units
- Operating headroom after entered other costs
- 18,000 currency units
- Operating headroom rate
- 14.4%
The exact engine-derived outputs are shown in the labelled rows below.
Interpretation
The prime-cost gap compares your entered direct-cost definition with your own target.
3. Validation and boundary checks
- All inputs must be finite and inside the visible validation boundaries.
- Rates are retained as decimal values and shown as percentages only at the presentation boundary.
- The worked fixture must expose every declared result: costOfGoodsExTax, labourCostExTax, primeCostExTax, primeCostRate, targetPrimeCostExTax, primeCostGapExTax, operatingHeadroomExTax, operatingHeadroomRate.
- Scenario comparison changes one declared driver while holding the remaining industry records constant.
- Net restaurant sales minimum
netRestaurantSalesExTax โฅ 0 currency units/review period, ex taxโ A lower value is rejected before calculation.- Net restaurant sales maximum
netRestaurantSalesExTax โค 10,000,000 currency units/review period, ex taxโ A higher value is rejected before calculation.- Food cost of sales minimum
foodCostOfSalesExTax โฅ 0 currency units/review period, ex taxโ A lower value is rejected before calculation.- Food cost of sales maximum
foodCostOfSalesExTax โค 10,000,000 currency units/review period, ex taxโ A higher value is rejected before calculation.- Beverage cost of sales minimum
beverageCostOfSalesExTax โฅ 0 currency units/review period, ex taxโ A lower value is rejected before calculation.- Beverage cost of sales maximum
beverageCostOfSalesExTax โค 10,000,000 currency units/review period, ex taxโ A higher value is rejected before calculation.- Restaurant wages minimum
restaurantWagesExTax โฅ 0 currency units/review period, ex taxโ A lower value is rejected before calculation.- Restaurant wages maximum
restaurantWagesExTax โค 10,000,000 currency units/review period, ex taxโ A higher value is rejected before calculation.- Payroll on-costs minimum
payrollOnCostsExTax โฅ 0 currency units/review period, ex taxโ A lower value is rejected before calculation.- Payroll on-costs maximum
payrollOnCostsExTax โค 10,000,000 currency units/review period, ex taxโ A higher value is rejected before calculation.- Other restaurant operating costs minimum
otherOperatingCostsExTax โฅ 0 currency units/review period, ex taxโ A lower value is rejected before calculation.- Other restaurant operating costs maximum
otherOperatingCostsExTax โค 10,000,000 currency units/review period, ex taxโ A higher value is rejected before calculation.- Target prime-cost rate minimum
targetPrimeCostRate โฅ 0 decimal fraction of net restaurant salesโ A lower value is rejected before calculation.- Target prime-cost rate maximum
targetPrimeCostRate โค 1 decimal fraction of net restaurant salesโ A higher value is rejected before calculation.
4. Assumptions and source classification
- Costs, capacity, contract terms, tax rates and targets are supplied by the user.
- No provider default, jurisdictional rule or industry benchmark is embedded.
- The shared engine retains full precision and display formatting never feeds calculation.
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
- Results are only as reliable as the timing, scope and basis of the entered records.
- The workflow does not predict demand or establish accounting, tax, contractual or legal treatment.
- Wages, payroll on-costs and the prime-cost target are user-entered records or decisions; the visible starting target is not an industry benchmark.
- The model does not apply wage rules, payroll tax, tips, service charges or jurisdiction-specific labour obligations.
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
- : Initial public release of the Restaurant Prime Cost planner and methodology.
Related reading
Guides to interpret the decision and its assumptions.
- Restaurant Economics: From Menu Price to Operating Profit
Trace menu price through contribution, operating capacity and period costs without confusing a dish margin with operating profit.
Read guide