Tesla has Model X and Model Y inventory and demand across different cities in the U.S....

 

Transcribed Image Text:

Tesla has Model X and Model Y inventory and demand across different cities in the U.S. These vehicles need to be transported by rail to meet the demand for Tesla distributors in the cities summarized in the following table. Note that a negative number in the table below means the supply of vehicles a city can ship out. For example, Columbus has 300 Model X that can be shipped to meet the demand in other cities. City Newark Boston Columbus Richmond Atlanta Mobile Jacksonville Vehicles Needed Model X 100 200 -300 200 0 -400 100 Model Y -200 100 -200 -500 200 0 150 Tesla rents rail cars to move its inventory of vehicles between these cities. Each rail car can hold up to 12 vehicles and are readily available in any quantity needed. The cost of renting a rail car and having it moved among these cities is summarized in the figure below. Tesla is looking for a transportation plan to minimize its cost to meet the demand. Please construct a spreadsheet model and solve it. What is the total cost of the optimal plan you find? You do NOT need to provide a mathematical formulation. Columbus 3 $930 $900 $910 Mobile 6 $980 Atlanta 5 Boston 2 $980 $860 $1110 $1220 $1080 $1020 Newark 1 Richmond 4 $720 $990 J'ville 7 Tesla has Model X and Model Y inventory and demand across different cities in the U.S. These vehicles need to be transported by rail to meet the demand for Tesla distributors in the cities summarized in the following table. Note that a negative number in the table below means the supply of vehicles a city can ship out. For example, Columbus has 300 Model X that can be shipped to meet the demand in other cities. City Newark Boston Columbus Richmond Atlanta Mobile Jacksonville Vehicles Needed Model X 100 200 -300 200 0 -400 100 Model Y -200 100 -200 -500 200 0 150 Tesla rents rail cars to move its inventory of vehicles between these cities. Each rail car can hold up to 12 vehicles and are readily available in any quantity needed. The cost of renting a rail car and having it moved among these cities is summarized in the figure below. Tesla is looking for a transportation plan to minimize its cost to meet the demand. Please construct a spreadsheet model and solve it. What is the total cost of the optimal plan you find? You do NOT need to provide a mathematical formulation. Columbus 3 $930 $900 $910 Mobile 6 $980 Atlanta 5 Boston 2 $980 $860 $1110 $1220 $1080 $1020 Newark 1 Richmond 4 $720 $990 J'ville 7

Answer rating: 100% (QA)

Following is the spreadsheet model and solution for the above problem Model Decision Variables xijnu... View the full answer