Question

In: Accounting

Q31. A customer comment phone line is staffed from 8:00 a.m. to 4:30 p.m. five days...

Q31. A customer comment phone line is staffed from 8:00 a.m. to 4:30 p.m. five days a week. Records are available that show the number of calls received every day for the last five weeks. Excel Data can be found in Data Tab/Sheet

a. Show a time series data plot of data and describe your observation in terms of pattern, trend, etc.

b. Use a dummy variable method forecasting method to produce Week 6’s Daily and total calls for Week 6.

Week Day Number of Calls
1 M 31
T 15
W 19
TH 18
F 26
2 M 28
T 13
W 17
TH 17
F 29
3 M 35
T 18
W 18
TH 16
F 24
4 M 30
T 16
W 19
TH 21
F 27
5 M 29
T 14
W 21
TH 20
F 28

Solutions

Expert Solution

Data Table

Ans-(a)

Observations:

  • Peaks happen mostly on first day of the week that is Monday
  • First three days there is declining trend
  • Last two days of the week again there is upward trend

Ans-(b)

Data table for Forecast

Data Forecast setting in excel

Daily Forecasted Calls for week - 6

5 week actual plus 6th week forecast chart:

ekkarill92 answered 2 years ago
Next > < Previous

Related Solutions

A pub opens its door for business at 6:00 PM. From 6:00 P.M. to 8:00 P.M....
A pub opens its door for business at 6:00 PM. From 6:00 P.M. to 8:00 P.M. 50 smokers in the pub smoke 2 cigarettes per hour and each cigarette emits 4mg formaldehyde. Fresh air is introduced into the pub @ 1,000 m3/hr. At 8:00 P.M. the number of smokers in the pub increases from 50 to 75 and as a result, the fresh air flow rate is increased from 1,000 m3/hr to 1,500 m3/hr to flush out the stale air....
A pub opens its door for business at 6:00 PM. From 6:00 P.M. to 8:00 P.M....
A pub opens its door for business at 6:00 PM. From 6:00 P.M. to 8:00 P.M. 50 smokers in the pub smoke 2 cigarettes per hour and each cigarette emits 4mg formaldehyde. Fresh air is introduced into the pub @ 1,000 m3/hr. At 8:00 P.M. the number of smokers in the pub increases from 50 to 75 and as a result, the fresh air flow rate is increased from 1,000 m3/hr to 1,500 m3/hr to flush out the stale air....
A toll-free phone number is available from 9 a.m. to 9 p.m. for your customers to...
A toll-free phone number is available from 9 a.m. to 9 p.m. for your customers to register complaints about a product purchased from your company. Past history indicates that an average of 1.0 calls are received per minute. Complete parts (a)through (c). A.    what is the probability that during a 1 min period zero phone calls will be received? B.    what is the probability that during a 1 min period three or more phone calls will be received? C.    what is the maximum...
A toll-free phone number is available from 9 a.m. to 9 p.m. to customers who want...
A toll-free phone number is available from 9 a.m. to 9 p.m. to customers who want to register a complaint about a product purchased from your company. Past history indicates that, on average, 0.4 calls are received per hour. (a) Decide what would be an appropriate distribution to describe the process [2] of people making complaints. Give a justification of your answer, in at most one sentence. (b) Using the distribution in (a), find the following probabilities: (i) the probability...
A Problem with a phone line that prevents a customer from receiving or making calls is...
A Problem with a phone line that prevents a customer from receiving or making calls is upsetting to both the customer and the telecommunications company. Samples of 20 problems reported to two different offices of a telecommunications company and the time to clear those problems (in minutes) from the customers’ lines. Data summary table: Problem 1 data Mean 1 2.21 Mean 2 2.01 Std. Dev. 1 1.72 Std. Dev. 2 1.89 Using the output below answer the answer the flowing...
A problem with a phone line that prevents a customer from receiving or making calls is...
A problem with a phone line that prevents a customer from receiving or making calls is upsetting to both the customer and the telecommunications company. The file Phone contains samples of 20 problems reported to two different offices of a telecommunications company and the time to clear these problems (in minutes) from the customers’ lines: Central Office I Time to Clear Problems (minutes) 1.48 1.75 0.78 2.85 0.52 1.60 4.15 3.97 1.48 3.10 1.02 0.53 0.93 1.60 0.80 1.05 6.32...
A problem with a phone line that prevents a customer from receiving or making calls is...
A problem with a phone line that prevents a customer from receiving or making calls is upsetting to both the customer and the telecommunications company. The file Phone contains samples of 20 problems reported to two different offices of a telecommunications company and the time to clear these problems (in minutes) from the customers' lines: Central Office I Time to Clear Problems (minutes) 1.48 1.75 0.78 2.85 0.52 1.60 4.15 3.97 1.48 3.10 1.02 0.53 0.93 1.60 0.80 1.05 6.32...
A problem with a phone line that prevents a customer from receiving or making calls is...
A problem with a phone line that prevents a customer from receiving or making calls is upsetting to both the customer and the telecommunications company. Table 4 contains samples of 20 problems reported to two different offices of a telecommunications company and the time to clear these problems (in minutes) from the customers’ lines:   Central Office I Time to Clear Problems (minutes): 1.48 1.75 0.78 2.85 0.52 1.60 4.15 3.97 1.48 3.10 1.02 0.53 0.93 1.60 0.80 1.05 6.32 3.93...
A problem with a phone line that prevents a customer from receiving or making calls is...
A problem with a phone line that prevents a customer from receiving or making calls is upsetting to both the customer and the telecommunications company. The following data sets contain samples I have 20 problems reported to two different offices of a telecommunications company and the time to clear these problems (in minutes) from the customers lines: Central Office 1 time to clear problems (minutes): 1.48 1.75 0.78 2.85 0.52 1.60 4.15 3.97 1.48 3.10 1.02 0.53 0.93 1.60 0.80...
A problem with a phone line that prevents a customer from receiving or making calls is...
A problem with a phone line that prevents a customer from receiving or making calls is upsetting to both the customer and the telecommunications company. The following data sets contain samples I have 20 problems reported to two different offices of a telecommunications company and the time to clear these problems (in minutes) from the customers lines: Central Office 1 time to clear problems (minutes): 1.48 1.75 0.78 2.85 0.52 1.60 4.15 3.97 1.48 3.10 1.02 0.53 0.93 1.60 0.80...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT