scholarly journals Aplikasi Sistem Akuntansi Rekapitulasi Pendapatan pada Perusahaan Daerah Air Minum (PDAM) Tirtauli Pematangsiantar

JURNAL PETIK ◽  
2020 ◽  
Vol 6 (1) ◽  
pp. 7-17
Author(s):  
Sindi Raharjo Tanjung ◽  
Dedi Suhendro
Keyword(s):  
Visual Basic ◽  
Accounting System ◽  
Microsoft Excel ◽  
Application System ◽  
Water Company ◽  
Database Manipulation ◽  
Owned Company ◽  
Income Accounting ◽  
Regional Water ◽  
Better Than

Abstact — The Tirtauli Pematangsiantar Regional Water Company (PDAM) is classified as a state-owned company that has operational objectives to meet the needs of the community. Revenues at the Tirtauli Regional Water Company (PDAM) are divided into two, namely water revenues and non-water revenues. Regional income recapitulation Tirtauli Pematangsaiantar still uses Microsoft Excel application where the application is still often an error in revenue recapitulation. Based on this, the authors designed a recapitulation income accounting system application program using Microsoft Basic Net and MySQL database to produce applications better than those running. Application of income recapitulation accounting system using Microsoft Visual Basic Net is designed to produce a better application using a MySQL database designed to perform database manipulation processes with various facilities. The purpose of the authors designed the application to facilitate the User in recapitulation of income with the Visual Basic Net application system so that it can help or simplify the process of inputing income recapitulation.Keywords : Application, Revenue Recapitulation, Microsoft Visual Basic Net, MySQL Database.Abstrak — Perusahaan Daerah Air Minum (PDAM) Tirtauli Pematangsiantar digolongkan sebagai perusahaan negara yang memiliki tujuan operasional untuk memenuhi kebutuhan masyarakat. Pendapatan pada Perusahaan Daerah Air Minum (PDAM) Tirtauli terbagi menjadi dua, yaitu penerimaan air dan pendapatan non-air. Rekapitulasi pendapatan perusahaan Daerah Air Minum (PDAM) Tirtauli Pematangsaiantar masih menggunakan aplikasi Microsoft Excel di mana aplikasi masih sering kesalahan dalam rekapitulasi pendapatan. Berdasarkan hal ini, penulis merancang program aplikasi sistem akuntansi pendapatan rekapitulasi dengan menggunakan Microsoft Basic Net dan database MySQL untuk menghasilkan aplikasi lebih baik yang sedang berjalan. Aplikasi sistem akuntansi rekapitulasi  pendapatan menggunakan Microsoft Visual Basic Net dirancang untuk menghasilkan suatu aplikasi yang lebih baik dengan menggunakan database MySQL yang didesain untuk melakukan proses manipulasi database dengan berbagai fasilitas. Tujuan penulis merancang aplikasi untuk mempermudah User dalam melakukan rekapitulasi pendapatan dengan sistem aplikasi Visual Basic Net sehingga dapat membantu atau mempermudah proses penginputan rekapitulasi pendapatan.Kata Kunci : Aplikasi, Rekapitulasi Pendapatan, Microsoft Visual Basic Net, Database MySQL.

Equipment Selection Optimization System of Draglines and it’s Applications in Opencast Coalmine in China

2011 ◽  
Vol 201-203 ◽  
pp. 1253-1257
Author(s):  
Xiao Ren Mei
Keyword(s):  
Visual Basic ◽  
Microsoft Excel ◽  
Equipment Selection ◽  
Optimization System ◽  
Design Cycle ◽  
Comprehensive Comparison ◽  
Background Database ◽  
Visual Basic 6.0 ◽  
Better Than ◽  
Research Institute

Draglines equipment selection optimization involves many factors. Manual simulation has many shortcomings,such as lower calculation accuracy, less programs, long design cycle, so it is hard to make a optimization program. Equipment Selection Optimization System of Draglines (ESOSD) is designed and developed according to the deposit occurrence of opencast coalmines in China. Visual Basic 6.0 is used as programming language, Access 2003 as Background database and the software such as Microsoft Excel 2003 and Autodesk AutoCAD 2004 are integrated in the ESOSD. Three mining schemes of SL opencast coalmine that put forward by SY Design and Research Institute were optimized by using ESOSD. The results show that scheme Ⅱ is better than the other two schemes, which is recommended as the draglines stripping scheme. The main parameters of scheme Ⅱ are as follows: stripping bench height is 45 meters; stripping bench width is 60 meters; throwing blast is adopted; stripping bench is 16 meters lowered by two D10R580HP dozers; dragline model is 1570WS, which boom length is 91.7 meters and bucket capacity is 72.7 cubic meters, and annual overburden amount is 17.2 Million cubic meters. By comprehensive comparison the optimization results with that of SY Design and Research Institute, The total cost reduces 7.512 Million Yuan (RMB) than that of the institute, bucket capacity of dragline reduces 10.7 cubic meters, and boom length reduces 14.3 meters. The optimization results show that ESOSD is reliable and practical, and it can be used as a decision support system for draglines equipment selection optimization.

The Influence of Effectiveness Managerial, Task Commitment and Work Ethic for Employee Performance Regional Water Company (Pdam) Tirta Bhagasasi Bekasi

2018 ◽  
Vol 4 (08) ◽  
Author(s):  
Kusnadi .
Keyword(s):  
Work Ethic ◽  
Employee Performance ◽  
Positive Influence ◽  
Managerial Effectiveness ◽  
Performance Task ◽  
Water Company ◽  
Managerial Task ◽  
Positive Effect ◽  
Regional Water ◽  
Task Commitment

The purpose of this study was to test the effect of managerial effectiveness to employee performance, task commitment to employee performance, work ethic on the performance of employees, managerial effectiveness to task commitment, managerial effectiveness to the work ethic and the work ethic of the commitment of the employee's duties Regional Water Company (PDAM) Tirta Bhagasasi Bekasi. This research was conducted using the method suryey with path analysis in hypothesis testing. In this study, employees were selected as sample there are 96 employees who selected a random sample by strata or stratified random sampling from a total population of 127 respondents. Took this instrument before being used for the data to test the validity and reliability. The results of this study are as follows: There is a direct positive influence on employee performance managerial effectiveness. There is a direct positive influence on employee performance task commitment. There is a direct positive influence on employee performance work ethic. There is a direct positive influence on the effectiveness of managerial task commitment. There is a direct positive effect managerial effectiveness to the work ethic. There is a direct positive effect on the work ethic of commitment to the task.

DEVELOPMENT OF AUTOMATED EVALUATION OF POSITIONING ACCURACY FOR SPECIALIZED NETWORKS’ POINTS IN TRILATERATION NETWORKS

2020 ◽  
Author(s):  
Мурат Газизович Мустафин ◽  
Глеб Андреевич Фролов
Keyword(s):  
Coordinate System ◽  
Visual Basic ◽  
Microsoft Excel ◽  
Positioning Accuracy ◽  
Automated Evaluation ◽  
Visual Basic For Applications ◽  
Multiple Configurations

В данной работе рассмотрен принцип работы созданного алгоритма, позволяющего автоматически определять среднюю квадратическую погрешность планового положения пунктов сетей трилатерации и представлены результаты автоматизации данного процесса при различных конфигурациях сети, с использованием пакетов Microsoft Excel, Visual Basic for Applications. This paper presents automatic solution for evaluating accuracy of positioning for specialized networks’ points in a plane coordinate system. The paper presents results of automation of this process through analysis of multiple configurations of trilateral networks using Microsoft Excel, Visual Basic for Applications.

Design of a Total Revenue Forecasting Tool to Estimate the Economic Output of Hardwood Logs

2020 ◽  
Vol 70 (4) ◽  
pp. 439-447
Author(s):  
Juan J. González ◽  
Henry Quesada ◽  
Sailesh Adhikari ◽  
Brian Bond ◽  
Shawn Grushecky
Keyword(s):  
Probability Distributions ◽  
Visual Basic ◽  
Total Revenue ◽  
Total Income ◽  
Microsoft Excel ◽  
Economic Output ◽  
Revenue Forecasting ◽  
Simple Tool ◽  
Hardwood Lumber ◽  
Volume Output

Abstract This article introduces a total revenue forecasting tool designed for calculating the economic output of visually graded hardwood lumber. The tool integrates Monte Carlo simulation from previous studies' data, providing a pseudoestimation of total board-feet based on log grades. The lumber output from different log groups is modeled using probability distributions for each lumber grade. The estimated volume output is multiplied by the respective price for each grade, leading to an expected amount of economic output for given log-grades. The tool was implemented using Microsoft Excel 2016 and Visual Basic. This work provides hardwood lumber producers with a valuable and simple tool to determine different scenarios of total income from each log, as established by the user with a statistical perspective. This total revenue forecasting tool provides the industry with a way to reduce waste and estimate their potential revenue by maximizing the interaction between the log yield's variables and providing the economic output of log, leading to an improvement of the economy of the hardwood market.

FEATURES OF ACCOUNTING IN THE ORGANIZATIONS OF THE HOTEL SPHERE

2021 ◽  
Vol 4 (4) ◽  
pp. 111-115
Author(s):  
BATTIKH RONY ◽  
Keyword(s):  
Accounting System ◽  
Income Accounting ◽  
Management Reporting

The article reveals the essence of the organization of the income accounting system in the organizations of the sphere of hotel services. The author identifies the main forms of management reporting by responsibility centers. The article reveals the main expenses of hotel organizations.

scholarly journals PENGARUH KOMPENSASI FINANSIAL, LINGKUNGAN KERJA DAN MOTIVASI KERJA TERHADAP KINERJA PEGAWAI PADA KANTOR PDAM KOTA PAYAKUMBUH

2019 ◽  
Author(s):  
Heru Marta Saputra ◽  
Riri mayliza
Keyword(s):  
Work Environment ◽  
Work Motivation ◽  
Employee Performance ◽  
Descriptive Analysis ◽  
Sampling Technique ◽  
Positive Influence ◽  
Financial Compensation ◽  
Water Company ◽  
Analysis Technique ◽  
Regional Water

Effect of Financial Compensation, Work Environment and Work Motivation on Employee Performance in the Regional Water Company (PDAM) Payakumbuh. The principal issues in this study is whether the process of financial compensation, work environment, work motivation influence on the performance of employees at the Regional Water Company (PDAM) Payakumbuh. This study aims to reveal the Financial Compensation Effect, Work Environment and Work Motivation on Employee Performance in the Regional Water Company (PDAM) Payakumbuh. This research is descriptive associative. The population in this study is the employee at the Regional Water Company (PDAM) Payakumbuh totaling 67 people. The sampling technique sampling study is saturated. The questionnaire was used as data collection techniques. Data analysis technique used is descriptive analysis and multiple regression analysis, multicollinearity analysis, analysis heterokedastisistas, normality test and coefficient detereminasi. To test the hypothesis used t test, Test F. Based on the analysis of the influence of financial compensation, work environment and work motivation and employee performance, especially in the Regional Water Company (PDAM) Payakumbuh, it would seem that there is a positive influence and significant correlation between financial compensation, work environment, work motivation on employee performance. Thus the hypothesis is proved.

scholarly journals Pembelajaran diskursus multi representasi terhadap peningkatan kemampuan komunikasi dan disposisi matematis mahasiswa

2018 ◽  
Vol 5 (1) ◽  
pp. 43 ◽  
Author(s):  
Ratni Purwasih ◽  
Martin Bernad
Keyword(s):  
Mathematics Learning ◽  
Control Group ◽  
Microsoft Excel ◽  
Control Group Design ◽  
Ability Test ◽  
First Semester ◽  
Quasi Experimental ◽  
Communication Ability ◽  
Mean Differences ◽  
Better Than

Penelitian ini bertujuan untuk mengetahui peningkatan kemampuan komunikasi dan disposisi mahasiswa melalui pembelajaran diskursus multi representasi (DMR). Metode penelitian ini adalah metode kuasi eksperimen dengan desain penelitian pretset-posttest control group design. Populasi penelitian adalah seluruh mahasiswa pendidikan matematika STKIP Siliwangi Bandung yang mengikuti mata kuliah metode pembelajaran matematika sekolah SD pada semester ganjil Tahun Ajaran 2016/2017 yang terdiri dari 3 kelas, yaitu: A1, A2 dan A3. Sampel penelitian dipilih 2 kelas dari populasi penelitian, terpilih kelas A2 sebagai kelas kontrol yang terdiri dari 35 orang mahasiswa dan kelas A1 sebagai kelas eksperimen yang terdiri dari 36 orang mahasiswa. Analisis data dilakukan terhadap gain hasil tes kemampuan mahasiswa mata kuliah metode pembelajaran matematika sekolah SD. Sedangkan analisis skala disposisi matematis mahasiswa menggunakan Microsoft Excel 2010. Untuk memperoleh data penelitian digunakan instrumen berupa tes uraian dan skala disposisi. Analisis penelitian menggunakan uji perbedaan rata-rata mann whitney. Hasil penelitian menunjukkan bahwa: (1) Pencapaian dan peningkatan kemampuan komunikasi matematis yang mendapat pembelajaran DMR lebih baik daripada mahasiswa yang mendapat pembelajaran konvensional; dan (2) Disposisi matematis mahasiswa yang pembelajarannya menggunakan DMR lebih baik daripada mahasiswa dengan pembelajaran yang menggunakan pendekatan konvensional. Learning multi discourse representation to enhance students communication and their mathematical disposition AbstractThis study aims to determine the improvement of students’ mathematical communication and dispositions ability through multi-representation discourse (DMR) learning. This research method is quasi-experimental with the design of pretset-posttest control group. The population is all students of mathematics education STKIP Siliwangi Bandung attending the course subject of  Metode Pembelajaran Matematika SD (Elementary Mathematics Learning Method) in the first semester of 2016/2017 academic year consisting of three classes, namely: A1, A2 and A3. The samples are selected from two classes; A2 as the control group consisting of 35 students and A1 as the experimental group consisting of 36 students.. Data analysis is performed to find out the gain from the results of students’ ability test in the subject of Metode Pembelajaran Matematika  SD; while the students’ mathematical disposition scale analysis is conducted by using Microsoft Excel 2010. To obtain research data, the instruments of  description test and disposition scale are used. The analysis of research uses the Mann Whitney’s mean differences test. The results show that: (1) the achievement and improvement of communication ability of the students’ receiving DMR learning are better than those who receive conventional learning; and (2) Mathematical disposition of students with DMR learning is better than those with the conventional approach.

scholarly journals OPTIMALISASI JUMLAH KENDARAAN DAN RUTE DISTRIBUSI LOGISTIK PEMILIHAN DI KABUPATEN KEDIRI PADA MASA PANDEMI

2021 ◽  
Vol 3 (1) ◽  
pp. 1-25
Author(s):  
Eka Wisnu Wardhana ◽  
Oki Anita Candra Dewi
Keyword(s):  
Vehicle Routing ◽  
Vehicle Routing Problem ◽  
Nearest Neighbor ◽  
Visual Basic ◽  
Microsoft Excel ◽  
Google Maps ◽  
Routing Problem ◽  
Visual Basic Application

Artikel ini membahas tentang permasalahan distribusi logistik pemilihan kepala daerah (Pemilihan) yang berkaitan dengan penentuan jumlah kendaraan yang tepat dan pemilihan rute terdekat dengan mempertimbangkan jarak yang dapat dilalui oleh kendaraan roda 4 atau lebih. Penentuan jumlah kendaraan dan rute yang tepat ini sangat penting bagi Komisi Pemilihan Umum (KPU) karena aspek logistik dan distribusi sangat berpengaruh dalam memastikan suara masyarakat tersampaikan dengan baik. Selain itu aspek ini memiliki keterkaitan satu dengan lainnya baik bersifat strategis maupun teknis. Selama pandemi, distribusi logistik Pemilihan tidak hanya berkaitan dengan kebutuhan alat pemungutan suara namun juga alat pelindung diri (APD) selama pelaksanaan pemungutan. Oleh karena itu kegiatan logistik menjadi lebih banyak dengan tetap mempertimbangkan protokol kesehatan sehingga diperlukan sebuah aplikasi yang dapat menentukan jumlah kendaraan dan rute yang tepat sebagai dasar untuk mempercepat pengambilan keputusan. Penelitian ini fokus pada penentuan jumlah kendaraan dan rute distribusi logistik yang optimal pada Pemilihan tahun 2020 di masa pandemic COVID-19 di KPU Kabupaten Kediri menggunakan pendekatan vehicle routing problem dengan memperhatikan jarak dari google maps serta menggunakan algoritma nearest neighbor dalam menentukan jarak terdekat antar titik. Aplikasi yang dikembangkan adalah penentuan rute menggunakan Visual Basic Application (VBA) pada Microsoft Excel. Penelitian ini menghasilkan jumlah kendaraan sebanyak 12 kendaraan untuk pengiriman logistik Pemilihan maupun APD dengan batas maksimal total perjalanan setiap truk sepanjang 100 km. Selain itu terdapat 6 kecamatan yang dikunjungi dua kali karena total kebutuhan melebihi kapasitas kendaraan.

scholarly journals Constructing Student’s Mathematical Understanding Skills and Self Confidence: Math Game with Visual Basic Application for Microsoft Excel in Learning Phytagoras at Junior High School

2018 ◽  
Vol 7 (3.2) ◽  
pp. 732 ◽  
Author(s):  
Martin Bernard ◽  
Eva Dwi Minarti ◽  
Masta Hutajulu
Keyword(s):  
High School ◽  
High School Students ◽  
Junior High School ◽  
Junior High ◽  
Visual Basic ◽  
Process Data ◽  
School Students ◽  
Microsoft Excel ◽  
Mathematical Concepts ◽  
Visual Basic Application

Learning media in Mathematics by using Microsoft Excel software that assisted Visual Basic application is a tool that can be applied for a more interactive visualization so that students better understand about mathematical concepts. Microsoft Excel is a software that serves to process data in the form of numbers that are always associated with mathematical commands. In addition, the functions of commands in Microsoft Excel can be applied in various fields such as Statistics, Economics and Finance, Mathematical Logic, and Engineering. If using mathematical concepts with data processing. But it is not just a number, it can also be used to process objects on shapes or drawings on images. This, of course, requires a function other than the mathematical functions of Visual Basic Applications, which can make math tools more interesting. The advantages of Microsoft Excel with Visual Basic for Application (VBA) are (1) the images are more interactive with different sizes and can make more; (2) more economical; (3)saving time; (4)the software is easy to find, and (5)improving students 'understanding of mathematical concepts and foster students' sense of trust, especially in junior high school students.  

Sign in / Sign up

Export Citation Format

Share Document