IDIS 644-Please fill appropriate tables below, considering the following data
June 7th, 2024
Please fill appropriate tables below, considering the following data and using moving average, weighted moving average (4 quarters; 0.4, 0.3, 0.2, and 0.1; where 0.4 is the weight for the most recent quarter) and exponential smoothing (?.30, F2015,Q1)Table 1. Historical DataYearQ1Q2Q3Q42014-15001100750201512001160124080020161050112013509202017?Obtain the sales forecasts from 2015 Q2 to 2016 Q4 using the 4-Quarter Moving Average, 4-Quarter weighted moving average, and exponential smoothing,Table 2. Forecasted values for historical dataYear-QuarterMoving AverageWeighted Moving AverageExponential Smoothing2015-Q22015-Q32015-Q42016-Q12016-Q22016-Q32016-Q4