Financial & Managerial Accounting
14th Edition
ISBN: 9781337119207
Author: Carl Warren, James M. Reeve, Jonathan Duchac
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
thumb_up100%
Chapter 18, Problem 18.18EX
Construct and interpret a product profitability report, allocating selling and administrative expenses
Naper Inc. manufactures power equipment. Naper has two primary products—generators and air compressors. The following report was prepared by the controller for Naper’s senior marketing management for the year ended December 31:
| Generators | Air Compressors | Total | |
| Revenue | $4,200,000 | $3,000,000 | $7,200,000 |
| Cost of goods sold | 2,940,000 | 2,100,000 | 5,040,000 |
| Gross profit | $1,260,000 | $ 900,000 | $2,160,000 |
| Selling and administrative expenses | 610,000 | ||
| Income from operations | $1,550,000 |
The marketing management team was concerned that the selling and administrative expenses were not traced to the products. Marketing management believed that some products consumed larger amounts of selling and administrative expense than did other products. To verify this, the controller was asked to prepare a complete product profitability report, using activity-based costing.
The controller determined that selling and administrative expenses consisted of two activities: sales order processing and post-sale customer service. The controller was able to determine the activity base and activity rate for each activity, as follows:
| Activity | Activity Base | Activity Rate |
| Sales order processing | Sales orders | $ 65 per sales order |
| Post-sale customer service | Service requests | $200 per customer service request |
The controller determined the following activity-base usage information about each product:
| Generators | Air Compressors | |
| Number of sales orders | 3,000 | 4,000 |
| Number of service requests | 225 | 550 |
A. Determine the activity cost of each product for sales order processing and post-sale customer service activities.
B. Use the information in (A) to prepare a complete product profitability report dated for the year ended December 31. Compute the gross profit to sales and the income from operations to sales percentages for each product. (Round to two decimal places.)
C. Interpret the product profitability report. How should management respond to the report?
Expert Solution & Answer
Trending nowThis is a popular solution!
Chapter 18 Solutions
Financial & Managerial Accounting
Ch. 18 - Why would management be concerned about the...Ch. 18 - Why would a manufacturing company with multiple...Ch. 18 - How do the multiple production department and the...Ch. 18 - Under what two conditions would the multiple...Ch. 18 - Prob. 5DQCh. 18 - Prob. 6DQCh. 18 - Prob. 7DQCh. 18 - Under what circumstances might the activity-based...Ch. 18 - Prob. 9DQCh. 18 - Prob. 10DQ
Ch. 18 - Single plantwide factory overhead rate The total...Ch. 18 - Multiple production department factory overhead...Ch. 18 - Activity-based costing: factory overhead costs The...Ch. 18 - Activity-based costing: selling and administrative...Ch. 18 - Activity-based costing for a service business...Ch. 18 - Single plantwide factory overhead rate Nixon...Ch. 18 - Single plantwide factory overhead rate Mozart...Ch. 18 - Single plantwide factory overhead rate Sally...Ch. 18 - Product costs and product profitability reports,...Ch. 18 - Multiple production department factory overhead...Ch. 18 - Single plantwide and multiple production...Ch. 18 - Single plantwide and multiple production...Ch. 18 - Identifying activity bases in an activity-based...Ch. 18 - Product costs using activity rates Nozama.com Inc....Ch. 18 - Product costs using activity rates Atlas...Ch. 18 - Activity rates and product costs using...Ch. 18 - Activity cost pools, activity rates, and product...Ch. 18 - Activity-based costing and product cost distortion...Ch. 18 - Multiple production department factory overhead...Ch. 18 - Activity-based costing and product cost distortion...Ch. 18 - Single plantwide rate and activity-based costing...Ch. 18 - Evaluating selling and administrative cost...Ch. 18 - Construct and interpret a product profitability...Ch. 18 - Activity-based costing and customer profitability...Ch. 18 - Activity-based costing for a service company...Ch. 18 - Activity-based costing for a service company...Ch. 18 - Single plantwide factory overhead rate Orange...Ch. 18 - Multiple production department factory overhead...Ch. 18 - Activity-based and department rate product costing...Ch. 18 - Activity-based product costing Mello Manufacturing...Ch. 18 - Allocating selling and administrative expenses...Ch. 18 - Product costing and decision analysis for a...Ch. 18 - Single plantwide factory overhead rate Spoiled Cow...Ch. 18 - Multiple production department factory overhead...Ch. 18 - Activity-based department rate product costing and...Ch. 18 - Activity-based product costing Sweet Sugar Company...Ch. 18 - Allocating selling and administrative expenses...Ch. 18 - Product costing and decision analysis for a...Ch. 18 - Activity-based product cost improvement Gourmet...Ch. 18 - Prob. 2ADMCh. 18 - Production run size and activity improvement...Ch. 18 - Prob. 4ADMCh. 18 - Ethics in Action The controller of Tri Con Global...Ch. 18 - Communication The controller of New Wave Sounds...
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
- Use the following information for Exercises 2-47 through 2-49. Jasper Company provided the following information for last year: Last year, beginning and ending inventories of work in process and finished goods equaled zero. Exercise 2-49 Income Statement Refer to the information for Jasper Company on the previous page. Required: 1. Prepare an income statement for Jasper for last year. Calculate the percentage of sales for each line item on the income statement. (Note: Round percentages to the nearest tenth of a percent.) 2. CONCEPTUAL CONNECTION Briefly explain how a manager could use the income statement created for Requirement 1 to better control costs.arrow_forwardCost of Goods Manufactured, Income Statement W. W. Phillips Company produced 4,000 leather recliners during the year. These recliners sell for 400 each. Phillips had 500 recliners in finished goods inventory at the beginning of the year. At the end of the year, there were 700 recliners in finished goods inventory. Phillips accounting records provide the following information: Required: 1. Prepare a statement of cost of goods manufactured. 2. Compute the average cost of producing one unit of product in the year. 3. Prepare an income statement for external users.arrow_forwardEllerson Company provided the following information for the last calendar year: During the year, direct materials purchases amounted to 278,000, direct labor cost was 189,000, and overhead cost was 523,000. During the year, 100,000 units were completed. Refer to Exercise 2.21. Last calendar year, Ellerson recognized revenue of 1,312,000 and had selling and administrative expenses of 204,600. Required: 1. What is the cost of goods sold for last year? 2. Prepare an income statement for Ellerson for last year.arrow_forward
- Financial statements of a manufacturing firm The following events took place for Sorensen Manufacturing Company during January, the first month of its operations as a producer of digital video monitors: a. Purchased 250,000 of materials. b. Used 180,000 of direct materials in production. c. Incurred 450,000 of direct labor wages. d. Incurred 180,000 of factory overhead. e. Transferred 760,000 of work in process to finished goods. f. Sold goods for 1,200,000. g. Sold goods with a cost of 675,000 h. Incurred 215,000 of selling expense i. Incurred 125,000 of administrative expense Using the information given, complete the following: a. Prepare the January income statement for Sorensen Manufacturing Company. b. Determine the inventory balances at the end of the first month of operations.arrow_forwardUse the following information for Brief Exercise: Morning Smiles Coffee Company manufactures Stoneware French Press coffee makers and sold 8,000 coffee makers during the month of March at a total cost of 612,500. Each coffee maker sold at a price of 100. Morning Smiles also incurred two types of selling costs: commissions equal to 5% of the sales price and other selling expense of 45,000. Administrative expense totaled 47,500. 2-33 Income Statement Percentages Refer to the information for Morning Smiles Coffee Company on the previous page. Required: Prepare an income statement for Morning Smiles for the month of March and calculate the percentage of sales revenue represented by each line of the income statement. (Note: Round answers to one decimal place.)arrow_forwardClassify costs Seymour Clothing Co. manufactures a variety of clothing types for distribution to several major retail chains. The following costs are incurred in the production and sale of blue jeans: Shipping boxes used to ship orders Consulting fee of 200,000 paid to industry specialist for marketing advice Straight-line depreciation on sewing machines Salesperson's salary, 10,000 plus 2% of the total sales Fabric Dye Thread Salary of designers Brass buttons Legal fees paid to attorneys in defense of the company in a patent infringement suit, 50,000 plus 87 per hour Insurance premiums on property, plant, and equipment, 70,000 per year plus 5 per 30,000 of insured value over 8,000,000 Rental costs of warehouse, 5,000 per month plus 4 per square foot of storage used Supplies Leather for patches identifying the brand on individual pieces of apparel Rent on plant equipment, 50,000 per year Salary of production vice president Janitorial services, 2,200 per month Wages of machine operators Electricity costs of 0.10 per kilowatt-hour Property taxes on property, plant, and equipment Instructions Classify the preceding costs as either fixed, variable, or mixed. Use the following tabular headings and place an X in the appropriate column. Identify each cost by letter in the cost column.arrow_forward
- Using the information in the previous exercises about Marleys Manufacturing, determine the operating income for department B, assuming department A sold department B 1,000 units during the month and department A reduces the selling price to the market price.arrow_forwardSalespersons report and analysis Walthman Industries Inc. employs seven salespersons to sell and distribute its product throughout the state. Data taken from reports received from the salespersons during the year ended December 31 are as follows: Instructions 1. Prepare a table indicating contribution margin, variable cost of goods sold as a percent of sales, variable selling expenses as a percent of sales, and contribution margin ratio by salesperson. (Round whole percent to one digit after decimal point.) 2. Which salesperson generated the highest contribution margin ratio for the year and why? 3. Briefly list factors other than contribution margin that should be considered in evaluating the performance of salespersons.arrow_forwardCost of quality and value-added/non-value-added reports for a service company A. Using the information in Exercise 17, identify the cost of quality classification for each activity and whether the activity is value-added or non-value-added. B. Prepare a cost of quality report. Assume that sales are 3,000,000. (Round percentages to one decimal place.) C. Prepare a value-added/non-value-added analysis. D. Interpret the information in (B) and (C).arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
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
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Cost Classifications - Managerial Accounting- Fixed Costs Variable Costs Direct & Indirect Costs; Author: Accounting Instruction, Help, & How To;https://www.youtube.com/watch?v=QQd1_gEF1yM;License: Standard Youtube License