Volume 3, Number 14, December 2022

e-ISSN: 2797-6068 and p-ISSN: 2777-0915

 

 


ANALYSIS OF TIME AND COST CONTROL USING THE EARNED VALUE METHOD IN WELL PAD HILLING AND COMPACTING WORK IN THE PT. PERTAMINA HULU ROKAN RIAU PROVINCE

 

Apde Bonny, Wateno Oetomo, Risma Marleno

Universitas 17 Agustus 1945, Surabaya, Indonesia

Email: [email protected], [email protected], [email protected]

 

 

KEYWORDS

Cost, Earned Value Method, Result Value, Scheduling, Time

ABSTRACT

The development of physical facilities in Indonesia is increasing rapidly along with the promotion of modernization. In the implementation of a project it is very rare to find a project that goes exactly as planned. Generally, they experience delays from what was planned, both in terms of time and progress of work, but there are also projects that experience acceleration from the initial schedule planned. The research objectives were to determine time and cost performance, and to determine cost estimates and final project completion time for the Well Pad stockpiling and compaction project in the Rokan Riau Oil and Gas Block environment. The method used in this study is the Earned Value method which combines the elements of cost and time as well as the physical performance of the work. The data obtained from the project includes the project time schedule, budget plan (RAB), project weekly reports and actual costs, then an analysis of costs, schedules, variances and performance indexes is carried out by explaining the problems that arise during the research. Based on the results of the analysis and discussion, the calculation of the CPI value is> 1 from the 1st week to the 16th week. This means that from the 1st week to the 16th week, the project cost is more economical. The EAS calculation for the 16th week estimates the project completion time is 116 days or 16 weeks. This means that the project is experiencing a delay from the planned schedule. At the end of the review period, an estimated final project cost of Rp. 4,022,024,000.00. And the estimated time for project completion is 116 days, which means the project will be completed in a longer time than planned, which is 211 days.

 

INTRODUCTION

The development of physical facilities in Indonesia is increasing rapidly along with the government's promotion of modernization with the aim of welcoming the era of globalization. Various large-scale projects are carried out to meet the increasingly complex needs of society. In the implementation of a project it is very rare to find a project that goes exactly as planned. Generally, they experience delays from what was planned, both in terms of time and progress of work, but there are also projects that experience acceleration from the initial schedule planned. Creating a work plan is one of the first steps in planning. Planning is made to achieve high effectiveness and efficiency of the resources to be used during construction project implementation. The planned resources are labor (man), equipment (machine), method (method), material (material), and money (money). These resources must be planned as efficiently and effectively as possible in order to obtain minimum implementation costs. In an effort to control project performance against costs and time to make it more effective and efficient, proper and measurable management controls are needed. Control over a particular project activity from the company is known as project management.

The construction of physical facilities also moves and supports the mining and oil sector. In supporting the government's program which has set a lifting target of 1 million barrels of crude oil and 12 BSCFD of natural gas in 2023, it is necessary to make efforts to increase upstream oil and gas operational activities such as drilling development wells or exploration wells. Pertamina Hulu Rokan as a subsidiary of Pertamina in charge of managing upstream oil and gas business activities based on a cooperation contract in the Rokan work area is trying to increase production by targeting 500 new wells by 2022. One of the most basic jobs before RIG undertook drilling is well preparation work. Pad as a place to do drilling. The problems currently faced by implementing companies are cost issues and less time allotted for the process of making one Well Pad and the waiting time for project completion because it involves work from other teams. So that there is an additional cost and working time that must be borne by the implementing company. Therefore it is necessary to do an analysis to calculate the cost and time needed to work on the Well Pad.

The purpose of this study was to determine the time and cost performance of the Well Pad filling and compaction project in the Rokan Riau Oil and Gas Block, and to determine the estimated cost and final project completion time.

The benefits of this research are expected to be able to add insight and knowledge, especially in terms of carrying out construction in terms of cost and time control and it is hoped that it will provide an understanding that systematic cost planning in accordance with a determined schedule will be very beneficial for a project implementation

 

RESEARCH METHOD

The method used in this research is descriptive quantitative research that describes the conditions of a particular project by analyzing existing data. Data analysis used analytical and descriptive methods. Analytical means that existing data is processed in such a way as to produce conclusive final results. While descriptive means to describe problems that already exist or appear. The Earned Value method examines the trend of schedule variances and cost variances over a period of time during a project. The research focused on controlling the well pad stockpiling and compaction project from the aspect of time and cost using the Earned Value method

 

RESULTS AND DISCUSSION

Project Overview

The general description of the Well Pad stockpiling and compaction project in the Rokan Riau Oil and Gas Block by PT. Pertamina Hulu Rokan which is used as the object in this final project is as follows:

Project Name: Well Pad Filling and Compaction

Project Location: Rokan Oil and Gas Block Environment, Riau

Name of Service Provider: PT. Pertamina Hulu Rokan

Contract Value: Rp. 5,041,789,130.00

Contract Date: 12 July 2022

Implementation Period: July 19 2022 to November 8 2022

(16 weeks)

Project Performance Identification

In identifying the implementation time, it means analyzing the reporting data on the implementation of activities at a certain time and comparing it with what has been planned, to see the implementation time, a Table 1 can be made.

Table 1

Execution Time Control

week

plan

cumulative

Realization

cumulative

1

0.714

0.714

0.480

0.48

2

0.654

1,368

0.420

0.900

3

0.876

2,244

0.642

1,542

4

0.910

3,154

0.676

2,218

5

0.991

4,145

0.757

2,975

6

1,072

5,217

0.838

3,813

7

2,453

7,670

2,219

6,032

8

3,534

11.204

3,300

9,332

9

5,453

16,657

5,219

14,551

10

7,876

24,533

7,642

22,193

11

10.354

34,887

7,775

29,968

12

15,560

50,447

9,981

39,949

13

17,456

67,903

11,877

51,826

14

16,650

84,553

13,966

65,792

15

12,453

97,006

12,219

78,011

16

2,985

100,000

2,199

80,210

Source : Data Processing (2022)

Figure 2

� Realized S Curve

 

Calculation Analysis Method Earned Value

����������� Calculation Analysis Earned Value on assignments end this form analysis Planned Value (PV), Earned Value (EV) and Actual Cost (AC).

Calculation of BCWS (Budget Cost of Work Schedule)

BCWS = (% progress plan) x (Budget)

Calculation of BCWS in weeks 1st period 19 July 2022 � 26 July 2022:

BCWS = (% plan) x (total project budget)

BCWS = (0.71%) x (Rp. 5,041,789,130.00)

BCWS = Rp. 35,796,703,

Table 2 follows show results calculation Planned Value (PV) in week 1 to with 16th week.

Table 2

Budget Cost of Work Schedule (BCWS)

BCWS = (% Weight plan ) x ( budget )

Sunday to

Weight plan (%)

Contract Value (Rp)

BCWS (Rp)

Cumulative BCWS

1

0.71

5,041,789,130.00

35,998,374

35,998,374

2

0.65

5,041,789,130.00

32,973,301

68,971,675

3

0.88

5,041,789,130.00

44,166,073

113,137,748

4

0.91

5,041,789,130.00

45,880,281

159,018,029

5

0.99

5,041,789,130.00

49,964,130

208,982,159

6

1.07

5,041,789,130.00

54,047,979

263,030,139

7

2.45

5,041,789,130.00

123,675,087

386,705,226

8

3.53

5,041,789,130.00

178,176,828

564,882,054

9

5.45

5,041,789,130.00

274,928,761

839,810,815

10

7.88

5,041,789,130.00

397,091,312

1,236,902,127

11

10.35

5,041,789,130.00

522,026,847

1,758,928,974

12

15.56

5,041,789,130.00

784,502,389

2,543,431,362

13

17,46

5,041,789,130.00

880,094,711

3,423,526,073

14

16.65

5,041,789,130.00

839,457,890

4,262,983,963

15

12.45

5,041,789,130.00

627,854,000

4,890,837,963

16

2.99

5,041,789,130.00

150,497,406

5,041,335,369

�Source: Data Processing (2022)

From Table 2 can seen exists increase Planned Value (PV)/ BCWS value for each week it means plan expenditure cost each week project experience increase.

Calculation of BCWP (Budget Cost of Work Performance)

BCWP = (% progress actual) x (Budget)

Calculation of BCWP in weeks 1st period 19 July 2022 � 26 July 2022:

BCWP = (% actual) x (total project budget)

BCWP = (0.39%) x (Rp. 5,041,789,130.00)

BCWP = Rp. 19,662,978.00

Table 3 below show results calculation Earned Value (EV) in week 1 to with 16th week.

Table 3

Budget Cost of Work Performance (BCWP)

BCWP = (% Weight realization) x ( budget )

Sunday to

Weight realization (%)

Contract Value (Rp)

BCWP (Rp)

Cumulative BCWP

1

0.39

5,041,789,130.00

19,662,978

19,662,978

2

0.42

5,041,789,130.00

21,175,514

40,838,492

3

0.64

5,041,789,130.00

32,368,286

73,206,778

4

0.68

5,041,789,130.00

34,082,495

107,289,273

5

0.76

5,041,789,130.00

38,166,344

145,455,616

6

0.84

5,041,789,130.00

42,250,193

187,705,809

7

2,22

5,041,789,130.00

111,877,301

299,583,110

8

3.30

5,041,789,130.00

166,379,041

465,962,151

9

5,22

5,041,789,130.00

263,130,975

729,093,126

10

7,64

5,041,789,130.00

385,293,525

1,114,386,651

11

7,78

5,041,789,130.00

391,999,105

1,506,385,756

12

9.98

5,041,789,130.00

503,220,973

2,009,606,729

13

11.88

5,041,789,130.00

598,813,295

2,608,420,024

14

13.97

5,041,789,130.00

704,136,270

3,312,556,294

15

12,22

5,041,789,130.00

616,056,214

3,928,612,508

16

2,20

5,041,789,130.00

110,868,943

4,039,481,451

�Source: Data Processing (2022)

From Table 3 can seen exists increase mark Earned Value (EV) on each week it means plan expenditure cost each week project experience increase.

Calculation of ACWP (Actual Cost Work Performance)

Table 4 shows recapitulation results calculation Actual Cost (AC) week 1 arrived with 16th week.

Table 4

Actual Cost Work Performance

Cost Direct and No Live

Sunday to

ACWP (Rp)

Cumulative ACWP (Rp)

1

19,578,000

19,578,000

2

21,084,000

40,662,000

3

32,228,400

72,890,400

4

33,935,200

106,825,600

5

38,001,400

144,827,000

6

42,067,600

167,316,600

7

111,393,800

298,288,400

8

165,660,000

463,948,400

9

261,993,800

725,942,200

10

383,628,400

1,109,570,600

11

390,305,000

1,499,875,600

12

501,046,200

2,000,921,800

13

596,225,400

2,597,147,200

14

701,093,200

3,298,240,400

15

613,393,800

3,911,634,200

16

110,389,800

4,022,024,000

��� ������������������������������������������� �Source: Data Processing (2022)

 

From Table 4 can seen exists increase mark Actual Cost (AC) on each week it means expenditure cost each week project experience increase.

Calculation Analysis Time and Cost Variances Completion Project

a. Calculation of Schedule Variance (SV)

SV is obtained from BCWP reduction with BCWS:

Calculation of SV by week 1st period 19 July 2022 � 26 July 2022:

SV = (BCWP) - (BCWS)

SV = (Rp. 19,662,978.00) - (Rp. 35,998,374.00)

SV = - Rp. 16,335,397.00

b.     Calculation of Cost Variance (CV)

CV obtained from reduction of BCWP with ACWP:

Calculation of CV by week 1st period 19 July 2022 � 26 July 2022:

CV = (BCWP) - (ACWP)

CV = (Rp. 19,662,978.00) - (Rp. 19,578,000.00)

CV = Rp. 84,978.00

Table 5 shows recapitulation results calculation CV and SV 1st week up with 16th week.

Table 5

CV and SV

Sunday to

SV (Rp)

CV (IDR)

1

- 16,335,397

84,978

2

- 28,133,183

176,492

3

- 39,930,970

316,378

4

- 51,728,756

463,673

5

- 63,526,543

628,616

6

- 75,324,330

20,389,209

7

- 87,122,116

1,294,710

8

- 98,919,903

2,013,751

9

- 110,717,689

3,150,926

10

- 122,515,476

4,816,051

11

- 252,543,218

6,510,156

12

- 533,824,633

8,684,929

13

- 815.106.049

11,272,824

14

- 950,427,669

14,315,894

15

- 962,225,455

16,978,308

16

- 1,001,853,918

17,457,451

Source: Data Processing (2022)

Criteria for second indicator above good the SV (Schedule Variance) and CV (Cost Variance) with negative SV and Positive CV are summed up that Profession done more fast from the plan with swallow fee above budget.

Calculation Index Productivity and Completion Performance Project
a. Calculation of Schedule Performance Index (SPI)

SPI obtained from BCWP divided by BCWS:
Calculation of SPI in weeks 1st period 19 July 2022 � 26 July 2022:

SPI = BCWP / BCWS
SPI = (Rp. 19,662,978.00) / (Rp. 35,998,374.00) SPI = 0.546

b.     Calculation of Cost Performance Index (CPI)

CPI obtained from BCWP divided by ACWP:
Calculation of CPI in weeks 1st period 19 July 2022 � 26 July 2022:

CPI = BCWP / ACWP
CPI = (19,662,978.00) / (19,578,000.00)

CPI = 1.004

Table 6 shows recapitulation results calculation of CPI and SPI �1st week up with 16th week.

Table 6

CPI and SPI

Sunday to

CPIs

SPI

1

1.004

0.546

2

1.217

0.592

3

1.225

0.647

4

1.136

0.675

5

1.185

0.696

6

1.306

0.714

7

1,192

0.775

8

1.196

0.825

9

1,199

0.868

10

1.203

0.901

11

1.106

0.856

12

1.11

0.79

13

1.113

0.762

14

1.117

0.777

15

1,12

0.803

16

1.124

0.801

Source: Data Processing (2022)

�SPI value less of 1 shows that time implementation late from planned schedule. CPI value is more big of 1 shows expenditure more small from budget.

 

�Calculation of ETC (Estimate To Complete) and EAC (Estimate At Complete)

ETC earned from BCWP divided by BCWS:
ETC calculation by week 1st period 19 July 2022 � 26 July 2022:

ETC = (Total Budget � BCWP) / CPI
ETC = (Rp. 5,041,789,130.00 - Rp.
19,662,978.00) / 1.004
ETC = Rp. 5,002,422,000.00

EAC is estimation total cost at the end project.

EAC = ACWP + ETC
EAC calculation by week 1st period 19 July 2022 � 26 July 202: EAC =
(Rp. 19,578,000.00) + (Rp. 5,000,422,000.00) EAC = Rp. 5,020,000,000.00

Table 7 shows recapitulation results ETC and EAC calculations 1st week up with 16th week.

Table 7

ETC and EAC

Sunday to

ETC (Rp)

EAC (Rp)

1

5,000,422,000

5,020,000,000

2

4,108,095,299

4,148,757,299

3

4,054,858,627

4,127,749,027

4

4,342,448,424

4,449,274,024

5

4,130,740,206

4,275,567,206

6

3,715,731,600

3,883,048,200

7

3,977,224,763

4,275,513,163

8

3,826,452,705

4,290,401,105

9

3,595,889,685

4,321,831,885

10

3,265,106,717

4,374,677,317

11

3,195,583,537

4,695,459,137

12

2,732,088,529

4,733,010,329

13

2,185,646,874

4,782,794,074

14

1,548,325,738

4,846,566,138

15

993,605,656

4,905,239,856

16

891,859,397

4,913,883,397

Source: Data Processing (2022)

 

�Calculation of ETS (Estimate To Schedule) and EAS (Estimate At Schedule)

ETS = Remaining Time / SPI
ETS calculations by week 1st period 19 July 2022 � 26 July 2022: ETS =
(120) / (0.546)ETS = 210 days

EAS = Completion Time + ETS
EAS calculation by week 1st period 19 July 2022 � 26 July 2022: EAS =
1 + 210 ����������
EAS = 211 days

Table 8 shows recapitulation results ETS and EAS calculations 1st week up with 16th week.

Table 8

Estimated At Schedule

Sunday to

ETS (days)

EAS (days)

1

210.85

211.68

2

193,23

194.82

3

175.25

177.85

4

166.51

170,16

5

159.75

164.56

6

154.07

160,12

7

138.25

147,15

8

124.87

137,87

9

111.36

130.68

10

97,17

125,62

11

88,19

128.66

12

72.75

131,27

13

48,87

127,63

14

23.06

121,14

15

4,32

116.85

16

0.01

116.00

(Source: 2022 Analysis Results)

 

CONCLUSION

The results of the analysis using the EVM (Earned Value Method) method on the Well Pad Piling and Compaction Project in the Rokan Oil and Gas Block Environment, Riau.

The cost performance of the Well Pad Piling and Compaction Project in the Rokan Oil and Gas Block, Riau Province, does not match the budgeted costs in the 16th week, the costs incurred amounted to Rp. 4,022,024,000.00 with an actual weight percentage of 80.21%. Calculation of the CPI value> 1 from the 1st week to the 16th week. This means that from the 1st week to the 16th week, the project cost is more economical.

The time performance of the Well Pad Piling and Compaction Project in the Rokan Oil and Gas Block Environment, Riau, in the 1st to 16th week, the SPI value < 1. This means that in the 1st to 16th week the project was delayed from the planned schedule. The EAS calculation for the 16th week estimates the project completion time is 116 days or 16 weeks. This means that the project is experiencing a delay from the planned schedule.

At the end of the review period, an estimated final project cost of Rp. 4,022,024,000.00. If the trend of project performance conditions is the same as at the end of the review, namely the 16th week, the estimated value does not exceed the total project cost of Rp. 5,041,789,130.00. And the estimated time for project completion is 116 days, which means the project will be completed in a longer time than planned, which is 211 days

�

 

REFERENCES

Alfiyan Rismawan, Ike Pontiawaty, B. (2012). "Study of Cost and Time Control Using the Earned Value Method Case Study on The Grove Apartment HK-PP JO Project."

Amiruddin Hi. Mohammed. (2016). Optimizing the implementation of construction projects using the pert and cpm methods .

Aris Pranoto, D., & Simanta, R. (nd). "Project Control Using the Earned Value Method Case Study on the Rusunawa Project at Diponegoro University Semarang".

April Widiya Laksana , et al , 2014 , Optimization of Project Time and Costs with Program Crash Analysis.

Alam Syahrir, Siswanto , Rian Tri Komara (2015), has study� Analysis Investment Provision of Raw Water for PDAM Tirta Dharma Duri ( Rokan River Intake Raw Water ).

Donny Halim, Siswanto , Trimaijon (2014) has study Analysis Investment System Provision of Clean Water for Duri City (Jurong II River Raw Water Intake).

Farirrahman , 2012, Cost and Time Performance Analysis Method Earned Value on Intensive Building Construction Projects Integrated RSU Dr. Saiful Anwar Malang, Surabaya: ITS

Fathurrahman. (2011). "Analysis of Cost and Time Performance Using the Earned Value Method in the Integrated Intensive Building Development Project at RSU Dr Syauful Anwar - Malang".

Fleming, QW and Koppelman, JM (1994). The Essence and Evolution of. Earned Value. AACE

Gede Suharjono, N. Budiartha R. M, Mayun Nadiasa (2014), reviewed the Determination of Priority for Maintenance of District Roads Based on Availability of Fund Allocations (Case Study of District Roads in Tulungagung District)

Himawan Nur Aredha , et al ., (2018), Value Engineering Analysis on Foundations Bridge ( Study Case : Project Cengger River Bridge , Semarang-Solo Toll Road Section Salatiga-Boyolali Session Ampel-Boyolali ).

Hidayat, A. (2017). Analysis of Cost and Time Performance in the Implementation of Construction Projects Using the Earned Value Method (Case Study of Mall and Hotel X Construction Projects in Pekanbaru). Journal of Engineering and Computer Science , 1 (1).

Ibrahim, Jacob , 2003, Study Appropriateness Business , Edition Revision , Publisher Rineka Copyright , Jakarta.

Johar , A., and Ahmad F., 2001, In Excel Applications Financial Aspects of Study Eligibility , PT. Elex Media Komputindo , Jakarta.

Juliana. (2016). Analysis of Cost and Time Control in Construction Projects Using the Earned Value Management (EVM) Method.

K, JF, Jasim, NA, & Al-Zwainy, FM (2020). Forecasting techniques in the construction industry: Earned value indicators and performance models .

N., K., S., E., & Al., SK et. (2019). Evaluation of Building Construction Project Performance Due to Changes in Contract Documents with the Earned Value Method .

Pujawan , I Nyoman, 2012, Engineering Economics , Edition Second Print Second January 2012, PT. Guna Widya , Jakarta.

Priyo, M. (2021). Earned Value Management System in Indonesian Construction Projects.

Ramdhani, F. (2016). Cost and Time Analysis Using the Earned Value Concept Method in the Bjdm Area Rl Construction At Well 3S-21B Project Area 9 Pt. Adhi Karya Cs Work Unit Rate Packagea � Duri .

Restu Rama Bayu Adi., 2 016 , Acceleration Analysis Project Study Program Crash Method Case : Mixed Use Sentraland Building Development Project .

Suharto , Faith, 1998, Management Project , Edition Second , PT. Erlangga , Jakarta.

Suad Suwarno, Project Feasibility Study, Fourth Edition, UPP

Siahaya, W. (2012). Procurement Management Procurement Management . . London: : Alphabet.

Suharto, I. (1995). Project management from conceptual to operational . Jakarta: Erlangga.

Sudarsana, DK (2008). Integrated Cost and Schedule Control on construction projects .

Tinus Kogoya ., et al ., (2020), has study about Value Engineering on the Manado Bypass Fly Over Interchange Foundation .

Wahab, B. (2019). Application of Cost and Time Control Assessment in Road Improvement Projects Using the Earned Value Method.

 

Copyright holders:

Apde Bonny, Wateno Oetomo, Risma Marleno (2022)

 

First publication right:

Devotion - Journal of Research and Community Service

This article is licensed under a Creative Commons Attribution- ShareAlike 4.0 International