Uman NUH | today: 10/17/2024
| Author(s) |
Grynchak O.V., , , Uman National University of Horticulture Marin B.M., , , Uman National University of Horticulture |
||
|---|---|---|---|
| Category | Economics | ||
| year | 2014 | issue | Issue #85 |
| pages | 213-218 | index UDK | 62-93:631.171:658.587 | DOI |
| Abstract | The problem of the optimal equipment replacement terms definition becomes very actual now when enterprises haven't enough of financial resources for the re-newing their machines parking. The applied information technology for solving this problem is built in the environment of spreadsheets processor Excel 2010. A total cost of tractors and machines exploitation function depends on equip-ment use term and includes four parameters: fixed and variable costs for machine or equipment maintenance, parameter of costs change in time and initial machine cost. Minimal costs point as well as a time of its reaching was arrived by equating of first derivate to zero. The results of the research of spreadsheets processor MS Excel functionalities in the solving of one typical task in tractors and agricultural machines using – definition of the efficient exploitation term of these machines and equipment – are presented. Information technology for automation of cost function values calculation, val-ues obtained visualization and searching for minimal cost function value built in Ex-cel environment is presented in the article. Searching cost function minimal value macro was developed on built-in pro-graming language VBA. Macro running associated with the pressing by user a button on the surface of the spreadsheet. The ways of further improvement of the created information technology are specified in the paper. The paper concludes that the Excel environment has a wide set of interface tools for modeling decision problems of tractors, agricultural machines and equipment re-placement as well as a number of other engineering tasks. | ||
| Key words | tractor, agricultural machine, equipment replacement, optimization, spreadsheets processor, Excel | ||