Allocation of Overhead
Land Products, Inc., uses a predetermined overhead rate in its production, assembly, and testing departments. One rate is used for the entire company; it is based on machine hours. The rate is determined by analyzing data from the previous year to determine the percentage change in costs. Thus this year’s overhead rate will be based on the percentage change multiplied by last year’s costs. Lise Jensen is about to compute the rate for this year using the following data:
|
Last Year’s Costs |
|
|
Machine hours |
41,800 |
|
Overhead costs |
|
|
Indirect materials |
$ 57,850 |
|
Indirect labor |
25,440 |
|
Supervision |
41,580 |
|
Utilities |
11,280 |
|
Labor-related costs |
9,020 |
|
Depreciation, factory |
10,780 |
|
Depreciation, machinery |
27,240 |
|
Property taxes |
2,880 |
|
Insurance |
1,920 |
|
Miscellaneous overhead |
4,840 |
|
Total overhead |
$192,830 |
This year the cost of indirect materials is expected to increase by 30 percent over the previous year. The cost of indirect labor, utilities, machinery depreciation, property taxes, and insurance is expected to increase by 20 percent over the previous year. All other expenses are expected to increase by 10 percent over the previous year. Machine hours for this year are estimated at 45,980.
Required
1. Compute the projected costs and the overhead rate for this year using the information about expected cost increases. (Round your answer to three decimal places.)
2. During this year, Lund Products completed the following jobs using the machine hours shown:
|
Job No. |
Machine Hours |
Job No. |
Machine Hours |
|
H–142 |
7,840 |
H–201 |
10,680 |
|
H–164 |
5,260 |
H–218 |
12,310 |
|
H–175 |
8,100 |
H–304 |
2,460 |
Determine the amount of overhead applied to each job. What was the total overhead applied during this year? (Round answers to the nearest dollar.)
3. Actual overhead costs for this year were $234,485. Was overhead under applied or over applied this year? By how much? Should the Cost of Goods Sold account be increased or decreased to reflect actual overhead costs?
4. At what point during this year was the overhead rate computed? When was it applied? Finally, when was under applied or over applied overhead determined and the Cost of Goods Sold account adjusted to reflect actual costs?