Material management.xlsx

	B	C	F	G
1			Day	Demand
2	Inventory Management Calculation		1	100
3	Lead time (Days)	3	2	122
4	STDEV of daily demand	176	3	491
5	Service level	95%	4	86
6	Z-score	1.64	5	278
7	Safety Stock	503	6	145
8			7	438
9			8	38
10			9	316
11			10	489
12			11	227
13			12	427
14			13	286
15			14	474
16			15	32
17			16	439
18			17	167
19			18	46
20			19	546
21			20	77
22			21	56
23			22	34
24			23	126
25			24	218
26			25	8
27			26	10
28			27	373
29			28	382
30			29	453
31			30	54
32			31	310
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100