To serve five sales points, a company intends to open a new distribution center. a) To...

Transcribed Image Text:

To serve five sales points, a company intends to open a new distribution center. a) To find a suitable location for the distribution center, the logistician first needs to forecast the demand of each sales point for the coming period (period 10). To help logistician with the forecasts, answer the following questions using the historical data for demand at each sales point in table below: Sales point 1 Sales point 2 Sales point 3 Sales point 4 Sales point 5 Period 1 392 360. 450 419 196 Period 2 318 445 512 409 505 Period 3 127 229 427 449 474 Period 4 229 241 480 357 501 Period 5 213 423 696 417 299 Period 6 521 451 550 410 449 Period 7 247 235 547 440 183 Period 8 362 332 540 394 567 Period 9 203 352 408 494 368 a.1) Use three-period moving average method to forecast the demand of sales point 1 and sales point 5 for period 10. Round up the forecast if required (Writing the formula and calculations are necessary). [5 points] a.2) Use four-period moving average method to forecast the demand of sales point 2 for period 10. Round up the forecast if required (Writing the formula and calculations are necessary). [5 points] a.3) Use nave method to forecast the demand of sales point 3 for period 10. Round up the forecast if required (Writing the formula and calculations are necessary). [5 points] a.4) Use exponential smoothing method (a = 0.6) to forecast the demand of sales point 4 for period 10. Round up the forecast for period 10 if required (Writing the formula and calculations are necessary). [5 points] b) Now, based on the forecasted demands of period 10 for each sales point, use Mean Absolute Deviation (MAD) for sale point 1 and 2 and Root Mean Square Error (RMSE) for sale point 3, 4 and 5 to calculate forecasting accuracy [20 pointsl O 88 24... To serve five sales points, a company intends to open a new distribution center. a) To find a suitable location for the distribution center, the logistician first needs to forecast the demand of each sales point for the coming period (period 10). To help logistician with the forecasts, answer the following questions using the historical data for demand at each sales point in table below: Sales point 1 Sales point 2 Sales point 3 Sales point 4 Sales point 5 Period 1 392 360. 450 419 196 Period 2 318 445 512 409 505 Period 3 127 229 427 449 474 Period 4 229 241 480 357 501 Period 5 213 423 696 417 299 Period 6 521 451 550 410 449 Period 7 247 235 547 440 183 Period 8 362 332 540 394 567 Period 9 203 352 408 494 368 a.1) Use three-period moving average method to forecast the demand of sales point 1 and sales point 5 for period 10. Round up the forecast if required (Writing the formula and calculations are necessary). [5 points] a.2) Use four-period moving average method to forecast the demand of sales point 2 for period 10. Round up the forecast if required (Writing the formula and calculations are necessary). [5 points] a.3) Use nave method to forecast the demand of sales point 3 for period 10. Round up the forecast if required (Writing the formula and calculations are necessary). [5 points] a.4) Use exponential smoothing method (a = 0.6) to forecast the demand of sales point 4 for period 10. Round up the forecast for period 10 if required (Writing the formula and calculations are necessary). [5 points] b) Now, based on the forecasted demands of period 10 for each sales point, use Mean Absolute Deviation (MAD) for sale point 1 and 2 and Root Mean Square Error (RMSE) for sale point 3, 4 and 5 to calculate forecasting accuracy [20 pointsl O 88 24...