USA: +1 (725) 712-1730 
Sign in
Please help this is my opma hw. I also need the calc so i can do well on the test and i have to show my work. Thank you
Problem 3-20 In this problem, you are to tost the validity of your forocasting model. Hero aro the forocasts for a model you have been using and the actual demands that occurred 910 010 860 810 910 810 885 1,030 a. Use the method stated in the text to computo 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.) Sum of Week Forecast 910 910 060 810 810 1,030 叱。 760 860 010 b. Decide whether the forecasting model you have been using is giving reasonable results
Expert Answer
A.
| i | F | A | D= A-F | Di+RSFE(i-1) | Abs(D) | ABSi+Sabs(i-1) | (ABSi+Sabs(i-1))/(sum (i) |
| Week | Forecast | Actual | Deviation | RSFE | Absolute deviation | Sum of Abs Dev | MAD |
| 1 | 860 | 910 | 50 | 50 | 50 | 50 | 50 |
| 2 | 760 | 910 | 150 | 200 | 150 | 200 | 100 |
| 3 | 860 | 960 | 100 | 300 | 100 | 300 | 100 |
| 4 | 860 | 810 | -50 | 250 | 50 | 350 | 88 |
| 5 | 910 | 810 | -100 | 150 | 100 | 450 | 90 |
| 6 | 885 | 1030 | 145 | 295 | 145 | 595 | 99 |
On the first row the formulas are given.
B.
As MAD is very high this is not suitable
So, NO
