Sales Forecasting for The Glass Slipper Restaurant: Seasonal Patterns, Trend Analysis, and Decomposition Modeling

Preview 2 of 3 pages

See the first 2 pages exactly as they appear in the document.

Page 1
Read page 1 as text
Sales Forecasting for The Glass Slipper Restaurant: Seasonal Patterns, Trend Analysis, and Decomposition Modeling For years The Glass Slipper restaurant has operated in a resort community near a popular ski area of New Mexico. The restaurant is busiest during the first 3 months of the year, when the ski slopes are crowded and tourists flock to the area. When James and Deena Weltee built The Glass Slipper, they had a vision of the ultimate dining experience. As the view of surrounding mountains was breathtaking, a high priority was placed on having large windows and providing a spectacular view from anywhere inside the restaurant. Special attention was also given to the lighting, colors, and overall ambiance, resulting in a truly magnificent experience for all who came to enjoy gourmet dining. Since its opening, The Glass Slipper has developed and maintained a reputation as one of the "must visit" places in that region of New Mexico. 1. Prepare a graph of the data. On this same graph, plot a 12 - month moving average forecast. Discuss any apparent trend and seasonal patterns. 2. Use regression to develop a trend line that could be used to forecast monthly sales for the next year. Is the slope of this line consistent with what you observed in question 1? If not, discuss a possible explanation. 3. Use the multiplicative decomposition model on these data. Use this model to forecast sales for each month of the next year. Discuss why the slope of the trend equation with this model is so different from that of the trend equation in question 2. SOLUTION 1.
Page 2

1 more page in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.