ISOM Forecasting question

DO YOU KNOW WHY YOUR FRIENDS ARE POSTING BETTER GRADES THAN YOU? — THEY ARE PROBABLY USING OUR WRITING SERVICES. Place your order and get a quality paper today. Take advantage of our current 15% discount by using the coupon code WELCOME15.

Order a Similar Paper Order a Different Paper

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 require writing assistance from our best tutors to complete this or any other assignment? Please go ahead and place your order with us and enjoy amazing discounts.

Order a Similar Paper Order a Different Paper