Use the following data to answer the next five questions. Monthly sales for the

Question

Use the following data to answer the next five questions. Monthly sales for the past nine periods along with the associated forecasts are shown in the following table. Month Sales Forecast 1 770 775 2 778 785 3 786 790 4 790 787 5 793 795 6 790 788 7 794 791 8 800798 9801799 Begin to compute the tracking signal starting in period five by updating the MAD with exponential smoothing. Use an alpha value of 0.25. Remember, you are co tracking signal, not a new forecast. mputing a MAD and Do not round intermediate calculations. Round all answers to two decimal points

Explanation / Answer

Answer:- Tracking signal for period 5= -3.571

Answer:-   Tracking signal for period 6=-3.391

Answer:-   Tracking signal for period 7=-2.692

Answer:-   Tracking signal for period 8=-2.783

Answer:-   Tracking signal for period 9=-3

Month Sales Forecast Error Absolute deviation Error MAD=Absolute deviation / number of month Tracking signal= sum of error/MAD 1 770 775.00 -5.00 5.00 -5 5.00 -1 2 778 785.00 -7.00 7.00 -12.00 6.00 -2 3 786 790.00 -4.00 4.00 -16.00 5.33 -3 4 790 787.00 3.00 3.00 -13.00 4.75 -2.73684 5 793 795.00 -2.00 2.00 -15.00 4.20 -3.57143 6 790 788.00 2.00 2.00 -13.00 3.83 -3.3913 7 794 791.00 3.00 3.00 -10.00 3.71 -2.69231 8 800 798.00 2.00 2.00 -8.00 2.88 -2.78261 9 801 799.00 2.00 2.00 -6.00 2.00 -3

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.