Optimizing Education Budget Allocation in Schools Using Excel Solver
Keywords:
Linear Programming, Excel Solver, Optimization, Educational Budget, School ManagementAbstract
Education budget management plays a crucial role in supporting the success of school education. Limited funding requires schools to allocate their budgets effectively to ensure optimal program implementation. This study aims to determine the optimal allocation of the education budget through the application of the Linear Programming method with the help of the Solver Add-in in Microsoft Excel. The study used data simulation involving four decision variables: teacher training and development budget, digital facilities and infrastructure, extracurricular activities and student welfare, and school building maintenance. An optimization model was designed based on the objective function and a number of constraints reflecting the school’s budget limitations. The simulation results show that Excel Solver is capable of generating optimal budget allocation solutions within all established constraints. Therefore, Excel Solver can be used as a decision-making tool in more systematic, objective, and efficient education budget planning and management.
Downloads
References
Indra Purnama, P., Sipil, T., Teknik, F., Dan, S., & Indonesia, U. I. (2021). MENGGUNAKAN PROGRAM LINIER
METODE SIMPLEX DAN BUILDING INFORMATION MODELING ( BIM ) ( OPTIMIZATION BEAM
REINFORCEMENT USING LINEAR PROGRAM SIMPLEX METHOD AND BUILDING INFORMATION
MODELING ) MENGGUNAKAN PROGRAM LINIER METODE SIMPLEX DAN BUILDING INFORMATIO.
Latief, F., & Suriyanti, D. (2023). Economics and Digital Business Review Analisis Perencanaan Produksi Dengan
Metode Linear Programming Guna Memaksimalkan Keuntungan. 4(1), 383–397.
Lubin et al. (2022). (n.d.). JuMP 1.0: Recent improvements to a modeling language for mathematical optimization.
Maryana, M., Putri, I. H., Sepriadi, S., Studi, P., Pertambangan, T., Palembang, P. A., Simpleks, M., & Solver, M. E. (n.d.).
PENERAPAN METODE SIMPLEKS DENGAN MICROSOFT EXCEL SOLVER UNTUK OPTIMALISASI
BLENDING BATUBARA SESUAI KRITERIA. 8, 614–621.
Oladejo, N. K., Abdul-shakuru, M., & Jafar, A. W. (2025). Linear Programming Techniques and Its Application in
Optimizing Lecture Room in an Institution. 14(1), 10–28. https://doi.org/10.4236/ojop.2025.141002
Fakhriyana, D., & Anggreini, M. N. (2026). Simplex vs. Revised Simplex for Budget Allocation in Madrasah Teacher and
Staff Development Programs under MoRA Kudus, Indonesia. Zero: Jurnal Sains, Matematika, dan Terapan.
Santi, E. E. (2015). Pemanfaatan Solver Excel untuk Optimasi Penjadwalan Mata Pelajaran. Jurnal Dimensi Pendidikan
dan Pembelajaran, 3(1), 9–15.
Anam, M. S. (2024). Pemanfaatan Solver Excel untuk Menentukan Mahasiswa Penerima Beasiswa Menggunakan
Pemrograman Linier. EPIC Journal.
Maryana, M., Putri, I. H., Sepriadi, S., et al. (2024). Penerapan Metode Simpleks dengan Microsoft Excel Solver untuk
Optimalisasi Blending Batubara Sesuai Kriteria. Jurnal Teknik Pertambangan, 8, 614–621.
Celestin, M., Kumar, M. S., Gidisu, J. A., & Dometi, W. T. (2025). The Utilization of Advanced Linear Programming
Models to Optimize Allocation of Limited Public Resources in the Context of Public Financial Management
Systems. Kings and Queens Journal of Multidisciplinary Research, 1(1), 49–60.
Wan Abdul Aziz, R. et al. (2019). Dynamic Linear Programming Model for Quarterly Budget Allocation and Execution.
Universiti Teknologi MARA
Maktabi, H., Tohidi, H., & Seyedaliakbar, S. M. (2011). An Application of Linear Programming for Efficient Resource
Allocation: Case Study of University Education. Australian Journal of Basic and Applied Sciences, 5(12), 703–
706.
Hudawi, A. (2025). Enhancing Internship Assignment Efficiency Through Spreadsheet-Based Linear Programming
Using Microsoft Excel Solver. Journal of Knowledge Optimization and Innovation.
Samsuriah. (2020). Metode Simpleks dalam Program Linear dengan Fungsi Solver di Excel. Progres: Professional Journal
in Integrity, Knowledge, and Skill, 12(1), 2–7.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 SCOPE (Social Sciences, Computing, and Engineering)
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
