How to do Capacity Planning for next 9 weeks (Very Urgent)

Topic Views - 1499

How to do Capacity Planning for next 9 weeks (Very Urgent)
Hi All Friends

I need your help to create Capacity Planning for 9 weeks , details are below
Absence Target 2%
Sickness Target 4%
Holiday Target 11.54%
Forecast Accuracy 5%
Weekly Attrition 2%
Occupancy Target 85%
Service Level 80%
Target Answer 20 Secs
AHT 404 Sec
Historical Data
Date Total Calls
01 Jan 07 8674
08 Jan 07 9068
15 Jan 07 9068
22 Jan 07 11546
29 Jan 07 8984
05 Feb 07 7404
12 Feb 07 7351
19 Feb 07 7556
26 Feb 07 8337
05 Mar 07 7556
12 Mar 07 8337
19 Mar 07 8656
26 Mar 07 8850
02 Apr 07 8573
09 Apr 07 8588
16 Apr 07 8777
23 Apr 07 8757
30 Apr 07 8059
07 May 07 7433
14 May 07 8757
21 May 07 8471
28 May 07 7351
04 Jun 07 7556
11 Jun 07 9077
18 Jun 07 9295
25 Jun 07 8337
02 Jul 07 8656
09 Jul 07 8850
16 Jul 07 8573
23 Jul 07 8588
30 Jul 07 8777
06 Aug 07 8734
13 Aug 07 8471
20 Aug 07 7351
27 Aug 07 7556
03 Sep 07 9077
10 Sep 07 9295
17 Sep 07 8337
24 Sep 07 8656
01 Oct 07 8850
08 Oct 07 8573
15 Oct 07 8588
22 Oct 07 8777
29 Oct 07 8734
05 Nov 07 8757
12 Nov 07 9077
19 Nov 07 7351
26 Nov 07 7556
03 Dec 07 8734
10 Dec 07 8850
17 Dec 07 8337
24 Dec 07 8656

I need to complete Capacity Plan for 9 weeks with forecasting



Forecasted Calls (week1) (week2) (week3) (week4) (week5) (week6). (week7) (week8) (week9)
Forecasted AHT (week1) (week2) (week3) (week4) (week5) (week6). (week7) (week8) (week9)

Required FTE (week1) (week2) (week3) (week4) (week5) (week6). (week7) (week8) (week9)
Actual FTE (week1) (week2) (week3) (week4) (week5) (week6). (week7) (week8) (week9)
Attrition (week1) (week2) (week3) (week4) (week5) (week6). (week7) (week8) (week9)
Recruitment (week1) (week2) (week3) (week4) (week5) (week6). (week7) (week8) (week9)
Variance (week1) (week2) (week3) (week4) (week5) (week6). (week7) (week8) (week9)

Occupancy (%) (week1) (week2) (week3) (week4) (week5) (week6). (week7) (week8) (week9)

Absence (%) (week1) (week2) (week3) (week4) (week5) (week6). (week7) (week8) (week9)
Sickness (%) (week1) (week2) (week3) (week4) (week5) (week6). (week7) (week8) (week9)
Holidays (%) (week1) (week2) (week3) (week4) (week5) (week6). (week7) (week8) (week9)


Please help i am new in this feild

Regards
Vinod

Helper

Call Centre Helper

A few tools to help you
Here are two of the main tools that you need

To Generate the forecast here is a forecasting tool. It works best if you group the calls into a month
https://www.callcentrehelper.com/forecasting-tool-97883.htm

But you do not have enough information to make an accurate forecast as you only have one year of data. This gives you the seasonality but it does not give you the trend. You need as a minimum one more week of data (but ideally at least one more year of data) to obtain the annual trend.

Once you have the forcast you can use an Erlang Calculator
https://www.callcentrehelper.com/tools/erlang-calculator/

You will need to put in your shrinkage. Here is an article on how to calculate shrinkage
https://www.callcentrehelper.com/how-to-calculate-contact-centre-shrinkage-90353.htm

Why is your forecast data from 2007? I would have thought that this would be rather out of date by now.

Want to add a comment?

Not found what you were looking for?

1. Try searching through our site.
2. Still not got an answer?

Why not ask the Call Centre Helper Community? Click here to ask your question