Use the Table Below to Answer the Following Questions) by Invoking

question 39

Multiple Choice

Use the table below to answer the following questions) by invoking the binary constraints on the variables using the standard Solver.
Below is the spreadsheet for a project selection model: $\begin{array}{|l|l|l|l|l|l|l|l|}\hline & \text { A } & \mathrm{B} & \mathrm{C}&D&E&F&G \\\hline 1 & \begin{array}{l}\text { Project Selection } \\\text { Model }\end{array} & & \\\hline 2 & & & \\\hline 3 & \text { Data } & & \\\hline 4 & & & & && & \text { Available } \\& &\text { Project 1 } & \text { Project 2 } & \text { Project 3 } & \text { Project 4 } & \text { Project 5 } & \text { Resources } \\\hline &\text { Expected Return } & \$ 160,000 & \$ 200,000 & \$ 125,000 & \$ 150,000 & \$ 225,000 & \\5 &\text { NPV) } & \\\hline 6& \begin{array}{l}\text { Cash } \\\text { requirements }\end{array} & \$ 45,000 & \$ 70,000 & \$ 28,000 & \$ 52,000 & \$ 65,000 & \$ 175,000 \\\hline 7 & \text { Personnel } & & & & & & \\&\text { requirements } & 7 & 4 & 2 & 6 & 4 & 10\\\hline 8 & \\\hline 9 & \text { Model } \\\hline 10 & \\\hline & \text { Project selection } \\11 & \text { decisions } \\\hline 12 & \text { Cash Used } \\\hline 13 & \text { Personnel Used } \\\hline 14 & \text { Return } \\\hline\end{array}$
-Which of the following cells is set as the objective cell in Solver?

• A) $G$12
• B) $F$14
• C) $G$14
• D) $B$12

---

Definitions:

Methoxycyclohexane

Methoxycyclohexane is an organic compound featuring a cyclohexane ring with a methoxy (-OCH3) functional group attached, utilized in various synthetic organic chemistry applications.

Meso Ether

An ether that is part of a molecule having chiral centers but is overall achiral due to a plane of symmetry.

Enantiomeric Ethers

Ethers that are mirror images of each other but cannot be superimposed, typically having asymmetric centers that lead to chiral properties.

Methoxycyclohexane

An organic compound consisting of a cyclohexane ring with a methoxy group (-OCH3) attached, used as a solvent or intermediate in organic synthesis.