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)

Question

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)

Quizplus · Accepted Answer

To compute the consumption of resource 3, which is represented by constraint #3, we need to multiply the resource usage rates (which are in row 2) by the decision variable values (which are in row 8) and then sum the results. Therefore, we should use the SUMPRODUCT function with range B2:C2 (resource usage rates) and range B8:C8 (decision variable values), which gives us the answer to constraint #3. Thus, choice C is correct.

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