STATELINE SHIPPING AND TRANSPORT COMPANY1)In Excel or other suitable program dev

STATELINE SHIPPING AND TRANSPORT COMPANY1)In Excel or other suitable program develop a model for shipping the waste directly from the 6 plants to the 3 waste disposal sites.2)Solve the model you developed in #1 (above) and clearly describe the results.3)In Excel or other suitable program Develop a transshipment model in which each of the plants and disposal sites can be used as intermediate points.4)Solve the model you developed in #3 (above) and clearly describe the results5)Interpret the results and draw conclusions that address the question posed in the case problem. What are the limits of the study? Write at least one paragraph.