Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

To serve five sales points, a company intends to open a new distribution center. a) To find a suitable location for the distribution center,

image

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...

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Management

Authors: Robbins, DeCenzo, Coulter

7th Edition

132996855, 0-13-610982-9 , 9780132996853, 978-0-13-61098, 978-0136109822

More Books

Students also viewed these General Management questions