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.
-
Assume Kw = 1.01 ✕ 10−14
For pure water, we can calculate [H3O+ ] = [OH...
asked 32 minutes ago -
Suppose that on a temperature scale X, water boils at 203.0°X
and freezes at -105.7°X. What...
asked 1 hour ago -
BaS crystallizes in a cubic unit cell with S2- ions on each
corner and each face....
asked 1 hour ago -
A. 0≤P(Oi)≤10≤P(Oi)≤1 for each i
B. P(Oi)≤0P(Oi)≤0
C. P(Oi)=1+P(OCi)P(Oi)=1+P(OiC)
D. P(Oi)≥1P(Oi)≥1
If an experiment consists of...
asked 3 hours ago -
A battery has an emf of 9.20V and an internal resistance of 1.20
ohm. a)What resistance...
asked 3 hours ago -
The area of an elastic circular loop decreases at a constant
rate, dA/dt = −6.60×10−3 m2/s...
asked 4 hours ago -
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 6 hours ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 6 hours ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 6 hours ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 6 hours ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 6 hours ago -
Explain in steps on the following code
What would be the output when executed
using System;...
asked 6 hours ago