Find the four seasonal indexes for the time

Assignment Help Management Theories

Reference no: EM131125290

The daily number of calls received by a call center over the last three weeks is reported by the Assignment 2.xlsx spreadsheet on Blackboard. The daily data is further broken down into four time windows. Please,

(i) Graph the 3×7×4 = 84 raw data points, and describe what you see using the concepts of trend, seasonality and randomness/noise.

(ii) Find the four seasonal indexes for the time of the day, and the seven seasonal indexes for the days of the week. Briefly describe what they represent and how they can be used in a forecast.

(iii) Next to the raw data point column, create a second column where each data point is divided by its corresponding "time of the day" seasonal index, and create a third column where each data point is divided by its corresponding "time of the day" indexand"day of the week" index. Graph the four columns and describe what you see. What does dividing a data point by a seasonal index do?

(iv) On the raw data point column, use a non-weighted 10-period moving average to forecast the number of calls for the next two days. Try to use the seasonal indexes found in (ii) to account for the "time window" and "day of the week" seasonal factors.

(v) Suppose that over the last two weeks you have been testing a non-weighted 10-period moving average and a non-weighted 4-period moving average. For the future, you want to choose whichever model has performed better over such testing period. Please, make your choice and motivate it using the forecasting errors as a guidance.

Reference no: EM131125290

Questions Cloud

Describe the life cycle of is the neurotransmitter : A 34-year-old woman with a long-standing history of seizure disorder presents to her neurologist with difficulty walking and coordination. Describe the life cycle of is the neurotransmitter for Purkinje cells

What is the final volume in liters of the gas : what is the final volume in liters of the gas at 39°C and a pressure of 747 mmHg , if the amount of CO2 remains the same.

Describe chemistry that might account for your preferences : Please select one example each of a food you like and a food you dislike and describe the chemistry that might account for your preferences. You may be surprised to learn that there are certain chemicals present in foods that might be found other ..

Briefly describe the situations in which the gross profit : The merchandise inventory was destroyed by fire on October 11. The following data were obtained from the accounting records:

Find the four seasonal indexes for the time : The daily number of calls received by a call center over the last three weeks is reported by the Assignment 2.xlsx spreadsheet on Blackboard. The daily data is further broken down into four time windows. Please,

What liability does whispering willows have in this case : Read the case study titled "Such a Nice Young Man", Answer the questions listed below: What liability does Whispering Willows have in this case

Taxes consequences of gifting a certain percentage : Discuss Taxes consequences of gifting a certain percentage - how do you protect your money, minimize taxes, and plan for the future.

Demonstrate your knowledge of the science of cooking : he final assignment in this course is intended to give you an opportunity to pursue something that interests you further and to demonstrate your knowledge of the science of cooking.

Impacted by the external environment : (b) How has J Crew been impacted by the external environment (analyze EACH force in detail: technology, economy, competitive, government, and social/cultural/natural environment). Provide references

User Account

All Pages