Implementasi Customer Relationship Management (Crm) di Industri Kecil Menengah (Ikm) Furnitur Menggunakan Microsoft Excel dan Visual Basic For Application (VBA)
DOI:
https://doi.org/10.35870/jemsi.v9i2.1029Keywords:
Customer Relationship Management (CRM), Industrial Technology4.0, Furniture IKMAbstract
Small and Medium Furniture Industry is one of the leading commodities of Kendal Regency and has important role in regional economy. Furniture IKM, which was only focused onproducts, must now change its strategy to focus on customers and implement modern management and be able to build relationships with customers. Consumers need more than just the value offered and have unique needs so companies need to think about creating marketing concepts that not only rely on the company's internal capabilities, but also involve consumer feelings. Maintaining good relation swith customers and increasing their loyalty through the development and fulfillment of customer needs is one of IKM furniture strategies in developing business. From the description, the author took the initiative to help design an information system based on Customer Relationship Management (CRM) as an industry 4.0 technology to digitize marketing, especially for managing customers. The implementation of CRM-based information systems starts from collecting data, then analyze business processes, and using case diagrams. The next step is to implement a CRM system using Microsoft Excel VBA. Finally analyze and evaluate CRM implementations in Furniture IKM. From this research we get a CRM system that is suitable for furniture IKM business processes.
Downloads
References
Alfarisi, A. M., & Mahendra, D. (2021). Rancang Bangun Sistem Informasi Penjualan Berbasis Crm Pada Usaha Mikro Kecil Menengah (Umkm) Di Kabupaten Jepara. Journal of Information System and Computer, 01, 43–48.
Beck, B., Summer, J. (2001). Data warehousing horizons CRM: Not just operational and collaborative.
Choudhury, M. M., & Harrigan, P. (2014). CRM to social CRM: the integration of new technologies into customer relationship management. Journal of Strategic Marketing, 22(2), 149–176.
Eko budiardjo Faldy Irwiensyah. (2008). Analisis Fitur CRM Untuk Meningkatkan Kepuasan Pasien Berbasis Pada Framework Of Dynamic CRM Studi Kasus: Departemen Obstetri Dan Ginekologi FKUI-RSCM Jakarta. Seminar Nasional Informatika, 349.
Greenberg, P. (2010). CRM at the Speed of Light , Fourth Edition : for Engaging Your Customers. In New York: Mc Graw Hill.
Husni, I., Amin, A., & Kristanto, A. (2014). Aplikasi Customer Relationship Management ( Crm ) Di Cv . Matahari Digital Printing Semarang. Dinamika Teknik, 8, 49.
Kalakota, D. R., & Robinson, M. (2001). e-Business 2.0. In EAI Journal.
Kansao, R., Yrigoyen, A., Haris, Z., & Saputelli, L. (2017). Waterflood performance diagnosis and optimization using data-driven predictive analytical techniques from capacitance resistance models CRM. Society of Petroleum Engineers - SPE Europec Featured at 79th EAGE Conference and Exhibition, 1545–1571.
Laudon, K. C. (2017). E-commerce 2017: business, technology, society.
Lestari, E., Sabri, L., & Yuwono, B. (2014). Pembuatan Program Perataan Parameter Jaring Poligon Dengan Menggunakan Visual Basic for Application (Vba) Microsoft Excel. Jurnal Geodesi Undip, 3(1), 83411.
Rowe, J. W. F., & Clark, F. E. (1927). Principles of Marketing. Economica, 19, 118.
Utomo, Y. B., Winarno, W. W., & Amborowati, A. (2016). PERANCANGAN CUSTOMER RELATIONSHIP MANAGEMENT PADA KLINIK (Studi Kasus: Klinik Pratama Nusa Medika Meritjan). Multitek Indonesia, 10(1), 57.
Downloads
Published
Issue
Section
License
Authors who publish with this journal agree to the following terms:
1. Copyright Retention and Open Access License
Authors retain copyright of their work and grant the journal non-exclusive right of first publication under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
This license allows unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
2. Rights Granted Under CC BY 4.0
Under this license, readers are free to:
- Share — copy and redistribute the material in any medium or format
- Adapt — remix, transform, and build upon the material for any purpose, including commercial use
- No additional restrictions — the licensor cannot revoke these freedoms as long as license terms are followed
3. Attribution Requirements
All uses must include:
- Proper citation of the original work
- Link to the Creative Commons license
- Indication if changes were made to the original work
- No suggestion that the licensor endorses the user or their use
4. Additional Distribution Rights
Authors may:
- Deposit the published version in institutional repositories
- Share through academic social networks
- Include in books, monographs, or other publications
- Post on personal or institutional websites
Requirement: All additional distributions must maintain the CC BY 4.0 license and proper attribution.
5. Self-Archiving and Pre-Print Sharing
Authors are encouraged to:
- Share pre-prints and post-prints online
- Deposit in subject-specific repositories (e.g., arXiv, bioRxiv)
- Engage in scholarly communication throughout the publication process
6. Open Access Commitment
This journal provides immediate open access to all content, supporting the global exchange of knowledge without financial, legal, or technical barriers.
