Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
16th Edition
ISBN: 9780134475585
Author: Srikant M. Datar, Madhav V. Rajan
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 5, Problem 5.27E
ABC, retail product-line profitability. 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 and 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:
Under its simple costing system, FS allocated support costs to products at the rate of 30% of cost of goods sold.
- 1. Use the simple costing system to prepare a product-line profitability report for FS.
Required
- 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?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Additional Activities
Now that you have learned how to forecast revenues and cost of the
business, investigate how these concepts are being applied by existing businesses
in your community. Using the table below, fill in the necessary information based on
your investigation.
Daily Revenue and Cost
Name of Business:
Projected
Projected
Volume
Revenue
Projected
Cost
Mark-up
Selling
(D)
(E)
Costs of
per Unit
Price
Average
Merchandisel
Purchases
(A)
(B)
(C)
No. of
Products
(Daily)
(Daily)
Items Sold
(Daily)
(B)= (A x
C =A +
E = C x D
K = (A x D)
.50)
B
Ex. Bag
150.00
75.00
225.00
10
2250
1500
yd belugm
COLLEC
tol elubom r borlain even uoy Jar wo
Aan pese
Customer profitability, customer-cost hierarchy. Enviro-Tech has only two retail and two wholesale customers. Information
relating to each customer for 2017 follows (in thousands):
Wholesale Customers
Retail Customers
North America
South America
Wholesaler
Wholesaler
Green Energy
Global Power
Revenues at list prices
Discounts from list prices
Cost of goods sold
Delivery costs
Order processing costs
$375,000
25,800
$590,000
$175,000
$130,000
47,200
8,400
590
285,000
510,000
144,000
95,000
2,230
2,180
4,550
6,710
2,145
3,820
5,980
1,130
Cost of sales visit
6,300
2,620
2,620
1,575
Enviro-Tech's annual distribution-channel costs are $33 million for wholesale customers and $12 million for retail
customers. The company's annual corporate-sustaining costs, such as salary for top management and general-
administration costs are $48 million. There is no cause-and-effect or benefits-received relationship between any cost-
allocation base and corporate-sustaining costs. That is, Enviro-Tech could…
The manager of the West store has concerns relating to the store’s financial performance and has asked for help analyzing transfer costs.
After calculating the operating income in dollars and the operating income percent, analyze the following financial information to determine costs that may need further investigation.
It may be helpful to perform a vertical analysis (i.e., perform a vertical analysis).
warehouse
west store
sales
$18,920
$43,860
cost of goods sold
9,082
21,053
gross profit
$9,838
$22,807
selling expenses
860
2,752
wages expense
4,730
15,351
costs allocated from corporate
2,838
4,386
Total expenses
$8,428
$22,489
operating income/(loss) $
?
?
Operating Income/(loss) %
?
?
Chapter 5 Solutions
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
Ch. 5 - What is broad averaging, and what consequences can...Ch. 5 - Why should managers worry about product...Ch. 5 - What is costing system refinement? Describe three...Ch. 5 - What is an activity-based approach to designing a...Ch. 5 - Describe four levels of a cost hierarchy.Ch. 5 - Why is it important to classify costs into a cost...Ch. 5 - What are the key reasons for product cost...Ch. 5 - Prob. 5.8QCh. 5 - Department indirect-cost rates are never...Ch. 5 - Prob. 5.10Q
Ch. 5 - Prob. 5.11QCh. 5 - Prob. 5.12QCh. 5 - Activity-based costing is the wave of the present...Ch. 5 - Increasing the number of indirect-cost pools is...Ch. 5 - The controller of a retail company has just had a...Ch. 5 - Conroe Company is reviewing the data provided by...Ch. 5 - Prob. 5.17MCQCh. 5 - Cost hierarchy. Roberta, Inc., manufactures...Ch. 5 - ABC, cost hierarchy, service. (CMA, adapted)...Ch. 5 - Alternative allocation bases for a professional...Ch. 5 - Plant-wide, department, and ABC Indirect cost...Ch. 5 - Plant-wide, department, and activity-cost rates....Ch. 5 - ABC, process costing. Sander Company produces...Ch. 5 - Department costing, service company. DLN is an...Ch. 5 - Activity-based costing, service company....Ch. 5 - Activity-based costing, manufacturing. Decorative...Ch. 5 - ABC, retail product-line profitability. Fitzgerald...Ch. 5 - Prob. 5.28ECh. 5 - Activity-based costing. The job-costing system at...Ch. 5 - ABC, product costing at banks,...Ch. 5 - Problems 5-31 Job costing with single direct-cost...Ch. 5 - Job costing with multiple direct-cost categories,...Ch. 5 - Job costing with multiple direct-cost categories,...Ch. 5 - First-stage allocation, time-driven activity-based...Ch. 5 - First-stage allocation, time-driven activity-based...Ch. 5 - Department and activity-cost rates, service...Ch. 5 - Activity-based costing, merchandising. Pharmahelp,...Ch. 5 - Choosing cost drivers, activity-based costing,...Ch. 5 - ABC, health care. Crosstown Health Center runs two...Ch. 5 - Unused capacity, activity-based costing,...Ch. 5 - Unused capacity, activity-based costing,...Ch. 5 - ABC, implementation, ethics. (CMA, adapted) Plum...Ch. 5 - Activity-based costing, activity-based management,...
Knowledge Booster
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
- The following information is from Good Read Books. Good Read is a regional book store with three regional stores. The May income statement for all stores is shown. A. Comment on the operating income results for each store. B. Now assume the costs allocated from corporate is an uncontrollable cost for each store. How does this change your assessment of each store?arrow_forwardCustomers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Additional data concerning the usage of the activities by the various customers are also provided: Required: (Note: Round answers to two decimal places.) 1. Calculate a cost per account per year by dividing the total cost of processing and maintaining checking accounts by the total number of accounts. What is the average fee per month that the bank should charge to cover the costs incurred because of checking accounts? 2. Calculate a cost per account by customer category by using activity rates. 3. Currently, the bank offers free checking to all of its customers. The interest revenues average 90 per account; however, the interest revenues earned per account by category are 80, 100, and 165 for the low-, medium-, and high-balance accounts, respectively. Calculate the average profit per account (average revenue minus average cost from Requirement 1). Then calculate the profit per account by using the revenue per customer type and the unit cost per customer type calculated in Requirement 2. 4. CONCEPTUAL CONNECTION After the analysis in Requirement 3, a vice president recommended eliminating the free checking feature for low-balance customers. The bank president expressed reluctance to do so, arguing that the low-balance customers more than made up for the loss through cross-sales. He presented a survey that showed that 50% of the customers would switch banks if a checking fee were imposed. Explain how you could verify the presidents argument by using ABC.arrow_forwardRalston Dairy gathered this data about the two products that it produces: Products Current SalesValue Estimated AddedProcessing Costs Sales Value IfProcessing Further Frozen yogurt $8,200 $2,100 $11,300 Ice cream 12,100 7,100 18,400 Which of the products should be processed further? Frozen Yougurt because profit increase by $???arrow_forward
- Customers as a Cost ObjectMorrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, mediumbalances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Required:(Note: Round answers to two decimal places.)1. Calculate a cost per account per year by dividing the total cost of processing andmaintaining checking accounts by the total number of accounts. What is the average feeper month that the bank should charge to cover the costs incurred because of checkingaccounts?2. Calculate a cost per account by customer category by using activity rates.3. Currently, the bank offers free checking to all of its customers. The interest revenuesaverage $90 per account; however, the interest revenues earned per account by categoryare $80, $100, and $165 for the low-, medium-, and high-balance…arrow_forwardRalston Dairy gathered this data about the two products that it produces: Ralston Dairy data Product Current Sales Value Estimated Added Processing Costs Sales Value if Processed Further Frozen yogurt $8,000 $2,000 $11,000 Ice cream 12,000 7,000 18,000 A) What is the effect on profit if the frozen yogurt is processed further? If it is negative, use a dash - not parentheses ( ). B) What is the effect on profit if the ice cream is processed further? If it is negative, use a dash - not parentheses ( ).arrow_forwardThe following information is from Daves Sporting Goods. Daves is a Midwest sporting goods store with three regional stores. The August income statement for all stores is shown. A. Comment on the operating income results for each store. B. Now assume the costs allocated from corporate is an uncontrollable cost for each store. How does this change your assessment of each store?arrow_forward
- Total cost method of product pricing Based on the data presented in Exercise 17, assume that Smart Stream Inc. uses the total cost method of applying the cost-plus approach to product pricing. A. Determine the total costs and the total cost amount per unit for the production and sale of 10,000 cellular phones. B. Determine the total cost markup percentage (rounded to two decimal places) for cellular phones. C. Determine the selling price of cellular phones. (Round markup to the nearest dollar.)arrow_forwardTim’s Bicycle Shop sells 21-speed bicycles. For purposes of a cost-volume-profit analysis, the shop owner has divided sales into two categories, as follows: Product Type Sales Price Invoice Cost Sales CommissionHigh-quality ....................................$500 $275 $25Medium-quality .............................. 300 135 15 Three-quarters of the shop’s sales are medium-quality bikes. The shop’s annual fixed expenses are $65,000. (In the following requirements, ignore income taxes.)Required:1. Compute the unit contribution margin for each product type.2. What is the shop’s sales mix?3. Compute the weighted-average unit contribution margin, assuming a constant sales mix.4. What is the shop’s break-even sales volume in dollars? Assume a constant sales mix.5. How many bicycles of each type must be sold to earn a target net income of $48,750? Assume a constant sales mix.arrow_forwardGiven the constant profit margin of 25%, determine the primary or net income for each SKU. Type your answers below. Note: 5th column is for RETURNS FROM CUSTOMERS due to product damages and defects. SKUS QUANTITY SELLING RETURNS NET SOLD PRICE FROM INCOME 1 SPRITE 2L 67 95.00 4 SPRITE 1.5L SPRITE 1L SPRITE 500ML SPRITE 355ML CAN CBTL COFFEE MOCHA 3-in-1 NESCAFE MOCHA LATTE 3-in-1 SAN MIG SUGAR FREE COFFEE 3-in-1 SWISS MISS DARK COCOA MIX 3-in-1 10 SWISS MISS MALLOWS COCOA MIX 3-in-1 2 101 70.00 7 3 59 50.00 4 45 25.00 70 25.00 3 42 30.00 2 7 55 15.00 3 8 90 10.00 5 9. 35 14.00 1 59 12.00 4arrow_forward
- Requirement 1. Use the ABC information to compute the operating income of each customer in August 2020. Comment on the results and what, if anything, Flair should do. (Round your answers to the nearest whole dollar. Use parentheses or a minus sign for operating losses.) Revenues Cost of goods sold Gross margin Operating costs Operating income(loss) Albany Pharmacyarrow_forwardCost of Goods Sold As an accountant for Lee Company, your supervisor gave you the following calculations of the gross profit for the first quarter: Alternative Sales ($50 per unit) Cost of Goods Sold Gross Profit A $500,000 $200,000 $300,000 B 500,000 228,000 272,000 C 500,000 213,333 286,667 The three alternative cost flow assumptions are FIFO, average, and LIFO (the alternatives are not necessarily presented in this sequence). Lee uses the periodic inventory system. The computation of the cost of goods sold under each alternative is based on the following data: Units Cost/Unit Inventory, January 1 12,000 $20 Purchase, January 10 4,000 21 Purchase, February 15 6,000 22 Purchase, March 10 8,000 23 1. Prepare schedules proving the cost of goods sold shown here under each of the three alternatives. For average cost. LEE COMPANY Schedules of Cost of Goods Sold For First Quarter Ended March 31 FIFO LIFO Average Beginning…arrow_forwardTB Problem 12-90 Midtown Retail operates a retail store... Midtown Retail operates a retail store in Kansas City, MO., and St. Louis, MO. The following information relates to the Kansas City facility: • The store sold 61,800 units at $34.00 each, after having purchased the units from various suppliers for $26.50. Kansas City salespeople are paid a 1% commission based on gross sales dollars. • Kansas City's sales manager oversees the placement of local advertising contracts, which totaled $70,000 for the year. Local property taxes amounted to $30,500. • The sales manager's $81,000 salarv is set by Kansas City's store manager. In contrast, the store manager's $150,000 salary is determined by Midtown's vice president. • Kansas City incurred $14,800 of other noncontrollable costs. • Nontraceable (common) corporate overhead totaled $84,000. ok nt ences Midtown's corporate headquarters is located in St. Louis, and the company uses responsibility accounting to evaluate performance. Required:…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
How to Estimate Project Costs: A Method for Cost Estimation; Author: Online PM Courses - Mike Clayton;https://www.youtube.com/watch?v=YQ2Wi3Jh3X0;License: Standard Youtube License