Question

In: Statistics and Probability

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:


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 a​six-quarter period. Quarter   Price Q1...
3. The following data show the average Home Price Index over a​six-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 as​needed.) 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?
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...
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...
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.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT