Continue exploring supply chain forecasting concepts - Microsoft Excel Tutorial

Contents

• Introduction Introduction

  • Using Excel for supply chain forecasting

    45s
  • What you need to know

    45s
  • Using exercise files

    1m 34s
• 1. Forecasting Fundamentals 1. Forecasting Fundamentals

  • The role of forecasting in supply chain management

    2m 11s
  • Preparing to forecast

    2m 41s
  • Quantitative vs. qualitative forecasting

    2m 46s
  • Key types of forecasting methods

    1m 21s
• 2. Fundamentals of Using Excel in Time Series Forecasting 2. Fundamentals of Using Excel in Time Series Forecasting

  • Time series explained

    7m 32s
  • Define level and trend with Excel

    5m 22s
  • Using Excel to define seasonality

    7m 8s
  • Introduce challenge

    1m 5s
  • Challenge solution

    4m 14s
• 3. Understanding Forecasting Errors 3. Understanding Forecasting Errors

  • Measuring forecast errors

    3m 20s
  • Mean absolute deviation (MAD)

    5m 16s
  • Mean absolute percentage error (MAPE)

    5m 39s
  • Root mean squared error (RMSE)

    6m 42s
  • Introduce challenge

    1m 26s
  • Challenge solution

    6m 18s
• 4. Bias in Forecasting 4. Bias in Forecasting

  • What is forecast bias?

    3m 29s
  • Calculating bias

    4m 57s
  • Determining bias significance

    10m 5s
  • Introduce challenge

    45s
  • Challenge solution

    5m 33s
• 5. Moving Average Forecasting 5. Moving Average Forecasting

  • Moving averages and smoothing

    2m 9s
  • Simple and weighted moving average

    6m 16s
  • Exponential moving average

    5m 12s
  • Introduce challenge

    58s
  • Challenge solution

    4m 56s
• 6. Trendlines and Simple Linear Regression 6. Trendlines and Simple Linear Regression

  • Simple linear regression fundamentals

    3m 54s
  • Simple linear regression

    8m 1s
  • Standard error of the regression

    6m 27s
  • Introduce challenge

    1m 47s
  • Challenge solution

    7m 2s
• 7. Compound Annual Growth Rate (CAGR) 7. Compound Annual Growth Rate (CAGR)

  • Linear vs. exponential trends

    2m 29s
  • Exponential curves

    7m 41s
  • Calculating compound annual growth rate (CAGR)

    4m 8s
  • Introduce challenge

    1m 25s
  • Challenge solution

    4m 10s
• 8. Seasonality and Ratio to Moving Average Method 8. Seasonality and Ratio to Moving Average Method

  • Seasonal index

    3m 21s
  • Centered moving average

    3m 49s
  • Periodic index

    3m 1s
  • Seasonal index

    5m 38s
  • Seasonal trendline formula

    3m 6s
  • Seasonal forecast

    3m 38s
  • Introduce challenge

    1m 24s
  • Challenge solution

    6m 30s
• 9. Multiple Regression Forecasting 9. Multiple Regression Forecasting

  • What is multiple regression?

    3m 33s
  • Preparing data for multiple regression in Excel

    5m 38s
  • Running a multiple regression in Excel

    3m 41s
  • Interpreting multiple regression output

    8m 48s
  • Developing a multi-variable equation to develop a forecast using regression output

    7m 28s
• Conclusion Conclusion

  • Continue exploring supply chain forecasting concepts

    55s