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 31QP
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.
d)
Summary Introduction
To identify: The processing time unused at each machine at the optimal solution.
e)
Summary Introduction
To identify: The change in the model when all machines are expected to utilize the same processing time.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
NewTel is a telephone company with a policy of filling positions internally through promotions, rather than hiring from outside. Until recently, the company had a strong engineering focus and tended to promote people to senior executive positions from the engineering areas. Consequently, almost all of the company's 14 senior executives joined the company over 20 years ago as junior engineers. There is increasing pressure on NewTel to become more market and service oriented. As a result, four people were hired last year from firms to fill new senior executive positions in marketing and service departments. The external hires were necessary because current employees were not sufficiently qualified. Now, there are signs of tension among senior executives, particularly during budget deliberations where there is limited discretionary spending on new corporate activities. The four new hires have been thwarted in their attempts to have the company invest more in marketing and customer…
At Trojans Urgent Care Clinic, there is one
triage nurse, 5 nurse practitioners, and 3
doctors. Patients arrive to the triage nurse,
and the triage nurse decides if their case
can be handled by a nurse practitioner or
must be handled by a doctor. The triage
nurse can detect patients whose case can
be handled by a nurse practitioner in on
average 5 minutes with standard deviation
1 minute; however, the triage nurse spends
on average 10 minutes with standard
deviation 3 minutes with patients whose
case is eventually handled by a doctor.
Patients seeing a nurse practitioner spend
on average 30 minutes with standard
deviation 8 minutes with the nurse
practitioner, and patients seeing a doctor
spend on average 45 minutes with
standard deviation 10 minutes with the
doctor. 60% of arriving patients are cared
for by a nurse practitioner and 40% of
arriving patients are cared for by a doctor.
Patients leave the Urgent Care Clinic after
seeing either the nurse practitioner or the
doctor.
a) If 8…
Catherine Blake, the office manager for the College of Business Administration, has received numerous complaints lately from several department chairpersons. In the past few months, the chairpersons have insisted that something be done about the amount of time their administrative assistants waste waiting in line to make copies. Currently, the college has two photocopy centers dedicated to small copying jobs: copy center A on the third floor and copy center B on the fourth floor. Both centers are self-serve and have identical processing capabilities. The copying machines are not visible to the administrative assistants from their offices. When copying is required, the administrative assistant goes to the copy room and waits in line to make the necessary copies. Catherine’s assistant, Brian, was assigned to investigate the problem.Brian reported that, on average, administrative assistants arrive at copy center A at the rate of 10 per hour and at copy center B at the rate of 14 per…
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
- Joan has a small design and tailoring shop making custom outfits for women. She has two employees. Each employee only begins working on a dress when a customer order has been received and then she makes the dress from beginning to end. The average production time of a dress is 1.8 days, with a standard deviation of 2.1 days. Historically, Joan has been receiving orders with interarrival times of one day on average. The interarrival times of orders have a coefficient of variation of one. (Carry at least 4 decimal places in all intermediate calculations. Round your final answer to 2 decimal places.) What is the expected waiting time, in days, between when an order is received and when production begins on the dress? A. 9.12 days B. 6.50 days C. 1.23 days D.3.41 daysarrow_forwardJOHNSON’S RULE Five specialty jobs at a La Crosse, Wisconsin, tool and die shop must be processed through two workcenters (drill press and lathe). The time for processing each job follows:Work (processing) Time for Jobs (hours)JOBWORK CENTER 1(DRILL PRESS) WORK CENTER 2(LATHE)A5 2B3 6C8 4D 10 7E 7 12arrow_forwardCakes baked by the Freshfood Bakery are transported from the ovens to be packaged by one of three wrappers. Each wrapper can wrap an average of 200 cakes per hour. The cakes are brought to the wrappers at the rate of 500 per hour. If a cake sits longer than 5 minutes before being wrapped, it will not be fresh enough to meet the bakery’s quality control standards. Does the bakery need to hire another wrapper?arrow_forward
- The medical director of a large emergency clinic faces a problem of providing treatment for patients who arrive at different rates during the day. There are several doctors available to treat patients when needed. If not needed, they can be assigned to other responsibilities (for example, lab tests, reports, x-ray diagnoses) or else rescheduled to work at other hours. It is important to provide quick and responsive treatment, and the medical director feels that, on the average, patients should not have to sit in the waiting area for more than 20 minutes before being seen by a doctor. Patients are treated on a first-come, first-served basis and see the first available doctor after waiting in the queue. The arrival pattern for a typical day is: ________________________________________________ Arrival Rate, Time patients/hour…arrow_forwardThe medical director of a large emergency clinic faces a problem of providing treatment for patients who arrive at different rates during the day. There are several doctors available to treat patients when needed. If not needed, they can be assigned to other responsibilities (for example, lab tests, reports, x-ray diagnoses) or else rescheduled to work at other hours. It is important to provide quick and responsive treatment, and the medical director feels that, on the average, patients should not have to sit in the waiting area for more than 20 minutes before being seen by a doctor. Patients are treated on a first-come, first-served basis and see the first available doctor after waiting in the queue. The arrival pattern for a typical day is: These arrivals follow a Poisson distribution. The treatment time is 24 minutes on the average with an exponential distribution. Consider the service cost (by doctors) to be $130 per hour. For each patient, the waiting cost when waiting for service…arrow_forwardSouth Beach University is conducting an online exam. There are 1,200 students taking this exam. Students are required to download the exam questions from the university’s learning management system (LMS), solve the questions, type their workings and answers in a computer word processing application, and submit the files back to the LMS. It is estimated that the LMS takes an average of 30 seconds to process a submission. For example, if a student submits his files at time T and the LMS is able to start processing his submitted files right away, it is estimated that the LMS accepts the submission at T + 30 seconds. The cut-off time of the exam is 12pm on the exam day, that is, if a submission cannot be accepted by the LMS by 12pm, it is considered late submission.Due to the capacity of the LMS servers, a maximum of 150 submissions can be processed at any point of time. Submissions are processed on a first-come-first-serve basis. If the number of submissions exceeds the capacity, some…arrow_forward
- South Beach University is conducting an online exam. There are 1,200 students taking this exam. Students are required to download the exam questions from the university’s learning management system (LMS), solve the questions, type their workings and answers in a computer word processing application, and submit the files back to the LMS. It is estimated that the LMS takes an average of 30 seconds to process a submission. For example, if a student submits his files at time T and the LMS is able to start processing his submitted files right away, it is estimated that the LMS accepts the submission at T + 30 seconds. The cut-off time of the exam is 12pm on the exam day, that is, if a submission cannot be accepted by the LMS by 12pm, it is considered late submission. Due to the capacity of the LMS servers, a maximum of 150 submissions can be processed at any point of time. Submissions are processed on a first-come-first-serve basis. If the number of submissions exceeds the capacity, some…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 $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_forwardLaredo Leather Company manufactures high-quality leather goods. The company's profits have declined during the past nine months. In an attempt to isolate the causes of poor profit performance, management is investigating the manufacturing operations of each of its products. One of the company's main products is leather belts. The belts are produced in a single, continuous process in the Dallas plant. During the process, leather strips are sewn, punched, and dyed. The belts then enter a final finishing stage to conclude the process. Labor and overhead are applied continuously during the manufacturing process. All materials, leather strips, and buckles are introduced at the beginning of the process. The firm uses the weighted-average method to calculate its unit costs. The leather belts produced at the Dallas plant are sold wholesale for $9.95 each. Management wants to compare the current manufacturing costs per unit with market prices for leather belts. The top management has…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,