Data Analysis - Call Center
This project was successfully completed by TwoExcelKings for $75 USD in 2 days.Get free quotes for a project like this
Project Budget$50 - $75 USD
Completed In2 days
Need to analyze call center metrics to develop three formulas for a call center report.
Please review the 2 attached reports & sample formula.
1.) We need to determine the amount of work we are doing: Something like (time logged into system - actual work time)
2.) Determine our efficiency: - Something like (Talk Time + Work Time/Hours logged in)
3.) Number of agents needed per hour: Forecast of calls expected / (work time*60)/Call handle time.)
The formulas above are a very vague idea of what I am looking for. We want someone to develop the actual formulas based off the available reports we have.
You may have to research how call centers measure efficiency.
End product must be 3 sample reports in Excel and an written report of the formulas with a proof for the reports.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online