Question: Part 3 Resource Leveling (40 points) Using the data below (Assume normal workday = 8 hours/day & normal workweek = 40 hours/week) Activity ID Activity

Part 3 Resource Leveling (40 points)

Using the data below (Assume normal workday = 8 hours/day & normal workweek = 40 hours/week)

Activity ID

Activity

Immediate Predecessor

Duration in days

Resource

Work Hours available per Day

A

Evaluate freezers

2

Alcides

6

B

Chart temperatures

6

Joan

4

C

Review service record

2

Alcides

D

Consult with HVAC engineer

A, B, C

3

Alcides

E

Develop construction plan

D

10

Joan

F

Complete IC assignment

E

2

Alcides

G

Complete ROI analysis

E

5

Joan

H

Conduct regulatory review

E

4

Joan

I

Obtain construction approval

F, G, H

2

Alcides

c. Joan and Alcides are not fully dedicated to the project. Joan is only available for 4 hours each day, and Alcides is available for 6 hours per day. The original estimated duration (in 8-hour days) results in over-allocation of Joan and Alcides. Prepare a resource-leveled project schedule in MS Excel. How long will it take to complete the project in a resource-leveled environment?

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!