Strategic Market 6
Running head: FINANCIALS IN MARKETING PLAN 1
3
FINANCIALS IN MARKETING PLAN
Financials in marketing plan
Name
Institution
Professor
Course
Date
Marketing planning
Financials section
This section ensures that the market planning strategy you are about to carry out is realistic and actionable (Westwood, 2019). In this section we will major in sales forecast and expenses budget. They consist if the following:
Sales forecast
Forecasting of sales is important since it helps one to have a good control of the inventory, one can have a better understanding of the customers want, their preferences and their queries about your products (Kotler & Kotler, 2017). Sales persons in the company can also use the sales forecast to know which products move faster than the others.
The following is a sample of sales forecast for Procter and Gamble Company from January 20th to May 20th:
SALES FORECAST
|
PRODUCT NAME |
|
January 20th |
February 20th |
March 20th |
April 20th |
May 20 th |
|
Always menstrual hygiene products |
Price per unit |
$ 200. 00
|
$ 200. 00
|
$ 200. 00
|
$ 200. 00
|
$ 200. 00
|
|
|
Units sold |
50 |
40 |
60 |
40 |
50 |
|
|
Total |
$10,000. 00 |
80,000 |
120, 000 |
80, 000 |
10, 000 |
|
Charmin bathroom tissue |
Price per unit |
$50. 00
|
$50. 00
|
$50. 00
|
$50. 00
|
$50. 00
|
|
|
Units sold |
100 |
200 |
100 |
200 |
200 |
|
|
Total |
10,000 |
100,000 |
50, 000 |
10, 000 |
100,000 |
|
Downy fabric
|
Price per unit |
$ 150. 00
|
$ 150. 00
|
$ 150. 00
|
$ 150. 00
|
$ 150. 00
|
|
|
Units sold |
200 |
300 |
300 |
200 |
200 |
|
|
Total |
300, 000 |
450, 000 |
45, 000 |
300, 000 |
300, 000 |
|
Bounty paper towels |
Price per unit |
$ 300. 00
|
$ 300. 00
|
$ 300. 00
|
$ 300. 00
|
$ 300. 00
|
|
|
Units sold |
500 |
600 |
600 |
600 |
600 |
|
|
Total |
150, 000 |
180,000 |
180,000 |
180, 000 |
180, 000 |
|
Dawn dishwashing |
Price per unit |
$ 400. 00
|
$ 400. 00
|
$ 400. 00
|
$ 400. 00
|
$ 400. 00
|
|
|
Units sold |
600 |
700 |
800 |
800 |
800 |
|
|
Total |
240, 000 |
280,000 |
|
|
|
|
Ariel laundry detergent |
Price per unit |
$600. 00
|
$600. 00
|
$600. 00
|
$600. 00
|
$600. 00
|
|
|
Units sold |
100 |
200 |
300 |
300 |
200 |
|
|
Total |
600,000 |
120,000 |
180,000 |
180,000 |
120,000 |
|
Crest toothpaste |
Price per unit |
$ 250
|
$ 250
|
$ 250
|
$ 250
|
$ 250
|
|
|
Units sold |
1000 |
900 |
800 |
700 |
600 |
|
|
Total |
250120, 000 |
225, 000 |
160,000 |
350, 000 |
150, 000 |
Expenses budget for proctor and gambler
An expense budget, is used to tell how much it is going to cost for you to make the sales you have forecasted. If the costs are low it shows you are less exposed to risk. It is important to have an expense budget since it helps one to organize how you are going to spend the savings available. It prevents one from overspending in some areas and leaving some with no funds to spend on. Once you have your budget you are able tell any possible potential issues in the future (Cohen, 2018). .
|
|
January |
|
YEAR TO DATE |
||||
|
FIXED |
Budget |
actual |
variance |
|
Budget |
Actual |
Variance |
|
executive salaries |
97,200 |
43, 872 |
35.89 |
|
65,000 |
96,000 |
15.6 |
|
office salaries |
11,300 |
789,123 |
1.34 |
|
32, 000 |
45, 400 |
8.74 |
|
employee benefits |
22,900 |
35, 123 |
15.34 |
|
145, 000 |
312, 000 |
35.89 |
|
payroll taxes |
57,000 |
312, 098 |
14.23 |
|
200,000 |
310,00 |
1.34 |
|
rent |
76, 000 |
78,123 |
3.45 |
|
146, 789 |
43, 872 |
15.34 |
|
audit |
100, 000 |
32, 000 |
6.78 |
|
45,890 |
789,123 |
14.23 |
|
transport |
26, 00 |
145, 000 |
15.6 |
|
234,123 |
35, 123 |
3.45 |
|
utilities |
45, 000 |
200,000 |
8.74 |
|
567,125 |
312, 098 |
6.78 |
|
taxes |
31, 000 |
146, 789 |
4.74 |
|
56, 897 |
78,123 |
5.4 |
|
VARIABLES |
Budget |
|
|
|
|
|
|
|
office salaries |
12, 000 |
312, 000 |
14.23 |
|
43, 872 |
32, 000 |
14.23 |
|
miscellaneous |
4, 000 |
310,00 |
3.45 |
|
789,123 |
26, 00 |
3.45 |
|
stationary |
1, 000 |
43, 872 |
6.78 |
|
35, 123 |
45, 000 |
6.78 |
|
employee benefits |
6, 000 |
789,123 |
5.4 |
|
312, 098 |
31, 000 |
15.6 |
|
|
|
|
|
|
|
|
|
|
TOTAL |
188,400 |
1,856,369 |
135.97 |
|
1,901,261 |
963,246 |
146.8 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The following if a column graph that shows the fixed graphs for the month of January: one visible tell which expenses will cost more than the others. This kind of a graph is important since the stakeholders can easily understand what the budget contains and they can tell whether it is work or not (Piercy & Morgan, 2018). As per our results, our costs are a bit high. This shows that the plan is quite risky.
References
Cohen, W. A. (2018). The marketing plan. John Wiley & Sons.
Kotler, P., & Kotler, P. (2017). Marketing for nonprofit organizations (Vol. 2). Englewood Cliffs, NJ: Prentice-Hall.
Piercy, N. F., & Morgan, N. A. (2018). The marketing planning process: behavioral problems compared to analytical techniques in explaining marketing plan credibility. Journal of Business Research, 29(3), 167-178.
Westwood, J. (2019). How to write a marketing plan. Kogan Page Publishers.
FIXED BUDGET
executive salaries 97200 office salaries 11300 employee benefits 22900 payroll taxes 57000 rent 0 audit 0 transport 0 utilities 0 taxes 0