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:

Dutch Culture

The customs, arts, social institutions, and achievements of the Netherlands and its people.

French Culture

The arts, customs, languages, and social behaviors of the French people that have developed over centuries.

Glorious Revolution

The bloodless coup in England in 1688 that resulted in the overthrow of King James II and the ascension of William III and Mary II to the throne, significantly expanding the powers of Parliament.

England's Political System

A constitutional monarchy and parliamentary democracy, where the monarch is the head of state and the Prime Minister is the head of government.