HomeMy WebLinkAbout5.1 Monthly Financial Report - July 2019 9/3/2019 BoardDocs®Pro
IL
Agenda Item Details
Meeting - REGULAR MEETINGI - .
Category 5. CONSENT AGENDA
Subject onthly Financial Report - July 2019
Access Public
Tye Action (Consent)
Recommended cin Accept the monthly financial report for July 2019.
Public Content
Information
The monthly financial report includes a Cash and Investment Position Report and Fund Budget Revenuen
Expenditure ries for the month endedJuly 30, 2019.
Alternatives
. Accept the monthly financial report for July-2019.
2. Action at the discretion of Village Board.
Staff Recommendation
Staff recommends the Village Boardaccept the monthly financial report for July 30, 2019.
07 July Board Reports for Upload pdf (357 KB) Treasurer's Report - - ,
385 KB)
Administrative Content
Executive Content
All items under Consent Agenda areconsidered routine by the Village Board andwill be enactedy one motion. There
will be no separate icion of those items unless a Boardmember or member from the audience so requests, in
which the item will be removed from the Consent Agenda and considered in its sequence on the agenda.
https://go.boarddocs.com/il/vomp/Board.nsf/Private?open&login# 1/1
VILLAGE OF MOUNT PROSPECT
BUDGET REVENUE
EXPENDITURE SUMMARIES
July 1 -July 31, 2019
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIIIFiscaIIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlr1lig
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
II S.,iii..i
W°. Geiiiisiir111111"""'kiiin
REVENUE
Ill...,a (s 16 498 000.00 .00 16 498 000.00 21910f343.41 .00 11 956 070.05 4 541 929.95 72 12 969 520.60
((Dfl'iei 1 axes 8,033,000.00 .00 8,033,000.00 (102,099.04) .00 2,732,854.44 5,3001145.56 34 4,108,527.35
Illliiciins s, 84, 1,362,000.00 .00 1,362,000.00 121,136.48 .00 1,113,907.19 248,092.81 82 921,931.00
fl,,all II R ^Illm�llle 27,872,000.00 .00 27,872,000.00 (1,185,456.20) .00 12,085,413.06 15,786,586.94 43 16,231,788.21
Iliaiii.g s VFoiiiSeii ices 11209,000.00 .00 1,209,000.00 1271144.07 .00 5871468.98 621,531.02 49 460,401.98
11 1iiiiries&.Il oii.ciiiiws 432,000.00 .00 432,000.00 321441.92 .00 159,924.40 272,075.60 37 222,854.77
11]-m �St']iTiecrit[ricoi�'ne 266,100.00 .00 266,100.00 31,099.45 .00 294,959.84 (28,859.84) 111 159,917.98
Ilircliiiiirrlllsiiiii sciiiciii mks 190,500.00 .00 190,500.00 121299.52 .00 139,575.22 50,924.78 73 97,757.98
fllhm!fl,-li :iirILKI 256,300.00 .00 256,300.00 24,341.35 .00 201,993.56 54,306.44 79 356,058.98
d'ieiii-Fiiiriiaiiriiciiiriig SGiiLfl,c&, .00 .00 .00 .00 .00 .00 .00 +++ (20.00)
REVENUE TOTALS $56,118,900.00 $0.00 $56,118,900.00 $1,971,250.96 $0.00 $29,272,166.74 $26,846,733.26 52% $35,528,738.85
II
iiriiiid WJ. GeIriellr 111111 Ill..., i:: s $56,118,900.00 $0.00 56,118,900.00 $lf97lf250.96 $0.00 29,272,166.74 $26,846f733.26 $35f528f738.85
1
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
IL 7 111111 t llll t ii 'ii
�.,�iir,.m �� iiie
REVENUE
IIG:iiillliii" Ill...,a (s 21434,000.00 .00 2,434,000.00 403,144.19 .00 1,771,533.85 662,466.15 73 1,740,918.89
((Dfl'ieiii Ill..., es 1,024,578.00 .00 1,024,578.00 527,033.07 .00 969,650.76 54,927.24 95 665,224.32
i:iirmi:eiii e Bili�ir�ir meiirmi::III Ili a eiirImLle 1,573,650.00 .00 1,573,650.00 3,608.76 .00 86,553.70 1,487,096.30 6 109,988.37
a:iii�'iiw'ne 51000.00 .00 5,000.00 8,470.57 .00 50,330.33 (45,330.33) 1007 5,521.37
01111th°iewiii.IlR eiir°mii.j .00 .00 .00 .00 .00 .00 .00 +++ .00
i.alh..meiir.Il iiiiiria�iriciiiirig Sojirces 790,000.00 .00 790,000.00 .00 .00 .00 790,000.00 0 .00
REVENUE TOTALS $5,827,228.00 $0.00 $5,827,228.00 $942,256.59 $0.00 $2,878,068.64 $2,949,159.36 49% $2,521,652.95
IIF tj iirid 002, IIII't6lll°t iiiY 111111"""" iiiis IL..,.
i I�.�i..as $5,827,228.00 $0.00 $5,827,228.00 $942,256.59 $0.00 $2,878,068.64 $2,949,159.36 $2,521,652.95
2
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII �FiscaeaIr t", ��� IIIIIi��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
II
� id 02,0IIII'iiiii
REVENUE
fllll iii....IIL..,a° � 11370,000.00 .00 1,370,000.00 (591,840.00) .00 .00 1,370,000.00 0 854,100.00
Ili a eii-iLle .00 .00 .00 .00 .00 .00 .00 +++ .00
a:iirwestirneiiiit a:ixo� ir'ne 20,000.00 .00 20,000.00 2,754.04 .00 19,611.85 388.15 98 11,698.53
112eliiiirslllsiii siirsiiris .00 .00 .00 .00 .00 .00 .00 +++ .00
01111th°iewiii.Ile emii mii.je 2,000.00 .00 2,000.00 .00 .00 .00 2,000.00 0 .00
i.alhiem iir..Il iiiiiria�iriciiiirig iijji c s 750,000.00 .00 750,000.00 .00 .00 .00 750,000.00 0 .00
REVENUE TOTALS $2,142,000.00 $0.00 $2,142,000.00 ($589,085.96) $0.00 $19,611.85 $2,122,388.15 1% $865,798.53
Il j.ji'd 02,0 CaIpkaVl IIL..,oCalls $2,142,000.00 $0.00 $2,142,000.00 ($589,085.96) $0.00 $19,611.85 $2,122,388.15 $865,798.53
3
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
IR.,r iir,.i 2 lire 'IIID iiii�Illl iiiii
miiii��^iiiir� iiiirwiiiru
REVENUE
fllll iii....Ill...,r° � 21085,000.00 .00 2,085,000.00 471752.71 .00 908,218.47 1,176,781.53 44 1,207,684.27
Ill.....iiiceins s,II[)&,iii°rsiiits&II �s 1,650,000.00 .00 1,650,000.00 24,668.50 .00 1,462,431.00 187,569.00 89 1,535,997.00
i:iir mi: iii 2 viii iir iir m iir mi:r:111 II.eveiir Im Lle .00 .00 .00 .00 .00 .00 .00 +++ 22,733.81
11 1iiiir-ies&Il iii-f iiii::s .00 .00 .00 .00 .00 .00 .00 +++ .00
a:iirwesl,]"n miiriI.:a:iir°Io:�Ir 6,000.00 .00 6,000.00 31237.65 .00 11,986.63 (51986.63) 200 3,957.43
Ilii. liiiir"rmlll`,,X.vir s iiri-ieiri s .00 .00 .00 .00 .00 6,297.35 (6,297.35) +++ .00
01:111-ieir II. iri�ie 30,000.00 .00 30,000.00 785.20 .00 12,252.68 17,747.32 41 187,580.52
i:;llliieii-111iiiinam inciiiiri Nj.jii(-.es .00 .00 .00 .00 .00 .00 .00 +++ .00
REVENUE TOTALS $3,771,000.00 $0.00 $3,771,000.00 $76,444.06 $0.00 $2,401,186.13 $1,369,813.87 64% $2,957,953.03
FLAICI 02,3 S,tiree't Cmns,tiiiruc111111'uuiiiii ...Ill..., iallls $3,771,000.00 $0.00 $3,771,000.00 $76,444.06 $0.00 $2,401,186.13 $1,369,813.87 $2,957,953.03
4
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIIIFiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
IR.,ur id 02,4111111""""Illllr r r Cr uuatur6llll Co,risturuic,timn 111111"""'a uu
REVENUE
fllll(,r...IIL..,a° ~� 345,422.00 .00 345,422.00 (149,222.31) .00 .00 345,422.00 0 189,216.00
a:ur mi:;eur 2rr Bur ur mui°eeur mtslll Il e eru-IL,Ie 21000,000.00 .00 21000,000.00 .00 .00 .00 21000,000.00 0 .00
Oh&, es Il Bus eur- iiices 40,000.00 .00 40,000.00 986.00 .00 23,219.00 16,781.00 58 121202.00
a:urm esi:��urrrr urmi::a:ur'iis�� 'ne 12,000.00 .00 12,000.00 11611.48 .00 11,361.13 638.87 95 91559.17
Ilt;wliiurm°Illuuimsmurmur°mi:s 20,000.00 .00 20,000.00 .00 .00 91907.28 10,092.72 50 20,000.00
i..Ilhieur..Il iiiuria�riciiurig Soiurjices .00 .00 .00 .00 .00 .00 .00 +++ .00
REVENUE TOTALS $2,417,422.00 $0.00 $2,4171422.00 ($146,624.83) $0.00 $44,487.41 $2,372,934.59 2% $230,977.17
Iluuid 02,4 1111 VIII uwiatur wlllll Cmns,turuc,tiouuri tunIIL..,oul:alls $2,417,422.00 $0.00 $2,4171422.00 ($146,624.83) $0.00 $44,487.41 $2,372,934.59 $230,977.17
5
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlr1lig
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
IR.iir id 02,,5 111111° IIIII'iiiii e
IIII�Ii'iiiii 'iiiiiiiiis iiiiss°tiiii
REVENUE
88,000.00 .00 88,000.00 59,865.17 .00 4621714.77 (374,714.77) 526 .00
Ilii.cliiiii'nLx.vi-sei'neirits .00 .00 .00 .00 .00 .00 .00 +++ .00
d'ec-,Ili. ii iije .00 .00 .00 .00 .00 .00 .00 +++ .00
oii.tii°c s .00 .00 .00 .00 .00 .00 .00 +++ .00
REVENUE TOTALS $88,000.00 $0.00 $88,000.00 $59,865.17 $0.00 $462,714.77 ($374,714.77) 526% $0.00
IlFiwwll 02,,5 111111° IIIII'iiiii "'iiiiiiiir 11111191�1iiiilllll s $88,000.00 $0.00 $88,000.00 $59,865.17 $0.00 $462,714.77 ($374,714.77) $0.00
Illllh°°°
m �w
6
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
II Sid 040 IIIIt. Raulse 1111'�Mslpo,saVl 111111""""uu uur�
REVENUE
II[,ui- 111 :I Ill...,a (s .00 .00 .00 .00 .00 .00 .00 +++ .00
Ilh&,des II qui.S&rvics 41194,500.00 .00 4,194,500.00 283,517.24 .00 2,402,372.27 1,7921127.73 57 2,372,281.77
111iiuiies IlFo eiii1.5 37,000.00 .00 37,000.00 5,203.71 ,
.00 19f949.98 17 050.02 54 22f555.27
a:ui�'iiwne 5,000.00 .00 5,000.00 1,212.07 .00 71138.70 (21138.70) 143 5,188.27
Ilii.;wliiurm°Illuuissmurmmur°mi:s 1,000.00 .00 11000.00 159.51 .00 381.95 618.05 38 427.50
i.11 ieur..Il.e eurim ie 1341220.00 .00 134,220.00 10,003.79 .00 76,004.10 58,215.90 57 68,798.01
REVENUE TOTALS $4,371,720.00 $0.00 $4,371,720.00 $300,096.32 $0.00 $2,5051847.00 $1,865,873.00 57% $2,469,250.82
Il t iid 040 IIIII °suii e I111')islpos4l 111111"""" iiiis IL..,.
�.�i..as $4,371,720.00 $0.00 $4,371,720.00 $300,096.32 $0.00 $2,505,847.00 $1,865,873.00 $2,469,250.82
7
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaIIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
II Sid 041. lfttmr 111111'ij6l"""111111"""ate 111111' iii iiia
REVENUE
IIC. �����,�mulje 11400,000.00 .00 1,400,000.00 100,167.95 .00 656,559.77 743,440.23 47 676,727.66
11] esbi'neiiriit a:iirxoc ir'n 20,000.00 .00 20,000.00 3,056.35 .00 16,684.77 31315.23 83 18,050.29
IIR,e i rn lb u iiia-,seiii me1.5 15,000.00 .00 15,000.00 .00 .00 1,728.50 13,271.50 12 5,702.10
01:�1,-ieiii-,IIReveiii�'rme .00 .00 .00 .00 .00 .00 .00 +++ .00
REVENUE TOTALS $1,435,000.00 $0.00 $1,435,000.00 $103,224.30 $0.00 $674,973.04 $760,026.96 47% $700,480.05
IL.... 1, lfttmr ate 111111'um„m ini w ...IIL.., iw.alll $1,435,000.00 $0.00 $1,435,000.00 $103,224.30 $0.00 $674,973.04 $760,026.96 $700,480.05
g
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
Ili.,iir and 042,
.�IIIIII''�tllllllll��°
REVENUE
II. �����,�m�je 275,649.00 .00 275,649.00 214,033.66 .00 214,033.66 61,615.34 78 31,978.99
a:iirwesbi'nem iriit a:iirxoc ir'n .00 .00 .00 .00 .00 .00 .00 +++ .00
diem ii-IIR,evelir ii.j 90,000.00 .00 90,000.00 .00 .00 99,226.14 (91226.14) 110 46,610.00
REVENUE TOTALS $365,649.00 $0.00 $365,649.00 $214,033.66 $0.00 $313,259.80 $52,389.20 86% $78,588.99
Il m.t iin(I 042, l..., i:: llI,
365,649.00 $0.00 $365,649.00 $214,033.66 $0.00 $313,259.80 $52f389.20 $78,588.99
9
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
R.iir,.i 3 Assert Seizitre
REVENUE
11 1iiiii s 89,Il iI'Rii"its 10,000.00 .00 10,000.00 .00 .00 11,612.46 (11612.46) 116 91234.13
a:iirwesbi'neirit a:iirxoc ir'n 2,000.00 .00 21000.00 159.20 .00 985.10 11014.90 49 914.63
REVENUE TOTALS $12,000.00 $0.00 $12,000.00 $159.20 $0.00 $12,597.56 ($597.56) 105% $10,148.76
IlFijind 043 set s $12,000.00 $0.00 $12,000.00 $159.20 $0.00 $12,597.56 ($597.56) $10,148.76
°w iiiii �iiii���iiiiiii�m 111111�iiii���iiiiiiii Ill..., i::��
10
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
II S.iir..id 044 1111 de it VIII SIhaire 111111'uu iiiii
REVENUE
11 1iiiii s 89,Il iI'Rii"its 21000.00 .00 21000.00 .00 .00 .00 21000.00 0 .00
a:iirwesbi'neirit a:iirxoc ir'n 200.00 .00 200.00 11.24 .00 75.03 124.97 38 71.31
REVENUE TOTALS $2,200.00 $0.00 $2,200.00 $11.24 $0.00 $75.03 $2,124.97 3% $71.31
Il wi id 111111 dear 111 llllllll 11 iiiii'iiiii°t lllldlllll $2,200.00 $0.00 $2,200.00 $11.24 $0.00 $75.03 $2,124.97 $71.31
111111""""iiiiiii iiiii s
11
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
Ili.iir and 045111111 tiU 'IIII 111111' iiia 111111' iiia
REVENUE
11 1iiiii s 89,Il iii. �ii"its 25,000.00 .00 25,000.00 2,539.11 .00 10,315.08 14,684.92 41 91045.37
a:iirwesbi'neirit a:iirxoc ir'n 500.00 .00 500.00 31.35 .00 207.69 292.31 42 194.32
REVENUE TOTALS $25,500.00 $0.00 $25,500.00 $2,570.46 $0.00 $10,522.77 $14,977.23 41% $9,239.69
Ilii iliid 04'!" ID Ill..., i::��
s $25,500.00 $0.00 $25,500.00 $2,570.46 $0.00 $10,522.77 $14,977.23 $9,239.69
� 111111 �� IIIllllh°°°��������� 111111�iiii���iii�����
12
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
R., id 046 111111"""" iiiii iiiii s 111111""""iiiii iiiii 111111ax IIII� r 111111"""" iiiis
REVENUE
fllll iii....IIL..,a° � 90,000.00 .00 90,000.00 73,751.54 .00 73,751.54 16,248.46 82 51770.96
a:iwesb'ne� iriit a:iirxoc ir'n 4,000.00 .00 41000.00 404.48 .00 21503.57 11496.43 63 21013.11
d'eci-,IlR,eveiir ii.je .00 .00 .00 .00 .00 .00 .00 +++ .00
oii.tii°c s .00 .00 .00 .00 .00 .00 .00 +++ .00
REVENUE TOTALS $94,000.00 $0.00 $94,000.00 $74,156.02 $0.00 $76,255.11 $17,744.89 81% $7,784.07
II �m��lll iim�w Ill..., iw.� s
$94,000.00 $0.00 $94,000.00 $74,156.02 $0.00 $76,255.11 $17,744.89 $7,784.07
�siii111111 �iiiii� iiiii iiiir 111111""""liiiiiir 111111°°° 1111111'" iii� 111111��iiiis
13
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
Il i.,iir and 048 1111'�Ms,t�ric,t111111"""' s
REVENUE
fllll iir....IIL..,a° � 11070,000.00 .00 1,070,000.00 93,370.16 .00 429,151.40 640,848.60 40 439,136.64
a:iirmi:;ciir ciiriirmiii°sciirmtslll II.evBiu-iLle 440,000.00 .00 440,000.00 (46,940.69) .00 143,139.31 296,860.69 33 279,720.00
11] cstirnesiriit a:iirxosir'ne 15,000.00 .00 15,000.00 788.63 .00 5,288.93 91711.07 35 8,340.71
0�1�:;,-msiir-,
ou.tii°.css .00 .00 .00 .00 .00 .00 .00 +++ .00
REVENUE TOTALS $1,525,000.00 $0.00 $1,525,000.00 $47,218.10 $0.00 $577,579.64 $947,420.36 38% $727,197.35
Il siiii(Jl III IIII",;usiih�riess1111111'iiiiis iir'iiiii m 111111'ttrid...III..., i.aIllu $1,525,000.00 $0.00 $1,525,000.00 $47,218.10 $0.00 $577,579.64 $947,420.36 $727,197.35
14
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
Il i.,iir and11111r �11°„'iilll t iii VIII
� i��ri 1111)is'tirict
REVENUE
IIGail-q1 :�'I Ill...,a (s 474,000.00 .00 474,000.00 67,017.76 .00 314,935.73 159,064.27 66 312,597.38
a:iirwes�'ne° iriit a:iirxoc ir'n 10,000.00 .00 10,000.00 11229.62 .00 10,805.11 (805.11) 108 44,844.54
d'eii-,IIR,eveiir ii.j .00 .00 .00 .00 .00 .00 .00 +++ 69,119.54
e��', o�tces 10,000,000.00 .00 10,000,000.00 .00 .00 .00 10,000,000.00 0 71318,879.30
REVENUE TOTALS $10,484,000.00 $0.00 $10,484,000.00 $68,247.38 $0.00 $325,740.84 $10,158,259.16 3% $7,745,440.76
IRwvin(;Jlll 049 1111°)iiiii Illli s"`t airid III 'iiiiiiiri"""111111"""'IIII IIIIII' 1111111'iiiiis°11111°iiiiim°'iiiii t...III...,ot,als $10,484,000.00 $0.00 $10,484,000.00 $68,247.38 $0.00 $325,740.84 $10,158,259.16 $7,745,440.76
15
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
II S.,iii..i
0,50 Wa,teir a iiiirid Seweir
REVENUE
IIGail-q1 :�'I Ill...,a (s .00 .00 .00 (4,054.04) .00 (41298.16) 41298.16 +++ (81746.13)
Ill.....iiiceins s,II[)&,iii°rsiiits&.II �s 20,000.00 .00 20,000.00 11670.00 .00 12,350.00 71650.00 62 121440.00
Oh&,-ges V iii viii- iiic s 15,509,600.00 .00 15,509,600.00 11214,522.44 .00 81345,453.43 711641146.57 54 71939,550.63
11 1iiiir-ies&Il iii-f iiii::s 100,000.00 .00 100,000.00 91655.58 .00 48,526.15 511473.85 49 58,871.46
a:iirwesl,]"n miiriI.:a:iir°Io:�Ir 511100.00 .00 51,100.00 34,812.82 .00 143,794.81 (92,694.81) 281 85,245.42
Ilii. liiiir"rmlll`,,X.virs iiri-ieiri s .00 .00 .00 .00 .00 81100.31 (8,100.31) +++ (11200.00)
01:111-ieir Ili. iri�ie 60,000.00 .00 60,000.00 4,820.00 .00 36,460.00 23,540.00 61 321268.47
i:;llliieii-111iiiinam inciiiiri Nj.jii(.-es 10,200,000.00 .00 10,200,000.00 .00 .00 .00 10,200,000.00 0 .00
REVENUE TOTALS $25,940,700.00 $0.00 $25,940,700.00 $1,261,426.80 $0.00 $8,590,386.54 $17,350,313.46 33% $8,118,429.85
II �iiir 111111'uuiiiir Ill..., iallls $25,940,700.00 $0.00 $25,940,700.00 $1,261,426.80 $0.00 $8,590,386.54 $17,350,313.46 $8,118,429.85
16
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaIIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
II S.,iir,.i °t iiiirs 111111"""" iiiii
�����°, ilii � 111111°� iiiii�llllliiiiiiiiis
REVENUE
fllll iii....IIL..,a° � .00 .00 .00 .00 .00 .00 .00 +++ .00
Ill&,des Il iii,-S&rvics 186,600.00 .00 186,600.00 11,625.60 .00 104,836.45 811763.55 56 111,190.31
a:iirwestirneiiriit a:iirxoeir'ne 31000.00 .00 31000.00 470.26 .00 21601.93 398.07 87 11926.39
01:�1,-ieiii-,IIR.eveiii�'ri�ie 31000.00 .00 31000.00 190.75 .00 11958.95 11041.05 65 11717.10
Vii,
Vii::°m°whim Illiiiir°msii� °mg So�ii.tii°..ccs .00 .00 .00 .00 .00 .00 .00 +++ .00
REVENUE TOTALS $192,600.00 $0.00 $192,600.00 $12,286.61 $0.00 $109,397.33 $83,202.67 57% $114,833.80
IR.iirm °1 ill 111111° iirlllll'iiiiiiiiii t �w iIll...,im 111111' iiiis ...otsllls $192,600.00 $0.00 $192,600.00 $12,286.61 $0.00 $109,397.33 $83,202.67 $114,833.80
m
17
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
II Sid 0,52, 111111 iirlllll iiiu iiiis iiia uu 111111"""" iiiu
REVENUE
fllll iii....IIL..,a° � .00 .00 .00 .00 .00 .00 .00 +++ .00
a:iirmi:;eiii2 eiiiiirmiii°uuiirmtulllII.eveii-IuLle .00 .00 .00 .00 .00 .00 .00 +++ .00
Oh&, es Il eiii eiii- iiic s 156,000.00 .00 156,000.00 13,040.05 .00 91,604.45 64,395.55 59 90,236.85
a:iii�'iiw'ne 1,000.00 .00 11000.00 158.18 .00 11076.21 (76.21) 108 877.94
01111th°iewiii.IlR eiir°mii.j 11200.00 .00 11200.00 115.85 .00 788.90 411.10 66 710.15
i.alh..meiir.Il iiiiiria�iriciiiirig Sojirces .00 .00 .00 .00 .00 .00 .00 +++ .00
REVENUE TOTALS $158,200.00 $0.00 $158,200.00 $13,314.08 $0.00 $93,469.56 $64,730.44 59% $91,824.94
Il j.ji'dP'2 111111 iirlllll'iiiiiiiiu l:e° im IlllllIe eiri Ill...,oi:.allls $158,200.00 $0.00 $158,200.00 $13,314.08 $0.00 $93,469.56 $64,730.44 $91,824.94
18
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlr1lig
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
IL....
� m ' 060 V6hWle
REVENUE
Illi viii-g:s Il(A' 1z3&"Viices 21046,358.00 .00 2 046 358.00 170 529.81 .00 1 193 708.67 852f649.33 58 1 190f482.30
a:iwesb'ne� iriit[irxoc ir'n 6,000.00 .00 6,000.00 464.42 .00 2,705.81 31294.19 45 3,452.09
d'&, IlR,eveiir ii.je .00 .00 .00 .00 .00 .00 .00 +++ .00
oii.tii°c s .00 .00 .00 .00 .00 .00 .00 +++ .00
REVENUE TOTALS $2,052,358.00 $0.00 $2,052,358.00 $170,994.23 $0.00 $1,196,414.48 $855,943.52 58% $1,193,934.39
Il a iiric,]ll 060 V6hWle Ill..., i.allls $2,052,358.00 $0.00 $2,052,358.00 $170,994.23 $0.00 $1,196,414.48 $855,943.52 $1,193,934.39
19
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
II Sid 061. V6III WIIII IIIIII't. IIII VIII � iiiis°t 111111'uiiiiiis
REVENUE
Illi viii-g(,s Il(A' Iz3&" i"'ces 211321100.00 .00 2,132,100.00 177,675.01 .00 1,243,725.07 888,374.93 58 939,924.93
Il iiiiiries&Il viii-feiits 10,000.00 .00 10,000.00 842.28 .00 10,668.67 (668.67) 107 3,511.47
a:iirwestirneiiiit a:ixo� ir'ne 120,000.00 .00 120,000.00 12,707.33 .00 118,535.22 11464.78 99 33,046.57
Ileliiiirslllsiii siirsiiris .00 .00 .00 .00 .00 .00 .00 +++ .00
01111h°ieiiiIlReveii mii.j .00 .00 .00 .00 .00 .00 .00 +++ .00
tllhiem iir..Il iiiiiria�iriciiiirig iijji c s 75,000.00 .00 75,000.00 .00 .00 24,945.00 50,055.00 33 62,012.00
REVENUE TOTALS $2,337,100.00 $0.00 $2,337,100.00 $191,224.62 $0.00 $1,397,873.96 $939,226.04 60% $1,038,494.97
II IIIII'iiiii VIII IIL..,oi::allls $2,337,100.00 $0.00 $2,337,100.00 $191,224.62 $0.00 $1,397,873.96 $939,226.04 $1,038,494.97
20
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
II S.,iir,.i 2
.� iiiii�llll2� iiiii�IIIIII��. IIID
REVENUE
iiai ii-g(,s Il(A' Iz3&"iiic s 162,897.00 .00 162,897.00 13,574.75 .00 95,023.25 67,873.75 58 119,639.87
a:iirwesb'ne� iriit a:iirxoc ir'n 4,000.00 .00 41000.00 907.30 .00 51716.26 (11716.26) 143 21963.07
ialh&, Il liiiir iir cliiiir 2 S0Lfl,c !,)" .00 .00 .00 .00 .00 .00 .00 +++ .00
REVENUE TOTALS $166,897.00 $0.00 $166,897.00 $14,482.05 $0.00 $100,739.51 $66,157.49 60% $122,602.94
Il a iii'idl 2 &iiinIIIIG ''eir Ill..., i::clll� $166,897.00 $0.00 $166,897.00 $14,482.05 $0.00 $100,739.51 $66,157.49 $122,602.94
21
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaIIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s c i c' Prior Year YTD
IL.... rim °t 111111"""" iiiir
� m 3 IIIIII�'.iiiu�� IIII iiia
REVENUE
Illi viii-g:s Il(A' Iz 3&"V"'ces 71429,717.00 .00 7 429 717.00 610f634.16 .00 4 314 318.04 3 115 398.96 58 4 104 367.18
11] esb'neiiriit a:iirxoc ir'n 20,000.00 .00 20,000.00 1,327.69 .00 9,042.55 10,957.45 45 12,837.19
IlR,e i rn 1 u iiia-,seiii ne1.5 2,000.00 .00 2,000.00 171,134.25 .00 196,478.28 (194,478.28) 9824 12,384.63
01:�1,-ieiii-,IIR.eveiii�'rie 1,803,500.00 .00 1,803,500.00 139,342.68 .00 974,666.33 828,833.67 54 989,110.86
REVENUE TOTALS $9,255,217.00 $0.00 $9,255,217.00 $922,438.78 $0.00 $5,494,505.20 $3,760,711.80 59% $5,118,699.86
IL.... �' iiii� iiii°11111°111111'a„iiia w ...Ill..., i.aIllu $9,255,217.00 $0.00 $9,255,217.00 $922,438.78 $0.00 $5,494,505.20 $3,760,711.80 $5,118,699.86
�u iii°"�;� '” 111114.iiiu�s~ VIII m iiiu
22
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII �FiscaeaIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s ci c' Prior Year YTD
IL.
� id 070 1111 ice
REVENUE
Illiia i ��ii- (� ..�Il(A' Iz��:�iii. iii e
.00 .00 .00 .00 .00 .00 .00 +++ .00
a:iirwesbi'neirit a:iirxoc ir'n 3,933,500.00 .00 3,933,500.00 615,014.50 .00 9,254,461.94 (5,320,961.94) 235 2,496,711.07
d'&, IlR,eveiir ii.j 41486,000.00 .00 4,486,000.00 719,482.32 .00 2,996,183.02 1,489,816.98 67 31078,175.54
REVENUE TOTALS $8,419,500.00 $0.00 $8,419,500.00 $1,334,496.82 $0.00 $12,250,644.96 ($3,831,144.96) 146% $5,574,886.61
Il Lflild 070 11126IIII'iiiii m III�)einsi&n k,iiiiind...Ill..., i::a,111� $8,419,500.00 $0.00 $8,419,500.00 $1,334,496.82 $0.00 $12,250,644.96 ($3,831,144.96) $5,574,886.61
23
Revenue Budget by Account Classification
Report
''11 9
Iro u g�h 0 7/3'1
IIIII� �FiscaIIr t", ��� IIIII�i��������� �.
,, IIIIrn a ...isUlrIlIg
Adopted Budget Amended Current Month YTD YTD Budget®YTD %Used/
Account i is ion Budget Amendments Budget Transactions Encumbrances Transactionsr s ci c' Prior Year YTD
IL.
�., id 071. 111111""""iiiiiiiiii 111111)eiiis iiiii iii 111111"""" iiiis
REVENUE
31586,000.00 .00 3,586,000.00 298,938.98 .00 7,671,914.05 (4,085,914.05) 214 2,185,634.35
((Dfl'ieii-Ilii iir-i je 4,095,800.00 .00 4,095,800.00 708,586.86 .00 2,794,872.95 1,300,927.05 68 2,751,387.95
REVENUE TOTALS $7,681,800.00 $0.00 $7,681,800.00 $1,007,525.84 $0.00 $10,466,787.00 ($2,784,987.00) 136% $4,937,022.30
IlFwid 071. 111111 iiiir 111111 nsi&n 111111' Ill..., i:: Ills $7,681,800.00 $0.00 $7,681,800.00 $1,007,525.84 $0.00 $10,466,787.00 ($2,784,987.00) $4,937,022.30
iir..a irmd Ill otals $144,883,991.00 $0.00 $144,883,991.00 $8,052,012.50 $0.00 $79,275,304.87 $65,608,686.13 $80,164,051.99
24
Expense Budget by Account Classification Report
Illlr•°
° Illlrlllll66.
""' ""'
Illlr �'lllll a a IIIb uu 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IR i iiri
0 0�°', Geiiiir""iiir
EXPENSE
IIG`(:.iii.ooiiialll :,iii ii s Wages 27 663 030.00 .00 27 663 030.00 21342,528.84 .00 15 120 515.78 12 542 514.22 55 14 517 658.99
Ill;iii lll�lll III;)&iiel°hills 14 484 814.00 00 14 484 814.00 21019f424.86 00 91300,461.51 5184352.49 64 91663,872.68
Ilfllllllll'aiillllll ( st:s 582,976.00 (21500.00) 580,476.00 311181.26 23,162.54 2671293.68 290,019.78 50 247,801.49
IIGciirmsliiiirm Illiir� 6iis 51819.00 .00 51819.00 499.44 .00 31496.08 21322.92 60 31394.23
iii �sd::ulll S&,vices 81776,475.00 77,000.00 81853,475.00 742,932.59 547,859.08 41546,870.52 31758,745.40 58 412441452.67
uli.:iiillliiii.:iiics 326,724.00 .00 326,724.00 27,363.29 .00 124,020.36 2021703.64 38 106,059.20
1:iii iir&we 549,118.00 .00 549,118.00 45,773.11 .00 320,295.97 228,822.03 58 243,340.15
oirnii iodiilaiies&&u 111 111 lllliiies 832,905.00 10,000.00 842,905.00 65,671.78 39,479.15 357,313.24 446,112.61 47 3811314.84
ialhm&,-Ill; Ill ciiimciliii::u iii;s 11038,741.00 .00 1,038,741.00 11154.44 .00 104,091.18 934,649.82 10 .00
Ill;a liillldliiiiri a:iii 111 iii ciir m iirmmmts .00 12,000.00 12,000.00 364.21 .00 81239.18 31760.82 69 392.16
office 40,430.00 10,000.00 50,430.00 694.18 1,046.25 81963.04 401420.71 20 16,851.13
247,887.00 .00 247,887.00 91790.37 31,942.57 120,951.36 94,993.07 62 149,358.14
III::iiisiwair liil,,Njiw:iiiori Syshnls .00 .00 .00 .00 .00 .00 .00 +++ .00
iire 11319,800.00 456,500.00 1,776,300.00 711202.13 453,423.32 285,058.53 1,037,818.15 42 3051250.86
...Ill...,iii-aiis ciii-s 1,540,000.00 .00 11540,000.00 .00 .00 .00 1,540,000.00 0 .00
EXPENSE TOTALS $57,408,719.00 $563,000.00 $57,971,719.00 $5,358,580.50 $1,096,912.91 $30,567,570.43 $26,307,235.66 55% $29,879,746.54
Il ii.vi id 001 Geirieir4l 111111'Uiiind Ill..., i::allls $57,408,719.00 $563,000.00 $57,971,719.00 $5,358,580.50 $1,096,912.91 $30,567,570.43 $26,307,235.66 $29,879,746.54
1
Expense Budget by Account Classification Report
66,
° IlllrlllllIlllr FiAicYvVIII t"llyllr�116 .1ded
S u IIII'n III, a ll ry I.............JsUIIIig
Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
R iiri2 IIIIII16IIIft Seirvice111111"""" iiiis
EXPENSE
Coiiiiib,-acbjal Sirv"'ces .00 .00 .00 .00 .00 .00 .00 +++ .00
.00 .00 .00 .00 .00 .00 .00 +++ .00
31812,499.00 .00 31812,499.00 .00 .00 571498.16 31755,000.84 2 56018.00
isi"fl, iii-esi::IlflllllllllXlpeiiise 21910,408.00 .00 21910,408.00 .00 .00 11530,280.26 11380,127.74 53 648,467.42
,321i°fl< Fic(.:, l IIF'(: 31500.00 .00 31500.00 .00 .00 428.00 31072.00 12 21835.50
lt,eiirft vric] r&-isfeirs .00 .00 .00 .00 .00 .00 .00 +++ .00
01,11iie�r 111iiiiriairicWliiiing Uses .00 .00 .00 .00 .00 .00 .00 +++ .00
EXPENSE TOTALS
$6,726,407.00 $0.00 $6,726,407.00 $0.00 $0.00 $1,588,206.42 $5,138,200.58 24% $707,320.92
5.vid 002, 111�)6Ift Ser, iii ce111111' s ...Ill...,otals $6f726f407.00 $0.00 $6f726f407.00 $0.00 $0.00 $1,588,206.42 $5,138,200.58 $707,320.92
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66.
""' ""'
Illlr �'lllll a a IIIb uu 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u -YTD / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IR iirid 02,0IIII'iiiiit 111111 IIID iiii�Illl iir ��iiiir 111111"""' uu iiiu
EXPENSE
iiiiibi,-aci::i X111 Sirv"'ces 79,590.00 15,000.00 94,590.00 .00 .00 529.90 94,060.10 1 .00
495,000.00 .00 495,000.00 2,071.63 68,225.26 15,538.74 411,236.00 17 .00
IIL.... iirm2 a:iiillliii ciir 'iirmt 400,000.00 .00 400,000.00 10,000.00 .00 (13,131.20) 413,131.20 -3 .00
III;a liillldliiiir'i a:iiriipiii�ove'neiirits 266,000.00 198,500.00 464,500.00 143.91 67,747.71 47,832.76 348,919.53 25 12,609.31
Office Ilfllllllll';21 a Iii 111`iii�ii eiii°fll:
.00 .00 .00 .00 .00 .00 .00 +++ .00
III"2oi.U� liiilll iii meirit 82,000.00 .00 82,000.00 .00 .00 .00 82,000.00 0 .00
Otlllliieir Ilflllllllll": u 572,100.00 101,500.00 673,600.00 144,945.30 293,669.05 233,882.20 146,048.75 78 138,775.76
708,750.00 545,000.00 11253,750.00 111216.90 338,786.37 190,463.06 724,500.57 42 321,539.23
.00 .00 .00 .00 .00 .00 .00 +++ .00
EXPENSE TOTALS $2,603,440.00 $860,000.00 $3,463,440.00 $168,377.74 $768,428.39 $475,115.46 $2,219,896.15 36% $472,924.30
IFw. id 0' IIII hili 11111'Illi iiiu r mo iiii� ilium t 111111' iuiiiu ill...IIL..,1,,,x111 2 603 440.00 860 000.00 3 463 440.00 168 377.74 768 428.39 475 115.46 2 219 896.15 $472,924.30
�u iir,.m
IIID
3
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66.
""' ""'
Illlr �'lllll a a IIIb 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IR iirid 02,3 tier � t'IIID iiii�Illl iir
�� miiii� iiiirtCoiiis,tiruc
EXPENSE
iiiiibi,-acbjall Sirv"'ces 40,000.00 .00 40,000.00 61707.50 31,853.50 61707.50 1,439.00 96 11,430.00
.00 .00 .00 .00 .00 .00 .00 +++ .00
.00 .00 .00 .00 .00 .00 .00 +++ .00
3,732,000.00 905,000.00 41637,000.00 11273,098.69 2,439,354.82 11426,764.04 770,881.14 83 2,215,762.94
a:iirmi:: iiimiir°mlll...III.,iiimiir°mc iii°mc .00 .00 .00 .00 .00 .00 .00 +++ .00
EXPENSE TOTALS $3,772,000.00 $905,000.00 $4,677,000.00 $1,279,806.19 $2,471,208.32 $1,433,471.54 $772,320.14 83% $2,227,192.94
II °�r t'Illi iiiir� r ciiiii� iiiii t iiiins,t�ir� 111111 riiiic ...Ill..., i,alls 3 772 000.00 905 000.00 4 677 000.00 1 279 806.19 2 471 208.32 1 433 471.54 $772f320.14 $2,227,192.94
' ��m m IIID � m � �
4
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66,
""' ""'
Illlr �'lllll a a IIIb 'lull VIII t, Illlr�1 .1ded
u III° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IR iirid 02,4111111""""VIIIood Ciirvtiir VIII
EXPENSE
iiiiibi,-aci::ijalll Sirv"'ces 120,000.00 .00 120,000.00 13,255.46 37,574.48 411286.44 41,139.08 66 28,087.62
Utilities 3,500.00 .00 3,500.00 11442.56 .00 2,067.75 1,432.25 59 1,711.05
,orni irnodiii:�,iii s&Sqp1plllies 5,000.00 .00 5,000.00 21459.00 .00 2,459.00 2,541.00 49 2,486.20
2,000.00 .00 2,000.00 11000.00 .00 1,000.00 1,000.00 50 1,000.00
01111th°ie,iiim III;2lusliilll iiriie�it°fll: .00 .00 .00 .00 .00 .00 .00 +++ .00
II[,')iist]a liilll°�.ji..iii ori �;�lwein-ls 80,000.00 .00 80,000.00 3,892.50 3,650.00 12,681.25 63,668.75 20 10,824.40
11]1fiir sbn.0.1.iire 3,550,000.00 461,000.00 4,011,000.00 21,000.00 33,015.41 243,691.96 3,734,292.63 7 1311369.97
EXPENSE TOTALS $3,760,500.00 $461,000.00 $4,221,500.00 $43,049.52 $74,239.89 $303,186.40 $3,844,073.71 9% $175,479.24
II
FL,fl,-id 02,4 1111 od Coiivt�riiiii tier a tiiiii c 111111' uiiiis Ill..., t s $3f76Of5OO.00 $461f000.00 $4f221f500.00 $43fO49.52 $74f239.89 303,186.40 $3f844fO73.71 $175f479.24
5
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66,
""' ""'
Illlr �'lllll a a IIIb 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IR iirid 02,,5 111111°' VIII'
.111111""""iiiii iiir IIIIBiiiiii iiiii iiiir
EXPENSE
iiiiibi,-aci::i VIII Sirv"'ces 21316,174.00 .00 2,3161174.00 152,661.13 .00 409,644.08 1,906,529.92 18 36,084.84
22,620,808.00 .00 22,620,808.00 816,115.38 .00 21348,506.16 20,272,301.84 10 .00
III;riirm IIliii 1iiic1ii111111 .00 .00 .00 .00 .00 .00 .00 +++ .00
EXPENSE $24,936,982.00 $0.00 $24,936,982.00 $968,776.51 $0.00 $2,758,150.24 $22,178,831.76 11% $36,084.84
II Lfllc111 02!5 1111° IIIII'iiiii "'iiiiiiiir 11111111''° 'iiiiilllll 'iiiiiiiiii ii °IIID ...Ill...,�i::i:illl $24,936,982.00 $0.00 $24,936,982.00 $968,776.51 $0.00 $2,758,150.24 $22,178,831.76 $36,084.84
111111 ��,
6
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66.
""' ""'
Illlr �'lllll a a IIIb uu 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
Il i iirid 040 I11�teftise 1111'''iiiiisllll s VIII 111111' iiiir
EXPENSE
II['(,N'sooii ulll S(,Nrvics, Ill viii-Hies&Wages 254,632.00 .00 254,632.00 23,815.13 .00 164,972.37 89,659.63 65 146,220.87
Ill;iii lll�lll III;)&iiel°hills 112,676.00 .00 112,676.00 9,557.71 .00 71,368.08 41,307.92 63 67,639.26
i:��llhm&-,Ilfllllllll'aii 111 111 �� ( s���:s 1,350.00 .00 1,350.00 .00 .00 1,350.00 .00 100 481.94
oii-fl,]i-�ad,,uslll Seiiivices 4,084,523.00 55,000.00 4,139,523.00 419,071.36 9,500.00 2,237,070.49 1,892,952.51 54 2,234,069.91
i::liilllliii:aiies 483.00 .00 483.00 12.57 .00 97.15 385.85 20 88.33
1msu.vr..&'ice 6,942.00 .00 6,942.00 578.50 .00 4,049.50 21892.50 58 15,559.25
.'6niirnodliitiics&.9 ilp1plllies 41,579.00 .00 41,579.00 .00 50.00 22,608.70 18,920.30 54 11,524.18
EXPENSE TOTALS $4,502,185.00 $55,000.00 $4,557,185.00 $453,035.27 $9,550.00 $2,501,516.29 $2,046,118.71 55% $2,475,583.74
II 4 502 185.00 $55,000.00 $4,557 185.00 $453 035.27
�uiir�mc IIIIII"�s�°°°ius�IIIIII'1iiullll r 111111'uiiiis ...Ill..., t �� $9f550.00 $2f501f516.29 $2f046JI8.71 $2f475f583.74
7
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66,
""' ""'
Illlr �'lllll a a IIIb uu 'lull VIII Illlr�1 .1ded
u VIII° VIII° a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IR iirid 041. IIIIY t r 111111' VIII"""111111"""ate 111111' iii iiiir
EXPENSE
iiiiibi,-acbjall Sirv"'ces 360,173.00 .00 360,173.00 16,354.92 236,859.75 60,511.40 62,801.85 83 199,156.93
Utilities 200,000.00 .00 200,000.00 55,021.48 .00 83,555.85 116,444.15 42 83,626.48
,orni irnodiii:�,iii s&Sqp1plllies 357,000.00 .00 357,000.00 .00 11,256.17 211,670.21 134,073.62 62 210,076.48
IIY;usiiillldiiiiir'i a:iiriipsii ove'neii it .00 .00 .00 .00 .00 .00 .00 +++ .00
a 111aiie 950,000.00 218,000.00 11168,000.00 296,714.70 5971100.06 448,892.87 122,007.07 90 767,094.00
EXPENSE TOTALS $1,867,173.00 $218,000.00 $2,085,173.00 $368,091.10 $845,215.98 $804,630.33 $435,326.69 79% $1,259,953.89
IIFILA,iid 041. VIIIfttmr VIII"""111111"""ate Ill... isllls 1 867 173.00 $218fOOO.00 2 085 173.00 $368f091.10 845 215.98 $804f630.33 $435f326.69 $1,259,953.89
8
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66.
""' ""'
Illlr �'lllll a a IIIb uu 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
EXPENSE
II['(,N'sooii ulll S(,Nrvics, I4-iies&Wages 37,492.00 .00 371492.00 .00 ,
.00 .00 37f492.00 0 10 920.00
Ill;iii lllslll III;)&iiel°hills 6,157.00 .00 61157.00 .00 .00 .00 6,157.00 0 2,010.37
01.1,i&-, C st:s 1,126.00 .00 11126.00 .00 .00 54.59 11071.41 5 610.75
oii-fl,]i-�ad,,u 111 Seiiivices 320,313.00 .00 320,313.00 155,034.63 .00 214,381.21 105,931.79 67 223,174.87
ulllllllllliii's, 561.00 .00 561.00 .00 .00 .00 561.00 0 10.49
i.alh..ieii III; Ill s iii mrllliiiiw.u.iir s .00 .00 .00 .00 .00 .00 .00 +++ .00
Ill.... iid a:iii 1pr iirneim�s .00 .00 .00 .00 .00 .00 .00 +++ .00
Ilfllll's Iii IIIA Iii iii�� a:iiia Illsiii�u� s�,iii iii mt��
.00 .00 .00 .00 .00 .00 .00 +++ .00
.00 .00 .00 .00 .00 .00 .00 +++ .00
EXPENSE TOTALS $365,649.00 $0.00 $365,649.00 $155,034.63 $0.00 $214,435.80 $151,213.20 59% $236,726.48
5xnd 042, IIIIII IIIIII 1 d i365,649.00 $0.00 $365,649.00 $155,034.63 $0.00 $214,435.80 $151,213.20 $236f726.48
9
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66,
""' ""'
Illlr �'lllll a a IIIb uu 'lull VIII t, Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
L.
I��.iiri 3 se iiiii itr
EXPENSE
tJlliii.Ill;iiillllll Costs 11000.00 .00 11000.00 .00 .00 .00 1,000.00 0 .00
iinl,�],-actual S&rvices 3,000.00 .00 3,000.00 .00 .00 .00 3,000.00 0 7,200.78
,orni irnodiii:�,lii s&Sqp1plllies .00 .00 .00 .00 .00 .00 .00 +++ 13,276.69
3,000.00 .00 3,000.00 11500.00 .00 16,303.77 (13,303.77) 543 10,809.40
EXPENSE TOTALS $7,000.00 $0.00 $7,000.00 $1,500.00 $0.00 $16,303.77 ($9,303.77) 233% $31,286.87
u ium wlll 043 Asst Seizttre111111'a„iiiis Ill..., t,a s $7,000.00 $0.00 $7,000.00 $1,500.00 $0.00 $16,303.77 ($9,303.77) $31,286.87
10
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66.
""' ""'
Illlr �'lllll a a IIIb 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IR iirid 044 1111 �deiir VIII SIIlaire111111' iiiii
EXPENSE
iiiiibi,-acbjall Sirv"'ces 11000.00 .00 11000.00 .00 .00 .00 1,000.00 0 .00
.00 .00 .00 .00 .00 .00 .00 +++ .00
Ilflllllllll: lilllliiim�'iiiA 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00
EXPENSE TOTALS $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 0% $0.00
IL.... it lull llllllll � $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 $0.00
iir°��r� 111111"""" iiiii°t� �miiir 111111��iiiii ��� Ill...,�i::�:�
11
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66,
""' ""'
Illlr �'lllll a a IIIb uu 'lull VIII t, Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IR iirid 045 IIIIII ui 'IIII 111111' iiiis 111111' iiiis
EXPENSE
tJlliii.Ill;iiillllll Costs 11000.00 .00 11000.00 11270.08 .00 21035.66 (1,035.66) 204 550.00
iinl,�],-actual S&rvices 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00
Ilflllllllll: uslilllliii �'iiiA 3,000.00 .00 3,000.00 5,201.24 .00 10,879.19 (7,879.19) 363 3,330.30
������ .00 .00 .00 .00 .00 .00 .00 +++ .00
EXPENSE TOTALS $5,000.00 $0.00 $5,000.00 $6,471.32 $0.00 $12,914.85 ($7,914.85) 258% $3,880.30
IlFiw'id 045111111 uu<fIIII 111111'iiiiis 111111'a„iiiis w ...Ill..., i.aIlls $5,000.00 $0.00 $5,000.00 $6,471.32 $0.00 $12,914.85 ($7,914.85) $3,880.30
12
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66.
""' ""'
Illlr �'lllll a a IIIb uu 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
iirid 046111111"""" lir ilio s 111111""""ilio iiir 111111ax IIII' r 111111"""" iiiis
EXPENSE
tJlliii.Ill;iiillllll Costs 15,000.00 .00 15,000.00 444.70 .00 31765.61 11,234.39 25 2,233.10
iinl,�],-actual S&rvices 10,500.00 .00 10,500.00 .00 .00 4,712.05 5,787.95 45 5,129.40
a:iirisusi'aiiric 500.00 .00 500.00 .00 .00 .00 500.00 0 .00
t r�ir �ir liii:aii s&SqpIIIJlies 13,000.00 .00 13,000.00 .00 .00 .00 13,000.00 0 101512.74
III:'tu liilllciliiiirig a:iir""mimlYii"m iirne'ii"°its 51000.00 .00 5,000.00 .00 .00 .00 5,000.00 0 .00
t italhiemcii III;q.Eiiilll iiffiecirit 24,000.00 .00 24,000.00 .00 .00 .00 24,000.00 0 8,643.60
EXPENSE TOTALS $68,000.00 $0.00 $68,000.00 $444.70 $0.00 $8,477.66 $59,522.34 12% $26,518.84
I �.�ii�a � � II� riiY� l.�t� s $68,000.00 $0.00 $68,000.00 $444.70 $0.00 $8,477.66 $59,522.34 $26,518.84
13
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66,
""' ""'
Illlr �'lllll a a IIIb 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IR iirid 048 1111'�Ms,t�ric,t111111"""' iiiir
EXPENSE
Ill;3,Dlld llciii111 X111 .00 .00 .00 .00 .00 .00 .00 +++ .00
11]'ite;ci-est III; IIIA:miiiiise 1,525,000.00 .00 1,525,000.00 59,381.84 .00 589,743.38 935,256.62 39 579,045.67
EXPENSE TOTALS $1,525,000.00 $0.00 $1,525,000.00 $59,381.84 $0.00 $589,743.38 $935,256.62 39% $579,045.67
Il ium IIIIIIII 'iiiiiiiiii s�111111''1'iiiii i�,iiiir'iiiii 111111'1iiiiiiiii d...III..., tall�� $1,525,000.00 $0.00 $1,525,000.00 $59,381.84 $0.00 $589,743.38 $935,256.62 $579,045.67
14
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66.
""' ""'
Illlr �'lllll a a IIIb uu 'lull VIII t, Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IR iirid 049° 1111 it �IID °t airid I
i��ri111111°°"'IIID
EXPENSE
tJlliii.Ill;iiillllll Costs 21700.00 .00 21700.00 .00 .00 600.00 2,100.00 22 600.00
iinl,�],-actual S&rvices 283,300.00 .00 283,300.00 35,083.56 50,980.56 129,571.75 102,747.69 64 222,272.31
,orni irnodiii:�,iii s&Sqp1plllies 1,500.00 .00 1,500.00 .00 1,500.00 0
.00 .00 .00
2,699,000.00 95,500.00 2,794,500.00 221793.83 70,882.50 440,476.72 2,283,140.78 18 5,999,752.29
Ill..... iirxlll[:-q11 ii eiir" iii"fl.s .00 709,500.00 709,500.00 5,145.40 .00 8,595.40 700,904.60 1 .00
11113ujiilll 'iiiiiri a:iiismlll iii ciii m iiimiws 6,000,000.00 .00 6,000,000.00 16,342.87 215,817.80 32,682.20 51751,500.00 4 .00
11]11frasbn.0..ul.iire 810,000.00 .00 810,000.00 .00 .00 .00 810,000.00 0 .00
Ill;tiii IIGiii liii mcliilll 'III .00 .00 .00 .00 .00 .00 .00 +++ .00
a:ini:;ei-cosi:III; p(,Nii se 432,738.00 .00 432,738.00 .00 .00 216,368.38 216,369.62 50 71,273.25
Ill;3a"', 8t Il iiiscslll 11Fe'ss .00 .00 .00 .00 .00 225.00 (225.00) +++ .00
.......IIL'iii��
.00 .00 .00 .00 .00 .00 .00 +++ .00
EXPENSE TOTALS $10,229,238.00 $805,000.00 $11,034,238.00 $79,365.66 $337,680.86 $828,519.45 $9,868,037.69 11% $6,293,897.85
IlFuiiimr 111111iiiu IIII 't' iiiic VIII 'iiiiiiiiu """111111"""'IIIII;IIIIII'°°°111111''it'iiiiiliiiuiiil Ilctslll $10,229,238.00 $805,000.00 $11,034,238.00 $79,365.66 $337,680.86 $828,519.45 $9,868,037.69 $6,293,897.85
15
Expense Budget by Account Classification Report
Illlr°
° Illlrlllll66.
""' ""'
Illlr �'lllll a a IIIb uu 'lull VIII t, Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
Il iirid 0,50t iir airid Seweir 111111"""'u u iiiir
EXPENSE
IIC`(,iii.ooii ulll :,iii ii ,SaI4�-ies&Wages 21199,835.00 .00 2 199 835.00 171 380.26 .00 11241,924.52 957 910.48 56 11295,798.51
IIC;iii Ill�lll IIC;t&iiel°iii1,s 8711240.00 .00 8711240.00 711796.65 .00 523,488.10 3471751.90 60 567,538.60
i:��llCm iiiIICIIIIIIII'aii Ill 111 (, st:s 441464.00 .00 441464.00 380.28 .00 31,867.19 12,596.81 72 33,632.71
oii-fl,]i-ad,,uslll Seiiivices 91174,756.00 50,000.00 91224,756.00 730,157.02 319,667.82 41480,081.65 41425,006.53 52 41403,973.87
tti::Iiilllliii:;liies 1621710.00 .00 1621710.00 23,972.84 .00 46,052.53 116,657.47 28 68,992.72
1msu.vr..&'ice 1171789.00 .00 117,789.00 91815.75 .00 68,710.25 49,078.75 58 55,382.88
�6niirnodliitiics&.9 ilp1plllies 336,045.00 .00 336,045.00 21,064.27 58,218.27 1311790.69 146,036.04 57 661532.03
i:;lllciii IIC; llliii m�liitu uiii:s .00 .00 .00 .00 .00 .00 .00 +++ .00
IIC;tuwliilll�iiiiirus .00 .00 .00 .00 .00 .00 .00 +++ .00
IIC;tuuliilll�liiiirm a:iiillliii ciirsuiirmmmts 285,000.00 .00 285,000.00 .00 .00 11440.00 283,560.00 1 11450.00
office 11081.00 .00 11081.00 .00 .00 .00 11081.00 0 .00
i i:alCm iii IIC; a liilll°iir ui:: 2121429.00 .00 2121429.00 19,995.00 37,574.77 39,136.49 135,717.74 36 75,781.31
IIC::iiisiwair liilll°,,Nj.iiiori Sysl,lefnis 51561,142.00 2,041,500.00 71602,642.00 144,572.23 2,4121921.67 1,895,464.91 31294,255.42 57 216,086.37
iw.u.Iire .00 .00 .00 .00 .00 .00 .00 +++ .00
IIC;t iii�IIG:)iriiiincliillpall 240,000.00 .00 240,000.00 .00 .00 .00 240,000.00 0 .00
I]It ,:St IIC;sllpem se 343,081.00 .00 343,081.00 .00 .00 171,541.00 171,540.00 50 741297.58
IIC;3a",rmlllk .Il iiiscslll IIFee .00 .00 .00 .00 .00 225.00 (225.00) +++ .00
.......IIL'iiiiii�°� �'iiis .00 .00 .00 .00 .00 .00 .00 +++ .00
Ill.....oi'm ...Ill...,viii iir�m IIC:'t lll°i:: .00 .00 .00 .00 .00 .00 .00 +++ .00
EXPENSE TOTALS $19,549,572.00 $21091,500.00 $21,641,072.00 $1,193,134.30 $2,828,382.53 $8,631,722.33 $10,180,967.14 53% $6,859,466.58
Il siiii;JIII 0,5tear aird SeweTimm,, III..., tolls $19,549,572.00 $2,091,500.00 $21,641,072.00 $1,193,134.30 $2,828,382.53 $8,631,722.33 $10,180,967.14 $6,859,466.58
16
Expense Budget by Account Classification Report
66,
° IlllrlllllIlllr FiAicYtvVIII yllr�116 .1ded
S u IIII'n III, a ll ry I.............VIII 'hili
Adopted Budget Amended Current Month YTD YTD Budget-YTD %Used/
Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD
R iirid 0,5 1. VEIHIage Sys'team
111111"""" iiiu
EXPENSE
['(,N'-soi�iial S(,iii vics,SaIll i-ies&Wages 16,916.00 .00 16,916.00 (71173.07) .00 91554.86 7,361.14 56 21,687.43
Ill;iii lllslll ")&iiel i1s 6,825.00 .00 6,825.00 (3f345.05) .00 3f802.17 3,022.83 56 10,208.42
Coinl,],-acl ual iii- nice64f006.00 .00 64f006.00 2,508.46 7,736.27 20f 163.73 36,106.00 44 11f746.13
285.00 .00 285.00 23.75 .00 166.25 118.75 58 381.50
Sq,)lllJlie sz 563.00 .00 563.00 .00 .00 563.00 .00 100 .00
Otlh..ieii III; 111 ciii mrlllliiiw.�.iires .00 .00 .00 .00 .00 .00 .00 +++ .00
Ill;,3uiii ldiii irigs .00 .00 .00 .00 .00 .00 .00 +++ .00
7f5O6.00 .00 7f5O6.00 .00 .00 .00 7,506.00 0 .00
50f000.00 .00 50f000.00 750.00 15,375.00 2,750.00 31,875.00 36 33,780.00
.00 .00 .00 .00 .00 .00 .00 +++ .00
EXPENSE TOTALS
$146,101.00 $0.00 $146,101.00 ($7f235.91) $23,111.27 $37,000.01 $85,989.72 41% $77f803.48
�i�iid...Ill...,otzllcz $146fI01.00 $0.00 $146f 101.00 ($7,235.91) $23f 111.27 $77f803.48
FLv�id &5�1. VEIHIag(! ���)a��Hktiig Sys,�te�m $37f000.01 $85f989.72
17
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66.
""' ""'
Illlr �'lllll a a IIIb 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IR iirid 0,52, 111111 iiiiHllll iiiii iiir slurs ue 111111"""" iiiu
�t iiii�IIIIII'2�
EXPENSE
II[: :iuso�oriialll S(,Nrvics, I4ir-Hies&Wages 15,576.00 .00 15,576.00 (51625.13) .00 91655.60 5,920.40 62 15,851.23
Ill;iii lllsllls III;)&iiel°hills 6,562.00 .00 6,562.00 (2,644.98) .00 3,812.39 2,749.61 58 7,525.76
Ciinl,�],acl ualll Seiir-vices 112,083.00 .00 112,083.00 21140.86 11,228.96 30,665.48 70,188.56 37 41,930.29
Ui,;IiilllliiU:;liies 9,799.00 .00 9,799.00 11265.46 .00 2,425.62 7,373.38 25 2,867.80
292.00 .00 292.00 24.33 .00 170.31 121.69 58 564.06
CGiTH'Tl diitliies&St1II)Illsllllliies 10,796.00 .00 10,796.00 .00 .00 7,085.65 31710.35 66 213.45
01:IIIiieirIlfllllllll" Ilpes i c liiUAiiir- s .00 .00 .00 .00 .00 .00 .00 +++ .00
Ill;siiillldiiiii gs .00 .00 .00 .00 .00 .00 .00 +++ .00
.00 .00 .00 .00 .00 .00 .00 +++ 9,783.35
.00 .00 .00 .00 .00 .00 .00 +++ .00
EXPENSE TOTALS $155,108.00 $0.00 $155,108.00 ($4,839.46) $11,228.96 $53,815.05 $90,063.99 42% $78,735.94
Il usiiiclll Q52, 111 iiirllll'iiiiiiiiu t iiiu IIIIII'Ieveiiiume 111111'auiiiu ...IIL.., U::i:,,) $155,108.00 $0.00 $155,108.00 ($4,839.46) $11,228.96 $53,815.05 $90,063.99 $78,735.94
18
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66.
""' ""'
Illlr �'lllll a a IIIb uu 'lull VIII Illlr�1 .1ded
u VIII° VIII° a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IL....
I�u.,u irm ' 060 V6lh liu uu iiu
EXPENSE
II['(,N'sooii ulll S(,Nrvics, Ill viii-Hies&Wages 947,587.00 .00 947,587.00 79,175.35 .00 590,189.93 357,397.07 62 602,328.92
Ill;iii lll�lll III;)&iiel°hills 357,549.00 .00 357,549.00 32,990.22 .00 217,633.12 139,915.88 61 316,470.76
01.1,i&-, C st:s 41167.00 .00 4,167.00 60.00 .00 1,777.40 2,389.60 43 3,984.03
oii-fl,]i-�ad,,uslll Seiiivices 111,883.00 .00 111,883.00 31210.58 14,029.74 54,738.47 43,114.79 61 471113.20
i:aiilllliii:aiies 31392.00 .00 3,392.00 460.40 .00 2,721.93 670.07 80 2,523.15
amsu.vr..&'ice 11,706.00 .00 11,706.00 975.50 .00 6,828.50 41877.50 58 .00
.'6niirnodliitiics&.9 ilp1plllies 593,408.00 .00 593,408.00 60,107.41 71,785.43 378,776.57 142,846.00 76 342,924.52
i:;lllciii III; Illiii m�liitu uiii:s .00 .00 .00 .00 .00 .00 .00 +++ .00
Office III; uliillliii°smiirmt 614.00 .00 614.00 .00 .00 70.42 543.58 11 298.20
i'1(11 ii.III; a liilll iii ciiimmui 3,941.00 .00 3,941.00 .00 .00 .00 3,941.00 0 3,504.00
EXPENSE TOTALS $2,034,247.00 $0.00 $2,034,247.00 $176,979.46 $85,815.17 $1,252,736.34 $695,695.49 66% $1,319,146.78
Il wi i iiiu°iU iiu iiu �111111'a uiiind IIl uslll $2,034,247.00 0.00 2 034 247.00 176 979.46 85 815.17 1 252 736.34 695 695.49 $1,319,146.78
iiu �IIII �i � �� � � � � � � ,
19
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66,
""' ""'
Illlr �'lllll a a IIIb 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IR iIrid 061. V6III 'iiiii lull IIIIII't llll lull ��llllr°t 111111' uli lllli
EXPENSE
8111 111 III;� .00 .00 .00 .00 .00 .00 .00 +++ .00
Illi: lll III; uliillllll° Ilrmi: 1,073,000.00 852,000.00 1,925,000.00 57,634.98 13,836.21 1,000,532.75 910,631.04 53 3441704.49
a:lllmi�; III�° Illm ...IIL..III� III�°� �'��III���� .00 .00 .00 .00 .00 .00 .00 +++ .00
EXPENSE TOTALS $1,073,000.00 $852,000.00 $1,925,000.00 $57,634.98 $13,836.21 $1,000,532.75 $910,631.04 53% $344,704.49
FLfllld� 061. IIIII'iiiii lull Ill...,oi::i:3III 1 073 000.00 $852fOOO.00 $1,925,000.00 $57f634.98 $13f836.21 $1,000f532.75 $910,631.04 $344,704.49
20
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66,
""' ""'
Illlr �'lllll a a IIIb 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IR iiiri 2 r
.� iiiii�llll � iiIIIIII��. IIID
EXPENSE
.00 .00 .00 .00 .00 .00 .00 +++ .00
250,000.00 .00 250,000.00 .00 .00 .00 250,000.00 0 .00
office 162,900.00 75,000.00 237,900.00 71150.00 8,034.74 85,902.79 1431962.47 39 48,605.50
EXPENSE TOTALS $412,900.00 $75,000.00 $487,900.00 $7,150.00 $8,034.74 $85,902.79 $393,962.47 19% $48,605.50
LEirl 7"""""Coiiin�lpu,teir Ill otals $412,900.00 $75fOOO.00 $487,900.00 $7,150.00 $8f034.74 $85f9O2.79 $393,962.47 $48,605.50
21
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66,
""' ""'
Illlr �'lllll a a IIIb 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IL....i�rid 063 iii irvt 111111"""" iiii
EXPENSE
iiiiibi,-acbjall Sirv"'ces 40,000.00 .00 40,000.00 .00 .00 41800.00 35,200.00 12 .00
a:iiriwi'&,iice 9,146,373.00 .00 9,146,373.00 985,790.48 .00 5,688,169.50 3,458,203.50 62 6,154,866.28
,orni irnodiii:�,lii s&Sqp1plllies 22,500.00 .00 22,500.00 308.85 .00 3,835.50 18,664.50 17 7,284.65
.00 .00 .00 .00 .00 .00 .00 +++ 1,112.65
a:iirmi:: iiimiir°mlll...III.,iiimiir°ms iii°ms .00 .00 .00 .00 .00 .00 .00 +++ .00
EXPENSE TOTALS $9,208,873.00 $0.00 $9,208,873.00 $986,099.33 $0.00 $5,696,805.00 $3,512,068.00 62% $6,163,263.58
IlFit iiirxj 063 IIIIII 'iiiii luk Ill..., tall s $9,208,873.00 $0.00 $9,208,873.00 $986,099.33 $0.00 $5,696,805.00 $3,512,068.00 $6,163,263.58
22
Expense Budget by Account Classification Report
Illlr�°
° Illlrlllll66.
""' ""'
Illlr �'lllll a a IIIb uu 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IR iirid 070
1111°)61ice
EXPENSE
II[I(,NiiIIS,,,'DiII Ilfllits' 51790,809.00 .00 5,790,809.00 493,536.55 .00 31334,372.84 2,456,436.16 58 31049,166.35
iinl,�],-actual S&rvices 167,300.00 .00 167,300.00 22,972.00 .00 65,263.84 102,036.16 39 63,627.75
a:iirisusi'a' trice 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 .00
t r�ir �ir liii:aii s&SqpIIIJlies 100.00 .00 100.00 .00 .00 .00 100.00 0 .00
01111th°ieiiim III; Ill swiii"°ICJl iiii::usiii°m;s 12,000.00 .00 12,000.00 .00 .00 8,000.00 41000.00 67 81000.00
Office III;0 Iiilllsiii merit .00 .00 .00 .00 .00 .00 .00 +++ .00
EXPENSE TOTALS $5,985,209.00 $0.00 $5,985,209.00 $516,508.55 $0.00 $3,4071636.68 $2,577,572.32 57% $3,120,794.10
Il txiiid 070 111261ice 111111 stillsi
ilio tills 111111' iiiis I otals $5,985,209.00 $0.00 $5,985,209.00 $516,508.55 $0.00 $3,4071636.68 $2,577,572.32 $3,120,794.10
23
Expense Budget by Account Classification Report
Illlr�°
°1IIIIrlllll66.
""' ""'
Illlr �'lllll a a IIIb uu 'lull VIII Illlr�1 .1ded
u VIII° VIII, a ll JsUIIIig
Adopted Budget Amended Current u / Used/
Account i is i Transactions c r c Transactions cions Rec'd Prior Year YTD
IL.
iirid 071. 111111""""ilio sir 111111)e itis ilio is
EXPENSE
61032,036.00 .00 6,032,036.00 5221742.87 .00 31702,526.31 2,329,509.69 61 31406,571.45
iinl,�],-actual S&rvices 136,700.00 .00 136,700.00 5,725.00 .00 56,622.32 80,077.68 41 671424.17
a:iirisusi'a' trice 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 .00
t r�ir �ir liii:aii s&SqpIIIJlies 100.00 .00 100.00 .00 .00 .00 100.00 0 .00
01111th°ieiiim III; Ill swiii"°ICJliiii::usiii°m;s 10,000.00 .00 10,000.00 .00 .00 8,185.00 11815.00 82 81190.00
EXPENSE TOTALS $6,193,836.00 $0.00 $6,193,836.00 $528,467.87 $0.00 $3,767,333.63 $2,426,502.37 61% $3,482,185.62
IlFILA'id 071. 111111 iiiir 11111 this 'ii its 111111' iiiis ui...Ill..., i,all s $6,193,836.00 $0.00 $6,193,836.00 $528,467.87 $0.00 $3,767,333.63 $2,426,502.37 $3,482,185.62
"hili-&,ii mi Ill otals $162,538,139.00 $6,885,500.00 $169,423,639.00 $12,395,814.10 $8,573,645.23 $66,035,726.60 $94,8141267.17 $65,900,348.49
24
Mount Prospect
Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES
FINANCE COMMISSION
FROM: DIRECTOR OF FINANCE
DATE: AUGUST 21, 2019
SUBJECT: MONTHLY FINANCIAL REPORT—JULY 2019
Attached hereto are the cash position and investment statements of the Village for the month ended July
30, 2019. These statements provide a snapshot of the Village's cash position at month end and are
intended to supplement the budget revenue and expenditure summary and listing of bills. The first
statement presents the Village's cash position for governmental and enterprise funds and trust and agency
funds. The second statement presents the Village's cash position by fund type. The third statement
presents the list of investments for governmental and enterprise funds and trust and agency funds. It is
important to note that although we have included the trust and agency funds in the cash position report,
these funds are not accessible for Village operations. They are restricted for pension and escrow funding
only. Please read the summary that follows for further detail on the cash position of the Village.
Cash and Investment Position Report—All Funds (page 4)
This report provides a detailed summary of cash and investments for the Village for governmental and
enterprise funds and trust and agency funds. Governmental funds include the General Fund, Special
Revenue Funds, Debt Service Funds, Capital Project Funds and Internal Service Funds. The Enterprise
Funds consist of the Water/Sewer Fund and two (2) Parking Funds.
Trust funds include the Village's two public safety pensions(Police and Firefighters')while the agency funds
include the Escrow Deposit and Flex Comp Escrow Funds. The Escrow Deposit Fund accounts for
refundable deposits held by the Village to ensure completion of public improvements. The Flex Comp
Escrow Fund accounts for employee payroll deductions pursuant to a Section 125 flexible compensation
plan.
Governmental and Enterprise Funds - Cash and cash equivalents at June 30 was $80.2 million. During
July, cash receipts totaled $8,895,113 and investment income was$128,693. Reductions in cash and cash
equivalents during July totaled $9,363,469. Of this amount, payments to vendors were $7,629,461 and
employee payroll expenses were$1,722,349. Inflows resulting from interfund activity totaled $12,945 while
other reductions to cash totaled $11,659. There was also a net transfer from investment of $3,045,565.
Cash and cash equivalents at July 31 were$82.9 million.
Investments in the Governmental and Enterprise Funds at June 30 were $22,362,377. Investment activity
during the month of July included investment income totaling $50,096 and a net transfer to cash of
$3,045,565. Notes and CD's accounted for in the Governmental and Enterprise Funds reside in multiple
Funds investing surplus funds above what is needed for cash flow purposes. Total investments at July 31
were $19,366,907.
Total cash and investments for Governmental and Enterprise Funds at June 30 were $102,559,654. Cash
and investments decreased $276,622 for the month. Cash and investments at July 31 totaled
$1027283;032.
Monthly Financial Report—July 2019
August 21,2019
Page 2
Trust and Agency Funds - Cash and cash equivalents at June 30 was $3,687,095. During July, cash
receipts totaled $1,474,304. Investment income for the month was $92,972. Cash investment activities
resulted in a net decrease of$45,424 while outflows due to Interfund activity totaled $12,945. Reductions
in cash and cash equivalents during July totaled $1,055,399. Of this amount, payments to vendors were
$167,544 and employee payroll/pension and related expenses were $886,322. Other disbursements
totaled $1,532. Cash and cash equivalents at July 31 were $4,140,603.
Total investments at July 31 were$141,055,270, an increase of$834,338 from June 30. Investment Income
of$788,914 and a net transfer to investments of$45,424 accounted for the change.
Total cash and investments for Trust and Agency Funds at June 30 were $143,908,027. Cash and
investments increased $1,287,846 for the month and totaled $145,195,873 at July 31.
Summary of Cash Activity by Fund Type (page 5)
This report provides the cash activity for the month by fund type. This report is useful in identifying where
the activity (receipts and disbursements) is occurring. Activity in funds such as the Capital Projects and
Special Revenue Funds is higher than normal certain times of the year. The General Fund, the Village's
primary operating fund, tends to be more level and predictable in terms of spending and receipt of revenue.
Each month this report will provide detail explanation on activity of the General Fund. Other Fund activity
will be highlighted as warranted. Detail on the activity of the General Fund follows.
General Fund — Cash and cash equivalents at June 30 totaled $19,514,557. During July, cash receipts
totaled $5,246,415, and investment income was$26,989. Significant cash receipts included the state sales
tax and state income tax.
Sales tax revenues distributed from the one percent state portion received from the State of Illinois
during July totaled $2,460,909. Sales taxes received in July are for taxes generated from sales in May.
There is a two-month lag in receiving sales tax distributions from the state.
The General Fund allocation of the one percent Home Rule Sales Tax distribution is 0.25 percent.
Allocation of the home rule sales tax distributions is completed by priority.
First priority is Debt Service and Street Construction Fund allocations, second priority is Flood Control
and Capital Improvement Fund allocations, and third priority is the General Fund allocation.
Distributions are expected to be allocated to the General Fund later in the year.
Income tax revenues distributed from the State of Illinois received during July totaled $508,012.
Income taxes collected by the State in May are received by the Village in July.
Disbursements from the General Fund for July included payments to vendors of $1,766,874, interfund
transfers of$783,063, payments for employee wages and benefits of$1,541,536 and other disbursements
of$4,059.
Cash and cash equivalents at July 31 were $20,692,429, an increase of $1,177,872 from June 30. In
addition, investments consisting of certificates of deposit were $1,236,115. Cash and investments for the
General Fund at July 31 totaled $21,928,429.
Monthly Financial Report—July 2019
August 21,2019
Page 3
Statement of Investments (page 6-7)
This statement provides a listing of investments for governmental and enterprise funds and trust and agency
funds. The report also provides details of the investments for each fund.
Government and Enterprise Funds - Investments for the governmental and agency funds are made up
of Certificates of Deposit and other fixed income investments. At July 31, $19,366,907 was invested in
CD's and various governmental notes. These notes and CD's consist of surplus monies available from the
governmental and enterprise funds. Total investments for the governmental and enterprise funds includes
proceeds from the Series 2018B and 2019A bonds invested in various maturities which will be drawn down
over a period of 12-15 months as the construction work is completed on the new Police and Fire
headquarters as well as for the water-main and sewer projects.A detail list of holdings is included with this
report.
Trust and Agency Funds—The investments for the trust and agency funds are made up of certificates of
deposits,fixed income investments and equity mutual funds. CD's(if any)held in the Escrow Deposit Fund
will generally have maturities of between 30 and 120 days. Most of the reserves for this fund are invested
in the money market account due to the nature of the deposit.At July 31, there was a total of$141,055,270
invested in a combination of fixed income and equity instruments. A list of holdings is included with this
report. Escrow refunds are processed two times per month. Investment of the Village's pension funds is
governed by an Investment Policy adopted by each Pension Board.
Investments for the Police and Firefighter Pension Funds consist of various fixed income securities as well
as equity mutual fund accounts. Wells Fargo is the third-party holder of the fixed income securities. The
funds are managed by three investment management firms, Galliard, Segall Bryant and Mesirow Financial.
Segall Bryant holds approximately half of the fixed income investments for the two pension funds while
Galliard and Mesirow manage the balance of fixed income investments for these two funds. Each manager
maintains a small portion of their portfolio in cash to help facilitate liquidity and trading.
Investments in equities consist of mutual funds spread across various sectors (small, mid and large-cap
stocks)as well as investment philosophies (value, core and growth). The funds also invest a small amount
in international stocks. Each year the investment mix is evaluated for optimal diversification to meet pension
fund investment policy goals and objectives. Equity investments held by the Police Pension Fund are
managed by Sawyer Falduto Asset Management.
Conclusion
The cash position, investment statements, and budget revenue &expenditure summaries provide valuable
information regarding the status of the Village's financials. These reports are provided to the Village Board
and Finance Commission on a monthly basis. The cash position report is intended to provide a snapshot
of the Village's cash position at month end. Using this report, we are able to provide trend information to
support cash management and maximize investment earnings while ensuring availability of funds to meet
the Village's commitments. If you have any questions on the statements or this report, please contact me.
Amit Thakkar
Director of Finance
VILLAGE OF MOUNT PROSPECT
Preliminary Cash and Investment Position Report-All Funds
For the Month Ended July 31, 2019
GOVERNMENTAL AND ENTERPRISE FUNDS
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at June 30, 2019 $ 80,197,277.10 $ 22,3623376.98 $ 102,559,654.08
Cash receipts 8,895,113.46 878957113.46
Investment income 1283692.69 507095.67 1787788.36
Transfers from investments to cash 330453565.21 (370453565.21) -
Transfers to investments from cash - - -
Interfund activity 123945.01 121945.01
Disbursements:
Accounts payable (776295460.92) (776297460.92)
Payroll (1,722,348.73) (1,722,348.73)
Other (115659.25) (115659.25)
Balance at July 31, 2019 $ 82,916,124.57 $ 19,366,907.44 $ 102,283,032.01
TRUST AND AGENCY FUNDS
Cash and Cash Total Cash and
Equivalents Investments Investments
Balance at June 30, 2019 $ 376875094.58 $ 140,2207932.48 $ 143,9081027.06
Cash receipts 174749304.15 17474,304.15
Investment income (loss) 92,971.63 7887913.87 8817885.50
Transfers from investments to cash 1,465,543.06 (1,465,543.06) -
Transfers to investments from cash (17510,966.81) 1,5101966.81 -
Interfund activity (127945.01) (127945.01)
Disbursements:
Accounts payable (1675543.75) (1677543.75)
Payroll (8655289.47) (8657289.47)
Flex spending (217032.82) (21,032.82)
Other (11532.47) (17532.47)
Balance at July 31, 2019 $ 4,140,603.09 $ 141,0551270.10 $ 14571951873.19
Assets are restricted in purpose and do not represent discretionary assets of the government.
4
CO—CN I'*- N CN 0 r- (01 CN OD Iq 0
(D(D m CN co P- CO N W (01, CN co 0 cm
t--4 00' (6 CCD v r,� r-�(6 C6 � wi
I'*-—CCD C)(0 0)V)m 0 N
V!lqz�0—M — Cl CCD 0 r^-
T-T- (0(0 m co
t�tib(N V-- t- —
oo V)rq Lf)LO LO I,- C> m CD C) � qq
CO co Iq CD V
N
69
(N rl- Lf)
U)>- CO C) qt W 0) Oct
04 (Nm
U-
LU< V- V-
z LLV-
z 0
0
< (D v- t--(0 r-ODI CNJ 00, C) "t
0 m 00 IT C)oo qt[,- CN 00, t-
z a I,:oo 06 C6 CCD C6 0 0 (C)6�
Z LLJ Z Mt CIO(3) It(0 00 r- C C) rl- 14-
�V-00 W LO cr) 14 C14 N to
<0 0 ,1., - -
(D—LC)CD Lr)T- 0 (D CF), U')
CN (D V- 1 (0 00 Ln
cl�0 z LO Iq Nr LO 13D 0 (3)C> 0 0
ff-CL uj csi - 1
Wo a; It
r) U') CY) V-
z (D CN 0 CV r- (3) LI) "qt- C)
<Ld r C6 N LO Vi Ci OD
Q) fl- r-M(D INt LO 0 V)
C14—CCD LO m(C) A NT, a
C)CL r��L6 co-LO- CN N 0) (D CCD (C) V)
CC Z o)a)CN 11;3- C%4 N (0 co
LU-1 V-CO T-CCD r- (D CD 0 N
-j LL C�C6 Cr) r,-:7 or-� a; ci
<z co co %- a
uj
0
ko(N c Q C5,
00 m r- (0
f
< Ch W4- (D (0
Z U- co co cMm 00 00 coo m (N01) m
co (wa
UJ W tl-N co ko C)
ui f-oo CY) LO LO
(.) C:)C%4 (m ko LO 4t
cr
ui
CZ)
W CN co C?)(D CZ) a)q;r m
IL ui (C)0 N LO 0 LO LO (V)
m'c:5 c6 6 (ri 6 (6
o CIO
LO �;f N CN
(C) It CV M ai 0
z CL 0 -
W N LO
M to C6(6 V7(61 (-5
U- LU Z (D co m
I LO M
C4
t z CN
-0 CN N
0 < c w
LIJ GO
U. M -6,- w
0 C.1r- ui
0
ui o 2 z C)— Nt N 0 MR C)
ui 1,6 1q:L(i 6 (Ni ci
< (0 C)C)CCD %14" (Y) cle)
Z C>CD 0)LOCruc to
E L-CCI vi C4 r-:ui C6
0 LLJ
E (L z
U- rl-0 m Iq r"- co
<o b-)c) C) OD IT ILO (C) a
LL
C6 ClT- L6 tr)
EL T- CN
Li ►
5;
Z
Lij 0 r-LO I lot
> C14LO C 00
0(V 40
co v
LU 06 E
Z 0 C6 CSV
n 00(D E
LLa)
>
0
CD
CD
4-
LO
IT C)(D It co CN N w
(-�cNm i L6(6 ai c6
< tp
U")co CO
CTD LO r-- CDC
(n
CL!r-OD CLM m m v CN
z 0 U)
T-V-(0
UJ (
UJ Z c6 (6'
D LO
CL>=) N o
ems—
LJ U- (D
LO W) r_
0
tJI
cc)
z (3) rl- 00 CY) 0 N CD P-
(M(N CN CV) (0 N(D 0 co
C
CCs u)c6' cri ai (6(-i c6 CC) tC7 M CLD
LL Lr) OD (ID LO (Y)rl- N
U') m o CS V)OD lq-
(0 (C) co CL
V C14 ()0 4T co 0) m (Y) N
LL! CN 0)
zCis tCj 4-
04
0
"0
CCD
C: z
M ui 0
>�
z m e-
ui d) CL z
Q- OL
(>31 w
C
>
:3 13
M U) E 'x 0 cn (D (D
m 8 < 8 E E
OL m
ui E C, -0 a-�; z
ILII coom 4� (n
X 0 > cl) CCD > > C: <
cn Ln E C 4.4 4 8 0
cc 0— a
0 Z � � E 0-0 -1-
EEEE m 2MOLM- C: U)
m 8 w C4
Uy N
m >IT E e LD LA cm LZ. 0 U-
cn a lz -0 m LU m (A
co m (n (1) U) C W 0
(1) m V >U) <
IL)m 0 C 0 0 0 w z - 9
5
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of July 31,2019
GOVERNMENTAL AND ENTERPRISE FUNDS
Maturity Purchase Financial Investment CUSIP/ Market
Date Date Institution Description FDIC# Net Yield Value
GENERAL FUND(001)
12/13/19 12/28/17 Federal Home Loan Bank Agency Notes 3130AOJR2 2.375% $ 1,236,115.07
1,2361115.07
POLICE&FIRE BUILDING CONSTRUCTION FUND(025)
08/07/19 12/21/18 BMO Harris Bank,NA,IL Certificate of Deposit 16571 2.480% 3001000.00
08/31/19 12/21/18 US Treasury Note US Treasury Note 912828TN0 2.549% 2,512,585.60
09/30/19 12/21/18 US Treasury Note US Treasury Note 912828TRI 2.562% 2,011,191.65
10/31/19 12/21/18 US Treasury Note US Treasury Note 912828F62 2.581% 1,507,227.64
12/04/19 12/21/18 Capital Community Bank,UT Certificate of Deposit 33823 2.730% 24300.00
12/04/19 12/21/18 Northeast Community Bank,NY Certificate of Deposit 29147 2.727% 24300.00
12/04/19 12/21/18 First Capital Bank,TN Certificate of Deposit 57552 2.650% 2431800.00
12/04/19 12/21/18 Bank of China,NY Certificate of Deposit 33653 2.590% 2431900.00
12/04/19 12/21/18 Orrstown Bank,PA Certificate of Deposit 713 2.520% 2441100.00
12/04/19 12/21/18 Financial Federal Bank,TN Certificate of Deposit 31840 2.520% 2441100.00
12/15/19 12/21/18 US Treasury Note US Treasury Note 912828073 2.602% 1,171,603.08
01/31/20 12/21/18 US Treasury Note US Treasury Note 912828H52 2.599% 1,0841933.68
02/29/20 12/21/18 US Treasury Note US Treasury Note 912828UQI 2.641% 1,006,583.78
04/08/20 12/21/18 Servisfirst Bank,FL Certificate of Deposit 57993 2.784% 2411200.00
04/08/20 12/21/18 Cornerstone Bank-York NE Certificate of Deposit 5496 2.687% 241,500.00
04/08/20 12/21/18 Sonabank,VA Certificate of Deposit 57968 2.691% 2411500.00
04/08/20 12/21/18 Bank OZK,AR Certificate of Deposit 110 2.623% 2411700.00
05/06/20 12/21/18 CFG Community Bank,MD Certificate of Deposit 34294 2.743% 2401900.00
05/06/20 12/21/18 First Internet Bank of Indiana,IN Certificate of Deposit 34607 2.725% 2401900.00
05/06/20 12/21/18 Modern Bank,National Association,NY Certificate of Deposit 22398 2.640% 1681305.30
05/06/20 12/21/18 Newbank,NA,NY Certificate of Deposit 58203 2.640% 2411200.00
1516141430.73
VEHICLE REPLACEMENT FUND(061)
06/12/20 12/28/17 Federal Home Loan Bank Agency Notes 313383MB4 1.875% 112481381.71
12/11/20 12/28/17 Federal Home Loan Bank Agency Notes 3130A3UQ5 1.875% 112471)740.41
214961122.12
RISK MANAGEMENT FUND (063)
03/06/19 03/06/17 Mount Prospect State Bank Certificate of Deposit 354058 0.250% 201239.52
20,239.52
TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS $ 1913661907.44
6
VILLAGE OF MOUNT PROSPECT
STATEMENT OF INVESTMENTS
As of July 31,2019
TRUST AND AGENCY FUNDS
Maturity Purchase Financial Investment CUSIP/ Interest Market
Date Date Institution Description Acct# Rate% Value
POLICE PENSION FUND(070)
Various Various Wells Fargo Wells Fargo Investments Various Various $ 2204,302.34
Various Various Various Mutual Fund Investments Various Various 50,7421442.21
73,3461744.55
FIRE PENSION FUND(071)
Various 5/26/2015 Principal Life Insurance Company Group Annuity Contract 8-10810 Variable 6,293,878.48
Various Various Wells Fargo Wells Fargo Investments Various Various 24,361,903.88
Various Various Various Mutual Fund Investments Various Various 37,052,743.19
67,708,525.55
TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 14110551270.10
* Assets are restricted in purpose and do not represent discretionary assets of the government.
7