”BUDGET RISK ANALYSIS IN PT. WASKITA KARYA 2007 BUDGET PLAN: BASIS 2006 ANNUAL REPORT” FINAL PROJECT
By Tutik Inayati 19004012
Undergraduate Program School of Business and Management Institut Teknologi Bandung
ABSTRACT This research is due to look to the future about PT. Waskita Karya’s prospectus. In 2007 budget plan, this study aims about the reliability and accuracy of budget plan. PT. Waskita Karya is a state-owned construction company that soon will undergo restructuring and privatization. But, in 2007 PT. Waskita Karya is having trouble in handling cash flow. This study will discuss about probability of how far can PT. Waskita Karya achieve its own target in 2007, and how the position of cash flows in PT. Waskita Karya itself. By measuring the probability and accuracy of projects received or won by PT. Waskita Karya. This study suggests PT. Waskita Karya to manage its cash flow more properly, because if cash flow is negative, then PT. Waskita Karya is considered unhealthy company. Second suggestion is for PT. Waskita Karya to diverse its products to another business development rather than only focusing on construction service. Key words: Probability, sensitivity analysis, cash flow, budget plan.
i
ABSTRAK Studi ini bertujuan untuk melihat ke depan dari prospek PT. Waskita Karya. Pada RKAP 2007, studi ini ditujukan untuk melihat tingkat keterkaitan dan keakuratan dari anggaran itu sendiri. PT. Waskita Karya adalah perusahaan pemerintah yang bekerja di bidang konstruksi dan sebentar lagi akan menjalani restrukturisasi dan privatisasi. Akan tetapi, pada tahun 2007 PT. Waskita Karya mengalami kesulitan dalam mengatur arus kas. Dan sebagian besar pendapatan PT. Waskita Karya berasal dari proyek – proyek tender maupun non-tender. Studi ini akan membahas mengenai probabilitas akan seberapa jauh PT. Waskita Karya dapat mencapai target yang telah dibuatnya sendiri dalam anggaran 2007, dan bagaimana posisi dari arus kas di dalam PT. Waskita Karya. Dengan menggunakan metode sensitivitas maka akan menunjukkan letak keuangan PT. Waskita Karya pada tahun 2007. Studi ini menyarankan agar PT. Waskita Karya dapat mengatur arus kasnya dengan baik yang nantinya akan dibahas di studi ini, karena apabila arus kas negatif, maka PT. Waskita Karya dapat dianggap sebagai perusahaan tidak sehat. Saran yang kedua adalah bagi PT. Waskita Karya untuk menjalankan diversifikasi produk ke berbagai pengembangan bisnis baru daripada hanya fokus ke jasa konstruksi.
Kata kunci: Probabilitas, analisa sensitivitas, arus kas, anggaran.
ii
VALIDATION PAGE
”BUDGET RISK ANALYSIS IN PT. WASKITA KARYA 2007 BUDGET PLAN: BASIS 2006 ANNUAL REPORT”
By: Tutik Inayati ID No: 19004012
Undergraduate Program School of Business and Management Institut Teknologi Bandung
Validated By
(Dr. Sudarso Kaderi Wiryono)
iii
FOREWORD Alhamdulillah, I praise for Allah S.W.T for all gifts that have been given to me. My gratitude to my parents, and my family for having supported me all these years especially in working this final project, a lot of thankfulness for my mentor, Dr. Sudarso Kaderi Wiryono, my guardian in SBM-ITB for three whole years, Ir. Budi Permadi Iskandar, MSP, and also Mrs. Yunieta for helping me to go through hard times in working on this final project. Mr. Bambang Kunto, head of risk management bureau PT. Waskita Karya. Dr. M. Machmudin Jusuf, commissioner of PT. Waskita Karya. I would like to thank for Wisnawan Bayuadi Priyono who keeps helping me searching data for my final project and supports me in any kind of condition, for all of Dr. Sudarso Kaderi Wiryono’s students, for sharing information and discussion. My best friends not only in SBMITB but also outside SBM-ITB, Maharani, Karina, M. Arief Baskoro, Eguh P, Ivan R, Tri Yudha, Pandu W, M. Rifki, Alfin M, Gebyar P, Meilida N, Johan I.T, Dharma S, m. Krishna W, and other names whom I can’t mention. I also would like to thank Alamanda open house that accepted me for the last two weeks, and all of my friends there.
iv
LIST OF TABLES Table 4.1. 2007 gross profit target from project
29
Table 4.2. Comparison between actual and PT. Waskita Karya assumption
34
Table 4.3. Comparison between RKAP 2006, Prognosis 2006, RKAP 2007, and Prognosis 2007 40
v
LIST OF FIGURES Figure 2.1. Example of S Curve Figure 3.1. Flow of methodology Graph 4.1. Cost curve for 2007 budget plan Graph 4.2. Cost curve from actual estimation 2007
21 23 38 39
vi
LIST OF CONTENT ABSTRACT
i
ABSTRAK
ii
Validation Page
iii
Foreword
iv
List of tables
v
List of Figures
vi
List of content
vii
1. Introduction
1
1.1. Background
1
1.2. Main problem formulation
2
1.3. Importance of problem solving
3
1.4. Steps for problem solving
3
1.4.1. Problem identification
4
1.4.2. Data collecting
4
1.4.3. Literature study
4
1.4.4. Budget risk analysis
4
1.4.5. Sensitivity analysis
5
1.5. Writing systematics
5
1.5.1. Chapter 1 Introduction
5
1.5.2. Chapter 2 Theoretical Foundation
5
1.5.3. Chapter 3 Methodology
5
1.5.4. Chapter 4 Data Analysis
5
1.5.5. Chapter 5 Discussion/Conclusion
6
2. Theoretical Foundation
7
2.1. Risk and risk management
7
2.1.1. Basic concept of risk management
7
2.1.2. Purposes of risk management
10
2.2. Financial risk management
11
2.2.1. Corporate culture
12
2.2.2. Policies and procedures
13
vii
2.2.3. Technology
16
2.2.4. Independence
17
2.3. Sensitivity analysis
19
2.4. S Curve
20
2.5. Cash flow
22
3. Methodology
23
3.1. Problem identification
24
3.2. Literature study
24
3.3. Data collecting
24
3.3.1. Primary data
24
3.3.2. Secondary data
25
3.4. Analysis
25
3.4.1. Probability
25
3.4.2. Cost curve
25
3.4.3. Comparison
26
3.5. Sensitivity analysis
26
3.6. Conclusion
26
3.7. Suggestion
26
4. Data collecting and analysis
27
4.1. Data collection
27
4.1.1. Division of project in PT. Waskita Karya
27
4.1.1.1. Product line I
27
4.1.1.2. Product line II
28
4.1.1.3. Product line III
28
4.1.2. Tender target 2007 (contract)
28
4.1.3. Gross profit from projects
29
4.1.4. Historical data from year 2004, 2005, and 2006
30
4.2. Analysis
30
4.2.1. Probability
30
4.2.1.1. Probability of product line I
31
4.2.1.1.1. Office building
31
viii
4.2.1.1.2. Shopping center
32
4.2.1.1.3. Hotels
32
4.2.1.1.4. Hospitals
32
4.2.1.1.5. Apartments
33
4.2.1.1.6. Religious facility
33
4.2.1.1.7. Industry building
33
4.2.1.2. Probability of product line II
34
4.2.1.2.1. Highway project
35
4.2.1.2.2. Pantura road, Java Island
35
4.2.1.2.3. National roads in many provinces
35
4.2.1.2.4. JORR (Jakarta Outer Ring Road)
35
4.2.1.2.5. Flyover and underpass DKI
36
4.2.1.2.6. Road and bridge project
36
4.2.1.2.7. Airport project
36
4.2.1.2.8. Seaport in east side of Indonesia project
37
4.2.1.2.9. Foreign project
37
4.2.1.3. Product line III
37
4.2.2. Cost curve analysis
38
4.2.3. Comparison between 2006 and 2007
40
4.2.4. Sensitivity analysis
41
4.2.4.1. Moderate case cash flow statement
42
4.2.4.2. Worst case (pessimist scenario)
42
4.2.4.3. Best case (optimist scenario)
42
5. Conclusion and suggestion
45
5.1. Conclusion
45
5.2. Suggestion
46
6. Reference
49
ix