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:

Nanotechnology

The science and technology of creating and manipulating materials on an atomic or molecular scale, especially to build microscopic devices or structures.

Restoring Function

The process of rehabilitation or treatment aimed at returning lost capabilities or functioning to an individual after injury, disease, or impairment.

Corticospinal Tract

Bundle of nerve fibers directly connecting the cerebral cortex to the spinal cord, branching at the brainstem into an opposite-side lateral tract that informs movement of limbs and digits and a same-side anterior tract that informs movement of the trunk; also called pyramidal tract.

Motor Pathway

A neural path that signals from the brain or spinal cord to muscles, facilitating movement and motor function.