Executive Summary
To mitigate sea freight logistical challenges and geopolitical tensions, the retailer initiated a proactive inventory expansion for North America. This project analyzes transaction data to determine the most cost-effective and low-risk restocking strategy to maintain market competitiveness.
Strategic Questions:
- Restock by Sales Volume or Profit Margin?
- Which Top 5 products minimize lead-time risk?
- What is the total landed cost of restocking?
Analysis Methodology:
- Relational Data Modeling (Star Schema)
- SQL-based Aggregation & Cleaning
- Sales Performance Visualizations
Data Architecture
/Data Model.png)
Relational model used to join product margins with regional sales performance.
Performance Analysis
/Highest Sales Products chart.png)
Feasibility
High-volume sales products show shorter manufacturing cycles and lower landed costs.
Risk Mitigation
Restocking established demand reduces the risk of "dead stock" during political volatility.
Growth
Ensuring steady revenue through high-sales items supports cash flow for future high-margin expansion.
The Verdict
Final Recommendation: Prioritize restocking high-sales products for the North American market. While high-margin items offer more profit per unit, the lower lead times and established consumer demand of high-volume products provide the most stable path through current logistical disruptions.