please use excel solver and show how to use it and answer the questions

3. The emergency room of MedCare Hospital operates 24 hours a day, 7 days a week. Nurses work five consecutive days a week. The daily nurse requirements for the daytime hours are as given in Table below. Weekday Sun Mon Tues. Wed. Thurs. Fri Sat. Nurses 8 57 56 10 9 Table: Daily Nurse Requirements A five day shift can start any day of the week. A shift that starts on Sunday ends on Thursday. A shift that starts on Friday ends on Tuesday. a. What are the decision variables of the problem? Define them clearly b. Use these decision variables to write the equation that there be a minimum of 10 nurses on duty on Friday. c. Use these decision variables to write the equation that there be a minimum of 7 nurses on duty on Tuesday. d. Formulate an integer programming model that minimizes the number of nurses while satisfying each day's requirement. e. Develop a weekly staffing schedule that can handle the daily demand of the MedCare Emergency Room with the minimum number of nurses. What are the values of the optimal solution? How many nurses are required? Are there any days on which no one starts a shift? f. They have found that they often do not need as many nurses as they thought. If you could reduce the requirements by 1 nurse on one specific day, which day would you choose and why? Reduce that day's total by 1 and demonstrate that the total number required goes down. (The solution is not necessarily unique)