Introduction to Supply Chain Analytics using Microsoft Excel

Your first steps in descriptive, predictive and prescriptive analytics to solve your toughest supply chain problems

Created by: Ray Harkins, The Manufacturing Academy
Senior Manufacturing Professional, Online Educator

What Will I 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.

Target audience

• Supply chain managers
• Manufacturing professionals
• Inventory analysts
• Logistics professionals
• Production planners
• Buyers
• Purchasing managers
• Industrial engineers
• Quality engineers and managers
• Operations managers