Solve it By 2 methods 1) Use the Formulas, and 2) Use the INTEREST TABLE

CASE STUDY ROR ANALYSIS WITH ESTIMATED LIVES THAT VARY Background The life estimates were developed by two different individuals: a design engineer and a manufacturing manager. They have Make-to-Specs is a software system under development by asked that, at this stage of the project, all analyses be performed ABC Corporation. It will be able to translate digital versions of using both life estimates for each system. three-dimensional computer models, containing a wide variety of part shapes with machined and highly finished (ultra- Case Study Exercises smooth) surfaces. The product of the system is the numerically controlled (NC) machine code for the part's manufacturing Use spreadsheet analysis to determine the following: Additionally, Make-to-Specs will build the code for superfine 1. If the MARR = 12%, which server should be selected? finishing of surfaces with continuous control of the finishing Use the PW or AW method to make the selection. machines. 2. Use incremental ROR analysis to decide between the servers at MARR = 12%. Information 3. Use any method of economic analysis to display on the spreadsheet the value of the incremental ROR between There are two alternative computers that can provide the server function for the software interfaces and shared da- server 2 with a life estimate of 5 years and a life estimate tabase updates on the manufacturing floor while Make-to- of 8 years. Specs is operating in parallel mode. The server first cost and estimated contribution to annual net cash flow are summarized below. First cost, $ Net cash flow, $/year Server 1 100,000 35,000 Server 2 200,000 50,000 year 1, plus 5000 per year for years 2, 3, and 4 (gradient) 70,000 maximum for years 5 on, even if the server is replaced Life, years 3 or 4 5 or 8 CASE STUDY ROR ANALYSIS WITH ESTIMATED LIVES THAT VARY Background The life estimates were developed by two different individuals: a design engineer and a manufacturing manager. They have Make-to-Specs is a software system under development by asked that, at this stage of the project, all analyses be performed ABC Corporation. It will be able to translate digital versions of using both life estimates for each system. three-dimensional computer models, containing a wide variety of part shapes with machined and highly finished (ultra- Case Study Exercises smooth) surfaces. The product of the system is the numerically controlled (NC) machine code for the part's manufacturing Use spreadsheet analysis to determine the following: Additionally, Make-to-Specs will build the code for superfine 1. If the MARR = 12%, which server should be selected? finishing of surfaces with continuous control of the finishing Use the PW or AW method to make the selection. machines. 2. Use incremental ROR analysis to decide between the servers at MARR = 12%. Information 3. Use any method of economic analysis to display on the spreadsheet the value of the incremental ROR between There are two alternative computers that can provide the server function for the software interfaces and shared da- server 2 with a life estimate of 5 years and a life estimate tabase updates on the manufacturing floor while Make-to- of 8 years. Specs is operating in parallel mode. The server first cost and estimated contribution to annual net cash flow are summarized below. First cost, $ Net cash flow, $/year Server 1 100,000 35,000 Server 2 200,000 50,000 year 1, plus 5000 per year for years 2, 3, and 4 (gradient) 70,000 maximum for years 5 on, even if the server is replaced Life, years 3 or 4 5 or 8