Given the series of demand data below Period: 1 2 3 4 5 6 7 8...

Question

Question

Given the series of demand data below Period: 1 2 3 4 5 6 7 8...

Given the series of demand data below


Period:	1	2	3	4	5	6	7	8	9	10
Demand:	45	35	51	43	22	50	36	38	26	37

a. Calculate the forecasts for periods 7 through 11 using moving average models with n = 2, n = 4, and n = 6.

Week	n=2	n=4	n=6
7
8
9
10
11

b. Calculate the bias and MAD for each set of forecasts. (Negative answers should be indicated by a minus sign. Round your intermediate calculations and final answers to 1 decimal place.)

	moving Average Forecast
	n=2	n=4	n=6
bias
MAD

business Operations-Management

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Add a comment

Answer 2

Similar Homework Help Questions

Given the series of demand data below Period: 1 2 3 4 5 6 7 8...

Given the series of demand data below Period: 1 2 3 4 5 6 7 8 9 10 Demand: 41 31 51 45 23 48 33 43 29 38 a. Calculate the forecasts for periods 7 through 11 using moving average models with n = 2, n = 4, and n = 6. (Round your intermediate calculations and final answers to 1 decimal place.) b-1. Calculate the bias and MAD for each set of forecasts. (Negative answers should be...
Calculate the following forecasts using the data below. For periods 4 through 10, develop the exponentially...

Calculate the following forecasts using the data below. For periods 4 through 10, develop the exponentially smoothed forecasts using a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. Calculate the three-period moving-average forecast for periods 4 through 10. Calculate the weighted moving average for periods 4 through 10, using weights of .70, .20, and .10, with 0.70 applied to the most recent data Calculate the mean absolute deviation (MAD) for each forecasting procedure. Which forecasting procedure...
8. Examine the following quarterly data: Quarter 11 Quarter 2 2 Quarter 3 3 15 26 20 12 34 51 Quarter 44 Quarter 1 5 Quarter 2 6 Quarter 3 7 Quarter 4 8 Quarter 1 9 Quarter 2 1 38 62 Quarter 311...

8. Examine the following quarterly data: Quarter 11 Quarter 2 2 Quarter 3 3 15 26 20 12 34 51 Quarter 44 Quarter 1 5 Quarter 2 6 Quarter 3 7 Quarter 4 8 Quarter 1 9 Quarter 2 1 38 62 Quarter 311 Quarter 4 12 84 Calculate the seasonal indexes for each quarter. a. Quarter 1 Quarter 2 Quarter 3 Quarter 4 b. Deseasonalize the time series. Produce the trend line using the deseasonalized data. Produce seasonaly adjusted...

Respond to each of the items using the following time series data. Period 1 2 3...

Respond to each of the items using the following time series data. Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Demand 144 172 157 160 144 181 160 176 149 183 182 149 153 164 153 104 Click here for the Excel Data File b. Compute all possible forecasts using a five-period moving average. (Round your answers to 1 decimal place.) Period Demand 5-period SMA Absolute Errors 1 144 2 172...
Please help with questions 7 - 10. PART IV Planning and Controling Operations and Supply Chains...

Please help with questions 7 - 10. PART IV Planning and Controling Operations and Supply Chains 290 period 1 was 250. Plot the results. Which model appears to work better? Why? 10. After graduating from college, you and your friends start selling birdhouses made from recycled plast has caught on, as shown by the following sales figures For problems 4 through 6, use the following time series data: The idea DEMAND MONTH January 2012 February March April May June 119...
For problerms 7 througl use the following time serles data:l Th fol PERIOD DEMAND 221 247 228 233...

Use excel, show excel commands. #8 For problerms 7 througl use the following time serles data:l Th fol PERIOD DEMAND 221 247 228 233 240 152 163 155 167 158 4 5 7 10 7. () Develop a last period forecast for periods 2 through 11. Calculate the MFE, MAD, and MAPE values for periods 2 through 10. Is this a good model? Why? 8. () Develop a three-period weighted moving average forecast for periods 4 through 11. Use weights...

The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34...

The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34 2 37 3 38 4 37 5 40 6 37 7 42 8 44 9 41 10 42 a. Calculate the single exponential smoothing forecast for these data using an ? of 0.20 and an initial forecast (F1) of 34. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 2 3 4 5 6 7 8 9 10 b....
The actual values for 12 periods (shown in order) are: Period Data 1 45 2 52...

The actual values for 12 periods (shown in order) are: 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 In Excel, create forecasts for periods 6-13 using each of the following methods: -------- -5 period simple moving average; Using a 5 period simple moving average, the forecast for period 13 will be: 68 -4 period weighted moving average (0.63, 0.26, 0.08, 0.03); Using...
Omework Consider the following time series data Month 1 2 3 4 5 6 7 Value 21 14 18 13 18 21 14 a....

omework Consider the following time series data Month 1 2 3 4 5 6 7 Value 21 14 18 13 18 21 14 a. Which of the following is a correct time series plot for this data? や" -Select your answer- What type of pattern exists in the data? -select your answer- b. Develop the three-month moving average forecasts for this time series. Compute MSE and a forecast for month 8 (to 2 decimals if necessary). Enter negative values as...

Period 2 3 4 5 6 3 Period Moving Average 4 Period Moving Average Observation Forecast...

Period 2 3 4 5 6 3 Period Moving Average 4 Period Moving Average Observation Forecast Error Error A2 Abs Error Forecast Exponential Smoothing Error Error 2 Abs Error Forecast Error 86 Error A2 Abs Error 85 Assume FAI 80 81 86 89 95 88 91 92 88 96 MSE MSE MSE MAD MAD Alpha 02 8 9 10 11 12 13 MAD According to MSE, what is the best forecasting model to MAD, what is the best forecasting model

Given the series of demand data below Period: 1 2 3 4 5 6 7 8...

Homework Answers