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© BrainMass Inc. brainmass.com March 4, 2021, 9:15 pm ad1c9bdddf
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.