Question: Adjustable Cells Final Reduced Objective Allowable Allowable Name Value Cost Coefficient Increase Decrease #Units XJ 8 0 9 27 1E+30 #Units AM 10 0 12
| Adjustable Cells | |||||
| Final | Reduced | Objective | Allowable | Allowable | |
| Name | Value | Cost | Coefficient | Increase | Decrease |
| #Units XJ | 8 | 0 | 9 | 27 | 1E+30 |
| #Units AM | 10 | 0 | 12 | 1E+30 | 4.5 |
| #Units TR | 30 | 0 | 15 | 9 | 1E+30 |
| #Units BR | 40 | 0 | 11 | 25 | 1E+30 |
| Constraints | |||||
| Final | Shadow | Constraint | Allowable | Allowable | |
| Name | Value | Price | R.H. Side | Increase | Decrease |
| WiringHrsUsed | 1075 | 0 | 1500 | 1E+30 | 425 |
| DrillHrsUsed | 2350 | 12 | 2350 | 200 | 0 |
| AssemblyHrsUsed | 2600 | 5 | 2600 | 1E+30 | 800 |
| InspectHrsUsed | 525 | 0 | 1200 | 1E+30 | 675 |
a-Which constraint(s) are binding?(4pts)
b-What is the Maximum Profit?(4pts)
c- How much would you be willing to pay for one more hour of Wiring?(4pts)
d-How much would you be willing to pay for one more hour of Assembly?(4pts)
XtraCredit(8pts) If the profit for one AM was $8 (instead of $12), how many of each item would you make and what is the new Max profit?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
