project wbs

b67
ExampleElementalEstimate13.xlsx

Elemental Estimate

Elemental Estimate
NOTES: 1) No overtime or weekends Unit Intensity Duration Effort:Total Staff Hrs Unit Cost Extension
2) Workday equals 8 hours (Days) (=Intensity * Duration *8) ($/Staff Hr) $$
0 60 Wall Street – Free of JPMC’s Employees and Technology
W'1 New Technology Infrastructure Operating Environment (Delivered to JPMC’s
Technology Teams) (Consolidated 8th and 9th Floor Data Centers)
W'1.1 Infrastructure Server Installation Plan
R1.1.1 Systems Analyst Staff Hour 3 10 240 50 12,000
R1.1.2 Data Base Administrator Staff Hour 4 12 384 40 15,360
R2.3 NT Support Specialist Staff Hour 6 10 480 55 26,400
W'1.2 Circuit Cutover Plan
R2.2 Network Operator Staff Hour 2 12 192 30 5,760
R2.4 Network Carrier Support Specialist Staff Hour 5 8 320 100 32,000
R3.1.1 Foreman (Electrician) Staff Hour 1 5 40 85 3,400
W'1.3 Market Data Test Plan
R1.3.2 Market Data Specialist Staff Hour 3 18 432 60 25,920
R1.3.3 Trader Voice Support Representative Staff Hour 2 14 224 40 8,960
R4.3 Disconnect/Reconnect Personnel Staff Hour 2 5 80 20 1,600
W'1.4 Operational Test Plan
R2.1 Infrastructure Support Representative Staff Hour 1 20 160 35 5,600
R2.2 Network Operator Staff Hour 4 10 320 30 9,600
R2.5 Production Operator Staff Hour 1 10 80 25 2,000
W'1.5 Floor Plan
R2.5 Production Operator Staff Hour 1 8 64 25 1,600
R3.5 Physical Planning Representative Staff Hour 1 8 64 35 2,240
R3.6 Architect Staff Hour 1 15 120 100 12,000
W'1.6 Power and Cooling Requirements Document
R3.2 Physical Planning Representative Staff Hour 1 12 96 35 3,360
R6.1.1 HVAC Engineer Staff Hour 2 8 128 85 10,880
R6.2.1 Power Distribution Engineer Staff Hour 1 8 64 85 5,440
Unit Intensity Duration Total Unit Extension
(Days) (Staff Hrs) Cost $$ $$
W'2 12th Floor Data Center (Empty) (Delivered to Deutsche Bank)
W'2.1 12th Floor Data Center (Facilities Equipment Removed)
W'2.1.1 Communications Cabinet Removal Plan
R3.2 Physical Planning Representative Staff Hour 2 22 352 35 12,320
R2.1 Infrastructure Support Representative Staff Hour 1 20 160 35 5,600
R2.5 Production Operator Staff Hour 2 15 240 25 6,000
W'2.1.2 HVAC Shutdown Plan
R6.1.1 HVAC Engineer Staff Hour 1 10 80 85 6,800
R3.7 Facilities Designer Staff Hour 1 10 80 40 3,200
R6.1.2 HVAC Apprentice Staff Hour 1 6 48 35 1,680
W'2.1.3 PDU Shutdown Plan
R6.2.1 Power Distribution Engineer Staff Hour 1 10 80 85 6,800
R3.7 Facilities Designer Staff Hour 1 10 80 40 3,200
R6.2.2 Power Distribution Apprentice Staff Hour 1 5 40 35 1,400
W'2.1.4 Cable Removal Plan
R3.2 Physical Planning Representative Staff Hour 1 12 96 35 3,360
R3.4 Cable Plant Technician Staff Hour 3 10 240 20 4,800
R3.1.2 Journeyman (Electrician) Staff Hour 1 5 40 37 1,480
W'2.1.5 Furniture Removal Plan
R3.7 Facilities Designer Staff Hour 1 8 64 40 2,560
R4.1.1 Mover Supervisor Staff Hour 1 6 48 35 1,680
R4.1.2 Movers Staff Hour 2 4 64 20 1,280
W'2.1.6 Raised Floor Retrofit Plan
R3.2 Physical Planning Representative Staff Hour 1 6 48 35 1,680
R3.1.2 Journeyman (Electrician) Staff Hour 1 5 40 37 1,480
R3.1.3 Apprentice (Electrician) Staff Hour 1 3 24 25 600
Unit Intensity Duration Total Unit Extension
(Days) (Staff Hrs) Cost $$ $$
W'2.2 12th Floor Data Center (Technology Infrastructure Removed)
W'2.2.1 Infrastructure Server Removal Plan
R1.1.1 Systems Analyst Staff Hour 3 25 600 50 30,000
R1.1.2 Data Base Administrator Staff Hour 5 25 1000 40 40,000
R5.2.1 Senior Technology Auditor Staff Hour 1 15 120 85 10,200
W'2.2.2 Market Data (TIBCO) Relocation Plan
R1.3.2 Market Data Specialist Staff Hour 2 12 192 60 11,520
R1.3.3 Trader Voice Support Representative Staff Hour 2 10 160 40 6,400
R7.2 Business Technology Infrastructure Mgr Staff Hour 5 10 400 90 36,000
W'2.2.3 PBX Removal Plan
R3.8 ATT Staff Hour 2 8 128 100 12,800
R7.2 Business Technology Infrastructure Mgr Staff Hour 5 8 320 90 28,800
R3.2 Physical Planning Representative Staff Hour 1 5 40 35 1,400
W'2.2.4 Carrier Removal/Relocation Plan
R2.4 Network Carrier Support Specialist Staff Hour 5 10 400 100 40,000
R2.2 Network Operator Staff Hour 2 12 192 30 5,760
R3.1.1 Foreman (Electrician) Staff Hour 1 8 64 85 5,440
W'2.2.5 Network Equipment Removal Plan
R2.2 Network Operator Staff Hour 2 6 96 30 2,880
R2.5 Production Operator Staff Hour 2 8 128 25 3,200
R3.7 Facilities Designer Staff Hour 1 4 32 40 1,280
W'2.2.6 Circuit Removal Plan
R2.2 Network Operator Staff Hour 2 5 80 30 2,400
R1.3.2 Market Data Specialist Staff Hour 2 8 128 60 7,680
R2.4 Network Carrier Support Specialist Staff Hour 5 6 240 100 24,000
W'2.2.7 Final Verification Plan
R3.7 Facilities Designer Staff Hour 1 5 40 40 1,600
R2.5 Production Operator Staff Hour 1 8 64 25 1,600
R3.2 Physical Planning Representative Staff Hour 1 3 24 35 840
Unit Intensity Duration Total Unit Extension
(Days) (Staff Hrs) Cost $$ $$
W'3 Low Rise, Tenant Floors 1 – 18 (Delivered to Deutsche Bank)
(Typical For All Tenant Floors, 1 - 47)
W'3.1 Floor Free Of Tenants
W'3.1.1 Tenant Migration Plan
R7.2 Business Technology Infrastructure Mgr Staff Hour 5 10 400 90 36,000
R7.3 Real Estate Project Coordinator Staff Hour 2 15 240 40 9,600
R7.1 Technology Corrdinator Staff Hour 5 18 720 35 25,200
W'3.1.2 Tenant Contingency Plan
R5.3 Contingency Administrator Staff Hour 1 15 120 70 8,400
R7.2 Business Technology Infrastructure Mgr Staff Hour 5 12 480 90 43,200
R1.2.1 Application Developer Staff Hour 5 20 800 60 48,000
W'3.1.3 New Location Test Plan
R7.2 Business Technology Infrastructure Mgr Staff Hour 5 25 1000 90 90,000
R1.3.1 Productivity Tools Support Representative Staff Hour 6 10 480 25 12,000
R1.2.2 Business Users Staff Hour 20 2 320 90 28,800
W'3.1.4 Personal Belongings Relocation Plan
R3.7 Facilities Designer Staff Hour 1 5 40 40 1,600
R7.1 Technology Corrdinator Staff Hour 5 2 80 35 2,800
R4.1.1 Mover Supervisor Staff Hour 1 1 8 35 280
W'3.1.5 Floor “Lock Down” Schedule
R3.7 Facilities Designer Staff Hour 1 2 16 40 640
R7.2 Business Technology Infrastructure Mgr Staff Hour 5 1 40 90 3,600
R4.4 Physical Security Officer Staff Hour 1 4 32 35 1,120
Unit Intensity Duration Total Unit Extension
(Days) (Staff Hrs) Cost $$ $$
W'3.2 Floor “Broom Clean”
W'3.2.1 Cable Cross Connect Removal Plan
R3.4 Cable Plant Technician Staff Hour 3 3 72 20 1,440
R7.1 Technology Corrdinator Staff Hour 3 2 48 35 1,680
R7.3 Real Estate Project Coordinator Staff Hour 1 3 24 40 960
W'3.2.2 Riser Cable Removal Plan
R3.4 Cable Plant Technician Staff Hour 2 5 80 20 1,600
R3.7 Facilities Designer Staff Hour 1 3 24 40 960
R3.1.1 Foreman (Electrician) Staff Hour 1 2 16 85 1,360
W'3.2.3 Furniture Removal Plan
R3.7 Facilities Designer Staff Hour 2 6 96 40 3,840
R4.1.1 Mover Supervisor Staff Hour 1 4 32 35 1,120
R4.1.2 Movers Staff Hour 1 2 16 20 320
W'3.2.4 Debris Removal Schedule
R3.7 Facilities Designer Staff Hour 1 1 8 40 320
R3.1.1 Foreman (Electrician) Staff Hour 1 1 8 85 680
R7.3 Real Estate Project Coordinator Staff Hour 1 1 8 40 320
W'3.3 Floor Free Of Technology
W'3.3.1 Logical Network Shutdown Plan
R7.3 Real Estate Project Coordinator Staff Hour 2 4 64 40 2,560
R7.1 Technology Corrdinator Staff Hour 2 3 48 35 1,680
R2.2 Network Operator Staff Hour 2 5 80 30 2,400
W'3.3.2 Network Equipment Removal Plan
R2.2 Network Operator Staff Hour 1 2 16 30 480
R3.1.1 Foreman (Electrician) Staff Hour 1 1 8 85 680
R7.3 Real Estate Project Coordinator Staff Hour 1 3 24 40 960
W'3.3.3 Market Data Equipment Removal Plan
R1.3.2 Market Data Specialist Staff Hour 2 5 80 60 4,800
R1.3.3 Trader Voice Support Representative Staff Hour 2 4 64 40 2,560
R7.3 Real Estate Project Coordinator Staff Hour 1 6 48 40 1,920
W'3.3.4 Workstation Equipment Removal Plan
R4.3 Disconnect/Reconnect Personnel Staff Hour 1 4 32 20 640
R4.1.1 Mover Supervisor Staff Hour 1 2 16 35 560
R3.2 Hardware Support Personnel Staff Hour 2 4 64 30 1,920
Unit Intensity Duration Total Unit Extension
(Days) (Staff Hrs) Cost $$ $$
W'3.3.5 Copier and FAX Machine Removal Plan
R3.7 Facilities Designer Staff Hour 1 3 24 40 960
R7.1 Technology Corrdinator Staff Hour 1 2 16 35 560
R4.1.1 Mover Supervisor Staff Hour 1 3 24 35 840
W'3.3.6 Telephone Removal Plan
R3.8 ATT Staff Hour 1 3 24 100 2,400
R7.1 Technology Corrdinator Staff Hour 1 4 32 35 1,120
R4.1.1 Mover Supervisor Staff Hour 1 2 16 35 560
W'3.3.7 Direct Circuit Removal Plan
R2.4 Network Carrier Support Specialist Staff Hour 5 2 80 100 8,000
R2.2 ATT Staff Hour 1 1 8 100 800
R1.3.2 Market Data Specialist Staff Hour 1 4 32 60 1,920
TOTAL $888,000