Integer Programming/Investment Problem/Network Flow Models

Order Description

For each question you should:

a.Define your decision variables.
b.Provide your complete formulation for the problem (objective function,
constraints and conditions on the decision variables).
c.Provide the optimal solution obtained using Solver. You are required to
state the optimal value of the decision variables and, in simple English,
the optimal solution with reference to the context (For example, X1=2 and
therefore, the company should build 2 5-star hotels…).
d.Provide a screen shot of your Excel model with the optimal solution.

Integer Programming/Investment Problem/Network Flow Models

Order Description

For each question you should:

a.Define your decision variables.
b.Provide your complete formulation for the problem (objective function,
constraints and conditions on the decision variables).
c.Provide the optimal solution obtained using Solver. You are required to
state the optimal value of the decision variables and, in simple English,
the optimal solution with reference to the context (For example, X1=2 and
therefore, the company should build 2 5-star hotels…).
d.Provide a screen shot of your Excel model with the optimal solution.