The URL can be used to link to this page

Home My WebLink About5.1 Monthly Financial Report - December 2018BoardDocs® Pro Agenda Item Details Meeting Category Subject Access Type Preferred Date Absolute Date Fiscal Impact Budgeted Recommended Action Page I of I Feb 05, 2019 - REGULAR MEETING OF THEM UT PROSPECT VILLAGE BOARD - 7:00 p.m. 5. CONSENT AGENDA 5.1 Monthly Financial Report - December 2018 Public Action (Consent) Feb 05, 2018 Feb 05, 2018 No No Public Content Information The monthly financial report contains a Cash Position Report and Fund Financials for the month ended December 31, 2018. Alternatives 1. Accept the monthly financial report for December 201 2. Action at discretion of Village Board. I Staff Recommendation Staff recommends the Village Board accept the monthly financial report for the month ended December 31, 2018. -ied 1: -i&ncials for BD 1.2-.201.8.pdf (34.2 KB) 1.2 December Board [Zeports for Upload pdf (348 KB) Combi�r 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. https://www.boarddocs.com/il/vomp/Board.nsf/Public 2/5/2019 VILLAGE OF MOUNT PROSPECT BUDGET REVENUE EXPENDITURE SUMMARIES December 1— December 31, 2018 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I 1 Adopted Fudgei: Amended Current Moriftis Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I und (Ml Gumillrall ll°iund REVENUE Plopelly la)(c's 16,540,000.00 .00 16,540,000.00 8,263.03 .00 16,379,813.17 160,186.83 99 16,112,039.55 01:her taxes 8,210,000.00 .00 8,210,000.00 647,586.26 .00 7,346,841.54 863,158.46 89 7,947,170.45 1 i(einses, 1101irritS& lees 1,417,000.00 .00 1,417,000.00 146,286.40 .00 1,783,833.35 (366,833.35) 126 1,416,127.09 Dfleigovelinirrelflal Revenue 24,883,860.00 .00 24,883,860.00 3,212,267.38 .00 25,850,428.95 (966,568.95) 104 25,986,586.49 chal jes I c,i 1;01 Vi(es 1,305,000.00 .00 1,305,000.00 72,318.98 .00 978,452.21 326,547.79 75 1,234,664.99 1 Ines & I c,i relts 437,000.00 .00 437,000.00 45,190.60 .00 395,053.96 41,946.04 90 425,439.11 Divesfirrent Dicuirre 205,000.00 .00 205,000.00 11,470.93 .00 316,400.07 (111,400.07) 154 132,924.83 Relirrhijiscirrents 218,900.00 .00 218,900.00 35,127.51 .00 205,500.40 13,399.60 94 178,007.18 01:her Revenue 251,500.00 .00 251,500.00 26,444.59 .00 480,498.46 (228,998.46) 191 369,003.93 011101 1 linallaing l;C,ui3Os .00 .00 .00 .00 .00 567,342.00 (567,342.00) +++ .00 REVENUE707ALS $53,468,260.00 $0.00 $53,468,260.00 $4,204,955.68 $0.00 $54,304,164.11 ($835,904.11) 102% $53,801,963.62 1 und (Ml Gumillrall ll:'iund fcN.als $53,468,260.00 $0.00 $53,468,260.00 $4,204,955.68 $0.00 $54,304,164.11 ($835,904.11) $53,801,963.62 1 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE TOTALS $5,011,668.00 $0.00 $5,011,668.00 $129,403.13 $0.00 $11,598,140.86 ($6,586,472.86) 231% $4,913,202.89 und 002 1)d7t Scivice ll:�iund I Nals $5,011,668.00 $0.00 $5,011,668.00 $129,403.13 $0.00 $11,598,140.86 ($6,586,472.86) $4,913,202.89 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I und W2 1)d7t Scivice ll°iund REVENUE Plopelly laxes 2,380,000.00 .00 2,380,000.00 .00 .00 2,390,000.00 (10,000.00) 100 2,284,000.00 011101 .l axes 1,012,518.00 .00 1,012,518.00 101,251.80 .00 1,012,518.00 .00 100 1,002,092.00 Dfleigovelinirrelflal Revenue 1,618,150.00 .00 1,618,150.00 21,063.92 .00 1,619,127.29 (977.29) 100 1,621,717.51 Divesfirrent Dicuirre 1,000.00 .00 1,000.00 7,087.41 .00 24,242.95 (23,242.95) 2424 5,393.38 011101 Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 011101 1 linallaing l;C,ui3Os .00 .00 .00 .00 .00 6,552,252.62 (6,552,252.62) +++ .00 REVENUE TOTALS $5,011,668.00 $0.00 $5,011,668.00 $129,403.13 $0.00 $11,598,140.86 ($6,586,472.86) 231% $4,913,202.89 und 002 1)d7t Scivice ll:�iund I Nals $5,011,668.00 $0.00 $5,011,668.00 $129,403.13 $0.00 $11,598,140.86 ($6,586,472.86) $4,913,202.89 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v �ity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE TOTALS $2,061,000.00 $0.00 $2,061,000.00 $885,422.13 $0.00 $2,128,634.59 ($67,634.59) 103% $2,017,934.34 1 and 020 . Callotall 1111,11pIrOV,11,111t lj:�iund I Nals $2,061,000.00 $0.00 $2,061,000.00 $885,422.13 $0.00 $2,128,634.59 ($67,634.59) $2,017,934.34 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 020 . Callotall 1111,11pIrOV,11,111t ll°iund REVENUE 011101 .l axes 1,300,000.00 .00 1,300,000.00 130,000.00 .00 1,300,000.00 .00 100 1,341,252.64 Dfleigovelinirrelflal Revenue .00 .00 .00 .00 .00 .00 .00 +++ 33,663.84 Divesfirrent Dicuirre 1,000.00 .00 1,000.00 5,422.13 .00 22,598.58 (21,598.58) 2260 9,117.86 Relirrhijiscirrents .00 .00 .00 .00 .00 .00 .00 +++ .00 011101 Revenue 10,000.00 .00 10,000.00 .00 .00 56,036.01 (46,036.01) 560 33,900.00 011101 1 linallaing l;0ui3Os 750,000.00 .00 750,000.00 750,000.00 .00 750,000.00 .00 100 600,000.00 REVENUE TOTALS $2,061,000.00 $0.00 $2,061,000.00 $885,422.13 $0.00 $2,128,634.59 ($67,634.59) 103% $2,017,934.34 1 and 020 . Callotall 1111,11pIrOV,11,111t lj:�iund I Nals $2,061,000.00 $0.00 $2,061,000.00 $885,422.13 $0.00 $2,128,634.59 ($67,634.59) $2,017,934.34 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE TOTALS I and 023 . Stjjr,it 1111,11pIrOV,11,111t CollSor, ll:�iund I Nals $3,662,000.00 $0.00 $3,662,000.00 $247,326.47 $0.00 $3,895,938.57 ($233,938.57) 106% $3,727,461.03 $3,662,000.00 $0.00 $3,662,000.00 $247,326.47 $0.00 $3,895,938.57 ($233,938.57) $3,727,461.03 Adopted Fudgei: Amended Current Moriftis Y7 D Y7 D Fudgei: - Y7 D Used/ Account Classificabon Budget Arnendrinerifts Budget Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 023 . Stjjr,it 1111,11pIrOV,11,111t CollSor, ll°iund REVENUE 011101 laxes 1,980,000.00 .00 1,980,000.00 237,769.60 .00 1,999,794.78 (19,794.78) 101 2,047,967.79 1 i(einses, 1101irritS& lees 1,650,000.00 .00 1,650,000.00 7,193.00 .00 1,601,050.50 48,949.50 97 1,648,264.50 Dfleigovelinirrelflal Revenue .00 .00 .00 .00 .00 24,235.51 (24,235.51) +++ .00 I Ines & I c,i relts .00 .00 .00 .00 .00 .00 .00 +++ .00 Divesfirrent Dicuirre 2,000.00 .00 2,000.00 2,363.87 .00 10,715.29 (8,715.29) 536 4,173.41 Relirrhijiscirrents .00 .00 .00 .00 .00 71,876.97 (71,876.97) +++ .00 01:1101 Revenue 30,000.00 .00 30,000.00 .00 .00 188,265.52 (158,265.52) 628 27,055.33 011101 1 linallaing l;C,ui3Os .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS I and 023 . Stjjr,it 1111,11pIrOV,11,111t CollSor, ll:�iund I Nals $3,662,000.00 $0.00 $3,662,000.00 $247,326.47 $0.00 $3,895,938.57 ($233,938.57) 106% $3,727,461.03 $3,662,000.00 $0.00 $3,662,000.00 $247,326.47 $0.00 $3,895,938.57 ($233,938.57) $3,727,461.03 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE TOTALS $339,000.00 $0.00 $339,000.00 $32,699.63 $0.00 $377,311.15 ($38,311.15) 111% $396,037.66 1 und 024 :flood Colljoroll CollSori,tjoll llimnd I Nall $339,000.00 $0.00 $339,000.00 $32,699.63 $0.00 $377,311.15 ($38,311.15) $396,037.66 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I and 024 11:110od Colljoroll CollSori,tjoll ll:imnd REVENUE 011101 laxes 288,000.00 .00 288,000.00 28,800.00 .00 288,000.00 .00 100 339,160.64 Dfleigovelinirrelflal Revellue .00 .00 .00 .00 .00 .00 .00 +++ .00 chal )es I c,i 1;01 VI(CS 25,000.00 .00 25,000.00 189.00 .00 50,595.00 (25,595.00) 202 26,783.00 Divesfirrent Dicuirre 6,000.00 .00 6,000.00 3,710.63 .00 18,716.15 (12,716.15) 312 10,270.52 Relirrhijiscirrents 20,000.00 .00 20,000.00 .00 .00 20,000.00 .00 100 19,823.50 011101 1 linallaing l;C,ui3Os .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $339,000.00 $0.00 $339,000.00 $32,699.63 $0.00 $377,311.15 ($38,311.15) 111% $396,037.66 1 und 024 :flood Colljoroll CollSori,tjoll llimnd I Nall $339,000.00 $0.00 $339,000.00 $32,699.63 $0.00 $377,311.15 ($38,311.15) $396,037.66 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE707ALS $0.00 $0.00 $0.00 $76,248.99 $0.00 $33,573,166.55 ($33,573,166.55) +++ $0.00 1 und 025 . 11,01111C, & lj:''Ijjjr, Illifildling Const I Nals $0.00 $0.00 $0.00 $76,248.99 $0.00 $33,573,166.55 ($33,573,166.55) $0.00 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I und 025 . 11,01111C, & ljII II, Illifildling Const REVENUE Divesfirrent Dicuirre .00 .00 .00 55,696.61 .00 140,239.19 (140,239.19) +++ .00 011101 Revenue .00 .00 .00 20,552.38 .00 20,552.38 (20,552.38) +++ .00 011101 1 linallaing l;C,ui3Os .00 .00 .00 .00 .00 33,412,374.98 (33,412,374.98) +++ .00 REVENUE707ALS $0.00 $0.00 $0.00 $76,248.99 $0.00 $33,573,166.55 ($33,573,166.55) +++ $0.00 1 und 025 . 11,01111C, & lj:''Ijjjr, Illifildling Const I Nals $0.00 $0.00 $0.00 $76,248.99 $0.00 $33,573,166.55 ($33,573,166.55) $0.00 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE TOTALS $4,337,000.00 $0.00 $4,337,000.00 $530,256.29 $0.00 $4,400,895.37 ($63,895.37) 101% $4,317,770.67 I und 040 Illefuse II)IIsliposall ll:�iund I Nals $4,337,000.00 $0.00 $4,337,000.00 $530,256.29 $0.00 $4,400,895.37 ($63,895.37) $4,317,770.67 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I und 040 Illefine II)IIsposall ll°iund REVENUE Plopelly taxes .00 .00 .00 .00 .00 .00 .00 +++ .00 Charges I c,i 1;01 VI(CS 4,175,000.00 .00 4,175,000.00 491,564.60 .00 4,200,221.82 (25,221.82) 101 4,148,685.53 1 Ines & I1tlorfelts 46,000.00 .00 46,000.00 1,755.97 .00 36,629.16 9,370.84 so 38,629.96 Divesfirrent Dicuirre 4,000.00 .00 4,000.00 2,011.79 .00 10,047.10 (6,047.10) 251 7,124.00 Relirrhijiscirrents 1,000.00 .00 1,000.00 24,088.36 .00 27,371.58 (26,371.58) 2737 18,339.04 011101 Revellue 111,000.00 .00 111,000.00 10,835.57 .00 126,625.71 (15,625.71) 114 104,992.14 REVENUE TOTALS $4,337,000.00 $0.00 $4,337,000.00 $530,256.29 $0.00 $4,400,895.37 ($63,895.37) 101% $4,317,770.67 I und 040 Illefuse II)IIsliposall ll:�iund I Nals $4,337,000.00 $0.00 $4,337,000.00 $530,256.29 $0.00 $4,400,895.37 ($63,895.37) $4,317,770.67 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v �ity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 042 . 11,40tolIr lj°,ijj u ax ll°iund REVENUE Dfleigovelinirrelflal Revenue 1,395,000.00 .00 1,395,000.00 239,829.38 .00 1,386,440.58 8,559.42 99 1,381,615.24 Divesfirrent Dicuirre 5,000.00 .00 5,000.00 5,899.29 .00 32,296.45 (27,296.45) 646 17,423.59 Relirrhijiscirrents 15,000.00 .00 15,000.00 1,206.00 .00 9,363.10 5,636.90 62 14,273.88 011101 Revenue .00 .00 .00 .00 .00 .00 .00 +++ 14,471.85 REVENUE TOTALS $1,415,000.00 $0.00 $1,415,000.00 $246,934.67 $0.00 $1,428,100.13 ($13,100.13) 101% $1,427,784.56 1 und 042 . 40tOjrj:�i,ijj Nx ll:�iund fNals $1,415,000.00 $0.00 $1,415,000.00 $246,934.67 $0.00 $1,428,100.13 ($13,100.13) $1,427,784.56 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE707ALS $438,666.00 $0.00 $438,666.00 $28,781.19 $0.00 $352,049.58 $86,616.42 80% $404,565.76 1 und 042 CII)IIIG fNals $438,666.00 $0.00 $438,666.00 $28,781.19 $0.00 $352,049.58 $86,616.42 $404,565.76 0 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I und 042 CII)IIIG REVENUE Dfleigovelinirrelflal Revenue 378,666.00 .00 378,666.00 28,781.19 .00 266,780.42 111,885.58 70 273,344.19 Divesfirrent Dicuirre .00 .00 .00 .00 .00 .00 .00 +++ .00 011101 Revenue 60,000.00 .00 60,000.00 .00 .00 85,269.16 (25,269.16) 142 131,221.57 REVENUE707ALS $438,666.00 $0.00 $438,666.00 $28,781.19 $0.00 $352,049.58 $86,616.42 80% $404,565.76 1 und 042 CII)IIIG fNals $438,666.00 $0.00 $438,666.00 $28,781.19 $0.00 $352,049.58 $86,616.42 $404,565.76 0 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE TOTALS I und 043 Asset S,IZ11,11r, llimnd I N als $7,000.00 $0.00 $7,000.00 $251.47 $0.00 $11,266.40 ($4,266.40) 161% $30,052.61 $7,000.00 $0.00 $7,000.00 10 $251.47 $0.00 $11,266.40 ($4,266.40) $30,052.61 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 043 Asset S,IZ11,11r, ll:�imnd REVENUE I Ines & I c,i relts 6,500.00 .00 6,500.00 (30.75) .00 9,644.13 (3,144.13) 148 29,172.47 Divesfirrent Dicuirre 500.00 .00 500.00 282.22 .00 1,622.27 (1,122.27) 324 880.14 REVENUE TOTALS I und 043 Asset S,IZ11,11r, llimnd I N als $7,000.00 $0.00 $7,000.00 $251.47 $0.00 $11,266.40 ($4,266.40) 161% $30,052.61 $7,000.00 $0.00 $7,000.00 10 $251.47 $0.00 $11,266.40 ($4,266.40) $30,052.61 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE TOTALS I und 044 :"'edurall Equitallble SlIall, ll:''iunds I Nals $2,000.00 $0.00 $2,000.00 $9.48 $0.00 $113.96 $1,886.04 6% $180.51 $2,000.00 $0.00 $2,000.00 11 $9.48 $0.00 $113.96 $1,886.04 $180.51 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 044 :'edurall Equitallble SlIall, ll°iunds REVENUE I Ines & I c,i relts 1,800.00 .00 1,800.00 .00 .00 .00 1,800.00 0 .00 Divesfirrent Dicuirre 200.00 .00 200.00 9.48 .00 113.96 86.04 57 180.51 REVENUE TOTALS I und 044 :"'edurall Equitallble SlIall, ll:''iunds I Nals $2,000.00 $0.00 $2,000.00 $9.48 $0.00 $113.96 $1,886.04 6% $180.51 $2,000.00 $0.00 $2,000.00 11 $9.48 $0.00 $113.96 $1,886.04 $180.51 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE TOTALS und 045 IIbfD 11 11:1ne lliund fcN.als $25,500.00 $0.00 $25,500.00 $5,424.42 $0.00 $21,648.50 $3,851.50 85% $27,124.78 $25,500.00 $0.00 $25,500.00 $5,424.42 $0.00 $21,648.50 $3,851.50 $27,124.78 12 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 045 II:) II', 11:1ne ll°iund REVENUE I Ines & I1tlorfelts 25,000.00 .00 25,000.00 5,399.22 .00 21,361.08 3,638.92 85 26,621.81 Divesfirrent Dicuirre 500.00 .00 500.00 25.20 .00 287.42 212.58 57 502.97 REVENUE TOTALS und 045 IIbfD 11 11:1ne lliund fcN.als $25,500.00 $0.00 $25,500.00 $5,424.42 $0.00 $21,648.50 $3,851.50 85% $27,124.78 $25,500.00 $0.00 $25,500.00 $5,424.42 $0.00 $21,648.50 $3,851.50 $27,124.78 12 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::lsc.aII YearAc' t �i v lity ]�� I'l C' Lided S Lll rn rn a iry Il..l �� I Stjj,jg 13 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 046 . III0111,11g III lj11111, ua, 1140alrd :Iund REVENUE 011101 laxes 90,000.00 .00 90,000.00 .00 .00 78,234.14 11,765.86 87 83,091.57 Divesfirrent Dicuirre 2,000.00 .00 2,000.00 715.90 .00 3,747.25 (1,747.25) 187 2,386.48 011101 Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 011101 1 linallaing l;C,uI,Os .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE707ALS $92,000.00 $0.00 $92,000.00 $715.90 $0.00 $81,981.39 $10,018.61 89% $85,478.05 1 und 046 IlImmilgin ll:lic NxBoUllrd 11:Iund I Nals $92,000.00 $0.00 $92,000.00 $715.90 $0.00 $81,981.39 $10,018.61 $85,478.05 13 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I 14 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 048 . 114,1111,55 j)jStjrjCt ll°iund REVENUE 011101 laxes 1,100,000.00 .00 1,100,000.00 125,889.98 .00 940,932.73 159,067.27 86 1,040,415.75 Dfleigovelinirrelflal Revenue 420,000.00 .00 420,000.00 .00 .00 378,000.00 42,000.00 90 404,444.92 Divesfirrent Dicuirre 3,000.00 .00 3,000.00 1,358.27 .00 13,162.03 (10,162.03) 439 6,310.04 011101 1 linallaing l;C,ui3Os .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $1,523,000.00 $0.00 $1,523,000.00 $127,248.25 $0.00 $1,332,094.76 $190,905.24 87% $1,451,170.71 fund 048 . 114,1111,55 j)jStjrjCt lliund I Nals $1,523,000.00 $0.00 $1,523,000.00 $127,248.25 $0.00 $1,332,094.76 $190,905.24 $1,451,170.71 14 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I 15 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 049 . 11,11,0511)Ct and IIMallin a II 11' j)jStjrjCt REVENUE Plopelly laxes 253,953.00 .00 253,953.00 2,841.12 .00 468,864.51 (214,911.51) 185 .00 Divesfirrent Dicuirre .00 .00 .00 2,027.58 .00 78,497.98 (78,497.98) +++ 306.90 011101 Revellue .00 .00 .00 .00 .00 169,345.01 (169,345.01) +++ .00 011101 1 linallaing l;C,ui3Os 1,600,000.00 .00 1,600,000.00 .00 .00 7,318,879.30 (5,718,879.30) 457 4,930,835.25 REVENUE TOTALS $1,853,953.00 $0.00 $1,853,953.00 $4,868.70 $0.00 $8,035,586.80 ($6,181,633.80) 433% $4,931,142.15 1 und 049 . 11,11,0511,Ctund1lMallin Nals $1,853,953.00 $0.00 $1,853,953.00 $4,868.70 $0.00 $8,035,586.80 ($6,181,633.80) $4,931,142.15 15 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE TOTALS WatllraiiidSmmWc llrlluuiiid f Nall $19,690,300.00 $0.00 $19,690,300.00 $1,153,678.26 $0.00 $14,434,965.68 $5,255,334.32 73% $15,023,047.82 $19,690,300.00 $0.00 $19,690,300.00 $1,153,678.26 16 $0.00 $14,434,965.68 $5,255,334.32 $15,023,047.82 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D Used/ Account Classificabon Budget Arnendrinerifts Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D 1,11(l (q5( . Wat,jr au croak S,W,jr ll°iund REVENUE Plopelly laxes .00 .00 .00 1.66 .00 (3,173.89) 3,173.89 +++ 1,514,451.70 (011505, 10i1rrits&lOOs 20,000.00 .00 20,000.00 920.00 .00 21,300.00 (1,300.00) 106 19,710.00 Charges I c,i ;Olvl(os 14,444,200.00 .00 14,444,200.00 1,116,324.18 .00 14,062,735.87 381,464.13 97 13,286,898.33 1 Ines & I1tlorfelts 130,000.00 .00 130,000.00 9,936.17 .00 104,537.55 25,462.45 so 102,870.15 Divesfirrent Dicuirre 16,100.00 .00 16,100.00 20,936.25 .00 186,828.35 (170,728.35) 1160 22,453.25 Relirrhijiscirrents .00 .00 .00 .00 .00 (1,200.00) 1,200.00 +++ 5,850.00 01:1101 Revenue 80,000.00 .00 80,000.00 5,560.00 .00 63,937.80 16,062.20 so 73,194.89 011101 1 linallaing l;C,ui3Os 5,000,000.00 .00 5,000,000.00 .00 .00 .00 5,000,000.00 0 (2,380.50) REVENUE TOTALS WatllraiiidSmmWc llrlluuiiid f Nall $19,690,300.00 $0.00 $19,690,300.00 $1,153,678.26 $0.00 $14,434,965.68 $5,255,334.32 73% $15,023,047.82 $19,690,300.00 $0.00 $19,690,300.00 $1,153,678.26 16 $0.00 $14,434,965.68 $5,255,334.32 $15,023,047.82 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE TOTALS 1,11(l (q5: . (bull IJUg, j,Ujrj(jjjg Systum lliund I Nals $197,600.00 $0.00 $197,600.00 $14,892.99 $0.00 $192,963.49 $4,636.51 98% $189,503.91 $197,600.00 $0.00 $197,600.00 $14,892.99 17 $0.00 $192,963.49 $4,636.51 $189,503.91 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D 1,11(l (m5:u . VIIIIIIag, 11'a Irl(IlIg Systum ll:iund REVENUE 011101 ..l axes .00 .00 .00 .00 .00 .00 .00 +++ .00 Charges I c,i 1;01 VI(CS 193,600.00 .00 193,600.00 13,959.86 .00 186,306.44 7,293.56 96 184,746.85 Divesfirrent Dicuirre 1,000.00 .00 1,000.00 701.43 .00 3,613.45 (2,613.45) 361 2,071.36 011101 Revenue 3,000.00 .00 3,000.00 231.70 .00 3,043.60 (43.60) 101 2,685.70 011101 1 linallaing l;C,ui3Os .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS 1,11(l (q5: . (bull IJUg, j,Ujrj(jjjg Systum lliund I Nals $197,600.00 $0.00 $197,600.00 $14,892.99 $0.00 $192,963.49 $4,636.51 98% $189,503.91 $197,600.00 $0.00 $197,600.00 $14,892.99 17 $0.00 $192,963.49 $4,636.51 $189,503.91 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v �ity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE TOTALS $157,500.00 $0.00 $157,500.00 $12,554.54 $0.00 $158,152.58 ($652.58) 100% $156,690.05 1 und 052 . 11'aIrl(IlIg SySt,, lj:C,,ijjji, lj,Jld I Nals $157,500.00 $0.00 $157,500.00 $12,554.54 $0.00 $158,152.58 ($652.58) $156,690.05 18 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 052.. 11'aIrl(IlIg Systum Illevenim ll:.iund REVENUE 011101 laxes .00 .00 .00 .00 .00 .00 .00 +++ .00 Dfleigovelinirrelflal Revellue .00 .00 .00 .00 .00 .00 .00 +++ .00 chal jes I c,i 1;01 VI(CS 156,000.00 .00 156,000.00 12,123.45 .00 155,249.12 750.88 100 154,563.55 Divesfirrent Dicuirre 500.00 .00 500.00 352.69 .00 1,702.96 (1,202.96) 341 809.80 011101 Revellue 1,000.00 .00 1,000.00 78.40 .00 1,200.50 (200.50) 120 1,316.70 011101 1 linallaing l;C,ui3Os .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE TOTALS $157,500.00 $0.00 $157,500.00 $12,554.54 $0.00 $158,152.58 ($652.58) 100% $156,690.05 1 und 052 . 11'aIrl(IlIg SySt,, lj:C,,ijjji, lj,Jld I Nals $157,500.00 $0.00 $157,500.00 $12,554.54 $0.00 $158,152.58 ($652.58) $156,690.05 18 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v �ity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I 19 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I und 060 Vellhicle 1114allintenance ll°iund REVENUE Charges I c,i 1;01 VI(CS 2,040,827.00 .00 2,040,827.00 170,069.10 .00 2,040,827.00 .00 100 2,029,964.00 Divesfirrent Dicuirre 3,000.00 .00 3,000.00 1,281.45 .00 6,516.67 (3,516.67) 217 4,919.65 011101 Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 011101 1 linallaing l;C,ui3Os .00 .00 .00 488.46 .00 1,576.37 (1,576.37) +++ (6,373.04) REVENUE TOTALS $2,043,827.00 $0.00 $2,043,827.00 $171,839.01 $0.00 $2,048,920.04 ($5,093.04) 100% $2,028,510.61 1 and MO Vellhicle 1114allintenaince lliund I Nals $2,043,827.00 $0.00 $2,043,827.00 $171,839.01 $0.00 $2,048,920.04 ($5,093.04) $2,028,510.61 19 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE TOTALS $1,734,300.00 $0.00 $1,734,300.00 $174,532.43 $0.00 $1,867,024.49 ($132,724.49) 108% $1,818,074.54 1 and (WH Vellhicle Illelplaccimint lliund I Nals $1,734,300.00 $0.00 $1,734,300.00 $174,532.43 $0.00 $1,867,024.49 ($132,724.49) $1,818,074.54 20 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 062 Vellhicle Illelplaccimint ll°iund REVENUE chal ges I c,i 1;01 VI(CS 1,611,300.00 .00 1,611,300.00 134,275.11 .00 1,611,300.00 .00 100 1,645,000.00 1 Ines & I c,i relts 8,000.00 .00 8,000.00 1,022.28 .00 9,027.19 (1,027.19) 113 11,297.72 Divesfirrent Dicuirre 50,000.00 .00 50,000.00 32,994.32 .00 112,225.31 (62,225.31) 224 64,685.99 Relirrhijiscirrents .00 .00 .00 .00 .00 .00 .00 +++ .00 011101 Revenue .00 .00 .00 .00 .00 .00 .00 +++ .00 011101 1 linallaing l;C,ui3Os 65,000.00 .00 65,000.00 6,240.72 .00 134,471.99 (69,471.99) 207 97,090.83 REVENUE TOTALS $1,734,300.00 $0.00 $1,734,300.00 $174,532.43 $0.00 $1,867,024.49 ($132,724.49) 108% $1,818,074.54 1 and (WH Vellhicle Illelplaccimint lliund I Nals $1,734,300.00 $0.00 $1,734,300.00 $174,532.43 $0.00 $1,867,024.49 ($132,724.49) $1,818,074.54 20 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE707ALS $206,597.00 $0.00 $206,597.00 $18,732.37 $0.00 $211,776.96 ($5,179.96) 103% $244,235.55 1 und 062 . COj,jt,r :CqpjaC,j,ijjt lliund I Nals $206,597.00 $0.00 $206,597.00 $18,732.37 $0.00 $211,776.96 ($5,179.96) $244,235.55 21 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I und 062 . COj,jp,t,r :CqpjaC,j,ijjt ll:'iund REVENUE Charges I c,i 1;01 VI(CS 205,097.00 .00 205,097.00 17,091.49 .00 205,097.00 .00 100 240,829.00 Divesfirrent Dicuirre 1,500.00 .00 1,500.00 1,640.88 .00 6,679.96 (5,179.96) 445 3,406.55 011101 1 linallaing l;C,ui3Os .00 .00 .00 .00 .00 .00 .00 +++ .00 REVENUE707ALS $206,597.00 $0.00 $206,597.00 $18,732.37 $0.00 $211,776.96 ($5,179.96) 103% $244,235.55 1 und 062 . COj,jt,r :CqpjaC,j,ijjt lliund I Nals $206,597.00 $0.00 $206,597.00 $18,732.37 $0.00 $211,776.96 ($5,179.96) $244,235.55 21 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v �ity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I 22 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I und 063 11111slk I'4anagumint ll"iund REVENUE Charges I c,i 1;01 VI(CS 7,164,350.00 .00 7,164,350.00 494,248.14 .00 7,094,912.77 69,437.23 99 6,667,747.64 Divesfirrent Dicuirre 13,000.00 .00 13,000.00 2,526.70 .00 20,791.89 (7,791.89) 160 17,169.97 Relirrhijiscirrents 1,000.00 .00 1,000.00 .00 .00 19,336.64 (18,336.64) 1934 48,275.09 01:1101 Revenue 1,582,528.00 .00 1,582,528.00 123,241.62 .00 1,708,941.82 (126,413.82) 108 1,398,672.27 REVENUE TOTALS $8,760,878.00 $0.00 $8,760,878.00 $620,016.46 $0.00 $8,843,983.12 ($83,105.12) 101% $8,131,864.97 fund M3 11111slk 1114unagumint lliund I Nals $8,760,878.00 $0.00 $8,760,878.00 $620,016.46 $0.00 $8,843,983.12 ($83,105.12) $8,131,864.97 22 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE TOTALS $9,745,500.00 $0.00 $9,745,500.00 ($3,884,723.21) $0.00 $588,658.35 $9,156,841.65 6% $14,097,223.15 1 und 070 Illollce Illenslon llimnd I Nals $9,745,500.00 $0.00 $9,745,500.00 ($3,884,723.21) $0.00 $588,658.35 $9,156,841.65 $14,097,223.15 23 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I and 070 Illollce Illenslon ll:imnd REVENUE chal ges I c,i 1;01 VI(CS .00 .00 .00 .00 .00 .00 .00 +++ .00 Divesfirrent Dicuirre 5,261,000.00 .00 5,261,000.00 (4,241,676.38) .00 (3,860,517.64) 9,121,517.64 -73 9,088,926.29 01:1101 Revenue 4,484,500.00 .00 4,484,500.00 356,953.17 .00 4,449,175.99 35,324.01 99 5,008,296.86 REVENUE TOTALS $9,745,500.00 $0.00 $9,745,500.00 ($3,884,723.21) $0.00 $588,658.35 $9,156,841.65 6% $14,097,223.15 1 und 070 Illollce Illenslon llimnd I Nals $9,745,500.00 $0.00 $9,745,500.00 ($3,884,723.21) $0.00 $588,658.35 $9,156,841.65 $14,097,223.15 23 Revenue Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc.aII YearAc' t �i v lity ]�� I'l C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I REVENUE TOTALS $9,117,300.00 und 072 ll:lic Illenslon lliund I Nals $9,117,300.00 $0.00 $9,117,300.00 ($2,117,083.27) $0.00 $1,972,355.71 $7,144,944.29 22% $13,489,851.84 $0.00 $9,117,300.00 ($2,117,083.27) $0.00 $1,972,355.71 $7,144,944.29 $13,489,851.84 CTand I Nals $125,889,849.00 $0.00 $125,889,849.00 $2,684,985.98 24 $0.00 $151,859,893.14 ($25,970,044.14) $132,710,871.78 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Budget Arnendrinerifts Budget Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 072 ll:lic Illenslon ll:'iund REVENUE Divesfirrent Dicuirre 5,078,000.00 .00 5,078,000.00 (2,506,375.84) .00 (2,049,544.28) 7,127,544.28 -40 9,414,541.44 01:1101 Revenue 4,039,300.00 .00 4,039,300.00 389,292.57 .00 4,021,899.99 17,400.01 100 4,075,310.40 REVENUE TOTALS $9,117,300.00 und 072 ll:lic Illenslon lliund I Nals $9,117,300.00 $0.00 $9,117,300.00 ($2,117,083.27) $0.00 $1,972,355.71 $7,144,944.29 22% $13,489,851.84 $0.00 $9,117,300.00 ($2,117,083.27) $0.00 $1,972,355.71 $7,144,944.29 $13,489,851.84 CTand I Nals $125,889,849.00 $0.00 $125,889,849.00 $2,684,985.98 24 $0.00 $151,859,893.14 ($25,970,044.14) $132,710,871.78 Account: Classlflcabon II°und (Ml (wuuncu�a 111 111°uund EXPENSE 11e15canal Savl(os, I;cdarlea R Wages I ESenefits 011101 I"llployee Costa Pension E'3e11efits CcmP.rad:u« I F;Olvl(os UP.IIIP.Ies Inaur'ance commodities R F;ulalalles Other 1)(Iaendlt:ures funding Im larcvements Of1''Ice EIIIc,ullnment O'Iher' EIIlqullamen P. Doll bulicrn FiysY:ems InfraaY:rud:ure Int:er.fund .l...ransfers Expense Budget by Account Classification Report - e I hIr()allgl 1.2/31./18 >Irlic)irI::l sc,a: II Year(:Vuvuty :]f:III (,Ilau��ed S Lll Irn� Irn� Iry Il...li :iia°� : Adopted Pudget Amended Current Morrth Y7 Y7 Pudget - Y7 % Used/ Pladget Amendrnerrts Pladget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 26,905,037.00 .00 26,905,037.00 2,897,168.52 .00 26,725,445.64 179,591.36 99 25,927,820.92 14,494,234.00 .00 14,494,234.00 1,369,349.96 .00 14,814,582.26 (320,348.26) 102 14,409,904.16 568,539.00 (2,050.00) 566,489.00 34,980.81 .00 409,928.85 156,560.15 72 462,614.52 46,950.00 .00 46,950.00 484.89 .00 5,818.68 41,131.32 12 46,779.60 8,639,276.00 6,450.00 8,645,726.00 944,383.72 .00 7,468,399.43 1,177,326.57 86 7,896,646.69 334,056.00 .00 334,056.00 59,286.57 .00 230,179.66 103,876.34 69 228,529.13 417,611.00 .00 417,611.00 1,854.28 .00 469,053.11 (51,442.11) 112 401,291.28 754,125.00 10,530.00 764,655.00 95,492.83 .00 653,097.59 111,557.41 85 649,603.24 683,456.00 .00 683,456.00 928,411.00 .00 932,154.84 (248,698.84) 136 1,184,150.35 15,828.00 (6,400.00) 9,428.00 .00 .00 392.16 9,035.84 4 3,145.08 54,776.00 9,000.00 63,776.00 4,707.81 .00 26,516.86 37,259.14 42 92,938.47 253,530.00 7,050.00 260,580.00 35,337.42 .00 233,460.14 27,119.86 90 505,564.86 .00 .00 .00 .00 .00 .00 .00 +++ .00 898,000.00 162,438.00 1,060,438.00 133,257.78 .00 568,277.82 492,160.18 54 678,354.38 750,000.00 .00 750,000.00 750,000.00 .00 750,000.00 .00 100 600,000.00 EXPENSE TOTALS $54,815,418.00 $187,018.00 $55,002,436.00 $7,254,715.59 $0.00 $53,287,307.04 $1,715,128.96 97% $53,087,342.68 1 and 002 (wuunariuralll ll1°uund Iotals $54,815,418.00 $187,018.00 $55,002,436.00 $7,254,715.59 $0.00 $53,287,307.04 $1,715,128.96 $53,087,342.68 1 lExpense Budget by Account Classification Report hi-(Xllg�l 12/3 1/18 �Didc)ir :::lsc,aII YearAc' t �� v �� ty ]�� 111 C' Stjj,jg Lided S Lll rn rn a iry Adopted Fudgei: Amended Current Morifth YTf7 YTf7 Fudgei: - Y7 D -/,, Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year YTf7 I und W2 ll:killbt Scivice ll°Iund EXPENSE contladual l;OIvI(OS .00 .00 .00 .00 .00 141,795.82 (141,795.82) +++ .00 011101 Ell x1poindiftlics .00 .00 .00 .00 .00 .00 .00 +++ .00 Hord III linal"al 3,712,771.00 .00 3,712,771.00 694,100.00 .00 7,825,687.41 (4,112,916.41) 211 3,518,903.64 DMOICS1 I x1poinse 1,296,201.00 .00 1,296,201.00 55,586.50 .00 1,202,447.10 93,753.90 93 1,375,697.28 Hark & I is,al I ces 6,000.00 .00 6,000.00 .00 .00 4,463.50 1,536.50 74 2,558.50 Iintci ruixi I I ainsfe, s .00 .00 .00 .00 .00 .00 .00 +++ .00 011101 1 linallaing USOS .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $5,014,972.00 $0.00 $5,014,972.00 $749,686.50 $0.00 $9,174,393.83 ($4,159,421.83) 183% $4,897,159.42 1 und W2 llakillbt Scivice ll:'Iund I otals $5,014,972.00 $0.00 $5,014,972.00 $749,686.50 $0.00 $9,174,393.83 ($4,159,421.83) $4,897,159.42 lExpense Budget by Account Classification Report hir()Lllgl 1.2/31./18 �)idc)ir:::Isc,a11 YearAc' t �� v �� ty ]�� III C' StrJ11,IgLided S Lll rn rn a iry Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account: Classificabon Fudgei: Arnendrinerifts Fudgei: Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 020 . Callotall 1111,11pIrOV,11,111t ll°iund EXPENSE contladual ;Olvl(os 78,030.00 110,000.00 188,030.00 .00 .00 129,744.50 58,285.50 69 149,212.10 011101 1 x1poindiftlics .00 .00 .00 .00 .00 .00 .00 +++ 44,866.45 1 and Improvements 200,000.00 115,000.00 315,000.00 5,500.00 .00 15,500.00 299,500.00 5 46,273.41 Huilding DmIploveirrents 480,000.00 58,225.00 538,225.00 250,684.64 .00 316,294.78 221,930.22 59 169,704.62 afri(c EIIIc,ullpment .00 .00 .00 .00 .00 .00 .00 +++ .00 Ivlcrtsrr Elllquipment .00 .00 .00 .00 .00 .00 .00 +++ .00 011ici I quipirrent 412,247.00 .00 412,247.00 107,740.42 .00 289,921.82 122,325.18 70 715,466.53 Dific'sliudi'lic 1,179,000.00 478,121.00 1,657,121.00 222,020.75 .00 711,943.50 945,177.50 43 143,926.57 Inter "fund i i ainsfe, s .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $2,349,277.00 $761,346.00 $3,110,623.00 $585,945.81 $0.00 $1,463,404.60 $1,647,218.40 47% $1,269,449.68 1 und 020 Callotall 1111,11pIrOV,11,111t lj:'iund I otals $2,349,277.00 $761,346.00 $3,110,623.00 $585,945.81 $0.00 $1,463,404.60 $1,647,218.40 $1,269,449.68 lExpense Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc,a11 Year Ac't u v u ty .]l.III C' Lided S Lll rn rn a iry StrJ11,Ig Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 023 . Stjjr,it 1111,11pIrOV,11,111t Cohnrimlj°iund EXPENSE contractual ;Olvl(os 40,000.00 .00 40,000.00 .00 .00 18,631.00 21,369.00 47 37,076.00 04:1101 1 x1poindiftlics .00 .00 .00 .00 .00 .00 .00 +++ .00 I and DmIploveirrents .00 .00 .00 .00 .00 .00 .00 +++ .00 Dific'sliudi'lic 3,777,000.00 .00 3,777,000.00 5,953.45 .00 2,563,984.73 1,213,015.27 68 3,883,509.51 Inter "fund i i aiisfe, s .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $3,817,000.00 $0.00 $3,817,000.00 $5,953.45 $0.00 $2,582,615.73 $1,234,384.27 68% $3,920,585.51 1 und 023 . Stjjr,it jj,jpjrOV,,,jt CollSor, lj:'iund I otals $3,817,000.00 $0.00 $3,817,000.00 $5,953.45 $0.00 $2,582,615.73 $1,234,384.27 $3,920,585.51 lExpense Budget by Account Classification Report hir()Lllgl 1.2/31./18 �)idc)ir:::Isc,a11 YearAc' t �� v �� ty ]�� III C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D Used/ Account Classificabon Budget Arnendrinerifts Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I and 024 11:11ood Colljoroll CollSori,tjoll ll:imnd EXPENSE contractual ;Olvl(os 124,296.00 .00 124,296.00 1,354.61 .00 87,854.90 36,441.10 71 55,050.48 Militics 2,550.00 .00 2,550.00 74.31 .00 1,986.55 563.45 78 1,917.05 commodities & 1;uIpplics 5,306.00 .00 5,306.00 385.64 .00 4,351.42 954.58 82 4,934.87 04:1101 1 x1poindiftlics 5,306.00 .00 5,306.00 .00 .00 1,000.00 4,306.00 19 440.00 011ici Elllquipment .00 .00 .00 .00 .00 .00 .00 +++ .00 fDisY:rl hulic'n 1;y5lems 102,000.00 53,775.00 155,775.00 4,892.07 .00 41,853.11 113,921.89 27 46,224.71 Dific'sliudi'lic 580,500.00 247,445.00 827,945.00 22,657.02 .00 328,150.93 499,794.07 40 488,063.80 EXPENSE TOTALS $819,958.00 $301,220.00 $1,121,178.00 $29,363.65 $0.00 $465,196.91 $67,981.09 41% $596,630.91 fund 024 11:11ood Colljoroll CollSori,tjoll ll:''imnd I otals $819,958.00 $301,220.00 $1,121,178.00 $29,363.65 $0.00 $465,196.91 $67,981.09 $596,630.91 lExpense Budget by Account Classification Report hir()LllgIl 1.2/31./18 �)id(.)ir lsc,aII Year Ac't u v u ty ]�� 111 C' Lided S Lll rn rn a iry Stjj,jg Adopted Fudgei: Amended Current Morifth YTf7 YTf7 Fudgei: - Y7 D -/,, Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTf7 I und 025 . 11,01111C, & ljjjjjr, Illifildling Const EXPENSE contladual ;Olvl(os .00 .00 .00 359,136.69 .00 1,898,546.29 (1,898,546.29) +++ .00 Huilding DIrl"IcIveirrents .00 .00 .00 65,100.00 .00 65,100.00 (65,100.00) +++ .00 Hord III lincipal .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $0.00 $0.00 $0.00 $424,236.69 $0.00 $1,963,646.29 ($1,963,646.29) +++ $0.00 1 und 025 . 11,01111C, & ljjjjjr, Illifildling Const I otals $0.00 $0.00 $0.00 $424,236.69 $0.00 $1,963,646.29 ($1,963,646.29) $0.00 lExpense Budget by Account Classification Report hir()Lllgl 1.2/31./18 �)idc)ir:::Isc,aII Year Ac't u v u ty ]f: III C' StrJ11,IgLided S Lll rn rn a iry Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I und 040 Illefine II)IIsposall ll°iund EXPENSE 11015c'nal ;Olvl(os, I;cdai 105 & Wages 270,999.00 .00 270,999.00 28,145.53 .00 267,842.41 3,156.59 99 248,931.75 EIIImplcWee 130110fits 119,861.00 .00 119,861.00 10,283.11 .00 123,512.47 (3,651.47) 103 115,362.62 04:1101 11 cosIs 1,324.00 .00 1,324.00 .00 .00 348.61 975.39 26 1,199.33 contractual ;Olvl(os 3,888,076.00 5,065.00 3,893,141.00 590,061.94 .00 4,167,302.08 (274,161.08) 107 3,804,783.72 Militics 474.00 .00 474.00 13.17 .00 157.80 316.20 33 303.06 Insurance 26,673.00 .00 26,673.00 .00 .00 5,892.30 20,780.70 22 29,528.00 commodities & 1;uIpplics 40,763.00 .00 40,763.00 3,335.46 .00 35,723.03 5,039.97 88 38,637.60 EXPENSE TOTALS $4,348,170.00 $5,065.00 $4,353,235.00 $631,839.21 $0.00 $4,600,778.70 ($247,543.70) 106% $4,238,746.08 1 und 040 Illefine II)IIsliposaIll ll:�iund I otals $4,348,170.00 $5,065.00 $4,353,235.00 $631,839.21 $0.00 $4,600,778.70 ($247,543.70) $4,238,746.08 lExpense Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc,a11 Year Ac't u v u ty .]l.III C' Lided S Lll rn rn a iry StrJ11,Ig Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 042 . 11,40tolIr lj°,ijj ax ll°iund EXPENSE contractual ;Olvl(os 353,111.00 .00 353,111.00 6,726.20 .00 318,356.47 34,754.53 90 330,389.19 Militics 165,612.00 .00 165,612.00 279.10 .00 154,292.15 11,319.85 93 149,799.87 commodities & 1;uIpplics 350,000.00 .00 350,000.00 124,943.11 .00 335,019.59 14,980.41 96 82,264.79 Huilding DmIploveirrents .00 .00 .00 .00 .00 .00 .00 +++ .00 Dific'sliudi'lic 600,000.00 330,659.00 930,659.00 13,140.50 .00 923,748.94 6,910.06 99 586,341.00 EXPENSE TOTALS $1,468,723.00 $330,659.00 $1,799,382.00 $145,088.91 $0.00 $1,731,417.15 $67,964.85 96% $1,148,794.85 fund 042 . 11,40tolIr lj,ijj uax ll:'iund I otals $1,468,723.00 $330,659.00 $1,799,382.00 $145,088.91 $0.00 $1,731,417.15 $67,964.85 $1,148,794.85 0 lExpense Budget by Account Classification Report hir()LllgIl 1.2/31./18 �)id(.)ir :::Isc,aII Year Ac't u v u ty ]�� III C' Lided S Lll rn rn a iry StrJ11,Ig Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I und 042 CII)IIIG EXPENSE 11015c'nal ;Olvl(os, I;cdai 105 & Wages .00 .00 .00 1,295.00 .00 27,440.00 (27,440.00) +++ 36,283.91 EIIImplcWee 130110fits .00 .00 .00 238.40 .00 5,051.72 (5,051.72) +++ 18,821.27 O4:her 11 cosIs 1,104.00 .00 1,104.00 .00 .00 1,114.14 (10.14) 101 104.00 contractual ;Olvl(os 437,012.00 .00 437,012.00 6,362.97 .00 344,438.15 92,573.85 79 349,356.58 commodities & 1;uIpplics 550.00 .00 550.00 .00 .00 10.49 539.51 2 .00 011101 1 x1poindiftlics .00 .00 .00 .00 .00 .00 .00 +++ .00 I and DmIploveirrents .00 .00 .00 .00 .00 .00 .00 +++ .00 Huilding DmIploveirrents .00 .00 .00 .00 .00 .00 .00 +++ .00 Dific'sliudi'lic .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $438,666.00 $0.00 $438,666.00 $7,896.37 $0.00 $378,054.50 $60,611.50 86% $404,565.76 1 und 042 CII)II5G I ot als $438,666.00 $0.00 $438,666.00 $7,896.37 $0.00 $378,054.50 $60,611.50 $404,565.76 0 10 lExpense Budget by Account Classification Report hir()LllgIl 1.2/31./18 �)id(.)ir :::Isc,aII Year Ac't u v u ty ]�� III C' Lided S Lll rn rn a iry StrJ11,Ig Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I und 043 Asset S,IZ11,11r, ll:�imnd EXPENSE 04:1101 11 cosIs 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 12,857.70 contladual ;Olvl(os 15,500.00 .00 15,500.00 .00 .00 10,349.28 5,150.72 67 .00 commodities & 1;uIpplics 24,400.00 .00 24,400.00 49.59 .00 15,365.15 9,034.85 63 .00 011ici I quipirrent 3,000.00 .00 3,000.00 1,039.46 .00 17,222.45 (14,222.45) 574 17,364.98 EXPENSE TOTALS $43,900.00 $0.00 $43,900.00 $1,089.05 $0.00 $42,936.88 $963.12 98% $30,222.68 1 und 043 Asset S,IZ11411r, ll:'imnd I ot als $43,900.00 $0.00 $43,900.00 $1,089.05 $0.00 $42,936.88 $963.12 $30,222.68 10 11 lExpense Budget by Account Classification Report hir()Llg�h 12/3 1/18 �)idc)ir :::Isc,a11 Year Ac't u v u ty .]l.III C' Lided S L11 rn rn a iry Stjj,jg Adopted Fudgel: Amended Current Morifth Y7 D Y7 D Fudgel: - Y7 D -/,, Used/ Account Classificabon Fudgel: Arnendrinerifts Fudgel: Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 044 :'edurall q uiit,aallb Ile SlIall, 11°iunds EXPENSE coifliadual I;Oivi(Os 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Huilding Improvements .00 .00 .00 .00 .00 .00 .00 +++ .00 011ici Elllquilament 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 EXPENSE TOTALS $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 0% $0.00 1 und 044 :'edurall q uiitaallb Ile SlIja1r, 11:'iunds I otals $2,000.00 $0.00 $2,000.00 $0.00 $0.00 $0.00 $2,000.00 $0.00 11 12 lExpense Budget by Account Classification Report hir()LllgIl 1.2/31./18 �)id(.)ir :::Isc,aII Year Ac't u v u ty ]�� III C' Lided S Lll rn rn a iry StrJ11,Ig Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 045 II)WI: 11:1ne ll°iund EXPENSE 04:1101 11 cosIs 1,000.00 .00 1,000.00 .00 .00 550.00 450.00 55 6,729.17 contladual ;Olvl(os 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 011ici I quipirrent 1,000.00 4,000.00 5,000.00 500.00 .00 23,301.30 (18,301.30) 466 917.23 Ingerrune! i i aiisfe, s .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $3,000.00 $4,000.00 $7,000.00 $500.00 $0.00 $23,851.30 ($16,851.30) 341% $7,646.40 I und 045 IIbU,D II 11:1ne ll:'iund I otals $3,000.00 $4,000.00 $7,000.00 $500.00 $0.00 $23,851.30 ($16,851.30) $7,646.40 12 lExpense Budget by Account Classification Report hir()Lllgl 1.2/31./18 �)idc)ir :::lsc,aII YearAc' t �� v �� ty ]�� 111 C' Stjj,jg Lided S Lll rn rn a iry Adopted Fudgei: Amended Current Morifth YTf7 YTf7 Fudgei: - Y7 D -/,, Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transactions Encumbrances Transactions Transactions Rec'd Prior Year YTf7 I und 046 . III0111,11g III lj11111, tla, 1140alrd :Iund EXPENSE 04:1101 11 cosIs 15,000.00 .00 15,000.00 .00 .00 3,730.77 11,269.23 25 4,054.24 contractual ;Olvl(os 15,000.00 130.00 15,130.00 180.65 .00 10,427.65 4,702.35 69 8,457.18 Insurance 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 commodities & 1;upplics 5,000.00 8,000.00 13,000.00 .00 .00 13,000.00 .00 100 6,013.15 Huilding DmIploveirrents .00 .00 .00 .00 .00 .00 .00 +++ .00 011ici I quipirrent 30,000.00 (8,130.00) 21,870.00 .00 .00 8,759.59 13,110.41 40 56,209.09 EXPENSE TOTALS $65,500.00 $0.00 $65,500.00 $180.65 $0.00 $35,918.01 $29,581.99 55% $74,733.66 1 und 046 IlImmilgin II unarm tluxBoUllrd II1Iund I otals $65,500.00 $0.00 $65,500.00 $180.65 $0.00 $35,918.01 $29,581.99 $74,733.66 13 14 lExpense Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::lsc,a11 Year Ac't u v u ty .]l.111 C' Lided S Lll rn rn a iry Stjj,jg Adopted Fudgei: Amended Current Morifth YTf7 YTf7 Fudgei: - Y7 D -/,, Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year YTf7 I und 048 . 114,1111,55 j)jStjrjCt ll°Iund EXPENSE Hord III lincipal .00 .00 .00 .00 .00 .00 .00 +++ .00 Dflelosl I x1poinse 1,523,000.00 .00 1,523,000.00 75,954.82 .00 906,508.65 616,491.35 60 1,451,170.71 EXPENSE TOTALS $1,523,000.00 $0.00 $1,523,000.00 $75,954.82 $0.00 $906,508.65 $616,491.35 60% $1,451,170.71 1 und 048 . 114,1111,55 j)jStjrjCt ll:'Iund I otals $1,523,000.00 $0.00 $1,523,000.00 $75,954.82 $0.00 $906,508.65 $616,491.35 $1,451,170.71 14 IV Account Classlflcabon I'-und Qq^A"',"b ° Ilbuaaspaaict and IIMa lln tl II II' III iict EXPENSE 011101 I1 Cosi:. Ccml.rad:u« I F;Olvl(os commodities R F;ulalalles 04:11011)(pendlt:ures L...and DIr l"lovemenl.s funding Iminrirvemenl.s Infraal:rud:ur0 Hord 4'ri11c:i1"al 111fere51: 11::9(1"01150 Hark C 1I='Isual II='ces Int:Orruruf Iansfers Expense Budget by Account Classification Report - e Ihir()Lllg 1l 12/31/18 )Irlic)ir I::llsc,aII Year(:Vuvuty :]f:111CllLide�� S Lll Irn� Irn� Iry Il...li :iia°� : Adopted Pudget Amended Current Morrth Y7 f7 Y7 f7 Pudget - Yi f7 % Used/ Pladsae'L Amendrnerrts Pladsae'L Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 f7 1,500.00 .00 1,500.00 .00 .00 1,200.00 300.00 80 600.00 181,500.00 .00 181,500.00 29,605.60 .00 351,825.64 (170,325.64) 194 238,490.66 1,500.00 .00 1,500.00 .00 .00 160.70 1,339.30 11 .00 3,423,000.00 .00 3,423,000.00 .00 .00 10,407,382.35 (6,984,382.35) 304 59,029.88 750,000.00 .00 750,000.00 40,052.84 .00 40,052.84 709,947.16 5 .00 260,000.00 .00 260,000.00 .00 .00 .00 260,000.00 0 .00 710,000.00 .00 710,000.00 700.00 .00 700.00 709,300.00 0 .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 183,419.00 .00 183,419.00 .00 .00 310,422.63 (127,003.63) 169 .00 .00 .00 .00 .00 .00 225.00 (225.00) +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $5,510,919.00 und 049 11'buaa511),Ct auind Mallin tl II 11'' II:Iblisan uCU. I to s $5,510,919.00 $0.00 $5,510,919.00 $70,358.44 $0.00 $11,111,969.16 ($5,601,050.16) 202% $298,120.54 $0.00 $5,510,919.00 $70,358.44 $0.00 $11,111,969.16 ($5,601,050.16) $298,120.54 15 Account: Classlflcabon I'°and 050 .. Wauteii and Sar.weiii 111°uunak EXPENSE 11e15canal ';a vicea, k. clot lea R Wages I ESenefll.s 011101 I1 Cosi:. Ccml.rad:u« I F;Olvl(os U1.III1.les Inaur'ance commodities R F;ulalalles Other 1)(pendlt:ures 19uildings funding IminrcIvement.s Of1''Ice EIIIc,ullnmenl. O'Iher' EIIlqullamenl. Doll bulicrn Fiysl:ems Infraal:rud:ure Hord III inc:ipal Infere51: 11::9gce115e Hark C 1I='Isual II ces Int:er.fund .lI I ansfers Expense Budget by Account Classification Report - e I hIr()allgl 1.2/31./18 >Irlic)ir I::llsc,aII Year(:Vuvuty :]f:111(,Ilau��ed S Lll Irn� Irn� Iry Il...li :iia°� : Adopted Pudget Amended Current Morrth Y7 f7 Y7 f7 Pudget - Yi f7 % Used/ Pladge'L Amendrnerrts Pladge'L Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 f7 2,318,148.00 .00 2,318,148.00 244,835.91 .00 2,297,087.18 21,060.82 99 2,112,395.07 929,223.00 .00 929,223.00 79,453.29 .00 1,010,230.11 (81,007.11) 109 1,085,357.36 43,599.00 .00 43,599.00 414.00 .00 43,302.73 296.27 99 40,313.38 8,885,882.00 .00 8,885,882.00 681,467.89 .00 8,022,421.37 863,460.63 90 8,347,895.34 171,292.00 .00 171,292.00 14,701.31 .00 114,998.91 56,293.09 67 135,012.92 94,942.00 .00 94,942.00 .00 .00 99,975.00 (5,033.00) 105 100,042.00 329,969.00 .00 329,969.00 38,143.43 .00 243,463.52 86,505.48 74 209,353.15 .00 .00 .00 .00 .00 .00 .00 +++ 681,476.96 .00 .00 .00 .00 .00 .00 .00 +++ .00 70,000.00 .00 70,000.00 28,421.20 .00 67,562.01 2,437.99 97 67,128.21 1,060.00 .00 1,060.00 .00 .00 1,060.00 .00 100 326.19 172,381.00 101,000.00 273,381.00 56,235.23 .00 150,822.32 122,558.68 55 296,087.88 5,462,414.00 242,500.00 5,704,914.00 283,220.06 .00 3,298,798.33 2,406,115.67 58 1,230,347.90 10,000.00 .00 10,000.00 .00 .00 .00 10,000.00 0 .00 115,000.00 .00 115,000.00 .00 .00 305,000.00 (190,000.00) 265 .00 182,546.00 .00 182,546.00 .00 .00 266,650.82 (84,104.82) 146 .00 .00 .00 .00 .00 .00 225.00 (225.00) +++ .00 .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $18,786,456.00 $343,500.00 $19,129,956.00 $1,426,892.32 $0.00 $15,921,597.30 $3,208,358.70 83% $14,305,736.36 ILnd (q5(q Wautarmur au croak Sa.wmauur ll"''uuind Iotals $18,786,456.00 $343,500.00 $19,129,956.00 $1,426,892.32 $0.00 $15,921,597.30 $3,208,358.70 $14,305,736.36 16 �'uwtrr M�nwroecn lExpense Budget by Account Classification Report hIr()allgl 1.2/31./18 >Irlic)irI::l sc,a: II Year(:Vuvuty :]f:III (,Ilau��ed S Lll Irn� Irn� Iry Il...li :iia°� : Adopted Eudget Amended Current Morrth Y7 Y7 Eudget - Y7 % Used/ Account Classlflc:abon Eudget Arnendrnerrts Eudget Transaction® Encumbrances Transaction® Transaction® Recd Prior Year Y7 1'-u11d (q50 Mii 11llag, Il'auurll(iiunap Sdstuuna 11 uuund EXPENSE 11e15crnal Savl(os, Scdai 105 R Wages 38,677.00 .00 38,677.00 4,157.18 .00 39,187.03 (510.03) 101 36,804.42 1 ESenefits 17,705.00 .00 17,705.00 1,576.55 .00 17,876.87 (171.87) 101 20,053.86 contractual (Services 61,073.00 .00 61,073.00 4,063.15 .00 39,374.82 21,698.18 64 22,196.63 Insurance 654.00 .00 654.00 .00 .00 242.00 412.00 37 1,596.00 commodities R Fiulalalles 552.00 .00 552.00 466.28 .00 552.01 (.01) 100 18.00 04:11011x1pendlt:ur'es .00 .00 .00 .00 .00 .00 .00 +++ .00 fundings .00 .00 .00 .00 .00 .00 .00 +++ .00 funding Imlplovements 7,506.00 .00 7,506.00 .00 .00 .00 7,506.00 0 .00 Infrasi:ruct:ure 50,000.00 .00 50,000.00 .00 .00 35,030.00 14,970.00 70 .00 Inter "fund iiansfer's .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $176,167.00 $0.00 $176,167.00 $10,263.16 $0.00 $132,262.73 $43,904.27 75% $80,668.91 IM°uruf (q5:0 Mli Ulla g, 11''auurll(iIlIg Sdstauum Ill:'iuund I otals $176,167.00 $0.00 $176,167.00 $10,263.16 $0.00 $132,262.73 $43,904.27 $80,668.91 17 lExpense Budget by Account Classification Report hir()Lllgl 1.2/31./18 �)idc)ir:::Isc,aII Year Ac't u v u ty ]f: III C' Lided StrJ11,Ig S Lll rn rn a iry Ilr �� I 18 Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D Used/ Account Classificabon Budget Arnendrinerifts Budget Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 052.. jX,jrj(jjjg Systum 11 to ll:.iund EXPENSE 11015c'nal ;Olvl(os, I;cdai 105 & Wages 28,275.00 .00 28,275.00 3,051.00 .00 28,703.48 (428.48) 102 27,054.29 EIIImplcWee 130110fits 13,097.00 .00 13,097.00 1,168.69 .00 13,256.64 (159.64) 101 11,471.08 contractual ;Olvl(os 108,898.00 .00 108,898.00 15,477.18 .00 89,836.07 19,061.93 82 99,829.70 Militics 11,387.00 .00 11,387.00 1,579.14 .00 5,913.45 5,473.55 52 6,245.72 Insurance 967.00 .00 967.00 .00 .00 248.00 719.00 26 1,382.00 commodities & 1;uIpplics 10,585.00 .00 10,585.00 1,515.39 .00 6,865.00 3,720.00 65 3,217.97 011101 1 x1poindiftlics .00 .00 .00 .00 .00 .00 .00 +++ .00 Huildings .00 .00 .00 .00 .00 .00 .00 +++ .00 Huilding DmIploveirrents .00 .00 .00 12,896.11 .00 25,177.10 (25,177.10) +++ .00 Inter "fund i i ainsfe, s .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $173,209.00 $0.00 $173,209.00 $35,687.51 $0.00 $169,999.74 $3,209.26 98% $149,200.76 1 und 052 jX,jrj(jjjg SySt,, lj:C,,ijjji, lj:°,Jjd I otals $173,209.00 $0.00 $173,209.00 $35,687.51 $0.00 $169,999.74 $3,209.26 $149,200.76 18 �'uwtrr M�nwroecn lExpense Budget by Account Classification Report hIr()allgl 1.2/31./18 >Irlic)irI::l sc,a: II Year(:Vuvuty :]f:III (,Ilau��ed S Lll Irn� Irn� Iry Il...li :iia°� : Adopted Eudget Amended Current Morrth Y7 Y7 Eudget - Y7 % Used/ Account Classlflc:abon Eudget Arnendrnerrts Eudget Transaction® Encumbrances Transaction® Transaction® Recd Prior Year Y7 I°und 060 Vellln iialle 1114auiiuntarnauince 11°uund EXPENSE 11e15canal Savl(os, S cdai 105 R Wages 1,008,432.00 .00 1,008,432.00 118,570.62 .00 1,049,506.66 (41,074.66) 104 1,034,076.08 1 ESenefits 405,323.00 .00 405,323.00 42,566.77 .00 507,743.82 (102,420.82) 125 432,803.67 O4:11e1 EIIImplcWee cosIs 4,085.00 .00 4,085.00 .00 .00 3,984.03 100.97 98 4,031.67 contlad:ual F;Olvl(os 108,800.00 .00 108,800.00 10,148.57 .00 111,635.40 (2,835.40) 103 95,644.49 UP.ilities 3,325.00 .00 3,325.00 877.42 .00 5,397.27 (2,072.27) 162 5,075.92 Insulance .00 .00 .00 .00 .00 9,935.00 (9,935.00) +++ .00 commodities R 1;uplalles 521,779.00 .00 521,779.00 72,756.80 .00 603,312.71 (81,533.71) 116 470,612.60 Other 1x1pendlt:ur'es .00 .00 .00 .00 .00 .00 .00 +++ 1,593.26 Office II:::quipment 602.00 .00 602.00 .00 .00 298.20 303.80 50 590.00 Ol:her II:::quipment 3,864.00 .00 3,864.00 .00 .00 3,504.00 360.00 91 3,787.77 EXPENSE TOTALS $2,056,210.00 $0.00 $2,056,210.00 $244,920.18 $0.00 $2,295,317.09 ($239,107.09) 112% $2,048,215.46 "''und MO Velllnicllare 1114auliuntenance Ill:'iund Iotals $2,056,210.00 $0.00 $2,056,210.00 $244,920.18 $0.00 $2,295,317.09 ($239,107.09) $2,048,215.46 19 20 lExpense Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc,a11 Year Ac't u v u ty .]l.III C' Lided S Lll rn rn a iry StrJ11,Ig Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 062 Vellhicle Illelplaccimint ll°iund EXPENSE 011101 Ell x1poindiftlics .00 .00 .00 .00 .00 .00 .00 +++ 697,577.37 Mohr I quipirrent 2,386,000.00 572,446.00 2,958,446.00 685,109.56 .00 1,438,091.44 1,520,354.56 49 40,236.88 Ingerrune! i i aiisfe, s .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $2,386,000.00 $572,446.00 $2,958,446.00 $685,109.56 $0.00 $1,438,091.44 $1,520,354.56 49% $737,814.25 1 und (WH Vellhicle Illelplaccimint ll:'iund I otals $2,386,000.00 $572,446.00 $2,958,446.00 $685,109.56 $0.00 $1,438,091.44 $1,520,354.56 $737,814.25 20 21 lExpense Budget by Account Classification Report hir()Lllg�l 12/3 1/18 �)idc)ir :::Isc,a11 Year Ac't u v u ty .]l.III C' Lided S Lll rn rn a iry StrJ11,Ig Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transaction® Encumbrances Transaction® Transaction® Rec'd Prior Year Y7 D I und 062 . COj,jp,t,r :CqpjaC,,,jt ll:'iund EXPENSE 011101 Ell x1poindiftlics .00 .00 .00 .00 .00 .00 .00 +++ 13,708.80 Huilding DmIploveirrents .00 .00 .00 .00 .00 .00 .00 +++ .00 afri(c iciuirmciw 295,515.00 .00 295,515.00 32,850.97 .00 146,624.55 148,890.45 50 107,911.30 EXPENSE TOTALS $295,515.00 $0.00 $295,515.00 $32,850.97 $0.00 $146,624.55 $148,890.45 50% $121,620.10 1 und M2 . C011,11,ut,jr :CqpjaC,,,jt ll:'iund I otals $295,515.00 $0.00 $295,515.00 $32,850.97 $0.00 $146,624.55 $148,890.45 $121,620.10 21 22 lExpense Budget by Account Classification Report hir()LllgIl 1.2/31./18 �)id(.)ir :::Isc,aII Year Ac't u v u ty ]�� III C' Lided S Lll rn rn a iry StrJ11,Ig Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I und 063 11111slk I'4anagumint ll"iund EXPENSE contractual ;Olvl(os 27,000.00 .00 27,000.00 .00 .00 16,200.00 10,800.00 60 34,880.00 Insurance 8,566,338.00 .00 8,566,338.00 673,306.27 .00 9,561,804.85 (995,466.85) 112 8,702,684.81 commodities & 1;uIpplics 20,000.00 .00 20,000.00 333.25 .00 8,667.50 11,332.50 43 14,705.33 011ici Elllquipment .00 .00 .00 .00 .00 1,112.65 (1,112.65) +++ .00 Inger "rune! i i aiisfe, s .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $8,613,338.00 $0.00 $8,613,338.00 $673,639.52 $0.00 $9,587,785.00 ($974,447.00) 111% $8,752,270.14 1 and M3 11111slk Managumint ll:'iund I otals $8,613,338.00 $0.00 $8,613,338.00 $673,639.52 $0.00 $9,587,785.00 ($974,447.00) $8,752,270.14 22 lExpense Budget by Account Classification Report hir()Lllgl 1.2/31./18 �)idc)ir:::Isc,aII Year Ac't u v u ty ]f: III C' StrJ11,IgLided S Lll rn rn a iry Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D -/,, Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I und 070 Illollce Illenslon ll°imnd EXPENSE lonsion 130110fits 5,033,555.00 .00 5,033,555.00 469,911.65 .00 5,407,696.80 (374,141.80) 107 4,834,596.97 contractual ;Olvl(os 165,500.00 .00 165,500.00 12,053.72 .00 124,134.08 41,365.92 75 147,632.70 Insurance 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 12,558.00 commodities & 1;uIpplics 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 011101 1 x1poindiftlics 10,000.00 .00 10,000.00 .00 .00 8,190.00 1,810.00 82 10,060.00 afri(c EIIIc,ullpment .00 .00 .00 .00 .00 .00 .00 +++ .00 EXPENSE TOTALS $5,224,155.00 $0.00 $5,224,155.00 $481,965.37 $0.00 $5,540,020.88 ($315,865.88) 106% $5,004,847.67 1 und 070 Illollce Illenslon ll:'imnd I otals $5,224,155.00 $0.00 $5,224,155.00 $481,965.37 $0.00 $5,540,020.88 ($315,865.88) $5,004,847.67 23 24 lExpense Budget by Account Classification Report hir()LllgIl 1.2/31./18 �)id(.)ir Isc,aII Year Ac't u v u ty ]�� III C' Lided S Lll rn rn a iry StrJ11,Ig Adopted Fudgei: Amended Current Morifth Y7 D Y7 D Fudgei: - Y7 D Used/ Account Classificabon Fudgei: Arnendrinerifts Fudgei: Transactions Encumbrances Transactions Transactions Rec'd Prior Year Y7 D I'-and 072 ll:lic Illenslon ll:iund EXPENSE lonsion 130110fits 5,601,610.00 .00 5,601,610.00 496,838.57 .00 5,909,909.10 (308,299.10) 106 5,427,384.93 contladual ;Olvl(os 133,500.00 .00 133,500.00 17,195.00 .00 131,435.55 2,064.45 98 119,318.51 Insurance 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 13,492.00 comirroditics & 1;uIpplics 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 011101 1 x1poindiftlics 10,000.00 .00 10,000.00 .00 .00 8,000.00 2,000.00 so 9,145.00 EXPENSE TOTALS $5,760,210.00 $0.00 $5,760,210.00 $514,033.57 $0.00 $6,049,344.65 ($289,134.65) 105% $5,569,340.44 1 und 072 ll:lic Illenslon ll:''iund I otals $5,760,210.00 $0.00 $5,760,210.00 $514,033.57 $0.00 $6,049,344.65 ($289,134.65) $5,569,340.44 CTand I otals $123,691,763.00 $2,505,254.00 $126,197,017.00 $14,088,171.30 $0.00 $129,049,042.13 ($2,852,025.13) $118,510,097.72 24 TA Mount Prospc Village of Mount Prospect Mount Prospect, Illinois INTEROFFICE MEMORANDUM TO: VILLAGE PRESIDENT AND BOARD OF TRUSTEES FINANCE COMMISSION FROM: DIRECTOR OF FINANCE DATE: JANUARY 31, 2019 SUBJECT: MONTHLY FINANCIAL REPORT — DECEMBER 2018 Attached hereto are the cash position and investment statements of the Village for the month ended December 31, 2018. These statements provide a snapshot of the Village's cash position as of the month end date noted and are intended to supplement the budget revenue and expenditure summary and listing of bills you receive. The first statement presents the Village's cash position broken down by 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 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 detailed summary 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 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 November 30 was $86.0 million. During December, cash receipts totaled $5,479,567 and investment income was $90,004. Transfers to investments for the month totaled $22,735,216. Reductions in cash and cash equivalents during December totaled $9,417,680. Of this amount, payments to vendors were $7,836,984 and employee payroll expenses were $1,580,696. Outflows resulting from interfund activity totaled $411,599 while other reductions to cash totaled $10,471. Cash and cash equivalents at December 31 were $59.8 million. Investments in the Governmental and Enterprise Funds at November 30 were $6,194,904. During the month of December, investment income totaled $66,556 and transfers from cash totaled $22,735,216. 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. There was a large influx of cash to investments from proceeds of the Series 2018B bonds. Total investments at December 31 were $28,996,675. Total cash and investments for Governmental and Enterprise Funds at November 30 were $92,186,673. Cash and investments at December 31 totaled $88,806,247. This is a decrease of $3,380,426 for the month. Monthly Financial Report — December 2018 January 31, 2019 Page 2 Trust and Agency Funds - Cash and cash equivalents at November 30 was $5,984,659. During December, cash receipts totaled $187,311. Investment income for the month was $87,269. There was also a net decrease in cash due to investment activities of $1,048,678 while outflows due to Interfund activity totaled $411,599. Reductions in cash and cash equivalents during December totaled $1,144,123. Of this amount, payments to vendors were $324,160 and employee payroll and related expenses were $818,803. Other disbursements totaled $1,160. Cash and cash equivalents at December 31 were $3,654,840. Total investments at December 31 were $125,439,988, a decrease of $5,775,638 from November 30. There were investment losses of $6,824,315 and a net transfer from cash of $1,048,678 that accounted for the change. Total cash and investments for Trust and Agency Funds at November 30 were $137,200,285. Cash and investments at December 31 totaled $129,094,828. This is a decrease of $8,115,457. Summary of Cash Activity by Fund Type (page 5) This report provides a breakdown of the cash activity for the month broken down by fund type. This breakdown is useful in identifying where the activity (receipts and disbursements) is occurring. There are times during the year when activity in certain funds such as the capital improvement and special revenue funds is higher than normal. This will distort the financial picture of some of the other components of the governmental funds such as the General Fund which tends to be more level and predictable in terms of spending and receipt of revenue. Each month the report will provide detail explanation on activity of the General Fund, the Village's primary operating 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 November 30 totaled $17,904,944. During December, cash receipts totaled $3,078,091, and investment income was $1,701. Transfers from investments for the month were $1,267,996. Significant cash receipts included the state sales tax and state income tax. Sales tax revenues distributed from the State of Illinois received during December totaled $1,904,254. Of this amount, $1,798,131 was generated from the 1% state portion while $106,123 was generated from the .25% home rule portion. Sales taxes received in December were for September sales as there is a three-month lag in getting this distribution from the state. Income tax revenues distributed from the State of Illinois received during December totaled $308,439. Income taxes received in December were for November. Disbursements from the General Fund for December included payments to vendors of $2,803,875, payments for employee wages and benefits of $1,384,477 and other disbursements of $4,356. There was also a net decrease in cash from Interfund transfers totaling $1,067,241. Cash and cash equivalents at December 31 were $16,992,781, a decrease of $912,163 from November 30. In addition, investments consisting of certificates of deposit totaling $1,231,882 bring total cash and investments for the General Fund to $18,224,663. Statement of Investments (page 6-71 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 and other fixed income investments. At December 31, there was a total of $28,996,675 invested in CD's and various governmental notes. These notes and CD's are investing surplus monies available from the governmental and enterprise funds. Total investments for the governmental and enterprise funds are higher than normal as proceeds from the Series 20186 bonds are invested in various Monthly Financial Report — December 2018 January 31, 2019 Page 3 maturities and will be drawn down over a period of 15 months as work on constructing the new Police and Fire headquarters is completed. 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 more liquid money market account due to the nature of the deposit. At December 31, there was a total of $125,439,988 invested in a combination of fixed income and equity instruments. A detail 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. A breakdown of where pension funds are invested is included with this report. Conclusion This cash position report is intended to provide a snapshot of the Village's cash position as of a particular month end date. 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. This report is provided to the Village Board and Finance Commission on a monthly basis. Please do not hesitate to contact me with any questions. David O. Erb Director of Finance VILLAGE OF MOUNT PROSPECT Preliminary Cash and Investment Position Report - All Funds For the Month Ended December 31, 2018 GOVERNMENTAL AND ENTERPRISE FUNDS Disbursements: Accounts payable Payroll Other Balance at December 31, 2018 (7,836,983.61) (1,580,696.12) (10,471.33) (7,836,983.61) (1,580,696.12) (10,471.33) $ 59,809,572.13 $ 28,996,675.07 $ 88,806,247.20 TRUST AND AGENCY FUNDS * Cash and Cash Total Cash and Equivalents Investments Investments Balance at November 30, 2018 $ 85,991,768.85 $ 6,194,903.78 $ 92,186,672.63 Cash receipts 5,479,567.07 5,479,567.07 Investment income 90,003.73 66,555.76 156,559.49 Transfers from investments to cash 1,291,433.13 (1,291,433.13) - Transfers to investments from cash (24,026,648.66) 24,026,648.66 - Interfund activity 411,599.07 411,599.07 Disbursements: Accounts payable Payroll Other Balance at December 31, 2018 (7,836,983.61) (1,580,696.12) (10,471.33) (7,836,983.61) (1,580,696.12) (10,471.33) $ 59,809,572.13 $ 28,996,675.07 $ 88,806,247.20 TRUST AND AGENCY FUNDS * Disbursements: Accounts payable Payroll Flex spending Other Balance at December 31, 2018 (324,160.32) (818,802.95) (1,159.75) (324,160.32) (818,802.95) (1,159.75) $ 3,654,839.62 $ 125,439,988.39 $ 129,094,828.01 * Assets are restricted in purpose and do not represent discretionary assets of the government. 4 Cash and Cash Total Cash and Equivalents Investments Investments Balance at November 30, 2018 $ 5,984,659.29 $ 131,215,625.62 $ 137,200,284.91 Cash receipts 187,310.86 187,310.86 Investment income (loss) 87,268.97 (6,824,314.64) (6,737,045.67) Transfers from investments to cash 2,999,923.48 (2,999,923.48) - Transfers to investments from cash (4,048,600.89) 4,048,600.89 - Interfund activity (411,599.07) (411,599.07) Disbursements: Accounts payable Payroll Flex spending Other Balance at December 31, 2018 (324,160.32) (818,802.95) (1,159.75) (324,160.32) (818,802.95) (1,159.75) $ 3,654,839.62 $ 125,439,988.39 $ 129,094,828.01 * Assets are restricted in purpose and do not represent discretionary assets of the government. 4 F- c W IL O K a z Z 7 O O W Q _J OLOO0 O) R m®Nrm O (( v N w WrNO W ° 0)M r ui (D M J N I,- I'- U C Cl) V V' Q - m N M N m I`. h- m V' �' (O m A O o N (D F -m ti O]m (DMm (O MV M r V' m-1 OOf V) V' 000 N W tM0 00 U 0) V f� fA N 7 h d9 N 4s ,. U) N r m N N 0) Q ll� n w (D Z U m m OM1 (0) LO Fl -e rl z 6) p � v Q n LL W N 2 ❑ LL O - Z O Q fA r W'44 U Q m 0) M A z Q ❑U 00 _0 M O IL' a N M z W Z f`- N (0 N 0 0 0 0 OO m " (D I`- (D W O a QOD UO NmN OS m N GSN N V fl 0) N U' ❑ W JUf`-(O P -0)m U m U Z oo m m O r N M(O O1 V' 0) M P. _� r M m a v (0D CD m V O LL a ,, V' N `- N U) h0- N N U m 0 N m o M m O O N 5� r- mm06m N D I: a mcDOMaore D1m (n P 1� O tl_ m lD m ti Ifl r- (O r•. a W r 0 m m N w Z'' Q) 00301N m0M N o V' "'� l0 m Q Z❑ W O m m V' O1 m CR OW LL IA .- qv r. 0),, N N c. ❑ U Z Q t» w U O r m o O]m O PN 7NI V N A JZ v m In r- w ti ° O r- M Cl) e Lo (N+), Lo C6 Z LL Om1 ham- N VUI-3 C.1- (D N m c 0 O K W m r+M V 0)m LO (D CN N h- a........ ..e N Z i p hM- fM-_ n m ® M M. a� m W (0 w w CLC) h. N C M W LO OD C (OCO m m ® o >n � UCl) a-0 �. d Nrtiioc M om m, Go Go �� ` U hi.. W � r- N (mil .U� r � p 0 � W oN F- LL .., ® z O o Q W C6 tCL w mLL, O C Z ClUt mN� (m0 (0 D U w a O W J N V' [O m 0 (p � � ® u E Z h- ((D h- ~ W P•- M M O MV'MN Ohm- O =O U LL Q LL (f) ® p'. H N... a M .N.. N N M W V' N p U U r v LO r > m N w r N 00 WD (hO N O U) M M i CO Z m M h- O OJ 06 v WCl) N N ❑ U N M 01 co O O h- Q. 0) Cl) P` m C Cl) ((1 m It '., p) a J WN w w 0 6 w U M m Q0 -coNM V' I- Cl)O a z . U Z v r m W W Z CO N N mLU O H LL ED U�m IR a' m N N fA � z I-- ti U) (MO N co OU> N N (MO (MD N a D M O O N co N� LL V' 0) O m 'T co 09 O h+ m N M V' m 06 r r-- m mV7 m m (ND (D (QJ LU 001 O N O co W 0O1) N N N Z'..... r M r ..J r �, (O r CO LLI U 69 Ga U N l0 1- m d W Z0 W o n d a y z F c Q n (D � - U y _ W > ❑a 2 r X �w U O O z (OU� E>N O d (UO W a N W CC N N Z _ 0 .� N N U IO ❑ c Q d �, O N N N N (p Z n O O E U% QQ�_77 E E M 21 '2 N y (p N U E >> j= e = c L yN(y��C C: ,2 m W� Q m Q N m> T L r o _N 0 _N 0 i coU) � N j F U m U � F F S❑ 0 00 W z =1 p- 5 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of December 31, 2018 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,231,881.63 1,231, 881.63 POLICE & FIRE BUILDING CONSTRUCTION FUND (025) 05/08/19 12/21/18 BMO Harris Bank, NA, IL Certificate of Deposit 16571 2.330% 2,500,000.00 06/05/19 12/21/18 BMO Harris Bank, NA, IL Certificate of Deposit 16571 2.430% 3,000,000.00 07/03/19 12/21/18 BMO Harris Bank, NA, IL Certificate of Deposit 16571 2.430% 3,000,000.00 08/07/19 12/21/18 BMO Harris Bank, NA, IL Certificate of Deposit 16571 2.480% 3,000,000.00 08/31/19 12/21/18 US Treasury Note US Treasury Note 912828TN0 2.549% 2,488,278.13 09/30/19 12/21/18 US Treasury Note US Treasury Note 912828TR1 2.562% 1,991,150.46 10/31/19 12/21/18 US Treasury Note US Treasury Note 912828F62 2.581% 1,495,902.64 12/04/19 12/21/18 Capital Community Bank, UT Certificate of Deposit 33823 2.730% 243,600.00 12/04/19 12/21/18 Northeast Community Bank, NY Certificate of Deposit 29147 2.727% 243,600.00 12/04/19 12/21/18 First Capital Bank, TN Certificate of Deposit 57552 2.650% 243,800.00 12/04/19 12/21/18 Bank of China, NY Certificate of Deposit 33653 2.590% 243,900.00 12/04/19 12/21/18 Orrstown Bank, PA Certificate of Deposit 713 2.520% 244,100.00 12/04/19 12/21/18 Financial Federal Bank, TN Certificate of Deposit 31840 2.520% 244,100.00 12/15/19 12/21/18 US Treasury Note US Treasury Note 912828073 2.602% 1,161,001.05 01/31/20 12/21/18 US Treasury Note US Treasury Note 9128281152 2.599% 1,074,246.23 02/29/20 12/21/18 US Treasury Note US Treasury Note 912828UQI 2.641% 996,424.31 04/08/20 12/21/18 Servisfirst Bank, FL Certificate of Deposit 57993 2.784% 241,200.00 04/08/20 12/21/18 Cornerstone Bank -York NE Certificate of Deposit 5496 2.687% 241,500.00 04/08/20 12/21/18 Sonabank, VA Certificate of Deposit 57968 2.691% 241,500.00 04/08/20 12/21/18 Bank OZK, AR Certificate of Deposit 110 2.623% 241,700.00 05/06/20 12/21/18 CFG Community Bank, MD Certificate of Deposit 34294 2.743% 240,900.00 05/06/20 12/21/18 First Internet Bank of Indiana, IN Certificate of Deposit 34607 2.725% 240,900.00 05/06/20 12/21/18 Modern Bank, National Association, NY Certificate of Deposit 22398 2.640% 168,305.30 05/06/20 12/21/18 Newbank, NA, NY Certificate of Deposit 58203 2.640% 241,200.00 24,027,308.12 VEHICLE REPLACEMENT FUND (061) 05/30/19 12/28/17 Freddie Mac Agency Notes 3137EADGI 1.750% 1,246,036.25 06/12/20 12/28/17 Federal Home Loan Bank Agency Notes 313383MB4 1.875% 1,237,807.50 12/11/20 12/28/17 Federal Home Loan Bank Agency Notes 3130A3UQ5 1.875% 1,233,553.75 3,717,397.50 RISK MANAGEMENT FUND (063) 03/06/19 03/06/17 Mount Prospect State Bank Certificate of Deposit 354058 0.250% 20,087.82 20,087.82 TOTAL GOVERNMENTAL AND ENTERPRISE FUNDS $ 28,996,675.07 VILLAGE OF MOUNT PROSPECT STATEMENT OF INVESTMENTS As of December 31, 2018 Maturity Purchase Financial Date Date Institution Various POLICE PENSION FUND (070) Various Various Wells Fargo Various Various Various Investment CUSIP/ Description Acct # Wells Fargo Investments Various Mutual Fund Investments Various FIRE PENSION FUND (071) Various 5/26/2015 Principal Life Insurance Company Group Annuity Contract Various Various Wells Fargo Wells Fargo Investments Various Various Various Mutual Fund Investments TOTAL TRUST AND AGENCY 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,196,727.14 Various 42,656,272.46 64,852,999.60 Variable 6,085,331.31 Various 23,696,744.44 Various 30,804,913.04 60,586,988.79 $ 125,439,988.39