isom forecasting question

The Swim Wear Store sells bathing caps. As the store does not sell a lot of them, such that ordering them periodically during the year when they run out has been the method of restocking. The store has the opportunity to purchase them in bulk at a much cheaper price from a supplier, but the supplier is only willing to ship these once a year. Thus, the Swim Wear Store needs to predict how many they will need next year. They have many loyal customers that will be very upset if they are not able to purchase a swim cap. Swim Wear Store has determined that customers will not be upset if they cannot purchase swim caps in December, just in case they run out. Swim Wear Store has kept the monthly sales records of swim caps for the years, 2015, 2016 and 2017. The store would also like to know the monthly sales forecast for swim caps in 2018, as it will help them to determine sales of other products, along with the total sales of swim caps for 2018. Follow the steps below.

• Create a numerical reference for each month in the Time column.
• In the column CMA, use the centered moving average for the month.
• In the column seasonal index, (Sales/CMA) for each month.
• Find the seasonal ratio, using the table labeled Seasonal Ratio
• Calculate the deseasonalized demand. (Sales/Seasonal Ratio)
• Use Trend to forecast demand.
• Seasonalize the forecast (TrendX Seasonal Ratio)

How much is the overall demand for bathing caps for 2018? What is the monthly demand?

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

The post isom forecasting question appeared first on Essay Writers.