Skip to main content
DD-RET-002 Inventory, Promotions and Product Profitability Get the data →
DD-RET-002-Q037 Hard

Category inventory-profit action matrix

Combine stockout rate, lines below reorder, margin rate and days of supply into one category score. Which category needs action first?
Expected
Category action matrix; leading row · Action matrix
Tables
FactSalesTransactions, FactInventorySnapshot, DimProduct · columns
  • FactSalesTransactions
  • FactInventorySnapshot
  • DimProduct
  • StockoutFlag
  • BelowReorderFlag
  • DaysOfSupply
  • GrossMarginSAR
  • CategoryName

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