Determine the magnitude of the seasonal ratio of the average quarter centered at that time period....

Determine the magnitude of the seasonal ratio of the average quarter centered at that time period.

Quarterly Sales ($1,000,000s) for Turner Industries
Quarter	Year 1	Year 2	Year 3	Average
1	108	116	123	115.67
2	125	134	142	133.67
3	150	159	168	159
4	141	152	165	152.67
Average	131	140.25	149.5	140.25

Solutions

Expert Solution

				Centered
				Moving	Ratio to	Seasonal
t	Year	Quarter	Data	Average	CMA	Indexes
1	1	1	108			0.849
2	1	2	125			0.963
3	1	3	150	132.000	1.136	1.131
4	1	4	141	134.125	1.051	1.057
5	2	1	116	136.375	0.851	0.849
6	2	2	134	138.875	0.965	0.963
7	2	3	159	141.125	1.127	1.131
8	2	4	152	143.000	1.063	1.057
9	3	1	123	145.125	0.848	0.849
10	3	2	142	147.875	0.960	0.963
11	3	3	168			1.131
12	3	4	165			1.057


	Calculation of Seasonal Indexes
	1	2	3	4
1			1.136	1.051
2	0.851	0.965	1.127	1.063
3	0.848	0.960
mean:	0.849	0.963	1.132	1.057	4.000
adjusted:	0.849	0.963	1.131	1.057	4.000

The graph is:

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Show the four-quarter and centered moving average values for this time series (to 3 decimals if necessary).

Quarter Year 1 Year 2 Year 3 1 4 6 8 2 2 4 7 3 3 5 6 4 5 7 8 Show the four-quarter and centered moving average values for this time series (to 3 decimals if necessary). Year Quarter Time Series Value Four-Quarter Moving Average Centered Moving Average 1 1 4 2 2 3 3 4 5 2 1 6 2 4 3 5 4 7 3 1 8 2 7 3 6 4 8 Compute seasonal...

Refer to Revenue Data Excel File. The 4 QTR Centered Moving Average for the 2nd quarter...

Refer to Revenue Data Excel File. The 4 QTR Centered Moving Average for the 2nd quarter of 2017 is: Select one: a. 222.125 b. 333.875 c. 269.250 d. 243.625 Year QTR Revenue (in $1000) 2015 1 205 2 400 3 200 4 229 2016 1 236 2 219 3 211 4 200 2017 1 280 2 275 3 261 4 322 2018 1 500 2 230 3 310 4 400 2019 1 325 2 241 3 379 4 316

3. The following data show the average Home Price Index over asix-quarter period. Quarter Price Q1...

3. The following data show the average Home Price Index over asix-quarter period. Quarter Price Q1 2017 185.9 Q2 2017 190.1 Q3 2017 196.1 Q4 2017 196.1 Q1 2018 198.3 Q2 2018 203.7 a. Forecast the price index for Q3 2018 using a two-period simple moving average. (Round to two decimal places asneeded.) b. Calculate the MAD for the forecast in part a. (Round to two decimal places as needed.) c. Forecast the price index for Q3 2018 using a...

The average collection period ratio is defined as shown below: Accounts Receivable / (sales/ 365) It...

The average collection period ratio is defined as shown below: Accounts Receivable / (sales/ 365) It shows how many days, on average, it takes to collect your receivables. If your average collection period was 30 days last year and it is now 45 days, what does that imply? What is happening to your cash position? What are some things you might do to reduce your average collection period?

Average Rate of Return, The expected period of time that will elapse between the date of...

Average Rate of Return, The expected period of time that will elapse between the date of a capital expenditure and the complete recovery in cash (or equivalent) of the amount invested.Cash Payback Period, A method of analysis of proposed capital investments that focuses on the present value of the cash flows expected from the investments.Net Present Value Method for a Service Company Spanish Peaks Railroad Inc. is considering acquiring equipment at a cost of $110,000. The equipment has an estimated...

Determine the payback period using the accumulated and average cash flows approaches.

Baird Company has an opportunity to purchase a forklift to use in its heavy equipment rental business. The forklift would be leased on an annual basis during its first two years of operation. Thereafter, it would be leased to the general public on demand. Baird would sell it at the end of the fifth year of its useful life. The expected cash inflows and outflows follow: Year Nature of Item Cash Inflow Cash Outflow Year 1 Purchase price...

For the given quarterly sales data, a) calculate seasonal indices for each quarter, b) the year...

For the given quarterly sales data, a) calculate seasonal indices for each quarter, b) the year 4 annual forecast based on a linear regression trend forecasting method, c) the seasonally adjusted trend based quarterly forecasts for that 4th year, d) the year 4 annual forecast based on the Naive forecasting method, and e) the seasonally adjusted Naive based quarterly forecast for that 4th year. Quarter: Year 1 Year 2 Year 3 1 2 3 7 2 6 10 18 3...

Forecast the advertising revenue for each quarter in 2011 using seasonal dummy variables and a best...

Forecast the advertising revenue for each quarter in 2011 using seasonal dummy variables and a best subsets regression. (Let the first dummy variable be equal to 1 for Quarter 2 and so on, following the order of the seasonal categories in the given table. 2008 1 540 2 516 3 488 4 500 2009 quarter Rev. in Millions 1 433 2 407 3 402 4 460 2010 quarters rev. in millions 1 347 2 297 3 292 4 332 A)...

A manager of the company would like to determine average delivery time of the products. A...

A manager of the company would like to determine average delivery time of the products. A sample of 25 customers is taken. The average delivery time in the sample was four days with a standard deviation of 1.2 days. Suppose the delivery times are normally distributed. Provide a 95 % confidence interval for the mean delivery time. The manager claims that the average delivery time of their products does not exceed 3 days. Write the null and alternative hypothesis regarding...

A scooter company wants to determine the average amount of time it takes an adult to...

A scooter company wants to determine the average amount of time it takes an adult to assemble an “easy to assemble” scooter. A sample of 49 times yielded an average time of 18.15 minutes. Assume that the assembly times are normally distributed and the population has a standard deviation of 5.39 minutes. a) Give a point estimate for the population mean that the sample of data is taken from. b) Find the 96% confidence interval for the mean assembly time.

Subjects