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 - October 2019
4/15/2020 BoardDocs® Pro Agenda Item Details Meeting Dec 03, 2019 - REGULAR MEETING OF THE MOUNT PROSPECT VILLAGE BOARD - 7:00 p.m. Category 5. CONSENT AGENDA Subject 5.1 Monthly Financial Report - October 2019 Access Public Type Action (Consent) Budget Source Accept the monthly financial report for October 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 October 31, 2019. Alternatives 1. Accept the Monthly Financial Report for October 2019. 2. Action at discretion of Village Board. Staff Recommendation Staff recommends the Village Board accept the monthly financial report for October 31, 2019. -�r / / • ��I .. 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 (not specified) Motion by Michael Zadel, second by Richard Rogers. Final Resolution: Motion Carries https://go.boarddocs.com/il/vomp/Board.nsf/Private?open&login 1/2 4/15/2020 BoardDocs® Pro Yea: William Grossi, Eleni Hatzis, Paul Hoefert, Richard Rogers, Colleen Saccotelli, Michael Zadel https://go.boarddocs.com/il/vomp/Board.nsf/Private?open&login 2/2 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES October 1—October 31, 2019 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima 1 _ Genera- -und _ ota -s REVENUE TOTALS $56,118,900.00 $0.00 $56,118,900.00 $3,959,833.52 $0.00 $44,462,535.93 $11,656,364.07 79% $48,621,562.34 $56,118,900.00 $0.00 $56,118,900.00 $3,959,833.52 1 $0.00 $44,462,535.93 $11,656,364.07 $48,621,562.34 Adopted Budget Amended Current % Used/ Classification s Budget Transactionsr r s i Transactions Prior Year YTD 00 _ Genera REVENUE wrrty 1 -s 16,498,000.00 .00 16,498,000.00 87,058.38 .00 16f 179f 543.29 318,456.71 98 16,335,349.80 Other 1 axes 8,033,000.00 .00 8,033,000.00 435,526.06 .00 4,539,500.15 3,493,499.85 57 6,093,872.90 ss r-ts1,362,000.00 .00 1,362,000.00 341,354.96 .00 11828,659.53 (466,659.53) 134 1,578,340.09 tervrt- Revenue 271872,000.00 .00 271872,000.00 2,814,645.33 .00 19,852,515.65 81019,484.35 71 22,085,251.21 Charges or S.ervices 11209,000.00 .00 11209,000.00 172,385.24 .00 1,011,171.31 197,828.69 84 801,804.70 -nes rias 432,000.00 .00 432,000.00 16,391.50 .00 218,326.53 213,673.47 51 305,285.50 Investment lncome 266,100.00 .00 266,100.00 24,878.58 .00 373,579.13 (107,479.13) 140 2741205.32 e -rrsts 190,500.00 .00 190,500.00 50,017.84 .00 211,913.45 (21,413.45) 111 148,758.16 Other Revenue 256,300.00 .00 256,300.00 17,575.63 .00 247,326.89 8,973.11 96 431,352.66 Other -C-gig rs .00 .00 .00 .00 .00 .00 .00 +++ 567,342.00 1 _ Genera- -und _ ota -s REVENUE TOTALS $56,118,900.00 $0.00 $56,118,900.00 $3,959,833.52 $0.00 $44,462,535.93 $11,656,364.07 79% $48,621,562.34 $56,118,900.00 $0.00 $56,118,900.00 $3,959,833.52 1 $0.00 $44,462,535.93 $11,656,364.07 $48,621,562.34 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS ter'- 002 - Debi Service Fund - otals $5,827,228.00 $0.00 $5,827,228.00 $30,184.06 $0.00 $3,606,189.50 $2,221,038.50 62% $9,974,738.79 $5,827,228.00 $0.00 $5,827,228.00 2 $30,184.06 $0.00 $3,606,189.50 $2,221,038.50 $9,974,738.79 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD 00 _ Debt Service �d REVENUE r rty _ -xes 21434,000.00 .00 21434,000.00 18,606.94 .00 2,410,153.94 23,846.06 99 2,390,000.00 Other _ axes 1,024,578.00 .00 1,024,578.00 .00 .00 1,024,578.00 .00 100 911,266.20 trrta- revenue 11573,650.00 .00 11573,650.00 5, 245.24 .00 100,018.04 1,473,631.96 6 109,988.37 -mvesiment Income 5,000.00 .00 5,000.00 6,331.88 .00 71,439.52 (66,439.52) 1429 11,231.60 Other Re .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Findanc ng )Dunes 790,000.00 .00 790,000.00 .00 .00 .00 790,000.00 0 6,552,252.62 REVENUE TOTALS ter'- 002 - Debi Service Fund - otals $5,827,228.00 $0.00 $5,827,228.00 $30,184.06 $0.00 $3,606,189.50 $2,221,038.50 62% $9,974,738.79 $5,827,228.00 $0.00 $5,827,228.00 2 $30,184.06 $0.00 $3,606,189.50 $2,221,038.50 $9,974,738.79 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS -- - -- - -- -__ - ,eta s $2,142,000.00 $0.00 $2,142,000.00 $233,507.61 $0.00 $320,549.77 $1,821,450.23 15% $1,185,177.45 $2,142,000.00 $0.00 $2,142,000.00 3 $233,507.61 $0.00 $320,549.77 $1,821,450.23 $1,185,177.45 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD 020 _ _t - improvement REVENUE Other _ axes 11370,000.00 .00 11370,000.00 231,812.60 .00 294,398.25 11075,601.75 21 11170,000.00 IritergovernM - Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Mesiment income 20,000.00 .00 20,000.00 1,695.01 .00 26,151.52 61151.52 131 15,177.45 -mrsts .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Rees 2,000.00 .00 2,000.00 .00 .00 .00 2,000.00 0 .00 Other Findanc-ng iources 750,000.00 .00 750,000.00 .00 .00 .00 750,000.00 0 .00 REVENUE TOTALS -- - -- - -- -__ - ,eta s $2,142,000.00 $0.00 $2,142,000.00 $233,507.61 $0.00 $320,549.77 $1,821,450.23 15% $1,185,177.45 $2,142,000.00 $0.00 $2,142,000.00 3 $233,507.61 $0.00 $320,549.77 $1,821,450.23 $1,185,177.45 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS improvement Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS und - - -� -_�-- Construct �- -_ - -_ iota ls - $2,417,422.00 $0.00 $2,417,422.00 $233,866.60 $0.00 $365,944.00 $2,051,478.00 15% $342,418.99 $2,417,422.00 $0.00 $2,417,422.00 5 $233,866.60 $0.00 $365,944.00 $2,0511478.00 $342,418.99 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD 024 =- �- Construction -und REVENUE Other _ axes 345,422.00 .00 345,422.00 231,812.60 .00 294,398.25 51,023.75 85 259,200.00 rigoven trrrt�- 2,000,000.00 .00 2,000,000.00 .00 .00 .00 2,000,000.00 0 .00 Charas r Sergi ces 40fOOO.00 .00 40,000.00 931.00 .00 26,040.00 13,960.00 65 50,188.00 --vesiment income 12,000.00 .00 12,000.00 1,123.00 .00 15,598.47 (3,598.47) 130 13,030.99 R-rsts 20,000.00 .00 20,000.00 .00 .00 29,907.28 (9,907.28) 150 20,000.00 Other Findanc-ng iources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS und - - -� -_�-- Construct �- -_ - -_ iota ls - $2,417,422.00 $0.00 $2,417,422.00 $233,866.60 $0.00 $365,944.00 $2,051,478.00 15% $342,418.99 $2,417,422.00 $0.00 $2,417,422.00 5 $233,866.60 $0.00 $365,944.00 $2,0511478.00 $342,418.99 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima o Me & - We Bu. -- Const_ Tota $88,000.00 £aREVENUE TOTALS $88,000.00 $0.00 $88,000.00 $47,231.66 $0.00 $627,213.81 ($539,213.81) 713% $33,441,763.46 $88,000.00 $0.00 $88,000.00 L0 $47,231.66 $0.00 $627,213.81 ($539,213.81) $33,441,763.46 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD REVENUE Investment Income 88,000.00 .00 88,000.00 47,231.66 .00 627,213.81 (539,213.81) 713 29,388.48 -rrsrts .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Other -- rs .00 .00 .00 .00 .00 .00 .00 +++ 33,412,374.98 o Me & - We Bu. -- Const_ Tota $88,000.00 £aREVENUE TOTALS $88,000.00 $0.00 $88,000.00 $47,231.66 $0.00 $627,213.81 ($539,213.81) 713% $33,441,763.46 $88,000.00 $0.00 $88,000.00 L0 $47,231.66 $0.00 $627,213.81 ($539,213.81) $33,441,763.46 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS 4 - Refuse � -s - ----una - tals $4,371,720.00 $0.00 $4,371,720.00 $307,965.43 $0.00 $3,609,466.04 $762,253.96 83% $3,558,915.69 $4,371,720.00 $0.00 $4,371,720.00 $307,965.43 7 $0.00 $3,609,466.04 $762,253.96 $3,558,915.69 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD 040 _ Refuse D-sposa- �d REVENUE rrrty -s .00 .00 .00 .00 Charges r Sereices 41194,500.00 .00 41194,500.00 283,592.99 .00 31461,756.25 7321743.75 83 31425,640.17 -s grits 37,000.00 .00 37,000.00 4,606.67 .00 28,206.48 8,793.52 76 31,309.67 -mvesiment Income 5,000.00 .00 5,000.00 1,087.79 .00 10,553.71 (5,553.71) 211 7,019.80 R-rsts 1,000.00 .00 1,000.00 319.02 .00 860.48 139.52 86 898.44 Other Revenue 134,220.00 .00 134,220.00 18,358.96 .00 108,089.12 26,130.88 81 94,047.61 REVENUE TOTALS 4 - Refuse � -s - ----una - tals $4,371,720.00 $0.00 $4,371,720.00 $307,965.43 $0.00 $3,609,466.04 $762,253.96 83% $3,558,915.69 $4,371,720.00 $0.00 $4,371,720.00 $307,965.43 7 $0.00 $3,609,466.04 $762,253.96 $3,558,915.69 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS 041 - Motor - Tax -und _ ota- $1,435,000.00 $0.00 $1,435,000.00 $204,152.10 $0.00 $1,190,335.19 $244,664.81 83% $1,048,750.18 $1,435,000.00 $0.00 $1,435,000.00 $204,152.10 $0.00 $1,190,335.19 $244,664.81 $1,048,750.18 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD 04 motor Me nolax REVENUE trgr_t- 1,400,000.00 .00 1,400,000.00 195,654.59 .00 1,157,545.40 242,454.60 83 1,016,838.91 Ir -vestment income 20,000.00 .00 20,000.00 1,907.68 .00 24,471.46 (41471.46) 122 23,754.17 Reimburs.inents 15,000.00 .00 15,000.00 6,589.83 .00 8,318.33 6,681.67 55 8,157.10 ether Reye .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS 041 - Motor - Tax -und _ ota- $1,435,000.00 $0.00 $1,435,000.00 $204,152.10 $0.00 $1,190,335.19 $244,664.81 83% $1,048,750.18 $1,435,000.00 $0.00 $1,435,000.00 $204,152.10 $0.00 $1,190,335.19 $244,664.81 $1,048,750.18 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS -ung 042 _ CDBG Tota $365,649.00 $101,322.00 $466,971.00 $0.00 $0.00 $338,259.80 $128,711.20 72% $261,138.73 $365,649.00 $101,322.00 $466,971.00 9 $0.00 $0.00 $338,259.80 $128,711.20 $261,138.73 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD -ung REVENUE trgr_t- 275,649.00 67,096.00 342,745.00 .00 .00 214,033.66 128,711.34 62 175,869.57 Investment income .00 .00 .00 .00 .00 .00 .00 +++ .00 ether Revenue 90,000.00 34,226.00 1241226.00 .00 .00 124,226.14 (.14) 100 85,269.16 REVENUE TOTALS -ung 042 _ CDBG Tota $365,649.00 $101,322.00 $466,971.00 $0.00 $0.00 $338,259.80 $128,711.20 72% $261,138.73 $365,649.00 $101,322.00 $466,971.00 9 $0.00 $0.00 $338,259.80 $128,711.20 $261,138.73 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS Asset --u -und Tota -s $12,000.00 $0.00 $12,000.00 $15,790.17 $0.00 $28,696.14 ($16,696.14) 239% $10,869.85 $12,000.00 $0.00 $12,000.00 10 $15,790.17 $0.00 $28,696.14 ($16,696.14) $10,869.85 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD REVENUE -s r is 10,000.00 .00 10,000.00 15,652.00 .00 27,264.46 (17,264.46) 273 9,674.88 Ir -vestment income 21000.00 .00 21000.00 138.17 .00 1,431.68 568.32 72 1,194.97 REVENUE TOTALS Asset --u -und Tota -s $12,000.00 $0.00 $12,000.00 $15,790.17 $0.00 $28,696.14 ($16,696.14) 239% $10,869.85 $12,000.00 $0.00 $12,000.00 10 $15,790.17 $0.00 $28,696.14 ($16,696.14) $10,869.85 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD 044 � - - - - - --qu-tab-e Snare-- REVENUE -s r is 2,000.00 .00 2,000.00 .00 .00 30,111.73 (28,111.73) 1506 .00 Ir -vestment income 200.00 .00 200.00 7.79 .00 100.53 99.47 50 95.31 REVENUE TOTALS OA undsTo $2,200.00 $0.00 $2,200.00 $7.79 $0.00 $30,212.26 ($28,012.26) 1373% $95.31 $2,200.00 $0.00 $2,200.00 $7.79 $0.00 $30,212.26 ($28,012.26) $95.31 11 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS DUI Mine - Tota s $25,500.00 $0.00 $25,500.00 $4,028.79 $0.00 $14,601.24 $10,898.76 57% $14,942.10 $25,500.00 $0.00 $25,500.00 12 $4,028.79 $0.00 $14,601.24 $10,898.76 $14,942.10 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD unL-I0- _ �_ REVENUE -s orfe is 25,000.00 .00 25,000.00 41007.40 .00 14,322.48 10,677.52 57 141706.54 Ir -vestment income 500.00 .00 500.00 21.39 .00 278.76 221.24 56 235.56 REVENUE TOTALS DUI Mine - Tota s $25,500.00 $0.00 $25,500.00 $4,028.79 $0.00 $14,601.24 $10,898.76 57% $14,942.10 $25,500.00 $0.00 $25,500.00 12 $4,028.79 $0.00 $14,601.24 $10,898.76 $14,942.10 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima Und 0 -Ir =- - - - - -6 -u - - to s oreign REVENUE TOTALS $94,000.00 $0.00 $94,000.00 $432.57 $0.00 $80,154.79 $13,845.21 85% $79,824.57 $94,000.00 $0.00 $94,000.00 $432.57 $0.00 $80,154.79 $13,845.21 13 $79,824.57 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD 046 oreign F Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima sin s - -strict -und _ ota- REVENUE TOTALS $1,525,000.00 $0.00 $1,525,000.00 $123,222.62 $0.00 $975,642.95 $549,357.05 64% $1,117,005.76 $1,525,000.00 $0.00 $1,525,000.00 14 $123,222.62 $0.00 $975,642.95 $549,357.05 $1,117,005.76 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD 08 _ Bus_ness _st_t und REVENUE Other _ axes 11070,000.00 .00 11070,000.00 81,844.41 .00 703,640.33 366,359.67 66 728,144.28 trvrrrta 440,000.00 .00 440,000.00 40,415.02 .00 263,973.13 176,026.87 60 378,000.00 Investment income 15,000.00 .00 15,000.00 963.19 .00 8,029.49 6,970.51 54 10,861.48 Other -- rs .00 .00 .00 .00 .00 .00 .00 +++ .00 sin s - -strict -und _ ota- REVENUE TOTALS $1,525,000.00 $0.00 $1,525,000.00 $123,222.62 $0.00 $975,642.95 $549,357.05 64% $1,117,005.76 $1,525,000.00 $0.00 $1,525,000.00 14 $123,222.62 $0.00 $975,642.95 $549,357.05 $1,117,005.76 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS Prosoect and Main - � District - to $10,484,000.00 $0.00 $10,484,000.00 $15,757.71 $0.00 $2,679,566.12 $7,804,433.88 26% $8,021,401.27 $10,484,000.00 $0.00 $10,484,000.00 15 $15,757.71 $0.00 $2,679,566.12 $7,804,433.88 $8,021,401.27 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD REVENUE rrrty 1 -s 474,000.00 .00 474,000.00 141746.64 .00 416,302.89 57,697.11 88 463,800.02 Investment income 10,000.00 .00 10,000.00 1,011.07 .00 14,044.23 (41044.23) 140 69,376.94 Other Revenue .00 .00 .00 .00 .00 .00 .00 +++ 169,345.01 Other -Sources 10,000,000.00 .00 101000,000.00 .00 .00 2,249,219.00 71750,781.00 22 7,318,879.30 REVENUE TOTALS Prosoect and Main - � District - to $10,484,000.00 $0.00 $10,484,000.00 $15,757.71 $0.00 $2,679,566.12 $7,804,433.88 26% $8,021,401.27 $10,484,000.00 $0.00 $10,484,000.00 15 $15,757.71 $0.00 $2,679,566.12 $7,804,433.88 $8,021,401.27 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS u -d 00 $25,940,700.00 $0.00 $25,940,700.00 $2,583,886.41 $0.00 $14,073,838.40 $11,866,861.60 54% $12,111,272.10 $25,940,700.00 $0.00 $25,940,700.00 $2,583,886.41 16 $0.00 $14,073,838.40 $11,866,861.60 $12,111,272.10 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD 0-0 _ Water and Sewer REVENUE rrtry _ _s .00 .00 .00 (41313.61) .00 (14,012.68) 14,012.68 +++ 5,716.76 - s s- rm Is gees 20,000.00 .00 20,000.00 2,290.00 .00 18,020.00 1,980.00 90 18,450.00 Iniergovernmenia Re -venue .00 .00 .00 .00 .00 .00 .00 +++ .00 Charges dor Seas 15,509,600.00 .00 15,509,600.00 2,544,684.34 .00 13,698,676.37 11810,923.63 88 11,815,943.66 -nes or -- 100,000.00 .00 100,000.00 9,032.99 .00 76,989.69 23,010.31 77 86,757.63 �stt Income 51,100.00 .00 51,100.00 28,272.69 .00 235,024.71 (183,924.71) 460 144,359.77 -rsts .00 .00 .00 .00 .00 8,100.31 (8,100.31) +++ (11200.00) Other venue 60,000.00 .00 60,000.00 3,920.00 .00 51,040.00 81960.00 85 52,677.80 Other -n-mrcing Sources 10,200,000.00 .00 10,200,000.00 .00 .00 .00 10,200,000.00 0 .00 REVENUE TOTALS u -d 00 $25,940,700.00 $0.00 $25,940,700.00 $2,583,886.41 $0.00 $14,073,838.40 $11,866,861.60 54% $12,111,272.10 $25,940,700.00 $0.00 $25,940,700.00 $2,583,886.41 16 $0.00 $14,073,838.40 $11,866,861.60 $12,111,272.10 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS - - VI -age Park -ng System -__- $192,600.00 $0.00 $192,600.00 $13,832.28 $0.00 $149,041.74 $43,558.26 77% $161,971.58 $192,600.00 $0.00 $192,600.00 17 $13,832.28 $0.00 $149,041.74 $43,558.26 $161,971.58 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD -- - _ -�s REVENUE Other _ axes .00 .00 .00 .00 .00 .00 .00 +++ .00 Charges r rvices 186,600.00 .00 186,600.00 13,239.80 .00 142,645.10 43,954.90 76 156,847.43 Mesiment income 3,000.00 .00 3,000.00 375.48 .00 3,763.24 (763.24) 125 21555.85 ether Reye 3,000.00 .00 3,000.00 217.00 .00 2,633.40 366.60 88 21568.30 Other-inanc -g Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS - - VI -age Park -ng System -__- $192,600.00 $0.00 $192,600.00 $13,832.28 $0.00 $149,041.74 $43,558.26 77% $161,971.58 $192,600.00 $0.00 $192,600.00 17 $13,832.28 $0.00 $149,041.74 $43,558.26 $161,971.58 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS $158,200.00 $0.00 $158,200.00 $14,418.70 $0.00 $134,803.77 $23,396.23 85% $132,520.04 $158,200.00 $0.00 $158,200.00 18 $14,418.70 $0.00 $134,803.77 $23,396.23 $132,520.04 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD -ung �� _ _System REVENUE Other _ axes .00 .00 .00 .00 .00 .00 .00 +++ .00 trvrrta- .00 .00 .00 .00 .00 .00 .00 +++ .00 rs nor -s 156,000.00 .00 156,000.00 14,112.25 .00 132,083.90 23,916.10 85 130,318.12 -mvesiment Income 1,000.00 .00 1,000.00 165.05 .00 1,556.12 (556.12) 156 11181.32 Wither Rees 11200.00 .00 11200.00 141.40 .00 11163.75 36.25 97 11020.60 Other Findanc-ng iources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $158,200.00 $0.00 $158,200.00 $14,418.70 $0.00 $134,803.77 $23,396.23 85% $132,520.04 $158,200.00 $0.00 $158,200.00 18 $14,418.70 $0.00 $134,803.77 $23,396.23 $132,520.04 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima ls nd 060 � Vehic- Maintenance - £a_ REVENUE TOTALS $2,052,358.00 $0.00 $2,052,358.00 $170,932.28 $0.00 $1,7091305.69 $343,052.31 83% $1,706,369.22 $2,052,358.00 $0.00 $2,052,358.00 19 $170,932.28 $0.00 $1,709,305.69 $343,052.31 $1,706,369.22 Adopted Budget Amended Current % Used/ Classificatio n Budget Amendments Budget Transactionsr r s i Transactions Prior Year YTD 0060 _ V -_-e Maintenance REVENUE Charges or Services 21046,358.00 .00 21046,358.00 170,529.81 .00 1,705,298.10 341,059.90 83 1,700,689.00 Investment income 61000.00 .00 61000.00 402.47 .00 4,007.59 11992.41 67 4,592.31 0 r Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 Other -- rs .00 .00 .00 .00 .00 .00 .00 +++ 1,087.91 ls nd 060 � Vehic- Maintenance - £a_ REVENUE TOTALS $2,052,358.00 $0.00 $2,052,358.00 $170,932.28 $0.00 $1,7091305.69 $343,052.31 83% $1,706,369.22 $2,052,358.00 $0.00 $2,052,358.00 19 $170,932.28 $0.00 $1,709,305.69 $343,052.31 $1,706,369.22 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS - - - - -- -- -- I -Fun - - ,eta s $2,337,100.00 $0.00 $2,337,100.00 $207,763.36 $0.00 $2,009,861.95 $327,238.05 86% $1,539,008.98 $2,337,100.00 $0.00 $2,337,100.00 20 $207,763.36 $0.00 $2,009,861.95 $327,238.05 $1,539,008.98 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD REVENUE Charges nor -s 211321100.00 .00 211321100.00 177,675.01 .00 1,776,750.10 355,349.90 83 1,342,749.90 -s r-ts 10,000.00 .00 10,000.00 .00 .00 11,928.67 (1,928.67) 119 6,449.47 Mesiment income 120,000.00 .00 120,000.00 16,455.40 .00 165,539.61 (45,539.61) 138 61,578.34 -m rs is .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Re .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Findanc-ng iources 75,000.00 .00 75,000.00 13,632.95 .00 55,643.57 19,356.43 74 128,231.27 REVENUE TOTALS - - - - -- -- -- I -Fun - - ,eta s $2,337,100.00 $0.00 $2,337,100.00 $207,763.36 $0.00 $2,009,861.95 $327,238.05 86% $1,539,008.98 $2,337,100.00 $0.00 $2,337,100.00 20 $207,763.36 $0.00 $2,009,861.95 $327,238.05 $1,539,008.98 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS Comouter Reo_c -----------__ -----------__nit -und Tota _s $166,897.00 $0.00 $166,897.00 $14,348.04 $0.00 $143,968.17 $22,928.83 86% $175,117.77 $166,897.00 $0.00 $166,897.00 21 $14,348.04 $0.00 $143,968.17 $22,928.83 $175,117.77 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD REVENUE Charges nor -s 162,897.00 .00 162,897.00 13,574.75 .00 135,747.50 271149.50 83 170,914.10 Ir -vestment income 41000.00 .00 41000.00 773.29 .00 8,220.67 (41220.67) 206 4,203.67 Other --nancing Sources .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS Comouter Reo_c -----------__ -----------__nit -und Tota _s $166,897.00 $0.00 $166,897.00 $14,348.04 $0.00 $143,968.17 $22,928.83 86% $175,117.77 $166,897.00 $0.00 $166,897.00 21 $14,348.04 $0.00 $143,968.17 $22,928.83 $175,117.77 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS $9,255,217.00 $0.00 $9,255,217.00 $755,115.55 $0.00 $7,779,629.61 $1,475,587.39 84% $7,394,897.78 $9,255,217.00 $0.00 $9,255,217.00 $755,115.55 22 $0.00 $7,779,629.61 $1,475,587.39 $7,394,897.78 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD 006 _ Risk Management REVENUE Charges or Services 71429,717.00 .00 71429,717.00 611,566.25 .00 6,140,728.32 1,288,988.68 83 5,942,376.39 -stmt income 20,000.00 .00 20,000.00 1,139.20 .00 12,817.10 71182.90 64 16,529.01 Reni rs is 2,000.00 .00 2,000.00 .00 .00 223,268.30 (221,268.30) 11163 13,060.53 ether Reye 11803,500.00 .00 11803,500.00 142,410.10 .00 1,402,815.89 400,684.11 78 1,422,931.85 REVENUE TOTALS $9,255,217.00 $0.00 $9,255,217.00 $755,115.55 $0.00 $7,779,629.61 $1,475,587.39 84% $7,394,897.78 $9,255,217.00 $0.00 $9,255,217.00 $755,115.55 22 $0.00 $7,779,629.61 $1,475,587.39 $7,394,897.78 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS U1,10 070 � P0 _-Ce Pension Fund Totals $8,419,500.00 $0.00 $8,419,500.00 $1,466,719.51 $0.00 $14,629,072.45 ($6,209,572.45) 174% $3,340,112.84 $8,4191500.00 $0.00 $8,4191500.00 $1,466,719.51 23 $0.00 $14,629,072.45 ($6,209,572.45) $3,340,112.84 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD -ung OZ O _ Po -we Pension REVENUE Charges or Services .00 .00 .00 .00 .00 .00 .00 +++ .00 Investment income 31933,500.00 .00 31933,500.00 1155192.62 .00 10 335 174.65 (61401,674.65) 263 (645 443.47) Other Revenue 41486,000.00 .00 41486,000.00 311,526.89 .00 41293,897.80 1921102.20 96 3,985,556.31 REVENUE TOTALS U1,10 070 � P0 _-Ce Pension Fund Totals $8,419,500.00 $0.00 $8,419,500.00 $1,466,719.51 $0.00 $14,629,072.45 ($6,209,572.45) 174% $3,340,112.84 $8,4191500.00 $0.00 $8,4191500.00 $1,466,719.51 23 $0.00 $14,629,072.45 ($6,209,572.45) $3,340,112.84 Revenue Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary Listima REVENUE TOTALS $71681,800.00 $0.00 $71681,800.00 $1,277,904.14 $0.00 $121410,370.84 ($4,728,570.84) 162% $3,048,290.53 Fund = -_ Pension � _ eta -s $7,681,800.00 $0.00 $7,681,800.00 $1,277,904.14 $0.00 $12,410,370.84 ($4,728,570.84) $3,048,290.53 Grand _ of -s $144,883,991.00 $101,322.00 $144,985,313.00 $11,766,205.99 $0.00 $114,793,716.54 $30,191,596.46 $140,864,223.52 24 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s i Transactions Prior Year YTD -ung 0 _ �_Pension REVENUE Investment Income 31586,000.00 .00 31586,000.00 953,907.79 .00 8,387,475.03 (41801,475.03) 234 (493,935.77) 0 tr 4,095,800.00 .00 4,095,800.00 323,996.35 .00 4,022,895.81 72,904.19 98 3,542,226.30 REVENUE TOTALS $71681,800.00 $0.00 $71681,800.00 $1,277,904.14 $0.00 $121410,370.84 ($4,728,570.84) 162% $3,048,290.53 Fund = -_ Pension � _ eta -s $7,681,800.00 $0.00 $7,681,800.00 $1,277,904.14 $0.00 $12,410,370.84 ($4,728,570.84) $3,048,290.53 Grand _ of -s $144,883,991.00 $101,322.00 $144,985,313.00 $11,766,205.99 $0.00 $114,793,716.54 $30,191,596.46 $140,864,223.52 24 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS $57,408,719.00 $625,990.00 $58,034,709.00 $5,3011426.28 $779,008.47 $44,595,258.62 $12,660,441.91 78% $41,372,398.04 u-- 1 _ Genera- Vund- _ otals $57,4081719.00 $625,990.00 $58,034,709.00 $5,3011426.28 $779,008.47 $44,595,258.62 $12,660,441.91 $41,372,398.04 1 Adopted Budget Amended Current % Used/ Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD 00 _ Genera EXPENSE Persona- Sere -s', Sa-r-sces 27,663,030.00 .00 27,663,030.00 31152,078.95 .00 221456,788.81 51206,241.19 81 20,660,645.36 oyeeits 14,484,814.00 .00 14,484,814.00 1,134,731.60 .00 13,252,572.86 1,232,241.14 91 12,793,567.74 Otr Emp-ovee Costs 582,976.00 (21100.00) 580,876.00 78,612.47 5,545.45 414,942.84 160,387.71 72 347,800.37 Pe-S-on-ts 5,819.00 .00 5,819.00 499.44 .00 41994.40 824.60 86 4,848.90 t -s ,, , ,, 732,902.04 ,tr102.79 6,507,477.27 1,999,987.94 77 51956,171.25 t- -ties 326,724.00 .00 326,724.00 25,378.85 .00 1771491.59 149,232.41 54 161,556.87 lnsuranrn 549,118.00 .00 549,118.00 45,767.51 .00 457,570.50 91,547.50 83 347,604.75 -ties & SUDDHes 832,905.00 121200.00 845,105.00 62,753.29 42,896.58 516,461.43 285,746.99 66 499,473.37 Other expend -tures 11038,741.00 .00 1,038,741.00 .00 .00 104,091.18 934,649.82 10 .00 Bu- Lj-ng Improvements .00 8,250.00 8,250.00 .00 .00 81239.18 10.82 100 392.16 O -quipment 40,430.00 10,000.00 50,430.00 31128.55 .00 14,895.01 35,534.99 30 19,862.63 Other -int 247,887.00 68,047.00 315,934.00 23,384.77 35,232.62 180,749.36 99,952.02 68 185,918.93 D_strbudon Systems .00 .00 .00 .00 .00 .00 .00 +++ .00 n-rastructure 11319,800.00 456,500.00 11776,300.00 42,188.81 353,231.03 498,984.19 924,084.78 48 394,555.71 lnu--TUnu _ rsrs 11540,000.00 .00 1,540,000.00 .00 .00 .00 11540,000.00 0 .00 EXPENSE TOTALS $57,408,719.00 $625,990.00 $58,034,709.00 $5,3011426.28 $779,008.47 $44,595,258.62 $12,660,441.91 78% $41,372,398.04 u-- 1 _ Genera- Vund- _ otals $57,4081719.00 $625,990.00 $58,034,709.00 $5,3011426.28 $779,008.47 $44,595,258.62 $12,660,441.91 $41,372,398.04 1 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS ung 002 � Debt Service =und _ -ora-- $6,726,407.00 $0.00 $6,726,407.00 $0.00 $0.00 $1,589,084.42 $5,137,322.58 24% $5,003,810.91 $6,726,407.00 $0.00 $61726,407.00 P) $0.00 $0.00 $1,589,084.42 $5,137,322.58 $5,003,810.91 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD -ung 002 _ Debt _ v_ �d EXPENSE tecta- -s .00 .00 .00 .00 .00 .00 .00 +++ 1411795.82 Other Exx .00 .00 .00 .00 .00 .00 +++ .00 P--ncba 31812,499.00 .00 31812,499.00 .00 .00 57,498.16 31755,000.84 2 41209,834.17 trst Expense 21910,408.00 .00 2,910,408.00 .00 .00 1,530,280.26 1,380,127.74 53 648,467.42 Bang & F-sca- s 3,500.00 .00 31500.00 .00 .00 11306.00 21194.00 37 31713.50 terfd Transfers .00 .00 .00 .00 .00 .00 .00 +++ .00 Other Fnnndncj uses .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS ung 002 � Debt Service =und _ -ora-- $6,726,407.00 $0.00 $6,726,407.00 $0.00 $0.00 $1,589,084.42 $5,137,322.58 24% $5,003,810.91 $6,726,407.00 $0.00 $61726,407.00 P) $0.00 $0.00 $1,589,084.42 $5,137,322.58 $5,003,810.91 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS v _ _ $2,603,440.00 $860,000.00 $3,463,440.00 $91,629.10 $509,004.58 $902,586.45 $21051,848.97 41% $711,652.64 $2,603,440.00 $860,000.00 $3,463,440.00 $91,629.10 $509,004.58 $902,586.45 $2,0511848.97 3 $711,652.64 Adopted Budget Amended Current - YTD % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD -ung 0 _ Cap-timprovement �d EXPENSE tecta- -s 79,590.00 15,000.00 94,590.00 .00 .00 11399.90 93,190.10 1 126,960.50 Other Exv- 495,000.00 .00 495,000.00 5,440.39 61,210.32 29,592.48 404,197.20 18 .00 Lama Improvements 400,000.00 .00 400,000.00 .00 .00 (13,131.20) 413,131.20 -3 10,000.00 - - - Improvements 266,000.00 , , , ,4 , 280.27 298,803.02 36 3,134.25 egg- --et .00 .00 .00 .00 .00 .00 .00 +++ .00 Motor - gent 82,000.00 .00 82,000.00 .00 .00 .00 82,000.00 0 .00 Other --t 572,100.00 101,500.00 673,600.00 39,907.33 58,717.88 515,957.20 98,924.92 85 171,577.49 i-f-astructure 708,750.00 545,000.00 1,253,750.00 311409.97 297,659.67 2941487.80 661,602.53 47 399,980.40 lnu--TUnu _ rsrs .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS v _ _ $2,603,440.00 $860,000.00 $3,463,440.00 $91,629.10 $509,004.58 $902,586.45 $21051,848.97 41% $711,652.64 $2,603,440.00 $860,000.00 $3,463,440.00 $91,629.10 $509,004.58 $902,586.45 $2,0511848.97 3 $711,652.64 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS und ver - - - --- - - tos 02"1 � Street $3,772,000.00 $905,000.00 $4,677,000.00 $50,069.42 $1,966,938.20 $1,953,537.18 $756,524.62 84% $2,568,598.72 $3,772,000.00 $905,000.00 $4,677,000.00 $50,069.42 $1,966,938.20 $1,953,537.18 $756,524.62 0 $2,568,598.72 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD unL improvementt EXPENSE tecta- -s 40,000.00 .00 40,000.00 .00 26,985.50 11,575.50 1,439.00 96 18,631.00 Other Exx .00 .00 .00 .00 .00 .00 +++ .00 Lama Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 -grstrctr 3,732,000.00 905,000.00 41637,000.00 50,069.42 1,939,952.70 1,941,961.68 755,085.62 84 2,549,967.72 inrlerfund _ rsrs .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS und ver - - - --- - - tos 02"1 � Street $3,772,000.00 $905,000.00 $4,677,000.00 $50,069.42 $1,966,938.20 $1,953,537.18 $756,524.62 84% $2,568,598.72 $3,772,000.00 $905,000.00 $4,677,000.00 $50,069.42 $1,966,938.20 $1,953,537.18 $756,524.62 0 $2,568,598.72 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS U a 02 Con $3,760,500.00 $461,000.00 $4,221,500.00 $282,685.78 $516,153.17 $898,343.31 $2,807,003.52 34% $416,487.86 $3,760,500.00 $461,000.00 $41221,500.00 $282,685.78 $516,153.17 $898,343.31 $2,807,003.52 5 $416,487.86 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD EXPENSE tecta- -s 120,000.00 .00 120,000.00 41659.73 14,384.71 69,756.03 35,859.26 70 75,446.18 t -_-ties 31500.00 .00 31500.00 29.81 .00 2,160.32 11339.68 62 1,878.22 _�-t-s --s 5,000.00 .00 5,000.00 .00 .00 2,459.00 2,541.00 49 2,486.20 Other "-tures 21000.00 .00 2,000.00 .00 .00 1,000.00 1,000.00 50 1,000.00 Other --t .00 .00 .00 .00 .00 .00 .00 +++ .00 D-st-but-on Systems 80,000.00 .00 80,000.00 3,648.75 31650.00 18,323.75 58,026.25 27 36,161.04 rstrtr 3,550,000.00 461,000.00 4,011,000.00 274,347.49 498,118.46 804,644.21 2,708,237.33 32 299,516.22 EXPENSE TOTALS U a 02 Con $3,760,500.00 $461,000.00 $4,221,500.00 $282,685.78 $516,153.17 $898,343.31 $2,807,003.52 34% $416,487.86 $3,760,500.00 $461,000.00 $41221,500.00 $282,685.78 $516,153.17 $898,343.31 $2,807,003.52 5 $416,487.86 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS Un $24,936,982.00 $0.00 $24,936,982.00 $1,488,627.08 $0.00 $8,643,166.61 $16,293,815.39 35% $958,126.73 $24,936,982.00 $0.00 $24,936,982.00 $1,488,627.08 L0 $0.00 $8,643,166.61 $16,293,815.39 $958,126.73 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD I Const. EXPENSE tecta- -s 2,3161174.00 .00 21316,174.00 47,853.77 .00 504,681.79 11811,492.21 22 958,126.73 -_- - r vmems 22,620,808.00 .00 22,620,808.00 11440,773.31 .00 81138,484.82 14,482,323.18 36 .00 P--nc-i)a .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS Un $24,936,982.00 $0.00 $24,936,982.00 $1,488,627.08 $0.00 $8,643,166.61 $16,293,815.39 35% $958,126.73 $24,936,982.00 $0.00 $24,936,982.00 $1,488,627.08 L0 $0.00 $8,643,166.61 $16,293,815.39 $958,126.73 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS -- D-SDosa _ Fund Tota $55,000.00 $4,557,185.00 $433,441.70 $14,057.20 $3,686,323.85 $856,803.95 81% $3,602,969.09 $4,502,185.00 $55,000.00 $4,557,185.00 $433,441.70 $14,057.20 $3,686,323.85 $856,803.95 $3,602,969.09 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD -ung 040 _ Refuse D-SDOsa- �d EXPENSE Persona- Sere -s', Sa-r-sces 254,632.00 .00 254,632.00 34,674.97 .00 243,965.10 10,666.90 96 2041746.30 - _ � -efts 112,676.00 .00 112,676.00 11,229.71 .00 107,059.30 51616.70 95 100,568.07 Otr Emp-ovee Costs 11350.00 .00 1,350.00 .00 .00 11573.00 (223.00) 117 481.94 otrt- -s 4 084 523.00 55 000.00 4 139f523.00 379 624.12 9 500.00 31292,392.67 837 630.33 80 31242f426.17 t- -t-s 483.00 .00 483.00 13.01 .00 136.10 346.90 28 131.54 sr 6,942.00 .00 6,942.00 578.50 .00 5,785.00 1,157.00 83 22,227.50 -ties & SUDS -s 41,579.00 .00 41,579.00 7,321.39 41557.20 35,412.68 11609.12 96 32,387.57 EXPENSE TOTALS -- D-SDosa _ Fund Tota $55,000.00 $4,557,185.00 $433,441.70 $14,057.20 $3,686,323.85 $856,803.95 81% $3,602,969.09 $4,502,185.00 $55,000.00 $4,557,185.00 $433,441.70 $14,057.20 $3,686,323.85 $856,803.95 $3,602,969.09 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS und 041 � Motor-- Tax Vund _ Vit - $1,867,173.00 $218,000.00 $2,085,173.00 $19,286.19 $143,730.49 $1,529,936.84 $411,505.67 80% $1,463,542.54 $1,867,173.00 $218,000.00 $2,085,173.00 $19,286.19 $143,730.49 $1,529,936.84 $411,505.67 L $1,463,542.54 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD -ung 0 _ motor Me I ax -und EXPENSE act aServ-ces 360,173.00 .00 360,173.00 19,286.19 103,425.25 2171416.13 39,331.62 89 288,291.66 t -_-ties 200,000.00 .00 200,000.00 .00 .00 83,555.85 116,444.15 42 135,215.40 _m -t -s --s 357,000.00 .00 357,000.00 .00 11,256.17 211,670.21 134,073.62 62 210,076.48 Buki-ng Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 -n—astructure 950,000.00 218,000.00 11168,000.00 .00 29,049.07 1,017,294.65 121,656.28 90 829,959.00 EXPENSE TOTALS und 041 � Motor-- Tax Vund _ Vit - $1,867,173.00 $218,000.00 $2,085,173.00 $19,286.19 $143,730.49 $1,529,936.84 $411,505.67 80% $1,463,542.54 $1,867,173.00 $218,000.00 $2,085,173.00 $19,286.19 $143,730.49 $1,529,936.84 $411,505.67 L $1,463,542.54 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS r _ CDBG _ t -s $365,649.00 $101,322.00 $466,971.00 ($10,396.01) $0.00 $240,317.44 $226,653.56 51% $365,507.17 $365,649.00 $101,322.00 $466,971.00 ($10,396.01) 9 $0.00 $240,317.44 $226,653.56 $365,507.17 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD -ung 042 EXPENSE Persona- Sere -s', -r-sces 371492.00 (37,492.00) .00 .00 .00 .00 .00 +++ 221277.50 r -y is 6,157.00 (6,157.00) .00 .00 .00 .00 .00 +++ 4,101.30 Otr Emp-ovee Costs 11126.00 (490.00) 636.00 .00 .00 72.24 563.76 11 11044.12 Cotrt- -s 320,313.00 146,022.00 466,335.00 (10,396.01) .00 240,245.20 226,089.80 52 338,073.76 -t s & Supp -s 561.00 (561.00) .00 .00 .00 .00 .00 +++ 10.49 Other expend -tures .00 .00 .00 .00 .00 .00 .00 +++ .00 Lwa im- .00 .00 .00 .00 .00 .00 .00 +++ .00 --ding Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 -g-strtr .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS r _ CDBG _ t -s $365,649.00 $101,322.00 $466,971.00 ($10,396.01) $0.00 $240,317.44 $226,653.56 51% $365,507.17 $365,649.00 $101,322.00 $466,971.00 ($10,396.01) 9 $0.00 $240,317.44 $226,653.56 $365,507.17 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting AssetEXPENSE TOTALS - O -r_ -Fund _ otals $7,000.00 $27,000.00 $34,000.00 $2,565.97 $0.00 $21,057.20 $12,942.80 62% $40,115.85 $7,000.00 $27,000.00 $34,000.00 10 $2,565.97 $0.00 $21,057.20 $12,942.80 $40,115.85 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD 0 _ Asset und EXPENSE Other -m-ployee Costs 1,000.00 .00 11000.00 .00 .00 .00 11000.00 0 .00 trta- Stere s 3,000.00 .00 3,000.00 .00 .00 .00 31000.00 0 10,349.28 _� t s - s .00 .00 .00 .00 .00 .00 .00 +++ 13,583.58 Other --t 31000.00 27,000.00 30,000.00 2,565.97 .00 21,057.20 8,942.80 70 16,182.99 AssetEXPENSE TOTALS - O -r_ -Fund _ otals $7,000.00 $27,000.00 $34,000.00 $2,565.97 $0.00 $21,057.20 $12,942.80 62% $40,115.85 $7,000.00 $27,000.00 $34,000.00 10 $2,565.97 $0.00 $21,057.20 $12,942.80 $40,115.85 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS -U-10 04 A Federa $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 0% $0.00 $2,000.00 $0.00 $2,000.00 11 $0.00 $0.00 $0.00 $2,000.00 $0.00 Adopted Budget Amended Current % Used/ Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD 044 _ � - - _ - -q-t EXPENSE tecta- -s 1,000.00 .00 11000.00 .00 .00 .00 11000.00 0 .00 Bu -- -ng- -r r vis .00 .00 .00 .00 .00 .00 .00 +++ .00 Other --t 11000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 EXPENSE TOTALS -U-10 04 A Federa $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 0% $0.00 $2,000.00 $0.00 $2,000.00 11 $0.00 $0.00 $0.00 $2,000.00 $0.00 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS F Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS _ � Mm --n __-e� = - - - �--n - o to $68,000.00 $0.00 $68,000.00 $5,722.00 $0.00 $14,872.91 $53,127.09 22% $29,839.12 $68,000.00 $0.00 $68,000.00 13 $5,722.00 $0.00 $14,872.91 $53,127.09 $29,839.12 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD -ung 046_ � _ _ - �_re ax B Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD EXPENSE Pr nc p- .00 .00 .00 .00 .00 .00 .00 +++ .00 tests 11525,000.00 .00 11525,000.00 190,725.11 .00 907,554.84 6171445.16 60 774,310.54 EXPENSE TOTALS $1,525,000.00 $0.00 $1,525,000.00 $190,725.11 $0.00 $907,554.84 $617,445.16 60% $774,310.54 $1,525,000.00 $0.00 $1,525,000.00 $190,725.11 14 $0.00 $907,554.84 $617,445.16 $774,310.54 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS Bund -4 _ _ _ ___ _ __ _oia- $10,2291238.00 $805,000.00 $11,034,238.00 $288,435.93 $569,150.94 $1,572,474.52 $8,892,612.54 19% $10,767,638.86 $10,229,238.00 $805,000.00 $11,034,238.00 $288,435.93 $569,150.94 $1,572,474.52 $8,892,612.54 15 $10,767,638.86 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD unL Ma_ -� _ _It EXPENSE Other --y Costs 21700.00 .00 21700.00 .00 .00 600.00 21100.00 22 1,800.00 trta- Sere -s 283,300.00 .00 283,300.00 27,776.24 20,392.20 179,164.75 83,743.05 70 304,403.26 _�-t s -s 1,500.00 .00 1,500.00 .00 .00 .00 1,500.00 0 .00 Other "spend -tires 2f699,000.00 95 500.00 2 794 500.00 10 905.00 27 561.44 807f250.32 11959f688.24 30 10 390 162.35 Lanci Improvements .00 709,500.00 709,500.00 201,071.38 431,896.59 209,666.78 67,936.63 90 .00 rets 6,000,000.00 .00 61000,000.00 48,683.31 89,300.71 159,199.29 5,751,500.00 4 .00 rstrtr 810,000.00 .00 810,000.00 .00 .00 .00 810,000.00 0 .00 Bond r - .00 .00 .00 .00 .00 .00 .00 +++ .00 test Exs 4321738.00 .00 432,738.00 .00 .00 216,368.38 216,369.62 50 71,273.25 -sc- s .00 .00 .00 .00 .00 225.00 (225.00) +++ .00 terfd _ rsrs .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS Bund -4 _ _ _ ___ _ __ _oia- $10,2291238.00 $805,000.00 $11,034,238.00 $288,435.93 $569,150.94 $1,572,474.52 $8,892,612.54 19% $10,767,638.86 $10,229,238.00 $805,000.00 $11,034,238.00 $288,435.93 $569,150.94 $1,572,474.52 $8,892,612.54 15 $10,767,638.86 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS $19,549,572.00 $2,773,500.00 $22,323,072.00 $2,066,289.57 $4,436,544.72 $13,344,929.40 $4,541,597.88 80% $12,248,481.51 U-10 03-0 � Water and Sewer� -d To - $19,549,572.00 $2,773,500.00 $22,323,072.00 $2,066,289.57 $4,436,544.72 $13,344,929.40 $4,541,597.88 $12,248,481.51 16 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD 0- _ Water and Sewer EXPENSE Persona- Sere -s', Sa-r-sces 21199,835.00 .00 21199,835.00 245,619.77 .00 11828,839.30 370,995.70 83 117821496.26 r _ i ,240.00 ,240.00 , ,752.47 108,487.53 88 780,758.88y Otr Emp-ovee Costs 441464.00 41125.00 48,589.00 21766.23 .00 411721.85 6,867.15 86 38,978.81 Cf1fo-t-actua- -s 9 174 756.00 53 106.00 9 227 862.00 761 331.22 190f925.20 61801,303.59 2 235 633.21 76 6 657 485.06 t- -t-s 1621710.00 .00 1621710.00 17,871.86 .00 76,230.65 86,479.35 47 92,933.28 sr 1171789.00 .00 1171789.00 91815.75 .00 98,157.50 19,631.50 83 79,118.40 Commodities & SUDS -s 336,045.00 .00 336,045.00 36,112.73 55,594.47 203,741.83 76,708.70 77 164,889.76 Other Expenditures .00 .00 .00 .00 .00 .00 .00 +++ .00 B00 --s .00 .00 .00 .00 .00 .00 .00 +++ .00 Bu- Lj-ng Improvements 285,000.00 .00 285,000.00 1,710.00 17,890.00 31150.00 263,960.00 7 35,780.81 Off- -quipment 1,081.00 .00 11081.00 .00 .00 .00 11081.00 0 1,060.00 Other -int 2121429.00 .00 2121429.00 211720.17 421161.58 62,328.38 107,939.04 49 94,587.09 D-strbudon Systems 51561,142.00 21716,269.00 81277,411.00 885,333.23 41129,973.47 31294,937.83 8521499.70 90 21446,095.58 _€ rstrtr .00 .00 .00 .00 .00 .00 .00 +++ .00 Bond r--- 240,000.00 .00 240,000.00 .00 .00 .00 240,000.00 0 .00 merest "-X-p.ense 343,081.00 .00 343,081.00 .00 .00 171,541.00 171,540.00 50 741297.58 Banff -s- s .00 .00 .00 .00 .00 225.00 (225.00) +++ .00 tr _ srs .00 .00 .00 .00 .00 .00 .00 +++ .00 LO -!j r t .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $19,549,572.00 $2,773,500.00 $22,323,072.00 $2,066,289.57 $4,436,544.72 $13,344,929.40 $4,541,597.88 80% $12,248,481.51 U-10 03-0 � Water and Sewer� -d To - $19,549,572.00 $2,773,500.00 $22,323,072.00 $2,066,289.57 $4,436,544.72 $13,344,929.40 $4,541,597.88 $12,248,481.51 16 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS fund -_-- Parking - _ _ � _ otai $146,101.00 $40,000.00 $186,101.00 $6,616.50 $17,934.55 $71,804.05 $96,362.40 48% $109,944.30 $146,101.00 $40,000.00 $186,101.00 17 $6,616.50 $17,934.55 $71,804.05 $96,362.40 $109,944.30 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD -ung 03A_ _ --age Park -ng System EXPENSE Persona- Sere -s', Sa-r-sces 16,916.00 .00 16,916.00 11774.24 .00 13,712.76 31203.24 81 30,309.06 --y is 61825.00 .00 61825.00 589.69 .00 5,626.85 1,198.15 82 14,317.90 trt- Sergi -s 64,006.00 500.00 64,506.00 41228.82 2,559.55 48,163.94 13,782.51 79 29,730.70 msuranCn285.00 .00 285.00 23.75 .00 237.50 47.50 83 545.00 W-MMOO-Dres'aDD -s 563.00 4,000.00 4,563.00 .00 .00 563.00 4,000.00 12 11.64 Other expend -tures .00 .00 .00 .00 .00 .00 .00 +++ .00 ----- s .00 .00 .00 .00 .00 .00 .00 +++ .00 --ding Improvements 7,506.00 .00 71506.00 .00 .00 .00 71506.00 0 .00 -,--astructure 50,000.00 35,500.00 85,500.00 .00 15,375.00 3,500.00 66,625.00 22 35,030.00 trg _ rsrs .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS fund -_-- Parking - _ _ � _ otai $146,101.00 $40,000.00 $186,101.00 $6,616.50 $17,934.55 $71,804.05 $96,362.40 48% $109,944.30 $146,101.00 $40,000.00 $186,101.00 17 $6,616.50 $17,934.55 $71,804.05 $96,362.40 $109,944.30 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS Bund _ _ - _t� - $155,108.00 $0.00 $155,108.00 $20,974.09 $9,354.09 $98,960.94 $46,792.97 70% $120,635.92 $155,108.00 $0.00 $155,108.00 $20,974.09 $9,354.09 $98,960.94 $46,792.97 $120,635.92 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD unL 0� ue EXPENSE Persona- Sere -s', Sa-r-sces 15,576.00 .00 15,576.00 11774.26 .00 13,813.55 11762.45 89 221174.35 --y its 6,562.00 .00 6,562.00 590.21 .00 5,638.66 923.34 86 10,548.33 tractus- - 112,083.00 .00 112,083.00 18,516.23 9,354.09 69,545.24 33,183.67 70 67,980.05 U, - -t-s 91799.00 .00 9,799.00 69.06 .00 2,634.54 7,164.46 27 4,235.21 insurance 292.00 .00 292.00 24.33 .00 243.30 48.70 83 805.80 Commodities & Supp -s 10,796.00 .00 10,796.00 .00 .00 7,085.65 3,710.35 66 5,108.83 Other t -gid -tures .00 .00 .00 .00 .00 .00 .00 +++ .00 Bui-dinas. .00 .00 .00 .00 .00 .00 .00 +++ .00 - -Improvements .00 .00 .00 .00 .00 .00 .00 +++ 9,783.35 trg _ rrs .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS Bund _ _ - _t� - $155,108.00 $0.00 $155,108.00 $20,974.09 $9,354.09 $98,960.94 $46,792.97 70% $120,635.92 $155,108.00 $0.00 $155,108.00 $20,974.09 $9,354.09 $98,960.94 $46,792.97 $120,635.92 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS n - Veh-i----e Maintenance-und _ otals $2,034,247.00 $0.00 $2,034,247.00 $198,897.91 $106,279.94 $1,761,927.33 $166,039.73 92% $1,797,249.24 $2,034,247.00 $0.00 $2,034,247.00 $198,897.91 $106,279.94 $1,761,927.33 $166,039.73 19 $1, 797, 249.24 Adopted Budget Amended Current % Used/ Classificatio n Budget Amendments Budget Transactionsr r s ci Transactions c' ri r Year YTD ---e Maintenance EXPENSE Persona- Sere -s', -r-sces 947,587.00 .00 947,587.00 108,304.70 .00 839,568.80 108,018.20 89 811,645.57 rm-y its 357,549.00 .00 357,549.00 34,191.23 .00 312,952.14 44,596.86 88 436,094.84 Otr Emp-ovee Costs 4,167.00 .00 41167.00 388.00 .00 41129.90 37.10 99 31984.03 Cotrt- -s 111,883.00 .00 111,883.00 71049.20 14,272.76 841770.97 12,839.27 89 76,897.78 T -t-s 3,392.00 .00 3,392.00 279.60 .00 3,568.28 (176.28) 105 4,127.12 sr 111706.00 .00 11,706.00 975.50 .00 9,755.00 1,951.00 83 .00 Commodities & SUDD--es 593,408.00 3,074.00 596,482.00 47,254.52 92,007.18 506,323.95 (11849.13) 100 460,697.70 Other -tures .00 .00 .00 .00 .00 .00 .00 +++ .00 0gg- Equipment 614.00 .00 614.00 .00 .00 70.42 543.58 11 298.20 Other --t 31941.00 (3,074.00) 867.00 455.16 .00 787.87 79.13 91 31504.00 EXPENSE TOTALS n - Veh-i----e Maintenance-und _ otals $2,034,247.00 $0.00 $2,034,247.00 $198,897.91 $106,279.94 $1,761,927.33 $166,039.73 92% $1,797,249.24 $2,034,247.00 $0.00 $2,034,247.00 $198,897.91 $106,279.94 $1,761,927.33 $166,039.73 19 $1, 797, 249.24 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS a s n- 061 � Veh-c_ _ _ d o£ $1,073,000.00 $852,000.00 $1,925,000.00 $22,919.84 $129,910.96 $1,304,825.76 $490,263.28 75% $733,019.32 $1,073,000.00 $852,000.00 $1,925,000.00 $22,919.84 $129,910.96 $1,304,825.76 $490,263.28 20 $733,019.32 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD -ung 06 _ -_- e ReD-acement EXPENSE Other -d tures .00 .00 .00 .00 .00 .00 .00 +++ .00 Motor -aubment 11073,000.00 852,000.00 11925,000.00 22,919.84 129,910.96 11304,825.76 490,263.28 75 733,019.32 lnle-;rrum _ r s rs .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS a s n- 061 � Veh-c_ _ _ d o£ $1,073,000.00 $852,000.00 $1,925,000.00 $22,919.84 $129,910.96 $1,304,825.76 $490,263.28 75% $733,019.32 $1,073,000.00 $852,000.00 $1,925,000.00 $22,919.84 $129,910.96 $1,304,825.76 $490,263.28 20 $733,019.32 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS $412,900.00 $75,000.00 $487,900.00 $14,529.45 $33,833.05 $122,839.35 $331,227.60 32% $65,104.39 $412,900.00 $75,000.00 $487,900.00 $14,529.45 21 $33,833.05 $122,839.35 $331,227.60 $65,104.39 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD EXPENSE Other -d-tures .00 .00 .00 .00 .00 .00 .00 +++ .00 -_- - 250,000.00 .00 250,000.00 .00 .00 .00 250,000.00 0 .00 egg Equipment 162,900.00 75,000.00 237,900.00 14,529.45 33,833.05 122,839.35 811227.60 66 65,104.39 EXPENSE TOTALS $412,900.00 $75,000.00 $487,900.00 $14,529.45 $33,833.05 $122,839.35 $331,227.60 32% $65,104.39 $412,900.00 $75,000.00 $487,900.00 $14,529.45 21 $33,833.05 $122,839.35 $331,227.60 $65,104.39 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS n _ R-sk Management - _ of -s $9,208,873.00 $0.00 $9,208,873.00 $1,035,251.00 $0.00 $8,288,240.00 $920,633.00 90% $81321,572.88 $9,208,873.00 $0.00 $9,208,873.00 $1,035,251.00 22 $0.00 $8,288,240.00 $920,633.00 $8,321,572.88 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD -ung 063 _ R-sk Management -und EXPENSE tecta- -s 40,000.00 .00 40,000.00 .00 .00 41800.00 35,200.00 12 16,200.00 msuranrn 91146,373.00 .00 91146,373.00 1,035,133.09 .00 8,279,150.02 8671222.98 91 8,295,925.98 _�-t-s --s 22,500.00 .00 22,500.00 66.15 .00 4,238.22 18,261.78 19 8,334.25 Other t .00 .00 .00 51.76 .00 51.76 (51.76) +++ 1,112.65 inrlerfund _ rsrs .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS n _ R-sk Management - _ of -s $9,208,873.00 $0.00 $9,208,873.00 $1,035,251.00 $0.00 $8,288,240.00 $920,633.00 90% $81321,572.88 $9,208,873.00 $0.00 $9,208,873.00 $1,035,251.00 22 $0.00 $8,288,240.00 $920,633.00 $8,321,572.88 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS -- - -_ � - - t -s � --s-n - -- -_ $5,985,209.00 $0.00 $5,985,209.00 $524,146.77 $0.00 $4,992,981.87 $992,227.13 83% $4,572,858.46 $5,985,209.00 $0.00 $5,985,209.00 $524,146.77 23 $0.00 $4,992,981.87 $992,227.13 $4,572,858.46 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD OZ _ P0we Pension EXPENSE Pe-S-OnBenef-is 5,790,809.00 .00 51790,809.00 503,931.42 .00 41879,104.31 9111704.69 84 41465,788.09 I-owactual rv-s 167,300.00 .00 167,300.00 20,215.35 .00 105,877.56 611422.44 63 98,880.37 Insuranc.e 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 .00 omm -t- s & SUDD--ec 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 ether-trs 12,000.00 .00 12,000.00 .00 .00 81000.00 41000.00 67 81190.00 Office _ - _ gent .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS -- - -_ � - - t -s � --s-n - -- -_ $5,985,209.00 $0.00 $5,985,209.00 $524,146.77 $0.00 $4,992,981.87 $992,227.13 83% $4,572,858.46 $5,985,209.00 $0.00 $5,985,209.00 $524,146.77 23 $0.00 $4,992,981.87 $992,227.13 $4,572,858.46 Mount Plrospc Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: DIRECTOR OF FINANCE DATE: NOVEMBER 25, 2019 SUBJECT: MONTHLY FINANCIAL REPORT — OCTOBER 2019 Attached hereto are the cash position and investment statements of the Village for the month ended October 31, 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 September 30 was $91.0 million. During October, cash receipts totaled $6.9 and investment income was $111,843. Reductions in cash and cash equivalents during October totaled $8,945,275. Of this amount, payments to vendors were $6,605,327 and employee payroll expenses were $2,328,929. Outflows resulting from interfund activity totaled $327,899 while other reductions to cash totaled $11,018. There was also a net transfer from investment of $1,521,325. Cash and cash equivalents at October 31 were $90.2 million. Investments in the Governmental and Enterprise Funds at September 30 were $11,857,564. Investment activity during the month of October included investment income totaling $19,720 and a net transfer to cash of $1,521,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 October 31 were $10,355,959. Total cash and investments for Governmental and Enterprise Funds at September 30 were $102,901,016. Cash and investments decreased $2,298,546 for the month. Cash and investments at October 31 totaled $100,602,470. Monthly Financial Report — October 2019 November 25, 2019 Page 2 Trust and Agency Funds - Cash and cash equivalents at September 30 was $3,931,705. During October, cash receipts totaled $330,166. Investment income for the month was $96,149. Cash investment activities resulted in a net increase of $56,015 while inflows due to Interfund activity totaled $372,899. Reductions in cash and cash equivalents during September totaled $1,068,986. Of this amount, payments to vendors were $182,297 and employee payroll/pension and related expenses were $871,245. Other disbursements totaled $15,443. Cash and cash equivalents at October 31 were $3,717,951. Total investments at October 31 were $142,599,228, an increase of $1,925,797 from September 30. Investment income of $1,981,812 and a net transfer to cash and cash equivalents of $56,015 accounted for the change. Total cash and investments for Trust and Agency Funds at September 30 were $144,605,136. Cash and investments increased $1,712,042 for the month and totaled $146,317,178 at October 31. Summary of Cash Activity by Fund Type (page 5) This report provides the cash activity for the month by fund type. This report is useful in identifying where the activity (receipts and disbursements) is occurring. Activity in funds such as the Capital Projects and Special Revenue Funds is higher than normal certain times of the year. The General Fund, the Village's primary operating fund, tends to be more level and predictable in terms of spending and receipt of revenue. Each month this report will provide detail explanation on activity of the General Fund. Other Fund activity will be highlighted as warranted. Detail on the activity of the General Fund follows. General Fund — Cash and cash equivalents at October 31 totaled $23,159,535. During October, cash receipts totaled $3,957,628, and investment income was $21,678. 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 October totaled $2,484,376. Sales taxes received in October are for taxes generated from sales in August. There is a two-month lag in receiving sales tax distributions from the state. The General Fund allocation of the one percent Home Rule Sales Tax distribution is 0.25 percent. Allocation of the home rule sales tax distributions is completed by priority. First priority is Debt Service and Street Construction Fund allocations, second priority is Flood Control and Capital Improvement Fund allocations, and third priority is the General Fund allocation. Distributions are expected to be allocated to the General Fund later in the year. Income tax revenues distributed from the State of Illinois received during September totaled $575,039. Income taxes collected by the State in August are received by the Village in October. Disbursements from the General Fund for October included payments to vendors of $1,952,854, interfund transfers of $1,231,751, payments for employee wages and benefits of $2,074,431 and other disbursements of $2,786. Total Cash and cash equivalents and, Investments at October 31 were $21,923,670, a decrease of $1,282,516 from September 30. In addition, investments consisting of certificates of deposit were $1,235,865. Cash and investments for the General Fund at October 31 totaled $23,159,535. Monthly Financial Report — October 2019 November 25, 2019 Page 3 Statement of Investments (page 6-7) This statement provides a listing of investments for governmental and enterprise funds and trust and agency funds. The report also provides details of the investments for each fund. Government and Enterprise Funds - Investments for the governmental and agency funds are made up of Certificates of Deposit and other fixed income investments. At October 31, $10,355,959 was invested in CD's and various governmental notes. These notes and CD's consist of surplus monies available from the governmental and enterprise funds. Total investments for the governmental and enterprise funds includes proceeds from the Series 2018B and 2019A bonds invested in various maturities which will be drawn down over a period of 12-15 months as the construction work is completed on the new Police and Fire headquarters as well as for the water -main and sewer projects. A detail list of holdings is included with this report. Trust and Agency Funds — The investments for the trust and agency funds are made up of certificates of deposits, fixed income investments and equity mutual funds. CD's (if any) held in the Escrow Deposit Fund will generally have maturities of between 30 and 120 days. Most of the reserves for this fund are invested in the money market account due to the nature of the deposit. At October 30, there was a total of $145,115,263 invested in a combination of fixed income and equity instruments. A list of holdings is included with this report. Escrow refunds are processed two times per month. Investment of the Village's pension funds is governed by an Investment Policy adopted by each Pension Board. Investments for the Police and Firefighter Pension Funds consist of various fixed income securities as well as equity mutual fund accounts. Wells Fargo is the third -party holder of the fixed income securities. The funds are managed by three investment management firms, Galliard, Segall Bryant and Mesirow Financial. Segall Bryant holds approximately half of the fixed income investments for the two pension funds while Galliard and Mesirow manage the balance of fixed income investments for these two funds. Each manager maintains a small portion of their portfolio in cash to help facilitate liquidity and trading. Investments in equities consist of mutual funds spread across various sectors (small, mid and large -cap stocks) as well as investment philosophies (value, core and growth). The funds also invest a small amount in international stocks. Each year the investment mix is evaluated for optimal diversification to meet pension fund investment policy goals and objectives. Equity investments held by the Police Pension Fund are managed by Sawyer Falduto Asset Management. Conclusion The cash position, investment statements, and budget revenue & expenditure summaries provide valuable information regarding the status of the Village's financials. These reports are provided to the Village Board and Finance Commission on a monthly basis. The cash position report is intended to provide a snapshot of the Village's cash position at month end. Using this report, we are able to provide trend information to support cash management and maximize investment earnings while ensuring availability of funds to meet the Village's commitments. If you have any questions on the statements or this report, please contact me. Amit Thakkar Director of Finance VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended October 31, 2019 GOVERNMENTAL AND ENTERPRISE FUNDS TRUST AND AGENCY FUNDS Cash and Cash Total Cash and Equivalents Investments Investments Balance at September 30, 2019 $ 91,043,452.45 $ 11,8573563.57 $ 1027901,016.02 Cash receipts 6,888,064.80 678881064.80 Investment income 1113843.39 197720.47 1311563.86 Transfers from investments to cash 135213325.00 (17521)325.00) - Transfers to investments from cash - - - Interfund activity (3723899.30) (372,899.30) Disbursements: Accounts payable (61605)327.01) (67605,327.01) Payroll (21328)929.97) (27328,929.97) Other (11)018.38) (11)018.38) Other (214.06) Balance at October 31, 2019 $ 90,2463510.98 $ 10,3551959.04 $ 1007602,470.02 TRUST AND AGENCY FUNDS * Assets are restricted in purpose and do not represent discretionary assets of the government. Cash and Cash Total Cash and Equivalents Investments Investments Balance at September 30, 2019 $ 319315705.21 $ 140,6731430.94 $ 144,6051136.15 Cash receipts 3305166.12 330,166.12 Investment income (loss) 96,149.90 1,981,812.30 27077,962.20 Transfers from investments to cash 4,249,991.55 (47249)991.55) - Transfers to investments from cash (41193)975.81) 4,193,975.81 - Interfund activity 372,899.30 3727899.30 Disbursements: Accounts payable (182)297.36) (1827297.36) Payroll (871)245.79) (8717245.79) Flex spending (15,228.46) (15)228.46) Other (214.06) (214.06) Balance at October 31, 2019 $ 3,717,950.60 $ 142,599,227.50 $ 14673171178.10 * Assets are restricted in purpose and do not represent discretionary assets of the government. VILLAGE OF MOUNT PROSPECT Summary of Cash Activity by Fund Type For the Month Ended October 31, 2019 GOVERNMENTAL AND ENTERPRISE FUNDS TRUST AND AGENCY FUNDS* SPECIAL REVENUE DEBT SERVICE CAPITAL PROJECTS ENTERPRISE INTERNAL TOTAL GOVT_ AND ENTERPRISE FIRE AND POLICE OTHER TRUST CASH & CASH EQUIVALENTS GENERAL FUND FUNDS —FUNDS — FUNDS FUNDS SERVICE FUNDS FUNDS PENSIONS AND AGENCY — FUNDS TOTAL — Beginning balance Cash receipts $ 23,206,185.66 3,957,627�93 7,147,24439 831,968.25 $ 6,137,427,20 24,253.60 $ 23,445,035,00 $ 22,045,250-19 $ 9,062,310 � 01 $ 91,043,452,45 2,791,564.87 $ 1,140,140� 34 - $ 94,975,157�66 Investment income 21,678,36 5,56635 6,331,88 546,44T00 39,043=88 1,394,832.22 28,813.22 132,935.80 6,888,064.80 207,072-33 123,093.79 7,218,230.92 Transfers from investments - - - 1,521,325.00 10,409.70 111,843,39 95,170.10 979.80 207,993.29 Transfers to investments - - - 1,521,325.00 4,249,991.55 - 5,771,31655 Interfund Disbursements -ether (1,231,751-52) (2,785.88) 27,780.06 (1,010-14) (401.42) (148,707.01) - 960,180.59 (372,899.30) (4,193,975.81) 380,089.75 (7,190,45) (4,193,975.81) 0�00 Disbursements - flexible spending (7,222.36) - (11,018.38) - (214.06) (11,232.44) Disbursements -payroll Disbursements -accounts payable (2,074,430,86) (1,952 8-5-1 qQ1 (21,022 12) (954,617.29� (1,724,501 17) (162,500 52) (70,976.47) (2,328,929.97) (871,245�79) (15,228.46) (15,228,46) (3,200,175-76) (842.734.47) (1.130.620,09) (6,605,327.011 (142.631:L5) 39 666_01 (�) �6,787,62�_�.37) Ending balance 21,923,669.70 7,035,909.50 6,167.611.26 23,827,34971 22,307,731.27 8,984,239-54 90,246,510�98 2,516,035.65 1.201t91495 93,,964.461.58 INVESTMENTS U.S. Treasury and Agency Notes and Certificates of Deposit Wells Fargo investments 1,235,864.86 6,594,47732 - 2,525,616-46 10,355,9%Q4 10,355,959.04 Mutual fund investments 47,539,108.76 47,539,10836 95,060,118,74 95,060,118.74 to Total investments 1,235.864.86 m a6,594,477,72 2,525.616.46 10,355,959.04 142,599,227-50 152,955,186-54 TOTAL CASH AND INVESTMENTS 23,155534-56 $ 7,035,909.50 $ 6,167,611.26 $ 30,421,827.43 $ 307,731.27 11,505856-00 $ 100,602,470.02 $145,115,263.15 $ 1,201,914.95 $246,919,648-12 Assets are restricted in purpose and do not represent discretionary assets of the government. VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of October 31, 2019 GOVERNMENTAL AND ENTERPRISE FUNDS Maturity Purchase Financial Investment CUSIP/ Market Date Date Institution Description FDIC # Net Yield Value GENERAL FUND (001) 12/13/19 12/28/17 Federal Home Loan Bank Agency Notes 3130AOJR2 2.375% $ 1,235,864.86 1,2351864.86 POLICE & FIRE BUILDING CONSTRUCTION FUND (025) 12/04/19 12/21/18 Capital Community Bank, UT Certificate of Deposit 33823 2.730% 2431600.00 12/04/19 12/21/18 Northeast Community Bank, NY Certificate of Deposit 29147 2.727% 2431600.00 12/04/19 12/21/18 First Capital Bank, TN Certificate of Deposit 57552 2.650% 2431800.00 12/04/19 12/21/18 Bank of China, NY Certificate of Deposit 33653 2.590% 2431900.00 12/04/19 12/21/18 Orrstown Bank, PA Certificate of Deposit 713 2.520% 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% 1J741373.73 01/31/20 12/21/18 US Treasury Note US Treasury Note 912828H52 2.599% 110891063.69 02/29/20 12/21/18 US Treasury Note US Treasury Note 912828UQI 2.641% 110101735.00 04/08/20 12/21/18 Servisfirst Bank, FL Certificate of Deposit 57993 2.784% 2411200.00 04/08/20 12/21/18 Cornerstone Bank -York NE Certificate of Deposit 5496 2.687% 2411500.00 04/08/20 12/21/18 Sonabank, VA Certificate of Deposit 57968 2.691% 2411500.00 04/08/20 12/21/18 Bank OZK, AR Certificate of Deposit 110 2.623% 2411700.00 05/06/20 12/21/18 CFG Community Bank, MD Certificate of Deposit 34294 2.743% 2401900.00 05/06/20 12/21/18 First Internet Bank of Indiana, IN Certificate of Deposit 34607 2.725% 240,900.00 05/06/20 12/21/18 Modern Bank, National Association, NY Certificate of Deposit 22398 2.640% 1681305.30 05/06/20 12/21/18 Newbank, NA, NY Certificate of Deposit 58203 2.640% 2411200.00 615941477.72 VEHICLE REPLACEMENT FUND (061) 06/12/20 12/28/17 Federal Home Loan Bank Agency Notes 313383MB4 1.875% 112521251.49 12/11/20 12/28/17 Federal Home Loan Bank Agency Notes 3130A3UQ5 1.875% 112521985.16 2,505,236.65 RISK MANAGEMENT FUND (063) 03/06/21 03/06/19 Mount Prospect State Bank Certificate of Deposit 354058 2.750% 201379.81 20,379.81 TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS $ 1013551959.04 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of October 31, 2019 Maturity Purchase Financial Date Date Institution POLICE PENSION FUND (070) Various Various Wells Fargo Various Various Various TRUST AND AGENCY FUNDS * Investment CUSIP/ Description Acct # Wells Fargo Investments Various Mutual Fund Investments Various FIRE PENSION FUND (071) Various 5/26/2015 Principal Life Insurance Company Various Various Wells Fargo Various Various Various TOTAL TRUST AND AGENCY FUND INVESTMENTS Group Annuity Contract Wells Fargo Investments Mutual Fund Investments * Assets are restricted in purpose and do not represent discretionary assets of the government. 7 8-10810 Various Various Interest Market Rate % Value Various $ 22,712,044.89 Various 51,410,732.34 74,122,777.23 Variable 6,391,501.04 Various 24,827,063.87 Various 37,25705.36 68,476,450.27 $ 14215991227.50 Expense Budget by Account Classification Report Through 10/31/19 Prior Fiscal Year Activity Included Summary fisting EXPENSE TOTALS $6,193,836.00 $0.00 $6,193,836.00 $529,640.62 $0.00 $5,368,269.89 $825,566.11 87% $51011,063.81 1 _ �_ Pens_ � _ t -s $6,193,836.00 $0.00 $6,193,836.00 $529,640.62 $0.00 $5,368,269.89 $825,566.11 $5,011,063.81 Grana Tota- $162,538,139.00 $71815,312.00 $170,353,451.00 $12,563,484.30 $9,231,900.36 $101,922,912.13 $59,198,638.51 $101,063,943.20 24 Adopted Budget Amended Current % Used/ Account Classification s Budget Transactionsr r s ci Transactions c' ri r Year YTD -ung 0 _ -----re Pension EXPENSE Pe -S -on -is 6,032,036.00 .00 61032,036.00 522,602.83 .00 51269,306.06 7621729.94 87 4,916,647.81 trta- r�ices 136,700.00 .00 136,700.00 7,037.79 .00 90,778.83 45,921.17 66 86,416.00 Insuranc.e 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 .00 omm -t- s & SUDD--ec 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 ether-trs 10,000.00 .00 10,000.00 .00 .00 81185.00 11815.00 82 81000.00 EXPENSE TOTALS $6,193,836.00 $0.00 $6,193,836.00 $529,640.62 $0.00 $5,368,269.89 $825,566.11 87% $51011,063.81 1 _ �_ Pens_ � _ t -s $6,193,836.00 $0.00 $6,193,836.00 $529,640.62 $0.00 $5,368,269.89 $825,566.11 $5,011,063.81 Grana Tota- $162,538,139.00 $71815,312.00 $170,353,451.00 $12,563,484.30 $9,231,900.36 $101,922,912.13 $59,198,638.51 $101,063,943.20 24