From the course: Excel: Market Research Strategies
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Demand forecasting caveats - Microsoft Excel Tutorial
From the course: Excel: Market Research Strategies
Demand forecasting caveats
- [Narrator] All forecasts or estimates of demand and market potential are wrong. A forecast will never be 100% precisely accurate in any kind of meaningful, real-world application. Knowing that though, we do need to be able to understand when our forecast is likely to be more accurate or less accurate. I'm in the zero one 10 begin file. Now, we're looking at the zero one underscore 10 caveat sheet. What we see here is an actual real-world set of unit sales, along with revenues, over a 12-month period for a particular hypothetical product. Now, we forecasted, based on this same data, that for a particular month, say June, we might have sales of 29 units. Well, if we look at the real-world figure of 69 versus the unit sales forecast of 29, I might say, well, what's going on here? These seem pretty far apart, and you're absolutely right. There's a few reasons for that, and you want to be aware of this.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
(Locked)
What is product demand?3m 10s
-
(Locked)
Measuring product demand4m 4s
-
(Locked)
Organizing sales data5m 3s
-
(Locked)
Seasonality in product demand5m 56s
-
(Locked)
Moving averages and product demand4m 34s
-
(Locked)
Price elasticity and product demand5m 57s
-
(Locked)
Predicting demand for a new product3m 11s
-
(Locked)
Regressions for forecasting5m 12s
-
Using Excel for regressions4m 55s
-
(Locked)
Demand forecasting caveats3m 17s
-
(Locked)
-
-
-
-