Prison Phone Justice

Fy Os.09 CDOC INMATE PHONE REVENUEICOMMISSION OFF SET

Debit
Interstatel
Collect

I

,

I

Kit Carson
Credits

309,871.92
26,520.45
7,278.30
25,318.42
38,811.09
21,494.22
27,034.82

Debit Revenue Total Revenue
263,692.93
573,564.85 I
18,919.93
45,440.38 i
6,164.45
13,442.75 i
16,156.82
41,475.24 :
22.754.96
61,566.05 :
14,680.89
36,t75.11 :
18,347.74
45,382.56 :

USF
6,105.54
422.64
86.17
248.82
473.95
329.56
442.71 :

i

i

456329.22

360,689.35

I

Invoice less
Commission}

less USF
567,459.31
45,017.74 .
13,356.58 I
41,226.42 I
61,092.10
35,845.55
44,939.85

(43%)
244,007.50
19,357.63
5,743.33
17,727.36
26,269.60
15.413.58
19,324.14

8,109.38

808,937.56

347,843.15

566,276.22 1
43,790.77
13,181.24
43,684.57
60,932.29
35,867.76
40,526.85

6,228.11
437.11 I
96.37 ;
276.59
492.05
306.40
422.26

560,048.11
43.353.66
13,084.87
. 43,407.98
60,440.24
35,561.36
40,104.59

804,259.70

8,258.89

796,000.81

342,280.35

511,834.46
33,664.98
12,514.11
38,729.14
51,126.81
35,032.41
43,174.65

5,523.49
342.88
91.62 I
220.78 !
443.07
297.87
391.62 .
,

506,310.97
33,322.10
12.422.49
38.508.36 t
50,683.74 I
34,734.54 j
42,783.03 :

217,713.72
14,328.50
5,341.67
16,558.59
21,794.01 1
14,935.85 •
18,396.70 •

(27.87

TOTAL

Off-Set (Debit

International Total Reven ue ' Commission

Revenue

Jul-08 DOC
Bent
Brush
CEC
Crowley
Huerfano

I

817,046.94 :

-

! -:

r-I

19,685.43
(437.70)
421.12
(1,570.54)
(,3.51464)
(732.69)
(975.40)

(2787)
12,846.70

DOC
InitiallDate
Approved
SG 08-04-08
SG 08-04-08
SG08-04-08
SG08-04-08
SG 08-04-08
SG 08-04-08
SG 08-04-08
SG 08-04-08
SG 08-04-08

:

VAC
Initial/Date
Approved
Tl8-13-08
Tl8-13-08
TL 8-13-08
TL 8-13-08
, TL8-13-08
! TL 8-13-08
! TL 8-13-08
i TL 8-13-08
TL 8-13-08

Private Site

DOC 20% or

80"10 or 82%

18%

15,873.26
4,709.53
14,181.89
21,541.07
12,639.14
15,845.79

3,464.37
1,033.80
3.545.47
4,728.53
2,774.45
3,478.34

84,790.ii8

19,044.96

15,286.50
4,613.73

3.355.57
1.012.77

:

Aug-08 DOC
Bent
Brush
CEC
Crowley
..

Huetfano
Kit Carson

Credits
TOTAL
Sep-08 DOC
Bent
Brush
CEC
Crowley
Huerfano

KilCarson
Credits
TOTAL
1st Qb'

,
:
I

!

297,563.54
24,288.17
7,100.52
24,466.10
36,196.06
21,256.20
23,061.21
433,931.80 1
276,188.34
18,899.71
6,932.49
23,446.90 I
29,994.88 I
21,559.22 :
24,885.88 I

268.712.66
19.502.60
6,080.72
19,218.47 I
24.736.23
14,611.56
17,465.64
(21.36 I
370,306.54 i
:
235,646.12 i
14,765.27 '
5,581.62 !
15,282.24 !
21,131.93 :
13,473.19 :
18,288.77 :
(30.521 :

401,907.42
1,292, 168.44

,
I

324,138.62 :

..

.

:
i

:
:
,
I

240,820.69
18,842.07
5,626.49
18:665.43 "
25,989.30
15,291.38 :
17,244.97 i

L

I

726,076.56

7,311.33

718,765.23 I

309,069.05

I
1,055,135.01 l 2,347,383.20 i

23,679.60

2,323,703.60 I

Prepared by
;

17,932.40
436.77
239.95
(1,27635)

!

(662.08)
(1,462.66)
('107.93)
(30.52

i

15,069.57

I

999,192.55 j

-'r 8/13/2009
i

".,j

I
I

27,891.99 SG 09-04-08
860.53 SG 09-04-08
454.23 SG09-04-08
. 553.04 SG 09-04'08 .
(1,253.07) SG 09-04-08
(679.82) SG 09-04-08
220.67 SG 09-04-08
(21.36 SG 09-04-08
28,026.19 SG 09-04-08

55,942.46

SG 10-03-08
SG 10-03-08
SG 10-03-08
SG 10-03-08
SG 10-03-08
SG 10-03-08
SG 10-03-08
SG 10-03-08
SG 10-03-08

TL 9-9-08
Tl9-9-08
Tl9-9-08
ITt9-9'lJ8 -- ---

~4,932.35-

:TL 9-9-08
:TL 9-9-08
!TL 9-9-08
!TL 9-9-08
ITL 9-9-08

21,311.23
12,538.94
14,140.88

TL 10-9-08
Tl10-9-08
Tll0-9-08

I~~ :~~:~:
!TL 10-9-08
iTL 10-9-08
hL 10-9-08
ITL 10-9-08

I

.

3,'l33c09

4,678.07
2,752.45
3,104.10
I

82,823.61 :
I
11,749.37
4,380.17
13,246.88
17,871.09
12,247.40
15,085.30

i

18,636.05

2,579.13
961.50
3,311.72
3,922.92
2,688.45
3,311.41

I

74,580.20 I
242,194.49

1
t

16,775.13
54,45l1.14

. Page 1

.J

-

FY oa.os cooc INMATE PHONE REVENUE/COMMISSION OFF SET

I
00t-08 DOC

Bent
Brush
CEC

Revenue

I
I
I
I

282,748.54
23,324.96
6,720.53
21,631.43
31,206.17
14,168.99
24,034.27

•

I

Kit Carson
Credlts
TOTAL

296,618.65
23,942.86
6,733.65
22,138.88
40,449.29
20,283.19
24,791.10

Huerfano

Kit Carson

:
:
i
!

TOTAL

434,957.62 j

,

2nd Qtr

307,985.44 !
22,612.62 !
7,459.30 1
21,876.17 I
36,777.56 I
19,636.83 I
25,762. 16 1

I
I
I
I 1,280,902.59 I
I

USF
5,748.24
444.33
106.91
262.91
478.15
226.33
431.85

less USF
532,371.61
41,872.22
13,414.96
39,396.03
55,089.16
24,676.42
41,202.50

I

755,721_62

7,698.72

748,022.90 I

249.501.98
17.279.57
6.563.67
17,655.81
24.777.66
15.854.54
17,908.67
(39.02)
349,502.88 I

546.120.63
41.222.43
13,297.32
39,794.69
65.226.95
36.137.73
42,699.77

5,847.62
413.34
118.00
243.73
475.08
345.88
428.01

540,273.01 :
40.809.09 :
13.179.32 i
.
.
I
39,550.96
64.751.87
35.791.85
42,271.76

232,317.39
17.547.91
5,667.11
17,006.91 I
27,843.30
15,390.50
18,176.86

764,499.52

7,871.66 I

776,627.86

333,949.98

6,306.92
429.14
111.93
267.94
527.26
325.18
485.24

565,294.75
40,199.95,
13,946.10 I
39.504.63 I
62,497.67 I
34,852.61 1
44,397.48

243,076.74
17.28598 i
5,996,82
16,986.99
26,874.00 ;
14,986.62
19,090.92

8,453.61

800,693.19

344,298.07

2,325,343.95

999,897.90

255,371.31
18,991.59
6,801.34
18,027.51
24.361.14
10,733.76
17,600.0B
(48.61
351,838.12

!

Huerfano
Kit Carson
Credits
TOTAL

538,119.85
42,316.55
13,521.87
39,658.94 ,
55,567.31 !
24,902.75
41,634.35

Debit Revenue Total Revenue

Credits

Dec-08 DOC
Bent
Brush
CEe
Crowley

442,110.08

Off-Set (Debit

Commission

International Total Revenue

403,834,89

Nov-08 DOC
Bent
Brush
CEC
Crowley

•

DOC
InitiallDate
Approved
(43%)
i Commission)
228,919.79 i
26,451.52 SG 11-05-08
18,005.05
986.54 SG 11-05-08
1,032.91 SG 11-05-08
5,768.43
1,087.22 SG 11-05-08
16,940.29
672.80 SG 11-05-08
23.688.34
122.90 SG 11-05-0B
10,610.86
(116.99) SG 11-05-08
17.717.08
(48~11-05-0B
. 30 188.
. 11-05'08
321649.85

Collect

I

Crowley

Huerfano

Debit
Interstate! i

,

I nvoice less

17,184.59 SG 12-03-08
(268.34) SG 12-03-08
896.56 SG 12-03-08
648.90 SG"12'03'08
(3,065.64) SG 12-03-08
464.04 SG 12-03-08
(268 j9) SG 12-03~8
(39.02) SG 12-03-08
15,552.90 SG 12-03~8

VAC
Initial/Oate Private Site DOC 20% or
Approved 80% or 82%
18%
TL 11-6-08
3,240.91
TL 11-6-08
14,764.14,
1,038.32
,TL 11-6-08
4,730.11 I
3,388.06
ITL 11-6-08
13.552.23 •
4,263.90
ITL 11-6-08
19:424.441
ITL 11-6-08
1,909.95
8,700.91
14,528.00
3,18907
TL 11-6-08
TL 11-6"08
17;030;22
TI: f1:S-08 -----"75;699:84"
TL 12-11-08
TL 12-11-08
TL 12-11~8
TL12-11~8

TL
TL
TL
TL
TL

12-11-08
12-11-08
12-11-08
12-11-08
12-11-08

~4:38~291

4,647.03 •
13,605.53 '
22,831.51
12,620.21
14,905.02

82,998_58

3,158.62
1,020.08
3,401.38
5,011.79
2,770.29
3,271.83
18634.00

I

263,616.23
571,601.67
40,629.09
18,016.47
14,058.03
6,598.73
17.896.40
39,772.57
26.247.37
83,024.93
35,177.79
15.540.96 ,
44,882.72
19.120.56 I
(87.72)1
366,949.00 1
809,146_80
I
1,068,290.00 : 2,349,367.94

!
24,023.99 !

,

Prepared by

I

20,539.49
730.49
601.91
909.41

SG 01-06-09
SG 01-06-09
SG 01-06-09
SG 01-08-09
(626<o3} SG 01-08-09
554.34 SG 01-08-09
29.64 SG01~6-09
(87.72) SG 01-06-09
22,650.93 SG 01-O8~9
68,392.10

TL 1-13-09
TL 1-13-09
TL 1-13-09
TL 1-13-09
TL 1-13-09
TL 1-13-09
TL 1-13-09
TL 1-13-09
Tll-13-09

14,174.50 :
4,917. 39 1
13,589.59
22,036.68
12,289.03
15,654.55

3,111.48
1,079.43
3.397.40
4.837.32
2,697.59
3,436.36

112661.75 !

18,559.58

241,360.17 I

54,223_80

Page 2

....r 8113l2009

/

FY 08-09 CDOC INMATE PHONE REVENUElCOMMISSION OFF-SET

Debit
Interstate!
Collect
Jan-09 DOC
Bent
Brush
CEC
Crowley
Huerfano
Kit Carson

,

Revenue

,

280,934.90
21,476.31
6.983.87
21.844.91
36.216.03
16,972.53
23,138.71

I

I
1

TOTAL

IOff-Set (Debit

International Total Revenue
Debit Revenue Total Revenue

261.251.79
17.235.02
6,553.28
19.294.62
27.539.79
13.290.25
17,537.09
.. (7681)
362,625.03

407,567.26

542,186.69
38,711.33
13.537.15
41,139.53
63,755.82
30,262.78
40,675.80

USF
5,055.25
354.85 I
88. 52 1
246.56 I
435.65
214,74
391.58

less USF
537,131.44
38,356.48
13,448.63
40.892.97
63,320.17
30,048,04
40,284.22

Commission, Invoice less

i

(43%)
230,966.52
16,493.29
5,782.91
17,583. 98
27,227.67
12,920,66
17,322.21

I
I

328297.24

,
'

i
I

1 Commissi.on)

I
I
I
1
1

I

770,269.10

6787.15

763,481.95

518,025.17
40,532.15
11,321.66
39,748.66
64,054.48
25,399.36
39,806.95

4,790.62
346.09
73.66
249.43
440.11
242.89
419.24

513.234.55
40.166.06
11.248.00
39,499.43
63.614.37
25,156.47
39,387.71

220.690.86
17,280.01
4,836.64
16.964.75
27,354.18
10,817.28
16,936.72

738,888.63

6,562.04

732,326.59

314,900.43

566,825.69
50,223.09
13,456.69
42,373.79
69,597.66
26,115.66
45,319.82

6.235.10
421.47
95.36
285.90
566.57
262.39
499.80

560,590.59
241,053.95 I
49,801.62
21,414.70 I
5,745.37 i
13,361.33 L
42,087.89 1
18,097.79 I
69,011.29 •
29,674.85 I
25,853.27 .
11,116.91 I
44,820.02
19,272.61 I

813,912.60

8,386.59

805,526.01 .

30,285.27
741.73
770.37
1,710.64
312.12
369,59
214.88
(76.S"
34,327.79

.

Feb-09 DOC
Bent
. Brush
CEC
Crowley
Huerfano
Kit Carson

258,369.82
21,960.42 ,
6,234.19 !
20,525.47
35,947.57
12,417.27
20,835.44 .

Credits
TOTAL

376,290.18 i

Mar-09 DOC
Bent
Brush
CEC
Crowley

I

,

I

Huerfano
Kit Carson

280,291.30
26,516.80
7,136.09
22.047.04
36,282.35
12,092.35
24,228.04

I
I

259,655.35
18,571.73
5,087,47
19,223.39 I
28,106.91 I
12,982.09 I
18,971.51 i
(32.55) I
362,565.90 I

i

VAC
Initial/Date
Approved
TL2-4-09
TL 2-4-09
TL 2-4-09
TL 2-4-09
TL 2-4-09
TL 2-4-09
TL 2-4-09
TL 2-4-09

Private Site DOC 20% or
80%

or 82%

18%
I
I

13,524,49 i
4,741.99 1
14,067.181
22,326.69 I
10,594.94 I
14,204.22 i

2,968.79
1,040.92
3.516.80
4,900.98
2,325.72
3,118.00

I
79,'f59Jjl~17;8T1.21

..

-AG 03-09-09 .TL03-11-09
AG 03-09-09 ITL 03-11-09
AG03-09-09 ITL 03-11-09
AG 03-09-09 ITL 03-11-09
AG 03-09-09 ITl 03-11-09
AG03-09-09 TlO3-11-09
AG03-09-09 TL 03-11-09
AG 03-09-09 TL 03-11-09

14,169.60
3,966.04
13,587.80
22,430.43
8,870.17
13,888.11

3.110.40
870.60
3,396.95
4,923.75
1.947.11
3.048.61

76912.161

17,297.42

17,560.05
4,711.20
14,478.23
24,333.38
9,115.86
15,803.54

3,854.65
1,034.17
3;619.56
5,341.47
2,001.04
3,469.07

86,002.27

19,319.96

242,373.94

54,488.59

I
286.534.39 I
23,706.29 I
6.320.601
20.326.75 I
31.315.51
14,023.31 I
21.091.781
(18.78):
403,299.85 I

Credits
TOTAL

I

3rd Qtr

I
i
I 1,194,451.41 , 1,128,490.78 I 2,323,070.33 I

410,593.97

I

38,964.49
1,291.72
250.83
2,236.64
752.73
2.164.81
2.034.79
(32.55
47,665.47

DOC
InitialiDate
Approved
SG02-03-09
SG 02-03-09
SG 02-03-09
SG 02-03-09
SG 02-03-09
SG 02-03"09
SG 02-03-09
SG 02-03-09

346,376.18

45,480.44
2,291.59
575.23
2,228.96
1,640.66
2,906.40
1,819.17

AG 04-09-09
AG 04-09-09
AG 04-09-09
AG 04-09-09
AG 04-09-09
AG 04-09-09
AG 04-09-09
{18.78 AG 04-09-09
56,923.67

TL 4-14-09
TL 4-14-09
TL 4-14-09
TL 4-14-09
TL 4-14-09
TL 4-14-09
TL 4-14-09
TL 4-14-09

!

21,735.78 I 2,301,334.55 1

989,573.86

Prepared by - '''r B/13/2OQ9

138,916.92

PageS

.

-

FY 08-09 CDOC INMATE PHONE REVENUE/COMMISSION OFF SET

I

Debit
Interstate!
International! Total Revenue
Debit Revenue Total Revenue
USF
,I less USF

Collect
Revenue
Apr-09 DOC
Bent
Brush
CEC
Crowley
Huerfano
Kit Carson
Credits
TOTAL

I
I

I

:

256,472.75
29,552.96
7,413.54
17,789.40
35,551.08 .
4,894.68 I
24,615.74 I

I

i
I

376,290_15 I

277,800.17
25,522.39
6,752.40
19,136.30 i
30,852.58 I
4,541.97 I
21,725.97
(29.86 I
386,301.92

i

534,272.92
55,075.35
14,165.94
36,925.70
66,403.66
9,436.65
46,341.71

6,026.93
441.25
95.14
269.74
533.50
85.15
533.32

762,621.93

7,985.03 ,

I
:
I
I
I
I

Off-5et (Debit
Invoice less
Commission)

Commission
(43%)

528.245.99
54.634.10
14,070.80
36,655.96
65,870.16 I
9,351.50 '
45,808.39

227,145.78 '
23,492.66
6,050.44
15,762.06
28,324.17
4,021.15
19,697.61

754,636.90

I

VAC
DOC
Initial/Date ! InitiallDate
Approved . Approved

,

324,493.87

50,654.39
2,029.73
701.96
3,374.24
2,528.41
520.82
2,028.36
(29.86
61,808_05

AG 05-05-09 TL 5-12-09
AG 05-05-09 TL 5-12-09
AG 05-05-09 ITL 5-12-09
AG 05-05-09 ITL 5-12-09
AG 05-05-09 TL 5-12-09
AG 05-05-09 TL 5-12-09
AG 05-05-09 TL 5~12-09
AG 05-05-09 TL 5-12-09
Tl5-12-09

51,216.78
5,247.17
838.56
4,715.84
3,201.40
0.00
1.658.39

TL 6-10-09
ITL 6-10-09
iTL 6-10-09
F[6-10-09
ITL 6-10-09
iTL 6-10-09
ITL 6-10-09
ITL 6-10-09
ITL 6-10-09

Private Site DOC 20% or
18%
80% or 82% ,
I

I
19,263.98 I
4,961.36 I
12,609.65 I
23,225.82 I
3,297.34
16,152.04

4,228.68
1,089.08
3.152.41
5,098.35
723.81
3,545.57

79,510.19

17837_90

21,594.24
5,387.92
15,501,86
22,639.33
0.00
16,981.81

4,740.20
1,182.72
3,875.46
4,969.61
0.00
3,727.72

82,105.16

18,495_71

,

.

~y-09 DOC

Bent
Brush
CEC
Crowley

Huerfano
Kit Carson
Credits
ITOTAL
Jun-09 DOC
Bent
Brush
CEC
Crowley
Huerfano
Kit Carson

Credits
TOTAL
4th Qtr

266,804.98 I
30,275.05.
7,981.28 I
21,388.83 !
33,948.24 i

286,293.36 i
553,098.34
31,581.61 i
61,856.66
7.407.20
15,388.48
24,093.16 I
45,481.99
30,810.34
84,758.58
0.00 i
0.00 i
0.00
26.333.47L
22,387.92 I
48,701.39
(33.26)i
I
386,731.85 I
402,520.33 I
789,285.44
I
I
222,502.20 I
266,058.73 I
488,560.93
26,545.79 I
25,760.90 I
52,306.69
6.840.43 I
6,916.69 1
13.557.12
18,855.66
22.341.79 I
41,197.45
28,108.31
26,525.59 I
54,633.90
{WO
0.00 I
0.00
14,656.02
15;797.92 I
30,453.94
(36J39)f
317,584.67
363,088.67 i
680,710.03
I
1,080,606.67 1,151,910.92 , 2,232,617_40

107.91

15,280.57

418.48
551.74
0.00
539.70

45,063.53
64,206.84
0.00
48,161.69

235,076.58
26,334.44
6,570.64
19,377.32
27,606.94
0.00
20,709.53 I

8,640.21

780,645.23

335,677.45 i

!
'
!
•
•

5,908.25
520.47
96.74
392.40
471.37 i
0.00 i
366.59,

207,540.66
22,268.07
5,787.96
17,546.17
23,289.89
0.00
12,937.56

:

7,755.82

482,652.68
51,786.22 .
13.460.38 i
40,805.05 •
54,162.53 •
0.00.
30,087.35 i
,,
672,854.21 I

I

I

TOTAL 08-09; 4,848,129.11

4,403,826.71

I

9,252,438.87

546,689.72 i
61,242.88 !

6.408.62
613.78

I

i

.AG 06-08-09
AG 08-08-09
AG 08-08-09
AG 08-08-09
AG 08-08-09
AG 06-08-09
AG 06-08-09
(3326) AG 06-08-09
66,642.88

I
I

i

I

289,370.31

I

58,518.07
3,492.83
852.47
4,795.62
3,235.70
0.00
2,860.36
(3669)
73,718.36

949,541.63 I

202,369.29

I
I

3,938,205.93 t

465,620.78

I

!
,
:

24,381.06

I

93,820.43

I
i
I

2,208,236.34
9,158,618.44

I

i

Prepared by -'>!r 8f1312009
I

SG 07-08-09 TL 7-10-09
SG 07-08-09 TL 7-10-09
SG 07-08-09 TL 7-10-09
SG 07-08-09 TL 7-10-09
SG 07-08-09 :TL 7-10-09
SG 07 -08-09iTL 7-10-09
SG 07-08-09 iTL 7-10-09
SG 07-08-09 :,TL 7-10-09
SG 07-08-09 iTL 7-10-09

18,259.82
4,748.13
14,038.94
19,097.71 .
0.00
10,608.80
66,749.40

J

4,008.25
1,041.83
3.509.23
4,192.18
0.00
2,328.76
15,080_25

I

I
I

51,413.86

954,293.36 :

214,582_38

228,364.75

Page 4

(j

f~

\

l

====~=~:~=~I======~=r,===~F:Y:2:0JO:9:C:I:P:S:A=~ITc~r:u:a:IS::aJ~:d~p=a:v:m:e:~n]t~S~p=re:a:d=S~h:e:e:t===~==-,c=~======'======T~===~i=========±I===='=l====~~~-I==.==~
CIPS Commisions to Accrue
I

Due Per SueJNAC Reports

Month
Collect
FY08 CarryOver
$ 130,.517.82
~- - - - $ 133;244.92
August
$ 127,952.32
SePtember
$: 1'1"8,760,99
Oct~-'-- $ 121,581.87
November
$ 127,54£.02
December
$ 132,433.74
January
$ 120,802.01
February $ 11 t,099.D2
March
$ 120,525.26
April
$ 110.283.28
May
$ 114.726.14
June
$ 95.675.95

$
$
$
$
$"

$
$
$
$
$
$
$
$

Total Due to
Debit
DOC
107,825.58 $ 238.343.40
110,7£2.58 $ 244,007.50
112,008.37 $ 240,820.69
98,952:73 -$ 217,713.72
1"01',337.92---$- 228:9HH9104,n1.37 $ 232,317.39
110,643.00 $ 243,076,74
HO, H34.51 $ 230,966.52
109,5'91.83 $ 220,690.85
120,528.69 $ 241,053.95
116,862.50 $ 227.145.78
120,350.44 $ 235,076.58
111,864.71 $ 207,540.66

1

Currentto
--'nt
A ..
Accrue

Totals
AddU'! Accruals:
CMRC (20%/43%)

July

I

0.00
0.00
0.00
0:00
-~ - O:O{}0.00
0.00
0.00
0.00
0.00
0.00
0.00
207,540.66
$207540.66 $2,800 132.911

I

~nua~
I_______-+________~I--------!=eiirUaiy---i
!
I

~ril

June

"

_

:FYD8 carry"f',"orwa"";"rd'c.____

---",Fea"re":..ary_- - - - --'~- . -

~

"

~-=--~

To!aJunleJVAccrua~-_-~,·.:_~'.
--

---

-

~

I.:

;-.~'.~~~==~+----===~~
,:•,

- -

-

-.

Q:\CTCF\A.CCTNG\GENACCT\Pratt\CIPS\FY09 CIPS Spreadsheet

01116109
02tUf09
03i16J09.
D4l14i09

249,462.96

263;528.51
261;-174.98
259;622.80
286,515.6,
277,770.31
288,260.10

03/16/09

04/14109
05f14109
06f12'09
07/13/09

05.1'14109

06/-12109
-o7/-f3/09

:::

1:08.-.531.61
.••. l1B,260.23

$ 1.221.843.81 I

$ 3,158,314.99 I

.~

..

3,270.37

§
$

3,733.09
3,31'L72

$
-$
-$

3,388.0"'6.1_____-+'_ _ _ _ _+-_ __+---+----+-----.;....---+----!----1
3,401.38
'
3,397.40
I

3,545.47

-$

3.61 •. 56

1

S

3.152.41

I

I'

3,509.23
-

I
.

1

I

!

I

---j-'_ _ _ I

I

I

I
1:---.1

1-, _ _ _

1

-+'____ I

1

14,853.9Sl

$

i

I'

I

1

~~75.46 " iI

~ ~._ jg;g~
i ---~- --~ -1---- -~. .l.-----~ ____ ::_-~=.;-~.---~
_
--t---- I
-------~.---. --. ~:$-: i,~3~,!.~0~0: :.'7:8 ~ 1_ --: J, ~lt
'=~:::II-=-=--:~-II~- . =1 ~i-=-:
. _·
I
:
-$"5,70040 =::::-.--. ._==--1" _=-=- _._.
L

__u

II

:

~:1~~;

222,620.91!

--

$3,017.759.33,!

1---

.

1- -

~+--

.~.·_-_-'-_~·.~·.·_··.i'r~' _"_'-"-'~I;=j'~',~57~'~.0~2!;:1l~r'~'~~:·:--!

- -

- 10'14108
11l17/oB
12f1610B

235,615:130
255,:322.70-.

12/16108·
01/1S109
02f17109

88,735.72
97.024.79
'.. 101",6-1-5.22 ~
_ 88,523.02_
.96,515,42_
1.00,039.92
1-03,420.49
101,450.05
.102,-94.3.10
..".~ \-16,784.2'

08113108
09114108

·268,~91.32

1-11-17108

I

I

250,685.04
263,~65.06

$
$

I

~i~~b:er-=-.----.-_-~I=I-_-.-_·__~-.-.-.--.jl-.--::::::-:::-;;;;
=~~;;er=_~-===r-f_·-~~:~ ~.--=:.- _L=------_---l:··-._-_-.-_
-----1· .....-.-.---

_~~i?~

$

I'

.$:;--i3":~3~96~.9~5~1----_+1-----~---_+---+--_+-----+-----:

I'

--'j;M:;:ay:::-_ _-+i _ _ _ _ _-+-_____--f . - - - - CCA'sfBrush
f18%143%;

08/13/08

09114J08
10/14/08

Amt Invoicad 110
0 Ie ~~ P 'dtil Warrant
by VAC
ue - a \Alt~ al~I_Number

-I

Due Date Date paidl Wa"b''''
Nurn er

~$~~3.~5~16~.8~O~I:-------_i'.--------_+.------~----+-I----~---------11------~-----+-----4

, :
I

. d Amt Invoiced
ecelve
oy VAC

I

October c - - r l - - - - _ + - - - - - i l - - - - November
I
I
I
December
I
March

Date R

R
d
ecelve
238.343.40
244.007.50
240,820.69
217;'71'3.72
228,919.79
232.317.39
243.076.742:30,966.52
220;690-.-85
241,053.95
227,145.78
235,076.58

FY08 carry fO"rward"'.____

I
September.
August

1 Comm,. Amt.

i l '

Totals Due to VAC for private
facilities

Totals Due to VAC

----

j

-~-

~--i---:

I

r·

-l--~~---

-.-..e.-

---- -~

----i--

. .- ·-r:=-~.:·T:-

'

-------

----"

-;~ ---

r'-

l _____ _

,.-

FY 09-10 eeoc INMATE PHONE REVENUE/COMMISSION OFF -SET

I

Debit
Interstatel
CoUect
Revenue

International Total Revenue: Commission
(43%)
USF
less USF
Debit Revenue Total Revenue

liivoice less
Commission)

212,574.44
23,053.20
6,223.47
17,794.56
25,261.94
20,797.24

63,879.32
5,263.91
670.04
6,564.27
4,170.77
3,144.19
(57.29
83,635.21

VAC
coc
Initial/Date
InitiaVDate
Approved
Approved
SG 08-05-09 ,TL 8-13-09
SG08-05-09 :TL 8-13-09
SG 00-05-09 TL 8-13-09
SG 08-05-09 TL8-13-09
SG 08-05-09 TLB-13-09
SG 08-05-09 TL 8-13-09
SG 08-05-09 TL 8-13-09
SG 08-05-09 TL 8-13-09

60,078.03
4,982.64
320.18
4,977.94
5,298.20
2,929.47
(44.93
78541.53

SG 09-09-09 'Tl9-17-09
SG 09-09-09 TL9-17-09
SG 09-09-09 Tl9-17-09
SG 09-09-09 Tl9-17-09
SG 09-09-09 TL 9-17-09
SG 09-17-09 TL 9-11-09
SG09-09-09 TL 9-17-09
'SG 09-17-09 'TL 9-17-09

i

224,934.80
25,903.88 !
7,680.45
17,453.19 .
29,903.47
25,027.57

Jul-09 DOC
Bent
Brush

CEC
Crowley
Kit Carson
Credits
TOTAL

330,903.36

276,453.76
28,317.11 I
6,893.51 I
24,358.83
29,432.71
23,941.43
(5729
389,340.06

501,388.56
54,220.99
14,573.96
41,812.02
59,336.18
48,969.00

7,029.40
608.90
100.76
429.33
587.48
603.32

494.35916
53,612.09
14,473.20
41,382.69
58,748.70
48,365.68

720,243.42

9,359.19 •

710,941.52 I

305,704.85

268,408.61 I
28,530.43 I
6,782.36 I
21,529.40
29,428.39
23,694.55
(44.93)
378,328.81

491,429.38
55,364.01
15,108.11
38,915.66 i
56,693.57 I
48,886.05

6,939.68
601.70
79.79
423.89
576.85
595.16

484,489.72
54,762.31
15,028.32
38,491.77
56,116.72
48,290.89

208.330.58
23,547.79
6,462.18
16,551.46
24,130.19
20,765.08

706,351,85

9,217.05 •

697,179.73 i

299,787.28

451,465.38
50,834.93
14,329.38
35,008.09 I
53,687.37 I
49,385.76

6,183.82
555.58
52.28
334.25
516.67
599.21 .

445,281.56
50,279.35
14,277.10
34,673.84
53,170.70,
48,786.55

,

I

223,020.77 !
26,833.58 '
8,325.75 i
17,386.26
27,265.18
25,191.50

- Aug-09 DOC
Bent
Brush

CEC
Crowley
Kit Carson

Credits
TOTAL

.

i
i

328,023.04

i

207,403.97
24,692.09
7,590.94
16,847.26
26,383.75
25,113.80

I
Sep-09 DOC
Bent
Brush

CEC
Crowley
Kit Carson

Credits
TOTAL
lstQIr

,

308,031.81
985,958.21

OffoSet (Oebit

244,061.41 I
26,142.84 :
6,738.44
18,160.83
27.303.62
24.271.96
146.95
346,632.15
1,114,301.02 i

,

I

654,710.91
2,081,306.18

646,469.10 I
I
I
26,818.05 I 2,054,590.35 I
8,241.81 I

191,471.07
21,620.12
6,139.15
14,909.75 '
22,863.40
20,978.22
277,981.71
883,473.85 ,

Prepared by user 7113/2010

52,590.34 ,AG 10-06-09 TL 10-15-09
4,522.72 lAG 10-06-09 TL 10-15-09
599.29 AG 10-06-09 TL 10-15-09
3,251.08 AG 10-06-09 'TL 10-15-09
4,440.22 AG 10-06-09 TL 10-15-09
3,293.74 AG 10-06-09 TL 10-15-09
(46.95) AG 10-06-09 Tll0-15-09
68,850.44 AG 10-06-09 TL 10-15-09
230,827.17

I

1

Private Site
80% or 82%

I DOC 20% or
18%

18,903.62
5,103.25
14,235.65
20,714.79 I
17,053.74

4,149.58
1,120.22
3,558.91
4,547.15
3,743.50
17,119.36

76,011.05
I

19,309.19 i
5,298.99
13,241.17
19,786.76
17,027.36

4,238.60
1,163.19
3,310.29
4,343.43
3.737.72

74,663.47 I

16,793.23

17,728.50
5,034.10
11,927.80
18,747.99
17,202.14

3.891.62
1,105.05
2.981.95
4,115.41
3,776.08

70,640.53 i

15,870.11

I
221,315.04 !

49,782.71

Page 1

·

FY 09 10 CDOC iNMATE PHONE REVENUElCOMMlSSION OFF-SET
!
Debit

I Interstatel
Collect

Off..set (Debit

International Total Revenue
Debit Revenue Total Revenue
USF
lessUSF

Commission
(43%)

Kit Carson

Revenue
204,071.88
26,634.48
7,229.76
18,154.80
29,441.18
25,094.82

Credits
TOTAL

310,626.92 ,

372,786.98 :

683,465.17

207,342.28 :
26,394.36 :
6.495.04 I
18,748.28 I
30,524.94
23,920.09

256,175.47 '
26,411.17
6,207.95
20,630.88
29,047.71
22,088.13
(20.21)

463,517.75
52,805.53
12,702.99
39,379.16
59,572.65
46,008.22

313,424.99

360,541.10

673,986.30

8,329.83 .

665,656.47

286,232.28

Kit Carson

219,821.50
25,574.86
5,535.48
16,624.42
29,163.51
21,736.29 ,

506,223.84
49,798.98
12,673.83
33,653.77
59,295.77
44,552.01

7,216.27
515.00
65.66
382.00
571.21
556.68

499,007.57
49,283.98
12,608.17
33,291.77
58,724.56
43,995.33

214,573.26
21,192.11
5,421.51
14,315.46
25,251.56
18,917.99

Credits
TOTAL

286,402.34
24,224.12
7,138.35
17,029.35
30,132.26
22,815.72
(32.21)

318,456.06

387,709.93 :

706,198.20

9,286.82

696,911.38

299,671.89

I 2,063,849.67

26,078.36

2,037,571.31

876,155.67

Oct·09 DOC
Bent
Brush
CEC
Crowley

Nov-09 DOC
Bent
Brush
CEC
Crowley

Kit Carson
Credits
TOTAL
Dec-09 DOC
Bent
Brush
CEC
Crowley

:,

I

262,962.65
28,694.73
7,228.98
20,876.84
29,708.32
23,366.73 :
(51.27):

467,034.53
55,329.21
14,458.74
39,031.64
59,149.50
48,461.55

I
I
!
:
:
:

i
1

6,279.01 ;
600.141
76.391
414.10
525.77
566.30

460,755.52
54,729.07
14,382.35
38.617.54
58,623.73
47,895.25

198,124.88
23,533.50
6,184.41
16,605.54
25,208.20
20,594.96

8481.71

675,003.48

290,251.49

6,220.60
574.55
63.14
413.59
485.69
572.26

457,297.15
52,230.98
12,639.85
38,965.57
59,086.96
45,435.96

196,637.77
22,459.32
5,435.14
16,755.20
25.407.39
19,537.46

Invoice less
Commission)

64,837.77
5,161.23
1,044.57
4,271.30
4,500.12
2,771.77
i5127)

DOC
InitiallDate
Approved

AG
AG
AG
AG
AG
AG
AG
82,535,49 AG

1 Hl9-09
11-09-09
11-09-09
11-09·09
11-09-09
11-09·09
11-09·09
11-09·09

VAC
InitiaUDate
Approved

TL 11·18-09
TL 11·18-09
TL 11·18-09
TL 11·18-09
TL 11-18-09
TL 11-18-09
TL 11-18-09
TL 11-18-09

59,537.70
3,951.85
772.81
3,875.68
3,640.32
2,550.67
(20.21)

AG12.16,.Q9 TL 12-15-09
AG 12-16-09 TL 12-15-09
AG 12-16-09 TL 12-15·09
AG 12-16-09 TL 12-15-09
AG 12-16-09 TL 12-15-09
AG 12-16-09 TL 12-15-09
AG 12-16-09 .TL 12-15·09
74,308.82 AG 12-16·09 TL 12-15-09
71,829.08
3,032.01
1,716.84
2,713.89
4,880.70
3,897.73
(32.21)

AG 1·8·10
AG 1·8·10
AG 1·8"10
AG 1-8·10
AG 1-8-10
AG 1-8-10
AG 1·8·10
88,038.04 AG 1·8-10

TL 1-8-10
ITL 1-8-10
iTL 1·8-10
!TL 1·8-10
;TL 1·8-10
tTL 1·8-10
Tl1-8-10
TL 1·8-10

DOC 20% or
18%

Private Site
80% or 82%

19,297.47
5,071.22
13,284.43
20,670.72
16,887.87

4,236.03
1,11:l19
3,321.11
4,537.48
3,707.09

75,211.71

16,914.90

18,416.64
4,456.82
13,404.16
20,834.06
16,020.72

4,042.68
978.32
3,351.04
4,573.33
3,516.74

73,132.40

I

16,462.11

17,377.53
4,445.64
11,452.37
20,706.28
15,512.75

3,814.58
975.87
2,863.09
4,545.28
3,405.24

69,484.57

15604.06

217,838.68

48,981.08

:
2ndQtr

942,507.97

1,121,038.01

Prepared by user 711312010

244,882.34

Page 2

FY 09-10 CDOC INMATE PHONE REVENUE/COMMISSION OFF-SET

Debit

Interstatel
Collect
Revenue

Jan.1°iDOC
CEC
Crowley
Kit Carson
Credits
TOTAL
Feb·10 DOC
Bent

I 203,886.94
25,556.05
5,064.51
16,693.93
28,119.75
21,008.25
300,329.43

Kit Carson

197,235.80
24.865.46
3,781.35
19,065.44
27,384.77
15,506.60

Credits
TOTAL

287,839.42

Brush

CEC
Crowley

International Total Revenue
Debit Revenue Total Revenue

268,374,37
27,373.58
6,029.58
15,904.55
32,139.92
18,898.44
(16.15)
368,704.29
271,655.57
26,689.35
5,787.02
19,357.40
32,858.44
17,869.70
122.54
374,194.94

472,261.31
52,929.63
11,094.09
32,598.46
60,259.67
39,906.69

I

USF
7,285.19 I
649.59

I

69.71 i
416.68 i
687.03
582.37

Commission

less USF
464,976.12
52,280.04
11,024.38
32,181.80
59,572.64
39,344.32

(43%)
199,939.73
22,480.42
4,740.48
13,838.17
25,616.24
16,918.06

669,049.87

9,670.57

659,379.30

283,533.10

468,891.37
51,554.81
9,568.37
38,422.64
60,243.21
33,376.30

7,093.89
618.69
65.01
336.74
634.14
544.89

461,797.48
50,936.12
9,503.36
38,086.10
59,609.07
32,831.41

198,572.92
21,902.53
4,086.45
16,37.7.02
25,631.90
14,117.51

662,056.90

9,293.36

652,763.54

290,688.33

68,434.64
4,893.16
1,289.10
2,066.38
6,523.68
1,980.38
(16.15
85,171.19

DOC
InitiallDate
Approved
AG 2-9·10
AG 2·9·10
AG 2·9·10
AG 2-9·10
AG 2-9·10
AG 2·9·10
AG 2·9·10
AG 2-9·10

VAC
InitiaUDate
Approved
TL 2·9-10
TL 2·9-10
TL 2·9-10
TL2·9-10
TL 2·9-10
TL 2·9-10
TL 2·9-10
TL 2·9-10

73,082.65
4,786,82
1,700.57
2,980.38
7,226.54
3,752.19
122.54)
93506.61

AG3-5·10
AG 3-5·10
AG 3·5-10
AG 3·5-10
AG 3-5·10
AG 3-5·10
AG 3·5-10
AG 3-5-10

TI3-19-10
TI3-19-10
TI3-19-10
TI3·19-10
TI3-19-10
TI3-19-10
TI3-19-10
TI3·19-10

Off-Set (Debit
Invoice less
Commission)

DOC 20% or
18%

Private Site
80% or 82%

I
18,433.94
3,887.20
11,070.54
21,005.31
13,872.81

4,046.46
853.29
2,767.63
4,610.92
3,045.25

68,269.80

15,323.57

17,960,07
3,350.89
13,101.62
21,018.16
11,576.36

3,942.46
735.58
3,275.40
4,613.74
2,541.15

67007.10

15,108.31
I

Mar·10 DOC
Bent
Brush
CEC
Crowley
Kit Carson

Credits
TOTAL
3rd QIr

207,386.71
25,935.42
4,244.65
21,917.00
29,080.00
14,242.47
302,806.25

I 890,975.10

304,811.06
30,647.56
6,617.63
23,404.33
35,417.26
18,703.62
(41.88)
419,559.58
1,162,458.81

512,197.7.7
58,582.98
10,862.28
45,321.33
64,497.26
32,946.09
722,407.71

I
2,063,514.48 I

7,835.26
729.44
82.01
392.46
725.68
572.76
10,337.61
29,301.54

504,362.51
55,853.54
10,780.27
44,928.87
63,7.71.58
32,37.3.33

I
712,070.10 I
I
2,024,212.94 I

216,875.88
24,017.02
4,635.52
19,319.41
27,421.78
13,920.53
306,190.14
870,411.57 i

Prepared by user 711"312010

87,935.18
6,630.64
1,982.11
4,084.92
7,995.48
4,783.09
(41.88)
113,369.44
292,047.24

AG 4·13-10
AG 4-13·10
AG 4·13·10
AG 4·13-10
AG 4c 13-10
AG 4-13·10
AG 4·13·10
AG 4·13·10

TL4-14-10
TL 4·14-10
TL 4·14-10
TL 4·14-10
iTL4-14-10

ITL 4-14-10
ITL 4·14-10
ITL4-14-10
I
I

19,693.96
3,801.13
15,455.53
22,465.86
11,414.83

I
!
!

I
i
I
i

4,323.06
834.39
3,863.88
4,935.92
2,505.70

72,851.31 i

16,462.95

I
208,128.22 I

46,894.83

Pages

FY 09-10

Apr.10 DOC
Bent
Brush
CEC
Crowley
Kit Carson
Credits
TOTAL
May·10 DOC

Bent
Brush
CEC
Crowley
Kit Carson
Credits
TOTAL

Jun·10 DOC
Bent
Brush
CEC
Crowley
Kit Carson
Credits
TOTAL

Collect
Revenue
Debit Revenue
197,865,77
293,739,08
25,098,64
30,770.51
4,148,26
7,862,78
22.261,54
25,099,95
29,594,61
35,495,07
14,630,50
17,465,01
(12,65
293,599,32 I 410,219,75
205.318.17
24,854,24
4,628,17
19,807,05
27,249,88
17,807.43

296,S01,83
31,888,33
6,545,26
25,973,91
35,914,76
19,933,55
(17,92)
416,739,72

299,884,94
199,882,54
21.642,91
2,577,62
18,445,83
23,894,07
16,900,31

275,432,56
28,072,27
4,836,54
22,018,74
30,704,19
16,889,01
(11,92)
377,941,39

283,143.28

ecoe INMATE PHONE REVENUE/COMMISSION OFF·SET

Debit
Off-Set (Debit
Interstatel
International Total Revenue Commission
Invoice less
Total Revenue
(43%)
Commission)
USF
less USF
491,604,85
85,839.81
483,486,68
8,118.17
207,89927 I
55,869,15
7,104,67
55,036,83
832,32
23,865,84 I
11,811,04
5,038,83 I
2,623,95
92,83 i
11,71821
47,361,49
46,644,03
4,957,02
517.46 '
20,142,93 I
792.41 i
65,089,86
7,847,24
64,29727
27,847,83 I
32,095,51
538.74 ;
3,895,60
31,556,77
13,569.41 I
I
(1265
I
703,831,72
692,939,79
297,964.11 I
112,255.64
10,891.93 i
I
I
501,820,00
8,540,38:
493,279,62
212,110,24 I
84,391,59
56,742,57
7,865.25
874,95 I
55.867,62
24,02308 I
11,173,43
11,088,80
4,759,58 I
1,785,68
104.63 I
45,780,96
6,5SO,09
609,29 I
46.171,67
19,423,82 I
63,164,64
919,70 I
62,244,94
9,149.44
26,765.32 I
37,740,98
37,101,82
3,979,77
15,953.78 I
639.16 I
(17.92)
I
704,734,47 I 303035,82
113703.90
716,422.58
11,688.11 I
I
475,115,10
74,549,94
7,946.24 i
467,168,86
200,882,62
49,715,18
21,042,04
7,030,23
780.20 I
48,934,98
7,414,16
7,336,10
3,154,52
1,882,02
78.061
40,464,57
563,35 I
17,157.52
4,861.22
39,901.22
53,784,19
23,127.20
7,576,99
54,598.26
814,07 I
33,789,32
2,585,81
526,07 I
33,263.25
14,303,20
I
(11,921
I
661,096.59
650,388,60
98274,29
10707.99 I
279667.10

I
4th Qtr

876,407.54

1,204,900.86

2,081,350.89

3,676,848,82 i 4,602,698.70

8,279,821.22

i
TOTAL 09-10
i

I
I
i
i

33,288.03 i . 2,048,062,86
880,667.04
I
115,485.98 i 8,164,437.46 3,510,708.12
,
I

Prepared by user 7/13/2010

,
VAC
DOC
InitiallDati!
Initial/Oate
Approved
Approved
AG 5-7-10
ITL 5·13-10
ITL 5-13-10
AG 5-7-10
AG 5-7-10
ITL 5-13-10
TL 5·13-10
AG 5·7-10
AG 5-7-10
TL5·13-10
TL 5-13·10
AG 5-7-10
AG 5-7-10
TL 5·13·10
TL 5·13·10
TL6·15·10
TL6·15·10
TL6·15-10
TL6·15-10
TL6·15-10
TL6·15-10

AG 6-15·10
AG 6-15·10
AG 6-15·10
AG 6-15·10
AG 6-15·10
AG 6-15·10

DOC 20% or
18%

19,405,99
4,131,84
16,114,34
22,671,22
11,126,92

4,259,85
906,99
4,028,59
4,976,61
2,442.49

73,450.31

16,614.53

19,698,93 '
3,902,86
15,539,06
21,947,56
13,082,10

AG 6-15-10
AG 7·12-10
AG 7·12-10
AG 7·12-10
AG 7·12·10
AG 7·12-10
AG 7·12-10
AG 7-12·10
AG 7·12·10

Private Site
80% or 82%

TL 7·13-10
TL 7-13-10
TL 7-13-10
TL 7-13-10
TL 7-13-10
ITL 7-13-10
ITL 7·13·10
ITL 7·13-10

4,324,15
856,72
3,884,76
4,817,76
2,871,68

74170.51

16,755.07

17,254.47
2,588.71
13,726,02
18,984,30
11,728,62

3,787,57
567,81
3,431,SO
4,162,90
2,574,58

64,260.12

14,524.36

i

211,880,94

324,233,82 AG 7-12·10
1,091,990,58 AG 7·12·10
I

47,893.97
I
859,162.87 I 193,552,58
I

Page 4

r)

Q:\CTCF'ACCTNG\GENACCnPratl\CIPS\FY10 CIPS Spreadsheet

FY 10-11

eeoc INMATE PHONE REVENUElCOMM1SSION OFF-SET

Debit
Interstatel
Collect

International

Revenue

Jul-l0 DOC
Bent
CEC
Crowley
Kit Carson
Credits
TOTAL
Aug-l0 DOC
Bent
CEC
Crowley

,

Kit Carson

279,286_00 ,
189,044.77 •
20,394.24
18,603.62
25,910.42
13,503.37 •

Credits
TOTAL

267,455.42 I

;

.

Sep-10 DOC
Bent
CEC
Crowley
Kit Carson
Credits

298,034.62
28,293.23
24,221.95
31,827.39
17,105.38
(8.64
399,473.93
294,694.82
27,077.60
23,599.24
29.385.10 ,
16,739.67 •

I
i

Off-Set (Debit
Commission

33,900.98

USF
7,637.85
673.25
498.63
751.79
473.34

678,768.57
483,739.59
47.471.64
42,202.86
55,295.52
30,243.04

10,034.86
7,529.30
702.86
506.34
651.70
485.02

668,733.71
476,210.29
46,768.98
41,696.52
54,543.82
29,758.02

287,555.50
204,770.43
20,110.66
17,929.50
23,496.64
12,795.95

Debit Revenue Totat Revenue

195,165.24
22,170.56
lS,731.01
26,423.59
16,795.60

Total Revenue

493,199.86
50,463.79
42,952.96
58,250.98

i
less USF
485,562.01 I

49,790.54

i

42,454.33 I
57,499.19
33,427.64

(43%)
208,791.67
21,409.93
18,255.36
24,724.65
14,373.89

(34.09).

Invoice less
Commission)

89,242.95
6,8S3.3O
5,966.59
7,102.74
2,731.49
(8.64
111,918.43
89,924.39
6,966.94
5,869.74
5,868.26
3,943.72
(34.09)
112,358.96

DOC
InitiallDate
Approved
AG 8-11-10
AG 8-11-10
AG 8-11-10
AG 8-11-10
AG 8-11-10
AG 8-12-10
AG 8-11-10
AG 9-21-10
AG 9-21-10
AG 9-21-10
AG 9-21-10
AG 9-21-10
AG 9-21-10
AG 9-21-10

VAC
IniliallDate
Approved
TlS-12-10
TlS-12-10
Tl8-12-10
Tl8-12-10
Tl8-12-10
TlS-12-10
Tl8-12-10
Tl9-21-10
Tl9-21-10
Tl9-21-10
Tl9-21-10
Tl9-21-10
Tl9-21-10
Tl9-21-10
Tl11-19-10
Tl11-19-10
Tl11-19-10
Tl11-19-10
Tl11-19-10
Tl11-19-10
TllO-19-10
TL 10-19-10

391,462.34 •

658,952.85 •

9,875.22

649,077.63

279,103.38

286,647.46 •
24,327.28 :
20,589.94 !
29,852.40
14,670.08 I

468,315.78
43,906.54
39,620.94
52,859.29
25,033.56

7,315.22
592.47
403.43
740.19
412.88

461,000.56
43,314.07
39,217.51
52,119.10
24,620.70

198,230.24
18,625.05
16,863.53
22,411.21
10,586.90

9,464.19

620,271.94

266,716.93

88,417.22 AG 10-19-10
5,702.23 AG 10-19-10
3,726.41 AG 10-19-10
7,441.19 AG 10-19-10
4,083.18 AG 10-19-10
(58.50) AG 10-19-10
109,311.73 AG 10-19-10

29,374.27 I 1,938,083.28

833,375.81

333,589.12 AG 10-19-10

Private Site
80% or 82%

DOC 20% or
18%

17,556.14
14,604.29
20,274.21
11,786.59

3,853.79
3,651.07
4.450.44
2.587.30

I
I
I

64,221.23 !

14,542.60

16,490.74
14,343.60
19,267.41
10,492.68

3,619.92
3,585.90
4,229.43
2,303.27

60,594.43

13,738.52

15,272.54
13,490.82
18,377.19
8,681.26

3,352.51
3,372.71
4,034.02
1,905.64

55,821.81

12,664.88

180,637.48

40,946.00

I
181,668.32
19,579.26
19,031.00
23,006.89
10,363.50

•
:
i

I
I

(58.50)

TOTAL

253,648.97

376,028.66

629,736.13

IstQtr

800,391.39

1,166,964.93

1,967,457.55

Prepared by user H2012012

Page 1

FY 10-11 eDoe INMATE PHONE REVENUEICOMMISSION OFF·SET

Debit
Interstate/

j
Collect
Revenue

Oct-10 DOC
Bent
CEC
Crowley
Kit Carson

191,431,61
22,265.81 ,
16,793.60 I
25,291.74
10,288.13

Credits

266,070_89

TOTAL
Nov-10 DOC
Bent
CEC
Crowley
Kit Carson
Credits
TOTAL
Dec-l0 DOC
Bent
CEC
Crowley

I
:
:

187,770.78
21,834.41
15,619.20
26,503.74
10,174.29
261,902.42

Kit Carson

197,208.20
24,263.30
15,784.64
27,788,60
10,041.65

Credits
TOTAL

275,086.39

2nd Qtr

803,059.70

International

303,163.23
28,598.35
20,874.27
32,742.84
14,599.55
(18,56
399,959,48

I
I

I
I

293,928.40

23,806.25
15,824.90
31.405.08
14,869.89 I
(94.51>1
379,740_01 I
319,419,56 I
30,367,97 i
17,735,73 '
35,383.70
14,541.54
(49_48
417,399_02 I

Off-Set (Debit
Commission

494,594.84
50,864.16
37,667.87
58,034.38
24,687.88

USF
7,316.24
663.02
302.03
704.91
403.79

less USF
I
487,278.60 :
50,201.14
37,365.84
57,329.47
24,483.89

(43%)
209,529.80
21,666.49
16,067.31
24,651.67
10,528.07

666,048,93 :

9,389.99

656,658,94

282,363,34 .

481,699.18 I
45,640.66
31,444.10
57,908.82
25,044.18

7,219.97
572.08
207.21
667.99
379.15

474,479.21
45,068.58
31,236.89
57,240.83
24,665.03

204,026.06
19,379.49
13,431.86
24,613.56,
10,605.96 I

641,736.94

9,046_40

632,690.54

272,056.93

516,627.76
54,631.27
33,520.37
63,172.30 I
24,583.19 I
I
692,534,89 I

I
1,197,098.51

I
i

Debit Revenue Total Revenue

Total Revenue

89,902.34
4,426.76
2,393.04
6,791.52
4,263,93
(94.51
107,683.08

AG
AG
AG
AG
AG
AG
AG

I
I

12-16-10
12-16-10
12-16-10
12-16-10
12-16-10
12-16-10
12-20-10

8,303.49
733.89
258.62
787.38
414.05

508,324.27
53,897.38
33,261.75
62,384.92
24,169.14

218,579.44
23,175.87
14,302.55
26,825.52
10,392.73

10,497.43

682,037.46

293,276,11

100,840.12
7,192.10
3.433.18
8.558.18
4,148.81
(49.48)
124,122.91

28,933.82

1,971,386.94

847,696.38 I

349,402.13 AG 1-13'11

i
2,000,320_76

93,633.43
7,011.86
4,806.96
8,090.97
4,071.48
(18.56
117,596,14

DOC
InitiallDate
Approved
AG 11-23-10
AG 11-23-10
AG 11-23-10
AG 11-23-10
AG 11-23-10
AG 11-23-10
AG 11-23-10

Invoice less
Commission)

Prepared by user 1!2{1/2012

AG
AG
AG
AG
AG
AG
AG

1-13-11
1-13-11
1-13-11
1-13-11
1-13-11
1-13-11
1-13-11

II InitiallDate
VAC
I Approved
ITL 11-23-10
ITL 11-23-10
ITL 11-23-10
ITL 11-23-10
ITL 11-23-10
ITL 11-23-10
ITL11-23-10
TL 12-20-10
TL 12-20-10
TL. 12-20-10
TL 12-20-10
TL 12-20-10
TL 12-20-10
TL 12-20-10
TL
TL
TL
TL
TL
TL
TL

1-13-11
1-13-11
1-13-11
1-13-11
1-13-11
1-13-11
1-13-11

DOC 20% or
18%

Private Site

80% or 82%
17,700.92 I
12,853.85
20,214.37
8,633.02

3,885.57
3,213.46
4,437.30
1,895.05

59,402.16 :

13,431.38

15,891.18 !
10,745.49 !

3,468.31
2,666.37
4,430.44
1,909.07

20.183.12

I

8,696.89 :
I

55,516.68 i

12,514,19

I
I
19,004.21
11,442.04
21,996.93
8,522.04

4,171.66
2,860.51
4,828.59
1,870.69

60,965.22

13,731.45

175,884.06

39,677,03

Page 1

FY 10-11 CDOC INMATE PHONE REVENUEICOMMISSION OFF SET

Ii
Jan·11 DOC
Bent
CEC
Crowley
KitC3rson

I
I
!

Debit
Interstate!
Collect
Revenue

Debit Revenue Total Revenue

186,432.52 !
22,594.27 !
14,402.26
27,075.15
9,950.56

Credits

TOTAL

Off-5et (Debit

International

280,454,7" .

287,615.75
28,538.40
18,017.45
28,503.03
13,868.04
(32.59
376,510,08

474,048.27
51,132.67
32,419.71
55,578.18
23,818.60

Total Revenue

USF
8,617.93 !
786.37 !
337.76 !
725.39 !
434.281

Commission

less USF
465,430.34 !
50,346.30 I
32,081.95
54,852.79
23,384.34

(43%)
200,135.04
21,648.91
13,795.24
23,586.70
10,D55.27

Invoice less
Commission)

87,480.71
6,889.49
4,222.21
4,916.33
3,812.77
(32,59
92

636,997,43

10,901,71

626,095,72

269221.16

476,317.01
48,363,64
35,027.93
59,143.81
22,640.03

8,606.43
702.31
354.35
823.95
399.34

467,710.58
47,;>61.33
34,673.58
58,319.86
22,240.69

201,115.55
20,494.37
14,909.64
25,077.54
9,563.50

641,492.42

10,886.38

630606.04

271160.60

524,366.71
51,210.39
40,487.56
62,808.24
25,476.56

9,625.14
699.35
403.42
901.42
440.58

514,741.57
50,511.04
40,084.14
61,906.82
25,035.98

221.338.88
21.719.75
17,236.18
26,619.93
10.765.47 i

704,349,46

12,069.91 •

692,279.55

297,680,21

33,858.00 • 1,948,981.31

838,061,96

DOC
VAC
Inilial/Date
InitiallDate
Approved
Approved
AG 2·14-11
TL 2·14·11
TL 2-14-11
AG 2·14-11
TL 2-14-11
AG 2·14-11
!TL 2-14-11
AG 2-14·11
AG 2-14-11
iTL2·14·11
AG 2-14-11
TL 2-14-11
TL2-14-11
lAG 2-14-11

Private Site
80% or 82%

DOC 20% or
18%

17,752.11
11,036.19
19,341.09
8,245.32

3,896.80
2,759.05
4,245.61
1.809.95

56,374,71

12,711,41

16,805.36
11,927.71
20,563.56
7,842.07

3,688.99
2,981.93
4,513,96
1,721.43

57,138.75

12,906,30

17,810.20
13,788.94
21,828.34
8,827.69

3,909.55
3.447.24
4.791.59
1,937.78

62,255.17

14,086,16

175,768.63

39,703,87

i
Feb-11 DOC
Sent
CEC
Crowley

183,556.45 1
21,329.14 1
15,702.51
26,922.06
9,334.64

Kit Carson

Credits
TOTAL

:

,

256,846.80

292,758.56
27,034.50
19,325.42
32,221.75
13,305.39
{54.24
384,591.38

91,643.01
6,540.13
4,415.78
7,144.21
3,741.89
(54.24)
113430.78

\G 3-7-11
\G 3-7-11
G 3-7-11
G 3-7-11
AG 3-7-11
AG 3-7-11
AG 3-7-11

!

112,669.94
7,880.24
4,994.97
9,419.07
4,337.69
{30.69
139,271,22

AG
AG
AG
AG
AG
AG
AG

!

359,990,93 AG 4-13-11

..

I

Kit Carson

190,357.89
21,610.40
18,256.41
26,769.24
10,373.40

Credits
TOTAL

267,367,34

Mar-11 DOC
Bent
CEC
Crowley

3rd Qtr

I
1

I
I

784,668,90

334,008.82
29,599.99
22,231.15
36,039.00
15,103,16
(30.69
436,951.43
1,198,052.89

i
1
1,982,839.31 1

Prepared by user 1/20/2012

4-13-11
4-13-11
4-13-11
4-13-11
4-13-11
4-13-11
4-13-11

TL3-11-11
TL 3-11-11
TL 3-11-11
TL3-11-11
TL3-11-11
ITL 3-11-11
ITL 3-11-11
1
TL 4-13-11
TL 4-13-11
TL 4-13-11
TL 4-13-11
TL 4-13-11
TL 4-13-11
ITL 4-13-11
I
ITL 4·13·11

Page 1

FY 10-11 COOC INMATE PHONE REVENUEJCOMMISSION OFF-SET

Collect
Revenue

Credits

I

,

!

International Total Revenue

:DebitRevenue~ Total Revenue

187,122,99 i
20,442,73 .
16,439.51
24,301.45
9,396,50

Apr·ll DOC
Bent
CEC
Crowley
Kit Carson

Debit
Interstatel

I
319,264,44 i
27,500,98 I
21,438,83
34,577.05
13,007.48

506,387A3
47,943.71
37,878.34
58,878,50
22,403,98

USF
9,170,79
644,98
440,81
902.91
340.46

(33,35

Commission

less USF
497,216.64
47,298.73
37,437.53
57,975.59
22,063.52

!

(43%)
213,803.16
20,338.45
16,098.14
24,929.50
9,487.31

I
661,992,01 I
I
499,216.45 I
44,976,83
33,391.42
55,824.15
24,051.72

214,663.08
19,340.04
14,358.31
24,004,38
10,342.24

I

282,708.05

• Off-Set (Debit
Invoice less
Commission)
105,461.28
7,162.53
5,340.69
9,647.55
3,520.17

I

DOC
InitiallDate
Approved
AG 5.17,11
AG 5·17-11
AG 5·17-11
AG 5·17-11
AG 5-17-11
(33.35 AG 5·17-11
131,098.87 AG 5·17-11

VAC
Initial/Date
Approved
TL 5-18-11
TLS-18-11
TL 5-18-11
TL 5-18-11
TL5-18-11
TL 5-18-11
TL 5-18-11

105,304.73
6,713.64
4,801.59
8,259.04
4,801.30
(38.27
129,842.03

AG 6-10-11
AG 6-10-11
AG6-10-11
AG6-10-11
AG6-10-11
AG6-10-11
AG6-10-11

TL 6-14-11
TL 6-14-11
TL 6-14-11
TL 6-14-11
TL6-14-11
TL 6-14-11
TL6-14-11

AG
AG
AG
AG
AG
AG
AG

7-13-11
7-13-11
7-13-11
7-13-11
7-13-11
7-13-11
7-13-11

TL 7-15-11
TL 7-15-11
iTL 7-15-11
iTL 7-15-11
:TL 7-15-11
iTL 7-15-11
iTL 7-15-11

51,642.31

I

11,690.35

iTL 7-15-11

164,929.85

I
I

37,301.19

iTL 7-15-11

I
697,220.02 I 157,628.09

257,703.18

415,755,43

673,491,96

11,499,95

Kit Carson

188,632,78
19,556,60
14,569,.67
24.425A9
9,352.76

508,600.59
45,610.28
33,729,57
56,688,91
24,496.30

Credits
TOTAL

256,537.30 i

319,967.81
26,053.68
19,159.90
32,263.42
15,143.54
(38.27)
412,550.08 :

669,125.65

9,384.14
633.45 i
338,15 ,
864.76 i
444.58 i
I
11,665.08 I

657,460.57

457,169.22
44.294.31
34.063.64
49,146,10
21,804.57

8.442.25
608.45
288.69
746.96
379.26

448,726.97
43,685.86
33.774.95
48,399.14
21,425.31

192,952.60 .
18,784.92 .
14,523.23
20,811.63
9,212,88

10,465.61

596,012.23

256,285.26

100,316,35
6,910AO
3,537.21
7,801,68
3,018.13
(29.45
121,554.32

33,630.64

1,915,464.81 I

823,649.87 i

382,495.22 AG 7-13-11

TOTAL
May-11 DOC
Bent
CEC
Crowley

Jun·11 DOC
Bent
CEC
Crowley
Kit Carson

Credits
TOTAL
4th Qtr

:
:
:

163,900.27 •
18,598.99 i
16,003.20 I
20,532.79 I
9,573.56

I
I 228,608.81
!
I 742,849.29
I

TOTAL 10-111 3,130,969.28

293.268.95
25,695.32
18.060.44
28,613.31
12,231.01
(29.45)
377,839.58
1,206,145.09

606,477.84

I
I

1,949,095.45 I

I

I
4,788,261.42

7,899,713.07 i

I
125,796.73

7,773,916.34

i

284,656.56

I
3,342,784.03 I 1,425,477.39 AG 7-13-11

Prepared by user 1i20/2012

Private Site
80% or 82%

DOC 20% or
18%

16,677.53
12,878.51
20,442.19
7,7.79.59

3,660,92
3,219.63
4,487,31
1,707,72

57,7.77.82

13,075.58

15,858.83
11,486.65
19,683.59
8,480.64

3,481.21
2,871.66
4,320.79
1,861.60

55,509.71

12,535.26

15,403.63
11,618.58
17,065.54
7,554.56

3,381.29
2,904.65
3,746.09
1,658.32

Page 1

~ T.<:ui 1

CIPS

..

and ""

A

~

.• L

i

CIPS Commisions to Accrue

onth
'09

'Collect

$

Debit
'
,
$~~:,~~912
83,921.06 S 124,870.61
81,289,25 S 1:23,481".18

$

78;117.38

$

82;315,59 $ 127,214.21

:

IV

:

S
$
$
$
$
$
$
$

80,741.44
84,799;53

$ 80,185.98
$ 76,930,13
$ ·81,853:90
$ 80.462.89
$ 81,112.10
$ 70,4n.'2 $

larch
'prjl
lay

une

-

T~~'to I

-123;284.62

133,779,91
119,969,08
122,185.42

Q.OO

208,791,67
204,nO.43
198,230.24.
209,529,80

0,00
0,00
0.00
0.00

204,026.06-

-0.00"

$ 218,579,44
$ 200,135.04

0,00
0.00
0,00
' 0:-00·
0.00
0.00

$ 2D1,115.55
$ 221,338.88
$ 213,803.1"6
$ 214,663.08
$1.' .",60

1-39;484.98

133,340.27
133,550.98
1??47'"

I

200,882.1)2

$
$
$
$
$
$

120,112:.86

Current
Accrue

Comm.Aint
Recel_

IDate

~~:::~

208,791.67

10/15110
11/15110
121-13110
0111411-1

204,770A3

198,230.24
209,529.80

, '204,028c06
218,579.44

.' ," :,:'~I~I~'.:·

~.

298,025,98
294;660.73
286,588.96

.

..

201,115,55
221,33S.88
213,803.16
214,663,08

08/15111
07112111

..

..

.
:

3,372,71
, "3.46
,686.37
,880.51
,759,05
,981,93
,447.24
,219.63
871.66

-..
..

March
April
May
June

ICGA (18%0143%1

-

,

I

i

2,904.65

11,092.88

, fOIWlf(i:

luly
luous.
'.17
'.92

" '.•'
1<

rv

-

i

:

1.94

',952.36
$
I=@95

8.785.70

I

Q:\CTCF\ACCTNG\GENACCnPraH\CIPS\FY11 CIPS Spreadsheet

I

I

I':'~~

';!!!!I!;j:

'!~

,

:j!W;,
"'1~!,~,

.', .

','

10115/10

,},vl 5J l0 '

02114111
03116111

:

,

0511B!1-1-" 06115111

319,23H19

- -~:- 071121t1

31S;92,9.S4

'!'Jl!Hi

.'''!;;~i:'

01114i1'i·
;'-04/13111

"'L'

'. ,.,,!,

,d""

12113/10

303;;144,~7

.

~ii!j>r'

.[V .

11115/10

293,833C89
02114111
311,116.07
0311611'. t :-:-,' ,.267;583-.'.6:
04114/1'1
292,704.32
0511611-1 333,978.13-

200,135.04

~~;:;1~

1=::": m:,!'

L

,

~'l;lf
...C·

I

Jan~ry_

~J\

:.>

!'Y,VAC .:

I

>etob.,

Ian

And I~OI.i:.d· IDueoal.1 >!.

...:;;.

.

',. ""'" ~.!, 'I:'..

Totals O.ue to VAC

:H:i:r;{j:!l ~1

FY2012 CIPS Accruals and Payment Spreadsheet
CIPS Commisions to Accrue
Due Per Sue//VAC Reports
Month
FY11 CarryOver
July
August *
September
October
November
December
January
February
March
April
May
June

$
$
$
$
$
$
$
$
$
$
$
$

Collect
70,477.12
72,816.69
54,565.00
68,922.25
66,197.45
73,726.63
67,632.94
70,082.11
75,972.55
63,362.36
68,996.39
67,607.00

$
$
$
$
$
$
$
$
$
$
$
$

Debit
122,475.48
125,796.88
99,743.30
121,440.21
118,033.61
128,191.83
120,209.74
126,579.39
129,316.44
137,250.12
137,113.85
133,079.76

Current
Amount to
Accrue
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
206,110.24
200,686.76
0.00
$406,797.00

Total Due to
DOC
$ 192,952.60
$ 198,613.57
$ 154,308.30
$ 190,362.46
$ 184,231.06
$ 201,918.46
$ 187,842.68
$ 196,661.50
$ 205,288.99
$ 200,612.48
$ 206,110.24
$ 200,686.76
$
-

Totals
Addit'l Accruals:
CMRC(20%of43%)
July
August *
September
October
November(18%)
December
January
February
March
April
May
June
CCA (18%of43%)
July
August *
September
October
November
December
January
February
March
April
May
June
Total JV Accrual:

FY11 carry forward:

$

FY11 carry forward:

Totals Due to VAC for private
facilities

Totals Due to VAC

Comm. Amt.
Received
192,952.60
198,613.57
154,308.30
190,362.46
184,231.06
201,918.46
187,842.68
196,661.50
205,288.99
200,612.48

$1,912,792.10

2,793.69
2,681.46
-

$
$
$
$
$
$
$
$
$
$

2,904.65
3,110.20
2,075.15
2,443.99
2,370.24
2,515.41
2,473.80
2,583.20
2,884.98
2,710.64

8,488.81
8,390.79
429,151.75

$
$
$
$
$
$
$
$
$
$

8,785.70
9,405.74
7,541.52
9,684.60
9,318.36
9,661.09
9,475.25
9,227.22
8,949.14
8,273.81

$2,029,186.79

T:\telephone project\2012 phone research\Records obtained\CO\colorado FY12 CIPS Spreadsheet

Date
Received
08/16/11
09/14/11
10/28/11
11/17/11
12/15/11
01/17/12
02/14/12
03/13/12
04/16/12
05/15/12

Amt Invoiced
by VAC
$

293,239.50
301,207.63
239,078.55
290,990.82
282,794.04
307,125.78
287,979.22
303,203.56
309,446.05
287,831.44

$ 2,902,896.59

Due Date Date Paid

Warrant
Number

Amt Invoiced
by VAC

Due Date Date Paid

84,600.08
91,314.99
68,463.51
87,791.06
85,057.85
85,676.52
89,842.69
87,121.50
86,984.66
77,068.02

08/16/11
09/14/11
10/28/11
11/17/11
12/15/11
01/17/12
02/14/12
03/13/12
04/16/12
05/15/12

08/16/11
09/14/11
10/28/11
11/17/11
12/15/11
01/17/12
02/14/12
03/13/12
04/16/12
05/15/12

$

Warrant
Number

843,920.88

* Note: A new cut-off date of the 25th was implemented in August by the CIPS
provider. This reduced the dollar activity for August to only 25 days
of activity instead of 31. Future months will have full month activity,
from the 25th of the prior month through the 25th of the month posted.