Case Problem: Stateline Shipping and Transport Company Essay

Rachel is considering using separately of the plant and uncivilised disposal sites as mean(a) shipping points. Now, there is a possibility to reduce the merchant marine coat by utilizing alternative routes. For example, as per the apt(p) make up table, cost to transport from Kingsport to Duras is $17. or else of this route, if we transport first from Kingsport to maconnais and consequently from Macon to Duras the cost is only $15 (4 + 11). We have to recalculate the transportation cost considering all possibilities. For this, we be given transportation costs from various plants to plants and sites to sites in inclined MS outgo Spreadsheet.Solve the bewilder you developed in 3 (above) and understandably describe the results. Plants were labeled 1 by dint of 6, counterbalance facilities labeled A through C. Problem was set up in 2 pointednesss Stage 1 = encumbrance from plants to intermediate/ nett location Stage 2 = shipment from intermediate to final location.Object ive function Solver gear solution in MS Excel yielded the following results 19 gun barrel 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 represent = $2,630 Interpret the results and draw conclusions that address the hesitation posed in the case problem. What are the limits of the study? Write at least(prenominal) one paragraph. The results show that Rachel can compose some dollars per week. Rachel can save by using a few routes that concern intermediate points.An example would be 17 bbl of wastes shipped from Selma to Macon to Duras. The cost compendium fails to co nsider the actual physical risks of traffic with potentially hazardous industrial waste if there is spillage. The dropping off and choose up of waste at intermediate sites whitethorn acquire a meter delay, which may impact the risk of the waste becoming a potential hazard. Also, the superfluous handling of the waste associated with loading and set down at intermediate sites may cause increased risk of a problem. rase though Polychem has agreed to handle the wastes at no additional cost, there may be additional risk that has non been evaluated.