MRP testing.xlsx

	B	C	D	F	G	H	I	J	K	M	N	O	P	Q	R	S	T	U	V	W	X	Z	AA	AB	AC	AD	AE	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR
1		BOM (df_bom)		ITEM MASTER (df_item_master)						PRODUCTION PLAN (FG) (df_fg_production)												STOCK (RPM) (df_stock_rpm)						PO PENDING (df_supply)
2
3	parent	component	norm_total	Item	Type	Site	Leadtime_days	MOQ	Shelf life	Item	Site	4/4/2022	4/5/2022	4/6/2022	4/7/2022	4/8/2022	4/9/2022	4/10/2022	4/11/2022	4/12/2022	4/13/2022	Item	Site	Quantity	Production date	Expiry date	Shelf life	Item	Site	4/4/2022	4/5/2022	4/6/2022	4/7/2022	4/8/2022	4/9/2022	4/10/2022	4/11/2022	4/12/2022	4/13/2022
4	K1	BIAGIAY-K1	1	K1	FG	ABC	1	50	1825	K1	ABC		100		100		50			60	80	BIAGIAY-K1	ABC	25	10/25/2021		No shelf life	BIAGIAY-K1	ABC		80
5	K1	CARTONPAPER	0.07	K1	FG	XYZ	1	50	1825	K1	XYZ		80		50					50		BIAGIAY-K1	ABC	50	12/17/2021		No shelf life	BIAGIAY-K2	ABC
6	K1	MAUTRANG	3	K2	FG	ABC	0	50	1825	K2	ABC	50	50		100		80		100			BIAGIAY-K1	XYZ	60	10/20/2021		No shelf life	CARTONPAPER	ABC						50
7	K1	COTOMAU	1	BIAGIAY-K1	Raw	ABC	2	80	No shelf life													BIAGIAY-K2	ABC	25	10/21/2021		No shelf life	COTOMAU	ABC				100
8	K2	BIAGIAY-K2	1	BIAGIAY-K1	Raw	XYZ	2	80	No shelf life													MAUTRANG	ABC	800	4/6/2021	4/6/2022	365	MAUTRANG	ABC
9	K2	CARTONPAPER	0.0625	BIAGIAY-K2	Raw	ABC	2	60	No shelf life													MAUTRANG	ABC	900	4/10/2021	4/10/2022	365
10	K2	MAUTRANG	3	CARTONPAPER	Raw	ABC	4	40	No shelf life													MAUTRANG	XYZ	300	5/30/2021	5/30/2022	365
11	K2	COTOMAU	1	CARTONPAPER	Raw	XYZ	3	40	No shelf life													CARTONPAPER	ABC	32	1/5/2022		No shelf life
12				MAUTRANG	Raw	ABC	2	30	365													CARTONPAPER	XYZ	19	2/7/2022		No shelf life
13				MAUTRANG	Raw	XYZ	2	30	365													COTOMAU	ABC	500	4/11/2017	4/11/2022	1825
14				COTOMAU	Raw	ABC	4	100	1825													COTOMAU	XYZ	160	4/12/2017	4/12/2022	1825
15				COTOMAU	Raw	XYZ	4	100	1825
16
17
18
19
20
21
22
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