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

 

Evening A B D E F G H J L. M 1 Off Day Sunday Monday Tuesday Wednesday Thursday Friday Saturday Target Morning Scheduled Sunday-Monday Monday-Tuesday Tuesday-Wednesday Wednesday-Thursday Thursday-Friday Friday-Saturday Saturday-Sunday 2 Morning Sunday-Monday le 3 Monday-Tuesday le Tuesday-Wednesday Wednesday-Thursday Thursday-Friday 4 le le le le 6 le 7 Friday-Saturday Saturday-Sunday le 8 le 9 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 >3D 16 le 10 Evening Sunday-Monday 11 Monday-Tuesday Tuesday-Wednesday Wednesday-Thursday le 12 le 13 le Thursday-Friday Friday-Saturday Saturday-Sunday 14 15 le 16 le 17 >= 8 le 18 Night Sunday-Monday Monday-Tuesday 19 le le Tuesday-Wednesday Wednesday-Thursday Thursday-Friday Friday-Saturday 20 21 22 23 24 Saturday-Sunday 25 26 Total 27 28 Minimize 29 30 Off Day Sunday Monday Tuesday Wednesday Thursday Friday Saturday 31 Sunday-Monday 1 1 1 32 Monday-Tuesday 1 1 33 Tuesday-Wednesday 1 1 1 1 1 34 Wednesday-Thursday Thursday-Friday Friday-Saturday 1 1 1 1 35 1 1 1 36 1 1 1 1 1 37 Saturday-Sunday 1 1 1 38 29