Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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

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 Number Data Center Cost ($ millions) Secure Servers Super Secure Servers
1 Michigan 3.5 40 80
2 New York 1 2.0 50 30
3 New York 2 4.0 90 60
4 Ohio 3.5 80 40
5 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.

Letxi=

1 if data centeriis updated
0 otherwise

for

i= 1, 2, 3, 4, 5.

Give your objective function in millions of

dollars.

Min

s.t.Secure

Super Secure

(b)Solve the model formulated in part (a) to provide a recommendation for management. Which data center(s) do you recommend Galaxy Cloud Services update? (Select all that apply.) Michigan New York 1 New York 2 Ohio California

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Methods For Business

Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Cam

11th Edition

978-0324651812, 324651813, 978-0324651751

Students also viewed these General Management questions