Show work and your response in a color other than black. A useful document for this assignment is the interactive overhead worksheet in Excel.

1. A manufacturer has the following information:

Budgeted or estimated Mfg OH costs = $1200

Estimated Direct Labor hours by plant workers = 500; Plant worker wages = $16/hour, budget & actual

Estimated Machine Hours = 250

Actual Mfg OH costs for the period = $1,180

Actual Machine Hours = 254

Actual Direct Labor hours by plant workers = 495

The predetermined overhead rate is based on estimated direct labor hours.

What is the predetermined overhead rate for manufacturing overhead?

What is the amount of applied manufacturing overhead?

What is the overapplied or underapplied manufacturing overhead?

Show the journal entry in debit and credit form to apply manufacturing overhead.

Show the journal entry in debit and credit form to adjust for underapplied or overapplied overhead.

2. Show work. Show work and your response in a color other than black.

A manufacturer has the following information:

Budgeted or estimated Mfg OH costs = $100

Estimated Direct Labor hours by plant workers = 500; Plant worker wages = $16/hour, budget & actual

Estimated Machine Hours = 250

Actual Mfg OH costs for the period = $98.00

Actual Machine Hours = 254

Actual Direct Labor hours by plant workers = 495

The predetermined overhead rate is based on estimated machine hours.

What is the predetermined overhead rate for manufacturing overhead?

What is the amount of applied manufacturing overhead?

What is the overapplied or underapplied manufacturing overhead?

Show the journal entry in debit and credit form to apply manufacturing overhead.

Show the journal entry in debit and credit form to adjust for underapplied or overapplied overhead.

3. Show work. Show work and your response in a color other than black.

A manufacturer has the following information:

Budgeted or estimated Mfg OH costs = $14,236

Estimated Direct Labor hours by plant workers = 5000; Plant worker wages = $16/hour, budget & actual.

Estimated Machine Hours = 2500

Actual Mfg OH costs for the period = $14,297

Actual Machine Hours = 2583

Actual Direct Labor hours by plant workers = 5014

The predetermined overhead rate is based on estimated direct labor cost.

What is the predetermined overhead rate for manufacturing overhead?

What is the amount of applied manufacturing overhead?

What is the overapplied or underapplied manufacturing overhead?

Show the journal entry in debit and credit form to apply manufacturing overhead.

Show the journal entry in debit and credit form to adjust for underapplied or overapplied overhead.

Machine-hours Direct Labor Cost Direct Labor Hours $72,500.00 Input data in these cells $60.00 Input data in these cells $170,000.00 Input data in these cells 9875.00 machine-hours $ 25.00 direct labor cost 1820.00 direct labor hours $70,000.00 $60.00 $170,001.00 9800.00 machine-hours $25.00 direct labor cost 1799.00 direct labor hours $72,500.00 These cells will automatically $60.00 These cells will automatically $170,000.00 These cells will automatically 9875.00 machine-hours calculate the predetermined $25.00 direct labor cost calculate the predetermined 1820.00 direct labor hours calculate the predetermined $7.34 per machine-hour overhead rate $2.40 per direct labor dollar overhead rate $93.41 per labor hour overhead rate DON'T MESS WITH THESE CELLS DON'T MESS WITH THESE CELLS DON'T MESS WITH THESE CELLS $70,000.00 $60.00 $170,001.00

$7.34

per machine-hour $2.40 per direct labor dollar

$93.41 per labor hour 9800.00 machine-hours $25.00 direct labor cost 1799.00 direct labor hours $71,949.37 $60.00 $168,038.46 $ (1,949.37) $70,000.00 vs $71,949.37 $ - $60.00 vs $60.00 $1,962.54 $170,001.00 vs. $168,038.46 Debit Credit Debit Credit Debit Credit Work in Process $71,949.37 Work in Process $ 60.00 Work in Process $168,038.46 Manufacturing Overhead $71,949.37 Manufacturing Overhead $ 60.00 Manufacturing Overhead $ 168,038.46 All numbers must show 2 decimals. Allocation base Machine-hours Direct Labor Cost Estimated manufacturing overhead cost, at start of period Estimated total amount of the allocation base, at start of period Actual manufacturing overhead cost, known by the end of period Actual total amount of the allocation base, known during or at end of period $72,500.00 9875.00 machine-hours $70,000.00 9800.00 machine-hours Input data in these cells Computation of the predetermined overhead rate Estimated manufacturing overhead cost, at start of period Estimated total amount of the allocation base, at start of period Predetermined overhead rate: EST OH COST/EST ALLOCATION BASE calculated at start of period $72,500.00 9875.00 machine-hours $7.34 per machine-hour These cells will automatically calculate the predetermined overhead rate Computation of underapplied or overapplied manufacturing overhead Actual manufacturing overhead cost, known by the end of period Manufacturing overhead cost applied to Work in Process during the year: Predetermined overhead rate, calculated at start of period Actual total amount of the allocation base, known during or at end of period Manufacturing overhead applied [actual amount of base activity x rate] Underapplied (Overapplied) manufacturing overhead Entry to apply Manufacturing Overhead $60.00 25.00 direct labor cost $60.00 $25.00 direct labor cost Input data in these cells $170,000.00 1820.00 direct labor hours $170,001.00 1799.00 direct labor hours Input data in these cells $60.00 $25.00 direct labor cost $2.40 per direct labor dollar $ These cells will automatically calculate the predetermined overhead rate $170,000.00 1820.00 direct labor hours $93.41 per labor hour These cells will automatically calculate the predetermined overhead rate DON'T MESS WITH THESE CELLS DON'T MESS WITH THESE CELLS $70,000.00 x $7.34 per machine-hour 9800.00 machine-hours $71,949.37 $ (1,949.37) $70,000.00 Direct Labor Hours DON'T MESS WITH THESE CELLS $60.00 x vs Debit Work in Process $ 71,949.37 Manufacturing Overhead $ 71,949.37 $ $2.40 per direct labor dollar $25.00 direct labor cost $60.00 - Credit $ 71,949.37 Work in Process Manufacturing Overhead $170,001.00 x $60.00 vs Debit $ 60.00 $60.00 $93.41 per labor hour 1799.00 direct labor hours $168,038.46 $1,962.54 Credit Debit $ 168,038.46 Work in Process $ 60.00 $170,001.00 vs. Manufacturing Overhead Credit $ 168,038.46 CELLS $168,038.46 3 OVERHEAD SCENARIOS (30 pts) Show work and your response in a color other than black. A useful document for this assignment is the interactive overhead worksheet in Excel. 1. A manufacturer has the following information: Budgeted or estimated Mfg OH costs = $1200 Estimated Direct Labor hours by plant workers = 500; Plant worker wages = $16/hour, budget & actual Estimated Machine Hours = 250 Actual Mfg OH costs for the period = $1,180 Actual Machine Hours = 254 Actual Direct Labor hours by plant workers = 495 The predetermined overhead rate is based on estimated direct labor hours. What is the predetermined overhead rate for manufacturing overhead? What is the amount of applied manufacturing overhead? What is the overapplied or underapplied manufacturing overhead? Show the journal entry in debit and credit form to apply manufacturing overhead. Show the journal entry in debit and credit form to adjust for underapplied or overapplied overhead. 2. Show work. Show work and your response in a color other than black. A manufacturer has the following information: Budgeted or estimated Mfg OH costs = $100 Estimated Direct Labor hours by plant workers = 500; Plant worker wages = $16/hour, budget & actual Estimated Machine Hours = 250 Actual Mfg OH costs for the period = $98.00 Actual Machine Hours = 254 Actual Direct Labor hours by plant workers = 495 The predetermined overhead rate is based on estimated machine hours. What is the predetermined overhead rate for manufacturing overhead? What is the amount of applied manufacturing overhead? What is the overapplied or underapplied manufacturing overhead? Show the journal entry in debit and credit form to apply manufacturing overhead. Show the journal entry in debit and credit form to adjust for underapplied or overapplied overhead. 3. Show work. Show work and your response in a color other than black. A manufacturer has the following information: Budgeted or estimated Mfg OH costs = $14,236 Estimated Direct Labor hours by plant workers = 5000; Plant worker wages = $16/hour, budget & actual. Estimated Machine Hours = 2500 Actual Mfg OH costs for the period = $14,297 Actual Machine Hours = 2583 Actual Direct Labor hours by plant workers = 5014 The predetermined overhead rate is based on estimated direct labor cost. What is the predetermined overhead rate for manufacturing overhead? What is the amount of applied manufacturing overhead? What is the overapplied or underapplied manufacturing overhead? Show the journal entry in debit and credit form to apply manufacturing overhead. Show the journal entry in debit and credit form to adjust for underapplied or overapplied overhead