The Rent-a-dent car rentalcompany allows its customers to pick up a rental car a
ID: 2938451 • Letter: T
Question
The Rent-a-dent car rentalcompany allows its customers to pick up a rental car at onelocation and return it to any of its locations. Currently 2locations(1,2) have 16 and 18 surplus cars and fourlocations(3,4,5,6) each need 10 cars. The cost of getting thesurplus cars from locations 1 and 2 to the other locations aresummarized in the following table.
location3 location4 location5 location6
Location1 $54 $17 $23 $30
location2 $24 $18 $19 $31
Because 34 surplus cars are available at locations 1 and 2 and 40cars are needed at locations 3,4,5 and 6, some locations will notreceive as many cars as they need. However, management wants tomake sure that all the surplus cars are sent where they are needed,and each location needing cars receives at least 5.
a. Formulate an LPmodel for this problem
b. Create a spreadsheet model for this problem and solve itusing Solver
c. What is the optimal solution
Show all work and allconstraints must be posted as well.
Explanation / Answer
54
17
23
30
16
location2
24
18
19
31
18
dummy loc
0
0
0
0
6
location3 location4 location5 location6 avail location154
17
23
30
16
location2
24
18
19
31
18
dummy loc
0
0
0
0
6
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.