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: