Compute the sales forecast

Assignment Help Basic Statistics
Reference no: EM13863018

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) naïve 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: EM13863018

Questions Cloud

Discus the definition of politics, : As we read and discus the definition of politics, let's also consider the consequences of political decisions on our everyday lives. Can you think of examples from your everyday life when you encounter politics? What makes these experiences "politica..
Ethical manner toward the community. : Q1: Discuss either two (2) civil liberties or two (2) civil rights events (past or current) that have influenced a sense of social responsibility in the American government today. Provide examples to support your answer. Note: In your response, consi..
Introductory paragraph and concluding paragraph : Write at three to four (3-4) page paper in which you:1. State your position on the topic you selected for Assignment 1.1.2. Identify (3) three premises (reasons) from the Procon.org website that support your position    and explain why you selected t..
Calculate the single pass conversion of a in the reactor : The reaction A giving 2B+C takes pace in a catalytic reactor. The reactor effluent is sent to a separator. Calculate the single pass conversion of A in the reactor and molar ratio of recycle to feed.
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:
How will you measure your quality of service : How will you measure your quality of service? What barriers might you run into in globalizing your service? Provide specific examples. In terms of the marketing mix, what specific marketing strategies will you use to distribute, price and promote thi..
The history of punk rock : When the music that would come to be known as "punk" first appeared in the U.S. and Great Britain, more than an ocean separated these two attacks on the musical sensibilities of their respective nations.  The roots of American punk were decidedly "ar..
Write a paragraph about the french revolution : Write a Paragraph about the French revolution. Write a one-page paper that provides a detailed comparison of the US Declaration of Independence and the French Declaration of the Rights of Man.
Develop an ex-pression that allows a determination of heats : A gas in a rigid vessel is at ambient temperature and at a pressure, P1, slightly higher than ambient pressure, P0. Develop an ex- pression that allows a determination of the ratio of specific heats, k, in terms of the pressures.

Reviews

Write a Review

Basic Statistics Questions & Answers

  How many people in sample had glucose levels above value

A random sample of 180 individuals had their blood sugar level measured. The 5-number summary was. How many of the people in the sample had glucose levels above 119?

  Confidence interval estimation and anova

The American Sugar Producers Association wants to estimate the mean yearly sugar consumption. A sample of 16 people reveals the mean yearly consumption to be 60 pounds with a standard deviation of 20 pounds.

  Marketing analyst can use inependent samples

Explain how the marketing analyst can use independent samples to collect the data.

  Consider an x-bar chart where the x-bar statistic is

consider an x-bar chart where the x-bar statistic is normally distributed and an associated x-bar control chart exists.

  Claiming sugar packaging

Sugar packaged by a certain machine has a mean weight of 5lb and a standard deviation of 0.02 lb. For what values of c can the manufacturer of the machinery claim that the sugar packaged by this machine has a weight between 5 - c and 5 + c lb with..

  Partition 100 numbers from 0 to 99 according to the

consider the following probability distributiondemand 0 1 2 3 4probability .15 .30 .25 .15 .15partition

  Confidence interval for the mean hav angle

Construct a 95% confidence interval for the mean HAV angle in the population of all such patients and construct a histogram and assess the shape, center, and spread. Remove the patient(s) that who are outliers.

  Probability based on geometric distribution

Follow the conventions as described in the general guidelines for writing up Special Problems.

  A machine produces 3 inch nails. a sample of 100 nails is

A machine produces 3 inch nails. A sample of 100 nails is selected, and it is found that 25 are shorter than 3 inches. Find the 95% confidence interval on the proportion of all such nails that are shorter than 3 inches.

  Suppose that the average life of a refrigerator before

suppose that the average life of a refrigerator before replacement is m 14 years with a 99.7 of data range from 8 to

  Cnstruct a pert network for the project compute the te

this problem should be solved in excel please use separate spreadsheets for different parts.- consider a project

  Assume the distribution of annual costs follows the normal

for the most recent year available the mean annual cost to attend a private university in the united states was 26889.

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