Question

Demand for Y is shown in the table. Develop a forecast using a trend line. What...

Demand for Y is shown in the table. Develop a forecast using a trend line. What is the forecast for period 10?

Period Y
1 28
2 42
3 49
4 74
5 78
6 93
7 115
8 129

Homework Answers

Answer #1

from above

a forecast using a trend line ; forecast for period 10 :

predicted value=11.2857+10*14.3810= 155.095
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The demand for electric power at N.Y. Edison over the period 1999 to 2005 is shown...
The demand for electric power at N.Y. Edison over the period 1999 to 2005 is shown the following table in megawatts. Forecast 2006 the demand by fitting a straight-line trends to these date. Years Time period (x) Electrical power Demand (y) 1999 2000 2001 2002 2003 2004 2005 1 2 3 4 5 6 7 74 79 80 90 105 142 122 a) Find the least squares trend equation for the above data. b) Project demand in 2006 as X=8
1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply...
1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table . YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 a) Develop a 3-year moving averages model to forecast sales. b) Develop a 3-year weighted moving averages model in which sales in the most recent year are given...
10 A) What is the best regression to forecast salary? 10 C) Are  all variables statistically significant?...
10 A) What is the best regression to forecast salary? 10 C) Are  all variables statistically significant? Did you drop any Final Math Pre req Hours Work experience 94 92 5 Y 74 90 3 Y 74 87 4 Y 76 84 3 N 66 87 2 N 80 49 4 Y 74 42 3 N 71 61 4 N 84 81 5 N 76 67 5 Y 95 93 4 N 78 56 5 N 71 54 3 Y 82...
The demand for a given product demand is formulated by the linear trend equation: y= 50...
The demand for a given product demand is formulated by the linear trend equation: y= 50 – 6t. Based on this information, when would be the first period that there is NO demand at all for this product? Select one: a. period 7 b. period 9 c. period 8 d. period 6 e. period 10
A) Forecast the demand for the next 4 periods using Exponential Constant Smoothing. Demand for 6...
A) Forecast the demand for the next 4 periods using Exponential Constant Smoothing. Demand for 6 periods is as follows: Period 1 2 3 4 5 6                                                                   Demand 20 22 21 18 19 28 B) Determine the bias
Using the data given below, (a) develop the estimated trend line (b) predict sales for october...
Using the data given below, (a) develop the estimated trend line (b) predict sales for october and december of the same year Sales in millions 2 4 6 5 3 Month Feb Mar April May June
Consider the following: period 1, 2, 3, 4, 5, 6, 7, 8 demand 7, 8, 9,...
Consider the following: period 1, 2, 3, 4, 5, 6, 7, 8 demand 7, 8, 9, 10, 14, 16, 13, 16 a. using a trend projection, forecast the demand for period 9 b. calculate the MAD for this forecast Show all work! do not use excel or phstat!!!
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week Auto Sales 1 8 2 10 3 9 4 11 5 10 6 13 7 - Problem 2: Carmen’s decides to forecast auto sales by weighting the three weeks as follows: Weights Applied Period 3 Last week 2 Two weeks ago 1 Three weeks ago 6 Total Problem 3: A firm uses simple exponential smoothing with to forecast demand. The forecast for the week...
For the data given below, forecast period 17 using following methods and suggest the best forecasting...
For the data given below, forecast period 17 using following methods and suggest the best forecasting model 1. Simple Moving Average (Three Period) 2. Weighted Average (50% on t-1, 30% on t-2, 20% on t-3) 3. Exponential Smoothing (α=.1), F1= y intercept from regression) 4. Exponential Smoothing (α=.3), F1= y intercept from regression) 5. Exponential Smoothing with trend (α=.3) and (δ=.3), F1= y intercept from regression)** 5. Exponential Smoothing with trend (α=.1) and (δ=.3), F1= y intercept from regression)** 6....
In Excel, create a forecast for periods 6-13 using the following method: 4 period weighted moving...
In Excel, create a forecast for periods 6-13 using the following method: 4 period weighted moving average. Weights: (0.63, 0.26, 0.08, 0.03) Using the 4 period weighted moving average, the forecast for period 13 will be: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74