Question: using solver excel with simplex lp A B C D F G H 1 Autos Roma is a car rental company with multiple sites in

using solver excel with simplex lp
using solver excel with simplex lp A B C D F G H
A B C D F G H 1 Autos Roma is a car rental company with multiple sites in the city. You are testing a new "return the car to the place that suits you best" policy to improve 2 customer service. However, this implies that the company has to constantly move around the city to maintain the required levels of vehicle availability. The 3 supply and demand for economy cars and the total cost of moving these vehicles between the sites are shown in the attached table. 4 1 2 3 4 Offer 5 10 A 9 7 5 6 60 7 B 10 9 9 0 8 40 6 4 4 10 65 10 11 Demand 60 50 25 30 165 12 13 a) Find the solution that minimizes the costs of movement through the Solver of Excel. 15 b) What impact would it have on the total cost to ensure that from origin C always sends a car to site 3 as part of the optimal solution? 16 17 c) it is considering adding an additional origin to choose between L1 and L2 The costs associated with L1 are: 8,3,4,7 respectively for 18 destinations 1.2.3 and 4: the offer is 30. The costs associated with 2 are: 5.3.9 and 7 respectively for destinations 1. 2. 3 and 4; the 19 offer is 20. Which of the two, L1 or L2, is better to minimize the cost? 20 21

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!