A Company Is Developing Its Weekly Production Plan What Is the Appropriate Formula to Use in Cell E8

Multiple Choice

A company is developing its weekly production plan.The company produces two products,A and B,which are processed in two departments.Setting up each batch of A requires $60 of labor while setting up a batch of B costs $80.Each unit of A generates a profit of $17 while a unit of B earns a profit of $21.The company can sell all the units it produces.The data for the problem are summarized below.
Hours required by
$$\begin{array} { r c c c } \text { Operation } & \text { A } & \text { B } & \text { Hours } \\\hline \text { Cutting } & 3 & 4 & 48 \\\text { Welding } & 2 & 1 & 36\end{array}$$
What is the appropriate formula to use in cell E8 of the following Excel implementation of the ILP model for this problem?

A) =SUMPRODUCTB5:C5,B7:C7) ? SUMPRODUCTB8:C8,B14:C14)
B) =SUMPRODUCTB8:C8,B14:C14) ? SUMPRODUCTB5:C5,B7:C7)
C) =SUMPRODUCTB5:C5,B7:C7) ? B8:C8
D) =SUMPRODUCTB5:C5,B7:C7) ? SUMPRODUCTB8:C8,B15:C15)