Consider the following linear programming problem:

Max Z = 1.5A + 2.5B + 3C + 4.5D

s.t. 2A + 4B + 3C + 7D

3A + 2B + 3C + 4D

2A + 3B + 2C + 5D

A,B,C,D >= 0

The sensitivity report of the solved problem is as given below.

figure 3

Based on the linear programming model and its sensitivity report (Figure 3), what is the optimal objective function value?

Based on Figure 3, what is the allowable range of the objective coefficient for item B for which the current solution remains optimal?

Based on Figure 3, what will happen to profit if the quantity of the resource represented by constraint 2 is increased by 10000?

Based on figure 3, what happens to profit if the company must produce 2000 units of product A?

Based on Figure 3, what happens to profit if resource 2 (i.e. right hand side of constraint 2) is decreased by 6000 units and resource 3 is increased by 7000 units?

Microsoft Excel 16.0 Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 10/13/2020 10:08:15 PM Variable Cells Name . Reduced Cost -1.5 Cell $C$9 $D$9 $E$9 $F$9 Final Value 0 16008 5988 0 Objective Coefficient 1.5 2.5 3 4.5 Allowable Increase 1.5 2. 0.75 0.2 Allowable Decrease 1E+30 0.142857143 0.5 1E+30 B 0 0 C D -0.2 Constraints Shadow Price Cell $H$5 $H$6 $H$7 0 Final Value 81996 49980 60000 Name LHS LHS LHS Constraint R.H. Side 100020 49980 60000 Allowable Increase 1E+30 40020 14970 Allowable Decrease 18024 9980 26680 0.8 0.3