Saint Johns Hospital Project In the interest of better serving the surrounding community, the board of St. Johns Hospital has decided to move to a new location. The project involves constructing a new hospital and making it operational. Judy Kramer, the project manager for the St. Johns Hospital project, divided the project into two major modules. She assigned John Stewart the overall responsibility for the Organizing and Site Preparation module and Sarah Walker the responsibility for the Physical Facilities and Infrastructure module. The project has a deadline of 65 days. The project manager has developed the precedence relationships, and activity time estimates for this project and they are shown in the following table: Activity Description Immediate Predecessor Optimistic Time (a) Most-Likely Time (m) Pessimistic Time (b) A Select administrative staff - 11 12 13 B Select site and survey - 7 8 15 C Select medical equipment A 5 10 15 D Prepare final construction plans B 8 9 16 E Bring utilities to site B 14 25 30 F Interview applicants for nursing and support staff A 6 9 18 G Purchase and deliver equipment C 25 36 41 H Construct hospital D 35 40 45 I Develop information system A 10 13 28 J Install medical equipment E, G, H 1 2 15 K Train nurses and support staff F, I, J 5 6 7 The project manager wants to use simulation to evaluate the likelihood of completing the project by the deadline. For the simulation, assume that a triangular distribution is used to determine the task time for each activity. 1. Since a triangular distribution will be used to randomly sample the probability distribution for an activitys time, generate a random value between 0 and 1 for each activity. a. Use a triangular distribution to generate a random time for each task given the optimistic, most likely and pessimistic times that the project team has determined. b. Calculate the starting time and finishing time for each activity. c. NOTE: It may be helpful to complete the next part before calculating the starting and ending task times. 2. Draw the network diagram for this project based on each activitys immediate predecessor. 3. Create a reference to the projects completion time for the first run of the simulation. 4. Create a Data Table in order to create 200 replicates for the projects completion time. 5. Based on the Data Table, create a histogram for the projects completion time. 6. Based on the Data Table, calculate the various descriptive statistics for the projects completion time. 7. Based on the Data Table, calculate the Frequency and Percentage based on the number of days provided in the table. a. Estimate the probabilities of the project being completed less than or equal to the days in the table, and greater than the days listed in the table. b. Use Conditional Formatting with Solid Green Bars for probability statements associated with less than or equal to statements. c. Use Conditional Formatting with Solid Red Bars for probability statements associated with greater than statements. 8. Do you think the project will be completed by the deadline? Provide evidence to justify your answer.