Skip to main content

Methodology

Equipment Cost Allocation Planner methodology

Allocate equipment ownership and maintenance cost across productive hours, then assign the resulting cost and consumables to one project.
Duc Nguyen X.By Duc Nguyen X.· Founder, Margin101Last reviewed: View update historyMethodology

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

Equipment cost per productive hour
equipmentCostPerHourExTax = (ownership cost + maintenance cost) ÷ productive equipment hours

Where

ownershipCostPerPeriodExTax
Equipment ownership cost (currency units/period, ex tax)Source: Business record
maintenanceCostPerPeriodExTax
Equipment maintenance cost (currency units/period, ex tax)Source: Business record
productiveHoursPerPeriod
Productive equipment hours (hours/period)Source: Business record
equipmentCostPerHourExTax
Equipment cost per productive hour (currency units/productive hour, ex tax)Source: Calculated output
Allocated project equipment cost
allocatedProjectCostExTax = equipment cost per hour × project use hours + project consumables

Where

projectUseHours
Project equipment hours (hours/project)Source: Business record
projectConsumablesExTax
Project consumables (currency units/project, ex tax)Source: Business record
equipmentCostPerHourExTax
Equipment cost per productive hour (currency units/productive hour, ex tax)Source: Calculated output
allocatedProjectCostExTax
Allocated project equipment cost (currency units, ex tax)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.

Equipment ownership cost
12,000 currency units/period, ex tax
Equipment maintenance cost
3,000 currency units/period, ex tax
Productive equipment hours
1,000 hours/period
Project equipment hours
10 hours/project
Project consumables
100 currency units/project, ex tax

Calculation and outputs

  1. Equipment cost per productive hour

    equipmentCostPerHourExTax = (ownership cost + maintenance cost) ÷ productive equipment hours
    Equipment ownership cost
    12,000 currency units/period, ex tax
    Equipment maintenance cost
    3,000 currency units/period, ex tax
    Productive equipment hours
    1,000 hours/period
    Project equipment hours
    10 hours/project
    Allocated project equipment cost
    250 currency units, ex tax

    Engine result: 15 currency units/productive hour, ex tax

  2. Allocated project equipment cost

    allocatedProjectCostExTax = equipment cost per hour × project use hours + project consumables
    Equipment ownership cost
    12,000 currency units/period, ex tax
    Equipment maintenance cost
    3,000 currency units/period, ex tax
    Productive equipment hours
    1,000 hours/period
    Project equipment hours
    10 hours/project
    Project consumables
    100 currency units/project, ex tax
    Equipment cost per productive hour
    15 currency units/productive hour, ex tax

    Engine result: 250 currency units, ex tax

Example

The rows below come directly from the exact engine using the visible default fixture.

Equipment cost per productive hour
15.00
Allocated project equipment cost
250.00

The exact engine-derived outputs are shown in the labelled rows below.

Interpretation

Allocate equipment cost using productive use, not total calendar availability.

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.
Equipment ownership cost minimum
ownershipCostPerPeriodExTax ≥ 0 currency units/period, ex tax — A lower value is rejected before calculation.
Equipment ownership cost maximum
ownershipCostPerPeriodExTax ≤ 10,000,000 currency units/period, ex tax — A higher value is rejected before calculation.
Equipment maintenance cost minimum
maintenanceCostPerPeriodExTax ≥ 0 currency units/period, ex tax — A lower value is rejected before calculation.
Equipment maintenance cost maximum
maintenanceCostPerPeriodExTax ≤ 10,000,000 currency units/period, ex tax — A higher value is rejected before calculation.
Productive equipment hours minimum
productiveHoursPerPeriod ≥ 0.01 hours/period — A lower value is rejected before calculation.
Productive equipment hours maximum
productiveHoursPerPeriod ≤ 100,000,000 hours/period — A higher value is rejected before calculation.
Project equipment hours minimum
projectUseHours ≥ 0 hours/project — A lower value is rejected before calculation.
Project equipment hours maximum
projectUseHours ≤ 100,000,000 hours/project — A higher value is rejected before calculation.
Project consumables minimum
projectConsumablesExTax ≥ 0 currency units/project, ex tax — A lower value is rejected before calculation.
Project consumables maximum
projectConsumablesExTax ≤ 10,000,000 currency units/project, 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

  1. : Initial public release of the Equipment Cost Allocation planner and methodology.

Related reading

Guides to interpret the decision and its assumptions.

Return to the planner