Formulate and Solve Optimization Models with Binary Variables and Logical

question 27

Multiple Choice

Formulate and solve optimization models with binary variables and logical constraints.
Use the table below to answer the following question(s) 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 } & \text { B } & \text { C } & \text { D } & \text { E } & \text { F } & \text { G } \\\hline & \text { Project Selection } & & & & & & \\1 & \text { Model } & & & & & & \\\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 5 & \begin{array}{l}\text { Expected Return } \\(\mathrm{NPV}) \end{array} & \$ 160,000 & \$ 200,000 & \$ 125,000 & \$ 150,000 & \$ 225,000 \\\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 & \begin{array}{l}\text { Personnel } \\\text { requirements }\end{array} & 7 & 4 & 2 & 6 & 4 & 10 \\\hline 8 & & & & & & & \\\hline 9 & \text { Model } \\\hline 10 & \\\hline 11 & \begin{array}{l}\text { Project selection } \\\text { decisions }\end{array} \\\hline 12 & \text { Cash Used } \\\hline 13 & \text { Personnel Used } \\\hline 14 & \text { Return } \\\hline\end{array}$
-What is the total return obtained from all five projects?

• A) $ 860,000
• B) $ 550,000
• C) $ 700,000
• D) $ 395,000

---

Definitions:

Dependent

A person who relies on another, typically a family member, for financial support and qualifies for certain tax benefits on the supporter's tax return.

Tuition

The charge or fee for instruction, as at a private school or a college or university, often eligible for tax credits or deductions under certain conditions.

Meal Plan

A prepaid system for purchasing meals, often used in college dining halls or by individuals planning dietary needs.

Child Tax Credit

A tax benefit that allows taxpayers to reduce their tax liability on a dollar-for-dollar basis for each qualifying child under a certain age.