Question: A retail store sells space heaters. Sales data for four years is provided in the tab Space Heaters. Plot the time series. Describe the time
A retail store sells space heaters. Sales data for four years is provided in the tab Space Heaters. Plot the time series. Describe the time series in a few sentences. (4 pts) Calculate the seasonal index for each quarter. What are the implications of these indexes? (8 pts) Calculate the trend equation for this data. Explain what the slope and intercept mean in this context. (8 pts) Using the multiplicative decomposition method calculate forecasts for each quarter of Year 5. (10 pts) Year Quarter Sales 1 1 810 1 2 481 1 3 732 1 4 436 2 1 1025 2 2 781 2 3 877 2 4 545 3 1 1217 3 2 940 3 3 1190 3 4 727 4 1 1399 4 2 1200 4 3 1236 4 4 853
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
