Concept explainers
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?
Trending nowThis is a popular solution!
Chapter 18 Solutions
Bundle: Financial & Managerial Accounting, Loose-leaf Version, 14th + Working Papers For Warren/reeve/duchac's Corporate Financial Accounting, 14th + ... Financial & Managerial Accounting,
- Cost 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_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 Pachec 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 June 30 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. 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_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_forwardALABAMA 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…arrow_forward
- 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 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_forwardTo better match cost to revenues Lewisville Corporation distributes its service department overhead costs to producing departments. Information for April is presented here. Maintenance Utilities Overhead costs incurred $18,700 $9,000 Service provided to: Maintenance Dept. 10% Utilities Dept. 20% Producing Dept. A 40% 30% Producing Dept. B 40% 60% Using the step method, how much of Lewisville's Corporation’s Utilities Department cost is allocated between Departments A and B? (order of allocation begins with Maintenance) Group of answer choices $9,900 $10,800 $12,740 $27,700 In order to better match cost with revenues, Lewisville Corporation distributes its service department overhead costs to producing departments. Information for April is presented here. Maintenance Utilities Overhead costs incurred $18,700 $9,000 Service provided to: Maintenance Dept. 10% Utilities Dept. 20%…arrow_forwardCost Flow Relationships The following information is available for the first year of operations of Creston Inc., a manufacturer of fabricating equipment: Sales $1,054,900 Gross profit 284,800 Indirect labor 94,900 Indirect materials 39,000 Other factory overhead 17,900 Materials purchased 538,000 Total manufacturing costs for the period 1,164,600 39,000 Materials inventory, end of period Using the above information, determine the following amounts: a. Cost of goods sold b. Direct materials cost c. Direct labor costarrow_forward
- Lewisville CorporationIn order to better match cost with revenues, Lewisville Corporation distributes its service department overhead costs to producing departments. Information for April is presented here. Maintenance Utilities Overhead costs incurred $18,700 $9,000 Service provided to: Maintenance Dept. 10% Utilities Dept. 20% Producing Dept. A 40% 30% Producing Dept. B 40% 60% Assume that Lewisville Corporation distributes service department overhead costs based on the algebraic method. What would be the formula to determine the total maintenance costs? Group of answer choices M = $18,700 + .10U M = $9,000 + .20U M = $18,700 + .30U + .40A + .40B M = $27,700 + .40A + .40Barrow_forwardXSport Sporting Goods Co. 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 $10,525,000 Sales—Summer Sports Division 13,610,000 Cost of Goods Sold—Winter Sports Division 6,280,000 Cost of Goods Sold—Summer Sports Division 7,868,000 Sales expense—Winter Sports Division 1,650,000 Sales expense—Summer Sports Division 1,894,000 Administrative Expense—Winter Sports Division 1,002,000 Administrative Expense—Summer Sports Division 1,204,400 Advertising Expense 479,000 Transportation Expense 144,500 Accounts Receivable Collection Expense 120,400 Warehouse Expense 1,164,000 The bases to be used in allocating expenses, together with other essential information, are as follows: A.…arrow_forwardJackson Company manufactures one main product and two by-products, A and B. For April, the following data are available: Main By- Product Product A B Total Sales Rs. 75,000 Rs. 6,000 Rs. 3,500 Rs. 84,500 Manufacturing cost after separation Rs. 11,500 Rs. 1,100 Rs. 900 Rs. 13,500 Marketing and administrative expenses 6,000 750 550 7,300 Manufacturing cost before separation 37,500 Profit allowed for A and B is 15% and 12%, respectively. Required: 1. Calculate manufacturing cost before separation for by-products A and B, using the market value (reversal cost) method. 2. Prepare an income statement, detailing sales and costs for each product. 3. Comment on the reliability of costing by-products A and B in relation to the assignment of balance joint cost on main product.arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial 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