Question: Open the Excel spreadsheet OR solve the problem on paper (either way, you must show your work to receive full and partial credit), then answer
Open the Excel spreadsheet OR solve the problem on paper (either way, you must show your work to receive full and partial credit), then answer the questions that follow.
You are working on the project pictured above and have 2 backhoes available.
Activities E and F require 2 backhoes, while activities A, B, C, and D require 1 backhoe. No splitting of activities is possible. Time is in weeks
Use the following order of heuristics: 1. Minimum slack, 2. Smallest duration, 3. Lowest identification number.
Note: In the schedule resource load chart the time-constrained scheduling interval (ES through LF) has been shaded. Any resource scheduled beyond the shaded area will delay the project.
Answer the following questions 1. How long will the project take if it was NOT resource-constrained? ____ weeks
2. Which activities are critical if the project was NOT resource-constrained? (list all critical activities in alphabetical order, no commas, no spaces)
3. How long will the resource-constrained project take? weeks
4. List the order in which you scheduled the activities of the resource-constrained project.
First Second Third Fourth Fifth Sixth
5. Which activities are critical in the resource-constrained schedule? (list all critical activities in alphabetical order, no commas, no spaces)


Answer the following questions 1. How long will the project take if it was NOT resource- constrained? weeks 2. Which activities are critical if the project was NOT resource- constrained? (list all critical activities in alphabetical order, no commas, no spaces) 3. How long will the resource-constrained project take? weeks 4. List the order in which you scheduled the activities of the resource-constrained project. First Second Third Fourth Fifth Sixth 5. Which activities are critical in the resource-constrained schedule? (list all critical activities in alphabetical order, no commas, no spaces) A B D E F G H 1 L M N o P Q R S T U V 1 0 2 3 3 0 1 0 0 Rules: 1 Minimum slack Smallest duration 3 Lowest ID# 4 3 3 3 D 8 0 5 0 1 3 5 8 8 0 F 10 2 o 210 8 E 3 2 5 6 2 2 3 8 Legend ES ID EF SLK RES SLK LS DUR LF 1 10 11 12 13 14 15 SLK 0 0 4 6 7 0 B 3 8 0 1 0 9 0 3 3 10 11 12 0 C 1 13 4 1 4 14 1 5 15 16 ID RES DUR ES LF 17 A 1 3 0 3 18 B 1 3 0 3 19 1 1 0 5 20 D 1 5 3 8 21 E 2 3 3 8 22 F 2 2 8 10 23 EXCAVATORS SCHEDULED 24 EXCAVATORS AVAILABLE 25 26 27 28 29 30 31 32 33 0 2 0 Answer the following questions 1. How long will the project take if it was NOT resource- constrained? weeks 2. Which activities are critical if the project was NOT resource- constrained? (list all critical activities in alphabetical order, no commas, no spaces) 3. How long will the resource-constrained project take? weeks 4. List the order in which you scheduled the activities of the resource-constrained project. First Second Third Fourth Fifth Sixth 5. Which activities are critical in the resource-constrained schedule? (list all critical activities in alphabetical order, no commas, no spaces) A B D E F G H 1 L M N o P Q R S T U V 1 0 2 3 3 0 1 0 0 Rules: 1 Minimum slack Smallest duration 3 Lowest ID# 4 3 3 3 D 8 0 5 0 1 3 5 8 8 0 F 10 2 o 210 8 E 3 2 5 6 2 2 3 8 Legend ES ID EF SLK RES SLK LS DUR LF 1 10 11 12 13 14 15 SLK 0 0 4 6 7 0 B 3 8 0 1 0 9 0 3 3 10 11 12 0 C 1 13 4 1 4 14 1 5 15 16 ID RES DUR ES LF 17 A 1 3 0 3 18 B 1 3 0 3 19 1 1 0 5 20 D 1 5 3 8 21 E 2 3 3 8 22 F 2 2 8 10 23 EXCAVATORS SCHEDULED 24 EXCAVATORS AVAILABLE 25 26 27 28 29 30 31 32 33 0 2 0