The company for which you work recently implemented time-driven activity-based costing (TDABC) in conjunction with its...

The company for which you work recently implemented time-driven activity-based costing (TDABC) in conjunction with its enterprise resource planning (ERP) system. Management is pleased with the revised product and customer cost information that the TDABC system produces. It is now wondering how this system can be used for budgeting purposes. You have been asked to provide an example of using time-driven activity-based budgeting, given the following information: There are two resources (departments): indirect labor and computer support.There are two primary activities that these resources support: handling production runs and product-level support.Indirect labor support is consumed as follows:To handle production runs: 10 hours/run.To support products: 630 hours/product.Computer support is consumed as follows:To handle production runs: 1.7 hours/run.To support products: 63 hours/product.Resource practical capacity levels:Indirect labor: 22,600 hours per quarter.Computer support: 630 hours per quarter.Cost of supplying resources:Indirect labor: $1,423,800 per quarter.Computer support: $516,600 per quarter.

Required:1. Calculate the budgeted resource cost per hour (at practical capacity) for each of the two resources, indirect labor support and computer support.

2. Determine the budgeted cost-driver rates for each of the two activities, handle production runs and support products.

3. Suppose that the total cost of resources supplied for the quarter just ended was exactly as budgeted (i.e., $1,940,400) but that only 20,600 indirect labor hours were used along with 580 computer hours. Calculate, for each resource, the cost of idle capacity.

4. After implementing a total quality management (TQM) program, the company was able to implement process-efficiency changes, the end result of which was a 20% reduction in the indirect labor time associated with the activity handling production runs. Recalculate the indirect labor cost component of the cost to handle a production run. Also, recalculate the cost of idle capacity for indirect labor assuming the original facts but with the 20% efficiency gain. Assume that in the original case facts, 17,300 of the 20,600 hours relate to the activity handling production runs (while the remaining 3,300 hours relate to the activity product-level support).

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

The company for which you work recently implemented time-driven activity-based costing (TDABC) in conjunction with its...

Rusties Company recently implemented an activity-based costing system.

Rusties Company recently implemented an activity-based costing system. At the beginning of the year, management made the following estimates of cost and activity in the company’s five activity cost pools: Activity Cost Pool Activity Measure ExpectedOverhead Cost ExpectedActivity Labor-related Direct labor-hours $ 24,912 2,076 DLHs Purchase orders Number of orders $ 1,070 535 orders Product testing Number of tests $ 4,550 325 tests Template etching Number of templates $ 770 35 templates General factory Machine-hours $ 52,500 10,500 MHs...

1. What is time-driven activity based management (TDABC)? 2. How does it differ from activity based...

1. What is time-driven activity based management (TDABC)? 2. How does it differ from activity based costing (ABC) and why would TDABC be used in place of ABC? 3. According to a Wall Street Journal article, a three hour televised football game boils down to 10 minutes and 43 seconds of actual playing time. What other activities take place during a televised football game? Of all the activities, which are value-added and which are non-value added? Football fans everywhere are...

Stahl Company is conducting a time-driven activity-based costing study in its Shipping Department.

Stahl Company is conducting a time-driven activity-based costing study in its Shipping Department. To aid the study, the company provided the following data regarding its Shipping Department and the customers served by the department.Required: 1. Using the customer cost analysis as demonstrated in Exhibit 7A-2 in your textbook, compute the following: a. The cost per minute of the resource supplied in the Shipping Department. b. The time-driven activity rate for each of Stahl's three activities. c.The total labor costs consumed by Customer L. Customer...

Stahl Company is conducting a time-driven activity-based costing study in its Shipping Department. To aid the...

Stahl Company is conducting a time-driven activity-based costing study in its Shipping Department. To aid the study, the company provided the following data regarding its Shipping Department and the customers served by the department: Number of employees 30 Average salary per employee $ 30,000 Weeks of employment per year 52 Hours worked per week 40 Practical capacity percentage 85 % Line-Item Picking Packaging Loading Deliveries Minutes per unit of the activity 5 15 30 Customer L Customer M Customer N...

Corporation is conducting a time-driven activity-based costing study in its Tech Support Department. The company has...

Corporation is conducting a time-driven activity-based costing study in its Tech Support Department. The company has provided the following data to aid in that study: Jahnel Corporation Tech Support Department Data Inputs Resource Data: Number of employees 7 Average salary per employee $ 43,200 Weeks of employment per year 50 Minutes available per week (40 hours × 60 minutes) 2,400 Practical capacity percentage 90 % Activity Data: Routing Calls Resolving Problems Preparing Change Orders Minutes per unit of the activity...

Hollifield Corporation is conducting a time-driven activity-based costing study in its Order Fulfillment Department. The company...

Hollifield Corporation is conducting a time-driven activity-based costing study in its Order Fulfillment Department. The company has provided the following data to aid in that study: Hollifield Corporation Order Fulfillment Department Data Inputs Resource Data: Number of employees 18 Average salary per employee $ 33,300 Weeks of employment per year 50 Minutes available per week (40 hours × 60 minutes) 2,400 Practical capacity percentage 75 % Activity Data: Processing Orders Preparing Deliveries Handling Returns Minutes per unit of the activity...

Spillett Corporation is conducting a time-driven activity-based costing study in its Order Fulfillment Department. The company...

Spillett Corporation is conducting a time-driven activity-based costing study in its Order Fulfillment Department. The company has provided the following data to aid in that study: Spillett Corporation Order Fulfillment Department Data Inputs Resource Data: Number of employees 22 Average salary per employee $ 43,860 Weeks of employment per year 50 Minutes available per week (40 hours × 60 minutes) 2,400 Practical capacity percentage 85 % Activity Data: Processing Orders Preparing Deliveries Handling Returns Minutes per unit of the activity...

Adria Company recently implemented an activity-based costing system. At the beginning of the year, management made...

Adria Company recently implemented an activity-based costing system. At the beginning of the year, management made the following estimates of cost and activity in the company’s five activity cost pools: Activity Cost Pool Activity Measure Expected Overhead Cost Expected Activity Labor-related Direct labor-hours $ 52,000 6,500 DLHs Purchase orders Number of orders $ 13,000 2,600 orders Material receipts Number of receipts $ 11,200 800 receipts Relay assembly Number of relays $ 16,000 1,600 relays General factory Machine-hours $ 342,000 38,000...

The Concord Company recently moved to activity-based costing and implemented customer profitability analysis. In doing so,...

The Concord Company recently moved to activity-based costing and implemented customer profitability analysis. In doing so, they found that one of their oldest customers, The Mequon Company, is not profitable. The Mequion Company is small and the management of Concord knows they are very reliant on products from Concord and that they can't absorb a significant increase from Concord, which is needed to make them profitable. 1. What would you recommend if you were part of The Concord Company management...

Subjects