For finding the effect on the optimal solution there is need to add new parameters according to the required change s
Z_new=3.10X+3Y
But it can be noted that the rate at point 0 will be
Z_new |_0=0
Now at point A this value will become
Z_new |_A=1581
This value can be evaluated at the point B
Z_new |_B=2949
The new value can be evaluate at point C
Z_new |_C=3000
Now it can be noted that if the value of the profit changes from 3 OMR then according to that the optimal value of the system will be change and then according to that the value of X and Y will be changed and the maximum profit will become 3000 OMR at point C
4. Solve the linear programming model for Khadija Textile Mills by using the computer. Produce the solution and tell if Khadija Textile Mills can obtain additional cotton or processing time, but not both, which should it select? How much? Explain your answer.
Clothes items | Price of items | Costs of items | Profit rate |
Rough | 5 | 2.75 | 2.25 |
Smooth | 7.5 | 4.4 | 3.10 |
It will be maximize at the value of
Maximuze Z=2.25X+3.10 Y
It will be subjected to the following constraints
5X+7.5Y=6500
3X+3.2Y=3000
Max demand for rough Y=510
| | | | | | | | | |
| | Objective | | | | | | | |
| Cell | Name | Value | | | | | | |
| $B$13 | Profit x | 26900 | | | | | | |
| | | | | | | | | |
| | | | | | | | | |
| | Variable | | | Lower | Objective | | Upper | Objective |
| Cell | Name | Value | | Limit | Result | | Limit | Result |
| $B$11 | Rough x | 0 | | 0 | 26900 | | #N/A | #N/A |
| $B$12 | Smooth x | 0 | | 0 | 26900 | | #N/A | #N/A |
5. Identify the sensitivity ranges for the objective function coefficients and for the constraint quantity values. Then explain the sensitivity range for the demand for Smooth.
Variable Cells | | | | | |
| | | Final | Reduced | Objective | Allowable | Allowable |
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease |
| $B$11 | Rough x | 0 | 0 | 0 | 1E+30 | 0 |
| $B$12 | Smooth x | 0 | 0 | 0 | 1E+30 | 0 |
| | | | | | | |
Constraints | | | | | |
| | | Final | Shadow | Constraint | Allowable | Allowable |
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease |
| $E$4 | Budget Usage | 0 | 0 | 510 | 1E+30 | 510 |
| $E$5 | other group Usage | 0 | 0 | 3000 | 1E+30 | 3000 |
| $E$6 | same group Usage | 0 | 0 | 6500 | 1E+30 | 6500 |
| $E$7 | Demand Usage | 0 | 0 | 0 | 1E+30 | 0 |
| $E$8 | Usage | 0 | 0 | 0 | 1E+30 | 0 |