Fill in the table above by subnetting 192.168.1.0 so that all subnets created have the necessary IP’s to accomodate 15 devices on the network which includes the router gateway interface. Choose the most efficient subnet mask and fill in the subnet ID’s (Network IP), Host Range IP’s, Broadcast IP and Subnet Mask.

The Excel Form to do this assignment is embedded in the Upload file below.