Question: Google Cloud Services operates several data centers across the United States, which contain servers that store and process data on the Internet. Suppose that Google
Google Cloud Services operates several data centers across the United States, which contain servers that store and process data on the Internet. Suppose that Google Cloud Services currently has five outdated data centers: one in Chicago, 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 given in attached image: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 minimize the total cost of the added capacity.Formulate a binary integer programming model that could be used to determine the optimal solution to the capacity increase question facing management. Please include the decision variables, objective function, and all constraints. Solve the formulated model to provide a recommendation for management.For this mathematical programming optimization problem:Formulate and solve the model on Microsoft EXCEL Solver and prepare a Managerial Report that includes...A detailed introduction and explanation of the setting. Embellish if you wish!A complete formulation of the linear optimization model.Explain all variables, the objective, and constraints well.Provide the Microsoft EXCEL Solver output.Answer any questions posed in the problem.Provide and thoroughly interpret the reports from EXCEL Solver and note any interesting or more insightful output.After you have finished everything (described,formulated, solved, answered all questions, and written all of the report),create a one-page Executive Summarythat indicates what the problem is,what you did to solve it,the final solution, and any other interesting results. This synopsis is for the busy executive who wants to see what is in the report and look at details further if interested.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
