Measuring Cost Risk Using Monte Carlo Simulation

[LeeAndro]

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 19 lectures (3h 19m) | Size: 1.37 GB

The objective of this course is to present how to measure the cost risks associated to a building project.

Fundamentals, Applications, VBA Codes, Excel workbook, ASTM E

Defining what is a risk in a project context

Learning the processes of risk management

Understand the various concepts associated to contingency and cost risks

Learn the various steps required to run a Monte Carlo Simulation

Learn how to develop a Monte Carlo simulation in MS Excel using VBA

Get the VBA code for practicing and customization

Bner in VBA

Bner in MS Excel

Bner in Monte Carlo Simulation

In the first part of the course will be reviewed the fundamentals on risk management. Project objectives will be presented in the context of corporate financial decision. The concept of risk will be defined, and risk management processed will be presented.

In the second part, will be presented how cost risks and usually deteed in a good number of organizations. And inconsistencies of this approach will be pointed. Then Monte Carlo analysis will be defined, and its procedure based on recognized best practices will be presented.

In the third part, as sample project summary report will be used as the basis of the Monte Carlo Analysis. Critical cost accounts will be identified, as well as their related risks. Then will followed the creation of a Monte Carlo Model and some preparations required for VBA simulation.

In the last part, mostly in the VBA interface, a sub procedure will be developed to collect the number of iterations from the user, a function defined to calculate the total cost for each iteration and another sub procedure for calculating the parameters for the entire number of iterations. Testing will be done to ensure everything works as expected.

Excel File and VBA Codes can be ed in the last lecture

This course is meant for educational purpose only. Please consult a professional if you need to apply this to an actual project.

Risk management amateur

Risk management professional

Cost Eeer

Managers

Anyone interested in cost risk analysis






DOWNLOAD
uploadgig.com

https://uploadgig.com/file/download/fee34062ade31893/_Measuring_C.part1.rar
https://uploadgig.com/file/download/Cf87abd292d07AEB/_Measuring_C.part2.rar

rapidgator.net

https://rapidgator.net/file/3366c2202acba18f49f9460f413add51/_Measuring_C.part1.rar.html
https://rapidgator.net/file/547702bf17818afd3580e481a1c6d077/_Measuring_C.part2.rar.html

nitro.download

https://nitro.download/view/82BF6EF01EF8434/_Measuring_C.part1.rar
https://nitro.download/view/89523B561BC8FF6/_Measuring_C.part2.rar