Scribd Logo
Upload

Welcome to Scribd!

  • 11 views

    5 Colour

    Uploaded by

    Gustian Suro Pratama

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    5 Colour

    Uploaded by

    Gustian Suro Pratama
    11 views18 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    11 views18 pages

    5 Colour

    Uploaded by

    Gustian Suro Pratama

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 18

    DATA KEUANGAN

    update : 06 July 2020

    No Item Desription Qty Satuan Harga Satuan

    A Pembelian Aset
    1 Pembelian Paket Booth 1 set Rp 5,900,000
    2 Ongkos kirim 1 set Rp 450,000
    3 Tempat Es 1 set Rp 170,000
    4 Termos Air Panas 1 set Rp 100,000

    B Pembelian Bahan
    1 Pembelian Wipe Cream 1 2 Pack Rp 85,000
    2 ongkos kirim 1 1 hari Rp 18,000
    3 Pembelian Boba 1 2 Pack Rp 24,000
    4 ongkos kirim 1 1 hari Rp 15,000
    5 Dalgona Taro 1 1 Kg Rp 55,000
    6 Dalgona Banana 1 1 Kg Rp 55,000
    7 Dalgona Red Valvet 1 1 Kg Rp 55,000
    8 Dalgona Strawberry 1 1 Kg Rp 55,000
    9 Dalgona Coffee 1 1 Kg Rp 60,000
    10 Dalgona Green Tea 1 1 Kg Rp 75,000
    11 Dark Choco 1 2 Kg Rp 52,000
    12 Susu Fuel Cream 1 2 Kg Rp 100,000
    13 ongkos kirim 1 1 paket Rp 50,000

    C Comsumable
    1 Listrik 1 1 lot Rp 75,000
    2 Axogy 1 3 galon Rp 18,000
    3 Aqua 1 2 galon Rp 5,000
    4 Bensin 1 2.5 Liter Rp 10,000
    D Gaji Pekerja
    1 Bunda 8 1 per hari Rp 30,000
    2 Grefith 8 1 per hari Rp 2,000

    E Penjualan
    Set Lima Warna 1 340 cup Rp 10,000

    SUMMARY
    Total Pengeluaran
    Total Pendapatan
    Profit Balance
    Pengembalian Modal
    Total Hari Jualan
    6

    Sub Harga Harga Grand Total Keterangan

    Rp 6,620,000
    Rp 5,900,000
    Rp 450,000
    Rp 170,000
    Rp 100,000

    Rp 1,369,000
    Rp 170,000
    Rp 18,000
    Rp 48,000
    Rp 15,000
    Rp 55,000
    Rp 55,000
    Rp 55,000
    Rp 55,000
    Rp 60,000
    Rp 75,000
    Rp 104,000
    Rp 200,000
    Rp 50,000

    Rp 164,000
    Rp 75,000
    Rp 54,000
    Rp 10,000
    Rp 25,000
    Rp 256,000
    Rp 240,000
    Rp 16,000

    Rp 3,400,000
    Rp 3,400,000

    Rp 9,778,000
    Rp 3,400,000
    Rp 1,611,000
    Rp 5,009,000
    Website

    Bahan kg Bubuk
    Dalgona 1 0.1 10
    Shake 1 0.05
    Dark Choco Garnace 1 0.05 20
    Susu 1 0.2 5
    Foam Cheese 0.6 0.1 6

    https://www.tokopedia.com/goldistoko/new-haan-whiptopp-topping-bubuk

    https://www.tokopedia.com/bobatee/boba-pearl-kualitas-premium
    air Cup
    0.1 0.03 3.33 33.33 Shake
    20.00 Bubuk 0.05
    15 40.00 Foam 0.03
    0.8 1 6.67 33.33
    0.25 0.35 1.17 7.00 Dark Choco
    Bubuk Choclat
    DATA KEUANGAN
    update : 06 July 2020

    No Item Desription Qty Satuan Harga Satuan

    B Pembelian Bahan
    1 Pembelian Wipe Cream 1 0 Pack Rp 85,000
    2 ongkos kirim 1 0 hari Rp 18,000
    3 Pembelian Boba 1 0 Pack Rp 24,000
    4 ongkos kirim 1 0 hari Rp 15,000
    5 Dalgona Taro 1 0 Kg Rp 55,000
    6 Dalgona Banana 1 0 Kg Rp 55,000
    7 Dalgona Red Valvet 1 0 Kg Rp 55,000
    8 Dalgona Strawberry 1 1 Kg Rp 55,000
    9 Dalgona Coffee 1 0 Kg Rp 60,000
    10 Dalgona Green Tea 1 0 Kg Rp 75,000
    11 Dark Choco 1 2 Kg Rp 52,000
    12 Susu Fuel Cream 1 2 Kg Rp 100,000
    13 ongkos kirim 1 1 paket Rp 50,000
    14 Shake Taro 1 1 Kg Rp 52,000
    15 Shake Banana 1 1 Kg Rp 52,000
    16 Shake Red Valvet 1 1 Kg Rp 52,000
    17 Shake Strawberry 1 1 Kg Rp 52,000
    19 Shake Green Tea 1 1 Kg Rp 55,000
    18 Cup + Sedotan 1 200 Cup Rp 988

    C Comsumable
    1 Listrik 1 1 lot Rp 75,000
    2 Axogy 1 3 galon Rp 18,000
    3 Aqua 1 2 galon Rp 5,000
    4 Bensin 1 2.5 Liter Rp 10,000
    D Gaji Pekerja
    1 Bunda 8 1 per hari Rp 30,000
    2 Grefith 8 1 per hari Rp 2,000
    Total Hari Jualan
    6

    Sub Harga Harga Grand Total Keterangan

    Rp 409,000
    Rp -
    Rp -
    Rp -
    Rp -
    Rp -
    Rp -
    Rp -
    Rp 55,000
    Rp -
    Rp -
    Rp 104,000
    Rp 200,000
    Rp 50,000
    Rp 52,000
    Rp 52,000
    Rp 52,000
    Rp 52,000
    Rp 55,000
    Rp 197,500

    Rp 164,000
    Rp 75,000
    Rp 54,000
    Rp 10,000
    Rp 25,000
    Rp 256,000
    Rp 240,000
    Rp 16,000
    Website

    Foam Cheese 0.6 0.1 6

    https://www.tokopedia.com/goldistoko/new-haan-whiptopp-topping-bubuk

    https://www.tokopedia.com/bobatee/boba-pearl-kualitas-premium
    0.25 0.35 1.17 7.00 Dark Choco
    Bubuk Choclat
    DATA KEUANGAN
    update : 06 July 2020

    No Item Desription Qty Satuan Harga Satuan

    B Pembelian Bahan
    1 Pembelian Wipe Cream 1 2 Pack Rp 85,000
    2 ongkos kirim 1 1 hari Rp 18,000
    3 Pembelian Boba 1 2 Pack Rp 24,000
    4 ongkos kirim 1 1 hari Rp 15,000
    5 Dalgona Taro 1 1 Kg Rp 55,000
    6 Dalgona Banana 1 1 Kg Rp 55,000
    7 Dalgona Red Valvet 1 1 Kg Rp 55,000
    8 Dalgona Strawberry 1 1 Kg Rp 55,000
    9 Dalgona Coffee 1 1 Kg Rp 60,000
    10 Dalgona Green Tea 1 1 Kg Rp 75,000
    11 Dark Choco 1 2 Kg Rp 52,000
    12 Susu Fuel Cream 1 2 Kg Rp 100,000
    13 ongkos kirim 1 1 paket Rp 50,000

    D Gaji Pekerja
    1 Bunda 8 1 per hari Rp 30,000
    2 Grefith 8 1 per hari Rp 2,000
    Total Hari Jualan
    6

    Sub Harga Harga Grand Total Keterangan

    Rp 960,000
    Rp 170,000
    Rp 18,000
    Rp 48,000
    Rp 15,000
    Rp 55,000
    Rp 55,000
    Rp 55,000
    Rp 55,000
    Rp 60,000
    Rp 75,000
    Rp 104,000
    Rp 200,000
    Rp 50,000

    Rp 256,000
    Rp 240,000
    Rp 16,000
    Website

    Foam Cheese 0.6 0.1 6

    https://www.tokopedia.com/goldistoko/new-haan-whiptopp-topping-bubuk

    https://www.tokopedia.com/bobatee/boba-pearl-kualitas-premium
    0.25 0.35 1.17 7.00 Dark Choco
    Bubuk Choclat

    You might also like