Question: Solve me this problem Introduction to Management Science textbook from Bernard W . Taylor. By following this six steps The introduction should just present the

Solve me this problem Introduction to Management Science textbook from Bernard W.Taylor. By following this six steps The introduction should just present the problem, and you should present your objective
qualitatively (question 2) and mathematically (question 3). In question 4, show the
transportation tableau and solve the problem (either with Excels solver or the manual method).
In question 5, produce your own, additional, risk analysis and use it to perform a sensitivity
analysis of your results in question 6. Suntrek, based in China, is a global supplier of denim jeans for apparel companies around the world. They purchase raw cotton from producers in Arkansas, Mississippi, and Texas, where it is picked, ginned, and baled and then transported by flatbed trucks to ports in Houston, New Orleans, Savannah, and Charleston, where it is loaded into 80-foot containers and shipped to factories overseas. For the coming year Suntrek has contracted with its U.S. broker for 71,000(550 lb.) bales of cotton and the transportation and handling costs from each cotton-processing facility to each port, and the container capacity (in bales) at each port are as follows:
\table[[Cotton Farms,Ports,\table[[Supply],[(bales)]]],[Houston,Savannah,New Orleans,Charleston],[Arkansas,$18,$23,$15,$23,31,000],[Mississippi,26,19,14,27,45,000],[Texas,14,29,21,32,27,000],[Demand (bales),26,000,19,000,14,000,12,000,]]
Determine the optimal shipments from each processing facility to each port that will result in the minimum shipping cost.
 Solve me this problem Introduction to Management Science textbook from Bernard

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!