Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 12, Problem 9P
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:
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Do number 2 only. #2
Zania Azlett and Angela Zesiger have joined forces to start A&Z Lettuce Products, a processor of packaged shredded lettuce for institutional use. Zania has years of food processing experience, and Angela
has extensive commercial food preparation experience. The process will consist of opening crates of lettuce and then sorting, washing, slicing, preserving, and finally packaging the prepared lettuce. Together,
with help from vendors, they think they can adequately estimate demand, fixed costs, revenues, and variable cost per bag of lettuce. They think a largely manual process will have monthly fixed costs of
$40,000 and variable costs of $1.60 per bag. A more mechanized process will have fixed costs of $75,000 per month with variable costs of $1.25 per bag. They expect to sell the shredded lettuce for $2.50 per
bag.
a) The break-even quantity in units for the manual process =
bags (round your response to the nearest whole number).
b) The revenue for the manual process at the break-even…
A company makes ceramic and porcelain tiles. They produce three different grades of tile, each of which requires
different amounts of materials and production time and generates different contributions to profit. The accompanying
table shows the percentage of materials needed for each grade and the profit per square foot. Each week, the company
receives raw material shipments, which must be used efficiently to maximize profitability. Currently, inventory consists of
6,000 pounds of clay, 3,500 pounds of silica, 5,000 pounds of sand, and 8,500 pounds of feldspar. At most 8,000 square
feet of grade III tiles should be produced and at least 2,000 square feet of grade I tiles are required. Each square foot of
tile weighs approximately 2 pounds. Develop and solve a linear optimization model to determine how many of each
grade of tile the company should make next week to maximize profit contribution.
Click here to view the tile data.
Complete the table below to indicate the number of square…
Chapter 12 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 12 - STAR Co. provides paper to smaller companies with...Ch. 12 - The following questions refer to a capital...Ch. 12 - Spencer Enterprises is attempting to choose among...Ch. 12 - Hawkins Manufacturing Company produces connecting...Ch. 12 - Grave City is considering the relocation of...Ch. 12 - Hart Manufacturing makes three products. Each...Ch. 12 - Galaxy Cloud Services operates several data...Ch. 12 - East Coast Trucking provides service from Boston...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- 23. Consider a simple economy with just two industries: farming and manufacturing. Farming consumes 1/2 of the food and 1/3 of the manufactured goods. Manufacturing consumes 1/2 of the food and 2/3 of the manufactured goods. Assuming the economy is closed and in equilibrium, find the relative outputs of the farming and manufacturing industries.arrow_forwardSuppose the coal and steel industries form a closed economy. Every $1 produced by the coal industry requires $0.30 of coal and $0.70 of steel. Every $1 produced by steel requires $0.80 of coal and $0.20 of steel. Find the annual production (output) of coal and steel if the total annual production is $20 million.arrow_forwardCell phones have become a necessity for many people throughout the world because modern society has a need for constant access to the internet and the information contained within it. The ability to access email and communicate with family are only two of the reasons for the increasing importance of cell phones. Cell phone manufacturers are constantly updating features to utilize new technologies in an effort to persuade customers to buy their latest models. However, buying a cell phone is a complicated decision and a consumer will probably spend a lot of money, depending on the features that are important to them. We will explore the variation/variability in cell phone retail prices in May 2021 with two datasets. For convenience, these two datasets have been combined into a single file for uploading into SALT. One of these datasets contains retail prices from Amazon, Walmart, and Best Buy in May 2021 of the top-rated models for 2021 as found in columns 1 and 2 of the dataset in SALT.…arrow_forward
- Mat 122 Project BThe National Business Machine Corporation manufactures two types of faxmachines, model A and model B. Each model A costs $200 to make and eachmodel B costs $300 to make. The profits are $25 for each model A fax machineand $40 for each model B fax machine. The total number of fax machinesproduced each month cannot exceed 2500 and the total earmarked formanufacturing costs cannot exceed $600,000. How many fax machines of eachmodel should the National Business Machine corporation make to maximizeprofits?arrow_forwardPharmaPlus operates a chain of 30 pharmacies. The pharmacies are staffed by licensed pharmacists and pharmacy technicians. The company currently employs 105 full-time-equivalent pharmacists (combination of full time and part time) and 175 full-time-equivalent technicians. Each spring management reviews current staffing levels and makes hiring plans for the year. A recent forecast of the prescription load for the next year shows that at least 320 full-time-equivalent employees (pharmacists and technicians) will be required to staff the pharmacies. The personnel department expects 10 pharmacists and 30 technicians to leave over the next year. To accommodate the expected attrition and prepare for future growth, management states that at least 15 new pharmacists must be hired. In addition, PharmaPlus's new service quality guidelines specify no more than two technicians per licensed pharmacist. The average salary for licensed pharmacists is $45 per hour and the average salary for…arrow_forwardA manufacturing company has three processing lines. Each processing line combines various raw materials to produce the same output, Y. One of the processing lines can combine units of input (X) to produce units of output (Y) such that there is a linear relationship between X and Y. The Chief Executive Officer wants the output model to be estimated for this processing line. Given the values of X and Y (in thousands of units) in the table below, and as the Director of Data Management, you are to: x 5 7 2 8 4 8 12 6 14 8 Determine the extent to which output changes as the input change and interpret your result. Find the intercept of the output model and interpret it. Write down the equation of the line of best fit for output. Determine the value of the extent of relationship between input (X) and output (Y), and interpret your result.arrow_forward
- Create an LP Model.arrow_forwardFlowcharts are common process design and analysis tools used in both manufacturing and services. What is a key feature of flowcharts used in service operations that differentiates between the front-office and back-office aspects of the system?arrow_forwardAlexa is the popular virtual assistant developed by Amazon. Alexa interacts with users using artificial intelligence and voice . can be used to perform daily tasks such as making to-do listsreporting the news and weather, and interacting with other smart devices in the home. In 2018, the Amazon Alexa app was downloaded some 2, 800 times per day from the Google Play Store (AppBrain website). Assume that the number of downloads per day of the Amazon Alexa app is normally distributed a mean of 2,800 and standard deviation of B60arrow_forward
- eICU Waiting Times. There is a severe shortage of critical care doctors and nurses to provide intensive-care services in hospitals. To offset this shortage, many hospitals, such as Emory Hospital in Atlanta, are using electronic intensive-care units (eICUs) to help provide this care to patients (Emory University News Center). eICUs use electronic monitoring tools and twoway communication through video and audio so that a centralized staff of specially trained doctors and nurses—who can be located as far away as Australia—can provide critical care services to patients located in remote hospitals without fully staffed ICUs. One of the most important metrics tracked by these eICUs is the time that a patient must wait for the first video interaction between the patient and the eICU staff. Consider the following sample of 40 patient waiting times until their first video interaction with the eICU staff.arrow_forwardAfter more than 75 years in the business, Walsworth Pub-lishing’s leadership was well aware of the efforts that go into juggling school work and the production of a high-quality school yearbook. They examined their communication and production processes and decided to implement the Information Builders’ WebFOCUS-based reporting portal, an online dashboard. Each of the more than 4,000 schools had its own dashboard, and the volunteer student staff and faculty advisor could access the dashboard in real time. The online dashboard contained notices, progress toward deadlines, alerts about missing or corrupt content, and more. What should be the research measure(s) to determine the effectiveness of the new online dashboard process for improving efficiency and quality of each school’s yearbook?arrow_forwardGlueco produces three types of glue on two differentproduction lines. Each line can be utilized by up to sevenworkers at a time. Workers are paid $500 per week onproduction line 1, and $900 per week on production line 2.A week of production costs $1,000 to set up production line1 and $2,000 to set up production line 2. During a week ona production line, each worker produces the number of unitsof glue shown in Table 12. Each week, at least 120 units ofglue 1, at least 150 units of glue 2, and at least 200 units ofglue 3 must be produced. Formulate an IP to minimize thetotal cost of meeting weekly demands.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
Elementary Geometry for College StudentsGeometryISBN:9781285195698Author:Daniel C. Alexander, Geralyn M. KoeberleinPublisher:Cengage Learning
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
Elementary Geometry for College Students
Geometry
ISBN:9781285195698
Author:Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:Cengage Learning
Use of ALGEBRA in REAL LIFE; Author: Fast and Easy Maths !;https://www.youtube.com/watch?v=9_PbWFpvkDc;License: Standard YouTube License, CC-BY
Compound Interest Formula Explained, Investment, Monthly & Continuously, Word Problems, Algebra; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=P182Abv3fOk;License: Standard YouTube License, CC-BY
Applications of Algebra (Digit, Age, Work, Clock, Mixture and Rate Problems); Author: EngineerProf PH;https://www.youtube.com/watch?v=Y8aJ_wYCS2g;License: Standard YouTube License, CC-BY