) In a previous version of the book, they included a basic solver exercise that I feel is helpful to begin to see how the solver can work and will help to set the foundation for more complicated uses. There is a file attached here that sets up the problem for you and gives you the instructions on the first sheet. There is an additional file of the pages from the previous version of the book. Note: You will need to use the solver in excel to perform the analysis. If you do not have this in the data tab of excel, you will need to add it in. There are instructions on how to do it in the content for this week. I think the videos are also helpful if you have not used the solver tool before. When running the solver, be sure to highlight the answer report, sensitivity and limits. Please show all of your work

2) For extra points (up to 20 more) Please complete exercise #2: In the DRG case-mix problem above, Vincent Valley Hospital and Health System (VVH) has determined it could convert 15 of the routine beds to ICU beds for a cost