FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
Bartleby Related Questions Icon

Related questions

Question

Info in image "ACC PT1" can be used for image "ACC PT2"

2. Change all of the numbers in the data area of your worksheet so that it looks like this:
A
C
1
Chapter 3: Applying Excel
3
Data
4
Allocation base
Machine-hours
Estimated manufacturing overhead cost
2$
713,400
6.
Estimated total amount of the allocation base
87,000 machine-hours
7
Actual manufacturing overhead cost
2$
695,900
8
Actual total amount of the allocation base
86,000 machine-hours
If your formulas are correct, you should get the correct answers to the following questions.
(a) What is the Predetermined overhead rate? (Round your answer to 2 decimal places.)
Predetermined overhead rate
$
8.20 per machine-hour
(b) By how much is the manufacturing overhead underapplied or overapplied?
Overapplied
manufacturing overhead
$
9,300
%24
expand button
Transcribed Image Text:2. Change all of the numbers in the data area of your worksheet so that it looks like this: A C 1 Chapter 3: Applying Excel 3 Data 4 Allocation base Machine-hours Estimated manufacturing overhead cost 2$ 713,400 6. Estimated total amount of the allocation base 87,000 machine-hours 7 Actual manufacturing overhead cost 2$ 695,900 8 Actual total amount of the allocation base 86,000 machine-hours If your formulas are correct, you should get the correct answers to the following questions. (a) What is the Predetermined overhead rate? (Round your answer to 2 decimal places.) Predetermined overhead rate $ 8.20 per machine-hour (b) By how much is the manufacturing overhead underapplied or overapplied? Overapplied manufacturing overhead $ 9,300 %24
3. Either print or make a copy of your worksheet in your workbook before proceeding. You will need to refer back to this worksheet.
Change the estimated total amount of the allocation base to 82,000 machine-hours, but keep everything the same as in Requirement
2. The data area of your worksheet should now look like this:
A
C
1
Chapter 3: Applying Excel
2
3
Data
4
Allocation base
Machine-hours
Estimated manufacturing overhead cost
$
713,400
Estimated total amount of the allocation base
82,000 machine-hours
7
Actual manufacturing overhead cost
$
695,900
8
Actual total amount of the allocation base
86,000 machine-hours
(a) By how much is the manufacturing overhead underapplied or overapplied?
manufacturing overhead
expand button
Transcribed Image Text:3. Either print or make a copy of your worksheet in your workbook before proceeding. You will need to refer back to this worksheet. Change the estimated total amount of the allocation base to 82,000 machine-hours, but keep everything the same as in Requirement 2. The data area of your worksheet should now look like this: A C 1 Chapter 3: Applying Excel 2 3 Data 4 Allocation base Machine-hours Estimated manufacturing overhead cost $ 713,400 Estimated total amount of the allocation base 82,000 machine-hours 7 Actual manufacturing overhead cost $ 695,900 8 Actual total amount of the allocation base 86,000 machine-hours (a) By how much is the manufacturing overhead underapplied or overapplied? manufacturing overhead
Expert Solution
Check Mark
Step 1

Manufacturing overhead: It is the indirect cost incurred as a part of manufacturing the products. These costs are not directly related to the units manufactured. So they are allocated to the manufactured units based on estimated cost drivers.

Pre-determined overhead allocate rate: It the rate of allocating the expected overheads to the actual units or hours for a specific accounting period.

Knowledge Booster
Background pattern image
Accounting
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
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education