GSCM 530 Week 1 Homework assignmentAssignmentAssignment: page 431, Problems 2, 8, and 12
2. Given the series of demand data below
.jpg”>
a. Calculate the forecasts for periods 7 through
11 using moving average models with n = 2, n = 4, and n =
6.
b. Calculate the bias and MAD for each set of
forecasts. Which moving average model is the best?
8. The owner of an online video rental
service has recorded the following rentals each week:
.jpg”>
a. Use a three-week moving average to forecast
sales for each of the weeks 4 through 9.
b. Use a four-week moving average to forecast
sales for each of the weeks 5 through 9.
c. Compare the forecasts created by these two
methods using mean absolute deviation. Which forecasting method would you
recommend?
12. Monthly usage data for pallets used in a
distribution center are as follows:
.jpg”>
a. Calculate the monthly usage index for each
month.
b. Use simple linear regression to forecast
total usage of pallets for year 5.
c. Forecast the seasonally adjusted usage for
pallets for each month in year 5.
Links to sample guide for homework
assignment below:
12-02 .viddler.com/embed/67f127aa/?f=1&autoplay=0&player=full&disablebranding=0″>http://www.viddler.com/embed/67f127aa/?f=1&autoplay=0&player=full&disablebranding=0
12-12 .viddler.com/embed/4061df8c/?f=1&autoplay=0&player=full&disablebranding=0″>http://www.viddler.com/embed/4061df8c/?f=1&autoplay=0&player=full&disablebranding=0
12-17 .viddler.com/embed/2f463df5/?f=1&autoplay=0&player=full&disablebranding=0″>http://www.viddler.com/embed/2f463df5/?f=1&autoplay=0&player=full&disablebranding=0
2. Given the series of demand data below
.jpg”>
a. Calculate the forecasts for periods 7 through
11 using moving average models with n = 2, n = 4, and n =
6.
b. Calculate the bias and MAD for each set of
forecasts. Which moving average model is the best?
8. The owner of an online video rental
service has recorded the following rentals each week:
.jpg”>
a. Use a three-week moving average to forecast
sales for each of the weeks 4 through 9.
b. Use a four-week moving average to forecast
sales for each of the weeks 5 through 9.
c. Compare the forecasts created by these two
methods using mean absolute deviation. Which forecasting method would you
recommend?
12. Monthly usage data for pallets used in a
distribution center are as follows:
.jpg”>
a. Calculate the monthly usage index for each
month.
b. Use simple linear regression to forecast
total usage of pallets for year 5.
c. Forecast the seasonally adjusted usage for
pallets for each month in year 5.
Links to sample guide for homework
assignment below:
12-02 .viddler.com/embed/67f127aa/?f=1&autoplay=0&player=full&disablebranding=0″>http://www.viddler.com/embed/67f127aa/?f=1&autoplay=0&player=full&disablebranding=0
12-12 .viddler.com/embed/4061df8c/?f=1&autoplay=0&player=full&disablebranding=0″>http://www.viddler.com/embed/4061df8c/?f=1&autoplay=0&player=full&disablebranding=0
12-17 .viddler.com/embed/2f463df5/?f=1&autoplay=0&player=full&disablebranding=0″>http://www.viddler.com/embed/2f463df5/?f=1&autoplay=0&player=full&disablebranding=0
GSCM 530 Week 1 Homework assignmentAssignment: page 431, Problems 2, 8, and 122. Given the series of demand data below.jpg”>a. Calculate the forecasts for periods 7 through
11 using moving average models with n = 2, n = 4, and n =
6.b. Calculate the bias and MAD for each set of
forecasts. Which moving average model is the best?8. The owner of an online video rental
service has recorded the following rentals each week:.jpg”>a. Use a three-week moving average to forecast
sales for each of the weeks 4 through 9.b. Use a four-week moving average to forecast
sales for each of the weeks 5 through 9.c. Compare the forecasts created by these two
methods using mean absolute deviation. Which forecasting method would you
recommend?12. Monthly usage data for pallets used in a
distribution center are as follows:.jpg”>a. Calculate the monthly usage index for each
month.b. Use simple linear regression to forecast
total usage of pallets for year 5.c. Forecast the seasonally adjusted usage for
pallets for each month in year 5.Links to sample guide for homework
assignment below:12-02 .viddler.com/embed/67f127aa/?f=1&autoplay=0&player=full&disablebranding=0″>http://www.viddler.com/embed/67f127aa/?f=1&autoplay=0&player=full&disablebranding=012-12 .viddler.com/embed/4061df8c/?f=1&autoplay=0&player=full&disablebranding=0″>http://www.viddler.com/embed/4061df8c/?f=1&autoplay=0&player=full&disablebranding=012-17 .viddler.com/embed/2f463df5/?f=1&autoplay=0&player=full&disablebranding=0″>http://www.viddler.com/embed/2f463df5/?f=1&autoplay=0&player=full&disablebranding=02. Given the series of demand data below.jpg”>a. Calculate the forecasts for periods 7 through
11 using moving average models with n = 2, n = 4, and n =
6.b. Calculate the bias and MAD for each set of
forecasts. Which moving average model is the best?8. The owner of an online video rental
service has recorded the following rentals each week:.jpg”>a. Use a three-week moving average to forecast
sales for each of the weeks 4 through 9.b. Use a four-week moving average to forecast
sales for each of the weeks 5 through 9.c. Compare the forecasts created by these two
methods using mean absolute deviation. Which forecasting method would you
recommend?12. Monthly usage data for pallets used in a
distribution center are as follows:.jpg”>a. Calculate the monthly usage index for each
month.b. Use simple linear regression to forecast
total usage of pallets for year 5.c. Forecast the seasonally adjusted usage for
pallets for each month in year 5.Links to sample guide for homework
assignment below:12-02 .viddler.com/embed/67f127aa/?f=1&autoplay=0&player=full&disablebranding=0″>http://www.viddler.com/embed/67f127aa/?f=1&autoplay=0&player=full&disablebranding=012-12 .viddler.com/embed/4061df8c/?f=1&autoplay=0&player=full&disablebranding=0″>http://www.viddler.com/embed/4061df8c/?f=1&autoplay=0&player=full&disablebranding=012-17 .viddler.com/embed/2f463df5/?f=1&autoplay=0&player=full&disablebranding=0″>http://www.viddler.com/embed/2f463df5/?f=1&autoplay=0&player=full&disablebranding=0
