In: Accounting
Spotted Cow Dairy Company manufactures three products—whole milk, skim milk, and cream—in two production departments, Blending and Packing. The factory overhead for Spotted Cow Dairy is $226,200.
The three products consume both machine hours and direct labor hours in the two production departments as follows:
Direct Labor Hours | Machine Hours | ||||||
Blending Department | |||||||
Whole milk | 250 | 740 | |||||
Skim milk | 270 | 670 | |||||
Cream | 210 | 270 | |||||
730 | 1,680 | ||||||
Packing Department | |||||||
Whole milk | 330 | 460 | |||||
Skim milk | 530 | 570 | |||||
Cream | 150 | 190 | |||||
1,010 | 1,220 | ||||||
Total | 1,740 | 2,900 |
Required:
1. Determine the single plantwide factory overhead rate, using each of the following allocation bases: (a) direct labor hours and (b) machine hours. If required, round all amounts to the nearest dollar.
a. Direct labor overhead rate | $fill in the blank 1 per direct labor hour |
b. Machine hour overhead rate | $fill in the blank 2 per machine hour |
2. Determine the product factory overhead costs, using (a) the direct labor hour plantwide factory overhead rate and (b) the machine hour plantwide factory overhead rate.
Whole Milk | Skim Milk | Cream | |
Direct labor hours | $fill in the blank 3 | $fill in the blank 4 | $fill in the blank 5 |
Machine hours | $fill in the blank 6 | $fill in the blank 7 | $fill in the blank 8 |
1. Single plantwide factory overhead rate | ||
a. Direct labor overhead rate [Refer working note 1] | $130 | per direct labor hour |
b. Machine hour overhead rate [Refer working note 1] | $78 | per machine hour |
.
.
2. Product factory overhead cost | |||
Whole Milk | Skim Milk | Cream | |
Direct labor hours [Refer working note 2] | $75,400 | $104,000 | $46,800 |
Machine hours [Refer working note 3] | $93,600 | $96,720 | $35,880 |
.
.
Working note 1 - Computation of plant-wide overhead rate: | ||
Direct Labor Hours | Machine Hours | |
Estimated factory overhead (a) | $226,200 | $226,200 |
Estimated hours (b) | 1,740 | 2,900 |
Overhead rate (a / b) | $130 | $78 |
.
.
Working note 2 - Computation of product factory overhead cost using direct labor hour overhead rate
Whole milk | Skim milk | Cream | |
Direct labor hours: | |||
Blending Department (a) | 250 | 270 | 210 |
Packing Department (b) | 330 | 530 | 150 |
Total hours (c= a + b) | 580 | 800 | 360 |
Overhead rate based on direct labor hours [Refer working note 1] (d) | $130 | $130 | $130 |
Product overhead cost (c x d) | $75,400 | $104,000 | $46,800 |
.
.
Working note 3 - Computation of product factory overhead cost using direct machine hour overhead rate
Whole milk | Skim milk | Cream | |
Machine hours: | |||
Blending Department (a) | 740 | 670 | 270 |
Packing Department (b) | 460 | 570 | 190 |
Total hours (c= a + b) | 1,200 | 1,240 | 460 |
Overhead rate based on machine hours [Refer working note 1] (d) | $78 | $78 | $78 |
Product overhead cost (c x d) | $93,600 | $96,720 | $35,880 |