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)

Question

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)

Quizplus · Accepted Answer

The Answer of 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)

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