Using simulation for decision-making and risk assessment
Many engineering and management problems have a “hazard” component, for example fluctuations in interest rates, variability in the time required to complete activities, potential consumer demand, the size of a part being machined according to specifications, etc. In these situations, the typical approach is to make assumptions such as using an average and then evaluating worst case scenarios. The main shortcoming of this approach is that the results are conditional on the quality and the correctness of the assumptions.
Monte-Carlo simulation adds robustness regarding assumptions to decision-making. In addition to properly evaluating the average and worst case scenarios, this technique quantifies the impact of the variability of the assumed values, as if thousands of possible scenarios were evaluated and analyzed simultaneously. Monte-Carlo simulation is essentially based on the intensive use of random numbers from statistical distributions. This training aims to provide participants with a solid working knowledge of the Monte-Carlo simulation approach: what it consists of, what are the key concepts and what are the possible applications.
Training objectives
- Identify the situations for which the Monte-Carlo simulation would bring added value
- Properly set the problem in order to be able to use the simulation
- Know how to perform a Monte-Carlo simulation and statistically interpret the results
Target audience
- Engineers
- Planners
- Data analysts
- Managers
- Reliability experts
- Decision makers
Format
- Virtual or in-person
- 50% theory and 50% practical
- Duration: 8 hours
Content
- History, key concepts and application examples
- Step-by-step detailed general methodology
- The different methods of controlling randomness
- Typical problems in the form of workshops: calculation of areas and volumes, yield of a portfolio, financial risk analysis, parameter sensitivity analysis, tolerance estimation, risk in project schedule management
Requirements
- Install Différence’s Excel add-in
- Know the statistical basis: calculation of mean, standard deviation and confidence intervals
- Be familiar with Microsoft Excel
This training is pratical, theoretical elements are very limited. For more informations or to book your training, please contact us!