I need an excel solver solution. Thank you in advance.

on Thursday, Friday and Saturday later in the week. Remember all weeks are the same Shouldice Hospital 2020 The Shouldice Hospital specializes in hemia operations. They have a special procedure that not only has a much higher rate of long-term success than other hospitals, but also allows patients to be in and out in exactly four (4) days. All patients are operated on the morning after their scheduled arrival. (All arrivals are scheduled.) As such a patient admitted Monday afternoon will be operated on Tuesday and will go home Friday morning. That person stays in the hospital Monday through Thursday nights. The hospital currently has $9 beds. Therefore, it can only have at any one time 89 patients staying overnight. The hospital currently performs operations five days a week, Monday through Friday. There are enough operating rooms and teams of doctors and nurses to perform at most 35 operations on any given day for which operations are scheduled The hospital is open seven days a week Although the hospital currently admit: 22 patients each day from Sunday through Thursday for a total of 110 patients, it suspects it can admit more in a week. A better plan may admit more on some days and less on others, but the total will be more. 1. Formulate a Decision Model that would determine the maximum number of patients that can have this operation in a week. Run your model to find the maximum number of patients per week. How many would be admitted on each day of the week 2. Shouldice would like to increase the number of patients it can handle. How many more patients could it handle per week if it added 10 bede? 3. Instead of more beds, Shouldice is considering hiring enough additional doctors and nurses to increase the number of Monday to Friday operations they could do each day to 40 (assume 89 beds.) How many more patients would that allow them to handle each week? 4. Shouldice is considering bringing in enough crews on Saturday to perform 20 operations along with adding 10 beds. How many more patients per week would this enable the hospital to handle ascome 99 beds and 35 operations per weekday)? 5. Because of recent improvements, Shouldice now has the ability to release half the patients after a 3 day stay. The other half stays the full four days. That is, exactly one half of each day's input stays 3 days and the other half stays 4 days. (Assume 89 beds and 40 weekday operations.) Hint: Model one week. Assume all weeks are the same, so the "carryover" from one week to the next is the same as the "carryover" from the last week to this week. As such "wrap around" the carryover. As such if you model the week as starting on Sunday. the people who stay over Sunday night arrived that day (Sunday) and each of the three days before Sunday. Since you started your model on Sunday, the number of patients who stay over the first Sunday are that day's arrivals plus the arrivals