Download (PDF 54 KB): https://research.fs.usda.gov/download/treesearch/143.pdf
Abstract
Improved spreadsheet software capabilities have brought optimization to users with little or no background in mathematical programming. Better interface capabilities of spreadsheet models now make it possible to combine optimization models with a spreadsheet system. Sawmill production and inventory systems possess many features that make them suitable application environments for spreadsheet optimization. This paper describes a spreadsheet model that optimizes log allocation and lumber production.
Citation
Mendoza, Guillermo; Sprouse, William; Araman, Philip A.; Luppold, William G. 1991. CEASAW: A User-Friendly Computer Environment Analysis for the Sawmill Owner. Proceedings, 1991 Symposium on Systems Analysis in Forest Resources. pp. 173-179.