Inventory & Supplier Performance Dashboard
Copper Kettle Home Goods — Asheville, NC
Blended GMROI
2.61×
+0.14 vs Q3
Inventory Turnover
4.8×
+0.3 YoY
Days Inventory Out.
58
+10d from Oct spike
Supplier OTIF
87%
+9% from Jun
Dead/Slow Stock
$47K
21.3% of total inv.
Stockout Rate
3.2%
Est. $11K lost margin
GMROI vs. Inventory Turnover by Category
Bubble size = inventory value. Target zone: GMROI >2.0×, Turnover >4×
Days Inventory Outstanding (12-Month Trend)
Inventory Turnover by SKU Tier
Supplier Scorecard — OTIF by Month
Supplier
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Supplier A
95%
93%
96%
94%
97%
92%
95%
96%
94%
93%
95%
97%
Supplier B
84%
81%
83%
80%
82%
54%
78%
85%
87%
86%
88%
89%
Supplier C
91%
90%
92%
91%
93%
90%
91%
92%
94%
93%
91%
92%
Supplier D
88%
87%
86%
89%
90%
88%
87%
89%
91%
90%
89%
90%
Supplier E
96%
95%
97%
96%
98%
97%
96%
97%
98%
97%
96%
98%
Green >90%, Yellow 75-90%, Orange <75%. Supplier B June port congestion visible.
Lead Time Variability by Supplier
Fill Rate by Sales Channel
Slow-Mover & Dead Stock Value ($47.3K total)
Seasonal Décor
$18.2K
DIO: 128d
Flatware Sets
$12.7K
DIO: 97d
Kitchen Linens
$8.0K
DIO: 79d
Categories with DIO >60 days and turnover <2×. Rationalization target: $25K reduction.
SKU Rationalization Action Items
| SKU |
Category |
Tier |
GMROI |
DIO |
Inv. Value |
Action |
| SD-47219 |
Seasonal Décor |
C |
0.87× |
142d |
$6,240 |
Liquidate |
| FL-38621 |
Flatware Sets |
C |
1.14× |
105d |
$4,830 |
Markdown 30% |
| GL-29412 |
Glassware |
B |
1.68× |
78d |
$3,920 |
Reduce order qty |
| KL-51283 |
Kitchen Linens |
C |
1.21× |
91d |
$3,510 |
Markdown 25% |
| CP-62947 |
Cookware |
A |
3.82× |
28d |
$8,640 |
Maintain |
| TB-41873 |
Tableware |
A |
4.15× |
22d |
$9,120 |
Increase stock |
| SD-58392 |
Seasonal Décor |
C |
0.94× |
136d |
$5,480 |
Liquidate |
| BA-72514 |
Bakeware |
B |
2.34× |
42d |
$4,260 |
Monitor |
Stockout Rate & Lost Margin (Monthly)
Reorder Point Accuracy & PO Cost Efficiency
Reorder Point Accuracy Rate
82.4%
Target: >85% (SKUs reordered within ±7d of optimal point)
PO Cost as % of Procurement
2.8%
Industry benchmark: <2.5%. Opportunity: consolidate orders.
Avg PO Processing Cost
$47
Down from $52 in Q3 via automation