CMMS, EAM & Spare Parts Management worked example

Asset Hierarchy Completeness at 99% cmms data-review resource availability: a worked example

What does the result look like when cmms data-review resource availability reaches 99%? The full calculation is worked below with real intermediate numbers. a maintenance or asset-management team needs to plan asset master data cleanup and know whether the hierarchy will support work orders, PMs, and spare parts linkage for a asset hierarchy cleanup

The inputs for this scenario

  • Asset records cleansed and parented per review cycle: 85 asset records / cycle (unchanged)
  • Hierarchy cleanup cycles available before go-live: 42 cycles (unchanged)
  • CMMS data-review resource availability: 99 % (raised for this scenario; the documented default is 88)
  • Asset records accepted by reliability without rework: 93 % (unchanged)

Working through the calculation

  • Applying the documented formula (Gross asset hierarchy completeness = asset records completed per review cycle × available hierarchy cleanup cycles) to the inputs above produces each figure below.
  • At this operating point the engine returns 3,287 units for usable asset hierarchy completeness, the number this scenario is built around.
  • At this operating point the engine returns 3,570 units for gross asset hierarchy completeness.
  • At this operating point the engine returns 35.7 units for asset hierarchy completeness loss from availability or service-factor limits.
  • At this operating point the engine returns 247 units for asset hierarchy completeness loss from data, accuracy, or acceptance gaps.

How this compares with the baseline

  • Against the tool's baseline example, where cmms data-review resource availability sits at 88% and the headline result is 2,922 units, this scenario comes in 12.5% above the baseline at 3,287 units.
  • A figure at this level is achievable when cmms data-review resource availability is genuinely sustained, not just peaked for a shift. It assumes a steady cleansing rate and a constant acceptance percentage; complex parent-child relationships or legacy data quality often degrade throughput as the easy records get done first.

Results at a glance

  • Usable asset hierarchy completeness: 3,287 units (headline result)
  • Gross asset hierarchy completeness: 3,570 units
  • Asset Hierarchy Completeness loss from availability or service-factor limits: 35.7 units
  • Asset Hierarchy Completeness loss from data, accuracy, or acceptance gaps: 247 units

Run it with your numbers

  • Every input above is editable in the live Asset Hierarchy Completeness calculator, which recalculates instantly and can be shared with the inputs intact.

Last reviewed 2026-05-12.