please answer the following

blue is table 1, red is table 2.

Problem 12-28 (Algo) Regional Supermarket is open 355 days per year. Daily use of cash register tape averages 18 rolls. Usage appears normally distributed with a standard deviation of 4 rolls per day. The cost of ordering tape is $.75, and carrying costs are 36 cents per roll a year. Lead time is 2 days Use Table and Table2. a. What is the EOQ? (Round your answer to the nearest whole number.) EO b. What ROP will provide a lead time service level of 99.8 percent? (Round up your answer to the nearest whole number.) ROP Che Problem 12-41 (Algo) A manager is going to purchase new processing equipment and must decide on the number of spare parts to order with the new equipment. The spares cost $188 each, and any unused spares will have an expected salvage value of $58 each. The probability of usage can be described by this distribution: Number @ Probability .15 2 3 .40 .25.20 Click here for the Excel Data File If a part fails and a spare is not available, 2 days will be needed to obtain a replacement and install it. The cost for idle equipment is $730 per day. What quantity of spares should be ordered? a. Use the ratio method. (Round the SL answer to 2 decimal places and the number of spares to the nearest whole number.) Service level is so we need to order Spares b. Use the tabular method and determine the expected cost for the number of spares recommended. (Do not round intermedicate calculations. Round your final answer to 2 decimals.) Expected costis o Z heb MacBook Air Normal distribution service lovels and unit normal loss function Lead Time Service Level Lead Time Service Level Lead Time Service Level Lead Time Service Level E(2) Z E(2) F(x) Z Elz) 0 1 11 358 11 104 01 04 9 2 10 BE 15 9413 2000 091 20102 2013 125 2013 Q154 0170 101 007 2007 650 10271 1001 2011 43 8 15 3156 300 3446 359 3745 A-10 -20 -11 -22 -2.24 -13 -21 -212 -20 -204 -200 -13 1 -1 1.24 -1 -1 -1.72 -1.8 -16 -1.80 -1.5 -15 -1.48 -14 -1 -13 -12 -10 - 72 858 - 878 - - 740 - - - 44 657 - - - - 555 -24 10 - 507 - - 12 452 = 40 - 0 240 20 222 2204 221 2205 21 21 2007 2018 2009 1 10 1 16] 14 177 1.7 199 11 1.62 1 1.54 1.511 1.474 1.427 1.40 1364 132 12.2. 125 12 11 1151 1.17 10 10 1.00 098 0982 0 0 0 0.2 08 10 104 1.E 112 116 1 174 1 1 1.2% 1 14 1. 152 1 1 07 01 066 ) 16 062 THE DHA CD RT 49 825 1995 9131 192 SI NG 5 P106 99T 22 000 24 200 000 252 00 256 Docu 2em 2010 264 2010 268 0000 27 Don 27 000 2 000 24 007 7 2006 792 005 26 4 3.00 0 30 000 3.12 0002 1 0002 200 324 A001 3 10001 0 3 no! ) re 06 5 959 9 67 971 074 9 88 9 50 9 992 82 994 95 95 9999 19997 4052 420, 168 4457 BET 40 200 51m 5319 479 56 5 5948 6 625 15 658 SCO REA 945 1 IP : 73 Ambum wwww% mu w RSS DS2 ) 2015 0905 DEA 694 054 034 DBOR 860 34 - IDO . 1151 17 11 - .14 15 1685 61788 1984 2005 1 14 24 CT 019 2017 016 014 : : m 09 41 671 19726 19750 2015 19 12 15 200 204 4 -1 20 -16 -12 -18 -1.0M -10 - 46 - 2 - 480 12 980 0 981 75 THE TITA ? - 517 EA2 TE LE 2007 006 06 005 212 216 2 224 2 AND 129 41 2 Service level 2 scale