Compute the sales forecast

Assignment Help Basic Statistics
Reference no: EM13860321

Clyde's Chairs and Things sells custom made chairs. Yearly sales from 1983 to 2011 are provided below. After analyzing the information, answer the following questions as completely as possible:

1. Plot the yearly sales data.

2. Compute the sales forecast for 2012 using the following approaches:

a) Native forecast

b) A four year moving average

c) A weighted 3 year average using .5 for 2011, .3 for 2010, and .2 for 2009

d) Exponential smoothing with alpha (smoothing constant) equal to .4 and assuming a 1984 forecast value of 20,050

3. Which method was the most appropriate and why? Which was the least appropriate and why?

Year

Chair Sales (Qty.)

1983

16,688

1984

21,184

1985

25,594

1986

28,110

1987

25,311

1988

20,112

1989

14,521

1990

10,749

1991

11,343

1992

15,162

1993

15,820

1994

16,533

1995

14,449

1996

15,077

1997

15,152

1998

16,303

1999

15,457

2000

14,199

2001

13,030

2002

13,636

2003

13,037

2004

14,842

2005

14,585

2006

10,916

2007

6,928

2008

5,368

2009

5,074       

2010

5,839

2011

4,889

Prepare this assignment in a Microsoft Word document.

Reference no: EM13860321

Questions Cloud

Design and implement a routine that will resample : The purpose of this laboratory is to design and implement a routine that will resample (upsample and/or downsample) a sequence.
What have you learned from others responses : What were the most compelling points from the interaction with your fellow students and how did participating in this discussion help in your understanding of the Discussion Board task?
How does each theory affect the views of the individual : How does each theory affect the views of the individual who is part of health care?
Determine all income statement line item amounts : Determine all income statement line item amounts necessary to prepare Student Inc. income statement starting from "income from continuing operations before tax and extraordinary items" through "net income".
Compute the sales forecast : Clyde's Chairs and Things sells custom made chairs. Yearly sales from 1983 to 2011 are provided below. After analyzing the information, answer the following questions as completely as possible:
What were the most compelling points from the interaction : What were the most compelling points from the interaction with your fellow students and how did participating in this discussion help in your understanding of the Discussion Board task?
Describe the external factors that affect the international : Identify the problems that UPS's information systems need to solve
Implement and present a website in dreamweaver : Develop, implement and present a WEBSITE in Dreamweaver for ONE of the following clients who want to present, popularise and sell their products online.
What are benefits and challanges to adapting new technolgy : Why is change the biggest challange to a system administrator?

Reviews

Write a Review

Basic Statistics Questions & Answers

  Explain how do you declare a variable as binary or integer

explain how do you declare a variable as binary or integer in excel solver?1.briefly explain the results of a what-if

  What does a line plot do to the shape of the graph

What does a line plot do to the shape of the graph of time values which are not uniformly spaced? Would an XY plot show the shape of the data more accurately?

  List some of the risks in using samples to make inferences

list some of the risks in using samples to make inferences about populations from which the samples were drawn. what

  Bob compares his sat verbal score of 400

Bob compares his SAT Verbal score of 400 to Marge's ACT Verbal score of 20. "I beat you," he exclaims. "My score is 20 times your score!" Although his multiplication is good, his logic is faulty. Explain why.

  Example of how statistics are miscommunicated

This is one way of saying statistics can be easily miscommunicated. Find one example of how statistics are miscommunicated and explain why there was a miscommunication and what you would do to correct this problem.Using probability: How can you use..

  Find weight of female using regression model output

The following output is the result of running a linear regression on WEIGHT (y) = average weight in pounds for American females. Based on this regression model output, what will be the weight of a Russian Female who is 71 inches tall?

  Simulator to determine the tread life

Suppose we select a sample of 40 tires and use a simulator to determine the tread life. What is the likelihood of finding that the sample mean is between 59,050 and 60,950?

  Below is the sample of baby deliveries in an 8 hour period

question below is the sample of baby deliveries in an 8 hour period at a small hospital13 14 6 12 13 8 6 14 4 78 7 5 9

  Is there evidence that the cost of attendance has increased

The sample mean was $22,098 and the standard deviation was $6050. Is there evidence at the 1% significance level that the cost of attendance has increased?

  Given the correlation value between anxiety and exam score

given the correlation value between anxiety and exam score could you assume that heightened anxiety is causing at least

  Describe how you could determine if the fishing is better

is fishing better from a boat or from the shore? pyramid lake is in nevada. presidents movie stars and people who just

  Are mean annual attendance rates same for employees

The sample sizes are unequal. Research question: Are the mean annual attendance rates the same for employees in these three departments?

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