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:

Axon Terminals

The distal terminations of the branches of an axon, responsible for releasing neurotransmitters to transmit signals to other neurons or muscles.

Nerve Impulse Conduction

The process by which nerve cells (neurons) transmit electrical signals along their axons to communicate with other neurons or muscles.

Myelin Sheath

A fatty layer that surrounds the axons of some neurons, providing electrical insulation and increasing the speed at which nerve impulses are conducted.

Saltatory Conduction

The process by which nerve impulses jump from one Ranvier node to another, speeding up the transmission of electrical signals along myelinated neurons.