Page 102 -

82 CHAPTER 2 AN INTRODUCTION TO LINEAR PROGRAMMING

Figure 2.24 Excel Solution for the GulfGolf Problem

EXCEL file
GULFGOLF

Appendix 2.2 Solving Linear Programmes With the Management Scientist

In this appendix we describe how The Management Scientist software package can
be used to solve the GulfGolf linear programming problem. After starting The
Management Scientist, execute the following steps.
Step 1. Select the Linear Programming module
Step 2. Select the File menu
Choose New
Step 3. When the Problem Features dialogue box appears:
Enter 2 in the Number of Decision Variables box
Enter 4 in the Number of Constraints box
Select Maximize in the Optimization Type box
Click OK
Step 4. When the data input worksheet appears (see Figure 2.26):
Change Variable Names from X1 and X2 to S and D, respectively.
Enter the Objective Function Coefficients
For each constraint:
Enter the Coefficients
Enter the Relation (<, ¼, >)
Enter the Right-Hand-Side value
Step 5. Select the Solution menu
Choose Solve

Copyright 2014 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has
deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.