Concept explainers
Allocating 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:
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-base usage and unit volume information for the three customers is as follows:
Instructions
- 1. Determine the activity rates for each of the three nonmanufacturing activity pools.
- 2. Determine the activity costs allocated to the three customers, using the activity rates in (1).
- 3. 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.
- 4. 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
- A 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_forwardA manufacturing company has two service and two production departments. Human Resources and Machine Repair are the service departments. The production departments are Grinding and Polishing. The following data have been estimated for next years operations: The direct charges identified with each of the departments are as follows: The human resources department services all departments of the company, and its costs are allocated using the numbers of employees within each department, while machine repair costs are allocable to Grinding and Polishing on the basis of machine 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_forwardCicleta 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_forward
- Bounce 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_forwardThe following product costs are available for Stellis Company on the production of erasers: direct materials, $22,000; direct labor, $35,000; manufacturing overhead, $17,500; selling expenses, $17,600; and administrative expenses; $13,400. What are the prime costs? What are the conversion costs? What is the total product cost? What is the total period cost? If 13,750 equivalent units are produced, what is the equivalent material cost per unit? If 17,500 equivalent units are produced, what is the equivalent conversion cost per unit?arrow_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_forward
- Allocating selling and administrative expenses using activity - based costing Artic Air Inc. manufactures cooling units for commercial buildings.The price and cost of goods sold for each units are as follows: 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 services,project bidding,and engineering support.The engineering support is in the form of engineering changes thet are placed by the customer to change the design of a product.The budgeted activity costs and activity bases associated with these activities are: instructions 1.Determine the activity rates for each of the three nonmanufacturing activity pools. 2.Determine the activity costs allocated to the three customers,using the activity rates in (1) 3.Construct customer profitability reports for tile…arrow_forwardHensel Manufacturing separates its manufacturing overhead costs into 2 broad categories: (1) maintenance costs and (2) utility costs. Maintenance costs average $100,000 per month, whereas utility costs average $8,000 per month. Maintenance costs are allocated to 2 activity cost pools: (1) the repair cost pool and (2) the set-up cost pool. Utility costs also are allocated to 2 activity cost pools: (1) the heating and air conditioning cost pool (HVAC) and (2) the machinery cost pool. Maintenance costs are allocated to their unique activity cost pools on the basis of the number of employees associated with each pool. Utility costs are allocated to their unique activity cost pools on the basis of kilowatt-hour (kWh) consumption. Of the company's maintenance employees, 70% engage primarily in repair activities, whereas 30% engage primarily in set-up activities. Approximately 75% of the company's kWh consumption can be traced to HVAC use, whereas 25% of its kWh consumption can be traced to…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 $650 per unit Cost of goods sold (390) Gross profit $260 per unit In addition, the company incurs selling and administrative expenses of $227,280. 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 $34,000 Number of service requests Sales…arrow_forward
- Doede Corporation uses activity-based costing to compute product margins. In the first stage, the activity-based costing system allocates two overhead accounts-equipment depreciation and supervisory expense-to three activity cost pools-Machining. Order Filing, and Other-based on resource consumption, Data to perform these allocations appear below: Overhead costs: Equipment depreciation Supervisory expense $ 30,000 $ 14,800 Distribution of Resource Consumption Across Activity Cost Pools: Equipment depreciation Supervisory expense Activity: Product W1 Product Me Total Machining Order Filling 0.50 0.50 In the second stage, Machining costs are assigned to products using machine-hours (Ms) and Order Filing costs are assigned to products using the number of orders. The costs in the Other activity cost pool are not assigned to products. Product W1 Product Me Total Activity Cost Pools MHS (Machining) 5,530 17,000 22,530 0.40 0.30 Show Transcribed Text 5,530 17,000 22,530 Orders (Order Filling)…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_forwardLysiak Corporation uses an activity based costing system to assign overhead costs to products. In the first stage, two overhead costs--equipment depreciation and supervisory expense-are allocated to three activity cost pools--Machining, Order Filling, and Other--based on resource consumption. Data to perform these allocations appear below: Overhead costs: Equipment depreciation $ 47,000 Supervisory expense $ 6,000 Distribution of Resource Consumption Across Activity Cost Pools: Activity Cost Pools Machining Order Filling Other Equipment depreciation 0.60 0.10 0.30 Supervisory expense 0.60 0.20 0.20 In the second stage, Machining costs are assigned to products using machine-hours (MHs) and Order Filling costs are assigned to products using the number of orders. The costs in the Other activity cost pool are not assigned to products. Activity data for the company's two products follow: Activity: MHs (Machining) Orders (Order Filling) Product C9 6,900 200…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 LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College