Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 30QP
a)
Summary Introduction
To formulate: A linear programming model for the problem.
b)
Summary Introduction
To develop: A spreadsheet model and solve using solver.
c)
Summary Introduction
To identify: The optimal solution.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a
machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the
time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand
forecasts (pessimistic, expected, and optimistic). The manager believes that a 25 percent capacity cushion is best.
D
Demand Forecast
Component
A
B
C
Time Standard
Processing Setup
(hr/unit) (hr/lot)
0.04
1.0
0.20
4.4
0.05
8.5
Lot Size
(units/lot)
50
75
100
Demand Forecast
Pessimistic
Expected
Optimistic
Pessimistic
16,000
10,000
18,000
a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up
to the next…
Macon Controls produces three different types of control units used to protect industrial equipment from overheating. Each of these units must be processed by a
machine that Macon considers to be their process bottleneck. The plant operates on two 8-hour shifts, 5 days per week, 52 weeks per year. The table below provides the
time standards at the bottleneck, lot sizes, and demand forecasts for the three units. Because of demand uncertainties, the operations manager obtained three demand
forecasts (pessimistic, expected, and optimistic). The manager believes that a 25 percent capacity cushion is best.
i
Demand Forecast
Component
A
B
C
Time Standard
Processing
(hr/unit)
0.04
0.20
0.05
Setup
(hr/lot)
1.0
4.4
8.5
Lot Size
(units/lot)
50
75
100
Demand Forecast
Pessimistic Expected
16,000
17,000
10,000
12,000
18,000
24,000
a. How many machines are required to meet minimum (Pessimistic) demand, expected demand, and maximum (Optimistic) demand? (Enter your responses rounded up
to the next…
2. As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem solving costs $8000.
a. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem solving that should be offered in order to minimize total cost.
b. Determine the optimal…
Chapter 3 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Refer to question 19 at the end of Chapter 2....Ch. 3 - Prob. 8QPCh. 3 - Prob. 9QPCh. 3 - Prob. 10QP
Ch. 3 - Prob. 11QPCh. 3 - Prob. 12QPCh. 3 - Prob. 13QPCh. 3 - Prob. 14QPCh. 3 - Prob. 15QPCh. 3 - Prob. 16QPCh. 3 - Prob. 17QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - Prob. 26QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 28QPCh. 3 - Prob. 29QPCh. 3 - Prob. 30QPCh. 3 - Prob. 31QPCh. 3 - Prob. 32QPCh. 3 - Prob. 33QPCh. 3 - Prob. 34QPCh. 3 - Prob. 35QPCh. 3 - Prob. 36QPCh. 3 - Prob. 37QPCh. 3 - Prob. 38QPCh. 3 - Prob. 39QPCh. 3 - Prob. 40QPCh. 3 - Prob. 41QPCh. 3 - Prob. 42QPCh. 3 - Prob. 43QPCh. 3 - Prob. 44QPCh. 3 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 46QPCh. 3 - The CFO for Eagle Beach Wear and Gift Shop is in...Ch. 3 - Prob. 48QPCh. 3 - Prob. 1.1CCh. 3 - Prob. 1.2CCh. 3 - Prob. 1.3CCh. 3 - Prob. 1.4CCh. 3 - Prob. 2.1CCh. 3 - Prob. 2.2CCh. 3 - Prob. 2.3CCh. 3 - Prob. 2.4CCh. 3 - Prob. 2.5CCh. 3 - Kelly Jones is a financial analyst for Wolverine...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- A large business process outsourcing company operates 5 days a week (Monday to Friday). The manager estimates that the minimum number of agents requires, a combined on-site and work-from-home (WFH) setup, to provide prompt service: 20 for Monday, 18 for Tuesday, 23 for Wednesday, 28 for Thursday, and 32 for Friday. Labor rules state that each agent must work for 3 days a week on-site. and 2 days in WFH setup. For example. an agent who works on-site Monday to Wednesday must be on WFH setup during Thursday and Friday. Also. the company wants at least 60% of the workforce daily to report on-site. Formulate the appropriate LP model for this problem to minimize the number of agents to be hired.arrow_forwardDon't used Chat gptarrow_forwardProblem #3 A, B, Carrow_forward
- As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem-solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem-solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem-solving costs $8,000. a. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem-solving that should be offered in order to minimize total cost.b. Graph the feasible…arrow_forwardEarth Resources Corporation is a multinational company engaged in steamfield development and power plant construction through the government's use of build-operate- transfer (BOT) contracts. Recently, the company has been awarded contracts and has to start drilling operations at four (4) new geothermal sites in the Philippines. In order to ensure that drilling operations are on schedule and in accordance with the provisions of the contract, Earth Resources must send a team of two (2) drilling engineers to each site. Currently, they have eight (8) drilling engineers at various sites where the drilling is almost completed. The chief executive officer (CEO) wants to mobilize all the eight engineers to the four new sites in such a way that the total costs involved is minimized. The CEO requested the company's chief accountant, Ms. Debbie Castro, to prepare a summary of the estimated mobilization costs from the engineer's present locations to their probable new assignments. accomplished…arrow_forwardR. C. Coleman distributes a variety of food products that are sold through grocery store and supermarket outlets. The company receives orders directly from the individual outlets, with a typical order requesting the delivery of several cases of anywhere from 20 to 50 different products. Under the company’s current warehouse operation, warehouse clerks dispatch order-picking personnel to fill each order and have the goods moved to the warehouse shipping area Because of the high labor costs and relatively low productivity of hand order picking, management has decided to automate the warehouse operation by installing a computer-controlled order-picking system along with a conveyor system for moving goods from storage to the warehouse shipping area. R. C. Coleman’s director of material management has been named the project manager in charge of the automated warehouse system. After consulting with members of the engineering staff and warehouse management personnel, the director compiled a…arrow_forward
- Companies A, B, and C supply components to three plants (F, G, and H) via two crossdocking facilities (D and E). It costs $4 to ship from D regardless of final destination and $3 to ship to E regardless of supplier. Shipping to D from A, B, and C costs $3, $4, and $5, respectively, and shipping from E to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. Crossdock facilities D and E can handle 600 and 700 units, respectively. Logistics Manager, Aretha Franklin, had previously used "Chain of Fools" as her supply chain consulting company, but now turns to you for some solid advice. Set up the solution in Excel and solve with Solver. What are total costs?arrow_forwardSituation: The Sure To Peal Paint Company stores all its metal compressed gas containers in a warehouse. These long cylindrical metal tanks contain various gases used in manufacturing cans of spray paint. The gas tanks are delivered to the warehouse by truck. Two receiving dockworkers unload the containers from the delivery trucks and place them on four wheel trucks. Two materials handlers are responsible for pushing the loaded trucks into the warehouse, unloading the tanks and setting them up on end. The two materials handlers spend a major portion of their day moving loads of the gas tanks into the warehouse and placing them into the proper storage locations. In total, there are five different types of gases that in equal proportion make up 98% of all gas handled. Question: Management would like to identify a better way to handle these gas tanks. How can the handling operation be improved? Situation: The Rosemarie Cosmetic company has a warehouse of 20 high pallet racks serviced by…arrow_forwardCompanies A, B, and C supply components to three plants (F, G, and H) via two crossdocking facilities (D and E). It costs $4 to ship from D regardless of final destination and $3 to ship to E regardless of supplier. Shipping to D from A, B, and C costs $3, $4, and $5, respectively, and shipping from E to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. Crossdock facilities D and E can handle 600 and 700 units, respectively. Logistics Manager, Aretha Franklin, had previously used "Chain of Fools" as her supply chain consulting company, but now turns to you for some solid advice. What is the objective function? Group of answer choices Max Z = $3AD + $3AE + $4BD + $3BE + $5CD + $3CE + $4DF + $4DG + $4DH + $10EF + $9EG + $8EH Min Z = $3AD + $3AE + $4BD + $3BE + $5CD + $3CE + $4DF + $4DG + $4DH + $10EF + $9EG + $8EH Min Z = $3AD + $3BE + $5CD + $3CE…arrow_forward
- (Business Analytics) I need some help on this problem, I'm not sure what to do. Problem 2) Larry Edison is the director of the Computer Center for Buckly college. He now needs to schedule the staffing of the center. It is open from 8:00 AM until midnight. Larry has monitored the usage of the center at various times of the day and determined that the following number of computer consultants (qualified graduate students) are required. Time of Day Minimum Number of Consultants Required to be on Duty 8 AM – Noon 6 Noon – 4 PM 8 4 PM – 8 PM 12 8 PM - Midnight 6 Two types of computer consultants can be hired: full-time and part-time period the full-time consultants work for eight consecutive hours in any of the following shifts: mornings (8 AM - 4:00 PM), afternoon (noon - 8:00 PM), and evenings (4:00 PM to midnight). Full-time consultants are paid $17.50 per hour. Part-time consultants can be hired to work any of the four…arrow_forward: You are employed by Univeristy of Gujrat , a university that provides a range of training and education, including Computing, and Information & Communication Technology (ITC). The Head of Department of ITC, Mr Rumi, has discovered that on more than one occasion recently a computer virus has been introduced to the computers in the department. He thinks that the viruses have been introduced from computer disks brought in by students. He has decided to introduce a system where all disks used in the department must be checked for a virus before they can be put into the computers. He says to you, I would like you to send a memo in my name to all teachers who use the computer rooms. You will have to tell them that all disks brought in by students must be checked before there are used. The teachers have to check them carefully, of course. We have got to stop these viruses being introduced before they cause serious problems. Oh yes, reminds them to lock up the rooms when they leave.…arrow_forwardKaren owns a roof repair service and drives a van to local client sites. During the week she drives the following distances: · From her home to her business headquarters: 8 miles · From her headquarters to a client site: 15 miles · From client site back to her headquarters: 15 miles · Trip from her headquarters back home: 8 miles How many miles does she count for business purposes? Group of answer choices 8 miles. 15 miles. 30 miles. 46 miles.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill Education
Management (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...ManagementISBN:9781305947412Author:Cliff RagsdalePublisher:Cengage Learning
Management Information Systems: Managing The Digi...ManagementISBN:9780135191798Author:Kenneth C. Laudon, Jane P. LaudonPublisher:PEARSON
Business Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSON
Fundamentals of Management (10th Edition)ManagementISBN:9780134237473Author:Stephen P. Robbins, Mary A. Coulter, David A. De CenzoPublisher:PEARSON
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON