ABCDEFGHIJKLMNOPQRAXAZBABBBCCICJCKCLCMCNCOCPCQCRCSCTCUCVCWCXCYCZDADBDCDDDEDFDGDHDIDJDKDLDMDNDODPDQDR
1
2
REKAP PENJUALANRekap Orderan
Rekap Barang Minus
3
TglOmsetCashAk - OmsetAv - OmsetExp (Rp)Exp (%)COGS (Rp)
COGS (%)
OLOctoGofood
Shopee Food
Grab FoodProdukTotalNama Bahan BakuHargaQtyTotal ( Rp )Nama Bahan BakuHargaTotalTotal ( Rp )12345678910111213141516171819202122232425262728293031
4
014.446.000 4.446.000 4.446.0004.446.000 #REF!
Mie Pedas Manis Lv 0
150,00%Mie Sabila18.0251.068 Rp 19.250.700 Mie Sabila18.025 -1.927-Rp 34.734.175 -347-257 -49 -13 -107 -15 -117 -20-12-7-15-15 -124 -16 -59 -9-745
5
025.880.000 5.880.000 10.326.0005.163.000 7.967.013#REF!
Mie Pedas Manis Lv 1
5.721.1258,39%
Kulit Pangsit Goreng
12.0891.153 Rp 13.938.617
Kulit Pangsit Goreng
12.089 -6.578-Rp 79.522.953 -1.503-1.152-548 -657 -221-159 -298-180-102-187-0-1.041 -530
6
038.420.000 8.420.000 18.746.0006.248.667 7.949.619#REF!
Mie Pedas Manis Lv 2
13.045.50119,12%Minyak Mie49.014110 Rp 5.391.540 Minyak Mie49.014 -47.247-Rp 2.315.764.458 -2.456-1.064 -1.488-243 -8.277 -10.080 -752-200 -813-1.856 -440 -1.328-126-1.659-197-716 -564-14.988
7
0410.542.900 10.542.900 29.288.9007.322.225 5.750.735#REF!
Mie Pedas Manis Lv 3
7.067.69710,36%Bumbu Basic23.243177 Rp 4.114.011 Bumbu Basic23.243 -26.926-Rp 625.841.018 -364-2.016-444-872-198-512 -2.188 -616-592-688-300 -404-462-1.214 -516 -912-240-253-665-227-177-111-317-170-12.468
8
0510.646.000 10.646.000 39.934.9007.986.980 -2.309.208#REF!
Mie Pedas Gurih Lv 0
3.977.9745,83%Bumbu Mie62.685171 Rp 10.719.135 Bumbu Mie62.685 -31.562-Rp 1.978.463.970 -2.028-2.932 -310 -1.059-407-676 -1.018-263-37 -828 -636 -474-177-14.291 -1.850 -693-3.883
9
0613.003.800 13.003.800 52.938.7008.823.117 13.927.618#REF!
Mie Pedas Gurih Lv 1
3.282.0134,81%Ayam Serbuk70.45548 Rp 3.381.840 Ayam Serbuk70.455 -22.818-Rp 1.607.642.190 -1.035-165-4.093 -8.331 -2.224 -690-6.280
10
0714.696.600 14.696.600 67.635.3009.662.186 3.614.307#REF!
Mie Pedas Gurih Lv 2
6.443.7039,44%Daun Bawang kering161.46014 Rp 2.260.440
Daun Bawang kering
161.460 -16.379-Rp 2.644.472.610 -65-656 -5.104 -821 -2.495 -407 -311 -3 -6.520
11
087.896.800 7.896.800 75.532.1009.441.513 981.842#REF!
Mie Pedas Gurih Lv 3
3.305.9764,85%Bawang Goreng 1kg51.84028 Rp 1.451.520
Bawang Goreng 1kg
51.840 -7.509-Rp 389.266.560 -2.198 -121 -5.190
12
0910.363.800 10.363.800 85.895.9009.543.989 15.375.336#REF! Pangsit Goreng2.201.5353,23%Kecap Sawi40.933114 Rp 4.666.362 Kecap Sawi40.933 -81.079-Rp 3.318.806.707 -4.557 -2.014-1.898-1.366 -19.939 -2.243-1.853-1.957-1.669 -4.642-525-1.380-1.029-860-587-843-2.284-2.007-1.985-1.839-1.986-2.064-1.507-974-19.071
13
107.850.600 7.850.600 93.746.5009.374.650 -4.651.597#REF! Siomay / Dimsum2.497.0883,66%Cabai Salma226.800 Rp - Cabai Salma226.800 Rp -
14
117.461.400 7.461.400 101.207.9009.200.718 5.226.895#REF! Ayam Rambutnya2.610.9983,83%Filling Pangsit ( 15 )17.9091.147 Rp 20.541.623
Filling Pangsit ( 15 )
17.909 -4.875-Rp 87.308.614 -1.422-780 -13 -262 -383-2.015
15
128.611.400 8.611.400 109.819.3009.151.608 3.276.428#REF! Lumpia Ayam280.1320,41%
Filling Udang Rambutan ( 25 )
29.849110 Rp 3.283.390
Filling Udang Rambutan ( 25 )
29.849 -3.689-Rp 110.112.961 -69 -76-1.073-541 -781 -120 -3 -240 -120-24 -3 -312 -279-48
16
1310.363.800 10.363.800 120.183.1009.244.854 6.029.033#REF! Ayam Keju5.415.9717,94%Siomay29.434125 Rp 3.679.250 Siomay29.434 -905-Rp 26.637.770 -117 -15 -104-21 -3-21 -9-19-38 -3-3-3-9 -36 -18 -6-3-477
17
1410.554.800 10.554.800 130.737.9009.338.421 5.748.576#REF! Pangstumi9.129.01313,38%Lumpia Ayam44.402200 Rp 8.880.400 Lumpia Ayam44.402 -1.413-Rp 62.740.026 -86 -80-9-186 -69 -68 -141 -41 -46-57-22-11 -14-39-544
18
158.153.200 8.153.200 138.891.1009.259.407 -6.178.465#REF! Pangsitjumi 0,00%Filling Ayam Keju38.102354 Rp 13.488.108 Filling Ayam Keju38.102 -2.024-Rp 77.118.448 -186-774 -45 -460 -7-8 -3 -93-9 -10 -78 -33-318
19
169.675.600 9.675.600 148.566.7009.285.419 6.500.750#REF! Lycheeti110,00%Minyak Wijen46.0205 Rp 230.100 Minyak Wijen46.020 -28.597-Rp 1.316.033.940 -256-196 -13 -2.282 -232 -21.954-97 -35 -1.314 -2.218
20
177.591.200 7.591.200 156.157.9009.185.759 2.839.017#REF! Manggoti734.1471,08%Minyak Padat346.76416 Rp 5.548.224 Minyak Padat346.764 -287.224-Rp 99.598.769.754 -14.480-14.169-13.863 -9.576-13.402 -43.742 -1.772-3.732 -1.136-4.171-29.106-4.007 -11.206-1.838-0 -31.945 -89.080
21
187.027.800 7.027.800 163.185.7009.065.872 -244.182.810#REF! Lemonti962.3131,41%Wadah Saos 25 ml8.120195 Rp 1.583.400 Wadah Saos 25 ml8.120 -5.980-Rp 48.557.600 -618-168 -63 -362-734 -174 -503 -212 -570-378 -351 -213-298-1.336
22
197.872.400 7.872.400 171.058.1009.003.058 39.044.584#REF! Sodalla1.552.1242,27%Sambal Thailand39.090156 Rp 6.098.040 Sambal Thailand39.090 -52.496-Rp 2.052.068.640 -2.860-860-760-1.940-11.760 -680 -480-12.940 -540 -60-840-240 -200-20-120-3.100-680-840-996 -960-1.760 -9.860
23
208.259.800 8.259.800 179.317.9008.965.895 37.570.927#REF! Matcha Latte 0,00%Paper Lunch810 Rp - Paper Lunch810 Rp -
24
219.333.400 9.333.400 188.651.3008.983.395 187.381.102#REF! Air Mineral 0,00%Box Side Dish458 Rp - Box Side Dish458 Rp -
25
227.903.400 7.903.400 196.554.7008.934.305 4.325.718#REF! Komboh 148Sumpit5.926270 Rp 1.600.020 Sumpit5.926 -11.311-Rp 67.028.986 -1.372 -74 -3.249 -95-556-469 -6-157 -28 -29-518-91-23 -504-4.140
26
237.698.200 7.698.200 204.252.9008.880.561 5.936.209#REF! Komboh 2Mie17.167 Rp - Mie17.167 Rp -
27
246.872.000 6.872.000 211.124.9008.796.871 6.141.199#REF! Komboh 3260.121Pasta CRM Rp - Pasta CRM Rp -
28
259.913.400 9.913.400 221.038.3008.841.532 4.214.552#REF! Mix Dimsum264.036Plastik 159.54555 Rp 524.975 Plastik 159.545 -823-Rp 7.855.535 -2-1-2 -2-1 -20 -7 -1 -734 -11 -2 -3 -37
29
269.481.800 9.481.800 230.520.1008.866.158 5.806.859#REF! Add On Lv 4120.030Plastik 2416.200139 Rp 2.251.800 Plastik 2416.200 -159-Rp 2.575.800 -9-5-5-6-5 -2-16 -3-3-4-5-2-4-2 -4-1 -3-6-5-15 -3 -51
30
277.865.600 7.865.600 238.385.7008.829.100 4.235.209#REF! Add On Lv 540.120Thermal4.050300 Rp 1.215.000 Thermal4.050 -60.168-Rp 243.681.246 -69 -103 -61 -6.984-7.983-44.960 -1 -0-5
31
288.902.200 8.902.200 247.287.9008.831.711 6.883.517#REF! Add On Lv 622.049Black Tea13.65114 Rp 191.114 Black Tea13.651 -7.849-Rp 107.139.874 -103-207 -33-4-11-2.073 -24-12 -470 -157 -12-37-1.951 -12 -151 -2.592
32
297.417.600 7.417.600 254.705.5008.782.948 4.113.616#REF! Packing36.046
Teh Tjatoet Hijau Isi 10
33.26420 Rp 665.280
Teh Tjatoet Hijau Isi 10
33.264 -52.139-Rp 1.734.351.696 -1.973-811 -280-13-11.191 -9.144 -91 -125-1.877 -40-92-6.913 -7.836-3.884-129-16 -7.724
33
307.756.000 7.756.000 262.461.5008.748.717 5.711.955#REF! Chili Oil1
Powder Lychee Squash
87.480 Rp -
Powder Lychee Squash
87.480 Rp -
34
017.787.600 7.787.600 270.249.1008.717.713 23.766.064#REF!
Powder Mango Squash
87.480 Rp -
Powder Mango Squash
87.480 Rp -
35
28Lemon Tea Powder79.33430 Rp 2.380.020
Lemon Tea Powder
79.334 -18.946-Rp 1.503.061.964 -2.370-550-481-419 -6.070 -2.625 -50 -70-209 -125 -13 -5.964
36
Gula Pasir19.440 Rp - Gula Pasir19.440 Rp -
37
Gula Cair Tebu90.25018 Rp 1.624.500 Gula Cair Tebu90.250 -72.273-Rp 6.522.638.250 -4.590-3.990-3.150 -2.150-1.820 -9.230 -3.720 -4.930-205 -5.146-1.444-190-1.970 -150-910-277-193-395-6.103 -1.160-260-20.290
38
Sirup Lychee ABC16.27316 Rp 260.368 Sirup Lychee ABC16.273 -6.605-Rp 107.483.165 -858 -5 -690 -2.802 -27 -369 -203 -369-33 -598 -358 -166-127
39
Sedotan Kecil12.42555 Rp 683.375 Sedotan Kecil12.425 -19.245-Rp 239.119.125 -71-450-26 -83 -4.628 -143 -278-6.448-1.096 -35-2.351 -3 -1.039 -244 -2.350
40
PP Plastik Cup Gosyen 20 Oz
21.276 Rp -
PP Plastik Cup Gosyen 20 Oz
21.276 Rp -
41
Lychee Tea Powder89.60023 Rp 2.060.800
Lychee Tea Powder
89.600 -30.090-Rp 2.696.064.000 -2.522 -1.602-58-280 -968-12.132 -1.342-31 -155-1.355 -39-239 -38-3-241-205-71 -62 -867-555-7.325
42
Mango Tea Powder89.60023 Rp 2.060.800
Mango Tea Powder
89.600 -35.231-Rp 3.156.697.600 -1.449-551-1.370-430-2.512 -1.410-11.217 -768-375-989 -457-775-428-725-375-20-480-998-378-753-374-7-754-386-763-6.487
43
Seal Lid Cup42.6138 Rp 340.904 Seal Lid Cup42.613 -42.612-Rp 1.815.825.156 -42.612
44
Tepung panir18.360 Rp - Tepung panir18.360 Rp -
45
paper lunch box coklat desain
Rp -
paper lunch box coklat desain
Rp -
46
box side dish desain
Rp -
box side dish desain
Rp -
47
Box Ngeumie Desain Baru
249.56952 Rp 12.977.588
Box Ngeumie Desain Baru
249.569 -9.598-Rp 2.395.363.262 -281-336 -5.408-56 -289 -100 -19 -280 -631 -81 -55 -58-17 -295 -46-1.646
48
Box Side Dish Desain Baru
178.05422 Rp 3.917.188
Box Side Dish Desain Baru
178.054 -2.858-Rp 508.878.332 -171-88 -97 -50-107 -37-109 -380 -95-737 -18-7-16-5-34-117 -6-13-12-8-751
49
Kertas Chicken Wrap
Rp -
Kertas Chicken Wrap
Rp -
50
Air Mineral Prima Rp - Air Mineral Prima Rp -
51
Sirup Sarsaparilla GKC 1 L
Rp -
Sirup Sarsaparilla GKC 1 L
Rp -
52
Powder Matcha Flavourista 1kg
Rp -
Powder Matcha Flavourista 1kg
Rp -
53
Premix Keju Rp - Premix Keju Rp -
54
Premix baslup Rp - Premix baslup Rp -
55
Plastik UK 35 Rp - Plastik UK 35 Rp -
56
Plastik UK 40 Rp - Plastik UK 40 Rp -
57
Paperbowl Rp - Paperbowl Rp -
58
Cup polos 14 oz Rp - Cup polos 14 oz Rp -
59
Chili Oil Rp - Chili Oil Rp -
60
Susu UHT Rp - Susu UHT Rp -
61
Baslup Kecil Rp - Baslup Kecil Rp -
62
Sirup Sarsaparilla Rp - Sirup Sarsaparilla Rp -
63
Coca Cola Rp - Coca Cola Rp -
64
Cup 16 Oz Rp - Cup 16 Oz Rp -
65
Cup 18 Oz Rp - Cup 18 Oz Rp -
66
Mie IKR Rp - Mie IKR Rp -
67
Rp - Rp -
68
Rp - Rp -
69
Rp - Rp -
70
Rp - Rp -
71
Rp - Rp -
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