Question

In: Accounting

Overhead Budget Johnston Company cleans and applies powder coat paint to metal items on a job-order...

Overhead Budget

Johnston Company cleans and applies powder coat paint to metal items on a job-order basis. Johnston has budgeted the following amounts for various overhead categories in the coming year.

Supplies $223,000
Gas 56,000
Indirect labor 172,000
Supervision 77,500
Depreciation on equipment 46,000
Depreciation on the buliding 48,000
Rental of special equipment 11,000
Electricity (for lighting, heating, and air conditioning) 27,000
Telephone 4,600
Landscaping service 2,000
Other overhead 58,000

In the coming year, Johnston expects to powder coat 170,000 units. Each unit takes 1.3 direct labor hours. Johnston has found that supplies and gas (used to run the drying ovens—all units pass through the drying ovens after powder coat paint is applied) tend to vary with the number of units produced. All other overhead categories are considered to be fixed.

Required:

1. Calculate the number of direct labor hours Johnston must budget for the coming year. Calculate the variable overhead rate. Calculate the total fixed overhead for the coming year. When required, round your answers to the nearest cent and use the rounded answers in subsequent requirements.

Direct labor hours
Variable overhead rate $ per direct labor hour
Total fixed overhead $

2. Prepare an overhead budget for Johnston for the coming year. Show the total variable overhead, total fixed overhead, and total overhead. When required, round your answers to the nearest cent.

Johnston Company
Overhead Budget
For the Coming Year
Budgeted direct labor hours
Variable overhead rate $
Budgeted variable overhead $
Budgeted fixed overhead
Total budgeted overhead $

Calculate the fixed overhead rate and the total overhead rate. If required, round your answers to the nearest cent.

Fixed overhead rate $ per direct labor hour
Total overhead rate $ per direct labor hour

3. What if Johnston had expected to make 168,000 units next year? Assume that the variable overhead per unit does not change and the total fixed overhead amounts do not change. Calculate the new budgeted direct labor hours.

Prepare a new overhead budget. If required, round your answers to the nearest cent.

Johnston Company
New Overhead Budget
For the Coming Year
Budgeted direct labor hours
Variable overhead rate $
Budgeted variable overhead $
Budgeted fixed overhead
Total budgeted overhead $

Calculate the fixed overhead rate and the total overhead rate. If required, round your answers to the nearest cent.

Fixed overhead rate $ per direct labor hour
Total overhead rate $ per direct labor hour

Solutions

Expert Solution

Req 1.
Expected output 170000
DLH required perr Unit 1.3
Total DLH required 221000
Total Variable OH 279000
(223000+56000)
Variable OH per DLH 1.26
Total Fixed Oh:
Indirect Labour 172000
Supervision 77500
Depreciation on equipment 46000
Depreciationon Building 48000
Rental on special equipment 11000
Electricity expenses 27000
Telephone 4600
Landscaping service 2000
Other overheads 58000
Total Fixed Oh: 446100
Req 2.
Overheads Budget:
Budgeted Labour hours 221000
Variable OH rate 1.26
Budgeted Variable OH 279000
Budgeted Fixed OH 446100
Total Budgeted OH 725100
Fixed OH rate per DLH (446100/221000) 2.02
Total OH per DLH (725100/221000) 3.28
Req 3.
Overheads Budget:
Budgeted Labour hours 218400 (168000*1.3)
Variable OH rate 1.26
Budgeted Variable OH 275184
Budgeted Fixed OH 446100
Total Budgeted OH 721284
Fixed OH rate per DLH (446100/218400) 2.04
Total OH per DLH (721284/218400) 3.3

Related Solutions

Overhead Budget Johnston Company cleans and applies powder coat paint to metal items on a job-order...
Overhead Budget Johnston Company cleans and applies powder coat paint to metal items on a job-order basis. Johnston has budgeted the following amounts for various overhead categories in the coming year. Supplies $212,000 Gas 53,000 Indirect labor 174,000 Supervision 75,000 Depreciation on equipment 48,000 Depreciation on the buliding 45,000 Rental of special equipment 10,000 Electricity (for lighting, heating, and air conditioning) 27,500 Telephone 5,000 Landscaping service 1,600 Other overhead 56,000 In the coming year, Johnston expects to powder coat 200,000...
Job-Order Costing Ace Custom Jewelry Company uses a job-order cost system. The company applies manufacturing overhead...
Job-Order Costing Ace Custom Jewelry Company uses a job-order cost system. The company applies manufacturing overhead to jobs using a predetermined overhead rate based on direct labor hours. The estimated MOH was $135,000 for the year and the estimated direct labor hours were 15,000 hours. In May, Job #378 was completed. Direct materials totaled $8,500. Total labor costs were $14,000 at $16 per hour. At the end of the year, it was determined that the company worked 16,000 direct labor...
Ravsten Company uses a job-order costing system.    The company applies overhead cost to jobs on...
Ravsten Company uses a job-order costing system.    The company applies overhead cost to jobs on the basis of machine-hours. For the current year, the company estimated that it would work 25,000 machine-hours and incur $118,750 in manufacturing overhead cost. The following transactions occurred during the year:    a. Raw materials requisitioned for use in production, $244,000 (70% direct and 30% indirect). b. The following costs were incurred for employee services: Direct Labor $170,000 Indirect Labor $28,000 Sales commisions $20,000...
2. Allenton Company is a manufacturing firm that uses job-order costing. The company applies overhead to...
2. Allenton Company is a manufacturing firm that uses job-order costing. The company applies overhead to jobs using a predetermined overhead rate based on machine-hours. At the beginning of the year, the company estimated that it would work 31,000 machine-hours and incur $248,000 in manufacturing overhead cost. The following transactions were recorded for the year: a. Raw materials were purchased, $412,419. b. Raw materials were requisitioned for use in production, $409,000 ($388,000 direct and $21,000 indirect). c. The following employee...
Ravsten Company uses a job-order costing system. The company applies overhead cost to jobs on the...
Ravsten Company uses a job-order costing system. The company applies overhead cost to jobs on the basis of machine-hours. For the current year, the company estimated that it would work 37,000 machine-hours and incur $159,100 in manufacturing overhead cost. The following transactions occurred during the year: a. Raw materials requisitioned for use in production, $191,000 (75% direct and 25% indirect). b. The following costs were incurred for employee services: Direct labor $ 161,000 Indirect labor $ 19,000 Sales commissions $...
Lott Company uses a job order cost system and applies overhead to production on the basis...
Lott Company uses a job order cost system and applies overhead to production on the basis of direct labor costs. On January 1, 2020, Job 50 was the only job in process. The costs incurred prior to January 1 on this job were as follows: direct materials $22,600, direct labor $13,560, and manufacturing overhead $18,080. As of January 1, Job 49 had been completed at a cost of $101,700 and was part of finished goods inventory. There was a $16,950...
Lott Company uses a job order cost system and applies overhead to production on the basis...
Lott Company uses a job order cost system and applies overhead to production on the basis of direct labor costs. On January 1, 2017, Job No. 50 was the only job in process. The costs incurred prior to January 1 on this job were as follows: direct materials $ 25,000, direct labor $ 15,000, and manufacturing overhead $ 20,000. As of January 1, Job No. 49 had been completed at a cost of $ 112,500 and was part of finished...
ABC Company uses a job order cost system and applies overhead to production on the basis...
ABC Company uses a job order cost system and applies overhead to production on the basis of direct labor costs. On January 1, 2014, Job No. 50 was the only job in process. The costs incurred prior to January 1 on this job were as follows: direct materials $20,000, direct labor $12,000, and manufacturing overhead $16,000. As of January 1, Job No. 49 had been completed at a cost of $90,000 and was part of finished goods inventory. There was...
Lott Company uses a job order cost system and applies overhead to production on the basis...
Lott Company uses a job order cost system and applies overhead to production on the basis of direct labor costs. On January 1, 2017, Job No. 50 was the only job in process. The costs incurred prior to January 1 on this job were as follows: direct materials $ 22,000, direct labor $ 13,200, and manufacturing overhead $ 17,600. As of January 1, Job No. 49 had been completed at a cost of $ 99,000 and was part of finished...
Oriole Company uses a job order cost system and applies overhead to production on the basis...
Oriole Company uses a job order cost system and applies overhead to production on the basis of direct labor costs. On January 1, 2020, Job 50 was the only job in process. The costs incurred prior to January 1 on this job were as follows: direct materials $21,000, direct labor $12,600, and manufacturing overhead $16,800. As of January 1, Job 49 had been completed at a cost of $94,500 and was part of finished goods inventory. There was a $15,750...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT