The Complete Operations Management Course - In Excel

In the normal capacity model, account for cycle-time losses from size changes, material changes, downtime, and assignment, compute real capacity, and assess demand against 95% capacity.

Learn textile capacity by computing a weighted average speed from fabric weight (gsm) and product mix to derive average time per shirt and cycle time.

Learn the mixing problem, a linear optimization in gasoline blends using additives a, b, and c. Define variables, constraints, and a profit objective, then maximize profit with simplex lp.

Compare deterministic and stochastic models to understand uncertainty, and learn how statistics and probability provide tools to quantify confidence, plan for extremes, and diagnose complex systems.

Explore probability and statistics, from descriptive to inferential, using sampling, margin of error, and tests like linear regression, t-tests, and ANOVA in operations modeling.

Explore the normal distribution and central limit theorem, examining symmetry, bell curve shape, mean, median, and mode equality, and using the data analysis tool pack to analyze skewness.

Explore the uniform and exponential distributions, highlighting equal probability and short vs long-tailed behavior, and apply them to operations modeling, including wait times, downtime, and simulations.

Explore a nine-tab statistics reference card that lets you adjust mu and standard deviation and compare distributions such as gamma and exponential.

Learn to formulate null and alternative hypotheses and decide to reject or fail to reject using data, illustrated by heart rate differences between horror and family movies and normal distribution.

Examine how to perform one-way and two-way ANOVA in Excel to compare multiple groups, assess whether differences exist, and interpret interaction effects.

Explore the simple regression test to determine if two continuous variables have a linear relationship. Interpret the regression output, r-squared, and p-values, and distinguish it from correlation and causality.

Explore a hands-on capability analysis in Excel, using length and width data to compare production against specification limits, compute yield, defects per million, and CPK.

Learn how process control charts relate to capability analyses, using real-time data, upper and lower control limits, and detection of special versus common cause variation to improve quality.

Learn to apply process control charting to binary pass/fail data by tracking proportions within subgroups, building p-charts, and adjusting control limits using Poisson-based reasoning.

Explore a Monte Carlo simulation in Excel by modeling a manufacturing process with 10,000 trials, using normal and gamma processes, and interpreting results to plan staffing.

Use Monte Carlo simulations to optimize movie theater concessions inventory, forecasting weekday and weekend demand, cup sizes, and kernels, and assess costs with a projected histogram.

Explore simulating with historic data in Excel, replacing distributions with real records. Use randbetween and vlookup to sample production, machines down, and downtime from historical data.