Prepare a graph of the data

Assignment Help Basic Statistics
Reference no: EM13991871

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 the table below.

Discussion Question-

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.

4. Based on these data, which model is better and why?

Monthly Revenue (in $1,000s)

Month             2011          2012          2013

January            436           444           454

February          419           425           439

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       202           212           220

October           225           233           243

November       270           278           289

December        315           322           330

Reference no: EM13991871

Questions Cloud

Adjusted gross income : Their adjusted gross income before considering the investment income is $84,000 in 2009 and $73,500 in 2010. Stoycho and Selen pay $9,000 in investment interest in 2009 and $5,000 in 2010. The investment interest is incurred to acquire all the inv..
Allowable deduction for investment interest : 1. What is Marjorie's allowable deduction for investment interest?
Describe the concept of force-field analysis : Describe the concept of force-field analysis and the forces that either drive or restrain change process. Determine the restraining forces and add them to the figure (one arrow per force).
Line of credit to purchase the car : If she uses the line of credit to purchase the car, the interest rate will be 7.95%. Write a letter to Mandy explaining whether she should finance the purchase of her car through the dealer or use her home equity line of credit. Assume Mandy is in..
Prepare a graph of the data : Prepare a graph of the data. On this same graph, plot a 12-month moving average forecast. Discuss any apparent trend and seasonal patterns
Proper tax treatment of the refund : Simon is single and a stockbroker for a large investment bank. During 2010, he has withheld from his paycheck $2,250 for state taxes and $400 for city taxes. In June 2011, Simon receives a state tax refund of $145. What is the proper tax treat- me..
Jesse allowable deduction for taxes : He also has to pay a $40 penalty and interest of $12 to New York City. However, he receives interest of $16 from New York State. What is Jesse's allowable deduction for taxes for 2010?
Allowable deduction for taxes : If Paula's adjusted gross income is $35,000, what is her allowable deduction for taxes? Assume the same facts as in part a, except that Paula pays $1,600 in sales tax on a motor vehicle she purchased during the year. What is Paula's allowable deduc..
What are the steps of testing a hypothesis : What are the steps of testing a hypothesis for two populationmeanswith independent and dependent samples? Provide a workplace or business related example

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

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