Radio Shack sells a 32GB flash drive. Weekly demand for the 32GB flash drive in one of their stores is normally distributed with a 1.25 and standard deviation of 0.5. The store places orders weekly and there is a one week lead time to receive orders.
a. On average, how many units will the store have on order?
b. Suppose they operate with a base stock level of 4. What in-stock probability would they achieve?
Please show excel inputs or formulas