2024, EST ORDER TO LOGISTIC.xlsx

	B	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AJ	AK	AL	AM	AN
1																non jadwal routing
2																input estimasi order berdasarkan repeat																	350,772
3	*INPUT ESTIMASI AWAL BULAN FULL															tanggal merah
4	VERSION 0 MONTHLY	Full Month Planning Estimation																															Recap
5		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	Week 1	Week 2	Week 3	Week 4	Week 5
6		S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	Week 1	Week 2	Week 3	Week 4	Week 5
7	RETAIL NASIONAL	0	25557	32849	15179	22504	26488	0	0	28150	30419	6866	11800	26935	0	0	19042	21511	500	8000	18642	0	0	11132	14179	5667	4000	15365	0	1800	1000	4987	122,577	104,170	67,695	50,343	5,987
8	REG 01	0	16518	0	6400	12000	0	0	0	20300	0	2500	7000	0	0	0	17542	0	500	7000	0	0	0	9832	0	4667	4000	0	0	0	1000	0	34,918	29,800	25,042	18,499	1,000
9	DKI 01		6518		3900					6900							7542							5432		4467							10,418	6,900	7,542	9,899	0
10	DKI 02		1000		2500					3400		2500					1000		500					400		200					1000		3,500	5,900	1,500	600	1,000
11	JATENG 01		3000			6000				7000			4000				4000			2000				2000			2000						9,000	11,000	6,000	4,000	0
12	JATENG 02		6000			6000				3000			3000				5000			5000				2000			2000						12,000	6,000	10,000	4,000	0
13	REG 02	0	9,039.00	11,998.00	8,779.00	10,504.00	3,607.00	0	0	7,850	5,500	4,366	4,800	669	0	0	1500	2800	0	1000	0	0	0	1300	400	1000	0	0	0	0	0	0	43,927	23,185	5,300	2,700	0
14	JABAR 01		4,594.00	4,100.00	3,900.00	4,061.00	3,607.00			3,559	2,000	2,766	2,000	669																			20,262	10,994	0	0	0
15	JABAR 02		4445	1398	2879	1643				2791		1600												1300	400	1000							10,365	4,391	0	2,700	0
16	SUM 01			4000		4000					2000		2000					2000		1000													8,000	4,000	3,000	0	0
17	SUM 02			2500	2000	800				1500	1500		800				1500	800															5,300	3,800	2,300	0	0
18	REG 03	0	0	20851	0	0	22881	0	0	0	24919	0	0	26266	0	0	0	18711	0	0	18642	0	0	0	13779	0	0	15365	0	1800	0	4987	43,732	51,185	37,353	29,144	4,987
19	JATIM 01			8195			8195				12842			12842				6423			6423				2928			2928		1800		2928	16,390	25,684	12,846	5,856	2,928
20	JATIM 02			2059			5883				2059			5883				2059			5883				2059			5883				2059	7,942	7,942	7,942	7,942	2,059
21	IBT 01			3988			3988				3988			3988				3988			3988				3988			3988					7,976	7,976	7,976	7,976	0
22	IBT 02			6,609			4,815				6,030			3,553				6,241			2,348				4,804			2,566					11,424	9,583	8,589	7,370	0
23
24	E-COM																																0	0	0	0	0
25	OUTLIVE																																0	0	0	0	0
26
27							x							x							x							x
28	VERSION 1 WEEKLY	Running Month Estimation																															Recap
29		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	Week 1	Week 2	Week 3	Week 4	Week 5
30		S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	Week 1	Week 2	Week 3	Week 4	Week 5
31	RETAIL NASIONAL		12659	23075	7697	19223	19185			20639	17001	1500	9000	16824			11000	12019	1000	8600	15112			4000	12375	0	4000	13437			0	0	81839	64964	47731	33812	0
32	REG 01		9000	0	0	12000	0			10000	0	0	7000	0			9000	0	0	7000	0			4000	0	0	4000	0			0	0	21000	17000	16000	8000	0
33	DKI 01																																0	0	0	0	0
34	DKI 02																																0	0	0	0	0
35	JATENG 01		3000			6000				7000			4000				4000			2000				2000			2000						9000	11000	6000	4000	0
36	JATENG 02		6000			6000				3000			3000				5000			5000				2000			2000						12000	6000	10000	4000	0
37	REG 02		3659	6395	7697	7223	999			10639	2500	1500	2000	0			2000	3600	1000	1600	0			0	0	0	0	0			0	0	25973	16639	8200	0	0
38	JABAR 01		2000	2000	1000	1000											2000	1000	1000														6000	0	4000	0	0
39	JABAR 02		1659	1395	6697	3223	999			10639	500	1500																					13973	12639	0	0	0
40	SUM 01			3000		3000					2000		2000					2000		1000													6000	4000	3000	0	0
41	SUM 02																	600		600													0	0	1200	0	0
42	REG 03		0	16680	0	0	18186			0	14501	0	0	16824			0	8419	0	0	15112			0	12375	0	0	13437			0	0	34866	31325	23531	25812	0
43	JATIM 01			4500			4500				2000			3000				500			2000				2000			2000					9000	5000	2500	4000	0
44	JATIM 02			1583			4883				1583			4883				1583			4883				1583			4883					6466	6466	6466	6466	0
45	IBT 01			3988			3988				3988			3988				3988			3988				3988			3988					7976	7976	7976	7976	0
46	IBT 02			6,609			4,815				6,930			4,953				2,348			4,241				4,804			2,566					11424	11883	6589	7370	0
47
48	E-COM																																0	0	0	0	0
49	OUTLIVE																																0	0	0	0	0
50
51
52
53
54	REALIZATION	Full Month Planning Estimation																															Recap
55		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	Week 1	Week 2	Week 3	Week 4	Week 5
56		S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	Week 1	Week 2	Week 3	Week 4	Week 5
57	RETAIL NASIONAL	0	20380	13291	14545	20236	13975	0	0	26960	7368	0	7952	8527	0	0	16984	3804	7294	3047	3500	0	0	5602	1700	0	0	2500	0	0	0	0	82427	50807	34629	9802	0
58	REG 01	0	18721	0	7848	12681	0	0	0	16321	0	0	7952	0	0	0	16984	0	7294	3047	0	0	0	5602	0	0	0	0	0	0	0	0	39250	24273	27325	5602	0
59	DKI 01		8873		7848					3591							5885		7294					4224									16721	3591	13179	4224	0
60	DKI 02																																0	0	0	0	0
61	JATENG 01		2934			5409				7160			3804				5718			3047				1378									8343	10964	8765	1378	0
62	JATENG 02		6914			7272				5570			4148				5381																14186	9718	5381	0	0
63	REG 02	0	1659	4667	6697	7555	999	0	0	10639	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	21577	10639	0	0	0
64	JABAR 01																																0	0	0	0	0
65	JABAR 02		1659	1395	6697	3223	999			10639																							13973	10639	0	0	0
66	SUM 01			3272		4332																											7604	0	0	0	0
67	SUM 02																																0	0	0	0	0
68	REG 03	0	0	8624	0	0	12976	0	0	0	7368	0	0	8527	0	0	0	3804	0	0	3500	0	0	0	1700	0	0	2500	0	0	0	0	21600	15895	7304	4200	0
69	JATIM 01																																0	0	0	0	0
70	JATIM 02			1800			5000				1200			3500				1500			3500				1700			2500					6800	4700	5000	4200	0
71	IBT 01																																0	0	0	0	0
72	IBT 02			6,824			7,976				6168			5027				2304															14800	11195	2304	0	0
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