Question

Where the ? marks are, there needs to be a formula. Thanks!

A 1 Chapter 3: Applying Excel 3 Data 4 Allocation base 5 Estimated manufacturing overhead cost 6 Estimated total amount of the allocation base 7 Actual manufacturing overhead cost 8 Actual total amount of the allocation base 9 10 Enter a formula into each of the cells marked with a ? below Machine-hours $300,000 75,000 machine-hours $290,000 68,000 machine-hours 11 ? machine-hours ? per machine-hour 12 Computation of the predetermined overhead rate 13 Estimated manufacturing overhead cost 14 Estimated total amount of the allocation base 15 Predetermined overhead rate 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 21 Actual total amount of the allocation base 22 Manufacturing overhead applied 23 Underapplied (overapplied) manufacturing overhead ? per machine-hour ? machine-hours

Thanks for the Help :)

Answer 1

In figures:

4 Allocation base 5 Estd. Manu. OH cost 6 Estd. Total amount of the allocation base 7 Actual manu. OH cost 8 Actual total amount of the allocation base Machine Hours $300,000.00 75000 machine hours $ 290,000.00 68000 machine hours 9 10 11 $ 300,000.00 75000 machine hours $ 4.00 per machine hour 12 Computation of the predetermined OH rate 13 Estd. Manu. OH cost 14 Estd. Total amount of the allocation base 15 Predetermined OH rate 16 17 Computation of underapplied or overapplied manu. OH 18 Actual manu. OH cost 19 Manu. OH cost applied to WIP during the year 20 Predetermined OH rate 21 Actual total amount of the allocation base 22 Manu. OH applied 23 Underaplied (overapplied) manu. OH $ 290,000.00 4 per machine hour 68000 machine hours $ 272,000.00 $ 18,000.00

With formulas:

4 Allocation base 5 Estd. Manu. OH cost 6 Estd. Total amount of the allocation base 7 Actual manu. OH cost 8 Actual total amount of the allocation base Machine Hours 300000 75000 machine hours 290000 68000 machine hours =B5 =B6 =B13/B14 machine hours per machine hour 10 11 12 Computation of the predetermined OH rate 13 =A5 14 =A6 15 Predetermined OH rate 16 17 Computation of underapplied or overapplied manu. OH 18 Actual manu. OH cost 19 Manu. OH cost applied to WIP during the year 20 Predetermined OH rate 21 Actual total amount of the allocation base 22 Manu. OH applied 23 Underaplied (overapplied) manu. OH =B7 =B15 =B8 =B20*B21 per machine hour machine hours =B18-B22