1. Case Study: Forecasting Supply Chain Disruptions in Manufacturing

What this typically involves

• Understanding disruption drivers (supplier delays, demand surges, etc.)

• Time series data analysis (identify patterns/trends)

• Building forecasting models (e.g., moving average, exponential smoothing)

• Interpreting outputs for decision making

Planned deliverables

• Summary of problem statement, data description

• Visual time series plots

• Model selection and justification

• Forecast results and accuracy metrics (MAPE/MAE)

• Recommendations for supply chain planners

✈️ 2. Case Study: Price Elasticity Modeling for Airline Ticket Pricing

Core tasks

• Review pricing vs. sales quantity data

• Compute price elasticity of demand

• Segment analysis by route/class/date

• Suggest pricing strategies based on elasticity outcomes

Planned deliverables

• Definition and formula for elasticity

• Regression or elasticity estimates

• Interpretation tables

• Strategic insights for airline pricing teams

📊 3. Hands‑on Exercises (Excel)

The exercises are focused on practical forecasts and visualizations in Excel:

A. Time Series Plotting in Excel

• Clean imported data

• Generate line charts with appropriate labels

• Highlight trends and seasonality

B. Forecasting E‑commerce Revenue

• Apply historical revenue data to forecast future revenue

• Use built‑in Excel Forecast Sheet or functions (e.g., FORECAST.ETS)

C. Simple Exponential Smoothing

• Use Excel Data Analysis ToolPak

• Configure smoothing factor and produce forecast

D. Forecasting Demand Planning

• Combine historical demand with planning forecast

• Compare multiple forecast outputs

Each exercise will include:

• Step‑by‑step Excel instructions

• Screenshots or sample formulas (if requested)

• Interpretation of results

📅 Suggested Workflow Step Task Output 1 Review each Google Doc & data sheet Understanding scope/data 2 Clean and pre‑process datasets Excel/Google Sheet ready 3 Visualize data Time series charts 4 Build forecasting models Forecast tables & charts 5 Analyze results Summary insights 6 Write interpretations Final report sections