Page 130 -

110 CHAPTER 3 LINEAR PROGRAMMING: SENSITIVITY ANALYSIS AND INTERPRETATION OF SOLUTION

Figure 3.11 Excel Solution for the Modified GulfGolf Problem with the 30 per cent Deluxe Bag Requirement
Target Cell (Max)
Original
Name Value Final Value
Maximize Total Profit Standard 0 8183.87751
Adjustable Cells
Original
Name Value Final Value
Bags produced Standard 0 335.999328
Bags produced Deluxe 0 100.7997984
Bags produced Lightweight 0 304.8004704
Constraints

Name Cell Value Status Slack
Cutting and Dyeing 579.8397043 Not Binding 50.16029568
Hours Used (LHS)
Sewing Hours 556.7996304 Not Binding 43.2003696
Used (LHS)
Finishing Hours 708 Binding 0
Used (LHS)
Inspection and Packaging 135 Binding 0
Hours Used (LHS)
Minimum production 0 Binding 0
of Deluxe
Adjustable Cells
Final Reduced Objective Allowable Allowable
Name Value Cost Coefficient Increase Decrease
Bags produced 335.999328 0 10 2.070069301 3.705
Standard
Bags produced 100.7997984 0 9 1.150027 12.35
Deluxe
Bags produced 304.8004704 0 12.85 5.292857143 0.940932893
Lightweight
Constraints
Final Shadow Constraint Allowable Allowable
Name Value Price R.H. Side Increase Decrease
Cutting and Dyeing 579.8397043 0 630 1E+30 50.16029568
Hours Used (LHS)
Sewing Hours 556.7996304 0 600 1E+30 43.2003696
Used (LHS)
Finishing Hours 708 7.40998518 708 57.00045 168
Used (LHS)
Inspection and 135 21.76005928 135 12.00007333 31.75008604
Packaging Hours
Used (LHS)
Minimum production 0 –1.38002964 0 101.6770005 84
of Deluxe

nutritional values in units per kilo and the costs for the three feed components are
summarized in Table 3.1; for example, each kilo of the standard feed component
contains 0.8 units of ingredient A, 1 unit of ingredient B and 0.1 units of ingredient
C. The minimum daily diet requirements for each cow are three units of ingredient
A, six units of ingredient B and four units of ingredient C. In addition, to control the
weight of the cattle, the total daily feed for a cow should not exceed six kilos.
KCC would like to determine the minimum-cost mix that will satisfy the daily diet
requirements.

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.