Explore BrainMass

Seasonal Index

Convert time series data to seasonal indices.

Material: Summer Historical Inventory.

Please be sure that your index calculations are based on the seasons in the data. You will need to identify the seasons in your data (winter & summer, high and low, etc.). As an example, if you divide your data into high season and low season, you'll use the average of all of the data for the high season as your base for the index numbers in those months in the high season, then you'll use the average of the low season months as the base for the months in the low season. Doing this will remove the changes in the data due to seasonality and help you see where the true changes in your data occur (not those based on the seasonality of the product). For instance, if you sell sqimsuits and you normally see a big increase in sales between April and August, then in the current year you want to see if there was really an increase in sales, you'd have to remove the seasonality and look at your index numbers to make that determination.

The seasonal merchandise is attached the product is Sunglasses, so the sales will be higher during the summer months..

Explain the results.


Solution Summary

This solution is comprised of detailed step-by-step calculation of the given problem in EXCEL and provides students with a clear perspective of the underlying concepts.