s 20, 22, 30, and 35 using Excel QM/POM QM NOTE For Problem 30, there is no need to solve the problem using linear programming methods. Instead, you should focus on solving using the project management capabilities within Excel QM/POM QM 20. A series of activities must be completed in a coordinated fashion to complete a landscaping overhaul. The following table shows the activities their optimistic, most likely and pessimistic durations and their immediate predecessors Activity A B C D E F G H I A 4 4 7 9 6 2 4 3 2 m 8 10 14 16 9 4 7 5 3 b 12 13 18 20 12 6 13 7 4 Immediate Predecessors --A B B B D,E C,F G G,H A- Determine the expected times and variances for each activity B- Construct a project network for this problem C- Determine the EST, EFT, LST, LFT and slack for each activity. Also determine the critical path and project completion time. D- What is the probability that the project will be finished in less than 57 days? E- What is the probability that the project will need at least 50 days? 22. The expected project completion time for the construction of a pleasure yacht is 21 months and the project variance is 6. What is the probabliltity that the project will (a) Require at least 17 months? (b) Be completed within 20 months? (c) Require a least 23 months? (d) Be completed within 25 months? 30. Bowman Builders manufactures steel storage sheds for commercial use. Joe Bowman, president of Bowman Builders, is contemplating producing sheds for home use. The activities necessary to build an experimental model and related data given in the table on the next page. The project completion time using standard times in 14 weeks. Set up and solve an LP model using Excel to crash the project to 10 weeks. How much does it cost to reduce the duration of this project from 14 to 10 weeks? 35. Getting a degree from a college or university can be a long and difficult task certain courses must be completed before other courses can be taken develop a network diagram in which every activity is a particular course that you must take for you degree program. The immediate predecessors will be course prerequisites don't forget to include all University College and departmental course requirements. Then try to group these courses into semesters or quarters for our particular school. How long do you think it will take you to graduate? Which course, if not taken in the proper sequence could delay your graduation