Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
5.1 Monthly Financial Report - May 2018
BoardDocs® ProPage 1 of 2 Agenda Item Details MeetingJun 19, 2018 - REGULAR MEETING OF THE MOUNT PROSPECT VILLAGE BOARD - 7:00 p.m. Category5. CONSENT AGENDA Subject5.1 Monthly Financial Report - May 2018 AccessPublic TypeAction (Consent) Preferred DateJun 19, 2018 Absolute DateJun 19, 2018 Fiscal ImpactNo BudgetedNo Recommended ActionAccept the monthly financial report for May 2018. Public Content Information The monthly financial report contains a Cash Position Report and Fund Financials for the month ended May 31, 2018. Alternatives 1. Accept the monthly financial report for May 2018. 2. Action at discretion of Village Board. Staff Recommendation Staff recommends the Village Board accept the monthly financial report for May 31, 2018. 05 May Board Reports for Upload_.pdf (559 KB)Combined Financials for BD 531--18.pdf (765 KB) Administrative Content https://www.boarddocs.com/il/vomp/Board.nsf/Private?open&login6/21/2018 BoardDocs® ProPage 2 of 2 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 Accept the monthly financial report for May 2018. Motion by Richard Rogers, second by Michael Zadel. Final Resolution: Motion Fails Not Present at Vote: William Grossi, Eleni Hatzis, Paul Hoefert, Richard Rogers, Colleen Saccotelli, Michael Zadel https://www.boarddocs.com/il/vomp/Board.nsf/Private?open&login6/21/2018 8 1 20 , 1 3 & May 1 May BUDGET REVENUE EXPENDITURE SUMMARIES VILLAGE OF MOUNT PROSPECT .00 60,489.3471,819.16 609,826.50372,881.52161,941.10181,262.59 8,696,101.481,987,265.144,345,452.08 Prior Year YTD $16,487,038.91$16,487,038.91 5431424226345843 126 44% +++ Rec'd Summary Listing % Used/ Through 05/31/18 .00 85,360.01 822,482.55962,309.48287,781.87125,643.41 (66,252.51) Transactions 7,591,725.185,668,368.54 Budget - YTD 14,395,817.73 $29,873,236.26$29,873,236.26 .00 YTD Prior Fiscal Year Activity Included 93,256.59 594,517.45342,690.52149,218.13119,639.99317,752.51 Transactions 8,948,274.822,541,631.46 10,488,042.27 $23,595,023.74$23,595,023.74 .00.00.00.00.00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00 89,366.3198,567.4095,441.7332,425.0548,779.7715,395.6935,292.79 688,217.98 Transactions 4,927,767.24 Current Month$6,031,253.96$6,031,253.96 Њ .00 Budget Amended 437,000.00205,000.00218,900.00251,500.00 8,210,000.001,417,000.001,305,000.00 16,540,000.0024,883,860.00 $53,468,260.00$53,468,260.00 .00.00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00 Revenue Budget by Account Classification Report Budget Adopted 437,000.00205,000.00218,900.00251,500.00 8,210,000.001,417,000.001,305,000.00 16,540,000.0024,883,860.00 $53,468,260.00$53,468,260.00 Totals REVENUE TOTALS 001 - General Fund Fund 001 - General Fund REVENUE Account ClassificationFundProperty TaxesOther TaxesLicenses, Permits & FeesIntergovernmental RevenueCharges For ServicesFines & ForfeitsInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00.00 295.12 131,555.56101,825.00 1,247,483.54 $1,481,159.22$1,481,159.22 Prior Year YTD 7 4920 154 29% ++++++ Rec'd Summary Listing % Used/ Through 05/31/18 .00.00 (544.01) 812,039.43 Transactions 1,218,241.631,508,161.63 Budget - YTD $3,537,898.68$3,537,898.68 .00.00 YTD Prior Fiscal Year Activity Included 1,544.01 200,478.57109,988.37 Transactions 1,161,758.37 $1,473,769.32$1,473,769.32 .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00 8,531.34 109,461.20 $117,992.54$117,992.54 Transactions Current Month Ћ .00.00 Budget 1,000.00 Amended 2,380,000.001,012,518.001,618,150.00 $5,011,668.00$5,011,668.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Revenue Budget by Account Classification Report Budget Adopted 1,000.00 2,380,000.001,012,518.001,618,150.00 $5,011,668.00$5,011,668.00 Totals REVENUE TOTALS 002 - Debt Service Fund Fund 002 - Debt Service Fund REVENUE Account ClassificationFundProperty TaxesOther TaxesIntergovernmental RevenueInvestment IncomeOther RevenueOther Financing Sources .00.00.00.00 2,043.38 184,815.97 $186,859.35$186,859.35 Prior Year YTD 00 20 610 13% ++++++ Rec'd Summary Listing % Used/ Through 05/31/18 .00.00 10,000.00 (5,095.22) 750,000.00 Transactions 1,042,600.00 Budget - YTD $1,797,504.78$1,797,504.78 .00.00.00.00 YTD Prior Fiscal Year Activity Included 6,095.22 257,400.00 $263,495.22$263,495.22 Transactions .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00.00 151.90 $151.90$151.90 Transactions Current Month Ќ .00.00 Budget 1,000.00 Amended 10,000.00 750,000.00 1,300,000.00 $2,061,000.00$2,061,000.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Revenue Budget by Account Classification Report Budget Adopted 1,000.00 10,000.00 750,000.00 1,300,000.00 $2,061,000.00$2,061,000.00 Totals REVENUE TOTALS 020 - Capital Improvement Fund Fund 020 - Capital Improvement Fund REVENUE Account ClassificationFundOther TaxesIntergovernmental RevenueInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00.00.00.00 716.27 18,587.43 406,290.49 1,471,062.00 $1,896,656.19$1,896,656.19 Prior Year YTD 258952 587 58% ++++++++++++ Rec'd Summary Listing % Used/ Through 05/31/18 .00.00.00.00 951.11 183,843.00 Transactions (146,123.30) 1,490,078.23 Budget - YTD $1,528,749.04$1,528,749.04 .00.00.00.00 YTD Prior Fiscal Year Activity Included 1,048.89 489,921.77176,123.30 Transactions 1,466,157.00 $2,133,250.96$2,133,250.96 .00.00.00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00.00 58,434.3911,740.75 112,568.00 $182,743.14$182,743.14 Transactions Current Month Ѝ .00.00.00.00 Budget 2,000.00 Amended 30,000.00 1,980,000.001,650,000.00 $3,662,000.00$3,662,000.00 .00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00.00 Revenue Budget by Account Classification Report Budget Adopted 2,000.00 30,000.00 1,980,000.001,650,000.00 $3,662,000.00$3,662,000.00 Totals REVENUE TOTALS 023 - Street Improvement Construc Fund 023 - Street Improvement Construc Fund Fund REVENUE Account ClassificationFundOther TaxesLicenses, Permits & FeesIntergovernmental RevenueFines & ForfeitsInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00.00 3,477.002,338.99 53,260.4014,823.50 $73,899.89$73,899.89 Prior Year YTD 90 2080 19% ++++++ Rec'd Summary Listing % Used/ Through 05/31/18 .00.00 1,194.16 22,630.0020,000.00 230,976.00 $274,800.16$274,800.16 Transactions Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included 2,370.004,805.84 57,024.00 $64,199.84$64,199.84 Transactions .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00.00 565.00 $565.00$565.00 Transactions Current Month Ў .00.00 Budget 6,000.00 Amended 25,000.0020,000.00 288,000.00 $339,000.00$339,000.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Revenue Budget by Account Classification Report Budget Adopted 6,000.00 25,000.0020,000.00 288,000.00 $339,000.00$339,000.00 Totals REVENUE TOTALS 024 - Flood Control Construction Fund Fund 024 - Flood Control Construction Fund REVENUE Account ClassificationFundOther TaxesIntergovernmental RevenueCharges For ServicesInvestment IncomeReimbursementsOther Financing Sources .00.00 1,612.72 16,873.7651,709.82 1,590,778.72 $1,660,975.02$1,660,975.02 Prior Year YTD 0 38347043 39% +++ Rec'd Summary Listing % Used/ Through 05/31/18 .00 1,180.681,000.00 30,315.8562,771.14 Transactions 2,571,346.87 Budget - YTD $2,666,614.54$2,666,614.54 .00.00 YTD Prior Fiscal Year Activity Included 2,819.32 15,684.1548,228.86 Transactions 1,603,653.13 $1,670,385.46$1,670,385.46 .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00 64.17 2,178.53 20,019.96 280,488.41 $302,751.07$302,751.07 Transactions Current Month Џ .00 Budget 4,000.001,000.00 Amended 46,000.00 111,000.00 4,175,000.00 $4,337,000.00$4,337,000.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00 Revenue Budget by Account Classification Report Budget Adopted 4,000.001,000.00 46,000.00 111,000.00 4,175,000.00 $4,337,000.00$4,337,000.00 Totals REVENUE TOTALS 040 - Refuse Disposal Fund Fund 040 - Refuse Disposal Fund REVENUE Account ClassificationFundProperty TaxesCharges For ServicesFines & ForfeitsInvestment IncomeReimbursementsOther Revenue .00 4,357.693,561.68 456,515.36 $464,434.73$464,434.73 Prior Year YTD 3338 177 33% +++ Rec'd Summary Listing % Used/ Through 05/31/18 .00 9,297.90 (3,867.14) 937,053.16 $942,483.92$942,483.92 Transactions Budget - YTD .00 YTD Prior Fiscal Year Activity Included 8,867.145,702.10 457,946.84 $472,516.08$472,516.08 Transactions .00.00.00.00 YTD $0.00$0.00 Encumbrances .00 113.15 4,747.77 124,002.71 $128,863.63$128,863.63 Transactions Current Month А .00 Budget 5,000.00 Amended 15,000.00 1,395,000.00 $1,415,000.00$1,415,000.00 .00.00.00.00 $0.00$0.00 Budget Amendments .00 Revenue Budget by Account Classification Report Budget Adopted 5,000.00 15,000.00 1,395,000.00 $1,415,000.00$1,415,000.00 Totals REVENUE TOTALS 041 - Motor Fuel Tax Fund Fund 041 - Motor Fuel Tax Fund REVENUE Account ClassificationFundIntergovernmental RevenueInvestment IncomeReimbursementsOther Revenue .00 41,556.0346,568.94 $88,124.97$88,124.97 Prior Year YTD 0 42 6% +++ Rec'd Summary Listing % Used/ Through 05/31/18 .00 35,000.00 378,666.00 $413,666.00$413,666.00 Transactions Budget - YTD .00.00 YTD Prior Fiscal Year Activity Included 25,000.00 $25,000.00$25,000.00 Transactions .00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00 $0.00$0.00 Transactions Current Month Б .00 Budget Amended 60,000.00 378,666.00 $438,666.00$438,666.00 .00.00.00 $0.00$0.00 Budget Amendments .00 Revenue Budget by Account Classification Report Budget Adopted 60,000.00 378,666.00 $438,666.00$438,666.00 Totals REVENUE TOTALS 042 - CDBG Fund 042 - CDBG REVENUE Account ClassificationFundIntergovernmental RevenueInvestment IncomeOther Revenue 347.13219.39 $566.52$566.52 Prior Year YTD 9396 93% Rec'd Summary Listing % Used/ Through 05/31/18 21.51 456.88 $478.39$478.39 Transactions Budget - YTD YTD Prior Fiscal Year Activity Included 478.49 6,043.12 $6,521.61$6,521.61 Transactions .00.00 YTD $0.00$0.00 Encumbrances 5.89 (196.00) ($190.11)($190.11) Transactions Current Month В 500.00 Budget 6,500.00 Amended $7,000.00$7,000.00 .00.00 $0.00$0.00 Budget Amendments Revenue Budget by Account Classification Report 500.00 Budget Adopted 6,500.00 $7,000.00$7,000.00 Totals REVENUE TOTALS 043 - Asset Seizure Fund Fund 043 - Asset Seizure Fund REVENUE Account ClassificationFundFines & ForfeitsInvestment Income .00 56.12 $56.12$56.12 Prior Year YTD 0 29 3% Rec'd Summary Listing % Used/ Through 05/31/18 141.55 1,800.00 $1,941.55$1,941.55 Transactions Budget - YTD .00 YTD Prior Fiscal Year Activity Included 58.45 $58.45$58.45 Transactions .00.00 YTD $0.00$0.00 Encumbrances .00 6.53 $6.53$6.53 Transactions Current Month ЊЉ 200.00 Budget 1,800.00 Amended $2,000.00$2,000.00 .00.00 $0.00$0.00 Budget Amendments Revenue Budget by Account Classification Report 200.00 Budget Adopted 1,800.00 $2,000.00$2,000.00 Totals REVENUE TOTALS 044 - Federal Equitable Share Funds Fund 044 - Federal Equitable Share Funds REVENUE Account ClassificationFundFines & ForfeitsInvestment Income 156.71 4,452.27 $4,608.98$4,608.98 Prior Year YTD 9 32 9% Rec'd Summary Listing % Used/ Through 05/31/18 341.32 22,835.48 $23,176.80$23,176.80 Transactions Budget - YTD YTD Prior Fiscal Year Activity Included 158.68 2,164.52 $2,323.20$2,323.20 Transactions .00.00 YTD $0.00$0.00 Encumbrances 17.98 611.06 $629.04$629.04 Transactions Current Month ЊЊ 500.00 Budget Amended 25,000.00 $25,500.00$25,500.00 .00.00 $0.00$0.00 Budget Amendments Revenue Budget by Account Classification Report 500.00 Budget Adopted 25,000.00 $25,500.00$25,500.00 Totals REVENUE TOTALS 045 - DUI Fine Fund Fund 045 - DUI Fine Fund REVENUE Account ClassificationFundFines & ForfeitsInvestment Income .00.00 593.72 10,322.57 $10,916.29$10,916.29 Prior Year YTD 0 56 1% ++++++ Rec'd Summary Listing % Used/ Through 05/31/18 .00.00 883.13 90,000.00 $90,883.13$90,883.13 Transactions Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included 1,116.87 $1,116.87$1,116.87 Transactions .00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00 31.62 $31.62$31.62 Transactions Current Month ЊЋ .00.00 Budget 2,000.00 Amended 90,000.00 $92,000.00$92,000.00 .00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Revenue Budget by Account Classification Report Budget Adopted 2,000.00 90,000.00 $92,000.00$92,000.00 Totals REVENUE TOTALS 046 - Foreign Fire Tax Board Fund Fund 046 - Foreign Fire Tax Board Fund REVENUE Account ClassificationFundOther TaxesInvestment IncomeOther RevenueOther Financing Sources .00 2,232.26 244,589.98237,500.00 $484,322.24$484,322.24 Prior Year YTD 2340 135 28% +++ Rec'd Summary Listing % Used/ Through 05/31/18 .00 (1,052.71) 846,641.03249,900.00 Transactions Budget - YTD $1,095,488.32$1,095,488.32 .00 YTD Prior Fiscal Year Activity Included 4,052.71 253,358.97170,100.00 $427,511.68$427,511.68 Transactions .00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00 76,260.5894,500.00 $170,760.58$170,760.58 Transactions Current Month ЊЌ .00 Budget 3,000.00 Amended 420,000.00 1,100,000.00 $1,523,000.00$1,523,000.00 .00.00.00.00 $0.00$0.00 Budget Amendments .00 Revenue Budget by Account Classification Report Budget Adopted 3,000.00 420,000.00 1,100,000.00 $1,523,000.00$1,523,000.00 Totals REVENUE TOTALS 048 - Business District Fund Fund 048 - Business District Fund REVENUE Account ClassificationFundOther TaxesIntergovernmental RevenueInvestment IncomeOther Financing Sources .00.00.00 $0.00$0.00 Prior Year YTD 0 457 +++ Rec'd 396% Summary Listing % Used/ Through 05/31/18 253,953.00 (29,527.44) Transactions Budget - YTD (5,718,879.30) ($5,494,453.74)($5,494,453.74) .00 YTD Prior Fiscal Year Activity Included 29,527.44 Transactions 7,318,879.30 $7,348,406.74$7,348,406.74 .00.00.00 YTD $0.00$0.00 Encumbrances .00 6,835.65 Transactions 7,176,093.70 Current Month$7,182,929.35$7,182,929.35 ЊЍ .00 Budget Amended 253,953.00 1,600,000.00 $1,853,953.00$1,853,953.00 .00.00.00 $0.00$0.00 Budget Amendments .00 Revenue Budget by Account Classification Report Budget Adopted 253,953.00 1,600,000.00 $1,853,953.00$1,853,953.00 Totals REVENUE TOTALS 049 - Prospect and Main TIF District Fund 049 - Prospect and Main TIF District REVENUE Account ClassificationFundProperty TaxesInvestment IncomeOther Financing Sources .00 200.00 8,800.006,955.62 39,073.3330,381.50 (1,019.59) 5,071,576.59 $5,155,967.45$5,155,967.45 Prior Year YTD 0 47383329 290 28% ++++++ Rec'd Summary Listing % Used/ Through 05/31/18 .00 284.93 10,590.0086,474.1856,538.01 (30,541.47) Transactions 8,962,156.885,000,000.00 Budget - YTD $14,085,502.53$14,085,502.53 .00.00 YTD Prior Fiscal Year Activity Included (284.93) 9,410.00 43,525.8246,641.4723,461.99 Transactions 5,482,043.12 $5,604,797.47$5,604,797.47 .00.00.00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00 2,239.651,720.009,381.265,296.99 15,411.64 (98,814.40) Transactions 1,115,293.22 Current Month$1,050,528.36$1,050,528.36 ЊЎ .00.00 Budget Amended 20,000.0016,100.0080,000.00 130,000.00 5,000,000.00 14,444,200.00 $19,690,300.00$19,690,300.00 .00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Revenue Budget by Account Classification Report Budget Adopted 20,000.0016,100.0080,000.00 130,000.00 5,000,000.00 14,444,200.00 $19,690,300.00$19,690,300.00 Totals REVENUE TOTALS 050 - Water and Sewer Fund Fund 050 - Water and Sewer Fund REVENUE Account ClassificationFundProperty TaxesLicenses, Permits & FeesCharges For ServicesFines & ForfeitsInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00.00 499.15 1,307.60 87,075.05 $88,881.80$88,881.80 Prior Year YTD 4339 105 43% ++++++ Rec'd Summary Listing % Used/ Through 05/31/18 .00.00 (50.15) 1,827.50 111,205.00 $112,982.35$112,982.35 Transactions Budget - YTD .00.00 YTD Prior Fiscal Year Activity Included 1,050.151,172.50 82,395.00 $84,617.65$84,617.65 Transactions .00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00 24.80 261.10 15,397.55 $15,683.45$15,683.45 Transactions Current Month ЊЏ .00.00 Budget 1,000.003,000.00 Amended 193,600.00 $197,600.00$197,600.00 .00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Revenue Budget by Account Classification Report Budget Adopted 1,000.003,000.00 193,600.00 $197,600.00$197,600.00 Totals REVENUE TOTALS 051 - Village Parking System Fund Fund 051 - Village Parking System Fund REVENUE Account ClassificationFundOther TaxesCharges For ServicesInvestment IncomeOther RevenueOther Financing Sources .00.00.00 196.27600.60 64,870.35 $65,667.22$65,667.22 Prior Year YTD 428854 42% +++++++++ Rec'd Summary Listing % Used/ Through 05/31/18 .00.00.00 59.81 457.85 91,026.00 $91,543.66$91,543.66 Transactions Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included 440.19542.15 64,974.00 $65,956.34$65,956.34 Transactions .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00 92.75 13,358.40 $13,451.15$13,451.15 Transactions Current Month ЊА .00.00.00 500.00 Budget 1,000.00 Amended 156,000.00 $157,500.00$157,500.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00 Revenue Budget by Account Classification Report 500.00 Budget Adopted 1,000.00 156,000.00 $157,500.00$157,500.00 Totals REVENUE TOTALS 052 - Parking System Revenue Fund Fund 052 - Parking System Revenue Fund REVENUE Account ClassificationFundOther TaxesIntergovernmental RevenueCharges For ServicesInvestment IncomeOther RevenueOther Financing Sources .00.00 1,191.42 845,818.35 $847,009.77$847,009.77 Prior Year YTD 4262 42% ++++++ Rec'd Summary Listing % Used/ Through 05/31/18 .00.00 1,146.89 Transactions 1,190,482.50 Budget - YTD $1,191,629.39$1,191,629.39 .00.00 YTD Prior Fiscal Year Activity Included 1,853.11 850,344.50 $852,197.61$852,197.61 Transactions .00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00 35.96 170,068.90 $170,104.86$170,104.86 Transactions Current Month ЊБ .00.00 Budget 3,000.00 Amended 2,040,827.00 $2,043,827.00$2,043,827.00 .00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Revenue Budget by Account Classification Report Budget Adopted 3,000.00 2,040,827.00 $2,043,827.00$2,043,827.00 Totals REVENUE TOTALS 060 - Vehicle Maintenance Fund Fund 060 - Vehicle Maintenance Fund REVENUE Account ClassificationFundCharges For ServicesInvestment IncomeOther RevenueOther Financing Sources .00.00 3,732.00 24,568.0127,463.55 685,416.60 $741,180.16$741,180.16 Prior Year YTD 42193097 43% ++++++ Rec'd Summary Listing % Used/ Through 05/31/18 .00.00 6,486.252,049.38 34,884.89 939,925.05 $983,345.57$983,345.57 Transactions Budget - YTD .00.00 YTD Prior Fiscal Year Activity Included 1,513.75 15,115.1162,950.62 671,374.95 $750,954.43$750,954.43 Transactions .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00 693.75 12,184.2613,453.62 134,274.99 $160,606.62$160,606.62 Transactions Current Month ЊВ .00.00 Budget 8,000.00 Amended 50,000.0065,000.00 1,611,300.00 $1,734,300.00$1,734,300.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Revenue Budget by Account Classification Report Budget Adopted 8,000.00 50,000.0065,000.00 1,611,300.00 $1,734,300.00$1,734,300.00 Totals REVENUE TOTALS 061 - Vehicle Replacement Fund Fund 061 - Vehicle Replacement Fund REVENUE Account ClassificationFundCharges For ServicesFines & ForfeitsInvestment IncomeReimbursementsOther RevenueOther Financing Sources .00 756.51 100,345.45 $101,101.96$101,101.96 Prior Year YTD 42 104 42% +++ Rec'd Summary Listing % Used/ Through 05/31/18 .00 (61.00) 119,639.95 $119,578.95$119,578.95 Transactions Budget - YTD .00 YTD Prior Fiscal Year Activity Included 1,561.00 85,457.05 $87,018.05$87,018.05 Transactions .00.00.00 YTD $0.00$0.00 Encumbrances .00 22.32 17,091.41 $17,113.73$17,113.73 Transactions Current Month ЋЉ .00 Budget 1,500.00 Amended 205,097.00 $206,597.00$206,597.00 .00.00.00 $0.00$0.00 Budget Amendments .00 Revenue Budget by Account Classification Report Budget Adopted 1,500.00 205,097.00 $206,597.00$206,597.00 Totals REVENUE TOTALS 062 - Computer Replacement Fund Fund 062 - Computer Replacement Fund REVENUE Account ClassificationFundCharges For ServicesInvestment IncomeOther Financing Sources .00 4,527.21 559,227.37 2,763,508.29 $3,327,262.87$3,327,262.87 Prior Year YTD 426945 815 43% Rec'd Summary Listing % Used/ Through 05/31/18 4,042.47 (7,145.68) 874,941.09 Transactions 4,154,272.19 Budget - YTD $5,026,110.07$5,026,110.07 YTD Prior Fiscal Year Activity Included 8,957.538,145.68 707,586.91 Transactions 3,010,077.81 $3,734,767.93$3,734,767.93 .00.00.00.00 YTD $0.00$0.00 Encumbrances .00 928.75 662,940.87142,005.33 $805,874.95$805,874.95 Transactions Current Month ЋЊ Budget 1,000.00 Amended 13,000.00 7,164,350.001,582,528.00 $8,760,878.00$8,760,878.00 .00.00.00.00 $0.00$0.00 Budget Amendments Revenue Budget by Account Classification Report Budget Adopted 1,000.00 13,000.00 7,164,350.001,582,528.00 $8,760,878.00$8,760,878.00 Totals REVENUE TOTALS 063 - Risk Management Fund Fund 063 - Risk Management Fund REVENUE Account ClassificationFundCharges For ServicesInvestment IncomeReimbursementsOther Revenue .00 3,854,023.382,056,489.37 $5,910,512.75$5,910,512.75 Prior Year YTD 2049 34% +++ Rec'd Summary Listing % Used/ Through 05/31/18 .00 Transactions 4,189,011.652,288,025.09 Budget - YTD $6,477,036.74$6,477,036.74 .00 YTD Prior Fiscal Year Activity Included Transactions 1,071,988.352,196,474.91 $3,268,463.26$3,268,463.26 .00.00.00 YTD $0.00$0.00 Encumbrances .00 110,354.36 Transactions 1,221,557.96 Current Month$1,331,912.32$1,331,912.32 ЋЋ .00 Budget Amended 5,261,000.004,484,500.00 $9,745,500.00$9,745,500.00 .00.00.00 $0.00$0.00 Budget Amendments .00 Revenue Budget by Account Classification Report Budget Adopted 5,261,000.004,484,500.00 $9,745,500.00$9,745,500.00 Totals REVENUE TOTALS 070 - Police Pension Fund Fund 070 - Police Pension Fund REVENUE Account ClassificationFundCharges For ServicesInvestment IncomeOther Revenue 4,757,365.971,670,061.33 $6,427,427.30$6,427,427.30 Prior Year YTD $45,504,629.71 2344 32% Rec'd Summary Listing % Used/ Through 05/31/18 Transactions 3,919,375.922,249,284.03 Budget - YTD $6,168,659.95$6,168,659.95 $71,008,857.04 YTD Prior Fiscal Year Activity Included Transactions 1,158,624.081,790,015.97 $2,948,640.05$2,948,640.05 $54,880,991.96 .00.00 YTD $0.00$0.00$0.00 Encumbrances 89,088.98 726,814.79 $815,903.77$815,903.77 Transactions Current Month $18,499,667.46 ЋЌ Budget Amended 5,078,000.004,039,300.00 $9,117,300.00$9,117,300.00 $125,889,849.00 .00.00 $0.00$0.00$0.00 Budget Amendments Revenue Budget by Account Classification Report Budget Adopted 5,078,000.004,039,300.00 $9,117,300.00$9,117,300.00 $125,889,849.00 Totals Grand Totals REVENUE TOTALS 071 - Fire Pension Fund Fund 071 - Fire Pension Fund REVENUE Account ClassificationFundInvestment IncomeOther Revenue .00 .00 1,537.05 19,491.5058,382.0278,815.31 69,249.5759,272.86 219,226.44167,204.71242,123.77503,473.00 9,089,120.323,068,327.86 6,050,399.46 Prior Year YTD $19,626,623.87 $19,626,623.87 500 2 432215 38463942445868 41% +++ Rec'd % Used/ Summary Listing Through 05/31/18 .00 44,525.5515,439.7054,117.39 348,807.23261,711.48243,819.76426,641.06683,456.00106,112.51344,208.56750,000.00 Transactions 7,838,455.004,932,699.04 Budget - YTD 16,559,594.80 $32,609,588.08$32,609,588.08 .00.00.00 YTD Prior Fiscal Year Activity Included 388.30 2,424.459,504.61 72,344.52 191,128.07173,791.24271,003.75112,102.53120,440.84 Transactions 6,655,779.002,998,151.62 10,345,442.20 $20,952,501.13$20,952,501.13 .00.00.00.00.00.00.00.00.00 YTD 154.00 28,603.7060,260.1935,314.96 720,225.34595,788.60 Encumbrances $1,440,346.79$1,440,346.79 .00.00.00.00 484.89 5,277.64 35,533.7211,728.9934,759.6253,840.7042,603.8076,548.21 754,101.41 674,368.97 Transactions 2,909,957.18 Current Month $4,599,205.13$4,599,205.13 .00 Budget Amended 1 46,950.0015,828.0063,776.00 568,539.00334,056.00417,611.00757,905.00683,456.00253,530.00750,000.00 8,651,076.001,060,438.00 26,905,037.0014,494,234.00 $55,002,436.00$55,002,436.00 .00.00.00.00.00.00.00.00.00.00.00 Budget 3,780.009,000.00 11,800.00 162,438.00 $187,018.00$187,018.00 Amendments .00 Budget Adopted Expense Budget by Account Classification Report 46,950.0015,828.0054,776.00 568,539.00334,056.00417,611.00754,125.00683,456.00253,530.00898,000.00750,000.00 8,639,276.00 14,494,234.00 26,905,037.00 $54,815,418.00$54,815,418.00 Totals EXPENSE TOTALS 001 - General Fund Fund 001 - General Fund EXPENSE Account ClassificationFundPersonal Services, Scheduled Salaries & WagesEmployee BenefitsOther Employee CostsPension BenefitsContractual ServicesUtilitiesInsuranceCommodities & SuppliesOther ExpendituresBuilding ImprovementsOffice EquipmentOther EquipmentDistribution SystemsInfrastructureInterfund Transfers .00.00.00.00 1,230.50 93,810.21 611,894.75 $706,935.46$706,935.46 Prior Year YTD 0 47 46 12% ++++++++++++ Rec'd % Used/ Summary Listing Through 05/31/18 .00.00.00.00 3,164.50 705,554.87 Transactions 3,712,771.00 Budget - YTD $4,421,490.37$4,421,490.37 .00.00.00.00.00 YTD Prior Fiscal Year Activity Included 2,835.50 590,646.13 Transactions $593,481.63$593,481.63 .00.00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00 .00.00.00.00.00 590,646.13 Transactions$590,646.13$590,646.13 Current Month .00.00.00.00 Budget 6,000.00 Amended 2 3,712,771.001,296,201.00 $5,014,972.00$5,014,972.00 .00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00.00 Budget Adopted Expense Budget by Account Classification Report 6,000.00 3,712,771.001,296,201.00 $5,014,972.00$5,014,972.00 Totals EXPENSE TOTALS 002 - Debt Service Fund Fund 002 - Debt Service Fund EXPENSE Account ClassificationFundContractual ServicesOther ExpendituresBond PrincipalInterest ExpenseBank & Fiscal FeesInterfund TransfersOther Financing Uses .00 .00.00 5,794.09 65,663.8020,368.40 12,351.2098,735.63 108,113.95 $311,027.07 $311,027.07 Prior Year YTD 08 4019 29 18% +++ +++++++++ Rec'd % Used/ Summary Listing Through 05/31/18 .00.00.00.00 113,030.00315,000.00494,574.01294,679.06 Transactions 1,338,555.50 Budget - YTD $2,555,838.57$2,555,838.57 .00.00.00.00.00.00 YTD Prior Fiscal Year Activity Included 24,989.2210,115.50 117,567.94 Transactions $152,672.66$152,672.66 .00.00.00.00.00.00 YTD 75,000.0018,661.77 308,450.00 $402,111.77$402,111.77 Encumbrances .00 .00.00.00.00.00.00 11,827.7048,790.91 $60,618.61$60,618.61 Transactions Current Month .00.00.00.00 Budget Amended 3 188,030.00315,000.00538,225.00412,247.00 1,657,121.00 $3,110,623.00$3,110,623.00 .00.00.00.00.00 Budget 58,225.00 110,000.00115,000.00478,121.00 $761,346.00$761,346.00 Amendments .00.00.00.00 Budget Adopted Expense Budget by Account Classification Report 78,030.00 200,000.00480,000.00412,247.00 1,179,000.00 $2,349,277.00$2,349,277.00 Totals EXPENSE TOTALS 020 - Capital Improvement Fund Fund 020 - Capital Improvement Fund EXPENSE Account ClassificationFundContractual ServicesOther ExpendituresLand ImprovementsBuilding ImprovementsOffice EquipmentMotor EquipmentOther EquipmentInfrastructureInterfund Transfers .00.00.00.00 65,241.81 $65,241.81$65,241.81 Prior Year YTD 91 66 91% +++++++++ Rec'd % Used/ Summary Listing Through 05/31/18 .00.00.00 13,465.00 323,447.13 Transactions $336,912.13$336,912.13 Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included 11,430.00 194,597.36 Transactions $206,027.36$206,027.36 .00.00.00 YTD 15,105.00 3,258,955.51 Encumbrances $3,274,060.51$3,274,060.51 .00.00.00 8,430.00 159,301.05 Transactions$167,731.05$167,731.05 Current Month .00.00.00 Budget Amended 4 40,000.00 3,777,000.00 $3,817,000.00$3,817,000.00 .00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00 Budget Adopted Expense Budget by Account Classification Report 40,000.00 3,777,000.00 $3,817,000.00$3,817,000.00 Totals EXPENSE TOTALS 023 - Street Improvement Construc Fund Fund 023 - Street Improvement Construc Fund EXPENSE Account ClassificationFundContractual ServicesOther ExpendituresLand ImprovementsInfrastructureInterfund Transfers .00 .00 27.90 791.90440.00 16,111.92 (2,997.95) $14,373.77$14,373.77 Prior Year YTD 1316171927 52 44% +++ Rec'd % Used/ Summary Listing Through 05/31/18 .00 2,139.154,425.194,306.00 108,192.00114,285.00398,652.24 Transactions $631,999.58$631,999.58 Budget - YTD .00 YTD Prior Fiscal Year Activity Included 410.85880.81600.00 9,554.001,000.00 102,378.50 Transactions $114,824.16$114,824.16 .00.00.00.00 YTD 6,550.00 40,890.00 326,914.26 $374,354.26$374,354.26 Encumbrances .00 .00.00 410.85880.81600.00 31,706.99 $33,598.65$33,598.65 Transactions Current Month .00 Budget 2,550.005,306.005,306.00 Amended 5 124,296.00155,775.00 827,945.00 $1,121,178.00 $1,121,178.00 .00.00.00.00.00 Budget 53,775.00 247,445.00 $301,220.00$301,220.00 Amendments .00 Budget Adopted Expense Budget by Account Classification Report 2,550.005,306.00 5,306.00 124,296.00102,000.00580,500.00 $819,958.00$819,958.00 Totals EXPENSE TOTALS 024 - Flood Control Construction Fund Fund 024 - Flood Control Construction Fund EXPENSE Account ClassificationFundContractual ServicesUtilitiesCommodities & SuppliesOther ExpendituresOther EquipmentDistribution SystemsInfrastructure 853.44 133.71 15,179.14 84,542.0742,858.0712,303.35 1,263,677.70 $1,419,547.48$1,419,547.48 Prior Year YTD 7 15 3841381242 38% Rec'd % Used/ Summary Listing Through 05/31/18 418.64 1,225.33 70,984.1615,559.2534,652.18 166,957.07 Transactions 2,429,463.80 Budget - YTD $2,719,260.43$2,719,260.43 YTD 98.6755.36 Prior Fiscal Year Activity Included 6,110.82 48,876.8411,113.75 104,041.93 Transactions 1,463,677.20 $1,633,974.57$1,633,974.57 .00.00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00 11.13 2,222.751,882.68 28,932.6110,825.08 325,844.02 Transactions$369,718.27$369,718.27 Current Month 474.00 Budget 1,324.00 Amended 6 26,673.0040,763.00 270,999.00119,861.00 3,893,141.00 $4,353,235.00 $4,353,235.00 .00.00.00.00.00.00 Budget 5,065.00 $5,065.00$5,065.00 Amendments Budget474.00 Adopted Expense Budget by Account Classification Report 1,324.00 26,673.0040,763.00 270,999.00119,861.00 3,888,076.00 $4,348,170.00$4,348,170.00 Totals EXPENSE TOTALS 040 - Refuse Disposal Fund Fund 040 - Refuse Disposal Fund EXPENSE Account ClassificationFundPersonal Services, Scheduled Salaries & WagesEmployee BenefitsOther Employee CostsContractual ServicesUtilitiesInsuranceCommodities & Supplies .00.00 1,949.62 55,177.23 70,082.62 $127,209.47 $127,209.47 Prior Year YTD 31 656499 79% +++ Rec'd % Used/ Summary Listing Through 05/31/18 .00 9,486.50 124,738.25113,734.19125,104.55 Transactions $373,063.49$373,063.49 Budget - YTD .00 YTD Prior Fiscal Year Activity Included 51,877.81 103,057.16210,076.48752,821.50 Transactions $1,117,832.95$1,117,832.95 .00.00 YTD 14,818.97 125,315.59168,351.00 $308,485.56$308,485.56 Encumbrances .00.00 36,561.7716,347.25 750,000.00 Transactions$802,909.02$802,909.02 Current Month .00 Budget Amended 7 353,111.00165,612.00350,000.00930,659.00 $1,799,382.00$1,799,382.00 .00.00.00.00 Budget 330,659.00 $330,659.00$330,659.00 Amendments .00 Budget Adopted Expense Budget by Account Classification Report 353,111.00165,612.00350,000.00600,000.00 $1,468,723.00$1,468,723.00 Totals EXPENSE TOTALS 041 - Motor Fuel Tax Fund Fund 041 - Motor Fuel Tax Fund EXPENSE Account ClassificationFundContractual ServicesUtilitiesCommodities & SuppliesBuilding ImprovementsInfrastructure .00 .00.00.00.00 104.00 9,964.71 18,337.01 181,888.81 $210,294.53$210,294.53 Prior Year YTD 32 48 49% +++++++++ +++++++++ Rec'd % Used/ Summary Listing Through 05/31/18 .00.00.00.00 539.51 (560.59) 1,072.00 (3,045.00) 225,566.04 Transactions $223,571.96$223,571.96 Budget - YTD .00.00.00.00 YTD 32.0010.49 Prior Fiscal Year Activity Included 560.59 3,045.00 35,407.96 $39,056.04$39,056.04 Transactions .00.00.00.00.00.00.00.00 YTD 176,038.00 $176,038.00$176,038.00 Encumbrances .00 .00.00.00 32.0010.49 560.59 1,260.74 3,045.00 $4,908.82$4,908.82 Transactions Current Month .00.00.00.00.00.00 550.00 Budget 1,104.00 Amended 8 437,012.00 $438,666.00$438,666.00 .00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00.00.00.00 Budget550.00 Adopted Expense Budget by Account Classification Report 1,104.00 437,012.00 $438,666.00$438,666.00 Totals EXPENSE TOTALS 042 - CDBG Fund 042 - CDBG EXPENSE Account ClassificationFundPersonal Services, Scheduled Salaries & WagesEmployee BenefitsOther Employee CostsContractual ServicesCommodities & SuppliesOther ExpendituresLand ImprovementsBuilding ImprovementsInfrastructure .00 .00.00.00 $0.00$0.00 Prior Year YTD 0 4650 195 57% Rec'd % Used/ Summary Listing Through 05/31/18 1,000.008,391.12 12,290.90 (2,857.82) $18,824.20$18,824.20 Transactions Budget - YTD .00 YTD Prior Fiscal Year Activity Included 7,108.885,857.82 12,109.10 $25,075.80$25,075.80 Transactions .00.00.00.00 YTD $0.00$0.00 Encumbrances .00 122.00180.92 3,890.17 $4,193.09$4,193.09 Transactions Current Month Budget 1,000.003,000.00 Amended 9 15,500.0024,400.00 $43,900.00$43,900.00 .00.00.00.00 $0.00$0.00 Budget Amendments Budget Adopted Expense Budget by Account Classification Report 3,000.00 1,000.00 15,500.0024,400.00 $43,900.00 $43,900.00 Totals EXPENSE TOTALS 043 - Asset Seizure Fund Fund 043 - Asset Seizure Fund EXPENSE Account ClassificationFundOther Employee CostsContractual ServicesCommodities & SuppliesOther Equipment .00.00 .00 $0.00$0.00 Prior Year YTD 00 0% +++ Rec'd % Used/ Summary Listing Through 05/31/18 .00 1,000.001,000.00 $2,000.00$2,000.00 Transactions Budget - YTD .00.00.00 YTD $0.00$0.00 Prior Fiscal Year Activity Included Transactions .00.00.00 YTD $0.00$0.00 Encumbrances .00 .00 (539.85) ($539.85)($539.85) Transactions Current Month .00 Budget 1,000.001,000.00 Amended $2,000.00$2,000.00 10 .00.00.00 $0.00$0.00 Budget Amendments .00 Budget Adopted Expense Budget by Account Classification Report 1,000.001,000.00 $2,000.00$2,000.00 Totals EXPENSE TOTALS 044 - Federal Equitable Share Funds Fund 044 - Federal Equitable Share Funds EXPENSE Account ClassificationFundContractual ServicesBuilding ImprovementsOther Equipment .00 .00 917.23 1,540.90 $2,458.13$2,458.13 Prior Year YTD 00 67 48% +++ Rec'd % Used/ Summary Listing Through 05/31/18 .00 1,000.001,000.001,669.70 $3,669.70$3,669.70 Transactions Budget - YTD .00.00.00 YTD Prior Fiscal Year Activity Included 3,330.30 $3,330.30$3,330.30 Transactions .00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00 .00 $0.00$0.00 Transactions Current Month .00 Budget 1,000.001,000.005,000.00 Amended $7,000.00$7,000.00 11 .00.00.00 Budget 4,000.00 $4,000.00$4,000.00 Amendments .00 Budget Adopted Expense Budget by Account Classification Report 1,000.00 1,000.001,000.00 $3,000.00$3,000.00 Totals EXPENSE TOTALS 045 - DUI Fine Fund Fund 045 - DUI Fine Fund EXPENSE Account ClassificationFundOther Employee CostsContractual ServicesOther EquipmentInterfund Transfers .00 1,105.663,703.035,146.595,480.00 $15,435.28$15,435.28 Prior Year YTD 0 102229 104 29% Rec'd % Used/ Summary Listing Through 05/31/18 500.00 (179.74) 13,432.9311,691.3221,356.40 $46,800.91$46,800.91 Transactions Budget - YTD .00 YTD Prior Fiscal Year Activity Included 1,567.073,308.685,179.748,643.60 $18,699.09$18,699.09 Transactions .00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00 .00.00 1,567.075,179.74 $6,746.81$6,746.81 Transactions Current Month 500.00 Budget 5,000.00 Amended 15,000.0015,000.0030,000.00 12 $65,500.00$65,500.00 .00.00.00.00.00 $0.00$0.00 Budget Amendments Budget500.00 Adopted Expense Budget by Account Classification Report 5,000.00 15,000.0015,000.0030,000.00 $65,500.00$65,500.00 Totals EXPENSE TOTALS 046 - Foreign Fire Tax Board Fund Fund 046 - Foreign Fire Tax Board Fund EXPENSE Account ClassificationFundOther Employee CostsContractual ServicesInsuranceCommodities & SuppliesOther Equipment .00 117,021.69 $117,021.69 $117,021.69 Prior Year YTD 10 10% +++ Rec'd % Used/ Summary Listing Through 05/31/18 .00 Transactions 1,365,888.52 Budget - YTD $1,365,888.52$1,365,888.52 .00 YTD Prior Fiscal Year Activity Included 157,111.48 Transactions $157,111.48$157,111.48 .00.00 YTD $0.00$0.00 Encumbrances .00 49,111.30 $49,111.30$49,111.30 Transactions Current Month .00 Budget Amended 13 1,523,000.00 $1,523,000.00$1,523,000.00 .00.00 $0.00$0.00 Budget Amendments .00 Budget Adopted Expense Budget by Account Classification Report 1,523,000.00 $1,523,000.00 $1,523,000.00 Totals EXPENSE TOTALS 048 - Business District Fund Fund 048 - Business District Fund EXPENSE Account ClassificationFundBond PrincipalInterest Expense .00.00.00.00.00.00 .00.00 4,325.33 11,499.09 $15,824.42$15,824.42 Prior Year YTD 0000 4039 176 139 +++ +++ Rec'd 115% % Used/ Summary Listing Through 05/31/18 .00.00 900.00 1,500.00 750,000.00260,000.00710,000.00112,145.75 (70,272.88) Transactions Budget - YTD ($830,652.42)($830,652.42) (2,594,925.29) .00.00.00.00.00.00 YTD Prior Fiscal Year Activity Included 600.00 71,273.25 179,777.64 Transactions 5,927,292.29 $6,178,943.18$6,178,943.18 .00.00.00.00.00.00.00.00 YTD 71,995.2490,633.00 $162,628.24$162,628.24 Encumbrances .00.00.00 .00.00.00.00 71,273.25 149,231.40 Transactions 5,396,509.29 Current Month $5,617,013.94$5,617,013.94 .00.00 Budget 1,500.001,500.00 Amended 14 181,500.00750,000.00260,000.00710,000.00183,419.00 3,423,000.00 $5,510,919.00$5,510,919.00 .00.00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Adopted Expense Budget by Account Classification Report 1,500.001,500.00 181,500.00750,000.00260,000.00710,000.00183,419.00 3,423,000.00 $5,510,919.00$5,510,919.00 Totals EXPENSE TOTALS 049 - Prospect and Main TIF District Fund 049 - Prospect and Main TIF District EXPENSE Account ClassificationFundOther Employee CostsContractual ServicesCommodities & SuppliesOther ExpendituresLand ImprovementsBuilding ImprovementsInfrastructureBond PrincipalInterest ExpenseInterfund Transfers .00.00.00.00.00 .00.00 326.19 42,559.1295,848.70 27,043.8341,684.20 705,390.13321,307.46100,051.09177,581.82 2,672,285.71 $4,184,078.25$4,184,078.25 Prior Year YTD 900 0 413625223041 42624232 35% +++ ++++++ Rec'd % Used/ Summary Listing Through 05/31/18 .00.00.00 1,060.00 16,574.7455,382.8063,750.0010,000.00 542,353.62127,714.36255,814.72190,867.69115,000.00108,248.42 Transactions 1,375,117.745,698,534.573,893,281.00 Budget - YTD $12,453,699.66$12,453,699.66 .00.00.00.00.00.00 YTD Prior Fiscal Year Activity Included 1,450.00 25,349.7643,577.6439,559.2041,806.2351,565.3174,297.58 943,030.26386,869.38142,198.32 Transactions 2,869,764.24 $4,619,467.92$4,619,467.92 .00.00.00.00.00.00.00.00.00.00.00 YTD 1,674.504,800.00 32,348.0530,948.00 317,583.19 1,669,434.68 Encumbrances $2,056,788.42$2,056,788.42 .00.00 .00.00.00.00.00 6,575.917,911.84 89,352.6811,727.9413,514.7727,728.4088,785.0874,297.58 264,059.13787,949.14 Transactions Current Month $1,371,902.47$1,371,902.47 .00.00.00 Budget 1,060.00 Amended 43,599.0094,942.0070,000.0010,000.00 15 929,223.00171,292.00329,969.00273,381.00115,000.00182,546.00 2,318,148.008,885,882.005,704,914.00 $19,129,956.00$19,129,956.00 .00.00.00.00.00.00.00.00.00.00.00.00.00.00.00 Budget 101,000.00242,500.00 $343,500.00$343,500.00 Amendments .00.00.00 Budget Adopted Expense Budget by Account Classification Report 1,060.00 43,599.0094,942.0070,000.0010,000.00 929,223.00171,292.00329,969.00172,381.00115,000.00182,546.00 2,318,148.008,885,882.005,462,414.00 $18,786,456.00$18,786,456.00 Totals EXPENSE TOTALS 050 - Water and Sewer Fund Fund 050 - Water and Sewer Fund EXPENSE Account ClassificationFundPersonal Services, Scheduled Salaries & WagesEmployee BenefitsOther Employee CostsContractual ServicesUtilitiesInsuranceCommodities & SuppliesOther ExpendituresBuildingsBuil ding ImprovementsOffice EquipmentOther EquipmentDistribution SystemsInfrastructureBond PrincipalInterest ExpenseInterfund Transfers .00.00 .00.00.00 12.00 665.00 6,501.193,830.43 12,674.96 $23,683.58$23,683.58 Prior Year YTD 00 4220 404268 39% +++ ++++++ Rec'd % Used/ Summary Listing Through 05/31/18 .00.00.00 381.50552.00 7,506.00 23,153.3310,349.3148,564.9316,135.00 Transactions $106,642.07$106,642.07 Budget - YTD .00.00.00.00.00 YTD Prior Fiscal Year Activity Included 272.50 7,355.698,028.97 15,523.6729,780.00 $60,960.83$60,960.83 Transactions .00.00.00.00.00.00.00.00 YTD 4,479.104,085.00 $8,564.10$8,564.10 Encumbrances .00.00.00 .00.00 54.50 4,137.861,602.782,273.46 29,780.00 $37,848.60$37,848.60 Transactions Current Month .00.00.00 654.00552.00 Budget 7,506.00 Amended 38,677.0017,705.0061,073.0050,000.00 16 $176,167.00$176,167.00 .00.00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00 654.00 Budget552.00 Adopted Expense Budget by Account Classification Report 7,506.00 38,677.0017,705.0061,073.0050,000.00 $176,167.00$176,167.00 Totals EXPENSE TOTALS 051 - Village Parking System Fund Fund 051 - Village Parking System Fund EXPENSE Account ClassificationFundPersonal Services, Scheduled Salaries & WagesEmployee BenefitsContractual ServicesInsuranceCommodities & SuppliesOther ExpendituresBuildingsBuilding ImprovementsInfrastructu reInterfund Transfers .00.00 .00.00 575.85 9,322.324,788.602,380.041,692.25 28,226.20 $46,985.26$46,985.26 Prior Year YTD 0 4041391742 55% ++++++ ++++++ Rec'd % Used/ Summary Listing Through 05/31/18 .00.00.00 564.10 7,670.579,443.99 16,933.6165,947.9210,585.00 $77,801.84$77,801.84 (33,343.35) Transactions Budget - YTD .00.00.00.00 YTD Prior Fiscal Year Activity Included 402.90 5,426.431,943.014,009.60 11,341.3927,580.09 $50,703.42$50,703.42 Transactions .00.00.00.00.00.00.00.00 YTD 15,369.9929,333.75 $44,703.74$44,703.74 Encumbrances .00.00 .00.00.00 80.58 369.61 3,038.081,179.33 10,276.08 $14,943.68$14,943.68 Transactions Current Month .00.00.00.00 967.00 Budget Amended 28,275.0013,097.0011,387.0010,585.00 17 108,898.00 $173,209.00$173,209.00 .00.00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00.00.00 Budget967.00 Adopted Expense Budget by Account Classification Report 28,275.0013,097.0011,387.0010,585.00 108,898.00 $173,209.00$173,209.00 Totals EXPENSE TOTALS 052 - Parking System Revenue Fund Fund 052 - Parking System Revenue Fund EXPENSE Account ClassificationFundPersonal Services, Scheduled Salaries & WagesEmployee BenefitsContractual ServicesUtilitiesInsuranceCommodities & SuppliesOther ExpendituresBuildingsBuilding ImprovementsInterfund Transfers .00.00 3,692.131,789.282,954.77 21,222.00 354,392.27159,495.76178,344.78 $721,890.99$721,890.99 Prior Year YTD 4441545091 635377 57% +++ Rec'd % Used/ Summary Listing Through 05/31/18 .00 303.80360.00 2,422.971,534.95 51,132.76 561,752.81150,546.17118,662.81 Transactions $886,716.27$886,716.27 Budget - YTD .00 YTD Prior Fiscal Year Activity Included 298.20490.00 1,662.031,790.05 37,176.04 446,679.19254,776.83239,854.31 Transactions $982,726.65$982,726.65 .00.00.00.00.00.00 YTD 3,014.00 20,491.20 163,261.88 $186,767.08$186,767.08 Encumbrances .00.00 .00 258.10393.98 8,536.66 89,085.4148,219.83 112,103.58 Transactions$258,597.56$258,597.56 Current Month .00 602.00 Budget 4,085.003,325.003,864.00 Amended 18 405,323.00108,800.00521,779.00 1,008,432.00 $2,056,210.00$2,056,210.00 .00.00.00.00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00 602.00 Budget Adopted Expense Budget by Account Classification Report 4,085.003,325.003,864.00 405,323.00108,800.00521,779.00 1,008,432.00 $2,056,210.00$2,056,210.00 Totals EXPENSE TOTALS 060 - Vehicle Maintenance Fund Fund 060 - Vehicle Maintenance Fund EXPENSE Account ClassificationFundPersonal Services, Scheduled Salaries & WagesEmployee BenefitsOther Employee CostsContractual ServicesUtilitiesCommodities & SuppliesOther ExpendituresOffice EquipmentOther Equipment .00.00 1,352,181.58 $1,352,181.58$1,352,181.58 Prior Year YTD 39 39% ++++++ Rec'd % Used/ Summary Listing Through 05/31/18 .00.00 Transactions 1,790,371.73 Budget - YTD $1,790,371.73$1,790,371.73 .00.00 YTD Prior Fiscal Year Activity Included 67,617.44 $67,617.44$67,617.44 Transactions .00.00 YTD 1,100,456.83 Encumbrances $1,100,456.83$1,100,456.83 .00.00 24,847.53 $24,847.53$24,847.53 Transactions Current Month .00.00 Budget Amended 19 2,958,446.00 $2,958,446.00 $2,958,446.00 .00.00 Budget 572,446.00 $572,446.00$572,446.00 Amendments .00.00 Budget Adopted Expense Budget by Account Classification Report 2,386,000.00 $2,386,000.00$2,386,000.00 Totals EXPENSE TOTALS 061 - Vehicle Replacement Fund Fund 061 - Vehicle Replacement Fund EXPENSE Account ClassificationFundOther ExpendituresMotor EquipmentInterfund Transfers .00 21,252.56 $21,252.56$21,252.56 Prior Year YTD 15 15% +++ Rec'd % Used/ Summary Listing Through 05/31/18 .00 252,577.81 Transactions $252,577.81$252,577.81 Budget - YTD .00 YTD Prior Fiscal Year Activity Included 34,122.91 $34,122.91$34,122.91 Transactions .00 YTD 8,814.28 $8,814.28$8,814.28 Encumbrances .00.00 $0.00$0.00 Transactions Current Month .00 Budget Amended 20 295,515.00 $295,515.00$295,515.00 .00.00 $0.00$0.00 Budget Amendments .00 Budget Adopted Expense Budget by Account Classification Report 295,515.00 $295,515.00 $295,515.00 Totals EXPENSE TOTALS 062 - Computer Replacement Fund Fund 062 - Computer Replacement Fund EXPENSE Account ClassificationFundOther ExpendituresOffice Equipment .00 .00 2,195.94 9,800.00 3,959,792.97 $3,971,788.91$3,971,788.91 Prior Year YTD 3 0 55 54% +++ +++ Rec'd % Used/ Summary Listing Through 05/31/18 .00 27,000.0019,304.50 (1,112.65) Transactions 3,880,987.17 Budget - YTD $3,926,179.02$3,926,179.02 .00.00 YTD Prior Fiscal Year Activity Included 695.50 1,112.65 Transactions 4,685,350.83 $4,687,158.98$4,687,158.98 .00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00.00 676,304.58 Transactions$676,304.58$676,304.58 Current Month .00.00 Budget Amended 27,000.0020,000.00 21 8,566,338.00 $8,613,338.00$8,613,338.00 .00.00.00.00.00 $0.00$0.00 Budget Amendments .00.00 Budget Adopted Expense Budget by Account Classification Report 27,000.0020,000.00 8,566,338.00 $8,613,338.00$8,613,338.00 Totals EXPENSE TOTALS 063 - Risk Management Fund Fund 063 - Risk Management Fund EXPENSE Account ClassificationFundContractual ServicesInsuranceCommodities & SuppliesOther EquipmentInterfund Transfers .00.00.00 9,210.00 38,303.00 1,995,051.76 Prior Year YTD$2,042,564.76$2,042,564.76 00 4225 80 42% +++ Rec'd % Used/ Summary Listing Through 05/31/18 .00 100.00 2,000.00 15,000.00 124,434.89 Transactions Budget - YTD2,897,999.78 $3,039,534.67$3,039,534.67 .00.00.00 YTD Prior Fiscal Year Activity Included 8,000.00 41,065.11 Transactions 2,135,555.22 $2,184,620.33$2,184,620.33 .00.00.00.00.00.00 YTD $0.00$0.00 Encumbrances .00.00.00 8,000.00 33,953.29 437,670.37 Transactions $479,623.66$479,623.66 Current Month .00 100.00 Budget Amended 15,000.0010,000.00 22 165,500.00 5,033,555.00 $5,224,155.00$5,224,155.00 .00.00.00.00.00.00 $0.00$0.00 Budget Amendments .00 100.00 Budget Adopted Expense Budget by Account Classification Report 15,000.0010,000.00 165,500.00 5,033,555.00 $5,224,155.00 $5,224,155.00 Totals EXPENSE TOTALS 070 - Police Pension Fund Fund 070 - Police Pension Fund EXPENSE Account ClassificationFundPension BenefitsContractual ServicesInsuranceCommodities & SuppliesOther ExpendituresOffice Equipment .00.00 8,795.00 42,590.59 2,208,698.10 $2,260,083.69 Prior Year YTD$2,260,083.69 $37,256,502.56 00 4337 82 43% Rec'd % Used/ Summary Listing Through 05/31/18 100.00 1,810.00 83,660.8315,000.00 Transactions Budget - YTD3,174,712.42 $3,275,283.25$3,275,283.25 $70,287,061.84 .00.00 YTD Prior Fiscal Year Activity Included 8,190.00 49,839.17 Transactions 2,426,897.58 $2,484,926.75$2,484,926.75 $46,365,835.58 .00.00.00.00.00 YTD $0.00$0.00 Encumbrances $9,544,119.58 .00.00 8,190.00 30,380.56 485,405.52 Transactions $523,976.08$523,976.08 Current Month $15,693,905.13 100.00 Budget Amended 15,000.0010,000.00 23 133,500.00 5,601,610.00 $5,760,210.00$5,760,210.00 $126,197,017.00 .00.00.00.00.00 $0.00$0.00 Budget Amendments $2,505,254.00 100.00 Budget Adopted Expense Budget by Account Classification Report 15,000.0010,000.00 133,500.00 5,601,610.00 $5,760,210.00$5,760,210.00 $123,691,763.00 Totals Grand Totals EXPENSE TOTALS 071 - Fire Pension Fund Fund 071 - Fire Pension Fund EXPENSE Account ClassificationFundPension BenefitsContractual ServicesInsuranceCommodities & SuppliesOther Expenditures Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO:VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM:FINANCE DIRECTOR DATE:JUNE14, 2018 SUBJECT:MONTHLY FINANCIALREPORT MAY2018 Attached hereto are the cash position and investment statements of the Village for the month ended May 31, 2018end date noted and are intended to supplement the budget revenue and expenditure summary and listing of bills you enterprise funds and trust and agency fund by fund type. The third statement presents the list of investments again broken down by 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 are not funds 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 detailedsummary of cash and investments for the Village broken out by 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 ServiceFunds. The Enterprise Funds consist of the Water/Sewer Fund and two (2) Parking Funds. include the Escrow Deposit and Flex compEscrow 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 atApril30was $47.0million. During May, cash receipts totaled $13,353,031andinvestment income was$66,082.There was also a transfer in from investments of $2.5 million. Reductions in cash and cash equivalents during Maytotaled $14,747,468. Of this amount, payments to vendors were $12,543,636and employee payroll expenses were $2,186,536. Inflowsresulting from interfund activity totaled $41,934while other reductions to cash totaled$17,296.Cash and cash equivalents at May31were $48.2million. Investments in the Governmental and Enterprise Funds at April30were $9,897,578.During the month of May, investment income was $17,920.There was also a transfer out to cash of $2.5 million. Notes and accounted for in the Governmental and Enterprise Funds reside in multiple Fundsinvesting surplus funds above what is needed for cash flow purposes.Total investments at May31are$7.4million. Total cash and investments for Governmental and Enterprise Funds at April30were $56,868,906. Cash and investments at May31totaled $55,600,405.This is adecrease of $1,268,501for the month. Monthly Financial Report 2018 June1, 2018 Page 2 TrustandAgency Funds-Cash andcashequivalentsatApril30was$4.6million.DuringMay,cash receipts totaled $259,390.Investment income for the month was $54,906. There was also a net increase incashduetoinvestmentactivitiesof$350whileoutflowsdueto Interfundactivitytotaled$41,934. ReductionsincashandcashequivalentsduringMaytotaled$1,026,146.Ofthisamount,paymentsto vendors were $241,733 and employee payroll and related expenses were $782,593.Other disbursements totaled $1,820.Cash and cash equivalents at May31 were $3.8 million. Total investments atMay 31were$136,016,666,an increase of $1,930,396 from April 30. Therewere investmentgains of $1,930,746 andanettransfer tocash of $350that accounted for the change. Total cashandinvestments forTrustandAgency Funds atApril 30were$138,658,476.Cashand investments atMay 31totaled $139,835,438. This isan increaseof $1,176,962. Summary of CashActivity by Fund Type (page5) This reportprovides a breakdown of the cash activity forthe monthbroken downby fund type. This breakdownis useful inidentifyingwherethe activity (receipts and disbursements) is occurring.Thereare times during theyearwhen activity incertainfunds suchas the capital improvementand special revenue funds is higher thannormal.This will distortthe financial picture of someof the other components of the governmental funds suchas the General Fundwhichtends tobe morelevel and predictableinterms of spending andreceiptof revenue.Eachmonththereportwill providedetail explanation on activity of the General Fund,the VilDetail on theactivity of the General Fund is highlighted below. GeneralFundCashandcashequivalentsat April30totaled$15,132,474.DuringMay,cashreceipts totaled$3,556,281,andinvestmentincomewas$40,166.Significantcashreceiptsincludesalesand income taxes. Sales tax revenues for the month totaled $1,504,428.Sales taxes received in Mayare for February sales as there is a three-month lag in getting this distribution from the state. State income taxreceipts for Maytotaled $742,904and were for the monthof April. Disbursements from the General Fund for Mayincluded payments to vendors of $1,888,027, payments for employee wages and benefits of $1,914,912and other disbursements of $10,942.There was also a net decrease in cash from Interfund transfers totaling $762,366. Cash and cash equivalentsatMay31were $14,152,675, adecrease of $979,799from April30. In addition, investments consisting of certificates of deposit totaling $3,676,631bring total cash and investments for the General Fund to $17,829,306. Statement of Investments (page 6) This report provides a breakdown of investments by trust and agency funds and governmental and enterprise funds. The report also provides a fund-by-fund breakdown of the investments. Government and Enterprise Funds-Investments for the governmental and agency funds are made up of Certificates of Deposit. At May31,there was a total of $7,401,993and various governmental notes. These notes and monies available from the governmental and enterprise funds. A detail list of holdings is included with this report. Trust andAgency FundsThe investments for the trust and agency funds are made up of certificates of will generally have maturities of between 30 and 120 days. Most of the reserves for this fund are invested in the more liquid money market account due to the nature of the deposit. At May31,there was a total of Monthly Financial Report 2018 June1, 2018 Page 3 $136.0 million invested in a combination of fixed income and equity instruments. A detail list of holdings is 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. SegallBryantholdsapproximatelyhalfofthefixedincomeinvestmentsforthetwopensionfundswhile 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. Investmentsin equitiesconsistofmutualfundsspread acrossvarioussectors(small,mid andlarge-cap stocks) as well as investment philosophies (value, core and growth). The funds also invest a small amount ininternationalstocks.Each yearthe investmentmixis evaluatedforoptimal diversificationtomeetpension fundinvestmentpolicygoalsandobjectives.EquityinvestmentsheldbythePolicePensionFundare managedbySawyerFaldutoAssetManagement.Abreakdownofwherepensionfundsareinvestedis included with this report. Conclusion monthenddate.Using this report, weareabletoprovide trend information tosupportcashmanagement Thisreportisprovided tothe Village Boardand FinanceCommission on amonthly basis. Pleasedo not hesitateto contact me withany questions. David O. Erb Finance Director VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended May 31, 2018 GOVERNMENTAL AND ENTERPRISE FUNDS Cash and CashTotal Cash and EquivalentsInvestmentsInvestments Balance at April 30, 2018$46,971,328.33$ 9,897,577.66$56,868,905.99 Cash receipts13,353,030.8513,353,030.85 Investment income66,082.2317,919.8784,002.10 Transfers from investments to cash2,513,505.00(2,513,505.00)- Transfers to investments from cash--- Interfund activity41,933.7141,933.71 Disbursements: Accounts payable(12,543,635.73)(12,543,635.73) Payroll(2,186,535.91)(2,186,535.91) Other(17,295.95)(17,295.95) Balance at May 31, 2018$48,198,412.53$ 7,401,992.53$55,600,405.06 TRUST AND AGENCY FUNDS * Cash and CashTotal Cash and EquivalentsInvestmentsInvestments Balance at April 30, 2018$4,572,205.82$134,086,270.14$138,658,475.96 Cash receipts259,389.79259,389.79 Investment income (loss)54,905.811,930,745.821,985,651.63 Transfers from investments to cash1,810,203.51(1,810,203.51)- Transfers to investments from cash(1,809,853.59)1,809,853.59- Interfund activity(41,933.71)(41,933.71) Disbursements: Accounts payable(241,732.75)(241,732.75) Payroll(782,593.23)(782,593.23) Flex spending-- Other(1,819.60)(1,819.60) Balance at May 31, 2018$3,818,772.05$136,016,666.04$139,835,438.09 * Assets are restricted in purpose and do not represent discretionary assets of the government. 4 5 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of May 31, 2018 GOVERNMENTAL AND ENTERPRISE FUNDS MaturityPurchaseFinancial InvestmentCUSIP/Market DateDateInstitutionDescriptionFDIC #Net YieldValue GENERAL FUND (001) 06/29/1812/28/17Freddie MacAgency Notes3134G9TH05.000%1,202,866.80 12/31/1812/28/17U.S. Treasury NoteTreasury Note912828A751.500%1,239,286.48 12/13/1912/28/17Federal Home Loan BankAgency Notes3130A0JR22.375%1,234,477.96 3,676,631.24 VEHICLE REPLACEMENT FUND (061) 05/30/1912/28/17Freddie MacAgency Notes3137EADG11.750%1,243,536.25 06/12/2012/28/17Federal Home Loan BankAgency Notes313383MB41.875%1,232,700.00 12/11/2012/28/17Federal Home Loan BankAgency Notes3130A3UQ51.875%1,229,075.00 3,705,311.25 RISK MANAGEMENT FUND (063) 03/06/1903/06/17Mount Prospect State BankCertificate of Deposit3540580.250%20,050.04 20,050.04 TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS$ 7,401,992.53 TRUST AND AGENCY FUNDS * MaturityPurchaseFinancial InvestmentCUSIP/InterestMarket DateDateInstitutionDescriptionAcct #Rate %Value POLICE PENSION FUND (070) VariousVariousWells FargoWells Fargo InvestmentsVariousVarious$ 22,935,404.49 VariousVariousVariousMutual Fund InvestmentsVariousVarious47,759,004.19 70,694,408.68 FIRE PENSION FUND (071) Various5/26/2015Principal Life Insurance CompanyGroup Annuity Contract8-10810Variable5,832,432.11 VariousVariousWells FargoWells Fargo InvestmentsVariousVarious22,184,558.84 VariousVariousVariousMutual Fund InvestmentsVariousVarious37,305,266.41 65,322,257.36 TOTAL TRUST AND AGENCY FUND INVESTMENTS$ 136,016,666.04 * Assets are restricted in purpose and do not represent discretionary assets of the government. 6