MANAGEMENT AND ACCOUNTING WEB

Introduction Main Topics Bibliography Books Journals Textbooks Marketplace Links Software
Contents Search maaw Summaries Maaw's Book Featured Pubs Grad Course Maaw's Blog Gadgets Videos

Example of an ABC Analysis

Summary by James R. Martin

This illustration appears in an article by Martin (2000). It is based on an example from Kaplan and Cooper (1998, 114 -118).

Information Needed for ABC Analysis

Activity

Handle customer orders

Measurement used to represent the activity cost driver

Number of customer orders

Practical capacity

5,000 orders

Budgeted or planned activity for the period

4,000 orders

Actual activity during the period

3,800 orders

Budgeted costs of order handling

$280,000

Actual costs of order handling

$273,600

Cost driver rate

$280,000 ÷ 5,000 orders = $56 per order

ABC Analysis Based on the Information Provided Above

                         /
                       /
                /
                    /
$60,800 U /
  Total       \
  variance   \
  for order    \
  handling      \
                          \
   

                        
                       /
                /
$67,200 U  /
Actual      \
cost of       \
unused        \
capacity        \

A. Actual order handling costs for 3,800 orders

B. Budgeted order handling costs ($56)(5,000 orders)

C. Order handling costs expected to be charged to products for the planned activity ($56)(4,000 orders)

D. Order handling costs charged to products ($56)(3,800)

$273,600
               
  \
              /
$280,000
                  \
               \
               /
             /
$224,000
                 \
                   \
              /
                 / $212,800

$6,400 F
Spending variance

$56,000 U
Planned activity volume variance


$11,200 U
Unplanned activity volume variance

The actual order handling activity volume variance of $67,200 (actual cost of unused capacity ) is separated into $56,000 which represents the cost of budgeted, or planned unused capacity (planned order handling activity volume variance) and $11,200 which represents the unexpected or unplanned cost of unused capacity (unplanned order handling activity volume variance). The key conceptual difference between traditional overhead variance analysis and ABC analysis is that a relevant activity volume (e.g., orders handled) is used as the basis for analyzing each activity in ABC rather than using production volume. In addition, practical capacity is used as the basis for calculating activity driver rates, rather than using the planned activity level or some other level of capacity. Using practical capacity prevents charging unused capacity costs to products and provides more accurate product costs and better information for capacity utilization decisions.

REFERENCES

Kaplan, R. S. and R. Cooper. 1998. Cost and Effect: Using Integrated Cost Systems to Drive Profitability and Performance. Boston: Harvard Business School Press.

Martin, J. R. 2000. The advantages of teaching three production volume variances. Journal of Accounting Education (Winter): 35-50.

 

Books
DVDs
Electronics

 Magazines
Software
VHS

Google

 
Web maaw.info