Problem
You are the manager of an infusion center. The center is only open from 9 am - 5 pm and cannot stay open any longer than that due to the lease that you signed.
In the infusion center you have 3 infusion chairs. Only one patient can be in each chair at a time. You don't have any funds in your budget to buy an additional chair.
Each patient's treatment requires them to be in a chair for 2 hours. However, only the first 30 minutes of the treatment requires 1-on-1 attention from a nurse.
You have one full-time nurse who works 40 hours per week, which includes a 1-hour paid lunch. When this nurse works alone, she can see 7 patients per day (see schedule here Download see schedule here).
You have the option to hire a part-time nurse for either 4 or 6 hours per day, if you can show that this will increase the number of patients seen each day.
Task
For this problem, you may use Excel or Word to submit your work.
Your goal is to maximize the number of patients seen in a day.
i. Determine whether you should hire the part-time nurse for 4 hours or 6 hours per day. Indicate the hours that the part-time nurse will work each day.
ii. Provide a schedule that shows the MAXIMUM number of patients that can be seen each day with the full-time and part-time nurse working together.