Skip to content
SheetModel
Real EstateE-commerceConstructionB2B SaaSWorkforceAbout
Construction 3 Excel tabs included 9 min read Updated Jan 2026

Equipment depreciation & hourly cost calculator

Turn a machine’s purchase price, fuel burn and maintenance into a defensible hourly rate you can charge to jobs — including the cost of idle hours.

Typical charge margin
15–25%
Fuel as % of O&O
20–30%
Idle cost per hour
O&O minus fuel
Advertisement
Advertisement

Ownership cost versus operating cost

Equipment costing splits into two families of cost, and the distinction matters because they behave differently. Ownership costs — depreciation, insurance, storage, licensing — are incurred whether the machine works or sits. Operating costs — fuel, tyres, undercarriage, repairs, operator — scale with use.

The practical consequence: ownership cost per hour rises when utilisation falls. A $148,000 excavator used 1,100 hours a year spreads its fixed costs over a lot of hours; the same machine used 400 hours a year carries the same fixed costs over a third of the work. Low utilisation is the most common reason a machine "does not make money" when it plainly should.

Ownership and operating cost per hourlive formula
Depreciation/hr = (Purchase price − Salvage value) ÷ Life hours
Ownership/hr    = (Insurance + Storage) ÷ Annual usage hours
O&O/hr          = Depreciation + Fuel + Maintenance + Ownership + Operator (burdened)
The workbook keeps every component on its own row and graphs the composition, so you can see which line is driving your rate.

Why hours-based depreciation beats calendar depreciation

Accounting depreciation is usually straight-line over years, because that is what the tax code and financial statements require. But equipment wears out in hours, not in months. A machine that runs 2,000 hours a year reaches its rebuild point four times faster than one that runs 500.

For internal costing, depreciate over hours: purchase price minus salvage, divided by expected life hours. This produces a rate that is stable across utilisation levels and gives your estimators a number they can trust without knowing how many hours the machine has run this year.

Typical life hours by asset class (planning reference, not a rule)
AssetLife hoursMajor rebuild interval
Compact excavator8,000–12,0004,000–5,000 hrs
Skid steer6,000–10,0003,000–4,000 hrs
Wheel loader12,000–16,0006,000 hrs
Crawler dozer10,000–14,0005,000 hrs undercarriage
Telehandler8,000–12,0004,000 hrs
Dump truck (class 8)350,000 milesEngine 500k miles
Advertisement

Idle hours are not free

When a machine sits, fuel stops but everything else continues. Depreciation continues because the machine is ageing toward its rebuild. Insurance, storage and licensing continue. The operator, if retained, continues to be paid and burdened. An idle hour on a $90/hour machine commonly costs $65.

This is why standby and delay hours belong in your change orders. If a subcontractor’s delay keeps your excavator on site for three extra days, the cost is not zero just because it did not dig.

  • Idle cost = O&O per hour − fuel per hour. Compute it once and use it consistently.
  • Standby rates in construction contracts typically sit between 50% and 100% of the operating rate.
  • Track utilisation monthly. Below 50% of the annual target, the asset is being cross-subsidised by other work.
  • Sell underutilised equipment rather than keeping it for occasional convenience — the carrying cost usually exceeds the rental cost of the handful of jobs that need it.

From cost to an internal charge rate

An internal charge rate is what your job costing will pay when the machine is used on a project. It should equal your O&O cost plus a margin that funds the eventual replacement of the asset. Skip the margin and you are consuming the machine without funding its successor — a pattern that shows up three years later as an inability to replace equipment.

Publish the rate annually, apply it consistently, and review actual utilisation against plan. Uniform application is what makes job costing comparable; a rate that changes per job makes every project look profitable or unprofitable for reasons unrelated to execution.

  • Internal charge rate = O&O per hour ÷ (1 − target margin %).
  • Include a replacement reserve: equipment must fund its own successor.
  • Apply the rate to every job, including your own divisions, so utilisation data stays honest.
  • Review rates when fuel moves more than 20% or when the market rental price diverges from your cost.

How to use this tool

  1. Enter the asset and its usage. Purchase price, salvage value, expected life hours and annual usage. The life hours input drives everything downstream.
  2. Add operating costs from real data. Fuel per hour from your consumption records, maintenance as a percentage of depreciation, insurance and storage from actual invoices.
  3. Compute the O&O cost per hour. Read the composition breakdown to see which component dominates. Fuel-heavy and maintenance-heavy machines need different management attention.
  4. Set the internal charge rate and allocate jobs. Download the workbook, set a target margin, then allocate hours per job to see contribution and utilisation against your annual target.

What is inside the download

A year-by-year depreciation schedule with book value and maintenance, an ownership and operating cost build per hour, and an internal charge rate sheet with job allocation and a break-even utilisation calculation.

  • Asset Depreciation Table — a separate worksheet in equipment-hourly-cost.xlsx.
  • Operating Cost Inputs — a separate worksheet in equipment-hourly-cost.xlsx.
  • Internal Job Charge Rate — a separate worksheet in equipment-hourly-cost.xlsx.

Where these defaults come from

Every pre-filled value in the calculator above is listed below with its basis. None of it is proprietary to us — we do not run primary research. Statutory figures come from the regulator, fee schedules from the vendor that charges them, ranges from published industry surveys, and conventions are labelled as rules of thumb. When you have your own numbers, replace the default: the workbook formulas do not care where an input came from.

DefaultValue usedBasisSource
Equipment useful lifeVaries widely by asset class and duty cycle. Use the manufacturer’s rebuild interval where available.8,000–12,000 hrs (typical)Rule of thumbNo authoritative source — industry convention
Maintenance as % of depreciationTracked equipment sits near the top of the range; trailers and light assets near the bottom.50–80%Rule of thumbNo authoritative source — industry convention
Construction labour burdenStatutory plus discretionary. Workers compensation class code is the largest variable in the range.28–45% of base wagesMarket surveyUS Bureau of Labor StatisticsEmployer Costs for Employee CompensationCited by name · link pending verification

Full source registry, verification status and review cadence: data sources & methodology.

Frequently asked questions

Add five components: depreciation per hour ((purchase price − salvage) ÷ life hours), fuel cost per hour, maintenance per hour, ownership per hour (insurance and storage ÷ annual usage), and the burdened operator rate. The sum is your ownership and operating cost, which is the basis for an internal charge rate.

Software that pairs with this model

These are the platforms our models are designed to work alongside, chosen because their pricing or data appears in the model itself. Some links are affiliate links — they cost you nothing, and they never influence a formula, a default value or a result.

Related models