Cloud Services Capacity Planning. Galaxy Cloud Services operates several data centers across the United States containing servers that store and process the data on the Internet. Suppose that Galaxy Cloud Services currently has five outdated data centers: one each in Michigan, Ohio, and California and two in New York. Management is considering increasing the capacity of these data centers to keep up with increasing demand. Each data center contains servers that are dedicated to Secure data and to Super Secure data. The cost to update each data center and the resulting increase in server capacity for each type of server are as follows: Data Center Cost ($ millions) Secure Servers Super Secure Servers Michigan 2. 5 50 30 New York 1 3. 5 80 40 New York 2 3. 5 40 80 Ohio 4. 0 90 60 California 2. 0 20 30 The projected needs are for a total increase in capacity of 90 Secure servers and 90 Super Secure servers. Management wants to determine which data centers to update to meet projected needs and, at the same time, minimize the total cost of the added capacity. A. Formulate a binary integer programming model that could be used to determine the optimal solution to the capacity increase question facing management. B. Solve the model formulated in part (a) to provide a recommendation for management

Respuesta :

The recommended cost that minimizes the total spending of the company is $7 million

How to formulate a binary integer programming model

The dataset can be represented using the following table:

Data center     Cost (Million)   Secure Servers    Super Secure Servers

Michigan (x₁)               2.5                    50                            30

New York 1 (x₂)            3.5                    80                            40

New York 2 (x₃)           3.5                    40                            80

Ohio (x₄)                       4.0                    90                            60

California (x₅)               2.0                    20                            30

Total                                                      90                            90

The above table can be represented using the following model

Minimize Z = 2.5x₁ + 3.5x₂ + 3.5x₃ + 4.0x₄ + 2.5x₅

Where the constraints are:

30x₁ + 40x₂ + 80x₃ + 60x₄ + 30x₅ ≥ 90

50x₁ + 80x₂ + 40x₃ + 90x₄ + 20x₅ ≥ 90

Where x₁, x₂, x₃, x₄, x₅ ≥ 0

The solution to the model

To do this we make use of a statistical calculator.

From the calculator, we have:

x₁ = 0, x₂ = 1, x₃ = 1, x₄ = 0, x₅ = 0

Substitute these values in Z = 2.5x₁ + 3.5x₂ + 3.5x₃ + 4.0x₄ + 2.5x₅.

So, we have:

Z = 2.5 * 0 + 3.5 * 1 + 3.5 * 1 + 4.0 * 0 + 2.5 * 0

Evaluate

Z = 7

Hence, the recommended cost that minimizes the total spending of the company is $7 million

Read more about objective functions at:

https://brainly.com/question/16826001

#SPJ1