Find out how to apply simulation techniques in Excel without the need for expensive specialty software.
Excel Supply Chain Analysis: Managing Simulations Using VBA
Overview
Syllabus
Introduction
- Enhance your Solver analysis by adding VBA
- What you should know
- Create a reference to the Solver VBA library
- Record and run a Solver macro
- Generate random inputs
- Define a loop structure to run multiple simulations
- Create an output summary worksheet
- Write model output to the summary worksheets
- Identify successful and unsuccessful solutions
- Create a results dashboard
- Explore alternative scenarios using Solver
- Next steps
Taught by
Curt Frye
