Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost And Management Accounting

Authors: Colin Drury

9th Edition

1473749050, 978-1473749054

More Books

Students also viewed these Accounting questions