UMSU.xlsx

	A	B	C	D	E	F	G	H	I	L	M	O	P	Q	R	S	T	U	V	W	X	Y
1	#	Cabang	Periode	Kode Menu	Nama Menu	Jenis Menu	Σ Qty	Harga (Rp)	Total (Rp)	dada 3	729	Update pertgl 21
2	1	OT-UMSU	01-Apr-26	611001	Ayam Dada	Dine In	3	13000	39000	P.atas 3	280	NO	ITEM	STRUK	SISA MATANG	ORDERAN	STOK AWAL	HARUS	SELISIH	KETERANGAN	PENJUALAN
3	2	OT-UMSU	01-Apr-26	611002	Ayam P.Atas	Dine In	7	13000	91000	p.b 2	684	NO	ITEM							KETERANGAN	PENJUALAN
4	3	OT-UMSU	01-Apr-26	611003	Ayam P.Bawah	Dine In	7	9000	63000	sayap 1	550	1	DADA/P.ATAS	3364				2470	894		Ayam	494
5	4	OT-UMSU	01-Apr-26	611004	Ayam Sayap	Dine In	4	9000	36000	Paket 1	338	2	PAHA BAWAH	1313				988	325		Geprek	1024
6	5	OT-UMSU	01-Apr-26	611005	AYAM CLBK Dada	Dine In	5	17000	85000	Paket 2	360	3	SAYAP	1363				988	375		Sadas	868
7	6	OT-UMSU	01-Apr-26	611006	AYAM CLBK P.Atas	Dine In	1	17000	17000	Paket 3	446	4	CHICKEN EXTRA	15	0	15	1	16	-1		Hamer	116
8	7	OT-UMSU	01-Apr-26	611007	AYAM CLBK P.Bawah	Dine In	1	14000	14000	Paket 3	331	5	INDOMIE	68	13	40	40	80	1		Reguler	119
9	8	OT-UMSU	01-Apr-26	611008	AYAM CLBK Sayap	Dine In	3	13000	39000	combo ori 1	6	6	SPAGETTI	18	11	20	7	27	2		Double Beef	67
10	9	OT-UMSU	01-Apr-26	612015	Sadazz P.Bawah Lv 3	Dine In	1	13000	13000	combo ori 2	5	7	ROTI BESAR	264	8	210	75	285	-13	Rusak Lebaran	Chesee	56
11	10	OT-UMSU	01-Apr-26	612025	Paket P.Bawah PDS Lv 1	Dine In	3	16000	48000	combo ori 3	6	8	ROTI KECIL	116	46	110	54	164	-2		P.Chesee	22
12	11	OT-UMSU	01-Apr-26	612026	Paket P.Bawah PDS Lv 2	Dine In	1	16000	16000	combo ori 1 milo	1	9	DAGING BESAR	264	32	220	76	296	0		CLBK	321
13	12	OT-UMSU	01-Apr-26	612028	Paket P.Atas PDS Lv 1	Dine In	3	18000	54000	combo ori 2 milo	0	10	DAGING KECIL	205	0	150	48	198	7		Miprek	21
14	13	OT-UMSU	01-Apr-26	612030	Paket P.Atas PDS Lv 3	Dine In	1	18000	18000	combo ori 3 milo	2	11	KEJU SLICE	78	18	60	36	96	0		Midaz	25
15	14	OT-UMSU	01-Apr-26	612032	Paket Dada PDS Lv 2	Dine In	1	18000	18000	combo D ori 1	0	12	KENTANG	84	17	80	18	98	3		Mikar	22
16	15	OT-UMSU	01-Apr-26	612033	Paket Dada PDS Lv 3	Dine In	1	18000	18000	combo D ori 2	0	13	PRIMA	214	14	192	34	226	2
17	16	OT-UMSU	01-Apr-26	613001	Burger Hamer	Dine In	3	10000	30000	combo D ori 3	2	14	TEH KOTAK	48	28	72	17	89	-13
18	17	OT-UMSU	01-Apr-26	613003	Burger Cheese	Dine In	1	14000	14000	combo D ori 1 milo	0	15	S TEE	475	81	480	166	646	-90
19	18	OT-UMSU	01-Apr-26	613004	Burger Double Beef	Dine In	2	16000	32000	combo D ori 2 milo	0	16	LEMON TEA	0		0		0	0
20	19	OT-UMSU	01-Apr-26	613005	Burger Premium Cheese	Dine In	1	18000	18000	combo D ori 3 milo	0	17	ORANGE	67	39	50	46	96	10
21	20	OT-UMSU	01-Apr-26	614004	Nasi	Dine In	11	5000	55000	bolaz 3	27	18	CHOCOMALT	10	29	0	77	77	-38	1bks rusak (-5 input)
22	21	OT-UMSU	01-Apr-26	614005	Kentang	Dine In	1	9000	9000	bolaz 3	11	19	NASI	3459	363	3190	696	3886	-64
23	22	OT-UMSU	01-Apr-26	615001	Paket Dada	Dine In	9	16000	144000	bolaz 2	40	20	DUS NASI					0	0
24	23	OT-UMSU	01-Apr-26	615002	Paket P.Atas	Dine In	6	16000	96000	bolaz 1	39	21	AYAM POTONG	671,1111111	88	660	246	906	-147
25	24	OT-UMSU	01-Apr-26	615003	Paket P.Bawah	Dine In	15	14000	210000	sahur 3	0	22	TEPUNG	277541,1111	60000	290000	64000	354000	-16458,88889
26	25	OT-UMSU	01-Apr-26	615004	Paket Sayap	Dine In	8	13000	104000	sahur 7 (3)	0	23	MINYAK	150022,2222	55000	180000	80000	260000	-54977,77778
27	26	OT-UMSU	01-Apr-26	615005	Paket Geprek Sayap	Dine In	4	15000	60000	sahur 7 (2)	0	24	KULIT	64	24	60	26	86	2
28	27	OT-UMSU	01-Apr-26	615006	Paket Geprek P.Bawah	Dine In	1	16000	16000	Sahur 7 (1)	0
29	28	OT-UMSU	01-Apr-26	615008	Paket Geprek Dada	Dine In	4	19000	76000	Sahur 5 (3)	0
30	29	OT-UMSU	01-Apr-26	616002	Bolaz Geprek P.Bawah	Dine In	1	19000	19000	Sahur 5 (2)	0
31	30	OT-UMSU	01-Apr-26	616003	Bolaz Geprek P.Atas	Dine In	1	21000	21000	Sahur 5 (1)	0
32	31	OT-UMSU	01-Apr-26	616004	Bolaz Geprek Dada	Dine In	3	21000	63000	PAS 2 Syp (1)	0
33	32	OT-UMSU	01-Apr-26	616017	COMBO CLBK 3	Dine In	2	23000	46000
34	33	OT-UMSU	01-Apr-26	617004	Teh Botol Kotak Sosro	Dine In	2	4000	8000	PAS Syp+PA (1)	0
35	34	OT-UMSU	01-Apr-26	617005	S-Tee	Dine In	2	4000	8000	PAS Syp+PA(3)	0
36	35	OT-UMSU	01-Apr-26	617005	S-Tee	Dine In	5	5000	25000	PAS 2 PB (2)	0
37	36	OT-UMSU	01-Apr-26	617006	Air Mineral	Dine In	19	5000	95000
38	37	OT-UMSU	01-Apr-26	617093	Choco malt	Dine In	1	8000	8000	PAS PB+PA (2)	0
39	38	OT-UMSU	01-Apr-26	617094	Orange good	Dine In	2	7000	14000	PAS PB+PA (3)	0
40	39	OT-UMSU	01-Apr-26	621001	Ayam Dada	Take Away	627	13000	8151000
41	40	OT-UMSU	01-Apr-26	621002	Ayam P.Atas	Take Away	229	13000	2977000	ayam G 3	129
42	41	OT-UMSU	01-Apr-26	621003	Ayam P.Bawah	Take Away	644	9000	5796000	ayam G 3	66
43	42	OT-UMSU	01-Apr-26	621004	Ayam Sayap	Take Away	488	9000	4392000	ayam G 2	18
44	43	OT-UMSU	01-Apr-26	621005	AYAM CLBK Dada	Take Away	40	17000	680000	Ayam G 1	36
45	44	OT-UMSU	01-Apr-26	621006	AYAM CLBK P.Atas	Take Away	26	17000	442000	Paket G 1	140
46	45	OT-UMSU	01-Apr-26	621007	AYAM CLBK P.Bawah	Take Away	22	14000	308000	Paket G 2	59
47	46	OT-UMSU	01-Apr-26	621008	AYAM CLBK Sayap	Take Away	31	13000	403000	Paket G 3	312
48	47	OT-UMSU	01-Apr-26	621009	Ayam Geprek Sayap	Take Away	19	13000	247000	Paket G 3	162
49	48	OT-UMSU	01-Apr-26	621010	Ayam Geprek P.Bawah	Take Away	6	14000	84000	bolaz Geprek 3	36
50	49	OT-UMSU	01-Apr-26	621011	Ayam Geprek Dada	Take Away	42	16000	672000	bolaz Geprek 3	13
51	50	OT-UMSU	Apr-26	621012	Ayam Geprek P.Atas	Take Away	25	16000	400000	bolaz Geprek 2	5
52	51	OT-UMSU	Apr-26	622001	Mozzadas Dada Lv 1	Take Away	1	20000	20000	bolaz Geprek 1	6
53	52	OT-UMSU	Apr-26	622002	Mozzadas Dada Lv 2	Take Away	2	20000	40000	Sahur 1 Geprek TK	0
54	53	OT-UMSU	Apr-26	622007	Paket Sadazz Sayap Lv 1	Take Away	1	14000	14000	Sahur 2 Geprek TK	0
55	54	OT-UMSU	Apr-26	622009	Paket Sadazz Sayap Lv 3	Take Away	2	13000	26000	Sahur 3 Geprek TK	0
56	55	OT-UMSU	Apr-26	622010	Sadazz Sayap Lv 1	Take Away	8	12000	96000	Sahur 3A Geprek TK	0
57	56	OT-UMSU	Apr-26	622011	Sadazz Sayap Lv 2	Take Away	13	12000	156000	SkakMat 3	0
58	57	OT-UMSU	Apr-26	622012	Sadazz Sayap Lv 3	Take Away	7	12000	84000	SkakMat 3A	0
59	58	OT-UMSU	Apr-26	622013	Sadazz P.Bawah Lv 1	Take Away	7	13000	91000	SkakMat 2	0
60	59	OT-UMSU	Apr-26	622014	Sadazz P.Bawah Lv 2	Take Away	6	13000	78000	SkakMat 1	0
61	60	OT-UMSU	Apr-26	622015	Sadazz P.Bawah Lv 3	Take Away	8	13000	104000	ayam prekjo dada 3	0
62	61	OT-UMSU	Apr-26	622016	Sadazz P.Atas Lv 1	Take Away	6	15000	90000	ayam prekjo P.atas 3	0
63	62	OT-UMSU	Apr-26	622017	Sadazz P.Atas Lv 2	Take Away	10	15000	150000	ayam prekjo p.b 2	0
64	63	OT-UMSU	Apr-26	622018	Sadazz P.Atas Lv 3	Take Away	11	15000	165000	ayam prekjo sayap 1	0
65	64	OT-UMSU	Apr-26	622019	Sadazz Dada Lv 1	Take Away	6	15000	90000	paket prekjo dada 3	0
66	65	OT-UMSU	Apr-26	622020	Sadazz Dada Lv 2	Take Away	22	15000	330000	paket prekjo P.atas 3	0
67	66	OT-UMSU	Apr-26	622021	Sadazz Dada Lv 3	Take Away	48	15000	720000	paket prekjo p.b 2	0
68	67	OT-UMSU	Apr-26	622022	Paket Sayap PDS Lv 1	Take Away	26	15000	390000	paket prekjo sayap 1	0
69	68	OT-UMSU	Apr-26	622023	Paket Sayap PDS Lv 2	Take Away	35	15000	525000	Ayam CLBK 3	101
70	69	OT-UMSU	Apr-26	622024	Paket Sayap PDS Lv 3	Take Away	21	15000	315000	Ayam CLBK 3	70
71	70	OT-UMSU	Apr-26	622025	Paket P.Bawah PDS Lv 1	Take Away	18	16000	288000	Ayam CLBK 2	30
72	71	OT-UMSU	Apr-26	622026	Paket P.Bawah PDS Lv 2	Take Away	23	16000	368000	Ayam CLBK 1	59
73	72	OT-UMSU	Apr-26	622027	Paket P.Bawah PDS Lv 3	Take Away	10	16000	160000	combo CLBK 1	9
74	73	OT-UMSU	Apr-26	622028	Paket P.Atas PDS Lv 1	Take Away	32	18000	576000	combo CLBK 2	7
75	74	OT-UMSU	Apr-26	622029	Paket P.Atas PDS Lv 2	Take Away	45	18000	810000	combo CLBK 3	22
76	75	OT-UMSU	Apr-26	622030	Paket P.Atas PDS Lv 3	Take Away	24	18000	432000	combo CLBK 1 milo	0
77	76	OT-UMSU	Apr-26	622031	Paket Dada PDS Lv 1	Take Away	28	18000	504000	combo CLBK 2 milo	0
78	77	OT-UMSU	Apr-26	622032	Paket Dada PDS Lv 2	Take Away	47	18000	846000	combo CLBK 3 milo	1
79	78	OT-UMSU	Apr-26	622033	Paket Dada PDS Lv 3	Take Away	46	18000	828000	sds 3	131
80	79	OT-UMSU	Apr-26	622038	New Sadazz 1	Take Away	15	18000	270000	sds 3	50
81	80	OT-UMSU	Apr-26	622039	New Sadazz 2	Take Away	7	19000	133000	sds 2	24
82	81	OT-UMSU	Apr-26	622040	New Sadazz 3	Take Away	38	21000	798000	sds 1	46
83	82	OT-UMSU	Apr-26	623001	Burger Hamer	Take Away	60	10000	600000	new 1	33
84	83	OT-UMSU	Apr-26	623002	Burger Reguler	Take Away	88	12000	1056000	new 2	15
85	84	OT-UMSU	Apr-26	623003	Burger Cheese	Take Away	34	14000	476000	new 3	100
86	85	OT-UMSU	Apr-26	623004	Burger Double Beef	Take Away	27	16000	432000	paket sds 3	169
87	86	OT-UMSU	Apr-26	623005	Burger Premium Cheese	Take Away	11	18000	198000	paket sds 3	123
88	87	OT-UMSU	Apr-26	624001	Saus Sadas	Take Away	10	4500	45000	paket sds 2	57
89	88	OT-UMSU	Apr-26	624002	Sambal Geprek	Take Away	16	4000	64000	paket sds 1	86
90	89	OT-UMSU	Apr-26	624004	Nasi	Take Away	169	5000	845000	midaz 3	17
91	90	OT-UMSU	Apr-26	624005	Kentang	Take Away	17	9000	153000	midaz 3	3
92	91	OT-UMSU	Apr-26	624014	Kunyah Original	Take Away	7	10000	70000	midaz 2	2
93	92	OT-UMSU	Apr-26	624075	Chicken Extra	Take Away	4	67000	268000	midaz 1	3
94	93	OT-UMSU	Apr-26	625001	Paket Dada	Take Away	358	16000	5728000	mikar 3	14
95	94	OT-UMSU	Apr-26	625002	Paket P.Atas	Take Away	261	16000	4176000	mikar 3	3
96	95	OT-UMSU	Apr-26	625003	Paket P.Bawah	Take Away	317	14000	4438000	mikar 2	2
97	96	OT-UMSU	Apr-26	625004	Paket Sayap	Take Away	302	13000	3926000	mikar 1	3
98	97	OT-UMSU	Apr-26	625005	Paket Geprek Sayap	Take Away	75	15000	1125000	miprek 3	3
99	98	OT-UMSU	Apr-26	625006	Paket Geprek P.Bawah	Take Away	37	16000	592000	miprek 3	5
100	99	OT-UMSU	Apr-26	625007	Paket Geprek P.atas	Take Away	77	19000	1463000	miprek 2	5