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:

Designated Groups

Specific segments of the population that are protected under affirmative action and equal opportunity policies, often including women, minorities, and individuals with disabilities.

Median Pay

Median pay refers to the middle value of wages in a range of pay rates, where half of the workers earn less and half earn more.

Aboriginals

Indigenous peoples native to a land or region, often used in reference to the original inhabitants of Australia.