Methodology
Project 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
contributionPerProjectExTax = average project revenue โ average project variable costWhere
- averageProjectRevenueExTax
- Average project revenue (currency units/project, ex tax)Source: Business record
- averageProjectVariableCostExTax
- Average project variable cost (currency units/project, ex tax)Source: Business record
- contributionPerProjectExTax
- Contribution per project (currency units/project, ex tax)Source: Calculated output
breakEvenProjects = ceiling(fixed period cost รท contribution per project)Where
- fixedCostPerPeriodExTax
- Fixed cost per period (currency units/planning period, ex tax)Source: Business record
- contributionPerProjectExTax
- Contribution per project (currency units/project, ex tax)Source: Calculated output
- breakEvenProjects
- Break-even projects (whole projects/period)Source: Calculated output
targetProfitProjects = ceiling((fixed period cost + target profit) รท contribution per project)Where
- fixedCostPerPeriodExTax
- Fixed cost per period (currency units/planning period, ex tax)Source: Business record
- targetProfitExTax
- Target period profit (currency units/planning period, ex tax)Source: Business record
- contributionPerProjectExTax
- Contribution per project (currency units/project, ex tax)Source: Calculated output
- targetProfitProjects
- Projects for target profit (whole projects/period)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 rows below come directly from the exact engine using the visible default fixture.
- Fixed cost per period
- 10,000 currency units/planning period, ex tax
- Average project revenue
- 5,000 currency units/project, ex tax
- Average project variable cost
- 3,000 currency units/project, ex tax
- Target period profit
- 4,000 currency units/planning period, ex tax
Calculation and outputs
Contribution per project
contributionPerProjectExTax = average project revenue โ average project variable cost- Fixed cost per period
- 10,000 currency units/planning period, ex tax
- Average project revenue
- 5,000 currency units/project, ex tax
- Average project variable cost
- 3,000 currency units/project, ex tax
Engine result: 2,000 currency units/project, ex tax
Break-even projects
breakEvenProjects = ceiling(fixed period cost รท contribution per project)- Fixed cost per period
- 10,000 currency units/planning period, ex tax
- Average project revenue
- 5,000 currency units/project, ex tax
- Average project variable cost
- 3,000 currency units/project, ex tax
- Target period profit
- 4,000 currency units/planning period, ex tax
- Contribution per project
- 2,000 currency units/project, ex tax
Engine result: 5 whole projects/period
Projects for target profit
targetProfitProjects = ceiling((fixed period cost + target profit) รท contribution per project)- Fixed cost per period
- 10,000 currency units/planning period, ex tax
- Average project revenue
- 5,000 currency units/project, ex tax
- Average project variable cost
- 3,000 currency units/project, ex tax
- Target period profit
- 4,000 currency units/planning period, ex tax
- Contribution per project
- 2,000 currency units/project, ex tax
Engine result: 7 whole projects/period
Example
The rows below come directly from the exact engine using the visible default fixture.
- Contribution per project
- 2,000.00
- Break-even projects
- 5
- Projects for target profit
- 7
The exact engine-derived outputs are shown in the labelled rows below.
Interpretation
The whole-project thresholds are period volume requirements, not forecasts of demand, completion or collection.
3. Validation and boundary checks
- All values must be finite and remain inside the visible input boundaries.
- All money values use one consistent ex-tax basis and period.
- Rates must remain inside their engine-owned boundaries.
- Project thresholds are available only when average project contribution is positive.
- Fixed cost per period minimum
fixedCostPerPeriodExTax โฅ 0 currency units/planning period, ex taxโ A lower value is rejected before calculation.- Fixed cost per period maximum
fixedCostPerPeriodExTax โค 10,000,000 currency units/planning period, ex taxโ A higher value is rejected before calculation.- Average project revenue minimum
averageProjectRevenueExTax โฅ 0 currency units/project, ex taxโ A lower value is rejected before calculation.- Average project revenue maximum
averageProjectRevenueExTax โค 10,000,000 currency units/project, ex taxโ A higher value is rejected before calculation.- Average project variable cost minimum
averageProjectVariableCostExTax โฅ 0 currency units/project, ex taxโ A lower value is rejected before calculation.- Average project variable cost maximum
averageProjectVariableCostExTax โค 10,000,000 currency units/project, ex taxโ A higher value is rejected before calculation.- Target period profit minimum
targetProfitExTax โฅ 0 currency units/planning period, ex taxโ A lower value is rejected before calculation.- Target period profit maximum
targetProfitExTax โค 10,000,000 currency units/planning period, ex taxโ A higher value is rejected before calculation.
4. Assumptions and source classification
- All hours, utilisation, costs, rates and recovery targets are supplied by the user.
- Money values use one consistent ex-tax basis.
- No provider fee, jurisdiction, benchmark or demand forecast is embedded.
- Raw engine precision is retained until display.
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 the completeness and classification of the entered business records.
- The planner does not forecast demand, utilisation, supplier terms or project outcomes.
- This is educational business decision support rather than 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 Project Break-even planner and methodology.
Related reading
Guides to interpret the decision and its assumptions.
- Job Costing: Estimate, Track and Review Margin
Compare estimated and actual labour, materials, subcontractors and overhead, then choose the next pricing or delivery action.
Read guide