Solved

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

Question 3

Multiple Choice

Use this information to answer the following questions.
Consider the following product mix problem and its associated spreadsheet model.
Max3X1+3X2 Subject to: 2X1+3X210 (constraint #1)  3X1+2X220 (constraint #2)  X15 (constraint #3)  X1,X20 (non-negativity)  \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 cell(s) designates the objective function as specified in  Solver ? A) E4 B) D3 C) D2 D) B1:C1 E) B2:C2
-Refer to the spreadsheet above.Which cell(s) designates the objective function as specified in "Solver"?


A) E4
B) D3
C) D2
D) B1:C1
E) B2:C2

Correct Answer:

verifed

Verified

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents