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 indicated by a minus sign. Round your intermediate calculations and final answers to 1 decimal place.)
b-2. Which moving average model is best with respect to MAD?
| 2-week moving average | |
| 6-week moving average | |
| 4-week moving average |
Homework Answers
Request Answer!
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
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...
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...
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...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36 2 38 3 40 4 41 5 43 6 42 7 43 8 45 9 46 10 48 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 36. (Round your intermediate calculations and answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α...
Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. 1...
Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. 1 Week Sales (1000s of gallons) 17 2 20 21 11 14 22 a. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. 4-Week 5-Week Moving Average Moving Average Week Sales 17 9 10 11 12 17 DE 23 21 C C 14 22 b. Compute the MSE for the four-week and five-week moving average forecasts. Round...
Refer to the gasoline sales time series data in the given table. Sales (1000s of gallons)...
Refer to the gasoline sales time series data in the given table. Sales (1000s of gallons) 18 Week 18 24 17 15 20 17 21 20 14 4 8 10 12 a. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. 4-Week 5-Week Sales Moving Average Moving Averagee 18 18 24 17 15 20 17 21 20 14 10 12 b. Compute the MSE for the four-week and five-week moving average forecasts....
The accompanying data file contains 10 observations for t and yt. picture Click here for the...
The accompanying data file contains 10 observations for t and yt. picture Click here for the Excel Data File A 3-period moving average is plotted along with the actual series. 15 14 13 12 11 - 10 LA 9 8- 7- 6 5 0 1 2 3 4 6 7 8 9 10 rk Ch 18 Saved Help Save & Exit su Check my we b-1. Use the 3-period moving average to make in-sample forecasts. (Round intermediate calculations to at...
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....
Please help Consider the following time series data. Week 1 N 3 4 5 6 Value...
Please help
Consider the following time series data. Week 1 N 3 4 5 6 Value 19 11 13 10 14 12 (a) Construct a time series plot. 20 18 20 18 14 12 10 Week 3 4 Week D 20 18+ 16 Time Series Value Time Series Value 5 Week 0 Wook What type of pattem exists in the data? The data appear to follow a cyclical pattern. The data appear to follow a trend pattem. The data appear...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 11 16 1017 15 (a) Construct a ...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 11 16 1017 15 (a) Construct a time series plot. 20 20 20 18 16 14 12 10 c 14 12 12 0 23 4 5 67 0 23 4 5 67 Week Weck Week 20 18 0 1 2345 6 7 Week What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a...
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...
Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. 1 Week Sales (1000s of gallons) 17 2 20 21 11 14 22 a. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. 4-Week 5-Week Moving Average Moving Average Week Sales 17 9 10 11 12 17 DE 23 21 C C 14 22 b. Compute the MSE for the four-week and five-week moving average forecasts. Round...
Refer to the gasoline sales time series data in the given table. Sales (1000s of gallons) 18 Week 18 24 17 15 20 17 21 20 14 4 8 10 12 a. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. 4-Week 5-Week Sales Moving Average Moving Averagee 18 18 24 17 15 20 17 21 20 14 10 12 b. Compute the MSE for the four-week and five-week moving average forecasts....
The accompanying data file contains 10 observations for t and yt. picture Click here for the Excel Data File A 3-period moving average is plotted along with the actual series. 15 14 13 12 11 - 10 LA 9 8- 7- 6 5 0 1 2 3 4 6 7 8 9 10 rk Ch 18 Saved Help Save & Exit su Check my we b-1. Use the 3-period moving average to make in-sample forecasts. (Round intermediate calculations to at...
Please help
Consider the following time series data. Week 1 N 3 4 5 6 Value 19 11 13 10 14 12 (a) Construct a time series plot. 20 18 20 18 14 12 10 Week 3 4 Week D 20 18+ 16 Time Series Value Time Series Value 5 Week 0 Wook What type of pattem exists in the data? The data appear to follow a cyclical pattern. The data appear to follow a trend pattem. The data appear...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 11 16 1017 15 (a) Construct a time series plot. 20 20 20 18 16 14 12 10 c 14 12 12 0 23 4 5 67 0 23 4 5 67 Week Weck Week 20 18 0 1 2345 6 7 Week What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a...
Most questions answered within 3 hours.
-
In response to concerns about nutritional contents of fast
foods, McDonald's has announced that it will...
asked 10 minutes ago -
A gun with inertia 5.5 kg fires a 13-g bullet at a stationary
target located 1.0...
asked 11 minutes ago -
A box contains twenty-five screws which are identical in size,
but 13 of which are copper...
asked 14 minutes ago -
“Is it possible that objectively
a product is high quality but subjectively low
quality?”
Please support...
asked 16 minutes ago -
OCHEM LAB
Why does hydration of 2-methyl-3-butyn-2-ol give the ketone,
3-hydroxy-3-methyl-2-butanone (4), rather than the aldehyde,...
asked 25 minutes ago -
A sample of gas at 15 ⁰C and 0.988 atm has a volume of 2.58
liters....
asked 32 minutes ago -
Enzymes are required in retroviruses because the genome
is not used directly as mRNA (T/F)
Please...
asked 31 minutes ago -
An AC generator supplies an rms voltage of 240 V at 50.0 Hz. It
is connected...
asked 43 minutes ago -
Raising taxes on wealthy Americans won’t be enough to deal with the
nation’s budget deficit. Some...
asked 27 minutes ago -
A bacterium (mass = 2.27 x 10−15 kg) in the blood is moving at
0.306 m/s....
asked 30 minutes ago -
look at the Fourth Lateran Council's Canon 18, and argue why a
defendant should not be...
asked 30 minutes ago -
An electron moves at 2.60×106 m/s through a region in
which there is a magnetic field...
asked 42 minutes ago