You are in the process of estimating activity duration in days) for your new project. After planning out the required activities you have been given the following information on the mostly most optimistic and most pessimistic duration estimates by the expert resources that will be undertaking the more complex activities on the project: Predecessor Optimistic Pessimistic Activity A B D E F G H 3 5 5 (9 A A B B.c D Most likely 2 5 7 6 3 2 5 7 21 7 4 12 D 4 1 E.F J 2 3 GH 1 J.K 4 6 20 L 2 The Excel spreadsheet can be accessed here. For further information see Spacer. Required: Please answer all questions in CANVAS! a. Using the weighted average formula for complex duration estimate [(a+4m+b)/6] calculate the estimated duration ONLY for activities B, C, D. G and K. Please write down the estimated duration for those activities in Canvas. (2.5 marks) b. Draw a network diagram that displays the relationships between each of the tasks using the attached MS Excel file. Also, identify the critical path (and duration) by performing a forward and backward pass on the diagram. Use the calculated durations for B, C, D, G and K from part a) and the "most likely" durations for A, E. F. H. 1. J and L b1) Please write down in CANVAS the critical path including duration - Clearly identify that this is the critical path! (4 marks) b2) Please Write down in CANVAS all other paths and the duration of them. (4 marks) c. Using your network diagram, identify what would happen to the project duration if task was delayed by 4 days? (3 marks) d. Using your network diagram, identify what would happen to the project duration if task H was delayed by 3 days? (1.5 marks) Please note Questions d) and e) are independent of each other, both questions start from the network diagram drawn in b). You are in the process of estimating activity duration in days) for your new project. After planning out the required activities you have been given the following information on the mostly most optimistic and most pessimistic duration estimates by the expert resources that will be undertaking the more complex activities on the project: Predecessor Optimistic Pessimistic Activity A B D E F G H 3 5 5 (9 A A B B.c D Most likely 2 5 7 6 3 2 5 7 21 7 4 12 D 4 1 E.F J 2 3 GH 1 J.K 4 6 20 L 2 The Excel spreadsheet can be accessed here. For further information see Spacer. Required: Please answer all questions in CANVAS! a. Using the weighted average formula for complex duration estimate [(a+4m+b)/6] calculate the estimated duration ONLY for activities B, C, D. G and K. Please write down the estimated duration for those activities in Canvas. (2.5 marks) b. Draw a network diagram that displays the relationships between each of the tasks using the attached MS Excel file. Also, identify the critical path (and duration) by performing a forward and backward pass on the diagram. Use the calculated durations for B, C, D, G and K from part a) and the "most likely" durations for A, E. F. H. 1. J and L b1) Please write down in CANVAS the critical path including duration - Clearly identify that this is the critical path! (4 marks) b2) Please Write down in CANVAS all other paths and the duration of them. (4 marks) c. Using your network diagram, identify what would happen to the project duration if task was delayed by 4 days? (3 marks) d. Using your network diagram, identify what would happen to the project duration if task H was delayed by 3 days? (1.5 marks) Please note Questions d) and e) are independent of each other, both questions start from the network diagram drawn in b)
