Demand during lead time for Apex Enterprises is distributed as follows:

a. Use a spreadsheet program to evaluate the expected number of units short per reorder cycle for reorder points of 40 to 46. What is the expected shortage cost per reorder cycle when the reorder point is 40 and cost per unit short is $36?

b. What happens to the expected shortage cost (when R = 40 and C = $36) if the demand distribution shifts as follows?

Probability .05 .10 .2 .15 .15 .3 .05 46 40 41 42 43 44 45 Demand