6.2 ABC and CVP Analysis: Multiple Products

Good Scent, Inc., produces two colognes: Rose and Violet. Of the two, Rose is more popular. Data concerning the two products follow:

	Rose	Violet
Expected sales (in cases)	46,000	9,200
Selling price per case	$102	$81
Direct labor hours	36,300	6,050
Machine hours	9,900	3,150
Receiving orders	50	27
Packing orders	98	54
Material cost per case	$52	$41
Direct labor cost per case	$9	$6

The company uses a conventional costing system and assigns overhead costs to products using direct labor hours. Annual overhead costs follow. They are classified as fixed or variable with respect to direct labor hours.

	Fixed		Variable
Direct labor benefits	$		$194,810
Machine costs	219,000*		228,690
Receiving department	228,500
Packing department	105,500
Total costs	$553,000		$423,500

^* All depreciation

Required:

1. Using the conventional approach, compute the number of cases of Rose and the number of cases of Violet that must be sold for the company to break even. In your computations, round variable unit cost to the nearest cent and round the number of break-even packages to the nearest whole number.

Break-even cases of Rose	fill in the blank 1
Break-even cases of Violet	fill in the blank 2

2. Using an activity-based approach, compute the number of cases of each product that must be sold for the company to break even. In your computations, round all computed amounts to the nearest cent and round the number of break-even packages to the nearest whole number.

Break-even cases of Rose	fill in the blank 3
Break-even cases of Violet	fill in the blank 4

Feedback

1. Remember to calculate package contribution margin per unit.

2. Benefits and Machine costs are unit based variable costs. The CVP formula will utilize three costs that utilize X1 (number of packages) X2 (receiving orders) and X3 (packing orders).