Concept explainers
Allocating selling and administrative expenses using activity-based costing
Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows:
In addition, the company incurs selling and administrative expenses of $414,030. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related to its three major nonmanufacturing activities: customer service, sales order processing, and advertising support. The advertising support is in the form of advertisements that are placed by Shrute Inc. to support the retailer’s sale of Shrute copiers to consumers. The budgeted activity costs and activity bases associated with these activities are:
Activity-base usage and unit volume information for the three customers is as follows:
Instructions
Determine the activity rates for each of the three nonmanufacturing activities.
Determine the activity costs allocated to the three customers, using the activity rates in (1).
Construct customer profitability reports for the three customers, dated for the year ended December 31, using the activity costs in (2). The reports should disclose the gross profit and operating income associated with each customer.
Provide recommendations to management, based on the profitability reports in (3).
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Managerial Accounting
- Cicleta Manufacturing has four activities: receiving materials, assembly, expediting products, and storing goods. Receiving and assembly are necessary activities; expediting and storing goods are unnecessary. The following data pertain to the four activities for the year ending 20x1 (actual price per unit of the activity driver is assumed to be equal to the standard price): Required: 1. Prepare a cost report for the year ending 20x1 that shows value-added costs, non-value-added costs, and total costs for each activity. 2. Explain why expediting products and storing goods are non-value-added activities. 3. What if receiving cost is a step-fixed cost with each step being 1,500 orders whereas assembly cost is a variable cost? What is the implication for reducing the cost of waste for each activity?arrow_forwardBounce Back Insurance Company carries three major lines of insurance: auto, workers compensation, and homeowners. The company has prepared the following report: Management is concerned that the administrative expenses may make some of the insurance lines unprofitable. However, the administrative expenses have not been allocated to the insurance lines. The controller has suggested that the administrative expenses could be assigned to the insurance lines using activity-based costing. The administrative expenses are comprised of five activities. The activities and their rates are as follows: Activity-base usage data for each line of insurance were retrieved from the corporate records as follows: a. Complete the product profitability report through the administrative activities. Determine the operating income as a percent of premium revenue, rounded to the nearest whole percent. b. Interpret the report.arrow_forwardA manufacturing company has two service and two production departments. Building Maintenance and Factory Office are the service departments. The production departments are Assembly and Machining. The following data have been estimated for next years operations: The direct charges identified with each of the departments are as follows: The building maintenance department services all departments of the company, and its costs are allocated using floor space occupied, while factory office costs are allocable to Assembly and Machining on the basis of direct labor hours. 1. Distribute the service department costs, using the direct method. 2. Distribute the service department costs, using the sequential distribution method, with the department servicing the greatest number of other departments distributed first.arrow_forward
- Absorption-Costing Income Statement Refer to the data for Osterman Company above. Required: 1. Calculate the cost of goods sold under absorption costing. 2. Prepare an income statement using absorption costing. Use the following information for Brief Exercises 3-23 and 3-24: During the most recent year, Osterman Company had the following data:arrow_forwardMedical Tape makes two products: Generic and Label. It estimates it will produce 423,694 units of Generic and 652,200 of Label, and the overhead for each of its cost pools is as follows: It has also estimated the activities for each cost driver as follows: How much is the overhead allocated to each unit of Generic and Label?arrow_forwardAllocating Selling and Administrative Expenses using Activity-Based Costing Shrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price $720 per unit Cost of goods sold (430) Gross profit $290 per unit In addition, the company incurs selling and administrative expenses of $229,820. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related to its three major nonmanufacturing activities: customer service, sales order processing, and advertising support. The advertising support is in the form of advertisements that are placed by Shrute Inc. to support the retailer's sale of Shrute copiers to consumers. The budgeted activity costs and activity bases associated with these activities are: Activity Budgeted Activity Cost Activity Base Customer service $33,000 Number of service requests Sales…arrow_forward
- Activity-Based Costing: Selling and Administrative Expenses Jungle Junior Company manufactures and sells outdoor play equipment. Jungle Junior uses activity-based costing to determine the cost of the sales order processing and the customer return activity. The sales order processing activity has an activity rate of $20 per sales order, and the customer return activity has an activity rate of $100 per return. Jungle Junior sold 2,500 swing sets, which consisted of 750 orders and 80 returns. a. Determine the total sales order processing and customer return activity cost for swing sets. b. Determine the per-unit sales order processing and customer return activity cost for swing sets. Round your answer to the nearest cent. per unitarrow_forwardAllocating selling and administrative expenses using activity-based costing Arctic Air Inc. manufactures cooling units for commercial buildings. The price and cost of goods sold for each unit are as follows: Line Item Description Amount Price $60,000 per unit Cost of goods sold (28,000) Gross profit $32,000 per unit In addition, the company incurs selling and administrative expenses of $226,250. The company wishes to assign these costs to its three major customers, Gough Industries, Breen Inc., and The Martin Group. These expenses are related to three major nonmanufacturing activities: customer service, project bidding, and engineering support. The engineering support is in the form of engineering changes that are placed by the customer to change the design of a product. The budgeted activity costs and activity bases associated with these activities are: Activity BudgetedActivity Cost Activity Base Customer service $31,500 Project bidding 74,000 Engineering…arrow_forwardScholfield Enterprises makes a variety of products that it sells to other businesses. The company's activity-based costing system has four activity cost pools for assigning costs to products and customers. Details concerning that activity-based costing system are listed below: Activity Cost Pool Supporting assembly Processing batches. Processing orders. Serving customers. Activity Measure Direct labor-hours (DLHS) Number of batches. Number of orders Number of customers Activity Rate $ 6.55 per DLH $ 138.20 per batch $ 52.60 per order $ 1,191.00 per customer The cost of serving customers, $1,191.00 per customer, is the cost of serving a customer for one year. Latif Corporation buys only one of the company's products which Scholfield Enterprises sells for $15.60per unit. Last year Latif Corporation ordered a total of 1,100units of this product in 2orders. To fill the orders, 7batches were required. The direct materials cost is $7.85per unit and the direct labor cost is $1.90per unit.…arrow_forward
- Yalland Manufacturing Company makes two different products, M and N. The company’s two departments are named after the products; for example, Product M is made in Department M. Yalland’s accountant has identified the following annual costs associated with these two products. Identify the costs that are (1) direct costs of Department M, (2) direct costs of Department N, and (3) indirect costs. Select the appropriate cost drivers for the indirect costs and allocate these costs to Departments M and N. Determine the total estimated cost of the products made in Departments M and N. Assume that Yalland produced 2,000 units of Product M and 4,000 units of Product N during the year. If Yalland prices its products at cost plus 40 percent of cost, what price per unit must it charge for Product M and for Product N?arrow_forwardROXY Tires the manufacturer and exported company of tires. The company uses an activity based costing system for its overhead costs. The company has provided the following data concerning its activity-based costing system. Activity Cost pool Activity Measure Annual Activity Supporting Direct Labor Direct labor Hour $28 per DLH Order Processing Order $285 per Order Custom design processing Custom design $185 per customer design Customer service customer $378 per customer Management would like an analysis of the profitability of a particular customer, Roxy Tires, which has ordered the following products over the last 12 months: Items…………………………….standard model……………….customer Design Number of Tires…………………20………………………………5 Number of orders……………….1……………………………….5 Number of customer designs……0………………………………5 Direct labor hour per Tires 26.5…………………………….28 Selling price per…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, 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_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College