Compute the Simple Average for July, August, September Compute the 4 month simple moving average for...

  

Transcribed Image Text:

Compute the Simple Average for July, August, September Compute the 4 month simple moving average for July, Aug, Sep Compute the weighted moving average for July using the weights of 50%, 30% and 20%. The heaviest weights should be on the more recent months. WMA for July: 398 Apr May Jun Jul Compute the weighted moving average for August using the weights of 7, 5, and 3 with lighter weights on the more 417 WMA for Aug: May Jun July Aug Forecasting Sheet #1 2022 Month Demand Average SMA WMA Smoothing Jan. 240 Feb. 400 Mar 380 Apr 340 May 350 Jun 450 Jul 520 ? ? Aug 550 ? ? 2.2. ? ? Sep 680 ? ? Oct *** 2222. ? ? ? ? Compute the Simple Average for July, August, September Compute the 4 month simple moving average for July, Aug, Sep Compute the weighted moving average for July using the weights of 50%, 30% and 20%. The heaviest weights should be on the more recent months. WMA for July: 398 Apr May Jun Jul Compute the weighted moving average for August using the weights of 7, 5, and 3 with lighter weights on the more 417 WMA for Aug: May Jun July Aug Forecasting Sheet #1 2022 Month Demand Average SMA WMA Smoothing Jan. 240 Feb. 400 Mar 380 Apr 340 May 350 Jun 450 Jul 520 ? ? Aug 550 ? ? 2.2. ? ? Sep 680 ? ? Oct *** 2222. ? ? ? ?