Table Turnover & Revenue Planner methodology

averageTurnsPerService = service minutes / average seating minutes

availableSeatTurns = tables × seats per table × service periods × average turns per service

plannedCovers = available seat-turn capacity × planned occupancy rate

plannedRevenueExTax = planned covers × average spend per guest

unitContributionExTax = average spend per guest − variable cost per guest

contributionBeforeFixedCostExTax = planned covers × contribution per guest

profitAfterFixedCostExTax = contribution before fixed cost − fixed period cost

breakEvenOccupancyRate = fixed period cost / (available seat-turn capacity × contribution per guest)

breakEvenFeasible = break-even occupied seat-turns is no greater than available capacity

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 remain inside the visible validation boundaries.
• Whole-count fields reject fractional table, seat, service, capacity or transaction counts where specified.
• Revenue per unit must exceed variable cost per unit when a positive fixed cost must be recovered.
• Occupancy and variable-cost rates remain inside the closed range from 0% to 100%.
• A required occupancy above 100% is reported as outside available capacity, not hidden or capped.

Tables available minimum

tableCount ≥ 1 tables — A lower value is rejected before calculation.

Tables available maximum

tableCount ≤ 100,000 tables — A higher value is rejected before calculation.

Average seats per table minimum

seatsPerTable ≥ 1 seats/table — A lower value is rejected before calculation.

Average seats per table maximum

seatsPerTable ≤ 1,000 seats/table — A higher value is rejected before calculation.

Service periods minimum

servicePeriods ≥ 1 services/period — A lower value is rejected before calculation.

Service periods maximum

servicePeriods ≤ 100,000 services/period — A higher value is rejected before calculation.

Minutes per service minimum

serviceMinutes ≥ 1 minutes/service — A lower value is rejected before calculation.

Minutes per service maximum

serviceMinutes ≤ 10,080 minutes/service — A higher value is rejected before calculation.

Average seating duration minimum

averageSeatingMinutes ≥ 1 minutes/seating — A lower value is rejected before calculation.

Average seating duration maximum

averageSeatingMinutes ≤ 10,080 minutes/seating — A higher value is rejected before calculation.

Planned occupied seat-turns minimum

occupancyRate ≥ 0 proportion of available seat-turn capacity occupied — A lower value is rejected before calculation.

Planned occupied seat-turns maximum

occupancyRate ≤ 1 proportion of available seat-turn capacity occupied — A higher value is rejected before calculation.

Average spend per guest minimum

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

Average spend per guest maximum

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

Variable cost per guest minimum

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

Variable cost per guest maximum

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

Fixed cost for the period minimum

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

Fixed cost for the period maximum

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

• All capacity, occupancy, duration, volume, price and cost values are supplied by the user.
• Money inputs use one consistent ex-tax basis and all records refer to the same operating period.
• Proposed occupancy, transaction count and average transaction value are scenarios, not forecasts.
• The engine retains raw precision and display formatting never feeds back into calculation.
• No jurisdiction, provider fee, industry benchmark or current policy value is embedded.

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 depend on comparable service, capacity and commercial records for the selected period.
• The model does not forecast demand, customer behaviour, no-shows, service quality or capacity disruption.
• Average values can conceal day-part, product-mix, party-size and channel differences.
• The planner does not replace operational, accounting, tax, legal or financial advice.

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-16: Initial public release of the Table Turnover and Revenue planner and methodology.