Simulate the following inventary replenishment problem far 20 weeks. You will hawe to use the Excel program to simulate. Demand is uniformly distributed between 20 and 30 units. Additional Data are given below. Inventary Cast/Weck - $1.00 Shortage Cost/Week - $2.00 Leod Time -2 weeks Beginning Stock on Hand [SOH)0 Supply in Week 1 - 21 units Supply in Week 2 - 22 units What is the total shortage cost at the end of 20 weeks if the order size in every week is 20 units? The demand for the neat 20 weeks is given belaw \begin{tabular}{l} \hline$0.00 \\ \hline$40.00 \\ \hline$990.00 \\ $1990.000 \end{tabular} None of the above