Home page     Downloads      Privacy policy     Disclaimer & terms of use     Contact us     Advertise with us     About us      Link to us

Home Activity Based Costing System Activity Based Costing (ABC) Example/ Problem
 

Activity Based Costing Example / Problem / Format:

Learning Objectives:

  1. Perform the first stage allocation of overhead costs to the activity cost pools.
  2. Compute activity rates for the activity cost pools.
  3. Construct a table showing the overhead costs of units and four orders.

Ferris Corporation makes a single product - a fire resistant commercial filing cabinet - that it sells to office furniture distributors. The company has a simple ABC system that it uses for internal decision making. The company has two overhead departments whose costs are listed below:
 
Manufacturing overhead $5,00,000
Selling and administrative overhead $300,000
 
Total overhead costs $8,00,000

 The company's activity based costing system has the following activity cost pools and activity measures:
 
Activity Cost Pool Activity Measures
Assembling units Number of units
Processing orders Number of orders
Supporting customers Number of customers
Other Not applicable

Costs assigned to the "other" activity cost pool have no activity measure; they consist of the costs of unused capacity and organization-sustaining costs - neither of which are assigned to products, orders or customers.

Ferris Corporation distributes the costs of manufacturing overhead and of selling and administrative overhead to the activity cost pools based on employee interviews, the results of which are reported below:
 

Distribution of Resource Consumption Across Activity Cost Pools

  Assembling Units Processing Orders Supporting Customers Other Total
Manufacturing overhead 50% 35% 5% 10% 100%
Selling and administrative overhead 10% 45% 25% 20% 100%
Total activity 1,000 units 250 orders 100 customers -- --

Required:

  1. Perform the first stage allocation of overhead costs to the activity cost pools.
  2. Compute activity rates for the activity cost pools.
  3. OfficeMart is one of the Ferris Corporation's customers. Last year OfficeMart ordered filing cabinets four different times. OfficeMart ordered a total of 80 cabinets during the year. Construct a table showing the overhead costs of these 80 units and four orders.

Solution:

1. The first stage allocation of costs to the activity cost pools appears below:

                                         Activity Cost Pools


  Assembling Units Processing Orders Supporting Customers Other Total
Manufacturing overhead $250,000 $175,000 $25,000 $50,000 $500,000
Selling and administrative overhead 30,000 135,000 75,000 60,000 300,000
 




Total activity $280,000 $310,000  $100,000 $110,000 $800,000
 

2. The activity rates for the activity cost pools are:
 
Activity Cost Pools Total Cost Total Activity Activity Rate
Assembling units $280,000 1,000 units $280 per unit
Processing orders $310,000 250 units $1,240 per order
Supporting customers $100,000 100 customers $1,000 per customer

3. The overhead cost for the four orders of a total of 80 filing cabinets would be computed as follows:
 
Activity Cost Pools Total Cost Total Activity Activity Rate
Assembling units $280 per unit 80 units $22,400
Processing orders $1,240 per order 4 units $4,960
Supporting customers $1000 per customer Not applicable  

4. The product and customer margin can be computed as follows:
 
Filing Cabinet Product Margin:    
Sales ($595 per unit 80 units)   $47,600
Cost:    
     Direct materials ($180 per unit 80 units) $14,400  
     Direct materials ($50 per unit 80 units) 4,000  
     Volume related overhead (above) 22,400  
     Order related overhead (above) 4,960 45,760
 

    $1,840
    ==========
Customer Profitability Analysis - OfficeMart    
Product margin (above) $1,840  
Less: Customer support overhead (above) 1,000  
 
 
  $840  
  ===========  
     

You may also be interested in other relevant articles from "activity based costing system" chapter:

  1. Definition and Explanation of Activity Based Costing System
  2. Treatment of Manufacturing, Non-manufacturing and Idle Capacity Costs Under Activity Based Costing System
  3. Activity Based Costing And Top Management
  4. Activity Based Costing System and External Reports
  5. Designing and Implementing Activity Based Costing System
  6. Targeting Process Improvements (Activity Based Costing + Activity Based Management)
  7. Advantages or Benefits | Disadvantages or Limitations of Activity Based Costing System
  8. Activity Based Costing Example

 

Downloadable Materials

Learn Accounting Easily With AccountingCoach Pro

View Online or Download all of the materials to Your Computer and Print Immediately

What is Included in Accounting Book
Downloadable Self-Study Materials ( Available in Word Editable Format)
Help in preparation of Online Exams (Available in Word Editable Formatt)
Solved Accounting Problems
Bookkeeping and Financial Statements

Back to Home Page | Back to Activity Based Costing System Page

Managerial Accounting

 
Introduction to Managerial Accounting
Business and Quality Improvement Programs
Cost Terms, Concepts and Classification
Job Order Costing system
Process Costing System
Process Costing System - Addition of Materials & Beginning Inventory
Controlling and Costing Materials
Materials and Inventory Cost Control
By Products and Joint Products Costing
Cost-Volume-Profit-Relationship
Variable Costing System
Activity Based Costing System
Budgeting and Planning
Standard Costing and Variance Analysis
Gross Profit Analysis
Linear Programming Technique
Segment Reporting and Transfer Pricing
Capital Budgeting Decisions
Service Department Costing
Cash Flow statement
Financial statement Analysis
Pricing Products and Services
Managerial Accounting Terms and Definitions
Managerial / Cost Accounting Formulas

Financial Accounting

 
Bookkeeping and Bookkeeping Terms
Accounting Principles and Accounting Equation
Journal
Ledger
Accounting For Bills of Exchange
Subdivision of Journal
Final Accounts
Capital and Revenue Items
Single Entry System/Accounting From Incomplete Records
Accounting For Non-Trading Concerns
Accounting for Consignment / Consignment Accounts
Accounting for Joint Ventures
Accounting for Depreciation

About us !

 
Also see formula of gross margin ratio method with financial analysis, balance sheet and income statement analysis tutorials for free download on Accounting4Management.com.Accounting students can take help from Video lectures, handouts, helping materials, assignments solution, Online Quizzes, GDB, Past Papers, books and Solved problems. Also learn latest Accounting & management software technology with tips and tricks.

Home page   Download Material   Privacy policy   Disclaimer & terms of use   Contact us   Advertise with us   About us   Useful links   Link to us

Copyrights of all content on this web site are owned by Accounting For Management except where indicated in source or copyright statements. Accounting For Management must be contacted for permission to copy or redistribute any material published on this website.
Copyright 2014 Accounting For Management. All rights reserved.