Construction project management

Week 5: Construction Scheduling

Construction Management

Assignment 5

Suggested format: Times New Roman 12 points, single spaced, 1” margin all around, APA style

for references

Note: All assignments will be checked for plagiarism using SafeAssign. The similarity index

should not be greater than 35% on the report. You should always provide references at the end.

LEARNING OBJECTIVE:

After successfully completing this assignment, students will be able to:

• Create a cash-loaded bar chart and cash flow histogram

• Create a banana curve with cumulative daily cash flows

• Assign and level resources for a construction project using MS Project

Week 5: Construction Scheduling

Q1. Using the precedence diagram below and associated data in the attached table, create

the following. You must calculate the daily values in the table first. 40 points

1. A daily cash-loaded bar chart and cash flow histogram based on the project’s early

dates.

2. A banana curve of cumulative daily cash flows showing both the early and late start dates

Week 5: Construction Scheduling

MS Project schedule activity

The following table shows a set of activities from a Construction Project, the duration of

the activities and logic sequence of the tasks have been defined together with the resources

required to complete these tasks. 60 points

Use Microsoft Project to schedule this project, create and assign Resources. This project has

a limitation of resources with the maximum amount limited as follows: (Engineer = 8

hours/week; Laborers = 20 hours/week; Crane = 5 hours/week; Consultant = 2 hours/week).

Choose start date 12/1/20.

Follow the following Homework Hints

1) Add a summary activity at the beginning to name your project.

2) To enter duration in weeks, go to: File_Options_Schedule_Duration is entered in: Weeks

3) All activities must be set as Fixed Duration in Task type.

4) When creating resources, the maximum allowed units for each resource have to be changed

as a percentage per total week hours (e.g. Laborer: 20 maximum hours per week = 20/40 =

50%). If the result is a decimal enter it as is, even if Project rounds it up.

5) When assigning resources, either on the split screen or using the assign resources button, to

activities in the field “Units”, again the working hours have to be changed as a percentage

per total week hours (e.g. Engineer: 5 hours per week = 5/40 = 12.5%) to yield the total

hours required to finish the activity.

6) The total hours of work to complete the activities should not change (e.g. for Preliminary

Planning requires 5 engineers hours per week working for 10 weeks for a total of 50 hours)

Week 5: Construction Scheduling

7) If you are in auto schedule mode, as you assign resources to activities, the software will try to

allocate them automatically to solve conflicts, to see the unleveled schedule you can always

click on Clear Leveling.

8) The Resource Leveling tool will not fix all the Limited Resources conflicts, you will have

to redistribute the resources by adding appropriate weeks to the activities with resource

conflicts, when doing this Project will ask you if work hours have increased or resources

will work fewer hours, choose appropriately.

Requirements:

1) Print the Gantt chart views before and after Leveling Resources (Show in one page Task

Name, Duration and Gantt chart only).

2) Print the Resource Sheet.

3) Print the Resource Usage sheet showing the Resource Name and Total Work hours for

each resource and activity (Just the first page, left side), before and after Resource Leveling.

4) Choose one resource that is conflicting and print the Resource Graph of this resource

showing where it has conflicts before and after Resource Leveling.

5) Use the final leveled schedule and research appropriate hourly wages for Field Engineer,

Laborers and Consultants, and hourly rates for a Crane (You can use RSMeans or any other

reliable source for the US). Input this cost in the Resource Sheet and obtain the weekly cash flow

for the project.