Assisting MSMEs in Determining Optimal Prices Using Spreadsheet-Based Regression Analysis: Pendampingan UMKM dalam Menentukan Harga Optimal menggunakan Analisis Regresi berbasis Spreadsheet

Urwawuska Ladini; Zakiyatunnisa Al Mubarokah

doi:10.59110/rcsd.883

Authors

Urwawuska Ladini UIN Sulthan Thaha Saifuddin Jambi, Jambi, Indonesia
Zakiyatunnisa Al Mubarokah UIN Sulthan Thaha Saifuddin Jambi, Jambi, Indonesia

Keywords:

Data Literacy, Economic Independence, Optimal Pricing, Regression Analysis, Student MSMEs

Abstract

Student MSMEs often face economic vulnerability due to intuitive and unmeasured decision-making, particularly in setting selling prices that are both competitive and profitable in a price-sensitive market. This community service program aimed to strengthen the managerial capacity and data literacy of 30 student entrepreneurs at UIN Sulthan Thaha Saifuddin Jambi through spreadsheet-based regression analysis as an appropriate technology. The program employed a Participatory Action Research (PAR) approach through intensive training, hands-on mentoring using participants’ actual business data, and impact evaluation. The results showed a 110.1% increase in participants’ analytical competence after the intervention. Participants were able to move from intuition-based pricing toward more systematic and data-driven pricing decisions. In addition, the program encouraged more consistent sales data recording and improved participants’ ability to evaluate pricing alternatives based on demand patterns. This program contributed not only to strengthening technical and managerial skills but also to supporting the economic independence and business sustainability of student MSMEs.

Downloads

Download data is not yet available.

References

Albright, S. C., & Winston, W. L. (2020). Business analytics: Data analysis & decision making (7th ed.). Cengage Learning.

Alie, M. S. (2025). Driving local productivity: The interplay of MSMEs, government spending, and economic growth. Shirkah Journal of Economics and Business, 10(2), 254–273. https://doi.org/10.22515/shirkah.v10i2.827

Alvarado, J. M. P. V., & Damián, M. Á. M. (2017). Estimación empírica de elasticidades de oferta y demanda. Revista Mexicana de Ciencias Agrícolas, 6(5), 955–965. https://doi.org/10.29312/REMEXCA.V6I5.590

Aprilia, N., Subroto, W. T., & Sakti, N. C. (2025). The role of small and medium enterprises (SMEs) in supporting the people’s economy in Indonesia. International Journal of Research and Scientific Innovation, 11(12), 368–376. https://doi.org/10.51244/ijrsi.2024.11120036

Bijmolt, T. H., Van Heerde, H. J., & Pieters, R. G. (2005). New empirical generalizations on the determinants of price elasticity. Journal of Marketing Research, 42(2), 141–156. https://doi.org/10.1509/jmkr.42.2.141.622

BPS Prov Jambi. (2023). Jumlah usaha mikro, kecil dan menengah (UMKM). https://opendata.jambiprov.go.id/data-dasar/72/Jumlah%20Usaha%20Mikro,%20Kecil%20dan%20Menengah?tahun=117

BPS Prov Jambi. (2024). Ekonomi Provinsi Jambi tahun 2023 tumbuh 4,66 persen. BPS Provinsi Jambi. https://jambi.bps.go.id/id/pressrelease/2024/02/05/749/ekonomi-provinsi-jambi-tahun-2023-tumbuh-4-66-persen.html

Chong, J. (2021). Real-time price elasticity in electricity: Evaluating regression-based methods. Social Science Research Network. https://doi.org/10.2139/SSRN.3732118

Erick Karunia, M. I. A., Utomo, M. N., Shalahuddin, Shalahuddin, Marsha, D., Aswan, Aswan, Andilolo, O. P., Nursia, Nursia, Suryaningsih, Suryaningsih, & Pratama, A. S. (2025). Pemberdayaan UMKM berbasis digital melalui penguatan strategi pemasaran, literasi keuangan, dan ketahanan ekonomi lokal. Jurnal Pengabdian Kepada Masyarakat Indonesia (JPKMI), 5(1), 58–69. https://doi.org/10.55606/jpkmi.v5i1.6044

Halim, S., Gevionita, Fiolyn, J., Erensia, E., & Malelak, M. I. (2025). UMKM dalam menilai persaingan harga di sektor kerajinan: Studi kasus. Jurnal Inovasi Hasil Pengabdian Masyarakat (JIPEMAS), 8(2), 391–404. https://doi.org/10.33474/jipemas.v8i2.23384

Horngren, C. T., Datar, S. M., & Rajan, M. V. (2021). Cost accounting: A managerial emphasis (17th ed.). Pearson.

Ihsan, K., & Nurlaila, N. (2024). Analysis of expense recording reports in MSMEs in the Pangkalan Mahsyur Subdistrict. International Journal of Education, Social Studies, and Management, 4(3), 1111–1119. https://doi.org/10.52121/ijessm.v4i3.477

Ma, Q., Feng, S., & Liu, J. (2024). Dynamic pricing and demand forecasting: Integrating time-series analysis, regression models, machine learning, and competitive analysis. Applied and Computational Engineering, 93(1), 149–154. https://doi.org/10.54254/2755-2721/93/20240935

Malau, A. G., & Ekananda, M. (2025). The impact of MSMEs on employment, investment, and income. Economics Development Analysis Journal, 14(2), 238–254. https://doi.org/10.15294/edaj.v14i2.24026

Milewski, D., & Wiśniewski, T. (2022). Regression analysis as an alternative method of determining the Economic Order Quantity and Reorder Point. Heliyon, 8(9), 1–9. https://doi.org/10.1016/j.heliyon.2022.e10643

Porter, M. E. (2020). Competitive advantage: Creating and sustaining superior performance. Free Press.

Powell, S. G., & Baker, K. R. (2021). Business analytics: The art of modeling with spreadsheets (5th ed.). Wiley.

Rifqi, D. N., Pinandita, T., & Jamaludin, H. (2023). Memberdayakan UMKM pelatihan Excel untuk peningkatan produktivitas dan menejemen data. Jurnal Pengabdian Kepada Masyarakat (JUDIKA), 4(1), 1–5. https://jurnal.inf.co.id/index.php/jurnalpengabdian/article/view/319

Simon, H., & Fassnacht, M. (2019). Price management: Strategy, analysis, decision, implementation. Springer.

Ulfah, Y., & Setiawaty, A. (2024). Penguatan usaha mikro, kecil dan menengah melalui edukasi penentuan harga jual dalam menghadapi persaingan usaha. ANDIL Mulawarman Journal of Community Engagement, 1(3), 86–91. https://doi.org/10.30872/andil.v1i3.1479

Wahyuni, L., Murtanto, M., Ariani, M., & ... (2022). Penentuan harga pokok produksi dalam menentukan harga jual barang bagi UMKM. Dirkantara, 1(1), 43–48. https://journal.fourzero.id/index.php/di/article/view/23

Widyaningsih, M., Yunas, S., Sudarmaji, E., Retno, B., Ateniyanti, A., Nugroho, A., & Rasyid, A. (2025). Bridging the gap: Improving financial management and business practices in Indonesian MSMEs through capacity-building interventions. International Journal of Social Science and Human Research, 8(5). https://doi.org/10.47191/ijsshr/v8-i5-78