analytics
Hardware Store Global Inventory Analysis
Problem
A global hardware inventory needed clearer visibility into product value, margin performance, warehouse concentration, and stock risk.
Main result
Produced executive-ready analysis across 1,112 SKU-warehouse records, 208 products, nine warehouses, and six countries, with recommendations for overstock reduction and inventory rebalancing.
Project work
- ABC/Pareto analysis of inventory-value concentration
- Margin and product-profitability analysis
- Inventory-value analysis across products and warehouses
- Stock-risk, overstock, and dead-stock views
- Warehouse and geographic risk comparisons
- Rebalancing and stock-action recommendations
Technologies
PythonPandasMatplotlibSeaborn