Papa n Mama’s Diner is a family-owned restaurant that opens 24 hours. A waiter can start a shift at 2am, 5am, 8am, 11am, 2pm, 5pm, 8pm, or 11pm, and each shift is 3 hours. The following table shows the minimum number of waiters needed during each 3-hour shift. 3-hour Shift 2A-5A 5A-8A 8A-11A 11A-2P 2P-5P 5P-8P 8P-11P 11P-2A Number of Waiters Required 5 11 8 12 5 13 14 5 Waiters who start working at 11pm or 2am work two consecutive shifts. Otherwise, those who start working at other times work three consecutive shifts. Waiters who work between 8am and 11pm are paid $15 per hour (i.e., $45 per shift), and who work between 11pm and next-day 8am are paid $20 per hour (i.e., 60 per shift). Use Excel to determine how many waiters start working at the beginning of each shift to minimize the daily payroll while meeting the staffing requirements.

Papa n Mama’s Diner is a family-owned restaurant that opens 24 hours. A waiter can start a shift at 2am, 5am, 8am, 11am, 2pm, 5pm, 8pm, or 11pm, and each shift is 3 hours. The following table shows the minimum number of waiters needed during each 3-hour shift. 3-hour Shift 2A-5A 5A-8A 8A-11A 11A-2P 2P-5P 5P-8P 8P-11P 11P-2A Number of Waiters Required 5 11 8 12 5 13 14 5 Waiters who start working at 11pm or 2am work two consecutive shifts. Otherwise, those who start working at other times work three consecutive shifts. Waiters who work between 8am and 11pm are paid $15 per hour (i.e., $45 per shift), and who work between 11pm and next-day 8am are paid $20 per hour (i.e., 60 per shift). Use Excel to determine how many waiters start working at the beginning of each shift to minimize the daily payroll while meeting the staffing requirements.

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

JOHNSON’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 12
Consider the following tasks that must be assigned to four workers on a conveyor-paced assembly line (i.e., a machine-paced line flow). Each worker must perform at least one task. There exists unlimited demand unless stated otherwise. Time to Complete Task (seconds): Task 1: 30 Task 2: 25 Task 3: 15 Task 4: 20 Task 5: 15 Task 6: 20 Task 7: 50 Task 8: 15 Task 9: 20 Task 10: 25 Task 11: 15 Task 12: 20 The current conveyor-paced assembly-line configuration assigns the workers in the following way: • Worker 1: Tasks 1, 2, 3 • Worker 2: Tasks 4, 5, 6 • Worker 3: Tasks 7, 8, 9 • Worker 4: Tasks 10, 11, 12 What is the direct labor content (in seconds per unit)?
The ABC Company is planning a new product line and a new plant to produce the parts for the line. The product line will include 8 different models. Annual production of each model is expected to be 900 units. Each product will be assembled of 180 components. All processing of parts will be accomplished in the new plant. On average, 6 processing operations are required to produce each component, and each operation takes an average of 1 min (including an allowance for setup time and part handling). All processing opera-tions are performed at workstations, each of which includes a production machine and a human worker. The plant operates one shift. Determine the number of (a) components, (b) processing operations, and (c) workers that will be needed to accomplish the processing operations if each worker works 2,000 hr/yr.
A large business process outsourcing company operates 5 days a week (Monday to Friday). The manager estimates that the minimum number of agents requires, a combined on-site and work-from-home (WFH) setup, to provide prompt service: 20 for Monday, 18 for Tuesday, 23 for Wednesday, 28 for Thursday, and 32 for Friday. Labor rules state that each agent must work for 3 days a week on-site. and 2 days in WFH setup. For example. an agent who works on-site Monday to Wednesday must be on WFH setup during Thursday and Friday. Also. the company wants at least 60% of the workforce daily to report on-site. Formulate the appropriate LP model for this problem to minimize the number of agents to be hired.
The Safe Zone Restaurant, a 24-hour restaurant, faces changing requirements from hour to hour. More workers are needed for peak hours, and fewer are needed in between. The following table shows the worker requirement for the first 12 hours in the restaurant: Table 8. Staff Requirement at the Safe Zone Restaurant Time Period 10 11 12 1 PM|2 PM|3 PM|4 PM|5 PM|6 PM 7 PM|8 PM|9 PM АM | АM | РМ Requirement 7 Assigned On Duty Overstaffed 9 10 10 8 6 6. 8 8 12 12 8 a) You are required to apply the first-hour principle to staff each hour with the required number of cafeteria staff, showing how many staff are on duty each given hour, the number of staff you have assigned to work each hour and any overstaffing for each hour. i. Schedule the staff to work in 8-hour shifts. ii. Schedule the staff to work in 4-hour shifts. b) Indicate with at least one reason, which schedule would be more optimal from an Operations Scheduling perspective?
A manufacturing plant produces a product 'A' that requires one unit of 'B' and ½ unit of 'C'. Each unit of 'B' is comprised of one unit of 'D', two units of 'E', and one unit of 'F'. Each unit of 'C' requires ½ unit of 'G' and three units of 'H'. The manufacturing lead times for the components are as follows: 'A' - two weeks, 'B' - one week, 'C' - two weeks, 'D' - two weeks, 'E' - three weeks, 'F' - one week, 'G' - two weeks, 'H' - one week. There are 20 units in stock for each of these components. 100 units of 'A' are needed for delivery in seven weeks: a) Develop the product structure and indexed bill of materials for the product. b) Create a gross and net requirements plan for the manufacturer of the product.
Solve the question below using the attached excel templates with formulas for renting both slow and fast copies (labeled in the excel tabs). Question: The Decision Sciences Department is trying to determine whether to rent a slow or a fast copier. The department believes that an employee’s time is worth $15 per hour. The slow copier rents for $4 per hour, and it takes an employee an average of 10 minutes to complete copying. The fast copier rents for $15 per hour, and it takes an employee an average of six minutes to complete copying. On average, four employees per hour need to use the copying machine. (Assume the copying times and interarrival times to the copying machine are exponentially distributed.) Which machine should the department rent to minimize expected total cost per hour?
The first station can process a unit in 10 minutes First Station capacity = 60/10 = 6 units per hour As the second station has 2 identical machines in parallel, each of which can process a unit in 12 minutes. Each unit needs to be processed on one of the two machines. Second Station Capacity = 60 x 2/12 = 10 units per hour The third station can process a unit in 8 minutes Third Station capacity = 60/8 = 7.5 units per hour What is the hourly capacity of this production line?
A diabetic patient needs at least 40 units of Vit. A, at least 30 units of Vit. C, and atleast 30 units of Vit. E each day. Each brand X multivitamin capsule contains 4 units of Vit. A, 6 units of Vit. C, and 2 units of Vit. E; each brand Y capsule contains 5 units of Vit.A, 3 units of Vit.C, and 5 units of Vit. E. If each brand X capsule costs P6.00 and eachbrand Y capsule costs P9.00, how many capsules should the patient take each day tominimize the costs? Solve using graphical method. Show complete solution.
A machine used for cutting materials in a factory has the following outputs per hour at various speeds and required periodic tool regrinding at intervals cited. Speed Hour Output per Tool RegrindingA 200 pieces every 8 hours B 280 pieces every 5 hours A set of tools costs 560 and can be ground twenty times. Each regrinding costs 54.00 and the time needed to regrind and change tools is 1 hour. The machine operator is paid 35.00 per hour including the time the tool is changed. The tool grinder who also sets the tools to the machine is paid 40.00 per hour. The hourly rate chargeable against the machine is 38.00, regardless of machine speed. Which speed is more ecomical? A. Speed B, 0.096/pc B Speed B, 0.087/pc C. Speed A, .054/pc D. Speed A >037/pc
A 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?
A serial process has 5 steps – A (4), B(5), C(2), D(6), and E(3) – that have to be performed in this order. The numbers in parentheses are the times (in minutes) needed to process a unit. For each unit produced by this process, the process has a total idle time of: Group of answer choices 1 min 10 mins 6 mins 3 mins