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$299,600Depreciation expense75,000Utilities32,000Nurse salaries278,500Technician wages126,900Total operating room overhead$812,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.

Open spreadsheet (See below)

table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .xl16 {background:white; mso-pattern:black none;} .xl17 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:white; mso-pattern:black none;} .xl18 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:white; mso-pattern:black none; padding-left:18px; mso-char-indent-count:2;} .xl19 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;} .xl21 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none; white-space:normal;} .xl22 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; background:white; mso-pattern:black none;} .xl23 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:204; text-align:center; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none; white-space:normal;} .xl24 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:white; mso-pattern:black none;} .xl25 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:204; text-align:center; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;} .xl26 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:#F4B084; mso-pattern:black none;} .xl27 {font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;} .xl30 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; background:#A9D08E; mso-pattern:black none;} .xl31 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:#A9D08E; mso-pattern:black none;} .xl32 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:white; mso-pattern:black none;} .xl36 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none; background:white; mso-pattern:black none; white-space:normal;} .xl37 {font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:204; text-align:center; vertical-align:middle; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none; white-space:normal;} .xl38 {font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;}

Predetermined factory overhead ratePoehling 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:DATADisposable supplies$299,600Depreciation expense75,000Utilities32,000Nurse salaries278,500Technician wages126,900Total operating room overhead$812,000The 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:DATAHours per day8Days per week7Weeks per year (net of maintenance weeks)50Select 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. AmountFormulasa.Predetermined surgical overhead rate (per hour)b.Number of surgical room hours7Procedure overheadc.Actual hours used in January230Actual surgical room overhead incurred, January$64,400surgical room overhead

Determine the predetermined operating room overhead rate for the year. Round your answer to the nearest dollar.

$fill in the blank 2 per hour

Bill Harris had a seven-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.

$fill in the blank 3

During January, the operating room was used 230 hours. The actual overhead costs incurred for January were $64,400. 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.

$fill in the blank 4