Materi Cost Estimator for beginner and middle

cost estimator

1. PELATIHAN COST ESTIMATOR
Jakarta, 26 Juni 2024
GROUP ENGINEERING AND TECHNOLOGY
PT PERUSAHAAN GAS NEGARA TBK

2. BUSINESS CASE AND FEASIBILITY STUDY
Source:
Evaluation and Funding of Capital Projects in Mining F. K. Crundwell ( 2016)

3. ENGINEERING ESTIMATE
Source : AACE Cost Estimate Classification System
Preliminary Design
Project Location Selection
•Ketersediaan lahan & ROW pipeline
•Ketersediaan infrastruktur existing
•Kedalaman perairan untuk sandar & tambat kapal
•Metocean & klimatologi
Engineering Estimate AACE Class Minimum

4. COST ESTIMATE CLASSIFICATION
Depends on the level of detail of each phase, the estimating level of may
determine the decision to continue with a project or more detail shall be
performed.
Remarks:
Blank = None
S = Started
P = Preliminary
C = Completed

5. ACCURACY LEVEL
Understanding the risk (level of accuracy) of each
phase during deciding to continue with a project may
help in anticipating what to be done to mitigate the
changes.
Class5
Class3
Class2
Class1
30%to100%-20%to-50%
20%to50%-15%to-30%
AccuracyRange
10%to30%-10%to-20%
5% to20%-5%to -15%
3% to15%-3%to -10%
Class4
OutofProjectManagerAuthority
RefertoRisk

6. PERHITUNGAN COST ESTIMATE
HARGA
TOTAL

7. TYPE OF COST
TypeofCost
1.DirectCost
2.IndirectCost
3.Fixed
4.Variable

8. TYPE OF COST
DirectCost
A cost that can be completely attributed to
the production of specific goods or services
-Resource Requirement
Manpower, tool, material
-Project Schedule (duration)
-Risk Register
Risk response which required to be
accommodated to plan
-Quality Management Plan
Cost of Quality
Indirect Cost
Costs that are not directly accountable to
a cost object (such as a particular project,
facility, function or product)
-Resource Requirement
Permit, temporary facilities, etc.
-Project Schedule (duration)
-RiskRegister
Riskresponsewhichrequired
tobe accommodatedtoplan
-QualityManagementPlan
CostofQuality
Overhead Cost
Expenses associated with running a business
that can't be linked to creating or producing a
product or service
-Resource Requirement
Corporate supporting, office rent
-Project Schedule (duration)
-CompanyPortfolio
NumberofProject,BusinessStrategy

9. COST ESTIMATE METHOD
ParametricEstimating(EndUnitor Physical)
Analogous Estimating (Top Down)
Use values, or attributes of previous projects that
are similar to current project.
Ex: In estimating 100 MW Power Generation Project in South Sumatra
Area, the cost of 90 MW Power Generation Project in North Sumatra
can be used.
Bottom Up Estimating
Three Point Estimating
Estimation done by considering estimation
uncertainty and risk, using three estimates to
define range.
Ex: Record shows 1 Dia-Inch piping work in North
Sumatra is 3$. The cost for 765 Dia-Inch piping
work in South Sumatra approximately 765 x 3 =
2,295$
Estimation done on the greatest level of specified detail.
100% rule apply when Cost Aggregation is performed.
Ex: See Cost Aggregation
Use a statistical relationship between relevant
historical data and other variable to calculate.

10. COST ESTIMATE METHOD
RegressionAnalysis
Statisticalmethodtodeterminecorrelationbetweentwo variable
Ex:Indeterminingestimatedcostforconcreteperm3basedon
projectdistancewiththebatchingplant.
Withtheequation,givenprojectlocationis35kmfrom
batchingplant,wecanconcludethecostsillbe
2.81x35+82.47=180USD
Data Distancefrom
BatchingPlant
(km)
ConcretePrice
(USD)
1 12 100
2 14 120
3 10 100
4 11 100
5 20 150
6 40 200
7 50 200
8 40 200
9 30 180
10 20 170
y=2.8149x
R²=0.
+82.472
8589
250
200
150
100
50
0
0 10 50 60
Concrete
Price
(USD)
20 30 40
DistancefromBatchingPlant
y = 753.53x
-0.474
0
20
40
60
80
100
120
140
160
180
200
0 50 100 150 200 250
Regression Analysis Pipa Offshore
Series1
Power (Series1)
Contoh Perhitungan Pipa Offshore (Data Historis)

11. COST ESTIMATE METHOD
NormalDistribution
Probabilitydistributionthatissymmetricaboutthemean
Ex:Indeterminingestimatedcostforconcreteperm3based ongivendata.
Data ConcretePrice
(USD)
1 100
2 120
3 100
4 100
5 150
6 200
7 200
8 200
9 180
10 170
P50 160
P90 200
P10 100
AVG 152
FORMULAIN EXCEL
=PERCENTILE.INC([range],0.5)
=PERCENTILE.INC([range],0.9)
=PERCENTILE.INC([range],0.1)
=AVERAGE([range])
P10–P90
P90
P10

12. COST ESTIMATE METHOD
Capacity Method
Estimation done which relies to non-linear relationship
between capacity and cost.
Rough guideline,n = 0.6 – 0.7
CAPACITYFACTOR-Thepowern<1.0(usually)!
COST
BFACTOR
B
COST FACTOR
n
A
=
A

13. COST ESTIMATE METHOD
CAPACITY
(TPH)
LN
($)
NONLN
($)
Parametric
($)
1050 515 516 525
1100 530 532 550
1150 545 547 575
1200 560 563 600
1250 575 578 625
1300 590 593 650
1350 605 607 675
1400 620 622 700
1450 635 636 725
750
700
650
600
550
500
450
950 1050 1150 1350 1450 1550
COST
1250
CAPACITY
LN
($)
NONLN
($)
Parametric
($)
CAPACITYMETHOD
CAPB=1,500TPH
CAPA=1,000TPH
$B=650,000USD
$A=500,000USD
CAPB/CAPA=1.5
$B/$A=1.3
e=0.65(calculated)
$C=$Ax(CAPB/CAPA)
e
$C=500,000x(1.5)
0.65
=563,000USD
Ex:
TheCompanyintendedtobuildadditionalfactorywithcapacityof
1200TonperHour(TPH)toaccommodaterawmaterial
productionincrementinSouthSumatraregion.Calculatingthe
presentvalueof2existingfactory,theCompanyhasthefollowing
information:
FactoryA:Capacity1000TPH,Cost500,000USD
FactoryB:Capacity1500TPH,Cost650,000USD
Calculatethepotentialcostof1200TPHfactorytobebuilt

14. CAPEX GAS PIPELINE PROJECT

15. OPEX GAS PIPELINE PROJECT

16. EQUIPMENT COST ESTIMATE

17. CE INDEX COST ESTIMATE

18. PERATURAN KEUNTUNGAN – HPS
Sumber :
Peraturan Lembaga Kebijakan Pengadaan Barang/Jasa Pemerintah Republik Indonesia Nomor 12
Tahun 2021 Tentang Pedoman Pelaksanaan Pengadaan Barang/Jasa Pemerintah Melalui Penyedia

19. HARGA JUAL GAS BUMI MELALUI PIPA
Sumber :
PERATURAN MENTERI ENERGI DAN SUMBER DAYA MINERAL REPUBLIK INDONESIA NOMOR 14 TAHUN 2019
TENTANG PERUBAHAN ATAS PERATURAN MENTERI ENERGI DAN SUMBER DAYA MINERAL NOMOR 58 TAHUN 2017
TENTANG HARGA JUAL GAS BUMI MELALUI PIPA PADA KEGIATAN USAHA HILIR MINYAK DAN GAS BUMI

20. APLIKASI HARGA
SATUAN

21. OBJECTIVE APLIKASI HARSAT
HARGA SATUAN
Identifikasi GoalsBusiness Initiative/Improvement
Belum tersedianya sistem database terkait harga
satuan material jaringan dan konstruksi, yang
bisa diakses dan digunakan dengan mudah oleh
semua Perwira PGN
Penyediaan aplikasi database harga
satuan material jaringan dan
konstruksi untuk pekerjaan pipeline
dan beyond pipeline (CNG & LNG) yang
dilengkapi dengan data pendukungnya
Tersedianya aplikasi database Harga Satuan.
Dengan adanya aplikasi database harga
satuan material jaringan dan
konstruksi, Perwira PGN dapat dengan mudah
mendapatkan informasi harga satuan material,
jaringan dan harga satuan konstrArahauksi
dengan cepat yang diperlukan dalam membuat
perhitungan biaya pekerjaan untuk pipeline
dan beyond pipeline, serta dapat membuat
rencana anggaran biaya atas pekerjaan terkait
dan terdokumentasi dengan baik

22. LINGKUP HARGA SATUAN
1.Harga Satuan Material Jaringan Pipeline
2.Harga SatuanMaterial Beyond Pipeline
3.Arithmetic Trend Harga Material Jaringan
ENGINEERING
1.Harga Satuan Material Konstruksi
2.Harga SatuanKonstruksiDan EstimasiDistribusiPipa Baja Dan PE
3.Harga Satuan Konstruksi Dan Estimasi Instalasi Pipa Baja & PE
4.Harga Satuan Konstruksi Dan Estimasi Pipa PA12
5.Harga Satuan Estimasi Pipa Premier
6.Harga Satuan Konstruksi dan Estimasi Beyond Pipeline
7.Dashboard Rules Of Thumb
8.Arithmetic Trend Harga Konstruksi
CONSTRUCTION
Aplikasi Database Harga Satuan Material Jaringan dan Konstruksi untuk pekerjaan pipeline dan beyond pipeline (CNG
dan LNG) yang dilengkapi data pendukungnya
WEBSITE

23. PENYUSUNAN HSMJ 2025
LINGKUP HARGA SATUAN

24. FLOW CHART PERHITUNGAN HSMJ
LINGKUP HARGA SATUAN

25. HARGA SATUAN MATERIAL KONSTRUKSI
LINGKUP HARGA SATUAN
HARGA SATUAN MATERIAL KONSTRUKSI

26. HARGA SATUAN ESTIMASI

27. HARGA SATUAN KONSTRUKSI

28. HARGA SATUAN KONSTRUKSI

29. SEBARAN WILAYAH AHS KONSTRUKSI

30. ALUR DATA HARSAT
Database komponen Analisa Harga Satuan
Daftar Asumsi
Daftar Kegiatan
Daftar Tenaga Kerja
Daftar Alat
Daftar Material
Daftar Harga
Lainnya
Analisa Harga Satuan Pekerjaan
Asumsi
Perhitungan
Scope Pekerjaan
Referensi
Scope Pekerjaan
Produktivitas
Kerja
Komponen
Tenaga Kerja
Komponen Alat
Komponen
Material
Komponen
Lainnya
Biaya Tenaga
Kerja
Biaya Alat
Biaya Material
Biaya Lainnya
Harga Satuan Pekerjaan
Daftar
Analisa Harga Satuan
Pekerjaan
Rekapitulasi
Harga Satuan Pekerjaan
Rencana Anggaran
Biaya
Daftar Alat K3PL
Harga Satuan Material
Jaringan
Daftar Harga Satuan
Material Jaringan
Simulasi Rencana
Anggaran Biaya
Harga Satuan
Estimasi

31. SIMULASI HARSAT
Tampilan Dashboard Aplikasi Harsat

32. SIMULASI HARSAT

33. SIMULASI HARSAT

34. Terima Kasih