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

Cost gap to budget and required saving

Management wants the actual-to-planned delivery cost variance to match the budgeted variance through cost savings alone, holding planned cost fixed. Reconcile the variance gap and calculate the required uniform cost-reduction percentage. Assess whether the target is feasible when reductions are capped at 8%.
Expected
Actual/budget variance, gap, required percentage, capped-savings feasibility · Scenario waterfall
Tables
FactFleetTransactions, FactBudgetMonthly · columns
  • FactFleetTransactions
  • FactBudgetMonthly
  • PlannedCostSAR
  • FuelCostSAR
  • DriverCostSAR
  • OtherCostSAR
  • BudgetPlannedCostSAR
  • BudgetDeliveryCostSAR
  • BudgetDateKey

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.