Determine the seventh projection of the following process variable data: Using Exponential Smoothing (α= 2/n+1) Actual...

Determine the seventh projection of the following process variable data:

Using Exponential Smoothing (α= 2/n+1)

Actual Results 100 123 140 110 150 105

Solutions

Expert Solution

α= 2/n+1 = 2/(7+1) = 0.25

Solve Using Excel:

	α	0.25
Projection	Actual (A)	Foercast (F)	A-F
1	100	100.00	0.00
2	123	100.00	23.00
3	140	105.75	34.25
4	110	114.31	-4.31
5	150	113.23	36.77
6	105	122.43	-17.43
7		118.07

Projection	Actual (A)	Foercast (F)	A-F
1	100	=B3	=B3-C3
2	123	=C3+$C$1*D3	=B4-C4
3	140	=C4+$C$1*D4	=B5-C5
4	110	=C5+$C$1*D5	=B6-C6
5	150	=C6+$C$1*D6	=B7-C7
6	105	=C7+$C$1*D7	=B8-C8
7		=C8+$C$1*D8

Projection 7 = 118.07

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Using exponential smoothing with α of 0.1 and the given forecast for year 1

As you can see in the following table, demand for heart transplant surgery at Washington General Hospital has increased steadily in the past few years: Year12345Heart Transplants46.048.055.057.057.0The director of medical services predicted 6 years ago that demand in year 1 would be 42.0 surgeries a) Using exponential smoothing with α of 0.1 and the given forecast for year 1, the forecasts for years 2 through 6 are (round your responses to one decimal place): Year123456Forecast42.0For the forecast made using exponential smoothing with α...

Given the following data, use exponential smoothing with a = 0.3 and α =.5 to develop...

Given the following data, use exponential smoothing with a = 0.3 and α =.5 to develop a demand forecasts for period 7. Assume that the forecast for week 1= 19. Use the Mean Absolute Percent Error to determine which forecasts are more accurate. Period 1 2 3 4 5 6 Demand 17 19 15 19 13 18

Question: Use the first-order exponential smoothing model with α = 0.2 to forecast for these data...

Question: Use the first-order exponential smoothing model with α = 0.2 to forecast for these data and for the first six months of the third year. Compute MSD/E, MAD, MAPE, and Bias. Month (t) Demand A(t) 1 148 2 125 3 78 4 53 5 25 6 29 7 9 8 68 9 84 10 110 11 147 12 120 13 147 14 109 15 96 16 70 17 42 18 36 19 34 20 28 21 71 22 102...

a. Show the naive forecast, an exponential smoothing forecasts using α = 0.2, and a 3-month moving average forecast.

Month137244335450534630750829936103511411245a. Show the naive forecast, an exponential smoothing forecasts using α = 0.2, and a 3-month moving average forecast.b. Compare the MFE, MSE, and MAPE on the modelsc. Make a conclusion on which model to use.d. Find the alpha (smoothing constant) that minimizes the MSE.

With the gasoline time series data from the given table, show the exponential smoothing forecasts using...

With the gasoline time series data from the given table, show the exponential smoothing forecasts using α = 0.1. week 1 2 3 4 5 6 7 8 9 10 11 12 sales 17 21 19 23 18 16 20 18 22 20 15 22 a. Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of α = 0.1 or α = 0.2 for the gasoline sales time series? Do not round your interim computations and...

Use 5 months moving average and exponential smoothing method (using alpha=0.3) on the following sale of...

Use 5 months moving average and exponential smoothing method (using alpha=0.3) on the following sale of Maggi. You are supposed to forecast the sale of Maggi in the 13th Month. Compare whether there is any difference in forecast based on two methods and Comment. Period (Month) Actual Sale of Maggi 1 1100 2 800 3 1000 4 1050 5 1500 6 750 7 700 8 650 9 1400 10 1200 11 900 12 1000 13

The following data based on assumption for 2 years projection, Analysis the following income statement and...

The following data based on assumption for 2 years projection, Analysis the following income statement and state whether investor should invest the company or not (250 words minimum) YEAR 1 YEAR 2 Revenues $ 2,995,000 $ 3,200,000 Cost of sales 1,894,000 2,100,000 Gross profit $ 1,101,000 $ 1,100,000 Accounting 8,000 8,300 Advertising and promotion 17,000 11,000 Bank chargers 51,000 55,897 Compensation and benefits 197,546 234,985 Insurance 5,000 5,550 Lease, facilities 350,600 456,000 Legal and professional 15,900 15,900 Licenses and fees...

Using the calculated wavelength, plot a graph of 1/lambda vs. (1/2^2 - 1/N^2). Determine the Rydberg...

Using the calculated wavelength, plot a graph of 1/lambda vs. (1/2^2 - 1/N^2). Determine the Rydberg constant from the slope of the line. Please write answer as neatly and large as possible, clearly demonstrating all steps. Computed wavelengths for each spectral line; Yellow = 5.89x10^-7m Violet = 4.38x10^-7m Blue = 4.91x10^-7m Red = 6.78x10^-7m

Using the calculated wavelength, plot a graph of 1/lambda vs. (1/2^2 - 1/N^2). Determine the Rydberg...

Using the calculated wavelength, plot a graph of 1/lambda vs. (1/2^2 - 1/N^2). Determine the Rydberg constant from the slope of the line. Please demonstrate using Excel only how to plot the graph portion and demonstrate clearly on paper how to determine the Rydberg constant from the slope of the line (showing all steps in detail) Computed wavelengths for each spectral line; Yellow = 5.89x10^-7m Violet = 4.38x10^-7m Blue = 4.91x10^-7m Red = 6.78x10^-7m

- Solve the following recurrence relation : T(n) = T(αn) + T((1 − α)n) + n

Subjects