Chapter 9, Problem 1

Please provide step by step directions in excel format as pictured below

SOLVE BPH'S PROBLEMS 1. The lab supervisor needs to establish a weekly schedule for the morning shift. Based on distributions of arrival times and service times, she has conducted a queuing analysis and found that the minimal number of lab technicians for each day is the following: UNG STAFF, PATIENTS. AND SORA SA Pay per Technician/Day Tuesday and Wednesday off, Wednesday and Thursday off, etc.). Formulate and solve an integer linear programming model that will determine the number of technicians for each one of the seven schedules while minimizing weekly cost and providing Hint: Define the decision variables as the number of technicians in e necessary capacity and giving each lab technician 2 days off. Day Number of Technicians Needed Monday 6 $160 Tuesday 5 $160 Wednesday 4 $160 Thursday 4 $160 Friday 5 $160 Saturday 6 $240 4 $240 Sunday Each technician is also allowed to take 2 days off every week. Technicians prefer to have 2 consecutive days off. There are therefore seven possible schedules (Monday and Tuesday off, schedule 1, 2, 3, ... the lab supervisor also be for D F G A B M3-06 (Chapter 9, Problem 1) Monday Tuesday Wednesday Thursday Friday Saturday Sunday Total # of Technicians Number Starting on Number Working on 0 0 0 0 0 0 > > > Number Needed on Pay per employee on 1 Cost 2 3 roufaiel: = Total number of employees. Those OFF on Tuesday and Wednesday 4 5 6 8 13. Briefly explain how artificial variability hinders smooth flow SOLVE BPH'S PROBLEMS backlog 3. What is the purpose of staff scheduling? WHAT DO YOU REMEMBER? 1. List and explain three threats to timely care. 2. List and explain the consequences of care delay. 4. How is integer linear programming used to schedule staff? 10. What is individual scheduling? What is its main disadvantage? 11. List and explain the six principles of open-access scheduling. 12. Why is TNA an accurate indicator of a scheduling system's bazuar 7. What is Moore's algorithm and what is its purpose? 8. List and briefly describe three performance measures for job scheduling 9. What is block scheduling? What is its main disadvantage? 5. What is job scheduling? 6. Discuss how each of the following rules works: a. FCFS b. SPT c. EDD d. STR e. CR performance? scheduling. which these requests will be processed, but his pertomatic wated in terms of turnaround time of powes. Ayo uy important. Help Joel find the sequence that will Mos me based on the following data. Try the following RCAS, SPT, EDD, and CR Requests will start ved at the last one's arrival, that is, 65 minutes, the peak times of 10 a.m. to 12 p.m. and 8 pm to 10 p.m. to The lab supervisor wants at least 40% of the phlebotomists be full-time employees. Also, she wants at least two full-time The next day, Joel was assigned six more jobs see problem However, for this set of jobs, Joel's supervisor to him to phlebotomists at full-time shift changes: 6:00 am, 200 pm, minimize tardiness and the number of tardy jobs. Als model to establish a schedule for phlebotomists that will metal and 10 p.m. Formulate and solve an integer linear programming equally important. Try the following rules: FCPS, SVT, EDD.CR. and Moore's algorithm. Requests will start being proceed bet the last one's arrival, that is, 200 minutes. established. All cooks work 12-hour shifts, 4 days in a row, Then they take 3 consecutive days off. There are seven possible number of cooks needed each day of the week as well as the the support specialists. Joel has latitude in deciding the order is Time Beck 1.0m-8 cm 2.80m-100 m 3.100m-12pm 4.12 pm-2pm 5.2 p.m4pm 64 pm-6pm 7.8 pm-8pm 8.8 pm-10pm 9.10pm-12 cm 10 12am-2 am 11.2 am 40m 12. 4 am-6am Number of Phlebotomists Needed 8 10 22 15 12 18 12 22 15 10 8 Arrival Time (min) 15 re Prowing me (i) 100 V50 on 20 30 40 55 120 30 We 29 B 65 F received. Six of those jobs were assigned to Joel Williams, one of requirements while minimizing daily costs. 3. The weekly cafeteria cooking staff schedules need to be schedules (Monday, Tuesday, Wednesday off, Tuesday, Wednesday, Thursday off, etc.) The following table lists the Doy Number of Pay per Cooks Needed Cook/Day Monday 10 $180 Tuesday 12 $180 Wodnesday 14 $180 Thursday 8 $180 Friday 8 $180 Saturday 12 $270 Sunday 14 $270 Formulate and solve an integer linear programming model that will determine the number of cooks in each schedule while minimizing weekly costs and ensuring that minimum capacity needs are met 4. Requests for solutions to billing-related IT problems have been U V Arrival Time (min) 20 80 100 120 150 Processing Time (ml) 60 120 90 45 150 100 180 500 520 2 200 data have Because physicians at a BPH clinic use an EHR system that is not fully interfaced with the system used by the hospital, some patient be manually reinputted into the hospital's system The clerk in charge of this task has just received a list of five patient charges. Their importance is evaluated in terms of their contribution to revenue. The clerk wants to minimize weighted tardiness. The data input will start now, at time 0. Help her find the best sequence to achieve that objective using the FCFS, SPT, EDD, and CR rules. Arrival Time (min) -5 Processing Time Due Date Weig 65 9 C 18 10 20 15 5 12 15 30 20 15 40 -1 10 4. Requests for solutions to billing-related IT problems have been received. Six of those jobs were assigned to Joel Williams, one of the support specialists. Joel has latitude in deciding the order in which these requests will be processed, but his performance is evaluated in terms of turnaround times or flow times. All jobs are equally important. Help Joel find the sequence that will minimize flow time based on the following data. Try the following rules: FCFS, SPT, EDD, and CR. Requests will start being processed after the last one's arrival, that is, 65 minutes. Due Date Request A Arrival Time (min) 15 Processing Time (min) 100 200 150 20 B 60 300 150 250 30 C 120 D 40 400 30 E 55 350 90 F 65