The URL can be used to link to this page

O-05-11.p 0RDINANCE 0-05 -11 VILLAGE OF DEERFIELD LAKE AND COOK COUNTIES, ILLINOIS ADOPTING THE BUDGET OF THE VILLAGE OF DEERFIELD FOR THE FISCAL YEAR BEGINNING MAY 1, 2005 AND ENDING APRIL 30, 2006 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, 2005; and, WHEREAS, the tentative annual budget for the fiscal year beginning May 1, 2005 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; arid, 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, 2005 and ending April 30, 2006. 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, 2005, and ending April 30, 2006. 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 18th day of April , 2005 AYES: Benton, Kayne, Rosenthal, Seiden, Swanson, Wylie (6) NAYS: None (0) ABSENT: None (0) ABSTAIN: None (0) APPROVED this 18th day of ATTEST: Village Clerk 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 15:15:46 REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL ------------------7----------------------------------------------------------------------------------------------------------------- FUND ACTUAL ORIG BUD REVISED•BUD ACTUAL PROJECTION FIN REVIEW CHANGE 100001 GENERAL FUND REVENUE -------------------------------------------- 100001 4110 PROP TAX 363,978.35 1,689,000.00 1,689,000.00 1,231,903.04 1,282,250.00 1,985,000.00 17.5% INCREASE OF $417,750 TO CAPTURE TIF 1 EAV. ADD BACK $285,000 IN LIEU OF TRANSFER FROM MFT. INF REP PROP TAX DECREASES BY A SIMILAR AMOUNT WITH TRANSFER OF FUNDS FROM MFT. EFFECT SHOULD BE A DECREASE IN TAX PAID-TO VILLAGE. 100001 4111 PRTX IMRF 697,078.06 .00 .00 .00 .00 .00 .0% 100001 4112 PRTX ROAD 15,412.15 .00 .00 6,259.15 .00 .00 .0% 100001 4113 PRTX P PEN 266,028.14 .00 .00 .00 .00 .00 .0% 100001 4114 PRTX PR YR .00 .00 .00 00 10,000.00 10,000.00 .0% 100001 4115 TIF SRPLUS 398,386.05 330,000.00 330,000.00 231,433.41 350,000.00 .00'- 100.0% TIF SURPLUS DISTRIBUTION WILL CONTINUE FOR NEXT TWO BUDGET YEARS BUT AT A REDUCED LEVEL IN SUCCEEDING YEARS. 100001 4120 REPLACEMT 37,877.43 4,400.00 4,400.00 28,220.30. 271000.00 10,000.00 127.3 °s 100001 4140 ST SALES 3,420,855.32 3,390,000.00 3,390,000.00 3,113,614.73 3,450,000.00 3,560,000..00 5.0% THIS IS THE GROSS AMOUNT AND INCLUDES AMOUNTS TO BE PAID TO WALGREEN AND DEERBROOK MALL FOR INCENTIVES. 100001 4141 HR SALES .00 204,000.00 204,000.00 .00 204,000.00 612,000.00 .200.0% REPRESENTS FIRST FULL YEAR OF HOME RULE TAX - 50% OF TOTAL . TO GENERAL FUND AND 50% TO INFRASTRUCTURE FUND. 100001 4142 LOC USE TX 180,289.20 165,780.00 165,780.00 139;657.35 188,800.00 202,620.00 22.296 . ESTIMATES FOR CURRENT YEAR AND PROJECTION FOR NEXT YEAR BASED ON ILL MUNICIPAL LEAGUE. 100001 4143 WALG SL TX - 20,207.62 .00 .00 - 45,739.9.7 .00 .00 .0% 100001 4150 ST INC TX 1,113,230.28 1,188,090.00 11188,090.00 991,047.62 1,243,300.00 1,307,800.,00 10.1% PROJECTING A SLIGHT INCREASE DUE TO RECOVERY IN STATE ESTIMATE FOR CURRENT YEAR AND PROJECTION FOR NEXT YEAR BASED ON ILL MUNICIPAL LEAGUE. 100001 4160 HOTEL TAX 1,515,953.67 1,825,000.00 1,825,000.00 1,524,318.55 1,825,000.00. 1,843,250.00 1.0% PROJECTING A 1% INCREASE IN BUDGETED AMOUNT DUE TO EXPECTED SLOW RECOVERY IN THIS ACTIVITY. 100001 4170 TELECOM TX 339,634.11, 410,000.00 410,000.00 226,562.58 34.0,000:00 340,000.00 -17.1% DECREASE TO REFLECT ACTUAL ACTIVITY. 100001 4211 LIQR LIC 75,800.00 73,000'.00 73,000.00 63,225.00 73,000..0'0 73,000.00 .0% 100001 4213 FOOD LIC 6,694.25 6,500.00 6,500.00 5,676.00 6,560.00 6,500.00 .0% 100001 4214 BUSN LIC 19,364.25 28,000.00 28,000.00 5,282.50, 28,000.00 28,000.00 .0% 100001 4220 BLDG PERM 397,390.52 300,000.00 300,000.00 756,272.26 700,000.00 350,000.00 16.7% INCREASE DUE TO EXPECTED CONTINUATION OF ACTIVITY. 03/28/2005 VILLAGE OF DEERFIELD PAGE 2 15:15:46 REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY '2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL FUND ACTUAL ORIG BUD =----------------- REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ---------------------------------------------------- 100001 4222 CONTR LIC 6,244.00 3,000.00 ------------ 3,000.00 ---------- ---------- 30,031.20 ---------------------- 19,500.0.0 - ---------- 4,500.00, 50.0% 100001 4232 LIC & PERM 100,867.31 50,000:00 50,000.00 62,078.77 50,000.00. 50,000.00 .0% 100001. 4233 ALRM PERM 675.00 3,000.00 3,000.00 21400.00 3,000.00 3,000..00 .0% 100001 4240 VEH LIC 332,062.50 335,000.00 335,000.00 333,020.00 335,.000.00 340,000.00 1.5% ADDITIONAL REVENUE EXPECTED FROM AN ENHANCED COLLECTION EFFORT. 100001 4310 MFT REV 275,000.00 285,000.00 285,000.00 .00 285,000.00 .00 - .100.096 MFT WILL BE USED FOR INFRASTRUCTURE PROJECTS IRF LEVY IN THE AMOUNT OF $285,000 IS NOW IN GF LEVY. 100001 4330. ST GRANT 260,803.67 6,000.00 6,000.00 98,258.94 6,000.00 6,000.00 .0% 100001 4350 FED GRANT 1,770.75 .00 .00 1,821.50 .00_• .00 .0% 100001 4415 CIS WLGRN 11,998.00 12,500.00 12,500.00 12,736..00. 12,500.00 12,50.0:00 .0% 100001 4417 CIS POL OT 190,520.25 191,500.00 191,500.00 187,894.00 191,500.00 '191,500.00 .0% PRIMARILY RAVINIA DETAIL REVENUE. 100001 4419 CIS OTHER 987.90 .00 .00 38,.112.99 .00 .00 .0% 100001 4420 CIS MAT SL 1,495.50 2,000.00 2,000.00 .00 2,000.00 2,000.00 .096 100001 4425 CIS BNK DI 57,651.00 79,000.00 79,000.00 72,184.00 79,000.00 79,000.00 .0% 100001 4430 CIS ENGIN 1,285.80 2,000.00 2,000.00 1,667.00 2,000.00 2,000.00 .0% 100001 4462 CIS TREE .00 1,000.00 1,000.00 3,647.50 1,000.00 1,000.00 .0% 100001 4463 CIS HWY MT 34,645.75 28,000.00 28,000.00 .00 28,.000.00 28,000.00 .0% 100001 4510 ORD V CTY 119,811.48 125,000.00 125,000.00 118,132.36 125,000.00 137,500:00 10.0% 100001 4511 ORD V VIL 40,689.04 70,000.00 70,000.00 32,841.42 50,000.00 50,000.00 -28.6% 100001 4520 FLSE ALRM 44,855.00 50,000.00 50,000.00 34,565.00. 50,000.00 50,000.00 .0% 100001 4530 RSTIT FINE .00 .00 .00 323.00 .00 .00 .0% 100001 4540 OVR SZ VEH 5,280.00 2,500.00 2,500.00 6,840.00 2,500.00 2,500.00 :0% 100001 4560 FF & PEN 394.00 .00 .00 1,870.04 -.00 .00 .0% 100001 4610 INTER EARN 390,745.06 455,000.00 455,000.00 .00 390,000.00 420,000.00 -7.7% 100001. 4612 NCHGFRVAL - 219,101.61 .00 .00 .00 .00 .00 .0% 100001 4810 MISC REV 103,555.29 51,000.00 51,000.00 73,078.02 75,000.00 52,000.00 2.0% 100001 4811 RENT INC 8,530.00 7,400.00 7,400.00 14,655.00 12,600.00 12,000.00 62.2% 100001 4821 PLZA ENT 2,794.00 5,000.00 5,000.00 1,350.00 5,000.00 5,000.00 .0% 100001 4822 FAM DY DON 74,124.36 30,000.00 30,000.00 49,526.36 54,000.00 40,000.00 33.3% INCLUDES DONATIONS FOR MUDFEST 100001 4844 INS REIMB 376.44 .00 .00 2,222.00 .00 .00 .0% 100001 4851 SALE EQPM .00 .00 .00 4,606.00 .00 .00 .0% 100001 4880 CABLE TV 198,916.83 230,000.00 230,000.00 156,073.28 230,000.00 230,000.00 .0% 100001 4910 TRSNFR IN .00 142,000.00 142,000.00 .00 142,000.00 .0% REPRESENTS OVERHEAD TRANSFER FROM COMMUTER PARKING FUND. .142,000.00 TOTAL GENERAL FUND REVENUE 10,874,741.48 11,779,670.00 11,779,670.00 9,617,666.90 11,877;850.00 12,188,670.00 3.5% TOTAL GENERAL FUND 10,874,741.48 11,779,670.00 11,779,670.00 9,617,666.90 11,877,850.00 12,188,670.00. 3.5% 03/28/2005 VILLAGE OF DEERFIELD PAGE 3 15:15:46 REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT MOTOR FUEL TAX FUND -------------------------------------------------------------------------------------------------------=---------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 140001 MOTOR FUEL TAX REVENUE -------------------------------------------- 140.001 4310 MFT REV 534,561.03 536,950.00 536,950.00 448,792.44 522,207.00 522,207.00 -2.7% ESTIMATE AND PROJECTION BASED ON ILL MUNICIPAL LEAGUE. 140001 4610 INTER EARN 11,982.24 .30,000.00 30,000.00 .00 22,000.00 20,000.00 -33.3% 140001 4612 NCHGFRVAL - 12,096.35 .00 .00 .00 .00 .00 .0% TOTAL MOTOR FUEL TAX REVENUE 534,446.92 566,950.00 566,950.00 448,792.44 544,207.00 542,207.00 -4.4% TOTAL MOTOR FUEL TAX FUND 534,446.92 566,950.00 566,950.00 448,792.44 544,.207.00 542,207.00 -4.4% n 03/28/2005 VILLAGE OF DEERFIELD PAGE 4 15:15:46 REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT E 911 FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 170001 E911 FUND REVENUES -- - - - - -- 170001 4410 ------------------------------ E911 SRCH - 168,348.52 132- ,000.00 132,000.00 165,822.77 165,000.00 165,000.00 25.0% 170001 4411 CELL 911 130,427.44 133,000.00 133,000.00 105,598.85 133.,000.00 133,000.00 .0% 170001 4425 C/S BNK DI .00 .00 .00 3,367.92 00 .00 .0% 170001 4610 INTER EARN 3,767.99 4,000.00 4,000.00 .00 4,000.00 4,000.00 .0% 170001 4612 NCHGFRVAL - 5,626.99 .00 .00 00. 00 .00 .0% TOTAL E911 FUND REVENUES_ 296,916.96 269,000.00 269,000.00 274,789.54 302,000.00 302,000.00 12.316 TOTAL E 911 FUND 296,916.96 269,000.00 269,000.00 274,.789.54 302,000.00 302,000.00 12.3% 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 15:33:25 - REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005. 2006 PCT VEHICLE & EQUIPMENT REPLACE. ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 210001 - VERF REVENUES -------------------------------------------- 210001 4480 CIS FUNDS .00 523,389.00 523,389.00 .00 523,389.00 509,737.00. -2.60 210001 4610 INTER EARN 38,260.79 75,000.00 75,000.00 00 50,000.00 50,000.00 -33.30 210001 4612 NCHGFRVAL - 47,618.93 .00 .00 .00 .00 .00 0% 21000.1 4844 INS REIMB .00 .00 .00 16,200.00 .00 .00 0% 210001 4852 G/L FADISP 34,998.00 .00 .00 .00 .00 .00 0% 210001 4910 TRSNFR IN 516,810.00 .00 .00 436,159.00 .00 .00 .0% TOTAL VERF REVENUES 542,449.86 598,389.00 598,389.00 452,359.00 573,389.00 559,737.00. -6.5% TOTAL VEHICLE & EQUIPMENT RE 542,449.86 598,389.00 598,389.00 452,359.00 573.389.00 559,737.00 -6.5% GRAND TOTAL 542,449.86 598,389.00 598,389.00 452,359.00 573,389.00 559,737.00 -6.5% 03/28/2005 VILLAGE OF DEERFIELD PAGE 6 15:15:46 REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT INFRASTRUCTURE REPLACEMENT ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 220001 INFRA REPLACE FUND REVENUE -------------------------------------------- 220001 4110 PROP TAX .00 - 330,000.00 330,000.00 .00 330,000.00 45,000.00 -86.4% $285,000 IN MFT FUNDS WILL NOW BE ADDED TO STREET PROGRAM. GENERAL FUND LEVY WILL BE INCREASED BY $285,000 TO MAKE UP - - FOR LOSS OF MFT TRANSFER. 220001 4115 TIP SRPLUS ..00 .00 .00 .00 .00 350,000.00 .0% 220001 4141 HR SALES .00 204,000.00 204,000.00 .00 204,,000.00 612,000.00 200.0% 220001 4460 CIS SIDEW .00 3,500.00 3,500.00 .00 .3,500.00 3,500.00 .0% 220001 4610 INTER EARN 112,277.86 120,000.00 120,000.00 .00 85,•000.00 40,000.00 - 66.7% 220001 4612 NCHGFRVAL - 74,121.96 .00 .00 .00 .00 :00 .0% TOTAL INFRA REPLACE FUND REV 38,155.90 657,500.00 657,500.00 .00 622,500.00 1,050,500.00 59.8% TOTAL INFRASTRUCTURE REPLACE 38,155.90 657,500.00 657,500.00" .00 622;,500.00 1,050,500.00 59.8% 03/28/2005 VILLAGE OF DEERFIELD PAGE 7 15:15:46 REVENUE BUDGET - FY 2005/06' bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT LAKE COOK RD TIF (TIF 1) ------------------------------------------------------------------------------------------------------=----------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION. FIN REVIEW CHANGE - - - - -- 250001 TIF 1 REVENUES -------------------------------------------- 250001 4110 PROP TAX 10,601,030.91 11,100,000.00 11,100,000.00 DUE TO THE EXPIRATION OF THE TIF 1 DISTRICT ON 12/31/04, THE RESIDUAL INCREMENT FROM THE 2004 LEVY WILL BE COLLECTED IN THIS FISCAL YEAR. ALL THIS WILL BE RETURNED THE THE TAXING DISTRICTS AS SURPLUS. 250001 4610 INTER EARN 292,860.78 160,000.00 160,000.00 250001 4612 NCHGFRVAL - 112,997.39 .00 .00 TOTAL TIF 1 REVENUES 10,780,894.30 11,260,000.00 11,260,000.00 TOTAL LAKE COOK RD TIF (TIF 10,780,894.30 11,260,000.00 11,260,000.00 8,169,952.23 11,100,000.00 5.,500,000.00 -50.5% :00 160,000.00 .00 00 8,169,952.23 11,260,000.00 8,169,952.23 11,260,000.00 85,000.00 -46.9% .00 .0% 5,585,000.00 -50.4% 5,585,000.00 -50.4% 03/28/2005 VILLAGE OF DEERFIELD PAGE 8 15:15:46. REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005/06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT VILLAGE CENTER ------------------------------------------------------------------------------------------------------------"------------------------ TIF (TIF 2) ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE . 260001 TIF 2 REVENUES 260001 4110 'PROP TAX 3,611,226.11 3,178,542.00 3,178,542.00 4,093,120.63 4,100,000.00 4,050,000.00- 27.40 260001 4330 ST GRANT .00 1," 200,000.00 1,200,000.00 723,566.24 1,200,000.00 .00 - 100.0% THIS WAS THE GRANT FOR THE PEDESTRIAN OVERPASS THAT - WAS COMPLETED IN FY 04/05. 260001 4610 INTER EARN 138,645.73 125,000.00 125,000.00 .00 125,000.00 125,000.00 .0% 260001 4612 NCHGFRVAL - 70,191.02 .00 .00 .00 .00 .00 .0% TOTAL TIF 2 REVENUES 3,679,680.82 4,503,542.00 4,503,542.00 .4,816,686.87 5,425,000.00 4,175,000.00 -7.30 TOTAL VILLAGE CENTER TIF (TI 3,679,680.82 4,503,542.00 4,503,542.00 4,816;686.87 5,425,000.00 4,175,000.00 -7.316 03/28/2005 VILLAGE OF DEERFIELD PAGE 9 15:15:46 REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT PROJECT 29 FUND --------------------------------------------------------------------------------------------------------7--------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 290001 PROJECT 29 REVENUES -------------------------------------------- 290001 4610 INTER EARN 3,328.15 600.00 600.00 .00 .3;000.00 3,000.00 -400.0% TOTAL PROJECT 29 REVENUES 3,328.15 600.00 600.00 .00 3,000.00 3,000.00 400.0% TOTAL PROJECT 29 FUND 3,328.15 600.00 600.00 .00 3,.000.00 3,000.00 400.0% 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 15:37:39 REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT DEBT SERVICE FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 350001 DEBT SERVICE REVENUE -------------------------------------------- 350001 4110 PROP TAX 320,391.20 .00 .00 310,247.42 310,184.00 .00 0°6 350001 4120 REPLACEMT 52,291.02 - .00 .00 39,405.51 .00 20,000.00 .0% 350001 4610 INTER EARN 71,260.46 75,000.00 75,000.00 ..00 25,000.00 25,000.00 . -66.7% 350001 4612 NCHGFRVAL - 31,008.77 .00 .00 .00 .00 .00 .0% 350001 4810 MISC REV .00 .00 .00 1.58 00 .00 0% 350001 4910 TRSNFR IN 1,769,550.00 2,416,008.00 2,416,008.00 1,737,000.00 2,416,008.00 1,877,250.00. -22.3% TRANSFER IN FROM TIF 2 OF ALL DEBT SERVICE DUE ON 1998 ISSUE. TOTAL DEBT SERVICE REVENUE 2,182,483.91 2,491,008.00 2,491,008.00 2,086,654.51 .2,751,192.00 1,922,250.00 -22.8% TOTAL DEBT SERVICE FUND 2,182,483.91 2,491,008.00 2,491,008.00 2,086,654.51 2,751,192.00 1,922,250.00 - 22.8°% GRAND TOTAL 2,182,483.91 2,491,008.00 2,491,008.00 2,086,654.51 2,751,192.00 1,922,250.00 -22.8% 03/28/2005 VILLAGE OF DEERFIELD PAGE 11 15:15:46 REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT WATER FUND ----------------------------------------------------------------------------------°-----------------=------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW.CHANGE 500001 WATER FUND REVENUES -------------------------------------------- 500001 4216 WTR PERM 22,085.25 17,500.00 17,500.00 31,035.00 25,000.00 30,000.00 71.4% PROPOSAL IS TO INCREASE TAP -ON FEES,' UNCHANGED SINCE 1981? 500001 4451 CIS UB 4,108,671.83 3,985,909.00 3,985,909.00 3,756;138.81 4,150,000.00 4,065,627.18 2.0% REPRESENTS PROPOSED 2% INCREASE IN RATE DUE TO HIGHLAND PARK PROPOSED WHOLESALE RATE INCREASE. SCHEDULED HIGHLAND PARK 3.6% INCREASE MAY 1. 500001 4452 CIS UB MSC 331.00 .00 .00 4,928.87 4,000..00 .00 .0°% 500001 4453 CIS UB PEN 22,984.05 25,000.00 25,000.00 50,512.60 45,000.00 35,000.00 40.0°% INCREASE DUE TO TIGHTER RESTRICTIONS ON LATE PAYMENTS AND IMPOSITION OF SHUT- OFF /TURN -ON FEES. 500001 4610 INTER EARN 79,816.54 76,000.00 76,000.00 .00 55,000.00. 55,000.00 - 27.6°% DECREASE DUE TO LOWER EXPECTED CASH BALANCES. - 500001 4612 NCHGFRVAL - 44,713.37 .00 .00 .00 .00 .00 .0% 500001. 4810 MISC REV - 443.69 7,500.00 7,500.00 21,462.49, 19,000.00 8,500.00 13.3% TOTAL WATER FUND REVENUES 4,188,731.61 4,111,909.00 4,111,909.00 3,864,077.77 4,298,000.00 4,194,127.18 _ 2.0% TOTAL WATER FUND 4,188,731.61 4,111,909.00 4,111,909.00 3,864,077.77 4,298,000.00 4,194,127.18 2.0% 03/28/2005- VILLAGE OF DEERFIELD PAGE 1 15:42:18 REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: .20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT SEWER FUND ----------------------------------------------------------------------=--------------=---------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 540001 SEWER FUND REVENUES -------------------------------------------- 540001 4215 SWR PERM 26,710.38 10,000.00 10,000.00 29,325.00 27',000:00 10,000.00 .0% 540001 4451 CIS UB 1,753,222.18 1,772,160.00 1,772,160.00 1,595,60.5.13 1,772,160.00 1,772,160.00 .0°% REPRESENTS NO CHANGE IN SEWER RATE. 540001 4453 CIS UB PEN 11,819.43 34,000.00 34,000.00 26;028.33 34,000..00 34,000.00 0% 540001 4495 CIS OTHER 19,593.90 35,000.00 35,000.00 00 .5,000.00 35,000.00 .01 -6 540001 4610 INTER EARN 44,631.09 45,000.00 45,000.00. .00 35,000.00 20,000.00 -55.6% DECREASE DUE TO SMALLER AVAILABLE CASH BALANCE. 540001 4612 NCHGFRVAL - 19,252.93 .00. .00 .00 .00 .00 .0% 540001 4810 MISC REV 1,095.40 5,000.00 5,000.00 7,942.27 9,560.00 5,000.00 .0% 540001 4910 TRSNFR IN .00 .00 .00 .00 .00 3,000,000.00 .0°% TRANSFER IN FROM GENERAL FUND RESERVES TO FUND CAPITAL PROGRAM AS NECESSARY TOTAL SEWER FUND REVENUES 1,837,819.45 1,901,160.00 1,901,160.00 1,658,90.0.73 .1,882,660.00 4,876;160.00 156.50 TOTAL SEWER FUND 1,837,819.45 1,901,160.00 1,901,160.00 1,658,900.73 1,882,660.00 4,876,160.00 156.5°% GRAND TOTAL 1,837,819.45 1,901,160.00 11901,160.00 1,658,900.73 1,882,660.00 . 4,876,160.00 .156.5°% 03/28/2005 VILLAGE OF DEERFIELD PAGE 13 15:15:46 REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT REFUSE FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL - PROJECTION FIN REVIEW CHANGE 580001 REFUSE FUND REVENUES ---------------=---------------------------- 580001 4110 PROP TAX 761,356.32. 778,000.00 778,000.00 699,558.13 778,000.00 809,000.00 4.0% PROPOSED 4% INCREASE IN 2005 LEVY FOR THIS FUND. 580001 4451 CIS UB 611,559.59 608,000.00 608,000.00 552,400.12 625,000.00 635,000.00 4.416 INCREASE REFLECTS RECENT GROWTH. 580001 4453 C /S.UB.PEN 5,227.86 4,000.00 4,000.00 8,805.95 7,500.00 5,000.00 25.0% 580001 4454 CIS REF CN 23,642.15 18,000.00 18,000.00 18,600.00 191000.00 20,000.00 11.1% 580001 4610 INTER EARN 3,438.66 2,500.00 2,500.00 .00 2,500.00 2,500.00 .0% 580001 4612 NCHGFRVAL - 5,605.31 .00 .00 .00 .00 .00 .0% 580001 4810 MISC REV 7,295'.64 12,000.00 12,000.00 5,724.40 12,000.00 12,000.00 .0% 580001 4835 RECYCLE 9,461.97 .00 .00 1.8,654.10 15,000.00 10,000.00 .0% RECYCLING REVENUE HAS INCREASED AND BUDGET IS BASED ON CURRENT REVENUE STREAM. TOTAL REFUSE FUND REVENUES 1,416,376.88 1,422,500.00 1,422,500.00 1,303,742.70 1,459,000..00 1,493,500.00 5.0% TOTAL REFUSE FUND 1,416,376.88 1,422,500.00 1,422,500.00 1;303,742.70 1,45.9,000.00 1,493,500.00 5.0% 03/28/2005 VILLAGE OF DEERFIELD PAGE -14 15:15:46 REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT COMMUTER PARKING FUND -----------------------------------------------------------------------------------------=------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 600001 COMMUTER PARKING FUND REVENUES -------------------------------------------- 600001 4440 CIS CPKMTR .00 63,000.00 63,000.00 43,210.20 95,000.00 100,800.00 60.0% 600001 4441 -CIS VPKMTR .00 12,000.00 12,000.00 3,515.00 12,000.00 19,200.00 60.0% 600001 4442 CIS VPKPER 100.00 63,000.00 63,000.00 43,750.00 85,000.00 85,000.00 34.9% 600001 4443 CIS CPKPER .00 11,000.00 11;000.00- 16,824.00 18,000.00 .18,000.00 63.6% 600001 4610 INTER EARN 2,590.03 11,000.00 11,000.00 .00 8,000.00 8,000.00 -27.3% 600001 4612 NCHGFRVAL - 10,282.45 .00 .00 .00 .00 .00 .0% 600001 4834 AST CNTR 365,926.00 .00 .00 .00 .00 .00 .0% TOTAL COMMUTER PARKING FUND 358,333.58 160,000.00 160,000.00 107,299.20 218,000.00 231,000.00 44.4% 03/28/2005 VILLAGE OF DEERFIELD PAGE 17 15:15:46 REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005' 2005 2005 2006 PCT GARAGE FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION_ FIN REVIEW CHANGE 700001 GARAGE FUND REVENUE -------------------------------------------- 700001 4480 CIS FUNDS 28,691.05 305,000.00 305,000.00 243,456.30 305,000.00 335,500.00 -10.0% 700001 4610 INTER EARN 3,304.55 500.00 500.00 .00 500.00 500.00 .0% 700001 4612 NCHGFRVAL - 1,879.80 .00 .00 .00 .00 .00 .0% 700001 4810 MISC REV 3,445.34 1,000.00 1,000.00 5,138.55 1,.000.00 11000.00 .0% 700001 4910 TRSNFR IN 221,281.35 .00 .00 .00 .00 00 .0°% TOTAL GARAGE FUND REVENUE 254,842.49 306,500.00 306,500.00 248,59.4.85 306,500.`00 337,000.00 10.0°% TOTAL GARAGE FUND 254,842.49 306,500.00 306,500.00 248,594.85 306;500.00 337,000.00 10.0°% 03/28/2005 VILLAGE OF DEERFIELD - PAGE 18 15:15:46 REVENUE BUDGET = FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT INSURANCE FUND -------------------------------------------------------------------------------=---------------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 720001 INSURANCE REVENUES -------------------------------------------- 720001 4495 CIS OTHER 50.00 .00 .00 25.00 .00 .00 .0% 720001 4610 INTER EARN 9,294.52 15,000.00 15,000.00 .00 5,000.00 5,000.00. -66.7% 720001 4612 NCHGFRVAL. - 7,796.03 .00 .00 .00 .00 ..00 .0% 720001 4860 VIL MEDPRE 1,125,294.05 1,245,856.00 1,245,856.00 .57,259.44 1,245,856.00 .00 - 100.0°% INSURANCE PREMIUMS FOR VILLAGE EMPLOYEES WILL BE EXPENSED'DIRECTLY OUT OF OPERATING DEPARTMENTS. WILL CHANGE FUND FROM INTERNAL SERVICE TO SPECIAL REVENUE. THIS WILL ALSO BE THE CASE FOR LIBRARY PREMIUMS. 720001 4861 VIL DNTPRE 16,982.78 166,067.00 166,067.00 .00 166,067.00 .00 - 100.0% 720001 4862 VIL LIFPRE 21,459.00 18,850.00 18,850.00 .00 18,850.00. .00 - 100.0% 720001 4863 RTR MEDPRE 163,803.30 64,632.00 64,632.00 145,048:15 13.5,000.00 .147,150.00 127.7°% 720001 4864 RTR DENPRE 10,629.47 .00 .00 9,842.74 10,000.00 11,000.00 .0% 720001 4865 LIB MEDPRE 144,866.91 145,000.00 145,000.00 41,992.82 209,000.00 :00 - 100.0% 720001 4866 LIB DENPRE 13,142.74 8,000.00 8,000.00 2,580.40. 12;.870.00 .00. - 100.0% 720001 4867 LIB LIFPRE 1,696.38 4,400.00 4,400.00 346.80 2,200.00 .00 - 100.0% 720001 4868 PKD MEDPRE 246,292.50 237,050.00 237,050.00 321,076.76 299,000.00 325,910.00 37.5°% 720001 4869 PKD DENPRE 26,202.42 24,970.00. .24,970.00 28,755.53 24,970:00 27,217.30 9.0% 720001 4870 PKD LIFPRE 28,451.85 12,200.00 12,200.00 - 17,014.45 6,500.00 6,500.00 -46.7% TOTAL 'INSURANCE REVENUES 1,800,369.89 1,942,025.00 1,942,025.00 589,913..19 2,135,313.00 522,777.30 -73.1% TOTAL INSURANCE FUND 1,800,369.89 1,942,025.00 1,942,025.00 589,913.19 2,135,313.00 522,777.30 -73.1% 03/28/2005 VILLAGE OF DEERFIELD PAGE 19 15:15:46 REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION 800001 - FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT POLICE PENSION FUND -----------------------------------------------------------------------------------=------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ----- - - - - -- 800001 POLICE PENSION FUND REVENUE 800001 4113 PRTX P PEN 315,762.00 .00 .00 .00 .00 .00 .0% 800001 4120 REPLACEMT 10,000.00 .00 .00 .00 .00 .00 .0% 800001 4610 INTER EARN 678,169.99 800,000.00 800,000.00 .00 800,000...00 800,000.00 .0 16 800001 4612 NCHGFRVAL 1,162,025.00 .00 .00 .00 .00 .00 .0% 800001 4620 GAIN SALE 33,412.01 .00 .00 .00 .00 .00 .0% 800001 .4890 EMPR CONTB .00 363,000.00 363,000.00 .00 363,000.00 725,000.00 99.70 800001 4891 EMPEE -CONT 288,507.45 301,040.00 301,040.00 68,709.16 301,040.00 316,100.00 5.0% . TOTAL POLICE PENSION FUND RE 2,487,876.45 1,464,040.00 1,464,040.00 68,709.16 1,464,040.00 1,841',100.00 25.80 TOTAL POLICE PENSION FUND 2,487,876.45 1,464,040.00 1,464,040.00 68,709.16 1,464,040.00 1,841,100.00 25.80 03/28/2005 VILLAGE OF DEERFIELD PAGE 20 15:15:46 REVENUE BUDGET - FY-2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT EAST SHORE RADIO NETWORK ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION• FIN REVIEW CHANGE 930001 ESRN REVENUES -------------------------------------------- 930001 4490 CIS GOVT .00 .00 .00 46_,142.00 .00 .00 .0% 930001 4610 INTER EARN 808.29 .00 .00 .00 .00 .00 .0% 930001 4612 NCHGFRVAL - 1,170.75 .00 .00 .00 .00 .00 .0% TOTAL ESRN REVENUES - 362.46 .00 .00 46,142.00 .00 .00 .0% TOTAL EAST SHORE RADIO NETWO - 362.46 .00 .00 .46,142.00 .00 .00 .0% 04/23/2005 VILLAGE OF DEERFIELD PAGE 1 10:16:53 DEERFIELD PUBLIC LIBRARY REVENUE BUDGET - FY 05/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006' PCT LIBRARY FUND ----------------------------------------------------------------------------------------------------------------=------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE 980001 LIBRARY REVENUES -------------------------------------------- 41 TAXES -------------------------------------------- 980001 4110 PROP TAX 1,837,333.69 1,708,955.00 1,708,955.00 1,529,592.83 1,708,.955.00 2,357,350.00 37.9% 980001 4115 TIF SRPLUS 142,908.00 140,000.00 14.0,000.00 164,674.00. 365,000.00_ 350,000..00 150.0% 980001 4120 REPLACEMT 18,145.90 16,000.00 16,000.00 15,997.60 16,000.00 .16,000.00 .0% TOTAL TAXES 1,998,387.59 1,864,955.00 1,864,955.00 1,710,264.43 2,089,955.00 2,723,350..00 46.016 43 INTERGOVERNMENTAL & -------------------------------------------- 980001 4330 ST GRANT 23,025.00 21,000.00 21,000.00 .00 .21,000.00 21,000.00 0% TOTAL INTERGOVERNMENTAL & 23,025.00 21,000.00 21,000.00 00, 21,000.00 21,000.00 .0% 45 FEES & FINES --------------------------------------------- 980001 4560 FF & PEN 40,207.09 40,000.00 40,000.00 37,915.65 40,000.00 40,000'.00 .0% 980001 4561 NRES FEE 18,543.49 24,000.00 24,000.00 8,277.02 24,000.00 10,000.00 -58.3% 980001 4562 PHOTOCOPY 6,174.75 6,000.00. 6,000.00 4,834.35 6,000.00 5,000.00 -16.7% 980001 4564 VID BORRW 12,957.55. 9,000.00 9,000.00 9,098.60 9,000.00 12,000.00 33.316 TOTAL FEES & FINES 77,882.88 _ 79,000.00 79,000.00 60,125.62 79,000.00 67,000.00 -15.2% 46 INVESTMENT INCOME -------------------------------------------- 980001 4610 INTER EARN 18,392.90 30,000.00 .30,000.00 .00 30,000.00 25,150.00 -16.2% . 980001 4611 SIMON INT 108.85 .00 .00 .00 ..00 .00 .0% TOTAL INVESTMENT INCOME 18,501.75 30,000.00 30,000.00 .00 30,.000.00 25,150.00 -16.2% 48 MISCELLANEOUS REVENU -------------------------------- ------ 980001 4810 MISC REV - - - - -- 9,410.89 1,000.00 1,000.00 4,153.80 1,000.00 1,000.00 .0% 980001 4820 GIFTS .00 1.,000.00 1,000.00 .00 1,000.00 2,500.00 150.0% 980001 4826 AMY SIMON 3,665.00 .00 .00 6,685.00 .00 2,000.00 .0% TOTAL MISCELLANEOUS REVENU 13,075.89 2,000.00 2,000.00 10,838.80 2,000.00 5,500.00 175.0% TOTAL LIBRARY REVENUES 2,130,873.11 '1,996,955.00 1,996, 955.00 1,781,228.85 2,221,955.00 2,842,000.00 42.316 TOTAL LIBRARY FUND 2,130,873.11 1,996,955.00 1,996,955.00 1,781,228.85 2,221,955.00 2,842,000.00 42.3% GRAND TOTAL 2,130,873.11. 1,996,955.00 1,996,955.00 1,781,228.85 2, 221, 955. 00 2,842,000.00 42.3% 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 10:12:20 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET,PROJECTION 6,0.00:00 FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 101111 FINANCE DEPARTMENT 5,298.72 14,520.00 14,000..00 -------------------------------------------- 101111 5110 REG SALAR 511,590.25 559,500.00 559,500.00 451,879.48 / 5.39,000.00 618,600.00 10.60 REQUEST TO CONVERT PART TIME FINANCE CLERK TO FULL TIME 44.4% 500.00 BASED ON ATTACHED MEMO. .00 500.00 500:00 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 101111 5111 5112 OVERTIME 5120 5121 5122 5130. 5140 5210 5211 5212 5213 5320 5321 5322 -5324 5325 5330 5331 5332 5335 5336" . 5337 5350 5351 5360 5361 5363 5364 5365 5370 5381 5382 5383 5384 5386 5390 PT SALARY OT SALARY AS NECESSARY FOR MED BNFT DNTL BNFT MISC BNFT APPAREL PEN CNTRB TRNG REG TRNG TRAV TRNG EXP SUBSCRIPT BLDG R&M STRUC R&M EQUP R&M CEME R&M DOG PND DUES CNF MEET TRAV EXP PRINTING LGL NOTICE POSTAGE INS GL INS DED P/S CRP CN P/S PRSCTR P/S MEDIC P/S CATV P/S OTHER DP SERV FAM SERV HOUS ASST SENR PKDIS TAXI SUBS FAMDYSEXP OTHER 29,475.09 9,389.22 DEPT PERSONNEL 88,310.22 972.19 12,493.59 .00 74,311.66 .00 678.03 .00 562.69 12,990.32 1,028.54 7,154.08 485.00 7,305.75 1,155.00 121.78 2,945.97 3,853.96 443.40 4,266.28 52;566.97 1,377.01 112,579.47 43,320.00 .00 .00 228,054.41 120,202.36 2,790.00 7,750.00 58,534.59 20,565.25 94,375.38 16,053.94 34,000.00 34,000.00 39,442.98 38,000.00 10,000.00 -70.6% 6,000.00. 6,000.00 6,702.07 6,0.00:00 8,000.00 33.3% 99,880.00 99,880.00 58,493.61 99- ,880.00. 110,090.00 10.2°% 14,520.00 14,520.00 5,298.72 14,520.00 14,000..00 -3.6% 4,500.00 4,500.00 4,757.51 4,500.00 6,500.00 44.4% 500.00 500.00 .00 500.00 500:00 .016 118,700.00 118,700.00 82,127.91 118..700.00 127,000.00 7.0% 500.00 500.00 433.40 500.00 1,000.00 100.0% 500.00 500.00 20.90 .200.00 250.00 -50.0% .00 .00 850.00 - 500.00 500.00 .0°% 3,000.00 3,000.00 290.80 750.00 1,000.00 - 66.7°% 20,000.00 6,077.00 5,244.76 9,000.00 10,000.00 64.6% .00 .00 .00 .00 .00 .0% 17,500.00 17,500.00 19,232.51 6,500.00 16,000,.00 -8.6% 12,000.00 12,000.00 5,466.85 12,000.00 12,000.00 .0% 7,000.00 7,000.00 5,853.08 3,500.00 6,000.00 -14.3% 3,500.00 3,500.00 5,963.95 4;200.00 4,500.00. 28.6% 2,000.00 2,000.00 657.58 2,000.00 3,000.00 50.0% 4,000.00 4,000.00 2,389.07 3,000.00 3,000.00 -25.0% 12,000.00 12,000.00 1,104.15 6,500.00 11,000.00 -8.3% 2,500.00 2,500.00 1,431.70 2,500.00 2,500.00 .0% 8,000.00 8,000.00 8,271.23. 10,000..00 10,000.00 25.0% 87,500.00 87,500.00 78,272.50 87,500.06 .91,875.00 5.0% .00 .00 .00 .00 .00 .0% 135,000.00 135,000..00 96,983.13 135;000.00 135,000.00 .0% 55,000.00 55,000.00 38,095.00 55,0.00.00 55,000.00 .0% 1;000.00 1,000.00 00 250.00 1,000.00 .0°% 5,000.00 5,000.00 .00 2,000.00 5,000.00 .0% 142,000.00 142,000.00 74,225.88 100,000.00 45,000.00 - 68.3°% 107,500.00 107,500.00 41,579.26 65,000.00 66,000.00 -38.6% 2,000.00 2,000.00 2,002.50 2,000..00 2,500.00 25.0°% 8,000.00 8,000.00 5,000.00 8,000.00 8,000.00 .0% 85,000.00 85,000.00 .00 85,000.00 85,000.00 .0% 27,000.00 27,000.00 15,905.50 27,000.00 27,000.00 .0% 90,000.00 90,000.00 80,558.42 90,000.00 90,000.00 .0% .00 .00 - 765.35 .00 .00 .0% 03/28/2005 VILLAGE OF DEERFIELD 10:12:21 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20061 FY 2005/06 MASTER BUDGET PROJECTION PAGE 2 bgnyrpts FOR.PERIOD 13 ACCOUNTS FOR: 2004 2005' 2005 2005 2005 2006 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- --------------------------------------------------------_- 101111 5395 ECON INCEN .00 .00 .00 83,068.49 150,000.00 230,000.00 0% ACCOUNTING RULES REQUIRE THAT WE EXPENSE THE ANTICIPATED REBATES FOR THE TWO SALES TAX AGREEEMENTS IN PLACE. WALGREEN NATIONAL - $180,000 DEERBROOK MALL - $50,000 101111 5410 MISC SUPP 1,045.25 16,000.00 16,000.00 3,557.72 16,000.00 16,000.00 .0% 101111 5421 MATERIAL .00 1,000.00 1,000.00 1,043.35 11500.00 .1,506.00 50.0% 101111 5440 SMTLSEQUP 899.51 1,500.00 1,500.00 98.94 1,500.00 1,500..00 .0% 101111 5450 OFF SUPP 6,355.91 11,000.00 11,000.00 7,779.05 9,000.00 10,000.00 -9.1% 101111 5460 OPER SUPP 3,775.23 3,000..00 3,000.00 3,426.37 3.,000.00 5,000.00 66.7% Sony SDX3 -100W 100 GB / 260 GB - AIT -3 $2000 101111 5470 R&M SUPP 1,669.40 2,500.00 2,500.00 1,355.48 2,500.00 2,500.00 .0% 101111 5530 U/E WATER 3,760.64 4,200.00 4,200.00.. 2,740.56 4,200..00 4,200.00 .0% 101111 5540 U/E TELEPH 16,366.26 23,000.00 23,000.00 13,902.74 20,000.00 22,000.00 -4.316 101111 5560 U/E OTHER 116.50 .00 .00 .00 .00 .00 .0% 101111 5810 OP EQP 28,265.02 2,200.00 2,200.00 21263.90 .2,200.00 15,500.00 604.5% HP Smart Array 6404/256 RAID Contrlr - Email Upgr - .$1900 6 - 72GB HD - Email Upgr.- $3100 DL360 G3 -.Processor Upgrade - GIS Upgrd. - $505 2 - 1Gb Ram - Email Upgr. - $550 . 1 - Laptop Computer - Finance - $2500 Sony AIT Library LIB 162A3CWK - Infr.- Upgrade - $5500 101111 5830 OFC EQP 359.64 7,900.00 7,900.00 5,227.26 7,900.00 .00 - 100.0% 101111 7210 TRNSFR OUT .00 .00 .00 .00 00 3,000,000.00 .0% TRANSFER TO SEWER FOR OPERATING AND CAPITAL EXPENDITURES. 101111 7211 TRANS VERF 43,650.00 44,250.00 44,250.00 TOTAL FINANCE DEPARTMENT 1,633,965.76 1,791,650.00 1,777,727.00 . 36,875.00 44,250.00 38,556.00 -12.9% 1,299,107.96 1,801,050.00 4,933,571..00 177.5% 03/28/2005 VILLAGE OF DEERFIELD PAGE 3 10:12:21 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL ------------------------------------------------------------------------------------------------------------------------------------ FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 101210 ADMINISTRATION -------------------------------------------- 101210 5110 REG SALAR 340,478.77 363,500.00 363,500.00 285,504.28 363,500.00 378,040.00. 4.0% 101210 5111 PT SALARY 27,942..66 34,000.00- 34,000.00 19,893.23 28,000.00 34,000.00 .0% 101210 5112 OT SALARY 1,947.22 6,000.00 6,000.00 912.24 3,500.00 5,000.00 -16.7% 101210 5120 MED BNFT 25,821.92 36,960.00 36,960.00 22,674.49 35,000.00 37,329.60 1.0% 101210 5121 DNTL BNFT 475.80 4,400.00 4,400.00 2,429.61 4,400.00 4,400.00 .0% 101210 5122 MISC BNFT 9,095.12 750.00 750.00 15,374.25 14,000.00 1,500.00 100.0% 101210 5140 PEN CNTRB 50,408.28 72,500.00 72,500.00 45,709.32 72,500.00 72,500.00 .0% 101210 5213 SUBSCRIPT 1,141.90 3,000.00 3,000.00 619.95 3,000.00 3,000.00 .0% 101210 5321 STRUC R&M .00 16,000.00 16,000.00 .00 3,000.00 5,000.00 -68.8% 101210 5322 EQUP R&M .00 1,000..00 1,000.00 109.83 1;.000.0.0 1,000.00 .0% 101210 5326 VEH MAINT 738.25 .1,000.00 1,000.00 241.50 1,000.00 1,000.00 .0% 101210 5330 DUES. 16,999.41 19,000.00 19,000.00 .14,006.80 19,.000.00 20,000.00 5..3% NW MUNICIPAL CONFERENCE - 7,460 NE ILL PLAN COMMISSION - 3,652 101210 5332 TRAV EXP 6,315.70 12,000.00 .12,000.00 6,934.93 12,000.00 12,000.00 .0% 101210 5335 PRINTING 24,282.20 29,000.00 29,000.00 24,670.36 28,000.00 37,000.00 27.6% $7,500 FOR NEW COMMUNITY INFORMATIONAL BROCHURE 101210 5336 LGL NOTICE 104.90 .00 .00 268..95 450.00 600.00 .0% 101210 5337 POSTAGE 4,966.77 8,000.00 8,000.00 4,119.28 8;000.00 8,000.00 .0% ANTICIPATED INCREASE IN POSTAGE RATES 101210 5387 ADV BOARD 103,879.06 90,000.00 90,000.00 68,043.22 90,000.00 90,000.:00 .0% 101210 5410 MISC SUPP 1,810.66 2,500.00 2,500.00 1;250.54 2,500.00 2,500.00 .0% 101210 5420 PETR PROD 594.71 750.00 750.00 2,273.24 750.00 2,000.00 166.7% 101210 5450 OFF SUPP 1,422.42 2,500.00 2,500.00 1,004.37 2,500..00 2,500.00 .0% 101210 5460 OPER SUPP 916.73 2,500.00 2,500.00. 2,881.66 3,000.00 3,500.00 40.0% 101210 5470 R&M SUPP .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 101210 5540 U/E TELEPH 2,210.49 1,600.00 1,600.00 925.82 1,6.00.00 1,600..00 .0% 101210 5810 OP EQP 836.55 .00 .00 .00 - .00 .00 .0% 101210. 5914 STRSCP IMP 00 13,000.00 13,000.00 2,173.92 13,000.00 48,000..00 269.2% CENTENNIAL SCULPTURE - $13,000 URN PLANTINGS - $35,000 101210 7211 TRANS VERF 3,999.98 4,000.00 4,000.00 3,333.00 4,000.00 3,600.00 -10.0% TOTAL ADMINISTRATION 626,389.50 724,960.00 724,960.00 525,354.79 714,700.00 775,069.60. 6.9% 03/28/2005 VILLAGE OF DEERFIELD 10:12:21 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION PAGE 4 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ------------------------------------------------------------------------------------------------------------------------- ----- - - - - -- 101330 COMMUNITY DEVELOPMENT 101330 5110 REG SALAR 405,300.97 442,650.00 442,650.00 334,850.96 395,204.58 545,000.00 23.1% ADDITIONAL PERSONNEL REQUESTED: BUILDING INSPECTOR @ $45,000 UPGRADE PT SECRETARY TO FULL TIME SECRETARY 2 $38,177 101330 5111 PT SALARY 89,719.23 97,394.00 97,394.00 83,873.60. 98,955..18 65,000.00 -33.3% REDUCTION DUE TO REQUEST TO UPGRADE PT SECRETARY TO FT 101330 5112 OT SALARY 9,315.03 7,556.00 7,556.00 2,700.83 4,051.25 7,556.00 .0% 101330 5120 MED BNFT 55,522.53 56,320.00 56,320.00 .52,873.67 61,536.63 75,000.00 33.2% INCREASE DUE TO ADDITIONAL FT PERSONEL REQUESTED 101330 5121 DNTL BNFT 976.84 5,500.00 5,500.00 5,376.86 6,296.34 8,200.00 49.1% 101330 5122 MISC BNFT 5,777.62 800.00 800.00 130.50 500. -00 1,323.00 65.4% 101330 5130 APPAREL 129.67 600.00 600.00 233.22 349.83 600.00 .0% 101330 5140 PEN CNTRB 60,660.25 108,008.00 108,008.00 68,116.21 79,819.44 - 120,000.00 11.1% INCREASE DUE TO ADDITIONAL PERSONNEL REQUESTED 101330 5211 TRNG TRAV 195.26 3,000.00 3,000.00 2,010.13 2,601.20 3,500.00 16.7% 101330 5213 SUBSCRIPT 168.49 3,000.00 3,000.00 25.00 .37.50' 1,000.00 -66.7% 101330 5322 EQUP R&M 2,868.58 9,000.00 9,000.00 1,180.88 1,771.32 5,000.00 -44.4% 101330 5326 VEH MAINT 1,998.20 5,300.00 .5,300.00 3,556.20 40.50 5,300.00 .0% 101330 5330 DUES 2,671.00 3,500.00 3,500.00 834.00 1,101.00 3,500.00 .0% 101330 5332 TRAV EXP 1,332.50 800.00 800.00 45.00 67..50 400.00 -50.0% 101330 5335 PRINTING 3,949.47 6,600.00 6,600.00 3,209.65 3,554.48 3,600.00 -45.5% 101330 5336 LGL NOTICE 2,243.56 1,600.00 1,600.00 3,625.52 4,273.92 4,300.00 168.8% 101330 5337 POSTAGE 1,660.50 400.00 400.00 1,068.28 1,602.42 1,610.00 302.5% 101330 5363 P/S MEDIC 455.00 400.00 400.00 .00 .00 800.00 100.0% 101330 5365 P/S OTHER 425.00 42,375.00 42,375.00 39,040.80 39,407.00 63,700.00 50.3°% Elevator inspection $15,000 Plumbing ins ection $46,200 Plan review ew $2,500 101330 5370 DP SERV 176.95 4,100.00 4,100.00 136.00 .00 4,100..00 .0% 101330 5390 OTHER 23,165.60 .00 .00 29,117.95 .00 ..00 .016 See 101330 5365 101330 .5410 MISC SUPP 44.95 650.00 650.00 142.86 214.29 650.00 .0% 101330 5420 PETR PROD 1,189.42 1,200.00 1,200.00 1,395.84 .00 1,800.00 50.0 %. 101330 5450 OFF SUPP 2,860.27 5,500.00 5,500.00 3,847.58 4,911.39 5,500.00 0$• 101330 5460 OPER SUPP 2,555.71 5,000.00 5,000.00 3,757.77 4,505.64 5,000.00 .0% 101330 5470 R&M SUPP 1,459.33 1,200.00 1,200.00 357.04 510.62 1,000.00 - 16.7 %. 101330 5520 U/E NAT GA 604.89 2,000.00 2,000.00 1,282.91 457.22 2,000.00 .0% 101330 5540 U/E TELEPH 3,067.71 3,700.00 31700.00 2,802.15 3,234.03 3,500.00 -5.4% 101330 5810 OP EQP .00 1,500.00 1,500.00 936.02 1,404.03 1,500.00 .0°% 101330 5830 OFC EQP .00 16,300.00 16,300.00 .00 00 1,000.00 -93.9% New Computer for Inspector - $1000 03/28/2005 VILLAGE OF DEERFIELD PAGE 5 10:12:21 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 101330 5990 OTHER CAP 1,131.64 .00 .00 .00 .00 .00 .0% 101330 7211 TRANS VERF 3,000.00 3,000.00 3,00.0.00 2,500.00 3,000.00 3,000.00 .0% TOTAL COMMUNITY DEVELOPMENT 684,626.17 838,953.00 838,953.00 6491027.43 719,407.31 944,439.00 12.6% 03/28/2005 VILLAGE OF DEERFIELD PAGE 6 10:12:21 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE --------------------------------------------=--------------------------------------------------------------------------------- - - - - -- 102010 STREET ADMINISTRATION 102010 5110 REG SALAR 126,578.94 159,800.00 159,800.00 178,708.18 159,800.00 159,800:00 .0% Street foreman, 1/3 engineering secretary, 1/4 director 102010 5111 PT SALARY 8,125.88 7,900.00 7,900.00 7,643..79 7,900.00 8,500.06 7.6% 1/3 Public works secretary + overtime for public works secretary 102010 5112 OT SALARY 822.73 2,000.00 2,000.00 3,012.78 3.,000.00 4,000.00 .100.0% 102010 5120 MED BNFT 16,188.60 19,410.00 19,410.00 17,328.69 19,410.00 21,200.00 9.2% 102010 5121 DNTL BNFT 336.24 2,190.00 21190.00 1,520.15. 2,190.00 2,299.50 5.0% 102010 5122 MISC BNFT 4,506.06 300.00 300.00 2,615.72 3,'500.00 3,500.00 1066.7% 102010 5130 APPAREL 4;695.38 4,800.00 4,800.00 4,290.95 4,800.00 6,000..00 25.0% 102010 5140 PEN CNTRB 16,694.74 18,000.00 18,000.00 30,038.83 40,000.00 35,000.00 94.4% 102010 5210 TRNG REG .00 .00 .00 .00 .00 1,200.00 .0% 102010 5211 TRNG.TRAV 860.53 400.00 400.00 .00 .00 .00 - 100.0°% 102010 5213 SUBSCRIPT .00 500.00 500.00 216.23 500.00 500.00 .0% 102010 5320 BLDG R&M 8,587.08 18,000.00 18,000.00 9,015.97 12,000.00 19,500.00 8.3% 102010 5322 EQUP R&M 3,977.90 3,000.00 3,000.00 490.00 1;000.00 5,000.00 66:7% 102010 5326 VEH MAINT 4,340.00 6,000.00 6,000.00 1,599.00 6,000.00 6,600.00 10.0% 102010 5330 DUES .00 200.00 200.00 98.00 200.00 200.00 .0% 102010 5332 TRAV EXP 2,967.11 1,300.00 1,300.00 431..78 1,300.00' 1,500.00 15.4% 102010 5335 .PRINTING 2,264.30 3,000.00 3,000..00 2,127.36 2,127.00 3,000.00 .0% 102010 5336 LGL NOTICE 180.57 200.00 200.00 .00 200.00 200.00 .0% 102010 5337 POSTAGE 4,702.01 5,100.00 5,100:00 1,500.00 5,100:00 5,100.00 .0% 102010 5350 INS GL 23,693.16 68,000.00 68,000.00 51,194.64 68,000.00 71,400.00 5.0% 102010 5351 INS DED _ 8,427.46 .00 .00 ..00 .00 .00 .0% 102010 5363 P/S MEDIC .00 500.00 500.00 400.00 .500.00 1,100.00 120.0% 102010 5365 P/S OTHER .00 9,400.00 9,400.00 4,477.00 .1,500.00 9,400:00 .0% 102010 5370 DP SERV 127.86 2,500.00 2,500.00 1,3.55.57 500.00 2,500.00 .0% 102010 5410 MISC SUPP 5,237.93 7,800.00 7,800.00 3,978.02 7,800..00 7,800.00 .0°% 1.02010 5420 PETR PROD 1,001.64 1,900.00 1,900.00 1,174:15 1,900.00 2,200.00 15.8% 102010 5421 MATERIAL 342.76 .00 .00 166.55 .00 .00 .0°% 102010 5430 ST SIGNS 451.50 .00 .00 .00 .00 .00 .0% 102010 5440 SMTLSEQUP 1,116.00 .00 .00 74.95 .00 .00 .0% 102010 5450 OFF SUPP 519.31 2,500.00 2,500.00' 839.95 1,200.00 2,500.00 .0% 102010 5460 OPER SUPP 3,279.54 3,500.00 3,500.00 1,592.53 3,500.00 3,500.00 .0% 102010 5470 R&M SUPP 2,738.09 3,000.00 3,000.00 6.99 500.00 3,000.00 .0% 102010 5510 U/E ELECT 1,953.53 4,000.00 4,000.00 3,555:90 4,000.00 4,.000.00 .0% 102010 5540 U/E TELEPH 6,362.60 6,500.00 6,500.00 4,530.29 6,500.00 6,500.00 .0% 102010 5560 U/E OTHER 43.62 .00 .00 .00 .00 .00 .0% 102010 5810 OP EQP 1,445.00 .00 .00 .00 .00 2,000.00 .0% 1/3 OF $6,000 FOR COPY MACHINE - $2,000 03/28/2005 VILLAGE OF DEERFIELD PAGE 7 10:12:21 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL FUND ----------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 102010 7211 TRANS VERF 7 -------------------------------------------- 125,187.98 119,923.00 ----------------- 119,923.00 99,936.00 ----------------------------- 119,923.00 127,915.00. 6.70 TOTAL STREET ADMINISTRATION 370,901.13 481,623.00 481,623.00 433,919.97 484,850.00 526,914.50 9.46 03/28/2005 VILLAGE OF DEERFIELD 10:12:21 a NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20061 FY 2005/06 MASTER BUDGET PROJECTION PAGE 8 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE -------------------------------------------------------------------=---------------------------------------------------------- - - - - -- 102036 STREET SNOW & ICE REMOVAL 102036 5110 REG SALAR 36,308.82 50,600.00 50,600.00 28,245.19 50,600.00 50,600.00 .0% All public works departments charged to this account during snow removal operations 102036 5111 PT SALARY 1,260.40 4,000.00 4,000.00 .00 4,000.00 6,000.00 50.0% 102036 5112 OT SALARY 47,380.12 45,200.00 45,200.00 57,440.65 60,000.00 55,000.00 21.7% 102036 5120 MED BNFT 17,570.05 7,900.00 7,900.00 13,176.95 14,000.00 15,000.00 89.9% 102036 5121 DNTL BNFT 78.95 900.00 900.00 1,221.65 1,500.00 1,800.00 100.0% 102036 5122 MISC BNFT 13.73 .00 .00 208.96 500.00 500.00 .0% 102036 5140 PEN CNTRB 17,433.67 9,300.00 9,300.00. 14,541.70 14,000.00 16,000.00 72.0% 102036 5310 RENT EQP 7,050.25 4,000.00 4,000.00 .00 2,000.00 4,000.00 .0°% 102036 5322 EQUP R&M 16,264.45 25,000.00 25,000.00 25,178.10 25;000.00 25,000.00. .0% 102036 5326 VEH MAINT 41,681.75 40,000.00 40,000.00 21,493.50 40,00.0.00 44,000.00 10.0% 102036 5390 OTHER .00 15,000.00 15,000.00 11,580.25- 15,000.00 17,500.00 16.7°% 102036 5420 PETR PROD 5,121.54 5,500.00 5,500.00 7,482.81 5,500.00 9,500.00 72.716 102036 5421 MATERIAL 1,328.48 10,000.00 10,000.00 126,533.94 4,000.00 7,500.00 - 25.0% 102036 5422 CHEMICAL 120,650.27 90,000.00 90,000.00 874.37 105,000.00 130,000..00 44.4% 102036 5460 OPER SUPP 612.78 1,800.00 1,800.00 894.37 1,800.00 1,800.00 .0% 102036 5470 R&M SUPP 404.91 1,200.00 1,200.00 1,173.07 1,200.00 1,500.00 25.0% 102036 5810 OP EQP 3,383.33 500.00 500.00 .00 "500.00 13,500.00 2600.0°% Tailgate salt spreaders and controls for vehicles # 705, 706 and 707. Increase by $10,000 102036 5914 STRSCP IMP - 5,072.00 .00 .00 - 369.23 .00 .00 .0% Remove this line item TOTAL STREET SNOW & ICE REMO 311,871.50 310,900.00 310,900.00 309,676.28 344,600.00 399,- 200.00 28.4% 03/28/2005 10:12:21 PROJECTION: 20061 VILLAGE OF DEERFIELD NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS FY 2005/06 MASTER BUDGET PROJECTION PAGE 9 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 . 2006 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE --------------------------------------------------------------------------------=--=------------------------------------------ - - - - -- 102037 STREET FORESTRY 102037 5110 _ _ - REG SALAR 430.25 35,600.00 102037 5111 PT SALARY 6,311.25 11,000.00 102037 5112 OT SALARY 2,099.16 2,400.00 102037 5120 MED BNFT 5,510.33 11,700.00 102037 5121 DNTL BNFT .00 1,300.00 102037 5122. MISC BNFT .00 .00 102037 5146 PEN CNTRB 3,371.22 8,200.00 102037 5322 EQUP R&M 6,595.95 6,000.00 102037 5326 VEH MAINT 7,155.50 .8,000.00 102037 5365 P/S OTHER .00 .00 $4000 for contractual weed spraying and $40,000 for consulting services 102037 5420 PETR PROD 519.20 1,400.00 102037 5421 MATERIAL 209.00 600.00 102037 5810 OP EQP .00 1,700-.00 $500 lawn mower $500 Chainsaw 102037 5914 STRSCP IMP 53,075.35 65,900.00 Increase by $2,100 $12000 DED, $40000 tree trimming, $9000 50/50 tree purchase and $7000 storm damage Add $13000 to account #261180 -5914 for holiday lights TOTAL STREET FORESTRY 85,277.21 153,800.00 35,600.00 30,187.31 35,600.00 35,600.00 .0% 11,000.00 547.50 11,000.00 6,000.00 -45.50 2,400.00 616.43 2,400.00 2,400.00 .016 11,700.00 6,034.77 10.,000.00 12,000.00 2.6% 1,300.00 575.51 1,300.00 1,300.00 .0% .00 92.48 500.00 500.00 .0% 8,200.00 5,239.26 8,200.00 8,800.00 7.3% .6,000.00 .2,671.50 4,000.00 6,000.00 .0% 8,000.00 2,662.50 8,000.00 8;800.00 10.016 .00 .00 ..00 44,000.00 .0% 1,400.00 600.00 1,700.00 65,900.00 153,800.00 709.68 110.37 106.11 68,084.73 117,638.15. 1,400.00 1,600.00 14.3% 600.00 600.00 .0% 1,700.00 1,700.00 .0% 65,900.00 68,000.00 3.2% 150,600.00 197,300..00 28.3% 03/28/2005 VILLAGE OF DEERFIELD PAGE 10 10:12:21 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD_13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL --------------------------------------------------------------------------------------------------=----------------------=---------- FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 102038 STREET TRAIN STATION MAINT -------------------------------------------- 102038 5110 REG SALAR 2,365.23 5,000.00 5,000.00 4,860.70 5,000.00 7,000.00 40.0% 102038 5111 PT SALARY .00 6,200:00 6,200.00 .00 1,000.00 2,200.00 -64.5% 102038 5112 OT SALARY 106.48 .00 .00 .00 .00 .00 .0% 102038 5120 MED BNFT 3,049.33 1,680.00 1,680.00 490.87 1,680.00 1,848.00 10.0% _. 102038 5121 DNTL BNFT 7.52 190.00 190.00 45:38 190..00 190.00 .0% 102038 5122 MISC BNFT 3.00 .00 .00 16.49 .00 .00 .0% 102038 5140 PEN CNTRB 2,371.85 960.00. 960.00 826.99 960.00 1,400.00 45.8% 102038 5320 BLDG R&M 1,924.14 3,000.00 3,000.00 167.15 .1,000.00 3,000.00 .0% 102038 5321 STRUC R&M .00 20,000.00 20,000.00. 12,600.00 20.,000.00 20,000.00 .0% 102038 5322 EQUP R &M 406.74 1,000.00 1,000.00 164.50 500.00 1,000.00 .0% 102038 5421 MATERIAL 1,959.98 4,000.00 4,000..00 1,671.38 .2,500.00 4,000.00 ".0% 102038 5460 OPER SUPP 889.61 800.00 800.00 1,182.03 800.00 1,00.0.00 25.0% 102038 5470 R&M SUPP 427.14 1,000.00 1,000.00 802.08 1,000.00 1,000.00 - .0% 102038 5550 U/E TELECM 380.33 500.00 500.00 378.15 500.00 500.00 .0% TOTAL STREET TRAIN STATION M 13,891.35 44,330.00 44,330.00 23,205.12 35,130.00 43,138.00 -2.7% 03/28/2005 10:12:21 VILLAGE OF DEERFIELD NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20061 FY 2005/06 MASTER BUDGET PROJECTION PAGE 11 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005. 2005 2006- PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 102050 STREET MAINTENANCE -------------------------------------------- 102050 .5110 REG SALAR 314,781.57 247,000.00 247,000.00 217,827.16 247,000.00 247,000.00 .0% 102050 5111 PT SALARY 3,134.20 8,200.00 8,200.00 8,551.88. 12,200.00 48.80 102050 5112 OT SALARY 17,061.67 20,700.00 20,700.00 26,441.23 „8,200.00 30,000.00 36,700.00 77.3°% Increase by $16000 to accomodate special events work i.e. farmers market, memorial day, 3rd and 4th of July, holiday on the town and art festivals 102050 5120 MED BNFT 55,003.81 61,740.00 61,740.00 49,172.56 61,740.00 66,827.00 8.216 102050 5121 DNTL BNFT 1,060.67 6,260.00 6,260.00 4,814.15 6,260.00. 6,886.00 10.0°% 102050 5122 MISC BNFT 170.43 .00 .00 744.81 1,.000.00 1,500.00 .0% 102050 5130 APPAREL -9.13 .00 .00 .00 00 00 0% 102050 5140 PEN CNTRB 38,480.02 55,500.00 55,500.00 41,395.56 55,500.00 59,400.00 7.016 102050 5210 TRNG REG .00 .00 .00 .00 .00 1,200.00 0% 102050 5310 RENT EQP 2,162.08 2,500.00 2,500.00 3,348.80 2,500.00 2,500.00 0% 102050 5322 EQUP R&M 25,557.74 18,000.06 18,000.00 12,572.23 .18,000.00 15,000.00 -16.7% 102050 5326 VEH MAINT 39,227.50 40,000.00 40,000.0.0 38,108.42 40,000.00 44,000.00 10.0% 102050 5365 P/S OTHER .00 .00> .00 .00 .00 42,000..00 .0% Directional boring = $10,300 Thermo - $24,000 Bridge cleaning - $7,700 102050 5390 OTHER 71,089.58 164,700.00 164,700.00 46,291.20 164,700.00 .00 - 100.0°% 102050 5410 MISC SUPP 3,236.93 2.,400.00 2,400.00 2,223.50 2,400..00 "2,400.00 .0% 102050 5420 PETR PROD 5,362.20 7,500.00 7,500.00 5,989.51 7,500.00 9,600.00 28.0% 102050 5421 MATERIAL 78,718.66 128,800.00 128,800.00 64,599.22 105,000.00 128,800.00 .0% 102050 5430 ST SIGNS 17,829.05 15,000.00 15,000.,00 11,214.81 15,000.00 15,000.00 .0% 102050 5440 SMTLSEQUP 440.52 700.00 700.00 452.89 700.00 1,000.00 42.9°% 102050 5450 OFF SUPP 1,371.98 .00 .00 .00 .00 .00 .0% 102050 5470 R&M SUPP 1,174.97- 1,600.00 1,600.00 2,209.25 1,600.00 2,000.00•. 25.0% 102050 5510 U/E ELECT 27,384.10 39,000.00 39,000.00 27,451.41 39,000.00 39,000.00 .0°% 102050 5611 PMTS OTHR 00 .00 .00 .00 .00 36,000.00 .0°% $2000 for CCHD traffic signal agreement, $4000 for LCHD traffic signal agreement and $26000 for IDOT traffic signal agreement $4000 for signal preemption at 294 spur on Waukegan Rd. 102050 5810 OP EQP 599.98 .00 .00 .00 .00 .00 .0% 102050 5950 BLDNG IMP .00 .00 .00 .00 .00 69,000.0.0 .0% Storage yard fencing - $45,000 . Storage yard paving - $24,000 TOTAL STREET MAINTENANCE 703,838.53 819,600.00 819,600.00 563,408:59 806,100.00 838,013.00 2'.2% 03/28/2005 VILLAGE OF DEERFIELD 10:12:21 NEXT YEAR / CURRENT YEAR.BUDGET ANALYSIS PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION PAGE 12 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL ----------------------------------------=----------------------=-------------------------------------------------------------------- FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 102110 ENGINEERING DIVISION -------------------------------------------- 102110 5110 REG SALAR 77,955.52 81,506.00 81,506.00 72,866.50 81,506.00 170,000.00 108.6% INCLUDE BOTH ASSISTANT ENGINEERS IN THIS DIVISION WAS OTHERWISE CARRIED IN STREET, WATER AND SEWER 102110 5111 PT SALARY .00 5,000.00 5,000.00 - .00 .00 5,500.00 10.0% SUMMER INTERN FOR ENGINEERING $9 -10 /HR ® APPROX 500 HOURS DURING THE SUMMER; ADDITIONAL FOR WINTER /SPRING BREAKS 102110 5120 MED BNFT 13,619.48 13,220.00 13,220.00 12,616.38 13,220.00 22,000.00 66.4% 102110 5121 DNTL BNFT 187.84 1,300.00 1,300.00. 1,079.62 1,300.00 2,600.00 100.0% 102110 5122 MISC BNFT 763.87 500.00 500.00 411.88 500".00 900.00 80.0% 102110 5130 APPAREL .00 300.00 300.00 .00 300.00 600.00 100.0% 102110 5140 PEN CNTRB 10,645.16 16,302.00 16,302.00 11,954.82 16,302.00 17,500.00 7.3% 102110 5211 TRNG TRAV 346.40. 2,500.00 2,500.00 170.00 2,500.00 2,500.00 .0% 102110 5213 SUBSCRIPT 53.70 .00 .00 120.90 .00 .00 .0% 102110 5322 EQUP R&M 875.11 1,250.00 1,250.00 780.6.7 1',250.00 1,250.00 .0% 102110 5326 VEH MAINT 347.50 1,500..00 1,500.00 3,041.50 1,500.00 1,650.00 10.0% 102110 5330 DUES 965.00 1,200.00 1,200.00 1,269.00. 1,200.00 1,200.00 .0% 102110 5332 TRAV EXP 2,776.51 300.00 300.00 2,247.52 300.00 500.00 66.7% 102110 5335 PRINTING 210.24 500.00 500.00 232.15 500.00 500.00 .0% 102110 5336 LGL NOTICE 699.32 500.00 500.00 403.90 500.00. 500.00 .0% 102110 5337 POSTAGE 253.26 300.00 300.00 426.28 300.00 300.00 .0.% 102110 5362 P/S ENG 37,353.45 25,000.00 25,000.00 8,579:50 25,000.00 25,000.00- .0% 102110 5363 P/S MEDIC .00 250.00 250.00 .00 250.00 250.00 .0% 102110 5365 P/S OTHER 796.00 7,500.00 7,500.00 1,854.67 71500.00 7,500.00 .0% 102110 5375 GIS SERV .00 109,000.00. 109,000.00 94,040.54 109,000.00 107,000.00 -1.8% PROGRAM STAFFING - $61,166 AYRES ASSOCIATES - $29,639 HARDWARE - $0 SOFTWARE - GISCON INTERNET MAPPING - $4,246 MAINT & LICENSING SOFTWARE (ESRI) - $8,000 BUDGET IN FY08 FOR PLOTTER SERV $1200 102110 5410 MISC SUPP 179.67 11000.00 1,000.00 526.63 1,000.00 1,000.00 .0% 102110 5420 PETR PROD 1,189.38 1,200.00 1,200.00 .00 1,200.00 1,200.00 .0% 102110 5450 OFF SUPP 2,830.22 3,000.00 3,000.00 2,802.97. 3,000.00 3,000.00 .0% CHAIR REPLACEMENT FOR JAMES - $300 102110 5460 OPER SUPP 190.26 500.00 500.00 .00 .500.00 500.00 .0% 102110 5470 R&M SUPP 673.95 .00 .00 .00 .00 .00 .0% 102110 5540 U/E TELEPH 2,662.17 2,500.00 2,500.00 2,266.90 2,500.00 2,500.00 .0% 102110 5810 OP EQP 2,874.80 3,500.00 3,500.00 1,986.00 3,500.00 3,500.00 .0% 102110 7211 TRANS VERF 9,081.00 9,081.00 9,081.00 7,568.00 9,081..00 9,081.00 .0% TOTAL ENGINEERING DIVISION 167,589.81 288,709.00 288,709.00 227,246.33 283,709:.00 388,031.00 34.4% 03/28/2005 VILLAGE OF DEERFIELD 'PAGE 13 10:12:21 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ----------------------------------------------------------------------.-------------------------------------------------------------- 106010 POLICE DEPT ADMINISTRATION ------------------7------------------------- 106010 5110 REG SALAR 502,308.05 592,989.00 592,989.00 509,193.62 582,000.00 589,134.00 -.7% PURPOSE OF ACCOUNT: SALARIES FOR REGULAR FULL TIME EMPLOYEES. INCLUDES ALLOWANCE FOR MERIT AND COLA DESCRIPTION: SALARIES FOR CHIEF, DEPUTY CHIEF OF ADMINISTRATION, ONE PATROL OFFICER, ONE ADMIN. TWO RECORDS CLERKS, AND TWO COMMUNITY SERVICE OFFICERS 106010 5111 PT SALARY 120.00 .6,000.00 6,000.00 977.47 2,.000.00 3,000.00 -50.0% 106010 5112 OT SALARY 120,022.51, . 5,000.00 5,000.00 4,371.60 5,500.00 6,000.00 20.0% 106010 5120 MED BNFT 66,098.46 109,468.00 109,468.00 59,267.34 99,500.00 110,000.00 .5% 106010 5121 DNTL BNFT 832.76 12,500.00 12,500.00 5,958.08 10,000.00 12,500.00 .016 106010 5122 MISC BNFT 5,074.21 1,000.00 .1,000.00 4,370.36 5;500.00 5,500.00 450.0% 106010 5130 APPAREL 4,152.54 5,750.00 5,750.00 2,652.41 5,500.00 51500.00 -4.3% MISC. CLOTHING ITEMS: BULLET PROOF VEST REPLACEMENT 106010 5140 PEN CNTRB 344,413.06 374,500.00 374,500.00 41,151.84 664,000.00 725,000.00 93.6% INCREASE DUE TO ACTUARIALLY DETERMINED REQUIRED CONTRIBUTION AS A RESULT OF INCREASED BENEFITS, HIGHER SALARIES, LOWER INVESTMENT RETURN 106010 5211 TRNG'TRAV 1,188.82 7,500.00 7,500.00 3.,635.21. 5,000.00 16,500.00 120.0% 106010 5212 TRNG EXP .00 .00 .00 .. .00 10,000.00 5,000.00 .0°% 106010 5213 SUBSCRIPT 1,072.35 2,000.00 2,000.00 1,028.57 2,000.00 2,000.00 .0% 106010 5320 BLDG R&M 12,604.53 40;000.00 53,923.00 53,.609.36 50,000.00 56,750.00 5.2% 106010 5322 EQUP R&M 26,762.53 23,850.00 23,850.00 23,377.74 23,000.00 25,000.00. 4.8% 106010 5326 VEH MAINT 346.00 1,500.00 1,500.00 595.50 1,250.00 1,500.00 .0% 106010 5330 DUES 633.75 2,500.00 2,500.00 1,283.53 2,500.00 2,500.00 .0% 106010 5332 TRAV EXP 1,230.27 13,500.00 .13,500.00 9,268.50 10,000.00 .00 - 100.0% 106010 5335 PRINTING 8,984.29 8,000.00 8,000.00 4,929.41_ 7,500.00 8,000.00 .0% 106010 5336 LGL NOTICE 916.52 1,200.00 1,200.00 20.00 500.00 1,200.00 .0% 106010 5337 POSTAGE 2,425.01 2,750.00 2,750.00 1,817.52 2,600.00 2,750.00 .0% 106010 5350 INS GL 104,062.28 180,000.00 180,000.00 145,651.29. 160;000.00 189,000.00 5.0% 106010 5351 INS DED 670'.26 .00 .00 .00 .00 .00 .0% 106010 5363 P/S MEDIC 4,010.75 8,500.00 8,500.00 4;237.00 5,000.00 6,000.00 -29.4% 106010 5370 DP SERV 6,313.50 1,000.00 1,000.00 1,096.00 1,200.00 12,250.00 1125.0% 106010 5387 ADV BOARD 11,275.82 10,000.00 10,000.00 13,579.00 15,000.00 20,000.00 100.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 (Elbaum) - $2,400 Cost of. Police Test - $2,000 Credit Checks - $750 Sergeants Test - $3,000 Mudfest - $8,000 03/28/2005 VILLAGE OF DEERFIELD PAGE 14 10:12:21 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEWCHANGE ---------------------------------------------------------------------------------------=-------------------------------------------- 106010 5388 EMER SERV 1,154.80 8,000.00 8,000.00 2,825.68 . 5,000.00 8,000.00 .016 PURPOSE: Cost of operating the ESDA Center 106010 5390 OTHER 42,391.00 42,500.00 42,500.00 37,814.00 40,000.00 46,500.00 9.4% PURPOSE: Other contractual work not classified DESCRIPTION: NIPCL - $29,178 NIPAS = $4,500 Hi9rhland Park Range - $3,000 Mayor Crimes Task Force - $500 IACP Net - $800 Records-Destruction/Copying - $4,000 Stericycle Bio- Disposal - $150 NIPCL Rent - $3,000 MCAT: Major Crash Team - $500 106010 5410 MISC SUPP 1,387.00 1,200.00 1,200.00 205.94 500.00 1,500..00 25.0% 106010 5420 PETR PROD 644.21 1,200.00 1,200.00 1,009.33 1,200:00 1,750.00 45.8% 106010 5450 OFF SUPP 7,619.98 10,000.00 10,000.00 8,182.73 10,000.00 10,000:00 .0% 106010 5460 OPER SUPP 34,663.09 36,000.00 36,000.00 26;124.65 35,000..00 37,000.00 2.80 106010 5470 R&M SUPP 2,329.17 2,000.00 2,000.00 1,291.14 2,000.00 2;000:00 .016 106010 5540 U/E TELEPH 32,771.13 .00 .00 2,548.59 .00 00 .0% 106010 5550 U/E TELECM .'00 37,000.00 37,000.00 27,415.18 32,000.00. 35,000.00 -5.4% 106010 5810 OP EQP 550.00 2,000.00 2,000.00 1,553 ;54 2,000.00 3,000.00 50.0% 106010 7211 TRANS VERF 214,132.98 193,385.00 193,185.00 199,043.75 193,385.00 168,287.00 -13.0% TOTAL POLICE DEPT ADMINISTRA 1,563,16.1.63 1,742,792.00 1,756,715.00 1,200,085.88 1,990,635.00 2,118,121.00 20.6% 03/28/2005 VILLAGE OF DEERFIELD PAGE 15 10:12:21 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005.' 2006 PCT GENERAL ------------------------------------------------------------------------------------------------------=----------------------------- FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE. 106020 POLICE DEPT COMMUNICATIONS -------------------------------------------- 106020 5110 REG SALAR 442,521.76 482,091.00 482, - 091.00 406,307.77 460,000.00 491,776.00 2.0% 106020 5111 PT SALARY 8,682.57 12,500.00 12,500.00, 8,466.39 11;100.00 12,500.00 .016 106020 5112 OT SALARY 34,207.88 26,000.00 26,000.00 30,108.63 35,000.00 27,000.00 3.8% 106020 5120 MED BNFT 58,419.77. 65,988.00 65,988.00 55,587.02 67,.984.00 72,600.00 10.0% 106020 5121 DNTL BNFT 864.16 11,100.00 11,100.00 5,510.36 6,950.00 10,500.00 -5.40 106020 5122 MISC BNFT 12,327.30 10,000.00 10,000.00 3,639.50 6,000.00 9,000.00 - 10.0°% 106020. 5130 APPAREL 2,647.14 2,800.00 2,800.00 1,520.12 2,800.00 2,800.00 .0% 106020 5140 PEN CNTRB 64,841.55 82,500.00 82,500.00 74,580.62 92,000.00 99,360.00 20.4% 106020 5211 TRNG TRAV 1,062.06 1,000.00 1,000.00 866.64 1,450.00 2,000.00 100.0% 106020 5212 TRNG EXP .00 .00 .00 .00 1,200.00 2,000.00 .0% 106020 5213 SUBSCRIPT 26.95 100.00 100.00 218.90 250.00 300.00 200.0% 106020 5330 DUES 330.00 500.00 500.00 330.00 500.00 500.00 .0% 106020 5332 TRAV EXP 607.10 2,800.00 2,800.00 325.00 2,800.00 .00 - 100.0% 106020 5810 OP EQP 1,940.00 31000.00 3,000.00 2,748.99 .3,000.00 9,000.00 200.0% PURPOSE: Purchase of equipment DESCRIPTION:. Shredder - $500 Color Printer - $500 Security Window Treatment - $2,000 Digital Security Cameras Upgrade - $6,000 TOTAL POLICE DEPT COMMUNICAT 628,478.24 700,379.00 700,379.00 590,209.94 691,.034:00 739,33.6.00 5.6% 03/28/2005 VILLAGE OF DEERFIELD 10:12:21 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION PAGE 16 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL ------------------------------------------------------ FUND ACTUAL ORIG BUD --------------------------------------------------------------------- REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE -.-------- 106033 POLICE DEPT INVESTIGATIONS -------------------------------------------- 106033 5110 REG SALAR 522,166.82 589,955.00 589,955.00 501,420.88 575,000.00 633,000.00 7.3% PURPOSE: Regular Salaries for Full time employees. Includes allowance for merit and COLA DESCRIPTION: Salaries for one Investigations Supervisor, two Investigators, two Youth Officers, one DARE officer, two Social workers 106033 5112 OT SALARY 15,904.89 15,000.00 15,000.00 18,256.35 19,000.00 20,000.00 33.3% 106033 5120 MED BNFT 91,874.67 101,640.00 101,640.00 89,718.99 103,000:00 111,804.00 10.0% 106033 5121 DNTL BNFT 1,190.43 9,702.00 9,702.00 7,701.71 9,000.00 10,672.00 10.0% 106033 5122 MISC BNFT 4,692.55 7,500.00 7,500.00 4,479.88 6,500.00 7,500:00 .0% 106033 5130 APPAREL 3,085.55 6,500.00 6,500.00 3,581.23 6,000.00 6,500.00 .0% 106033 5140 PEN CNTRB 24,947.20 35,800.00 35,800.00 26,778.50 31,500.00 37,000.00 3.416 106033 5211 TRNG TRAV 943.16 1,200.00 1,200.00 403 -.47 1,000.00 1,200.00 .0% 106033 5212 TRNG EXP .00 .00 .00 .00 4,750.00 5,000.00 .0% 106033 5213 SUBSCRIPT 594.12 750.00 750.00 836.66 750.00 750.00 .0% 106033 5326 VEH MAINT 1,665.38 3,750.00 3,750.00 3,900.45 .4,000:00 4,500.00 20.0% 106033 5330 DUES 819.00 1,200.00 1,200.00 866.00 1,200.00 1,200.00 .0% 106033 5332 TRAV EXP 2,095.18 5,000.00 5,000.00 975.25 4.,.750.00 .00 - 100.0% 106033 5390 OTHER - 521.00 .00 .00 .00 .00 .00 .0% 106033 5415 DARE PROG .00 8,250.00 8,250.00 5,984.33 6,250.00 8,250.00 .0% 106033 5420 PETR PROD 1,383.51 3,500.00 3,500.00 2,548.70 3,000.00 3,750.00 7.11 106033 5810 OP EQP 5,805.60 5,000.00 5,000.00 3,412.90 5,000.00 8,000.00 60.0% PURPOSE: Purchase of equipment for Investigations DESCRIPTION: Composite Sketch Program - $600 Videotape System - $1,000 Surveillance Equipment - $1,250 Computer Upgrades - $2,750 Projector - $1,500 Misc.- Equipment - $400 TOTAL POLICE DEPT INVESTIGAT 676,647.06 794,747.00 794,747.00 670,865.30 782,700.00 859,1261.00 8.1% 03/28/2005 VILLAGE OF DEERFIELD 10:12:21 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION PAGE 17 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 . 2005 2005 2005 . 2006 PCT GENERAL ------------------------------------------------------------------------------------------------------------------------=----------- FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 106034 POLICE DEPT PATROL -------------------------------------------- 106034 5110 REG SALAR 2,305,735.12 2,301,036.00 2,301,036.00 1,927,513.74 2,195,000.00 2,437,200.00 5.9% PURPOSE: Regular salaries for full time employees. Includes allowance for merit and COLA DESCRIPTION: Salaries for 1 Deputy Chief, 8 Supervisors 23 Patrol Officer, including merit and Career Development for qualified personnel 106034 5111 PT SALARY 55,573.03 55,000.00 55,000.00 41,816.25 .53,000.00 65,000.00 18.2% PURPOSE: Salaries for permanent and temporary part time employees - Salaries for 8 crossing guards for a total of 24 hours per day _ 186 days at $14.69 per hour Salaries for assisting Department during special events Salaries for summer school guards - 25 hours a week for six weeks (partial reimbursement from school) 106034 5112 OT SALARY 110,436.46 110,000.00 110,000.00 100,215.33 120,000.00 120,000.00 9.1% 106034 5120 MED BNFT 337,972.58 330,000.00 330,000.00 294,684.39 358,768.00 363,000.00 10.0% 106034 5121 DNTL BNFT 4,736.59 42,735.00 42,735.00 26,275.20 35,800.00 44,000.00 3.0% 106034 5122 MISC BNFT 29,397.06 10,000.00 10,000.00 7,220:85 7,940.00 10,000.00 .0% 106034 5130 APPAREL 31,177.94 36,000.00 36,000.00 27,762.26 34.,500.00 36,000.00 .0% 106034 5140 PEN CNTRB 26,096.77 34,800.00 34,800.00 24,610.62 32,000.00 37,584.00 8.0% 106034 5211 TRNG TRAV 5,697.50 7,000.00 7,000.00 1,675.31 2,500.00 5,000.00 -28.6% 106034 5212 TRNG EXP .00 .00 .00 .00 28,500.00 30,000.00 .0% 106034 5213 SUBSCRIPT 639.05 900.00 900.00 387.50 9.00.00 900.00 .0% 106034 5322 EQUP R&M .00 .00 .00 578.00 .00 .00 .01 106034 5326 VEH MAINT 27,661.43 35,000.00 35,000.00 39,015.72 38,000.00 45,000.00 28.6% 106034 5330 DUES 349.00 500.00 500.00 509.96 525.00 600.00 20.0% 106034 5332 TRAV EXP 22,204.30 30,000.00 30,000.00 15,864.12 25,000.00 .00 - 100.0; 106034 5420 PETR PROD 33,386.70 39,000.00 39,000.00 38,739.73 40,000.00 50,000.00" 28.21 106034 5540 U/E TELEPH 6,829.39 .00 .00 . .00 .00 .00 .0% 106034 5550 U/E TELECM .00 7,000.00 7,000.00 5,004:10 5,560.00 7,000.00 .0% 106034 5810 OP EQP 45,189.64 36,800.00 36,800.00 36,229.30 36,800.00 22,800.00 -38.0% PURPOSE: Purchase of Non -VERF Equipment for Patrol DESCRIPTION: Equipment for Patrol Misc. Equipment - $5,000 Laptop Batteries - $3,000 Citizen Police Academy Supplies - $1,500 Upgrade Patrol Computers - $5,000 Radar Unit - $2,900 Printer - $1,000 Ballistic Vests - $3.000 Rifle Cases - $600 Typewriter - $800 03/28/2005 VILLAGE OF DEERFIELD PAGE 18 10:12:22 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE TOTAL POLICE.DEPT PATROL 3,043,082.56 3,075,771.00 3,075,771.00 2,594,102.38 3,014,793.00 3,274,084.00 6.4% 03/28/2005 VILLAGE OF.DEERFIELD PAGE 19 10:12:22 NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005. 2005 .2005 2006 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------=------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 106061 POLICE DEPT SPEC DETAIL -------------------------------------- 106061 5112 OT SALARY - - - - -- 78,543.67 204,049.00 204,049.00 91,276:79 204,049.00 225,910.00 - 10.7% 106061 5120 MED BNFT 1,344.32 .00 .00 11,927.28 .00 .00 .0% 106061 5121 DNTL BNFT 123.88 .00 .00 1,062.08 .00 .00 .0% 106061 5122 MISC BNFT 910.79 .00 .00 90.73 .00 .00 .0% 106061 5140 PEN CNTRB 234.04 .00 .00 1,577.87 .00 ..00 .0% 106061 5326 VEH MAINT 601.50 .00 .00 .00 .00 .00 .0% 106061 5420 PETR PROD 1,113.44 .00 .00 .00 00 .00 .0% TOTAL POLICE DEPT SPEC DETAI 82,871.64 204,049.00 204,049.00 105,934.75 204;049.00 225,910.00 10.7% TOTAL GENERAL FUND 10,592,592.09 11,972,263.00 11,972,263.00 9,309,783.47 12,023,357.31 16,262,253.10 35.8% GRAND TOTAL 10,592,592.09 11,972,263.00 11,972,263.00 _9,309,783.47 12,023,3.57.31 16,262,253.10 35.8% 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 14:42:01 MOTOR FUEL TAX BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT MOTOR FUEL TAX FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL- ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 142050 MOTOR FUEL TAX EXPENDITURES -------------------------------------------- 142050 5910 STREET IMP 249,999.76 292,000.00 292,000.00. 289,804.12 292,000.00 601,000.00. 105.8% 142050 5930 STRM IMP 24,964.00 20,000.00 20,000.00 .00 .00 .00 - 100.0°% 142050 7.210 TRNSFR OUT 275,000.00 285,000.00 285,000.00. .00 285,000.00 .00 - 100.0°% TOTAL MOTOR FUEL TAX EXPENDI 549,963.76 597,000.00 597,000.00 289,804.12 577,000.00 601,000.00 .7% TOTAL MOTOR FUEL TAX FUND 549,963.76 597,000.00 597,000.00 289,804.12 577,000.00 601,000.00 .7% GRAND TOTAL' 549,963.76 597,000.00 597,000.00 289,804:12 .577,.000.00 601,000.00 .7% 03/28/2005 VILLAGE OF DEERFIELD 15:08:34 EMERG. TELE.. SYSTEM (E911) BUDGET - FY 2005/06 PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION PAGE 1 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT E 911 FUND ----------------------------------------------------------------------------------------------------=--=-=--=--------------=--- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE - - - - -- 176020 E911 FUND EXPENDITURES -------------------------------------------- 176020 5322 EQUP R&M 42,764.84 .00 .00 276.00 .00 .00 .016 176020 5323 RADIO R&M .00 55,000.00 55,000.00 37,694.21 47,500.00 55,000.00 .0% 176020 5370 DP SERV 83,194.44 41,295.00 41,295.00 41,505.00 35,750.00 40,000.00 -3.11 176020 5540 U/E TELEPH 16,356.19 .00 .00 .00 .00 :00 .0% 176020 5550 U/E TELECM .00 69,500.00 69,500.00 48,979.91 57,500.00 69,500.00 .0% 176020 5810 OP EQP 59,446.14 .00 .00 .00 .00 .00 .0°6 176020 5820 RAD EQP 235,471.69 99,500.00 99,500.00 79,027.82 99,000.00 58,500.00. - 41.2°% 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 CML Phone /Radio Upgrade - $30,000 Computer Monitors - $6,000 Misc. computer Equipment - $12,500 New World CAD project - $10,000 176020 7211 TRANS VERF 24,333.00 51,900.00 51,900.00 43,250..00 51,900.00 47,400.00 -8.7% TOTAL E911 FUND EXPENDITURES, 461,566.30 317,195.00 317,195.00 250,732.94 291,650.00 270,400.00 -14.816 TOTAL E 911 FUND 461,566.30 317,195.00 317,195.00 250,732.94 291,65.0.00 270,400.00 -14.8% GRAND TOTAL 461,566.30 317,195.00 317,195.00 250,732.94 291;650.00 270,400.00 -14.8% 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 14:54:25 VEH. & EQUIP. REPLACEMENT FUND BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT VEHICLE & EQUIPMENT REPLACE. ACTUAL ----------------------------------------------------------------------------------------------------------- ORIG BUD REVISED BUD ACTUAL PROJECTION -------- FIN REVIEW - - - - -- ---- CHANGE - - - - -- 211150 VERF EXPENSES -------------------------------------------- 211150 5670 DEPR EXP 162,678.52 .00 .00 .00 00 .00 .0°% 211150 5810 OP EQP 303,507.97 70,000.00 .70,000.00 32,022.17 70,000.00 65,000.00 -7.1% SQUAD CAR EQUIPMENT - $35,000 UPS BATTERIES REPLACEMENT, E911 - $15,000 POLICE DEPT. FILE SERVER - $15,000 211150 5820 RAD EQP .00 170,000.00 170,000.0.0 .00 .00 40,000.00 - 76.5°% MOBILE RADIOS, POLICE 211150 5850 MBL EQP .00 118,000.00 118,000.00 99,599.00 100,000.00 270,000.00 •128.8°% REPLACE SEWER #702 WATERJET - $270,000 211150 5860 MOTOR VEH 270,573.72 187,825.00 187,825.00 148,694:85 187,825.00 385,600.00 105.3% WATER #602 1 TON PU - $48,000 STREET #807 35,000 DUMP - $70,000 POLICE 8 SQUADS @ $27,825 - $222,600 POLICE 1 INV. UNIT @ $25,000 ADDITIONAL SERVICE VEHICLE, TREATMENT PLANT - $20,0'00 TOTAL VERF EXPENSES 736,760.21 545,825.00 545,825.00 280,316.02 357,825.00 760,600.00 39.3% TOTAL VEHICLE & EQUIPMENT RE 736,760.21 545,825.00 .545,825.00 280,316.02 357,825.00 .760,600.00 39.3°% GRAND TOTAL 736,760.21 545,825.00 545,825.00 280,316.02 357,825.00 760,600.00 39.3% 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 14:51:58 INFRASTRUCTURE REPLACEMENT BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT INFRASTRUCTURE REPLACEMENT ACTUAL ORIG BUD ------------------------------------------------------------------------------------------------------------------------------------ REVISED BUD ACTUAL _PROJECTION FIN REVIEW CHANGE 222082 INFRA REPLACE FUND EXPENDITURE -------------------------------------------- 222082 5362 P/S ENG 103,316.31_ 333,000.00 333,000.00 306,644.98 333,000.00 833,400.00. 150.3% STREET REHAB PROGRAM - $50,000 DEERFIELD RD PROJECT - $64,000 FOR PH3 WILMOT RD SOUTH - $300,000 (GRANT DEPENDENT) DEERFIELD RD SIDEWALK EAST OF ROSEMARY - $9,400 STRATFORD RD PROJECT - $260,000 ROSEMARY PROJECT - $150,000 222082 5910 STREET IMP 592,593.93 1,451,000.00 1,451,000.00 783,816.61 780,000.00 3,114,000.00 114.6% STREET REHAB - $630,000 STRATFORD RD PROJECT — $1,565,000 DEERFIELD RD PROJECT - $919,000 222082 5911 SDWLK IMP 449,.700.00 450,000.00 450;000.00 461,209.20 463,000.00 450,000.00 .0% SIDEWALK & CURB REPLACEMENT PROGRAM - $450,000 TOTAL INFRA REPLACE FUND EXP 1,145,610.24 2,234,000.00 2,234,000.00 1,551,670.79 1,576,•000.00 4,397,400.00 96.8% TOTAL.INFRASTRUCTURE REPLACE 1,145,610.24 2,234,000.00 2,234,000.00. 1,551,670.79 1,576,000.00 4,397,400.00 96.8% GRAND TOTAL 1,145,610.24 2,234,000.00 2,234,000.00 1,551,670.79 1,576,000.00 4,397,400.00 96.8% 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 14:48:01 LAKE COOK ROAD TIF DISTRICT BUDGET - FY 2005/0.6 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT LAKE COOK RD TIF (TIF 1) ACTUAL ORIG BUD. REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE -------- - ----------------------------------------------------- ------------------------------------------------- - -------------- - - - - -- 251180 TIF 1 EXPENSES ..00 .0% -----------=-------------------------------- 251180 5365 P/S OTHER 20,480.28 .00 251180 5390 OTHER .00 9,700,000.00 .00 THE LAKE COOK ROAD TIF DISTRICT TERMINATED ON 12/31/04. .00 FINAL ACTIVITY WILL BE TO CONTINUE TO DISTRIBUTE THE 59,355.88 INCREMENT TO'THE TAXING DISTRICTS. - 100.0°% 251180 5610 OTH EXPENS 9,654,786.39 .00 251180 5611 PMTS OTHR 1,370,008.91 .00 251180 5950 BLDNG IMP 47,059.15 75,000.00 TOTAL TIF 1 EXPENSES 11,092,334.73 9,775,000.00 TOTAL LAKE COOK RD TIF (TIF 11,092,334.73 9,775,000.00 GRAND TOTAL 11,092,334.73 9,775,000.00 .00 .00, .00. ..00 .0% 9,700,000.00 5,699,496.00 10,165,000.00 11,500,000.00_ 18.6% .00 .00 .00 .00 .0% .00 .00 .00 .00 .0% 75,000.00 59,355.88 .75,000.00 .00 - 100.0°% 9,775,000.00 5,758,851.88 10,240,000.00 11,500,000.00 17.6% 9,775,000.00 5,758,851.88 10,240,000.00 11,500,000.00 17.6% 9,775,000.00 5,758,851.88 10,240,000.00 11,500,000.00 17.6% 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 14:48:32 VILLAGE CENTER TIF'DISTRICT BUDGET - FY 2005%06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT VILLAGE CENTER TIP (TIF 2) ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 261180 TIF 2 EXPENSES -------------------------------------------- 261180 5321 STRUC R&M 37,154.41: .00 .00 .00 .00 .00 .0% 261180 5322 EQUP R&M .00 50,000.00 50,000.00 10,620.00 50,000.00 50,000.00 .0% 261180 5362 P/S ENG 18,146.55 338,000.00 338,000.00 195,069.45 200,0.00.00 10,000.00 -97.0% BALANCE OF OSTERMAN /WAUKEGAN INTERSECT IMPROVEMENTS 261180 5365 P/S OTHER 91,592.27 100,000.00 100,000.00 5,145.32 100,000.00 200,000:00 100.0% . ARCHITECTURAL FEES FOR VILLAGE HALL EXPANSION - $200,000 261180 5390 OTHER 1,715.00 80,000.00 80,000.00 18,655.00 80,000.00 85,000.00 6.3% STREETSCAPE MAINTENANCE & REPLACEMENT 261180 5510 U/E ELECT 2,260.90 800,000.00 .00 .00 .00 .00 .0% 261180 5610 OTH EXPENS 579.60 .00 .00 .00 .00 .00 .0% 261180 5910 STREET IMP .00 .00 800,000.00 549,284.44 560,000.00 25,000.00 -96.9% BALANCE OF WAUKEGAN /OSTERMAN IMPROVEMENTS LANDSCAPING AT BANK FINANCIAL - 261180 5911 SDWLK IMP 25,025.27 .00 .00 .00 .00 .0.0 .09. 261180 5914 STRSCP IMP .00 820,000.00 820,000.00 328,117.92 350,000;00 15,000.00 -98.2% OTHER STREETSCAPE IMPROVEMENTS 261180 5950 BLDNG IMP 324,764.69 1,300,000.00 1,300,000.00 950,862.37 1,300;000.00 2,300,000.00 76.9% CONSTRUCTION COSTS OF VILLAGE HALL EXPANSION - $2,000,000 FACADE REBATE PAYMENTS - $300,000 261180 5960 LAND ACQ 1,150,068.22 150,000.00 150,000.00 127,589.38 127,589.38 .00 - 100.0% 261180 7210 TRNSFR OUT 1,769,550.00 1,941,750.00 1,941,750.00 1,737,000..00 1,941,750.00 1,877,250.00 -3.3% DEBT SERVICE EXPENSES FOR 1998 ISSUE: TOTAL TIP 2 EXPENSES 3,420,856.91 5,579,750.00 5,579,750.00 3,922,343.88_ 4,709.;339.38 4,562,250.00 -18.2% TOTAL VILLAGE CENTER TIF (TI 3,420,856.91 5,579,750.00 5,579,750.00 3,922,343.88 4,709,339.38 4,562,250.00 -18.2% GRAND TOTAL 3,420,856.91 5,579,750.00 5,579,750.00 3,922,343.88 4,709,33.9.38 4,562,250.00 - 18.2 %. 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 15:03:58 PROJECT 29 BUDGET - FY 2005/06- bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT PROJECT 29 FUND ------------------------------=------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 299999 PROJECT 29 EXPENDITURES -------------------------------------------- 299999 5390 OTHER .00 500.00 500.00 .00 .00 500.00 .0% TOTAL PROJECT 29 EXPENDITURE .00 500.00 500.00 .00 .00 500.00 .0% TOTAL PROJECT 29 FUND .00 500.00 500.00 .00 .00 500.00 .0% GRAND TOTAL .00 500.00 500.00 .00 .00 500.00 .0% 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 14:45:42 DEBT SERVICE FUND BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005/06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT DEBT SERVICE FUND ------------------------------------------------------------------------------------------------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 357070 DEBT SERVICE EXPENSE -------------------------------------------- 357070 5760 D/S FA FEE 300.00 .00 .00 .00 00 .00 .016 TOTAL DEBT SERVICE EXPENSE 300.00 .00 .00 .00 .00 00 .0% 03/28/2005 VILLAGE OF DEERFIELD PAGE 2 14:45:42 DEBT SERVICE FUND BUDGET - FY,2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT DEBT SERVICE ----------------------------------------------------------------------------------------=------------------------------------------- FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 357071 DEBT SERVICE 1997 EXP -------------------------------------------- 357071 5710 D/S INTER 269,250.00 158,432:00 158,432.00 .00 .00 .00 - 100.0% 357071 5730 D/S PRINC 1,500,000.00 330,000.00 330,000.00 00 .00 .00 - 100.0°% THIS ISSUE IS BEING SERVICED IN THE WATER FUND. 357071 5760 D/S FA FEE 300.00 1,000.00 1,000.00 600.00 .00 .00 - 100.0°% TOTAL DEBT SERVICE 1997 EXP 1,769,550.00 489,432.00 489,432.00 600.00 .00 .00 - 100.0% 03/28/2005 VILLAGE OF DEERFIELD PAGE 3 14:45:42 DEBT SERVICE FUND BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT DEBT SERVICE FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 357072 DEBT SERVICE 1998 EXP -------------------------------------------- 357072 5710 D/S INTER 326,400.00 441,750.00 4.41,750.00 237,000.00 441,750._00 345,000.0.0 -21.9% 357072 5730 D/S PRINC 1,250,000.00 11500,000.00 1,500,000.00 1,500,000.00 1,500,000.00 2,000,000.00 33.3% 357072 5760 D/S FA FEE 1,033.00 1,000.00 1,000.00 300.00 1,000.00 1,000.00 .0% TOTAL DEBT SERVICE 1998 EXP 1,577,433.00. 1,942,750.00 1,942,750.00 1- ,737,300.00 1,942,750.00 2,346,000.00 20.8% 03/28/2005 VILLAGE OF DEERFIELD PAGE 4 14:45:42 DEBT SERVICE FUND BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT DEBT SERVICE FUND ------------------------------------------------------------------------------------------------------------------=---=------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 357073 DEBT SERVICE 2002 EXP -------------------------------------------- 357073 5710 D/S INTER .00 39,400.00 39,400.00 39,400.00 39,.400.00 .00 - 100.0% 357073 5730 D/S PRINC .00 985,000.00 985,000.00 985,00,0.00 985,000,:00 .00 - 100.0% THIS ISSUE WAS RETIRED WITH THE PAYMENTS MADE IN FY 04/05. 357073 5760 D/S FA FEE 1,200.00 1,500.00 1,500.00 200.00 1,500.00 .00 - 100.0% TOTAL DEBT SERVICE 2002 EXP 1,200.00 1,025,900.00 1,025,900.00 1,024,600,.00 1,025,900.00 .00 - 100.0% 03/28/2005 VILLAGE OF DEERFIELD PAGE 5 14:45:42 DEBT SERVICE FUND BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT DEBT SERVICE FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 357074 DEBT SERVICE 2003 EXP -------------------------------------------- 357074 5710 D/S INTER .00 95,158.00 95,158.00 .00 .00 .00 - 100.0% 357074 5730 D/S PRINC .00 40,000.00 40;000.00 ..00 .00 .00 .- 100.0% THIS ISSUE IS BEING SERVICED IN THE WATER FUND. 357074 5760 D/S FA FEE 200.00 1,500.00 1,500.00 200.00 .00 .00 - 100.0% TOTAL DEBT SERVICE 2003 EXP 200.00 136,658.00 136,658.00 200.00 .00 00 - 100.0% TOTAL.DEBT SERVICE FUND 3,348,683.00 3,594,740.00 3,594,740.00 2,762,700.00 2,968,650.00 2,,346,000.00 -34.7% GRAND TOTAL 3,348,683.00 3,594,740.00 3,594,740.00 2,762,700.00 2,968;650.00 2,346,000.00 -34.7% 03/28/2005 VILLAGE OF DEERFIELD 14:40:37 WATER FUND BUDGET FY 2005/06 PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION PAGE 1 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT WATER FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 502010 WATER DEPARTMENT ADMINISTRATIO -------------------------------------------- 502010 5110 REG SALAR 89,062.82 160,400.00 160,400.00 99,227.34 160,400.00 160,000.00 -.2% WATER SUPERVISOR 1 EMPLOYEE 1/4 DIRECTOR, 1/3 PW & ENG. SECRETARY 502010 5111" PT SALARY 7,794.66 -8,000.00 8,000.00 7,576.60 8,000.00 8,000.00 .0% 502010 5112 OT SALARY 239.50 3,000.00 3,000.00 2,489.07 .3,000.00 31000.00 .0% 502010 5120 MED BNFT 15,189.93 24,750.00 24,750.00 11,129.44 24,750.00 24,750.00 .0% 502010 5121 DNTL BNFT 174.44 2,750.00 2,750.00 1,261.73 2,750.00 2,750.00 .0% 502010 5122 MISC BNFT 2,301.43 200.00 200.00 262.78 200.00 200.00 .0% 502010 5130 APPAREL 3,932.84 4,500.00 4,500.00 4,333.58 4,500.00 6,000.00 33.3% 502010 5140 PEN CNTRB 17,335.58 25,600.00 25,600.00 17,928.68 25,600.00 27,400.00 7.0% 502010 5211 TRNG TRAV 15.00 400.00 400.00 50.00 400.00 .00 - 100.0% 502010 5213 SUBSCRIPT .00 200.00 200.00 51.50 200.00 200.00 .0% 502010 5320 BLDG R&M 6,827.73 6,000.00 6,000:00 6,251.32 6,000.00 8,500..00 41.7% 502010 5322 EQUP R&M 3;762.66 7,500.00 7,500.00 1,550.00 21500.00 4,000.:00 -46.7% 502010 5326 VEH MAINT 1,529.00 3,000.00 3,000.00 1,092.00 3,000.00 - 3,500.00 16.7 %. 502010 5330 DUES 185.00 100.00 100.00 127.00 100.0.0 100.00 .0°% 502010 5332 TRAV EXP 700.00 1,000.00 1,000.00 .00 . 1,000.00 300.00 -70.0% 502010 5335 PRINTING 1,968.43 5,000.00 5,000.00 5,092.44 6,000.00 7,000.00.- 40.0% 502010 5337 POSTAGE 2,934.32 3,800.00 3,800.00 5,527.40 7,000.00 7,000.00 84.216 502010 5350 INS GL 53,788.95 74,500.00 74,500.00 67,638.46 74,500.00 78,225.00 5.0% 502010 5351 INS DED 178.08 .00 ..00 .00 .00 ..00 .0% 502010 5362 PIS ENG .00 3,000.00 3,000.00 1,424.88 3,000.00 6,000:00 100.0% 502010 5363 PIS MEDIC .00 .00 .00 102.00 .00 1,100..00 .0% 502010 5365 PIS OTHER .00 .00 .00 .00 .00 1,500.00 .0% 502010 5370. DP SERV 887.52 2,000.00 2,000.00 1,174.88 2,000.00 2,000.00 .0% 502010 5410 MISC SUPP 1,579.07 2,200.00 2,200.00_ 2,722.37 2,200.00 3,000.00 36.4°% 502010 5420 PETR PROD 943.62 1,900.00 1,900.00 1,237.00 1,900.00 2,185.00 15.0% 502010 5450 OFF SUPP 128.33 550.00 550.00 474.05 550.00. 550.00 .0% 502010 5460 OPER SUPP 560.15 300.00 300.00 518.42 300.00 300.00 .0% 502010 5470 R&M SUPP .00 300.00 300.00 148.75 300.00 300:00 .0% 502010 5540 U/E TELEPH 13,947.22 16,000.00 16,000.00 12,532.99 16,000.00 16,000.00 .0% 502010 5560 U/E OTHER 421.73 .00 .00 .00 .00. ..00 .0% 502010 5670 DEPR EXP 275,780.30 .00 .00 .00 .00 .00 .0°% 502010 5710 D/S INTER 135,352.66 109,843.00 109,843.00 .00 109,843.00 109,843.00 .01 502010 5730 D/S PRINC .00 340,000.00 340,000.00 .00 340,000..00 340;000.00 .0% 502010 5810 OP EQP .00 .00 .00 .00 .00 2,000.00 .0% 1/3 OF $6,000 FOR COPY.MACHINE 502010 7211 TRANS VERF 37,104.98 38,568.00 38,568.00 32,140.00 38,568.00 41,527.00 7.7% TOTAL WATER DEPARTMENT ADMIN 674,625.95 845,361.00 845,361.00 284,. 064.68 844,561.00 867,230.00 2.6% 03/28/2005 VILLAGE OF DEERFIELD- PAGE 2 14:40:37 WATER FUND BUDGET FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006. PCT WATER FUND -------------------------------------------------------------------------------------------------------=---------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 502031 WATER DEPT DISTRIBUTION ----------------------------------- 502031 5110 REG SALAR- 96,399.56 59,000.00 59,000.00 37,488.78 59,000.00 61,000:00. 3.4% 502031 5112 OT SALARY 13,237.62 10,000.00 10,000.00 10,182.64 10,000.00 .10,000.00 .0% 502031 5120 MED BNFT 19,832.45 25,260.00 25,260.00 8,963.66 .12,000.00 15,000..00 - 40.6 %, 502031 5121 DNTL BNFT 214.02 2,640.00 2,640.00 812.16 2,640.00- 2,640.00 .0% 502031 5122 MISC BNFT 43.44 .00 .00 125.08 .00 .00 .0% 502031 5140 PEN CNTRB 22,605.25 36,500.00 36,500.00 7,752.43 12,.000.00 15,000.00 -58.91 502031 5320 BLDG R&M .00 1,900.00 1,900.00 .00 1,900.00 1,900.00 0% 502031 5322 EQUP R&M 7,855.12 19,000.00 19,000.00 11,285.97 _19,000.00 19,000.00,. .0% 502031 5326 VEH MAINT 3,507.30 4,000.00 4,000.00 2,067.00 4,000.00 4,400.00 10.0°% 502031 5335 PRINTING .00 800.00 800.00 .00 800.00 800.00 .0% 502031 5362 P/S ENG 6,988.74 218,000.00 218,000.00 19,268.84 30,000.00 80,000.00 -63.3% ELEVATED TANK INSPECTION $7,000 ELEVATED TANK PAINTING ENGINEERING $50,000 RICHFIELD PUMP STATION ENGINEERING $23,000 502031 5365 P/S OTHER 6,010.00 8,700.00 8,700.00 3,280.48 81700.00 8,800.00 1.1% 502031 5390 OTHER 4,110.00 .00 .00 275.00 .00 .00 .0% 502031 5410 MISC SUPP 174.32 600.00 600.00 176.02 600.00 600.00 .0% 502031 5420 PETR PROD 630.25 2,500.00 2,500.00 493.08 2,500.00 2,875.00 15.0% 502031 5421 MATERIAL 4,201.49 3,500.00 3,500.00 3,091.84 3,500.00 3,500.00 .0% 502031 5422 CHEMICAL .00 500.00 500.00 .00 .500.00 500.00 .0% 502031 5423 BUY WATER 2,062,011.49 2,047,500.00 2,047,500.00 1,604,404.80 2,047,500.00 2,121,210.00 3.6% HIGHLAND PARK HAS NOTIFIED VILLAGE OF A 3.6% INCREASE IN THEIR WHOLESALE CHARGE FOR WATER. 502031 5460 OPER SUPP 236.51 700.00 700.00 638.20 700.00. 700.00 .0 %. 502031 5510 U/E ELECT 80,479.48 80,000.00 80,000.00 53,651.54 60.,000.00 80,0.00.00 .0% 502031 5520 U/E NAT GA 101.03 2,200.00 2,200.00 .00 .2,200.00 2,200.00 .0% 502031 5810 OP EQP .00. .00 .00 .00 .00 48,500.00 .0% SCADA SYSTEM COMPUTER UPGRADE $8,500 SCADA SYSTEM FOR HAWTHORNE $20,000 ALARMS ON HATCHES FOR RESERVOIRS (HOMELAND SECURITY) $20,000 502031 5920 WTRSYS IMP 102,202.54 .00 .00 102,-416:90 .00 .00 0% 502031 5921 WTRSUP IMP 13,992.15 500,000.00 500,000.00 .00 .00 234,000.00 -53.2% RICHFIELD PUMP STATION - $234,000 TOTAL WATER DEPT DISTRIBUTIO* 2,444,832.76 3,023,300.00 3,023,300.00 1,866,374.42 2,297,540.00 2,712,625-.00 -10.3% 03/28/2005 VILLAGE OF DEERFIELD 14:40:37 WATER FUND BUDGET FY 2005/06 PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION PAGE 3 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2004 - 2005 2005 2005 2005 2006 PCT WATER FUND ACTUAL --------------------------------------------- =--------------------------------- ORIG BUD REVISED BUD ------------------------------------------- ACTUAL PROJECTION FIN REVIEW ---------- CHANGE 502050 WATER MAIN MAINTENANCE -------------------------------------------- 502050 5110 REG SALAR 175,318.30 179,000.00 179,000.00 161,181.44 179,000.00 185,000.00 3.4% 502050 5111 PT SALARY 6,269.75. 10,000.00 10,000.00 2,888.00. 10,000.00 10,000.00 .0°% 502050 5112 OT SALARY, 73,592.00 62,100.00 62,100.00 56,223.82 62,100.00 62,100.00 .0% 502050 5120 MED BNFT 36,773.78 29,030.00 .29,030.00 .45,098.74 48,000.00 52,000.00 79.1°% 502050 5121 DNTL BNFT. 697.42 2,970.00 2,970.00 3,826.86 3,800.00 4,200.00 41.4% 502050 5122 MISC BNFT 117.46 .00 .00 646.86 .00 .00 .0% 502050 5140. PEN CNTRB 29,455:67 32,300.00 .32,300.00 36,882.21 40,000.00 44;000.00 36.2°% 502050 5310 RENT EQP 2,289.64 4,000.00 4,000.00 1,899..70 4,000.00 4,000.00 .0% 502050 5321 STRUC R&M .00 1,400.00 .1,400.00 715.00 1;400.00 1,400.00 .0% 502050 5322 EQUP R&M 40,960.00 10,000.00 87,000.00 16,.051.26 10;000.00 10,000.00 -88.5% 502050 5326 VEH MAINT 25,832.80 27,000.00 27,000.00 28,999.00 27,000.00 29,700.00 10.0% 502050 5362 P/S ENG 38,994.76 410,000.00 410,000.00 217,152.24 250,000.00 132,000.00 -67.81 ENGINEERING FOR ANNUAL WM REPLACEMENT PROJECTS AMBLESIDE - DIMMEYDALE ENGINEERING = $60,000 FUTURE WM REPLACEMENT ENGINEERING = $40,500 COMPLETE CENTRAL AVE WM ENGINEERING = $5,000 DEERFIELD RD. / WILMOT RD. WM ENGINEERING = 20,000 MISC. $6,500 502050 5365 P/S OTHER .00 137,900.00 10,900.00 37,499.85 50,000.00 112,000.00 927.5% HYDRANT PAINTING $20,000 LEAK SURVEY $11,000 LANDSCAPER $20,000 .VALVE REPAIR $22,000 VALVE EXERCISING $25,000 MAIN REPAIRS $14,000. 502050 5390 OTHER 6,965.00 .00 50,000.00 13,562.46 .00 50,000.00 .0% SPOIL REMOVAL FROM STORAGE YARD ANNUAL PROGRAM DURATION 10 -15 YEARS = $10,000 EACH SPOIL REMOVAL STORAGE YARD SPECIAL FOUR YEARS EACH $40,000 502050 5410 MISC SUPP 4,502.90 4,000.00 4,000.00 4,697.95 '5,000.00 2,000.00 -50.0% 502050 5420 PETR PROD 3,068.09 4,000.00 4,000.00 4,420.11 4,600.00 4,900.06 22.5% 502050 5421 MATERIAL 149,743.71 148,000.00 148,000.00 147,008.27 170,000.00 170,000.00 14.9°% 502050 5440 SMTLSEQUP 190.59 800.00 800.00 694.02 800.00 1,200.00 50.0% 502050 5810 OP EQP 4,078.34 4,000.00 4,000.00 3,810.65 4,000.00 37,000.00 825.0 %' MINI EXCAVATOR $25,000/ 50% OF $50K TO SPLIT WITH SEWER DEPT VALVE OPERATOR $6,000 DEWATERING PUMP $1,500 GENERATOR $1,500 MISC. $3,000 502050 5920 WTRSYS IMP .00 700,000.00 1700,000.00 569,414.48 700,00.0.00 995,000.00 42.1°% AMBLESIDE - DIMMEYDALE CONSTR = $300,000 FINISH CENTRAL AVENUE CONSTRUCTION = $45,000 DEERFIELD /WILMOT ROADS WATERMAIN = $650,000 DEERFIELD /WILMOT ROADS WATERMAIN = $650,000 03/28/2005 VILLAGE OF DEERFIELD PAGE 4 14:40:37 WATER FUND BUDGET FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR.PERIOD 13 ACCOUNTS FOR: 2004 2005 .2005 2005 2005 2006 PCT WATER FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE TOTAL WATER MAIN MAINTENANCE 598,850.21 1,766,500.00 1,766,500.00 . 1,352,672.92 1,569,700.00 1,906,500.00 7.90 03/28/2005 VILLAGE OF DEERFIELD PAGE 5 14:40:37 WATER FUND BUDGET FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT WATER FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 502054 WATER METER MAINTENANCE 502054 5110 REG SALAR 81,935.71 104,700.00 104,700.00 75,556.06 104,700.00 104,700.00 .0% 502054 5111 PT SALARY .00 1,500.00 1,500.00 .00 .00 1,500.00 .0% 502054 5112 OT SALARY 265.58 1,300.00 1,300.00 3,000.00 3,000 :00 130.8% 502054 5120 MED BNFT 18,565.18 21,130.00 21,130.00 .'2,290.59 13,805.95 21,130.00 21,130.00 .0% 502054 5121 DNTL BNFT 340.81 1,870.00 1,870.00 1,335.79 1,.870.00 1,870.00 .0°% 502054 5122 MISC BNFT 54.43 .00 .00 246.67 350.00 500.00 .0% 502054 5140 PEN CNTRB 12,832.07 17,700.00 17,700.00 13,.201.59 17,700.00 19,000.00 7.3% 502054 5322 EQUP R&M 375.50 2,600.00 2,600.00 328.00 500.00 1,500.00 -42.3% 502054 5326 VEH MAINT 2,376.00 4,000.00 4,000.00 849.00 4,000.00 4,400.00 10.0 %. 502054 5332 TRAV EXP .00 200.00 200.00 .00 200.00 300.00 50.0% 502054 5335 PRINTING .00 300.00 300.00 .00 300.00 300.00 .0 %. 502054 5365 P/S OTHER 950.00 2,000.00 2,000.00 126.45 2,000.00 2,000.00 .0°% 502054 5410 MISC SUPP .00 500.00 500.00 .00 500.00 500.00 .0% 502054 5420 PETR PROD 1,078.97 1,800.00 11800•..00 1,103.66 1,800.00 2,070.00, 15.0°% 502054 5421 MATERIAL 3,499.96 6,000.00 6,000.00 3,493.28 6,000.00 6,000.00 .0°% 502054 5440 SMTLSEQUP .00 100.00 100.00 .00 100:00 100.00 .0°% 502054 5810 OP EQP 43,364.72 65,000.00 65,000.00 60,239.99 65,000.00 87,000.00 33.8% PURCHASE OF WATER METERS'$85,000 INCREASE IN METER SIZE 1 1/2 AND 2 INCH METERS BEING BOUGHT INCREASED BUDGET FROM 04/05 COMPUTER SOFTWARE /ORION UPGRADES - $2,000 TOTAL WATER METER MAINTENANC 165,638.93 230,700.00 230,700.00 172,577.03 229,150.00 255,870.00 10.9% TOTAL WATER FUND 3,883,947.85 5,865,861.00 5,865,861.00 3,675,689.05 4,940,951.00 5,742,225.00 -2.1% GRAND TOTAL 3,883,947.85 5,865,861.00 5,865,861..00 3,675,689.05 4,940,951.00 5,742,225.00 -2.1% 03/28/2005 VILLAGE OF DEERFIELD 14:41:10 SEWER FUND BUDGET - FY 2005/06 PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION PAGE 1 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005- 2006 PCT SEWER FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 542010 SEWER ADMINISTRATION -------------------------------------------- 542010 5110 REG SALAR 126,586.52 159,200.00 159,200.00 122,165.89 159,200.00 159,200.00. 0% 542010 5111 PT SALARY 7,796.33 7,500.00 7,500.00 6,966.60 7,500.00 7,500.00 .0:% 542010 5112 OT SALARY 932.40 3,000.00 3,000.0 0 1,833.65 3,.000.00 3,000.00 .0% 542010 5120 MED BNFT 18,557.81 24,800.00 24,800.00 14,605.18 .24;800:00 24,800.00 .0% 542010 5121 DNTL BNFT . 261.36 2,800.00 2,800.00 1,341.87 2,800.00 2,800.00 .0% 542010 5122 MISC BNFT 11,538.90 300.00 300.00 936.93 300.00 300:00 .0% 542010 5130 APPAREL 2,595.99 3,200.00 3,200.00 4,089.05 4,000.00 5,500.00 71.916 542010 5140 PEN CNTRB 20,838.44 28,200.00 28,200.00 20,961.20 28,200.00 30,200:00 7.1% 542010 5211 TRNG TRAV 655.36 .00 .00 35.00 00 200.00 .0°% 542010 5213 SUBSCRIPT .00 200.00 200.00 62.00 200.00 200.00 .0% 542010 5320 BLDG R&M 5,696.00 5,000.00 5,000.00 4,272.64 5,000.00 7,500.00 50.0% 542010 5322 EQUP R&M 5,444.67 9,300.00 9.,300.00 1,048:00 .2,000.00 6,500.00 -30.1% 542010 5326 VEH MAINT 1,885.50 3,000.00 3,000.00 1,113.00 3,000.00 3,300.00 10.0°% 542010 5332 TRAV EXP .00 400.00 400.00 358.00 400.00 300.00 -25.0% 542010 5335 PRINTING 590.51 4,000.00 .4,000.00 .1,999.24 3,000.00 4,000..00 :0% 542010 5337 POSTAGE 3,631.34 4,200.00 4,200.00 2,844:74 4,200.00 4,200.00 .0% 542010 5350 INS GL 61,979.36 110,000.00 110,000.00 97,595.14 110,000.00 115,500.00 5.0% 542010 5351 INS DED 1,000.00 .00 .00 .00 .00 .00 .0% 542010 5362 P/S ENG .00 20,000.00 20,000.00 .00 20,000.00 10,000.0.0 -50,0% 542010 5363 P/S MEDIC 40.00 200.00 200.00 373.00 450.00 1,000.00 40.0.0% 542010 5370 DP SERV 337.46 2,000.00 2,000.00 1,783.27 2,000.00 2,000.00 .0% 542010 5410 MISC SUPP 1,519.27 2,300.00 2,300.00 1,717.66 2,300.00 2,300.00 .0% 542010 5420 PETR PROD 1,316.01 2,200.00 2,200.00 1,438.27 2,200.00 2,530, 00 15.0% 542010 5450 OFF SUPP 302.13 400.00 400.00 640.51 400.00 500.00 25.0% 542010 5460 OPER SUPP 316.07 1,000.00 1,000.00 612.89 1,000.00 1,000.00 .0% 542010 5540 U/E TELEPH 4,472.04 4,800.00 4,800.00 3,507.40 4,.800.00 4,800.00 .0% 542010 5560 U/E OTHER 271.76 .00 .00 .00 .00 00 0% 542010 5670 DEPR EXP 101,607.33 .00 .00 .00 .00 .00 0. °% 542010 5810 OP EQP .00 .00 .00 .00 .00 .2,000.00 .0% 1/3 OF $6,000 FOR COPY MACHINE 542010 7211 TRANS VERF 35,147.02 37,725.00 37,725.00 31,438.00 37,725.00 47,729.00 26.5% TOTAL SEWER ADMINISTRATION 415,319.58 435,725.00 435,725.00 323,741.13 428,475.00 448,859.00 3.0% 03/28/2005 VILLAGE OF DEERFIELD PAGE 2 14:41:10 SEWER FUND BUDGET - FY 2005/06 bgnyxpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: .2004 2005 2005 2005 2005 2006 PCT SEWER FUND -------------------------------------------------------------------=---------------------------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 542031 SEWER LINE CONSTRUCTION 542031 5110 REG SALAR 88,428.41 101,100.00 101,100.00 129,324.27 140,000.00 145,000.00 _ 43.4 %. 542031 5111 PT SALARY 5,578.09 4,000.00 4,000.00 5,426.00 6,000:00 5,000.00 25.0% 542031 5112 OT SALARY 5,798.77 5,000.00 5,000.00 6,018.68 7,000.00 7,000.00 40.0% 542031 5120 MED BNFT 24,910.38 28,000.00 28,000.00 23,404.07 28,000.00 29,400.00 5.0 %' 542031 5121 DNTL BNFT 277.62 2,800.00 2,800.00 21080.87 2,800.00 3,080.00 10.0% 542031 5122 MISC BNFT 54.17 500.00 500.00 459.54 .500.00 500.00 .0% 542031 5130 APPAREL .00 500.00 500.00 74.39 200.00 .00 - 100.0% 542031 5140 PEN CNTRB 16,888.67 25,300.00 25,300.00. 23,285.06 34,000.00 36,400.00 43.9% 542031 5310 RENT EQP 374.80 5,000.00 5,000.00 2,071.35 3,000.00 5,000.00 .0% 542031 5321 STRUC R&M .00 14,000.00 14,000.00 1,487.60 5,000.00 14,000.00 .0% 542031 5322 EQUP R&M 3,143.00 9,000.00 9,000.00 18,830.89 9,000.00 9,000:00 .0% 542031 5326 VEH MAINT 12,778.30 15,000.00 15,000.00 18,045.60 .15,000.00 16,500.00 10.0% 542031 5362 P/S ENG .00 .00 .00 .00 .00 285,000.00 .0% INFLOW AND INFILTRATION STUDY 542031 5390 OTHER 93,343.00 .00 .00 237.50 .00 .00 .0% 542031 5420 PETR PROD 4,656.81 5,700.00 5,700.00 5,475.80 5,900.00 6,555.00 15.0% . 542031 5421 MATERIAL 64,811.99 70,000.00 70,000.00 38,098.87 50,000.00 70,000.00 .0% 542031 5440 SMTLSEQUP .00 200.00 200.00 116.25 200.00 1,000.00 400.0% 542031 5460 OPER SUPP .00 1,200.00 1,200.00 .1,188.50 .'1,200.00 1,200.00 .0% 542031 5940 SANSWR IMP .00 80,000.00 80,000.00. 80,000.00 80,000.00 1,780,000.00 2125.0% SEWER LINING AT VARIOUS LOCATIONS - $100,000 SEWER LINING VARIOUS LOCATIONS - $100,000 WARWICK RD. STORM STATION - $185,000 DEERFIELD RD. LIFT & STORM STATION - $215,000 DEERBROOK LIFT STATION REPLACE. - $265,000 NORTH AVE. LIFT STATION REPLACE. - $375,000 ,EAST SIDE LIFT STATION REHAB. - $640,000 TOTAL SEWER LINE CONSTRUCTIO 321,044.01 367,300.00 367,300.00 355,625.24 387,800.00 2,414,635.00 557.4% 03/28/2005 VILLAGE OF DEERFIELD 14:41:10 SEWER FUND BUDGET -.FY 2005/06 PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION PAGE 3 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT SEWER FUND =------------------------------------------------------------------=---------------------------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW'CHANGE 542051 SEWER CLEANING ' -------------------------------------------- 542051 5110 REG SALAR 126,143.88 162,800.00 162,800.00 72,294.28 75,000.00 100,000.00 -38.6% 542051 5111 PT SALARY 14,308.52 9,000.00 91000.00 1,536.00 3,000'.00 91000.00 .0% 542051 5112 OT SALARY 13,673.94 15,600.00 15,600.00 7,027.93 15,600.00 15,600.00 .0% 542051 5120 MED BNFT 16,029.41 22,200.00• 22,200.00 15,766.85 22,200.00 22,200.00 .0% 542051 5121 DNTL BNFT 275.80 2,300.00 2,300.00 1,527.08 2,300.00 2,300.00 .0% 542051 5122 MISC BNFT 52.27 .00 .00 260.33 400.00 . 50.0.00 .0% 542051 5140 PEN CNTRB 13,234.21 22,000.00 22,000.00 13,561.61 19,000.00 20,000..00 -9.1% 542051 5310 RENT EQP 795.00 4,000.00 4,000.00 .00 2,000.00 4,000.00 .0% 542051 5322 EQUP R&M 13,223.20 6,000.00 6,000.00 2,046.50 3,000.00 61000.00 .0% 542051 5326 VEH MAINT 8,365.35 10,000.00 10,000.00 3,977.00 101000.00 11,000.00 10.0% 542051 5362 P/S ENG .00 192,000.00 192,000.00 .00 35,000.00. .00 - 100.0% INFLOW AND INFILTRATION STUDY •SANITARY SEWER EVALUATIONS 542051 5365 P/S OTHER .00 24,000.00 24,000.00 10,704.27 24,000.00 24,000.00 .0% 542051 5410 MISC SUPP 978.31 2,500.00 2,500.00 2,664.76 2,500.00 2,500.00 .0% 542051 5420 PETR PROD 621.79 1,900.00 1,900.00 694.80 1,900.00 2,185.00. 15.0% 542051 5421 MATERIAL 9,334.03 15,000.00 15,000.00 7,964.30 10,000.00 15,000.00 .0% 542051 5440 SMTLSEQUP 226.88 600.00 600.00 .00 600.00 3,200.00 433.3% 542051 5450 OFF SUPP 2,004.24 7,000.00 .00 .00 .00 .00 .026 542051 5460 OPER SUPP .00 .00 7,000.00 2,262.44 4;000.00 7,000.00 .0% 542051 5470 R&M SUPP 7,801.92 10,000..00 10,000.00 3,817.64 51000.00 10,000.00 .0% 542051 5810 OP EQP 1,283.33 .00 MINI EXCAVATOR - $25,000 / 50% OF $50K SPLIT WITH WATER DEPT ENCLOSED TRAILER FOR SEWER TELEVISING CAMERA - $5,000 542051 5850 MBL EQP .00 38,000.00 TOTAL SEWER CLEANING 00 38,000.00 228,352.08 544,900.00 1 544,900.00 00 .00 30,000.00 .0% 37;966.00 38,000.00 ..00 - 100.0% 184,071.79 273,500.00 284,485.00 -47.8% 03/28/2005 VILLAGE OF DEERFIELD 14:41:10 SEWER FUND BUDGET - FY 2005/06 PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION PAGE 4 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2004 . 2005 2005 2005 2005 1 2006 PCT SEWER FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 542052 WASTEWATER TREATMENT FACILITY -------------------------------------------- 542052 5110 REG SALAR 475,532.24 520,000.00 520,000.00 381,305.31 520,000.00 585,000.00 12.5% Request filling operator trainee position. add $43500.00 for this position. 542052 5111 PT SALARY 8,758.00 8,000.00 8,000.00 8,088.00 8,000.00 10,000.00 25.0% 542052 5112 OT SALARY 26,993.11 23,200.00 23,200.00 21,537.14 23,200.00 2.4,000.00 3.4% 542052 5120 MED BNFT 91,289.44 113,300.00 113,300.00 78,084.97 113,300.00 125,000.00 10.3% 542052 5121 DNTL BNFT 1,279.68 12,200.00 12,200.00 7,566.81 12,200.00 12,200.00 .0% 542052 5122 MISC BNFT 301.25 .00 .00 2,070.63 2,100.00 2,500.00 .0% 542052 5130 APPAREL 3,641.96 4,500.00 4,500.00 3,004.71 4,500.00 6,700.00 48.9% 542052 5140 PEN CNTRB 70,024.44 103,000.00 103,000.00 67,744.94 103,000.00 110,000.00 6.816 542052 5211 TRNG TRAV 3,098.78 2,500.00 2,500.00 95.00 2,500.00_ 3,000.00 20.0% 542052 5213 SUBSCRIPT 2,238.41 500.00 500:00 36.56 500.00 500.00 .0% 542052 5310 RENT EQP .00 9,500.00 9,500.00 41.04 9,500.00 9,500.00 .0% 542052 5320 BLDG R&M 514.93 20,000.00 20,000.00 7,429.05 20,000.00 21,000.00 5.0% CLEANING SERVICE - $1,000 NEW ROOF & TUCKPOINTING - $20,000 542052 5322 EQUP R&M 251,913.99 68,500.00 68,500.00 136,043.69 145,000.00 68,500.00 .016 542052 5326. VEH MAINT 7,126.25 9,000.00 9,000.00 3,631.00 9,000.00 9,900.00 10.016 542052 5330 DUES .00 .00 00 .00 .00 300..00 .0% 542052 5332 TRAV EXP 323.75 3,000.00 3,000.00 2,805.56 3,000.00 3,000.00 .0% 542052 5335 PRINTING 185:57 200.00 200.00 .00 200.00 200.00 .0% 542052 5362 P/S ENG 2,244.25 295,000.00 295,000.00 87,228.63 150,000.00 305,000.00 3.4% NPDES ASSISTANCE WITH NEW PERMIT REQ'S - $10,000 STP IMPROVEMENTS - $323,000 ENGINEERING STUDY - $67,000 - 542052 .5363 P/S MEDIC .00 .00 .00 .00 .00 1,200.00 .0% 542052 5365 P/S OTHER .00 .00 .00 .00 00. 49,000.00 .0% YEARLY SLUDGE HAULING - $40,000 SNAIL REMOVAL IN SLUDGE BASIN - $9,000 542052 5370 DP SERV 79.13 600.00 600.00 .00 600.00 600.00 .0% 542052 5390 OTHER .00 .00 .00 .00 .00 20,000:00 .0% New state permit charge for treatment plant discharge and sludge hauling permits. 542052 5410 MISC SUPP 1,480.38 4,000.00 4,000.00 3,923.73 4,000.00 5,500.00 37:5% 542052 5420 PETR PROD 28,175.73 14,000.00 14,000.00 10,197.51 14,000.00 16,100.00 15.0% 542052 5421 MATERIAL 27,259.72 40,000.00 40,000.00 8,283.04 40,000.00 40,.000.00 .0% 542052 5422 CHEMICAL 37.,793.58 56,000.00 56,000.00 27,653.57 56,000.00 60,000.00 7.1% 542052 5440 SMTLSEQUP 903.54 1,000.00 11000.00. 603.03 1,000.00 1,500.00 50.0% 542052 5450 OFF SUPP 273.45 600.00 600.00 249.96 600.00 600..00 .0% 542052 5460 OPER SUPP 18,216.60 18,000.00 18,000.00 12,044.85 18,000.00 19,000.00 5.6% 542052 5470 R&M SUPP- 17,376.66 19,000.00 19,000.00 16,560.24 19,000.00 20,000.00 5.3% 03/28/2005 VILLAGE OF DEERFIELD PAGE 5 14:41:10 SEWER FUND BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 542052 5510 U/E ELECT 177,836.36 170,000.00 170,000.00 121,466.85 155,000.00 160,000.00 -5.90 542052 5520 U/E NAT GA 36,508.90 40,000.00 40,000.00 34,706.48 40,000.00 45,0.00.00" 12.50 542052 5530 U/E WATER 6,070.90 10,000.00 10,000.00 5,124.84 10,000.00 10,000.00 .0°s 542052 5540 U/E TELEPH 13,435.20 14,500.00 14,500.00 11,052.34 14,500.00 14,500.00 .0% 542052 5810 OP EQP 9,860.80 13,000.00 13,000.00 11,552.53 13,000.00 13,000.00 .0% 542052 5941 STP IMP .00 481,500.00 481,500.00 276,253.32 350.,000.00 660,000.00 37.10 SLUDGE HANDLING BLDNG. ROOF - $10,000 FINAL CLARIFIERS #1 & 2 WEIR REPLACE. - $15,000 EXCESS FLOW TRAVELING BRIDGE REPLACE. - $400,000 MAIN CONTROL BLDNG ELECTRICAL FEED - $75,000 SPILLWAY REHAB & DISSOLV. OXYGEN IMPROVE. - $75,000. AEROBIC DIGESTER IN -TANK EQUIP. REPLACE. - $85,000 542052 7211 TRANS VERF 9,008.02 8,908.00 8,908.00 7,423..00 8,908.00 9,342.00 4.9% TOTAL WASTEWATER TREATMENT F 1,331,745.02 .2,083,508.00 2,083,508.00 1,353,808.33 1,870,608.00 2,441,642.00 17.2% TOTAL SEWER FUND 2,296,460.69 3,431,433.00 3,431,433.00 2,217,246.49 2,96,01383.00 5,589,621.00 62.9% GRAND TOTAL 2,296,460.69 3,431,433.00 3,431,433.00 2,217,246.49 2,960.,383.00 5,589,621.00 62.90 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 15:02:53 REFUSE FUND BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 . ACCOUNTS FOR: 2004 2005 2005 2005 -2005 2006 PCT REFUSE FUND --------------------------------------------------------------------------=--------------------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 582030 REFUSE COLLECTION -------------------------------------------- 582030 5311 PROP RENT .00 21,000.00 21,000.00. .00 21,000.00 21,000.00 .0% 582030 5337 POSTAGE 1,734.34 2,400.00 2,400.00. 653.18 2,400.00 2,400.00 .'0% 582030 5350 INS GI, 1,818.43 3,900.00 3,900.00 .3,460.19 3,900.00 4,095.00 5..0% 582030 5352 INS - EXCE 372.04 .00 .00 .00 .00 .00 .0% 582030 5390 OTHER 15,435.53 17,000.00 17,000.00 822.11 3,000.00 10,000.00 - 41.2°% 582030 5391 REF COLCT 1,257,294.93 1,440,000.00 1,440,000.00 1,044,927.88 11350,000.00 1,440,000.00 .0% 582030 5410 MISC SUPP .00 4,000.00 4,000.00 1,600.00 4,000.00 4,000.00 .0% TOTAL REFUSE COLLECTION 1,276,655.27 1,488,300.00 1,488,300.00 1,051,463.36 1,384,300.00 1,481,495.00 -.5% 03/28/2005 VILLAGE OF DEERFIELD PAGE .2 15:02:53 REFUSE FUND BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT REFUSE FUND ---------------------------------------------------------------------------------7-----------------=-------------=------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 582053 REFUSE LEAF COLLECTION -------------------------------------------- 582053 5110 REG SALAR 42,870.60 59,400.00 59,400.00 34,036.38 40,000.00 52,000.00 -12.50 582053 5111 PT SALARY .00 .00 .00 5,075.00 5,100.,00 8,000.00 .0 °s 4 part time hires for 4 weeks 582053 5112 OT SALARY 16,175.38 18,700.00 18,700.00. 14,316.49 15,000.00 18,700..00 .016 582053 5120 MED BNFT 5,484.88 10,500.00 10,500.00 8,362.79 10,500.00 11,550.00 10.0°% 582053 5121 DNTL BNFT .00 1,000.00 1,000.00 786.14 .1,000.00 1,100.00 10.0% 582053 5122 MISC BNFT .00 .00 .00 135.99 250.00 500.00 .0% 582053 5140 PEN CNTRB 4,609.43 10,800.00 10,800.00 8,288.69 15,500.00 17,200.00 59.3-s- 582053 5310 RENT EQP .00 .00 .00 .00 .00 5,000.00 .0°% 582053 5322 EQUP R&M 16,829.50 19,000.00 19,000.00 20,079.40 19,000.00. 21,000.00 10.50 582053 5326 VEH MAINT 5,797.00 10,000.00 10,000.00 977-.50 5,.000.00 10,000.00 .0% 582053 5420 PETR PROD 2,567.02 2,900.00 2,900.00 3,783.24 3,900.00 4,100.00 41.40 582053 5460 OPER SUPP 146.79 300.00 300.00 10.00 300.00 300.00 .0% 582053 7211 TRANS VERF 10,250.02 10,250.00• 10,250.00 8,542.010 10,250.00 10,775.00 5.1°% TOTAL REFUSE LEAF COLLECTION 104,730.62 142,850.00 142,850.00 104,393.62 1.25,800.00 160,225.00 12.2% TOTAL REFUSE FUND 1,381,385.89 1,631,150.00 1,631,150.00 1,155,856.98 1,510,100.00 1,641,720.00 .6% GRAND TOTAL 1,381,385.89 1,631,150.00 1,631,150.00 1,155,856.98 1,510,100.00 1,641,720.00 .6% 03/28/2005 VILLAGE OF DEERFIELD PAGE 1. 15:03 :27 COMMUTER PARKING LOTS BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT COMMUTER -----------------------------------------------------------------------------------------------------=------------------------------- PARKING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 602019 COMM PARK COMBINED FUNDING -------------------------------------------- 602019 5110 REG SALAR 8,531.20 12,600.00 12,600.00 8,596.98 12,600.00 12,600.00 .0% 602019 5120 MED BNFT 1,493.38 2,330.00 2,330.00 634.80 .2,330.00 2,330.00 .0% 602019 5121 DNTL BNFT 14.60. 250.00 250.00 87.44 250.00 250.00 .0% 602019 5122 MISC BNFT 5.82 .00 .00 31.49 100.00 100.00 .0% 602019 5140 PEN•CNTRB 1,478.46 2,200.00 2,200.00 1,466.77 2,200.00 2,200.00 .0% 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 .00 2,000.00 2,000.00 .00. 500.00 2,000.00" .0% 602019 5322 EQUP R&M .00 1,000.00 1,000.00 .00 .500.00 1,000.00 .0% 602019 5350 INS GL 335.19 590.00 590.00 523.46 590.00 619.50 5.0% 602019 5390 OTHER 1,950.00 20,000.00 20,000.00 12,600.00 20,000.00 20,000..00 .0% 602019 5410 MISC SUPP 1.85 200.00 200.00 63.17 200.00 200.00 .0°% 602019 5421 MATERIAL .00 5,200.00 5,200.00 .00 .00 5,200.00 .0°% 602019 5460 OPER SUPP .00 300.00 300.00 46.00 300.00 300.00 .0% 602019 5470 R&M SUPP .00 100.00 100.00 6.03 100.00 100.00 .0° %. 602019 5510 U/E ELECT 2,502.71 5,000.00 5,000.00 1,704.67 -3,500.00 4,500.00 - 10.0°% 602019 5810 OP EQP .00 2,000.00 2,000.00 .00 500.00 1,000.00 - 50.0% 602019 7210 TRNSFR OUT .00 62,500.00 62,500.00 �. .00 62,500.00 65,000700 4%0% TOTAL COMM PARK COMBINED FUN. 23,753.21 123,770.00 123,770.00. 25,760.81 113,670.00 124,899.50 .9 16- 03/28/2005 VILLAGE OF DEERFIELD PAGE 2 15:03:27 COMMUTER PARKING LOTS BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT COMMUTER ------------------------------------------------------------------------------------------=----------------------------------------- PARKING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 602038 COMM PARK VILLAGE OWNED -------------------------------------------- 602038 5110 REG SALAR 8,531.64 12,320.00 12,320.00 8,596.98 12,320.00 12,320.00 .0% 602038 5112 OT SALARY 291.08 .00 .00 .00 .00 .00 .0% 602038 5120 MED BNFT 1,493.38 2,330.00 2,330.00 634.80 2;330,:00 2,330.00 .0% 602038 5121 DNTL BNFT 14.60 250.00 250.00 87.44 250.00 250.00 .0% 602038 5122 MISC BNFT 5.82 .00 .00 31.49 100.00 100.00 .0% 602038 5140 PEN CNTRB 1,478.46 2,200.00 2,200.00 1,466.77 2,200.00 2,200.00 .0% 602038 5322 EQUP R&M 610.00 2,000.00 2,000.00 1,002.50 2,000.00 4,000.00 100.0% $2000 for viaduct and pedestrian bridge maintenance 602038 5350 INS GL 335.19 590.00 590.00 523.46 590.00 619.50 5.0% 602038 5352 INS - EXCE 101.46 .00 ..00 .00 .00 .00 .016 602038 5390 OTHER 1,950.00 20,000.00 20,000.00 12,600.00 20,000.00 25,000.00 .25.0% $5000 for contractual viaduct and pedestrian bridge maintenance 602038 5410 MISC SUPP 1.85 .00 .00 .00 .00 00 .09. 602038 5421 MATERIAL .00 3,100.00 3,100.00 .00. 1,000.00 3,100.00 .0% 602038 5460 OPER SUPP .00 200.00 200.00 43.75 200.00 200.00 0% 602038 5470 R&M SUPP .00 200.00 200.00 00 200.00 200.00 .0% 602038 5510 U/E ELECT 5,006.21 5,800.00 5,800.00 3,561.21 5,800.00 5,800.00 .0% 602038 5810 OP EQP .00 1,000.00 1,000.00 .00 200.00 1,000.00 .0% 602038 7210 TRNSFR OUT .00 62,500.00 62,500.00 .00 62,500.00 65,000.00 4:0% TOTAL COMM PARK VILLAGE OWNE 19,819.69 112,490.00 112,490.00 28,548.40 109,690.00 122,119.50 8.6% TOTAL COMMUTER PARKING. FUND 43,572.90 236,260.00 236,260.00 54,309.21 223,360.00 247,019.00 4•.6% GRAND TOTAL 43,572.90 236,260.00 236,260.00 54,309.21 223,360.00 247,019.00 4.6% 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 14:42:31 GARAGE FUND BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2605 2005 2006. PCT GARAGE FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 702050 GARAGE FUND EXPENDITURES -------------------------------------------- 702050 5110 REG SALAR 182,005.77 166,740.00 166,740.00 131,460.72 166,740.00 171,742.20 3.0% 702050 5112 OT SALARY 12,674.26 9,200.00 9,200.00 7,584.64 9,200.00 10,120:00 10.0°% 702050 5120 MED BNFT 24,161.72 29,650.00 29,650.00 19,091.02 29,650.00 29,650.00 .0% 702050 5121 DNTL BNFT 375.68 3,150.00 3,150.00 2,154.42 3.,150.00 3,150.00 .016 702050 5122 MISC BNFT 22,089.83 .00 ..00 438.79 500.00 600.00 .0°% 702050 5130 APPAREL 1,092.15 1,000.00 1,000.00 290.00 1,000.00 1,000..00 .0% 702050 5140 PEN CNTRB 2,498.55 30,500.00 30,500.00 23,447.06 30,500.00 32,600.00 6.915 702050 5211 TRNG TRAV 41.72 200.00 200.00 .00 200.00 200.00. .0% 702050 5322 EQUP R&M 13,742.32 5,000.00 5,000.00 490.00 5,000.00 5,000.00 0% 702050 5332 TRAV EXP .00 400.00 400.00 60.00 400.00 400.00 .0% . 702050 5335 PRINTING .00 400.00 400.00 401.31 400.00 400.00 .0% 702050 5350 INS GL 4,715.92 8,300.00 8,300.00 1,364.01 8,300.00 8,715.00 5.016 702050 5352 INS - EXCE 768.24 .00 .00 .00 .00 .00 .0% 702050 5410 MISC SUPP 1,142.74 1,100.00 1,100.00 1,585.85 1,100.00 1,100..00 .0% 702050 5420 PETR PROD 483.62 1,000.00 1,000.00 466.34 1,000.00 1,000.00 .0% 702050 5421 MATERIAL .00 200.00 200.00 63..00 200.00 200.00 .0°% 702050 5440 SMTLSEQUP ! 1,493.90 2,500.00 2,500.00 1,459.15 2,500.00 2,500.00 .0°% 702050 5450 OFF SUPP 481.58 .00 .00 .00 .00 :00 .0% 702050 5460 OPER SUPP - 1,154.25 300.00 300.00 .00 300.00 300.00 .0°% 702050 5470 R&M SUPP 60,130.80 68,400.00 68,400.00 . 64,306.94 68,400.00 70,452.00 3.0% 702050 5530 U/E WATER 1,345.13 2,000.00 2,000.00 1,423.02 2,000.00 2,000.00 .0% 702050 5540 U/E TELEPH 1,544.78 .2,400.00 2,400.00 1,212.23 2,400.00 2,400.00 .0% 702050 5810 OP EQP .00 2,500.00. 2,500.00 2,395.00 2,,500.00 .00 - 100.0% 702050 7211 TRANS VERF 2,375.02 2,400.00 .2,400.00 2,000.00 2,400.00 2,525.00 5.2% TOTAL GARAGE FUND EXPENDITUR 332,009.51 337,340.00 337,340.00 267,693.50 337,840.00 346,054.20 2.6% TOTAL GARAGE FUND 332,009.51 337;340.00 337,340.00 267,693.50 337,840.00 346,054.20 2.6% GRAND TOTAL 332,009.51 337,340.00 337,340.00 267,693.50 337,840.00 346,054.20 2.6% 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 14:45:08 INSURANCE FUND BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION -FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT INSURANCE -----------------------=------------------------------------------------------------------------------------------------------------ FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 721111 INSURANCE EXPENSES -------------------------------------------- 721111 5610 OTH EXPENS .00 1,000.00 1,000.00 195.77 1,000.00 1,000.00 .0°s 721111 5620 VIL MED PR 1,101,115.37 1,205,833.00 1,205,833.00 637,973.21 1,205,833.00 .00 - 100.00 VILLAGE PREMIUMS WILL BE EXPENSED IN EACH OPERATING FUNCTION BEGINNING IN FY 2005/06. THIS WILL ELIMINATE THE DOUBLE EXPENSING IN BUDGET OF HEALTH INSURANCE COSTS. 721111 5621 VIL DNT PR 80,163.40 95,865.00 95,865.00 26,876.49 95,865.00 .00 - 100.0% 721111 5622 VIL LIF PR 22,282.80 23,200.00 23,200.00 11,866.16 23;200.00 .00 - 100.00 721111 5630 RT MED PR 163,607.37 135,000.00 135,000.00 89,735.60 135,000.00 147,150.00 9.0% 721111 5631 RT DNT PR 8,095.54 8,690.00 8,690.00 3,839.61 8,690.00 8,690..00 .0°% 721111 5640 LIB MED PR 185,194.20 209,000.00 209,000.00 105,737.10 209,000.00 .00 - 100.0% 721111 5641 LIB DNT PR 12,021.20 12,870.00 12,870.00 4,293.77 12,870.00 .00 - 100.0°% 721111 5642 LIB LIF PR 2,037.60 2,100.00 2,100.00 1,084.08 2,100.00 .00 - 100.0°% 721111 5650 PKD MED PR 271,394.19 299,000.00 299,000.00 160,344.02 299,000.00 325,910.00 9.0% 721111 5651 PKD DNT PR 21,995.03 14,520.00 14,520.00 8,195.21 14,520.00 15,826.80 9.0% 721111 5652 PKD LIF PR 5,832.00 6,500.00 6,500.00 3,106.68 6,500.00 6,500.00. .0% TOTAL INSURANCE EXPENSES 1,873,738.70 2,013,578.00 2,013,578.00 1,053,247.70 2,013,578.00 505,076.80 -74.9% TOTAL INSURANCE FUND 1,873,738.70 2,013,578.00 2,013,578.00 1,053,247.70 2,013,578.00 505,076.80 -74.9% GRAND.TOTAL 1,873,738.70 2,013,578.00 2,013,578.00 1,053,247.70 2,013,578.00 505,076.80 - 74.9°% 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 14:44:40 POLICE PENSION FUND BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT POLICE PENSION FUND ACTUAL ORIG BUD REVISED BUD. ACTUAL PROJECTION FIN REVIEW CHANGE -------------------------------------------------------------------=---------------------------------------------------------- - - - - -- 806010 POLICE PENSION FUND EXPENDITUR 806010 5141 PEN PYMNT 1,079,104.90 806010 5142 SEP REFND .00 806010 5330 DUES 750.00 806010 5332 TRAV EXP 75.16 806010 5360 P/S CRP CN 2,100.00 806010 5365 P/S OTHER 2,775.83 806010 5369 TRUST FEES 210.57 806010 5390 OTHER .00 806010 5410 MISC SUPP 1,119.61 TOTAL POLICE PENSION FUND EX 1,086,136.07 TOTAL POLICE PENSION FUND 1,086,136.07 1,200,000.00 15,000.00 1,500.00 500.00 5,000.00 .00 .00 2,500.00 .00 1,200,000.00 15,000.00 1,500.00 500.00 5,000.00 .00 .00 2,500.00 .00 1,224,500.00 1,224,500.00 1,224,500.00 1,224,500.00 GRAND TOTAL 1,086,136.07 1,224,500.00 1,224,500.00 934,795.81 .00 750.00 .00 1,982.98 .00 .00 3,877.05 .00 941,405.84 941,405.84 941-,405.84 1,150,000.00 .00 1,500.00 250.00 3,500.00 .00 .00 2,500.00 .00 1,157,750.00 1,157,750:00 11157,750:00 1,248,000:00 15,000.00 1,500.00 500.00 5,000.00 1,000.00 1,500:00 2,500..00 .00 1,275,000.00 1,275,000.00 1,275,000.00 4.0% .0% .0% .0° .0% .0% .0% 0 .06 4.10 4.16 4.10 03/28/2005 VILLAGE OF DEERFIELD PAGE 1 15:44:57 LIBRARY REVENUE BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005 2006 PCT LIBRARY FUND ----------------------------------------------------------------------------------------='------------=------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 980001 LIBRARY REVENUES -------------------------------------------- 980001 4110 PROP TAX 1,837,333.69 1,708,955.00 1,708,955.00 1,529,592.83 1,708,955.00 2,357,350.00 37.9% 980001 4115 TIF SRPLUS 142,908.00 140,000.00 140,000.00 164,674.00 365,000.00 350,00.0:00 150.0% 980001 4120 REPLACEMT 18,145.90 16,000.00 16,000.00 13,667.67 16,000.00 16,000.00 .0% 980001 4330 ST GRANT 23,025.00 21,000.00 21,000.00 .00 21,000..00 21,000.00 .0% 980001 4560 FF & PEN 40,207.09 40,000.00 40,000.00 33,612.20 40,000.00 40,000.00 .0% 980001 4561 NRES FEE 18,543.49 24,000.00 24,000.00 7,737.02 24,000.00 10,000.00 -58.3% 980001 4562 PHOTOCOPY 6,174.75 6,000.00 6,000.00, 4,347.45 6,000.00 5,000.00 -16.7% 980001 4564 VID BORRW _ 12,957.55 9,000.00 9,000.00 8,284.60 9,000.00 12,000.00 33.3% 980001 4610 INTER EARN 18,392.90 30,000.00 30,000.00 .00 30,000.00 25,150.00 -16.2% 980001 4611 SIMON INT. 108.85 .00 .00 .00 .00 .00 .0 %_ 980001 4810 MISC REV 9,410.89 1,000.00 1,000.00 3,900.50 1,000,.00 1,000.00 .0% 980001 4820 GIFTS .00 1,000.00. 1,000.00 -.00 1,000.00 2,500.00 150.0% 980001 4826 AMY SIMON 3,665.00 .00 .00 6,550.00 .00 2,000.00 .0% TOTAL LIBRARY REVENUES 2,130,873.11 1,996,955.00 1,996,955.00 1,772,366.27 2,221,955.00 2,842,000.00 42.3% TOTAL LIBRARY FUND 2,130,873.11 1,996,955.00 1,996,955.00 1,772,366.27 2,221,955.00 2,842,000.00 42.3% GRAND TOTAL 2,130,873.11 1,996,955.00 1,996,955.00 1,772,366.27 2,221;955.00 2,842,000.00 ,42.3% 03/28/2005 VILLAGE OF DEERFIELD 15:04:27 LIBRARY BUDGET - FY 2005/06 PROJECTION: 20061 FY 2005 /06 MASTER BUDGET PROJECTION PAGE 1 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2004 2005 2005 2005 2005" 2006 PCT LIBRARY FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ------------------------------------------=------------------------------------------------------------------------- ---------- - - - - -- 988030 LIBRARY EXPENSES 988030 5110 REG SALAR 669,476.14 598,500.00 598,500.00 949.,017.26 598;500.00 603,000.00 .8% 988030 5111 PT SALARY 393,457.51 593,000.00 593,000.00 94,430.72_ 593,000.00 640,.000.00 7.9% 988030 5112 OT SALARY 4,888.13 5,000.00 5,000.00 5,812.71 5,000.00 5,000.00 .0% 988030 5120 MED BNFT 134,385.60 145,000.00 145,000.00 135,514.02 145;000.00 160,000.00 10.3% 988030 5121 DNTL BNFT 7,230.40 8,000.00 8,000.00 7,332.66 8,000.00 10,000.00 25.0% 988030 5122 MISC BNFT 11,975.55 1,000.00 1,000.00 1,546.72 1,000.00 2,000.00 100.0% 988030 5140 PEN CNTRB 164,939.15 193,000.00 193,000.00 167,563.61 193,000.00 210,000.00 8.8% 988030 5211 TRNG TRAV 8,608.08 7,000.00 7,000.00 11,199.91 7,000.00 8,006.00 14.3% 988030 5320 BLDG R&M 16,464.45 20,000.00 20,000.00. 14,065.70 20,000.00 20,000.00 .016 988030 5321 STRUC R&M 14,350.00 11,784.00 11,784.00 .00 .11,784.00 10,000.00 -15.1% 988030 5322 EQUP R&M 23,813.74 18,000.00 18,000.00 18,823.83 18,000.00 25,000.00.- 38.9% 988030 5330 DUES 2,229.00 7,000.00 7,000.00 3,102.99 7,000.00 8,000.00 14.3% 988030 5335 PRINTING 15,228.75 16,000.00 16,000.00 19,618.49 16,000:00 18,000.00 12.5% 968030 5337 POSTAGE 5,070.40 5,000.00 5,000.00. 5,954.72 5,000..00 6,000.00 20.0% 988030 5340 LIB BIND 2,904.05 4,500.00 4,500.00 1,751.60 4,500.00 4,500.00 .0% 988030 5341 LIB PERIO 27,626.25 40;000.00 40,000.00. 22,544.20 40,000.00 40,000.00 .0% 988030 5342 LIB BOOKS 129,747.38 140,000.00 140,000.00 110,537.67 140,.000..00 145,000.00 3.6% 988030 5343 LIB CHILD 40,613.33 50,000.00 50,000.00 35,511.41 .50,000.00 55,000.00 10.016 966030 5344 LIB AV 29,396.64 30,000.00 30,000.00 24,714.24 30,000.00 35,000.00 16.7% 988030 5345 LIB FILM 19,021.26 18,000.00 18,000.00 12,900.81 18,000.00 18,000.00 .0% 988030 5346 LIB DP .00 90,000.00 90,000.00 1,920.00 90,000.00 100,000.00 11.1% 988030 5347 LIB CATALG 9,737;14 11,000.00 11,000.00 10,719.83 11,000.00 20,000.00 81.8% 988030 5348 LIB LOSTBK .00 .00 .00 - 4,008.50 .00 5,000.00 .0% 968030 5350 INS GL 20,525.00 30,800.00 30,800.00 20,190.00. 30,800.00 30,000.00 -2.6% 988030 5360 P/S CRP CN 12,686.58 3,000.00 3,000.00 11,623.75 3,000.00 4,000.00 33.3% 988030 5370 DP SERV 78,589.74 .00 .00 47,532.21 00 ..00 .0% 988030 5450 OFF SUPP 31,027.78 28,000.00 28,000.00 27,019.84 28,000.00 32,000.00 14.36 988030 5530 U/E WATER 1,253.66 1,500.00 1,500.00 978.39 .1,500.00 1,500.00 .0% 988030 5540 U/E TELEPH 12,086.26 11,000.00 11,000.00 7,857.12 11,000.00 11,000.00 .0% 988030 5610 OTH EXPENS 404.76 1,000.00 11000.00 69.70 1,000.00 1,000..00 .0% 988030 5810 OP EQP 9,702.07 10,000.00 10,000.00 11,106.66 10,000.00 15,000.00 .50.0% 988030 7211 TRANS VERF .00 50,000.00 50,000.00 .00 .00 .00 - 100.0°% TOTAL LIBRARY EXPENSES 1,897,438.80 2,147,084.00 2,147,084.00 1,776,952.27• 2, "097,084.00 2,242,00.0.00 4.4% 03/28/2005 VILLAGE OF DEERFIELD PAGE 2 15:04:27 LIBRARY BUDGET - FY 2005/06 bgnyrpts PROJECTION: 20061 FY 2005 /06 MASTER.BUDGET PROJECTION FOR PERIOD 13 ACCOUNT'S FOR: 2004 2005 2005 2005 2005 2006 PCT LIBRARY FUND -----------------------------------------------------"------------------------------------------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 968082 LIBRARY EXPENSES -------------------------------------------- 988082 5320 BLDG R&M 6,076.00 00 .00 .00 .00 .00 .0% 988082 5321 STRUC R&M 10,815.89 150,000.00 150,000.00 17,811.36 150,000.00 100,000.00 -33.30 TOTAL LIBRARY EXPENSES 16,891.89 150,000.00 150,000.00. 17,811.36 150,000.00 100,000.00 -33.30 TOTAL LIBRARY FUND 1,914,330.69 2,297,084.00 2,297,084.00 1;794,763.63 2,247,084.00 2,342,000.00 2.0% GRAND TOTAL 1,914,330.69 2,297,084.00 2,297,084.00 1,794,763.63 2,247,084.00 2,342,000.00 2.0%