Note: This Problem Requires the Use of a Linear Programming $$x _ { j } = \left\{ \begin{array} { l } 1 , \text { if project } j \text { is selected } \\0 , \text { otherwise }\end{array} \right.$$

question 40

Multiple Choice

Note: This problem requires the use of a linear programming application such as Solver or Analytic Solver.
A firm has prepared the following binary integer program to evaluate a number of potential new capital projects. The firm's goal is to maximize the net present value of their decision while not spending more than their currently available capital.
Max 100x1 + 120x2 + 90x3 + 135x4
s.t. 150x1 + 200x2 + 225x3 + 175x4 ? 500 {Constraint 1}
X1 + x2 + x3 + x4 ? 2 {Constraint 2}
X2 + x4 ? 1 {Constraint 3}
X2 + x3 ? 1 {Constraint 4}
X1 = x4 {Constraint 5} $$x _ { j } = \left\{ \begin{array} { l } 1 , \text { if project } j \text { is selected } \\0 , \text { otherwise }\end{array} \right.$$
Set up the problem in Excel and find the optimal solution. Which projects are selected?

• A) Project 1
• B) Project 2
• C) Project 4
• D) Projects 2 and 3
• E) Projects 1 and 3

---

Definitions:

Determination of Parties

The process of identifying the entities or individuals involved in an agreement, conflict, or legal case.

Ethical Intensity

The magnitude of ethical concern perceived in a situation, influenced by factors like potential harm, social pressure, and probability of effect.

Vary Directly

A relationship where an increase in one variable corresponds with an increase in another variable.

Generation Y

A term used to describe individuals born approximately between the early 1980s and the late 1990s, also known as Millennials.