Explore BrainMass

Explore BrainMass

    What is the deseasonalized sales value for quarter 1?

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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:

    a. 553.5
    b. 984
    c. 588
    d. 184.5

    © BrainMass Inc. brainmass.com June 4, 2020, 12:47 am ad1c9bdddf


    Solution Summary

    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.