Question $28to$ Question $30is$ based $on$ this problem:

A company wants $to$ build a new factory $in$ either Atlanta $or$ Columbia. $Itis$ also considering building a warehouse $in$ whichever city $is$ selected for the new factory. The following table shows the net present value $(NPV)$ and cost $of$ each facility. The company wants $to$ maximize the net present value $of$ its facilities, but $it$ only has $$15$ million $to$ invest.

The ILP formulation $of$ the problem and its spreadsheet implementation are $as$ follows:

MAX: $3X1+4X2+2X3+X4$

Subject $to$: $10X1+8X2+6X3+5X415$

$X1+X2=1$

$X3+X41$

$X3-X10$

$X4-X20$

$Xi=0,1$

Which $of$ the following expressions should $goin$ Cell $F6of$ the above spreadsheet?

Group $of$ answer choices

$=$SUMPRODUCT$($$$B$$$14$:$$E$$$14,B7$:$E7)$

$=$SUMPRODUCT$($$$B$$$6$:$$E$$$6,B11$:$E11)$

$=$SUMPRODUCT$($$$B$$$6$:$$E$$$6,B7$:$E7)$

$=$SUMPRODUCT$($$$B$$$6$:$$E$$$6,B10$:$E10)$

Question $29$

Which $of$ the following expressions should $goin$ Cell $F13of$ the above spreadsheet?

Group $of$ answer choices

$=$SUMPRODUCT$($$$B$$$7$:$$E$$$7,B13$:$E13)$

$=$SUMPRODUCT$($$$B$$$6$:$$E$$$6,B13$:$E13)$

$=$SUMPRODUCT$($$$B$$$13$:$$E$$$13,B10$:$E10)$

$=$SUMPRODUCT$($$$B$$$10$:$$E$$$10,B13$:$E13)$

None $of$ the above expressions

Question $30$

Which $of$ the following statements $is$ not true for the optimal solution $of$ the problem?

Group $of$ answer choices

$X2=1$

$X3=0$

$X4=1$

$X1=1$

Question $28$

Question $28to$ Question $30is$ based $on$ this problem:

A company wants $to$ build a new factory $in$ either Atlanta $or$ Columbia. $Itis$ also considering building

a warehouse $in$ whichever city $is$ selected for the new factory. The following table shows the net

present value $(NPV)$ and cost $of$ each facility. The company wants $to$ maximize the net present value

$of$ its facilities, but $it$ only has $$15$ million $to$ invest.

The ILP formulation $of$ the problem and its spreadsheet implementation are $as$ follows:

MAX: $31+42+23+x4$

Subject $to$: $101+82+63+5415$

$,x1+x2=1$

$,x3+x41$

$,x3-x10$

$,x4-x20$

$,=0,1$

Which $of$ the following expressions should $goin$ Cell $F6of$ the above spreadsheet?

$-$SUMPRODUCT$($$$B$$$14-$$$E$$$14,B7$:$E7)$

$-$SUMPRODUCT$($$$B$$$6.$$$E$$$6,B11$:$E11)$

$-$SUMPRODUCT$($$$B$$$6.$$$E$$$6,B7$:$E7)$

$-$SUMPRODUCT$($$$B$$$6.$$$E$$$6,B10$:$E10)$ Question $29$

Which $of$ the following expressions should $goin$ Cell $F13of$ the above spreadsheet?

$-$SUMPRODUCT$($$$B$$$7-$$$E$$$7,B13$:$E13)$

$-S$