Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
O-09-12
VILLAGE OF DEERFIELD LAKE AND COOK COUNTIES, ILLINOIS ORDINANCE NO. 0 -09 -12 AN ORDINANCE ADOPTING THE BUDGET OF THE VILLAGE OF DEERFIELD FOR THE FISCAL YEAR BEGINNING MAY 1, 2009 AND ENDING APRIL 30, 2010 PASSED AND APPROVED BY THE PRESIDENT AND BOARD OF TRUSTEES OF THE VILLAGE OF DEERFIELD, LAKE AND COOK COUNTIES, ILLINOIS, this 20th day of April , 2009. Published in pamphlet form by authority of the President and Board of Trustees of the Village of Deerfield, Lake and Cook Counties, Illinois, this 20th day of April , 2009. ORDINANCE 0 -09 -12 VILLAGE OF DEERFIELD LAKE AND COOK COUNTIES, ILLINOIS ADOPTING THE BUDGET OF THE VILLAGE OF DEERFIELD FOR THE FISCAL YEAR BEGINNING MAY 1, 2009 AND ENDING APRIL 30, 2010 WHEREAS, the Village of Deerfield has adopted the statutory budget system provided for in the Illinois Municipal Code, 65 ILCS 5/8 -2 -9.1 through 5/8 -2 -9.11; and; WHEREAS, the Village's Budget Officer has compiled a tentative budget for the fiscal year beginning May 1, 2009; and, WHEREAS, the tentative annual budget for the fiscal year beginning May 1, 2009 has been made conveniently available to public inspection for at least ten (10) days prior to the passage of the annual budget; and, WHEREAS, a public hearing has been held on the tentative annual budget pursuant to public notice duly given by publication in a newspaper having general circulation in the Village of Deerfield at least one week prior to the time of the public hearing; and, WHEREAS, the corporate authorities of the Village of Deerfield find that it is in the best interests of the Village to adopt the budget attached hereto as Exhibit A as the annual budget of the Village of Deerfield for the fiscal year beginning May 1, 2009 and ending April 30, 2010. NOW, THEREFORE, BE IT ORDAINED BY THE PRESIDENT AND BOARD OF TRUSTEES OF THE VILLAGE OF DEERFIELD, LAKE AND COOK COUNTIES, ILLINOIS, in the exercise of its home rule powers, as follows: SECTION 1: The corporate authorities of the Village of Deerfield do hereby approve and adopt the budget attached to this Ordinance as Exhibit A as the annual budget for the Village of Deerfield for the fiscal year beginning May 1, 2009, and ending April 30, 2010. SECTION 2: This Ordinance, and each of its terms, shall be the effective legislative act of a home rule municipality without regard to whether such Ordinance should: (a) contain terms contrary to the provisions of current or subsequent non - preemptive state law; or, (b) legislate in a manner or regarding a matter not delegated to municipalities by state law. It is the intent of the corporate authorities of the Village of Deerfield that to the extent that the terms of this Ordinance should be inconsistent with any non - preemptive state law, this Ordinance shall supersede state law in that regard within its jurisdiction. SECTION 3: That this Ordinance shall be in full force and effect from and after its passage, approval and publication in pamphlet form as provided by law. PASSED this 20th day of April , 2009. AYES: Benton, Jester, Rosenthal, Seiden, Struthers, Wasserman (6) NAYS: None (0) ABSENT: None (0) ABSTAIN: None (0) APPROVED this 20th day c ATTEST: Village Cler 03/30/2009 09:53 VILLAGE OF DEERFIELD PG 1 rfialkow REVENUE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL ------------------------------------------------------------------------------------------------------------------------------------ FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 100001 GENERAL FUND REVENUE -------------------------------------------- 41 TAXES -------------------------------------------- 100001 4110 PROP TAX 1,915,603.38 2,084,250.00 2,084,250.00 1,936,801.42 1,950,000.00 2,246,250.00 7.8% 5% INCREASE TO OFFSET INCREASED OPERATIONAL COSTS. ALSO, INCREASE OF 162,000 TO CAPTURE TIF 2 EAV. 100001 4112 PRTX ROAD 26,198.44 .00 .00 20,805.25 .00 .00 .0% 100001 4114 PRTX PR YR .00 10,000.00 10,000.00 .00 10,000.00 10,000.00 .0% 100001 4120 REPLACEMT 105,042.98 75,000.00 75,000.00 75,923.23 75,000.00 75,000.00 .0% 100001 4140 ST SALES 4,552,097.71 4,500,000.00 4,500,000.00 4,059,535.44 4,500,000.00 4,500,000.00 .0% THIS IS THE GROSS AMOUNT AND INCLUDES AMOUNTS TO BE PAID TO WALGREEN FOR INCENTIVES. FLAT DUE TO SLOWER LOCAL RETAIL ECONOMY - OFFSET BY INCREASED WALGREENS ACTIVITY 100001 4141 HR SALES 956,633.67 1,400,000.00 1,400,000.00 850,634.92 1,400,000.00 2,700,000.00 92.9% 75% OF TOTAL HOME RULE GOES TO GENERAL FUND AND 25% TO INFRASTRUCTURE FUND THIS IS GROSS AMOUNT WHICH INCLUDES INCENTIVE TO BE PAID TO WALGREEN'S PER AGREEMENT. FIRST FULL YEAR OF INCREASED HOME RULE TAX (TO 1 %) EFFECTIVE 01/01/09. 100001 4142 LOC USE TX 260,519.89 245,000.00 245,000.00 248,755.99 259,440.00 259,440.00 5.9% ESTIMATES FOR CURRENT YEAR AND PROJECTION FOR NEXT YEAR BASED ON ILL MUNICIPAL LEAGUE. 100001 4150 ST INC TX 1,695,990.68 1,650,000.00 1,650,000.00 1,599,798.80 1,709,360.00 1,665,200.00 .9% ESTIMATE FOR CURRENT YEAR AND PROJECTION FOR NEXT YEAR BASED ON ILL MUNICIPAL LEAGUE. REVISED LOWER ON 3/12 DUE TO NEW IML ESTIMATES. 100001 4160 HOTEL TAX 2,108,579.79 2,000,000.00 2,000,000.00 1,692,141.65 1,950,000.00 1,850,000.00 -7.5% PROJECTING NO INCREASE IN BUDGETED AMOUNT DUE TO HISTORIC TREND AND CONTINUED STRENGTH IN LOCAL BUSINESS DEMAND FOR ROOMS WHICH SHOULD OFFSET OVERALL SLOWER ECONOMY. 100001 4170 TELECOM TX 354,983.69 310,000.00 310,000.00 328,393.59 340,000.00 335,000.00 8.1% 1% TAX ON PHONE AND CELLULAR SERVICE BILLED IN DEERFIELD. TOTAL TAXES 11,975,650.23 12,274,250.00 12,274,250.00 10,812,790.29 12,193,800.00 13,640,890.00 11.1% 42 LICENSES & PERMITS -------------------------------------------- 100001 4211 LIQR LIC 67,625.00 71,000.00 71,000.00 60,200.00 67,000.00 68,000.00 -4.2% 03/30/2009 09:53 VILLAGE OF DEERFIELD rfialkow REVENUE BUDGET FISCAL YEAR 2009/10 PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION IPG 2 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 100001 4213 FOOD LIC 5,441.00 8,000.00 8,000.00 4,883.00 8,000.00 8,000.00 .0% 100001 4214 BUSN LIC 5,141.00 28,000.00 28,000.00 5,495.00 28,000.00 28,000.00 .0% 100001 4220 BLDG PERM 651,351.49 600,000.00 600,000.00 764,805.15. 900,000.00 900,000.00 50.0% PROJECTED STRENGTH DUE TO COMMERCIAL PROJECTS. 100001 4222 CONTR LIC 25,652.50 8,000.00 8,000.00 7,200.001 8,000.00 8,000.00 .0% 100001 4232 LIC & PERM 64,775.77 50,000.00 50,000.00 48,412.00 50,000.00 50,000.00 .0% 100001 4233 ALRM PERM 2,500.00 3,000.00 3,000.00 2,025.00 3,000.00 3,000.00 .0% 100001 4240 VEH LIC 338,789.00 345,000.00 345,000.00 337,456.00 340,000.00 344,000.00 -.3% TOTAL LICENSES & PERMITS 1,161,275.76 1,113,000.00 1,113,000.00 1,230,476.15 1,404,000.00 1,409,000.00 26.6% 43 INTERGOVERNMENTAL & -------------------------------------------- 100001 4330 ST GRANT 1,210.00 6,000.00 6,000.00 1,210.00 6,000.00 6,000.00 .096 100001 4350 FED GRANT 50,662.54 .00 .00 50,662.54 51,000.00 .00 .096 100001 4463 CIS HWY MT 40,876.25 33,000.00 33,000.00 41,848.50 33,000.00 33,000.00 .096 100001 4464 CIS TSM 4,236.00 .00 .00 4,236.00 .00 .00 .096 TOTAL INTERGOVERNMENTAL & 96,984.79 39,000.00 39,000.00 97,957.04 90,000.00 39,000.00 .096 44 CHARGES FOR SERVICES -------------------------------------------- 100001 4415 CIS WLGRN 15,748.00 12,500.00 12,500.00 13,026.51 12,500.00 12,500.00 .0% 100001 4417 CIS POL OT 171,915.90 250,000.00 250,000.00 141,911.59 150,000.00 150,000.00 -40.0% PRIMARILY RAVINIA DETAIL REVENUE. 100001 4419 C/S OTHER 5,700.00 .00 .00 4,567.00 .00 .00 .0% 100001 4420 CIS MAT SL .00 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0% 100001 4425 CIS BNK DI 84,000.00 79,000.00 79,000.00 80,674.00 84,000.00 84,000.00 6.3% 100001 4430 CIS ENGIN .00 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0% 100001 4462 CIS TREE 71,164.25 4,000.00 4,000.00 50,710.75 60,000.00 8,000.00 100.0% TOTAL CHARGES FOR SERVICES 348,528.15 349,500.00 349,500.00 290,889.85 310,500.00 258,500.00 -26.0% 45 FEES & FINES -------------------------------------------- 100001 4510 ORD V CTY 190,742.99 145,000.00 145,000.00 170,455.84 170,000.00 165,000.00 13.8% 100001 4511 ORD V VIL 33,508.67 45,000.00 45,000.00 28,938.60 45,000.00 45,000.00 .0% 100001 4520 FLSE ALRM 28,450.06 35,000.00 35,000.00 27,491.70 30,000.00 30,000.00 -14.3% 100001 4521 ALRM MNTR 26,811.98 20,000.00 20,000.00 28,537.63 25,000.00 25,000.00 25.0% 100001 4530 RSTIT FINE 3,791.00 .00 .00 1,957.00 .00 .00 .0% 100001 4540 OVR SZ VEH 4,900.00 3,500.00 3,500.00 935.00 3,500.00 3,500.00 .0% 100001 4560 FF & PEN 1,740.00 .00 .00 1,385.00 .00 .00 .0% TOTAL FEES & FINES 289,944.70 248,500.00 248,500.00 259,700.77 273,500.00 268,500.00 8.0% 46 INVESTMENT INCOME -------------------------------------------- 100001 4610 INTER EARN 638,313.36 520,000.00 520,000.00 294,774.55 400,000.00 350,000.00 -32.7% REDUCTION DUE TO SHARPLY LOWER INTEREST RATES. 03/30/2009 09:53 OF DEERFIELD 3 rfialkow (VILLAGE REVENUE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 100001 4620 GAIN SALE 21,303.18 .00 .00 .00 .00 .00 .0% 100001 4622 UNRLZD G/L 178,600.88 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 838,217.42 520,000.00 520,000.00 294,774.55 400,000.00 350,000.00 -32.7% 48 MISCELLANEOUS REVENU -------------------------------------------- 100001 4810 MISC REV 88,531.92 35,000.00 35,000.00 42,719.68 35,000.00 40,000.00 14.3% 100001 4811 RENT INC 40,610.00 25,000.00 25,000.00 73,898.25 40,000.00 50,000.00 100.0% INCREASE DUE TO CELL TOWER REVENUE. 100001 4821 PLZA ENT .00 5,000.00 5,000.00 .00 5,000.00 5,000.00 .0% 100001 4822 FAM DY DON 57,093.82 60,000.00 60,000.00 47,409.00 55,000.00 55,000.00 -8.3% INCLUDES DONATIONS FOR MUDFEST 100001 4843 WC REIMB 50,766.14 .00 .00 131,034.53 100,000.00 .00 .0% 100001 4844 INS REIMB 66,222.02 .00 .00 8,340.86 8,500.00 .00 .0% 100001 4851 SALE EQPM 11,052.47 5,000.00 5,000.00 8,570.08 9,000.00 7,500.00 50.0% 100001 4880 CABLE TV 278,122.29 245,000.00 245,000.00 222,664.17 255,000.00 260,000.00 6.1% TOTAL MISCELLANEOUS REVENU 592,398.66 375,000.00 375,000.00 534,636.57 507,500.00 417,500.00 11.3°% 49 TRANSFERS IN (IFT) -------------------------------------------- 100001 4910 TRSNFR IN 130,000.00 181,000.00 181,000.00 .00 181,000.00 181,000.00 .0% COMMUTER PARKING TRANSFER IN - 160,000 REFUSE TRANSFER IN - 21,000 TOTAL TRANSFERS IN (IFT) 130,000.00 181,000.00 181,000.00 .00 181,000.00 181,000.00 .0% TOTAL GENERAL FUND REVENUE 15,432,999.71 15,100,250.00 15,100,250.00 13,521,225.22 15,360,300.00 16,564,390.00 9.7°% TOTAL GENERAL FUND 15,432,999.71 15,100,250.00 15,100,250.00 13,521,225.22 15,360,300.00 16,564,390.00 9.7% 03/30/2009 09:53 OF DEERFIELD 4 rfialkow (VILLAGE REVENUE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT MOTOR FUEL TAX FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 140001 MOTOR FUEL TAX REVENUE -------------------------------------------- 43 INTERGOVERNMENTAL & -------------------------------------- 140001 4310 MFT REV - - - - -- 523,212.72 525,000.00 525,000.00 454,519.66 485,000.00 494,000.00 -5-.9% 5.9% o ESTIMATE AND PROJECTION BASED ON ILL MUNICIPAL LEAGUE. TOTAL INTERGOVERNMENTAL & 523,212.72 525,000.00 525,000.00 454,519.66 485,000.00 494,000.00 -5.9% 46 INVESTMENT INCOME -------------------------------------------- 140001 4610 INTER EARN 23,463.65 25,000.00 25,000.00 7,487.76 10,000.00 10,000.00 -60.0% DECREASE DUE TO REDUCED FUND BALANCE 140001 4620 GAIN SALE 782.60 .00 .00 .00 .00 .00 .0% 140001 4622 UNRLZD G/L 6,561.13 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 30,807.38 25,000.00 25,000.00 7,487.76 10,000.00 10,000.00 -60.0% 48 MISCELLANEOUS REVENU -------------------------------------------- 140001 4810 MISC REV .00 .00 .00 72,869.00 .00 .00 .0% TOTAL MISCELLANEOUS REVENU .00 .00 .00 72,869.00 .00 .00 .0% TOTAL MOTOR FUEL TAX REVENUE 554,020.10 550,000.00 550,000.00 534,876.42 495,000.00 504,000.00 -8.4% TOTAL MOTOR FUEL TAX FUND 554,020.10 550,000.00 550,000.00 534,876.42 495,000.00 504,000.00 -8.4% 03/30/2009 09:53 OF DEERFIELD PG 5 rfialkow (VILLAGE REVENUE BUDGET FISCAL YEAR 2009/10' bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT E 911 FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 170001 E911 FUND REVENUES -------------------------------------------- 44 CHARGES FOR SERVICES -------------------------------------------- 170001 4410 E911 SRCH 134,923.73 140,000.00 140,000.00 106,359.22 136,000.00 136,000.00 -2.916 170001 4411 CELL 911 233,070.08 160,000.00 160,000.00 268,403.86 225,000.00 230,000.00 43.8% TOTAL CHARGES FOR SERVICES 367,993.81 300,000.00 300,000.00 374,763.08 361,000.00 366,000.00 22.0% 46 INVESTMENT INCOME -------------------------------------------- 170001 4610 INTER EARN 28,196.98 14,000.00 14,000.00 17,071.09 15,000.00 14,000.00 .0% 170001 4620 GAIN SALE 902.05 .00 .00 .00 .00 .00 .0% 170001 4622 UNRLZD G/L 7,562.57 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 36,661.60 14,000.00 14,000.00 17,071.09 15,000.00 14,000.00 .0% 48 MISCELLANEOUS REVENU -------------------------------------------- 170001 4810 MISC REV 68,074.00 .00 .00 .00 .00 .00 .0% TOTAL MISCELLANEOUS REVENU 68,074.00 .00 .00 .00 .00 .00 .0% TOTAL E911 FUND REVENUES 472,729.41 314,000.00 314,000.00 391,834.17 376,000.00 380,000.00 21.0% TOTAL E 911 FUND 472,729.41 314,000.00 314,000.00 391,834.17 376,000.00 380,000.00 21.0% 03/30/2009 09:53 OF DEERFIELD IPG 6 rfialkow (VILLAGE REVENUE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT VEHICLE & EQUIPMENT REPLACE. ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 210001 VERF REVENUES -------------------------------------------- 44 CHARGES FOR.SERVICES -------------------------------------------- 210001 4480 CIS FUNDS 516,344.00 584,203.00 584,203.00 535,519.40 584 - ,203. -00 584,639.00 1% TOTAL CHARGES FOR SERVICES 516,344.00 584,203.00 584,203.00 535,519.40 584,203.00 584,639.00 .1% 46 INVESTMENT INCOME -------------------------------------------- 210001 4610 INTER EARN 136,076.81 90,000.00 90,000.00 71,971.47 90,000.00 70,000.00 -22.2% 210001 4620 GAIN SALE 4,423.75 .00 .00 .00 .00 .00 .0% 210001 4622 UNRLZD G/L 37,087.65 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 177,588.21 90,000.00 90,000.00 71,971.47 90,000.00 70,000.00 -22.2% 48 MISCELLANEOUS REVENU -------------------------------------------- 210001 4852 G/L FADISP 87,996.00 .00 .00 .00 .00 .00 .0% TOTAL MISCELLANEOUS REVENU 87,996.00 .00 .00 .00 .00 .00 .0% TOTAL VERF REVENUES 781,928.21 674,203.00 674,203.00 607,490.87 674,203.00 654,639.00 -2.9% TOTAL VEHICLE & EQUIPMENT RE 781,928.21 674,203.00 674,203.00 607,490.87 674,203.00 654,639.00 -2.90 03/30/2009 09:53 OF DEERFIELD PG 7 rfialkow (VILLAGE REVENUE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT INFRASTRUCTURE REPLACEMENT ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 220001 INFRA REPLACE FUND REVENUE -------------------------------------------- 41 TAXES -------------------------------------------- 220001 4110 PROP TAX 43,498.59 45,000.00 45,000.00 44,049.70 45,000.00 45,000.00 .0% 220001 4115 TIF SRPLUS .00 .00 .00 .00 .00 1,350,000.00 .0% DEERFIELD WILL GET BACK $1.2 MILLION FROM SALES TAX CONTRIBUTION. ADDITIONAL $150,000 FROM PROPERTY TAX SURPLUS DISTRIBUTION. 220001 4141 HR SALES 956,633.69 850,000.00 850,000.00 850,635.02 850,000.00 850,000.00 .0% THIS FUND RECEIVES 25% OF THE 1.0% HOME RULE SALES TAX. TOTAL TAXES 1,000,132.28 895,000.00 895,000.00 894,684.72 895,000.00 2,245,000.00 150.8% 43 INTERGOVERNMENTAL & -------------------------------------------- 220001 4330 ST GRANT 21,986.71 1,484,900.00 1,484,900.00 .00 1,008,000.00 2,108,600.00 42.0% TOTAL GRANTS FOR ENGINEERING - $213,500 TOTAL GRANTS FOR CONSTRUCTION - $1,271,400 220001 4350 FED GRANT 2,957.96 .00 .00 .00 .00 .00 .0% 220001 4370 CTY GRANT 253.53 .00 .00 .00 .00 .00 .0% TOTAL INTERGOVERNMENTAL & 25,198.20 1,484,900.00 1,484,900.00 .00 1,008,000.00 2,108,600.00 42.0% 44 CHARGES FOR SERVICES -------------------------------------------- 220001 4460 CIS SIDEW .00 3,500.00 3,500.00 .00 3,500.00 3,500.00 .0% TOTAL CHARGES FOR SERVICES .00 3,500.00 3,500.00 .00 3,500.00 3,500.00 .0% 46 INVESTMENT INCOME -------------------------------------------- 220001 4610 INTER EARN 67,521.18 12,000.00 12,000.00 34,259.24 30,000.00 12,000.00 .0% 220001 4620 GAIN SALE 2,018.28 .00 .00 .00 .00 .00 .0% 220001 4622 UNRLZD G/L 16,920.81 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 86,460.27 12,000.00 12,000.00 34,259.24 30,000.00 12,000.00 .0% 48 MISCELLANEOUS REVENU -------------------------------------------- 220001 4811 RENT INC 5,000.00 45,000.00 45,000.00 .00 .00 45,000.00 .0% FROM BILLBOARDS ON 29A SITE 220001 4830 IMPACT FEE .00 300,000.00 300,000.00 .00 .00 300,000.00 .0% FROM BILLBOARDS ON 29A SITE ONE TIME PAYMENT 03/30/2009 09:53 OF DEERFIELD 8 rfialkow (VILLAGE REVENUE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT INFRASTRUCTURE REPLACEMENT ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE TOTAL MISCELLANEOUS REVENU 5,000.00 345,000.00 345,000.00 .00 .00 345,000.00 .0% 49 TRANSFERS IN (IFT) -------------------------------------------- 220001 4910 TRSNFR IN 2,000,000.00 .00 .00 3,312,407.03 4,500,000.00 2,600,000.00 .0% REMAINING PROCEEDS FROM 2008 DEBT ISSUE - 500,000 TRANSFER IN FROM GENERAL FUND - 2,100,000 220001 4990 ISSUE DEBT .00 5,000,000.00 5,000,000.00 .00 .00 .00 - 100.0% TOTAL TRANSFERS IN (IFT) 2,000,000.00 5,000,000.00 5,000,000.00 3,312,407.03 4,500,000.00 2,600,000.00 -48.0% TOTAL INFRA REPLACE FUND REV 3,116,790.75 7,740,400.00 7,740,400.00 4,241,350.99 6,436,500.00 7,314,100.00 -5.5% TOTAL INFRASTRUCTURE REPLACE 3,116,790.75 7,740,400.00 7,740,400.00 4,241,350.99 6,436,500.00 7,314,100.00 -5.5% 03/30/2009 09:53 OF DEERFIELD PG 9 rfialkow (VILLAGE REVENUE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT BOND PROCEEDS FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 230001 BOND PROCEEDS -------------------------------------------- 46 INVESTMENT INCOME -------------------------------------------- 230001 4610 INVST EARN .00 .00 .00 31,243.28 .00 .00 .0% 230001 4630 PREM /DISC .00 .00 .00 - 30,866.90 .00 .00 .0% TOTAL INVESTMENT INCOME .00 .00 .00 376.38 .00 .00 .0% 49 TRANSFERS IN (IFT) -------------------------------------------- 230001 4990 ISSUE DEBT .00 .00 .00 5,000,000.00 .00 .00 .0% TOTAL TRANSFERS IN (IFT) .00 .00 .00 5,000,000.00 .00 .00 .0% TOTAL BOND PROCEEDS .00 .00 .00 5,000,376.38 .00 .00 .0% TOTAL BOND PROCEEDS FUND .00 .00 .00 5,000,376.38 .00 .00 .0% 03/30/2009 09:53 OF DEERFIELD 10 rfialkow (VILLAGE REVENUE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT VILLAGE CENTER TIF ------------------------------------------------------------------------------------------------------------------------------------ (TIF 2) ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 260001 TIF 2 REVENUES -------------------------------------------- 41 TAXES -------------------------------------------- 260001 4110 PROP TAX 4,527,304.59 4,500,000.00 4,500,000.00 4,948,264.30 4,950,000.00 5,000,000.00 11.1% TOTAL TAXES 4,527,304.59 4,500,000.00 4,500,000.00 4,948,264.30 4,950,000.00 5,000,000.00 11.1% 46 INVESTMENT INCOME -------------------------------------------- 260001 4610 INTER EARN 167,938.11 110,000.00 110,000.00 76,703.18 90,000.00 45,000.00 -59.1% 260001 4620 GAIN SALE 6,133.11 .00 .00 .00 .00 .00 .0% 260001 4622 UNRLZD G/L 51,418.54 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 225,489.76 110,000.00 110,000.00 76,703.18 90,000.00 45,000.00 -59.1% TOTAL TIF 2 REVENUES 4,752,794.35 4,610,000.00 4,610,000.00 5,024,967.48 5,040,000.00 5,045,000.00 9.4% TOTAL VILLAGE CENTER TIF (TI 4,752,794.35 4,610,000.00 4,610,000.00 5,024,967.48 5,040,000.00 5,045,000.00 9.4% 03/30/2009 09:53 VILLAGE OF DEERFIELD PG 11 rfialkow REVENUE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT PROJECT 29 FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------ - - - - -- 290001 PROJECT 29 REVENUES ---------------------------- 46 INVESTMENT INCOME 290001 4610 INTER EARN 7,264.79 290001 4620 GAIN SALE 115.33 290001 4622 UNRLZD G/L 966.90 TOTAL INVESTMENT INCOME 8,347.02 TOTAL PROJECT 29 REVENUES 8,347.02 TOTAL PROJECT 29 FUND 8,347.02 .00 .00 3,049.63 .00 .00 .0% .00 .00 .00 .00 .00 .0% .00 .00 .00 .00 .00 .0% .00 .00 3,049.63 .00 .00 .0% .00 .00 3,049.63 .00 .00 .0% .00 .00 3,049.63 .00 .00 .0% 03/30/2009 09:53 VILLAGE OF DEERFIELD PG 12 rfialkow (REVENUE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION — FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT DEBT SERVICE FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 350001 DEBT SERVICE REVENUE ----7--------------------------------------- 41 TAXES -------------------------------------------- 350001 4110 PROP TAX .00 400,000.00 400,000.00 .00 .00 367,462.50 -8.1. 350001 4120 REPLACEMT .00 20,000.00 20,000.00 .00 20,000.00 20,000.00 .0. TOTAL TAXES .00 420,000.00 420,000.00 .00 20,000.00 387,462.50 -7.70 46 INVESTMENT INCOME -------------------------------------------- 350001 4610 INTER EARN 20,673.25 25,000.00 25,000.00 10,326.88 12,000.00 12,000.00 -52.0. 350001 4620 GAIN SALE 733.17 .00 .00 .00 .00 .00 .0. 350001 4622 UNRLZD G/L 6,146.74 .00 .00 .00 .00 .00 .0 °s TOTAL INVESTMENT INCOME 27,553.16 25,000.00 25,000.00 10,326.88 12,000.00 12,000.00 -52.0. 49 TRANSFERS IN (IFT) -------------------------------------------- 350001 4910 TRSNFR IN 2,216,000.00 2,130,000.00 4,130,000.00 4,086,500.00 4,130,000.00 .00 - 100.0006 TRANSFER IN FROM TIF 2 OF ALL DEBT SERVICE DUE ON 1998 ISSUE. TOTAL TRANSFERS IN (IFT) 2,216,000.00 2,130,000.00 4,130,000.00 4,086,500.00 4,130,000.00 .00 - 100.00 TOTAL DEBT SERVICE REVENUE 2,243,553.16 2,575,000.00 4,575,000.00 4,096,826.88 4,162,000.00 399,462.50 -91.3. TOTAL DEBT SERVICE FUND 2,243,553.16 2,575,000.00 4,575,000.00 4,096,826.88 4,162,000.00 399,462.50 -91.3. 03/30/2009 09:53 VILLAGE OF DEERFIELD 13 rfialkow REVENUE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT WATER FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 500001 WATER FUND REVENUES -------------------------------------------- 42 LICENSES & PERMITS -------------------------------------------- 500001 4216 WTR PERM 27,560.77 30,000.00 30,000.00 37,896.71 45,000.00 30,000.00 .0% TOTAL LICENSES & PERMITS 27,560.77 30,000.00 30,000.00 37,896.71 45,000.00 30,000.00 .0% 44 CHARGES FOR SERVICES -------------------------------------------- 500001 4451 CIS UB 4,361,773.13 4,262,000.00 4,262,000.00 3,540,124.90 4,262,000.00 4,368,550.00 2.5% REPRESENTS PROPOSED 2.5% INCREASE IN RATE DUE TO HIGHLAND PARK PROPOSED WHOLESALE RATE INCREASE 500001 4452 CIS UB MSC 3,993.93 .00 .00 767.12 .00 .00 .0% 500001 4453 CIS UB PEN 35,539.74 37,000.00 37,000.00 36,584.55 37,000.00 37,000.00 .0% TOTAL CHARGES FOR SERVICES 4,401,306.80 4,299,000.00 4,299,000.00 3,577,476.57 4,299,000.00 4,405,550.00 2.5% 46 INVESTMENT INCOME -------------------------------------------- 500001 4610 INTER EARN 28,044.68 41,000.00 41,000.00 15,223.19 25,000.00 30,000.00 -26.8% DECREASE DUE TO LOWER EXPECTED CASH BALANCES AND INTEREST RATES. 500001 4620 GAIN SALE 1,066.81 .00 .00 .00 .00 .00 .0% 500001 4622 UNRLZD G/L 8,943.86 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 38,055.35 41,000.00 41,000.00 15,223.19 25,000.00 30,000.00 -26.8% 48 MISCELLANEOUS REVENU -------------------------------------------- 500001 4810 MISC REV 22,954.14 25,000.00 25,000.00 2,537.36 25,000.00 25,000.00 .0% 500001 4811 RENT INC 29,000.00 33,000.00 33,000.00 24,960.00 33,000.00 33,000.00 .0% CELL ANTENNA FEE FOR USE OF WATER TOWER 500001 4834 AST CNTR 299,910.02 .00 .00 .00 .00 .00 .0% 500001 4844 INS REIMB 12,564.00 .00 .00 .00 .00 .00 .0% TOTAL MISCELLANEOUS REVENU 364,428.16 58,000.00 58,000.00 27,497.36 58,000.00 58,000.00 .0% 49 TRANSFERS IN (IFT) -------------------------------------------- 500001 4910 TRSNFR IN 2,000,000.00 .00 .00 .00 .00 .00 .0% TOTAL TRANSFERS IN (IFT) 2,000,000.00 .00 .00 .00 .00 .00 .0% TOTAL WATER FUND REVENUES 6,831,351.08 4,428,000.00 4,428,000.00 3,658,093.83 4,427,000.00 4,523,550.00 2.2% TOTAL WATER FUND 6,831,351.08 4,428,000.00 4,428,000.00 3,658,093.83 4,427,000.00 4,523,550.00 2.2% 03/30/2009 09:53 OF DEERFIELD IPG 14 rfialkow (VILLAGE REVENUE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT SEWER FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 540001 SEWER FUND REVENUES -------------------------------------------- 42 LICENSES & PERMITS -------------------------------------------- 540001 4215 SWR PERM 19,675.00 22,000.00 22,000.00 7,030.00 22,000.00 22,000.00 .016 TOTAL LICENSES & PERMITS 19,675.00 22,000.00 22,000.00 7,030.00 22,000.00 22,000.00 .0% 43 INTERGOVERNMENTAL & -------------------------------------------- 540001 4330 ST GRANT .00 160,000.00 160,000.00 .00 160,000.00 .00 - 100.016 TRANSFER OF PROJ. 29 GRANTS FOR EAST SIDE LIFT STN. IF NOT RECEIVED IN FY 2008, RE- BUDGET TOTAL INTERGOVERNMENTAL & .00 160,000.00 160,000.00 .00 160,000.00 .00 - 100.00 44 CHARGES FOR SERVICES -------------------------------------------- 540001 4451 CIS UB 2,396,295.10 2,509,000.00 2,509,000.00 2,198,410.82 2,509,000.00 2,571,725.00 2.5116 SHOWS A 2.5% INCREASE IN SEWER RATE 540001 4453 CIS UB PEN 29,953.99 34,000.00 34,000.00 24,012.19 34,000.00 34,000.00 540001 4495 CIS OTHER .00 15,000.00 15,000.00 .00 15,000.00 15,000.00 .0% TOTAL CHARGES FOR SERVICES 2,426,249.09 2,558,000.00 2,558,000.00 2,222,423.01 2,558,000.00 2,620,725.00 2.5% 46 INVESTMENT INCOME -------------------------------------------- 540001 4610 INTER EARN 66,356.26 15,000.00 15,000.00 11,423.84 13,000.00 13,500.00 -10.0% 540001 4620 GAIN SALE 1,886.48 .00 .00 .00 .00 .00 .0% 540001 4622 UNRLZD GIL 15,815.78 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 84,058.52 15,000.00 15,000.00 11,423.84 13,000.00 13,500.00 -10.0% 48 MISCELLANEOUS REVENU -------------------------------------------- 540001 4810 MISC REV 1,704.70 5,000.00 5,000.00 13,724.22 14,000.00 5,000.00 .0% 540001 4834 AST CNTR 141,694.95 .00 .00 .00 .00 .00 .016 540001 . 4844 INS REIMB 18,037.00 .00 .00 .00 .00 .00 .0% TOTAL MISCELLANEOUS REVENU 161,436.65 5,000.00 5,000.00 13,724.22 14,000.00 5,000.00 .0% TOTAL SEWER FUND REVENUES 2,691,419.26 2,760,000.00 2,760,000.00 2,254,601.07 2,767,000.00 2,661,225.00 -3.6% TOTAL SEWER FUND 2,691,419.26 2,760,000.00 2,760,000.00 2,254,601.07 2,767,000.00 2,661,225.00 -3.616 03/30/2009 09:53 VILLAGE OF DEERFIELD 15 rfialkow REVENUE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT REFUSE FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 580001 REFUSE FUND REVENUES -------------------------------------------- 41 TAXES -------------------------------------------- 580001 4110 PROP TAX 780,784.74 841,360.00 841,360.00 789,570.02 820,000.00 841,360.00 .0% 4% INCREASE TO COVER INCREASED CONTRACT COSTS WITH NO CORRESPONDING INCREASE IN DIRECT USER FEES. TOTAL TAXES 780,784.74 841,360.00 841,360.00 789,570.02 820,000.00 841,360.00 .0% 44 CHARGES FOR SERVICES -------------------------------------------- 580001 4451 CIS UB 597,866.52 605,000.00 605,000.00 544,043.68 598,000.00 598,000.00 -1.2% NO CHANGE IN DIRECT CHARGE TO USERS CONTEMPLATED 580001 4453 CIS UB PEN 7,373.40 5,000.00 5,000.00 6,468.75 6,500.00 5,000.00 .0% 580001 4454 CIS REF CN 19,109.00 18,500.00 18,500.00 17,397.75 18,500.00 18,500.00 .0% TOTAL CHARGES FOR SERVICES 624,348.92 628,500.00 628,500.00 567,910.18 623,000.00 621,500.00 -1.1% 46 INVESTMENT INCOME -------------------------------------------- 580001 4610 INTER EARN 24,609.99 14,000.00 14,000.00 9,572.52 10,500.00 11,000.00 -21.4% 580001 4620 GAIN SALE 840.26 .00 .00 .00 .00 .00 .0% 580001 4622 UNRLZD G/L 7,044.58 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 32,494.83 14,000.00 14,000.00 9,572.52 10,500.00 11,000.00 -21.4% 48 MISCELLANEOUS REVENU -------------------------------------------- 580001 4810 MISC REV 6,353.40 9,000.00 9,000.00 5,109.00 6,000.00 6,000.00 -33.3% TOTAL MISCELLANEOUS REVENU 6,353.40 9,000.00 9,000.00 5,109.00 6,000.00 6,000.00 -33.3% TOTAL REFUSE FUND REVENUES 1,443,981.89, 1,492,860.00 1,492,860.00 1,372,161.72 1,459,500.00 1,479,860.00 -.9% TOTAL REFUSE FUND 1,443,981.89 1,492,860.00 1,492,860.00 1,372,161.72 1,459,500.00 1,479,860.00 -.9% 03/30/2009 09:53 VILLAGE OF DEERFIELD PG 16 rfialkow (REVENUE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT COMMUTER PARKING FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 600001 COMMUTER PARKING FUND REVENUES -------------------------------------------- 44 CHARGES FOR SERVICES -------------------------------------------- 600001 4440 CIS CPKMTR 67,914.25 70,000.00 70,000.00 74,337.39 85,000.00 85,000.00 21.4% 600001 4441 CIS VPKMTR 27,007.04 15,000.00 15,000.00 14,667.62 15,000.00 15,000.00 .0% 600001 4442 CIS VPKPER 89,118.50 88,000.00 88,000.00 90,304.61 97,000.00 90,000.00 2.3% 600001 4443 CIS CPKPER 28,545.17 30,000.00 30,000.00 30,243.00 28,000.00 28,000.00 -6.7% TOTAL CHARGES FOR SERVICES 212,584.96 203,000.00 203,000.00 209,552.62 225,000.00 218,000.00 7.4% 46 INVESTMENT INCOME -------------------------------------------- 600001 4610 INTER EARN 29,394.18 15,000.00 15,000.00 15,097.40 15,000.00 15,000.00 .0% 600001 4620 GAIN SALE 955.60 .00 .00 .00 .00 .00 .0% 600001 4622 UNRLZD G/L 8,011.49 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 38,361.27 15,000.00 15,000.00 15,097.40 15,000.00 15,000.00 .01 48 MISCELLANEOUS REVENU -------------------------------------------- 600001 4844 INS REIMB 1,000.00 .00 .00 .00 .00 .00 .0% TOTAL MISCELLANEOUS REVENU 1,000.00 .00 .00 .00 .00 .00 .0% TOTAL COMMUTER PARKING FUND 251,946.23 218,000.00 218,000.00 224,650.02 240,000.00 233,000.00 6.9% TOTAL COMMUTER PARKING FUND 251,946.23 218,000.00 218,000.00 224,650.02 240,000.00 233,000.00 6.9% 03/30/2009 09:53 VILLAGE OF DEERFIELD PG 17 rfialkow REVENUE BUDGET FISCAL YEAR 2009/10 Ibgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GARAGE FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 700001 GARAGE FUND REVENUE -------------------------------------------- 44 CHARGES FOR SERVICES -------------------------------------------- 700001 4480 CIS FUNDS 370,591.24 315,000.00 315,000.00 334,193.11 320,000.00 330,000.00 4.8% TOTAL CHARGES FOR SERVICES 370,591.24 315,000.00 315,000.00 334,193.11 320,000.00 330,000.00 4.8% 46 INVESTMENT INCOME -------------------------------------------- 700001 4610 INTER EARN 983.29 500.00 500.00 969.11 800.00 500.00 .0% 700001 4620 GAIN SALE 28.83 .00 .00 .00 .00 .00 .0% 700001 4622 UNRLZD G/L 241.73 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 1,253.85 500.00 500.00 969.11 800.00 500.00 .0% 48 MISCELLANEOUS REVENU -------------------------------------------- 700001 4810 MISC REV 9,540.19 1,000.00 1,000.00 11,866.53 10,000.00 7,000.00 600.0% TOTAL MISCELLANEOUS REVENU 9,540.19 1,000.00 1,000.00 11,866.53 10,000.00 7,000.00 600.0% TOTAL GARAGE FUND REVENUE 381,385.28 316,500.00 316,500.00 347,028.75 330,800.00 337,500.00 6.6% TOTAL GARAGE FUND 381,385.28 316,500.00 316,500.00 347,028.75 330,800.00 337,500.00 6.6% 03/30/2009 09:53 VILLAGE OF DEERFIELD 18 rfialkow REVENUE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT POLICE PENSION FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 800001 POLICE PENSION FUND REVENUE -------------------------------------------- 46 INVESTMENT INCOME -------------------------------------------- 800001 4610 INTER EARN 594,853.65 800,000.00 800,000.00 488,658.70 .00 800,000.00 .0% 800001 4612 NCHGFRVAL - 65,166.39 .00 .00 - 6,738,887.28 .00 .00 .0% 800001 4620 GAIN SALE 2,029.42 .00 .00 568,029.14 .00 .00 .0% 800001 4622 UNRLZD G/L .00 .00 .00 - 65,925.20 .00 .00 .0% TOTAL INVESTMENT INCOME 531,716.68 800,000.00 800,000.00 - 5,748,124.64 .00 800,000.00 .0% 48 MISCELLANEOUS REVENU -------------------------------------------- 800001 4890 EMPR CONTB 698,335.00 790,000.00 790,000.00 843,209.00 844,000.00 950,000.00 20.3% 800001 4891 EMPEE -CONT 418,204.76 344,400.00 344,400.00 336,155.28 344,400.00 375,000.00 8.9% TOTAL MISCELLANEOUS REVENU 1,116,539.76 1,134,400.00 1,134,400.00 1,179,364.28 1,188,400.00 1,325,000.00 16.8% TOTAL POLICE PENSION FUND RE 1,648,256.44 1,934,400.00 1,934,400.00 - 4,568,760.36 1,188,400.00 2,125,000.00 9.9% TOTAL POLICE PENSION FUND 1,648,256.44 1,934,400.00 1,934,400.00 - 4,568,760.36 1,188,400.00 2,125,000.00 9.9% GRAND TOTAL 40,611,502.89 42,713,613.00 44,713,613.00 36,709,773.07 42,956,703.00 42,221,726.50 -5.6% ** END OF REPORT - Generated by Bob Fialkowski ** 03/27/2009 17:02 (VILLAGE OF DEERFIELD rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION PG 1 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------ - - - - -- 101111 FINANCE DEPARTMENT --------------------------- 51 PERSONNEL SERVICES 101111 5110 REG SALAR 722,476.03 795,900.00 795,900.00 723,169.38 795,900.00 805,000.00 1.1% CEME R&M INCREASE DUE TO COLA AND MERIT 101111 5325 DOG PND 1,829.17 101111 5330 101111 5111 PT SALARY 7,978.82 12,000.00 12,000.00 3,125.50 6,000.00 6,000.00 -50.0% 101111 5112 OT SALARY 1,488.87 9,500.00 9,500.00 103.26 4,000.00 8,500.00 -10.5% POSTAGE OVERTIME AS NECESSARY FOR DEPT PERSONNEL INS GL 90,191.47 101111 5363 P/S MEDIC .00 101111 5120 MED BNFT 128,207.79 130,861.50 130,861.50 119,646.50 130,861.50 148,000.00 13.1% 101111 5121 DNTL BNFT 7,909.69 10,000.00 10,000.00 7,073.17 9,500.00 10,000.00 .0% 101111 5122 MISC BNFT 5,556.06 6,500.00 6,500.00 8,824.22 8,000.00 8,000.00 23.1% 101111 5123 IPBC ADJ - 313,760.95 .00 .00 .00 .00 .00 .0% 101111 5130 APPAREL 203.94 500.00 500.00 305.48 500.00 500.00 .0% 101111 5140 PEN CNTRB 132,252.85 143,325.00 143,325.00 134,841.97 143,325.00 164,215.00 14.6% TOTAL PERSONNEL SERVICES 692,313.10 1,108,586.50 1,108,586.50 997,089.48 1,098,086.50 1,150,215.00 3.8% 52 TRAINING & DEVELOPME -------------------------------------------- 101111 5210 TRNG REG 4,903.00 11,500.00 11,500.00 3,000.00 3,000.00 8,000.00 -30.4% IT TRAINING - $4000 - RK0910 OTHER DEPT. TRAINING - $4,000 101111 5211 TRNG TRAV 548.99 1,200.00 1,200.00 509.65 1,200.00 1,200.00 .0% 101111 5212 TRNG EXP 10.00 3,000.00 3,000.00 .00 500.00 1,000.00 -66.7% 101111 5213 SUBSCRIPT 946.92 900.00 900.00 199.50 600.00 600.00 -33.3% TOTAL TRAINING & DEVELOPME 6,408.91 16,600.00 16,600.00 3,709.15 5,300.00 10,800.00 -34.9% 53 CONTRACTUAL SERVICES 101111 5320 BLDG R&M 2,324.93 101111 5322 EQUP R&M 21,006.47 101111 5324 CEME R&M 38,680.57 101111 5325 DOG PND 1,829.17 101111 5330 DUES 1,555.00 101111 5331 CNF MEET 1,436.44 101111 5332 TRAV EXP 3,463.31 101111 5335 PRINTING 3,570.85 101111 5336 LGL NOTICE 888.24 101111 5337 POSTAGE 5,030.27 101111 5350 INS GL 90,191.47 101111 5363 P/S MEDIC .00 101111 5365 P/S OTHER 68,355.87 2,500.00 INCLUDES AUDIT AT PROJECTED TOTAL OF $35,000 9,000.00 IT CONSULTING - $5,000 - RK0910 6,000.00 POLICE PENSION AUDIT - $2,700 110,000.00 110,000.00 OTHER PROFESSIONAL CONSULTING - $15,000 3,000.00 3,000.00 6,596.58 7,500.00 3,000.00 .016 8,000.00 8,000.00 2,607.27 8,000.00 8,000.00 .0% 15,000.00 15,000.00 13,841.85 15,000.00 15,000.00 .06 7,000.00 7,000.00 180.00 2,000.00 3,500.00 -50.0% 6,000.00 6,000.00 1,615.00 3,500.00 3,500.00 -41.7% 6,000.00 6,000.00 3,824.59 6,000.00 6,000.00 .016 5,000.00 5,000.00 1,874.02 5,000.00 51000.00 .0% 8,500.00 8,500.00 3,340.25 4,000.00 6,000.00 -29.4% 2,500.00 2,500.00 1,114.14 2,500.00 2,500.00 .0% 9,000.00 9,000.00 3,725.81 6,000.00 7,500.00 -16.716 110,000.00 110,000.00 98,009.44 104,000.00 115,060.00 4.66 1,000.00 1,000.00 .00 500.00 1,000.00 .0% 78,000.00 78,000.00 41,348.50 65,000.00 57,700.00 -26.06 03/27/2009 17:02 OF DEERFIELD 6,437.32 10,000.00 10,000.00 3,724.97 8,000.00 2 rfialkow 101111 (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 2,604.07 2,000.00 2,000.00 129.67 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION 101111 5440 SMTLSEQUP 845.84 FOR PERIOD 13 ACCOUNTS FOR: 1,500.00 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND 4,000.00 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 101111 5369 TRUST FEES .05 .00 .00 .00 .00 .00 .0% 101111 5370 DP SERV 61,692.33 97,350.00 97,350.00 63,689.03 97,350.00 80,000.00 -17.8% -13.0% SERVER A/C UNIT SUPPORT - $2500 - RK0910 101111 5381 FAM SERV .00 - 3,000.00 3,000.00 .00 3,000.00 3,000.00 .0% 101111 5382 HOUS ASST 8,250.00 .00 .00 .00 .00 .00 .0% 11,137.03 MOVED TO ADMINISTRATION 17,000.00 8,992.48 12,000.00 14,500.00 -14.7% TOTAL UTILITIES 12,841.36 101111 5383 SENR PKDIS 105,060.00 120,000.00 120,000.00 109,367.00 120,000.00 125,000.00 4.2% 101111 5384 TAXI SUBS 19,202.75 23,000.00 23,000.00 18,884.25 23,000.00 25,000.00 8.7% 101111 5386 FAMDYSEXP 81,931.59 90,000.00 90,000.00 81,434.89 90,000.00 90,000.00 .0% 101111 5395 ECON INCEN 848,242.18 800,000.00 800,000.00 795,913.05 925,000.00 1,150,000.00 43.8% ACCOUNTING RULES REQUIRE THAT WE EXPENSE THE ANTICIPATED 28,500.00 28,500.00 14,764.40 27,350.00 16,000.00 -43.9% REBATES FOR THE WALGREENS SALES TAX AGREEEMENT. INCREASE DUE TO INCREASED ACTIVITY BY WALGREENS AND FIRST FULL YEAR OF ADDITIONAL HOME RULE SALES TAX. TOTAL CONTRACTUAL SERVICES 1,362,711.49 1,392,350.00 1,392,350.00 1,247,365.67 1,487,350.00 1,706,760.00 22.616 54 COMMODITIES 101111 5410 MISC SUPP 6,437.32 10,000.00 10,000.00 3,724.97 8,000.00 9,000.00 -10.0% 101111 5421 MATERIAL 2,604.07 2,000.00 2,000.00 129.67 2,000.00 2,000.00 .0% 101111 5440 SMTLSEQUP 845.84 1,500.00 1,500.00 53.98 1,500.00 11500.00 .0% 101111 5450 OFF SUPP 2,851.30 7,000.00 7,000.00 1,091.90 4,000.00 4,500.00 -35.7% 101111 5460 OPER SUPP 3,513.83 4,000.00 4,000.00 5,135.05 4,000.00 4,000.00 .0% 101111 5470 R&M SUPP 611.23 2,500.00 2,500.00 893.81 2,500.00 2,500.00 .0% TOTAL COMMODITIES 16,863.59 27,000.00 27,000.00 11,029.38 22,000.00 23,500.00 -13.0% 55 UTILITIES -------------------------------------------- 101111 5520 U/E NAT GA 349.89 5,000.00 5,000.00 263.64 1,000.00 1,000.00 -80.0% 101111 5530 U/E WATER 1,354.44 5,000.00 5,000.00 6,746.70 7,500.00 7,500.00 50.0% 101111 5540 U/E TELEPH 11,137.03 17,000.00 17,000.00 8,992.48 12,000.00 14,500.00 -14.7% TOTAL UTILITIES 12,841.36 27,000.00 27,000.00 16,002.82 20,500.00 23,000.00 -14.8% 56 OTHER EXPENSES -------------------------------------------- 101111 5610 0TH EXPENS 415.00 .00 .00 .00 .00 .00 .0% TOTAL OTHER EXPENSES 415.00 .00 .00 .00 .00 .00 .0% 58 CAPITAL OUTLAY -------------------------------------------- 101111 5810 OP EQP 19,577.14 28,500.00 28,500.00 14,764.40 27,350.00 16,000.00 -43.9% RK0910 - $5000 MISC. RK0910 - $1500 Cisco WAP RK0910 - $1500 Digital Projector RK0910 - $5000 IP Camera 03/27/2009 17:02 VILLAGE OF DEERFIELD 3 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ------------------------------------------------------------------------------------------------------------------------------------ ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE TOTAL CAPITAL OUTLAY 19,577.14 28,500.00 28,500.00 14,764.40 27,350.00 16,000.00 -43.9% 72 j TRANSFERS OUT (IFT) -------------------------------------------- 101111 7210 TRNSFR OUT 4,000,000.00 .00 .00 .00 .00 2,100,000.00 .0% TRANSFER TO INFRASTRUCTURE FUND FOR CAPITAL PROJECT FUNDING 101111 7211 TRANS VERF 34,667.00 I 36,750.00 36,750.00 33,687.50 36,750.00 34,667.00 -5.7% I BUDGET CHANGE WITHOUT ECONOMIC INCENTIVES IS i A DECREASE OF 1.5% TOTAL TRANSFERS OUT (IFT) 4,034,667.00 36,750.00 36,750.00 33,687.50 36,750.00 2,134,667.00 5708.6% TOTAL FINANCE DEPARTMENT 6,145,797.59 2,636,786.50 2,636,786.50 2,323,648.40 2,697,336.50 5,064,942.00 92.1% 03/27/2009 17:02 (VILLAGE OF DEERFIELD rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION PG 4 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL ------------------------------------------------------------------------------------------------------------------------------------ FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 101210 ADMINISTRATION -------------------------------------------- 51 PERSONNEL SERVICES ---------------- 101210 ---------------------- 5110 REG SALAR - - - - -- 342,723.14 380,000.00 380,000.00 291,207.90 330,000.00 360,000.00 - 5.3% 101210 5111 PT SALARY 31,283.29 34,000.00 34,000.00 31,165.40 32,000.00 35,000.00 2.9% 101210 5112 OT SALARY 6,151.82 5,000.00 5,000.00 150.90 1,500.00 3,000.00 -40.0% 101210 5120 MED BNFT 37,564.05 47,074.21 47,074.21 33,639.72 40,000.00 48,000.00 2.0% 101210 5121 DNTL BNFT 3,080.92 4,200.00 4,200.00 2,620.20 3,500.00 4,200.00 .0% 101210 5122 MISC BNFT 66,577.70 15,000.00 15,000.00 1,218.12 8,000.00 15,000.00 .0% 101210 5140 PEN CNTRB 69,190.95 80,000.00 80,000.00 57,134.90 75,000.00 80,000.00 .0% TOTAL PERSONNEL SERVICES 556,571.87 565,274.21 565,274.21 417,137.14 490,000.00 545,200.00 -3.6% 52 TRAINING & DEVELOPME -------------------------------------------- 101210 5210 TRNG REG 350.00 1,000.00 1,000.00 1,554.00 2,000.00 3,000.00 200.0% SOFTWARE TRAINING - $2000 - RK0910 101210 5211 TRNG TRAV 917.13 1,000.00 1,000.00 1,224.79 1,500.00 1,500.00 50.0% 101210 5213 SUBSCRIPT 1,023.95 3,000.00 3,000.00 600.00 - 500.00 2,000.00 -33.3% TOTAL TRAINING & DEVELOPME 2,291.08 51000.00 5,000.00 3,378.79 4,000.00 6,500.00 30.096 53 CONTRACTUAL SERVICES -------------------------------------------- 101210 53,20 BLDG R&M 4,385.00 32,000.00 32,000.00 13,976.00 18,000.00 25,000.00 -21.9% PROFESSIONAL CLEANING SERVICES VILLAGE HALL ENTRYWAY MAT CLEANING 101210 5322 EQUP R&M 226.82 1,000.00 1,000.00 1,163.96 1,200.00 1,500.00 50.0% 101210 5326 VEH MAINT 488.60 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 101210 5330 DUES 16,197.61 20,000.00 20,000.00 16,019.38 20,000.00 20,000.00 .0% NW MUNICIPAL CONFERENCE - 7,460 NE ILL PLAN COMMISSION - 3,652 IML, SWALCO, TMA, ICMA, ILCMA, IPELRA 101210 5331 CNF MEET 1,718.96 51000.00 5,000.00 855.82 3,500.00 5,000.00 .0% 101210 5332 TRAV EXP 2,065.19 7,000.00 7,000.00 810.33 3,000.00 6,000.00 -14.3% 101210 5335 PRINTING 26,658.17 30,000.00 30,000.00 19,616.94 30,000.00 30,000.00 .0% 101210 5336 LGL NOTICE 541.44 600.00 600.00 10.00 600.00 600.00 .0% 101210 5337 POSTAGE 12,083.43 12,500.00 12,500.00 12,477.65 12,500.00 13,000.00 4.0% 101210 5360 P/S CRP CN 267,880.51 160,000.00 160,000.00 284,886.18 300,000.00 225,000.00 40.6% 101210 5370 DP SERV 16,548.97 25,000.00 25,000.00 21,775.14 25,600.00 12,000.00 -52.0% VILLAGE WEB SITE ENHANCEMENTS INCLUDING RE- DESIGN AND MAINTENANCE - $5000 - RK0910 ADOBE REN. - $3000 - RK0910 NUANCE PDF SOFT - $2000 - RK0910 PHONE /NETWORK SUPPORT $1500 - RK0910 03/27/2009 17:02 OF DEERFIELD PG 5 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 101210 5382 HOUS ASST .00 12,000.00 12,000.00 5,500.00 12,000.00 12,000.00 .0% 101210 5387 ADV BOARD 92,859.50 94,000.00 94,000.00 44,928.88 75,000.00 94,000.00 .0% INCLUDES $16,000 FOR ACTS OF KINDNESS PROGRAM INCLUDES $6,000 FOR CLEAN AIR COUNTS GRANTS TOTAL CONTRACTUAL SERVICES 441,654.20 400,100.00 400,100.00 422,020.28 502,400.00 445,100.00 11.2% 54 COMMODITIES -------------------------------------------- 101210 5410 MISC SUPP 3,580.94 2,500.00 2,500.00 1,528.88 2,500.00 2,500.00 .0% 101210 5420 PETR PROD 916.72 3,000.00 3,000.00 463.36 2,000.00 2,000.00 -33.3% 101210 5450 OFF SUPP 3,303.35 3,000.00 3,000.00 816.80 1,500.00 2,500.00 -16.7% 101210 5460 OPER SUPP 6,644.05 5,000.00 5,000.00 199.99 1,000.00 3,000.00 -40.0% 101210 5470 R&M SUPP 260.00 1,000.00 1,000.00 .00 500.00 1,000.00 .0% TOTAL COMMODITIES 14,705.06 14,500.00 14,500.00 3,009.03 7,500.00 11,000.00 -24.1% 55 UTILITIES -------------------------------------------- 101210 5540 U/E TELEPH 1,239.25 1,600.00 1,600.00 836.55 1,400.00 1,500.00 -6.3% TOTAL UTILITIES 1,239.25 1,600.00 1,600.00 836.55 1,400.00 1,500.00 -6.3% 58 CAPITAL OUTLAY -------------------------------------------- 101210 5810 OP EQP 3,517.09 4,000.00 4,000.00 2,116.98 4,000.00 .00 - 100.0% 101210 5840 OFC FURN 265,739.47 10,000.00 10,000.00 .00 2,000.00 2,000.00 -80.0% TOTAL CAPITAL OUTLAY 269,256.56 14,000.00 14,000.00 2,116.98 6,000.00 2,000.00 -85.7% 59 CAPITAL IMPROVEMENTS ----7--------------------------------------- 101210 5914 STRSCP IMP 57,963.25 48,000.00 48,000.00 45,234.79 50,000.00 52,000.00 8.3% URN PLANTINGS - $35,000 TOTAL CAPITAL IMPROVEMENTS 57,963.25 48,000.00 48,000.00 45,234.79 50,000.00 52,000.00 8.3% 72 TRANSFERS OUT (IFT) -------------------------------------------- 101210 7211 TRANS VERF 3,600.00 2,571.00 2,571.00 2,356.75 2,571.00 2,250.00 -12.5% TOTAL TRANSFERS OUT (IFT) 3,600.00 2,571.00 2,571.00 2,356.75 2,571.00 2,250.00 -12.5% TOTAL ADMINISTRATION 1,347,281.27 1,051,045.21 1,051,045.21 896,090.31 1,063,871.00 1,065,550.00 1.4% 03/27/2009 17:02 (VILLAGE OF DEERFIELD rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION PG 6 bgnyrpts FOR PERIOD 13 ACCOUNTS-FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ---------------------------------------------------------------------------------------------------------------------------------- 101330 COMMUNITY DEVELOPMENT 51 PERSONNEL SERVICES 101330 5110 REG SALAR 557,468.05 584,000.00 584,000.00 523,616.51 575,000.00 602,000.00 3.1% 101330 5111 PT SALARY 4,339.75 25,000.00 25,000.00 15,341.26 18,000.00 25,000.00 .0% 101330 5112 OT SALARY 7,831.23 9,600.00 9,600.00 7,031.03 8,000.00 9,600.00 .0% 101330 5120 MED BNFT 89,595.39 99,300.00 99,300.00 86,570.59 95,000.00 105,258.00 6.0% 101330 5121 DNTL BNFT 6,881.40 9,500.00 9,500.00 6,235.50 7,500.00 9,500.00 .0% 101330 5122 MISC BNFT 2,450.04 .00 .00 3,729.20 4,000.00 5,000.00 .0% TUITION REIMBURSEMENT 101330 5130 APPAREL 638.68 1,000.00 1,000.00 .00 500.00 1,000.00 .0% Boots, Jackets, etc. 101330 5140 PEN CNTRB 104,137.62 114,000.00 114,000.00 103,819.04 111,000.00 125,400.00 10.0% TOTAL PERSONNEL SERVICES 773,342.16 842,400.00 842,400.00 746,343.13 819,000.00 882,758.00 4.8% 52 ' TRAINING & DEVELOPME -------------------------------------------- 101330 5211 TRNG TRAV 173.64 1,000.00 1,000.00 551.58 1,000.00 1,000.00 .0% training related travel expenses 101330 5212 TRNG EXP 3,073.40 6,000.00 6,000.00 1,094.35 2,500.00 6,000.00 .0% fees, tuitions and course costs 101330 5213 SUBSCRIPT 1,030.83 1,000.00 1,000.00 623.85 1,000.00 1,000.00 .0% TOTAL TRAINING & DEVELOPME 4,277.87 8,000.00 8,000.00 2,269.78 4,500.00 8,000.00 .0% 53 CONTRACTUAL SERVICES -------------------------------------------- 101330 5322 EQUP R&M 816.76 4,000.00 4,000.00 493.75 1,500.00 4,000.00 .0% 101330 5326 VEH MAINT 2,956.16 5,300.00 5,300.00 7,913.19 7,500.00 9,000.00 69.8% 101330 5330 DUES 882.00 2,000.00 2,000.00 711.00 1,200.00 2,000.00 .0% 101330 5332 TRAV EXP 51.60 400.00 400.00 52.30 400.00 400.00 .0% 101330 5335 PRINTING 2,373.41 6,000.00 6,000.00 1,940.60 2,500.00 5,000.00 -16.7% Building Permits applications, placards, Temporary use permits Public Hearing signs Zoning Ord, Devlopment Code, Subdivision Code, Etc. 101330 5336 LGL NOTICE 2,234.07 3,200.00 3,200.00 535.14 2,000.00 3,000.00 -6.3% 101330 5337 POSTAGE 2,082.74 3,000.00 3,000.00 2,040.42 3,000.00 3,000.00 .0% 101330 5363 P/S MEDIC .00 600.00 600.00 .00 600.00 600.00 .0% 101330 5365 P/S OTHER 53,640.00 89,000.00 89,000.00 52,690.54 75,000.00 89,000.00 .0% See Thompson's Fee Schedule attached valid for 09 -10 per Kathy at Thompson. Fees plus 15% is billed to recipient Fee is passed through to recipient +15% 750 Plumbing inspections @ $65 ea. = $48,750 08 -09 no change per Mike Murrin 11/15/07 Plan review $2,500 03/27/2009 17:02 OF DEERFIELD PG 7 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 101330 5370 DP SERV 27,857.01 25,600.00 25,600.00 19,177.15 25,600.00 16,500.00 - 35.5°% RK- 0910 - NETWORK SUPPORT -$5000 Ongoing document scanning - $10,000 TOTAL CONTRACTUAL SERVICES 92,893.75 139,100.00 139,100.00 85,554.09 119,300.00 132,500.00 -4.7% 54 COMMODITIES -------------------------------------------- 101330 5410 MISC SUPP 2,314.99 7,500.00 7,500.00 3,391.26 5,000.00 6,500.00 -13.3% $5,000 for new and replacement banners for Village Center banner poles. 101330 5420 PETR PROD 3,421.25 4,500.00 4,500.00 3,118.24 4,500.00 4,700.00 4.4% 101330 5450 OFF SUPP 3,654.73 5,500.00 5,500.00 1,536.12 3,500.00 5,500.00 .0% 101330 5460 OPER SUPP 2,834.57 6,000.00 6,000.00 3,882.26 5,000.00 5,000.00 -16.7% 101330 5470 R&M SUPP 1,179.20 2,000.00 2,000.00 1,128.86 2,000.00 2,000.00 .0% TOTAL COMMODITIES 13,404.74 25,500.00 25,500.00 13,056.74 20,000.00 23,700.00 -7.1% 55 UTILITIES -------------------------------------------- 101330 5520 U/E NAT GA 4,625.00 3,000.00 3,000.00 .00 .00 .00 - 100.0% PRIOR YEARS WAS FOR ANNEX BUILDING 101330 5540 U/E TELEPH 9,145.68 9,500.00 9,500.00 5,274.72 8,500.00 9,000.00 -5.3% TOTAL UTILITIES 13,770.68 12,500.00 12,500.00 5,274.72 8,500.00 9,000.00 -28.0% 58 CAPITAL OUTLAY -------------------------------------------- 101330 5810 OP EQP 9,206.60 .00 .00 314.75 400.00 5,000.00 .0% RK -0910- IP Camera - $5000 101330 5830 OFC EQP .00 1,000.00 1,000.00 .00 .00 1,000.00 .0% TOTAL CAPITAL OUTLAY 9,206.60 1,000.00 1,000.00 314.75 400.00 6,000.00 500.0% 72 TRANSFERS OUT (IFT) -------------------------------------------- 101330 7211 TRANS VERF 3,000.00 6,143.00 6,143.00 5,631.08 6,143.00 5,750.00 -6.4% TOTAL TRANSFERS OUT (IFT) 3,000.00 6,143.00 6,143.00 5,631.08 6,143.00 5,750.00 -6.4% TOTAL COMMUNITY DEVELOPMENT 909,895.80 1,034,643.00 1,034,643.00 858,444.29 977,843.00 1,067,708.00 3.2% 03/27/2009 17:02 OF DEERFIELD 8 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL ------------------------------------------------------------------------------------------------------------------------------------ FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 102010 STREET ADMINISTRATION -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 102010 5110 REG SALAR 149,450.66 166,000.00 166,000.00 142,511.34 177,000.00 182,310.00 9.81 1/2 STREET CREW LEADER 1/3 SUPERINTENDENT OF STREETS AND UTILITIES 1/4 DIRECTOR OF PUBLIC WORKS 1/4 ASST DIRECTOR OF PUBLIC WORKS 1/4 PW & ENGINEERING SECRETARY 1/4 PW SECRETARY II 102010 5111 PT SALARY 1,988.04 6,300.00 6,300.00 1,187.08 2,500.00 2,500.00 -60.3% SUMMER HELP 2 -3 PEOPLE 102010 5112 OT SALARY 6,111.44 11,000.00 11,000.00 10,733.43 13,000.00 11,000.00 .0% CREW LEADER 8 x 26.1 PERIODS PAID ON CALL 52 WEEK /7 =8 TIMES x $95 /TIME SECRETARY OT (2) x 2 HR /PERIOD x 26.1 PERIODS= 104.4HR 102010 5120 MED BNFT 21,684.24 34,000.00 34,000.00 23,812.96 30,000.00 36,000.00 5.9% 102010 5121 DNTL BNFT 1,414.48 3,000.00 3,000.00 1,607.83 2,500.00 3,000.00 .0% 102010 5122 MISC BNFT 392.60 4,000.00 4,000.00 666.73 1,000.00 1,000.00 -75.01 102010 5130 APPAREL 4,006.41 6,700.00 6,700.00 4,018.21 6,700.00 6,700.00 .0% Uniforms, boots, jackets $500 x (7 +1.3) =$4200 1 safety apparel $300 x (7+1.3) =$2500 102010 5140 PEN CNTRB 28,363.52 36,000.00 36,000.00 28,811.86 36,000.00 39,600.00 10.0% TOTAL PERSONNEL SERVICES 213,411.39 267,000.00 267,000.00 213,349.44 268,700.00 282,110.00 5.7% 52 TRAINING & DEVELOPME -------------------------------------------- 102010 5210 TRNG REG 899.02 4,400.00 4,400.00 492.50 1,000.00 1,500.00 -65.91 Training registrations, CDL licenses $200 /man X (7 +1) men 102010 5211 TRNG TRAV 111.00 1,300.00 1,300.00 130.00 300.00 500.00 -61.5% 102010 5213 SUBSCRIPT 29.25 500.00 500.00 .00 100.00 100.00 -80.0% TOTAL TRAINING & DEVELOPME 1,039.27 53 CONTRACTUAL SERVICES -------------------------------------------- 102010 5320 BLDG R&M 16,805.36 1/4 cleaning service, $4000 overhead doors $2000 HVAC, $1500 flooring 6,200.00 15,000.00 6,200.00 15,000.00 622.50 38,614.99 1,400.00 40,000.00 2,100.00 -66.1% 15,000.00 .0% 03/27/2009 17:02 OF DEERFIELD 9 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 102010 5322 EQUP R&M 3,424.85 3,500.00 3,500.00 1,954.00 2,500.00 2,500.00 - 28.6°% $900 for 1/3 JULIE, fax, copier, fuel tank meters, 102010 5326 VEH MAINT 6,028.59 81000.00 8,000.00 1,837.50 5,000.00 5,000.00 -37.5% 102010 5330 DUES 851.00 1,300.00 1,300.00 1,407.00 1,000.00 1,000.00 -23.1% Dues for membership to APWA $250 $750 FOR NIPSTA MEMBERSHIP (1/4 OF $3000 ) 102010 5332 TRAV EXP 999.54 3,200.00 3,200.00 775.21 1,000.00 1,000.00 -68.8% travel expenses for seminars , conferences $100 per employee 7 +1= $800 102010 5335 PRINTING 1,193.60 3,000.00 3,000.00 553.30 2,000.00 2,000.00 -33.3% 102010 5336 LGL NOTICE 115.01 300.00 300.00 109.04 300.00 300.00 .0% Bid notices, job openings 102010 5337 POSTAGE 2,052.15 3,000.00 3,000.00 2,006.25 3,000.00 3,000.00 .0% 102010 5350 INS GL 76,296.55 90,000.00 90,000.00 80,189.54 88,000.00 108,260.00 20.3% 102010 5363 P/S MEDIC 693.25 1,300.00 1,300.00 665.00 1,300.00 1,300.00 .0% 8 x $100 FOR ALCHOL & DRUG TESTING $500 FOR PRE - EMPLOYMENT TESTING 102010 5365 P/S OTHER 878.00 20,000.00 20,000.00 9,242.50 10,000.00 5,000.00 -75.0% 1/4 $2400 for weather services 102010 5370 DP SERV 1,871.09 5,000.00 5,000.00 2,260.00 5,000.00 3,000.00 -40.0% Replacements and updates TOTAL CONTRACTUAL SERVICES 111,208.99 153,600.00 153,600.00 139,614.33 159,100.00 147,360.00 -4.1% 54 COMMODITIES -------------------------------------------- 102010 5410 MISC SUPP 4,847.46 5,500.00 5,500.00 4,622.15 5,500.00 5,500.00 .0% Safety equipment, flashlight, batteries, barricades, cones work zone signs 102010 5420 PETR PROD 1,721.42 2,500.00 2,500.00 1,444.16 2,500.00 2,500.00 .0% 102010 5450 OFF SUPP 1,947.28 2,000.00 2,000.00 1,362.26 2,000.00 2,000.00 .0% 102010 5460 OPER SUPP 2,616.65 2,000.00 2,000.00 2,158.24 2,000.00 2,000.00 .0% Cleaning products, brooms, mops, paper towels, coffee, ice 102010 1 5470 R&M SUPP 803.37 800.00 800.00 .00 800.00 800.00 .0% TOTAL COMMODITIES 11,936.18 12,800.00 12,800.00 9,586.81 12,800.00 12,800.00 .0% 55 UTILITIES -------------------------------------------- 102010 5510 U/E ELECT 2,552.65 3,500.00 3,500.00 1,880.13 1,500.00 1,500.00 -57.1% 102010 5540 U/E TELEPH 6,330.49 7,000.00 7,000.00 5,018.83 7,000.00 7,000.00 .0% Nextel phone bills, public works land lines and alarms TOTAL UTILITIES 8,883.14 10,500.00 10,500.00 6,898.96 8,500.00 8,500.00 -19.0% 58 CAPITAL OUTLAY -------------------------------------------- 102010 5810 OP EQP 1,027.00 3,600.00 3,600.00 5,618.87 6,000.00 2,000.00 -44.4% 03/27/2009 17:02 OF DEERFIELD 10 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE TOTAL CAPITAL OUTLAY 1,027.00 3,600.00 3,600.00 5,618.87 6,000.00 2,000.00 -44.4% 72 TRANSFERS OUT (IFT) -------------------------------------------- 102010 7211 TRANS VERF 127,915.00 164,150.00 164,150.00 150,470.83 164,150.00 173,872.00 5.9% TOTAL TRANSFERS OUT (IFT) 127,915.00 164,150.00 164,150.00 150,470.83 164,150.00 173,872.00 5.9% TOTAL STREET ADMINISTRATION 475,420.97 617,850.00 617,850.00 526,161.74 620,650.00 628,742.00 1.816 03/27/2009 17:02 OF DEERFIELD 11 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL ------------------------------------------------------------------------------------------------------------------------------------ FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 102036 STREET SNOW & ICE REMOVAL -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 102036 5110 REG SALAR 34,996.30 47,000.00 47,000.00 27,193.93 47,000.00 48,410.00 3.0% SNOW AND ICE CONTROL All public works departments charged to this account during snow removal operations 102036 5111 PT SALARY 2,515.64 3,150.00 3,150.00 3,850.50 3,150.00 3,307.50 5.0% 102036 5112 OT SALARY 147,307.87 65,000.00 65,000.00 95,703.32 130,000.00 65,000.00 .0% All public works departments charged to this account during overtime snow removal operations 102036 5120 MED BNFT 24,807.81 12,000.00 12,000.00 13,815.55 15,000.00 16,000.00 33.3% 102036 5121 DNTL BNFT 1,635.26 1,800.00 1,800.00 853.99 100.00 250.00 -86.1% 102036 5122 MISC BNFT 255.89 500.00 500.00 131.76 500.00 500.00 .0% 102036 5140 PEN CNTRB 34,676.78 16,480.00 16,480.00 23,844.84 17,000.00 19,500.00 18.3% TOTAL PERSONNEL SERVICES 246,195.55 145,930.00 145,930.00 165,393.89 212,750.00 152,967.50 4.8% 53 CONTRACTUAL SERVICES -------------------------------------------- 102036 5310 RENT EQP 2,099.50 2,500.00 2,500.00 3,660.00 2,500.00 2,500.00 .0% Semi trucks, snow blower for heavy snowfall 102036 5322 EQUP R&M 72,786.75 35,000.00 35,000.00 100,437.51 100,000.00 35,000.00 .0% All snow removal related equipment, plow blades, casters plows INCREASE DUE TO RISE IN STEEL COST 102036 5326 VEH MAINT 37,979.43 40,000.00 40,000.00 31,156.74 40,000.00 40,000.00 .0% All snow removal related vehicles 102036 5390 OTHER 32,337.88 13,000.00 13,000.00 16,982.50 25,000.00 13,000.00 .0% Sidewalk and parking lot contractual snow removal TOTAL CONTRACTUAL SERVICES 145,203.56 90,500.00 90,500.00 152,236.75 167,500.00 90,500.00 .0% 54 1 COMMODITIES -------------------------------------------- 102036 5420 PETR PROD 31,207.94 14,000.00 14,000.00 19,214.26 18,000.00 14,000.00 .0% 102036 5421 MATERIAL 8,084.21 2,500.00 2,500.00 3,549.66 8,000.00 2,500.00 .0% Ice melt for sidewalks around public buildings 102036 5422 CHEMICAL 425,962.96 225,000.00 225,000.00 614,453.78 600,000.00 225,000.00 .0% Bulk road salt purchased under state bid or other sources as needed. CALCIUM CHLORIDE LIQUID $25,000 PAST HISTORY $200,000 08/09, 09/10 03/27/2009 17:02 OF DEERFIELD 12 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 102036 5460 OPER SUPP 2,425.20 1,000.00 1,000.00 2,830.56 2,000.00 1,000.00 .0% Meals during emergency operations 102036 5470 R&M SUPP 950.68 1,500.00 1,500.00 1,147.07 1,500.00 1,500.00 .0% Mailboxes, dirt and seed for snow plow damage restoration PAST-EXPERIENCE = $1200, -USE $1,500 TOTAL COMMODITIES 468,630.99 244,000.00 244,000.00 641,195.33 629,500.00 244,000.00 .0% 58 CAPITAL OUTLAY - - -- --------------------------------------- 102036 5810 OP EQP .00 27,000.00 27,000.00 26,856.80 27,000.00 7,500.00 -72.2% Small snow blowers, sidewalk spreaders TOTAL CAPITAL OUTLAY .00 27,000.00 27,000.00 26,856.80 27,000.00 7,500.00 -72.2% 59 CAPITAL IMPROVEMENTS -------------------------------------------- 102036 5914 STRSCP IMP .00 .00 .00 500.00 500.00 .00 .0% TOTAL CAPITAL IMPROVEMENTS .00 .00 .00 500.00 500.00 .00 .0% TOTAL STREET SNOW & ICE REMO 860,030.10 507,430.00 507,430.00 986,182.77 1,037,250.00 494,967.50 -2.5% 03/27/2009 17:02 (VILLAGE OF DEERFIELD IPG 13 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------ - - - - -- 102037 STREET FORESTRY 51 PERSONNEL SERVICES 102037 5110 REG SALAR 12,178.74 46,575.00 -57.1% Trees, grass and weed control. 68.00 1,500.00 102037 5111 PT SALARY 3,663.13 3,675.00 7,500.00 Part time salaries 1.05 .0% 10,000.00 102037 5112 OT SALARY 10,434.80 7,500.00 1,200.00 Storm damage 400.00 600.00 102037 5120 MED BNFT 3,712.38 10,000.00 102037 5121 DNTL BNFT 247.33 1,200.00 102037 5122 MISC BNFT 35.23 300.00 102037 5140 PEN CNTRB 4,486.37 9,500.00 TOTAL PERSONNEL SERVICES 34,757.98 78,750.00 53 CONTRACTUAL SERVICES 10,000.00 9,827.75 -------------------------------------------- 102037 5320 BLDG R&M 195.00 .00 102037 5322 EQUP R&M 18,660.87 10,000.00 218,000.00 Chainsaws lawn mowers and weed wackers 198,000.00 102037 5326 VEH MAINT 11,863.68 8,500.00 Riding mowers 102037 5365 P/S OTHER 120,978.11 218,000.00 contractual weed spraying $4000 URBAN FOREST MANAGMENT 45,000 TOTAL (12,000 DED SURVEY,5,000 PERMITS /REVIEWS,.. (10,000 INSPECTIONS,15,000 TREE ID SURVEY, 3,000 MISC) 40,000 TREE TRIMMING 42,000 TREE AND STUMP REMOVAL 7,000 STORM DAMAGE 15,000 EMERALD ASH BORER 15,000 GYPSY MOTH $10,000 DOWNTOWN PLANTINGS $20,000 PARKWAY IMPROVEMENTS TOTAL CONTRACTUAL SERVICES 151,697.66 236,500.00 54 COMMODITIES -------------------------------------------- 102037 5420 PETR PROD 2,433.68 3,000.00 102037 5421 MATERIAL 3,550.39 5,000.00 Tree wrap, dirt and seed 46,575.00 1,741.37 1,800.00 20,000.00 -57.1% 3,675.00 68.00 1,500.00 3,675.00 .0% 7,500.00 4,088.41 7,500.00 7,500.00 .0% 10,000.00 1,035.03 3,000.00 5,000.00 -50.0% 1,200.00 68.70 400.00 600.00 -50.0% 300.00 10.04 300.00 300.00 .0% 9,500.00 1,113.97 3,000.00 4,000.00 -57.9% 78,750.00 8,125.52 17,500.00 41,075.00 -47.8% .00 .00 .00 .00 .0% 10,000.00 9,827.75 15,000.00 12,000.00 20.0% 8,500.00 12,484.17 15,000.00 10,000.00 17.6% 218,000.00 174,359.13 175,000.00 198,000.00 -9.2% 236,500.00 196,671.05 205,000.00 220,000.00 -7.0% 3,000.00 1,867.14 3,000.00 3,000.00 .0% 5,000.00 3,688.85 5,000.00 5,000.00 .0% 03/27/2009 17:02 OF DEERFIELD 14 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 102037 5460 OPER SUPP .00 500.00 500.00 349.90 500.00 500.00 .0% BLADES FOR SAWS AND MOWERS DUST MASK, EAR PLUGS TOTAL COMMODITIES - - - 5,984.07. 8,500.00 8,500.00 5,905.89 8,500.00 8,500.00 .0% 58 CAPITAL OUTLAY -------------------------------------------- 102037 5810 OP EQP 2,781.89 5,000.00 5,000.00 1,560.00 5,000.00 5,000.00 .016 $500 lawn mower $500 Chainsaw Replace Lawn mowers and maintenace equipment (weed eaters) TOTAL CAPITAL OUTLAY 2,781.89 5,000.00 5,000.00 1,560.00 5,000.00 5,000.00 .0% 59 CAPITAL IMPROVEMENTS -------------------------------------------- 102037 5914 STRSCP IMP 22,269.00 50,000.00 50,000.00 87,851.97 90,000.00 35,000.00 -30.0% $9000 50/50 tree ..Past history $10,000 COMBINED DOWNTOWN $ 5,000 BRICK PAVER WORK BRICK BOLLARDS / TREES / IRON TREE GRATES) SPRINKLER SYSTEM TOTAL CAPITAL IMPROVEMENTS 22,269.00 50,000.00 50,000.00 87,851.97 90,000.00 35,000.00 -30.0% TOTAL STREET FORESTRY 217,490.60 378,750.00 378,750.00 300,114.43 326,000.00 309,575.00 -18.3% 03/27/2009 17:02 VILLAGE OF DEERFIELD PG 15 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL ------------------------------------------------------------------------------------------------------------------------------------ FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 102038 STREET TRAIN STATION MAINT -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 102038 5110 REG SALAR 6,195.51 10,000.00 10,000.00 5,871.64 8,000.00 8,000.00 -20.01 Pedestrian bridge, viaduct and train station 102038 5111 PT SALARY .00 1,000.00 1,000.00 .00 .00 .00 - 100.0% 102038 5112 OT SALARY .00 500.00 500.00 .00 .00 .00 - 100.0% 102038 5120 MED BNFT 641.07 2,000.00 2,000.00 618.67 2,000.00 2,000.00 .0% 102038 5121 DNTL BNFT 42.76 190.00 190.00 38.65 190.00 190.00 .0% 102038 5122 MISC BNFT 13.34 .00 .00 12.26 10.00 .00 .0% 102038 5140 PEN CNTRB 1,157.43 1,600.00 1,600.00 1,126.96 1,600.00 1,760.00 10.0% TOTAL PERSONNEL SERVICES 8,050.11 15,290.00 15,290.00 7,668.18 11,800.00 11,950.00 -21.8% 53 CONTRACTUAL SERVICES -------------------------------------------- 102038 5320 BLDG R&M 4,146.90 50,000.00 50,000.00 11,223.97 12,000.00 50,000.00 .096 Electric doors, floor sanding windows and rails. 2009 -10 paint out side of building TRANSFERED PART FROM 602019 -5320 COMMUTER LOT COMBINED 102038 5321 STRUC R&M 11,894.00 30,000.00 30,000.00 22,784.63 30,000.00 30,000.00 .0% Alarm maintenance $3760, door and window maintenance $2800 boiler maintenance $4000 parking lots $3500 1/3 cost for landscaping= $15,000 102038 5322 EQUP R&M 722.91 2,000.00 2,000.00 2,311.42 2,500.00 2,000.00 .0% TOTAL CONTRACTUAL SERVICES 16,763.81 82,000.00 82,000.00 36,320.02 44,500.00 82,000.00 .0% 54 COMMODITIES ----7--------------------------------------- 102038 5421 MATERIAL 1,070.52 2,500.00 2,500.00 291.76 2,500.00 2,500.00 .0% Hardware, wood and glass as needed for repairs 102038 5460 OPER SUPP 652.98 700.00 700.00 1,886.31 1,500.00 1,000.00 42.9% Floor sealers, waxes 102038 5470 R&M SUPP 815.80 1,000.00 1,000.00 300.43 1,000.00 1,000.00 .0% Mops, rags and brooms TOTAL COMMODITIES 2,539.30 4,200.00 4,200.00 2,478.50 5,000.00 4,500.00 7.1% 55 UTILITIES -------------------------------------------- 102038 5550 U/E TELECM .00 500.00 500.00 .00 500.00 500.00 .0% Telemetry and phone t 03/27/2009 17:02 OF DEERFIELD IPG 16 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE TOTAL UTILITIES .00 500.00 500.00 .00 500.00 500.00 .0% TOTAL STREET TRAIN STATION M 27,353.22 101,990.00 101,990.00 46,466.70 61,800.00 98,950.00 -3.016 03/27/2009 17:02 OF DEERFIELD 17 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL ------------------------------------------------------------------------------------------------------------------------------------ FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 102050 STREET MAINTENANCE -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 102050 5110 REG SALAR 340,478.65 362,250.00 362,250.00 337,879.83 362,250.00 375,000.00 3.5% 6.5 EMPLOYEES STREET MAINTENANCE INC. 1/2 STREET CREW LEADER 102050 5111 PT SALARY 15,217.78 14,700.00 14,700.00 17,555.78 20,000.00 15,000.00 2.0% Seasonal help, 3 men typical X 15 /weeks /man @ $8 to $10 /hr. depending on number of years (1.05) 102050 5112 OT SALARY 40,636.67 40,000.00 40,000.00 31,658.41 40,000.00 40,000.00 .0% Emergency call back 6.5 employees, inc CREW LEADER 102050 5120 MED BNFT 77,351.52 91,000.00 91,000.00 84,414.00 91,000.00 100,000.00 9.9% 102050 5121 DNTL BNFT 5,244.53 6,500.00 6,500.00 5,337.23 6,500.00 7,000.00 7.7% 102050 5122 MISC BNFT 696.62 1,500.00 1,500.00 723.95 1,500.00 1,500.00 .0% 102050 5130 APPAREL 63.05 .00 .00 .00 .00 .00 .0% 102050 5140 PEN CNTRB 71,513.37 70,000.00 70,000.00 66,126.71 78,000.00 88,000.00 25.7% TOTAL PERSONNEL SERVICES 551,202.19 585,950.00 585,950.00 543,695.91 599,250.00 626,500.00 6.9% 52 TRAINING & DEVELOPME -------------------------------------------- 102050 5210 TRNG REG 185.00 .00 .00 .00 .00 .00 .0% MOVED TO 102010 -5210 TOTAL TRAINING & DEVELOPME 185.00 .00 .00 .00 .00 .00 .0% 53 CONTRACTUAL SERVICES -------------------------------------------- 102050 5310 RENT EQP .00 6,000.00 6,000.00 5,135.00 6,000.00 6,000.00 .0% Sweeper if needed due to breakdown of village sweeper 1 month of rental $6,000.0 102050 5322 EQUP R&M 9,093.63 15,000.00 15,000.00 10,352.07 15,000.00 15,000.00 .0% $7000 to replace residential and traffic light knock downs $1000 for dump fees and $3000 for fence repairs $4000 for miscellaneous 102050 5326 VEH MAINT 54,585.82 42,000.00 42,000.00 26,021.98 42,000.00 42,000.00 .0% 102050 5365 P/S OTHER 44,922.46 65,000.00 65,000.00 47,936.42 65,000.00 65,000.00 .0% Directional boring - $20,000 Bridge cleaning - $5,000 Thermoplastic - 10,000 Crack seal - $15,000 SIGNAL MAINT CONTRACTORS $15,000 TOTAL CONTRACTUAL SERVICES 108,601.91 128,000.00 128,000.00 89,445.47 128,000.00 128,000.00 .0% 54 COMMODITIES -------------------------------------------- 102050 5410 MISC SUPP 1,774.90 2,000.00 2,000.00 940.73 2,000.00 2,000.00 .0% Safety equipment, safety fence 03/27/2009 17:02 OF DEERFIELD IPG 18 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 102050 5420 PETR PROD 17,322.31 8,000.00 8,000.00 13,089.14 18,000.00 18,000.00 125.0% 102050 5421 MATERIAL 63,036.59 80,000.00 80,000.00 65,522.78 55,000.00 60,000.00 -25.0% Aggregates, blacktop, concrete, black dirt, seed, backfill crackfiller, aluminum signs blanks, sign posts, inlet frames and covers, street light poles , heads and lamps 102050 5430 ST SIGNS 7,268.00 12,000.00 12,000.00 192.20 5,000.00 7,500.00 -37.5% Sign sheeting for aluminum blanks 102050 5440 SMTLSEQUP 454.99 2,000.00 2,000.00 17.83 2,000.00 2,000.00 .0% Hand tools, specialized tools,shovels etc. 102050 5470 R&M SUPP 796.00 2,000.00 2,000.00 905.93 2,000.00 2,000.00 .0% Sweeper brooms TOTAL COMMODITIES 90,652.79 106,000.00 106,000.00 80,668.61 84,000.00 91,500.00 -13.7% 55 UTILITIES -------------------------------------------- 102050 5510 U/E ELECT 53,503.15 42,000.00 42,000.00 43,892.60 50,000.00 50,000.00 19.0% ROADWAY AND RESIDENTIAL LIGHTING TOTAL UTILITIES 53,503.15 42,000.00 42,000.00 43,892.60 50,000.00 50,000.00 19.0% 56 OTHER EXPENSES -------------------------------------------- 102050 5611 PMTS OTHR 50,401.07 38,000.00 38,000.00 33,238.82 50,000.00 50,000.00 31.6% $7000 for CCHD traffic signal agreement, $9000 for LCHD traffic signal agreement and $30,000 for IDOT traffic signal agreement $4000 for signal preemption at 294 spur on Waukegan Rd. TOTAL OTHER EXPENSES 50,401.07 38,000.00 38,000.00 33,238.82 50,000.00 50,000.00 31.6% 59 CAPITAL IMPROVEMENTS ---- - --------------------------------------- 102050 5950 BLDNG IMP .00 135,000.00 135,000.00 122,086.36 125,000.00 20,000.00 -85.2% I INC. REPLACE VILLAGE ENTRANCE SIGNAGE (6 LOCATIONS) BUDGET $10,000 FOR EACH OF 3 YRS. TOTAL CAPITAL IMPROVEMENTS .00 135,000.00 135,000.00 122,086.36 125,000.00 20,000.00 -85.2% TOTAL STREET MAINTENANCE 854,546.11 1,034,950.00 1,034,950.00 913,027.77 1,036,250.00 966,000.00 -6.7% 03/27/2009 17:02 OF DEERFIELD 19 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 102110 ENGINEERING DIVISION -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 102110 5110 REG SALAR 231,011.81 250,000.00 250,000.00 190,767.37 213,000.00 257,500.00 3.0% INCLUDE ASSISTANT ENGINEER INCLUDE STAFF ENGINEER INCLUDE ENG. INSPECTOR 102110 5111 PT SALARY 6,025.00 18,000.00 18,000.00 14,124.12 18,000.00 18,900.00 5.0% SUMMER INTERN FOR ENGINEERING $15 /HR @ APPROX 500 HOURS DURING THE SUMMER; ADDITIONAL FOR WINTER /SPRING BREAKS Extra inspector $10,000 X 1.05 = $18,375 102110 5112 OT SALARY 4,264.07 5,000.00 5,000.00 3,211.85 5,000.00 5,000.00 .0% 102110 5120 MED BNFT 42,393.74 46,000.00 46,000.00 39,229.70 46,000.00 48,760.00 6.0% 102110 5121 DNTL BNFT 2,812.07 1,000.00 1,000.00 2,480.73 3,500.00 3,500.00 250.0% 102110 5122 MISC BNFT 1,005.51 1,500.00 1,500.00 508.12 1,500.00 1,500.00 .0% ESTIMATE $500 PER PERSON (3) INC TUITION 102110 5130 APPAREL 1,423.42 1,500.00 1,500.00 1,392.83 1,500.00 1,500.00 .0% ESTIMATE $450 PER PERSON (3) 102110 5140 PEN CNTRB 44,062.71 45,000.00 45,000.00 37,847.95 46,000.00 50,000.00 11.1% TOTAL PERSONNEL SERVICES 332,998.33 368,000.00 368,000.00 289,562.67 334,500.00 386,660.00 5.1% 52 TRAINING & DEVELOPME -------------------------------------------- 102110 5210 TRNG REG .00 4,500.00 4,500.00 793.20 1,500.00 3,000.00 -33.3% 102110 5211 TRNG TRAV 3,991.68 1,500.00 1,500.00 1,344.67 1,500.00 1,500.00 .0% ESTIMATE $300 PER PERSON (4) ANNUAL CONF $300 102110 5213 SUBSCRIPT .00 600.00 600.00 27.50 600.00 200.00 -66.7% books, subscription, safety TOTAL TRAINING & DEVELOPME 3,991.68 6,600.00 6,600.00 2,165.37 3,600.00 4,700.00 -28.8% 53 1 CONTRACTUAL SERVICES ----7--------------------------------------- 102110 5322 EQUP R&M 1,501.09 1,000.00 1,000.00 110.00 1,000.00 1,000.00 .0% 102110 5326 VEH MAINT 11,235.07 10,000.00 10,000.00 6,459.60 10,000.00 10,000.00 .0% ESTIMATE $3000 PER VEHICLE (3) DUE TO INCREASED COSTS 102110 5330 DUES 854.00 1,800.00 1,800.00 349.50 1,800.00 1,200.00 -33.3% ESTIMATE $400 PER PERSON (3) INC APWA 102110 5332 TRAV EXP 411.40 3,200.00 3,200.00 1,610.44 1,500.00 1,500.00 -53.1% ESTIMATE $500 PER PERSON (3) 03/27/2009 17:02 OF DEERFIELD 20 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ----7------------------------------------------------------------------------------------------------------------------------------- 102110 5335 PRINTING 597.75 1,000.00 1,000.00 .00 500.00 500.00 -50.0% 102110 5336 LGL NOTICE 538.16 1,000.00 1,000.00 169.26 500.00 500.00 -50.0% EMPLOYEE RECRUITMENT PROJECT ADVERTISING - LEGAL NOTICE 102110 5337 POSTAGE 151.18- - - 600.00 600.00 420.76 600.00 600.00 .016 102110 5350 INS GL 918.97 1,150.00 1,150.00 1,024.64 1,150.00 1,350.00 17.416 102110 5362 PIS ENG 5,647.55 30,000.00 30,000.00 25,000.00 30,000.00 30,000.00 .0% PAVEMENT AND SOIL TESTING 102110 5363 PIS MEDIC .00 250.00 250.00 .00 250.00 250.00 .016 102110 5365 PIS OTHER 5,525.93 7,500.00 7,500.00 3,942.79 5,000.00 5,000.00 -33.3% 102110 5370 DP SERV 6,350.16 18,500.00 18,500.00 6,822.88 18,500.00 3,000.00 -83.8% PHONE \NETWORK SUPPORT - $2500 - RK0910 1021 -10 5375 GIS SERV 151,312.98 108,000.00 108,000.00 66,123.72 108,000.00 115,000.00 6.5% PROGRAM STAFFING - $67,000 AYRES ASSOCIATES - $27,000 HARDWARE - PLOTTERMAINT.$2000 SOFTWARE - GISCON INTERNET MAPPING - $5,000 MAINT & LICENSING SOFTWARE (ESRI) - $11,000 OTHER (CONFERENCES /MISC) - $2,000 TOTAL CONTRACTUAL SERVICES 185,044.24 184,000.00 184,000.00 112,033.59 178,800.00 169,900.00 -7.7% 54 COMMODITIES -------------------------------------------- 102110 5410 MISC SUPP 1,140.06 1,000.00 1,000.00 1,213.21 1,500.00 1,500.00 50.0% 102110 5420 PETR PROD 4,374.07 4,000.00 4,000.00 4,830.06 6,900.00 7,000.00 75.016 102110 5450 OFF SUPP 3,229.84 5,000.00 5,000.00 3,249.24 5,000.00 5,000.00 .0% 102110 5460 OPER SUPP 475.57 500.00 500.00 356.23 500.00 500.00 .0% TOTAL COMMODITIES 9,219.54 10,500.00 10,500.00 9,648.74 13,900.00 14,000.00 33.3% 55 UTILITIES -------------------------------------------- 102110 5540 U/E TELEPH 8,046.25 5,000.00 5,000.00 6,638.21 7,500.00 8,000.00 60.0% ESTIMATE $2500 PER PERSON (3) TOTAL UTILITIES 8,046.25 5,000.00 5,000.00 6,638.21 7,500.00 8,000.00 60.0% 58 CAPITAL OUTLAY -------------------------------------------- 102110 5810 OP EQP 5,819.81 5,500.00 5,500.00 4,999.23 5,500.00 5,000.00 -9.1% TOTAL CAPITAL OUTLAY 5,819.81 5,500.00 5,500.00 4,999.23 5,500.00 5,000.00 -9.10 72 TRANSFERS OUT (IFT) -------------------------------------------- 102110 7211 TRANS VERF 9,367.00 9,486.00 9,486.00 8,695.50 9,486.00 9,057.00 -4.5% 03/27/2009 17:02 VILLAGE OF DEERFIELD PG 21 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------ - -= - -- TOTAL TRANSFERS OUT (IFT) 9,367.00 9,486.00 9,486.00 8,695.50 9,486.00 9,057.00 -4.5% TOTAL ENGINEERING DIVISION 554,486.85 589,086.00 589,086.00 433,743.31 553,286.00 597,317.00 1.4% 03/27/2009 17:02 VILLAGE OF DEERFIELD PG 22 rfialkow (EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 106010 POLICE DEPT ADMINISTRATION -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------- ------ - - - - -- o 106010 5110 REG SALAR 445,483.32 537,074.00 537,074.00 446,589.97 495,000.00 553,186.00 3.0% PURPOSE OF ACCOUNT: SALARIES FOR REGULAR FULL TIME EMPLOYEES. INCLUDES ALLOWANCE FOR MERIT AND COLA DESCRIPTION: SALARIES FOR CHIEF, DEPUTY CHIEF OF ADMINISTRATION, ONE MANAGERIAL SECRETARY, TWO RECORDS CLERKS, AND TWO COMMUNITY SERVICE OFFICERS INCLUDE RETIRMENT PAYOUT, VACATION BUY BACK, ETC., IF KNOWN 106010 5111 PT SALARY .00 1,500.00 1,500.00 1,200.00 1,500.00 1,500.00 .0% PURPOSE OF ACCOUNT: SALARIES FOR PERMANENT AND PART TIME EMPLOYEES DESCRIPTION OF ITEMS: SALARIES FOR PART TIME EMPLOYEES AS THEY MAY BE REQUIRED 106010 5112 OT SALARY .00 3,500.00 3,500.00 397.09 1,500.00 3,500.00 .0% PURPOSE OF ACCOUNT: OVERTIME COSTS FOR REGULAR FULL TIME EMPLOYEES DESCRIPTION: OVERTIME COSTS FOR EMPLOYEES LISTED IN 106010 -5110 106010 5120 MED BNFT 83,125.19 93,090.00 93,090.00 89,177.34 94,000.00 100,000.00 7.4% PURPOSE: COST OF PROVIDING MEDICAL BENEFITS FOR ELIGIBLE EMPLOYEES DESCRIPTION: HOSPITALIZATION AND MEDICAL INS. COSTS FOR PERSONNEL ASSIGNED TO ADMINISTRATION. INCLUDES RETIREES' MONTHLY INSURANCE 106010 5121 DNTL BNFT 4,417.38 7,500.00 7,500.00 4,611.25 7,500.00 7,500.00 .0% PURPOSE: DENTAL INSRUANCE PAYMENT FOR EMPLOYEES ASSIGNED TO ADMINISTRATION DESCRIPTION: COST OF DENTAL INSURANCE FO PERSONNEL ASSIGNED TO ADMINISTRATION 106010 5122 MISC BNFT 7,153.28 6,000.00 6,000.00 6,248.34 6,000.00 8,000.00 33.3% PURPOSE: MISCELLANEOUS BENEFITS DESCRIPTION: SCHOOL BENEFITS FOR PERSONNEL IN COLLEGE PROGRAMS, CHIEF'S ICMA, LIFE INSURANCE 106010 5130 APPAREL 3,444.11 5,500.00 5,500.00 3,167.30 5,500.00 5,500.00 .0% PURPOSE: COST OF PROVIDING VILLAGE REQUIRED CLOTHING AND EQUIPMENT FOR PERSONNEL DESCRIPTION: CLOTHING ALLOWANCE FOR 2 OFFICERS Q $800 EACH, 2 COMMUNITY SERVICE OFFICERS Q $450 EACH MISC. CLOTHING ITEMS: BULLET PROOF VEST REPLACEMENT, UNIFORMS FOR NEW EMPLOYEES, ETC. 03/27/2009 17:02 (VILLAGE OF DEERFIELD rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION PG 23 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 106010 5140 PEN CNTRB 736,306.48 795,000.00 795,000.00 884,248.97 890,000.00 135,960.00 -82.9% PURPOSE: EMPLOYERS CONTRIBUTION TO POLICE PENSION FUND, IMRF, & FICA - 45,000 VILLAGE CONTRIBUTION TO POLICE PENSION - 78,600 POLICE PENSION CONTRIBUTION NOW ALLOCATED TO DIVISIONS BASED ON TOTAL SWORN SALARIES - TOTAL FOR ALL POLICE SWORN IS 950,000 TOTAL PERSONNEL SERVICES 1,279,929.76 1,449,164.00 1,449,164.00 1,435,640.26 1,501,000.00 52 TRAINING & DEVELOPME -------------------------------------------- 106010 5211 TRNG TRAV 3,310.83 18,000.00 18,000.00 PURPOSE: COST OF MEALS, HOTELS, MILEAGE & MISC. EXPENSES IN CONNECTION WITH TRAVEL TO CONVENTIONS, MEETINGS AND TRAINING DESCRIPTION: IL. CHIEFS CONFERENCE, ACCREDITATION CONFERENCE, MISC. TRAVEL, NWS ANNUAL CONFERENCE. IACP CONVENTION 106010 5212 TRNG EXP 2,740.28 7,500.00 7,500.00 PURPOSE: FEES AND REGISTRATION FOR TRAINING & CONF. DESCRIPTION: IACP CONFERENCE, COLLEGE OF LAKE COUNTY NORTHEAST MULTI- REGIONAL, MISC. TRAINING FBI ACADEMY 106010 5213 SUBSCRIPT 1,580.50 2,000.00 2,000.00 PURPOSE: Subscription and publications TOTAL TRAINING & DEVELOPME 7,631.61 27,500.00 27,500.00 53 CONTRACTUAL SERVICES -------------------------------------------- 106010 5320 BLDG R&M 49,495.48 65,000.00 65,000.00 PURPOSE: Repair and maintenance of building includes Maint. Agreements 106010 5322 EQUP R&M 14,482.68 27,500.00 27,500.00 PURPOSE: Repair and Maint. of Equipment 106010 5326 VEH MAINT 448.72 1,500.00 1,500.00 PURPOSE: Maintenance of vehicles DESCRIPTION: Maintenance of vehicles assigned to Administration 106010 5330 DUES 1,264.00 2,000.00 2,000.00 106010 5332 TRAV EXP 20.20 .00 .00 5,329.97 2,728.00 475.50 8,533.47 57,032.79 12,401.99 277.00 1,626.50 7.58 10,000.00 5,500.00 1,000.00 16,500.00 65,000.00 15,000.00 1,500.00 2,000.00 .00 815,146.00 -43.8% 15,000.00 -16.7% 7,500.00 .0% 2,000.00 .0% 24,500.00 -10.9% 65,000.00 .01V 27,500.00 .0% 1,500.00 .0% 2,000.00 .0% .00 .0% 03/27/2009 17 :02 OF DEERFIELD MISC SUPP 168.00 106010 5420 24 rfialkow 106010 (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 OFF SUPP 8,728.73 106010 5460 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION 16,963.72 SERVER BACKUP TAPES - $2000 FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 106010 5335 PRINTING 8,302.68 8,000.00 8,000.00 6,896.34 8,000.00 8,000.00 .0% PURPOSE: Forms, letterhead, envelopes, case reports, tickets, etc. 106010 5336 LGL NOTICE 74.56 1,000.00 1,000.00 .00 .00 1,000.00 .0% 106010 5337- - POSTAGE 3,373.02 4,000.00 4,000.00 3,092.34 4,000.00 4.,000.00 .0% PURPOSE: Regular postage, billings, newsletter, overnight mailings 106010 5350 INS GL 194,396.19 240,000.00 240,000.00 216,821.00 225,000.00 288,700.00 20.316 106010 5361 PIS PRSCTR 56,810.00 60,000.00 60,000.00 39,615.00 60,000.00 60,000.00 .0% EXPENSE TRANSFERRED FROM FINANCE AS SERVICES ARE MAINLY PERFORMED FOR POLICE DEPT. 106010 5363 PIS MEDIC 8,916.00 6,000.00 6,000.00 5,581.00 6,000.00 6,000.00 .0% 106010 5365 PIS OTHER 500.00 .00 .00 .00 .00 .00 .0% 106010 5370 DP SERV 13,028.11 18,500.00 18,500.00 15,498.83 18,500.00 18,500.00 .0% 106010 5387 ADV BOARD 14,600.37 20,000.00 20,000.00 23,526.96 24,000.00 20,000.00 .0% PURPOSE: Costs associated with various village boards and commissions DESCRIPTION: Costs associated with testing of Police Cand. Sergeants exam, expenses incurred from Mudfest, etc. Newspaper ads - $2,000 Consultation Fees (Zachar) - $2,400 Cost of Police Test - $2,000 Credit Checks - $750 Sergeants Test - $3,000 Mudfest - $8,000 106010 5388 EMER SERV 7,222.98 10,000.00 10,000.00 14,706.80 10,000.00 10,000.00 .0% PURPOSE: Cost of operating the ESDA Center 106010 5390 OTHER 48,736.34 63,000.00 63,000.00 39,879.61 63,000.00 55,000.00 -12.7% TOTAL CONTRACTUAL SERVICES 421,671.33 526,500.00 526,500.00 436,963.74 502,000.00 567,200.00 7.7% 54 COMMODITIES 106010 5410 MISC SUPP 168.00 106010 5420 PETR PROD 1,439.91 106010 5450 OFF SUPP 8,728.73 106010 5460 OPER SUPP 32,882.32 16,963.72 SERVER BACKUP TAPES - $2000 - RK0910 106010 5470 R&M SUPP 516.98 TOTAL COMMODITIES 1,500.00 2,500.00 10,000.00 37,000.00 2,000.00 43,735.94 53,000.00 55 UTILITIES -------------------------------------------- 106010 5550 U/E TELECM 18,191.40 35,000.00 1,500.00 25.00 1,500.00 1,500.00 .016 2,500.00 945.23 2,500.00 2,500.00 .016 10,000.00 5,628.68 7,500.00 10,000.00 .0% 37,000.00 16,963.72 18,500.00 37,000.00 .0% 2,000.00 48.94 2,000.00 2,000.00 .016 53,000.00 23,611.57 32,000.00 53,000.00 .0% 35,000.00 13,287.63 22,000.00 30,000.00 -14.3% 03/27/2009 17:02 OF DEERFIELD 25 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE TOTAL UTILITIES 18,191.40 35,000.00 35,000.00 13,287.63 22,000.00 30,000.00 -14.3% 58 CAPITAL OUTLAY -------------------------------------------- 106010 5810 OP EQP 1,233.05 8,800.00 8,800.00 1,463.77 8,800.00 8,800.00 .0% TOTAL CAPITAL OUTLAY 1,233.05 8,800.00 8,800.00 1,463.77 8,800.00 8,800.00 .016 72 TRANSFERS OUT (IFT) -------------------------------------------- 106010 7211 TRANS VERF 171,572.00 166,235.00 166,235.00 152,382.08 166,235.00 148,966.00 -10.4% TOTAL TRANSFERS OUT (IFT) 171,572.00 166,235.00 166,235.00 152,382.08 166,235.00 148,966.00 -10.4% TOTAL POLICE DEPT ADMINISTRA 1,943,965.09 2,266,199.00 2,266,199.00 2,071,882.52 2,248,535.00 1,647,612.00 -27.31 03/27/2009 17:02 VILLAGE OF DEERFIELD PT SALARY PG 26 rfialkow (EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 106020 POLICE DEPT COMMUNICATIONS 5130 APPAREL -------------------------------------------- 51 PERSONNEL SERVICES 106020 5140 -------------------------------------- 106020 5110 - - - - -- REG SALAR 496,204.24 _ 533,367.00 533,367.00 469,805.15 518,000.00 549,370.00 3.0% 106020 5111 PT SALARY 33,485.45 106020 5112 OT SALARY 22,027.56 106020 5120 MED BNFT 69,549.60 106020 5121 DNTL BNFT 4,711.40 106020 5122 MISC BNFT 3,081.06 106020 5130 APPAREL 2,479.44 106020 5140 PEN CNTRB 99,274.56 TOTAL PERSONNEL SERVICES 730,813.31 52 I TRAINING & DEVELOPME 2,800.00 ----=--------------------------------------- 106020 5211 TRNG TRAV 973.87 106020 5212 TRNG EXP 1,445.00 106020 5213 SUBSCRIPT 173.77 TOTAL TRAINING & DEVELOPME 2,592.64 53 CONTRACTUAL SERVICES 2,500.00 -------------------------------------------- 106020 5330 DUES 208.00 TOTAL CONTRACTUAL SERVICES 208.00 54 COMMODITIES 300.00 300.00 -------------------------------------------- 106020 5460 OPER SUPP .00 TOTAL COMMODITIES .0% .00 58 CAPITAL OUTLAY 500.00 -------------------------------------------- 106020 5810 OP EQP 2,278.89 40,000.00 40,000.00 31,212.21 40,000.00 40,000.00 .0% 37,500.00 37,500.00 24,853.85 37,500.00 37,500.00 .016 85,500.00 85,500.00 73,209.57 85,500.00 90,630.00 6.0% 8,500.00 8,500.00 4,546.96 8,500.00 8,500.00 .0% 8,000.00 8,000.00 3,635.35 8,000.00 8,000.00 .0% 2,800.00 2,800.00 1,451.61 2,800.00 2,800.00 .0% 104,328.00 104,328.00 98,727.29 105,000.00 126,500.00 21.3% 819,995.00 819,995.00 707,441.99 805,300.00 863,300.00 5.3% 2,500.00 2,500.00 1,342.49 2,500.00 2,500.00 .0% 2,800.00 2,800.00 1,173.00 2,800.00 2,800.00 .0% 300.00 300.00 138.90 300.00 300.00 .0% 5,600.00 5,600.00 2,654.39 5,600.00 5,600.00 .0% 500.00 500.00 212.00 500.00 500.00 .0% 500.00 500.00 212.00 500.00 500.00 .0% .00 .00 279.50 .00 .00 .0% .00 .00 279.50 .00 .00 .0% 5,000.00 5,000.00 378.49 5,000.00 5,000.00 .0% 03/27/2009 17:02 VILLAGE OF DEERFIELD IPG 27 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------ - - - - -- TOTAL CAPITAL OUTLAY TOTAL POLICE DEPT COMMUNICAT E 2,278.89 5,000.00 5,000.00 378.49 5,000.00 5,000.00 .0% 735,892.84 831,095.00 831,095.00 710,966.37 816,400.00 874,400.00 5.2% 03/27/2009 17:02 OF DEERFIELD 28 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL ------------------------------------------------------------------------------------------------------------------------------------ FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 106033 POLICE DEPT INVESTIGATIONS -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 106033 5110 REG SALAR 611,027.12 594,707.00 594,707.00 557,340.69 594,707.00 648,367.00 9.0% PURPOSE: Regular Salaries for Full time employees. Includes allowance for merit and COLA DESCRIPTION: Salaries for one Investigations Supervisor, one Investigator, two Youth Officers, one DARE officer, two Social Workers 106033 5112 OT SALARY 46,951.71 25,000.00 25,000.00 48,331.03 35,000.00 30,000.00 20.0°% Includes $3,041 in anticipated retro payout 106033 5120 MED BNFT 84,425.44 112,000.00 112,000.00 83,074.92 101,000.00 118,720.00 6.0% 106033 5121 DNTL BNFT 5,492.51 10,000.00 10,000.00 5,036.45 6,500.00 8,000.00 -20.0% 106033 5122 MISC BNFT 1,027.35 5,000.00 5,000.00 908.47 2,500.00 5,000.00 .0% 106033 5130 APPAREL 6,020.78 6,500.00 6,500.00 3,981.22 6,500.00 6,500.00 .0% 106033 5140 PEN CNTRB 30,118.98 35,000.00 35,000.00 28,841.71 31,000.00 194,700.00 456.3% IMRF - 35,000; POLICE PENSION 142,000 TOTAL PERSONNEL SERVICES 785,063.89 788,207.00 788,207.00 727,514.49 777,207.00 1,011,287.00 28.3°% 52 TRAINING & DEVELOPME -------------------------------------------- 106033 5211 TRNG TRAV 483.17 1,200.00 1,200.00 1,013.61 1,200.00 1,200.00 .0% 106033 5212 TRNG EXP 670.00 5,000.00 5,000.00 1,264.00 5,000.00 5,000.00 .0% 106033 5213 SUBSCRIPT 555.66 750.00 750.00 457.00 750.00 750.00 .0% TOTAL TRAINING & DEVELOPME 1,708.83 6,950.00 6,950.00 2,734.61 6,950.00 6,950.00 .016 53 CONTRACTUAL SERVICES -------------------------------------------- 106033 5326 VEH MAINT 5,218.87 5,000.00 5,000.00 4,429.98 5,000.00 6,000.00 20.0% 106033 5330 DUES 556.00 1,200.00 1,200.00 320.00 1,200.00 1,000.00 -16.7% TOTAL CONTRACTUAL SERVICES 5,774.87 6,200.00 6,200.00 4,749.98 6,200.00 7,000.00 12.9% 54 COMMODITIES -------------------------------------------- 106033 5415 DARE PROG 7,496.59 10,960.00 10,960.00 4,751.79 10,960.00 10,960.00 .0% PURPOSE: DARE Account 106033 5420 PETR PROD 3,847.41 5,000.00 5,000.00 3,291.75 5,000.00 5,000.00 .0% TOTAL COMMODITIES 11,344.00 15,960.00 15,960.00 8,043.54 15,960.00 15,960.00 .0% 58 CAPITAL OUTLAY -------------------------------------------- 106033 5810 OP EQP 3,870.90 9,750.00 9,750.00 3,611.96 9,750.00 5,000.00 -48.7% PURPOSE: Purchase of equipment for Investigations 03/27/2009 17:02 VILLAGE OF DEERFIELD PG 29 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE TOTAL CAPITAL OUTLAY 3,870.90 9,750.00 9,750.00 3,611.96 9,750.00 5,000.00 -48.7% TOTAL POLICE DEPT INVESTIGAT 807,762.49 827,067.00 827,067.00 746,654.58 816,067.00 1,046,197.00 26.5% 03/27/2009 17:02 OF DEERFIELD 30 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL ------------------------------------------------------------------------------------------------------------------------------------ FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 106034 POLICE DEPT PATROL -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 106034 5110 REG SALAR 2,546,062.21 2,725,089.00 2,725,089.00 2,289,193.75 2,550,000.00 2,990,228.00 9.7% PURPOSE: Regular salaries for full time employees. Includes allowance for merit and COLA DESCRIPTION: Salaries for 1 Deputy Chief, 8 Supervisors 23 Patrol Officers, including merit and Career Development for qualified personnel 106034 5111 PT SALARY 65,414.92 73,400.00 73,400.00 64,774.30 73,400.00 75,602.00 3.0% 106034 5112 OT SALARY 133,133.89 140,000.00 140,000.00 131,490.19 140,000.00 145,000.00 3.6% 106034 5120 MED BNFT 418,051.00 451,500.00 451,500.00 396,315.38 451,500.00 481,500.00 6.6% 106034 5121 DNTL BNFT 26,481.30 35,000.00 35,000.00 23,767.49 29,000.00 35,000.00 .0% 106034 5122 MISC BNFT 5,911.54 11,000.00 11,000.00 4,549.20 11,000.00 11,000.00 .0% 106034 5130 APPAREL 28,263.74 41,000.00 41,000.00 17,733.47 25,000.00 41,000.00 .0% 106034 5140 PEN CNTRB 31,878.58 41,000.00 41,000.00 28,441.89 35,000.00 847,500.00 1967.1% IMRF - 41,000; POLICE PENSION - 729,400 TOTAL PERSONNEL SERVICES 3,255,197.18 3,517,989.00 3,517,989.00 2,956,265.67 3,314,900.00 4,626,830.00 31.5% 52 TRAINING & DEVELOPME -------------------------------------------- 106034 5211 TRNG TRAV 2,104.02 6,000.00 6,000.00 3,007.65 6,000.00 6,000.00 .0% 106034 5212 TRNG EXP 14,193.33 30,000.00 30,000.00 13,308.40 25,000.00 30,000.00 .0% 106034 5213 SUBSCRIPT 104.00 900.00 900.00 100.00 900.00 900.00 .0% TOTAL TRAINING & DEVELOPME 16,401.35 36,900.00 36,900.00 16,416.05 31,900.00 36,900.00 .0% 53 CONTRACTUAL SERVICES -------------------------------------------- 106034 5322 EQUP R&M 709.09 .00 .00 51.18 .00 .00 .0% 106034 5326 VEH MAINT 52,557.94 60,000.00 60,000.00 55,093.98 60,000.00 64,600.00 7.7% 106034 5330 DUES 570.00 600.00 600.00 600.00 600.00 1,000.00 66.7% 1 TOTAL CONTRACTUAL SERVICES 53,837.03 60,600.00 60,600.00 55,745.16 60,600.00 65,600.00 8.3% 54 COMMODITIES -------------------------------------------- 106034 5420 PETR PROD 61,894.21 75,000.00 75,000.00 54,015.02 65,000.00 75,000.00 .0% TOTAL COMMODITIES 61,894.21 75,000.00 75,000.00 54,015.02 65,000.00 75,000.00 .0% 55 UTILITIES -------------------------------------------- 106034 5550 U/E TELECM 6,142.40 6,500.00 6,500.00 4,415.59 5,600.00 6,500.00 .0 % 03/27/2009 17:02 OF DEERFIELD 31 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE TOTAL UTILITIES 6,142.40 6,500.00 6,500.00 4,415.59 5,600.00 6,500.00 .0% 58 CAPITAL OUTLAY -------------------------------------------- 106034 5810 OP EQP 11,507.35 19,500.00 19,500.00 9,689.60 17,000.00 25,200.00 29.2% PURPOSE: Purchase of Non -VERF Equipment for Patrol DESCRIPTION: Equipment for Patrol TOTAL CAPITAL OUTLAY 11,507.35 19,500.00 19,500.00 9,689.60 17,000.00 25,200.00 29.2% TOTAL POLICE DEPT PATROL 3,404,979.52 3,716,489.00 3,716,489.00 3,096,547.09 3,495,000.00 4,836,030.00 30.1% 03/27/2009 17:02 (VILLAGE OF DEERFIELD IPG 32 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------ - - - - -- 106061 POLICE DEPT SPEC DETAIL 51 PERSONNEL SERVICES 106061 5112 OT SALARY 163,269.07 292,000.00 292,000.00 144,247.86 200,000.00 200,000.00 -31.5% INCREASE DUE TO ADDITION OF TWO MORE LOCATIONS 106061 5120 MED BNFT 20,915.22 26,750.00 26,750.00 20,640.50 26,750.00 29,425.00 10.0% 106061 5121 DNTL BNFT 1,339.98 2,300.00 2,300.00 1,228.55 2,300.00 2,300.00 .0% 106061 5122 MISC BNFT 246.09 .00 .00 228.11 .00 .00 .0% 106061 5140 PEN CNTRB 2,621.84 4,000.00 4,000.00 2,828.53 4,000.00 4,400.00 10.0% TOTAL PERSONNEL SERVICES 188,392.20 325,050.00 325,050.00 169,173.55 233,050.00 236,125.00 -27.4% TOTAL POLICE DEPT SPEC DETAI 188,392.20 325,050.00 325,050.00 169,173.55 233,050.00 236,125.00 -27.4% TOTAL GENERAL FUND 18,473,294.65 15,918,430.71 15,918,430.71 14,079,103.83 15,983,338.50 18,934,115.50 18.916 03/27/2009 17:02 OF DEERFIELD 33 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT MOTOR FUEL TAX FUND ACTUAL ------------------------------------------------------------------------------------------------------------------------------------ ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 142050 MOTOR FUEL TAX EXPENDITURES -------------------------------------------- 59 CAPITAL IMPROVEMENTS -------------------------------------------- 142050 5910 STREET IMP 600,000.00 600,000.00 600,000.00 600,000.00 600,000.00 550,000.00 -8.3% APPLY TO STREET REHABILITATION PROGRAM OR OTHER FEDERALLY FUNDED PROGRAM AS MATCH TOTAL CAPITAL IMPROVEMENTS 600,000.00 600,000.00 600,000.00 600,000.00 600,000.00 550,000.00 -8.3% TOTAL MOTOR FUEL TAX EXPENDI 600,000.00 600,000.00 600,000.00 600,000.00 600,000.00 550,000.00 -8.3% TOTAL MOTOR FUEL TAX FUND 600,000.00 600,000.00 600,000.00 600,000.00 600,000.00 550,000.00 -8.3% 03/27/2009 17:02 VILLAGE OF DEERFIELD PG 34 rfialkow (EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT E 911 FUND ACTUAL ------------------------------------------------------------------------------------------------------------------------------------ ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 176020 E911 FUND EXPENDITURES -------------------------------------------- 53 CONTRACTUAL SERVICES -------------------------------------------- 176020 5322 EQUP R&M 864.00 .00 .00 .00 .00 .00 .0% 176020 5323 RADIO R&M 25,336.22 55,000.00 55,000.00 45,423.90 55,000.00 75,000.00 36.4% includes Maint. Agreements 176020 5370 DP SERV 43,334.00 65,545.00 65,545.00 61,788.50 65,545.00 65,000.00 -.8% TOTAL CONTRACTUAL SERVICES 69,534.22 120,545.00 120,545.00 107,212.40 120,545.00 140,000.00 16.1% 55 UTILITIES -------------------------------------------- 176020 5550 U/E TELECM 61,806.61 75,000.00 75,000.00 56,679.25 75,000.00 70,000.00 -6.7% TOTAL UTILITIES 61,806.61 75,000.00 75,000.00 56,679.25 75,000.00 70,000.00 -6.7% 58 CAPITAL OUTLAY -------------------------------------------- 176020 5810 OP EQP 472.11 .00 .00 .00 .00 .00 .0% 176020 5820 RAD EQP 12,099.20 23,800.00 23,800.00 344.41 23,800.00 128,000.00 437.8% PURPOSE: Purchase Equip. for 911 Center DESCRIPTION: Computers, monitors, servers, software and other equipment needed for the 911 center. Vendors include Futuretek, CML, United Radio and other related vendors TOTAL CAPITAL OUTLAY 12,571.31 23,800.00 23,800.00 344.41 23,800.00 128,000.00 437.8% 72 'i TRANSFERS OUT (IFT) ---- - --------------------------------------- 176020 7211 TRANS VERF 48,600.00 51,267.00 51,267.00 46,994.75 51,267.00 69,398.00 35.41; PURPOSE: Annual costs associated with major equipment items or vehicles - transfer to VERF TOTAL TRANSFERS OUT (IFT) 48,600.00 51,267.00 51,267.00 46,994.75 51,267.00 69,398.00 35.4% TOTAL E911 FUND EXPENDITURES 192,512.14 270,612.00 270,612.00 211,230.81 270,612.00 407,398.00 50.5% TOTAL E 911 FUND 192,512.14 270,612.00 270,612.00 211,230.81 270,612.00 407,398.00 50.5% 03/27/2009 17:02 VILLAGE OF DEERFIELD PG 35 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 Ibgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT VEHICLE & EQUIPMENT REPLACE. ACTUAL ORIG BUD ------------------------------------------------------------------------------------------------------------------------------------ REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 211150 VERF EXPENSES ----7--------------------------------------- 56 OTHER EXPENSES ----7--------------------------------------- 211150 5670 DEPR EXP 218,137.50 .00 .00 .00 .00 .00 .01 TOTAL OTHER EXPENSES 218,137.50 .00 .00 .00 .00 .00 .0% 58 CAPITAL OUTLAY -------------------------------------------- 211150 5810 OP EQP 29,835.21 142,000.00 142,000.00 119,975.00 142,000.00 .00 - 100.0% 211150 5820 RAD EQP .00 105,000.00 105,000.00 .00 .00 142,500.00 35.7% MOBILE RADIOS, POLICE - $70,000 MOBILE DATA TERMINALS, POLICE - 57,500 CAD SERVER - 15,000 211150 5850 MBL EQP 9,992.00 .00 .00 .00 .00 84,600.00 .0% SALT SPREADER - #806 - $32,300 LEAF VACUUM BOX - 52,300 211150 5860 MOTOR VEH 27,973.70 1,074,700.00 1,074,700.00 327,259.51 447,000.00 712,900.00 -33.7% POLICE SQUADS (10) - 280,000 POLICE VEHS. (2) -- 50,000 PW 703 - 3/4 TON PU 4x4, WRF - 44,300 PW 708 - 3/4 TON PU ST - 44,300 PW 804 - HEAVY DUMP TRUCK, STREET - 134,400 PW 806 - HEAVY DUMP TRUCK, STREET - 159,900 TOTAL CAPITAL OUTLAY 67,800.91 1,321,700.00 1,321,700.00 447,234.51 589,000.00 940,000.00 -28.9% TOTAL VERF EXPENSES 285,938.41 1,321,700.00 1,321,700.00 447,234.51 589,000.00 940,000.00 -28.9% TOTAL VEHICLE & EQUIPMENT RE 285,938.41 1,321,700.00 1,321,700.00 447,234.51 589,000.00 940,000.00 -28.9% 03/27/2009 17:02 VILLAGE OF DEERFIELD rfialkow (EXPENDITURE BUDGET FISCAL YEAR 2009/10 PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION PG 36 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT INFRASTRUCTURE REPLACEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ---------------------------------------------------------------------------------------------------------------- -------------- - - - - -- 222082 INFRA REPLACE FUND EXPENDITURE -------------------------------------------- 53 CONTRACTUAL SERVICES -------------------------------------------- 222082 5362 P/S ENG 257,494.28 1,683,000.00 1,683,000.00 Hazel Avenue and Wilmot Road Bridge (PH 3) - 67,000 67,000= >13,400 IRF + 53,600 FED Hazel Avenue (West) Rehabilitation (PH3) - IN -HOUSE Central Ave and Juniper Ct Bridge (PH1 &2) - 125,000 Deerfield Rd. Safety Sidewalk (PH2 +ROW Acq) - 60,000 60,000= >12,000 IRF + 48,000 FED Deerfield Rd. Safety Sidewalk (PH3) - IN -HOUSE Lake Cook Road Sidewalk Completion (N.Side) (PH3) - 5,000 Lake Cook at Chestnut Traffic Signal (PH2) - 13,000 Street Rehabilitation Project (PH2 +3) - IN -HOUSE Lake Cook Road Utility Replacement via CCHD (PH2 +3) - 70,000 Wilmot Road South (Lake Cook Road to Dfld) (PH3) - 125,000 125,000= >75,000 IRF + 50,000 FED Inflow& Infiltration Investigations - 100,000 Waukegan Road Safety Improvement Study (PH1) - 100,000 Green Streets Engineering - 50,000 WRF Design Plant Improvement (PH2) - 1,100,000 East Side Lift Station (PH3) - 148,000 Deerbrook Lift Station (PH3) - 10,000 + IN -HOUSE Wilmot Road Sta. Piping Modifications (PH3) - 5,000 Deerfield Rd. Pedestrian Underpass (PH1 +2) - 75,000 75,000= >15,000 IRF + 60,000 FED GRANT FUNDING TO MATCH ABOVE (as shown) = $211,600 TOTAL CONTRACTUAL SERVICES 257,494.28 1,683,000.00 1,683,000.00 726,719.65 1,145,000.00 2,053,O00.00 22.016 726,719.65 1,145,000.00 2,053,000.00 22.016 59 I CAPITAL IMPROVEMENTS ----7--------------------------------------- 222082 5910 STREET IMP 2,039,970.47 4,360,000.00 4,360,000.00 3,548,597.93 3,176,000.00 3,050,000.00 -30.0% Hazel Avenue and Wilmot Road Bridge (PH 3) - 650,000 = >130,000 IRF + 520,000 FED Street Rehabilitation Project (PH3) - 350,000 Wilmot Road South (Lake Cook Road to Dfld) (PH3) - 2,500,000 2,500,000 = >950k IRF + 1,OOOk FED + 550k MFT GRANT FUNDING TO MATCH ABOVE (as shown) = $1,570,000 Green Streets Project - 100,000 (50/50 Fed /Local) 03/27/2009 17:02 VILLAGE OF DEERFIELD IPG 37 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT INFRASTRUCTURE REPLACEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 222082 5911 SDWLK IMP .00 350,000.00 350,000.00 .00 .00 440,000.00 25.70 Deerfield Rd. Safety Sidewalk+ ROW (PH3) - 350,000 +40,000 350,000= >70,000 IRF + 280,000 FED 40,000= >8,000 IRF + 32,000 FED Lake Cook Road Sidewalk Completion (N.Side) (PH3) - 50,000 50,000= >25,000 IRF + 25,000 CCHD GRANT FUNDING TO MATCH ABOVE (as shown) = $337,000 222082 5990 OTHER CAP .00 3,090,000.00 3,090,000.00 3,801,326.20 1,942,000.00 3,568,000.00 15.50 Sewer Lining - 250,000 Lake Cook Rd Utility Replacement via CCHD (PH3) - 1,200,000 WATER MAIN 1,100,000 IRF SANITARY MH AND LINING 100,000 IRF Inflow& Infiltration Related Improvements - 100,000 WRF- Replace Grinder Packs- Raw Sewage Influent Lines- 25,000 WRF- Sludge Handling Building Pump Replacement (2) - 25,000 WRF- Sludge Wasting Pumps(2), rails and check valves - 30,000 WRF -Motor Control Center Preventive Maintenance - 35,000 East Side Lift Station (PH3) - 1,300,000 Deerbrook Lift Station (PH3) - 425,000 Warwick Road Station Fence Replacement - 8,000 Wilmot Road Sta.Piping Modifications (PH3) - 80,000 Wilmot Road Station Pump Rails (4 sets) & 2 -12" check valves - 50,000 Pump wet well controllers - 40,000 GRANT FUNDING TO MATCH ABOVE (as shown) =$0 TOTAL CAPITAL IMPROVEMENTS 2,039,970.47 7,800,000.00 7,800,000.00 7,349,924.13 5,118,000.00 7,058,000.00 -9.5% TOTAL INFRA REPLACE FUND EXP 2,297,464.75 9,483,000.00 9,483,000.00 8,076,643.78 6,263,000.00 9,111,000.00 -3.9% TOTAL INFRASTRUCTURE REPLACE 2,297,464.75 9,483,000.00 9,483,000.00 8,076,643.78 6,263,000.00 9,111,000.00 -3.9% 03/27/2009 17:02 (VILLAGE OF DEERFIELD IPG 38 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT BOND PROCEEDS FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------ ------------------ - - - - -- 237071 2008 BOND ISSUE -------------------------------------------- 72 TRANSFERS OUT (IFT) -------------------------- ------ - - -- - - -- 237071 7210 TRNSFR OUT TOTAL TRANSFERS OUT (IFT) TOTAL 2008 BOND ISSUE TOTAL BOND PROCEEDS FUND .00 .00 .00 3,312,407.03 .00 .00 .0% .00 .00 .00 3,312,407.03 .00 .00 .0% .00 .00 .00 3,312,407.03 .00 .00 .0% .00 .00 .00 3,312,407.03 .00 .00 .0% 03/27/2009 17:02 VILLAGE OF DEERFIELD 39 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT VILLAGE CENTER TIF (TIF 2) ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 261180 TIF 2 EXPENSES -------------------------------------------- 53 CONTRACTUAL SERVICES -------------------------------------------- 261180 5365 P/S OTHER 15,250.76 25,000.00 25,000.00 .00 .00 1,000.00 -96.0% 261180 5390 OTHER 12,983.31 .00 .00 .00 .00 .00 .0% TOTAL CONTRACTUAL SERVICES 28,234.07 25,000.00 25,000.00 .00 .00 1,000.00 -96.0% 56 I OTHER EXPENSES -------------------------------------------- 261180 5610 OTH EXPENS .00 .00 .00 .00 .00 4,500,000.00 .0% SURPLUS DISTRIBUTION PURSUANT TO STATE STATUTE TOTAL OTHER EXPENSES .00 .00 .00 .00 .00 4,500,000.00 .0% 59 CAPITAL IMPROVEMENTS -------------------------------------------- 261180 5910 STREET IMP 2,750.00 .00 .00 .00 .00 .00 .0% 261180 5914 STRSCP IMP 1,140.00 .00 .00 .00 .00 .00 .0% 261180 5950 BLDNG IMP 1,875,396.07 .00 .00 8,965.08 .00 .00 .0% TOTAL CAPITAL IMPROVEMENTS 1,879,286.07 .00 .00 8,965.08 .00 .00 .0% 72 TRANSFERS OUT (IFT) -------------------------------------------- 261180 7210 TRNSFR OUT 2,216,000.00 2,130,000.00 4,130,000.00 4,086,500.00 4,086,500.00 .00 - 100.0% DEBT SERVICE EXPENSES FOR 1998 ISSUE TOTAL TRANSFERS OUT (IFT) 2,216,000.00 2,130,000.00 4,130,000.00 4,086,500.00 4,086,500.00 .00 - 100.0% TOTAL TIF 2 EXPENSES 4,123,520.14 2,155,000.00 4,155,000.00 4,095,465.08 4,086,500.00 4,501,000.00 8.3% TOTAL VILLAGE CENTER TIF (TI 4,123,520.14 2,155,000.00 4,155,000.00 4,095,465.08 4,086,500.00 4,501,000.00 8.3% I 03/27/2009 17:02 IVILLAGE OF DEERFIELD JPG 40 rfialkow 1EXPENDITURE BUDGET FISCAL YEAR 2009/10 lbgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT DEBT,SERVICE FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 357071 DEBT SERVICE 2008 EXP -------------------------------------------- 57- -DEBT -- SERVICE.___ -------------------------------------- 357071 5710 - D/S INTER - - - -- .00 400,000.00 400,000.00 64,383.33 - 64,383.00 - -- - 193,150.00 - -51.7% 357071 5730 D/S PRINC .00 .00 .00 .00 .00 175,000.00 .0% 357071 5760 D/S FA.FEE .00 40,000.00 40,000.00 36,438.25 35,000.00 2,000.00 -95.0% TOTAL DEBT SERVICE .00 440,000.00 440,000.00 100,821.58 99,383.00 370,150.00 -15.9% TOTAL DEBT SERVICE 2008 EXP .00 440,000.00 440,000.00 100,821.58 99,383.00 370,150.00 -15.9% 03/27/2009 17:02 (VILLAGE OF DEERFIELD IPG 41 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT DEBT SERVICE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------ - - - - -- 357072 DEBT SERVICE 1998 EXP ------------------------------ 57 DEBT SERVICE 357072 5710 D/S INTER 216,000.00 TIF 2 DEBT RETIRED IN FY 2008/09 357072 5730 D/S PRINC 2,000,000.00 357072 5760 D/S FA FEE 600.00 TOTAL DEBT SERVICE 2,216,600.00 TOTAL DEBT SERVICE 1998 EXP 2,216,600.00 TOTAL DEBT SERVICE FUND 2,216,600.00 130,000.00 130,000.00 2,000,000.00 4,000,000.00 1,000.00 1,000.00 2,131,000.00 4,131,000.00 2,131,000.00 4,131,000.00 2,571,000.00 4,571,000.00 86,500.00 130,000.00 4,000,000.00 4,000,000.00 300.00 1,000.00 4,086,800.00 4,131,000.00 4,086,800.00 4,131,000.00 4,187,621.58 4,230,383.00 .00 - 100.0% .00 - 100.0% .00 - 100.0% .00 - 100.016 .00 - 100.0% 370,150.00 -91.9% 03/27/2009 17:02 OF DEERFIELD 42 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT WATER FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 502010 WATER DEPARTMENT ADMINISTRATIO -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 502010 5110 REG SALAR 201,799.60 190,000.00 190,000.00 190,662.23 225,000.00 230,000.00 21.1% WATER SUPERVISOR 1 EMPLOYEE 1/3 SUPERINTENDENT OF STREETS AND UTILITIES 1/4 DIRECTOR OF PUBLIC WORKS 1/4 ASST DIR OF PW 1/4 PW & ENGINEERING SECRETARY 1/4 PW SECRETARY II 502010 5111 PT SALARY 1,929.61 5,000.00 51000.00 .00 .00 3,000.00 -40.0% SEASONAL HELP 2 EMPLOYEES IF NEEDED 502010 5112 OT SALARY 772.23 10,000.00 10,000.00 1,184.24 1,500.00 1,500.00 -85.0% SUPERVISOR 8 X 26.1 PERIODS SECRETARY OT (2) X 2 HR / PERIOD X 26.1 PRIODS =104.4 HR 502010 5120 MED BNFT 22,718.26 22,470.00 22,470.00 23,152.08 24,000.00 28,000.00 24.6% 502010 5121 DNTL BNFT 1,398.52 1,400.00 1,400.00 1,465.01 2,000.00 2,100.00 50.0% 502010 5122 MISC BNFT 1,058.33 4,500.00 4,500.00 527.40 1,500.00 1,500.00 -66.7% 8 + 1.3 x 500 = $4500 INC TUITION REDUCE BASED ON HISTORY TO $1500 502010 5130 APPAREL 4,799.01 7,500.00 7,500.00 4,821.47 7,500.00 7,500.00 .0% CLOTHING, JACKETS,BOOTS ($500 x 8+1.3 = $4650) SAFETY APPAREL- $2,800 (300 *8 +1.3 PER PERSON ) INCLUDES VESTS, GLOVES, HARD HATS, GOGGLES, RAINSUITS & BOOTS AND MSA EQUIP TOTAL $7440 ROUND TO $7500 502010 5140 PEN CNTRB 37,849.85 45,000.00 45,000.00 36,101.73 40,000.00 45,000.00 .0% TOTAL PERSONNEL SERVICES 272,325.41 285,870.00 285,870.00 257,914.16 301,500.00 318,600.00 11.4% 52 TRAINING & DEVELOPME -------------------------------------------- 502010 5210 TRNG REG 600.00 4,800.00 4,800.00 734.00 1,500.00 2,000.00 -58.3% $200 X 8 + 2 = $2,000..CDL LISCENSES 502010 5211 TRNG TRAV 623.60 1,400.00 1,400.00 151.83 500.00 1,400.00 .0% $100 X 8 + 2 = $1000 ANNUAL CONF 1/3 SUPERINTENDENT + SUPERVISOR 100 +300 =400 502010 5213 SUBSCRIPT 29.25 200.00 200.00 .00 200.00 200.00 .0% TOTAL TRAINING & DEVELOPME 1,252.85 6,400.00 6,400.00 885.83 2,200.00 3,600.00 -43.8% 53 CONTRACTUAL SERVICES -------------------------------------------- 502010 5320 BLDG R&M 10,546.54 15,000.00 15,000.00 10,422.39 15,000.00 15,000.00 .0% UPKEEP FOR P.W. BUILDINGS - BOILERS & GAS HEATERS 1/3 CLEANING SERVICE - $6200 03/27/2009 17:02 VILLAGE OF DEERFIELD PG 43 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 Ibgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 502010 5322 EQUP R&M 1,134.14 3,500.00 3,500.00 1,836.39 3,500.00 3,500.00 .0% 2 -WAY RADIOS / FUEL METER 1/3 JULIE SERVICE - $900 FAX, PRINTERS, COPY MACHINE, TYPEWRITERS - $1,000 502010 5326 VEH MAINT 3,310.07 3,100.00 3,100.00 5,009.00 4,000.00 4,000.00 29.0% MAINTENANCE ON 603 502010 5330 DUES 888.00 1,300.00 1,300.00 1,433.50 1,000.00 1,000.00 -23.1% AWWA, AND NSWWA MEMBERSHIP FEES $250 NIPSTA MEMBERSHIP = $750 = 1/4 OF $3000 502010 5332 TRAV EXP 477.74 3,600.00 3,600.00 173.75 750.00 750.00 -79.2% SEMINARS, CONVENTIONS, TRAVEL EXPENSES, LICENSES 502010 5335 PRINTING 5,628.55 5,000.00 5,000.00 3,257.90 5,000.00 5,000.00 .0% SHUT OFF NOTIFICATIONS, UTILITY BILLS, DOOR HANGERS 502010 5337 POSTAGE 7,739.85 6,500.00 6,500.00 6,295.85 7,500.00 7,500.00 15.4% 502010 5350 INS GL 80,944.43 101,000.00 101,000.00 91,990.49 97,000.00 121,500.00 20.3% 502010 5362 P/S ENG .00 2,500.00 2,500.00 .00 500.00 2,500.00 .0% 502010 5363 P/S MEDIC 1,057.25 1,400.00 1,400.00 760.00 1,000.00 1,000.00 -28.6% OMEGA $100 PER PERSON PER YEAR X 9 PRE EMPLOYMENT TESTING $500 ( $250 PER PERSON ) 502010 5365 P/S OTHER 1,103.00 1,000.00 1,000.00 444.71 1,000.00 1,000.00 .0% 1/4 OF $2400 FOR WEATHER SERVICE 502010 5370 DP SERV 1,871.23 5,000.00 5,000.00 2,260.00 3,000.00 3,000.00 -40.0% REPLACEMENTS & UPDATES TOTAL CONTRACTUAL SERVICES 114,700.80 148,900.00 148,900.00 123,883.98 139,250.00 165,750.00 11.3% 54 COMMODITIES -------------------------------------------- 502010 5410 MISC SUPP 2,441.76 3,000.00 3,000.00 592.40 1,000.00 3,000.00 .0% SAFETY EQUIPMENT FLASHLIGHTS, BATTERIES 502010 5420 PETR PROD 2,885.75 3,000.00 3,000.00 2,780.58 3,500.00 3,500.00 16.7% 502010 5450 OFF SUPP 2,672.16 2,000.00 2,000.00 1,590.08 2,000.00 2,000.00 .0% COPIER PAPER, PENS, INK, TAPE 502010 5460 OPER SUPP 1,605.47 1,500.00 1,500.00 1,567.92 1,500.00 1,500.00 .0% 502010 5470 R&M SUPP .00 300.00 300.00 .00 300.00 300.00 .0% TOTAL COMMODITIES 9,605.14 9,800.00 9,800.00 6,530.98 8,300.00 10,300.00 5.1% 55 UTILITIES -------------------------------------------- 502010 5540 U/E TELEPH 12,118.75 16,000.00 16,000.00 9,373.12 11,000.00 11,000.00 -31.3% NEXTEL PHONE, ALARMS, TELEMETRY 03/27/2009 17:02 OF DEERFIELD 44 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT WATER FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE TOTAL UTILITIES 12,118.75 16,000.00 16,000.00 9,373.12 11,000.00 11,000.00 -31.3% 56 OTHER EXPENSES 502010 5670 DEPR EXP 340,313.81 .00 .00 .00 .00 .00 .0% TOTAL OTHER EXPENSES 340,313.81 .00 .00 .00 .00 .00 .0% 57 DEBT SERVICE -------------------------------------------- 502010 5710 D/S INTER 73,072.00 67,820.00 67,820.00 67,820.00 67,820.00 57,365.00 -15.4% 502010 5730 D/S PRINC .00 410,000.00 410,000.00 410,000.00 410,000.00 425,000.00 3.7% 502010 5760 D/S FA FEE 400.00 1,000.00 1,000.00 400.00 1,000.00 1,000.00 .0% 502010 5761 D/S ISS EX 26,788.98 .00 .00 .00 .00 .00 .0% TOTAL DEBT SERVICE 100,260.98 478,820.00 478,820.00 478,220.00 478,820.00 483,365.00 .9% 58 CAPITAL OUTLAY -------------------------------------------- 502010 5810 OP EQP .00 1,000.00 1,000.00 .00 .00 1,000.00 .0% Calculators / computer programs (TOTAL CAPITAL OUTLAY .00 1,000.00 1,000.00 .00 .00 1,000.00 .0% 72 1 TRANSFERS OUT (IFT) -------------------------------------------- 502010 7211 TRANS VERF 41,527.00 55,395.00 55,395.00 50,778.75 55,395.00 48,122.00 -13.1% TOTAL TRANSFERS OUT (IFT) 41,527.00 55,395.00 55,395.00 50,778.75 55,395.00 48,122.00 -13.1% TOTAL WATER DEPARTMENT ADMIN 892,104.74 1,002,185.00 1,002,185.00 927,586.82 996,465.00 1,041,737.00 3.9% 03/27/2009 17:02 OF DEERFIELD PG 45 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT WATER FUND ACTUAL ------------------------------------------------------------------------------------------------------------------------------------ ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 502031 WATER DEPT DISTRIBUTION -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 502031 5110 REG SALAR 60,509.63 63,000.00 63,000.00 61,111.23 63,000.00 64,890.00 3.0% ONE EMPLOYEE 502031 5112 OT SALARY 9,038.75 10,000.00 10,000.00 9,595.30 10,000.00 10,300.00 3.0% EMERGENCY CALL BACK WATER CONTROLS HISTORICAL TREND - NOT A REG ' MT. 502031 5120 MED BNFT 15,385.32 18,457.50 18,457.50 14,545.50 18,457.50 19,564.95 6.0% 502031 5121 DNTL BNFT 934.98 1,200.00 1,200.00 825.56 1,200.00 1,200.00 .0% 502031 5122 MISC BNFT 123.85 300.00 300.00 111.72 300.00 300.00 .0% 502031 5140 PEN CNTRB 13,421.63 15,000.00 15,000.00 13,316.48 15,000.00 17,000.00 13.3% TOTAL PERSONNEL SERVICES 99,414.16 107,957.50 107,957.50 99,505.79 107,957.50 113,254.95 4.916 53 CONTRACTUAL SERVICES -------------------------------------------- 502031 5320 BLDG R&M 365.00 10,000.00 10,000.00 2,857.37 10,000.00 10,000.00 .0% MITCHELL PARK PUMP STA MITCHELL PARK RESERVOIR, HAWTHORNE RESERVOIR, NORTH FEED BOOSTER STATION, ELEVATED TANK BUILDING ELEV TANK WELDING $7000 502031 5322 EQUP R&M 15,595.89 15,000.00 15,000.00 12,162.73 15,000.00 10,000.00 -33.3% PUMPS AT ALL RESERVOIRS, FLO -LO DIAGNOSTIC SERVICES PUMP CONTROLS UPGRADE $2,000 CATHODIC PROTECTION FOR ELEVATED TANK $2,500 LIGHT REPLACEMENT ELEVATED TANK $400 CONTINUOUS ALARM STATIONS $5,000 502031 5326 VEH MAINT 4,860.70 6,000.00 6,000.00 2,427.50 6,000.00 6,000.00 .0% MAINTENANCE ON 602 502031 5335 PRINTING .00 350.00 350.00 .00 350.00 350.00 .0% EMERGENCY NOTICES ADVANCE NOTICES D -TALES 502031 5362 P/S ENG 2,755.00 29,000.00 29,000.00 952.50 1,000.00 5,000.00 -82.8% 502031 5365 P/S OTHER 5,440.08 12,000.00 12,000.00 2,880.00 6,000.00 6,000.00 -50.0% CITY OF HIGHLAND PARK BACTERIAL ANALYSIS LEAD AND COPPER CONTENT TESTING TOTAL CONTRACTUAL SERVICES 29,016.67 72,350.00 72,350.00 21,280.10 38,350.00 37,350.00 -48.4% 54 COMMODITIES -------------------------------------------- 502031 5410 MISC SUPP 179.13 600.00 600.00 .00 500.00 500.00 -16.7% BATTERIES, FLASHLIGHTS, NOTEBOOKS, DEHUMIDIFIER AND FURNACE MATERIALS SAFETY EQUIPMENT 03/27/2009 17:02 VILLAGE OF DEERFIELD 95,000.00 11.816 2,300.00 .00 PG 46 rfialkow (EXPENDITURE BUDGET FISCAL YEAR 2009/10 87,300.00 88,297.07 97,300.00 97,300.00 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION .00 140,000.00 225.6% FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 502031 5420 PETR PROD .00 2,000.00 2,000.00 .00 2,000.00 2,000.00 .016 502031 5421 MATERIAL 1,586.76 3,500.00 3,500.00 872.74 1,000.00 3,500.00 .0% grease / hand tools / filters / light bulbs 502031 5422 CHEMICAL .00 500.00 500.00 .00 500.00 500.00 .0% CHLORINE - 502031 5423 BUY WATER 2,235,121.92 2,259,907.00 2,259,907.00 1,631,082.40 1,950,000.00 2,225,000.00 -1.5% ASSUMES A 3% INCREASE IN WATER RATE FROM HIGHLAND PARK ALONG WITH A REDUCTION IN USE DUE TO LOSS OF RIVERWOODS DEMAND 502031 5460 OPER SUPP 550.45 700.00 700.00 551.15 700.00 700.00 .016 CL2 TEST KITS TOTAL COMMODITIES 2,237,438.26 2,267,207.00 2,267,207.00 1,632,506.29 1,954,700.00 2,232,200.00 -1.5% 55 UTILITIES -------------------------------------------- 502031 5510 U/E ELECT 96,264.27 85,000.00 ALL LOCATIONS - WATER PUMPING 502031 5520 U/E NAT GA .00 2,300.00 ALL LOCATIONS TOTAL UTILITIES 96,264.27 87,300.00 58 CAPITAL OUTLAY -------------------------------------------- 502031 5810 OP EQP 902.72 43,000.00 SCADA SYSTEM UP GRADES VFD'S / PUMP'S PUMP REPLACEMENT AND DRIVE (vfd) RICHFIELD 135,000 TOTAL CAPITAL OUTLAY 902.72 43,000.00 59 1 CAPITAL IMPROVEMENTS ----,---------------------------------------- 502031 5921 WTRSUP IMP 99,939.10 .00 TOTAL CAPITAL IMPROVEMENTS 99,939.10 .00 TOTAL WATER DEPT DISTRIBUTIO 2,562,975.18 2,577,814.50 85,000.00 88,297.07 95,000.00 95,000.00 11.816 2,300.00 .00 2,300.00 2,300.00 .0% 87,300.00 88,297.07 97,300.00 97,300.00 11.506 43,000.00 .00 .00 140,000.00 225.6% 43,000.00 .00 .00 140,000.00 225.6°% .00 .00 .00 .00 .0% .00 .00 .00 .00 .0% 2,577,814.50 1,841,589.25 2,198,307.50 2,620,104.95 1.6% 03/27/2009 17:02 VILLAGE OF DEERFIELD 47 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT WATER FUND ACTUAL ------------------------------------------------------------------------------------------------------------------------------------ ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 502050 WATER MAIN MAINTENANCE -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 502050 5110 REG SALAR 235,557.41 213,000.00 213,000.00 230,640.98 213,000.00 219,390.00 3.0% 3 1/2 EMPLOYEES VARIOUS LEVELS 502050 5111 PT SALARY 9,863.52 11,000.00 11,000.00 4,082.63 5,000.00 6,000.00 -45.5% SEASONAL HELP 2 EMPLOYEES x 1.05 502050 5112 OT SALARY 40,972.77 50,000.00 50,000.00 43,717.18 50,000.00 50,000.00 .0% EMERGENCY CALL BACK 502050 5120 MED BNFT 56,378.09 71,020.00 71,020.00 57,283.04 71,020.00 75,281.20 6.0% 502050 5121 DNTL BNFT 3,837.80 5,500.00 5,500.00 3,657.32 5,500.00 5,500.00 .0% 502050 5122 MISC BNFT 531.95 600.00 600.00 514.72 600.00 600.00 .0% 502050 5140 PEN CNTRB 52,145.35 55,640.00 55,640.00 52,719.87 55,640.00 61,204.00 10.0% TOTAL PERSONNEL SERVICES 399,286.89 406,760.00 406,760.00 392,615.74 400,760.00 417,975.20 2.816 53 CONTRACTUAL SERVICES -------------------------------------------- 502050 5310 RENT EQP .00 2,500.00 2,500.00 615.00 700.00 2,500.00 .0% EQUIPMENT RENTAL BORING TOOL, MISC. EQUIPMENT 502050 5321 STRUC R&M .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% PRECAST CONCRETE VAULTS, CONCRETE RINGS, FRAMES AND COVERS 502050 5322 EQUP R&M 6,515.52 10,000.00 10,000.00 3,723.70 5,000.00 7,000.00 -30.0% LOCATOR, GENERATOR, PUMPS 502050 5326 VEH MAINT 17,668.35 30,000.00 30,000.00 13,171.29 30,000.00 30,000.00 .0% MAINTENANCE ON 604,580,803,807 502050 5362 P/S ENG 19,862.21 48,000.00 48,000.00 25,913.36 25,000.00 5,000.00 -89.6% 502050 5365 P/S OTHER 54,307.96 90,000.00 90,000.00 20,685.40 30,000.00 60,000.00 -33.3% MAIN REPAIRS $11,000 LEAK SURVEY $12,000 LANDSCAPER $10,000 VALVE REPAIR $10,000 VALVE EXERCISING $10,000 CONCRETE & ASPHALT REPLACEMENT $7,000 502050 5390 OTHER 49,980.00 50,000.00 50,000.00 .00 .00 .00 - 100.0% SPOIL REMOVAL FROM STORAGE YARD ANNUAL PROGRAM DURATION 10 -15 YEARS = $10,000 EACH TOTAL CONTRACTUAL SERVICES 148,334.04 231,500.00 231,500.00 64,108.75 91,700.00 105,500.00 -54.4% 54 COMMODITIES -------------------------------------------- 502050 5410 MISC SUPP 440.66 2,000.00 2,000.00 796.51 2,000.00 2,000.00 .0% SAW BLADES, MARKING PAINT, LUBRICANTS SAFETY EQUIPMENT 03/27/2009 17:02 OF DEERFIELD 48 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 502050 5420 PETR PROD 9,074.75 7,000.00 7,000.00 8,809.96 12,000.00 12,000.00 71.40 502050 5421 MATERIAL 127,524.06 130,000.00 130,000.00 124,745.78 130,000.00 130,000.00 .036 CONCRETE $9,000, ASPHALT $5,000, FILL SAND $7,000 GRAVEL $6,000, STONE $6,000, FLOWABLE FILL $20,000 5 HYDRANTS AND PIPING $16,000, SLEEVES ( ALL SIZES ) $36,000 LUMBER $5,000, BLACK DIRT $10,000, SEED $10,000, SOD $10,000 502050 5440 SMTLSEQUP 301.37 1,200.00 1,200.00 87.88 500.00 1,200.00 .0% SHOVELS, RAKES, POWER TOOLS, HAND TOOLS TOTAL COMMODITIES 137,340.84 140,200.00 140,200.00 134,440.13 144,500.00 145,200.00 3.6% 58 CAPITAL OUTLAY -------------------------------------------- 502050 5810 OP EQP 5,549.00 7,000.00 7,000.00 1,939.65 7,000.00 7,000.00 .0% 2 DEWATERING PUMPS @ $1500 = $3000 GENERATOR $1500 MISC. $2500 TOTAL CAPITAL OUTLAY 5,549.00 7,000.00 59 CAPITAL IMPROVEMENTS -------------------------------------------- 502050 5920 WTRSYS IMP 1,814,762.25 TOTAL CAPITAL IMPROVEMENTS 1,814,762.25 TOTAL WATER MAIN MAINTENANCE 2,505,273.02 100,000.00 100,000.00 885,460.00 7,000.00 100,000.00 100,000.00 885,460.00 1,939.65 .00 .00 593,104.27 7,000.00 .00 .00 643,960.00 7,000.00 .0% .00 - 100.00 .00 - 100.0% 675,675.20 -23.7% 03/27/2009 17:02 (VILLAGE OF DEERFIELD IPG 49 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 502054 WATER METER MAINTENANCE -------------------------------- 51 PERSONNEL SERVICES 502054 5110 REG SALAR 116,741.22 502054 5111 PT SALARY 3,151.63 502054 5112 OT SALARY 1,203.68 502054 5120 MED BNFT 11,555.66 502054 5121 DNTL BNFT 669.00 502054 5122 MISC BNFT 1,031.13 502054 5140 PEN CNTRB 21,116.01 TOTAL PERSONNEL SERVICES .0% 155,468.33 53 CONTRACTUAL SERVICES 500.00 -------------------------------------------- 502054 5322 EQUP R&M 67.00 502054 5326 VEH MAINT 5,591.13 502054 5332 TRAV EXP .00 502054 5335 PRINTING .00 502054 5365 P/S OTHER 176.82 6,000.00 METER CALIBRATION / ACCURACY TESTING TOTAL CONTRACTUAL SERVICES 5,834.95 54 COMMODITIES .00 300.00 -------------------------------------------- 502054 5410 MISC SUPP 76.19 502054 5420 PETR PROD 3,057.80 502054 5421 MATERIAL 121.46 502054 5440 SMTLSEQUP 14.39 I TOTAL COMMODITIES 10,100.00 3,269.84 58 1 CAPITAL OUTLAY 1,000.00 -------------------------------------------- 502054 5810 OP EQP 99,336.35 3,000.00 PURCHASE OF WATER METERS $200,000 5,000.00 INCREASE IN METER SIZE 1 1/2 AND 2 INCH .00 METERS BEING BOUGHT -66.7% 100.00 COMPUTER SOFTWARE /ORION UPGRADES $2,000 .00 INCREASE FOR WATER METER PRICE INCREASE 10% 113,850.00 113,850.00 95,780.55 113,850.00 117,265.50 3.0% 500.00 500.00 .00 .00 .00 - 100.0% 2,100.00 2,100.00 1,115.56 2,100.00 2,100.00 .0% 18,000.00 18,000.00 10,919.94 15,000.00 18,000.00 .0% 1,500.00 1,500.00 683.02 1,500.00 1,500.00 .0% 500.00 500.00 217.61 500.00 500.00 .0% 25,000.00 25,000.00 18,631.34 19,000.00 25,000.00 .0% 161,450.00 161,450.00 127,348.02 151,950.00 164,365.50 1.8% 1,500.00 1,500.00 65.00 1,500.00 1,500.00 .0% 6,000.00 6,000.00 2,015.05 6,000.00 6,000.00 .0% 300.00 300.00 .00 300.00 300.00 .0% 300.00 300.00 .00 300.00 300.00 .0% 2,000.00 2,000.00 69.70 2,000.00 2,000.00 .0% 10,100.00 10,100.00 2,149.75 10,100.00 10,100.00 .0% 1,000.00 1,000.00 47.79 1,000.00 1,000.00 .0% 3,000.00 3,000.00 3,805.53 5,000.00 5,000.00 66.7% 3,000.00 3,000.00 .00 500.00 1,000.00 -66.7% 100.00 100.00 .00 100.00 100.00 .0% 7,100.00 71100.00 3,853.32 6,600.00 7,100.00 .0% 202,000.00 202,000.00 143,810.79 202,000.00 202,000.00 .0% 03/27/2009 17:02 VILLAGE OF DEERFIELD PG 50 rfialkow (EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------- ----------------- - - - - -- TOTAL CAPITAL OUTLAY 99,336.35 202,000.00 202,000.00 143,810.79 202,000.00 202,000.00 .0% TOTAL WATER METER MAINTENANC 263,909.47 380,650.00 380,650.00 277,161.88 370,650.00 383,565.50 .8% TOTAL WATER FUND 6,224,262.41 4,846,109.50 4,846,109.50 3,639,442.22 4,209,382.50 4,721,082.65 -2.6% 03/27/2009 17:02 OF DEERFIELD 51 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT SEWER FUND ACTUAL ------------------------------------------------------------------------------------------------------------------------------------ ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 542010 SEWER ADMINISTRATION -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 542010 5110 REG SALAR 135,899.31 175,000.00 175,000.00 114,368.04 140,000.00 180,250.00 3.0% 1/2 CREW LEADER 1/3 SUPERINTENDENT OF STREETS AND UTILITIES 1/4 DIRECTOR 1/4 ASST DIR OF PW 1/4 PW & ENGINEERING SECRETARY 1/4 PW SECRETARY II 542010 5111 PT SALARY 1,929.61 7,500.00 7,500.00 .00 2,500.00 2,500.00 -66.7% SEASONAL HELP 2 EMPLOYEES PAST HISTORY 542010 5112 OT SALARY 578.81 3,000.00 3,000.00 1,315.48 3,000.00 3,000.00 .0% 542010 5120 MED BNFT 19,167.88 25,000.00 25,000.00 17,854.72 25,000.00 26,500.00 6.0% 542010 5121 DNTL BNFT 1,172.74 2,000.00 2,000.00 1,151.86 2,000.00 2,000.00 .0% 542010 5122 MISC BNFT 4,194.28 4,000.00 4,000.00 377.20 1,000.00 1,000.00 -75.0% INC TUITION 542010 5130 APPAREL 3,065.31 6,000.00 6,000.00 3,492.96 6,000.00 6,000.00 .0% CLOTHING / BOOTS / JACKETS ($500 ) x 6 + 2 SAFETY APPAREL - ($300 PER PERSON) INCLUDES VESTS, GLOVES, RAINSUITS & BOOTS, GOGGLES, HARD HATS, HAND SANITIZER 542010 5140 PEN CNTRB 24,914.52 30,200.00 30,200.00 21,516.52 25,000.00 30,200.00 .0% TOTAL PERSONNEL SERVICES 190,922.46 252,700.00 252,700.00 160,076.78 204,500.00 251,450.00 -.5% 52 TRAINING & DEVELOPME -------------------------------------------- 542010 5210 TRNG REG 490.00 4,000.00 4,000.00 625.00 2,000.00 2,000.00 -50.0% $200 PER MAN X 6 + 2 = 1600 542010 5211 TRNG TRAV 322.07 1,200.00 1,200.00 806.47 1,200.00 1,200.00 .0% SEMINARS / TRAVEL EXPENSES $100.00 PER MAN 6 +2 =800 ANNUAL CONF 1/3 SUPERINTENDENT + 1 = 400 542010 5213 SUBSCRIPT 29.25 200.00 200.00 .00 200.00 200.00 .0% PUBLICATIONS, MANUALS TOTAL TRAINING & DEVELOPME 841.32 5,400.00 5,400.00 1,431.47 3,400.00 3,400.00 -37.0% 53 CONTRACTUAL SERVICES -------------------------------------------- 542010 5320 BLDG R&M 11,519.78 11,000.00 11,000.00 12,710.22 11,000.00 11,000.00 .0% UPKEEP FOR PW BUILDINGS- DOORS, WINDOWS, PAINTING $3,500 1/4 CLEANING SERVICE - $4,000 $2000 FOR HVAC $1500 \FLOORING 03/27/2009 17:02 OF DEERFIELD 52 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 542010 5322 EQUP R&M 1,848.93 3,500.00 3,500.00 1,778.58 3,500.00 3,500.00 .0% 2 -WAY RADIOS / FUEL METER FAX / PRINTERS / TYPEWRITERS - $1,000 542010 5326 VEH MAINT 2,779.54 5,000.00 5,000.00 3,809.60 5,000.00 5,000.00 .0% MAINTENANCE ON 601 542010 5330 DUES 520.00 1,300.00 1,300.00 715.50 1,000.00 1,000.00 -23.1% MEMBERSHIP FEES AWWA APWA $250 MEMBERSHIP NIPSTA 1/4 OF $3000 = $750 542010 5332 TRAV EXP 733.95 3,200.00 3,200.00 108.70 500.00 1,000.00 -68.8% SEMINARS, CONVENTIONS, TRAVEL EXPENSES 542010 5335 PRINTING 3,534.62 3,000.00 3,000.00 1,617.25 3,000.00 3,000.00 .0% LEGALS FOR BID NOTICES job openings 542010 5337 POSTAGE 4,383.55 4,400.00 4,400.00 3,564.18 4,400.00 4,400.00 .0% 5% INCREASE _ $4400 542010 5350 INS GL 117,621.72 145,000.00 145,000.00 132,192.06 140,000.00 174,500.00 20.3% 542010 5362 PIS ENG .00 4,000.00 4,000.00 .00 .00 .00 - 100.0% 542010 5363 PIS MEDIC 944.25 1,300.00 1,300.00 634.00 1,300.00 1,300.00 .0% DRUG & ALCOHOL TESTING $800 OMEGA $100 PER PERSON x 6 +2 PRE EMPLOYMENT TESTING $500 ( $250 PER PERSON ) 542010 5365 PIS OTHER .00 1,000.00 1,000.00 .00 .00 .00 - 100.0% 542010 5370 DP SERV 1,871.24 4,500.00 4,500.00 2,258.27 4,500.00 3,000.00 -33.3% REPLACEMENTS AND UPDATES NETWORK SUPPORT -$2500 RK0910 TOTAL CONTRACTUAL SERVICES 145,757.58 187,200.00 187,200.00 159,388.36 174,200.00 207,700.00 11.0% 54 COMMODITIES -------------------------------------------- 542010 5410 MISC SUPP 1,504.24 2,500.00 2,500.00 1,204.30 2,500.00 2,500.00 .0% SAFETY EQUIPMENT, FLASHLIGHTS, BATTERIES SCBA / RESPERATORS / SHORING / GENERATOR 542010 5420 PETR PROD 1,273.07 2,000.00 2,000.00 2,272.47 3,000.00 3,000.00 50.0% 542010 5450 OFF SUPP 2,026.31 2,000.00 2,000.00 1,154.87 2,000.00 2,000.00 .0% COPIER PAPER, PENS, INK, TAPE 542010 5460 OPER SUPP 2,180.64 2,000.00 2,000.00 1,818.27 2,000.00 2,000.00 .01 TOTAL COMMODITIES 6,984.26 8,500.00 8,500.00 6,449.91 9,500.00 9,500.00 11.8% 55 UTILITIES -------------------------------------------- 542010 5540 U/E TELEPH 5,044.44 5,000.00 5,000.00 4,011.35 5,000.00 5,000.00 .0% NEXTEL PHONES, ALARMS, TELEMETRY 03/27/2009 17:02 OF DEERFIELD 53 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT SEWER FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE TOTAL UTILITIES 5,044.44 5,000.00 5,000.00 4,011.35 5,000.00 51000.00 .0% 56 OTHER EXPENSES -------------------------------------------- 542010 5670 DEPR EXP 140,597.65 .00 .00 .00 .00 .00 .0% TOTAL OTHER EXPENSES 140,597.65 .00 .00 .00 .00 .00 .0% 58 CAPITAL OUTLAY -------------------------------------------- 542010 5810 OP EQP 1,027.00 6,500.00 6,500.00 4,628.59 6,500.00 2,000.00 -69.21 LOCATORS / CAMERA HEAD / CAMERA ACCESSORIES TOTAL CAPITAL OUTLAY 1,027.00 6,500.00 6,500.00 4,628.59 6,500.00 2,000.00 -69.2% 72 TRANSFERS OUT (IFT) -------------------------------------------- 542010 7211 TRANS VERF 50,929.00 56,105.00 56,105.00 51,429.58 56,105.00 59,313.00 5.7% TOTAL TRANSFERS OUT (IFT) 50,929.00 56,105.00 56,105.00 51,429.58 56,105.00 59,313.00 5.7% TOTAL SEWER ADMINISTRATION 542,103.71 521,405.00 521,405.00 387,416.04 459,205.00 538,363.00 3.3% 03/27/2009 17:02 (VILLAGE OF DEERFIELD IPG 54 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------- ----------------- - - - - -- 542031 SEWER LINE CONSTRUCTION 51 PERSONNEL SERVICES 185,400.00 3.0% -------------------- 542031 5110 - - - - -- --------------- REG SALAR - 178,336.61 180,000.00 5,200.00 1/2 CREW LEADER 5,356.00 3.0% 35,000.00 TWO EMPLOYEES 45,000.00 50,000.00 542031 5111 PT SALARY .00 3,000.00 25.0% SEASONAL HELP (2) 354.81 500.00 542031 5112 OT SALARY 4,742.43 5,200.00 500.00 INCREASE IN OVERTIME DUE TO INFRASTRUCTURE FAILURE 542031 5120 MED BNFT 30,715.87 35,000.00 542031 5121 DNTL BNFT 2,204.69 2,800.00 542031 5122 MISC BNFT 371.98 500.00 542031 5130 APPAREL 405.70 1,500.00 9,000.00 hip boots / rubber boots / concrete gloves / safety vests 542031 5140 PEN CNTRB 33,065.62 36,400.00 TOTAL PERSONNEL SERVICES 249,842.90 264,400.00 53 CONTRACTUAL SERVICES 40,500.00 -55.2% -------------------------------------------- 542031 5310 RENT EQP 3,643.00 2,500.00 50,000.00 EXCAVATING MACHINES FOR USE IN RESTRICTED LOCATIONS .0% TOOLS AND SAWS/ PUMPS, TRENCHERS, HYDRALIC PIPE PUSHERS 542031 5321 STRUC R&M 9,166.50 10,000.00 OUTSIDE CONTRACTORS FOR SEWER REPAIRS EMERGENCY SEWER REPAIR 542031 5322 EQUP R&M 2,978.20 9,000.00 REPAIRING PUMPS AND GENERATORS CRANSHIRE CT & DEERPATH PUMP STATION 542031 5326 VEH MAINT 10,222.22 19,000.00 MAINTENANCE ON 601/705/709/702 542011 ENG 69,586.35 50,000.00 TOTAL CONTRACTUAL SERVICES 95,596.27 90,500.00 54 COMMODITIES -------------------------------------------- 542031 5420 PETR PROD 10,537.33 8,000.00 542031 5421 MATERIAL 49,078.92 50,000.00 PURCHASING PRECAST CONCRETE $7,000 PVC PIPE & MISSION COUPLINGS $12,000 FLOWABLE FILL $5,000 / GRAVEL $2,000 / CONCRETE $5,000 BLACKTOP $5,000 / FRAMES & COVERS $6,000 / BRICKS $3,000 ADJUSTING RINGS $3,000 / WATER PLUG $2,000 180,000.00 167,477.98 180,000.00 185,400.00 3.0% 3,000.00 2,821.50 3,000.00 3,150.00 5.0% 5,200.00 4,695.63 5,200.00 5,356.00 3.0% 35,000.00 34,474.08 45,000.00 50,000.00 42.9% 2,800.00 2,296.00 3,200.00 3,500.00 25.0% 500.00 354.81 500.00 500.00 .0% 1,500.00 .00 500.00 500.00 -66.7% 36,400.00 32,902.83 48,000.00 55,000.00 51.1% 264,400.00 245,022.83 285,400.00 303,406.00 14.8% 2,500.00 639.00 2,500.00 2,500.00 .0% 10,000.00 2,050.00 5,000.00 10,000.00 .0% 9,000.00 1,016.00 2,000.00 9,000.00 .0% 19,000.00 13,737.54 19,000.00 19,000.00 .0% 50,000.00 5,473.69 5,500.00 .00 - 100.0% 90,500.00 22,916.23 34,000.00 40,500.00 -55.2% 8,000.00 10,336.33 14,000.00 14,000.00 75.0% 50,000.00 47,576.82 50,000.00 50,000.00 .0% 03/27/2009 17:02 OF DEERFIELD PG 55 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 542031 5440 SMTLSEQUP 199.02 1,000.00 1,000.00 681.91 1,000.00 1,000.00 .0% HAND TOOLS SUCH AS SHOVELS / PICKS / SCREWDRIVERS 542031 5460 OPER SUPP 805.00 1,200.00 1,200.00 57.52 1,200.00 1,200:00 .0% sewer dye / locating flags / spray paint - TOTAL COMMODITIES 60,620.27 60,200.00 60,200.00 58,652.58 66,200.00 66,200.00 10.0% 58 CAPITAL OUTLAY -------------------------------------------- 542031 5810 OP EQP 184.78 12,000.00 12,000.00 .00 .00 .00 - 100.0% TOTAL CAPITAL OUTLAY 184.78 12,000.00 12,000.00 .00 .00 .00 - 100.0% 59 CAPITAL IMPROVEMENTS -------------------------------------------- 542031 5940 SANSWR IMP 35,497.39 593,000.00 593,000.00 273,882.54 245,000.00 .00 - 100.0% TOTAL CAPITAL IMPROVEMENTS 35,497.39 593,000.00 593,000.00 273,882.54 245,000.00 .00 - 100.0% TOTAL SEWER LINE CONSTRUCTIO 441,741.61 1,020,100.00 1,020,100.00 600,474.18 630,600.00 410,106.00 -59.8% 03/27/2009 17:02 OF DEERFIELD 56 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT SEWER FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 542051 SEWER CLEANING -------7------------------------------------ 51 PERSONNEL SERVICES -------------------------------------------- 542051 5110 REG SALAR 112,926.73 140,000.00 140,000.00 162,152.69 140,000.00 144,200.00 3.0% THREE EMPLOYEES / VARIOUS LEVELS 542051 5111 PT SALARY 544.25 7,800.00 7,800.00 3,868.25 4,000.00 4,000.00 -48.7% SEASONAL HELP 542051 5112 OT SALARY 14,380.50 12,500.00 12,500.00 10,428.53 8,000.00 8,000.00 -36.0% 542051 5120 MED BNFT 20,632.30 34,000.00 34,000.00 34,437.85 26,000.00 28,000.00 -17.6% 542051 5121 DNTL BNFT 1,461.88 2,700.00 2,700.00 2,282.43 2,700.00 2,700.00 .0% 542051 5122 MISC BNFT 249.69 500.00 500.00 338.70 500.00 500.00 .0% 542051 5140 PEN CNTRB 24,017.49 28,000.00 28,000.00 32,862.45 25,000.00 29,000.00 3.6% TOTAL PERSONNEL SERVICES 174,212.84 225,500.00 225,500.00 246,370.90 206,200.00 216,400.00 -4.0% 53 CONTRACTUAL SERVICES -------------------------------------------- 542051 5310 RENT EQP .00 2,000.00 2,000.00 .00 .00 2,000.00 .0% RENTAL OF REMOTE CLEANING EQUIPMENT / EXCAVATORS / SAWS 542051 5322 EQUP R&M 1,427.75 6,000.00 6,000.00 1,747.00 2,000.00 6,000.00 .01 REPAIR ROOT CUTTERS / PURCHASE OF HIGH PRESSURE HOSE / CUTTING BLADES 542051 5326 VEH MAINT 16,558.01 12,000.00 12,000.00 11,061.81 12,000.00 12,000.00 .0% REPAIRING 702 542051 5365 P/S OTHER 3,887.50 10,000.00 10,000.00 4,014.81 10,000.00 10,000.00 .0% CONTRACTING FOR SEWER CLEANING AND TELEVISING BEYOND OUR CAPABILITIES UNION DRAINAGE DISTRICT ASSESSMENT FOR RESERVOIR 29 - $1,000 TOTAL CONTRACTUAL SERVICES 21,873.26 30,000.00 30,000.00 16,823.62 24,000.00 30,000.00 .0% 54 COMMODITIES -------------------------------------------- 542051 5410 MISC SUPP 494.29 2,500.00 2,500.00 1,955.79 2,500.00 2,500.00 .0% WATER JET LEADER HOSE / UTILITY TOOLS SAFETY EQUIPMENT 542051 5420 PETR PROD 1,364.79 2,500.00 2,500.00 1,163.28 2,500.00 2,500.00 .0% 542051 5421 MATERIAL 91118.08 15,000.00 15,000.00 8,695.39 10,000.00 10,000.00 -33.3% AGGREGATE / FLOWABLE FILL / BLACKTOP / $1,000 MISSION COUPLINGS $3,000 / CONCRETE $900 BLACK DIRT $3000 / SEED $1,000 03/27/2009 17:02 (VILLAGE OF DEERFIELD rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION PG 57 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 542051 5440 SMTLSEQUP .00 3,200.00 3,200.00 330.60 1,000.00 11000.00 -68.80 HAND TOOLS / SOCKET SETS / SCREW DRIVERS/ 542051 5460 OPER SUPP .00 4,500.00 4,500.00 .00 2,000.00 2,000.00 -55.6% SEWER DYE, SMOKE BOMBS, REBAR, ROOT CUTTING BLADES CHEMICALS, LUMBER 542051 5470 R&M SUPP .00 6,500.00 6,500.00 392.63 2,500.00 2,500.00 -61.5% WATER JET HOSE / VAC HOSE / WATER PLUG ROOT CUTTERS / SLEEVES / MISC SUPPLIES TOTAL COMMODITIES 10,977.16 34,200.00 34,200.00 12,537.69 20,500.00 20,500.00 -40.1% TOTAL SEWER CLEANING 207,063.26 289,700.00 289,700.00 275,732.21 250,700.00 266,900.00 -7.9% 03/27/2009 17:02 !VILLAGE OF DEERFIELD 58 rfialkow (EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT SEWER FUND ACTUAL ------------------------------------------------------------------------------------------------------------------------------------ ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 542052 WASTEWATER TREATMENT FACILITY -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------- 542052 - - - - -- 5110 REG SALAR 564,727.03 647,000.00 647,000.00 543,206.77 647,000.00 666,410.00 l 3.0% SUPERINTENDENT OF WRF 1/4 DIRECTOR, 1/4 ASSISTANT DIRECTOR 1/4 PW & ENGINEERING SECRETARY 1/4 PW SECRETARY II SENIOR OPERATOR, TWO OPERATOR 1 MAINTENANCE CHIEF, MAINTENANCE ASST. LAB DIRECTOR ONE CURRENT OPER. TRAINEE 542052 5111 PT SALARY 10,702.88 13,700.00 13,700.00 9,398.13 13,700.00 14,385.00 5.0% Request two part time people in summer and two people for winter break. 542052 5112 OT SALARY 35,370.21 34,500.00 34,500.00 31,988.79 34,500.00 35,535.00 3.0% 542052 5120 MED BNFT 116,440.64 143,380.00 143,380.00 110,459.99 143,380.00 151,982.80 6.0% 542052 5121 DNTL BNFT 7,321.79 10,500.00 10,500.00 7,083.64 9,500.00 9,500.00 -9.56 542052 5122 MISC BNFT 14,186.23 4,500.00 4,500.00 1,267.16 4,500.00 2,400.00 -46.7% 300 X 8 = $2,400. 542052 5130 APPAREL 5,962.40 8,000.00 8,000.00 3,858.03 5,500.00 7,000.00 -12.56 APPAREL CLOTHING, BOOTS, JACKETS $500.00 PERSON $4,000. TOTAL. SAFETY APPAREL $3,000. INCLUDES VESTS, GLOVES, HARD HATS, GOGGLES, RAIN SUITS AND FIREMEN'S BOOTS. 542052 5140 PEN CNTRB 109,622.20 105,000.00 105,000.00 109,613.35 115,000.00 125,000.00 19.0% IMI AL PERSONNEL SERVICES 864,333.38 966,580.00 966,580.00 816,875.86 973,080.00 1,012,212.80 4.70 52 I -------------------------------------------- TRAINING & DEVELOPME 542052 5210 TRNG REG 974.00 5,200.00 5,200.00 2,221.00 2,500.00 4,500.00 -13.5% NATIONAL CONFERENCE REGISTRATION $200 PER EMPLOYEE x 8 + 2 = 2000 TRAINING REGERSTRATION CDL LICENSE $1000. 542052 5211 TRNG TRAV 2,056.39 1,600.00 1,600.00 208.65 11000.00 1,000.00 -37.5% TRAVEL TRAINING & RELATED EXPENSES 8 x $100. = $800 03/27/2009 17:02 VILLAGE OF DEERFIELD PG 59 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 Ibgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT SEWER FUND ACTUAL ------------------------------------------------------------------------------------------------------------------------------------ ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 542052 5213 SUBSCRIPT 29.25 300.00 300.00 .00 100.00 100.00 -66.7% TOTAL TRAINING & DEVELOPME 3,059.64 7,100.00 7,100.00 2,429.65 3,600.00 5,600.00 -21.1% 53 CONTRACTUAL SERVICES -------------------------------------------- 542052 5310 RENT EQP 30.00 20,000.00 20,000.00 787.50 5,000.00 15,000.00 -25.0% CRANE RENTAL EMERGENCY PUMP RENTAL EMERGENCY GENERATOR RENTAL 542052 5320 BLDG R&M 11,030.74 25,000.00 25,000.00 9,464.54 10,000.00 15,000.00 -40.0% CLEANING SERVICE - $1,000 CONTINGENCY REPAIRS 542052 5322 EQUP R&M 73,456.90 100,000.00 100,000.00 51,506.69 75,000.00 75,000.00 -25.0% ELECTRICAL - MECHANICAL REPAIRS PUMP REPAIRS GENERATOR MAINTENANCE 542052 5326 VEH MAINT 6,527.08 9,000.00 9,000.00 3,868.75 9,000.00 8,000.00 -11.1% TRUCK #703, #605, CAR 307, BOBCAT, AIR COMP. 6 INCH TRAILER MOUNTED DIESEL PUMP 542052 5330 DUES 570.00 1,000.00 1,000.00 1,595.95 1,500.00 3,500.00 250.0% WATER ENVIRONMENT FEDERATION DUES APWA $250 NIPSTA MEMBERSHIP $750 IL. ASSOC. W.W. AGENCIES $2,500. 542052 5332 TRAV EXP 350.00 4,400.00 4,400.00 325.51 2,000.00 2,000.00 -54.5% TRAVEL EXP FOR SEMINARS , $150. X 8 = $1,200. 542052 5335 PRINTING 121.97 500.00 500.00 151.88 500.00 500.00 .0% Bids and Reports. KINKO'S (COPYING PLANS) 542052 5362 P/S ENG 34,548.09 65,000.00 65,000.00 59,847.59 65,000.00 65,000.00 .0% LAB WORK, MONITORING WELLS 29A $20,000. N.P.D.E.S. ASSISTANCE $5,000. 542052 5363 P/S MEDIC 1,633.25 5,000.00 5,000.00 665.00 2,000.00 2,000.00 -60.0% DRUG & ALCOHOL TESTING 8 X 200 = 1,600. EMPLOYEE MEDICAL EXAMS 542052 5365 P/S OTHER 3,280.33 84,000.00 84,000.00 83,708.49 84,000.00 75,000.00 -10.7% YEARLY SLUDGE HAULING - $40,000. DIGESTER CLEANING - CONTINGENCY- $35,000. 542052 5370 DP SERV 691.70 3,500.00 3,500.00 .00 3,500.00 3,000.00 -14.3% UPDATES AND REPLACEMENTS PHONE \NETWORK SUPPORT - $2500 - RK0910 TOTAL CONTRACTUAL SERVICES 132,240.06 317,400.00 317,400.00 211,921.90 257,500.00 264,000.00 -16.8% 54 COMMODITIES -------------------------------------------- 542052 5410 MISC SUPP 3,797.10 8,000.00 8,000.00 799.63 5,000.00 5,000.00 -37.5% SAFETY EQUIPMENT 03/27/2009 17:02 OF DEERFIELD 60 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ---- - ------------------------------------------------------------------------------------------------------------------------------- 542052 5420 PETR PROD 10,502.84 14,000.00 14,000.00 7,488.54 11,000.00 11,000.00 -21.4% 542052 5421 MATERIAL 21,359.74 30,000.00 30,000.00 7,708.48 25,000.00 25,000.00 -16.7% SLUDGE SAND, PIPING VALVES, PACKING & GREASE $10,000. GIVEN $15,000. CONTINGENCY - 542052 5422 CHEMICAL 39,081.48 50,000.00 50,000.00 35,472.32 50,000.00 45,000.00 -10.0% SODIUM HYPOCHLORITE - DISINFECTION OF EFFLUENT SODIUM BISULFITE - DECHLORINATION OF EFFLUENT DEGREASER FOR MAINTENANCE GARAGE DIGEST AID FOR GREASE REMOVAL AT LIFT STATIONS & W.R.F. DEODORANT AT W.R.F. AND LIFT STATION WET WELLS CHLORINE TABLETS FOR STORM STATION DISINFECTION 542052 5440 SMTLSEQUP 1,717.02 2,500.00 2,500.00 1,413.05 2,500.00 2,000.00 -20.0% HAND & POWER TOOLS FOR MAINTENANCE GARAGE SLUDGE FORKS, RAKES AND SHOVELS FOR SLUDGE BEDS. MATERIAL FOR FABRICATING VALVE WRENCHES 542052 5450 OFF SUPP 1,329.69 1,000.00 1,000.00 1,124.19 1,000.00 1,000.00 .0% PRINTER INK, BINDERS, COPYING PAPER, PENS, PENCILS MISC, OFFICE SUPPLIES 542052 5460 OPER SUPP 8,257.07 20,000.00 20,000.00 9,268.85 10,000.00 12,000.00 -40.0% LABORATORY SUPPLIES DISTILLED WATER OUTSIDE LABORATORY TESTING, EFFLUENT & SLUDGE PERMIT REQUIREMENTS 542052 5470 R&M SUPP 16,369.11 25,000.00 25,000.00 6,764.64 15,000.00 15,000.00 -40.0% ANTICIPATE MORE REPAIR PARTS PURCHASES TOTAL COMMODITIES 102,414.05 150,500.00 150,500.00 70,039.70 119,500.00 116,000.00 -22.9% 55 UTILITIES -------------------------------------------- 542052 5510 U/E ELECT 211,021.81 220,000.00 220,000.00 185,666.45 200,000.00 200,000.00 -9.1% TREATMENT PLANT AND SATELLITE FACILITIES 542052 5520 U/E NAT GA 42,231.53 50,000.00 50,000.00 33,525.45 50,000.00 50,000.00 .0% INCREASED COST FOR NATURAL GAS 542052 5530 U/E WATER 6,282.40 10,000.00 10,000.00 12,492.61 14,000.00 15,000.00 50.0% 542052 5540 U/E TELEPH 15,590.52 15,000.00 15,000.00 13,818.11 15,000.00 17,000.00 13.3°% NEXTEL, ALARMS & TELEMETRY TOTAL UTILITIES 275,126.26 295,000.00 295,000.00 245,502.62 279,000.00 282,000.00 -4.4% 56 OTHER EXPENSES -------------------------------------------- 542052 5611 PMTS OTHR 16,650.00 65,000.00 65,000.00 27,280.00 30,000.00 50,000.00 -23.1% STATE PERMIT - TREATMENT PLANT DISCHARGE 20K STATE PERMIT - SLUDGE LAND APPLICATION 1K 03/27/2009 17:02 OF DEERFIELD 61 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ FIRE MARSHALL INSPECTION FEE 0.5K TELEMETRY AT RESERVOIR 29A 25K MISC GOVERNMENT FEE 1K INSPECTION FEE FOR DIGESTER BOILERS 0.5K TOTAL OTHER EXPENSES 16,650.00 65,000.00 65,000.00 27,280.00 30,000.00 50,000.00 -23.1% 58 CAPITAL OUTLAY -------------------------------------------- 542052 5810 OP EQP 4,508.83 35,000.00 35,000.00 2,730.80 5,000.00 5,000.00 -85.7% REPLACEMENT EQUIPMENT $2,000. CONTINGENCY $5,000. TOTAL CAPITAL OUTLAY 4,508.83 35,000.00 35,000.00 2,730.80 5,000.00 5,000.00 -85.7% 59 CAPITAL IMPROVEMENTS -------------------------------------------- 542052 5941 STP IMP 133,947.00 242,000.00 242,000.00 212,669.42 220,000.00 .00 - 100.016 TOTAL CAPITAL IMPROVEMENTS 133,947.00 242,000.00 242,000.00 212,669.42 220,000.00 .00 - 100.0% 72 TRANSFERS OUT (IFT) -------------------------------------------- 542052 7211 TRANS VERF 11,867.00 15,901.00 15,901.00 14,575.92 15,901.00 18,477.00 16.2% TOTAL TRANSFERS OUT (IFT) 11,867.00 15,901.00 15,901.00 14,575.92 15,901.00 18,477.00 16.2% TOTAL WASTEWATER TREATMENT F 1,544,146.22 2,094,481.00 2,094,481.00 1,604,025.87 1,903,581.00 1,753,289.80 -16.3% TOTAL SEWER FUND 2,735,054.80 3,925,686.00 3,925,686.00 2,867,648.30 3,244,086.00 2,968,658.80 -24.4% 03/27/2009 17:02 (VILLAGE OF DEERFIELD IPG 62 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT REFUSE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------ - - - - -- 582030 REFUSE COLLECTION ----------------------------- 53 CONTRACTUAL SERVICES 582030 5311 PROP RENT 21,000.00 582030 5337 POSTAGE 1,020.84 582030 5350 INS GL 4,577.53 582030 5390 OTHER 7,382.35 582030 5391 REF COLCT 1,371,655.60 TOTAL CONTRACTUAL SERVICES 1,405,636.32 21,000.00 21,000.00 2,200.00 2,200.00 5,500.00 5,500.00 9,000.00 9,000.00 1,582,411.50 1,582,411.50 1,620,111.50 1,620,111.50 54 COMMODITIES -------------------------------------------- 582030 5410 MISC SUPP 6,083.70 4,000.00 TOTAL COMMODITIES 6,083.70 4,000.00 TOTAL REFUSE COLLECTION 1,411,720.02 1,624,111.50 4,000.00 .00 795.28 4,900.47 7,033.78 1,195,358.61 1,208,088.14 2,705.90 4,000.00 2,705.90 1,624,111.50 1,210,794.04 21,000.00 21,000.00 .0% 2,200.00 2,200.00 .0% 5,500.00 6,600.00 20.0% 9,000.00 9,000.00 .0% 1,450,000.00 1,580,000.00 -.2% 1,487,700.00 1,618,800.00 -.1% 4,000.00 4,000.00 .0% 4,000.00 4,000.00 .0% 1,491,700.00 1,622,800.00 -.1% 03/27/2009 17:02 VILLAGE OF DEERFIELD PG 63 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 Ibgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT REFUSE FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 582053 REFUSE LEAF COLLECTION -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 582053 5110 REG SALAR 30,411.68 40,000.00 40,000.00 20,051.60 21,000.00 30,000.00 -25.0% 582053 5111 PT SALARY 8,120.88 9,000.00 9,000.00 10,977.50 11,000.00 12,000.00 33.316 4 part time hires for 4 weeks @ at least $10 /hr. 582053 5112 OT SALARY 6,705.92 14,500.00 14,500.00 13,939.75 14,000.00 14,500.00 .0% 582053 5120 MED BNFT 8,382.30 15,000.00 15,000.00 6,220.89 7,000.00 15,000.00 .0% 582053 5121 DNTL BNFT 543.60 1,500.00 1,500.00 395.77 1,500.00 1,500.00 .0% 582053 5122 MISC BNFT 78.74 500.00 500.00 59.92 500.00 500.00 .0% 582053 5140 PEN CNTRB 7,377.74 16,000.00 16,000.00 6,996.19 8,000.00 14,000.00 -12.5% TOTAL PERSONNEL SERVICES 61,620.86 96,500.00 96,500.00 58,641.62 63,000.00 87,500.00 -9.3% 53 CONTRACTUAL SERVICES -------------------------------------------- 582053 5310 RENT EQP .00 10,000.00 10,000.00 .00 .00 10,000.00 .0% Rental street sweeper for after last leaf pickup 582053 5322 EQUP R&M 26,202.00 35,000.00 35,000.00 28,060.00 28,000.00 35,000.00 .0% Repairs and maintenance of leaf machines and equipment INC. FRONT END LOADER 582053 5326 VEH MAINT 3,785.25 4,500.00 4,500.00 3,905.00 4,000.00 4,500.00 .0% Repairs and maintence of vehicles used for leaf removal 4 trucks, sweeper TOTAL CONTRACTUAL SERVICES 29,987.25 49,500.00 49,500.00 31,965.00 32,000.00 49,500.00 .0% 54 fi COMMODITIES ----7--------------------------------------- u 5820II3 5420 PETR PROD 5,106.57 6,000.00 6,000.00 7,957.59 8,000.00 8,000.00 33.3% Fuel used for leaf removal 582053 5460 OPER SUPP 979.60 500.00 500.00 1,590.07 1,600.00 1,000.00 100.0% Rakes, shovels, ear plugs, face masks, safety glasses and safety goggles TOTAL COMMODITIES 6,086.17 6,500.00 6,500.00 9,547.66 9,600.00 9,000.00 38.5% 72 TRANSFERS OUT (IFT) -------------------------------------------- 582053 7211 TRANS VERF 10,775.00 17,675.00 17,675.00 16,202.08 17,675.00 11,617.00 -34.3% 03/27/2009 17:02 VILLAGE OF DEERFIELD rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION PG 64 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT REFUSE FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE TOTAL TRANSFERS OUT (IFT) 10,775.00 17,675.00 17,675.00 16,202.08 17,675.00 11,617.00 -34.3% TOTAL REFUSE LEAF COLLECTION 108,469.28 170,175.00 170,175.00 116,356.36 122,275.00 157,617.00 -7.4% TOTAL REFUSE FUND 1,520,189.30 1,794,286.50 1,794,286.50 1,327,150.40 1,613,975.00 1,780,417.00 -.8% 03/27/2009 17:02 VILLAGE OF DEERFIELD 65 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT COMMUTER ------------------------------------------------------------------------------------------------------------------------------------ PARKING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE 602019 -------------------------------------------- COMM PARK COMBINED FUNDING 51 PERSONNEL SERVICES -------------------------------------------- 602019 5110 REG SALAR 9,925.29 12,600.00 12,600.00 9,038.99 12,600.00 12,600.00 .0% 602019 5120 MED BNFT 793.57 2,330.00 2,330.00 1,099.71 2,330.00 2,330.00 .016 602019 5121 DNTL BNFT 78.22 250.00 250.00 73.28 250.00 250.00 .016 602019 5122 MISC BNFT 23.25 100.00 100.00 22.26 100.00 100.00 .0% 602019 5140 PEN CNTRB 1,738.02 2,400.00 2,400.00 1,738.33 2,400.00 2,400.00 .0% I TOTAL PERSONNEL SERVICES 12,558.35 17,680.00 17,680.00 11,972.57 17,680.00 17,680.00 .0% 53 CONTRACTUAL SERVICES -------------------------------------------- 602019 5311 PROP RENT 7,440.00 7,500.00 7,500.00 .00 7,500.00 7,500.00 .0% 602019 5320 BLDG R&M 3,560.92 30,000.00 30,000.00 13,907.43 30,000.00 30,000.00 .016 STAIR REPAIRS / LANDSCAPE IMPROVEMENTS TRAIN STATION MAINT. TRANSFERED TO 102038 -5320 602019 5322 EQUP R&M .00 500.00 500.00 .00 500.00 500.00 .0% 602019 5350 INS GL 2,021.76 2,530.00 2,530.00 2,254.21 2,530.00 3,000.00 18.6% 602019 5390 OTHER .00 25,000.00 25,000.00 .00 25,000.00 25,000.00 SEAL COAT AND STRIPE LOT $10,000 1/3 LANDSCAPING TOTAL= $15,000 TOTAL CONTRACTUAL SERVICES 13,022.68 65,530.00 65,530.00 16,161.64 .65,530.00 66,000.00 .7% 54 COMMODITIES -------------------------------------------- 602019 5410 MISC SUPP .00 200.00 200.00 .00 200.00 200.00 602019 5421 MATERIAL 4,771.04 5,200.00 5,200.00 2,017.50 5,200.00 5,200.00 602019 5460 OPER SUPP .00 300.00 300.00 .00 300.00 300.00 .0% 60209 5470 R&M SUPP .00 100.00 100.00 .00 100.00 100.00 TOTAL COMMODITIES 4,771.04 5,800.00 5,800.00 2,017.50 5,800.00 5,800.00 .016 55 1 UTILITIES -------------------------------------------- 602019 5510 U/E ELECT 2,687.31 3,300.00 3,300.00 2,295.56 3,300.00 3,300.00 .016 TOTAL UTILITIES 2,687.31 3,300.00 3,300.00 2,295.56 3,300.00 3,300.00 .016 58 CAPITAL OUTLAY -------------------------------------------- 602019 5810 OP EQP .00 5,000.00 5,000.00 .00 1,000.00 5,000.00 .0% 03/27/2009 17:02 VILLAGE OF DEERFIELD PG 66 rfialkow (EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT COMMUTER PARKING FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE TOTAL CAPITAL OUTLAY .00 5,000.00 5,000.00 .00 1,000.00 5,000.00 .0% 72 TRANSFERS OUT (IFT) -------------------------------------------- 602019 7210 TRNSFR OUT 65,000.00 80,000.00 80,000.00 .00 80,000.00 80,000.00 .0% TOTAL TRANSFERS OUT (IFT) 65,000.00 80,000.00 80,000.00 .00 80,000.00 80,000.00 .0% TOTAL COMM PARK COMBINED FUN 98,039.38 177,310.00 177,310.00 32,447.27 173,310.00 177,780.00 .316 03/27/2009 17:02 VILLAGE OF DEERFIELD IPG 67 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT COMMUTER PARKING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------ - - - - -- 602038 COMM PARK VILLAGE OWNED -------------------------------- 51 PERSONNEL SERVICES 602038 5110 REG SALAR 9,925.28 602038 5112 OT SALARY .00 602038 5120 MED BNFT 793.57 602038 5121 DNTL BNFT 78.22 602038 5122 MISC BNFT 23.25 602038 5140 PEN CNTRB 1,738.02 TOTAL PERSONNEL SERVICES 100.00 12,558.34 53 CONTRACTUAL SERVICES 2,400.00 -------------------------------------------- 602038 5322 EQUP R&M .00 .0% viaduct and pedestrian bridge maintenance 602038 5350 INS GL 2,021.76 602038 5390 OTHER .00 -33.3% $15,000 LANDSCAPE MAINTENANCE 2,254.21 2,530.00 SEAL COAT AND STRIPE LOT - $10,000 TOTAL CONTRACTUAL SERVICES 2,021.76 54 COMMODITIES 25,000.00 .016 -------------------------------------------- 602038 5421 MATERIAL 240.00 602038 5460 OPER SUPP .00 602038 5470 R&M SUPP .00 TOTAL COMMODITIES 200.00 240.00 55 UTILITIES .0% 200.00 -------------------------------------------- 602038 5510 U/E ELECT 5,710.51 TOTAL UTILITIES 1,400.00 5,710.51 56 OTHER EXPENSES 1,400.00 .0% -------------------------------------------- 602038 5670 DEPR EXP 26,737.44 TOTAL OTHER EXPENSES .0% 26,737.44 58 CAPITAL OUTLAY 6,000.00 -------------------------------------------- 602038 5810 OP EQP .00 12,320.00 12,320.00 9,038.99 12,320.00 12,320.00 .0% 700.00 700.00 .00 700.00 700.00 .0% 2,330.00 2,330.00 1,099.71 2,330.00 2,330.00 .0% 250.00 250.00 73.28 250.00 250.00 .0% 100.00 100.00 22.26 100.00 100.00 .0% 2,400.00 2,400.00 1,738.33 2,400.00 2,400.00 .0% 18,100.00 18,100.00 11,972.57 18,100.00 18,100.00 .0% 15,000.00 15,000.00 2,543.22 5,000.00 10,000.00 -33.3% 2,530.00 2,530.00 2,254.21 2,530.00 3,000.00 18.6% 25,000.00 25,000.00 25,653.23 27,000.00 25,000.00 .016 42,530.00 42,530.00 30,450.66 34,530.00 38,000.00 -10.7% 1,000.00 1,000.00 297.50 1,000.00 1,000.00 .0% 200.00 200.00 .00 200.00 200.00 .0% 200.00 200.00 .00 200.00 200.00 .0% 1,400.00 1,400.00 297.50 1,400.00 1,400.00 .0% 6,000.00 6,000.00 4,546.27 6,000.00 6,000.00 .0% 6,000.00 6,000.00 4,546.27 6,000.00 6,000.00 .0% .00 .00 .00 .00 .00 .0% .00 .00 .00 .00 .00 .0% 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 03/27/2009 17:02 OF DEERFIELD 68 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT COMMUTER PARKING FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE TOTAL CAPITAL OUTLAY .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 72 TRANSFERS OUT (IFT) -------------------------------------------- 602038 7210 TRNSFR OUT 65,000.00 80,000.00 80,000.00 .00 80,000.00 80,000.00 .0% TOTAL TRANSFERS OUT (IFT) 65,000.00 80,000.00 80,000.00 .00 80,000.00 80,000.00 .0% TOTAL COMM PARK VILLAGE OWNE 112,268.05 149,030.00 149,030.00 47,267.00 141,030.00 144,500.00 -3.0% TOTAL COMMUTER PARKING FUND 210,307.43 326,340.00 326,340.00 79,714.27 314,340.00 322,280.00 -1.2% 03/27/2009 17:02 (VILLAGE OF DEERFIELD IPG 69 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GARAGE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------ - - - - -- 702050 GARAGE FUND EXPENDITURES 137,000.00 149,350.00 -------------------------------------------- 51 PERSONNEL SERVICES 24,626.75 30,000.00 -------------------------------------------- 702050 5110 REG SALAR 140,563.55 130,000.00 25,000.00 MECHANIC AND ASST. MECHANIC .0% 2,700.00 702050 5112 OT SALARY 25,027.73 11,000.00 1,000.00 OVER TIME 2 EMPLOYEES 500.00 500.00 702050 5120 MED BNFT 18,128.78 32,550.00 702050 5121 DNTL BNFT 1,536.97 2,700.00 702050 5122 MISC BNFT 393.25 1,000.00 203,470.79 INC TUITION 241,700.00 16.8% 702050 5130 APPAREL 596.68 1,600.00 500 PER EMPLOYEE + 300 PER PERSON FOR SAFETY APPAREL 702050 5140 PEN CNTRB 29,507.41 28,000.00 TOTAL PERSONNEL SERVICES 215,754.37 206,850.00 52 TRAINING & DEVELOPME -------------------------------------------- 702050 5210 TRNG REG 52.09 1,400.00 $200 x 2 - $400 CDL LICENSE ANNUAL CONF 300 702050 5211 TRNG TRAV 50.00 500.00 100 PER EMPLOYEE + ANNUAL CONF 300 TOTAL TRAINING & DEVELOPME 102.09 1,900.00 53 CONTRACTUAL SERVICES ----7--------------------------------------- 702050 5322 EQUP R&M 8,611.41 12,000.00 USED FOR REPAIR OF GARAGE EQUIPMENT AND HEATING PURCHASE OF MATERIAL FOR MECHANICS BAY 702050 5332 TRAV EXP .00 1,600.00 $200 per employee 702050 5335 PRINTING .00 400.00 job sheet forms and business cards 702050 5350 INS GL 8,840.36 11,000.00 TOTAL CONTRACTUAL SERVICES 17,451.77 25,000.00 54 COMMODITIES -------------------------------------------- 702050 5410 MISC SUPP 1,609.89 1,500.00 Paper supplies, first aid supplies, consortium fee, etc. 130,000.00 129,089.38 137,000.00 149,350.00 14.9% 11,000.00 24,626.75 30,000.00 20,000.00 81.8% 32,550.00 17,516.28 25,000.00 32,550.00 .0% 2,700.00 1,384.59 2,700.00 2,700.00 .0% 1,000.00 318.72 500.00 500.00 -50.0% 1,600.00 1,032.03 1,600.00 1,600.00 .0% 28,000.00 29,503.04 29,900.00 35,000.00 25.0% 206,850.00 203,470.79 226,700.00 241,700.00 16.8% 1,400.00 500.00 1,900.00 12,000.00 1,600.00 400.00 11,000.00 25,000.00 1,500.00 290.00 .00 290.00 1,949.22 500.00 500.00 1,000.00 500.00 -64.3% 500.00 .0% 1,000.00 -47.4% 2,000.00 12,000.00 .0% .00 500.00 500.00 -68.8% .00 100.00 100.00 -75.0% 9,800.97 10,000.00 13,250.00 20.5% 11,750.19 12,600.00 25,850.00 3.4% 963.48 1,500.00 1,500.00 .0% 03/27/2009 17:02 OF DEERFIELD 70 rfialkow (VILLAGE EXPENDITURE BUDGET FISCAL YEAR 2009/10 IPG bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT GARAGE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 702050 5420 PETR PROD 718.85 1,000.00 1,000.00 782.18 1,000.00 1,000.00 .0% 702050 5421 MATERIAL 1,568.33 3,000.00 3,000.00 2,151.46 3,000.00 3,000.00 .0% SAFETY GLASSES /WELDING SHIELDS /RESPERATORS /GLOVES 702050 5440 SMTLSEQUP 6,183.13 7,000.00 7,000.00 5,065.15 7,000.00 7,000.00 .0% upgrade diagnostic equipment, specialty tools for new equip + new employee tools 702050 5450 OFF SUPP 38.31 100.00 100.00 72.65 100.00 100.00 .0% 702050 5460 OPER SUPP 348.89 300.00 300.00 153.31 300.00 300.00 .0% 702050 5470 R&M SUPP 75,509.19 100,000.00 100,000.00 102,689.87 132,000.00 100,000.00 .0% TIRES, BATTERIES, PARTS STEEL, PETROLEUM PRODUCTS New variety of equip in fleet TOTAL COMMODITIES 85,976.59 112,900.00 112,900.00 111,878.10 144,900.00 112,900.00 .0% 55 UTILITIES -------------------------------------------- 702050 5530 U/E WATER 2,162.84 2,500.00 2,500.00 2,211.80 2,500.00 2,500.00 .0% 702050 5540 U/E TELEPH 2,196.78 2,200.00 2,200.00 1,799.69 2,200.00 2,200.00 .0% TOTAL UTILITIES 4,359.62 4,700.00 4,700.00 4,011.49 4,700.00 4,700.00 .0% 58 CAPITAL OUTLAY -------------------------------------------- 702050 5810 OP EQP 6,245.00 5,000.00 5,000.00 145.76 5,000.00 5,000.00 .0% TESTING EQUIPMENT TOTAL CAPITAL OUTLAY 6,245.00 5,000.00 5,000.00 145.76 5,000.00 5,000.00 .0% 72 TRANSFERS OUT (IFT) -------------------------------------------- 702050 7211 TRANS VERF 2,525.00 2,525.00 2,525.00 2,314.58 2,525.00 3,150.00 24.8% TOTAL TRANSFERS OUT (IFT) 2,525.00 2,525.00 2,525.00 2,314.58 2,525.00 3,150.00 24.8% TOTAL GARAGE FUND EXPENDITUR 332,414.44 358,875.00 358,875.00 333,860.91 397,425.00 394,300.00 9.916 TOTAL GARAGE FUND 332,414.44 358,875.00 358,875.00 333,860.91 397,425.00 394,300.00 9.9% 03/27/2009 17:02 (VILLAGE OF DEERFIELD PG 71 rfialkow EXPENDITURE BUDGET FISCAL YEAR 2009/10 bgnyrpts PROJECTION: 20101 FY 2009 /10 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2008 2009 2009 2009 2009 2010 PCT POLICE PENSION FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE ------------------------------------------------------------------------------------------------------------------------------ - - - - -- 806010 POLICE PENSION FUND EXPENDITUR 51 a PERSONNEL SERVICES 806010 5141 PEN PYMNT 1,312,162.08 1,561,400.00 1,561,400.00 1,278,800.13 1,505,900.00 1,659,900.00 6.3% 806010 5142 SEP REFND 75,445.90 15,000.00 15,000.00 40,164.88 40,200.00 15,000.00 .0% TOTAL PERSONNEL SERVICES 1,387,607.98 1,576,400.00 1,576,400.00 1,318,965.01 1,546,100.00 1,674,900.00 6.2% 53 CONTRACTUAL SERVICES -------------------------------------------- 806010 5330 DUES 1,062.50 1,500.00 1,500.00 1,150.00 1,500.00 1,500.00 .0% 806010 5332 TRAV EXP 76.15 500.00 500.00 .00 500.00 500.00 .0% 806010 5360 P/S CRP CN 2,755.86 5,000.00 5,000.00 1,500.00 5,000.00 5,000.00 .0% 806010 5365 P/S OTHER 750.00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 806010 5369 TRUST FEES 1,537.55 1,750.00 1,750.00 1,257.50 1,750.00 1,750.00 .0% 806010 5390 OTHER 4,756.73 2,500.00 2,500.00 5,213.96 5,300.00 6,000.00 140.0% TOTAL CONTRACTUAL SERVICES 10,938.79 12,250.00 12,250.00 9,121.46 15,050.00 15,750.00 28.6% TOTAL POLICE PENSION FUND EX 1,398,546.77 1,588,650.00 1,588,650.00 1,328,086.47 1,561,150.00 1,690,650.00 6.4% TOTAL POLICE PENSION FUND 1,398,546.77 1,588,650.00 1,588,650.00 1,328,086.47 1,561,150.00 1,690,650.00 6.4% GRAND TOTAL 40,610,105.24 45,159,689.71 49,159,689.71 44,585,609.19 43,363,192.00 46,691,051.95 -5.0% ** END OF REPORT - Generated by Bob Fialkowski ** 3 -18 -09 Deerfield Public Library GENERAL FUND 2009.2010 Approved Operating Budget REVENUES TAXES PROPERTY TAX 2,756,250 Operating budget only. Appropriations request to follow in Fall. TIF SURPLUS DISTRIBUTION 0 TIF SURPLUS TRANSFER 0 REPLACEMENT TAX 25,000 TOTAL TAXES 2,781,250 FEES & FINES 0 FEES, FINES & PENALTIES 40,000 NON- RESIDENT FEES 10,000 COPYING AND PRINTING 4,000 TOTAL FEES & FINES 54.000 INTEREST EARNINGS 25,000 TOTAL INVESTMENT INCOME 25.000 INTERGOVERNMENTAL 17,885 STATE GRANT (PER CAPITA) 0 OTHER GRANTS 0 TOTAL INTERGOVERNMENTAL 0 MISCELLANEOUS REVENUE AVAILABLE FROM RESERVE 118,750 GIFTS AND CONTRIBUTIONS 8,000 OTHER 100 TOTAL MISCELLANEOUS REVENUE 127.750 TOTAL REVENUES 2.988.000 EXPENDITURES PERSONNEL EXPENSES REGULAR SALARIES 1,488,000 FICA 113,088 HEALTH & MISC. BENEFITS 194,905 PENSION (IMRF) 163,680 TOTAL PERSONNEL SERVICES 1.959.673 BUILDING Interior maintenance and repair 55,000 Equipment maintenance and repair 17,885 Exterior maintenance and repair 10,000 Utilities 30,000 Furnishings and equipment 10,000 Automation upgrade TOTAL BUILDING 122,885 LIBRARY MATERIALS LIBRARY BINDING 0 LIBRARY PERIODICALS 30,000 LIBRARY ADULT REF & NON - FICTION 80,000 LIBRARY ADULT FICTION 46,000 LIBRARY TEEN 8,000 LIBRARY CHILDREN'S BOOKS 60,000 LIBRARY AUDIO VISUAL 85,000 LIBRARY ONLINE SERVICES 60,000 LIBRARY CATALOGING SERVICE 15,000 LIBRARY LOST BOOKS 0 TOTAL LIBRARY MATERIALS 384.000 Page 1 2009 -2010 3 -18 -09 Deerfield Public Library 2009 -2010 GENERAL FUND AUTOMATION Software and Licenses Hardware Support TOTAL AUTOMATION OFFICE LIBRARY SPECIAL PROGRAMS INSURANCE GENERAL LIABILITY POSTAGE PRINTING OFFICE SUPPLIES OTHER EXPENSES PROF SERV /CORPORATE COUNSEL TOTAL OFFICE TRAINING AND DEVELOPMENT TRAINING AND EDUCATION DUES & MEMBERSHIPS TRAVEL TOTAL TRAINING & DEVELOPMENT SUBTOTAL GENERAL EXPENDITURES CAPITAL EXPENDITURES EQUIPMENT STRUCTURE RESERVE FUND MAINTENANCE TOTAL CAPITAL EXPENDITURES TOTAL EXPENDITURES CONTRIBUTION (REDUCTION) - GENERAL FUND BALANCE RESERVE RESERVEINTEREST TOTAL RESERVE TOTALS (Contribution plus Reserve Interest) Jack Hicks - Gifts Transfers Interest TOTAL Jack Hicks Scholarship Fund 2009 -2010 Approved Operating Budget TOTAL TOTAL 103,500 80,442 39,000 222,942 30,000 40,000 8,500 18,000 48,000 2,000 70,000 216,500 21,000 5,000 6,000 32A00 2,938,000 25,000 25,000 0 50,000 2,988,000 0 25,000 25,000 25.000 0 0 150 150 3,013,150 2,988,000 25.150 Page 2