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)

Open the Excel spreadsheet OR solve the problemOpen the Excel spreadsheet OR solve the problem

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!