Question

D E F G H K G#: Copy Formulas A B C 1 Chapter 3: Applying Excel Name: 2 3 Data 4 Allocation base Machine-hours Estimated manufacturing overhead cost $300,000 6 Estimated total amount of the allocation base 75,000 machine-hours 7 Actual manufacturing overhead cost $290,000 8 Actual total amount of the allocation base 68,000 machine-hours 9 10 Enter a formula into each of the green cells marked with a ? below. Once complete use the "Copy Formula" button. 11 12 Computation of the predetermined overhead rate 13 Estimated manufacturing overhead cost ? 14 Estimated total amount of the allocation base ? machine-hours 15 Predetermined overhead rate ? per machine-hour 16 17 Computation of underapplied or overapplied manufacturing overhead 18 Actual manufacturing overhead cost ? 19 Manufacturing overhead cost applied to Work in Process during the year: 20 Predetermined overhead rate 7 per machine-hour 21 Actual total amount of the allocation base 7 machine-hours 22 Manufacturing overhead applied 23 Underapplied (overapplied) manufacturing overhead ? 24 25 26 27 28 29 30 ? 31 Formulas R 1 CH3 Req 2 Ch3 Rey 3 Ch3 Req 4 Ch3 + EP - + 137%

Answer 1

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
Computation of the predetermined overhead rate
Estimated Manufacturing Overhead Cost	$300,000
Estimated Total amount of the allocation base	75,000	machine-hours
Predetermined Overhead Rate	$4	per machine -hour
Computation of underapplied or overappplied manufacturing overhead
Actual Manufacturing Overhead Cost	$290,000
Manufacturing Overhead Cost applied to work in process during the year
Predetermined Overhead Rate	$4
Actual Total Amount of the allocation base	68,000
Manufacturing Overhead Applied	$272,000
Underapplied (overapplied) Manufacturing Overhead	$18,000

You may look the following for the formulae reference:

Data
Allocation Base	Machine-Hours
Estimated Manufacturing Overhead Cost	300000
Estimated Total amount of the allocation base	75000	machine-hours
Actual Manufacturing Overhead Cost	290000
Actual Total Amount of the allocation base	68000	machine-hours
Computation of the predetermined overhead rate
Estimated Manufacturing Overhead Cost	=D245
Estimated Total amount of the allocation base	=D246	machine-hours
Predetermined Overhead Rate	=D251/D252	per machine -hour
Computation of underapplied or overappplied manufacturing overhead
Actual Manufacturing Overhead Cost	=D247
Manufacturing Overhead Cost applied to work in process during the year
Predetermined Overhead Rate	=D253
Actual Total Amount of the allocation base	=D248
Manufacturing Overhead Applied	=D258*D259
Underapplied (overapplied) Manufacturing Overhead	=D256-D260