LAN Media Spreadsheet

[ LAN User Requirements Document | Site LAN Wiring Plan & Physical Topology | Site LAN Logical Topology | Wiring Closet Diagrams | LAN Electronics Spreadsheet | IGRP Implementation | ACL Implementation | IPX Implementation | LAN Pros & Cons | Back to Main]

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