SOLVE USING EXCEL A hospital emergency room needs the following numbers of nurses: Day Monday Tuesday Wednesday Thursday Friday Saturday Sunday Min. number 2 3 4 4 8 7 5 Each nurse should have two consecutive days off. How many full-time nurses are required, and what is a good nurse schedule? Show detailed steps of your solution.

SOLVE USING EXCEL A hospital emergency room needs the following numbers of nurses: Day Monday Tuesday Wednesday Thursday Friday Saturday Sunday Min. number 2 3 4 4 8 7 5 Each nurse should have two consecutive days off. How many full-time nurses are required, and what is a good nurse schedule? Show detailed steps of your solution.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter12: Queueing Models

Section: Chapter Questions

Problem 59P

See similar textbooks

Similar questions

A hospital emergency room needs the following numbers of nurses: Day M T W T F S S Min. number 7 4 6 3 4 5 7 Each nurse should have two consecutive days off. How many full-time nurses are required and what is a good nurse schedule? Round your answer to the nearest whole number. nurses
Assign the 4 departments in Table X to locations A, B, C, and D, which are separated by the distances shown in Table y, in such a way that transportation cost is minimized. Use this heuristic: assign departments with the greatest interdepartmental workflow first. (See attached table) Illustrate the configuration of the 4 departments in each of the 4 locations. Show the distances between departments and total interdepartmental workflows of department pairs.
Determine the optimal allocation of jobs to machines that will maximize totalprofit. The following table shows the profit each job will get from each machine in dollars:Need answer asap. Please include the solution/computation. Thank you.
EU Company manufactures two different types of life vests (A and B) that are manufactured and assembled on three different workstations (W, X, and Y) using a small-batch process (see Figure 1). Batch setup times are negligible. The flowchart denotes the path each product follows through the manufacturing process, and each product’s price, demand per week, and processing times per unit are indicated as well. Purchased parts and raw materials consumed during production are represented by inverted triangles. EU can make and sell up to the limit of its demand per week; no penalties are incurred for not being able to meet all the demand. Each workstation is staffed by a worker who is dedicated to work on that workstation alone and is paid $6 per hour for an entire week, regardless of how much the worker is used. Total labor costs per week are fixed. Variable overhead costs are $1,500/week. The plant operates one 8-hour shift per day, or 40 hours/week. Which of the three workstations, W,…
The operations manager of a body and paint shop has five cars to schedule for repair. The estimates of the times required to do the body and paint work on each are as follows: Using Johnson's Rule to minimize total duration, the correct sequence of these five jobs is; a. DCAEB b. DBECA c. BEACD d. ACEBD Car Body Work (Hours) Paint (Hours) A 8 7 B 9 4 C 7 9 D 3 4 E 12 5
Now 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 minutes
A group of six jobs is to be processed through a two-machine flow shop. The first operation involves cleaning and the second involves painting. Determine a sequence that willminimize the total completion time for this group of jobs. Processing times are as follows:PROCESSING TIME (hours)Job Work Center 1 Work Center 2A 5 5B 4 3C 8 9D 2 7E 6 8F 12 15 To employ Johnson’s rule, create a “blank” sequence first, such as:mhhe.com/stevenson13eEXAMPLE 41st 2nd 3rd 4th 5th 6th
Assign the 4 departments in Table X to locations A, B, C, and D, which are separated by the distances shown in Table y, in such a way that transportation cost is minimized. Use this heuristic: assign departments with the greatest interdepartmental workflow first. See attached table. a.Fill up the table attached. b. Compute the total transportation cost if the cost to move one workload 1 meter apart is P5.00.
Suppose the company has just received an order for 40 mission oak dining room sets. Briefly list the kinds of informationthe company will need to plan, schedule, and process thisjob.
Part A is processed on a MILLING machine; Part B is processed on a LATHE machine. Two parts (A and B) are then assembled on an ASSEMBLY machine. Standard times, scrap rates, efficiency, and availability of each machine and the assembly are given in the table below. Determine the number of milling (M), the lathe (L) and the assembly (A) machines needed to produce 100 good parts from this production system during and 8-hour (480 minutes) shift. (Note: Round up the number of parts processed on each station and then round up the number of machines needed).
Baking dog treats in her kitchen has been a simple process for Emma to manage. She has two ovens, one sink, a refrigerator, and enough room for two people to work at the same time. However, when Emma moves her business out of her home, she will have a commercial kitchen that can accommodate as many as six people working simultaneously. She had never thought of her business as “production” until the real estate agent who showed her the space asked how many production workers she needs to accommodate. At that point, Emma realized she would be running a production system. Even worse, she realized that she had never even visited a manufacturing facility or set foot on a real production floor. How will she ever manage this process?
A1 Credit provides credit information to its customersthroughout the country, 24 hours per day. Credit representativesanswer customer calls and provide information. Based on demandpatterns, the estimated number of representatives needed duringfour-hour time periods of each day are shown in the table. Employees work shift s of eight consecutive hours, and shift scan start at the beginning of any of the six periods shown inthe table. Assume this schedule will be repeated day aft er day,so that someone starting at 8 pm will contribute to the need forrepresentatives in the midnight–4 am time period. Th e supervisorhas been instructed to schedule employees so that all demandscan be met with a minimum possible number of employees.(a) Formulate an LP to minimize the number of representativesneeded.(b) Set up and solve the problem on a spreadsheet.(c) What is the optimal solution? Explain the rationale for thesolution.