Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
08-13-12 Work Session Agenda
GENERAL FUND BUDGET DETAIL REVENUES TAXES 31010 GENERAL PROPERTY TAX 31020 DELINQUENT AD VALOREM TAXES 31040 FISCAL DISPARITIES TOTALTAXES LICENSES& PERMITS 321.10 LIQUOR LICENSES 32120 TOBACCO LICENSES 32160 TREE TRIMMING LICENSES 32175 RENTALHOUSING LICENSES 32180 OTHER BUSINESS LICENSES AND PE 32210 BUILDING PERMITS 32215 PLAN CHECK FEES 32240 DOG LICENSES 32250 HORSE PERMITS TOTAL LICENSES & PERMITS INTERGOVERNMENTAL 33401 LOCAL PERFORMANCE AID 33404 PERA AID 33418 MUNICIPAL STATE AID FOR STREET TOTAL INTERGOVERNMENTAL CHARGES FORSERVICES 34103 ZONING AND SUBDIVISION FEES 34104 PASS THEN CHARGES 34105 SALE OF COPIES 34107 SPECIAL ASSESSMENT SEARCHES 34780 PARK FEES & RENTALS 34781 TREE SALES 34785 PARK DONATIONS TOTAL CHARGES FOR SERVICES FINES & FORFEITURES 35101 FINES &FORFEITS TOTAL FINES & FORFEITURES MISCELLANEOUS REVENUE 36210 INTEREST EARNINGS 36230 CONTRIBUTIONS AND DONATIONS FR 36240 REFUNDS & REIMBURSEMENTS 36250 POP MACHINE REVENUE 36260 DRY HYDRANT CHARGES 36265 CELLULAR ANTENNA REVENUE 36270 MISCELLANEOUS REVENUE 36275 CONCESSIONS /VENDING TOTAL MISCELLANEOUS REVENUE Approved Dept Budget Actual Budget Actual Budget Actual Budget YID Request Percent Dollar 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 4,776,292 4,517,369 4,776,292 4,647,334 4,763,319 4,547,162 4,763,319 1,696,500 4,763,319 0.0% - - 62,142 - 6,730 - 119,030 - - - - 123,858 63,140 121,002 4,776,292 4,703,369 4,776,292 4,717,204 4,763,319 4,787,194 4,763,319 1,696,500 4,763,319 0.0% - 8,820 8,320 8,820 810 8,300 8,820 8,300 8,820 8,300 0.0% - 1,000 1,000 1,000 825 1,000 1,000 1,000 250 1,000 0.0% - 450 630 450 570 450 730 450 90 450 0.0% - 500 1,020 Soo 1,440 1,000 1,440 1,000 540 1,000 0.0% - 1,000 3,555 1,000 4,940 3,100 11,404 3,100 1,427 3,100 0.0% - 180,000 97,651 90,000 118,189 70,000 123,141 80,000 51,901 92,000 15.0% 12,000 - 12,336 - 23,679 11,000 24,225 12,000 14,994 15,000 25.0% 3,000 3,500 3,321 3,500 3,609 3,300 3,309 3,300 1,271 3,300 0.0% - 50 50 50 50 50 100 50 0.0% 195,264 127,878 105,266 154,112 98,200 174,119 109,200 79,393 124,200 13.7% 15,000 - - - - - - 1,000 - 1,000 0.0% - 5,000 4,751 5,000 4,751 4,751 2,375 4,751 - 4,751 0.0% - 60,000 61,471 60,000 64,647 64,650 68,217 64,650 34,377 64,650 0.0% 65,000 66,411 65,000 69,133 69,401 70,592 70,401 34,377 70,401 0.0% - 4,500 5,738 4,500 1,824 4,500 4,067 4,500 3,393 4,500 0.0% - - - - 4,750 - (4,235) - 835 - - 1,000 913 1,000 722 1,000 526 1,000 1.25 1,000 0.0% - 500 110 Soo 190 150 250 150 325 150 0.0% - - 325 - 250 425 525 425 1,171 29,500 6841.2% 29,075 - - - - - - - 6,828 - 31,000 27,070 31,000 34,146 29,000 32,718 29,000 19,971 -100.0% (29,000) 37,000 41,649 37,000 41,882 35,075 33,851 35,075 32,648 35,150 0.2% 75 55,000 52,968 55,000 55,806 52,000 48,720 54,500 26,474 57,000 4.6% 2,500 55,000 52,968 55,000 55,806 52,000 48,720 54,500 26,474 57,000 4.6% 2,500 117,000 58,624 95,000 46,769 45,000 25,629 45,000 - 35,000 -22.2% (10,000) - 820 - - - 1,340 - - - - 10,000 11,349 10,000 13,423 - 28,930 - 14,009 10,000 10,000 3,500 3,332 3,500 (125) 3,500 245 3,500 4 3,500 TEX - - - - - - - - - 150,000 150,000 17,000 8,236 17,000 26,444 15,000 21,217 15,000 9,714 15,000 0.0% - 2,500 394 2,500 394 400 394 400 400 0.0% 150,000 82,755 128,000 86,905 63,900 77,755 63,900 23,727 213,900 234.7% 150,000 P1 P2 Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change TRANSFERS 39202 TRANSFERS FROM ENTERPRISE FUND 40,000 40,000 18,842 33,465 40,000 40,000 40,000 29,320 - - 100.0% (40,000) 39203 TRANSFERS FROM OTHER FUNDS 160,000 180,000 TOTALTRANSFERS 200,000 40,000 198,842 33,465 40,000 40,000 40,000 29,320 - - 100.0% (40,000) TOTAL REVENUES 5,478,556 5,115,030 5,365,400 5,158,507 5,121,895 5,232,231 5,136,395 1,922,439 5,263,970 2.5% 127,575 EXPENDITURES C"COUNCIL Personnel 16,794 16,794 16,794 16,794 16,800 16,794 16,800 8,397 16,800 0.0% - Materials and Supplies 1,400 3,064 3,064 1,175 1,300 684 3,000 165 2,000 -33.3% (1,000) Support Services and Charges 52,000 46,158 46,158 45,776 102,430 76,063 86,315 18,801 61,975 -28.2% (24,340) Transfers 1,379 13,600 4D,000 194.1% 26,400 Total City Council 70,194 66,016 66,016 63,745 120,530 94,920 119,715 27,363 120,775 0.9% 1,060 Administration Personnel 374,401 369,882 360,040 399,294 373,996 427,106 319,475 213,545 359,671 12.6% 40,196 Materials and Supplies 23,500 19,924 24,925 17,634 20,800 16,524 24,095 10,172 18,450 -234% (5,645) Support Services and Charges 42,900 39,441 39,155 35,881 37,110 41,855 39,935 13,568 42,175 5.6% 2,240 Capital 7,500 6,540 6,200 2,844 - 135 - Total City Administration 448,301 435,787 430,320 455,653 431,906 485,485 383,505 237,420 420,296 9.6% 36,791 FINANCE Personnel 177,637 166,032 177,637 147,242 177,637 163,794 128,416 81,064 132,929 3.5% 4,513 Materials and Supplies 8,200 6,952 8,200 7,576 8,200 7,785 7,300 7,932 8,400 15.1% 1,100 Support Services and Charges 8,500 4,799 8,500 7,222 8,500 13,822 9,150 1,014 11,600 26.8% 2,450 Capital 4,500 2,483 4,500 4,500 - - - Total Finance 198,837 180,266 198,837 162,040 198,837 185,401 144,866 90,010 152,929 5.6% 8,063 PROFESSIONAL SERVICES Support Services and Charges 205,500 223,859 223,859 178,604 223,859 188,963 199,320 130,640 203,390 2.0% 4,070 Total Professional Services 205,500 223,859 223,859 178,604 223,859 188,963 199,320 130,640 203,390 2.0% 4,070 PLANNING Personnel 199,601 195,474 195,474 175,553 195,474 168,156 170,666 88,269 170,666 0.0% - MaterialsandSUpphes 1,755 2,138 2,138 149 2,138 261 655 - 650 -0.8% (5) Support Services and Charges 11,950 8,990 8,990 6,882 8,990 8,079 9,412 2,509 7,400 -21.4% (2,012) Capital 200 200 Total Planning 213,306 206,602 206,602 182,584 206,602 176,496 180,733 90,778 178,916 -1.0% (1,817) MUNICIPAL BUILDINGS Materials and Supplies 26,300 34,321 34,321 51,244 34,321 50,002 16,500 13,380 22,130 34.1% 5,630 Support Services and Charges 139,500 123,958 123,958 54,496 123,958 126,794 157,750 131,095 164,800 4.5% 7,050 Capital 1,000 - - 15,713 - 1,534 - 352 - - Bond Payments 100,120 5,425 5,425 2,959 5,425 - - - - - Transfers 110,000 99,773 99,773 160,368 99,773 103,950 102,200 100,450 -T7% (1,750) Total Municipal Buildings 376,920 263,477 263,477 284,780 263,477 282,280 276,450 144,827 287,380 4.0% 10,930 POLICE Materials add Supplies - - - 1,367 - - - - - - Support Services and Charges 943,000 943,989 943,989 949,337 943,989 996,771 989,085 494,458 1,015,077 2.6% 25,992 Capital 233,000 232,940 232,940 228,068 232,940 230,068 225,132 112,566 235,437 4.6% 10,305 Total Police _ 1,176,000 1,176,929 1,176,929 1,178,772 1,176,929 1,226,839 1,214,217 607,024 1,250,514 3.0% 36,297 P2 P3 Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change FIRE Support Services and Charges 316,138 323,180 323,180 322,535 323,180 337,131 332,805 165,993 349,582 5.0% 16,777 Capital 284,500 277,270 277,270 272,629 277,270 270,697 277,906 138,953 287,643 3.5% 9,737 Total Fire 600,638 600,450 600,450 595,164 600,450 607,828 610,711 304,946 637,225 4.3% 26,514 PROTECTIVE INSPECTIONS Personnel 122,484 119,184 119,184 115,081 119,184 122,171 118,049 57,517 120,588 2.2% 2,539 Materials and Supplies 750 139 139 28 139 154 200 - 200 0.0% - Support ServicesandCharges 10,700 5,647 5,647 4,575 5,647 4,438 5,150 631 5,300 2.9% 150 Capital 1,298 1,298 1,298 Total Protective Inspections 133,934 126,268 126,268 119,684 126,268 126,763 123,399 58,148 126,088 2.2% 2,689 CITYENGINEER Personnel 132,594 107,388 107,388 94,497 SD7,388 96,219 90,872 39,160 92,549 1.8% 1,677 Materials and Supplies 900 741 741 152 741 495 200 104 200 0.0% - SupportServicesandCharges 18,653 7,639 7,639 8,937 7,639 13,550 11,960 7,018 11,220 -6.2% (740) Capital 8,910 2,854 2,854 538 2,854 1,057 Total City Engineer 161,057 118,622 118,622 104,124 118,622 111,321 103,032 46,282 103,969 0.9% 937 PUBLIC WORKS SERVICES Personnel 401,668 359,724 414,085 405,101 313,867 389,918 418,633 181,079 428,]]5 2.4% 10,142 Materials and Supplies 160,900 115,838 164,623 144,931 162,725 159,047 172,575 103,074 171,300 -0.7% (1,275) Support Services and Charges 128,440 119,565 127,949 117,944 145,239 139,759 134,439 48,145 138,550 3.1.% 4,111 Capital 3,500 5,003 3,800 - - - - - 1,200 1,200 Transfers 875,000 875,000 800,000 800,000 750,000 750,000 750,000 ]]2,500 3.0% 22,500 Total Public Works Services 1,569,508 1,475,130 1,510,457 1,467,976 1,371,831 1,438,724 1,475,647 332,298 1,512,325 2.5% 36,678 SNOWAND ICECONTROL Personnel 41,172 35,995 35,995 55,052 56,567 37,959 55,024 14,979 56,662 3.0% 1,638 Materials and Supplies 45,340 38,457 38,457 32,451 45,117 29,462 45,117 10,247 45,000 -0.3% (117) Support Services and Charges - - - - - - - - - - Capital Total Snow and ice Control 86,512 74,452 74,452 87,503 101,684 67,421 100,141 25,226 101,662 1.5% 1,521 PARKS MAINTENANCE Personnel 147,532 147,532 147,532 153,637 185,708 152,118 100,988 52,583 103,358 2.3% 2,371 Materials and Supplies 10,094 10,094 10,094 14,237 19,800 17,394 18,300 12,307 19,300 5.5% 1,000 Support Services and Charges 109,781 109,781 109,781 96,057 91,900 87,090 26,500 13,652 30,910 16A%, 4,410 Transfers Total Parks Maintenance 267,407 267,407 267,407 263,931 297,408 256,602 145,788 78,542 153,568 5.3% 7,781 RECREATION Personnel - - - - - - 68,356 19,829 36,360 -46.8% (31,997) Materials and Supplies - - - - - - 1,500 1,000 1,500 0.0% - Support Services and Charges - - - - - - 34,150 11,634 20,145 -41.0% (14,005) Transfers 45,000 45,000 42,000 42,000 42,000 42,000 42,000 42,000 0.0% Total Recreation 45,000 45,000 42,000 42,000 42,000 42,000 146,006 32,463 100,005 -31.5% (46,002) GENERAL FUND TOTAL EXPENDITURES 5,553,114 5,260,265 5,305,696 5,186,560 5,180,403 5,291,043 5,223,530 2,205,967 5,349,043 2.4% 125,513 REVENUE OVER /(UNDER) EXPENDITURES (74,558) (145,235) 59,705 (28,054) (158,508) (58,812) (87,135) (283,528) (85,073) -2.4% 2,062 (Planned Use of Fund Balance) P3 GENERAL FUND REVENUE DETAIL REVENUES TAXES 31010 GENERAL PROPERTY TAX 31020 DELINQUENT AD VALOREM TAXES 31040 FISCAL DISPARITIES 31800 OTHER TAXES 31910 PENALTIES AND INTEREST ON AD V 31920 FORFEITED TAX SALE APPORTIONMENT TOTAL TAXES LICENSES & PERMITS 32110 LIQUOR LICENSES 32120 TOBACCO LICENSES 32160 TREE TRIMMING LICENSES 32175 RENTAL HOUSING LICENSES 32180 OTHER BUSINESS LICENSES AND PE 32210 BUILDING PERMITS 32215 PLAN CHECK FEES 32240 DOG LICENSES 32250 HORSE PERMITS 32260 OTHER NON - BUSINESS LICENSES AN 32300 DOMESTIC PARTNERSHIP REGISTRATION TOTAL LICENSES & PERMITS Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 4,776,292 4,517,369 4,776,292 4,647,334 4,763,319 4,547,162 4,763,319 1,696,500 4,763,319 0.0% - 62,142 - 6,730 - 119,030 - - 123,858 - 63,140 - 121,002 - 4,776,292 4,703,369 4,776,292 4,717,204 4,763,319 4,787,194 4,763,319 1,696,500 4,763,319 0.01% - 8,820 8,320 8,820 810 8,300 8,820 8,300 8,820 8,300 0.0% - 1,000 1,000 1,000 825 1,000 1,000 1,000 250 1,000 0.0% - 450 630 450 570 450 730 450 90 450 0.0% - 500 1,020 500 1,440 1,000 1,440 1,000 540 1,000 0.0% - 1,000 3,555 1,000 4,940 3,100 11,404 3,100 1,427 3,100 0.0% - 180,000 97,651 90,000 118,189 70,000 123,141 80,000 51,901 92,000 15.0% 12,000 - 12,336 - 23,679 11,000 24,225 12,000 14,994 15,000 25.0% 3,000 3,500 3,321 3,500 3,609 3,300 3,309 3,300 1,271 3,300 0.0% - - 50 - 50 50 50 50 100 50 0.0% - 1,000 - 1,000 - - - - - - - 196,270 127,883 106,270 154,112 98,200 174,119 109,200 79,393 124,200 13.7% 15,000 INTERGOVERNMENTAL 33401 LOCAL PERFORMANCE AID - - - - - - 1,000 - 1,000 0.09/ - 33403 MKT VALUE CREDIT AID - 189 - (265) - - - - - 33404 PERA AID 5,000 4,751 5,000 4,751 4,751 2,375 4,751 4,751 0.0% - 33418 MUNICIPAL STATE AID FOR STREET 60,000 61,471 60,000 64,647 64,650 68,217 64,650 34,377 64,650 0.0% - TOTAL INTERGOVERNMENTAL 65,000 66,411 65,000 69,133 69,401 70,592 70,401 34,377 70,401 0.0% - CHARGES FOR SERVICES 34101 CITY HALL RENT 9,000 7,493 9,000 - - - - - - 34103 ZONING AND SUBDIVISION FEES 4,500 5,738 4,500 1,824 4,500 4,067 4,500 3,393 4,500 0.0% - 34104 PASS -THRU CHARGES - - - 4,750 - (4,235) - 835 - - 34105 SALE OF COPIES 1,000 913 1,000 722 1,000 526 1,000 125 1,000 0.0% - 34107 SPECIAL ASSESSMENT SEARCHES 500 110 500 190 150 250 150 325 150 0.0% - 34780 RECREATION & CLASS FEES - 325 - 250 425 525 425 1,171 29,500 6841.2% 29,075 34781 TREE SALES 6,828 - 34785 PARK DONATIONS 31,000 27,070 31,000 34,146 29,000 32,718 29,000 19,971 - 100.0% (29,000) TOTAL CHARGES FOR SERVICES 46,000 41,649 46,000 41,882 35,075 33,851 35,075 32,648 35,150 0.2% 75 P4 FINES & FORFEITURES 35101 FINES & FORFEITS TOTAL FINES & FORFEITURES MISCELLANEOUS REVENUE 36210 INTEREST EARNINGS 36230 CONTRIBUTIONS AND DONATIONS FR 36240 REFUNDS & REIMBURSEMENTS 36260 DRY HYDRANT CHARGES 36265 CELLULAR ANTENNA REVENUE 36270 MISCELLANEOUS REVENUE 36275 CONCESSIONS /VENDING TOTAL MISCELLANEOUS REVENUE TRANSFERS 39202 TRANSFERS FROM ENTERPRISE FUNDS 39203 TRANSFERS FROM OTHER FUNDS TOTALTRANSFERS TOTAL REVENUES 55,000 52,968 55,000 55,806 52,000 48,720 54,500 26,474 57,000 4.6% 2,500 55,000 52,968 55,000 55,806 52,000 48,720 54,500 26,474 57,000 4.6% 2,500 117,000 58,624 95,000 46,769 45,000 25,629 45,000 35,000 -22.2% (10,000) - 820 - - - 1,340 - - - 10,000 11,349 10,000 13,423 - 28,930 - 14,009 10,000 10,000 3,500 3,332 3,500 (125) 3,500 245 3,500 4 3,500 0.0% - - - - _ - - - 150,000 150,000 17,000 8,236 17,000 26,444 15,000 21,217 15,000 9,714 15,000 0.0% - 2,500 394 2,500 394 400 394 400 400 0.0% - 150,000 82,755 128,000 86,905 63,900 77,755 63,900 23,727 213,900 234.7% 150,000 40,000 40,000 18,842 33,465 40,000 40,000 40,000 29,320 - 160,000 - 180,000 - - - 200,000 40,000 198,842 33,465 40,000 40,000 40,000 29,320 - 5,488,562 5,115,035 5,375,404 5,158,507 5,121,895 5,232,231 5,136,395 1,922,439 5,263,970 - 100.0% (40,000) - 100.0% (40,000 2.5% 127,575 P5 CITY COUNCIL Expenditure Coding: 101- 41110- PERSONAL SERVICES 101 FULL -TIME REGULAR 102 FULL -TIME OVERTIME 103 PART -TIME 106 OTHER 111 SEVERANCE PAY 121 PERA CONTRIB - CITY SHARE 122 FICA CONTRIB - CITY SHARE 131 EMPLOYEE INSURANCE - CITY SHARE 141 UNEMPLOYMENT COMPENSATION 151 WORKERS COMPENSATION TOTAL PERSONAL SERVICES Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 15,600 15,600 15,600 15,600 15,600 15,600 15,600 7,800 15,600 0.0% - 1,194 1,194 1,194 1,194 1,200 1,194 1,200 597 1,200 0.5% 6 16,794 16,794 16,794 16,794 16,800 16,794 16,800 8,397 16,800 0.0% 6 MATERIALS & SUPPLIES 245 GENERALSUPPLIES 1,400 3,064 3,064 1,175 1,300 684 3,000 165 2,000 338.6% 2,316 TOTAL MATERIALS & SUPPLIES 1,400 3,064 3,064 1,175 1,300 684 3,000 165 2,000 338.6% 2,316 SUPPORT SERVICES /CHARGES 302 CONSULTING FEES - - - - - 1,888 - (1,888) 331 TRAVEL, CONFERENCE &SCHOOLS 7,000 2,968 2,968 2,270 3,500 20,920 4,500 425 4,500 -78.5% (16,420) 351 PRINTING AND PUBLISHING - - - - - - 400 CONTRACTUAL SERVICES - - - - 36,649 3,120 - - 100.0% (3,120) 410 RENTALS - - - - - - - 433 DUES AND SUBSCRIPTIONS 45,000 43,190 43,190 43,506 43,169 40,477 47,690 18,376 47,000 17.8% 7,213 440 MISC SERVICES - - - - 19,112 9,658 34,125 10,475 2 24,467 TOTAL SUPPORT SERVICES /CHARGES 52,000 46,158 46,158 45,776 102,430 76,063 86,315 18,801 61,975 13.5% 10,252 TRANSFERS 720 OPERATING TRANSFERS - - - - - 1,379 13,600 40,000 12,221 TOTAL TRANSFERS - - - - - 1,379 13,600 - 40,000 12,221 TOTAL Council 70,194 66,016 66,016 63,745 120,530 94,920 119,715 27,363 120,775 26.1% 24,795 m ADMINSTRATION Expenditure Coding: 101- 41300- CAPITAL OUTLAY 540 MACHINERY &EQUIPMENT 7,500 6,540 5,600 2,844 - - - 135 - 560 FURNITURE AND FIXTURES - - 600 - - - - 580 OTHER IMPROVEMENTS - - - - - - - - TOTAL CAPITAL OUTLAY 7,500 6,540 6,200 2,844 - - - 135 - - TOTAL ADMINISTRATION 448,301 435,787 430,320 455,653 431,906 485,485 383,505 237,420 420,296 -21.0% 45,865 P7 Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar PERSONAL SERVICES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 101 FULL -TIME REGULAR 259,750 240,187 267,405 249,664 235,463 249,895 252,473 148,464 286,860 13.G% 34,387 102 FULL -TIME OVERTIME 400 422 - - - 74 - - - 103 PART -TIME 40,147 52,523 12,000 69,613 60,235 82,644 - 12,418 - - 121 PERA /ICMA CONTRIB - CITY SHARE 17,934 19,331 18,788 20,632 21,438 22,584 18,304 11,337 20,797 13.6% 2,493 122 FICA CONTRIB - CITY SHARE 21,106 22,240 20,534 21,174 22,621 25,138 19,314 12,104 21,945 13.6% 2,631 131 EMPLOYEE INSURANCE - CITY SHARE 35,064 28,814 41,313 34,235 34,239 46,752 29,384 24,156 30,069 2.3% 685 141 UNEMPLOYMENT COMPENSATION - 6,365 - 3,976 - 19 - 5,066 - - 151 WORKERS COMPENSATION - - - - - - - - - - TOTAL PERSONAL SERVICES 374,401 369,882 360,040 399,294 373,996 427,106 319,475 213,545 359,671 12.6% 40,196 MATERIALS & SUPPLIES 200 OFFICE SUPPLIES 7,800 4,556 7,250 3,172 6,000 4,001 7,000 2,149 5,000 2,999 208 POSTAGE 12,150 10,815 12,400 9,854 11,250 10,786 14,245 6,385 11,150 3,459 221 MAINTENANCE OF EQUIPMENT 2,200 1,585 1,700 1,665 2,050 1,665 1,700 1,364 1,400 35 245 GENERAL SUPPLIES 1,350 2,968 3,575 2,943 1,500 72 1,150 274 900 1,078 TOTAL MATERIALS 8, SUPPLIES 23,500 19,924 24,925 17,634 20,800 16,524 24,095 10,172 18,450 - 7,571 SUPPORT SERVICES /CHARGES 321 COMMUNICATIONS - TELEPHONE 500 944 1,000 873 960 1,012 960 527 1,100 -5.1% (52) 331 TRAVEL, CONFERENCE & SCHOOLS 9,180 5,172 5,350 3,101 5,650 3,669 5,895 1,774 8,710 60.7% 2,226 351 PRINTING AND PUBLISHING 3,500 890 4,500 2,683 2,000 3,218 3,200 848 2,000 400 CONTRACTUAL SERVICES 28,450 31,000 27,050 27,582 27,000 32,161 27,965 10,003 28,365 (4,196) 433 DUES AND SUBSCRIPTIONS 1,270 1,435 1,255 1,642 1,500 1,731 1,915 416 2,000 10.6% 184 440 MISC SERVICES - - - - - 64 - - - (64) TOTAL SUPPORT SERVICES /CHARGES 42,900 39,441 39,155 35,881 37,110 41,855 39,935 13,568 42,175 4.6% (1,902) CAPITAL OUTLAY 540 MACHINERY &EQUIPMENT 7,500 6,540 5,600 2,844 - - - 135 - 560 FURNITURE AND FIXTURES - - 600 - - - - 580 OTHER IMPROVEMENTS - - - - - - - - TOTAL CAPITAL OUTLAY 7,500 6,540 6,200 2,844 - - - 135 - - TOTAL ADMINISTRATION 448,301 435,787 430,320 455,653 431,906 485,485 383,505 237,420 420,296 -21.0% 45,865 P7 FINANCE Expenditure Coding: 101- 41500- SUPPORT SERVICES /CHARGES 301 AUDITING& ACCOUNTING SERVICES - 3,400 Approved 3,400 Dept 294 Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar PERSONAL SERVICES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 101 FULL -TIME REGULAR 137,679 132,533 137,679 118,664 137,679 128,624 102,399 67,398 106,078 3.6% 3,679 121 PERA CONTRIB - CITY SHARE 8,949 8,924 8,949 7,220 8,949 9,306 7,424 4,867 7,691 3.6% 267 122 FICA CONTRIB - CITY SHARE 10,532 10,102 10,532 8,484 10,532 9,175 7,834 4,765 8,115 3.6% 281 131 EMPLOYEE INSURANCE -CITY SHARE 20,477 14,473 20,477 12,874 20,477 16,689 10,759 4,034 11,045 2.7% 286 TOTAL PERSONAL SERVICES 177,637 166,032 177,637 147,242 177,637 163,794 128,416 81,064 132,929 3.5% 4,513 MATERIALS & SUPPLIES 1,200 5,183 800 - 5,400 -84.6% (4,383) TOTAL SUPPORT SERVICES /CHARGES 8,500 4,799 200 OFFICE SUPPLIES 1000 604 1000 109 1000 224 - - - (224) 221 MAINTENANCE OF EQUIPMENT 7,000 6,183 7,000 6,521 7,000 6,842 7,000 7,839 8,100 23% 158 245 GENERALSUPPLIES 200 165 200 946 200 719 300 93 300 -58.3% (419) TOTAL MATERIALS & SUPPLIES 8,200 6,952 8,200 7,576 8,200 7,785 7,300 7,932 8,400 -6.2% (485) SUPPORT SERVICES /CHARGES 301 AUDITING& ACCOUNTING SERVICES - 3,400 3,106 3,400 - - 294 331 TRAVEL, CONFERENCE & SCHOOLS 4,800 2,166 4,800 2,323 4,800 3,887 2,300 734 4,000 -40.8% (1,587) 351 PRINTING AND PUBLISHING 500 720 500 597 500 635 650 - 700 2.4% 15 360 UNALLOCATED INS - LTD - - - - - - - 400 CONTRACTUAL SERVICES 1,000 719 1,000 721 1,000 721 1,000 - 1,000 38.7% 279 433 DUES AND SUBSCRIPTIONS 1,000 698 1,000 60 1,000 290 1,000 280 500 244.8% 710 440 MISC SERVICES - - - - - - - 450 BANK SERVICE CHARGES 1,200 496 1,200 121 1,200 5,183 800 - 5,400 -84.6% (4,383) TOTAL SUPPORT SERVICES /CHARGES 8,500 4,799 8,500 7,222 8,500 13,822 9,150 1,014 11,600 -33.8% (4,672) CAPITAL OUTLAY 540 MACHINERY & EQUIPMENT 4,000 1,678 4,000 - 4,000 560 FURNITURE AND FIXTURES - - 580 OTHER IMPROVEMENTS 500 805 500 - S00 TOTAL CAPITAL OUTLAY 4,500 2,483 4,500 - 4,500 TOTAL FINANCE 198,837 180,266 198,837 162,040 198,837 185,401 144,866 90,010 152,929 -21.9% (40,535) w PROFESSIONAL SERVICES Expenditure Coding: 101- 41600- TOTAL PROFESSIONAL SERVICES 205,500 223,859 223,859 178,604 223,859 188,963 199,320 130,640 203,390 5.5% w Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent SUPPORT SERVICES /CHARGES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change 301 AUDITING & ACCOUNTING SERVICES 25,000 19,835 19,835 20,573 19,835 30,347 24,000 4,000 25,000 -20.9% 304 CIVIL LEGAL CONTRACT 77,500 82,567 82,567 36,989 82,567 36,007 44,400 15,319 44,400 23.3% 304 PROSECUTION CONTRACT 30,224 30,224 27,500 30,224 28,350 33,000 13,750 33,990 16.4% 400 CONTRACTUAL ASSESSOR SERVICES 93,000 90,549 90,549 93,492 90,549 94,259 97,920 97,571 100,000 3.9% 440 MISC SERVICES 10,000 684 684 50 684 - - - - TOTAL SUPPORT SERVICES/CHARGES 205,500 223,859 223,859 178,604 223,859 188,963 199,320 130,640 203,390 5.5% TOTAL PROFESSIONAL SERVICES 205,500 223,859 223,859 178,604 223,859 188,963 199,320 130,640 203,390 5.5% w PLANNING Actual Actual Actual Actual Actual Actual Requested Percent Revenue Coding: 101 - PERSONAL SERVICES 2009 2009 2009 2010 2009 2011 2012 Expenditure Coding: 101- 41910- Increase 101 FULL -TIME REGULAR 87,853 141,729 141,729 138,584 Approved 132,198 Dept 69,527 133,887 Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar REVENUE 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 34103 Zoning and Subdivision Fees 4,500 5,738 4,500 1,824 4,500 4,067 4,500 3,393 4,500 433 TOTALREVENUE 4,500 5,7 4,500 1,824 4,500 4,067 4,500 3,393 4,500 - 433 P10 Actual Actual Actual Actual Actual Actual Requested Percent Dollar PERSONAL SERVICES 2009 2009 2009 2010 2009 2011 2012 Increase Increase 101 FULL -TIME REGULAR 87,853 141,729 141,729 138,584 141,729 132,198 133,887 69,527 133,887 0.0% - 102 OVERTIME - - - - - - - 103 PART -TIME 66,848 15,027 15,027 1,142 15,027 - - - - - 106 OTHER - - - - - - - - 111 SEVERANCE PAY - - - - - - - - - 121 PERA CONTRIB - CITY SHARE 10,056 10,376 10,376 9,274 10,376 9,508 9,707 5,005 9,707 0.0% - 122 FICA CONTRIB - CITY SHARE 11,835 11,106 11,106 8,971 11,106 9,187 10,242 4,698 10,242 0.0% - 131 EMPLOYEE INSURANCE - CITY SHAR 23,009 17,236 17,236 17,582 17,236 17,263 16,830 6,316 16,830 0.0% - 141 UNEMPLOYMENT COMPENSATION - - - - - - - 2 - 151 WORKERS COMPENSATION - - - - - - " TOTAL PERSONAL SERVICES 199,601 195,474 195,474 175,553 195,474 168,156 170,666 88,269 170,666 1.5% 2,510 MATERIALS 8, SUPPLIES 200 OFFICE SUPPLIES 100 510 510 71 510 249 - - - 1249) 221 MAINTENANCE OF EQUIPMENT 405 405 405 - 405 - 405 - 400 405 245 GENERALSUPPLIES 1,250 1,223 1,223 78 1,223 12 250 - 250 1983.3% 238 TOTAL MATERIALS &SUPPLIES 1,755 2,138 2,138 149 2,138 261 655 - 650 151.0% 394 SUPPORT SERVICES /CHARGES 304 LEGAL FEES - - - - - - - - - 321 COMMUNICATIONS - CELLULAR PHON 1,200 1,301 1,301 1,109 1,301 923 800 429 800 -13.3% (123) 331 TRAVEL, CONFERENCE & SCHOOLS 4,600 1,904 1,904 4,177 1,904 3,916 4,012 355 2,000 2.5% 96 351 PRINTING AND PUBLISHING 500 1,298 1,298 732 1,298 1,266 1,000 721 1,000 -21.0% (266) 400 CONTRACTUAL SERVICES 4,900 3,660 3,660 - 3,660 963 2,500 - 2,500 159.6% 1,537 433 DUES AND SUBSCRIPTIONS 750 827 827 864 827 1,011 1,100 1,004 1,100 8.8% 89 440 MISC SERVICES - - - " TOTAL SUPPORT SERVICES /CHARGES 11,950 8,990 8,990 6,882 8,990 8,079 9,412 2,509 7,400 16.5% 1,333 CAPITAL OUTLAY 540 MACHINERY &EQUIPMENT - - - - - - - - " 560 FURNITURE AND FIXTURES - - - - - - - 200 " 580 OTHER IMPROVEMENTS - - - " TOTAL CAPITAL OUTLAY - - - - - - 200 - TOTAL PLANNING 213,306 206,602 206,602 182,584 206,602 176,496 180,733 90,778 178,916 2.4% 4,2 Net Levy Impact $ 208,806 $ 200,864 $ 202,102 $ 180,760 $ 202,102 $ 172,429 $ 176,233 $ 87,385 $ 174,416 $ 0 $ 3,804 P10 MUNICIPAL BUILDINGS Expenditure Coding: 101- 41940- SUPPORT SERVICES /CHARGES 302 CONSULTING FEES - - - - - - Approved 805 Dept - 321 COMMUNICATIONS - Warner Conn. Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar MATERIALS &SUPPLIES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 221 MAINTENANCE OF EQUIPMENT 21,300 32,020 32,020 48,384 32,020 45,472 14,000 11,545 11,400 -69.2% (31,472) 223 MAINTENANCE OF BUILDINGS 5,000 119 119 883 119 2,899 - 589 7,800 34.7% (2,899) 245 GENERALSUPPLIES - 2,182 2,182 1,977 2,182 1,631 2,500 1,246 2,930 53.3% 869 TOTAL MATERIALS & SUPPLIES 26,300 34,321 34,321 51,244 34,321 50,002 16,500 13,380 22,130 -67.0% (33,502) SUPPORT SERVICES /CHARGES 302 CONSULTING FEES - - - - - - - 805 - - 321 COMMUNICATIONS - Warner Conn. 7,000 6,523 6,523 2,771 6,523 3,287 34,000 15,404 34,000 934.4% 30,713 331 TRAVEL, CONFERENCE & SCHOOLS - - - 542 - - - - - 360INSURANCE 110,000 98,796 98,796 33,942 98,796 103,252 105,000 106,143 110,000 1.7% 1,748 380 UTILITY SERVICES 10,000 10,671 10,671 7,700 10,671 8,168 11,000 2,961 11,000 34.7% 2,832 400 CONTRACTUAL SERVICES 11,000 6,640 6,640 8,173 6,640 11,083 7,500 4,778 9,800 -32.3% (3,583) 410 RENTALS 1,500 1,328 1,328 1,368 1,328 1,004 250 1,004 - -75.1% (754) 437 TAXES /LICENSES - - - - - - - 440 MISCSERVICES - - - - - - - TOTAL SUPPORT SERVICES /CHARGES 139,500 123,958 123,958 54,496 123,958 126,794 157,750 131,095 164,800 24.4% 30,956 CAPITAL OUTLAY 520 BUILDINGS & STRUCTURES - - - - - 250 - - (250) 540 MACHINERY &EQUIPMENT 1,000 - - 15,713 - 1,284 - 352 - (1,284) 560 FURNITURE AND FIXTURES - - - - - - - - - 580 OTHER IMPROVEMENTS - - - - - - - - - TOTAL CAPITAL OUTLAY 1,000 - - 15,713 - 1,534 - 352 - (1,534) EDA DEBT SERVICE 601 BOND PRINCIPAL 25,000 - - - - - - #DIV /01 - 611 BOND INTEREST 75,120 5,425 5,425 2,959 5,425 - - #DIV /0! - TOTALEDADEBTSERVICES 100,120 5,425 5,425 2,959 5,425 - - - - #DIV /01 - TRANSFERS 720 OPERATING TRANSFERS 110,000 99,773 99,773 160,368 99,773 103,950 102,200 100,450 (1,750) TOTAL TRANSFERS 110,000 99,773 99,773 160,368 99,773 103,950 102,200 - 100,450 (1,750) TOTAL MUNICIPAL BUILDINGS 376,920 263,477 263,477 284,780 263,477 282,280 276,450 144,827 287,380 -2% (5,830) P11 POLICE 50 26 26 Expenditure Coding: 101-42100 - 26 45 - 11 50 Approved Dept 938,950 Budget Actual Budget Actual Budget Actual Budget YTD Request Percent MATERIALS & SUPPLIES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change 245 GENERAL SUPPLIES - - - 1,367 - - - 4,000 TOTAL MATERIALS & SUPPLIES - - - 1,367 - - - - - SUPPORT SERVICES /CHARGES 380 UTILITY SERVICES 50 26 26 41 26 45 - 11 50 - 100.0% 400 CONTRACTUAL SERVICES 938,950 941,396 941,396 947,298 941,396 994,787 987,085 494,243 1,013,027 -0.8% 440 MISC SERVICES 4,000 2,567 2,567 1,998 2,567 1,939 2,000 204 2,000 3.1% TOTAL SUPPORT SERVICES /CHARGES 943,000 943,989 943,989 949,337 943,989 996,771 989,085 494,458 1,015,077 -0.8% CAPITAL OUTLAY 520 BUILDINGS & STRUCTURES 233,000 232,940 232,940 228,068 232,940 230,068 225,132 112,566 235,437 -2.1% TOTAL CAPITAL OUTLAY 233,000 232,940 232,940 228,068 232,940 230,068 225,132 112,566 235,437 -2.1% TOTAL POLICE PROTECTION 1,176,000 1,176,929 1,176,929 1,178,772 1,176,929 1,226,839 1,214,217 607,024 1,250,514 -1.0% P12 FIRE Expenditure Coding: 101- 42200- TOTAL FIRE PROTECTION 600,638 600,450 600,450 595,164 600,450 607,828 610,711 304,946 637,225 015% P13 Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent SUPPORT SERVICES /CHARGES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change 400 Excelsior Fire 316,138 298,175 298,175 298,113 298,175 312,549 307,705 159,852 324,999 -1.5% 400 Mound Fire Contract - 25,005 25,005 24,422 25,005 24,582 25,100 6,141 24,583 2.1% TOTAL SUPPORT SERVICES /CHARGES 316,138 323,180 323,180 322,535 323,180 337,131 332,805 165,993 349,582 -1.3% CAPITAL OUTLAY 520 BUILDINGS & STRUCTURES 284,500 277,270 277,270 272,629 277,270 270,697 277,906 138,953 287,643 2.7% TOTAL CAPITAL OUTLAY 284,500 277,270 277,270 272,629 277,270 270,697 277,906 138,953 287,643 2.7% TOTAL FIRE PROTECTION 600,638 600,450 600,450 595,164 600,450 607,828 610,711 304,946 637,225 015% P13 PROTECTIVE INSPECTIONS COMMUNICATIONS - CELLULAR PHONE Actual Actual Actual Actual Actual Adopted Requested - Percent Expenditure Coding: 101 - 42400- PERSONAL SERVICES 2009 2009 2009 2009 Approved 2011 Dept -13.8% (400) Increase Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar REVENUE 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 32210 Building Permits 180,000 97,651 90,000 118,189 70,000 123,141 80,000 51,901 80000 -35.0% (43,141) 32215 Plan Check Fees - 12,336 - 23,679 11,000 24,225 12,000 14,994 12000 -50.5% (12,225) Miscellaneous Revenue 6,916 3,072 7,085 2.4% 169 131 EMPLOYEE INSURANCE - CITY SHARE 12,360 100 10,475 11,381 TOTAL REVENUE 180,000 109,987 90,000 141,868 81,000 147,366 92,000 66,895 92,100 -37.6% (55,366) MATERIALS & SUPPLIES 200 OFFICE SUPPLIES - - - 245 GENERALSUPPLIES 750 139 139 TOTAL MATERIALS & SUPPLIES 750 139 139 SUPPORT SERVICES /CHARGES E 154 22 139 - 200 28 139 154 200 - (154) 200 200 200 29.9% 46 321 COMMUNICATIONS - CELLULAR PHONE Actual Actual Actual Actual Actual Adopted Requested - Percent Dollar PERSONAL SERVICES 2009 2009 2009 2009 2009 2011 2012 -13.8% (400) Increase Change 101 FULL -TIME REGULAR 83,103 88,521 88,521 90,428 88,521 96,525 90,403 46,410 92,613 2.4% 2,210 102 PART -TIME 13,370 7,275 7,275 1,285 7,275 - 1,500 433 1,500 0.0% - 121 PERA CONTRIB - CITY SHARE 6,271 6,267 6,267 6,092 6,267 6,844 6,554 3,240 6,714 2.4% 160 122 FICA CONTRIB - CITY SHARE 7,380 6,646 6,646 5,895 6,646 6,460 6,916 3,072 7,085 2.4% 169 131 EMPLOYEE INSURANCE - CITY SHARE 12,360 10,475 10,475 11,381 10,475 12,342 12,676 4,795 12,676 0.0% - TOTALPERSONALSERVICES 122,484 119,184 119,184 115,081 119,184 122,171 118,049 57,517 120,588 -3.4% (4,122) MATERIALS & SUPPLIES 200 OFFICE SUPPLIES - - - 245 GENERALSUPPLIES 750 139 139 TOTAL MATERIALS & SUPPLIES 750 139 139 SUPPORT SERVICES /CHARGES E 154 22 139 - 200 28 139 154 200 - (154) 200 200 200 29.9% 46 321 COMMUNICATIONS - CELLULAR PHONE 450 470 470 244 470 - - - - 331 TRAVEL, CONFERENCE & SCHOOLS 3,400 2,799 2,799 2,785 2,799 2,900 2,500 2,500 -13.8% (400) 351 PRINTING AND PUBLISHING 300 668 668 116 668 135 36 150 400 CONTRACTUAL SERVICES 6,400 1,610 1,610 1,330 1,610 1,278 2,500 595 2,500 95.6% 1,222 433 DUES AND SUBSCRIPTIONS 150 100 100 100 100 125 150 150 2010% 25 TOTAL SUPPORT SERVICES /CHARGES 10,700 5,647 5,647 4,575 5,647 4,438 5,150 631 5,300 16.0% 712 CAPITAL OUTLAY 540 MACHINERY & EQUIPMENT 560 FURNITURE AND FIXTURES TOTAL CAPITAL OUTLAY 1,298 1,298 - 1,298 1,298 - 1,298 TOTAL PROTECTIVE INSPECTIONS 133,934 126,268 126,268 119,684 126,268 126,763 123,399 58,148 126,088 -2.7% (3,364) Net Levy Support (46,066) 16,281 36,268 (22,184) 45,268 (20,603) 31,399 (8,747) 33,988 P14 CITY ENGINEER Expenditure Coding: 101- 43010- SUPPORT SERVICES /CHARGES 303 ENGINEERING FEES 5,000 1,825 1,825 4,620 1,825 5,236 Approved 3,875 Dept -4.5% (236) Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar PERSONAL SERVICES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Change Change 101 FULL -TIME REGULAR 102,767 86,821 86,821 74,859 86,821 75,297 72,196 31,524 73,640 2.0% 1,444 121 PERA CONTRIB - CITY SHARE 6,680 4,826 4,826 4,993 4,826 5,424 5,234 2,267 5,339 2.0% 105 122 FICA CONTRIB - CITY SHARE 7,862 6,581 6,581 5,437 6,581 5,704 5,523 2,387 5,633 2.0% 110 131 EMPLOYEE INSURANCE - CITY SHARE 15,285 9,160 9,160 9,208 9,160 9,794 7,919 2,982 7,937 0.2% 18 TOTAL PERSONAL SERVICES 132,594 107,388 107,388 94,497 107,388 96,219 90,872 39,160 92,549 1.8% 1,677 MATERIALS & SUPPLIES 300 136 300 -59.6% ( 442) TOTAL SUPPORT SERVICES /CHARGES 18,653 7,639 7,639 8,937 200 OFFICE SUPPLIES 370 395 395 119 395 409 150 104 150 -63.3% (259) 221 MAINTENANCE OF EQUIPMENT - - - - - - - - 8,700 - 245 GENERALSUPPLIES 530 346 346 33 346 86 50 50 -41.9% (36) TOTAL MATERIALS & SUPPLIES 900 741 741 152 741 495 200 104 200 -59.6% (295) SUPPORT SERVICES /CHARGES 303 ENGINEERING FEES 5,000 1,825 1,825 4,620 1,825 5,236 5,000 3,875 5,000 -4.5% (236) 321 COMMUNICATIONS- CELLULAR PHONE 600 547 547 411 547 250 60 60 -76.0% (190) 331 TRAVEL, CONFERENCE & SCHOOLS 6,650 3,375 3,375 1,400 3,375 5,634 2,500 1,249 2,500 -55.6% (3,134) 351 PRINTING AND PUBLISHING 2,173 792 792 177 792 40 300 212 300 650.0% 260 400 CONTRACTUAL SERVICES 500 - - - - - - - #DIV /01 - 410 RENTAL 2,000 267 267 - 267 248 600 - 141.9% 352 433 DUES AND SUBSCRIPTIONS 830 833 833 2,197 833 1,400 3,200 1,546 3,060 128.6% 1,800 437 TAXES /LICENSES 900 - - 132 - 742 300 136 300 -59.6% ( 442) TOTAL SUPPORT SERVICES /CHARGES 18,653 7,639 7,639 8,937 7,639 13,550 11,960 7,018 11,220 -11.7% (1,590) CAPITAL OUTLAY 540 MACHINERY & EQUIPMENT 8,700 2,854 2,854 538 2,854 1,057 - - - 100.0% (1,057) 560 FURNITURE AND FIXTURES 210 - - - - - - - - 580 OTHER IMPROVEMENTS - - - - - - - - TOTAL CAPITAL OUTLAY 8,910 2,854 2,854 538 2,854 1,057 - - - - 100.0% (1,057) TOTAL CITY ENGINEER 161,057 118,622 118,622 104,124 118,622 111,321 103,032 46,282 103,969 - 7.4% (8,289) P15 PUBLIC WORKS Expenditure Coding: 101- 43050- MATERIALS & SUPPLIES 200 OFFICE SUPPLIES - 16 - 126 200 229 200 Approved 200 Dept (29) 212 MOTOR FUELS & LUBRICATION 51,750 27,668 Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar PERSONAL SERVICES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Increase Change 101 FULL -TIME REGULAR 306,448 283,371 313,546 318,540 242,559 303,535 325,676 143,379 334,078 2.6% 8,402 102 OVERTIME 5,500 1,850 5,772 1,053 3,200 1,132 2,500 934 2,500 0.0% - 103 PART -TIME - 460 - 1,302 - 640 - 115,838 - 144,931 - 121 PERA CONTRIB CITY SHARE 20,277 19,191 22,352 21,753 17,722 22,090 23,611 10,383 24,402 3.3% 791 122 FICA CONTRIB - CITY SHARE 23,864 21,194 24,427 23,636 18,701 22,545 24,914 10,596 25,748 3.3% 834 131 EMPLOYEE INSURANCE - CITY SHARE 45,579 33,658 47,988 38,817 31,685 39,976 41,932 15,787 42,047 0.3% 115 1,800 TOTAL PERSONAL SERVICES 401,668 359,724 414,085 405,101 313,867 389,918 418,633 181,079 428,775 2.4% 10,142 MATERIALS & SUPPLIES 200 OFFICE SUPPLIES - 16 - 126 200 229 200 161 200 -12.7% (29) 212 MOTOR FUELS & LUBRICATION 51,750 27,668 43,123 37,660 43,000 49,822 51,000 22,679 51,000 2.4% 1,178 221 MAINTENANCE OF EQUIPMENT 16,200 19,448 16,300 15,131 16,150 17,555 16,000 36,695 16,500 -8.9% (1,555) 223 MAINTENANCE OF BUILDINGS 2,050 865 2,000 1,502 2,000 1,324 4,000 1,881 2,500 202.1% 2,676 240 SMALL TOOLS AND MINOR EQUIPMENT 2,200 908 2,000 802 1,775 860 1,775 650 1,500 106.4% 915 245 GENERAL SUPPLIES 88,700 66,933 101,200 89,710 99,600 89,257 99,600 41,008 99,600 11.6% 10,343 TOTAL MATERIALS & SUPPLIES 160,900 115,838 164,623 144,931 162,725 159,047 172,575 103,074 171,300 8.5% 13,528 SUPPORT SERVICES /CHARGES 303 ENGINEERING 3,634 305 DRUG TESTING 1,300 - 1,300 - 1,300 - 1,300 - 1,800 #DIV /0! 1,300 321 COMMUNICATIONS - TELEPHONE 3,200 1,527 3,200 1,950 3,200 2,169 3,200 1,422 3,200 47.5% 1,031 331 TRAVEL, CONFERENCE &SCHOOLS 3,450 2,800 3,950 3,060 7,450 2,775 7,450 2,870 7,500 168.5% 4,675 351 PRINTING AND PUBLISHING - 2,896 - - - - - - - 380 UTILITY SERVICES 18,400 10,285 15,000 10,325 14,300 11,124 14,300 4,481 14,550 28.6% 3,176 399 UTILITIES - STREETLIGHTS - 40,849 41,049 38,882 41,049 42,163 41,049 17,654 41,500 400 CONTRACTUAL SERVICES 54,840 58,776 56,690 57,045 70,990 67,956 60,190 18,131 63,000 -11.4% (7,766) 410 RENTALS 1,200 283 1,200 331 1,000 - 1,000 598 1,000 #DIV /01 1,000 433 DUES AND SUBSCRIPTIONS 2,200 1,518 1,500 1,584 1,500 1,500 1,500 1,609 1,500 0.0% - 437 TAXES /LICENSES 850 317 850 846 850 514 850 875 900 65.4% 336 440 MISC SERVICES 43,000 314 3,210 3,921 3,600 7,924 3,600 505 3,600 -54.6% (4,324) TOTAL SUPPORT SERVICES /CHARGES 128,440 119,565 127,949 117,944 145,239 139,759 134,439 48,145 138,550 -3.8% (5,320) CAPITAL OUTLAY 520 BUILDINGS &STRUCTURES - - 540MACHINERY &EQUIPMENT 2,750 5,003 3,800 560 FURNITURE AND FIXTURES 750 - - 580 OTHER IMPROVEMENTS - - 900 300 TOTAL CAPITAL OUTLAY 3,500 5,003 3,800 1,200 TRANSFERS 720 OPERATING TRANSFERS- EQUIPMENT 875,000 875,000 800,000 800,000 750,000 750,000 750,000 772,500 0.0% - TOTALTRANSFERS 875,000 875,000 800,000 800,000 750,000 750,000 750,000 - 772,500 0.0% - TOTAL PUBLIC WORKS 1,569,508 1,475,130 1,510,457 1,467,976 1,371,831 1,438,724 1,475,647 332,298 1,512,325 2.6% 36,923 P16 ICE AND SNOW REMOVAL Expenditure Coding; 101- 43125- PERSONAL SERVICES 101 FULL -TIME REGULAR 102 OVERTIME 103 PART -TIME 106 OTHER 111 SEVERANCE PAY 121 PERA CONTRIB - CITY SHARE 122 FICA CONTRIB - CITY SHARE 131 EMPLOYEE INSURANCE -CITY SHARE 141 UNEMPLOYMENT COMPENSATION 151 WORKERS COMPENSATION Budget 2009 Actual 2009 Budget 2010 Actual 2010 Budget 2011 Actual 2011 Approved Budget 2012 YTD 2012 Dept Request 2013 Percent Increase Dollar Change 26,736 23,995 23,995 27,444 38,238 17,416 36,052 9,540 37,455 3.9% 1,403 5,000 5,226 5,226 18,317 7,500 11,091 7,500 1,864 7,500 0.0% - 2,063 1,981 1,981 2,645 2,772 2,598 3,064 827 3,259 195 2,428 2,178 2,178 2,759 2,925 2,629 3,332 818 3,439 3.2% 107 4,945 2,615 2,615 3,887 5,132 4,225 5,076 1,930 5,009 -1.3% (67) TOTAL PERSONAL SERVICES 41,172 35,995 35,995 55,052 56,567 37,959 55,024 14,979 56,662 3.0% 1,638 MATERIALS & SUPPLIES 245 GENERAL SUPPLIES 45,340 38,457 38,457 32,451 45,117 29,462 45,117 10,247 TOTAL MATERIALS & SUPPLIES 45,340 38,457 38,457 32,451 45,117 29,462 45,117 10,247 SUPPORT SERVICES /CHARGES 331 TRAVEL, CONFERENCE & SCHOOLS - - - - - - - TOTALSUPPORTSERVICES /CHARGES - - - - - - - - CAPITAL OUTLAY 540 MACHINERY &EQUIPMENT - - - - - - - TOTAL CAPITAL OUTLAY - - - - - - - 45,000 53.1% 15,655 45,000 53.1% 15,655 TOTAL ICE & SNOW CONTROL 86,512 74,452 74,452 87,503 101,684 67,421 100,141 25,226 101,662 48.5% 32,720 P17 PARKS MAINTENANCE Expenditure Coding: 101 - 45200- ENGINEERING FEES 14,013 14,013 14,013 - - Approved - Dept 2,000 - 321 Budget Actual Budget Actual Budget Actual Budget YTD Request Percent - 100.0% Dollar PERSONAL SERVICES 2009 2009 2010 2010 2011 2011 2012 2012 2013 Increase Change 101 FULL -TIME REGULAR 95,949 95,949 95,949 102,710 124,702 102,797 67,732 42,403 69,784 -34.1% 160 (35,065) 102 OVERTIME 2,222 2,222 2,222 1,870 2,500 1,462 2,500 7,761 2,500 71.0% 9,000 1,038 103 PART -TIME 22,100 22,100 22,100 21,314 22,000 17,441 12,000 1,281 12,000 -31.2% 7,200 (5,441) 121 PERA CONTRIB - CITY SHARE 6,773 6,773 6,773 7,437 9,041 7,848 5,092 3,075 5,241 -35.1% 9,750 (2,756) 122 FICA CONTRIB - CITY SHARE 8,575 8,575 8,575 8,719 9,540 8,718 6,291 3,075 6,448 -27.8% - (2,427) 131 EMPLOYEE INSURANCE - CITY SHARE 11,913 11,913 11,913 11,587 17,925 13,852 7,373 2,749 7,386 -46.8% 30,910 (6,479) TOTAL PERSONAL SERVICES 147,532 147,532 147,532 153,637 185,708 152,118 100,988 52,583 103,358 -33.6% (51,130) MATERIALS & SUPPLIES 208 POSTAGE - - - - - 255 255 - 221 MAINTENANCE OF EQUIPMENT 841 841 841 2,896 5,000 2,858 5 - 4,000 74.9% 2,142 223 MAINTENANCE OF BUILDINGS 284 284 284 920 4,000 1,088 4,000 257 5,000 267.6% 2,912 240 SMALL TOOLS AND MINOR EQUIPMENT 63 63 63 604 800 344 800 800 132.6% 456 245 GENERAL SUPPLIES 8,906 8 8,906 9,817 10,000 12,849 8,500 11,795 9,500 -33.8% (4,349) TOTAL MATERIALS & SUPPLIES 10,094 10,094 10,094 14,237 19,800 17,394 18,300 12,307 19,300 5.2% 906 SUPPORT SERVICES /CHARGES 303 ENGINEERING FEES 14,013 14,013 14,013 - - - - 2,000 - 321 COMMUNICATIONS - TELEPHONE 1,695 1,695 1,695 1,747 1,900 1,770 - 1,800 - 100.0% (1,770) 331 TRAVEL, CONFERENCE & SCHOOLS - - - - - 23 1,000 1,000 977 351 PRINTING AND PUBLISHING - - - 105 1,000 160 - 38 160 - 100.0 %. (160) 380 UTILITY SERVICES 8,179 8,179 8,179 7,613 9,000 7,761 9,000 3,439 9,000 16.0% 1,239 400 CONTRACTUAL SERVICES 73,949 73,949 73,949 76,352 70,000 67,702 7,000 4,555 7,200 -89.7% (60,702) 410 RENTALS 11,709 11,709 11,709 10,240 9,500 9,501 9 5,620 9,750 0.0% (1) 440 MISC SERVICES 236 236 236 - 500 173 - - - 100.0% (173) TOTAL SUPPORT SERVICES /CHARGES 109,781 109,781 109,781 96,057 91,900 87,090 26,500 13,652 30,910 .69.6% (60,590) TRANSFERS 720 OPERATING TRANSFERS - - - TOTAL TRANSFERS - - - - - TOTAL PARKS MAINTENANCE 267,407 267,407 267,407 263,931 297,408 256,602 145,788 78,542 153,568 -43.2% (110,814) mu RECREATION Revenue Coding: 101 - Expenditure Coding: 101 - 45300- Approved Dept Budget Actual Budget Actual Budget Actual Budget YTD Request Percent Dollar REVENUE 2009 2009 2010 2010 2011 2011 2012 2012 2013 Increase Change 34780 Recreation & Class Fees 31,000 27,395 31,000 34,396 29,425 33,243 29,425 21,142 29,500 -11.5% (3,818) Actual Actual Actual Adopted Requested Percent Dollar PERSONAL SERVICES 2009 2010 2011 2012 2013 Increase Change 101 FULL -TIME REGULAR 49,235 15,456 21,882 -55.6% (27,353) 102 OVERTIME - - - 103 PART -TIME 10,000 1,497 10,000 0.0% - 106 OTHER - - - 111 SEVERANCE PAY - - - 121 PERA CONTRM - CITY SHARE 3,570 1,229 1,586 -55.6% (1,984) 122 FICA CONTRIB - CITY SHARE 4,531 1,238 2,439 -46.2% (2,093) 131 EMPLOYEE INSURANCE - CITY SHARE 1,020 409 453 -55.6% (567) TOTAL PERSONAL SERVICES - - - 68,356 19,829 36,360 -46.8% (31,997) MATERIALS & SUPPLIES 245 GENERALSUPPLIES 1,500 1,000 1,500 1,500 TOTAL MATERIALS & SUPPLIES - - - 1,500 1,000 1,500 1,500 SUPPORT SERVICES /CHARGES 302 CONSULTING FEES - - 303 ENGINEERING FEES - - 304 LEGAL FEES - - 321 COMMUNICATIONS - TELEPHONE 1,900 728 2,100 1,900 331 TRAVEL, CONFERENCE & SCHOOLS 1,500 179 1,500 1,500 351 PRINTING AND PUBLISHING 1,000 904 1 1,000 400 CONTRACTUAL SERVICES 29,500 9,823 14,795 29,500 433 DUES AND SUBSCRIPTIONS 250 250 250 TOTAL SUPPORT SERVICES /CHARGES - - - 34,150 11,634 20,145 34,150 TRANSFERS 720 OPERATING TRANSFERS 45,000 45,000 42,000 42,000 42,000 42,000 42,000 - 42,000 0.0% - TOTAL TRANSFERS 45,000 45,000 42,000 42,000 42,000 42,000 42,000 - 42,000 0.0% - TOTAL PARKS AND RECREATION 45,000 45,000 42,000 42,000 42,000 42,000 146,006 32,463 100,005 247.6% 104,006 Net Levy Support 14,000 17,605 11,000 7,604 12,575 8,757 116,581 11,321 70,505 1231.3% 107,824 P19 P1 4FSn00 42400 43 010 43050 43100 43200 43250 5 45200 45300 490 60J� 6111 621, 6311 _ _. Gen - Plan/ Prat e Public iStreetsi Snow P b1i L Storm Total Pestle Admin Govt Ele t Pon ( In Engr ROads Weeds, Trees Ice 'Parks Rec -- ! SSCC Water Sewer Recycl' Water City Administrator 1.000 1.00 2012 Allocation 1.000 _ _ L _ r 100 ._ 2011 1.000 �. L_ _ 100. 2010 1.000 1 1 O0 2009 1.000 1 - �. .. .1.00 3 YearAverage 1.000 _. -i 1.00 Dep. City Clerk 3.000 �.. _ �_ �. 1.00 2012 Allocation 1.000 1 = __100 2011 0.238 0.762 0 _ ..1.00 2010 0.203 0.556 0.240 I 1 .. i._ _ 11 _ 2009 0.259 0.733 0 _ . -_ ! , _ I _ 1.00 3 Year Average 0.233 0.684 0.083 1.00 Admin. Asst. 0350 0100 0.070 0.0801 -I 1.00 2012 A 0.750 0 TOO _ ,._ 0.070 0 080 it 1 00 2011 0.790 0 00720003 0 00571 0061 0.017 100 2010 0.703 0058 0087 0 0031 11- 0.0011 0 073 D 073 0 0001 f 100 2009 0.766 0 000 0.1031 0 000 I � 0 0 0661 000 . 0 066f 0 000 1 00 3 YearAverage 0.753 0.019 1 - 0.087 - 0.002 - _, 0.000 0.065 0.0671 0.0061 1.00 Admi A sst. 0.600 1.00 2012 A_Ilocation _ I 1 _ 0100 _ 0.900 1 _ _ 1.00 2011 0.507 0 00231 x0463; 1 00001 M07 0000 it 100 _ 2010 0.503 0 025 0 024 _ 1 OA41 0.002 0.001 0 0031 ( 1 00 _ 2009 0.562 0 000 _ 0.028 0 407 0 000 0.0021 0 001 1 00 3 Year Average 0.514 0.008 _ 0.025 _ 0.437'.. 0.001' 0.003 0.001 1.00 Comm. Coard 0.650 _ _ _ 0 .100 0.75 2012 A 0.650 ll J- _ 2011 0.459 1 i _ 0.057 1 0 085 .. 0.0601 066 _. - 2010 0.449 1 '.. 0 0056, 0082 065 2009 0.562 1. 0 0631 0 000 0.0661 0 69 3 YearAverage 0.490 0.062 _ 0 0471 - 0.069 0.67 Finance Director 0.7001 0.3001 0.100 1.00 2012 Allocati O 1060 _ { . 105001 0100 wil I I i 1010011 - -100 1 I 2009 1 ... 1 000 - 100 3Year Average _ 1.000' Sr. Acco 0.700 0.100 0.1001 - 0.100 _1.00 2012 Allocati I.. 0700 {{II �.. 01001 0 010011 1.00 2011 07001 L. - 0 100 01001 01001 1 00 2010 0664 - .01141 0.111 __ 0.1171 _100 2009 { 1 0 659 0.115_ 0.113 0 113 1 3 _ 1,p0 Year Average 0.674 - 0.110 0 108 0.108 1.00 Planning Director 0.950 0.050' I -�� 2012Allocation �� ( 1.00 20111 �_ 1 .. � 0956044 100 2 010 0976100241_ _1 100 2009 6.678 0 022 �- - - -- -- - LOO 3 Year Average _ "' 0.9701 0.030 1.00 P1 41300 41400 41410 41500 41910 42400 43010 43050 43100 43250 43125 �45200 45300 1- 601 + 490 _ 611 E 6211 631 Gen plan) 1 Prot Public �Streets143200 _ Snow � Storm T otal Position Admin Govt Elect fin Zone Ins En r Works, g Roads Weeds; Trees Ice Parks Rec SSCC Water': Sewer Rec cl Water y Planning Asst 0.700 0.100 _.0.80 2012 Allocation 0700 01001171 1 �_ _ L_ { I 0 .80 _ 20111 06441 0 O OOO 1 ! -. 082 _ 20101 {I 0_ 706 0.1131 _ 0.002 �{ _ 0.82 -- 2009 0 0054!_00041 _095 3 Year Average 10.747 1 0.113 0.002 0.86 Building Official 1.000 �_ ( 1.00 2012 Allocation 1.00 20111 1 000 100 2010 _ L 1 .100 2009__ 1.0001 _ { .. _ 1.. 3 YearAvera a _ 1.000 '.. _� 0 City Engineer 0.900 0.3001 -� _1.00 2012 Allocation 0900 _ 1 ( 0.100 100 20111 000 �. 0.013 0056 1.00 2010 _ 0.01 � 0018 100 2069 1 - �� 0960 -_ 0 0021 0.000 0.037 __ 3 Year Average 01 956 _'. 0.003 1 i 0.004 _ -- _ 0.037 1.00 PW Director 0.750 0.100 0.100 0.050 _1.00 2012 All _ 0.750 _ ! 0100 1 0.100 0.05011 10 2011 l _ - 0.502 0.000 0.000 0.0001 0 1421 0,285 _ 0.073 1,00 _ 2010 0.749 0.012 0.031 0.021 _ 0 074 0 090 _ 0 02211 _7 00 2009 _ 0.802 0.000 0.000 �. 0.007 O.077' 0,098 _ 0.015 1.00 3 Year Average, 0.684 0.004 0.010 0.009 0.098. 0.158 0.037,1 1.00 Lt Eq Oper Shop Tech 1 1 _ 0.950 0.050 J 2012 Allocation �_ _ _ _ 0.950 005 0 _ _1.00 1 00 2011 0.921 0.031 0 019 _ 0.029 0 000 0 0001 0 000 i 1.00 2010� _ 0.884 MOO 0003 1 2009 0.866 010$ EMT 0 014 0 004 0 0091 0 000 _ _ 1.00 3 Yeor Average ''. 0.890 0.069 0.008 0.0281 0.001 0.003 0.001 1.00 Lt Eq G 0.850 0.050 2012 Allocation 0 800 0.150 - , JIB { _ _ 0.273 0.372 0.000 0070 Olig 0 09 II 0 014 0 0021 0 058 1 00 2010 0.329 0.287 0.013 0 079 0 152 1 0 106 j 0.0011 0 015 0 018 1.00 2009 _ 0.443 0.328 0.013 0 00761 0033 j 0.033 0.013 _ 0029 100 3 VearAVera e 1 9 _ 0.348 0.329 0.009 0.060 0.115'' 0.077 �, 0.016 0.010 0.035,1 1.00 _- 2012 Allocation 1 1.. 1 0.950 0050 1 M401 0.025 ..100 I.GO 2011 0.280 0.407 0.000 0.098 o6811 0 0441 - 2010 __ 0.363 0.349 0.000 0.145 0,086 0.033 0 0101 0.010 1 00 _ _ 2009 0.414 0.353 0.005 0.068 0.0901 0.022 _ _.. 0 034 0.0031 _ i 0.010 1.00 3 Year Average1 1 0.352 0.370 0.002 0.104 0.086'..0.033 10.023 0.016 0.015 2.00 Lt Eq Oper _ _ 0.350 0.050 0.6001 2012 Allo cation 0.350 0050..0.600 _ _ 1 100 20111 0.235 0.072 0.038 0.037 + 1 2010 _ i__ L 0.214 0.073 0 024 0 0531 0 6831 0 0 1 0.00411 1,00 2009 0.273 0.076 0 001 0.041 '', 0 600 0.0011 0 007 1.00 P2 P3 41300 41400 41410 41500 41910 42400 43050 43100 43200 4312S 45200 45300 �_ 4901 6011 6111 621.. 631 Gen Plan( Prot Public Streets) _43250 Snow _Storm IlTotal _ Position Admin Govt Elect Pin Zone Insp _. Engr Works�Roads Weeds! Trees I Ice Parks Re f SSCC Water Sewer Recycl� Water Lt Eq Oper �_ _ 0.350 0.050 1.00 2012 A _ 0,350 00501 0600 100 2011 0.216 0.054 0.044 0,059 6612 0 002 0 000 cl 012 1 00 2010 _ _ 0.205 0.106 0 025 0.075,0 586 0.000 0000 0.003, 1.00 2009'. _. 0187 0.034 0.003 0.024 0.638 _ 0 001., OA00 0,013 1.00 3 Year Average' "' 0136 0.065 0.024 0.053 0.612 '.. 0.001 0.000 0.009[ 1.00 Utility lead 1 0.500 0.100 _ 1 o.zo0, O.zoo Loo - 2012 Al - -. 0.450 0 1001 0.2501 0.2W 1 1 00 _ 20111 0.356 0.205 0.002 0,009 0 078 06111 0 1062 0164 0 003 6.067 �j 1 00 20101 0.290 0.183 0.013 0.010 0.1072„ 0,000 0 1801 0 167 0.004 0 046 _ 1.00 2009 _ 0.378 0.074 .050 0.00 0.0001 0.004 1.6o 3 YearAverage . 0.341 0.354 0.00 0.007 0.078 0.004 1 0.181 0.188 0.002 0.039 1.00 Lt Eq Oper - Util ' 0.300 0.1001 0.300, 0300 _I _1.00 2012 Allocation _ 0.350 0100 0250 0 2011 _ 0.194 0.113 0 0056 0016 0369E 0199 1 00451 1.00 2010 -- 0101 0.047 0 001 0.11E' _ 0 026 0.342 0231 0 036 1 00 _ 20091 I- 0.000 0.162 0 0177 0 0 0369 0000 IL 100 3 Year Average -_ 0.132 0.107 0.003 0116 0.014 1 0.334 0166 0.027 1.00 Q Eq Oper Ut+l f 0.300 - 01001_ '. i 0.4001 0.200 - 1 - 1.00 - _ I 2012AIlocation ' 0.250 01001 i 0400 0150 _ 100 2011 1 0.257 0.025 U04 0 004 0.0601 000 1 0,389 0.1961 6.34s 6.215 0.000 0.064 r 0 1.00 1.00 2010 0.250 0.053 0.001 0.006 0.106 00 0042 0.0121 20091 0,255 0.009 0.004 0.002 0.04 2 O 066 1 0.446, 0.2441 3 Year Average _. L . l _ { -- 0.254 0.029 0.003 0.004 0.069 0 002 0.393 1 0.218 1 0.001 0.0251 2013 Allocation 0 1400 1250 0900 5250 0000 0000 0000 0.650 12501 04001 # # # #� 1.270 1.080 0100 0.35011 19.550 2012 A 3.400 0.000 0 .000 1.400 1.650 1150 0.900 5.300 OA00 0.000 0.650 1250 0.900_ # # # # #1 __.. 0.000, 1.270 1.130' OAM 0.350, 19.550 2011_ 1138 2.Si8L_0000� 1.700.1650 1 602 1 310 0 934 3.234 2010 1 203 2 211 0 323 1.664 1 682 323 1.248 0 981 3.485, 1.1781 0.0581 02931 0737 1.483 0.441._ # # ## 1 0.059 1.140 0.913 _ 0.090 0.280 1 19469 20091 2.623 0.009 1.659 1.870 1107 0.964 3.7181 1.143 0.027'' _ 0.108, 0.513, 1.370 0.4071 { ## # ## 0.000 r 1.332 11391 0.066 0.228 19642 ..1.259 3 or Ave 1.233 2A512 0.111 1.674 1.717 1.2551 0.960 3.479 Sd001 0.0301, 0.2301 0.589'. 1.4301 0.4371 # ### # 0.0481 1.236 1.033.. 0.079 0336 19.529 P3 Planning Protective Public Snow Storm Total Position Admin. Finance Zoning Inspection Engineer Works Ice Parks Recreation Water Sewer Recycling Water PW Director $ - $ - $ - $ - $ - $ 77,126 $ - $ - $ - $ 10,283 $ 10,283 $ - $ 5,142 $ 102,834 Finance Director $ - $ 63,118 $ - $ - $ - $ - $ - $ - $ - $ 9,017 $ 9,017 $ - $ 9,017 $ 90,168 LEO $ - $ - $ - $ - $ - $ 1.9,540 $ 2,791 $ 33,496 $ - $ - $ - $ - $ - $ 55,827 LEO $ - $ - $ - $ - $ - $ 17,372 $ 5,791 $ - $ - $ 17,372 5 17,372 $ - $ - $ 57,907 Admin. Asst. $ 41,030 $ - $ - $ 5,471 $ - $ - $ - $ - $ - $ 3,829 $ 4,376 $ - $ - $ 54,706 Admin. Asst. $ 32,824 $ - $ - $ - $ - $ - $ - $ - $ 21,882 $ - $ - $ - $ - $ 54,706 City Administrator $ 100,621 $ - $ - $ - $ - $ - $ - $ - $ - $ $ - $ $ - $ 100,621 Planning Asst $ - $ - $ 46,790 $ 6,684 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 53,474 City Engineer $ - $ - $ - $ - $ 73,640 $ - $ - $ - $ - $ - $ - $ - $ 8,182 $ 81,822 LEO - Utilities $ - $ - $ - $ - $ - $ 17,372 $ 5,791 $ - $ - $ 23,163 $ 11,581 $ - $ - $ 57,907 Lea - ShopTech $ - $ - $ - $ - $ - $ 54,024 $ 2,843 $ - $ - $ - $ - $ - $ - $ 56,867 Comm. Coord $ 34,642 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 5,330 $ - $ 39,972 Sr. Accountant $ - $ 42,960 $ - $ - $ - $ - $ - $ - $ - $ 6,137 $ 6,137 $ - $ 6,137 $ 61,372 Planning Director $ - $ - $ 87,097 $ 4,584 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 91,681 Dep. City Clerk $ 77,743 $ - $ - $ - $ - $ - $ - $ - $ $ - $ $ - $ - $ 77,743 Building Official $ - $ - $ - $ 75,874 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 75,874 LEO $ - $ - $ - $ - $ - $ 47,453 $ 5,583 $ 2,791 $ - $ - $ - $ - $ - $ 55,827 Utility Lead $ - $ - $ - $ - $ - $ 31,408 $ 6,282 $ - $ - $ 12,563 $ 12,563 $ - $ - $ 62,816 LEO $ - $ - $ - $ - $ - $ 19,540 $ 2,791 $ 33,496 $ - $ - $ - $ - $ - $ 55,827 LEO $ - $ - $ - $ - $ - $ 50,244 $ 5,583 $ - $ - $ - $ - $ - $ - $ 55,827 TOTAL $ 286,860 $ 106,078 $ 133,887 $ 92,613 $ 73,640 $ 334,078 $ 37,455 $ 69,784 $ 21,882 $ 82,365 $ 71,331 $ 5,330 $ 28,478 $ 1,343,780 2013 Salary Expense Estimate 8/7/2012 Department Salaries * PERA FICA Benefits Total Administration $ 286,860 $ 20,797 $ 21,945 $ 30,069 $ 359,671 General Government 0 0 0 0 0 Elections 0 0 0 0 0 Finance 106,078 7,691 8,115 11,045 132,929 Planning and Zoning 133,887 9,707 10,242 16,830 170,666 Protective Inspections 92,613 6,714 7,085 12,676 119,088 Engineer 73,640 5,339 5,633 7,937 92,549 Public Works 334,078 24,221 25,557 42,047 425,903 Streets and Roads 0 0 0 0 0 Snow and Ice 37,455 2,715 2,865 5,009 48,044 Weeds 0 0 0 0 0 Trees 0 0 0 0 0 Parks Maintenance 69,784 5,059 5,338 7,386 87,568 Recreation 21,882 1,586 1,674 453 25,596 Water 82,365 5,971 6,301 10,501 105,139 Sewer 71,331 5,171 5,457 8,556 90,515 Recycling 5,330 386 408 619 6,743 Storm Sewer 28,478 2,065 2,179 2,879 35,600 Total Salary Expenditures $ 1,343,780 $ 97,424 $ 102,799 $ 156,009 $ 1,700,012 * Union wages and benefits are included at the 2013 level since the contract is set. Non -union wages are included at the 2012 level with a contingency of 1% in the City Council budget. Non -union insurance is included at the same $900 per month shown in the union contract. 8 -08-2012 11:15 PM CITY OF SHOREWOOD PAGE: 1 BALANCE SHEET AS OF: DECEMBER 31ST, 2011 101-General Fund ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 101-10100 CASH AND INVESTMENTS 3,449,665.41 101-10200 PETTY CASH 120.00 101-10410 ALLOW FOR UNREALIZED INVEST GA 0.27 101-10450 ACCRUED INTEREST RECEIVABLE 9,145.73 101-10500 TAXES RECEIVABLE - CURRENT 57,132.09 101-10700 TAXES RECEIVABLE - DELINQUENT 100,284.91 101-11500 ACCOUNTS RECEIVABLE 18,460.50 101-12300 SPECIAL ASSESS REC-DEFERRED 0.46) 101-13200 DUE FROM OTHER GOVERNMENTS 0.43 101-15510 PREPAID EXPENSES - OTHER 49,059.99 3,526,991.82 3,683,868.8 TOTAL ASSETS LIABILITIES 101-20100 AP PENDING (DUE TO POOL) 56,258.66 101-20805 PERMIT SURCHARGES PAYABLE 892.5? 101-20810 LIABILITY INSURANCE PAYABLE 16,509.17 101-21600 ACCRUED WAGES & SALARIES PAYAB 48,202.01 101-21703 FICA/MEDICARE TAX PAYABLE 3349.95) 101-21710 SEC 125 INSURANCE PAYABLE 2,050.10 101-22200 DEFERRED REVENUES 100,285.01 TOTAL LIABILITIES 223,847.57 EQUITY 101-25310 UNRESERVED, DESIGNATED FUND BA 3,526,991.82 TOTAL BEGINNING EQUITY 3,526,991.82 TOTAL REVENUE 5,286,323.41 TOTAL EXPENSES 5,353,293.93 TOTAL REVENUE OVER/(UNDER) EXPENSES 66, 970 .52) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 3,460,021.30 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 3,683,868.87 -------- - - - - -- -------- - - - - -- P1 8 -08-2012 11:16 PM CITY OF SHOREWOOD PAGE: 1 BALANCE SHEET AS OF: DECEMBER 31ST, 2011 401-Public Facility Fund ACCOUNT # ACCOUNT DESCRIPTION ---------------------------------------- ASSETS 401-10100 CASH AND INVESTMENTS 401-10410 ALLOW FOR UNREALIZED INVEST GA 401-10450 ACCRUED INTEREST RECEIVABLE BALANCE 186,932.41 0.25) 187,302 .58 TOTAL ASSETS LIABILITIES 401-20100 AP PENDING (DUE TO POOL) 9,081.25 TOTAL LIABILITIES 9,081.25 EQUITY 401-25310 UNRESERVED, DESIGNATED FUND BA 196,080-59 TOTAL BEGINNING EQUITY 196,080.59 TOTAL REVENUE 1,587.82 TOTAL EXPENSES 19,447.08 TOTAL REVENUE OVER/(UNDER) EXPENSES 17,859.26) TOTAL EQUITY & REV. OVER/(UNDER) EXP- 178,221.3-2, TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 187,3102.58 187,302.58 P2 8 -08-2012 11:16 PM CITY OF SHOREWOOD PAGE: 1 BALANCE SHEET AS OF: DECEMBER 31ST, 2011 402-Park Capital Improvements ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 402-10100 CASH AND INVESTMENTS 150,765.94 402-10450 ACCRUED INTEREST RECEIVABLE 542.83 151,308.77 TOTAL ASSETS LIABILITIES ---------------- EQUITY 402-25310 UNRESERVED, DESIGNATED FUND BA 190,379.89 TOTAL BEGINNING EQUITY 190,3179.89 TOTAL REVENUE 43,3115.25 TOTAL EXPENSES 82, TOTAL REVENUE OVER/(UNDER) EXPENSES 39,071.12) 15'1,308.77 TOTAL, EQUITY & REV. OVER/(UNDER) EXP. 151,308.77 TOTAL, LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 151,308.77 P3 8-08-2012 11:16 PM CITY OF SHOREWOOD PAGE: 1 BALANCE SHEET AS OF: DECEMBER 31ST, 2011 403 Replacement ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 403-10100 CASH AND INVESTMENTS 392,344.68 4031-10410 ALLOW FOR UNREALIZED INVEST GA 0.39) 403-10450 ACCRUED INTEREST RECEIVABLE 1,239.05 403-11900 LEASE RECEIVABLE 131,254.90 524,838.24 TOTAL ASSETS 4021-203.00 AP PENDING (DUE TO POOL) 2,927.41 TOTAL LIABILITIES 2,927.41 EQUITY 403-253110 UNRESERVED, DESIGNATED FUND BA 732,104.97 TOTAL BEGINNING EQUITY 732,104.97 TOTAL REVENUE 61,798.21 TOTAL EXPENSES 271,992.3 TOTAL REVENUE OVER/(UNDER) EXPENSES 210,194.14) TOTAL EQUITY & REV. OVER/(UNDZ�R) EXP. 521, 910 .83 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 524,8318.24 -------- - - - - -- 524,838.24 i 8 -09-2012 11:16 PM CITY OF SHOREWOOD PAGE: 1 BALANCE SHEET AS OF: DECEMBER 31ST, 2011 404-Street Capital Improvemen ACCOUNT # ACCOUNT DESCRIPTION BALANCE ASSETS 404-10100 CASH AND INVESTMENTS 1,483,751.28 404-10410 ALLOW FOR UNREALIZED INVEST GA 0.18 404-10450 ACCRUED INTEREST RECEIVABLE 1,012.20 1,484,763.66 TOTAL ASSETS LIABILITIES 404-20100 AP PENDING (DUE TO POOL) 4,156.00 TOTAL LIABILITIES 4,156.00 EQUITY 404-253110 UNRESERVED, DESIGNATED FUND BA 1,311,707.56 TOTAL BEGINNING EQUITY 1,3111,707.56 TOTAL REVENUE 710,536.79 TOTAL EXPENSES 541,6316.69 TOTAL REVENUE OVER/(UNDER) EXPENSES 168,900.10 TOTAL EQUITY L REV. OVER/(UNDER) EXP. 1,480,607.66 TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 1,484,763.66 1_484,763.66 P5 8-08-2012 11:16 PM CITY OF SHOREWOOD PAGE: 1 BALANCE SHEET AS OF: DECEMBER 31ST, 2011 405-MSA Capital Improvement ACCOUNT # ACCOUNT DESCRIPTION ASSETS 405-10100 CASH AND INVESTMENTS 405-10450 ACCRUED INTEREST RECEIVABLE TOTAL ASSETS BALANCE 129, 768 .51 2,880.83 132,649.34 LIABILITIES ----------- EQUITY 405-25310 UNRESERVED, DESIGNATED FUND BA 131, 749 .29 TOTAL BEGINNING EQUITY 131,749.29 TOTAL REVENUE 1,066.93 TOTAL EXPENSES 166.88 TOTAL REVENUE OVER/(UNDER) EXPENSES 900.05 TOTAL EQUITY & REV. OVER/(UNDER) EXP. 1 TOTAL LIABILITIES, EQUITY & REV.OVER/ (UNDER) EXP. 132,649.314 -------- - - - - -- 132, 649 .34 I 8 -08 -2012 11:16 PM CITY OF SHOREWOOD PAGE: 1 BALANCE SHEET AS OF: DECEMBER 31ST, 2011 408 - Technology Fund ACCOUNT # ACCOUNT DESCRIPTION --------------------------------------- ASSETS 408 -10100 CASH AND INVESTMENTS 408 -10410 ALLOW FOR UNRLZ INV GAIN /LOSS 408 -10450 ACCURED INTEREST RECEIVABLE BALANCE 86,220.09 ( 0.01) 86,331 TOTAL ASSETS LIABILITIES 408 -20100 AP PENDING (DUE TO POOL) TOTAL LIABILITIES 7,241.7 7,241 EQUITY 408 -25310 UNRESERVED, DESIGNATED END BAL 90,754.3 TOTAL BEGINNING EQUITY 90,754.35 TOTAL REVENUE 708.52 TOTAL EXPENSES 12,373 TOTAL REVENUE OVER /(UNDER) EXPENSES ( 11,664.53) TOTAL EQUITY & REV. OVER /(UNDER) EXP. 79,089 TOTAL LIABILITIES, EQUITY & REV.OVER /(UNDER) EXP. 86,331.56 -------- - - - - -- -------------- 86,331.56 -------- -- - - -- P7 8-08-2012 11:17 PM CITY OF SHOREWOOD PAGE: 1 BALANCE SHEET AS OF: DECEMBER 31ST, 2011 450-Community Infrastructure ACCOUNT # ACCOUNT DESCRIPTION --------------------------------- ASSETS 450-10100 CASH AND INVESTMENTS 450-10450 ACCRUED INTEREST 450-14200 LAND HELD FOR RESALE TOTAL ASSETS LIABILITIES 450-20100 AP PENDING (DUE TO POOL) TOTAL LIABILITIES EQUITY 450-25310 UNRESERVED FUND BALANCE TOTAL BEGINNING EQUITY BALANCE 1,677,462.33 1,213.00 150, 068 .00 1,828,743.33 185.00 1,867,783.02 1,867,783.02 185.00 TOTAL REVENUE 14,906.90 TOTAL EXPENSES 54,131.59 TOTAL REVENUE OVER/(UNDER) EXPENSES 39,224.69) TOTAL EQUITY & REV. OVER/(UNDER) EXP. 1, 828, 558. 33 TOTAL LIABILITIES, EQUITY & REV. OVER/ (UNDER) EXP. 1,828,743.333 1,828,743.313 I 8-08-2012 11:17 PM CITY OF SHOREWOOD PAGE: 1 BALANCE SHEET AS OF: DECEMBER 31ST, 2011 490-Southshore Community Ctr. ACCOUNT # ACCOUNT DESCRIPTION --------------------------------- ASSETS 490-10100 CASH AND INVESTMENTS 490-10200 SOUTHSHORE CENTER-PETTY CASH 490-10410 ALLOW FOR UNREALIZED INVEST GA 490-10450 ACCRUED INTEREST RECEIVABLE BALANCE 12, 975.07 192.25 0.49) 13,203.46 TOTAL ASSETS LIABILITIES 490-20100 AP PENDING (DUE TO POOL) 13,010.46 490-21600 ACCRUED WAGES & SALARIES PAYAB 126.00 TOTAL LIABILITIES EQUITY 490-25310 UNRESERVED, DESIGNATED FUND BA 17,650.51 TOTAL BEGINNING EQUITY 17,650.51) TOTAL REVENUE 128,703.08 TOTAL EXPENSES 110,985.57 TOTAL REVENUE OVER/(UNDER) EXPENSES 17,717.51 TOTAL EQUITY & REV. OVER/(UNDER) EXP. TOTAL LIABILITIES, EQUITY & REV.OVER/(UNDER) EXP. 13,136.46 67.00 13,203.46 13,203 .46 -------- - - - - -- I