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

question 83

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)

---

Definitions:

Diuretic

A medication or substance that promotes the production of urine by the kidneys, helping to remove excess water and salt from the body.

Cardiac Catheterization

A medical procedure used to diagnose and treat some cardiovascular conditions by inserting a catheter into a chamber or vessel of the heart.

Cardiac Arrhythmia

An abnormal heart rhythm that can include conditions where the heartbeat is too slow, too fast, or irregular.

Hypostatic Pneumonia

A type of pneumonia that occurs from prolonged immobility, leading to the pooling and congestion of secretions in the lungs.