Question

Venus Creations sells window treatments (shades, blinds, and awnings) to both commercial and residential customers. The following information relates to its budgeted operations for the current year. Commercial Residential Revenues $356,500 $536,000 Direct materials costs $35,000 $50,000 Direct labor costs 140,000 260,000 Overhead costs 91,500 266,500 251,000 561,000 Operating income (loss) $90,000 $(25,000) The controller, Peggy Kingman, is concerned about the residential product line. She cannot understand why this line is not more profitable given that the installations of window coverings are less complex for residential customers. In addition, the residential client base resides in close proximity to the company office, so travel costs are not as expensive on a per client visit for residential customers. As a result, she has decided to take a closer look at the overhead costs assigned to the two product lines to determine whether a more accurate product costing model can be developed. Here are the three activity cost pools and related information she developed: Estimated Overhead Cost Drivers Activity Cost Pools Scheduling and travel Setup time Supervision $91,500 91,000 160,000 Hours of travel Number of setups Direct labor cost Estimated Use of Cost Drivers per Product Commercial Residential Scheduling and travel Setup time 800 450 700 250

Answer 1

	Income Statement
	Particulars			Commercial			Residential
	Revenues				$ 356,500.00			$ 536,000.00
Less:	Expenses:
	Direct material cost			$   35,000.00			$   50,000.00
	Direct labor cost			$ 140,000.00			$ 260,000.00
	Overhead cost			$ 163,300.00	$ 338,300.00		$ 179,200.00	$ 489,200.00
	Operating Income				$   18,200.00			$   46,800.00

Workings:

			Drivers			Cost
Cost Pools		Estd. OH	Volume			per volume
Scheduling and travel		$   91,500.00	1500	(800 + 700)		$   61.00
Setup time		$   91,000.00	700	(450 + 250)		$ 130.00
Supervision		$ 160,000.00	400000	($ 140000 + $ 260000)		$      0.40

Allocation of OH costs
Particulars			Commercial		Residential
Scheduling and travel			$   48,800.00	($ 61 x 800)	$   42,700.00	($ 61 x 700)
Setup time			$   58,500.00	($ 130 x 450)	$   32,500.00	($ 130 x 250)
Supervision			$   56,000.00	(0.4 x $ 140000)	$ 104,000.00	(0.4 x $ 260000)
			$ 163,300.00		$ 179,200.00