DAFTAR ISI
HALAMAN JUDUL..................................................................................................... HALAMAN PENGESAHAN PEMBIMBING .......................................................... HALAMAN PENGESAHAN PENGUJI.................................................................... SURAT PERNYATAAN KARYA ASLI TUGAS AKHIR ...................................... HALAMAN PERSEMBAHAN ................................................................................... HALAMAN MOTTO................................................................................................... KATA PENGANTAR .................................................................................................. ABSTRAK..................................................................................................................... DAFTAR ISI ................................................................................................................. DAFTAR GAMBAR .................................................................................................... DAFTAR TABEL ......................................................................................................... DAFTAR MODUL PROGRAM .................................................................................
i ii iii iv v vii vii ix x xiii xiv xv
BAB I PENDAHULUAN ............................................................................................. 1.1 Latar Belakang Masalah........................................................................................ 1.2 Rumusan Masalah ................................................................................................. 1.3 Batasan Masalah.................................................................................................... 1.4 Tujuan Penelitian .................................................................................................. 1.5 Manfaat Penelitian ................................................................................................ 1.6 Metodologi Penelitian ........................................................................................... 1.7 Sistematika Penulisan ...........................................................................................
1 1 2 3 3 4 4 4
BAB II LANDASAN TEORI....................................................................................... 2.1 Aplikasi ................................................................................................................. 2.2 Metodologi Pengembangan Sistem....................................................................... 2.3 Data Flow Diagram (DFD) .................................................................................. 2.4 Flowchart .............................................................................................................. 2.5 Basis Data ............................................................................................................. 2.5.1 Entity Relationship Diagram (ERD)........................................................................... 2.5.2 Relasi Antar Tabel (RAT)..................................................................................... 2.6 Structured Query Language (SQL)....................................................................... 2.7 My Structured Query Language (MySQL) ........................................................... 2.8 XAMPP ................................................................................................................. 2.9 Microsoft Visual Studio 2010................................................................................ 2.10 Visual Basic.NET .................................................................................................. 2.11 Cadangan dan Produksi Migas.............................................................................. 2.11.1 Cadangan Migas .................................................................................................. 2.11.2 Produksi Migas .................................................................................................... 2.12 Kajian Keekonomian Minyak Bumi ..................................................................... 2.12.1 Cash Flow............................................................................................................ 2.12.2 Komponen Cash Flow ......................................................................................... 2.12.2.1 Pendapatan Kotor (Gross Revenue).................................................................. 2.12.2.2 Operating Cost ................................................................................................. 2.12.2.3 Investasi ............................................................................................................
6 6 10 12 13 14
x
15
17 18 18 19 20 20 21 21 21 22 22 23 23 24 24
2.12.2.4 Pajak / Tax ........................................................................................................ 2.12.2.5 Abandont Cost .................................................................................................. 2.12.2.6 Sunk Cost .......................................................................................................... 2.12.3 Depresiasi ............................................................................................................ 2.12.4 Indikator-indikator Ekonomi ............................................................................... 2.12.4.1 Payback Periode (PBP) atau Pay Out Time (POT).......................................... 2.12.4.2 Net Present Value (NPV) ................................................................................. 2.12.4.3 Rate of Return (ROR)....................................................................................... 2.12.4.4 Internal Rate of Return (IRR)........................................................................... 2.12.4.5 Profit to Investment Ratio (PIR)....................................................................... 2.12.5 Tinjauan Umum Sistem Production Sharing Contract ....................................... 2.12.5.1 Kontrak Production Sharing (KPS) Generasi I (1964 -1977)........................... 2.12.5.2 Kontrak Production Sharing (KPS) Generasi II (1978 -1987) ......................... 2.12.5.3 Kontrak Production Sharing (KPS) Generasi III (1988 - Sekarang) ................ 2.12.6 Pengertian Beberapa Istilah dalam Production Sharing Contract (PSC) ........... 2.12.6.1 Pendapatan Kotor (Gross Revenue).................................................................. 2.12.6.2 First Trenche Petroleum (FTP) ........................................................................ 2.12.6.3 Equity to be Split .............................................................................................. 2.12.6.4 Pertamina Share................................................................................................ 2.12.6.5 Contractor Share .............................................................................................. 2.12.6.6 Taxable Income ................................................................................................ 2.12.6.7 Goverment Tax ................................................................................................. 2.12.6.8 Recoverable Cost.............................................................................................. 2.12.6.9 Domestic Market Obligation (DMO) ............................................................... 2.13 Studi Pustaka.........................................................................................................
25 25 26 26 27 27 28 29 30 30 31 32 33 34 35 35 35 36 36 36 37 38 38 38 39
BAB III ANALISIS DAN PERANCANGAN ............................................................ 3.1 Rekayasa dan Pemodelan Sistem .......................................................................... 3.2 Analisis Kebutuhan Sistem ................................................................................... 3.2.1 Masukan (Input) .................................................................................................... 3.2.2 Proses..................................................................................................................... 3.2.3 Output .................................................................................................................... 3.2.4 Arsitektur Sistem ................................................................................................... 3.3 Perancangan Sistem .............................................................................................. 3.3.1 Rancangan Proses .................................................................................................. 3.3.1.1 DFD Level 0 ....................................................................................................... 3.3.1.2 DFD Level 1 ....................................................................................................... 3.3.1.3 Flowchart ........................................................................................................... 3.3.2 Rancangan Basis Data ........................................................................................... 3.3.2. 1Rancangan Entity Relationship Diagram (ERD)................................................ 3.3.2.2 Rancangan Tabel ................................................................................................ 3.3.2.3 Relasi Antar Tabel (RAT) .................................................................................. 3.3.3 Rancangan Struktruk Menu ................................................................................... 3.3.4 Rancangan User Interface ..................................................................................... 3.3.4.1 Rancangan Halaman Login................................................................................. 3.3.4.2 Rancangan Halaman Utama ............................................................................... 3.3.4.3 Rancangan Halaman New Project ...................................................................... 3.3.4.4 Rancangan Halaman Menu Awal Project .......................................................... 3.3.4.5 Rancangan Halaman Basic Assumption .............................................................
41 41 41 42 42 42 42 43 43 43 44 45 49 49 50 54 54 56 56 56 57 57 57
xi
3.3.4.6 Rancangan Halaman Scenario 1 (Basecase) ...................................................... 58 3.3.4.7 Rancangan Halaman Scenario 2 ........................................................................ 59 BAB IV IMPLEMENTASI.......................................................................................... 4.1 Perangkat Keras (Hardware) yang digunakan...................................................... 4.2 Perangkat Lunak (Software) yang digunakan ....................................................... 4.3 Implementasi Aplikasi .......................................................................................... 4.3.1 Implementasi Halaman Login .............................................................................. 4.3.2 Implementasi Halaman Utama Aplikasi .............................................................. 4.3.3 Implementasi Halaman Menu Awal Aplikasi ...................................................... 4.3.4 Implementasi Halaman Basic Assumption ........................................................... 4.3.5 Implementasi Halaman Scenario 1 - 4 .................................................................
62 62 62 63 63 64 65 66 68
BAB V PENUTUP ........................................................................................................ 82 51. Kesimpulan............................................................................................................... 82 5.2 Saran ......................................................................................................................... 82 DAFTAR PUSTAKA ................................................................................................... 83
xii
DAFTAR GAMBAR
Gambar 2.1 Gambar 2.2 Gambar 2.3 Gambar 2.4 Gambar 2.5 Gambar 2.6 Gambar 2.7 Gambar 3.1 Gambar 3.2 Gambar 3.3 Gambar 3.4 Gambar 3.5 Gambar 3.6 Gambar 3.7 Gambar 3.8 Gambar 3.9 Gambar 3.10 Gambar 3.11 Gambar 3.12 Gambar 3.13 Gambar 3.14 Gambar 3.15 Gambar 3.16 Gambar 3.17 Gambar 3.18 Gambar 3.19 Gambar 3.20 Gambar 3.21 Gambar 4.1 Gambar 4.2 Gambar 4.3 Gambar 4.4 Gambar 4.5 Gambar 4.6 Gambar 4.7 Gambar 4.8 Gambar 4.9 Gambar 4.10
Tahapan Metode Waterfall ...................................................................... ERD Relasi Satu ke Satu (One to One) ................................................... ERD Relasi Satu ke Banyak (One to Many)............................................ ERD Relasi Banyak ke Banyak (Many to Many) .................................... Dinamika Pengusahaan Migas................................................................. Kurva Komulatif Nilai Uang .................................................................. Bagan Aliran Pembagian Keuntungan Sistem Bagi Hasil....................... Arsitektur Aplikasi .................................................................................. DFD Level 0 ............................................................................................ DFD Level 1 ............................................................................................ Flowchart Perhitungan Pemilihan Scenario............................................ Flowchart Perhitungan Scenario 2 .......................................................... Flowchart Proses Analisa Perbandingan Scenario.................................. Entity Relationship Diagram (ERD) ....................................................... Relasi Antar Tabel (RAT) ....................................................................... Rancangan Struktur Menu ....................................................................... Rancangan Halaman Login.................................................................... Rancangan Halaman Utama ................................................................... Rancangan Halaman New Project ........................................................... Rancangan Halaman Menu Awal Project ............................................... Rancangan Halaman Basic Assumption................................................... Rancangan Rancangan Halaman Scenario 1 (Basecase)......................... Rancangan Halaman Scenario 1 Economic Contract.............................. Rancangan Halaman Scenario 1 Diagram Pie ........................................ Rancangan Halaman Scenario 2 Menu Jadwal ....................................... Rancangan Halaman Scenario 2 Import File Produksi Sumur................ Rancangan Halaman Scenario 2 Economic Contract.............................. Rancangan Halaman Scenario 2 Diagram Pie......................................... Implementasi Antarmuka Halaman Login............................................... Implementasai Antarmuka Halaman Utama Aplikasi ............................. Implementasi Form New Project............................................................. Implementasi Form Open Project ........................................................... Implementasi Halaman Menu Utama Awal Aplikasi.............................. Implementasi Halaman Basic Assumption............................................... Implementasi Halaman Scenario 1 (Basecase) ....................................... Implementasi Halaman Scenario 2 Contract........................................... Implementasi Halaman Schedule pada Scenario 2.................................. Implementasi Halaman Diagram pada Scenario 2 ................................
xiii
11 16 17 17 23 27 35 43 44 45 46 47 49 50 54 55 56 56 57 57 58 58 59 59 60 60 61 61 63 64 65 65 66 66 69 69 73 76
DAFTAR TABEL
Tabel 2.1 Tabel 2.2 Tabel 2.3 Tabel 3.1 Tabel 3.2 Tabel 3.3 Tabel 3.4 Tabel 3.5 Tabel 3.6 Tabel 3.7 Tabel 4.1 Tabel 4.2
Notasi Simbol DFD (Data Flow Diagram)................................................... Notasi Simbol Flowchart .............................................................................. Notasi Simbol ERD (Entity Relationship Diagram) ..................................... Tabel Basic Assumption................................................................................ Tabel Scenario ............................................................................................... Tabel Data Excel ........................................................................................... Tabel Jadwal.................................................................................................. Tabel Depresiasi ............................................................................................ Tabel Admin.................................................................................................. Tabel Project.................................................................................................. Tabel Perangkat Keras yang Digunakan ....................................................... Tabel Perangkat Lunak yang Digunakan ......................................................
xiv
13 14 16 50 51 52 52 53 53 53 62 63
DAFTAR MODUL PROGRAM
Modul Program 4.1 Modul Program 4.2 Modul Program 4.3 Modul Program 4.4 Modul Program 4.5 Modul Program 4.6 Modul Program 4.7 Modul Program 4.8 Modul Program 4.9 Modul Program 4.10 Modul Program 4.11 Modul Program 4.12 Modul Program 4.13 Modul Program 4.14 Modul Program 4.15 Modul Program 4.16 Modul Program 4.17 Modul Program 4.18 Modul Program 4.19 Modul Program 4.20 Modul Program 4.21
Source Code Save Koneksi.net ................................................... Lanjutan Source Code Save Koneksi.net .................................... Source Code Save Basic Assumption .......................................... Lanjutan Source Code Save Basic Assumption........................... Source Code Tampil Scenario .................................................... Lanjutan Source Code Tampil Scenario ..................................... Source Code Import Data Produksi............................................. Source Code Perhitungan Scenario............................................. Lanjutan Source Code Perhitungan Scenario ............................. Lanjutan Source Code Perhitungan Scenario ............................. Source Code Tampil Schedule .................................................... Source Code Simpan Schedule ................................................... Lanjutan Source Code Simpan Schedule .................................... Source Code Hapus Schedule...................................................... Lanjutan Source Code Hapus Schedule ...................................... Source Code Print dan Diagram.................................................. Lanjutan Source Code Print dan Diagram .................................. Lanjutan Source Code Print dan Diagram .................................. Lanjutan Source Code Print dan Diagram .................................. Lanjutan Source Code Print dan Diagram .................................. Lanjutan Source Code Print dan Diagram ..................................
xv
63 64 67 68 69 70 70 71 72 73 74 74 75 75 76 76 77 78 79 80 80