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

question 27

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}$
-What is the amount of personnel used for Project 2?

• A) 3
• B) 4
• C) 6
• D) 11

---

Definitions:

Synthesized

Created or formed by combining simpler substances or elements through a chemical process, leading to a new compound or product.

Cash Dividend

A distribution of a portion of a company's earnings, decided by the board of directors, paid to a class of its shareholders.

Assets

Economic resources owned or controlled by a company; they have measurable value and are expected to benefit the company by producing cash inflows or reducing cash outflows in the future.

Stock Price Appreciation

The rise in the value of a company's shares over time, reflecting the market's increased valuation of the company.