29 Nov 2024 QTY TOTAL ES DEGAN I

❔ Konsumen➖➖➖💙 Ubay C 1
CASH
❔ Pecah Stok P 1
5,000 Es Degan Original O 2 Rp 10,000 TOTAL
❔ ➕ ES BATU E 2 ONLINE
❔ Take Away Reguler R 2 4 T
❔ Kantong Sedang U 1 O
❔ X 1 B
❔ Konsumen➖➖➖💙 Om cino C 1 D
5,000 Degan Tawar + T 1 Rp 5,000 J
2,000 Tanpa Es Z 1 Rp 2,000 L
❔ Take Away Reguler R 1 0 G
❔ Kantong Kecil K 1 N
❔ X 1 A
❔ Konsumen➖➖➖💙 Adek kecil C 1 M
5,000 Es Degan Original O 1 Rp 5,000 S
❔ ➕ ES BATU E 1 R
❔ Take Away Reguler R 1 I
❔ Kantong Kecil K 1 Q
❔ X 1 C
1 Z
1 P
1 W
1 E
1 K
1 U
1 V
1 F
1 Y
1 LU
1 X
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
ES DEGAN INDONESIA
Rp 22,000 LAPORAN KONTROL STOK
Rp 22,000
PRINT
HARIAN
ITEM
Degan Tawar + 1 Sirup in Degan Stok
Es Degan Original 3 Pecah 1 Gula Aren
Es Degan Aren CUP 4 Gula Putih
Es Degan Cocopandan PCH% Jumbo
4.0
Es Degan Jeruk cup / pch Madu
Es Degan Leci % DINE Reguler Cup
Es Degan Mangga % BKS 100% Sealer Cup
Es Degan Melon Copandn
Es Degan Spesial % All Jeruk
+Madu APC 7,333 Leci
+Susu Mangga
Take Away Reguler 4 Melon
Upsize Cup Jumbo
Dine in Straw
Konsumen➖➖➖💙 3 Susu
Tanpa Es 1 BUNGKUS
Pecah Stok 1 0 Hasil Akhir Es
Kelapa Utuh -22
➕ ES BATU 3
Kantong Kecil 2
Kantong Sedang 1
Kantong Besar
Kantong Jumbo
QR Payment
Lumpia
3 29 Nov 2024
 Kantong
ONTROL STOK Kantong Kecil 44 42
Kantong Sedang 54 53
STOK OTW Kantong Besar 70
22 21 Kantong Jumbo -9
25 Madu 0 0
0
38 35 Susu 0 0
0
2 -
82 78
283 279
0
0
12
0
1

69 65
0 0
4
Hasil Akhir Es
-Rp 5,280
Rp 22,000 Rp 50,000 Rp 66,000 138,000

Day NOTE KODE On Stok Reguler

29
Golda I Rp 3,000 Indomaret
Cup Reguler T Rp 24,000 Store
Belanja Alfamart R Rp 33,000 Rokok
Ice Tube E Rp 5,000 Ice Tube

1
Sabun Mandi S Rp 16,000 Skincare

Rokok R Rp 22,000 Rokok

Sent to Tabungan J Rp 10,000 Tabungan

Saldo -Rp 74,000

Friday
Kombinasi Malam L Rp 10,000 Lain-lain
Rokok + Susu R Rp 25,000 Rokok
Bensin B Rp 10,000 Bensin
Alfamart A Rp 4,000 Alfamart

2
Sent to Tabungan J Rp 10,000 Tabungan

Rokok R Rp 18,000 Rokok

Evan L Rp 20,000 Lain-lain

Peskop - Lemon Tea H Rp 16,000 Hangout

Saturday
Isoplus I Rp 3,000 Indomaret
Rokok R Rp 21,000 Rokok
Indomaret I Rp 10,000 Indomaret
Golda A Rp 4,000 Alfamart

3
Degan D Rp 100,000 Degan

Minus Koin -Rp 4,000

Sunday
Ice Tube E Rp 5,000 Ice Tube
Pajak P Rp 2,000 Tax
Golda + Korek I Rp 8,000 Indomaret
Pipit L Rp 5,000 Lain-lain

4
Bensin B Rp 10,000 Bensin
 4 Golda

Rokok
A
R
Rp
Rp
5,000
18,000
Alfamart

Rokok

Kopi Telkom H Rp 8,000 Hangout

Monday
Indomaret I Rp 8,000 Indomaret
Indomaret I Rp 21,000 Indomaret
Bensin B Rp 10,000 Bensin

Tuesday
Es Tube E Rp 6,000 Ice Tube
Plus Koin L -Rp 2,000 Lain-lain
Alfamart R Rp 22,000 Rokok

Wednesday
Rokok R Rp 19,000 Rokok
Golda A Rp 4,000 Alfamart
Es Tube E Rp 6,000 Ice Tube
Pajak P Rp 2,000 Tax

7
Kacang Goreng L Rp 77,000 Lain-lain

Paylater L Rp 20,000 Lain-lain

Golda A Rp 4,000 Alfamart

Rokok R Rp 18,000 Rokok

Thursday
Degan D Rp 100,000 Degan
Straw T Rp 13,000 Store
Motor L Rp 3,000 Lain-lain

8
 Gula T Rp 20,000 Store

8
Pajak P Rp 2,000 Tax

Ice Tube E Rp 5,000 Ice Tube

Rokok R Rp 16,000 Rokok

Hansaplast L Rp 2,000 Lain-lain

Warung Cobek G Rp 14,000 Food

Friday
Bensin B Rp 10,000 Bensin
Es + Koin E Rp 8,000 Ice Tube
Rokok R Rp 20,000 Rokok
Listrik P Rp 24,000 Tax

9
Pajak P Rp 2,000 Tax

Motor L Rp 35,000 Lain-lain

Rokok R Rp 22,000 Rokok

Peskop H Rp 11,000 Hangout

Mbok Re G Rp 7,000 Food

MALAM MINGGU

Saturday
Minus Koin L Rp 2,000 Lain-lain
Rokok R Rp 20,000 Rokok
Soto Sawah G Rp 7,000 Food
Alat Jualan T Rp 10,000 Store

10
Hangout H Rp 9,000 Hangout

Rokok R Rp 17,000 Rokok

Sunday
Golda I Rp 3,000 Indomaret
Ice Tube E Rp 6,000 Ice Tube
Pajak P Rp 2,000 Tax
Golda A Rp 2,000 Rp 2,000 Alfamart

11
Minus Koin L Rp 1,000 Lain-lain

Rokok R Rp 20,000 Rokok

Bensin B Rp 12,000 Bensin

Gula T Rp 18,000 Store

Makan H Rp 18,000 Hangout

Monday
Degan D Rp 100,000 Degan
 Cup T Rp 25,000 Store
Golda A Rp 4,000 Alfamart
Es Batu E Rp 6,000 Ice Tube

12
Tax P Rp 2,000 Tax

Rokok R Rp 19,000 Rokok

Kedai Abah H Rp 13,000 Hangout

Lotion S Rp 29,000 Skincare

Rokok R Rp 17,000 Rokok

Tuesday
Shopee L Rp 63,000 Lain-lain
Tf to Cash L Rp 20,000 -Rp 20,000 Lain-lain
Kopi A Rp 10,000 Alfamart
Pajak P Rp 2,000 Tax

13
Rokok R Rp 17,000 Rokok

Tabungan L Rp 20,000 Lain-lain

Indomaret I Rp 15,000 Indomaret

Hangout H Rp 14,000 Hangout

Rokok R Rp 18,000 Rokok

Wednesday
Jeruk Nipis T Rp 5,000 Store
Ice Tube E Rp 6,000 Ice Tube
Sabun S Rp 12,000 Skincare
Rokok R Rp 23,000 Rokok

14
Plus Salah Hitung L -Rp 20,000 Lain-lain

Bensin B Rp 10,000 Bensin

Thursday
Rokok R Rp 20,000 Rokok
Minus Koin L Rp 2,000 Lain-lain
Hutang Paud L Rp 10,000 Lain-lain
Gula T Rp 21,000 Store

15
Tf From Ewallet -Rp 55,000
Rp 17,000
Rp 2,000 Rp 5,000
-Rp 100,000 Rp 100,000
 Friday
Degan D Rp 100,000 Degan
Es Batu E Rp 6,000 Ice Tube
Golda A Rp 4,000 Alfamart
Listrik P Rp 10,000 Tax

16
Rokok R Rp 21,000 Rokok

Pajak P Rp 2,000 Tax

Golda A Rp 8,000 Alfamart

Rokok R Rp 18,000 Rokok

Bensin B Rp 10,000 Bensin

Saturday
Es Batu E Rp 6,000 Ice Tube
Tax P Rp 2,000 Tax
Straw T Rp 20,000 Store
Rokok R Rp 22,000 Rokok

17

Sunday
Rokok R Rp 22,000 Rokok
Es Batu E Rp 5,000 Ice Tube
Pajak P Rp 1,000 Tax
Hutang Paud L -Rp 10,000 Lain-lain

18
Golda I Rp 4,000 Indomaret

Rokok R Rp 15,000 Rokok

Alfamart A Rp 14,000 Alfamart

Bensin B Rp 10,000 Bensin

Monday
Golda I Rp 4,000 Indomaret
Jeruk Nipis T Rp 3,000 Store

Rp 32,000
-Rp 100,000

19
Rp 15,000
Rp 12,000
Rp 17,000
Rp 4,000 Rp 1,000
 19

Tuesday
Es Batu E Rp 6,000 Ice Tube
Golda A Rp 4,000 Alfamart
Bensin B Rp 10,000 Bensin
Peskop H Rp 25,000 Hangout

20
Gula T Rp 6,000 Rp 12,000 Store

L Rp 22,000 Lain-lain

Cashout isaku -Rp 50,000

Wednesday
Tambal Ban Rp 15,000
Tax Rp 2,000
Rp 25,000
Rp 4,000

21

Thursday
Rokok R Rp 17,000 Rokok
Golda A Rp 5,000 Alfamart
Peskop H Rp 20,000 Hangout
Bensin B Rp 10,000 Bensin

22
Free L -Rp 2,000 Lain-lain

Belanja Lumpia T Rp 57,000 Store

Dana L -Rp 100,000 Lain-lain

Rokok R Rp 17,000 Rokok

Sabun S Rp 22,000 Skincare

-Rp 50,000
Friday
Indomaret I Rp 6,000 Indomaret
Lotion S Rp 25,000 Skincare
Rokok R Rp 18,000 Rokok
Lupa L Rp 24,000 Lain-lain

23
From ngger L -Rp 150,000 Lain-lain

Golda A Rp 4,000 Alfamart

23 Bensin B Rp 10,000 Bensin

-Rp 150,000
Saturday
Degan D Rp 100,000 Rp 20,000 Degan
Nasi Padang G Rp 10,000 Food
Es Batu E Rp 6,000 Ice Tube
Golda I Rp 1,000 Indomaret

24
Rokok R Rp 17,000 Rokok

Hangout H Rp 10,000 Hangout

Sunday
Oli L Rp 45,000 Lain-lain
Klakson L Rp 20,000 Lain-lain
Bensin B Rp 35,000 Bensin
Cup Reguler T Rp 25,000 Store

25
Rokok R Rp 22,000 Rp 2,000 Rokok

Uang Pemilu L -Rp 150,000 Lain-lain

Monday
Es Batu E Rp 6,000 Ice Tube
Golda I Rp 5,000 Indomaret
Listrik P Rp 10,000 Tax
Minus Koin L Rp 1,000 Lain-lain

26
Gula T Rp 21,000 Store

Rokok R Rp 16,000 Rokok

Ningsih H Rp 8,000 Hangout

Mbok Re G Rp 14,000 Food

Golda I Rp 4,000 Indomaret

Tuesday
Rokok R Rp 22,000 Rokok
Es Batu E Rp 5,000 Ice Tube
Wizmee G Rp 1,000 Rp 23,000 Food
Minus Koin L Rp 2,000 Lain-lain

27
 27
Bensin B Rp 15,000 Bensin

Rokok R Rp 16,000 Rokok

Golda A Rp 12,000 Alfamart

Teh Jumbo H Rp 4,000 Hangout

Wednesday
Lupa L Rp 10,000 Lain-lain
Peskop H Rp 10,000 Hangout
Rokok L Rp 17,000 Lain-lain
Golda I Rp 8,000 Indomaret

28
Degan D Rp 100,000 Degan

Lupa L Rp 17,000 Lain-lain

Thursday
Tax P Rp 2,000 Tax

29

Friday

30

31
31

Rp 524,000 Rp 1,587,000
138,000

Nov 2024
1 -Rp 50,000 Rp 89,000 Friday 1
2 Rp - Rp 113,000 Saturday 2
3 Rp 100,000 Rp 34,000 Sunday 3
4 Rp - Rp 61,000 Monday 4
5 Rp - Rp 39,000 Tuesday 5
6 Rp - Rp 26,000 Wednesday 6
7 Rp - Rp 150,000 Thursday 7
8 Rp 140,000 Rp 35,000 Friday 8
9 Rp 97,000 Rp 42,000 Saturday 9
10 Rp 37,000 Rp 28,000 Sunday 10
11 Rp 13,000 Rp 71,000 Monday 11
12 Rp 100,000 Rp 115,000 Tuesday 12
13 Rp 84,000 Rp 75,000 Wednesday 13
14 Rp 11,000 Rp 25,000 Thursday 14
15 -Rp 98,000 Rp 120,000 Friday 15
16 Rp 120,000 Rp 59,000 Saturday 16
17 Rp - Rp 50,000 Sunday 17
18 Rp - Rp 61,000 Monday 18
19 Rp 4,000 -Rp 16,000 Tuesday 19
20 Rp 16,000 Rp 19,000 Wednesday 20
21 Rp - Rp 46,000 Thursday 21
22 -Rp 50,000 Rp 46,000 Friday 22
23 -Rp 300,000 Rp 87,000 Saturday 23
24 Rp 100,000 Rp 64,000 Sunday 24
25 Rp 82,000 -Rp 83,000 Monday 25
26 Rp 12,000 Rp 73,000 Tuesday 26
27 Rp 6,000 Rp 94,000 Wednesday 27
28 Rp 100,000 Rp 62,000 Thursday 28
29 Rp - Rp 2,000 Friday 29
30 Rp - Rp -
31 Rp - Rp -
524,000 1,587,000
STOK REGULER

Item Stok Reguler Total

D Degan 600,000 20,000 Rp 620,000
R Rokok 77,000 593,000 Rp 670,000
I Indomaret 8,000 95,000 Rp 103,000
 A Alfamart 20,000 70,000 Rp 90,000
B Bensin 45,000 117,000 Rp 162,000
S Skincare 104,000 Rp 104,000
G Food 8,000 68,000 Rp 76,000
E Ice Tube 48,000 45,000 Rp 93,000
T Store 93,000 187,000 Rp 280,000
P Tax 42,000 23,000 Rp 65,000
H Hangout 25,000 141,000 Rp 166,000
L Lain-lain - 74,000 68,000 -Rp 6,000
J Tabungan 20,000 Rp 20,000

Tanggal Kode Keterangan Nominal

Berikut adalah
keterangan
tambahan biaya lain
lain
Cash Stok 50,000 : Total modal kerja, hasil dari Total CoT Reguler
Cash Reguler 66,000 : Total Uang Pribadi. Sisa Modal Kerja Aktif
Grand Total Wallet 116,000 : Grand Total Uang di Wallet

E-Wallet 104,756
Tabungan 0
otal CoT Reguler
l Kerja Aktif
29 Nov 2024
BULAN
NOMOR STATUS STD APC DAY TANGGAL INCOME E-PAYMENT
LALU

1 OPEN 5 9,600 Friday 01 November 2024 215,000 48,000 -

2 OPEN 8 9,750 Saturday 02 November 2024 79,000 78,000 25,000
3 CLOSE LIBUR Sunday 03 November 2024 140,000 LIBUR -
4 OPEN 12 9,667 Monday 04 November 2024 92,000 116,000 -
5 CLOSE LIBUR Tuesday 05 November 2024 Libur LIBUR -
6 OPEN 16 12,438 Wednesday 06 November 2024 Libur 199,000 24,000
7 OPEN 13 9,077 Thursday 07 November 2024 167,000 118,000 12,000
8 OPEN 12 11,833 Friday 08 November 2024 90,000 142,000 20,000
9 OPEN 8 6,500 Saturday 09 November 2024 140,000 52,000 -
10 OPEN 9 9,778 Sunday 10 November 2024 116,000 88,000 28,000
11 OPEN 3 46,000 Monday 11 November 2024 95,000 138,000 -
12 OPEN 7 9,429 Tuesday 12 November 2024 161,000 66,000 20,000
13 OPEN 13 9,077 Wednesday 13 November 2024 143,000 118,000 10,000
14 OPEN 5 16,400 Thursday 14 November 2024 138,000 82,000 15,000
15 OPEN 9 8,000 Friday 15 November 2024 124,000 72,000 -
16 OPEN 6 14,000 Saturday 16 November 2024 110,000 84,000 31,000
17 OPEN 10 14,500 Sunday 17 November 2024 70,000 145,000 85,000
18 OPEN 3 17,667 Monday 18 November 2024 175,000 53,000 -
19 OPEN 2 7,500 Tuesday 19 November 2024 106,000 15,000 -
20 OPEN 6 8,000 Wednesday 20 November 2024 Libur 48,000 25,000
21 CLOSE LIBUR Thursday 21 November 2024 164,000 LIBUR -
22 CLOSE LIBUR Friday 22 November 2024 41,000 LIBUR -
23 OPEN 1 45,000 Saturday 23 November 2024 84,000 45,000 -
24 OPEN 11 13,909 Sunday 24 November 2024 75,000 153,000 42,000
 25 CLOSE LIBUR Monday 25 November 2024 103,000 LIBUR -
26 OPEN 12 9,250 Tuesday 26 November 2024 99,000 111,000 13,000
27 OPEN 9 9,778 Wednesday 27 November 2024 155,000 88,000 39,000
28 OPEN 1 15,000 Thursday 28 November 2024 122,000 15,000 -
29 CLOSE LIBUR Friday 29 November 2024 147,000 -
30 53,000 -
31 93,000 -

GRAND TOTAL 181 Rp 11,459 3,297,000 Rp 2,074,000 Rp 389,000

8 Jangan Lupa Atur Jam

Rekapitulasi Bulan ini
Sales Terendah Rp 15,000
Sales Tertinggi Rp 199,000 01 sd 05 Rp 242,000
Total LIBUR 6 06 sd 12 Rp 803,000
Total Hari Kerja 23 13 sd 19 Rp 569,000
APC BULAN INI Rp 90,174 20 sd 26 Rp 357,000
APC Bulan Lalu Rp 117,750 27 sd 30 Rp 103,000
Target Bulan ini Rp 2,800,000
Sisa Target Rp 726,000

Target Harian Rp 726,000 30 Rekapitulasi Bulan Lalu

Hari Sales
Kolom Putih TIDAK DI ISI Selasa 215,000
KETERANGAN Rumus Rabu 79,000
STATUS Keterangan Buka / Tidak - Kamis 140,000
STD Jumlah Struk Terbaca Aplikasi Jumat 92,000
APC Rata-Rata per customer Income / STD Sabtu
DAY Hari Berlaku - Minggu
TANGGAL Tanggal Berjalan - Senin 167,000
BULAN LALU Penjualan Bulan Lalu (Income) - Selasa 90,000
INCOME Jumlah Penjualan - Rabu 140,000
E-PAYMENT Pembayaran Non-Tunai - Kamis 116,000
 Uang yang masuk ke Saldo
Transfer Saldo Penjualan - Jumat 95,000
HPP KELUAR TotalUang
Sisa Pengeluaran Kotor
setelah dimasukkan - Sabtu 161,000
SISA CASH SALDO In Cash - Masuk Saldo Minggu 143,000
KELUAR REGULER Nilai Uang Keluar - Senin 138,000
CASH INPUT TotalCash
Nilai UangReguler
Cash / Pendapatan Selasa 124,000
MASUK CASH (FREE) Lain Lain Aplikasi Rabu 110,000
ALL OF CASH Total Uang Cash Income - EWallet Kamis 70,000
CATATAN Keterangan Note Jumat 175,000
CUP Jumlah Cup Hari Ini (Saldo+Sisa Cash Masuk+Masuk)-Keluar Sabtu 106,000
PCH Jumlah Pecah Stok Aplikasi Minggu
IN-OUT Hasil Pembagian Kelapa Aplikasi Senin 164,000
TA Jumlah Cup Reguler Keluar Cup / PCH Selasa 41,000
UPSIZE Jumlah Cup Jumbo Keluar Note Rabu 84,000
Tawar Es Degan Tawar Note Kamis 75,000
Original Original Note Jumat 103,000
AREN Es Degan Aren (Masuk DG-PCH)+Sisa DG Kemarin Sabtu 99,000
SIRUP Es Degan Sirup Income - SPD REAL Minggu 155,000
NO ICE Tambahan Tanpa Es Margin Kotor asli + untung Asli Senin 122,000
SPC Es Degan Spesial Selasa 147,000
UTUH Kelapa Utuh Rabu 53,000
MARGIN KOTOR Total HPP Keluar Kamis 93,000
STOK IN DEGAN Stok Pembelian Degan

STOK DEGAN Stok Degan Terkini

PEMASUKAN LAINNYA Pendapatan Lain Lain

REAL SPD HARIAN Margin Kotor + Pengeluaran HPP Margin (1) + Keluar (1)
ESTIMASI SALDO Estimasi Penjualan berdasarkan Stok Degan

HARGA DEGAN (2) Harga Degan berdasarkan Pembagian Degan

UNREAL ORI DEGAN Untuk mengurangi Selisih

REAL OUT (2) (HPP Keluar - Unreal Degan Ori) + Harga Degan (2) * Jumlah Cup
HPP KELUAR x
SELISIH (2) HPP Keluar 1 - Real Out

REAL MARGIN (2) HPP Margin - Real Out

HPP UPDATE Harga Update Terkini berdasarkan Pembelian Update

REAL OUT SESUAI (HPP Keluar - Unreal Degan Ori) + Harga Degan (3) Update * Jumlah Cup
SELISIH SESUAI
MARGIN SESUAI
Buka
Close
Durasi
Transfer KELUAR CASH MASUK ALL OF
HPP KELUAR SISA CASH CATATAN CUP PCH IN-OUT
Saldo REGULER INPUT CASH (FREE) CASH

Rp 24,411 Rp 48,000 89,000 48,000 187,000 146,000 Mendung 8 2 4.0

50,000 Rp 42,331 Rp 3,000 113,000 53,000 55,000 91,000 Weekend 14 4 3.5
0 34,000 57,000 Off Day 0
50,000 Rp 63,639 Rp 66,000 61,000 116,000 62,000 20 5 4.0
0 39,000 23,000 Off Day 0
50,000 Rp 103,553 Rp 125,000 26,000 175,000 5,000 127,000 34 8 4.3
75,000 Rp 69,436 Rp 31,000 150,000 106,000 8,000 Hujan 14.00 22 6 3.7
75,000 Rp 80,031 Rp 47,000 35,000 122,000 20,000 26 6 4.3
30,000 Rp 30,708 Rp 22,000 42,000 52,000 - Hujan 10 3 3.3
32,000 Rp 50,388 Rp 28,000 28,000 60,000 - 17 5 3.4
75,000 Rp 79,797 Rp 63,000 71,000 138,000 100,000 92,000 20cup Asrama 22 7 3.1
40,000 Rp 37,561 Rp 6,000 115,000 46,000 60,000 43,000 12 3 4.0
70,000 Rp 69,019 Rp 38,000 75,000 108,000 6,000 Hujan jam 2 22 5 4.4
Rp 48,469 Rp 67,000 25,000 67,000 48,000 Mendung 14 4 3.5
Rp 41,682 Rp 72,000 120,000 72,000 - Mendung jam 9 13 4 3.3
7,000 Rp 45,118 Rp 46,000 59,000 53,000 50,000 37,000 Hutang 50 15 4 3.8
20,000 Rp 81,901 Rp 40,000 50,000 60,000 27,000 Hutang 62000 27 8 3.4
Rp 30,032 Rp 53,000 61,000 53,000 19,000 Hutang 24000 9 5 1.8
Rp 9,029 Rp 15,000 - 16,000 15,000 50,000 3 0
Rp 20,013 Rp 23,000 19,000 23,000 54,000 7 2 3.5
0 46,000 100,000 108,000 Off Day 0
0 46,000 62,000 Off Day 0
Rp 20,725 Rp 45,000 87,000 45,000 20,000 6 7 0.9
Rp 91,458 Rp 111,000 64,000 111,000 67,000 30 10 3.0
 0 - 83,000 150,000 0
Rp 63,176 Rp 98,000 73,000 98,000 175,000 21 7 3.0
Rp 46,479 Rp 49,000 94,000 49,000 130,000 15 4 3.8
0 62,000 68,000 S: Lumpia/hujan 0
0 2,000 66,000 0
0 0
0 0

Rp 50,000 Rp 1,148,957 Rp 925,043 Rp 1,587,000 Rp1,670,000 Rp 557,000 66,000 367 109 3.4

Total [Link] Margin Bulan ini 17 3,010

AVG HPP

Hari (On) Sales (On) Lumpia

Friday 48,000 1
Saturday 78,000 2
Sunday LIBUR 3
Monday 116,000 4
Tuesday LIBUR 5
Wednesday 199,000 6
Thursday 118,000 7
Friday 142,000 8
Saturday 52,000 9
Sunday 88,000 10
 Monday 138,000 11
Tuesday 66,000 12
Wednesday 118,000 13
Thursday 82,000 14
Friday 72,000 15
Saturday 84,000 16
Sunday 145,000 17
Monday 53,000 18
Tuesday 15,000 19
Wednesday 48,000 20
Thursday LIBUR 21
Friday LIBUR 22 1
Saturday 45,000 23
Sunday 153,000 24
Monday LIBUR 25
Tuesday 111,000 26
Wednesday 88,000 27
Thursday 15,000 28 3
Friday 29
30
31
4
 MARGIN STOK IN PEMASUKAN
TA UPSIZE Tawar Original AREN SIRUP NO ICE SPC UTUH STOK DEGAN
KOTOR DEGAN LAINNYA

4 2 2 5 1 - 1 - - Rp 17,589 9 7 6,000
9 2 3 10 - 1 1 - - Rp 29,669 3 6,000
- - - - - - - 18 21
14 2 4 16 - - 5 - - Rp 46,361 16 6,000
- - - - - - - 16
18 5 9 23 - 2 4 - - Rp 74,447 8 21,000
13 2 20 - - 4 - - Rp 48,564 2 -
19 2 1 19 4 2 1 - - Rp 51,969 19 15 10,000
8 1 9 - - 1 - - Rp 21,292 12 -
12 1 2 15 - - - - - Rp 34,613 7 3,000
22 2 19 - 1 14 - - Rp 58,203 - -
9 4 8 - - 3 - - Rp 28,439 18 15 -
17 4 17 - 1 4 - - Rp 48,981 10 -
13 - 11 3 - 6 - - Rp 33,531 6 -
7 1 1 8 2 2 2 - - Rp 27,318 2 3,000
3 3 1 13 - 1 - - - Rp 29,882 26 24 9,000
23 2 3 19 4 1 1 - - Rp 55,099 16 8,000
9 3 5 1 - 4 - - Rp 22,968 11 -
3 - 3 - - - - - Rp 5,971 11 -
4 3 3 3 1 - - - - Rp 14,988 - 1 8 13,000
- - - - - - - 8
- - - - - - - 8
6 6 - - - 5 - - Rp 19,275 1 5,000
20 2 1 24 5 - 1 - - Rp 60,542 24 15 1,000
 - - - - - - - 15
17 2 1 19 - 1 - - - Rp 41,824 8 6,000
8 3 2 12 1 - 2 - - Rp 32,521 4 9,000
- - - - - - - 18 22
- - - - - - - 22
- - - - - - -
- - - - - - -

258 30 55 278 22 12 59 0 0 804,043 131 Rp 106,000

MARGIN 2,379 1,990 1,879 1,629 1,000 2,379 6,000

HPP OUT 2,621 3,010 3,121 3,371 1,000 4,621 6,000
Harga Jual 5,000 5,000 5,000 5,000 2,000 7,000 12,000
 HARGA DEGAN UNREAL ORI REAL MARGIN
REAL SPD HARIAN ESTIMASI SALDO REAL OUT (2) SELISIH (2) HPP UPDATE
(2) DEGAN (2)

Rp 42,000 Rp 135,000 1,500 16,000 Rp 20,411 Rp 4,000 27,589 1,250

Rp 72,000 Rp 105,000 1,714 28,000 Rp 38,331 Rp 4,000 39,669 1,429
Rp 315,000
Rp 110,000 Rp 315,000 1,500 40,000 Rp 53,639 Rp 10,000 62,361 1,389
Rp 240,000
Rp 178,000 Rp 240,000 1,412 68,000 Rp 83,553 Rp 20,000 115,447 1,307
Rp 118,000 Rp 120,000 1,636 44,000 Rp 61,436 Rp 8,000 56,564 1,515
Rp 132,000 Rp 315,000 1,385 52,000 Rp 64,031 Rp 16,000 77,969 1,215
Rp 52,000 Rp 225,000 1,800 20,000 Rp 28,708 Rp 2,000 23,292 1,579
Rp 85,000 Rp 180,000 1,765 34,000 Rp 46,388 Rp 4,000 41,613 1,548
Rp 138,000 Rp 105,000 1,909 44,000 Rp 77,797 Rp 2,000 60,203 1,675
Rp 66,000 Rp 270,000 1,500 24,000 Rp 31,561 Rp 6,000 34,439 1,389
Rp 118,000 Rp 225,000 1,364 44,000 Rp 55,019 Rp 14,000 62,981 1,263
Rp 82,000 Rp 150,000 1,714 28,000 Rp 44,469 Rp 4,000 37,531 1,587
Rp 69,000 Rp 90,000 1,846 26,000 Rp 39,682 Rp 2,000 32,318 1,709
Rp 75,000 Rp 420,000 1,600 30,000 Rp 39,118 Rp 6,000 44,882 988
Rp 137,000 Rp 360,000 1,778 54,000 Rp 75,901 Rp 6,000 69,099 1,097
Rp 53,000 Rp 240,000 3,333 18,000 Rp 42,032 -Rp 12,000 10,968 2,058
Rp 15,000 Rp 165,000 0 6,000 Rp 3,029 Rp 6,000 11,971
Rp 35,000 Rp 150,000 1,714 14,000 Rp 18,013 Rp 2,000 29,988 1,058
Rp 120,000
Rp 120,000
Rp 40,000 Rp 120,000 7,000 12,000 Rp 50,725 -Rp 30,000 - 5,725 4,321
Rp 152,000 Rp 375,000 2,000 60,000 Rp 91,458 Rp - 61,542 1,667
 Rp 225,000
Rp 105,000 Rp 225,000 2,000 42,000 Rp 63,176 Rp - 47,824 1,667
Rp 79,000 Rp 120,000 1,600 30,000 Rp 40,479 Rp 6,000 47,521 1,333
Rp 330,000
Rp 330,000

Rp 1,953,000 1,912 Rp 48,589 Rp 80,000 Rp 990,043 Rp 33,043

Berdasarkan Jumlah Hitungan Sesu

REAL OUT SELISIH
MARGIN SESUAI Buka Close Durasi
SESUAI SESUAI

18,411 6,000 29,589 9 15 6

34,331 8,000 43,669 10 15 5
0 0
51,417 12,222 64,583 10 17 7

79,997 23,556 119,003 9 15 6

58,769 10,667 59,231 9 15 6
59,610 20,421 82,390 9 15 6
26,498 4,211 25,502 9 16 7
42,703 7,684 45,297 10 15 5
72,639 7,158 65,361 10 15 5
30,228 7,333 35,772 11 15 4
52,797 16,222 65,203 8 15.5 7.5
42,692 5,778 39,308 10 16 6
37,904 3,778 34,096 9 15 6
29,933 15,185 54,067 9 15.5 6.5
57,531 24,370 87,469 9 15 6
30,550 - 519 22,450 9 16 7
10 15 5
13,420 6,593 34,580 9 14 5

34,651 - 13,926 10,349

81,458 10,000 71,542
 56,176 7,000 54,824 10 16 6
36,479 10,000 51,521 10 14 4

10 15 5

Rp 948,195 191,733 Rp 1,095,805 121

5.0

Berdasarkan Jumlah Hitungan Sesuai Update

 29 STOK BULAN INI

SKU 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Degan Stok X 2 4 - 5 - 8 6 6 3 5 7 3 5 4 4 4
Gula Aren 17 1 - - - - - - 4 - - - - - 3 2 -
Gula Putih 28 5 10 - 16 - 23 20 19 9 15 19 8 17 11 8 13
Jumbo 28 2 2 - 2 - 5 - 2 - 1 - - - - 1 3
Madu 6 - - - - - 1 - 2 - - - - - - - -
Reguler Cup 39 4 9 - 14 - 18 13 19 8 12 22 9 17 13 7 3
Sealer Cup 571 6 11 - 16 - 23 13 21 8 13 22 9 17 13 8 6
Copandn 3 - - - - - - - 2 - - - - - - - 1
Jeruk 3 - - - - - 1 - - - - - - - - 2 -
Leci 14 - 1 - - - - - - - - - - - - - -
Mangga 0 - - - - - - - - - - - - - - - -
Melon 5 - - - - - 1 - - - - 1 - 1 - - -
Straw 10 6 11 - 16 - 23 13 21 8 13 22 9 17 13 8 6
Susu 5 - - - - - 2 - - - - - - - - - -
Ice Tube 1 1 1 1 1 1 1 1

MASUK STOK
Pembelian
Degan Stok 9 18 19 18 26
Gula Aren
Gula Putih 45 45 45 45
Jumbo
Madu
Reguler Cup 100 100
Sealer Cup
Copandn
Jeruk
Leci
Mangga
Melon
Straw 150
Susu
Ice Tube

STOK MINUS
(-) jika stok plus 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

Gula Aren
Gula Putih -3 -15
Jumbo
Madu
Reguler Cup -1
Sealer Cup
Copandn
Jeruk
Leci
Mangga
Melon
Straw -59 12
Susu 1 1
Ice Tube

Sales
K. Kecil -43 2 1 0 5 0 9 0 0 2 2 8 2 3 4 4 5
K. Sdg 100 1 2 0 4 0 4 1 6 2 1 0 1 3 4 1 0
K. Besar 99 0 1 0 0 0 1 1 6 0 2 0 2 3 5 0 0
K. Jmbo -2 0 0 0 0 0 0 0 0 0 0 5 0 2 0 0 0

Stok in Out
K. Kecil 150
K. Sdg
K. Besar
K. Jmbo

PLU

Degan Stok P 101

Gula Aren B 102
Gula Putih O 103
Jumbo U 104
Madu M 105
Reguler Cup W 106
Sealer Cup W 107
Cocopandan D 108
Jeruk J 109
Leci L 110
Mangga G 111
Melon N 112
Straw W 113
Susu S 114
Ice Tube E 115
Kantong Kecil K 116
Kantong Sedang U 117
Kantong Besar V 118
Kantong Jumbo F 119
17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 ALL ST
8 5 - 2 - - 7 10 - 7 4 - - - - 109 22
4 1 - 1 - - - 5 - - 1 - - - - 22 25
19 5 3 3 - - - 24 - 19 12 - - - - 278 38
2 - - 3 - - - 2 - 2 3 - - - - 30 0
1 - - - - - - - - - - - - - - 4 2
23 9 3 4 - - 6 20 - 17 8 - - - - 258 82
25 9 3 7 - - 6 22 - 19 11 - - - - 288 283
- - - - - - - - - - - - - - - 3 0
- - - - - - - - - - - - - - - 3 0
1 - - - - - - - - - - - - - - 2 12
- - - - - - - - - - - - - - - 0 0
- - - - - - - - - 1 - - - - - 4 1
25 9 3 7 - - 6 22 - 19 11 - - - - 288 69
- - - 1 - - - - - - - - - - - 3 0
1 1 10

-1 24 18 131
30 30
45 45 270
0
0
100 300
0
0
0
0
0
0
150 300
0
0

17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 TOTAL
0
0
-18
-2 -2
0
-1
0
 0
0
0
0
0
-47
2
0

3 1 0 4 0 0 0 2 0 6 0 0 0 0 0 63 44
2 3 0 1 0 0 0 3 0 4 3 0 0 0 0 46 54
3 0 0 0 0 0 2 2 0 0 1 0 0 0 0 29 70
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 -9

150
0
0
0
 HARGA Aktiva 1 2 3 4
Rp 6,000 132,000 12,000 24,000 0 30,000
Rp 500 12,500 500 0 0 0
Rp 389 14,778 1,944 3,889 0 6,222
Rp 270 0 540 540 0 540
Rp 833 1,667 0 0 0 0
Rp 250 20,500 1,000 2,250 0 3,500
Rp 47 13,301 282 517 0 752
Rp 750 0 0 0 0 0
Rp 750 0 0 0 0 0
Rp 750 9,000 0 750 0 0
Rp 750 0 0 0 0 0
Rp 750 750 0 0 0 0
Rp 50 3,450 300 550 0 800
Rp 1,333 0 0 0 0 0
Rp 6,000 0 6,000 0 0 6,000

Rp 207,945 22,566 32,496 0 47,814

Rp 6,000 Rp 786,000 54,000 0 108,000 0

Rp 500 Rp 15,000 0 0 0 0
Rp 389 Rp 105,000 0 0 0 0
Rp 270 Rp - 0 0 0 0
Rp 833 Rp - 0 0 0 0
Rp 250 Rp 75,000 25,000 0 0 0
Rp 47 Rp - 0 0 0 0
Rp 750 Rp - 0 0 0 0
Rp 750 Rp - 0 0 0 0
Rp 750 Rp - 0 0 0 0
Rp 750 Rp - 0 0 0 0
Rp 750 Rp - 0 0 0 0
Rp 50 Rp 15,000 0 0 0 0
Rp 1,333 Rp - 0 0 0 0
Rp 6,000 Rp - 0 0 0 0

79,000 0 108,000 0

101,566 32,496 108,000 47,814

Rp 6,000 Rp - 0 0 0 0
Rp 500 Rp - 0 0 0 0
Rp 389 -Rp 7,000 0 0 0 0
Rp 270 -Rp 540 0 0 0 0
Rp 833 Rp - 0 0 0 0
Rp 250 -Rp 250 0 0 0 0
Rp 47 Rp - 0 0 0 0
Rp 750 Rp - 0 0 0 0
Rp 750 Rp - 0 0 0 0
Rp 750 Rp - 0 0 0 0
Rp 750 Rp - 0 0 0 0
Rp 750 Rp - 0 0 0 0
Rp 50 -Rp 2,350 0 0 0 0
Rp 1,333 Rp 2,667 0 0 0 0
Rp 6,000 Rp - 0 0 0 0

0 0 0 0

101,566 32,496 108,000 47,814

Rp 45 Rp 1,980 90 45 0 225
Rp 30 Rp 1,620 30 60 0 120
Rp 60 Rp 4,200 0 60 0 0
Rp 80 -Rp 720 0 0 0 0
120 165 0 345

Rp 30 0 0 0 0 0
Rp 30 0 0 0 0 0
Rp 60 0 0 0 0 0
Rp 80 0 0 0 0 0
0 0 0 0
Sales Rp 48,000 Rp 78,000 LIBUR Rp 116,000

Margin Kotor -Rp 53,686 Rp 45,339 Off Day Rp 67,841

5 6 7 8 9
0 48,000 36,000 36,000 18,000
0 0 0 2,000 0
0 8,944 7,778 7,389 3,500
0 1,350 0 540 0
0 833 0 1,667 0
0 4,500 3,250 4,750 2,000
0 1,081 611 987 376
0 0 0 1,500 0
0 750 0 0 0
0 0 0 0 0
0 0 0 0 0
0 750 0 0 0
0 1,150 650 1,050 400
0 2,667 0 0 0
0 0 6,000 6,000 6,000

0 70,025 54,289 61,883 30,276

0 0 0 114,000 0
0 0 0 0 0
0 17,500 0 17,500 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 7,500 0
0 0 0 0 0
0 0 0 0 0

0 17,500 0 139,000 0

- 87,525 54,289 200,883 30,276

0 0 0 0 0
0 0 0 0 0
0 -1,167 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 -2,950 0
0 0 0 0 0
0 0 0 0 0

0 -1,167 0 -2,950 0

- 86,359 54,289 197,933 30,276

0 405 0 0 90
0 120 30 180 60
0 60 60 360 0
0 0 0 0 0
0 585 90 540 150

0 4,500 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 4,500 0 0 0
LIBUR Rp 199,000 Rp 118,000 Rp 142,000 Rp 52,000

Off Day Rp 107,556 Rp 63,621 -Rp 56,473 Rp 21,574

10 11 12 13 14
30,000 42,000 18,000 30,000 24,000
0 0 0 0 1,500
5,833 7,389 3,111 6,611 4,278
270 0 0 0 0
0 0 0 0 0
3,000 5,500 2,250 4,250 3,250
611 1,034 423 799 611
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 750 0 750 0
650 1,100 450 850 650
0 0 0 0 0
0 6,000 6,000 0 0

40,364 63,773 30,234 43,260 34,289

0 0 108,000 0 0
0 0 0 0 0
0 0 17,500 0 0
0 0 0 0 0
0 0 0 0 0
0 0 25,000 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0

0 0 150,500 0 0

40,364 63,773 180,734 43,260 34,289

0 0 0 0 0
0 0 0 0 0
0 -5,833 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 -250 0 0
0 0 0 0 0
 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 1,333 1,333 0 0
0 0 0 0 0

0 -4,500 1,083 0 0

40,364 59,273 181,817 43,260 34,289

90 360 90 135 180

30 0 30 90 120
120 0 120 180 300
0 400 0 160 0
240 760 240 565 600

0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Rp 88,000 Rp 138,000 Rp 66,000 Rp 118,000 Rp 82,000

Rp 47,396 Rp 77,967 -Rp 116,057 Rp 74,175 Rp 47,111

15 16 17 18 19
24,000 24,000 48,000 30,000 0
1,000 0 2,000 500 0
3,111 5,056 7,389 1,944 1,167
270 810 540 0 0
0 0 833 0 0
1,750 750 5,750 2,250 750
376 282 1,175 423 141
0 750 0 0 0
1,500 0 0 0 0
0 0 750 0 0
0 0 0 0 0
0 0 0 0 0
400 300 1,250 450 150
0 0 0 0 0
6,000 0 6,000 0 0

38,407 31,948 73,687 35,567 2,208

0 156,000 0 0 0
0 0 15,000 0 0
0 17,500 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 7,500 0 0
0 0 0 0 0
0 0 0 0 0

0 173,500 22,500 0 0

38,407 205,448 96,187 35,567 2,208

0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 600 0 0 0
0 0 0 0 0
0 0 0 0 0

0 600 0 0 0

38,407 206,048 96,187 35,567 2,208

180 225 135 45 0

30 0 60 90 0
0 0 180 0 0
0 0 0 0 0
210 225 375 135 0

0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Rp 72,000 Rp 84,000 Rp 145,000 Rp 53,000 Rp 15,000

Rp 33,383 -Rp 122,273 Rp 48,438 Rp 17,298 Rp 12,792

20 21 22 23 24
12,000 0 0 42,000 60,000
500 0 0 0 2,500
1,167 0 0 0 9,333
810 0 0 0 540
0 0 0 0 0
1,000 0 0 1,500 5,000
329 0 0 282 1,034
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
350 0 0 300 1,100
1,333 0 0 0 0
0 0 0 0 0

17,489 0 0 44,082 79,507

-6,000 0 0 0 144,000
0 0 0 0 0
0 17,500 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0

-6,000 17,500 0 0 144,000

11,489 17,500 - 44,082 223,507

0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0

0 0 0 0 0

11,489 17,500 - 44,082 223,507

180 0 0 0 90
30 0 0 0 90
0 0 0 120 120
0 0 0 0 0
210 0 0 120 300

0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Rp 48,000 LIBUR LIBUR Rp 45,000 Rp 153,000

Rp 36,301 Off Day Off Day Rp 798 -Rp 70,807

25 26 27 28 29
0 42,000 24,000 0 0
0 0 500 0 0
0 7,389 4,667 0 0
0 540 810 0 0
0 0 0 0 0
0 4,250 2,000 0 0
0 893 517 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 750 0 0 0
0 950 550 0 0
0 0 0 0 0
0 6,000 0 0 0

0 62,772 33,044 0 0

0 0 0 108,000 0
0 0 0 0 0
0 17,500 0 0 0
0 0 0 0 0
0 0 0 0 0
0 25,000 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0

0 42,500 0 108,000 0

- 105,272 33,044 108,000 -

0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 -540 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0

0 -540 0 0 0

- 104,732 33,044 108,000 -

0 270 0 0 0
0 120 90 0 0
0 0 60 0 0
0 0 0 0 0
0 390 150 0 0

0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
LIBUR Rp 111,000 Rp 88,000 Rp 15,000

Off Day Rp 5,878 Rp 54,806 -Rp 93,000

30 31
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0

0 0 949,980

0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0

0 0

- -

0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0

0 0

- -

0 0
0 0
0 0
0 0
0 0

0 0
0 0
0 0
0 0
0 0

Rp 249,978
Tanggal 1 2 3 4 5 6 7

STD 5 8 12 16 13
Income 48,000 78,000 LIBUR 116,000 LIBUR 199,000 118,000
Epay - 25,000 - 24,000 12,000
Incash 48,000 53,000 116,000 175,000 106,000
PCH 2 4 5 8 6
TA 4 9 14 18 13
Jumbo 2 2 2 5 -
TW 2 3 4 9 2
ORI 5 10 16 23 20
AREN 1 - - - -
SIRUP - 1 - 2 -
NO ICE 1 1 5 4 4
SPC - - - - -
UTUH - - - - -

29
3 STD

22,000 Income

- Epay

22,000 Incash

1 PCH

4 TA

- Jumbo

1 TW

3 ORI

- AREN

- SIRUP

1 NO ICE

- SPC

- UTUH

Tanggal STD Income Epay Incash PCH TA Jumbo

1 5 48,000 - 48,000 2 4 2
2 8 78,000 25,000 53,000 4 9 2
3 LIBUR
4 12 116,000 - 116,000 5 14 2
5 LIBUR
6 16 199,000 24,000 175,000 8 18 5
7 13 118,000 12,000 106,000 6 13 -
8 12 142,000 20,000 122,000 6 19 2
9 8 52,000 - 52,000 3 8 -
10 9 88,000 28,000 60,000 5 12 1
11 3 138,000 - 138,000 7 22 -
12 7 66,000 20,000 46,000 3 9 -
 13 13 118,000 10,000 108,000 5 17 -
14 5 82,000 15,000 67,000 4 13 -
15 9 72,000 - 72,000 4 7 1
16 6 84,000 31,000 53,000 4 3 3
17 10 145,000 85,000 60,000 8 23 2
18 3 53,000 - 53,000 5 9 -
19 2 15,000 - 15,000 - 3 -
20 6 48,000 25,000 23,000 2 4 3
21 LIBUR
22 LIBUR
23 1 45,000 - 45,000 7 6 -
24 11 153,000 42,000 111,000 10 20 2
25 LIBUR
26 12 111,000 13,000 98,000 7 17 2
27 9 88,000 39,000 49,000 4 8 3
28 1 15,000 - - - - -
29
30
31

29
1 2 3 4 5 6 7
Madu - - - 1
Copandn - - - -
Jeruk - - - 1
Leci - 1 - -
Mangga - - - -
Melon - - - 1
Susu - - - 2
K. Kecil 2 1 5 9
K. Sdg 1 2 4 4 1
K. Besar - 1 - 1 1
K. Jmbo - - - -

- Madu Madu

- Copandn Copandn

- Jeruk Jeruk

- Leci Leci

- Mangga Mangga

- Melon Melon

- Susu Susu

2 K. Kecil K. Kecil

1 K. Sdg K. Sdg

- K. Besar K. Besar

- K. Jmbo K. Jmbo
 8 9 10 11 12 13 14 15 16

12 8 9 3 7 13 5 9 6
142,000 52,000 88,000 138,000 66,000 118,000 82,000 72,000 84,000
20,000 - 28,000 - 20,000 10,000 15,000 - 31,000
122,000 52,000 60,000 138,000 46,000 108,000 67,000 72,000 53,000
6 3 5 7 3 5 4 4 4
19 8 12 22 9 17 13 7 3
2 - 1 - - - - 1 3
1 1 2 2 4 4 - 1 1
19 9 15 19 8 17 11 8 13
4 - - - 3 2 -
2 - 1 - 1 - 2 1
1 1 14 3 4 6 2 -
- - - - - - - -
- - - - - - - -

TW ORI AREN SIRUP NO ICE SPC UTUH

2 5 1 - 1 - -
3 10 - 1 1 - -

4 16 - - 5 - -

9 23 - 2 4 - -
2 20 - - 4 - -
1 19 4 2 1 - -
1 9 - - 1 - -
2 15
2 19 1 14 - -
4 8 - - 3 - -
4 17 - 1 4 - -
- 11 3 - 6 - -
1 8 2 2 2 - -
1 13 - 1 - - -
3 19 4 1 1 - -
3 5 1 - 4 - -
- 3 - - - - -
3 3 1 - - - -

6 - 5
1 24 5 - 1 - -

1 19 - 1 - - -
2 12 1 - 2 - -
- - - - - - -

8 9 10 11 12 13 14 15 16
2
2 1
2

1 1

2 2 8 2 3 4 4 5
6 2 1 1 3 4 1
6 2 2 3 5
5 2
 17 18 19 20 21 22 23 24 25 26

10 3 2 6 1 11 12
145,000 53,000 15,000 48,000 LIBUR LIBUR 45,000 153,000 LIBUR 111,000
85,000 - - 25,000 - 42,000 13,000
60,000 53,000 15,000 23,000 45,000 111,000 98,000
8 5 - 2 7 10 7
23 9 3 4 6 20 17
2 - - 3 - 2 2
3 3 - 3 6 1 1
19 5 3 3 - 24 19
4 1 - 1 5 -
1 - - - - 1
1 4 - - 5 1 -
- - - - - -
- - - - - -
17 18 19 20 21 22 23 24 25 26
1

1
1
3 1 4 2 6
2 3 1 3 4
3 2 2 -
- -
 27 28 29 30 31

9 1
88,000 15,000
39,000 -
49,000 -
4 -
8 -
3 -
2 -
12 -
1 -
- -
2 -
- -
- -
27 28 29 30 31

3
1
Tanggal Harga Beli Jumlah Per PCS Harga Jual

1 100,000 20 5,000 1,250

2 100,000 20 5,000 1,429
3 100,000 18 5,556
4 100,000 18 5,556 1,389
5 100,000 18 5,556
6 100,000 18 5,556 1,307
7 100,000 18 5,556 1,515
8 100,000 19 5,263 1,215
9 100,000 19 5,263 1,579
10 100,000 19 5,263 1,548
11 100,000 19 5,263 1,675
12 100,000 18 5,556 1,389
13 100,000 18 5,556 1,263
14 100,000 18 5,556 1,587
15 100,000 18 5,556 1,709
16 100,000 27 3,704 988
17 100,000 27 3,704 1,097
18 100,000 27 3,704 2,058
19 100,000 27 3,704
20 100,000 27 3,704 1,058
21 100,000 27 3,704
22 100,000 27 3,704
23 100,000 27 3,704 4,321
24 120,000 24 5,000 1,667
25 120,000 24 5,000
26 120,000 24 5,000 1,667
27 120,000 24 5,000 1,333
28 100,000 18 5,556
29 100,000 18 5,556
30 100,000 18 5,556
31
Harga Asli Harga Grab Harga Asli Harga SOPI

Rp - Rp - Grab = 0,8

Harga Grab Harga Asli Harga SOPI Harga Asli

Rp - Rp - Shp = 0,75

Produk Harga Diskon Grab DISKON Tampilan

Es Degan Diskon 5% 2Hemat Rp 13,345 Rp 13,345
Original 4Hemat Rp 28,000 Rp 1,250 Rp 26,750
Ori Rp 7,300 Rp 500 Rp 6,800
Air Rp 7,300 Rp 500 Rp 6,800
Coco Rp 7,300 Rp 500 Rp 6,800
Melon Rp 7,300 Rp 500 Rp 6,800
Jeruk Rp 7,300 Rp 500 Rp 6,800
Leci Rp 7,300 Rp 500 Rp 6,800
Mangga Rp 7,300 Rp 500 Rp 6,800
Aren Rp 7,300 Rp 500 Rp 6,800
Madu Rp 9,650 Rp 100 Rp 9,550
Susu Rp 9,650 Rp 100 Rp 9,550
Utuh Rp 16,200 Rp 16,200
Air no Rp 10,100 Rp 500 Rp 9,600
No ice Rp 2,800 Rp 2,800
Jumbo Rp 4,000 Rp 4,000
Rp -

FILE PERMANENT

K
 Real Bundling After Bundling Real Real Per pcs
Rp 10,009 Rp - Rp - Rp - #DIV/0!
Rp 20,063 Rp - Rp - Rp - #DIV/0!
Rp 5,100 Rp - Rp - Rp - #DIV/0!
Rp 5,100 Rp - Rp - Rp - #DIV/0!
Rp 5,100 Rp - Rp - Rp - #DIV/0!
Rp 5,100 Rp - Rp - Rp - #DIV/0!
Rp 5,100 Rp - Rp - Rp - #DIV/0!
Rp 5,100 Rp - Rp - Rp - #DIV/0!
Rp 5,100 Rp - Rp - Rp - #DIV/0!
Rp 5,100 Rp - Rp - Rp - #DIV/0!
Rp 7,163 Rp - Rp - Rp - #DIV/0!
Rp 7,163 Rp - Rp - Rp - #DIV/0!
Rp 12,150 Rp -
Rp 7,200 Rp - Rp - Rp - #DIV/0!
Rp 2,100 Rp - Rp - Rp - #DIV/0!
Rp 3,000 Rp - Rp - Rp - #DIV/0!
Rp - Rp - Rp - Rp - #DIV/0!
Harga Asli Harga Grab Harga Asli Harga SOPI

Rp - Rp - Grab = 0,8

Harga Grab Harga Asli Harga SOPI Harga Asli

Rp - Rp - Shp = 0,75

Produk Harga Diskon Grab DISKON Tampilan

Es Degan Diskon 5% 2Hemat Rp 15,600 Rp 2,500 Rp 13,100

Original 4Hemat Rp 28,000 Rp 2,550 Rp 25,450
6Hemat Rp 38,000 Rp 38,000
Jeruk Nipis Rp 7,800 Rp 1,300 Rp 6,500
ORI Rp 7,800 Rp 1,300 Rp 6,500
MADU Rp 8,900 Rp 8,900
Coco Rp 6,800 Rp 6,800
Leci Rp 6,800 Rp 6,800
Jeruk Rp 6,800 Rp 6,800
Melon Rp 6,800 Rp 6,800
Aren Rp 6,800 Rp 6,800
Mangga Rp 6,800 Rp 6,800
Air Rp 7,800 Rp 1,300 Rp 6,500
Air no Rp 10,300 Rp 1,300 Rp 9,000
Susu Rp 8,900 Rp 8,900
Utuh Rp 16,000 Rp 1,000 Rp 15,000
Tanpa es Rp 2,500 Rp 2,500

FILE PERMANENT

Rp 340
 Real Bundling After Bundling Real Real Per pcs

Rp 10,480 Rp - Rp - Rp - #DIV/0!
Rp 20,360 Rp - Rp - Rp - #DIV/0!
Rp 30,400 Rp - Rp - Rp - #DIV/0!
Rp 5,200 Rp - Rp - Rp - #DIV/0!
Rp 5,200 Rp - Rp - Rp - #DIV/0!
Rp 7,120 Rp - Rp - Rp - #DIV/0!
Rp 5,440 5 Rp 34,000 Rp 1,700 Rp 32,300 Rp 25,840 Rp 5,168
Rp 5,440 Rp - Rp - Rp - #DIV/0!
Rp 5,440 Rp - Rp - Rp - #DIV/0!
Rp 5,440 4 Rp 27,200 Rp 1,000 Rp 26,200 Rp 20,960 Rp 5,240
Rp 5,440 Rp - Rp - Rp - #DIV/0!
Rp 5,440 Rp - Rp - Rp - #DIV/0!
Rp 5,200
Rp 7,200 Rp - Rp - Rp - #DIV/0!
Rp 7,120 4 Rp 35,600 Rp 595 Rp 35,005 Rp 28,004 Rp 7,001
Rp 12,000 Rp - Rp - Rp - #DIV/0!
Rp 2,000 Rp - Rp - Rp - #DIV/0!
 Item Harga Pcs Harga Jual
ORIGINAL Rp 5,000
Cup Rp 12,500 50 Rp 250 001 Rp 3,010
Straw Rp 7,500 150 Rp 50 Margin Rp 1,990
Seal Rp 49,000 1,200 Rp 41 Kelapa Rp 2,000
Tax Rp 200 10 Rp 20 Cup Rp 250
Lain Rp 200 10 Rp 20 Gula Rp 389
ES Rp 6,000 25 Rp 240 Seal Rp 41
Kelapa Rp 6,000 3 Rp 2,000 Straw Rp 50
Sirup Rp 13,500 18 Rp 750 Tax Rp 20
Gula Rp 35,000 90 Rp 389 Lain Rp 20
Aren Rp 15,000 30 Rp 500 Es Rp 240
KLPN Rp 6,000 2 Rp 3,000
Susu Rp 7,000 6 Rp 1,167
Madu Rp 10,000 12 Rp 833
Jumbo Rp 13,500 50 Rp 270 AREN Rp 5,000
002 Rp 3,121
Margin Rp 1,879
Kelapa Rp 2,000
Cup Rp 250
Aren Rp 500
Seal Rp 41
Straw Rp 50
Tax Rp 20
Lain Rp 20
Es Rp 240

SIRUP Rp 5,000
003 Rp 3,371
Margin Rp 1,629
Kelapa Rp 2,000
Cup Rp 250
Sirup Rp 750
Seal Rp 41
Straw Rp 50
Tax Rp 20
Lain Rp 20
Es Rp 240
NO ICE Rp 7,000
004 Rp 3,770
Margin Rp 3,230
KLPN Rp 3,000
Cup Rp 250
Gula Rp 389
Seal Rp 41
Straw Rp 50
Tax Rp 20
Lain Rp 20

MADU Rp 7,000
005 Rp 3,454
Margin Rp 3,546
Kelapa Rp 2,000
Cup Rp 250
Madu Rp 833
Seal Rp 41
Straw Rp 50
Tax Rp 20
Lain Rp 20
Es Rp 240

SUSU Rp 7,000
006 Rp 3,788
Margin Rp 3,213
Kelapa Rp 2,000
Cup Rp 250
Susu Rp 1,167
Seal Rp 41
Straw Rp 50
Tax Rp 20
Lain Rp 20
Es Rp 240

SPC Rp 7,000
007 Rp 4,621
Margin Rp 2,379
Kelapa Rp 2,000
Cup Rp 250
Madu Rp 833
Seal Rp 41
Straw Rp 50
Tax Rp 20
Lain Rp 20
Es Rp 240
Susu Rp 1,167

Jumbo Rp 7,000
008 Rp 3,030
Margin Rp 3,970
Kelapa Rp 2,000
Jumbo Rp 270
Gula Rp 389
Seal Rp 41
Straw Rp 50
Tax Rp 20
Lain Rp 20
Es Rp 240

TAWAR Rp 5,000
009 Rp 2,621
Margin Rp 2,379
Kelapa Rp 2,000
Cup Rp 250
Seal Rp 41
Straw Rp 50
Tax Rp 20
Lain Rp 20
ES Rp 240
 HARGA
PLU Variant Harga Jual
HPP Margin
001 Original Rp 5,000 Rp 3,010 Rp 1,990
002 Aren Rp 5,000 Rp 3,121 Rp 1,879
003 Sirup Rp 5,000 Rp 3,371 Rp 1,629
004 No Ice Rp 7,000 Rp 3,770 Rp 3,230
005 Madu Rp 7,000 Rp 3,454 Rp 3,546
006 Susu Rp 7,000 Rp 3,788 Rp 3,213
007 Spc Rp 7,000 Rp 4,621 Rp 2,379
008 Jumbo Rp 7,000 Rp 3,030 Rp 3,970
009 Tawar Rp 5,000 Rp 2,621 Rp 2,379
 Basic : Rp 6,000 MARGIN
Harga Beli Rp 3,290 Rp 1,710 SPESIAL Rp 3,099 MARGIN
Kelapa Rp 2,000
Gula Rp 389 Rp 2,000 Harga Beli Rp 4,901 HPP
Cup Rp 250 Rp 389 Kelapa Rp 2,000
Straw Rp 50 Rp 250 Susu Rp 1,167
Seal Rp 41 Rp 50 Cup Rp 250
Tax Rp 20 Rp 39 Straw Rp 50
Lain Rp 300 Rp 200 Seal Rp 41
ES Rp 240 Rp 300 Tax Rp 20
Rp 240 Lain Rp 300
Es Rp 240
Madu Rp 833

AREN MARGIN DINE IN ITEM UNTUNG TA

Original Rp 1,710
Harga Beli Rp 3,401 Rp 1,599 Rp 1,999 Aren Rp 1,599
Kelapa Rp 2,000 Sirup Rp 1,349
AREN Rp 500 T. Es Rp 2,710
Cup Rp 250 TAWAR Rp 2,099
Straw Rp 50 Spc Rp 3,099
Seal Rp 41
Tax Rp 20 ITEM HARGA TA
Lain Rp 300 Original Rp 3,290
ES Rp 240 Aren Rp 3,401
Sirup Rp 3,651
T. Es Rp 4,290
TAWAR Rp 2,901
SIRUP Spc Rp 4,901
Harga Beli Rp 3,651 Rp 1,349 Rp 1,749
Kelapa Rp 2,000
Sirup Rp 750
Cup Rp 250
Straw Rp 50 Rp 75
Seal Rp 41
Tax Rp 20
Lain Rp 300 Es Batu Kecil 25
Es Rp 240 Es Batu Bsr 40
Kelapa Muda 3
Gula Putih 1 kg 45
Gula Aren 0,5kg 30
Tanpa Es Sirup 18
Harga Beli Rp 4,290 Rp 2,710 Rp 3,110 Straw 150
KLPN Rp 3,000
Gula Rp 389
Cup Rp 250
 Straw Rp 50
Seal Rp 41
Tax Rp 20
Lain Rp 300
Es Rp 240

FILE PERMANENT

DGN PORSI RP Jual Operasional Margin

10 30 Rp 60,000 Rp 150,000 Rp 50,000 Rp 40,000
25 75 Rp 150,000 Rp 300,000 Rp 50,000 Rp 100,000
34 102 Rp 204,000 Rp 460,000 Rp 50,000 Rp 206,000
67 201 Rp 402,000 Rp 920,000 Rp 50,000 Rp 468,000
0 Rp - Rp -
0 Rp - Rp -
0 Rp - Rp -
0 Rp - Rp -
0 Rp - Rp -

MILK 1,333
SIRUP 750
Cup 50
Straw 41
Sealer 20
Listrik Tax 300
Lain 240
Harga 2,734
Jual 5,000
Margin Rp 2,266

HOT CHOCOLATE

Rp 2,659 Rp 2,341
Chocolate Rp 1,460
Cup Rp 250
Water Rp -
Sugar Rp 389
Sealer Rp 20
Tax Rp 300
Lain Rp 240
Rp 3,811 Rp 4 Rp 15,244
 TAWAR Rp 2,099

Harga Beli Rp 2,901

Kelapa Rp 2,000
Cup Rp 250
Item Harga Pcs
Straw Rp 50
Seal Rp 41 Cup Rp 12,500 50
Tax Rp 20 Straw Rp 7,500 150
Lain Rp 300 Seal Rp 49,000 1,200
Es Rp 240 Tax Rp 200 10
Lain Rp 3,000 10
ES Rp 6,000 25
Kelapa Rp 6,000 3
DINE IN MASUK Sirup Rp 13,500 18
Rp 2,110 34% Gula Rp 35,000 90
Rp 1,999 32% Aren Rp 15,000 30
Rp 1,749 27% KLPN Rp 6,000 2
Rp 3,110 39% Susu Rp 7,000 6
Rp 2,499 42% Madu Rp 10,000 12
Rp 3,499 39%

DINE IN KELUAR
Rp 2,890 66% 100%
Rp 3,001 68% 100%
Rp 3,251 73% 100%
Rp 3,890 61% 100%
Rp 2,501 58% 100%
Rp 4,501 61% 100%
 Per pcs
Rp 5,000
Rp 4,000
Rp 4,510
Rp 4,577
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Harga Jual

Rp 250
Rp 50
Rp 41
Rp 20
Rp 300
Rp 240
Rp 2,000
Rp 750
Rp 389
Rp 500
Rp 3,000
Rp 1,167
Rp 833
#DIV/0!
#DIV/0!
#DIV/0!
TGL MASUK KELUAR Real OUT Rp -

1 Rp 30,251 Rp 5,251 Rp 30,251

2 Rp 25,800 Rp 31,051 Rp 56,051
3 Rp 2,500 Rp 28,551 Rp 53,551
4 Rp 17,800 Rp 10,751 Rp 35,751
5 Rp 10,751 Rp 35,751
6 Rp 24,720 Rp 35,471 Rp 60,471
7 Rp 12,000 Rp 47,471 Rp 72,471
8 Rp 20,325 Rp 67,796 Rp 92,796
9 Rp 67,796 Rp 92,796
10 Rp 32,600 Rp 100,396 Rp 125,396
11 Rp 100,000 Rp 396 Rp 25,396
12 Rp 20,000 Rp 20,396 Rp 45,396
13 Rp 10,480 Rp 30,876 Rp 55,876
14 Rp 24,300 Rp 55,176 Rp 80,176
15 Rp 45,000 Rp 100,000 Rp 176 Rp 25,176
16 Rp 31,000 Rp 31,176 Rp 56,176
17 Rp 85,960 Rp 117,136 Rp 142,136
18 Rp 3,800 Rp 113,336 Rp 138,336
19 Rp 100,000 Rp 13,336 Rp 38,336
20 Rp 25,320 Rp 5,500 Rp 33,156 Rp 58,156
21 Rp 21,300 Rp 11,856 Rp 36,856
22 Rp 3,800 Rp 8,056 Rp 33,056
23 Rp 5,500 Rp 2,556 Rp 27,556
24 Rp 50,880 Rp 53,436 Rp 78,436
25 Rp 53,436 Rp 78,436
26 Rp 13,000 Rp 2,000 Rp 64,436 Rp 89,436
27 Rp 64,436 Rp 89,436
28 Rp 40,320 Rp 104,756 Rp 129,756
29 Rp 104,756 Rp 129,756
30 Rp 104,756 Rp 129,756
31 Rp 104,756 Rp 129,756
C Rp 104,756 Rp 129,756
TOTAL

Rp 104,756 29 Rp 129,756

Nominal Sebenarnya Day Data Aplikasi

Cash Out
-Rp 4,756
100.000
Grab Shopee QRIS

- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- - -
PLU Harga Deskripsi

T 5000 Degan Tawar +

O 5000 Es Degan Original
B 5000 Es Degan Aren
D 5000 Es Degan Cocopandan
J 5000 Es Degan Jeruk
L 5000 Es Degan Leci
G 5000 Es Degan Mangga
N 5000 Es Degan Melon
A 8000 Es Degan Spesial
M 2000 +Madu
S 2000 +Susu
R ❔ Take Away Reguler
I 3000 Upsize Cup Jumbo
Q ❔ Dine in
C ❔ Konsumen➖➖➖💙
Z 2000 Tanpa Es
P ❔ Pecah Stok
W 12000 Kelapa Utuh
E ❔ ➕ ES BATU
K ❔ Kantong Kecil
U ❔ Kantong Sedang
V ❔ Kantong Besar
F ❔ Kantong Jumbo
Y ❔ QR Payment
LU 5000 Lumpia
X ❔
D4 -4000 Diskon
D3 -3000 Diskon
D2 -2000 Diskon
D1 -1000 Diskon
D5 -5000 Diskon
❔
❔
❔
❔
❔
❔
TGL MASUK KELUAR STOK OUT

1 0 -50,000 89,000 39,000

2 50,000 0 113,000 113,000
3 0 100,000 34,000 134,000
4 50,000 0 61,000 61,000
5 0 0 39,000 39,000
6 50,000 0 26,000 26,000 SALDO
7 75,000 0 150,000 150,000 CASH
8 75,000 140,000 35,000 175,000 ALL
9 30,000 97,000 42,000 139,000
10 32,000 37,000 28,000 65,000
11 75,000 13,000 71,000 84,000 E-Wallet
12 40,000 100,000 115,000 215,000 Tabungan
13 70,000 84,000 75,000 159,000
14 0 11,000 25,000 36,000
15 0 -98,000 120,000 22,000
16 7,000 120,000 59,000 179,000 Week 1
17 20,000 0 50,000 50,000 Week 2
18 0 0 61,000 61,000 Week 3
19 0 4,000 -16,000 -12,000 Week 4
20 0 16,000 19,000 35,000 Week 4
21 0 0 46,000 46,000
22 0 -50,000 46,000 -4,000
23 0 -300,000 87,000 -213,000
24 0 100,000 64,000 164,000
25 0 82,000 -83,000 -1,000
26 0 12,000 73,000 85,000
27 0 6,000 94,000 100,000
28 0 100,000 62,000 162,000
29 0 0 2,000 2,000
30 0 0 0 0
31 0 0 0 0

574,000 524,000 1,587,000 2,111,000

MAX 75,000 140,000 150,000

 50,000 (Locked)
66,000
116,000

104,756
0

50,000 297,000 01 sd 05
387,000 467,000 06 sd 12
121,000 374,000 13 sd 19
-140,000 252,000 20 sd 26
106,000 158,000 27 sd 30
WEEK Minggu - Sabtu

Date Count Day Target Sales Out Reguler Selisih

1 5 5 400,000 242,000 297,000 158,000

6 12 7 700,000 803,000 467,000 103,000
13 19 7 700,000 569,000 374,000 131,000
20 26 7 700,000 357,000 252,000 343,000
27 30 4 300,000 103,000 158,000 197,000

30 2,800,000 2,074,000 1,548,000 726,000

1 Sisa Hari
29

Listrik Tanggal Count Sales Nominal Perday Sales/Day

Week 1 9
Week 2 9 14 803,000 24,000 1,714 55,643
Week 3
Week 4
Week 5

1 1
2 2
3 3
4 4
5 5
6 1
7 2
8 3
9 4
10 5
11 6
12 7
13 1
14 2
15 3
16 4
17 5
18 6
19 7
20 1
21 2
22 3
23 4
24 5
25 6
26 7
27 1
28 2
29 3
30 4
31 5
 WEEK 5

Per Day Perday Minus per Count Sisa

%Sales November Oktober
Real Target day Day Hari
48,400 80,000 61% 5 BELUM BELUM
114,714 100,000 115% 7 OKE OKE
81,286 100,000 81% 7 BELUM OKE
51,000 100,000 51% 7 BELUM BELUM
25,750 75,000 65,667 34% 1 3 BELUM OKE

69,133 93,333 74% 29

3
Update setiap Closing
 Periode Target Acv Minus
MEI 1,500,000 1,462,500 37,500 98%
JUNI 3,000,000 2,726,500 273,500 91%
JULI 3,000,000 2,207,500 792,500 74%
AGUSTUS 3,000,000 3,046,000 46,000 102%
SEPTEMBER 3,000,000 2,664,000 336,000 89%
OKTOBER 3,200,000 3,297,000 97,000 103%
NOVEMBER 3,000,000 2,074,000 926,000 69%
DESEMBER -
JANUARI -
FEBRUARI -
MARET -
APRIL -
MEI -
JUNI -
JULI -
AGUSTUS -
SEPTEMBER -
OKTOBER -
NOVEMBER -
DESEMBER -
JANUARI -
FEBRUARI -
MARET -
APRIL -
MEI -
JUNI -
JULI -
AGUSTUS -
SEPTEMBER -

FILE PERMANENT
 Jumlah Cup Open Day Close Day STD AVG STD

22 8 201 9
26 5 220 8
29 2 267 9
25 5 257 10
599 28 3 285 10
367 23 6 181 8

ANENT
Day Juni Juli Agustus September November Desember Januari Februari Maret
1 10,000
2 10,000 10,000
3 10,000
4 10,000
5 10,000
6 10,000 20,000
7 10,000
8 30,000
9 20,000
10 10,000
11 10,000
12 10,000
13 30,000
14
15
16 50,000
17 10,000
18
19 10,000
20 10,000
21 10,000
22 0
23 20,000
24
25
26
27
28
29
30
31
0 0 0 0 0 0 0 0 0

FILE PERMANENT

Data disini
permanen,
dilarang untuk
mengurangi
April Mei Juni

0 0 0
Day Juni Juli Agustus September Oktober
1 Rp - Rp 195,000 Rp 72,000 Rp 25,000 Rp 215,000
2 Rp 150,000 Rp 175,000 Rp 83,000 Rp 151,000 Rp 79,000
3 Rp 77,000 Rp 183,500 Rp 87,000 Rp 85,000 Rp 140,000
4 Rp - Rp 47,000 Rp 141,000 Rp 170,000 Rp 92,000
5 Rp 126,000 Rp 70,000 Rp 79,000 Rp 140,000
6 Rp 125,000 Rp 57,000 Rp 154,000 Rp 185,000
7 Rp 89,000 Rp - Rp 119,000 Rp 72,000 Rp 167,000
8 Rp 60,000 Rp 75,000 Rp 22,000 Rp - Rp 90,000
9 Rp 80,000 Rp 85,000 Rp 57,000 Rp 95,000 Rp 140,000
10 Rp 145,000 Rp 124,000 Rp - Rp 120,000 Rp 116,000
11 Rp 26,000 Rp 70,000 Rp - Rp 92,000 Rp 95,000
12 Rp 94,000 Rp - Rp 122,000 Rp 124,000 Rp 161,000
13 Rp 60,000 Rp 242,000 Rp 87,000 Rp 146,000 Rp 143,000
14 Rp 65,000 Rp 55,000 Rp 69,000 Rp 145,000 Rp 138,000
15 Rp 60,000 Rp 50,000 Rp 114,000 Rp 76,000 Rp 124,000
16 Rp 84,000 Rp 69,000 Rp 124,000 Rp 122,000 Rp 110,000
17 Rp 156,000 Rp 22,000 Rp 46,000 Rp 85,000 Rp 70,000
18 Rp - Rp 36,000 Rp 30,000 Rp 131,000 Rp 175,000
19 Rp - Rp - Rp 181,000 Rp 78,000 Rp 106,000
20 Rp - Rp 57,000 Rp 75,000 Rp 78,000
21 Rp - Rp 32,000 Rp 127,000 Rp 156,000 Rp 164,000
22 Rp - Rp 37,000 Rp 96,000 Rp 37,000 Rp 41,000
23 Rp 60,000 Rp 70,000 Rp 145,000 Rp - Rp 84,000
24 Rp 50,000 Rp 68,000 Rp 200,000 Rp 38,000 Rp 75,000
25 Rp 77,000 Rp 98,000 Rp 99,000 Rp 71,000 Rp 103,000
26 Rp 72,000 Rp 70,000 Rp 57,000 Rp - Rp 99,000
27 Rp 65,000 Rp 25,000 Rp 137,000 Rp - Rp 155,000
28 Rp 45,000 Rp 123,000 Rp 285,000 Rp - Rp 122,000
29 Rp 60,000 Rp - Rp 35,000 Rp 89,000 Rp 147,000
30 Rp - Rp - Rp 126,000 Rp 153,000 Rp 53,000
31 END Rp 72,000 Rp 77,000 END Rp 93,000

Rp 1,826,000 Rp 2,207,500 Rp 3,046,000 Rp 2,664,000 Rp 3,297,000

Copy Paste

FILE PERMANENT
28 Ags Pesanan Jumbo
6 Sep Jumat Mbk Ninik
November Desember Januari Februari Maret April Mei Juni
Rp 48,000
Rp 78,000
LIBUR
Rp 116,000
LIBUR
Rp 199,000
Rp 118,000
Rp 142,000
Rp 52,000
Rp 88,000
Rp 138,000
Rp 66,000
Rp 118,000
Rp 82,000
Rp 72,000
Rp 84,000
Rp 145,000
Rp 53,000
Rp 15,000
Rp 48,000
LIBUR
LIBUR
Rp 45,000
Rp 153,000
LIBUR
Rp 111,000
Rp 88,000
Rp 15,000

Rp -

### Rp - Rp - Rp - Rp - Rp - Rp - Rp -

Belum Belum
 HPP Beef HPP Coklat Keju

HPP Rp 1,430 HPP Rp 640

Rp 2,500 Rp 1,070 Rp 3,000 Rp 2,360

Kulit Lumpia Rp 180 Kulit Lumpia Rp 180

Beef Rp 480 Coklat Rp -
Wortel Rp 100 Keju Rp -
Minyak Rp 50 Minyak Rp 50
Lainnya Rp 50 Mika Rp 360
Mika Rp 360 Lainnya Rp 50

Cambah Rp 100
Saus Rp 110
 HPP Tape Keju

HPP Rp 640 Kulit Lumpia Rp 9,000

Rp 3,000 Rp 2,360 Coklat
Keju
Kulit Lumpia Rp 180 Tape
Keju Rp - Mika Rp 9,000
Tape Rp - Minyak Rp 50
Minyak Rp 50 Lainnya Rp 50
Mika Rp 360 Beef Rp 24,000
Lainnya Rp 50 Wortel Rp 2,000
Tepung Rp 5,000
Cambah Rp 2,000
Saus Rp 5,500
50 Rp 180 Total Belanja Rp 56,500
20 Rp -
20 Rp - Saus
10 Rp - Mika
25 Rp 360 Tepung Rp 19,500
1 Rp 50 Wortel
1 Rp 50 Cambah Rp 4,000
50 Rp 480 Kornet Rp 24,000
20 Rp 100 Kulit Rp 9,000
100 Rp 50
20 Rp 100
50 Rp 110
WARALABA ES DEGAN INDONESIA
Harga / Gelas
Estimasi Rp 3,220,000 Estimasi HPP Rp 3,304
5500000 Rp 2,280,000 Harga Jual Rp 5,000
Keuntungan Rp 1,696
Booth (Rombong) Rp 2,000,000 Kelapa/cup Rp 2,000
Tempat Es Batu Rp 75,000 Gula Rp 389
Ember Rp 20,000 Cup Rp 250
Scoop Ice Rp 20,000 Sedotan Rp 50
Gelas 12 pcs Rp 65,000 Seal Take Away Rp 41
Box 2 pcs Rp 30,000 Pajak**** Rp 20
Sendok 12 pcs Rp 15,000 Lain* Rp 300
Pengeruk Degan Rp 2,000 ES** Rp 240
Cupit Rp 15,000
Saringan Rp 13,000
Botol Gula 2 pcs Rp 20,000 **** :
Cup Plastik 100pcs Rp 25,000 Pajak Meliputi Listrik, biaya
sewa, dll. Dihitung
Cup Sealer Rp 700,000
berdasarkan Cup masuk HPP
Pisau Rp 100,000 per Produk terjual
Ceret Rp 20,000
Modal Kelapa Rp 100,000 Harga Es Batu 6000/ kantong
Dalam 1 kantong es batu untuk 25 porsi Gelas

*biaya lain lain merupakan biaya tambahan

untuk Karyawan dan lain sebagainya

Survey Orang : 10
Manis Asin
1 4
10% 40%
 (Dalam 1 Cup)

jak Meliputi Listrik, biaya

sewa, dll. Dihitung
dasarkan Cup masuk HPP
per Produk terjual

atu untuk 25 porsi Gelas

upakan biaya tambahan

dan lain sebagainya