Each day, workers at an emergency department work two 6-hour shifts chosen from 12 A.M. to 6 A.M., 6 A.M. to 12 P.M., 12 P.M. to 6 P.M., and 6 P.M. to 12 A.M. the following number of workers are needed during each shift: 12 A.M. to 6 A.M.- 19 workers; 6 A.M. to 12 PM- 6 workers; 12 PM. to 6 P.M. - 12workers; 6 P.M. to 12 A.M. – 9 workers. Workers whose two shifts are consecutive are paid $15 per hour; workers whose two shifts are not consecutive are paid $25per hour. Formulate an LP that can be used to minimize the cost of meeting the daily emergency department requirement.

Each day, workers at an emergency department work two 6-hour shifts chosen from 12 A.M. to 6 A.M., 6 A.M. to 12 P.M., 12 P.M. to 6 P.M., and 6 P.M. to 12 A.M. the following number of workers are needed during each shift: 12 A.M. to 6 A.M.- 19 workers; 6 A.M. to 12 PM- 6 workers; 12 PM. to 6 P.M. - 12workers; 6 P.M. to 12 A.M. – 9 workers. Workers whose two shifts are consecutive are paid $15 per hour; workers whose two shifts are not consecutive are paid $25per hour. Formulate an LP that can be used to minimize the cost of meeting the daily emergency department requirement.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

You work as the administrative manager in charge of the operations of the medical services office that brings together over 10 specialists from different health fields. Each specialist has about 5 administrative employees who help with coding, billing, customer service, and other administrative tasks. You supervise all administrative employees. For two months you have noticed that a series of conflicts have arisen between the employees you supervise, which you must address promptly to avoid escalation. These are the conflicts that have been identified: A new position has been opened to supervise night operations and two of the employees have requested it. However, both have resorted to demonstrating that the other does not have the capabilities to rise to the position. These interpersonal differences have resulted in a tense work environment.It has been rumored that one of the medical specialists is going to retire, so it is possible that he will put the five administrative employees…
Rollmore, a non-union manufacturing company decides it needs input on improving its work processes and procedures and decides to create employee committees to provide general feedback about things such as work rules and organizational policies and practices in hopes of improving efficiency. Rollmore asks ten employees to serve on such committees. Rollmore asks these employees to bring to their meetings, which include management representatives, concerns and ideas from their coworkers. Rollmore schedules these committees to meet once a month for two hours and provides lunch and a conference room for the participants. Are these employee committees legal or illegal? Why or why not?
Fatema, Mariam, and Layan are three dental hygienists who work for Dr. Amnah at Family Dentistry. All three hygienists do pretty much the same thing every day. On an average, they see 12 people every day for regular teeth cleaning which involves cleaning, flossing, and normal checkup. Dr. Amnah, on the other hand, has quite unpredictable job. She has to respond to all types of teeth-related emergencies including having to do surgeries. All three hygienists always try to help each other out, have a very good attitude in general toward each other, and keep each other informed about matters that are relevant to them and to Dr. Amnah. Fatema specifically takes on the role of attending all community-related voluntary meetings and functions where Family Dentistry may have a stake or are asked for involvement. On her own time, she keeps up on all dental regulations and business-related news that may have an impact on the firm. Mariam speaks up and offers constructive suggestions regarding…
state whether or not each situation would be considered “compensable time” (and why or why not). Toby works as Call Center Representative. He works from 7am – 4:30am, Monday – Friday with 30minutes for lunch. He also typically takes several “mini-breaks” during the day to smoke. These breakstypically range from 5-10 minutes in length and he would typically take at least, one in the morning andone in the afternoon. Toby prefers to eat his lunch at his desk, however he also tends to answerquestions from his manager and even his co-workers throughout his lunch, because he is the seniorrepresentative on that team. This occurred for at least a year. Toby recently was let go because due toa downsizing in the department. Toby called his former manager, Kelly and stated that he was owed 30minutes of pay for the past year because technically he was doing work while eating. Kelly stated thatthis was not correct, he was on a lunch break and answering questions was completely voluntary. Shewent on…
b. The Healthy Food Restaurant, a 24-hour restaurant, faces changing requirements from hour tohour. More workers are needed for peak hours, and fewer are needed in between. The followingTable 6 (below) shows the worker requirement for the first 12 hours in the restaurant:Table 6. Staff Requirement at the Healthy Food RestaurantTime Period 10AM11AM12PM1PM2PM3PM4PM5PM6PM7PM8PM9PMRequirement 8 10 12 12 9 7 6 7 9 10 12 8AssignedOn DutyOverstaffed8(i) You are required to apply the first-hour principle to staff each hour with the required number ofcafeteria staff, showing how many staff are on duty each given hour, the number of staffyou have assigned to work each hour and any overstaffing for each hour. i. Schedule the staff to work in 8-hour shifts.
Diablo Electronics manufactures four unique products (A, B, C, and D) that are fabricated and assembledin five different workstations (V, W, X, Y, and Z) using a small batch process. Each workstation is staffedby a worker who is dedicated to work a single shift per day at an assigned workstation. Batch setuptimes have been reduced to such an extent that they can be considered negligible. A flowchart denotesthe path each product follows through the manufacturing process as shown in Figure 5.2, where eachproduct’s price, demand per week, and processing times per unit are indicated as well. Inverted trianglesrepresent purchased parts and raw materials consumed per unit at different workstations. Diablo canmake and sell up to the limit of its demand per week, and no penalties are incurred for not being able tomeet all the demand.Which of the five workstations (V, W, X, Y, or Z) has the highest utilization, and thus serves as the bottle-neck for Diablo Electronics?
A diabetic patient needs at least 40 units of Vit. A, at least 30 units of Vit. C, and at least 40 units 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 each brand Y capsule costs P9.00, how many capsules should the patient take each day to minimize the costs?
The Mountain Springs Water Company has two departments, Purifying and Bottling. The Bottling Department received 69,480 liters from the Purifying Department. During the period, the Bottling Department completed 66,940 liters, including 2,750 liters of work in process at the beginning of the period. The ending work in process was 5,290 liters. How many liters were started and completed during the period??????????????????????? liters started and completed
Karen Valdez is a call center agent of Ringing Telecom Company. She was one of the performing employees for the month of January to October. She constantly achieved her daily target sales and solved customer complaints with satisfaction. She's in giving her ideas, dislikes and likes to her co-workers and to her supervisor that causes her to some disagreements with her supervisor Ms. Linda Lindo. Since then, the Sales Specialist of Ringing Telecom Company didn’t favor her views on handling administrative tasks because the company claimed that Karen had some errors and mistakes in her reports. At the end of November, Ms. Linda conducted and used Graphic Rating Scale in evaluating her subordinates. Karen Valdez got 'Satisfactory Rating', that made Karen wondered why she was rated that way. Ms. Linda claimed that all she knew was to handle customer complaints, selling and some administrative tasks. However, in Karen's defence, she mentioned that Ms. Linda Lindo didn't inform her about the…
How to develop an LP spreadsheet model that relates five-day shift schedules to daily numbers of employees available?
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.
Richard has been a highly regarded employee of the Brier Corporation for almost 20 years. Her loyalty to the company is reflected in her dedication to her job as general accounting clerk from which she has not taken a vacation in almost 12 years. the Brier Corp to reduce its work force through attrition, control salary expenses and become more efficient and competitive. The following describes Richard’s responsibilities. Because of her dedication and long tenure, she has acquired many related responsibilities, which has allowed Richard receives copies of credit sales orders from the sales department. From these documents she accesses the AR subsidiary ledger from her office computer and records the AR. She then records the sale in the sales journal and posts the transactions to the general ledger accounts. Cash receipts in payment of customer AR come directly to her office. She records the cash receipts in the GL cash and AR accounts and updates the AR subsidiary ledger. She then…