Given the following demand data for five consecutive months: January: 120 units February: 130 units March:...

   

Transcribed Image Text:

Given the following demand data for five consecutive months: January: 120 units February: 130 units March: 140 units April: 150 units May: 160 units What is the forecast for June using a 3-month moving average? Given the following demand data for three consecutive months: January (Actual): 300 units February (Actual): 310 units March (Actual): 320 units The forecasted demand was 305 units for February and 310 units for March. The smoothing constant (alpha) is 0.1. What is the forecast for April using Simple Exponential Smoothing? iven the following demand data for six consecutive months: January: 120 units February: 130 units March: 150 units April: 140 units May: 160 units June: 150 units The weights for the 3-month moving average are 0.1, 0.3, and 0.6 for the first, second, and third month respectively. What is the forecast for July using a 3-month weighted moving average? Given the following actual demand and forecasts for the last five months: Month 1 2 3 4 5 Actual Demand 257 240 251 228 228 Forecast What is the Mean Absolute Deviation? 274 258 255 209 217 Given the following demand data for five consecutive months: January: 120 units February: 130 units March: 140 units April: 150 units May: 160 units What is the forecast for June using a 3-month moving average? Given the following demand data for three consecutive months: January (Actual): 300 units February (Actual): 310 units March (Actual): 320 units The forecasted demand was 305 units for February and 310 units for March. The smoothing constant (alpha) is 0.1. What is the forecast for April using Simple Exponential Smoothing? iven the following demand data for six consecutive months: January: 120 units February: 130 units March: 150 units April: 140 units May: 160 units June: 150 units The weights for the 3-month moving average are 0.1, 0.3, and 0.6 for the first, second, and third month respectively. What is the forecast for July using a 3-month weighted moving average? Given the following actual demand and forecasts for the last five months: Month 1 2 3 4 5 Actual Demand 257 240 251 228 228 Forecast What is the Mean Absolute Deviation? 274 258 255 209 217

Answer rating: 100% (QA)

1 Calculate the forecast for June using a 3month moving average youll average the demand data for the three most recent months March April and May Add ... View the full answer