PLEASE SOLVE EACH AND EVRY QUESTION

(120)5. The Ace Manufacturing Company produces two lines of its product, the super and the regular. Resource requirements for production are given in the Table below. There are 1,600 hours of assembly worker hours available per week, 700 hours of paint time, and 300 hours of inspection time. Regular customers will demand at least 150 units of regular line and 90 of the suner The linear programming formulation for this product mix problem is: Decision variables x1 = units of regular produced x2= units of super produced Formulation Maximize Z=50x1+75x2 s.t. 1.21+1.621600 Assembly time .81+.92700 Paint time .21+.22300 Inspection time x1150 Regular demand x2 x1,x20 90 Super demand Answer the following questions on this page and the next page referring to the above formulation and the printout on the page following the questions a. What is the optimal solution (complete answer!)? b. If demand for regular increased by 10 , what will happen to the optimal solution ( Z and decision variables)? c. If demand for super increased by 10 , what will happen to the optimal solution ( Z and decision variables)? d. If the profit contribution of regular decreased to 30 , what will happen to the optimal solution ( Z and decision variables)? e. If the profit contribution of super decreased to 55 , what will happen to the optimal solution ( Z and decision variables)? Adjustable Cells \begin{tabular}{lccrrrr} \hline Cell & Name & FinalValue & ReducedCost & ObjectiveCoefficient & AllowableIncrease & AllowableDecrease \\ \hline$B14 Regular & 150 & & 0 & 50 & 16.66666667 & 1E+30 \\ $C$14 Super & 644.4444444 & & 0 & 75 & 1E+30 & 18.75 \\ \hline \end{tabular} Constraints \begin{tabular}{lcrrrrrr} \hline Cell & Name & FinalValue & ShadowPrice & ConstraintR.H.Side & AllowableIncrease & AllowableDecrease \\ \hline \$D\$10 Regular demand LHS & 150 & -16.66666667 & 150 & 623.75 & 150 \\ \hline \$D\$11 Super demand LHS & 644.4444444 & 0 & 90 & 554.4444444 & 1E+30 \\ \hline \$D\$7 & Assembly LHS & 1211.111111 & 0 & 1600 & 1E+30 & 388.8888889 \\ \$D\$8 & Paint LHS & 700 & 83.33333333 & 700 & 218.75 & 499 \\ \hline \$D\$9 & and Packaging LHS & 158.8888889 & 0 & 300 & 1E+30 & 141.1111111 \\ \hline \end{tabular}