Question 3: Gantt Charts and Resource Leveling (15 marks) The table below lists all activities for an IT project with their predecessors, duration in weeks and resources Activity | Predecessor | Duration (Weeks) Personnel Required Per Week ) Draw a Gantt chart for the above project. Indicate the critical path and the minimum project time. (5 marks) Calculate the total floats for each non-critical activity. (2 marks) Allocate the resources for each activity and draw a histogram showing the weekly usage of resources. What 1s the average resource requurement per week? (2 marks) Assume that the maximum workers per week available for the project is 25. Identify any period with resource over commitments. (2 marks) Apply resource leveling to ensure that the maximum resource required per week does not exceed 25 workers. Explain your solution. lf-'l marks) Question 1: Critical Path Analysis (15 marks) A software company has received a contract from a client for the development of an E-Auction system. A team of engineers has determined the activities, precedence constraints and time estimates as given in the table below. All times are in weeks. Activity Predecessors Optimistic Most Likely Time Pessimistic Time (a) (m) Time (b) A 4 6 8 B 1 4.5 5 C A 3 3 3 D A 4 6 E A 0.5 1.5 F B.C 3 4 5 G B.C 1 1.5 5 H E. F 5 6 7 I E,F 2 5 8 J D.H 2.5 2.75 4.5 K G.I 3 5 7 a) Draw a fully analysed activity-on-node (AoN) network diagram for this project, using a standard node convention, to display the duration, the earliest and latest start and end dates and the float for each activity. Supply a node key. (8 Marks) b) Name, and display on the network diagram, the critical path and state the minimum duration. .(3 marks) c) What is the probability that the project will be completed within 24 weeks? (2 marks) d) By what date is management 96 percent sure completion will occur? (2 marks)Question 4: Earned Value Analysis (15 marks) Your company is currently working on a house building project for an external client. An outline plan for this project has been drawn up with the tasks and their expected duration and budget. ID Task Predecessors Duration Budget ($) (Months) A Design House 3 30000 B Lay Foundation A 2 200 00 Order and receive A 1 30000 materials D Build House B. C 3 400 00 E Select Paint B. C 10000 Select Carpet E 1 15000 G Finish Work D, F 2 20000 a) Draw a Gantt chart of the above project. Indicate the critical path and the total floats (if any). (3 marks) b) Complete the following table (3 marks) MONTHLY BUDGET ($) Task | DUR ES EF LS LF 1 2 3 4 15 6 7 9 A H D E GThe following represents the progress status at 6 months Task Status Actual Start Actual Actual Cost ( Months) Duration (S) Design House 100%% 0 3 months 25000 B Lay Foundation 100% 3 months 2 months 22000 Order and receive 100% +1 month 1 month 28000 materials D Build House 25% As per other delays 20000 Select Paint 100% As per other delays 1 month 9000 Select Carpet As per other delays G Finish Work 0% As per other delays c) Draw another Gantt chart representing the current status of the project. (3 marks) 18431 Final Examination - Semester 1 2018 - Page 10 of 13 Name: ID Number: d) Now complete the following earned value analysis table (3 marks) TASK %Complete | EV AC PV A B D E F G Totals e) Calculate CV, SV, CPI and SPI for the project and comment on the project performance