Acta Univ. Agric. Silvic. Mendelianae Brun. 2015, 63, 217-225

https://doi.org/10.11118/actaun201563010217
Published online 2015-03-14

Supply Chain Planning for a Timber Harvesting Plus Sale Tender

Josef Holoubek, Martina Lindnerová, Jitka Janová

Department of Statistics and Operational Research, Mendel University in Brno, Zemědělská 1, 613 00 Brno, Czech Republic

Since 2010, the Czech State Forest Enterprise has been inviting timber-harvesting tenders while insisting on the forestry company purchasing the timber from the felled trees as well. To win, a tender must offer the greatest difference between the price of the timber purchased and the cost of the operations. Thus, the forest companies are now facing new problem: apart from minimizing the logging costs they are searching for a cross-cutting and mill-distribution strategy that maximizes the selling price of the harvested timber.
The optimization model devised by the present paper provides support for finding an optimal timber selling strategy and, as an important contribution, include a detailed plan for cross-cutting the logs and assign them to the particular customers. We keep the support accessible via common office software and the cross-cutting and customer-assigning problem is formulated as a linear programming model for EXCEL, a particular real-world problem is solved and, using expert comparison, the model appears to provide very good results.

Funding

The research is partially supported by the Czech Science Foundation grant nr. GA13-25897S. We acknowledge the helpful consultation with Jiri Kadlec. Appendix: Optimisation problem as solved by an expert without any quantitative support. Note that the expert only knew about the structure of trees in the forest in question, that is, about their distribution into age rather than tree-volume classes as with the optimisation model. For the timber volume in each tree-volume class, the expert carried out assignments to individual customers. In the tables, then, the total costs are calculated of transport and logging, yields on customer sales as well as the total profit for timber of each age class.

References

17 live references