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

Grasp the concepts of sustainability and sustainable consumer behavior.

Learn the mechanisms and benefits of eco-efficient practices.

Comprehend the importance of stakeholder engagement in evaluating CSR programs.

Recognize the importance of ethical standards and moral responsibilities in business practices.

---

Definitions:

Native-Born

Individuals born in the country in which they reside, as opposed to those who have immigrated or moved there.

White-Collar

White-Collar refers to jobs or workers that are in professional, managerial, or administrative roles, typically involving mental or clerical work as opposed to physical labor.

Billions

A numerical value equivalent to a thousand million (1,000,000,000), often used to denote large quantities, such as currency or populations.

Code of the Street

A set of informal rules governing interpersonal public behavior, including violence, in urban environments, often as a means of maintaining respect and dissuading aggression.