13 Inventory Modeling.xlsx

	B	C	D	E	F	G	H	K	L
1
2	A company use anually 1,000 units for its operation. The ordering cost is $5.00 per order with any number of units required.
3	It is considered a holding cost of $1.25 per unit per year. And the supplier send the order in 5 days with a cost per unit of $12.50.
4
5	Compute the economic order quantity for this company and compare the cost considering the actual requirement of 200 units.
6
7	Annual demand	(D) =	1.000	units
8	Average daily demand	(d) =	2,74	(1,000/365)
9	Ordering cost	(S) =	$ 5,00	per order
10	Holding cost	(H) =	$ 1,25	per unit per year
11	Lead time	(L) =	5	days
12	Cost per unit	(C) =	$ 12,50
13
14	What quantity should be ordered.
15
16	1.- The optimal order quantity is				2.- The reorder point is:			3.- The total annual cost will be
17
18
19					ROP= dL	1.000	(5)
20						365
21
22						3
23
24	Qopt=	89,4427191	Units		ROP=	14	Units	TC=	$ 12.611,80
25
26
27
28					Quantity	Total annual Cost	Difference
29					10	$ 13.006,25	-$ 394,447
30					50	$ 12.631,25	-$ 19,447
31					80	$ 12.612,50	-$ 0,697
32					89	$ 12.611,80	$ -
33					90	$ 12.611,81	-$ 0,002
34					100	$ 12.612,50	-$ 0,697
35					200	$ 12.650,00	-$ 38,197
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