MONTHLY FULL

DESEMBER
Budgeting
TARGET REALISASI
OMSET ALL 100.00% 4,000,000,000 107.49%
RETURN PRODUK 4.00% 160,000,000 3.48%

HPP PENJUALAN 60.02% 2,401,000,000 46.91%

HPP BAHAN BAKU (Belanja) 50.00% 2,000,000,000 46.26%
GAJI PRODUKSI 8.25% 330,000,000 0.00%
OPR PRODUKSI + DISTRIBUSI 1.08% 43,000,000 0.00%
WASTE PRODUK 0.00% - 0.00%
SEWA FACTORY 0.70% 28,000,000 0.64%

LABA KOTOR 39.98% 1,599,000,000 53.09%

OPEX
OPEX MARKETING EXPENSE 8.00% 320,000,000 7.33%
MARKETING PROMO 4.00% 160,000,000 6.11%
MARKETING EVENT 4.00% 160,000,000 0.64%
KANG RIDWAN OFC 0.57%
SALES DISCOUNT 1.13% 45,000,000 0.00%
OPEX OPERATION & HO 21.32% 852,916,667 15.40%
OPEX OPERATION 1.75% 70,000,000 1.79%
GAJI OPR 4.63% 185,000,000 3.65%
BIAYA SEWA TOKO 2.22% 88,750,000 2.07%
OPEX HEAD OFFICE 6.00% 240,000,000 2.09%
GAJI OFFICE 6.50% 260,000,000 5.60%
BIAYA SEWA KANTOR 0.23% 9,166,667 0.19%
OPEX BAKERY FRANCHISE 2.96% 118,246,058 2.21%
OPEX OPERATION FRANCHISE 1.03% 41,000,000 0.49%
GAJI OPR FRANCHISE 1.28% 51,329,391 1.15%
BIAYA SEWA TOKO 0.65% 25,916,667 0.57%

PENDAPATAN & BEBAN LAIN 0.00% - 0.00%

PENDAPATAN LAIN-LAIN 0.00% - 0.00%
BEBAN LAIN-LAIN 0.00% - 0.00%

NET PROFIT 7.70% 307,837,276 28.16%

BEBAN AKTIVA
PENDAPATAN & BEBAN LAIN -
SETORAN BANK 0.00% 0.00%
 PRIVE RUTIN 0.00% 0.00%
- Angsuran Rutin Asuransi 0.00% 6,800,000 0.00%
- Angsuran Rutin Bu Acu 0.00% 5,716,146 0.00%
- Angsuran Rutin Kendaraan Owner 0.00% 9,376,500 0.00%
- Angsuran Rutin Pinjaman Dirut 0.00% 4,786,459 0.00%
- Prive Rutin 0.00% 27,983,479 0.00%
- Training Dirut 0.00% 20,801,509 0.00%
ANGSURAN BANK AMOR 0.00% 109,079,788 0.00%
ANGSURAN GOLD OWNER 0.00% 50,000,000 0.00%
PRIVE DEALING CIKUKULU 7,500,000
KANG RIDWAN OFFICIAL 0.00% 32,559,200 0.00%
SALADIVA 0.00% 18,559,820 0.00%
ANGSURAN KENDARAAN 0.00% - 0.00%
PAJAK KENDARAAN OWNER
SEWA RUKO KANG RIDWAN
PEMBELIAN ASSET 0.00% 0.00%
UANG MUKA SEWA 0.00% - 0.00%
TOTAL 100.00% - 100.00%
CASH ESTIMASI
 30 PROPORSIONAL 1 S.D.
MBER ACH NOVEMBE 30 Hari
REALISASI TARGET REALISASI
4,299,707,005 107.5% 100.00% 4,000,000,000 107.49% 4,299,707,005
149,811,500 87.1% 4.00% 160,000,000 3.48% 149,811,500

2,016,912,344 78.1% 60.03% 2,401,000,000 46.91% 2,016,912,344

1,989,245,677 92.5% 50.00% 2,000,000,000 46.26% 1,989,245,677
0.0% 8.25% 330,000,000 0.00% -
0.0% 1.08% 43,000,000 0.00% -
- #DIV/0! 0.00% - 0.00% -
27,666,667 91.9% 0.70% 28,000,000 0.64% 27,666,667

2,282,794,661 132.8% 39.97% 1,599,000,000 60.58% 2,282,794,661

315,115,115 91.6% 9.13% 365,000,000 6.75% 290,398,615

262,915,115 152.9% 4.00% 160,000,000 6.11% 262,915,115
27,483,500 16.0% 4.00% 160,000,000 0.64% 27,483,500
24,716,500
- 1.13% 45,000,000 0.00% -
662,057,617 72.2% 21.32% 852,916,667 15.40% 662,057,617
76,979,489 102.3% 1.75% 70,000,000 1.79% 76,979,489
157,050,796 79.0% 4.63% 185,000,000 3.65% 157,050,796
88,875,001 93.2% 2.22% 88,750,000 2.07% 88,875,001
89,957,455 34.9% 6.00% 240,000,000 2.09% 89,957,455
240,944,876 86.2% 6.50% 260,000,000 5.60% 240,944,876
8,250,000 83.7% 0.23% 9,166,667 0.19% 8,250,000
94,963,521 74.7% 2.96% 118,246,058 2.21% 94,963,521
20,987,466 47.6% 1.03% 41,000,000 0.49% 20,987,466
49,306,055 89.4% 1.28% 51,329,391 1.15% 49,306,055
24,670,000 88.6% 0.65% 25,916,667 0.57% 24,670,000
-
- #DIV/0! 0.00% - 0.00% -
- #DIV/0! 0.00% - 0.00% -
- #DIV/0! 0.00% - 0.00% -
-
1,210,658,408 365.9% 6.57% 262,837,276 28.73% 1,235,374,908
-
-
0%
#DIV/0! 0.00% - 628,357,901
#DIV/0! 0.00% - 0.00% -
 #DIV/0! 0.00% - #DIV/0! -
6,800,000 0.00% 6,800,000 0.30% 6,800,000
5,716,146 0.00% 5,716,146 #DIV/0! 5,716,146
9,376,500 0.00% 9,376,500 #DIV/0! 9,376,500
4,786,459 0.00% 4,786,459 1.65% 4,786,459
27,983,479 0.00% 27,983,479 10.64% 27,983,479
20,801,509 0.00% 20,801,509 75.69% 20,801,509
109,079,788 0.00% 109,079,788 #DIV/0! 109,079,788
0.00% 50,000,000 0.00% -
7,500,000 7,500,000 7,500,000
41,164,200 0.00% 32,559,200 53.47% 41,164,200
18,559,820 0.00% 18,559,820 11.82% 18,559,820
6,590,000 #DIV/0! 0.00% - 0.29% 6,590,000
6,931,000
25,000,000
- 0.00% -
118,000,000 #DIV/0! 0.00% - #DIV/0! 370,000,000
408,288,901 100.0%
802,369,507 607,017,007

370,000,000
 30
ACH

107.5%
87.1%

78.1%
92.5%
0.0%
0.0%
#DIV/0!
91.9%

29.3%

74.0%
152.9%
16.0%

0.0%
72.2%
102.3%
79.0%
93.2%
34.9%
86.2%
83.7%
74.7%
47.6%
89.4%
88.6%

#DIV/0!
#DIV/0!
#DIV/0!

437.3%

#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!

#DIV/0!
#DIV/0!
#DIV/0!

#DIV/0!
 3/3/2023
NO ACTION STEP
Tanggal
1 Meeting Koordinasi dengnan SCM untuk strategi Belanja Idul Fitri 3/6/2023
2 Buat Proyeksi PO & Cashflow 3/6/2023

3 Overdue Vendor (gambarkan) 3/6/2023

4 Uang Masuk Cheffmate Done
5 Diskusi dengan Pak Gamal Belanja 45% Khusus Kebutuhan Maret Done
6 Analisa Kembali data yang di laporakan di Financial Report terkait HPP dan minus 3/6/2023
di bulan Februari
 3/10/2023
NO ACTION STEP
Tanggal
1 Meeting Koordinasi dengnan SCM untuk strategi Belanja Idul Fitri 3/14/2023
2 Analisa Kembali data yang di laporakan di Financial Report terkait HPP dan minus 3/14/2023
di bulan Februari
3 Buat Proyeksi PO & Cashflow 3/14/2023
4 Total Hutang Keseluruhan dan Hutang Vendor Overdue 3/14/2023
5 Buat Format Kuncian untuk Pembahasan Khusus Cashflow 3/14/2023
6 History Overdue 3 Tahun kebelakang 3/14/2023

7 Analisa Kembali Target Budget Maret 3/14/2023

8 Coaching Khusus Laporan Keuangan 3/14/2023
 ###
NO ACTION
STEP
PIC Tanggal PIC
Hari Ini Lutfi & Dias DONE 1 FIX terkait kendala persiapan idul fitri

Hari Ini Lusi/marmar DONE 2 Bahas Detail Terkait Komposisi Budgeting Detail
Hari Ini Friska 3 Bahas Terkait Planing Open Bakery Setelah Lebaran
Hari Ini Friska DONE
Done Dias DONE

Hari Ini Friska Belum Ke Tracking

Besok Lusi/marmar
Minta JadwDias Udah Diskusi dengan GM masuk di meeting 3bulanan
Bahasan Mingguan
1 Cash On Hand
2 Proyeksi Pembayaran 1 Minggu kedepan
3 Alokasi Pembayaran Prioritas Hutang Overdue
4
5
6
7
8
9
10

Bahasan 2 Mingguan
1 Review Hutang Vendor (overdue, Runing, Progres)
2
3
4
5
6
7
8
9
10

Bahasan Bulanan
1 Laporan Keuangan Bulanan
2
 MONTHLY FULL
NOVEMBER
Budgeting
TARGET REALISASI
OMSET ALL 100.00% 3,900,000,000 83.44%
RETURN PRODUK 4.00% 156,000,000 3.89%

HPP PENJUALAN 60.28% 2,351,000,000 63.68%

HPP BAHAN BAKU (Belanja) 50.00% 1,950,000,000 52.79%
GAJI PRODUKSI 8.46% 330,000,000 8.75%
OPR PRODUKSI + DISTRIBUSI 1.10% 43,000,000 1.29%
WASTE PRODUK 0.00% - 0.00%
SEWA FACTORY 0.72% 28,000,000 0.85%

LABA KOTOR 39.72% 1,549,000,000 30.30%

OPEX
OPEX MARKETING EXPENSE 8.00% 312,000,000 4.38%
MARKETING PROMO 4.00% 156,000,000 3.23%
MARKETING EVENT 4.00% 156,000,000 2.02%
SALES DISCOUNT 1.15% 45,000,000 0.00%
OPEX OPERATION & HO 21.87% 852,916,667 16.54%
OPEX OPERATION 1.79% 70,000,000 2.23%
GAJI OPR 4.74% 185,000,000 5.09%
BIAYA SEWA TOKO 2.28% 88,750,000 2.73%
OPEX HEAD OFFICE 6.15% 240,000,000 2.13%
GAJI OFFICE 6.67% 260,000,000 7.39%
BIAYA SEWA KANTOR 0.24% 9,166,667 0.25%
OPEX BAKERY FRANCHISE 3.03% 118,246,058 2.40%
OPEX OPERATION FRANCHISE 1.05% 41,000,000 0.61%
GAJI OPR FRANCHISE 1.32% 51,329,391 1.51%
BIAYA SEWA TOKO 0.66% 25,916,667 0.76%

PENDAPATAN & BEBAN LAIN 0.00% - 0.00%

PENDAPATAN LAIN-LAIN 0.00% - 0.00%
BEBAN LAIN-LAIN 0.00% - 0.00%

NET PROFIT 6.82% 265,837,276 8.37%

BEBAN AKTIVA
PENDAPATAN & BEBAN LAIN -
SETORAN BANK 0.00% 0.00%
PRIVE RUTIN 0.00% 0.00%
 - Angsuran Rutin Asuransi 0.00% 6,800,000 0.00%
- Angsuran Rutin Bu Acu 0.00% 5,716,146 0.00%
- Angsuran Rutin Kendaraan Owner 0.00% 9,376,500 0.00%
- Angsuran Rutin Pinjaman Dirut 0.00% 4,786,459 0.00%
- Prive Rutin 0.00% 27,983,479 0.00%
- Training Dirut 0.00% 20,801,509 0.00%
ANGSURAN BANK AMOR 0.00% 109,079,788 0.00%
ANGSURAN GOLD OWNER 0.00% 50,000,000 0.00%
PRIVE DEALING CIKUKULU 7,500,000
KANG RIDWAN OFFICIAL 0.00% 32,559,200 0.00%
SALADIVA 0.00% 18,559,820 0.00%
ANGSURAN KENDARAAN 0.00% - 0.00%
PAJAK KENDARAAN OWNER
PEMBELIAN ASSET 0.00% 0.00%
UANG MUKA SEWA 0.00% - 0.00%
TOTAL 100.00% - 100.00%
CASH ESTIMASI
 28 PROPORSIONAL 1 S.D.
EMBER ACH NOVEMBE 30 Hari
REALISASI TARGET REALISASI
3,253,991,350 83.4% 100.00% 4,080,000,000 0.00%
126,627,500 97.3% 4.00% 163,200,000 #DIV/0!

2,072,147,748 105.6% 59.22% 2,510,272,000 #DIV/0!

1,717,707,081 105.6% 49.50% 2,100,384,000 #DIV/0!
284,658,900 103.4% 7.80% 330,969,600 #DIV/0!
42,115,100 117.4% 1.20% 50,918,400 #DIV/0!
- #DIV/0! 0.00% - #DIV/0!
27,666,667 118.4% 0.72% 28,000,000 #DIV/0!

1,181,843,602 76.3% 40.78% 1,569,728,000 #DIV/0!

170,920,345 54.8% 5.66% 231,000,000 #DIV/0!

105,104,345 80.8% 3.77% 154,000,000 #DIV/0!
65,816,000 50.6% 1.89% 77,000,000 #DIV/0!
- 0.00% - #DIV/0!
644,998,523 75.6% 16.78% 684,500,000 #DIV/0!
72,704,120 124.5% 2.21% 90,000,000 #DIV/0!
165,591,338 107.3% 4.17% 170,000,000 #DIV/0!
88,875,001 120.0% 2.21% 90,000,000 #DIV/0!
69,255,786 34.6% 1.96% 80,000,000 #DIV/0!
240,322,278 110.8% 6.00% 245,000,000 #DIV/0!
8,250,000 107.9% 0.23% 9,500,000 #DIV/0!
93,643,199 79.2% 2.45% 100,000,000 #DIV/0!
20,000,000 58.5% 0.61% 25,000,000 #DIV/0!
48,973,199 114.4% 1.23% 50,000,000 #DIV/0!
24,670,000 114.1% 0.61% 25,000,000 #DIV/0!

- #DIV/0! 0.00% - #DIV/0!

- #DIV/0! 0.00% - #DIV/0!
- #DIV/0! 0.00% - #DIV/0!
-
272,281,535 122.8% 13.58% 554,228,000 #DIV/0!
-
-
0%
#DIV/0! 0.00% - 666,715,801
#DIV/0! 0.00% - #DIV/0! -
#DIV/0! 0.00% - #DIV/0! -
 6,800,000 0.00% 6,800,000 #DIV/0! 6,800,000
5,716,146 0.00% 5,716,146 #DIV/0! 5,716,146
9,376,500 0.00% 9,376,500 #DIV/0! 9,376,500
4,786,459 0.00% 4,786,459 #DIV/0! 4,786,459
27,983,479 0.00% 55,000,000 #DIV/0! 27,983,479
20,801,509 0.00% 20,801,509 #DIV/0! 20,801,509
109,079,788 0.00% 109,079,788 #DIV/0! 109,079,788
75,000,000 0.00% 50,000,000 #DIV/0! 75,000,000
7,500,000 15,000,000 7,500,000
41,164,200 0.00% 67,000,000 #DIV/0! 41,164,200
18,559,820 0.00% 6,000,000 #DIV/0! 18,559,820
6,590,000 #DIV/0! 0.00% 6,590,000 #DIV/0! 6,590,000
6,931,000 -
- 80,000,000
118,000,000 #DIV/0! 118,000,000
458,288,901 100.0% 0.00% 554,150,402
- 186,007,365 0.00% 77,598 #DIV/0! 333,357,901

370,000,000 - 666,715,801
 30
ACH
TARGET
###
###

###
###

###
###
###

###

###
###
###

###
###
###
###
###
###
###
###
###

###
###
###

###

###
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!

#DIV/0!
#DIV/0!
#DIV/0!

#DIV/0!