Question

2. For each of the months March through June, determine the 3-month forecast error rate, defined as 1 minus the absolute percentage error. For example, the forecast error rate for March's sales is found by dividing the absolute value of the forecast error for this month by the actual sales volume for the month. The forecast error for any month (e.g., March) is defined as the difference between the actual sales volume for the month and the sales volume for that month forecasted 3 months earlier (e.g., December). Also, indicate for each month whether the actual sales volume was above or below the forecasted volume generated three months earlier. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive. (Hin only one forecasted number for January—this is the forecast done in December. For February, there will be two done in December and a second done in January. For June, there will be six forecasts, one done in each of the months.) May June January 106 120 128 Forecast for Month of February March April 101 108 113 96 108 108 103 108 108 110 Month of Forecast December January February March April May | 123 105 123 100 113 90 108 108 < Required 1 Required 2 >

Answer 1

Answer 1)

Month of	Forecast for Month of
Forecast	January	February	March	April	May	June
December	106	101	108	113	120	128
January		96	108	108	110	123
February			103	108	105	123
March				108	100	113
April					90	108
May						108

Answer 2)

January February March April May June Actual sales 108 96 111 104 117 132 Forecast error rate - - 2.70 % 3.85 % 10.26 % 14.39 % Direction of error - - above   below above above

For part 2 plz provide the actual sales mentioned in the question. Leave in comment, so that i can help immediately