A major equipment purchase is being economically evaluated by a team of three design engineers and one production engineer at Raytheon Aerospace. The agreed-upon estimates are P = $560,000, n = 6 years, and S = $100,000. The group disagrees, however, on the estimated annual net savings the equipment will generate. Estimates are summarized below. (a) Use PW analysis and a spreadsheet to identify which estimates, if any, indicate that the equipment is economically justified at a MARR of 8% per year. (b) For any estimate(s) indicating that the purchase is not justified, determine the breakeven number of years for the purchase to be justified.
(a) The first three estimates indicate that the equipment should be purchased; Mehmet’s
does not (PW = $-34,695)
(b) Use Goal Seek to change the life (cell B5) from 6 to 6.64 years so that PW = 0 (cell E5)
You might also like to view...
In order to specify different values of metric base units of measure, a set of ____________________ is used.
Fill in the blank(s) with the appropriate word(s).
What is the difference between a primary product, a byproduct, and a coproduct?
What will be an ideal response?
If the pupa is not removed from the cocoon, it dies shortly after producing its first batch of silk
Indicate whether the statement is true or false
The circuit power factor and the____________________ are determined by the resistance and the capacitive reactance that is not canceled by the inductive reactance.
Fill in the blank(s) with the appropriate word(s).