Examlex

Solved

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

question 33

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


Definitions:

NLRA Deregulation

The process of reducing or eliminating government rules governing the National Labor Relations Act, potentially affecting labor relations and practices.

Antitrust Regulations

Laws and policies designed to prevent anti-competitive practices, monopoly, and to promote fair competition for the benefit of consumers.

Stakeholder Model

A theory of organizational management and ethics focusing on the needs and interests of all stakeholders, including employees, customers, and the community.

Adversarial Model

A model of dispute resolution, commonly found in legal contexts, where two or more parties with opposing interests present their argument before a neutral party, such as a judge or arbitrator.

Related Questions