Use This Information to Answer the Following Questions -Refer to the Spreadsheet Above

Multiple Choice

Use this information to answer the following questions.
Consider the following product mix problem and its associated spreadsheet model.
$$\begin{array} { l l l } \operatorname { Max } & 3 \mathrm { X } _ { 1 } + 3 \mathrm { X } _ { 2 } & \\\text { Subject to: } & \\& 2 \mathrm { X } _ { 1 } + 3 \mathrm { X } _ { 2 } \leq 10 & \text { (constraint \#1) } \\& 3 \mathrm { X } _ { 1 } + 2 \mathrm { X } _ { 2 } \leq 20 & \text { (constraint \#2) } \\&\mathrm { X } _ { 1 } \geq 5 & \text { (constraint \#3) } \\&\mathrm { X } _ { 1 } , \mathrm { X } _ { 2 } \geq 0 & \text { (non-negativity) }\end{array}$$

-Refer to the spreadsheet above.Which equation should be entered in cell D8 to compute the consumption of resource 3 (i.e. ,constraint #3) ?

A) =SUMPRODUCT(B1:C1,B8:C8)
B) =SUMPRODUCT(B2:C2,B7:C7)
C) =SUMPRODUCT(B2:C2,B8:C8)
D) =SUMPRODUCT(D6:D8,E6:E8)
E) =SUMPRODUCT(B2:C2,E6:E8)