will be shut down two weeks per year for general repairs. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine the predetermined operating room overhead rate for the year. Round your answer to the nearest dollar. X per hour b. Bill Harris had a six-hour procedure on January 22. How much operating room overhead would be charged to his procedure, using the rate determined in part (a)? Round your answer to the nearest dollar. $ positive number. Round your answer to the nearest dollar. A B C On January 1 of the current year, the annual operating room overhead is estimated to be: The overhead costs will be assigned to procedures, based on the number of surgical room hours. The number of hours per day and days per week that Poehling Medical Center expects to use the operating room and the number of weeks per year for general repairs are provided below: Select the correct answer in the dropdown in cell B30. Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric results for the green entry cells (D23, D26, and D30) into the appropriate fields in CNOWv2 for grading