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.