M4 (RJ) Responce

NEED PEER RESPONSE:
ORIGINAL QUIESTON:
Assignment 1: Discussion—ABC or Activity-Based Costing
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

STUDENT RESPONSE:
ABC or Activity-Based Costing

Total cost for small campaigns: 325000 + 835714 + 337500 = $1498214

Cost for large campaigns: 325000 + 64286 + 112500 = $501786

Creative: $500000 + $150000 = $650000

Small campaigns = (400/ 800 * 650000) = $325000
Large campaigns = (400/ 800 * 650000) = $325000
Production Staff: $750000 + $150000 = $900000
Small campaigns = (325/ 350 * 900000) = $835714
Large campaigns = (25/ 350 * 900000) = $64286
Administration &support staff: $300000 + $150000 = $450000
Small campaigns = (300/ 400 * 450000) = $337500
large campaigns = (100/ 400 * 450000) = $112500

800 (400 small +400 large) advertisements =$500000

Meaning that, for small advertisement= 0.125 X $500000=$62500
For large advertisement = 0.875 X $500000 = $437500
The large advertisement that were successful, =25/400 X $437500 = $27343.75
The small advertisement that were successful, = 325/400 X $62500 = $50781.25
Total creative staff overhead = ($27343.75+ $50781.25) = $78125
Production staff = $750000
Rental and associated costs = $450,000
Administrative & support staff =$300,000
The advertising costs =$2000000

Small campaign: ((1498214 – 1300000) / 1300000) * 100% = 15.25%

Large campaign: ((700000 – 501786) / 700000) * 100% = -28.32%
Reference
Cokins, G. (2001). Activity-based cost management: An executive’s guide. New York: Wiley.
Hicks, D. T. (2002). Activity-based costing: Making it work for small and mid-sized companies.
Horngren, C. (2017). Cost accounting. [S.l.]: Pearson.
NEED PEER RESPONSE:

Quality and affordable writing services. Our papers are written to meet your needs, in a personalized manner. You can order essays, annotated bibliography, discussion, research papers, reaction paper, article critique, coursework, projects, case study, term papers, movie review, research proposal, capstone project, speech/presentation, book report/review, and more.
Need Help? Click On The Order Now Button For Help

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"