Methodology
Occupancy Break-even 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
unitContributionExTax = revenue per occupied unit โ variable cost per occupied unitWhere
- revenuePerOccupiedUnitExTax
- Revenue per occupied unit (currency units/occupied unit, ex tax)Source: Business record
- variableCostPerOccupiedUnitExTax
- Variable cost per occupied unit (currency units/occupied unit, ex tax)Source: Business record
- unitContributionExTax
- Contribution per occupied unit (currency units, ex tax)Source: Calculated output
exactBreakEvenOccupiedUnits = fixed period cost / contribution per occupied unitWhere
- fixedPeriodCostExTax
- Fixed cost for the period (currency units/period, ex tax)Source: Business record
- unitContributionExTax
- Contribution per occupied unit (currency units, ex tax)Source: Calculated output
- exactBreakEvenOccupiedUnits
- Exact break-even occupied units (units)Source: Calculated output
wholeBreakEvenOccupiedUnits = exact break-even occupied units rounded upwardWhere
- exactBreakEvenOccupiedUnits
- Exact break-even occupied units (units)Source: Calculated output
- wholeBreakEvenOccupiedUnits
- Whole break-even occupied units (units)Source: Calculated output
breakEvenOccupancyRate = exact break-even occupied units / available capacity unitsWhere
- availableCapacityUnits
- Available capacity units (occupied units/period)Source: Business record
- exactBreakEvenOccupiedUnits
- Exact break-even occupied units (units)Source: Calculated output
- breakEvenOccupancyRate
- Break-even occupancy (decimal rate)Source: Calculated output
plannedOccupiedUnits = available capacity units ร planned occupancy rateWhere
- availableCapacityUnits
- Available capacity units (occupied units/period)Source: Business record
- plannedOccupancyRate
- Planned occupancy (proportion of available capacity occupied)Source: User decision
- plannedOccupiedUnits
- Planned occupied units (units)Source: Calculated output
plannedRevenueExTax = planned occupied units ร revenue per occupied unitWhere
- revenuePerOccupiedUnitExTax
- Revenue per occupied unit (currency units/occupied unit, ex tax)Source: Business record
- plannedOccupiedUnits
- Planned occupied units (units)Source: Calculated output
- plannedRevenueExTax
- Planned revenue (currency units, ex tax)Source: Calculated output
plannedContributionBeforeFixedCostExTax = planned occupied units ร contribution per occupied unitWhere
- unitContributionExTax
- Contribution per occupied unit (currency units, ex tax)Source: Calculated output
- plannedOccupiedUnits
- Planned occupied units (units)Source: Calculated output
- plannedContributionBeforeFixedCostExTax
- Planned contribution before fixed cost (currency units, ex tax)Source: Calculated output
plannedProfitAfterFixedCostExTax = planned contribution before fixed cost โ fixed period costWhere
- fixedPeriodCostExTax
- Fixed cost for the period (currency units/period, ex tax)Source: Business record
- unitContributionExTax
- Contribution per occupied unit (currency units, ex tax)Source: Calculated output
- plannedContributionBeforeFixedCostExTax
- Planned contribution before fixed cost (currency units, ex tax)Source: Calculated output
- plannedProfitAfterFixedCostExTax
- Planned profit after fixed cost (currency units, ex tax)Source: Calculated output
occupancyGap = planned occupancy rate โ break-even occupancy rateWhere
- plannedOccupancyRate
- Planned occupancy (proportion of available capacity occupied)Source: User decision
- breakEvenOccupancyRate
- Break-even occupancy (decimal rate)Source: Calculated output
- occupancyGap
- Occupancy headroom (decimal rate)Source: Calculated output
breakEvenFeasible = break-even occupancy is no greater than available capacityWhere
- availableCapacityUnits
- Available capacity units (occupied units/period)Source: Business record
- breakEvenOccupancyRate
- Break-even occupancy (decimal rate)Source: Calculated output
- breakEvenFeasible
- Break-even capacity status (feasibility status)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 labelled rows below are formatted directly from the exact engine using the visible default inputs.
- Available capacity units
- 1,000 occupied units/period
- Revenue per occupied unit
- 50 currency units/occupied unit, ex tax
- Variable cost per occupied unit
- 20 currency units/occupied unit, ex tax
- Fixed cost for the period
- 9,000 currency units/period, ex tax
- Planned occupancy
- 0.4 proportion of available capacity occupied
Calculation and outputs
Contribution per occupied unit
unitContributionExTax = revenue per occupied unit โ variable cost per occupied unit- Revenue per occupied unit
- 50 currency units/occupied unit, ex tax
- Variable cost per occupied unit
- 20 currency units/occupied unit, ex tax
- Fixed cost for the period
- 9,000 currency units/period, ex tax
- Exact break-even occupied units
- 300 units
- Whole break-even occupied units
- 300 units
- Planned occupied units
- 400 units
- Planned revenue
- 20,000 money
- Planned contribution before fixed cost
- 12,000 money
- Planned profit after fixed cost
- 3,000 money
Engine result: 30 money
Exact break-even occupied units
exactBreakEvenOccupiedUnits = fixed period cost / contribution per occupied unit- Revenue per occupied unit
- 50 currency units/occupied unit, ex tax
- Variable cost per occupied unit
- 20 currency units/occupied unit, ex tax
- Fixed cost for the period
- 9,000 currency units/period, ex tax
- Contribution per occupied unit
- 30 money
- Whole break-even occupied units
- 300 units
- Planned occupied units
- 400 units
- Planned contribution before fixed cost
- 12,000 money
- Planned profit after fixed cost
- 3,000 money
Engine result: 300 units
Whole break-even occupied units
wholeBreakEvenOccupiedUnits = exact break-even occupied units rounded upward- Revenue per occupied unit
- 50 currency units/occupied unit, ex tax
- Variable cost per occupied unit
- 20 currency units/occupied unit, ex tax
- Contribution per occupied unit
- 30 money
- Exact break-even occupied units
- 300 units
- Break-even occupancy
- 0.3 percent
- Planned occupied units
- 400 units
- Break-even capacity status
- Yes status
Engine result: 300 units
Break-even occupancy
breakEvenOccupancyRate = exact break-even occupied units / available capacity units- Available capacity units
- 1,000 occupied units/period
- Revenue per occupied unit
- 50 currency units/occupied unit, ex tax
- Variable cost per occupied unit
- 20 currency units/occupied unit, ex tax
- Contribution per occupied unit
- 30 money
- Exact break-even occupied units
- 300 units
- Whole break-even occupied units
- 300 units
- Planned occupied units
- 400 units
- Break-even capacity status
- Yes status
Engine result: 0.3 percent
Planned occupied units
plannedOccupiedUnits = available capacity units ร planned occupancy rate- Available capacity units
- 1,000 occupied units/period
- Planned occupancy
- 0.4 proportion of available capacity occupied
- Break-even occupancy
- 0.3 percent
- Planned revenue
- 20,000 money
- Planned contribution before fixed cost
- 12,000 money
- Planned profit after fixed cost
- 3,000 money
- Occupancy headroom
- 0.1 percent
- Break-even capacity status
- Yes status
Engine result: 400 units
Planned revenue
plannedRevenueExTax = planned occupied units ร revenue per occupied unit- Revenue per occupied unit
- 50 currency units/occupied unit, ex tax
- Variable cost per occupied unit
- 20 currency units/occupied unit, ex tax
- Planned occupancy
- 0.4 proportion of available capacity occupied
- Contribution per occupied unit
- 30 money
- Exact break-even occupied units
- 300 units
- Whole break-even occupied units
- 300 units
- Planned occupied units
- 400 units
- Planned contribution before fixed cost
- 12,000 money
- Planned profit after fixed cost
- 3,000 money
Engine result: 20,000 money
Planned contribution before fixed cost
plannedContributionBeforeFixedCostExTax = planned occupied units ร contribution per occupied unit- Revenue per occupied unit
- 50 currency units/occupied unit, ex tax
- Variable cost per occupied unit
- 20 currency units/occupied unit, ex tax
- Planned occupancy
- 0.4 proportion of available capacity occupied
- Contribution per occupied unit
- 30 money
- Exact break-even occupied units
- 300 units
- Whole break-even occupied units
- 300 units
- Planned occupied units
- 400 units
- Planned revenue
- 20,000 money
- Planned profit after fixed cost
- 3,000 money
Engine result: 12,000 money
Planned profit after fixed cost
plannedProfitAfterFixedCostExTax = planned contribution before fixed cost โ fixed period cost- Variable cost per occupied unit
- 20 currency units/occupied unit, ex tax
- Fixed cost for the period
- 9,000 currency units/period, ex tax
- Planned occupancy
- 0.4 proportion of available capacity occupied
- Contribution per occupied unit
- 30 money
- Planned occupied units
- 400 units
- Planned revenue
- 20,000 money
- Planned contribution before fixed cost
- 12,000 money
Engine result: 3,000 money
Occupancy headroom
occupancyGap = planned occupancy rate โ break-even occupancy rate- Planned occupancy
- 0.4 proportion of available capacity occupied
- Exact break-even occupied units
- 300 units
- Whole break-even occupied units
- 300 units
- Break-even occupancy
- 0.3 percent
- Planned occupied units
- 400 units
- Planned revenue
- 20,000 money
- Planned contribution before fixed cost
- 12,000 money
- Planned profit after fixed cost
- 3,000 money
- Break-even capacity status
- Yes status
Engine result: 0.1 percent
Break-even capacity status
breakEvenFeasible = break-even occupancy is no greater than available capacity- Available capacity units
- 1,000 occupied units/period
- Planned occupancy
- 0.4 proportion of available capacity occupied
- Exact break-even occupied units
- 300 units
- Whole break-even occupied units
- 300 units
- Break-even occupancy
- 0.3 percent
- Occupancy headroom
- 0.1 percent
Engine result: Yes status
Example
The labelled rows below are formatted directly from the exact engine using the visible default inputs.
- Contribution per occupied unit
- 30 currency units
- Exact break-even occupied units
- 300
- Whole break-even occupied units
- 300
- Break-even occupancy
- 30%
- Planned occupied units
- 400
- Planned revenue
- 20,000 currency units
- Planned contribution before fixed cost
- 12,000 currency units
- Planned profit after fixed cost
- 3,000 currency units
- Occupancy headroom
- 10%
- Break-even capacity status
- Within available capacity
The break-even occupancy is 30%.
Interpretation
Use whole break-even units and feasibility together; an exact threshold above capacity cannot be reached in the entered period.
3. Validation and boundary checks
- 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.
- Available capacity units minimum
availableCapacityUnits โฅ 1 occupied units/periodโ A lower value is rejected before calculation.- Available capacity units maximum
availableCapacityUnits โค 100,000,000 occupied units/periodโ A higher value is rejected before calculation.- Revenue per occupied unit minimum
revenuePerOccupiedUnitExTax โฅ 0 currency units/occupied unit, ex taxโ A lower value is rejected before calculation.- Revenue per occupied unit maximum
revenuePerOccupiedUnitExTax โค 10,000,000 currency units/occupied unit, ex taxโ A higher value is rejected before calculation.- Variable cost per occupied unit minimum
variableCostPerOccupiedUnitExTax โฅ 0 currency units/occupied unit, ex taxโ A lower value is rejected before calculation.- Variable cost per occupied unit maximum
variableCostPerOccupiedUnitExTax โค 10,000,000 currency units/occupied unit, 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.- Planned occupancy minimum
plannedOccupancyRate โฅ 0 proportion of available capacity occupiedโ A lower value is rejected before calculation.- Planned occupancy maximum
plannedOccupancyRate โค 1 proportion of available capacity occupiedโ A higher value is rejected before calculation.
4. Assumptions and source classification
- 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.
5. Limitations
- 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.
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 Occupancy Break-even 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