C3 Sales Forecasting

Question 1

Extrapolation

Answer 1

Using past experience or past business data to forecast future sales.

Question 2

Quantitative forecasting methods

Answer 2

Time series analysis

Use of market research data

Question 3

Qualitative forecasting methods.

Answer 3

Delphi technique
Brainstorming
Intuition
Expert opinion

Question 4

When are quantitative forecasting methods used?

What do they rely on?

Answer 4

When there is historical data available

They rely heavily on data and are objective.

Question 5

Time series analysis

Answer 5

Uses evidence from past sales records to predict future sale patterns

Question 6

Methods of time series analysis

Answer 6

Seasonal analysis
Trend analysis
Cycle analysis
Random factor analysis

Question 7

Seasonal Analysis

Answer 7

Sales are measured on a monthly or weekly basis to examine the seasonality of demand.

Eg the sales of ice cream will be higher in the warmer seasons and lower in the colder seasons, or according to daily weather changes.

Question 8

Trend analysis

Answer 8

This focuses on long-term data, which has been collected over a number of years. The objective is to determine the general trend of sales - rising, falling, or stagnant.

Question 9

Cycle analysis

Answer 9

As with trend analysis, long term figures are used but now the objective is to examine the relationship between demand and levels and economic activity.

Question 10

Random factor analysis

Answer 10

This method of analysis attempts to explain how unusual or extreme sales figures occur.

Eg. If sales of ice creams double for a two week period could this be explained by a change in weather conditions as opposed to a successful marketing campaign?

Question 11

How to work out moving averages

Answer 11

Take the number of adjacent figures for each month, add it together and divide by the number of months.

Result is placed in the middle month.

Question 12

Months in a quarter

Answer 12

3 months

Question 13

Benefits of time series analysis

Answer 13

• Helps plan ahead
• Helps financial planning
• Production planning (determine right type and quantity of supplies are ordered and that the line is running at the correct speed)
• Useful in identifying seasonal variation
• Reduces risk of surprises
• Human resource planning (ensures right number and correctly qualified staff members are available)

Question 14

Limitations of time series analysis

Answer 14

• It is not always easy to predict the future
• Historical data is not always a good indicator
• Even complicated forecasting methods may not be accurate
• Less useful for long term forecasts
• Success is not guaranteed

Question 15

Surveys of consumer intentions

Answer 15

Making predictions by asking people directly what they intend to do in the future. The results of these surveys allow businesses to predict sales patterns, and plan for the future in terms of staffing and production levels.

Question 16

Direct Sales Information

Answer 16

Sales staff may notice any developing trends, and they have the experience to spot market changes, and shifts in customer preferences, and attitudes.

Question 17

Test Marketing

Answer 17

Test marketing involves testing consumers response to a product, before the full release of the product. This may involve releasing the product in a small geographical area or to a small selection of the target market.

Question 18

Delphi method

Answer 18

Begins with the initial development of a questionnaire focusing on the problem, this is then sent out to a select panel of ‘experts’ who independently answer and send back the questionnaire. A second questionnaire is then developed, based on findings from the first, and sent to the same panel.
The members of the panel independently rate and prioritise ideas. This allows the group of experts to reach a consensus forecast on the subject being discussed

Question 19

Benefits of the Delphi Method

Answer 19

• It is flexible enough to be used in a variety of situations and can be applied to a range of complex problems.
• Provides a structured way for a group of people to make a decision.
• Participants have time to think through their ideas leading to a better quality of response.
• The Delphi Method creates a record of the experts responses and ideas which can be used where needed.

Question 20

Limitations of the Delphi Method

Answer 20

• The method will more than likely require a substantial period of time to complete as the process is time consuming to coordinate and manage.
• It assumes that experts are willing to come to a consensus.
• Monetary payments to the experts may cause bias.

Question 21

External factors affecting quantitive and qualitative sales forecasting

Answer 21

• Economic (unemployment, inflation, interest rates, exchange rates, economic growth)
• Consumer Factors (Consumer tastes and fashion is always changing. Consumers are notoriously unpredictable)
• Competition Factors (A business cannot control the actions of competitors)