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

the world_record_egg gained more than 25 million likes in just 10 days after posting a image of an egg on 4 january with the caption: “let’s set a world record together and get the most liked post on instagram.”

the u.s. census bureau produces data on the population and economy nationwide. it can you to analyze the kind of people living in your neighborhood. it does not show you the market of people willing to buy your product or an existing market for your product. that will require more market research. the census bureau only gives you an insight to the demographics in your area.