Please provide a worksheet with detailed answers to the


Please provide a worksheet with detailed answers to the following question:

The forecast generated by two forecasting methods and actual sales are as follows:

Month   Sales  Forecast1  Forecast2

      1        269     275             268

      2        289    266              287

      3        294    290              292

      4        278    284              298

      5        268    270             274

      6        269    268             270

      7         260   261             259

      8        275    271             275

Compute the MSE, the MAD, the MAPE, the RSFE, and the tracking signal for each forecasting method. Which method is better? Why?

Solution Preview :

Prepared by a verified Expert
Business Management: Please provide a worksheet with detailed answers to the
Reference No:- TGS02204635

Now Priced at $20 (50% Discount)

Recommended (93%)

Rated (4.5/5)