me the answer report and sensitivity analysis to the pipe manufacturer's routing problems are provided below. answer Report Target Cell (Max) Cell Name $F$3 Total Profit= Original Value Final Value 0 3500 Adjustable Cells Cell Name $B$2 Value Routing 1 $C$2 Value Routing 2 Original Value Final Value 0 5 0 40 Constraints Cell Name $D$6 Melting Used $D$7 Extruder A Used $D$8 Extruder B Used $D$9 Raw Mat Used $B$2 Value Routing 1 $C$2 Value Routing 2 Cell Value Formula Status 45 $D$6=0 Not Binding 40 $C$2>=0 Not Binding Slack 0 75 0 15 5 40 Sensitivity Report Adjustable Cells Cell Name SBS2 Valve Routing 1 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 5 0 60 60 20 Sensitivity Report Adjustable Cells Cell Name $B$2 Value Routing 1 $C$2 Value Routing 2 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 5 0 60 20 60 40 0 80 1E+30 20 Constraints Cell Name $D$6 Melting Used $D$7 Extruder A Used $D$8 Extruder B Used $D$9 Raw Mat Used Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 45 60 45 3 5 15 0 90 1E+30 75 160 5 160 20 60 185 0 200 1E+30 15 What is the maximum total profit the pipe manufacturer can make given its current constraints? Round to the nearest dollar. Answer: Check How much should the plant manager be willing to pay for an extra hour of capacity at extruder A? Round to the closest dollar Answer: Check Suppose the profit per 100 feet of pipe produced on routing 1 increases to $70, would the plant manager want to change the routing scheme identified in the above solution report? Select one: a. No b. Yes Check If the plant manager can purchase an extra pound of raw material for $5 per pound. How many pounds of raw material should the plant manager purchase? Round you answer to the closest pound. Answer: Check