Using historic sales data create a monthly forecast using classical decomposition that is based on regression and
Fantastic news! We've Found the answer you've been seeking!
Question:
Using historic sales data create a monthly forecast using classical decomposition that is based on regression and seasonality. We are creating a monthly forecast not quarterly.
For help, review Module 4 Excel Exercise. Please note that the Module 4 Exercise is based on quarterly data. Kiana is creating a monthly forecast based on monthly data. You will create a seasonal Index for each month. Therefore, you will have seasonal indexes for Jan, Feb, March, etc. Remember the total of the month’s seasonal indexes for a year should add up to 12. You will still use a three-year average for your final seasonal index.
Related Book For
Chemistry The Central Science
ISBN: 978-0321696724
12th edition
Authors: Theodore Brown, Eugene LeMay, Bruce Bursten, Catherine Murphy, Patrick Woodward
Posted Date: