$[?]$ Column J $-$ Available Inventory

$[?J3=$ beginning inventory for that month $+$ units received that month

$[?]$ You are to write the formula for $J3$ yourself and copy it to $J4$ thru $J14$

$[?]$ Column K$-$Demand

The simulated monthly demand is based upon the Demand Distribution table. We will use Excel's LOOKUP function. You previously entered the parameters $($demand$,$ probabilities, and random number intervals$)$ in the Demand Distribution table, cells D$17$:E$25.$ We will use a random number generator, $=$Rand$(),$ to provide a number a number between $0\mathrm{.}0000$ and $0\mathrm{.}9999.$ LOOKUP will than use that random number to find the corresponding demand for that month from the Demand Distribution table. For instance, the random number of $0\mathrm{.}20$ falls between $0\mathrm{.}056$ and $0\mathrm{.}278$ in the table, returning a demand of $10$ units for that month

$[7]$ Enter the formula below in cell $K3$ and copy the formula to cells $K4$:$K14$

$=$ LOOKUP$(RAND(),$$$D$$$20$:$$D$$$25,$$$420$:$$425)$