Excel Supply Chain Analysis: Managing Simulations Using VBA

Find out how to apply simulation techniques in Excel without the need for expensive specialty software.

Introduction

• Enhance your Solver analysis by adding VBA
• What you should know

1. Defining Solver Simulations Using VBA

• 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

2. Analyzing Solver Simulation Results

• 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

Conclusion

• Next steps