I need the answer solved in Microsoft Excel with screenshots of solver and formulas. And please solve the question in the template provided below. And follow the rubric attached at the right of the screenshot as well. (Cost is not needed because Profit is already given)

A hospital outpatient clinic performs four types of operations. The profit per operation, as well as the minutes of X-ray time and laboratory time used, are given in the table below. The clinic has 500 private rooms and 500 intensive care rooms. Type 1 and type 2 operations require a patient to stay in an intensive care room for one day, whereas type 3 and type 4 operations require a patient to stay in a private room for one day. Each day, the hospital is required to perform at least 100 operations of each type. The hospital has set the following goals (listed in order of priority):

Goal 1: Earn a daily profit of at least$100,000.

Goal 2: Use at most 50 hours daily of X-ray time.

Goal 3: Use at most 40 hours daily of laboratory time. Use goal programming to determine the types of operations that should be performed.

$200 $100 $80 Profit X-Ray time (minutes) Lab time (minutes) $150 5 6 4 3 5 4 3 2 Op 1 Op 2 Op 3 Op 4 Performed >= Needed Rooms used Available Private Formulas for Rooms Used Formulas for Achieved Formulas for Net Formulas for Actual (deviations) Values for Already Achieved Solver 8 12 6 21 9 12 Intensive care Goals Achieved Under Over Net Goal Profit X-Ray (hours) Lab (hours) Already achieved Deviations Actual Profit X-Ray Lab