Activity-Based Costing; Customer Group Cost AnalysisFranklin Furniture, Inc. (FFI) manufactures bedroom furniture in sets (a set includes a dresser, two queen-size beds, and one bedside table) for use in motels and hotels. FFI has three customer groups, which it calls the value, quality, and luxury groups. The value products are targeted to low-price motels that are looking for simple furniture, while the luxury furniture is targeted to the very best hotels. The value line is attractive to a variety of hotels and motels that appreciate the combination of quality and value. Currently there has been a small increase in the low-cost and value lines, and an appreciable increase in demand in the luxury line, reflecting cyclical changes in the marketplace. Luxury hotels are now in more demand for business travel, while a few years ago, the value segment was the most popular for business travelers. FFI wants to be able to respond to the increased demand with increased production but worries about the increased production cost and about price setting as its mix of customers and production change. FFI has used a volume-based rate based on direct labor hours for some time. Direct labor cost is $15 per hour.

	Budgeted Cost	Cost Driver
Materials handling	$349,600	Number of parts
Product scheduling	160,000	Number of production orders
Setup labor	216,000	Number of setups
Automated machinery	1,750,000	Machine hours
Finishing	619,500	Direct labor hours
Pack and ship	290,400	Number of orders shipped
	$3,385,500
General, selling, and adm. costs	$5,000,000

Page 160

The budgeted production data for the three product lines follow.

Product Lines	Value	Quality	Luxury
Units produced	15,000	5,000	600
Price	$650	$900	$1,200
Direct materials cost per unit	$80	$50	$110
Number of parts per unit	30	50	120
Direct labor hours per unit	4	5	7
Machine hours per unit	3	7	15
Production orders	50	70	200
Production setups	20	50	50
Orders shipped	1,000	2,000	300
Number of inspections	2	6	14

Required(Round all rates to two decimal places)

Determine the cost per set and the total production cost of each of the three customer groups using activity-based costing.

Determine the production cost for each of the three customer groups using FFIs current volume-based approach.