help with the 3 following questions please:
Questions Search Insert Draw Design Layout References Mailings Review View Help 1) A company can decide how many additional labor hours to acquire for a given week. Subcontractor workers will only work a maximum of 20 hours a week. The company must produce at least 200 units of product A, 300 units of product B, and 400 units of product C. In 1 hour of work, worker 1 can produce 15 units of product A, 10 units of product B, and 30 units of product C. Worker 2 can produce 5 units of product A, 20 units of product B, and 35 units of product C. Worker 3 can produce 20 units of product A, 15 units of product B, and 25 units of product C. Worker 1 demands a salary of $50/hr, worker 2 demands a salary of $40/hr, and worker 3 demands a salary of $45/hr. The company must choose how many hours they should contract with each worker to meet their production requirements and minimize labor cost. (a) Formulate this as a linear programming problem. (b) Find the optimal solution. 2) Consider the sensitivity report below: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 R 15 8 10 $D$4 W 12.5 0 12 4 6.667 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SE$6 Corn 40 40 3.6 16.667 SE$7 Sugar 70 70 18 30 SE$8 Jugs 27.5 0 50 1E+30 22.5 $E$9 Hours 67.5 72 1E+30 4.5 (a) Which constraints are binding? (b) Which constraints are non-binding? (c) What is the increase in the objective value if 3 Com are added? 3) Consider the sensitivity report below: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 Cabinet X 8 0 1 $D$4 Cabinet Y 3 0 12 4 1.333333333 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$6 Floor 72 72 9.333333333 16 SE$7 Budget 140 0.2 140 40 20 SE$8 Coffee 3 40 1E+30 (a) Which constraints are binding? (b) Which constraints are non-binding? c) What is the increase in the objective value if 3 Coffee are added