Problem Set 9.docx - Problem Set 8 1 The Axis car rental...

This preview shows page 1 - 2 out of 6 pages.

Problem Set 81.The Axis car rental company allows its customers to pick up a rental car at one location andreturn it to any of its locations. Currently, two locations (1 and 2) have 16 and 18 surplus cars,respectively, and four locations (3, 4, 5, and 6) each need 10 cars. The costs of getting the surpluscars from locations 1 and 2 to the other locations are summarized in the following table. Costs of Transporting Cars Between LocationsLocation 3Location 4Location 5Location 6Location 1$54$17$23$30Location 2$24$18$19$31Because 34 surplus cars are available at locations 1 and 2, and 40 cars are needed at locations 3, 4, 5,and 6, some locations will not receive as many cars as they need. However, management wants tomake sure that all the surplus cars are sent where they are needed, and that each location needing carsreceives at least five. Develop a spreadsheet model for this problem and solve it using Solver. Location 3Location 4Location 5Location 6Location154172330Location224181931at most10101010at least5555Location 3Location 4Location 5Location 6sumLocation1050516Location2505018Total min caost450s.t.10<=1610<=185<=105<=105<=105<=105>=55>=55>=55>=5

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture