Question

Case Study Forecasting Monthly Sales For years The Glass Slipper restaurant has operated in a resort shore. They also knew that hiring the right manager would al- community near a popular ski area of New Mexico. The restau low James and Deena the time to begin a semi-retirement in a rant is busiest during the first 3 months of the year, when the corner of paradise. ski slopes are crowded and tourists flock to the area. To make this happen, James and Deena would have to sell 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, result- ing in a truly magnificent experience for all who came to enjoy gourmet dining. Since its opening, The Glass Slipper has devel- oped and maintained a reputation as one of the must visit The Glass Slipper for the right price. The price of the business would be based on the value of the property and equipment, as as projections of future income. A forecast of sales for the next year is needed to help in the determination of the value of the restaurant. Monthly sales for each of the past 3 years are provided in Table 5.14 Discussion Questions 1. Prepare a graph of the data. On this same graph, plot a places in that region of New Mexico 12-month moving average forecast. Discuss any apparent trend and seasonal patterns. While James loves to ski and truly appreciates t he moun- tains and all that they have to offer, he also shares Deenas dream of retiring to a tropical paradise and enjoying a more relaxed lifestyle on the beach. After some careful analysis of their financial condition, they knew that retirement was many years away. Nevertheless, they were hatching a plan to bring them closer to their dream. They decided to sell The Glass Slipper and open a bed and breakfast on a beautiful beach in Mexico. While this would mean that work was still in their future, they could wake up in the morning to the sight of the palm trees blowing in the wind and the waves lapping at the 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 equa tion in question 2. TABLE 5.14 Monthly Revenue (in $1,000s) MONTH January February March 438 420 414 318 306 240 240 425 423 331 318 245 255 223 210 233 278 322 2010 450 438 434 338 May une July August September October November December 254 264 231 224 243 289 335 225 270 315

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1) Time series plot of revenue as function of time is shown below

Monthly Revenue and Forecast as function of time -Monthly Revenue (At)--12-month moving average forecast 500 450 400 350 o 30

Trend: the time series plot shows that there is a slightly increasing trend.

Seasonality: There is a clear seasonal pattern evident in the time series plot. Monthly revenue is the highest in Jan month and then it decreases until Sep, after which it again increases until Jan. The rate of decrease and increase is identical year after year.

2) Regression to develop trend line.

Simple Linear Repression (Least Squares Repression Method 438 420 414 318 306 240 438 840 1242 1272 1530 1440 680 1728 1782 2

The trend line developed using regression shows a downward slope. That is possible because the rate of decrease is becoming steeper, and rate of increase is getting flatter.

3) Multiplicative decomposition.

1 Multiplicative Decomposition tercept292.792 Slope0.5160 Averag 304.458 PeriodMonthly Seasonal Deseasonal 5 Year Month (t)Re

Formulas:

D3 =AVERAGE(D6:D29)

G2 =INTERCEPT($G$6:$G$29,$C$6:$C$29)

G3 =SLOPE($G$6:$G$29,$C$6:$C$29)

E6 =D6/$D$3 copy to E6:E41

F6 =AVERAGE(E6,E18,E30) copy to F6:F17

F18 =F6   copy to F18:F53

G6 =D6/F6   copy to G6:G41

H6 =$G$2+$G$3*C6   copy to H6:H53

I42 =H42*F42   copy to I42:I53

Add a comment
Know the answer?
Add Answer to:
Case Study Forecasting Monthly Sales For years The Glass Slipper restaurant has operated in a resort...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT