INVENTORY SUJU.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	NO	NAMA RAWMAT	QTY ITEM	KAPASITAS BACKROOM	QTY WST	OUT 7 HARI	SISA STOK	QTY FULL	QTY ORDER	qty buffer /100	KETERANGAN	BUFFER (%) :

2	1	ICE REG 12 OZ	600	4800	2400	1412	705.6	-4094.4	7	1.2	CART
3	2	ICE LARGE 16 OZ	600	3600	1800	826	808.8	-2791.2	5	1.2	CART	120
5	4	RTD 1000	110	330	550	169	347.2	17.2	0	1.2	CART
6	5	HOT REG	50	500	550	127	397.6	-102.4	2	1.2	SLOP (50 PCS)
7	6	HOT LARGE	50	500	450	50	390	-110	2	1.2	SLOP (50 PCS)	100%
8	7	HOT LID	1	10	19	2	16.6	6.6	0	1.2	SLOP (100 PCS)	WEEKDAY
9	8	CUP KIDS	500	500	550	157	361.6	-138.4	0	1.2	CART
10	9	BUTTERSCOTCH	6	24	35	20	11	-13	2	1.2	CART	@ 12%
11	10	VANILA	6	6	10	3	6.4	0.4	0	1.2	CART
12	11	ELDERFLOWER	6	4	2	2	-0.4	-4.4	1	1.2	CART	WEEKEND
13	12	OAT MILK	6	24	23	8	13.4	-10.6	2	1.2	CART	40%
14	13	ALMOND MILK	12	30	18	11	4.8	-25.2	2	1.2	CART	@ 20%
15	14	SOY MULTIGRAIN	12	12	12	5	6	-6	1	1.2	CART
16	15	LYCHE SYRUP	1	4	6	1	4.8	0.8	0	1.2	PCS
17	16	HAZELNUT	1	3	5	1	3.8	0.8	0	1.2	PCS
18	17	JASMINE	1	3	7	1	5.8	2.8	0	1.2	PCS
19	18	TIRAMISU	1	3	7	1	5.8	2.8	0	1.2	PCS
20	19	OREO	1	3	6	1	4.8	1.8	0	1.2	PCS
21	20	ORANGE JUICE	6	42	42	22	15.6	-26.4	4	1.2	CART
22	21	DRIED LEMON	1	5	6	1	4.8	-0.2	0	1.2	PCS
23	22	COFFEE CREAM POW	10	10	8	2	5.6	-4.4	0	1.2	PCS
24	23	PLAIN BASE	10	5	16	2	13.6	8.6	0	1.2	PCS
25	24	SPUNDBOND S	50	1000	750	267	429.6	-570.4	11	1.2	PACK (50 PCS)
26	25	SPUNDBOND M	50	2000	450	508	-159.6	-2159.6	43	1.2	PACK (50 PCS)
27	26	DELMONTE	1	20	11	4	6.2	-13.8	14	1.2	PACK
28	27	CREAMER	10	60	12	44	-40.8	-100.8	10	1.2	CART
29	28	AREN LATTE PREMIX	10	30	20	10	8	-22	2	1.2	CART
30	29	UHT	12	600	384	323	-3.6	-603.6	50	1.2	CART
31	30	FRESH MILK	12	36		31	-37.2	-73.2	6	1.2	CART
32	31	WHIPPE CREAM	12	12		2	-2.4	-14.4	1	1.2	CART
33	32	YAKULT	5	100		27	-32.4	-132.4	26	1.2	PACK
34	33	HOUSE BLAND	10	80	102	30	66	-14	1	1.2	CART
35	34	CLASSIC BLAND	10	50	52	12	37.6	-12.4	1	1.2	CART
36	35	MANUKA	6	24	9	3	5.4	-18.6	3	1.2	CART
37	36	ETERNAL +	20	20	10	3	10	-13.6	1	1.2	CART
38	37	BOTOL KALE	100	100	100	19	77.2	-22.8	0	1.2	CART
39	38	AREN	6	32	35	10	23	-9	2	1.2	CART
40	39	PANDAN	6	18	17	3	13.4	-4.6	1	1.2	CART
41	40	PECAN	12	24	11	8	1.4	-22.6	2	1.2	CART
42	41	SALTED CARAMEL	6	24	17	8	7.4	-16.6	3	1.2	CART
43	42	TRIPLE PEACH	1	6	5	2	2.6	-3.4	3	1.2	PCS
44	43	ENGLISH BREAKFAST	25	50		1	-1.2	-51.2	2	1.2	PACK (25 PCS)
45	44	GREEN TEA JASMINE	25	50		1	-1.2	-51.2	2	1.2	PACK (25 PCS)
46	45	CHAMOMILE	25	50		4	-4.8	-54.8	2	1.2	PACK (25 PCS)
47	46	GREEN TEA MINT	25	50		5	-6	-56	2	1.2	PACK (25 PCS)
48	47	STRAWBERRY PULP	6	6	6	2	3.6	-2.4	0	1.2	CART
49	48	SIMPLE SYRUP	6	18	12	6	4.8	-13.2	2	1.2	CART
50	49	HYDRO COCO	12	24	3	3	-0.6	-24.6	2	1.2	CART
51	50	CARAMEL SAUCE	1	12	9	5	3	-9	9	1.2	PCS
52	51	GULA AREN CAIR	1	20	6	6	-1.2	-21.2	21	1.2	PCS
53	52	MILO	1	5	2	2	-0.4	-5.4	5	1.2	PCS
54	53	FRAPE BASE	1	2	2	1	0.8	-1.2	1	1.2	PCS
55	54	MATCHA POW	1	20	12	5	6	-14	14	1.2	PCS
56	55	COKLAT POW	1	10	11	3	7.4	-2.6	3	1.2	PCS
57	56	CONDENSCE	1	8	18	2	15.6	7.6	0	1.2	PCS
58	57	HIBISCUS TEA	1	5	21	1	19.8	14.8	0	1.2	PCS
59	58	CRUMBLE CARAMEL	1	4	10	1	8.8	4.8	0	1.2	PCS
60	59	WHITE SUGAR	1	2	2	1	0.8	-1.2	1	1.2	PACK
61	60	BROWN SUGAR	1	4	3	1	1.8	-2.2	2	1.2	PACK
62	61	PAPER POUCH CAKE	1	10	9	165	-189	-199	199	1.2	PACK
63	62	PACKAGING BOX	1	5	3	1	1.8	-3.2	3	1.2	PACK
64	63	NAPKIN	48	144	288	21	262.8	118.8	0	1.2	CART
65	64	ROCK SALT POW	15	20	14	9	3.2	-16.8	1	1.2	CART
66	65	KERTAS ROTI	1	5		78	-93.6	-98.6	99	1.2	PACK
67	66	SPORK AND KNIFE	1	10	300	92	189.6	179.6	0	1.2	PACK
68	67	CUP TRAY 4 LUBANG	75	1400	675	800	-285	-1685	22	1.2	PACK
69	68	STIRER	1	1	13	1	11.8	10.8	0	1.2	PACK
70	69	TRASH BAG	1	40		2	-2.4	-42.4	42	1.2	PACK
71	70	THERMAL PAPER	1	30	31	7	22.6	-7.4	7	1.2	PCS
72	71	THERMAL STIKER	5	50	20	16	0.8	-49.2	10	1.2	PACK
73	72	SUAPI 25	1	72	24	6	16.8	-55.2	55	1.2	PACK
74	73	SUAOI 50	1	60	40	9	29.2	-30.8	31	1.2	PACK
75	74	SARUNG TANGAN PLASTIK	1	10	0	5	-6	-16	16	1.2	PACK
76	75	HAND TOWEL	1	20	48	6	40.8	20.8	0	1.2	PACK
77	76	HAND SANITAZER	1	1		1	-1.2	-2.2	2	1.2	BOTOL
78	77	Q-SAN	1	1		1	-1.2	-2.2	2	1.2	BOTOL
79	78	MPC	1	2		1	-1.2	-3.2	3	1.2	BOTOL
80	79	HAND SOAP	1	2		1	-1.2	-3.2	3	1.2	BOTOL
81	80	FLOOR CLEANER	1	1		1	-1.2	-2.2	2	1.2	BOTOL
82	81	IRISH	6	6	9	1	7.8	1.8	0	1.2	CART
84	83	STICKER FORE JR	25	200	25	157	-163.4	-363.4	15	1.2	PACK
85	84	CABLE TIES	1	20	10	5	4	-16	16	1.2	PACK
86	85	CAKE PLATE				0	0	0	#DIV/0!	1.2	PACK
87	86	ISOLASI	1	30	17	15	-1	-31	31	1.2	PCS
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102