Supply Chain Shipping & Management Analysis

The analysis focuses on optimizing distribution paths from factory to customers, shipping cost reduction, factory performance monitoring, and customer segmentation for efficient supply chain management.

Download Full Report (PDF) View Full Report on Google Docs

Overview This project analyzes The Sugar Wagon’s supply chain — a national distributor of sweets and chocolates operating through 5 factories and 5000+ customers across the U.S. and Canada.

Business Problems Optimize factory-to-customer allocation to minimize delivery time & cost. Track factory performance and demand-supply metrics. Identify top-selling products by region to align production. Segment customers into active, inactive, high-value, and distant hubs. Develop strategies for satellite warehouses in key cities.

Key Insights Secret Factory has the most optimized distribution (avg. distance 486 km, 41.7% within 400 km). Wicked Choccy’s is the most profitable (NYC & Philadelphia driving high revenue). Lot’s O’ Nuts has 17.4% of customers >1600 km away → satellite warehouse recommended in San Francisco. The Other Factory struggled in 2022 but rebounded in Dallas with +182% growth in Wonka Bar sales. Customer Segmentation (RFM + distance) highlights high-value, distant customers around Seattle requiring premium fast delivery.

Strategies Set up satellite warehouses in San Francisco, Washington, and New York. Launch targeted seasonal campaigns (Q4 festive demand peaks). Use loyalty rewards & hyperlocal marketing to re-engage churned cities like San Diego. Offer express delivery to high-value distant customers for customer retention.