Reliability & Downtime

Criticality-Weighted Maintenance Budget Allocator

Criticality-Weighted Maintenance Budget Allocator takes a score per asset on four dimensions you define, the weight you give each dimension, the total budget to allocate, and current spend per asset and returns each asset's criticality index, its share of the fleet, the budget that share implies, and the gap against what you spend today. Criticality Index = the sum of each score × its weight, with the four weights required to total 100% and a check that says so when they do not. Share = the asset's index ÷ the fleet's total index. Allocated budget = your total budget × that share. Gap = allocated − current spend, in dollars and percent. Nothing is pre-filled with an outside figure — no criticality standard, no scoring rubric presented as correct, no weighting convention, no spend norm. Every value on every sheet is one you entered or one computed from what you entered, against the As-of date you set on 1. Setup, never today's date.