Question: Please solve using Excel Desicions Solver Model. Thank you The Bavarian Motor Company (BMC) manufactures luxury cars in Hamburg, Germany to sell in the United
Please solve using Excel Desicions Solver Model. Thank you

The Bavarian Motor Company (BMC) manufactures luxury cars in Hamburg, Germany to sell in the United States. The exported cars are shipped to ports in Newark, New Jersey, and Jacksonville. From these ports, the cars are transported by rail or truck to distributors in Boston, Columbus, Atlanta, Richmond, and Mobile. The network diagram below shows the possible routes and the transportations cost of shipping each car across the routes. Currently, 200 cars are available at the Port of Newark and 300 are available 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 of Newark and Jacksonville to the cities where they are needed. Create and submit a Solver model for this scenario to minimize this cost. What is the decision? Formulation: 1. Goal: Minimize Cost 2. Decision Variables: Xi,j= the Cars to transport from Node i to Node j 3. Objective Function: MIN:30X1,2+40X1,4+50X2,3+35X3,5+40X5,3+30X5,4+35X5,6+25X6,5 +50X7,4+45X7,5+50X7,6 4. Constraints: Subject To... X1,2X1,4X7,4X7,5X7,6X2,3+X1,2X3,5+X2,3+X5,3+X1,4+X5,4+X7,4X5,3X5,4X5,6+X3,5+X6,5X6,5+X5,6+X7,6200300=100=60=80+X7,5=170=70 5. Xi,j0
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
