Problem # 3: Transshipment Problem The Bavarian Motor Company (BMC-NA) manufactures expensive luxury cars in Hamburg. Ge

[answerhappygod]

Problem 3 Transshipment Problem The Bavarian Motor Company Bmc Na Manufactures Expensive Luxury Cars In Hamburg Ge 1 (33.26 KiB) Viewed 66 times

Problem # 3: Transshipment Problem The Bavarian Motor Company (BMC-NA) manufactures expensive luxury cars in Hamburg. Germany, and exports cars to sell in the United States. The exported cars are shipped from Hamburg to ports in Newark, NJ and Jacksonville, FL From these ports the cars are transported by rail or truck to distributors located in Boston, MA, Columbus, OH, Atlanta, GA, Richmond, VA, Mobile, AL, and Memphis, TN. The figure below shows the possible shipping routes available to the company along with the transportation cost for shipping each car along the indicated path. Each location is termed as a node and numbered for convenience in defining decision variables. $30 B Memphis $35 $30 Columbus $35 $25 550 9 Atlama S 2 530 $45 (1. Extent Newark 1 540 $50 $40 $35 Mobile 7 $50 Note that Newark and Jacksonville are supply nodes (only supplies). Richmond is a demand node (can only receive) Boston, Columbus, Atlanta, Mobile, and Memphis are transshipment nodes (can both receive and supply while ensuring their requirements). Currently, 250 cars are available at the port in Newark and 320 are available in Jacksonville The number of cars needed by the distributors in Boston, Columbus, Atlanta, Richmond, Mobile, and Memphis are 100, 60, 170, 80, 70, and 50 respectively. BMC would like to determine the least costly way of transporting cars from the ports in Newark and Jacksonville to the cities where they are needed. You should not pre-determine any routes (using any calculations) as you write the mathematical formulation and solve it using Excel Solver