A construction company wants to determine the optimal replacement policy for the earth mover it owns. The
Question:
A construction company wants to determine the optimal replacement policy for the earth mover it owns. The company has a policy of not keeping an earth mover for more than five years, and has estimated the annual operating costs and trade-in values for earth movers during each of the five years they might be kept as:
Assume that new earth movers currently cost $25,000 and are increasing in cost by 4.5% per year. The company wants to determine when it should plan on replacing its current, 2-year-old earth mover. Use a 5-year planning horizon.
a. Draw the network representation of this problem.
b. Write out the LP formulation of this problem.
c. Solve the problem using Solver. Interpret yoursolution.
Step by Step Answer:
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics
ISBN: 1233
8th Edition
Authors: Cliff T. Ragsdale