Abstract Firms can benefit by developing and using aggregate production plans. However, reports of ongoing production planning applications are rare. The complexity of production planning models has been cited as one of the reasons that firms do not develop formal production plans. This study was conducted to determine if a simple model, trial-and-error on a spreadsheet, could be used to produce cost-effective production planning solutions. Results indicate that good solutions can be obtained using this method. Furthermore, solutions tend to improve as the knowledge of the production planner increases and as time spent developing solutions increases. In addition, experience at producing spreadsheet-based solutions can translate into lower cost solutions for more complex problems while using less time for analysis. These findings indicate that spreadsheets can be effective decision aids for developing production planning solutions. By coupling the power and simplicity of a spreadsheet modelling package wit...
[1]
Steven C. Ross,et al.
Developing and using decision support applications
,
1987
.
[2]
James R. Evans.
Spreadsheets and optimization: Complementary tools for decision making
,
1986
.
[3]
Eddie Anderson,et al.
Operations Management—Strategy and Analysis
,
1987
.
[4]
Roy J. Clinton,et al.
Interactive Optimization Aspects of Electronic Spreadsheet Models for Design and Planning
,
1991
.
[5]
Jack A. Holt,et al.
A heuristic method for aggregate planning: Production decision framework
,
1981
.
[6]
Jack A. Holt.
PDF versus LP: An empirical aggregate planning comparison
,
1983
.
[7]
C. C. Holt,et al.
Planning Production, Inventories, and Work Force.
,
1962
.
[8]
Roger G. Schroeder,et al.
Operations Management: Decision Making in the Operations Function
,
1981
.