complete the following problems from the textbook: Chapter 6, pages 280-282, Problems 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. Linear programming will be covered in Module 7. #20 1- 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 DAYS Activity A m b Immediate Predecessors A 4 8 12 — B 4 10 13 A C 7 14 18 B D 9 16 20 B E 6 9 12 B F 2 4 6 D,E G 4 7 13 C,F H 3 5 7 G I 2 3 4 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? # ***** The expected project completion time for the construction of a pleasure yacht is 21 months, and the project variance is 6. What is the probability that the project will: a. Require at least 17 months? b. Be completed within 20 months? c. Require at least 23 months? d. Be completed within 25 months? # ***** 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 are given in the table on the next page. The project completion time using standard times is 14 weeks. How much does it cost to reduce the duration of this project from 14 weeks to 10 weeks? Activity Immediate Predec. Standard time Stand. Cost Crashtime(weeks) CrashCost A — 3 1,000 2 1,600 B — 2 2,000 1 2,700 C — 1 300 1 300 D A 7 1,300 3 1,600 E B 6 850 3 1,000 F C 2 4,000 1 5,000 G D,E 4 1,500 2 2,000 # ***** Getting a degree from a college or university can be a long and difficult task. Certain courses must be completed before other courses may be taken. Develop a network diagram in which every activity is a particular course that you must take for your 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 your particular school. A. How long do you think it will take you to graduate? B. Which courses, if not taken in the proper sequence, could delay your graduation?