Question: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$3 Number to make P1 36.7142 0.0000 50.0000 11.5335 15.3129 $C$3
|
|
|
|
|
|
|
| |
Variable Cells |
| |||||||
|
|
| Final | Reduced | Objective | Allowable | Allowable |
|
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease |
|
| $B$3 | Number to make P1 | 36.7142 | 0.0000 | 50.0000 | 11.5335 | 15.3129 |
|
| $C$3 | Number to make P2 | 58.6371 | 0.0000 | 58.0000 | 13.2315 | 14.9192 |
|
| $D$3 | Number to make P3 | 0.0000 | -19.4686 | 46 | 19.4686 | 1E+30 |
|
| $E$3 | Number to make P4 | 63.5675 | 0.0000 | 62 | 1E+30 | 6.3795 |
|
|
|
|
|
|
|
|
|
|
Constraints | ||||||||
|
|
| Final | Shadow | Constraint | Allowable | Allowable |
|
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease |
|
| $F$11 | Labour Used | 3488.5543 | 0.0000 | 3600 | 1E+30 | 111.4457 |
|
| $F$12 | Machine hours Used | 1700.0000 | 2.6008 | 1700 | 61.4764 | 336.3636 |
|
| $F$13 | Management | -7.10543E-15 | 6.2907 | 0 | 20.1320 | 64.4643 |
|
| $F$7 | Cloth Used | 600.0000 | 7.9275 | 600 | 148.0000 | 70.9184 |
|
| $F$8 | Starch Used | 350.3346 | 0.0000 | 500 | 1E+30 | 149.6654 |
|
|
|
|
|
|
|
|
|
|
Use the sensitivity report to answer the following questions.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
