Loading...
HomeMy WebLinkAbout5. General Fund Recap s: CITY OF SHAKOPEE Memorandum TO: Mayor and Council Mark McNeill, City Administrator FROM: Gregg Voxland, Finance Director SUBJ: General Fund Budget 2010/11 DATE: August 7, 2009 Introduction & Background Attached on pages 2 to 7 (page numbers on the bottom of the page) are the detail revenue sheets for council review. Recent adjustments include several minor items, decrease of approximately $72,000 of Police service revenues from initial numbers, decrease in tax revenue due to adjustment upwards of loss of MVHC (market value homestead credit) amounts. During the work session, the determination of the tax levy will be presented. MVHC is deducted from the city's levy when calculating taxes to be levied so it needs to be factored in when setting the levy. Actual MVHC number will not be known until November. Levy limits will not be known for about another week or two. Fiscal disparities amounts will not be known until later this month. On pages 8 is the current status of the general fund budget. Following on page 9 is the breakdown of revenue, expenditures and net by division. Gregg Voxland Finance Director H,\Finance\budget\ 1 R5509BUD SH001 PV CITY OF SHAKOPEE 8/7/2009 8:39:01 By Company (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 1 Fiscal Period: 7 / 09 Level Of Rollup 7 2007 2008 7/31/2009 2009 2010 2011 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget --- 01000 GENERAL FUND 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4010 PROPERTY TAX 4011 CURRENT PROPERTY TAX 9,985,594- 11,459,321- 6,340,146- 11,734,750- 11,332,900- 11,202,970- 4012 DELINQUENT PROPERTY TAX 50,321 151,141 4013 MARKET VALUE CREDIT 520,909- 243,691- 4015 FISCAL DISPARITIES 906,165- 1,119,749- 652,938- 1,344,160- 1,344,160- 1,344,160- 4020 MOBIL HOME TAX 461- 455- 260- 400- 400- 400- 4025 PILOT 300- 4031 EXCESS TAX INCREMENT 1,571 298- 4040 AGGREGATE TAX 7,083- 5,120- 2,632- 8,000- 8,000- 8,000- 4050 LODGING TAX 200,682- 193,797- 74,291- 210,000- 210,000- 210,000- 4010 PROPERTY TAX 11,569,003- 12,871,292- 7,070,565- 13,297,310- 12,895,460- 12,765,530- 4005 TAXES 11,569,003- 12,871,292- 7,070,565- 13,297,310- 12,895,460- 12,765,530- 4100 SPECIAL ASSESSMENT 4110 SPECIAL ASSESSMENT PRINCIPAL 1,848- 37,196- 3,060 2,000- 2,000- 2,000- 4111 SPEC ASSESSMENT INTEREST 2,517- 3,397- 4120 SA PREPAY 1,041- 30,643 4100 SPECIAL ASSESSMENT 5,406- 9,950- 3,060 2,000- 2,000- 2,000- 4200 LICENSES AND PERMITS 4201 LICENSES 4202 CABLE FRANCHISE 305,000- 305,000- 4203 TRACK FRANCHISE 12,281- 12,129- 12,000- 12,000- 12,000- 4220 LIQUOR LICENSE 117,825- 117,363- 115,616- 106,000- 117,000- 117,000- 4230 BEER LICENSE 3,949- 3,651- 4,440- 4,000- 3,600- 3,600- 4240 CIGARETTE LICENSE 8,225- 6,900- 200- 7,000- 7,000- 7,000- 4242 DOG LICENSES 4,386- 4,756- 2,720- 4,500- 4,500- 4,500- 4243 MISC BUSINESS LICENSE 9,366- 13,482- 2,876- 9,000- 9,000- 9,000- 4244 MISC NON-BUSINESS LICENSE 20- -- --~~- 4201 LICENSES 156,051- 158,280- 125,853- 142,500- 458,100- 458,100- 4250 PERMITS 4251 BUILDING PERMITS 345,779- 244,151- 169,626- 230,000- 250,000- 250,000- 4259 PLAN REVIEW FEE 131,837- 69,682- 96,656- 70,000- 80,400- 80,400- 4261 PLUMBING PERMITS 68,488- 42,010- 37,590- 46,000- 46,000- 46,000- 4265 MECHANICAL PERMITS 96,404- 48,493- 26,616- 55,000- 55,000- 55,000- 4267 ELECTRICAL PERMITS 80,217- 58,372- 42,472- 65,000- 70,000- 75,000- 4272 SEWER & WATER PERMITS 15,346- 11,499- 13,900- 7,000- 11,000- 11,000- 4274 FIRE INSPECTION PERMITS 21,908- 16,276- 7,479- 25,000- 15,000- 15,000- 4275 INSPECTIONS 47- 102- 4276 FENCE PERMITS 1,200- 2,375- 1,825- 1,200- 2,500- 2,500- 4280 STREET OPENING PERMITS 54,692- 39,478- 28,954- 40,000- 40,000- 40,000- 4282 WOODLAND MANAGEMENT FEE 1,689- 800- 404- 1,600- 80P- 800- 4250 PERMITS 817,608- 533,135- 425,623- 540,800- 570,700- 575,700- 4200 LICENSES AND PERMITS 973,659- 691,415- 551,475- 683,300- 1,028,800- 1,033,800- 4400 INTERGOVERNMENTAL 4410 FEDERAL GRANTS 167,928- 4,474- 1,585- 5,000- 5,000- 5,000- 4411 COPS 60,412- 2 R5509BUD SH001 PV CITY OF SHAKOPEE 8/7/2009 8:39:01 By Company (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 2 Fiscal Period: 7 / 09 Level Of Rollup 7 2007 2008 7/31/2009 2009 2010 2011 Actual Actual YTD Final Proposed Proposed Object Code I Description Amount Amount Actual Budget Budget Budget ~.. ---.---- 4410 FEDERAL GRANTS 228,340- 4,474- 1,585- 5,000- 5,000- 5,000- 4450 STATE GRANTS & AIDS 18,688- 21,019- 6,237- 18,990- 18,000- 18,000- 4455 PERA AID 18,170- 541 19,000- 19,000- 19,000- 4460 STATE AID - MAINT 124,166- 215,000- 248,330- 248,330- 4465 STATE AI D - POll CE 295,743- 308,226- 295,000- 300,000- 300,000- 4467 POLICE TRAINING REIMBURSEMENT 18,024- 4482 COUNTY GRANTS/AIDS 29,498- 8,990- 25,000- 25,000- 25,000- 4490 OTHER LOCAL GRANTS/AIDS 1,220- ~-_._-- 4450 STATE GRANTS & AIDS 362,099- 356,938- 130,403- 572,990- 610,330- 610,330- 4400 INTERGOVERNMENTAL 590,439- 361,412- 131,988- 577,990- 615,330- 615,330- 4500 CHARGES FOR SERVICE 4510 ADMINISTRATIVE CHARGES 4511 ADMINISTRATIVE CHARGES 52,045- 41,047- 7,405- 51,840- 39,840- 39,840- 4513 SALE OF DOCUMENTS 10,685- 4,784- 3,147- 8,700- 3,700- 3,700- 4516 ASSESSMENT SEARCHES 1,075- 600- 275- 1,000- 500- 500- 4518 RELEASE OF DEVELOPER AGREEMENT 25- 75- 55- 4525 TITLE EXAMINATION 1,500- 600- 300- --- 4510 ADMINISTRATIVE CHARGES 65,330- 47,106- 11,181- 61,540- 44,040- 44,040- 4570 COMMUNITY DEVELOPMENT 4571 APPEAL 1,350- 1,125- 225- 1,000- 1,300- 1,300- 4572 SIGNS 9,920- 5,925- 3,070- 9,000- 6,000- 6,000- 4573 CONCEPT REVIEWS 350- 8,144- 4574 REZONE/COMP PLAN 3,010- 3,710- 1,350- 3,000- 1,300- 1,300- 4575 ZONING LETTER 350- 550- 350- 350- 350- 350- 4576 LAND DIVISION ADMINISTRATION 8,471 4579 P U 0 3,681- 3,462- 2,840- 3,000- 3,000- 4580 MAJOR SUBDIVISION PRE-APP 1,112- 350- 350- 350- 4581 PRELIMINARY PLAT 9,742- 10,864- 5,400- 3,000- 3,000- 4582 FINAL PLAT 32,927- 10,571- 5,282- 2,820- 3,000- 3,000- 4583 MINOR SUBDIVISION 500- 3,810- 3,800- 3,800- 3,800- 4584 VACATION 2,550- 1,700- 2,500- 2,000- 2,000- 4585 VARIANCE 900- 500- 1,150- 1,000- 1,000- 1,000- 4586 CUP 4,450- 5,484- 2,400- 2,400- 4,000- 4,000- 4587 HOME OCCUPATION 200- 600- 600- 600- 600- --- 4570 COMMUNITY DEVELOPMENT 61 ,460- 57,557- 13,827- 35,060- 29,700- 29,700- 4600 ENGINEERING 4620 ENGINEER FEE - PRIVATE 133,955- 53,718- 3,769- 100,000- 20,000- 20,000- 4621 ENGINEER FEE - PUBLIC 418,347- 267,928- 80,371- 300,000- 300,000- 300,000- 4630 GRADE FEE 17,605- 19,452- 9,461- 8,000- 16,000- 16,000- 4600 ENGINEERING 569,907- 341,098- 93,601- 408,000- 336,000- 336,000- 4640 PUBLIC SAFETY FEES 4642 POLICE SERVICES 142,729- 346,314- 38,900- 175,000- 166,600- 166,600- 4643 VALLEY FAIR 32,246- 30,283- 33,311- 31,000- 31,000- 31,000- 4646 FALSE ALARMS 4,440- 20,600- 20,600- 4655 POUND FINES & FEES 2,120- 1,540- 660- 2,000- 1,500- 1,500- 4660 FIRE SERVICES 148,906- 152,308- 152,964- 149,000- 150,000- 150,000- 4640 PUBLIC SAFETY FEES 326,001- 530,445- 230,274- 357,000- 369,700- 369,700- 4670 PUBLIC WORKS 3 R5509BUD SH001PV CITY OF SHAKO PEE 8/7/2009 8:39:01 By Company (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 3 Fiscal Period: 7 / 09 Level Of Rollup 7 2007 2008 7/31/2009 2009 2010 2011 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget 4680 MISC PUBLIC WORKS 53,938- 108,656- 36,827- 80,500- 30,500- 30,500- 4681 CARITRUCK WASHES 49 8,300- 8,300- 4682 WEED REMOVAL CHARGES 130- 4684 STREET SIGNS 1,860- 880- 728- 2,000- 1,000- 1,000- ~_.- 4670 PUBLIC WORKS 55,798- 109,536- 37,636- 82,500- 39,800- 39,800- 4750 REFUSE 4751 REFUSE CHARGES 11,524- 7,509- 10,817- 7,500- 9,000- 9,000- 4750 REFUSE 11,524- 7,509- 10,817- 7,500- 9,000- 9,000- 4760 RECREATION FEES 4762 MEMBERSHIPS 213,000- 214,500- 4766 GENERAL ADMISSIONS 109,750- 120,000- 4770 LESSONS 117,000- 115,000- 4774 ICE RENTAL - PRIME TAXABLE 63,370- 65,500- 4775 ICE RENTAL - PRIME EXEMPT 199,750- 210,000- 4780 YOUTH ACTIVITIES 185,000- 190,000- 4795 ADULT ACTIVITIES 50,330- 56,000- 4796 ROOM RENTALS 17,000- 12,000- 4798 PARK FACILITY RENTAL 17,000- 17,000- 4799 PARK FIELD RENTALS 2,450- 2,500- 4800 SKATE SHARPENING 2,250- 2,000- 4810 CONCESSION STANDS 28,500- 35,500- 4812 VENDING CONCESSION COMMISSION 16,900- 20,100- 4814 NON-RESIDENT FEE 9,000- 9,000- 4816 NON-RESIDENT FEEITOWNSHIP PYMT 8,000- 11,000- 4817 ARENA ADVERTISING 5,000- 5,000- 4818 OTHER RECREATION FEES 7,500- 4,000- 4760 RECREATION FEES 1,051,800- 1,089,100- ---- 4500 CHARGES FOR SERVICE 1,090,020- 1,093,251- 397,337- 951,600- 1,880,040- 1,917,340- 4820 FINES & FORFEITS 4821 FINES & FORFEITS 269,067- 231,044- 99,902- 320,000- 231,000- 231,000- 4822 FINES & FORFEITS - SJPA 182,351- 135,574- 39,380- 190,000- 150,000- 164,000- --- -- 4820 FINES & FORFEITS 451,418- 366,618- 139,282- 510,000- 381,000- 395,000- 4830 MISCELLANEOUS 4832 INVESTMENT INCOME 4833 INTEREST 523,673- 434,413- 114,752 400,000- 375,000- 375,000- ---- 4832 INVESTMENT INCOME 523,673- 434,413- 114,752 400,000- 375,000- 375,000- 4835 MISCELLANEOUS NON-INTEREST 4840 RENTS 142- 4843 COMMISSIONS 5,775- 7,282- 7,099- 800- 6,800- 800- 4845 CONTRIBUTIONS 50- 8,600- 1,100- 5,000- 2,500- 4850 MISCELLANEOUS 27,086- 14,179- 1 ,553- 34,500- 20,500- 21,500- 4852 INSURANCE DIVIDENDS/FEES 29,408- 19,636- 16,000- 18,000- 18,000- 4855 SALE OF ASSETS 17,700- 4835 MISCELLANEOUS NON-INTEREST 80,161- 49,697- 9,752- 51,300- 50,300- 42,800- 4830 MISCELLANEOUS 603,835- 484,109- 104,999 451,300- 425,300- 417,800- 4960 PROCEEDS FROM DEBT ISSUED 4001 REVENUES 15,283,779- 15,878,047- 8,182,588- 16,473,500- 17,227,930- 17,146,800- 4 R5509BUD SH001 PV CITY OF SHAKO PEE 81712009 8:39:01 "- By Company (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page _ 4 Fiscal Period: 7 / 09 Level Of Rollup 7 2007 2008 7/31/2009 2009 2010 2011 Actual Actual YTD Final Proposed Proposed Object Code / Descriptio~__ Amount Amount ___~~~~ ~~~~ Budget Budget 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 6,598,785 6,645,061 3,812,452 7,102,210 7,549,350 7,629,930 6005 OVERTIME-FT 197,288 264,878 123,895 177,000 145,500 154,500 6010 PREMIUM PAY 1,827 7,898 1,417 12,000 10,600 10,600 6015 WAGES - PART TIMEfTEMP 491,638 433,000 247,993 454,400 865,330 889,700 6017 OVERTIME-PART TIMEfTEMP 2,674 89 188 7,820 3,000 6002 WAGES 7,292,211 7,350,925 4,185,945 7,745,610 8,578,600 8,687,730 6100 BENEFITS 6122 PERA 590,218 657,830 396,824 759,880 824,060 833,850 6124 FICA 322,386 318,133 170,293 354,560 420,360 428,600 6128 FIRE PENSION 210,301 187,451 240,170 340,000 340,000 6135 HEALTH 763,697 772,048 405,713 904,770 1,055,310 1,182,780 6139 POST EMPLOYMENT HEALTH PLAN 34,263 33,148 16,917 34,650 37,580 37,530 6140 L1FElLTD 29,613 30,057 15,716 35,210 37,260 37,230 6145 DENTAL 42,011 43,343 23,262 55,030 60,130 60,050 6160 UNEMPLOYMENT 700 223 34 6170 WORKERS COMPENSATION 202',908 211,428 118,051 215,650 280,950 285,300 6180 COMPENSATED ABSENCES 42,395 141,155 289,820 186,900 186,900 6185 OPEB 62,051 104,300 174,910 174,910 6100 BENEFITS 2,238,493 2,456,866 1,251,111 2,889,740 3,417,460 3,567,150 6001 WAGES & BENEFITS 9,530,705 9,807,792 5,437,056 10,635,350 11,996,060 12,254,880 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 589,497 388,379 97,522 447,560 436,740 459,080 6203 TOOLS 2,307 1,759 206 2,000 1,000 1,000 6210 OFFICE SUPPLIES 59,550 41,394 11,045 72,210 62,760 64,950 6211 RECREATION SUPPLIES 39,270 40,060 6212 UNIFORMS/CLOTHING 31,404 13,647 20,100 16,700 16,700 6213 FOOD 2,417 1,860 2,000 2,000 6215 MATERIALS 125,930 144,000 53,170 137,000 135,000 140,000 6222 MOTOR FUELS & LUBRICANTS 220,721 235,815 71,543 220,680 249,720 291,690 6230 BUILDING MAINT SUPPLIES 49,205 39,836 12,068 56,150 75,200 76,300 6240 EQUIPMENT MAINTENANCE 262,949 70,918 29,919 99,650 85,320 89,420 6245 UTILITY MAINT 7 6250 MERCHANDISE 3,114 10,440 34,539 2,000 21,400 21,400 6290 SALES TAX 650 650 6201 SUPPLIES & SERVICES 1,313,280 966,362 325,518 1,057,350 1,125,760 1,203,250 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 586,102 614,334 320,038 520,050 470,630 488,000 6312 ENGINEERING CONSULTNTS 33,204 38,639 13,605 33,000 25,000 25,000 6314 COMPUTER SERVICES 8,895 3,607 3,038 12,500 11,800 12,700 6315 BUILDING MAl NT. 186,861 128,587 68,530 82,500 141,100 129,500 6316 EQUIPMENT MAINTENANCE 91,520 451,397 207,972 347,230 421,850 429,060 6318 FILING FEES 573 301 184 300 250 250 6320 LODGING TAX 190,648 184,107 69,899 200,000 200,000 200,000 6322 PAVEMENT PRESERVATION 171,706 314,582 54,584 295,000 460,000 480,000 6324 TRANSPORTATION 7,900 7,900 6325 PERFORMERS/INSTRUCTORS 240 42,550 42,550 6327 OTHER PROF SERVICES 580,703 594,156 362,681 621,140 697,120 691,290 5 R5509BUD SH001 PV CITY OF SHAKOPEE 8/7/2009 8:39:01 By Company (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 5 Fiscal Period: 7 / 09 Level Of Rollup 7 2007 2008 7/31/2009 2009 2010 2011 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget ~dget ___ -------- 6300 PROFESSIONAL SERVICES 1,850,212 2,329,710 1,100,772 2,111,720 2,478,200 2,506,250 6330 COMMUNICATIONS 6332 POSTAGE 16,892 28,293 11,797 32,650 37,520 39,750 6334 TELEPHONE 54,388 48,398 26,620 57,530 58,750 60,000 6336 PRINTING/PUBLISHING 43,336 47,758 24,207 51,330 84,600 86,850 6338 ADVERTISING 2,722 468 3,750 12,510 12,510 6339 COMPUTER ACCESS 1,740 2,482 1,631 2,750 5,750 8,780 --- 6330 COMMUNICATIONS 119,078 127,399 64,254 148,010 199,130 207,890 6350 INSURANCE 6352 LIABILITY 182,911 145,960 127,044 165,100 176,230 195,670 6354 PROPERTY 107,249 106,808 254,969- 108,190 132,490 134,030 6356 AUTO 60,633 63,706 45,161 72,620 67,960 70,710 6350 INSURANCE 350,793 316,475 82,764- 345,910 376,680 400,410 6360 UTILITY SERVICE 7,246 3,641 3,372 505,600 63,000 63,000 6362 ELECTRIC 313,473 381,902 111,329 133,030 521,290 526,110 6364 WATER 51,003 16,235- 5,838 28,280 28,620 6365 GAS 111,841 148,673 79,188 237,300 246,280 6366 SEWER 37,002 27,133- 2,348 14,220 14,430 6367 REFUSE 3,626 196 1,076 600 8,600 8,000 6368 STORM 32,863 32,937 16,674 39,010 39,960 ----- 6360 UTILITY SERVICE 557,053 523,980 219,825 639,230 911,700 926,400 6400 RENTALS 6410 SOFTWARE - ANNUAL FEES 136,295 183,405 208,672 155,630 243,220 251,880 6420 EQUIPMENT RENT 14,361 14,337 7,405 10,800 19,770 20,320 6425 EQUIPMENT RENT (IS FUND) 1,002,756 1,031,472 423,132 846,410 688,900 690,210 6430 BUILDING RENT (IS FUND) 581,664 599,472 339,090 678,100 1,142,710 1,164,310 6435 OTHER RENT 33,260 132,094 50,343 118,230 307,440 301,800 -~--- ------...--.-.- 6400 RENTALS 1,768,337 1,960,779 1,028,642 1,809,170 2,402,040 2,428,520 6470 DUESrrRAININGITRAVEL 6472 CONFERENCE/SCHOOLrrRAINING 119,556 79,533 47,709 140,700 120,950 122,050 6475 TRAVEUSUBSISTENCE 38,808 36,881 17,967 57,810 44,950 47,500 6480 DUES 53,579 140,529 128,766 176,950 182,240 186,860 6490 SUBSCRIPTIONS/PUBLICATIONS 7,053 10,285 3,865 14,500 12,350 11,480 ~---- 6470 DUESrrRAININGITRAVEL 218,996 267,228 198,308 389,960 360,490 367,890 6497 FLEET CHARGE BACK 233,310- 117,918- 330,000- 330,000- 330,000- 6498 EXPENSE CHARGED BACK 192,376- 15,674- 38,840- 6200 SUPPLIES AND SERVICES 5,985,372 6,242,950 2,736,636 6,132,510 7,524,000 7,710,610 6500 DEPRECIATION 6600 MISCELLANEOUS 6620 PROPERTY TAX/SPECIAL ASSESS 54,783 40,385 46,745 44,260 41,250 41,250 6640 DESIGNATED MISCELLANEOUS 61,211 5,217 546 11,500 88,500 84,500 6650 CREDIT CARD FEES 2,086 1,608 1,007 2,430 12,930 12,930 6660 CASH SHORT-OVR/BANK FEES 0- 57 21 6640 DESIGNATED MISCELLANEOUS 63,297 6,882 1,574 13,930 101,430 97,430 6680 CONTINGENCY 6681 CONTINGENCY 50,000 50,000 50,000 6 R5509BUD SH001 PV CITY OF SHAKOPEE 8/7/2009 8:39:01 By Company (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 6 Fiscal Period: 7 / 09 Level Of Rollup 7 2007 2008 7/31/2009 2009 2010 2011 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget ----~-----_._.- --._~ ------- 6685 CONTINGENCY - DESIGNATED 67,661 75,000 130,000 _.~u.__ _.___,__. ~ ,--------- 6680 CONTINGENCY 67,661 125,000 50,000 180,000 -----~- ~--- 6600 MISCELLANEOUS 118,080 114,928 48,319 183,190 192,680 318,680 6700 CAPITAL OUTLAY 6730 BUILDINGS 24,652 6740 EQUIPMENT 471,000 101,504 23,411 14,500 73,000 125,000 6760 IMPROVEMENTS 21,850 ------.---.- ~- 6700 CAPITAL OUTLAY 495,652 123,354 23,411 14,500 73,000 125,000 6800 DEBT SERVICE 6840 DEBT SERVICE INTEREST 6000 EXPENDITURES 16,129,808 16,289,023 8,245,423 16,965,550 19,785,740 20,409,170 8005 TOTAL TRANSFERS IN 8010 OPERATING TRANSFERS IN 103,340- 109,940- 236,900- 121,200- 121,200- 8011 TRANSFER FROM ELECTRIC FUND 1,080,962- 1,151,428- 958,525- 1,783,000- 1,800,000- 1,850,000- 8012 TRANSFER FROM WATER FUND 704,809- 651,924- 8019 TRANSFER IN CAPITAL PROJECT FD 77,230- ~--- -- 8010 OPERATING TRANSFERS IN 1,889,111- 1,990,522- 958,525- 2,019,900- 1,921,200- 1,971,200- ---~---- 8005 TOTAL TRANSFERS IN 1,889,111- 1,990,522- 958,525- 2,019,900- 1,921,200- 1,971,200- 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 8053 TRANSFERS OUT 71,411 29,200 32,000 8054 OPERATING TRANSFER/DEBT SERV 253,268 8058 OPERATING TRANSFER RECREATION 1,108,770 1,145,010 1,204,160 1,204,160 --.----...- - ..._--~- ~------ 8052 TRANSFERS OUT 1,180,181 1,427,478 1,204,160 1,236,160 ~-_._----_._- ~---~ 8050 TOTAL TRANSFERS OUT 1,180,181 1,427,478 1,204,160 1,236,160 - -,- ----~._- ~----- 4000 REVENUES AND EXPENDITURES 137,100 152,068- 308,470 291,690- 636,610 1,291,170 ._. -------.-----..-.--- - -----~--- 01000 GENERAL FUND 137,100 152,068- 308,470 291,690- 636,610 1,291,170 7 R5509BUD SH001PV CITY OF SHAKOPEE 8/7/2009 8:40:18 By Company (pb), Object (2 Yr Bdgt) - Portrait Budget Report Page - 1 Fiscal Period: 7 / 09 Level Of Rollup 5 2007 2008 7/31/2009 2009 2010 2011 Actual Actual YTD Final Proposed Proposed Object Code / Description Amount Amount Actual Budget Budget Budget -_.._._--~ - 01000 GENERAL FUND 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 11,569,003- 12,871,292- 7,070,565- 13,297,310- 12,895,460- 12,765,530- 4100 SPECIAL ASSESSMENT 5,406- 9,950- 3,060 2,000- 2,000- 2,000- 4200 LICENSES AND PERMITS 973,659- 691,415- 551,475- 683,300- 1,028,800- 1,033,800- 4400 INTERGOVERNMENTAL 590,439- 361,412- 131,987- 577,990- 615,330- 615,330- 4500 CHARGES FOR SERVICE 1,090,020- 1,093,251- 397,337- 951,600- 1,880,040- 1,917,340- 4820 FINES & FORFEITS 451,418- 366,618- 139,282- 510,000- 381 ,ODD- 395, DDD- 4830 MISCELLANEOUS 603,835- 484,109- 104,999 451,300- 425,300- 417,800- ~-~- 4001 REVENUES 15,283,778- 15,878,047- 8,182,588- 16,473,500- 17,227,930- 17,146,800- 6000 EXPENDITURES 6001 WAGES & BENEFITS 9,530,705 9,807,791 5,437,057 10,635,350 11,996,060 12,254,880 6200 SUPPLIES AND SERVICES 5,985,372 6,242,949 2,736,636 6,132,510 7,524,000 7,710,610 6600 MISCELLANEOUS 118,080 114,929 48,32D 183,190 192,680 318,680 6700 CAPITAL OUTLAY 495,652 123,354 23,411 14,500 73,000 125,000 6000 EXPENDITURES 16,129,809 16,289,023 8,245,423 16,965,550 19,785,740 20,409,170 8005 TOTAL TRANSFERS IN 8010 OPERATING TRANSFERS IN 1,889,111- 1,990,522- 958,525- 2,019,900- 1,921,200- 1,971,200- ---~-_.__._-- 8005 TOTAL TRANSFERS IN 1,889,111- 1,990,522- 958,525- 2,019,900- 1,921,200- 1,971,200- 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 1,180,181 1,427,478 1,204,160 1,236,160 --~- ----- 8050 TOTAL TRANSFERS OUT 1,180,181 1,427,478 1,204,160 1,236,160 4000 REVENUES AND EXPENDITURES 137,100 152,068- 308,471 291,690- 636,610 1,291,17D ~-_..- ------- 01000 GENERAL FUND 137,100 152,068- 308,471 291,690- 636,610 1,291,170 ~",.tl fJ e: ( l'A : ...t'" i2. e...s (l,r,/.f!." - .3 2.';:;0=> - .1~o"C? o f\~;..,:-r 3/1 1..010 9(p(p, 170 ---~- 8 By Co, Div (Totals Only w 2 Yr Bdgt) - Portrait Fiscal Period: 7 Level Of Rollup 5 8/4/2009 Object Code / Description 2010 2010 2010 2010 2011 2011 2011 2011 01000 GENERAL FUND Revenue Expend. Transfers Net Revenue Expend. Transfers Net 00 N/A 13,138,960 1,921,200 15,060,160 13,003,030 1,971,200 14,974,230 11 MAYOR & COUNCIL 205,810 (205,810) 202,950 (202,950) 12 CITY ADMINISTRATOR 307,500 769,200 (461,700) 307,500 788,210 (480,710) 13 CITY CLERK 141 , 1 00 330,400 (189,300) 141 ,1 00 322,480 (181,380) 15 FINANCE 210,840 858,090 (647,250) 210,840 876,500 (665,660) 17 COMMUNITY DEVELOPMENT 29,700 472,660 (442,960) 29,700 479,460 (449,760) 18 FACILITIES 239,830 (239,830) 247,190 (247,190) 20 INFORMATION TECHNOLOGY 397,730 (397,730) 393,110 (393,110) 31 POLICE DEPARTMENT 940,900 6,553,940 (5,613,040) 954,900 6,817,140 (5,862,240) 32 FIRE 150,000 1,912,280 (1,762,280) 150,000 1,939,040 (1,789,040) 33 INSPECTION-BLDG-PLMBG-HTG 535,900 763,980 (228,080) 540,900 779,170 (238,270) 41 ENGINEERING 372,500 677,360 (304,860) 372,500 693,090 (320,590) co 42 STREET MAINTENANCE 318,830 1,921,800 (1,602,970) 318,830 1,989,280 (1,670,450) 44 FLEET 18,300 99,540 (81,240) 18,300 115,760 (97,460) 46 PARK MAINTENANCE 1,702,790 (1,702,790) 1,728,680 (1,728,680) 65 LIBRARY/CONGREGATE DINING 800 320,150 (319,350) 800 303,030 (302,230) 66 NATURAL RESOURCES 800 54,970 (54,170) 800 54,970 (54,170) 67 RECREATION 1,061,800 2,350,210 (1,288,410) 1,097,600 2,379,110 (1,281,510) 91 UNALLOCA TED 155,000 (155,000) 300,000 (300,000) TOTAL 17,227,930 19,785,740 1,921,200 (636,610) 17,146,800 20,409,170 1,971,200 (1,291,170) ~----~ ------- - -- ------------ - ~----- ------- , , Hftl\lJ out Pay 2010 Residential Property Value Changes 6000 p 5000 N r u 0 4000 m b P e 3000 e r r t 2000 i 0 e f 1000 s I 0 +0-5% -<1% -1~4+% -5~8+% -9~11+% -12~15+% -16~25+% -26~35+% Value Change Pay 2010 Residential Property Value Change . Increase . Decrease ---------- . Same levy tax rate 0.33832 Pay 2010 Residential Average Tax Change % Value Range Tax change # of affected Inc/Dec Properties $100.00 5000 +0-5% $ 52.36 881 c 4500 -<1% $ 24.86 219 h $50.00 -1-4+% $ 6.53 5031 4000 N a $- -5-8+% $ (30.14) 1070 u p n 3500 -9-11+% $ (62.23) 988 $(50.00) m a -12-15+% $ (94.31) 1862 g 3000 b r -16-25+% $ (14473) 605 e $(100.00) 2500 e c -26-35+% $ (254.74) 232 2000 r e 10,888 i $(150.00) I n 1500 $(200.00l o S 1000 f T $(250.00) 500 a $(300.00) 0 x ~\o 0\0 0\0 0\0 ^yxo\a (,./\0 ~~\a ~l\o e i'" ,,~x 'Ox xC:; ;,. ~ ~^y /',,; /';" />; S 9> ;,."- ;,.'" ",,'" Average tax change Increase 10% 1,100 Pay 2010 Residential Tax Change Less than $1 0 increa~ 46% 5,031 Decrease 44% 4,757 10% 10,888 44% . Increase . Less than $10 increase . Decrease -----------------------------------~------- , $ (112,000.00) Pay 2010 Residential Average Tax Change tax rate 0.33549 % Value Range Tax change # of affected $112,000 cut Inc/Dec Properties +0-5% $ 45.25 881 $100.00 5000 '>,B' -<1% $ 17.96 219 C 4500 $ h $50.00 -1-4+% (0.24) 5031 4000 N -5-8+% $ (3663) 1070 a $- u P -9-11+% $ (68.47) 988 n 3500 m a -12-15+% $ (100.31) 1862 g $(50.00) 3000 b -16-25+% $ (150.35) 605 r e $(100.00) -26-35+% $ (259.52) 232 2500 e c 10,888 $(150.00) 2000 r e i I 1500 n $(200.00) o 5 1000 f T $(250.00) 500 a $(300.00) 0 x ~\a ~\o 0\0 .\0 .\. a\a "'\0 0\0 e xCf ,t- ,~x 'Ox ,,>X <-,X ~x ~x :-- y; ,"> ~"\, /).:. /lj s 9> ;,.'" :--'" ",,'<> Average tax change Increase 10% 1,100 Pay 2010 Residential Tax Change $112,000 cut No change 46% 5,031 Decrease 44% 4,757 10% 10888 44% . Increase . No change . Decrease