MAT 540 QuantitativeMethodsWeek10
MAT 540 QuantitativeMethodsWeek10
Popular in Course
verified elite notetaker
Popular in Department
This 0 page Study Guide was uploaded by tophomework Notetaker on Sunday November 15, 2015. The Study Guide belongs to a course at a university taught by a professor in Fall. Since its upload, it has received 14 views.
Reviews for MAT 540 QuantitativeMethodsWeek10
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 11/15/15
MAT 540 Quantitative Methods Week 10 Assignment 4 Stateline Shipping and Transport Company Case Problem 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 Stateline Shipping Initial Setup Kingsport Danville Macon Selma Columbus Allentown DEMAND 2 Solve the model you developed in 1 above and clearly describe the results Stateline Shipping Optimal Solution Optimal solution value 2822 Los Kingsport Danville Macon Selma Columbus Allentown Dummy The above table shows the optimal solution when Stateline ships directly from the plants to the disposal sites The table re ects the following a 35 bbl from Kingsport 1 bbl from Selma and 29 bbl from Columbus should be shipped directly to the Whitewater waste disposal site each week b 52 bbl from Selma and 28 bbl from Allentown should be shipped directly to the Los Canos waste disposal site each week c 26 bbl from Danville 42 bbl from Macon and 10 bbl from Allentown should be shipped directly to the Duras waste disposal site each week d The minimum cost to make these shipments from the plants directly to the waste disposal sites is 282200 per week 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 Stateline Shipping Transshipment Initial Setup Allentown White Kingsport I Danville Macon Selma Columbus Allentown Whitewater Los Canos Duras DEMAND 4 Solve the model you developed in 3 above and clearly describe the results Stateline Shipping Transshipment Optimal Solution ggggal SOIUtlon value Kingsport Danville Macon Selma Columbus Allentown White Kingsport 250 16 19 Danville 196 Macon 214 Selma 17 250 36 Columbus 214 Allentown 38 250 Whitewater Los Canos Duras Dummy The above table shows the optimal solution when Stateline uses intermediate points in their shipping note the highlighted cells re ect amounts shipped back to itself which actually does not get shipped The table re ects the following a The Kingsport plant should ship 16 bbl to the DanVille plant and 19 bbl to the Macon plant b The DanVille plant should ship 80 bbl directly to the Los Canos disposal site c The Macon plant should ship 78 bbl directly to the Duras disposal site d The Selma plant should ship 17 bbl to the Macon plant and 36 bbl to the Columbus plant e The Columbus plant should ship 65 bbl directly to the Whitewater disposal site f The Allentown plant should ship 38 bbl to the DanVille plant g The Whitewater Los Canos and Duras disposal sites would not ship to any other sites or plants h By using the above transshipment procedure the optimal minimum cost would be 263000 per week 5 Interpret the results and draw conclusions that address the question posted in the case problem What are the limits of the study Write at least one paragraph If Stateline Shipping and Transport uses the original transportation model their weekly transportation cost will be 2822 If Stateline decides to use intermediate points the optimal minimum cost per week would be 2630 One limitation of the study is that we failed to address the dangers of transporting industrial wastes and the increased risks of using the intermediate points This study also fails to consider the time required to transport waste from one point to another Lastly the study fails to recognize that many towns and cities prohibit the transport of hazardous wastes through their limits therefore alternate routes would need to be deVised which could increase costs
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'