Homework_Ch13

# Homework_Ch13 - 7 Forecast demand using exponential...

This preview shows page 1. Sign up to view the full content.

Homework – Chapter 13 You are given the following data set for the sales of bottled water at Kroger: Jan 1325 Feb 1353 Mar 1305 Apr 1275 May 1210 Jun 1195 1. Forecast demand for April – July using the 3-month SMA method. 2. Forecast demand for June – July using the 5-month SMA method. 3. Forecast the July demand using the 6-month SMA method. 4. Forecast the July demand using the 6-month WMA method with 40% weight given to the first three months and 60% weight given to the last three months. 5. Forecast the July demand using the 6-month WMA method with 30% weight given to the first three months and 70% weight given to the last three months. 6. Forecast the July demand using the 6-month WMA method with 20% weight given to the first three months and 80% weight given to the last three months.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 7. Forecast demand using exponential smoothing with α = 0.2 where the January forecast is 1370. 8. Forecast demand using exponential smoothing with α = 0.8 where the January forecast is 1370. 9. Forecast demand using exponential smoothing with trend where α = 0.8 and δ = 0.5, where the January forecast is 1380 and January trend forecast is -10. 10. Calculate the MAD, MFE and Tracking Signal for the Exponential Smoothing forecasts with α = 0.2. Is this a good forecasting method for this data? 11. Calculate the MAD, MFE and Tracking Signal for the Exponential Smoothing with trend forecasts. Is this a good forecasting method for this data? 12. Use linear regression to forecast the July demand....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online