From the course: Excel: Market Research Strategies

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Seasonality in product demand

Seasonality in product demand - Microsoft Excel Tutorial

From the course: Excel: Market Research Strategies

Start my 1-month free trial

Seasonality in product demand

“

- [Instructor] A cornerstone of market research is establishing estimates for demand and for sales for a particular product. One basic tool that we can use to start down that path is a moving average. But the moving average is built around seasonality. I'm in the 01_04_Begin Excel sheet. Now what we have here is a sheet that's going to help us to establish the seasonality for a particular product. So, there's two tabs that we're interested in. The 01-04 Seasonality is our first tab, the one we've started on, and this is going to show us the number of units that we sell for a particular product in particular month. And then our 01-03 All Sales Sheet, which in essence looks just like the kind of information you'd get from any typical point of sale system or CRM that your company has, something like that. It essentially just shows us the customer name, customer type, product number, product names, et cetera,…

Contents