Application of Linear Programming to Optimize Production and Profit (A Case Study of Oda Natural Spring Water Factory)

Ahmed Buseri Ashine; Mideksa Tola Jiru

doi:doi:10.11648/j.ijtam.20261201.12

Research Article |

| Peer-Reviewed

Application of Linear Programming to Optimize Production and Profit (A Case Study of Oda Natural Spring Water Factory)

Ahmed Buseri Ashine^*

, Mideksa Tola Jiru

Published in International Journal of Theoretical and Applied Mathematics (Volume 12, Issue 1)

Received: 6 November 2025 Accepted: 14 January 2026 Published: 31 January 2026

Views: Downloads:

Download PDF

Share This Article

Twitter
Linked In
Facebook

Abstract

This research focuses on optimizing production processes at Oda Natural Spring Water Factory in Ethiopia through the application of Linear Programming (LP). In the competitive bottled water industry, efficient resource management is crucial for profitability. Oda Natural Spring Water, known for its unique selenium-rich composition, faces challenges related to inefficient production practices and suboptimal resource allocation. This study develops a tailored LP model to determine the optimal daily production quantities for four bottled water sizes (35cl, 60cl, 100cl, and 200cl), with the objective of maximizing profit while adhering to constraints such as production time, cost budget, and market demand limits. Data collected over six months were analyzed using Excel Solver. The findings indicate that the factory can achieve a maximum daily profit of 150,143 Ethiopian Birr (ETB) by producing 1,100 packs of 35cl, 1,714 packs of 60cl, 1,441 packs of 100cl, and 976 packs of 200cl water. Sensitivity analysis reveals that the production cost constraint is binding, while significant production time remains unused. The study underscores LP as a practical decision-making tool in manufacturing, providing actionable strategies for improving resource allocation, reducing costs, and enhancing profitability. Recommendations include cost reduction initiatives and regular review of production plans in response to market dynamics.

Published in	International Journal of Theoretical and Applied Mathematics (Volume 12, Issue 1)
DOI	10.11648/j.ijtam.20261201.12
Page(s)	13-23
Creative Commons	This is an Open Access article, distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution and reproduction in any medium or format, provided the original work is properly cited.
Copyright	Copyright © The Author(s), 2026. Published by Science Publishing Group

Keywords

Linear Programming, Production Optimization, Profit Maximization, Resource Allocation, Selenium, Excel Solver

References

[1]	Ezema, J. L., & Amakou, J. U. (2012). Optimizing profit using linear programming: A case study of a plastic industry. Journal of Mathematics and Statistics, 8(1), 9–14.
[2]	Fagoyinbo, I. S., & Ajibode, I. A. (2010). Application of linear programming technique in the efficient allocation of raw materials in plastic production. Journal of Research in National Development, 8(2), 1–14.
[3]	Frizzone, J. A., Mateos, L., & Goncalves, J. R. (1997). Application of linear programming for efficient water resources allocation. Agricultural Water Management, 35(1-2), 1–14.
[4]	Khan, A. A., Jaber, M. Y., & Bonney, M. (2011). A sensitivity analysis of a production planning model with carbon emissions. International Journal of Production Economics, 133(1), 375–381. https://doi.org/10.1016/j.ijpe.2011.05.010
[5]	Nonso, M. (2005). Linear Programming for Managerial Decision. Discovery Publishing House.
[6]	Olayemi, O. O., Ilesanmi, A. O., Durojaye, A. A., & Opatoyinbo, O. P. (2021). Application of linear programming in optimization of production cost in Coca-Cola Bottling Company, Ibadan, Nigeria. International Journal of Mechanical Engineering and Technology, 12(1), 1–10.
[7]	Taha, H. A. (1977). Operations research: An introduction. Macmillan Publishing Co.
[8]	Gerold, E., & Antrekowitsch, H. (2022). A Sustainable Approach for the Recovery of Manganese from Spent Lithium-Ion Batteries via Photocatalytic Oxidation. International Journal of Material Science and Applications, 11(3), 66–76. https://doi.org/10.11648/j.ijma.20221103.12
[9]	Smith, J., & Doe, A. (2023). Optimization techniques in beverage production: A review of linear programming applications. Journal of Food Process Engineering, 46(4), e14345. https://doi.org/10.1111/jfpe.14345
[10]	Kumar, R., & Singh, V. (2023). Resource allocation and profit maximization in manufacturing using linear programming: A case study of the packaged water industry. Operations Research Perspectives, 10, 100275. https://doi.org/10.1016/j.orp.2023.100275
[11]	Chen, L., & Wang, Y. (2022). Integrating sensitivity analysis into production planning for robust optimization. International Journal of Production Economics, 245, 108392. https://doi.org/10.1016/j.ijpe.2021.108392
[12]	Alvarez, P., & Garcia, M. (2023). Sustainable production planning under resource constraints: An LP approach for the agri-food sector. Sustainable Production and Consumption, 36, 246–258. https://doi.org/10.1016/j.spc.2023.01.012
[13]	Patel, S., & Mehta, R. (2022). Application of Excel Solver in operational research for small and medium enterprises. Journal of Applied Quantitative Methods, 17(2), 45–60.
[14]	Feng, X., & Zhang, Q. (2023). Linear programming for capacity planning and profit optimization in the bottled water industry. Journal of Cleaner Production, 382, 135234. https://doi.org/10.1016/j.jclepro.2022.135234
[15]	Ibrahim, A., & Oyelade, O. (2022). Enhancing profitability through optimal resource allocation in beverage manufacturing: A linear programming model. African Journal of Science, Technology, Innovation and Development, 14(5), 1287–1298. https://doi.org/10.1080/20421338.2021.2006784
[16]	Nguyen, T., & Lee, H. (2023). Stochastic linear programming for production planning under demand uncertainty. Computers & Industrial Engineering, 176, 108956. https://doi.org/10.1016/j.cie.2022.108956
[17]	Rahman, S., & Hossain, M. (2022). Optimization of production processes in developing economies: A case study using linear programming. International Journal of Business Analytics, 9(3), 1–18. https://doi.org/10.4018/IJBAN.20220701.o1
[18]	Davis, K., & Brown, T. (2023). The role of sensitivity analysis in linear programming models for manufacturing optimization. Journal of Manufacturing Systems, 66, 112–124. https://doi.org/10.1016/j.jmsy.2022.11.005
[19]	Gomez, L., & Silva, P. (2022). Economic and operational benefits of linear programming in the mineral water industry. Resources Policy, 78, 102876. https://doi.org/10.1016/j.resourpol.2022.102876
[20]	Yusuf, M., & Abdullahi, S. (2023). Integrating environmental constraints into production optimization using linear programming: A beverage sector case. Environmental Science and Pollution Research, 30, 45672–45685. https://doi.org/10.1007/s11356-023-25425-7

Cite This Article

Plain Text BibTeX RIS

APA Style

Ashine, A. B., Jiru, M. T. (2026). Application of Linear Programming to Optimize Production and Profit (A Case Study of Oda Natural Spring Water Factory). International Journal of Theoretical and Applied Mathematics, 12(1), 13-23. https://doi.org/10.11648/j.ijtam.20261201.12

Copy | Download

ACS Style

Ashine, A. B.; Jiru, M. T. Application of Linear Programming to Optimize Production and Profit (A Case Study of Oda Natural Spring Water Factory). Int. J. Theor. Appl. Math. 2026, 12(1), 13-23. doi: 10.11648/j.ijtam.20261201.12

Copy | Download

AMA Style

Ashine AB, Jiru MT. Application of Linear Programming to Optimize Production and Profit (A Case Study of Oda Natural Spring Water Factory). Int J Theor Appl Math. 2026;12(1):13-23. doi: 10.11648/j.ijtam.20261201.12

Copy | Download

@article{10.11648/j.ijtam.20261201.12,
  author = {Ahmed Buseri Ashine and Mideksa Tola Jiru},
  title = {Application of Linear Programming to Optimize Production and Profit (A Case Study of Oda Natural Spring Water Factory)},
  journal = {International Journal of Theoretical and Applied Mathematics},
  volume = {12},
  number = {1},
  pages = {13-23},
  doi = {10.11648/j.ijtam.20261201.12},
  url = {https://doi.org/10.11648/j.ijtam.20261201.12},
  eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.ijtam.20261201.12},
  abstract = {This research focuses on optimizing production processes at Oda Natural Spring Water Factory in Ethiopia through the application of Linear Programming (LP). In the competitive bottled water industry, efficient resource management is crucial for profitability. Oda Natural Spring Water, known for its unique selenium-rich composition, faces challenges related to inefficient production practices and suboptimal resource allocation. This study develops a tailored LP model to determine the optimal daily production quantities for four bottled water sizes (35cl, 60cl, 100cl, and 200cl), with the objective of maximizing profit while adhering to constraints such as production time, cost budget, and market demand limits. Data collected over six months were analyzed using Excel Solver. The findings indicate that the factory can achieve a maximum daily profit of 150,143 Ethiopian Birr (ETB) by producing 1,100 packs of 35cl, 1,714 packs of 60cl, 1,441 packs of 100cl, and 976 packs of 200cl water. Sensitivity analysis reveals that the production cost constraint is binding, while significant production time remains unused. The study underscores LP as a practical decision-making tool in manufacturing, providing actionable strategies for improving resource allocation, reducing costs, and enhancing profitability. Recommendations include cost reduction initiatives and regular review of production plans in response to market dynamics.},
 year = {2026}
}

Copy | Download

TY  - JOUR
T1  - Application of Linear Programming to Optimize Production and Profit (A Case Study of Oda Natural Spring Water Factory)
AU  - Ahmed Buseri Ashine
AU  - Mideksa Tola Jiru
Y1  - 2026/01/31
PY  - 2026
N1  - https://doi.org/10.11648/j.ijtam.20261201.12
DO  - 10.11648/j.ijtam.20261201.12
T2  - International Journal of Theoretical and Applied Mathematics
JF  - International Journal of Theoretical and Applied Mathematics
JO  - International Journal of Theoretical and Applied Mathematics
SP  - 13
EP  - 23
PB  - Science Publishing Group
SN  - 2575-5080
UR  - https://doi.org/10.11648/j.ijtam.20261201.12
AB  - This research focuses on optimizing production processes at Oda Natural Spring Water Factory in Ethiopia through the application of Linear Programming (LP). In the competitive bottled water industry, efficient resource management is crucial for profitability. Oda Natural Spring Water, known for its unique selenium-rich composition, faces challenges related to inefficient production practices and suboptimal resource allocation. This study develops a tailored LP model to determine the optimal daily production quantities for four bottled water sizes (35cl, 60cl, 100cl, and 200cl), with the objective of maximizing profit while adhering to constraints such as production time, cost budget, and market demand limits. Data collected over six months were analyzed using Excel Solver. The findings indicate that the factory can achieve a maximum daily profit of 150,143 Ethiopian Birr (ETB) by producing 1,100 packs of 35cl, 1,714 packs of 60cl, 1,441 packs of 100cl, and 976 packs of 200cl water. Sensitivity analysis reveals that the production cost constraint is binding, while significant production time remains unused. The study underscores LP as a practical decision-making tool in manufacturing, providing actionable strategies for improving resource allocation, reducing costs, and enhancing profitability. Recommendations include cost reduction initiatives and regular review of production plans in response to market dynamics.
VL  - 12
IS  - 1
ER  -

Copy | Download

Author Information

Ahmed Buseri Ashine

Department of Mathematics, Arsi University, Asella, Ethiopia

Contact Email

http://orcid.org/0000-0003-2634-3493
Mideksa Tola Jiru

Department of Mathematics, Arsi University, Asella, Ethiopia

Contact Email

http://orcid.org/0000-0003-0700-3864

Download PDF

Submit an Article

Sections

Plain Text BibTeX RIS

APA Style

Ashine, A. B., Jiru, M. T. (2026). Application of Linear Programming to Optimize Production and Profit (A Case Study of Oda Natural Spring Water Factory). International Journal of Theoretical and Applied Mathematics, 12(1), 13-23. https://doi.org/10.11648/j.ijtam.20261201.12

Copy | Download

ACS Style

Ashine, A. B.; Jiru, M. T. Application of Linear Programming to Optimize Production and Profit (A Case Study of Oda Natural Spring Water Factory). Int. J. Theor. Appl. Math. 2026, 12(1), 13-23. doi: 10.11648/j.ijtam.20261201.12

Copy | Download

AMA Style

Ashine AB, Jiru MT. Application of Linear Programming to Optimize Production and Profit (A Case Study of Oda Natural Spring Water Factory). Int J Theor Appl Math. 2026;12(1):13-23. doi: 10.11648/j.ijtam.20261201.12

Copy | Download

@article{10.11648/j.ijtam.20261201.12,
  author = {Ahmed Buseri Ashine and Mideksa Tola Jiru},
  title = {Application of Linear Programming to Optimize Production and Profit (A Case Study of Oda Natural Spring Water Factory)},
  journal = {International Journal of Theoretical and Applied Mathematics},
  volume = {12},
  number = {1},
  pages = {13-23},
  doi = {10.11648/j.ijtam.20261201.12},
  url = {https://doi.org/10.11648/j.ijtam.20261201.12},
  eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.ijtam.20261201.12},
  abstract = {This research focuses on optimizing production processes at Oda Natural Spring Water Factory in Ethiopia through the application of Linear Programming (LP). In the competitive bottled water industry, efficient resource management is crucial for profitability. Oda Natural Spring Water, known for its unique selenium-rich composition, faces challenges related to inefficient production practices and suboptimal resource allocation. This study develops a tailored LP model to determine the optimal daily production quantities for four bottled water sizes (35cl, 60cl, 100cl, and 200cl), with the objective of maximizing profit while adhering to constraints such as production time, cost budget, and market demand limits. Data collected over six months were analyzed using Excel Solver. The findings indicate that the factory can achieve a maximum daily profit of 150,143 Ethiopian Birr (ETB) by producing 1,100 packs of 35cl, 1,714 packs of 60cl, 1,441 packs of 100cl, and 976 packs of 200cl water. Sensitivity analysis reveals that the production cost constraint is binding, while significant production time remains unused. The study underscores LP as a practical decision-making tool in manufacturing, providing actionable strategies for improving resource allocation, reducing costs, and enhancing profitability. Recommendations include cost reduction initiatives and regular review of production plans in response to market dynamics.},
 year = {2026}
}

Copy | Download

TY  - JOUR
T1  - Application of Linear Programming to Optimize Production and Profit (A Case Study of Oda Natural Spring Water Factory)
AU  - Ahmed Buseri Ashine
AU  - Mideksa Tola Jiru
Y1  - 2026/01/31
PY  - 2026
N1  - https://doi.org/10.11648/j.ijtam.20261201.12
DO  - 10.11648/j.ijtam.20261201.12
T2  - International Journal of Theoretical and Applied Mathematics
JF  - International Journal of Theoretical and Applied Mathematics
JO  - International Journal of Theoretical and Applied Mathematics
SP  - 13
EP  - 23
PB  - Science Publishing Group
SN  - 2575-5080
UR  - https://doi.org/10.11648/j.ijtam.20261201.12
AB  - This research focuses on optimizing production processes at Oda Natural Spring Water Factory in Ethiopia through the application of Linear Programming (LP). In the competitive bottled water industry, efficient resource management is crucial for profitability. Oda Natural Spring Water, known for its unique selenium-rich composition, faces challenges related to inefficient production practices and suboptimal resource allocation. This study develops a tailored LP model to determine the optimal daily production quantities for four bottled water sizes (35cl, 60cl, 100cl, and 200cl), with the objective of maximizing profit while adhering to constraints such as production time, cost budget, and market demand limits. Data collected over six months were analyzed using Excel Solver. The findings indicate that the factory can achieve a maximum daily profit of 150,143 Ethiopian Birr (ETB) by producing 1,100 packs of 35cl, 1,714 packs of 60cl, 1,441 packs of 100cl, and 976 packs of 200cl water. Sensitivity analysis reveals that the production cost constraint is binding, while significant production time remains unused. The study underscores LP as a practical decision-making tool in manufacturing, providing actionable strategies for improving resource allocation, reducing costs, and enhancing profitability. Recommendations include cost reduction initiatives and regular review of production plans in response to market dynamics.
VL  - 12
IS  - 1
ER  -

Copy | Download