Week 3 Accounting excel worksheet & questions
WK 3 Acct
Chapter 3: Applying Excel
Data
Allocation base Machine-hours
Estimated manufacturing overhead cost $300,000
Estimated total amount of the allocation base 75,000 machine-hours
Actual manufacturing overhead cost $290,000
Actual total amount of the allocation base 68,000 machine-hours
Enter a formula into each of the cells marked with a ? below
Computation of the predetermined overhead rate
Estimated manufacturing overhead cost ?
Estimated total amount of the allocation base ? machine-hours
Predetermined overhead rate ? per machine-hour
Computation of underapplied or overapplied manufacturing overhead
Actual manufacturing overhead cost ?
Manufacturing overhead cost applied to Work in Process during the year:
Predetermined overhead rate ? per machine-hour
Actual total amount of the allocation base ? machine-hours
Manufacturing overhead applied ?
Underapplied (overapplied) manufacturing overhead ?