Question: Improving Decision Making: Using Spreadsheet Software to Perform a Security Risk Assessment Mercer Paints Risk Assessment ExposureProbability of Occurrence ( % ) Average Loss (
Improving Decision Making: Using Spreadsheet Software to Perform a Security Risk Assessment Mercer Paints Risk Assessment ExposureProbability of Occurrence Average Loss $Malware attack$Data loss$Embezzlement$User errors$Threats from hackers$Improper use by employees$Power failure$ Mercer paints is a paint manufacturing company located in New Jersey that uses a network to link its business operations. A security risk assessment that management requested identified a number of potential exposures. These exposures, their associated probabilities, and average losses are summarized in the table above. Use the table to answer the following questions: Identify two additional exposures, assign probabilities of occurrences, and average losses to your additional exposures. Use Excel to input the table and create a fourth column call Expected Annual Loss and calculate the expected annual loss for each exposure. Sum the expected annual losses and create a pie chart for each exposure based on the exposure and expected annual loss Highlight your results by filling the rows with Yellow fill for the top three exposures. Upload your spreadsheet to the appropriate dropbox.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
