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
error_outline
This textbook solution is under construction.
Students have asked these similar questions
How much influence can the employee requirements for one, two, or three days have on the weekly schedule in the employee scheduling example? Explore this in the following questions:
a. Let Monday’s requirements change from 17 to 25 in increments of 1. UseSolverTable to see how the total number of employees changes.b. Suppose the Monday and Tuesday requirements can each, independently of one another, increase from 1 to 8 in increments of 1. Use a two-way SolverTable to see how the total number of -employees changes.c. Suppose the Monday, Tuesday, and Wednesday -requirements each increase by the same amount, where this increase can be from 1 to 8 in -increments of 1. Use a one-way SolverTable to -investigate how the total number of employees changes.
A nursing home must schedule nurses in a manner that balances providing adequate patient care while keeping costs down. From historical records, administrators can project the minimum number of nurses to have on hand during each day/time slot. This data is shown below.
Shift
Time Slot
Minimum number of nurses needed
1
12 am-4
10
2
4 am-8
6
3
8 am-12
8
4
12 pm-4
12
5
4 pm-8
10
6
8 pm-12
14
Nurses must start work at the beginning of one of the four-hour shifts (starting as early as 12 am midnight or as late as 8pm evening) and work for eight hours. Nurses who begin working at 8 pm will work until 4 am the next morning.
Formulate and solve the nurse-scheduling problem so as to minimize excess stagging while satisfying minimum staffing requrements.
What is the value of total excess staffing?
Please walk me step by step to help solve this
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
- Currently a company that designs Web sites has five customers in its backlog. The day when the order arrived, processing time, and promised due dates are given in the following table. The customers are listed in the order of when they arrived. They are ready to be scheduled today, which is the start of day 190. Customer Time SinceOrder Arrived(days ago) ProcessingTime (days) Due Date(days fromnow) A B C D E 10 8 6 3 2 20 12 28 24 32 26 50 66 58 100 a. Develop separate schedules by using the FCFS and EDD rules. Compare the schedules on the basis of average flow time and average days past due.b. Comment on the performance of the two rules relative to these measures. Which one gives the best schedule? Why?arrow_forwardCurrently a company that designs Web sites has five customers in its backlog. The time since the order arrived, processing time, and promised due dates are given in the following table. The customers are ready to be scheduled today, which is the start of day 190. Customer Time Since Order Arrived (days ago) Processing Time (days) Due Date (days from now) Upper AA 6 18 66 Upper BB 3 24 58 Upper CC 2 32 100 Upper DD 10 22 26 Upper EE 8 12 50 a. Develop separate schedules by using the FCFS and EDD rules. Compare the schedules on the basis of average flow time and average days past due. Part 2 Using the FCFS (first come, first served) decision rule for sequencing the customers, the order is: Sequence 1 2 3 4 5 Customer D E A B C Part 3 Using…arrow_forwardThe company has received 7 special jobs. These jobs have to go through Process X, Process Y and then Process Z in sequence. Each of the processes is operated by a dedicated machine. What is the optimal sequence to schedule the jobs? Show your steps. If there is more than one optimal sequence under the adapted Johnson’s rule, show them all.arrow_forward
- Currently a company that designs Web sites has five customers in its backlog. The time since the order arrived, processing time, and promised due dates are given in the following table. The customers are ready to be scheduled today, which is the start of day 190. Question Viewer Time Since Order Arrived Customer (days ago) Processing Time (days) Due Date (days from now) A 3 B 2 C 10 D E 8 6 22228 24 32 58 100 20 26 12 50 66 a. Develop separate schedules by using the FCFS and EDD rules. Compare the schedules on the basis of average flow time and average days past due. Using the FCFS (first come, first served) decision rule for sequencing the customers, the order is: Sequence 1 2 3 4 5 Customer C D E A B Using the EDD (earliest due date) decision rule for sequencing the customers, the order is (to resolve a tie, use the order in which the jobs were received): Sequence 1 2 3 4 5 Customer C D A E B The average flow time and average days past due for each option are: (Enter your responses…arrow_forwardUsing the FCFS rule for scheduling, the sequence is Sunny Park Tailors has been asked to make three different types of wedding suits for separate customers. The table below highlights the time taken in hours for cutting and sewing (process 1) and delivery (process 2) of each of the suits Times Taken for Different Activities (hours) Cut and Sew Suit 1 2 3 7 4 5 Deliver 2 3 6 Assume that orders for suits have been listed in the above table in the order in which they were received. Carrow_forwardA machine center in a job shop for a local fabrication company has five unprocessed jobs remaining at a particular point in time. The jobs are labeled A, B, C, D, and E in the order that they entered the shop. The respective processing times and due dates are given in the table below. What is the sequence the of jobs by CR rules? Job Processing Time Due Date A 10 32 B. 55 34 C. 11 31 60 35arrow_forward
- About Assignment Short-Term Scheduling The following table shows the contribution of benefits provided by 5 employees A, B, C, and D in handling 5 types of work I, II, III, IV, and V. Work Employee A B C D I 10 12 10 8 II 14 10 9 15 III 8 8 7 9 IV 13 15 8 16 V 10 13 14 11 Determine the maximum contribution that can be obtained using the Assignment Modelsarrow_forwardUsing the FCFS rule for scheduling, the sequence is 1-2-3 For the schedule developed using the FCFS rule, the total length of time taken to complete the three suits (including delivery) : hours (enter your response as a whole number). = G Sunny Park Tailors has been asked to make three different types of wedding suits for separate customers. The table below highlights the time taken in hours for cutting and sewing (process 1) and delivery (process 2) of each of the suits. Times Taken for Different Activities (hours) Cut and Sew 3 5 6 Suit 1 2 7 3 Deliver 4 2 ∞ N 8 Assume that orders for suits have been listed in the above table in the order in which they were received.arrow_forwardsniparrow_forward
- Mike Reynolds has four assignments due in class tomorrow, and his class times are as follows: Time 9 a.m. 11 a.m. 2 p.m. 5:30 p.m. Each class lasts one hour, and Mike has no other classes. It is now midnight, and Mike estimates that the psychology, marketing, OM, and finance assignments will take him four, two, five, and six hours, respectively. Assume that all time till the last class begins can be spent on completing assignments but each assignment should be done till the time of the class on the same subject. (Mike can prepare assignments for the next classes during previous classes.) Use the Excel Sequencing template to determine how he should schedule the work. Use minus sign to enter negative lateness values, if any. Enter the half an hour value as 0.5, e.g., 3:30 p.m. should be entered as 15.5. If your answer is zero, enter "0". Round your answers for the due date, lateness, and tardiness to one decimal place. Round your answers for the average values to two decimal places. EDD…arrow_forwardNow you are being hired as a scheduler in the manufacturing unit of surgical instruments. Your job is to schedule four jobs on the two machines. The job processing time in minutes for the four jobs is given below: A с D Machine 1 Machine 2 3.43 0.11 B 1.58 0.46 3.62 2.29 4.05 4.52 The optimal schedule using Johnson method and makespan for the jobs is: (A)BCBA, 12.79 minutes (B) ABCD, 5.41 minutes (C) DCBA, 12.79 minutes (D) CDBA, 5.41 minutesarrow_forwardUsing Johnson's rule for 2-machine scheduling, the sequence is: Scheduled Order 1 2 3 4 5 6 Job For the schedule developed using Johnson's rule, the total length of time taken to complete the six jobs (including the 2nd operation) = hours (enter your response as a whole number). Six jobs are to be processed through a two-step operation. The first operation involves sanding, and the second involves painting. Processing times are as follows: Job A <ש ס ח ר B C E F Operation 1 (hours) 10 36254 Operation 2 (hours) 8° 4 2 7 1 13arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill EducationManagement (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSONSpreadsheet 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:PEARSONBusiness Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSONFundamentals 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