Loading...
HomeMy WebLinkAbout2017 Revenue and Expenditures CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 101 - GENERAL FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET GENERAL PROPERTY TAXES 101-31010-000GENL PROP TAXES-CUR & DELIN5,216,002.785,216,002.785,193,661.00( 22,341.78)100.43 101-31020-000GNRL PROP TAXES-PENALTY & INT1,214.661,214.66.00( 1,214.66).00 101-31030-000OTHER PROPERTY TAXES26.6926.69.00( 26.69).00 101-31050-000PMT IN LIEU OF TAXES72,154.2272,154.2273,000.00845.7898.84 101-31060-000TAX ABATEMENTS/ADJUSTMENTS( 3,279.21)( 3,279.21).003,279.21.00 101-31410-000HOTEL- MOTEL ROOM TAX1,362.141,362.141,500.00137.8690.81 TOTAL GENERAL PROPERTY TAXES5,287,481.285,287,481.285,268,161.00( 19,320.28)100.37 BUSINESS LICENSES & PERMITS 101-33010-000GENERAL CONTRACTORS LICENSE4,515.004,515.002,500.00( 2,015.00)180.60 101-33020-000REFUSE LICENSE1,350.001,350.001,050.00( 300.00)128.57 101-33040-000CIGARETTE LICENSES1,200.001,200.00750.00( 450.00)160.00 101-33050-000LIQUOR LICENSES32,152.0032,152.0035,050.002,898.0091.73 101-33060-000NON-INTOX MALT LIQ LICENCES580.00580.00690.00110.0084.06 101-33070-000AMUSEMENT LICENSES330.00330.00150.00( 180.00)220.00 101-33080-000HOME OCCUPATION LICENSES405.00405.00105.00( 300.00)385.71 101-33085-000RIGHT OF WAY PERMITS2,100.002,100.001,500.00( 600.00)140.00 101-33090-000KENNEL LICENSES100.00100.00.00( 100.00).00 101-33095-000FIREWORKS SALES LICENSES200.00200.00200.00.00100.00 101-33100-000OTHER LICENSES955.00955.00100.00( 855.00)955.00 101-33105-000LAWN FERTILIZER LICENSE200.00200.00100.00( 100.00)200.00 101-33110-000INVESTIGATION FEES500.00500.00.00( 500.00).00 TOTAL BUSINESS LICENSES & PERMITS44,587.0044,587.0042,195.00( 2,392.00)105.67 NON-BUSINESS LIC & PERMITS 101-34010-000BUILDING PERMITS117,134.05117,134.0550,000.00( 67,134.05)234.27 101-34015-000FIRE PROTECTION PERMITS6,373.776,373.772,000.00( 4,373.77)318.69 101-34020-000PLUMBING PERMITS4,641.194,641.192,000.00( 2,641.19)232.06 TOTAL NON-BUSINESS LIC & PERMITS128,149.01128,149.0154,000.00( 74,149.01)237.31 FINES & FORFEITS 101-35010-000COURT FINES48,423.3448,423.3440,000.00( 8,423.34)121.06 101-35040-000OTHER FINES & FORFEITS1,600.001,600.00.00( 1,600.00).00 TOTAL FINES & FORFEITS50,023.3450,023.3440,000.00( 10,023.34)125.06 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 1 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 101 - GENERAL FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET INTERGOVERNMENTAL REVENUE 101-36070-000POLICE AID80,854.2780,854.2775,000.00( 5,854.27)107.81 101-36090-000OTHER STATE REVENUE - PERA AID35,014.0035,014.002,040.00( 32,974.00)1,716.37 101-36100-000OTHER LOCAL GOVERNMENTS318.90318.90.00( 318.90).00 101-36110-000RECYCLING GRANT14,356.0014,356.0010,000.00( 4,356.00)143.56 101-36140-000STATE GRANT - PUBLIC SAFETY8,102.268,102.267,000.00( 1,102.26)115.75 TOTAL INTERGOVERNMENTAL REVENUE138,645.43138,645.4394,040.00( 44,605.43)147.43 CHARGES FOR SERVICES 101-37010-000GENERAL GOVERNMENT8,837.648,837.647,000.00( 1,837.64)126.25 101-37020-000SPECIAL FIRE PROTECTION SRVS26,039.1126,039.11.00( 26,039.11).00 101-37060-000CHARGES TO OTHER FUNDS5,350.005,350.005,350.00.00100.00 101-37065-000TIF ADMINISTRATION FEES515.30515.30250.00( 265.30)206.12 101-37080-000DEVELOPMENT CHARGE50,020.0050,020.0040,000.00( 10,020.00)125.05 TOTAL CHARGES FOR SERVICES90,762.0590,762.0552,600.00( 38,162.05)172.55 MISCELLANEOUS REVENUE 101-38010-000INTEREST ON INVESTMENTS51,584.2451,584.24.00( 51,584.24).00 101-38015-000INTEREST-MARKET VALUE ADJ( 1,491.76)( 1,491.76).001,491.76.00 101-38030-000SALE OF MUNICIPAL PROPERTY8,188.008,188.00.00( 8,188.00).00 101-38050-000OTHER REFUNDS & REIMBURSE105,887.20105,887.2083,000.00( 22,887.20)127.57 101-38060-000DONATIONS & CONTRIBUTIONS1,050.001,050.00.00( 1,050.00).00 101-38230-000CUSTOMER COLLECTIONS - GARBAGE4,470.714,470.715,500.001,029.2981.29 101-38270-000CUSTOMER COLL- PENALTY GARBAGE472.72472.72150.00( 322.72)315.15 TOTAL MISCELLANEOUS REVENUE170,161.11170,161.1188,650.00( 81,511.11)191.95 OTHER FINANCING SOURCES 101-39030-000LMICT DIVIDEND7,169.007,169.00.00( 7,169.00).00 TOTAL OTHER FINANCING SOURCES7,169.007,169.00.00( 7,169.00).00 TOTAL FUND REVENUE5,916,978.225,916,978.225,639,646.00( 277,332.22)104.92 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 2 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 101 - GENERAL FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET GENERAL MANAGEMENT/BUILDING 101-40000-201POSTAGE1,719.411,719.413,500.001,780.5949.13 101-40000-206UTILITIES78,599.0078,599.0090,000.0011,401.0087.33 101-40000-207MAINT & REP OF BLDG & STRU6,873.386,873.3810,000.003,126.6268.73 101-40000-208MAINTENANCE OF EQUIPMENT3,841.763,841.765,000.001,158.2476.84 101-40000-212OTHER CONTRACTUAL SERVICES30,286.0430,286.0431,500.001,213.9696.15 101-40000-302CLEANING SUPPLIES357.94357.94400.0042.0689.49 101-40000-303OFFICE SUPPLIES301.44301.442,100.001,798.5614.35 101-40000-307FUEL.00.003,000.003,000.00.00 101-40000-311OTHER MATERIAL & SUPPLIES4,762.344,762.346,500.001,737.6673.27 101-40000-403RENT OF EQUIPMENT910.68910.68500.00( 410.68)182.14 101-40000-408SUBSCRIPTIONS & MEMBERSHIPS7,508.647,508.648,000.00491.3693.86 101-40000-417LICENSE AND REGISTRATION FEE100.00100.00100.00.00100.00 101-40000-905FLEX PLAN FUNDING596.68596.68500.00( 96.68)119.34 101-40000-940GRANTS/CONTRIBUTIONS13,500.0013,500.0013,500.00.00100.00 TOTAL GENERAL MANAGEMENT/BUILDING149,357.31149,357.31174,600.0025,242.6985.54 MAYOR & COUNCIL 101-40100-101SALARIES OF REGULAR EMPLOYEE29,820.0029,820.0029,820.00.00100.00 101-40100-103PROF & CONSULTANT SERVICES29,360.0029,360.0030,500.001,140.0096.26 101-40100-201POSTAGE1,336.261,336.262,500.001,163.7453.45 101-40100-203TRAVEL, CONFERENCE, SCHOOLS3,931.723,931.7214,000.0010,068.2828.08 101-40100-205PRINTING & PUBLISHING9,351.749,351.7418,000.008,648.2651.95 101-40100-212OTHER CONTRACTUAL SERVICES2,570.582,570.582,600.0029.4298.87 101-40100-311OTHER MATERIAL & SUPPLIES238.68238.68500.00261.3247.74 101-40100-408SUBSCIPTIONS & MEMBERSHIPS3,066.553,066.553,500.00433.4587.62 101-40100-410FICA CONTRIBUTION2,281.202,281.202,284.002.8099.88 101-40100-910MISCELLANEOUS EXP (ANN PIC)9,676.259,676.2511,300.001,623.7585.63 TOTAL MAYOR & COUNCIL91,632.9891,632.98115,004.0023,371.0279.68 LEGAL 101-40200-103PROF & CONSULTANT SERVICES22,898.0022,898.0036,000.0013,102.0063.61 TOTAL LEGAL22,898.0022,898.0036,000.0013,102.0063.61 ELECTIONS 101-40300-208MAINT & REPAIR OF EQUIPMENT1,660.001,660.001,200.00( 460.00)138.33 TOTAL ELECTIONS1,660.001,660.001,200.00( 460.00)138.33 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 3 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 101 - GENERAL FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET CITY ADMINISTRATION 101-40400-101SALARIES OF REGULAR EMPLOYEES227,957.98227,957.98224,770.00( 3,187.98)101.42 101-40400-102SALAR OF TEMPORARY EMPLOYEE.00.005,000.005,000.00.00 101-40400-202TELEPHONE3,250.013,250.013,500.00249.9992.86 101-40400-203TRAVEL, CONFERENCE, SCHOOLS4,609.764,609.765,500.00890.2483.81 101-40400-205PRINTING & PUBLISHING.00.00100.00100.00.00 101-40400-212OTHER CONTRACTUAL SERVICES458.00458.00100.00( 358.00)458.00 101-40400-303OFFICE SUPPLIES1,585.221,585.222,000.00414.7879.26 101-40400-310BOOKS & PERIODICALS.00.00350.00350.00.00 101-40400-311OTHER MATERIALS & SUPPLIES257.21257.21500.00242.7951.44 101-40400-408SUBSCRIPTIONS & MEMBERSHIPS1,086.421,086.421,100.0013.5898.77 101-40400-409PERA CONTRIBUTION20,084.9520,084.9519,850.00( 234.95)101.18 101-40400-410FICA CONTRIBUTION16,793.4916,793.4917,600.00806.5195.42 101-40400-417LICENSE AND REGISTRATION FEE20.0020.00150.00130.0013.33 TOTAL CITY ADMINISTRATION276,103.04276,103.04280,520.004,416.9698.43 PLANNING & ZONING 101-40500-103PROF & CONSULTANT SERVICES36,371.2536,371.2530,000.00( 6,371.25)121.24 101-40500-203TRAVEL, CONFRENCE, SCHOOL60.0060.00300.00240.0020.00 101-40500-209MEETING PER DIEMS825.00825.001,500.00675.0055.00 101-40500-311OTHER MATERIALS & SUPPLIES.00.00200.00200.00.00 TOTAL PLANNING & ZONING37,256.2537,256.2532,000.00( 5,256.25)116.43 FINANCE 101-40600-101SALARIES OF REGULAR EMPLOYE170,371.14170,371.14172,613.002,241.8698.70 101-40600-202TELEPHONE672.07672.07790.00117.9385.07 101-40600-203TRAVEL CONFERENCE SCHOOLS1,682.151,682.153,000.001,317.8556.07 101-40600-212OTHER CONTRACTUAL SERVICES153.07153.07500.00346.9330.61 101-40600-303OFFICE SUPPLIES441.97441.972,000.001,558.0322.10 101-40600-311OTHER MATERIAL & SUPPLIES628.29628.29800.00171.7178.54 101-40600-408SUBSCRIPTIONS & MEMBERSHIPS746.50746.50750.003.5099.53 101-40600-409PERA CONTRIBUTION12,777.8412,777.8412,946.00168.1698.70 101-40600-410FICA CONTRIBUTION12,259.5812,259.5813,204.00944.4292.85 101-40600-417LICENSE AND REGISTRATION165.00165.00175.0010.0094.29 TOTAL FINANCE199,897.61199,897.61206,778.006,880.3996.67 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 4 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 101 - GENERAL FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET COMPUTER SYSTEM 101-40650-208MAINTENANCE OF EQUIPMENT.00.00200.00200.00.00 101-40650-212OTHER CONTRACTUAL SERVICES34,054.6334,054.6345,500.0011,445.3774.85 101-40650-311OTHER MATERIAL & SUPPLIES1,705.721,705.722,000.00294.2885.29 TOTAL COMPUTER SYSTEM35,760.3535,760.3547,700.0011,939.6574.97 AUDITING 101-40670-103PROF & CONSULTANT SERVICES32,800.0032,800.0031,120.00( 1,680.00)105.40 TOTAL AUDITING32,800.0032,800.0031,120.00( 1,680.00)105.40 INSURANCE 101-40690-404INSURANCE OF BLDG & CONTENT28,051.5028,051.5028,000.00( 51.50)100.18 101-40690-405INSURANCE ON EQUIPMENT6,058.506,058.505,700.00( 358.50)106.29 101-40690-406INS WORKMENS COMPENSATION39,656.0039,656.0049,250.009,594.0080.52 101-40690-415EMPLOYEE HEALTH LIFE & DENTAL265,555.69265,555.69272,550.006,994.3197.43 101-40690-416EMPLOYEE DISABILITY INS7,737.307,737.307,900.00162.7097.94 101-40690-418GENERAL LIABILITY INSURANCE34,004.0034,004.0030,200.00( 3,804.00)112.60 101-40690-419UMBRELLA INSURANCE7,734.007,734.007,050.00( 684.00)109.70 TOTAL INSURANCE388,796.99388,796.99400,650.0011,853.0197.04 ASSESSOR 101-40700-103PROF & CONSULTANT SERVICES24,038.7324,038.7323,600.00( 438.73)101.86 TOTAL ASSESSOR24,038.7324,038.7323,600.00( 438.73)101.86 ENGINEERING 101-41000-103PROF & CONSULTANT SERVICES24,273.8224,273.8230,000.005,726.1880.91 TOTAL ENGINEERING24,273.8224,273.8230,000.005,726.1880.91 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 5 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 101 - GENERAL FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET POLICE DEPARTMENT 101-41510-101SALARIES OF REGULAR EMPLOY972,651.47972,651.47998,550.0025,898.5397.41 101-41510-102SALAR OF TEMPORARY EMPLOYEE.00.0026,200.0026,200.00.00 101-41510-103PROF & CONSULTANT SERVICES56,497.1056,497.1060,667.004,169.9093.13 101-41510-201POSTAGE339.93339.93500.00160.0767.99 101-41510-202TELEPHONE7,194.477,194.477,500.00305.5395.93 101-41510-203TRAVEL, CONFERENCE, SCHOOLS9,821.019,821.0110,000.00178.9998.21 101-41510-208MAINT & REPAIR OF EQUIP16,290.0816,290.0815,000.00( 1,290.08)108.60 101-41510-212OTHER CONTRACTUAL SERVICES24,105.5924,105.5927,552.003,446.4187.49 101-41510-303OFFICE SUPPLIES1,151.031,151.031,500.00348.9776.74 101-41510-307MOTOR FUELS & LUBRICANTS18,156.9618,156.9630,000.0011,843.0460.52 101-41510-310BOOKS & PERIODICALS.00.00300.00300.00.00 101-41510-311OTHER MATERIALS & SUPPLIES10,601.6310,601.6311,330.00728.3793.57 101-41510-312UNIFORMS10,676.6010,676.6019,550.008,873.4054.61 101-41510-408SUBSCRIPTIONS & MEMBERSHIPS1,015.001,015.00950.00( 65.00)106.84 101-41510-409PERA CONTRIBUTION151,833.02151,833.02158,985.007,151.9895.50 101-41510-410FICA CONTRIBUTION16,904.6116,904.6118,832.001,927.3989.77 101-41510-417LICENSE OR REGISTRATION FEE194.25194.25500.00305.7538.85 TOTAL POLICE DEPARTMENT1,297,432.751,297,432.751,387,916.0090,483.2593.48 FIRE PROTECTION 101-41520-212OTHER CONTRACTUAL SERVICES241,689.00241,689.00237,300.00( 4,389.00)101.85 101-41520-214INSPECTION SERVICES3,292.703,292.701,000.00( 2,292.70)329.27 101-41520-311OTHER MATERIAL & SUPPLIES2,000.002,000.002,000.00.00100.00 TOTAL FIRE PROTECTION246,981.70246,981.70240,300.00( 6,681.70)102.78 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 6 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 101 - GENERAL FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET BUILDING INSPECTIONS 101-41530-101SALARIES OF REGULAR EMPL84,570.2084,570.2085,820.001,249.8098.54 101-41530-201POSTAGE157.48157.48200.0042.5278.74 101-41530-202TELEPHONE704.10704.10650.00( 54.10)108.32 101-41530-203TRAVEL, CONFERENCE, SCHOOLS130.00130.001,500.001,370.008.67 101-41530-208MAINTENANCE OF EQUIPMENT378.86378.86400.0021.1494.72 101-41530-212OTHER CONTRACTUAL SERVICES5.235.231,000.00994.77.52 101-41530-303OFFICE SUPPLIES198.41198.41400.00201.5949.60 101-41530-307MOTOR FUELS & LUBRICANTS163.56163.56400.00236.4440.89 101-41530-310BOOKS & PERIODICALS.00.001,200.001,200.00.00 101-41530-311OTHER MATERIAL & SUPPLIES32.1332.13500.00467.876.43 101-41530-312UNIFORMS9.969.96400.00390.042.49 101-41530-408SUBSCRIPTIONS & MEMBERSHIPS135.00135.00150.0015.0090.00 101-41530-409PERA CONTRIBUTION6,342.686,342.686,436.0093.3298.55 101-41530-410FICA CONTRIBUTION5,924.725,924.726,565.00640.2890.25 101-41530-417LICENSE OR REGISTRATION FEE.00.00300.00300.00.00 TOTAL BUILDING INSPECTIONS98,752.3398,752.33105,921.007,168.6793.23 EMERGENCY MANAGEMENT 101-41540-206UTILITIES96.3696.36110.0013.6487.60 101-41540-212OTHER CONTRACTUAL SERVICES2,117.462,117.461,500.00( 617.46)141.16 TOTAL EMERGENCY MANAGEMENT2,213.822,213.821,610.00( 603.82)137.50 ANIMAL CONTROL 101-41550-212OTHER CONTRACTUAL SERVICES259.00259.001,500.001,241.0017.27 101-41550-311OTHER MATERIALS & SUPPLIES660.62660.62150.00( 510.62)440.41 TOTAL ANIMAL CONTROL919.62919.621,650.00730.3855.73 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 7 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 101 - GENERAL FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET PUBLIC WKS-STREET MAINTENANCE 101-42010-101SALARIES OF REG EMPLOYEES23,684.6123,684.6125,514.001,829.3992.83 101-42010-103PROF & CONSULTANT SERVICES.00.00800.00800.00.00 101-42010-107UNEMPLOYMENT80.4680.46490.00409.5416.42 101-42010-201POSTAGE14.2414.24300.00285.764.75 101-42010-202TELEPHONE366.79366.79310.00( 56.79)118.32 101-42010-203TRAVEL, CONFERENCE, SCHOOLS848.26848.26800.00( 48.26)106.03 101-42010-206UTILITIES2,893.782,893.783,600.00706.2280.38 101-42010-208MAINT & REPAIR OF EQUIPMENT5,543.075,543.075,000.00( 543.07)110.86 101-42010-212OTHER CONTRACTUAL SERVICES16,559.0816,559.0845,500.0028,940.9236.39 101-42010-301CHEMICAL SUPPLIES.00.00700.00700.00.00 101-42010-302CLEANING SUPPLIES.00.0050.0050.00.00 101-42010-303OFFICE SUPPLIES85.3085.30300.00214.7028.43 101-42010-307MOTOR FUELS & LUBRICANTS521.68521.681,050.00528.3249.68 101-42010-308SMALL TOOLS268.64268.641,000.00731.3626.86 101-42010-311OTHER MATERIAL & SUPPLIES5,190.855,190.855,200.009.1599.82 101-42010-312UNIFORMS149.24149.24400.00250.7637.31 101-42010-313STREET SIGNS6,499.486,499.486,500.00.5299.99 101-42010-403RENT OF EQUIPMENT61.0061.00500.00439.0012.20 101-42010-409PERA CONTRIBUTION1,774.941,774.941,914.00139.0692.73 101-42010-410FICA CONTRIBUTION1,781.011,781.011,952.00170.9991.24 101-42010-417LICENSE OR REGISTRATION FEE.00.00100.00100.00.00 TOTAL PUBLIC WKS-STREET MAINTENANCE 66,322.4366,322.43101,980.0035,657.5765.03 PUBLIC WKS-SNOW REMOVAL 101-42020-208MAINT & REPAIR OF EQUIPMENT764.60764.601,000.00235.4076.46 101-42020-212OTHER CONTRACTUAL SERVICES113,287.66113,287.66200,000.0086,712.3456.64 101-42020-311OTHER MATERIAL & SUPPLIES384.65384.651,000.00615.3538.47 TOTAL PUBLIC WKS-SNOW REMOVAL114,436.91114,436.91202,000.0087,563.0956.65 PUBLIC WKS-STREET LIGHTING 101-42030-206UTILITIES61,438.3061,438.3068,600.007,161.7089.56 101-42030-212OTHER CONTRACTUAL SERVICES.00.002,000.002,000.00.00 TOTAL PUBLIC WKS-STREET LIGHTING61,438.3061,438.3070,600.009,161.7087.02 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 8 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 101 - GENERAL FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET ARBORIST 101-42040-103PROF & CONSULTANT SERVICES.00.005,000.005,000.00.00 101-42040-201POSTAGE43.2043.2050.006.8086.40 101-42040-203TRAVEL CONFERENCE SCHOOLS259.39259.39.00( 259.39).00 101-42040-408DUES & MEMBERSHIPS320.25320.25250.00( 70.25)128.10 TOTAL ARBORIST622.84622.845,300.004,677.1611.75 SANITATION & WASTE REMOVAL 101-42510-201POSTAGE657.24657.241,000.00342.7665.72 101-42510-205PRINTING & PUBLISHING842.26842.26700.00( 142.26)120.32 101-42510-210CLEANING & WASTE REMOVAL202,187.76202,187.76214,000.0011,812.2494.48 101-42510-212OTHER CONTRACTUAL SERVICES.00.00600.00600.00.00 101-42510-704RECYCLING AWARD309.88309.88600.00290.1251.65 TOTAL SANITATION & WASTE REMOVAL203,997.14203,997.14216,900.0012,902.8694.05 TREE REMOVAL/PLANTING 101-42520-212OTHER CONTRACTUAL SERVICES34,725.0034,725.0035,000.00275.0099.21 TOTAL TREE REMOVAL/PLANTING34,725.0034,725.0035,000.00275.0099.21 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 9 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 101 - GENERAL FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET PARKS 101-44010-101SALARIES OF REGULAR EMPLOYE28,819.1628,819.1628,007.00( 812.16)102.90 101-44010-102SALARY OF PART TIME EMPLOYEE18,423.6318,423.6332,400.0013,976.3756.86 101-44010-103PROF & CONSULTANT SERVICES100.00100.00300.00200.0033.33 101-44010-107UNEMPLOYMENT1,477.751,477.751,500.0022.2598.52 101-44010-108SUMMER PARKS COOR WAGES8,455.018,455.018,000.00( 455.01)105.69 101-44010-201POSTAGE10.7310.73150.00139.277.15 101-44010-202TELEPHONE2,004.802,004.802,100.0095.2095.47 101-44010-203TRAVEL, CONFERENCE, SCHOOLS6,114.626,114.622,700.00( 3,414.62)226.47 101-44010-206UTILITIES5,091.325,091.325,500.00408.6892.57 101-44010-207MAINT & REP OF BLDG & STRUC752.69752.695,000.004,247.3115.05 101-44010-208MAINT & REPAIR OF EQUIP345.89345.894,500.004,154.117.69 101-44010-209MEETING PER DIEMS950.00950.001,500.00550.0063.33 101-44010-212OTHER CONTRACTUAL SERVICES34,169.0834,169.0847,500.0013,330.9271.93 101-44010-301CHEMICAL SUPPLIES364.88364.882,000.001,635.1218.24 101-44010-302CLEANING SUPPLIES266.13266.13200.00( 66.13)133.07 101-44010-303OFFICE SUPPLIES32.5532.55300.00267.4510.85 101-44010-307MOTOR FUELS & LUBRICANTS456.42456.421,300.00843.5835.11 101-44010-308SMALL TOOLS1,171.861,171.862,000.00828.1458.59 101-44010-311OTHER MATERIAL & SUPPLIES17,723.1517,723.1515,500.00( 2,223.15)114.34 101-44010-312UNIFORMS398.47398.47600.00201.5366.41 101-44010-314REC SUPPLIES-SUMMER PROG8,202.938,202.939,000.00797.0791.14 101-44010-403RENT OF EQUIPMENT1,016.601,016.601,100.0083.4092.42 101-44010-409PERA CONTRIBUTION2,166.282,166.282,100.00( 66.28)103.16 101-44010-410FICA CONTRIBUTION4,298.364,298.365,215.00916.6482.42 TOTAL PARKS142,812.31142,812.31178,472.0035,659.6980.02 OTHER EXPENDITURES 101-44444-920TRANS OUT-TO OTHER FUNDS2,528,949.002,528,949.001,697,825.00( 831,124.00)148.95 TOTAL OTHER EXPENDITURES2,528,949.002,528,949.001,697,825.00( 831,124.00)148.95 CONTINGENCY 101-46000-703CONTINGENCIES785.70785.7015,000.0014,214.305.24 TOTAL CONTINGENCY785.70785.7015,000.0014,214.305.24 TOTAL FUND EXPENDITURES6,084,864.936,084,864.935,639,646.00( 445,218.93)107.89 NET REVENUE OVER EXPENDITURES( 167,886.71)( 167,886.71).00167,886.71.00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 10 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 202 - FORFEITURE/SEIZURE FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET MISCELLANEOUS REVENUE 202-38010-000INTEREST ON INVESTMENTS101.88101.88.00( 101.88).00 202-38015-000INTEREST-MARKET VALUE ADJ( 5.12)( 5.12).005.12.00 TOTAL MISCELLANEOUS REVENUE96.7696.76.00( 96.76).00 OTHER FINANCING SOURCES 202-39070-000POLICE DEPT CONFISCATIONS8,060.048,060.04.00( 8,060.04).00 TOTAL OTHER FINANCING SOURCES8,060.048,060.04.00( 8,060.04).00 TOTAL FUND REVENUE8,156.808,156.80.00( 8,156.80).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 11 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 202 - FORFEITURE/SEIZURE FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 202-44444-311OTHER MATERIAL & SUPPLIES5,487.435,487.43.00( 5,487.43).00 TOTAL OTHER EXPENDITURES5,487.435,487.43.00( 5,487.43).00 TOTAL FUND EXPENDITURES5,487.435,487.43.00( 5,487.43).00 NET REVENUE OVER EXPENDITURES2,669.372,669.37.00( 2,669.37).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 12 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 204 - ECONOMIC DEVELOPMENT AUTHOR PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET MISCELLANEOUS REVENUES 204-38010-000INTEREST ON INVESTMENTS427.30427.30.00( 427.30).00 204-38015-000INTEREST-MARKET VALUE ADJ3.823.82.00( 3.82).00 TOTAL MISCELLANEOUS REVENUES431.12431.12.00( 431.12).00 TOTAL FUND REVENUE431.12431.12.00( 431.12).00 NET REVENUE OVER EXPENDITURES431.12431.12.00( 431.12).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 13 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 205 - TIF DISTRICT-OAKGREEN COMMONS PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET GENERAL PROPERTY TAXES 205-31010-000GENL PROP TAXES-CUR & DELIN215,196.88215,196.88.00( 215,196.88).00 TOTAL GENERAL PROPERTY TAXES215,196.88215,196.88.00( 215,196.88).00 205-38010-000INTEREST ON INVESTMENTS1,829.121,829.12.00( 1,829.12).00 205-38015-000INTEREST-MARKET VALUE ADJ( 145.70)( 145.70).00145.70.00 TOTAL SOURCE 381,683.421,683.42.00( 1,683.42).00 TOTAL FUND REVENUE216,880.30216,880.30.00( 216,880.30).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 14 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 205 - TIF DISTRICT-OAKGREEN COMMONS PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 205-44444-205PRINTING & PUBLISHING28.7028.70.00( 28.70).00 205-44444-212OTHER CONTRACTUAL SERVICES240.00240.00.00( 240.00).00 205-44444-701REFUNDS AND REIMBURSEMENTS172,157.50172,157.50.00( 172,157.50).00 205-44444-915TRF OUT TO GF-ADMIN FEE515.30515.30.00( 515.30).00 TOTAL OTHER EXPENDITURES172,941.50172,941.50.00( 172,941.50).00 TOTAL FUND EXPENDITURES172,941.50172,941.50.00( 172,941.50).00 NET REVENUE OVER EXPENDITURES43,938.8043,938.80.00( 43,938.80).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 15 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 206 - TIF DIST #2-OSGOOD FRONTAGE PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET 206-38010-000INTEREST ON INVESTMENTS44.1344.13.00( 44.13).00 206-38015-000INTEREST-MARKET VALUE ADJ5.765.76.00( 5.76).00 TOTAL SOURCE 3849.8949.89.00( 49.89).00 TOTAL FUND REVENUE49.8949.89.00( 49.89).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 16 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 206 - TIF DIST #2-OSGOOD FRONTAGE PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 206-44444-103PROF & CONSULTANT SERVICES1,680.001,680.00.00( 1,680.00).00 TOTAL OTHER EXPENDITURES1,680.001,680.00.00( 1,680.00).00 TOTAL FUND EXPENDITURES1,680.001,680.00.00( 1,680.00).00 NET REVENUE OVER EXPENDITURES( 1,630.11)( 1,630.11).001,630.11.00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 17 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 401 - BUDGETED PROJECTS FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET 401-37080-000DEVELOPMENT CHARGE1,350.001,350.00.00( 1,350.00).00 TOTAL SOURCE 371,350.001,350.00.00( 1,350.00).00 MISCELLANEOUS REVENUE 401-38010-000INTEREST ON INVESTMENTS39,691.9939,691.99.00( 39,691.99).00 401-38015-000INTEREST-MARKET VALUE ADJ712.95712.95.00( 712.95).00 TOTAL MISCELLANEOUS REVENUE40,404.9440,404.94.00( 40,404.94).00 OTHER FINANCING SOURCES 401-39020-000TRANSF IN (FROM OTHER FUND)1,343,574.001,343,574.00.00( 1,343,574.00).00 TOTAL OTHER FINANCING SOURCES1,343,574.001,343,574.00.00( 1,343,574.00).00 TOTAL FUND REVENUE1,385,328.941,385,328.94.00( 1,385,328.94).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 18 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 401 - BUDGETED PROJECTS FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 401-44444-103PROF & CONSULTANT SERVICES81,494.7081,494.70.00( 81,494.70).00 401-44444-205PRINTING & PUBLISHING176.28176.28.00( 176.28).00 401-44444-207MAINT & REP OF BLDG & STRUC11,207.9711,207.97.00( 11,207.97).00 401-44444-212OTHER CONTRACTUAL SERVICES455,471.07455,471.07.00( 455,471.07).00 401-44444-311OTHER MATERIAL & SUPPLIES17,973.5617,973.56.00( 17,973.56).00 401-44444-502BUILDING AND STRUCTURES17,866.1217,866.12.00( 17,866.12).00 401-44444-503FURNITURE AND EQUIPMENT25,902.9625,902.96.00( 25,902.96).00 401-44444-504OTHER IMPROVEMENTS20,122.1820,122.18.00( 20,122.18).00 401-44444-505MACHINERY & AUTOMOTIVE EQUI198,889.40198,889.40.00( 198,889.40).00 401-44444-920TRANSFER OUT (TO OTHER FDS)150,000.00150,000.00.00( 150,000.00).00 TOTAL OTHER EXPENDITURES979,104.24979,104.24.00( 979,104.24).00 TOTAL FUND EXPENDITURES979,104.24979,104.24.00( 979,104.24).00 NET REVENUE OVER EXPENDITURES406,224.70406,224.70.00( 406,224.70).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 19 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 405 - PARK & REC DEVELOPMENT FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET MISCELLANEOUS REVENUES 405-38010-000INTEREST7,229.017,229.01.00( 7,229.01).00 405-38015-000INTEREST-MARKET VALUE ADJ1,160.931,160.93.00( 1,160.93).00 405-38095-000LAND DEDICATION FEE43,280.0043,280.00.00( 43,280.00).00 TOTAL MISCELLANEOUS REVENUES51,669.9451,669.94.00( 51,669.94).00 OTHER FINANCING SOURCES 405-39020-000TRANSFERS IN FROM OTHER FUNDS390,000.00390,000.00.00( 390,000.00).00 TOTAL OTHER FINANCING SOURCES390,000.00390,000.00.00( 390,000.00).00 TOTAL FUND REVENUE441,669.94441,669.94.00( 441,669.94).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 20 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 405 - PARK & REC DEVELOPMENT FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 405-44444-205PRINTING AND PUBLISHING419.75419.75.00( 419.75).00 405-44444-212OTHER CONTRACTUAL SERVICES3,511.683,511.68.00( 3,511.68).00 405-44444-311OTHER MATERIAL & SUPPLIES1,526.721,526.72.00( 1,526.72).00 405-44444-502BUILDING AND STRUCTURES435,763.00435,763.00.00( 435,763.00).00 405-44444-504OTHER IMPROVEMENTS179,598.49179,598.49.00( 179,598.49).00 405-44444-920TRANS OUT (TO OTHER FUND)45,000.0045,000.00.00( 45,000.00).00 TOTAL OTHER EXPENDITURES665,819.64665,819.64.00( 665,819.64).00 TOTAL FUND EXPENDITURES665,819.64665,819.64.00( 665,819.64).00 NET REVENUE OVER EXPENDITURES( 224,149.70)( 224,149.70).00224,149.70.00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 21 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 407 - MOELTER PARK FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET MISCELLANEOUS REVENUE 407-38010-000INTEREST2,413.722,413.72.00( 2,413.72).00 407-38015-000INTEREST-MARKET VALUE ADJ368.69368.69.00( 368.69).00 TOTAL MISCELLANEOUS REVENUE2,782.412,782.41.00( 2,782.41).00 TOTAL FUND REVENUE2,782.412,782.41.00( 2,782.41).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 22 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 407 - MOELTER PARK FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 407-44444-103PROF & CONSULTANT SERVICES1,505.001,505.00.00( 1,505.00).00 407-44444-920TRANSFER OUT (TO OTHER FDS)140,000.00140,000.00.00( 140,000.00).00 TOTAL OTHER EXPENDITURES141,505.00141,505.00.00( 141,505.00).00 TOTAL FUND EXPENDITURES141,505.00141,505.00.00( 141,505.00).00 NET REVENUE OVER EXPENDITURES( 138,722.59)( 138,722.59).00138,722.59.00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:00AM PAGE: 23 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 500 - REVOLVING CAPITAL FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET MISCELLANEOUS REVENUE 500-38010-000INTEREST ON INVESTMENTS4,773.634,773.63.00( 4,773.63).00 500-38015-000INTEREST-MARKET VALUE ADJ48.9548.95.00( 48.95).00 TOTAL MISCELLANEOUS REVENUE4,822.584,822.58.00( 4,822.58).00 TOTAL FUND REVENUE4,822.584,822.58.00( 4,822.58).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 24 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 500 - REVOLVING CAPITAL FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 500-44444-103PROF & CONSULTANT SERVICES1,941.971,941.97.00( 1,941.97).00 TOTAL OTHER EXPENDITURES1,941.971,941.97.00( 1,941.97).00 TOTAL FUND EXPENDITURES1,941.971,941.97.00( 1,941.97).00 NET REVENUE OVER EXPENDITURES2,880.612,880.61.00( 2,880.61).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 25 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 527 - GO CAPITAL IMPRV BONDS 2009A PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET MISCELLANEOUS REVENUES 527-38010-000INTEREST ON INVESTMENT482.23482.23.00( 482.23).00 527-38015-000INTEREST-MARKET VALUE ADJ6.466.46.00( 6.46).00 TOTAL MISCELLANEOUS REVENUES488.69488.69.00( 488.69).00 OTHER FINANCING SOURCES 527-39020-000TRANSFERS IN FROM OTHER FUND143,000.00143,000.00.00( 143,000.00).00 TOTAL OTHER FINANCING SOURCES143,000.00143,000.00.00( 143,000.00).00 TOTAL FUND REVENUE143,488.69143,488.69.00( 143,488.69).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 26 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 527 - GO CAPITAL IMPRV BONDS 2009A PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 527-44444-601DEBT SERVICE-PRINCIPAL130,000.00130,000.00.00( 130,000.00).00 527-44444-602DEBT-SERVICE INTEREST14,115.0014,115.00.00( 14,115.00).00 527-44444-603FISCAL AGENTS CHARGE495.00495.00.00( 495.00).00 TOTAL OTHER EXPENDITURES144,610.00144,610.00.00( 144,610.00).00 TOTAL FUND EXPENDITURES144,610.00144,610.00.00( 144,610.00).00 NET REVENUE OVER EXPENDITURES( 1,121.31)( 1,121.31).001,121.31.00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 27 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 528 - GO CIP REFUNDING BONDS 2012A PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET MISCELLANEOUS REVENUES 528-38010-000INTEREST ON INVESTMENT987.99987.99.00( 987.99).00 528-38015-000INTEREST-MARKET VALUE ADJ15.2715.27.00( 15.27).00 TOTAL MISCELLANEOUS REVENUES1,003.261,003.26.00( 1,003.26).00 OTHER FINANCING SOURCES 528-39020-000TRANSFERS IN FROM OTHER FUND410,000.00410,000.00.00( 410,000.00).00 TOTAL OTHER FINANCING SOURCES410,000.00410,000.00.00( 410,000.00).00 TOTAL FUND REVENUE411,003.26411,003.26.00( 411,003.26).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 28 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 528 - GO CIP REFUNDING BONDS 2012A PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 528-44444-601DEBT SERVICE-PRINCIPAL305,000.00305,000.00.00( 305,000.00).00 528-44444-602DEBT-SERVICE INTEREST104,757.50104,757.50.00( 104,757.50).00 528-44444-603FISCAL AGENTS CHARGE495.00495.00.00( 495.00).00 TOTAL OTHER EXPENDITURES410,252.50410,252.50.00( 410,252.50).00 TOTAL FUND EXPENDITURES410,252.50410,252.50.00( 410,252.50).00 NET REVENUE OVER EXPENDITURES750.76750.76.00( 750.76).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 29 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 529 - GO CAPITAL IMPROVEMENT BD 2014 PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET SPECIAL ASSESSMENTS 529-32010-000SPECIAL ASSESS-PREPAYMENTS40,630.0040,630.00.00( 40,630.00).00 529-32020-000SPECIAL ASSESSMENTS-CURRENT100,424.81100,424.81.00( 100,424.81).00 529-32040-000SPECIAL ASSESSMENTS- PEN & INT1,091.221,091.22.00( 1,091.22).00 TOTAL SPECIAL ASSESSMENTS142,146.03142,146.03.00( 142,146.03).00 MISCELLANEOUS REVENUE 529-38010-000INTEREST ON INVESTMENT14,311.5514,311.55.00( 14,311.55).00 529-38015-000INTEREST-MARKET VALUE ADJ678.75678.75.00( 678.75).00 TOTAL MISCELLANEOUS REVENUE14,990.3014,990.30.00( 14,990.30).00 OTHER FINANCING SOURCES 529-39020-000TRANSFERS IN FROM OTHER FUND226,100.00226,100.00.00( 226,100.00).00 TOTAL OTHER FINANCING SOURCES226,100.00226,100.00.00( 226,100.00).00 TOTAL FUND REVENUE383,236.33383,236.33.00( 383,236.33).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 30 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 529 - GO CAPITAL IMPROVEMENT BD 2014 PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 529-44444-601DEBT SERVICE-PRINCIPAL400,000.00400,000.00.00( 400,000.00).00 529-44444-602DEBT-SERVICE INTEREST73,800.0073,800.00.00( 73,800.00).00 529-44444-604OTHER591.00591.00.00( 591.00).00 TOTAL OTHER EXPENDITURES474,391.00474,391.00.00( 474,391.00).00 TOTAL FUND EXPENDITURES474,391.00474,391.00.00( 474,391.00).00 NET REVENUE OVER EXPENDITURES( 91,154.67)( 91,154.67).0091,154.67.00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 31 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 565 - STREET RECONSTRUCTION PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET 565-36100-000OTHER LOCAL GOVERNMENTS2,400.792,400.79.00( 2,400.79).00 565-36120-100OTHER STATE REV - PUBLIC WORKS19,206.3519,206.35.00( 19,206.35).00 TOTAL SOURCE 3621,607.1421,607.14.00( 21,607.14).00 MISCELLANEOUS REVENUES 565-38010-000INTEREST ON INVESTMENTS25,149.0925,149.09.00( 25,149.09).00 565-38015-000INTEREST-MARKET VALUE ADJ( 470.44)( 470.44).00470.44.00 565-38060-000DONATIONS & CONTRIBUTIONS24,898.0924,898.09.00( 24,898.09).00 TOTAL MISCELLANEOUS REVENUES49,576.7449,576.74.00( 49,576.74).00 OTHER FINANCING SOURCES 565-39020-000TRANSFER IN (FROM OTHER FD)380,126.00380,126.00.00( 380,126.00).00 TOTAL OTHER FINANCING SOURCES380,126.00380,126.00.00( 380,126.00).00 TOTAL FUND REVENUE451,309.88451,309.88.00( 451,309.88).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 32 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 565 - STREET RECONSTRUCTION PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 565-44444-103PROF & CONSULTANT SERVICES27,297.1927,297.19.00( 27,297.19).00 565-44444-800CONSTRUCTION57,083.8457,083.84.00( 57,083.84).00 TOTAL OTHER EXPENDITURES84,381.0384,381.03.00( 84,381.03).00 TOTAL FUND EXPENDITURES84,381.0384,381.03.00( 84,381.03).00 NET REVENUE OVER EXPENDITURES366,928.85366,928.85.00( 366,928.85).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 33 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 572 - CITY HALL IMPROVEMENTS PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET 572-38010-000INTEREST ON INVESTMENTS1,150.431,150.43.00( 1,150.43).00 572-38015-000INTEREST-MARKET VALUE ADJ37.9937.99.00( 37.99).00 TOTAL SOURCE 381,188.421,188.42.00( 1,188.42).00 TOTAL FUND REVENUE1,188.421,188.42.00( 1,188.42).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 34 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 572 - CITY HALL IMPROVEMENTS PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET 572-44444-212OTHER CONTRACTUAL SERVICES3,240.003,240.00.00( 3,240.00).00 572-44444-503FURNITURE AND EQUIPMENT5,421.005,421.00.00( 5,421.00).00 TOTAL DEPARTMENT 444448,661.008,661.00.00( 8,661.00).00 TOTAL FUND EXPENDITURES8,661.008,661.00.00( 8,661.00).00 NET REVENUE OVER EXPENDITURES( 7,472.58)( 7,472.58).007,472.58.00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 35 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 601 - PERA INTERNAL SERVICE FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET INTERGOVERNMENTAL REVENUE 601-36090-000OTHER STATE REVENUE7,919.007,919.00.00( 7,919.00).00 TOTAL INTERGOVERNMENTAL REVENUE7,919.007,919.00.00( 7,919.00).00 CHARGES FOR SERVICES 601-37060-000CHARGES TO OTHER FUNDS205,478.00205,478.00.00( 205,478.00).00 TOTAL CHARGES FOR SERVICES205,478.00205,478.00.00( 205,478.00).00 TOTAL FUND REVENUE213,397.00213,397.00.00( 213,397.00).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 36 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 601 - PERA INTERNAL SERVICE FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 601-44444-409PERA CONTRIBUTION343,700.00343,700.00.00( 343,700.00).00 TOTAL OTHER EXPENDITURES343,700.00343,700.00.00( 343,700.00).00 TOTAL FUND EXPENDITURES343,700.00343,700.00.00( 343,700.00).00 NET REVENUE OVER EXPENDITURES( 130,303.00)( 130,303.00).00130,303.00.00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 37 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 705 - WATER UTILITY FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET SPECIAL ASSESSMENTS 705-32040-000SPECIAL ASSESSMENTS - P & I244.10244.10.00( 244.10).00 TOTAL SPECIAL ASSESSMENTS244.10244.10.00( 244.10).00 NON-BUSINESS LIC & PERMITS 705-34050-000UTILITY INSPECTION FEE650.00650.00.00( 650.00).00 705-34060-000WATER METERS- FEE10,022.4110,022.41.00( 10,022.41).00 705-34070-000CURB STOP COVER100.00100.00.00( 100.00).00 TOTAL NON-BUSINESS LIC & PERMITS10,772.4110,772.41.00( 10,772.41).00 CHARGES FOR SERVICES 705-37050-000OTHER SERVICES90.0090.00.00( 90.00).00 TOTAL CHARGES FOR SERVICES90.0090.00.00( 90.00).00 MISCELLANEOUS REVENUE 705-38010-000INTEREST ON INVESTMENTS11,887.0011,887.00.00( 11,887.00).00 705-38015-000INTEREST-MARKET VALUE ADJ249.12249.12.00( 249.12).00 705-38050-000OTHER REFUNDS & REIMBURSEMENTS1,016.031,016.03.00( 1,016.03).00 705-38230-000CUSTOMER COLLECTIONS784,520.39784,520.39750,000.00( 34,520.39)104.60 705-38250-000OTHER SERVICES1,048.541,048.54.00( 1,048.54).00 705-38270-000CUSTOMER COLLECTION-PENALTY7,509.767,509.765,000.00( 2,509.76)150.20 TOTAL MISCELLANEOUS REVENUE806,230.84806,230.84755,000.00( 51,230.84)106.79 TOTAL FUND REVENUE817,337.35817,337.35755,000.00( 62,337.35)108.26 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 38 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 705 - WATER UTILITY FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 705-48100-101SALARIES OF REGULAR EMPLOYE171,737.02171,737.02174,004.002,266.9898.70 705-48100-103PROF & CONSULTANT SERVICES8,490.508,490.507,000.00( 1,490.50)121.29 705-48100-107UNEMPLOYMENT502.85502.852,000.001,497.1525.14 705-48100-201POSTAGE1,298.261,298.261,000.00( 298.26)129.83 705-48100-202TELEPHONE3,272.643,272.643,500.00227.3693.50 705-48100-203TRAVEL CONFERENCE & SCHOOL2,484.262,484.265,200.002,715.7447.77 705-48100-205PRINTING & PUBLISHING.00.00700.00700.00.00 705-48100-206UTILITIES26,249.1926,249.1930,000.003,750.8187.50 705-48100-207MAIN & REPR OF BLDG & STRUC668.60668.604,000.003,331.4016.72 705-48100-208MAINT & REPAIR OF EQUIPMENT5,355.585,355.585,000.00( 355.58)107.11 705-48100-212OTHER CONTRACTUAL SERVICES44,579.8744,579.8747,500.002,920.1393.85 705-48100-301CHEMICAL SUPPLIES7,102.537,102.5310,500.003,397.4767.64 705-48100-303OFFICE SUPPLIES325.61325.611,000.00674.3932.56 705-48100-307MOTOR FUEL & LUBRICANTS3,272.553,272.558,000.004,727.4540.91 705-48100-308SMALL TOOLS2,593.312,593.312,000.00( 593.31)129.67 705-48100-311OTHER MATERIALS & SUPPLIES12,192.5512,192.5512,000.00( 192.55)101.60 705-48100-312UNIFORMS932.79932.791,500.00567.2162.19 705-48100-404INS OF BUILDING & CONTENTS3,699.503,699.503,500.00( 199.50)105.70 705-48100-405INSURANCE ON EQUIPMENT890.00890.00870.00( 20.00)102.30 705-48100-406INSURANCE WORKERS COMP7,851.007,851.005,335.00( 2,516.00)147.16 705-48100-408SUBSCRIPTIONS & MEMBERSHIPS696.00696.00500.00( 196.00)139.20 705-48100-409PERA CONTRIBUTION12,644.8212,644.8213,050.00405.1896.90 705-48100-410FICA CONTRIBUTION12,679.6412,679.6413,311.00631.3695.26 705-48100-415EMPLOYEE HEALTH LIFE & DENT10,835.4810,835.4818,781.007,945.5257.69 705-48100-416EMPLOYEE DISABILITY INS( 1,954.26)( 1,954.26)852.002,806.26( 229.37) 705-48100-417LICENSE & REGISTRATION FEES1,848.591,848.592,800.00951.4166.02 705-48100-418INSURANCE GENERAL LIABILITY2,906.002,906.002,700.00( 206.00)107.63 705-48100-419INSURANCE UMBRELLA2,578.002,578.002,400.00( 178.00)107.42 705-48100-920TRANS OUT (TO OTHER FUNDS)448,714.78448,714.78407,885.00( 40,829.78)110.01 705-48100-970DEPRECIATION EXP PURCHASED250,269.99250,269.99165,000.00( 85,269.99)151.68 705-48100-995LOSS ON DISP OF FIXED ASSET10,224.6910,224.69.00( 10,224.69).00 TOTAL OTHER EXPENDITURES1,054,942.341,054,942.34951,888.00( 103,054.34)110.83 TOTAL FUND EXPENDITURES1,054,942.341,054,942.34951,888.00( 103,054.34)110.83 NET REVENUE OVER EXPENDITURES( 237,604.99)( 237,604.99)( 196,888.00)40,716.99( 120.68) FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 39 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 706 - SEWER UTILITY FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET NON-BUSINESS LIC & PERMITS 706-34050-000UTILITY INSPECTION FEES70.0070.00.00( 70.00).00 TOTAL NON-BUSINESS LIC & PERMITS70.0070.00.00( 70.00).00 MISCELLANEOUS REVENUE 706-38010-000INTEREST ON INVESTMENTS9,413.629,413.62.00( 9,413.62).00 706-38015-000INTEREST-MARKET VALUE ADJ237.91237.91.00( 237.91).00 706-38050-000OTHER REFUNDS & REIMBURSEMENTS23,756.6023,756.60.00( 23,756.60).00 706-38230-000CUSTOMER COLLECTIONS972,016.55972,016.55971,000.00( 1,016.55)100.10 706-38270-000CUSTOMER COLLECTION-PENALTY11,990.2911,990.295,000.00( 6,990.29)239.81 TOTAL MISCELLANEOUS REVENUE1,017,414.971,017,414.97976,000.00( 41,414.97)104.24 TOTAL FUND REVENUE1,017,484.971,017,484.97976,000.00( 41,484.97)104.25 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 40 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 706 - SEWER UTILITY FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 706-48200-101SALARIES OF REGULAR EMPLOYE112,964.39112,964.39110,220.00( 2,744.39)102.49 706-48200-103PROF & CONSULTANT SERVICES5,023.255,023.254,000.00( 1,023.25)125.58 706-48200-107UNEMPLOYMENT301.71301.711,200.00898.2925.14 706-48200-201POSTAGE1,214.681,214.681,600.00385.3275.92 706-48200-202TELEPHONE1,375.581,375.582,100.00724.4265.50 706-48200-203TRAVEL CONFERENCE & SCHOOL229.03229.032,800.002,570.978.18 706-48200-205PRINTING & PUBLISHING.00.00400.00400.00.00 706-48200-206UTILITIES6,110.336,110.337,000.00889.6787.29 706-48200-207MAIN & REPR OF BLDG & STRUC892.50892.504,000.003,107.5022.31 706-48200-208MAINT & REPAIR OF EQUIPMENT1,482.351,482.3515,000.0013,517.659.88 706-48200-212OTHER CONTRACTUAL SERVICES46,737.9646,737.9666,000.0019,262.0470.82 706-48200-213METRO SEWER SERVICE CHARGE498,929.40498,929.40498,930.00.60100.00 706-48200-301CHEMICAL SUPPLIES1,056.001,056.001,600.00544.0066.00 706-48200-303OFFICE SUPPLIES139.48139.481,050.00910.5213.28 706-48200-307MOTOR FUELS & LUBRICANTS1,956.221,956.223,600.001,643.7854.34 706-48200-308SMALL TOOLS1,268.731,268.73600.00( 668.73)211.46 706-48200-311OTHER MATERIALS & SUPPLIES8,869.918,869.917,300.00( 1,569.91)121.51 706-48200-312UNIFORMS562.34562.34700.00137.6680.33 706-48200-404INS ON BUILDING & CONTENTS816.50816.50860.0043.5094.94 706-48200-405INSURANCE ON EQUIPMENT689.00689.00680.00( 9.00)101.32 706-48200-406INSURANCE WORKERS COMP11,902.5011,902.503,550.00( 8,352.50)335.28 706-48200-409PERA CONTRIBUTION8,261.318,261.318,266.004.6999.94 706-48200-410FICA CONTRIBUTION8,280.848,280.848,432.00151.1698.21 706-48200-415EMPLOYEE HEALTH LIFE & DENT7,365.227,365.2212,237.004,871.7860.19 706-48200-416EMPLOYEE DISABILITY INS( 3,115.58)( 3,115.58)550.003,665.58( 566.47) 706-48200-417LICENSE OR REGISTRATION FEE23.0023.00125.00102.0018.40 706-48200-418INSURANCE GENERAL LIABILITY7,231.507,231.506,900.00( 331.50)104.80 706-48200-419INSURANCE UMBRELLA2,578.002,578.002,350.00( 228.00)109.70 706-48200-920TRANS OUT (TO OTHER FUNDS)221,027.89221,027.89189,725.00( 31,302.89)116.50 706-48200-970DEPRECIATION EXP PURCHASED118,660.63118,660.6384,190.00( 34,470.63)140.94 TOTAL OTHER EXPENDITURES1,072,834.671,072,834.671,045,965.00( 26,869.67)102.57 TOTAL FUND EXPENDITURES1,072,834.671,072,834.671,045,965.00( 26,869.67)102.57 NET REVENUE OVER EXPENDITURES( 55,349.70)( 55,349.70)( 69,965.00)( 14,615.30)( 79.11) FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 41 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 707 - STORM SEWER UTILITY FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET SPECIAL ASSESSMENTS 707-32040-000SPECIAL ASSESSMENT - P & I221.07221.07.00( 221.07).00 TOTAL SPECIAL ASSESSMENTS221.07221.07.00( 221.07).00 NON BUSINESS LIC & PERMITS 707-34050-000UTILITY INSPECTION FEES70.0070.00.00( 70.00).00 TOTAL NON BUSINESS LIC & PERMITS70.0070.00.00( 70.00).00 MISCELLANEOUS REVENUE 707-38010-000INTEREST ON INVESTMENTS2,342.422,342.42.00( 2,342.42).00 707-38015-000INTEREST-MARKET VALUE ADJ( 42.55)( 42.55).0042.55.00 707-38230-000CUSTOMER COLLECTIONS82,731.9382,731.9382,560.00( 171.93)100.21 707-38270-000CUSTOMER COLLECTION-PENALTY863.55863.55300.00( 563.55)287.85 TOTAL MISCELLANEOUS REVENUE85,895.3585,895.3582,860.00( 3,035.35)103.66 TOTAL FUND REVENUE86,186.4286,186.4282,860.00( 3,326.42)104.01 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 42 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 707 - STORM SEWER UTILITY FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 707-48300-101SALARIES OF REGULAR EMPLOYE21,517.4921,517.4921,978.00460.5197.90 707-48300-103PROF & CONSULTANT SERVICES2,904.502,904.5015,000.0012,095.5019.36 707-48300-107UNEMPLOYMENT50.2850.28250.00199.7220.11 707-48300-201POSTAGE574.27574.27500.00( 74.27)114.85 707-48300-202TELEPHONE229.28229.28210.00( 19.28)109.18 707-48300-203TRAVEL CONFERENCE & SCHOOL38.1638.16200.00161.8419.08 707-48300-205PRINTING & PUBLISHING.00.00300.00300.00.00 707-48300-208MAINT & REPAIR OF EQUIPMENT247.03247.03630.00382.9739.21 707-48300-212OTHER CONTRACTUAL SERVICES16,050.3916,050.3928,000.0011,949.6157.32 707-48300-303OFFICE SUPPLIES23.2523.25100.0076.7523.25 707-48300-307MOTOR FUEL & LUBRICANTS326.04326.04700.00373.9646.58 707-48300-308SMALL TOOLS429.25429.25200.00( 229.25)214.63 707-48300-311OTHER MATERIALS & SUPPLIES882.10882.101,000.00117.9088.21 707-48300-312UNIFORMS93.2693.26150.0056.7462.17 707-48300-409PERA CONTRIBUTION1,544.531,544.531,648.00103.4793.72 707-48300-410FICA CONTRIBUTION1,549.201,549.201,682.00132.8092.10 707-48300-415EMPLOYEE HEALTH LIFE & DENT1,635.821,635.822,504.00868.1865.33 707-48300-416EMPLOYEE DISABILITY INS112.32112.32115.002.6897.67 707-48300-417LICENSE OR REGISTRATION FEE650.00650.00650.00.00100.00 707-48300-701REFUNDS & REIMBURSEMENTS763.75763.75.00( 763.75).00 707-48300-915TRF OUT TO GF-ADMIN FEE5,350.005,350.005,350.00.00100.00 707-48300-920TRANS OUT (TO OTHER FUNDS)13,850.0013,850.0013,850.00.00100.00 TOTAL OTHER EXPENDITURES68,820.9268,820.9295,017.0026,196.0872.43 TOTAL FUND EXPENDITURES68,820.9268,820.9295,017.0026,196.0872.43 NET REVENUE OVER EXPENDITURES17,365.5017,365.50( 12,157.00)( 29,522.50)142.84 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 43 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 710 - RENEWAL/REPLACEMENT FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET MISCELLANEOUS REVENUE 710-38010-000INTEREST ON INVESTMENTS43,881.2143,881.21.00( 43,881.21).00 710-38015-000INTEREST-MARKET VALUE ADJ( 25.37)( 25.37).0025.37.00 TOTAL MISCELLANEOUS REVENUE43,855.8443,855.84.00( 43,855.84).00 OTHER FINANCING SOURCES 710-39020-000TRANSFER IN (FROM OTHER FD)513,255.28513,255.28.00( 513,255.28).00 TOTAL OTHER FINANCING SOURCES513,255.28513,255.28.00( 513,255.28).00 TOTAL FUND REVENUE557,111.12557,111.12.00( 557,111.12).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 44 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 710 - RENEWAL/REPLACEMENT FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 710-44444-103PROF & CONSULTANT SERVICES19,088.1019,088.10.00( 19,088.10).00 710-44444-800CONSTRUCTION78,965.1078,965.10.00( 78,965.10).00 TOTAL OTHER EXPENDITURES98,053.2098,053.20.00( 98,053.20).00 TOTAL FUND EXPENDITURES98,053.2098,053.20.00( 98,053.20).00 NET REVENUE OVER EXPENDITURES459,057.92459,057.92.00( 459,057.92).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 45 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 712 - ST SEWER RENEWAL/REPLACE FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET MISCELLANEOUS REVENUE 712-38010-000INTEREST ON INVESTMENTS6,417.616,417.61.00( 6,417.61).00 712-38015-000INTEREST-MARKET VALUE ADJ( 41.03)( 41.03).0041.03.00 TOTAL MISCELLANEOUS REVENUE6,376.586,376.58.00( 6,376.58).00 OTHER FINANCING SOURCES 712-39020-000TRANSFERS IN FROM OTHER FUNDS87,624.0087,624.00.00( 87,624.00).00 TOTAL OTHER FINANCING SOURCES87,624.0087,624.00.00( 87,624.00).00 TOTAL FUND REVENUE94,000.5894,000.58.00( 94,000.58).00 NET REVENUE OVER EXPENDITURES94,000.5894,000.58.00( 94,000.58).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 46 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 734 - WATER TOWER REHAB PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET MISCELLANEOUS REVENUE 734-38010-000INTEREST ON INVESTMENTS5,930.745,930.74.00( 5,930.74).00 734-38015-000INTEREST-MARKET VALUE ADJ( 212.12)( 212.12).00212.12.00 734-38020-000RENT OF MUNICIPAL PROPERTY40,730.0940,730.09.00( 40,730.09).00 TOTAL MISCELLANEOUS REVENUE46,448.7146,448.71.00( 46,448.71).00 OTHER FINANCING SOURCES 734-39020-000TRANSFER IN FROM OTHER FUNDS40,479.0740,479.07.00( 40,479.07).00 TOTAL OTHER FINANCING SOURCES40,479.0740,479.07.00( 40,479.07).00 TOTAL FUND REVENUE86,927.7886,927.78.00( 86,927.78).00 NET REVENUE OVER EXPENDITURES86,927.7886,927.78.00( 86,927.78).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 47 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 735 - WELL REHABILITATION FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET MISCELLANEOUS REVENUE 735-38010-000INTEREST ON INVESTMENTS1,483.091,483.09.00( 1,483.09).00 735-38015-000INTEREST-MARKET VALUE ADJ47.9947.99.00( 47.99).00 TOTAL MISCELLANEOUS REVENUE1,531.081,531.08.00( 1,531.08).00 OTHER FINANCING SOURCES 735-39020-000TRANSFERS IN FROM OTHER FUNDS11,445.0511,445.05.00( 11,445.05).00 TOTAL OTHER FINANCING SOURCES11,445.0511,445.05.00( 11,445.05).00 TOTAL FUND REVENUE12,976.1312,976.13.00( 12,976.13).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 48 CITY OF OAK PARK HEIGHTS EXPENDITURES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 735 - WELL REHABILITATION FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET OTHER EXPENDITURES 735-44444-800CONSTRUCTION21,180.0021,180.00.00( 21,180.00).00 TOTAL OTHER EXPENDITURES21,180.0021,180.00.00( 21,180.00).00 TOTAL FUND EXPENDITURES21,180.0021,180.00.00( 21,180.00).00 NET REVENUE OVER EXPENDITURES( 8,203.87)( 8,203.87).008,203.87.00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 49 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 736 - SEWER REHABILITATION FUND PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET MISCELLANEOUS REVENUE 736-38010-000INTEREST ON INVESTMENTS707.92707.92.00( 707.92).00 736-38015-000INTEREST-MARKET VALUE ADJ( .05)( .05).00.05.00 TOTAL MISCELLANEOUS REVENUE707.87707.87.00( 707.87).00 OTHER FINANCING SOURCES 736-39020-000TRANSFERS IN FROM OTHER FUNDS1,938.271,938.27.00( 1,938.27).00 TOTAL OTHER FINANCING SOURCES1,938.271,938.27.00( 1,938.27).00 TOTAL FUND REVENUE2,646.142,646.14.00( 2,646.14).00 NET REVENUE OVER EXPENDITURES2,646.142,646.14.00( 2,646.14).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 50 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 771 - AAE-SAN SEWER CONNECTIONS PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET SPECIAL ASSESSMENTS 771-32050-000CONNECTION CHARGE15,257.3215,257.32.00( 15,257.32).00 TOTAL SPECIAL ASSESSMENTS15,257.3215,257.32.00( 15,257.32).00 MISCELLANEOUS REVENUES 771-38010-000INTEREST ON INVESTMENTS5,892.835,892.83.00( 5,892.83).00 771-38015-000INTEREST-MARKET VALUE ADJ4.624.62.00( 4.62).00 TOTAL MISCELLANEOUS REVENUES5,897.455,897.45.00( 5,897.45).00 TOTAL FUND REVENUE21,154.7721,154.77.00( 21,154.77).00 NET REVENUE OVER EXPENDITURES21,154.7721,154.77.00( 21,154.77).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 51 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 772 - AAE-WATERWORK CONNECTIONS PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET SPECIAL ASSESSMENTS 772-32050-000CONNECTION CHARGE79,335.3679,335.36.00( 79,335.36).00 TOTAL SPECIAL ASSESSMENTS79,335.3679,335.36.00( 79,335.36).00 MISCELLANEOUS REVENUES 772-38010-000INTEREST ON INVESTMENTS8,149.858,149.85.00( 8,149.85).00 772-38015-000INTEREST-MARKET VALUE ADJ( 178.46)( 178.46).00178.46.00 TOTAL MISCELLANEOUS REVENUES7,971.397,971.39.00( 7,971.39).00 TOTAL FUND REVENUE87,306.7587,306.75.00( 87,306.75).00 NET REVENUE OVER EXPENDITURES87,306.7587,306.75.00( 87,306.75).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 52 CITY OF OAK PARK HEIGHTS DETAIL REVENUES WITH COMPARISON TO BUDGET FOR THE 12 MONTHS ENDING DECEMBER 31, 2017 FUND 773 - AAE-STORM SEWER CONNECTIONS PERIODBUDGETBUDGET% OF ACTUALYTD ACTUALAMOUNTREMAININGBUDGET SPECIAL ASSESSMENTS 773-32050-000CONNECTION CHARGE7,138.567,138.56.00( 7,138.56).00 TOTAL SPECIAL ASSESSMENTS7,138.567,138.56.00( 7,138.56).00 MISCELLANEOUS REVENUES 773-38010-000INTEREST ON INVESTMENTS12,872.0812,872.08.00( 12,872.08).00 773-38015-000INTEREST-MARKET VALUE ADJ92.5592.55.00( 92.55).00 TOTAL MISCELLANEOUS REVENUES12,964.6312,964.63.00( 12,964.63).00 TOTAL FUND REVENUE20,103.1920,103.19.00( 20,103.19).00 NET REVENUE OVER EXPENDITURES20,103.1920,103.19.00( 20,103.19).00 FOR ADMINISTRATION USE ONLY100 % OF THE FISCAL YEAR HAS ELAPSED03/29/2018 10:01AM PAGE: 53