Week Calls Week Calls 1 2 3 4 5 6 7 8 9 10 11 12 50 34 25 39 45 34 21 32 36 19 1

Question

Week Calls Week Calls 1 2 3 4 5 6 7 8 9 10 11 12 50 34 25 39 45 34 21 32 36 19 16 39 13 14 15 16 17 18 19 20 21 22 23 24 54 35 26 56 54 41 34 60 75 51 41 65 een de veo ed and are provided 5 a) Assuming a starting forecast o 50.00 for week 1 with a smoothing constant of O 30, the forecasts or weeks 2 through 24 ha below. Continuing with the given information, the forecast for week 25 is (round your response to two decimal places) 10 12 Week Calls Week Calls 29.49 36.84 36.29 33.20 40.04 44.23 4326 40.48 46.34 54.94 53.76 49.93 54.45 50.00 50.00 45.20 39.14 39.10 40.87 38.81 33.47 33.03 33.92 29.44 2541 en 13 14 15 16 17 18 19 20 21 22 23 24 25 b) Assuming a start ng forecast of 5000 for week 1 with a smoothing constant of 0 5, the recasts or weeks 2 rough 24 below. Continuing with the given information, the forecast for week 25 is (round your response to two decimal places) ave been do eo ed and are pro ide 12 3 4 5 67 89 10 13 14 15 16 17 8 19 2021 22 23 24 11 12 Week Calls Week 50.00 50.00 3960 30.11 35.89 4181 36.73 26.51 3008 3393 24.23 18.88 Calls 31.96 46.29 38.95 30.53 47.09 51.58 44.70 37.75 5221 6702 5661 46.46 58.51 o ju c) For the forecast provided (24 weeks) with a - 0.30, MAD calls (round your response to two decimal places).

Explanation / Answer

Answer A:- Exponential smoothing forecasting = Ft = Ft-1 +(At-1-Ft-1)

In the question, Ft-1 =49.93 At-1=65, =0.3

Exponential smoothing forecasting = Ft = 49.93 +0.3(65-49.93) =54.451

Answer B:- Exponential smoothing forecasting = Ft = Ft-1 +(At-1-Ft-1)

In the question, Ft-1 =46.46 At-1=65, =0.65

Exponential smoothing forecasting = Ft = 46.46 +0.65(65-46.46) =58.511

Answer C:-

MAD =Sum of absolute deviation/number of forecast

MAD=279.15/24

MAD= 11.63

I REQUEST YOU TO KINDLY RATE THE ANSWER AS THUMBS UP. THANKS, A LOT.

Month Actual Call Forecast Calls Error Absolute deviation 1 50 50 0 0 2 34 50 -16 16 3 25 45.2 -20.2 20.2 4 39 39.14 -0.14 0.14 5 45 39.1 5.9 5.9 6 34 40.87 -6.87 6.87 7 21 38.81 -17.81 17.81 8 32 33.47 -1.47 1.47 9 36 33.03 2.97 2.97 10 19 33.92 -14.92 14.92 11 16 29.44 -13.44 13.44 12 39 25.41 13.59 13.59 13 54 29.49 24.51 24.51 14 35 36.84 -1.84 1.84 15 26 36.29 -10.29 10.29 16 56 33.2 22.8 22.8 17 54 40.04 13.96 13.96 18 41 44.23 -3.23 3.23 19 34 43.26 -9.26 9.26 20 60 40.48 19.52 19.52 21 75 46.34 28.66 28.66 22 51 54.94 -3.94 3.94 23 41 53.76 -12.76 12.76 24 65 49.93 15.07 15.07 Sum 279.15

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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