Projects using Microsoft Excel in Maryland CityProjects using Microsoft Excel in Maryland City
Projects
People
Cover image for Inventory Integrity: Custom 3-Ply Loss
Inventory Integrity: Custom 3-Ply Loss Prevention The Challenge: Annapolis Lighting faced significant inventory shrinkage and untraceable losses across six retail locations due to a lack of visibility into defective merchandise and vendor returns. The Solution: I designed and implemented a proprietary Defective Merchandise Tracking System. Using a 3-ply reconciliation logic (Product/Vendor/Buyer), I created a closed-loop audit trail that accounted for every unit from the moment of defect to the final vendor credit. The Impact: - 15% Reduction in Shrinkage: Reclaimed lost revenue through precise inventory tracking. - 100% Audit Visibility: Provided leadership with real-time data on vendor performance and product quality. - Scalable: Deployed across all 6 locations and the central warehouse.
0
24