Develop simulation model for a PERT/CPM assignment based on problem 14 from chapter 11. Use the attached template (it has probability distributions of duration of activities A through D that you should consider) and perform 120 recalculations/trials using the Data Table feature of Excel. Calculate the following summary statistics: the estimate of the average length (duration) of the project the standard deviation of the project length (duration) minimum, maximum and range of the project length (duration) Calculate the probability that the project will be completed in 36 weeks or less, Display summary statistics and the probability of project completion in 36 weeks or less ON TOP OF THE SHEET On a separate sheet (rename it PERT_chart) create a histogram showing frequency distribution of project length (duration). Attachments PERT simulation template.xlsx A1 fx B 1 Project duration problem (PERT/CPM model) 2 Input Parameters 3 Activity A Cumulative 5 Probability Probability Time 6 7 B 9 10 11 12 TRIAL 13 14 15 16 17 Ready 0.25 0.35 0.25 0.15 Alignment Project duration problem (PERT/CPM model) D E Windows User: The Cumulative Probability column should display the starting value of each interval of random number to be associated with activity time 5 6 7 8 Activity A duration of A Rand # Rand # template to consider Type here to search O Number Probability Activity B duration of B 0.2 0.55 0.25 1221 Rand # 15 Activity B Cumulative Probability Styles Time Activity C duration of C 3 5 7 Rand # H me Activity Co uration of C 49 6 Y H 3 7 N Rand hp Probability Activity D duration of D 144 ( 7 8 UD U 9 Cumulative Probability 0.1 0.25 0.4 0.2 0.05 PROJECT DURATION Time J K L ; M alt 10 12 14 16 18 66F Cloudy O O P [ / Activity D Cumulative Probability Probabdity 0.6 04 insert 3 D prt sc + backspace pause ctri