9:17 Problem Set: Module 2 1. EX.03.06 ALGO 2 EX.02.13.BLANKSHEET.ALGO 3. TMM 02.03 17 4. EX 02 11 EXCEL ALGO 5. EX.03.05 ALGO 6. EX 03.03.BLANKSHEET ALCO engagenow.com ® ON Disposable supplies Depreciation expense + Open spreadsheet 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: Nurse salaries Technician wages Total operating room overhead all 71% > 39 $309,900 77,500 33,100 288,100 131,300 $840,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. a. Determine the predetermined operating room overhead rate for the year. Round your answer to the nearest dollar. $ 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. c. During January, the operating room was used 220 hours. The actual overhead costs incurred for January were $63,800. 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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%
Please answer all parts. Last part multiple choice: Underapplied Or overapplied
9:17
Problem Set: Module 2
1. EX.03.06.ALGO
2. EX.02.13.BLANKSHEET.ALGO
3. TMM.02.03
4. EX.02.11.EXCEL ALGO
cengagenow.com
5. EX.03.05.ALGO
6. EX.03.03.BLANKSHEET.ALGO
+
Disposable supplies
Depreciation expense
Utilities
Nurse salaries
Open spreadsheet
actory 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:
Technician wages
Total operating room overhead
$
$309,900
77,600
33,100
ن %71 ||..
288,100
131,300
$840,000
39
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.
>
a. Determine the predetermined operating room overhead rate
for the year. Round your answer to the nearest dollar.
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.
c. During January, the operating room was used 220 hours. The
actual overhead costs incurred for January were $63,800.
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.
Transcribed Image Text:9:17 Problem Set: Module 2 1. EX.03.06.ALGO 2. EX.02.13.BLANKSHEET.ALGO 3. TMM.02.03 4. EX.02.11.EXCEL ALGO cengagenow.com 5. EX.03.05.ALGO 6. EX.03.03.BLANKSHEET.ALGO + Disposable supplies Depreciation expense Utilities Nurse salaries Open spreadsheet actory 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: Technician wages Total operating room overhead $ $309,900 77,600 33,100 ن %71 ||.. 288,100 131,300 $840,000 39 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. > a. Determine the predetermined operating room overhead rate for the year. Round your answer to the nearest dollar. 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. c. During January, the operating room was used 220 hours. The actual overhead costs incurred for January were $63,800. 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.
X template
3
4
5
6
7
8
1 Predetermined factory overhead rate
2
11
12
9
10 Technician wages
29
30
31
32
33
34
35
36
37
38
39
40
13
14
15
16 Hours per day
41
42
A
43
44
45
46
47
48
49
50
51
52
53
54
55
9:17
56
57
58
59
60
61
62
63
64
65
66
17
Days per week
18 Weeks per year (net of maintenance weeks)
19
67
68
28. Actual hours used in January
69
70
Disposable supplies
Depreciation expense
Utilities
Nurse salaries
22
23 a. Predetermined surgical overhead rate (per hour)
24
25 b. Number of surgical room hours
26 Procedure overhead
27
71
72
✪ about:blank
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:
73
74
75
76
77
78
Total operating room overhead
Select the correct answer in the dropdown in call B30. Using formulas and call references, perform the
required analysis, and input your answers into the Amount column. Transfer the numeric results for the green
20 entry cells (D23, D26, and D30) into the appropriate fields in CNOWV2 for grading.
21
>
DATA
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:
DATA
Data +
Actual surgical room overhead incurred, January
000
$309,900
77,600
33, 100
288,100
131,300
$840,000
E
7
50
surgical room overhead
Amount
ON
O
+
6
220
$63,800
Formulas
د %72 ...
40
G
Edit ...
H
I
Transcribed Image Text:X template 3 4 5 6 7 8 1 Predetermined factory overhead rate 2 11 12 9 10 Technician wages 29 30 31 32 33 34 35 36 37 38 39 40 13 14 15 16 Hours per day 41 42 A 43 44 45 46 47 48 49 50 51 52 53 54 55 9:17 56 57 58 59 60 61 62 63 64 65 66 17 Days per week 18 Weeks per year (net of maintenance weeks) 19 67 68 28. Actual hours used in January 69 70 Disposable supplies Depreciation expense Utilities Nurse salaries 22 23 a. Predetermined surgical overhead rate (per hour) 24 25 b. Number of surgical room hours 26 Procedure overhead 27 71 72 ✪ about:blank 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: 73 74 75 76 77 78 Total operating room overhead Select the correct answer in the dropdown in call B30. Using formulas and call references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric results for the green 20 entry cells (D23, D26, and D30) into the appropriate fields in CNOWV2 for grading. 21 > DATA 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: DATA Data + Actual surgical room overhead incurred, January 000 $309,900 77,600 33, 100 288,100 131,300 $840,000 E 7 50 surgical room overhead Amount ON O + 6 220 $63,800 Formulas د %72 ... 40 G Edit ... H I
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Database management system (DBMS)
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education