IMPLEMENTATION OF A MULTI-PERIOD PRODUCTION SIMPLIFICATION MODEL IN MS EXCEL USING SOLVER
pdf (Georgian)

How to Cite

Vartaniani, N., Donadze, G., & Devadze, D. (2025). IMPLEMENTATION OF A MULTI-PERIOD PRODUCTION SIMPLIFICATION MODEL IN MS EXCEL USING SOLVER . Transactions of the Adjara Autonomous Republic Regional Scientific Centre of the Georgian National Academy of Sciences, 11, 14-20. https://doi.org/10.52340/tgsa.2025.11.02

Abstract

The article discusses how linear programming can be used as a powerful mathematical tool for decision-making to achieve optimal results under limited resources. In general, the linear programming process involves optimizing an objective function (minimizing costs or maximizing profits) within linear constraints. The purpose of the paper is to show how companies can determine the most efficient way to use their resources (workforce, fuel, time), thereby achieving significant financial and operational savings.

To solve the problem, a linear programming model is employed, implemented through the Solver function in MS Excel. According to the optimal solution obtained by Solver, it is confirmed that the LP linear programming model can determine the optimal allocation of resources to achieve minimal operating cost.

pdf (Georgian)

References

H. A. Taha, Operations Research: An Introduction, 10th ed., Pearson Education Limited, 2017.

F. S. Hillier and G. J. Lieberman, Introduction to Operations Research, 10th ed., McGraw-Hill Education, 2015.

W. L. Winston, Operations Research: Applications and Algorithms, 4th ed., Cengage Learning, 2014.

W. L. Winston and S. C. Albright, Practical Management Science, 5th ed., Cengage Learning, 2019.

R. L. Rardin, Optimization in Operations Research, 2nd ed., Pearson Education, 2014.

S. Chopra and P. Meindl, Supply Chain Management: Strategy, Planning, and Operation, 7th ed., Pearson, 2019.