UNIVERSITY OF ILLINOIS AT URBANA-CHAMPAIGN DEPARTMENT OF CIVIL AND ENVIRONMENTAL ENGINEERING CEE320 CONSTRUCTION ENGINEERING AND MANAGEMENT FALL 2016 THE ROCKFORD PROJECT CHAPTER 9: JOB COSTING DUE DATE: THURSDAY DECEMBER 1ST, 3:30 PM Prof. Mani Golparvar-Fard Office Hours: Tue and Thu 1:30 - 3:00 pm or by appointment Office: 3129D, Newmark; E-mail: mgolpar@illinois.edu Contact Teaching Assistants: Ray Sumler, Wilfredo Torres Calderon, and Mahmoud Hmaidi Office Hours: Mon noon - 1:30pm, Wed 1:30 pm - 3:00 pm, or by appointment Office: Quade Conference Room, Newmark; E-mails: sumler2@illinois.edu; trrscld2@illinois.edu; hmaidi2@illinois.edu Lectures: Tue & Thu, 3:30 PM - 4:50 PM * Please see the Schedule of Sessions for details on location. Notes: 1. This is a TEAM assignment. You can only discuss concepts with other groups. No other discussions are allowed. DO NOT COPY answers from any sources such as Internet or Past Assignments. 2. If you have a problem or question after reading the assignment, please post your questions on the \"Piazza\". In case of confidentiality issues, email your instructors team (e.g., Prof. Golparvar, Ray, Wil, or Mo) CEE320: Construction Engineering and Management Assignment 9 CHAPTER 9: JOB COSTING Setting: In the afternoon of the 27th workday for Pipe Pro on the job of Rockford, Tim Timer just finished his work on the new schedule. The schedule shows that the installation of the storm water system will be delayed. He gave the schedule to Peter, who was worried about the possible higher cost of completion. He called his old high school friend, Cassandra Costa, who works for an Architect/Engineering firm in Ohio. The telephone call went like this: Peter: Hi Cassy, it's Peter. I have a little bit of a problem on one of our jobs and... Cassy: ...and I'm supposed to help you out again. Peter: Yes, please! Cassy: I guess it has something to do with costs, right? Peter: Right. Cassy: Peter, why don't get yourself a book about construction cost control? Or even better, try to take a course in this. You can't turn to me all the time. I have a job to do here myself. Peter: Cassy, how about this? I'll promise you that I will get knowledgeable with this construction cost stuff, if you can do me this last favor. Please! Cassy: That does not sound like a good deal, but I will help you out this LAST time. Peter: Thank you so much! Peter sent Cassandra an e-mail with the old cost estimate and the three schedules from Tim Timer. He also added the following information to your e-mail: "The price of the bedding material actually turned out to be $26.10/CY. As far as the placement and compaction of the bedding material is concerned, the price per hour for both of them is $2.50 less than the estimate. The excavation is $162.31/hr. That is indeed very close to our estimate. The price per hour for laying and jointing the pipes went up by $5.00. All other costs are as estimated." Fall 2016 Page 2 of 5 CEE320: Construction Engineering and Management Assignment 9 Additional data from Peter's Fax Table 9.1 - Budgeted Cost Quantity Duration Unit (units) (hours) Item Unit Cost Total Cost Excavation $162.31 HR - 20.5 $ 3,327.30 Pipe Material $50.60 LF 2,500 - $ 126,500.00 Bedding Material $23.10 LCY 463 - $ 10,694.44 Place Bedding Material $174.15 HR - 10.3 $ 1,793.72 Compact Bedding Material $44.64 HR - 15.4 $ 687.50 Lay and Joint Pipe $298.98 HR - 125 $ 37,372.50 Backfill $214.99 HR - 33.2 $ 7,137.68 Compaction $229.14 HR - 37.1 $ 8,500.95 Overhead $77.55 HR - 300 $ 23,265.00 Table 9.2 - Quantity Summary Fall 2016 Item Quantity Unit Excavation Pipe Material Bedding Material Place Beddding Material Compact Bedding Material Lay and Joint Pipe 4,644 LCY 2,500 LF 463 LCY 463 LCY 463 LCY 2,500 LF Backfill Backfill Compaction Overhead 4,452 LCY 4,452 LCY 300 HR Page 3 of 5 CEE320: Construction Engineering and Management Assignment 9 Table 9.3 - Actual Work Completed at EOD 27 Item Quantity Unit Excavation 4,644 LCY Pipe 1,700 LF Material Bedding 463 LCY Material Place Beddding 463 LCY Material Compact Bedding 463 LCY Material Lay and 1000 LF Joint Pipe Backfill 570 LCY Backfill 250 LCY Compaction Overhead 190 HR Table 9.4 - Scheduled Work Completed at EOD 27 Item Quantity Unit Excavation 3,915 LCY Pipe 2,000 LF Material Bedding 361 LCY Material Place Beddding 361 LCY Material Compact Bedding 361 LCY Material Lay and 1,250 LF Joint Pipe Backfill 400 LCY Backfill 180 LCY Compaction Overhead 172 HR Assignment 9 Imagine you are cost expert, Cassandra Costa. Use the data provided in the handout and produce an estimate of the cost of the work at completion. Calculate the following as the basis of your report: 1. The scheduled work in % complete by the end of workday 27 for each activity/item in the cost estimate, and thus the budgeted cost of work scheduled based on Tim Timer's original schedule. 2. The actual work in % completed by that time for the same activities/items and thus the budgeted cost of work performed. 3. The actual cost of work performed based on the estimate updates that Peter tells Cassandra. 4. The cost performance index as well as the schedule performance index for each of the activities/items by the end of the 27th workday. Prepare a memo summarizing the results from the report and then attach the report to the memo. Fall 2016 Page 4 of 5 CEE320: Construction Engineering and Management Assignment 9 Assignment 9 Rubric Timeliness and Professionalism (25 points) 15 10 On-Time Submission Professional presentation Calculations (75 points) 15 15 15 BCWS calculations BCWP calculations ACWP calculations 15 15 each SPI each CPI Note: BCWS, BCWP and ACWP are the most essential parts of this assignment. There are 9 activities (excluding the O/H) where calculating BCWS, BCWP and ACWP are necessary. Determining CI and SI is then just a matter of math (BCWP/ACWP and BCWP/BCWS). If BCWS and BCWP numbers are right then the indices should be right, otherwise a math error was made. Give follows credit if the correct equations are used. In the case of backfill and compaction of trench, SI should be undefined (either indicated by a NA or "-" or something). Recognizing this should be worth a point or two. Fall 2016 Page 5 of 5