PROFIT OPTIMIZATION AND COST EFFICIENCY OF PRODUCT MIX WITH LINIER PROGRAMMING SPREADSHEET MODEL
(Case of Nanda Salad)
Abstract
ABSTRACT
This research aims to provide the best model in order to optimize profits and minimize costs in the field of product mix at Micro Smal Medium Enterprises called Nanda Salad, Malang, East Java, Indonesia.This research uses the Solver Spreadsheet Model to produce a Linier Programming scheme. The analysis method begins with the process of collecting data, constructing the model, defining the variables, constructiong the objective function, designing the model constraints, constructing the solution model, and implementing the solution. The results of this research indicate that profit optimization and cost efficiency can be obtained more optimally if Nanda Salad chooses to carry out production activities with on line 1 compared to on line 2. In addition to getting profit optimization and cost efficiency schemes, on line 1 shows that Nanda Salad can use their limited resources to produce of product mix optimally. By considering the average of return, Nanda Salad can optimally meet consumer demand without wasting costs. To increase the accuracy result, MSMEs can combine forecasting approaches with Linier Programming.
Keywords: Cost efficiency, Excel, Linier Programming, Product Mix, Profit Optimization
ABSTRAK
Penelitian ini bertujuan untuk memberikan model terbaik dalam rangka mengoptimalkan laba dan meminimalkan biaya terhadap produksi produk campuran pada Usaha Mikro Kecil Menengah bernama Nanda Salad, Malang, Jawa Timur, Indonesia. Penelitian ini menggunakan Solver Spreadsheet Model untuk menghasilkan skema Linier Programming. Metode analisis dimulai dengan proses pengumpulan data, membangun model, mendefinisikan variabel, membangun fungsi tujuan, merancang batasan model, membangun model penyelesaian, dan pengimplementasian solusi. Hasil penelitian ini menunjukkan bahwa optimalisasi laba dan efisiensi biaya dapat diperoleh dengan lebih maksimal apabila Nanda Salad memilih untuk menjalankan kegiatan produksi dengan skema on line 1 dibandingkan on line 2. Selain mendapatkan skema optimalisasi laba dan efisiensi biaya, skema on line 1 menjawab dengan jelas bahwa Nanda Salad dapat mempergunakan sumber daya yang terbatas untuk memproduksi produk campuran dengan optimal. Dengan mempertimbangkan rata-rata jumlah retur Nanda Salad dapat memenuhi permintaan konsumen secara optimal tanpa adanya kondisi pemborosan biaya. Untuk meningkatkan keakuratan hasil, UMKM dapat mengombinasikan pendekatan forecasting dengan Linier Programming.
Kata Kunci: Efisiensi biaya, Excel, Linier Programming, Optimalisasi laba, Produk Campuran
References
Azzahra, B., & Wibawa, I. G. A. R. P. (2021). Strategi optimalisasi standar kinerja UMKM sebagai katalis perekonomian indonesia dalam menghadapi middle income trap 2045. Inspire Journal: Economics and Development Analysis, 1(1), 75–86. https://ejournal.uksw.edu/inspire/article/download/4856/1771
Baki, S. M., & Cheng, J. K. (2021). A linear programming model for product mix profit maximization in a small medium enterprise company. International Journal of Industrial Management, 9, 64–73. https://doi.org/10.15282/ijim.9.0.2021.5956
Balogun, O. S., Jolayemi, E. T., Akingbade, T. J., & Muazu, H. G. (2012). Use of linear programming for optimal production in a production line in Coca–Cola bottling company, Ilorin. International Journal of Engineering Research and Applications, 2.
Biswas, S., & Chakraborty, A. (2016). Importance of production planning and control in small manufacturing enterprises. International Journal of Engineering Science Invention, 5(6), 61–64.
Eka Saputra, V. M. (2021). OPTIMASI PERENCANAAN PRODUKSI DENGAN METODE LINIER PROGRAMING PADA INDUSTRI KERIPIK TEMPE SANAN MALANG “TOKO VELODROM.” Universitas Muhammadiyah Malang.
Ezema, B. I., & Amakom, U. (2012). Optimizing profit with the linear programming model: A focus on golden plastic industry limited, Enugu, Nigeria. Interdisciplinary Journal of Research in Business, 2(2), 2046–2057.
Fagoyinbo, I. S., Akinbo, R. Y., Ajibode, I. A., & Olaniran, Y. O. A. (2011). Maximization of profit in manufacturing industries using linear programming techniques: Geepee Nigeria Limited. 1st International Technology, Education and Environment Conference, 1(1–2), 159–166.
Ginting, M., Kirawan, M., & Marpaung, B. (2018). Product mix optimization on multi-constraint production planning-a Fuzzy Mixed Integer Linear Goal Programming (FMILGP) approach: A single case study. MATEC Web of Conferences, 204, 2004.
Haider, Z., Fareed, R., Tariq, M. B., Usman, S., Din, N. U., & Khan, M. S. (2016). Application of Linear Programming for Profit Maximization: A Case of Paints Company, Pakistan. International Journal of Management Sciences and Business Research, 5(12), 141–151
Kristiyanti, M. (2012). Peran strategis usaha kecil menengah (UKM) dalam pembangunan nasional. Majalah Ilmiah Informatika, 3, 15.
Lian, C. L. (2018). Competitive Advantage of Malaysian Small Medium Enterprises: Impact of Supply Chain management Practices, environmental Uncertainty and Supply Chain Flexibility. Asia e University.
Mariam, O. O. (2017). Inventory Control and Profit Maximization in a Manufacturing Company; A Case Study of Nigeria Distillereis Limited, Sango Otta Ogun State. Departement of Accounting, Faculty of Management Science, National Open University of Nigeria.
Maurya, V. N., Misra, R. B., Anderson, P. K., & Shukla, K. K. (2015). Profit optimization using linear programming model: A case study of Ethiopian chemical company. American Journal of Biological and Environmental Statistics, 1(2), 51–57. https://doi.org/https://doi.org/10.11648/j.ajbes.20150102.12
Molina, M. G. (2018). Product mix optimization at minimum supply cost of an online clothing store using linear programming. International Journal of Applied Mathematics Electronics and Computers, 6(3), 33–38. https://doi.org/https://doi.org/10.1039/b000000x
Munawir, S. (2014). Analisa Laporan Keuangan (17th ed.). Liberty Yogyakarta.
Ogbeide, D., & Ejechi, J. O. (2018). Product Mix Optimization in the Manufacturing Industry: A Linear Product Mix Optimization in the Manufacturing Industry: A Linear Programming Approach. Journal of Economics and Finance, 2(2), 263–275.
Sharma, J. K. (2017). Operations Research Theory And Applications (6th ed.). Laxmi Publications.
Sikder, J., Mahmud, T., Banik, B., & Gupta, S. (2018). Linear Programming To Find The Critical Path Using Spreadsheet Methodology. August, 10–13. https://doi.org/10.9790/0661-2003024850
Sugiyono. (2009). Metode Penelitian Bisnis. CV Alfabeta.
Sugiyono. (2013). Metodologi Penelitian. Media Press.
Sugiyono. (2015). METODE PENELITIAN & PENGEMBANGAN. CV Alfabeta.
Tannady, H. (2017). Optimasi Produksi Meubel Menggunakan Model Pemrograman Linear. Business Management Journal, 10(1), 1-9.
Wang, Y., & Li, L. (2017). Manufacturing profit maximization under time-varying electricity and labor pricing. Computers & Industrial Engineering, 104, 23–34. https://doi.org/https://doi.org/10.1016/j.cie.2016.12.011
Yahya, W. B., Garba, M. K., Ige, S. O., & Adeyosoye, A. E. (2012). Profit maximization in a product mix company using linear programming. European Journal of Business and Management, 4(17), 126–131.
Yulianto, A. W., Suyitno, H., & Mashuri, M. (2012). Aplikasi Fuzzy Linear Programming Dalam Optimalisasi Produksi. UNNES Journal of Mathematics, 1(1) 7-14.
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
