Use Excel and Front line Solver to solve the following network optimization problem. Shipping Cars. The Bavarian Motor Company (BMC) manufactures expensive luxury cars in Hamburg, Germany, and exports cars to sell in the United States.

Use Excel and Front line Solver to solve the following network optimization problem.
Shipping Cars. The Bavarian Motor Company (BMC) 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, New Jersey and Jacksonville, Florida. From these ports, the cars are transported by rail or truck to distributors located in Boston, Massachusetts; Columbus, Ohio; Atlanta, Georgia; Richmond, Virginia; and Mobile, Alabama. The following figure shows the possible shipping routes available to the company along with the transportation cost for shipping each car along the indicated path.

Currently, 200 cars are available at the port in Newark and 300 in Jacksonville. The numbers of cars needed by the distributors in Boston, Columbus, Atlanta, Richmond, and Mobile are 100, 60, 170, 80, and 70 respectively. BMC wants to determine the least costly way of transporting cars from the ports in Newark and Jacksonville to the cities where they are needed.

Steps

Use Excel and Frontline Solver to build a model for the problem.
Create a tab (“worksheet’) in your Excel file labeled “Answers” and enter your answers in it.

Ensure that your answers are in a format suitable for consumption by decision-makers (it should not take a math professor to understand your answers.)

Write in complete sentences—do not just provide a number.
Submit your Excel file using this file-naming format: OR531-M#-Assignment_Name.xlsx. For example, for Project Number 1 in Module 1, use OR531-M1-Project_Number_1.xlsx.

Last Completed Projects