MAT 540 Assignment 4 Case Problem: Stateline Shipping and Transport Company

Read the “Stateline Shipping and
Transport Company” Case Problem on pages 273-274 of the text. Analyze this
case, as follows:



In Excel, or other suitable program, develop a
model for shipping the waste directly from the 6 plants to the 3 waste disposal
sites.



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.



Solve the model you developed in #3 (above) and
clearly describe the results.



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.



There are two deliverables for this Case
Problem, the Excel spreadsheets and an accompanying written
description/explanation. Please submit both of them electronically via the
dropbox.
Powered by