Question: please help Question 6 (4 points) Use a 3-month weighted moving average to forecast the sales for the months May through December. Use weights of



Question 6 (4 points) Use a 3-month weighted moving average to forecast the sales for the months May through December. Use weights of (4/8), (3/8), and (1/8), giving more weight to more recent data. Match the forecast to the month. 5125 4350 6687.5 3862.50 4625 5600 5875 1. May 2. June 3. July 4. August 5. September 6. October 7. November 8. December Use exponential smoothing with to forecast the sales for the months February through December. Assume that the initial forecast for January was 3200 and =0.6. Match the month with the forecast amount. 3200 5846.98 1. February 3871 2. March 3272 3. April 4. May 5361.41 5. June 6503.52 6. July 4368.61 3528.80 4664.56 \begin{tabular}{|l|r|} \hline Month & Sales \\ \hline January & 3000 \\ \hline February & 3400 \\ \hline March & 3700 \\ \hline April & 4100 \\ \hline May & 4700 \\ \hline June & 5700 \\ \hline July & 6300 \\ \hline August & 7200 \\ \hline September & 6400 \\ \hline October & 4600 \\ \hline November & 4200 \\ \hline December & 3900 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
