| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||
2 | Telecom Expenses | Notes | Calculation | |||||||||
3 | Inbound | |||||||||||
4 | A | Inbound 800# cost/minute | $0.02 | Avg. cost per minute paid for inbound 800# services. | Cost/second | $0.0004 | ||||||
5 | Outbound | rounded up to the nearest 1/4 cent | ||||||||||
6 | B | Outbound LD cost/minute | $0.02 | Cost/second | $0.0004 | |||||||
7 | rounded up to the nearest 1/4 cent | |||||||||||
8 | ||||||||||||
9 | Multipliers | |||||||||||
10 | Traffic | |||||||||||
11 | C | Num of seconds saved per call | 15 | Industry avg. suggests 15-20 seconds/call saved. | Savings/call | $0.19 | ||||||
12 | D | Avg. num of inbound calls/agent/hour | 20 | Inbound savings/hr/agent | $3.80 | |||||||
13 | E | Avg. num of outbound calls/agent/hour | 5 | Outbound savings/hr/agent | $0.95 | |||||||
14 | F | Hours of operation/day | 8 | Savings/hour | $47.50 | |||||||
15 | G | Num of days/week | 6 | Savings/day | $380.00 | |||||||
16 | Labor | Savings/week | $2,280.00 | |||||||||
17 | H | Avg. "loaded" salary/agent (per year) | $30,000.00 | Includes benefits, training costs, vacation time, payroll taxes, etc. | Savings/month | $9,120.00 | ||||||
18 | Avg. agents "on duty"/hour | 10 | Savings/year | $109,440.00 | ||||||||
19 | ||||||||||||
20 | ROI Calculation(s) | |||||||||||
21 | I | Application Cost | $30,000.00 | Total cost of the Screenpop application and development | ||||||||
22 | J | Phone System Cost | Total cost of the Unified Communications solution including phone (less the application) | Savings/month | 9,120.00 | |||||||
23 | K | ROI in years | 0.28 | Savings/year | 109,440.00 | |||||||
24 | L | ROI in months | 3.36 | |||||||||
25 | M | ROI in working days | 87.36 | |||||||||
26 | ||||||||||||