Please help me do this, I have attached data, and PLEASE inducate which formula were used and the step by step process
================================Enter the z value ->
You are the procurement manager of Tacy’s. The supplier offers a new style of classical bomber jacket for the winter season. The purchase cost is $200, and the selling price is $500. You Consider offering a discount for unsold jackets at the end of the season. The discounted price is $ 150. The forecasted demand, D, is normally distributed with a mean of 3,000 units (mu ) and a standard deviation of 700 units (sigma ). Assume that the A/F ration is 1.
(a) You will get a promotion if the total sold jackets is above 4,000 units. What is the probability that the actual demand will be 4,000 units or more?
(b) Selling less than 80% of the average forecast may result in the placement of your position in a lower pay grade. What is the probability of selling more than 80%?
(c) What is the probability that the actual demand is within 25% of the average forecast?
(d) What is the expected profit maximizing order quantity, Q?
(e) Assuming Tacy’s Manger enforces and orders quantity of Q=4,500. What are the expected lost sales?
(f) At Q=4,500, what are the expected sales?
(g) At Q=4,500, what is the expected leftover inventory?
(h) At Q=4,500, what is the expected profit?
(i) At Q=4,500, what is the expected fill rate?
(j) At Q=4,500, what is the stock-out probability?
(z) (z)1 z (z) L(z) z (z) (z Z (z) L(z) -3.00 0.0013 3.000 -1.24 0.10751.292 0.52 0.69850.192 2.28 0.98870.004 -2.96 0.0015 2.960 -1.20 0.1151 1.256 0.56 0.7123 0.180 2.32 0.9898 0.003 -2.92 0.0018 2.921 1.16 0.1230 1.221 0.60 0.72570.169 2.36 000 6066'0 2.88 0.0020 2.881 1.12 0.1314 1.186 0.64 0.7389 0.158 2.40 0.99180.003 -2.84 0.0023 2.841 1.08 0.1401 1.151 0.68 0.7517 0.148 2.44 0.9927 0.002 -2.80 0.0026 2.801 1.04 0.1492 1.117 0.72 0.7642 0.138 2.48 0.99340.002 -2.76 0.0029 2.761 1.00 0.1587 1.083 0.76 0.7764 0.129 2.52 0.99410.002 -2.72 0.0033 2.721 -0.96 0.1685 1.050 0.80 0.78810.120 2.56 0.9948 0.002 -2.68 0.0037 2.681 -0.92 0.1788 1.017 0.84 0.7995 0.112 2.60 0.9953 0.001 -2.64 0.0041 2.641 -0.88 0.18940.984 0.88 0.81060.104 2.64 0.9959 0.001 -2.60 0.0047 2.601 -0.84 0.2005 0.952 0.92 0.8212 0.097 2.68 0.9963 0.001 -2.56 0.0052 2.562 -0.80 0.2119 0.920 0.96 0.8315 0.090 2.72 0.9967 0.001 -2.52 0.0059 2.522 -0.76 0.22360.889 1.00 0.8413 0.083 2.76 0.99710.001 -2.48 0.0066 2.482 -0.72 0.2358 0.858 1.04 0.8508 0.077 2.80 0.9974 0.001 -2.44 0.0073 2.442 0.68 0.2483 0.828 1.08 0.8599 0.071 2.84 0.9977 0.001 -2.40 0.0082 2.403 0.64 0.2611 0.798 1.12 0.86860.066 2.880.9980 0.001 -2.36 0.0091 2.363 -0.60 0.2743 0.769 1.16 0.8770 0.061 2.92 0.9982 0.001 -2.32 0.0102 2.323 0.56 0.2877 0.7401.20 0.8849 0.056 2.96 0.9985 0.000 -2.28 0.0113 2.284 0.52 0.3015 0.712 .240.89250.052 3.00 0.99870.000 -2.24 0.0125 2.244 0.48 0.3156 0.684 1.28 0.8997 0.047 3.040.9988 0.000 -2.20 0.0139 2.205 0.44 0.3300 0.657 1.320.9066 0.044 3.08 0.9990 0.000 -2.16 0.0154 2.165 0.40 0.3446 0.6301.36 0.9131 0.040 3.12 0.9991 0.000 -2.12 0.0170 2.126 0.36 0.3594 0.605 1.40 0.9192 0.037 3.16 0.99920.000 -2.08 0.0188 2.087 -0.32 0.3745 0.579 1.44 0.9251 0.034 3.20 0.9993 0.000 -2.04 0.0207 2.048 -0.28 0.3897 0.554 1.48 0.93060.031 3.24 0.9994 0.000 2.00 0.0228 2.008 0.24 0.4052 0.530 1.52 0.9357 0.028 3.28 0.99950.000 -1.96 0.0250 1.969 -0.20 0.4207 0.507 1.56 0.94060.026 3.32 0.9995 0.000 -1.92 0.0274 1.930 0.16 0.4364 0.484 1.60 0.9452 0.023 3.360.9996 0.000 1.88 0.0301 1.892 0.12 0.4522 0.462 1.64 0.9495 0.021 3.40 0.9997 0.000 -1.84 0.0329 1.853 0.08 0.4681 0.440 1.68 0.9535 0.019 3.44 0.9997 0.000 -1.80 0.03591.814 -0.04 0.4840 0.419 1.72 0.95730.017 3.48 0.99970.000 1.76 0.0392 1.776 0.00 0.5000 0.399 1.76 0.9608 0.016 3.52 0.9998 0.000 -1.72 0.0427 1.737 0.04 0.5160 0.379 1.80 0.9641 0.014 3.56 0.9998 0.000 -1.68 0.04651.699 0.08 0.5319 0.360 1.84 0.96710.013 3.60 0.9998 0.000 1.64 0.0505 1.661 0.12 0.5478 0.342 1.88 0.9699 0.012 3.64 0.9999 0.000 -1.60 0.0548 1.623 0.16 0.5636 0.324 1.92 0.9726 0.010 3.68 0000 66660 -1.56 0.05941.586 0.20 0.5793 0.307 1.96 0.9750 0.009 3.720.9999 0.000 1.52 0.0643 1.548 0.24 0.5948 0.290 2.00 0.9772 0.008 3.76 0.9999 0.000 -1.48 0.0694 1.511 0.28 0.61030.274 2.04 0.97930.008 3.80 0.99990.000 -1.44 0.0749 1.474 0.32 0.6255 0.259 2.08 0.98120.007 3.84 0.9999 0.000 -1.40 0.0808 1.437 0.36 0.6406 0.245 2.12 0.9830 0.006 3.88 0.9999 0.000 -1.36 0.0869 1.400 0.40 0.6554 0.230 2.16 0.9846 0.005 3.92 1.0000 0.000 1.32 0.0934 1.364 0.44 0.6700 0.217 2.20 0.9861 0.005 3.96 1.0000 0.000 1.28 0.1003 1.327 0.48 0.6844 0.204 2.240.98750.004 4.001.00000.000
z-value| (z Enter the z value 0 0.5 Read In-stock Probability
L(z)
0.39894228
Read Lost Function