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

Promotion return on discount

For each promotion type, compute incremental gross margin per SAR of discount (margin on promoted lines divided by discount granted). Which type gives the best return?
Expected
Promotion type table; leading row · Ranked bar chart
Tables
FactSalesTransactions, DimPromotion · columns
  • FactSalesTransactions
  • DimPromotion
  • GrossMarginSAR
  • DiscountSAR
  • PromotionID
  • PromotionType

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