At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year 0 is now).

The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years.
(a) Formulate this problem as a shortest-path problem.
(b) Use the algorithm described in Sec. 10.3 to solve this shortestpath problem.
(c) Formulate and solve a spreadsheet model for this problem.

Transcribed Image Text:

$8,000 $18,000 10,000 $31,000 21,000 12,000