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 Please, do not copy and paste answers from the internet Please, answer fully for all the questions as described Answer Prepare a resource leveled project schedule in MS Excel

The Answer is in the image, click to view ...

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?

Please, do not copy and paste answers from the internet.

Please, answer fully for all the questions as described: Answer: Prepare a resource-leveled project schedule in MS Excel

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!

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...

Part 3 Resource Leveling (40 points) Using the data below (Assume normal workday = 8 hours/day & normal workweek = 40 hours/week) Work Hours Activity Immediate Duration in available ID Activity...

Part 3 Resource Leveling (40 points) Using the data below (Assume normal workday =8 hours / day \& normal workweek =40 hours/week) a. Create a project schedule in MS Excel ensuring that it reflects...

udget Estimating (100 points) This assignment consists of 2 parts: questions about budget estimation and developing a budget. Part 1 Questions (10 points) Provide responses to the following questions...

Schedule Compression and Resource Leveling (100 points) This assignment consists of 3 parts: questions about resourcing projects, schedule development and compression, and resource leveling. Part 1...

Part 3 Budget Estimating (50 points) You are the project manager for a process improvement project for Company XYZ. Prepare a figure like Exhibit 10.9 that illustrates the weekly and cumulative costs...

Part 3 Budget Estimating (50 points) You are the project manager for a process improvement project for Company XYZ. Build a figure like Exhibit 10.9 that illustrates the weekly and cumulative costs...

Part 1 Questions (10 points) Provide responses to the following questions 1. You are providing a review of contractor bids for a component of your upcoming project. What can be done to determine...

Part 2 Budget Estimating (30 points) Using the same scenario from the previous unit on scheduling, create a time-phased budget for the following project. Prepare a figure like Exhibit 10.9, CPT 4e,...

Part 1 Questions (10 points) Provide responses to the following questions 1. You are providing a review of contractor bids for a component of your upcoming project. What can be done to determine...

Why might it be argued that the development of APEC and the Trans-Pacific Partnership alongside integration efforts in the Western Hemisphere increases the likelihood that regional agreements may be...

An electric toy with a resistance of is operated by a 3.00-V battery. (a) What current does the toy draw? (b) Assuming that the battery delivers a steady current for its lifetime of 4.00 h, how much...

If a loss of $ 2 5 4 0 0 is incurred in selling ( for cash ) office equipment having a book value of $ 9 0 0 0 0 , the total amount reported in the cash flows from investing activities section of the...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...