Predicting monthly sale

Assignment Help Operation Management
Reference no: EM13111573

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.
MONTH 2008 2009 2010
January 438 444 450
February 420 425 438
March 414 423 434
April 318 331 338
May 306 318 331
June 240 245 254
July 240 255 264
August 216 223 231
September 198 210 224
October 225 233 243
November 270 278 289
December 315 322 335

Reference no: EM13111573

Questions Cloud

Numerator or denominator of the z-score : The value of the z-score that is obtained for a hypothesis test is influenced by several factors. Some factors influence the size of the numerator of the z -score and other factors influence the size of the standard error in the denominator.
Determine pounds of quicklime and soda : A lime-soda softening plant treats a flow of 150 MGD, and the water has 86 mg/l CO2. The commercial grade of quicklime has a purity of 85% and the soda ash has a purity of 95%.
Advantage of using an alpha level : Briefly explain the advantage of using an alpha level of 0.01 verus a level of .05. general, what is the disavantage of using a smaller alpha level?
Creating standard reference solution for hplc : How can I make up 100ml of a solution containing Compound A (solid, purity of 83.7%) at 90 ug/ml and compound B (liquid, density 1.12 and purity of 90.5) at 30 ug/mL for HPLC reference standard.
Predicting monthly sale : 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.
Problems of hypothesis testing : A sample of n=9 scores is obtained from a normal population distribution with o-=12. The sample mean is M=60.
Two population variances-media matrix and jupiter : Media Matrix and Jupiter Communications gathered data on the time adults and the time teens spend online during a month (USA Today, September 14, 2000).
Question regarding inferences about two population variances : Most individuals are aware of the fact that the average annual repair cost for an automobile depends on the age of the automobile. A researcher is interested in finding out whether the variance of the annual repair costs also increases with the ag..
Inferences about two population variances : The standard deviation in the 12-month earnings per share for 10 companies in the airline industry was 4.27 and the standard deviation in the 12-month earnings per share for 7 companies in the automotive industry was 2.27

Reviews

Write a Review

Operation Management Questions & Answers

  Evaluate information security issues facing the government

Evaluate the information security issues facing the government and identify its three biggest concerns. application: Demonstrate how the government can use authentication and authorization technologies to prevent information theft.

  Describe conceptually about maslow needs hierarchy

is emotional labour more troublesome for college instructors or for telephone operators working at an emergency service. four drives should parallel seven needs which Maslow identified

  If we drew a random sample of federal employees from this

In early years of twenty-first century, annual salaries for federal employees in Upper Midwest averaged approximately $42,000, with a population standard deviation.

  Senior executive responsible for technology

Consider this scenario: You are the senior executive responsible for technology innovation for Company A. The company learns of the cost and efficiency advantages

  Algebraic formulation of the linear programming model

GoodBuy Inc. is a small electronics company that manufactures cell phones and digital recorders. The per-unit labor costs, raw material costs, and selling price of each product are given below.

  The company makes a net income

The company makes a net income of $1.00 for each regular pizza and $1.50 for each deluxe pizza produced. The firm currently has 150 pounds of dough mix and 800 pounds of topping mix.

  Project management at the phoenician video case

Many times, project decision makers do not rely solely on financial hurdles, such as return on investment or internal rates of return, but place a lot of emphasis on intangible factors.

  Estimation of evpi

The following is a payoff table giving profits for various situations. The probabilities for states of nature A, B, and C are 0.3, 0.5, and 0.2, respectively.

  Judge whether marketing occurred in this situation

Judge whether marketing occurred in this situation and justify your conclusions. Appraise the effectiveness of government regulation in controlling markets.

  A motor grader requires two passes at 2 miles per hour

A motor grader requires two passes at 2 miles per hour, two passes at 3 miles per hour, and one pass at 4 miles per hour to accomplish the work

  Create decision tree and calculate expected monetary value

Superior Products Inc. is considering two potential equipment alternatives for production of their best selling product line. Option 1 involves proven equipment: Fixed cost investment of $800,000 Variable cost of $45/unit.

  Discuss the confidence intervals also their usefulness based

Discuss the effect of any seasonal factors utilizing the process performance data collected each week. Discuss the confidence intervals also their usefulness based on the number of data points.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd