How many seasons are in each repeating cycle

Assignment Help Advanced Statistics

Reference no: EM13751982

Project: Forecasting

Eli Orchid has designed a new pharmaceutical product, Orchid Relief that improves night sleep. (We will revisit this company in future mini-projects as well). Before mass production of the product, Eli Orchid has market tested Orchid Relief in only Orange County over the past 8 weeks. The weekly demand is recorded. Eli Orchid is now trying to use the sales pattern over the past 8 weeks to predict sales in US for the upcoming few months.

78_daily demand.png

After reviewing the data, the marketing manager of Eli Orchid believes that there is a repeating pattern in Orchid Relief use likely due to changes in sleeping pattern of customers on different days.

1) How many seasons are in each repeating cycle?
a) 3
b) 5
c) 7
d) 12

2) To make a forecast of day 60, what is the seasonal factor for this day?
a. 90.58%
b. 98.02%
c. 99.05%
d. 100%
e. 121.89%

3) Looking at the deseasonalized time series, what is the slope of a linear time trend in the deseasonalized data?
a. 339.29
b. 351.08
c. 4.018× 10-7
d. 0.6143
e. 1.0356

4) Can we conclude at 5% significance level that there is a significant linear time trend in the deseasonalized time series?
a. Yes
b. No
c. Cannot be determined

5) Using the regression method on the deseasonalized time series, what is a deseasonalized forecast for day 60?
a. 343.43
b. 353.54
c. 387.94
d. 401.42

6) Taking seasonality into account, what is a forecast for day 60?
a. 387.94
b. 351.40
c. 353.54
d. 363.61

7) What is a deseasonalized forecast for day 57 using the 3-day weighted moving average with weights 60%, 30% and 10%?
a. 378.31
b. 391.56
c. 384.96
d. 384.77

8) What is a deseasonalized forecast for day 60 using the 3-day weighted moving average with weights 60%, 30% and 10%?
a. 391.56
b. 378.31
c. 392.86
d. 384.96

9) What is a deseasonalized forecast for day 57 using the exponential smoothing method with smoothing constant 0.7 (Hint: Use deseasonalized data on day 53 as your forecast for day 54)?
a. 384.77
b. 384.19
c. 386.72
d. 393.28
e. 380.36

10) What is a deseasonalized forecast for day 60 using the exponential smoothing method with smoothing constant 0.7?
a. 384.77
b. 384.19
c. 386.72
d. 393.28
e. 380.36

11) Using the deseasonalized forecast of question 8 and the method of incorporating for seasonality that the Chief Marketing Officer suggested, what is a seasonal forecast for day 60?
a. 391.56
b. 384.19
c. 354.67
d. 320.51

Attachment:- data.xlsx

Attachment:- forecast.xls

Reference no: EM13751982

Questions Cloud

E-commerce in healthcare : You have been asked by the executive committee of your healthcare facility to write a report on the strategic implications of information technology for your firm in the next three years, E-commerce in healthcare

What is the overall reliability of the systern : lf the backup computer must be tivated by a switch in the event that the first computer fails, and the switch has a reliability of .98, what is the overall reliability of the systern? Both the switch and the backup computer must function in oder f..

Obtain a trace file of the tcp handshake process. : Obtain a trace file of the TCP handshake process and Explore the preferences and configuration options in Wireshark. Share your findings with the class

What is the impact on gdp : What is the impact on GDP if consumer spending increases? Would the answer be different if the consumer spending was directed toward foreign goods?

How many seasons are in each repeating cycle : How many seasons are in each repeating cycle and Looking at the deseasonalized time series, what is the slope of a linear time trend in the deseasonalized data

Length of the days sales in inventory : Sow Tire, Inc., has sales of $1,441,000 and cost of goods sold of $1,241,000. The firm had a beginning inventory of $96,100 and an ending inventory of $77,500. What is the length of the days' sales in inventory?

Discuss two reasons why jackson pollocks style of painting : Discuss a minimum of two reasons why Jackson Pollock's style of painting, as exemplified by Convergence, is considered an important, innovative development in the history of painting.

Variance of return on the well diversified portfolio : Question 1: Consider the one factor APT. The variance of the factor portfolio is 6%. The beta of a well diversified portfolio on the factor is 1.1. The variance of return on the well diversified portfolio is approximately

Discuss the effectiveness and the limitations of cognitive : Discuss the influence one component has on the others - Discuss the effectiveness and the limitations of cognitive behavioral intervention?

User Account

All Pages