Question

Given the following data, answer the questions below the table: ------------------------------------------------------------------------------------------------------------------------ Data Allocation base Machine-hours Estimated...

  1. Given the following data, answer the questions below the table:

------------------------------------------------------------------------------------------------------------------------

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?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Add a comment
Know the answer?
Add Answer to:
Given the following data, answer the questions below the table: ------------------------------------------------------------------------------------------------------------------------ Data Allocation base Machine-hours Estimated...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Data Allocation base Machine-hours Estimated manufacturing overhead cost $300,000 Estimated total amount of the allocation base...

    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...

    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...

    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...

    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...

    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...

    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...

    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:

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT