eBook Show Me How Office 365 Calculator Predetermined factory overhead rate Novello 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 $283,700 Depreciation expense 84,400 Utilities 47,000 Nurse salaries 339,600 Technician wages 225,300 Total operating room overhead $980,000 The overhead costs will be assigned to procedures based on the number of surgical room hours. Novello 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. Open spreadsheet a. Compute the estimated number of operating room hours for the year. hours b. Determine the predetermined operating room overhead rate for the year. Round your answer to the nearest dollar per hour c. Conrad Goldsmith 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 (b)? Round your answer to the nearest dollar Check My Work Previous Next > All work saved Save and Exit Submit Assignment for Grading 311 Service Representativ.. DES eBook Show Me How Office 365 Calculator pou Nurse salaries 339,600 Technician wages 225,300 Total operating room overhead $980,000 The overhead costs will be assigned to procedures based on the number of surgical room hours. Novello 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. Compute the estimated number of operating room hours for the year. hours b. Determine the predetermined operating room overhead rate for the year. Round your answer to the nearest dollar. per hour c. Conrad Goldsmith 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 (b)? Round your answer to the nearest dollar d. During January, the operating room was used 260 hours. The actual overhead costs incurred for January were $78,900. Determine the overapplied operating overhead or underapplied operating overhead for the period. Enter your answer as a positive number. Round your answer to the nearest dollar. overapplied Feedback Next > Hor Basket Forever 21 Register 311 Service Representativ. Profile Information Retail template Savu Excel View Data Review Help Tell me what you want to do File Insert Home Formulas Number $ - % Paste X Out [h copy Format Painter Clipboard Arial 10 A 29. Wrap Text BIUROA Merge conter Font Alignment Num Undo C24 D E B 2 Using formulas and cell references, perform the required analysis, and input your answers into the Amounts column. Enter underapplied overhead, if any, as a negative value. Transfer the numeric results for the green 21 entry cells (C24, C26, C29, and C33) into the appropriate fields in CNOWV2 for grading. 22 23 Amounts Formulas 24 a. Estimated number of operating room hours 25 26 . Predetermined operating room overhead rate (per hour) 27 28 c. Procedure duration, hours 29 Procedure overhead 30 31 d. Actual operating room usage in January, hours 260 32 Actual operating room overhead incurred, January $78,900 33 Over-lunderapplied operating overhead 34 35 36 37 40 43 45 46 Data + Calon Mode: Automatic WorkbookStatistics esc o # $