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).

Courses included free