# Question & Answer: Please help this is my opma hw. I also need the calc so i can do well on the test and…..

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

A.

Don't use plagiarized sources. Get Your Custom Essay on
Question & Answer: Please help this is my opma hw. I also need the calc so i can do well on the test and…..
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS \$13/PAGE
 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