Use linear programming, a spreadsheet, and the Solver tool to select from the independent, unequal-life projects in Problem 12.18.
Problem 12.18
The independent project estimates below have been developed by the engineering and finance managers at Golphanen Enterprises. The corporate MARR is 8% per year, and the capital investment limit set by the CFO is $4 million. As a new employee in the Engineering Department, you have been asked to recommend the economically best projects. Use (a) hand solution, and (b) spreadsheet solution to determine your recommendation.
 FIGURE 1.png)
Use the Figure 12-5 template at 8% with an investment limit of $4 million.
Select projects 1 and 4 with $3.5 million invested and Z ? $1.285 million.
 ANSWER.png)
You might also like to view...
?Technician A says high current is caused by high resistance. Technician B says a short to ground can occur internally within a component. Who is correct?
A. ?A only B. ?B only C. ?Both A and B D. ?Neither A nor B
On a dynamometer, horsepower is calculated by which of these formulae?
A) Stroke × bore × 3300 B) Stroke × bore × 55 C) Torque × RPM ÷ 5252 D) Torque × RPM
Commercial refrigeration systems normally have:
A) A suction service valve and a discharge service valve. B) A suction service valve, discharge service valve, and a king valve. C) A liquid line valve and a suction service valve. D) Most commercial refrigeration systems do not have refrigeration service valves.
Water will evaporate at a slower rate when:
A) The temperature of the water is below the point of vaporization. B) The relative humidity is high C) The ambient air around it is at a low relative humidity. D) The dew point is equal to barometric pressure.