Loading...
03-683Council File #��� �,p$ 3 GreenSheet# ,��� Presented By: Referred To: Commiftee Dafe: Page � of 18 � z 3 a s a � s 9 �o tt 12 t3 �a 15 t6 n IB 19 20 zt � 23 za zs 26 27 28 29 ao 3I 32 33 3d 35 36 37 38 39 � at az � WHEREAS, the Local Govemment Aid estimate projected for financing the 2003 General Fund budget will be roughly $13 million less than expected; and WHEREAS, The Mayor, according to Cify Cfiarter, Sec. 10.07.3, did notify the City Council of a budget shortfall and recammended adjustments to bring the 2003 budget back into balance; and WHEREAS, the City Council met to review and revise the recommendations, and on February 26, 2003, created and adopted a plan, commonly referred to as Round 1, to return the 2003 butlget into balance; and WHEREAS, the Mayor and City Council recommend that the following butlgets be adjusted; and agree that the following changes in appropriations and financing estimates are su�cient to resolve the projected loss of LGA, and WHEREAS, the Mayor, in accordance with Section 10.07.1, 10.07.3, and 10.07.4 of the city charter, recommends the following changes to the 2003 budget: GENERALFUND Fund Activity Object Description FINANCING Local Government Aid 001 - 00000 - 3401 Use of Fund Balance (2002 Snow Plowing savings) 001 - OD000 - 9830 Interest Revenue 001 - 00000 - 6602 Transfer from Debt Service 001 - 00000 - 7304 CiN Attornev City Attorney - General Operations 001 - 00200 - 7305 Fire Fire Plans and Training 001 - 05100 - 7305 Trensfer from Special Revenue Fund Firefighting and Paremedics 001 - 05'120 - 7305 Trensfer from Special Revenue Fund RESOLUTION SAIMT PAUL, MINNESOTA l� CURRENT AMENDED BUDGET CHANGES BUDGET 76,129,865 (12,951,389) 63,178,476 5,965,198 2,100,000 2,200,000 600,000 0 12,358 10,000 91,437 0 23,200 0 48,140 8,065,198 2,800,000 12,358 101,437 23,200 48,140 Council File # v?j� ��� Green Sheet # RESOLUTION CITY OF SAINT PAUL, MINNESOTA Presented By: Referted To: Committee Date: Page 2 of 18 CURRENT AMENDED Fund Activity Objed Description BUDGET CHANGES BUDGET aa � as a� � as so si sz � � 55 56 s� � sa 60 s� 62 63 64 65 66 67 68 68 �o �� �z 73 74 75 ]6 License Insqections and Environmental Protection 2oning 001 - 00178 - 4080 001 - 00178 - 4111 001 - 00178 - 4113 001 - 00178 - 4301 001 - 00178 - 2468 Police O�ce of the Chief 001 - 04000 - 7305 Transfer from Pawn System Program 001 - 04000 - 7305 Transferfrom LIEP Technoloqv and Manaaement Services Cable Communications 001 - 07121 - 7305 Transfer from Special Revenue Fund Risk Management 001 01370 4399 Services N.O.C. Real Estate Division 001 - 07300 - 7305 Transferfrom Special Revenue Fund GENERAL FUND FINANCING CHANGE SPENDING CitvAttomeYs �ce City Attomey, General Operetions 001 - 00200 - 0111 Full time certified 007 - 00200 - 0114 Full time appointed 001 - 00200 - 0161 Negotiated Increase 00! - 00200 - 0439 Frirtges 001 - 00200 - 0576 Misc. Adjustment 35,897 (35,897) 29,675 (29,675) 3,000 (3,000) 8,816 (8,816) 0 54,000 0 37,579 54,000 1,226,681 0 105,194 30,000 0 0 0 0 54,000 97,579 1,331,875 30,000 26,300 15,965 42,265 (9.856,9Q4) 535,859 2,935,975 103,598 1,053,844 0 (145,257) (25,238) (4,357) (45,707) (8�698) 390,602 2,910,677 99,241 7,008,137 (8,698) Council File # p3" (�� RESOLUTION CITY OF SAINT PAUL, MINNESOTA Presented By: Referred To: Green Sheet # Committee Date: Page 3 of 18 Fund Adivity Object Description ao Citizen Services Office s� 001 - 00250 - az 001 - 00250 - 83 �0� - Q�2$� - sa 001 - 00257 - ss 001 - 00251 - 86 OOY - OO2S2 - s7 001 - 00252 - sa 001 - 00252 - ss 007 - 00256 - ao 001 - 00256 - s� 00� - 00256 - s2 001 - 00257 - 93 001 - 00257 - ea 95 96 97 86 89 100 iot �02 703 toa ms t06 �m 708 IW »o t7t t�z 113 tt4 »s I'I6 tt7 tt8 179 t2o tzt t2z izs tza ,25 0111 0439 0111 0439 0368 0174 0439 0857 0171 0439 0284 0�11 0439 Full time certified Fringe Benefits Full time certified Fringe Benefits Office Supplies-Purchase S[oreroom Full Time Appointed Fringe Benefits DaW Processing Hardware Full time certified Fringe Benefits Rental Data Processing Equipment Full time certified Fringe Benefits Citv Council City Council's General Fund budget 001 - 00001 - 0174 Full Time Appointed 001 - 00001 - 161 Salary Needs 001 - 00001 - 0439 Fringe Benefits Financial Services Financial Services 001 - 001�0 - O7'11 Full-Time Permanent 001 - 00110 - 0161 Negotiated Increases 001 - 00110 - 0439 Fringe Benefits Fire 001 001 001 007 00'I 001 001 001 00'I 001 001 001 001 001 001 001 001 oo� - 05001 - 05001 - 05002 - 05050 - 05050 - 05050 - 05050 - 05100 - OS'102 - 05102 - 05102 - OS'102 - 05102 - 05102 - 05110 - 05110 - 05110 - os��o - 0528 - 0813 - 0256 - 0717 - 0439 - 0299 - 0822 - 0215 - 02�5 - 0111 - 0439 - 0215 - 0349 • 0432 - 011� - 0439 - 0235 - ossa Dept. Head Reimbursement Duplicating Machines Registration Fees local Trades wlo City Benefits Fringe Benefits Other Miscellaneous Services Trucks and Vans Fees - Medical Fees - Medical Full-Time Permanent Fringe Beneflts Fees - Medical Other Equip. Pts Supplies Acc Unemployment Comp Full-Time Permanent Fringe Benefits Type II - Mileage Trensfer to Trust Fund (Uniforms) CURRENT AMENDED BUDGET CHANGES BUDGET 136,'179 64,231 167,622 52,744 1,469 173,663 68,207 13,000 1,017,310 324,047 5,600 154,503 52,593 (45,252) (13,824) (2,219) (678) (452) (18,341) (5,603) (2,817) (68,962) (27,068) (4,595) (25,949) (2,659) 9Q927 50,407 165,403 52,066 7,017 155,322 62,604 '10,183 948,348 302,979 1,005 128,554 49,934 714,554 60,700 475,957 1,068,469 38,279 371,806 1,000 25,955 3,500 165,423 710,317 3,334 ZO 49,829 30,865 63,899 20,107 30,865 '16,748 0 1,084,293 466,435 33,971 11,362 (98,938) 615,616 (6,025) 54,675 (32,067) 443,890 (89,661) 978,808 �z,ns� ss,sos (40,661) 331,145 (700) (9,000) �2�280) (23,516) (����) 5,000 (20,000) (49,829) (2,614) (51,742) (14,568) (2,614) (5,000) '12,142 (21,999) (6,720) (2,500) (500) 300 16,955 1,220 141,907 '103,133 8,334 0 0 28,251 12,157 5,539 28,251 11,748 12,142 1,062,294 459,715 31,471 10,862 Council File # p3- �g3 RESOLUTION CITY OF SAINT PAUL, MINNESOTA Presented By: Referred To: Fund Activity Object DescriptiOn Page 4 of 1S t26 �z� �ze 129 130 131 132 �aa taa �as 136 137 138 138 �� �a� ta2 ta3 �as �u tas �a� tcs 10.9 iso �s� uz i� �sa I55 156 157 �� t59 tso I6t 762 763 �sa 165 768 Pire (continued) 001 - 05120 - 01'I'I 001 - 05120 - 0142 001 - 05120 - 0439 001 - 05120 - 0215 001 - 05120 - 0518 007 - 05120 - 0822 001 - 05121 - 0'111 001 - 05121 - 0439 Generel Government Accounts Executive Administration General Government 001 - 09948 - 0237 Parking Expense 001 - 09080 - 0241 Printing Outside 001 - 09050 - 0565 Transfer to Capital Projects Fund 001 - 09061 - 0548 Council Contingency 001 - 09170 - 0898 Building improvements Full-Time Permanent Mandatory Overtime Fringe Benefits Fees - Medical Mayofs Contingency Trucks and Vans Full-Time Permanent Fringe Benefits CURRENT BUDGET 22,721,505 874,921 7,471,893 11,000 68,000 482,210 98,'186 31,119 Green Sheet # Committee Date: AMENDED CHANGES BUDGET (605,582) (198,026) (228,857) (8,000) {68,000) (194,096) (11,576) (3,455) 125,000 (100,000) 55,000 (30,000) 770,000 (70,000) 136,655 (136,655) 100,000 (4,035) 1,284,737 (126,608) 532,505 (38,499) 53,200 (3,200) Human Resources 001 - 00165 - 0111 Full time certified 001 - 00165 - 0439 Fringe Benefts 001 - 00164 - 0254 Tuition Human Riahts 001 - 00152 - 0111 Full time certi£ed 001 - 00�52 - 0439 Fringe benefits Libraries 001 - 03400 001 - 03400 001 - 03400 001 - 03401 001 - 03402 001 - 03402 007 - 03402 - 0111 - 0167 - 0439 - 0558 - 0111 - 0167 - 0439 Full-Time Permanent Negotiated Increase Fringe BeneFts Transfer to Special Fund Full-Time Permanent Negotiated Increase Fringe Benefits License Inspections antl Environmental Protedion Mimat ConMol 001 - 00177 - 0111 Full time certified 001 - 00�77 - 016� Negotiatedincrease 001 - 00177 - 0439 Fringes 393,384 (27,656) 365,728 163,131 (8,435) 154,696 204,300 9,'192 65,222 400,000 3,762,552 152,504 1,596,888 513,304 16,605 167,020 (46,214) (7,386) (14,542) (100,000) (96,615) (2,898) (30,401) 22,115,923 676,895 7,243,036 3,000 0 288,114 86,610 27,664 25,000 25,000 700,000 0 95,965 1,758,129 494,006 50,000 158,086 7,806 50,680 300,000 3,665,937 '149,606 1,566,487 (38,314) (�>») (12,056) 474,990 15,456 154,964 Council File # � �g,� RESOLUTION CITY OF SAINT PAUL, MINNESOTA Presented By: Referted To: Committee Date: Green Sfieef # Page 5 of 18 787 iss 769 no n� 772 173 na ns 176 tn 176 '179 780 787 �az �a3 tsa �as 186 ta� 186 �as �ao 797 792 �as t94 195 196 197 t98 199 zoo zot zoz 203 zoa zos 206 2m zoa zas z�o zt� ztz Fund Activity Object Description Zoning 001 - OQ9 - 001 - 001 - 007 - 001 - 001 - 001 - 001 - 001 - 007 - 007 - 009 - 001 - 001 - 007 - 001 - 001 - 001 - 001 - 001 - 001 - 007 - oo� - 001 - 001 - 007 - 001 - 00'I - OOT - 001 - 001 - 00'1 - 001 - 001 - 001 - 001 - 00� - 00'I - 001 - 001 - 001 - 001 - 001 - 001 • 00'I7S 00178 00178 00178 00778 00178 00178 00178 00178 00178 00178 00178 00178 00178 00178 00'178 00178 00178 00178 00178 00178 00178 00178 oons 00178 00178 00178 00178 00178 00778 00178 00178 00178 00178 00178 00178 00178 00'178 00178 00178 00178 00178 00178 00178 00'178 - 0� 71 Full time certified - 0733 Interrt • 0141 Overtime • 0161 Negotiated Increase - 0209 Commission Meetings - 0219 Fees - Other Professional Services • 0227 PosWge - 0222 Telephone - Monthly - 0223 Telephone - Long Distance • 0228 Telephone - Cell • 0229 Other-Communication • 0235 Type II - Regular Mileage - 0237 Parking Facpense - 0241 Printing-Outside • 0242 Printing - River Print • 0246 Film Processing - 0251 Transportation - 0252 Lodging-Meals - 0253 Registration Fee - 0255 Dues - 0256 Registration Fee - 0259 Other-Travel - 0260 HR - PR - BA Allocation - 026� Firelnsurance - 0271 Building - Repairs - 0275 Off. Equip Maintenance - 0276 Off. Equipment 8 Furniture Repair - 0279 Other - Repair - 0282 RenWl-Building - 0285 Renfial - Duplicating Equip - 0286 Rental- Other - 0299 Other Misc. - 0349 OtherEquip - 0356 Safety Supplies - 0359 Other Spec Materials - 0361 O�ce Accessories - 0362 PaperSupplies - 0368 OfficeSupplies - 0369 Other O�ce Supplies - 0370 ComputerEquipment - 0381 Books-Periodicals - 0382 Newspapers - 0387 Photo Supplies - 0389 Other - Misc. Supplies - 0439 Fringe Beneflts CURRENT AMENDED BUDGET CHANGES BUDGET 24$�604 2,000 2,000 7,488 3,800 500 2,500 2,500 150 900 100 7,000 200 300 1,200 800 zoo 300 700 300 1,800 100 387 50 275 300 500 200 15,200 1,200 6�0 200 35 200 200 100 600 395 380 5,698 725 '100 300 60 77,813 (245,604) (2,000) (2,000) (7.'F88) (3,800) (500) (2,500) (2,500) (150) (900) (100) n�0�0) (2�0� (300) (1,200) (800) (200) (300) (700} (300) ('1,800) (100) (387) (50) (275) (300) (500) (200) (15,200) (9,200) �6�0� (Z��) (35) (200) (200) (100) (600) (395) (380) (5,698) (�25) (100) (300) (60) (77,813) Council File # �3� �� RESOLUTION CITY OF SAINT PAUL, MINNESOTA Presented By: Referred To: Green Sheet # Committee Date: Page 6 of 18 213 zta z�s NB zn z�a 279 zzo zzt z22 223 zza 2zs 228 zz� zza zza zso 231 232 233 zsa zas 236 237 238 239 zao za� zaz 2as zaa zas zae za7 zas 249 25D 25I 252 153 zsa Fund Activity Object Description MavoYs Office Mayor's Office 001 - 00100 00'I - 00100 001 - 00100 0111 0161 0439 Full time certified Negotiated Increase Fringes Parks & Recreation 001 - 03700 001 - 03700 001 - 03100 001 - 03102 001 - 03103 001 - 03103 001 - 03103 001 - 03103 001 - 03103 001 - 03703 001 - 03103 001 - 03103 001 - 03103 001 - 03103 001 - 03108 001 - 03108 001 - 03122 001 • 03122 001 - 03130 001 - 03132 001 - 03132 001 - 03134 001 - 03170 001 - 03970 001 - 03174 001 - 03174 001 - 03177 001 - 03795 001 - 03195 007 - 03195 - 0117 - 0439 - 0279 • 0299 - 0711 - 0161 - 0439 - 0221 - 0235 - 0247 - 0255 - 0256 - 0299 - 0368 - 0'111 - 0439 - 0111 - 0439 - 0578 - 0111 - 0439 - 0299 - 0111 - 0439 - 0111 - 0439 - 0282 - 0'111 - 0439 - 0279 Pull time certified Fringes Professional Services Other Miscellaneous Services Full time certifed Salary Needs Fringes Postage Mileage Type II - Regular ($Mday+.20) Printing - Outside Dues Registretion Fees - Local Other Miscellaneous Services �ce Supplies - Purchase Storeroom Full time ceAified Fringes Full fime certified Fringes Safery Allocation Full time certified Fringes Other Miscellaneous Services Full time certified Fringes Full time certified Fringes Rental Buildings Full time certified Pringes Professional Services Planninp and Economic Develooment 001 - 06000 - 0219 Feesother professional services 001 - 06000 - 0299 Other misc. services 001 - 06000 - 0545 Contrihution to outside agency CURRENT AMENDED BUDGET CHANGES BUDGET 162,334 43,156 284,270 (86,063) (2,582) (27,081) 76,27� 40,574 257,189 608,421 999,918 53,674 39,968 27,445 823 8,639 1,050 1,200 822 1,319 1,350 1,343 489 286,794 93,034 719,1T9 229,307 30,000 1,068,474 350,592 246,963 2,471,342 1,131,528 98,787 36,446 26,500 997,789 64,163 53,689 90,000 935,861 100,000 (70,003) 51,244 (3,260) (30,000) (27,445) (823) (8,636) (1,050) (1,200) (822} (1,3'19) (1,350) (7,343) (489) (214,901) (65,653) (38,290) (11,698) (15,000) (52,91 � ) (16,164) (16,000) (184,124) (56,251) (64,447) (19,689) (26,500) (731,216) (40,087) (25,000) (75,000) (339,066) (10,000) 538,418 251,162 50,354 9,968 0 0 3 0 0 0 0 0 0 0 71,893 27,381 680,829 217,609 15,000 1,015,563 334,428 230,963 2,287,218 1,075,277 34,340 16,757 0 66,573 24,076 28,689 15,000 596,795 90,000 Council File # O�j - RESOLUTION CITY OF SAINT PAUL, MINNESOTA Presented By: Refertetl To: Green Sheet # Committee Date: Page 7 of 18 zss zss zs� zsa 259 260 26I zsz 263 zsa zss 266 zs� 268 169 270 z» nz 273 z�a z�s 276 zn 278 2�9 zao zai 2ffi zat zea 285 286 2a7 zss 289 zao 29I 282 293 zsa zss 286 297 298 299 300 Fund Adivity Objed Description Police 001 - 001 - 002 - 003 - 004 • 005 - 006 • 007 • 008 • 009 - 010 - 011 - 012 - 013 - 014 - 015 - 016 - 017 - 018 - 019 - 020 - 021 - 022 - 023 - 024 - 025 - 001 - 001 - 001 - 001 - 001 - 001 - 002 - 003 - 004 - 005 - 006 - 007 - 008 - 009 - 010 - 011 - 012 - 013 - 014 - 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04000 04001 04001 04001 04001 04100 04100 04100 04100 04100 04100 04700 04100 04100 04100 04700 04100 04100 04100 04100 - 011'I - 0439 - 0229 - 0237 - 0242 - 0245 - 0246 - 0275 - 0286 - 0289 - 0341 - 0342 - 0359 - 0362 - 0367 - 0370 - 0377 - 0381 - 0383 - 0387 - 0389 • 0393 • 0395 - 0396 - 0398 - 0848 - 0111 - 0439 - 0821 - 0829 - 011'I - 0439 • 0215 - 0219 - 0222 - 0223 - 0225 - 0229 - 0247 - 0242 - 0276 - 0277 - ozss - 0354 - 0356 Full time certified salaries Fringes Other Communications Parking Printing Publications Film Processing Office Equipment Maintenance Other RenWl Miscellaneous Rental Motor Fuel Tires Specialized Material Paper Training Supplies Computer Equipment ' District Heating Books Small Tools Photo Supplies Other Supplies Software Office Equipment Field Equipment Opticom Capitalized Equipment Full time certified salaries Fringes Cars and Motorcycles Other Self propelled Equipment Full time certified salaries Pringes Medical Fees OtherFees Telephone Long DisWnce Fau Other Communications Printing River Print Casts Equipment and Furniture Maintenance Other Maintenance Miscellaneous Rental Law Enforcement Supplies Safety Supplies CURRENT AMENDED BUDGET CHANGES BUDGET 5,252,895 1,670,138 5,493 64 4,519 187 822 3,647 202 21 517 125 4,235 228 295 2.994 3,500 2,173 942 422 984 852 4,322 1,788 4,975 38,739 56,089 17,649 982,099 175,000 24,565,600 7,302,0'12 2,500 25,200 1,600 300 t,600 6�0 500 7,508 3,183 1,160 24,400 17,684 6,100 (287,827) (83,926) (233) (�) (462) (19) (�) (373) (21) (2) (52) (12) (423) (z3) �29) (299) (350) (217) (94) (42) � (85) (432) (179) (�� (3,800) (56,089) (17,135) (877,500) (175,000) (793,781) (215,249) (2,500) (6,000) ('1,600) (300) (1,600) (6�0) (500) (500) (500) ($0�� (24,400) (1,500) (500) 4,965,068 1,586,212 5,260 57 4,057 168 738 3.274 181 19 465 113 3,812 205 266 2,695 3,150 1,956 848 380 886 767 3,890 1,609 4,478 34,939 514 104,599 23,777,819 7,086,763 19,200 1,008 2,683 ss� '16,184 5,600 Council File #�� Presented By: Referred To: Green Sheet # Committee Date: Page 8 of 18 RESOLUTION CITY OF SAINT PAUL, MINNESOTA Fund Activity Objed Description so� Police (continuedl aoz 015 - 04100 aoa 016 - 04100 aoa 017 - 04100 305 ��8 - ��0� 306 ��� - �4��2 ao� 001 - 04102 sos 001 - 04702 aos 001 - 04102 a�o 001 - 04300 stt 001 - 04300 a�z 009 - 04301 a�a 001 - 04301 a�a 001 - 04302 a�s 001 - 04302 3�6 001 - 04308 an 001 - 04308 a�s 001 - 04308 379 �0� - �43�$ 3zo 00� - 04308 a2� 001 - 04308 s2z 001 - 04308 azs 001 - 04308 aza 007 - 04308 azs 001 - 04308 azs 001 - 04340 az7 001 - 04340 azs 001 - 04340 azs 001 - 04340 �0 001 - 04340 aa� 001 - 04340 �z 001 - 04340 3s3 001 - 04340 ssa 001 - 04340 aas 00� - 04340 336 UU1 - U4340 a37 001 - 04340 �s 001 - 04340 aaa 001 - 04340 �to 001 - 04340 aa7 001 - 04340 aaz 001 - 04340 3n3 001 - 04340 saa 001 - 04340 3ns 001 - 04340 sas 001 - 04340 - 0359 - 0369 - 0381 - 0383 - 0111 - 0131 - 0439 - 0821 - 0111 - 0439 - 0'111 - 0439 - o�a� - 0439 - 0275 - 0282 - 0292 - ��99 • 0347 - 0349 - 0367 - 0370 - 0380 - 0393 - 0'111 - 0439 - 0219 - 0270 - 0271 - 0273 - 0274 - 0277 - 0279 - 0291 • 0292 - 0293 - 0294 - 0297 - 0299 - 0311 - 0312 - 0373 - 0314 - 0315 - 0316 Specialized Material Other office Supplies Books Small Tools Full time certified salaries certified salaries - 7emporary Fringes Cars and Motorcycles Full time certified salaries Pringes Full time certified salaries Fringes Overtime Salaries Fringes O�ce Equipment Maintenance Building RenWl Laundry Other Services Radio Supplies Other Equipment Treining Supplies Computer Equipment Communications Equipment Software Full time certified salaries Pringes Otherfees Elevator Maintenance Building Repair Grounds Maintenance Self Propelled Equipment Other Equipment Maintenance Other Repair Refuse Disposal Laundry SewerCharges Testing Services Data Processing Services Other Services Plumbing Supplies Eledric Supplies Lumber Paint Janitor Suppties Glass CURRENT BUDGET 14,200 6,140 100 400 138,220 '145,706 58,810 21,684 294,521 118,697 902.444 285,153 76,490 1,064,111 5,498 12,000 650 1,700 120,000 10,000 1,'100 4,000 40,640 2,000 447,587 150,982 7,500 5,000 6,295 500 500 4,000 25,000 9,915 6,000 7,000 1,000 6,000 6,500 647 6,833 1,000 2,476 '19,000 1,000 CHANGES (8,500) (300) (100) (100) (99,926) (145,106) (25,111) (21,684) (69,907) (19,893) (143,346) (43,792) (34,624) (5,376) (554) (1,210) (65) (171) (71,950) (996) (1'10) (398) (4,047) (199) (40,500) (12,373) (249) (499) (628) (50) (50) (399) (2,494) (989) (598) (698) (100) (598) ��) (65) (683) (100) (247) (1,898) (100) AMENDED BUDGET 5,700 5,840 300 38,294 33,699 224,614 98,804 759,098 241,361 41,866 1,058,735 4,944 10,790 585 1,529 108,050 9,004 990 3,602 36,593 1,801 407,087 738,609 7,251 4,501 5,667 450 450 3,601 22,506 8,926 5,402 6,302 900 5,402 5,852 582 6,150 900 2.229 17,102 900 Council File # 63_ (�g3 RESOLUTION CITY OF SAINT PAUL, MINNESOTA Presented By. Referred To: Green Sheet# Committee Date: Fund Activity Object Description yn aas sas 350 351 352 asa ssa 355 asc 357 356 ass 360 36I 362 363 364 365 366 367 368 369 a�o a�� 372 a�a 374 375 376 377 378 379 380 38t 382 383 aaa 385 386 387 aea asa Police (continuedl 001 - 04340 001 - 04340 001 - 04340 00'I - 04340 001 - 04340 001 - 04340 001 - 04340 001 - 04340 001 - 04340 001 - 04340 001 - 04340 001 • 04340 001 - 04340 001 - 04340 001 - 04340 007 - 04340 001 - 04340 001 - 04342 00'I - 04342 00! - 04342 001 - 04342 001 - 04342 001 - 04342 001 - 04342 - 0317 - 0319 - 0321 - 0337 - 0344 - 0349 - 0356 - 0359 - 0368 - 0369 - 037'I - 0373 - 0376 - 0377 - 0383 - 0389 - 0394 - 0222 - 0223 - 0227 - 0229 - 0282 - 0377 - 0380 Hardware Other Repair Supplies Horticulture Plant Material Signing Material Parts For Vehicles OtherParts Safety Supplies Specialized Material O�ce Supplies Other office Supplies Electricity Gas Water District Heating Small Tools Other Supplies Office Furniture Telephone Long Distance Data 7elephone Service Other Communications Building Rental Electricity Communication Supplies Public Works Personnel and Clerical 001 - 02025 - 0268 Management and Admin Services Traffic Calming 001 - 02157 - 0337 Signing Materials Traffic Maintenance 001 - 02281 - 0279 Other • Repair & Maintenance 001 • 02281 - 0576 Round I& II Adjustments Signal Operetions 8 Maintenance 001 - 02282 - 0279 Other - Repair & Maintenance Lighting Operations & Maintenance 001 - 02283 - 0279 Other - Repair & Maintenance 00� - 02283 - 0576 Round I& II Adjustments Page 9 of � 8 CURRENT AMENDED BUDGET CHANGES BUDGET 2,716 2,000 747 1,000 500 773 500 11,412 300 600 160,295 12,450 5,500 9�,a00 500 4,000 14,200 56,000 12,000 204,400 30,000 7,000 '1,583 30,000 (271) (200) (75) (100) (50) (57) (50) (14�) (30) (60) (16,017) (�,Z�) (550) (8,993) (50) (400) (1,479) (3,667) (786) (13,383) ��. (458) (155) (2,945) 2,445 1,800 672 9�� 450 7'I6 450 11,271 2�0 540 744,278 11,206 4,950 81,007 450 3,600 12,781 52,333 11,214 191,017 28,036 6,542 1,428 27,055 117,280 (8,500) 51,363 (51,043) 465,001 (277,000) 0 (40,000) 556,967 (175,000) 2,031,999 (341,000) 0 ('160,000) 108,780 320 248,001 (40,000) 381,961 1,690,999 ('I60,000) Council File # p3-1��3 Green Sheet # RESOLUTION CITY OF SAINT PAUL, MINNESOTA Presented By: Referted To: Committee Date: Page 70 of �8 CURRENT AMENDED Fund Aetivity Object Description BUDGET CHANGES BUDGET aso Public Works (Continuedl ae� Tra�c Lighting and Signals asz 001 - 02280 - 0111 Full time certified asa 001 - 02280 - 076� Negotiatedlncrease asa 001 - 02280 - 0439 Fringes 3ss 00'I - 02280 - 0371 Eledriciry 396 as� Technolom and Manaaement Services asa Administretion ass 001 - 01001 - 0111 Full time ceAified aoo 001 - 01001 - 0439 Fringe benefits ao� aoz Contracts and Malysis Services aoa 001 - 01250 - 0299 Other miscellaneous services aoa aas Information Services aos 001 - 01115 - 0111 Full time certi£ed qo7 001 - 01115 - 0122 Part time not certified aos 001 - 01115 - 0283 Rental of vehicles aos 001 - 011�5 - 0439 Fringe beneflts ato 001 • 01119 - 0256 Registration fees-lowl at� 00'I - 01119 - 0285 Rental of duplicating equipment m2 ms Real Estate a�a 001 - 01340 - 0211 Feesarchitect 475 476 Risk Management ai� 001 - 01370 - 0111 Full time certified a�e 001 - 01370 - 0219 Feesother professional services ats 001 - 01370 - 0439 Fringe beneflts azo azt GENERAL FUND SPENDING CHANGE azz SPECIAL FUNDS azs azn Fire azs FItJANClNG azs No Change for Fund 510 427 16,344 (16,344) 490 (490) 5,143 (5,143) 1,234,773 (3'I,000) 86,551 (34,470) 59,114 (10,530) 0 0 0 1,203,773 52,081 48,5&4 470,242 (40,000) 430,242 2,674,291 (147,837) 22,922 (11,077) 9,050 (8,840) 893,025 (45,051) 11,500 (11,500) 313,474 (10,984) 114,576 (39,000) 2,532,454 11,845 210 847,974 302,490 75,576 594,786 (47,838) 546,948 13,800 35,453 49,253 988,926 (14,615) 174,311 (9,856,904) a2a SPENDING azs 510 - 35117 - 0367 Training or Instructional Supplies 23,200 (23,200) 0 aso 5'10 • 35117 - 0557 Trensfer to General Fund 0 23,200 23,200 q3� FUND SPENDING TOTAL 0 0 23,200 Council File # D3- (�q3 Presented By: Referred To: Fund Activity Object Description RESOLUTION CITY OF SAINT PAUL, MINNESOTA Page 77 of 78 a3z 433 aaa ass a3a �� asa nae aao 4at aa2 aaa aaa a45 aas at7 aaa aas aso u� nsz 453 nsa 455 456 �� 45a 459 460 ast A62 asa a54 4ss 466 ac� G68 469 a�o 4]1 an ms a�a a75 a�s Fire (wntinued) FINANCING No Change for Fund 735 Committee Date: CURRENT AMENDED BUDGET CHANGES BUDGET Green Sheet # SPENDING 735 - 55001 - 0822 Trucks and Vans 540,904 (48,140) 492,764 735 - 55001 - 0557 Transferto GenerelFund 0 48,140 48,140 FUND SPENDING TOTAL 0 0 48,'140 Libreries FINANCING 349 - 33422 - 7299 Trensfer from General Fund 400,000 (100,000) 300,000 349 - 33422 - All Other Financing 403,538 0 403,538 FUND FINANCING TOTAL 803,538 (100,000) 703,538 SPENDING 349 - 33422 - 0381 Books Periodicals Pictures 650,000 (100,000) 550,000 349 - 33422 - AIIOtherSpending 153,538 0 153,538 FUND SPENDING TOTAL 803,538 (100,000) 703,538 License Insoections and EnvironmenWl Protection License Inspeetions and Environmental Protection Fund FINANCING 320 - 33351 - 9830 Use of Fund Balance 320 - 33353 - 9830 Use of Fund Balance 320 - 33355 - 4080 Zoning Appeals 320 - 33355 - 4111 Examination Fee - M- Other Fuels 320 - 33355 - 4113 ExaminationFee-J-CM 320 - 33355 - 4301 Normal Activity Services FUND FINANCING TOTAL SPENDING 320 - 33357 - 0111 320 - 33351 - 0117 320 - 33351 - 0'I61 320 - 33357 - 0439 320 - 33351 - 0557 320 - 3335'I - 0373 320 - 33353 - 0111 320 - 33353 - 016'I 320 - 33353 - 0439 320 - 33353 - 0557 320 - 33355 - 0111 320 - 33355 - 0133 320 - 33355 - 0141 320 - 33355 - 0167 320 - 33355 - 0209 Full time certified Trades w/o City Benefits Negotiated Increase Fringes Transfer to Generel Fund Gas including 6ottle Full time certified Negotiated Increase Fringes Trensfer to General Fund Full time certifled Infern Overtime Negotiated Increase Commission Meetings 0 474,409 474,409 44,161 (8,425) 35,736 0 35,897 35,897 0 29,675 29,675 0 3,000 3,000 0 8,8'I6 8,816 44,161 543,372 587,533 1,342,993 2,336,399 166,814 1,220,036 0 0 1,289,622 44,297 434,558 33,865 0 0 0 0 0 (96,741) (132,087) (9,586) (72,836) 91,437 75,000 (46,424) ('1,393) (14,608) 54,000 245,604 2,000 2,000 7,488 3,800 1,246,252 2,204,312 757,228 1,147,200 91,437 �$�0�0 1,243,198 42,904 419,950 87,865 245,604 2,000 2,000 7,488 3,800 Council File #�� RESOLUTION CITY OF SAINT PAUL, MINNESOTA Presented By. Referred To: Green Sheet # Committee Date: Page 12 of 18 an a�s 478 aao 487 4a2 483 asa aas 4as w� aae 489 aso 491 482 493 asa 495 496 497 496 499 soo so� 502 503 soa 505 506 507 soa 509 510 577 512 5'13 s�a 5�5 516 sn s�a 579 szo �i 522 Fund Activity Object Deseription License Insoections and EnvironmenWl Protection (continuedl 320 - 33355 - 0219 Fees - Other Professional Services 320 • 33355 - 0221 Postage 320 - 33355 - 0222 Telephone - Monthly 320 - 33355 - 0223 Telephone - Long DisWnce 320 - 33355 - 0228 Telephone-Cell 320 - 33355 - 0229 O[her-Communication 320 - 33355 - 0235 Type II - Regular Mileage 320 - 33355 - 0237 Parking Expense 320 - 33355 - 0241 Printing-Outside 320 - 33355 - 0242 Printing - River Print 320 - 33355 - 0246 Film Processing 320 - 33355 - 0251 Transportation 320 - 33355 - 0252 Lodging - Meals 320 - 33355 - 0253 Registration Fee 320 - 33355 - 0255 Dues 320 - 33355 - 0256 Registration Fee 320 • 33355 - 0259 Other - Trevel 320 - 33355 - 0260 HR-PR-BAAllocation 320 - 33355 - 0261 Fire Insurance 320 - 33355 - 0271 Building - Repairs 320 - 33355 - 0275 Off.Equip Maintenance 320 - 33355 - 0276 Off. Equipment & Furniture Repair 320 - 33355 - 0279 Other- Repair 320 - 33355 - 0282 RenWl-Building 320 - 33355 - 0285 RenWl • Duplicating Equip 320 - 33355 - 0286 RenWl- Other 320 - 33355 - 0299 Other Misc. 320 • 33355 - 0349 Other Equip 320 - 33355 - 0356 SafetySupplies 320 - 33355 - 0359 Other Spec Materials 320 - 33355 - 0361 �ce Accessories 320 - 33355 - 0362 PaperSupplies License Insoections and EnvironmenWl Protection License Inspections and EnvironmenWl Protection Fund SPENDING 320 - 33355 - 0368 O�ce Supplies 320 - 33355 - 0369 Other Office Supplies 320 - 33355 - 0370 Computer Equipment 320 - 33355 - 0381 Books - Periodicals 320 - 33355 - 0382 Newspapers 320 - 33355 - 0387 Photo Supplies 320 - 33355 - 0389 Other-Misc.Supplies 320 • 33355 - 0439 Fringe Benefits FUND SPENDING TOTAL CURRENT AMENDED BUDGET CHANGES BUDGET 500 2,500 2,500 150 900 100 7.000 200 300 1,200 S00 200 300 700 300 1,800 100 387 50 275 300 500 20� 15,200 '1,200 600 200 35 200 200 100 600 0 0 0 0 0 0 U 0 1,802,342 395 380 5,698 125 '100 300 60 77,813 543,372 500 2,500 2,500 150 900 100 7,000 200 300 1,200 S00 200 300 700 300 1,800 ��� 387 50 275 300 500 200 15,200 1,200 600 2�� 35 200 2�� 100 600 395 380 5,698 125 100 300 60 77,813 2,345,7'14 Council File # D3 -1��3 Presented By. Referred To: RESOLUTION CITY OF SAINT PAUL, MINNESOTA Green Sheet # Committee Date: Page �3 of 18 523 52a szs 526 sz� 528 528 sao sat 532 s� 536 s3s s3s 537 538 539 sao �� saz saa saa sas 545 547 Sd6 sas ssa 551 552 553 554 sss 556 ss� sse ssa seo ss� CURRENT AMENDED Fund Activity Object Description BUDGET CHANGES BUDGET Parks and Recreation FINANCING Como Campus Fund 380 - 33139 - 7305 Transfer from Special Revenue Fund 102,308 0 102,308 380 - 33139 - 6927 Other pgency Share of Cost 0 50,000 50,000 FUND FINANCING TOTAL 102,308 50,000 152,308 SPENDING Como Campus Fund 380 - 33139 - 0111 Full time certified 75,707 38,300 114,007 380 - 33139 - 0439 Fringe Benefits 23,823 11,700 35,523 380 - 33139 - AII OtY 2,778 0 2,778 FUND SPENDING TOTAL 102,308 50,000 152,308 Planninq and Economic Development PED Operations Fund FINANCING 126 - 36075 - 4399 Services N.O.C. 8,772,342 (339,066) 8,433,276 FUND FINANCING TOTAL 8,772,342 (339,066) 8,433,276 SPENDING 126 - 36075 - 0111 Full time ceRified 5,264,399 (259,721) 5,004,678 126 - 36075 - 0439 Fringe benefits 1,823,297 (79,345) 1,743,952 FUND SPENDING TOTAL 7,087,696 (339,066) 6,748,630 PO�IC2 Police Special Projects Fund FINANCING 436 - 34120 - 9830 Special Investigations, fund balance 0 53,�00 53,100 FUND FINANCING TOTAL 0 53,100 53,'100 SPENDING 436 - 34119 - 011'I 436 - 34119 - 0439 436 - 34119 - 0557 436 - 34�20 - 0111 436 - 34120 - 0439 Pawn System, Certified Salaries 29,510 (28,785) 725 Pawn System, Fringes 9,015 (8,794) 221 Pawn System, Transfer to the general fund 0 37,579 37,579 Special Investigations, Certified Salaries 0 4Q674 40,674 Special Investigations, Fringes 0 12,426 12,426 FUND SPENDING TOTAL 38,525 53,100 9'1,625 Council File # �'� (�g3 RESOLUTION CITY OF SAINT PAUL, MINNESOTA Presented By: Referred To: Fund Activity Objed Description Page 14 of 18 562 563 sea sss sea �� ssa 569 s�a s» 572 573 s�a 575 576 577 s7s s7s 580 581 ssz sea ssa 565 586 587 5es 589 590 sai 592 593 55a 595 596 597 ssa 599 600 607 eoz 603 604 Public Warks FINANCING CapiWl Forecasting and Progremming 205 - 12�10 - 7302 TrensferfromEnterpriseFUnd 205 12110 9925 Use of ReWined Earnings 205 - 12110 - All Other Financing FUND FINANCING TOTAL FINANCING Street Repair and Cleaning Administration 225 42310 3403 MunicipalSWteAid 225 42310 7302 Transfer from Enterprise Fund 225 42310 9830 Use of Fund Balance 225 - 42310 - All Other Financing , FUND FINANCING TOTAL Green Sheet# Committee Date: CURRENT AMENDED BUDGET CHANGES BUDGET 47,710 (47,710) 0 0 47,710 47,710 0 0 0 47,770 0 47,710 2,775,000 (200,000) 2,575,000 156,829 (156,829) 0 2,329,549 362,025 2,691,574 9,053,606 0 9,053,606 74,314,984 5,196 14,320,180 FINANCING Rightof-Way 225 42350 7302 Trensfer from Enterprise Fund 5,796 (5,796) 0 225 - 42350 - All Other Financing 1,990,027 0 1,990,027 FUND FINANCING TOTAL 1,995,223 (5,196) 1,990,027 FINANCING Lighting Maintenance Assessment Districts 231 32320 7302 Transfer from Enterprise Fund 918 (918) 0 231 32320 9830 Use of Fund Balance 4,894 978 5,812 231 - 32320 - All Other Financing 129,584 0 '129,584 FUND FINANCING TOTAL 135,396 0 135,396 FINANCING Solid Waste and Recycling 232 32407 7302 7ransferfrom Enterprise Fund 232 32401 9830 Use of Fund Balance 232 - 32401 - All Other Financing FUND FINANCING TOTAL FINANCING Traffic Maintenance Prqects 240 - 12005 - 3403 Municipal State Aid 240 - 12005 - 9925 Use of ReWined Earnings 240 12005 7302 Transfer from Enterprise Fund 240 - 12005 - All O[her Financing FUND FINANCING TOTAL 5,488 (5,488) 0 726,560 5,488 132,048 2,538,928 0 2,538,928 2,670,976 0 2,670,976 250,488 200,000 450,488 236,409 (188,906) 47,503 11,094 ('I'1,094) 0 7,303,033 0 1,303,033 1,801,024 0 1,801,024 Council File # O � ��� RESOLUTION CITY OF SAINT PAUL, MINNESOTA Presented By. Referted To: Green Sheet # Committee Date: Page 75 of 18 605 606 607 608 609 610 671 6t2 813 674 875 816 617 676 619 620 627 822 623 624 625 626 627 628 629 630 631 632 633 s3a sas 636 637 638 638 eao Fund Activity Object Description Public Works (continued) FINANCING Asphalt Plant 245 - 1220'I - 7302 Trensfer from Enterprise Fund 245 12201 9925 Use of ReWined Earnings 245 - 12201 - All Other Financing FUND FINANCING TOTAL FINANCING Equipment Services 250 - 12202 - 7302 Transfer from Enterprise Fund 250 12202 9925 Use of Retained Eamings 250 - 12202 - All Other Financing FUND FINANCING TOTAL FINANCING Director's Office 255 - 12300 - 7302 Trensfer from Enterprise Fund 255 12300 9925 Use of Retained Earnings 255 - 12300 - NI Other Financing FUND FINANCING TOTAL FINANCING Public Information 255 - 12304 255 - 12304 SPENDING Public Information 255 - 72304 255 - 12304 255 - 12304 255 - 12304 CURRENT AMENDED BUDGET CHANGES BUDGET 11,102 (11,102) 0 0 11,102 11,102 2,531,121 0 2,531,121 2,542,223 0 2,542,223 10,361 (10,361) 0 188,952 70,36t 199,313 3,292,179 0 3,292,179 3,491,492 0 3,499,492 1,302 8,100 383,725 393,127 ('I,302) 0 1,302 9,402 0 383,725 0 393,127 - 4301 NormalActivityServices 97,033 (85,923) 11,110 - All Other Financing 0 0 0 FUND FINANCING TOTAL 97,033 (85,923) 1�,110 - 0111 Full time certified 63,899 (63,899) 0 - 0161 Negotiated Increase 1,917 (1,917) 0 - 0439 Fringe Benefits 20,107 (20,107) 0 - All Off 0 0 FUND SPENDING TOTAL 85,923 (85,923) 0 Council File # ��� �g3 RESOLUTION CITY OF SAINT PAUL, MINNESOTA Presented By. Referred To: CURRENT AMENDED Fund Activity Objed Description BUDGET CHANGES BUDGET Page'16 of18 sst snz sas saa sas sas �� sna sas 650 657 652 653 654 655 656 657 6u9 659 660 661 662 683 664 665 666 667 688 668 s�o s�i 672 673 674 675 676 sn 678 679 660 Public Works (continued) FINANCING Major Sewer Service Obligations 260 22200 9925 Use of ReWined Earnings 8,934,045 (250,000) 8,684,045 260 - 22200 - All Other Financing 29,661,917 0 29,661,917 FUND FtNANCtNG TOTAL 38,595,962 (25Q000) 38,345,962 Green Sheet # Committee Date: SPENDING Diredors Office 260 - 22200 - 0558 Trensfer to Special Revenue Fund 260 - 22200 • 0567 Transfer to Internal Service Fund 26� - Y1200 - A�I Ofl FUND SPENDING TOTAL Technoloavand ManapementServices Cable Communications Special Revenue Pund SPENDING 166 - 31121 166 - 31121 766 - 31121 166 - 3'1121 766 - 31121 166 - 31'121 166 - 31121 166 - 31121 766 - 31121 766 - 31124 - 0'111 - 0114 - 0216 - 0219 - 0252 - 0253 - 0439 - 0557 - 0852 - 0852 Full time certified Full time appointed Feesaccounting and auditing Feesother professional services Lodging-meals�tc. Registration fees Fringe bene£ts Transfer to General Fund Communications equipment over $5,000 Communications equipment over $5,000 FUND SPENDING TOTAL '168,431 (168,431) 0 81,569 (S'1,569) 0 0 � 250,000 (250,000) 0 331,554 (29,621) 301,933 8,870 (8.870) " $���0 (8�000) - 30,000 (12,000) 18,000 3,600 (825) 2,775 2,000 (825) 1,175 128,862 (11,553) 117,309 1, 300, 741 7 05,194 1,405,935 25,000 (7,500) 17,500 26,000 (26,000) 1,864,627 - 1,864�627 Contrects and Malysis Services Fund FINANCING 124 - 11250 - 4301 Normal activity services 848,290 (40,000) 808,290 FUND FINANCING TOTAL 848,290 (40,000) 808,290 SPENDING 124 - 1'1250 124 - 11250 - 0111 Full time certifled 576,761 (30,640) 546,721 - U439 Fringebenefits 181,486 (9,360) 172,�26 FUND SPENDING TOTAL 758,247 (40,000) 718,247 Council File # 03 Presented By. Referred To: CURRENT AMENDED Fund Activity Object Description BUDGET CHANGES BUDGET Green Sheet# Committee Date: Page �7 of �8 687 682 683 684 ses 886 687 ses 689 690 697 692 693 694 695 696 697 698 689 �oo �m �oz �os �� �os �oe �o� 708 �os �to 71t 772 773 »a 715 776 777 7�a 779 720 �z� Technoloqv and Manaqement Services (continued) Ciry-Wide DaW Processing Fund FINANCING 626 - 31115 - 430'I Normalactivityservices 7,024,173 62,718 1,086,891 FUND FINANCING TOTAL 1,024,173 62,718 1,086,891 SPENDING 626 - 31115 - 01'11 Full time certified 740,754 48,041 788,795 626 - 31115 - 0439 Fringe benefits 239,458 14,677 254,�35 FUND SPENDING TOTAL 980,212 62,718 1,042,930 Real EsWte Management Fund FINANCING 760 - 71040 - 7299 Transfer from General Fund 114,576 (39,000) 75,576 FUND FINANCING TOTAL 1�4,576 (39,000) 75,576 SPENDING 160 - 11040 - 0111 Full time certified 310,551 (29,874) 280,677 160 - 11040 - 0439 Fringe benefits 110,795 (9,126) 101,669 FUND SPENDING TOTAL 427,346 (39,000) 382,346 TMS Special Projects Fund FINANCING '165 - 31161 - 9830 Use of fund balance 20,000 (7,101) 18,899 FUND PINANCING TOTAL 20,000 (1,101) 18,899 SPEN�ING 165 - 31161 165 - 31161 165 - 3N61 165 - 31161 Debt FINANCING 960 - 89996 RESOLUTION CITY OF SAINT PAUL, MINNESOTA 0219 Feesother professional services 12,000 (12,000) - 025'I Transportation 8,000 (8,000) - 0299 Other-miscellaneous 0 2,934 2,934 0557 Transfer to General Fund 0 15,965 15,965 FUND SPENDING TOTAL 20,000 ('1,101) 18,899 1397 GEFF Des/District Heating 828,000 12,358 840,358 FUND FINANCING TOTAL 828,000 12,358 840,358 SPENDING 860 - 89955 - 0557 Transfer to General Fund 0 12,358 12,358 FUND SPENDING TOTAL - 12,358 '12,358 Council File # O3-t�,�3 RESOLUTION CITY OF SAINT PAUL, MINNESOTA Presented By: Referred To: Green Sheet # Committee Date: Page 78 of 18 �zz Therefore, be it RESOLVED, that the City Council approves the amended budgets as indicated above, and adopts the �za revisions to the 2003 budget. Adopted by Council: Date Adoption Certifled by Council Secretary: By: Approved By: Requested by Department of: Administration - Financial Services By: Matt Smith Approval Recommended by Director of Financial Services: By: � Form Approved by City Attomey: � a3�3 Green Sheet Green Sheet Green Sheet Green Sheet Green Sheet Green Sheet FS - Financial Services Contact Person 8 Phone: MaC Smith 266 5796 Must Be on Council Agenda by (Date): t3JUN-03 I Green Sheet NO: 3001464 � ueoartmefrc 5ent � o verson 0 ivaucial Seryices Assign 1 ioancialServices Deoartmen[Direcror I Numbe� Z inaocial rvices Ofti Financial rvi Por Routing 3 'tv Attornev i piyJe� 4 or's Office M or/Assistant 5 ouocil i Council 6 ' Clerk lerk Total # of Signature Pages _(Clip All Locations for SignaWre) Action Requested: Approval of the attached 2003 mid-year budget admusbnent resolufion for Round 1 of the Local Govemment Aid Budget adjustment. itlations: Approve (A) or R Planning Commission CIB Committee Civil Service Commission Personal Service Contrects Must Answer the Following Questions: 1. Has this person/firm ever worked under a contraci for this department? Yes No 2. Has this personffirm ever been a city employee? Yes No 3. Does this person/fircn possess a skill not normally possessed by any current city employee? Yes No Explain all yes answers on separete sheet and attach to green sheet Initiating Problem, Issues, Opportunity (Who, What, When, Where, Why): The Mayor must recommend adjustments to bring the budget into balance if a shortFall is expected. The City Council adopted the plan to implement Round I of the Local Govemement Aid adjustment on February 26, 2003. AdvantaaeslfApproved: The Commcil-adopted plan will be implemented, and ffie 2003 budget for the City of Saint Paul will be balanced once again. Disadvantages If Approved: None. JUL 0?�2�J03 � v' Disadvanta9es If Not Approved: The 2003 budget will not balance. Transaetion: -9990446 Funding Source: V8fi0US Financial Information: Genenl Fund ($9,856,904) (expiain) Special Funds ($133,542) Capibl Projects Funds $0 CosURevenue Budgeted: Activity Number: V8fI0US Total ($9,990,446) d�_��.� City of Saint Paul Interdepartmental Memorandum To: Council President Dan Bostrom Couaciluzember Jay Benaaav Councilruember Pat Harris Councilmember Jerry Blakey Councilmember Kathy Lantry Councilmember Chris Coleman Councilmember Jim Reiter From: Matt Smitly d�� Date: July 15, 2003 Subject: Round I and Round II Budget Adjustment Resolutions On the agenda for the JuIy 16 City Council meeting are resolutions number 03-682 and 03-683, implementing mid-yeaz adjushnents to the adopted 2003 budget in response to reductions in state Local Govemment Aid (LGA) payments to the City in 2003 and in 2004. Attached to this memo aze smmnary tables reconciling the adopted Council resolutions authorizing the budget adjustrnents ("Round 1," Council File 03-212, adopted 2/26/03; and "Round 2," Council File 03-375, adopted 4J16/03) with the budget changes implemented in the current resolutions. Table 1 shows the overall reduction in 2003 spending levels for each department compared against the originaily-adopted budget. The overall effect of the resolutions is to reduce 2003 General Fund spending by $10,581,412 from the originally-adopted levet (a reduction of 6.03%). Financing into the General Fund is also increased by $2,193,288. Combining the reduction an General Fuud spending and the increase in General Fund fmancing with a net use of the Generai Fund's fund balance in the aznount of $2'72,999 completely covers the total reduction in the Caty's 2003 LGA payment ($13,047,699). The budget amendment resolutions now before the Council differ only slightly from the specific plans adopted with the eazlier resolufions. The only variance between the plan and the actuai budget amendments is $18,234 in Library savings that could not be realized because the retirement-based savings from two positions will not be available until later this year instead of July 1 as the earlier plans had envisioned. The Coaaatcil's adopteQ bau3get adjashnent resalutions from earlier this yeaz will also have a coniina�ing impact on City departinen# spending levels for the 2004 budget, as the intent was camed tt�rough in prepazation of deparhnental base budgets. The total reduction in base General Fund spending leveis for 2004 resulting from the budget adjustment resolutions is estimated at $10.8 million, and increased financing to the General Fund in the amount of $2.7 million is also forecast in 2004 as a result of the 2003 mid-yeaz adjustments. In addition, changes in use of Neighborhood STAR and other revenues will provide at least $5.4 million in additional debt service financing for 2004. Round I and Round II Budget Adjushnent Resolutions July 15, 2003 Page 2 Thus, the total positive impact on the 2004 budget from the mid-year adjustments to the 2003 budget is projected at $18.9 million. This compares to an enacted reduction in 2004 state LGA of $i9_6 million reiative to the origina12003 budgeted level. I hope this information is helpfui as you consider the iwo budget adjustment resolutions before you. Feel free to contact me or members of our staff if you have any qnestions or require additional information. cc: Mayor Randy Kelly Dennis Flaherty Deparhnent and Office Directors Greg Biees G:�Shared�0 F S\Budget Amendmenis�Resolution-Rds 1&2 Memo.wpd d .c E } �1 � M � W � � 7 LL Q L � � V N � C O .� � � � CL .fl d N 7 � Q M � N N y � L c � �a � r y � � � 7 Q d' j L o ?� i Q Q N � C 3 � .��.,��.�.�,...�, 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 CO N M 6) V 07 N W o7 f0 O N O O) N M c- � f� N V O lC) O 1� I� N M 1� h T M O co o r� oi �n � v n n cri ui ri �ri ri M ui co � � � � . t� O O) V 07 W o� O N N O t0 (O N N t� V' � O 6) h O h N N 1� � O) !� O N O O c�J [O P7 � � N O CO N O(O lfl i� V CD 1� N h o� (6 W 1fJ lfJ N � tfJ � t7 N N I� c'� V o] 1� oJ O� h N tn V cC (O N O tfJ o c� o co u� n ti ca M N �n <<n co m w m N r N c+i '7 c�7 c0 u7 � v Ci c0 V c� <- �n m co 00000rn nvrnc%��n o�m o�noo�o rn��nrnv oc+>o O O� 01 m � M V f: N!� � W�C1 V� h I� t� N (O � N 0� � d' �. .�..� c..�.tn `-'N � V N � � � O fD u7 � 1� W h W� O f� CO (D f0 (O O n O O M a�D N V N LL�'J � O W N O � C M� M M(�O (`�') N N � C�� O N N 3 � �.�..v�� O O vM �� �Q v �i \/ \' �/ � LL V/ �/ �r• C U N .� a � 0 Q = O � Q \° \ � \ \° \ \ \ \° \ \ \ \ \ \ \ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N � N V � � � N W t m � � � � ` �- O•- O N O N N M M N<O N f0 O V �- M N I p � � � � \ O O O O 1� CO CO O t0 t0 V c�] � N N N� N�M,� O fh (D CO M N(h (O V' t� 0� a- N O) (D ,fJ V O o� O) � c0 V O� M O O N N I� N N f� eY m N W W th M M� O) N O W 6] (O O m OJ 1f7 V� 1� V' (+7 � M N S`J N I� I� N O N 0� N f� �fJ N� N � d' N� N c�7 �-- ln M tD tO N � I� �.- f� � N � lq � h c 0 0 � 0 a` � N y Q7 U � E Z °' d ° � o y C C d C N � � � C � ry� � U � � � V Q � V N U � c � y o � o y o E U � U N'6 (p T V C N c W (�j �C ..y. � p_ U (6 N � � "6 � � � � � � � � 0 N � � O V O V�� N y C O� NS y C � R c6 (6 C C U y ' N N j �. I � � N O N U 9� � U �� � O @ C � 7 V U) 7 (p � O �- � d c) � i� ___, ¢ c) i- a a � a'u, a c7 N O U 7 N N � C N � � 2 0 C N � N N � N � Y N � � 3 -6 �.� 2003 Budget Round i and 2 Reduction Scenario Plan by Department nnd Office - Adjusted Round � �__ "� ._a '" ��.'�'3". �<. ,,. -+.. _ , �.� --�°'?���:;riz:��:�.:m_.:�.iL.a9,�,�e�' . ' Tat�:e 2 A�Y 229.257 91.437 (229,257) 320.694 (91.437) �i�uQnservices 212.4'!9 (2'12.419) 212,419 0 Council 937.030 (�37,030) 137,030 0 Financial Services 133,095 (133.095j 133,095 � fixeandSaferyServices 1.592.556 7�.3d6 F�.52t2�s) t.592,556 0 Gene21 GovernmerR Accounts 336,655 (340,590} 340,690 (4,035) Human Resources 168,307 (168,3D7) �fi6,307 0 Human Rights 36,091 (36.091) 3S,U91 0 Li62ries 292.056 (2g2.A5� 2g{p56 0 ��EP 558,928 (23,388) (436.879) 413,491 145,437 b9ayor's Office 175,726 (115,726) 115,726 0 Qa�7aSRetteation 1.074,427 (1.074,427) 1,074,427 0 Pta+ctirag �d Ecanmuc De�edopment 424,066 (424.066) 424,066 0 ao(�ce 3,347,415 91 579 3 309 u ic o 1,&35,520 600,000 (�,045,520) 1,645,520 0 TecMnoiogy&Management5ervices 535,483 151,�59 (380,289) 537,448 4,035 Debt 12.358 12.358 12.358 0 TOTAL 10,8$1,389 994,485 (g,856,904) '10,85'1,389 0 Rnanci� (Fund Balance, Snow Plowing) 2,ry00,00p Total 12,951,389 Dewease in LGA estimate Resotuiion Totals (generelfund) itamd 2 Attomey Citizen Services Council Fnanciai Services Fie ar�d Satefy Services Gene21 GovemmeM Axour�tr Human Resources fi+rman PoghS Libraries L�EP Mayofs Office Parks & Recreation Pianning antl Economic Development PoLce Pubic Wvi6 TeGxiol4gy & Managers�ei Services Debt TOTAL 2,'I OO,ODO (12,95'1,389) (9,856,904) (9,856,904) - 0 61.397 (6t.397) 44,000 _ (44.000) 37,500 (37,500) - 0 20.OD0 (41.831) 37,950 (37,950� 67.900 (67.900) 706,979 (88,745) 76,377 44.268 (32.'109) 25,050 (25,050) '122.293 {122,293) 7,SOD 17,SOD) 1.759 (7.759) 559.549 � 381.245 (156.474) 0 7.458254 425.513 (724,5D8) F"a^�+n9 (trde+QSt Eami�9s? 74,Ut}0 Fnancing (Central service cost remvery) 759,290 Total 1,941.544 Decrease tn lGAes4mate Decease in Use of Fund Baiance [003 Resolution Topls (general fund) Debt STAR Sales Taz Receipts Interest Famings Decease in Use M Funtl Balance Tatal - 4.141.947 300,000 4,44'1,947 74.DUQ 759,290 (%,370) (1.827,00'I) (724,508) (724,508) 4.'141,948 300,000 (4,447,948) 0 61,397 44,000 37,500 0 41,831 37,950 67,900 88.745 76,377 25,050 122293 7,500 0 1,759 537,779 1,'150,021 0 t�) 0 0 0 (21,837 ) U 18.234 0 0 21,830 0 18,233