Loading...
HomeMy WebLinkAbout5. 2009 Budget 5. CITY OF SHAKOPEE Memorandum TO: Mayor and Council Mark McNeill, City Administrator FROM: Gregg Voxland, Finance Director RE: 2009 Budget DATE: August 15, 2008 Introduction & Background Continued discussion of the 2009 budget: . General Fund overview. . Levy limit review. . Tax impact. . Tax "subsidy". a) Attached are General Fund summary level budget statement. b) General Fund revenue detail. c) Budget projection for different tax levy levels. d) Tax impact of 3.9% increase. e) Tax impact of maximum tax increase. f) Tax subsidy be division. Council action steps: 1. Any changes to revenue projections. 2. Reduce equipment rent by $100,000. 3. Reduce equipment rent by $200,000 instead of $100,000. 4. Decide on ($72,000?) deficit reduction. Prioritization cuts. Action Discuss and give direction. G~OXland Finance Director h:\budget09 R5509BUD .001 CITY OF .PEE 8/.10:20:30 Fiscal Period: 7 / 8 Budget Report Page - 1 Level Of Rollup 5 2005 2006 2007 7/31/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 01000 GENERAL FUND 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 8,741,111- 9,471,594- 11,569,003- 6,796,453- 12,979,410- 12,973,760- 12,973,760- 12,973,760- 4100 SPECIAL ASSESSMENT 2,892- 6,597- 5,406- 14,277 2,000- 2,000- 2,000- 2,000- 4200 LICENSES AND PERMITS 3,177,521- 1,644,174- 973,659- 439,743- 820,000- 683,300- 683,300- 683,300- 4400 INTERGOVERNMENTAL 434,211- 506,239- 590,439- 24,986- 344,000- 634,000- 634,000- 634,000- 4500 CHARGES FOR SERVICE 1,573,955- 1,294,733- 1,090,020- 528,848- 607,650- 886,600- 886,600- 886,600- 4820 FINES & FORFEITS 277,774- 374,808- 451,418- 211,709- 430,000- 510,000- 510,000- 510,000- 4830 MISCELLANEOUS 287,650- 452,508- 603,835- 41,497 405,000- 451,300- 451,300- 451,300- 4001 REVENUES 14,495,114- 13,750,653- 15,283,778- 7,945,966- 15,588,060- 16,140,960- 16,140,960- 16,140,960- 6000 EXPENDITURES 6001 WAGES & BENEFITS 7,689,039 8,482,664 9,530,705 5,197,447 10,315,330 10,849,940 10,849,940 10,849,940 6200 SUPPLIES AND SERVICES 4,377,291 5,115,228 5,985,372 3,192,861 6,367,170 6,486,480 6,486,480 6,486,480 6600 MISCELLANEOUS 99,939 91,297 118,080 38,958 227,960 183,190 183,190 183,190 6700 CAPITAL OUTLAY 93,703 173,063 495,652 21,148 139,000 14,500 14,500 14,500 6000 EXPENDITURES 12,259,971 13,862,251 16,129,809 8,450,414 17,049,460 17,534,110 17,534,110 17,534,110 8005 TOTAL TRANSFERS IN 8010 OPERATING TRANSFERS IN 1,373,131- 1,586,979- 1,889,111- 987,000- 1,740,000- 2,004,940- 2,004,940- 2,004,940- 8005 TOTAL TRANSFERS IN 1,373,131- 1,586,979- 1,889,111- 987,000- 1,740,000- 2,004,940- 2,004,940- 2,004,940- 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 1,175,986 1,309,889 1,180,181 1,145,010 1,171,010 1,243,350 1,243,350 1,243,350 8050 TOTAL TRANSFERS OUT 1,175,986 1,309,889 1,180,181 1,145,010 1,171,010 1,243,350 1,243,350 1,243,350 4000 REVENUES AND EXPENDITURES 2,432,288- 165,492- 137,100 662,458 892,410 631,560 631,560 631,560 01000 GENERAL FUND 2,432,288- 165,492- 137,100 662,458 892,410 631,560 631,560 631,560 ~ R5509BUD .001 CITY OF .PEE 8/. 10:22:56 Fiscal Period: 7 / 8 Budget Report Page - 1 Level Of Rollup 7 2005 2006 2007 7/31/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 01000 GENERAL FUND 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4010 PROPERTY TAX 4011 CURRENT PROPERTY TAX 7,844,390- 8,432,190- 9,985,594- 6,070,626- 11,091,950- 11,411,200- 11,411,200- 11,411,200- 4012 DELINQUENT PROPERTY TAX 6,668- 67,503 50,321 4013 MARKET VALUE CREDIT 711- 118- 520,909- 531,860- 4015 FISCAL DISPARITIES 677,034- 862,751- 906,165- 636,859- 1,137,200- 1,344,160- 1,344,160- 1,344,160- 4020 MOBIL HOME TAX 441- 603- 461- 274- 400- 400- 400- 400- 4031 EXCESS TAX INCREMENT 36,152- 1,571 4040 AGGREGATE TAX 8,000- 9,214- 7,083- 2,023- 8,000- 8,000- 8,000- 8,000- 4050 LODGING TAX 203,867- 198,070- 200,682- 86,671- 210,000. 210,000- 210,000- 210,000- 4010 PROPERTY TAX 8,741,111- 9,471,594- 11,569,003- 6,796,453- 12,979,410- 12,973,760- 12,973,760- 12,973,760- 4005 TAXES 8,741,111- 9,471,594- 11,569,003- 6,796,453- 12,979,410- 12,973,760- 12,973,760- 12,973,760- 4100 SPECIAL ASSESSMENT 4110 SPECIAL ASSESSMENT PRINCIPAL 978- 2,707- 1,848- 17,806- 2,000- 2,000- 2,000- 2,000- 4111 SPEC ASSESSMENT INTEREST 1,375- 1,582- 2,517- 4120 SA PREPAY 540- 2,308- 1,041- 32,083 4100 SPECIAL ASSESSMENT 2,892- 6,597- 5,406- 14,277 2,000- 2,000- 2,000- 2,000- 4200 LICENSES AND PERMITS 4201 LICENSES 4203 TRACK FRANCHISE 11,535- 10,733- 12,281- 12,000- 12,000- 12,000- 12,000- 4220 LIQUOR LICENSE 104,280- 111,736- 117,825- 111,641- 112,000- 106,000- 106,000- 106,000- 4230 BEER LICENSE 4,929- 3,564- 3,949- 3,278- 4,000- 4,000- 4,000- 4,000- 4240 CIGARETTE LICENSE 7,742- 6,363- 8,225- 300- 7,000- 7,000- 7,000- 7,000- 4242 DOG LICENSES 2,953- 3,909- 4,386- 2,284- 4,000- 4,500- 4,500- 4,500- 4243 MiSe BUSINESS LICENSE 12,722- 8,923- 9,366- 4,240- 9,000- 9,000- 9,000- 9,000- 4244 Mise NON-BUSINESS LICENSE 20- 20- 4201 LICENSES 144,162- 145,248- 156,051- 121,743- 148,000- 142,500- 142,500- 142,500- 4250 PERMITS 4251 BUILDING PERMITS 1,659,322- 782,372- 345,779- 145,698- 300,000- 230,000- 230,000- 230,000- 4259 PLAN REVIEW FEE 673,137- 329,034- 131,837- 42,416- 120,000- 70,000- 70,000- 70,000- ~ 4261 PLUMBING PERMITS 134,272- 71,491- 68,488- 26,974- 55,000- 46,000- 46,000- 46,000- 4265 MECHANICAL PERMITS 238,967- 85,938- 96,404- 30,238- 55,000- 55,000- 55,000- 55,000- 4267 ELECTRICAL PERMITS 125,637- 79,271- 80,217- 35,544- 50,000- 65,000- 65,000- 65,000- R5509BUD LOGIS001 CITY OF SHAKOPEE 8/1412008 10:22:56 Fiscal Period: 7 / 8 Budget Report Page- 2 Level Of Rollup 7 2005 2006 2007 7/31/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 4272 SEWER & WATER PERMITS 40,801- 29,669- 15,346- 5,308- 7,000- 7,000- 7,000- 7,000- 4274 FIRE INSPECTION PERMITS 33,481- 23,078- 21,908- 12,106- 25,000- 25,000- 25,000- 25,000- 4275 INSPECTIONS 8,977- 5,086- 47- 4276 FENCE PERMITS 1,200- 1,775- 1,200- 1,200- 1,200- 4280 STREET OPENING PERMITS 118,766- 92,987- 54,692- 17,541- 60,000- 40,000- 40,000- 40,000- 4282 WOODLAND MANAGEMENT FEE 1,689- 400- 1,600- 1,600- 1,600- 4250 PERMITS 3,033,360- 1,498,926- 817,608- 318,000- 672,000- 540,800- 540,800- 540,800- 4200 LICENSES AND PERMITS 3,177,521- 1,644,174- 973,659- 439,743- 820,000- 683,300- 683,300- 683,300- 4400 INTERGOVERNMENTAL 4410 FEDERAL GRANTS 2,887- 74,593- 167,928- 5,000- 5,000- 5,000- 5,000- 4411 COPS 100,484- 80,916- 60,412- 4412 BLOCK GRANT 27,934- 4410 FEDERAL GRANTS 131,305- 155,509- 228,340- 5,000- 5,000- 5,000- 5,000- 4450 STATE GRANTS & AIDS 18,756- 18,148- 18,688- 14,681- 15,000- 10,000- 10,000- 10,000- 4455 PERA AID 11,933- 18,170- 18,170- 9,085- 19,000- 19,000- 19,000- 19,000- 4460 STATE AID - MAINT 215,000- 215,000- 215,000- 4465 STATE AID - POLICE 208,658- 223,408- 295,743- 228,000- 295,000- 295,000- 295,000- 4482 COUNTY GRANTS/AIDS 14,295- 41,235- 29,498- 12,000- 25,000- 25,000- 25,000- 4490 OTHER LOCAL GRANTS/AIDS 49,265- 49,770- 1,220- 65,000- 65,000- 65,000- 65,000- 4450 STATE GRANTS & AIDS 302,907- 350,731- 362,099- 24,986- 339,000- 629,000- 629,000- 629,000- 4400 INTERGOVERNMENTAL 434,212- 506,240- 590,439- 24,986- 344,000- 634,000- 634,000- 634,000- 4500 CHARGES FOR SERVICE ".' 4510 ADMINISTRATIVE CHARGES 4511 ADMINISTRATIVE CHARGES 166,481- 129,494- 52,045- 11,292- 65,000- 51,840- 51,840- 51,840- 4513 SALE OF DOCUMENTS 5,949- 12,615- 10,685- 4,218- 8,000- 8,700- 8,700- 8,700- 4516 ASSESSMENT SEARCHES 1,270- 2,275- 1,075- 400- 2,000- 1,000- 1,000- 1,000- 4518 RELEASE OF DEVELOPER AGREEMENT 320- 175- 25- 25- 150- 4525 TITLE EXAMINATION 1,500- 4510 ADMINISTRATIVE CHARGES 174,021- 144,560- 65,330- 15,935- 75,150- 61,540- 61,540- 61,540- 4570 COMMUNITY DEVELOPMENT 4571 APPEAL 1,350- 525- 1,000- 1,000- 1,000- 1,000- 4572 SIGNS 9,920- 3,370- 3,000- 9,000- 9,000- 9,000- 4573 CONCEPT REVIEWS 350- 1,489- 4574 REZONE/COMP PLAN 3. 3,110- 3,000- 3,000- 3,000- 3,000. . R5509BUD .001 CITY OF .PEE 8/. 10:22:56 Fiscal Period: 7 / 8 Budget Report Page - 3 Level Of Rollup 7 2005 2006 2007 7/31/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 4575 ZONING LETTER 350- 250- 600- 350- 350- 350- 4576 LAND DIVISION ADMINISTRATION 12,479- 18,856- 8,471 4578 LAND USE ADMINISTRATION 37,689- 28,116- 4579 P U D 3,681- 3,816- 2,840- 2,840- 2,840- 4580 MAJOR SUBDIVISION PRE-APP 828- 350- 350- 350- 4581 PRELIMINARY PLAT 9,742- 9,464- 5,400- 5,400- 5,400- 4582 FINAL PLAT 32,927- 3,179- 2,820- 2,820- 2,820- 4583 MINOR SUBDIVISION 500- 1,900- 3,800- 3,800- 3,800- 4584 VACATION 2,550- 850- 1,000- 2,500- 2,500- 2,500- 4585 VARIANCE 900- 300- 5,000- 1,000- 1,000- 1,000- 4586 CUP 4,450- 2,000- 10,000- 2,400- 2,400- 2,400- 4587 HOME OCCUPATION 200- 200- 500- 600- 600- 600- 4570 COMMUNITY DEVELOPMENT 50,168- 46,972- 61,460- 31,280- 24,100- 35,060- 35,060- 35,060- 4600 ENGINEERING 4620 ENGINEER FEE - PRIVATE 944,392- 781,969- 133,955- 53,718- 100,000- 100,000- 100,000- 4621 ENGINEER FEE - PUBLIC 418,347- 142,311- 200,000- 300,000- 300,000- 300,000- 4630 GRADE FEE 149,318- 57,467- 17 ,605- 3,538- 400- 8,000- 8,000- 8,000- 4600 ENGINEERING 1,093,710- 839,436- 569,907- 199,567- 200,400- 408,000- 408,000- 408,000- 4640 PUBLIC SAFETY FEES 4642 POLICE SERVICES 114,711- 100,640- 142,729- 55,190- 100,000- 110,000- 110,000- 110,000- 4643 VALLEY FAIR 36,829- 34,274- 32,246- 30,283- 34,000- 31,000- 31,000- 31,000- 4655 POUND FINES & FEES 1,110- 260- 2,120- 780- 2,000- 2,000- 2,000- 4660 FIRE SERVICES 69,963- 97,630- 148,906- 150,013- 146,000- 149,000- 149,000- 149,000- 4640 PUBLIC SAFETY FEES 222,613- 232,804- 326,001- 236,266- 280,000- 292,000- 292,000- 292,000- 4670 PUBLIC WORKS 4680 MISC PUBLIC WORKS 8,050- 12,966- 53,938- 37,411- 12,000- 80,500- 80,500- 80,500- 4684 STREET SIGNS 15,390- 5,940- 1,860- 880- 4,000- 2,000- 2,000- 2,000- 4670 PUBLIC WORKS 23,440- 18,906- 55,798- 38,291- 16,000- 82,500- 82,500- 82,500- 4750 REFUSE 4751 REFUSE CHARGES 10,003- 12,056- 11,524- 7,509- 12,000- 7,500- 7,500- 7,500- 4750 REFUSE 10,003- 12,056- 11,524- 7,509- 12,000- 7,500- 7,500- 7,500- 4760 RECREATION FEES 4500 CHARGES FOR SERVICE 1,573,955- 1,294,733- 1,090,020- 528,848- 607,650- 886,600- 886,600- 886,600- 4820 FINES & FORFEITS R5509BUD LOGIS001 CITY OF SHAKOPEE 8/14/2008 10:22:56 Fiscal Period: 7 / 8 Budget Report Page- 4 Level Of Rollup 7 2005 2006 2007 7/31/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 4821 FINES & FORFEITS 191,561- 243,245- 269,067- 137,643- 280,000- 320,000- 320,000- 320,000- 4822 FINES& FORFEITS - SJPA 86,213- 131,562- 182,351- 74,066- 150,000- 190,000- 190,000- 190,000- 4820 FINES & FORFEITS 277,774- 374,808- 451,418- 211,709- 430,000- 510,000- 510,000- 510,000- 4830 MISCELLANEOUS 4832 INVESTMENT INCOME 4833 INTEREST 200,727- 388,297- 523,673- 62,345 350,000- 400,000- 400,000- 400,000- 4832 INVESTMENT INCOME 200,727- 388,297- 523,673- 62,345 350,000- 400,000- 400,000- 400,000- 4835 MISCELLANEOUS NON-INTEREST 4840 RENTS 5,017- 7,418- 142- 5,000- 4843 COMMISSIONS 935- 778- 5,775- 6,993- 800- 800- 800- 4845 CONTRIBUTIONS 8,050- 15,625- 50- 8,550- 4850 MISCELLANEOUS 5,594 23,693- 27,086- 5,305- 34,000- 34,500- 34,500- 34,500- 4852 INSURANCE DIVIDENDS/FEES 79,143- 16,697- 29,408~ 16,000- 16,000- 16,000- 16,000- 4855 SALE OF ASSETS 629 17,700- 4835 MISCELLANEOUS NON-INTEREST 86,922- 64,211- 80,161- 20,849- 55,000- 51,300- 51,300- 51,300- 4830 MISCELLANEOUS 287,650- 452,508- 603,835- 41,497 405,000- 451,300- 451,300- 451,300- 4960 PROCEEDS FROM DEBT ISSUED 4001 REVENUES 14,495,114- 13,750,653- 15,283,779- 7,945,966- 15,588,060- 16,140,960- 16,140,960- 16,140,960- 4000 REVENUES AND EXPENDITURES 14,495,114- 13,750,653- 15,283,779- 7,945,966- 15,588,060- 16,140,960- 16,140,960- 16,140,960- 01000 GENERAL FUND 14,495,114- 13,750,653- 15,283,779- 7,945,966- 15,588,060- 16,140,960- 16,140,960- 16,140,960- . . . CITY OF SHAKO PEE 2009 General Fund Totals Current Maximum Option Option Option Option A B C 0 2010 2011 Revenues 100.000% 102.700% 103.900% 106.400% 103.90% 103.90% Tax $ 12,477,920 $ 12,825,820 $ 12,975,760 $ 13,294,373 $ 13,481,815 $ 14,007,605 Licenses/Permits 683,300 683,300 683,300 683,300 683,300 850,000 Intergovt 634,000 634,000 634,000 634,000 640,340 646,743 Charges for Service 886,600 886,600 886,600 886,600 913,198 940,594 Fines 510,000 510,000 510,000 510,000 525,300 541,059 Misc 451 451 451 451 451 451 BP Reserve Transfers in 2,004,940 2,004,940 2,004,940 2,004,940 2,065,088 2,127,041 Total Sources 18,008,060 18,355,960 18,505,900 18,824,513 19,120,341 19,924,343 Expenditures Wages 10,849,940 10,849,940 10,849,940 10,849,940 11,370,737 11,916,533 Supplies/Services 6,486,480 6,486,480 6,486,480 6,486,480 6,700,534 6,921,651 Misc 183,190 183,190 183,190 183,190 183,190 183,190 Capital 14,500 14,500 14,500 14,500 50,000 50,000 Transfers out 1,319,070 Equip Rent Total uses 18,577,460 18,577,460 18,577,460 18,577,460 19,385,111 20,390,444 Net (569,400) (221,500) (71,560) 247,053 (264,771) (466,101) GF Fund Balance 6,797,451 7,145,351 7,295,291 7,613,904 6,532,680 6,066,579 37% 38% 39% 41% 34% 30% Wages 4.8% 4.8% Supplies/Services 3.3% 3.3% Misc 0.0% 0,0% r Capital Transfers out 3.0% 3.0% c... U fY'eNl -- 3.' ~ o/"~'I'J~ City of Shakopee TIF Fiscal Disparity Taxable NTC Ref Market Val Shakopee (156,582) (6,073,067) 40,870,351 3,775,000,000 Levy Gross Fisc Disp Dist Spread Taxable NTC Est TC Rate Net Tax Cap Based _$ (1,344,156) $ 13,294,422 40,870,351 32.528% Levy Ref MV Est MV Rate Market Value Based _$ - $ 246,239 3,775,000,000 0.00652% Estimated Estimated Estimated Estimated Estimated Value Tax Capacity NTC Tax Rate NTC Tax MV Rate MV Tax MV Credit 2009 Total Tax 171,918 1,719 32.528% $ 559.22 0.00652% $ 11.21 $ 69.66 $ 500.78 229,224 2,292 32.528% $ 745.63 0.00652% $ 14.95 $ 53.15 $ 707.43 286,530 2,865 32.528% $ 932.03 0.00652% $ 18.69 $ 36.65 $ 914.08 334,285 3,343 32.528% $ 1,087.37 0.00652% $ 21.81 $ 22.89 $ 1,086.28 2008 Value Tax Cap NTC Tax Rate NTC Tax Ref MV Rate MV Tax MV Credit 2008 Total Tax 180,000 1,800 31.925% $ 574.65 0.00537% $ 9.67 $ 71.24 $ 513.07 240,000 2,400 31.925% $ 766.20 0.00537% $ 12.89 $ 52.96 $ 726.13 300,000 3,000 31.925% $ 957.75 0.00537% $ 16.11 $ 34.67 $ 939.19 350,000 3,500 31.925% $ 1,117.38 0.00537% $ 18,80 $ 19.44 $ 1,116.73 t) /vfA~"M c.(M City of Shakopee TIF Fiscal Disparity Taxable NTC Ref Market Val Shako pee (156,582) (6,073,067) 40,870,351 3,775,000,000 Levy Gross Fisc Disp Dist Spread Taxable NTC Est TC Rate Net Tax Cap Based 1_6.~' $ (1,344,156) $ 13,619,537 40.870,351 33.324% :',*:' .' ,a,~i Levy Ref MV Est MV Rate Market Value Based [ii._ $ - $ 246,239 3,775,000,000 0.00652% Estimated Estimated Estimated Estimated Estimated Value Tax Capacity NTC Tax Rate NTC Tax MV Rate MV Tax MV Credit 2009 Total Tax 171,918 1,719 33.324% $ 572.90 0.00652% $ 11.21 $ 69.66 $ 514.45 229,224 2,292 33.324% $ 763.86 0.00652% $ 14.95 $ 53.15 $ 725.66 286,530 2,865 33.324% $ 954.83 0.00652% $ 18.69 $ 36.65 $ 936.87 334,285 3,343 33.324% $ 1.113.96 0.00652% $ 21.81 $ 22.89 $ 1,112.87 2008 Value Tax Cap NTC Tax Rate NTC Tax Ref MV Rate MVTax MV Credit 2008 Total Tax 180,000 1,800 31.925% $ 574.65 0.00537% $ 9.67 $ 71.24 $ 513.07 240,000 2,400 31.925% $ 766.20 0.00537% $ 12.89 $ 52.96 $ 726.13 300,000 3.000 31.925% $ 957.75 0,00537% $ 16.11 $ 34.67 $ 939.19 350,000 3.500 31.925% $ 1.117.38 0.00537% $ 18.80 $ 19.44 $ 1,116.73 ~ - !- General Fund Division "tax subsidy" 2009 Revenue Expenditure Net "Subsidv" Mayor $ 165,700 $ (165,700) $ 165,700 Admin 553,930 (553,930) 553,930 Clerk 130,500 310,200 (179,700) 179,700 Finance 274,840 819,090 (544,250) 544,250 Legal 510,000 533,500 (23,500) 23,500 Planning 35,060 535,930 (500,870) 500,870 Facilities 238,420 (238,420) 238,420 IT 359,170 (359,170) 359,170 Police 535,200 6,283,660 (5,748,460) 5,748,460 Fire 174,000 2,029,890 (1,855,890) 1,855,890 Inspections 483,700 751,980 (268,280) 268,280 Engineering 509,000 761,290 (252,290) 252,290 Street 1,967,500 (1,673,500) 1,673,500 Fleet 103,640 (43,640) 43,640 Park 1,540,990 (1,540,990) 1,540,990 Library 800 323,580 (322,780) 322,780 Natural Resources 1,600 135,830 (134,230) 134,230 Unallocated 120,000 (120,000) 120,000 Recreation 1,112,600 2,323,950 (1,211,350) 1,211,350 EDA 129,000 116,680 12,320 92,000 Telecomm 335,000 117,920 217,080 Transit 1,085,000 1,170,040 (85,040)