Figure 1 A B 0 D E F B 4 3 0 LHS 0 = 1 2 3 Variables 4 Profit 4 5 6 constraint 1 3 7 constraint 2 12 8 constraint 3 1 9 10 11 Maximum profit : 4A+3B 12 13 Subject to: 3A+4B = 15 16 A,B >= 0 Figure 1 demonstrates an Excel spreadsheet that is used to model the following linear programming model, where cells B3 and C3 are the designated cells for optimum values of A and B respectively, while cell D4 is the designated cell of the objective function value. Cells D6:D8 designate the left-hand side of the constraints. Answer the next two questions (i.e. 9-10) by using Figure 1 and the model. Refer to Figure 1. What formula should be entered in cell D4 to comp total profitability? Refer to Figure 1. What formula should be entered in cell D4 to compute total profitability? O =SUMPRODUCT(B5:C5,E5:E7) O ESUMPRODUCT(B3:C3, D5:D7) O ESUMPRODUCT(B5:B7, C5:07) =SUMPRODUCT(B5:C5,B3:03) =SUMPRODUCT(B3:C3,B4:C4) Question 10 5 pts Refer to Figure 1. What formula should be entered in cell D6 to compute the amount of resource 1 that is consumed? O ESUMPRODUCT(B3:C3,E5:E6) =SUMPRODUCT(B3:C3,B9:09) =SUMPRODUCT(B3:C3,B6:06) O ESUMPRODUCT(B9:C9,17:07) =SUMPRODUCT(B9:C9,B5:C5) Question 11 10 pts Consider the following linear programming problem along with its graphical representation (Figure 2) shown below to answer the next four questions (i.e. 11-12-13-14). Figure 2 s.t. Max Z= 20W + 25C 10W + 13C >= 100 12W + 110 = 0 16) 12 8 4 0 1 1 12 1 16 0 8 W What is the color of the line for W>=5 LK 1 1 4 12 16 w What is the color of the line for W>=5 O green O blue O none of them O red Question 12 10 pts What is the color of the line for 10W+13C >= 100 O blue O red O none of them O green