Minimize labor cost in a nursing home with solver
A nursing home wants to minimize costs. A RN costs the nursing home $50 an hour, while a Licensed practical nurse(LPN) costs $35 an hour. For every 3 LPN's on the floor, an RN must also be present.
A physical therapist (PT) costs the nursing home $55/hr while a PTA (physical therapy assistant) costs $40. For every 3 PTA's on the floor, a PT must also be present.
A therapist and a nurse can have up to 8 patients on their floor.
Currently there are 48 patients in the nursing home
Minimize costs using solver.