Skip to main contentSkip to solution

The five month moving averages for the following data

Month (rthr^{th})434445464748495051
Actual Demand105106110110114121130128137

is:

Solution

✅ Correct Option: 1

A 5-month moving average takes any 5 consecutive months, adds their demands, and divides by 5. The calculation then slides forward by one month.

Month434445464748495051
Demand105106110110114121130128137

Months 43 to 47:

=105+106+110+110+1145= \dfrac{105 + 106 + 110 + 110 + 114}{5}

=5455= \dfrac{545}{5}

=109= 109


Months 44 to 48:

=106+110+110+114+1215= \dfrac{106 + 110 + 110 + 114 + 121}{5}

=5615= \dfrac{561}{5}

=112.2= 112.2


Months 45 to 49:

=110+110+114+121+1305= \dfrac{110 + 110 + 114 + 121 + 130}{5}

=5855= \dfrac{585}{5}

=117= 117


Months 46 to 50:

=110+114+121+130+1285= \dfrac{110 + 114 + 121 + 130 + 128}{5}

=6035= \dfrac{603}{5}

=120.6= 120.6


Months 47 to 51:

=114+121+130+128+1375= \dfrac{114 + 121 + 130 + 128 + 137}{5}

=6305= \dfrac{630}{5}

=126= 126


The five-month moving averages are: 109, 112.2, 117, 120.6, 126

Keyboard Shortcuts

  • Left arrow: Previous question
  • Right arrow: Next question
  • S key: Jump to solution
  • Q key: Jump to question