Introduction to Supply Chain Analytics using Microsoft Excel

What you'll learn:
Fundamental tools of descriptive, predictive and descriptive analytics
How to answer the questions, "What happened?", "What will happen?", and "What should we do?"
Analytical tools for assessing demand forecasts, production outputs and product mix strategies
Introductory time series analysis tools
Baseline, Trend, Seasonality and Error
Linear programming using Excel Solver
Statistical tools in Excel like quartiles, the data analysis tool kit, Norminv, linear regression, mathematical programming, and more!
How to use the Economic Order Quantity (EOQ)
"Launch points" for further study in analytics

Requirements
Basic Microsoft Excel skills
Basic understanding of manufacturing or logistics
Basic business acumen
Some supply chain or operations experience would be helpful.

Description
Many industry analyst predict that both supply chain management and analytic will be among the most in-demand workplace skills the coming years. This class, "Introduction to Supply Chain Analytics using Microsoft Excel" will teach you many of the fundamental tools of descriptive (What happened?), predictive (What will happen?), and prescriptive (What should we do?) analytics, all within the familiar context of Excel.

In the descriptive analytics section you will learn:

Example of parametric and nonparametric statistics

Measures of central tendency and dispersion

How to use the normal distribution to describe processes

How to combine the normal random variables

How to calculate process yield

Lots of practical applications for descriptive analytics

In the predictive analytics section you will learn:

The basics of time series analysis

How to build a linear regression model in Excel

How to calculate seasonality

How to combine baseline, trend and seasonality to build forecasts

How to use Excel Data Analysis Add-in

Real life applications of time series forecasting

In the prescriptive analytics section you will learn:

The basics of mathematical programming

How to use Excel's Solver Add-in

How to build data models using objective functions and constraints

The Economic Order Quantity and how to use it to cut your Total Inventory Costs

How to integrate management policies into your linear programs

How to apply linear programming in a "classic" product mix problem

Who this course is for
Supply chain managers
Manufacturing professionals
Inventory analysts
Logistics professionals
Production planners
Buyers
Purchasing managers
Industrial engineers
Quality engineers and managers
Operations managers