Physical counts vs. system actuals with variance analysis
| Location (Parish) | Category | Physical Qty | System Qty | Variance | % Variance | Value Diff | Last Audit |
|---|---|---|---|---|---|---|---|
Kingston Central Warehouse Kingston | Food | 12,450 | 12,500 | -50 | -0.4% | -$2,500 | 2025-01-15 14:30 |
Montego Bay Distribution St. James | Medical | 3,200 | 3,050 | +150 | +4.9% | +$15,000 | 2025-01-15 13:45 |
Spanish Town Depot St. Catherine | Power | 850 | 920 | -70 | -7.6% | -$21,000 | 2025-01-15 15:00 |
Mandeville Storage Manchester | Shelter | 1,580 | 1,600 | -20 | -1.3% | -$4,000 | 2025-01-15 12:15 |
Port Antonio Warehouse Portland | Food | 4,200 | 3,950 | +250 | +6.3% | +$12,500 | 2025-01-15 11:30 |
Visual representation of inventory discrepancies
Track shipments from arrival to disbursement with full accountability
| Shipment ID | Origin | Received | Manifest | Warehouse | Loaned | Donated | In Storage | Damaged | Balance |
|---|---|---|---|---|---|---|---|---|---|
SHP-2025-0142 MAN-KIN-0089 | Kingston Port / USAID 2025-01-10 | 5,000 | 5,000 | Kingston Central | 1,200 | 2,800 | 950 | 50 | 950 |
SHP-2025-0138 MAN-MBJ-0067 | Montego Bay Port / Red Cross 2025-01-08 | 2,500 | 2,500 | Montego Bay Distribution | 800 | 1,500 | 200 | 0 | 200 |
SHP-2025-0135 MAN-KIN-0085 | Kingston Port / UN WFP 2025-01-05 | 3,200 | 3,250 | Spanish Town Depot | 600 | 2,100 | 450 | 50 | 450 |