Sam's hardware store has an order policy of ordering 12 gallons of a specific primer whenever 7 gallons are on hand (unless there's already an ordered delivery due). The store would like to see how well their policy works

Assume that beginning inventory in period 1 is 10 gallons and that orders are placed at the end of the week to be received one week later. (In other words, if an order is placed at the end of week one, it is available at the beginning of week 3.) Assume that if inventory is not on hand, it will result in a lost sale. The weekly demand distribution obtained from past sales is found in the table below. Also, use the random numbers that are provided and simulate 10 weeks' worth of sales. How many sales are lost?

Weekly sales Probability
3 .20
4 .30
5 .20
6 .20

Random numbers for sales: 37, 60, 79, 21, 85, 71, 48, 39, 31, 35

Weekly sales Probability RN
assignment
3 .20 01-20
4 .30 21-50
5 .20 51-70
6 .20 71-90
7 .10 91-00

Week Order received Beginning inventory RN Sales Ending inventory Order? Lost sales
1 10 37 4 6 Y
2 6 60 5 1
3 12 13 79 6 7 Y
4 7 21 4 3
5 12 15 85 6 9
6 9 71 6 3 Y
7 3 48 4 0 1
8 12 12 39 4 8
9 8 31 4 4 Y
10 4 35 4 0

Over the 10 weeks only 1 gallon of sales is lost.