Cash Flow V.1.4

Washing Machine 11 kg (Max Capacity 6 Kg)
JAM KERJA WAKTU PROSES Idling Time PROSES Max HASIL KETERANGAN
(JAM /HARI) (MENIT) (minute) SIKLUS (Kg) (Kg)
A 8 30 5 14 69
60
5
B 10 30 5 17 86
60
note :
1 Mesin cuci 11 kg pintu depan (front load) efektif produksi per proses max
6 kg dengan waktu proses produksi max 30 menit;
2 Kebutuhan listrik 350 W - 400 W.
Dryer Machine 8 Kg (Max Capacity 4 Kg)

JAM KERJA WAKTU PROSES Idling Time PROSES Max HASIL LPG Biaya
(JAM /HARI) (MENIT) (minute) SIKLUS (Kg) (Kg) 12 Kg Gas
A 8 50 5 9 35 1.75
4 225,000
B 10 50 5 11 44 2.18
Note :
1 Mesin pengering Speedqueen (dryer) 8 kg efektif produksi max 4 kg dengan waktu
proses produksi max 50 menit, tergantung tingkat ketebalan kain
2 Kebutuhan Listrik 100 watt
Kebutuhan Gas 0,2 kg / Load / Proses
Produksi Pengeringan dan Penyeretikaan dengan menggunakan Gas LPG 12 Kg

Biaya/Kg Rotasi KETERANGAN
(Rp) Hari
938 7 0.2 kg / Load/
Proses
938 6
PRODUCTION SITE (FIRST PHASE)
Machine Description Qty Unit Price Total Price
Washer Machine
2 18,000,000.00 36,000,000.00
Dryer Machine
LPG TUBE 12 Kg 3 600,000.00 1,800,000.00
Iron steam (Boiler) 1 5,000,000.00 5,000,000.00
Iron steam (Table) 2 3,500,000.00 7,000,000.00
Ironing 2 500,000.00 1,000,000.00
Plastic Basket 25 15,000.00 375,000.00
Pouch serut (25 X 30) 50 10,000.00 500,000.00
Bag for Pick up & Delivery 1 90,000.00 90,000.00
Timbangan Digital 1 250,000.00 250,000.00
Tab Android 1 3,000,000.00 3,000,000.00
Printer Termal 1 900,000.00 900,000.00
Biaya Pasang Meteran 2200 VA 1 3,000,000.00 3,000,000.00
Mesin Pompa air 1 -
Total Invesment Cost 58,915,000.00
VAT 11% 6,480,650.00
Total Incl. VAT 65,395,650.00
Description :
* Mekanisme Pembayaran dapat menggunakan Pay Later
*
*
*
*
*
Ta
Description Qty Unit Price Total Price VAT 11%
Production site 5,500,000

Production site Renovation 1 2,000,000 2,000,000 220,000
ATK 1 1,000,000 1,000,000 110,000
Marketing tools (banner, etc) 1 2,500,000 2,500,000 275,000
- -
Total Price
6,105,000
2,220,000
1,110,000
2,775,000
-
EMPLOYEE (Month)
Description Qty Unit Cost Month
Employee Cost
laundress,ironing , packing 2 1,500,000 1
Pick up and Delivery 0 1,000,000 1
Meals 2 25,000 30
Total Cost 65,395,650.00
6,105,000.00
4,500,000 6 27,000,000 27,000,000
3,000,000 98,500,650.00
-
1,500,000
MONTHLY OPEX
Cilandak Area (Pick Up & Delivery)

Distance Area Coverage 3 km
Operation 2 shift/day
Time 12 Hours
Total Operation Motorcycle 30 Days
Cilandak Area (Electricity )

Daya 2200 VA
Usage 1500 watt
Operation 8&10 Hours
Tariff 2200 / Kwh 1,500 Rupiah
Operation / Month 30 Days
Description Qty Unit Cost Total Cost VAT 11%
Washing
Deterjen (Liter) 1 - -
Air (Liter) 1 - -
Parfum Super 1 - -
Plastik - -
Listrik - -
Employee Cost
laundress,ironing , packing
Pick up and Delivery
Meals
BASIC CALCULATION INFO
A. Cost Pick up & Delivery (Touch Point)
Jarak Coverage (Km) 3
Total Trip /Day 12
Trip / Kecepatan motor 30
Trip 30
Trip / day ( minute) 2
Consumption /Liter 25
Consumption Fuel /Day 0.5
Cost / Liter /Day 10,000
Cost / Liter /Month 30
B. Electricity
Asumsi menggunakan
Total Cost Incl. VAT Remarks Daya minimal 2200 watt
Usage machine & others 1500
- Tariff 2200 / Kwh 1,500
- Operational 30
- Usage / day 8
- 10
- Kilowatt/ hour (Kwh) 8
- 10
Cost Per Day (Rp) 8
10
Cost Per Month (Rp) 8
10
C. Gas (LPG )
Tube 12
Cost 225,000
Tube 3
Tube 12 Kg 3
Cost / Kg
ouch Point)
Km 15 minute
Km
/ Km 5 minute
Minute (back and fort)
60 minute
Km 2 Days
Liter
Rupiah 5,000 Rupiah
150,000 Rupiah
Washing Dryer
Machine
watt
rupiah
days
Hours 12000
Hours 15000
Hours 12
Hours 15
Hours 18,000
Hours 22,500 292 210 Rupiah/Kg
Hours 540,000
Hours 675,000 8,766 6,308 Rupiah/Kg
Kilogram
/ Tube
Kilogram 100 Kilogram
400 Kilogram
563 Rupiah
Gas Sale Price USD 13.5 per MMbtu
Gas Purchase Price USD 9.5 per MMbtu
Currency USD to IDR IDR 14,300
Description 1 2
Revenue - -
#REF! - -
#REF! #REF! MMbtu/h
#REF! #REF! MMbtu/h
#REF! #REF! MMbtu/h
0
Cilandak Area (Pick Up & Delivery) Err:509 MMbtu/h
Operating Cost (Opex)
Cost of Goods - #REF!

#REF! - #REF!
#REF! #REF! MMbtu/h #REF!
0
Cilandak Area (Pick Up & Delivery) Err:509 MMbtu/h
Gross Margin - #REF!
Machinary 65,395,650 -
#REF! 65,395,650 65,395,650
0 -
Machine Operations #REF!

#REF! #REF!
#REF! #REF! #REF!
0 -
Washing -
Employee 4,500,000 #REF!

Head Office 4,500,000 4,500,000 4,500,000
#REF! #REF! #REF!
0 -
Office Operations 126,105,000 25,000,000

Head Office Rent 120,000,000 120,000,000
Head Office G&A Setup 6,105,000 6,105,000
Head Office Operations (listrik, mobil, dll 25,000,000 25,000,000
xx
xx
BPJS - #REF!
BPJS TK 5.40% #REF!
BPJS Kesehatan kelas 2 100,000 #REF! #REF!
Taxes 675,000 #REF!

VAT - -
PPH employee 675,000 #REF!
EBI (Earning Before Interest) - 196,675,650 #REF!
KAS
Saldo Awal 2,000,000,000 4,803,324,350
Saldo Akhir 1,803,324,350 #REF!
Modal 2,000,000,000 3,000,000,000

3 4 5 6 7 8 9 10
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

- Err:509 Err:509 Err:509

Err:509 Err:509 Err:509

Err:509 Err:509 Err:509 Err:509

Err:509 Err:509 Err:509 Err:509
- - - - - - - -

- - - - - - - -
- - - -

4,500,000 4,500,000 4,500,000 4,500,000 4,500,000 9,000,000 4,500,000 4,500,000
- - - -
25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000
25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000



1,000,000,000
11 12 ytd 1 1 2 3 4
#REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF!
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509



#REF! #REF! #REF! ### #REF! #REF! #REF! #REF!
- - 65,395,650 ### - - - -
-

- - - - - -
- - - - - -

4,500,000 4,500,000 4,500,000 4,500,000 4,500,000 4,500,000
- - - - - -
25,000,000 25,000,000 401,105,000 145,000,000 25,000,000 25,000,000 25,000,000

120,000,000
25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000



5 6 7 8 9 10 11 12

Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509



- - - - - - - -

- - - - - - - -
- - - - - - - -

4,500,000 4,500,000 4,500,000 9,000,000 4,500,000 4,500,000 4,500,000 4,500,000
- - - - - - - -
25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000
25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000



ytd 2 1 2 3 4 5 6




- - - - - - -
-
-

- - - - - -
- - - - - -

4,500,000 4,500,000 4,500,000 4,500,000 4,500,000 4,500,000
- - - - - -
420,000,000 145,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000

120,000,000
25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000


#REF! ### #REF! #REF! #REF! #REF! #REF! #REF!

7 8 9 10 11 12 ytd 3




- - - - - - -

- - - - - -
- - - - - -

4,500,000 9,000,000 4,500,000 4,500,000 4,500,000 4,500,000
- - - - - -
25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 420,000,000
25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000



1 2 3 4 5 6 7 8
#REF! #REF! Err:509 Err:509 Err:509 Err:509 Err:509 -

#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509

Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509
#REF! Err:509 Err:509 Err:509 Err:509 Err:509 - -

#REF!
#REF!
#REF!
#REF!

- - - - - - - -
-
-
#REF! - - - - - - -
#REF! - - - - - - -
#REF!
- - - - - -
- - - - - -
#REF! #REF! #REF! #REF! #REF! #REF! 4,500,000 -

4,500,000 4,500,000 4,500,000 4,500,000 4,500,000 4,500,000 4,500,000
- - - - - -
145,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 -

120,000,000
25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000

#REF! #REF! #REF! #REF! #REF! #REF! #REF! -
#REF! #REF! #REF! #REF! #REF! #REF! 243,000 -

#REF! #REF! #REF! #REF! #REF! #REF! 675,000 -

9 10 11 12 ytd 4
- - - - #REF!
- - - - #REF!
- - - - #REF!
- - - - -
- - - - -
- - - -
- - - - #REF!
- - - - 295,000,000
- - - - #REF!
- - - -
- - - - #REF!
- - - -
- - - -
- - - - #REF!
#REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF!
ytd 1 ytd 2 ytd 3
Revenue #REF! #REF! #REF!
Operating Cost (Opex) #REF! #REF! #REF!
COGS #REF! #REF! #REF!

Machinary 65,395,650 - -
Machine Operations #REF! #REF! #REF!
Employee #REF! #REF! #REF!
Office Operations 401,105,000 420,000,000 420,000,000
BPJS #REF! #REF! #REF!
Taxes #REF! #REF! #REF!
EBI (Earning Before Interest) #REF! #REF! #REF!
Modal Awal #REF!

Modal Akhir #REF! #REF! #REF!
ROI #REF!
BEP #REF! tahun #REF!
EMV #REF!
Growth Rate #REF!
ytd 4 yoy
#REF! #REF!
#REF! #REF!
#REF! #REF!
- 65,395,650
- #REF!
#REF! #REF!
295,000,000 1,536,105,000
#REF! #REF!
#REF! #REF!
#REF! #REF!
#REF! #REF!
bulan

Cash Flow V.1.4

Uploaded by

Copyright:

Available Formats

Cash Flow V.1.4

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Cash Flow V.1.4

Uploaded by

Copyright:

Available Formats

Washing Machine 11 kg (Max Capacity 6 Kg)

Dryer Machine 8 Kg (Max Capacity 4 Kg)

Produksi Pengeringan dan Penyeretikaan dengan menggunakan Gas LPG 12 Kg

Machine Description Qty Unit Price Total Price

Production site 5,500,000

Description Qty Unit Cost Month

Cilandak Area (Pick Up & Delivery)

Cilandak Area (Electricity )

Description Qty Unit Cost Total Cost VAT 11%

Operating Cost (Opex)

Cost of Goods - #REF!

Gross Margin - #REF!

Machine Operations #REF!

Employee 4,500,000 #REF!

Office Operations 126,105,000 25,000,000

Taxes 675,000 #REF!

EBI (Earning Before Interest) - 196,675,650 #REF!

Modal 2,000,000,000 3,000,000,000

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

- Err:509 Err:509 Err:509

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

Err:509 Err:509 Err:509 Err:509

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000

25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF!

Err:509 Err:509 Err:509 Err:509 Err:509 Err:509

#REF! #REF! #REF! #REF! #REF! #REF! #REF!

Err:509 Err:509 Err:509 Err:509 Err:509 Err:509

#REF! #REF! #REF! ### #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF!

25,000,000 25,000,000 401,105,000 145,000,000 25,000,000 25,000,000 25,000,000

25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000

#REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000

25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000 25,000,000

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

#REF! #REF! #REF! #REF! #REF! #REF! #REF!

Err:509 Err:509 Err:509 Err:509 Err:509 Err:509

#REF! #REF! #REF! #REF! #REF! #REF! #REF!

Err:509 Err:509 Err:509 Err:509 Err:509 Err:509