Fill This Form To Receive Instant Help
Homework answers / question archive / Exercise 4-14 a1-a2, b (Video) Venus Creations sells window treatments (shades, blinds, and awnings) to both commercial and residential customers
Commercial
|
Residential
|
||||||||
Revenues | $319,300 | $472,500 | |||||||
Direct materials costs | $45,000 | $50,000 | |||||||
Direct labor costs | 120,000 | 280,000 | |||||||
Overhead costs | 79,300 | 244,300 | 167,500 | 497,500 | |||||
Operating income (loss) | $75,000 | $(25,000) |
Activity Cost Pools
|
Estimated Overhead
|
Cost Drivers
|
||||
Scheduling and travel | $79,300 | Hours of travel | ||||
Setup time | 127,500 | Number of setups | ||||
Supervision | 40,000 | Direct labor cost |
Estimated Use of Cost Drivers per Product | ||||||||
Commercial
|
Residential
|
|||||||
Scheduling and travel | 750 | 550 | ||||||
Setup time | 500 | 250 |
Compute the activity-based overhead rates for each of the three cost pools. (Round overhead rate for supervision to 2 decimal places, e.g. 0.38.)
Determine the overhead cost assigned to each product line.
Compute the operating income for each product line, using the activity-based overhead rates.
Activity Cost Pools
|
Estimated
Overhead |
÷
|
Estimated Use of
Cost Drivers |
=
|
ABC
Overhead Rates |
|||
Scheduling and travel | $79,300 | 1,300 | hours | $61 | per hour | |||
Setup time | $127,500 | 750 | setups | $170 | per setup | |||
Supervision | $40,000 | $400,000 | * | $0.10 | per dollar |
*$120,000 + $280,000
Commercial
|
||||||
Activity Cost Pools
|
Estimated Use of
Cost Driver per Product |
×
|
ABC
Overhead Rates |
=
|
Cost
Assigned |
|
Scheduling and travel | 750 | $61/hr. |
$45,750
|
|||
Setup time | 500 | $170/setup |
$85,000
|
|||
Supervision | $120,000 | $0.10/dollar |
$12,000
|
|||
Total assigned costs |
$142,750
|
Residential
|
||||||
Activity Cost Pools
|
Estimated Use of
Cost Driver per Product |
×
|
ABC
Overhead Rates |
=
|
Cost
Assigned |
|
Scheduling and travel | 550 | $61/hr. |
$33,550
|
|||
Setup time | 250 | $170/setup |
$42,500
|
|||
Supervision | $280,000 | $0.10/dollar |
$28,000
|
|||
Total assigned costs |
$104,050
|
[(Commercial: (750 x $61) + (500 x $170) + ($120,000 x $0.10) = $142,750); (Residential: (550 x $61) + (250 x $170) + ($280,000 x $0.10) = $104,050)]
[(Commercial: (Hrs. of travel x OH rate/hr.) + (No. of setups x OH rate/setup) + (DL cost x OH rate/DL$) = Tot. assigned OH costs); (Residential: (Hrs. of travel x OH rate/hr.) + (No. of setups x OH rate/setup) + (DL cost x OH rate/DL$) = Tot. assigned OH costs)]
Commercial
|
Residential
|
||||||||
Revenues | $319,300 | $472,500 | |||||||
Direct material costs | $45,000 | $50,000 | |||||||
Direct labor costs | 120,000 | 280,000 | |||||||
Overhead costs | 142,750 | 307,750 | 104,050 | 434,050 | |||||
Operating income (loss) | $11,550 | $38,450 |