scholarly journals Pemanfaatan Microsoft Excel untuk Aplikasi Data Pelanggan pada Pada Usaha Jasa Pembersihan Dan Perawatan Sepatu, Tas, Dan Topi

2021 ◽  
Vol 5 (4) ◽  
Author(s):  
Fajar Astuti Hermawati ◽  
Aidil Primasetya Armin
Keyword(s):  
Business Owners ◽  
Microsoft Excel ◽  
Customer Data ◽  
Total Cost ◽  
Excel Spreadsheet ◽  
Service Data ◽  
Spreadsheet Application

Abstract Scar Wash is a micro-business engaged in the care and cleaning of bags, hats and shoes located in the Karang Menjangan area of ​​Surabaya. In the process, partners face problems in the process of storing customer data is still done in the manual form. So it isn't easy in knowing information about customers and what transactions have been made by satisfied customers to improve service. Since of these reasons, we offer to create desktop applications by utilizing a Microsoft Excel spreadsheet application that is quite familiar to business owners. The system consists of three main menus, namely the customer data, the service data and the transaction menu. The customer data menu is for storing customer data. The service data menu is for managing service data provided by partners and the rates of each service provided. The transaction menu is used to record every transaction of a customer that includes services and the total cost that the customer must pay. This application has the advantage of being easy to install. After all, it does not require software other than Microsoft Excel, small and fast because it runs directly on the Excel application itself and is easy to use because it has a combo-box facility for selecting customer data and service data.   Keywords: Customer application, Microsoft Excel, Services, Micro-business   Abstrak Scar Wash adalah sebuah usaha mikro yang bergerak di bidang perawatan dan pembersihan tas, topi dan sepatu yang berlokasi di daerah Karang Menjangan kota Surabaya. Pada prosesnya, mitra menghadapi permasalahan pada proses penyimpanan data pelanggan masih dilakukan dalam bentuk manual yaitu ditulis pada buku. Sehingga menyulitkan di dalam mengetahui informasi tentang pelanggan serta transaksi apa saja yang pernah dilakukan oleh pelanggan tertentu guna meningkatkan pelayanan. Atas dasar hal ini, maka ditawarkan untuk membuat aplikasi desktop dengan memanfaatkan aplikasi spreadsheet Microsoft Excel yang cukup familiar bagi pemilik usaha. Sistem yang dibangun terdiri dari tiga menu utama yaitu menu data pelanggan untuk menyimpan data pelanggan, menu data layanan untuk mengelola data layanan yang disediakan oleh mitra serta tarif dari setiap jasa yang diberikan serta menu transaksi yang digunakan untuk mencatat setiap transaksi seorang pelanggan yang meliputi jasa atau layanan dan total biaya yang harus dibayarkan oleh pelanggan tersebut. Aplikasi ini mempunyai kelebihan mudah untuk dipasang karena tidak memerlukan perangkat lunak selain Microsoft Excel, kecil dan cepat karena langsung berjalan pada aplikasi Excel sendiri serta mudah digunakan karena dilengkapi fasilitas combo-box untuk memilih data pelanggan dan data layanan.   Kata kunci: Aplikasi Pelanggan, Microsoft Excel, Jasa, Usaha Kecil

Penerapan Metode Klasifikasi Decision Tree dan Algoritma C4.5 dalam Memprediksi Kriteria Nasabah Kredit Mega Auto Finance

2020 ◽  
Vol 7 (2) ◽  
pp. 200
Author(s):  
Puji Santoso ◽  
Rudy Setiawan
Keyword(s):  
Data Mining ◽  
Decision Tree ◽  
Microsoft Excel ◽  
Customer Data ◽  
Data Mining Techniques ◽  
C4.5 Algorithm ◽  
Marketing Costs ◽  
Excel Format ◽  
Data Mining Application

One of the tasks in the field of marketing finance is to analyze customer data to find out which customers have the potential to do credit again. The method used to analyze customer data is by classifying all customers who have completed their credit installments into marketing targets, so this method causes high operational marketing costs. Therefore this research was conducted to help solve the above problems by designing a data mining application that serves to predict the criteria of credit customers with the potential to lend (credit) to Mega Auto Finance. The Mega Auto finance Fund Section located in Kotim Regency is a place chosen by researchers as a case study, assuming the Mega Auto finance Fund Section has experienced the same problems as described above. Data mining techniques that are applied to the application built is a classification while the classification method used is the Decision Tree (decision tree). While the algorithm used as a decision tree forming algorithm is the C4.5 Algorithm. The data processed in this study is the installment data of Mega Auto finance loan customers in July 2018 in Microsoft Excel format. The results of this study are an application that can facilitate the Mega Auto finance Funds Section in obtaining credit marketing targets in the future

Sistem Informasi Pengendalian Persediaan Barang Menggunakan Metode Economic Order Quantity (EOQ)

IJAcc ◽  
2020 ◽  
Vol 1 (2) ◽  
pp. 132-139
Author(s):  
Erna Astriyani ◽  
Desy Apriani ◽  
Meri Mayang Sari
Keyword(s):  
Control System ◽  
System Design ◽  
Inventory Control ◽  
Economic Order Quantity ◽  
Economic Order ◽  
Control System Design ◽  
Order Quantity ◽  
Microsoft Excel ◽  
Total Cost ◽  
Control Information

The system that is currently running in recording inventory at PT Berlina Tbk Tangerang is considered ineffective and efficient because it still uses paper and the process of inputting and recapping goods data is semi-computerized in Microsoft Excel. which causes problems, namely too much stock of goods so that it increases the load in the warehouse and too little stock of goods which results in an exhaustion of stock in the warehouse. To solve this problem, we need an inventory control information system. The method of analysis uses the EOQ (Economic Order Quantity) method. For the system design process using sublime as the writing language and programming PHP, and XAMPP as localhost, the database uses MySQL. This study aims to design an inventory control system in the HRD department at PT Berlina Tbk Tangerang, and to make it easier for the HRD Department to input and create inventory reports. With this research, it can produce an inventory control system design that is more effective and efficient and can find out the storage costs in the warehouse. From the calculation of the EOQ method, it is found that it is 20% smaller than the previous storage and the total cost of ordering in a year is 2x orders. Thus, it means that there is a very real difference between the inventory policies implemented by the company and the EOQ method.

scholarly journals Pengembangan Sistem Informasi Berbasis Web Untuk Pendistribusian Gas LPG

2021 ◽  
Vol 3 (1) ◽  
pp. 20-28
Author(s):  
Wiki Aji Putra Pena ◽  
Lanto Ningrayati Amali ◽  
Manda Rohandi ◽  
Edi Setiawan
Keyword(s):  
Business Owners ◽  
Prototype Model ◽  
Distribution Data ◽  
Surveillance Systems ◽  
Liquefied Petroleum Gas ◽  
Gas Distribution ◽  
Web Based ◽  
Customer Data ◽  
Supervision Process ◽  
Access Rights

Jenis gas LPG (Liquefied Petroleum Gas) ukuran 3 kg hanya diperuntukkan bagi masyarakat miskin dan pelaku UKM, tetapi jenis gas ini juga dinikmati oleh masyarakat yang mampu dan pelaku industry. Hal ini terjadi karena tidak adanya sistem pengawasan yang terkomputerisasi mengenai pendistribusian gas LPG 3 kg yang dilakukan oleh agen dan pangkalan. Penelitian ini bertujuan untuk mengembangkan sistem informasi pendistribusian gas LPG 3 kg di PT.P(Persero) Gorontalo berbasis web. Metode pengembangan sistem yang digunakan adalah model Prototype. Penelitian ini menghasilkan sistem aplikasi yang memberikan hak akses bagi admin untuk dapat menginputkan data yang dibutuhkan seperti data pelanggan, data pangkalan, data distribusi ke pangkalan dan data distribusi ke pelanggan. Sistem ini juga dapat mempermudah pihak agen dalam proses pendistribusian gas LPG 3 kg dan membantu PT.P(Persero) Gorontalo dalam proses pengawasan. Liquefied Petroleum Gas (LPG) in 3kg packaging is reserved actually for poor and SMEs, yet the gas is also utilized by well-off people and business owners. This occurs because of the absence of computerized surveillance systems of the gas distribution by the agent and outlet. This study aimed to develop a web-based system of 3kg Liquefied Petroleum Gas information distribution in PT.P(Persero) Gorontalo; a prototype model was used to develop the system. This research resulted in a system that provides access rights for administrators to be able to input required data, such as customer data, outlet data, outlet distribution data, and customer distribution data. The systems also help the process of 3kg Liquefied Petroleum Gas distribution and PT.P(Persero) Gorontalo in terms of the supervision process.

Simulating Fraunhofer diffraction of waves using microsoft excel spreadsheet

2018 ◽  
Vol 53 (5) ◽  
pp. 055010
Author(s):  
I Singh ◽  
K Khun Khun ◽  
B Kaur
Keyword(s):  
Fraunhofer Diffraction ◽  
Microsoft Excel ◽  
Excel Spreadsheet

Optimizing operations in 3‐D land seismic surveys

Geophysics ◽  
2001 ◽  
Vol 66 (6) ◽  
pp. 1818-1826 ◽  
Author(s):  
Douglas J. Morrice ◽  
Astrid S. Kenyon ◽  
Christian J. Beckett
Keyword(s):  
Minimum Cost ◽  
Seismic Survey ◽  
Production Parameter ◽  
Microsoft Excel ◽  
Trade Off ◽  
Seismic Surveys ◽  
Total Cost ◽  
Decision Variables ◽  
Conduct Sensitivity Analysis ◽  
Operational Constraints

We formulate and solve a mathematical programming optimization model to find a minimum cost solution for an orthogonal split‐spread design in a 3‐D land seismic survey. The model contains decision variables on source and receiver location spacings, the amount of receiver equipment, and the production rate of the seismic crews. The model includes operational constraints for source and receiver movements. It also includes geophysical constraints for fold coverage, offset, and azimuth. To demonstrate the efficacy of the model, we include an example and solve it using the nonlinear optimization solver in Microsoft Excel. The model results demonstrate the classic trade‐off between source and receiver points to satisfy the geophysical requirements. In addition, we conduct sensitivity analysis on an important production parameter: the maximum number of source points that can be shot per day. We show that although changes to this parameter do not impact the decision variables, such changes do have a significant effect on the total cost of the survey.

scholarly journals Sistem Informasi Penjualan Dengan Fitur Customer Relationship Management (CRM) Pada Tria Salon Berbasis Web

2019 ◽  
Vol 1 (3) ◽  
pp. 165-174
Author(s):  
Welda Welda ◽  
Bagus Baskara Sukarma ◽  
Emmy Febriani Thalib
Keyword(s):  
Customer Relationship Management ◽  
Customer Loyalty ◽  
Relationship Management ◽  
Customer Relationship ◽  
Web Based ◽  
Customer Data ◽  
Transaction Data ◽  
To Come ◽  
Service Data ◽  
Incorrect Data

Sales is a transaction carried out by two or more parties between one person to another with a valid payment that generates an income. One of the factors of success of sales is to maintain good relationships with customers, such as giving special promotions to Pelaggan so that customers will continue to come to buy products or services offered by a company.In this study found problems such as the difficulty of determining customer loyalty, the difficulty of determining the product that must be stocked a lot, the difficulty in recording transactions because of the possibility of missing or incorrect data due to Tria salon still recording data in the ledger. In addition, other problems that arise are the delivery of promotions that take more time due to having to send the same message one by one to the customer.The solution to solving this problem is to build a sales information system with web-based customer relationship management (CRM) features. Which later can help admin performance in managing customer data, managing product and service data and managing transaction data. In addition, it can help salon owners in managing customer reports and transaction reports and can provide promotions to all customers.From the results of blackbox testing that has been done, the results obtained are that the test is in accordance with the process that is run and produces an output that is in accordance with the system functions that have been defined.

Sign in / Sign up

Export Citation Format

Share Document