A spreadsheet-based decision support system for wood panel manufacturing

摘要

Wood paneling manufacturers face a number of complex decisions when trying to allocate production resources and combine various raw materials to meet production goals. While various linear programming formulations for this problem have been proposed, these models are often difficult to use and maintain for real-time decision making in a dynamic shop floor environment. This paper describes an MS Excel-based decision support system for wood panel manufacturing. The system is easy to use and maintain yet gives shop floor personnel access to powerful optimization capabilities useful for fine-tuning production processes in the face of changing supply and price situations.