Fitzgerald Supermarkets (FS) operates at capacity and decides to apply ABC analysis to three product lines: baked goods, milk and fruit juice, and frozen foods. It identifies four activities their activity cost rates as follows:

Ordering $95 per purchase order
Delivery and receipt of merchandise $76 per delivery
Shelf-stocking $19 per hour
Customer support and assistance $0.15 per item sold
The revenues, cost of goods sold, store support costs, activities that account for the store support costs, and activity-area usage of the three product lines are as follows:

Baked Goods Milk and Fruit Juice Frozen Products
Financial data
Revenues $60,000 $66,500 $50,500
Cost of goods sold $41,000 $51,000 $32,000
Store support $12,300 $15,300 $9,600
Activity-area usage (cost-allocation base)
Ordering (purchase orders) 44 24 14
Delivery (deliveries) 120 60 36
Shelf-stocking (hours) 170 150 20
Customer support (items sold) 15,400 20,200 7,960
Under its simple costing system, FS allocated support costs to products at the rate of 30% of the cost of goods sold.

Required:

1. Use the simple costing system to prepare a product-line profitability report for FS.

2. Use the ABC system to prepare a product-line profitability report for FS.

3. What new insights does the ABC system in requirement 2 provide to FS managers?

(1) Baked Goods profit $6,700, Milk and Fruit juice profit $200, Frozen Products profit $8,900 (2) Baked Goods profit $160, Milk and Fruit juice profit $2,870, Frozen Products Profit $12,860. (3) it provide insight to FS managers that Frozen Products is the most profitable among the three product lines.

Explanation:

(1) Baked Goods. Milk and Fruit juice. Frozen Products

$ $ $

Revenue. 60,000. 66,500. 50,500

Less : Cost of good sold 41,000. 51,000. 32,000

Gross Margin. 19,000. 15,500. 18,500

Less: Store Support. 12,300. 15,300. 9,600

Profit. 6,700. 200. 8,900

'

(2)

Baked Goods. Milk and Fruit juice. Frozen Products

$ $ $

Revenue. 60,000. 66,500. 50,500

Less Cost of good sold 41,000. 51,000. 32,000

Contribution. 19,000. 15,500. 18,500

Less Overhead

Ordering cost. 4,180. 2,280. 1,,330

Delivery&Receipt. 9,120. 4,560. 2,736

Shelf Stocking. 3,230. 2,850. 380

Customer Support & Assistant 2,310. 3,030. 1,194

Profit. 160. 2,870. 12,860

(3) The new insight to FS managers is that Frozen Products is the most profitable among the three products lines

Workings

Ordering cost ($95 × 44) = 4,180 ($95 × 24) = 2,280 ($95 × 14) = 1,330

Delivery &Receipt ($76 × 120) = 9,120 ($76 × 60) = 4,560 ($76 × 36) = 2,736

Shelf Stocking ($19 × 170) = 3,230 ($19 × 150) = 2,850 ( $19 × 20) = 380

Customer Support &Assistant ($0.15 × 15,400) = 2,310 ($0.15 × 20,200) = 3,030 ($0.15 × 7,960)= 1,194

answer; the nav calculated at the market close at 4: 00 pm new york time;