Question

Please I need more explanation and details for this question.

A nurse manager in an urgent care clinic must develop a weekly schedule for nursing staff. Nurses in the clinic work four days a week with three consecutive days off. The staff requirement is twenty nurses each day. Solve this problem using Excel Solver.

Answer 1

Formulation

Solver inputs:

Solution:

	Mon	Tue	Wed	Thu	Fri	Sat	Sun
Report on	5	5	5	5	5	5	5
Total	1	1	1	1	1	1	1	35
s.t.
Mon	1				1	1	1	20	>=	20
Tue	1	1				1	1	20	>=	20
Wed	1	1	1				1	20	>=	20
Thu	1	1	1	1				20	>=	20
Fri		1	1	1	1			20	>=	20
Sat			1	1	1	1		20	>=	20
Sun				1	1	1	1	20	>=	20

So, a total of 35 nurses will be required and a group of 5 will report each day of the week.