# Segmented Income Statement Problem

### Question Description:

20

Segmented Income Statement Problem 1 answer below » View complete question » 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 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 View less » Dec 11 2013 12:48 AM