Purchase Solution

Computation of Seasonal Indices

Not what you're looking for?

Ask Custom Question

Ratio to moving average method

An analyst wants to use the ratio-to-moving average method to forecast a company's sales for the next few quarters. Beginning in Quarter 4 of 2006 , the analyst collects the following sales data (in millions of dollars).
Estimate the seasonal index associated with Quarter 1 . Round your answer to at least three decimal places.

Tme Quarter Sales Moving Average
1 4 113.2

2 1 211
137.5
3 2 132
142.4
4 3 93.8
137.025
5 4 132.8
135.4
6 1 189.5
136.225
7 2 125.5
136.825
8 3 97.1
154.35
9 4 135.2
156.2
10 1 259.6
154.6
11 2 132.9

12 3 90.7

Attachments
Purchase this Solution
Solution Summary

In this problem the computation of seasonal indices by using ratio to moving average method is illustrated. The general procedure is described and it is illustrated by using the given problem. The computation is provided in an excel sheet also, so that students can easily use it.

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Holt's seasonal forecast with multiplicative seasonal indices

    In this model, beta is twice the value of alpha, the seasonal indices average to 1 and the seasonal factors for quarter 1 and quarter 3 are both equal to 1.

  • Time series forecasting problem

    What are the values of the seasonal indices for decomposition? Interpret these values. Do they make sense with respect to the graph in question 1? Following are the values of seasonal indices.

  • Statistics forecasting with dependent and independent variables

    After the quarterly sales data for both the years have been calculated, we shall have to calculate the seasonal indices.

  • Quantitative Analysis

    Seasonal indices for the four quarters have been found to be 1.30, 0.90, 0.70, and 1.10, respectively. Compute a seasonalized or adjusted sales forecast.

  • Forecasting problem:Seasonality incorporated

    What fraction of the variability in revenue is accounted for by the trend alone? B) Find the quarterly seasonal indices for the revenues in 1982 dollars, and use them to deseasonalize those revenues.

  • Time Series for Apple, Inc

    Copy of the data. Calculation of seasonal indices. Calculation of Trend Line Graph of original data and the trend line Graph of Seasonal indices Graph of Predicted and actual values vs. time."

  • Time series analysis

    For example against time period 3 we place the average of 141.275 and 138.075. The calculation of the seasonal index is given in xl file. To determine seasonal indices using ratio to moving average.

  • Forecast

    This solution is comprised of detailed analysis and step-by-step calculations of various Forecast Techniques like Exponentially Smoothed Forecast, Trend Projection, Seasonal Indices etc. in EXCEL.

  • Time Series Graphing

    Determine adjusted seasonal indices for each of the four quarters. 3. Do seasonal forces significantly affect the sales of farming equipment? Comment 4. Derive a least-squares trend line for the sales of farming equipment. 5.

View More Related Solutions