INVENTORI MANAGER UNTUK MENINGKATKAN PENJUALAN PADA SHOWROOM RALIF MOBIL DI BANJARMASIN

Fajar, Adha and Bayu, Nugraha and Muhammad, Riko Anshori Prasetya INVENTORI MANAGER UNTUK MENINGKATKAN PENJUALAN PADA SHOWROOM RALIF MOBIL DI BANJARMASIN. [Karya Dosen UNISM]

Text 2.145-160+Fajar+Adha (1).pdf Download (2MB)

Abstract

Vehicle stock and sales recording at Ralif Motor ShowroomBanjarmasin was previously carried out manually, which posed risks of data loss, recording errors, and difficulties in transaction tracking. This study aims to design and develop a web-based information system to manage stock and sales data in an integrated manner and to provide visualizations that support managerial decision-making. The system was developed using PHP as the programming language and MySQL as the database, employing the Agile Kanban approach, and was equipped with an interactive dashboard using Tableau. The research data were obtained from stock and sales reports of Ralif Motor Showroom for the 2023–2025 period. After the preprocessing stage, the final dataset consisted of 36 stock entries in 2024, 31 sales transactions in 2024, 20 stock entries in 2025, 11 sales transactions in 2025, and 14 remaining stock units that were unsold. Each data entry included vehicle code, model, brand, entry date, purchase price, repair cost, selling price, and transaction number. The net profit was defined as the difference between the selling price and repair cost for each transaction. The implementation results show that the system can record transactions and update stock data in real time, maintain data consistency through input validation, display monthly sales trends and vehicle inflow using line and bar charts, and generate key sales metrics that can be exported for reporting. The digitalization of the inventory process has proven to improve recording accuracy, minimize input errors, and accelerate sales performance monitoring, thereby supporting data-driven decision-making.

Actions (login required)

View Item