A microcomputer-based decision support system for the management of lumber mill production

Production management for a lumber mill includes the choice of saw patterns, as well as drying, sorting, grading and materials handling operations. The decision support system developed for an existing mill includes a linear programming (LP) model, data base software and a spreadsheet aid for detailed production scheduling. The LP model was structured to minimize total production cost subject to constraints on the available supply of raw material, the required output of timber, the available saw patterns and capacities on production facilities and materials handling operations. The LP solution is used by the spreadsheet support program to schedule product flow on a daily basis. The system was implemented on a microcomputer.