I have attached all questions in the excel sheet. Please help in answering questions 3 through 6 in the different sheets. Please let me know if you need any additional information from myself.

1) Transportation costs for Legos are give in the following chart (see right): Distribution centers are across the top row; plants creating legos are in the left column California Texas Florida Minnesota DEMAND (a) How should the legos be shipped to satisfy demand and minimize cost? Provide detailed solution with analysis. (b) Suppose that you consider building a new source to satisfy demand. Choose a location and assign values for shipping to the 4 destinations. Assuming the production levels of this new facility put supply equal to demand in the table above, how should the legos be shipped to minimize costs? Comment on the change in shipping plans from what you found previously. Washington $5.00 $8.00 $17.00 $12.00 30000 New York $15.00 $12.00 $7.00 $12.00 30000 Ohio $12.00 $6.00 $7.00 $5.00 10000 Michigan $11.50 $7.00 $9.00 $4.00 10000 SUPPLY 20000 25000 15000 12500 2) Panini-ville is expecting the opening of a Delicious Sandwich restaurant in its town in 3 weeks. The mayor of Panini-ville wishes to avoid mass chaos in the streets. Therefore, the mayor has decided to restrict the flow of traffic through the town. Some streets will be blocked to one-way, while others will be open in both lanes. Numbers are given in the chart below representing thousands of cars that can travel each road each hours: From 1 1 1 2 2 3 3 4 4 5 To 2 4 3 4 5 6 4 5 6 6 Flow Capacity 3 3 6 2 4 2 3 2 3 6 Reverse Flow Capacity 2 4 3 2 - (a) How many vehicles can travel over each road before maximum flow is obtained? What is the maximal flow? Assume that the flow goes from 1 to 6, where 6 is the location of the new restaurant. (b) Suppose that you (in place of the mayor) can open another road. This road has a flow of 4 thousand cars per hour, and cannot start or end at 6. Assuming this ONE road, where would you place the road in order to increase overall flow the most? Explain briefly. n 3 weeks. The mayor of d to restrict the flow of open in both lanes. ch road each hours: 3) Consider the network given below. Answer the proceeding questions about this network. The weights are given in hours: (a) What is the shortest path from node 1 to node 11? Support your response; report the length of this path as well as the path. (b) Suppose the weight from node 1 to node 5 changes from 3 to 5. The change in weight changes the shortest path from node 1 to node 11. Verify this by reporting the new path with its total weight. Why does the path change? Explain. From 1 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 10 10 11 12 To 2 5 6 3 4 4 7 5 8 6 9 10 11 8 12 9 12 10 11 13 13 13 Distance (in hours) 1 3 11 5 1 2 5 2 14 7 15 12 27 4 12 6 7 5 14 8 5 11 4) Delicious Sandwich has decided on locations to build the new sandwich shops. In the next phase, you are charged with e timeframes as to when the shops can be built. As per most building processes, there are certain events which must happen For example, sandwiches cannot be made until the oven is installed. The oven cannot be installed until the floors are done, and the hood has been installed. The main construction foreman has determined a list of activities, as well as the activities t any activities wishing to be completed. The list is given below: Project to be Completed A B C D E F G H I J K The foreman has also established time estimates (in weeks) for each of the projects that needs to be completed. The inform table below: (a) When is the earliest that we can expect construction to be completed? How about the latest? What is the expected com (Report the answer using a 99.7% significance. Remember 99.7% significance represents +/- 3 standard deviations.) (b) Marketing would like to start promoting the opening of Delicious Sandwiches in Lima in 21 weeks. What is the liklihood will be open by then? Explain your response and show how you arrived at your response. ch shops. In the next phase, you are charged with establishing cesses, there are certain events which must happen before other events. e oven cannot be installed until the floors are done, electricity turned on, termined a list of activities, as well as the activities that must proceed Preceeding Projects to Project listed to the lef A A,B A B,C,D E C,D,F E,F,G D,F A,E,G,I D,F,G,H,J he projects that needs to be completed. The information is found in the Project to be Completed A B C D E F G H I J K d? How about the latest? What is the expected completion date? ance represents +/- 3 standard deviations.) ndwiches in Lima in 21 weeks. What is the liklihood that the new store at your response. Optimistic 1 1.75 0.5 3 2.5 1 3 1 2 1 4 Most Probable 1.5 2.25 1 4 2.75 2 3.5 3 3 1.3 5 Pessimistic 2 3 1.5 5 3.15 3 4.25 5 3.2 1.7 7 5) The city of panini-ville has anticipated the need to construct a road to alleviate the madness surrounding "Delicious Sand outline of the project has been submitted, and is represented in the table below. Each activity is listed horizontally at the to predecessors to each activity are highlighted below the activity at the top (for example, D is preceeded by A). The completio each project are listed on the bottom. Use this information to answer the following questions. A B C D E F G H I J K L 3 3 1 3 2 4 3 4 1 2 2 3 A B C D E F G H I J K L (a) What are the critical events for this project? (b) Which of the activities has the greatest amount of free time; i.e. which is least important to finishing the road project in t constraints? (c ) Assuming that Eddie would like to complete the activities in less than 3 months, does the analysis provide Eddie evidenc be able to complete the project in his timeframe? Provide proof. **(Within your response, specifically state the number of you personally are considering to be in a 3 month period to support your response) madness surrounding "Delicious Sandwich". An h activity is listed horizontally at the top. The e, D is preceeded by A). The completion times for uestions. EVENT TIMES IN WEEKS ortant to finishing the road project in terms of time oes the analysis provide Eddie evidence that he will ponse, specifically state the number of weeks that (6) Delicious Sandwich is expecting that the demand per hour will be around 190 customers. In response to this, they have decided to run 4 cashiers to take and complete orders. Each cashier can handle about 50 customers an hour (yes...they are efficient cashiers!). Based on the analysis given below, what would you recommend for the manager of Delicious Sandwich? Your response will be graded on thoroughness. response to this, they ustomers an hour nd for the manager of