Problem 3 The manager of a call center recorded the daily volume of calls receiv
ID: 3121028 • Letter: P
Question
Problem 3
The manager of a call center recorded the daily volume of calls received for 21 days (Jan 19 was Tuesday) and wants to forecast call volume for each day of the coming week (Feb 9-15). The call center operates 7 days a week. Data is provided below. Check if the data displays trend and/or seasonality. Then provide a forecast for each day using an appropriate forecasting method.
Date
Calls
Date
Calls
Date
Calls
Jan 19
67
Jan 26
60
Feb 2
64
Jan 20
75
Jan 27
73
Feb 3
76
Jan 21
82
Jan 28
85
Feb 4
87
Jan 22
98
Jan 29
99
Feb 5
96
Jan 23
90
Jan 30
86
Feb 6
88
Jan 24
36
Jan 31
40
Feb 7
44
Jan 25
55
Feb 1
52
Feb 8
50
Date
Calls
Date
Calls
Date
Calls
Jan 19
67
Jan 26
60
Feb 2
64
Jan 20
75
Jan 27
73
Feb 3
76
Jan 21
82
Jan 28
85
Feb 4
87
Jan 22
98
Jan 29
99
Feb 5
96
Jan 23
90
Jan 30
86
Feb 6
88
Jan 24
36
Jan 31
40
Feb 7
44
Jan 25
55
Feb 1
52
Feb 8
50
Explanation / Answer
We can use an either Point Estimate Method or Averaging Approaches.
Here the most appropriate method is Averaging Approaches.
So from the previous given data we can identify the following week forecasting.
Hence, for 9th feb-
Calculating
(19th Jan - 67 + 26th jan - 60 + 2nd Feb - 64. ) ÷ 3 = 9th feb - 63
(20th Jan - 75 + 27th jan - 73 + 3rd feb - 76) ÷ 3 = 10th feb- 75
(21st Jan - 82 + 28th Jan - 85 + 4th feb - 87 ) ÷ 3 = 11 th feb - 85
(22nd jan - 98 + 29th Jan - 99 + 5th feb - 96 ) ÷3 = 12th feb - 98
(23rd jan - 90 + 30th jan - 86 + 6th feb - 88) ÷ 3 = 13th feb - 88
(24th jan - 36 + 31st jan - 40 + 7th feb - 44) ÷ 3 = 14th feb - 40
(25th jan - 55 + 1st feb - 52 + 8th feb - 50 ) ÷ 3 = 15th feb - 53
This is the appropriate and approximate approach to this question.
Thank You
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.