You are given the following linear programming model and Excel spreadsheet to solve this problem: MAX: 25 X1 + 35 X2 Subject to: Constraint 1: 6 X1 + 4 X2 = 0 X1 X2 Number to make: Unit profit: Objective 25 35 10 Constraints: Constraint 1 Constraint 2 Constraint 3 LHS RHS 1500 2700 800 What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute Objective function value?

You are given the following linear programming model and Excel spreadsheet to solve this problem: 25 X1 + 35 X2 MAX: Subject to: Constraint 1: 6 X1 + 4 X2 = 0 A B C D E 1 X1 X2 Number to 0 0 Objective make: Unit profit: 25 35 7 Constraints: LHS RHS 8 Constraint 1 6 1500 9 Constraint 2 4 2700 10 Constraint 3 800 What formula should be entered in cell E5 in the accompanying Excel spreadsheet to compute Objective function value? =B4*B5+C4*C5 =SUMPRODUCT(B8:C8,$B$4:$C$4) =SUM(B5:C5) =SUM(E8:E10) -~~+ 56 481