Formulate and Solve Optimization Models with Binary Variables and Logical

question 49

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}$
-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

Understand the components and implications of Herzberg's two-factor theory on employee motivation.

Comprehend the relationship between expectancy theory and employee motivation including the concepts of valence, expectancy, and instrumentality.

Differentiate between the concepts of economic value added and residual income, and their roles in financial management.

Understand the concept and importance of decentralization in organizations.

---

Definitions:

Spinal Column

The structure consisting of a series of vertebrae extending from the skull to the lower back, supporting the body and protecting the spinal cord.

Flexibility Program

A structured set of exercises designed to enhance the flexibility and range of motion of joints and muscles.

Contract-relax Phase

A technique in stretching and physical therapy where a muscle is first contracted, then relaxed to allow it to stretch further.

Gluteal Stretch

A specific physical exercise aimed at increasing the flexibility and range of motion of the gluteal muscles in the buttocks.