Marketing Analysis: Sales Forecasting (Copy)

8.1 Marketing Analysis

8.1.3 Sales Forecasting

1. Meaning Of Sales Forecasting

• Sales Forecasting: The process of estimating future sales volume and revenue over a specific period.
• Based on historical data, market trends, and qualitative judgments.
• Important for strategic planning, financial management, and resource allocation.

2. The Need To Forecast Sales

• Financial Planning
  • Estimate revenues → helps in budgeting and cash flow planning.
  • Determines financing needs (short-term and long-term).
• Production Planning
  • Helps determine required output.
  • Ensures efficient use of resources.
• Inventory Management
  • Prevents overproduction and underproduction.
  • Balances stock levels with demand.
• Staffing Decisions
  • Hiring or scheduling based on forecasted demand.
  • Reduces labour shortages or redundancies.
• Marketing Strategy
  • Adjust promotional spending to match forecasted demand.
  • Helps set pricing and sales targets.
• Risk Management
  • Identifies potential seasonal fluctuations.
  • Helps prepare for uncertain demand.

Written and Compiled By Sir Hunain Zia, World Record Holder With 154 Total A Grades, 7 Distinctions and 11 World Records For Educate A Change A2 Level Business Full Scale Course

3. Time Series Analysis

• Definition: A method of predicting future sales based on past sales data over time.
• Uses patterns such as trend, seasonal variation, cyclical variation, and random fluctuations.

Key Components Of Time Series

• Trend → general direction (upward, downward, constant).
• Seasonal Variation → regular fluctuations at specific times of year.
• Cyclical Variation → long-term economic cycles (boom, recession).
• Random Variation → unpredictable events (natural disasters, strikes).

3.1 Four-Period Centred Moving Average (CMA) Method

• Used to smooth out fluctuations and identify the trend.

Steps:

1. Add 4 consecutive data points.
2. Divide by 4 → gives the moving average.
3. Place the average between the 2nd and 3rd data points.
4. Continue across the data set.
5. Calculate the CMA (Centred Moving Average) by averaging two consecutive 4-period moving totals.

Formula:

• 4-period moving total = Q1+Q2+Q3+Q4Q₁ + Q₂ + Q₃ + Q₄
• 4-period moving average = Q1+Q2+Q3+Q44frac{Q₁ + Q₂ + Q₃ + Q₄}{4}
• Centred moving average = MA of period t+MA of (t+1)2frac{text{MA of period t} + text{MA of (t+1)}}{2}

3.2 Example Of Four-Period CMA

Quarterly Sales Data (Units):

Step 1: Calculate 4-Quarter Totals

• Q1–Q4: 120 + 140 + 160 + 180 = 600
• Q2–Q5: 140 + 160 + 180 + 200 = 680
• Q3–Q6: 160 + 180 + 200 + 220 = 760
• Q4–Q7: 180 + 200 + 220 + 240 = 840
• Q5–Q8: 200 + 220 + 240 + 260 = 920

Step 2: Calculate 4-Quarter Moving Averages (divide by 4)

• 600 ÷ 4 = 150
• 680 ÷ 4 = 170
• 760 ÷ 4 = 190
• 840 ÷ 4 = 210
• 920 ÷ 4 = 230

Step 3: Centre The Averages

• CMA between Q2 & Q3 = (150 + 170) ÷ 2 = 160
• CMA between Q3 & Q4 = (170 + 190) ÷ 2 = 180
• CMA between Q4 & Q5 = (190 + 210) ÷ 2 = 200
• CMA between Q5 & Q6 = (210 + 230) ÷ 2 = 220

Final Trend Line Data:

Interpretation:

• The trend is increasing by +20 units each quarter.
• Business can forecast Q9 = 260 + 20 = 280 units.

Written and Compiled By Sir Hunain Zia, World Record Holder With 154 Total A Grades, 7 Distinctions and 11 World Records For Educate A Change A2 Level Business Full Scale Course

4. Qualitative Sales Forecasting

• Definition: Forecasting based on opinions, intuition, and experience rather than numerical data.

Methods Of Qualitative Forecasting

• Delphi Technique
  • Panel of experts consulted anonymously.
  • Iterative rounds until consensus is reached.
• Market Research
  • Surveys, interviews, focus groups.
  • Understand consumer preferences and demand patterns.
• Brainstorming / Sales Team Feedback
  • Salespeople provide predictions based on direct customer contact.
• Historical Analogy
  • Predicting new product demand by comparing to similar products.
  • Example: Forecasting demand for electric cars using hybrid car sales data.

Advantages:

• Useful for new products with no historical data.
• Incorporates expert knowledge and insights.
• Helps predict market trends and consumer preferences.

Disadvantages:

• Subjective and less accurate.
• Time-consuming and costly.
• May be biased by personal opinions.

5. Impact Of Sales Forecasting On Business Decisions

• Operations Management
  • Plan production levels.
  • Ensure efficient use of resources.
  • Avoid under- or overproduction.
• Human Resource Management
  • Workforce planning (e.g., hiring seasonal staff).
  • Planning training and development.
• Finance
  • Forecast cash flow.
  • Decide investment levels.
  • Budgeting and resource allocation.
• Marketing
  • Plan promotions and pricing strategy.
  • Manage product life cycle (PLC).
  • Align marketing strategy with demand trends.
• Strategic Planning
  • Forecast long-term demand.
  • Decide on market entry or exit.
  • Support decisions on expansion and diversification.

Written and Compiled By Sir Hunain Zia, World Record Holder With 154 Total A Grades, 7 Distinctions and 11 World Records For Educate A Change A2 Level Business Full Scale Course

6. Limitations Of Sales Forecasting

• Accuracy Depends On Data Quality
  • Poor or incomplete data reduces reliability.
• External Shocks
  • Natural disasters, pandemics, wars, or economic crises can disrupt forecasts.
• Changing Consumer Behaviour
  • Fashion trends, technology, and tastes change rapidly.
• Short-Term vs Long-Term
  • More reliable in short-term; less accurate in long-term.
• Costly And Time-Consuming
  • Requires resources for research and data analysis.
• Over-reliance On Forecasts
  • May discourage flexibility and innovation.

7. Quick Revision Tables

A. Types Of Sales Forecasting

B. Impact On Business Functions

Written and Compiled By Sir Hunain Zia, World Record Holder With 154 Total A Grades, 7 Distinctions and 11 World Records For Educate A Change A2 Level Business Full Scale Course

8. Evaluation Points

• Sales forecasting is useful but not perfect.
• Best used with both quantitative (time series) and qualitative (market research) methods.
• More reliable in stable environments than in dynamic or unpredictable markets.
• Helps managers reduce risk but cannot eliminate uncertainty.
• Poor forecasts can lead to overproduction, stockouts, financial losses.
• Must be regularly updated with new data to remain accurate.

9. Exam Tips

• Always define sales forecasting clearly.
• Be able to calculate 4-period centred moving averages.
• Show calculations step by step:
  • % ΔQd=Q2−Q1Q1×100% ΔQ_d = frac{Q₂ – Q₁}{Q₁} × 100
  • % ΔP=P2−P1P1×100% ΔP = frac{P₂ – P₁}{P₁} × 100
• Use tables to show calculations in exam answers.
• Include examples of real businesses (Amazon, Apple, Tesco).
• Discuss advantages and disadvantages in evaluation.
• Always link forecasts to strategic decisions (e.g., investment, production, HR planning).