OSCM Excel Exercises
Hands-on exercises covering forecasting (SMA, WMA, exponential smoothing), forecast error, and Sales & Operations Planning strategies.
Lean Six Sigma Excel Demo
Tesla Gigafactory battery QC scenario with Cost of Quality, DMAIC tracker, SPC control charts, process capability, and Pareto analysis.
Fraud Detection — Training Data
5,000 transaction records (Jan–Jun 2025) with 3% fraud rate. Includes data dictionary. Use for building classification models.
ML Model Deployment — Scoring Template
Excel-based logistic regression and decision tree scorer with step-by-step guide and ROI calculator. No code required.
OSCM Part 2 — Practice Problems & Solutions
Comprehensive problem set with solutions for forecasting, SOP strategies, inventory models (EOQ, safety stock, price break), and MRP.
BrewLine Operations Data
Multi-sheet dataset for a coffee roaster: order fulfilment, supplier deliveries, staffing, and customer satisfaction data.
GreatLakes Delivery Data
Vehicle routing scenario with delivery orders, fleet details, and a distance matrix for logistics optimisation exercises.
Warehouse Shuffle — Student Version
Interactive warehouse layout challenge: minimise transportation costs by arranging departments. Includes cost calculator.
Warehouse Shuffle — Solution
Instructor answer key for the Warehouse Shuffle challenge with optimal layout and all layout comparisons.
Stent Failure Dataset
Large medical device dataset for classification analysis. Contains patient demographics, stent specifications, and failure outcomes.
Excel Forecasting Examples
Worked examples of time-series forecasting, trend analysis, causal relationships, and trend-seasonality models with regression output.
Fraud Detection — Test Data
1,500 hold-out transactions (Jul–Sep 2025) for validating fraud detection models. Pair with the training set.
Customer Segmentation — Training Data
4,000 customer records for clustering and segmentation exercises. Includes data dictionary with demographics and behaviour fields.
Customer Segmentation — Test Data
1,200 hold-out customer records for validating segmentation models. Pair with the training set.
Loan Application Dataset — Student Version
Training and test data for loan approval classification. Includes credit scores, income, debt, and application outcomes.
Loan Application Dataset — Full (with Answer Key)
Complete loan dataset including instructor answer key. Use for teaching binary classification and model evaluation.
BrewRight Customer Data
200-record loyalty card dataset for a coffee company. Includes customer demographics, visit frequency, and spend data.
AI Triage Center Scoring Sheet
Team-based scoring sheet for an AI triage routing exercise. Includes scorecard and answer key.
ML Model Deployment — Logistics
Deploy decision tree and regression models in Excel for late delivery prediction, delivery days, and shipping cost estimation.