Skip to main content
DD-LOG-004 Fleet Network Performance and Capacity Planning Get the data →
DD-LOG-004-Q060 Very Hard

Breakdown support pool allocation

A breakdown support pool equals 50% of total breakdown maintenance cost across the network. Allocate the pool to depots in proportion to their breakdown downtime hours only; planned services earn nothing. Reconcile allocations to the pool and report each depot remaining unfunded breakdown cost.
Expected
Depot breakdown hours, breakdown cost, allocation, unfunded cost, reconciled total · Allocation waterfall
Tables
FactMaintenanceEvents, DimDepot, DimVehicle · columns
  • FactMaintenanceEvents
  • DimDepot
  • DimVehicle
  • EventType
  • DowntimeHours
  • CostSAR
  • DepotID
  • VehicleID

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.