Penerapan Sistem Sederhana Berbasis Excel untuk Membantu Penentuan Harga Jual Rebung Kering pada UMKM Ibu Rumah Tangga

Fransiska Elly Renni Susanti; Heni Ermewaningsih; Anisa Safitri

doi:10.60004/komunita.v5i3.766

Fransiska Elly Renni Susanti Institut Teknologi Keling Kumang
Heni Ermewaningsih Institut Teknologi Keling Kumang https://orcid.org/0009-0005-0187-2067
Anisa Safitri Institut Teknologi Keling Kumang

DOI: https://doi.org/10.60004/komunita.v5i3.766

Keywords: Decision making, price, profit, simple system, SMEs

Abstract

This community service activity is motivated by the problem of price determination in SMEs, which is still conducted conventionally without considering the relationship between price, sales volume, and profit. This condition often leads to suboptimal pricing decisions and reduced business profitability. This activity aims to assist SMEs in determining optimal selling prices through the implementation of a simple system based on Microsoft Excel. The methods used include interviews to identify problems, system design and development, internal testing, socialization and training, and evaluation of system usage by the partners. The results show that the partners are able to use the system to simulate pricing and understand the relationship between price, demand, and profit. Based on the simulation results, a price of Rp 19,900 generates the highest estimated profit of Rp 373,399.29 per production cycle. In addition, there is a shift in the partners’ decision-making approach from intuitive to a more structured and calculation-based method. Therefore, the developed system not only supports price determination but also enhances business decision-making capabilities in a more effective and sustainable manner.

References

A. Sabulao, M., & L. Docena, R. (2024). The Relationship Between the Consumer’s Demand and Medium Enterprise Profitability. FMDB Transactions on Sustainable Management Letters, 2(4), 162–171. https://doi.org/10.69888/ftsml.2024.000315

Chinonso Benjamin Obiajulu, Chidimma Francisca Azubuko, & Joshua Okpanachi. (2025). Exploring pricing strategies and their impact on financial performance of SMEs in Nigeria. World Journal of Advanced Research and Reviews, 27(2), 1281–1287. https://doi.org/10.30574/wjarr.2025.27.2.2922

Díaz-Arancibia, J., Hochstetter-Diez, J., Bustamante-Mora, A., Sepúlveda-Cuevas, S., Albayay, I., & Arango-López, J. (2024). Navigating Digital Transformation and Technology Adoption: A Literature Review from Small and Medium-Sized Enterprises in Developing Countries. In Sustainability (Switzerland) (Vol. 16, Number 14). Multidisciplinary Digital Publishing Institute (MDPI). https://doi.org/10.3390/su16145946

Gómez-Prado, R., Alvarez-Risco, A., Cuya-Velásquez, B. B., Arias-Meza, M., Campos-Dávalos, N., Juarez-Rojas, L., Anderson-Seminario, M. de las M., Del-Aguila-Arcentales, S., & Yáñez, J. A. (2022). Product Innovation, Market Intelligence and Pricing Capability as a Competitive Advantage in the International Performance of Startups: Case of Peru. Sustainability (Switzerland), 14(17). https://doi.org/10.3390/su141710703

Karabağ, O., & Gökgür, B. (2023). Integrated optimisation of pricing, manufacturing, and procurement decisions of a make-to-stock system operating in a fluctuating environment. International Journal of Production Research, 61(24), 8423–8450. https://doi.org/10.1080/00207543.2022.2152127

Liu, C., & Sustik, M. A. (2021). Elasticity Based Demand Forecasting and Price Optimization for Online Retail. In eprint arXiv:2106.08274. https://doi.org/10.48550/arXiv.2106.08274

Mgbame, A. C., Akpe, O. E., Abayomi, A. A., Ogbuefi, E., & Adeyelu, O. O. (2022). Developing Low-Cost Dashboards for Business Process Optimization in SMEs. International Journal of Management and Organizational Research, 1(1), 214–230. https://doi.org/10.54660/ijmor.2022.1.1.214-230

Ni, G. (2023). Optimal decisions on price and inventory for a newsboy-type retailer with identifiable information and discount promotion. PLoS ONE, 18(7 July). https://doi.org/10.1371/journal.pone.0288874

Njideka Ihuoma Okeke, Oluwaseun Adeola Bakare, & Godwin Ozoemenam Achumie. (2024). Implementing data-driven financial management systems in SMEs: A case review approach. International Journal of Management & Entrepreneurship Research, 6(10), 3243–3258. https://doi.org/10.51594/ijmer.v6i10.1613

Okfalisa, Anggraini, W., Mahyarni, Saktioto, & Pranggono, B. (2022). Assessing Digital Readiness of Small Medium Enterprises: Intelligent Dashboard Decision Support System. IJACSA) International Journal of Advanced Computer Science and Applications, 13(4), 98–108. https://doi.org/10.14569/IJACSA.2022.0130412

Rezazadeh, J., Bagheri, R., Karimi, S., Nazarian-Jashnabadi, J., & Nezhad, M. Z. (2023). Examining the impact of product innovation and pricing capability on the international performance of exporting companies with the mediating role of competitive advantage for analysis and decision making. Journal of Operations Intelligence, 1(1), 30–43. https://doi.org/10.31181/jopi1120232

San-José, L. A., Sicilia, J., & Abdul-Jalbar, B. (2021). Optimal policy for an inventory system with demand dependent on price, time and frequency of advertisement. Computers and Operations Research, 128. https://doi.org/10.1016/j.cor.2020.105169

Somogyi, R., Vergote, W., & Virag, G. (2023). Price competition with capacity uncertainty - feasting on leftovers. Games and Economic Behavior, 140, 253–271. https://doi.org/10.1016/j.geb.2023.03.010

Tanjung, F. S. (2024). Data-Driven Decisions: Leveraging Analytics for Strategic Marketing Management. Equator Journal OfManagement and Entrepreneurship, 12(4). https://doi.org/10.26418/ejme.v12i3.81935

Taparia, V., Mishra, P., Gupta, N., & Chandiramani, H. (2023). Data-Driven Retail Excellence: Machine Learning for Demand Forecasting and Price Optimization. Journal of Graphic Era University, 12(1), 37–52. https://doi.org/10.13052/jgeu0975-1416.1213