A relational database approach to a linear programming-based decision support system for production planning in secondary wood product manufacturing

Authors:
Ross R. Farrell;Thomas C. Maness
Affiliations:
WoodFlow Systems Corp., Burnaby, BC, Canada;Faculty of Forestry, University of British Columbia, Vancouver, BC, Canada
Venue:
Decision Support Systems
Year:
2005

Citing 6
Cited 2

An introduction to structured modeling

Management Science
Representation schemes for linear programming models

Management Science
Meta-modeling concepts and tools for model management: a systems approach

Management Science
Database structures for mathematical programming models

Decision Support Systems
Designing Relational Database Systems with Cdrom

Designing Relational Database Systems with Cdrom
A Relational Modeling System for Linear and Integer Programming

Operations Research

Identifying generic routings for product families based on text mining and tree matching

Decision Support Systems
Optimization Helps Shermag Gain Competitive Edge

Interfaces

Quantified Score

Hi-index	0.01

Visualization

Abstract

Secondary manufacturers in the forest products industry face a complex production planning process. Linear programming (LP)-based applications have addressed this production planning issue. However, most models have been developed for a specific plant configuration and cannot readily be applied to others. A relational database approach was used to create an integrated linear programming-based decision support system that can be used to analyze production planning issues in a wide variety of secondary wood product manufacturers. The flexibility of the resultant system indicated the potential to analyze production strategies in the highly dynamic environment characteristic of secondary manufacturers.