Question: please use excel, i only need help with questions 2 and 3 0 m - 4 6 The activities (for constructing municipal buildings), their immediate
0 m - 4 6 The activities (for constructing municipal buildings), their immediate predecessors, & time requirements are given in following Table: Activity Time Required (weeks) Columni Column2 Immediate Normal Column 3 Crash Column4 P Predecessors Weeks SSSS Weeks SSSS 1 1 4 5 4 4000 12 1000 2 3 4 3 3600 12 4800 3 3 4 5 4 3200 3 5000 7 & 9 18 9600 14 8400 4 5 1 4 1600 3 2000 1 2 4 13 2 1200 1 2500 7 4 5 6 14 5 3000 3 4000 8 1 2 4 7 2 1600 1 2400 9 3 4 4 15 4 4400 12 6000 10 1 1 2 2 2 1600 1 2000 11 18 20 26 20 7200 16 8400 12 2 3 & 2 1600 1 2400 13 1 1 2 6.9, 10, 11 1 1000 0.5 1800 14 0.1 0.14 0.16 13 10.14 600 0.14 600 15 0.2 0.3 0.4 14 10.3 700 0.3 700 16 1 1 2 14 1 800 0.5 1200 17 1 2 3 16 2 1600 1 2000 18 3 5 7 15, 17 5 4400 3 6000 19 0.1 0.9 0.2 16 1 1400 10.5 2200 20 0.1 0.14 0.16 19 0.14 500 10.14 500 21 2 3 6 19 3 3000 2 4000 22 0.1 0.1 0.2 20 0.1 400 0.1 400 23 0 0.2 0.2 21, 22 0.2 300 0.2 300 Requirements: 1. Determine the Total Project Completion Time, Critical Path and Slack time for all activities involved 2. What will be the probability that the project will be completed in 20 weeks & 18.5 weeks? 3. Determine the least cost of reducing the project completion date by 3.5 weeks. 0 m - 4 6 The activities (for constructing municipal buildings), their immediate predecessors, & time requirements are given in following Table: Activity Time Required (weeks) Columni Column2 Immediate Normal Column 3 Crash Column4 P Predecessors Weeks SSSS Weeks SSSS 1 1 4 5 4 4000 12 1000 2 3 4 3 3600 12 4800 3 3 4 5 4 3200 3 5000 7 & 9 18 9600 14 8400 4 5 1 4 1600 3 2000 1 2 4 13 2 1200 1 2500 7 4 5 6 14 5 3000 3 4000 8 1 2 4 7 2 1600 1 2400 9 3 4 4 15 4 4400 12 6000 10 1 1 2 2 2 1600 1 2000 11 18 20 26 20 7200 16 8400 12 2 3 & 2 1600 1 2400 13 1 1 2 6.9, 10, 11 1 1000 0.5 1800 14 0.1 0.14 0.16 13 10.14 600 0.14 600 15 0.2 0.3 0.4 14 10.3 700 0.3 700 16 1 1 2 14 1 800 0.5 1200 17 1 2 3 16 2 1600 1 2000 18 3 5 7 15, 17 5 4400 3 6000 19 0.1 0.9 0.2 16 1 1400 10.5 2200 20 0.1 0.14 0.16 19 0.14 500 10.14 500 21 2 3 6 19 3 3000 2 4000 22 0.1 0.1 0.2 20 0.1 400 0.1 400 23 0 0.2 0.2 21, 22 0.2 300 0.2 300 Requirements: 1. Determine the Total Project Completion Time, Critical Path and Slack time for all activities involved 2. What will be the probability that the project will be completed in 20 weeks & 18.5 weeks? 3. Determine the least cost of reducing the project completion date by 3.5 weeks
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
