Question $4$ to Question $6$ is based on this problem:

Question $5$

A company wants to build a new factory in either Atianta or Columbla. it is also considerine 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 tacilities, but it conly has $$15$ million

to imvest.

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

MAX:

Subject $31+42+23+4$

$10$: $101+82+63+5415$

$x_1+x_2-1x_3+x_{4}1$

$x_3+x_{4}1x_3-x_{1}0$

$x_4-x_{2}0$

$-0,1$

Which of the following expressions should go in Cell F$6$ of the above spreadhect?

~~ A$.$

O$.B$

$-$SUMPRODUCTSBQSSESG,B$1$OE$10$

$oc$

$-$SUMPRODUCT$($$RS$65556.$n$11-$F$11)$

o a

$-5$UMPRODUCT$(5$B$$14$;$E$514,97$:E$7)$