Skip to main content
DD-RET-004 Enterprise Retail Profitability and Inventory Optimisation Get the data →
DD-RET-004-Q048 Very Hard

Budget variance decomposition

Split the total net sales variance against budget into a volume effect (units) and a price/mix effect (net sales per unit). Which effect explains more?
Expected
Two effects · Bridge chart
Tables
FactSalesTransactions, FactBudgetMonthly · columns
  • FactSalesTransactions
  • FactBudgetMonthly
  • NetSalesSAR
  • QuantitySold
  • BudgetNetSalesSAR
  • BudgetUnits

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