Synergies from spreadsheet linear programming used with the theory of constraints – a case study

Synergies from spreadsheet linear programming used with the theory of constraints – a case study

0.00 Avg rating0 Votes
Article ID: iaor19992618
Country: United Kingdom
Volume: 49
Issue: 9
Start Page Number: 918
End Page Number: 927
Publication Date: Sep 1998
Journal: Journal of the Operational Research Society
Authors: ,
Keywords: production, agriculture & food, spreadsheets
Abstract:

This paper describes a case study relating to a food-processing plant. The methods used to address the case include spreadsheets combined with Goldratt's Theory of Constraints (TOC), both of which are accessible to practising managers. The paper demonstrates how standard spreadsheet optimisation tools can be used in combination with a TOC framework to provide effective decision aids. The results from the case study indicate real productivity improvements are possible from even small models of a situation. The paper explores the interrelationships and complementaries between Linear Programming and Theory of Constraints frameworks, and details the steps involved in using them in combination. We argue that traditional LP practice should be modified in light of the ease with which LPs can be solved, and suggest that the Theory of Constraints approach provides a useful framework to guide LP use. We share some of the insights gained both by the analysts and by the company.

Reviews

Required fields are marked *. Your email address will not be published.