Concept explainers
1.
Activity-based costing (ABC) method: The costing method which allocates
Formula to compute activity-based overhead rate:
To compute: The activity-based overhead rate for each of the given activities
1.
Explanation of Solution
Compute activity-based overhead rates.
Computation of Activity-Based Overhead Rates | |||||
Activity Cost Pools | Activity Cost | ÷ | Total Activity-Base Usage | = | Activity-Based Overhead Rates |
Customer support | $76,860 | ÷ | 427 requests | = | $180 per request |
Sales order processing | 25,920 | ÷ | 1,080 orders | = | $24 per order |
Advertising support | 311,250 | ÷ | 249 advertisements | = | $1,250 per ad |
Table (1)
2.
To compute: The activity-cost allocated to each of the products
2.
Explanation of Solution
Compute activity cost allocated to Company W.
Activity Cost Pools | Activity-Based Overhead Rates | × | Actual Use of Activity-Base | = | Activity Cost Allocated |
Customer support | $180 per request | × | 62 requests | = | $11,160 |
Sales order processing | $24 per order | × | 300 orders | = | 7,200 |
Advertising support | $1,250 per ad | × | 25 ads | = | 31,250 |
Total activity costs allocated to Company W | $49,610 |
Table (2)
Note: Refer to Table (1) for value and computation of activity-based overhead rate.
Compute activity cost allocated to Company K.
Activity Cost Pools | Activity-Based Overhead Rates | × | Actual Use of Activity-Base | = | Activity Cost Allocated |
Customer support | $180 per request | × | 340 requests | = | $61,200 |
Sales order processing | $24 per order | × | 640 orders | = | 15,360 |
Advertising support | $1,250 per ad | × | 180 ads | = | 225,000 |
Total activity costs allocated to Company K | $301,560 |
Table (3)
Note: Refer to Table (1) for value and computation of activity-based overhead rate.
Compute activity cost allocated to Company SU.
Activity Cost Pools | Activity-Based Overhead Rates | × | Actual Use of Activity-Base | = | Activity Cost Allocated |
Customer support | $180 per request | × | 25 requests | = | $4,500 |
Sales order processing | $24 per order | × | 140 orders | = | 3,360 |
Advertising support | $1,250 per ad | × | 44 ads | = | 55,000 |
Total activity costs allocated to Company SU | $62,860 |
Table (4)
Note: Refer to Table (1) for value and computation of activity-based overhead rate.
3.
To draft: Customer profitability report of Incorporation S for the year ended December 31
3.
Explanation of Solution
Prepare customer profitability report of Incorporation S for the year ended December 31.
Incorporation S | |||
Customer Profitability Report | |||
For the Year Ended December 31 | |||
Company W | Company K | Company SU | |
Revenues | $899,100 | $899,100 | $899,100 |
Cost of goods sold | 552,420 | 552,420 | 552,420 |
Gross profit | 346,680 | 346,680 | 346,680 |
Selling and administrative expenses: | |||
Customer support | $11,160 | $61,200 | $4,500 |
Project bidding | 7,200 | 15,360 | 3,360 |
Engineering support | 31,250 | 225,000 | 55,000 |
Total selling expenses | $49,610 | $301,560 | $62,860 |
Income (loss) from operations | $297,070 | $45,120 | $283,820 |
Table (5)
Working Notes:
Refer to Tables (2), (3) and (4) for value and computation of selling and administrative expenses for the three customers.
Compute sales revenues for each of the customers.
Customers | Number of Units Sold | × | Selling Price Per Unit | = | Sales Revenue |
Company W | 810 units | × | $1,110 | = | $899,100 |
Company K | 810 units | × | 1,110 | = | 899,100 |
Company SU | 810 units | × | 1,110 | = | 899,100 |
Table (6)
Compute cost of goods sold for each product.
Customers | Number of Units Sold | × | Cost Price Per Unit | = | Cost of Goods Sold |
Company W | 810 units | × | $682 | = | $552,420 |
Company K | 810 units | × | 682 | = | 552.420 |
Company SU | 810 units | × | 682 | = | 552.420 |
Table (7)
4.
To discuss: The inferences from the customer profitability report.
4.
Explanation of Solution
Company W and Company SU are profitable customers whereas Company K has low margin. This is due to the high activity costs for all the three activities. Company K is suggested to increase its sales volume to overcome its costs. Due to high costs and low revenues, the customer experienced losses.
Want to see more full solutions like this?
Chapter 4 Solutions
Managerial Accounting
- 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_forwardYo-Down Inc. produces yogurt. Information related to the companys yogurt production follows: Support Department 1s costs total 142,000. Using the direct method of support department cost allocation, determine the costs from Support Department 1 that should be allocated to each production department.arrow_forwardAbsorption-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_forward
- 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_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_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
- Medical 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_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
- 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 $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_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 $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_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_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 LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College