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!
Students have asked these similar questions
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:
Air
Generators Compressors
Total
Revenue
$1,431,000
$2,094,800
$3,525,800
Cost of goods sold
1,073,250
1,571,100
2,644,350
Gross profit
$357,750
$523,700
$881,450
Selling and administrative expenses
189,650
Income from operations
$691,800
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…
Assume you are the department B manager for Marley's Manufacturing. Marley's operates under a cost-based transfer structure. Assume you receive the majority of your raw
materials from department A, which sells only to department B (they have no outside sales).
The income statement for Marley's Manufacturing is shown below:
Marley's Manufacturing
Income Statement
Month Ending August 31, 2018
Dept. A
Dept. B
Sales
$23,000
$52,000
Cost of goods sold
11,040
27,560
Gross profit
$11,960
$24,440
Utility expenses
1,380
3,640
Wages expense
5,980
10,920
Costs allocated from corporate
2,530
15,080
Total expenses
$9,890
$29,640
Operating income/(loss) in dollars
$2,070
-$5,200
Operating income/(loss) in percentage
9 %
-10 %
Assume the market price for the items your department purchase is 15% below what you are being charged by department A of Marley's Manufacturing.
Determine the operating income for department B, assuming department A "sold" department B 1,000 units during the month and…
ALABAMA CORPORATION Goals and Objectives Review of basic terminology Review basic accounting and journal entries to reflect the flow of costs Review preparation of income statement and supporting schedules for manufacturer given end-of-year information The company manufactures a single product, cleverly named Product X. The following information is available for the calendar year 2018 just completed, during which they produced and sold 200,000 units. Sales for the year was $2,400,000. During the year, the company paid a sales commission of 5 percent of sales. The corporate income tax rate was 20%. Direct materials purchases $300,000 Direct labor 140,000 Depreciation - factory equipment 45,000 Depreciation - factory building 30,000 Depreciation - headquarters building 50,000 Factory insurance 15,000 Property taxes: Factory 20,000 Headquarters 18,000 Utilities - factory 34,000 Utilities – sales 1,800 Administrative salaries 150,000 Indirect labor salaries 156,000 Sales office…
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
- Ellerson 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_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_forwardUse 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_forward
- Salespersons 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_forwardposting in accountarrow_forwardAssume you are the department B manager for Marley's Manufacturing. Marley's operates under a cost-based transfer structure. Assume you receive the majority of your raw materials from department A, which sells only to department B (they have no outside sales). The income statement for Marley's Manufacturing is shown below: Marley's ManufacturingIncome StatementMonth Ending August 31, 2018 Dept. A Dept. B Sales $21,000 $52,000 Cost of goods sold 10,290 27,560 Gross profit $10,710 $24,440 Utility expenses 1,050 3,640 Wages expense 5,460 10,400 Costs allocated from corporate 2,100 15,080 Total expenses $8,610 $29,120 Operating income/(loss) in dollars $2,100 -$4,680 Operating income/(loss) in percentage 10 % -9 % Assume the market price for the items your department purchase is 15% below what you are being charged by department A of Marley’s Manufacturing. Determine the operating income for department B, assuming department A…arrow_forward
- Please help mearrow_forwardAssume you are the department B manager for Marley's Manufacturing. Marley's operates under a cost-based transfer structure. Assume you receive the majority of your raw materials from department A, which sells only to department B (they have no outside sales). After calculating the operating income in dollars and operating income in percentage, analyze the following financial information to determine costs that may need further investigation. Marley's Manufacturing Income Statement Month Ending August 31, 2018 Dept. A Dept. B Sales $22,000 $52,000 Cost of goods sold 10,780 27,040 Gross profit $11,220 $24,960 Expenses: Utility expenses $880 $3,640 Wages expense 5,280 10,920 Costs allocated from corporate 1,980 14,560 Total expenses $8,140 $29,120 Operating income/(loss) in dollars $ $ Operating income/(loss) in percentage % Department B had an operating loss. Department A had an operating loss. Department B has a higher wage percent of sales. Department A receives a higher percent…arrow_forwardHelp pleasearrow_forward
- Cost Flow Relationships The following information is available for the first year of operations of Creston Inc., a manufacturer of fabricating equipment: Sales Gross profit Indirect labor Indirect materials Other factory overhead Materials purchased Total manufacturing costs for the period Materials inventory, end of period $1,337,000 361,000 120,300 49,500 22,700 681,900 1,476,000 49,500 Using the above information, determine the following amounts: a. Cost of goods sold b. Direct materials cost c. Direct labor costarrow_forwardProfit Center Responsibility Reporting Championship Sports Inc. operates two divisions-the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y9, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: Sales-Winter Sports Division $22,785,000 Sales-Summer Sports Division 25,172,000 Cost of Goods Sold-Winter Sports Division 13,671,000 Cost of Goods Sold-Summer Sports Division 14,539,000 Sales Expense-Winter Sports Division 3,906,000 Sales Expense-Summer Sports Division 3,472,000 Administrative Expense-Winter Sports Division 2,278,500 Administrative Expense-Summer Sports Division 2,235,100 Advertising Expense 941,000 Transportation Expense 411,600 Accounts Receivable Collection Expense 253,800 Warehouse Expense 2,170,000 The bases to be used in allocating expenses, together with other information, are as follows: a. Advertising…arrow_forwardAssume you are the department B manager for Marley's Manufacturing. Marley's operates under a cost-based transfer structure. Assume you receive the majority of your raw materials from department A, which sells only to department B (they have no outside sales). After calculating the operating income in dollars and operating income in percentage, analyze the following financial information to determine costs that may need further investigation. Marley's Manufacturing Income Statement Month ending August 31, 2019 Dept. A Dept. B Sales $22,000 $51,000 Cost of Goods Sold 10,560 26,520 Gross profit $11,440 $24,480 Utility expenses 1,000 3,200 Wages expense 5,500 10,200 Costs allocated from Corporate 2,200 15,000 Total expenses $8,700 $28,400 Operating Income/(loss) $ ? ? Operating income/(loss) % ? ? Which of these costs may need further…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
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
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
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