Question

Mastery Problem: Activity-Based Costing (Advanced)

Activity-Based Costing

Traditionally, Overhead cost: Sometimes referred to as "factory overhead," this is an indirect cost that is not directly tied to the production of units, yet nonetheless must be built into product cost in order to appropriately price it. Examples are managerial salaries, rent expense, setup costs, and property taxes.overhead costs are assigned based arbitrarily on the rate of either Direct labor: This is a labor cost directly associated with the production of goods and services. An example is the hourly wages of workers.direct labor or Direct materials: This is a material cost directly associated with the production of goods. An example is sheet metal used to manufacture auto parts.direct materials associated with production. This makes sense when companies only make a few products, production processes are simple, and overhead costs are less pervasive. However, today production processes are more complex, companies make a wider array of products, and fewer costs are directly traceable to units of production. To address this, companies use activity-based costing (ABC).

Specifically, activity-based costing identifies and traces costs and expenses to activities and then to specific products. ABC uses multiple factory overhead rates based on activities. Activities are the types of work, or actions, involved in a manufacturing process or service activity. For example, assembly, inspection, and engineering design are activities.

The estimated activity costs are allocated to products using an activity rate. Activity rates are determined as follows:
Activity Rate = Estimated Activity Cost / Estimated Activity Base Usage

Illustrated Example of Activity-Based Costing

Comparing Two Products under Traditional and Activity-Based Costing

Compare two projects under development by the same company. The following are a few aspects of each product’s development process relevant to costs.

Product S		Product T
Requires 3,200 hours of testing		Requires 800 hours of testing
Requires 4,200 units of computing power		Requires 1,800 units of computing power
Requires 30 developer hours to implement		Requires 70 developer hours to implement

Cost Items Cost of Each Activity Testing: $31,200 Computing power: $46,800 Developer hourly cost: $10 per hour

Traditional Costing

Traditional costing would take the proportion of a direct cost, such as direct labor hours, and use it as the basis for allocating overhead costs, such as computing power and testing. In the following table, use developer hours as the basis for assigning overhead costs (computing and developer costs) to each project. If required, round your answers to the nearest dollar.

Product S			Product T
Percentage of developer hours	30%		Percentage of developer hours	70%
Testing cost	$		Testing cost	$
Computing cost	$		Computing cost	$
Developer cost	$		Developer cost	$
Total cost	$		Total cost	$

Percentage of developer hours

+ Percentage of developer hours for Product S (30%) Allocation basis for Product S: The amount of labor hours associated directly with Product S, as a percentage of all developer hours worked (regardless of product). The amounts for overhead to be allocated are multiplied by this value to determine the overhead to be assigned to Product S under the traditional costing method. 30 (30+70)

+ Percentage of developer hours for Product T (70%) Allocation basis for Product T: The amount of labor hours associated directly with Product T, as a percentage of all developer hours worked (regardless of product). The amounts for overhead to be allocated are multiplied by this value to determine the overhead to be assigned to Product T under the traditional costing method. 70 (30+70)

Review the resources each product (S and T) requires for production and compare that to the costs calculated above under traditional costing. Does traditional costing serve as an accurate gauge of costs?
No

• Yes
• No
• Not enough information

Feedback

Using traditional cost assignment means pegging overhead costs based on a direct cost, such as direct labor or direct materials. In this case, you use direct labor (developer hours) as the basis for overhead allocation.

For product S, the percentage of developer labor costs as a proportion of the whole is already calculated. This is the figure that, when multiplied by the overhead values, will yield the overhead assigned to each project under traditional costing.

Activity-Based Costing

Using the data above for products S and T, calculate the costs using activity-based costing. Allocate the costs of testing, computing, and development based on the rates of activity consumed by each product's development process. If required in your computations, round per unit costs to the nearest cent. Round your final answers to the nearest dollar.

Cost	Activity Base
Testing	Hours of testing
Computing cost	Units of computing power
Developer cost	Development hours

Product S			Product T
Testing cost	$		Testing cost	$
Computing cost	$		Computing cost	$
Developer cost	$		Developer cost	$
Total cost	$		Total cost	$

Feedback

The budgeted activity costs are assigned to products using factory overhead rates for each activity. These rates are called activity rates because they are related to activities. Activity rates are determined as follows:
Activity Rate = Budgeted Activity Cost / Total Activity Base Usage

The costs are allocated to the product by multiplying the activity-base usage by the computed activity rate.

Activity-based costing for varying batch production

A manufacturing company has the following two activities associated with completion of products:

1. The setting up of machines for running batches of products
2. The actual production of units produced

The company has annual manufacturing overhead costs of $2,000,000, of which $200,000 is directly involved in setting up machines for batch runs. During the year, the company expects to perform 400 machine setups, one setup per batch for a total of 400 batches of production. Assume that the batch sizes vary considerably, but the work involved in setting up the machines is not appreciably different from one job to the next.

If the company estimates that the $200,000 costs associated with setups will yield 400 setups this year, the cost associated directly with each setup will be $ per setup. Because each job will require its own setup, setup costs are viewed as batch costs. Because $200,000 of the $2,000,000 are costs associated with setups, this means that costs associated directly with the production of units equal $.

Feedback

The costs associated directly with the actual production of units will be annual manufacturing costs less the costs directly involved in setting up the machines for batch runs.

The costs directly associated with each setup will be costs directly involved

Answer 1

Ans:1) Cost as per the Absorption Costing
Particulars	Cost of each activity	Number of Activity	Cost	Product S (30% of Development Hours)	Product T (70% of Development Hours)
Testing cost	$31,200	4000	$124,800,000	$37,440,000	$87,360,000
Computing cost	$46,800	6000	$280,800,000	$84,240,000	$196,560,000
	$10	100	$1,000	$300	$700
Total Cost Product Basis				$121,680,300	$283,920,700
2) Activity Based Costing
Particulars	Cost of each activity	Product S		Product T
		Number of Activity	Cost	Number of Activity	Cost
Testing cost	$31,200	3200	$99,840,000	800	$24,960,000
Computing cost	$46,800	4200	$196,560,000	1800	$84,240,000
Developer cost	$10	30	$300	70	$700
Total Cost Product Basis			$296,400,300		$109,200,700
Under the Traditional costing system the cost of production of product S is lower than the product T, whereas in Activity based Costing System the cost of production is of product S is higher than the product T this is due to in activity based costing system cost is allocated on the basis of different activity performed for production of each product.
3) The company has annual manufacturing overhead costs of $2,000,000, of which $200,000 is directly involved in setting up machines for batch runs.During the year, 400 machine setups, one setup per batch for a total of 400 batches of production. Manufacturing Overheads of $200,000 costs associated with setups will yield 400 setups this year, the cost associated directly with each setup will be $500 per setup. Because $200,000 of the $2,000,000 are costs associated with setups, this doesn't means that costs associated directly with the production of units. As this incurred on the basis of production of Batches. If this cost is allocated on the basis of per unit then the result will be different if production is not took place in batch.