Supply Chain & Inventory Optimization
Forecast a retailer’s demand and set reorder levels that cut stock-outs and dead stock.
About this internship
Data Collection & Cleaning
- Logistics Data Extraction: Pulling historical Enterprise Resource Planning (ERP) or Point of Sale (POS) data, focusing on stock levels, supplier lead times, procurement costs, order volumes, and transportation bottlenecks.
- Data Wrangling: Using tools like Python (
pandas) or Excel to clean messy data, handling missing values, anomalies (e.g., sudden order cancellations), and tracking down inconsistencies in SKU (Stock Keeping Unit) naming conventions.
Quantitative Inventory Modeling
- ABC/XYZ Analysis: Classifying inventory items by revenue impact (ABC) and demand predictability (XYZ) to help businesses prioritize storage space and capital for high-value, highly volatile products.
- Safety Stock & Reorder Point (ROP) Calculation: Programming formulas to determine exactly when to reorder stock and how much buffer inventory to keep based on supplier lead-time variance and demand fluctuations.
- Economic Order Quantity (EOQ) Modeling: Calculating the optimal order size that minimizes total inventory holding costs and ordering costs.
Demand Forecasting & Simulation
- Time-Series Forecasting: Applying baseline statistical and machine learning models (like Moving Averages, Exponential Smoothing, or ARIMA) to predict future consumer demand based on seasonal trends and historical sales.
- Stockout Simulation: Running Monte Carlo simulations or stress tests to model potential supply chain disruptions (e.g., transport delays, supplier failures) and evaluate how long existing inventory will last.
Network & Workflow Optimization
- Lead-Time Analysis: Mapping the lifecycle of a product from the supplier’s warehouse to the end customer to identify operational bottlenecks and delivery delays.
- Warehouse Space Allocation: Designing data-driven layouts or slotting strategies to place fast-moving goods closer to packing stations, reducing picking time.
Dashboarding & Strategic Reporting
- KPI Dashboard Engineering: Constructing interactive operational dashboards using Tableau, Power BI, or Streamlit to track live logistics metrics such as Inventory Turnover Ratio, Fill Rate, and Carrying Cost of Inventory.
- Cost-Benefit Recommendations: Writing a concise final report summarizing the trade-offs between holding excess inventory (high storage costs) versus running lean (risk of losing customers to stockouts).