Compute amount of overhead allocated to advertising campaign

Assignment Help Managerial Accounting
Reference no: EM131442840

Assignment: Accounting Practices for Managers

Tasks:

• Examine the case below and then...

o Calculate the amount of overhead allocated to small and large advertising campaigns under existing methods.
o Apply activity-based costing to calculate the cost per cost driver for each of the cost pools.
o Use the costs per cost driver to calculate the activity-based overhead applicable to small and large campaigns.
o 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

OVERHEAD COSTS ALLOCATED UNDER CURRENT METHODS
Small campaigns - $4000 x 325 = $1,300,000
Large campaigns - $28,000 x 25 = $700,000

ACTIVITY BASED COSTING - COST PER COST DRIVER
CREATIVE - $500,000/800 = $625
PRODUCTION - $750,000/350 = $2142.88
ADMIN & SUPPORT - $300,000/400 = $750

ACTIVITY BASED OVERHEAD
CREATIVE
Small campaigns - 400 x $625 = $250,000
Large campaigns - 400 x $625 = $250,000

PRODUCTION
Small campaigns - 325 x $2142.88 = $696,436
Large campaigns - 25 x $2142.88 = $53,572

ADMIN & SUPPORT
Small camapaigns - 300 x $750 = $225,000
Large campaigns - 100 x $750 = $75,000

TOTAL OVERHEARD COST BASED ON ACTIVITY BASED COSTING - Add totals from Activity Based Overhead.
Small campaigns - $946,436
Large campaigns - $153,672

**SMALL CAMPAIGNS - Overhead comes to $946,436 based on Activity Based Costing. In order to cover the overhead based on this amount, 73% ($946,436/325=$2912/$4000x100=73%) should be added to the direct advertising costs

**LARGE CAMPAIGNS - Overhead comes to $153,672 based on Activity Based Costing. In order to cover the overhead based on this amount, 22% ($153,672/25=$6146/$28,000x100=22%) should be added to the direct advertising costs.

Reference no: EM131442840

Questions Cloud

Show what happened once the war ended. : During wartime, countries shift production from civilian goods, like automobiles and clothing, to military goods, like tanks and military uniforms.
Which is one of the modules objectives : Why do you think Module 3 shifts specifically to, and focuses on, " ... conflict between Native Americans and the English in particular", which is one of the module's objectives? (IE, why is there so much attention to the English at this point in ..
Views of europeans of the fifteenth and sixteenth centuries : Contrast the views of Europeans of the fifteenth and sixteenth centuries with those of Native Americans and Africans they encountered on such topics as the environment, social relations, religious beliefs, and slavery. Are historical terms like "s..
Show the production possibilities curve : How would the following events be shown using a production possibilities curve for shelter and food? a. The economy is experiencing double-digit unemployment.
Compute amount of overhead allocated to advertising campaign : MS6010- 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.
Mesopotamian and egyptian societies : Consider the linkages between politics, religion, and art in Mesopotamian and Egyptian societies. Provide a specific example and analyze how it responds to politics, religion, and art.
Eastern african nile valley civilizations of egypt : Analyze the Eastern African Nile Valley civilizations of Egypt, Ethiopia, Kush, and Axum, and the Western civilizations of Ghana, Mali, and Songhai.
Challenges of global economic integration : Compare the establishment of the Qing dynasty in China with the establishment of the Tokugawa Shogunate in Japan. How did each group assert its legitimacy? How did each respond to the challenges of global economic integration?
Examine the depiction of king philips war : Examine the depiction of King Philip's War (Metacom's War). What advantages might the Native Americans have had that are not depicted here?Read these two early seventeenth century accounts related to John Smith.How do these accounts demonstrate th..

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Question 1in order to assist the manager you are compiling

question 1in order to assist the manager you are compiling a resource which will define the various management

  Considering the acquisition of equipment

(Ignore income taxes in this problem.) Gull Inc. is considering the acquisition of equipment that costs $530,000 and has a useful life of 6 years with no salvage value. The incremental net cash flows that would be generated by the equipment are:

  Sherriane baby products salaries expense

Prepare a summary entry that represents the net effect of salaries expense incurred and paid during the reporting period.

  Discuss the advantages of forming two divisions

Discuss the advantages of forming two divisions (an Automotive division and a Home Products division) and allowing the division managers substantial decision-making autonomy.

  What is expected value of perfect information about product

Should the product be marketed? Why? What is the expected value of perfect information about the success or failure of the product?

  Prepare a revised budget consistent with the president

Prepare a revised budget consistent with the president's recommendation.

  Activity-based costing: hampstead company

Hampstead company's order entry department has 20 order entry operators. The cost associated with these 20 operators (salaries, fringe benefits, and supervision, as well as occupancy and equipment costs) is $873,600 per year.

  Type of costing system

Describe the costs and processes involved in making your firm's product or providing their service, and state what type of costing system might be used (job order, process or hybrid costing)

  What is the purpose of the changes columns

What is the purpose of the "changes" columns of a spreadsheet to prepare a statement of cash flows?

  Why wouldn''t this product be the most profitable use

Which product has the largest unit contribution margin? Why wouldn't this product be the most profitable use of the constrained resource in either case?

  Calculate the cost of delivering the lost parcel

How do you think the cost of $240 would have been calculated - Under what circumstances might it be contended that there was no cost associated with losing the parcel?

  Determining firm cost of equity

Your firm has a debt-equity ratio of .40. Your cost of equity is 12% and your after-tax cost of debt is 6%. What will your cost of equity be if the target capital structure becomes a 50/50 mix of debt and equity?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd