A warehouse currently has the following network (see diagram for topology):

• Internet connectivity via HFC (Hybrid Fibre-Coax)
• A "border" router (just a regular router which happens to be at the border of where the company network meets the provider's network/Internet)
• 6 Switches (1 central switch, 4 workgroup switches (ie. one per department), 1 switch for the warehouse)
• 4 Servers (1 for HR, 1 for accounts, 1 for sales, 1 for inventory)
• 8 PC's (2 for HR, 2 for accounts, 2 for sales, 2 for warehouse management)
• 4 Laptops (1 for the Managing Director, 3 for sales)
• 4 Wireless Access Points (WAP) distributed through the warehouse
• 1 Wireless Access Point in the office

Perform a risk analysis of the entire network (including both the warehouse and the enclosed office) and create a control spreadsheet.

Provide three lists / tables for the point below:

1. Identify the assets of the company and assign a "value" of the relative importance of each asset by giving it a number (higher number = more valuable, note that value here is not monetary but is an indication of the importance of the asset to the business).
2. Identify potential threats, provide a description of the threat, and assign a level of risk to each threat (indicating severity and likelihood).
3. Identify any potential control mechanisms that could be implemented and describe how the control can used against the threat(s) you have identified (e.g. use a firewall at XYZ location in the network).

Then, link them together in a control spreadsheet.

Control Spreadsheet

• List the identified assets from your risk analysis in priority order down the left column
• List the threats you identified in the risk analysis across the top of the control spreadsheet
• List the controls that appropriate to use to address each threat in the corresponding cells

You will need to provide a summary of any controls that you have identified that need to be added and include their costs.