Question: PLEASE SOLVE THIS PROBLEM IN AN EXCEL DOCUMENT. PLEASE PROVIDE ONE VERSION OF EXCEL SCREENSHOTS OF THE FORMULAS AND ANOTHER WITH THE RESULTS THE FORMULAS

PLEASE SOLVE THIS PROBLEM IN AN EXCEL DOCUMENT. PLEASE PROVIDE ONE VERSION OF EXCEL SCREENSHOTS OF THE FORMULAS AND ANOTHER WITH THE RESULTS THE FORMULAS CREATED. THANK YOU!
Problems 15. Doug Casey is in charge of planning and coordinating next spring's sales management training program for his company. Doug listed the following activity information for this project: Immediate Predecessor Activity Time (weeks) Most Probable 2.0 Optimistic 1.5 Pessimistic 2.0 25 6.0 2.0 3.0 1.0 1.5 Description Plan topic Obtain speakers List meeting locations Select location Finalize speaker travel plans Make final check with speakers Prepare and mail brochure Take reservations Handle last-minute details C B.D 0.5 E B,D G F.H 1.0 3.0 3.0 1.5 a Draw a project network. b. Prepare an activity schedule. C. What are the critical activities and what is the expected project completion time? d. If Doug wants a 0.99 probability of completing the project on time, how far ahead of the scheduled meeting date should he begin working on the projectStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
