Using a spreadsheet, consider the four independent projects outlined below. At 5% per year and a 15?year study period, (a) determine which projects are acceptable, and (b) the value of the annual M&O cost to make any nonacceptable project acceptable with a B/C ratio of at least 1.0. (Note: Utilize a logical IF function somewhere in your analysis.)
 FIGURE 1.png)
(a) Screen image #1: projects M and N are acceptable; O and P are not.
(b) Use Goal Seek to determine maximum M&O costs.
Screen images #2 and #3: O is acceptable if M&O is below $32,465 per year
P is acceptable if M&O is below $32,124 per year
You might also like to view...
One method for specifying a feature of size as a datum feature is by associating the datum feature symbol on a(n) ____________________ line of a feature of size dimension.
What will be an ideal response?
Gas metal arc welding (GMAW) was originally developed as a process for welding _____.? ?
A. steel? B. aluminum? C. pipes? D. wire?
Using a torque converter smaller than stock size could result in ________
A) Slower than normal acceleration B) Reduced fuel economy C) Faster than normal acceleration D) Both B and C
The type of drawing that depicts the weldment that must be fabricated and the pieces to be joined by welding
is the _____. a. section view b. isometric view c. assembly drawing d. welding detail drawing