Showing posts with label ABUS 5.1.1 Sales Forecasting. Show all posts
Showing posts with label ABUS 5.1.1 Sales Forecasting. Show all posts

Tuesday, 23 August 2016

Welcome to A2 Applied Business & Sales Forecasting

A2 Applied Business

Starting the year as we mean to go on.......
Getting to know you:
In the following clip Michael Jordan explains what is the key to success.
What do you think he is going to say?
  

What characterises Jordan's attitude - and what can you learn from it?
We want our students to see learning as being about endurance, working hard, practising, and making mistakes - rather than being about natural ability.
How can Ronaldo add to this discussion?



How to get going with work

How to avoid procrastinating: Charlie explains why we procrastinate, and suggests ways to make ourselves more productive with our time:
Verb:procrastinate


Delay, put off doing something, postpone action, defer action, use delaying tactics, stall, play for time, play a waiting game, drag one's feet/heels,take one's time.



How to create and stick to new habits:

How to create habits that you stick to: in the following clip, Charlie explains how using Jerry Seinfeld's 'Don't break the chain' idea has helped him to create and stick to new habits:



Susan and Robert:


Understanding Plagiarism:




ABUS5 - Business Decision Making

5.1 Decision-making and the marketing function.

http://www.youtube.com/watch?v=TVblWq3tDwY

What is your definition of 'marketing'?

Noun: Marketing
The action or business of promoting and selling products or services, including market research and advertising.
Cadburys has a ‘brand manager’ for each product within its portfolio.
How many different Cadbury products can you think of?


Each brand manager will focus on the likely future sales of the product they are responsible for.

Imagine this was your role for Creme Eggs (with a £60,000 salary, at least.)

What are the implications for Cadbury of a changing sales forecast for the products they make?

A sales forecast will have an impact on:

1. Investment decisions.
2. The number and type of staff that are required.
3. The four Ps.

Methods of forecasting sales:

For a new product Test Marketing may be used.


For an existing product a 'moving average' is a good way to smooth out fluctuations in sales to allow for a prediction of future sales. This is technically known as time series analysis.



In the following video a Centred Moving Average is discussed. Your exam board does not expect you to take this extra step. We will discuss this in class.


Qualitative sales forecasting:

This may involve panel surveys (focus groups):


Or industry experts (the Delphi technique). A nice summary of this technique here.


Advantages and disadvantages of the Delphi technique. Details here.



Monday, 23 May 2016

Calculating the Trend

This table shows my current sales.



Quarter (2012)

Sales

(£000's)

Seasonal variation *

(£000's)

1.  January - March

34

+2

2.  April - June

30

-4

3.  July -     September

40

+4

4  October - December

34

-4

*The formula  ‘Actual minus Trend’ is used to calculate the seasonal variations.

1. Calculate and describe the sales trend shown in the table. [5]
Answer:
The sales figures in 000's in the question can be shown as the blue line.
You have been asked to calculate the red 'trend' line.
So....
If the seasonal variation figure is above the red line (a + number)  you need to take that amount (in 000's) away from the sales figures.
You do the opposite if the seasonal variation is below the red 'trend' line.



Quarter (2012)

Trend

(£000's)

1. January - March

32

2. April - June

34

3. July - September

36

4. October - December

38


A rising trend. 1 mark
Rising by £2000 per quarter. 1 mark
2 marks for correct figures in the table.
1 mark for correct display of figures i.e. '£' and '000's
2. Forecast the sales for each quarter of 2014, and the total sales value for 2014. You will need to use the information provided in the table and your response to question 1 In your answer. [5]

We calculated the trend for 2012.
We need to assume the same pattern continues through 2013 and 2014.

 2013

 Sales (£000's)

 Q1

 40

 Q2

 42

 Q3

 44

 Q4

 46

 2014


 Q1

 48

 Q2

 50

 Q3

 52

 Q4

 54
These figures are the 'trend'. The question asks you to calculate: the sales value for each quarter of 2014, and the total sales value for 2014. We now need to use the seasonal variation figures to work out the sales for each quarter.

So...


 2014

 Trend (£000's)

 Seasonal Variation

 Sales (£000's)

 Q1

 48

 +2

 50 (1 mark)

 Q2

 50

 -4

 46 (1 mark)

 Q3

 52

 +4

 56 (1 mark)

 Q4

 54

 -4

 50 (1 mark)

Total sales for 2014 are forecast to be: £202,000 (50 + 46 + 56 + 50)
(1 mark)


3. To what extent can a marketing manager rely on time series analysis to forecast future sales? [10]
A linear trend (1) A marketing manager can use such a trend to forecast future sales value (1)
But this trend is not guaranteed to continue (1)

Seasonal variations only are used (1) - the influence of cyclical and random/catastrophic variations are not analysed (1)
Other quantitative techniques e.g. sampling, analysis of market research, could give alternative forecasts (1)
Qualitative analysis, e.g. customer surveys, should also be used (1)
(Conclusion/judgement)

Knowledge of the trend informs company management  (1) - but the reliability of all quantitative techniques’ data is questionable (1)

Knowledge of other matters, e.g. competitor actions global issues e.g. recession in the markets the company operates in, are needed for a fuller judgement (1)

Tuesday, 17 May 2016

Sampling Calculation


A building firm called Jones and Son Ltd wish to carry out a survey of householders in Richmond upon Thames
William Jones has found out information from the 2011 census.
London Borough of Richmond upon Thames population: 191 400 (of which 93,000 are males). 


Housing status %

Richmond upon Thames %

England and Wales %

Owner occupier

85%

70%

Council tenant

5%

20%

Other

10%

10%



Age Group %

Richmond upon Thames %

England and Wales %

Under 16

20.8

20.2

16 - 17

5.2

4.9

18 - 29

13.1

12.6

30 - 59

39.0

41.5

60 and over

21.9

20.8
          The sample chosen is 18+ home owning males.

The firm has requested a stratified 3.5% sample of the target market. The criteria for the stratified sample is ‘Richmond borough male home owners over the age of 18’
Calculate:
1. The total sample size.
         2. State the number of males aged 18 – 29 in the sample.
         3. State the number of males aged 30 and over in the sample.
Show all your workings. 
Answer:
Population who are 18+ (13.1% + 39% + 21.9%) = 74%
93,000 (males) x 0.74 = 68,820
Home owning = 85%
68,820 x 0.85 = 58,497
3.5% sample:
58,497 x 0.035 = 2047.395
Sample size: Accept 2047 or 2048
Males who are 18 – 29:
2048 x 0.131 = 269
Males who are 30+ (39% + 21.9%) = 60.9%
2048 x 0.609 = 1248