Question

1. Single Plantwide Rate and Activity-Based Costing

   Whirlpool Corporation conducted an activity-based costing study of its Evansville, Indiana, plant in order to identify its most profitable products. Assume that we select three representative refrigerators (out of 333): one low-, one medium-, and one high-volume refrigerator. Additionally, we assume the following activity-base information for each of the three refrigerators:

   Three Representative Refrigerators	Number of Machine Hours		Number of Setups		Number of Sales Orders		Number of Units
   Refrigerator—Low Volume	120		21		63		600
   Refrigerator—Medium Volume	310		20		140		1,550
   Refrigerator—High Volume	960		14		210		4,800

   Prior to conducting the study, the factory overhead allocation was based on a single machine hour rate. The machine hour rate was $600 per hour. After conducting the activity-based costing study, assume that three activities were used to allocate the factory overhead. The new activity rate information is assumed to be as follows:

   	Machining Activity		Setup Activity		Sales Order Processing Activity
   Activity rate	$580		$900		$200

   a. Complete the following table, using the single machine hour rate to determine the per-unit factory overhead for each refrigerator (Column A) and the three activity-based rates to determine the activity-based factory overhead per unit (Column B). Finally, compute the percent change in per-unit allocation from the single to activity-based rate methods (Column C).

   If required, round all per unit answers to the nearest cent. Round percents to one decimal place. For column C, use the minus sign to indicate a negative or decrease.

   	Column A	Column B	Column C
   Product Volume Class	Single Rate Overhead Allocation Per Unit	ABC Overhead Allocation Per Unit	Percent Change in Allocation
   Low	$	$	%
   Medium	$	$	%
   High	$	$	%

   
   b. Why is the traditional overhead rate per machine hour greater under the single rate method than under the activity-based method?

   The machine hour rate is greater under the single rate method than under the activity-based method because 100% of the factory overhead is is allocated by machine hours under the single rate method. However, only a portion of the factory overhead is allocated under the machine rate method using activity-based costing. The remaining factory overhead is allocated using the . Thus, the numerator for for determining the machine hour rate under activity-based costing must be less than the numerator under the single machine hour rate method.

   c. Interpret Column C in your table from part (A).

   Column C indicates that under activity-based costing the low-volume product has a per-unit cost than calculated under the single rate method. In contrast, under activity-based costing the high-volume product has a per-unit cost than calculated under the single rate method. This result will occur when there are activities that occur in proportions different from their volumes. In this case, volume products have setups and sales orders occurring in higher proportions of total setups and sales orders than their proportion of machine hours to total machine hours. The opposite is the case for the volume product. Thus, the lower-volume products are produced and ordered in batch sizes compared to the higher-volume product. This implies that Whirlpool may wish to simplify its product line by eliminating some of the volume products or by attempting to reduce the overall cost of setup and sales order processing activities.

Answer 1

C A*B E C/D A D No.of Machine Hour ОН per OH Allocation No of Refrigerators Machine rate using m/c hours units unit Hours 120 $ 310 $ 960 $ 600 $ 600 S Low 72,000 600 120 Medium 1,550 $ 4,800 $ 1,86,000 120 High 600 S 5,76,000 120 Medium High Low 69,600 $ 1,79,800 $ Machining Activity 5,56,800 (Machine hrs * $$ 580) |Set-up Activity (Set-up hrs $ 900) Sales Order Processing Activity |(Sales order * $ 200) (120*580) (310*580) (960*580) 18,900 $ 18,000 $ 12,600 (21*900) (20*900) (14*900) 12,600 $ 28,000 $ 1,26,000 (63*200) (140*200) (210*600) 1,01,100 $ 600 $ 169 $ Total OH allocation (a) No. of units (b) ОН per unit (a/b) 2,25,800 $ 1,550 $ 146 $ 6,95,400 4,800 $ 145 Requirement a Column B АВС ОН Column A Column C |Single Rate |OH Allocation Allocation per % Change in unit 120 $ Product Volume Class allocation per unit 40.8% Low 169 Medium High $ 120 S 146 21.7% 120 $ 20.8% 145 (All increase)