Question: For the data below, based on a 3 period moving average forecasting method calculate the following: Year Quarter Sales 1 1 154 2 130 3

For the data below, based on a 3 period moving average forecasting method calculate the following:

Year Quarter Sales
1 1 154
2 130
3 186
4 182
2 1 145
2 118
3 145
4 120
3 1 114
2 149
3 183
4 103
4 1 132
2 186
3 182
4 105
5 1 178
2 180
3 153
4 128

1) Calculate the mean absolute error. ANSWER TO 2 DECIMAL PLACES

2) Calculate the mean square error. ANSWER TO 2 DECIMAL PLACES

3) Calculate the absolute percentage error. ANSWER AS A PERCENT TO 2 DECIMAL PLACES...INCLUDE UNITS (I.E. THE PERCENT SIGN)

4) Predict the the number of sales for the first quarter of year 6. ANSWER TO 0 DECIMAL PLACES

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!