What is the duration (in days) of the activity to install all the fixtures in the dormitory with one crew? Assume an eight-hour workday and round the total days up to the whole day.
What is the duration (in days) of the activity to install all the fixtures in the dormitory with one crew?
Problem Set 4 (Ch. 10 & Lecture) Resource Leveling and Productivity
Your Name Here
Overview:
Final ‘problem sets’ should include a word document (.docx) (12-point font, 1” margins, times new roman) that responds to each individual problem below. Include the problem statement in this document, as well as your solution. Make sure that each solution includes:
A description of what you did and how you did it;
All values clearly labeled with units (e.g., “work days”, “crews”, “workers”);
A reference included for any reference to a table, figure, or equation provided in a text; and
A clear description/reference to what you found;
All calculations (formulas and how they are used) must be shown; and
Calculations can be completed in excel, but must be documented in full professionally in this word document.
Problem #1: The estimate for a three-story dormitory included 30 plumbing fixtures on each of the floors. In developing the bid, the estimator used a production rate of 0.625 person-hours per fixture. The project superintendent is organizing the plumbing crews to include two plumbers per crew. What is the duration (in days) of the activity to install all the fixtures in the dormitory with one crew? Assume an eight-hour workday and round the total days up to the whole day.
Hint: The production rate provided is ‘person-hours per fixture’; you have multiple people per crew working. You will also need to calculate the total quantity of fixtures for the building with multiple floors.
Solution #1:
Problem #2: For each of the following activities and corresponding estimated information, calculate the following information:
Production rate per crew for each activity (units per crew hour)
Time to complete each activity (hours)
Duration of each activity (whole days, rounded up)
Activity PIB Production Rate (units per man-hour) Quantity of material
(units) Workers per crew
A or 5 None 3.125 200 2
B or 10 5 3.125 300 4
C or 15 5 3.125 200 2
D or 20 10, 15 6.250 100 1
E or 25 15 3.125 300 4
F or 30 20 6.250 100 2
G or 35 20, 25 3.125 300 3
H or 40 25 6.250 300 2
I or 45 30, 35, 40 6.250 200 2
Solution #2:
Problem #3: Given the following Gantt chart (with resources corresponding to activities):
What is the distribution of resources (workers per day) required for the existing schedule (unleveled)? (the sum of all resources for each day of the project as scheduled)
You determine you have enough workers to higher up to 6 workers per day between the 1st of the month and the 10th, but after that you only have enough workers to hire 5 per day. Does the existing unleveled schedule allow for this constraint to be met while still delivering the project on time? If not, can the schedule be leveled to meet this constraint and deliver the project ton time? If so, produce the leveled schedule and indicate what changed. If not, describe the constraint that prevents both constraints (on-time completion on the 25th and limited workers per day) from being met. For any given day an activity takes place, the workers per day are the required number of workers to complete the activity for that given day—no splitting up crews.
Hint: “IN” represents interfering float. “F” represents free float. The schedule has already been placed into a calendar with additional holidays. Do not schedule workers over the weekend or during the holidays!
Date: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Activity Resources M T W Th F Sa Su M T W Th F Sa Su M T W Th F Sa Su M T W Th
5 2
10 4 F IN
15 2
20 1 IN
25 4
30 2 F F F F
35 3
40 2 F
45 1
Solution #3:
Problem #4: See the resources needed for each activity and the corresponding calendar. Add the resources to your calendar (below). For any given day an activity takes place, the workers per day are the required number of workers to complete the activity for that given day—no splitting workers.
Hint: “IN” represents interfering float. “F” represents free float. The schedule has already been placed into a calendar with additional holidays. Do not schedule workers over the weekend or during the holidays!
Determine what the required resources are in workers per day.
You have a maximum ability to hire 6 workers per day. Can you level the schedule to complete your job on time? If so, what would the “leveled” schedule look like? If not, explain why not and level the schedule to show the new project schedule and duration that accommodates the resource constraints.
Activity Duration PIB workers per day
5 2 None 1
10 3 None 1
15 3 5 2
20 4 5 2
25 1 10 1
30 2 15 2
35 2 25 3
40 5 20, 30, 35 1
M T W Th F Sa Su M T W Th F Sa Su M T W ThActivity 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
5
10 IN
15
20 F
25 IN
30
35 F
40
Solution #4: