A Company Wants to Build a New Factory in Either

question 21

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 $15 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 values should go in cells B6:G14 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

Comprehend the importance of currency exchange rates for global companies.

Define licensing and franchising, including their advantages and disadvantages.

Understand the techniques and importance of back translation in global marketing.

Understand the Dividend Discount Model (DDM) and its application in investment analysis.

---

Definitions:

Accompanying Figure

A graphical or visual representation that goes with a text or data set to illustrate or explain the information presented.

Assignment Operator

The assignment operator in programming languages is used to assign a value to a variable.

String Variable

A type of variable in programming that is used to store text data, such as words or sentences.

Memory Space

The amount of physical or virtual memory allocated for storing data or program instructions.