Purchase Solution

Manager of marketing department: develop department budget

Not what you're looking for?

Ask Custom Question

ACCT320-1202A-01 Intermediate Accounting II
Assignment Name: Unit 5 Individual Project
Deliverable Length: 1 Excel spreadsheet
Details: As the manager of the marketing department, you are being asked for the first time to develop a department budget. The accounting department has supplied you with the following projected information about how this year, 20XX, will end up for your department's spending.
Expense category 20XX projected
Sales force base salary 200,000
Sales force commission 200,000
Sales force benefits 60,000
Trade show space rental 50,000
Free coupon expense 40,000

Note:
Sales 2,000,000
Before you begin the process, your manager and you have sat down to develop broad planning objectives for the upcoming year, which you will need to incorporate into the budget. These include
- a doubling of trade show spending.
- an increase of the sales force by 25%.
- an expected sales volume increase of 10%.
- an expected increase of 4% of all expenses due to inflation.
- no anticipated selling price changes for next year.
You need to do the following:
A. for each of the listed expenses:
- identify whether you would treat them as a fixed or variable cost
- explain the reasoning for your classification
B. based on the historical information and the planning you did for new marketing programs for the upcoming year, prepare a budget for the upcoming year by completing the table:
1. In the 20XX+1 column, fill in budgeted figures.
2. In the next column, when appropriate, adjust that amount for inflation.
3. Complete the next column based on the projected volume increase.
4. In the last column, briefly explain how you arrived at the budgeted figure.

Expense category 20XX projected 20XX+1 with plan changes 20XX+1 with inflation changes 20XX+1 with volume impact Explanation
Sales force base salary 200,000
Sales force commission 200,000
Sales force benefits 60,000
Trade show space rental 50,000
Free coupon expense 40,000

Note:
Sales 2,000,000 2,200,000

The following grading criteria will be used:
Grading Guidelines
20% For each of the listed expenses:
- identify whether you would treat them as a fixed or variable cost
- explain the reasoning for your classification
20% In the 20XX+1 column, fill in budgeted figures.
20% In the next column, when appropriate, adjust that amount for inflation.
20% Complete the next column based on the projected volume increase.
20% In the last column, briefly explain how you arrived at the budgeted figure.

Objective:
-Understand how fixed and variable costs behave and how to use them to predict costs, analyze a mixed cost using the high-low method and prepare an income statement using the contribution format.
-Understand why organizations budget and the processes they use to create budgets, and recognize situations that present potential ethical and legal issues and develop solutions for those issues.

Purchase this Solution

Solution Summary

Your tutorial is in excel, attached. The cost behavior classification is in the table along with the columns requested. A contribution margin income statement is also provided.

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.