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.What formula should be entered in cell D3 to compute total profitability?

A) =SUMPRODUCT(B1:C1,B3:C3)
B) =SUM(B3:C3)
C) =B2*B3 + C2*C3
D) =SUMPRODUCT(B3:C3,E6:E8)
E) =B1*B3 + C1*C3