Restaurant Menu Profitability Planner methodology

totalRevenueExTax = sum(item units sold * item price)

totalDirectCostExTax = sum(waste-adjusted ingredients + labour + packaging + channel fees)

totalContributionExTax = total revenue - total direct cost

contributionMargin = total contribution / total revenue

signatureRequiredPriceExTax = signature non-fee cost / (1 - channel fee - target margin)

secondRequiredPriceExTax = second-item non-fee cost / (1 - channel fee - target margin)

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.

• 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: totalRevenueExTax, totalDirectCostExTax, totalContributionExTax, contributionMargin, signatureRequiredPriceExTax, secondRequiredPriceExTax.
• Scenario comparison changes one declared driver while holding the remaining industry records constant.

Signature item units sold minimum

signatureUnitsSold ≥ 0 whole portions/review period — A lower value is rejected before calculation.

Signature item units sold maximum

signatureUnitsSold ≤ 100,000,000 whole portions/review period — A higher value is rejected before calculation.

Signature item menu price minimum

signatureSellingPriceExTax ≥ 0 currency units/portion, ex tax — A lower value is rejected before calculation.

Signature item menu price maximum

signatureSellingPriceExTax ≤ 10,000,000 currency units/portion, ex tax — A higher value is rejected before calculation.

Signature item ingredient cost minimum

signatureIngredientCostPerUnitExTax ≥ 0 currency units/portion, ex tax — A lower value is rejected before calculation.

Signature item ingredient cost maximum

signatureIngredientCostPerUnitExTax ≤ 10,000,000 currency units/portion, ex tax — A higher value is rejected before calculation.

Signature item labour minutes minimum

signatureLabourMinutesPerUnit ≥ 0 minutes/portion — A lower value is rejected before calculation.

Signature item labour minutes maximum

signatureLabourMinutesPerUnit ≤ 1,440 minutes/portion — A higher value is rejected before calculation.

Signature item packaging cost minimum

signaturePackagingCostPerUnitExTax ≥ 0 currency units/portion, ex tax — A lower value is rejected before calculation.

Signature item packaging cost maximum

signaturePackagingCostPerUnitExTax ≤ 10,000,000 currency units/portion, ex tax — A higher value is rejected before calculation.

Signature item channel-fee rate minimum

signatureChannelFeeRate ≥ 0 decimal fraction of signature-item revenue — A lower value is rejected before calculation.

Signature item channel-fee rate maximum

signatureChannelFeeRate ≤ 1 decimal fraction of signature-item revenue — A higher value is rejected before calculation.

Signature item waste rate minimum

signatureWasteRate ≥ 0 decimal fraction of signature-item ingredient requirement lost — A lower value is rejected before calculation.

Signature item waste rate maximum

signatureWasteRate ≤ 1 decimal fraction of signature-item ingredient requirement lost — A higher value is rejected before calculation.

Second item units sold minimum

secondUnitsSold ≥ 0 whole portions/review period — A lower value is rejected before calculation.

Second item units sold maximum

secondUnitsSold ≤ 100,000,000 whole portions/review period — A higher value is rejected before calculation.

Second item menu price minimum

secondSellingPriceExTax ≥ 0 currency units/portion, ex tax — A lower value is rejected before calculation.

Second item menu price maximum

secondSellingPriceExTax ≤ 10,000,000 currency units/portion, ex tax — A higher value is rejected before calculation.

Second item ingredient cost minimum

secondIngredientCostPerUnitExTax ≥ 0 currency units/portion, ex tax — A lower value is rejected before calculation.

Second item ingredient cost maximum

secondIngredientCostPerUnitExTax ≤ 10,000,000 currency units/portion, ex tax — A higher value is rejected before calculation.

Second item labour minutes minimum

secondLabourMinutesPerUnit ≥ 0 minutes/portion — A lower value is rejected before calculation.

Second item labour minutes maximum

secondLabourMinutesPerUnit ≤ 1,440 minutes/portion — A higher value is rejected before calculation.

Second item packaging cost minimum

secondPackagingCostPerUnitExTax ≥ 0 currency units/portion, ex tax — A lower value is rejected before calculation.

Second item packaging cost maximum

secondPackagingCostPerUnitExTax ≤ 10,000,000 currency units/portion, ex tax — A higher value is rejected before calculation.

Second item channel-fee rate minimum

secondChannelFeeRate ≥ 0 decimal fraction of second-item revenue — A lower value is rejected before calculation.

Second item channel-fee rate maximum

secondChannelFeeRate ≤ 1 decimal fraction of second-item revenue — A higher value is rejected before calculation.

Second item waste rate minimum

secondWasteRate ≥ 0 decimal fraction of second-item ingredient requirement lost — A lower value is rejected before calculation.

Second item waste rate maximum

secondWasteRate ≤ 1 decimal fraction of second-item ingredient requirement lost — A higher value is rejected before calculation.

Loaded kitchen labour cost per hour minimum

loadedKitchenLabourCostPerHourExTax ≥ 0 currency units/hour, ex tax — A lower value is rejected before calculation.

Loaded kitchen labour cost per hour maximum

loadedKitchenLabourCostPerHourExTax ≤ 10,000,000 currency units/hour, ex tax — A higher value is rejected before calculation.

Target contribution margin minimum

targetContributionMargin ≥ 0 decimal fraction of item revenue — A lower value is rejected before calculation.

Target contribution margin maximum

targetContributionMargin ≤ 0.99 decimal fraction of item revenue — A higher value is rejected before calculation.

Per-item whole-unit and rate validation

Number.isInteger(item units sold) and 0 ≤ channel fee ≤ 1 and 0 ≤ waste rate < 1 — A menu item outside any combined boundary is rejected.

Zero-revenue contribution margin

totalRevenueExTax = 0 — contributionMargin is null rather than Infinity or NaN.

Required-price retained share

1 − channel fee rate − target contribution margin ≤ 0 — The engine returns unreachable_target and no required item price.

• 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.

• 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.
• Channel fees, loaded labour cost, waste rates and target margin are editable scenario inputs; the visible starting values are not provider fees, wage rules or industry benchmarks.
• Tax, tips, service charges, menu-labelling requirements and delivery-platform contract terms are outside the model.

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.

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.

1. 2026-07-31: Initial public release of the planner and methodology after pre-launch calculation, content, source and interaction review.