Question: Only need the answer to question F. Please show formulas for excel as well Due to the popularity of investment apps, the Investors National Bank

Only need the answer to question F. Please show formulas for excel as well

Only need the answer to question F. Please show

Due to the popularity of investment apps, the Investors National Bank of Atlanta has noticed a significant increase in the number of transactions made by its clients. To meet the current level of activity, the bank needs to install a new computer system to handle its accounts more efficiently. Kinzie Brown, the bank's manager, has identified the activities that must take place to both the computer system and the equipment that interfaces with the computer system to complete the project. He and his team have also determined the precedence relationships of the activities and the estimated activity times. The information collected is shown in the table below. Task Description A Immediate Predecessor None None B D E F Hire system developer Develop system Conduct system training Conduct equipment training Test system Perform system changeover Design equipment for system interface Integrate the interface into the system Test equipment Debug system Perform equipment changeover Optimistic Most Likely Pessimistic Time Time Time 7 10 19 5 14 17 6 9 12 7 10 25 3 3 3 3 6 15 5 8 11 3 4.5 9 3 3 3 4 4 4 7 10 13 A B,C B, C D, E D, E H F.G GI G H 1 K Based on the information provided, answer the following questions. Round calculations to at least 4 decimal places. Note: Excel may be used to perform the calculations for this problem but all answers must be contained in the test document. a) Create a network diagram for this project. (6) b) Create a table showing the earliest start and finish as well as the latest start and finish values. (4) c) What is the expected project completion time? (2) d) Calculate the slack for each activity and include them in the table created for part (b). (2) e) What are the critical path activities? (2) 1) What is the probability of completing the project in 45 weeks or less? (4)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!