scholarly journals Implementasi Pembelian Kredit Bahan Baku Material Menggunakan Aplikasi MYOB Accounting V18 Pada PT Mitra Metal Sejati

2021 ◽  
Vol 6 (1) ◽  
pp. 1-15
Author(s):  
Arif Maulana Yusuf ◽  
Yeny Rostiani ◽  
Rahmat Gunawan ◽  
Renanda Claudia
Keyword(s):  
Microsoft Excel ◽  
Purchase Order

PT Mitra Metal Sejati merupakan salah satu perusahaan yang bergerak dalam bidang jasa mekanikal dan machining fabrikasi. Dalam melakukan kegiatan usahanya perusahaan membutuhkan pembelian bahan baku material untuk dapat menjalankan kegiatannya. Pencatatan pembelian kredit merupakan bagian penting dalam suatu perusahaan karena nantinya pencatatan tersebut berkaitan dengan hutang yang merupakan kewajiban sebuah perusahaan. Tujuan penelitian ini menyajikan informasi pembelian dan hutang secara terkomputerisasi yang cepat dan akurat. Metodologi penelitian yang penulis gunakan terdapat beberapa tahapan diawali dengan perencanaan, pengumpulan data, pengolahan data, dan migrasi data ke aplikasi MYOB Accounting Plus V18. Pencatatan pembelian bahan baku material pada PT Mitra Metal Sejati masih menggunakan Microsoft Excel dan belum terkomputerisasi sehingga sering terjadi kesalahan. Kesalahan atau permasalahan yang terjadi pada PT Mitra Metal Sejati seperti: penginputan hutang usaha dan membuat Purchase Order (PO) serta laporan pembelian kredit baik nama supplier, nomor invoice masuk dan nominal masih menggunakan Microsoft Excel sehingga kadang terjadinya kesalahan penginputan data. Adapun dari permasalahan-permasalahan tersebut dan dengan semakin berkembangnya perusahaan membutuhkan Sistem Informasi yang baik untuk menunjang kegiatan-kegiatan usahanya khususnya dalam pembelian kredit yang nantinya berhubungan dengan utang perusahaan. Mengimplementasikan suatu penyajian laporan pembelian kredit dan utang pada PT Mitra Metal Sejati menggunakan aplikasi akuntansi MYOB Accounting Plus V18. Sehingga dapat mempermudah, mempercepat, dalam pencatatan pembelian kredit serta menyajikan laporan pembelian dan utang, dan laporan tersebut dapat digunakan sebagai pengambilan keputusan oleh manajemen.

scholarly journals Sistem Informasi Penawaran Harga Dan Penjualan Pada CV. Inspirasi Software

2019 ◽  
Vol 7 (2) ◽  
pp. 153-166
Author(s):  
Uus Rusmawan ◽  
Petrus Dwi Ananto Pamungkas
Keyword(s):  
Survey Methods ◽  
Application Development ◽  
Microsoft Excel ◽  
Purchase Order ◽  
Document Delivery ◽  
Consulting Services ◽  
Microsoft Word ◽  
Income Statement ◽  
A Company ◽  
Price Offer

Abstract   Software Inspiration is a company that operates in the sale of IT goods, application manufacturing services and IT consulting services. The business transaction begins with a request for a price quote from the client, the issuance of PO, the delivery of goods accompanied by a travel document, delivery of invoices, and finally the payment process. In addition, there is also a recording of expenses and the existence of a company's income statement. The recording of the transaction is done using MS. Word and Excel, which still require an increase in system performance, are therefore subject to research using survey methods, interviews, and literature studies. The application development model is done by the waterfall method. After the system is built in the form of an application, the process of recording transactions can be done more easily and quickly, the presentation of transaction reports and income statements can be obtained quickly and accurately.     Keywords: Excel, Invoice, Price Offer, Sales, Purchase Order, Information Technology, Waterfall   Abstrak   CV Inspirasi Software adalah sebuah perusahaan yang bergerak di bidang penjualan barang-barang bidang Teknologi Informasi, jasa pembuatan aplikasi dan jasa konsultan Teknologi Informasi. Transaksi bisnisnya diawali dengan permintaan penawaran harga dari client, penerbitan PO, pengirimam barang disertai surat jalan, pengiriman invoice, dan terakhir adalah proses pembayaran. Selain itu terjadi juga pencatatan pengeluaran biaya dan adanya laporan laba rugi perusahaan. Pencatatan transaksi tersebut dilakukan dengan menggunakan Microsoft Word dan Microsoft Excel yang masih memerlukan peningkatan kinerja sistem, untuk itu dilakukan penelitian dengan metode survey, wawancara, dan studi pustaka. Model pengembangan aplikasi dilakukan dengan metode waterfall. Setelah dibangun sistem berupa aplikasi maka proses pencatatan transaksi dapat dilakukan dengan lebih mudah dan cepat, penyajian laporan transaksi dan laporan laba rugi dapat diperoleh dengan cepat dan akurat.   Kata kunci: Excel, Invoice, Panawaran Harga, Penjualan, Purchase Order, Teknologi Informasi, Waterfall

scholarly journals RANCANG BANGUN APLIKASI PURCHASE ORDER PADA UNIT PURCHASING PT. XYZ

Jurnal PASTI ◽  
2020 ◽  
Vol 13 (3) ◽  
pp. 223
Author(s):  
Dina Tauhida
Keyword(s):  
Spare Part ◽  
Microsoft Excel ◽  
Purchase Order ◽  
Microsoft Access

PT. XYZ memiliki unit purchasing yang bertugas untuk melakukan pembelian spare part. Pada proses pembelian spare part ke pemasok, terdapat Purchase Order (PO) yang digunakan sebagai alat atau bukti pemesanan. Admin purchasing merupakan karyawan PT. XYZ yang bertugas membuat PO tersebut. Dalam pelaksanaan tugasnya, admin purchasing melakukan kesalahan pencatatan PO yang dapat membuat kekurangan atau kelebihan stok spare part. Hal tersebut akan menimbulkan kerugian pada perusahaan apabila lolos pengecekan oleh atasan. Selain adanya kesalahan pencatatan, pembuatan PO masih menggunakan bantuan Microsoft excel dimana data – data terkait belum terintegrasi dan harus membuka beberapa file. Adanya kesalahan pencatatan PO serta data yang belum terintegrasi akan menurunkan kinerja unit purchasing sehingga perlu membuat aplikasi pembuatan PO yang dapat memudahkan pengguna dan mempercepat pekerjaan. Perancangan aplikasi pembuatan PO menggunakan bantuan aplikasi Microsoft Access yang digunakan sebagai database juga. Aplikasi pembuatan PO diharapkan dapat meminimalisir kesalahan admin dan meningkatkan kinerja admin karena pembuatan PO yang lebih cepat dan akurat.

scholarly journals Sistem Informasi Pembelian Bahan Baku Sockliner pada PT Sinar Utama Jaya Abadi

2021 ◽  
Vol 10 (2) ◽  
pp. 61-68
Author(s):  
Evita Sulis Tyanur ◽  
Rachmat Hidayat ◽  
Yusnia Budiarti
Keyword(s):  
Input Data ◽  
Visual Basic ◽  
Microsoft Excel ◽  
Purchase Order ◽  
Related Product

Intisari— Proses pembelian bahan baku memiliki peranan penting dalam proses produksi. Karena pembelian bahan baku merupakan sebuah awal kegiatan perusahaan dalam menghasilkan pendapatan. Tidak mungkin dalam suatu perusahaan dapat menyediakan sendiri kebutuhan untuk menjalankan roda perusahaan. Permasalahan yang ada pada saat ini proses pembelian bahan baku prosesnya masih dilakukan secara konvensional, Purchase Order (PO) di buat dengan menggunakan Microsoft Excel lalu dicetak dan dikirim kepada supplier via email/fax, hal ini sering terjadi kesalahan pada proses input data dan penyimpanan data belum terintegrasi oleh sistem sehingga kesulitan pada saat pencarian data selain itu dalam pembuatan laporan penerimaan barang, laporan permintaan barang dan laporan pembelian memerlukan waktu yang cukup lama untuk mengolah dan menggabungkan banyak data dalam Microsoft Excel. Tujuan dari penelitian ini adalah agar mempermudah, mempercepat dan mengurangi kesalahan dalam sistem pembelian bahan baku sockliner pada PT Sinar Utama Jaya Abadi untuk membantu mengolah data pembelian serta laporan perusahaan dengan mudah, cepat dan akurat. Metode yang digunakan dalam penelitian ini adalah model SDLC air terjun (waterfall) dan dalam pembuatan sistem ini, menggunakan Visual Studio dan MySQL. Hasil dari sistem yang telah dibuat adalah berupa sistem informasi pembelian bahan baku sockliner yang dapat mengelola informasi data. Kata Kunci— Sistem Informasi, Permintaan Barang, Pembelian Barang, Penerimaan Barang, Waterfall Referensi : [1]   A. A. Andryadi, “Perancangan Sistem Informasi Purchase Orderinternal Non Related Product Berbasis Web (Studi Kasus PT Shafco Multi Trading) MEDIA Inform., vol. 16, no. 1, pp. 57–69, 2017. [2]   A. Sauki, Warsino, and Y. M. Ardi, “Perancangan Sistem Informasi Pembelian Bahan Baku Pada Pt Nani Wahyuni Industries Bekasi,” J. Ilm. SANTIKA, vol. 9, no. 1, pp. 865–872, 2019. [3]   V. M. M. Siregar, “Sistem Informasi Pembelian dan Penjualan Pakaian pada Galoenk Distro Pematang Siantar,” J. Chem. Inf. Model., vol. 53, no. 49, pp. 13–26, 2017. [4]   D. Uswara and H. Patrie, “Perancangan sistem informasi pembelian dan penjualan toko elisa rizki dengan metodologi berorientasi obyek,” IDEALIS, vol. 2, pp. 297–301, 2019. 5]     A. Kristanto, Perancangan Sistem Informasi Dan Aplikasinya. Klaten: Gava Media, 2018. [6]   J. Enterprise, Otodidak Visual Basic. PT Elex Media Komputindo, 2017. [7]   Hardiyanto, Abdussomad, E. Haryadi, R. Sopandi, and Asep, “Penerapan Model Waterfall dan UML Dalam Rancang Bangun Program Pembelian Barang Berorientasi Objek pada PT Fujita Indonesia,” INTERKOM, vol. 13, pp. 1–12, 2019. [8]   Raharjo, Belajar Otodidak MySQL. Informatika Bandung, 2018. [9]   R. A. Sukamto and M. Shalahuddin, Rekayasa Perangkat Lunak Terstruktur dan Berorientasi Objek. Bandung: Informatika Bandung, 2018. [10] E. R. Yunita and N. Safitri, “Sistem Informasi Pengadaan Bahan Baku Berbasis Desktop Pada PT Inti Technik Sejahtera Bekasi,” Inf. Syst. Educ. Prof., vol. 4 No.1, no. 1, pp. 85–94, 2019. [11] Munawar, Analisa Perancangan Sistem Berorientasi Objek Dengan UML. Informatika Bandung, 2018.  

Current Issues: Advanced Digital Technology for Supervising Graduate Clinicians

2010 ◽  
Vol 20 (1) ◽  
pp. 9-13 ◽  
Author(s):  
Glenn Tellis ◽  
Lori Cimino ◽  
Jennifer Alberti
Keyword(s):  
Real Time ◽  
Digital Technology ◽  
Clinical Training ◽  
State Of The Art ◽  
Clinical Skills ◽  
Slow Motion ◽  
Video Capture ◽  
Microsoft Excel ◽  
Clinical Supervisors ◽  
Training And Supervision

Abstract The purpose of this article is to provide clinical supervisors with information pertaining to state-of-the-art clinic observation technology. We use a novel video-capture technology, the Landro Play Analyzer, to supervise clinical sessions as well as to train students to improve their clinical skills. We can observe four clinical sessions simultaneously from a central observation center. In addition, speech samples can be analyzed in real-time; saved on a CD, DVD, or flash/jump drive; viewed in slow motion; paused; and analyzed with Microsoft Excel. Procedures for applying the technology for clinical training and supervision will be discussed.

Prescribing trends of antidiabetic drugs in diabetic and hypertensive diabetic patients in an urban tertiary care hospital of Bangladesh

2017 ◽  
Vol 3 (3) ◽  
pp. 338-343
Author(s):  
Mohammad Didar Khan ◽  
Md. Ibrahim ◽  
Md. Mizanur Rahman Moghal ◽  
Dipti debnath ◽  
Asma Kabir ◽  
...  
Keyword(s):  
Urban Areas ◽  
Tertiary Care ◽  
Diabetic Patients ◽  
Care Hospital ◽  
Age Group ◽  
Microsoft Excel ◽  
Patient Profile ◽  
Prescribing Trends ◽  
Medical University ◽  
Insight Into

Objective: The present epidemiological study was conducted with the objectives of providing an insight into the current use of antidiabetic medications to diabetics and hypertensive diabetics in urban areas and determining how the patient factors influence the prescribing of antidiabetic medications. Methodology: Data of patients of past two years were collected from Bangabandhu Sheikh Mujib Medical University (BSMMU) Hospital, Dhaka, Bangladesh. The details were entered in the structured patient profile form. Data were statistically analyzed using the Microsoft Excel 2007 software. Result: A total of 958 patient’s data were collected and analyzed of which 632 (65.97 %) were males and 326 (34.03 %) were females. These patients were further categorized based on their age. 330 patients (34.45 %) belonged to the age group 20 – 44 years, 504 (52.61 %) to the age group 45 – 65 years and 124 (12.94 %) to the age group 65 – 80 years. 684 (71.4%) patients out of the 958 patients studied were suffering from coexisting hypertension. Co-existing hypertension was found to be more prevalent in the age group 45 – 65 years (67.69%) and was found more in females (84.04%). Conclusion: Metformin was the oral hypoglycemic which was the highest prescribed. In hypertensive diabetics Metformin and Pioglitazone were most frequently prescribed drugs. Biguanides and Insulin were the most commonly prescribed antidiabetics. A combination of two or more drugs of different classes was prescribed to hypertensive diabetics. It is necessary to have an improved understanding of the etiology and pathophysiology of diabetes to focus on research efforts appropriately.

Perancangan Pengkondisian Udara pada Ruangan Steril Rumah Sakit Mitra Medika dengan Standard Cleanroom Menggunakan Instalasi Ducting

2019 ◽  
Vol 2 (2) ◽  
Author(s):  
Fremmy Raymond Agustinus
Keyword(s):  
Air Conditioning ◽  
Static Pressure ◽  
Filter Medium ◽  
Positive Pressure ◽  
Design Tools ◽  
Microsoft Excel ◽  
Cooling Unit ◽  
X 24 ◽  
Air Passage ◽  
Booster Fan

Desain penyejuk udara juga dapat diterapkan di bidang kesehatan, dengan standar Cleanroom dapat diperoleh suhu, kelembaban, kenyamanan dan kebersihan yang dibutuhkan untuk ruang steril (ruang bedah). Perancangan pendingin udara dalam hal ini dilakukan dengan menentukan beban pendinginan yang diperlukan untuk ruang steril (ruang bedah), kemudian menentukan ukuran ducting, jalur ducting, dan jumlah penggunaan ducting. Desain ini menggabungkan unit split saluran yang dimodifikasi, kipas booster, filter pra, filter medium, dan filter HEPA dengan menggunakan saluran aluminium preinsulated sebagai saluran udara. Desain dilakukan dengan menggunakan perangkat lunak AutoCAD 2012, Design Tools Duct Sizer, dan Microsoft Excel. Dari hasil perhitungan dan desain didapatkan kebutuhan kapasitas 3 ruang bedah yaitu ducted ducted 100.000 BTUH sebanyak 3 unit, booster fan 3.3 - 4 Di WG sebanyak 3 unit, pre filter 24 "x 24" x 2 "6 set, filter menengah 610 x 610 x 290 mm 6 set, dan filter HEPA 1220 x 610 x 70 mm 12. Untuk ruang steril, tekanan statis yang dihasilkan oleh unit pendingin harus lebih besar daripada tekanan statis yang dihasilkan dari unit yang ada. di ruang semi steril. Dengan kata lain, ruang steril harus memiliki tekanan positif terhadap ruang semi steril. Hal ini dimaksudkan agar udara di ruang semi steril tidak masuk ke ruang steril ketika pintu antar ruangan dibuka. Desain dan perhitungan ruang bedah, suhu nyata yang diperoleh adalah 23 ° C ± 2 ° C dan kelembaban relatif yang diperoleh adalah 60% ± 2%.   Air conditioning design can also be applied in the health field, with cleanroom standard can be obtained temperature, humidity, comfort and hygiene needed for sterile room (surgical room). The design of air conditioning in this case is done by determining the cooling load required for the sterile room (surgical room), then determining the ducting size, ducting path, and the amount of ducting usage. This design combines modified ducted split unit, booster fan, pre filter, medium filter, and HEPA filter by using preinsulated aluminum duct as an air passage. The design is done by using AutoCAD 2012 software, Design Tools Duct Sizer, and Microsoft Excel. From the calculation and design result obtained the capacity requirement of 3 surgical room that is split ducted 100.000 BTUH as many as 3 units, booster fan 3.3 - 4 In WG as many as 3 units, pre filter 24"x 24" x 2" 6 sets, medium filter 610 x 610 x 290 mm 6 sets, and HEPA filter 1220 x 610 x 70 mm 12 sets. For the sterile room, the static pressure generated by the cooling unit shall be larger than the static pressure generated from the unit present in the semi sterile room. In other words, the sterile room must have positive pressure to the semi sterile room. It is intended that the air in the semi sterile room does not enter into the sterile room when the door between room opened. In this surgical room design and calculation, real temperature obtained is 23 °C ± 2 °C and the relative moisture obtained is 60% ± 2%.

Telaahan Penerapan Sistem Informasi Akuntansi Berbasis Komputer Akuntansi (Menggunakan Microsoft Excel) dalam Penyajian Laporan Keuangan (Studi Kasus pada Rumah Sakit Islam Bogor)

2010 ◽  
Vol 6 (02) ◽  
pp. 49
Author(s):  
Syarief Gerald Prasetya
Keyword(s):  
Information System ◽  
Balance Sheet ◽  
Accounting Information ◽  
Financial Statement ◽  
Microsoft Excel ◽  
Financial Reports ◽  
Accounting Information System ◽  
Achievement Data ◽  
Medical Needs ◽  
Processing Data

Hospital was established to serve the medical needs of the citizen. In addition to serving, hospitals also need to explore the benefits for the sustainability and the development of the hospital. To achieve financial reports have involved a large role. Accounting information system computer-based accounting will help serving the financial reports, so that more accurate and faster. Errors can be diminished.  Research object is selected by the author to conduct research is Bogor Rumah Sakit Islam. A hospital that is located on Jl. Perdana Raya. 22 Budi Agung, Jakarta Utara. This hospital was established on May 12, 1991. The location is strategic as it is in the center of Bogor. In doing activity, accounting information system based on computerized accounting still not yet common use. Computer already exist but support application to create an accurate and fast financial statement does not exist. So much weaknesses if we still using manual method. Like slowly processing data, still using much worker and much step while processing. The information result is still contained high mistake. To solve all problems above we need accounting software as tool for accounting division. For that I try to apply computerized accounting using Microsoft Excel for helping creating financial statement. By doing observation and interview with related employee, this research can do well. Journalize transaction process by using Microsoft Excel is to make a column for each transaction such as Journal Voucher, General Ledger, Balance Sheet. After making a column, the next step is inputing achievement data to Journal Voucher. After inputing data, General Ledger and Balance Sheet can automatically fill up. By using computer, processing data is more faster, information result is more accurately, human resource is less needed. Related management can get information they need more faster, because amount recalculated every doing transaction.

MODULE OF ICT-BASED LEARNING MATHEMATICS: RESPONSE OF STUDENTS IN THE LEARNING PROCESS

2020 ◽  
Vol 4 (3) ◽  
Author(s):  
Endang Istikomah
Keyword(s):  
Mathematics Learning ◽  
Student Response ◽  
Questionnaire Data ◽  
Research Subjects ◽  
Microsoft Excel ◽  
Learning Modules ◽  
Descriptive Research ◽  
Learning Module ◽  
Learning Mathematics ◽  
Learning Guide

The use of modules in learning aims so that students can learn independently without or with the guidance of the lecturer. There is no teaching material as a learning guide that meets the needs of students in IT-based mathematics learning courses in the form of LKM, Modules or textbooks.This study aims at finding and examining further the response of students to ICT-based mathematics learning modules. The form of this research is descriptive research. The research subjects of the even semester students are 2018/2019 in ICT-based mathematics learning courses. The instrument used was a student response questionnaire. Data collection techniques using a Likert scale through Google Form. The data was processed using Microsoft Excel 2010. The results showed that student’s responses to the ICT-based mathematics learning module as a whole were positive with an average on the material Aspects, the Interest Aspects of the module and the Module Aspects respectively of 92, 42%, 87 % and 93, 16%.. Thus it can be concluded that ICT-based mathematics learning using modules can be applied.

Sign in / Sign up

Export Citation Format

Share Document