~Get Your Files Here !

  Ex_Files_Excel_Supply_Chain_Analysis

   Exercise Files

    01_03_RandomInputs.xlsm

    02_01_ResultSheets.xlsm

    02_03_Fulfillment.xlsm

    02_05_Scenarios.xlsm

  [1] Introduction

   [1] Enhance your Solver analysis by adding VBA.srt

   [2] What you should know.srt

  [2] 1. Defining Solver Simulations Using VBA

   [1] Create a reference to the Solver VBA library.srt

   [2] Record and run a Solver macro.srt

   [3] Generate random inputs.srt

   [4] Define a loop structure to run multiple simulations.srt

  [3] 2. Analyzing Solver Simulation Results

   [1] Create an output summary worksheet.srt

   [2] Write model output to the summary worksheets.srt

   [3] Identify successful and unsuccessful solutions.srt

   [4] Create a results dashboard.srt

   [5] Explore alternative scenarios using Solver.srt

  [4] Conclusion

   [1] Next steps.srt