[Solved]: Topic : Optimize Workforce Planning in Hospital…

Topic : Optimize Workforce Planning in Hospital Efficient workforce planning is essential for hospitals to effectively manage their operations, given the diverse range of roles within healthcare practitioners and support occupations. In this study, we aim to optimize workforce planning for hospitals while meeting all the demands of work performed by different healthcare occupations. Objective: Minimize the wages paid. Constraint 1: Staffing requirements. All patient demands must be satisfied. Constraint 2 : Maximum working hours per day can’t exceed the national average. (For example, if a physician (healthcare practitioner) works on Monday, they can not work more than 8.78 hours.) Constraint 3 : Minimum working days. To ensure employee retention, a minimum of 5 consecutive working days per week is required. Constraint 4: Maximum working hours per week. Each staff member must rest for 2 days after 5 consecutive working days. Data 1. Different types of healthcare occupations (US Bureau of Labor Statistics) a. Healthcare practitioner includes – Physicians and surgeons – Registered nurses – Licensed practical and licensed vocational nurses – Physical therapists – Dentists – Pharmacists – Physician assistants – Emergency medical technicians and paramedics – Medical records and health information technicians b. Healthcare support occupation includes – Physical therapist assistants and aides – Dental assistants – Medical assistants 2. Average hours worked by different healthcare occupations (US Bureau of Labor Statistics) Occupation Avg hours of work on weekday Avg hours of work on On weekend Healthcare practitioner 8.78 6.5 Healthcare support occupation 7.94 7.31 3. Average wages for each healthcare occupation (US Bureau of Labor Statistics) Occupation Hourly Wage ($) Physicians and surgeons $162.66 Registered nurses $46.55 Licensed practical and licensed vocational nurses $26.63 Physical therapists $50.25 Dentists $74.20 Pharmacists $69.36 Physician assistants $63.74 Emergency medical technicians and paramedics $23.32 Medical records and health information technicians $33.46 Physical therapist assistants and aides $28.91 Dental assistants $24.88 Medical assistants $22.00 4. Number of patients treated on weekdays and weekends for various departments a. Surgery i. Avg 50 patients per day on weekdays (Mon,Tues,Wed,Thurs,Fri) ii. Avg 10 patients per day on weekends (Sat,Sun) b. Treatment i. Avg 200 patients per day on weekdays ii. Avg 50 patients per day on on weekends c. Physical Therapy i. Avg 65 patients per day on weekdays ii. Avg 25 patients per day on weekends d. Dental i. Avg 30 patients per day on weekdays ii. Avg 10 patients per day on weekends e. Pharmacy i. Avg 175 patients per day on weekdays ii. Avg 90 patients per day on weekends f. Emergency i. Avg 20 patients per day on weekdays ii. Avg 20 patients per day on weekends 5. Staffing requirements for 1 patient in each department a. Surgery i. 1 surgeon ii. 2 registered nurses iii. 2 licensed practical nurse iv. 1 physician assistant v. 1 medical assistant b. Treatment i. 1 physician ii. 2 registered nurses iii. 1 licensed practical nurse iv. 1 medical assistants c. Physical Therapy i. 1 physical therapist ii. 1 physical therapist assistant d. Dental i. 1 dentist ii. 2 dental hygienists iii. 1 dental assistant e. Pharmacy i. 1 pharmacist ii. 2 pharmacy technicians f. Emergency i. 1 physician ii. 3 emergency medical technicians iii. 2 paramedics iv. 1 registered nurses v. 1 licensed practical nurse 6. Avg minutes patients stay at hospital a. Surgery i. 60 minutes b. Treatment i. 15 minutes c. Physical Therapy i. 30 minutes d. Dental i. 20 minutes e. Pharmacy i. 5 minutes f. Emergency i. 45 minutes 7. There must be 10 Medical records and health information technicians each day