Inventory Accuracy & Cycle Count Dashboard

PrecisionStock 3PL – Midwest Regional DC | Week Ending Nov 22, 2024

Alert Status
Zone BB-2 IRA Critical (93.4%)
Overall IRA Rate
98.6%
-0.5% vs W9
Count Completion
104%
+4% vs Plan
Variance Rate
1.4%
+0.5% vs W9
Shrink Cost (W12)
$47.8K
Over $20K Limit
First-Count Accuracy
86.2%
+1.8% vs W9
Audit Close Rate
92.4%
Within SLA

Zone Accuracy Heat Map – Current Week IRA %

Zone
W6
W7
W8
W9
W10
W11
W12
Reserve-A
99.4
99.5
99.2
99.3
99.1
98.8
98.9
Reserve-B
98.7
98.6
98.9
98.5
98.4
98.3
98.6
Pick-Face
99.1
98.8
98.9
99.0
98.7
98.5
98.8
Bulk Bay-1
98.2
98.4
98.1
97.8
97.6
97.5
97.9
Bulk Bay-2
98.3
98.5
97.2
96.8
95.1
93.4
94.2
HazMat
99.6
99.7
99.5
99.6
99.4
99.3
99.5
Quarantine
99.2
99.3
99.1
99.2
98.9
98.7
98.8
Legend: ≥99% 98-98.9% 95-97.9% <95%

Variance Root Cause Breakdown – W12

Mis-putaway spiked to 41% following RF gun firmware update (W4). Training intervention deployed W11.

Root Cause 8-Week Trend

Rolling 13-Week Adjustment Dollar Value

Red threshold = $20K. W12 total $47.8K driven by Bulk Bay-2 partial-pallet putaway errors and A-tier SKU-A0882 shrink ($4.3K).

Count Frequency Compliance by ABC Tier

A-Tier (Daily)
98%
B-Tier (Weekly)
94%
C-Tier (Monthly)
89%

Shrink Cost per SKU Velocity Tier

System vs Physical Gap

+1,240 Units W12

First-Count Accuracy

86.2% Current

Audit Close Rate

92.4% SLA Met

Location-Level Variance Roster – W12 Top Issues

Location ID Zone SKU Tier Sys Qty Phys Qty Var Qty Var % $ Impact Root Cause Status
BB2-A-08-14 Bulk Bay-2 SKU-A0882 A 420 386 -34 -8.1% -$4,340 Mis-putaway Open
BB2-C-12-05 Bulk Bay-2 SKU-B1204 B 680 621 -59 -8.7% -$2,950 Partial pallet Open
RA-D-04-22 Reserve-A SKU-A0102 A 1200 1198 -2 -0.2% -$84 Cycle damage Closed
PF-B-07-11 Pick-Face SKU-B0547 B 88 90 +2 +2.3% +$58 Receiving extra Closed
BB1-F-03-18 Bulk Bay-1 SKU-C2108 C 540 502 -38 -7.0% -$912 Mis-pick unreported Open
RB-A-09-06 Reserve-B SKU-B0881 B 315 308 -7 -2.2% -$182 Shrink Closed
BB2-B-11-09 Bulk Bay-2 SKU-A0945 A 210 183 -27 -12.9% -$1,620 Mis-putaway Open
HM-A-02-04 HazMat SKU-A0334 A 96 96 0 0.0% $0 — Perfect