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

Cost gap to budget and required saving

Management wants the actual-to-standard cost variance to match the budgeted variance through cost savings alone, holding standard 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
FactProductionTransactions, FactBudgetMonthly · columns
  • FactProductionTransactions
  • FactBudgetMonthly
  • StandardCostSAR
  • ActualMaterialCostSAR
  • ActualLabourCostSAR
  • ActualOverheadCostSAR
  • BudgetStandardCostSAR
  • BudgetActualCostSAR
  • 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.