7 ca 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $E$5 values X1 500 0 49.5 19.5 1E+30 10 $F$5 values X2 200 0 69 1E+30 8.5 11 $G$5 values X3 1100 0 60.5 8.5 1E+30 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $H$12 Constraint4 LHS 1800 69 1800 800 200 17 $H$9 Constraint1 LHS 500 -19.5 500 200 500 18 $H$10 Constraint2 LHS 300 0 1500 1E+30 1200 19 SH$ 11 Constraint3 LHS 2200 4.25 2200 400 1600 20 21 4. The UWA local in Bakersfield, California, has proposed wage concessions at that plant to raise employment. What is the smallest decrease in the wage rate at that plant that would increase employment there? 5. (A) What is the cost of assembling 5 extra automobiles given the current output level of 1,800 automobiles? (B) Is it feasible to produce 2,100 automobiles? If possible, provide the new total cost, if not possible explain why not? 6. A team of production specialists has indicated that the auto manufacturer can achieve efficiencies at its Norwood plant by reconfiguring the assembly line. The reconfiguration has the effect of increasing the productivity of the labor at this plant from 1.1 hours to 0.8