I don't know this question in Excel please help me in solving this

1. (5 points) A hospital in Brampton, Ontario needs to determine how many nurses to hire to cover a 24- hour period. The nurses must work & consecutive hours but can start work at the start of 6 different shifts. They are paid different wages depending on when they start their shifts. The number of nurses required per 4-hour time period and their wages are shown in the following table. Time period Required # of Nurses Wage ($/hr) 12 am - 4 am 20 15 4 am - 8 am 30 16 8 am - 12 pm 40 12 pm - 4 pm 50 4 pm - 8 pm 40 8 pm - 12 am Formulate the LP and solve the problem using Excel Solver