This is the last extra credit question. I some one could answer these I would greatly appreciate it. This is our extra credit assignment and finals are next week. I could really use the help. Also, someone said they needed service level details in order to solve it, but this is all that was available. The whole problem is posted here.Thanks in advance! -Steve

PA 14-7 (Algo) Cyber Chemicals uses liquid nitrogen on a... Cyber Chemicals uses liquid nitrogen on a regular basis. Average daily demand is normally distributed with a mean of 184 gallons and a standard deviation of 41. Cyber operates Six days a week and orders from its supplier once each week. The supplier takes one week to deliver Cyber's order. a. Suppose an order-up-to level of 2000 is used. What is the average order quantity? b. Suppose an order-up-to level of 2450 is used. What is the expected on-hand inventory? Use Table 14.1 c. Suppose an order-up-to level of 2620 is used. What is the expected on-order inventory? (Round your answer to 4 decimal places.) Suppose an order-up-to level of 2699 is used. What is the in-stock probability? Use d. Table 14.1 (Round your answer to 4 decimal places.) Suppose an order-up-to level of 2375 is used. What is the stockout probability? Use Table 14.1 e. 11 f. Suppose Cyber Chemicals wants a 0.94 in-stock probability. What should the order-up- to level be? Use Excel and round to nearest integer. Z Fiz) A(z) -4.0 .0000 0.0000 -3.9 .0000 0.0000 -3.8 .0001 0.0000 -3.7 .0001 0.0000 -3.6 .0002 0.0000 -3.5 .0002 0.0001 -3.4 .0003 0.0001 -3.3 .0005 0.0001 -3.2 .0007 0.0002 -3.1 .0010 0.0003 -3.0 .0013 0.0004 -2.9 .0019 0.0005 -2.8 .0026 0.0008 -2.7 .0035 0.0011 -2.6 .0047 0.0015 -2.5 .0062 0.0020 -2.4 .0082 0.0027 -2.3 0107 0.0037 -2.2 0.0049 .0139 .0179 -2.1 0.0065 -2.0 .0228 0.0085 -1.9 .0287 0.0111 -1.8 .0359 0.0143 -1.7 .0446 0.0183 -1.6 .0548 0.0232 -1.5 .0668 0.0293 -1.4 .0808 0.0367 -1.3 .0968 0.0455 -12 .1151 0.0561 -1.1 .1357 0.0686 -1.0 .1587 0.0833 -0.9 .1841 0.1004 -0.8 .2119 0.1202 -0.7 .2420 0.1429 -0.6 2743 0.1687 -0.5 .3085 0.1978 -0.4 .3446 0.2304 -0.3 .3821 0.2668 -0.2 .4207 0.3069 -0.1 .4602 0.3509 0.0 .5000 0.3989 0.1 .5398 0.4509 0.2 .5793 0.5069 0.3 .6179 0.5668 0.4 .6554 0.6304 0.5 .6915 0.6978 0.6 .7257 0.7687 0.7 .7580 0.8429 0.8 .7881 0.9202 0.9 .8159 1.0004 1.0 .8413 1.0833 1.1 .8643 1.1686 1.2 .8849 1.2561 1.3 .9032 1.3455 1.4 .9192 1.4367 1.5 .9332 1.5293 1.6 .9452 1.6232 1.7 .9554 1.7183 1.8 .9641 1.8143 1.9 .9713 1.9111 2.0 .9772 2.0085 2.1 .9821 2.1065 2.2 .9861 2.2049 2.3 .9893 2.3037 2.4 .9918 2.4027 2.6 .9953 2.6015 2.7 .9965 2.7011 2.8 .9974 2.8008 2.9 .9981 2.9005 3.0 .9987 3.0004 3.1 .9990 3.1003 3.2 .9993 3.2002 3.3 .9995 3.3001 3.4 .9997 3.4001 3.5 .9998 3.5001 3.6 9998 3.6000 3.7 .9999 3.7000 3.8 .9999 3.8000 3.9 1.0000 3.9000 4.0 1.0000 4.0000