Generating Risk Adjusted Margins

This forum includes discussion about project risk analysis and risk management theory: Monte Carlo simulations, Event Chain Methodology, schedule and cost risk analysis. Please submit questions and case studies about your experience with our project risk analysis software.

Moderator: Intaver Support

Post Reply
KerryMiller
Posts: 23
Joined: Tue Dec 18, 2007 3:39 pm
Location: USA, MI

Generating Risk Adjusted Margins

Post by KerryMiller » Sat Feb 22, 2020 5:36 pm

We have been asked to calculate schedule margin activities based on p80. How do can I calculate this in RiskyProject?
Project Engineer

Intaver Support
Posts: 992
Joined: Wed Nov 09, 2005 9:55 am

Re: Generating Risk Adjusted Margins

Post by Intaver Support » Sat Feb 22, 2020 5:44 pm

1. Set the High Results the simulations to p80 in the Project Options > Calculation tab.
Image

2. Run the simulation.
3. In the Reports > Simulation Results view, hide all of the columns with the exception of the Task Name, Base Duration (Duration Base – cur schedule), and Duration High.
Image

4. From the File menu, click Export > Microsoft Excel
Image

5. You are prompted to confirm the Export with some customization if required.
6. Click OK and the data will open as an Excel spreadsheet.
7. Add a additional column to the left Margin and using the Find and Replace remove the word “days” from all the cells (otherwise calculations will not work)
Image

8. The calculated margin is the difference between the Base duration of the deterministic schedule and the High Results. Create a formula that subtracts the Base duration from the High Duration in the Margin cells “=D2-C2”

9. Copy the formula down the Margin column. You now have values for all the activities in the schedule.
Image
Intaver Support Team
Intaver Institute Inc.
Home of Project Risk Management and Project Risk Analysis software RiskyProject
www.intaver.com

Post Reply