Skip to main content

Methodology

Occupancy Break-even Planner methodology

Find the occupied-unit threshold needed to cover a venue cost base, then compare it with a planned occupancy scenario and the available capacity ceiling.

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

Contribution per occupied unit
unitContributionExTax = revenue per occupied unit โˆ’ variable cost per occupied unit

Where

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
Exact break-even occupied units
exactBreakEvenOccupiedUnits = fixed period cost / contribution per occupied unit

Where

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
Whole break-even occupied units
wholeBreakEvenOccupiedUnits = exact break-even occupied units rounded upward

Where

exactBreakEvenOccupiedUnits
Exact break-even occupied units (units)Source: Calculated output
wholeBreakEvenOccupiedUnits
Whole break-even occupied units (units)Source: Calculated output
Break-even occupancy
breakEvenOccupancyRate = exact break-even occupied units / available capacity units

Where

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
Planned occupied units
plannedOccupiedUnits = available capacity units ร— planned occupancy rate

Where

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
Planned revenue
plannedRevenueExTax = planned occupied units ร— revenue per occupied unit

Where

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
Planned contribution before fixed cost
plannedContributionBeforeFixedCostExTax = planned occupied units ร— contribution per occupied unit

Where

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
Planned profit after fixed cost
plannedProfitAfterFixedCostExTax = planned contribution before fixed cost โˆ’ fixed period cost

Where

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
Occupancy headroom
occupancyGap = planned occupancy rate โˆ’ break-even occupancy rate

Where

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
Break-even capacity status
breakEvenFeasible = break-even occupancy is no greater than available capacity

Where

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

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

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

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

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

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

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

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

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

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

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

  1. : Initial public release of the Occupancy Break-even planner and methodology.

Guides to interpret the decision and its assumptions.

Return to the planner