BA 314 Forecasting WorksheetName:Use Excel to calculate the values to fill in the empty boxes. Feel free to add additional tables and calculations asneeded. Please use the assignment 1 discussion board to ask questions. Once completed, save this file andupload it in Canvas.Historical Demand Data 2013 to 2017:The table reproduced below is the demand data for a company (aggregated) for the previous five years.20132014201520162017Q1963215034161171556516470Q22224526824241691915132858Q31164611314145051139219278Q4AnnualDemandAverageQuarterlyDemand113551069811176106131393454878638706596756721825401372015968164921418020635Forecasting Using Moving Average MethodsUsing the historical demand data above, you are to determine the total annual demand forecast for 2017 an the three-period moving average forecasting method the three-period weighted moving average method with weights of .5, .4, and .1Enter your forecast results in the following tables.20172017AnnualAnnualForecastForecastUsing aUsing aWeightedMovingMovingAverageAverage62,18661,1342018AnnualForecastUsing aMovingAverage68,4092018AnnualForecastUsing aWeightedMovingAverage70,555Calculate a Time Series Linear equation using the all of the above demand data:Using the historical demand data for 2013 through 2017, create a linear equation with the year as the indep(Excel can be quite useful here, co ...
To Order an Original Plagiarism Free Paper on the Same Topic Click Here
Other samples, services and questions:
When you use PaperHelp, you save one valuable — TIME
You can spend it for more important things than paper writing.
