See attached file.
The attached table shows the sales for a plastics manufacturer recorded over the past year. The seasonal indexes for each quarter are also provided. To track the trend for these four quarters, use the indexes to deseasonalize the sales data:
What is the deseasonalized sales value for quarter 1?
Choose the right answer:
This solution is comprised of detailed analysis and step-by-step calculations of how to deseasonalize seasonal demands in Excel. The solution provides students with a clear perspective of the given problems and the related aspects of forecast analysis.