WhatsApp Widget

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

By Okoth / November 26, 2025

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.