Rate and mix decomposition of delivery cost variance
Decompose the change in delivery cost variance per shipment between the latest two years into within-route rate and route-mix effects. Retain routes with shipments in both years. Use prior-year shares for the rate effect and latest-year rates for the mix effect; reconcile both effects to the overall rate change.
- Expected
- Route rates and shipment shares for both years, rate effect, mix effect, reconciliation · Forecast comparison
- Tables
-
FactFleetTransactions, DimRoute, DimDate · columns
- Topics
- Forecasting & Planning