Skip to main content
DD-LOG-004 Fleet Network Performance and Capacity Planning Get the data →
DD-LOG-004-Q038 Hard Time series

Vehicle-hour utilisation by depot

Compare driver hours booked with available vehicle hours by depot and month. Identify the highest utilisation, calculate unused hours, and explain why availability is a planning ceiling rather than hours worked. Resolve ties by earliest month then lowest DepotID.
Expected
Depot-month hours, available hours, utilisation, unused hours · Variance matrix
Tables
FactFleetTransactions, FactCapacityDaily, DimDepot, DimDate · columns
  • FactFleetTransactions
  • FactCapacityDaily
  • DimDepot
  • DimDate
  • ActualHours
  • DepotID
  • AvailableVehicleHours
  • CapacityDateKey
  • DispatchDateKey
  • YearMonth

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.