Anticipated annual losses from various security threats identified for a small company.


This project uses spreadsheet software to calculateanticipated annual losses from various security threats identified for a smallcompany. Mercer Paints is a paint manufacturing company located in Alabama thatuses a network to link its business operations. A security risk assessmentrequested by management identified a number of potential exposures. Theseexposures, their associated probabilities, and average losses are summarized ina table, which can be found in this learning module. Use the table to answerthe following questions:

Don't use plagiarized sources. Get Your Custom Essay on
Anticipated annual losses from various security threats identified for a small company.
Just from $13/Page
Order Essay

⢠In addition to the potential exposures listed, identify atleast three other potential threats to Mercer Paints, assign probabilities, andestimate a loss range.

⢠Use spreadsheet software and the risk assessment data tocalculate the expected annual loss for each exposure.

⢠Present your findings in the form of a chart. Whichcontrol points have the greatest vulnerability? What recommendations would youmake to Mercer Paints? Prepare a written report that summarizes your findingsand recommendations.

Setting securitypolicies and procedures really means developing a plan for how to deal withcomputer security. One way to approach this task is:

·Look at what you are trying to protect.

·Look at what you need to protect it from.

·Determine how likely the threats are.

·Implement measures that will protect your assetsin a cost-effective manner.

·Review the process continuously, and improvethings every time a weakness is found.

Reports should focus most on the last two steps, but the first threeare critically important to making effective decisions about security. One oldtruism in security is that the cost of protecting yourself against a threatshould be less than the cost of recovering if the threat were to strike you.Without reasonable knowledge of what you are protecting and what the likelythreats are, following this rule could be difficult.

Hands-on MIS

Improving Decision Making: Using Spreadsheet Software to Perform a Security Risk Assessment

Mercer Paints Risk Assessment


Probability of Occurrence (%)

Average Loss ($)

Malware attack



Data loss






User errors



Threats from hackers



Improper use by employees



Power failure



Hands-on MIS Security Vulnerabilities and Risk Assessment Tables

Management Decision Problem 2


Platform Number of High Medium Low Total

Computers Risk Risk Risk Vulnerabilities

Windows Server

(corporate applications) 111 37 19

Windows 8 Enterprise

(high-level administrators) 3 56 242 87

Linux (e-mail and printing services) 1 3 154 98

Sun Solaris (UNIX)

(E-commerce and Web servers) 2 12 299 78

Windows 8 Enterprise user

desktops and laptops with office19514161,237

productivity tools that can also be

linked to the corporate network

running corporate applications and



Source link

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 15% with the discount code BANANA