8- 10 This project uses spreadsheet software to calculate anticipated annual losses from various security threats identified for a small company.

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 a table, which can be found in MyLab MIS. Use the table to answer the following questions:

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

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

• Present your findings in the form of a chart. Which control points have the greatest vulnerability? What recommendations would you make to Mercer Paints?

Prepare a written report that summarizes your findings and recommendations.