A company that manufactures high-speed submersiblerotary-indexing spindles is consideringan upgrade of production equipment to reducecosts over the next 5 years. The company can invest$80,000 now, 1 year from now, or 2 yearsfrom now. Depending on when the investment ismade, the savings will vary. The saving estimatesare $26,000, $31,000, or $37,000 per year if theinvestment is made now, 1 year from now, or 2years from now, respectively. The company willonly invest if the ROR is at least 20% per year. Using a future worth analysis, determine if thetiming of the investment will affect the return requirementand, if so, when the investment shouldbe made. Solve by (a) hand, and (b) spreadsheet.

ENGR 121 B Lecture Notes for 10/31/2016 Spencer Kociba ● Calculating Standard Deviation ○ u=mean, N=number of elements in a vector N ○ SD= 1 * ∑(x(i) − u) √ N−1 k=1 ■ Take each element, subtract the mean and square it. Repeat this for all the elements in the vector and sum them. Divide by N-1 and take the square root ○ Function this_std=standard_deviation(vec) ○ Part 1 (calculating the mean) ■ sum=0 ■ For i=1:length(vec) ● sum=sum+vec(i) ■ End ■ this_mean=sum/length(vec) ○ Part 2 (calculation of SD) ■ For i=1:len