16 Material Requirement Planning (MRP).xlsx

	B	C	D	E	F	G	H	J	K
1
2	Lot for Lot
3
4	Week	Net Requirements	Production Quantity	Ending Inventory	Holding cost	Setup Cost	Total Cost	Unit Cost	$ 10,00
5	1	50					$ -	SetUp Cost	$ 47,00
6	2	60					$ -	Holding Cost (Weekly) per unit cost	0,5%
7	3	70					$ -
8	4	60					$ -
9	5	95					$ -
10	6	75					$ -
11	7	60					$ -
12	8	55					$ -
13							$ -
14
15	Economic Order Quantity
16
17	Week	Net Requirements	Production Quantity	Ending Inventory	Holding cost	Setup Cost	Total Cost
18	1	50					$ -
19	2	60					$ -
20	3	70					$ -
21	4	60					$ -
22	5	95					$ -
23	6	75					$ -
24	7	60					$ -
25	8	55					$ -
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