Draft an excel budget spreadsheet for a marketing campaign including the following: As for the budget, consider
Fantastic news! We've Found the answer you've been seeking!
Question:
Draft an excel budget spreadsheet for a marketing campaign including the following:
- As for the budget, consider all the varying types of resources you'll use in marketing the campaign, and what sort of costs will be associated with each. Here are some categories that may help you begin to break your budget down:
- Sales Budget.A sales budget expresses a company's expected sales in the form of units and dollars. Because the sales budget serves as a starting point for all operating budgets and most financial budgets, the information it contains should be as accurate as possible.
- Production Budget.A production budget tells a company how many units it must produce to meet its sales needs and satisfy ending inventory requirements.
- Selling, General, and Administrative Budget (SG&A).A selling, general, and administrative budget (SG&A) details planned expenditures for nonmanufacturing activities (fixed or variable). The SG&A budget essentially includes all of a company's costs that are not directly tied to production.
- Cash Budget.A cash budget approximates the amount of cash a company has on hand at the beginning of the budget period. It also estimates a company'scashinflows and outflowsthe amount of money coming into and leaving the company.
Here is the framework:
The total budget for the campaign is $3.75 million. This includes $2 million for TV commercials, $500,000 for manufacturing limited-edition cans, $1 million for manufacturing point-of-sale displays, and $250,000 for the giveaway and pop-up. The budget will be allocated as follows:
- 53% for TV commercials
- 13% for limited-edition cans
- 27% for point-of-sale displays
- 7% for the giveaway and pop-up
Related Book For
Principles Of Managerial Finance
ISBN: 9781292400648
16th Global Edition
Authors: Chad Zutter, Scott Smart
Posted Date: