MAT 540 Assignment 4 Stateline Shipping and Transport Company Answer

MAT 540 Assignment 4 Stateline Shipping and Transport Company Answer

MAT 540 Assignment 4 Stateline Shipping and Transport Company Answer

MAT 540 Assignment 4 Stateline Shipping and Transport Company Answer

MAT 540 Assignment 4 Stateline Shipping and Transport Company Answer

MAT 540 Assignment 4 Stateline Shipping and Transport Company Answer

Read the “Stateline Shipping and Transport Company” Case Problem on pages 273-274 of the text. Analyze this case, as follows:
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.

In Excel, or Other Suitable Program, Develop a Model for Shipping the Waste
Directly from the 6 Plants to the 3 Waste Disposal Sites
The Stateline Shipping and Transport Company wanted to transport chemical wastes from the six plants to the three waste disposal sites. The six pants and their capacity for wastes generated are shown below. Also shown are the three waste disposal sites and their demand requirements.
Plants Supply (barrels)
1. Kingsport 35
2. Danville 26
3. Macon 42
4. Selma 53
5. Columbus 29
6. Allentown 38

Waste Disposal Sites Demand (barrels)
A. Whitewater 65
B. Los Canos 80
C. Duras 105

Shown below are the shipping costs ($/bbl) from each waste disposal site to each plants.
Plants Waste Disposal Sites
A. Whitewater B. Los Canos C. Duras
1. Kingsport $12 $15 $17
2. Danville 14 9 10
3. Macon 13 20 11
4. Selma 17 16 19
5. Columbus 7 14 12
6. Allentown 22 16 18

Cite your sources according to APA requirements.

For getting the instant digital download solution, Please click on the “PURCHASE” link below to get MAT 540 Assignment 4 Stateline Shipping and Transport Company Answer

For instant digital download of the above solution or tutorial, please click on the below link and make an instant purchase. You will be guided to the PAYPAL Standard payment page wherein you can pay and you will receive an email immediately with a download link.

In case you find any problem in getting the download link or downloading the tutorial, please send us an email on mail@bizcourseqa.com

MAT 540 Assignment 4 Stateline Shipping and Transport Company