The decision support systems commonly used in industry and economy managerial practice for optimizing the processes are based on algoritmization of the typical decision problems. In Czech forestry business, there is a lack of developed decision support systems, which could be easily used in daily practice. This stems from the fact, that the application of optimization methods is less successful in forestry decision making than in industry or economy due to inherent complexity of the forestry decision problems. There is worldwide ongoing research on optimization models applicable in forestry decision making, but the results are not globally applicable and moreover the cost of possibly arising software tools are indispensable. Especially small and medium forestry companies in Czech Republic can not afford such additional costs, although the results of optimization could positively influence not only the business itself but also the impact of forestry business on the environment. Hence there is a need for user friendly optimization models for forestry decision making in the area of Czech Republic, which could be easily solved in commonly available software, and whose results would be both, realistic and easily applicable in the daily decision making.The aim of this paper is to develop the optimization model for the machinery use planning in Czech logging firm in such a way, that the results can be obtained using MS EXCEL. The goal is to identify the integer number of particular machines which should be outsourced for the next period, when the total cost minimization is required. The linear programming model is designed covering the typical restrictions on available machinery and total volume of trees to be cut and transported. The model offers additional result in the form of optimal employment of particular machines. The solution procedure is described in detail and the results obtained are discussed with respect to its applicability in practical forestry decision making. The possibility of extension of suggested model by including additional requirements is mentioned and the example for the wood manipulation requirement is shown.
The optimization model of the logging machinery usage in forestry practice
