Abstract :

Indonesia is known to be one of Southeast Asia’s largest markets for used cars. Used car showrooms in Indonesia are numerous and varied, some focus on one car brand, some focus on the lower middle class, some focus on the upper middle class, and some provide all types of cars. One of them is PQR Showroom, Even though PQR Showroom was able to generate such a great amount of sales, the profits generated by the PQR showroom are not proportional to the amount of capital invested.

To increase the profit, we proposed the solution using descriptive analytics and prescriptive analytics using K-Means. We also carry out simulations by comparing sales in existing years with the results of the descriptive and prescriptive analytics that have been made for the expected profit.

The results show that the simulation comparison with the data we have obtained from descriptive and prescriptive analysis gives the best-expected profit compared to the initial sales results at the PQR Showroom.

It shows that the data using descriptive and K-Means is great than before. The fastest cars that have been sold is LCGC and the most wanted car is MPY Toyota Avanza and the best profit that can generate is SUV Toyota Fortuner.

---

Keywords :

Descriptive Analytics, K-Means, Prescriptive Analytics, Sales, Used cars.

---

References :

1. Mendiratta, A. (2021, January 21). Digitalization Transforming the Used Car Industry in Indonesia. Ken Research. Retrieved July 9, 2023, from https://www.kenresearch.com/interviews/digitalization-transforming-the-used-car-industry-in-indonesia/45.html
2. Mordor Intelligence. (2022, December). Southeast Asia Used Car Market – Share, Analysis & Growth. Mordor Intelligence. Retrieved July 9, 2023, from https://www.mordorintelligence.com/industry-reports/south-east-asia-used-car-market
3. OLX Autos Indonesia. (2021, December). 2021 Used Car Market Review & 2022 Outlook. OLX News. Retrieved July 9, 2023, from https://news.olx.co.id/wp-content/uploads/2022/02/OLX-Whitepaper-final-Eng-revcopy-10.12.pdf
4. Liu, S., Liu, O., & Chen, J. (2023). Mathematics Journal. A Review on Business Analytics: Definitions, Techniques, Applications, and Challenges, 11(899).
5. Duan, L., & Xiong, Y. (2015, March 19). Journal of Management Analytics. Big Data Analytics and Business Analytics, 2(1), 1-21. http://www.tandfonline.com/loi/tjma20
6. Chen, H., Chiang, R. H. L., & Storey, V. C. (2012, December). MIS Quarterly. Business Intelligence and Analytics: From Big Data to Big Impact, 36(4), 1165-1188. https://www.jstor.org/stable/41703503
7. Delen, D., & Zolbanin, H. M. (2018, September). Journal of Business Research. The Analytics Paradigm in Business Research, 90, 186-195.
8. Delen, D., & Ram, S. (2018). Journal of Business Analytics. Research Challenges and Opportunities in Business Analytics, 1(1), 2-12.
9. Kraus, M., Feuerriegel, S., & Oztekin, A. (2019, September 11). European Journal of Operational Research. Deep Learning in Business Analytics and Operations Research: Models, Applications, and Managerial Implications, 239(3), 628-641.
10. Bayrak, T. (2015). Procedia – Social Behavioral Sciences. A Review of Business Analytics: A Business Enabler or Another Passing Fad, 195(2015), 230-239.
11. Ware, C. (2004). Information Visualization: Perception for Design. Morgan Kaufmann.
12. Lepenioti, K., Bousdekis, A., Apostolous, D., & Mentzas, G. (2020). International Journal of Management. Prescriptive Analytics: Literature Review and Research Challenges, 50(2020), 57-70.
13. Ediyanto, Mara, M. N., & Satyahadewi, N. (2013). Buletin Ilmiah Mat, Stat, dan Terapannya. Pengklasifikasian Karakteristik Dengan Metode K-Means Cluster Analysis, 2(2), 133-136.
14. Merliana, N. P. E., Ernawati, & Santoso, A. J. (2015). PROSIDING SEMINAR NASIONAL MULTI DISIPLIN ILMU & CALL FOR PAPERS UNISBANK. ANALISA PENENTUAN JUMLAH CLUSTER TERBAIK PADA METODE K-MEANS CLUSTERING.
15. Arvai, K. (2020). K-Means Clustering in Python: A Practical Guide – Real Python. Real Python. Retrieved July 9, 2023, from https://realpython.com/k-means-clustering-python/
16. Xiao, J., Lu, J., & Li, X. (2017). Intelligent Data Analysis. Davies Bouldin Index Based Hierarchical Initialization K-Means, 21, 1327-1388.