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 In
2 days
Total Bids
Project Description

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.

Completed by:
Skills Required

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online