Business, 13.04.2021 04:50 Vells962

A company considers opening distribution centers in (1) New Brunswick, (2) Waterloo, (3) Montreal, (4) Ottawa, and (5) Toronto. The cost of building the five terminals (in millions of dollars) would be 10 in New Brunswick, 14 in Waterloo, 18 in Montreal, 17 in Ottawa, and 24 in Toronto. No more than two terminals may be built. If a terminal is built in Ottawa, then one must be built in New Brunswick. At least one terminal must be built in Montreal, Ottawa, or Toronto. a) Formulate this location problem as an integer problem (i. e. define the variables and write down the objective function and all constraints in algebraic form).
b) Create a spreadsheet model for this problem and solve it with Solver.
c) What is the optimal solution? What is the optimal value?
d) How much would the company save without this requirement: "If a terminal is built in Ottawa, then one must be built in New Brunswick"?

Answers: 3

Show answers

Another question on Business

Business, 22.06.2019 11:00

Acompany that adapts its product mix to meet the needs of a new market is using which of the following global marketing strategies market development diversification strategy product development undiversified

Answers: 3

Answer

Business, 22.06.2019 11:30

4. chef a says that broth should be brought to a boil. chef b says that broth should be kept at an even, gentle simmer. which chef is correct? a. neither chef is correct. b. chef a is correct. c. both chefs are correct. d. chef b is correct. student c incorrect which is right answer

Answers: 2

Answer

Business, 22.06.2019 15:10

On december 31, 2013, coronado company issues 173,000 stock-appreciation rights to its officers entitling them to receive cash for the difference between the market price of its stock and a pre-established price of $10. the fair value of the sars is estimated to be $5 per sar on december 31, 2014; $2 on december 31, 2015; $10 on december 31, 2016; and $8 on december 31, 2017. the service period is 4 years, and the exercise period is 7 years. prepare a schedule that shows the amount of compensation expense allocable to each year affected by the stock-appreciation rights plan.

Answers: 2

Answer

Business, 22.06.2019 18:00

If you would like to ask a question you will have to spend some points

Answers: 1

Answer

You know the right answer?

A company considers opening distribution centers in (1) New Brunswick, (2) Waterloo, (3) Montreal, (...

Questions