Question

Sam's hardware store has an order policy of ordering 12 gallons of a specific primer whenever 7 gallons are on hand. The store would like to see how well their policy works. Assume that beginning inventory in period 1 is 10 units, 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? 3 Weekly sales Probability .20 4 .30 5 20 6 20 .10 7 Random numbers for sales: 37, 60, 79, 21, 85, 71, 48, 39, 31, 35

Answer 1

Calculation of random no range

weekly sales	probability	cumulative probability	Random no range
3	0.2	0.2	0-19
4	0.3	0.5	20-49
5	0.2	0.7	50-69
6	0.2	0.9	70-89
7	0.1	1	90-99

calclation of weeky demand and lost sale

frequency	Random no	weekly sales	begening inventory	closing inventory	qty ordered	qty rceived	lost sale
1	37	4	10	6	12		0
2	60	5	6	1			0
3	79	6	13	7	12	12	0
4	21	4	7	3			0
5	85	6	15	9		12	0
6	71	6	9	3	12		0
7	48	4	3	0			1
8	39	4	12	8		12	0
9	31	4	8	4	12		0
10	35	4	4	0			0

No of lost sale = 1