Question

In: Accounting

In your readings this module, you were introduced to Activity-Based Costing or ABC. It is a...

In your readings this module, you were introduced to Activity-Based Costing or ABC. It is a method used to determine a reliable predetermined benchmark for the allocation of overhead costs to the products produced based on their activity levels. In this discussion, we will work a case study on ABC together. For your initial response, attempt to answer the questions yourself and post all the required items into the Discussion Area. You may want to post some elements during different days so the class can work this problem together. Then in your response postings, help each other with misunderstandings or miscalculations.

Tasks: Examine the case below and then…

Calculate the amount of overhead allocated to small and large advertising campaigns under existing methods.

Apply activity-based costing to calculate the cost per cost driver for each of the cost pools.

Use the costs per cost driver to calculate the activity-based overhead applicable to small and large campaigns.

Calculate the percentage to be added to direct advertising costs to recover overhead costs under activity-based costing.

Merit-o-cracy PLC is a specialist advertising agency. It has been long-established but is experiencing difficulties in winning new business. The Chief Executive believes that its pricing methods are leading to the loss of large customer advertising campaigns while it is consistently winning smaller business.

Merit-o-cracy costs work for pricing purposes on the basis of direct advertising costs (i.e. space or time purchased from newspapers, radio and TV) plus 100%. The 100% is intended to cover all the overheads of the business, which run at $2 million per year. It does not include any profit margin. This budget cost comprises:

Creative staff $500,000

Production staff $750,000

Administrative & support staff $300,000

Rental and associated costs $450,000

Merit-o-cracy classifies its advertising campaigns as either small or large. Of the 350 campaigns the agency wins, about 325 are classified as small. A typical small advertising campaign incurs direct advertising costs of $4,000 each (and therefore is allocated $4,000 of overheads under current methods). The other 25 advertising campaigns are large and incur direct advertising costs of $28,000 each.

Merit-o-cracy’s accountant has heard of activity-based costing. After speaking to the management team, she has gathered information on the most common causes of costs. She believes that creative staff costs are linked to the number of advertising campaigns the agency competes for. Production staff costs are related to the number of advertising campaigns the agency wins. Administrative and support staff costs are related to the number of customers the agency has. Rental and associated costs are people-based and as a similar number of staff is employed in each of the three departments, the costs should be equally shared. The accountant has also collected data on the activity levels in each of the three departments over the budget period. These are:

Creative

800 advertising campaigns the agency bids for

400 of these are bids for large campaigns and 400 for small campaigns

Production

350 advertising campaigns the agency wins

325 of these are small campaigns and 25 large campaigns

Admin & support

400 customers the agency services

300 of these are customers with small campaigns and 100 have large campaigns

Solutions

Expert Solution

Under current pricing methodology 100% of direct cost is taken as overhead cost and allocated to each job. Hence for a small advertising project $4,000 will be allocated as overhead and for a large advertising project $28,000 will be charges.

In case we use Activity based costing technique then the following table shows the various cost pools

Particulars Creative staff Production staff Admin and support
Total cost $500,000 $750,000 $300,000
Total no of units of the relevant cost driver 800 350 400
Cost per unit of cost driver (calculated by dividing the above two) $625 $2,142.86 $750

For the rental cost the total cost will be simply divided equally among the two category of products.

Now the total overhead cost allocated to both type of advertising can be calculated as follows

Particulars large advertising small advertising
Creative staff cost 400*625 = $250,000 400*625 = $250,000
Production staff cost 25*2142.86 = $53,571 325*2142.86 = $696,429
Admin and support cost 100*750 = $75,000 300*750 = $225,000
Rental cost $225,000 $225,000
Total overhead cost $603,571 $1,396,429
Overhead cost per unit 603571/25 = $24,142.84 1396429/325 = $4,296.70

Hence the percentage to be added to direct cost is as follows

For large advertising = 24142.84/28000*100 = 86.22%

For small advertising = 4296.70/4000 = 107.42%


Related Solutions

Explain the purpose of Activity-Based Costing(ABC).
Explain the purpose of Activity-Based Costing(ABC).
- Activity-Based Costing Define activity-based costing (ABC) systems. What benefits does implementing an ABC system bring...
- Activity-Based Costing Define activity-based costing (ABC) systems. What benefits does implementing an ABC system bring to the company? Explain at least two benefits. What are the disadvantages to implementing an ABC system? List and explain at least two. Would the proposed changes make ABC a universally applicable costing method in your opinion? Why or why not? Elaborate your response. No plagiarised answer, please.
What is the difference between Activity-Based Costing(ABC) and Traditional Costing?
What is the difference between Activity-Based Costing(ABC) and Traditional Costing?
Tell what you know about the difference between volume-based (traditional) costing and activity-based (ABC) costing
Tell what you know about the difference between volume-based (traditional) costing and activity-based (ABC) costing
Based on your course readings in Module 1 and additional research, prepare and post to the...
Based on your course readings in Module 1 and additional research, prepare and post to the Discussion Area the strengths and weaknesses of healthcare delivery in the U.S., as compared to other developed nations such as England or Australia. In addition discuss the factors that contribute to the strengths and weaknesses of healthcare delivery in the U.S. Justify your viewpoint using examples. Note: You are encouraged to look for authoritative, peer-reviewed sources of information and then choose your own perspective...
Having attended a course on activity based costing (ABC) you decide to experiment by applying the...
Having attended a course on activity based costing (ABC) you decide to experiment by applying the principles of ABC to the four products currently made and sold by your company. Details of the four products and relevant information are given below for one period. Product                                              A                        B                  C                    D Output in units Cost per unit Direct material (Ksh) Direct labour (Ksh) 120 40 28 100                 80 50                 30 21                 14 120 60 21 Machine hours per unit (hours)             4                         3                ...
How would you use activity-based costing (ABC) in the organization you work/worked at? Explain activity level...
How would you use activity-based costing (ABC) in the organization you work/worked at? Explain activity level in your organization in addition to the steps needed to follow while implementing ABC. Subject: Managerial Accounting Write more than 350 words
How would you use activity-based costing (ABC) in the organization you work/worked at? Explain activity level...
How would you use activity-based costing (ABC) in the organization you work/worked at? Explain activity level in your organization in addition to the steps needed to follow while implementing ABC. Subject: Managerial Accounting Write more than 350 words
Select a manufacturer in your area and explain how it could implement an activity-based costing (ABC)...
Select a manufacturer in your area and explain how it could implement an activity-based costing (ABC) system. When you are deciding on a company to use, consider the costs and benefits in implementing an ABC system. In your post, provide some background information about your company. Explain what it produces and identify the activities that would drive costs. Discuss the cost pools that it would use. Recommend the process it would need to go through to implement ABC in the...
As you might imagine the ABC Tank Manufacturing Company uses an activity-based costing system. ABC has...
As you might imagine the ABC Tank Manufacturing Company uses an activity-based costing system. ABC has given you the following data that is used in its activity-based costing system: Overhead Costs Wages and salaries $ 348,000 Other overhead costs 193,000 Total overhead costs $ 541,000 Activity Cost Pool Activity Measure Total Activity Direct labor support Number of direct labor-hours 10,500 DLHs Order processing Number of orders 480 orders Customer support Number of customers 105 customers Other This is an organization-sustaining...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT