Scenario: Car Lot Inventory (Ch 2 Pg 51-58)

	A	B	C	D	E	F	G	H	I	K	L
1	Day no.	# cars delivered	Inventory – start	Sales	Inventory – end	Perceived sales	Desired inventory	Shortage	# cars ordered	3	PERCEPTION_DELAY
2	1	20	200	20	180	20.00	200	20	20	5	DELIVERY_DELAY
3	2	20	200	20	180	20.00	200	20	20	3	ORDER_SHORTFALL_AVERAGING_DURATION
4	3	20	200	20	180	20.00	200	20	20	20	HISTORICAL_DAILY_SALES
5	4	20	200	20	180	20.00	200	20	20	10	DESIRED_INVENTORY_TO_SALES_RATIO
6	5	20	200	20	180	20.00	200	20	20	10	SALES_INCREASE_PERC
7	6	20	200	20	180	20.00	200	20	20
8	7	20	200	20	180	20.00	200	20	20
9	8	20	200	20	180	20.00	200	20	20	Notes
10	9	20	200	20	180	20.00	200	20	20	1. Cells shaded red contain formulae that are different from other cells in column
11	10	20	200	20	180	20.00	200	20	20	2. The choice of day 21 as the day of the sales increase is arbitrary
12	11	20	200	20	180	20.00	200	20	20
13	12	20	200	20	180	20.00	200	20	20
14	13	20	200	20	180	20.00	200	20	20
15	14	20	200	20	180	20.00	200	20	20
16	15	20	200	20	180	20.00	200	20	20
17	16	20	200	20	180	20.00	200	20	20
18	17	20	200	20	180	20.00	200	20	20
19	18	20	200	20	180	20.00	200	20	20
20	19	20	200	20	180	20.00	200	20	20
21	20	20	200	20	180	20.00	200	20	20
22	21	20	200	22	178	20.67	207	29	23
23	22	20	198	22	176	21.33	214	38	29
24	23	20	196	22	174	22.00	220	46	38
25	24	20	194	22	172	22.00	220	48	44
26	25	20	192	22	170	22.00	220	50	48
27	26	20	190	22	168	22.00	220	52	50
28	27	23	191	22	169	22.00	220	51	51
29	28	29	198	22	176	22.00	220	44	49
30	29	38	214	22	192	22.00	220	28	41
31	30	44	236	22	214	22.00	220	6	26
32	31	48	262	22	240	22.00	220	0	12
33	32	50	290	22	268	22.00	220	0	2
34	33	51	319	22	297	22.00	220	0	0
35	34	49	346	22	324	22.00	220	0	0
36	35	41	365	22	343	22.00	220	0	0
37	36	26	369	22	347	22.00	220	0	0
38	37	12	359	22	337	22.00	220	0	0
39	38	2	339	22	317	22.00	220	0	0
40	39	0	317	22	295	22.00	220	0	0
41	40	0	295	22	273	22.00	220	0	0
42	41	0	273	22	251	22.00	220	0	0
43	42	0	251	22	229	22.00	220	0	0
44	43	0	229	22	207	22.00	220	13	5
45	44	0	207	22	185	22.00	220	35	16
46	45	0	185	22	163	22.00	220	57	35
47	46	0	163	22	141	22.00	220	79	57
48	47	0	141	22	119	22.00	220	101	79
49	48	0	119	22	97	22.00	220	123	101
50	49	5	102	22	80	22.00	220	140	122
51	50	16	96	22	74	22.00	220	146	137
52	51	35	109	22	87	22.00	220	133	140
53	52	57	144	22	122	22.00	220	98	126
54	53	79	201	22	179	22.00	220	41	91
55	54	101	280	22	258	22.00	220	0	47
56	55	122	380	22	358	22.00	220	0	14
57	56	137	495	22	473	22.00	220	0	0
58	57	140	613	22	591	22.00	220	0	0
59	58	126	717	22	695	22.00	220	0	0
60	59	91	786	22	764	22.00	220	0	0
61	60	47	811	22	789	22.00	220	0	0
62	61	14	803	22	781	22.00	220	0	0
63	62	0	781	22	759	22.00	220	0	0
64	63	0	759	22	737	22.00	220	0	0
65	64	0	737	22	715	22.00	220	0	0
66	65	0	715	22	693	22.00	220	0	0
67	66	0	693	22	671	22.00	220	0	0
68	67	0	671	22	649	22.00	220	0	0
69	68	0	649	22	627	22.00	220	0	0
70	69	0	627	22	605	22.00	220	0	0
71	70	0	605	22	583	22.00	220	0	0
72	71	0	583	22	561	22.00	220	0	0
73	72	0	561	22	539	22.00	220	0	0
74	73	0	539	22	517	22.00	220	0	0
75	74	0	517	22	495	22.00	220	0	0
76	75	0	495	22	473	22.00	220	0	0
77	76	0	473	22	451	22.00	220	0	0
78	77	0	451	22	429	22.00	220	0	0
79	78	0	429	22	407	22.00	220	0	0
80	79	0	407	22	385	22.00	220	0	0
81	80	0	385	22	363	22.00	220	0	0
82	81	0	363	22	341	22.00	220	0	0
83	82	0	341	22	319	22.00	220	0	0
84	83	0	319	22	297	22.00	220	0	0
85	84	0	297	22	275	22.00	220	0	0
86	85	0	275	22	253	22.00	220	0	0
87	86	0	253	22	231	22.00	220	0	0
88	87	0	231	22	209	22.00	220	11	4
89	88	0	209	22	187	22.00	220	33	15
90	89	0	187	22	165	22.00	220	55	33
91	90	0	165	22	143	22.00	220	77	55
92	91	0	143	22	121	22.00	220	99	77
93	92	0	121	22	99	22.00	220	121	99
94	93	4	103	22	81	22.00	220	139	120
95	94	15	96	22	74	22.00	220	146	136
96	95	33	107	22	85	22.00	220	135	140
97	96	55	140	22	118	22.00	220	102	128
98	97	77	195	22	173	22.00	220	47	95
99	98	99	272	22	250	22.00	220	0	50
100	99	120	370	22	348	22.00	220	0	16