I am still having so much trouble figuring out question 3. I do not understand how to do the crashing with constraints. If someone can please help me with part a and b for question 3.

Here is my answer to question 1 and 2. I need help with question 3 part a and b.

I figured out questions 1 and 2. But with my excel currently not having the data analysis tool I need, I am having trouble figuring out question 3.. part a and b. B D Dr. Ell has been given a budget of $10,000 to organize a conference at her university in 3 months' time (13 weeks) via an educational grant. She has a team of 2 research assistants and after some deliberation, they identified the following activities that are required to be completed for hosting a successful conference Activity Description Immediate Predecessor A Planning Topics and Sessions B Identifying potential venues in the city Selecting a venue for the conference Inviting presenters from various universities A,C Finalizing presenters for each session F Completing registration for all presenters Last minute edits, replacements, and lists F Dr. Ell has approached you, her student, to help her figure this out, as a part of her Management Science class assignment. Please give your responses, with appropriate explanations, tables, and formulas, where relevant to the following questions: 1. Follow a PERT/CPM model to identify the project network, activity schedule, critical activities, and the expected time for completing the project successfully. The expected completion times for each of the listed activities is based on the experiences of all the people on the team and is as follows: E D E Activity Optimistic Most Probable Pessimistic A 1 2 6 B 1 2 3 1 3 5 D 1 2 3 E 1 2 3 F 1 2 3 1 1 1 2. Dr. Ell is worried about completing all the required activities before the 13-week deadline is up, because she has never hosted a conference before. She wants to know, based on her team's estimates what is the probability of NOT completing the activities by the end of 13 weeks. (47) AO 2 23 IE STAKT 657 12157 IF 19 11 12 7 9 12911 1625 ES Activity A B EF 2 13/25 UF 5 2 0 sorelowlool 12 2 5 Slack Critical Total time = 12 days 3 NO Critical Path B, C, D, E, F, G. Yes Activity A slack time - 3 days Yes Variance=0.5 res 2 = (13-12)sqrt (0.5) - 1.41-.9207 Yes 1-9207=10.0793) O yes Yes 5 7 9 7 9 7 9 a OO 2 12