Cell $B$7 $C$7 Name Regular = Super = Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 130 0.00 80 1E+30 10.77 0 14.00 90 14 1E+30 Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$3 Wiring (hr/unit) 260 40 260 115 $E$4 Welding (hr/unit) 416 0 1E+30 184 $E$5 Inspection (hr/unit) 390 0 600 1E+30 260 600 210 Answer the following questions from sensitivity output of Excel Solver of an LP problem shown above: D) The total profit is $ 1040 i) If a super product is brought into the solution mix the profit will be reduced by $ ! ) If the company wanted to increase the available hours for one of their constraints by two hours, they should increase iv) The profit on the super product could increase by $ without affecting the product mix. V) If downtime reduced the available capacity for welding by 40 hours, the profit would be reduced by $ Activate Windows vi) A change in the market has increased the profit on the super product by $5. Total profit will increase by 5 activate Window