Using historical sales data create a monthly forecast using classical decomposition based on regression and seasonality . We are creating a monthly forecast not quarterly . The data set is your historical sales . Please set your Excel spreadsheet to show 4 decimal points . This will help when you are entering the data into the Csepub Quiz . This part of the project is completed on the Excel Worksheet : and Regression . For help , review Module 4 Excel Exercise . Please note that the Module 4 Exercise is basedon 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 .

Do not need to fill in these spaces