need help with 3 parts of this assignment.

profilebalo.i
ip_add_inventory.xlsx

IP address

UMUC IP Address assignment Scheme
Subnet Devices hosts vlan id network mask subnet mask netwrok ID Start IP last ip Broadcast
1 UMUC 20 64 101 192.16.10 192.16.10 26 255.255.255.192 192.16.10.0 192.16.10.1 192.16.10.62 192.16.10.63
2 UMES 8 16 102 192.16.10 192.16.10 28 255.255.255.240 192.16.10.64 192.16.10.65 192.16.10.78 192.16.10.79
3 UMCPTowson 8 16 103 192.16.10 192.16.10 28 255.255.255.240 192.16.10.80 192.16.10.81 192.16.10.94 192.16.10.95
4 Towson 4 8 104 192.16.10 192.16.10 29 255.255.255.248 192.16.10.96 192.16.10.97 192.16.10.102 192.16.10.103
5 UB 5 16 105 192.16.10 192.16.10 28 255.255.255.240 192.16.10.104 192.16.10.105 192.16.10.118 192.16.10.119
6 UMB 15 32 106 192.16.10 192.16.10 27 255.255.255.224 192.16.10.120 192.16.10.121 192.16.10.150 192.16.10.151
7 Eastern Shore 4 8 107 192.16.10 192.16.10 29 255.255.255.248 192.16.10.152 192.16.10.153 192.16.10.158 192.16.10.159
8 UMBC 12 32 108 192.16.10 192.16.10 27 255.255.255.224 192.16.10.160 192.16.10.161 192.16.10.190 192.16.10.191
9 Bowe 5 16 109 192.16.10 192.16.10 28 255.255.255.240 192.16.10.192 192.16.10.193 192.16.10.206 192.16.10.207
10 Class Rooms 150 512 110 192.16.11 192.16.12 23 255.255.254.0 192.16.11.0 192.16.11.1 192.16.12.253 192.16.12.254
11 Shady Grove Administrations 50 128 111 192.16.13 192.16.13 25 255.255.255.128 192.16.13.0 192.16.13.1 192.16.13.126 192.16.13.127
12 Router 4 8 112 192.16.13 192.16.13 29 255.255.255.248 192.16.13.128 192.16.13.129 192.16.13.134 192.16.13.136
13 Switches 10 32 113 192.16.13 192.16.13 27 255.255.255.224 192.16.13.136 192.16.13.137 192.16.13.166 192.16.13.167
14 Patch Panel 4 8 114 192.16.13 192.16.13 29 255.255.255.248 192.16.13.168 192.16.13.169 192.16.13.174 192.16.13.175
15 Hubs 5 16 115 192.16.13 192.16.13 28 255.255.255.240 192.16.13.176 192.16.13.177 192.16.13.190 192.16.13.191
16 Printers 5 16 116 192.16.13 192.16.13 28 255.255.255.240 192.16.13.192 192.16.13.193 192.16.13.206 192.16.13.207
17 Network Printers and departments Printers 25 64 117 192.16.14 192.16.14 26 255.255.255.192 192.16.14.0 192.16.14.1 192.16.14.62 192.16.14.63
18 telephone 200 512 118 192.16.15 192.16.16 23 255.255.254.0 192.16.15.0 192.16.15.1 192.16.16.253 192.16.16.254
19 wifi network 1000 512 119 192.16.17 192.16.18 23 255.255.254.0 192.16.17.0 192.16.17.1 192.16.18.253 192.16.18.254
20 LAN servers 10 16 120 192.16.18 192.16.19 28 255.255.255.240 192.16.19.0 192.16.18.1 192.16.19.14 192.16.19.15
21 Public Servers 10 16 121 2.2.2 2.2.2 28 255.255.255.240 2.2.2.0 2.2.2.1 2.2.2.14 2.2.2.15

inventory

Subnets Devices Comment
UMUC 20 Work Stations
UMES 8 Work Stations
UMCPTowson 8 Work Stations
Towson 4 Work Stations
UB 5 Work Stations
UMB 15 Work Stations
Eastern Shore 4 Work Stations
UMBC 12 Work Stations
Bowe 5 Work Stations
Class Rooms 150 Work Stations
Shady Grove Administrations 50 Application server, Data server, and SAN
Router 4 2600 series, Slow processing power
Switches 10 switches All switches are without port security. No technology to reduce convergence time.
Patch Panel 4
Hubs 5
Printers 5 Commercial Type in Copy Centre
Network Printers and departments Printers 25
Wireless Network Controllers 2 NEEDED; Cisco 2100 Series Wireless LAN Controller; Cisco 2125
Wireless Network Controllers 2 NEEDED; Cisco 2100 Series Wireless LAN Controller; Cisco 2112
Wireless Access Points 40 NEEDED; Cisco Aironet 1250 Series

bandwidth calculation

UMUC IP Address assignment Scheme
S no Subnet planning number per device(kbps) total(kbps) total(mbps)
1 UMUC 64 512 32,768 32 Mbps
2 UMES 16 512 8,192 8 Mbps
3 UMCPTowson 16 512 8,192 8 Mbps
4 Towson 8 512 4,096 4 Mbps
5 UB 16 512 8,192 8 Mbps
6 UMB 32 512 16,384 16 Mbps
7 Eastern Shore 8 512 4,096 4 Mbps
8 UMBC 32 512 16,384 16 Mbps
9 Bowe 16 512 8,192 8 Mbps
10 Class Rooms 512 512 262,144 256 Mbps
11 Shady Grove Administrations 128 512 65,536 64 Mbps
12 Router 8 512 4,096 4 Mbps
13 Switches 32 512 16,384 16 Mbps
14 Patch Panel 8 512 4,096 4 Mbps
15 Hubs 16 512 8,192 8 Mbps
16 Printers 16 512 8,192 8 Mbps
17 Network Printers and departments Printers 64 512 32,768 32 Mbps
18 telephone 512 512 262,144 256 Mbps
19 wifi network 512 512 262,144 256 Mbps
10 LAN servers 16 512 8,192 8 Mbps
21 Public Servers 16 512 8,192 8 Mbps
TOTAL 1,048,576 1024 Mbps

WLC and AP Placement

WLC and AP Placement Table Suggested Wireless LAN Controler
Building Access Point Wireless LAN Controller WLC Cisco Part Number Quantity Cost Notes
Requirements Requirements Cisco 2100 Series Wireless LAN Controller AIR-WLC2125-K9 2 One Cisco 2125 and one Cisco 2112 placed in each building
Building3 1 x WLC2125; 1 x WLC2112 Cisco 2100 Series Wireless LAN Controller AIR-WLC2112-K9 2 Cisco 2112 will provide room for expansion and backup in the event of failure of 2125
Lobby 2
Cafeteria 10 Suggested Wireless Access Point
Conference room 10 AP Cisco Part Number Quantity Cost Notes
Building 2 1 x WLC2125; 1 x WLC2112 Cisco Aironet 1250 Series AIR-AP1252AG-x-K9: 802.11a/g/n-draft 2.0 2.4/5-GHz Modular Autonomous Access Point; 6 RP-TNC 40 One extra in the event of failure until replacement can be purchased
Lobby 2
Conference Room 15
TOTAL AP 39
TOTAL WLC 0