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?

$\backslash$table$[[$Probability$,\mathrm{.}2,\mathrm{.}4,\mathrm{.}2,\mathrm{.}1,\mathrm{.}1,0,0],[$Demand$,40,41,42,43,44,45,46]]$