Scientific Journal of KubSAU

This article analyzes the best practices of choosing the optimal policy for replacement of vehicle fleet. The problem of replacement equipment was revealed. For each of these methods we gave objective function, constraints. We have found the best method of optimal plan of replacing the vehicle fleet in the company, allowing us to obtain accurate, economically viable new equipment purchase plan during a certain period. We have selected a number of important factors that influence the choice of payment method replacement policy and built PivotTable methods and factors. The selected as part of the research methodology will significantly reduce the labor and time, which will lead to an increase in productivity of the enterprise as a whole. The article gives a practical justification for the need to address the problem of choosing the optimal policy of replacing the vehicle fleet