For Famous Healthcare system (FHS), consultants from the Operational and Administrative Department (O&A) determined the average daily patient demand for various nursing professionals. The Medical Unit needs to develop a staffing schedule for the week that has 16 nurses for the morning shift, 8 nurses for the evening shift and 6 nurses for the night shift. Develop a schedule to meet this demand using a 5/40 staffing schedule using the attached template.
Please Use Excel to create schedule
F 1 J L Target D Monday 0 0 0 0 0 0 n 0 0 0 n n 0 n 0 n Sunday 0 n 0 n 0 n 0 0 n 0 0 0 0 0 0 0 n 0 0 0 0 0 0 0 H Friday 0 0 n 0 n 0 0 0 n 0 0 n 0 n n 0 n 0 0 0 0 n 0 n 0 n 0 = 16 E F G Tuesday Wednesday Thursday 0 0 0 0 0 U 0 0 0 0 u 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 n 0 0 0 n 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 n 0 0 0 0 0 0 0 0 0 n 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N Scheduled 0 0 0 0 0 0 0 0 0 n 0 n 0 0 n n 0 n 0 n 0 n 0 n 0 n 0 n 0 A B 1 Off Day 2 Morning Sunday-Monday 3 Monday-Tuesday 4 Tuesday-Wednesday 5 5 Wednesday-Thursday 6 Thursday-Friday 7 Friday-Saturday o 8 Saturday-Sunday 9 10 Evening Sunday-Monday 11 Monday-Tuesday 12 12 Tuesday-Wednesday 13 Wednesday-Thursday 14 Thursday-Friday 15 Friday-Saturday 16 10 Saturday-Sunday 17 18 Night Sunday Monday 19 Monday-Tuesday 20 Tuesday-Wednesday 21 Wednesday-Thursday 22 Thursday-Friday 23 Friday-Saturday 24 24 Saturday-Sunday 25 26 27 28 29 30 Off Day 31 Sunday-Monday 32 Monday-Tuesday 33 Tuesday Wednesday 34 Wednesday-Thursday 35 Thursday-Friday 36 Friday-Saturday 37 Saturday-Sunday 38 29 Saturday 0 U 0 0 0 0 0 0 0 0 n 0 0 0 0 0 0 0 >= 0 n 0 n 0 n 0 0 0 0 0 M Morning Sunday-Monday Monday-Tuesday Tuesday-Wednesday Wednesday-Thursday Thursday-Friday Friday-Saturday Saturday-Sunday Evening Sunday-Monday Monday-Tuesday Tuesday-Wednesday Wednesday-Thursday Thursday-Friday Friday-Saturday Saturday-Sunday Night Sunday-Monday Monday Tuesday Tuesday-Wednesday Wednesday-Thursday Thursday-Friday Friday-Saturday Saturday-Sunday 8 n 0 n 0 n 0 0 n 0 n 0 n 0 n 0 0 0 0 n 0 n 0 n 0 n 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 Total 0 Minimize 0 Monday 0 0 Sunday 0 1 1 1 1 1 0 1 Tuesday Wednesday Thursday 1 1 1 0 1 1 0 0 1 1 0 0 1 1 1 0 1 1 1 1 1 1 Friday 1 1 1 1 Saturday 1 1 1 1 1 0 0 1 1 1 1 0 0 1 F 1 J L Target D Monday 0 0 0 0 0 0 n 0 0 0 n n 0 n 0 n Sunday 0 n 0 n 0 n 0 0 n 0 0 0 0 0 0 0 n 0 0 0 0 0 0 0 H Friday 0 0 n 0 n 0 0 0 n 0 0 n 0 n n 0 n 0 0 0 0 n 0 n 0 n 0 = 16 E F G Tuesday Wednesday Thursday 0 0 0 0 0 U 0 0 0 0 u 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 n 0 0 0 n 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 n 0 0 0 0 0 0 0 0 0 n 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N Scheduled 0 0 0 0 0 0 0 0 0 n 0 n 0 0 n n 0 n 0 n 0 n 0 n 0 n 0 n 0 A B 1 Off Day 2 Morning Sunday-Monday 3 Monday-Tuesday 4 Tuesday-Wednesday 5 5 Wednesday-Thursday 6 Thursday-Friday 7 Friday-Saturday o 8 Saturday-Sunday 9 10 Evening Sunday-Monday 11 Monday-Tuesday 12 12 Tuesday-Wednesday 13 Wednesday-Thursday 14 Thursday-Friday 15 Friday-Saturday 16 10 Saturday-Sunday 17 18 Night Sunday Monday 19 Monday-Tuesday 20 Tuesday-Wednesday 21 Wednesday-Thursday 22 Thursday-Friday 23 Friday-Saturday 24 24 Saturday-Sunday 25 26 27 28 29 30 Off Day 31 Sunday-Monday 32 Monday-Tuesday 33 Tuesday Wednesday 34 Wednesday-Thursday 35 Thursday-Friday 36 Friday-Saturday 37 Saturday-Sunday 38 29 Saturday 0 U 0 0 0 0 0 0 0 0 n 0 0 0 0 0 0 0 >= 0 n 0 n 0 n 0 0 0 0 0 M Morning Sunday-Monday Monday-Tuesday Tuesday-Wednesday Wednesday-Thursday Thursday-Friday Friday-Saturday Saturday-Sunday Evening Sunday-Monday Monday-Tuesday Tuesday-Wednesday Wednesday-Thursday Thursday-Friday Friday-Saturday Saturday-Sunday Night Sunday-Monday Monday Tuesday Tuesday-Wednesday Wednesday-Thursday Thursday-Friday Friday-Saturday Saturday-Sunday 8 n 0 n 0 n 0 0 n 0 n 0 n 0 n 0 0 0 0 n 0 n 0 n 0 n 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 Total 0 Minimize 0 Monday 0 0 Sunday 0 1 1 1 1 1 0 1 Tuesday Wednesday Thursday 1 1 1 0 1 1 0 0 1 1 0 0 1 1 1 0 1 1 1 1 1 1 Friday 1 1 1 1 Saturday 1 1 1 1 1 0 0 1 1 1 1 0 0 1
