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

A company wants to build a new factory in either Atlanta or Columbia. It is 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$

$Xi=0,1$

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

A$.$

$=$SUMPRODUCT $($$B$$6$:$E$$6,$B$7$:E$7)$

B$.$

$=$SUMPRODUCT $($$B$$$6$:$E$$,$B$10$:E$10)$

C$.$

$=$ SUMPRODUCT $($$B$$6$:$E$$6,$B$11$:E$11)$

D$.$

$=$SUMPRODUCT $($$B$$14$:$E$$14,$B$7$:E$7)$