Case Problem: Stateline Shipping and Transport Company Essay

Rachel is considering using to each one of the plant and boast disposal sites as mediate shipping points. Now, at that place is a possibility to boil down the transportation coat by utilizing alternative routes. For drill, as per the habituated follow table, cost to transport from Kingsport to Duras is $17. or else of this route, if we transport first from Kingsport to maconnais and then from Macon to Duras the cost is only $15 (4 + 11). We have to work out the transportation cost considering all possibilities. For this, we are given transportation costs from various plants to plants and sites to sites in link MS leap out Spreadsheet.Solve the model you genuine in 3 (above) and clearly describe the results. Plants were labeled 1 through 6, have facilities labeled A through C. Problem was set up in 2 Stages Stage 1 = onus from plants to middling/final location Stage 2 = shipment from liaise to final location.Objective function convergent thinker add-on solution in M S Excel yielded the following results 19 cask of wastes shipped from Kingsport to Macon to Duras, 16 bbl of wastes shipped from Kingsport to Los Canos, 26 bbl of wastes shipped from Danville to Los Canos, 42 bbl of wastes shipped from Macon to Duras,17 bbl of wastes shipped from Selma to Macon to Duras, 36 bbl of wastes shipped from Selma to capital of Ohio to Whitewater, 29 bbl of wastes shipped from Columbus to Whitewater, 38 bbl of wastes shipped from Allentown to Danville to Los Canos. Total Cost = $2,630 scan 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. The results show that Rachel can fulfil some dollars per week. Rachel can save by using a few routes that involve intermediate points.An example would be17 bbl of wastes shipped from Selma to Macon to Duras. The cost analysis fails to consider the actual physical risks of relations with potentially hazardous industrial was te if there is spillage. The dropping off and picking up of waste at intermediate sites may cause a time delay, which may impact the risk of the waste becoming a potential hazard. Also, the additional treatment of the waste associated with loading and unloading at intermediate sites may cause increased risk of a problem. Even though Polychem has agreed to handle the wastes at no additional cost, there may be additional risk that has not been evaluated.