Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Private Equity Toolkit A Step By Step Guide To Getting Deals Done From Sourcing To Exit

Authors: Tamara Sakovska

1st Edition

1119697107, 978-1119697107

More Books

Students also viewed these Finance questions

Question

Describe the five basic forms of departmentalization.

Answered: 1 week ago

Question

2. What are some ways to research specific employers? (LO 13-1)

Answered: 1 week ago

Question

Consider this article:...

Answered: 1 week ago