Loading...
O-12-14VILLAGE OF DEERFIELD LAKE AND COOK COUNTIES, ILLINOIS ORDINANCE 0-12 -14 ADOPTING THE BUDGET OF THE VILLAGE OF DEERFIELD FOR THE FISCAL YEAR BEGINNING MAY 1, 2012 AND ENDING APRIL 30, 2013 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, 2012; and, WHEREAS, the tentative annual budget for the fiscal year beginning May 1, 2012 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 interest 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, 2012 and ending April 30, 2013. 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, 2012, and ending April 30, 2013. 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 16th day of April , 2012. AYES: Benton, Farkas, Jester, Oppenheim, Struthers (5) NAYS: Seiden (1) ABSENT: None ABSTAIN: None APPROVED this 16th day of April , 2012. ATTEST: illage Clerk Mayor Exhibit A 2012/13 Annual Budget BUDGET SUMMARY - FOUR YEAR COMPARISON YR.END YR.END BUDGET EST.YR.END BUDGET % CHG BUDG FUND /REVENUE SOURCE FY 09/10 FY 10/11 FY 11/12 FY 11/12 FY 12/13 FY12 - >13 GENERAL FUND (10) - Corporate Property 2,006,159 1,989,698 2,140,000 2,140,000 2,140,000 0.00% -TIF Surplus 0 0 0 0 0 N/A -Sales 4,153,781 4,372,978 4,450,000 4,600,000 4,550,000 2.25% -Home Rule Sales 2,525,183 2,725,330 2,535,000 2,800,000 2,650,000 4.54% -Hotel /Motel 1,415,604 1,532,536 1,700,000 1,750,000 1,800,000 5.88% -State Income 1,462,986 1,436,146 1,472,000 1,472,000 1,443,400 -1.94% -State Use Tax 219,053 265,672 225,400 296,000 297,000 31.77% -Prior year Property Tax 0 0 10,000 10,000 10,000 0.00% -Pers. Prop. Replace. 81,182 90,771 75,000 85,000 85,000 13.33% - Telecommunications Tax 326,528 644,129 1,500,000 1,500,000 1,500,000 0.00% - Electric Utility Tax 0 1,162,527 1,200,000 1,250,000 1,250,000 4.17% Fines--------------------------------------------------------------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -Court/Local Ordinance 227,686 262,542 265,500 251,500 241,500 - 9.04% LicenseFees------------------------------------------------------------------------------------------------------------------------------------------------------------- From Fund Balance 541,604 (1,043,011) 447,005 (986,008) 2,214,608 - Business 72,367 73,906 60,500 60,500 60,500 0.00% - Liquor 60,175 73,255 65,000 65,000 65,000 0.00% - Vehicle 335,363 330,842 338,000 335,000 338,000 0.00% -Other 1,050 750 2,500 500 500 - 80.00% PermitFees------------------------------------------------------------------------------------------------------------------------------------------------------------ 1,075 0 1,000 (1,500) 100 - 90.00% - Building 890,017 945,990 500,000 750,000 525,000 5.00% -Other 7,500 7,050 8,000 7,000 7,000 - 12.50% InspectionFees------------------------------------------------------------------------------------------------------------------------------------------------------------ - Engineering 0 41,483 2,000 7,500 2,000 0.00% - Dispatching Services 91,236 93,492 86,000 88,000 88,000 2.33% - Interest Earned (net) 117,170 74,848 120,000 105,000 105,000 - 12.50% - Special Police Services 174,636 174,647 162,500 185,500 175,500 8.00% - Activity Donations 22,117 27,378 55,000 32,000 25,000 - 54.55% - Grants 49,229 182,983 39,000 117,000 46,000 17.95% - Transfers In 181,000 224,000 224,000 224,000 274,000 22.32% -Cable Franchise Fees 313,565 351,984 340,000 350,000 350,000 2.94% - Auction Proceeds 94,690 30,161 7,500 7,500 7,500 0.00% - Rental Income 182,163 186,276 211,000 235,000 235,000 11.37% -False Alarm Fees 27,000 34,817 28,000 27,000 27,000 -3.57% - Miscellaneous 324,225 178,702 122,000 499,000 135,000 10.66% TOTAL NEW REVENUE 15,361,665 17,514,892 17,943,900 19,250,000 18,432,900 2.73% Adjustment (To) From Fund Balance 541,604 (1,043,011) 447,005 (986,008) 2,214,608 395.43% TOTAL EXPENDITURES 15,903,269 16,471,881 19,140,905 18,263,992 20,647,508 7.87% :'K FIN WATER FUND (50) -Water Sales 3,595,735 3,809,440 4,000,000 4,000,000 4,100,000 2.50% - Interest Earned 1,075 0 1,000 (1,500) 100 - 90.00% - Miscellaneous 70,260 84,181 110,000 225,500 103,000 -6.36% TOTAL NEW REVENUE 3,667,069 3,893,620 4,111,000 4,224,000 4,203,100 2.24% Adjustment (To) From Retained Earnings 436,818 321,860 292,977 257,863 228,442 - 22.03% TOTAL OPERATING EXPENSES 4,103,888 4,215,481 4,403,977 4,481,863 • 4,431,542 0.63% =1 � 1 � I��� � I � � i � � �_T 3�a � d � 13�� l : Z•Z � 7 i I I J_T:� 6� � ] YR.END YR.END BUDGET EST.YR.END BUDGET % CHG BUDG FUND /REVENUE SOURCE FY 09/10 FY 10/11 FY 11/12 FY 11/12 FY 12/13 FY12 - >13 SEWER FUND (54) 0 5,144,163 0 0 182,593 N/A -Sewer Use Fees 2,345,448 2,479,107 2,459,000 2,440,000 2,698,000 9.72% - Interest Earned 119 372 500 (100) 100 - 80.00% - Miscellaneous 17,552 33,761 17,000 64,100 17,000 0.00% TOTAL NEW REVENUE 2,363,119 2,513,241 2,476,500 2,504,000 2,715,100 9.63% Adjustment (To) From Retained Earnings 280,158 333,147 475,409 304,639 219,344 - 53.86% TOTAL OPERATING EXPENSES 2,643,277 2,846,388 2,951,909 2,808,639 2,934,444 -0.59% MOTOR FUEL TAX FUND (14) - Intergov. Transfer In 473,426 554,542 472,880 453,800 453,800 -4.03% - Interest Inc. /Misc. 5,419 2,218 3,000 2,000 2,000 - 33.33% TOTAL NEW REVENUE 478,844 556,760 475,880 455,800 455,800 -4.22% Adjustment (To) From Fund Balance 15,156 (66,760) 14,120 34,200 34,200 142.21% TOTAL EXPENDITURES 494,000 490,000 490,000 490,000 490,000 0.00% C, GARAGE FUND (70) - Charges for Service 373,594 371,747 385,000 385,000 385,000 0.00% - Interest Earned /Misc. 8,858 10,969 7,500 8,650 8,500 13.33% TOTAL NEW REVENUE 382,453 382,717 392,500 393,650 393,500 0.25% Adjustment (To) From Fund Balance (15,804) (262) 625 (25,375) (3,200) - 612.00% TOTAL EXPENDITURES 366,649 382,455 393,125 368,275 390,300 - 0.72% POLICE PENSION FUND (80) - Employer Contribution 1,202,006 1,350,132 1,000,000 1,000,000 1,000,000 0.00% - Employee Contrib. 358,412 364,078 390,000 445,000 410,000 5.13% - invest. Income 5,071,411 3,583,925 1,100,000 1,100,000 1,100,000 0.00% TOTAL NEW REVENUE 6,631,828 5,298,135 2,490,000 2,545,000 2,510,000 0.80% Adjustment (To) From Fund Balance (5,109,367) (3,579,157) (615,920) (351,945) (422,450) - 31.41% TOTAL EXPENDITURES 1,522,461 1,718,978 1,874,080 2,193,055 2,087,550 11.39% DEBT SERVICE FUND (35) including bond proceeds -Bond Proceeds net of transfer out 0 5,144,163 0 0 182,593 N/A - Property Taxes 0 153,280 502,500 502,484 2,212,995 340.40% - Transfer From TIF 2 /Gen. Fund 0 210,000 701,602 701,602 833,396 18.78% - Interest Earned /Misc. /BAB credit 2,113 236 188,755 188,755 592,291 213.79% TOTAL NEW REVENUE 2,113 5,507,679 1,392,857 1,392,841 3,821,275 174.35% Adjustment (To) From Fund Balance 1,032,427 (5,139,766) (18,529). (18,751) (924,229) 4888.11% TOTAL EXPENDITURES 1,034,539 367,913 1,374,328 1,374,090 2,897,046 110.80% BUDGET SUMMARY - FOUR YEAR COMPARISON YR.END YR.END BUDGET EST.YR.END BUDGET % CHG BUDG FUND /REVENUE SOURCE FY 09/10 FY 10/11 FY 11/12 FY 11/12 FY 12/13 FY12 - >13 TAX INCREMENT FINANCING DISTRICT 2 - Village Center (26) - (district terminated) - Grants 0 0 0 0 0 N/A - Investment Income 34,623 0 0 0 0 N/A - Increment Prop. Tax 5,124,436 0 0 0 0 N/A -Other/Transfers In 0 0 0 0 0 N/A TOTAL NEW REVENUE 5,159,059 0 0 0 0 N/A Adjustment (To) 0.00% - Interest Earned 0 310 500 3,500 From Fund Balance 3,837,808 0 0 0 0 N/A TOTAL EXPENDITURES 8,996,867 0 0 0 0 N/A INFRASTRUCTURE REPLACEMENT (22) - Transfers In 923,389 7,296,834 21,400,000 21,400,000 16,600,000 - 22.43% -Home Rule Sales Tax 841,728 908,444 782,640 930,000 900,000 15.00% - Property Tax 45,076 44,825 45,000 45,000 45,000 0.00% - Rental Income /Impact Fee 0 0 0 0 0 N/A -Other (TIF Surplus /Grants /Bond Pro( 1,789,725 214,682 3,500 433,500 3,500 0.00% - Interest Earned 0 310 500 3,500 1,500 200.00% TOTAL NEW REVENUE 3,599,918 8,465,094 22,231,640 22,812,000 17,550,000 - 21.06% Adjustment (To) - Surcharge Revenue 341,116 303,289 355,000 350,000 350,000 From Fund Balance 1,025,056 (186,451) 1,769,360 (1,805,813) 2,146,000 21.29% TOTAL EXPENDITURES 4,624,973 8,278,643 24,001,000 21,006,187 19,696,000 - 17.94% VEHICLE & EQUIPMENT REPLACEMENT FUND (21) - Interfund Transfer 584,639 534,924 559,608 559,608 532,484 -4.85% - interest/Misc. 27,471 44,174 28,000 28,000 28,000 0.00% TOTAL NEW REVENUE 612,110 579,098 587,608 587,608 560,484 -4.62% Adjustment (To) - Interest 1,763 649 1,500 950 750 From Fund Balance (107,035) (235,966) (151,908) (288,408) 29,516 - 119.43% TOTAL EXPENDITURES 505,075. 343,132 435,700 299,200 590,000 35.41% From Fund Balance EMERGENCY TELEPHONE SYSTEM (911) (17) 146,624 (64,426) (122,278) (103,823) 61.15% - Surcharge Revenue 341,116 303,289 355,000 350,000 350,000 -1.41% - Grant/Miscellaneous 0 3,453 0 0 0 N/A - Interest 7,517 5,235 8,000 7,000 7,000 - 12.50% TOTAL NEW REVENUE 348,633 311,977 363,000 357,000 357,000 -1.65% Adjustment (To) From Fund Balance (18,765) (71,912) 150,242 (75,858) 205,071 36.49% TOTAL EXPENDITURES 329,868 240,065 513,242 281,142 562,071 9.51% SOLID WASTE SYSTEM (58) -User Fees 622,629 608,475 473,900 475,400 487,150 2.80% - Property Taxes 807,968 832,264 883,428 883,000 905,500 2.50% - Miscellaneous 5,349 12,724 6,000 72,000 72,000 1100.00% - Interest 1,763 649 1,500 950 750 - 50.00% TOTAL NEW REVENUE 1,437,709 1,454,112 1,364,828 1,431,350 1,465,400 7.37% Adjustment (To) From Fund Balance 161,534 146,624 (64,426) (122,278) (103,823) 61.15% TOTAL OPERATING EXPENSES 1,599,243 1,600,736 1,300,402 1,309,072 1,361,577 4.70% i .Y., '?�, 4: W ,� :h. .' i' `t'yt: �ii;,„2 Y.. .d, r r 7:,, '�' 4 - Fi'l.,Y '.{l. ✓ Y 1 .. ., E1 f� iiY..,, l j.. r' .Y l ji : Y.: hi N�irtr +kl ++.,t y. 1 ,jI .ICY' BUDGET SUMMARY - FOUR YEAR COMPARISON YR.END YR.END BUDGET EST.YR.END BUDGET % CHG BUDG FUND /REVENUE SOURCE FY 09/10 FY 10/11 FY 11/12 FY 11/12 FY 12/13 FY12 - >13 COMM. STATION PARKING (60) -User Fees 209,165 204,236 227,000 200,000 200,000 - 11.89% -Misc. Revenue 0 0 0 0 0 N/A - Interest 5,340 3,511 4,000 3,200 3,200 - 20.00% TOTAL NEW REVENUE 214,504 207,747 231,000 203,200 203,200 - 12.03% Adjustment (To) From Fund Balances 47,953 114,684 150,749 127,675 213,820 41.84% TOTAL EXPENDITURES 262,457 322,431 381,749 330,875 417,020 9.24% TOTAL NEW REVENUES 40,259,024 46,685,072 54,060,713 56,156,449 52,667,759 -2 Adjustment (To) From Fund Balance 2,127,542 (9,406,970) 2,449,704 (2,950,059) 3,837,299 56 TOTAL EXPENDITURES 42,386,566 37,278,102 57,260,417 53,206,390 56,505,058 -1 0.45 0.4 0.35 0.3 w 0.25 H 0.2 0.15 0.1 0.05 0 VILLAGE PROPERTY TAX RATE - $1$100 OF EQUALIZED ASSESSED VALUATION 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011* 2012+ TAX YEAR ( +projected, *estimated) FUND VILLAGE OF DEERFIELD 2011 -2012 BUDGET SUMMARIES BY FUND 5/1/2011 AUDITED BEGINNING FUND BALANCE PROJECTED NEW PROJECTED REVENUES EXPENDITURES 4/30/2012 PROJECTED ENDING FUND BALANCE General $16,566,828 $19,250,000 $18,263,992 $17,552,836 Sewer 158,485 2,504,000 2,808,639 (146,154) Water (399,963) 4,224,000 4,481,863 (657,826) Garage 129,210 393,650 368,275 154,585 Subtotal "Operational' Funds $16,454,560 $26,371,650 $25,922,769 $16,903,441 MFT 551,238 455,800 490,000 517,038 Refuse (Solid Waste) 0 1,431,350 1,309,072 122,278 Debt Service 101,518 1,392,841 1,374,090 120,269 Infrastructure Replacement (inc. Bond Proc) 5,511,182 22,812,000 21,006,187 7,316,995 Parking Lots 586,002 203,200 330,875 458,327 Vehicle & Equipment Replacement 4,145,722 587,608 299,200 4,434,130 Enhanced 911 1,180,422 357,000 281,142 1,256,280 COMBINED VILLAGE FUNDS $28,530,644 $53,611,449 $51,013,335 $31,128,758 Police Pension 30,880,931 2,545,000 2,193,055 31,232,876 Deerfield Library 4,200,902 4,491,500 4,491,500 4,200,902 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. VILLAGE OF DEERFIELD 2012-2013 BUDGET SUMMARIES BY FUND Police Pension Deerfield Library 31,232,876 4,200,902 2,510,000 7,347,500 2,087,550 7,347,500 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. 9 31,655,326 4,200,902 511/2012 413012013 PROJECTED PROJECTED BEGINNING BUDGET NEW BUDGET ENDING FUND FUND BALANCE REVENUES EXPENDITURES FUND BALANCE General $17,552,836 $18,432,900 $20,647,508 $15,338,228 Sewer (146,154) 2,715,100 2,934,444 (365,498) Water (657,826) 4,203,100 4,431,542 (886,268) Garage 154,585 393,500 390,300 157,785 Subtotal "Operational" Funds $16,753,540 $25,744,600 $28,403,794 $14,244,247 MFT 517,038 455,800 490,000 482,838 Refuse (Solid Waste) 122,278 1,465,400 1,361,577 226,101 Debt Service 120,269 3,821,275 2,897,046 1,044,498 Infrastructure Replacement 7,316,995 17,550,000 19,696,000 5,170,995 Parking Lots 458,327 203,200 417,020 244,507 Vehicle & Equipment Replacement 4,434,130 560,484 590,000 4,404,614 Enhanced 911 1,256,280 357,000 562,071 1,051,209 COMBINED VILLAGE FUNDS $30,978,857 $50,157,759 $54,417,508 $26,869,009 Police Pension Deerfield Library 31,232,876 4,200,902 2,510,000 7,347,500 2,087,550 7,347,500 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. 9 31,655,326 4,200,902 2012 Property Tax Levy with Dive Year Comparison Fund 2008 2009 2010 net net 2011 (net)iVET Proposed 2012 % Change General 1,984,950 1,984,950 2,140,000 2,140,000 2,140,000 0.0% Infrastructure 45,000 45,000 45,000 45,000 45,000 0.0% Scavenger 808,950 841,360 883,428 883,428 905,500 2.5% Debt Serv. WRF 0 0 301,490 1,362,274 1,583,239 16.2% Debt Serv. non -WRF 0 155,000 200,994 0 481,110 NIA Total Village 2,836,900 3,026,310 3,570,912 4,430,702 5,154,849 16.3% Library 2,756,250 2,903,250 3,050,000 3,966,072 4,050,000 2.1% Combined Levy 5,595,150 5,929,560 6,620,912 6,396,774 9,204,849 9.6% Tax Mate History EAV 1,577,953,846 1,586,409,629 1,501,605,590 1,500,000,000 1,500,000,000 0.0% Tax Rate (est) (est) Village 0.180 0.191 0.238 0.295 0.344 16.3% Library 0.175 0.183 0.203 0.264 0.270 2.1% Combined 0.355 0.3741 0.441 0.5601 0.614 9.6% 2012 NET represents debt service levies net of Federal credits - no other abatements Village of Deerfield Budgeted Full Time Employees DEPARTMENT /FYE 4 -30 2006 2007 2008 2009 2010 2011 2012 1 2013 VILLAGE MANAGER 3 3 3 3 3 2 5 5 FINANCE 9 10 10 10 10 10 8 8 COMMUNITY DEVELOPMENT 6 7 7 7 7 7 7 7 PUBLIC WORKS: ADMINISTRATION 2 4 4 4 4 4 4 4 ENGINEERING 2 3 3 3 3 2 2 2 STREETS 7 7 7 7 7 7 7 7 UTILITIES MAINTENANCE 13 14 15 15 15 14 14 14 SEWAGE TREATMENT PLANT 8 8 8 8 8 8 8 8 GARAGE 2 2 2 2 2 2 2 2 TOTAL PUBLIC WORKS 34 38 39 39 39 37 37 37 POLICE: 0.3 0.3 1.0 1.0 1.0 1.0 1.0 1.0 ADMINISTRATION 8 7 7 7 7 7 7 7 COMMUNICATIONS 8 8 8 8 8 8 8 8 INVESTIGATIONS /YOUTH 7 7 7 7 7 7 7 7 PATROL 32 31 31 31 31 31 32 32 TOTAL POLICE 55 53 53 53 53 53 54 54 TOTAL 107 111 112 112 112 109 111 111 Part time Employees - Full time equivalent DEPARTMENT /FYE 4 -30 2006 2007 2008 2009 2010 2011 2012 2013 VILLAGE MANAGER 0.6 0.6 0.6 0.6 0.6 1.4 1.4 0.2 FINANCE 0.0 0.2 0.2 0.2 0.2 0.1 0.1 0.1 COMMUNITY DEVELOPMENT 0.8 0.0 0.0 0.6 0.6 0.6 0.6 0.6 PUBLIC WORKS: ENGINEERING 0.0 0.3 0.3 0.3 0.3 0.8 0.8 0.8 STREETS 0.8 1.2 1.2 1.5 1.5 1.5 1.5 1.5 UTILITIES MAINTENANCE 1.5 1.5 1.5 1.7 1.7 1.7 1.7 1.7 SEWAGE TREATMENT PLANT 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 TOTAL PUBLIC WORKS 2.6 3.3 3.3 3.8 3.8 4.3 4.3 4.3 POLICE: ADMINISTRATION 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 COMMUNICATIONS 0.3 0.3 1.0 1.0 1.0 1.0 1.0 1.0 INVESTIGATIONS /YOUTH 0.0 0.8 0.8 0.8 0.8 0.8 0.0 0.0 PATROL 1.8 1.8 1.8 1.8 1.8 1.8 1.8 1.8 TOTAL POLICE 2.1 2.1 3.6 3.6 3.6 3.6 2.8 2.8 TOTAL - PART TIME - FTE 6.1 5.5 7.7 8.8 8.8 10.0 9.2 8.0 BUDGET REQUEST - FY 2012 -2013 DEERFIELD PUBLIC LIBRARY (COMPONENT UNIT) PERSONNEL SERVICES ACTUAL BUDGET EST EXPEND BUDGET % CHG BUDG TRAINING & DEVELOPMENT FY 10/11 I FY 11/12 I FY 11/12 FY 12/13 FY12 -FY13 PERSONNEL SERVICES 1,952,397 2,170,580 2,170,580 2,291,484 5.57% TRAINING & DEVELOPMENT 36,035 26,500 26,500 26,500 0.00% CONTRACTUAL SERVICES 1,138,877 603,800 603,800 554,500 - 8.16% COMMODITIES 54,176 378,620 378,620 416,016 9.88% UTILITIES 16,881 32,000 32,000 32,000 0.00% OTHER EXPENSES 7,966 0 0 0 N/A DEBT SERVICE 0 0 0 0 N/A CAPITAL OUTLAY 0 1,280,000 1,280,000 4,027,000 214.61% CAPITAL IMPROVEMENTS 0 0 0 0 N/A TRANSFERS OUT 0 0 0 0 N/A TOTAL EXPENDITURES 1 3,206,332 1 4,491,5001 4,491,500 1 7,347,500 1 63.59% DEERFIELD LIBRARY (COMPONENT UNIT) - REVENUES TAXES INTERGOVERNMENTAL FEES & FINES INVESTMENT INCOME MISCELLANEOUS TOTALREVENUES 2,964,929 ACTUAL BUDGET EST REVENUE BUDGET % CHG BUDG 20,000 FY 10/11 FY 11/12 FY 11/12 FY 12/13 FY12 -FY13 TAXES INTERGOVERNMENTAL FEES & FINES INVESTMENT INCOME MISCELLANEOUS TOTALREVENUES 2,964,929 3,100,000 3,100,000 3,252,500 4.92% 20,850 20,000 20,000 20,000 0.00% 90,348 81,500 81,500 62,500 - 23.31% 20,845 3,000 3,000 3,000 0.00% 16,585 1,287,000 1,287,000 4,009,500 211.54% 3,113,5571 4,491,5001 4,491,5001 7,347,500 1 63.59% As a component unit, the Library budget is not reported under the Village budget. ••••!. m U n I$' Financials, Revenue & Citizen services and Human Capital Management , PROP TAX !e • o ly,cr Crp SOIUtiOn 2,140,000.00 2,182,144.62 2,140,000.00 04/19/2012 09:18 OF DEERFIELD 100001 1 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpta PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION 32,082.88 FOR PERIOD 99 ACCOUNTS FOR: .0% 100001 4114 PRTX PR YR 2011 2012 2012 2012 2012 2013 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 100001 GENERAL FUND REVENUE 41 TAXES 100001 4110 PROP TAX 1,963,603.76 2,140,000.00 2,140,000.00 2,182,144.62 2,140,000.00 2,140,000.00 .0% 100001 4112 PRTX ROAD 26,094.35 .00 .00 32,082.88 .00 .00 .0% 100001 4114 PRTX PR YR .00 10,000.00 10,000.00 3,008.43 10,000.00 10,000.00 .0% 100001 4120 REPLACEMT 90,771.32 75,000.00 75,000.00 86,522.10 85,000.00 85,000.00 13.3% 100001 4140 ST SALES 4,372,978.19 4,450,000.00 4,450,000.00 4,945,404.84 4,600,000.00 4,550,000.00 2.2% 100001 4141 HR SALES 2,725,330.49 2,535,000.00 2,535,000.00 3,132,796.87 2,800,000.00 2,650,000.00 4.5% 100001 4142 LOC USE TX 265,672.34 225,400.00 225,400.00 268,102.82 296,000.00 297,000.00 31.8% 100001 4150 ST INC TX 1,436,145.92 1,472,000.00 1,472,000.00 1,311,291.19 1,472,000.00 1,443,400.00 -1.9% 100001 4160 HOTEL TAX 1,532,535.77 1,700,000.00 1,700,000.00 1,573,416.54 1,750,000.00 1,800,000.00 5.9% 100001 4170 TELECOM TX 644,129.32 1,500,000.00 1,500,000.00 1,631,299.47 1,500,000.00 1,500,000.00 .0% 100001 4175 ELEC UTIL 1,162,527.23 1,200,000.00 1,200,000.00 1,210,227.88 1,250,000.00 1,250,000.00 4.2% TOTAL TAXES 14,219,788.69 15,307,400.00 15,307,400.00 16,376,297.64 15,903,000.00 15,725,400.00 2.7% 42 LICENSES & PERMITS 100001 4211 LIQR LIC 73,255.00 65,000.00 65,000.00 74,283.34 65,000.00 65,000.00 .0% 100001 4213 FOOD LIC 6,890.00 5,000.00 5,000.00 5,740.25 5,000.00 5,000.00 .0% 100001 4214 BUSN LIC 5,485.00 5,500.00 5,500.00 4,235.00 5,500.00 5,500.00 .0% 100001 4220 BLDG PERM 945,989.64 500,000.00 500,000.00 682,753.43 750,000.00 525,000.00 5.0% 100001 4222 CONTR LIC 7,050.00 8,000.00 8,000.00 7,000.00 7,000.00 7,000.00 -12.5% 100001 4232 LIC & PERM 61,531.08 50,000.00 50,000.00 54,738.00 50,000.00 50,000.00 .0% 100001 4233 ALRM PERM 750.00 2,500.00 2,500.00 1,075.00 500.00 500.00 -80.0% 100001 4240 VEH LIC 330,841.50 338,000.00 338,000.00 331,286.50 335,000.00 338,000.00 .0% TOTAL LICENSES & PERMITS 1,431,792.22 974,000.00 974,000.00 1,161,111.52 1,218,000.00 996,000.00 2.3% 43 INTERGOVERNMENTAL & 100001 4330 ST GRANT 28,192.00 6,000.00 6,000.00 1,100.00 2,000.00 3,000.00 -50.0% 100001 4350 FED GRANT 105,081.97 .00 .00 71,530.97 72,000.00 .00 .0% 100001 4463 CIS HWY MT 45,184.75 33,000.00 33,000.00 34,490.75 43,000.00 43,000.00 30.3% 100001 4464 CIS TSM 4,524.00 .00 .00 4,416.00 .00 .00 .0% TOTAL INTERGOVERNMENTAL & 182,982.72 39,000.00 39,000.00 111,537.72 117,000.00 46,000.00 17.9% 44 CHARGES FOR SERVICES 100001 4415 CIS WLGRN 16,973.77 12,500.00 12,500.00 14,029.08 15,500.00 15,500.00 24.0% ••�•:!• Mum' Financials, Revenue & citizen Services and Human Capital Management . r56 o tyler erp solution teChnclopes 04/19/2012 09:18 OF DEERFIELD 2 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpta PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 100001 4417 CIS POL OT 155,243.83 150,000.00 150,000.00 169,159.96 165,000.00 155,000.00 3.3% 100001 4418 CIS POL XG 2,429.44 .00 .00 5,883.24 5,000.00 5,000.00 .0% 100001 4419 CIS OTHER 5,160.26 .00 .00 4,968.00 5,000.00 5,000.00 .0% 100001 4420 CIS MAT SL .00 2,000.00 2,000.00 .00 .00 .00 - 100.0% 100001 4425 CIS BNK DI 93,492.00 86,000.00 86,000.00 89,243.00 88,000.00 88,000.00 2.396 100001 4430 CIS ENGIN 41,482.50 2,000.00 2,000.00 7,529.00 7,500.00 2,000.00 .0% 100001 4462 CIS TREE 69,444.00 55,000.00 55,000.00 56,484.25 55,000.00 55,000.00 .0% TOTAL CHARGES FOR SERVICES 384,225.80 307,500.00 307,500.00 347,296.53 341,000.00 325,500.00 5.9% 45 FEES & FINES 100001 4510 ORD V CTY 214,089.93 170,000.00 170,000.00 237,618.73 190,000.00 170,000.00 .0% 100001 4511 ORD V VIL 19,757.69 62,000.00 62,000.00 36,651.02 45,000.00 45,000.00 -27.4% 100001 4520 FLSE ALRM 34,816.71 28,000.00 28,000.00 27,187.14 27,000.00 27,000.00 -3.6% 100001 4521 ALRM MNTR 23,151.41 25,000.00 25,000.00 17,974.15 23,000.00 23,000.00 -8.0% 100001 4530 RSTIT FINE 1,217.00 .00 .00 1,665.00 .00 .00 .0% 100001 4540 OVR SZ VEH 2,020.00 3,500.00 3,500.00 3,315.00 3,500.00 3,500.00 .096 100001 4560 FF & PEN 2,305.96 .00 .00 463.00 .00 .00 .0% TOTAL FEES & FINES 297,358.70 288,500.00 288,500.00 324,874.04 288,500.00 268,500.00 -6.9% 46 INVESTMENT INCOME 100001 4610 INTER EARN 104,015.17 120,000.00 120,000.00 100,964.67 105,000.00 105,000.00 -12.5% 100001 4620 GAIN SALE - 25,917.37 .00 .00 .00 .00 .00 .0% 100001 4622 UNRLZD GIL - 3,250.26 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 74,847.54 120,000.00 120,000.00 100,964.67 105,000.00 105,000.00 -12.5% 48 MISCELLANEOUS REVENU 100001 4810 MISC REV 54,963.35 70,000.00 70,000.00 360,962.75 350,000.00 70,000.00 .0% 100001 4811 RENT INC 186,276.04 211,000.00 211,000.00 326,232.03 235,000.00 235,000.00 11.4% 100001 4821 PLZA ENT .00 5,000.00 5,000.00 .00 .00 .00 - 100.0% 100001 4822 FAM DY DON 27,378.30 50,000.00 50,000.00 40,287.00 32,000.00 25,000.00 -50.0% 100001 4843 WC REIMB 38,217.42 .00 .00 27,292.11 30,000.00 5,000.00 .0% 100001 4844 INS REIMB 10,916.23 .00 .00 92,675.48 49,000.00 .00 .0% 100001 4851 SALE EQPM 30,161.03 7,500.00 7,500.00 13,306.88 7,500.00 7,500.00 .0% 100001 4880 CABLE TV 351,984.30 340,000.00 340,000.00 363,379.59 350,000.00 350,000.00 2.9% TOTAL MISCELLANEOUS REVENU 699,896.67 683,500.00 683,500.00 1,224,135.84 1,053,500.00 692,500.00 1.3% 49 TRANSFERS IN (IFT) 100001 4910 TRSNFR IN 224,000.00 224,000.00 224,000.00 .00 224,000.00 274,000.00 22.3% -- •�•_• m V n i$' Financials, Revenue & citizen Services and Human capital management;iU�� • e tyle, erp Solution 04/19/2012 09:18 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 2012 2012 GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION IPG 3 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE TOTAL TRANSFERS IN (IFT) 224,000.00 224,000.00 224,000.00 .00 224,000.00 274,000.00 22.3% TOTAL GENERAL FUND REVENUE 17,514,892.34 17,943,900.00 17,943,900.00 19,646,217.96 19,250,000.00 18,432,900.00 2.7% TOTAL GENERAL FUND 17,514,892.34 17,943,900.00 17,943,900.00 19,646,217.96 19,250,000.00 18,432,900.00 2.7% °• o m Un iS* Financials, Revenue & Citizen services and Human Capital Management er whndN,es a tyler erp solution �. 04/19/2012 09:18 OF DEERFIELD 4 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS (PG bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT MOTOR FUEL TAX FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 140001 MOTOR FUEL TAX REVENUE 43 INTERGOVERNMENTAL & 140001 4310 MFT REV 554,542.04 472,880.00 472,880.00 539,460.91 453,800.00 453,800.00 -4.0% TOTAL INTERGOVERNMENTAL & 554,542.04 472,880.00 472,880.00 539,460.91 453,800.00 453,800.00 -4.0% 46 INVESTMENT INCOME 140001 4610 INTER EARN 3,138.34 3,000.00 3,000.00 3,846.48 2,000.00 2,000.00 -33.3% 140001 4620 GAIN SALE - 817.44 .00 .00 .00 .00 .00 .0% 140001 4622 UNRLZD G/L - 102.51 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 2,218.39 3,000.00 3,000.00 3,846.48 2,000.00 2,000.00 - 33.3°% TOTAL MOTOR FUEL TAX REVENUE 556,760.43 475,880.00 475,880.00 543,307.39 455,800.00 455,800.00 -4.29. TOTAL MOTOR FUEL TAX FUND 556,760.43 475,880.00 475,880.00 543,307.39 455,800.00 455,800.00 -4.2% •••.• m u n is• Financials, Revenue & Citizen Services and Human Capital Management • a tyter erp solution _ .. ' - �.i`. 04/19/2012 09:18 OF DEERFIELD PG 5 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT E 911 FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 170001 E911 FUND REVENUES 44 CHARGES FOR SERVICES 170001 4410 E911 SRCH 107,467.74 115,000.00 115,000.00 88,347.92 110,000.00 110,000.00 -4.3% 170001 4411 CELL 911 195,821.19 240,000.00 240,000.00 223,204.04 240,000.00 240,000.00 .0% TOTAL CHARGES FOR SERVICES 303,288.93 355,000.00 355,000.00 311,551.96 350,000.00 350,000.00 -1.4% 46 INVESTMENT INCOME 170001 4610 INTER EARN 7,354.19 8,000.00 8,000.00 6,799.54 7,000.00 7,000.00 -12.5% 170001 4620 GAIN SALE - 1,883.16 .00 .00 .00 .00 .00 .0% 170001 4622 UNRLZD G/L - 236.16 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 5,234.87 8,000.00 8,000.00 6,799.54 7,000.00 7,000.00 - 12.5°% 48 MISCELLANEOUS REVENU 170001 4810 MISC REV 3,453.00 .00 .00 3,453.00 .00 .00 .0% TOTAL MISCELLANEOUS REVENU 3,453.00 .00 .00 3,453.00 .00 .00 .0% TOTAL E911 FUND REVENUES 311,976.80 363,000.00 363,000.00 321,804.50 357,000.00 357,000.00 -1.7% TOTAL E 911 FUND 311,976.80 363,000.00 363,000.00 321,804.50 357,000.00 357,000.00 -1.7% 90 ��•_• mum' Financials, Revenue & Citizen Services and Human Capital Management a ty':er erp Swoon 04/19/2012 09:18 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 VEHICLE & EQUIPMENT REPLACE. ACTUAL ORIG BUD REVISED BUD 210001 VERF REVENUES 559,608.00 44 CHARGES FOR SERVICES 559,608.00 210001 4480 C/S FUNDS 534,924.00 TOTAL CHARGES FOR SERVICES 534,924.00 46 INVESTMENT INCOME 559,608.00 210001 4610 INTER EARN 27,639.41 210001 4620 GAIN SALE - 7,078.10 210001 4622 UNRLZD G/L - 887.65 TOTAL INVESTMENT INCOME 19,673.66 48 MISCELLANEOUS REVENU .00 210001 4810 MISC REV .00 210001 4852 G/L FADISP 24,500.00 TOTAL MISCELLANEOUS REVENU 24,500.00 TOTAL VERF REVENUES 579,097.66 TOTAL VEHICLE & EQUIPMENT RE 579,097.66 2012 2012 ACTUAL PROJECTION PG 6 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 559,608.00 559,608.00 559,608.00 559,608.00 532,484.00 -4.8% 559,608.00 559,608.00 559,608.00 559,608.00 532,484.00 -4.8% 28,000.00 28,000.00 25,824.50 28,000.00 28,000.00 .0% .00 .00 .00 .00 .00 .0% .00 .00 .00 .00 .00 .0% 28,000.00 28,000.00 25,824.50 28,000.00 28,000.00 .0% .00 .00 21,997.50 .00 .00 .0% .00 .00 .00 .00 .00 .0% .00 .00 21,997.50 .00 .00 .0% 587,608.00 587,608.00 607,430.00 587,608.00 560,484.00 -4.6% 587,608.00 587,608.00 607,430.00 587,608.00 560,484.00 -4.6% of 0i ��• . m u n i ' Financials, Revenue & Citizen Services and Human Capital Management a tyter erp Swoon 04/19/2012 09:18 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 INFRASTRUCTURE REPLACEMENT ACTUAL ORIG BUD REVISED BUD 2012 2012 ACTUAL PROJECTION PG 7 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 220001 INFRA REPLACE FUND REVENUE 41 TAXES 220001 4110 PROP TAX 44,606.97 45,000.00 45,000.00 45,889.70 45,000.00 45,000.00 .0% 220001 4115 TIF SRPLUS 217.67 .00 .00 .00 .00 .00 .0% 220001 4141 HR SALES 908,443.53 782,640.00 782,640.00 1,044,265.64 930,000.00 900,000.00 15.0% TOTAL TAXES 953,268.17 827,640.00 827,640.00 1,090,155.34 975,000.00 945,000.00 14.2% 43 INTERGOVERNMENTAL & 220001 4350 FED GRANT 206,819.01 .00 .00 428,538.45 430,000.00 .00 .0°% TOTAL INTERGOVERNMENTAL & 206,819.01 .00 .00 428,538.45 430,000.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 718.59 500.00 500.00 4,855.64 3,500.00 1,500.00 200.0% 220001 4620 GAIN SALE - 362.88 .00 .00 .00 .00 .00 .0°% 220001 4622 UNRLZD G/L -45.51 .00 .00 .00 .00 .00 .0°% TOTAL INVESTMENT INCOME 310.20 500.00 500.00 4,855.64 3,500.00 1,500.00 200.0% 48 MISCELLANEOUS REVENU 220001 4810 MISC REV 7,862.78 .00 .00 5,500.00 .00 .00 .0% TOTAL MISCELLANEOUS REVENU 7,862.78 .00 .00 5,500.00 .00 .00 .016 49 TRANSFERS IN (IFT) 220001 4910 TRSNFR IN 7,296,834.45 21,400,000.00 21,400,000.00 17,549,289.66 21,400,000.00 16,600,000.00 - 22.4°% TOTAL TRANSFERS IN (IFT) 7,296,834.45 21,400,000.00 21,400,000.00 17,549,289.66 21,400,000.00 16,600,000.00 -22.4% TOTAL INFRA REPLACE FUND REV 8,465,094.61 22,231,640.00 22,231,640.00 19,078,339.09 22,812,000.00 17,550,000.00 -21.1% TOTAL INFRASTRUCTURE REPLACE 8,465,094.61 22,231,640.00 22,231,640.00 19,078,339.09 22,812,000.00 17,550,000.00 -21.1% W��:!• m u n is• Financials, Revenue & Citizen Services and Human capital Management � - - a ty:er erp Solution .�hndogies 04/19/2012 09:18 OF DEERFIELD 8 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT BOND PROCEEDS FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 230001 BOND PROCEEDS 46 INVESTMENT INCOME 230001 4610 INVST EARN 10,009.32 .00 .00 17,758.21 .00 .00 .0% 230001 4630 PREM /DISC - 69,012.50 .00 .00 79,790.65 .00 .00 .0% TOTAL INVESTMENT INCOME - 59,003.18 .00 .00 97,548.86 .00 .00 .0% 49 TRANSFERS IN (IFT) 230001 4990 ISSUE DEBT 12,500,000.00 .00 .00 26,500,000.00 .00 .00 .0% TOTAL TRANSFERS IN (IFT) 12,500,000.00 .00 .00 26,500,000.00 .00 .00 .0% TOTAL BOND PROCEEDS 12,440,996.82 .00 .00 26,597,548.86 .00 .00 .0% TOTAL BOND PROCEEDS FUND 12,440,996.82 .00 .00 26,597,548.86 .00 .00 .0% •�• * -- :.•_• mum' Financials, Revenue & citizen services and Human capital Management a tyter erp solution 04/19/2012 09:18 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012/13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 DEBT SERVICE FUND ACTUAL ORIG BUD REVISED BUD 2012 2012 ACTUAL PROJECTION PG 9 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 350001 DEBT SERVICE REVENUE 41 TAXES 350001 4110 PROP TAX 153,280.24 502,500.00 502,500.00 558,064.36 502,484.00 2,192,995.00 336.4% 350001 4120 REPLACEMT .00 20,000.00 20,000.00 .00 20,000.00 20,000.00 .0% TOTAL TAXES 153,280.24 522,500.00 522,500.00 558,064.36 522,484.00 2,212,995.00 323.5% 46 INVESTMENT INCOME 350001 4610 INTER EARN 395.23 500.00 500.00 433.60 500.00 500.00 .0% 350001 4620 GAIN SALE - 141.33 .00 .00 .00 .00 .00 .0% 350001 4622 UNRLZD G/L -17.72 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 236.18 500.00 500.00 433.60 500.00 500.00 .0% 48 MISCELLANEOUS REVENU 350001 4810 MISC REV .00 168,254.65 168,254.65 168,254.63 168,255.00 774,384.00 360.2% TOTAL MISCELLANEOUS REVENU .00 168,254.65 168,254.65 168,254.63 168,255.00 774,384.00 360.2% 49 TRANSFERS IN (IFT) 350001 4910 TRSNFR IN 210,000.00 701,602.00 701,602.00 701,602.00 701,602.00 833,396.00 18.8% TOTAL TRANSFERS IN (IFT) 210,000.00 701,602.00 701,602.00 701,602.00 701,602.00 833,396.00 18.8% TOTAL DEBT SERVICE REVENUE 363,516.42 1,392,856.65 1,392,856.65 1,428,354.59 1,392,841.00 3,821,275.00 174.3% TOTAL DEBT SERVICE FUND 363,516.42 1,392,856.65 1,392,856.65 1,428,354.59 1,392,841.00 3,821,275.00 174.3% ��•.• m u n is Financials, Revenue & citizen services and Human capital Management . a !)let &p solution ram° df� 04/19/2012 09:18 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 2012 WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL 2012 PROJECTION tyler IPG 10 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 500001 WATER FUND REVENUES 42 LICENSES & PERMITS 500001 4216 WTR PERM 39,633.27 37,000.00 37,000.00 32,569.77 37,000.00 37,000.00 .0% TOTAL LICENSES & PERMITS 39,633.27 37,000.00 37,000.00 32,569.77 37,000.00 37,000.00 .0% 44 CHARGES FOR SERVICES 500001 4451 CIS UB 3,773,060.44 4,000,000.00 4,000,000.00 3,855,962.64 4,000,000.00 4,100,000.00 2.5% 500001 4452 CIS UB MSC 4,639.22 .00 .00 3,339.50 .00 .00 .0% 500001 4453 CIS UB PEN 31,740.29 37,000.00 37,000.00 29,838.96 34,000.00 34,000.00 -8.1% TOTAL CHARGES FOR SERVICES 3,809,439.95 4,037,000.00 4,037,000.00 3,889,141.10 4,034,000.00 4,134,000.00 2.41 46 INVESTMENT INCOME 500001 4610 INTER EARN .00 1,000.00 1,000.00 - 4,597.53 - 1,500.00 100.00 -90.0% TOTAL INVESTMENT INCOME .00 1,000.00 1,000.00 - 4,597.53 - 1,500.00 100.00 -90.0% 48 MISCELLANEOUS REVENU 500001 4810 MISC REV 822.05 10,000.00 10,000.00 125,759.46 127,500.00 5,000.00 - 50.0°% 500001 4811 RENT INC 26,996.74 26,000.00 26,000.00 .00 27,000.00 27,000.00 3.8% 500001 4843 WC REIMB 16,728.47 .00 .00 17.84 .00 .00 .0°% TOTAL MISCELLANEOUS REVENU 44,547.26 36,000.00 36,000.00 125,777.30 154,500.00 32,000.00 -11.1% TOTAL WATER FUND REVENUES 3,893,620.48 4,111,000.00 4,111,000.00 4,042,890.64 4,224,000.00 4,203,100.00 2.2% TOTAL WATER FUND 3,893,620.48 4,111,000.00 4,111,000.00 4,042,890.64 4,224,000.00 4,203,100.00 2.2% 00 0 0 000 - •;••!• mum' Financials, Revenue & citizen services and Human Capital Management 0 Iy:or erp solution 04/19/2012 09:18 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 SEWER FUND ACTUAL ORIG BUD REVISED BUD 540001 SEWER FUND REVENUES 42 LICENSES & PERMITS 2012 2012 ACTUAL PROJECTION PG 11 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 540001 4215 SWR PERM 12,200.00 12,000.00 12,000.00 11,600.00 12,000.00 12,000.00 .0s TOTAL LICENSES & PERMITS 12,200.00 12,000.00 12,000.00 11,600.00 12,000.00 12,000.00 .0s 44 CHARGES FOR SERVICES 540001 4451 C/S UB 2,450,088.01 2,425,000.00 2,425,000.00 2,460,341.52 2,440,000.00 2,667,500.00 10.0% 540001 4453 C/S UB PEN 29,019.33 32,000.00 32,000.00 26,488.44 30,000.00 30,000.00 -6.3% 540001 4495 C/S OTHER .00 2,000.00 2,000.00 .00 100.00 500.00 -75.0% TOTAL CHARGES FOR SERVICES 2,479,107.34 2,459,000.00 2,459,000.00 2,486,829.96 2,470,100.00 2,698,000.00 9.7% 46 INVESTMENT INCOME 540001 4610 INTER EARN 539.78 500.00 500.00 - 481.97 - 100.00 100.00 -80.0% 540001 4620 GAIN SALE - 148.97 .00 .00 .00 .00 .00 .0% 540001 4622 UNRLZD G/L -18.68 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 372.13 500.00 500.00 - 481.97 - 100.00 100.00 -80.0% 48 MISCELLANEOUS REVENU 540001 4810 MISC REV 600.00 5,000.00 5,000.00 7,651.00 8,000.00 5,000.00 .0% 540001 4834 AST CNTR 2,963,995.96 .00 .00 .00 .00 .00 .0 °6 540001 4843 WC REIMB 20,961.48 .00 .00 15,027.37 14,000.00 .00 .0% 540001 4844 INS REIMB .00 .00 .00 1,345.00 .00 .00 .0% TOTAL MISCELLANEOUS REVENU 2,985,557.44 5,000.00 5,000.00 24,023.37 22,000.00 5,000.00 .0% TOTAL SEWER FUND REVENUES 5,477,236.91 2,476,500.00 2,476,500.00 2,521,971.36 2,504,000.00 2,715,100.00 9.6% TOTAL SEWER FUND 5,477,236.91 2,476,500.00 2,476,500.00 2,521,971.36 2,504,000.00 2,715,100.00 9.66 ••::'• mum' Financials, Revenue & citizen Services and Human capital Management • • a ty ?er erp Solution 04/19/2012 09:18 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012/13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 REFUSE FUND ACTUAL ORIG BUD REVISED BUD 580001 REFUSE FUND REVENUES 41 TAXES 2012 2012 ACTUAL PROJECTION IPG 12 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 580001 4110 PROP TAX 832,263.84 883,428.00 883,428.00 900,834.08 883,000.00 905,500.00 2.5% TOTAL TAXES 832,263.84 883,428.00 883,428.00 900,834.08 883,000.00 905,500.00 2.5% 44 CHARGES FOR SERVICES 580001 4451 CIS UB 582,721.18 450,000.00 450,000.00 451,083.68 450,000.00 461,250.00 2.5% 580001 4453 CIS UB PEN 6,824.71 5,000.00 5,000.00 5,291.43 6,500.00 6,500.00 30.0% 580001 4454 CIS REF CN 18,929.00 18,900.00 18,900.00 17,091.55 18,900.00 19,400.00 2.6% TOTAL CHARGES FOR SERVICES 608,474.89 473,900.00 473,900.00 473,466.66 475,400.00 487,150.00 2.8% 46 INVESTMENT INCOME 580001 4610 INTER EARN 963.21 1,500.00 1,500.00 901.84 950.00 750.00 -50.0% 580001 4620 GAIN SALE - 278.85 .00 .00 .00 .00 .00 .0% 580001 4622 UNRLZD G/L -34.97 .00 .00 .00 .00 .00 .0% TOTAL INVESTMENT INCOME 649.39 1,500.00 1,500.00 901.84 950.00 750.00 -50.0% 48 MISCELLANEOUS REVENU 580001 4810 MISC REV 12,724.00 6,000.00 6,000.00 13,688.50 12,000.00 12,000.00 100.0% 580001 4835 RECYCLE .00 .00 .00 66,640.25 60,000.00 60,000.00 .0% TOTAL MISCELLANEOUS REVENU 12,724.00 6,000.00 6,000.00 80,328.75 72,000.00 72,000.00 1100.0% TOTAL REFUSE FUND REVENUES 1,454,112.12 1,364,828.00 1,364,828.00 1,455,531.33 1,431,350.00 1,465,400.00 7.4% TOTAL REFUSE FUND 1,454,112.12 1,364,828.00 1,364,828.00 1,455,531.33 1,431,350.00 1,465,400.00 7.4% •••••• •••_• m U n IS' Financials, Revenue & Citizen services and Human capital Management ` • a tyler erp solution 04/19/2012 09:18 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 COMMUTER PARKING FUND ACTUAL ORIG BUD REVISED BUD 600001 COMMUTER PARKING FUND REVENUES 44 CHARGES FOR SERVICES 600001 4440 C/S CPKMTR 600001 4441 CIS VPKMTR 600001 4442 CIS VPKPER 600001 4443 CIS CPKPER TOTAL CHARGES FOR SERVICES 46 INVESTMENT INCOME 600001 4610 INTER EARN 600001 4620 GAIN SALE 600001 4622 UNRLZD G/L TOTAL INVESTMENT INCOME TOTAL COMMUTER PARKING FUND TOTAL COMMUTER PARKING FUND 2012 2012 ACTUAL PROJECTION PG 13 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 50,328.76 80,000.00 80,000.00 46,773.75 50,000.00 50,000.00 -37.5% 34,973.99 28,000.00 28,000.00 31,179.86 32,000.00 32,000.00 14.3°% 88,722.00 88,000.00 88,000.00 89,337.50 88,000.00 88,000.00 .0% 30,211.00 31,000.00 31,000.00 30,868.00 30,000.00 30,000.00 -3.2% 204,235.75 227,000.00 227,000.00 198,159.11 200,000.00 200,000.00 -11.9% 4,951.42 4,000.00 4,000.00 3,791.55 3,200.00 3,200.00 -20.0% - 1,279.63 .00 .00 .00 .00 .00 .0% - 160.48 .00 .00 .00 .00 .00 .0% 3,511.31 4,000.00 4,000.00 3,791.55 3,200.00 3,200.00 - 20.0°% 207,747.06 231,000.00 231,000.00 201,950.66 203,200.00 203,200.00 -12.0% 207,747.06 231,000.00 231,000.00 201,950.66 203,200.00 203,200.00 -12.0% 00 0 0 00 •�• _. mum' Financials, Revenue &Citizen services and Human capital Management • a ty :er erp solution 04/19/2012 09:18 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012/13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 GARAGE FUND ACTUAL ORIG BUD REVISED BUD 700001 GARAGE FUND REVENUE 44 CHARGES FOR SERVICES 700001 4480 CIS FUNDS TOTAL CHARGES FOR SERVICES 46 INVESTMENT INCOME 700001 4610 INTER EARN 700001 4620 GAIN SALE 700001 4622 UNRLZD GIL TOTAL INVESTMENT INCOME 48 MISCELLANEOUS REVENU 700001 4810 MISC REV TOTAL MISCELLANEOUS REVENU TOTAL GARAGE FUND REVENUE TOTAL GARAGE FUND 2012 2012 ACTUAL PROJECTION IPG 14 bgnyrpta FOR PERIOD 99 2013 PCT ADOPTED CHANGE 371,747.20 385,000.00 385,000.00 318,275.79 385,000.00 385,000.00 .0% 371,747.20 385,000.00 385,000.00 318,275.79 385,000.00 385,000.00 .0% 779.06 500.00 500.00 644.20 650.00 500.00 .0% - 198.63 .00 .00 .00 .00 .00 .0% -24.91 .00 .00 .00 .00 .00 .0% 555.52 500.00 500.00 644.20 650.00 500.00 .0% 10,413.84 7,000.00 7,000.00 10,221.47 8,000.00 8,000.00 14.3% 10,413.84 7,000.00 7,000.00 10,221.47 8,000.00 8,000.00 14.31 382,716.56 392,500.00 392,500.00 329,141.46 393,650.00 393,500.00 .3% 382,716.56 392,500.00 392,500.00 329,141.46 393,650.00 393,500.00 .3% GRAND TOTAL 56,945,903.13 54,060,712.65 54,060,712.65 81,545,663.31 56,156,449.00 52,667,759.00 -2.6% ** END OF REPORT - Generated by Bob Fialkowski ** ••••!. m u n is' Financials, Revenue &Citizen Services and Human Capital Management !er • a tyter erp solution 04/19/2012 09:18 VILLAGE OF DEERFIELD 15 rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT POLICE PENSION FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 800001 POLICE PENSION FUND REVENUE 46 INVESTMENT INCOME 800001 4610 INTER EARN 540,389.07 600,000.00 600,000.00 559,324.25 600,000.00 600,000.00 .0% 800001 4612 NCHGFRVAL 2,380,319.09 500,000.00 500,000.00 2,448,338.97 500,000.00 500,000.00 .0% 800001 4620 GAIN SALE 663,216.49 .00 .00 203,299.41 .00 .00 .0% 800001 4622 UNRLZD G/L .00 .00 .00 137,663.30 .00 .00 .0% TOTAL INVESTMENT INCOME 3,583,924.65 1,100,000.00 1,100,000.00 3,348,625.93 1,100,000.00 1,100,000.00 .0% 48 MISCELLANEOUS REVENU 800001 4810 MISC REV .00 .00 .00 39,672.46 .00 .00 .0% 800001 4890 EMPR CONTB 1,350,132.00 1,000,000.00 1,000,000.00 860,228.00 1,000,000.00 1,000,000.00 .0% 800001 4891 EMPEE -CONT 364,078.27 390,000.00 390,000.00 522,649.08 445,000.00 410,000.00 5.1% TOTAL MISCELLANEOUS REVENU 1,714,210.27 1,390,000.00 1,390,000.00 1,422,549.54 1,445,000.00 1,410,000.00 1.4% TOTAL POLICE PENSION FUND RE 5,298,134.92 2,490,000.00 2,490,000.00 4,771,175.47 2,545,000.00 2,510,000.00 .8% TOTAL POLICE PENSION FUND 5,298,134.92 2,490,000.00 2,490,000.00 4,771,175.47 2,545,000.00 2,510,000.00 .8% GRAND TOTAL 56,945,903.13 54,060,712.65 54,060,712.65 81,545,663.31 56,156,449.00 52,667,759.00 -2.6% ** END OF REPORT - Generated by Bob Fialkowski ** 0 00 a •••_• m u n IS' Financials, Revenue & Citizen Services and Human Capital Management • a Wter erp sotuwn 04/19/2012 09:20 rfialkow PROJECTION: 20131 ACCOUNTS FOR: GENERAL FUND (VILLAGE OF DEERFIELD NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS FY 2012 /13 MASTER BUDGET PROJECTION 101111 FINANCE DEPARTMENT 51 PERSONNEL SERVICES 2011 2012 2012 2012 2012 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PG 1 bgnyrpte FOR PERIOD 99 2013 PCT ADOPTED CHANGE 101111 5110 REG SALAR 797,345.15 854,750.00 854,750.00 882,047.97 854,750.00 651,500.00 -23.8% 101111 5111 PT SALARY 3,122.50 4,500.00 4,500.00 3,710.50 3,800.00 4,500.00 .0% 101111 5112 OT SALARY 124.40 2,500.00 2,500.00 95.49 1,500.00 2,500.00 .0% 101111 5120 MED BNFT 152,403.65 163,500.00 163,500.00 157,047.84 159,000.00 161,000.00 -1.5% 101111 5121 DNTL BNFT 9,508.99 10,000.00 10,000.00 10,034.92 10,000.00 8,500.00 -15.0% 101111 5122 MISC BNFT 3,152.61 8,000.00 8,000.00 2,636.90 4,000.00 5,000.00 -37.5% 101111 5123 IPBC ADJ - 5,096.70 .00 .00 .00 .00 .00 .0% 101111 5130 APPAREL 179.91 500.00 500.00 234.83 300.00 500.00 .0% 101111 5140 PEN CNTRB 166,845.15 184,000.00 184,000.00 182,095.28 190,000.00 150,000.00 -16.5% TOTAL PERSONNEL SERVICES 1,127,585.66 1,227,750.00 1,227,750.00 1,237,903.73 1,223,350.00 983,500.00 -19.9% 52 TRAINING & DEVELOPME 101111 5210 TRNG REG 2,463.00 5,500.00 5,500.00 1,380.00 3,500.00 7,000.00 27.3% 101111 5211 TRNG TRAV 331.00 1,200.00 1,200.00 476.74 1,000.00 1,200.00 .0% 101111 5212 TRNG EXP 112.17 1,000.00 1,000.00 123.69 500.00 750.00 -25.0% 101111 5213 SUBSCRIPT 639.48 600.00 600.00 168.00 600.00 600.00 .0% TOTAL TRAINING & DEVELOPME 3,545.65 8,300.00 8,300.00 2,148.43 5,600.00 9,550.00 15.1% 53 CONTRACTUAL SERVICES 101111 5320 BLDG R &M 12,371.20 6,000.00 6,000.00 7,273.58 6,500.00 7,500.00 25.0% 101111 5322 EQUP R &M 6,626.13 6,200.00 6,200.00 7,576.50 9,263.00 10,250.00 65.39. 101111 5324 CEME R &M 13,995.29 10,000.00 10,000.00 10,922.38 14,000.00 15,000.00 50.0% 101111 5325 DOG PND 6,015.00 4,500.00 4,500.00 830.00 2,500.00 4,000.00 -11.1% 101111 5330 DUES 1,880.00 3,000.00 3,000.00 1,751.85 2,500.00 2,500.00 -16.7% 101111 5331 CNF MEET 2,997.02 5,500.00 5,500.00 2,686.06 4,200.00 5,000.00 -9.1% 101111 5332 TRAV EXP 2,202.45 3,500.00 3,500.00 1,747.77 3,500.00 3,500.00 .0% 101111 5335 PRINTING 3,261.59 5,000.00 5,000.00 3,747.50 4,000.00 4,500.00 -10.0% 101111 5336 LGL NOTICE 1,233.80 2,000.00 2,000.00 1,367.00 2,000.00 2,000.00 .0% 101111 5337 POSTAGE 5,131.09 5,500.00 5,500.00 4,439.52 4,500.00 5,000.00 -9.1% 101111 5350 INS GL 80,387.29 94,500.00 94,500.00 93,153.35 94,500.00 94,500.00 .0% 101111 5363 P/S MEDIC .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 101111 5365 P/S OTHER 46,399.14 57,700.00 57,700.00 88,527.16 90,000.00 59,000.00 2.3% 101111 5370 DP SERV 50,831.65 57,150.00 57,150.00 48,117.01 61,000.00 65,000.00 13.7°% 101111 5383 SENR PKDIS 104,058.00 130,000.00 130,000.00 108,633.00 130,000.00 130,000.00 .0% 101111 5384 TAXI SUBS 30,780.00 28,000.00 28,000.00 35,965.00 30,000.00 32,000.00 14.3% 0 0 5410 MISC SUPP 06 600 •V!6 m u n is Financials, Revenue & citizen Services and Human capital Management MATERIAL a ty;er erp sotumn 5440 w _ .'. 04/19/2012 09:20 OF DEERFIELD 101111 5460 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS 5470 PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION COMMODITIES -66.7% ACCOUNTS FOR: UTILITIES 2,500.00 902.71 1,500.00 2011 2012 2012 2012 GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL 101111 5386 FAMDYSEXP 60,569.65 65,000.00 65,000.00 56,995.37 101111 5395 ECON INCEN 1,444,733.62 1,400,000.00 2,150,000.00 2,099,748.04 TOTAL CONTRACTUAL SERVICES 1,873,472.92 1,884,550.00 2,634,550.00 2,573,481.09 54 COMMODITIES 11,750.00 14,500.00 -23.7% 101111 5410 MISC SUPP 101111 5421 MATERIAL 101111 5440 SMTLSEQUP 101111 5450 OFF SUPP 101111 5460 OPER SUPP 101111 5470 R&M SUPP TOTAL COMMODITIES -66.7% 55 UTILITIES 2,500.00 101111 5520 U/E NAT GA 101111 5530 U/E WATER 101111 5540 U/E TELEPH TOTAL UTILITIES 58 CAPITAL OUTLAY 101111 5810 OP EQP 101111 5830 OFC EQP TOTAL CAPITAL OUTLAY 72 TRANSFERS OUT (IFT) 101111 7210 TRNSFR OUT 101111 7211 TRANS VERF TOTAL TRANSFERS OUT (IFT) TOTAL FINANCE DEPARTMENT IPG 2 bgayrpte FOR PERIOD 99 2012 2013 PCT PROJECTION ADOPTED CHANGE 60,000.00 60,000.00 -7.7% 1,600,000.00 1,800,000.00 -16.3% 2,119,463.00 2,300,750.00 - 12.7°% 2,441.44 6,500.00 6,500.00 354.75 3,000.00 4,000.00 -38.5% 16.19 2,000.00 2,000.00 .00 500.00 1,000.00 -50.0% .00 1,500.00 1,500.00 102.47 250.00 500.00 -66.7% 1,010.80 2,500.00 2,500.00 902.71 1,500.00 2,000.00 - 20.0°% 3,635.29 4,000.00 4,000.00 6,597.14 4,000.00 4,500.00 12.5% 928.01 2,500.00 2,500.00 705.37 2,500.00 2,500.00 .0% 8,031.73 19,000.00 19,000.00 8,662.44 11,750.00 14,500.00 -23.7% 312.36 1,000.00 1,000.00 278.18 500.00 1,000.00 .0% 7,137.73 7,500.00 7,500.00 7,445.75 7,800.00 8,200.00 9.3% 10,634.49 11,500.00 11,500.00 9,973.94 10,900.00 11,500.00 .0% 18,084.58 20,000.00 20,000.00 17,697.87 19,200.00 20,700.00 3.5% 5,472.15 6,500.00 6,500.00 3,522.17 2,500.00 11,900.00 83.1°% 69.12 .00 .00 .00 .00 .00 .0% 5,541.27 6,500.00 6,500.00 3,522.17 2,500.00 11,900.00 83.1% 210,000.00 701,602.00 701,602.00 701,602.00 701,602.00 2,483,396.00 254.0% 34,667.00 34,667.00 34,667.00 34,667.00 34,667.00 34,667.00 .0% 244,667.00 736,269.00 736,269.00 736,269.00 736,269.00 2,518,063.00 242.0% 3,280,928.81 3,902,369.00 4,652,369.00 4,579,684.73 4,118,132.00 5,858,963.00 25.9% °•_• M u h i$' Financials, Revenue & Citizen services and Human capital Management x a tyter erp solution o x- 04/19/2012 09:20 (VILLAGE OF DEERFIELD IPG 3 rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpta PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 101210 ADMINISTRATION 51 PERSONNEL SERVICES 101210 5110 REG SALAR 277,309.80 280,000.00 280,000.00 321,229.06 322,000.00 503,333.00 79.8% 101210 5111 PT SALARY 90,704.25 75,000.00 75,000.00 30,982.95 31,500.00 7,000.00 -90.7% 101210 5112 OT SALARY .00 1,500.00 1,500.00 .00 1,500.00 .00 - 100.0% 101210 5120 MED BNFT 38,173.53 39,000.00 39,000.00 38,908.10 39,600.00 56,500.00 44.9% 101210 5121 DNTL BNFT 2,799.63 4,200.00 4,200.00 2,321.40 2,800.00 4,600.00 9.5% 101210 5122 MISC BNFT 1,411.86 10,000.00 10,000.00 1,417.32 10,000.00 10,000.00 .0% 101210 5140 PEN CNTRB 74,108.59 80,000.00 80,000.00 70,081.42 73,000.00 105,000.00 31.3% TOTAL PERSONNEL SERVICES 484,507.66 489,700.00 489,700.00 464,940.25 480,400.00 686,433.00 40.2% 52 TRAINING & DEVELOPME 101210 5210 TRNG REG 1,809.45 3,000.00 3,000.00 2,479.45 3,000.00 9,600.00 220.0% 101210 5211 TRNG TRAV 701.60 1,500.00 1,500.00 1,242.39 1,200.00 1,500.00 .0% 101210 5213 SUBSCRIPT 1,200.45 2,000.00 2,000.00 1,103.95 1,500.00 2,000.00 .0% TOTAL TRAINING & DEVELOPME 3,711.50 6,500.00 6,500.00 4,825.79 5,700.00 13,100.00 101.5°% 53 CONTRACTUAL SERVICES 101210 5320 BLDG R&M 51,698.68 25,000.00 25,000.00 16,840.50 19,476.00 23,776.00 -4.9% 101210 5322 EQUP R&M 10,783.69 6,500.00 6,500.00 4,304.72 6,663.00 8,700.00 33.8% 101210 5326 VEH MAINT 9.00 1,000.00 1,000.00 1,201.00 1,300.00 1,200.00 20.0% 101210 5330 DUES 20,402.40 20,000.00 20,000.00 20,468.75 20,525.00 21,350.00 6.8% 101210 5331 CNF MEET 255.51 4,000.00 4,000.00 1,138.35 2,000.00 5,000.00 25.0% 101210 5332 TRAV EXP 535.35 6,000.00 6,000.00 873.37 1,500.00 6,000.00 .0% 101210 5335 PRINTING 20,860.69 26,000.00 26,000.00 18,190.69 15,800.00 15,800.00 -39.2% 101210 5336 LGL NOTICE .00 600.00 600.00 105.60 600.00 600.00 .0% 101210 5337 POSTAGE 10,114.20 10,000.00 10,000.00 10,054.32 10,700.00 11,050.00 10.5% 101210 5360 P/S CRP CN 279,017.45 252,159.00 252,159.00 340,776.79 350,000.00 220,000.00 - 12.8°% 101210 5364 P/S CATV 11,465.00 28,000.00 28,000.00 15,471.00 16,940.00 21,290.00 -24.0% 101210 5365 P/S OTHER .00 .00 .00 .00 .00 10,000.00 .0°% 101210 5370 DP SERV 5,008.74 8,175.00 8,175.00 3,514.57 4,000.00 49,180.00 501.6% 101210 5382 HOUS ASST 5,500.00 12,000.00 12,000.00 8,250.00 12,000.00 10,500.00 -12.5% 101210 5387 ADV BOARD 57,415.19 120,000.00 120,000.00 98,253.10 99,400.00 114,300.00 -4.8% TOTAL CONTRACTUAL SERVICES 473,065.90 519,434.00 519,434.00 539,442.76 560,904.00 518,746.00 -.1% 54 COMMODITIES 101210 5410 MISC SUPP 716.91 1,500.00 1,500.00 56.81 300.00 1,000.00 -33.3% :.• . m u n * Financials, Revenue & Citizen services and Human Capital Management x ty:er erp solution 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012/13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 GENERAL FUND ACTUAL ORIG BUD REVISED BUD 101210 5420 PETR PROD 101210 5450 OFF SUPP 101210 5460 OPER SUPP 101210 5470 R &M SUPP TOTAL COMMODITIES 55 UTILITIES 101210 5540 U/E TELEPH TOTAL UTILITIES 58 CAPITAL OUTLAY 101210 5810 OP EQP 101210 5840 OFC FURN TOTAL CAPITAL OUTLAY 59 CAPITAL IMPROVEMENTS 101210 5914 STRSCP IMP TOTAL CAPITAL IMPROVEMENTS 72 TRANSFERS OUT (IFT) 101210 7211 TRANS VERF TOTAL TRANSFERS OUT (IFT) TOTAL ADMINISTRATION PG 4 bgnyrpta FOR PERIOD 99 2012 2012 2013 PCT ACTUAL PROJECTION ADOPTED CHANGE 494.11 1,000.00 1,000.00 689.34 700.00 800.00 -20.0% .00 1,000.00 1,000.00 299.72 100.00 500.00 - 50.0°% 1,272.34 1,500.00 1,500.00 85.00 200.00 1,000.00 -33.3% .00 500.00 500.00 .00 500.00 250.00 -50.0% 2,483.36 5,500.00 5,500.00 1,130.87 1,800.00 3,550.00 -35.5% 870.00 1,500.00 1,500.00 1,204.69 1,300.00 11300.00 -13.3% 870.00 1,500.00 1,500.00 1,204.69 1,300.00 1,300.00 -13.3% 227.28 5,100.00 5,100.00 5,504.00 9,200.00 24,750.00 385.3% .00 1,000.00 1,000.00 .00 1,000.00 500.00 -50.0% 227.28 6,100.00 6,100.00 5,504.00 10,200.00 25,250.00 313.9% 31,640.98 52,000.00 52,000.00 25,699.62 46,000.00 46,000.00 -11.5% 31,640.98 52,000.00 52,000.00 25,699.62 46,000.00 46,000.00 -11.5% 2,250.00 2,250.00 2,250.00 2,250.00 2,250.00 2,250.00 .0% 2,250.00 2,250.00 2,250.00 2,250.00 2,250.00 2,250.00 .0% 998,756.68 1,082,984.00 1,082,984.00 1,044,997.98 1,108,554.00 1,296,629.00 19.7% •ie °tee - •e•_• m u n is' Financials, Revenue & Citizen Services and Human Capital Management • x tyler Cra SOtuti0n '+ "" 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 2012 GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL 2012 PROJECTION ty !er IPG 5 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 101330 COMMUNITY DEVELOPMENT 51 PERSONNEL SERVICES 101330 5110 REG SALAR 589,910.48 636,525.00 636,525.00 606,316.51 625,196.00 655,620.68 3.0% 101330 5111 PT SALARY 19,311.50 25,625.00 25,625.00 19,911.48 20,567.04 20,567.04 -19.7% 101330 5112 OT SALARY 9,600.81 11,000.00 11,000.00 16,295.18 11,000.08 11,000.08 .0% 101330 5120 MED BNFT 101,903.93 117,000.00 117,000.00 107,653.87 107,000.00 119,500.00 2.196 101330 5121 DNTL BNFT 6,883.96 9,500.00 9,500.00 7,305.18 7,200.00 8,000.00 -15.8% 101330 5122 MISC BNFT 3,418.78 5,000.00 5,000.00 1,448.33 1,417.26 5,000.06 .0°% 101330 5130 APPAREL .00 1,000.00 1,000.00 841.90 1,005.00 1,005.00 .5% 101330 5140 PEN CNTRB 133,114.31 144,210.00 144,210.00 138,067.13 142,000.00 150,000.00 4.0% TOTAL PERSONNEL SERVICES 864,143.77 949,860.00 949,860.00 897,839.58 915,385.38 970,692.86 2.2% 52 TRAINING & DEVELOPME 101330 5211 TRNG TRAV 303.80 1,000.00 1,000.00 256.69 1,000.00 1,200.00 20.0% 101330 5212 TRNG EXP 5,876.33 6,000.00 6,000.00 1,947.77 3,000.00 5,500.00 -8.3% 101330 5213 SUBSCRIPT 692.84 1,000.00 1,000.00 612.15 500.00 500.00 -50.0% TOTAL TRAINING & DEVELOPME 6,872.97 8,000.00 8,000.00 2,816.61 4,500.00 7,200.00 -10.0% 53 CONTRACTUAL SERVICES 101330 5322 EQUP R &M 155.00 4,000.00 4,000.00 974.72 2,963.00 3,200.00 -20.0% 101330 5326 VEH MAINT 6,955.75 9,000.00 9,000.00 6,712.40 8,800.00 10,000.00 11.1% 101330 5330 DUES 1,210.25 2,000.00 2,000.00 1,373.00 2,400.00 2,400.00 20.0% 101330 5332 TRAV EXP 52.00 500.00 500.00 .00 800.00 1,000.00 100.0°% 101330 5335 PRINTING 2,813.93 5,000.00 5,000.00 2,596.47 5,000.00 5,000.00 .0% 101330 5336 LGL NOTICE 5,427.40 4,000.00 4,000.00 1,128.80 4,476.00 4,600.08 15.0% 101330 5337 POSTAGE 2,044.20 3,000.00 3,000.00 1,988.29 2,442.00 3,000.00 .0% 101330 5363 P/S MEDIC .00 600.00 600.00 .00 600.00 600.00 .0°% 101330 5365 P/S OTHER 89,530.70 81,000.00 81,000.00 72,215.50 74,749.00 85,489.00 5.5% 101330 5370 DP SERV 6,227.39 16,000.00 16,000.00 4,315.80 1,500.00 16,000.00 .0% TOTAL CONTRACTUAL SERVICES 114,416.62 125,100.00 125,100.00 91,304.98 103,730.00 131,289.08 4.9% 54 COMMODITIES 101330 5410 MISC SUPP 1,371.04 5,000.00 5,000.00 6,061.70 5,000.00 5,000.00 .0% 101330 5420 PETR PROD 3,218.15 4,700.00 4,700.00 3,638.27 4,114.00 4,700.04 .0% 101330 5450 OFF SUPP 1,061.28 3,500.00 3,500.00 1,600.29 2,000.00 3,000.00 -14.3% m u n is* Financials, Revenue & Citizen services and Human Capital Management tyler 8 tyter erp solution "' ' pp— ',echndcg;ejM 04/19/2012 09:20 OF DEERFIELD PG 6 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpta PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 101330 5460 OPER SUPP 4,247.58 5,500.00 5,500.00 5,168.57 6,083.00 5,500.00 .0% 101330 5470 R &M SUPP 323.53 1,500.00 1,500.00 152.89 1,500.00 1,500.00 .0% TOTAL COMMODITIES 10,221.58 20,200.00 20,200.00 16,621.72 18,697.00 19,700.04 -2.5% 55 UTILITIES 101330 5540 U/E TELEPH 5,350.07 6,500.00 6,500.00 5,075.77 6,500.00 6,500.04 .0% TOTAL UTILITIES 5,350.07 6,500.00 6,500.00 5,075.77 6,500.00 6,500.04 .0% 58 CAPITAL OUTLAY 101330 5810 OP EQP 385.83 1,750.00 1,750.00 1,000.00 991.00 13,999.00 699.9% TOTAL CAPITAL OUTLAY 385.83 1,750.00 1,750.00 1,000.00 991.00 13,999.00 699.9% 72 TRANSFERS OUT (IFT) 101330 7211 TRANS VERF 5,750.00 5,750.00 5,750.00 5,750.00 5,750.00 5,750.00 .0% TOTAL TRANSFERS OUT (IFT) 5,750.00 5,750.00 5,750.00 5,750.00 5,750.00 5,750.00 .0% TOTAL COMMUNITY DEVELOPMENT 1,007,140.84 1,117,160.00 1,117,160.00 1,020,408.66 1,055,553.38 1,155,131.02 3.4% •�. o m u n is Financials, Revenue & Citizen services and Human Capital Management • a tyler vp Solution ° - 04/19/2012 09:20 (VILLAGE OF DEERFIELD PG 7 rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 102010 STREET ADMINISTRATION 51 PERSONNEL SERVICES 102010 5110 REG SALAR 150,153.87 171,000.00 171,000.00 169,058.23 155,000.00 175,000.00 2.3% 102010 5111 PT SALARY 54.55 .00 .00 .00 .00 .00 .0% 102010 5112 OT SALARY 3,986.33 5,000.00 5,000.00 2,325.40 3,500.00 5,000.00 .0% 102010 5120 MED BNFT 29,351.32 34,500.00 34,500.00 36,606.36 36,000.00 39,000.00 13.0% 102010 5121 DNTL BNFT 1,721.39 3,000.00 3,000.00 2,303.62 2,400.00 3,000.00 .0% 102010 5122 MISC BNFT 1,376.52 1,000.00 1,000.00 14,765.08 15,000.00 2,500.00 150.0% 102010 5130 APPAREL 2,668.08 6,700.00 6,700.00 3,492.16 4,000.00 6,500.00 -3.0% 102010 5140 PEN CNTRB 32,347.16 40,000.00 40,000.00 35,238.29 37,000.00 40,000.00 .0% TOTAL PERSONNEL SERVICES 221,659.22 261,200.00 261,200.00 263,789.14 252,900.00 271,000.00 3.8% 52 TRAINING & DEVELOPME 102010 5210 TRNG REG 530.00 750.00 750.00 780.00 600.00 1,250.00 66.7% 102010 5211 TRNG TRAV .00 500.00 500.00 .00 100.00 500.00 .0°% 102010 5213 SUBSCRIPT .00 150.00 150.00 .00 150.00 150.00 .0% TOTAL TRAINING & DEVELOPME 530.00 1,400.00 1,400.00 780.00 850.00 1,900.00 35.7°% 53 CONTRACTUAL SERVICES 102010 5310 RENT EQP 93.50 .00 .00 .00 .00 .00 .0% 102010 5320 BLDG R &M 39,894.22 15,000.00 15,000.00 21,285.29 15,000.00 15,028.00 .2% 102010 5322 EQUP R &M 5,878.50 4,000.00 4,000.00 3,368.25 5,650.00 7,750.00 93.8% 102010 5326 VEH MAINT 4,222.30 5,000.00 5,000.00 4,123.70 5,000.00 5,000.00 .0% 102010 5330 DUES 1,359.25 1,400.00 1,400.00 462.40 1,400.00 1,400.00 .0% 102010 5332 TRAV EXP .00 500.00 500.00 .00 500.00 500.00 .0% 102010 5335 PRINTING 530.97 1,200.00 1,200.00 222.04 300.00 600.00 -50.0% 102010 5336 LGL NOTICE 151.20 500.00 500.00 347.20 400.00 250.00 -50.0% 102010 5337 POSTAGE 2,044.20 2,000.00 2,000.00 1,997.85 2,000.00 2,000.00 .0% 102010 5350 INS GL 127,925.77 147,000.00 147,000.00 147,562.96 147,000.00 147,000.00 .0% 102010 5351 INS DED 1,000.00 .00 .00 .00 .00 .00 .0% 102010 5363 P/S MEDIC 633.00 1,000.00 1,000.00 455.00 1,000.00 1,000.00 .0% 102010 5365 P/S OTHER 1,286.50 3,000.00 3,000.00 1,200.00 2,500.00 3,000.00 .0% 102010 5370 DP SERV 894.51 3,000.00 3,000.00 652.78 650.00 3,500.00 16.7% TOTAL CONTRACTUAL SERVICES 185,913.92 183,600.00 183,600.00 181,677.47 181,400.00 187,028.00 1.9% 54 COMMODITIES 102010 5410 MISC SUPP 910.60 2,500.00 2,500.00 218.30 200.00 500.00 -80.0% 0.000• •�•.• m U n IS' Financials, Revenue & citizen services and Human capital Management • a Wer erp sWution -. 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012/13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 GENERAL FUND ACTUAL ORIG BUD REVISED BUD 102010 5420 PETR PROD 1,058.66 102010 5421 MATERIAL 51.96 102010 5450 OFF SUPP 1,109.86 102010 5460 OPER SUPP 2,004.56 102010 5470 R &M SUPP .00 TOTAL COMMODITIES 5,135.64 55 UTILITIES 1,200.00 102010 5510 U/E ELECT 3,475.51 102010 5540 U/E TELEPH 5,115.96 TOTAL UTILITIES 8,591.47 58 CAPITAL OUTLAY 2,500.00 102010 5810 OP EQP 578.32 TOTAL CAPITAL OUTLAY 578.32 72 TRANSFERS OUT (IFT) 250.00 102010 7211 TRANS VERF 142,823.00 TOTAL TRANSFERS OUT (IFT) 142,823.00 TOTAL STREET ADMINISTRATION 565,231.57 IPG 8 bgnyrpta FOR PERIOD 99 2012 2012 2013 PCT ACTUAL PROJECTION ADOPTED CHANGE 2,000.00 2,000.00 2,301.33 2,000.00 2,000.00 .0% .00 .00 .00 .00 .00 .0s 1,200.00 1,200.00 673.12 1,200.00 1,200.00 .0% 2,500.00 2,500.00 2,841.31 2,500.00 2,500.00 .0% 250.00 250.00 .00 250.00 .00 - 100.0% 8,450.00 8,450.00 6,034.06 6,150.00 6,200.00 -26.6% 2,500.00 2,500.00 1,631.17 2,500.00 2,500.00 .0% 5,800.00 5,800.00 4,288.88 5,800.00 5,800.00 .0% 8,300.00 8,300.00 5,920.05 8,300.00 8,300.00 .0% 1,000.00 1,000.00 308.53 305.00 7,750.00 675.0% 1,000.00 1,000.00 308.53 305.00 7,750.00 675.0% 155,835.00 155,835.00 155,835.00 155,835.00 158,371.00 1.6% 155,835.00 155,835.00 155,835.00 155,835.00 158,371.00 1.6% 619,785.00 619,785.00 614,344.25 605,740.00 640,549.00 3.4% 0 o m u n i ' Financials, Revenue & Citizen services and Human Capital Management • a tyler erp solution 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 2012 GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL 2012 PROJECTION IPG 9 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 102036 STREET SNOW & ICE REMOVAL 51 PERSONNEL SERVICES 102036 5110 REG SALAR 16,706.51 35,000.00 35,000.00 .00 16,000.00 20,000.00 -42.9% 102036 5111 PT SALARY 200.00 1,500.00 1,500.00 .00 500.00 1,500.00 .0% 102036 5112 OT SALARY 111,198.22 80,000.00 80,000.00 33,792.71 80,000.00 80,000.00 .0% 102036 5120 MED BNFT 19,853.56 14,000.00 14,000.00 6,861.91 14,000.00 14,000.00 .0% 102036 5121 DNTL BNFT 1,279.57 750.00 750.00 443.61 750.00 750.00 .0% 102036 5122 MISC BNFT 112.37 500.00 500.00 34.29 100.00 250.00 -50.0% 102036 5140 PEN CNTRB 27,676.65 14,000.00 14,000.00 7,210.21 14,000.00 14,000.00 .0% TOTAL PERSONNEL SERVICES 177,026.88 145,750.00 145,750.00 48,342.73 125,350.00 130,500.00 -10.5% 53 CONTRACTUAL SERVICES 102036 5310 RENT EQP 7,860.41 2,500.00 2,500.00 1,550.00 4,000.00 4,000.00 60.0% 102036 5322 EQUP R &M 93,625.46 80,000.00 80,000.00 33,053.80 80,000.00 80,000.00 .0s 102036 5326 VEH MAINT 38,140.75 40,000.00 40,000.00 22,448.11 40,000.00 40,000.00 .0% 102036 5390 OTHER 72,561.25 13,000.00 13,000.00 7,926.00 13,000.00 15,000.00 15.4% TOTAL CONTRACTUAL SERVICES 212,187.87 135,500.00 135,500.00 64,977.91 137,000.00 139,000.00 2.6% 54 COMMODITIES 102036 5420 PETR PROD 21,218.68 14,000.00 14,000.00 10,991.53 14,000.00 14,000.00 .0% 102036 5421 MATERIAL 2,683.44 750.00 750.00 611.61 750.00 750.00 .0% 102036 5422 CHEMICAL 360,677.82 350,000.00 350,000.00 183,863.75 350,000.00 350,000.00 .0% 102036 5460 OPER SUPP 1,479.52 1,000.00 1,000.00 137.60 1,000.00 1,000.00 .0% 102036 5470 R&M SUPP 993.01 1,500.00 1,500.00 225.00 1,500.00 1,500.00 .0% TOTAL COMMODITIES 387,052.47 367,250.00 367,250.00 195,829.49 367,250.00 367,250.00 .0% 58 CAPITAL OUTLAY 102036 5810 OP EQP .00 750.00 750.00 .00 250.00 75.00 -90.0% TOTAL CAPITAL OUTLAY .00 750.00 750.00 .00 250.00 75.00 -90.0% TOTAL STREET SNOW & ICE REMO 776,267.22 649,250.00 649,250.00 309,150.13 629,850.00 636,825.00 -1.9% -- 00 • o �•� ❖ . mum' Financials, Revenue & Citizen Services and Human Capital Management • o tyzer erp swetion 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012/13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 GENERAL FUND ACTUAL ORIG BUD REVISED BUD 102037 STREET FORESTRY 51 PERSONNEL SERVICES 102037 5110 REG SALAR 102037 5112 OT SALARY 102037 5120 MED BNFT 102037 5121 DNTL BNFT 102037 5122 MISC BNFT 102037 5140 PEN CNTRB TOTAL PERSONNEL SERVICES 53 CONTRACTUAL SERVICES 102037 5322 EQUP R &M 102037 5326 VEH MAINT 102037 5365 P/S OTHER TOTAL CONTRACTUAL SERVICES 54 COMMODITIES 796.98 102037 5420 PETR PROD 102037 5421 MATERIAL 102037 5460 OPER SUPP 102037 5470 R &M SUPP TOTAL COMMODITIES 150.00 58 CAPITAL OUTLAY 102037 5810 OP EQP TOTAL CAPITAL OUTLAY 59 CAPITAL IMPROVEMENTS 102037 5914 STRSCP IMP TOTAL CAPITAL IMPROVEMENTS TOTAL STREET FORESTRY 2012 2012 ACTUAL PROJECTION PG 10 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 60.71 .00 .00 .00 .00 .00 .0% 3,138.24 4,000.00 4,000.00 14,108.42 14,200.00 4,000.00 .0% 796.98 2,000.00 2,000.00 2,489.18 3,000.00 4,000.00 100.0% 43.31 200.00 200.00 152.57 200.00 300.00 50.0% 3.90 150.00 150.00 11.97 100.00 100.00 - 33.3°% 705.26 1,000.00 1,000.00 3,010.04 4,000.00 4,500.00 350.0% 4,748.40 7,350.00 7,350.00 19,772.18 21,500.00 12,900.00 75.5% 16,730.40 15,000.00 15,000.00 12,785.35 15,000.00 15,000.00 .0% 14,989.10 13,000.00 13,000.00 16,644.70 15,000.00 13,000.00 .0% 139,688.48 170,000.00 170,000.00 316,494.11 330,000.00 170,000.00 .0% 171,407.98 198,000.00 198,000.00 345,924.16 360,000.00 198,000.00 .0°% 2,606.31 3,000.00 3,000.00 9,421.35 9,500.00 3,000.00 .0% 1,551.38 5,000.00 5,000.00 8,094.33 10,000.00 5,000.00 .0% 485.50 500.00 500.00 405.71 500.00 500.00 .0% 307.72 .00 .00 .00 .00 .00 .0% 4,950.91 8,500.00 8,500.00 17,921.39 20,000.00 81500.00 .0% 3,045.16 1,000.00 1,000.00 889.23 700.00 1,000.00 .0% 3,045.16 1,000.00 1,000.00 889.23 700.00 1,000.00 .0% 61,012.72 60,000.00 60,000.00 85,892.72 86,000.00 60,000.00 .0% 61,012.72 60,000.00 60,000.00 85,892.72 86,000.00 60,000.00 .0°% 245,165.17 274,850.00 274,850.00 470,399.68 488,200.00 280,400.00 2.0% •�•. M Uh I$ Financials, Revenue &Citizen Services and Human Capital Management F • a ty'.er erp solution -"'' _ -, .= } 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 2012 GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL 2012 PROJECTION 00 tectmdogiell IPG 11 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 102038 STREET TRAIN STATION MAINT 51 PERSONNEL SERVICES 102038 5110 REG SALAR 6,499.32 6,750.00 6,750.00 6,669.90 6,500.00 6,500.00 -3.7% 102038 5112 OT SALARY 188.69 .00 .00 .00 .00 .00 .0% 102038 5120 MED BNFT 746.53 2,000.00 2,000.00 776.33 2,000.00 2,000.00 .0% 102038 5121 DNTL BNFT 46.83 190.00 190.00 48.98 190.00 190.00 .0% 102038 5122 MISC BNFT 8.98 .00 .00 8.02 .00 .00 .0% 102038 5140 PEN CNTRB 1,447.58 1,760.00 1,760.00 1,447.80 1,760.00 1,760.00 .0% TOTAL PERSONNEL SERVICES 8,937.93 10,700.00 10,700.00 8,951.03 10,450.00 10,450.00 -2.3% 53 CONTRACTUAL SERVICES 102038 5320 BLDG R &M 19,613.70 25,000.00 25,000.00 32,947.94 26,000.00 25,000.00 .0% 102038 5321 STRUC R &M 21,666.82 30,000.00 30,000.00 29,424.59 30,000.00 25,000.00 - 16.7°% 102038 5322 EQUP R &M 1,297.00 2,000.00 2,000.00 998.02 2,000.00 2,000.00 .0% TOTAL CONTRACTUAL SERVICES 42,577.52 57,000.00 57,000.00 63,370.55 58,000.00 52,000.00 -8.8 %; 54 COMMODITIES 102038 5421 MATERIAL .00 1,500.00 1,500.00 63.24 300.00 500.00 - 66.7°% 102038 5460 OPER SUPP 2,702.71 2,000.00 2,000.00 3,921.62 3,000.00 3,000.00 50.0% 102038 5470 R &M SUPP 225.00 500.00 500.00 .00 500.00 .00 - 100.0°% TOTAL COMMODITIES 2,927.71 4,000.00 4,000.00 3,984.86 3,800.00 3,500.00 -12.5% 55 UTILITIES 102038 5550 U/E TELECM .00 500.00 500.00 .00 500.00 500.00 .0% TOTAL UTILITIES .00 500.00 500.00 .00 500.00 500.00 .01 TOTAL STREET TRAIN STATION M 54,443.16 72,200.00 72,200.00 76,306.44 72,750.00 66,450.00 -8.0% •• °• °° m u n is• Financials, Revenue & Citizen Services and Human Capital Management tyler • a ty:er erp solOw = ,..� 04/19/2012 09:20 OF DEERFIELD 12 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 102050 STREET MAINTENANCE 51 PERSONNEL SERVICES 102050 5110 REG SALAR 364,801.38 516,000.00 516,000.00 399,239.68 356,000.00 400,000.00 -22.5% 102050 5111 PT SALARY 20,911.88 18,000.00 18,000.00 23,898.27 24,000.00 18,000.00 .0% 102050 5112 OT SALARY 28,126.11 35,000.00 35,000.00 39,853.20 40,000.00 35,000.00 .0% 102050 5120 MED BNFT 80,892.71 110,000.00 110,000.00 107,996.49 108,000.00 116,600.00 6.0% 102050 5121 DNTL BNFT 5,189.07 7,000.00 7,000.00 6,799.89 6,800.00 7,350.00 5.0% 102050 5122 MISC BNFT 467.89 4,250.00 4,250.00 473.37 4,250.00 4,250.00 .0% 102050 5130 APPAREL 651.03 500.00 500.00 285.89 500.00 500.00 .0% 102050 5140 PEN CNTRB 84,055.51 101,200.00 101,200.00 95,770.94 101,000.00 105,000.00 3.8% TOTAL PERSONNEL SERVICES 585,095.58 791,950.00 791,950.00 674,317.73 640,550.00 686,700.00 -13.3% 53 CONTRACTUAL SERVICES 102050 5310 RENT EQP 5,715.75 6,000.00 6,000.00 9,219.63 10,000.00 6,000.00 .0% 102050 5322 EQUP R &M 11,403.75 15,000.00 15,000.00 29,881.46 10,000.00 15,000.00 .0% 102050 5326 VEH MAINT 15,966.53 25,000.00 25,000.00 28,893.95 20,000.00 20,000.00 -20.0% 102050 5365 P/S OTHER 66,927.83 55,000.00 55,000.00 55,054.70 55,000.00 55,000.00 .0°% TOTAL CONTRACTUAL SERVICES 100,013.86 101,000.00 101,000.00 123,049.74 95,000.00 96,000.00 -5.0% 54 COMMODITIES 102050 5410 MISC SUPP 1,994.12 2,000.00 2,000.00 2,195.32 2,000.00 2,000.00 .0% 102050 5420 PETR PROD 10,403.23 15,000.00 15,000.00 12,334.64 13,000.00 15,000.00 .0% 102050 5421 MATERIAL 63,648.39 50,000.00 50,000.00 71,611.29 65,000.00 65,000.00 30.0% 102050 5430 ST SIGNS 2,252.78 3,000.00 3,000.00 4,603.62 2,000.00 3,000.00 .0% 102050 5440 SMTLSEQUP 1,711.92 750.00 750.00 1,314.65 1,500.00 1,000.00 33.3% 102050 5470 R &M SUPP 405.13 2,500.00 2,500.00 2,388.28 2,000.00 2,500.00 .0% TOTAL COMMODITIES 80,415.57 73,250.00 73,250.00 94,447.80 85,500.00 88,500.00 20.8°% 55 UTILITIES 102050 5510 U/E ELECT 60,500.70 60,000.00 60,000.00 46,815.09 60,000.00 60,000.00 .0°% TOTAL UTILITIES 60,500.70 60,000.00 60,000.00 46,815.09 60,000.00 60,000.00 .0% 56 OTHER EXPENSES 102050 5611 PMTS OTHR 67,039.47 50,000.00 50,000.00 33,015.39 50,000.00 50,000.00 .0% •�•oso ��•_® m u n is• Financials, Revenue & Citizen Services and Human Capital Management tyler a tyter erp solution technclogies 04/19/2012 09:20 VILLAGE OF DEERFIELD 13 rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE TOTAL OTHER EXPENSES 67,039.47 50,000.00 50,000.00 33,015.39 50,000.00 50,000.00 .0% 59 CAPITAL IMPROVEMENTS 102050 5950 BLDNG IMP 8,026.56 2,500.00 2,500.00 1,412.35 2,500.00 2,500.00 .0% TOTAL CAPITAL IMPROVEMENTS 8,026.56 2,500.00 2,500.00 1,412.35 2,500.00 2,500.00 .0% TOTAL STREET MAINTENANCE 901,091.74 1,078,700.00 1,078,700.00 973,058.10 933,550.00 983,700.00 -8.8% •�• . m u n is Financials, Revenue & Citizen Services and Human Capital Management t tyler • a wer erp somtion �,- 04/19/2012 09:20 (VILLAGE OF DEERFIELD IPG 14 rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 102110 ENGINEERING DIVISION 51 PERSONNEL SERVICES 102110 5110 REG SALAR 174,214.09 188,000.00 188,000.00 186,392.70 188,000.00 197,000.00 4.8% 102110 5111 PT SALARY 17,405.05 25,000.00 25,000.00 21,294.00 25,000.00 25,000.00 .0% 102110 5112 OT SALARY 1,125.94 2,000.00 2,000.00 63.00 2,000.00 2,000.00 .0% 102110 5120 MED BNFT 40,016.95 42,000.00 42,000.00 41,846.68 42,000.00 44,600.00 6.2% 102110 5121 DNTL BNFT 2,337.29 2,800.00 2,800.00 2,470.68 2,500.00 2,900.00 3.6% 102110 5122 MISC BNFT 301.92 1,500.00 1,500.00 290.84 1,500.00 1,500.00 .0% 102110 5130 APPAREL 1,479.44 950.00 950.00 715.41 800.00 950.00 .0% 102110 5140 PEN CNTRB 38,443.31 44,000.00 44,000.00 41,749.32 44,000.00 46,000.00 4.5% TOTAL PERSONNEL SERVICES 275,323.99 306,250.00 306,250.00 294,822.63 305,800.00 319,950.00 4.5% 52 TRAINING & DEVELOPME 102110 5210 TRNG REG 1,592.21 3,000.00 3,000.00 540.00 3,000.00 4,250.00 41.7% 102110 5211 TRNG TRAV 1,867.73 1,500.00 1,500.00 255.04 1,500.00 1,500.00 .0% 102110 5213 SUBSCRIPT 140.00 200.00 200.00 .00 200.00 200.00 .0% TOTAL TRAINING & DEVELOPME 3,599.94 4,700.00 4,700.00 795.04 4,700.00 5,950.00 26.6% 53 CONTRACTUAL SERVICES 102110 5320 BLDG R &M .00 5,000.00 5,000.00 .00 5,000.00 5,000.00 .0% 102110 5322 EQUP R&M .00 3,000.00 3,000.00 697.29 7,177.00 8,000.00 166.7% 102110 5326 VEH MAINT 11,709.60 12,000.00 12,000.00 15,462.32 12,000.00 10,000.00 -16.7% 102110 5330 DUES 560.00 1,400.00 1,400.00 627.40 1,400.00 1,400.00 .0% 102110 5332 TRAV EXP 370.11 1,500.00 1,500.00 27.00 1,500.00 1,500.00 .0% 102110 5335 PRINTING 611.45 1,750.00 1,750.00 28.85 1,750.00 1,750.00 .0% 102110 5336 LGL NOTICE 280.80 500.00 500.00 93.60 500.00 500.00 .0% 102110 5337 POSTAGE 673.33 600.00 600.00 800.33 600.00 650.00 8.3% 102110 5350 INS GL 13,364.54 15,750.00 15,750.00 17,202.56 15,750.00 15,750.00 .0% 102110 5362 P/S ENG 40,755.50 30,000.00 30,000.00 20,472.50 30,000.00 30,000.00 .0% 102110 5363 P/S MEDIC .00 250.00 250.00 .00 250.00 250.00 .0% 102110 5365 P/S OTHER 4,518.43 5,000.00 5,000.00 .00 5,000.00 5,000.00 .0% 102110 5370 DP SERV 4,001.61 4,100.00 4,100.00 2,430.61 6,350.00 10,850.00 164.6% 102110 5375 GIS SERV 87,655.25 95,500.00 95,500.00 90,200.20 94,806.00 81,189.00 -15.0% TOTAL CONTRACTUAL SERVICES 164,500.62 176,350.00 176,350.00 148,042.66 182,083.00 171,839.00 -2.6% 54 COMMODITIES 102110 5410 MISC SUPP 1,618.16 3,500.00 3,500.00 1,413.07 3,500.00 3,500.00 .0% o ®oe •o• •�•_• m u n is• Financials, Revenue & Citizen Services and Human Capital Management tyler • a Syter erp solution .+x- 04/19/2012 09:20 OF DEERFIELD 15 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 102110 5420 PETR PROD 2,998.28 5,000.00 5,000.00 3,465.57 5,000.00 5,000.00 .0% 102110 5450 OFF SUPP 4,298.36 5,000.00 5,000.00 2,968.73 5,000.00 5,000.00 .0% 102110 5460 OPER SUPP 1,007.48 750.00 750.00 1,443.98 750.00 1,500.00 100.0% 102110 5470 R&M SUPP .00 .00 .00 .00 .00 1.00 .0% TOTAL COMMODITIES 9,922.28 14,250.00 14,250.00 9,291.35 14,250.00 15,001.00 5.3% 55 UTILITIES 102110 5540 U/E TELEPH 7,831.89 8,200.00 8,200.00 7,086.23 8,200.00 8,200.00 .0% TOTAL UTILITIES 7,831.89 8,200.00 8,200.00 7,086.23 8,200.00 8,200.00 .0% 58 CAPITAL OUTLAY 102110 5810 OP EQP 666.47 3,000.00 3,000.00 1,614.19 4,700.00 8,250.00 175.0% TOTAL CAPITAL OUTLAY 666.47 3,000.00 3,000.00 1,614.19 4,700.00 8,250.00 175.0% 72 TRANSFERS OUT (IFT) 102110 7211 TRANS VERF 13,657.00 13,865.00 13,865.00 13,865.00 13,865.00 11,401.00 -17.8% TOTAL TRANSFERS OUT (IFT) 13,657.00 13,865.00 13,865.00 13,865.00 13,865.00 11,401.00 -17.8% TOTAL ENGINEERING DIVISION 475,502.19 526,615.00 526,615.00 475,517.10 533,598.00 540,591.00 2.7% •�• ® Ill U it i$' Financials, Revenue & citizen services and Human capital Management • a tyter erp solution _ �,'.. jer 04/19/2012 09:20 (VILLAGE OF DEERFIELD IPG 16 rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 106010 POLICE DEPT ADMINISTRATION 51 PERSONNEL SERVICES 106010 5110 REG SALAR 534,572.92 576,893.00 576,893.00 542,969.04 594,196.00 604,196.00 4.7% 106010 5111 PT SALARY .00 1,500.00 1,500.00 .00 1,500.00 1,500.00 .0% 106010 5112 OT SALARY 1,061.28 3,500.00 3,500.00 1,535.80 3,500.00 3,500.00 .0% 106010 5120 MED BNFT 131,018.86 150,000.00 150,000.00 142,248.33 149,000.00 159,000.00 6.0% 106010 5121 DNTL BNFT 5,866.72 7,500.00 7,500.00 6,086.99 6,400.00 7,500.00 .0% 106010 5122 MISC BNFT 5,091.02 7,500.00 7,500.00 8,978.49 7,500.00 7,500.00 .0°% 106010 5130 APPAREL 2,165.23 5,500.00 5,500.00 2,667.80 5,500.00 5,500.00 .0°% 106010 5140 PEN CNTRB 173,045.85 165,000.00 165,000.00 130,491.58 142,200.00 173,000.00 4.8% TOTAL PERSONNEL SERVICES 852,821.88 917,393.00 917,393.00 834,978.03 909,796.00 961,696.00 4.8% 52 TRAINING & DEVELOPME 106010 5211 TRNG TRAV 3,133.72 10,000.00 10,000.00 5,455.80 10,000.00 10,000.00 .0% 106010 5212 TRNG EXP 1,570.00 6,000.00 6,000.00 3,024.75 4,600.00 6,600.00 10.0% 106010 5213 SUBSCRIPT 265.00 2,000.00 2,000.00 392.50 1,000.00 1,000.00 -50.0% TOTAL TRAINING & DEVELOPME 4,968.72 18,000.00 18,000.00 8,873.05 15,600.00 17,600.00 -2.2% 53 CONTRACTUAL SERVICES 106010 5320 BLDG R &M 52,763.17 65,000.00 65,000.00 34,478.75 62,720.00 62,720.00 -3.5% 106010 5322 EQUP R &M 23,622.92 27,500.00 27,500.00 22,874.18 33,390.00 36,000.00 30.9% 106010 5326 VEH MAINT 1,220.25 1,500.00 1,500.00 1,307.47 1,500.00 1,500.00 .0% 106010 5330 DUES 1,200.00 2,000.00 2,000.00 1,625.00 2,000.00 2,000.00 .0% 106010 5335 PRINTING 12,390.34 8,000.00 8,000.00 6,971.55 9,350.00 9,350.00 16.9% 106010 5336 LGL NOTICE .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0% 106010 5337 POSTAGE 3,391.72 4,000.00 4,000.00 2,984.30 4,000.00 4,000.00 .0% 106010 5350 INS GL 347,653.53 409,500.00 409,500.00 404,714.54 409,500.00 409,500.00 .0% 106010 5361 P/S PRSCTR 53,255.00 60,000.00 60,000.00 46,156.40 60,000.00 60,000.00 .0°% 106010 5363 P/S MEDIC 13,585.00 8,000.00 8,000.00 8,657.30 5,400.00 5,400.00 - 32.5°% 106010 5365 P/S OTHER 932.50 .00 .00 494.50 .00 .00 .0% 106010 5370 DP SERV 15,734.03 22,000.00 22,000.00 11,091.98 26,000.00 27,000.00 22.7% 106010 5387 ADV BOARD 21,000.95 20,000.00 20,000.00 19,594.06 20,000.00 20,000.00 .0% 106010 5388 EMER SERV 16,376.62 10,000.00 10,000.00 6,722.86 10,000.00 10,000.00 .0% 106010 5390 OTHER 40,017.18 48,000.00 48,000.00 35,813.40 48,000.00 48,000.00 .0% TOTAL CONTRACTUAL SERVICES 603,143.21 686,500.00 686,500.00 603,486.29 692,860.00 696,470.00 1.5% 54 COMMODITIES 106010 5410 MISC SUPP 417.00 1,500.00 1,500.00 282.74 1,500.00 1,500.00 .0% ••�•: °o m u n is, Financials, Revenue & citizen Services and Human capital Management #j !er a tyter erp woon .� . '•' ✓ rmclopes 04/19/2012 09:20 VILLAGE OF DEERFIELD 17 rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpta PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 106010 5420 PETR PROD 1,377.06 2,500.00 2,500.00 1,717.75 2,500.00 2,500.00 .0°% 106010 5450 OFF SUPP 7,274.79 9,000.00 9,000.00 7,049.79 9,000.00 9,000.00 .096 106010 5460 OPER SUPP 19,858.28 30,000.00 30,000.00 18,642.42 30,000.00 30,000.00 .0% 106010 5470 R &M SUPP 67.83 2,000.00 2,000.00 161.98 1,750.00 .00 - 100.00 TOTAL COMMODITIES 28,994.96 45,000.00 45,000.00 27,854.68 44,750.00 43,000.00 -4.4% 55 UTILITIES 106010 5550 U/E TELECM 14,642.35 20,000.00 20,000.00 13,512.79 20,000.00 18,200.00 -9.0% TOTAL UTILITIES 14,642.35 20,000.00 20,000.00 13,512.79 20,000.00 18,200.00 -9.0% 58 CAPITAL OUTLAY 106010 5810 OP EQP 6,926.04 17,550.00 17,550.00 13,369.37 19,850.00 14,100.00 -19.7% TOTAL CAPITAL OUTLAY 6,926.04 17,550.00 17,550.00 13,369.37 19,850.00 14,100.00 -19.7% 72 TRANSFERS OUT (IFT) 106010 7211 TRANS VERF 137,916.00 133,345.00 133,345.00 133,345.00 133,345.00 114,225.00 - 14.3°% TOTAL TRANSFERS OUT (IFT) 137,916.00 133,345.00 133,345.00 133,345.00 133,345.00 114,225.00 - 14.3°% TOTAL POLICE DEPT ADMINISTRA 1,649,413.16 1,837,788.00 1,837,788.00 1,635,419.21 1,836,201.00 1,865,291.00 1.5% • ••�� `o m u n is- Financials, Revenue & citizen Services and Human Capital Management ° o tyter erp solution 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 2012 GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL 2012 PROJECTION tyler IPG 18 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 106020 POLICE DEPT COMMUNICATIONS 51 PERSONNEL SERVICES 106020 5110 REG SALAR 549,085.68 579,781.00 579,781.00 561,378.85 579,781.00 597,175.00 3.0% 106020 5111 PT SALARY 17,873.17 40,000.00 40,000.00 33,063.77 40,000.00 40,000.00 .0% 106020 5112 OT SALARY 19,098.42 35,000.00 35,000.00 19,528.66 35,000.00 35,000.00 .0% 106020 5120 MED BNFT 95,236.96 102,000.00 102,000.00 98,571.71 100,000.00 108,000.00 5.9% 106020 5121 DNTL BNFT 5,959.12 8,500.00 8,500.00 6,200.77 6,300.00 8,000.00 -5.9% 106020 5122 MISC BNFT 876.96 5,000.00 5,000.00 1,058.55 5,000.00 5,000.00 .0% 106020 5130 APPAREL 1,136.18 2,800.00 2,800.00 844.25 2,800.00 2,800.00 .0% 106020 5140 PEN CNTRB 123,490.64 145,000.00 145,000.00 127,899.12 136,000.00 150,000.00 3.4% TOTAL PERSONNEL SERVICES 812,757.13 918,081.00 918,081.00 848,545.68 904,881.00 945,975.00 3.0% 52 TRAINING & DEVELOPME 106020 5211 TRNG TRAV 1,533.65 2,500.00 2,500.00 1,089.75 2,500.00 2,500.00 .0% 106020 5212 TRNG EXP 1,008.75 2,800.00 2,800.00 1,441.82 2,800.00 2,800.00 .0% 106020 5213 SUBSCRIPT 325.09 300.00 300.00 402.70 450.00 300.00 .0% TOTAL TRAINING & DEVELOPME 2,867.49 5,600.00 5,600.00 2,934.27 5,750.00 5,600.00 .0% 53 CONTRACTUAL SERVICES 106020 5330 DUES 367.00 500.00 500.00 182.00 500.00 500.00 .0% TOTAL CONTRACTUAL SERVICES 367.00 500.00 500.00 182.00 500.00 500.00 .0s 58 CAPITAL OUTLAY 106020 5810 OP EQP 1,839.42 5,000.00 5,000.00 3,876.30 5,000.00 5,000.00 .0% TOTAL CAPITAL OUTLAY 1,839.42 5,000.00 5,000.00 3,876.30 5,000.00 5,000.00 .0% TOTAL POLICE DEPT COMMUNICAT 817,831.04 929,181.00 929,181.00 855,538.25 916,131.00 957,075.00 3.0% o•:o: ®o mum' Financials, Revenue & Citizen Services and Human Capital Management • a tyter erp solution 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 2012 GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL 2012 PROJECTION IPG 19 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 106033 POLICE DEPT INVESTIGATIONS 51 PERSONNEL SERVICES 106033 5110 REG SALAR 627,637.76 652,802.00 652,802.00 630,352.75 646,233.00 660,403.00 1.2% 106033 5112 OT SALARY 50,660.42 55,000.00 55,000.00 41,981.88 55,000.00 55,000.00 .0% 106033 5120 MED BNFT 115,007.85 137,000.00 137,000.00 112,878.22 108,000.00 117,000.00 -14.6% 106033 5121 DNTL BNFT 6,581.42 8,000.00 8,000.00 6,492.13 6,200.00 7,500.00 -6.3% 106033 5122 MISC BNFT 760.46 5,000.00 5,000.00 568.28 5,000.00 5,000.00 .0% 106033 5130 APPAREL 3,987.87 6,500.00 6,500.00 5,529.19 5,250.00 5,250.00 -19.2% 106033 5140 PEN CNTRB 215,781.28 210,000.00 210,000.00 153,206.55 168,300.00 210,000.00 .0% TOTAL PERSONNEL SERVICES 1,020,417.06 1,074,302.00 1,074,302.00 951,009.00 993,983.00 1,060,153.00 -1.3% 52 TRAINING & DEVELOPME 106033 5211 TRNG TRAV 211.47 1,200.00 1,200.00 192.14 1,200.00 1,200.00 .0% 106033 5212 TRNG EXP 295.00 5,000.00 5,000.00 2,155.00 5,000.00 5,000.00 .0% 106033 5213 SUBSCRIPT 570.43 750.00 750.00 299.96 750.00 750.00 .0% TOTAL TRAINING & DEVELOPME 1,076.90 6,950.00 6,950.00 2,647.10 6,950.00 6,950.00 .0% 53 CONTRACTUAL SERVICES 106033 5326 VEH MAINT 4,885.20 6,000.00 6,000.00 5,866.10 6,000.00 6,000.00 .0% 106033 5330 DUES 645.00 1,000.00 1,000.00 680.00 1,000.00 1,000.00 .0% TOTAL CONTRACTUAL SERVICES 5,530.20 7,000.00 7,000.00 6,546.10 7,000.00 7,000.00 .0% 54 COMMODITIES 106033 5415 DARE PROG 5,365.28 10,000.00 10,000.00 4,969.66 10,000.00 10,000.00 .0% 106033 5420 PETR PROD 3,426.00 5,000.00 5,000.00 3,818.51 5,000.00 5,000.00 .0% TOTAL COMMODITIES 8,791.28 15,000.00 15,000.00 8,788.17 15,000.00 15,000.00 .0% 58 CAPITAL OUTLAY 106033 5810 OP EQP 2,480.37 8,000.00 8,000.00 6,710.73 5,000.00 5,000.00 -37.5% TOTAL CAPITAL OUTLAY 2,480.37 8,000.00 8,000.00 6,710.73 5,000.00 5,000.00 -37.5% TOTAL POLICE DEPT INVESTIGAT 1,038,295.81 1,111,252.00 1,111,252.00 975,701.10 1,027,933.00 1,094,103.00 -1.5% .•.••• �•• . m u n is Financials, Revenue & Citizen Services and Human Capital Management 0001- O.V. chnclol;,es tyler e tyer erp SOtution _��h� 04/19/2012 09:20 VILLAGE OF DEERFIELD IPG 20 rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 106034 POLICE DEPT PATROL 51 PERSONNEL SERVICES 106034 5110 REG SALAR 2,553,017.12 2,937,511.00 2,937,511.00 2,873,809.04 2,937,000.00 2,966,901.00 1.0% 106034 5111 PT SALARY 75,494.67 75,000.00 75,000.00 79,608.16 77,500.00 77,500.00 3.3% 106034 5112 OT SALARY 131,335.17 150,000.00 150,000.00 134,832.75 150,000.00 150,000.00 .0% 106034 5120 MED BNFT. 433,772.31 510,000.00 510,000.00 472,834.43 477,000.00 530,000.00 3.9% 106034 5121 DNTL BNFT 26,112.38 35,000.00 35,000.00 29,142.91 30,000.00 34,000.00 -2.9% 106034 5122 MISC BNFT 3,274.01 10,000.00 10,000.00 2,869.50 10,000.00 10,000.00 .0% 106034 5130 APPAREL 40,383.21 45,000.00 45,000.00 39,503.70 47,000.00 47,000.00 4.4% 106034 5140 PEN CNTRB 1,088,961.13 1,055,000.00 1,055,000.00 715,365.24 815,000.00 1,055,000.00 .0% TOTAL PERSONNEL SERVICES 4,352,350.00 4,817,511.00 4,817,511.00 4,347,965.73 4,543,500.00 4,870,401.00 1.1% 52 TRAINING & DEVELOPME 106034 5211 TRNG TRAV 2,006.56 5,000.00 5,000.00 2,631.80 5,000.00 5,000.00 .0% 106034 5212 TRNG EXP 19,746.00 25,000.00 25,000.00 21,316.00 25,000.00 25,000.00 .0% 106034 5213 SUBSCRIPT 82.50 900.00 900.00 800.00 900.00 900.00 .0% TOTAL TRAINING & DEVELOPME 21,835.06 30,900.00 30,900.00 24,747.80 30,900.00 30,900.00 .0% 53 CONTRACTUAL SERVICES 106034 5322 EQUP R &M 359.00 .00 .00 .00 .00 .00 .0% 106034 5326 VEH MAINT 45,241.38 65,000.00 65,000.00 67,294.34 65,000.00 65,000.00 .0% 106034 5330 DUES 968.00 1,000.00 1,000.00 871.78 1,000.00 1,000.00 .0% TOTAL CONTRACTUAL SERVICES 46,568.38 66,000.00 66,000.00 68,166.12 66,000.00 66,000.00 .0% 54 COMMODITIES 106034 5420 PETR PROD 58,040.21 70,000.00 70,000.00 70,389.10 70,000.00 70,000.00 .0% 106034 5460 OPER SUPP .00 5,000.00 5,000.00 5,102.32 5,000.00 5,000.00 .0% TOTAL COMMODITIES 58,040.21 75,000.00 75,000.00 75,491.42 75,000.00 75,000.00 .0% 55 UTILITIES 106034 5550 U/E TELECM 4,631.70 6,000.00 6,000.00 4,049.64 6,000.00 6,000.00 .0% TOTAL UTILITIES 4,631.70 6,000.00 6,000.00 4,049.64 6,000.00 6,000.00 .0% 58 CAPITAL OUTLAY 106034 5810 OP EQP 8,699.79 8,000.00 8,000.00 8,139.42 9,500.00 9,500.00 18.8% ��• o m u n iS* Financials, Revenue & citizen services and Human capital Management - o tyter erp solution teChndopeS 04/19/2012 09:20 OF DEERFIELD 21 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE TOTAL CAPITAL OUTLAY 8,699.79 8,000.00 8,000.00 8,139.42 9,500.00 9,500.00 18.8% TOTAL POLICE DEPT PATROL 4,492,125.14 5,003,411.00 5,003,411.00 4,528,560.13 4,730,900.00 5,057,801.00 1.1% •�•.• m u n i s' Financials, Revenue & Citizen Services and Human Capital Management. • a tyier erp solution 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012/13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 GENERAL FUND ACTUAL ORIG BUD REVISED BUD 106061 POLICE DEPT SPEC DETAIL 51 PERSONNEL SERVICES 106061 5112 OT SALARY 106061 5120 MED BNFT 106061 5121 DNTL BNFT 106061 5122 MISC BNFT 106061 5140 PEN CNTRB TOTAL PERSONNEL SERVICES TOTAL POLICE DEPT SPEC DETAI TOTAL GENERAL FUND .00 2012 2012 ACTUAL PROJECTION IPG 22 bgnyrpta FOR PERIOD 99 2013 PCT ADOPTED CHANGE 144,799.87 150,000.00 150,000.00 165,404.32 170,000.00 175,000.00 16.7% 21,366.26 28,000.00 28,000.00 25,529.50 32,000.00 32,000.00 14.3% 1,273.11 2,300.00 2,300.00 1,567.99 1,900.00 2,000.00 -13.0% 134.15 .00 .00 141.71 .00 .00 .0% 2,115.06 5,060.00 5,060.00 2,800.36 3,000.00 5,000.00 -1.2% 169,688.45 185,360.00 185,360.00 195,443.88 206,900.00 214,000.00 15.5% 169,688.45 185,360.00 185,360.00 195,443.88 206,900.00 214,000.00 15.5% 16,471,880.98 18,390,905.00 19,140,905.00 17,754,529.64 18,263,992.38 20,647,508.02 7.9% ��• . m u n is• Financials, Revenue & Citizen services and Human Capital Management tyler a tgter erp wutWn ..' °` -r- techmlogtes 04/19/2012 09:20 OF DEERFIELD PG 23 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT MOTOR FUEL TAX FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 142050 MOTOR FUEL TAX EXPENDITURES 59 CAPITAL IMPROVEMENTS 142050 5910 STREET IMP 490,000.00 490,000.00 490,000.00 475,591.65 490,000.00 490,000.00 .0% TOTAL CAPITAL IMPROVEMENTS 490,000.00 490,000.00 490,000.00 475,591.65 490,000.00 490,000.00 .0% TOTAL MOTOR FUEL TAX EXPENDI 490,000.00 490,000.00 490,000.00 475,591.65 490,000.00 490,000.00 .0% TOTAL MOTOR FUEL TAX FUND 490,000.00 490,000.00 490,000.00 475,591.65 490,000.00 490,000.00 .0% ••.•.!o m u h iS' Financials, Revenue & Citizen services and Human capital Management . • a Tyler erp solution 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 E 911 FUND ACTUAL ORIG BUD REVISED BUD 176020 E911 FUND EXPENDITURES 53 CONTRACTUAL SERVICES 176020 5323 RADIO R&M 176020 5370 DP SERV TOTAL CONTRACTUAL SERVICES 55 UTILITIES 176020 5550 U/E TELECM TOTAL UTILITIES 58 CAPITAL OUTLAY 176020 5820 RAD EQP TOTAL CAPITAL OUTLAY 72 TRANSFERS OUT (IFT) 176020 7210 TRNSFR OUT 176020 7211 TRANS VERF TOTAL TRANSFERS OUT (IFT) TOTAL E911 FUND EXPENDITURES TOTAL E 911 FUND 2012 2012 ACTUAL PROJECTION IPG 24 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 48,171.44 40,000.00 40,000.00 40,376.89 46,000.00 46,000.00 15.0% 64,366.58 75,600.00 75,600.00 74,283.28 76,000.00 76,000.00 .5% 112,538.02 115,600.00 115,600.00 114,660.17 122,000.00 122,000.00 5.5% 47,136.93 58,000.00 58,000.00 42,466.81 56,500.00 58,000.00 .0% 47,136.93 58,000.00 58,000.00 42,466.81 56,500.00 58,000.00 .0% 10,991.85 267,000.00 267,000.00 5,150.08 30,000.00 267,000.00 .0% 10,991.85 267,000.00 267,000.00 5,150.08 30,000.00 267,000.00 .0% .00 .00 .00 .00 .00 50,000.00 .0% 69,398.00 72,642.00 72,642.00 72,642.00 72,642.00 65,071.00 -10.4% 69,398.00 72,642.00 72,642.00 72,642.00 72,642.00 115,071.00 58.4% 240,064.80 513,242.00 513,242.00 234,919.06 281,142.00 562,071.00 9.5% 240,064.80 513,242.00 513,242.00 234,919.06 281,142.00 562,071.00 9.5% -- -- •• -.. a :�•_o m u n is Financials, Revenue & citizen Services and Human Capital Management je a ty:er erp Solution - lcrpes 04/19/2012 09:20 OF DEERFIELD 25 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT VEHICLE & EQUIPMENT REPLACE. ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 211150 VERF EXPENSES 56 OTHER EXPENSES 211150 5670 DEPR EXP 261,422.88 .00 .00 .00 .00 .00 .0% TOTAL OTHER EXPENSES 261,422.88 .00 .00 .00 .00 .00 .0°% 58 CAPITAL OUTLAY 211150 5810 OP EQP .00 45,000.00 45,000.00 19,470.00 45,000.00 210,000.00 366.7% 211150 5820 RAD EQP .00 165,000.00 165,000.00 .00 .00 .00 - 100.0% 211150 5830 OFC EQP .00 44,000.00 44,000.00 46,119.57 46,200.00 .00 - 100.0% 211150 5850 MBL EQP .00 .00 .00 .00 .00 113,500.00 .0% 211150 5860 MOTOR VEH 81,708.72 181,700.00 181,700.00 252,104.58 208,000.00 266,500.01 46.7% TOTAL CAPITAL OUTLAY 81,708.72 435,700.00 435,700.00 317,694.15 299,200.00 590,000.01 35.4°% TOTAL VERF EXPENSES 343,131.60 435,700.00 435,700.00 317,694.15 299,200.00 590,000.01 35.4% TOTAL VEHICLE & EQUIPMENT RE 343,131.60 435,700.00 435,700.00 317,694.15 299,200.00 590,000.01 35.4% •••❖ m u n is' Financials, Revenue & Citizen services and Human Capital Management ty !er • 0 ryter erp Solution 04/19/2012 09:20 OF DEERFIELD 26 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpta PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT INFRASTRUCTURE REPLACEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 222082 INFRA REPLACE FUND EXPENDITURE 53 CONTRACTUAL SERVICES 222082 5362 P/S ENG 491,501.88 3,061,000.00 3,061,000.00 1,703,625.78 2,135,630.00 2,540,000.00 -17.0% TOTAL CONTRACTUAL SERVICES 491,501.88 3,061,000.00 3,061,000.00 1,703,625.78 2,135,630.00 2,540,000.00 -17.0% 59 CAPITAL IMPROVEMENTS 222082 5910 STREET IMP 4,610,527.32 3,030,000.00 3,030,000.00 1,397,144.60 1,791,524.85 2,366,000.00 -21.9% 222082 5911 SDWLK IMP 99,808.01 290,000.00 290,000.00 313,274.28 390,000.00 .00 - 100.0% 222082 5941 STP IMP 2,808,980.33 15,000,000.00 15,000,000.00 14,255,924.30 15,000,000.00 14,000,000.00 -6.7% 222082 5990 OTHER CAP 267,825.63 2,620,000.00 2,620,000.00 1,515,734.31 1,689,032.00 790,000.00 -69.8% TOTAL CAPITAL IMPROVEMENTS 7,787,141.29 20,940,000.00 20,940,000.00 17,482,077.49 18,870,556.85 17,156,000.00 -18.1% TOTAL INFRA REPLACE FUND EXP 8,278,643.17 24,001,000.00 24,001,000.00 19,185,703.27 21,006,186.85 19,696,000.00 -17.9% TOTAL INFRASTRUCTURE REPLACE 8,278,643.17 24,001,000.00 24,001,000.00 19,185,703.27 21,006,186.85 19,696,000.00 -17.9% •�• . m u n is Financials, Revenue & Citizen Services and Human Capital Management • a ty'*er erp solution 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 BOND PROCEEDS FUND ACTUAL ORIG BUD REVISED BUD 237071 2010 BOND ISSUE 57 DEBT SERVICE 237071 5761 D/S ISS EX 50,084.18 TOTAL DEBT SERVICE 50,084.18 72 TRANSFERS OUT (IFT) 237071 7210 TRNSFR OUT 7,296,834.45 TOTAL TRANSFERS OUT (IFT) 7,296,834.45 TOTAL 2010 BOND ISSUE 7,346,918.63 2012 2012 ACTUAL PROJECTION PG 27 bgnyrpte FOR PERIOD 99 2013 PCT ADOPTED CHANGE .00 .00 .00 .00 .00 .0% .00 .00 .00 .00 .00 .06 .00 .00 17,549,289.66 .00 .00 .0 %; .00 .00 17,549,289.66 .00 .00 .0% .00 .00 17,549,289.66 .00 .00 .0% 0 00 0 •.••0o m u n is• Financials, Revenue & Citizen services and Human Capital Management • a iy:er crp sWuteor, tecnnCcges 04/19/2012 09:20 OF DEERFIELD 28 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpta PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT BOND PROCEEDS FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 237075 2011 A BOND ISSUE 57 DEBT SERVICE 237075 5761 D/S ISS EX .00 .00 .00 150,658.05 .00 .00 .0% TOTAL DEBT SERVICE .00 .00 .00 150,658.05 .00 .00 .0% TOTAL 2011 A BOND ISSUE .00 .00 .00 150,658.05 .00 .00 .0% •�•_o m u n is• Financials, Revenue & Citizen services and Human Capital Management ""ow ANA LOOP V • x ty:er erp somtion tectmoloptes 04/19/2012 09:20 VILLAGE OF DEERFIELD 29 rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT BOND PROCEEDS FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 237076 2011 B BOND ISSUE 57 DEBT SERVICE 237076 5761 D/S ISS EX .00 .00 .00 236,638.00 .00 .00 .0% TOTAL DEBT SERVICE .00 .00 .00 236,638.00 .00 .00 .0% TOTAL 2011 B BOND ISSUE .00 .00 .00 236,638.00 .00 .00 .0% TOTAL BOND PROCEEDS FUND 7,346,918.63 .00 .00 17,936,585.71 .00 .00 .0% ••:•: °o Mum Financials, Revenue & Citizen services and Human Capital Management � • e t�et erp sOtution - ' ":_ 04/19/2012 09:20 VILLAGE OF DEERFIELD 30 rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT DEBT SERVICE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 357070 DEBT SERVICE 2012 EXP 57 DEBT SERVICE 357070 5710 D/S INTER .00 .00 .00 .00 .00 182,593.00 .0% 357070 5760 D/S FA FEE .00 .00 .00 52,631.96 .00 1,000.00 .0% TOTAL DEBT SERVICE .00 .00 .00 52,631.96 .00 183,593.00 .0% TOTAL DEBT SERVICE 2012 EXP .00 .00 .00 52,631.96 .00 183,593.00 .0% I... mum' Financials, Revenue & Citizen services and Human Capital Managementw;�i a ty4er erp solution 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 2012 2012 DEBT SERVICE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION 357071 DEBT SERVICE 2008 EXP 57 DEBT SERVICE 357071 5710 D/S INTER 187,462.54 175,600.00 175,600.00 357071 5730 D/S PRINC 180,000.00 190,000.00 190,000.00 357071 5760 D/S FA FEE 450.00 2,000.00 2,000.00 TOTAL DEBT SERVICE 367,912.54 367,600.00 367,600.00 TOTAL DEBT SERVICE 2008 EXP 367,912.54 367,600.00 367,600.00 181,612.54 181,612.50 185,000.00 185,000.00 450.00 750.00 367,062.54 367,362.50 367,062.54 367,362.50 PG 31 bgnyrpta FOR PERIOD 99 2013 PCT ADOPTED CHANGE 169,425.00 -3.5% 195,000.00 2.6% 750.00 -62.5% 365,175.00 -.7% 365,175.00 -.7% 0 •�•e•� •�• ® m u n IS* Financials, Revenue & citizen services and Human capital Management • a tyter erp sotutm,� 04/19/2012 09:20 OF DEERFIELD 32 (VILLAGE rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT DEBT SERVICE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 357072 DEBT SERVICE 2011 EXP 57 DEBT SERVICE 357072 5710 D/S INTER .00 .00 .00 .00 .00 616,685.00 .0% 357072 5730 D/S PRINC .00 .00 .00 .00 .00 725,000.00 .0% 357072 5760 D/S FA FEE .00 .00 .00 .00 .00 2,000.00 .0% TOTAL DEBT SERVICE .00 .00 .00 .00 .00 1,343,685.00 .0% TOTAL DEBT SERVICE 2011 EXP .00 .00 .00 .00 .00 1,343,685.00 .0% O •• ®sv� •�•_• I11 U h I$' Financials, Revenue & Citizen Services and Human Capital Management • x tyfer erp sofution 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 DEBT SERVICE FUND ACTUAL ORIG BUD REVISED BUD 2012 2012 ACTUAL PROJECTION PG 33 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 357073 DEBT SERVICE 2010 EXP 57 DEBT SERVICE 357073 5710 D/S INTER .00 480,728.00 480,728.00 480,727.59 480,727.56 458,592.50 -4.6% 357073 5730 D/S PRINC .00 525,000.00 525,000.00 525,000.00 525,000.00 545,000.00 3.8% 357073 5760 D/S FA FEE .00 1,000.00 1,000.00 700.00 1,000.00 1,000.00 .0% TOTAL DEBT SERVICE .00 1,006,728.00 1,006,728.00 1,006,427.59 1,006,727.56 1,004,592.50 -.2% TOTAL DEBT SERVICE 2010 EXP .00 1,006,728.00 1,006,728.00 1,006,427.59 1,006,727.56 1,004,592.50 -.2% TOTAL DEBT SERVICE FUND 367,912.54 1,374,328.00 1,374,328.00 1,426,122.09 1,374,090.06 2,897,045.50 110.8% • 00 0 •�• ® mum* Financials, Revenue & Citizen Services and Human Capital Management • x W& erp SNOW 04/19/2012 09:20 rfialkow PROJECTION: 20131 ACCOUNTS FOR: WATER FUND (VILLAGE OF DEERFIELD NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS FY 2012 /13 MASTER BUDGET PROJECTION 502010 WATER DEPARTMENT ADMINISTRATIO 51 PERSONNEL SERVICES 502010 5110 REG SALAR 502010 5111 PT SALARY 502010 5112 OT SALARY 502010 5120 MED BNFT 502010 5121 DNTL BNFT 502010 5122 MISC BNFT 502010 5130 APPAREL 502010 5140 PEN CNTRB TOTAL PERSONNEL SERVICES 52 TRAINING & DEVELOPME 502010 5210 TRNG REG 502010 5211 TRNG TRAV TOTAL TRAINING & DEVELOPME 53 CONTRACTUAL SERVICES 502010 5320 BLDG R &M 502010 5322 EQUP R &M 502010 5326 VEH MAINT 502010 5330 DUES 502010 5332 TRAV EXP 502010 5335 PRINTING 502010 5337 POSTAGE 502010 5350 INS GL 502010 5362 P/S ENG 502010 5363 P/S MEDIC 502010 5365 P/S OTHER 502010 5370 DP SERV TOTAL CONTRACTUAL SERVICES 54 COMMODITIES .0% 502010 5410 MISC SUPP 502010 5420 PETR PROD 2011 2012 2012 2012 2012 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PG 34 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 212,548.29 225,000.00 225,000.00 228,075.85 225,000.00 232,000.00 3.1% .00 1,500.00 1,500.00 .00 1.00 .00 - 100.0°% 1,610.42 1,000.00 1,000.00 380.00 300.00 1,000.00 .0% 35,716.15 37,500.00 37,500.00 38,321.11 37,500.00 40,200.00 7.2% 2,384.07 2,100.00 2,100.00 2,642.10 2,500.00 2,700.00 28.6% 10,426.64 2,500.00 2,500.00 543.26 2,500.00 2,500.00 .0% 3,759.48 5,000.00 5,000.00 3,518.91 4,500.00 5,000.00 .0% 44,924.35 51,750.00 51,750.00 48,312.23 49,000.00 52,000.00 .5% 311,369.40 326,350.00 326,350.00 321,793.46 321,301.00 335,400.00 2.8% 408.00 1,400.00 1,400.00 550.00 700.00 1,650.00 17.9% 9.00 600.00 600.00 .00 600.00 450.00 -25.0% 417.00 2,000.00 2,000.00 550.00 1,300.00 2,100.00 5.0% 20,201.85 15,000.00 15,000.00 9,042.26 12,000.00 15,000.00 .0% 1,589.00 2,500.00 2,500.00 2,296.06 3,165.00 3,750.00 50.0% 259.00 5,000.00 5,000.00 521.00 1,000.00 5,000.00 .0% 1,207.25 1,400.00 1,400.00 462.40 1,400.00 1,400.00 .0% 115.00 750.00 750.00 51.00 100.00 100.00 -86.7% 3,589.67 3,500.00 3,500.00 3,093.33 3,500.00 3,500.00 .0% 8,183.07 8,000.00 8,000.00 7,696.61 8,000.00 8,000.00 .0% 122,309.69 143,139.15 143,139.15 143,417.82 143,139.15 143,139.15 .0% .00 500.00 500.00 .00 500.00 500.00 .0% 520.00 1,000.00 1,000.00 520.00 1,000.00 1,000.00 .0% 989.00 1,000.00 1,000.00 653.00 1,000.00 1,000.00 .0% 2,521.08 4,000.00 4,000.00 1,855.97 200.00 1,750.00 -56.3% 161,484.61 185,789.15 185,789.15 169,609.45 175,004.15 184,139.15 -.9% 649.96 1,500.00 1,500.00 154.65 1,000.00 1,000.00 -33.3% 1,360.08 2,500.00 2,500.00 2,628.64 2,500.00 2,500.00 .0% •��•'• m u n is' Financials, Revenue & Citizen services and Human Capital Management a tyler erp Solution^ 04/19/2012 09:20 VILLAGE OF DEERFIELD 35 rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpte PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 502010 5450 OFF SUPP 1,306.47 1,000.00 1,000.00 1,275.77 1,000.00 1,000.00 .0% 502010 5460 OPER SUPP 1,262.52 1,500.00 1,500.00 1,381.12 1,000.00 1,000.00 -33.3% 502010 5470 R &M SUPP 121.87 300.00 300.00 .00 1.00 .00 - 100.0% TOTAL COMMODITIES 4,700.90 6,800.00 6,800.00 5,440.18 5,501.00 5,500.00 -19.1% 55 UTILITIES 502010 5540 U/E TELEPH 9,082.36 10,700.00 10,700.00 8,576.01 10,700.00 10,700.00 .0% TOTAL UTILITIES 9,082.36 10,700.00 10,700.00 8,576.01 10,700.00 10,700.00 .0% 56 OTHER EXPENSES 502010 5670 DEPR EXP 368,697.31 .00 .00 .00 .00 .00 .0% TOTAL OTHER EXPENSES 368,697.31 .00 .00 .00 .00 .00 .0% 57 DEBT SERVICE 502010 5710 D/S INTER 39,117.50 31,125.00 31,125.00 31,125.00 31,125.00 16,275.00 - 47.7°% 502010 5730 D/S PRINC .00 450,000.00 450,000.00 450,000.00 450,000.00 465,000.00 3.3% 502010 5760 D/S FA FEE 400.00 1,000.00 1,000.00 400.00 1,000.00 1,000.00 .0% 502010 5761 D/S ISS EX 29,133.02 .00 .00 .00 .00 .00 .0% TOTAL DEBT SERVICE 68,650.52 482,125.00 482,125.00 481,525.00 482,125.00 482,275.00 .0% 58 CAPITAL OUTLAY 502010 5810 OP EQP 50.46 300.00 300.00 .00 1.00 2,250.00 650.0% TOTAL CAPITAL OUTLAY 50.46 300.00 300.00 .00 1.00 2,250.00 650.0°% 72 TRANSFERS OUT (IFT) 502010 7211 TRANS VERF 45,055.00 53,178.00 53,178.00 53,178.00 53,178.00 53,178.00 .0% TOTAL TRANSFERS OUT (IFT) 45,055.00 53,178.00 53,178.00 53,178.00 53,178.00 53,178.00 .0% TOTAL WATER DEPARTMENT ADMIN 969,507.56 1,067,242.15 1,067,242.15 1,040,672.10 1,049,110.15 1,075,542.15 .8% ••:; m um' is' Financials, Revenue & citizen Services and Human capital Management a • a ty t erp solution 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 WATER FUND ACTUAL ORIG BUD REVISED BUD 502031 WATER DEPT DISTRIBUTION 51 PERSONNEL SERVICES 2012 2012 ACTUAL PROJECTION IPG 36 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 502031 5110 REG SALAR 78,481.44 73,000.00 73,000.00 76,498.04 73,000.00 75,000.00 2.7% 502031 5112 OT SALARY 10,254.00 10,000.00 10,000.00 5,864.35 10,000.00 10,000.00 .0% 502031 5120 MED BNFT 17,137.97 20,500.00 20,500.00 17,541.15 17,900.00 20,500.00 .0% 502031 5121 DNTL BNFT 975.12 1,200.00 1,200.00 1,003.62 1,100.00 1,200.00 .0% 502031 5122 MISC BNFT 80.41 1,300.00 1,300.00 69.75 1,300.00 1,300.00 .09. 502031 5140 PEN CNTRB 17,690.44 19,550.00 19,550.00 17,667.91 19,550.00 20,500.00 4.9% TOTAL PERSONNEL SERVICES 124,619.38 125,550.00 125,550.00 118,644.82 122,850.00 128,500.00 2.3% 53 CONTRACTUAL SERVICES 502031 5320 BLDG R &M 5,413.58 5,500.00 5,500.00 6,790.00 7,000.00 7,500.00 36.4°% 502031 5322 EQUP R &M 11,768.81 15,000.00 15,000.00 7,807.56 7,500.00 15,000.00 .0% 502031 5326 VEH MAINT 2,179.80 3,000.00 3,000.00 693.50 1,500.00 3,000.00 .0% 502031 5335 PRINTING .00 350.00 350.00 .00 1.00 .00 - 100.0°% 502031 5362 P/S ENG 19,188.09 15,000.00 15,000.00 22,272.29 23,000.00 .00 - 100.0% 502031 5365 P/S OTHER 5,242.40 4,500.00 4,500.00 126,433.16 130,000.00 4,500.00 .0°% TOTAL CONTRACTUAL SERVICES 43,792.68 43,350.00 43,350.00 163,996.51 169,001.00 30,000.00 -30.8% 54 COMMODITIES 502031 5410 MISC SUPP 427.44 500.00 500.00 .00 500.00 500.00 .0% 502031 5420 PETR PROD 367.92 500.00 500.00 648.12 650.00 600.00 20.0% 502031 5421 MATERIAL 939.40 1,000.00 1,000.00 1,265.61 500.00 500.00 -50.0% 502031 5422 CHEMICAL .00 500.00 500.00 .00 500.00 500.00 .0% 502031 5423 BUY WATER 2,081,430.37 2,050,000.00 2,050,000.00 1,844,524.58 2,050,000.00 2,050,000.00 .0% 502031 5460 OPER SUPP 230.00 700.00 700.00 .00 150.00 300.00 - 57.1°% TOTAL COMMODITIES 2,083,395.13 2,053,200.00 2,053,200.00 1,846,438.31 2,052,300.00 2,052,400.00 .0% 55 UTILITIES 502031 5510 U/E ELECT 96,174.40 90,000.00 90,000.00 83,912.26 90,000.00 90,000.00 .0% TOTAL UTILITIES 96,174.40 90,000.00 90,000.00 83,912.26 90,000.00 90,000.00 .0% 58 CAPITAL OUTLAY 502031 5810 OP EQP 1,023.86 20,000.00 20,000.00 .00 20,000.00 10,000.00 -50.0% ��• e m U n iS' Financials, Revenue & citizen Services and Human capital Management tyler a tyter erp sotution 04/19/2012 09:20 OF DEERFIELD 37 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE TOTAL CAPITAL OUTLAY 1,023.86 20,000.00 20,000.00 .00 20,000.00 10,000.00 - 50.0°% TOTAL WATER DEPT DISTRIBUTIO 2,349,005.45 2,332,100.00 2,332,100.00 2,212,991.90 2,454,151.00 2,310,900.00 -.9% so 0 9 ••9 ••••!• mum* Financials, Revenue a citizen services and Human capital Management • a tyer erp solution - 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012/13 MASTER BUDGET PROJECTION ACCOUNTS FOR: PG 38 bgnyrpts FOR PERIOD 99 2011 2012 2012 2012 2012 2013 PCT WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 502050 WATER MAIN MAINTENANCE 51 PERSONNEL SERVICES 502050 5110 REG SALAR 234,014.96 205,000.00 205,000.00 205,615.69 205,000.00 205,000.00 .09- 502050 5111 PT SALARY 8,490.00 5,000.00 5,000.00 4,116.25 5,000.00 6,000.00 20.0% 502050 5112 OT SALARY 63,134.32 50,000.00 50,000.00 39,160.91 50,000.00 50,000.00 .0°% 502050 5120 MED BNFT 66,153.09 78,000.00 78,000.00 57,080.03 57,000.00 72,000.00 -7.7% 502050 5121 DNTL BNFT 4,153.36 5,500.00 5,500.00 3,658.81 3,800.00 5,000.00 -9.1% 502050 5122 MISC BNFT 353.95 2,100.00 2,100.00 255.81 2,100.00 2,100.00 .0°% 502050 5140 PEN CNTRB 62,543.45 70,384.60 70,384.60 53,073.63 57,000.00 65,000.00 -7.7% TOTAL PERSONNEL SERVICES 438,843.13 415,984.60 415,984.60 362,961.13 379,900.00 405,100.00 -2.6% 53 CONTRACTUAL SERVICES 502050 5310 RENT EQP 1,050.40 2,500.00 2,500.00 .00 400.00 1,200.00 -52.0% 502050 5321 STRUC R &M 955.77 1,000.00 1,000.00 .00 1.00 .00 - 100.0°% 502050 5322 EQUP R&M 10,413.20 7,000.00 7,000.00 8,875.95 8,000.00 10,000.00 42.996 502050 5326 VEH MAINT 19,853.34 17,000.00 17,000.00 28,880.10 23,000.00 20,000.00 17.6% 502050 5362 P/S ENG 2,492.95 5,000.00 5,000.00 1,965.25 5,000.00 5,000.00 .0% 502050 5365 P/S OTHER 31,924.81 53,500.00 53,500.00 26,363.87 53,000.00 60,000.00 12.1°% TOTAL CONTRACTUAL SERVICES 66,690.47 86,000.00 86,000.00 66,085.17 89,401.00 96,200.00 11.9% 54 COMMODITIES 502050 5410 MISC SUPP 1,189.11 2,000.00 2,000.00 1,734.02 2,000.00 2,000.00 .0% 502050 5420 PETR PROD 9,294.97 9,000.00 9,000.00 10,607.40 9,000.00 9,000.00 .0% 502050 5421 MATERIAL 145,304.69 100,000.00 100,000.00 213,005.31 100,000.00 100,000.00 .0% 502050 5440 SMTLSEQUP 507.22 1,200.00 1,200.00 960.25 1,200.00 1,200.00 .0% TOTAL COMMODITIES 156,295.99 112,200.00 112,200.00 226,306.98 112,200.00 112,200.00 .0% 58 CAPITAL OUTLAY 502050 5810 OP EQP 867.00 2,000.00 2,000.00 629.00 2,000.00 2,000.00 .0% TOTAL CAPITAL OUTLAY 867.00 2,000.00 2,000.00 629.00 2,000.00 2,000.00 .0% TOTAL WATER MAIN MAINTENANCE 662,696.59 616,184.60 616,184.60 655,982.28 583,501.00 615,500.00 -.1% 000 - -- i% m u n is• Financials, Revenue & citizen Services and Human capital Management a tyler erp solution �- ,.'' 04/19/2012 09:20 VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 WATER FUND ACTUAL ORIG BUD REVISED BUD - °. `` 2012 ACTUAL 2012 PROJECTION 00 'echnClopes IPG 39 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 502054 WATER METER MAINTENANCE 51 PERSONNEL SERVICES 502054 5110 REG SALAR 114,603.28 124,000.00 124,000.00 122,251.30 124,000.00 124,000.00 .0% 502054 5112 OT SALARY 1,474.29 2,000.00 2,000.00 2,007.29 2,000.00 2,000.00 .0% 502054 5120 MED BNFT 13,031.52 16,000.00 16,000.00 14,442.63 14,800.00 16,000.00 .0% 502054 5121 DNTL BNFT 816.62 1,500.00 1,500.00 909.24 1,100.00 1,500.00 .0% 502054 5122 MISC BNFT 158.66 500.00 500.00 147.52 500.00 500.00 .0% 502054 5140 PEN CNTRB 24,989.16 28,750.00 28,750.00 26,995.50 28,500.00 30,200.00 5.0% TOTAL PERSONNEL SERVICES 155,073.53 172,750.00 172,750.00 166,753.48 170,900.00 174,200.00 .8% 53 CONTRACTUAL SERVICES 502054 5322 EQUP R &M 246.99 1,500.00 1,500.00 1,297.00 1,500.00 1,500.00 .0% 502054 5326 VEH MAINT 6,919.00 3,500.00 3,500.00 3,763.35 3,500.00 3,500.00 .0% 502054 5332 TRAV EXP .00 300.00 300.00 .00 1.00 .00 - 100.0% 502054 5335 PRINTING .00 300.00 300.00 .00 .00 .00 - 100.0% 502054 5365 P/S OTHER .00 2,500.00 2,500.00 10,379.95 12,000.00 22,000.00 780.0% TOTAL CONTRACTUAL SERVICES 7,165.99 8,100.00 8,100.00 15,440.30 17,001.00 27,000.00 233.3% 54 COMMODITIES 502054 5410 MISC SUPP .00 500.00 500.00 179.20 500.00 500.00 .0% 502054 5420 PETR PROD 3,822.99 4,500.00 4,500.00 5,165.70 4,500.00 4,500.00 .0% 502054 5421 MATERIAL .00 500.00 500.00 242.57 100.00 300.00 -40.0% 502054 5440 SMTLSEQUP .00 100.00 100.00 29.36 100.00 100.00 .0% TOTAL COMMODITIES 3,822.99 5,600.00 5,600.00 5,616.83 5,200.00 5,400.00 -3.6% 58 CAPITAL OUTLAY 502054 5810 OP EQP 68,208.55 202,000.00 202,000.00 207,762.20 202,000.00 223,000.00 10.4% TOTAL CAPITAL OUTLAY 68,208.55 202,000.00 202,000.00 207,762.20 202,000.00 223,000.00 10.4% TOTAL WATER METER MAINTENANC 234,271.06 388,450.00 388,450.00 395,572.81 395,101.00 429,600.00 10.6°% TOTAL WATER FUND 4,215,480.66 4,403,976.75 4,403,976.75 4,305,219.09 4,481,863.15 4,431,542.15 .6% b•°'o 111 V h I$ Financials, Revenue & Citizen Services and Human Capital Management �}. ty a tyter erp solution - ,,,. a 'jer 04/19/2012 09:20 (VILLAGE OF DEERFIELD IPG 40 rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 542010 SEWER ADMINISTRATION 51 PERSONNEL SERVICES 542010 5110 REG SALAR 145,762.52 171,000.00 171,000.00 164,494.43 150,000.00 165,000.00 -3.5% 542010 5112 OT SALARY 316.37 .00 .00 47.97 100.00 .00 .0% 542010 5120 MED BNFT 28,240.77 27,000.00 27,000.00 34,927.53 35,100.00 37,500.00 38.9% 542010 5121 DNTL BNFT 1,607.53 2,000.00 2,000.00 2,132.51 2,200.00 2,200.00 10.0% 542010 5122 MISC BNFT 5,914.97 1,000.00 1,000.00 657.11 1,000.00 1,000.00 .0°% 542010 5130 APPAREL 4,159.57 5,000.00 5,000.00 2,553.38 2,500.00 2,500.00 -50.0% 542010 5140 PEN CNTRB 29,756.11 38,000.00 38,000.00 34,626.77 35,500.00 37,800.00 -.5% TOTAL PERSONNEL SERVICES 215,757.84 244,000.00 244,000.00 239,439.70 226,400.00 246,000.00 .8% 52 TRAINING & DEVELOPME 542010 5210 TRNG REG 388.00 600.00 600.00 1,076.26 1,000.00 600.00 .0% 542010 5211 TRNG TRAV 18.00 1,100.00 1,100.00 404.16 600.00 800.00 -27.3% 542010 5213 SUBSCRIPT .00 200.00 200.00 .00 200.00 .00 - 100.0% TOTAL TRAINING & DEVELOPME 406.00 1,900.00 1,900.00 1,480.42 1,800.00 1,400.00 -26.3% 53 CONTRACTUAL SERVICES 542010 5320 BLDG R &M 12,987.26 15,000.00 15,000.00 8,544.24 6,500.00 15,000.00 .0% 542010 5322 EQUP R &M 1,982.25 1,200.00 1,200.00 759.14 800.00 1,200.00 .0% 542010 5326 VEH MAINT 6,533.00 6,000.00 6,000.00 1,833.45 2,500.00 6,000.00 .0% 542010 5330 DUES 1,072.25 1,400.00 1,400.00 463.40 700.00 1,400.00 .0°% 542010 5332 TRAV EXP .00 800.00 800.00 .00 200.00 400.00 -50.0% 542010 5335 PRINTING 2,784.22 2,000.00 2,000.00 1,381.07 2,500.00 2,500.00 25.0% 542010 5337 POSTAGE 4,416.91 4,400.00 4,400.00 4,197.51 4,400.00 4,400.00 .0% 542010 5350 INS GL 161,360.42 194,250.00 194,250.00 192,610.90 194,250.00 194,250.00 .0% 542010 5363 P/S MEDIC 503.00 1,200.00 1,200.00 390.00 400.00 700.00 -41.7% 542010 5365 P/S OTHER .00 .00 .00 412.50 500.00 500.00 .0% 542010 5370 DP SERV 2,003.19 2,500.00 2,500.00 1,472.64 2,500.00 2,500.00 .0% TOTAL CONTRACTUAL SERVICES 193,642.50 228,750.00 228,750.00 212,064.85 215,250.00 228,850.00 .0% 54 COMMODITIES 542010 5410 MISC SUPP 1,186.41 1,500.00 1,500.00 154.65 300.00 800.00 - 46.7°% 542010 5420 PETR PROD 2,048.15 2,500.00 2,500.00 2,968.85 2,500.00 2,500.00 .0% 542010 5450 OFF SUPP 885.81 500.00 500.00 693.99 500.00 500.00 .05. o - 00 0 •�•.• m u n is Financials, Revenue & citizen Services and Human capital Management • a iyter erp solution '`r '� 04/19/2012 09:20 VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 2012 SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL 2012 PROJECTION IPG 41 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 542010 5460 OPER SUPP 1,227.34 2,000.00 2,000.00 1,321.39 2,000.00 2,000.00 .0% TOTAL COMMODITIES 5,347.71 6,500.00 6,500.00 5,138.88 5,300.00 5,800.00 -10.8% 55 UTILITIES 542010 5540 U/E TELEPH 3,427.35 4,600.00 4,600.00 3,378.01 4,600.00 4,600.00 .0% TOTAL UTILITIES 3,427.35 4,600.00 4,600.00 3,378.01 4,600.00 4,600.00 .0% 56 OTHER EXPENSES 542010 5670 DEPR EXP 275,441.31 .00 .00 .00 .00 .00 .0% TOTAL OTHER EXPENSES 275,441.31 .00 .00 .00 .00 .00 .0% 58 CAPITAL OUTLAY 542010 5810 OP EQP 93.00 750.00 750.00 .00 750.00 .00 - 100.0°% TOTAL CAPITAL OUTLAY 93.00 750.00 750.00 .00 750.00 .00 - 100.0% 72 TRANSFERS OUT (IFT) 542010 7211 TRANS VERF 54,929.00 55,776.00 55,776.00 55,776.00 55,776.00 55,776.00 .0% TOTAL TRANSFERS OUT (IFT) 54,929.00 55,776.00 55,776.00 55,776.00 55,776.00 55,776.00 .0°% TOTAL SEWER ADMINISTRATION 749,044.71 542,276.00 542,276.00 517,277.86 509,876.00 542,426.00 .0% • •• °•'® m u n is• Financials, Revenue & citizen Services and Human capital Management • a t ter of solution Y P 04/19/2012 09:20 rfialkow PROJECTION: 20131 ACCOUNTS FOR: SEWER FUND VILLAGE OF DEERFIELD NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS FY 2012 /13 MASTER BUDGET PROJECTION 542031 SEWER LINE CONSTRUCTION 51 PERSONNEL SERVICES 2011 2012 2012 2012 2012 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PG 42 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 542031 5110 REG SALAR 179,848.03 170,000.00 170,000.00 165,629.01 170,000.00 170,000.00 .0% 542031 5111 PT SALARY 1,520.00 1,000.00 1,000.00 560.00 600.00 3,000.00 200.01 542031 5112 OT SALARY 866.62 3,500.00 3,500.00 1,287.79 1,200.00 2,500.00 - 28.6°% 542031 5120 MED BNFT 41,005.27 43,500.00 43,500.00 40,245.36 41,500.00 44,000.00 1.1% 542031 5121 DNTL BNFT 2,620.22 3,500.00 3,500.00 2,922.31 3,000.00 3,500.00 .0% 542031 5122 MISC BNFT 221.73 2,250.00 2,250.00 201.85 2,250.00 2,250.00 .0% 542031 5130 APPAREL .00 500.00 500.00 289.44 250.00 .00 - 100.0°% 542031 5140 PEN CNTRB 36,677.49 50,000.00 50,000.00 34,564.03 36,500.00 38,500.00 -23.0% TOTAL PERSONNEL SERVICES 262,759.36 274,250.00 274,250.00 245,699.79 255,300.00 263,750.00 -3.8% 53 CONTRACTUAL SERVICES 542031 5310 RENT EQP .00 2,500.00 2,500.00 .00 200.00 1,500.00 -40.0% 542031 5321 STRUC R &M 7,458.42 10,000.00 10,000.00 1,126.07 500.00 8,000.00 -20.0% 542031 5322 EQUP R &M 6,186.96 6,500.00 6,500.00 15,296.15 13,000.00 6,500.00 .0% 542031 5326 VEH MAINT 10,416.90 10,000.00 10,000.00 6,572.45 10,000.00 10,000.00 .0% 542031 5362 P/S ENG 1,153.68 .00 .00 .00 .00 .00 .0% TOTAL CONTRACTUAL SERVICES 25,215.96 29,000.00 29,000.00 22,994.67 23,700.00 26,000.00 -10.3% 54 COMMODITIES 542031 5420 PETR PROD 8,466.11 9,000.00 9,000.00 11,800.18 11,000.00 10,000.00 11.1 %; 542031 5421 MATERIAL 41,542.73 40,000.00 40,000.00 50,268.52 55,000.00 60,000.00 50.0% 542031 5440 SMTLSEQUP 950.34 1,000.00 1,000.00 702.02 600.00 1,000.00 .0% 542031 5460 OPER SUPP 664.58 1,200.00 1,200.00 995.04 1,200.00 1,200.00 .0% TOTAL COMMODITIES 51,623.76 51,200.00 51,200.00 63,765.76 67,800.00 72,200.00 41.0% TOTAL SEWER LINE CONSTRUCTIO 339,599.08 354,450.00 354,450.00 332,460.22 346,800.00 361,950.00 2.1% 00 0 0 ••0 - - •�••'• mum* Financials, Revenue & citizen Services and Human capital Management , li a filler erp solution 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012/13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 2012 2012 SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION 542051 SEWER CLEANING 51 PERSONNEL SERVICES IPG 43 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 542051 5110 REG SALAR 152,283.68 198,000.00 198,000.00 130,092.90 140,000.00 140,000.00 -29.3% 542051 5111 PT SALARY 3,910.00 2,500.00 2,500.00 .00 100.00 500.00 -80.0% 542051 5112 OT SALARY 4,014.00 4,500.00 4,500.00 2,847.50 3,700.00 4,500.00 .0% 542051 5120 MED BNFT 33,816.97 43,000.00 43,000.00 27,569.68 27,900.00 30,000.00 -30.2% 542051 5121 DNTL BNFT 2,150.60 2,400.00 2,400.00 1,624.26 1,700.00 1,785.00 -25.6% 542051 5122 MISC BNFT 250.98 1,000.00 1,000.00 158.15 1,000.00 1,000.00 .0% 542051 5140 PEN CNTRB 32,096.06 38,000.00 38,000.00 28,700.81 29,900.00 31,500.00 -17.1% TOTAL PERSONNEL SERVICES 228,522.29 289,400.00 289,400.00 190,993.30 204,300.00 209,285.00 -27.7% 53 CONTRACTUAL SERVICES 542051 5310 RENT EQP .00 2,000.00 2,000.00 .00 500.00 1,000.00 -50.0% 542051 5322 EQUP R &M 609.50 1,000.00 1,000.00 397.09 500.00 1,000.00 .0% 542051 5326 VEH MAINT 5,823.00 7,500.00 7,500.00 8,455.95 7,500.00 7,500.00 .0% 542051 5365 P/S OTHER 12,070.97 10,000.00 10,000.00 2,719.25 5,000.00 10,000.00 .0% TOTAL CONTRACTUAL SERVICES 18,503.47 20,500.00 20,500.00 11,572.29 13,500.00 19,500.00 -4.9% 54 COMMODITIES 542051 5410 MISC SUPP 530.18 500.00 500.00 497.26 500.00 500.00 .0% 542051 5420 PETR PROD 2,299.83 1,500.00 1,500.00 4,629.78 3,500.00 3,500.00 133.3% 542051 5421 MATERIAL 211.20 10,000.00 10,000.00 12,594.97 6,500.00 10,000.00 .0% 542051 5440 SMTLSEQUP .00 1,000.00 1,000.00 739.39 250.00 11000.00 .0% 542051 5450 OFF SUPP 39.56 .00 .00 .00 .00 .00 .0% 542051 5460 OPER SUPP 762.92 1,000.00 1,000.00 .00 500.00 500.00 -50.0% 542051 5470 R &M SUPP 500.00 .00 .00 .00 .00 .00 .0 °s TOTAL COMMODITIES 4,343.69 14,000.00 14,000.00 18,461.40 11,250.00 15,500.00 10.71 TOTAL SEWER CLEANING 251,369.45 323,900.00 323,900.00 221,026.99 229,050.00 244,285.00 -24.6% •.•••. m u n is• Financials, Revenue & citizen services and Human capital Management • a lye+ em solution 04/19/2012 09:20 rfialkow PROJECTION: 20131 ACCOUNTS FOR: SEWER FUND VILLAGE OF DEERFIELD NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS FY 2012/13 MASTER BUDGET PROJECTION 542052 WASTEWATER TREATMENT FACILITY 51 PERSONNEL SERVICES 2011 2012 2012 2012 2012 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PG 44 bgnyrpta FOR PERIOD 99 2013 PCT ADOPTED CHANGE 542052 5110 REG SALAR 648,038.12 657,000.00 657,000.00 655,309.15 657,000.00 683,000.00 4.0% 542052 5111 PT SALARY 13,991.01 17,500.00 17,500.00 15,072.32 16,500.00 17,500.00 .0% 542052 5112 OT SALARY 28,654.99 35,535.00 35,535.00 39,728.48 35,535.00 35,535.00 .0°% 542052 5120 MED BNFT 132,350.27 142,000.00 142,000.00 136,982.68 140,000.00 149,500.00 5.3% 542052 5121 DNTL BNFT 8,718.66 9,500.00 9,500.00 9,338.22 9,300.00 9,800.00 3.2% 542052 5122 MISC BNFT 2,240.42 5,150.00 5,150.00 1,223.09 5,150.00 5,150.00 .0% 542052 5130 APPAREL 3,969.23 7,000.00 7,000.00 4,086.48 6,300.00 7,000.00 .0% 542052 5140 PEN CNTRB 142,100.29 143,750.00 143,750.00 150,081.17 156,500.00 164,000.00 14.1% TOTAL PERSONNEL SERVICES 980,062.99 1,017,435.00 1,017,435.00 1,011,821.59 1,026,285.00 1,071,485.00 5.3% 52 TRAINING & DEVELOPME 542052 5210 TRNG REG 2,403.08 4,500.00 4,500.00 2,045.56 3,300.00 4,480.00 -.4% 542052 5211 TRNG TRAV 13.00 1,000.00 1,000.00 41.46 1,000.00 1,000.00 .0% 542052 5213 SUBSCRIPT .00 100.00 100.00 .00 .00 .00 - 100.0% TOTAL TRAINING & DEVELOPME 2,416.08 5,600.00 5,600.00 2,087.02 4,300.00 5,480.00 -2.1% 53 CONTRACTUAL SERVICES 542052 5310 RENT EQP 2,774.34 10,000.00 10,000.00 30.00 5,030.00 20,000.00 100.0% 542052 5320 BLDG R &M 17,436.22 15,000.00 15,000.00 10,153.43 15,000.00 15,000.00 .0°% 542052 5322 EQUP R &M 37,717.67 75,000.00 75,000.00 51,604.09 62,000.00 75,000.00 .0°% 542052 5326 VEH MAINT 4,761.10 8,000.00 8,000.00 4,895.75 8,000.00 8,000.00 .0% 542052 5330 DUES 2,251.25 1,400.00 1,400.00 1,626.40 1,600.00 2,450.00 75.0% 542052 5332 TRAV EXP 475.02 2,000.00 2,000.00 37.87 1,100.00 1,200.00 - 40.0°% 542052 5335 PRINTING 124.75 500.00 500.00 .00 250.00 500.00 .0% 542052 5362 P/S ENG 15,032.39 45,000.00 45,000.00 12,941.39 25,000.00 30,000.00 - 33.3°% 542052 5363 P/S MEDIC 520.00 2,000.00 2,000.00 520.00 2,000.00 520.00 -74.0% 542052 5365 P/S OTHER 28,314.00 70,000.00 70,000.00 52,450.75 60,000.00 94,000.00 34.3% 542052 5370 DP SERV 2,003.19 2,500.00 2,500.00 1,472.64 1,500.00 2,500.00 .0% TOTAL CONTRACTUAL SERVICES 111,409.93 231,400.00 231,400.00 135,732.32 181,480.00 249,170.00 7.7% 54 COMMODITIES 542052 5410 MISC SUPP 2,848.76 4,000.00 4,000.00 3,045.12 3,500.00 4,000.00 .0% 542052 5420 PETR PROD 17,020.20 15,000.00 15,000.00 8,652.28 13,500.00 11,000.00 -26.7% 000000 0 ip. m u n is• Financials, Revenue & Citizen Services and Human Capital Management = y 0 t tyler erp SNOW � ' " 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 2012 SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL 2012 PROJECTION 000 oo IPG 45 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 542052 5421 MATERIAL 4,444.70 15,000.00 15,000.00 7,705.24 12,000.00 15,000.00 .0s 542052 5422 CHEMICAL 30,794.77 40,000.00 40,000.00 34,652.92 40,000.00 40,000.00 .0% 542052 5440 SMTLSEQUP 249.20 2,000.00 2,000.00 1,465.07 1,500.00 2,000.00 .0% 542052 5450 OFF SUPP 920.55 1,000.00 1,000.00 1,206.13 1,000.00 1,000.00 .0% 542052 5460 OPER SUPP 10,398.26 15,000.00 15,000.00 14,213.22 8,000.00 8,000.00 -46.7% 542052 5470 R &M SUPP 12,728.12 20,000.00 20,000.00 17,404.97 20,000.00 20,000.00 .0% TOTAL COMMODITIES 79,404.56 112,000.00 112,000.00 88,344.95 99,500.00 101,000.00 -9.8% 55 UTILITIES 542052 5510 U/E ELECT 240,676.08 200,000.00 200,000.00 197,651.31 200,000.00 200,000.00 .0% 542052 5520 U/E NAT GA 29,387.25 50,000.00 50,000.00 24,572.02 50,000.00 50,000.00 .0% 542052 5530 U/E WATER 9,910.90 15,000.00 15,000.00 11,501.31 15,000.00 15,000.00 .0% 542052 5540 U/E TELEPH 11,526.70 16,400.00 16,400.00 10,024.19 16,400.00 16,200.00 -1.2% TOTAL UTILITIES 291,500.93 281,400.00 281,400.00 243,748.83 281,400.00 281,200.00 -.1% 56 OTHER EXPENSES 542052 5611 PMTS OTHR 24,500.00 50,000.00 50,000.00 19,000.00 50,000.00 49,500.00 -1.0% TOTAL OTHER EXPENSES 24,500.00 50,000.00 50,000.00 19,000.00 50,000.00 49,500.00 -1.0% 58 CAPITAL OUTLAY 542052 5810 OP EQP 303.20 13,500.00 13,500.00 9,858.43 10,000.00 8,000.00 -40.7% TOTAL CAPITAL OUTLAY 303.20 13,500.00 13,500.00 9,858.43 10,000.00 8,000.00 -40.7% 59 CAPITAL IMPROVEMENTS 542052 5941 STP IMP .00 .00 .00 48,252.12 50,000.00 .00 .0s TOTAL CAPITAL IMPROVEMENTS .00 .00 .00 48,252.12 50,000.00 .00 .0% 72 TRANSFERS OUT (IFT) 542052 7211 TRANS VERF 16,777.00 19,948.00 19,948.00 19,948.00 19,948.00 19,948.00 .0% TOTAL TRANSFERS OUT (IFT) 16,777.00 19,948.00 19,948.00 19,948.00 19,948.00 19,948.00 .0% TOTAL WASTEWATER TREATMENT F 1,506,374.69 1,731,283.00 1,731,283.00 1,578,793.26 1,722,913.00 1,785,783.00 3.1% TOTAL SEWER FUND 2,846,387.93 2,951,909.00 2,951,909.00 2,649,558.33 2,808,639.00 2,934,444.00 -.6% •••• °• m u h iS' Financials, Revenue & citizen Services and Human capital Management er • a tytet erp solution ..:;�.: „.- y �'' lechndogies 04/19/2012 09:20 VILLAGE OF DEERFIELD 46 rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgayrpta PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT REFUSE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 582030 REFUSE COLLECTION 53 CONTRACTUAL SERVICES 582030 5311 PROP RENT 24,000.00 24,000.00 24,000.00 .00 24,000.00 24,000.00 .0% 582030 5337 POSTAGE 1,090.70 2,200.00 2,200.00 1,018.47 1,500.00 2,000.00 -9.1% 582030 5350 INS GL 6,597.64 7,775.46 7,775.46 7,627.63 7,800.00 7,800.00 .3% 582030 5390 OTHER 7,062.89 9,000.00 9,000.00 7,034.26 8,000.00 8,000.00 -11.1% 582030 5391 REF COLCT 1,440,825.57 1,130,000.00 1,130,000.00 1,059,586.27 1,130,000.00 1,165,000.00 3.1% TOTAL CONTRACTUAL SERVICES 1,479,576.80 1,172,975.46 1,172,975.46 1,075,266.63 1,171,300.00 1,206,800.00 2.9% 54 COMMODITIES 582030 5410 MISC SUPP 14,584.00 4,000.00 4,000.00 11,250.00 15,000.00 15,000.00 275.0% TOTAL COMMODITIES 14,584.00 4,000.00 4,000.00 11,250.00 15,000.00 15,000.00 275.0% TOTAL REFUSE COLLECTION 1,494,160.80 1,176,975.46 1,176,975.46 1,086,516.63 1,186,300.00 1,221,800.00 3.8% of 0 a f0a •�•.• m u n is• Financials, Revenue & Citizen services and Human Capital Management x tyter erp sWution = 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012/13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 REFUSE FUND ACTUAL ORIG BUD REVISED BUD 582053 REFUSE LEAF COLLECTION 51 PERSONNEL SERVICES 582053 5110 REG SALAR 582053 5111 PT SALARY 582053 5112 OT SALARY 582053 5120 MED BNFT 582053 5121 DNTL BNFT 582053 5122 MISC BNFT 582053 5140 PEN CNTRB TOTAL PERSONNEL SERVICES 53 CONTRACTUAL SERVICES 582053 5310 RENT EQP 582053 5322 EQUP R &M 582053 5326 VEH MAINT TOTAL CONTRACTUAL SERVICES 54 COMMODITIES 582053 5420 PETR PROD 582053 5460 OPER SUPP TOTAL COMMODITIES 72 TRANSFERS OUT (IFT) 582053 7211 TRANS VERF TOTAL TRANSFERS OUT (IFT) TOTAL REFUSE LEAF COLLECTION TOTAL REFUSE FUND 2012 2012 ACTUAL PROJECTION PG 47 bgayrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 23,417.70 20,000.00 20,000.00 25,605.22 26,000.00 26,000.00 30.0% 11,625.25 13,000.00 13,000.00 10,345.00 10,345.00 13,000.00 .0% 9,777.98 16,000.00 16,000.00 13,410.22 13,500.00 16,000.00 .0°% 7,643.80 9,500.00 9,500.00 9,503.77 14,200.00 15,000.00 57.9% 490.82 1,000.00 1,000.00 583.82 900.00 1,000.00 .0% 39.39 250.00 250.00 40.55 250.00 250.00 .0% 7,802.07 10,000.00 10,000.00 8,931.50 13,400.00 14,000.00 40.096 60,797.01 69,750.00 69,750.00 68,420.08 78,595.00 85,250.00 22.2°% .00 .00 .00 600.00 600.00 600.00 .0% 29,112.60 35,000.00 35,000.00 18,365.25 19,000.00 35,000.00 .0% 2,521.10 3,000.00 3,000.00 4,000.50 4,000.00 3,000.00 .0% 31,633.70 38,000.00 38,000.00 22,965.75 23,600.00 38,600.00 1.6% 4,964.36 6,000.00 6,000.00 9,629.97 10,000.00 6,000.00 .0% 3.11 500.00 500.00 1,383.62 1,400.00 750.00 50.0°% 4,967.47 6,500.00 6,500.00 11,013.59 11,400.00 6,750.00 3.8% 9,177.00 9,177.00 9,177.00 9,177.00 9,177.00 9,177.00 .0% 9,177.00 9,177.00 9,177.00 9,177.00 9,177.00 9,177.00 .0% 106,575.18 123,427.00 123,427.00 111,576.42 122,772.00 139,777.00 13.2% 1,600,735.98 1,300,402.46 1,300,402.46 1,198,093.05 1,309,072.00 1,361,577.00 4.7% 0 • o00 o oo�o m u n is Financials, Revenue & Citizen Services and Human Capital Management a tyet erp solution 04/19/2012 09:20 (VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 2012 COMMUTER PARKING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL 2012 PROJECTION tyler IPG 48 bgnyrpta FOR PERIOD 99 2013 PCT ADOPTED CHANGE 602019 COMM PARK COMBINED FUNDING 51 PERSONNEL SERVICES 602019 5110 REG SALAR 9,125.51 10,500.00 10,500.00 11,554.03 10,500.00 10,500.00 .0% 602019 5120 MED BNFT 1,272.62 1,800.00 1,800.00 1,656.98 1,700.00 1,900.00 5.6% 602019 5121 DNTL BNFT 79.77 250.00 250.00 104.38 150.00 250.00 .0% 602019 5122 MISC BNFT 14.93 100.00 100.00 16.29 100.00 100.00 .0% 602019 5140 PEN CNTRB 1,889.66 2,400.00 2,400.00 2,521.55 2,700.00 2,800.00 16.7% TOTAL PERSONNEL SERVICES 12,382.49 15,050.00 15,050.00 15,853.23 15,150.00 15,550.00 3.3% 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 20,589.12 20,000.00 20,000.00 17,846.34 20,000.00 20,000.00 .0% 602019 5322 EQUP R &M .00 500.00 500.00 .00 1.00 1.00 -99.8% 602019 5350 INS GL 2,999.00 3,534.30 3,534.30 3,467.10 3,534.30 3,534.30 .0% 602019 5390 OTHER 11,371.42 75,000.00 75,000.00 12,692.93 25,000.00 25,000.00 -66.7% TOTAL CONTRACTUAL SERVICES 42,399.54 106,534.30 106,534.30 34,006.37 56,035.30 56,035.30 -47.4% 54 COMMODITIES 602019 5421 MATERIAL 327.50 750.00 750.00 332.50 750.00 750.00 .0% TOTAL COMMODITIES 327.50 750.00 750.00 332.50 750.00 750.00 .0% 55 UTILITIES 602019 5510 U/E ELECT 1,360.57 3,300.00 3,300.00 3,062.96 3,300.00 3,300.00 .0% TOTAL UTILITIES 1,360.57 3,300.00 3,300.00 3,062.96 3,300.00 3,300.00 .0% 72 TRANSFERS OUT (IFT) 602019 7210 TRNSFR OUT 100,000.00 100,000.00 100,000.00 .00 100,000.00 100,000.00 .0% TOTAL TRANSFERS OUT (IFT) 100,000.00 100,000.00 100,000.00 .00 100,000.00 100,000.00 .0% TOTAL COMM PARK COMBINED FUN 156,470.10 225,634.30 225,634.30 53,255.06 175,235.30 175,635.30 -22.2% •�• . m u n is• Financials, Revenue & Citizen services and Human Capital Management LOOP- • a tyter erp solutior, 04/19/2012 09:20 VILLAGE OF DEERFIELD rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION ACCOUNTS FOR: 2011 2012 2012 2012 COMMUTER PARKING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL 2012 PROJECTION tyler IPG 49 bgnyrpts FOR PERIOD 99 2013 PCT ADOPTED CHANGE 602038 COMM PARK VILLAGE OWNED 51 PERSONNEL SERVICES 602038 5110 REG SALAR 9,125.51 10,500.00 10,500.00 11,554.03 10,500.00 10,500.00 .0°% 602038 5120 MED BNFT 1,272.62 2,330.00 2,330.00 1,656.98 1,700.00 2,300.00 -1.3% 602038 5121 DNTL BNFT 79.77 250.00 250.00 104.38 105.00 200.00 -20.0% 602038 5122 MISC BNFT 14.93 100.00 100.00 16.29 100.00 100.00 .0% 602038 5140 PEN CNTRB 1,889.66 2,400.00 2,400.00 2,521.55 2,700.00 2,750.00 14.6% TOTAL PERSONNEL SERVICES 12,382.49 15,580.00 15,580.00 15,853.23 15,105.00 15,850.00 1.7% 53 CONTRACTUAL SERVICES 602038 5322 EQUP R &M .00 5,000.00 5,000.00 .00 5,000.00 90,000.00 1700.0% 602038 5350 INS GL 2,999.00 3,534.30 3,534.30 3,467.10 3,534.30 3,534.30 .0% 602038 5390 OTHER 17,786.17 25,000.00 25,000.00 11,722.32 25,000.00 25,000.00 .0% TOTAL CONTRACTUAL SERVICES 20,785.17 33,534.30 33,534.30 15,189.42 33,534.30 118,534.30 253.5% 54 COMMODITIES 602038 5421 MATERIAL 327.50 1,000.00 1,000.00 332.50 1,000.00 1,000.00 .0% TOTAL COMMODITIES 327.50 1,000.00 1,000.00 332.50 1,000.00 1,000.00 .0% 55 UTILITIES 602038 5510 U/E ELECT 5,728.33 6,000.00 6,000.00 7,639.65 6,000.00 6,000.00 .0% TOTAL UTILITIES 5,728.33 6,000.00 6,000.00 7,639.65 6,000.00 6,000.00 .0% 56 OTHER EXPENSES 602038 5670 DEPR EXP 26,737.44 .00 .00 .00 .00 .00 .0% TOTAL OTHER EXPENSES 26,737.44 .00 .00 .00 .00 .00 .0% 72 TRANSFERS OUT (IFT) 602038 7210 TRNSFR OUT 100,000.00 100,000.00 100,000.00 .00 100,000.00 100,000.00 .0% TOTAL TRANSFERS OUT (IFT) 100,000.00 100,000.00 100,000.00 .00 100,000.00 100,000.00 .0% TOTAL COMM PARK VILLAGE OWNE 165,960.93 156,114.30 156,114.30 39,014.80 155,639.30 241,384.30 54.6°% TOTAL COMMUTER PARKING FUND 322,431.03 381,748.60 381,748.60 92,269.86 330,874.60 417,019.60 9.2% ��•.• m u n is• Financials, Revenue & Citizen Services and Human capital Management, ty!er a tyier erp sotuwn o 04/19/2012 09:20 (VILLAGE OF DEERFIELD IPG 50 rfialkow NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT GARAGE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 702050 GARAGE FUND EXPENDITURES 51 PERSONNEL SERVICES 702050 5110 REG SALAR 160,762.88 151,000.00 151,000.00 159,867.04 151,000.00 155,000.00 2.6% 702050 5112 OT SALARY 17,765.83 12,000.00 12,000.00 7,288.75 12,000.00 12,000.00 .0% 702050 5120 MED BNFT 18,277.77 24,000.00 24,000.00 17,454.74 17,700.00 22,000.00 -8.3% 702050 5121 DNTL BNFT 1,367.08 2,600.00 2,600.00 1,280.74 1,400.00 2,200.00 -15.4% 702050 5122 MISC BNFT 218.13 1,500.00 1,500.00 170.89 1,500.00 1,500.00 .0% 702050 5130 APPAREL 885.64 1,600.00 1,600.00 979.44 1,000.00 1,000.00 -37.5% 702050 5140 PEN CNTRB 37,174.88 40,250.00 40,250.00 36,197.16 37,800.00 40,000.00 -.6% TOTAL PERSONNEL SERVICES 236,452.21 232,950.00 232,950.00 223,238.76 222,400.00 233,700.00 .3% 52 TRAINING & DEVELOPME 702050 5210 TRNG REG .00 500.00 500.00 .00 300.00 430.00 -14.0% 702050 5211 TRNG TRAV .00 500.00 500.00 .00 500.00 500.00 .0% TOTAL TRAINING & DEVELOPME .00 1,000.00 1,000.00 .00 800.00 930.00 -7.0% 53 CONTRACTUAL SERVICES 702050 5322 EQUP R &M 5,675.12 12,000.00 12,000.00 .00 4,000.00 12,000.00 .0% 702050 5332 TRAV EXP .00 500.00 500.00 .00 500.00 400.00 -20.0% 702050 5335 PRINTING 76.87 100.00 100.00 .00 100.00 .00 - 100.0% 702050 5350 INS GL 17,819.40 21,000.00 21,000.00 20,600.79 21,000.00 21,000.00 .0% TOTAL CONTRACTUAL SERVICES 23,571.39 33,600.00 33,600.00 20,600.79 25,600.00 33,400.00 -.6% 54 COMMODITIES 702050 5410 MISC SUPP 292.05 1,500.00 1,500.00 936.45 1,500.00 1,500.00 .0% 702050 5420 PETR PROD 838.19 1,000.00 1,000.00 793.46 1,000.00 1,000.00 .0% 702050 5421 MATERIAL 764.12 3,000.00 3,000.00 3,431.92 4,000.00 3,000.00 .0% 702050 5440 SMTLSEQUP 7,707.89 7,000.00 7,000.00 3,630.39 4,000.00 7,000.00 .0% 702050 5450 OFF SUPP .00 100.00 100.00 .00 100.00 100.00 .0% 702050 5460 OPER SUPP .00 300.00 300.00 .00 .00 .00 - 100.0°% 702050 5470 R &M SUPP 107,107.37 100,000.00 100,000.00 102,645.38 100,000.00 100,000.00 .0% TOTAL COMMODITIES 116,709.62 112,900.00 112,900.00 111,437.60 110,600.00 112,600.00 -.39. 55 UTILITIES 702050 5530 U/E WATER 964.69 2,500.00 2,500.00 736.20 2,500.00 2,500.00 .0% •�• . Pll U h IS Financials, Revenue & Citizen Services and Human Capital Management tyler • a tyter crp solution ..- 04/19/2012 09:20 OF DEERFIELD 51 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpta PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT GARAGE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 702050 5540 U/E TELEPH 2,231.75 2,000.00 2,000.00 1,710.53 2,000.00 2,000.00 .0% TOTAL UTILITIES 3,196.44 4,500.00 4,500.00 2,446.73 4,500.00 4,500.00 .0% 58 CAPITAL OUTLAY 702050 5810 OP EQP .00 5,000.00 5,000.00 .00 1,200.00 2,500.00 -50.0% TOTAL CAPITAL OUTLAY .00 5,000.00 5,000.00 .00 1,200.00 2,500.00 -50.0% 72 TRANSFERS OUT (IFT) 702050 7211 TRANS VERF 2,525.00 3,175.00 3,175.00 3,175.00 3,175.00 2,670.00 -15.9% TOTAL TRANSFERS OUT (IFT) 2,525.00 3,175.00 3,175.00 3,175.00 3,175.00 2,670.00 -15.9% TOTAL GARAGE FUND EXPENDITUR 382,454.66 393,125.00 393,125.00 360,898.88 368,275.00 390,300.00 -.7% TOTAL GARAGE FUND 382,454.66 393,125.00 393,125.00 360,898.88 368,275.00 390,300.00 -.7% •�• ® M u n is• Financials, Revenue & Citizen Services and Human Capital Management tyler • a tyer erp sotutfon technclNes 04/19/2012 09:20 OF DEERFIELD 52 rfialkow (VILLAGE NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IPG bgnyrpts PROJECTION: 20131 FY 2012 /13 MASTER BUDGET PROJECTION FOR PERIOD 99 ACCOUNTS FOR: 2011 2012 2012 2012 2012 2013 PCT POLICE PENSION FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED CHANGE 806010 POLICE PENSION FUND EXPENDITUR 51 PERSONNEL SERVICES 806010 5120 MED BNFT .00 2,250.00 2,250.00 .00 .00 .00 - 100.0% 806010 5141 PEN PYMNT 1,685,337.37 1,820,805.00 1,820,805.00 1,671,405.35 1,820,805.00 2,040,000.00 12.0% 806010 5142 SEP REFND 4,305.49 15,000.00 15,000.00 346,472.65 347,000.00 15,000.00 .0% TOTAL PERSONNEL SERVICES 1,689,642.86 1,838,055.00 1,838,055.00 2,017,878.00 2,167,805.00 2,055,000.00 11.8% 53 CONTRACTUAL SERVICES 806010 5330 DUES 775.00 1,500.00 1,500.00 775.00 1,000.00 1,000.00 -33.3% 806010 5332 TRAV EXP 255.80 1,000.00 1,000.00 409.80 1,000.00 1,500.00 50.0% 806010 5350 INS GL 4,916.00 5,775.00 5,775.00 4,996.00 5,000.00 5,800.00 .4% 806010 5360 P/S CRP CN 6,835.18 10,000.00 10,000.00 3,671.85 4,000.00 7,500.00 -25.0% 806010 5365 P/S OTHER 4,440.34 4,000.00 4,000.00 .00 4,000.00 4,000.00 .0% 806010 5369 TRUST FEES 1,661.54 1,750.00 1,750.00 1,681.67 1,750.00 1,750.00 .0% 806010 5390 OTHER 10,451.40 12,000.00 12,000.00 7,287.53 8,500.00 11,000.00 -8.3% TOTAL CONTRACTUAL SERVICES 29,335.26 36,025.00 36,025.00 18,821.85 25,250.00 32,550.00 -9.6% TOTAL POLICE PENSION FUND EX 1,718,978.12 1,874,080.00 1,874,080.00 2,036,699.85 2,193,055.00 2,087,550.00 11.4% TOTAL POLICE PENSION FUND 1,718,978.12 1,874,080.00 1,874,080.00 2,036,699.85 2,193,055.00 2,087,550.00 11.4% GRAND TOTAL 44,625,020.10 56,510,416.81 57,260,416.81 67,973,884.63 53,206,390.04 56,505,057.28 -1.3% ** END OF REPORT - Generated by Bob Fialkowski **