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

question 38

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 locations for new warehouses. The firm's goal is to maximize the net present value of their decision while not spending more than their currently available capital.
Max 20x1 + 30x2 + 10x3 + 15x4
s.t. 5x1 + 7x2 + 12x3 + 11x4 ? 21 {Constraint 1}
X1 + x2 + x3 + x4 ? 2 {Constraint 2}
X1 + x2 ? 1 {Constraint 3}
X1 + x3 ? 1 {Constraint 4}
X2 = x4 {Constraint 5} $$x _ { j } = \left\{ \begin{array} { l } 1 , \text { if location } j \text { is selected } \\0 , \text { otherwise }\end{array} \right.$$
Set up the problem in Excel and find the optimal solution. Which locations are selected?

• A) Location 1
• B) Location 2
• C) Location 4
• D) Locations 2 and 4
• E) Locations 1 and 3

---

Definitions:

Hip Hop

A cultural movement that originated in the 1970s, characterized by four key elements: rapping, DJing, graffiti, and breakdancing.

Political Engagement

Involvement in political activities to influence government policy or representation.

Tassou Performances

A form of traditional African oral performance that combines speaking, singing, and rhythm, often in a ceremonial or storytelling context.

MC Solaar

A French rapper of Senegalese and Chadian descent, known for his complex lyrics and significant impact on the French rap scene.