Using Excel and solve the following problems. Provide linear programming.

R. C. Coleman

R. C. Coleman distributes a variety of food products that are sold through grocery store and supermarket outlets. The company receives orders directly from the individual outlets, with a typical order requesting the delivery of several cases of anywhere from 20 to 50 different products. Under the companys current warehouse operation, warehouse clerks dispatch order-picking personnel to fill each order and have the goods moved to the warehouse shipping area. Because of the high labor costs and relatively low productivity of hand order-picking, management has decided to automate the warehouse operation by installing a computer-controlled order-picking system, along with a conveyor system for moving goods from storage to the warehouse shipping area.

R. C. Colemans director of material management has been named the project manager in charge of the automated warehouse system. After consulting with members of the engineering staff and warehouse management personnel, the director compiled a list of activities associated with the project. The optimistic, most probable, and pessimistic times (in weeks) have also been provided for each activity.

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. Colemans top management established a required 40-week completion time for the project. Can this completion time be achieved? Include probability information in your discussion. What recommendations do you have if the 40-week completion time is required

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: Solve for 38-weeks completion.

\begin{tabular}{clc} Activity & \multicolumn{1}{c}{ Description } & Immediate \\ A & \multicolumn{1}{c}{ Determine equipment needs } & Predecessor \\ B & Obtain vendor proposals & - \\ C & Select vendor & A,B \\ D & Order system & C \\ E & Design new warchouse layout & C \\ F & Design warehouse & E \\ G & Design computer interface & C \\ H & Interface computer & D, F, G \\ I & Install system & D, F \\ J & Train system operators & H \\ K & Test system & I,J \end{tabular} T'inue (twacke) Crashed Activity Time Activity ctivityABCDEFGHIJK(weeks)47287454433Normal1,0001,0001,5002,0005,0003,0008,0005,00010,0004,0005,000Crashed1,9001,8002,7003,2008,0004,10010,2506,40012,4004,4005,500