Relationship between sales revenue and advertising expenditures
Not what you're looking for?
1) A company is trying to determine the optimal level of advertising expenditures. Based upon past experience and test markets, please find below the relationship between sales revenue and advertising expenditures. The average gross margin percent (gross margin/revenue) is shown in parentheses for that level of sales. The margin increases as the revenue increases because of "economies of scale", but will eventually decrease because of the "diseconomies of scale". Please note that the unit selling price is the same at each level of advertising expenditure (price is not changed).
? No advertising => revenue of $1.2 mio (40%)
? Advertising $ 200,000 => revenue of $2.1 mio (43%)
? Advertising $ 400,000 => revenue of $2.9 mio (46%)
? Advertising $ 600,000 => revenue of $3.2 mio (48%)
? Advertising $ 800,000 => revenue of $3.4 mio (46%)
The income tax rate is 30%. Fixed G&A expenses are $600,000. Using Excel, please prepare a table showing:
? Revenue
? Gross margin
? Income before tax
? Net income
? Marginal revenue from Advertising (marginal product of advertising)
Please also briefly explain why the marginal revenue of advertising declines as the level of advertising increases (which is often the case in the real world).
Purchase this Solution
Solution Summary
The relationship between sales revenues and advertising expenditures are discussed.
Education
- BE, Bangalore University, India
- MS, University of Wisconsin-Madison
Recent Feedback
- "Your explanation to the answers were very helpful."
- "What does 1 and 0 means in the repair column?"
- "Went through all of the formulas, excellent work! This really helped me!"
- "try others as well please"
- "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.