Abstract

One of the tasks of dynamic programming is to talk about replacing hardware. One of the urgent tasks is to solve the problem of proper operation of the equipment and its timely replacement with new equipment. There are two ways to solve such problems. In the first, we look at ensuring that the cost of operating the equipment is minimal, and in the second, we look at ensuring that the profit from operating the equipment is maximum. Our article is devoted to the search for maximum profit. An effective way to solve the problem was chosen

Keywords

dynamic programming, hardware replacement, MS Excel, task, profit, optimal strategy

References

  1. Afanasiev, M.Yu., & Suvorov, B.P. (2003). Operations research in economics: Models, problems, solutions: Textbook for economic universities. Moscow: INFRA-M.

  2. Ashirbaeva, A.Zh., Abdimanap kyzy, N., & Abdualim kyzy, A. (2024). Using network graphs for planning course paper writing. Bulletin of Osh Technological University, 1, 102-106.

  3. Ashirbaeva, A.Zh., & Kushbak, K.G. (2017). The using of MS Excel in construction models in interbranch balance. Bulletin of Osh State University, 1, 100-105.

  4. Venttsel, E.S. (2006). Operations research: Problems, principles, methodology: Textbook for universities (4th ed.). Moscow: Drofa.

  5. Zhusupbaev, A., Mamatkadyrova, G.T., & Ashirbaeva, A.Zh. (2008). Methods and models of operations research in economics: Textbook. Bishkek.

  6. Kremer, N.Sh. (Ed.). (1997). Operations research in economics: Textbook for universities. Moscow: UNITI.

  7. Kholod, N.I., et al. (2000). Economic-mathematical methods and models: Textbook for universities (2nd ed.). Minsk: BSEU.

  8. Ashyrbaeva, A.J., & Abdakimova, G.K. (2016). Using the method of the dynamic programming. Bulletin of Osh Technological University, 1, 103-107.

Suggested citation

Saparova, S., Beksarieva, J., & Abdimalikova, A. (2025). USING MS EXCEL FUNCTIONS TO SOLVE THE PROBLEM OF EQUIPMENT REPLACEMENT. News of Osh Technological University, 25(1), 174-179.