the pw is solve in part if its not correct solve it
QUESTION 1 CASE STUDY PEFORMING ROR ANALYSIS FOR 3D PRINTER AND HOT 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 I, is being beta tested that will allow lloT-type (Industrial Internet of Things) connections between machines et 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 IT 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 1. 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 contribution to annual net cash flow, are summarized below. Server 1 100,000 Server 2 100,000 First cost $ 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 3 4 Life, years Case Study Exercises Use spreadsheet analysis to determine the following: A. If the MARR = 12%, which server should be selected based on PW method to make the selection, (Hint: You have to use LCM for PW lculations) answer the below questions: 1. The PW for server 13 years) LCM cash flow -15937 1. The PW for server 1 (3 years) LCM cash flow= .15937 2. The PW for server 2 ( 4 years) LCM cash flow = -24067.5 3. The PW for server 3 ( 5 years) LCM cash flow = 52300.5 4. Based on the PW analysis which option should be selected? Server 3 B- The ROR for each option, answer the below questions: 1. The RqR for server over 3 years operation equal - 5 2. The ROR for server2 over 4 years operation equal = 0 3. The ROR for server3 over 5 years operation equal = 100 4. Based on the ROR for each option which option we should select? Server 3 - Use incremental ROR analysis between server 2 and server 3 to decide which is the best option at MARR = 12%. Answer the below questions 1. As per the Descartes rule of signs for the NCF between servers 2&3, what is the maximum number of real number Delta_i* that exist? 2. As per the Norstroms criterion, is there a one real-positive Delta_1* exist (enter yes or no)? 3. What is the value of Delta_i* between server 2 & 3 if exist? 4. Based on the incremental analysis which option we should select if incremental analysis is applicable ? 12% n 1 2 3 4 S 6 7 8 9 10 11 12 13 14 1 16 TABLE 17 Discrete Cash Flow: Compound Interest Factors 12% Single Payments Uniform Series Payments Arithmetic Gradients F/P P/F A/F FA A/P P/A P/G A/G Compound Present Sinking Compound Capital Present Gradient Gradient Amount Worth Fund Amount Recovery Worth Present Worth Uniform Series 1.1200 08929 100000 XXCO 1.12000 0.8929 1 2544 0.7972 0.47170 2.1200 0 59170 1.6901 0.2972 0.4717 14049 0.7118 0.29635 3.3744 041635 2.4018 2.2208 0.9246 1.5735 0.6355 0.20923 4.7793 0.32923 3.0373 4.1273 13589 17623 05674 0.15741 63528 0.27741 3.6048 6.3970 1.7746 19738 0.5066 0.12323 8.1152 0.14323 4.1114 8.9302 2.1720 22107 0.4523 0.09912 10.0890 021912 4.5638 11 6543 2.5512 24700 0.4039 0.0510 12 2997 0.2010 49676 14.4714 2.9131 2.7731 03606 0.06768 14.7757 0.18768 5.3282 17.3563 3.2574 3.1058 03220 0.05698 17.5687 0.17698 5.6502 20 2541 3.5647 3.4785 02875 0.04842 206546 0.16842 5.9377 23.1288 3.8953 3.8960 0.2567 0.04144 24.1331 0.16144 6.1944 259523 4.1897 4.3635 0.2292 0.03568 28.091 0.1556% 6.4235 28.7024 44683 48871 0.2046 003057 323926 0.15087 6.6282 313624 4.7317 S4736 0.1827 0.02582 372797 0.162 6.8109 33.9202 4.9803 6.1304 0.1631 0.02339 42.7533 0.14339 6 9740 36 3670 5.2147 68660 0.1456 0.02046 48 8837 0.140-46 7.1196 38.6973 5.4353 76900 0 1300 0.01794 55.7497 0.13794 7.3497 40.9080 5.6427 5.6128 0.1161 0.01576 63 4397 0.13576 73658 429979 5.8375 96463 0.1037 0.0138 72.0524 0.13388 7.4694 44.9676 6.0202 10.8038 0.0926 0.01224 81.6987 0.13224 7.5620 46 8188 6.1913 12.1003 0.0826 ODIONI 92 5026 0.13081 7.6146 48.5543 6.3514 13.5523 0.0738 0.00956 104.6029 0.12956 7.7184 50.1776 6.5010 15.1786 0.0659 0.00846 118.1552 0.12846 7.7843 51.6929 6.6406 17.0001 0.0588 0.00750 1333839 0.12750 7.8431 53.1046 6.7708 19.0401 0.0525 0.00665 1503339 0.12665 7.8957 544177 6.8921 21.3249 00469 0.00590 169 3740 0.12590 7.9426 55.6369 7.0049 238839 0.0419 0.00524 190.6989 0.12524 7.9844 56.7674 7.1098 26.7499 0.0374 0.00466 2145828 0.12466 8.0218 578141 72071 29.9999 00334 0.00414 2411327 052414 8.0852 58.7821 72974 335551 0.0298 0.00369 271 2926 0.12369 BORSO 59.6761 7/3811 375817 0.0266 0.00328 304 3477 0.122 8.1116 60 5010 7.4586 42.0915 0.0238 0.00292 3424294 0.12292 8.1354 61.2012 7.5302 47.1425 0.0212 0.00260 384 5210 0.12260 8.1566 61 9612 7.5965 52.7996 0.0189 0.00232 431.6635 0.12232 8.1755 62.6052 7.6577 930510 0.0107 0.00130 7670914 0.12130 8.2438 65.1159 7.95 163.9876 0.0061 0.0074 135823 0.12074 8.2825 06.7342 8.0572 289.0022 0.0035 0.00042 240002 0.12062 8.1045 67.7624 8.1597 50932015 00020 0.00024 423601 0.12024 83170 684082 8.2251 8975 0.0011 0.0001 7471.64 0.1 2013 8.3240 68 8100 8.2664 158187 0.0006 0.0000 13174 0.12005 8.3251 09.0581 3.2922 278780 0.0004 0.00004 23221 0.12004 1103 69 2103 8.3052 491306 . 0.00002 40934 0.12002 3316 69.3031 83181 8658 4K 0.0001 0.00001 72146 0.12001 8.3324 69 3594 8.3241 15259 0.0001 0.00001 0.12001 3328 69.3935 8.1278 20 21 26 = = = = = = = a aa 50 65 75 80