A Company Wants to Build a New Factory in Either

question 74

Essay

A company wants to build a new factory in either Atlanta or Columbia.It is also considering building a warehouse in whichever city is selected for the new factory.The following table shows the net present value NPV)and cost of each facility.The company wants to maximize the net present value of its facilities,but it only has $16 million to invest.
Variable Decision
NPV
$million)
Cost $million)
^X₁ Factory in Columbia 3 10
^X₂ Factory in Atlanta 4 8
^X₃ Warehouse in Columbia 2 6
^X₄ Warehouse in Atlanta 1 5
Based on this ILP formulation of the problem and the indicated optimal solution what formulas should go in cells F6:F14 of the following Excel spreadsheet?
MAX: ^{3 X}₁ ^{+ 4 X}₂ ^{+ 2 X}₃ ^{+ X}₄
Subject to: ^{10 X}₁ ^{+ 8 X}₂ ^{+ 6 X}₃ ^{+ 5 X}₄ ^{≤ 15}
X₁ + X₂ = 1 X₃ + X₄ ≤ 1 X₃ − X₁ ≤ 0 X₄ − X₂ ≤ 0 X_i = 0,1

---

Definitions:

Computers

Electronic devices capable of executing a set of instructions to perform various tasks, including processing, storing, and displaying information.

Price

The total of money that is predicted, demanded, or delivered in settlement for a product.

Law of Demand

A principle in economics that states the quantity demanded of a good falls as the price rises, and vice versa, all else being equal.

Pepsi

A carbonated soft drink produced and manufactured by PepsiCo, and one of the world's most famous and recognizable cola beverages.