ong Term Forecasting Create a forecast Instructions: The following table represents call volume for the first 20 weeks of years 2003 - 2005 and call volume for the first 10 weeks of 2006. Create a forecast for weeks 11-20 for the year 2006 and input the forecast in the area highlighted in yellow. After you complete your forecast, please use the text box below to explain the rationale and assumptions behind your forecast Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Week 13 Week 14 Week 15 Week 16 Week 17 Week 18 | Week 19 Week 20 401,244 402,578 413,471 427,980 463,220 487,185 425,514 482,864 511,608 525,944 549,507 476,283 555,963 583,458 561,946 539,048 520,994 478,299 428,572 20031 428,170 454.981 417,116 380,800 2004 351,156 364,513 360,637 364,079 366,422 390,654 415,130 365,544 1 408,471 416,175 440,465 448,407 411,521 471,646 479,307 477,527 470,078 386,232 363,258 321,818 2005 293,378 296,483 294,174 294,442 302,263 315,018 342,117 296,479 337,663 356,004 368,278 389,984 369,518 391,786 403,470 402,755 398,220 2006 276,619 260,470 271,491 276,658 287,101 287,507 326,892 287,628 ! 328,697 348,592 Explanation / Rationale / Assumptions:Stafng Analysis Determining how many agents we need? Given the following assumptions, how many people would we need to schedule to answer the calls Please document any assumptions you make outside the ones provided. Assumptions: A. 350 Calls will be answered in the center during a one hour period E. The ayerage duration of the call will be 180 seconds C. 12% of an agent's time will hesp-ent off the phone D. Ofthe time logged into the phones, an agent will be handling calls approximately 85% of the time and waiting for the next call approximately 15% of the time E. 5% of the agents scheduled will call in sick Number of agents? Please explain the process you went through to get y ur answer in the text box below