School - Strayer University
Course - Math 540 Quantitative Methods
Assignment #4 Case Problem - Stateline Shipping and Transport Company
Instructions:
This assignment consists of two models: the transportation and transshipment models. Solver (Excel add-on)should be used to solve the models.
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. 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.
3. Solve the model you developed in #3 (above) and clearly describe the results.
4. Interpret the results and draw onclusions that address the question posed in the case problem. What are the limits of the study? Write at least one paragraph.
There are two documents for this case problem, the Excel spreadsheets and an accompanying written description/explanation.