Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started