Read the Stateline Shipping and Transport Company Case Problemon pages 273-274 o

Read the Stateline Shipping and Transport Company Case Problemon pages 273-274 of the text. Analyze this case as follows: 1. InExcel or other suitable program develop a model for shipping thewaste directly from the 6 plants to the 3 waste disposal sites. 2.Solve the model you developed in #1 (above) and clearly describethe results. 3. In Excel or other suitable program Develop atransshipment model in which each of the plants and disposal sitescan be used as intermediate points. 4. Solve the model youdeveloped in #3 (above) and clearly describe the results. 5.Interpret the results and draw conclusions that address thequestion posed in the case problem. What are the limits of thestudy? Write at least one paragraph.