X=1

TABLE 1: SUMMARY OF INFORMATION OBTAINED FROM DETAILED ANALYSIS Crash condition Direct Cost (AUD) Normal condition Activity Description ID Duration Direct Cost Resource/ (Weeks) (AUD) week (units) A Excavate 2+X 180,000 7 B Lay the foundation 4 +X 320,000 8 Put up the rough wall 10 +X 620,000 9 D Put up the roof 6 +X 260,000 4 E Install the exterior plumbing 4 +X 410,000 3 F Install the interior plumbing 5+X 180,000 7 G Put up the exterior siding 7 + X 900,000 5 H Do the exterior painting 9 + X 200,000 3 Do the electrical work 7 + X 210,000 3 J Put up the wallboard 8 + X 430,000 5 Install the flooring 4 + X 160,000 4. L Do the interior painting 5+X 250,000 3 M Install the exterior fixtures 2 + x 100,000 3 N Install the interior fixtures 6 + X 330,000 7 Group Numer Where, X = rounded up to the nearest integer. 2 Duration (Weeks) 1 + X 2+X 7+X 4+ X 3+ X 3+X 4+X 6 + X 5+X 280,000 420,000 860,000 340,000 570,000 260,000 1020,000 380,000 270,000 490,000 200,000 350,000 200,000 510,000 6+X 3+ X 3+X 1+X 3+X PROJECT INDIRECT COST Indirect cost = AUD (5000+ group number x 100)/week TASK RELATIONSHIPS: After the analysis of the tasks, you have been able to establish the following task relationships: The project starts with the excavation for the foundations. The foundation for the building can only be laid once the foundation excavation has been finished. The rough wall can be placed only after the foundation has been laid. The placement of roof requires the completion of rough wall works. The start of the exterior plumbing work is dependent on the completion of rough wall work. Interior plumbing cannot start until the exterior plumbing is complete. Exterior siding cannot start until the roof is in place. The start of exterior painting requires the completion of the exterior siding and the exterior plumbing works. The electrical work can start once the rough wall is in place. Wall board can be placed only after the interior plumbing and electrical works are complete. Flooring and interior painting cannot start until the wallboard work is complete. Exterior fixtures can be installed only after the completion of the exterior painting work. Interior fixtures cannot be placed until flooring and interior painting are complete. Installation of interior fixture makes the project ready for handover. . 1 . TASK 3 - RESOURCE LEVELLING (4 MARKS) SUBTASKS MARKS Prepare resource histogram for the earliest start of all the activities under normal condition. You must show resource allocation on the Gantt chart. Gantt Chart must clearly show critical activities, non-critical activities, and floats. 1 Prepare resource histogram for the latest start of all the activities under normal condition. You must show resource allocation on the Gantt chart. Gantt Chart must clearly show critical activities, non-critical activities, and floats. 1 Level the resources under normal duration of the activities to improve resource utilization and demonstrate the improvement by comparing Resource Utilization Factor (RUF) values. You must show all the associated resource allocations on the Gantt Chart, present resource histograms and show the calculation for Resource Utilization Factors (RUF) 2 TASK 4 - PROJECT BUDGETING (7 MARKS) SUBTASKS MARKS . Earliest start of all the activities 1 Normal duration of activities Latest start of all the activities 1 Time-phased weekly budget 1 Resource-levelled condition 1 1 Earliest start of all the activities 1 Fully crashed condition Latest start of all the activities 1 Earliest start of all the activities Normal duration of activities 1 Latest start of all the activities 1 Draw the cumulative project cost vs. time graphs on a single plot Resource-levelled condition Earliest start of all the activities Fully crashed condition 1 1 Latest start of all the activities TASK 5-EARNED VALUE ANALYSIS (6 MARKS) It was decided to budget the project using normal duration of each of the activities. The progress of the project activities exactly at the middle of the planned project duration are given below: Activity Percent Completed Actual Cost to Date (5) 100 200,000 330.000 600.000 200,000 400,000 60,000 50 130,000 A B D E F 100 100 75 100 25 MARKS 1 1 1 SUBTASKS Based on the given status of the project determine the followings: A. Planned Value (PV) and Earned Value (EV) at the status date B. Schedule Variance (SV) and Schedule Performance Index (SPI) at the status date C. Cost Variance (CV) and Cost Performance Index (CPI) at the status date D. Estimated duration of the project assuming the future schedule performance will be influenced by the past Schedule Performance Index. E. Estimated cost at project completion assuming the future cost performance will be influenced past Cost Performance Index only. F. Graphically show the followings on a single graph: Schedule Variance (SV) at the status date Cost Variance (CV) at the status date Time Variance (TV) at the status date Cost at completion Cost Variance (CV) at completion Delay at Completion (DAC) 1 . TASK 6 - ANALYSIS OF THE PROJECT USING MICROSOFT PROJECT (4 MARKS) SUBTASKS MARKS Show project Gantt-Charts highlighting the critical activities You need to show Early Start (ES), Early Finish (EF). Late Start (LS) and Late Finish (LF) of all the activities by inserting additional columns on the table. Format the network diagram to show the followings: Under normal duration of the activities 2 ES EF Duration LS LF Show project Gantt Charts highlighting the critical activities . You need to show Early Start (ES), Early Finish (EF). Late Start (LS) and Late Finish (LF) of all the activities by inserting additional columns on the table. Format the network diagram to show the followings: Under fully crashed condition 2 ES EF Duration LS LF Compare the manually calculated values with the values obtained from Microsoft Project and comment on your observation Note: You need to submit two Microsoft project files on CANVAS. The names of the files need to be as given below: File 1: MIET2138 Group Project (Group No XX) - Normal condition File 2: MIET2138 Group Project (Group No XX) - Fully crashed condition