begi year, depart stor been recording sales data to be used to compute 4-period moving averages to orecast sales for an upcoming month. Sales data for the months of January through September are reported in the table below. January February March April May June July August September Month Sales 21 20 39 22 29 14 42 28 27 Computed forecast values are not rounded. Compute the four-period moving average forecast for October. value as a whole number by rounding. Specify the Compute the mean absolute deviation (MAD) for the four-period moving average orecasts. Specify the MAD as a whole number by rounding. Compute the mean squared error (MSE) for the four-period moving average orecasts. Specify the MSE as a whole number by rounding. Compute the mean absolute percentage error (MAPE) for the four-period moving average forecasts. Specify the MAPE as a whole number by rounding.
begi year, depart stor been recording sales data to be used to compute 4-period moving averages to orecast sales for an upcoming month. Sales data for the months of January through September are reported in the table below. January February March April May June July August September Month Sales 21 20 39 22 29 14 42 28 27 Computed forecast values are not rounded. Compute the four-period moving average forecast for October. value as a whole number by rounding. Specify the Compute the mean absolute deviation (MAD) for the four-period moving average orecasts. Specify the MAD as a whole number by rounding. Compute the mean squared error (MSE) for the four-period moving average orecasts. Specify the MSE as a whole number by rounding. Compute the mean absolute percentage error (MAPE) for the four-period moving average forecasts. Specify the MAPE as a whole number by rounding.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.7: Exponential Smoothing Models
Problem 29P: The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building...
Related questions
Question
![Since the beginning of the year, the purchase manager at a department store has
been recording sales data to be used to compute 4-period moving averages to
forecast sales for an upcoming month. Sales data for the months of January through
September are reported in the table below.
Month
January
February
March
April
May
June
July
August
September
Sales
21
20
39
22
29
14
42
28
27
Computed forecast values are not rounded.
Compute the four-period moving average forecast for October.
value as a whole number by rounding.
Specify the
Compute the mean absolute deviation (MAD) for the four-period moving average
forecasts.
Specify the MAD as a whole number by rounding.
Compute the mean squared error (MSE) for the four-period moving average
forecasts. Specify the MSE as a whole number by rounding.
Compute the mean absolute percentage error (MAPE) for the four-period moving
average forecasts.
Specify the MAPE as a whole number by rounding.
CHECK ANSWER](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff1befd8b-fea9-4d58-a4db-57124c8cf11b%2Fc611c515-59fe-468c-bc57-3e5050683db7%2Fxkqczc4_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Since the beginning of the year, the purchase manager at a department store has
been recording sales data to be used to compute 4-period moving averages to
forecast sales for an upcoming month. Sales data for the months of January through
September are reported in the table below.
Month
January
February
March
April
May
June
July
August
September
Sales
21
20
39
22
29
14
42
28
27
Computed forecast values are not rounded.
Compute the four-period moving average forecast for October.
value as a whole number by rounding.
Specify the
Compute the mean absolute deviation (MAD) for the four-period moving average
forecasts.
Specify the MAD as a whole number by rounding.
Compute the mean squared error (MSE) for the four-period moving average
forecasts. Specify the MSE as a whole number by rounding.
Compute the mean absolute percentage error (MAPE) for the four-period moving
average forecasts.
Specify the MAPE as a whole number by rounding.
CHECK ANSWER
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 11 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Contemporary Marketing](https://www.bartleby.com/isbn_cover_images/9780357033777/9780357033777_smallCoverImage.jpg)
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing