segmented income statement problem 452399

Aug 29, 2021 | Uncategorized

Blue Ridge Manufacturing
ABC Analysis of Indirect Costs
Activity Measure Used By:
Activity Cost Pool Amount Activity Measure Designer Children’s Sports
Designer Pay $488,260 Hours worked 10,105 3,857 14,760
Supervisory pay 163,176 Hours worked 76,411 82,606 47,498
Samples 218,711 Number of items 2,223 2,224 1,229
Setup costs 76,220 Number of setups 15,806 15,807 11,290
Travel for design 47,266 Travel hours 3,985 2,213 6,476
Scheduling 67,142 Number of orders 246 1,870 11,990
Customer service 13,369 Number of calls 118 882 13,580
Design office costs 7,925 Square feet occupied 900 811 1,004
Supervisory, setup, and
schedulers office costs 66,665 Square feet occupied 1,800 1,622 2,008
Inspection 13,501 Number of inspections 1,897 1,297 7,113
Purchasing 175,356 Number of unique items 1,870 246 11,990
Materials handling 71,641 Number of material moves 118 882 13,580
Total Costs $1,409,232
Blue Ridge Manufacturing
Segmented Income Statement
Designer Children’s Sports Total
Sales $3,464,915 $3,246,587 $1,739,510 $8,451,012
Less:
Variable product costs 1,829,464 1,977,798 1,137,225 4,944,487
Commissions 236,805 256,006 147,202 640,013
Contribution Margin $1,398,646 $1,012,783 $455,083 $2,866,512
Less:
Indirect expenses 687,601 497,903 223,728 1,409,232
Income $711,045 $514,880 $231,355 $1,457,280

1. Use an excel spreasheet to determine the amount of indirects cost that coud be attributable to each product line
using activity based costing (ABC. Data is in the ABC analysis tab of the file