FOOD ORDER RIAU BDG.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AC	AD	AG
1	ISI HANYA YANG WARNA BIRU SAJA																				BUFFER (%)
2																					BUFFER (%)
3																					30%
4	Nomor SKU	PASTRY (PT. CIPTA RASA MULTINDO)													FOREECASE SOLD/ MONTH	FORECASE SOLD/ 2 WEEK	FORECASE SOLD/ WEEK	QTY YG HARUS DI ORDER	QTY YG HARUS DI ORDER	MIN ORDER (CARTON)	30	TREND 3 BULAN TERAKHIR			AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	LAST WEEK (Minggu - Sabtu)	TOTAL	PANDUAN PENGISIAN
5	Nomor SKU	SKU	Qty	X CRTN	UOM	SOH	PO 1 19/5	26/5	2/6			Total+1 PO	Total+2 PO	Total+3 PO	FOREECASE SOLD/ MONTH	FORECASE SOLD/ 2 WEEK	FORECASE SOLD/ WEEK	QTY YG HARUS DI ORDER	QTY YG HARUS DI ORDER	4	30	April	March	February	AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	10 May 2026 Sampai 16 May 2026	TOTAL	1. Isi kolom yang berwarna bisu saja. 2. Dilarang untuk merubah atau edit kolom dengan warna lain selain warna biru. 3. Isi kolom SOH sesuai dengan fisik yang ada di store (diisi saat akan melakukan order food). 4. Isi kolom PO 1 jika terdapat PO gantung di minggu tersebut. 5. Isi kolom PO 2 dan PO seterusnya jika diharuskan order lebih dari 1 PO. 6. Isi kolom V, W, X (warna biru) sesuai dengan penjualan food di bulan tersebut. 7. Isi kolom AC (warna biru) sesuai dengan penjualan food di minggu lalu. 8. Isi kolom U (buffer) sesuai dengan kebutuhan di store yang ingin melakukan buffer berapa %). 9. Jika sudah terisi semua, total Qty yang seharusnya di order berada pada kolom R. NOTE!!!!!! - Order food harus di sesuaikan dengan kapasitas atau jumlah freezer. - Jangan melakukan buffer berlebih jika tidak diharuskan. - Perhatikan minimal order dari setiap vendor, hitung pada kolom D apakah Qty sudah memenumi minimal order dari vendor tersebut. - Tools ini akan terus update jika suatu hari terdapat perubahan dari mulai SKU, Qty dll. - Feedback Tools bisa menghubungi via WA : +62881023565159.
6	RAW199127	Almond Croissant 90gr	20	3	pcs/carton	28	80		40			108	108	148	104	52	26	0	tidak order	KURANG DARI MIN ORDER		102	137	108	116	4	27	25	25
7	RAW109111	Butter Croissant 55g	20	4	pcs/carton	44	80	80				124	204	204	160	80	40	0	tidak order			141	136	119	132	4	31	49	49
8	RAW199110	Pain Au Chocolate 55g	24	3	pcs/carton	48	48	72				96	168	168	101	50	25	0	tidak order			102	115	110	109	4	25	25	25
9	RAW199109	Kouign Amann 90gr	24	2	pcs/carton	72		48				72	120	120	56	28	14	0	tidak order			73	67	56	65	2	15	13	13
10	RAW199128	Croissant Smoke beef & Cheese 80gr	20	1	pcs/carton							0	0	0	15	8	4	20	1 carton			30	30	37	32	1	8
11	RAW199126	Triple Cheese Danish 70gr	24	2	pcs/carton	24	48	48				72	120	120	59	30	15	0	tidak order			60	60	68	63	2	15	15	15
12	RAW199130	Choco Melt Muffin	32	2	pcs/carton	52	32		32			84	84	116	79	40	20	0	tidak order			64	90	98	84	3	20	20	20
13	RAW199129	Blueberry Cheese Muffin	32	1	pcs/carton	32			32			32	32	64	37	19	9	32	1 carton			33	38	41	37	1	9	10	10
14	RAW199156	Pain Au Tiramisu Croissant	24	1	pcs/carton	28		48				28	76	76	32	16	8	0	tidak order			44	48	47	46	2	11	5	5
15		Total				328	288	296	104	0	0	616	912	1016	644	322	161	52	2
16
17	Nomor SKU	SANDWICH (PT. JADDI GROUP)													FOREECASE SOLD/ MONTH	FORECASE SOLD/ 2 WEEK	FORECASE SOLD/ WEEK	QTY YG HARUS DI ORDER	QTY YG HARUS DI ORDER	MIN ORDER (CARTON)		TREND 3 BULAN TERAKHIR			AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	LAST WEEK (Minggu - Sabtu)	TOTAL
18	Nomor SKU	SKU	Qty	X CRTN	UOM	SOH	PO 1 19/5	26/5	2/6			Total+1 PO	Total+2 PO	Total+3 PO	FOREECASE SOLD/ MONTH	FORECASE SOLD/ 2 WEEK	FORECASE SOLD/ WEEK	QTY YG HARUS DI ORDER	QTY YG HARUS DI ORDER	6		April	March	February	AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	10 May 2026 Sampai 16 May 2026	TOTAL
19	RAW199096	Beef Mentai Sandwich (New)	12	5	pcs/carton	17	72		36			89	89	125	99	50	25	12	1 carton	SUDAH BENAR		81	110	99	97	3	23	27	27
20	RAW199145	Chicken Teriyaki Sandwich	12	2	pcs/carton	14		12				14	26	26	31	16	8	12	1 carton			27	50	33	37	1	9	7	7
21	RAW199146	Smoked Beef & Cheese Sandwich	12	9	pcs/carton	16	108	36	60			124	160	220	209	104	52	48	4 carton			236	252	238	242	8	56	48	48
22	RAW199147	Cheesy Tuna Sandwich	15	3	pcs/carton	0	15		45			15	15	60	72	36	18	60	4 carton			62	75	96	78	3	18	18	18
23	RAW199148	Mushroom Truffle Sandwich	15	4	pcs/carton	0	90		105			90	90	195	102	51	25	15	1 carton			87	100	69	85	3	20	31	31
24	RAW199163	Cakalang Quiche	24	1	pcs/carton	14			14			14	14	28	26	13	6	24	1 carton			28	34	25	29	1	7	6	6
25		Total				61	285	48	260	0	0	346	394	654	539	269	135	171	12
26
27	Nomor SKU	CAKE (PT. FORTUNA)													FOREECASE SOLD/ MONTH	FORECASE SOLD/ 2 WEEK	FORECASE SOLD/ WEEK	QTY YG HARUS DI ORDER	QTY YG HARUS DI ORDER	MIN ORDER (CARTON)		TREND 3 BULAN TERAKHIR			AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	LAST WEEK (Minggu - Sabtu)	TOTAL
28	Nomor SKU	SKU	Qty	X CRTN	UOM	SOH	PO 1 19/5	26/5	2/6			Total+1 PO	Total+2 PO	Total+3 PO	FOREECASE SOLD/ MONTH	FORECASE SOLD/ 2 WEEK	FORECASE SOLD/ WEEK	QTY YG HARUS DI ORDER	QTY YG HARUS DI ORDER	4		April	March	February	AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	10 May 2026 Sampai 16 May 2026	TOTAL
29	RAW199100	Banana Choco cake	24	2	pcs/carton	39			48			39	39	87	73	36	18	48	2 carton	KURANG DARI MIN ORDER		51	80	104	78	3	18	18	18
30	RAW199101	Cempedak	24	1	pcs/carton	23			48			23	23	71	17	8	4	0	tidak order			15	29	25	23	1	5	3	3
31		Total				62	0	0	96	0	0	62	62	158	89	45	22	48	2
32
33	Nomor SKU	KLAPPERART PPANG (BOGA SEJAHTERA)													FOREECASE SOLD/ MONTH	FORECASE SOLD/ 2 WEEK	FORECASE SOLD/ WEEK	QTY YG HARUS DI ORDER	QTY YG HARUS DI ORDER	MIN ORDER (CARTON)		TREND 3 BULAN TERAKHIR			AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	LAST WEEK (Minggu - Sabtu)	TOTAL
34	Nomor SKU	SKU	Qty	X CRTN	UOM	SOH	PO 1 19/5	26/5	2/6			Total+1 PO	Total+2 PO	Total+3 PO	FOREECASE SOLD/ MONTH	FORECASE SOLD/ 2 WEEK	FORECASE SOLD/ WEEK	QTY YG HARUS DI ORDER	QTY YG HARUS DI ORDER	3		April	March	February	AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	10 May 2026 Sampai 16 May 2026	TOTAL
35	RAW199170	Klappertart Croissant	12	1	pcs/carton							0	0	0	18	9	4	24	2 carton	KURANG DARI MIN ORDER		11	21	19	17	1	4	5	5
36		Total				0	0	0	0	0	0	0	0	0	18	9	4	24	2	KURANG DARI MIN ORDER
37
38	Nomor SKU	CAKE (PT. FORTUNA)													FOREECASE SOLD/ MONTH	FORECASE SOLD/ 2 WEEK	FORECASE SOLD/ WEEK	QTY YG HARUS DI ORDER	QTY YG HARUS DI ORDER	MIN ORDER (CARTON)		TREND 3 BULAN TERAKHIR			AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	LAST WEEK (Minggu - Sabtu)	TOTAL
39	Nomor SKU	SKU	Qty	X CRTN	UOM	SOH	PO 1 19/5	26/5	2/6			Total+1 PO	Total+2 PO	Total+3 PO	FOREECASE SOLD/ MONTH	FORECASE SOLD/ 2 WEEK	FORECASE SOLD/ WEEK	QTY YG HARUS DI ORDER	QTY YG HARUS DI ORDER	4		April	March	February	AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	03 May 2026 Sampai 09 May 2026	TOTAL
40		Mocha Roll Cake	30	1	pcs/carton	89			30			89	89	119	41	21	10	0	tidak order	KURANG DARI MIN ORDER		40	50		45	2	11	10	10
41		Pandan Cheese Roll Cake	30	1	pcs/carton	22			90			22	22	112	59	30	15	60	2 carton			66	67		67	2	16	14	14
42		PB&J Jam Roll Cake	30	1	pcs/carton	87						87	87	87	32	16	8	0	tidak order			27	52		40	1	9	7	7
43		Total				109	0	0	90	0	0	109	109	199	91	46	23	60	2
44
45		Total				560 Pcs	573 Pcs	344 Pcs	550 Pcs	0 Pcs	0 Pcs	1133 Pcs	1477 Pcs	2027 Pcs	1381	690	345	355 Pcs	20 Carton
46	TOTAL FREEZER	2 UNIT	KAPASITAS FOOD			#REF!
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