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

Working-capital view: inventory versus sales

Relate the latest inventory value to the final three months of net sales. What is inventory as a share of quarterly sales, and which category is most over-stocked by that measure?
Expected
Ratio and leading category · Ratio table
Tables
FactSalesTransactions, FactInventorySnapshot, DimProduct, DimDate · columns
  • FactSalesTransactions
  • FactInventorySnapshot
  • DimProduct
  • DimDate
  • InventoryCostSAR
  • NetSalesSAR
  • SnapshotDateKey
  • 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