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	8/11/2026	8/18/2026	8/25/2026			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	July	June	May	AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	02 August 2026 Sampai 08 August 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	20	20	40	40			40	80	120	104	52	26	40	2 carton	SUDAH BENAR		102	137	108	116	4	27	25	25
7	RAW109111	Butter Croissant 55g	20	4	pcs/carton	56	20	20	40			76	96	136	160	80	40	60	3 carton			141	136	119	132	4	31	49	49
8	RAW199110	Pain Au Chocolate 55g	24	3	pcs/carton	40		48	24			40	88	112	101	50	25	24	1 carton			102	115	110	109	4	25	25	25
9	RAW199109	Kouign Amann 90gr	24	2	pcs/carton	16	24	24				40	64	64	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	32			24			32	32	56	59	30	15	48	2 carton			60	60	68	63	2	15	15	15
12	RAW199130	Choco Melt Muffin	32	2	pcs/carton	28	32	32				60	92	92	79	40	20	0	tidak order			64	90	98	84	3	20	20	20
13	RAW199129	Blueberry Cheese Muffin	32	1	pcs/carton	36			32			36	36	68	37	19	9	32	1 carton			33	38	41	37	1	9	10	10
14	RAW199156	Pain Au Tiramisu Croissant	24	1	pcs/carton							0	0	0	32	16	8	48	2 carton			44	48	47	46	2	11	5	5
15		Total				228	96	164	160	0	0	324	488	648	644	322	161	272	12
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	8/11/2026	28/7/2026	8/25/2026			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		July	June	May	AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	02 August 2026 Sampai 08 August 2026	TOTAL
19	RAW199096	Beef Mentai Sandwich (New)	12	5	pcs/carton	6		48	48			6	54	102	99	50	25	48	4 carton	SUDAH BENAR		81	110	99	97	3	23	27	27
20	RAW199145	Chicken Teriyaki Sandwich	12	2	pcs/carton	7	12	12				19	31	31	31	16	8	0	tidak order			27	50	33	37	1	9	7	7
21	RAW199146	Smoked Beef & Cheese Sandwich	12	9	pcs/carton	30	36	60	60			66	126	186	209	104	52	84	7 carton			236	252	238	242	8	56	48	48
22	RAW199147	Cheesy Tuna Sandwich	15	3	pcs/carton	35	30	30	30			65	95	125	72	36	18	0	tidak order			62	75	96	78	3	18	18	18
23	RAW199148	Mushroom Truffle Sandwich	15	4	pcs/carton	29	45	45	45			74	119	164	102	51	25	0	tidak order			87	100	69	85	3	20	31	31
24				#DIV/0!	pcs/carton							0	0	0	26	13	6	0	#DIV/0!			28	34	25	29	1	7	6	6
25		Total				107	123	195	183	0	0	230	425	608	539	269	135	132	11
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	8/11/2026	8/18/2026	8/25/2026			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		July	June	May	AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	02 August 2026 Sampai 08 August 2026	TOTAL
29	RAW199100	Banana Choco cake	24	2	pcs/carton	23		96				23	119	119	73	36	18	0	tidak order	KURANG DARI MIN ORDER		51	80	104	78	3	18	18	18
30	RAW199101	Cempedak	24	1	pcs/carton							0	0	0	17	8	4	24	1 carton			15	29	25	23	1	5	3	3
31		Total				23	0	96	0	0	0	23	119	119	89	45	22	24	1
32
33	Nomor SKU	PT.INTI PRIMA RASA													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	8/11/2026	8/18/2026	8/25/2026			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		July	June	May	AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	02 August 2026 Sampai 08 August 2026	TOTAL
35	RAW199163	Beef omelette toast	15	1	pcs/carton	81						81	81	81	18	9	4	0	tidak order	KURANG DARI MIN ORDER		11	21	19	17	1	4	5	5
36		Total				81	0	0	0	0	0	81	81	81	18	9	4	0	0	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	8/11/2026	8/18/2026	8/25/2026			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		July	June	May	AVERAGE / MONTH	AVERAGE / DAY	AGERAGE / WEEK	26 July 2026 Sampai 01 August 2026	TOTAL
40		Mocha Roll Cake	30	1	pcs/carton	51	30					81	81	81	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	13	60					73	73	73	59	30	15	0	tidak order			66	67		67	2	16	14	14
42		PB&J Jam Roll Cake	30	1	pcs/carton	4	60					64	64	64	32	16	8	0	tidak order			27	52		40	1	9	7	7
43		Total				17	120	0	0	0	0	137	137	137	91	46	23	0	0
44
45		Total				456 Pcs	339 Pcs	455 Pcs	343 Pcs	0 Pcs	0 Pcs	795 Pcs	1250 Pcs	1593 Pcs	1381	690	345	428 Pcs	24 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