must be done in excel

Chapter 13 Project Scheduling PERT/CPM Case Problem R. C. Coleman RC Coleman distributes variety of food products that we sold they and supermarket outlets. The company receives adors directly from the video with a typical onder requesting the delivery of several cases of anywhere from 2050 dispatch orderpicking personnel to fill each onder and have the goods to the different products. Under the company's current ware operation wheredes house shipping are. Because of the high tabor costs and relatively low ende onderpicking management has decided to make the warehouse or by a computer-controlled orderpicking system, along with conversion for goods from storage to the warehouse shipping area RC Coleman's director of material management has been named the pe ager in charge of the automated warehouse system. After conting with means of the engineering staff and warehouse management personnel, the director wild activities associated with the project. The optimistic, most probable, and istim (in weekx) have also been provided for each activity Activity A B Immediate Predecor AB Description Determine equipment needs Obtain vendor proposals Select vendor Order system Design new warehouse layout Design Warehouse Design computer interface Interface computer Install system Train system operators D E F G H 1 J K D.F.G DF H Test system Time (weeks) Most Probable Pessimistic Optimistie 6 Activity A B C D E F G H 1 8 4 10 10 6 6 6 4 4 4 4 3 2 16 6 24 13 8 20 8 14 5 6 6 4 K Appendix 13.1 Finding Cumulative Probabilities for Normally Distributed Random Variables 629 Managerial Report Develop a report that presents the activity schedule and expected project completion time for the warehouse expansion project . Include a project network in the report. In addition, take into consideration the following issues: 1. R.C. Coleman's top management established a required 40-week completion time for the project. Can this completion time be achieved? Include probability infor- mation in your discussion. What recommendations do you have if the 40-week completion time is required? 2. Suppose that management requests that activity times be shortened to provide an 80% chance of meeting the 40-week completion time. If the variance in the project completion time is the same as you found in part (1), how much should the expected project completion time be shortened to achieve the goal of an 80% chance of completion within 40 weeks? 3. Using the expected activity times as the normal times and the following crashing information, determine the activity crashing decisions and revised activity schedule for the warehouse expansion project: Crashed Activity Time (weeks) 4 Activity A B D E F G H 1 J K 2 8 7 4 Ontem Cost ($) Normal 1,000 1,000 1,500 2,000 5,000 3,000 8,000 5.000 10,000 4.000 5,000 Crashed 1,900 1.800 2,700 3.200 8,000 4,100 10,250 6,400 12,400 4,400 5,500 4 4 3 3