The URL can be used to link to this page

Home My WebLink About5.1 Monthly Financial Report5/29/2019 BoardDocs® Pro Agenda Item Details Meeting May 21, 2019 - REGULAR MEETING OF THE MOUNT PROSPECT VILLAGE BOARD - 7:00 p.m. Category 5. CONSENT AGENDA Subject 5.1 5.1 Monthly Financial Report - April 2019 Access Public Type Action (Consent) Fiscal Impact No Budgeted No Recommended Action Accept the monthly financial report for April 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 April 30,, 2019. Alternatives 1. Accept the monthly financial report for April 2019. 2. Action at discretion of Village Board. Staff Recommendation Staff recommends the Village Board accept the monthly financial report for April 30., 2019. 04 April Board Reports for Upload pdf (347 KB) Combined Financials for BD 04302019.pdf (144 KB) Administrative Content Executive 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. Motion & Voting https://go.boarddocs.com/il/vomp/Board.nsf/Private?open&login# 1/2 5/29/2019 BoardDocs® Pro I 1=1 MM= - 001"0 Motion by William Grossi, second by Richard Rogers. Final Resolution: Motion Carries Yea: William Grossi, Eleni Hatzis, Richard Rogers, Colleen SaccotelliMichael Zadel https://go.boarddocs.com/il/vomp/Board.nsf/Private?open&login# 2/2 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES April l - April 30, 2019 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS $561118f900.00 FLEldWl. ne�raVl iiiiid I ol,lals $56,118,900.00 $0.00 $56,118,900.00 $11f419f842.42 $0.00 $23,494,675.54 $32,624,224.46 42% $17,563,769.78 $0.00 $56,118,900.00 $11f4191842.42 1 $0.00 $23,494,675.54 $32,624,224.46 $17,563,769.78 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Its irid Wl, Gedne�raVIII 111111"""' iiiis REVENUE III am,;" 16 498 000.00 .00 16f 498f 000.00 211f373.62 .00 8f961f258.44 7f536f741.56 54 8f858f908.51 I axes 8f033f000.00 .00 8f033f000.00 L051f791.97 .00 1f680f691.54 6f352f308.46 21 L853f413.48 I iceinses s, & Fee- L362f000.00 .00 1,362f000.00 285f029.46 .00 773,265.21 588f 734.79 57 495,950.05 11]"fl,,eiii-goveiiiii�'n&ifl., 111 IIRevein�� je 27f872f000.00 .00 27f872f000.00 9,644,689.13 .00 11,381f591.52 16,490,408.48 41 5f560f275.03 I allf.g(as F'6iSeiiivices 1,209,000.00 .00 1,209,000.00 124,376.04 .00 278,830.89 9301169.11 23 247f 248.79 Fiiiries & IlFoii� �chits 432f000.00 .00 432f000.00 18f 670.42 .00 71,619.41 360,380.59 17 116,793.08 11]iivesl,rneirit [nc(lrne 266f 100.00 .00 266f 100. 00 44,221.00 .00 158f 188.13 107,911.87 59 70,860.22 190,500.00 .00 190f 500. 00 20,251.78 .00 53,237.41 137,262.59 28 77f 860.90 (Dfl'iei�- Iliacvei�-iLje 256f300.00 .00 256f300.00 19,439.00 .00 135,992.99 120,307.01 53 282,459.72 Od'i(,!i�' Il iiiiirr iirrciiiiirr S0Lfl,ce!,! .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $561118f900.00 FLEldWl. ne�raVl iiiiid I ol,lals $56,118,900.00 $0.00 $56,118,900.00 $11f419f842.42 $0.00 $23,494,675.54 $32,624,224.46 42% $17,563,769.78 $0.00 $56,118,900.00 $11f4191842.42 1 $0.00 $23,494,675.54 $32,624,224.46 $17,563,769.78 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS 5.vid 007 IIIIII )6Ift Seirvice Ill..., otzlls $5,827,228.00 $0.00 $5,827,228.00 $484,446.70 $0.00 $1f834f372.14 $3,992,855.86 31% $1f355f776.78 $5,827,228.00 $0.00 $5,827,228.00 $484,446.70 $0.00 $1f834f372.14 $3,992,855.86 $1f355f776.78 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fuirid 002,111111 t llll tSeirvice111111 iiiis REVENUE IIG: iii 111 iii.i: III am,;" 21434,000.00 .00 2f 434f 000.00 311433.35 .00 1f358f970.53 1f075f029.47 56 if 153f 227.03 I axes 1f024f578.00 .00 1f024f578.00 442,617.69 .00 442f 617.69 581,960.31 43 200,478.57 IIReveiiiUJe 1f573f650.00 .00 1f573f650.00 2f079.16 .00 3,442.10 1f570f207.90 0 527.17 11]'wesl.]'iie�ri 11: ic(')iiri i e 5f000.00 .00 5,000.00 81316.50 .00 29f 341.82 (24,341.82) 587 1f544.01 01111h.ieii� IIReveii mii.je .00 .00 .00 .00 .00 .00 .00 +++ .00 Otlhie�iiFiiria� riciirq Soi�i j�rces 790f000.00 .00 790f 000. 00 .00 .00 .00 790f000.00 0 .00 REVENUE TOTALS 5.vid 007 IIIIII )6Ift Seirvice Ill..., otzlls $5,827,228.00 $0.00 $5,827,228.00 $484,446.70 $0.00 $1f834f372.14 $3,992,855.86 31% $1f355f776.78 $5,827,228.00 $0.00 $5,827,228.00 $484,446.70 $0.00 $1f834f372.14 $3,992,855.86 $1f355f776.78 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS FLfl'mea 02III 'hili I dl.zllls $2,142,000.00 $0.00 $2,142,000.00 $595,214.10 $0.00 $605,251.60 $1f536f748.40 28% $263,343.32 $2,142,000.00 $0.00 $2,142,000.00 $595,214.10 $0.00 $605,251.60 $1f536,748.40 $263,343.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 Fuirid 020 CaIpkaVl REVENUE ofull iiiI a° 53'', 11370,000.00 .00 1,370f000.00 591,840.00 .00 591,840.00 778f 160. 00 43 257f400.00 i:iir mi: iii s s iii lir miii° lir mi: 111 IIRevei�-I�Lle .00 .00 .00 .00 .00 .00 .00 +++ .00 iiiiiw�'ne 20fOOO.00 .00 20f 000. 00 3f374.10 .00 13f411.60 6f 588.40 67 5,943.32 Reiiirii�bui seii�"neiiril'S .00 .00 .00 .00 .00 .00 .00 +++ .00 01111h.ieii� IIReveii mii.je 2,000.00 .00 2,000.00 .00 .00 .00 21000.00 0 .00 Otlh..ieii� Fiiria� riciirq Soi�i j�rces 750f000.00 .00 750f000.00 .00 .00 .00 750f000.00 0 .00 REVENUE TOTALS FLfl'mea 02III 'hili I dl.zllls $2,142,000.00 $0.00 $2,142,000.00 $595,214.10 $0.00 $605,251.60 $1f536f748.40 28% $263,343.32 $2,142,000.00 $0.00 $2,142,000.00 $595,214.10 $0.00 $605,251.60 $1f536,748.40 $263,343.32 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS lFuiiriid 023 ireet Cmiis'tiiirix wndl I ol,,als $3,771,000.00 $0.00 $3,771,000.00 $1f264,984.80 $0.00 $2,051,075.00 $1,719,925.00 54% $1,950,507.82 $3,771,000.00 $0.00 $3,771,000.00 $1f264f984.80 $0.00 $2,051,075.00 $1,719,925.00 $1,950,507.82 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fuirid 023 iree't Coinstiruc REVENUE ofull iiiI a° 53'', 21085,000.00 .00 2f085f000.00 6441763.05 .00 746f 724.08 1f338f275.92 36 431,487.38 I iceinses,, [)&,-iii'nhits & F(,�es 1,650f000.00 .00 1f650f000.00 615,361.00 .00 1,288f915.50 361,084.50 78 1f353f589.00 IIReveiiiiLle .00 .00 .00 .00 .00 .00 .00 +++ .00 Fiiir-ies & IlFoiii. fbil,,s .00 .00 .00 .00 .00 .00 .00 +++ .00 ivesl.]"neiiri I., icoii�'Tie 6,000.00 .00 61000.00 1f602.95 .00 5,880.27 119.73 98 1f048.89 Reiiir'6"',X vi seiMeirits .00 .00 .00 .00 .00 6,297.35 (6f297.35) +++ .00 01,11iieir Il.c cinje 30f000.00 .00 30f000.00 3,257.80 .00 3,257.80 26f 742.20 11 164,382.55 Ofliieiii- 111iiinaiii ciiiiig Sojiii-(',',es .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS lFuiiriid 023 ireet Cmiis'tiiirix wndl I ol,,als $3,771,000.00 $0.00 $3,771,000.00 $1f264,984.80 $0.00 $2,051,075.00 $1,719,925.00 54% $1,950,507.82 $3,771,000.00 $0.00 $3,771,000.00 $1f264f984.80 $0.00 $2,051,075.00 $1,719,925.00 $1,950,507.82 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS FLfl'id 024 1111""""11lood Co,uiatur6l I UV.aIII s $2,417,422.00 $0.00 $2,417,422.00 $169,459.11 $0.00 $187f034.50 $2f230f387.50 8% $63,634.84 $2,417,422.00 $0.00 $2f417f422.00 $169,459.11 $0.00 $187,034.50 $2,230,387.50 $63,634.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 Fuurid 024 1111""""Vlood Cou n'tir6l Couur uuruic'timn Uind REVENUE ofull uiI a° 53'', 345,422.00 .00 345,422.00 149,222.31 .00 149,222.31 196f 199.69 43 571024.00 Reveu�-ILle 21000,000.00 .00 2,000,000.00 .00 .00 .00 21000,000.00 0 .00 Oha�i-ges IlFoui-' Seuiwices 40,000.00 .00 40,000.00 18,225.00 .00 19,885.00 20,115.00 50 11805.00 11]'wesl.]'iieu i1:: ic(')uri i e 12,000.00 .00 12,000.00 21011.80 .00 81019.91 31980.09 67 41805.84 Reiurnbuu seuriwieurO.'s 201000.00 .00 201000.00 .00 .00 91907.28 101092.72 50 .00 OtlhieuiFiuria� riciurq Soiu jjrces .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS FLfl'id 024 1111""""11lood Co,uiatur6l I UV.aIII s $2,417,422.00 $0.00 $2,417,422.00 $169,459.11 $0.00 $187f034.50 $2f230f387.50 8% $63,634.84 $2,417,422.00 $0.00 $2f417f422.00 $169,459.11 $0.00 $187,034.50 $2,230,387.50 $63,634.84 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS R 025 1111116& �ns'�tiiii I otaldls $88,000.00 $0.00 $88,000.00 $42,949.02 $0.00 $264,209.88 ($1761209.88) 300% $0.00 $88,000.00 $0.00 $88,000.00 0 $42,949.02 $0.00 $264,209.88 ($176f209.88) $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 Fuirid 025 ��)61ice & �Btifll&�ng Cmnstiiii REVENUE 88,000.00 .00 88f 000. 00 42,949.02 .00 2641209.88 (176f209.88) 300 .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 01.1'ieiii-' IIR,eveiii ,ii�i�je .00 .00 .00 .00 .00 .00 .00 +++ .00 Fi��ig So�ii�tices .00 .00 .00 REVENUE TOTALS R 025 1111116& �ns'�tiiii I otaldls $88,000.00 $0.00 $88,000.00 $42,949.02 $0.00 $264,209.88 ($1761209.88) 300% $0.00 $88,000.00 $0.00 $88,000.00 0 $42,949.02 $0.00 $264,209.88 ($176f209.88) $0.00 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS $4,371,720.00 FLfl'id IIIIIIIefijise 1111')islpos4l 111...,x.. tzmlll s $4,371,720.00 $0.00 $4,371,720.00 $315,594.01 $0.00 $1,402,541.78 $2,969,178.22 32% $1f367f635.70 $0.00 $4,371,720.00 $315,594.01 $0.00 $1,402,541.78 $2,969,178.22 $1f367f635.70 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD s iiri 111111.�teftise 1111' Mslpo,saVl REVENUE [ail-qxvii"tyIll..am;" .00 .00 .00 .00 .00 .00 .00 +++ .00 Ohai�-ges IlFoii�,- S&rvic(,�s 41194,500.00 .00 4,194,500.00 283,417.05 .00 1f343f727.31 2f850f772.69 32 1,323,166.03 Fiiiries 3. IlFoi�-f615 37,000.00 .00 37,000.00 41495.92 .00 11.1156.56 25,843.44 30 13505.62 11]'wesl.]'iieiiri 11a:iiric(')airi i e 5f000.00 .00 51000.00 11128.60 .00 4.1482.68 517.32 90 21755.15 ReiiirnIbuiir seii�,iwieiir..O.'s 1f000.00 .00 1f000.00 .00 .00 .00 11000.00 0 .00 OtlhieiiiReveiri� i e 134,220.00 .00 134,220.00 26f 552.44 .00 43f 175.23 91,044.77 32 28f 208.90 REVENUE TOTALS $4,371,720.00 FLfl'id IIIIIIIefijise 1111')islpos4l 111...,x.. tzmlll s $4,371,720.00 $0.00 $4,371,720.00 $315,594.01 $0.00 $1,402,541.78 $2,969,178.22 32% $1f367f635.70 $0.00 $4,371,720.00 $315,594.01 $0.00 $1,402,541.78 $2,969,178.22 $1f367f635.70 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS Fiwwll 041, VIII4o'tmr ax ttrid I otals $1,435,000.00 $0.00 $1,435,000.00 $104,536.55 $0.00 $337f045.23 $1,097,954.77 23% $343,652.45 $1,435,000.00 $0.00 $1,435,000.00 $104,536.55 $0.00 $337f045.23 $1,097,954.77 $343,652.45 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fuirid 041, IIIIYfttmr 16l ax viii iii REVENUE Reveiiiije 11400,000.00 .00 1,400f000.00 1021214.45 .00 326,618.03 1,073f381.97 23 333,944.13 1]wesb'n&'iit [�'i(",o�r'ne 20f000.00 .00 20f 000. 00 2,322.10 .00 10,427.20 9,572.80 52 8,753.99 15f000.00 .00 15f000.00 .00 .00 .00 15f000.00 0 954.33 01,1'-iei�' IIReveiiije .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS Fiwwll 041, VIII4o'tmr ax ttrid I otals $1,435,000.00 $0.00 $1,435,000.00 $104,536.55 $0.00 $337f045.23 $1,097,954.77 23% $343,652.45 $1,435,000.00 $0.00 $1,435,000.00 $104,536.55 $0.00 $337f045.23 $1,097,954.77 $343,652.45 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS Fitnd 042 1 ol,' als $365,649.00 $0.00 $365,649.00 $0.00 $0.00 $66,203.64 $299,445.36 18% $25,000.00 $365,649.00 $0.00 $365,649.00 9 $0.00 $0.00 $66,203.64 $299,445.36 $25,000.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 Fuirid 042, REVENUE Reve��i� je 275,649.00 .00 275,649.00 .00 .00 .00 275,649.00 0 .00 1]wesb'n&'iit [�'i(",o�r'ne .00 .00 .00 .00 .00 .00 .00 +++ .00 01.1'ieiii-' IIR,eveiii ,ii�i�je 90,000.00 .00 90,000.00 .00 .00 66,203.64 23,796.36 74 25,000.00 REVENUE TOTALS Fitnd 042 1 ol,' als $365,649.00 $0.00 $365,649.00 $0.00 $0.00 $66,203.64 $299,445.36 18% $25,000.00 $365,649.00 $0.00 $365,649.00 9 $0.00 $0.00 $66,203.64 $299,445.36 $25,000.00 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS Fwid 043 Asseeiztcre 111111 viii iiiii Ill..., ol,,'a'", 11,111z'; $12,000.00 $0.00 $12,000.00 $11,773.86 $0.00 $12,252.38 ($252.38) 102% $6,711.72 $12,000.00 $0.00 $12,000.00 10 $11,773.86 $0.00 $12,252.38 ($252.38) $6,711.72 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fuirid 043 Asse't Seizitre111111 viiiind REVENUE Fiiii s 89, FDI'('�l"�ts 10,000.00 .00 10,000.00 11,612.46 .00 11,612.46 (1f612.46) 116 61239.12 1]wesb'n&'iit [�'i(",o�r'ne 21000.00 .00 21000.00 161.40 .00 639.92 11360.08 32 472.60 REVENUE TOTALS Fwid 043 Asseeiztcre 111111 viii iiiii Ill..., ol,,'a'", 11,111z'; $12,000.00 $0.00 $12,000.00 $11,773.86 $0.00 $12,252.38 ($252.38) 102% $6,711.72 $12,000.00 $0.00 $12,000.00 10 $11,773.86 $0.00 $12,252.38 ($252.38) $6,711.72 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS u iir.i 111111 edelr9haiiire Ill..., ot'', B, I $2,200.00 $0.00 $2,200.00 $10.86 $0.00 $41.69 $2,158.31 2% $51.92 $2,200.00 $0.00 $2,200.00 $10.86 $0.00 $41.69 $2,158.31 $51.92 11 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD iiri 111111 dear VIII 51iaire REVENUE Fiiii s 89, FDI'('�l"�ts 21000.00 .00 2,000.00 .00 .00 .00 2,000.00 0 .00 1]wesb'n&'iit [�'i(",o�r'ne 200.00 .00 200.00 10.86 .00 41.69 158.31 21 51.92 REVENUE TOTALS u iir.i 111111 edelr9haiiire Ill..., ot'', B, I $2,200.00 $0.00 $2,200.00 $10.86 $0.00 $41.69 $2,158.31 2% $51.92 $2,200.00 $0.00 $2,200.00 $10.86 $0.00 $41.69 $2,158.31 $51.92 11 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS Fa� tnd 045 I ol lcz $25,500.00 $0.00 $25,500.00 $1,409.99 $0.00 $1,495.06 $24,004.94 6% $1,694.16 $25,500.00 $0.00 $25,500.00 12 $1,409.99 $0.00 $1,495.06 $24,004.94 $1,694.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 Fuirid 045111111 tiU 'IIII 111111' iiia 111111' iiia REVENUE Fiiii s 89, FDI'('�l"�ts 25,000.00 .00 25f000.00 11379.99 .00 11379.99 23,620.01 6 11553.46 1]wesb'n&'iit [�'i(",o�r'ne 500.00 .00 500.00 30.00 .00 115.07 384.93 23 140.70 REVENUE TOTALS Fa� tnd 045 I ol lcz $25,500.00 $0.00 $25,500.00 $1,409.99 $0.00 $1,495.06 $24,004.94 6% $1,694.16 $25,500.00 $0.00 $25,500.00 12 $1,409.99 $0.00 $1,495.06 $24,004.94 $1,694.16 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS I ot,als R 046 ax $94,000.00 $0.00 $94,000.00 $409.80 $0.00 $1,625.16 $92,374.84 2% $1,085.25 $94,000.00 $0.00 $94,000.00 $409.80 $0.00 $1f625.16 $92,374.84 $1,085.25 13 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fuirid 046 IIIIII liltd111111"""' iiiii REVENUE 90,000.00 .00 90f 000. 00 .00 .00 .00 90,000.00 0 .00 1]wesb'n&'iit [�'i(",o�r'ne 41000.00 .00 41000.00 409.80 .00 11625.16 21374.84 41 11085.25 01.1'ieiii-' IIR,eveiii ,ii�i�je .00 .00 .00 .00 .00 .00 .00 +++ .00 01,1'-ieiii- Fiiii iaiiiiciiii ig So�� t� ces .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS I ot,als R 046 ax $94,000.00 $0.00 $94,000.00 $409.80 $0.00 $1,625.16 $92,374.84 2% $1,085.25 $94,000.00 $0.00 $94,000.00 $409.80 $0.00 $1f625.16 $92,374.84 $1,085.25 13 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS Fiwwll 048 I111')is'tirkt III..., ot,als $1,525,000.00 $0.00 $1,525,000.00 $267,342.67 $0.00 $367,711.57 $1,157,288.43 24% $256,751.10 $1,525,000.00 $0.00 $1,525,000.00 14 $267,342.67 $0.00 $367,711.57 $1,157,288.43 $256,751.10 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fuirid 048 "kness REVENUE ofull iiiI a° 53'', 11070,000.00 .00 1,070f000.00 76f 160.22 .00 173,988.15 896,011.85 16 177f098.39 Revei�-ILle 440f000.00 .00 440f 000. 00 190,080.00 .00 190,080.00 249,920.00 43 75f600.00 11]wesl.]'neiiiA, [�iiwi'ne 15f000.00 .00 15f000.00 11102.45 .00 3,643.42 11,356.58 24 4f052.71 Fi��ig So�iitces .00 .00 .00 REVENUE TOTALS Fiwwll 048 I111')is'tirkt III..., ot,als $1,525,000.00 $0.00 $1,525,000.00 $267,342.67 $0.00 $367,711.57 $1,157,288.43 24% $256,751.10 $1,525,000.00 $0.00 $1,525,000.00 14 $267,342.67 $0.00 $367,711.57 $1,157,288.43 $256,751.10 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS $1014841000.00 R i�rid� 049 ��)�ro,s�pec't a�rid 14ai�n I otals $10,484,000-00 $0.00 $10,484,000.00 $5,988.52 $0.00 $251,357.92 $10,232,642.08 2% $165,477.39 $0.00 $10,484,000.00 15 $5,988.52 $0.00 $251,357.92 $10,232,642.08 $165,477.39 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fuirid 049 1111°)iros�pec't a�rid Maiiiin 1111 Ms'trict REVENUE III..., . . .... a" xE � � 474,000.00 .00 474f 000. 00 41340.92 .00 2441759.92 229,240.08 52 .00 1]wesb'n&'iit [�'i(",o�r'ne 10,000.00 .00 10,000.00 1f647.60 .00 61598.00 31402.00 66 221691.79 01.1'ieiii-' IIR,eveiii ,ii�i�je .00 .00 .00 .00 .00 .00 .00 +++ .00 Fi ac� g So�i�tices 10,000,000.00 .00 10,000,000.00 .00 .00 .00 10,000,000.00 0 1421785.60 REVENUE TOTALS $1014841000.00 R i�rid� 049 ��)�ro,s�pec't a�rid 14ai�n I otals $10,484,000-00 $0.00 $10,484,000.00 $5,988.52 $0.00 $251,357.92 $10,232,642.08 2% $165,477.39 $0.00 $10,484,000.00 15 $5,988.52 $0.00 $251,357.92 $10,232,642.08 $165,477.39 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS $25,940,700.00 ilii, 1 ol,,als $25,940,700.00 $0.00 $25f940f700.00 $1,183,910.68 $0.00 $4f805f378.22 $21f135f321.78 19% $4,554,269.11 $0.00 $25f940f700.00 $1f183f910.68 16 $0.00 $4,805,378.22 $21,135,321.78 $4,554,269.11 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fuirid 0,50 Wate�r airid Sewelr REVENUE [ail-qxvii"tyIll..am;" .00 .00 .00 (361.07) .00 (11655.15) 1f655.15 +++ (2,524.58) 1 iceinses,, [)&,-iii'nits & es 20f000.00 .00 20f 000. 00 1,600.00 .00 7f020.00 12,980.00 35 7,690.00 Ohai�-ges VFoiii-' Seiii vices 15f509f600.00 .00 15f509f600.00 1,151,627.06 .00 4,682,512.88 10,827,087.12 30 4,366,749.90 Fiiir-ies & IlFoiii. fbil,,s 100,000.00 .00 100,000.00 8,510.17 .00 25,,231.07 74,768.93 25 341144.56 ivesl.]"neiiri I., icoii�'Tie 51f 100.00 .00 511100.00 16,934.52 .00 62f 149. 11 (11f049.11) 122 31,229.83 Reiiir'6"',X vi seiMeirits .00 .00 .00 .00 .00 8,100.31 (8fI00.31) +++ .00 01,11iieir IlReveine je 60f000.00 .00 60f 000. 00 5f600.00 .00 22f020.00 37,980.00 37 18f 165.00 Ofliieiii- 111iiiiisaiinciiiiiig Sojiii-(',',es 10,200,000.00 .00 10f200f000.00 .00 .00 .00 10f200f000.00 0 98f 814.40 REVENUE TOTALS $25,940,700.00 ilii, 1 ol,,als $25,940,700.00 $0.00 $25f940f700.00 $1,183,910.68 $0.00 $4f805f378.22 $21f135f321.78 19% $4,554,269.11 $0.00 $25f940f700.00 $1f183f910.68 16 $0.00 $4,805,378.22 $21,135,321.78 $4,554,269.11 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS R i�nd 05�1 WlHlage Sys'teim II(' Aals $192,600.00 $0.00 $192f600.00 $15,649.95 $0.00 $69f020.95 $123,579.05 36% $68,934.20 $192,600.00 $0.00 $192f600.00 17 $15,649.95 $0.00 $69,020.95 $123,579.05 $68,934.20 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fuirid 0,51, WlHlage Sys'teim 111111"""' iiiiissi� REVENUE ofull iiiI a° 53'', .00 .00 .00 .00 .00 .00 .00 +++ .00 Ohai-ges IlFoii�,- S&rvic(,s 186,600.00 .00 186,600.00 14,934.00 .00 66,249.30 120,350.70 36 66,997.45 11]wesl.]'ne�iA, [�iiw�ine 31000.00 .00 31000.00 395.70 .00 11570.80 11429.20 52 11025.35 01.1'-iei�' IlRe&i��.je 31000.00 .00 31000.00 320.25 .00 11200.85 11799.15 40 911.40 01111h.ie�� Filir iaiir.i( iii lir ig Soii trces .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS R i�nd 05�1 WlHlage Sys'teim II(' Aals $192,600.00 $0.00 $192f600.00 $15,649.95 $0.00 $69f020.95 $123,579.05 36% $68,934.20 $192,600.00 $0.00 $192f600.00 17 $15,649.95 $0.00 $69,020.95 $123,579.05 $68,934.20 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS FLfl'id 0,5 2, Sys'te�iin ��Ieveiiirvue 1111""":wnd I otzlls $158,200.00 $0.00 $158f200.00 $13,673.00 $0.00 $52,965.23 $105,234.77 33% $52,505.19 $158,200.00 $0.00 $158f200.00 IV $13,673.00 $0.00 $52,965.23 $105,234.77 $52,505.19 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Itsirid 0,52, ��)a��Hktng Systzm IIIIeveinue REVENUE oflliiiI am53'', .00 .00 .00 .00 .00 .00 .00 +++ .00 Revei�-I�Lle .00 .00 .00 .00 .00 .00 .00 +++ .00 Ohai�-ges VFoiii-' Sei ices 156,000.00 .00 156,000.00 13,379.10 .00 511787.40 1041212.60 33 51,615.60 11]'wesl.]'iieiiri 11: ic(')ii i e 11000.00 .00 11000.00 187.50 .00 747.33 252.67 75 440.19 01111h.ieii� IlReveii mii.je 11200.00 .00 11200.00 106.40 .00 430.50 769.50 36 449.40 OtlhieiiiFiiriairiciirq Soi�i jirces .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS FLfl'id 0,5 2, Sys'te�iin ��Ieveiiirvue 1111""":wnd I otzlls $158,200.00 $0.00 $158f200.00 $13,673.00 $0.00 $52,965.23 $105,234.77 33% $52,505.19 $158,200.00 $0.00 $158f200.00 IV $13,673.00 $0.00 $52,965.23 $105,234.77 $52,505.19 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS R.vric']IhWlelftiin'teina�lir lce 111111 iiiiss Ill..., otals $2,052,358.00 $0.00 $2f052f358.00 $170,839.11 $0.00 $683,848.78 $1,368,509.22 33% $682f092.75 $2f052f358.00 $0.00 $2,052,358.00 19 $170,839.11 $0.00 $683,848.78 $1,368,509.22 $682,092.75 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fuirid 060 V6hisoli ind REVENUE Giia�r-g(,s F'6r' :S(,N'-'iiia es 21046,358.00 .00 2f046f358.00 170f 529.81 .00 682f 119.24 1f364f238.76 33 680f 275.60 1]wesb'n&'iit [�'i(",o�r'ne 6f000.00 .00 6,000.00 309.30 .00 1f729.54 4,270.46 29 1,817.15 01.1'iei�-' IIR,evelir ii�irje .00 .00 .00 .00 .00 .00 .00 +++ .00 01,1'-ie��' Fi�� ia�� ici�� ig So�� t� ces .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS R.vric']IhWlelftiin'teina�lir lce 111111 iiiiss Ill..., otals $2,052,358.00 $0.00 $2f052f358.00 $170,839.11 $0.00 $683,848.78 $1,368,509.22 33% $682f092.75 $2f052f358.00 $0.00 $2,052,358.00 19 $170,839.11 $0.00 $683,848.78 $1,368,509.22 $682,092.75 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS FLfl'id 061. V61iiI otzils $2,337,100.00 $0.00 $2,337,100.00 $192,611.31 $0.00 $797,899.10 $1,539,200.90 34% $590,347.81 $2,337,100.00 $0.00 $2,337,100.00 20 $192,611.31 $0.00 $797,899.10 $1f539,200.90 $590,347.81 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fuirid 061, V6hiclle REVENUE Ill iii F'6i' :S(,N'-v"iii es 211321100.00 .00 2,132,100.00 177,675.01 .00 710,700.04 1,421f399.96 33 537f099.96 Fiiiries & Ilori- hits 10,000.00 .00 10,000.00 .00 .00 .00 10,000.00 0 820.00 11]wesl.]'ne�iA, [�iiw�'ne 120,000.00 .00 120,000.00 16,336.92 .00 68,,524.06 51,475.94 57 2,930.85 Reiiirii�buiii seii�"neiril'S .00 .00 .00 .00 .00 .00 .00 +++ .00 01111h.ieii� IIReveii mii.je .00 .00 .00 .00 .00 .00 .00 +++ .00 OtlhieiiiFiiria� riciirq Soi�i j�rces 75f000.00 .00 75f000.00 (1f400.62) .00 18,675.00 56,325.00 25 49,497.00 REVENUE TOTALS FLfl'id 061. V61iiI otzils $2,337,100.00 $0.00 $2,337,100.00 $192,611.31 $0.00 $797,899.10 $1,539,200.90 34% $590,347.81 $2,337,100.00 $0.00 $2,337,100.00 20 $192,611.31 $0.00 $797,899.10 $1f539,200.90 $590,347.81 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS Fu�nd 062, Colinin Illj ir I of a'�Ica:'� $166,897.00 $0.00 $166,897.00 $14,503.25 $0.00 $57,984.64 $108,912.36 35% $69,904.32 $166,897.00 $0.00 $166,897.00 21 $14,503.25 $0.00 $57,984.64 $108,912.36 $69,904.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 Fuirid 062, CoimIptrteir REVENUE ag(,sF'6�' :S)(,N'-v"'ces 162,897.00 .00 162,897.00 13,574.75 .00 541299.00 108,598.00 33 68,365.64 1]wesb'n&'iit [�'i(",o�r'ne 41000.00 .00 41000.00 928.50 .00 31685.64 314.36 92 11538.68 011'ieiii" F�"iiiaiix So�� ce!; .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS Fu�nd 062, Colinin Illj ir I of a'�Ica:'� $166,897.00 $0.00 $166,897.00 $14,503.25 $0.00 $57,984.64 $108,912.36 35% $69,904.32 $166,897.00 $0.00 $166,897.00 21 $14,503.25 $0.00 $57,984.64 $108,912.36 $69,904.32 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS $9,255,217.00 Fiwwl� 063 ��INI( I otals $9f255f217.00 $0.00 $9,255,217.00 $740,491.29 $0.00 $2,975,260.52 $6,279,956.48 32% $2,928,892.98 $0.00 $9,255,217.00 $740,491.29 22 $0.00 $2,975,260.52 $6,279,956.48 $2,928,892.98 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fuirid 063 Mainageimeilii 111111""""m mii iiia REVENUE Giia�ii- g(,s F'6i' :S(,N'-v"'ces 71429,717.00 .00 7,429,717.00 601,690.30 .00 21407,628.08 5f022f088.92 32 21347,136.94 1]wesb'n&'iit [�'i(",o�r'ne 20,000.00 .00 20,000.00 1f098.39 .00 51328.93 14,671.07 27 81028.78 21000.00 .00 21000.00 .00 .00 31719.03 (11719.03) 186 81145.68 01,1'-ieiii"IIRev&ije 11803,500.00 .00 1f8031500.00 1371702.60 .00 558,584.48 11244,915.52 31 565,581.58 REVENUE TOTALS $9,255,217.00 Fiwwl� 063 ��INI( I otals $9f255f217.00 $0.00 $9,255,217.00 $740,491.29 $0.00 $2,975,260.52 $6,279,956.48 32% $2,928,892.98 $0.00 $9,255,217.00 $740,491.29 22 $0.00 $2,975,260.52 $6,279,956.48 $2,928,892.98 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiaviyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS $8,419,500.00 FLEld 070 IIIIeiiisiii k,iiiiid I ol."als $8,419,500.00 $0.00 $8,419,500.00 $1f847,721.57 $0.00 $10,296,295.77 ($1f876,795.77) 122% $1f936f550.94 $0.00 $8,419,500.00 $1f847,721.57 23 $0.00 $10,296,295.77 ($1,876,795.77) $1,936,550.94 Adopted Budget Amended Current Month YTD YTD Budget - YTD ®/ Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fuirid 070 1111)61ice REVENUE Giiaiii-g(,s F'6i' :13E,N"v"'ces .00 .00 .00 .00 .00 .00 .00 +++ .00 1]wesb'n&'iit [�'i(",o�r'ne 31933,500.00 .00 3f933f500.00 1,740,970.08 .00 8f218f460.00 (4f284f960.00) 209 (149f569.61) 01.1'ieiii-' IIR,eveiii ,ii�i�je 4f486f000.00 .00 4,486,000.00 106,751.49 .00 2f077f835.77 2f4O8f 164.23 46 2,086,120.55 REVENUE TOTALS $8,419,500.00 FLEld 070 IIIIeiiisiii k,iiiiid I ol."als $8,419,500.00 $0.00 $8,419,500.00 $1f847,721.57 $0.00 $10,296,295.77 ($1f876,795.77) 122% $1f936f550.94 $0.00 $8,419,500.00 $1f847,721.57 23 $0.00 $10,296,295.77 ($1,876,795.77) $1,936,550.94 Revenue Budget by Account Classification Report .......... . 04/30[11 9 IL IL "" IlllrAiavit"llyllr�Idided S u III"n a ll ry 1 ............. JsUIIIig REVENUE TOTALS Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD Fuirid 071, 1111°)einsioin111111"""' iiii $1,503,929.85 $0.00 $8f378f068.62 ($6961268.62) $2,132,736.28 REVENUE $144,883,991.00 $0.00 $144,883,991.00 $20,367,292.42 $0.00 $58,993,614.92 31586,000.00 .00 3f586f000.00 1f413f791.11 .00 6,520,556.43 (2f934f556.43) 182 431,809.29 i i:llhm iii. IlReveiir-iLje 4.095,800.00 .00 4,095,800.00 90,138.74 .00 1,857,512.19 2,238,287.81 45 1,700,926.99 REVENUE TOTALS $7,681,800.00 $0.00 $7,681,800.00 $1,503,929.85 $0.00 $8f378f068.62 ($696f268.62) 109% $2,132,736.28 FLEnd 071.111111 iiiir IIIII2eiiiiisi&111111' iiiiiiii ...Ill..., oi:: III11z'; $7,681,800.00 $0.00 $7,681,800.00 $1,503,929.85 $0.00 $8f378f068.62 ($6961268.62) $2,132,736.28 Gi airid I otals $144,883,991.00 $0.00 $144,883,991.00 $20,367,292.42 $0.00 $58,993,614.92 $85,890,376.08 $36f381f325.81 24 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS $57,408f719.00 $563f000.00 $57,971,719.00 $3f315f981.51 $1,527,456.37 $16,818,952.83 $39f625f309.80 32% $16,353,296.00 5.viid001 Gelne�rall w...Ill...,otals $57,408,719.00 $563,000.00 $57f971f719.00 $3f315f981.51 $1,527,456.37 $16,818,952.83 $39f625f309.80 $16,353,296.00 1 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year R iiridGedne�raVl 111111"""' iiiis EXPENSE ['(,N,-soi�iial :,iii ii SaI4�-ies & Wages 27 663 030.00 .00 27 663 030.00 11983f 191.08 .00 71578,163.50 20 084 866.50 27 71435,485.02 ")&iiel i1s 14 484 814.00 .00 14 484 814.00 638f773.85 .00 51932,498.04 81552,315.96 41 51981,410.03 01,1'i&-, (',osts 582,976.00 (21500.00) 580,476.00 49,616.78 25f 340.50 178,399.82 376,735.68 35 155,594.35 [)e�r'isicY�'i c,3', 51819.00 .00 51819.00 499.44 .00 11997.76 31821.24 34 11939.56 Coiiiflll]i�ad,lua111 S&,vices 8,776,475.00 77f 000. 00 81853,475.00 506,400.51 727f 284.73 2,509,531.05 51616,659.22 37 21244,050.21 utilit,i"'es 326,724.00 .00 326,724.00 171211.34 .00 611791.08 264,932.92 19 60,615.53 1 iira�rice 549,118.00 .00 549f 118.00 45,754.07 .00 183,007.88 366f 110. 12 33 139,031.62 Coirn�niodil,,Jies & SL,fl)lplies 832,905.00 10,000.00 842f905.00 55,512.96 65,654.55 1721718.95 604,531.50 28 2171163.05 Od'i&- [, Ill ciii mdliii::u iii ; s 11038,741.00 .00 1f038,741.00 .00 .00 102,936.74 935,804.26 10 .00 [,,3uildiiirig .00 12,000.00 12,000.00 .00 .00 71874.97 41125.03 66 388.30 office 40,430.00 10,000.00 50,430.00 999.90 .00 41919.88 45,510.12 10 41226.97 247,887.00 .00 247,887.00 41274.96 63,949.61 46f304.11 137,633.28 44 69,498.73 [,)isl.]r li1,,Njtioiri sl finis .00 .00 .00 .00 .00 .00 .00 +++ .00 11319,800.00 456f500.00 1f776f300.00 13,746.62 645,226.98 38,809.05 1f092f263.97 39 43,892.63 I i-ai�isfei�-s 11540,000.00 .00 11540,000.00 .00 .00 .00 1f540f000.00 0 .00 EXPENSE TOTALS $57,408f719.00 $563f000.00 $57,971,719.00 $3f315f981.51 $1,527,456.37 $16,818,952.83 $39f625f309.80 32% $16,353,296.00 5.viid001 Gelne�rall w...Ill...,otals $57,408,719.00 $563,000.00 $57f971f719.00 $3f315f981.51 $1,527,456.37 $16,818,952.83 $39f625f309.80 $16,353,296.00 1 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS Rfl'id 002, 111�)6lft Seir,Vice I otals $6,726,407.00 $0.00 $6f726f407.00 $0.00 $0.00 $428.00 $6,725,979.00 0% $2,835.50 $6,726,407.00 $0.00 $6f726f407.00 $0.00 $0.00 $428.00 $6,725,979.00 $2,835.50 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year R iirid 2 111111 t llll tSeirvice111111"""' iiiis EXPENSE Caiib,-adual 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 31812,499.00 .00 .00 .00 31812,499.00 0 .00 ll]"il,,eiii'esl,, 'Xpei�iise 21910,408.00 .00 21910,408.00 .00 .00 .00 21910,408.00 0 .00 ,3,aai°fl< Fic (,,-, l IIF'(: 31500.00 .00 31500.00 .00 .00 428.00 31072.00 12 21835.50 11 ....... ...... . ]� lt,e�� ft vricl I rarisfeirs .00 .00 .00 .00 .00 .00 .00 +++ .00 01,lliie�r IlFiiriariciing Uses .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS Rfl'id 002, 111�)6lft Seir,Vice I otals $6,726,407.00 $0.00 $6f726f407.00 $0.00 $0.00 $428.00 $6,725,979.00 0% $2,835.50 $6,726,407.00 $0.00 $6f726f407.00 $0.00 $0.00 $428.00 $6,725,979.00 $2,835.50 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS Fd 0 ... a� i2a�pai.. 1,,, $2,603,440.00 $2,603,440.00 $860,000.00 $3,463,440.00 $82f008.12 $514,991.86 $118,617.43 $2,829,830.71 18% $92f054.05 $2,603,440.00 $860,000.00 $3,463,440.00 $82f008.12 $514,991.86 $118,617.43 $2,829,830.71 $92f054.05 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year R iirid 02,0 CaIpk EXPENSE Caiib,-adual Siii v"'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 .00 .00 .00 495,000.00 0 .00 Ill..... aid 400,000.00 .00 400,000.00 .00 .00 .00 400,000.00 0 .00 [,,3uildiiir'ig [rii�piii :�'neiirits 266,000.00 198f500.00 464f500.00 23,295.86 80,555.04 25,325.64 358,619.32 23 13f 161.52 Office "qIii III` iii eiii °illl' .00 .00 .00 .00 .00 .00 .00 +++ .00 motaiq. liilll iii 82f000.00 .00 82f000.00 .00 .00 .00 82,000.00 0 .00 Otlliieir "q 572f 100.00 101,500.00 673f600.00 46,521.26 4341436.82 78,332.99 160,830.19 76 68f 777.03 708,750.00 545f000.00 11253,750.00 121191.00 .00 141428.90 1,239,321.10 1 10,115.50 .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS Fd 0 ... a� i2a�pai.. 1,,, $2,603,440.00 $2,603,440.00 $860,000.00 $3,463,440.00 $82f008.12 $514,991.86 $118,617.43 $2,829,830.71 18% $92f054.05 $2,603,440.00 $860,000.00 $3,463,440.00 $82f008.12 $514,991.86 $118,617.43 $2,829,830.71 $92f054.05 Expense Budget by Account Classification Report F .......... .gum 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS R i�rid 02�3 S,t�ree't Caiis,tirluc tall $3,772,000.00 $3,772,000.00 $905f000.00 $4f677f000.00 $21,409.99 $3,725,594.41 $27,106.24 $924,299.35 80% $38,296.31 $3,772,000.00 $905,000.00 $4f677f000.00 $21,409.99 $3,725,594.41 $27,106.24 $924,299.35 $38,296.31 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year R iirid 02,3 S,t�ree't Cans,tiruc EXPENSE Caiib,-adual Siii v"'ces 40,000.00 .00 40,000.00 .00 38,561.00 .00 11439.00 96 31000.00 .00 .00 .00 .00 .00 .00 .00 +++ .00 Ill..... a'id .00 .00 .00 .00 .00 .00 .00 +++ .00 3,732,000.00 905f000.00 4f637f000.00 21,409.99 3f687f033.41 27f 106.24 922,860.35 80 35,296.31 ll]' -Il f dli I °Jqsf(:%iii-qz a .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS R i�rid 02�3 S,t�ree't Caiis,tirluc tall $3,772,000.00 $3,772,000.00 $905f000.00 $4f677f000.00 $21,409.99 $3,725,594.41 $27,106.24 $924,299.35 80% $38,296.31 $3,772,000.00 $905,000.00 $4f677f000.00 $21,409.99 $3,725,594.41 $27,106.24 $924,299.35 $38,296.31 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS FL,fl,-id 02,4 111111"""' 11111 Caaturoll I otals $3,760,500.00 $461,000.00 $4,221,500.00 $8,282.91 $88,965.36 $134,270.67 $3,998,263.97 5% $81,225.51 $3,760,500.00 $461,000.00 $4,221,500.00 $8,282.91 $88,965.36 $134,270.67 $3,998,263.97 $81,225.51 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification udget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year R iurid 02,4 1111"""" Illood Caatir6VIII Cans,tuuruic,tian 1111"""'4nd EXPENSE Caiib,-adual Surv"'ces 120,000.00 .00 120,000.00 2,661.68 55,997.51 31621.30 60,381.19 50 91554.00 Utilities 31500.00 .00 31500.00 505.58 .00 625.19 21874.81 18 .00 Cararnodil,,ies & SqpIplies 51000.00 .00 51000.00 .00 .00 .00 51000.00 0 .00 01,1,-ieui-, "XIpeui'ii dV"11:�aie! 21000.00 .00 21000.00 .00 .00 .00 21000.00 0 11000.00 01111C°ieui"qU"l�Y�iie�r°illl' .00 .00 .00 .00 .00 .00 .00 +++ .00 IIC::iiis..urliillC°iwaiiuim Sysl eun-ls 80,000.00 .00 80f000.00 11878.75 3,650.00 7,146.25 69f203.75 13 .00 ll]llfrasbn ictl iure 31550,000.00 461f000.00 41011,000.00 3,236.90 29,317.85 122,877.93 3f858f804.22 4 70,671.51 EXPENSE TOTALS FL,fl,-id 02,4 111111"""' 11111 Caaturoll I otals $3,760,500.00 $461,000.00 $4,221,500.00 $8,282.91 $88,965.36 $134,270.67 $3,998,263.97 5% $81,225.51 $3,760,500.00 $461,000.00 $4,221,500.00 $8,282.91 $88,965.36 $134,270.67 $3,998,263.97 $81,225.51 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS FUlldl 2!'! 111111 I1ice & Cans'Itiiiiii I ol,lals $24,936,982.00 $0.00 $24,936,982.00 $277,367.02 $0.00 $448,846.09 $24,488,135.91 2% $0.00 $24,936,982.00 $0.00 $24,936,982.00 $277,367.02 0 $0.00 $448,846.09 $24,488,135.91 $0.00 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification Lyd.,get Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 025 1111)61i . IBijhili lilii ing Cans'tiiiiii EXPENSE Caiib,-adual Siii v"'ces 21316,174.00 .00 2,316,174.00 16f 199.02 .00 183,921.31 2f132f252.69 8 .00 22f620f808.00 .00 22f620f808.00 2611168.00 .00 264,924.78 22,355,883.22 1 .00 [,,3a'idIIG iii lii i cliff 111 111 .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS FUlldl 2!'! 111111 I1ice & Cans'Itiiiiii I ol,lals $24,936,982.00 $0.00 $24,936,982.00 $277,367.02 $0.00 $448,846.09 $24,488,135.91 2% $0.00 $24,936,982.00 $0.00 $24,936,982.00 $277,367.02 0 $0.00 $448,846.09 $24,488,135.91 $0.00 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u III"n III,a Illlry 1 ............. JsUIIIig EXPENSE TOTALS Rfl'id III11leftjse I111')isVIII os4VIII 111111' iiiis ...III...,otals $4,502,185.00 $55,000.00 $4,557,185.00 $383,522.05 $1,006.50 $1f281f570.83 $3f274f607.67 28% $1f264f256.30 $4,502,185.00 $55,000.00 $4,557,185.00 $383,522.05 $1,006.50 $1,281,570.83 $3,274,607.67 $1,264,256.30 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year R iirid IIIIIIt.eftise 1111' )islpo,saVl EXPENSE ['(,N,-soi�iial S(,iii vics, SaIll i-ies & Wages 254,632.00 .00 254,632.00 20,710.35 .00 85,534.59 169,097.41 34 75,109.32 ")&iiel i1s 112,676.00 .00 112,676.00 8,965.19 .00 41,559.37 711116.63 37 38,051.76 01,1'i&-, (',osts 11350.00 .00 11350.00 826.07 .00 If350.00 .00 100 98.67 Coi�-il,],-a d,,uel Se�� vices 4f084,523.00 55,000.00 41139,523.00 342,373.66 .00 1.1131f536.78 31007,986.22 27 1, 137,833.18 ul,lilil'J"es 483.00 .00 483.00 13.18 .00 58.17 424.83 12 44.23 1 isuvi alrice 61942.00 .00 61942.00 578.50 .00 21314.00 4,628.00 33 81891.00 C .'6ni�rnodities & 9 ilp1plies 41,579.00 .00 41,579.00 10,055.10 11006.50 19,217.92 21,354.58 49 41228.14 EXPENSE TOTALS Rfl'id III11leftjse I111')isVIII os4VIII 111111' iiiis ...III...,otals $4,502,185.00 $55,000.00 $4,557,185.00 $383,522.05 $1,006.50 $1f281f570.83 $3f274f607.67 28% $1f264f256.30 $4,502,185.00 $55,000.00 $4,557,185.00 $383,522.05 $1,006.50 $1,281,570.83 $3,274,607.67 $1,264,256.30 Expense Budget by Account Classification Report F .......... .gum 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS Fit iiirxl VIII4o,tar ax I otals $1,867,173.00 $218f000.00 $2,085,173.00 $38,482.25 $1,227,155.14 $267f 363.64 $590,654.22 72% $314,923.93 $1,867,173.00 $218,000.00 $2,085,173.00 $38,482.25 $1f227,155.14 $267,363.64 $590,654.22 �610] $314,923.93 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year R iirid 041. IIIIYfttar ax 111111' iuiiiir EXPENSE Caiib,-adual Sirv"'ces 360,173.00 .00 360,173.00 9,769.15 190,023.81 21,563.45 148,585.74 59 66,495.39 Utilities 200,000.00 .00 200,000.00 23,252.49 .00 28,534.37 171f465.63 14 35,530.56 Cararnodil,,ies & Sqplplies 357f000.00 .00 357f000.00 .00 11f256.17 211,670.21 134,073.62 62 210,076.48 [,,3uildiiir'ig [rii�pii ove'neii its .00 .00 .00 .00 .00 .00 .00 +++ .00 a ll,iie 950f000.00 218,000.00 11168,,000.00 5,460.61 11025,875.16 5,595.61 136,529.23 88 2,821.50 EXPENSE TOTALS Fit iiirxl VIII4o,tar ax I otals $1,867,173.00 $218f000.00 $2,085,173.00 $38,482.25 $1,227,155.14 $267f 363.64 $590,654.22 72% $314,923.93 $1,867,173.00 $218,000.00 $2,085,173.00 $38,482.25 $1f227,155.14 $267,363.64 $590,654.22 �610] $314,923.93 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS Fuind 042, 1 d:: i llI $365,649.00 $0.00 $365,649.00 $73.25 $0.00 $958.35 $364,690.65 0% $34,147.22 $365,649.00 $0.00 $365,649.00 9 $73.25 $0.00 $958.35 $364,690.65 $34,147.22 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification B Amendments Budq t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 042, G EXPENSE ['(,N,-soi�iial S(,iii vics, SaI4�-ies & Wages 37,492.00 .00 371492.00 .00.00 .00 37 1492.00 0 .00 ")&iiel i1s 6,157.00 .00 61157.00 .00 .00 .00 61157.00 0 .00 01.1,i&-, C',ost.'s 11126.00 .00 11126.00 15.20 .00 28.74 11097.26 3 .00 Coi�-il,],-ad,,uel Se�� vices 320,313.00 .00 320,313.00 58.05 .00 929.61 319,383.39 0 341147.22 561.00 .00 561.00 .00 .00 .00 561.00 0 .00 Otlieiiiiires .00 .00 .00 .00 .00 .00 .00 +++ .00 I aiiiiid [mlpl 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 Fuind 042, 1 d:: i llI $365,649.00 $0.00 $365,649.00 $73.25 $0.00 $958.35 $364,690.65 0% $34,147.22 $365,649.00 $0.00 $365,649.00 9 $73.25 $0.00 $958.35 $364,690.65 $34,147.22 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS Fiwi(',Jl 043 Aswt Se'ilii zsir e Ill..., otals $7,000.00 $0.00 $7,000.00 $1,285.00 $0.00 $12f094.32 ($5,094.32) 173% $20,882.71 $7,000.00 $0.00 $7f000.00 10 $1,285.00 $0.00 $12,094.32 ($5f094.32) $20,882.71 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification Budget -Amendments Budq t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD L izitre EXPENSE Oflii(,,"iii- Cosl,,,,s 11000.00 .00 11000.00 .00 .00 .00 11000.00 0 .00 Canl,],-actual Siii vices 31000.00 .00 31000.00 .00 .00 .00 31000.00 0 61986.88 Cararnodil,,ies & Sqp1plies .00 .00 .00 .00 .00 .00 .00 +++ 11,928.18 31000.00 .00 31000.00 1f285.00 .00 12,094.32 (91094.32) 403 11967.65 EXPENSE TOTALS Fiwi(',Jl 043 Aswt Se'ilii zsir e Ill..., otals $7,000.00 $0.00 $7,000.00 $1,285.00 $0.00 $12f094.32 ($5,094.32) 173% $20,882.71 $7,000.00 $0.00 $7f000.00 10 $1,285.00 $0.00 $12,094.32 ($5f094.32) $20,882.71 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS usir°id 044 ,iii iiia Ill..., otals $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 0% $539.85 $2,000.00 $0.00 $2,000.00 11 $0.00 $0.00 $0.00 $2,000.00 $539.85 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 deit VIII SIIiare EXPENSE Caiib-acbjal Siii v"'ces 11000.00 .00 11000.00 .00 .00 .00 11000.00 0 539.85 .00 .00 .00 .00 .00 .00 .00 +++ .00 A 01,1'ieiii-, [,l"qU"lpiiiineiii, 1 11000.00 .00 11000.00 .00 .00 .00 11000.00 0 .00 EXPENSE TOTALS usir°id 044 ,iii iiia Ill..., otals $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 0% $539.85 $2,000.00 $0.00 $2,000.00 11 $0.00 $0.00 $0.00 $2,000.00 $539.85 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS Fiw,i(Jl 04 111111 lii'IIII 111111' iiiis 111111' u„ iiiis w ...Ill..., otals $5,000.00 $0.00 $5,000.00 $4,997.95 $0.00 $6,177.95 ($1,177.95) 124% $3,330.30 $5,000.00 $0.00 $5f000.00 12 $4,997.95 $0.00 $6,177.95 ($1f177.95) $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 111111 tui 'IIII 111111' iiiis 111111' iiiis EXPENSE Oflii(,,"iii- Cosl,,,,s 11000.00 .00 11000.00 .00 .00 500.00 500.00 50 .00 Cani.]-actual S&rvices 11000.00 .00 11000.00 .00 .00 .00 11000.00 0 .00 A 31000.00 .00 31000.00 41997.95 .00 51677.95 (21677.95) 189 31330.30 I ��a"iisfe�� s .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS Fiw,i(Jl 04 111111 lii'IIII 111111' iiiis 111111' u„ iiiis w ...Ill..., otals $5,000.00 $0.00 $5,000.00 $4,997.95 $0.00 $6,177.95 ($1,177.95) 124% $3,330.30 $5,000.00 $0.00 $5f000.00 12 $4,997.95 $0.00 $6,177.95 ($1f177.95) $3,330.30 Expense Budget by Account Classification Report F .......... .gum 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS FL,fl'id 046 ax I (AC', I I -a $68,000.00 $0.00 $68f000.00 $843.90 $0.00 $6,380.76 $61,619.24 9% $11,952.28 $68,000.00 $0.00 $68f000.00 13 $843.90 $0.00 $6,380.76 $61,619.24 $11,952.28 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 Illlll liltd111111"""' iiiu EXPENSE Oflii(,,"iii- Cosl,,,,s 15,000.00 .00 15,000.00 743.90 .00 21693.01 12,306.99 18 .00 Cani.]-actual S&rvices 10,500.00 .00 10,500.00 100.00 .00 31687.75 61812.25 35 31308.68 iirisuiii'a'ice 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 & SqpIplies 13,000.00 .00 13,000.00 .00 .00 .00 13,000.00 0 .00 III:' uildiiirig [riil�Yi moveiir-nie ft, c.:; 51000.00 .00 51000.00 .00 .00 .00 51000.00 0 .00 Otl� i"q E"'lllYffieit 24,000.00 .00 24,000.00 .00 .00 .00 24,000.00 0 8,643.60 EXPENSE TOTALS FL,fl'id 046 ax I (AC', I I -a $68,000.00 $0.00 $68f000.00 $843.90 $0.00 $6,380.76 $61,619.24 9% $11,952.28 $68,000.00 $0.00 $68f000.00 13 $843.90 $0.00 $6,380.76 $61,619.24 $11,952.28 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry 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 iirid 11111111t,is kness EXPENSE 111; 3,Dlld IIG iii iiHlciii111a111 .00 .00 .00 .00 .00 .00 .00 +++ .00 ll]'itei�-est 'Xp&iise 11525,000.00 .00 1f525f000.00 50,923.14 .00 105f 599.42 1f419f400.58 7 108f 000. 18 EXPENSE TOTALS Faand 048 iijiiiid ...III...,otals $1,525,000.00 $0.00 $1,525,000.00 $50,923.14 $0.00 $105,599.42 $1,419,400.58 7% $108,000.18 $1,525,000.00 $0.00 $1,525,000.00 $50,923.14 14 $0.00 $105,599.42 $1,419,400.58 $108,000.18 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS t Fuirid 049 111�Yirois��pec�t and lftiin isrihitt Ilei als $10,229,238.00 $805f000.00 $11,034,238.00 $36,135.29 $81,568.92 $324,842.96 $10,627,826.12 4% $561,929.24 $10f229f238.00 $805f000.00 $11,034,238.00 $36,135.29 15 $81,568.92 $324,842.96 $10,627,826.12 $561f929.24 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 049 ��)�ros�pec't iiiis IIII iiiin111111°°° IIID 111111"""' 111111 �tiiiu°tiiriiiu EXPENSE Oflii(,,"iii- Cosl,,,,s 21700.00 .00 21700.00 .00 .00 600.00 21100.00 22 600.00 Cani.]-actual S&rvices 283,300.00 .00 283,300.00 30f 594.09 81,568.92 43,890.09 157,840.99 44 30f 546.24 Cararnodil,,ies & Sqp1plies 1f500.00 .00 1f500.00 .00 .00 .00 11500.00 0 .00 0i:;llh-me��- IIf "XIpe��'ii d'i"I,,,�a� e! 2f699f000.00 95f500.00 2f794f500.00 5,541.20 .00 276f902.87 21517,597.13 10 530,783.00 Ill..... arxll [: -q,Yeiir"neiii fl.'s .00 709f500.00 709f500.00 .00 .00 3,450.00 706,050.00 0 .00 11113u jildiirig 6f000f000.00 .00 6f000f000.00 .00 .00 .00 61000f000.00 0 .00 ll]llfrasbn ictl ie 810,000.00 .00 810,000.00 .00 .00 .00 810,000.00 0 .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 a: to -est 'Illise 432,738.00 .00 432,738.00 .00 .00 .00 432,738.00 0 .00 Ill; siirmlll t IlFi",sscal Il ccs .00 .00 .00 .00 .00 .00 .00 +++ .00 a: iii mi:�,eiii'u iiimr ....... ..... .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS t Fuirid 049 111�Yirois��pec�t and lftiin isrihitt Ilei als $10,229,238.00 $805f000.00 $11,034,238.00 $36,135.29 $81,568.92 $324,842.96 $10,627,826.12 4% $561,929.24 $10f229f238.00 $805f000.00 $11,034,238.00 $36,135.29 15 $81,568.92 $324,842.96 $10,627,826.12 $561f929.24 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year R iirid 0,50 Wa,teir aind Seweir EXPENSE ['(,N,-soi�iial S(,Nrvii , SaI4�-ies & Wages 21199,835.00 .00 2f 199,835.00 1541233.13 .00 652,027.37 11547,807.63 30 678,971.13 ")&iiel i1,,s 8711240.00 .00 8711240.00 68f 193.34 .00 2971734.74 573,505.26 34 297,516.70 (ost,,s 441464.00 .00 441464.00 111746.33 1f959.80 24,076.63 18,427.57 59 18,773.85 Coi�-il,],-ad,,uel Se�� vices 91174,756.00 50f000.00 91224,756.00 683,135.16 425f705.48 21116,958.21 61682,092.31 28 21081,815.10 ul,lilil,"J"es 1621710.00 .00 1621710.00 61913.23 .00 17f 999.67 1441710.33 11 31,849.70 1 isuvi aerice 1171789.00 .00 117,789.00 91815.75 .00 39,263.00 78,526.00 33 31,647.36 C .'6ni�rnodities & 9 ilp1plies 336,045.00 .00 336f045.00 32,361.34 86,316.10 641749.64 184,979.26 45 28,291.46 .00 .00 .00 .00 .00 .00 .00 +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 285,000.00 .00 285,000.00 .00 .00 11440.00 283,560.00 1 11450.00 office 1f081.00 .00 11081.00 .00 .00 .00 11081.00 0 .00 2121429.00 .00 2121429.00 16,323.00 .00 171234.76 195,194.24 8 23,836.91 [,)isl.]rli1,,Njtioiri Sysl,leinis 5,561,142.00 2,041,500.00 7,602,642.00 52,060.54 31043,667.05 468f 149.98 4,090,824.97 46 53,413.24 a:iiri asbn idl iire .00 .00 .00 .00 .00 .00 .00 +++ .00 [)iriincilpal 240,000.00 .00 240f000.00 .00 .00 .00 240f000.00 0 .00 I]llt(,N,-(,St 'Xpemse 343,081.00 .00 343,081.00 .00 .00 .00 343,081.00 0 .00 3a-� rilk Fi",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 $21,641,072.00 $1,034,781.82 $3,557,648.43 $3,699,634.00 $14,383,789.57 34% $3,247,565.45 Fiwi(Jl 0,50 Wa,teiiir airtd Seweiiumlll I otals $19,549,572.00 $21091f500.00 $21f641f072.00 $1,034,781.82 $3,557,648.43 $3f699,634.00 $14f383f789.57 $3,247,565.45 16 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS Ilius sir iidl Q�il. hili VIII ��,PaiiiHking Sys'lteim $146f101.00 $0.00 $146,101.00 $5,616.10 $7,876.43 $21,937.00 $116,287.57 20% $23,112.23 $146,101.00 $0.00 $146,101.00 17 $5,616.10 $7,876.43 $21,937.00 $116,287.57 $23,112.23 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year R iirid 111111"""" iiiu 0,51 . WlHlage Sys'te�m EXPENSE ['(,N'-soi�iial S(,iii vics, SVIII i-ies & Wages 16,916.00 .00 16,916.00 21456.25 .00 10,178.82 61737.18 60 11,385.81 ")&iiel i1,,s 61825.00 .00 61825.00 11109.65 .00 41655.97 21169.03 68 51752.91 Coinl,],-acl ual iii-nice64,006.00 .00 64,006.00 21026.45 5,876.43 51694.21 521435.36 18 51755.51 285.00 .00 285.00 23.75 .00 95.00 190.00 33 218.00 563.00 .00 563.00 .00 .00 563.00 .00 100 .00 Otlhie�iiiires .00 .00 .00 .00 .00 .00 .00 +++ .00 Ill; 13uliildiirigs .00 .00 .00 .00 .00 .00 .00 +++ .00 71506.00 .00 7f5O6.00 .00 .00 .00 71506.00 0 .00 50,000.00 .00 50,000.00 .00 21000.00 750.00 471250.00 6 .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS Ilius sir iidl Q�il. hili VIII ��,PaiiiHking Sys'lteim $146f101.00 $0.00 $146,101.00 $5,616.10 $7,876.43 $21,937.00 $116,287.57 20% $23,112.23 $146,101.00 $0.00 $146,101.00 17 $5,616.10 $7,876.43 $21,937.00 $116,287.57 $23,112.23 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS Fuiir.iid Q52, t ilius 111111 teveiiinije I $155,108.00 $0.00 $155,108.00 $5,328.24 $12f002.51 $23,034.20 $120,071.29 23% $35,759.74 $155,108.00 $0.00 $155,108.00 IV $5,328.24 $12f002.51 $23f034.20 $120,071.29 $35,759.74 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year R iirid 0,521111 iiiHkiing Sys'te�m ��Ieve�nue111111"""' iiiu EXPENSE ['(,N'-soi�iial S(,iii vics, SaIll i-ies & Wages 15,576.00 .00 15,576.00 21225.63 .00 91325.53 61250.47 60 81303.31 Ill; iii°ulll�lll cc ")&iiel i1s 61562.00 .00 61562.00 998.03 .00 41211.03 21350.97 64 41247.10 Coinl,],-acl ual Sei�-vices 112,083.00 .00 112,083.00 11319.23 12f002.51 4,210.84 95,869.65 14 17f304.01 U1,J11il'J"es 9f799.00 .00 9f799.00 761.02 .00 862.48 81936.52 9 1f573.40 292.00 .00 292.00 24.33 .00 97.32 194.68 33 322.32 CGTH'Tlodities & st 1Ill)111)Iies 10f796.00 .00 10f796.00 .00 .00 4,327.00 6,469.00 40 .00 01,lliieir "Xlpeinci'll iiii,-es .00 .00 .00 .00 .00 .00 .00 +++ .00 Ill; ,3uildiiiiiigs .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 Fuiir.iid Q52, t ilius 111111 teveiiinije I $155,108.00 $0.00 $155,108.00 $5,328.24 $12f002.51 $23,034.20 $120,071.29 23% $35,759.74 $155,108.00 $0.00 $155,108.00 IV $5,328.24 $12f002.51 $23f034.20 $120,071.29 $35,759.74 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS Fug r id 060 V61iWI(! Maiin'teiinaiiu e i iiuiind I otals $2,034,247.00 $0.00 $2f034f247.00 $152,899.39 $193,965.05 $692,170.19 $1,148,111.76 44% $724,129.09 $2f034,247.00 $0.00 $2,034,247.00 $152,899.39 19 $193,965.05 $692,170.19 $1,148,111.76 $724,129.09 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year R iirid 060 V6hWle EXPENSE ['(,N,-soi�iial S(,iii vics, SaIll i-ies & Wages 947,587.00 .00 947,587.00 67,320.49 .00 313,480.38 6341106.62 33 334,575.61 ")&iiel i1s 357,549.00 .00 357,549.00 25,823.86 .00 119,244.17 238,304.83 33 165,691.42 01.1,i&-, C',ost.'s 41167.00 .00 41167.00 686.40 .00 11012.40 31154.60 24 11403.93 Coi�-il,],-a d,,uel Se�� vices 111,883.00 .00 111,883.00 61697.15 35,599.59 23,096.95 53,186.46 52 28,639.38 ul,lilil'J"es 31392.00 .00 31392.00 380.02 .00 1f501.30 11890.70 44 11396.07 1 isuvi alrice 111706.00 .00 11f706.00 975.50 .00 31902.00 7,804.00 33 .00 C .'6ni�rnodities & 9 ilp1plies 593,408.00 .00 593f408.00 51,015.97 158,365.46 229,862.57 205f 179.97 65 191,634.48 .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�,- [,� 1 31941.00 .00 31941.00 .00 .00 .00 31941.00 0 490.00 EXPENSE TOTALS Fug r id 060 V61iWI(! Maiin'teiinaiiu e i iiuiind I otals $2,034,247.00 $0.00 $2f034f247.00 $152,899.39 $193,965.05 $692,170.19 $1,148,111.76 44% $724,129.09 $2f034,247.00 $0.00 $2,034,247.00 $152,899.39 19 $193,965.05 $692,170.19 $1,148,111.76 $724,129.09 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry 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 R iirid 061. V6hWle EXPENSE 08111(,N,- [, III 'iii d lii t ii iii .00 .00 .00 .00 .00 .00 .00 +++ .00 mota,- [ ......... .. . 11073,000.00 852,000.00 1f925f000.00 89f 184.38 850f050.35 130,898.70 944f050.95 51 42f 769.91 .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS FLElld� 061. V61iWle $1,073f000.00 $852f000.00 $1f925f000.00 $89,184.38 $850f050.35 $130,898.70 $944,050.95 51% $42,769.91 $1f073,000.00 $852f000.00 $1,925,000.00 $89,184.38 20 $850f050.35 $130,898.70 $944,050.95 $42,769.91 Expense Budget by Account Classification Report F .......... . 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS IIFuiir°iid2, CailnIIIpu'te�r I otals $412,900.00 $75f000.00 $487,900.00 $0.00 $16,631.66 $44,156.35 $427,111.99 12% $34,122.91 $412,900.00 $75f000.00 $487,900.00 21 $0.00 $16,631.66 $44,156.35 $427,111.99 $34,122.91 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, Carnqptrte�r VIII �iiiir��iiii 111111"""' iiiii 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 .00 16,631.66 44f 156.35 1771111.99 26 34f 122.91 EXPENSE TOTALS IIFuiir°iid2, CailnIIIpu'te�r I otals $412,900.00 $75f000.00 $487,900.00 $0.00 $16,631.66 $44,156.35 $427,111.99 12% $34,122.91 $412,900.00 $75f000.00 $487,900.00 21 $0.00 $16,631.66 $44,156.35 $427,111.99 $34,122.91 Expense Budget by Account Classification Report F .......... .gum 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS R. iir m IIIIIIiiii lk Ill..., otals $9,208,873.00 $0.00 $9f208f873.00 $649,605.35 $32,590.00 $3,384,377.67 $5,791,905.33 37% $4f010f854.40 $9,208,873.00 $0.00 $9f208f873.00 $649,605.35 22 $32,590.00 $3,384,377.67 $5,791,905.33 $4f010f854.40 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ Account Classification Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year R i�rid 063 Manage�mein't 111111"""' uii iiia EXPENSE Caiib-acbjal Sirv"'ces 40,000.00 .00 40,000.00 4f800.00 .00 41800.00 35,200.00 12 .00 iiriwi'a,iice 91146,373.00 .00 9,146,373.00 642f605.35 32,590.00 3f377f047.01 5,736,735.99 37 4f009f046.25 CararnodlI,J; s & SqplplHies 22f500.00 .00 22f500.00 2f200.00 .00 2,530.66 19,969.34 11 695.50 .00 .00 .00 .00 .00 .00 .00 +++ 1f112.65 I f dlI °Jqsf(:%��-qz I Z) i .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS R. iir m IIIIIIiiii lk Ill..., otals $9,208,873.00 $0.00 $9f208f873.00 $649,605.35 $32,590.00 $3,384,377.67 $5,791,905.33 37% $4f010f854.40 $9,208,873.00 $0.00 $9f208f873.00 $649,605.35 22 $32,590.00 $3,384,377.67 $5,791,905.33 $4f010f854.40 Expense Budget by Account Classification Report F .......... .gum 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS R jiirid 070 111261ice I ("Ac" lic a $5,985,209.00 $0.00 $5f985f209.00 $498,642.61 $0.00 $1f937f739.24 $4,047,469.76 32% $1f704f996.67 $5,985,209.00 $0.00 $5f985f209.00 $498,642.61 23 $0.00 $1,937,739.24 $4,047,469.76 $1,704,996.67 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 111111° lieu 1111°insian 111111' �iiiu EXPENSE 51790,809.00 .00 5f790f809.00 471f324.93 .00 1f904f651.36 3f886f157.64 33 1f697f884.85 Cani.]-actual S&rvices 167f300.00 .00 167f300.00 27,317.68 .00 33f087.88 134,212.12 20 7f1I1.82 iirisui�'a'ice 15f000.00 .00 15f000.00 .00 .00 .00 15,000.00 0 .00 & SqpIplies 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 0111, 1h°ieiiiICJl i lll,"U ["E'll"S' 12,000.00 .00 12,000.00 .00 .00 .00 12,000.00 0 .00 Office "q .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS R jiirid 070 111261ice I ("Ac" lic a $5,985,209.00 $0.00 $5f985f209.00 $498,642.61 $0.00 $1f937f739.24 $4,047,469.76 32% $1f704f996.67 $5,985,209.00 $0.00 $5f985f209.00 $498,642.61 23 $0.00 $1,937,739.24 $4,047,469.76 $1,704,996.67 Expense Budget by Account Classification Report F .......... .gum 04/30[111 9 6, IIIiaII" cYaAativVIII t'llyIIIIdided S u IIII'n III,a Illlry I ............. JsUIIIig EXPENSE TOTALS $6,193,836.00 Adopted Budget Amended Current Month YTD YTD Budget ® YTD % Used/ $0.00 Account Classification Budget -Amendments Budq t Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTD R iirid 071. 1111)elin silio an 111111"""' iiiis Ga,iid I otills $162,538,139.00 EXPENSE $6,885,500.00 $169,423,639.00 $71192f068.78 $11,837,502.99 $31f583f542.10 $126f002f593.91 $30,671,930.45 [l(,NllS,,'Dll Ilflliits' 61032,036.00 .00 6f032f036.00 5141241.19 .00 2f054f967.94 3f977f068.06 34 1f941f492.06 Canl,],-actuall S&rvices 136f700.00 .00 136f700.00 20,457.32 .00 41,417.32 95,282.68 30 19,458.61 iirisui�'a'ice 15f000.00 .00 15f000.00 .00 .00 .00 15,000.00 0 .00 & SqpIplies 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 01111h°ieiii11x111,)Elll 10,000.00 .00 10,000.00 .00 .00 .00 10,000.00 0 .00 EXPENSE TOTALS $6,193,836.00 $0.00 $6,193,836.00 $534,698.51 $0.00 $2f096f385.26 $4,097,450.74 34% $1f960f950.67 FILA'id 071.111111 iiiir 111111° iiiiii 'iiiii s 111111' iiiis ui ...Ill...,otals $6,193,836.00 $0.00 $6,193,836.00 $534,698.51 $0.00 $2f096f385.26 $4,097,450.74 $1f960f950.67 Ga,iid I otills $162,538,139.00 $6,885,500.00 $169,423,639.00 $71192f068.78 $11,837,502.99 $31f583f542.10 $126f002f593.91 $30,671,930.45 24 Mount Piosvk rrr�r. Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: DEPUTY DIRECTOR OF FINANCE DATE: MAY 1512019 SUBJECT: MONTHLY FINANCIAL REPORT — APRIL 2019 Attached hereto are the cash position and investment statements of the Village for the month ended April 301 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 March 31 was $66.2 million. During April, cash receipts totaled $6,743,776 and investment income was $104,173. Reductions in cash and cash equivalents during March totaled $5,912,417. Of this amount, payments to vendors were $4,430,118 and employee payroll expenses were $1,470,229. Inflows resulting from interfund activity totaled $45,557 while other reductions to cash totaled $12,070. There was also a net transfer from investment of $11,325. Cash and cash equivalents at April 30 were $67.2 million. Investments in the Governmental and Enterprise Funds at March 31 were $29,053,745. Investment activity during the month of April included investment income totaling $24,079 and a net transfer to cash of $11,325. 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 April 30 were $29,0665500. Total cash and investments for Governmental and Enterprise Funds at March 31 were $95,290,336. Cash and investments increased $1,005,168 for the month. Cash and investments at April 30 totaled $96,2957504. Monthly Financial Report — April 2019 May 15, 2019 Page 2 Trust and Agency Funds - Cash and cash equivalents at March 31 was $6,275,023. During April, cash receipts totaled $288,003. Investment income for the month was $106,065. Cash investment activities resulted in a net decrease of $42,745 while outflows due to Interfund activity totaled $45,557. Reductions in cash and cash equivalents during April totaled $1,046,789. Of this amount, payments to vendors were $178,231 and employee payroll and related expenses were $865,955. Other disbursements totaled $2,603. Cash and cash equivalents at April 30 were $5,533,997. Total investments at April 30 were $138,711,391, an increase of $3,069,252 from March 31. Investment gains of $3,026,506 and a net transfer to investments of $42,745 accounted for the change. Total cash and investments for Trust and Agency Funds at March 31 were $141,917,162. Cash and investments increased $2,328,226 for the month and totaled $144,245,388 at April 30. 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 March 31 totaled $21,823,330. During April, cash receipts totaled $3,494,290, and investment income was $40,589. 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 April totaled $1,573,867. Sales taxes received in April are for taxes generated from sales in January. There is a three-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 April totaled $522,920. Income taxes collected by the State in March are received by the Village in April. Disbursements from the General Fund for April included payments to vendors of $1,242,830, interfund transfers of $800,973, payments for employee wages and benefits of $1,311,003 and other disbursements of $5,235. Cash and cash equivalents at April 30 were $20,558,815, an increase of $174,838 from March 31. In addition, investments consisting of certificates of deposit were $1,234,515. Cash and investments for the General Fund at April 30 totaled $21,823,330. Monthly Financial Report — April 2019 May 15, 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 April 30, $29,066,500 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 April 30, there was a total of $138,711,392 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. Lynn M Jarog Deputy Director of Finance VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended April 30, 2019 GOVERNMENTAL AND ENTERPRISE FUNDS Investments $ 29, 053, 745.72 24,079.72 (11,325.00) $ 29, 066, 500.44 TRUST AND AGENCY FUNDS Cash and Cash Equivalents Balance at March 31, 2019 $ 66,236,590.32 Cash receipts 637433776.06 Investment income 1043173.80 Transfers from investments to cash 113325.00 Transfers to investments from cash - nterfu nd activity 45, 557.47 Disbursements: Accounts payable (41430,118.33) Payroll (114703229.75) Other (123070.09) Balance at April 30, 2019 $ 6732299004.48 Investments $ 29, 053, 745.72 24,079.72 (11,325.00) $ 29, 066, 500.44 TRUST AND AGENCY FUNDS Investments $ 135, 642,139.71 3, 026, 506.84 (17259)271.12) 1, 302, 016.40 $ 138, 711, 391.83 Total Cash and Investments $ 9572907336.04 6, 743, 776.06 128,253.52 45,557.47 (474307118.33) (17470,229.75) (12, 070.09) $ 9672959504.92 Total Cash and Investments $ 14199179162.80 288,003.14 3,132, 572.10 (45,557.47) (178,231.83) (8387813.85) (27,142.66) (2,603.32) $ 1447245,388.91 * Assets are restricted in purpose and do not represent discretionary assets of the government. Cash and Cash Equivalents Balance at March 31, 2019 $ 692755023.09 Cash receipts 2885003.14 Investment income (loss) 106,065.26 Transfers from investments to cash 1,259,271.12 Transfers to investments from cash (1)3025016.40) Interfund activity (455557.47) Disbursements: Accounts payable (178)231.83) Payroll (838)813.85) Flex spending (275142.66) Other (21603.32) Balance at April 30, 2019 $ 5,533,997.08 Investments $ 135, 642,139.71 3, 026, 506.84 (17259)271.12) 1, 302, 016.40 $ 138, 711, 391.83 Total Cash and Investments $ 9572907336.04 6, 743, 776.06 128,253.52 45,557.47 (474307118.33) (17470,229.75) (12, 070.09) $ 9672959504.92 Total Cash and Investments $ 14199179162.80 288,003.14 3,132, 572.10 (45,557.47) (178,231.83) (8387813.85) (27,142.66) (2,603.32) $ 1447245,388.91 * Assets are restricted in purpose and do not represent discretionary assets of the government. N Q V � O W 7C3 ON a � O LL o a �QH �= z 70 U76 O a C: W LL (� O U O LU O 2 J� _J E O > n LL U) 0 Z U - LU U) ryW H W Z a a H Z W Z W O r 0 CO N O O r CO O CO CO N O r* 01- CO 0 r LC) M 6 6 CO CO O M N M O r J r 1` CO M r I` � It U') O a O I` N LO O O r O CO O r r 0 0 N It ti 6) 0o M O r CO r I- O r N 0 0 CO 0 LO O N N M �� c) CO I- N I, r r N193- N r- 69- 00 -6g00 6) r 1` N CO CO I� U)>- 00 6) N O M CO 6) O �U ' Z� 06 06 oo� LN 000 W 6) r CO CO r CO � r r r 1` PI r Ln Q Z N6) 6) N N N LU O 2 C) LL r F- Z O a 69- LO gLO LO N O O LO 1` r N r O r "t't o0 00 O p U) Ii IT O r 0 00 M 06 N zW z OM CD NOM T- < 00LLO LO aUo _ J 00 r� r N CM M 00 �Oz `•� W W LL � L6 69- M g0 N CO O O 1,- 6) Ldp M 00 Z M O 00 O It O 1` M It a W' ' O CO M Ln I� O 6) 06 14 > (n L ti= CO LO O N r O d 0 O M r Ln N O O 6) O z M� O r r ti M N C9 W D N I- It N J F- LL COO CO F- Z O W H 69- U) 1` ti N N O 6) 6) 0 N O It 00 ti It M J z i i Lfi< 04 CO I`r-O ti CO 00 r CL I-LOoo N do It ZL 0� W 6i � 6i o cr o 0 LUD r - U Q0 L m ti co Z> — 0� W U W N r- ti 000 a)(D T- U) 6 1` ti o _o cM 6 CIS 0- 0 LO a) Ln LO O O O N 0�Z q7titi MCO cMT--7 Co M W 00 r Lf) O O r H LL 00 N r r ti r z N r M W r r N 0 00 O 0o 00 6) O 1` O O CO F- C) 0 (D C) M r- NT Wz CO N r r O O W M 6) N r a O ) I- "t co � 6 U�LL M a r r W � � O ti W0 O "t M 00 Cn Z CT 06 O 00 00 6) LO N 1` co x Lf ) W 1 I� LO r 1- 1- (3) N N CO r 00 I- � 00 r- O J W It It N N C15 L» M r UZD Q0_�oro rn0000 �M W W Z 00 co O N CM M a > 6) 1- N LO U) w LL Ln LO 6g Z L6MLf o n� NNS qT D ti O 6) ' ' M Ln ' cri O Ln LL 1` 6) 00 I` M O M r J 6) N LC) 6) N O 00 00 a 0 LO r a)� O r 000 Nt"t 00 M N LO W .� z0 M r O W N �� N U' 6e} O � ~ >6 Z Q W >n U J C:» Q N ) N - > EL p -I-- O a) L O W > v o� CL cu _ >u UC U >A E V m e E E E E mW ,� U 4) L L-0 N N O O -0 _ c w E w w c L L L L O Q a) M > : V m U H H W �co C) r- m N CO N co O f` N M LO O r- co 0o O CO O 1` LW) 6) LO M O N It 07 O I* r N I- i L6 0o Re N r 40 co CD co N CO o0 0w0 4 ti r M � M CD O 0) M r- r r O O r r NT 6) c r r O ' ' O O LO LO LO O O w O O N 6) 6) Cfl N N CD Orl- O C CO ' ' CO LO ,,:I- It m LO LM() N 1� f� CO M M r O co ' ' O co ti IrM I- N N co IrIr M r 6F} ti N Ln 00 O Ili N N U') 00 O I�i N Cho m 0 M 00 M 64 LO 0o a) N O E L!7 N O O � O N O r O U) >v Lc) L- L � O LO Co r LO co N r Ln co r LO co N r r U N O N M M a) N N w 4- v O N c 64 70 co cu H z U) N W O Q Z Cl) a U N } N s= ;+� Z O Q U - U N >a 0 > > U) Q 4-1 N L O _� � Z N = L n a) N v cu cu L u > LC N�LU � C J Cn Q ~O z�v ° a H H VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of April 30, 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% 112341514.65 1,234,514.65 POLICE & FIRE BUILDING CONSTRUCTION FUND (025) 05/08/19 12/21/18 BMO Harris Bank, NA, IL Certificate of Deposit 16571 2.330% 2,50000.00 06/05/19 12/21/18 BMO Harris Bank, NA, IL Certificate of Deposit 16571 2.430% 30000.00 07/03/19 12/21/18 BMO Harris Bank, NA, IL Certificate of Deposit 16571 2.430% 3001000.00 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% 215021523.09 09/30/19 12/21/18 US Treasury Note US Treasury Note 912828TR1 2.562% 2021877.76 10/31/19 12/21/18 US Treasury Note US Treasury Note 912828F62 2.581% 1,502,921.12 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% 24300.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 912828073 2.602% 1,167,242.65 01/31/20 12/21/18 US Treasury Note US Treasury Note 912828H52 2.599% 1,0801377.48 02/29/20 12/21/18 US Treasury Note US Treasury Note 912828UQ1 2.641% 1,002,275.69 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 CFG 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 24,078,523.09 VEHICLE REPLACEMENT FUND (061) 05/30/19 12/28/17 Freddie Mac Agency Notes 3137EADG1 1.750% 1,2491316.25 06/12/20 12/28/17 Federal Home Loan Bank Agency Notes 313383MB4 1.875% 112431207.50 12/11/20 12/28/17 Federal Home Loan Bank Agency Notes 3130A3UQ5 1.875% 1,2401838.75 3,7331362.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 $ 29,066,500.44 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of April 30, 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 $ 21,8721582.96 Various Various Various Mutual Fund Investments Various Various 50,28106.99 72,154,449.95 FIRE PENSION FUND (071) Various 5/26/2015 Principal Life Insurance Company Group Annuity Contract 8-10810 Variable 6,202,241.88 Various Various Wells Fargo Wells Fargo Investments Various Various 23,7621041.27 Various Various Various Mutual Fund Investments Various Various 3615921658.73 66,5561941.88 TOTAL TRUST AND AGENCY FUND INVESTMENTS $ 138,7111391.83 * Assets are restricted in purpose and do not represent discretionary assets of the government. VILLAGE OF MOUNT PROSPECT List of Bills May 1, 2019 - May 14, 2019 Fund Vendor Name Invoice Description 001 General Fund 199 Randhurst LLC Black Finn Elected Officials reception 3B Group LLC Grounds Maintenance Materials and Supplies ACS State & Local Government Solutions Illinois State Disbursement Unit Addison Building Material Co. Building maintenance repair supplies Building maintenance repair supplies Patching Materials Equipment maintenance supplies Restoration Materials Restoration Materials Equipment Maintenance Airgas, Inc. Oxygen Allscape, Inc. Grounds Maintenance Services American Landscaping Inc. Grass cutting - 2 N. Main Andres Medical Billing, Ltd. Ambulance Billing - April 2019 ARC Document Solutions, LLC Engineering Supplies And Materials Arguilles, Consuelo Global Leadership Summit- Consuelo registration Ariens Specialty Brands LLC Forestry Equipment and Supplies Avanti Cafe & Sandwich Bar, Inc. Elected Officials reception Bald Eagle Window Cleaning Equipment Maintenance Batteries Plus Holding Corporation Equipment Maintenance Bear Estates #1, LLC Prisoner meals - March, 2019 Bedco Mechanical Building Maintenance & Repair Building Maintenance & Repair Building Maintenance & Repair Building Maintenance & Repair Building Maintenance & Repair Building Maintenance & Repair Beliveau Professional Services Course registration Blue Cross Blue Shield Refund for Ambulance Services (Christopher Rivera) 9/29/16 Bond, Dickson & Associates PC Legal Britt Industries, Inc. Sign Making Materials And Supplies Busse's Flowers & Gifts Gifts & Flowers Sympathy Flowers Case Lots, Inc. Custodial Supplies Custodial Supplies CBS Awards Retirement plaque Central States Automatic Sprinklers Equipment Maintenance Repair Services Chem -wise Ecological Pest Mgmt. Inc. Equipment Maintenance Equipment Maintenance Chief Supply Corp. Squad emergency supplies Christopher B. Burke Engineering Ltd Intersection Studies CIT Bank, N.A. Equipment Lease City of Lake Forest Membership Fees Clifford -Wald & Co., Inc. - A KIP Company Engineering Supplies And Materials Equipment Maintenance Community Consolidated School District 59 Refund Business Licenses(1901 Estates,1900 Lonnquist&1805 Aspen) Constellation NewEnergy, Inc. Electricity - Streetlights Cooney, William J. MLS Gameplan lunch meeting Costar Realty Information, Inc. Co -Star services Dennison Leafblad, Deborah Camera Operator Camera Operator Eckert, William Reimbursement - Eckert - 2019 IAAI Renewal EESCO, A Division of WESCO Distribution, Inc. Custodial Supplies Custodial Supplies Eldredge, Candace Garnishment Elegant Embroidery Inc. Uniforms & Clothing - Supplies Elite K-9 Inc. Supplies for K-9 unit Eterno, David G. April legal Page 1 of 12 Amount 9 180.00 100.00 3,496.19 13.47 12.21 147.26 56.84 37.80 134.84 39.88 318.92 1,957.00 60.00 7,457.83 301.39 1,500.00 347.97 402.00 4,166.00 551.45 305.55 1,390.80 690.00 644.50 2,534.35 1,552.50 4,813.70 990.00 468.80 3,811.00 300.00 95.00 63.50 239.60 182.00 70.00 1,090.00 30.00 215.00 535.49 4,142.54 388.79 2,916.67 76.48 65.00 470.00 79.04 78.96 783.76 150.00 150.00 130.00 858.36 97.47 686.46 36.81 47.98 405.42 VILLAGE OF MOUNT PROSPECT List of Bills May 1, 2019 - May 14, 2019 Fund Vendor Name Invoice Description Amount 001 General Fund (continued) Evans, Tim Paramedic License Renewal 40.00 Experian Background checks - April, 2019 77.48 Fahey, Paul Equipment Maintenance 136.08 Federal Express Corp postage 23.17 postage 17.63 Fiesta Market Refund Sign Variation Application Fee 200.00 Fire Pension Fund Fire Pension 25,834.61 Fleck's Landscaping Landscape Maintenance 5,954.11 G & J Associates, Inc. Custodial Supplies 712.80 Lettering for 5-0 5K banner 140.00 Garvey's Office Products Building maintenance repair supplies 642.13 Toner - FPB, Nell's printer 187.42 Gene's Village Towing Inc. Tow service for FD extrication training car 100.00 Ghawaly, Michael Paramedic License Renewal 40.00 Gonet, Sarah Gas for village car to attend IFSAP Conference 40.40 Gordon Flesch Company, Inc. Quarterly Lease M120454 4,697.58 GF Monthly Lease Extension 05/22/19-06/21/19 1,529.77 Graceland College Center for Prof. Dev. Register for training class 05/13/19 179.00 Greek Feast Elected Officials reception 450.00 Green Soils Management LLC Grounds Maintenance Materials and Supplies 315.00 Grounds Maintenance Materials and Supplies 630.00 GTNL Group LLC Refreshments for BOFPC Recruit testing oral interviews 05/07/19 165.00 Healy Asphalt Company, LLC Patching Materials 225.98 Patching Materials 96.60 Patching Materials 82.80 Patching Materials 182.28 Home Depot U.S.A., Inc. Equipment Maintenance 158.27 ICMA Retirement Trust - 401 ICMA 401(A) PD Chief Flat 11720.76 ICMA Retirement Trust - 457 ICMA 457 32,008.57 Illinois American Water Company Service Period 3/30/19 - 5/31/19 42.00 Illinois Convenience & Safety Corp bus shelter posters for Irish Fest 775.00 bus shelter posters for Fridays on the Green 325.00 Illinois Department of Revenue IL State Withholding 40,456.43 Image Trend Inc. Image Trend Connect 2019 - Mark Nabielec - 07/24/19-07/26/19 610.00 IMRF IMRF EFT April 2019 1511733.73 Internal Revenue Service Federal Withholding 178,310.39 International Association of Financial Crimes Inve Registration for training conference 490.00 International Union of Operating Engineers IUOE PW Membership Dues 1,331.54 J.P. Morgan Chase Bank N.A. Credit Card Purchases - March 2019 (4/15/19 EFT) 3,154.43 Kane, Ryan Reimburse training expenses 48.00 Kathleen W. Bono,csr, LTD Legal 491.60 Kowalczyk, Stanley Transfer Stamp Rebate 660.00 Krotky, Kevin Uniforms & Clothing - Supplies 154.95 Lands' End Business Outfitters Uniforms & Clothing - Supplies 103.49 Laner Muchin, LTD Legal 3,396.94 Leib, Jason Travel and Meeting Expenses 80.00 LexisNexis Risk Data Management Inc. Background checks - April 2019 111.50 Lifeline Training Register for training class 687.00 Lorman Business Center, Inc. Training - Fees 175.20 Lund Industries, Inc. Equipment maintenance for Dept. Pick-up 79.89 Masterson, Danielle Marie On Camera Talent MP Update 200.00 Mazursky, Shelby Professional Services 285.00 Printing Expense - Outsource 109.00 McGuffin, Mark Reimburse expenses: Officer of the Year selection meeting 64.19 Mcmaster-carr Supply Co. Equipment Maintenance 89.18 Menard Inc. Equipment Maintenance 107.26 Building maintenance repair supplies 22.56 Equipment Maintenance 57.94 Page 2 of 12 VILLAGE OF MOUNT PROSPECT List of Bills May 1, 2019 - May 14, 2019 Fund Vendor Name Invoice Description Amount 001 General Fund (continued) Menard Inc. (continued) Building maintenance repair supplies 5.94 Building maintenance repair supplies 53.40 Building maintenance repair supplies 25.91 Building maintenance repair supplies 130.95 Custodial Supplies 26.72 Building maintenance repair supplies 35.95 Building maintenance repair supplies 37.52 ET Supplies 28.36 Metro Door and Dock, Inc. Overhead Garage Door Maintenance 11185.49 Overhead Garage Door Maintenance 893.91 Overhead Garage Door Maintenance 600.00 Overhead Garage Door Maintenance 600.00 Overhead Garage Door Maintenance 200.00 Metro Federal Credit Union MP Fire Local 4119 Dues 2,509.32 Metropolitan Alliance - Police MP Police Association Dues 1,350.00 Metropolitan Mayors Caucus Metropolitan Mayors Caucus 2019 Event 220.00 Michael Wagner & Sons, Inc. Building maintenance repair supplies 252.92 Parts and Supplies 146.84 Mobile Print Inc. Liquor printing signage 104.76 Business card printing 31.02 Elected Official invitation printing 174.60 BOFPC letterhead 159.08 Fridays on the Green Posters 143.56 Morris, Peter Paramedic License Renewal 40.00 Morrison Associates, Ltd. Education and Training 997.50 Mount Prospect Chamber of Commerce Chamber yearly membership dues & sponsorship 18,000.00 Mount Prospect Public Library Fiber Optic Charges for Village Hall 1/16/19 - 4/15/19 944.99 Fiber Optic Charges for CC Center 1/16/19 - 4/15/19 458.77 MSF Graphics Inc. CAFR Tabs & Binder Combs (Imprint Spines & Laminated) 118.00 Municipal Emergency Services, Inc. Personnel Safety Equipment and Supplies 282.19 Nationwide Mutual Insurance Company Nationwide 457 10,268.05 NCPERS Group Life Ins. IMRF Life Insurance 495.60 Nelson, Michael Reimburse expenses: pads for dept. fitness equipment 123.10 NICOR Natural Gas 111 E Rand 276.08 North East Multi Regional Trng Register for training class 1,125.00 Northshore University Healthsystem Medical exam 453.00 Northwest Central Dispatch System June 2019 Member Assessment 57,069.93 Northwestern University Register for Supervision of Police Personnel 08/19-30/19 1,000.00 Novak, Todd Per Diem & Parking for FDIC Conference 80.00 Nutphrees Bakery Inc. Cake for reception 48.00 Pennwell Publishing Company 2 year Subscription for Digital Magazine only 39.00 Pesche's Flower Shop Flowers and Shrubs 159.99 Petty Cash Petty Cash - Police Department 4/17/19 257.99 Petty Cash - April 2019 119.73 Police Pension Fund Police Pension 31,993.88 Promos 911, Inc. "I Can Be Fire Safe" Coloring Books 702.75 Ramel, Andrew Uniforms & Clothing - Supplies 180.00 Ray O'herron Co., Inc. Body armor 2,682.86 Uniform supplies 493.85 Uniform supplies 11.99 Body armor 678.42 Patch replacement 52.00 RC Topsoil Inc. Restoration Materials 662.21 Redlin, Ronald Per Diem for FDIC conference 60.00 RHW Customized Graphics & Promotions Hats 163.18 Uniform Expense 477.45 Route 12 Rental Co., Inc. Equipment maintenance supplies 442.81 SAE Customs Inc. Outfitting labor, shop supplies & electrical parts for Tahoe 332.50 Page 3 of 12 VILLAGE OF MOUNT PROSPECT Fund Vendor Name 001 General Fund (continued) SAE Customs Inc. (continued) Salveo Inc. Sam Schwartz Engineering, D.P.C. Schroeder & Schroeder Inc. Schwegler, Richard Shaffer, Wylie Shallcross, Jason Sherwin Williams Paint Company Silk Screen Express Society of Municipal Arborists Southern WI Northern IL Fire Rescue Association Standard Equipment Company Steiner Electric Company Stephen A. Laser Assoc.,p.c. Streicher's Inc. Superior Industrial Supply Co. Systems Forms, Inc. The Sign Palace, Inc. The Stevens Group LLC Thelen Materials LLC Thompson Elevator Inspections TransUnion Risk and Alternative Data Solutions Inc. Trejo, Miguel Uidl, Randy Uline Inc. UniFirst Corporation United Maintenance Company, Inc. US Department of Education AWG Verizon Wireless Services LLC Veterans of Foreign Wars Post 1337 Village of Mount Prospect Village of Romeoville W. W. Grainger, Inc. W.S. Darley & Co. Warehouse Direct Wide Open West Wisconsin Department of Revenue Wojcik, Paul C. Wuotinen, Keith A Yantis, Alex Yuh, Sunhee 001 General Fund Total 020 Capital Improvement Fund Addison Building Material Co. CS2 Design Group, LLC List of Bills May 1, 2019 - May 14, 2019 Invoice Description Amount Outfitting labor, ext. spkr. & shop supplies for Explorer 397.50 Postage 15.66 Engineering 4,102.48 Sidewalk Repairs 56,546.48 Registration fee & per diem for FDIC conference 52.00 Reimburse training expenses 04/22-26/19 160.00 travel reimbursement for the U of O Economic Dev. Institute- JS 197.51 Building maintenance repair supplies 204.25 Vest cover 168.00 Vest cover 168.00 Vest cover extensions 25.00 Professional Services 100.00 Annual Membership Dues 5/1/19 - 5/1/20 30.00 Street Sweeper Supplies 984.47 Parts and Supplies 115.23 Candidate Assessment 550.00 Bags for staff employees 3,040.00 Custodial Supplies 653.88 23 Sets of Budget Covers Front & Back 95.13 Office Supplies 140.00 Printing and Mailing of May/June Newsletter 6,686.77 Grounds Maintenance Materials and Supplies 187.65 Grounds Maintenance Materials and Supplies 375.30 Thompson Elevator inspection 225.00 Background checks - April, 2019 118.98 Reimburse training expenses 04/08-12/19 60.00 EMT license renewal 20.00 Custodial Supplies 82.61 Custodial Supplies 508.21 Uniforms and Clothing -Cleaning 225.06 Uniforms and Clothing -Cleaning 212.95 Uniforms and Clothing -Cleaning 243.37 Custodial Services 21275.82 Garnishment 216.28 Cellular Service & Equipment Charges 4/20/19 - 5/19/19 9,515.33 Memorial Day Parade 11200.00 Flex - Medical 10,526.50 Fringe Benefit - Auto 336.54 Rope Ops, 4/22 - 4/26 - Anders 450.00 Equipment maintenance supplies 132.72 Equipment maintenance supplies 207.44 Custodial Supplies 650.52 Equipment maintenance supplies 38.19 2.5" hose adapters & hose cap 423.83 Credit Memo - Returned hose cap (57.00) Document holder, desk organizer, keyboard and mouse wrist rest 134.89 Office Supplies 173.84 Fire Main & Fire #12 & Fire #13 - 4/21/19 - 5/20/19 922.98 WI State Withholding 449.29 Paramedic License Renewal 40.00 Non -Destructive Entry & Lock Picking, 6/3-6/4 950.00 Refund Overpayment Police Ticket #P3966338 25.00 Refund Overpayment Police Ticket# P3966176 50.00 $ 759,166.97 Building maintenance repair supplies $ 26.07 HVAC Repair services 4,720.00 Page 4 of 12 VILLAGE OF MOUNT PROSPECT List of Bills May 1, 2019 - May 14, 2019 Fund Vendor Name Invoice Description Amount 020 Capital Improvement Fund (continued) G & J Associates, Inc. Building maintenance repair supplies 1,270.00 Home Depot U.S.A., Inc. Equipment Maintenance 988.94 Idlewood Electric Supply Inc. Parking Deck Maintenance 3,304.08 Maxx Contractors Corp Salt / De -Icing Agents 19,425.00 Mount Prospect Paint, Inc. Building maintenance repair supplies 273.68 Building maintenance repair supplies 19.40 Building maintenance repair supplies 307.93 Building maintenance repair supplies 156.97 Building maintenance repair supplies 25.83 Building maintenance repair supplies 110.82 Building maintenance repair supplies 386.92 Northwest Central 9-1-1 System Motorola Subscriber Financing - May 2019 10,603.91 Northwest Electrical Supply Parking Deck Maintenance 540.00 Parking Deck Maintenance 368.31 Pa rkeon Parking Lot / Parking Deck 560.00 Traffic Control & Protection Inc. Parking Deck Maintenance 544.00 020 Capital Improvement Fund Total $ 43,631.86 023 Street Improvement Construct Fund Dale, Penny & Andy Refund Vehicle Stickers Fee (Moved Out) - Two Stickers $ 90.00 Gazis, Mary Refund Vehicle Sticker Fee (Senior Rate) 30.00 Goodrich, Greg H Refund Vehicle Sticker Fee (Senior Rate) 45.00 Medina, Luis Refund Vehicle Sticker Fee (Senior Rate) 30.00 Revolorio, Fernando Refund Vehicle Sticker Fee (Moved Out) 45.00 Rivas, Rogelio Refund Vehicle Sticker Fee (Purchased twice) 45.00 Ronay, Michael Refund Vehicle Sticker Fee (Moved Out) 68.00 Shah, Prashant Refund Vehicle Sticker Fee (Sold Vehicle) 45.00 023 Street Improvement Construct Fund Total $ 398.00 024 Flood Control Construction Fund Bushnell, Incorporated Sewer Pump Station Maintenance Repair Parts And Supplies $ 911.60 Sewer Pump Station Maintenance Repair Parts And Supplies 527.08 Commonwealth Edison Electricity 29.30 Constellation NewEnergy, Inc. Electricity - Streetlights 476.28 Copenhaver Construction Inc. Release Retainage & Pay Overage 2019 5,845.25 Home Depot U.S.A., Inc. Equipment Maintenance 459.82 Manhard Consulting Ltd. Storm Sewer Repair Services 1,098.75 Michael Wagner & Sons, Inc. Pumps 175.13 Underground Pipe & Valve Co. Sewer Pump Station Repair Services 498.00 Xylem Water Solutions USA, Inc. Pumps 5,586.00 024 Flood Control Construction Fund Total $ 15,607.21 025 Police & Fire Building Const. Camosy Incorporated Contractor for Police Station - April 30 2019 $ 261,203.00 Nicholas and Associates Fire Station 103,961.00 Republic Services, Inc. Refuse Disposal Program 3,182.49 STV Construction Inc. Police FF & E Coor 8,190.00 Fire FF & E Coor 3,367.00 True North Consultants, Inc. Police Asbestos 590.00 025 Police & Fire Building Const. Total $ 380,493.49 040 Refuse Disposal Fund Cartegraph Systems LLC Technology & Software Equipment, Supplies, & Services $ 8,299.41 Eldredge, Candace Garnishment 58.85 Groot Industries, Inc. Refuse Disposal Program 72.48 ICMA Retirement Trust - 457 ICMA 457 102.91 Illinois Department of Revenue IL State Withholding 491.74 IMRF IMRF EFT April 2019 3,486.61 Page 5 of 12 VILLAGE OF MOUNT PROSPECT List of Bills May 1, 2019 - May 14, 2019 Fund Vendor Name Invoice Description Amount 040 Refuse Disposal Fund (continued) Internal Revenue Service Federal Withholding 3,113.54 International Union of Operating Engineers IUOE PW Membership Dues 120.75 J.P. Morgan Chase Bank N.A. Credit Card Purchases - March 2019 (4/15/19 EFT) 261.44 Nationwide Mutual Insurance Company Nationwide 457 365.34 NCPERS Group Life Ins. IMRF Life Insurance 17.20 Republic Services, Inc. Refuse Disposal Program 14,002.85 Refuse Disposal Program 233,766.18 RHW Customized Graphics & Promotions Open House Supplies 430.00 Open House Supplies 425.00 Village of Mount Prospect Flex - Medical 226.26 Zarnoth Brush Works, Inc. Street Sweeping Supplies 674.00 040 Refuse Disposal Fund Total $ 265,914.56 041 Motor Fuel Tax Fund Baxter & Woodman, Inc. Traffic Signal Streetlight Improvement $ 3,849.30 Constellation NewEnergy, Inc. Electricity - Streetlights 23,252.49 H & H Electric Co Traffic Signal Maintenance 881.15 Schroeder & Schroeder Inc. Sidewalk Repairs 10,215.10 Thorne Electric Inc. Street Light Project 68,654.34 041 Motor Fuel Tax Fund Total $ 106,852.38 043 Asset Seizure Fund Nelson, Michael Reimburse expenses: Dept. fitness equipment $ 1,035.00 043 Asset Seizure Fund Total $ 1,035.00 046 Foreign Fire Tax Board Fund J.P. Morgan Chase Bank N.A. Credit Card Purchases - March 2019 (4/15/19 EFT) $ 79.95 Mobile Print Inc. Postage for annual FFT letters 520.30 Novak, Todd Per Diem & Parking for FDIC Conference 176.00 Schwegler, Richard Registration fee & per diem for FDIC conference 371.95 046 Foreign Fire Tax Board Fund Total $ 1,148.20 049 Prospect and Main TIF District Fleck's Landscaping Landscape Maintenance $ 10,196.12 S. B. Friedman & Company Legal - Professional Services through 4/30/19 8,982.88 The Sign Palace, Inc. Signs 1,050.00 049 Prospect and Main TIF District Total $ 20,229.00 050 Water and Sewer Fund ABT Electronics Equipment Maintenance $ 150.00 3021 Lynn Court Acquisitions LLC Utility Refund - 3029 Lynn Ct #B 12.95 Addison Building Material Co. Maintenance and repair supplies 41.82 Maintenance and repair supplies 8.98 Maintenance and repair supplies 52.20 Maintenance and repair supplies 10.03 Maintenance and repair supplies 65.87 Grounds Maintenance Materials and Supplies 13.49 Maintenance and repair supplies 108.54 Maintenance and repair supplies 21.66 Restoration Materials 26.67 Maintenance and repair supplies 26.99 Alexander Chemical Water System Treatment Chemicals 24.00 Ariens Specialty Brands LLC Uniforms & Clothing - Supplies 253.93 Aries Industries, Inc. Equipment maintenance supplies 208.12 B&W Control Systems Integration, L.L.C. SCADA Control System Maintenance 41290.00 Badger Meter Inc. Professional Services 11421.09 Baxter & Woodman, Inc. Professional Services 2,031.45 Burns & Mcdonnell Engineering Co. Professional Services 4,515.00 Page 6 of 12 VILLAGE OF MOUNT PROSPECT List of Bills May 1, 2019 - May 14, 2019 Fund Vendor Name Invoice Description Amount 050 Water and Sewer Fund (continued) Carhartt Retail, LLC Uniforms & Clothing - Supplies 119.98 Uniforms & Clothing - Supplies 59.99 Cartegraph Systems LLC Technology & Software Equipment, Supplies, & Services 5,820.59 Ciorba Group Inc. Sewer Lift Station Rehab 5,341.29 Professional Services 6,347.30 Constellation NewEnergy, Inc. Electricity - Streetlights 5,289.80 Electricity - 203 E Evergreen 59.25 Cornerstone Services, Inc. Equipment maintenance supplies 567.90 Dorner Products, Inc. Valves 2,866.00 Elegant Embroidery Inc. Uniforms and Clothing - Supplies 49.81 Uniforms & Clothing - Supplies 49.51 Finance of America Structured Securities Utility Refund - 216 N William St 92.12 Fleck's Landscaping Landscape Maintenance 5,715.77 G&L Contractors, Inc. Material delivery and debris hauling 8,462.56 Gordon Flesch Company, Inc. Quarterly Lease M120454 396.00 HBK Water Meter Service Meter Installation 6,910.31 Meter Installation 80.00 Meter Installation 900.00 Meter Installation 4,815.00 Meter Installation 2,620.00 Water Meter Testing Services 80.00 Home Depot U.S.A., Inc. Equipment Maintenance 211.11 ICMA Retirement Trust - 457 ICMA 457 676.34 Illinois Department of Revenue IL State Withholding 3,831.12 IMRF IMRF EFT April 2019 22,535.24 Internal Revenue Service Federal Withholding 23,482.28 International Union of Operating Engineers IUOE PW Membership Dues 11188.10 Jackson-hirsh, Inc. Office Supplies 132.99 Joseph D. Foreman & Co. Equipment Maintenance 685.00 Lands' End Business Outfitters Uniforms & Clothing - Supplies 230.61 Uniforms & Clothing - Supplies 134.80 Uniforms & Clothing - Supplies 310.46 Lee Jensen Sales Co. Inc. Portable Generators 384.00 Martam Construction Lift Station Rehabilitation Project 200,973.15 Menard Inc. Equipment Maintenance 42.40 Equipment Maintenance 207.01 Mizen, Colton Uniforms & Clothing - Supplies 180.00 Moe, Scott Uniforms & Clothing - Supplies 156.60 Nationwide Mutual Insurance Company Nationwide 457 11205.88 NCPERS Group Life Ins. IMRF Life Insurance 89.60 Newell Tool LLC Equipment maintenance supplies 140.00 NICOR Natural Gas 117 N Waverly PI 141.81 Natural Gas - 112 E Highland 254.73 Natural Gas 1 W Wa Pella 135.29 Ozinga Materials, Inc. Street Patching Materials 478.00 Paddock Publications, Inc. Office Supplies 92.00 RC Topsoil Inc. Restoration Materials 327.79 Ranier Calimlim Utility Refund - 1518 Lowden Ln 41.00 RHW Customized Graphics & Promotions Hats 4,304.40 Uniform Expense 477.45 Robinson Engineering, Ltd. Water Main 421156.25 RST Inc. Uniforms & Clothing - Supplies 180.00 Roman Szulyk Utility Refund - 315 Prairie Ave 185.47 Schroeder & Schroeder Inc. Sidewalk Repairs 28,885.38 State Industrial Products Corporation Water System Treatment Chemicals 500.00 Water System Treatment Chemicals 250.00 Steiner Electric Company Electrical Parts and Supplies 286.98 Stickels, Matthew R. Uniforms & Clothing - Supplies 167.35 Page 7 of 12 VILLAGE OF MOUNT PROSPECT List of Bills May 1, 2019 - May 14, 2019 Fund Vendor Name Invoice Description Amount 050 Water and Sewer Fund (continued) Suburban Laboratories, Inc. Water Sample Testing 2,120.00 Tank Industry Consultants, Inc. Professional Services 41700.00 UniFirst Corporation Uniforms and Clothing -Cleaning 225.07 Uniforms and Clothing -Cleaning 212.96 Uniforms and Clothing -Cleaning 243.37 Verizon Wireless Services LLC Cellular Service & Equipment Charges 4/20/19 - 5/19/19 683.42 Village of Mount Prospect Flex - Medical 620.19 Visu-sewer of Illinois, LLC. Sewer System Repair Services 3,400.00 W. W. Grainger, Inc. Maintenance and repair supplies 97.76 Warehouse Direct Office Supplies 68.16 Office Supplies 39.37 Office Supplies 19.64 Office Supplies 19.64 Office Supplies 111.84 Office Supplies (19.64) Water Environment Federation Training - Fees 232.00 Whitescarver Consulting Training - Fees 774.00 Ziebell Water Service Products Hydrant Repair Supplies and Materials 436.00 050 Water and Sewer Fund Total $ 419,570.34 051 Village Parking System Fund ACS State & Local Government Solutions Illinois State Disbursement Unit $ 23.96 Eldredge, Candace Garnishment 19.62 ICMA Retirement Trust - 457 ICMA 457 3.62 Illinois Department of Revenue IL State Withholding 53.34 IMRF IMRF EFT April 2019 353.24 Internal Revenue Service Federal Withholding 318.96 International Union of Operating Engineers IUOE PW Membership Dues 8.90 Nationwide Mutual Insurance Company Nationwide 457 4.50 NCPERS Group Life Ins. IMRF Life Insurance 5.60 Panzarino, Frank Refund Easy Park Pass - Maple St Lot (#178) 40.00 Parkeon Whoosh Transaction - March 2019 276.85 Petty Cash Petty Cash - April 2019 2.00 Traffic and Parking Control Co, Inc. Professional Services 138.84 Village of Mount Prospect Flex - Medical 30.79 051 Village Parking System Fund Total $ 1,280.22 052 Parking System Revenue Fund ACS State & Local Government Solutions Illinois State Disbursement Unit $ 24.06 Constellation NewEnergy, Inc. Electricity - Streetlights 496.49 Eldredge, Candace Garnishment 19.68 ICMA Retirement Trust - 457 ICMA 457 3.63 Illinois Department of Revenue IL State Withholding 49.55 IMRF IMRF EFT April 2019 323.30 Internal Revenue Service Federal Withholding 297.88 International Union of Operating Engineers IUOE PW Membership Dues 8.95 Nationwide Mutual Insurance Company Nationwide 457 4.51 NCPERS Group Life Ins. IMRF Life Insurance 4.80 NICOR Natural Gas 11 E Northwest Hwy 143.70 Parkeon Whoosh Transaction - March 2019 108.15 Traffic and Parking Control Co, Inc. Professional Services 381.16 Village of Mount Prospect Flex - Medical 25.25 052 Parking System Revenue Fund Total $ 1,891.11 060 Vehicle Maintenance Fund Abbott Rubber Co., Inc. Parts and Supplies $ 169.44 Arlington Power Equipment Parts and Supplies 365.10 Bamjak Inc., Vehicle Maintenance Supplies 82.62 Page 8 of 12 VILLAGE OF MOUNT PROSPECT List of Bills May 1, 2019 - May 14, 2019 Fund Vendor Name Invoice Description Amount 060 Vehicle Maintenance Fund (continued) Bamjak Inc. (continued) Vehicle Maintenance Supplies 25.10 Vehicle Maintenance Supplies 150.26 Vehicle Maintenance Supplies 63.98 Vehicle Maintenance Supplies 54.00 Parts and Supplies (140.36) Vehicle Maintenance Supplies 50.90 Equipment Maintenance 217.95 Vehicle Maintenance Supplies 29.28 Vehicle Maintenance Supplies 64.51 Vehicle Maintenance Supplies 44.38 Vehicle Maintenance Supplies 50.94 Vehicle Maintenance Supplies 32.88 Bonnell Industries Inc. Parts and Supplies 414.75 Breitzman, James Equipment Maintenance 150.00 Equipment Maintenance 235.00 Busse Car Wash, Inc. Equipment Maintenance 50.00 Equipment Maintenance 160.00 Equipment Maintenance 45.00 Castle Chevrolet North LLC Vehicle Maintenance Supplies 104.63 Chicago Parts & Sound LLC Vehicle Maintenance Supplies 116.04 Vehicle Maintenance Supplies 54.40 Vehicle Maintenance Supplies 263.68 Vehicle Maintenance Supplies 33.89 Vehicle Maintenance Supplies 131.97 Vehicle Maintenance Supplies 315.48 Dave & Jim's Auto Body, Inc. Equipment Maintenance 541.20 Dultmeier Sales Davenport Inc. Parts and Supplies 422.40 Elliott Auto Supply Co, Inc. Parts and Supplies (107.70) Parts and Supplies 107.70 Parts and Supplies 177.09 Friberg, Daniel Education and Training 122.00 Fuller's Car Wash of Des Plaines Equipment Maintenance 424.00 Equipment Maintenance 345.00 Gas Depot, Inc. Gasoline/Diesel Fuel 20,789.30 Global Emergency Products Vehicle Maintenance Supplies 318.59 Vehicle Maintenance Supplies 117.95 Vehicle Maintenance Supplies 562.78 Vehicle Maintenance Supplies 232.49 Vehicle Maintenance Supplies 100.68 Vehicle Maintenance Supplies 101.49 Equipment Maintenance 146.86 Hotsy of Chicago, Inc. Equipment Maintenance 120.00 ICMA Retirement Trust - 457 ICMA 457 21201.52 Identifix Inc. Vehicle Equipment, Supplies & Services 11428.00 Illinois Department of Revenue IL State Withholding 1,543.00 IMRF IMRF EFT April 2019 8,933.46 Internal Revenue Service Federal Withholding 9,076.77 International Union of Operating Engineers IUOE PW Membership Dues 574.76 Interstate Battery of Western Chicago Vehicle Maintenance Supplies 267.90 Just Tires Parts and Supplies 220.00 Vehicle Maintenance 11106.32 Parts and Supplies 1,583.76 Parts and Supplies 11735.20 Parts and Supplies (1,735.20) Parts and Supplies 1,688.88 Kaman Fluid Power LLC Parts and Supplies 234.24 Leach Enterprises, Inc. Parts and Supplies 143.00 Parts and Supplies 43.72 Page 9 of 12 VILLAGE OF MOUNT PROSPECT List of Bills May 1, 2019 - May 14, 2019 Fund Vendor Name Invoice Description Amount 060 Vehicle Maintenance Fund (continued) Liebovich Bros, Inc. Parts and Supplies 429.26 Parts and Supplies 288.88 Lund Industries, Inc. Parts and Supplies 72.40 Mcmaster-carr Supply Co. Vehicle Maintenance Supplies 29.44 Vehicle Maintenance Supplies 176.08 Vehicle Maintenance Supplies 82.11 Vehicle Maintenance Supplies 27.47 Vehicle Maintenance Supplies 67.13 Parts and Supplies 115.31 Parts and Supplies 154.18 Vehicle Maintenance Supplies 284.31 Vehicle Maintenance Supplies 179.53 Menard Inc. Parts and Supplies 361.26 Parts and Supplies 36.08 Morton Grove Automotive Vehicle Maintenance 1,850.00 Municipal Fleet Managers Association Education and Training 75.00 Education and Training 75.00 Education and Training 75.00 NCH Corporation Parts and Supplies 365.73 Parts and Supplies 126.61 NCPERS Group Life Ins. IMRF Life Insurance 59.20 Overhead Material Handling II., Inc. Equipment Maintenance Repair Services 435.00 Patlin Incorporated Vehicle Maintenance Supplies 460.26 Pomp's Tire Service, Inc. Parts and Supplies 934.02 Parts and Supplies 193.34 Parts and Supplies 1,692.00 Power Equipment Leasing Co Equipment Maintenance Repair Services 670.00 Ronco Industrial Supply Parts and Supplies 17.29 Parts and Supplies 36.84 Parts and Supplies 47.32 Parts and Supplies 422.08 Parts and Supplies 463.88 Rush Truck Centers of Illinois, Inc. Parts and Supplies 1,330.00 Parts and Supplies 101.88 Parts and Supplies 480.87 Parts and Supplies (63.84) Parts and Supplies 1,421.75 Parts and Supplies 350.00 Parts and Supplies 315.00 Parts and Supplies 120.00 Russo Hardware, Inc. Parts and Supplies 89.00 Parts and Supplies 31.69 Sauber Mfg. Co. Parts and Supplies 138.64 Schnittker, John Equipment Maintenance 60.00 Solvent Systems Int'I. Inc. Maintenance and repair supplies 300.00 Spring Align of Palatine, Inc. Parts and Supplies 1,018.08 Suburban Accents Inc. Equipment Maintenance 45.00 Terrace Supply Company Equipment Rental 23.70 Equipment Rental 3.60 Parts and Supplies 10.10 Equipment Rental 197.72 Parts and Supplies 21.90 Parts and Supplies 202.68 Triangle Radiator Service Inc. Parts and Supplies 549.00 Uline Inc. Parts and Supplies 433.81 Verizon Wireless Services LLC Cellular Service & Equipment Charges 4/20/19 - 5/19/19 347.78 Village of Mount Prospect Flex - Medical 302.51 W. W. Grainger, Inc. Parts and Supplies 455.52 Page 10 of 12 Fund Vendor Name VILLAGE OF MOUNT PROSPECT List of Bills May 1, 2019 - May 14, 2019 Invoice Description 060 Vehicle Maintenance Fund (continued) West Side Tractor Sales Equipment maintenance supplies Vehicle Maintenance Supplies Parts and Supplies Parts and Supplies Wholesale Direct Inc. Parts and Supplies 060 Vehicle Maintenance Fund Total 061 Vehicle Replacement Fund Bamjak Inc., Vehicle Equipment, Supplies & Services GovDeals, Inc. Vehicle Equipment, Supplies & Services JX Enterprises Inc. New Vehicles 061 Vehicle Replacement Fund Total 063 Risk Management Fund International Union of Operating Engineers PW Insurance Premiums - June 2019 Kast, Ryan Reimbursement for Wellness Lunch & Learn- Eat Well, Be Well Morrow Brothers Ford, Inc. 2019 Ford Police Interceptor (Replacing P-15) 063 Risk Management Fund Total 073 Escrow Deposit Fund 249 Prospect LLC Refund Escrow Permit # CB18-0317 (249 E Prospect Ave #B) ABC Plumbing & Heating Refund Escrow Permit # RB18-2039 (1809 Apache Ln) Refund Escrow Permit # RB18-2086 (RB18-2086) Accurate Paving Refund Escrow Permit # RB19-0347 (1925 Yuma Ln) Affordable Tuckpointing Refund Escrow Permit # RB19-0399 (505 Carol Ln) American National Sprinkler Refund Escrow Permit # RB18-1133 (202 E Berkshire Ln) ARS of Illinois Refund Escrow Permit # RB18-1207 (114 S Louis St) Refund Escrow Permit # RB18-1357 (413 Hi Lusi Ave) Barkan, Julio Refund Escrow Permit # RB19-0285 (547 Ida Ct) BC Concrete and Construction Refund Escrow Permit # 19-0416 (243 Hatlen Ave) Biezychudek, Mark Refund Escrow Permit # RB18-1355 (212 S Elmhurst Ave) Capps Plumbing & Sewer Refund Escrow Permit # RB19-0512 (910 Ironwood Dr) Cassata, Rosario Refund Escrow Permit # RB19-0258 (414 1 Oka Ave) Castellucci, Angelo Refund Escrow Permit # RB19-0391 (302 Eric Ct) Cross Town Electric Inc. Refund Escrow Permit # CB19-0139 (2316 Terminal Dr) David's Chain O' Lakes Roofing Corp Refund Escrow Permit # CB19-0106 (926 Boxwood Dr #A) Desmond Landscaping Refund Escrow Permit # RB19-0178 (420 N Maple St) Drains Inc. Refund Escrow Permit # RB19-0465 (103 S Louis St) DZI Construction Services Inc. Refund Escrow Permit # CB19-0014 (990 Mt Prospect Plz) Fortis Concrete Refund Escrow Permit # RB18-1931 (605 Fairview Ave) Four Seasons Heating and A/C Refund Escrow Permit # RB19-0396 (802 Greenwood Dr) Greco Electric Inc. Refund Escrow Permit # CB18-0248 (100 S Emerson St #P63) Gutierrez, David Refund Escrow Permit # RB19-0237 (710 S Na Wa Ta Ave) Ibbotson Heating Company Refund Escrow Permit # RB19-0164 (605 See Gwun Ave) J & S Plumbing Inc. Refund Escrow Permit # RB19-0339 (311 N Emerson St) JK Rem and Painting Services Refund Escrow Permit # RB19-0084 (700 E Busse Ave) JRC Design Build Inc. Refund Escrow Permit # RB18-1922 (201 S Edward St) K & K Concrete Refund Escrow Permit # RB18-1890 (1910 Yuma Ln) Kaempfer, Richard Refund Escrow Permit # RB18-1102 (303 N Elmhurst Ave) Konzak, Ann Refund Escrow Permit #RB19-0127 (2834 Briarwood Dr) Martini, Jeffrey Refund Escrow Permit # RB18-0210 (408 Walnut St) Matthews, Shabin Refund Escrow Permit # CB19-0022 (1746 W Golf Rd) Mayer, Matthew J Refund Escrow Permit # RB19-0036 (702 N Wille St) Norb & Sons Electric Inc. Refund Escrow Permit # RB19-0203 (204 N Kenilworth Ave) Refund Escrow Permit # RB19-0369 (910 Whitegate Dr) Oreluk, Mary Refund Escrow Permit # RB19-0144 (1418 Birch Dr) Penco Electric Inc. Refund Escrow Permit # RB19-0315 (115 Forest Ave) Portanova, Santina Refund Escrow Permit # RB19-0390 (300 Eric Ct) Page 11 of 12 Amount 10,804.00 355.06 279.26 97.93 214.51 $ 87,242.14 $ 63.68 480.25 90,585.00 $ 91,128.93 $ 66,150.00 145.07 32,315.00 $ 98,610.07 125.00 50.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 150.00 100.00 100.00 100.00 125.00 125.00 100.00 100.00 300.00 100.00 100.00 125.00 100.00 100.00 100.00 100.00 100.00 100.00 225.00 100.00 125.00 350.00 150.00 100.00 100.00 100.00 100.00 100.00 VILLAGE OF MOUNT PROSPECT List of Bills May 1, 2019 - May 14, 2019 Fund Vendor Name Invoice Description Amount 073 Escrow Deposit Fund (continued) Radzak, Richard Rick's Sewer & Drainage Rodriguez, Santos Rossi, Margaret Rustic Wood Fence St. Paul Lutheran School Taylor, Scott The Real Seal LLC Third District Circuit Court TM Concrete Topolewski, Michael Total Paving and Brick Services Inc. Two Eagle Distillery LLC Unique Seal and Brick Waldron Construction LLC Weir, Mark 073 Escrow Deposit Fund Total Grand Total Refund Escrow Permit # RB19-0446 (1611 Ironwood Dr) Refund Escrow Permit # RB19-0238 (200 N Pine St) Refund Escrow Permit # RB19-0485 (411 S Pine St) Refund Escrow Permit # RB19-0206 (1009 S Lancaster Ave) Refund Escrow Permit # RB19-0239 (504 E Berkshire Ln) Refund Escrow Permit # RB18-1557 (1504 Ironwood Dr) Refund Escrow Permit # RB18-2095 (21 N Pine St) Refund Escrow Permit # CB18-0131 (18 S School St) Refund Escrow Permit # RB19-0108 (250 Parliament PI #215) Refund Escrow Permit # 18-1339 (1809 Magnolia Ln) Bond Check 5/2/19 Bond Check 5/9/19 Bond Check 5/14/19 Refund Escrow Permit # RB19-0277 (1808 Bonita Ave) Refund Escrow Permit # RB18-1709 (515 S William St) Refund Escrow Permit # CB19-0104 (838 Partridge Ln) Refund Escrow Permit # CB18-0342 (1852 S Elmhurst Rd) Refund Escrow Permit # RB18-1128 (9 N Owen St) Refund Escrow Permit # CB18-0301 (1902 S Elmhurst Rd) Refund Escrow Permit # RB19-0333 (22 S Owen St) Page 12 of 12 100.00 100.00 100.00 100.00 100.00 100.00 100.00 125.00 100.00 100.00 375.00 300.00 610.00 100.00 100.00 100.00 200.00 100.00 350.00 inn nn :> /,y1U.UU it 7 :tn? 1 nQ AR