Rolling Up Maintenance Cost Across a Whole Fleet by Category and Site

Why Finance Keeps Asking for a Number You Don't Quite Have

The budget memo arrives in August. Finance wants projected maintenance spend for the coming year — broken down by equipment category, ideally by site. You open the spreadsheet you built in January. There's a tab for the press brakes, a tab for the conveyors, a separate file someone emailed in from the second facility. The numbers don't add up cleanly, the labor rates in the two files are different, and there's no single cell that says "total fleet maintenance cost."

That gap — between what you can see per asset and what finance actually needs — is the fleet maintenance cost rollup problem. The math itself is not complicated. What's hard is doing it consistently across every asset, every category, and every site, in a way that holds together when someone asks you to change an assumption.

By the end of this guide you'll know exactly how to structure a fleet-level rollup: the per-asset inputs, the category-level aggregation, the site-level merge, and the one benchmark that tells you whether the total makes sense before you submit it.

---

Start at the Asset Level: The Building Block Is Per-Asset Annual Cost

A fleet rollup is only as reliable as the per-asset estimates underneath it. For each asset, the annual maintenance cost estimate has two components:

Annual labor cost = (PM labor hours per event) × (number of PM events per year) × (fully-loaded labor rate per hour)

Annual parts and materials cost = sum of consumables, filters, belts, lubricants, and planned-repair parts consumed per year across all PM events

Per-asset annual maintenance cost = annual labor cost + annual parts and materials cost

Per-asset annual cost = (hours/event × events/year × labor rate) + annual parts cost

For a concrete illustration: a CNC machining center requires 2 labor hours per PM event, with four events per year, at a fully-loaded rate of $28/hour (close to the BLS OEWS May 2023 median of $27.57/hour for Machinery Maintenance Workers, SOC 49-9043 — your actual rate will vary by geography, shift, and benefits loading; use your own figure). Parts — way filters, coolant, way oil, spindle-oil top-off — run approximately $320 per year.

Annual labor: 2 hours × 4 events × $28/hour = $224 Annual parts: $320 Per-asset annual cost: $544

That number for a single CNC is not a budget submission. It's an ingredient. The rollup is what turns twenty ingredients into an answer.

For a deeper walk through the per-asset formula and how to set PM event frequency from OEM intervals, see our per-asset maintenance cost formula guide.

---

Structure the Fleet Into Categories First

Before you can sum anything, you need a consistent category taxonomy — a shared vocabulary that works for every asset in the fleet and maps to how finance organizes capital expenditures. Common categories for SMB manufacturers:

• CNC Machining — machining centers, lathes, turning centers
• Fabrication — press brakes, laser cutters, punch presses, welders
• Conveying & Material Handling — conveyors, hoists, overhead cranes, forklifts
• HVAC & Utilities — air handlers, compressors, chillers, boilers
• Electrical & Controls — switchgear, panels, drives, PLCs
• Facility Infrastructure — roofing, dock equipment, lighting systems

The specific categories matter less than the consistency. Every asset gets exactly one category. The category label goes on every asset row in your register. When you sum, you sum within that label — and the category subtotals roll up to the fleet total.

This is also where the pre-CMMS gap tends to appear. A spreadsheet with separate tabs per asset or per building has no shared taxonomy; summing across tabs requires manual formulas that break when a tab is renamed or a row is inserted. A persistent, multi-asset calculation engine holds the taxonomy at the register level, so every asset's category tag is available for aggregation without reformatting.

---

The Rollup Arithmetic: Category Level, Then Fleet Level

Once every asset has an estimated annual cost and a category tag, the rollup is straightforward addition.

Step 1: Sum within each category

Category	Assets	Sum of Annual Cost
CNC Machining	12	$18,240
Fabrication	8	$11,600
Conveying & Material Handling	14	$9,800
HVAC & Utilities	6	$12,400
Fleet total	40	$52,040

(Illustrative inputs — your asset count, hours/event, events/year, labor rate, and parts spend will differ.)

Step 2: Confirm the fleet total makes sense against MC/RAV

The Society for Maintenance and Reliability Professionals (SMRP) endorses a metric called Maintenance Cost as a Percentage of Replacement Asset Value, or MC/RAV:

MC/RAV = (annual maintenance cost × 100) ÷ replacement asset value

World-class facilities run at roughly 2%–3% of RAV; a typical target range is 3%–4%; above 5% is a warning signal (Tractian, 2026). (Note: these thresholds are general benchmarks — your industry, asset age, and duty cycle all affect what's reasonable for your fleet.)

For the illustrative fleet above: if the replacement asset value of those 40 assets is $1,750,000, the MC/RAV is ($52,040 × 100) ÷ $1,750,000 = 2.97% — squarely in the world-class-to-target band.

If your calculated MC/RAV lands above 5%, that's a signal to review inputs before submission: check whether labor rates are fully loaded, whether PM event frequencies match OEM guidance, and whether any reactive repair history is inflating the parts estimate. For a full guide on interpreting this benchmark, see maintenance cost as a percentage of asset value.

---

Adding the Site Dimension

If your operation runs more than one facility, finance will want the category breakdown presented by site — not just fleet-wide. The structure is the same; you add a second grouping dimension.

Step 1: Tag every asset with a site ID in addition to its category

Step 2: Sum by site × category

Site	Category	Assets	Annual Cost
Site A — Detroit	CNC Machining	7	$10,640
Site A — Detroit	Fabrication	5	$7,250
Site A — Detroit	HVAC & Utilities	4	$8,100
Site A total		16	$25,990
Site B — Grand Rapids	CNC Machining	5	$7,600
Site B — Grand Rapids	Conveying & Material Handling	14	$9,800
Site B — Grand Rapids	HVAC & Utilities	2	$4,300
Fabrication	3	$4,350
Site B total		24	$26,050
Fleet total		40	$52,040

(Illustrative inputs throughout.)

In a spreadsheet, this requires either a pivot table or careful SUMIFS logic — and it regenerates from scratch whenever a labor rate assumption changes at one site. In a purpose-built multi-asset cost engine, a rate change at Site B propagates automatically to the Site B subtotal and the fleet total without anyone rebuilding a pivot.

For a closer look at the mechanics of running cost rollups across multiple facilities, see multi-site maintenance cost rollup.

---

Common Rollup Errors That Distort the Budget Answer

1. Mixed labor rate assumptions across sites. If Site A uses a $23/hour rate from last year and Site B uses a $28/hour rate from a recent quote, the fleet total is internally inconsistent. Standardize rates at the start — or deliberately use site-specific rates and document the difference.

2. Parts costs estimated from last year's invoices without adjusting for frequency changes. If you've extended a PM interval since last year, parts consumption changes proportionally. The rollup should reflect the current interval, not the legacy spend.

3. Reactive repair cost buried in the parts line. If last year's parts invoices include emergency repairs — a blown seal replaced on a Saturday, an unplanned motor rewind — those costs are reactive, not preventive. Including them in a PM cost estimate overstates planned spend. Pull reactive costs out or flag them separately; they belong in a different budget line. This distinction also matters for benchmarking: operations without a structured PM approach tend to run 40%–55% reactive maintenance as a share of total maintenance activity, while operations with software-supported PM programs average closer to 15%–20% reactive (MapTrack, 2026). The difference in cost is real — reactive work typically costs materially more per task than the same work planned in advance.

4. Missing assets. A rollup that covers 38 of 40 tracked assets and silently omits two gives finance a number they'll catch when the missing assets break. Every asset in the register should appear in the rollup, even if its estimated cost is zero (e.g., an asset with no scheduled PM — which itself is worth flagging).

5. No version control. If the budget workbook has been emailed between three people and saved as "Fleet Costs FINAL v3 USE THIS ONE.xlsx," there is no reliable way to know which assumptions are current. Either maintain a single shared source or export a dated PDF snapshot when you submit.

---

Turning the Rollup Into a Budget Submission

Finance typically wants three things: a total by category, a total by site, and a prior-year comparison. If you have those three views reconciling to the same fleet total, you have a submittable budget.

The category view answers: "Where is the money going — machining, conveying, utilities?" The site view answers: "Which facility costs more to maintain, and why?" The prior-year comparison answers: "Is this number reasonable, and what changed?"

For a complete walkthrough of structuring the annual budget narrative — including how to document assumptions and present variance from prior year — see the annual maintenance budget guide. And once the budget is submitted and the year is underway, the next challenge is tracking actual spend against the plan; see budget variance tracking for maintenance for how to structure that.

---

Building the Rollup: Spreadsheet vs. a Persistent Engine

A well-structured spreadsheet can handle this rollup for a fleet of ten to fifteen assets. Past that threshold — and especially with multiple sites — the maintenance burden of the spreadsheet itself becomes a real cost: manually updating category tags, rebuilding pivot tables after structural changes, reconciling two files from two sites with different labor rate assumptions.

A persistent, multi-asset calculation engine holds every asset's inputs in a single register, applies your labor rate and parts assumptions consistently, and produces the category and site rollups automatically as the register changes. When an interval changes, the annual cost estimate updates. When a new asset is added, it appears in the rollup immediately.

If you're ready to build the rollup in a structured format today — before committing to a full subscription — our Maintenance Cost Budget Workbook is a one-time Excel download with pre-built per-asset input sheets, category and site summary tabs, and an MC/RAV calculator. It's designed for the step between "scattered spreadsheet tabs" and "persistent SaaS tool."

If you're tracking more than fifteen assets, or running two or more sites, the 14-day free trial of the Maintenance Cost and Interval Planner lets you import your asset register and see the category and site rollup populate in real time — no per-seat pricing, one flat rate for the organization.

Either way, the goal is the same: one number per category, one number per site, both reconciling to a fleet total you can defend when finance asks how you got there.