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}

$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)$
-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)

In a Multi-Period Production Scheduling Application,the Objective Function Is To

Multiple Choice

Correct Answer:VerifiedUnlock this answer nowGet Access to more Verified Answers free of chargeAccess For Free

Correct Answer:
Verified
Unlock this answer now
Get Access to more Verified Answers free of charge