Use excel to answer the question and fill in answer to the excel sheet

A hospital outpatient clinic performs four types of operations. The profit per operation, as well as the minutes of Xray time and laboratory time used, are given as follows: 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: Eam 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. The hospital believes that the weights for these goals are 1, 300, and 200. These weights also incorporate scaling. You can interpret these weights as, for example, 1 hour over deviation from goal 2 is worth $300. Use goal programming to determine the types of operations that should be performed. Op 1 Op 2 Op 3 Op 4 Operations Performed Under dev over dev Profit X-Ray (hours) Lab (hours) objective value (weighted average) A hospital outpatient clinic performs four types of operations. The profit per operation, as well as the minutes of Xray time and laboratory time used, are given as follows: 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: Eam 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. The hospital believes that the weights for these goals are 1, 300, and 200. These weights also incorporate scaling. You can interpret these weights as, for example, 1 hour over deviation from goal 2 is worth $300. Use goal programming to determine the types of operations that should be performed. Op 1 Op 2 Op 3 Op 4 Operations Performed Under dev over dev Profit X-Ray (hours) Lab (hours) objective value (weighted average)