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 attack60%$75,000Data loss12%$70,000Embezzlement3%$30,000User errors95%$25,000Threats from hackers95%$90,000Improper use by employees5%$5,000Power failure15%$300,000 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: 1. Identify two additional exposures, assign probabilities of occurrences, and average losses to your additional exposures. 2. Use Excel to input the table and create a fourth column call Expected Annual Loss and calculate the expected annual loss for each exposure. 3. Sum the expected annual losses and create a pie chart for each exposure based on the exposure and expected annual loss.4. Highlight your results by filling the rows with Yellow fill for the top three exposures. 5. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!