this will help you because its a solution setup help

QUESTION 1 CASE STUDY PEFORMING ROR ANALYSIS FOR 3D PRINTER AND HIOT TECHNOLOGY Background Software used in 3D printer systems manufactured by Spectrum LASER Corp. is currently able to automatically develop hollows, shells, and tree supports to save development time. Network printing for use on multiple machines and at different locations globally is available. New software, called JIT il, is being beta tested that will allow lloT-type (Industrial Internet of Things) connections between machines at distant locations. When onboard monitoring sensors detect that a part is about to fail, or it is time to replace one of several high-profile parts, the JIT il software will automatically queue the part's manufacturing code onto a 3D printer that is detected to be locally idle or ready. The company believes it can design and produce the JIT ll software, the 3D printers, and the accompanying computer equipment necessary to place this technology in a wide variety of harsh environments-chemically toxic to humans, in flight, underground in mines, on the ocean floor, In war torn areas, etc. Information For this case, we will analyze the available computers that can provide the server function necessary to make this interlinking Available and successful. The first cost and other parameter estimates, including expected contributlon to annual net cash flow, are summarized below. Server 1 100,000 Server 2 100,000 First costs Net cash flow, s/year 35,000 25000 Server 3 150000 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 5 4 3 Life, years Case Study Exercises Use spreadsheet analysis to determine the following lculations answer the below questions Use spreadsheet analysis to determine the following If the MARR - 12%, which server should be selected based on PW method to make the selection (Hint: You have to use LCM for PWC 1. The PW for server 1years) LCM cash flow 24912 2. The PW for server 2 ( 4 years) LCM cash flow. 15888 3. The PW for server 3 15 years) LCM cash flow 39720 4. Based on the PW analysis which option should be selected server 3 8. The ROR for each option, answer the below questions: 1. The ROR for servert over 3 years operation equal 2. The ROR for server over 4 years operation equal 3. The ROR for server over 5 years operation equal 4. Based on the ROR for each option which option we should select? Use incremental ROR analysis between server and server 3 to decide which is the best option at MARR=12. Arswer the below questions 1. As per the Descartes rule of signs for the NCF between servers 282, what is the maximum number of real number Delta that 2 exist? 2. As per the Norstroms criterion, is there a one real positive Deta* exist (enter yes or no)? 3. What is the value of Delta I between server 28 3f exist? 4. Based on the incremental analysis which option we should select it incremental analysis is applicable? TA O ! Server 1 years $100,000.00 $35.000.00 $35.000.00 $35.000.00 Server 25 years LOM $150,000.00 GO $50.000.00 12 Server Byears -$100,000.00 $35.000.00 $35,000.00 535,000.00 $35,000.00 00 000 SSS 00000095 2 3 4 5 2 3 4 5 $65.000.00 $70,000.00 9 7 7 8 6 6 DO Server 1 year Server 25 years NO $100,000.00 $150.000.00 $50,000.00 $35.000.00 $50,000.00 $15,000.00 $35,000.00 $55,000.00 $20,000.00 $35.000.00 $60,000.00 $25,000.00 565.000.00 565,000.00 $130,000.00 $35,000.00 $80,000.00 $115,000.00 595.60000 $70,000.00 $35,000.00 $35,00000 $70,000.00 $35,000.00 $65.000.00 570,000.00 $135,000.00 $35,000.00 $70,000.00 $35.000.00 535.000.00 $10,000.00 $115,000.00 $35.00000 $70,000.00 $35,000.00 $55,000.00 $70,000.00 $135,000.00 $35.000.00 $70,000.00 $35.000.00 335.000.00 $70,000.00 $15,000.00 $35.000.00 5.000.00 $115.000.00 565.000.00 $70,000.00 $115.000.00 $15.000.00 $70,000.00 $15.000.00 $5.000.00 $70,000.00 595,000.00 $15.000.00 $70,000.00 595.00000 $70,000.00 $35.000.00 10 11 12 13 14 15 MCF $50,000.00 535.000.00 $15.000.00 $10,000.00 $140,000.00 $25,000.00 560.000.00 $95.000.00 $230,000.00 $265.00000 $150,000.00 $15.000.00 $120,000.00 $395.000 DO $190,000.00 $275,000.00 5410,000.00 $425,000.00 5480,000.00 5515.000.00 SW.00000 1 Server 1 year $100,000.00 $35,000.00 $35.000.00 $35,000.00 545.000.00 $35,000.00 $35,000.00 $35,000.00 $65,000.00 $35,000.00 $35,000.00 $35,000.00 -365.000.00 $35.000 335.000.00 535,000.00 $6.000.00 $15,000.00 535,00000 $15.000.00 45.000.00 525,000.00 575.000.00 $100.000 $35,000.00 $35.00000 -565,000.00 $35,000.00 $35.000.00 365,000.00 $35.00000 $35,000.00 -565,000.00 $35,000.00 $35,000.00 $65,000.00 $35,000.00 $35.000 -565.000 $15,000.00 525.00000 56.000.00 $35.000 $15.000 -0.000 $35,000.00 $35.000 $65.000.00 $35.000 $35.000.00 365.000 $35.000 91 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 26 12 18 10 20 00000 SES DO DO ar 00000 SES AW PW per erele PW LOM DO W.000.00 $35,000.00 $35,000.00 335,000.00 8.000.00 O LCM NI Server 1 year Server years Server 35 $100,000.00 0.000 $3.000.00 550.000.00 $5.000.00 $5.000.00 S.CO 0.00000 TID $70,000.00 ACH 150,000.00 $35,000.00 $11.00000 $10,000.00 29 30 11 12 13 14 $35.000.00 $35.000.00 $5,000.00 4.000.00 $35.00000 00 000 DES 00 e 1 4 $ 0000095 000000 00 GOOSES SE ? Server $10.000.00 $1.00000 $35.000 $15.000.00 51.000.00 $5.000.00 S35.000 SS.600.00 $15.000.00 $15,000.00 $15.000.00 $5.000.00 SI5.000.00 $35.000.00 $5.000.00 $35.000.00 SI5,000.00 595,000.00 $35.000.00 $35.000.00 $35.000.00 . 6 01 Server SNC $100,000.00 $50,000.00 $50,000.00 $15.000.00 $5,000.00 $20,00000 560,000.00 525.000.00 $65.000.00 $40,000.00 $10,000.00 545,000.00 $70,000.00 $2.000.00 $70,000.00 $35.000.00 $70,000.00 5,000.00 $70,000.00 $5,000.00 $10,00000 145,000.00 $70,000.00 $15.000.00 $70,000.00 585,000.00 52.00000 $35.000.00 $20,000.00 $35.000.00 -565,000.00 $70,000.00 S85.000.00 570,000.00 $70,000.00 $35.000.00 $70,000.00 $35,000.00 $70,000.00 $35.000.00 $35.000.00 4.000.00 SI5,000.00 $15,000.00 $25.000.00 5.000.00 16 3 18 19 40 41 42 00 SES 11 12 13 14 15 16 $25.000.00 $60,00000 $95.000.00 $120.000.00 $215.000.00 5150,000.00 $185 000 00 5210,000 SNO.0000 $140,000.00 $275,000.00 $160,000.00 $395.000.00 54.90,000.00 5465,000.00 S500,000.00 DO DES 44 45 46 47 $35.000 365,000.00 $5,00000 $1,00000 561,000.00 $35,00000 $35.000 345.000 DO $35.000 $11.00000 $6,000.00 $11.00 185.000 563.000 $35.000 $1,000.00 -565/2000 $35.000.00 $99.000.00 $65.000 $35,000 $35,000.00 563.000 $35,000.00 $35.000.00 $65,000.00 $35.000.00 $35,000.00 $65.00000 $35,000.00 $35,000.00 $35,000.00 $ 00000 SES 15 20 $15,000.00 $35.000.00 145.000.00 $35.000 60 SI5.000.00 $35,000.00 565.000.00 $35,000.00 $35.000.00 $35,000.00 S45.000.00 535,000.00 $35.000.00 $35,000.00 -0.000.00 $35.000.00 $25,000.00 $35.000.00 $35,000.00 87 67 06 TS AP 52 RON AW PW per role ES PW LOM 54 55 $ 95 SY SE 55 09 QUESTION 1 CASE STUDY PEFORMING ROR ANALYSIS FOR 3D PRINTER AND HIOT TECHNOLOGY Background Software used in 3D printer systems manufactured by Spectrum LASER Corp. is currently able to automatically develop hollows, shells, and tree supports to save development time. Network printing for use on multiple machines and at different locations globally is available. New software, called JIT il, is being beta tested that will allow lloT-type (Industrial Internet of Things) connections between machines at distant locations. When onboard monitoring sensors detect that a part is about to fail, or it is time to replace one of several high-profile parts, the JIT il software will automatically queue the part's manufacturing code onto a 3D printer that is detected to be locally idle or ready. The company believes it can design and produce the JIT ll software, the 3D printers, and the accompanying computer equipment necessary to place this technology in a wide variety of harsh environments-chemically toxic to humans, in flight, underground in mines, on the ocean floor, In war torn areas, etc. Information For this case, we will analyze the available computers that can provide the server function necessary to make this interlinking Available and successful. The first cost and other parameter estimates, including expected contributlon to annual net cash flow, are summarized below. Server 1 100,000 Server 2 100,000 First costs Net cash flow, s/year 35,000 25000 Server 3 150000 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 5 4 3 Life, years Case Study Exercises Use spreadsheet analysis to determine the following lculations answer the below questions Use spreadsheet analysis to determine the following If the MARR - 12%, which server should be selected based on PW method to make the selection (Hint: You have to use LCM for PWC 1. The PW for server 1years) LCM cash flow 24912 2. The PW for server 2 ( 4 years) LCM cash flow. 15888 3. The PW for server 3 15 years) LCM cash flow 39720 4. Based on the PW analysis which option should be selected server 3 8. The ROR for each option, answer the below questions: 1. The ROR for servert over 3 years operation equal 2. The ROR for server over 4 years operation equal 3. The ROR for server over 5 years operation equal 4. Based on the ROR for each option which option we should select? Use incremental ROR analysis between server and server 3 to decide which is the best option at MARR=12. Arswer the below questions 1. As per the Descartes rule of signs for the NCF between servers 282, what is the maximum number of real number Delta that 2 exist? 2. As per the Norstroms criterion, is there a one real positive Deta* exist (enter yes or no)? 3. What is the value of Delta I between server 28 3f exist? 4. Based on the incremental analysis which option we should select it incremental analysis is applicable? TA O ! Server 1 years $100,000.00 $35.000.00 $35.000.00 $35.000.00 Server 25 years LOM $150,000.00 GO $50.000.00 12 Server Byears -$100,000.00 $35.000.00 $35,000.00 535,000.00 $35,000.00 00 000 SSS 00000095 2 3 4 5 2 3 4 5 $65.000.00 $70,000.00 9 7 7 8 6 6 DO Server 1 year Server 25 years NO $100,000.00 $150.000.00 $50,000.00 $35.000.00 $50,000.00 $15,000.00 $35,000.00 $55,000.00 $20,000.00 $35.000.00 $60,000.00 $25,000.00 565.000.00 565,000.00 $130,000.00 $35,000.00 $80,000.00 $115,000.00 595.60000 $70,000.00 $35,000.00 $35,00000 $70,000.00 $35,000.00 $65.000.00 570,000.00 $135,000.00 $35,000.00 $70,000.00 $35.000.00 535.000.00 $10,000.00 $115,000.00 $35.00000 $70,000.00 $35,000.00 $55,000.00 $70,000.00 $135,000.00 $35.000.00 $70,000.00 $35.000.00 335.000.00 $70,000.00 $15,000.00 $35.000.00 5.000.00 $115.000.00 565.000.00 $70,000.00 $115.000.00 $15.000.00 $70,000.00 $15.000.00 $5.000.00 $70,000.00 595,000.00 $15.000.00 $70,000.00 595.00000 $70,000.00 $35.000.00 10 11 12 13 14 15 MCF $50,000.00 535.000.00 $15.000.00 $10,000.00 $140,000.00 $25,000.00 560.000.00 $95.000.00 $230,000.00 $265.00000 $150,000.00 $15.000.00 $120,000.00 $395.000 DO $190,000.00 $275,000.00 5410,000.00 $425,000.00 5480,000.00 5515.000.00 SW.00000 1 Server 1 year $100,000.00 $35,000.00 $35.000.00 $35,000.00 545.000.00 $35,000.00 $35,000.00 $35,000.00 $65,000.00 $35,000.00 $35,000.00 $35,000.00 -365.000.00 $35.000 335.000.00 535,000.00 $6.000.00 $15,000.00 535,00000 $15.000.00 45.000.00 525,000.00 575.000.00 $100.000 $35,000.00 $35.00000 -565,000.00 $35,000.00 $35.000.00 365,000.00 $35.00000 $35,000.00 -565,000.00 $35,000.00 $35,000.00 $65,000.00 $35,000.00 $35.000 -565.000 $15,000.00 525.00000 56.000.00 $35.000 $15.000 -0.000 $35,000.00 $35.000 $65.000.00 $35.000 $35.000.00 365.000 $35.000 91 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 26 12 18 10 20 00000 SES DO DO ar 00000 SES AW PW per erele PW LOM DO W.000.00 $35,000.00 $35,000.00 335,000.00 8.000.00 O LCM NI Server 1 year Server years Server 35 $100,000.00 0.000 $3.000.00 550.000.00 $5.000.00 $5.000.00 S.CO 0.00000 TID $70,000.00 ACH 150,000.00 $35,000.00 $11.00000 $10,000.00 29 30 11 12 13 14 $35.000.00 $35.000.00 $5,000.00 4.000.00 $35.00000 00 000 DES 00 e 1 4 $ 0000095 000000 00 GOOSES SE ? Server $10.000.00 $1.00000 $35.000 $15.000.00 51.000.00 $5.000.00 S35.000 SS.600.00 $15.000.00 $15,000.00 $15.000.00 $5.000.00 SI5.000.00 $35.000.00 $5.000.00 $35.000.00 SI5,000.00 595,000.00 $35.000.00 $35.000.00 $35.000.00 . 6 01 Server SNC $100,000.00 $50,000.00 $50,000.00 $15.000.00 $5,000.00 $20,00000 560,000.00 525.000.00 $65.000.00 $40,000.00 $10,000.00 545,000.00 $70,000.00 $2.000.00 $70,000.00 $35.000.00 $70,000.00 5,000.00 $70,000.00 $5,000.00 $10,00000 145,000.00 $70,000.00 $15.000.00 $70,000.00 585,000.00 52.00000 $35.000.00 $20,000.00 $35.000.00 -565,000.00 $70,000.00 S85.000.00 570,000.00 $70,000.00 $35.000.00 $70,000.00 $35,000.00 $70,000.00 $35.000.00 $35.000.00 4.000.00 SI5,000.00 $15,000.00 $25.000.00 5.000.00 16 3 18 19 40 41 42 00 SES 11 12 13 14 15 16 $25.000.00 $60,00000 $95.000.00 $120.000.00 $215.000.00 5150,000.00 $185 000 00 5210,000 SNO.0000 $140,000.00 $275,000.00 $160,000.00 $395.000.00 54.90,000.00 5465,000.00 S500,000.00 DO DES 44 45 46 47 $35.000 365,000.00 $5,00000 $1,00000 561,000.00 $35,00000 $35.000 345.000 DO $35.000 $11.00000 $6,000.00 $11.00 185.000 563.000 $35.000 $1,000.00 -565/2000 $35.000.00 $99.000.00 $65.000 $35,000 $35,000.00 563.000 $35,000.00 $35.000.00 $65,000.00 $35.000.00 $35,000.00 $65.00000 $35,000.00 $35,000.00 $35,000.00 $ 00000 SES 15 20 $15,000.00 $35.000.00 145.000.00 $35.000 60 SI5.000.00 $35,000.00 565.000.00 $35,000.00 $35.000.00 $35,000.00 S45.000.00 535,000.00 $35.000.00 $35,000.00 -0.000.00 $35.000.00 $25,000.00 $35.000.00 $35,000.00 87 67 06 TS AP 52 RON AW PW per role ES PW LOM 54 55 $ 95 SY SE 55 09