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:

Precocious Puberty

The appearance of physical and hormonal signs of pubertal development at an earlier age than is considered normal.

Pubic Hair

Body hair that grows in the pubic region from puberty onwards, the development of which is a sign of puberty and sexual maturation.

Scrotum

The bag of skin that holds and protects the testicles in males, also acting as a climate control system for sperm.

Nocturnal Emission

Also known as a wet dream, it's an involuntary ejaculation of semen during sleep, typically associated with puberty and male sexual health.