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

question 50

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 B15 of the following Excel implementation of the ILP model for this problem?

• A)=B5 ? MIN$E$11/B11,$E$11/C11)*B14
• B)=B5 ? MIN$E$11/B11,$E$12/B12)
• C)=B5 ? $E$12/B12*B14
• D)=B5 ? MIN$E$11/B11,$E$12/B12)*B14

---

Definitions:

Isopropyl Iodide

An organic compound with the formula (CH3)2CHI, used as an alkylating agent in organic synthesis.

Vinylic Halide

A halogenated compound where the halide ion is directly bonded to an alkene carbon atom.

Androgen Agonist

A substance that binds to and activates androgen receptors, stimulating the effects of male hormones like testosterone in the body.

Flame Retardant

A substance that is added to materials to make them resistant to catching fire.