How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask R.R. Jha Your Own Question

R.R. Jha
R.R. Jha, Bachelor's Degree
Category: Calculus and Above
Satisfied Customers: 5362
Experience:  Math Expert
Type Your Calculus and Above Question Here...
R.R. Jha is online now
A new question is answered every 9 seconds

Case Problem for MAT 540 Quantitative Methods Due March 9

Customer Question

Stateline Shipping and Transport Company


Rachel Sundusky is the manager of the South-Atlantic office of the Stateline Shipping and Transport Company. She is in the process of negotiating a new shipping contract with Polychem, a company that manufactures chemicals for industrial use. Polychem want Stateline to pick up and transport waste products from its six plants to three waste disposal sites. Rachel is very concerned about this proposed arrangement. The chemical wastes that will be hauled can be hazardous to humans and the environment if they leak. In addition, a number of towns and communities in the region where the plants are located prohibit hazardous materials from being shipped through their municipal limits. Thus, not only will the shipments have to be handled carefully and transported at reduced speeds, they will also have to traverse circuitous routes in many cases. Rachel has estimated the cost of shipping a barrel of waste from each of the six plants to each of the three waste disposal sites as shown in the following table:


 



















































                                                                       Waste Disposal Site



Plant



Whitewater



Los Canos



Duras



Kingsport



$12



$15



$17



Danville



14



9



10



Macon



13



20



11



Selma



17



16



19



Columbus



7



14



12



Allentown



22



16



18



 


The plants generate the following amounts of waste products each week:


 


































Plant



Waste per Week (bbl)



Kingsport



35



Danville



26



Macon



42



Selma



53



Columbus



29



Allentown



38



 


The three waste disposal sites at Whitewater, Los Canos, and Duras can accommodate a maximum of 65, 80, and 105 barrels per week respectively. In addition to shipping directly from each of the six plants to one of the three waste disposal sites, Rachel is also considering using each of the plants and waste disposal sites as intermediate shipping points. Trucks would be able to drop a load at a plant or disposal site to be picked up and carried on to the final destination by another truck, and vice versa. Stateline would not incur any handling costs because Polychem has agreed to take care of all local handling of the waste materials at the plants and the waste disposal sites. In other words, the only cost Stateline incurs is the actual transportation cost. So Rachel wants to be able to consider the possibility that it may be cheaper to drop and pick up loads at intermediate points rather than ship them directly. Rachel estimates the shipping costs per barrel between each of the six plants to be as follows:


 


 








































































 


Plant



Plant



Kingsport



Danville



Macon



Selma



Columbus



Allentown



Kingsport



$  __



$6



$4



$9



$7



$8



Danville



6



__



11



10



12



7



Macon



5



11



__



3



7



15



Selma



9



10



3



__



3



16



Columbus



7



12



7



3



__



14



Allentown



8



7



15



16



14



__



 


The estimated shipping cost per barrel between each of the three waste disposal sites is as follows:


 

































 


Waste Disposal Site



Waste Disposal Site



Whitewater



Los Canos



Duras



Whitewater



$__



$12



$10



Los Canos



12



__



15



Duras



10



15



__



 


Rachel wants to determine the shipping routes that will minimize Stateline’s total cost in order to develop a contract proposal to submit to Polychem for waste disposal. She particularly wants to know if it would be cheaper to ship directly from the plants to the waste sites or if she should drop and pick up some loads at the various plants and waste sites. Develop a model to assist Rachel and solve the model to determine the optimal routes.


 


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. 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. 

  3. Solve the model you developed in #3 (above) and clearly describe the results.

  4. 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.


 


There are two deliverables for this Case Problem, the Excel spreadsheets and an accompanying written description/explanation. Please submit both of them electronically via the drop box.


 


Attachment: 2012-03-06_082320_rachel_sundusky_is_the_manager_of_the_south.docx


Submitted: 2 years ago.
Category: Calculus and Above
Expert:  Josie-Mod replied 2 years ago.

Hi, I'm a moderator for this topic and I wonder whether you're still waiting for an answer. If you are, please let me know and I will do my best to find an Expert to assist you right away. If not, feel free to let me know and I will cancel this question for you. Thank you!

Customer: replied 2 years ago.
Hi,

I still need an answer please.
Expert:  Josie-Mod replied 2 years ago.

Sometimes, finding the right Expert can take a little longer than expected and we thank you greatly for your understanding. We'll be in touch again shortly.

Customer: replied 2 years ago.
ok thank you.
Expert:  R.R. Jha replied 2 years ago.
Hi,

I could help with this, if you still need it. Let me know.


Thanks
Customer: replied 2 years ago.
Yes please. Thank you.
Expert:  R.R. Jha replied 2 years ago.
Please download the answer below

stateline shipping

All set, please hit Accept.

Thanks
R.R. Jha, Bachelor's Degree
Satisfied Customers: 5362
Experience: Math Expert
R.R. Jha and 2 other Calculus and Above Specialists are ready to help you
Customer: replied 2 years ago.
thank you.
Expert:  R.R. Jha replied 2 years ago.
Glad to help

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
  • He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX
 
 
 

Meet The Experts:

 
 
 
  • Mr. Gregory White's Avatar

    Mr. Gregory White

    Master's Degree

    Satisfied Customers:

    90
    M.A., M.S. Education / Educational Administration
< Last | Next >
  • http://ww2.justanswer.com/uploads/ED/educatortech/2012-6-7_1256_williams4.64x64.jpg Mr. Gregory White's Avatar

    Mr. Gregory White

    Master's Degree

    Satisfied Customers:

    90
    M.A., M.S. Education / Educational Administration
  • http://ww2.justanswer.com/uploads/homeworklady/2008-11-24_125231_susannewavatar.jpg SusanAthena's Avatar

    SusanAthena

    Master's Degree

    Satisfied Customers:

    86
    Tutor for Algebra, Geometry, Statistics. Explaining math in plain English.
  • http://ww2.justanswer.com/uploads/SO/sonofGauss/2012-6-6_20151_PortraitLHW.64x64.jpg JACUSTOMER-yrynbdjl-'s Avatar

    JACUSTOMER-yrynbdjl-

    Master's Degree

    Satisfied Customers:

    42
    I have a MS in Mathematics and I have taught Mathematics for 10 years at the college level.
  • http://ww2.justanswer.com/uploads/dhouse1940/2010-09-02_133023_DSCN2406.jpg dhouse1940's Avatar

    dhouse1940

    Master's Degree

    Satisfied Customers:

    33
    BS mathematics, MS biostatistics, 35+ yrs designing & analyzing biological experiments.
  • http://ww2.justanswer.com/uploads/CO/CosumelEyes/2012-5-4_4923_Profile.64x64.jpg Ray Atkinson's Avatar

    Ray Atkinson

    Bachelor's Degree

    Satisfied Customers:

    30
    Degrees in Math, Education and Accounting, years and years of tutoring.
  • http://ww2.justanswer.com/uploads/DO/Donbacongamer/2012-3-6_2337_mathmaster.64x64.jpg Don's Avatar

    Don

    Master's Degree

    Satisfied Customers:

    29
    M.S. Astronautical Engineering. Math/Sci/Comp Tutor
  • http://ww2.justanswer.com/uploads/AR/arubin9/2012-2-4_42617_ArthurRubinedit.64x64.jpg Dr Arthur Rubin's Avatar

    Dr Arthur Rubin

    Doctoral Degree

    Satisfied Customers:

    26
    Ph.D. in Mathematics, 1978, from the California Institute of Technology, over 20 published papers