Explore BrainMass
Share

Assign costs using Activity Based Costing

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Fontillas Instrument, Inc. manufactures two products: missile range instruments
and space pressure gauges. During April, 50 range instruments and 300 pressure gauges.

Identify activity cost drivers.
Compute overhead rates and
assign overhead using ABC.

Activity-Based Costing
overhead costs of $89,500 were estimated. An analysis of estimated
overhead costs reveals the following activities.

Activities Cost Drivers Total Cost
1. Materials handling Number of requisitions $35,000
2. Machine setups Number of setups 27,500
3. Quality inspections Number of inspections 27,000

The cost driver volume for each product was as follows.
Cost Drivers Instruments Gauges Total
Number of requisitions 400 600 1,000
Number of setups 200 300 500
Number of inspections 200 400 600

Instructions
(a) Determine the overhead rate for each activity.
(b) Assign the manufacturing overhead costs for April to the two products using activitybased
costing.
(c) Write a memorandum to the president of Fontillas Instrument explaining
the benefits of activity-based costing.

© BrainMass Inc. brainmass.com October 25, 2018, 12:18 am ad1c9bdddf
https://brainmass.com/business/accounting/assign-costs-using-activity-based-costing-223517

Solution Summary

The solution explains how to assign costs using activity based costing

$2.19
See Also This Related BrainMass Solution

Product and Activity Based Costing: Two Activity Example

Activity based costing (ABC) assigns manufacturing overhead costs to products in a more logical manner than the traditional approach of simply allocating costs on the basis of machine hours. Activity based costing first assigns costs to the activities that are the real cause of the overhead. It then assigns the cost of those activities only to the products that are actually demanding the activities.

Let's discuss activity based costing by looking at two products manufactured by the same company. Product 124 is a low volume item which requires certain activities such as special engineering, additional testing, and many machine setups because it is ordered in small quantities. A similar product, Product 366, is a high volume product--running continuously--and requires little attention and no special activities. If this company used traditional costing, it might allocate or "spread" all of its overhead to products based on the number of machine hours. This will result in little overhead cost allocated to Product 124, because it did not have many machine hours. However, it did demand lots of engineering, testing, and setup activities. In contrast, Product 366 will be allocated an enormous amount of overhead (due to all those machine hours), but it demanded little overhead activity. The result will be a miscalculation of each product's true cost of manufacturing overhead. Activity based costing will overcome this shortcoming by assigning overhead on more than the one activity, running the machine.

Activity based costing recognizes that the special engineering, special testing, machine setups, and others are activities that cause costs-they cause the company to consume resources. Under ABC, the company will calculate the cost of the resources used in each of these activities. Next, the cost of each of these activities will be assigned only to the products that demanded the activities. In our example, Product 124 will be assigned some of the company's costs of special engineering, special testing, and machine setup. Other products that use any of these activities will also be assigned some of their costs. Product 366 will not be assigned any cost of special engineering or special testing, and it will be assigned only a small amount of machine setup.

Activity based costing has grown in importance in recent decades because (1) manufacturing overhead costs have increased significantly, (2) the manufacturing overhead costs no longer correlate with the productive machine hours or direct labor hours, (3) the diversity of products and the diversity in customers' demands have grown, and (4) some products are produced in large batches, while others are produced in small batches.

Activity Based Costing with Two Activities
Let's illustrate the concept of activity based costing by looking at two common manufacturing activities: (1) the setting up of a production machine for running batches of products, and (2) the actual production of the units of product.

We will assume that a company has annual manufacturing overhead costs of $2,000,000â?"of which $200,000 is directly involved in setting up the production machines. During the year the company expects to perform 400 machine setups. Let's also assume that the batch sizes vary considerably, but the setup efforts for each machine are similar.

The cost per setup is calculated to be $500 ($200,000 of cost per year divided by 400 setups per year). Under activity based costing, $200,000 of the overhead will be viewed as a batch-level cost. This means that $200,000 will first be allocated to batches of products to be manufactured (referred to as a Stage 1 allocation), and then be assigned to the units of product in each batch (referred to as Stage 2 allocation). For example, if Batch X consists of 5,000 units of product, the setup cost per unit is $0.10 ($500 divided by 5,000 units). If Batch Y is 50,000 units, the cost per unit for setup will be $0.01 ($500 divided by 50,000 units). For simplicity, let's assume that the remaining $1,800,000 of manufacturing overhead is caused by the production activities that correlate with the company's 100,000 machine hours.

For our simple two-activity example, let's see how the rates for allocating the manufacturing overhead would look with activity based costing and without activity based costing:

With ABC
Without ABC

Mfg overhead costs assigned to setups
$200,000
$0

Number of setups
400
Not applicable

Mfg overhead cost per setup
$500
$0

Total manufacturing overhead costs
$2,000,000
$2,000,000

Less: Cost traced to machine setups
200,000
0

Mfg O/H costs allocated on machine hours
$1,800,000
$2,000,000

Machine hours (MH)
100,000
100,000

Mfg overhead costs per MH
$18
$20

Mfg Overhead Cost Allocations
$500 setup cost per batch + $18 per MH
$20 per MH

Next, let's see what impact these different allocation techniques and overhead rates would have on the per unit cost of a specific unit of output. Assume that a company manufactures a batch of 5,000 units and it produces 50 units per machine hour, here is how the cost assigned to the units with activity based costing and without activity based costing compares:

With ABC
Without ABC

Mfg overhead for setting up machine
$500
$0

No. of units in batch
5,000
Not applicable

Mfg O/H caused by Setup â?" Per Unit
$0.10
Not applicable

Mfg overhead costs per machine hour
$18
$20

No. of units produced per machine hour
50
50

Mfg O/H caused by Production â?" Per Unit
$0.36
$0.40

Total Mfg O/H Allocated â?" Per Unit
$0.46
$0.40

If a company manufactures a batch of 50,000 units and produces 50 units per machine hour, here is how the cost assigned to the units with ABC and without ABC compares:

With ABC
Without ABC

Mfg overhead for setting up machine
$500
$0

No. of units in batch
50,000
Not applicable

Mfg O/H caused by Setup Per Unit
$0.01
Not applicable

Mfg overhead costs per machine hour
$18
$20

No. of units produced per machine hour
50
50

Mfg O/H caused by Production â?" Per Unit
$0.36
$0.40

Total Mfg O/H Allocated Per Unit
$0.37
$0.40

As the tables above illustrate, with activity based costing the cost per unit decreases from $0.46 to $0.37 because the cost of the setup activity is spread over 50,000 units instead of 5,000 units. Without ABC, the cost per unit is $0.40 regardless of the number of units in each batch. If companies base their selling prices on costs, a company not using an ABC approach might lose the large batch work to a competitor who bids a lower price based on the lower, more accurate overhead cost of $0.37. Its also possible that a company not using ABC may find itself being the low bidder for manufacturing small batches of product, since its $0.40 is lower than the ABC model of $0.46 for a batch size of 5,000 units. With its bid price based on manufacturing overhead of $0.40 but a true cost of $0.46 the company may end up doing lots of production for little or no profit.

Our example with just two activities (production and setup) illustrates how the cost per unit using the activity based costing method is more accurate in reflecting the actual efforts associated with production. As companies began measuring the costs of activities (instead of focusing on the accountant's departmental classifications), they began using ABC cost information to practice activity based management. For example, with the cost of setting up a machine now being measured and discussed, managers began to ask questions such as:

Please answer the following in detail

Why is the cost of setting up a production machine so expensive? What can be done to reduce the setup cost? If the setup costs cannot be reduced, are the selling prices adequate to cover all of the companys costs including the setup cost that was previously buried in the overall machine-hour overhead rate?

Elaborate your solution describing how Activity Based Costing can benefit companies. You may wish to give an example of a company where activity based costing could be applied. Describe in detail how this company could benefit from Activity based costing.

Solution expectations:

The following items will be evaluated in particular:

Identify strengths and weaknesses of ABC
Discuss the differences between traditional product costing and ABC
Explain why the inclusion of fixed costs in the product will lead to poor internal decision making.

View Full Posting Details