If the objective function for x2 was to decrease from $30 to $25, what would the new total Z amount be for the day?

Consider the following linear programming model Max Z= 40x4 + 30x, subject to. Constraint A 10x1 +5X2 5500 Constraint B 4X1 +372 5300 Constraint c X: + 2x2 s 200 Constraint D 3x1 + 5x2 300 X1, X2 20 Use the following Excel sensitivity report to answer the following questions. Show all the details of your answer. Variable Cells Cell Name SA$8 $B$8 Final Value 28.57 42.86 Reduced Objective Cost Coefficient 0 40 0 30 Allowable Increase 20.00 36.67 Allowable Decrease 22 10 Constraints Final Value Constraint R.H. Side 500 500 Cell Name $C$3 $C$4 $C$5 $C$6 Shadow Price 3.14 0.00 0.00 2.86 Allowable Increase 181.82 1E+30 1E+30 200 Allowable Decrease 200 57.14 85.71 242.86 114.29 300 300 200 300 150