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
Mr. Elf owns a show store. Currently, he has 10 pairs of shoes that require resoling and polishing. He has a machine that can resole one pair of shoes at a time, and the time required for
the operation varies with the type and condition of the shoe and the type of sole that is used. Shoes are polished on a machine dedicated to this purpose as well, and polishing is always
done after resoling. His assistant generally does the polishing while Mr. Elf does the resoling. The resoling and polishing times (in minutes) are:
Shoes
1
Resoling Time
14
Polishing Time
3
2
28
1
3
12
2
4
6
5
5
10
10
6
14
6
7
4
12
8
25
8
9
10
15
10
5
5
Determine the sequence in which these shoes should be repaired to minimize the total makespan for these 10 jobs, and answer the following questions.
Based on the optimal sequence: (Enter integer only)
1. The first job to be processed is Job
2. The third job to be processed is Job
3. The fourth job to be processed is Job
4. The fifth job to be processed is Job
5. The…
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…
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…
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
- 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…arrow_forwardJoan 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_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_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
- 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_forwardEngineering managementarrow_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_forward
- Gilman Heating and Air Conditioning Gilman Heating and Air Conditioning Inc. provides a broad range of services to commercial and residential customers, including installation and repair of several different brands of heating and air-conditioning systems, Gilman has a fleet of 28 trucks, each operated by one or more service technicians, depending on the size of a job. A recurrent problem for Gilman has been coordinating the service teams during the day to determine the status of a job and the need for parts not kept in the service vehicle, as well as to identify which team to send on emergency calls. Gilman's service area is spread over an urban/rural area of approximately 50 square miles. The company has developed cost and price sheets so that the service technicians accurately and consistently price the service work they perform.arrow_forwardA consulting company must hire 15 new associates per year to replace those who haveleft the company for other positions or have retired. The company employs 120 associates overall. How long is the average associate employed at the consulting company?arrow_forwardMansfield Energy Corp has recently taken over a fuel supply plant that is in close proximity to one of its competitors. The collection point for both fuel companies is located at the same seaport. The general manager of Mansfield Energy Corp intends to hire a consultant to train Mansfield Energy Corp’s employees regarding the new procedures for affixing the fuel lines at the collection point to the high-capacity storage tanks and is debating whether the competitor should be invited to attend given that they use the same seaport. The general manager is mindful of the high cost of hiring the consultant and sourcing the equipment to train Mansfield Energy Corp’s employees and is therefore hesitant to invite his competitors. The manager is also aware that there have been no accidents at the port since operations started 10 years ago and might not invite the competitors to participate in the training. The General Manager decides, based on the high price for the consultant (facilitation fee,…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
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,