SCM Sheets - Mock Models.xlsx

	A	B	C	D	E	F	G	H
1	EOQ Model
2	Demand	4000	units/year
3	Holding Cost	5	$/Year
4	Ordering Cost	100	$/order
5
6		Ch1	Ch2	Ch3	Ch4	Ch5	Ch6	Ch7
7	Q	50	100	200	400	500	1000	2000
8	Average Inventory	25	50	100	200	250	500	1000
9	Total Holding Cost	125	250	500	1000	1250	2500	5000
10	Number of Orders	80	40	20	10	8	4	2
11	Total Ordering Cost	8000	4000	2000	1000	800	400	200
12	Total Cost	8125	4250	2500	2000	2050	2900	5200
13
14
15					,
16
17
18
19
20
21
22								Q = EOQ = √(2cost of ordering Demand/Holding Cost)
23
24
25
26
27
28
29
30
31
32
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