Please formulate the problem as AN OPTIMIZATION MODEL only and I will finish the rest. Health Center is planning to open its facilities 24 hours a day and wants to determine an optimal schedule. for their nurses. A nurse's work schedule is 8 hours in a row and can only start at the beginning of each shift. The personnel requirement for each shift is shown in Table 1.Table 1 – Personnel Requirement Table 1 - Personnel RequirementRequiredNursesShiftTime8:00am-12:00pm12:00pm-4:00pm4:00pm-8:00pm8:00pm-12:00am12:00am-4:00am150256360442324:00am-8:00am24Each nurse is paid $100 per hour in the daytime (from 8:00am to 8:00 pm) and $125 at night (from 8:00pm to8:00am on the following day). Consider that each nurse can also work overtime hours. If a nurse worksovertime hours, then she/he will work 4 consecutive hours beyond her/his normal work time, and be paid anadditional 50% for each of the 4 hours. Furthermore, no more than 25% of the nurses can work overtime hoursat each shift. Formulate an optimization model to minimize labor expenses. You must solve the optimizationproblem using either the IBM IL0G CPLEX Optimization Studio or the Microsoft Excel Solver.

Name: Please formulate the problem as AN OPTIMIZATION MODEL only and I will
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: Please formulate the problem as AN OPTIMIZATION MODEL only and I will finish the rest. Health Center is planning to open its facilities 24 hours a day and wants to determine an optimal schedule. for their nurses. A nurse's work schedule is 8 hours in

Answered: Image /qna-images/answer/e13f5b75-59bf-4c4e-a4f0-a62e9ca1096a.jpg

Answered: Formulate an optimization model to…

Business

Operations Management

Formulate an optimization model to minimize labor expenses. You must solve the optimizati either the IBM ILOG CPLEX Optimization Studio or the Microsoft Excel Solver.

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

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.
The Prime Manufacturing Company is a garment factory that employs about 1250 employees of varied skills. About 75 percent are women who are mostly in the production department. Men employees are assigned in the maintenance department and as operators of machines used in garment production. Women are mostly in the sewing department, packaging, and quality control. Mr. Duztin Fernando was hired to head the HR department. Prior to his assignment at Prime Manufacturing Company, Rod was in a construction firm, a medium-sized organization. His main concern was preparing the payroll and handling employees’ records. The Human Resource Department is composed of 5 employees, a payroll clerk, a personnel assistant, two supervisors, and Mr. Duztin Fernando as Manager. The record of Duztin Fernando in his academic achievements is quite satisfactory. His Bachelor’s degree is in the field of Engineering. Performance in the previous employment is quite satisfactory. The…
WAI knows from historical records that approximately 40percent of its labor is used in Department 101 and 60 percentis used in Department 102. Th e reverse is true of machine time;60 percent is used in Department 101 and 40 percent is used inDepartment 102.(a) Calculate the labor and machine hours needed inDepartment 101 for each period of the MPS developed inProblem 4.(b) Calculate the labor and machine hours needed inDepartment 102 for each period of the MPS developed inProblem 4.
Which of the following relates to How many employees should be scheduled? 1.Group of answer choices 2.Operations Planning 3.Operations Process 4.Capacity Planning 5.Production-Method Decisions
Climate Control, Inc., makes expedition-quality rain gearfor outdoor enthusiasts. Management prepared a forecast ofsales (in suits) for next year and now must prepare a produc-tion plan. The company has traditionally maintained a levelworkforce strategy. All nine workers are treated like familyand have been employed by the company for a number ofyears. Each employee can produce 2,000 suits per month.At present, finished goods inventory holds 24,000 suits. Thedemand forecast follows: Use the Sales and Operations Planning with SpreadsheetsSolver in OM Explorer or develop your own spreadsheetmodels to address the following questions. a. Management is willing to authorize overtime in pe-riods for which regular production and current lev-els of anticipation inventory do not satisfy demand.However, overtime must be strictly limited to no morethan 20 percent of regular-time capacity. Managementwants to avoid stockouts and backorders and is notwilling to accept a plan that calls for shortages.…
Chelsea Jacobson awaited the arrival of her bed and dresser one Saturday in September. She’dpurchased the items in the IKEA Brooklyn store twelve days before, and couldn’t wait to finally bedone with sleeping on the floor of her apartment. She needed to be well rested as she headed toher writing job in Hell’s Kitchen.Although she’d been given a delivery window for the furniture to arrive, her bed and dresser never came.She contacted the shipping company, XPO Logistics, to get an update on the status of her items, butXPO notified her that IKEA had never supplied the order. Jacobson contacted IKEA numerous timesand eventually found out it could take an additional 4-6 weeks for her items to arrive, as they had been misplaced.Jacobson joins the ranks of customers who have fallen victim to IKEA’s troubled customer service.After attempts to contact the company via email and phone proved unsuccessful, she turned toTwitter to voice her complaints and warn others, only to find thousands of…
onsider an outpatient surgery center that is located in a rectangular building that is 90 feet by 50 feet. There are six departments, each of which is 30 feet by 25 feet in size. Using the "Patient Traffic per Week" matrix. Registration Exam Operating Recovery Labs/Tests X-ray Registration 0 130 30 0 60 20 Exam 0 0 110 40 30 25 Operating 0 0 0 100 10 10 Recovery 0 0 0 0 5 15 Labs/Test 0 0 0 0 0 15 X-ray 0 0 0 0 0 0 a. Determine the total cost per week of the following initial layout. Assuming it cost $4 to move patients between adjacent rooms. Use rectilinear distances Registration X-ray Exam Operating Labs/Tests Recovery b. Design the effective layout that produces the minimum cost per week. show breakdown of work
Tasty Tim’s Tasty Tim’s is a specialty taco restaurant. The following tasks are required for the successful assembly of a Tasty taco (times are in seconds per taco): Chop and trim meat – 30 Chop vegetables – 20 Grill meat – 240 Grill vegetables – 180 Prepare toppings - Lettuce - 10 - Tomato - 15 - Guacamole - 40 Assemble taco - Add meat - 5 - Add vegetables - 5 - Add cheese - 5 - Add toppings - 10 Wrap taco - 20 During the lunch hour, Tasty Tim’s encounters demand for 120 tacos. What is the labor content of one of Tasty Tim’s tacos?
Tasty Tim’s Tasty Tim’s is a specialty taco restaurant. The following tasks are required for the successful assembly of a Tasty taco (times are in seconds per taco): Chop and trim meat – 30 Chop vegetables – 20 Grill meat – 240 Grill vegetables – 180 Prepare toppings - Lettuce - 10 - Tomato - 15 - Guacamole - 40 Assemble taco - Add meat - 5 - Add vegetables - 5 - Add cheese - 5 - Add toppings - 10 Wrap taco - 20 During the lunch hour, Tasty Tim’s encounters demand for 120 tacos. A) What is the labor content of one of Tasty Tim’s tacos? B) What is the Takt time (in seconds/unit) takt time for Tasty Tim’s taco shop? C) In an ideal world, how many workers should Tim hire to make tacos? D) During off-peak afternoon hours, demand at Tasty Tim’s drops to 40 tacos each hour. How many employees should Tim schedule to work during the afternoon? Again, ignore any effects of idle time or inefficiency due to poor line balancing.
the following are come accounts pertaining to the rooms division od XYZ Inn. salaries and wages $10,000 operating supplies $5,000 sales $200,000 laundry $9,000 commissions $2,000 dry cleaning $500 uniforms $200 fringe benefits and payroll taxes 10% of salaries and wages other expenses 3% of sales 1. using the information provided above, what would the total salaries, wages, service charges, contracted labor and bonuses be equal to on the rooms department schedule for XYZ Inn? 2. using the information provided above, what would the total payroll-related expenses be equal to on the rooms department schedule for XYZ Inn? 3. Using the information provided above, what would the total rooms revenue be equal to on the rooms department schedule for XYZ Inn? 4. Using the information provided above, what would the total expenses be equal to on the rooms department schedule for XYZ Inn? 5. Using the information provided above, what would the total labor costs and related expenses be equal…
HRD System at PT. Angin Ribut wants to add a sub system to handle employee leave and overtime. The leave allowance provided by PT Angin Ribut is 12 days per year, however each year it will increase by 1 day until the maximum leave allowance reaches 20 days. Leave can be taken per half day. More than three hours will count as half a day. Overtime process is similar to leave, can be taken per half day. Every time an employee applies for leave, he must get approval from his immediate supervisor. If approved, the annual leave allowance will be reduced according to the number of days on the leave request. For each agreement on overtime, the employee's leave allowance will increase according to the number of overtime days in the employee's request. An administrator is responsible for granting leave per year. The leave allowance will be forfeited if it is not used until March of the following year, except with the approval of the President Director, the leave allowance can be extended. The…
The balance in Supplies before adjustment is $1,900. A physical count reveals $300 of supplies on hand on December 31, 2020. Account Names DR CR Blank 1. Fill in the blank, read surrounding text. Blank 2. Fill in the blank, read surrounding text. Blank 3. Fill in the blank, read surrounding text. Blank 4. Fill in the blank, read surrounding text. Blank 5. Fill in the blank, read surrounding text. Blank 6. Fill in the blank, read surrounding text. Blank 7. Fill in the blank, read surrounding text. Blank 8. Fill in the blank, read surrounding text. Blank 9. Fill in the blank, read surrounding text. Blank 10. Fill in the blank, read surrounding text. Blank 11. Fill in the blank, read surrounding text. Blank 12. Fill in the blank, read surrounding text. Show any calculations Blank 13. Fill in the blank, read surrounding text. Mark for Review What's This?