Question

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?

Answer 1

Answer:(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