(a) How long would it take to recover an invest­ment of $245,000 in enhanced CNC controls that include axis control to eight axes on the milling model, if the associated income is $92,000 per year, expense is $38,000 per year, and the salvage value is estimated to be 15% of the first cost? Use a MARR of 15% per year. (b) Also, write the spreadsheet function that determines np.

What will be an ideal response?


(a) Develop the PW relation and solve for np

-245,000 + (92,000 – 38,000)(P/A,15%,np) + 245,000(0.15)(P/F,15%,np) = 0

Solve by trial and error:
Try n = 7: -245,000 + (92,000 – 38,000)(4.1604) + 36,750(0.3759) = 0
-6524 < 0
Try n = 8: -245,000 + (92,000 – 38,000)(4.4873) + 36,750(0.3269) = 0
+9327 > 0
Therefore, np ? 8 years

(b) Spreadsheet function: = NPER(15%,54000,-245000,0.15*245000) displays 7.4 years

Trades & Technology

You might also like to view...

Specific notes are also called:

a. general notes b. common notes c. local notes d. applied notes

Trades & Technology

Which of the following conditions is likely to result in a shock hazard?

a. Using a grounded extension cord b. Using a cord from which the grounding conductor has been removed c. Connecting a power tool to a GFCI-protected circuit d. Using a grounded plug in a three-prong receptacle

Trades & Technology

All of the following statements are true EXCEPT:

A. shifts can be either too late, with the engine rpm too high, or too early, with the engine lugging. B. a transmission that shifts at the wrong time could be the result of a pressure problem or a sticking valve in the valve body. C. pressure problems can be caused by a leaking modulator, a misadjusted throttle valve cable, or a sticking governor. D. clutch chatter can be caused by a leaking modulator, a misadjusted throttle valve cable, or a sticking governor.

Trades & Technology

A structural CAD technician may be called upon to prepare drawings that provide an overall picture of a job for marketing purposes. What type of drawings would be suitable in presenting this overview?

A. Engineering drawings B. Shop drawings C. Production drawings D. Strategic drawings

Trades & Technology