This assignment is due by Sunday, 11:59 PM EST.
Supplemental Material: How to Create a Risk Heatmap in Excel – Part 2 (Links to an external site.)
Overview and Rationale
Using the risk log and documented risks, rank the risks by likelihood and impact score.
Instructions
You must complete the risk calculation sheet Download risk calculation sheetfirst then score your risks based on factors you researched about the organization.
Review news articles and other online materials regarding the organization
Update the risk calculation sheet Download risk calculation sheetwith four risk types updated for impact. The likelihood scores will remain as provided.
Using the risk log Download risk log, score your risks based on external and internal factors as well as information on the competition, which you found in news articles and materials about the organization.
Once scored, develop your risk heat map using excel. Develop a chart that takes the values of likelihood on the “X” axes and “Y” for values of Impact. Do NOT use 1 to 10 as your values are not 1 to 10. You must reflect what is in the risk calculation sheet.
Plot your scores in relation to the total risk score in a risk heat map.
Once plotted, document the high, medium and low thresholds. These ranges will then be carried over to the heat map in terms of red = high, medium = yellow and low = green.