Gabriel Supermarkets (GS) 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 and their activity cost rates as follows: (Click the icon to view the activity cost rates)

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter9: Responsibility Accounting And Decentralization
Section: Chapter Questions
Problem 4EA: The following information is from Daves Sporting Goods. Daves is a Midwest sporting goods store with...
icon
Related questions
icon
Concept explainers
Topic Video
Question
Gabriel Supermarkets (GS) 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 and their activity cost rates as follows:
i (Click the icon to view the activity cost rates.)
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:
(Click the icon to view the information for the three product lines.)
Read the requirements.
Requirement 1. Use the simple costing system to prepare a product-line profitability report for GS. (Round the percentages to the nearest hundredth percent, X.XX%.
Frozen
Products
Revenues
Costs
Cost of goods sold
Store support
Total costs
Operating income
Operating income/Revenues
More info
Milk and
Baked Goods Fruit Juice
Ordering
Delivery and receipt of merchandise
Shelf-stocking
Customer support and assistance
Print
%
%
$96 per purchase order
$75 per delivery
$24 per hour
$0.16 per item sold
Done
%
X
Total
%
(...)
Requirements
Print
Data table
Done
Financial data
Revenues
Cost of goods sold
Store support
Activity-area usage (cost-allocation base)
Ordering (purchase orders)
Delivery (deliveries)
1. Use the simple costing system to prepare a product-line profitability report for
GS.
2. Use the ABC system to prepare a product-line profitability report for GS.
3. What new insights does the ABC system in requirement 2 provide to GS
managers?
-
X
Milk and
Baked Goods Fruit Juice
Print
$
$
$
58,500 $
35,000 $
10,500 $
25
38
165
Shelf-stocking (hours)
Customer support (items sold)
11,000
17,000
Under its simple costing system, GS allocated support costs to products at the rate
of 30% of cost of goods sold.
30
96
185
66,000 $
44,000 $
13,200 $
Done
Frozen
Products
-
52,500
31,000
9,300
10
26
25
8,000
Transcribed Image Text:Gabriel Supermarkets (GS) 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 and their activity cost rates as follows: i (Click the icon to view the activity cost rates.) 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: (Click the icon to view the information for the three product lines.) Read the requirements. Requirement 1. Use the simple costing system to prepare a product-line profitability report for GS. (Round the percentages to the nearest hundredth percent, X.XX%. Frozen Products Revenues Costs Cost of goods sold Store support Total costs Operating income Operating income/Revenues More info Milk and Baked Goods Fruit Juice Ordering Delivery and receipt of merchandise Shelf-stocking Customer support and assistance Print % % $96 per purchase order $75 per delivery $24 per hour $0.16 per item sold Done % X Total % (...) Requirements Print Data table Done Financial data Revenues Cost of goods sold Store support Activity-area usage (cost-allocation base) Ordering (purchase orders) Delivery (deliveries) 1. Use the simple costing system to prepare a product-line profitability report for GS. 2. Use the ABC system to prepare a product-line profitability report for GS. 3. What new insights does the ABC system in requirement 2 provide to GS managers? - X Milk and Baked Goods Fruit Juice Print $ $ $ 58,500 $ 35,000 $ 10,500 $ 25 38 165 Shelf-stocking (hours) Customer support (items sold) 11,000 17,000 Under its simple costing system, GS allocated support costs to products at the rate of 30% of cost of goods sold. 30 96 185 66,000 $ 44,000 $ 13,200 $ Done Frozen Products - 52,500 31,000 9,300 10 26 25 8,000
Expert Solution
steps

Step by step

Solved in 5 steps with 4 images

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning