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

Maintenance support pool allocation

A maintenance support pool equals 50% of total breakdown maintenance cost across the network. Allocate the pool to plants in proportion to their breakdown downtime minutes only; planned maintenance earns nothing. Reconcile allocations to the pool and report each plant remaining unfunded breakdown cost.
Expected
Plant breakdown minutes, breakdown cost, allocation, unfunded cost, reconciled total · Allocation waterfall
Tables
FactMaintenanceEvents, DimPlant, DimWorkCentre · columns
  • FactMaintenanceEvents
  • DimPlant
  • DimWorkCentre
  • EventType
  • DowntimeMinutes
  • CostSAR
  • PlantID
  • WorkCentreID

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.