Direct Labor Hours Machine Hours Blending Department Whole milk 260 650 Skim milk 245 710 Cream 215 260 720 1,620 Packing Department Whole milk 470 500 Skim milk 300 415 Cream 130 165 900 1,080 Total 1,620 2,700 The management of Spotted Cow Dairy Company now plans to use the multiple production department factory overhead rate method. The total factory overhead associated with each department is as follows: Blending Department $178,200 Packing Department 121,500 Total $299,700 Required: 1. Determine the multiple production department factory overhead rates, using machine hours for the Blending Department and direct labor hours for the Packing Department. Blending Department $fill in the blank 1 110 per machine hour Packing Department $fill in the blank 2 per direct labor hour 2. Determine the product factory overhead costs, using the multiple production department rates in (1). Whole Milk Skim Milk Cream Blending Department factory overhead $fill in the blank 3 71,500 $fill in the blank 4 78,100 $fill in the blank 5 28,600 Packing Department factory overhead fill in the blank 6 fill in the blank 7 fill in the blank 8 Total factory overhead $fill in the blank 9 $fill in the blank 10 $fill in the blank 11

Note: This question is not complete and the data in it are merged together. The complete question with the sorted data are therefore presented before answering the question as follows:

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 $299,700.

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 260 650

Skim milk 245 710

Cream 215 260

720 1,620

Packing Department

Whole milk 470 500

Skim milk 300 415

Cream 130 165

900 1,080

Total 1,620 2,700

The management of Spotted Cow Dairy Company now plans to use the multiple production department factory overhead rate method. The total factory overhead associated with each department is as follows:

Blending Department $178,200

Packing Department 121,500

Total $299,700

Required:

1. Determine the multiple production department factory overhead rates, using machine hours for the Blending Department and direct labor hours for the Packing Department.

2. Determine the product factory overhead costs, using the multiple production department rates in (1).

The explanation of the answer is now given as follows:

1. Determine the multiple production department factory overhead rates, using machine hours for the Blending Department and direct labor hours for the Packing Department.

Blending department overhead rate = Blending department overheads / Blending department machine hours = $178,200 / 1,620 = $110 per machine hour

Packing department overhead rate = Packing department overheads / Packing department labor hours = $121,500 / 900 = $135 per direct labor hour

2. Determine the product factory overhead costs, using the multiple production department rates in (1).

Note: See the attached excel file for the determination of the product factory overhead costs, using the multiple production department rates.

In the attached excel file the following formulae are used to calculate the product factory overhead costs:

Blending department factory overhead = Machine fours * Overhead rate per machine hour

Packing department factory overhead = Direct labor hours * Overhead rate per direct labor hour

From the attached excel file, we have:

Whole Milk Total factory overhead = $134,950

Skim Milk Total factory overhead = $118,600

Cream Total factory overhead = $46,150