LAN Media Spreadsheet

In the following table represents the footage of each room location, the footage of the drop and how many drops are installed in each room. Each room had labeled have four drops, they are Room 1 (1-a, 1-b, 1-c, 1-d) etc. Every room have included * is a 24 students workstation room, use drops room number with -c and room number -d to connect them to the port and the switch. The cable runs from the switch to the students workstation will labeled at R4S01 to R4S24. Which mean: Room 4 with Switch 01 workstation. Teacher’s workstation with labeled at room number with -a, and other devices (e.g. printers) labeled at room number with -b.

Cat5 e UTP running though the MDF in Building A

Room Number	Drops	Cable run in Feet	Vertical run in Feet	Total Distance run in Feet	Total running Feet
1	4	90	10	100	400
2	4	90	10	100	400
3	4	90	10	100	400
4	4	90	10	100	400
5	-	45	10	55	220
6	-	45	10	55	220
7	4	90	10	100	400
8	4	90	10	100	400
9	-	75	10	85	340
10	4	90	10	100	400
11	4	90	10	100	400
12	4	90	10	100	400
13	4	90	10	100	400
14	-	65	10	75	300
15	-	65	10	75	300
16	4	90	10	100	400
17	4	135	10	145	580
18	-	45	10	55	220
19	-	45	10	55	220
20	4	140	10	150	600
21	4	90	10	100	400
22	4	90	10	100	400
23	-	45	10	55	220
24	-	40	10	50	200
25	-	90	10	100	400
26	-	125	10	135	540
27	-	110	10	120	480
28	-	130	10	140	560
29	-	40	10	50	200
30	4	90	10	100	400
31	4	90	10	100	400
32	-	45	10	55	220
33	-	45	10	55	220
34	4	90	10	100	400
35	4	90	10	100	400
36	4	90	10	100	400
37	4	90	10	100	400
38	-	45	10	55	220
39	-	45	10	55	220
40	4	90	10	100	400
41	4	90	10	100	400
42	-	30	10	40	160
43	-	30	10	40	160
44	4	90	10	100	400
45	4	90	10	100	400
46	-	40	10	50	200
47	-	40	10	50	200
48	4	90	10	100	400
49	4	90	10	100	400
50	4	80	10	90	360
51	4	90	10	100	400
52	4	90	10	100	400
53	-	40	10	50	200
54	-	40	10	50	200
55	4	90	10	100	400
56	4	90	10	100	400
57	4	160	10	170	760
58	4	85	10	95	380
59	-	120	10	130	520
60	-	50	10	60	240
61	4	50	10	60	240
62	-	50	10	60	240
Total Distance in Feet					21660

Cat 5e UTP running though the IDF in Building B (Administration office)

Room Number	Drops	Cable run in Feet	Vertical run in Feet	Total Distance run in Feet	Total run in Feet
1	4	40	10	50	200
2	-	50	10	60	240
3	4	40	10	50	200
4	-	40	10	50	200
5	-	40	10	50	200
6	8	65	10	75	300
7	8	65	10	75	300
8	4	80	10	90	360
9	4	70	10	80	320
10	4	90	10	100	400
11	4	55	10	65	260
Total Run in Feet					2980

Cat 5 e UTP running though the IDF in Building C (Multipurpose/Canteen)

Room Number	Drops	Cable run in Feet	Vertical run in Feet	Total Distance run in Feet	Total run in Feet
1	4	100	10	110	440
2	-	30	10	40	160
3	-	100	10	110	440
4	4	160	10	170	680
5	-	70	10	80	320
Total Run in Feet					2040

Total Cat 5e UTP for the Entire School Network in Feet is 26680

The project require 27 rolls of Cat5 e UTP at the cost $175 per 1000’ roll, the total cost is $4725

Fiber Media

Source	Destination	Distance in Feet
MDF	IDF in Building B	270
MDF	IDF in Building C	260
Total Distance in Feet		530

530 feet of 62.5 / 125 Micron Multimedia Fiber at $0.50 per foot for a total cost of $265

Cat 5e Connectors and Accessories

Item	Quantity	Unit Price	Total Price
24" Wall Cabinet	50	$379	$18950
Cat 5e snap-in jack	198	$3.70	$732.6
10' modular patch cord	78	$7.90	$616.2
4 port surface plates	50	$0.75	$37.5
Surface mount box	50	$4.00	$200
Cat5 duplex surface mount	160	$5.5	$880
RJ 45 Plug	550	$0.20	$110
8’ Decorative molding	250	$5.00	$1250
Total Cost			$22776.3

The total cost for this project is $27766.3