Now Accepting Apple Pay

Apple Pay is the easiest and most secure way to pay on StudyMoose in Safari.

Case Problem: Stateline Shipping and Transport Company

Categories: Transport

Rachel is considering using each of the plant and waste disposal sites as intermediate shipping points. Now, there is a possibility to reduce the transportation coat by utilizing alternative routes. For example, as per the given cost table, cost to transport from Kingsport to Duras is $17. Instead of this route, if we transport first from Kingsport to Macon and then from Macon to Duras the cost is only $15 (4 + 11). We have to recalculate the transportation cost considering all possibilities. For this, we are given transportation costs from various plants to plants and sites to sites in attached MS Excel Spreadsheet.

Solve the model you developed in #3 (above) and clearly describe the results. Plants were labeled 1 through 6, waste facilities labeled A through C. Problem was set up in 2 Stages: Stage 1 = shipment from plants to intermediate/final location; Stage 2 = shipment from intermediate to final location.

Objective function: Solver add-on solution in MS Excel yielded the following results: 19 bbl 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 Columbus to Whitewater, 29 bbl of wastes shipped from Columbus to Whitewater, 38 bbl of wastes shipped from Allentown to Danville to Los Canos.

Get quality help now
Prof. Finch
Verified writer

Proficient in: Transport

4.7 (346)

“ This writer never make an mistake for me always deliver long before due date. Am telling you man this writer is absolutely the best. ”

+84 relevant experts are online
Hire writer

Total Cost = $2,630 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.

Get to Know The Price Estimate For Your Paper
Topic
Number of pages
Email Invalid email

By clicking “Check Writers’ Offers”, you agree to our terms of service and privacy policy. We’ll occasionally send you promo and account related email

"You must agree to out terms of services and privacy policy"
Check writers' offers

You won’t be charged yet!

The results show that Rachel can save some dollars per week. Rachel can save by using a few routes that involve intermediate points.

An example would be 17 bbl of wastes shipped from Selma to Macon to Duras. The cost analysis fails to consider the actual physical risks of dealing with potentially hazardous industrial waste 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 handling 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.

Cite this page

Case Problem: Stateline Shipping and Transport Company. (2016, Jul 23). Retrieved from https://studymoose.com/case-problem-stateline-shipping-and-transport-company-essay

Case Problem: Stateline Shipping and Transport Company

👋 Hi! I’m your smart assistant Amy!

Don’t know where to start? Type your requirements and I’ll connect you to an academic expert within 3 minutes.

get help with your assignment