Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
Author: Cliff Ragsdale
Publisher: Cengage Learning
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.
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…
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…
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 (MindTap Course List)
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 producer has three products, A, B, and C, which are composed from many of the same raw materials and subassemblies by the same skilled workforce. Each unit of product A uses 15 units of Raw Material X, one Purge System Subassembly, one Case, one Power Cord, three Labour Hours in the Assembly Department, and one Labour Hour in the Finishing Department. Each unit of product B uses 10 units of Raw Material X, five units of Raw Material Y, two Purge System Subassemblies, one Case, one Power cord, five Labour Hours in the Assembly Department, and 90 minutes in the Finishing Department. Each unit of product C uses five units of Raw Material X, 25 units of Raw Material Y, two Purge System Subassemblies, one Case, a Power Cord, seven Labour Hours in the Assembly Department, and Three Labour Hours in the Finishing Department. Labour between the Assembly and Finishing departments is not transferable, but workers within each department work on any of the three products. There are three…arrow_forwardA producer has three products, A, B, and C, which are composed from many of the same raw materials and subassemblies by the same skilled workforce. Each unit of product A uses 15 units of Raw Material X, one Purge System Subassembly, one Case, one Power Cord, three Labour Hours in the Assembly Department, and one Labour Hour in the Finishing Department. Each unit of product B uses 10 units of Raw Material X, five units of Raw Material Y, two Purge System Subassemblies, one Case, one Power cord, five Labour Hours in the Assembly Department, and 90 minutes in the Finishing Department. Each unit of product C uses five units of Raw Material X, 25 units of Raw Material Y, two Purge System Subassemblies, one Case, a Power Cord, seven Labour Hours in the Assembly Department, and Three Labour Hours in the Finishing Department. Labour between the Assembly and Finishing departments is not transferable, but workers within each department work on any of the three products. There are three…arrow_forwardAs 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. 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. Graph the feasible region.…arrow_forward
- Company ZWZ manufactures three products in a serial system; Product XA is manufactured in Stage 1, Product XB in Stage 2, and XC in Stage 3. Product XB has a sales potential in the market; hence, some of it can be sold at the end of Stage 2, and the remaining can be moved to Stage 3. The third stage produces Product XC, and then delivers it to customers. Two units of Product XA produced in Stage 1 are required for each unit of Product XB in Stage 2. In addition, four units of Product XB produced in Stage 2 are required for each unit of Product XC in Stage 3. Stage 1 can only use regular time; however, Stage 2 has the options of using regular time and overtime in manufacturing. On the other hand, Stage 3 has only one alternative, which is subcontracting. The pertinent data are provided below: Stage 2 Stage 1 11 No overtime No subcontracting No sales 0.07 Unit regular time cost (TL) Unit overtime cost (TL) Unit subcontracting cost (TL) Unit selling price (TL) Unit processing time (hrs)…arrow_forwardA manufacturing plant produces a product 'A' that requires one unit of 'B' and ½ unit of 'C'. Each unit of 'B' is comprised of one unit of 'D', two units of 'E', and one unit of 'F'. Each unit of 'C' requires ½ unit of 'G' and three units of 'H'. The manufacturing lead times for the components are as follows: 'A' - two weeks, 'B' - one week, 'C' - two weeks, 'D' - two weeks, 'E' - three weeks, 'F' - one week, 'G' - two weeks, 'H' - one week. There are 20 units in stock for each of these components. 100 units of 'A' are needed for delivery in seven weeks: a) Develop the product structure and indexed bill of materials for the product. b) Create a gross and net requirements plan for the manufacturer of the product.arrow_forwardAs 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 costarrow_forward
- 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_forwardCarol Burgess is a letter carrier and a part-time trainer of letter carriers for the U.S. Postal Service in a major city on the west coast. She trains all new letter carriers in her service area, which encompasses the northern half of her state. Over the past five years she has trained 318 new letter carriers. Typically, the training is offered prior to the new letter carrier’s entry onto the job, although sometimes it occurs shortly thereafter. The training program typically encompasses both the orientation of new employees to the U.S. Postal Service and the development of specific skills needed by the new letter carrier. The latter involves practice in casing mail (i.e., sorting) to appropriate locations of a case in preparation for delivery, reading maps, determining appropriate sequencing of delivery, and customer relations. The total training program takes three full days (one day of orientation and two days of skills training). The orientation part of the training program…arrow_forwardEmbassy Motorcycles (EM) manufactures two lightweight motorcycles designed for easy handling and safety. The EZ-Rider model has a new engine and a low profile that make it easy to balance. The Lady-Sport model is slightly larger, uses a more traditional engine, and is specifically designed to appeal to women riders. Embassy produces the engines for both models at its Des Moines, Iowa, plant. Each EZ-Rider engine requires 6 hours ofarrow_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_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_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_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