Question
Sundown Rent-a-Car, a large automobile rental agency operating in the Midwest, is preparing a leasing strategy for the next six months. Sundown leases cars from
Sundown Rent-a-Car, a large automobile rental agency operating in the Midwest, is preparing a leasing strategy for the next six months. Sundown leases cars from an automobile manufacturer and then rents them to the public on a daily basis. A forecast of the demand for Sundown's cars in the next six months follows:
March | April | May | June | July | August |
420 | 400 | 430 | 460 | 470 | 440 |
Cars may be leased from the manufacturer for either three, four, or five months.
These are leased on the first day of the month and are returned on the last day of the month. Every six months the automobile manufacturer is notified by Sundown about the number of cars needed during the next six months.
The automobile manufacturer has stipulated that at least 50% of the cars leased during a six-month period must be on the five-month lease.
The cost per month is $420 for the three-month lease
The cost per month is $400 for the four-month lease
The cost per month is $370 for the five-month lease.
Sundown has 390 cars.
The lease on 120 cars expires at the end of March.
The lease on another 140 cars expires at the end of April,
The lease on another 130 cars expires at the end of May.
Use LP to determine how many cars should be leased in each month on each type of lease to minimize the cost of leasing over the six-month period.
How many cars are left at the end of August?
Let Xij = number of new leases in month ifor j-months, i = 1, . . . , 6; j = 3, 4, 5
Minimize cost = 1260X13 + 1260X23 + 1260X33 + 1260X43 + 840X53 + 420X63 + 1600X14 + 1600X24 + 1600X34 + 1200X44 + 800X54 + 400X64+ 1850X15 + 1850X25 + 1480X35 + 1110X45 + 740X55 + 370X65
Note: X13 is a designation for the 1 month of cars leased for 3 months; X23is 2nd month and so on. The $1260 = total cost for 3 month lease(420*3).
subject to: X13 + X14 + X15 420 390
X13 + X14 + X15 + X23 + X24 + X25 400 270
X13 + X14 + X15 + X23 + X24 + X25 + X33 + X34 + X35 430 130
X14 + X15 + X23 + X24 + X25 + X33 + X34 + X35 + X43+ X44 + X45 460
X15 + X24 + X25 + X33 + X34 + X35 + X43 + X44 + X45+ X53 + X54 + X55 470
X25 + X34 + X35 + X43 + X44 + X45 + X53 + X54 + X55+ X63 + X64 + X65 440
X15 + X25 + X35 + X45 + X55 + X65 0.50(X13 + X14+ X15 + X23 + X24 + X25 + X33 + X34 + X35 + X43 + X44+ X45 + X53 + X54 + X55 + X63 + X64 + X65)
All variables 0
Solving this on the computer results in the following solution:
X15 = 30 5-month leases in March
X25 = 100 5-month leases in April
X35 = 170 5-month leases in May
X45 = 160 5-month leases in June
X55 = 10 5-month leases in July
All other variables equal 0.
Total cost = $677,100.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started