Loading...
HomeMy WebLinkAbout2.F. General Fund 2008 Budget . " IF CITY OF SHAKOPEE ON. T~ t3 t.. E Memorandum TO: Mayor and Council Mark McNeill, City Administrator FROM: Gregg Voxland, Finance Director SUBJ: General Fund 2008 Budget DATE: August 10, 2007 General Fund revenues are projected to be down in the three major areas related to development. 2007 is a projection of year to date July actual. There is a decrease of $3,305,738 from 2005 to 2008. 2005 2006 2007 2008 Permits 3,033,360 1,498,926 894,504 647,000 Planning 50,168 46,972 31,620 24,100 Engineering 1,093,710 839,436 531,327 200,400 4,177,238 2,385,334 1,457,451 871,500 The budget status for 2008 as it stands now with keeping the same tax rate, entrance monument and 800 MHZ coming out of fund balance, no new positions and no layoffs and a 4% under-spend factor is a surplus of $44,000. Keeping the same tax rate is a levy increase of 12%. Total net taxable tax capacity went from $~6,078,941 to $40,271,139, an increase of 11.6% - keep in mind these numbers are preliminary and some houses are still impacted by limited market value. Attached are General Fund revenue print out (pages 2-5), Expenditures summary by division (page 6), four year average under-spent by division (page 7), tax impact on five sample properties (page 8) tax levy worksheet (page 9) and options worksheet (page 10) . I ,," R5509BUD Lu131S001 CITY OF 5,.. ..,OPEE B/1...__,,7 9:33:59 Fiscal Period: Budget Report Page - 1 7 1 7 Level Of Rollup 7 2004 2005 2006 7/31/2007 2007 200B 200B 200B Actual Actual Actual YTD Final Requested Approved Final Object Code 1 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 6,685,974- 7,B44,390- B,432,190- 4,557,360- 9,B54,440- 11,091,950- 11,091,950- 11,091,950- 4012 DELINQUENT PROPERTY TAX 95,060 6,66B- 67,503 4013 MARKET VALUE CREDIT 624- 711- 11B- 531,B60- 531,B60- 531,B60- 531,860- 4015 FISCAL DISPARITIES 524,524- 677, 034- B62,751- 490,010- 955,800- 1,137,200- 1,137,200- 1,137,200- 4020 MOBIL HOME TAX 367- 441- 603- 150- 400- 400- 400- 400- 4031 EXCESS TAX INCREMENT 6,675- 36,152- 1,612 4040 AGGREGATE TAX 5,B47- 8,000- 9,214- 2,374- 8,000- 8,000- 8,000- 8,000- 4050 LODGING TAX 197,B52- 203,B67- 19B,070- 85,548- 210,000- 210,000- 210,000- 210,000- 4010 PROPERTYTAX 7,326,802- B,741,111- 9,471,594- 5,133,B30- 11,560,500- 12,979,410- 12,979,410- 12,979,410- 4005 TAXES 7,326,802- B,741,111- 9,471,594- 5,133,B30. 11,560,500- 12,979,410~ 12,979,410- 12,979,410- 4100 SPECIAL ASSESSMENT 4110 SPECIAL ASSESSMENT PRINCIPAL 8,517 978- 2,707- 1,106- 2,000- 2,000- 2,000- 2,000- 4111 SPEC ASSESSMENT INTEREST 1,461- 1,375- 1,582- 4120 SAPREPAY 270- 540- 2,308- 4toO SPECIAL ASSESSMENT 6,786 2,892- 6,597- 1,106- 2,000.. 2,000- 2,000- 2,000- 4200 LICENSES AND PERMITS 4201 LICENSES 4203 TRACK FRANCHISE 9,764- 11,535- 10,733- 12,000- 12,000- 12,000- 12,000- 4220 LIQUOR LICENSE 95,714- 104,280- 111,736- 108,959- 112,000- 112,000- 112,000- 112,000- 4230 BEER LICENSE 3,880- 4,929- 3,564- 3,732- 4,000- 4,000- 4,000-. 4,000- 4240 CIGAREITE LICENSE 7,30B- 7,742- 6,363- 1,225- 7,700- 7,000- 7,000- 7,000- 4242 DOG LICENSES 1,124- 2,953- 3,909- 2,2B6- 3,000- 4,000- 4,000- 4,000- 4243 MISC BUSINESS LICENSE 12,722- 8,923- 699- 11,000- 9,000- 9,000- 9,000- 4244 MISC NON-BUSINESS LICENSE 20- 20- 4201 LICENSES 117,790- 144,162- 145,248- 116,921- 149,700- 14B,OOO- 148,000- 148,000- 4250 PERMITS 4251 BUILDING PERMITS 1,471,562- 1,659,322- 7B2,372- 214,591- 700,000- 300,000- 300,000- 300,000- 4259 PLAN REVIEW FEE 875,581- 673,137- 329,034- 83,941- 300,000- 160,000.. 160,000- 160,000- 4261 PLUMBING PERMITS 153,037- 134,272- 71,491- 4B,907- 75,000- 20,000- 20,000- 20,000- 4265 MECHANICAL PERMITS 172,324- 238,967- 85,93B- 76,501- 80,000- 25,000- 25,000- 25,000- 4267 ELECTRICAL PERMITS 134,710- 125,637- 79,271- 48,642- 80,000- 50,000- 50,000- 50,000- .\'-' CITY OF SHAKOPEE 8/10/2007 9:33:59 R5509BUD LOGIS001 Budget Report Page - 2 Fiscal Period: 7 I 7 Level Of Rollup 7 2004 2005 2006 7/31/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 4272 SEWER & WATER PERMITS 44,444- 40,801- 29,669- 7,598- 20,000- 7,000- 7,000- 7,000- 4274 FIRE INSPECTION PERMITS 38,728- 33,481- 23,078- 14,088- 20,000- 25,000- 25,000- 25,000- 4275 INSPECTIONS 13,349- 8,977- 5,086- 47- 5,000- 4276 FENCE PERMITS 725- 4280 STREET OPENING PERMITS 162,428- 118,766- 92,987- 25,065- 75,000- 60,000- 60,000- 60,000- 4282 WOODLAND MANAGEMENT FEE 4,159- 1,689- 4284 MISC BUSINESS PERMITS 9,577- 4250 PERMITS 3,079,900- 3,033,360- 1,498,926- 521,794- 1,355,000- 647,000- 647,000- 647,000- 4200 LICENSES AND PERMITS 3,197,690- 3,177,521- 1,644,174- 638,714- 1,504,700- 795,000- 795,000- 795,000- 4400 INTERGOVERNMENTAL 4410 FEDERAL GRANTS 4,326- 2,887- 74,593- 137,928- 5,000- 5,000- 5,000- 5,000- 4411 COPS 79,126- 100,484- 80,916- 723- 8,000- 4412 BLOCK GRANT 27,934- 4410 FEDERAL GRANTS 83,452- 131,305- 155,509- 138,651- 13,000- 5,000- 5,000- 5,eoO- 4450 STATE GRANTS & AIDS 70,129- 18,756- 18,148- 7,696- 10,000- 15,000- 15,000- 15,000- 4455 PERA AID 18,170- 11,933- 18,170- 9,085- 5,960- 19,000- 19,000- 19,000- 4465 STATE AID - POLICE 181,935- 208,658- 223,408- 225,000- 228,000- 228,000- 228,000- 4482 COUNTY GRANTSIAIDS 7,115- 14,295- 41,235- 29,498- 8,000- 12,000- 12,000- 12,000- 4490 OTHER LOCAL GRANTSIAIDS 4,178- 49,265- 49,770- 65,000- 65,000- 65,000- 4450 STATE GRANTS & AIDS 281,528- 302,907- 350,731- 46,279- 248,960- 339,000- 339,000- 339,000- 4400 INTERGOVERNMENTAL 364,979- 434,212- 506,240- 184,929- 261,960- 344,000- 344,000- 344,000- 4500 CHARGI;S FOR SERVICE 4510 ADMINISTRATIVE CHARGES 4511 ADMINISTRATIVE CHARGES 169,268- 166,481- 129,494- 5,106- 100,000- 65,000- 65,000- 65,000- 4513 SALE OF DOCUMENTS 8,957- 5,949- 12,615- 8,352- 8,000- 8,000- 8,000- 8,000- 4516 ASSESSMENT SEARCHES 2,105- 1,270- 2,275- 875- 1,500- 2,000- 2,000- 2,000- 4518 RELEASE OF DEVELOPER AGREEMENT 360- 320- 175- 25- 300- 150- 150- 150- 4525 TITLE EXAMINATION 300- 4510 ADMINISTRATIVE CHARGES 180,690- 174,021- 144,560- 14,658- 109,800- 75,150- 75,150- 75,150- 4570 COMMUNITY DEVELOPMENT 4571 APPEAL 825- 1,000- 1,000- 1,000.. 4572 SIGNS 5,625- 3,000- 3,000- 3,000- 4574 REZONE/COMP PLAN 2,510- 3,000- 3,000- 3,000- 4575 ZONING LEITER 175- 600- 600- 600- C,v R5509BUD Lu131S00 1 CITY OF $,.. ."OPEE 8/1...... JJ7 9:33:59 Fiscal Period: 7 I 7 Budget Report Page .. 3 Level Of Rollup 7 2004 2005 2006 7/31/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final ....' Object Code 1 Description Amount Amount Amount Actual BUdget Budget Budget Budget 4576 LAND DIVISION ADMINISTRATION 10,824- 12,479- 18,856- 220,000- 4578 LAND USE ADMINISTRATION 42,051- 37,689- 28,116- 46,000- 4581 PRELIMINARY PLAT 2,700- 4582 FINAL PLAT 1,410- 4583 MINOR SUBDIVISION 500- 4584 VACATION 850- 1,000- 1,000- 1,000- 4585 VARIANCE 600- 5,000- 5,000- 5,000- 4586 CUP 3,050- 10,000- 10,000- 10,000- 4587 HOME OCCUPATION 200- 500- 500- 500- 4570 COMMUNITY DEVELOPMENT 52,875- 50,168- 46,972- 18,445- 266,000- 24,100- 24,100- 24,100- 4600 ENGINEERING 4620 ENGINEER FEE - PRIVATE 931,326- 944,392- 781,969- 133,955- 700,000- 4621 ENGINEER FEE - PUBLIC 165,481- 200,000- 200,000- 200,000- 4630 GRADE FEE 225,822- 149,318- 57,467- 10,505- 100,000- 400- 400- 400- 4600 ENGINEERING 1,157,148- 1,093,710- 839,436- 309,941- 800,000- 200,400- 200,400- 200,400- 4640 PUBLIC SAFETY FEES 4642 POLICE SERVICES 53,675- 114,711- 100,640- 47,990- 180,000- 100,000- 100,000- 100,000- 4643 VALLEY FAIR 35,194- 36,829- 34,274- 32,246- 36,000- 34,000- 34,000- 34,000- 4655 POUND FINES & FEES 4,610- 1,110- 260- 1,380- 4660 FIRE SERVICES 67,127- 69,963- 97,630- 145,106- 140,000.. 146,000- 146,000- 146,000- 4640 PUBLIC SAFETY FEES 160,607- 222,613- 232,804- 226,722- 356,000- 280,000- 280,000- 280,000- 4670 PUBLIC WORKS 4678 PUBLIC WORKS RENTAL 334- 4680 MISC PUBLIC WORKS 7,169- 8,050- 12,966- 18,518- 8,000- 12,000- 12,000- 12,000- 4684 SIGNS 6,210- 15,390- 5,940- 1,830- 8,000- 4,000- 4,000- 4,000- 4670 PUBLIC WORKS 13,713- 23,440- 18,906- 20,348- 16,000- 16,000- 16,000- 16,000- 4750 REFUSE 4751 REFUSE CHARGES 9,616- 10,003- 12,056- 11,524- 11,000- 12,000- 12,000- 12,000- 4750 REFUSE 9,616- 10,003- 12,056- 11,524- 11,000- 12,000- 12,000- 12,000- 4760 RECREATION FEES 4500 CHARGES FOR SERVICE 1,574,649- 1,573,955- 1,294,733- 601,638- 1,558,800- 607,650- 607,650- 607,650- 4820 FINES & FORFEITS ,4821 FINES & FORFEITS 249,642- 191,561- 243,245- 130,900- 280,000- 280,000- 280,000- 280,000- >: -t:. 4822 FINES & FORFEITS - SJPA 6,121- 86,213- 131,562- 72,119- 150,000- 150,000- 150,000- R5509BUO LOGIS001 CITY OF SHAKOPEE 8/10/2007 9:33:59 Fiscal Period: 7 I 7 Budget Report Page - 4 Level Of Rollup 7 2004 2005 2006 7/31/2007 2007 2008 2008 2008 Actual Actual Actual YTD Final Requested Approved Final Object Code 1 Description Amount Amount Amount Actual Budget Budget Budget Budget 4820 FINES & FORFEITS 255,763- 277,774- 374,808- 203,019- 280,000- 430,000- 430,000- 430,000- 4830 MISCELLANEOUS 4832 INVESTMENT INCOME 4833 INTEREST 136,758- 200,727- 388,297- 53,807- 220,000- 350,000- 350,000- 350,000- 4832 INVESTMENT INCOME 136,758- 200,727- 388,297- 53,807- 220,000- 350,000- 350,000- 350,000- 4835 MISCELLANEOUS NON-INTEREST 4840 RENTS 1,876- 5,017- 7,418- 142- 2,000- 5,000- 5,000- 5,000- 4843 COMMISSIONS 649- 935- 778- 5,438- 4845 CONTRIBUTIONS 8,050- 15,625. 4850 MISCELLANEOUS 34,805- 5,594 23,693- 989- 61,500- 34,000- 34,000- 34,000- 4852 INSURANCE DIVIDENDS/FEES 79,143- 16,697- 16,000- 16,000- 16,000- 4855 SALE OF ASSETS 629 4835 MISCtLLANEOUS NON-INTEREST 37,330- 86,922- 64,211- 6,570- 63,500- 55,000- 55,000- 55,000- 4830 MISCELLANEOUS 174,088- 287,650- 452,508- 60,376- 283,500- 405,000- 405,000- 405,000- 4960 PROCEEDS FROM DEBT ISSUED 4001 REVENUES 12,887,185- 14,495,114- 13,750,653- 6,823,613- 15,451,460- 15,563,060- 15,563,060- 15,563,060- 4000 REVENUES AND EXPENDITURES 12,887,185- 14,495,114- 13,750,653- 6,823,613- 15,451,460- 15,563,060- 15,563,060- 15,563,060- 01000 GENERAL FUND 12,887,185- 14,495,114- 13,750,653- 6,823,613- 15,451,460- 15,563,060- 15,563,060- 15,563,060- "'>'-;'. ~ > CITY OF SHAKOPEE 8/10/2007 Budget Report 2004 2005 2006 7/31/2007 2007 2008 Actual Actual Actual YTD Actual Budoet Requested Object Code / Description 01000 GENERAL FUND 11 MAYOR & COUNCIL 79,234 70,251 85,176 81,774 198,090 177,190 -11% 12 CITY ADMINISTRATOR 536,518 379,656 424,010 263,908 488,360 526,170 8% 13 CITY CLERK 266,616 323,594 320,670 171,727 314,790 364,540 16% 15 FINANCE 634,221 662,711 677,882 441,706 748,780 770,090 3% 16 LEGAL COUNSEL 298,616 285,754 448,961 259,178 486,300 533,500 10% 17 COMMUNITY DEVELOPMENT 402,102 398,185 436,865 246,297 511,350 546,670 7% 18 GENERAL GOVERNMENT BUILDINGS 549,968 532,314 303,298 205,307 351,190 266,330 -24% 20 INFORMATION TECHNOLOGY 187,193 207,854 298,603 201,607 282,090 312,020 11% 31 POLICE DEPARTMENT 3,682,219 4,107,360 4,796,124 2,880,861 5,719,500 6,021,430 5% 32 FIRE 1,078,778 1,194,610 1,481,327 997,228 1,976,930 2,106,490 7% 33 INSPECTION-BLDG-PLMBG-HTG 740,747 855,864 829,526 531 ,173 857,930 820,540 -4% 41 ENGINEERING 685,660 773,574 867,415 430,033 968,340 924,110 -5% 42 STREET MAINTENANCE 992,742 1 ,152,924 1,190,775 1,056,548 1,623,550 1,839,450 13% 44 SHOP 291,826 402,364 364,507 164,552 66,250 94,380 42% 46 PARK MAINTENANCE 793,082 912,955 1,076,929 596,936 1,309,940 1,423,990 9% 65 LIBRARY/CONGREGATE DINING 260,182 152,934 309,460 297,080 -4% 66 NATURAL RESOURCES 70,115 118,830 127,660 7% 91 UNALLOCA TED - -76,631 150,000 156,000 4% 01000 GENERAL FUND 11,219,522 12,259,970 13,862,250 8,675,253 16,481,680 17,307,640 5% ~ " 4 Year Avg Budget Underspend GENERAL FUND 11 MAYOR & COUNCIL 85% 12 CITY ADMINISTRATOR 88% 13 CITY CLERK 91% 15 FINANCE 98% 16 LEGAL COUNSEL 73% 17 COMMUNITY DEVELOPMENT 89% 18 GENERAL GOVERNMENT BUILDI 95% 20 INFORMATION TECHNOLOGY 86% 31 POLICE DEPARTMENT 97% 32 FIRE 98% 33 INSPECTION-BLDG-PLMBG-HTG 100% 41 ENGINEERING 95% 42 STREET MAINTENANCE 90% 44 SHOP 93% 46 PARK MAINTENANCE 93% 65 LIBRARY/CONGREGATE DINING 91 UNALLOCATED 15% 01000 GENERAL FUND 93% . 7 . b Shakopee Assessed Value and Taxes Payable Residential Tax EMV Tax Cap. City City Parcel Year Value Value Tax Rate Tax 27-004147-0 2002/03 126,400 1,264 33.939% 428.99 2003/04 141,600 1,416 32.433% 459.25 2004/05 154,100 1,541 31.115% 479.48 2005/06 177 ,200 1,772 30.922% 547.94 2006/07 182,400 1,824 31.939% 582.57 6% 2007/08 190,600 1,906 31.938% 608.74 4% 27-037013-0 2002/03 146,600 1 ,466 33.939% 497.55 2003/04 164,200 1,642 32.433% 532.55 2004/05 188,800 1,888 31.115% 587.45 2005/06 188,800 1,888 30.922% 583.81 2006/07 199,500 1,995 31.939% 637.18 9% 2007/08 217,100 2,171 31.938% 693.37 9% 27 -015004-0 2002/03 214,900 2,149 33.939% 729.35 2003/04 240,700 2,407 32.433% 780.66 2004/05 276,800 2,768 31.115% 861.26 2005/06 318,300 3,183 30.922% 984.25 2006/07 365,100 3,651 31.939% 1,166.09 18% 2007/08 345,600 3,456 31 .938% 1,103.78 -5% 27 -015006-0 2002/03 255,000 2,550 33.939% 865.44 2003/04 285,600 2,856 32.433% 926.29 2004/05 328,400 3,284 31.115% 1,021.82 2005/06 377,700 3,777 30.922% 1,167.92 2006/07 382,200 3,822 31.939% 1,220.71 5% 2007/08 396,000 3,960 31.938% 1,264.74 4% 27-142014-0 2002/03 471,700 4,717 33.939% 1,600.90 2003/04 513,000 5,163 32.433% 1,674.35 2004/05 513,000 5,163 31.115% 1,606.31 2005/06 513,000 5,163 30.922% 1,596.35 2006/07 590,000 6,125 31.939% 1,956.26 23% 2007/08 587,300 6,091 31.938% 1 ,945.42 -1% g- , t.) Citv of ShakonAI 8/1012007 Pay 07 tax lew nRtn7 n7tnR Genera! Law 11.226.097 13.025.000 1.798.903 16.0% Debt Service 1996A Imp 61 701 91.701 20.000 1997B Imp 29.477 29.477 75.000 1998B Imn 62 597 62.597 62.238 62.238 2000A Imp 55.858 55.858 56.167 56167 2002A Imp 98.569 98 569 95.786 95.786 2004C Imp 146.075 146075 144.965 144 965 2006A Imp 343,026 343.026 345 274 345 274 2007A Imp 8.742 8.742 2007B Imp 2004D PW buildina(buildina fl 469.040 467 649 20048 Fire Referendum 241'\..449 251.752 Total Debt Service R27 303 898 172 70.869 8.6% I I I Certainteed lew for tax abatement 26.000 26.000 0 0.0% Rvan Abatement 44.000 50,000 6.000 13.6% Total Levv 12.479.000 13999172 1,520,172 12.2% Fiscal Disn Dist ~5 8n4\ (1 137205) Net Levy to spread 11,523,196 12,861,967 1,338,771 11. 6% Market Value cut ~ . t~,.-" ;- ^ . . -:.. '. ,"",.,. ._~.'^:; Allowance for Uncoil. 1?4Q 580\ 1?7Q 983\ Budaet Amount 1n 741 7"1 12.050.119 1,308,368 GAneral Fund ( net) 9.854.448 (net) 11.091.947 1.237.499 12.6% EDA - city lew 60 000 60 000 Debt Service 827.303 898.172 70.869 9 LEVY07-08.XLS LEVY07-08 8:50 AM 8/10/2007 c' 0 1 Tax Rate Levy increase SUMMARY GENERAL FUND - 2008 GF Total Revenue per print 15.563.060 Tax Rate Increase N/C Transfer In 1.740,000 Total Revenue & Transfers 17 .303,060 GF Expend per print 17.307.640 Options to cut - Options to add 0 EDA Transfer out 26.000 Recreation Transfer out 1.099.000 Total Expenditures and Transfers 18.432.640 Net surplus (deficit) (1.129,580) FundinQ From Fund Balance 800 MZH 456,000 Carom, Center Painting 0 Carom. Center Parking lot 0 Carom. Center carpet 0 Carom. Center point of sale equip 0 Entrance monument 25,000 4% underspend 692,306 Net surplus (deficit) 43.726 Included in draft budaet Request Cuts Not Included in draft budaet Adds Police officer 64,500 Police officer 64,500 Police officer 64,500 Police - CSO r S 21,500 Fire Chief 100,000 Assistant Fire Chief 80,000 SCBA coordinators 3,500 Fire Dept anniversary 10,000 IT back up plan 56,000 Library noise/solar mitigation 46,000 Recreation Superintendant 92,700 Home Town Messenger 17,000 Green/Energy initiatives 50,000 Fire Station 51 parking lot 15,000 Fire Station 51 concrete apron 50,000 Carom. Center Painting 55,000 Comm. Center Parking lot 25,000 Comm. Center carpet 20,000 Comm. Center point of sale equip 20,400 855,600 - ICJ 8/10/2007 10:44 AM