MGMT 9060 MIS - Case Study #2 (Mercer Paints) Mercer paints is a paint manufacturing company located in Alabama that uses a network to link its business operations. A security risk assessment that management - The Complete Academic Support Hub

MGMT 9060 MIS – Case Study #2 (Mercer Paints)

Mercer paints is a paint manufacturing company located in Alabama 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 provided below. Use the table to answer the associate questions.

In addition to potential exposures listed, identify at least three other potential threats to Mercer Paints, assign probabilities, and estimate a loss range.

Hands-on Case Questions

1. Use a spreadsheet software and the risk assessment data to calculate the expected annual loss for each exposure.

2. Present your findings in the form of a chart.

3. Which control points have the greatest vulnerability?

4. Which recommendations would you make to Mercer Paints?

5. Prepare a written report that summarizes your findings?

Mercer Paints Risk Assessment

Exposure	Probability of Occurrence (%)	Average Loss ($)
Malware attack	60%	$75,000
Data loss	12%	$70,000
Embezzlement	3%	$30,000
User errors	95%	$25,000
Threats from hackers	95%	$90,000
Improper use by employees	5%	$5,000
Power failure	15%	$300,000

MGMT 9060 MIS – Case Study #2 (Mercer Paints)

Grading Rubric

Critical Elements	Exemplary (3)	Good (2)	Fair (1)	Poor (0)
Use a spreadsheet software and the risk assessment data to calculate the expected.	Question fully answered and student demonstrated original thought, high-level of understanding of material including facts and or examples that backup-up statements.	Question fully answered and student demonstrated some original thought, good understanding of material including some facts and or examples that backupup statements.	Question not answered fully and student demonstrated limited original thought, an adequate understanding of material with limited facts and or examples that backup-up statements.	Student did not answer this question.
Present your findings in the form of a chart?	Question fully answered and student demonstrated original thought, high-level of understanding of material including facts and or examples that backup-up statements.	Question fully answered and student demonstrated some original thought, good understanding of material including some facts and or examples that backupup statements.	Question not answered fully and student demonstrated limited original thought, an adequate understanding of material with limited facts and or examples that backup-up statements.	Student did not answer this question.
Which control points have the greatest vulnerability?	Question fully answered and student demonstrated original thought, high-level of understanding of material including facts and or examples that backup-up statements.	Question fully answered and student demonstrated some original thought, good understanding of material including some facts and or examples that backupup statements.	Question not answered fully and student demonstrated limited original thought, an adequate understanding of material with limited facts and or examples that backup-up statements.	Student did not answer this question.
Which recommendations would you make to Mercer Paints?	Question fully answered and student demonstrated original thought, high-level of understanding of material including facts and or examples that backup-up statements.	Question fully answered and student demonstrated some original thought, good understanding of material including some facts and or examples that backupup statements.	Question not answered fully and student demonstrated limited original thought, an adequate understanding of material with limited facts and or examples that backup-up statements.	Student did not answer this question.
Prepare a written report that summarizes your findings?	Question fully answered and student demonstrated original thought, high-level of understanding of material including facts and or examples that backup-up statements.	Question fully answered and student demonstrated some original thought, good understanding of material including some facts and or examples that backupup statements.	Question not answered fully and student demonstrated limited original thought, an adequate understanding of material with limited facts and or examples that backup-up statements.	Student did not answer this question.