------------------------------------------------------------------------------------------------------------------------
Data |
||
Allocation base |
Machine-hours |
|
Estimated manufacturing overhead cost |
$220,800 |
|
Estimated total amount of the allocation base |
46,000 |
machine-hours |
Actual manufacturing overhead cost |
$240,100 |
|
Actual total amount of the allocation base |
42,000 |
machine-hours |
------------------------------------------------------------------------------------------------------------------------
a) What is the pre-determined overhead rate?
b) By how much is the manufacturing overhead underapplied or overapplied?
c) Change the estimated total amount of allocation base to 48,000 machine hours, now by how much is the manufacturing overhead underapplied or overapplied?
Predetermined Overhead rate = Estimated overhead/Estimated machine hours = 220,800/46,000 = 4.80 per machine hour |
Applied overhead = 4.80 * 42,000 = 201,600 Actual overhead = 240,100 So, overhead underapplied by = 240,100 - 201,600 = 38,500 underapplied |
Predetermined overhead rate = 220,800/48,000 = 4.60 per mh Applied overhead = 4.60*42000 = 193,200 Actual overhead = 240,100 So,overhead is underapplied by = 240,100 - 193,200 = 46,900 underapplied |
Given the following data, answer the questions below the table: ------------------------------------------------------------------------------------------------------------------------ Data Allocation base Machine-hours Estimated...
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 ? 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...
4. Change the estimated total amount of the allocation base back to 39,000 machine-hours, so that the data area of you worksheet looks exactly the same as in Requirement 2. Now change the actual manufacturing overhead cost from $184,800 to $193,500. The data area of your worksheet should now look like this: 1 Chapter 3: Applying Excel 4 5 6 7 8 Data Allocation base Estimated manufacturing overhead cost Estimated total amount of the allocation base Actual manufacturing overhead cost...
Chapter 3: Applying Excel Data Allocation base Machine-hours Estimated manufacturing overhead cost $300,000 Estimated total amount of the allocation base 60,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...
A B C 1 2 3 4 5 6 7 8 Chapter 3: Applying Excel Data Allocation base Machine-hours Estimated manufacturing overhead cost $290,700 Estimated total amount of the allocation base 57,000 machine-hours Actual manufacturing overhead cost $273,700 Actual total amount of the allocation base 60,000 machine-hours (a) By how much is the manufacturing overhead underapplied or overapplied? (b) Why is the amount of underapplied (overapplied) manufacturing overhead different from Requirement 2 above? (you can select one or more) The...
Chapter 3: Applying Excel: Exercise 2. Change all of the numbers in the data area of your worksheet so that it looks like this: с 1 Chapter 3: Applying Excel 2 3 4 5 Data Allocation base Estimated manufacturing overhead cost Estimated total amount of the allocation base Actual manufacturing overhead cost Actual total amount of the allocation base 6 Machine-hours $ 275,600 52.000 machine-hours $ 261,600 50,000 machine-hours 7 00 If your formulas are correct, you should get the...
A B C 1 2 3 4 5 6 7 8 Chapter 3: Applying Excel Data Allocation base Machine-hours Estimated manufacturing overhead cost $290,700 Estimated total amount of the allocation base 51,000 machine-hours Actual manufacturing overhead cost $281,700 Actual total amount of the allocation base 60,000 machine-hours (a) By how much is the manufacturing overhead underapplied or overapplied? (b) Why is the amount of underapplied (overapplied) manufacturing overhead different from Requirement 2 above? (you can select one or more below)...
The Excel worksheet form that appears below is to be used to recreate part of the example relating to Turbo Crafters that appears earlier in the chapter. 1. Award: 10.00 points 2. Change all of the numbers in the data area of your worksheet so that it looks like this: 1 Chapter 3: Applying Excel 2 3 Data 4 Allocation base 5 Estimated manufacturing overhead cost 6 Estimated total amount of the allocation base 7 Actual manufacturing overhead cost Machine-hours...
The company you work for uses machine hours as an allocation base to allocate overhead to jobs. You also collect the following information:Estimated use 47,500m-hPractical capacity 50,000m-hActual usage 46,850m-hFixed manufacturing overhead* $ 1,258,400 *All manufacturing overhead is fixedMachine hours required for Job X55m-h1) Using estimated amount of the allocation base, calculate:a) predetermined overhead rateb) overhead would be applied to Job Xc) underapplied or overapplied overhead2) Using practical capacity amount of the allocation base, calculate:a) predetermined overhead rateb) overhead would be applied to ...
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 45,000 machine-hours, but keep everything the same as in Requirement 2. The data area of your worksheet should now look like this: 1 Chapter 3: Applying Excel 3 Data 4 5 6 7 8 Allocation base Estimated manufacturing overhead cost Estimated total amount of the allocation...
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...