Please show in excel

To complete this comprehensive exercise, use the Excel spreadsheet program. In this exercise you will be using linear programming and Solver in Excel to solve the problem described in the following scenario. A hospital emergency room is open 24 hours a day. Nurses report for duty at 1 a.m., 5 a.m., 9 a.m., 1 p.m., 5 p.m., or 9 p.m., and each works an 8-hour shift. Nurses are paid the same regardless of the shift they work. The following table shows the minimum number of nurses needed during the six periods into which he day is divided. To complete the comprehensive exercise, formulate and solve the problem using Excel's Solver. Additionally, in your workbook respond to Part A and Part B (listed below). NAME the workbook with your completed work using your last name in the file name-----use: LASTNAME_Mod2_Comp_Exercise_3. Submit the Excel workbook in BlackBoard. Part A: How should the hospital schedule the nurses so that the total staff required for one day's operation is minimized? What is the minimum number of nurses that will be used given your staffing plan? Part B: What constraints are binding constraints? What constraints have slack or surplus? How much slack or surplus