I excel or other suitable program develop a model for

Question

Case Study: Stateline Shipping and Transport Company

Requirement

1. 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 results.

5. 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.

Answer 1

Review the case study named - Stateline Shipping and Transport Company and as per requisite answers the following questions. Q1. In Excel sheet, or other appropriate program, build up a model for shipping the waste directly from the 6 plants to the 3 waste disposal sites. Q2. Resolve the model you build up in (1) (above) and clearly illustrate the results. Q3. By using Excel sheet, or other appropriate program, build up a transshipment model in which each of the plants and disposal sites can be employed as intermediate points. Q4. Resolve the model you build up in (3) (above) and clearly illustrate the results. Q5. Interpret the outcomes and draw conclusions which address the question posed in the case problem. Determine the limits of the study? Write at a minimum of one paragraph.