x CengageNOWv2 | Online teach x Excel Online Student Work Poehling Medical Center Has A | + v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress=false Content Chapter 16 Extra Credit 1. EX.16-11.EXCEL.ALGO Progress: 1/1 items Assignment Score: 0.0% eBook Show Me How Office 365 Predetermined factory overhead rate Poehling Medical Center has a single operating room that is used by local physicians to perform surgical procedures. The cost of using the operating room is accumulated by each patient procedure and includes the direct materials costs (drugs and medical devices), physician surgical time, and operating room overhead. On January 1 of the current year, the annual operating room overhead is estimated to be: Disposable supplies Depreciation expense Utilities Nurse salaries Technician wages Total operating room overhead $247,900 62,100 26,500 230,500 105,000 $672,000 The overhead costs will be assigned to procedures, based on the number of surgical room hours. Poehling Medical Center expects to use the operating room an average of eight hours per day, seven days per week. In addition, the operating room 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. X Open spreadsheet a. Determine the predetermined operating room overhead rate for the year. Round your answer to the nearest dollar. Check My Work nor hour Save and Exit Submit Assignment for Grading