ScienceDirect® Home Skip Main Navigation Links
You have guest access to ScienceDirect. Find out more.
 
Home
Browse
My Settings
Alerts
Help
 Quick Search
 Search tips (Opens new window)
    Clear all fields    
advertisementadvertisement
Decision Support Systems
Volume 40, Issue 2, August 2005, Pages 183-196
 
Font Size: Decrease Font Size  Increase Font Size
 Abstract - selected
Article
Purchase PDF (393 K)

 
 
 
Related Articles in ScienceDirect
View More Related Articles
 
View Record in Scopus
 
doi:10.1016/j.dss.2004.02.001    How to Cite or Link Using DOI (Opens New Window)
Copyright © 2004 Elsevier B.V. All rights reserved.

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

Ross R. FarrellCorresponding Author Contact Information, a, Corresponding Author Contact Information, E-mail The Corresponding Author and Thomas C. ManessE-mail The Corresponding Author, b

a WoodFlow Systems Corp., Burnaby, BC, Canada V5A 1R2 b Faculty of Forestry, University of British Columbia, 2424 Main Mall, Vancouver, BC, Canada V6T 1Z4

Received 5 September 2003; 
Revised 5 September 2003; 
accepted 3 February 2004. 
Available online 30 April 2004.

Purchase the full-text article



References and further reading may be available for this article. To view references and further reading you must purchase this article.

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.

Author Keywords: Decision support system; Linear programming; Flexibility; Relational database; Production planning; Secondary wood product manufacturing

Article Outline

1. Introduction
2. DSS structure
2.1. Relational database
2.1.1. Generic machine centers
2.1.2. Machine costs
2.1.3. Lumber definition
2.1.4. Market demand
2.1.5. Units
2.2. User interface—data entry/manipulation
2.3. Model formulation
2.3.1. Objective function
2.3.2. Raw material constraints
2.3.3. Material balance constraints
2.3.4. Recovery constraints
2.3.5. Machine capacity constraints
2.3.6. Marketing constraints
2.4. Definitions
2.4.1. Subscripts
2.4.2. Variables
2.4.3. Cost coefficients
2.4.4. Other coefficients
2.5. Constraints
2.5.1. Raw material constraints
2.5.2. Material balance constraints
2.5.3. Recovery constraints
2.5.4. Machine capacity constraints
2.5.5. Marketing constraints
2.6. Matrix generation
2.7. XAEZ (model instantiation)
2.8. XA (solving the model)
2.9. User interface—reports
3. Conclusion
Acknowledgements
References
Vitae





Decision Support Systems
Volume 40, Issue 2, August 2005, Pages 183-196
 
Home
Browse
My Settings
Alerts
Help
Elsevier.com (Opens new window)
About ScienceDirect  |  Contact Us  |  Information for Advertisers  |  Terms & Conditions  |  Privacy Policy
Copyright © 2008 Elsevier B.V. All rights reserved. ScienceDirect® is a registered trademark of Elsevier B.V.