Strategic Market 6

profileMiguelito102519
ProctorGamble5.docx

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 Research29(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