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

Actual cost against budget

Reconcile actual cost against the monthly work-centre budget. Report total actual, budget and variance, and build a variance bridge by plant. Do not multiply monthly budget values by order counts.
Expected
Plant totals: actual, budget, variance; overall reconciliation · Variance matrix
Tables
FactProductionTransactions, FactBudgetMonthly, DimPlant, DimDate · columns
  • FactProductionTransactions
  • FactBudgetMonthly
  • DimPlant
  • DimDate
  • ActualMaterialCostSAR
  • ActualLabourCostSAR
  • ActualOverheadCostSAR
  • BudgetActualCostSAR
  • BudgetDateKey
  • PlantID
  • WorkCentreID
  • StartDateKey
  • 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