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

Delivery cost against budget

Reconcile actual delivery cost against the monthly route budget. Report total actual, budget and variance, and build a variance bridge by depot. Do not multiply monthly budget values by shipment counts.
Expected
Depot totals: actual, budget, variance; overall reconciliation · Variance matrix
Tables
FactFleetTransactions, FactBudgetMonthly, DimDepot, DimDate · columns
  • FactFleetTransactions
  • FactBudgetMonthly
  • DimDepot
  • DimDate
  • FuelCostSAR
  • DriverCostSAR
  • OtherCostSAR
  • BudgetDeliveryCostSAR
  • BudgetDateKey
  • DepotID
  • RouteID
  • 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.

Create a free account Sign in