Income Statement Essentieel 2022

Revenue 2022
Sales
January Rp10,025,000
Februari Rp12,240,000
Maret Rp3,540,000
April Rp5,652,500
Mei Rp6,432,000
Juni Rp9,691,000
Juli Rp11,053,500
Agustus Rp17,063,000
September Rp16,250,000
Oktober Rp9,337,000
Total Revenue Rp101,284,000

Cost Of Goods Sold 2022

Material
January Rp3,116,855
Februari Rp3,488,400
Maret Rp885,000
April Rp1,661,688
Mei Rp1,768,800
Juni Rp2,713,000
Juli Rp3,374,000
Agustus Rp5,254,000
September Rp4,602,800
Oktober Rp2,623,700
Total Material Cost Rp29,488,243
Labor
January Rp3,150,000
Februari Rp3,150,000
Maret Rp1,800,000
April Rp1,800,000
Mei Rp3,150,000
Juni Rp3,150,000
Juli Rp3,150,000
Agustus Rp3,280,000
September Rp3,280,000
Oktober Rp3,280,000
Total Labor Cost Rp29,190,000
Rent
Total Rent Cost Rp18,000,000
Total COGS Cost Rp76,678,243

Gross Profit Rp24,605,757

Operating Expense 2020

Advertising
Coffee Blogger Rp1,200,000
Instagram Ads Rp650,000
Total Advertising Cost Rp1,850,000
Repair and Maintenance
Espresso Machine Maintenance Rp500,000
Speaker Maintenance Rp250,000
Total Repair and Maintenance Cost Rp750,000
Office Supplies
Total Office Supplies Rp750,000
Total Operating Expense Cost Rp3,350,000

Profit (Loss) Before Tax Rp21,255,757

Tax Expense Rp0

Net Profit (Loss) Rp21,255,757

 Budgeting List

Legal Entity
No Name Estimated Price
1 Pengurusan Akte CV Rp2,500,000
Total Rp2,500,000

Equipment
NO KEBUTUHAN ALAT QTY HARGA TOTAL
1 Kursi 45cm 30 Rp 75,000 Rp 2,250,000
2 Kursi 75cm 4 Rp 125,000 Rp 500,000
3 Meja ( bikin ) 6 Rp 150,000 Rp 900,000
4 Wadah kopi 8 Rp 15,000 Rp 120,000
5 Scale 2 Rp 200,000 Rp 400,000
6 Server 1 Rp 50,000 Rp 50,000
7 Gelas bening 15 Rp 25,000 Rp 375,000
8 Gelas cappucino 20 Rp 25,000 Rp 500,000
9 Sloki 12 Rp 5,000 Rp 60,000
10 Cupping bowl 12 Rp 30,000 Rp 360,000
11 Piring gorengan 12 Rp 5,000 Rp 60,000
12 Lampu sorot 2 Rp 50,000 Rp 100,000
13 Lampu neon led 4 Rp 30,000 Rp 120,000
14 Neon box 1 Rp 1,000,000 Rp 1,000,000
15 Kompor 2 tungku 1 Rp 150,000 Rp 150,000
16 Gas 3kg 2 Rp 100,000 Rp 200,000
17 Katel 1 Rp 50,000 Rp 50,000
18 Peralatan dapur 1 Rp 500,000 Rp 500,000
19 Tanaman hias 6 Rp 25,000 Rp 150,000
20 Service alat 3 Rp 250,000 Rp 750,000
21 Grinder DF64 2 Rp 5,500,000 Rp 11,000,000
22 Origami plastic 3 Rp 300,000 Rp 900,000
22 Hario v60 glass 01 3 Rp 150,000 Rp 450,000
23 April Dripper 3 Rp 350,000 Rp 1,050,000
24 Jug rinser medium 1 Rp 900,000 Rp 900,000
25 Packaging kardus 100 Rp 5,000 Rp 500,000
26 Packaging kopi 100 Rp 5,000 Rp 500,000
27 Press sealer 1 Rp 250,000 Rp 250,000
28 Vacuum sealer 1 Rp 500,000 Rp 500,000
TOTAL BIAYA Rp 24,645,000

Renovation
NO KEBUTUHAN TEMPAT QTY HARGA TOTAL
1 Sewa tempat 12 Rp 2,000,000 Rp 24,000,000
2 Renovasi 1 Rp 30,000,000 Rp 30,000,000
TOTAL BIAYA Rp 54,000,000
 Marketing Budget
NO KEBUTUHAN PEMASARAN QTY HARGA TOTAL
1 Influencer IG 15 Rp 300,000 Rp 4,500,000
2 Free flow coffee 8 Rp 150,000 Rp 1,200,000
3 Collective cupping 6 Rp 50,000 Rp 300,000
4 Instagram ads 15 Rp 200,000 Rp 3,000,000
5 Tiktok ads 15 Rp 300,000 Rp 4,500,000
6 Sponsorship 3 Rp 180,000 Rp 540,000
TOTAL BIAYA Rp 14,040,000

Bahan Baku Green Bean

NO KEBUTUHAN BAHAN BAKU QTY HARGA TOTAL
1 Arabica natural 20 Rp 200,000 Rp 4,000,000
2 Arabica washed 20 Rp 150,000 Rp 3,000,000
3 Arabica honey 20 Rp 180,000 Rp 3,600,000
4 Arabika experimental 20 Rp 200,000 Rp 4,000,000
5 Robusta fine grade 50 Rp 60,000 Rp 3,000,000
TOTAL BIAYA Rp 17,600,000
 Total Budget
No Aspek Total
1 Equipment Purchasing Rp24,645,000
2 Legal Entity Rp2,500,000
3 Renovation Rp54,000,000
4 Marketing Rp14,400,000
5 Raw Material Rp17,600,000
Total Rp113,145,000
Biaya Tak Terduga (20%) Rp22,629,000
Total Investment Rp135,774,000
 Fixed Cost

Wage
No Name Jumlah Shift Gaji Per Shift
1 Full-Time Barista 30 100000
2 Part-Time Barista 10 50000
3 Designer + Content Creator 1 500000
Total

Rent
No Name Harga
1 Sewa Tempat Rp1,800,000
2 Listrik Rp200,000
Total Rp2,000,000

Marketing Cost
No Name Harga
1 Instagram Ads + Coffee Blog Rp600,000
Total Rp600,000

Total Budget
No Aspek Total
1 Wage Rp5,000,000
2 Rent Rp2,000,000
3 Marketing Cost Rp600,000
Total Rp7,600,000
Jumlah Orang Price
1 Rp3,000,000
3 Rp1,500,000
1 Rp500,000
Rp5,000,000
 Revenue Forecast (Daily)
No Name Price Quantity Estimated Revenue
1 Coffee and Beverages Rp22,000 30 Rp660,000
2 Food and Cookies Rp10,000 23 Rp230,000
Total Rp890,000

Revenue Forecast (Monthly)

No Name Price Quantity Estimated Revenue
1 Coffee and Beverages Rp22,000 900 Rp19,800,000
2 Food and Cookies Rp10,000 690 Rp6,900,000
Total Rp26,700,000

Revenue Forecast (Yearly)

No Name Price Quantity Estimated Revenue
1 Coffee and Beverages Rp22,000 10800 Rp237,600,000
2 Food and Cookies Rp10,000 8280 Rp82,800,000
Total Rp320,400,000
Estimasi Laporan Arus Kas
Tahun fiskal mulai: (Pra) Awal
11/1/2022

Saldo Kas (awal bulan) Rp0

Penerimaan Kas
Penjualan Tunai
Penagihan dari akun Piutang (CR)
Pinjaman/ suntikan dana lainnya Rp135,744,000
Total Rp135,744,000
Total Kas Tersedia (sebelum kas keluar) Rp135,744,000

Pengeluaran Kas
Pembelian Bahan Baku
Pembelian Grinder dan Peralatan Kopi
Gaji kotor (jumlah penarikan tepat)
Pengeluaran penggajian (pajak, dst.)
Layanan dari luar
Persediaan (kantor & operasi.)
Perbaikan & pemeliharaan
Iklan
Mobil, pengiriman & perjalanan
Hukum (Pengurusan CV)
Sewa
Telepon
Listrik/Air
Asuransi
Pajak (bumi dan bangunan, dll.)
Bunga
Pengeluaran lainnya (Renovasi)
Lainnya (sebutkan)
Lainnya (sebutkan)
Lain-lain
Total Rp0

Pengeluaran Kas (Non L&R)

Pembayaran pokok pinjaman
Pembelian modal (sebutkan)
 Biaya awal lainnya
Reserve dan/atau eskrow
Penarikan oleh Investor
Total Rp0
Total Pengeluaran Kas Rp0

Posisi kas (akhir bulan) Rp135,744,000

 NOV DES JAN FEB MAR APR
01 01 01 01 01 01

Rp135,744,000 Rp75,824,000 Rp85,849,000 Rp95,874,000 Rp105,899,000 Rp115,924,000

Rp26,700,000 Rp30,000,000 Rp30,000,000 Rp30,000,000 Rp30,000,000 Rp30,000,000

Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp26,700,000 Rp30,000,000 Rp30,000,000 Rp30,000,000 Rp30,000,000 Rp30,000,000
Rp162,444,000 Rp105,824,000 Rp115,849,000 Rp125,874,000 Rp135,899,000 Rp145,924,000

Rp17,600,000 Rp7,500,000 Rp7,500,000 Rp7,500,000 Rp7,500,000 Rp7,500,000

Rp24,645,000 Rp0 Rp0 Rp0 Rp0 Rp0
Rp5,000,000 Rp5,000,000 Rp5,000,000 Rp5,000,000 Rp5,000,000 Rp5,000,000
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp600,000 Rp600,000 Rp600,000 Rp600,000 Rp600,000
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp2,500,000 Rp0 Rp0 Rp0 Rp0 Rp0
Rp1,800,000 Rp1,800,000 Rp1,800,000 Rp1,800,000 Rp1,800,000 Rp1,800,000
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp200,000 Rp200,000 Rp200,000 Rp200,000 Rp200,000 Rp200,000
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp30,000,000 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp81,745,000 Rp15,100,000 Rp15,100,000 Rp15,100,000 Rp15,100,000 Rp15,100,000

Rp0 Rp0 Rp0 Rp0 Rp0 Rp0

Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
 Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp4,875,000 Rp4,875,000 Rp4,875,000 Rp4,875,000 Rp4,875,000 Rp4,875,000
Rp4,875,000 Rp4,875,000 Rp4,875,000 Rp4,875,000 Rp4,875,000 Rp4,875,000
Rp86,620,000 Rp19,975,000 Rp19,975,000 Rp19,975,000 Rp19,975,000 Rp19,975,000

Rp75,824,000 Rp85,849,000 Rp95,874,000 Rp105,899,000 Rp115,924,000 Rp125,949,000

 MEI JUN JUL AGU SEP OKT
01 01 01 01 01 01

Rp125,949,000 Rp134,474,000 Rp144,499,000 Rp149,524,000 Rp159,549,000 Rp169,574,000

Rp30,000,000 Rp30,000,000 Rp30,000,000 Rp30,000,000 Rp30,000,000 Rp30,000,000

Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp30,000,000 Rp30,000,000 Rp30,000,000 Rp30,000,000 Rp30,000,000 Rp30,000,000
Rp155,949,000 Rp164,474,000 Rp174,499,000 Rp179,524,000 Rp189,549,000 Rp199,574,000

Rp7,500,000 Rp7,500,000 Rp7,500,000 Rp7,500,000 Rp7,500,000 Rp7,500,000

Rp0 Rp0 Rp5,000,000 Rp0 Rp0 Rp0
Rp5,000,000 Rp5,000,000 Rp5,000,000 Rp5,000,000 Rp5,000,000 Rp5,000,000
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp1,500,000 Rp0 Rp0 Rp0 Rp0 Rp0
Rp600,000 Rp600,000 Rp600,000 Rp600,000 Rp600,000 Rp600,000
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp1,800,000 Rp1,800,000 Rp1,800,000 Rp1,800,000 Rp1,800,000 Rp1,800,000
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp200,000 Rp200,000 Rp200,000 Rp200,000 Rp200,000 Rp200,000
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp16,600,000 Rp15,100,000 Rp20,100,000 Rp15,100,000 Rp15,100,000 Rp15,100,000

Rp0 Rp0 Rp0 Rp0 Rp0 Rp9,319,000

Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
 Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp0 Rp0 Rp0 Rp0 Rp0 Rp0
Rp4,875,000 Rp4,875,000 Rp4,875,000 Rp4,875,000 Rp4,875,000 Rp4,875,000
Rp4,875,000 Rp4,875,000 Rp4,875,000 Rp4,875,000 Rp4,875,000 Rp14,194,000
Rp21,475,000 Rp19,975,000 Rp24,975,000 Rp19,975,000 Rp19,975,000 Rp29,294,000

Rp134,474,000 Rp144,499,000 Rp149,524,000 Rp159,549,000 Rp169,574,000 Rp170,280,000