Galaxy Cloud Services operates several data centers across the United States that contain servers which 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 is as follows: Data Center Cost ($ millions) Secure Servers Super Secure Servers Michigan 2.5 30 30 New York 1 1.5 40 40 New York 2 1 40 80 Ohio 3.5 40 60 California 3 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. If required, round your answers to one decimal place. Min x1 + x2 + x3 + x4 + x5 s.t. x1 + x2 + x3 + x4 + x5 ≥, ≤ , = Secure Server x1 + x2 + x3 + x4 + x5 Super Secure Server x1, x2, x3, x4, x5 = 0,1 (b) Solve the model formulated in part (a) to provide a recommendation for management. If required, round your answers to one decimal place. Optimal solution: Total Cost: $ Millions

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

Galaxy Cloud Services operates several data centers across the United States that contain servers which 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 is as follows:

Data Center	Cost ($ millions)	Secure Servers	Super Secure Servers
Michigan	2.5	30	30
New York 1	1.5	40	40
New York 2	1	40	80
Ohio	3.5	40	60
California	3	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. If required, round your answers to one decimal place.

Min	x₁	+	x₂	+	x₃	+	x₄	+	x₅
s.t.
	x₁	+	x₂	+	x₃	+	x₄	+	x₅	≥, ≤ , =	Secure Server
	x₁	+	x₂	+	x₃	+	x₄	+	x₅		Super Secure Server
	x₁, x₂, x₃, x₄, x₅	=	0,1