PLEASE CLEARLY SHOW ALL EXCEL CALCULATIONS AND STEPS IN EXCEL!! THANK YOU

6. (20 pts) VVH wants to determine the optimal case mix for diagnosis-related groups(DRGs) that will maximize profits. Limited resources (e.g., space, qualified employees) are available to serve patients classified in the various DRGs, and minimum levels of service (number of cases) must be achieved for each DRG. (1) Formulate linear optimization problem. Is non-negativity constraint required in this problem? (2) Use Excel's solver to find optimal cases for each DRG with Q6.xlsx file. Use name manager function to define blocks contain constraints, decision variables and coefficients. (3) Answer below questions. Hint: use Excel Solver's sensitivity report. (a) How the total profit would be if VVH add one ICU bed day? (b) How the total profit would be if VVH decides to take one more Birth/Delivery case? (c) Currently, VVH earns $2,500 margin from Coronay Surgery. What is the maximum discount amount VVH can offer in Coronay Surgery