Q4. The following table contains the number of complaints received in the depart
ID: 472060 • Letter: Q
Question
Q4. The following table contains the number of complaints received in the department store for first 6 months of operation:
Month
Jan
Feb
Mar
April
May
June
Complaints
36
45
81
90
108
144
a.Calculate the forecast for the month from April through June using 3month moving average?
b.What will be the forecast for the month of July using 3month moving average?
c.If actual sales for the month of July turned out to be 145, what will be the forecast for
August month using 3 month moving Average.
Month
Jan
Feb
Mar
April
May
June
Complaints
36
45
81
90
108
144
Explanation / Answer
a) April Forecast = Jan + Feb + Mar
=36 + 45 + 81 / 3
=54
May Forecast = Feb + march + April
= 45 + 81 + 90 / 3
=216 / 3
=72
June = March + April + may
=81 + 90 + 108
=279 / 3
=93
________________________________________________________________________________________
b) July complaints Moving average =90+ 108 + 144 +
=342 / 3 = 114
____________________________________________________________________________________
c) May + June + July / 3
= 108 + 144 + 145
=397 / 3
=132.33
_____________________________________________________________________________________
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.