In response to the ongoing sea freight logistical challenges and political tensions in the manufacturing country, the Global Electronic Retailer is proactively seeking to expand its inventory for North American customers. This strategic initiative aims to ensure a consistent supply of products, enhancing customer satisfaction and maintaining market competitiveness.
֎ Strategic Considerations:
» Should we restock products with highest sales or highest profit margin?
» What are the top 5 products we need to order in a large quantity?
» What is the cost of ordering these products?
» When the products will arrive?
֎ Data Modeling:
/Data Model.png)
֎ Top 5 Highest Sales Products chart
/Highest Sales Products chart.png)
֎ Analysis outcome: Restocking products with highest sales in North America
» Feasibility: Restocking products with the highest sales is more feasible due to lower costs and shorter lead times.
» Risk: Restocking high-sales products carries lower risk due to established demand and manageable supply chain timelines.
» Benefits: While restocking high-margin products offers higher profitability per unit, restocking high-sales products ensures steady revenue and customer satisfaction.