Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
5.1 Monthly Financial Report - May 2019
6/19/2019 BoardDocs® Pro Agenda Item Details Meeting Jun 18, 2019 - REGULAR MEETING OF THE MOUNT PROSPECT VILLAGE BOARD - 7:00 p.m. Category 5. CONSENT AGENDA Subject 5.1 Monthly Financial Report - May 2019 Access Public Type Action (Consent) Fiscal Impact No Budgeted No Recommended Action Accept the monthly financial report for May 2019. Public Content Information The monthly financial report includes a Cash and Investment Position Report and Fund Budget Revenue and Expenditure Summaries for the month ended May 31, 2019. Alternatives 1. Accept the monthly financial report for May 2019. 2. Action at the discretion of Village Board. Staff Recommendation Staff recommends the Village Board accept the monthly financial report for May 31, 2019. 05 May Board Reports for Upload .pdf (352 KB) Monthly Cash Position Report - May 2019.pdf (410 KB) Administrative Content All items under Consent Agenda are considered routine by the Village Board and will be enacted by one motion. There will be no separate discussion of those items unless a Board member 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. Executive Content https://go.boarddocs.com/il/vomp/Board.nsf/Private?open&login# 1/2 6/19/2019 BoardDocs® Pro All items under Consent Agenda are considered routine by the Village Board and will be enacted by one motion. There will be no separate discussion of those items unless a Board member 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# 2/2 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES May 1— May 31, 2019 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES May 1—May 31, 2019 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 FiscaVr tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS Fitnd Wl. GeirieiraVIII 111111 iiiid I ol,"als $56,118,900.00 $0.00 $56,118,900.00 $2f517J12.20 $0.00 $26,011,787.74 $30,107,112.26 46% $23,595,023.74 $56,118,900.00 $0.00 $56,118,900.00 $2,517,112.20 1 $0.00 $26,011,787.74 $30,107,112.26 $23,595f023.74 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 WJ. Geineir REVENUE III am,�5,3", 16 498 000.00 .00 16 498 000.00 88,949.74 .00 91050,208.18 7f447f791.82 55 81948,274.82 I axes 81033,000.00 .00 8f033,000.00 700f391.34 .00 21381,082.88 51651,917.12 30 21541,631.46 I ic&ises228.03 8m, Fees 11362,000.00 .00 1f362,000.00 1121 .00 885,493.24 476 1506.76 65 594,517.45 fl,,al IlReveiii1�� Je 27,872,000.00 .00 27,872,000.00 11375,975.94 .00 121757,567.46 15,114,432.54 46 10,488,042.27 Ghiaiiiges IlFoiii Seiii vices 11209,000.00 .00 11209,000.00 92,589.25 .00 3711420.14 837,579.86 31 342,690.52 Fiiiries & IlFoiii° its 432,000.00 .00 432f000.00 21,084.36 .00 92f 703.77 339,296.23 21 149,218.13 11]iivest]-neirfl. [incorne 266,100.00 .00 266f 100.00 73,251.96 .00 231,440.09 34,659.91 87 1191639.99 IlRi rn b ijiii s irseiints 190,500.00 .00 190,500.00 34,685.71 .00 87,923.12 102f 576.88 46 931256.59 C)fl'ieiii-IlReveiir-iLje 256,300.00 .00 256,300.00 17,955.87 .00 153,948.86 102,351.14 60 3171752.51 Od,i(,,i', S0Lfl-ce!3" .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS Fitnd Wl. GeirieiraVIII 111111 iiiid I ol,"als $56,118,900.00 $0.00 $56,118,900.00 $2f517J12.20 $0.00 $26,011,787.74 $30,107,112.26 46% $23,595,023.74 $56,118,900.00 $0.00 $56,118,900.00 $2,517,112.20 1 $0.00 $26,011,787.74 $30,107,112.26 $23,595f023.74 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS Ftji�iid 002, III�)6b't Seirice I otals $5,827,228.00 $0.00 $5,827,228.00 $90,560.27 $0.00 $1f924f932.41 $3f902f295.59 33% $1f473f769.32 $5,827,228.00 $0.00 $5,827,228.00 $90,560.27 $0.00 $1f924f932.41 $3f902f295.59 $1f473f769.32 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 002, IIII �Ib't Seirvice111111"""' iiiis REVENUE IIG: iii 111 iii.i: III am,�5,3", 21434,000.00 .00 2f434,000.00 91408.85 .00 11368,379.38 L065f620.62 56 111611758.37 I axes 11024,578.00 .00 1f024,578.00 .00 .00 442,617.69 581,960.31 43 2001478.57 IIR(� w(NiI�Lle 11573,650.00 .00 1f573,650.00 76,787.86 .00 80,229.96 11493,420.04 5 109,988.37 51000.00 .00 51000.00 41363.56 .00 33,705.38 (28,705.38) 674 11544.01 01111hie�iiIIReveii mii.je .00 .00 .00 .00 .00 .00 .00 +++ .00 Otlhie�iiFiiria� riciirig Sojirces 790,000.00 .00 790f000.00 .00 .00 .00 790f000.00 0 .00 REVENUE TOTALS Ftji�iid 002, III�)6b't Seirice I otals $5,827,228.00 $0.00 $5,827,228.00 $90,560.27 $0.00 $1f924f932.41 $3f902f295.59 33% $1f473f769.32 $5,827,228.00 $0.00 $5,827,228.00 $90,560.27 $0.00 $1f924f932.41 $3f902f295.59 $1f473f769.32 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS R jiirand 02,0 CaIp'iiiii I otals $2,142,000.00 $0.00 $2,142f000.00 $0.00 $0.00 $605,251.60 $1f536f748.40 28% $263,495.22 $2,142,000.00 $0.00 $2,142,000.00 $0.00 $0.00 $605,251.60 $1f536f748.40 $263,495.22 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 02,0 CaIpR41111 REVENUE oflliiiI a° s 11370,000.00 .00 1f370,000.00 .00 .00 591,840.00 778f 160. 00 43 2571400.00 Revei�-iLie .00 .00 .00 .00 .00 .00 .00 +++ .00 20,000.00.,00 20000.00 .00 .00 13,411.60 61588.40 67 61095.22 .00 .00 .00 .00 .00 .00 .00 +++ .00 01111hie�iiIIReveii mii.je 21000.00 .00 21000.00 .00 .00 .00 21000.00 0 .00 Otlhie�iiFiiria� riciirig Sojirces 750,000.00 .00 750f000.00 .00 .00 .00 750,000.00 0 .00 REVENUE TOTALS R jiirand 02,0 CaIp'iiiii I otals $2,142,000.00 $0.00 $2,142f000.00 $0.00 $0.00 $605,251.60 $1f536f748.40 28% $263,495.22 $2,142,000.00 $0.00 $2,142,000.00 $0.00 $0.00 $605,251.60 $1f536f748.40 $263,495.22 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS Fw,iid 02,3 Sbili ee't Cmns,tiii ruc111111"""' uum ill ...Ill...,01,,,aIlls $3,771,000.00 $0.00 $3,771,000.00 $170,189.99 $0.00 $2,221,264.99 $1f549,735.01 59% $2,133,250.96 $3,771,000.00 $0.00 $3,771,000.00 $170,189.99 $0.00 $2,221,264.99 $1,549,735.01 $2,133,250.96 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 iurid 02,3S,turee't Couns,turuc REVENUE oflluiI a° s 21085,000.00 .00 2f085,000.00 56,720.65 .00 803,444.73 1,281f555.27 39 489,921.77 I iceinses,, [)&,-ui'nits & IIF(,�es 11650,000.00 .00 1f650,000.00 108,364.50 .00 11397,280.00 2521720.00 85 11466,157.00 IIR(� w(� NiIuLle .00 .00 .00 .00 .00 .00 .00 +++ .00 Fiur-ies & IlFoui�f6il,,s .00 .00 .00 .00 .00 .00 .00 +++ .00 ivesl,]"nesu i I., i our Tie 61000.00 .00 61000.00 .00 .00 51880.27 119.73 98 1,048.89 Reiur'6',,,X vseuMeits .00 .00 .00 .00 .00 6,297.35 (61297.35) +++ .00 01,11iieur IlReveunie 30,000.00 .00 30f000.00 51104.84 .00 8,362.64 21,637.36 28 176,123.30 Ofliieui-Fiuna�nciurig Sou .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS Fw,iid 02,3 Sbili ee't Cmns,tiii ruc111111"""' uum ill ...Ill...,01,,,aIlls $3,771,000.00 $0.00 $3,771,000.00 $170,189.99 $0.00 $2,221,264.99 $1f549,735.01 59% $2,133,250.96 $3,771,000.00 $0.00 $3,771,000.00 $170,189.99 $0.00 $2,221,264.99 $1,549,735.01 $2,133,250.96 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS Fix'id 02,4 1111"""' ori d Couivtur6l I otals $2,417,422.00 $0.00 $2,417,422.00 $1,803.00 $0.00 $188,837.50 $2,228,584.50 8% $64,199.84 $2,417,422.00 $0.00 $2f417f422.00 $1,803.00 $0.00 $188,837.50 $2,228,584.50 $64,199.84 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 iurid 02,4 1111""""Illood Couuatur6l Co,ns,turuic,timn 1111' 4nd REVENUE oflluiI a° s 345,422.00 .00 345,422.00 .00 .00 149,222.31 196f 199.69 43 57f024.00 Reveu�-iLie 2f000f000.00 .00 2f000f000.00 .00 .00 .00 2f000f000.00 0 .00 Oha�i-ges Il oui Seui-vices 40f000.00 .00 40f000.00 1f803.00 .00 21,688.00 18,312.00 54 2,370.00 [rxo�r'ne 12,000.00 .00 12,000.00 .00 .00 8,019.91 3,980.09 67 4f805.84 Reiurnbuu seuriwieurO.'s 20,000.00 .00 20f000.00 .00 .00 9f907.28 10,092.72 50 .00 OtlhieuiFiuria� riciurig Soiu jjrces .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS Fix'id 02,4 1111"""' ori d Couivtur6l I otals $2,417,422.00 $0.00 $2,417,422.00 $1,803.00 $0.00 $188,837.50 $2,228,584.50 8% $64,199.84 $2,417,422.00 $0.00 $2f417f422.00 $1,803.00 $0.00 $188,837.50 $2,228,584.50 $64,199.84 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS R.vn(Jl 025 1111112 ice & 111111101&rig Cmns,tiiii Ill..., otals $88,000.00 $0.00 $88,000.00 $68,510.31 $0.00 $332,720.19 ($244,720.19) 378% $0.00 $88,000.00 $0.00 $88f000.00 $68,510.31 0 $0.00 $332,720.19 ($244,720.19) $0.00 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 025 1111°)61ice & IBijfll&ing Co�ns'tiiii REVENUE 88,000.00 .00 88,000.00 68,510.31 .00 3321720.19 (244f720.19) 378 .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 01,1'ie�t-, IIR,eveiirii�irje .00 .00 .00 .00 .00 .00 .00 +++ .00 01,1"ie��', So��� t� ces .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS R.vn(Jl 025 1111112 ice & 111111101&rig Cmns,tiiii Ill..., otals $88,000.00 $0.00 $88,000.00 $68,510.31 $0.00 $332,720.19 ($244,720.19) 378% $0.00 $88,000.00 $0.00 $88f000.00 $68,510.31 0 $0.00 $332,720.19 ($244,720.19) $0.00 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS Ftx�id IIIIIIIefuise IIII')islpos4l I otals $4,371,720.00 $0.00 $4,371f720.00 $298,296.83 $0.00 $1,700,838.61 $2f670f881.39 39% $1,670,386.77 $4,371,720.00 $0.00 $4f371f720.00 $298,296.83 $0.00 $1,700,838.61 $2f670f881.39 $1,670,386.77 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 iurid III111t.eftise 1111' Mslpo,sa1l 111111"""" iiiir REVENUE I am5,3", .00 .00 .00 .00 .00 .00 .00 +++ .00 Ohaui-ges IlFof- S&rvic.(,�s 41194,500.00 .00 4,194,500.00 2841234.18 .00 1f627f961.49 2,566,538.51 39 1ffl3f654.44 Fiuiies d. IlFo i 1.5 37,000.00 .00 37,000.00 21173.39 .00 13,329.95 23,670.05 36 15,684.15 [rxo�r'ne 5f000.00 .00 51000.00 .00 .00 4,482.68 517.32 90 2,819.32 ReiurnIbuuiseuriieur..O.'s 11000.00 .00 1f000.00 .00 .00 .00 11000.00 0 .00 OtlhieuiReveuriie 134,220.00 .00 134,220.00 11,889.26 .00 55f064.49 79,155.51 41 48f 228.86 REVENUE TOTALS Ftx�id IIIIIIIefuise IIII')islpos4l I otals $4,371,720.00 $0.00 $4,371f720.00 $298,296.83 $0.00 $1,700,838.61 $2f670f881.39 39% $1,670,386.77 $4,371,720.00 $0.00 $4f371f720.00 $298,296.83 $0.00 $1,700,838.61 $2f670f881.39 $1,670,386.77 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS Fiwi(',Jl °IVIII 4cwt mr ax111111 iiia ...Ill...,otals $1,435,000.00 $0.00 $1,435,000.00 $121,624.81 $0.00 $458,670.04 $976,329.96 32% $472,516.08 $1,435,000.00 $0.00 $1,435f000.00 $121,624.81 �00] $0.00 $458,670.04 $976,329.96 $472,516.08 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 041. IIIIYfttmr ax 111111' iii iiiir REVENUE ReveIIIile 11400,000.00 .00 1f400,000.00 119,896.31 .00 446,514.34 953,485.66 32 457,946.84 11]wesb'neiiriit [rxo�r'ne 20,000.00 .00 20,000.00 .00 .00 10,427.20 91572.80 52 81867.14 15,000.00 .00 15,000.00 11728.50 .00 11728.50 13,271.50 12 51702.10 01,1,-ieiii, IIReveiii"i�i�je .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS Fiwi(',Jl °IVIII 4cwt mr ax111111 iiia ...Ill...,otals $1,435,000.00 $0.00 $1,435,000.00 $121,624.81 $0.00 $458,670.04 $976,329.96 32% $472,516.08 $1,435,000.00 $0.00 $1,435f000.00 $121,624.81 �00] $0.00 $458,670.04 $976,329.96 $472,516.08 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS Fitnd 042, "C"'Is $365,649.00 $0.00 $365,649.00 $33,022.50 $0.00 $99,226.14 $266,422.86 27% $25,000.00 $365,649.00 $0.00 $365,649.00 $33,022.50 9 $0.00 $99,226.14 $266,422.86 $25f000.00 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 i�rid 042, REVENUE Reve��i� je 275,649.00 .00 275,649.00 .00 .00 .00 275,649.00 0 .00 11]wesb'neiiriit [rxoir'ne .00 .00 .00 .00 .00 .00 .00 +++ .00 01,1'ieiii-, IlR,eveiii,ii�i�je 90,000.00 .00 90,000.00 33f022.50 .00 99f 226.14 (9f226.14) 110 25f000.00 REVENUE TOTALS Fitnd 042, "C"'Is $365,649.00 $0.00 $365,649.00 $33,022.50 $0.00 $99,226.14 $266,422.86 27% $25,000.00 $365,649.00 $0.00 $365,649.00 $33,022.50 9 $0.00 $99,226.14 $266,422.86 $25f000.00 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS FLEnd 043 Asse't S64tjiiiire I ol,". ,,,a $12,000.00 $0.00 $12,000.00 $0.00 $0.00 $12,252.38 ($252.38) 102% $6,521.61 $12,000.00 $0.00 $12,000.00 10 $0.00 $0.00 $12,252.38 ($252.38) $6,521.61 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 i�rid 043 Asse't Seizitre REVENUE Fiiii s & IlFDII'i"�ts 10,000.00 .00 10,000.00 .00 .00 11,612.46 (1f612.46) 116 6,043.12 11]wesb'ne�riit [rxoir'ne 2,000.00 .00 2,000.00 .00 .00 639.92 1f360.08 32 478.49 REVENUE TOTALS FLEnd 043 Asse't S64tjiiiire I ol,". ,,,a $12,000.00 $0.00 $12,000.00 $0.00 $0.00 $12,252.38 ($252.38) 102% $6,521.61 $12,000.00 $0.00 $12,000.00 10 $0.00 $0.00 $12,252.38 ($252.38) $6,521.61 -7- Report ............ I .......... . 05/3 9 k Fisca�l Year t", . .... [III-161LAE.d ly S L,,VIII°°�n Irn a I ................ isUIrllg 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 111111 dei raVIII SIIlaire REVENUE 21000.00 .00 21000.00 .00 .00 .00 2,000.00 0 .00 11]wesb'ne�riit [rxoir'ne 200.00 .00 200.00 11.23 .00 52.92 147.08 26 58.45 REVENUE TOTALS Fwiid 044 1111"""''edeir51,iaiiire111111 viii iiiii Ill..., ol a I ,S; $2,200.00 $0.00 $2,200.00 $11.23 $0.00 $52.92 $2,147.08 2% $58.45 $2,200.00 $0.00 $2,200.00 11 $11.23 $0.00 $52.92 $2,147.08 $58.45 -7 - Report ............ I .......... . 05/3 9 k Fisca�l Year t", . .... [III-161LAE.d ly S L,,VIII°°�n Irn a I ................ isUIrllg 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 045IIIIII1iU 'IIII 111111' iiia 111111' iiia REVENUE F'6�1'(,,IitS 25,000.00 .00 25,000.00 11987.32 .00 31367.31 21,632.69 13 2,164.52 11]wesb'ne�riit [rxoir'ne 500.00 .00 500.00 .00 .00 115.07 384.93 23 158.68 REVENUE TOTALS Fitnd 0451111 U'I[ I ol,". ,a I $25,500.00 $0.00 $25,500.00 $1,987.32 $0.00 $3,482.38 $22,017.62 14% $2,323.20 $25,500.00 $0.00 $25,500.00 12 $1,987.32 $0.00 $3,482.38 $22,017.62 $2,323.20 Revenue Budget by Account Classification Report ............ 1 .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a 1 ................ isUIrlig REVENUE TOTALS R.vn(JI 046 oiirei�ri axIlllllloaird ttrid Ill..., otals $94,000.00 $0.00 $94,000.00 $0.00 $0.00 $1,625.16 $92,374.84 2% $1,116.87 $94,000.00 $0.00 $94f000.00 13 $0.00 $0.00 $1f625.16 $92,374.84 $1, 116.87 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 046 ax IBwrd REVENUE oflliiiI a° s 90,000.00 .00 90,000.00 .00 .00 .00 90,000.00 0 .00 11]wesb'ne�riit [rxoir'ne 4,000.00 .00 4,000.00 .00 .00 1f625.16 2,374.84 41 1, 116.87 01,1'ie�i-, IIR,eveiii ,ii�i�je .00 .00 .00 .00 .00 .00 .00 +++ .00 01,,1"ie��', So��� t� ces .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS R.vn(JI 046 oiirei�ri axIlllllloaird ttrid Ill..., otals $94,000.00 $0.00 $94,000.00 $0.00 $0.00 $1,625.16 $92,374.84 2% $1,116.87 $94,000.00 $0.00 $94f000.00 13 $0.00 $0.00 $1f625.16 $92,374.84 $1, 116.87 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS Fiwwll048 lllll"Iu& 'Iiiiess tu...III...,otals $1,525,000.00 $0.00 $1,525,000.00 $76,129.25 $0.00 $443,840.82 $1,081,159.18 29% $427,511.68 $1,525,000.00 $0.00 $1,525f000.00 $76,129.25 14 $0.00 $443,840.82 $1,081,159.18 $427,511.68 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 048 11111"kisl� "kness REVENUE oflliiiI a° s 11070,000.00 .00 1f070,000.00 76,129.25 .00 250,117.40 819,882.60 23 253,358.97 Revei�-iLle 440,000.00 .00 440,000.00 .00 .00 190,080.00 249,920.00 43 1701100.00 15,000.00 .00 15,000.00 .00 .00 31643.42 11,356.58 24 41052.71 01,1,-ie���, Fi���ia��xi���ig So��� t� ces .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS Fiwwll048 lllll"Iu& 'Iiiiess tu...III...,otals $1,525,000.00 $0.00 $1,525,000.00 $76,129.25 $0.00 $443,840.82 $1,081,159.18 29% $427,511.68 $1,525,000.00 $0.00 $1,525f000.00 $76,129.25 14 $0.00 $443,840.82 $1,081,159.18 $427,511.68 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS R., iii m ;lll1111112iro,s�pec,t airid 14aiin I otals $10,484,000.00 $0.00 $10,484,000.00 $4,854.27 $0.00 $256,212.19 $10,227,787.81 2% $7,348f406.74 $10,484,000.00 $0.00 $10,484f000.00 15 $4,854.27 $0.00 $256,212.19 $10,227,787.81 $7,348,406.74 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 049 1111°)�ros�pec't ii IIaiin111111°°"'IIID 111111"""' 111111 �tiiiiis°tiiriiiii REVENUE III..., . . .... a x E � � 474,000.00 .00 474,000.00 31148.35 .00 247,908.27 226,091.73 52 .00 11]wesb'ne�riit [rxoir'ne 10,000.00 .00 10,000.00 11705.92 .00 8,303.92 1f696.08 83 29f 527.44 01,1'ie�i-, 11R,eveiii ,ii�i�je .00 .00 .00 .00 .00 .00 .00 +++ .00 eia��xig So�ti ces 10f000f000.00 .00 10f000f000.00 .00 .00 .00 10f000f000.00 0 7f318f879.30 REVENUE TOTALS R., iii m ;lll1111112iro,s�pec,t airid 14aiin I otals $10,484,000.00 $0.00 $10,484,000.00 $4,854.27 $0.00 $256,212.19 $10,227,787.81 2% $7,348f406.74 $10,484,000.00 $0.00 $10,484f000.00 15 $4,854.27 $0.00 $256,212.19 $10,227,787.81 $7,348,406.74 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS FL,fl"id0,50 Wa,te�r a�nd Seweiiir I ol,,,als $25,940,700.00 $0.00 $25,940,700.00 $1,192,809.52 $0.00 $5,998,187.74 $19,942,512.26 23% $5,604,797.47 $25,940,700.00 $0.00 $25f940f700.00 $1f192f809.52 16 $0.00 $5,998,187.74 $19,942,512.26 $5,604,797.47 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,50 Wa,teir aind Seweir REVENUE I am5,3", .00 .00 .00 11583.63 .00 (71.52) 71.52 +++ (284.93) I iceinses,, [)&,-iii'nhits & IlF(,�es 20f000.00 .00 20,000.00 1,510.00 .00 8,530.00 11f470.00 43 9,410.00 Oha�i-ges Il oiiiSei�'vices 15f509f600.00 .00 15f509f600.00 1,165,840.62 .00 5,848,353.50 9,661,246.50 38 5,482,043.12 Fiiir-ies & IlFoii f6il,,s 100,000.00 .00 100,000.00 7,872.72 .00 33,,103.79 66,896.21 33 43,525.82 ivesl,]"neiiri I'll i( oii�'Tie 511100.00 .00 51.1100.00 12f402.55 .00 74,551.66 (23,451.66) 146 46,641.47 Reiiiriil[,,,X vi seiMeirits .00 .00 .00 .00 .00 8,100.31 (81100.31) +++ .00 01,11iie�r Il.c cinie 60,000.00 .00 60f000.00 31600.00 .00 25,620.00 34,380.00 43 23,461.99 Ofliie�i-Fiina�nciiirig So� 10,200,000.00 .00 10,200,000.00 .00 .00 .00 10,200,000.00 0 .00 REVENUE TOTALS FL,fl"id0,50 Wa,te�r a�nd Seweiiir I ol,,,als $25,940,700.00 $0.00 $25,940,700.00 $1,192,809.52 $0.00 $5,998,187.74 $19,942,512.26 23% $5,604,797.47 $25,940,700.00 $0.00 $25f940f700.00 $1f192f809.52 16 $0.00 $5,998,187.74 $19,942,512.26 $5,604,797.47 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 FiscaVr tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS R ii�i("Jl 5. gys'�te�m I ot,aga�H�iils $192,600.00 $0.00 $192f600.00 $15,247.70 $0.00 $84,268.65 $108,331.35 44% $84,617.65 $192,600.00 $0.00 $192f600.00 $15,247.70 17 $0.00 $84,268.65 $108,331.35 $84,617.65 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 111111"""" iiiiis 0,51 . WlHlage Sys'te�m REVENUE oflliii....Illa° s .00 .00 .00 .00 .00 .00 .00 +++ .00 Ohai�-ges IlFoiii,- S&ryiii c.(,s 186,600.00 .00 186,600.00 14,891.75 .00 811141.05 105,458.95 43 821395.00 -ne429.20 31000.00 .00 31000.00 .00 .00 11570.80 1,429.20 52 11050.15 IIReveiii"i�i�je 31000.00 .00 31000.00 355.95 .00 11556.80 11443.20 52 1,172.50 1172.5001111 0 i::ieiiiFiiir.iaiir.i( iiir.ig So�iiti°ces .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS R ii�i("Jl 5. gys'�te�m I ot,aga�H�iils $192,600.00 $0.00 $192f600.00 $15,247.70 $0.00 $84,268.65 $108,331.35 44% $84,617.65 $192,600.00 $0.00 $192f600.00 $15,247.70 17 $0.00 $84,268.65 $108,331.35 $84,617.65 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS FL,fl'id G52 Sys,te�m IIIIeveuriue111...o tals $158,200.00 $0.00 $158f200.00 $13,795.20 $0.00 $66,760.43 $91,439.57 42% $65,956.34 $158,200.00 $0.00 $158f200.00 $13,795.20 IV $0.00 $66,760.43 $91,439.57 $65,956.34 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 iurid0,52 111�)a��Hkiung Sys'te�m ��Ieveunue 111111' a uiu REVENUE oflluiI a° s .00 .00 .00 .00 .00 .00 .00 +++ .00 Reveu�-IuLle .00 .00 .00 .00 .00 .00 .00 +++ .00 Oha�i-ges Il oui Scut -vices 156,000.00 .00 156,000.00 13,660.80 .00 65,448.20 90,551.80 42 64,974.00 [rxo�r'ne 1,000.00 .00 11000.00 .00 .00 747.33 252.67 75 440.19 01111hieuiIIReveur ui.je 11200.00 .00 11200.00 134.40 .00 564.90 635.10 47 542.15 OtlhieuiFiuria� riciuriiu� jjrces .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS FL,fl'id G52 Sys,te�m IIIIeveuriue111...o tals $158,200.00 $0.00 $158f200.00 $13,795.20 $0.00 $66,760.43 $91,439.57 42% $65,956.34 $158,200.00 $0.00 $158f200.00 $13,795.20 IV $0.00 $66,760.43 $91,439.57 $65,956.34 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS Fiwwll 060 V6hlitle tund Ill..., otals $2,052,358.00 $0.00 $2,052,358.00 $170,529.81 $0.00 $854,378.59 $1,197,979.41 42% $852,197.61 $2,052,358.00 $0.00 $2,052,358.00 $170,529.81 19 $0.00 $854,378.59 $1,197,979.41 $852,197.61 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD IL.... iirid 060 V6llh liiii IIII iiiiateinaince uiind REVENUE Glli,)iii'g(,s F'6i. iii vces 21046,358.00 .00 2f046,358.00 170,529.81 .00 852,649.05 1,193f708.95 42 850,344.50 11]wesb'ne�riit [rxoir'ne 61000.00 .00 61000.00 .00 .00 11729.54 41270.46 29 11853.11 01,1'ie�i-, IIR,eveiii ,ii�i�je .00 .00 .00 .00 .00 .00 .00 +++ .00 01,,I"ie��', So��� t� ces .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS Fiwwll 060 V6hlitle tund Ill..., otals $2,052,358.00 $0.00 $2,052,358.00 $170,529.81 $0.00 $854,378.59 $1,197,979.41 42% $852,197.61 $2,052,358.00 $0.00 $2,052,358.00 $170,529.81 19 $0.00 $854,378.59 $1,197,979.41 $852,197.61 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS R jiirid 061. V6VIII ,fitle I otals $2,337,100.00 $0.00 $2,337,100.00 $208,458.11 $0.00 $1,006,357.21 $1,330,742.79 43% $750,954.43 $2,337,100.00 $0.00 $2,337,100.00 $208,458.11 20 $0.00 $1,006,357.21 $1,330,742.79 $750,954.43 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 061. V6hWle REVENUE Glli,)��-g(� s F'6�- �rvces 132 100.00 21 1 .00 2 132 100.00 f I 177,675.01 .00 888,375.05 1 f243f724.95 42 671,374.95 Fiiiries & IlFoiii-feits 10,000.00 .00 10,000.00 71786.39 .00 71786.39 21213.61 78 11513.75 120,000.00 .00 120,000.00 16,256.46 .00 841780.52 35,219.48 71 15J15.11 .00 .00 .00 .00 .00 .00 .00 +++ .00 Vii: 1111hieiii IIReveii mii.je .00 .00 .00 .00 .00 .00 .00 +++ .00 OtlhieiiiFiiria� riciirig Sojirces 75,000.00 .00 75f000.00 61740.25 .00 25,415.25 49f 584.75 34 62,950.62 REVENUE TOTALS R jiirid 061. V6VIII ,fitle I otals $2,337,100.00 $0.00 $2,337,100.00 $208,458.11 $0.00 $1,006,357.21 $1,330,742.79 43% $750,954.43 $2,337,100.00 $0.00 $2,337,100.00 $208,458.11 20 $0.00 $1,006,357.21 $1,330,742.79 $750,954.43 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS FLEIIdl 062 CoiiinIllpu,teir iiiiid I otals $166,897.00 $0.00 $166,897.00 $13,574.75 $0.00 $71,559.39 $95,337.61 43% $87,018.05 $166,897.00 $0.00 $166,897.00 $13,574.75 21 $0.00 $71,559.39 $95,337.61 $87,018.05 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 iirid062, Coirnqptrteir IIIIII��. IIID REVENUE Glli,)iii-g(,s F'6i- iii vces 162,897.00 .00 162,897.00 13,574.75 .00 67,873.75 95f023.25 42 85,457.05 11]wesb'ne�riit [rxoir'ne 4,000.00 .00 4,000.00 .00 .00 3,685.64 314.36 92 1f561.00 _JS .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS FLEIIdl 062 CoiiinIllpu,teir iiiiid I otals $166,897.00 $0.00 $166,897.00 $13,574.75 $0.00 $71,559.39 $95,337.61 43% $87,018.05 $166,897.00 $0.00 $166,897.00 $13,574.75 21 $0.00 $71,559.39 $95,337.61 $87,018.05 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS Fiilii (Jl 063 1 otals $9,255,217.00 $0.00 $9,255,217.00 $783,508.52 $0.00 $3,758,769.04 $5,496,447.96 41% $3,734,767.93 $9,255,217.00 $0.00 $9,255,217.00 $783,508.52 22 $0.00 $3,758,769.04 $5,496,447.96 $3,734,767.93 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 063 Mainmn't 111111"""" iiiis REVENUE G lli,)��'g(,�s F'6�, �rvces 7 429,717.00 .00 7 429,717.00 f 605,171.34 .00 31012,799.42 4 f416f917.58 41 31010,077.81 11]wesb'neiiriit [rxo�r'ne 20,000.00 .00 20,000.00 912.63 .00 61241.56 13,758.44 31 81957.53 21000.00 .00 21000.00 211175.00 .00 24,894.03 (22,894.03) 1245 81145.68 01,1,-ieiii, IIReve,�i�i� je 11803,500.00 .00 11803,500.00 156,249.55 .00 714,834.03 11088,665.97 40 7071586.91 REVENUE TOTALS Fiilii (Jl 063 1 otals $9,255,217.00 $0.00 $9,255,217.00 $783,508.52 $0.00 $3,758,769.04 $5,496,447.96 41% $3,734,767.93 $9,255,217.00 $0.00 $9,255,217.00 $783,508.52 22 $0.00 $3,758,769.04 $5,496,447.96 $3,734,767.93 Revenue Budget by Account Classification Report ............ I .......... .VIII05/3 9 Fiscaear tly [III-161LAE.k d S L,,j III11111'n IIIIrn a I ................ isUIrlig REVENUE TOTALS FLEId 070 11126llll'iiiiic 111112eiiisimn I ol,"als $8,419,500.00 $0.00 $8,419,500.00 ($2,854,550.56) $0.00 $7,441,745.21 $977,754.79 88% $3,268,463.26 $8,419,500.00 $0.00 $8,419,500.00 ($2,854,550.56) 23 $0.00 $7,441,745.21 $977,754.79 $3,268,463.26 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 070 1111°)61ice REVENUE Glli,)��,g(,�s F'6�, S(,��rvces .00 .00 .00 .00 .00 .00 .00 +++ .00 11]wesb'neiiriit [rxoir'ne 31933,500.00 .00 3f933f500.00 (2f986f967.77) .00 5f231f492.23 (11297f992.23) 133 1f071f988.35 01,1'ieiii-, IlR,eveiii,ii�i�je 4f486f000.00 .00 4f486f000.00 1321417.21 .00 2f210f252.98 2,275,747.02 49 2,196,474.91 REVENUE TOTALS FLEId 070 11126llll'iiiiic 111112eiiisimn I ol,"als $8,419,500.00 $0.00 $8,419,500.00 ($2,854,550.56) $0.00 $7,441,745.21 $977,754.79 88% $3,268,463.26 $8,419,500.00 $0.00 $8,419,500.00 ($2,854,550.56) 23 $0.00 $7,441,745.21 $977,754.79 $3,268,463.26 Revenue Budget by Account Classification Report VIII05/3 9 VIII°��FiscaVr ������ ����� IIIII� 61LAEk L,,j III°°�n IIIIrn a I................ IIIIIs� 'lllll IIIIrl g Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account i is i Transactions c r c Transactions r cions Rec'd Prior Year YTD IL . iirid 071. 111111""""iiiii iiiii 111111)e itis iiiii is REVENUE 31586,000.00 .00 3,586,000.00 (11880,525.09) .00 41640,031.34 (1,054,031.34) 129 11158,624.08 i i::lhm iii. IlR iir-i je 41095,800.00 .00 4,095,800.00 117,839.03 .00 11975,351.22 21120,448.78 48 11790,015.97 REVENUE TOTALS $7,681,800.00 $0.00 $7,681,800.00 ($1,762,686.06) $0.00 $6,615,382.56 $1,066,417.44 86% $2,948,640.05 IL.... 111111 iiiir 111111°'° iiiiim 'iiiii 111111' k,iiiiind ...Ill..., islll $7,681,800.00 $0.00 $7,681,800.00 ($1,762,686.06) $0.00 $6,615,382.56 $1,066,417.44 $2,948,640.05 viii°..airmd...IIL..,otallls $144,883,991.00 $0.00 $144,883,991.00 $1,164,788.97 $0.00 $60,158,403.89 $84,725,587.11 $54,880,993.27 24 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS $57,408,719.00 $563f000.00 $57f971f719.00 $4,759,267.87 $1f355f295.25 $21,578,220.70 $35f038f203.05 40% $20,952,501.13 FL,fl,id 001 Geineiiiiz� l wndl ...Ill...,otals $57,408,719.00 $563f000.00 $57f971f719.00 $4,759,267.87 $1f355f295.25 $21f578f220.70 $35f038f203.05 $20,952,501.13 1 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 00�1. Geineir EXPENSE i-soiriial S(,Nrvic(,�s Sala��-ies & Wages 27,663,030.00 .00 27f663fO3O.00 3fO39,929.67 .00 10f6l8f093.17 17fO44f936.83 38 lOf345f442.20 Ill; iii lllsllls `)&iiel i1s 14f484f814.00 .00 14f 484f 814.00 6971192.21 .00 6f629f690.25 7f855f123.75 46 6f655f779.00 (,',ost,,s 582,976.00 (2f500.00) 580f 476. 00 31,327.72 28,748.05 209f 727.54 342f000.41 41 191,128.07 5,819.00 .00 51819.00 499.44 .00 2,497.20 3,321.80 43 2,424.45 Coiiiflll]i�ad,lua111 S&ivices 8,776,475.00 77,000.00 8,853,475.00 705f070.54 708f 730.02 3f214f601.59 4,930,143.39 44 2,998,151.62 utilit,�"'es 326,724.00 .00 326,724.00 21,646.29 .00 83,437.37 243,286.63 26 72f 344.52 1 �nsuliira�rice 549f 118.00 .00 549,118.00 45f 744.67 .00 228,752.55 320,365.45 42 173f 791.24 Co�rn�niodil,,Jies & &ijlplplies 832f905.00 10,000.00 842f905.00 46,534.74 67,683.14 219,253.69 555,968.17 34 271,003.75 Od'i&- [,lllsciii msiliii::u iii ; s 1f038f741.00 .00 1f038f741.00 .00 .00 102,936.74 935f804.26 10 .00 [,,3uildiiirig .00 12,000.00 12,000.00 .00 .00 7,874.97 4,125.03 66 388.30 office 40,430.00 10,000.00 50,430.00 2,330.90 .00 7,250.78 43f 179.22 14 9,504.61 247,887.00 .00 247f 887. 00 61,598.67 8,781.08 107f902.78 1311203.14 47 112f 102.53 [,)isl.]r li1,,Njtio�ri sl finis .00 .00 .00 .00 .00 .00 .00 +++ .00 [nfi astn ictl iire 11319,800.00 456f500.00 11776,300.00 107,393.02 541,352.96 146,202.07 1f088f744.97 39 120,440.84 ....... ... [V eirfix,x�j I ra"irisfeiii-s 11540,000.00 .00 11540,000.00 .00 .00 .00 1f540f000.00 0 .00 EXPENSE TOTALS $57,408,719.00 $563f000.00 $57f971f719.00 $4,759,267.87 $1f355f295.25 $21,578,220.70 $35f038f203.05 40% $20,952,501.13 FL,fl,id 001 Geineiiiiz� l wndl ...Ill...,otals $57,408,719.00 $563f000.00 $57f971f719.00 $4,759,267.87 $1f355f295.25 $21f578f220.70 $35f038f203.05 $20,952,501.13 1 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS Rfl'id 002 111�)6lft SeirV�ke wrid I otals $6,726,407.00 $0.00 $6,726,407.00 $1f483,200.13 $0.00 $1f483f628.13 $5,242,778.87 22% $593,481.63 $6,726,407.00 $0.00 $6f726f407.00 $1f483f200.13 $0.00 $1f483f628.13 $5,242,778.87 $593,481.63 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R i�rid 002, ���)6b't Se�rvice EXPENSE Caiib-acbjal Sirv"'ces .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 [,,3a'idIIG iii iiia ciiillls 111 31812,499.00 .00 3f812f499.00 .00 .00 .00 3f812f499.00 0 .00 ll]"mi: iii'esi::IlflllllllllXll iiriise 2f910f408.00 .00 2f910f408.00 11483,200.13 .00 1f483f200.13 1f427f207.87 51 590f 646.13 a E :% :qz l ,3,aai °fl< &I Fic (.:,a�IIF'E 3f500.00 .00 3f500.00 .00 .00 428.00 31072.00 12 2,835.50 iteiirfi vrid I arisfeirs .00 .00 .00 .00 .00 .00 .00 +++ .00 01,lliie�r 111iiiiriaricWliiiing Uses .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS Rfl'id 002 111�)6lft SeirV�ke wrid I otals $6,726,407.00 $0.00 $6,726,407.00 $1f483,200.13 $0.00 $1f483f628.13 $5,242,778.87 22% $593,481.63 $6,726,407.00 $0.00 $6f726f407.00 $1f483f200.13 $0.00 $1f483f628.13 $5,242,778.87 $593,481.63 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS Far id 02IllpitIll..., ol,,als $2,603,440.00 $860,000.00 $3,463,440.00 $20f602.81 $567,378.37 $139,220.24 $2,756,841.39 20% $152,672.66 $2,603,440.00 $860,000.00 $3,463,440.00 $20f602.81 $567,378.37 $139,220.24 $2,756,841.39 $152,672.66 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 02,0 CaIpit4l EXPENSE Caiib,-adual Siii v"'ces 79,590.00 15f000.00 94f 590. 00 .00 .00 529.90 94,060.10 1 .00 495f000.00 .00 495f000.00 .00 .00 .00 495f000.00 0 .00 I a'id 400f000.00 .00 400f 000. 00 .00 .00 .00 400f000.00 0 .00 266f000.00 198f500.00 464f 500. 00 51746.17 78,016.75 31,071.81 355f411.44 23 24,989.22 Office "qIii III` Yiiieiii °illl' .00 .00 .00 .00 .00 .00 .00 +++ .00 motaIII; �.lilllYffieirit 82,000.00 .00 82f 000. 00 .00 .00 .00 82,000.00 0 .00 01,lliieir "q 572f 100.00 101,500.00 673f600.00 10,603.91 434,436.82 88,936.90 150,226.28 78 117,567.94 708,750.00 545f000.00 1f253f750.00 4,252.73 54,924.80 18,681.63 1,180,143.57 6 10,115.50 .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS Far id 02IllpitIll..., ol,,als $2,603,440.00 $860,000.00 $3,463,440.00 $20f602.81 $567,378.37 $139,220.24 $2,756,841.39 20% $152,672.66 $2,603,440.00 $860,000.00 $3,463,440.00 $20f602.81 $567,378.37 $139,220.24 $2,756,841.39 $152,672.66 Expense Budget by Account Classification Report ............gum 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS R i�rid 02�3 S,t�ree't Cans,tiruc 1L..otalls $3f772f000.00 $905,000.00 $4,677,000.00 $93,360.46 $3,747, 123.55 $120,466.70 $809,409.75 83% $206f027.36 $3f772f000.00 $905f000.00 $4,677,000.00 $93,360.46 $3,747, 123.55 $120,466.70 $809,409.75 $206f027.36 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget -Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 02,3 S,t�ree't Canstiruc EXPENSE Caiib,-adual S(,irv"'ces 40,000.00 .00 40f 000. 00 .00 38,561.00 .00 1f439.00 96 11f430.00 .00 .00 .00 .00 .00 .00 .00 +++ .00 I a'id .00 .00 .00 .00 .00 .00 .00 +++ .00 3,,732f000.00 905,000.00 41637,000.00 93,360.46 31708,562.55 120,,466.70 807,970.75 83 194,,597.36 11]'.11 f dl I �Jcsf(:%��qz i a .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS R i�rid 02�3 S,t�ree't Cans,tiruc 1L..otalls $3f772f000.00 $905,000.00 $4,677,000.00 $93,360.46 $3,747, 123.55 $120,466.70 $809,409.75 83% $206f027.36 $3f772f000.00 $905f000.00 $4,677,000.00 $93,360.46 $3,747, 123.55 $120,466.70 $809,409.75 $206f027.36 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS FL,fl,-mea 02,4 111111"""' VIII Caatiroll s iiiii stiiii aiiii tliiii s 111111"""' iiiiss ...111...otall s $3,760,500.00 $461,000.00 $4,221,500.00 $8,819.73 $83,379.36 $143f090.40 $3,995f030.24 5% $114,824.16 $3,760,500.00 $461,000.00 $4,221,500.00 $8,819.73 $83,379.36 $143,090.40 $3f995f030.24 $114,824.16 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 02,4 1111"""" VIII Caatir6l Cans,tiructian 1111"""'4nd EXPENSE Caiib,-adual Sirv"'ces 120,000.00 .00 120f 000. 00 51821.91 50,411.51 9,443.21 60f 145.28 50 9,554.00 Utilities 3f500.00 .00 3f500.00 .00 .00 625.19 2,874.81 18 410.85 Cararnodil,,ies & Sq11 111 lies 5f000.00 .00 5f 000. 00.00 .00 .00 5f000.00 0 880.81 2,000.00 .00 2,000.00 .00 .00 .00 2,000.00 0 1f000.00 01111C°ieiii"qU"l�Yriie� it°illl' .00 .00 .00 .00 .00 .00 .00 +++ .00 IIC::iiis.airliillC°iwaiiiiimwciiims 80f000.00 .00 80,000.00 .00 3,650.00 7,146.25 69 203.75 13 600.00 [nfrasbn ictl iire 31550,000.00 461,000.00 41011,000.00 2,997.82 29,317.85 125,875.75 3f855f806.40 4 102,378.50 EXPENSE TOTALS FL,fl,-mea 02,4 111111"""' VIII Caatiroll s iiiii stiiii aiiii tliiii s 111111"""' iiiiss ...111...otall s $3,760,500.00 $461,000.00 $4,221,500.00 $8,819.73 $83,379.36 $143f090.40 $3,995f030.24 5% $114,824.16 $3,760,500.00 $461,000.00 $4,221,500.00 $8,819.73 $83,379.36 $143,090.40 $3f995f030.24 $114,824.16 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS ILuans'�tI ol,laliirx2!111oie& s $24,936,982.00 $0.00 $24,936,982.00 $531,142.13 $0.00 $979,988.22 $23,956,993.78 4% $0.00 $24,936,982.00 $0.00 $24,936,982.00 0 $531,142.13 $0.00 $979,988.22 $23,956,993.78 $0.00 Adopted Budget Amended Current Month YTD YTD Budget - YTD ®/ Used/ Account Classification Lud_qet Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 025 111111 1ice & IBijfll&ing Cans'tiiiiii EXPENSE Caiib,-actual Sirv"'ces 21316,174.00 .00 2,316,174.00 721151.64 .00 256f072.95 2f060f101.05 11 .00 22f620f808.00 .00 22f620f808.00 458,990.49 .00 723,915.27 21f896f892.73 3 .00 [,,3a'idIIG iii lii i cliff 111 111 .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS ILuans'�tI ol,laliirx2!111oie& s $24,936,982.00 $0.00 $24,936,982.00 $531,142.13 $0.00 $979,988.22 $23,956,993.78 4% $0.00 $24,936,982.00 $0.00 $24,936,982.00 0 $531,142.13 $0.00 $979,988.22 $23,956,993.78 $0.00 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS FL,fl'id IIIIIIeftise 1111'Aslposlull 111111' iiia ...III...,tall $4,502,185.00 $4,502,185.00 $55f000.00 $4,557,185.00 $397,839.39 $756.50 $1f679f410.22 $2,877,018.28 37% $1f633f974.57 $4,502,185.00 $55,000.00 $4,557,185.00 $397,839.39 $756.50 $1f679,410.22 $2f877f018.28 $1f633,974.57 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Ri iiri III111teftise 1111' )islposaVIII 111111"""" iiiir EXPENSE iii -soiiriial S(,Nrvic(,�s Sala��-ies & Wages 254,632.00 .00 254f632.00 33,884.57 .00 119,419.16 135,212.84 47 104,041.93 Ill; iii lll�lll `)&iiel i1,,s 112,676.00 .00 112,676.00 111128.76 .00 52,688.13 59,987.87 47 48f 876.84 01,1'i&-, (',osts if350.00 .00 if350.00 .00 .00 if350.00 .00 100 98.67 Coi�-il,],-a d,,ual iii likes 4f084f523.00 55,000.00 4,139,523.00 351,984.32 .00 1f483f521.10 2,656,001.90 36 1f463f677.20 UIJIIHIes J" 483.00 .00 483.00 13.24 .00 71.41 411.59 15 55.36 1 isuvr..airice 6,942.00 .00 61942.00 578.50 .00 2,892.50 41049.50 42 11,113.75 C .'6ni�rnodities & 9 ilp1plies 41,579.00 .00 41,579.00 250.00 756.50 19,467.92 21,354.58 49 6,110.82 EXPENSE TOTALS FL,fl'id IIIIIIeftise 1111'Aslposlull 111111' iiia ...III...,tall $4,502,185.00 $4,502,185.00 $55f000.00 $4,557,185.00 $397,839.39 $756.50 $1f679f410.22 $2,877,018.28 37% $1f633f974.57 $4,502,185.00 $55,000.00 $4,557,185.00 $397,839.39 $756.50 $1f679,410.22 $2f877f018.28 $1f633,974.57 Expense Budget by Account Classification Report ............gum 05/3 1 "1 9 6, Fiair Activity iii� ciled S u aiiiii JsUhili ig EXPENSE TOTALS F iir m 1. VIII4o,tiiia ax, 1 otals $1,867,173.00 $218,000.00 $2,085,173.00 $94,018.05 $1f148f285.70 $361f381.69 $575,505.61 72% $1, 117,832.95 $1,867,173.00 $218f000.00 $2,085,173.00 �610] $94,018.05 $1f148f285.70 $361f381.69 $575,505.61 $1, 117,832.95 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 041. IIIIYlatar ax111111' iii iiiis EXPENSE Caiib,-adual Sirv"'ces 360,173.00 .00 360f 173.00 171735.45 179,808.71 39f 298.90 141,065.39 61 103f057.16 Utilities 200f000.00 .00 200f 000. 00 .00 .00 28f 534.37 171,465.63 14 51,877.81 Cararnodil,,ies & Sou p1plies 357,000.00 .00 357,000.00 .00 11f256.17 211,670.21 134f073.62 62 210,076.48 .00 .00 .00 .00 .00 .00 .00 +++ .00 a ll,iie 950f000.00 218,000.00 11168,000.00 76f 282.60 9571220.82 81,878.21 128,900.97 89 752,821.50 EXPENSE TOTALS F iir m 1. VIII4o,tiiia ax, 1 otals $1,867,173.00 $218,000.00 $2,085,173.00 $94,018.05 $1f148f285.70 $361f381.69 $575,505.61 72% $1, 117,832.95 $1,867,173.00 $218f000.00 $2,085,173.00 �610] $94,018.05 $1f148f285.70 $361f381.69 $575,505.61 $1, 117,832.95 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS IlFuiiiiid 042, 1 ol 'ri 11I� cS, $365,649.00 $0.00 $365,649.00 $10,039.17 $0.00 $10,997.52 $354,651.48 3% $39f056.04 $365,649.00 $0.00 $365,649.00 9 $10,039.17 $0.00 $10,997.52 $354,651.48 $39,056.04 Adopted Budget Amended Current Month YTD YTD Budget - YTD ®/ Used/ Account Classification Bu Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R i�rid 042, G EXPENSE IIG :iii -soiiriial S(,Ni c(,�s Sala��J�es & Wages 37492.00 .00 37492.00 .00 .00 .00 37492.00 f 0 31045.00 Ill; iii lll�lll `)&iiel i1,, 6,,157.00 .00 61157.00 .00 .00 .00 6,157.00 0 560.59 01.1,i&-, C',ost.'s 1, 126.00 .00 11126.00 .00 .00 28.74 1f097.26 3 32.00 Coi�-fl,],-a d,,ual Seiii likes 320,313.00 .00 320,313.00 10f039.17 .00 10,,968.78 309,344.22 3 35,,407.96 Sq,)111JIHe 561.00 .00 561.00 .00 .00 .00 561.00 0 10.49 Otlk ieiir III; Ill iii mrlllliiiw.u.iires .00 .00 .00 .00 .00 .00 .00 +++ .00 I aiiiiid [�-n�lp� roveirneints .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS IlFuiiiiid 042, 1 ol 'ri 11I� cS, $365,649.00 $0.00 $365,649.00 $10,039.17 $0.00 $10,997.52 $354,651.48 3% $39f056.04 $365,649.00 $0.00 $365,649.00 9 $10,039.17 $0.00 $10,997.52 $354,651.48 $39,056.04 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS Fiwicl� 043 Asse�t Seizwre I otals $7f000.00 $0.00 $7,000.00 $2,709.45 $0.00 $14,803.77 ($7,803.77) 211% $25,075.80 $7,000.00 $0.00 $7,000.00 10 $2,709.45 $0.00 $14f803.77 ($7,803.77) $25f075.80 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification .. Eudget Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 043 Asset Seizitre111111"""' iuiiiis EXPENSE Ofli,- Costs 11000.00 .00 1f000.00 .00 .00 .00 1f000.00 0 .00 Canl,],-actual S&rvices 3f000.00 .00 3f000.00 .00 .00 .00 3f000.00 0 7,108.88 Cararnodil,,ies & Sqplplies .00 .00 .00 .00 .00 .00 .00 +++ 12f 109. 10 3f000.00 .00 3f000.00 21709.45 .00 14f803.77 (11f803.77) 493 5,857.82 EXPENSE TOTALS Fiwicl� 043 Asse�t Seizwre I otals $7f000.00 $0.00 $7,000.00 $2,709.45 $0.00 $14,803.77 ($7,803.77) 211% $25,075.80 $7,000.00 $0.00 $7,000.00 10 $2,709.45 $0.00 $14f803.77 ($7,803.77) $25f075.80 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS �Fusir°id 044 51,iare Ill..., otals $2f000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 0% $0.00 $2f000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 11 $0.00 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 044 51iare111111' iiiu EXPENSE Caiib-acbjal Sirv"'ces 11000.00 .00 1f000.00 .00 .00 .00 1f000.00 0 .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 1,1'iiii-, [,l"U"lpiiieiiiAI 0eqin, if000.00 .00 1f000.00 .00 .00 .00 1f000.00 0 .00 EXPENSE TOTALS �Fusir°id 044 51,iare Ill..., otals $2f000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 0% $0.00 $2f000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 11 $0.00 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS Fiw,x',Jl 045 111111 t fl111111' iiiis 111111' u„ iiiis w ...Ill..., otals $5f000.00 $0.00 $5,000.00 $0.00 $0.00 $6,177.95 ($1,177.95) 124% $3,330.30 $5,000.00 $0.00 $5,000.00 $0.00 $0.00 $6,177.95 ($1,177.95) 12 $3,330.30 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 045 EXPENSE Ofli,- Costs 11000.00 .00 1f000.00 .00 .00 500.00 500.00 50 .00 Cani.]-actual S&rvices 1f000.00 .00 1f000.00 .00 .00 .00 1f000.00 0 .00 A 3fOOO.00 .00 3f000.00 .00 .00 5,677.95 (2f677.95) 189 3,330.30 I �-a"iisfe�� s .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS Fiw,x',Jl 045 111111 t fl111111' iiiis 111111' u„ iiiis w ...Ill..., otals $5f000.00 $0.00 $5,000.00 $0.00 $0.00 $6,177.95 ($1,177.95) 124% $3,330.30 $5,000.00 $0.00 $5,000.00 $0.00 $0.00 $6,177.95 ($1,177.95) 12 $3,330.30 Expense Budget by Account Classification Report ............gum 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS Fix'id 046 ax,, IIIIIIIIloai�llld I Ulls $68,000.00 $0.00 $68,000.00 $1,148.20 $0.00 $7,528.96 $60,471.04 11% $18,699.09 $68,000.00 $0.00 $68,000.00 13 $1,148.20 $0.00 $7,528.96 $60,471.04 $18,699.09 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 046 ax lBoard111111"""' iiiis EXPENSE Ofli,- Costs 15,000.00 .00 15f000.00 627.90 .00 3,320.91 11f679.09 22 1, 567.07 Cani.]-actual S&rvliices 10,500.00 .00 10,500.00 520.30 .00 4f208.05 6,291.95 40 3,308.68 iirisui�'a'ice 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 &SqplplH�es 13f000.00 .00 13f000.00 .00 .00 .00 13f000.00 0 5,179.74 II,30ildliirig [riilllYi moveiir-neii� fl.'s 5f000.00 .00 5,000.00 .00 .00 .00 51000.00 0 .00 Otl� ieiii [, q E"'lllYffie�rit 24,000.00 .00 24,000.00 .00 .00 .00 24,000.00 0 8,643.60 EXPENSE TOTALS Fix'id 046 ax,, IIIIIIIIloai�llld I Ulls $68,000.00 $0.00 $68,000.00 $1,148.20 $0.00 $7,528.96 $60,471.04 11% $18,699.09 $68,000.00 $0.00 $68,000.00 13 $1,148.20 $0.00 $7,528.96 $60,471.04 $18,699.09 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig 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 0481111111 iii"kness 1111'�)is,tirict111111"""' iii iiiir EXPENSE .00 .00 .00 .00 .00 .00 .00 +++ .00 ll]'itei�-est 'Xp&iise 11525,000.00 .00 1f525f000.00 48f 589.09 .00 154f 188.51 1f370f811.49 10 157f 111.48 EXPENSE TOTALS Faand 048 1 oi:: 111cz,; $1,525,000.00 $0.00 $1f525f000.00 $48,589.09 $0.00 $154,188.51 $1f370f811.49 10% $157,111.48 $1,525f000.00 $0.00 $1f525f000.00 14 $48,589.09 $0.00 $154,188.51 $1,370,811.49 $157,111.48 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS t Fuirid 049 1111°Y�ros��pect and 114ai�n 11", isr�hict . .......Ilstsls $10,229,238.00 $805,000.00 $11f034f238.00 $267,550.38 $319,872.80 $592,393.34 $10f121,971.86 8% $6,178,943.18 $10,229,238.00 $805,000.00 $11,034,238.00 15 $267,550.38 $319,872.80 $592,393.34 $10,121,971.86 $6,178,943.18 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 049 ���)�ros�pect and Maiin 111111°°"'IIID 111111"""' 111111 �iiiiis°tiriiiut EXPENSE Ofli,- Costs 21700.00 .00 2,700.00 .00 .00 600.00 2,100.00 22 600.00 Cani.]-actual S&rvices 283f300.00 .00 283f300.00 40,401.98 71,372.80 84f 292.07 127,635.13 55 179f 777.64 Cararnodil,,ies & Sqplplies 1f500.00 .00 1f500.00 .00 .00 .00 if5OO.00 0 .00 2f699f000.00 95,500.00 2,794,500.00 10,780.02 .00 287f 682.89 2,506,817.11 10 5,927,292.29 Ill..... arxll [r-q,Ymover il.'s .00 709,500.00 709f 500. 00 .00 .00 3,450.00 706,050.00 0 .00 11113u jildiirig 6f000f000.00 .00 61000,000.00 .00 248f 500. 00 .00 51751,500.00 4 .00 [nfrastn ictl ire 810,000.00 .00 810,000.00 .00 .00 .00 810,000.00 0 .00 [,,3aiid .00 .00 .00 .00 .00 .00 .00 +++ .00 a: to -est 'Ills (,Niise 432,738.00 .00 432,738.00 216,368.38 .00 216f 368.38 216,369.62 50 71,273.25 Ill;t 8t IlFi",sscal Il Fees .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS t Fuirid 049 1111°Y�ros��pect and 114ai�n 11", isr�hict . .......Ilstsls $10,229,238.00 $805,000.00 $11f034f238.00 $267,550.38 $319,872.80 $592,393.34 $10f121,971.86 8% $6,178,943.18 $10,229,238.00 $805,000.00 $11,034,238.00 15 $267,550.38 $319,872.80 $592,393.34 $10,121,971.86 $6,178,943.18 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS Adopted Budget Amended Current Month YTD YTD Budget - YTD ®/ Used/ Account Classification Budget -Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 0,50 Wa,teir aiit EXPENSE i-soiriial S(,Nrvic(,�s Sala��-ies & Wages 2 199,835.00 .00 2 199f835.00 f 255,157.43 .00 907184.80 f 1 292f650.20 41 943 030.26 `)&iiel i1,,s 871,240.00 .00 871,240.00 83,683.67 .00 381,418.41 489,821.59 44 386f869.38 (,',ost,,s 44,464.00 .00 44,464.00 41154.80 1f482.35 28,231.43 14,750.22 67 25,349.76 Coi�-il,],-ad,,ua111 iii likes 9,174,756.00 50,000.00 9,224,756.00 723,022.30 356,560.07 2,839,980.51 6,028,215.42 35 2,869,764.24 ul,lilil,"J"es 162,710.00 .00 162,710.00 2f099.50 .00 20f 099.17 142,610.83 12 43f 577.64 1 isuvr..airice 117,789.00 .00 1171789.00 9,815.75 .00 49f078.75 68,710.25 42 39f 559.20 C .'6ni�rnodities & 9 ilp1plies 336f045.00 .00 336,045.00 22,493.27 78,816.22 87f 242.91 169,985.87 49 41,806.23 .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 285f000.00 .00 285f000.00 .00 .00 1f440.00 283,560.00 1 1f450.00 office 1f081.00 .00 1f081.00 .00 .00 .00 1f081.00 0 .00 212,429.00 .00 212,429.00 .00 21,333.00 17f 234.76 173,861.24 18 51,565.31 [,)isl.]r li1,,Njtioiri Sysl,leinis 5,561,142.00 21041,500.00 71602,642.00 401,923.04 2f714f649.91 870f073.02 4,017,919.07 47 142f 198.32 [nfi asbn ictl iire .00 .00 .00 .00 .00 .00 .00 +++ .00 [)iriincilpal 240f000.00 .00 240f 000. 00 .00 .00 .00 240f000.00 0 .00 [nt(,N,-(,St 'III einse 343,081.00 .00 343,081.00 171,541.00 .00 171,541.00 171,540.00 50 74f 297.58 IIC;3airilllk iii ,sscal IIFees .00 .00 .00 .00 .00 .00 .00 +++ .00 ....... ..... .00 .00 .00 .00 .00 .00 .00 +++ .00 I oi�'ig 1 .00 .00 .00 .00 .00 .00 .00 +++ .00 $19,549,572.00 $2,091,500.00 $21f641f072.00 $1f673f890.76 $3,172,841.55 $5,373,524.76 $13f094,705.69 39% $4,619,467.92 Fiwicll 0,5teir airtd Seweiiumlll I otals $19f549f572.00 $2,091,500.00 $21,641,072.00 $1,673,890.76 $3f172f841.55 $5f373f524.76 $13,094,705.69 $4f619f467.92 16 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS uiir.iQ"il. WlHlage 1112aiii Hkiing Sys'teiiim Ill..., ol,lals $146,101.00 $0.00 $146,101.00 $7,661.54 $8,399.77 $29,598.54 $108,102.69 26% $60,960.83 $146f101.00 $0.00 $146,101.00 17 $7,661.54 $8,399.77 $29,598.54 $108,102.69 $60,960.83 Adopted Budget Amended Current Month YTD YTD Budget - YTD ®/ Used/ Account Classification Budget Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 0,51. ilii lHlage Sys'teiiim EXPENSE [ iii '-soiiriial S(,Nrvic(� s ,� , Sala��-ies & Wages 16,916.00 .00 l6f916.00 31988.96 .00 14167.78 f 2748.22 f 84 15f 523.67 Ill; iii lll�lll `)&iiel i1,,s 6,825.00 .00 6,825.00 1f364.92 .00 6f020.89 804.11 88 7,355.69 Coinl,],-acl ual Seiii- vic(� !Is 64f006.00 .00 64f 006. 00 21283.91 6,399.77 7,978.12 49,628.11 22 8f028.97 285.00 .00 285.00 23.75 .00 118.75 166.25 42 272.50 Sq,)lllJlie 563.00 .00 563.00 .00 .00 563.00 .00 100 .00 Otlk ielir III; Ill ciii mrlllliiiw.�.iires .00 .00 .00 .00 .00 .00 .00 +++ .00 [,,3uildiirigs .00 .00 .00 .00 .00 .00 .00 +++ .00 7f5O6.00 .00 7f 506. 00 .00 .00 .00 7, 506.0 0 .00 50f000.00 .00 50f 000. 00 .00 21000.00 750.00 47,250.00 6 29,780.00 .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS uiir.iQ"il. WlHlage 1112aiii Hkiing Sys'teiiim Ill..., ol,lals $146,101.00 $0.00 $146,101.00 $7,661.54 $8,399.77 $29,598.54 $108,102.69 26% $60,960.83 $146f101.00 $0.00 $146,101.00 17 $7,661.54 $8,399.77 $29,598.54 $108,102.69 $60,960.83 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS IlFuiir.i7 IIIIIIaiiiHkliSys"ii iiiu IlllllZ.eveiimie I ol,lals $155,108.00 $0.00 $155,108.00 $25,751.51 $14,828.52 $48,785.71 $91,493.77 41% $50f703.42 $155,108.00 $0.00 $155,108.00 IV $25,751.51 $14,828.52 $48,785.71 $91,493.77 $50,703.42 Adopted Budget Amended Current Month YTD YTD Budget - YTD ®/ Used/ Account Classification Bu Amendments B t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 111111"""' iiiu 0,52 ���)a��Hklng Sys'teim IIIIeveiiinue EXPENSE ['(,N'-soi�iial S(,iii its s, SalaiiiJ�es & Wages 15,576.00 .00 15,576.00 31642.97 .00 12f 968.50 2f607.50 83 11f341.39 Ill; iii lllslll `)&iiel i1s 6,562.00 .00 6,562.00 11234.48 .00 5,445.51 1, 116.49 83 5,426.43 Coinl,],-acl ual Seiii-Vb!Is 112f083.00 .00 112f083.00 20,684.61 12f 069.87 24,895.45 75f 117.68 33 27f 580.09 UIJIIHIJ"es 9f799.00 .00 9f 799. 00 165.12 .00 1f027.60 8,771.40 10 1f943.01 aiiiicle 292.00 .00 292.00 24.33 .00 121.65 170.35 42 402.90 CGTH'Tlodt�es & St 1Ill)lll)IHes 10f796.00 .00 10,796.00 .00 2,758.65 4,327.00 31710.35 66 .00 01,lliieir "Xlpeirici'll iiii,-es .00 .00 .00 .00 .00 .00 .00 +++ .00 [,,3011dlii iigs .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ 4,009.60 .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS IlFuiir.i7 IIIIIIaiiiHkliSys"ii iiiu IlllllZ.eveiimie I ol,lals $155,108.00 $0.00 $155,108.00 $25,751.51 $14,828.52 $48,785.71 $91,493.77 41% $50f703.42 $155,108.00 $0.00 $155,108.00 IV $25,751.51 $14,828.52 $48,785.71 $91,493.77 $50,703.42 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS Fwuiiic�le Mai�n'te�na�ince Ill..., .t $2,034,247.00 $2,034,247.00 $0.00 $2f034f247.00 $179f074.48 $176,667.41 $871f244.67 $986,334.92 52% $982,726.65 $2,034,247.00 $0.00 $2f034f247.00 19 $179,074.48 $176,667.41 $871,244.67 $986,334.92 $982,726.65 Adopted Budget Amended Current Month YTD YTD Budget - YTD ®/ Used/ Account Classification Budget Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R inaid Ilh'u IIII iuuateunaance uiund EXPENSE IIG a-ssur iial S(,Nrvic& Wages 947,587.00 .00 947f 587. 00 121,854.08 .00 435f334.46 512252.54 ,l 46 446f 679.19 `&iiel i1,, 357,549.00 .00 357,549.00 36,532.44 .00 155,776.61 201,772.39 44 254,776.83 01.1,i&-, C',ost.'s 4,167.00 .00 4,167.00 375.00 .00 1f387.40 2,779.60 33 1f662.03 Coui-il,],-a d,,ual Seuivices 111f883.00 .00 111f883.00 16,819.09 21,575.59 39,916.04 50,391.37 55 37f 176.04 ul,lilil,'J"es 3,392.00 .00 3,392.00 380.90 .00 1f882.20 11509.80 55 1f790.05 I isuvr..aurice 11f706.00 .00 111706.00 975.50 .00 4,877.50 61828.50 42 .00 C .'6ni�rnodities & 9 ilp1plies 593f408.00 .00 593,408.00 2,137.47 155,091.82 232f000.04 206,316.14 65 239,854.31 .00 .00 .00 .00 .00 .00 .00 +++ .00 Office 614.00 .00 614.00 .00 .00 70.42 543.58 11 298.20 A od'1(11�,- [,� I 3f941.00 .00 3f941.00 .00 .00 .00 3f941.00 0 490.00 EXPENSE TOTALS Fwuiiic�le Mai�n'te�na�ince Ill..., .t $2,034,247.00 $2,034,247.00 $0.00 $2f034f247.00 $179f074.48 $176,667.41 $871f244.67 $986,334.92 52% $982,726.65 $2,034,247.00 $0.00 $2f034f247.00 19 $179,074.48 $176,667.41 $871,244.67 $986,334.92 $982,726.65 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 061. V6hWle EXPENSE 0fl11(,N,- [, 111 iii �liii ii iii .00 .00 .00 .00 .00 .00 .00 +++ .00 mota,- [ ......... .. . 11073,000.00 852,000.00 1f925f000.00 2,370.47 862,970.35 133,269.17 928,760.48 52 67f 617.44 [iA,,&"fuiiiid I i-a,iisf'( �ii`s .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS FLEr°lld1. V61ii $1,073f000.00 $852,000.00 $1f925f000.00 $2,370.47 $862,970.35 $133,269.17 $928,760.48 52% $67,617.44 $1,073f000.00 $852,000.00 $1,925,000.00 20 $2,370.47 $862,970.35 $133,269.17 $928,760.48 $67,617.44 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS lFulir°id 062, CailnIllpu,tei111111, Illld lull m ilium iiiu °IIID 111111"""'u iiiu ...Ill..., .tall $412,900.00 $412f9OO.00 $75,000.00 $487,900.00 $23,451.44 $11f951.66 $67,607.79 $408,340.55 16% $34,122.91 $412f900.00 $75,000.00 $487,900.00 21 $23,451.44 $11f951.66 $67f607.79 $408,340.55 $34,122.91 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 062, Cam�ptrte�rVIII iiii��iiiir 111111"""' iiiu IIIIII'�. IIID EXPENSE .00 .00 .00 .00 .00 .00 .00 +++ .00 250,000.00 .00 250f000.00 .00 .00 .00 250f000.00 0 .00 office 162,900.00 75f000.00 237,900.00 23,451.44 11f951.66 67f607.79 158,340.55 33 34f 122.91 EXPENSE TOTALS lFulir°id 062, CailnIllpu,tei111111, Illld lull m ilium iiiu °IIID 111111"""'u iiiu ...Ill..., .tall $412,900.00 $412f9OO.00 $75,000.00 $487,900.00 $23,451.44 $11f951.66 $67,607.79 $408,340.55 16% $34,122.91 $412f900.00 $75,000.00 $487,900.00 21 $23,451.44 $11f951.66 $67f607.79 $408,340.55 $34,122.91 Expense Budget by Account Classification Report ............gum 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS R 063 IIIIIIIiiiiisk I otals $9f208f873.00 $0.00 $9,208,873.00 $682,379.80 $0.00 $4f066f757.47 $5,142,115.53 44% $4,687,158.98 $9f208f873.00 $0.00 $9,208,873.00 22 $682,379.80 $0.00 $4f066f757.47 $5,142,115.53 $4,687,158.98 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Bu Amendments B t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R i�rid 063 Manage�me�n't 111111"""' iiiir EXPENSE Caiib-acbjal S(,irv"'ces 40,000.00 .00 40f 000. 00 .00 .00 4f800.00 35f200.00 12 .00 iiriwi'a,iice 9,146,373.00 .00 9,146,373.00 6821234.73 .00 4f059f281.74 5,087,091.26 44 4,685,350.83 CararnodlI,Js & Sq11 111 lHies 22f500.00 .00 22f500.00 145.07 .00 2,675.73 19,824.27 12 695.50 .00 .00 .00 .00 .00 .00 .00 +++ if 112.65 ll]' -Il , f dlI °Jcsf(:%��-qz I Z) i .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS R 063 IIIIIIIiiiiisk I otals $9f208f873.00 $0.00 $9,208,873.00 $682,379.80 $0.00 $4f066f757.47 $5,142,115.53 44% $4,687,158.98 $9f208f873.00 $0.00 $9,208,873.00 22 $682,379.80 $0.00 $4f066f757.47 $5,142,115.53 $4,687,158.98 Expense Budget by Account Classification Report ............ 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS R jsir id070 111261ice 111�)eiiisian wrid I (Azils $5f985f209.00 $0.00 $5,985,209.00 $486,351.89 $0.00 $2f424f091.13 $3,561,117.87 41% $2,184,620.33 $5,985,209.00 $0.00 $5,985,209.00 23 $486,351.89 $0.00 $2f424f091.13 $3,561,117.87 $2,184,620.33 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget -Amendments Budg t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 070 111111°' Ilio 1111°)einsian 111111' �iiiis EXPENSE 51790,809.00 .00 5,790,809.00 471,324.93 .00 2,375,976.29 3f414f832.71 41 2,135,555.22 Canl,]actual S&rvices 167f300.00 .00 167f300.00 7f026.96 .00 40f 114.84 127f 185.16 24 41,065.11 iirisui�'a'ice 15f000.00 .00 15f000.00 .00 .00 .00 15f000.00 0 .00 & Sqplplies 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 0111, 1h°ieiiiICJi lll,"U ["E'll'"S' 12,000.00 .00 12f 000. 00 8f000.00 .00 8f000.00 41000.00 67 8f000.00 Office 11 0 Iiilll lllTiIii llrit .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS R jsir id070 111261ice 111�)eiiisian wrid I (Azils $5f985f209.00 $0.00 $5,985,209.00 $486,351.89 $0.00 $2f424f091.13 $3,561,117.87 41% $2,184,620.33 $5,985,209.00 $0.00 $5,985,209.00 23 $486,351.89 $0.00 $2f424f091.13 $3,561,117.87 $2,184,620.33 Expense Budget by Account Classification Report ............gum 05/3 1 "1 9 6, Fiair Activity iii� ciled S uiiiiiI'n iiiiiiiiii JsUiliig EXPENSE TOTALS Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ $0.00 Account Classification .. Eudget Amendments Budg t Transations c Enumbanes crc Tansations rc Tansations rc Rec'd Prior YeaYTD r R i�rid 071. ���)e�nsian G-a,iid ...Ill...,cAals $162,538,139.00 EXPENSE $6f885f500.00 $169,423,639.00 $11f329f249.94 $11f469,750.79 $42f912f792.04 $115,041,096.17 $46,365,835.58 61032,036.00 .00 6f032f036.00 5141241.19 .00 2,569,209.13 3,462,826.87 43 2,426,897.58 Canl,],-actual S&rvices 136f700.00 .00 136f700.00 7f605.00 .00 49f022.32 87f 677.68 36 49,839.17 iirisuiii'a'ice 15f000.00 .00 15f000.00 .00 .00 .00 15f000.00 0 .00 & Sqplplies 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 01111h°ieiiiICJ� i lll,"U ["E'lS' 10,000.00 .00 10,000.00 8,185.00 .00 8,185.00 11815.00 82 8,190.00 $6,193,836.00 $0.00 $6,193,836.00 $530,031.19 $0.00 $2f626f416.45 $3,567,419.55 42% $2,484,926.75 FILAII(i 071.111111 iiiir 111112eiiuss'iiiiiari I otals $6,193,836.00 $0.00 $6,193,836.00 $530,031.19 $0.00 $2f626f416.45 $3,567,419.55 $2,484,926.75 G-a,iid ...Ill...,cAals $162,538,139.00 $6f885f500.00 $169,423,639.00 $11f329f249.94 $11f469,750.79 $42f912f792.04 $115,041,096.17 $46,365,835.58 24 Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: DIRECTOR OF FINANCE DATE: JUNE 12, 2019 SUBJECT: MONTHLY FINANCIAL REPORT — MAY 2019 Attached hereto are the cash position and investment statements of the Village for the month ended May 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 April 30 was $67.2 million. During May, cash receipts totaled $6,734,281 and investment income was $109,511. Reductions in cash and cash equivalents during May totaled $9,266,721. Of this amount, payments to vendors were $6,976,247 and employee payroll expenses were $2,274,829. Outflows resulting from interfund activity totaled $1,315 while other reductions to cash totaled $15,645. There was also a net transfer from investment of $3,782,961. Cash and cash equivalents at May 31 were $68.6 million. Investments in the Governmental and Enterprise Funds at April 30 were $29,066,500. Investment activity during the month of May included investment income totaling $55,609 and a net transfer to cash of $3,782,961. 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 May 31 were $25,339,149. Total cash and investments for Governmental and Enterprise Funds at April 30 were $96,295,505. Cash and investments decreased $2,368,636 for the month. Cash and investments at May 31 totaled $93,926,869. Monthly Financial Report — May 2019 June 12, 2019 Page 2 Trust and Agency Funds - Cash and cash equivalents at April 30 was $5,533,997. During May, cash receipts totaled $269,945. Investment income for the month was $146,612. Cash investment activities resulted in a net increase of $210,672 while inflows due to Interfund activity totaled $1,315. Reductions in cash and cash equivalents during May totaled $1,038,042. Of this amount, payments to vendors were $166,969 and employee payroll and related expenses were $868,148. Other disbursements totaled $2,925. Cash and cash equivalents at May 31 were $5,124,500. Total investments at May 31 were $133,505,113, a decrease of $5,206,279 from April 30. Investment loss of $4,995,607 and a net transfer to investments of $210,672 accounted for the change. Total cash and investments for Trust and Agency Funds at April 30 were $144,245,389. Cash and investments decreased $5,615,776 for the month and totaled $138,629,613 at May 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 April 30 totaled $20,588,815. During May, cash receipts totaled $3,956,271, and investment income was $69,909. 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 May totaled $1,501,669. Sales taxes received in May are for taxes generated from sales in March. 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 May totaled $1,087,748. Income taxes collected by the State in April are received by the Village in May. Disbursements from the General Fund for May included payments to vendors of $1,874,832, interfund transfers of $849,320, payments for employee wages and benefits of $2,002,729 and other disbursements of $8,494. Cash and cash equivalents at May 31 were $19,879,621, a decrease of $709,195 from April 30. In addition, investments consisting of certificates of deposit were $1,235,373. Cash and investments for the General Fund at May 31 totaled $21,114,994. Monthly Financial Report — May 2019 June 12, 2019 Page 3 Statement of Investments (page 6-71 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 May 31, $25,339,148 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 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. 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 May 31, there was a total of $133,505,113 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 May 31, 2019 GOVERNMENTAL AND ENTERPRISE FUNDS Disbursements: Accounts payable Payroll Flex spending Other Balance at May 31, 2019 (166,969.01) (838,056.42) (30,091.24) (2,925.21) (166,969.01) (838,056.42) (30,091.24) (2,925.21) $ 5,124,499.99 $ 133,505,113.18 $ 138,629,613.17 Assets are restricted in purpose and do not represent discretionary assets of the government. Cash and Cash Total Cash and Equivalents Investments Investments Balance at April 30, 2019 $ 67,229,004.48 $ 29,066,500.44 $ 96,295,504.92 Cash receipts 6,734,280.59 6,734,280.59 Investment income 109,511.04 55,608.87 165,119.91 Transfers from investments to cash 3,782,960.79 (3,782,960.79) - Transfers to investments from cash - - - Interfund activity (1,315.13) (1,315.13) Disbursements: Accounts payable (6,976,247.05) (6,976,247.05) Payroll (2,274,828.65) (2,274,828.65) Other (15,645.22) (15,645.22) Balance at May 31, 2019 $ 68,587,720.85 $ 25,339,148.52 $ 93,926,869.37 TRUST AND AGENCY FUNDS Cash and Cash Total Cash and Equivalents Investments Investments Balance at April 30, 2019 $ 5,533,997.08 $ 138,711,391.83 $ 144,245,388.91 Cash receipts 269,945.45 269,945.45 Investment income (loss) 146,612.28 (4,995,606.72) (4,848,994.44) Transfers from investments to cash 1,643,256.60 (1,643,256.60) - Transfers to investments from cash (1,432,584.67) 1,432,584.67 - Interfund activity 1,315.13 1,315.13 Disbursements: Accounts payable Payroll Flex spending Other Balance at May 31, 2019 (166,969.01) (838,056.42) (30,091.24) (2,925.21) (166,969.01) (838,056.42) (30,091.24) (2,925.21) $ 5,124,499.99 $ 133,505,113.18 $ 138,629,613.17 Assets are restricted in purpose and do not represent discretionary assets of the government. C z Z) LL z w z LU (f7 v N 0 iz c ;c, V r (N 07 0) 0 to 0 m m CD -Z C'4 CY CY ar to (D o7P- 0 m t- a 0 �0 0 00 m to ��,! g N 0 NCi N CD m cy� uj S LL � - Ni to (0 m. >o w�uE 9 w o, z to C1Il4 m 8 > m = E 4 4 4 qJ uj C� N i 14mm cL g W (D W d) to 6 E E E w (0 W 0 fl pl: 06 P.: D co (a co (M m to Cl) (N C? U7 m uj (0 ON F- LO >- L) '7 N C'j Z ui to at t- to6 MVM N g i 114� C� (�i to; cc to -n (D Er Z < Z) 0 U - z 0 < cn IT mw CO z uj z In a) C14 m m < L) 0 cv cy� C� Lu U) co (0 Cl) CN 00 0) , m 0) 0) to 0 m 0 z R :, �2 C7 IL uj (N Cl) In to N co UJ C� - M co (0 1 , I Cry rty �_: I - to u. dJ =) U) Z 0ffl (le Lu ui z co 0) N to z um �2 (N 0 0:t (47 til ui 0 'n co 0 EE '0 cr-,, 'N. U7, q CN LL 0) A M N t (0 r' h I - C7 8 of z r, -T R , '0 rl�. cl� M 2 ui �) -i U- - - r� 40 M Us 00 10 < z (0 (0 CN N LU (a CD r7 Calz C7 '7 Z:� Li. 0) CO 04 0 InN w W In I m .1 x LU cn LU V r m N roc) . (0 1 (6 01 ��4 N cG7 C'4 co 1 tz Cl) CD m uj S LL m. >o w�uE 9 w o, z (6 8 > m = E 4 4 4 qJ uj cL g W (D W d) to 6 E E E N W 0 ntl .E w at _ID _ID e' E2 P cc LL (a co (M m to Cl) (N C? U7 m uj 01 F- A zo dN D 0 - CO CN 0) m 47 C,4 to m U) to -n U. CL LU cn LU U) Z D LL ui (N Cl) In to N 00 UJ C� - M co (0 1 , I Cry rty �_: I - to u. dJ =) U) Z 0ffl w �.2 4C7 Lu ui z 0) 02 (N cv M LL to (0 to z 90 cc to N - (1) 1- to N m m o co N 0 0) 0 CN LL V; P� 0 N CA -0 C4, aMi aYm rl-� aq N CRt*7 h I - C7 WIQ .0 (0 C) § C7 Z 0 c6 LU N 0 (a V r m at 0) 0 <6 E >o w�uE 9 w o, a(u CL r- 8 > m = E 4 4 4 qJ U) m C} cL g W (D W d) to 6 E E E N W 0 ntl .E w at _ID _ID e' E2 P cc LL (a W > Q) ODOM t.7tOU ht -z uj - 0 F- VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of May 31, 2019 GOVERNMENTAL AND ENTERPRISE FUNDS Maturity Purchase Financial Investment CUS1P/ 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% S 1,235,372.97 1,235,372.97 POLICE & FIRE BUILDING CONSTRUCTION FUND (025) 06/05/19 12/21/18 BMO Harris Bank, NA, 1L Certificate of Deposit 16571 2.430% 3,000,000.00 07/03/19 12/21/18 BMO Harris Bank, NA, IL Certificate of Deposit 16571 2.430% 3,000,000.00 08/07/19 12/21/18 BMO Harris Bank, NA, IL Certificate of Deposit 16571 2.480% 3,000,000.00 08/31/19 12/21/18 US Treasury Note US Treasury Note 91282STNO 2.549% 2,506,059.18 09/30/19 12/21/18 US Treasury Note US Treasury Note 912828TRI 2.562% 2,005,712.87 10/31/19 12/21/18 US Treasury Note US Treasury Note 91282SF62 2.581% 1,504,573.06 12/04/19 12/21/18 Capital Community Bank, UT Certificate of Deposit 33823 2.730% 243,600.00 12/04/19 12/21/18 Northeast Community Bank, NY Certificate of Deposit 29147 2.727% 243,600.00 12/04/19 12/21/18 First Capital Bank, TN Certificate of Deposit 57552 2.650% 243,800.00 12/04/19 12/21/18 Bank of China, NY Certificate of Deposit 33653 2.590% 243,900.00 12/04/19 12/21/18 Orrstown Bank, PA Certificate of Deposit 713 2.520% 244,100.00 12/04/19 12/21/18 Financial Federal Bank, TN Certificate of Deposit 31840 2.520% 244,100.00 12/15/19 12/21/18 US Treasury Note US Treasury Note 91282SU73 2.602% 1,168,895.88 01/31/20 12/21/18 US Treasury Note US Treasury Note 912828H52 2.599% 1,082,251.19 02/29/20 12/21/18 US Treasury Note US Treasury Note 912828UQI 2.641% 1,003,935.37 04/08/20 12/21/18 Servisfirst Bank, FL Certificate of Deposit 57993 2.784% 241,200.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% 241,500.00 04/08/20 12/21/18 Bank OZK, AR Certificate of Deposit 110 2.623% 241,700.00 05/06/20 12/21/18 CFC Community Bank, MD Certificate of Deposit 34294 2.743% 240,900.00 05/06/20 12/21/18 First Internet Bank of Indiana, IN Certificate of Deposit 34607 2.725% 240,900.00 05/06/20 12/21/18 Modern Bank, National Association, NY Certificate of Deposit 22398 2.640% 168,305.30 05/06/20 12/21/18 Newbank, NA, NY Certificate of Deposit 58203 2.640% 241,200.00 21,591,732.85 VEHICLE REPLACEMENT FUND (061) 06/12/20 12/28/17 Federal Home Loan Bank Agency Notes 313383MB4 1.875% 1,245,176.25 12/11/20 12/28/17 Federal Home Loan Bank Agency Notes 313OA3UQ5 1.875% 1,246,766.25 2,491,942.50 RISK MANAGEMENT FUND (063) 03/06/19 03/06/17 Mount Prospect State Bank Certificate of Deposit 354058 0.250% 20,100.20 20,100.20 TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS S 25,339,148.52 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of May 31, 2019 TRUST AND AGENCY FUNDS * Maturity Purchase Financial Date Date Institution POLICE PENSION FUND (070) Various Various Wells Fargo Various Various Various FIRE PENSION FUND (071) Various 5/26/2015 Principal Life Insurance Company Various Various Wells Fargo Various Various Various TOTAL TRUST AND AGENCY FUND INVESTMENTS Investment CUS1P/ Interest Market Description Acct# Rate % Value Wells Fargo Investments Various Various $ 21,966,903.15 Mutual Fund Investments Various Various 47,011,936.33 68,978,839.48 Group Annuity Contract 8-10810 Variable 6,221,107.82 Wells Fargo Investments Various Various 23,927,276.54 Mutual Fund Investments Various Various 34,377,889.34 64,526,273.70 $ 133,505,113.18 * Assets are restricted in purpose and do not represent discretionary assets of the government.