please answer this question clearly in Excel with all steps. Thanks

Ride SY ition feasible? Why? in part (b) (drop the fractional mal profit and what are the optimal number of TopLathes and BigPresses? requirements to the model you constructed in part (b). What is the opti 2. Nurse Scheduling. Hospital administrators must schedule nurses so that the hospital's patients are provided adequate care. At the same time, careful attention must be paid ber of nurses required to be on hand for various times of day and days of the week. To ca keeping costs down. From historical records, administrators can project the minimum num- objective is to find the minimum total number of nurses required to provide adequate care. Nurses start work at the beginning of one of the four-hour shifts given below (except for shift 6) and work for 8 consecutive hours. Hence, possible start times are the st of shifts 1 through 5. Also, assume that the projected required number of nurses factors in time for each nurse to have a meal break. Formulate and solve the nurse scheduling problem as an integer program for one day for the data given below. Hint: Note that exceeding the minimum number of needed nurses in each shift is acceptable so long as the total number of nurses over all shifts is minimized. Shift Time Minimum Number of Nurses Needed 10 24 18 12:00 a.m. - 4:00 a.m. 4:00 a.m. - 8:00 a.m. 8:00 a.m. - 12:00 p.m. 12:00 p.m. -4:00p.m. 4:00 p.m. -8:00p.m. 000 8:00 p.m. - 12:00 a.m. 10 23 17 2345 6