Use this information, along with its associated Sensitivity Report. Study the report carefully and tell me what about the profitable production for the company. Then discuss the constraints. You will use this report to answer the following questions. 14. A production manager wants to determine how many units of each product to produce weekly to maximize weekly profits. Production requirements for the products are shown in the following table. Material 1 (lbs.). Material 2 (lbs.). Product Labor (hours) A 3 2 4 B 1 4 2 5 none 3.5 Material 1 costs $7 a pound, material 2 costs $5 a pound, and labor costs $15 per hour. Product A sells for $101 a unit, product B sells for $67 a unit, and product C sells for $97.50 a unit. Each week there are 300 pounds of material 1; 400 pounds of material 2; and 200 hours of labor. The output of product A should not be more than one-half of the total number of units produced. Moreover, there is a standing order of 10 units of product C each week. Formulation Max 10A + 10B + 10C Subject to: 3A + B + 5C 10 (constraint #4) A, B, C70 Can you please set this up in Solver and tell me what the optimal values for A, B, and C are? What is the Objective function? Sensitivity Report Adjustable Cells Final Cell $B$4 $C$4 $D$4 Name Optimal Values: A Optimal Values: B Optimal Values: C Value 0 82.5 10 Reduced Cost -10 0 Objective Coefficient 10 10 10 Allowable Allowable Increase Decrease 10 1E+30 1E+30 4.285 7.5 1E+30 0 Constraints Cell Name $E$7 Constraint 1 $E$8 Constraint 2 $E$9 Constraint 3 $E$10 Constraint 4 Final Value 132.5 330 200 10 Shadow Price 0 0 5 -7.5 Constraint R.H.S. Side 300 400 200 10 Allowable Allowable Increase Decrease 1E+30 167.5 1E+30 70 35 165 47.142 10 15) Which constraints are binding? O A) 1 and 2 B) 1 and 4 ) O C) 2 and 3 O D) 3 and 4 16) What is the optimal objective function value? O A) 925 O B) 825 O C) 100 OD D) 92.5 17) By how much would the profit contribution of product A has to increase before it will be profitable to produce A? O A) $20 O B) $0 O C) $1E+30 O D) $10 18) Suppose that we force the production of one unit of product A. The new objective function value will be O A) $925 O B) $915 O C) $935 D) $900 19) Suppose that the production manager has an additional 100 pounds of material 1. What impact will this have on the current optimal objective function value? O A) no change O B) a decrease of $100 O C) an increase of $100 OD) an increase of $200 20) Suppose that the production manager procures an additional 10 labor hours. What impact will this have on the current optimal objective function valu O A) an increase of $50 O B) an increase of $5 O C) no change O D) an increase of $35