SISTEM INFORMASI PENYUSUNAN MASTER BUDGET DI PT. YUTAKA MANUFACTURING INDONESIA

SISTEM INFORMASI PENYUSUNAN MASTER BUDGET DI PT. YUTAKA MANUFACTURING INDONESIA

FAJRI AGUSMAN 41813120208

PROGRAM STUDI SISTEM INFORMASI FAKULTAS ILMU KOMPUTER UNIVERSITAS MERCU BUANA JAKARTA 2016

http://digilib.mercubuana.ac.id/



KATA PENGANTAR

Puji syukur penulis panjatkan kepada Allah SWT atas rahmat, karuniaNya, serta hidayahNya selama ini, sehingga penulis dapat menyelesaikan Skripsi ini dimana sebagai syarat dalam menyelesaikan Strata 1 (satu) Jurusan Sistem Informasi di Universitas Mercu Buana Jakarta tepat pada waktu yang ditentukan. Dalam penyusunan Skripsi ini penulis menyadari bahwa Tugas Akhir ini masih jauh sempurna, oleh karena itu penulis sangat menerima kritik, saran atau masukan yang bersifat membuat kesempurnaan pada Tugas Akhir ini. Dalam pembuatan Skripsi ini penulis sangat berterimakasih kepada pihak – pihak yang telah memberikan dukungan selama ini, diantaranya : 1. Allah SWT atas izin dan rahmatNya. 2. Orang tua dan keluarga besar Amran tercinta, dalam memberikan dukungan serta pengertian yang besar selama ini. 3. Sdri. Rahmi Savitri, calon istri penulis yang terus membantu melalui moral dan pikirannya kepada penulis dalam kehidupan bersama beliau. 4. Ibu Sarwati Rahayu, ST, MMSI selaku dosen pembimbing dan seluruh dosen pengajar selama dalam masa kuliah dan dalam memberikan bimbingannya sehingga penulisan Skripsi ini dapat selesai pada waktunya. 5. PT. Yutaka Manufacturing Indonesia untuk izin dan kerjasamanya demi lancarnya pembuatan Skripsi ini. 6. Seluruh teman – teman jurusan Sistem Informasi yang selama ini memberi dukungan, pengetahuan, dan ilmunya. Akhir kata penulis ucapkan terimakasih kepada semua pihak atas bantuan dan dukungannya selama ini.

Jakarta, 9 Januari 2016

Fajri Agusman


DAFTAR ISI Halaman LEMBAR PERNYATAAN ......................................................................................................

i

LEMBAR PENGESAHAN ......................................................................................................

ii

KATA PENGANTAR ...............................................................................................................

iii

ABSTRACT ...............................................................................................................................

iv

ABSTRAK .................................................................................................................................

v

DAFTAR ISI..............................................................................................................................

vi

DAFTAR GAMBAR .................................................................................................................

x

DAFTAR TABEL .....................................................................................................................

xiii

BAB I PENDAHULUAN 1.1 Latar Belakang ...............................................................................................................

1

1.2 Rumusan Masalah ...........................................................................................................

2

1.3 Batasan Masalah .............................................................................................................

2

1.4 Tujuan dan Manfaat Penelitian .......................................................................................

2

1.5 Metodologi Penelitian .....................................................................................................

3

1.5.1 Metode Pengumpulan Data ....................................................................................

3

1.5.2 Metode Analisa ......................................................................................................

3

1.5.3 Metode Pemodelan Sistem .....................................................................................

4

1.5.4 Metode Pengembangan Sistem ..............................................................................

4

1.6 Sistematika Penulisa .......................................................................................................

5

BAB II LANDASAN TEORI 2.1 Sistem Informasi .............................................................................................................

6

2.1.1 Pengertian Sistem...................................................................................................

6

2.1.2 Karakteristik Sistem ...............................................................................................

6

2.1.3 Klasifikasi Sistem ..................................................................................................

7

2.1.4 Pengertian Informasi ..............................................................................................

8

2.1.5 Kualitas Informasi ..................................................................................................

8

2.1.6 Nilai Informasi .......................................................................................................

9


2.1.7 Pengertian Sistem Informasi ..................................................................................

9

2.1.8 Komponen Sistem Informasi .................................................................................

9

2.1.9 Pengertian Master Budget ......................................................................................

10

2.1.10 Komponen Master Budget ...................................................................................

10

2.2 Analisa dan Perancangan Sistem ....................................................................................

11

2.2.1 Pengertian Analisa Sistem .....................................................................................

11

2.2.2 Pengertian Perancangan Sistem .............................................................................

11

2.2.3 Model Waterfall .....................................................................................................

11

2.3 UML (Unified Modeling Languange) .............................................................................

12

2.3.1 Class Diagram ........................................................................................................

12

2.3.2 Use Case Diagram ..................................................................................................

13

2.3.3 Sequence Diagram .................................................................................................

14

2.4 Basis Data .......................................................................................................................

15

2.4.1 Database Management System (DBMS) ...............................................................

15

2.5 Perangkat Lunak Pendukung ..........................................................................................

16

2.5.1 Microsoft Visual Studio .........................................................................................

16

2.5.2 Janus Winforms Control Suite ...............................................................................

17

2.5.3 Microsoft SQL Server ............................................................................................

18

2.5.4 VB. Net ..................................................................................................................

18

2.6 Pengertian Desktop Base ................................................................................................

18

2.7 Metode Pengujian Black Box .........................................................................................

18

BAB III ANALISA DAN PERANCANGAN 3.1 Sejarah Perusahaan .........................................................................................................

20

3.1.2 Struktur Organisasi ................................................................................................

21

3.2 Analisa Sistem Berjalan ..................................................................................................

34

3.2.1 Flowchart Diagram Sistem Berjalan ......................................................................

35

3.3 Analisa Sistem Usulan ....................................................................................................

37

3.3.1 Use Case Diagram ..................................................................................................

37

3.3.2 Activity Diagram....................................................................................................

44

3.3.3 Sequence Diagram .................................................................................................

52

3.3.4 Class Diagram ........................................................................................................

55


3.3.5 Struktur Basis Data ................................................................................................

56

3.4 Rancangan Layar ............................................................................................................

69

3.4.1 Rancangan Layar Cost Allocation .........................................................................

69

3.4.2 Rancangan Layar Work Center ..............................................................................

69

3.4.3 Rancangan Layar Form ..........................................................................................

70

3.4.4 Rancangan Layar Budget Class .............................................................................

70

3.4.5 Rancangan Layar Account Distribution List..........................................................

71

3.4.6 Rancangan Layar Part Report ................................................................................

71

3.4.7 Rancangan Layar Model ........................................................................................

72

3.4.8 Rancangan Layar Budget Period............................................................................

72

3.4.9 Rancangan Layar Item List ....................................................................................

73

3.4.10 Rancangan Layar Dimension ...............................................................................

73

3.4.11 Rancangan Layar Mapping Category...................................................................

74

3.4.12 Rancangan Layar Item Verification .....................................................................

74

3.4.13 Rancangan Layar Sales ........................................................................................

75

3.4.14 Rancangan Layar Man Power Planning ...............................................................

75

3.4.15 Rancangan Layar Employee Compensation & Labor Cost .................................

76

3.4.16 Rancangan Layar Other Income...........................................................................

76

3.4.17 Rancangan Layar Other Expense .........................................................................

77

3.4.18 Rancangan Layar Depreciation New Asset..........................................................

77

3.4.19 Rancangan Layar Depreciation Existing Asset ....................................................

78

3.4.20 Rancangan Layar Request Item ...........................................................................

78

3.4.21 Rancangan Layar Exception Form .......................................................................

79

3.4.22 Rancangan Layar Monthly Budget Request ........................................................

79

3.4.23 Rancangan Layar Master Budget Request ...........................................................

80

3.4.24 Rancangan Layar Dialog Report ..........................................................................

80

3.4.25 Rancangan Layar Setting Ratio & Manual Justification ......................................

81

3.4.26 Rancangan Layar History Simuation ...................................................................

81

3.4.27 Rancangan Layar Proportional to Detail ..............................................................

82

3.4.28 Rancangan Layar Generate Budget ID ................................................................

82


BAB IV IMPLEMENTASI DAN PENGUJIAN 4.1 Implementasi Sistem .......................................................................................................

83

4.2 Implementasi Basis Data .................................................................................................

83

4.3 Implementasi Antar Muka ..............................................................................................

99

4.4 Pengujian.........................................................................................................................

142

4.4.1 Skenario Pengujian ................................................................................................

143

4.4.2 Hasil Pengujian ......................................................................................................

147

4.4.3 Analisa Hasil Pengujian .........................................................................................

151

BAB V PENUTUP 5.1 Kesimpulan .....................................................................................................................

152

5.2 Saran ...............................................................................................................................

152

DAFTAR PUSTAKA LAMPIRAN


DAFTAR GAMBAR

Halaman 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. 42.

Gambar 2.1 Model Waterfall ......................................................................................... Gambar 2.2 Tampilan Microsoft Visual Studio ............................................................. Gambar 2.3 Janus Winforms Control Suite ................................................................... Gambar 3.1 Struktur Organisasi PT. Yutaka Manufacturing Indonesia ........................ Gambar 3.2 Flowchart Diagram Sistem Berjalan .......................................................... Gambar 3.3 Flowchart Diagram Sistem Berjalan (Lanjutan) ........................................ Gambar 3.4 Use Case Diagram Sistem Berjalan ........................................................... Gambar 3.5 Use Case Diagram Sistem Usulan.............................................................. Gambar 3.6 Activity Diagram Setting Parameter .......................................................... Gambar 3.7 Activity Diagram Send form Request Budget............................................ Gambar 3.8 Activity Diagram Make Budget Request ................................................... Gambar 3.9 Activity Diagram Review & Rekapitulate Data Budget ............................ Gambar 3.10 Activity Diagram Make Report ................................................................ Gambar 3.11 Activity Diagram Budget Simulation....................................................... Gambar 3.12 Activity Diagram Create Budget ID ........................................................ Gambar 3.13 Activity Diagram Setting Parameter Budget usulan ................................ Gambar 3.14 Activity Diagram Input Master Budget usulan ........................................ Gambar 3.15 Activity Diagram Verifikasi Data Budget usulan .................................... Gambar 3.16 Activity Diagram Generate Laporan Usulan............................................ Gambar 3.17 Activity Diagram Setting Ratio & Simulasi Budget usulan ..................... Gambar 3.18 Activity Diagram Create Budget ID usulan ............................................. Gambar 3.19 Sequence Diagram Setting Parameter Budget ......................................... Gambar 3.20 Sequence Diagram Input Master Budget ................................................. Gambar 3.21 Sequence Diagram Verifikasi Data Budget ............................................. Gambar 3.22 Sequence Diagram Generate Laporan ...................................................... Gambar 3.23 Sequence Diagram Simulasi Budget ........................................................ Gambar 3.24 Sequence Diagram Generate Budget ID .................................................. Gambar 3.25 Class Diagram Sistem Usulan .................................................................. Gambar 3.26 Rancangan Layar Cost Allocation ........................................................... Gambar 3.27 Rancangan Layar WorkCenter ................................................................. Gambar 3.28 Rancangan Layar Form ............................................................................ Gambar 3.29 Rancangan Layar Budget Class ............................................................... Gambar 3.30 Rancangan Layar Account Distribution List............................................ Gambar 3.31 Rancangan Layar Part Report .................................................................. Gambar 3.32 Rancangan Layar Model .......................................................................... Gambar 3.33 Rancangan Layar Budget Period.............................................................. Gambar 3.34 Rancangan Layar Item List ...................................................................... Gambar 3.35 Rancangan Layar Dimension ................................................................... Gambar 3.36 Rancangan Layar Mapping Category....................................................... Gambar 3.37 Rancangan Layar Item Verification ......................................................... Gambar 3.38 Rancangan Layar Sales ............................................................................ Gambar 3.39 Rancangan Layar Man Power Planning ...................................................


11 16 17 21 35 36 38 41 44 44 45 45 46 46 47 48 48 49 50 50 51 52 52 53 53 54 54 55 69 69 70 70 71 71 72 72 73 73 74 74 75 75

43. 44. 45. 46. 47. 48. 49. 50. 51. 52. 53. 54. 55. 56. 57. 58. 59. 60. 61. 62. 63. 64. 65. 66. 67. 68. 69. 70. 71. 72. 73. 74. 75. 76. 77. 78. 79. 80. 81. 82. 83. 84. 85. 86. 87. 88. 89. 90.

Gambar 3.40 Rancangan Layar Employee Compensation & Labor Cost ..................... Gambar 3.41 Rancangan Layar Other Income............................................................... Gambar 3.42 Rancangan Layar Other Expense ............................................................. Gambar 3.43 Rancangan Layar Depreciation New Asset.............................................. Gambar 3.44 Rancangan Layar Depreciation Existing Asset ........................................ Gambar 3.45 Rancangan Layar Request Item .............................................................. Gambar 3.46 Rancangan Layar Exception Form ........................................................... Gambar 3.47 Rancangan Layar Monthly Budget Request ............................................ Gambar 3.48 Rancangan Layar Master Budget Request ............................................... Gambar 3.49 Rancangan Layar Dialog Report .............................................................. Gambar 3.50 Rancangan Layar Setting Ratio & Manual Justification .......................... Gambar 3.51 Rancangan Layar History Simulation ...................................................... Gambar 3.52 Rancangan Layar Proportional to Detail .................................................. Gambar 3.53 Rancangan Layar Generate Budget ID .................................................... Gambar 4.1 Tampilan Tabel ActDesc............................................................................ Gambar 4.2 Tampilan Tabel ADLHeader...................................................................... Gambar 4.3 Tampilan Tabel ADLTrans ........................................................................ Gambar 4.4 Tampilan Tabel BudgetClass ..................................................................... Gambar 4.5 Tampilan Tabel WorkCenter...................................................................... Gambar 4.6 Tampilan Tabel Department ...................................................................... Gambar 4.7 Tampilan Tabel CostAllocation ................................................................. Gambar 4.8 Tampilan Tabel Product ............................................................................. Gambar 4.9 Tampilan Tabel Model ............................................................................... Gambar 4.10 Tampilan Tabel Costumer ........................................................................ Gambar 4.11 Tampilan Tabel Form............................................................................... Gambar 4.12 Tampilan Tabel Sales ............................................................................... Gambar 4.13 Tampilan Tabel MaterialCostMonthly ..................................................... Gambar 4.14 Tampilan Tabel EmpCLB ........................................................................ Gambar 4.15 Tampilan Tabel MPP ............................................................................... Gambar 4.16 Tampilan Tabel ReportHeader ................................................................. Gambar 4.17 Tampilan Tabel ReportTrans ................................................................... Gambar 4.18 Tampilan Tabel ItemList .......................................................................... Gambar 4.19 Tampilan Tabel Dimension ...................................................................... Gambar 4.20 Tampilan Tabel ReqDeptBudgetMonthly ................................................ Gambar 4.21 Tampilan Tabel Deprecation .................................................................... Gambar 4.22 Tampilan Form Cost Allocation............................................................... Gambar 4.23 Tampilan Form WorkCenter .................................................................... Gambar 4.24 Tampilan Form Update Form................................................................... Gambar 4.25 Tampilan Form Budget Class................................................................... Gambar 4.26 Tampilan Form Asset Category ............................................................... Gambar 4.27 Tampilan Form Account Distribution List ............................................... Gambar 4.28 Tampilan Form Part Report ..................................................................... Gambar 4.29 Tampilan Form Depreciation Mapping .................................................... Gambar 4.30 Tampilan Form Assumption Type ........................................................... Gambar 4.31 Tampilan Form Macro Assumption ......................................................... Gambar 4.32 Tampilan Form Model ............................................................................. Gambar 4.33 Tampilan Form Budget Period ................................................................. Gambar 4.34 Tampilan Form Item List .........................................................................


76 76 77 77 78 78 79 79 80 80 81 81 82 82 84 84 85 85 86 87 87 88 88 89 89 91 92 93 94 95 96 96 97 97 98 99 100 102 103 105 106 108 109 111 112 114 115 116

91. Gambar 4.35 Tampilan Form Mapping Category .......................................................... 92. Gambar 4.36 Tampilan Form Item Verification ............................................................ 93. Gambar 4.37 Tampilan Form Sales ............................................................................... 94. Gambar 4.38 Tampilan Form Man Power Planning ...................................................... 95. Gambar 4.39 Tampilan Form Employee Compensation & Labor Cost......................... 96. Gambar 4.40 Tampilan Form Other Income .................................................................. 97. Gambar 4.41 Tampilan Form Other Expense ................................................................ 98. Gambar 4.42 Tampilan Form Depreciation ................................................................... 99. Gambar 4.43 Tampilan Form Request Item................................................................... 100. Gambar 4.44 Tampilan Form Exception Form .............................................................. 101. Gambar 4.45 Tampilan Form Monthly Budget Request................................................ 102. Gambar 4.46 Tampilan Form Annual Budget Request.................................................. 103. Gambar 4.47 Tampilan Form Master Budget Request .................................................. 104. Gambar 4.48 Tampilan Form Dialog Report ................................................................. 105. Gambar 4.49 Tampilan Form Setting Ratio & Manual Justification ............................. 106. Gambar 4.50 Tampilan Form History Simulation ......................................................... 107. Gambar 4.51 Tampilan Form Compilation for PBT ...................................................... 108. Gambar 4.52 Tampilan Form Proportional to Detail ..................................................... 109. Gambar 4.53 Tampilan Form Generate Budget ID........................................................


117 119 120 121 123 124 126 127 129 130 131 132 134 135 136 137 138 140 141

DAFTAR TABEL

Halaman 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. 42.

Tabel 2.1 Elements Class Diagram ................................................................................ Tabel 2.2 Element Use Case Diagram ........................................................................... Tabel 2.3 Elements Sequence Diagram ......................................................................... Tabel 3.1 Deskripsi Flowchart Diagram Sistem Berjalan .............................................. Tabel 3.2 Skenario Use Case Input Sales ...................................................................... Tabel 3.3 Skenario Use Case Setting Parameter Budget ............................................... Tabel 3.4 Skenario Use Case Send Form Master Budget .............................................. Tabel 3.5 Skenario Use Case Make Budget Request ..................................................... Tabel 3.6 Skenario Use Case Review & Recapitulate Data Budget .............................. Tabel 3.7 Skenario Use Case Make Report ................................................................... Tabel 3.8 Skenario Use Case Budget Simulation .......................................................... Tabel 3.9 Skenario Use Case Create Budget ID ............................................................ Tabel 3.10 Skenario Use Case Usulan Input Sales ........................................................ Tabel 3.11 Skenario Use Case Usulan Setting Parameter Budget ................................. Tabel 3.12 Skenario Use Case Usulan Input Master Budget ......................................... Tabel 3.13 Skenario Use Case Usulan Verifikasi Data Budget ..................................... Tabel 3.14 Skenario Use Case Usulan Generate Laporan ............................................. Tabel 3.15 Skenario Use Case Usulan Setting Ratio dan Simulasi Budget ................... Tabel 3.16 Skenario Use Case Usulan Create Budget ID .............................................. Tabel 3.17 Tabel ActDesc.............................................................................................. Tabel 3.18 Tabel ADLHeader........................................................................................ Tabel 3.19 Tabel ADLTrans .......................................................................................... Tabel 3.20 Tabel BudgetClass ....................................................................................... Tabel 3.21 Tabel WorkCenter........................................................................................ Tabel 3.22 Tabel Department ........................................................................................ Tabel 3.23 Tabel Cost Allocation .................................................................................. Tabel 3.24 Tabel Product ............................................................................................... Tabel 3.25 Tabel Model ................................................................................................. Tabel 3.26 Tabel Costumer ............................................................................................ Tabel 3.27 Tabel Form................................................................................................... Tabel 3.28 Tabel Sales ................................................................................................... Tabel 3.29 Tabel MaterialCostMonthly ......................................................................... Tabel 3.30 Tabel EmpCLB ............................................................................................ Tabel 3.31 Tabel MPP ................................................................................................... Tabel 3.32 Tabel ReportHeader ..................................................................................... Tabel 3.33 Tabel ReportTrans ....................................................................................... Tabel 3.34 Tabel ItemList .............................................................................................. Tabel 3.35 Tabel Dimension .......................................................................................... Tabel 3.36 Tabel ReqDeptBudgetMonthly .................................................................... Tabel 3.37 Tabel Depreciation ....................................................................................... Tabel 4.1 Tabel Skenario Pengujian Login .................................................................... Tabel 4.2 Tabel Skenario Pengujian Maintenance Data Budget Class ..........................


11 14 14 37 38 38 39 39 39 40 40 40 41 42 42 42 43 43 43 56 56 57 57 58 58 58 59 59 59 60 60 62 63 64 65 65 65 66 66 68 143 143

43. 44. 45. 46. 47. 48. 49. 50. 51. 52. 53. 54. 55. 56. 57. 58. 59. 60.

Tabel 4.3 Tabel Skenario Pengujian Proses Request Budget Man Power ..................... Tabel 4.4 Tabel Skenario Pengujian Request Budget Monthly ..................................... Tabel 4.5 Tabel Skenario Pengujian Proses Generate Laporan ..................................... Tabel 4.6 Tabel Skenario Pengujian Verifikasi Data Budget pada Form Master Budget Tabel 4.7 Tabel Skenario Pengujian Proses Simulasi .................................................... Tabel 4.8 Tabel Skenario Pengujian Compilation for PBT ........................................... Tabel 4.9 Tabel Skenario Pengujian Proses Proportional to Detail ............................... Tabel 4.10 Tabel Skenario Pengujian Generate Budget ID ........................................... Tabel 4.11 Tabel Hasil Pengujian Login ....................................................................... Tabel 4.12 Tabel Hasil Pengujian Maintenance Data Budget Class .............................. Tabel 4.13 Tabel Hasil Pengujian Proses Request Budget Man Power ......................... Tabel 4.14 Tabel Hasil Pengujian Request Budget Monthly ......................................... Tabel 4.15 Tabel Hasil Pengujian Proses Generate Laporan ......................................... Tabel 4.16 Tabel Hasil Pengujian Verifikasi Data Budget pada Form Master Budget . Tabel 4.17 Tabel Hasil Pengujian Proses Simulasi........................................................ Tabel 4.18 Tabel Hasil Pengujian Compilation for PBT ............................................... Tabel 4.19 Tabel Hasil Pengujian Proses Proportional to Detail ................................... Tabel 4.20 Tabel Hasil Pengujian Generate Budget ID .................................................


144 144 145 145 145 146 146 146 147 147 148 148 149 149 149 150 150 150

SISTEM INFORMASI PENYUSUNAN MASTER BUDGET DI PT. YUTAKA MANUFACTURING INDONESIA

Recommend Documents