Solve it correctly please. I A sales manager wants to forecast monthlysales for the company's products using thefollowing monthly sales data.month 12 34 5 6$3,803 $2,558 $3,469 $3,442 $2,682 $3,469SalesIf the forecast for period 7 is $3167, what isthe forecast for period 9 using exponentialsmoothing with an alpha equal to 0.6?$2802$3425O $3113O $3100O $32012 of 102

A company manager intended to forecast the monthly sales and six months sales are given as below:…

Answered: A sales manager wants to forecast…

College Algebra

1st Edition

ISBN:9781938168383

Author:Jay Abramson

Publisher:Jay Abramson

Chapter3: Functions

Section3.3: Rates Of Change And Behavior Of Graphs

Problem 26SE: Table 3 gives the annual sales (in millions of dollars) of a product from 1998 to 20006. What was...

See similar textbooks

Similar questions

Enter the data from Table 2 into a graphing calculator and graph the ranking scatter plot. Determine whetherthe data from the table would likely represent a function that is linear, exponential, or logarithmic.
Does a linear, exponential, or logarithmic model best fit the data in Table 2? Find the model.
Table 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?
Olympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s pole vault height has fallen below the value predicted by the regression line in Example 2. This might have occurred because when the pole vault was a new event there was much room for improvement in vaulters’ performances, whereas now even the best training can produce only incremental advances. Let’s see whether concentrating on more recent results gives a better predictor of future records. (a) Use the data in Table 2 (page 176) to complete the table of winning pole vault heights shown in the margin. (Note that we are using x=0 to correspond to the year 1972, where this restricted data set begins.) (b) Find the regression line for the data in part ‚(a). (c) Plot the data and the regression line on the same axes. Does the regression line seem to provide a good model for the data? (d) What does the regression line predict as the winning pole vault height for the 2012 Olympics? Compare this predicted value to the actual 2012 winning height of 5.97 m, as described on page 177. Has this new regression line provided a better prediction than the line in Example 2?
Cable TV The following table shows the number C. in millions, of basic subscribers to cable TV in the indicated year These data are from the Statistical Abstract of the United States. Year 1975 1980 1985 1990 1995 2000 C 9.8 17.5 35.4 50.5 60.6 60.6 a. Use regression to find a logistic model for these data. b. By what annual percentage would you expect the number of cable subscribers to grow in the absence of limiting factors? c. The estimated number of subscribers in 2005 was 65.3million. What light does this shed on the model you found in part a?
The U.S. Census tracks the percentage of persons 25 years or older who are college graduates. That data forseveral years is given in Table 4[14]. Determine whether the trend appears linear. If so, and assuming the trendcontinues. in what year will the percentage exceed 35%?
Table 3 gives the annual sales (in millions of dollars) of a product from 1998 to 20006. What was the average rate of change of annual sales (a) between 2001 and 2002, and (b) between 2001 and 2004?
Estimate the age of a newly discovered fossil for which the ratio of carbon-14 to carbon-12 is R=1/1014.
Please answer part b
For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. a. Compute for a 3 month moving average forecast. b. Compute for the exponential smoothing forecast for a=0.2. c. Which provides the better forecast using MSE as the measure of model accuracy? d. What is the forecast for next month?
Using excel. For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. a. Compare the three-month moving average approach with the exponential smoothing approach for α=\alpha =α= .2. Which provides more accurate forecasts using MSE as the measure of forecast accuracy? b. What is the forecast for next month? Please show work
Please answer part C

SEE MORE QUESTIONS

Recommended textbooks for you

College Algebra

Algebra

ISBN:

9781938168383

Author:

Jay Abramson

Publisher:

OpenStax

Algebra & Trigonometry with Analytic Geometry

Algebra

ISBN:

9781133382119

Author:

Swokowski

Publisher:

Cengage

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

College Algebra

Algebra

ISBN:

9781938168383

Author:

Jay Abramson

Publisher:

OpenStax

Algebra & Trigonometry with Analytic Geometry

Algebra

ISBN:

9781133382119

Author:

Swokowski

Publisher:

Cengage

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

College Algebra (MindTap Course List)

Algebra

ISBN:

9781305652231

Author:

R. David Gustafson, Jeff Hughes

Publisher:

Cengage Learning

Functions and Change: A Modeling Approach to Coll…

Algebra

ISBN:

9781337111348

Author:

Bruce Crauder, Benny Evans, Alan Noell

Publisher:

Cengage Learning

Big Ideas Math A Bridge To Success Algebra 1: Stu…

Algebra

ISBN:

9781680331141

Author:

HOUGHTON MIFFLIN HARCOURT

Publisher:

Houghton Mifflin Harcourt

SEE MORE TEXTBOOKS

A sales manager wants to forecast monthly sales for the company's products using the following monthly sales data.