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 service | $83,720 | ÷ | 322 requests | = | $260 per request |
Project bidding | 61,360 | ÷ | 104 bids | = | $590 per bid |
Engineering support | 86,800 | ÷ | 217 design changes | = | $400 per change |
Table (1)
(2)
To compute: The activity-cost allocated to each of the customers.
(2)
Explanation of Solution
Compute activity cost allocated to GK University.
Activity Cost Pools | Activity-Based Overhead Rates | × | Actual Use of Activity-Base | = | Activity Cost Allocated |
Customer service | $260 per request | × | 60 requests | = | $15,600 |
Project bidding | $590 per bid | × | 36 bids | = | 21,240 |
Engineering support | $400 per change | × | 45 changes | = | 18,000 |
Total activity costs allocated to GK University | $54,840 |
Table (2)
Note: Refer to Table (1) for value and computation of activity-based overhead rates.
Compute activity cost allocated to HS Arena.
Activity Cost Pools | Activity-Based Overhead Rates | × | Actual Use of Activity-Base | = | Activity Cost Allocated |
Customer service | $260 per request | × | 52 requests | = | $13,520 |
Project bidding | $590 per bid | × | 18 bids | = | 10,620 |
Engineering support | $400 per change | × | 30 changes | = | 12,000 |
Total activity costs allocated to HS Arena | $36,140 |
Table (3)
Note: Refer to Table (1) for value and computation of activity-based overhead rates.
Compute activity cost allocated to BL Hospital.
Activity Cost Pools | Activity-Based Overhead Rates | × | Actual Use of Activity-Base | = | Activity Cost Allocated |
Customer service | $260 per request | × | 210 requests | = | $54,600 |
Project bidding | $590 per bid | × | 50 bids | = | 29,500 |
Engineering support | $400 per change | × | 142 changes | = | 56,800 |
Total activity costs allocated to BL Hospital | $140,900 |
Table (4)
Note: Refer to Table (1) for value and computation of activity-based overhead rates.
(3)
To draft: Customer profitability report of Incorporation CZ for the year ended December 31
(3)
Explanation of Solution
Prepare customer profitability report of Incorporation CZ for the year ended December 31.
Incorporation CZ | |||
Customer Profitability Report | |||
For the Year Ended December 31 | |||
GK University | HS Arena | BL Hospital | |
Revenues | $1,650,000 | $1,050,000 | $450,000 |
Cost of goods sold | 1,320,000 | 840,000 | 360,000 |
Gross profit | 330,000 | 210,000 | 90,000 |
Selling and administrative expenses: | |||
Customer service | $15,600 | $13,520 | $54,600 |
Project bidding | 21,240 | 10,620 | 29,500 |
Engineering support | 18,000 | 12,000 | 56,800 |
Total selling expenses | 54,840 | 36,140 | 140,900 |
Income (loss) from operations | $275,160 | $173,860 | $(50,900) |
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 |
GK University | 22 units | × | $75,000 | = | $1,650,000 |
HS Arena | 14 units | × | 75,000 | = | 1,050,000 |
BL Hospital | 6 units | × | 75,000 | = | 450,000 |
Table (6)
Compute cost of goods sold for each customer.
Customers | Number of Units Sold | × | Cost Price Per Unit | = | Cost of Goods Sold |
GK University | 22 units | × | $60,000 | = | $1,320,000 |
HS Arena | 14 units | × | 60,000 | = | 840,000 |
BL Hospital | 6 units | × | 60,000 | = | 360,000 |
Table (7)
(4)
To discuss: The inferences from the customer profitability report.
(4)
Explanation of Solution
Want to see more full solutions like this?
Chapter 26 Solutions
Bundle: Financial & Managerial Accounting, 13th + CengageNOWv2, 2 terms (12 months) Printed Access Card
- Blue Africa Inc. produces laptops and desktop computers. The companys production activities mainly occur in what the company calls its Laser and Forming departments. The Cafeteria and Security departments support the companys production activities and allocate costs based on the number of employees and square feet, respectively. The total cost of the Security Department is 273,000. The total cost of the Cafeteria Department is 180,000. The number of employees and the square footage in each department are as follows: Using the reciprocal services method of support department cost allocation, determine the total costs from the Security Department that should be allocated to the Cafeteria Department and to each of the production departments.arrow_forwardRoper Furniture manufactures office furniture and tracks cost data across their process. The following are some of the costs that they incur. Classify these costs as fixed or variable costs, and as product costs or period costs. Wood used to produce desks ($125,00 per desk) Production labor used to produce desks ($15 per hour) Production supervisor salary ($45,000 per year) Depreciation on factory equipment ($60,000 per year) Selling and administrative expenses ($45,000 per year) Rent on corporate office ($44,000 per year) Nails, glue, and other materials required to produce desks (varies per desk) Utilities expenses for production facility Sales staff commission (5% of gross sales)arrow_forwardActivity-Based Supplier Costing Levy Inc. manufactures tractors for agricultural usage. Levy purchases the engines needed for its tractors from two sources: Johnson Engines and Watson Company. The Johnson engine has a price of 1,000. The Watson engine is 900 per unit. Levy produces and sells 22,000 tractors. Of the 22,000 engines needed for the tractors, 4,000 are purchased from Johnson Engines, and 18,000 are purchased from Watson Company. The production manager, Jamie Murray, prefers the Johnson engine. However, Jan Booth, purchasing manager, maintains that the price difference is too great to buy more than the 4,000 units currently purchased. Booth also wants to maintain a significant connection with the Johnson source just in case the less expensive source cannot supply the needed quantities. Jamie, however, is convinced that the quality of the Johnson engine is worth the price difference. Frank Wallace, the controller, has decided to use activity costing to resolve the issue. The following activity cost and supplier data have been collected: Required: 1. CONCEPTUAL CONNECTION Calculate the activity-based supplier cost per engine (acquisition cost plus supplier-related activity costs). (Round to the nearest cent.) Which of the two suppliers is the low-cost supplier? Explain why this is a better measure of engine cost than the usual purchase costs assigned to the engines. 2. CONCEPTUAL CONNECTION Consider the supplier cost information obtained in Requirement 1. Suppose further that Johnson can only supply a total of 20,000 units. What actions would you advise Levy to undertake with its suppliers?arrow_forward
- Charlies Wood Works produces wood products (e.g., cabinets, tables, picture frames, and so on). Production departments include Cutting and Assembly. The Janitorial and Security departments support the Cutting and Assembly departments. The Assembly Department spans about 46,400 square feet and holds assets valued at about 60,000. The Cutting Department spans about 33,600 square feet and holds assets valued at about 140,000. Charlies Wood Works allocates support department costs using the direct method. If costs from the Janitorial Department are allocated based on square feet and costs from the Security Department are allocated based on asset value, determine (a) the percentage of Janitorial costs that should be allocated to the Assembly Department and (b) the percentage of Security costs that should be allocated to the Cutting Department.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_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
- 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 $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_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
- V&S Mechanical sells and services plumbing, heating, and air conditioning systems. V&S's cost accounting system tracks two cost categories: direct labor and direct materials V&S uses a time-and-materials pricing system, with direct labor marked up 100% and direct materials marked up 50% to recover indirect costs of support staff, support materials, and shared equipment and tools and to earn a profit (Click the icon to view the cost information) Read the requirements Requirement 1. If Dryden presents Lowry with the replace or repair options, what price would he quote for each? Complete the table below to determine the price Dryden would quote for each option Labor Materials Total Price Repair option Replace option Requirements 1. if Dryden presents Lowry with the replace or repair options, what price would he quote for each? 2. If the two options were equally effective for the 3 years that Lowry intends to live in the home, which option would she choose? 3. if Dryden's objective is to…arrow_forwardM & J Mechanical sells and services plumbing, heating, and air conditioning systems. M & J's cost accounting system tracks two cost categories: direct labor and direct materials. M & J uses a time-and-materials pricing system, with direct labor marked up 100% and direct materials marked up 40% to recover indirect costs of support staff, support materials, and shared equipment and tools and to earn a profit. Data table During a hot summer day, the central air conditioning in Susan Lee's home stops working. M & J technician Sam Austen arrives at Lee's home and inspects the air conditioner. He considers two options: replace the compressor or repair it. The cost information available to Austen follows: Repair option Replace option Labor rate Labor 7 hrs. 1 hrs. $40 per hour Materials $160 $280 Xarrow_forwardYalland 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_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning