sd a7

profileankitar
ITProjectScheduletemplate.xlsx

Example

Project Schedule - xxxx
WBS Task # Task Action Duration Predecessor Resource Comment:
1.0 IT Area leave duration blank - subordinate tasks identify actual duration leave predecessor blank - no predecessor leave resource blank - put in subordinate tasks
1.1.1 1 Purchase 4 network servers 5 days none PC Specialist
1.1.2 2 purchase 1 desktop PC 5 days none PC Specialist
1.1.3 3 Purchase 2 laptops 5 days none PC Specialist
1.1.4 4 Purchase 2 VOIP Phones 5 days none PC Specialist
1.2 5 Loading and testing network software at corporate IT for servers, desktop, laptops and VOIP phones 60 min 1,2,3,4 PC Specialist
1.3 6 Deployment of equipment to new location 60 min 5 PC Specialist
1.5 7 Installation of network servers 150 min 6 Network Specialist.
1.6 8 Installing the cabbling for network. 120 min 6 PC Specialist, Network Specialist
1.7 9 Testing of network servers 60 min 7 PC Specialist, Network Specialist
1.8.1 10 Installation and testing of VOIP Phones 45 min 7 Network Specialist
1.8.2 11 Installation and testing laptops 45 min 7 PC Specialist, Network Specialist
1.8.3 12 Installation and testing of desktop 30 min 7 PC Specialist, Network Specialist
1.9 13 Testing the IT infrastruture in the area 25 min 10,11,12 PC Specialist, Network Specialist
1.xx IT Area Completed 0 This is a milestone with zero minutes
2.0 Administrative Area IT Area is the predecessor.
2.1.1 1 Purchase of 4 VOIP Phones 5 days none PC Specialist Network servers connected and operation before testing for connectivity
2.1.2 2 Purchase of 4 desktops PC 5 days none PC Specialist
2.1.3 3 Purchase of 1 copier 5 days none PC Specialist
2.2 4 Loading and testing corporate software in desktop and VOIP phones at corporate IT 90 min 1,2,3 PC Specialist
2.3 5 Deployment of equipment to new location 60 min 4 PC Specialist
2.4 6 Network cabling 120 min 5 PC Specialist, Network Specialist
2.5 7 Installation/confirmation of wireless access 60 min 5 PC Specialist, Network Specialist
2.6.1 8 Installation and Testing of Desktops 90 min 6 PC Specialist
2.6.2 9 Installation and testing of VOIP phones 90 min 6 Network Specialist
2.6.3 10 Installation and testing copier 45 min 6 PC Specialist, Network Specialist
2.7 11 Testing of wireless system 30 min 8,9,10 PC Specialist, Network Specialist
2.xx Administrative Area Completed This is a milestone with zero minutes
3.0 Conference Room Administrative areas is the predecessor .
3.1.1 1 Purchase of the projector 5 days none PC Specialist Network servers connected and operation before testing for connectivity
3.1.2 2 Purchase of 2 VOIP phone 5 days none PC Specialist Some tasks run concurrently with IT and Administrative areas
3.2 3 Loading and testing corporate software in VOIP phones at corporate IT 60 min 1,2 PC Specialist
3.3 4 Deployment of equipment to new location 60 min 3 PC Specialist
3.4 5 Cabbling to enable network access 90 min 4 PC Specialist, Network Specialist
3.5 6 Installation/confirmation of wireless access 45 min 4 Router, PC Specialist, Network Specialist
3.6.1 7 Installation of projector 90 min 4 A/V Specialist
3.6.2 8 Installation and testing of VOIP phone 75 min 5 Network Specialist
3.7 9 Testing projector for wireless and cabbling access by desktop and laptop 30 min 5,6 PC Specialist, A/V Specialist
3.8 10 Testing the wireless system 30 min 7,8,9 PC Specialist, Network Specialist
Conference Room Complete This is a milestone with zero minutes
4.0 Meeting Room The predecessor of this task is the Administrative area
4.1.1 1 Purchase of 2 VOIP phones 5 days none PC Specialist Network servers connected and operation before testing for connectivity
4.1.2 2 Purchase of desktop 5 days none PC Specialist This one runs concurrently with conference room.
4.1.3 3 Purchase a projector 5 days none PC Specialist
4.2 4 Loading and testing corporate software in desktop and VOIP phones at corporate IT 75 min 1,2 PC Specialist
4.3 5 Deployment of equipment to new location 60 min 4 PC Specialist
4.4 6 Cabbling to enable network access 90 min 5 PC Specialist, Network Specialist
4.5 7 Installation/confirmation of wireless access 45 min 5 PC Specialist, Network Specialist
4.6.1 8 Installation and testing of desktop 30 min 6 PC Specialist, Network Specialist
4.6.2 9 Installation and testing of VOIP phones 75 min 7 Network Specialist
4.6.3 10 Installation of the projector 75 min 7 A/V Specialist
4.7 11 Testing projector for wireless access 30 min 10 PC Specialist, A/V Specialist
Meeting Room Completed
5.0 Computer Labs Both the conferene and meeting rooms are predecessors
5.1.1 1 Purchase of 2 projectors 5 days none PC Specialist Some tasks may run concurrently with confence and meeting rooms
5.1.2 2 Purchase of 2 VOIP Phones 5 days none PC Specialist Network servers connected and operation before testing for connectivity
5.1.3 3 Purchase of 2 copiers 5 days none PC Specialist
5.1.4 4 Purchase of 52 desktop PC 5 days none PC Specialist
5.2 5 Loading and testing corporate software in desktop and VOIP phones at corporate IT 300 min 2,4 PC Specialist
5.3 6 Deployment of equipment to new location 60 min 5 PC Specialist
5.4 7 Installation/confirmation of wireless access 60 min 6 PC Specialist, Network Specialist
5.5 8 Cabbling for network 240 min 6 PC Specialist, Network Specialist
5.6.1 9 Installation and testing all desktops for network 360 min 8 PC Specialist, Network Specialist
5.6.2 10 Installation of projectors 150 min 8 A/V Specialist
5.6.3 11 Installation and testing VOIP 120 min 7,8 Network Specialist
5.6.4 12 Installation and testing of copier 60 min 7,8 PC Specialist, Network Specialist
5.7 13 Cabling connection of desktop PCs to projector 45 min 8,9,10 PC Specialist, A/V Specialist
5.8 14 Testing the computer system in the labs 60 min 13 PC Specialist, Network Specialist 4
Computer Labs Completed This is a milestone with zero minutes
6.0 Individual Offices
6.1.1 1 Purchase of 40 desktops 5 days none PC Specialist Last activity
6.1.2 2 Purchase of 40 VOIP phones 5 days none PC Specialist Network servers connected and operation before testing for connectivity
6.2 3 Loading and testing corporate software in desktops 240 min 1 PC Specialist
6.3 4 Deployment of equipment to new location 60 min 3 PC Specialist
6.4 5 Installation/confirmation of wireless access 60 min
6.5 6 Cabbling for networking in the offices 480 min 4 PC Specialist, Network Specialist
6.6.1 7 Installation and testing of desktop 360 min 5 PC Specialist, Network Specialist
6.6.2 8 Installation and testing of VOIP 300 min 6 Network Specialist
Individual Offices Completed This is a milestone with zero minutes