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

Critical supplier risk

Among the top quartile of suppliers by net sales, which has the worst OTIF? Report the supplier, its OTIF and the sales it carries.
Expected
Supplier risk table; leading row · Scatter (sales vs OTIF)
Tables
FactSalesTransactions, FactSupplierDeliveries, DimProduct, DimSupplier · columns
  • FactSalesTransactions
  • FactSupplierDeliveries
  • DimProduct
  • DimSupplier
  • NetSalesSAR
  • OnTimeFlag
  • InFullFlag
  • SupplierID

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