Purchase Solution

Ratio to Moving Average Method

Not what you're looking for?

Ask Custom Question

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 2 of 2005 , the analyst collects the following sales data (in millions of dollars).
Estimate the seasonal index associated with Quarter 4. Round your answer to at least three decimal places.

keywords: averages, moving-average

Attachments
Purchase this Solution
Solution Summary

The solution provides step by step method for the calculation of seasonal index using ratio to moving average method. Formula for the calculation and Interpretations of the results are also included. Interactive excel sheet is included. The user can edit the inputs and obtain the complete results for a new set of data.

Purchase this Solution
Free BrainMass Quizzes
Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

View More Free Quizzes
Related BrainMass Solutions

  • Time series analysis : Seasonal index

    229208 Ratio to Moving Average Method 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.

  • Computation of Seasonal Indices

    274180 Ratio to moving average method 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.

  • Ratio-to moving-average method as a forecasting method

    369198 Ratio-to moving-average method as a forecasting method See attached data file. 58. The number of employees on the payroll at a food processing plant is recorded at the start of each month.

  • Seasonal index

    me how to get the centered moving average, and the ratio to moving average ?

  • Time series analysis

    72747 Ratio to Moving Average Method I need help understanding the formula to use for this problem. Also, can this be calculated using a function in Excel?

  • Ratio to moving average

    235650 Seasonal index - Ratio to moving averages An analyst wants to use the ratio-to-moving average method to forecast a company's sales for the next few quarters.

  • Ratio to moving average/seasonal index

    252462 Ratio to moving average/seasonal index An analyst wants to use the ratio-to-moving average method to forecast a company's sales for the next few months.

  • ratio-to-moving average method: Forecasting problem

    This posting contains solution to following problem on forecasting using ratio-to-moving average method.

  • Time series analysis

    Describe the overall long term pattern ( upward or downward movement of the time series over time) b) Develop the typical seasonal pattern for Appliance Center Company, using the ratio-to-moving-average method.

View More Related Solutions