Question: Granger Supermarkets (GS) found that its ABC analysis provided important insights. GS extends the analysis to cover three more product lines: baked goods, milk and

 Granger Supermarkets (GS) found that its ABC analysis provided important insights.

GS extends the analysis to cover three more product lines: baked goods,

milk and fruit juice, and frozen products. It identifies four activities and

Granger Supermarkets (GS) found that its ABC analysis provided important insights. GS extends the analysis to cover three more product lines: baked goods, milk and fruit juice, and frozen products. It identifies four activities and the activity cost rates for each activity as provided (Click the icon to view the activity cost rates.) The revenues, cost of goods sold, store support costs, and activity area usage of the three product lines are as follows. (Click the icon to view the information for the three product lines.) Required Requirement 1. Use the simple costing system to prepare a product-line profitability report for GS. (Round the percentages to two decimal places, X.XX%. Use parentheses or a minus sign for an operating loss.) Milk and Fruit Frozen Baked Goods Juice Products Total Revenues 61,500 $ 77,500 $ 60,500 Costs Cost of goods sold Store support 36,000 10.800 48,000 14,400 34,000 10,200 Total costs Operating income Operating income/Revenues % % % Activity cost rates x Ordering $102 per purchase order Delivery and receipt of merchandise $78 per delivery Shelf-stocking $21 per hour Customer support and assistance $0.22 per item sold Info for the three product lines Milk and Fruit Juice Frozen Products Baked Goods Financial data Revenues $ 61,500 $ 77,500 $ 60,500 Cost of goods sold $ 36,000 $ 48,000 $ 34,000 Store support 10,800 $ 14,400 $ 10,200 Activity area usage (cost driver) Ordering (purchase orders) 25 20 15 Delivery (deliveries) 90 35 30 Shelf-stocking (hours) 190 180 40 Customer support (items sold) 13,500 17,500 8,000 Under its simple costing system, GS allocated support costs to products at the rate of 30% of cost of goods sold There are no bottle returns for any of these three product lines

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!