One of my previous MBA students, an exceptional student really, Mrinmoy Dutta, has created a tool that has recently been published on ProjectManagement.com. You will need a PMI membership to access it but Mrinmoy has provided a summary of the tool, reprinted below.

This tool is to assess and come up with a response strategies for Risks during various stages of project execution. The tool predicts expected monetary value (EMV) of a particular risk by assessing

  •  In which stage of the project risk is discovered
  •  Probability and Impact ratings for the risk
  • Raw cost impact calculated based on risk matrix
  • Residual probability of the risk

It also calculates how much opportunity cost can be realized, and whether some of the risks can go into change control mechanism and fetch additional revenue for the company. Of multiple tabs in the tool, only user entry is in “Risk Register” tab.

The tool is scalable and can be used for projects worth as low as $100K and as high as $20M. The tool calculates overall Risk ranking of a project based on real time changes in Risk ratings.

The Dashboard tab can be presented to executive team for reporting purpose.

The Pivot Table tab shows risk Ownership in an intuitive fashion.

The Summary tab reflects overall Risk Management history of the project and auto updates based on changes made in Risk Register tab.

The Calculation tab shows Risk acceptance ratings and can be scaled based on customer nature (Risk Averse or Risk Lover)

CSUF Entrepreneurship

We are dedicated to helping the next generation of entrepreneurs develop the skills that they need to compete locally and globally. The CSUF Entrepreneurship program does many things, including: consulting projects where students serve up fresh strategies to actual businesses, competitions for students from middle school to grad school, helping entrepreneurs go from concept to launch, frequent seminars and office hours for entrepreneurs and professionals, and much more. Interested in becoming a part of the CSUF Entrepreneurship community? Reach out to us at csufentrepreneurship@fullerton.edu for more information! CSUF Entrepreneurship depends on the support of the community, please go here to donate.

Published by CSUF Entrepreneurship

We teach, coach and lead the principled, cross-disciplinary practice of entrepreneurship. We believe that, through determined practice, leadership and team work, our students, faculty, clients, volunteers and alums can systematically recombine the new and the old to forge new ventures, create an entrepreneurial culture, and dramatically benefit our community.