Can you show me how to solve this problem? In this problem, you are to test the validity of your for

Can you show me how to solve this problem?

In this problem, you are to test the validity of your forecasting model. Here are the forecasts for a model you have been using and the actual demands that occurred:

WEEK FORECAST ACTUAL
1 770 895
2 845 995
3 945 1,045
4 945 895
5 995 895
6 970 1,050

a. Use the method stated in the text to compute the MAD and tracking signal for each week. (Negative values should be indicated by a minus sign. Round your “Tracking Signal” to 1 decimal place and all other answers to the nearest whole number.)

Week Forecast Actual Deviation RSFE Absolute
Deviation
Sum of
Absolute
Deviation
MAD TS
1 770 895
2 845 995
3 945 1,045
4 945 895
5 995 895
6 970 1,050

b. Decide whether the forecasting model you have been using is giving reasonable results.

The forecasting model is acceptable
The forecasting model is unacceptable

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.