CMMS, EAM & Spare Parts Management worked example

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

This worked example runs the asset hierarchy completeness numbers for a tougher week than the baseline: 63% cmms data-review resource availability instead of the typical 88%. Estimate usable asset hierarchy records completed after considering records per cleanup cycle, available review cycles, and data acceptance quality.

The inputs for this scenario

  • Asset records cleansed and parented per review cycle: 85 asset records / cycle (held at the documented default)
  • Hierarchy cleanup cycles available before go-live: 42 cycles (held at the documented default)
  • CMMS data-review resource availability: 63 % (the input this scenario stresses; the baseline uses 88)
  • Asset records accepted by reliability without rework: 93 % (held at the documented default)

Working through the calculation

  • The calculation starts from the formula this tool documents: Gross asset hierarchy completeness = asset records completed per review cycle × available hierarchy cleanup cycles.
  • Usable asset hierarchy completeness works out to 2,092 units at these inputs, and this is the headline figure for the scenario.
  • Gross asset hierarchy completeness works out to 3,570 units at these inputs.
  • Asset Hierarchy Completeness loss from availability or service-factor limits works out to 1,321 units at these inputs.
  • Asset Hierarchy Completeness loss from data, accuracy, or acceptance gaps works out to 157 units at these inputs.

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 28.41% below the baseline at 2,092 units.
  • Use it during CMMS data migration, asset register rebuilds, or hierarchy standardization projects to forecast deliverable record counts and staff the review queue. A result at this level usually justifies acting on the stressed input before touching anything else, because every other figure in the table is downstream of it.

Results at a glance

  • Usable asset hierarchy completeness: 2,092 units (headline result)
  • Gross asset hierarchy completeness: 3,570 units
  • Asset Hierarchy Completeness loss from availability or service-factor limits: 1,321 units
  • Asset Hierarchy Completeness loss from data, accuracy, or acceptance gaps: 157 units

Run it with your numbers

  • To rerun this with your own numbers, open the live Asset Hierarchy Completeness calculator, set cmms data-review resource availability to your actual value, and adjust the remaining inputs to match your operation.

Last reviewed 2026-05-12.