The chief engineer at Clean Water Engineering has established a capital investment limit of $710,000 for next year for projects related to concentrate management. (a) Select any or all of the following independent projects, using a MARR of 10% per year. (b) Use a spreadsheet to determine the minimum annual NCF necessary to select any of the other viable bundles besides the one selected in part (a).
 FIGURE 1.png)
 figure 3.png)
(b) Develop the spreadsheet so that the annual NCF values can be adjusted using Goal Seek. Functions are shown below.
 FIGURE 4.png)
Repeatedly apply Goal Seek to find NCF values that force the PW values to equal that of bundle 4, namely PW3 = $119,736, per the spreadsheet PW value for bundle 3. The spreadsheet for bundle 1 (project A) is shown below. NCF values for all bundles resulting from Goal Seek applications are as follows:
NCFA = $72,243 compared to the estimated $50,000
NCFB = $134,569 compared to the estimated $90,000
NCFAB = $169,039 compared to the estimated $140,000
 ANSWER.png)
You might also like to view...
Technician A says by using selective thrust washers, end play is often corrected. Technician B says by using selective snap rings, end play is often corrected. Who is correct?
A. A only B. B only C. Both A and B D. Neither A nor B
Which description best fits the role of a service advisor?
A) A beginning technician B) A customer service representative C) A skilled technician D) A money manager
Which statement concerning fast-packet multiplexing is not true?
A) it operates on the premise that circuits may be oversubscribed in the same way that stadium seats are oversold, with the understanding that not every subscriber user will be on line at the same time B) it is much more efficient than TDM or FDM C) it is a method used to transmit information D) none of the above (all are true)
Find V1, V2, and V3 in the circuit shown below.
