Home
/
Operations & Supply Chain Analytics
/
Mission 24
caseSQL
Operations & Supply Chain Analytics · Mission 24 of 30
Expert
Forecast accuracy decomposition (bias + precision per SKU)
Unlock with Pro
→
Back to Operations & Supply Chain Analytics
The Brief
You'll practice
Signed vs ABS error
AVG decomposition
← Previous
Mission 23
Next →
Mission 25
All 30 missions in Operations & Supply Chain Analytics
↓
1.
How many suppliers do we work with?
2.
Show me the warehouses
3.
How many SKUs do we stock?
4.
List our SKU categories
5.
Show the 5 most recent purchase orders
6.
Total units ordered per category last quarter
7.
On-time delivery rate per supplier
8.
Top 5 SKUs by purchase value
9.
Stock-out risk: SKUs with under 7 days of supply
10.
Late shipments this quarter
11.
Average lead time per supplier
12.
Latest inventory on hand per warehouse
13.
Forecast accuracy by SKU last week
14.
Lead-time consistency per supplier
15.
Overstocked SKUs (over 15 days of supply)
16.
Top 3 SKUs per category by purchase value
17.
Supplier scorecard (lead time + on-time + cancellation)
18.
Demand week-over-week change
19.
Stockout root cause: SKUs with no incoming PO
20.
Inventory turnover ratio (last week)
21.
Point-in-time supplier on-time target (SCD2 reconstruction)
22.
Lead-time trend per supplier (monthly average)
23.
ABC analysis: classify SKUs by spend share
24.
Forecast accuracy decomposition (bias + precision per SKU)
25.
Reorder-point breach: SKUs below their ROP
26.
Supplier health capstone (multi-CTE scorecard)
27.
Multi-warehouse rebalancing plan
28.
Demand stability per SKU (coefficient of variation)
29.
Supplier concentration risk per category (Herfindahl index)
30.
Operations KPI capstone (board scoreboard)