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:
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:
The controller determined the following activity-base usage information about each product:
Determine the activity cost of each product for sales order processing and post-sale customer service activities.
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 operating income to sales percentages for each product. (Round to two decimal places.)
Interpret the product profitability report. How should management respond to the report?
Trending nowThis is a popular solution!
Chapter 18 Solutions
Financial And Managerial Accounting
- 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). 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 $50,000 Cost of goods sold 10,340 26,000 Gross profit $11,660 $24,000 Expenses: Utility expenses $1,320 $2,500 Wages expense 5,280 10,000 Costs allocated from corporate 2,200 14,000 Total expenses $8,800 $26,500 Operating income/(loss) in dollars %$4 % Operating income/(loss) in percentage %24arrow_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_forwardElmo Security Consultants (ESC) offer a standardized review of data security for small business owners. The following data apply to the provision of these reviews: Sales price per unit (1 unit = 1 review with recommendations) Fixed costs (per month): Selling and administration Production overhead (e.g., rent of facilities) Variable costs (per review): Labor for oversight and feedback Outsourced security analysis Materials used in reviews Review overhead Selling and administration (e.g., scheduling and billing) Number of reviews per month Required: a. Variable review (production) cost per unit b. Variable total cost per unit c. Full cost per unit d. Full absorption cost per unit e. Prime cost per unit f. Conversion cost per unit Calculate the amount for each of the following (one unit = one review) if the number of reviews is 2,500 per month. Also calculate if the number of reviews decreases to 2,000 per month. g. Contribution margin per unit h. Gross margin per unit 2,500 Reviews $ 500…arrow_forward
- Elmo Security Consultants (ESC) offer a standardized review of data security for small business owners. The following data apply to the provision of these reviews: Sales price per unit (1 unit = 1 review with recommendations) Fixed costs (per month): Selling and administration Production overhead (e.g., rent of facilities) Variable costs (per review): Labor for oversight and feedback. Outsourced security analysis Materials used in reviews Review overhead Selling and administration (e.g., scheduling and billing) Number of reviews per month a. Variable review (production) cost per unit b. Variable total cost per unit c. Full cost per unit d. Full absorption cost per unit e. Prime cost per unit Required: Calculate the amount for each of the following (one unit = one review) if the number of reviews is 2,500 per month. Also calculate if the number of reviews decreases to 2,000 per month. Note: Do not round intermediate calculations. Round your final answers to the nearest whole dollar. f.…arrow_forwardElmo Security Consultants (ESC) offer a standardized review of data security for small business owners. The following data apply to the provision of these reviews: Sales price per unit (1 unit 1 review with recommendations) Fixed costs (per month): Selling and administration Production overhead (e.g., rent of facilities) Variable costs (per review): Labor for oversight and feedback Outsourced security analysis Materials used in reviews Review overhead Selling and administration (e.g., scheduling and billing) Number of reviews per month a Variable review (production) cost per unit b. Variable total cost per unit Required: Calculate the amount for each of the following (one unit = one review) if the number of reviews is 2,500 per month. Also calculate if the number of reviews decreases to 2,000 per month. c. Full cost per unit d. Full absorption cost per unit e. Prime cost per unit f. Conversion cost per unit g Contribution margin per unit h. Gross margin per unit 2,500 Reviews $ 500…arrow_forward[The following information applies to the questions displayed below.] Arctica manufactures snowmobiles and ATVs. These products are made in different departments, and each department has its own manager. Each responsibility performance report includes only those costs that the department manager can control: direct materials, direct labor, supplies used, and utilities. Budget For Year Ended December 31 Direct materials Direct labor Department manager salaries Supplies used Utilities Rent Totals Controllable Costs Direct materials Direct labor Supplies used Utilities Totals Responsibility Accounting Performance Report- Manager, Snowmobile Department For Year Ended December 31 $ Snowmobile $ 21,520 12,400 6,300 5,500 560 7,700 $ 53,980 Budgeted Prepare a responsibility accounting performance report for the snowmobile department. (Under budget amounts should be indicated by a minus sign.) 0 $ ATV $ 29,500 22,500 7,200 Actual 1,100 740 8,300 $ 69,340 0 $ Actual Snowmobile $ 21,420 12,860…arrow_forward
- Toxaway Company is a merchandiser that segments its business into two divisions-Commercial and Residential. The company's accounting intern was asked to prepare segmented income statements that the company's divisional managers could use to calculate their break-even points and make decisions. She took the prior month's companywide income statement and prepared the absorption format segmented income statement shown below: erences Mc. Graw H&M Sales Cost of goods sold Gross margin Selling and administrative expenses Net operating income Total Company $ 825,000 555,500 269,500 260,000 $9,500 Commercial Residential $ 275,000 $ 550,000 154,000 401,500 121,000 148,500 114,000 146,000 $ 7,000 $ 2,500 In preparing these statements, the intern determined that Toxaway's only variable selling and administrative expense is a 10% sales commission on all sales. The company's total fixed expenses include $79,500 of common fixed expenses that would continue to be incurred even if the Commercial or…arrow_forwardThe following situations describe decision scenarios that could use managerial accounting information: The manager of High Times Restaurant wishes to determine the price to charge for various lunch plates. By evaluating the cost of leftover materials, the plant manager of a precision tool facility wishes to determine how effectively the plant is being run. The division controller of West Coast Supplies needs to determine the cost of products left in inventory. The manager of the Maintenance Department of a large manufacturing company wishes to plan next year’s anticipated expenditures. For each situation, discuss how managerial accounting information could be used. b) What are the major differences between managerial accounting and financial accounting?arrow_forwardBig Apple Design Company specializes in designing commercial office space in Chicago. The firm’s president recently reviewed the following income statement and noticed that operating profits were below her expectations. She had a hunch that certain customers were not profitable for the company and asked the controller to perform a customer-profitability analysis showing profitability by customer for the month of March. Required: Put yourself in the position of Big Apple’s controller and write a memo to the president to accompany the customer-profitability graph. Comment on the implications of the customer-profitability analysis and raise four or more questions that should be addressed by the firm’smanagement team.arrow_forward
- Accounting records for The Ralston Company show the following for the most recent fiscal year. Units produced and sold Total revenues and costs Sales revenue Direct materials costs Direct labor costs Variable manufacturing overhead Fixed manufacturing overhead Variable marketing and administrative costs Fixed marketing and administrative costs Required: a. Prepare a gross margin Income statement. b. Prepare a contribution margin Income statement. Required A Required B Complete this question by entering your answers in the tabs below. Prepare a gross margin income statement. Gross Margin Income Statement 59,500arrow_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 ManufacturingIncome StatementMonth Ending August 31, 2018 Dept. A Dept. B Sales $21,000 $52,000 Cost of goods sold 9,870 27,040 Gross profit $11,130 $24,960 Expenses: Utility expenses $840 $3,120 Wages expense 5,040 10,920 Costs allocated from corporate 2,100 14,560 Total expenses $7,980 $28,600 Operating income/(loss) in dollars $fill in the blank 1 $fill in the blank 2 Operating income/(loss) in percentage fill in the blank 3 % fill in the blank 4 % Department B had…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 ManufacturingIncome StatementMonth Ending August 31, 2018 Dept. A Dept. B Sales $23,000 $51,000 Cost of goods sold 11,040 26,520 Gross profit $11,960 $24,480 Expenses: Utility expenses $920 $2,550 Wages expense 5,980 10,710 Costs allocated from corporate 2,300 14,280 Total expenses $9,200 $27,540 Operating income/(loss) in dollars $fill in the blank 1 $fill in the blank 2 Operating income/(loss) in percentage fill in the blank 3 % fill in the blank 4 %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
- 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 LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning