About an implementation of the method of dynamic programming to solve the problem of equipment replacement with an application program

With the development of information technologies, the fields of knowledge related to applied informatics are of great importance. The tools and methods of this science allow users of the computer technology to create software products for solving individual problems. Despite the abundance of special software packages that use mathematical methods to find solutions, there is often a need to create your own software. The article describes the process of creating an application program for solving the problem of replacing equipment by the method of dynamic programming. The task is to find the optimal strategy when deciding to stop using old equipment and acquire the new one. It is proposed to automate calculations that arise when implementing a solution to this problem with the help of a program created in the VBA (Visual Basic for Applications) programming environment.