PI Dashboard
Wks 3–10 · Leamington Spa · 850 records
PI Accuracy
98.53%
Target 99.00%
AMBER
Total Errors
67
SKUs with discrepancy
View →
Net Direction
-13
Found − Lost
View →
Units Found
509
Surplus stock
View →
Units Lost
763
Missing stock
View →
Total Counted
272,430
Units processed
Accuracy vs Target
95%96%97%98%98.53% ◆99% ▲ Target100%
Metric
Target
Actual
Status
PI Accuracy
99.00%
98.53%
FAIL
Top 10 Adjusted SKUs
Ranked by absolute qty impact
| # | SKU | Units Found (+) | Units Lost (−) | Net Units | Total Counted | Locations | Impact |
|---|---|---|---|---|---|---|---|
| 1 | ITM015638 | +1 | 414 | -413 | 2,991 | 3 |
415
|
| 2 | PP-POAPSA-0200-UK | +236 | — | +236 | 1,059 | 3 |
236
|
| 3 | 84755 | +6 | 96 | -90 | 4,885 | 4 |
102
|
| 4 | S22011 | — | 90 | -90 | 990 | 1 |
90
|
| 5 | KNBSA250 | +77 | — | +77 | 388 | 1 |
77
|
| 6 | 83491 | +30 | — | +30 | 2,717 | 3 |
30
|
| 7 | LMPRLGBX | +28 | — | +28 | 8,976 | 10 |
28
|
| 8 | 56502 | +18 | — | +18 | 546 | 1 |
18
|
| 9 | 83298 | +18 | — | +18 | 5,322 | 6 |
18
|
| 10 | PP-GOATPW-0250-UK | — | 18 | -18 | 186 | 3 |
18
|
Weekly Accuracy Trend
Units Found
Units Lost
No multi-week data available for current filter
Top 10 Problem Locations
Ranked by absolute discrepancy
| # | Location | Client | SKUs | Sys Qty | Counted Qty | Units Found (+) | Units Lost (−) | Net | Accuracy |
|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||
Client Scorecard
Ranked by accuracy · click row to filter dashboard
Client
RAG
Lines
Found
Lost
Accuracy
vs Target
Pi Schedule
Weeks 3–52 · Client → SKU mapping · Click any Week to edit
| # | Client | Product SKU | Week ✎ editable | Status | Actions |
|---|
Raw Data
Products in Location Export — Upload CSV to update
Upload Products in Location CSV
Click or drag & drop · .csv files only
| Client | Warehouse | Location | Type | Location Type | Product SKU | Product Name | Qty | Batch No | Best Before | Week | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No records found | |||||||||||||||||||
0 records
Results
Count results with accuracy metrics · 🔒 Editing locked
| Week | Client | Warehouse | Product SKU | Product Name | Location | Sys Qty ✎ | Counted Qty ✎ | Discrepancy | Accuracy % auto | Loc Acc Avg % auto | Batch | Best Before | Counted At audit | Counted By audit |
|---|
Second Counts
Verify discrepant counts with an independent second count before adjustment
| Week | Client | SKU | Location | Sys Qty | 1st Count | 1st Disc | 2nd Count | 2nd Disc | Status | Counted By | 2nd Counted By | 2nd Counted At | Action |
|---|
Out for Count
Items currently being counted
| Week | Client | Warehouse | Product SKU | Product Name | Location | Sys Qty | Batch No | Best Before | Counted Qty |
|---|
Count Data
Raw count data · 5,617 records
| Week | Client | Warehouse | Product SKU | Product Name | Location | Quantity | Serial No | Batch No | Best Before |
|---|
Upload CSV
Upload a Products in Location export to replace the Raw Data tab
Products in Location Export
Upload a .csv file · columns will be auto-detected
Expected CSV Columns
Client
Warehouse
Location
Type
LocationType
ProductSKU
ProductName
Quantity
SerialNo
BatchNo
BestBefore
Week
Column order doesn't matter — headers are matched by name. Extra columns are preserved.
📅 Week Planner 2026
ISO weeks · working days · bank holidays · PI schedule · Leamington Spa
Current ISO Week
—
—
Working Days Left (Year)
—
of 2026
Next Bank Holiday
—
—
PI Weeks Planned
—
weeks with PI scheduled
Client Adjustments
Review what clients have approved or disputed across all accounts
Pending Review
—
Awaiting client action
Approved
—
Client accepted
Disputed
—
Client queries count
Total Adjustments
—
All clients combined
| Status | Week | Client | SKU | Location | Sys Qty | Counted | Discrepancy | Accuracy | Batch | Client Comment | Reviewed At |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Click Refresh to load adjustments | |||||||||||