Hello Dan,
I have recently constructed a model in Excel.
If you are working in a sales environment I have found the best way is to work backwards from your daily sales target. It would be all to easy to increase the number of agents to achieve high completion rates but you need to consider the agents ability to achieve target also.
For example if an agent has a daily target of 10 sales and your average sale to completed record is 10% an agent will need to complete approximately 100 records to achieve their target.
You will also need to factor in the amount of 'effective' time an agent has - for example login duration less waiting time, breaks, one-to-one's etc. You will need to factor average call durations against this to ensure that the required connects/completions are achievable within the time available.
The model will need to consider the records available, overall target completion rate (DMA guideline is 85%), agent effective time, dialler efficiency to determine amount of idle time and average wait between calls, average call duration, target and conversion. You can then goal seek within Excel to find the values required for x number of agents, or just tweak different areas to see the effects - for example increasing dialler efficiency to find the extra effective time required, or changing the conversions/targets etc.
Hope this helps.
Thanks
Andy |