Smyth Window has an order for $4$ products $(101,202,303,404).$ The company can assemble any or all these window products in$-$house or outsource their production to a partner company. The number of units required for each product are provided in the Smyth Window worksheet along with the unit costs to assemble the products in$-$house or to buy the products from partner.

If Smyth assembles the products in$-$house, there are three stages in this process: pick, assemble, inspect. The amount of time required for each product type in each of the three stages is given in the worksheet. Each of these three stages has a limitation on the total time available for this order.

The goal for Smyth Window is to minimize the total cost of filling the order.

In setting up the linear program for optimization, a formula that would work in cell F$17,$ for the left$-$hand$-$side of the Assemble constraint is:

Group of answer choices

$=$sumproduct$($B$4$:E$4,$B$17$:E$17)$

$=$sumproduct$($B$9$:E$9,$B$17$:E$17)$

$=$sumproduct$($$B$$8$:$E$$8,$B$17$:E$17)$

$=$B$8*$B$17+$C$8*$C$17+$D$8*$D$17+$E$8*$E$17$

Exactly two answers are correct.

None of the answers are correct.