Reference no: EM131229021
Forecasting Monthly Sales 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. While James loves to ski and truly appreciates the mountains and all that they have to offer, he also shares Deena’s 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 shore. They also knew that hiring the right manager would allow James and Deena the time to begin a semi-retirement in a corner of paradise. To make this happen, James and Deena would have to sell The Glass Slipper for the right price. The price of the business would be based on the value of the property and equipment, as well 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 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.
DATA
2011
Jan- 438, Feb- 420, March- 414, April- 318, May- 306, June- 240, July-240, August- 216, Sept- 198, Oct- 225, Nov-270, Dec- 315
2013
Jan- 444, Feb- 425, March- 423, April- 331, May- 318, June- 245, July-255, August- 223, Sept- 210, Oct- 233, Nov-278, Dec- 322
2014
Jan- 450, Feb- 438, March- 434, April- 338, May- 331, June- 254, July-264, August- 231, Sept- 224, Oct- 243, Nov-289, Dec- 335
|
Determine and plot the filter output
: Discuss the impact of the change on the BER of the binary communication system - Obtain the autocorrelation function and the power spectral density of X(t).
|
|
How does agency theory affect insider trading activities
: How does agency theory affect insider trading activities? Do executives in the firm have any information advantage over outside investors? Explain the impact of agency theory on short- and long-term financial performance.
|
|
Derive an equivalent of upml in 2d cylindrical coordinates
: Plot a snapshot of the field patterns a few wavelengths down the waveguide; what modes exist in this waveguide? Repeat for frequencies of 8 GHz and 12 GHz and compare the results.
|
|
Briefly discuss a client or server computing relationship
: Briefly discuss a client/server computing relationship by giving an example of a client (user point of entry) and a server (system that stores and processes shared data). A successful posting will have at least two paragraphs with at least five ..
|
|
They had a vision of the ultimate dining experience
: Forecasting Monthly Sales 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 f..
|
|
How a firm can add value by combining traditional capital
: Discuss how a firm can add value by combining traditional capital budgeting techniques with an alternative strategy and consider sustainable capital.
|
|
How to manage and control the use of cloud resources
: How to manage and control the use of cloud resources and other service providers that may be used for processing and data storage outside the organization's physical locations and Specific recommendations to control mobile access to organization..
|
|
Identify the economic benefits from international visitors
: Research Objectives - To identify the economic benefits from international visitors. To determine the number of international visitors in the fix period July 1st 2016 to 31st December 2016
|
|
Learned in course to your current or future position
: Rate the three (3) most important concepts that you learned in this course in order of importance (one [1] being the most important). Provide a rationale for your response. Determine ways you plan to apply what you learned in this course to your curr..
|