The URL can be used to link to this page

O-06-15VILLAGE OF DEERFIELD LAKE AND COOK COUNTIES, ILLINOIS ORDINANCE NO. 0 -06 -15 AN ORDINANCE ADOPTING THE BUDGET OF THE VILLAGE OF DEERFIELD FOR THE FISCAL YEAR BEGINNING MAY 1, 2006 AND ENDING APRIL 30, 2007 PASSED AND APPROVED BY THE PRESIDENT AND BOARD OF TRUSTEES OF THE VILLAGE OF DEERFIELD, LAKE AND COOK COUNTIES, ILLINOIS, this 17th day of April , 2006. Published in pamphlet form by authority of the President and Board of Trustees of the Village of Deerfield, Lake and Cook Counties, Illinois, this 17th day of April , 2006 ORDINANCE 0 -06 -15 VILLAGE OF DEERFIELD LAKE AND COOK COUNTIES, ILLINOIS ADOPTING THE BUDGET OF THE VILLAGE OF DEERFIELD FOR THE FISCAL YEAR BEGINNING MAY 1, 2006 AND ENDING APRIL 30, 2007 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, 2006; and, WHEREAS, the tentative annual budget for the fiscal year beginning May 1, 2006 has been made conveniently available to public inspection for at least ten (10) days prior to the passage of the annual budget; and, WHEREAS, a public hearing has been held on the tentative annual budget pursuant to public notice duly given by publication in a newspaper having general circulation in the Village of Deerfield at least one week prior to the time of the public hearing; and, WHEREAS, the corporate authorities of the Village of Deerfield find that it is in the best interests of the Village to adopt the budget attached hereto as Exhibit A as the annual budget of the Village of Deerfield for the fiscal year beginning May 1, 2006 and ending April 30, 2007. 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, 2006, and ending April 30, 2007. 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 17th day of April , 2006. AYES: Benton, Feldman, Rosenthal, Sgiden,Struthers, Wylie (6) NAYS: None (0) TO: D FROM: . FIALKOWSKI, DIRECTOR OF FINANCE DATE:. o� Lo qw, Revenue Item BUDGET SUMMARY AND HISTORICAL PERSPECTIVE Police Debt Infrastr. General Sewer Water Refuse Garage MFT Pension Service Repl. TIF 1 Taxes: Property Tax 1,985,000 809,000 45,000 TIF Increment Takes 25,000 Home Rule Sales Tax 750,000 750,000 Replacement Tax 40,000 20,000 Motor Fuel 524,970 Sales Tax 4,050,000 Local Use Tax 229,100 State Income Tax 1,458,800 Hotel -Motel Tax License & Permits 1,875,000 Liquor /Food .. 80,500 Other Business Lic 28,000 Vehicle 340,000 Building Permits 550,000 Non- Business Lic 55,000 Charges: ' Police Services 308,600 False Alarms 40,000 Dispatching Serve 79,000 User Fees 2,449,000 4,167,268 660,000 Penalties Rental Income 20,000 Fran Fees - Cable 210,000 Telecom. Charges 295,000 Insurance Charges Interfund Charges 369,050 725,000 Engineering Fees Misc Rev 2,000 Interest Earnings 460,000 10,000 55,000 2,500 20,000 700,000 25,000 10,000 500 Grants 6,000 Miscellaneous 149,000 22,500 75,000 9,000 1,500 5,000 Employee Cont 316,100 Ordin Violations 197,500 Transfers: Transfer Charges 12,000 Transf Pking General 130,000 MFT to General Trans to Debt Service 2,302,000 TIF Surplus Distribution 23,500 Misc Trans 1,600,000 2,400,000 13,350,500 4,081,500 4,297,268 1,480,500 370,550 549,970 1,741,100 2,347,000 3,228,500 25,500 TOTAL NEW REVENUE 4,021,320 174,871 1,034,373 193,984 (22,788) 75,030 (341,050) 556,000 1,222,500 224,500 (To) /From Reserve TOTAL RESOURCES 17,371,820 4,256,371 5,331,641 1,674.4841 347,762 625,000 1,400,0501 2,903,000 4,451,000 250,000 EXP. CATEGORIES: Personnel 10,104,326 1,566,900 911,100 101,700 242,015 Other Services 116,100 6,100 2,900 0 500 Contractual 2,528,717 925,125 941,008 1,552,709 15,822 12,250 797,000 Commodities 683,400 546,450 2,515,398 9,3001 86,900 Capital Outlay 182,800 1,149,000 438,000 0 625,000 3,654,000 Debt Service 481,708 2,303,000 Pension Payments 1,387,800 Transfers 3,756,477 62,796 41,527 10,775 2,525 600,000 TIF Rebate 250,000 TOTAL EXPEND. 17,371,8201 4,256,3711 5,331,641 1,674,4841 347,7621 625,0001 1,400,0501 2,903,0001 4,451,000 250,000 BUDGET SUMMARY AND HISTORICAL PERSPECTIVE Parking Equip. Project TIF 2 Lots Replace. 29 Insurance E -911 2006 -07 2005.06 2005 -06 TOTAL Est TOTAL 200405 BUDGET Actual BUDGET Actual 2,839,000 2,839,000 2,839,000 2,324,438 Taxes* Property Tax 4,150,000 4,175,000 12,564,890 9,550,000 14,698,797 TIF Increment Taxes 1,500,000 1,500,000 1,224,000 511,612 Home Rule Sales Tax 60,000 40,000 30,000 34,966 Replacement Tax 524,970 524,970 522,207 538,543 Motor Fuel 4,050,000 4,000,000 3,560,000 3,978,767 Sales Tax ' 229,100 202,630 202,620 197,039 Local Use Tax 1,458,800 1,396,236 11307,800 1,247,027 State Income Tax 1,875,000 1,875,000. 1,843,250 1,669,346 Hotel -Motel Tax License & Permits 80,500 82,500 .82,500 63,225 Liquor /Food 28,000 28,000 28,000 95,164 Other Business Lic 340,000 332,000 340,000 333,922 Vehicle .550,000 1,500,000 350,000 861,823 Building Permits 55,000 9,500 54,500 36,468 Non - Business Lic 308,600 204,000 204,000 218,712 Charges: Police Services 40,000 40,000 50,000 37,590 False Alarms 79,000 79,000 79,000 78,340 Dispatching Serve 203,000 7,479,268 7,270,000 6,715,787 6,666,135 User Fees 0 0 0 0 Penalties 20,000 12,000 12,000 15,265 Rental Income 210,000 230,000 230,000 209,524 Fran Fees - Cable 300,000 595,000 594,000 638,000 600,289 Telecom. Charges 755,618 755,618 517,777 517,777 0 Health Ins. Charges 532,583 1,626,633 1,581,237 1,570,237 1,424,385 Interfund Charges 2,000 65,000 2,000 1,667 Engineering Fees Misc Rev • 145,000 8,000 50,000 3,000 10,000 8,000 1,507,000 1,665,000 1,662,500 2,957,453 Interest Earnings 6,000 29,000 6,000 993,941 State Grants 262,000 344,751 315,000 392,409 Miscellaneous 316,100 316,100 316,100 349,043 Employee Contributions 197,500 192,300 190,000 196,250 Ordin Violations 12,000 0 21,000 2,119,264 Transfers: Transfer Charges 130,000 130,000 130,000 125,000 Transf Pking to General 0 0 .0 285,000 MFT to General 2,302,000 1,877,250 1,877,250 1,941,750 Trans to Debt Service 23,500 453,500 353,500 408,488 TIF Surplus Distribution 4,000,000 0 3,000,000 0 Misc. Transfers TOTAL NEW REVENUE (To) /From Reserve 4,295,000 211,000 582,583 3,000 765,618 308,000 37,637,589 42,495,641 39,824,028 45,611,642 2,682,000 41,580 523,917 (2,500) (86,509) 15,268 10,312,496 2,846,859 16,223,091 1,424,914 6,977,0001 252,580 1,106,500 5001 679,109 323,268 47,950,085 45,342,500 56,047,119 47,036,556 TOTAL RESOURCES EXP. CATEGORIES: 36,580 12,962,621 11,652,495 12,453,541 10,592,307 Personnel 500 126,100 79,300 127,100 17,046 Other Services 305,000 64,900 679,109 95,545 7,917,185 6,407,038 7,083,436 6,975,199 Contractual 19,100 1 76,740 3,937,288 3,714,596 3,736,612 3,289,333 Commodities 4,370,000 2,000 1,106,500 92,500 11,619,800 5,817,267 11,550,600 4,681,715 Capital Outlay 2,784,708 2,320,300 2,794,843 3,072,378 Debt Service 1,387,800 1,248,000 1,263,000. 1,124,911 Pension Payments 2,302,000 130,000 58,483 6,964,583 2,516,987 5,537,987 7,119,313 Transfers 250,000 11,586,517 11,500,000 10,164,354 TIF Rebate 6,977,000 252,580 1,1,500 06 5001 679,logl 323,268 47,950,085 45,342,500 56,047,119 47,036,556 TOTAL EXPENDITURES VILLAGE OF DEERFIELD 2006 - 2007 BUDGET SUMMARIES BY FUND ESTIMATED PROJECTED BEGINNING BUDGET NEVV BUDGET ENDING FUND FUND BALANCE REVENUES EXPENDITURES FUND BALANCE General Sewer Water . Refuse (Solid Waste) Garage MFT Police Pension Debt Service Infrastructure Replacement TIF I TIF II Parking Lots Insurance Project 29 Vehicle & Equipment Replacement Enhanced 911 COMBINED VILLAGE FUNDS Deerfield Library $15,239,513 $13,350,500 $17,371,820. $11,218,193 92,474. 4,081,500.. 4,256,371 (829397) 1,033,116 4,297,268 52331,642 (1,258) 293,180 1,480,500- 1,674,484 99,196. 100,131 370,550 347,762 122,919 647,899 549,970 625,000 572,869 23,021;368 1,741,100 1,400,050 23,362,418' . 1,146,865 2,347,000. 2,903,000 590,865 406,608 3,228,500 4,451,000 (815,892) 0 25,500 .250,000. (224,500) 4,414,073 4,295,000 6,977,000 1,732,073 566,789 211,000 252,580 525,209 730,089 765,618 679,109 816,598 149,928 3,000 500 152,428 .3,043,141 582,583 1,106,500 2,519,224 527,835 308,000 323,268 512,567 .$51,413,009 $37,637,589 $47,950,086 41,100,512 2,183,554 2,790,933 2,722,933 2,251,554 COMBINED ALL FUNDS $53,596,563 $40,428,522 $50,673,019 $43,352,066 Combined totals are for information only. Certain funds are restricted in.that available funds may only be used for expenditures allowed within said fund. Figures for enterprise funds represent available cash balances. Available balance is based on estimated prior year end totals. FUND BALANCE 0607v3.xls BUDGET SUMMARY - FOUR YEAR COMPARISON YR.END YR.END BUDGET EST.YR.END BUDGET % CHG BUDG FUND /REVENUE SOURCE 04/30/04 04/30/05 FY 05/06 FY 05/06 FY 06/07 FY06 - >07 GENERAL FUND (10) Taxes _ - - - - -- - 78,340 -- - 79,000 0.00% - Corporate Property 363,978. 1,176,655 1,985,000 1,985,000 - 1,985,000 0.00% - Police Pension Levy 266,028 0 0 0 0- N/A - IMRF /FICA/Medicare Levy 697,078 0 0 0 0 N/A -TIF Surplus 398,386 408,488 0 0 0 N/A -Sales 3,400,648 3,978,767 3,560,000 4,000,000 4,050,000 13.76% -Home Rule Sales 0 255,806 612,000 750,000 750,000 22.55% -Hotel /Motel 1,515,952, 1,669,346 1,843,250 1,875,000 1,875,000 _ . 1.72% -State Income 1,111230 1,247,027 1,307,800 1,396,236 1,458,800 11.55% -State Use Tax 180,289 .197,039 ` 202,620 202,620 229,100 13.07% -Prior year Property Tax 0 13,447 10,000 10,000 0 - 100.00% -Pers. Prop. Replace.. 37,877 34,966 10,000 10,000 45,000 350.00% - Telecommunications Tax 339,634 298,021 340,000 298,000 295,000 - 13.24% Fines - - -- -- -Court/Local Ordinance 166,174 196,250 190,000 192,300 197,500 3.95% License Fees----- -- - Business 26,059 86,888 28,000 28,000 28,000 0.00% - Liquor 75,800 63,225 73,000 73,000 71,000 -2.74% - Vehicle 332,063 333,922 340,000 332,000 340,000 0.00% -Other 6,919 8,276 9,500 9,500 9,500 0.00% Permit Fees-- -- -- - - - - -- - Building. 397,391 861,823 350,000` 1,500,000 550,000 57.14% -Other 100,867 36,468 54,500 30,000 55,000 0.92% Inspection Fees - -- ---- -- - - - - - - - -- Engineenng 1,286 1,667 2,000 65,000 2,000. 0.00% - Dispatching Services 57,651 78,340 79,000 79,000. 79,000 0.00% - interest Earned (net) 171,643 315,202 420,000 420,000 460,000 9.52% - Special Police Services 203,506 218,712 204,000 204,00.0 308,600 51.27% - Activity Donations 76,918 .60,839 45,000 60,000 60,000 33.33% - Grants 262,575 11,477 6,000 29,000 6,000 0.00% - Transfers In 275,000 431,000 151,000 151,000 142,000 -5.96% -Cable Franchise Fees 198,917 209,524 230,000 230,000 210,000 -8.70% - Auction Proceeds 376 4,606 1,500 1,500 1,500 0.00% - Rental Income 8,530 15,265 12,000 12,000 20,000 66.67% -False Alarm Fees 44,855 37,590 50,000 40,000 40,000 - 20.00% - Miscellaneous 155,111 189,429 72,500 64,250 82,500 13.79% TOTAL NEW REVENUE 10,874,741 12,440,064 12,188,670 T4,047,406 13,350,500 9.53% Adjustment (To) From Fund Balance (261,940) (985,346) 4,073,583 (1,505,504) 4,021,320 -1.28% TOTAL EXPENDITURES 10,612,801 11,454,718 16,262,253 12,541,902 17,371,820 6.82% ............ MI .1 WATER FUND (50) -Water Sales 4,109,003 4,091,821 4,065,627 4,265,000 4,167,268 2.50% - Interest Earned 35,106 62,510 55,000 55,000 55,000 0.00% - Miscellaneous 44,625 66,732 73,500 114,000 75,000 2.04% TOTAL NEW REVENUE 4,188,734 4,221,063 4,194,127 4,434,000 4,297,268 2.46% Adjustment (To) From Retained Earnings (584,585) (256,419) 1,548,098 1,248,502 1,034,373 - 33.18% TOTAL OPERATING EXPENSES 3,604,149 3,964,644 5,742,225 5,682,502 5,331,641 -7.15% MV ME RN! j. a ., FUND/REVENUE SOURCE SEWER FUND (54) -Sewer Use Fees -interest Earned -Miscellaneous BUDGET SUMMARY - FOUR YEAR COMPARISON YR..END YR.END 04/30/04 04/30/05 FY 05/06 FY 06/07 FY06->07 1,772,816 1,740,881 1,772,160 .2,144,000 2,449,000 38.19 % - 25,382. 18.411 . 20,000 20,000 10,000 0 -50.00% 39,624 44,017 3.084.000 .37.000 1,622.500 -47.39% TOTAL NEW REVENUE 1,837,822 1,803,309 4,876,160 2,201,000. 4,081,500 -16.30% Adjustment (To) From Retained Earnings 357.031 613.081 713,461 559.751 174,871 -75.49%' TOTAL OPERATING EXPENSES 2.194,853 2,416,390 5.589.621 2,760,751 4,256,371- -23.85% 100"M"& z=HM MZ1, MOTOR FUEL TAX FUND (14) -.Intergov. Transferin 534,561- 538,543 522,207 524.970 524,970 0.53% -Interest Inc.1M1sc. (114) 34,506 20.000 29.511 .25.000 25.00% TOTAL-NEW REVENUE 534,447 573,049 542,207 554,481. 549,970 1.43% Adjustment (To) From Fund Balance 15,517 .(17,184) 58,793 61,721 75,030 27.62% TOTAL EXPENDITURES 549,964 555.865 601,000 616,202 625,000 3.99% ar al ;n 2 1 rim 1 Li nj GARAGE FUND (70) -Charges for Service 253,417 -286,628 335,500 335,500 369,050 10.00% -Interest Eamed/Misc. 1,426 2,454 1,500 .1,500 1,500 0.00% TOTAL NEW REVENUE 254,843 289,082 337,000 337,000 370,550 9.96% Adjustment (To) From Fund Balance 77,166 7.440 9,054 6,354 (22,788) -351.69% TOTAL EXPENDITURES. 332,009 296,522 346,054 343,354 347,762 0.49% Mom"MIM0121:0 30t MMEELOMMIALau Oman 0.3, 170vion, M".11 =M11201U. UJUVIRM111 ir-92A U POLICE PENSION FUND (80) -Employer Contribution 325,762 614,326 725,000 725.000 725,000 0.00% -Employee Contrib. 288,507 349,043 316,100 316,100 316,100 0.00% -Invbst. Income 1873,607 1,848,090 800,000 800,000 700,000 -12.50%.. TOTAL NEW REVENUE 2,487,876 2,811,459 1,841,100 1,841,100 1,741,100 - 5.43% - Adjustment (To) From Fund Balance (1,401,740) (1,675,082) (566,100) (575,750) (341,050) -39.75% TOTAL EXPENDITURES 1,086,136 1,136,377 1,275,000 1,265,350 1,400,050 T 9.81% rmr i a . hl . . . . . . . . . . . . . . M-M= INSURANCE (BENEFI ' (BENEFITS) FUND (72) -Charges for Services 1,798,871 .2,098,264 517,777 517,777 755,618 45.64% -invest. Income 1,499 .11,815 5,000 5,000 10,000 100.00% -Miscellaneous 0 25 0 0 0 N/A TOTAL NEW REVENUE 1,800,370 2,110,104 522,777 522,777 765,618 46.45% Adjustment (To) From Fund Balance 73,369 (100,540) (17,700) (17,700) (86,509) 388.75% TOTAL EXPENDITURES 1,873,739 2,009,564 505,077 505,077 679,109 34.46% N W ffiff na-gluffa wcmi3nmrm, gull I.J DEBT SERVICE FUND (35) -Bond Proceeds 0 0 0 0 0 N/A -Property Taxes 372,682 393,421 20,000 m000 20,000 0.00% -Transfer From General Fund 0 0 0 0 0 N/A -Transfer From Water 0 0 0 0 0 N/A -Transfer From TIF 2 1,769,550 1,941,750 1,877,250 1,877,250 2,302,000 22.63% -TIF Surplus Distribution 0 0 0 0 0 N/A -interest Earned 40,251 28,775 25.000 25,000 25,000 0:00% TOTAL.NEW REVENUE 2,182,483 2,363,946 1,922,250 1,922,250 2,347,000 22.10% Adjustment (To) From Fund Balance 1,166,200 603,804 423,750 (76,250) 556,006 31.21% TOTAL EXPENDITURES 3,348,683 2,967,750 2,346,000 1,846,000 2,903,000 23.74% BUDGET SUMMARY - FOUR YEAR COMPARISON D BUDGET % CHG B FUND /REVENUE SOURCE 04/30104 04/30105 FY 05/06 FY 05/06 FY 06/07 FY06 - >07 TAX INCREMENT FINANCING DISTRICT 1 - Lake Cook Rd (25) 0 0 0 0 - Investment Income 179,863 233,502 85,000 85,000 500 - 99.41% - Increment Prop. Tax 10,601,031 10,605,676 5,500;000 0 25,000 - 99.55% -Other .0 0 0 .8,364,890. 0 0 N/A TOTAL NEW REVENUE 10,780,894 10,839,178 5,585,000 8,449,890 25,500 - 99.54% Adjustment (To) - 75.00% TOTAL NEW REVENUE 38,155 381,775 1,050,500 1,288,500. From Fund Balance 811,440 3.083.918 5,915,000 3,136,627 224,500 - 96.20% TOTAL EXPENDITURES 1I1,58A 6f!,� 5 7 9 7I!',83:�.% L1 :M.:...- .. . - n2l:.50n.,0!l i0f0 ' ? , .Y n'e1t� j .j . + Cui:i laJlr,.ulu . .. i .:,.11,592,334 ...13,923,096 :.11.,500,000 ,...�!.. l TAX INCREMENT FINANCING DISTRICT 2 - Village,Center (26) TOTAL EXPENDITURES 574,082 407,681 760,600 - Grants .. 0 939,196 0 _ 0 0 N/A - Investment Income 68,456 137,741 125,000 125,000.. 145,000 16.00% - Increment Prop.. Tax 3,611,226. 4,093,121 .:.4,050,000 4,200,000 4,150,000 2.47% = Other/Transfers In 500.000 0 0 0 0 N/A TOTAL NEW REVENUE 4,179,682 5,170,058 4,175,000 4,325,000 4,295,000 2.87% Adjustment (To) . From Fund Balance From Fund Balance (758,825) (802.673) 387,250 (2,019,750) 2;6810-00--_-.: 592.58% TOTAL EXPENDITURES 3,420,857 41367,385 4,562,250 2,305,250 ,6',q77,000 77,000 � -i 52.93% INFRASTRUCTURE REPLACEMENT (22) - Transfers In 0 0 0 0 2,400,000 N/A -Home Rule Sales Tax 0 255,806 612,000: 750,000, 750,000 22.55% - Property Tax 0 0 45,000 45,000 45,000 0.00% -Other (TIF Surplus /Grants) 0 43,268 353,500 453,500 23,500 '. - 93.35% - Interest Earned 38,155 82.701 40.000 40.000 10.000 - 75.00% TOTAL NEW REVENUE 38,155 381,775 1,050,500 1,288,500. 3,228,500 207.33% Adjustment (To) From•Fund Balance 1,107,455 1,336,387 3,346,900 2,261,500 1,222,500 - 63.47% TOTAL EXPENDITURES 1,145,610 1,718,162 4,397,400 3,550,000 4,451,000 1.22% UGt MIill'iS12u, uu� 6l, luli!I mw!� 09IMrMITH1JILW�I";ci ."k, 20= 21 ui ]IIuGtJ �IL�I�t"�I" IG:Gt "u� ul'�iIG W U�!! � 11i1s�PdIE1 rt?i!w14 �u�I�Whu�4v7i tEu11G`lll t t� " ` " , GutL uIu� IR�l�Ilo�h� fW uJt111v{I! ulunu`Jg ia�l�l�4w� rtL � VEHICLE & EQUIPMENT REPLACEMENT FUND (21) - Interfund Transfer 516,810 523,431 509,737 509,737 532,583 4.48% -Interest/Misc. (9.356) 136.209 50.000 50.000 50.000 0.00% TOTAL NEW REVENUE 507,454 659,640 559,737 559,737 582,583 4.08% Adjustment (To) From "Fund Balance 66,628 (251.959) 200,863 (207,172) 523,917 160.83% TOTAL EXPENDITURES 574,082 407,681 760,600 352,565 1,106,500 45.48% m !'h�li�l!i,�Irll(� �f�ru�:uW�ffa ? ' 1 �wVI1E!I�I ! ° '10M( i I1'L�IIV!ID�I� 1 i �GII�f l6ti�f r�li !III flll� 4 !: EMERGENCY TELEPHONE SYSTEM (911) (17) - Surcharge Revenue 298,776 302,268 298,000 296,000 300,000 0.67% - Interest (1,859) 10,245 4,000 4,000 8,000 100.00% TOTAL NEW REVENUE 296,917 312,513 302,000 300,000 308,000 1.99% Adjustment (To) From Fund Balance 164,649 (81,070) (31,600) (84,890) 15,268 - 148.32% TOTAL EXPENDITURES 461,566 231,443 270,400 215,110 323,268 19.55% R "°" - �1 ' 1, c H ri SOLID WASTE SYSTEM (58) -User Fees 640,430 630,935 655,000 661,500 660,000 0.76% - Property Taxes 761,356 740,915 809,000 809,000 809,000 0.00% - Miscellaneous 16,758 26,762 27,000 29,000 9,000 - 66.67% - Interest (2168) 16,155 2,500 2.500 2,500 0.00% TOTAL NEW REVENUE 1,416,376 1,414,767 1,493,500 1,502,000 1,480,500 -0.87% Adjustment (To) From Fund Balance (34,990) (23,321) 148,220 43,320 193,984 30.88% TOTAL OPERATING EXPENSES 1,381,386 1,391,446 1,641,720 1,545,320 1,674,484 BUDGET SUMMARY - FOUR YEAR CONIRARISON YR.END YR.END BUDGET EST.YR.END BUDGET % CHG BUDG FUND /REVENUE SOURCE 04/30/04 04130/05 FY 05/06 FY 05/06 FY 06/07 FY06 - >07 COMM. STATION PARKING (60) -User Fees 151,133 202,498 223,000 199,500 203,000 -8.97% -Misc. Revenue. 0.-. 0 0 .0 0 N/A - Interest (2,019) 16,325 8,000 8,000 8,000 0.00% TOTAL NEW REVENUE 149,114 218.823 231,000 207,500 211,000 -8.66% Adjustment (To) From Fund Balances (105,541) (23.310) 16,019 19,100 41,580 159.57% TOTAL EXPENDITURES 43,573 195,513 • 247,019 226,600 252,580 2.25% D mm p+., 'r �.. + s " .Y . 7 N <'i�i;' I ++ ' `4 _ +a I �� a 3'u"4. +. a i +:. i�l:l 1 :: u: 1r7,.+u�.; . I + l: '.7ulet+'�.'JR�.1'.Ci:a�i'I:.w ..I.k, 4, . +i. n: rt m. . +:.. .,'gym'. -. 1: n x' F. °9f : 1, ^ '°"II:HT ..yy.r°i n:.' +.: +;+. i — . L3 H. .�+ . + - �j13 h. •'a�¢I + + i..l'� +i . I. �I „�, I.�,..+lu..: ?.:F.w..u� I e ..+ Is.;:ILtil::l�l.,.�l'aI�Tw lu::�,:1 : u. ilr�l PROJECT 29 (29) 1�'I uG : .a ,il�!.:�I.I:tI::W:.w+:n1.�a.. = Miscellaneous 0 0 0 0- 0 N/A - Interest 3,328 2.812 3.000 3,000 3,000 0.00% TOTAL NEW REVENUE 3,328 2,812* 3,000 3,000 3;000 0.06%- Adjustment (To) From Fund Balance (3,328) (2,812) (2,500) (3,000) (2.500) 0.00% TOTAL EXPENDITURES 0 0 500 0 . 500. 0.00% TOTAL NEW REVENUES 41,533,236 45,611,641 43,434,793 42,495,641 37,637,589 - 13.350/ 4djustment (To) . From Fund Balance 688.507 1,424,915 5,919,101 2,846,859 10,312;496 74.220/ TOTAL EXPENDITURES 42,221,742 47,036,556 56,047,119 45,342,500 47,950,085 - 14.450i 0.5 0.45 0.4 0.35 0.3 W Q 0.25 Ix 02 0.15 0.1 0.05 0 VILLAGE PROPERTY TAX RATE - $ /$100 OF EQUALIZED ASSESSED VALUATION 1997 1998 1999 2000 2001 2002 2003. 2004 2005' 2006+ TAX YEAR ( +projected) 2006 Property Tax Levy with Five Year Comparison Funtl Proposed 2002 20:03 2004 2005 -:2006 Change_ General 1,316,250 1,316,250 1,282,250 1,985,000 ...1,985,000 0.0% Infrastructure 0 0 330,000 45,000 45,000 0.0% Scavenger 755,000 755,000 778,000 809,000 809,000. 0.0% Debt Service (net) 319,000 319,000 0 0 0 NIA 2,390,250 2,390,250 2,390,250 2,839,000 2,839,000 Total Village 0.0% Library 1,687,790 1,708,955 2,006,984 2,357,350 2,496,433 5.9% Combined Levy 4,078,040 4,099,205 4,397,234 5,196,350: 59335,433. 2.7% Tax Bate History EAV 871,070,465 921,735,951 992,399,806 1,211,600,000 1,260,064,000 4.0% Tax Rate (est) (est) Village .0.279 0.260. 0.244 6.234 0.225 -3.7% Library 0.194 0.185 0.204 0.195 0.198 1.6% Combined 1 0.4731 0.4481 0.4481 0.4291- 0.423 -1.3% EAV for 2005 includes projected TIF 1 increment. 03/22/2006 VILLAGE OF DEERFIELD PG 1 12:22 RWF• REVENUE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY'2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE -----------------------------------------------------------------------------------------------------=------------------------ - - - - -- 100001 GENERAL FUND REVENUE ST INC TX -------------------------------------------- 41 TAXES 340,000.00 --------------------------------------- 100001 - - - - -. 4110 PROP TAX 1,176,654.63 1,985,000.00 1,985,000.00 FOR CURRENT YEAR AND PROJECTION NO INCREASE PER DIRECTION OF VILLAGE BOARD 8,786,542.14 100001 4112 PRTX ROAD - 13,446.55 .00 00 100001 4114 PRTX.PR YR .00 10,000.00 10,000.00 100001 4115 TIF SRPLUS 408,487.67 .00 .00 100001 4120 REPLACEMT 34,965.69 10,000.00 10,000.00 100001 4140 ST SALES 3,978,766.72 3,560,000.00 3,560,000..00 100001 THIS IS THE GROSS AMOUNT AND INCLUDES AMOUNTS TO BE PAID TELECOM TX 298,021.43 TO WALGREEN AND DEERBROOK MALL FOR INCENTIVES. 1,500,000..00 100001 4141 HR SALES 255,806.34 612,000.00 612,000.00 TOTAL TAXES 5011 OF TOTAL HOME RULE GOES TO GENERAL FUND 9,279,561.49 9,870;670.00 AND 50% TO INFRASTRUCTURE FUND. LICENSES & PERMITS GROSS AMOUNT WHICH INCLUDES INCENTIVE TO BE -------------------------------------------- 100001 PAID TO WALGREEN'S PER AGREEMENT. LIQR LIC 100001 4142 LOC USE TX 197,039.12 202,620.00 202,620.00 4213 ESTIMATES FOR CURRENT YEAR AND PROJECTION FOR NEXT YEAR 5,676.00 6,500.00 BASED ON ILL MUNICIPAL LEAGUE. 4214 100001 4150 ST INC TX 1,247,027.42 1,307,800.00 340,000.00 PROJECTING A SLIGHT INCREASE DUE TO RECOVERY IN STATE 298,000.00 ESTIMATE FOR CURRENT YEAR AND PROJECTION FOR NEXT YEAR 8,786,542.14 BASED ON ILL MUNICIPAL LEAGUE. .8.4% 100001 4160 HOTEL TAX 1,669,345.92 1,843,250.00 6,500..00 PROJECTING A 1 %.INCREASE IN BUDGETED AMOUNT DUE TO 8,000.00 EXPECTED SLOW RECOVERY IN THIS ACTIVITY. 5,365.00 100001 4170 TELECOM TX 298,021.43 340,000.00 1,500,000..00 DECREASE TO REFLECT ACTUAL ACTIVITY. TOTAL TAXES 9,279,561.49 9,870;670.00 42 LICENSES & PERMITS -------------------------------------------- 100001 4211 LIQR LIC 63,225.00 73,000.00 100001 4213 FOOD LIC 5,676.00 6,500.00 100001 4214 BUSN LIC 5,282.50 28,000.00 100001 4220 BLDG PERM 861,823.12 350,000.00 INCREASE DUE TO EXPECTED CONTINUATION OF ACTIVITY. 1,214,012.42 4,938.76 .00 .00 55,750.4'9 3,632,618.59 743,862.69 174,024.47 1,307,800.00 1,032,444.31 1,985,,0.00'.00 .00 10 1.000. 00 .00 `10,000.00 4,060,000.00 750;000.00 202,.620.00 1,396,236.00 1,985,060.00 .0% .00 .0% 10,000:00 .0% .00 .0% 45,000.00 ..350.0% 4,050,000.00 13.8% 750,000.00 22.5% 229,100.00 13.1% 1,458,800.00 11.5% 1,843,250.00 1,692,116.45 1,843,250.00 1,875,000.00 1.7% 340,000.00 236,773.9.6 298,000.00 295,000.00 -13.2% 9,870,670.00 8,786,542.14 .10,495,106.00 10,697,900.00 .8.4% 73,000.00 64,750.00 73,000.00 71,060.00 -2.7% 6,500..00 8,235.00 61500.00 8,000.00 23.1% 28,000.00 5,365.00 26,000.00 28,000.00 .0% 350,000.00 1,468,695.60 1,500,000..00 550,000.00 57.1% 03/22/2006 VILLAGE OF DEERFIELD PG 2 12:22 RWF REVENUE BUDGET - REQUEST - FY 2006/07 bgriyrpts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR.PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007. PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ------------ 100001 - ---------- 4222 - - - - -- ------------------------------------------ CONTR LIC 36,467.70 4,500.00 - - - - -- 4,500.00 - - - -- - - 37,696.50 - 30,000.00 - 5,500.00 22.20 100001 4232 LIC & PERM 81,605.07 50,000.00 50,000.00 45,082.95 50,000.00 50,000.00 .0% 100001 4233 ALRM PERM 2,600.00 3,000.00 3,000.00 2,825.00 3,000.00 3,000.00 .0% 100001 4240 VEH LIC 333,922.00 340,000.00 340,000.00 323,821.00 332;000.00 340,000.00 .0% ADDITIONAL REVENUE EXPECTED FROM AN ENHANCED COLLECTION EFFORT. TOTAL LICENSES & PERMITS 1,390,601.39 855,000:00 855,000.00 1- ,956,471..05 2,022,500.00 1,055,500.00 23.5% 43 INTERGOVERNMENTAL & -------------------------------------------- 100001 4310 MFT REV 285,000.00 .00 .00 .00 00'. .00 - .0% MFT WILL BE USED FOR INFRASTRUCTURE PROJECTS IRF LEVY IN THE AMOUNT OF $285,000 IS NOW IN GF LEVY. 100001 4330 ST GRANT 9,655.48 6,000.00 6,000.00 26,185.11 29,000.00 6,000.00. .0% 100001 4350 FED GRANT 1,821.50 - .00 ..00 .00 00 .00 .0% TOTAL INTERGOVERNMENTAL & 296,476.98 6,000.00 6,000.00. 26,185.11 29,000:00 61000.00 0% 44• CHARGES FOR SERVICES - - - - - -- 100001 ------------------------------------ 4415 CIS WLGRN 14,024.'00 12,500.00 12,500.00 13,215.04 12,500.00 12,500.00 .0% 100001 4417 CIS POL OT 195,218.00 191,500.00 191,500..00 180,774..5.3 191,500.00 296,100.00 54.6% PRIMARILY RAVINIA DETAIL REVENUE. 100001 4419 CIS OTHER 9,469.92 .00 .00 11,624.92 .00_ .00 .0% 100001 4420 CIS MAT SL .00 2,000.00 2,000:00 ..00 5.00.00 2,000.00 .0% 100001 4425 CIS BNK DI 78,340.00 79,000.00 79,000.00 71,534.00 79,000.00 79,000.00 .0% 100001 .4430 CIS ENGIN 1,667.00 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0% 100001 4462 CIS TREE 5,084.00 1,000.00 1,000.00 41,646.50 11,000.00 3,000.00 200.0% 100001 4463 CIS HWY MT 35,507.25 28,00.0.00 28,000.00 .00 28,000.00 28,000.00 .0% 100001 4464 CIS TSM 5,006.55 .00 .00 00 .00 .00 .0% TOTAL CHARGES FOR SERVICES 344,316.72 316,000.00 316,000.00 318., 79:4.99 324;500.00 422,600.00 33.7% 45 FEES & FINES -------------------------------------------- 100001 4510 ORD,V CTY 150,319.15 137,500.00 137,500.00 136,717.39 137,500.00 145,000..00 5.5°% 100001 4511 ORD V VIL 36,293.10 50,000..00 50,000.00 34,014.18 50,000.00 50,0.00.00 .0% 100001 4520 FLSE.ALRM 37,590.00 50,000.00 50,000.00. 34,537.14 40,000.00 40,000.00 - 20.0°% 100001 4521 ALRM MNTR 33,769.98 .00 .00 20,802.35 15,000.00 .10,000.00 .0% 100001 4530 RSTIT FINE 588.00 .00 .00 3,103.00 .00 .00 .0% 100001 4540 OVR SZ VEH 6,910.00 2,500.00 2,500.00 8,870.00 4,8.00.00 2,500.00 .0% 100001 4560 FF & PEN 2,140.04 .00 .00 1,587.23 .00 ..00 .0% TOTAL FEES & FINES. 267,610.27 240,000.00 240,000.00 239,631.33 247,300.00 247,500.00 3.1% 46 INVESTMENT INCOME -------------------------------------------- 100001 4610 INTER EARN 384,938.32 420,000.00 420,000.00 .00 420,000.00 460,000.00 9.5% 03/22/2006 VILLAGE OF DEERFIELD PG 3 12:22 RWF REVENUE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD .13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE --------------------------------------------------------------------------------------------- 100001 4612 NCHGFRVAL - 63,548:94 .00 .00 ------------- .00. - -------------------------- .00 .00 .0% 100001 4622 UNRLZD G/L - 6,187..15 .00 .00 .00 .00 ..00 .0'% TOTAL INVESTMENT INCOME 315,202.23 420,000.00 420,000.00 .00. 420,000,.'00 460,000.,00 9.5% 48 MISCELLANEOUS REVENU -------------------------------------------- 100001 4810 MISC REV 65,205.69 52,000.00 52,000.00 32,853.90 .52,000.00 27,50.0.00 -47.10 100001 4811 RENT INC 15,265.00 12,000.00 12,000.00 7,450.00 12,000.00 20,000..00 66.7% 100001 4821 PLZA ENT 1,350.00 5,00.0.00 5,000.00 550.00 5,000.00 5,000..00 .0% 100001. 4822 FAM DY DON 59,489.83 40,000.00 40,000.00 51,123.60 55_,000.00 55,000.00 37.5% INCLUDES DONATIONS FOR MUDFEST 100001 4843 WC REIMB 39,127.25 .00 .00 35,706.35 .00 ..00 .0% 100001 4844 INS REIMB 5,727.00 .00 .00 5,865.12. .00 a -.00 016 100001 4851. SALE EQPM 4,606.00 .00 .00 .00 .00 1,500.00 Oo 100001 4880 CABLE TV 209,524.31 230,000.00 230, 00.0. 00. 219,974.51 230,000.00 210,000.00 -8.716 TOTAL MISCELLANEOUS REVENU 400,295.08 339,000.00 339,000.00 353,56.3:48 354,000.00 319,000.00 -5.9% 49 TRANSFERS IN (IFT) . -------------------------------------------- 100001 4910 TRSNFR IN 146,000.00 142,000.00 142,000.00 .00 142,000.00. 142,000.00. 0% REPRESENTS OVERHEAD TRANSFER FROM COMMUTER PARKING FUND. TOTAL TRANSFERS IN (IFT) 146,000.00 142,000.00 142,000.00 .00 142,000.00 142,000.00 .016 TOTAL GENERAL FUND REVENUE 12,440,064.16 12,188,670.00 12,188,670.00 11,681,188.10 14,034.,406.00 13,350,500.00 9.516 TOTAL GENERAL FUND 12,440,064.16 12,188,670.00 12,188,670.00 11,681,188.10 14.,0341406.00 13,350,500.00 9.5% 03/22/2006 VILLAGE OF DEERFIELD PG 4 12:22 RWF REVENUE BUDGET REQUEST - FY- 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT MOTOR FUEL TAX FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 140001 MOTOR,FUEL TAX REVENUE 43 INTERGOVERNMENTAL & -------- - - - - -- ------------------------ 140001 4310 MFT REV 538,542:97 522,207.00 - 522,207.00 446,289 -:12- 524 -,970.00 _524_,97.0.00 5% ESTIMATE AND PROJECTION. BASED ON ILL MUNICIPAL LEAGUE. 140001 4330 ST GRANT 9,945.00 .00 .00 9,511 -.00 .00 .00 .0% TOTAL INTERGOVERNMENTAL & 548,487.97 522,207.00 522,207.00 455,800.12 524,9.70:00 524,9.70.00 5% 46 INVESTMENT INCOME -------------------------------------------- 140001 4610 INTER EARN 28,383.44 20,000.00 20,000.00 .00. 20,000.00 25,000.00 25.0% 140001 4612 NCHGFRVAL - 3,822.34 .00 .00 .00 .00 .00. .016 TOTAL INVESTMENT INCOME 24,561.10 20,000.00 .20,000.00 .00 20,000:00 25,000;.00 25.0% TOTAL MOTOR FUEL TAX REVENUE 573,049.07 542,207.00 542,207.00 455,800.12 5441970..00 549,970.00 1.4% TOTAL MOTOR FUEL TAX FUND 573,049.07 542,207.00 542,207.00 455,800.12 54:4,970.00 549,970.00 1.4% 03/22/2006 VILLAGE.OF DEERFIELD PG 5 12:22 RWF REVENUE BUDGET-REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT E 911 FUND -----------------------------------------------------------------------------------------------------=------------------------------ ACTUAL ORIG BUD REVISED-BUD ACTUAL PROJECTION FIN REVIEW CHANGE 170001 E911 FUND REVENUES -------------------------------------------- 44 CHARGES FOR SERVICES -------------------------------- 170001 4410 E911 SRCH 157,059.55 165,000.00 165,000.00 112,049..69 161,000.00 162,000.00 -1.80 170001 4411 CELL 911 141,840.75 133,000.00 133,000.00 119,482.87 135,000.00 .138,000.00 3.80 170001 4425 CIS BNK DI 3,367.92 .00 .00 .00 00 .00 .0% TOTAL CHARGES FOR SERVICES 302,268.22 298,000.00 298,000.00 231,532..56 296,'00.0. 00 300,000:00 .7% 46 INVESTMENT INCOME -------------------------------------------- 170001 4610 INTER EARN 11,839.08 4,000.00 4,000.00 .00 4.,000.00 8,000.00 100.0% 170001 4612 NCHGFRVAL - 1,594.34 .00 .00 .00 .00 00 .0% TOTAL INVESTMENT INCOME 10,244.74 4,000.00 4,000.00 .00 4,000.00 8,000.00 100.0% TOTAL E911 FUND REVENUES 312,512.96 302,000.00 302,000.00 231,532.56 300;000.00 308,000.00 2.0% TOTAL E 911 FUND. 312,512.96 302,,000.00 302,000.00. 231,532.56 300,006.00 308,000.00 2.0% 03/22/2006 VILLAGE OF DEERFIELD PG 6 12:22 RWF REVENUE BUDGET REQUEST - FY 2006/07' bgnyrpts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT VEHICLE & EQUIPMENT REPLACE. ----------------------------------------------------------------------------------------:-------------------------------=------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 210001 VERF REVENUES -------------------------------------------- 44 CHARGES FOR SERVICES _ - - -------------------------------------------- 210001 4480 CIS FUNDS .00 509,737.00 509,737.0.0 .00 509,737.00 532,583.0.0 4.5%. TOTAL CHARGES FOR SERVICES .00 509,737.00 509,737.00 .00 509,737.00 532,583,.00. 4.516 46 INVESTMENT INCOME -------------------------------------------- 210001 4610 INTER EARN 86,766.94 50,000.00 50,000.00 .00 50:1000.00 50,000.00 .016 210001 4612 NCHGFRVAL - 13,020.48 .00 .00 .00 .00 .00 .0% 210001 4622 UNRLZD G/L - 733.16 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 73,013.30 50,000.00 50,000.00 .00 501000.00 50,000.00 .0% 48 MISCELLANEOUS REVENU -------------------------------------------- 210001 4844 INS REIMB 16,200.00 .00 .00 .00 .00 .00 .0% 210001 4852 G/L FADISP 46,996.00 .00 .00 .00 .00 :00 .0% TOTAL MISCELLANEOUS REVENU 63,196.00 .00 .00 .00 00 .00 .0% 49 TRANSFERS IN (IFT) -------------------------------------------- 210001 4910 TRSNFR IN 523,431.00 .00 .00 .00 .00 00 .0% TOTAL TRANSFERS IN (IFT) 523,.431.00 .00 .00 00 .00 .00 .0% TOTAL VERF REVENUES 659,640.30 559,737.00. 559,737.00 .00 5590737.00 582,583.00 4.1% TOTAL VEHICLE & EQUIPMENT RE 659,640.30 559,737.00 559,737.00 .00 559.,737.00 582,583.00 4.1% J 03/22/2006 VILLAGE OF DEERFIELD PG 7 12:22 RWF REVENUE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT INFRASTRUCTURE REPLACEMENT ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 220001 INFRA REPLACE FUND REVENUE - - -- - 41 TAXES -------------------------------------------- 220001 4110 PROP TAX .00 45,000.00 45,000.00 317,492.12 45,.000.00 45,000.00 .0% 220001 4115 TIF.SRPLUS. .00 350,000.00 350,000.00 453,121.54 450,000.00 20,000.00 -94.3% 220001 4141 HR SALES 255,806.35 612,000.00 612,000.00 .743,862.68 750,000.00 750,000.00. 22.5% THIS FUND RECEIVES HALF OF THE .0.596 HOME RULE SALES TAX. TOTAL TAXES 255,806.35 1,007,000:00 1,007,000.00 1,514,476.34 1,24,5,000.00 815,000.00 -19.1% 43 INTERGOVERNMENTAL & - -------------------------------------------- 220001 4330 ST GRANT :00 .00 .00 92,685.01 .00 .00 .016 220001 4370 CTY GRANT 43,268.00 .00 .00 .00 .00 00 .0% TOTAL INTERGOVERNMENTAL & 43,268.00 .00 .00 92,685.01._ 00 00 .0% 44 CHARGES FOR SERVICES ------------.-------------------------------- 220001 4460 C/S SIDEW .00 3,500.00 3,500.00 .00 3,500,00 3,500.00 .0% TOTAL CHARGES FOR SERVICES .00 3,500.00 3,500.00 .00 3_;500.00 3,500.00 .0% 46. INVESTMENT INCOME -------------------------------------------- 220001 4610 INTER EARN 97,508.46 40,000.00 40,000.00 .00 40,000.00 10,000:00 -75.0% 220001 4612. NCHGFRVAL - 151432.44 .00 .00 .00 .00 .00 .0% 220001 4622 UNRLZD G/L 625.00 .00 .00 .00 .00_ .00 .0% TOTAL INVESTMENT INCOME 82,701.02 40,000.00 40,000.00 .00 40,000.00 10,000.00 -75.0% 49 TRANSFERS IN (IFT) -------------------------------------------- 220001 4910 TRSNFR IN .00 .00 .00 .00 00. 2,400,000.00 .0% $1,800,000 FROM GENERAL FUND $600,000 FROM DEBT SERVICE FUND TOTAL TRANSFERS IN (IFT) .00 .00 00 .00 ..00 2,400,000,.00 .0% TOTAL INFRA REPLACE FUND REV 381,775.37 1,050,500.00 1,050,500.00 1,607,161.35 1,288,500.00 3,228,500:00 207.3% TOTAL INFRASTRUCTURE REPLACE 381,775.37 1,050,500.00 1,050,500.00 1,607,16.1.35 1,288,;500.00 3,228,500.00 207.3% 03/22/2006 VILLAGE OF DEERFIELD PG 8 12:22 RWF REVENUE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT LAKE COOK RD TIF (TIF 1) ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL' ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 250001 TIF 1 REVENUES 41 TAXES -------------------------------------------- 250001 4110 PROP TAX 10,605,675.81. 5,500,000.00 5,500,000.00 8,37,1,865.21 5,500,000.00 25,000.00 -99.5% THE DISTRICT EXPIRED ON 12/31/2004. LATE PROPERTY TAX PAYMENTS WILL RESULT IN CONTINUED REVENUE TO THIS FUND. ALL REVENUE COLLECTED WILL BE RETURNED TO THE TAXING DISTRICTS AS SURPLUS. TOTAL TAXES 10,605,675.81 5,500,000.00, 5,500,000.00 8,371,865.21 5,5.00,000.00. 25,000.00 -99.5% 46 INVESTMENT INCOME -------------------------------------------- 25000.1 4610 INTER EARN 282,982.29 85,000.00 85,000.00 .00 85;000.00 500.00 -99.4% 250001 4612 NCHGFRVAL - 49,322.48 .00 .00 .00 .00 .00 .0% 250001 4622 UNRLZD G/L - 157.82 .00 .00 .00 00 .00 0% TOTAL INVESTMENT INCOME 233,501.99 85,000.00 85,000.00 .00 85,00.0.00 500.00 -99.4% TOTAL TIF 1 REVENUES 10,839,177.80 5,585,000.00 5,585,000.00 8,371;865.21 5,585,000.00 25,500'.00 -99.5% . TOTAL LAKE COOK RD TIF (TIF 10,839,177.80, 5,585,000.00 5,585,000:00 8,371,865.21. 5,585;000.00 25,500.00 -99.5% 03/22/2006 VILLAGE OF DEERFIELD PG 9 12:22 RWF REVENUE BUDGET REQUEST-- FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 .2006 2007 PCT VILLAGE CENTER TIP (TIP 2) --------------------------------------------------------------------------------------------------- ACTUAL ORIG BUD REVISED BUD. ACTUAL PROJECTION FIN REVIEW CHANGE 260001 TIF 2 REVENUES -------------------------------------------- 41 TAXES -------------------------------------------- 260001 4110 PROP TAX 4,093,120.63 4,050,000.00 4,050,000.00 4,121,570.01 4,050,000:00 4,150,000.00 2.50 TOTAL TAXES 4,093,120.63 4,050,000.00 4,050,000.00 4,121,570.01 4,050',000.00 4,150,000:00 2.5% 43 INTERGOVERNMENTAL & -------------------------------------- 260001 4330 ST GRANT - - - - -- 939,196.33 .00 .00 28.8,913.58 . _ ..00 .00 .0 °s THIS WAS THE GRANT FOR THE PEDESTRIAN OVERPASS THAT -WAS COMPLETED IN FY 04/05. TOTAL INTERGOVERNMENTAL & 939,196.33 .00 .00 288,913.58 7100 .00 .0% 46 INVESTMENT INCOME ----------------------------------- -------- 260001 4610 INTER EARN 164,061.72 125,000.00 125,000.00 .00 125,_00,0.00 145,000.00 16.0% 260001 4612 NCHGFRVAL - 25,754.80 .00 .00 .00 .00 .00 .0% 260001 4622 UNRLZD G/L - 565.66 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 137,741.26 125,000.00 125,000.00 .00 .125,000.00 145,000.00 16.0% 48 MISCELLANEOUS REVENU -------------------------------------------- 260001 4810 MISC REV .00 .00 .00 6,885.22 .00. .00 .0% TOTAL MISCELLANEOUS REVENU, 00. .00 .00 6,885.22 00. .00 .0% TOTAL TIF 2 REVENUES 5.,170,058.22 4,175,000.00 4,175,000.00 .4;417.,368.81 4,175,000.00 4,295,000.00 2.9% TOTAL VILLAGE CENTER TIF (TI 5,170,058.22 4,175,000.00 4,175,000.00 4,417,368..81 4,175,.000.00 4,295,.000.00 2.9% 03- /22/2006 VILLAGE OF DEERFIELD PG 10 12:22 RWF REVENUE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 .2006 2007 PCT PROJECT 29 FUND ----------------------------------------------------------------------------------=------------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 290001 PROJECT 29 REVENUES -------------------------------------------- 46 INVESTMENT INCOME -------------------------------------------- 290001 4610 INTER EARN 2,811.91 3,000.00 3,000.00 .00 3.,000.00 3,000.00 .0% TOTAL INVESTMENT INCOME 2,811.91 3,000.00 3,000.00 .00 3,000.00 3,000..00 .0% TOTAL PROJECT 29 REVENUES 2,811.91 3,000.00 3,000.00 .00 .3,000.00 3,000.00 .016 TOTAL PROJECT 29 FUND 2,811.91 3,000.00 3,000.00 .00 3,000.00 3,000:00 .0% 03/22/2006 VILLAGE OF DEERFIELD PG 11 12:22 RWF REVENUE BUDGET REQUEST - FY 2006/07 bgnyi-pts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT DEBT SERVICE FUND --- - -------------------------------------------------------------------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 350001 DEBT SERVICE REVENUE -------------------------------------------- 41 TAXES -------------------------------------------- 350001 4110 PROP TAX 327,725.01 .00 .00 .00- .00 .00. .0% 350001 4120 REPLACEMT 65,695.67 20,000.00 20,000.00 10,517.17 20,000.00 20,000.:00 .0 %. TOTAL TAXES 393,420.68 .20,000.00 20,000.00 10,517.17 20,000.00 20,000.00 .0% 46 INVESTMENT INCOME -------------------------------------- 350001 4610 INTER EARN 35,672.56 25,000.00 25,000.00 .00 25,000.00 25,000.00 .0% 350001 4612 NCHGFRVAL - 7,399.39 .00 .00 .00 .00 .00 .0% 350001 4622 UNRLZD G/L 500.00 .00 .00 .00 .00 .00 016 TOTAL INVESTMENT INCOME 28,773.17 25,000.00 25,000.:00 .00 25,000:00. 25,000.00 .0% 48 MISCELLANEOUS REVENU -------------------------------------------- 350001 4810 MISC REV 1.58 .00 .00 .00 .00 .00 .0% TOTAL MISCELLANEOUS REVENU 1.58 00 .00 .00 .00 .00 .0% 49 TRANSFERS IN (IFT) -------------------------------------------- 350001 . 4910 TRSNFR IN 1,941,750.00 1,877,250..00 , 1,877,250:00 1,704,750.00 1,877,250.00 2,302,000.00 22.6% TRANSFER IN FROM TIF 2 OF ALL DEBT SERVICE DUE ON 1998 ISSUE. TOTAL TRANSFERS IN (IFT) 1,941,750.00 1,877,250.00 1,877,250.00 1,704,750:00 1,877,250.00 2,302,000.00 22.6% TOTAL DEBT SERVICE REVENUE 2,363,945.43 1,922,250.00 1,922,250.00 1,'715,267.17 1,922,250.00 2,347,000.00 22.10 TOTAL DEBT SERVICE FUND 2,363,945.43 1,922,250.00 1,922,250.00 1,715,267.17 1,922;250.00- 2,347,000.:00 22.10 03/22/2006 VILLAGE OF DEERFIELD PG 12 12:22 RWF REVENUE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006_ 2006 2006 2007 PCT WATER FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 500001 WATER FUND REVENUES 42 LICENSES & PERMITS -------------------------------------------- 500001 4216 WTR PERM 39;100.00 30,000.00 30,000.00 45,280.00 40,0.00.00 30,000.00 .0% PROPOSAL IS TO INCREASE TAP -ON FEES, UNCHANGED SINCE 19817 TOTAL LICENSES & PERMITS 39,100.00 30,000.00 30,000.00 45,280.00 40,000.00 30,000.00 .0% 44 CHARGES FOR SERVICES -------------------------------------------- 500001 4451 CIS UB 4,032,549.59 4,065,627.18 4,065,627.00 4.,.366,588.75 4,265;:000.00 4,167,267.68 2.5% REPRESENTS PROPOSED 2.5% INCREASE IN RATE DUE TO HIGHLAND PARK PROPOSED WHOLESALE RATE INCREASE. SCHEDULED HIGHLAND PARK 5.0% INCREASE MAY 1. 500001 4452 CIS UB MSC 6,048.87 .00 .00 7,952.96 .00 00 .0% 500001 4453 CIS UB PEN 53,222.57 35,000.00 35,000.00 45,431.56 35,000.00 35,000.00 .0% INCREASE DUE TO TIGHTER RESTRICTIONS ON LATE PAYMENTS AND IMPOSITION OF SHUT- OFF /TURN -ON FEES. TOTAL CHARGES FOR SERVICES 4,091,821.03 4,100,627.18 4,100,627.00 4.,421,973.27- 4,300,000..00 4,202,267.68 2.5% 46 INVESTMENT INCOME -------------------------------------------- 500001 4610 INTER.EARN 74,159.83 55,000.00 55,000.00 .00 55,000..00 55,000.00 ..0% DECREASE DUE TO LOWER EXPECTED CASH BALANCES. 500001 4612 NCHGFRVAL - 11,957.56 .00 .00. .00 00 .00 .0% 500001 4622 UNRLZD G/L 307.40 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 62,509.65 55,000.00 55,000.00 .00 55,000.00 55,000.00 .0% 48 MISCELLANEOUS REVENU -------=------------------------------------ 500001 4810 MISC REV 27,631.52 8,500.00 8,500.00 43,134.36 39,00.0 00 10,000.00 17.6% 500001 4843 WC REIMB .00 .00 .00 22,278.77 .00 .60 .016 500001 4844 INS REIMB .00 .00 .00 358.00 .00 .00 .01 TOTAL MISCELLANEOUS REVENU 27,631.52 8,500:00 8,500.00 65,771.13 39,000.00 -10,000.00 17.6% TOTAL•WATER FUND REVENUES 4,221,062.20 4,194,127.18 4,194,127.00 4,533,024.40 4,434,000:00 4,.297,267:68 2.56 TOTAL WATER FUND 4,221,062.20. 4,194,127.18 4,194,127.00 4,533,024.40 4,434;000.00 4,297,267..68 2.5% 03/22/2006 VILLAGE OF DEERFIELD. PG 13 12:22 RWF REVENUE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR.PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION' FIN REVIEW CHANGE 540000 SEWER FUND BALANCE SHEET -------------------------------------------- 48 MISCELLANEOUS REVENU -------------------------------------------- 540000 .4834 AST CNTR 70,947.36 .00 .00 .00 .00 .00 .0% TOTAL MISCELLANEOUS REVENU 70,947.36 .00. .00 .00 .00 .00 0% TOTAL SEWER FUND BALANCE SHE 70,947.36 .00 .00 -.00 .00 .00 .0% 03/22/2006 VILLAGE OF DEERFIELD PG 14 12:22 RWF REVENUE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 200.5 2006 2006 2006 2006 2007 PCT SEWER FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL. PROJECTION FIN REVIEW CHANGE 540001 SEWER FUND REVENUES -------------------------------------------- 42 LICENSES & PERMITS -------------------------------------------- 540001 4215 SWR PERM 36,075.00 10,000.00 10,000.00 40,401.00 32,000..00 17,500.00 75.0% TOTAL LICENSES & PERMITS 36,075.00 10,000.00 10,000.00 40,401.00. 32,000.00 17,500.00 75.0% 44 CHARGES FOR SERVICES --------------------------------------- 540001 4451 CIS UB 1,,713,520.44 1,772;160.00 1,772,160.00 1,660,217.04 2,100.,000.00 2,400,000.00 35.4 %, REPRESENTS NO CHANGE IN SEWER RATE. BUT A FULL YEAR AT HIGHER RATE IMPOSED IN FY 2005/06. 540001 4453 CIS UB PEN 27,360.89 34,000.00 34,000.00 17,040.31 34,000.00 34,000.00 .0% 540001 4495 CIS OTHER .00 35,000.00 35,000.00 .00 10,000.00. 15,000.00 -57.1% TOTAL CHARGES FOR SERVICES 1,740,661.33 1,841,160.00 1,841,160.00 1,677,257.35 2,144,000.00 2,449,000.00 33.0% 46 INVESTMENT.INCOME 540001 4610 INTER EARN 21,832.15 20,000.00 20,000..00 .00 20,000.00 10,000.00 -50.016 DECREASE DUE TO SMALLER AVAILABLE CASH BALANCE. 540001 4612 NCHGFRVAL - 3,781.46 .00 00 .00 .00 :00 .0% 540001 4622 UNRLZD G/L 360.41 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 18,411.10 20,000.00 20,000.00 .00 201000.00 10,000.00 -50.06 48 MISCELLANEOUS REVENU ------------=------------------------------- 540001 4810 MISC REV 7,942.27 5,000.00 5,000.00 2,440.25 5,000.00 5,000.00 .0% 540001 4843 WC REIMB .00 .00 .00 1,617.16 :00 .00 .0% TOTAL MISCELLANEOUS REVENU 7,942.27 5,000.00 5,000.00 4,057.41 5,000.00 5,000.00 .0% 49 TRANSFERS IN (IFT) -------------------------------------------- 540001 4910 TRSNFR IN .00 3,000,000.00 3,000,000.00 .00 .00 1,600,000:00 -46.7% TRANSFER IN FROM GENERAL FUND RESERVES TO FUND CAPITAL PROGRAM AS NECESSARY DEPENDENT ON TIMING OF CAPITAL IMPROVEMENTS TOTAL-TRANSFERS IN (IFT) ...00 3,000,000.00 3,000,000.00 .00 .00 1,600,000.00 - 46..7% TOTAL SEWER FUND REVENUES 1,803,309.70 4,876,160.00 4,876,160.00 1,721,715.76 2,201,000.00 4,081,500.00 -16.3% TOTAL SEWER FUND 1,674,257.06 4,876,160.00 4,876,160.00 1,721,715:..76 2,201,000:00 4,081,500.00 -16.3% 03/22/2006 VILLAGE OF DEERFIELD PG 15 12:22 RWF REVENUE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT REFUSE FUND -----------------------------------------=------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 580001 REFUSE FUND REVENUES -------------------------------------------- 41 TAXES -------------------------------------------- 580001' 4110 PROP TAX 740,915.19 809,000.00 809,000.00 .746,602.50 809.,000.00 809,000.00 .0% NO INCREASE PER DIRECTION OF VILLAGE BOARD TOTAL TAXES 740,915.19 809,000.00 809,000.00 746,602.50 809,-000.00 809,000.00 .0% 44 CHARGES FOR SERVICES -------------------------------------------- 580001 4451 CIS. UB 601,445.86 635,000.00 635,000.00 544,565.05 635,000.'00 635,000.00 .0% NO CHANGE IN DIRECT CHARGE TO USERS CONTEMPLATED 580001. 4453 CIS UB PEN 9,358.37 5,000.00 5,000.00 6,097.24 .6,500.00 5;000..00 .0% 580001 4454 CIS REF CN 20,131.25 20,000.00 20,000.00 17,437.55 20,000.0.0 20,000:00 .0% TOTAL CHARGES FOR SERVICES 630,935.48 660,000.00 660,000.00 568.,099.84 6611500.00 660,000.00. .0% 46 INVESTMENT INCOME -------------------------------------------- 580001 4610 INTER EARN 18,669.32 2,500.00 2,500.00 .00 2,500.00 2,500.00 .0% 580001 4612 NCHGFRVAL - 2,514.16 .00 .00 .00 .00 .,00 .0 %. TOTAL INVESTMENT INCOME 16,15.5.16 2,500.00 2,500.00 .00 2,500.00 2,500.00 .0% 4`8 MISCELLANEOUS REVENU ---------------------------------------.----- 580001 4810 MISC REV 6,495.60 12,000.00 12,000.00_ 3,844.40 12,000.00 9,000.00 -25.0% 580001 4835 RECYCLE 20,266.47 10,000.00 10,000..00 19 ;095.39 17,.000.00 .00 - 100.0% - NEW CONTRACT ELIMINATES VILLAGE REVENUE FROM RECYCLING TOTAL MISCELLANEOUS REVENU 26,762.07 22,000.00 22,000.00 22,939.79 29,000.00 9,000.00 -59.1% TOTAL REFUSE FUND REVENUES. 1,414,767.90 1,493,500.00 1,493,500.00 1;337,642.13 1,502,00.0.00 1,480,500.00 -.9% TOTAL REFUSE FUND 1,414,767.90 1,493,500.00 1,493,500.00 1,337;642.13 1,502;000.00 1,480,500.00 -.9% 03/22/2006 VILLAGE OF DEERFIELD PG 16 12:22 RWF REVENUE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT COMMUTER PARKING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 600001 COMMUTER PARKING FUND REVENUES ------------------------------- ------- 44 CHARGES FOR SERVICES -- -- -- -------------------------------------------- 600001 4440 CIS CPKMTR 58,597.78 100,800.00 .100,800.00 70,924.32 75,000.00 75,000.00 -25.60 600001 4441 CIS VPKMTR 4,298.00 19;200.00 19,200.00 4,374.76 7;500..00 7,500.00 -60.90 600001 4442 CIS VPKPER 43,750.00 .- 85,000.00 85,000.00 .84,821.00 85,000.00 85,500.00 .6% 600001 4443 CIS CPKPER 16,824.00 18,000.00 18,000.00. 30,046.00 32,000.00 35,000.00 94.4% TOTAL CHARGES.FOR SERVICES 123,469.78 223,000.00 223,000.00 190,166.08 199,500.00 203,000.00 -9.0% 46 INVESTMENT INCOME -------------------------------------------- 600001 4610 INTER EARN 21,401.42 8,000.00 8,000.00 .00 8,000.00 8,000.00 .0% 600001• 4612 NCHGFRVAL - 2,882.08 .00 .00 00 .00 ..00 0% 600001 4622 UNRLZD G/L - 2,193.87 .00 .00 00 .00 .00 .0% TOTAL INVESTMENT INCOME 16,325.47 8,000.00 8,000.00 :00 8,000.00 8,000.00 .0% 48 MISCELLANEOUS REVENU -------------------------------------------- 600001 4834 AST CNTR 970,946.48 .00 .00 .00 .00 00 0% TOTAL MISCELLANEOUS REVENU 970,946..48 .00 .00 .00 .00 00 .0% TOTAL COMMUTER PARKING FUND 1,110,741.73 231,000.00 231,000.00 190,166.08 207,500.00 211,000.00 -8.7% 03/22/2006 VILLAGE OF DEERFIELD PG 17 12:22 RWF REVENUE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR,'PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 .2006 2006 2007 PCT COMMUTER PARKING FUND --------------------------------------------------------------------=------------------------=-------.-----=------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 602019 COMM PARK COMBINED FUNDING -------------------------------------------- 44 CHARGES FOR SERVICES -------.------------------------------------- 602019 4440. C/S CPKMTR 19,522.64 .00 .00 .00 :00 .00 .0% TOTAL CHARGES FOR SERVICES 19,522.64 .00 .00 .00 .00 .00 .016 TOTAL COMM PARK COMBINED FUN 19,522.64 .00 .00 .00 00 .00 .0% 03/22/2006 VILLAGE OF DEERFIELD PG 18 12:22 RWF REVENUE BUDGET REQUEST - FY 2006/07. bgnyrpts PROJECTION: 20071 FY 20.06 /07.MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT COMMUTER PARKING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 602038 COMM PARK VILLAGE OWNED -------------------------------------------- 44 CHARGES FOR.SERV ICES -------------------------------------------- 602038 4441 CIS VPKMTR 3,164.37 .00 .00 .00 .00 ..0.0 .0% 602038 .4442 CIS VPKPER 56,340.50 .00 .00 .00 .00 .00 .0% TOTAL CHARGES FOR SERVICES 59,504.87 .00 .00 .00 .00 .00 0% TOTAL COMM PARK VILLAGE OWNE 59,504.87 .00 .00 .00 .00 .00 .0% TOTAL COMMUTER PARKING FUND 1,189,769.24 231,000.00 231,000.00 190,166.08 207;500.00 211,000.00 - -8.7% 03122/2006 VILLAGE OF DEERFIELD PG 19 12:22 RWF REVENUE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD.13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GARAGE FUND ---------------------------------------------------------=----=---=------------.------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 700001 GARAGE FUND REVENUE' 44 CHARGES FOR SERVICES -------------------------------------- 700001 4480 C /S•FUNDS - - - - -= 286,627.50 335,500.00 335,500.00 154,875.71 335,500.00 369,050.00 10.0% TOTAL CHARGES FOR SERVICES 286,627.50 335,500.00 335,500.00 154,875.71 335.,500.00 369,050.00 10.0% 46 INVESTMENT INCOME -------------------------------------------- 700001 . 4610 INTER EARN 2,944.58 500.00 500.00 ..00 500.00 '500.00 .0% 700001 4612 NCHGFRVAL - 511.01 .00 .00 00 .00 .00 .0% 700001 4622 UNRLZD G/L 20.11 .00 .00 .00 00 .00 .0% TOTAL INVESTMENT INCOME 2,453.68 500.00 500.00 v.o 0 500.00 500.00 .016 48 MISCELLANEOUS REVENU -------------------------------------------- 700001 4810 MISC REV 5,448.07 1,000.00 1,000.00 7,415.87 1,000.00 1,000.00 0% TOTAL MISCELLANEOUS REVENU 5,448.07 1,000.00 1,000.00 .7,415.87 1,000.00 1,000.00 .0% TOTAL GARAGE FUND REVENUE 294,529.25 337,000.00 337,000.00 162,291.58 337,.000.00 370,550.00, 10.0% TOTAL GARAGE FUND 294,529:25 337,000.00 337,000.00 162,291.58 337,000.00 370,550..00 10.0% o�/uz/ouua nzLuaoo OF DooRFzozD ' eo oo 12.22 aomr RannmxUE a0000T nEOnooT - FY 2606/07 bgoyzpto PROJECTION: 20071 FY 2006/07.ymuST8a BUDGET PROJECTION ` . FOR PoozOo 13 ACCOUNTS FOR: 2005 uoos uoos unoa nua 2007 PCT INSURANCE FUND ---------------------------------------------------------------------------------------'-----------_-------------------------------- ACTUAL uaza oon REVISED ono ACTUAL �z�� rOz�czzom u rzm RovzEw caAmoE 720001 zm3{DamuCO Bzm/somsEo -----------------------------------`-------- 44 CHARGES FOR SERVICES ' -------------------------------------------- 720001 4495 CIS OTHER 25.00 .Oo 'UO ` .no .00 ''00 .u% TOTAL cHAaooa FOR amnvzcEa 25'00 .00 .00 .00 .00 .00 .0% 46 zmvEoTMomT zmcomE ______________________ 720001 e610 zxmrza souox. 19,124.67 5,000.00 s,000'oo .uo .5'000.00 10'000.00 100.0% 720001 4612 NCHGFRVAL -2'575.48 'oo .00 .8O 'ou .ou .U% 720001 4622 0maLoD G/L -4.734'38 'uu .uu .00 ` - .00 ` .00 .u% TOTAL INVESTMENT INCOME 11.814'81 5.000.00 5'000.00 `.uu .�'uuo.00 10'000.00 100.0x «u MISCELLANEOUS nznEmnz _--________--___-__- 720001 «ean nzL MonpRE --------- 1,186,834'35 'on .ou .uo. .00 .00 .o% zmSOsomvCo PREMIUMS FOR VILLAGE EMPLOYEES WILL oo ' EXesov000 oIaoorLr OUT On OPERATING mme»uzzmomzo' WILL caAm8o romo FROM ImTmamaL ooanzco TO aeEczaL REVENUE. THIS WILL ALSO BE THE CASE FOR LzonxaRY PaEmzomo' 720001 *asz nzL oxmPmE 104.606.52 .Vo .00 ' -uo .uo .no .00 ?u000z *862 nzL uzFrao 25,578.54 .ou .»V .«« -»» `»» '01 w 720001 4863 RTo MEoeaE 190'123.79 147'150.00 147'150.00 187'294.54 147'156.00 183,937 50 2s'0% 720001 4864 RTR DomgaE 13.887.94 11.000.00 11.000'00 zz.ysu.z« 111000.06 12'650 uo 15.0*6 720001 4865 LIB MEDPBE 196'820'87 'OO 'OO. 143,306.41 _ .O0` 185'000.00 .O% 720001 4866 LIB DENPD8 15,771'40 'OO 'OO z1.386.32 ,oO .00 .u% 720001 4867 LIB LIFPDE 2,114.44 .00 .00 1,401.16 'Vn 2'500.00 .01 720001 4868 pKo mooPnE 3*7,572'90 aus'ozo.00 325'910.00 311'e67.14 ` 325,910.00 365'019.20 12.0% 720001 4869 pnD oEmPoo 31'459'74 27'217.30 27'217.00 oy�oso.?* 27.217.30 zu'oo �-100.0w ru000z «aru Pno Lzneao -16'50e.65 a,soo'oo «'sou.00 6,097.23 a^sno`no 6,50.0.00 .o's TOTAL MISCELLANEOUS aonEmo o,oyo'oss.o« 517.777'30 517'777'00 70 3,235.75 517,777.30 s rss ' z o , 7o 45. 9* TOTAL zmsoexmvom nEnoomUEa 2.110'103.65 522'777.30 522'777.00 ruz'zss.rs 522^777'30 7651-61e.70 oa.s* TOTAL zmSDnxUvCo FOmo 2,1I0'103.65 522.777'30 522'777.00 703'235.75 522,777'30 765,618:.70 ' 46.5% 03/22/2006 VILLAGE-OF DEERFIELD PG 21 12:22 RWF REVENUE BUDGET REQUEST = FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2.006 2007 PCT POLICE PENSION FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 800001 POLICE PENSION FUND REVENUE 46 INVESTMENT INCOME -------------------------------------------- 800001 4610 INTER EARN 623,037.87 800,000.00 800,000.00. 71,101.45 800,.000.00 700,000.00 - 12.5°% 800001 4620 GAIN SALE .37,599.91 .00 .00 `.00 ..00 .00 .0% 800001 4621 LOSS SALE - 219,613.35 .00 .00 .00 .00 ..00 .0°% 800001 4622 UNRLZD G/L 1,407,065.60 .00 .00. .00 .00 .00 .0% TOTAL INVESTMENT INCOME 1,848,090.03 800,000.00 800,000.00 71,101.45 800,.000.00 700,000.00 -12.5% 48 MISCELLANEOUS REVENU. -------------------------------------------- 800001 4890 EMPR CONTB 614,326.00 725,000.00 725,000.00 575,395_00. 725,000.00 725,0001.00 800001 4891 EMPEE -CONT 349,042.93 316,100.00 316,100.00 242,185.82 3.16,100.00 316,100:00 .0% TOTAL MISCELLANEOUS REVENU 963,368.93 1,041,100.00 1,041,100.00 817,580.82 1,041,100.00 1,041,100.00. .0% TOTAL POLICE PENSION FUND RE 2,811,458.96 1,841,100.00 1,841,100.00 8.88,682.27 11841,100,.00 1,741,100.00 -5.4% TOTAL POLICE PENSION FUND 2,811,458.96 1,841,100.00 1,841,100.00 888,682.27 1;841,100.00 1,741,100.00 -5.4 %. GRAND TOTAL 46,658,983.48 . 39,824,028,.48 39,824,.028.00 38,016,941..29 39,458,.240.30 37,637,58.9.38 -5.5 %' ** END OF.REPORT - GENERATED BY BOB FIALKOWSKI ** 03/22/2006 VILLAGE OF DEERFIELD 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION PG 1 bgnyrpts,. FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 .2006 2006 2007 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - = - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 101111 FINANCE DEPARTMENT -------------------------------------------- 51 PERSONNEL SERVICES ----------- - --------------------------------- 101111 5110 REG SALAR 513,096.29 618,600.00 618,600.00 525,487.26 INCREASE DUE TO COLA AND ADDITION OF COMPUTER TECHNICIAN PREVIOUSLY ACCOUNTED FOR IN POLICE ADM. 101111 5111 PT SALARY 45,418.00 10,000.00 101111 5112 OT SALARY 6,921.34 8,000.00 TRAINING - $3,500 OVERTIME AS NECESSARY FOR DEPT PERSONNEL TRNG TRAV 101111 5120 MED BNFT 63,872.07 110,090.00 101111 5121 DNTL BNFT 5,794.04 14,000.00 101111 5122 MISC BNFT 5,007.46 6,500.00 101111 5130 APPAREL .00 500.00 101111 5140 PEN CNTRB 93,480.24 127,000.00 TOTAL PERSONNEL SERVICES 733,589.44 52 TRAINING & DEVELOPME 101111 5210 TRNG REG 561.40 101111 IT TRAINING - $25,000 20,743.51 101111 . OTHER DEPT. TRAINING - $3,500 5,951.85 101111 5211 TRNG TRAV 38.30 101111 5212 TRNG EXP 850.00 101111 5213 SUBSCRIPT 403.80 TOTAL TRAINING & DEVELOPME 1,853.50 53 CONTRACTUAL SERVICES 101111 .5320 BLDG R&M 3,406.06 101111 5322 EQUP R&M 20,743.51 101111 . 5324 CEME R&M 5,951.85 101111 5325 DOG PND 5,999.76 101111 5330 DUES 6,098.95 101111 5331 CNF MEET 782.58 101111 5332 TRAV EXP 2,708.72 101111 5335 PRINTING 1,487.64 101111 5336 LGL NOTICE 1,489.36 101111 5337 POSTAGE 8,639.95 101111 5350 INS GL 78,272.50 101111 5360 P/S CRP CN 138,276.64 10,000:00 10,617.52 8 -, 000. 00' 8,830.46 110,090'.00 14,000.00 6,500.00 500.00 127,000.00 894;690.00 894,690.00 70,774.05 5,959.13 3,503.12 00 92,672.95 717,844:49 595,000.00 699,400,.00 13.1°% 11,000.00 12,000.00 20.0% 8,.000.0.0 9,50.0.00 18.8% 88,000.00 110,000.00 -.1% 7,.000.00 7,900.00 -43.6% 6,.500.00 6,500.00 .0% 200.00 500..00 .0% 115,000.00 130,000.06 2.4% 830',700.00 975,800.00. 9.1% 1,000.00 11000.00. 2,055.00 4,000.00 28,500:00 2750.0% 250.00 250.00 175.89 250.00 750.00 200.0% 500.00 500.00 2,075.47 2,500.00 3,000.00 500.0% 1,000.00 1,000.00 555.00 11000.00 900._00 -10.0% 2,750.00 2,750.00 4,861.36 7,750.00 33,150.00 1105.5 % - 10,000.00 10,000.00 714.65 5,000.00 5,000.00 - 50.0%. 16,000.00 16,000.00 5,845.38 10,000.00 13,000.00 -18.8% 12,000.00 12,000.00. 3.,395.00 8,000..00 10,000.00 - 16.7 %' 6,000.00 6,000.00 4,072.91 4;000.0.0 5,000.00 -16.7% 4,500.00 4,500.00 8,901.00 4,500.00 6,000.00 33.3% 3,000.00 3,000.00 2,381:14 .3,000.00' 4,500,:00 50.0% 3,000.00 3,000.00 2,.908:20. 3,000.00. 3;800.00 26.7% 11,000.00 11,000.00 5,267.02 .6;500.00 9,500.00 -13.6% 2,500.00 2,500.00 946.60 .2,500:00 2,500.00 .0% 10,000.00 10,000.00 4,137.99 7,500.00 9,000..00 -10.0% 91,875.00 91,875.00 83,644.95 91,875.00 105,656.25 15.0°% 135,000.60 135,000.00 142,474.52 150;000.00 140,000..00 3.7% 03/22/2006 5410 MISC SUPP VILLAGE OF DEERFIELD 101111 5421 MATERIAL PG 2 12:28 RWF 101111 EXPENDITURE BUDGET REQUEST - FY 2006/07 98.94 1,500.00 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION 10,000.00 101111 5460 FOR PERIOD 13 ACCOUNTS FOR: 101111 • 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND .0% ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ---------------------------------------------------------- 101111 5361 PIS PRSCTR 45,885.00 ------------ 55,000.00 --------------------------------------------- 55,000.00 43,130.00 55,000.00 55,000.00 .016 101111 5363 PIS MEDIC -.00_ 1,000.00 1,000.00 .00 500.00 1,000.00 .0% 101111 5364 PIS CATV .00 5,000.00 5,000.00 .00 5,000.00 5,000.00 .0% 101111 5365 PIS OTHER 79,631.63 45,000.00 45,000..00 38,668.50 45,.000.00 69,000.00 53.3% INCLUDES AUDIT AT PROJECTED TOTAL OF.$34,000 IT CONSULTING- - $25,000 OTHER PROFESSIONAL CONSULTING - $10,000 101111 5369 TRUST FEES .00 .00 .00 .00 1;.200.00 1,500.00. .0% 101111 5370 DP SERV 44,772.17. 66,000.00. 66,000.00 44,595.21 66,000.00 :55,850.00 -15.4% 101111 .5381 FAM SERV 2,550.00 2,500.00 2,500.00 661.20 2,500..00 3,000.00 20.0% 101111 5382 HOUS ASST 5,000.00 8,000.00 8,000.00 9,625.00 11,000.00 12,000.00 50.0% 101111 5383 SENR PKDIS 92,915.00 85,000.00 85,000.00 93,446,00 85,000.00 110,000.00 29.4% 101111 5384 TAXI SUBS 19,184.75 27,000.00 27,000.00 15,362.75 21;000.00 25,000.00 -7.4% 101111 5386 FAMDYSEXP 82,358.42 90,000.00 90,000.00 67,586.20 90,0010.00 90,000.00 .0% 101111 5390 OTHER - 692.20 .00 .00 1,081.88 ..00 .00 0% 101111 5395 ECON INCEN 222,462.75 230,000.00 230,000.00. 394,072.71 300,000.00. 325,000.00 41.3% ACCOUNTING RULES REQUIRE THAT WE EXPENSE THE ANTICIPATED REBATES FOR THE TWO SALES TAX AGREEEMENTS IN PLACE. WALGREEN NATIONAL - $210,000 DEERBROOK MALL - $115,000 TOTAL CONTRACTUAL. SERVICES 867,925.04 919,375.00 . 919,375.00 54 COMMODITIES 101111 5410 MISC SUPP 3,629.52 16,000.00 101111 5421 MATERIAL 1,043.35 1,500.00 101111 5440 SMTLSEQUP 98.94 1,500.00 101111 5450 OFF SUPP 8,698.49 10,000.00 101111 5460 OPER SUPP 4,675.29 5,000.00 101111 • 5470 R&M SUPP 1,355.48 2,500.00 TOTAL COMMODITIES 19,501.07 55 UTILITIES -------------------------------------------- 101111 5530 U/E WATER 3,226.64 101111 ' 5540 U/E TELEPH 15,394.16 TOTAL UTILITIES 18,620.80 56 OTHER EXPENSES -------------------------------------------- 101111 5610 OTH EXPENS 161,299.60 TOTAL OTHER EXPENSES 161,299.60 58 CAPITAL OUTLAY -------------------------------------------- 101111 5810 OP EQP 2,263.90 36,500.00 4,200.00 22,000.00 26,200.00 .00 00 15,500.00 16,000.00 1,500.00 .1,500.00 10,000.00 5,000.00 2,500.00 36,500.00 4,200.00 22,000.00 26,200.00 .00 .00 15,500..00 972,918.81 587.51 466.90 97.91 3,013..09 3,430..19 14.81 7,610.41 3,406.26 13,608.26. 17,014.52 415.00 415.00 13,672.98 980,075.00 1,066,306..25 16.0°% 16,000.00 11,000.00 - 31.3 %, 1,500.00 2,000.00 33:3% ,1,500.00 1,500..00 .0% 7,000.00 8,000.00 -20.0% 5,000.00 5,000.00 .0% 1,200.00 2,500.00. .06 32,200..00 .30,000.00 -17.8% 4,200.00 5,000..00 19.0% 18,000.00 20,000.00 -9.1% 22;200.00 25,000.00. -4.6% 00 00 .0% .00 .00 .0% 15,500.00 13,000.00 -16.1% . 03/22/2006 VILLAGE OF DEERFIELD PG 3._ 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY•.2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 101111 5830 OFC EQP 5,227..26 .00 .00 543.,45 .00 .00 .0% TOTAL CAPITAL OUTLAY 7,491.16 15,500.00 15,500.00 14,216.43 1$,500.00 13,000.00 -16.10 72 TRANSFERS OUT (IFT) - -------------------------------------------- 101111 7210 TRNSFR OUT .00 3,000,000.00 3,000,000.00 .00 00 3,400,000.00 13.3°% ` $1,600,000 TRANSFER TO SEWER FOR CAPITAL EXPENDITURES $1,800,000 TRANSFER TO INFRASTRUCTURE FOR CAPITAL EXPENDITURES. 101111 7211 TRANS VERF 44,251.00 38,556.00 38,556.00 .00 38,556.00 34,667.00 . -10:1% TOTAL TRANSFERS OUT (IFT) 44,251.00 3,038,556.00 3,038,556.00 .00 38',556.,00 3,434,667.00 13.0% TOTAL FINANCE DEPARTMENT 1,854,531.61 4,933,571.00 4,933,571.00 1,734,881.02 1,926,.981.00 5,577,923.25 13.1% 03/22/2006 VILLAGE OF DEERFIELD PG 4 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07. bgnyrpts PROJECTION: 20071 FY- 2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 101210 ADMINISTRATION --------------.------------------------------ 51 PERSONNEL SERVICES 101210 5110 REG SALAR 320,211.49 378,040.00 378,040:00 287;274.70 350,000.00 408,283.20 8.0% 101210 5111 PT SALARY 23,356.57 34,000.00 34,000.00 24,547.27 34;,000.00 34,000.00 .0% 101210 5112 OT SALARY 912.24 5,000.00 5,000.00 682:58 5,000:00 5,000.00 .0% 101210 5120 MED BNFT' 24,839.48 37,329.60 37,330.00 27,164.75 371329.60 41,063._00 10.0% 101210 5121 DNTL BNFT 2,666.32 4,400.00 4,400.00 _ 2,793.64 4,400.00 3,300.00 -25.0% 101210 5122 MISC BNFT 17,401.74 1,500.00 1,500.00 15,782.36 15,000.00 15,000.00 900.0% 101210 5140 PEN CNTRB 52,530.79 72,500.00 72,500.00 56,099.24 651000..00 80,000.00 10.3% TOTAL PERSONNEL SERVICES 441,918.63 532,769.60 532,770.00 408,344:54. 510,729.60 586,646.20, 10.1% 52 TRAINING & DEVELOPME -------------------------------------------- 101210 5213 SUBSCRIPT 661.90 3,000.00 3,000.00 975.50 3,.000:00 3,000.00 .0% TOTAL TRAINING & DEVELOPME 661.90 3,000.00 3,000.00 975.50 3,000.00 3,000.00 .0% 53 CONTRACTUAL SERVICES -------------------------------------------- 101210 5321 STRUC R&M .00 5,000.00 5,000:00 .00 500.00 5,000.00 .0% 101210 5322 EQUP R&M 494.83 1,000.00 1,000.00 203.66, :.1,000.00 1,000.00 .0% 101210 5326 VEH MAINT 241.50 1,000.00 1,000.00 5.00 1,000.00 1,000.00 .0% 101210 5330 DUES 14,641.80 20,000.00 20,000.00 16,226:17 .20,000.00 20,000.00 .0% NW MUNICIPAL CONFERENCE - 7,460 NE ILL PLAN COMMISSION - 3,652 101210 5332 TRAV EXP 7,157.25 12,000.00 12,000.00 5,590.43 12,000.00. 12,000.00 .0°% 101210 5335 PRINTING 25,743.88 37,000.00 37,000.00 14,033.65 31;000.00 33,000.00 - 10.8°% $7,500 FOR NEW COMMUNITY INFORMATIONAL BROCHURE 101210 5336 LGL NOTICE 2,391.09 606.00 600.00 110.00 600.00 600.00 .0°% 101210 5337 POSTAGE 5,410.90 8.,000.00 8,.000.00 6,259.63 8,000.00 8,000.00 .01 ANTICIPATED INCREASE IN POSTAGE RATES 101210 5387 ADV BOARD 72,682.86 90,000.00 90,000.00 57,656.65 75,000.00 95,000.00 5.6% INCLUDES $15,000 FOR ACTS OF KINDNESS PROGRAM TOTAL CONTRACTUAL SERVICES 128,764.11 174_,600.00 174,600.00 100,065.19 149,100.00 175,600.00 .6% 54 COMMODITIES -------------------------------------------- 101210 5410 MISC SUPP 1,269.19 2,500.00 2,500.00 780..74 2,500.00 2,500.00 .0% 101210 5420 PETR PROD 2,715.59" 2,000.00 2,000:00 .00 .3, 000.00 3,000:00 50.0% 101210 5450 OFF SUPP 1,066.70 2,500.00 2,500.00 - 2,87.0'.69 1,500..00 2,600.00 4.0% 03/22/2006 VILLAGE OF DEERFIELD PG 5 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR.PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL ORIG•BUD REVISED BUD ACTUAL 'PROJECTION FIN REVIEW CHANGE --------------=-------------------------------------------------------=-----=-------------------------------------------------------- 101210 5460 OPER SUPP 2,980.16 3,500.00 3,500.00 192.85 2;500.00 3,500.00. .0% 101210 5470 R&M SUPP ..00 1,000.00 1,000.00 .00 500.00 1,000.00 .0% TOTAL COMMODITIES 8,031:64 11,500.00 11,500.00 3,844.28 10 ;000.00 12,600.00 9.6% 55 UTILITIES -------------------------------------------- 101210 5540 U/E TELEPH 1,026.40 1,600.00 1,600.00 1,011.19 ..1., 600.00 1,600.00 .0% TOTAL UTILITIES 1,026.40 1,600.00 1,600.00 1,011.19 1.,600,00 1,600.00 .0% ' 58 CAPITAL OUTLAY -------------------------------------------- 101210 5810 OP EQP .00 .00 .00 .00 .00 30,000..00 0% - 10 LAPTOP COMPUTERS FOR BOARD FOR ELECTRONIC PACKETS TOTAL CAPITAL OUTLAY .00 .00 .00 .00, .00 30,000..00 .0% 59 CAPITAL IMPROVEMENTS -------------------------------------------- 101210 5914 STRSCP IMP 2,173.92 48,000.00 48,000.00 337.14 -25,000.00 58,500.00 21.9% CENTENNIAL SCULPTURE - $13,000 URN PLANTINGS.- $35,000 Banner pole banners, purchase /replacement - $10,500 TOTAL CAPITAL IMPROVEMENTS 2,173.92 48,000.00 48,000.00. 337.14 25,000.00 58,500.00 21.9% 72 TRANSFERS OUT .(IFT) ------------------------------ -.------------- 101210 7211 TRANS VERF 3,999.00 3,600.00 3,600.00 .00 .3,600.00 3,600.00 .0% TOTAL TRANSFERS OUT (IFT) 3,999.00 3,600.00 3,600.00 .00 3,600.00 3,600.00 0% TOTAL ADMINISTRATION 586,575.60 775,069.60 775,070.00 514,597.84 703,029.60 871,546.20 12.4% 03/22/2006 VILLAGE OF DEERFIELD PG 6 12:28 RWF EXPENDITURE BUDGET REQUEST - -FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007. PCT GENERAL FUND ---------------------------------------------------------------------------------------------------------------=-------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 1D1330 COMMUNITY DEVELOPMENT - -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 101330 5110 REG SALAR 377,706.67 545,000.00 545,000.00 348,607.70 410,000.00 564,000.00 3.50 101330 5111. PT SALARY 91,347.22 65,000.00 65,000.00 51,341.69 65,000.00 45,000.00 -30.8% REDUCTION DUE TO REQUEST.TO UPGRADE PT SECRETARY TO FT 101330. 5112 OT SALARY 2,700.83 7,556.00 7,556.00 1,013.64 71556..00 5,000.00 -33.8% 101330 5120 MED BNFT 57,159.79 75,000.00 75,000.00 61,751.86 .75,000.00 82,500.00- 10.0% 101330 5121 DNTL BNFT 5,807.28 8,200.00 8,200.00 5,954.77 8,200.00 8,200..00 .0% 101330 5122 MISC BNFT 200.50 1,323.00 .1,323.00 1,407.04. 1,323.00. 1,500.00 13.4% 101330 5130 APPAREL 233.22 600.00 600.00 536.90 600.00 800.00 .33.3% Boots, Jackets, etc. 101330 5140 PEN -CNTRB 76,381.89 120,000:00 .120,000.00- 69,832.42 831500.00 110,000.00 -8.3% TOTAL PERSONNEL SERVICES 611',537.40 822,679.00 822,679.00 540,446.02 651,179.00 817,000.00 -.7% 52 TRAINING & DEVELOPME -------------------------------------------- 101330 5211 TRNG TRAV 2,055.13. 3,500.00 3,500.00 684.00 21500.00 1,000..00 -71.4% training related travel expenses 101330 5212 TRNG EXP .00 .00 .00 .00 .00 4,000.00 .0 %. fees, tuitions and course costs 101330 5213 SUBSCRIPT. 25.00 1,000.00 1,000.00 .1,349.04 1,000.00. 1,000.00 09., TOTAL TRAINING &.DEVELOPME 2,080.13 4,500.00. 4,500.00 2,033.04 3,500..00 6,000.00 33.3 %. 53 CONTRACTUAL SERVICES -------------------------------------------- 101330 5322 EQUP R&M 4,588.88 5,000.00 5,000.00 197.91 2,500.00 5,000.00 .0% 101330 5326 VEH MAINT 3,748.70 5,300.00 5,300.00 3,333.50 5,300..00 5,300.00 .0% 101330 533.0 DUES 834.00 .3,500.00 3,500.00 1,329:75. 2;000.00 2,000.00 -42.9% 101330 5332 TRAV EXP 46.00 400.00 400.00 31.25 .400.00 400.00 .09. 101330 5335 PRINTING 3,209.65 .3,600.00 3,600.00 5,663.89 6,000.00 7,500.00 108.3% Building Permits applications, placards, Temporary use permits Public Hearing signs Zoning Ord, Devlopment Code, Subdivision Code, Etc. 101330 5336 LGL NOTICE 3,961.08 4,300.00 4,300.00 2,145.82 3,200..00 3,200.00 -25.65. 101330 5337 POSTAGE 1,368.28 1,610.00 1,610.00. 1,247.54 1,610.00. 1,700.00 5.6°% 101330 5363 P/S MEDIC .00 800.00 800.00 .00 600.00 600.00 - 25.0°% 101330 5365 P/S OTHER 62,734.44 63,700.00 63,700.00 76,860.15 63,700.00 74,800.00 17.4% 400 semi annual Elevator inspections @$40 each = $16,000 Reinspections @ $40.0.0 each, About 35% = $5600 Plan Review for new construction, upgrades @ $75 per car 15 cars = $1125 New construction inspection and reinspection $75 per car llcars = $825_ Elevator fee is passed though to the recipient Elevator Total $23,550 03/22/2006 2,500.00 617.50 VILLAGE OF DEERFIELD 3,000.00 .00 3;000.00 PG 7 12:28 RWF .00 EXPENDITURE BUDGET REQUEST - FY 2006/07 944,439.00 647,006,.98 769,939.00 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION.: FIN REVIEW CHANGE ----------------------------------------------------=------------------------------------------------------------------------------- Fee is- passed through to recipient +15% 750 Plumbing inspections @ $65 ea. _ $48,750 Plan review $2,500 101330 5370 DP SERV 136.00 4,100.00. 4,100.00 .00 4.;100.00 4,100.00 0% 101330 5387 ADV BOARD .00 .00 .00 15.74 .00 .00 .0% 101330 5390 OTHER 30,273.90 .00 .00 973.75 .00 .00 .0% See 101330 5365 TOTAL CONTRACTUAL SERVICES 110,900.93 92,310.00 _92,310.00 91,799.30 89,610.00 104,600.00 13.3% 54 COMMODITIES -------------------------------------------- 101330 5410 MISC SUPP 173.94 650.00 650.00 304.14 650.00 650.00 .0% 101330 5420 PETR PROD 1,549.94 1,800.00 1,800.00 .00 2.,500.00 2,500.00 38.9% 101330 5450 OFF SUPP 4,436.43 5,500:00 5,500.00 3,629.96, 5,500.00 5,500.00 .0% 101330 5460 OPER SUPP 4,892.87 5,000.00 5,000.00 2,165.78 5,000.00 5,000.00 .0% 101330 5470 R&M SUPP 357.04 1,000.00 1,000.00 950.00 1,000.00 1,500.00 50.0% TOTAL COMMODITIES 11,410.22 13,950.00 13,950.00 7,049.88 14;650.00 15,150.00 8.6% 55 UTILITIES -------------------------------------------- 101330 5520 U/E NAT GA 2,185.33 2,000.00 2,000.00 1,911.79 2,000.00 3,000.00 50.0% .101330 5540. U/E TELEPH 3,045.11 3,500.00 3,500.00 2,949.45 3,500.0.0 3,500.00 .0% Does-not include relocation costs TOTAL UTILITIES' 5,230.44 5,500.00 5,500.00 4,861.24 5;.500.00 .6,500.00 18.2% 58 CAPITAL OUTLAY -------------------------------------------- 101330 5810 OP EQP 936.02 11500.00 11500.00 817.50 1,500.00 2,0.00.00 33.3% 101330 58.30 OFC EQP .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0 %. TOTAL CAPITAL OUTLAY 936.02 72 TRANSFERS OUT (IFT) -------------------------------------------- 101330 7211 TRANS VERF 3,000.00 TOTAL TRANSFERS OUT (IFT) 3,000.00 TOTAL COMMUNITY DEVELOPMENT 745,095.14. 2,500.00 2,500.00 617.50 2,500.00 3,000.00 3,000.00 .00 3;000.00 3,000.00 3,000.00 .00 3,000.00 944,439.00 944,439.00 647,006,.98 769,939.00 3,000.00 20.016. 3,000.00 .0% 3,000.00 .0% 955,250.00 1.1% 03/22/2006 VILLAGE OF DEERFIELD PG 8 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 102010 STREET ADMINISTRATION - -------------------------------------------- 51 PERSONNEL SERVICES ----------------=--------------------------- 102010 5110 REG SALAR 201,209.42 159,800.00 159,600.00 134,637:42 159,800.00 224,800.00 40.79 Street foreman, 1/3 engineering secretary, 1/4 director INCLUDES ADDITIONAL AMOUNT FOR NEW ASST. PUBLIC WKS DIR 102010 5111 PT SALARY 8,562.02 8,500.00 8,500.00 7,489.93 8,500.00 8,500.00 0 °s 1/3 Public works secretary + overtime for public works secretary 102010 5112 OT SALARY 3,112.86 4,000.00 4,000.00 2,170.01 4,000.00 4,000.00 .09 102010 '5120 MED BNFT 19,040.97 21,200.00 21,200.00 16,697.25 21,200:00 341,380:00 62.20 102010 5121 DNTL BNFT 1,674.03 2,299.50 2,300.00 .1,397. 77 1,800.00 3,000.00 30.4°% 102010 5122 MISC BNFT 2,677.88 3,500.00 3,500.00 790.62 1;800.00, 3,500.00 09 102010 5130 APPAREL 4,228.45 6,000.00 6,000.00. 3,653.97 5;0.00.00 6,000.00 .09 Uniforms, boots, jackets $500 X 7 =$3500 Gloves, safety vests, hardhats, rain gear, rubber boots $300 X 7 =$2100 102010 5140 PEN CNTRB 34,0.65.46 35,000.00 35,.000.00 24,153.70 .35,000.00 41,000:00 .17.1% TOTAL PERSONNEL SERVICES 274,571.09 240,299.50 240,300.00 190,990.67 237,100.00 325,•180.00 35.3°% 52 TRAINING & DEVELOPME -------------------------------------------- 102010 5210 TRNG REG .00 1,200.00 1,200.00. 120.00 600.00.. 1,600.00 33.39 Training registrations, CDL licenses $200 /man X 7 men $200 for director. 102010 5211 TRNG TRAV 370.00 .00 .00 .00 .00 00 09 Delete this account # and combine with 102010 -5332 102010 5213 SUBSCRIPT 216.23 500.00 500.00 .00 _ 50.00 500.00 .09 TOTAL TRAINING & DEVELOPME 586.23 1,700..00 1,700.00 120.00 650.00 2,100.00 23.59 53 CONTRACTUAL SERVICES -------------------------------------------- 102010 5320 BLDG R&M ' 11,737.25 19,500.00 19,500.00 10,115.20 14,000.00 19,500.00 .09 1/3 cleaning service, $4000 overhead doors $2000 HVAC, $1500 flooring 102010 5322 EQUP R&M 490.00 5,000.00 5,000.00 455.16 3,500.00 5,000..00 .09 $900 for 1/3 JULIE, fax, copier, fuel tank meters, 102010 5326 VEH MAINT 1,671.50 6,600.00 6,600.00 1,060.50 6,600:OG 8,000.00 21.29 102010 5330 DUES 158.00 200.00 200.00 101.00 200.00 500.00 150.09 Dues for membership to APWA etc. $50 for director $250 for-membership tp NIPSTA 03/22./2006 VILLAGE OF DEERFIELD 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 - PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION PG 9 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL ORIG BUD. REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE -------------------------------------------------------------------=---------------------------------------------------------------- 102010 5332 TRAV EXP 1,252.02 1,500.00 1,500.00 306..24 1,500.00 1,600.00 6.7% $1600 for travel expenses to seminars, conferences etc. CDL license for admin. $100 for director 102010 5335 PRINTING 4,296.28 3,000.00 3,000.00 608:36 1;200.00 3,000.00. .0% Door hangers, vehicle stickers and time cards 102010 5336 LGL NOTICE .00 200.00 200.00 .00 200.00 200.00 .0% Bid notices, job openings 102010 5337 POSTAGE 1,860.00 5,100.00 5,100..00 1,292.70 3,500.00 5,300.00 3.9% INCREASE IN POSTAGE 5% 102010 5350 INS GL 51,194.64 71,400.00 71,400.00 .63,154.69 65,,000:00 82,110:00 15.0% 102010 5363 P/S MEDIC 450.00 1,100.00 1,100.00 :00 550.00 1,300.00 18.2% $650 for alchol & drug testing $450 for pre - employment testing,.05 prices increased by 5% = $1100 X 1.05 = $1300 102010 5365 P/S OTHER 4,477.00 9,400.00 9,400.00 1,102.50 5;000.00 9,400.00 1/3 $3065 for weather services 102010 5370 DP SERV- 1,355.57 2,500.00 2,500.00 .00 500.00 2,500.00 .0% Replacements and updates TOTAL CONTRACTUAL SERVICES 78,882.26 125,500.00 125,500.00 78.,796.35 101,350.00 138,410.0.0 10.3% 54 COMMODITIES -------------------------------------------- 102010 5410 MISC SUPP 4,405.45 7,800.00 7,800.00 4,075.00 5.,000.00 7,800.00 .0% Safety equipment, flashlight, batteries, barricades, cones 102010 work zone signs 5420 PETR PROD 1,412.65 2,200.00 2,200.00 .00 .2:,200.00 2,500.00 13.6% 102010 5421 MATERIAL 166.55 .00 .00 141.97 00 .00 .0% 102010 5440 SMTLSEQUP 74.95 .00 .00 .00 .00 .00 .0% 102010 5450 OFF SUPP 1,242.19 2,500.00 2,500.00 488.37 .1,000.00 2,000.00 -20.0% Copier paper, pens,.ink cartridges, tape staples 102010 5460 OPER SUPP 1,592.53 3,500.00 3,500.00 918.53 .2,000.00 3,500.00 .0% Cleaning.products, brooms, mops, paper-towels, coffee, ice' 102010 5470 R&M SUPP 6.99 3,000.00 3,000.00 .00 500.00 1,000'.00 -66.7% Maintenance contracts, $700 copier machine $300 JULIE printer. TOTAL COMMODITIES 8,901.31 19,000.00 190000:00 5,623.87 10.,700.00 16,800.00 -11.6% 55 UTILITIES -------------------------------------------- 102010 5510 U/E ELECT 3,816.02 4,000.00 4,000.00 .2,397.21 2,,000.00 4,000'.00 .016 102010 5540 U/E TELEPH 4,941.05 6,500.00 6,500.00. 4,294.85 5,000.00 6,500.00 .0% Nextel.phone bills, public works land lines and alarms 03/22/2006 VILLAGE OF DEERFIELD PG 10 12:28 RWF EXPENDITURE BUDGET REQUEST- FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE TOTAL UTILITIES - - 8,757.07 - 10,500.00 10,500.00' - 6-,692.06 7,000 -.00 10,500.00 .0% 58 CAPITAL OUTLAY -------------------------------------------- 102010 5810 OP EQP .00 2,000.00 2,000.00 2,053.00 2,100.00 2,000.00 .0% TOTAL CAPITAL OUTLAY .00 2,000.00 2,000.00 2,053.00 2,100.00 2,000.00 .0% 72 TRANSFERS OUT (IFT) -------------------------------------------- 102010 7211 TRANS VERF 119,924.00 ]27,915.00 127,915.00 .00 127,915.00 127,915.00 .0% TOTAL TRANSFERS OUT (IFT) 119,924.00 127,915.00 127,915.00 - .00 127,915.00 127,915.00 .0% TOTAL STREET ADMINISTRATION 491,621.96 526,914:50 526,915.00 284,275.95 487.,'215. 00 622,905..00 18.2% 03/22/2006 VILLAGE OF DEERFIELD PG 11 12:28. RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006- 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL, PROJECTION. FIN REVIEW CHANGE ------ ---------------- =---------------------------------------------------------------------------- =---------------------------------- 102036 STREET SNOW & ICE REMOVAL 51 PERSONNEL SERVICES 30,000..00 50,600.00 -------------------------------------------- 102036 5110 REG SALAR 40,191.98 50,600.00 6,000.00 All public works departments charged to this account . 40,662...64 during snow removal operations' 55,000.00 102036 5111 PT SALARY .00 6,000.00 102036 5112 OT SALARY 58,534.69 55,000.00 1,200.00 All public works departments charged to this account 500.00 during overtime snow removal operations 500.00 102036 5120 MED BNFT 14,581.81 15,000.00 102036 5121 DNTL BNFT 1,363.05 1,800.00 102036 5122 MISC BNFT 231.50 500.00 102036 5140 PEN CNTRB 16,763.06 16,000.00 TOTAL PERSONNEL SERVICES 131,666.09 144,900.00 53 CONTRACTUAL SERVICES .0% 44,000.00 -------------------------------------------- 102036 5310 RENT EQP .00 4,000.00 17,500.00 Semi trucks, snow blower for.heavy snowfall 17,500.00 102036 5322 EQUP R &M 26,603.10 25,000.06 90,500:00, All snow removal related equipment, plow blades, casters 10,500.00 plows 20.0% 7,500.00 102036 5326 VEH MAINT '30,104.50 44,000.00 130,000.00 All snow removal related vehicles 140,000..00 102036 5390 OTHER 13,232.03 17,500.00 1,800.0'0 Sidewalk and parking lot contractual snow removal TOTAL CONTRACTUAL SERVICES 69,939.63 90,500.00 54 COMMODITIES -------------------------------------------- 102036 5420 PETR PROD 8,358.80 9,500.00 102036 5421 MATERIAL 117,756.72 7,500.00 Ice melt for sidewalks around public buildings 102036 5422' CHEMICAL 874.37 130,000.00 Bulk road salt purchased-under state bid or other sources as needed. Increase by $10,000 102036 5460 OPER SUPP 918.45 1,800,.00 Meals during emergency operations 50,600.00 14,511.51 30,000..00 50,600.00 .0% 6,000.00 294.00 1,500.00 6,000.00 .0% 55,000.00 40,662...64 55,000.00 55,000.00 .0% 15,000.00 8,924.78 .12,500.00 15,000.00 .0% -1,800.00- 755.03 1,200.00 1,800.00 .016 500.00 132.12 500.00 500.00 .0% 16,000.00 9,500,.50 14,.000.00 16,000.00 .016 144,900.00 74,780.64 114,700.00 144,900.00 .0% 4,000.00 .00 2,000.00 41000.00 .0% 25,000.00. 7,392.50 15,000.00 25,000.00 .0% 44,000.00 11,274.50 .44,000.00 44,000.00 .0% 17,500.00 6,049:63 17,.500.00 17,500.00 .0% 90,500.00 24,716:63 78,500:00. 90,500:00, 0% 9,500.00 .00 10,500.00 11,400.00 20.0% 7,500.00 .531.57 7,,500.00 7,500.00 .0% 130,000.00 128,813.20 115,000.00 140,000..00 7.7% 1,800..00 499.83 1,800.00 1,800.0'0 .0% 03/22/2006 VILLAGE OF DEERFIELD PG 12 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006. 2007 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 102036 5470 R&M SUPP 1,173.07 1,500.00 1,500.00 1,.880.16 2,000.00._ 2,000..00 33.30. Mailboxes, dirt-and seed-for snow plow damage restoration TOTAL COMMODITIES 129,081.41 -150,300.00 150,300.00 131,724.76 13"6,800.00. 162,700::00 8.30 58 CAPITAL OUTLAY -------------------------------------------- 102036 5810 OP EQP .00 13,500.00 13,500:00 9,.435.95 12,000.00 2,500.00 -81.50 Small snow blowers, sidewalk spreaders- TOTAL CAPITAL OUTLAY .00 13,500.00 13,500.00 9.,435.95 12,000.00 2,500.00 -81.5% 59 CAPITAL IMPROVEMENTS -------------------------------------------- 102036 5914 . STRSCP IMP 1,067.27 .00 .00 .00 .00 .00 ,0% Remove this line item TOTAL CAPITAL IMPROVEMENTS 1,067.27 .00 .00 00 .00 .00 .0% TOTAL STREET SNOW & ICE REMO 331,754.40 399,200.00 399,200.00 240;657.98 342,000.00 400,600.00 .4% 03/22/2006 VILLAGE OF DEERFIELD PG 13 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL -----------------------------------------------------------------.-----------------------=------------------------------------------- FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 102037 STREET FORESTRY -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 102037 5110 REG SALAR 32,067.92 35,600.00 35,600.00. 32,150.96 38,000..00 - .45,000.00 26.4% Trees, grass and weed control. 102037 5111 PT SALARY 547.50 6,000.00 6,000.00 1,881.50 5,000.00 6,000.00 .0% 102037 5112 OT SALARY 616.43 2,400.00 2,400.00 4,370.98 5.,000.00 6,000_.00 150.0% Storm damage 102037 5120 MED BNFT 6,408.45 12,000.00 12,000.00 7,927.28 12,000.00 13,800.00 15.0 %; 102037 5121 DNTL BNFT 608.88 1,300.00 1,300.00 670.62 1,300.00. 1,200.00 -7.7% 102037 5122 MISC BNFT 98.42 500.00 500.00 107.73 500.00 500.00 0% 102037 5140 PEN CNTRB 5,559.43 8,800.00 8,800.00 6,238..91 _ 8,800.00 9,500.00 8.0% TOTAL PERSONNEL SERVICES. 45,907.03 66,600.00 66,600.00 53,347.98 70,600.00 82,000.00 23.1% 53 CONTRACTUAL SERVICES -------------------------------------------- 102037 5322 EQUP R&M 3,149.00 6,000.00 6,000.00 3,607.13 6,000.0.0 6,000.00 .0% Chainsaws lawn mowers and'weed wackers 102037 5326 VEH MAINT' 2,795.00 8,800.00 8,800.00 1;556.00 8,800.00 8,800.00 _ 0% Riding mowers 102037 5365 P/S OTHER .00 44,000.00 44,000.00 36;305.75.. .30,000.00 118,000.00 168.2% $4000 for contractual weed spraying and $40,000 for consulting services $12,000 DED; $40,000 TREE TRIMMING; $7,000 STORM DAMAGE $15,000 ADVANCE WORK FOR INFRASTRUCTURE PROJECTS TOTAL CONTRACTUAL SERVICES 5,944.00 58,800.00 58,800.00 411468.88. 44,800.00 132,800.00 125.9% 54 COMMODITIES ---------------=---------------------------- 102037 5420 PETR PROD 726.36 1,600..00 1,600.00. .00 1,600..00 2,000.,00 25.0% 102037 5421 MATERIAL 141.31 600.00 600.00 .00 600.00 600.00 .0% Tree wrap, dirt and seed TOTAL COMMODITIES 867.67 2,200.00 2,200.00 .00 2;200.00 2,600.00 18.2% 58 CAPITAL OUTLAY -------------------------------------------- 102037 5810 OP EQP 106.11 1,700.00 1;700.00 559.98 1,700.00 1,700.00 .0% $500 lawn mower $500 Chainsaw 03/22/2006 VILLAGE OF DEERFIELD PG 14 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND - --------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - ACTUAL - - - - - - - - - - - - - ORIG BUD - - - - - - - - - - - - - REVISED BUD - - - - - - - - - - - - - - ACTUAL - - - - - - - - -=- - - - - - - - PROJECTION - - - - - - - - - - - - - - FIN REVIEW - - - - - - - - - - - - - CHANGE - - - - - - - - - TOTAL CAPITAL OUTLAY _ 106.11 - 1,700.00 1,700.00 559.98- 1,700.00 1,700.00" .0% 59 CAPITAL IMPROVEMENTS 102037 5914 STRSCP IMP 49,336.13 68,000.00 68,000.00 62,642.56 68,000.00 9,000.00. - 86.80 $9000 50/50 tree TOTAL CAPITAL IMPROVEMENTS 49,336.13 68,000.00 68,000.00 62,642.56 68,000..00 9,000.00 -86.80 TOTAL STREET FORESTRY 102,160.94 197,300.00- 197,300.00 158,019.40 1871300.00 228,100.00 15.60 03/22/2006 VILLAGE OF DEERFIELD PG 15 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 12006 2007 PCT GENERAL FUND -----------------.----------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 102038 STREET TRAIN STATION MAINT -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 102038 5110 REG SALAR 5,469.56 7,000.00 7,000.00 6,650.24 7,0.00.00 8,500.00 21.4% Pedestrian bridge, viaduct and train station 102038 5111 PT SALARY -.00 2,200.00 2,200.00 872.00 2,- 200.00 2,200.00 .0% 102038 5112 OT SALARY .00 .00 .00 64:00 .'00 1,000.00 .0% 102038 5120 MED BNFT 536.23 1,848.00 1,848.00 995.29 1,.848.00 2,032.80 10.0% 102038 5121 DNTL BNFT 49.51 190.00 190.00 84.14 190.00 190.00 .0% 102038 5122 MISC BNFT 17.99 .00 .00 22.46 .00 .00 .0% 102038 5140 PEN CNTRB 931.36 1,400.00 1.,400.00 1,240..47. 1,400.00 1,600.00 14.3% TOTAL PERSONNEL SERVICES 7,004.65 12,638.00 12,638.00 9,928.60 12,638.00 15,522.80 22.8% 53 CONTRACTUAL SERVICES -------------------------------------------- 102038 5320 BLDG R&M 167.15 3,000.00 3,000.00 3,525.65 4,.000.00 5,000..00 66.7% Electric doors, floor sanding, windows and rails. 102038 5321 STRUC R&M 14,550.00 20,000.00 20,000.00 14,180.00. 20,000.00 '22,000.00 10.0% Alarm maintenance $3760, door and window maintenance $2800, boiler maintenance $4000, parking lots $3500, 1/3 cost for landscaping $6940 102038 5322 EQUP R&M 164.50 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% TOTAL CONTRACTUAL SERVICES 14,881.65 24,000.00 24,000.00 .17,705.65 25,000.00 28,000.00 16.7% 54 COMMODITIES ---------=---------------------------------- 102038 5421 MATERIAL 1,671.38 4,000.00 4,000.00 :51.54 1,500.00 4,000.00 .0% Hardware, wood and glass as needed for repairs 102038 5460 OPER SUPP 1,457.38 1,000.00 1,000.00 1,538..92 1,300.00 1,500.00 50.0% Floor sealers, waxes 102038 5470 R&M SUPP 802.08 1,000.00 1,000.00 93.58 1,000.00 1,000.00 .0% Mops, rags and brooms . TOTAL COMMODITIES 3,930.84 6,000.00 6,000.00 .1,684.04 31800.00 6,500.00 8.3% 55 UTILITIES -------------------------------------------- 102038 5550 U/E TELECM 447.02 500.00 500.00 358.45 .500.00 500.00. .0% Telemetry and phone TOTAL UTILITIES 447.02 500.00 500.00 358.45 500.00 500.00 .0% TOTAL STREET TRAIN STATION M 26,264.16 43,138.00 43,138.00 29,6.76.74 41,938.00 50,522.80 17.1% 03/22/2006 VILLAGE OF DEERFIELD PG 16 . 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR.PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 -2006 2007 PCT GENERAL FUND -------------------------------------------=----------------------------------------------=----------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 102050 STREET MAINTENANCE -------------------------------------------- 51. PERSONNEL SERVICES 102050 5110 REG SALAR 239,689.93 247,000.00 247,000.00 228,965.87 247,000.00 .275;000..00 11.3% 6 employees 102050 5111 PT SALARY 8,551.88 12,200.00 12,200.00 10,669..56 12,200.00 14,000.00 14.8 %_ -, Seasonal help, 3 men typical X 15 /weeks /man @ $8 to $10 /hr. depending on number of years 102050 5112 OT SALARY 27,155.01 36,700.00 36,700.00 23,491.64 36,700.00 36,700.00. 0% Emergency call back 102050 5120 MED BNFT 53,739.69 66,827.00 66,827.00 54,745.41 66,827..00 80,192.40 20.016 102050 5121 DNTL BNFT 5,246.77 6,886.00 6,886.00. 4,712.81 6,886.00 5,500.0.0 -20.1% 102050. 5122 MISC BNFT 812.56 1,500.00 .1,500.00 736.75 1;.500.00 1,500.0 .0 .0 % 102050 5130 APPAREL - 354.80 .00 .00 - 174:27 .00 .00 0% Remove this line item 102050 5140 PEN CNTRB 46,031.95 59,400.00 59,400.00 44,762.45 59,400.00 59,400.00 .0% TOTAL PERSONNEL SERVICES 380,872.99 430,513.00 '.430,513.00 367,910.22 430.;513.00 472,292.40 9.716 52 TRAINING &-DEVELOPME -------------------------------------------- 102050 5210 TRNG REG .00 1,200.00 1,200..00 50.00 1;200.00 1,200.00 .0% Travel training.for seminars, CDL licenses, travel expenses. $200 /man x 6 men = $1200 TOTAL TRAINING & DEVELOPME .00 1,200.00 1,200.00 50.00 1,200.00 1,200:00 .0% 53 CONTRACTUAL SERVICES -------------------------------------------- 102050 5310 RENT EQP 3,348.80 2,500.00 2,500.00 .00 21500.00 2,500.00 .0% Sweeper if needed due to breakdown of village sweeper 102050 5322 EQUP R&M 14,282.73 15,000.00 15,000.00 20,481.'92 22,000.00 15,000.00 .0% $7000 to replace residential and traffic light knock downs $1000 for dump fees and $3000 for fence repairs $4000 for miscellaneous 102050 5326 VEH MAINT 43,650.42 44,000.00 44,000.00 24,546.00 44,000.00 48,000.00 9.1% 102050 5365 P/S OTHER .00 42,000.00 42,000.00 7,681.80 15,000.00 35,000.00 -16.7% Directional boring - $20,000 Bridge cleaning - $5,000 Thermoplastic - 10,000 03/22/2006 VILLAGE OF DEERFIELD PG 17 12:28 RWF EXPENDITURE BUDGET REQUEST -.FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 - 2006 2007 PCT GENERAL FUND ACTUAL. ORIG BUD REVISED BUD ACTUAL PROJECTION ..FIN REVIEW CHANGE ----------------------------------------------------------------------------------------------------'-------------------------------- 102050 5390 OTHER 71,647.30. .00 .00 240.00 .00 .00 .0% TOTAL CONTRACTUAL SERVICES 132;929.25 103,500.00 103,500.00. 52,949.72 83,500.00 100,500.00 -2.916 54 COMMODITIES -------------------------------------------- 102050 5410 MISC SUPP 2,253.50 2,400.00 2,400.00 481.37 2,400.00 2,400.00 .0% Safety equipment, safety fence 102050 5420 PETR PROD 7,482.95 9,600.00 9,600.00 .00 i1,000.00 12,000.00 25.0% 102050 5421 MATERIAL 68,560.39 128,800.00 128,800.00 37,399.79 70,000.00 128,800.00 .0% Aggregates, blacktop, concrete, black dirt, seed, backfill crackfiller, aluminum signs blanks, sign posts, inlet frames and covers, street light poles , heads and lamps 102050 5430 ST SIGNS 11,782.47 15,000.00 15,000.00 9,215.59 151000.00 12,000.00 -20.0% Sign sheeting for aluminum blanks Reduce by $3,000 102050 5440 SMTLSEQUP 641.89 1,000.00 1,000.00 43.16 1,000.00. 1,000.00. .0% Hand tools, specialized tools,shovels etc. 102050 5470 R&M SUPP 2,209.25 2,000:00 2,000.00 .00 2,000.00 2,000.00 .0% Sweeper brooms TOTAL COMMODITIES 92,930.45 158,800.00 158,800.00 47,139.91 101,400.00 158,200.00 -.4% 55 UTILITIES -------------------------------------------- 102050 5510 U/E ELECT 31,198.23 39,000.00 .39,000.00 30,685.69 .39,000.00 39,000.00 .0% Roadway and residential lighting costs TOTAL UTILITIES 31,198.23 39,000.00 39,000.00 30,685.69 391000.00 39,000.00 .0% 56 OTHER EXPENSES -------------------------------------------- 102050 5611 PMTS OTHR .00 36,000.00 36,000.00 21,293.64 36,000.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. TOTAL OTHER EXPENSES .00 36,000.00 36,000.00 21,293.64 36.,000.00 36,000.00 .0% 59 CAPITAL IMPROVEMENTS -------------------------------------------- 102050 5950 BLDNG IMP .00 69,000.00 69,000.00 17,989.62 40,000.00 25,000.00. 763..8% Storage yard paving - $25,000 03/22/2006 VILLAGE OF DEERFIELD PG 18 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION:'20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ------------------------------------------------------------------------------------------------=----------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE - TOTAL CAPITAL IMPROVEMENTS .00 69,000.00 69,000.00 17,989.62 40,000.00 25,- 000.00 -63.8% TOTAL STREET MAINTENANCE 637,930.92 838,013.00 838,013.00 538;018.80 731,613.00 832,192.40 -.7% 03/22/2006 VILLAGE OF DEERFIELD. PG 19 12:28 RWF EXPENDITURE BUDGET REQUEST,- FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 102110 ENGINEERING DIVISION -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 102110 5110 REG SALAR. 82,287.58 170,000.00 170,000.00 129,068.71 150,000.00 231,800.00 36.4% INCLUDE BOTH ASSISTANT ENGINEERS IN THIS DIVISION WAS OTHERWISE CARRIED IN STREET, WATER.AND SEWER INCLUDES $55,000 FOR NEW POSITION ENG. INSPECTOR 102110 5111 PT SALARY .00 5,500.00 5,500.00 .1,804.15 100.00 5,500.00 .0% SUMMER INTERN FOR ENGINEERING $9 -10 /HR @ APPROX 500 HOURS DURING THE SUMMER; ADDITIONAL FOR WINTER /SPRING BREAKS. 102110 5120 MED BNFT 13,780.82 22,000.00 22,000.00 15,032..14 18,000.00 36,400..00 65.5% 102110 5121 DNTL BNFT 1,176.64 2,600.00 2,600.00 1,245.06 1,600.00 1,000100 - -61.56 102110 5122 MISC BNFT 426:88 900.00' 900.00 674.83 900.00 900.00 .0% 102110 5130 APPAREL .00 600.00 600.00 569.45 600.00 900.00 50.0% 102110 5140 PEN CNTRB 13,560.80 17,500.00 17,500.00 22,991.44 22,000.00 27,500.00 57.1% TOTAL PERSONNEL SERVICES 111,232.72 .219,100.00 219,100.00. .171.,405.78 193,200.00. 304,000:00 38.7% 52 TRAINING & DEVELOPME -------------------------------------------- 102110 ' 5211 TRNG TRAV 170.00 2,500.00 2,500.00 1,207.75 1,500.00 2,560.0.0 .0% 102110 5213 SUBSCRIPT_ 78.95 .00 .00 00 .00 .00 .0% TOTAL TRAINING & DEVELOPME 248.95 2,500.00 2,500.00 1,207.75 1,500.00 2,500`.00 .0% 53 CONTRACTUAL SERVICES ------------ 102110 - -------------------------------- 5322 EQUP R&M 780.67 1;250..00 1,250.00 2,576.12 2,500.00: 1,250.00 .0% 102110 5326 VEH MAINT 3,862.70 1,650.00, 1,650.00 3,034.00 3,300.00 1,650.00 .0% 102110 5330• DUES 1,269.00 1,200.00 1,200.00 11052.00 1,20.0.00 1,200..00 .0% 102110 5332 TRAV EXP 2,365.42 500.00 500.00. 92.93. 500.00 1,000:00 100.0% 102110 5335 PRINTING 244.65 500.00 500.00 52.75 500.00 500.00 .0% 102110 5336 LGL NOTICE 563.24 500.00 500.00 408..74 500..00 500.00 .0% 102110 5337 POSTAGE 535.75 300.00 300.00 324.71 450.00 600:_0.0 100.0% 102110 5350 INS GL .00 .00 .00 926.20 1,000..00 1,000.00 .016 . 102110 5362 P/S ENG 10,800.04 25,000..00 25,000.00 13,623.60 95,000..00 25,000.00 .0% 102110 5363 P/S MEDIC .00 250.00 250.00 .00 250.00 250100 .0% 102110 5365 P/S OTHER 1,854.67 7,500.00 7,500.00 1,090.00 7,500.00 _ 7,500.00 ..0% 102110 5375 GIS SERV 103,826.10 107,000.00 107,000.00 104,400.28 _ 107,000.00. 100,000.00 -6.5% PROGRAM STAFFING -. $63,307 AYRES ASSOCIATES - $23,041 HARDWARE - $0 SOFTWARE - GISCON INTERNET MAPPING - $4,368 MAINT & LICENSING SOFTWARE (ESRI) - $7,300 BUDGET IN FY08 FOR PLOTTER SERV $1200 OTHER (CONFERENCES /MISC) - $2000 03/22/2006 VILLAGE OF DEERFIELD PG 20 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR:. 2005 2006 2006 2006 2006 2007. PCT GENERAL FUND -------------------- -.--------------------------------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL ----------------- PROJECTION .--------------------------- FIN REVIEW CHANGE TOTAL CONTRACTUAL SERVICES 126,102.24 145,650.00 145,650.00 127,581.33 219,700;00 140,4-50.00 -3.6% 54 COMMODITIES 102110 5410 MISC SUPP 538.33 1,000.00 1,000.00 1,300.01 1,350.00 1,000.00 .0% 102110 5420 PETR PROD .00 1,200.00 1,200.00 .00 1,20.0.00- 1,500.00 25.0% 102110 5450 OFF SUPP 3,371.16 3,000.00 3,000.00 2,924.31 3,000.00 3,000.00 .0% CHAIR REPLACEMENT FOR BARBARA LITTLE - $300 .102110 5460 OPER SUPP 44.00 500.00 500.00 450.19 .500.00 .500.00 .0% TOTAL COMMODITIES 3,953.49 5,700.00 .5,700.00 .4,674.51. 6,050.00 6,000.00 5.3% 55 UTILITIES -------------------------------------------- 102110 5540 U/E TELEPH 2,427.10 2,500.00 2,500.00 1,806..45 ..2,500.00 .2,500.00 .0% TOTAL UTILITIES 2,427.10 .2,500.0.0 2,500:00 1,806.45 2,500.00 2,500.00 0% 58 CAPITAL OUTLAY -------------------------------------------- 102110 .5810 OP EQP 1,986.00 3,500.00 3,500.00. 2,266_.21 3,500.00 3,500.00 .0% TOTAL CAPITAL OUTLAY 1,986.00 3,500.00 3,500.00 2,266.21 3,500.00 3,500.00 .0% 72 TRANSFERS OUT (IFT) -------------------------------------------- 102110 7211 TRANS VERF 9,082.00 9,081.00 9,081.00 .00 91081.00 9,081.00. .0% TOTAL TRANSFERS OUT (IFT) 9,082.00 9,081.00 9,081.00 .00 19 ;081.00 9,081.00 .0% TOTAL ENGINEERING DIVISION 255,032.50 388,031.00 388,031.00 308,942.03 435;531.00 468,031.00 20.616 03/22/2006 VILLAGE OF DEERFIELD PG 21 12:28 RWF EXPENDITURE "BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 106010 POLICE DEPT ADMINISTRATION -------------------------------------------- '51 PERSONNEL SERVICES -- - - - - - - 106010 - - - - - - - - - - - - - - - - - - - - - - - - - - - - 5110 " REG SALAR - - - - - - -- 568,750.48 589,134.00 589,134.00 433,982.36 489,000.00. 502,578:00 -14.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 MANAGERIAL SECRETARY, TWO RECORDS CLERKS, AND TWO COMMUNITY SERVICE OFFICERS 106010 5111 PT SALARY 945.59 3,000.00 3,000.00 2,877.40 3,000.00 1,500.00 -50.0% 106010 5112 OT SALARY 4,675.48 6,000.00 6,000.00 256:04 1,000.00 3,500.00 -41.7% 106010 5120 MED BNFT 65,193.33 110,000.00 110,000.00 58,048.45 65,974.00 75,000".00 -31.8% 106010 5121 DNTL BNFT 6,570.57 12,500.00 12,500.00 5,073.91 6,100.00 7,500.00 -40.0% 106010 5122 MISC BNFT 4,797.32 5,500.00 5,500.00 5,487.17 .5,580.00 6,000.00 9.116 106010 5130 APPAREL 4,199.44 5,500.00 5,500.00 2,876.88 5,500.00 5,500.00 .0% MISC. CLOTHING ITEMS: BULLET PROOF VEST REPLACEMENT, UNIFORMS FOR NEW EMPLOYEES, ETC.' 106010 5140 PEN CNTRB 659,908.20 725,000.00 725,000.00 615,461.08. 615,:000.00. 700,000.00 -3.416 TOTAL PERSONNEL SERVICES 1,315,040.41 1,456,634.00 1,456,634..00 1,124,063:29 1,191;,.154".00" 1,301,578.00, -10.6% 52 TRAINING & DEVELOPME _. -------------------------------------------- 106010 5211 TRNG TRAV 4,238.46 16,500.00 16,500.00 5,930.99 7,50,0.00 12,000.00 -27.3% 106010 5212 TRNG EXP .00 5,000.00 5,000.00 3,804.00 4,750.00 5,000.00 0 °6 106010 5213 SUBSCRIPT 1,028.57 2,000.00 2,000.00 1,124.93 2,000.00 2,000.00 .0% TOTAL TRAINING & DEVELOPME 5,267.03 23,500.00 23,500.00 10,859.92 14.,250.00 19,000:00 -19.1% 53 CONTRACTUAL SERVICES -------------------------------------------- 106010 5320 BLDG R&M 58,589.76- 56,750.00 56,750.00" 43,621.71 50,000.00 55,000.00 -3.1% 03/22/2006 VILLAGE OF DEERFIELD PG 22 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL. ..PROJECTION FIN REVIEW CHANGE ------ 106010 - - - - -- - --- - - - - -- ---------------------------------------------------------------------------------------------------o- 5322 EQUP R&M 24,672.74 25,000.00 25,000.00 20;725.67 23,.000.00 27,500.00 10.0% 106010 5326 VEH.MAINT _ 640.50 1,500.00 1,500..00 ..468.00 1,250.00 11500.00-- .0% 106010 5330 DUES 1,283.53 2,500.00 2,500.00 785.00. 2,500.00" 2,500.00 .0% 106010 5332 TRAY EXP 9,308.50 .00 .00 202.73 .0.0 .00 .0% 106010 5335 PRINTING 5,017.86 8,000.00 8,000.00 4,433.87 7,500..00 8,000.00 .0% 106010 5336 LGL NOTICE 20.00 1,200.00 1,200.00 _ .00 1,000.00 1,200.00 .0% 106010 5337 POSTAGE 2,233.92 2,750.00 2,750.00 2,121.96 2,6.00.00 3,200.00 16.4°% 106010. 5350 INS GL 149,940.04 189,000.00 189,000.00 172,.955.31 189,000.00 217,350.00. .15.00 106010 5363 P/S MEDIC 4,830.00 6,000.00 6,000.00 827.50 6,000.00. 6,000.00 .0% 106010 5365 P/S OTHER 93.00 .00 .00 390.00 .00 .00 .0% 106010 5370 DP SERV 1,096.00 12,250.00 12,250.00 11,027.51 12,250.00 14,600.00 19.216 106010 5387 ADV BOARD 14,086.64 20,000.00 20,000.00 14,757.50. 15,000.00 20,000..00 .0% PURPOSE: Costs associated with various village boards and commissions DESCRIPTION: Costs associated with testing of Police Cand. Sergeants exam, expenses incurred from Mudfest, etc. .Newspaper ads - $2,000 Consultation Fees (Zachar) - $2,4'00 Cost of Police Test - $2,000 Credit Checks - $750 Sergeants Test - $3,000 Mudfest - $8,000 106010 5388 EMER SERV - 3,174.63 8,000.00 8,00.0.00 2,677.78 5,060.00 8,000.00 ,.0 %. PURPOSE: Cost of operating the ESDA Center 106010 5390 OTHER 38,090.00 46,500.00 46,500.00 38,589.91 46,500.00 94,100.00 102.4% PURPOSE:' Other contractual work not classified DESCRIPTION: NIPCL - $29,178 NIPAS - $4,500 HiVhland 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 CALEA Continuation Fees - $8,390 Job Description /Task Analysis - $40,000 ' TOTAL CONTRACTUAL SERVICES 313,077.12. 379,450.00 379,450.00 313,584.45 361,:600.00 458,950.00 21.0% 54 COMMODITIES -------------------------------------------- 106010 5410 MISC SUPP 535.34 1,500.00 1,500.00 449.15 850.00 1,500..00 .0% 03/22/2006 VILLAGE OF DEERFIELD PG 23 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyi-pts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR-PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 106010 5420 PETR PROD 1,298.11 1,750.00 1,750.00 .00 1,750.00 2,000.00 14.3% 106010 5450 OFF.SUPP 9,399.03 10,000.00 10,000.00 6;5.98.31 9,750.00 10,000.00 .0% 106010 5460 OPER SUPP 31,683.00 37,000.00 37,000.00 24,993.21 34,500.00 37,000.00 .0% 106010 5470 R&M SUPP 1,291.14 ` 2,000.00 2,000.00 .171.24 2,000.00 2,000.00 .0% TOTAL COMMODITIES 44,206.62 52,250.00 52,250.00 32,211.91 48,850.00 52,500.00 .5% 55 UTILITIES -------------------------------------------- 106010 5540 U/E TELEPH 2,763.22 .00 .00 1,069.30 .00 .00 .0% 106010 5550 U/E TELECM 30,221.31 35,000.00 35,000.00 28,459.72 35,000.00. 37,000.00 5.7% TOTAL UTILITIES 32,984.53 35,000.00 35,000.00 29,529.02 35,000.00 37,000.00 5.7% 58 CAPITAL OUTLAY -------------------------------------------- 106010 5810 OP EQP 1,553.54: 3,000.00 3,000.00 2,065.47 3,000.00- 6,500:00 116.7% TOTAL CAPITAL OUTLAY 1,553.54 3,000.00 3,000.00 2,065.47 31000.00 6,500.00 116.7% 72 TRANSFERS OUT (IFT) -------------------------------------------- 106010 7211 TRANS VERF 193,424.00 168,287.00 168,287.00 .00 168,287.00 178,214.00 5.916 TOTAL TRANSFERS OUT (IFT) 193,424.00 168,287.00 168,287.00 .00 168,287.00 178,214.00 5.96 TOTAL POLICE DEPT ADMINISTRA 1,905,553.25 2,118,121.00 2,118,121.00 1,512,314.06 11822,141.00 2,053,742.00 -3.0% 03/22/2006 VILLAGE OF DEERFIELD PG 24 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/.07 bgnyrpts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL' ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 106020 POLICE DEPT COMMUNICATIONS -------------------------------------------- 51 PERSONNEL SERVICES 425,529.53 -------------------------------------------- 106020 5110 REG SALAR 459,954.92 106020 5111 PT. SALARY 10,232.26 106020 5112 OT SALARY 34,302.23 106020 5120 MED BNFT 60,718.76 106020 5121 DNTL BNFT 6,007.92 106020 5122 MISC BNFT 3,991.45 106020 5130 APPAREL 1,747.34 106020 5140 PEN CNTRB 84,633.33 TOTAL PERSONNEL SERVICES 661,588.21 52 TRAINING & DEVELOPME 9,000.00 -------------------------------------------- 106020 5211 TRNG TRAV 866.64 106020 5212 TRNG EXP .00 106020 5213 SUBSCRIPT 218.90 TOTAL TRAINING & DEVELOPME 1,085.54 53 CONTRACTUAL SERVICES 89,565.00 -------------------------------------------- 106020 5330 DUES 330.00 106020 5332 TRAV EXP 819..00 TOTAL CONTRACTUAL SERVICES 1,149.00 54 COMMODITIES 900.98 -------------------------------------------- 106020 5460 OPER SUPP .00 TOTAL COMMODITIES .00 58 CAPITAL OUTLAY 2,500'.00 ---------------------- 106020 7 ---------------- 5810 OP EQP ------ 2,512.99 135..71 PURPOSE: Purchase of equipment 300..00 DESCRIPTION:. 4,300.00 4,300.00. LCD Monitors - $3,000 3,.650..00 5,300:00 Shelving - .$1,500 500.00 500.00 Misc. /Computer Equipment - $2,500 491,776.00 491,776.00 425,529.53 482,067.00 511,453.00 4.0% 12,500.00 12,500.00 27,.056.59 34,948.00 35,000.00 180.0% 27,000.00 27,000.00 21,428.78 22,793.00 - 27,000.00 .0% 72,600.00 72,600.00 64,921.48 72,881.00 80,169.00 10.4% 10,500.00 10,500.00 5,904.50 6,968.0.0 8,500.00 -19.0% 9,000.00 9,000.00 5,341.70 4950.00 8,000:00 -11.1% 2;800.00 2,800.00 _ B31..09 2,800.00 2,800.00 .0% 99,360.00 99,360.00 81,121.31 89,565.00 :99,360. -00 .0% 725,536.00 725,536.00 .632,134.98 716,972.00 772,282.00 6.4% 2,000.00 2,000.00 900.98 1,750.00 2,500.00 .25.0% 2,000.00 2,000.00 1,199.07 1,650..00. 2,500'.00 25.0% 300.00. 300.00 135..71 250.00 300..00 .0% 4,300.00 4,300.00. 2,235.76 3,.650..00 5,300:00 23.3% 500.00 500.00 335.00 475.00 500.00 .0% .00 .00 .00 .00.. .0 0 .0% 500.00 .500.00 .335.00 475.00 500.00 .0% .00 .00 91.07 .00 .00 .0% .00 .00 91.07 .00 00 .096 9,000.00• 9,000.00 2,815.85 .91000.00 7,000.00 -22.2% 03/22/2006 VILLAGE OF DEERFIELD PG 25 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ----------------------------------------------------------------------------------------------------------------------=------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE TOTAL CAPITAL OUTLAY 2,512.99 9,000.00 9,000.00 2,815.85 9,000.00 7,000.00 -22.20 TOTAL POLICE DEPT COMMUNICAT 666,335.74 739,336.00 739,336.00 63.7,612.66 730,097.00 785,082.00 6.20 03/22/2006 VILLAGE OF DEERFIELD PG 26 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgny-rpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005. 2006 2006 2006- 2006 2007 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE --------------------------------- ---------------------------------------------------------------------------------------=----- - - - - -- 106033 POLICE DEPT INVESTIGATIONS 51 PERSONNEL SERVICES 19,750.00 21,000.00 -------------------------------------------- 106033 5110 REG SALAR 575,674.70 633,000.00 112,000.00 PURPOSE: Regular Salaries.for Full time employees. 6,783.91 .Includes allowance for merit and COLA -6.30 7,500.00 DESCRIPTION: Salaries for one Investigations Supervisor, 3,000.00 two Investigators, two Youth Officers, one DARE officer, 6,500.00 two Social Workers 6,000.00 6,500.00 106033 5112 OT SALARY 20,965.10 20,000.00 106033 5120 MED BNFT 97,866.83 111,804.00 106033 5121 DNTL BNFT 8,384.07 10,672.00 106033 5122 MISC BNFT 4,616.56 7,500.00 106033 5130 APPAREL 3,878.12 6,500.00 106033 5140 PEN CNTRB 30,271.30 37,00.0.00 TOTAL PERSONNEL SERVICES 741,656.68 826,476.00 52 TRAINING & DEVELOPME 6,950.00 .0% -------------------------------------------- 106033 5211 TRNG TRAV 403.47 1,200.00 106033 5212 TRNG EXP .00 5,000.00 106033 5213 SUBSCRIPT 836.66 750.00 TOTAL TRAINING & DEVELOPME 1,240.13 -6,950.00,. 53 CONTRACTUAL SERVICES 4,950'.00 5,500.0Q -------------------------------------------- 106033 5326 VEH MAINT 4,184.45 4,500.00 106033 5330 DUES 991.00 1,200.00 106033 5332 TRAV EXP 2,491.73 .00 TOTAL CONTRACTUAL SERVICES 7,667.18 5,700.00 S4 COMMODITIES 7,169.89 8.,000.00 -------------------------------------------- 106033 5415 DARE PROG 6,665.94 8,250.00 106033 5420 PETR PROD 3,107.21 3,750.00 TOTAL COMMODITIES 9,773.15 12,000.00 58 CAPITAL OUTLAY -------------------------------------------- 106033 5810 OP EQP 4,675.90 8,000.00 PURPOSE: Purchase of equipment for Investigations - DESCRIPTION: Laptop Computer - $2,500. Misc. Equipment - $3,000 633,000.00 518,819.79 .620,707.00 623,712.00 -1.5% 20,000..00 16,805.54 19,750.00 21,000.00 5.0% 111,804.00 83,442.83 111;804.00 112,000.00 .2% 10,672.00 6,783.91 .7;797.00 10,000.00 -6.30 7,500.00 1,559.77 3,000.00 5,000:00 - 33.3% 6,500.00 4,154.21 6,000.00 6,500.00 .0% 37,000.00 22,151.75 28,000.00 35,000.00 -5.4% 826,476.00 653,717.80 797,058.00 813,212.00 -1.6% .1,200.00 215.66 11000.00 1,200.00 .0% 5,000.00 623.00 41,250.00 5,000..00 .0% 750.00 192.00 ..750.00 750.00 .0% 6,950.00 1,030.66 6,.000.00 6,950.00 .0% 4,500.00 2,252.25. 3,750.00 4,500.00 .0% 1,200.00 ..588.00 1,200.00 1,000.00 -16.7% .00 .00 .0.0 .00 0% 5,700.00 21840.25 4,950'.00 5,500.0Q -3.5% 8,250.00 5,947.39 8,- 250..00 9, 000..00 9.116 3,750.00. 5.00 31750.00 6,750.00 80.0% 12,000.00 5,952..39 12,000..00 15,750.00 31.3% 8,000.00 7,169.89 8.,000.00 5,500.00 -31.3% 03/22/2006 VILLAGE OF DEERFIELD PG 27. 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006. 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN.REVIEW CHANGE TOTAL CAPITAL OUTLAY 4,675.90 8,000.00 8,000.00. 7,169.89 8,0.00.00 5,500.00 - 31.3 °s TOTAL POLICE DEPT INVESTIGAT .765,013.04 859,126.00 859,126.00 670,710.99 828,008.00 846,912.00 -1.4% i 03/22/2006 VILLAGE OF DEERFIELD PG 28 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE -------------------------------------------------------------------=----------------------------=------------- -------- - - - - -- - - - - -- 106034 POLICE DEPT PATROL 51 PERSONNEL SERVICES 2,457,579.00 .816 -------------------------------------------- 106034 5110 REG SALAR 2,223,995.45 2,437,200.00 44,000.00 PURPOSE: Regular salaries for full time employees. -9.1% Includes allowance for merit and COLA 12,500.00 25.0% DESCRIPTION: Salaries for 1 Deputy Chief, 8 Supervisors 41,000.00 23 Patrol Officer, including merit and Career Development 27,304.85 for qualified personnel .0% 3,112,784.00 106034 5111 PT SALARY 55,908.84 65,000.00 4,460.02 PURPOSE: Salaries for permanent and temporary 30,000.00 .part time employees 30,000.00 .0% - Salaries for 8 crossing guards for a total of 24 hours 900.00 per day - 186 days at 14.69 per hour 33,400.00 36,900.00 Salaries for assisting Department during special events .00 Salaries for summer school guards - 25 hours a week 391029.62 for six weeks (partial reimbursement from school) 106034 .5112 OT SALARY 108,910.33 120;000.00 106034 5120 MED BNFT 322,553.50 363,000.00 106034 5121 DNTL BNFT 28,725.88 44,000.00 106034 5122 MISC BNFT 8,160.72 10,000.00 106034 5130 APPAREL 37,501.11 36,000.00 106034 5140 PEN CNTRB 27,871.08 37,584.00 TOTAL PERSONNEL SERVICES 2,813,626.91 3,112,784.00 52 TRAINING & DEVELOPME --------------------------------------- 106034 5211 TRNG TRAV 2,040.82 5,000.00 106034 5212 TRNG EXP .00 30,000.00 106034 5213 SUBSCRIPT. 387.50 900.00 TOTAL TRAINING & DEVELOPME 2,428.32 35,900.00 53 CONTRACTUAL SERVICES -------------------------------------------- 106034 5322 EQUP R&M 1,473.35 .00 106034 5326 VEH MAINT 48,726.32 45,000.00 106034 5330 DUES 629.96 600.00 106034 5332 TRAV EXP 19,745.39 .00 TOTAL CONTRACTUAL SERVICES 70,575.42- 45,600.00 54 COMMODITIES -------------------------------------------- 106034 5420 PETR PROD 46,584:87 50,000.00 0 2,437,200.00 2,192,835.60 2,470,288.00 2,457,579.00 .816 65,000.00 .58,975.36 71,300:00 71,650.00 10.216 120,000.00 100,032.65 121,000.00 125,000.00 4.2% 363,000.00 326,603.15 370,661:00 400,000.00 10.2% 44,000.00 26,760.22 30,500:00 .0 40,0000 -9.1% 10,000.00 7,590.38 9,500. 00 12,500.00 25.0% 36,000.00 18,374.42 34.,500.00 _ 41,000.00 .13.9% 37,584.00 27,304.85 32,300.00 37,584.00 .0% 3,112,784.00 2,758,476.63 3,140,049.00 3,185,313.00 2.3% 5,000.00 4,460.02 51000.00 6,000.00 20.0% 30,000.00 17,118.90 27,500.00 30,000.00 .0% 900.00 637.65 900.00 900.00 .0% 35,900.00 22,216.57 33,400.00 36,900.00 2.8% .00 .00 .00 .00 .0 %. 45,000.00 391029.62 44,350.00 501000..00 .. 11.1°'6 600.00 585.00 600.00 600.00 ..0% .00 .00 .00 .00 .0% 45,600.00 39,614.62. -44,950.00 50,600.00 11.0 %; 50,000.00 .00 65,..000.00 75,000.00 50.0% 03/22/2006 VILLAGE OF DEERFIELD PG 29 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071, FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND ACTUAL ------------------------------------------------------------------------------------=----------------------------------------------- ORIG BUD REVISED BUD ACTUAL, PROJECTION FIN REVIEW CHANGE TOTAL COMMODITIES .46,584.87 50,000.00 50,000.00. .00 65,000.00 75,000.00 50.0% 55 UTILITIES -------------------------------------------- 106034 5550 U/E TELECM 5,483.75 7,000.00 7,000.00 4,958.69 5,500.00 . 7,000.00 .0% TOTAL UTILITIES 5,483.75 7,000.00. 7,000.00 4,958.69 5,500.00 7,000.00 .0% 58 CAPITAL OUTLAY -------------------------------------------- 106034 5810 OP EQP 32,741.30 22,800.00 22,800.00 11,810.98 22,000.00 15,600.00 -31.6% PURPOSE: Purchase of Non -VERF Equipment for Patrol DESCRIPTION: Equi p ment for Patrol Misc. Equipment - 5,000 Citizen Police Academy Supplies.- $1,500. Moving Radar Units - $4,647 Speed Board Equipment /Supplies - $800 Ballistic Vests - $3,600 TOTAL CAPITAL OUTLAY 32,741.30 22,800.00 22,800.00 11,810.98 22,000.00 15,600.00 - - 31.66 TOTAL POLICE DEPT PATROL 2,971,440.57 3,274,084.00 3,274,OB4.00 2,837,077.49 3,31.0,899.00 3,370.,413.00 2.90 03/22/2006 VILLAGE OF DEERFIELD PG 30 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GENERAL FUND -------------------------------------------------=---------------------------------------------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 106061 POLICE DEPT SPEC DETAIL -------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 106061 5112 OT SALARY 99,604.52 225,910.00 225,910.00 107,448.24 - 225,910.00 292,00,0.00, 29.30 INCREASE DUE TO ADDITION OF TWO MORE LOCATIONS 106061 5120 MED BNFT 12,866.42 .00 .00 14,845.79 .00 15,000.00 .016 106061 5121 DNTL BNFT 1,141.73 .00 .00. 1,199.60 .00. 1,600.00 .0% 106061 5122 MISC BNFT 95.32 .00 .00 217.24 .00 .00 .0% 106061 5140 PEN CNTRB 1,700.46 .00 .00 2,195.56 00 ..00 .0% TOTAL PERSONNEL SERVICES 115,408:45 ' 225,910.00 225,910.00 125,906.43 22.5,910.00 308,600.00. 36.6% TOTAL POLICE DEPT SPEC DETAI 115,408.45 225,910.00 225,910.00 125,906.43 225,910.00 308,600.00. 36.6% TOTAL GENERAL FUND 11,454,718.28 16,262,253.10 16,262,254.00 10,239',698.37 12,542,601.60 17,371,819.65 6.8% 03/22/2006 VILLAGE OF DEERFIELD PG 31 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyi-pts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT MOTOR FUEL TAX FUND ------------------------------------------------------------------------------------------------.------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION .FIN REVIEW CHANGE 142050 MOTOR FUEL TAX EXPENDITURES 59 CAPITAL IMPROVEMENTS -------------------------------------------- 142050 5910 STREET IMP 270,865.12 601,000.00 601,000.00 616,201.64 .616,202.00 625,000.00 4.0% TOTAL CAPITAL IMPROVEMENTS 270,865.12 601,000.00 601,000.00 616,201.64 616,202.00 625,000.00 4.0% 72 TRANSFERS OUT (IFT) -------------------------------------------- 142050 7210 TRNSFR OUT 285;000.00 .00 .00 ..00 .00 .00 .0% TOTAL TRANSFERS OUT (IFT) 285,000.00 .00 .00 .00 .00 .00 .0% TOTAL MOTOR FUEL TAX EXPENDI 555,865.12 601,000.00 601,000.00 616,201.64 616,202.00 625,000..00 4.0% TOTAL MOTOR FUEL TAX FUND 555,865.12 601,000.00 601,000.00 616,201.64 616",202.00 625,000.00 4.0% 03/22/2006 VILLAGE OF DEERFIELD PG 32 _ 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS .FOR: 2005 2006 2006 2006 -2006 2007 PCT E 911 FUND ACTUAL ------------------------------------------------------------------------------------------------------------------------------------ ORIG BUD REVISED BUD. ACTUAL PROJECTION FIN REVIEW CHANGE 176020 E911 FUND EXPENDITURES- ------------- - - -- - 53 CONTRACTUAL SERVICES -------------------------------------------- 176020 5323 RADIO R&M 49,215.21 55,000.00. 55,000.00 52,285.09 52,.641.00 55,000.00 .0% 176020 5370 DP SERV 38,144.48 40,000.00 40,000.00 33,213.00 35,750.00 40,545.00 1.4% TOTAL CONTRACTUAL SERVICES 87,359.69 95,000.00 95,000.00 85,498.09 88,391.00 95,545.00 .6% 55 UTILITIES -------------------------------------------- 176020. 5550 U/E TELECM 55,323.62 69,500.00 69,500.00 44,881.42 53;819.00 76,740.00 10.4% TOTAL UTILITIES 55,323.62 69,500.00 69,500.00 44,8.81.42 531819.00 76,740.00 10.4% 58 CAPITAL OUTLAY . -------------------------------------------- 176020. 5810 OP EQP 3,480.00 .00 .00 - 3,480.00. .00 .00 .0% 176020 5820 RAD EQP 33,379.94 58,500.00 58,500.00 11,172.10 25,500.00 92,500.00 58.1% 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 Back -up Server /NWS - $40,000 Computers - $6,000 Misc. Equipment (headsets) - $1,500 Dialogic Server - $5,000 Voice Logger - $30,000 New World CAD Project - $10,000. TOTAL CAPITAL OUTLAY 36,859.94 58,500.00 58,500.00 7,692.10 25,5.00.00 92,500.00 58.1% 72 TRANSFERS OUT (IFT) -------------------------------------------- 176020 7211 TRANS VERF 51,900.00 47,400.00 47,400.00 .00 .47,400.00 58,483.00 23.4% PURPOSE: Annual costs associated with major equipment items or vehicles - transfer to VERF TOTAL TRANSFERS OUT (IFT) 51,900.00 47,400.00 47,400.00 .00 47,400.00 58,483.00 23.4°% TOTAL E911 FUND EXPENDITURES 231,443.25 .270,400.00 270,400.00 138,071.61 '215,110.00 323,2.68.00. 19.61 TOTAL E 911 FUND 231,443.25 270,400.00 270,400.00 138,071.61 2151110.00 323,268.00 19.6% 03/22/2006 VILLAGE OF DEERFIELD PG 33 12:28 _RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 -2006 2007 PCT VEHICLE & EQUIPMENT REPLACE. ACTUAL ORIG BUD ----=------------------=------------------------------------------------------------------------------------------------------------ REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 211150 VERF EXPENSES - -- ------------------------ 56 OTHER EXPENSES -------------------------------------------- 211150 5670 DEPR EXP 173,796.68 .00 .00 .00 .00 .00 .0% TOTAL OTHER EXPENSES 173,796.68 .00 .00 .00 .00 .00 .0% 58 CAPITAL OUTLAY - - - - - -- -- ------ - - - - -- 211150 5810 OP EQP 32,022.17 65,000.00 65,000.00 7,896.50 8,000..00 115,000.00 - 76.9% SQUAD CAR EQUIPMENT - $35,0.00 IN -CAR CAMERAS (POLICE) (10) - 65,000 POLICE DEPT. UPS BATTERIES - 15,000 211150 5820 RAD EQP 133,743.63 40,000.00 40,000.00 .00 .00 105,000.00. 162.5% MOBILE RADIOS, POLICE - $40,000 - MOBILE DATA TERMINALS, POLICE - 65,000 211150 5830 OFC EQP .00 .00 .00 00 .00 300,000.00 .0% . NEW DATA INFRASTRUCTURE (INCLUDING PHONE SYS) FOR ALL DEPTS. INSTALLED AS PART OF NEW VILLAGE HALL CONSTRUCTION TOTAL COST FOR ALL DEPARTMENTS - $300,000 INCLUDES SERVICES TO DESIGN AND INSTALL 211150 5850 MBL EQP 11,250.00 270,000.00. 270,000.00 223,595.00 2231595.00. 69,500.00 _ -74.3% BOBCAT FOR WRF SLUDGE BED WORK - $55,000 -- THIS IS A NEW PIECE OF EQUIPMENT NOT CURRENTLY ON THE VERF SCHEDULE AIR COMPRESSOR.REPLACEMENT - WATER - 14,500 211150 5860 MOTOR VEH 56,868.94 385,600.00 385,600.00 315,121.58. 120,970.00 517,000. "00 34.1% POLICE SQUADS (CARRYOVER FROM 05/06) - $275,425 POLICE - 3 UNITS - 77,825 STREET #104 1 TON - 84,000 STREET #707 1 TON DUMP - 47,250 - STREET #809 1 TON P/U - 32,500 TOTAL CAPITAL OUTLAY 233,884.74 760,600.00 760,600.00 546,613.08 352,565.00 1,106,500.00 45.5% TOTAL VERF EXPENSES 407,681.42 760,600.00 760,600.00 546,613..08 352,565.00 1,106,500.00 45.5% TOTAL VEHICLE & EQUIPMENT RE 407,681.42 760,600.00 760,60.0.00 546,613.08 352;56.5.0.0 1,106,500.00 45.5% 03/22/2006 VILLAGE OF DEERFIELD PG 34 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION! 20071 FY.2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT INFRASTRUCTURE REPLACEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE .222082 INFRA REPLACE FUND EXPENDITURE- -------------------------------------------- 53 CONTRACTUAL SERVICES -------------------------------------------- 222082 5362 P/S ENG 348,302.19 833,400.00 833,400.00 550,641.99 700;000.00 797,000:00 _ -4.4% STREET REHAB PROGRAM - $75,000 DEERFIELD RD PROJECT - $7,000 FOR PH3 WILMOT RD SOUTH - $125,000 .(GRANT DEPENDENT) (WILMOT SOUTH 07/08 - 255,000 08/09 - 215,000) HAZEL BRIDGE -$9000 (GRANT DEPENDENT) WILMOT BRIDGE -$9000 (GRANT DEPENDENT) DEERFIELD RD SIDEWALK EAST OF ROSEMARY - $47,000 LAKE COOK ROAD SIDEWALK WEST OF PINE - $3,000 STRATFORD RD PROJECT - $22,000 ROSEMARY PROJECT - $210,000, (35K PH II, + 175K PH III) CRABTREE PROJECT - $100,000 WILMOT RD. NORTH - $190,000 TOTAL CONTRACTUAL SERVICES 348,302.19 833,400.00 833,400.00 550,641.99 700,000:00 797,000.00 -4.4% 59 CAPITAL IMPROVEMENTS -------------------------------------------- 222082 '5910 STREET IMP 908,650.63 3,114,000.00 3,114,000.00 2,743,2 49. 36 2,400.,000.00 3,654,000.00 17.30 STREET REHAB_- $1,120;000 COMBINED W/ SIDEWALK PROGRAM (06/07) DEERFIELD RD PROJECT - $ 0 WILMOT RD SOUTH - $ 0 (GRANT DEPENDENT) ` (WILMOT S. 07/08 - 403,000 08/09 - 805,000) DEERFIELD RD SIDEWALK EAST OF ROSEMARY - $50,000 LAKE COOK ROAD SIDEWALK WEST OF PINE - $44,000 STRATFORD RD PROJECT - $200,000 ROSEMARY PROJECT - $2,240,000 222082 5911 SDWLK IMP 461,209.20 450,000.00 450,000.00 .450,119.40 450,000..00 .00 - 100.0% 05/06 SIDEWALK & CURB REPLACEMENT PROGRAM - $450,000 06/07 COMBINE WITH STREET REHABILITATION PROGRAM - $0 TOTAL CAPITAL IMPROVEMENTS 1,369,859.83 3,564,000.00 3,564,000.00 3,193,368.76 2,650,000.00 3,654,000.00, 2.5% TOTAL INFRA REPLACE FUND EXP 1,718,162.02 4,397,400.00 4,397,400.00 3,744,010.75 3,550,000.00 4,451,000:00 1.2% TOTAL INFRASTRUCTURE REPLACE 1,718,162.02 4,397,400.00 4,397,400.00 3,744,010.75 3,55 0,00.0.00. 4,4Sl,o 00. 0.0 1.2% 03/22/2006 VILLAGE OF DEERFIELD PG 35 12:28 RWF EXPENDITURE BUDGET REQUEST -'FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT LAKE COOK RD TIF (TIF 1) ---------------------------------------------------------------------------------------------=-------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 251180 TIF 1 EXPENSES -------------------------------------------- 53 CONTRACTUAL SERVICES -------------------------------------------- 251180 5390 OTHER 10,164,354.00 11,500,000.00. 11,-500,000.00 5,545,671.00 11,586,517..00 250,000.00 - 97.8°6 THE LAKE COOK ROAD TIF DISTRICT TERMINATED ON 12/31/04. FINAL ACTIVITY WILL BE TO CONTINUE TO DISTRIBUTE THE INCREMENT TO THE TAXING DISTRICTS. TOTAL CONTRACTUAL SERVICES 10,164,354.00 11,500,000.00 11,500,000.00 51-545,671.00 11,586,517:00 250,000.00 - 97.816 56 OTHER EXPENSES -------------------------------------------- 251180 5610 OTH EXPENS 3,699,498.23 .00 .00 .00 .00 .00 .0% TOTAL OTHER EXPENSES 3,699,498.23 .00 .00 .00 00 :00 .0% 59 CAPITAL IMPROVEMENTS -------------------------------------------- 251180 595.0 BLDNG IMP 59,243.28 .00 .00 .00 .00 .00 .0% TOTAL CAPITAL IMPROVEMENTS. 59,243.28 .00 .00 .00 00 .00 .0% TOTAL TIF 1 EXPENSES 13,923,095.51 11,500,000.00 11,500,000.00 5,545,671.00 11,5136,517.00 250,000.00 -97.8% TOTAL LAKE COOK RD TIF (TIF 13,923,095.51 11,500,000.00 11,500,000.00 5,545,671.00 11,586,517.00 250,000.00 -97.8% 03/22/2006 VILLAGE OF DEERFIELD PG. 36 12:28 RWF EXPENDITURE BUDGET REQUEST _ FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 - 2006 2006 2006 2007 PCT VILLAGE CENTER TIF (TIF 2) -----------------------------------------------------------------------------------------------------=--=--------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 261180 TIF 2 EXPENSES -------------------------------------------- 53 CONTRACTUAL SERVICES -------.------------------------------------- 261180 5322 EQUP R&M 10,620.00 50,000.00 50,000.00 4,900.00 15,000.00 25,000.00 -50.0% 261180 5362 P/S ENG 203,903.45 10,000.00 10,000.00 00 3,000.00, ._00 - 100.0% 261180 5365 P/S OTHER 5,567.82 200,000.00 200,000.00 288,606.06 200,0.00.00 200,000.00 .0°% ARCHITECTURAL /INSPECTION FEES FOR VILLAGE HALL EXPANSION 261180 5390 OTHER 16,989.45 85,000.00 85,000.00 45,377.19 85,000.00 80,000..00 -5.90 STREETSCAPE MAINTENANCE & REPLACEMENT TOTAL CONTRACTUAL SERVICES 237,080.72 345,000.00 345,000.00 338,883.25 303,000.00 305,000.0.0 -11.6% 59 CAPITAL IMPROVEMENTS -------------------------------------------- 261180 5910 STREET IMP 545,048..90 25,000.00 25,000.00 2,950.00 10,000.00 45,000.00 80.0% PARKING LOT ENHANCEMENTS LINDEMANN /BANK - $ 20,000 261180 5914 STRSCP IMP 331,161.34 15,000.00 15,000.00' 14,787.35 15,000.00' 25,00.0.00 66.70 HOLIDAY LIGHT FOR TREES IN CBD, URN DECORATIONS FOR WINTER, AND EQUIPMENT RENTAL TO PUT UP LIGHTS OTHER STREETSCAPE IMPROVEMENTS INCREASE BY $10,000 06/07 261180 5950 BLDNG IMP 1,203,528.77 2,300,000.00 2,300,000.00 .00 100,000.00 4,300,000.00 87.0% CONSTRUCTION COSTS OF-VILLAGE HALL EXPANSION - $4,000,000 FACADE REBATE PAYMENTS - $300,000 261180 5960 LAND ACQ 108,814.80 .00 .00 1,991.37 .00 00 .0% TOTAL CAPITAL IMPROVEMENTS 2,188,553.81 2,340,000.00 2,340,000.00. 19,728.72 125,000.00 4,310,000.00 86.8% 72 TRANSFERS OUT (IFT) -------------------------------------------- 261180 7210 TRNSFR OUT .1,941,750.00 1,877,250.00 1,877,250.00 11704,750.00 1,877,250.00 2,302,000.00 22.6% DEBT SERVICE EXPENSES FOR 1998 ISSUE TOTAL TRANSFERS OUT (IFT) 1,941,750.00 1,877,250.00 1,877,250:00 1,704,750.00 1,877.;250.00 2,302,000.00 22.6°% TOTAL TIF 2 EXPENSES 4,367,384.53 4,562,250.00 4,562,250.00 2,063,361.97 2,305,250.00" 6,977,000.00 52.9% TOTAL VILLAGE CENTER TIF (TI 4,367,384.53 4,562,250.00 4,562,250.00 2,063.,361.97 2,305,250.00: 6,977,000.00 52.9°% 03/22/2006 VILLAGE OF DEERFIELD PG 37 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 .2006 2007 PCT _ PROJECT 29 FUND ---------------------------------------------- ACTUAL =------------------- ORIG BUD REVISED BUD --------------- ----------- ACTUAL ----------- PROJECTION =-=---------------------------- FIN REVIEW CHANGE 299999 PROJECT 29 EXPENDITURES -53 CONTRACTUAL ----------------- SERVICES 299999 5390 OTHER .00 500.00 500.00 .00 500.00 500..00 .0% TOTAL CONTRACTUAL SERVICES .00 500.00 500.00 .00 500.00 500.00 .0% TOTAL PROJECT 29 EXPENDITURE .00 500.00 500.00 .00 500.00 500:00 .0% TOTAL PROJECT 29 FUND .00 500.00 500.00 .00 500.00 500.00 .0% 03/22/2006 VILLAGE OF DEERFIELD PG 38 12:28 RWF. EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR.PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT DEBT SERVICE FUND -------------------------------------------------=---------------------------------------------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN - REVIEW CHANGE 357070 DEBT SERVICE EXPENSE 56 OTHER EXPENSES -------------------------------------------- 357010 5610 OTH EXPENS .00 .00 .00 .00 .00 600,000.00 .0% TRANSFER OF SURPLUS FUND BALANCE TO INFRASTRUCTURE FUND FOR CAPITAL PROJECTS. TOTAL OTHER EXPENSES .00 .00 .00 .00 .00 600,000.00 .016 TOTAL DEBT SERVICE EXPENSE .00 .00 .00 .00 ,.00 600,000.00 .0% 03/22/2006 VILLAGE OF DEERFIELD PG 39 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 -PCT DEBT SERVICE FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 357071 DEBT SERVICE 1997 EXP -------------------------------------------- 57 DEBT SERVICE -------------------------------------------- 357071 5760 D/S FA FEE 600.00 .00 .00 .00 .00 .00 .0% TOTAL DEBT SERVICE 600.00 .00 .00 .00. 00 ..00 .0% TOTAL DEBT SERVICE 1997 EXP 600.00 .00 .00 .00 .00 ..00 .0% 03/22/2006 VILLAGE OF.DEERFIELD PG 40 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007. PCT DEBT SERVICE FUND ------------------------------------------------------------------------------------------------------------------------------------ ACTUAL ORIG -BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 357072 . DEBT SERVICE 1998 EXP -------------------------------------------- 57 DEBT SERVICE -------------------------------------------- 357072 5710. D/S INTER 441,750.00 345,000.00 345,000.00 .204,750.00 345,000.00 302,000.00 - 12.5°% 357072 5730 D/S PRINC 1,500,000.00 2,000,000.00 2,000,000.00. 1,500,000.00 1,500,000.00 2,000,000.00 .0% 357072 5760 D/S FA FEE 600.00 1,000.00 1,000.00 300.00 1,000.00 1,000.00 .0% TOTAL DEBT SERVICE 1,942,350.00 2,346,000.00 2,346,000.00 1,705',050.00 1,846,.000.00 2,303,000.00 -1.86 TOTAL DEBT SERVICE 1998 EXP 1,942,350.00 2,346,000.00 2,346,000.00 1,705,050.00 1,846,000.00 2,303,000.00 -1.8% 03/22/2006 VILLAGE OF DEERFIELD PG 41 12:28 RWF EXPENDITURE'BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005' 2006 2006 2006 2006 2007 PCT DEBT SERVICE FUND -------------------------------------------------- ACTUAL -------------------------------------------------- ORIG BUD REVISED BUD ACTUAL PROJECTION - --- =---------------- FIN REVIEW ------------- CHANGE 357073 DEBT SERVICE 2002 EXP -------------------=------------------------ 57 DEBT SERVICE - --------------------------------------------- 3570.73 5710 D/S INTER 39,400.00 .00 .00 .00 .00 .00 .0% 357073 5730 D/S PRINC 985,000.00 .00 .00 .00 .00 .00 .0% THIS ISSUE WAS RETIRED WITH THE PAYMENTS.MADE IN FY 04/05. 357073 5760 D/S FA FEE 200.00 .00 .00 .00 .00 .00 .0% TOTAL DEBT SERVICE 1,024,600.00 .00 .00 .00'. :00 .00 0% TOTAL DEBT SERVICE 2002 EXP 1.,024,600.00 .00 .00 .00 .00 .00 .0% . 03/22/2006 VILLAGE OF DEERFIELD PG 42 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07- bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT DEBT SERVICE FUND ----------------------------------------------------------------------------------------------------------=------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 357074 DEBT SERVICE 2003 EXP ------------------ - - - - - -- - 57 DEBT SERVICE - - - -- - - -- -------------------------------------------- 357074 5760 D/S FA FEE 200.00 .00 .00 .06 .00 .00 0% TOTAL DEBT SERVICE 200.00 00 .00 .00 .00 .00 .0% TOTAL DEBT SERVICE 2003 EXP 200.00 .00 .00 .00 .00 .00 .0% TOTAL DEBT SERVICE FUND 2,967,750.00 2,346,000.00 2,346,000.00 1,705,050.00 1,846,000.00 2,903,000.00 23.7% 03/22/2006 VILLAGE OF DEERFIELD PG 43 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 . bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT WATER FUND -------------------------------------------------------------------------------------------------7---------------------------------- ACTUAL ORIG BUD REVISED•BUD ACTUAL PROJECTION FIN REVIEW CHANGE 502010 WATER DEPARTMENT ADMINISTRATIO ------------------------.-------------------- 51 PERSONNEL SERVICES -------------------------------------------- 502010. 5110 REG SALAR 116,833.24 160,000.00 160,000.00 109,477.40 130.,000.00 160,000.Ob 0% WATER SUPERVISOR 1.EMPLOYEE 1/4 DIRECTOR,.1 /3 PW & ENG. SECRETARY 502010 5111 PT SALARY 8,489.53 8,000.00 8,000.00 9,248.87 9,000.00 10,000.00 25.0% SEASONAL HELP 2 EMPLOYEES IF NEEDED .502010 5112 OT SALARY 2,622.66 3,000.00 3,600.00 .. 672.78 3,000.00 3,000.00 .0% 502010 5120 MED BNFT 12,339.78 24,750.00 24,750.00. 8,868.44 15,000.00 22,000.00 - 11.1°% 502010 5121 DNTL BNFT 1,396.38 2,750.00 2,750.00 836.21 1;200.00 1,400.00 -49.1% 502010 5122 MISC BNFT 288:95 200.00 200.00 433.37 400.00 350.00 75.0 %. 502010 5130 APPAREL 3,986.94 6,000.00. 6,000.00 2,685.42 51000.00 6,500.00 8.36 CLOTHING, BOOTS, JACKETS ($500 x 7 =3500 + 550 x 1= 550 = $4050) SAFETY APPAREL- $2,400 (300 *8 PER PERSON ) INCLUDES VESTS, GLOVES, HARD HATS, GOGGLES,. RAINSUITS & BOOTS AND MSA EQUIP TOTAL 6450 ROUND TO 6500 502010 5140 PEN CNTRB 20,468.62 27,400.00 27,400.00 20,300.38. 27 ",400.00. 27,400.00 .0% TOTAL PERSONNEL SERVICES 166,426.10 232,100.00 232,100.00 152,516.87 191;000..00 230,650.00 -.6°% 52 TRAINING & DEVELOPME -------------------------------------------- '502010 5210 TRNG REG .00 .00 .00 .00 .00 1,800.00 .0% DIRECTOR 200 $200 PER MAN X 8 MEN 502010 5211 TRNG TRAV 50.00 .00 .00 170.00 '300.00 900:00 .0°% $100 PER MAN X 8 MEN $100 FOR DIRECTOR 502010 5213 SUBSCRIPT 51.50 2.00.00 200.00. 00 200.00 200.00 .0% TOTAL TRAINING & DEVELOPME 101.50 200.00 200.00 170.00 500.00 2,900.00.1350.0% 53 CONTRACTUAL SERVICES -----------=------------------------------=- 502010 5320 BLDG R&M 6,686.32 8,500.00 8,500.00 14,394.27 15,0,00.00 12,000..00 41.2% UPKEEP FOR P.W. BUILDINGS- BOILERS & GAS HEATERS 1/3 CLEANING SERVICE - $4,000 INCREASE 2000 06/07 FOR HVAC INCREASE 1500 06/07 FLOORING 502010 5322 EQUP R&M 3,268.18 4,000.00 4,000:00 1,725.00 .4,000.00 4,000.00 .0% 2 -WAY RADIOS / FUEL METER 1/3 JULIE SERVICE - $900 FAX, PRINTERS, COPY MACHINE, TYPEWRITERS - $1,000 03/22/2006 VILLAGE OF DEERFIELD PG 44 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT WATER FUND ACTUAL ORIG.BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ----------------------------------------------------------------=------------------------------------------------------------------- 502010 5326 VEH MAINT 1,360.00 3,500.00 3,500.00 431.50 3,500.00 4,000.00 14.3% MAINTENANCE ON 603 -- 502010 5330 . DUES 127.00 100.00 100.00 128.00 100.0.0 450.00 350.0% AWWA, AND NSWWA MEMBERSHIP FEES $150 ADD DIRECTOR.-$50 NIPSTA MEMBERSHIP = $250 502010 5332 TRAV EXP 19.03 360.00 300:00 50.00 300.00 1,800.00 500.0% SEMINARS, CONVENTIONS, TRAVEL EXPENSES, LICENSES - APPROX $200-PER PERSON X 8 = $1600 DIRECTOR $200 502010 5335 PRINTING 6,588.99 7,000.00 7,000.00 4,602.04. 7,000.00. 7,000.00 .0% SHUT OFF NOTIFICATIONS, UTILITY BILLS, DOOR HANGERS 502010 5337 POSTAGE 6,754.35 7,000.00 7,000.00 5,409.37 .7,000.00. 7,400.00 5.7% INCREASE IN COST FOR POSTAGE FOR UTILITIES 5% 502010 5350 INS GL 69,329.76 78,225.00 78,225.00 70,749.46 16,000.00_ 89,958.75 15.0% 502010 5362 P/S ENG 1,442.80 6,000:00 6,000.00 .00 21000.00 6,000.00 .016 502010 5363 P/S MEDIC 102.00 1,100.00 1,100.00 00 550.00- 1,300.00 18.2% 105 PRICES....... INCREASE BY 5% DRUG & ALCOHOL TESTING $650 ( $90 PER PERSON PER YEAR ) PRE TESTING $500 ( $250 PER PERSON ) 562010 .EMPLOYMENT 5365 P/S OTHER .00 1,500.00 1,500.00 250.00 1;500.00 1,500.00 0% 1/3 OF $3,065 FOR WEATHER SERVICE 502010 5370 DP SERV 1,445.01 2,000.00 2,000.00 1,469.79 2,000.00 2,000.00 .016 REPLACEMENTS & UPDATES TOTAL CONTRACTUAL SERVICES 97,123.44 119,225.00 119,225.00 99,209.43 118,950.00 137,408775 15.316 54 COMMODITIES . -------------------------------------------- '502010 5410 MISC SUPP. 2,768.09 3,.000.00 3,'000.00 3,332.73 4,500.Ob 3,000.00 .0% SAFETY EQUIPMENT FLASHLIGHTS, BATTERIES 502010 5420 PETR PROD 1,557.11 2,185.00 2,185.00 .00 2,.200.00 2,400.00 9.8 %. 502010 5450 OFF SUPP 474.05 550.00 550.00 205.75 200..00 500.00 - COPIER PAPER, PENS, INK, TAPE 502010 5460 OPER SUPP 5].8.42 300.00 300.00. 275.96 300.00 300..00 .0% 502010 5470 R&M SUPP 148.75 300.00 300.00 ..00 300.00 300.00 .0 %. TOTAL COMMODITIES 5,466.42 6,335.00 6,335.00 3,814.44 7,.500.00 6,500:00 2..6% 55 UTILITIES -------------------------------------------- 502010 5540 U/E TELEPH 14,195.46 16,000.00 16,000.00 11,497.14 .14,000.00 16,000.00 .0% NEXTEL PHONE, ALARMS, TELEMETRY 03/22/2006 VILLAGE OF DEERFIELD PG 45 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT WATER FUND -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ACTUAL - - - - - - - - - - - - - ORIG BUD - - - - - - - - - - - - - REVISED BUD _ - - - - - - - - - - - - - - - - - ACTUAL - - - - - - - - -- - - - - - PROJECTION - - - - - - - - - -- - - - - - FIN REVIEW - - - - - - - - - - - = - CHANGE - - - - - - - - - TOTAL UTILITIES 14,195.46 16,000.00 16,000.00 11,497.14 14,000.00 16,000.00 .0% 56 OTHER EXPENSES --------------------------------------------- 502010 5670 DEPR EXP 275,782.32 .00 .00 .00 .00 .00 .0% TOTAL OTHER EXPENSES 275,782.32 .00 .00 .00 .00 00 .0% 57 DEBT SERVICE -------------------------------------------- 502010 5710 D/S INTER 106,027.65 109,843.00 109,843.00 94,257:50 94;300.00 85,707.50 - 22.0% 502010 5730 D/S PRINC .00 340,000.00 340,000.00 380,000.00 380,000.00 395,000.00 16.2% 502010 5760 D/S FA FEE 200.00 .00 .00 200.00 .00 1,000.00 .0% TOTAL DEBT SERVICE 106,227.65 449,843.00 449,843.00 474,457.50 474,300:00. 481,707.50 7.10 58 CAPITAL OUTLAY -------------------------------------------- 502010 5810 OP EQP .00 2,000.00 2,000.00 2,052.00 4.,500.00: 1,000 ..00 -50.0% ITEMIZE. TOTAL CAPITAL OUTLAY .00 2,000.00 2,000:00 2,052.00 4,500..00 1,000.00 -50.06 72 TRANSFERS OUT (IFT) -------------------------------------------- 502010 7211 TRANS VERF 38.,568.00 41,527.00 41,527.00 .00 41,527.00 41,527.00 .0% TOTAL TRANSFERS OUT (IFT) 38,568.00 41,527.00 41,527.00 00 41,527.00 41,527.00 .0% TOTAL WATER DEPARTMENT ADMIN 703,890.89 867,230.00 867,230.00 743,717.38 852.1277.00. 917,693.25 5.8% 03/22/2006 VILLAGE OF DEERFIELD PG 46 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07, bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT WATER FUND -----------------------------------------------------------------------------------------------------------------------=------------ ACTUAL ORIG BUD REVISED BUD ACTUAL- PROJECTION FIN REVIEW CHANGE 502031 . WATER DEPT DISTRIBUTION _ 51 PERSONNEL SERVICES -------------------------------------------- 502031 5110 REG SALAR 52,820.03 61,000.00 61,000.00 42,875.47 56.,000.00 61,000..00 .0% ONE EMPLOYEE 502031 5112 OT SALARY 13,686.27 10,000.00 10,000.00 16,186.20 16,000.00 18,000.00 80.0% EMERGENCY CALL BACK WATER CONTROLS HISTORICAL TREND - NOT A REG MT. 502031 5120 MED BNFT 10,060.96 15,000.00 15,000.00 11,479.88. 15,000.00 17,250.00 15.0% 502031 5121 DNTL BNFT 903.65 2,640.00 2,640.00 891.58 ..1,100:00 1,200.00 -54.50 502031 5122 MISC BNFT 139.38 .00 .00 139.52 150.00 .00.. .0% 502031 5140 PEN CNTRB 9,393.37 15,000.00 15,000.00 10.,263.88 12,000.00 15,000.00 .0% TOTAL PERSONNEL SERVICES' 87,003.66 103,640.00 103,640.00 81,836.53 100.1250.00 112,450.00 8.50 53 CONTRACTUAL SERVICES -------------------------------------------- 502031 5320 BLDG R&M .00 1,900.00 1,900.00 00 1,900:00 15,060.00 .689.516 MITCHELL PARK PUMP STA $15.000 MITCHELL PARK RESERVOIR, HAWTHORNE RESERVOIR, NORTH FEED BOOSTER STATION, ELEVATED TANK BUILDING 502031 5322 EQUP R&M 15,845.43 19,000.00 19,000.00 18,910.51 22,000.00 25,000.00 31.6% PUMPS AT ALL RESERVOIRS, FLO -LO DIAGNOSTIC SERVICES PUMP CONTROLS UPGRADE $2,000 CATHODIC PROTECTION FOR ELEVATED TANK $1,500 LIGHT REPLACEMENT ELEVATED TANK $400 CONTINUOUS ALARM STATIONS $2,500. UPGRADE ALARMS $2,600 502031 5326 VEH MAINT 3,044.00. 41-400.00 •4,400.00 1,964.25 4,400.00 4,400.00 .0% MAINTENANCE ON 602 502031 5335 PRINTING :00 800.00 800.00 .00 400.00 800:00 .0% EMERGENCY NOTICES ADVANCE NOTICES D -TALES 502031 5362 P/S ENG 23,039.21 80,000.00 80,000.00 5,548'.17 301000.00 36,000.00 -55.0% ELEVATED TANK CLEANING AND REPAIRS $7,000 ELEVATED TANK PAINTING ENGINEERING $50,000 (DEDUCT FOR.NOW.. (PERFORM, IN 12007 -' 2010 BUDGET YEAR)) RICHFIELD PUMP STATION ENGINEERING $35,000 (8,000 HP, 27,000 VOD) RICHFIELD PUMP STA, LEAD PAINT REMOVAL $7,000 IN 06/07 HP RICHFIELD RESV INSPECT, CLEAN, SEAL ENG. $12,000 IN 06/07 (10,000 HP, 2,000 VOW 03/22/2006 VILLAGE OF DEERFIELD PG 47 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION s FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE --------- ------------------------------------------------------------------------------------------------------------------------------ 502031 5365 P/S OTHER 11,221.33 8,800.00 8,800.00 11,189.00 8,80.0.00 8,800.00 .0% CITY OF HIGHLAND PARK BACTERIAL ANALYSIS LEAD AND COPPER CONTENT TESTING AND 1/3 OF $3065 FOR WEATHER SERVICES 502031 5390 OTHER 275.00 .00 .00 .00 .00 .00 .0°% TOTAL CONTRACTUAL SERVICES .53,424.97 1141*900.00 114,900.00 - 37,611.93 6,7,,500:00. 90,000.00 -21.7% 54 COMMODITIES -------------------------------------------- 502031 5410 MISC SUPP 270.09 600.00 600.00 590.50 - 600.00. 600.00 .0% BATTERIES, FLASHLIGHTS, NOTEBOOKS, DEHUMIDIFIER AND FURNACE MATERIALS SAFETY EQUIPMENT 502031 5420 PETR PROD 625.13 2,875.00 2,875:00 .00 2,875.00' 3,000.00 4.3% 502031 5421 MATERIAL. 3,214.84 3,500.00 3,500.00 1,727.93 .3;500.00 3,500.00 0% 502031 54'22 CHEMICAL .00 500.00 500.00 404.00 .500.00 500.00. 0% CHLORINE 502031 5423 BUY WATER 2,033,982.97 2,121,210.00 2,121,210.00 1,894,494.24 2,250,000.00 2,204,997,.80 4.0% HIGHLAND PARK HAS NOTIFIED VILLAGE OF A 3.6% INCREASE IN THEIR WHOLESALE CHARGE FOR WATER. 502031 5460 OPER SUPP 638.20 700.00 700.00 41.15 700.00 706.00 .016 CL2 TEST KITS TOTAL COMMODITIES 2,038,731.23 2,129,385.00 2,129,385.00 11897,257.82 2,258,175.00 2,213,297..80 3.9% 55 UTILITIES 502031 5510 U/E ELECT 70,171.38 80,000.00 80,000.00 63,598.13 80,000.00 83,000.00 3.8% ALL LOCATIONS 502031 5520 U/E NAT GA .00 2,200.00 2,200.00 .00 2,200.00 2,300.00 4.5% ALL LOCATIONS TOTAL UTILITIES. 70,171.38 82,200.00 82,200.00 63,598.13 .82,200.00 85,300.00 3.8% 58 CAPITAL OUTLAY -------------------------------------------- 502031 5810 - OP EQP .00 48,500.00 48,500.00 13,008.12 48,500.00 15,000.00 -69.1% SCADA SYSTEM COMPUTER UPGRADE $8,500 NOW $2500 06/07 SCADA SYSTEM FOR HAWTHORNE.$20,000 NOW $5000 06/07 ALARMS ON HATCHES FOR RESERVOIRS (HOMELAND SECURITY) $20,000 NOW $7500 06/07 FOR ADT HOOKUP TOTAL CAPITAL OUTLAY .00 48,500.00 48,500.00 13,008.12 48,500.00 15,000.00 - 69.1°% 59 CAPITAL IMPROVEMENTS 502031 5920 WTRSYS IMP 22,127.68 .00 .00 29,483.70 .00 ,.00 .0% 03/22/2006 VILLAGE OF DEERFIELD PG 48 • 12:28 RWF EXPENDITURE BUDGET REQUEST- FY 2006/07 bgnyrpts " PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR- .PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007" PCT WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE -------------------------------------------------------------------------------------------=-------_--------=------------------------ 502031 5921" WTRSUP IMP 1,000.00 234,000.00 234,000.00 .00 .00 275,000:,00 17.5% RICHFIELD PUMP STATION - $355,000 (85,000 HP, 270,000 VOD) RICHFIELD PUMP STA. LEAD PAINT REMOVAL - $ 72, 000 (06/07) HP RICHFIELD RESV INSPECT, CLEAN AND SEAL - $ 117,000 (06/07) (112,000 HP, 5,000 VOD) ELEVATED TANK CONSTRUCTION (2007 -2010) TOTAL CAPITAL IMPROVEMENTS 23,127.68 234,000.00 234,000.00 29,483..70 .00 275,000.00 17.50" TOTAL WATER DEPT DISTRIBUTIO 2,272,458.92 2,712,625.00" 2,712,625.00. 2,122,796.23 2,556,625.00 . 2,791,047.80 2.90 03/22/2006 VILLAGE OF DEERFIELD PG 49 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT WATER FUND ACTUAL ------------------------------------------------------------------------------------------------------------------------------------ ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 502050 WATER MAIN MAINTENANCE -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 502050 5110 REG SALAR 182,128.16 185,000.00 185,000.00 168,690.32 192,000.00 205,000.00 10.86 3 1/2 EMPLOYEES VARIOUS LEVELS 502050 5111 PT SALARY 3,848.00 10,000.00 10,000.00 10.,767.75 12,000.00 _12,000.00 20.0% SEASONAL HELP 2 EMPLOYEES 502050 5112 OT SALARY 61,831.97 62,100.00 62,100.00 72,229.58 70,000.0.0 75,000..00 20.8% EMERGENCY CALL BACK 502050 5120 MED BNFT 49,237.12 52,000.00 52,000.00 52,129.27 58,500.,00 64,000.00 23.1% 502050 5121 DNTL BNFT 4,189.32 4,200.00 4,200.00 4,215..16 .4,200.00 5,500.00 31.0 %. 502050 5122 MISC BNFT 703.76 .00 .00 719.48 00 .00 .0% 502050 5140 PEN CNTRB 41,455.39 44,000.00 44,000.00 40,722.10 47,000.00 52,000.00 18.2% TOTAL PERSONNEL SERVICES 343,393.72 357,300.00 357,300.00 349,473.66 383,700.00 413,500.00. 15.7% 53 CONTRACTUAL SERVICES -------------------------------------------- 502050 5310 RENT EQP 2;915.20 4,000.00 4,000.00 .00 4,000.00 4,000.00. 0% EQUIPMENT RENTAL BORING TOOL, MISC. EQUIPMENT 502050 5321 STRUC R&M 715...00 1,400.00 1,400.00 .00 1,400.00 1,400.00. .0% PRECAST CONCRETE VAULTS, CONCRETE RINGS, FRAMES AND COVERS 502050 5322 EQUP R&M 23,269.38 10,000.00 10,000.00 2,041.50 8;000.00 10,000.00 .0% LOCATOR, GENERATOR, PUMPS 502050 5326 VEH MAINT 34,105.00 29,700.00 29,700.00 12,147.75 29,700.00 29,700..00 .0% MAINTENANCE ON 604,580,803,807 502050 5362 P/S ENG 193,240.21 132,000.00 132,000.00 '57,060:49 132,000..00 495,000.00 275.0% - ENGINEERING FOR ANNUAL WM REPLACEMENT PROJECTS CASTLEWOOD ,SAPLING,SUSAN,CLAVINIA ENGINEERING $240,000 ($140;000 IN 07/08) FUTURE WM REPLACEMENT ENGINEERING = $100,000 NORTH AVE. TRANSMISSION MAIN ENGINEERING $75,000 LAKE COOK ROAD WATER MAIN RELOCATION ENG. $64,000 RANK MAP UPDATE $6000 MISC. $10,000 502050 5365 P/S OTHER 37,379.85 112,000.00 112,000.00 90,641.40 .112,000.00 115,000.00 2.7% MAIN REPAIRS $14,000 LEAK SURVEY $11,000 LANDSCAPER $20,000 VALVE REPAIR $25,000 VALVE EXERCISING $25,000 CONCRETE & ASPHALT REPLACEMENT $20,000 HYDRANT PAINTING (SUSPEND 06/07, 07/08. BUDGET) 03/22/2006 VILLAGE OF DEERFIELD PG 50 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION:.20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 502050 5390 OTHER 24,544.34 50,000.00 50,000.00 72,247.14 50,000.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 TOTAL CONTRACTUAL SERVICES 316,168.98 339,100.00 339,100.00 234,138.28 337,100.00 705,100..00 107.9% 54 COMMODITIES -------------------------------------------- 502050 5410 MISC SUPP 4,697.95 2,000.00 2,000.00 663.49 :2,000.00 2,000.00 .0% . SAW BLADES, MARKING PAINT, LUBRICANTS. SAFETY EQUIPMENT 502050 5420 PETR PROD 5,083.92 4,900.00 4,900.00 .00 6;000.00 7,000..00 42.9%. 502050 5421 MATERIAL 120,675.63 170,000.00 _170,000.00 126,381.03 165,000.00. .175,000.00 2.9% CONCRETE $9,000,.ASPHALT $5,000, FILL SAND $7,000 GRAVEL $6,000, STONE $6,000, FLOWABLE FILL $20,000 5 HYDRANTS AND PIPING $16,000, SLEEVES ( ALL SIZES ) $66,000 LUMBER $5,000, BLACK DIRT $10,000, SEED $10,000, SOD $10,000 502050 5440 SMTLSEQUP 694.02 1,200.00 1,200.00 .00 1,200.00 1,200.00 .0% SHOVELS, RAKES, POWER TOOLS, HAND TOOLS TOTAL COMMODITIES 131,151.52 178,100.00 178,100.00 127,044.52 174;200.00 185,200..00 4.0% 58 CAPITAL OUTLAY ---------------=---------------------------- 502050 5810 OP EQP 3,810.65 37,000.00 37,000.,00 32,119.00. 37,000.00 7,000.00 - 81.1% 2 DEWATERING PUMPS @.$1500 = $3000 GENERATOR $1500 MISC. $2500 TOTAL CAPITAL OUTLAY 3,810.65 37,000.00 37,000.00 32,119..00 37,000.00 7,000.00 -81.1% 59 CAPITAL IMPROVEMENTS -------------------------------------------- 502050 5920 WTRSYS IMP 00 995,000.00 995,000.00 1,128,326.85 1,100,000.00 50,000.00 - 95.0% CASTLEWOOD, SAPLING', SUSAN, CLAVINIA WATER MAIN CONSTRUCTION ESTIMATE $1,600,000 (07/08) RIVER CROSSING = $50,000 VIA DIRECTIONAL DRILLING-METHODS TOTAL CAPITAL IMPROVEMENTS .00 995,000.00 995,000..00 1, 128, 326.85 1,100_;000.00 50,000.00 -95.0% TOTAL WATER MAIN MAINTENANCE 794,524.87 1,906,500.00 1,906,500.00 1,,871,102.31 2,032,000.00 1,360,800.00 - 28.6°% 03/22/2006 VILLAGE OF DEERFIELD PG 51 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY .2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007. PCT WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 502054 WATER METER MAINTENANCE -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 502054 .5110 REG SALAR 89,681.51 104,700.00 104,700.00 71,486.39 100,000. -00 110,000.00 5.1% 502054 5111 PT SALARY .00 1,500.00 1,500600 608.00 1;500.00 1,500.00 .0% 502054 5112 OT SALARY 3,695.30 - 3,000.00 3,000.00 1,048.03 3,000.00 3,000.00 .0% 502054 5120 MED BNFT 14,763.12 21,130.00 21,130.00 10,847.80 .16,000.00 19,000.00. - 10.1% 502054 5121 DNTL BNFT 1,418.91 1,870.00 1,870.00 881:71 1,400.00 1,500.00 - 19.8% 502054 5122 MISC BNFT 267.81 500.00_ 500'.00 222.71 500.00 500.00 502054 5140 PEN CNTRB 14,968.44 19,000.00 19,000.00 12,.933.09 17,000.00 19,000.00. .0% TOTAL PERSONNEL SERVICES 124,795.09 151,700.00 151,700.00 98,027.73 139,400.00 154,500.00 1.8% 53 CONTRACTUAL SERVICES -------------------------------------------- 502054 5322 EQUP R &M 2,600.00 1,500.00 1,500.00 495.00 ..1.,500.00 1,500.00 .0% 502054 5326 VEH MAINT 849.00 4,400.00 4,400.00 1,176.50 4,400.00 4,400.,00 .0% INCREASE FOR 2ND PERSON VEHICLE 502054 5332" TRAV EXP .00 300.00 300.00 .00 300.00 .300.00 .0% 502054 5335 PRINTING .00 300.00 300.00 .00 300.00 300.00 .01 -6 502054 5365 P/S OTHER 1,226.45 2,000.00 2,000.00 2,359.79 2,000.00 2,000.00 .0% TOTAL CONTRACTUAL SERVICES 4,675.45 8,500.00 8,500.00 4,031.29 8,500.00 8,500.00 .0% 54 COMMODITIES -------------------------------------------- 502054 5410 MISC SUPP 500.00 500.00 500.00 .00 500.00 500..00 .0% 502054 5420 PETR PROD 1,327.74 2,070.00 2,076.00 .00 2,100.00 2,500.00 20.8% INCREASE FOR 2ND PERSON VEHICLE 502054 5421 MATERIAL 6,320.03 6,000.00 6,000.00 809.10 .4,000.00 6,000.00 .09. 502054 5440 SMTLSEQUP .00 100.00 100.00 8.08 1.00.00 100.00 .0% TOTAL COMMODITIES 8,147.77 8,670.00 8,670.00 .817.18 6;700.00 9,100..00 5.016 58 CAPITAL OUTLAY -- - - - - - - 502054 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 5810 OP EQP - - - -- - 56,151.28 87,000.00 87,000.00 79,963.86 87,000.00 90,000..00 3.4% . PURCHASE OF WATER METERS $88,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 03/22/2006 VILLAGE OF DEERFIELD PG 52 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR PERIOD,13 ACCOUNTS FOR: 2005 2006 2006 2006 2006. 2007 PCT WATER FUND ------------------------------------------------------------------------------------,------------------------------------------------ ACTUAL ORIG BUD REVISED -BUD ACTUAL. PROJECTION FIN REVIEW CHANGE TOTAL CAPITAL OUTLAY 56,151.28 87,000.00 87,000.00 79;- 963.86 87,.000.00 - 90,000.00 3.46 TOTAL WATER METER MAINTENANC 193,769.59 255,870.00_ 255,870.00 182;840.06 241,600.00 262,100.00 2.40" - TOTAL WATER FUND 3,964,644.27 5,742,225.00 5,742,225.00 .4,920_,455.98 5,.682,502.00 5,331,641.05 -7.20 O3/22/2006 VILLAGE OF DEERFIELD PG 53 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT SEWER FUND -------------------------------------------------------------------------------------------=-----------------=---------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 542010 SEWER ADMINISTRATION -------------------------------------------.- 51 PERSONNEL SERVICES 542010 5110 REG SALAR 135,633.23 159,200.00 159,200.00 121,789.69 140,000.00 159,200.00 .0% SEWER FOREMAN / ONE EMPLOYEE 1/4 DIRECTOR / 1/3 PW & ENGINEERING 542010 5111 PT SALARY 7,850.59 7,500.00 7,500.00 7,228.87 7,500.00. 7,500:00 .0% SEASONAL HELP 2 EMPLOYEES 1/3 PW SECRETARY 542010 5112 OT SALARY 1,949.27 3,000.00 3,000.00 1,263.58 3,000.00 4,000..00 33.3% 542010 5120 MED BNFT 15,639.01 24,800.00 24,800.00 15,525:,84 19,.000.00 24,800.00 .016 542010 5121 DNTL BNFT 1,424.42 2,800.00 2,800.00 1,283.91 1;500.00 1,800..00 -35.7% 542010 5122 MISC BNFT 959.55 300.00 300.00 .344.52 350.00 450.00 50.0% 542010 5130 APPAREL 4,089.05 5,500.00 5,500.00 3,517.69 5,500.00 5,000.00 -9.1% CLOTHING / BOOTS / JACKETS ($500 ) x 6 SAFETY APPAREL - ($300 PER PERSON) INCLUDES VESTS; GLOVES, RAINSUITS & BOOTS, GOGGLES, HARD HATS, HAND SANITIZER 542010 5140 PEN CNTRB 23,215.99 30,200.00 30,200.00 21,6.97..07 26,000:00 30,200_.00 .0% TOTAL PERSONNEL SERVICES 190,761.11 233,300.00 233,300.00 172,651.17 850. 00 232,950.00 -.2% 52 TRAINING & DEVELOPME _-------------------------------------------- 542010 5210 TRNG REG .00 .00 :00 .00 .00 700.00 .0% $100 PER MAN X 6 $100 DIRECTOR 542010 5211 TRNG TRAV 35.00 200.00 200.00 180.00. 200.00. 700.00 250.0% SEMINARS / TRAVEL EXPENSES $100.00 PER MAN X 6 $100 DIRECTOR 542010 5213 SUBSCRIPT 62.00 200.00 200.00 67.00 200.00 200.00 .0% PUBLICATIONS, MANUALS TOTAL TRAINING & DEVELOPME 97.00 400.00 400.00 .247.00 400.00 1,600.00 300.0% 53 CONTRACTUAL SERVICES -------------------------------------------- 542010 5320 BLDG R&M 4,680.27- 7,500.00 71500.00 3,947.25 6,500.00 11,000_:00 46.70. UPKEEP FOR PW BUILDINGS- DOORS, WINDOWS, PAINTING $3,500 CLEANING SERVICE - •$4,000 .1/3 INCREASE $2000 6/7 FOR HVAC INCREASE $1500 6/7 FLOORING 03/22/2006 VILLAGE OF DEERFIELD- PG 54- 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR:- 2005 2006 2006 2006 2006 2007 PCT SEWER FUND ACTUAL. ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ------------ 542010 ------------------------------------------------------------------ 5322 - EQUP R&M 1,048. -00 6,500.00 -------------------------------------------------------- 6,500.00 981.15 6,500.00 6,500.00 .0% 2 -WAY RADIOS / FUEL METER 1 /3 WEATHER SERVICE - $1,500 1/3 JULIE SERVICE - $900 FAX / PRINTERS / TYPEWRITERS - $1,000 542010 5326 VEH MAINT 1,113.00 3,300.00 3,300.00 945.00 3,300..00 4,300.:00 30.3% MAINTENANCE ON 601 542010 5330 DUES .00 .00 .00 .00 .00 300.00 .0% MEMBERSHIP FEES AWWA DIRECTOR $50 MEMBERSHIP NIPSTA $250 542010 5332 TRAV EXP 378.03 300.00 300.00 94.56 300.00 400.00 33.3% SEMINARS, CONVENTIONS, TRAVEL EXPENSES, LICENSE $200 PER PERSON $100.DIRECTOR 542010. 5335 PRINTING 2,471.82 4,000.00 4,000.00 2,756.15 4,000.00 4,000:00 .0% LEGALS FOR BID NOTICES 542010 5337 POSTAGE 3,486.66 4,200.00 4,200.00 2,780.73 4,200.00 4,400.00 4.8% 5% INCREASE = $4400 542010 5350 INS GL 97,595.14 115,500.00 115,500.00 .110,995.04 115,500.00 132,825.00 15.0% 542010 5362 P/S ENG .00 10,000.00 10,000.00 2,925.77 10,000.00 10,000.00 .016 542010 5363 P/S MEDIC 586.00 1,000.00 1,000.00 .00 500.00 1,050.00 5.0% DRUG & ALCOHOL TESTING $550 ( $90 PER PERSON PER YEAR ) PREEMPLOYMENT TESTING $450 ( $250 PER PERSON ) INCREASE 6/07 5% 542010 5370 DP SERV 2,053.39 2,000.00 2,000.00 1,469.36 2;000.00 2,000..00 .0% REPLACEMENTS AND UPDATES TOTAL CONTRACTUAL SERVICES 113,412.31 154,300.00 154,300.00 126,895.01 152;800.00 176,775.00 14.6% 54 COMMODITIES . -------------------------------------------- S42010 5410 MISC SUPP 1,763.38 2,300.00 2,300.00 3,396.83 4,600.00 5,000.00 117.4% SAFETY EQUIPMENT, FLASHLIGHTS, BATTERIES SCBA / RESPERATORS / SHORING / GENERATOR 542010 5420 PETR PROD 1,689.69 2,530.00 2,530.00 00 2,400.00 2,800.00 10.7% 542010 5450 OFF SUPP 640.51 500.00 500.00 104.59 500.00. 500:00 .0% COPIER PAPER, PENS, INK, TAPE 542010 5460 OPER SUPP 612.89 1,000.00 1,000.00 530.38 1;000.00 1,000.00 U% TOTAL COMMODITIES 4,706.47 6,330.00 6,330.00 4,031.80 8,500.00 9,300:00 46.9% 55 UTILITIES -------------------=------------------------ 542010 5540 U/E TELEPH 3,857.43 4,800.00 4,800.00 3,750.43 4,800.00 4,800.00 .0% NEXTEL PHONES, ALARMS, TELEMETRY 03/22/2006 VILLAGE OF DEERFIELD PG 55 12:28 RWF EXPENDITURE. BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT SEWER FUND - ------------------------------------------------ ACTUAL --------------------------------- ORIG BUD REVISED BUD ACTUAL -------- -------------------------------------------- PROJECTION FIN REVIEW CHANGE TOTAL UTILITIES 3,857.43 4,800.00 4,800.00 3,750.43 4,800.00 4,800.00 .0% 56 OTHER EXPENSES 542010 5670 DEPR EXP 96,055.99 .00 .00 .00 .00 ..:00 .0% TOTAL OTHER EXPENSES 96,055.99 .00 .00 .00 .00 .00'. .0% 58 CAPITAL OUTLAY -------------------------------------------- 542010 5810 OP EQP .00 21000.00 2,000.00 2,052.00 4,200.00. 2,500.00 25.0% LOCATORS / CAMERA HEAD / CAMERA ACCESSORIES .TOTAL CAPITAL OUTLAY .00 2,000.00 2,000.00 2,052.00 4,200.00 2,500.00 25.0% 72 TRANSFERS OUT (IFT) r -------------------------------------------- 542010 7211 TRANS VERF 37,726.00 47,729.00 47,729.00 .00 47,729.00 50,929:00 6.7% -TOTAL TRANSFERS OUT (IFT) 37,726:00 47,729.00 47,729.00 .00 47,729:00 50,929.00_ 6.7 %- TOTAL SEWER ADMINISTRATION 446,616.31 448,859.00 448,859.00 309,627.41 421,.279.00 478,854.00 6.7% 03/22/2006 VILLAGE OF DEERFIELD- 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 PROJECTION: 20071 FY.2006/07 MASTER BUDGET PROJECTION PG 56 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 .2006 2006 2007 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL. PROJECTION FIN REVIEW CHANGE ------------------------------------------------------------------------------------=---=---------=--------------------------- - - - - -- 542031 SEWER LINE CONSTRUCTION 51 PERSONNEL SERVICES 159,000.00 -------------------------------------------- 542031 5110 REG SALAR 132,667.62 145,000.00 4,092.25 TWO EMPLOYEES 5,500.00 542031 5111 PT SALARY 5,426.00 5,000.00 7;000.00 SEASONAL HELP (2) .0% 542031 5112 OT SALARY 6,357.74 7,000.00 35,000.00 INCREASE IN OVERTIME DUE TO INFRASTRUCTURE FAILURE 542031 5120 MED.BNFT 23,615.05 29,400.00 542031 5121 DNTL BNFT 2,101.68 3;080.00 542031 5122 MISC BNFT 463.03 500.00 542031 5130 APPAREL - 562.92 .00 542031 5140 PEN CNTRB 23,639.00 36,400.00 TOTAL PERSONNEL SERVICES 193,707.20 226,380.00 53 CONTRACTUAL SERVICES 226,380.00 -------------------------------------------- 542031 5310 RENT EQP 2,921.65 5,000.00 13.8% EXCAVATING MACHINES FOR USE IN RESTRICTED LOCATIONS 5,000.00 TOOLS, AND SAWS/ PUMPS, TRENCHERS, HYDRALIC PIPE PUSHERS 542031 5321 STRUC R&M 2,495.11 14,000.00 14,000.00 _ OUTSIDE CONTRACTORS FOR SEWER REPAIRS 9,000.00 5,052.15 EMERGENCY SEWER REPAIR 9,000.00 542031 5322• EQUP R&M. 10,916.39 9,000.00 16,500.00 REPAIRING PUMPS AND GENERATORS 9.1% 542031 5326 VEH MAINT 22,051.10 16,500.00 260,000.00 MAINTENANCE ON 601/705/709/702 .00 542031 5362 P/S ENG .00 285,000.00 .0% 2005/06 ' INFLOW AND INFILTRATION STUDY $50',000 19,713.00 86,650.00 2006/07. INFLOW AND INFILTRATION STUDY $260,000 6,555.00 2007/08 PINE/ HACKBERRY SANITARY SEWER REPLACEMENT- 8,000..00 $40,000 ENG, / / /CONSTR= $200,000 542031 5390 OTHER 237.50 .00 TOTAL CONTRACTUAL SERVICES 38,621.75 329,500.00 54 COMMODITIES -------------------------------------------- 542031 5420 PETR PROD 6,268.20 6,555.00 542031 5421 MATERIAL 49,575.98 70,000.00 PURCHASING PRECAST CONCRETE $7,000 PVC PIPE & MISSION COUPLINGS $17,000 PLOWABLE FILL $10,000 / GRAVEL $2,000 /.CONCRETE $10,000 BLACKTOP $10,000 / FRAMES & COVERS $6,000 / BRICKS $3,000 ADJUSTING RINGS $3,000 / WATER PLUG $2,000 145, "000.00 130,896.78 159,000.00 168,000.00 15.9% 5,000.00 4,092.25 5,000.00 5,500.00 10.0% 7,000.00 .2,596.12. . 7;000.00 7,000.00 .0% 29,400.00 24,883.00 29,400.00 35,000.00 .19.0% 3,080.00 2,091.44 3,060.00 2,800.00 -9.1% 500.00 413.44 .500.00 500.00 .0% .00 - 308.94 .00 2,500.00 .0% 36,400.00 23;494.93 36,400.00 36,400.00 .0% 226,380.00 188,159.02 240,360.00 257,700.00 13.8% 5,000.00 1,911.70 5,000.00 5,000.00 14,000.00 2,879.90 6,000.00 14,000.00 _ .0% 9,000.00 5,052.15 ...9,000 .0,0 9,000.00 .0% 16,500.00 9,719.25 16,500.00 18,000.00 9.1% 285,000.00 .00 50,000.00 260,000.00 -8.8% .00 150.00 150.00 .00 .0% 329,500.00 19,713.00 86,650.00 306,000.00 -7.1% 6,555.00 00 8,000..00 8,500.00 29.7% 70,000.00 45,053..90 70,000.00 70,000.00 .0% 03/22/2006 VILLAGE OF DEERFIELD PG 57 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ------------------------------------------------------------------------------------------.------------------------------------------ 542031 5440 SMTLSEQUP 116.25 1,000.00 1,000.00 144.11 1,00.0.00 1,000.00 .0% HAND TOOLS SUCH AS SHOVELS / PICKS / SCREWDRIVERS 542031 5460 OPER SUPP 1,188.50 ]:,200.00 1,200.00 698.15 1,200.00 1,200.00 .0% TOTAL COMMODITIES 57,148.93 78,755.00 78,755.00 45,896.16 80,200.00 80,700:00 2.5% 59 CAPITAL IMPROVEMENTS -------------------------------------- - - - - -- 542031 5940 SANSWR IMP .00 1,780,000.00 1,780,000.00 154,098.28 200,000.00 9.35,000.00 -4-7.5%. SEWER LINING VARIOUS LOCATIONS - $100,000 INCREASE TO $140,000 IN 06/07 AND $20,000 EVERY YEAR AFTER. REPLACEMENT OF SEWER UNDER CREEK FROM PINE TO WRF 07/08 CONSTR. $200,000 + 07/08 $40,000 FOR ENGINERING IN -CODE 5362 WARWICK RD. STORM STATION - $185,000 y 06/07 - $ 15,000 07/08 - $ 170,000 DEERFIELD RD. LIFT & STORM STATION - $165,000 06/07 - $ 15,000 07/08 - $ 150,000 DEERBROOK LIFT STATION REPLACE. - $265000 NORTH AVE. LIFT STATION REPLACE. - $375000 EAST SIDE LIFT STATION REHAB. - $640000 06/07 - $ 110,000 07/08 - $ 530,000 PFINGSTON RD. LIFT STATION $35,000 06/07 - $ 5,000 07/08 --$ 30,000 WILMOT RD. LIFT STATION 80,000 06/07 - $ 10,000 07/08 - .$ 70,000 TOTAL CAPITAL IMPROVEMENTS .00 1,780,000.00 1,.780,000.00 154,098.28 200,000:00 935,000.00 -47.5% TOTAL SEWER LINE CONSTRUCTIO 289,477.88 2,414,635.00 2,414,635.00 407,866.46 .607,230.00 1,579,400.00 - 34.6°% 03/22/2006 VILLAGE OF DEERFIELD PG 58 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/01 bgnyrpts PROJECTION: 2007.1 FY 2006 /07 MASTER BUDGET PROJECTION FOR.PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006' 2006 2007 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ----------------------------------------------------------------------------------- - - - - -- ------------------------------------------ 542051 SEWER CLEANING 51 PERSONNEL SERVICES -------------------------------------------- 542051 5110 REG SALAR 99,911.45 100,000.00 100,000.00 94,263.35 101,000.00 115,000.00 15.0% THREE EMPLOYEES / VARIOUS LEVELS 542051 5111 PT SALARY 1,536.00 9,000.00 9,000.00 2,192.00 6,000.00 9,000.00 .0% SEASONAL HELP 542051 5112 OT SALARY 7,998.42 15,600.00 15,600.00 4,519.98 8,000.00. 15,600.00 .0% 542051 5120 MED BNFT 19,724.08 22,200.00 22,200.00 18,055:-78 22,200.00 27,750.00 25.0% 542051 5121 DNTL BNFT 1,883.12 2,300.00 2,300.00 1,480.78 2,.300.00 1,900.00 -17.4% 542051 5122 MISC BNFT 328.42 500.00 500.00 312.42 500.00 500.00 .0% 542051 5140 PEN CNTRB 18,487.52 20,000.00 20,000.00 17,564.74 18;500.00 20,500.00 2.50 TOTAL PERSONNEL SERVICES 149,869.01 169,600.00 169,600.00 138,389.05 158,500.00. 190,250.00 12.2% 53 CONTRACTUAL SERVICES -------------------------------------------- 542051 5310 RENT EQP 00 4,000.00 4,000.00 .00 2,000.00 4,000..00 .0% RENTAL OF REMOTE CLEANING EQUIPMENT / EXCAVATORS / SAWS 542051 5322 EQUP R&M 2,304.00 6,000.00 6,000.00 74.78 ...4, 00.0.00 6,000.00 .0% REPAIR ROOT CUTTERS / PURCHASE OF HIGH PRESSURE HOSE / CUTTING BLADES 542051 5326 VEH MAINT 5,486.50 11,000.00 11,000.00 2,397:00 11,000.00 11,000.00 .0 %. REPAIRING 702 542051 5365 P/S OTHER 11,674.17 24,000.00 24,000.00 3,050.00 18,000.00 24,000_.00 .0% CONTRACTING FOR SEWER CLEANING AND TELEVISING BEYOND OUR CAPABILITIES 1/3 OF $3065 FOR WEATHER SERVICE UNION DRAINAGE DISTRICT ASSESSMENT.FOR RESERVOIR 29 - $1,000 TOTAL CONTRACTUAL SERVICES 19,464.67 45,000.00 45,000.00 5,521.78 35,000.00 45,000.00 .0% 54 COMMODITIES -------------------------------------------- 542051 5410 MISC SUPP 2,694.76 2,500.00 2,500.00 1,105.47 2,.500.00 2,500.00 0% WATER JET LEADER HOSE / UTILITY TOOLS SAFETY EQUIPMENT 542051 PETR PROD 992.36 2,185.00 2,185.00 1,110.53 2,300.00 2,500.00 14.4% 542051 .5420 5421 MATERIAL 9,401.74 15,000.00 15,000.00 6,734.60 151000.00- 15,000.00 .0% AGGREGATE / FLOWABLE FILL / BLACKTOP / $1,000 MISSION COUPLINGS $3,000 / CONCRETE $900 BLACK DIRT $3000 / SEED $1,000 03/22/2006 VILLAGE OF DEERFIELD PG 59 12:28. RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007, PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE =-------------------------------------------------------------------=---------------------------------------------------=----------- 542051 5440 SMTLSEQUP 292.67 3,200.00 .3,200.00 00 1,600.00 3,200.00. .0% HAND TOOLS / SOCKET SETS / SCREW DRIVERS/ - SMALL COMPACTOR - $2,600 542051 5460 OPER SUPP 2,450.72 7,000.00 .7,000.00 2,853.57 3,500.00 .7,000.00 06 SEWER.DYE, SMOKE BOMBS, REBAR, ROOT CUTTING BLADES CHEMICALS, LUMBER 542051 5470 R&M SUPP 3,817.64 10,000.00 10,000.00 1,856.00 6,000.00 10,000.00 .0% WATER JET HOSE / VAC HOSE / WATER PLUG ROOT CUTTERS / SLEEVES / MISC SUPPLIES TOTAL COMMODITIES 19,649.89 39,885.00 39,885.00 13,660.17 30,900.00 40,200.00 .8% 5B CAPITAL OUTLAY 542051 5810 OP EQP .00 30,000.00 30,000.00 251464.20 30,000.00 .00 - 100.06 542051 5850 MBL EQP 37,966.00 .00 .00 .00 ..00 .00 .0% TOTAL CAPITAL OUTLAY 37,966.00 30,000.00 30,000.00 25,464.20 30,000.00 .00 - 100.0%' TOTAL SEWER CLEANING 226,949.57 2B4,465.00 284,465.00 .183,035.20 25.4,400.00 275,450.00 -3.2% 03/22/2006 VILLAGE OF DEERFIELD 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION PG 60 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT _ SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN,REVIEW CHANGE --------------------------------------------------------=-------------------------------------------- -------- --=-------------- - - - - -- 542052 WASTEWATER TREATMENT FACILITY 51 PERSONNEL SERVICES -------------------------------------------- 542052 5110 REG SALAR 435,165.32 585,000.00 585,000.00 415,530.27 520,00.0.00 595,000:.00 1.7% FOREMAN, LAB DIRECTOR, MAINTENANCE CHIEF, MAINTENANCE ASST., SENIOR OPERATORS, TWO OPERATORS, ONE OPERATOR TRAINEE. .1/4 DIRECTOR 542052 5111 PT SALARY 8,088.00 10,000.00 '10,000.00- 7,976.00 :10,000.00 12,00.0.00 20.0% Request two part time people in summer and two people for winter break. Need to raise budget to accomdate positions for summer and winter. 542052 5112 OT SALARY 21,893.17 24,000.00 .24,000.00 17,322.88 19,000.00 25,000,.00 '4.2% Increased overtime budget to account for COLA. INCREASE OVERTIME BUDGET FOR UNION ON -CALL SUPPLEMENT. 542052 5120 MED BNFT 85,445.49 125,000.00 125,000.00 94,205.99': 105,000.00 130,000:00 4.0% ADDED 12,000 FOR ADDITIONAL PERSON REQUESTED.IN 05/06 542052 5121 DNTL BNFT 8,265.31 12,200.00 12,200.00 8,021.36 8,90.0.00 9,500..00 542052 5122 MISC BNFT 2,218.73 2;500.00 2,500.00 1.,686.47 2,500.00 2,500.00 .0% 542052 .5130 APPAREL 2,617.39 6,700.00 6,700.00 3,927.76 6,700.00 7,000.00 4.5% APPAREL: CLOTHING, BOOTS, JACKETS ($500.00 PERSON $4000.00 TOTAL: SAFETY APPAREL($300.00 person ) X 8 $2,400.00 TOTAL. ROUND UP TO $7000.00 INCLUDES VESTS, GLOVES, HARD HATS, GOGGLES, RAIN SUITS AND FIREMEN'S BOOTS. 542052 5140 PEN CNTRB 76,355.74 110,000.00 110,000.00 74.,637.08 85,000.00 105,000.00 -4.5% TOTAL PERSONNEL SERVICES 640,049.15 875,400.00 875,400.00 623,307.81 757,100..00 886,000.00 1.2116 52 TRAINING & DEVELOPME -------------------------------------------- 542052 5210 TRNG REG .00 .00 .00 .00.- .00 500:00 .0% $250 FOR FOREMAN AND $250 FOR DIRECTOR 542052 5211 TRNG TRAV 95.00 3,000.00 3,000.00 1,118.77 3,000.00 3,500.00 16.7% INCREASE IN TRAINING DUE TO NEW EMPLOYEE 542052 5213 SUBSCRIPT 36.56 500.00 500.00 .00 ..500.00 500.00. .0% TOTAL TRAINING & DEVELOPME 131.56 3,500.00 3,500.00 1,118.77. .3,500.00 4,500.00 28.6% 53 CONTRACTUAL SERVICES -------------------------------------------- 542052 5310 RENT EQP 641.04 9,500.00 9,500.00- 1,816.75 9,500.00 10,000.00 5.3% .Crane Rental EMERGENCY PUMP RENTAL EMERGENCY GENERATOR RENTAL 03/22/2006 VILLAGE OF DEERFIELD 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION PG 61 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 542052 5320 BLDG R&M 8,416.27 21,000.00 21,000.00 00 12,000.00 30,000.00. 42.9% CLEANING SERVICE - $1;000 NEW ROOF & TUCKPOINTING - $20,000 542052.: 5322 EQUP R&M 89,591.52 68,500.00 68,500.00 32,545.13 50,000.00 70,000.00 2.2% Electrical," Mechanical. PUMP REPAIR 542052 5326 VEH MAINT 4,442.50 9,900.00 9,900.00 5,062.50 9,900.00 .10,500.00 6.10 542052 5330 DUES .00 300.00 300.00 97.00. 3.00.00 650.00 .116.7% WATER ENVIRONMENT FEDERATION DUES ADD $50.00 FOR DIRECTOR NIPSTA MEMBERSHIP $250 542052 5332 TRAV EXP 3,729.42 3,000.00 3,000.00 50.00 1,500.00 3,100.00 3.3% INCREASE $100.00 FOR DIRECTOR COMMERCIAL DRIVERS LICENSES 542052 5335 PRINTING .00 200.00 200.00 9.8.41 200.00 200.00 .0% Bids and Reports. 542052 5362 P/S ENG 89,938.51 305,000.00 305,000.00 13,852.13 100,000.00 175,000.00 - 42.6°% NEW PERMIT REQ'S ASSISTANCE $10,000 TRAVELING BRIDGE ENGINEERING $55,000.00 DISSOLVED OXYGEN ENGINEERING $15,000.00 ANAEROBIC DIGESTER COVER #3 ENGINEERING $75,000.00 LAB WORK, MONITORING WELLS 29A RESERVOIR $20,000.00 542052 5363 P/S MEDIC .00 1,200.00. 1,200.00 606:00 1,200.00 1,300.00 8.3% P/S MEDIC.$750.00 DRUG & ALCOHOL TESTING ($90.00PERSON /YR) $450.00 PREEMPLOYMENT TESTING INCREASE 105.COSTS BY 5% 542052 5365 P/S OTHER .00 49,000.00 49,000.00 31,794.26 49,000.00 50,000.00 2.0% YEARLY SLUDGE HAULING - $40,000 542052 5370 DP SERV 77.41 600.00_ 600.00 .00 600.0.0 600.00. 0% Updates and replacements 542052 5390 OTHER .00 20,000.00 20,000.00 16,500 ".00 20,000.00 23,000.00 15.0% MOVED.TO 5611 PAYMENTS TO OTHER GOVERNMENT AGENCIES TOTAL CONTRACTUAL SERVICES 196,836.67 488,200.00 .4.88,200.00 102,422.18 254,200.00 374,350:00 -23.3% 54 COMMODITIES -------------------------------------------- 542052 5410 MISC SUPP 4,012.49 5,500.00 5,500.00 4,69.8.60 5,500.00 5,750.00 4.516 Safety Equipment. 542052 5420 PETR PROD. 10,806.27 16,100.00 16,100.00 5,903.38 16,100.00 16,100.00 .0% 03/22/2006 VILLAGE OF DEERFIELD PG 62 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 .2006 2007 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ------------------------------------------------------------------------------------------------------------------------------------ 542052 5421 MATERIAL 9,014.45 40,000.00 40,000.00 6,261.75 30,000.00 40,000.00 .0% Sand Bed Sand $8,000.00, Piping $11,000 ".00 Valves 11,000.00 Packing & Grease $2,000.00 Misc $8,000.00. 542052 5422 CHEMICAL 35,601.64 60,000.00- 60,000.00 19.,483.42 40,000 .00 60,000.00 .0% Increase costs for Sodium Hypochlorite this year. Sodium Bisulfite (dechlorination) and Degreaser (for maintenance) DIGEST.AID:FOR GREASE REMOVAL AT LIFT STATIONS & W.R.F. DEODORANT AT W.R.F. AND LIFT STATIONS. 542052 5440 SMTLSEQUP 704.61 1,500.00 11500.00 1,119.70 1 ,500.00 2,000:00 33.30 Increase amount needed for this account for small tools for the maintenance shop. Sludge Forks, Shovels, Rakes for Sludge Bed.Work. 542052 5450 OFF SUPP 266.64 600.00 600.00 414.65 600.00 600.00 :0 °s Fax paper, pens, printer ink, pens, notebooks. 542052 "5460 OPER SUPP 14,086.35 19,000.00 19,000.00 ." 10,177.41 19,000.00 19,00.0.00 .0% Laboratory Supplies, rain gauge. 542052 5470 R&M SUPP 16,869.58 20,000.00 20,000.00 7,950.68 15;000.00 20,000.06 0% Raised $1000 for increased costs for these items. TOTAL COMMODITIES 91,362.09 162,700.00 162,70,0.00 56,009.59 127,700.00 163,450.00 5% 55 UTILITIES . -------------------------------------- 542052 - - - - -- 5510 U/E ELECT 163,665.81 160,000.00 160,000.00 113,185.18 135,000.00 170,000.00 6.3% 542052 5520 U/E NAT GA 39,726.89 45,000.00 45,000.00 40,938.19 45,000.00 53,000.00 17.80 Increased.costs for natural gas. 542052 5530 U/E WATER "5,552.70 10,000.00 10,000.00 2,382.76 8;500".00" 10,000.00 .0% 542052 5540 U/E TELEPH 12,698.93 14,500.00 14,500.00. 10,;806.83 " 14,500.00 15,060.00 3.4% Nextel,"Alarms, Telemetry. NEW EMPLOYEE PHONE" TOTAL UTILITIES 221,644.33 229,500.00 229,500.00 167,312.96 203,000.00 248,000:00 8.1% 56 OTHER EXPENSES -------------------------------------------- 542052 5611 PMTS OTHR .00 .00 .00 . "00 .00 23,000.00 :0% TRANSFER FROM 5390 "OTHER" STATE PERMIT CHARGE FOR TREATMENT PLANT DISCHAGE SLUDGE HAULING PERMIT FEE STATE FIRE MARSHALL INSPECTION FEE . MISC GOVERNMENT FEE 03/22/2006' VILLAGE OF DEERFIELD 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION PG 63 bgnyrpts FOR PERIOD 13 ACCOUNTS FOR:. 2005 2006 2006 2006 2006 2007 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE ---------------------------------------------------------------------------------------------------------------=-------------- -- - - -- TOTAL OTHER EXPENSES .00 .00 .00 58 CAPITAL OUTLAY 542052 5810 OP EQP 11,552.53 13,000.00 13,000.00 BOBCAT FOR SLUDGE BED:WORK $55.,000.00 (TRANSFERRED TO VERN TRAILER -TO TRANSPORT RIDING LAWNMOWER TO STATIONS.$3000.00 LAB -METER FOR TESTING PHOSPHOROUS AND NITROGEN $7,000.00 MEGGAR METER (ELECTRICAL) FOR MAINTENANCE $1000.00 4" TRASH PUMP (REPLACEMENT) & HOSES $3500.00 SELF CONTAINED BREATHING APPARATUS $12000 (4 SETS) TOTAL CAPITAL OUTLAY 11,552.53 13,000.00 13,000.00 59 CAPITAL•IMPROVEMENTS -------------------------------------------- 542052 5941 STP IMP 282,,863.22 660,000.00 MAIN CONTROL BLD.. ELECT. (CONST.) $75,000.00 TRAVELING BRIDGE (CONST.) $345,000.00 MOVE BRIDGE CONSTRUCTION TO 06/07 (- $345,000) SPILLWAY & DISSOLVED OXYGEN IMP. $75,000.00 DEODORIZING EQUIPT. $5,000.00 DEEP GRINDER $30,000.00 DEFER GRINDER, PURCHASE PACK FOR $5,000 WHEN NEEDED (- $25,000) DIGESTER BASEMENT VALVES $25,000.00 DIGESTER #3.COVER REPLACEMENT (WITH SLUDGE REMOVAL) IS $525,000.00 MOVE DIGESTER CONSTRUCTION TO 06/07 (- $525,000) TOTAL CAPITAL IMPROVEMENTS 282,863.22 .660,000.00 72 TRANSFERS OUT (IFT) 542052 7211 TRANS VERF 8,907.00 9,342.00 TOTAL TRANSFERS OUT (IFT) 8,907.00 9,342.00 TOTAL WASTEWATER TREATMENT F 1,453,346.55 2,441,642.00 TOTAL SEWER FUND 2,416,390.31 5,589,621.0.0 660,000.00 660,000.00 .00 2,256.72 2,256.72 121,863..42 121,863.42 9,342.00 .00 9,342.00 .00 2,441,642.00 1,074,291.45 5,589,621.00 .1,974,820.52 00 23,000.00 .0% 13.,000.00 26,500.00 103.8 %. 13,000.00 26,500.00 103.8% 110,000.00 185;000.00 -72.0% 110,000.00 185,000.00 -72.0% 9,342.00 11,867.00 27.0% 9,342.00 11,867.00 27.0% 1,477,,842.00 1,922,667.00 -21.39,; 2,760,751.00 4,256,371.00 -23.9% 03/22/2006 VILLAGE OF DEERFIELD PG 64 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007. PCT REFUSE FUND -------------"--------------------------------------------------------------------------------=-------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 582030 REFUSE COLLECTION 53 CONTRACTUAL SERVICES -------------------------------------------- 582030 5311 PROP RENT 21,000.00 21,000.00 21,000.00 .00 21,000.00 21,000.00 .0% 582030 5337 POSTAGE 811.02 2,400.00 2,400.00 685.35 2,000.00 2,200:00 -8.3% 582030 5350 INS GL 3,460.19 4,095.00 4,095.00 3,703:66 4;095.00 4,709..25 15.0% 582030 5390 OTHER 990.88 10,000.00 10,000.00 2,325.91 6,000.00 9,00.0.00 -10.0% 582030 5391 REF COLCT 1,255,882.70 1,440,000.00 1,440,000.00 1,055,937.69 1, 400, 0.00. 0.0 1,484,300..00. 3.1% INCREASES DUE TO NEW CONTRACT -. $117,000 FOR NEW RECYCLING CARTS $24,000 FOR CPI INCREASE TOTAL CONTRACTUAL - SERVICES 1,282,144.79 1,477,495.00 1,477,495.00 1,062,652..61 1',433,095.00 1,521,209:25 3.0% 54 COMMODITIES --------------------------------------------- 582030 5410 MISC SUPP 3,200.00 4,000.00 4,000.00 1,600.00 4,000.00 4;000..00. .0% TOTAL COMMODITIES 3,200.00 4,'000.00 4,000.00 1;600.00 4,000.00 4,000.00 0% TOTAL REFUSE COLLECTION 1,285,344.79 1,481,495.00. 1,481,495.00 1,064,252.61 1,437,095.00 1,525,209.25 3.0% 03/22/2006 VILLAGE OF DEERFIELD 12:28 RWF EXPENDITURE BUDGET REQUEST.- FY 2006/07 PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION PG 65 bgnyrpts FOR PERIOD 13 ACCOUNTS-FOR: 2005 2006 2006 2006 2006 2007 PCT REFUSE FUND ------------ ------------------- ------------------------------ ACTUAL. ORIG BUD =---------------------------------------- REVISED BUD ACTUAL PROJECTION =-=--------------------------- FIN REVIEW CHANGE 582053 REFUSE LEAF COLLECTION -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 582053 5110 REG SALAR 34,036.38 52,000.00 52,000.00 32,347.88 34,000.00 45,000..00 -13.5% DECREASE.TO REFLECT ACTUAL HISTORY 582053. 5111 PT SALARY 5,075.00 8,000.00 8,000.00 4,301.00 5,000.00 _ 8,000.00 .0% 4 part time hires for 4 weeks a at least $10 /hr. 582053 5112 OT SALARY 14,316.49 18,700.00 18,700.00 12,907.40 13.,000.00 14,500.00 -22.5% DECREASE TO REFLECT ACTUAL HISTORY 582053 5120 MED BNFT 8,362.79 11,550.00 11,550.00 9,036.97 11,550.00 15,000.00 29.9% 582053 5121 DNTL BNFT 786.14 1,100.00 1,100.00 746.29 1,100.00 1,500..00 36.40 582053 5122 MISC BNFT 135.99 500.00 500..00 123.55 500.00 500.00 .0% 582053 5140 PEN CNTRB 8,288.69 17,200.00 17,200.00 .7,973.24 11,000.00 17,200.00 .0% TOTAL PERSONNEL SERVICES 71,001.48 109,050.00 109,050.00. 67,436.33. 761150.00 101,700.00 -6.70 53 CONTRACTUAL SERVICES -------------------------------------------- 582053 5310 RENT EQP .00 5,000.00 5,000.00 .00 500.00 7,500:00 50.0% Rental street sweeper for after last leaf pickup Increase by $2,500 582053 .5322 EQUP R&M 20,079.40 21,000.00 21,000.00 14;355.00 15,000:00 21,000.00 0% Repairs and maintenance of leaf machines and equipment 582053 5326 VEH MAINT 977.50 10,000.00 10,000.00 761.00 11000.00 3,000.00 -70.0% Repairs and maintence of vehicles used for leaf removal 4 trucks, sweeper and front -end loader TOTAL CONTRACTUAL SERVICES 21,056.90 36,000.00 36,000.00 15,116.Ob. 16,500.00 31,500.00 -12.5% 54 COMMODITIES 582053 5420 PETR PROD 3,783.24 4,100.00 4,100.00 .00 4,500.00 5,000.00 22.0% Fuel used for leaf removal 582053 5460 OPER SUPP 10.00 300.00 300.00 102.34 300.00 300.00 .016 Rakes, shovels, ear plugs, face masks, safety glasses and safety goggles TOTAL COMMODITIES 3,793.24 4,400.00 4,400.00 102.34 . 4,800.00 5,300.00 20.50 72 TRANSFERS OUT (IFT) -------------------------------------------- 582053 7211 TRANS VERF 10,250.00 10,775.00 10,775.00 .00. 10,775.00 10,775.00 .0% .03/22/2006 VILLAGE OF DEERFIELD PG 66 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT REFUSE FUND --------------------------------=----- ACTUAL --- ------------------------------------------------.:- ORIG BUD REVISED BUD ACTUAL --- --------------------------------------.-- PROJECTION FIN REVIEW CHANGE TOTAL TRANSFERS OUT (IFT) 10,250.00 10,775.00 10,775.00 .00 10,775.00 10,775.00 .0% TOTAL REFUSE LEAF COLLECTION 106,101.62 160;225.00 .160,225.00 .82,654.67 108,225.00 149,275:00" -6.80 TOTAL REFUSE FUND 1,391,446.41 1,641,720.00 1,641,720.00 1,146,907.28 1,545,320.00 1,674,484.25 2.0% 03/22/2006 VILLAGE OF DEERFIELD PG 67 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT COMMUTER PARKING FUND ---------------- -------------------------------------------- ACTUAL ORIG BUD ----------------------------------------------- REVISED BUD ACTUAL PROJECTION ------------------------- FIN REVIEW CHANGE 602019 COMM PARK COMBINED FUNDING -------------------------------- ------------ 51 PERSONNEL SERVICES -----=--------------=----------------------- 602019 5110 REG SALAR 9,910.30 12,600.00. 12,600.00 8,649.41 111000.00 12,600.00 .0% 602019 5120 MED BNFT 694.56 2,330.00 2,330.00 676:61 1,500.00 2,330.00 0% 602019 5121 DNTL BNFT 95.59 250.00 250.00 85.16 .250.00 250.00 .0% 602019 5122 MISC BNFT 34.45 100.00 100.00 30.71. 100.00 100.00 .0% 602019 5140 PEN CNTRB 1,657.03 2,200.00 2,200.00 1,53.7.76. 2,200.00 2,400.00 9.19. TOTAL PERSONNEL SERVICES 12,391.93 11,480.00 - 17,480.00 10,979.65 15,050.00 17,680.00 1.1% 53 CONTRACTUAL SERVICES -------------------------------------------- 602019 5311 PROP RENT 7,440.00 7,500.00 7,500.00 .00 7,500.00 7,500.00 .0% 602019 5320 BLDG R&M .00 2,000.00 2,000.00 1,138.00 .2,000.00 3,000.00 50.0% 602019 5322 EQUP R&M .00 1,000.00 1,000.00. .00 500.00 1,000.00 .0% 602019 5350 INS GL 523.46 619.50 619.50 1,060.72 1,100.00 2,200.00 255.1% . 602019 5390. OTHER 14,550.00 20,000.00 20,000.00 13',650.00 20,000.00 20,000.00 .0% TOTAL CONTRACTUAL SERVICES 22,513.46 31,119.50 31,119.50 15,848.72 31,100.00 33,700.00 8.3% 54 COMMODITIES -------------------------------------=------ 602019 5410 MISC SUPP 63.17 200.00 200.00 25.40 200..00 200.00 .0% 602019 5421 MATERIAL .00 5,200.00 5,200.00. 225.00 1,500.00 5,200..00 .0% 602019 5460 OPER SUPP 46.00 300.00 300.00 .00 300.00 300.00 .0% 602019 5470 R&M SUPP 6.03 100.00 100..00 .00 100.00, 100.00. .0% TOTAL COMMODITIES 115.20 5,800.00 5,800.00 250.40 2,100.00 5,800.00 .0% 55 UTILITIES -------------------------------------------- 602019 5510 U/E ELECT 2,228.97 4,500.00 4,500.00 1,637.08 2,500.00 4,000.00 -11.1% TOTAL UTILITIES 2,228.97 4,500.00 4,500.00 1,637.08 2,500.00. 4,000.00 -11.1% 58 CAPITAL OUTLAY -------------------------------------------- 602019 5810 OP EQP .00 1,000.00 1,000.00 .00. 500.00' 1,000.00 .0% TOTAL CAPITAL OUTLAY .00 1,000..00 1,000.00 ..00_ 500.00: 1,000.00 .0% 72 TRANSFERS OUT (IFT) -------------------------------------------- 602019 7210 TRNSFR OUT 62,500.00 65,000.00 65,000.00 .00 65,000.00 65,000..00 .0% 03/22/2006 VILLAGE OF DEERFIELD PG 68 w 12:28 RWFf EXPENDITURE BUDGET REQUEST-- FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT COMMUTER PARKING FUND --------------------------------------------------------- ACTUAL ORIG BUD -.--------- REVISED BUD ACTUAL =--------------------------------- PROJECTION 7 ------------------------------ FIN REVIEW CHANGE TOTAL TRANSFERS OUT-(IFT) 62,500.00 65, 000.00 65,000.00 .00 651000.00 65,000.00 .0% TOTAL COMM PARK COMBINED FUN 99,749.56 124,899.50 124,899.50 28,715.85 - 116,250.00 127,180.00 1.8% 03/22/2006 VILLAGE OF DEERFIELD PG 69. 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13, ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT COMMUTER PARKING.FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN.REVIEW CHANGE 602038 COMM PARK VILLAGE OWNED' - - -- -- - ------------------------- 51 PERSONNEL SERVICES 602038 5110 REG SALAR 9,910.30 12,320.00 12,.320.00 9,109:.52 11,000.00 12,320.00 .0% 602038 5112 OT SALARY .00 .00 .00 1,208.69 1,500.00 1,500.00 .0% 602038 5120 MED BNFT 694.56 2,330.00 2,330.00 1,021.01 1,700.00 2,330.00 0% 602038 5121 DNTL BNFT 95.59 250.00 250.00 115:19 250:00 250.00 .0% 602038 5122 MISC BNFT 34.45 100.00 100.00 35.34 .100.00 100.00. 0% 602038 5140 PEN CNTRB 1,657.03 2,200.00 2,200.00 1,812.58 2,.200.00 2,400.00 9.1% - TOTAL PERSONNEL SERVICES 12,391.93 17,200.00 17,200:00 13,302.33 16,750.90 18,900.00 9.9% 53 CONTRACTUAL SERVICES -------------------------------------------- 602038 5322 EQUP R&M 1,002.50 4,000.00 4,000.00 .00 2,000:00 4,000.00 .0% $2000 for viaduct and pedestrian bridge maintenance 602038 5350 INS GL 523.46 619.50 619.50 1,060.72 1,200.00 2,200.00 255.1% 602038 5390 OTHER 14,550.00 25,000.00 25,000.00 .13.,650.00 18,,000.00 25,000.00 .0 %. $5000 for contractual viaduct and pedestrian bridge maintenance TOTAL CONTRACTUAL SERVICES 16,075.96 29,619.50 29,619.50 14,710..72 21,200..00' 31,200:00 5.3% 54 COMMODITIES. -------------------------------------------- 602038 5410 MISC SUPP .00 .00 .00 25.40 .00 .00 .0% 602038 5421 MATERIAL .00 3,100.00 3;100.00 311.28 1,500.00 3,100.00 .0% 602038 5460 OPER SUPP 43.75 200.00 200.00 .00 200'.00 200.00 .0% 602038 5470 R&M SUPP .00 200.00 200..00 7.00. 200.00 200'.00 .0% TOTAL COMMODITIES 43.75 3,500.00 3,500.00 343.68 1,900.00 3,500.00 .0% 55 UTILITIES -------------------------------------------- 602038 5510 U/E ELECT 4,752.07 5,800.00 5,800.00 3,,914.08 4,500:00. 5,800.00. .0% TOTAL UTILITIES 4,752.07 5,800.00 5,800.00 3,914.08 4,500.00 5,800.00 .0% 58 CAPITAL OUTLAY -------------------------------------- 602038 5810 OP EQP - - - - -- .00 1;000.00 1,000.00. .00 1,000.00 1,000.00 .0% TOTAL CAPITAL OUTLAY .00• 1,000.00- 1,000.00 .00 1,,0.00.00 1,000.00 .0% 72. TRANSFERS OUT (IFT) -------------------------------------------- 602038 7210 TRNSFR OUT 62,500.00 65,000.00 65,000.00' .00 65,000..00 65,000.00 .0% 03/22/2006 VILLAGE OF DEERFIELD PG 70- 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyi-pts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007. PCT COMMUTER PARKING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL .PROJECTION FIN REVIEW CHANGE TOTAL TRANSFERS OUT (IFT) 62,500.00 65,000.00 65,000.00 .00- 65,000.00 65,000.00 .0% TOTAL COMM PARK VILLAGE OWNE 95,763.71 122,119.50 122,119.50 32,270.81 110,350..00 125,400:00 2.7°6 TOTAL COMMUTER PARKING FUND 195,513.27 247,019.00 247,019.00 .60,986.66 226,600.00 252,580.00 2.3 °s 03/22/2006 VILLAGE OF DEERFIELD PG 71 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006, 2006 2006 2006. 2007 PCT GARAGE FUND ------------------------------------------------------------------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 702050 GARAGE FUND EXPENDITURES -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 102050 5110 REG SALAR 156,178.29 171,742.20 171,742.00 170,492:09 .171,742.20 160,000.00 -6.8% GARAGE FOREMAN AND MECHANIC 702050 5112 OT SALARY 7,954.20 10,120.00 10,120.00 .8,959.61 10,120.00 .11,000:00 8.7% 702050 5120 MED BNFT 20,790.42 29,650.00 29,650.00 20,181.27 29,650.00 32,615.00 10.0% 702050 5121 DNTL BNFT 2,348.46 3,150.00 3,150.00 2,145.03 3,150.00 .2,700.00 -14.30 702050 5122 MISC BNFT 478.79 600.00 600.00 - 441.64 600.00. 600.00 .0% 702050 5130 APPAREL 628.75 1,000.00" 1,000.00 822.75. 1,000.00' 1,100..00 10.0% 702050 5140 PEN CNTRB 26,457.84 32,600.00 32,600:00 29;203..40 32,600.00 34,000..00 4.3% TOTAL PERSONNEL SERVICES 214,836;75 248,862.20 248,862.00 232,245.79 248,862.20 242,015.00 -2.816 52 TRAINING & DEVELOPME -------------------------------------------- 702050 5210 TRNG REG .00 .00 .00 .00 .00 200.00 0% 702050 5211 TRNG TRAV .00 200.00 200.00 .00 .00 300.00 50.0% New employee will need training TOTAL TRAINING & DEVELOPME .00 200.00 200.00 ..00 .00 500..00 150.0% 53 CONTRACTUAL SERVICES -------------------------------------------- 702050 5322 EQUP R&M 750.00 5,000.00 5,000.00 125.58 2,500.00 5,000..00 .016 USED FOR REPAIR OF GARAGE EQUIPMENT AND HEATING 702050 5332 TRAV EXP 79.03 400.00 400.00 82.19 1100.00 400.00 .0% 702050 5335 PRINTING 401.31 400.00 400.00 .00. .00 400:00., 0% job sheet forms and business cards 702050 5350 INS GL 7,364.01 8,115.00 8,.715.00 7,882.16 8,715.:.00 10,022.25 15.0% TOTAL CONTRACTUAL SERVICES 8,594.35 14,515.00 14,515:00 8,089.93 11,315.00 15,822.25 9.01 54 COMMODITIES =------------------------------------------- 702050 5410 MISC SUPP 1,673.97 1,100.00 1,100.00 .2,580.80 1,900.00 1,500.00 36.4% Paper supplies, first aid supplies, consortium fee, etc. 702050 5420 PETR PROD 560.62 1,000.00 1,000.00. .00 1,000.00 1,000.00 .0% 702050 5421 MATERIAL 63.00 200.00 .200.00 233.02 300.00 300..00 50.0% 702050 5440 SMTLSEQUP 1,666.00 2,500.00 2,500..00 898.80 2.,0,00.00 4,000.00 60.0% upgrade sw diagnostic equipment, specialty tools for new equip + new employee tools 702050 5450 OFF SUPP .00 .00 .00 78.75 ..100.00 100.00 .0% 03/22/2006 VILLAGE OF DEERFIELD PG 72 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT GARAGE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW_ - - - CHANGE - -- - -_ ---------------------------_---------------------------------------------------------------------------------------------- 702050 5460 OPER SUPP - 6,322.50 300.00 300.00 .00 300.00 300.00 .Oo 702050 5470 R&M SUPP 67,893.76 70,452.00 70,452.00 56,213.59 70,452. -00 75.,000.00 6.516 TIRES, BATTERIES, PARTS-. 5% INCREASE REQUESTED DUE TO GENERAL INCREASES New variety of equip in fleet TOTAL COMMODITIES 65,534.85 75,552.00 75,552.00 60,004.96 76,052.00 82,200.00 8.8% 55 UTILITIES -------------------------------------------- 702050 5530 U/E WATER 1,423.02 2,000.00 2,000.00 2,224.97 2,500.00 2,500.00 _ 25.0% 702050 5540 U/E TELEPH 1,338.42 2,400.00 .2,400.00 .1,222.73 2,100.00 2,200.00 -8.3% TOTAL UTILITIES 2,761.44 4,400.00 4,400.00 3,447.70 .4,.600.00 4,700.00 6.8% 58 CAPITAL OUTLAY -------------------------------------------- 702050 5810 OP EQP 2,395.00 .00 .00 -.00 .00 :00 016 STARTER UNIT WAS A ONE TIME PURCHASE TOTAL CAPITAL OUTLAY 2,395.00 .00 00 .00 .00 '00 0% 72 TRANSFERS OUT (IFT) -------------------------------------------- 702050 7211 TRANS VERF 2,400.00 2,525.00 2,525.00 .00 2,525.00. 2,525.00 .0% TOTAL TRANSFERS OUT (IFT) 2,400.00 2,525.00 2,525.00 00 2,525.00 2,525.00 .0% TOTAL GARAGE FUND EXPENDITUR 296,522.39 346,054.20 346,054.00 303,788.38 343,354.20 347,762.25 .5% TOTAL GARAGE FUND 296,522.39 346,054.20 346,054.00 303-,788.38 343,354.20 347,762.25. 5% 03/22/2006 VILLAGE OF DEERFIELD PG 73 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006/07 bgnyrpts PROJECTION: 20071 FY 2006 /07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007 PCT INSURANCE FUND -------------------------------------------------------------------------7---------------------------------------------------------- ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION FIN REVIEW CHANGE 721111 INSURANCE EXPENSES -------------------------------------------- 56 OTHER EXPENSES 721111 5610 OTH EXPENS 245.77 1,000.00 1,000.00 450.00 1,.000.00 1,000.00 .0% 721111 5620 VIL MED PR 1,232,376.53 .00 .00 99,067.22 .00 ..00 .0% 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 35,504.99 .00 .00 .00 .00 .00 .0% 721111 5622 VIL LIF PR 24,094.70 .00 00 2,038.09 00 00 .0% 721111 5630 RT MED PR 173,617.16 147,150.00 147,150.00 164,683.13 147,150:00 261,900.00 78..0% INCREASE DUE TO GREATER RETIREE NUMBERS 721111 5631 RT DNT PR 5,078.19 8,690.00 8,690.00 15,317.21 8,690.00 8,690.00 .0% 721111 5640 LIB MED PR 206,055.12 .00 .00 16,642..87 .00 .00 .0% 721111 5641 LIB DNT PR 5,553.01 .00 .00 .00 .00 .00 .0% 721111 5642 LIB LIF PR 2,202.30 .00 .00 .185._37 :00 .00 .0°% 721111 5650 PKD MED PR 307,009.85 325,910.00 325,910.00 247,786.75 325,910:00 365,019.20 12.0°° %" 721111 -5651 PKD DNT PR 11,518.71 15,826.80 15,827.00 .32,512,.47 15;826.80 36,000:00 127.5°%. 721111 5652 PKD LIF PR 6,307.20 6,500.00 6,500.00 4,885.37 6,500.00 6,500.00 .09; TOTAL OTHER EXPENSES 2,009,563.53 505,076:80 505,077.00 583,568.48 505,076.80 679,109.20: 34.5% TOTAL INSURANCE EXPENSES 2,009,563.53 505,076.80 505,077.00 583,568.48 505,076:80 679,109.20 34.5% TOTAL INSURANCE FUND 2,009,563.53 505,076.80 505,077.00 583,568.48 505,076.8.0' 679,109.210 34.5% 03/22/2006 VILLAGE OF DEERFIELD PG 74 12:28 RWF EXPENDITURE BUDGET REQUEST - FY 2006107 bgnyrpts PROJECTION: 20071 FY.2006/07 MASTER BUDGET PROJECTION FOR PERIOD 13 ACCOUNTS FOR: 2005 2006 2006 2006 2006 2007. PCT POLICE PENSION FUND ----------------------------7-------------------------------------------------------------------------=------------------------------ ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION .FIN REVIEW CHANGE 806010 .POLICE PENSION FUND EXPENDITUR -------------------------------------------- 51 PERSONNEL SERVICES -------------------------------------------- 806010 5141 PEN PYMNT 1,124,911.47 1,248,000.00 1,248,000.00 1,067,975.20 1,248,000.00 1,372,800.00 10.0% 806010 5142 SEP REFND .00 15,000.00 15,000.00 .00 .00 15,000.00 . .0% TOTAL PERSONNEL SERVICES 1,124,911.47 1,263,000.00 1,263,000.00 1,067,975.20 11248,000:00 1,387,800.00 9.9% 53 CONTRACTUAL SERVICES -------------------------------------------- 806010 5330 DUES 750.00 1,500.00 1,500.00 750.00 750.00 1,500.00 .0% 806010 5332 TRAV EXP .00 500.00 500.00 .00 100.00 500.00 .0% 806010 5360 P/S CRP CN 3,945.95 5,000.00 5,000.00 4,952.72 6;000.00 5,00.0.00 .0% 806010 5365 P/S OTHER 1,567.50 1,000.00 1,000.00 4,859.45 5,000.00 1,000.00 .0% 806010 5369 TRUST FEES .00 1,500.00 1,500.00 213.23 1,500.00 1,750.00 16.7% 806010 5390 OTHER 3,877.05 2,500.00 2,500.00 3,877.05 4,.000.00 2,500.00 .0% TOTAL CONTRACTUAL SERVICES 10,140.50 12,000.00 12,000.00 14,652.45 17,350.00 12,250.00 2:1% 56 OTHER EXPENSES -------------------------------------------- 806010 5610 OTH EXPENS 1,324.61 .00 .00 :00 .00 .00 .0% TOTAL OTHER EXPENSES 1,324.61 .00 .00 .00 .00 .00 .0% TOTAL POLICE PENSION FUND EX 1,136,376.58 1,275,000.00 1,275,000.00 1,082,627.65 1,265,350.00, 1,400,050.00 9.8% TOTAL POLICE PENSION FUND 1,136,376.58 1,275,000.00 1,275,000.00 1,082,627.65.. 1,265,350.00 1,400,050:00 9.8% GRAND TOTAL 47,036,556.89 56,047,119.10 56,047,120.00 34,671,833.37 45,343'1'699.60 47,950,085.40 - 14.4% ** END OF REPORT - GENERATED BY BOB FIALKOWSKI ** DEERFIELD PUBLIC LIBRARY FY 2007 BUDGET GENERAL FUND FY 2006 FY 2007 BUDGET BUDGET CAPITAL EXPENDITURES EQUIPMENT 15,000 25,000 STRUCTURE 100,000 100,000 RESERVE FUND MAINTENANCE 250,000 250,000 TOTAL CAPITAL EXPENDITURES 365,000 375,000 TOTAL EXPENDITURES 2,592,000 2,722,933 . CONTRIBUTION (REDUCTION) - GENERAL FUND BALANCE 2( ,150) 0 AMY SIMON FUND GIFTS 150 0 INTEREST 2,000 0 TOTAL AMY SIMON FUND 4150 0 RESERVE INTEREST 0 68,000 TOTAL RESERVE 0 68,000 TOTALS Q 68.000 TOTAL REVENUES 2,592,000 2,790,933 TOTAL EXPENDITURES 2.592.000 2.722.933 GRAND TOTAL Q DEERFIELD PUBLIC LIBRARY FY 2007 BUDGET GENERALFUND LIBRARY LIBRARY BINDING LIBRARY PERIODICALS LIBRARY BOOKS LIBRARY CHILDREN'S BOOKS LIBRARY AUDIO VISUAL LIBRARY SPECIAL PROGRAMS LIBRARY ONLINE SERVICES LIBRARY CATALOGING SERVICE LIBRARY LOST BOOKS TOTAL LIBRARY OFFICE INSURANCE GENERAL LIABILITY POSTAGE PRINTING OFFICE SUPPLIES OTHER EXPENSES PROF SERV CORPORATE COUNSEL TELEPHONE TOTAL OFFICE TRAINING AND DEVELOPMENT DUES & MEMBERSHIPS TRAVEL TOTAL TRAINING & DEVELOPMENT SUBTOTAL GENERAL EXPENDITURES FY 2006 FY 2007 BUDGET BUDGET 4,500 4,500 40,000 45,000 - 145,000 150,000 55,000 55,000 35,000 45,000 18,000 15,000 100,000 100,000 20,000 20,000 5,000 7,033 422,500 441,533 30,000 6,000 18,000 32,000 1,000 4,000 11.000 102,000 8,000 81000 16, 000 2,227,000 30,000 7,000 18,000 35,000 5,000 5,000 13.500 113,500 8,000 8.000 16,000 2,347,933 DEERFIELD PUBLIC LIBRARY . FY 2007 BUDGET GENERALFUND MISCELLANEOUS REVENUE AVAILABLE FROM RESERVE GIFTS AND CONTRIBUTIONS OTHER TOTAL MISCELLANEOUS REVENUE TOTALREVENUES EXPENDITURES PERSONNEL EXPENSES REGULAR SALARIES FICA HEALTH & MISC. BENEFITS PENSION TOTAL PERSONNEL SERVICES BUILDING REPAIR & MAINTENANCE - BUILDING REPAIR & MAINTENANCE - EQUIPMENT REPAIR & MAINTENANCE - STRUCTURE WATER TOTAL BUILDING FY 2006 BUDGET 100,000 2,500 1.000 103.50 2,589,850 1,248,000 - . 96, 000 172,000 114,000 1,630,000 20,000 25;000 10,000 t500 56.50 FY 2007 BUDGET 100,000 1,000 11000 102,000 2,722,933 1,310,400 100,000 185,000 115.000 1,710,400 25,000 25,000 15,000 1,500 66,500 GENERALFUND REVENUES TAXES PROPERTY TAX SURPLUS DISTRIBUTION SURPLUS TRANSFER REPLACEMENT TAX TOTALTAXES FEES & FINES FEES, FINES & PENALTIES NON- RESIDENT FEES PHOTOCOPYING FEES VIDEO BORROWING TOTAL FEES & FINES INVESTMENT INCOME INTEREST EARNINGS TOTAL INVESTMENT INCOME INTERGOVERNMENTAL STATE GRANT (PER CAPITA) TOTAL INTERGOVERNMENTAL DEERFIELD PUBLIC LIBRARY FY 2007 BUDGET FY 2006 BUDGET 2,357,350- 350,000 (350, 000) 16.000 2,373,350 40,000 10,000 5,000 12.000 67.000 25.000 25,000 21,000 21,000 FY 9nn7 2,496,433 - 0 0 16,000 2,512,433 40,000 10,000 5,000 7.500 62,500 25,000 25,000 21,000 21,000 A.