Loading...
HomeMy WebLinkAbout2.a. Proposed 2003 BudgetAGENDA ITEM: Proposed 2003 Budget AGENDA SECTION: DISCUSSION PREPARED BY: Thomas D Burt, City Administrator AGENDA NO. ATTACHMENTS: MEMOS, 7/1/02 Budget Draft APPROVED B CITY OF ROSEMOUNT EXECUTIVE SUMMARY FOR ACTION CITY COUNCIL MEETING DATE AUGUST 14, 2002 As in the past, the plan is to review the budget at the July and August work session and set a preliminary levy in September. Finance Director Jeff May has received preliminary information from the Department of Revenue regarding the levy and has made adjustments to the budgets and levies for next year Please review his attached memo NOTES: MEMORANDUM DATE August 9, 2002 TO Thomas D Burt, City Administrator FROM Jeff May, Finance Director SUBJECT Budget Revisions Based on preliminary information that I received from the Department of Revenue yesterday regarding our levy limit for 2003 and discussions that you and I had, I have made revisions to our budgets and levies for next year These changes are included in the attached sheets and will be used for discussion at the August 14 Committee of the Whole meeting I will try to summarize the changes below 1) Our "preliminary" levy limit number is $6,293,411 This figure is $469,605 less than the preliminary levy that was discussed at the July C 0 W meeting To reduce the general levy we will look at doing the Connemara with a State Aid Street Bond issue next year This will allow us to eliminate $613,000 from the Street CIP In order to levy to our limit I have added back $143,142 to the Street CIP under Council Designated 2) I updated the LGA number to reflect the actual figure that was certified to us by the State last week The certified number was $253 less than the estimated figure we had been using 3) I updated the worksheet that estimates the impact to different valued homes with information that I received from the County These figures still only contain changes to the City's tax capacity rate The other agencies' information is still unavailable so we are still using last year's figures 4) Any pages that were affected by the above changes were updated as well August 14, 2002 Departments FUNDING REQUIREMENTS USES (INCLUDING FIRE STATION LEVY) 2002 2003 Adopted Proposed +1- Budget Budget Difference Percentage Council Budget $88,600 $93,500 $4,900 5 53% Administration Budget 320,300 341,000 20,700 6 46% Elections Budget 23,000 10,000 (13,000) -56 52% Finance Budget 255,300 271,200 15,900 6 23% General Government Budget 298,700 370,000 71,300 23 87% Community Development Budget 684,700 784,500 99,800 14 58% Police Budget 1,688,000 1,932,500 244,500 1448% Fire Budget 254,800 265,500 10,700 4 20% Public Works Operating Budgets Govemment Buildings Budget 312,900 321,800 8,900 2 84% Fleet Maintenance Budget 395,500 413,100 17,600 4 45% Street Maintenance Budget 893,800 1,142,200 248,400 27 79% Parks Maintenance Budget 423,100 457,600 34,500 8 15% Park Rec Budget General Operating 771,300 843,200 71,900 9 32% Park Rec Budget Special Programs 91,600 92,000 400 0 44% Total Operating Budgets General Fund $6,501,600 $7,338,100 $836,500 1287% Building CIP Requirements 24,000 24,000 0 0 00% Street CIP Requirements 208,000 303,142 95,142 45 74% Equipment CIP Requirements 770,100 751,100 (19,000) -2 47% Insurance Budget Requirements 200,000 210,000 10,000 5 00% Bonded Indebtedness 1,065,379 1,322,203 256,824 24 11% Bonded Indebtedness Fire Station Levy 154,482 156,130 1,648 1 07% Armory Anticipatory Levy (Value 2!21!02) 173,011 186,984 13,973 8 08% "195,000 ($1,152,683,700 x 00798 Total Funding Requirements $9,096,572 $10,291,659 $1,195,087 13 14% NOTE Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies August 14, 2002 Types Local Government Aid (LGA) FUNDING REQUIREMENTS SOURCES (INCLUDING FIRE STATION LEVY) 2002 2003 Adopted Proposed Budget Budget Difference Percentage $394,723 $402,142 $7,419 1 88% Internal Revenue Generated Licenses and Permits 478,500 516,200 37,700 7 88% Intergovernmental 423,889 432,089 8,200 1 93% Charges for Services 481,400 539,400 58,000 12 05% Fines Forfeits 90,000 90,000 0 0 00% Recreational Fees 203,900 208,800 4,900 2 40% Miscellaneous Revenues 130,400 140,800 10,400 7 98% Transfers In 3,500 3,500 0 0 00% Total Internal Revenues 1,811,589 1,930,789 119,200 6 58% Levy Sources Special Levies 1,392,872 1,665,317 272,445 19 56% General Levy 5,497,388 6,293,411 796,023 14 48% Total Levy $6,890,260 $7,958,728 $1,068,468 15.51% Total Revenue Sources $9,096,572 $10,291,659 $1,195,087 13 14% NOTE Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies 2002 GENERAL PROPERTY TAX LEVY PAYABLE 2003 GENERAL FUND BUILDING CIP FUND STREET CIP FUND EQUIPMENT CIP FUND INSURANCE FUND GENERAL LEVY $5,005,169 $24,000 $303,142 $751,100 $210,000 TOTAL GENERAL LEVY $6,293,411 BONDED INDEBTEDNESS G O COMMUNITY CENTER BONDS 1992C (Authorized $101,927) $0 G O IMPROVEMENT BONDS 1992D (Authorized- $6,128) $6,128 G 0 MUNICIPAL BUILDING BONDS 1992E (ICE ARENA) (Authorized $268,656) $0 G O IMPROVEMENT BONDS 1993A (Authorized $4,013) $4,013 G 0 BONDS 1993E (Port Authority) (Authorized $67,001) $67,001 G 0 BONDS 1994A (Port Authority) (Authorized $171,347) $171,347 G O IMPROVEMENT BONDS 1995A (Authorized 516,026) $16,026 G 0 MUNICIPAL BUILDING REFUNDING BONDS 1998A (ICE ARENA) (Authorized $252,644) $252,644 G 0 IMPROVEMENT BONDS 1998C (Authorized 55,139) $5,139 G O IMPROVEMENT BONDS 1999B (Authorized $16,434) $16 434 G 0 BONDS 20008 (Port Authority) (Authorized $236,266) $236,266 G 0 IMPROVEMENT BONDS 2001A (Authonzed $117,821) 50 G 0 PUBLIC FACILITY BONDS 2001C (Port Authority) (Authonzed 5170,604) $170,604 G 0 COMMUNITY CENTER REFUNDING BONDS 2001E (Authorized $93,447) $93,447 G 0 PORT AUTHORITY BONDS (Authonzed $283,154) $283,154 TOTAL BONDED INDEBTEDNESS $1,322,203 MARKET VALUE BASED REFERENDUM 1995 FIRE STATION LEVY G O FIRE STATION BONDS, 1996A (Authonzed $156,130) TOTAL FIRE STATION LEVY PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($95,000 ($1,152,683,700 x 00798°/x)) (As of 2/21/02) TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS GRAND TOTAL 2002 PROPERTY TAX LEVY $156,130 5156,130 $186,984 $186,984 $7,958,728 Total Funding Requirements 7,440,486 8,019,068 9,096,572 10,291,659 Less Internal Revenues 1,573,889 1,716,389 1,811,589 1,930,789 Less Market Value Based Levy Fire Station (See Below) 155,715 152,508 154,482 156,130 (4) Equals Revenues Needed City Adjustments (All Subtractions) Local Government Aid (LGA) 396,549 394,496 394,723 402,142 (2) Homestead Agricultural Credit Aid (HACA) 577,497 577,707 0 0 (2) Levy Certified by City to County Auditor County Auditor Adjustments (All Subtractions) Fiscal Disparities Distnbuturon Levy (Metro Area) Market Value Based Referendum Levy Fire Station Last Update 8/9102 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) (Proposed) 2000 2001 2002 2003 5,710,882 6,150,171 4,736,836 5,177,968 581,379 612,593 7,130,501 8,204,740 6,735,778 7,802,598 708,036 708,036 (3) Spread Levy Used to Compute Local Tax Rate 4,155,457 (1) 4,565,375 (1) 6,027,742 (1) 7,094,562 Increase from Previous Year in Spread Levy 9 86% 32 03% 17 70% 155,715 152,508 154,482 156,130 (4) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2003 Numbers Provided by Minnesota Department of Revenue No Estimate Available at This Time (Year 2002 HACA is removed as the HACA was repealed by the legislature) (3) 2003 Number Provided by Dakota County No Estimate Available at This Time (4) Market Value Based Levy for Fire Station Based on $156,130 Levy Spread to Taxable Market Value on 12/31/03 Last Update from Dakota County 2/21/02 Shows the Levy of $156,130 $1,130,070,450 1382 per $1,000 as our Estimate 0 8 S Page One August 14, 2002 Account Description 101 31010 00 000 Current Ad Valorem Taxes 101 31040 00 000 Fiscal Disparities Total Taxes (Tax) 101 33401 00 000 Local Government Aid (LGA) Total LGA (Lga) 101 33402 00 000 Hstd Ag Credit Aid (HACA) Total HACA (Haca) 101 33424 00 000 Local Performance Aid (LPA) Total LPA (Lpa) 101 32110 00 000 101 32160 00 000 101 32161 00 000 101 32180 00 000 101 3221000 000 101 3221200 000 101 32220 00 000 101 32230 00 000 101 3224000 000 101 32250 00 000 101 3225500 000 101 3226000 000 101 32290 00 000 101 31010 00 000 101 3101000 000 1 101 3102000 000 101 31030 00 000 101 31710 00 000 101 31810 00 000 101 31811 00 000 101 31920 00 000 101 3310000 000 101 33403 00 000 101 33416 00 000 101 33416 00 000 1 101 3341600 000 2 101 33418 00 000 101 3342300 000 101 3342500 000 101 33620 00 000 101 33630 00 000 101 3363000 000 1 101 36101 00 000 101 3610200 000 2003 BUDGET WORKSHEETS GENERAL FUND REVENUES Alcoholic Beverage Licenses (L) Licenses to do Business (L) Licenses to do Bus Kennels (L) Cigarette Licenses (L) Building Permit Revenue (L) Mineral Extraction Permit (L) Electrical Permit Revenue (L) Plumbing Permit Revenue (L) Animal Licenses (L) Sewer Permit Revenue (L) County Recording Fee City's (L) HVAC Permit Revenue (L) Other Non -Bus Lic Permits (L) Total Licenses Permits (L) Current Ad Valorem Taxes (I) MSABC Armory Payments Delinquent Ad Valorem Taxes (I) Mobile Home Taxes (I) Gravel Taxes (I) Franchise Taxes Regular Fees (I) Franchise Taxes PEG Fees (I) Forfeited Tax Sale Apportionment Federal Grants Aids (I) Mobile Home HACA (I) Police Training Reimbursement (I) Post Board Training Reimb State Aid (Tied to PERA) MSA for Streets Maintenance (I) Ag Preserves Credit (I) Other State Grants Aids Other County Grants Aids 0) Police Services Levy -ISD #196 (I) 0 A R E /Liaison Funding Principal Special Assessments (I) Penalties Interest 51A 0) Total Intergovernmental (I) PAGE TOTALS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $1,949,827 $2 095,667 $2 302 742 $3,587 252 $4,297 133 From County 530,667 581,379 612 593 708 036 708,036 From County 2 480,494 2,677 046 2 915 335 4 295 288 5,005 169 381 988 396 549 394,496 394,723 402 142 From State 381 988 396 549 394 496 394 72 402 142 550 493 577,497 577 707 550,493 577,497 577,707 15 466 15 466 0 0 0 0 14 166 16 840 21,540 17 00 20 00 2,150 1 359 2,400 1,00 1,50 50 75 75 0 0 0 479 029 461 126 632 696 373 00 400 00 2 275 4 030 1,520 1 80 2 00 21 543 12,839 17,579 12 00 15 00 36 934 32,305 44,946 25 00 30,00 2 190 2,228 2 352 2 00 2 00 24 039 21,355 18 772 15 00 15 00 230 200 250 20 20 39 358 34 621 48 241 30 00 30 00 1500 1325 25 150 50 623 463 588,304 790,396 478 50 516 20 91,000 90,000 90,000 90 30 91 00 Included in Debt Levy Figure 90,300 36,624 27,003 43,974 20 00 20,00 From County 11 744 11,656 10,690 10 00 10 00 From County 7 003 7 673 9 222 7,00 8,00 From County 125,757 93,639 106,857 95 00 100 00 From Cable Company O 9,253 12 331 10,00 10 00 From Cable Company O 0 0 From County 21 250 276 637 1 099 22,987 23,060 23,060 From State Program Eliminated 94 847 94,280 90 942 93,00 93,00 From State 8,000 87,000 27,900 28,596 28,230 27,900 29,000 From State 0 1,059 915 0 0 From State 30,233 12,889 17 037 19 389 12 889 From State PERA Aid 11 619 11,845 12 059 11 300 13 200 Dakota County Recycling Funds 35 091 36 979 40 045 40,000 45 COO 45,000 From ISD #196 O 0 65 0 0 From County O 0 0 0 0 From County 516,055 722 568 486,526 423 889 432 089 4,587 959 4 961 964 5 164,461 5,592,400 6 355 600 0 From State Program Eliminated From State Rolled into LGA Garbage Haulers, Ped Lis etc Alarm Permits Page Two August 14, 2002 2003 BUDGET WORKSHEETS GENERAL FUND REVENUES 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 101 34103 00 000 Zoning 8 Subdivision Fees (C) 8 068 18,592 20,245 12 000 15 000 101 34104 00 000 Plan Checking Fees (C) 228 930 271 726 379 389 210,000 260 000 65% of Budding Permit Fees 101 34105 00 000 Sales of Maps Publications (C) 404 542 1,704 500 500 101 34106 00 000 Deputy Registrar Fees (C) 31,418 30 652 34,738 35,000 35,000 State Fee Increase 7/1/01 101 34107 00 000 Assessment Searches (C) 327 60 10 100 100 101 34108 00 000 Admin Fees Other Funds (C) 140 088 195,691 96,670 100,000 125 000 101 34108 00 000 1 Applicable Funds Except Const 25 000 101 34108 00 000 2 Construction Funds 100,000 101 34109 00 000 Other Charges for Service (C) 2 069 2,429 2,901 3 000 3 000 101 34110 00 000 Service Chg on Returned Chks (C) 180 240 201 100 100 101 34112 00 000 Utility Permit Application Fee (C) 150 300 1,350 200 200 101 34160 00 000 National Guard Ma,nt Fees (C) 16,000 80,700 72,296 71 300 44 300 101 34160 00 000 1 Shared Space Rental Agreement 16,000 101 34160 00 000 2 Budding Maintenance Contract 28,300 101 34201 00 000 Special Police Services (C) 23,503 21,280 22,558 21 000 26,000 Contractual O,'T for Officers 101 34202 00 000 Fire Services Burning Permits (C) 4 183 3,723 3,393 3 500 3 500 101 34203 00 000 Accident Reports (C) 513 550 616 500 500 101 34204 00 000 Day Care Inspection Fees (C) 292 504 252 200 200 101 34206 00 000 Other Police Services (C) 23 0 0 0 0 101 34207 00 000 Other Fire Protection Services (C) 25 188 66,121 60 294 21,000 21 000 101 34207 00 000 1 U of M Fire Contract 5,100 101 34207 00 000 2 Coates Fire Contract 3,600 101 34207 00 000 3 Other Billed Fire Calls 12,300 101 34303 00 000 Mow Weeds (C) 529 3 258 0 0 0 101 34306 00 000 Other Highway 8 Street Rev (C) 150 14 130 0 0 2,000 Street Light Bills Developers 101 34407 00 000 City Share of Metro SAC Chgs (C) 4,365 3,395 4,086 3,000 3 000 Total Charges for Services (C) 486 379 713 892 700 702 481,400 539,400 101 35101 00 000 Court Fines (F) 91 441 72 067 88,523 90,000 90 000 From County Total Fines 8 Forfeits (F) 91 441 72 067 88 523 90,000 90,000 101 34720 00 000 Park Reservations (R) 89 1,175 1,695 1 500 1,500 101 34721 00 000 Softball Revenues (R) 44,13 44,701 48,174 37 500 40 000 101 34722 00 000 Volleyball Revenues (R) 6 71 4,780 3,350 9 400 2,500 101 34724 00 000 Tennis Revenues (R) 1 37 1 148 975 1 300 1,300 101 34725 00 000 Tiny Tot Revenues (R) 12,50 15,240 15,499 16 600 19 000 101 34726 00 000 Porn Ram Revenues (R) 2 30 1,916 3 152 2,500 3,000 101 34727 00 000 Field Trip Revenues (R) 4,53 2,524 2,159 2 800 2 800 101 34728 00 000 Broomball Revenues (R) 1 17 780 675 0 0 101 34 00 000 Skating Lesson Revenues (R) 60 450 75 800 800 101 34730 00 000 Fun Runs Walks Bike Rides (R) 1 71 1,717 2,988 1,000 1,800 101 34732 00 000 Adult Basketball (R) 1,02 1,260 2 370 700 1,900 101 34733 00 000 Other Programs Revenues (R) 9 21 11,154 6,277 3,500 5 500 101 34735 00 000 Summer Camps (R) 0 2 675 3,000 3,000 101 34736 00 000 T -Ball (R) 0 3,794 3,200 3 500 101 34790 00 000 Other Recreation Revenues (R) 0 0 0 2 100 Promise Fellow Grant Program 101 38080 00 000 Banquet Room Fees (R) 55 49 60 228 57,025 52 500 54 000 101 38081 00 000 Auditorium Fees (R) 12 20 13,351 10 133 12 600 12 600 101 38082 00 000 Gymnasium Fees (R) 17 47 24,538 25 038 20 000 22 000 101 38084 00 000 Pistol Range Fees (R) 3 75 3,775 3,951 4 700 0 101 38086 00 000 Classroom Fees (R) 25 10 28,834 25,626 22 000 24 000 101 38096 00 000 Liquor Provider Fees (R) 1 54 1,440 1 500 2 000 2 000 101 38097 00 000 AN Rental Fees (R) 83 663 874 700 700 101 38150 00 000 Open Gym Fees (R) 0 0 1,000 0 101 38154 00 000 Teen Night Revenues (R) 4 98 4 358 4,917 4 600 4 800 Total Recreation Fees (R) 207 578 224,033 222 921 203 900 208 800 PAGE TOTALS 785,398 1,009,993 1 012 146 775 300 838 200 Comments Page Three August 14, 2002 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account# Descnpaon Actual Actual Actual Budget Amount Budget Comments 101 36210 00 000 Interest Earnings Investments (M) 83,426 152,349 172 613 120 000 130 000 101 36214 00 000 Net Change in FV- Investments tM) (31 095) 22,969 2,167 0 0 Annual Market Value Changes 101 36215 00 000 Interest Earnings (M) 1 532 1 432 1 843 1,000 1,000 From Checking Account 101 36220 00 000 Rents 8 Royalties (M) 4 056 4,394 4,760 4,400 4,800 US West Antenna Rent 101 36230 00 000 Contribution /Donations (M) 55 315 44,146 77,166 0 0 101 36260 00 000 Other Revenue (M) 3 417 6,284 7 289 5 000 5 000 Total Misc Revenues (M) 116,651 231,574 265,639 130 400 140,800 101 39202 00 000 Contribution from Enterprises (T) 3,500 3,500 3,500 3 500 3 500 Arena Bldg Grounds Maint Total Transfers In (T) 3 500 3,500 3 500 3,500 3 500 PAGE TOTALS $120,151 $235,074 $269 139 $133,900 $144,300 DEPARTMENT TOTALS $5 473,508 $6 207,031 $6 445 745 $6 501 600 $7,338 100 INTERNAL REVENUES $2 045 066 $2 555,938 $2 558 208 $1,811,589 $1,930 789 Grand Total Less Ad Valorem LGA HACA, LPA Fiscal Disparities 2003 BUDGET WORKSHEETS GENERAL FUND REVENUES Page Four August 14 2002 2003 BUDGET WORKSHEETS GENERAL FUND REVENUES 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 101 34108 00 000 General Fund Admm Fees $25 000 $25,000 $25 000 $25,000 $25,000 101 34108 00 000 1 Fund 201 6,000 101 34108 00 000 2 Fund 202 2,500 101 34108 00 000 3 Fund 203 2,500 101 34108 00 000 4 Fund 206 2 500 101 34108 00 000 5 Fund 207 2 500 101 34108 00 000 8 Fund 605 1 000 10' 34108 00 000 9 Fund 606 1 000 101 34108 00 000 11 Fund 607 1 000 101 34108 00 000 12 Fund 650 6,000 Adman Fees Breakdown Totals $25,000 $25 000 $25 000 $25 000 $25,000 $25,000 co 2003 2 0031 20031 20031 1003 2003 2003 2003 2003 2003 20031 2003' 7 000c 7 0 JWWW 0 0 C 203 1 2003 onn3 2003 2003 nnnn 2003 rear 'dais u,� iun nippenuaie vvaler lower I Water Tower #4 rickop )rcepIace P339) Easement Sewer Cleaning Machine 1 I ((vim) luawaoeldaj ralspI (hotel wawaleidau insno van (Replace #319 Park Rec) 3 Squads (Sell Back 3 #9920, 9970 2030) PW Bldg Add n Lease /Purch (Yr 5 of 20) J 93r. clt ueollidlYdric 'Emergency Equipment for Squads Installation pry Birch Park Trails s Improvements I uc.l n um i nee a ieael SCBA Unit Replacements (1991 Units) I 1 r=+�yi,dieu- ti 991 reserves PC Printer Replacements (From 1998) Li non cease-rut noose Cw -mars' 2001 Lease Purchase f10- Years; 1995 Lease Purchase (10- Years' item Uescnpbon rue Werks Pub Works Pub Works Pub Works I Pub Works Pub Works Pub Works Pub Works Pub Works ponce Police 'Park Rec Police [nark a nee Park Rec rmance Fire Uounal Finance Uouncil Council Council IDeparimenl I 24 000 1 CIP Levy 303,142; 160,0001 Street 751 1001 42 000 33 000 30 00', 30 0001 r 20 000 75 000 6 000 8 000 49 000 5 000 50 000 85,000 r 40,000 1 20.000 64 900 115 400 50 800 F Eq uipm nt 1,202 000 862,000 15 000 325 000 113 0010 1 30 000 30,000 15,000 1 Park Imo 675,00 675,0001 Funds From 528,001 160 0001 15 000 320,000 1 Wa 3 5,000, 15 000 1 Sewer 726,0001 726,000 1 1 SInrm Q000 11 W,rar 10,0001 2 268,0001 dl 190 uuu 613,000 in nnn ..de 6,645 2421 180,0001 0 W D J 010001000 W Co 000_- NJ PO 0000A C.1 W 0 0 001000 A J (1 IA 1001 00000 0 W W 4 V W 0C C 1 50 0001 1 20,0001 L 1431421 1 e� co MEMORANDUM DATE July 2, 2002 TO Mayor City Council FROM Thomas D Burt, City Administrator SUBJECT 2003 Proposed Budget The following identifies every change to the budget on a line item by line item basis The greatest increase in the general fund budget is as a result of increases to benefits and wages that attribute approximately $420,000 of the proposed $837,000 increase The following full -time positions are being recommended Police Officer This additional position is based on the unofficial commitment to maintain a ratio of 1 officer per 1000 residents According to Planner Rick Pearson, the estimated population as of April 1, 2002 was 16,599 It still appears likely that 300 350 additional homes v,111 be built over the next t■ elve months At that growth rate, the community still grows by 750 925 residents annually If an officer position is budgeted for July 1, 2003, the officer will be hired and ready for duty in late fall when the population will be approaching 18,000 The addition of this officer will allow us to either increase coverage to three (3) officers on duty from 11 00 a m to 02 30 a m or to create a second investigative assignment depending on analysis of call load and the creation of the proposed sergeant position An additional patrol position should reduce the amount of overtime spent Staffing levels will be set to not fill all the shifts when there will still be two (2) officers scheduled This occurs when officers take leave time, attend training or call in sick Full time Police Receptionist This position is needed to provide better customer service and due to the workload of the present secretarial staff The secretaries currently are continually multi- tasking, which reduces their efficiency of performing their primary duties of typing reports and entering data A FT receptionist will greet counter customers and callers more quickly, while at the same time the secretaries will focus on their tasks Making this position full -time will also provide better coverage when one of the secretaries is on leave As the department has added police officers, there has been a corresponding increase in the workload of the secretarial positions This position is needed to allow the secretarial staff to complete typing and processing of police reports needed by the county attorney's office, city prosecutor, victims, witnesses and other agencies A PT receptionist position was approved in the 2002 budget Because the position was, not filled until July due to the state's budget shortfall, the position was adjusted to a full tune position This was done in anticipation of the position being made FT in 2003 1 Sergeant Position There are currently four (4) supervisor /manager positions in the department w ith a staff of 19 FT and 3 PT positions The staff has grown due to the increased number of calls for service being received Calls have also become more complex in nature requiring more time being spent on the calls An additional supervisor position is needed to provide supervision dunng more hours of the day and on weekends The current scheduling of supervisors /managers results m there not being a supervisor on duty for at least 49 5 hours of the 168 hours work week Supervisory staff is only scheduled for 10 5 hours on weekends and 19 5 hours each weekday Those hours are further reduced when supervisory staff takes leave time or is gone for naming A supervisor is not on -duty more than twenty -five percent of the time The addition of one sergeant will not entirely eliminate the unsupervised hours, however, there will be a significant reduction Also, the third sergeant position will be used differently than the current positions With the addition of a third sergeant position, one of the positions will be used to provided coverage on weekends, provide investigative supervision and to perform some administrative functions This will provide an opportunity for the development of administrative and management skills to better prepare sergeants for assuming new duties and possible promotion in the future Assistant Planner The Assistant Planner position will enhance customer service for the public Currently, lengthy gaps in the availability of the City Planner to assist the public occur as a result of meeting participation and agenda preparation The Assistant Plainer will also assist the Building Department by reviewing applications all budding permits including sign permits and permits for decks, patios, swimming pools, etc The Assistant Planner will accelerate the completion of annual work plan objectives by assisting the City Planner with agenda preparation and enhanced research capabilities Project administration and follow -up will be enhanced with the availability of the Assistant Planner for field inspections and landscaping venfication Building Maintenance Worker The funding for the position is a reallocation of current part -time funds We have been having a difficult time retaining part-time building staff positions at the Rosemount Community Center We often finish training in a new staff person and they end their employment with us to pursue other interests After reviewing the amount of overtime worked by the building staff, it indicates a need for additional help Parks Supervisor The position will be supervised by the Director of Parks and Recreation and would be classified much like a Recreation Supen isor but IN ith a parks focus Due to the increased demand for the use of our parks, the position will better our service levels in the areas of parks operations and development The job responsibilities will include handling park reservations. supervising contracted construction projects, handling park based programs such as Arbor Day, Adopt -a -Park and the Memonal Donation Program 2 The position would also handle all city rubbish and recycling and along with City Clean up Day The position will be a liaison to all scheduled park users and will be the City contact for RAAA, Garden Club, Dakota REV etc A position that is focused on the parks will be a long -tens benefit to the City and our residents The heavy use that oui parks receive and the quality of life they can create, needs special attention The two Recreation Supervisors, Water Resource Engineer, Director of Parks and Recreation and other public works staff are currently performing some of the duties that this position will be responsible for The following explains why each line item has increased or decreased from 2002 As you review the budget if you have questions please call or if you would like to meet to discuss any part of the budget, please let me know EXPENDITURES: Council 101 41110 01 307 +52,500 Increased cost of the newsletter 101 41110 01 319 +$1,300 The number of employees applying for educational reimbursement has increased 101 41110 01 433 +$700 Administration 101 41320 01 101 +20,500 101 41320 01 433 -$200 Elections Finance 101 41520 01 101 +510,900 101 41520 01 391 +$4,000 101 41520 -01 -437 +51.000 Increased to League of Minnesota Cities dues. Total Department budget has increased by $4,900 or 5.5 Adjusted for salary and insurance increases Added dues for Human Resources Total Department budget has increased by $20,700 or 6.46 This is off election year so the budget will decrease Each line item is zero with the exception of Equipment purchases This line item of 510,000 is encumbered for future election equipment to offset future cost Total Department budget has decreased by $13,000 or 56.52 Adjusted for salary and insurance increases Increase in software and network support cost Management classes for supervisory position 3 General Government 101 41810 01 202 +12,000 Added photo copiers and increase cost of file storage and closer reflects history 101 41810 01 209 +1,000 101 41810 01 301 +14.000 101 41810 01 319 +$3,500 Total Department budget has increased by $15,900 or 6.23% Increase in general office supplies to closer reflect history Increase audit cost. Increase in flex spending administration cost and continuing disclosure fees for bonds issued 101 41810 01 320 +1,000 Cost of accepting credit cards at Parks department 101 41810 01 321 +400 Increased telephone cost 101 41810 01 328 +400 Video tapes for meetings 101 41810 01 329 +39,000 Cost of producing cable television programs and broadcasting Port Authonty meetings Total Department budget has increased by 571,300 or 23.87% Community Development 101 41910 01 101 +99,200 Adjusted for salary and insurance increases, in addition a Planner has been added 101 41910 01 103 +1,200 Adjusted for salary increase and increased hours of part-time secretary 101 41910 01 202 -300 Reflects needs. 101 41910 01 203 -1,000 Reflects needs 101 41910 01 209 +300 Reflects needs 101 41910 01 219 +400 If a new planner is hired initial supplies are needed 101 41910 01 319 +$1,000 Reflects historical spending 101 41910 01 435 -5500 Reflects needs -300 Reflects needs Total Department budget has increased by $99,800 or 14.58% 4 Police 101 42110 01 101 5293,500 Adjusted for salary and insurance increases, in addition a part time receptionist is move to full tune, a Police Officer has been added beginning in mid 2002 and an additional Sergeant position has been added 101 42110 01 102 +20,000 Increased as a result of adding sergeant and officer 101 42110 01 103 $4.000 Adjusted to closer reflect history 101 42110 01 202 +300 Reflect history 101 42110 01 316 +51,200 As the population grows more animal complaints are being received 101 42110 01 319 +4,000 Reflects cost increases due to population growth 101 42110 01 331 +51,000 Based on history and expected costs in 2002 101 42110 01 396 +11,000 Increase in LOGIS costs 101 42110 01 433 +1,000 Increase is due to 9 officers' licenses being renewed 101 42110 01 580 +3,400 Purchase digital recorders Total Department budget has increased by $320,000 or 18.96% Fire 101 42210 01 103 -1 5,100 Increase as a result of adding fire fighters and pension cost increases 101 42210 01 208 1,100 Reflects department needs for 2003 101 42210 01 219 +$500 Reflects department needs for 2003 101 42210 01 305 +51,900 Reflects department needs for 2003 for annual medical testing 101 42210 01 306 -$500 Four firefighters will be recruited in 2002 101 42210 01 310 +$600 This line item fluctuates from year to year based on the equipment needing testing 101 42210 01 313 +55.000 101 42210 01 319 +$200 The increase is the added cost of participating in the Technical Team Joint Powers Increase in fire prevention education matenals 5 101 42210 01 321 +$300 101 42210 01 433 +$200 101 42210 01 580 $2,000 Public Works Government Buildings 101 41940 01 101 +$3,100 101 41940 01 102 +$1,000 101 41940 01 208 +$1,500 101 41940 01 319 +$2,500 Fleet Maintenance 101 43100 01 101 +$7,600 101 43100 01 221 +$2,000 101 43100 01 222 +$5,000 101 43100 01 242 +$2,000 101 43100 01 404 +$5,000 Street Maintenance 101 43121 01 101 +$22,500 101 43121 01 205 +400 101 43121 01 231 +$2,000 101 43121 01 233 +$3,000 101 43121 01 381 +$10,000 Reflects department needs for 2003 Reflects department needs for 2003 Reflects department needs for 2003 Total Department budget has increased by $10,700 or 4.20% Adjusted for salary and insurance increases Reflects historical costs Increased cost of cleanmg materials for governmental buildings Reflects histoncal costs Total Department Division budget has increased by $8,900 or 2.84% Adjusted for salary and insurance increases Budget reflects history of spending needs. Increase is due to the grader needing tires replaced Reflects department needs for 2003 Reflects department needs for 2003 Total Department Division budget has increased by $17,600 or 4.45% Adjusted for salary and insurance increases Increased to reflect history As the city adds roads the amount budgeted for bituminous patching will increase proportionately Increased cost in dust control matenals As a result of growth there is an increase in number of street lights. 6 101 43121 01 391 +$2,000 101 43121 01 402 +575,000 101 43121 01 405 +$7.000 101 43121 01 406 +$3,500 101 43121 01 407 $25,000 101 43121 01 408 +$15,000 101 43121 01 410 +$128,000 101 45202 01 101 +$15,100 101 45202 01 216 +$15,000 101 45202 01 221 +$1,000 101 45202 01 225 +$900 Software support for pavement management program The city has added 3 miles of road annually and has not increased the amount of seal coating for a number of years Last year we began to increase this number but we are still not keeping up with maintenance of' the streets on the average every street should be seal coated on a see en years cycle As the City adds roads this item will need to raise to reflect the added cost of striping additional miles of road on and annual basis As the City adds roads this item will need to raise to reflect the added cost of street sweeping additional miles of road on and annual basis This line item was combined in Sidewalk improvements Similar to above the city has not kept up with crack filling If cracks are not repaired m pavement, water gets under the pavement and will cause increased damage A goal of the Council was to provide connections of existing sidewalk system At a works session staff presented information of a 7 year plan to connect sidewalks and trails and then to establish a maintenance program Total Department Division budget has increased by $248,400 or 27.79% Parks Grounds Maintenance Adjusted for salary and insurance increases. Because additional parks have been added more chemicals are need for maintenance in addition it has been budget closer to what has historically been spent 101 45202 01 219 +$2,000 Because additional parks have been added more supplies are need for maintenance. As parks are added the cost of maintenance on playground equipment, etc is increasing Increase to reflect history Total Department Division budget has increased by $34500or 8.15% 7 Park Recreation 101 45100 01 101 +$75,000 Adjusted for salary and insurance increases The position of Parks Supervisor was added and a full time building Maintenance Worker was added 101 45100 01 103 $17,300 This line item is down because part of the money to fund the full time building maintenance position was funded from part time salanes 101 45100 01 209 +$200 Increase to reflect history 101 45100 01 216 +$300 Increase to reflect history 101 45100 01 219 +$1,000 Increase to reflect history 101 45100 01 221 +$4.000 New tables and chairs will be purchased for the banquet room 101 45100 01 312 +$900 Increased cost of contractual custodial maintenance 101 45100 01 319 +$1,000 Increased to reflect history 101 45100 01 401 +$2,000 Increased to reflect history 101 45100 01 404 +$1,000 Increased to reflect history. 101 45100 01 415 +$2,000 As parks are added the need to rent additional portable toilets are added 101 45100 01 433 +$300 Increase as a result of dues for new Parks Supervisor. 101 45100 01 437 +$500 Increase as a result of added Parks Supervisor position Total Department budget has increased by 571,900 or 9.32% REVENUE At the time of wnting this memo Spnngsted has not completed the fee study that could change some of the revenue amounts budgeted The revenues have minor increases with the greatest increase in the general levy of $1 3 million dollars To keep the tax capacity rate the same as last year we would need to reduce the budget by $66,013 because the city expenenced a 16% growth in value The greatest concern to the 2003 budget is the States financial problems It is expected that cities will lose their Local Government Aid which amounts to $402,395 for Rosemount I recommend that Council consider budgeting for our needs and setting the preliminary with the understanding that the State may take away LGA funds If the state does eliminate LGA the following is recommended to be cut from the budget 8 101 41110 01 307 101 41110 01 329 101 41110 01 329 101 41910 01 103 101 42110 01 580 101 43121 01 410 101 45100 01 101 Capital Improvements Program PC's Pi inters Motor Pool Vehicle (305) P &R Van Roller Replacement Skidster Replacement 2 Pickups Total CIP TOTAL REDUCTION Planning Consultant Broadcast Port Authonty Meetings Cable television programming Planning Intern Digital Recorders Sidewalk improvements Parks Supervisor (wages insurance) 12,000 5,000 5 30,000 17,500 4,000 $125,000 71,321 $252,821 50,000 20,000 20,000 27,000 30,000 30.000 75,000 $252,000 $504,821 July 10, 2002 Departments FUNDING REQUIREMENTS USES (INCLUDING FIRE STATION LEVY) 2002 2003 Adopted Proposed Budget Budget Difference Percentage Council Budget $88,600 $93,500 $4,900 5 53% Administration Budget 320,300 341,000 20,700 6 46% Elections Budget 23,000 10,000 (13,000) -56 52% Finance Budget 255,300 271,200 15,900 6 23% General Government Budget 298,700 370,000 71,300 23 87% Community Development Budget 684,700 784,500 99,800 14 58% Police Budget 1,688,000 1,932,500 244,500 14 48% Fire Budget 254,800 265,500 10,700 4 20% Public Works Operating Budgets Government Buildings Budget 312,900 321,800 8,900 2 84% Fleet Maintenance Budget 395,500 413,100 17,600 4 45% Street Maintenance Budget 893,800 1,142,200 248,400 27 79% Parks Maintenance Budget 423,100 457,600 34,500 8 15% Park Rec Budget General Operating 771,300 843,200 71,900 9 32% Park Rec Budget Special Programs 91,600 92,000 400 0 44% Total Operating Budgets General Fund $6,501,600 $7,338,100 $836,500 12.87% Building CIP Requirements 24,000 24,000 0 0 00% Street CIP Requirements 208,000 773,000 565,000 271 63% Equipment CIP Requirements 770,100 751,100 (19,000) -2 47% Insurance Budget Requirements 200,000 210,000 10,000 5 00% Bonded Indebtedness 1,065,379 1,039,049 (26,330) -2 47% Bonded Indebtedness Fire Station Levy 154,482 156,130 1,648 1 07% Armory Anticipatory Levy (Value 2/21/02) 173,011 186,984 13,973 8 08% "195,000 (81,152,683,700 X 00798%)" Total Funding Requirements $9,096,572 $10,478,363 $1,381,791 15 19% NOTE Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies July 10, 2002 Types Local Government Aid (LGA) FUNDING REQUIREMENTS SOURCES (INCLUDING FIRE STATION LEVY) 2002 2003 Adopted Proposed Budget Budget Difference Percentage $394,723 $402,395 $7,672 1 94% Internal Revenue Generated Licenses and Permits 478,500 516,200 37,700 7 88% Intergovernmental 423,889 432,089 8,200 1 93% Charges for Services 481,400 539,400 58,000 12 05% Fines Forfeits 90,000 90,000 0 0 00% Recreational Fees 203,900 208,800 4,900 2 40% Miscellaneous Revenues 130,400 140,800 10,400 7 98% Transfers In 3,500 3,500 0 0 00% Total Internal Revenues 1,811,589 1,930,789 119,200 6 58% Levy Sources Special Levies 1,392,872 1,382,163 (10,709) -0 77% General Levy 5,497,388 6,763,016 1,265,628 23 02% Total Levy $6,890,260 58,145,179 51,254,919 18 21% Total Revenue Sources $9,096,572 510,478,363 51,381,791 15 19% NOTE Special Levies vlclude (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies 2002 GENERAL PROPERTY TAX LEVY PAYABLE 2003 GENERAL LEVY GENERAL FUND $5,004,916 BUILDING CIP FUND $24,000 STREET CIP FUND $773,000 EQUIPMENT CIP FUND 5751,100 INSURANCE FUND $210,000 TOTAL GENERAL LEVY 56,763,016 BONDED INDEBTEDNESS G O COMMUNITY CENTER BONDS 1992C (Authorized $101,927) $0 G 0 IMPROVEMENT BONDS 1992D (Authorized 56.128) S6,128 G 0 MUNICIPAL BUILDING BONDS 1992E (ICE ARENA) (Authorized $268,656) $0 G 0 IMPROVEMENT BONDS 1993A (Authorized $4,013) $4,013 G 0 BONDS 1993E (Port Authority) (Authorized $67,001) $67,001 G 0 BONDS 1994A (Port Authority) (Authorized $171,347) $171,347 G O IMPROVEMENT BONDS 1995A (Authorized 516,026) $16,026 G 0 MUNICIPAL BUILDING REFUNDING BONDS 1998A (ICE ARENA) {Authorized $252,64 $252,644 G 0 IMPROVEMENT BONDS 1998C (Authorized $5,139) 55,139 G 0 IMPROVEMENT BONDS 1999B (Authorized $16,434) $16,434 G 0 BONDS 2000B (Port Authority) (Authorized $236,266) $236,266 G 0 IMPROVEMENT BONDS 2001A (Authorized $117,821) $0 G 0 PUBLIC FACILITY BONDS 2001C (Port Authority) (Authorized $170,604) $170,604 G 0 COMMUNITY CENTER REFUNDING BONDS 2001E (Authorized 593,447) $93,447 TOTAL BONDED INDEBTEDNESS $1,039,049 MARKET VALUE BASED REFERENDUM 1995 FIRE STATION LEVY G 0 FIRE STATION BONDS, 1996A (Authorized $156,130) TOTAL FIRE STATION LEVY PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($95,000 ($1,152,683,700 x 00798 (AS OF 2121/02) TOTAL. PRINCIPAL AND INTEREST ON ARMORY BONDS GRAND TOTAL 2002 PROPERTY TAX LEVY $156,130 $156,130 $186,984 5186,984 -y 58,145,179 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) (Proposed) 2000 2001 2002 2003 Total Funding Requirements 7,440,486 8,019,068 9,096,572 10,478,363 Less Internal Revenues 1,573,889 1,716,389 1,811,589 1,930,789 Less Market Value Based Levy Fire Station (See Below) 155,715 152,508 154,482 156,130 (4) Equals Revenues Needed 5,710,882 6,150,171 7,130,501 8,391,444 City Adjustments (All Subtractions) Local Government Aid (LGA) 396,549 394,496 394,723 402,395 (2) Homestead Agricultural Credit Aid (HACA) 577,497 577,707 0 0 (2) Levy Certified by City to County Auditor 4,736,836 5,177,968 6,735,778 7,989,049 County Auditor Adjustments (All Subtractions) Fiscal Disparities Distnbutuion Levy (Metro Area) Spread Levy Used to Compute Local Tax Rate Increase from Previous Year in Spread Levy Market Value Based Referendum Levy Fire Station Last Update 6/28/02 581,379 612,593 708,036 708,036 (3) 4,155,457 (1) 4,565,375 (1) 6,027,742 (1) 7,281,013 986% 32 03% 20 79% 155,715 152,508 154,482 156,130 (4) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2003 Numbers Provided by Minnesota Department of Revenue No Estimate Available at Thus Time (Year 2002 HACA is removed as the HACA was repealed by the legislature) (3) 2003 Number Provided by Dakota County No Estimate Available at This Time (4) Market Value Based Levy for Fire Station Based on $156,130 Levy Spread to Taxable Market Value on 12/31/03 Last Update from Dakota County 2/21/02 Shows the Levy of $156,130 $1,130,070,450 1382 per $1,000 as our Estimate _saes xen SS ESSE Page One July 10, 2002 Acoounl# D esc ri ptio n 101 3101000 000 101 31040 00 000 101 33401 00 000 101 33402 00 000 101 33424 00 000 101 3211000 000 101 3216000 000 101 32161 00 000 101 32180 00 000 101 3221000 000 101 3221200 000 101 3222000 000 101 32230 00 000 101 32240 00 000 101 32250 00 000 101 3225500 000 101 32260 00 000 101 3229000 000 101 3101000 000 101 31010 00 0001 101 31020 00 000 101 31030 00 000 101 31710 00 000 101 3181000 000 101 31811 00 000 101 31920 00 000 101 33100 00 000 101 33403 00 000 101 33416 00 000 101 33416 DO 0001 101 33416 00 000 2 101 33416 00 000 101 33423 00 000 101 33425 00 000 101 3362000 000 101 3363000 000 101 33630 00 0001 101 36101 00 000 101 36102 00 000 2003 BUDGET WORKSHEETS GENERAL FUND REVENUES Current Ad Valorem Taxes Fiscal Disparities Total Taxes (Tax) Local Government Aid (LGA) Total LGA (Lga) Hstd Ag Credd Aid (HACA) Total HACA (Haca) Local Performance Aid (LPA) Total LPA (Lpa) Alcoholic Beverage Licenses (L) Licenses to do Business (L) Licenses to do Bus Kennels (L) Cigarette Licenses (L) Budding Permit Revenue (L) Mineral Extraction Permit (L) Electncal Permit Revenue (L) Plumbing Permit Revenue (L.) Animal Licenses (L) Sewer Permit Revenue (L) County Recording Fee -City's (L) HVAC Permit Revenue (L) Other Non -Bus uc Permits (L) Total ucenses Permits (L) Current Ad Valorem Taxes (I) MSABC Armory Payments Delmcuent Ad Valorem Taxes (I) Mobile Home Taxes (I) Gravel Taxes (I) Franchise Taxes Regular Fees (I) Franchise Taxes PEG Fees (1) Forfeited Tax Sale Apportionment Federal Grants Aids (I) Mobile Home HACA (I) Police Training Reimbursement (I) Post Board Training Reimb State Aid (Tied to PERA) MSA for Streets Maintenance (1) Ag Preserves Credit (1) Other State Grants Aids Oche' County Grants Aids (I) Police Services Levy -ISD #196 (I) D A R E /Liaison Funding Principal Special Assessments (I) Penalties Interest S,A (I) Total Intergovernmental (I) PAGE TOTALS 2002 2003 (Dialect 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $1 949 827 $2,095,667 $2 302 742 33,587,252 530,667 581 379 612593 708036 2 460494 2 677 046 2 915 335 4 295 288 381 986 396 549 394 496 394 723 381 988 396,549 394 496 394 723 550 493 577 497 577 707 0 0 From State Program Eliminated 550,493 577,497 577,707 15,466 0 0 0 15466 0 0 0 14,166 16,840 21,540 17,000 2,150 1,359 2400 1000 50 75 75 0 0 0 0 0 479 029 461,126 632 696 373,000 2 275 4,030 1 520 1,800 21 543 12 839 17,579 12,000 36,934 32,305 44 946 25 000 2,190 2 228 2,352 2 000 24,039 21,355 18 772 15 000 230 200 250 200 39,358 34 621 48 241 30 000 1,500 1,325 25 1 500 623 463 586,304 790,396 478,50 91,000 90,000 90000 90,30 36 624 27,003 43,974 20 00 11,744 11,856 10,690 10 00 7,003 7,873 9 222 7,00 125,757 93,639 106 857 95,00 0 9,253 12,331 10,00 0 0 0 21250 276637 1099 22 987 23 060 23 060 94 847 94 280 90 942 93,00 27,900 26 596 28 230 27 900 0 1 059 915 0 30 233 12 689 17 037 19,389 11,619 11,845 12 059 11,300 35,091 36,979 40,045 40,000 0 0 65 0 0 0 0 0 516,055 722,568 486,526 423 889 0 0 90,300 6,000 87,000 45,000 $4 296,880 From County 708 036 From County 5 004,916 402,395 From State 402,395 20,000 1 500 Garbage Haulers Ped Mc etc 0 0 400,000 2 000 15 000 30,000 2 000 15 000 200 30 000 500 Alarm Permits 516,20 91 00 20,00 10,00 8 00 100 00 10 00 93 00 29,000 0 12 889 13 200 45 000 432 089 0 From State Roiled into LGA 0 4,567,959 4,961 964 5 164 461 5592 400 6 355,600 Included m Debt Levy Figure From County From County From County From Cable Company From Cable Company From County From State Program Eliminated From State From State From State From State PERA Aid Dakota County Recycling Funds From ISD #196 0 From County 0 From County Page Two July 10, 2002 2003 BUDGET WORKSHEETS GENERAL FUND REVENUES 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 101 34103 D0 000 Zoning Subdivision Fees (C) 6,068 18 592 20,245 12 000 15 000 101 34104 00 000 Plan Checking Fees (C) 228 930 271 726 379,389 210 000 260,000 65% of Building Permit Fees 101 34105 00 000 Sales of Maps 8 Publications (C) 404 542 1 704 500 500 101 34106 00 000 Deputy Registrar Fees (C) 31,418 30,652 34 738 35 000 35 000 Stale Fee Increase 7/1/01 101 34107 00 000 Assessment Searches (C) 327 60 10 100 100 101 34108 00 000 Adman Fees Other Funds (C) 140 088 195 691 96,670 100 000 125,000 101 34108 00 000 1 Applicable Funds Except Canst 25,000 101 34108 00 000 2 Construction Funds 100,000 101 34109 00 000 Other Charges for Service (C) 2 069 2,429 2,901 3 000 3,000 101 34110 00 000 Service Chg on Returned Chks (C) 180 240 201 100 100 101 34112 00 000 Utility Fermi, Application Fee (C) 150 300 1 350 200 200 101 34160 00 000 National Guard Ma int Fees (C) 16,000 80,700 72 296 71,300 44 300 101 34160 00 000 1 Shared Space Rental Agreement 16 000 101 34160 00 000 2 Building Maintenance Contract 28 300 101 34201 00 000 Special Police Services (C) 23,503 21 280 22,558 21,000 26 000 Contractual O(f for Officers 101 34202 00 000 Fire Services Burning Permits (C) 4,183 3,723 3393 3,500 3,500 101 34203 00 000 Accident Reports (C) 513 550 616 500 500 101 34204 00 000 Day Care Inspection Fees (C) 292 504 252 200 200 101 34206 00 000 Other Police Services fC) 23 0 0 0 0 101 34207 00 000 Other Fire Protection Services (C) 25,188 66,121 60 294 21,000 21 000 101 34207 00 000 1 U of M Fire Contract 5 100 101 34207 00 000 2 Coates Fire Contract 3 600 101 34207 00 000 3 Other Billed Fire Calls 12,300 101 34303 00 000 Mow Weeds (C) 529 3,258 0 0 0 101 34306 00 000 Other Highway Street Rev (C) 150 14,130 0 0 2,000 Street Light Bills Developers 101 34407 00 000 City Share of Metro SAC Chgs (C) 4 365 3,395 4 086 3,000 3 000 Total Charges tor Services (C) 486 379 713 892 700 702 481,400 539 400 101 35101 00 000 Court Fines (F) 91,441 72,067 88 523 90,000 90 000 From County Total Fines Forfeits (F) 91,441 72,067 88 523 90,000 90 000 101 34720 00 000 Park Reservations (R) 89 1 175 1,695 1 500 1 500 101 34721 00 000 Softball Revenues (R) 4413 44,701 48,174 37,500 40000 101 34722 00 000 Volleyball Revenues (R) 6 71 4,78 3 350 9,400 2 500 101 34724 00 000 Tennis Revenues (R) 1 37 1 14 975 1 300 1 300 101 34725 00 000 Tiny Tot Revenues (R) 12,50 15 24 15 499 16 600 19 000 101 34726 00 000 Pom Pom Revenues (R) 2,30 1,91 3,152 2,500 3 000 101 34727 00 000 Field Trip Revenues (R) 4 53 2,52 2,159 2 800 2 800 101 34726 00 000 Broomball Revenues (R) 1 17 78 675 0 0 101 34729 00 000 Skating Lesson Revenues (R) 60 45 75 800 600 101 34730 00 000 Fun Rurs, Walks 8 Bike Rides (R) 1 71 1,71 2 988 1,000 1 800 101 34732 00 000 Adult Basketball (R) 1,02 1,26 2 370 700 1 900 101 34733 00 000 Other Programs Revenues (R) 9,21 11,15 6 277 3 500 5 500 101 34735 00 000 Summer Camps (R) 2,675 3 000 3,000 101 34736 00 000 T -Ball (R) 3794 320D 3500 101 34790 00 000 Other Recreation Revenues (R) 0 0 2 100 Promise Fellow Grant Program 101 38080 00 000 Banquet Room Fees (R) 55 49 60,22 57 025 52 500 54,000 101 38081 00 000 Auditorium Fees (R) 12 20 13,35 10,133 12,600 12 600 101 38082 00 000 Gymnasium Fees (R) 17,47 24 53 25 038 20 000 22 000 101 38064 00 000 Pistol Range Fees (R) 3,75 3,77 3 951 4 700 0 101 38086 00 000 Classroom Fees (R) 25,10 28,83 25,626 22,000 24 000 101 38096 00 000 Liquor Provider Fees (R) 1 54 1,44 1 500 2,000 2 000 101 38097 00 000 AN Rental Fees (R) 83 66 874 700 700 101 38150 00 000 Oper Gvm Fees (R) 0 1 000 0 101 38154 00 000 Teen Night Revenues (R) 4 98 4,35 4,917 4 600 4 800 Total Recreation Fees (R) 207 57 224 032 222 921 203,900 208 800 PAGE TOTALS 785 398 1 009 993 1,012,146 775,300 838 200 Comments Page Three July t0 2002 Account 101 36210 00 000 101 3621400 000 101 362'500 000 101 36220 00 000 10' 36230 00 000 101 3626000 000 101 39202 00 000 2003 BUDGET WORKSHEETS GENERAL FUND REVENUES Descnptlon Interest Earnings Investments (M) Net Change in FV- Investments (M) Interest Earnings (M) Rents Royalties (M) Contribution /Donations (M) Other Revenue (M) Total Misc Revenues (M) Contribution from Enterprises (T) Total Transfers In (T) PAGE TOTALS DEPARTMENT TOTALS INTERNAL REVENUES 2002 2003 Object 2003 1994 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 83,426 152 349 172,613 120,000 130,000 (31,095) 22 969 2,167 0 0 1 532 1,432 1,643 1,000 1,000 4 056 4,394 4 760 4 400 4 800 55315 44,146 77166 0 0 3 417 6 284 7 289 5 000 5 000 116 651 231,574 265 639 130 400 140 800 Annual Markel Value Changes From Checking Account US West Antenna Rent 3 500 3,500 3 500 3 500 3 500 Arena Bldg Grounds Malnt 3 500 3,500 3 500 3,500 3,500 $120151 $235,074 $269 139 $133900 9144,300 $2,045 066 $2 555 938 $2 558,208 31 811,589 $5 473,508 36 207,031 $6,445,745 $6 501 600 $7 338 100 $1 930 789 Grand Total Less Ad Valorem, LGA HACA, LPA Fiscal Drspanhes Page Four July 10 2002 2003 BUDGET WORKSHEETS GENERAL FUND REVENUES 101 34108 00 000 General Fund Admm Fees 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments $25,000 $25,000 $25,000 525,000 525,000 10' 34106 00 000 1 Fund 201 6,000 10 34108 00 000 2 Fund 202 2,500 101 34108 00 000 3 Fund 203 2,500 101 34108 00 000 4 Fund 206 2,500 101 34108 00 000 5 Fund 207 2,500 101 34'08 00 000 6 Fund 605 1,000 101 34 .08 00 000 9 Fund 606 1 000 '01 34108 00 000 11 Fund 607 1 000 101 34108 00 000'2 Fund 650 6,000 Admin Fees Breakdown Totals $25 000 $25 000 525 000 $25 030 $25 000 525,000 Page One July 10, 2002 Account 2003 BUDGET WORKSHEETS COUNCIL 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41110 103 Salaries Benefits $18 781 $19,048 $25 533 525,700 525,700 Salary, Taxes PERA Benefits 101 41110 01 307 Management Fees 19 781 13,672 20 004 15,500 18,000 101 41110 01 307 1 Newsletter 5 000 101 41110 01 307 2 Chamoe' of Commerce Directory 1,000 101 41110 01 307 3 Council Projects 12 000 101 41110 01 319 Other Professional Services 2,539 4,230 5,579 15,700 17,000 101 41110 01 319 1 Education Reimbursement 5,000 101 41110 01 319 2 Plammng Consultant 12,000 101 4'110 01 329 Other Communjcauon Costs 0 313 0 0 0 101 41110 01 331 Travel Expense 0 176 469 300 700 101 41110 01 433 Dues Subscriptions 11,546 4,259 13 106 13 800 14,500 101 41110 01 433 1 LMC Dues 10000 101 41110 01 433 2 AMM Dues 4 000 101 41110 01 433 3 NDCC Dues 500 101 41110 01 435 Books Pamphlets 62 0 0 100 100 101 41110 01 437 Conferences Seminars 4,946 2,741 2,061 3 500 3,500 101 41110 01 437 1 Registration Hotel -LMC Conf 2,000 101 41110 01 437 2 Miscellaneous Conferences 1,500 101 41110 01 439 Other Miscellaneous Charges 19,294 16,123 36,524 0 0 101 41110 01 598 Council Designated 21,160 2,767 11,199 14,000 14000 101 41110 01 598 1 Yearly Contingencies 14 000 PAGE TOTALS 598,107 $63,328 5114,475 588,600 593 500 DEPARTMENT TOTALS 598,107 563,328 5114475 $88 600 $93 500 Page One 2003 BUDGET WORKSHEETS ADMINISTRATION July 10 2002 2002 2003 Oblecl 2003 1999 2000 2001 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 41320 101 Salaries Benefits 5263 673 $232 990 $273,533 $305 200 $325 700 Salary Taxes PERA Benefits 101 41320 102 Full -Time Overtime 667 1,867 0 1 000 1 000 101 41320 01 207 Training Instructional Supplies 270 1,439 0 1,900 1 900 101 41320 01 207 1 Safety Committee 200 101 41320 01 207 2 Right to Know 1 200 101 41320 01 207 3 Employee Training 500 101 41320 01 209 Other Office Supplies [52 390 22 300 300 Miscellaneous Purcnases 101 41320 01 307 Management Fees 3,207 5 627 3 402 4,000 4 000 Labor Consultant 101 41320 01 331 Travel Expense 1,066 402 614 600 600 101 41320 01 331 1 State Conference -LMC 50 101 41320 01 331 2 State Conference MCMA 50 101 41320 01 331 3 Personnel Workshops 100 101 41320 01 331 4 ICMA Conference 400 101 41320 01 341 Employment Advertising 0 913 0 0 0 101 41320 01 353 Ordinance Publication 661 1 134 2 757 2 000 2,000 Codification of Code 101 41320 01 394 P C Software Purchases 0 3,111 2 061 0 0 101 41320 01 433 Dues Subscriptions 1,256 9,210 1 353 1,300 1 500 101 41320 01 433 1 MCMA Dues 75 101 41320 01 433 2 MAMA Dues 75 101 41320 01 433 3 MCFOA Dues 75 101 41320 01 433 4 IIMC Dues 100 101 41320 01 433 5 IPMA Dues 75 101 41320 01 433 B ICMA Dues 900 101 41320 01 433 7 SHRM Dues 200 101 41320 01 435 Books Pamphlets 60 309 385 100 100 101 41320 01 437 Conferences Seminars 1,892 3,100 1,543 3 000 3 000 101 41320 01 437 1 Registration Hotel LMC 300 101 41320 01 437 2 Registration Hotel MCMA 200 101 41320 01 437 3 Personnel Conferences 500 101 41320 01 437 4 Staff (1) Each 200 10 41320 01 437 5 Miscellaneous Seminars 400 101 41320 01 437 6 Registration Hotel ICMA 1,200 101 41320 01 437 7 Advanced Clerks School 200 101 41320 01 580 Other Equipment Purchases 0 0 0 900 PAGE TOTALS 5272,822 $260,493 5285,670 5320,300 DEPARTMENT TOTALS 5272,822 $260 493 $285,670 $320,300 5341,000 $341,000 900 Typewnter Organizer Paye One July 10 2002 Account 101 41410 103 101 4141001 203 101 4141001 208 101 41410 01 219 101 41410 01 242 101 41410 01 319 101 41410 01 321 101 41410 01 351 101 41410 01 409 101 41410 01 412 101 41410 01 439 2003 BUDGET WORKSHEETS ELECTIONS 101 41410 01 580 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Description Actual Actual Actual Budget Amount Budget Comments Part-Time Salaries Pnnted Forms Paper Miscellaneous Supplies Other Operating Supplies Minor Equipment Other Professional Services Telephone Costs Legal Notices Publishing Other Contracted Repair Maint Building Rental Other Miscellaneous Charges $0 $9,909 50 511,000 0 332 0 600 0 1082 0 1,000 O 197 0 300 O 1,551 0 2000 0 1,022 0 1000 O 10 0 0 0 54 0 100 0 0 0 800 0 0 0 500 0 0 0 0 0 1,136 10,200 5,700 S0 $15293 510,200 523,000 $0 $15,293 510,200 523 000 50 Election Judges -2 New Precincts 0 Ballots Programming 0 Election Purchases 0 Rolls for Election Judges 0 Booths Signs 0 0 0 Election Publica bons 0 Maintenance for Oplechs 0 Possible Rent for Locations 0 10 000 Off -Year For Future Equipment $10,000 $10 000 Page One July 10 2002 2003 BUDGET WORKSHEETS FINANCE 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account it Description Actual Actual Actual Budget Amount Budget Comments 101 41520 101 Salaries Benefits 101 41520 102 Full -Time Overtime All Salary Costs Inclusive of $104,284 $119,814 $136,004 $195 400 $206,300 Salary, Taxes, o f RA Benefits 164 307 1,910 500 500 101 41520 DI 319 Other Professional Services 5 800 0 0 10,000 10,000 F/A Reinventory Infrastructure 101 41520 01 331 Travel Expense 185 126 384 800 800 101 41520 01 331 1 Finance Director 600 National Convention Miss 101 41520 01 331 2 Staff 200 101 41520 01 391 PC Maintenance 28,324 24,539 36,584 39,000 43000 101 41520 01 391 1 Civic Systems Applications Support 10,000 101 41520 01 391 2 Civic Systems System Support 4 000 101 41520 01 391 3 General Network Support 25,000 250 Hours of Support Time 101 4'520 01 391 4 Motor Vehicle SW Ma int 1 000 101 41520 01 391 5 Fixed Asset Maml Contract 1 000 10' 41520 01 391 6 Miscellaneous P C Repairs 2,000 101 41520 01 392 P C Accessories Supplies 1,077 2,384 1,133 3,000 3,000 City System Supplies 101 41520 01 393 P C Hardware °urchases 831 607 1,203 2,000 2 000 101 41520 01 394 P C Software Purchases 2,631 0 95 1,000 1 000 101 41520 01 409 Other Contracted R M 140 245 100 300 300 Cash Register Repairs 101 41520 01 433 Dues Subscriptions 277 120 381 600 800 101 41520 01 433 1 MDRA Annual Fees 200 101 41520 01 433 2 MGFOA Finance Director 50 101 41520 01 433 3 MGFOA Staff 50 101 41520 01 433 4 GFOA Finance Director 200 101 41520 01 433 5 Magazine Subscriptions 100 101 41520 01 435 Books Pamphlets 33 53 0 200 200 101 41520 01 435 1 Accounting Related Books 100 101 41520 01 435 2 Finance Related Books 100 101 41520 01 437 Conferences Seminars 1,109 1,104 2,017 2,000 3 000 101 41520 01 437 1 MORA Conference (For 2) 200 101 41520 01 437 2 MGFOA Annual Conf (FD) 300 101 41520 01 437 3 GFOA National Conf (F!D) 1,000 101 41520 01 437 4 Management Classes 1,000 101 41520 01 437 5 Miscellaneous Seminars 500 101 41520 C1 439 Other Miscellaneous Charges 166 108 209 500 500 Contigencies 101 41520 01 570 Office Equipment Furnishings 0 417 0 0 0 PAGE TOTALS $145,020 $149,825 $180,000 8255 300 $271,200 DEPARTMENT TOTALS $145,020 $149,825 $180,000 $255 300 $271,200 Page One July 10, 2002 Account 101 41810 01 301 101 4181001 301 1 101 41810 01 3012 101 41810 01 301 3 101 4181001 301 4 101 41810 01 304 101 4181001 319 101 4181001 319 1 101 41810 01 319 2 101 41610 01 319 3 101 41810 01 319 4 101 41810 01 320 101 4181001 321 101 41810 01 321 1 101 41810 01 321 2 101 4181001 321 3 101 41810 01 322 101 4181001 328 101 41810 01 329 101 41810 0' 3291 101 41810 01 329 2 101 41810 01 329 3 101 4181001 339 101 41810 01 351 101 41810 01 351 1 101 41810 01 351 2 101 41810 01 351 3 2003 BUDGET WORKSHEETS GENERAL GOVERNMENT Description 101 41810 01 202 Duplicating Copying 101 41810 01 202 1 Records Retention 101 41810 01 202 2 Copying Casts 101 41810 01 203 Printed Forms Paper 101 41810 01 203 1 Copy Paper 101 41810 01 203 2 General Receipt Books 101 41810 01 203 3 Purchase Orcers 101 41810 01 203 4 Payroll Checks 101 41810 01 203 5 A/P Checks 101 41 810 01 203 6 Greenba' Computer(30 Boxes) 101 41810 0 204 Envelopes 8 Letterheads 101 41810 01 204 1 Letterhead 101 41810 01 204 2 Plain Envelopes 101 41810 01 204 3 NP Payroll Envelopes 101 41810 01 204 4 10 x 13 Envelopes 101 41810 01 204 5 10 x 15 Envelopes 101 41810 01 209 Other Office Supplies 10' 41810 01 221 Equipment Parts 101 41810 01 242 Minor Equipment 101 41810 01 242 1 Stale Purchasing Program 101 41810 01 242 2 Fax Machine Maint Agreement 101 41810 01 242 3 HP 551 Ranter Maintenance 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $8,627 $12,367 $20,160 513,000 3,925 10,109 4,714 10,000 2 689 3,488 760 3,500 Auditing 8 Accounting Services 33 466 34,093 37,201 46,000 2001 Audit 8 General Consulting Dakota County Assessment Fees Oak Cty Truth In Taxation Costs Pnnting of Budget Books Legal Fees 44,118 51,577 45,864 75000 Other Professional Services 28,942 50,062 42,298 4 500 Fire Relief Association Flex Admm Plan Fees SWWC Co- operative Dues Continuing Disclosure Fees Credit Card Activity Fees 0 0 477 0 Telephone Costs 47,910 53,085 54,926 59,600 General Phone Costs E -Mad Server Costs Web Server Costs Postage Costs 14 936 12,937 10 686 16,000 Cable Supply Costs 0 0 0 0 Other Communication Costs 0 5,214 21 298 31,000 Cable JPA Payment General Cdy Cable JPA Payment Port Authority Addition Cable TV Programming Other Transportation Expenses 253 669 135 800 Legal Notices Publishing 4,624 2,740 3,238 5,600 Costs for Public Notices Truth in Taxation Notices Budget 8 Audit Publications 101 41810 01 439 Other Miscellaneous Charges 101 41810 01 580 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 115 100 188 0 10,000 15,000 2 500 1 200 1 200 1 100 2 200 1 800 1,100 600 800 600 400 13,558 14,079 15 887 15000 16 000 General Office Supplies 95 903 0 500 500 City Hall Equipment Repairs 734 350 674 1,200 1,200 350 250 600 50,000 5 000 3,000 2,000 3,400 1,000 1,200 0 2,500 500 5,000 55,000 4,000 1,000 35 000 5 000 30 000 525,000 10,000 3 500 60 000 $215 094 $266 818 $269479 5298,700 $370 000 Yearly Fees for Program Increased GASB Requirements 75,000 General City Legal Fees 8,000 Moved to Fire Dept Budget Insurance Plans Fees Paid to Springsted (Bonds) 1 000 60,000 Monthly Billings Insurance Plans 16,000 400 Tapes 8 Reimbursable Costs 70 000 Insurance Plans 800 General Costs 5 600 All Departments Billing from Dakota County State Mandated Publications 0 11,102 15,023 10,973 17,000 17,000 Copy Machine Leases All Bldgs (Fax Machine 8 Postage Meter) 5215,094 $266,818 5269 479 $298 700 5370,000 Page One July 10, 2002 Account Description 101 41910 101 41910 101 41910 101 41910 101 41910 101 41910 101 4191001 201 101 41910 01 202 101 41910 01 203 101 41910 01 205 101 41910 01 208 101 41910 01 209 101 41910 01 219 101 4191001 241 101 41910 01 305 101 41910 01 312 101 41910 01 319 10 41910 01 329 101 4191001 331 101 41910 01 341 101 4191001 391 101 4191001 392 101 4191001 433 101 4191001 433 1 101 41910 01 4332 101 41910 01 433 3 101 41910 01 4334 101 41910 01 4335 101 41910 01 4336 101 4191001 4337 101 41910 01 433 8 101 41910 01 433 9 101 41910 01 435 101 41910 01 437 101 41910 01 4371 101 41910 01 4372 101 41910 01 437 3 101 41910 01 4374 101 41910 01 4375 101 4191001 437 6 101 41910 01 437 7 101 4191001 437 8 101 4191001 437 9 101 4191001 437 10 101 41910 01 43711 101 41910 01 439 101 41910 01 570 2003 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT 101 Salaries Benefits 102 Full -Time Overtime 103 Part -Time Satanes Benefits 103 1 Interns 103 2 PrT Building Secretary 103 3 Planning Commission Members Office Accessories Duplicating Copying Printed Forms Paper Drafting Supplies Miscellaneous Supplies Other Office Supplies Other Operating Supplies Small Tools Medical Dental Fees Contract Inspection Fees Other Professional Services Other Communication Costs Trat,el Expense Employment Advertising PC Mainlenance P C Accessories Supplies Dues Subscriptions APA/AICP ICBC North Star Lake Country iAPMO National Stale Trade Magazines Planners Journal Sensible Land Use Coalition Secretaries Association Books Pamphlets Conferences Seminars State Bldg Official School Spring Fall Code Updates ICBO Seminars (2 TimesNear) Computer Training Clerical Seminars Planning Seminars ISTS Training State Planning Conference (2) Planning Commissioner Training Gen I Seminars (Motivational) Other Bldg Inspection Training Other Miscellaneous Charges Office Equipment Furnishings PAGE TOTALS DEPARTMENT TOTALS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 5320,369 5354,471 5459,553 $601 500 $700,700 Salary Taxes PERA Benefits 968 1 507 438 3 000 3 000 Add Assistant Planner 31,463 7,288 25,340 55,400 56,600 2 020 0 223 400 99 0 0 500 1 057 736 1,060 2200 0 0 0 100 0 59 121 200 121 187 238 300 143 22 1,246 500 250 0 490 400 0 227 76 0 20 768 0 0 0 1 740 5,077 3 346 1,000 863 213 1,288 1 500 305 228 191 500 8 737 4 883 906 1,000 80 3 980 2,016 6,000 2016 1,495 65 1000 1,021 1,083 1,311 1 900 3,502 3,897 3,270 6,000 176 46 0 799 5395,645 5386 431 5395 845 5366 431 531 400 0 0 $501,797 $684,700 5501 797 5684 700 17,500 34 100 5,000 500 300 1 400 400 500 500 500 800 300 400 400 400 Calendars Planners etc 200 Annual Codification Zoning Ord 1 200 Forms Stickers Tags etc 100 Zipalone Sp-ay Mount 200 Calculators 600 Dictation Devices Tapes 900 Building Inspection Supplies 400 Inspectors Tools 0 0 Fees for Contracted/Temp Sery 2 000 Planning Consultant 1,500 Cellular Phone Pagers 500 1 000 6 000 SNV Maint Permitworks Support 500 1 900 600 400 Dues for Additional Inspector 200 150 50 150 100 150 100 147 234 89 900 400 Manuals References IBC Books 6 000 0 $784 500 $784,500 4 Persons $175 Code Enforcement Seminars 400 Contingencies Page One July 10, 2002 Account 101 42110 10' 42110 101 42110 101 42110 101 42110 101 42110 01 202 101 4211001 203 101 42110 01 204 101 4211001 207 101 42110 01 207 1 101421100' 2072 101 42110 01 208 101 4211001 209 101 42110 01 211 101 42110 01 211 1 101 4211001 211 2 101 42110 01 217 101 4211001 219 101 42110 01 221 101 4211001 241 101 42110 01 242 2003 BUDGET WORKSHEETS POLICE Description 101 Salaries Benefits 102 Full -Time Overtime 102 1 Regular Overtime Hours 102 2 Contracted 07 103 Pan -Time Salaries Benefits Duplicating Copying Pnnted Forms Paper Envelopes Letterheads Training Instructional Supplies Practice Ammunition Service Ammunition Miscellaneous Supplies Other Office Supplies Cleaning Supplies Blanket Cleaning Squad Interior Cleaning Clothing Allowance Other Operating Supplies Equipment Pans Small Tools Minor Equipmenl 101 42110 01 304 Legal Fees 101 42'10 01 305 Medical Dental Fees 101 42110 01 305 1 Miscellaneous Fees 101 42110 01 305 2 Narcotic Testing 101 42110 01 306 Personnel Testing Recruitment 101 42110 01 316 Animal Care Services 101 42 01 316 1 Impound Care Fees 101 42110 01 315 2 Deer Inventory 101 42110 01 319 Other Professional Services 101 42110 01 319 1 Dispatch Services 101 42110 01 319 2 Radio Repeater Phone Lines 101 42110 01 321 Telephone Costs 101 42110 01 321 1 Cell Phones 101 42110 01 321 2 Pagers 101 42110 01 321 3 LOGIS Line 101 42110 01 323 Radio Units 101 42110 01 331 Travel Expense 101 42110 01 331 1 MCPA Conference 101 42110 01 331 2 IACP Conference 101 42110 01 331 3 Oulstate Investigations Conferences 101 42110 01 331 4 Juvenile Officers Conference 101 42110 01 333 Freight Express Expenses 101 42110 01 341 Employment Advertising 101 42110 01 394 P C Software Purchases 101 42110 01 396 Computer Maintenance 101 42110 01 396 1 LOGIS Records CAD 101 42110 01 396 2 CJDN Connection Charges 101 42110 01 396 3 MCD Connection Charges 101 42110 01 396 4 MCC Maintenance Charges PAGE TOTALS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 1,069 400 1,108 455 1,190 076 $1,383,530 $1 581,500 Salary, Taxes PERA Benefits 66 280 58 601 78,563 50 000 70 000 Add Sergeant Officer 23,161 22 000 26 722 42,400 589 723 694 766 576 926 108 48 230 3 247 1,697 1,558 4,007 6 484 6 273 0 1,620 1289 1,796 2,000 31 288 9 400 0 4,426 2,518 3,000 2,613 927 1171 1000 691 2,595 1,156 2500 339 1,253 1,313 1,500 0 0 5,761 1,500 54 996 54,996 54,996 56 000 1,334 849 840 1,000 2 657 300 4 732 4 500 13,293 16,097 12 074 14,000 55344 63,678 54,950 61,000 8,784 13,085 6,940 6,000 1,903 2,303 1,389 3,000 2 252 2,556 2 030 3,000 95 676 0 17 711 7 58 200 779 416 1,000 0 0 1,200 30,169 39 046 49,000 45 000 25,000 500 800 Film Developing 1 000 1 000 Evidence Logs Animal Lit etc 200 200 2 500 2 500 2,000 500 100 300 500 500 14 000 1,200 61,500 3 500 4,900 600 500 500 1,500 700 300 1,331,897 1,394,362 1,498,247 1 671,900 1,912,000 28,000 P/T CSC's Total 50 Hrs/Wk 0 Donated Forfeited Funds 2 000 Video, Audio Tapes Misc 400 3,000 CSO /Reserve /Chaplai^ Uniforms 1,000 Evidence Bags 1st Aid Drug Kits 2 500 Squao Emergency Equip Repairs 1 500 Crime Scene Kit Supplies 1,500 Less Lethal Supplies 56 000 Prosecution 1,000 4,500 Career /Recruiting Fairs, Hong 15 200 65.000 6 000 3,000 Radio Radar Repairs 3 000 200 Repairs 1 000 Officer Hiring 1,200 Criminal Justice Integration Prot 60 000 43,000 3,000 4 000 10 000 Moved from (319) Above Page Two July 10 2002 2003 BUDGET WORKSHEETS POLICE 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Descnption Actual Actual Actual Budget Amount Budget Comments 101 42110 01 409 Other Contracted Repair 8 Maint 0 0 0 0 0 101 42110 01 415 Other Equipment Rental 0 0 0 500 500 101 42110 01 433 Dues 8 Subscriptions 453 2,118 1,548 2,000 3,000 101 42110 01 433 1 Mutual Aid Assistance Group 1,200 101 42110 01 433 2 IACP Chiefs Dues 150 101 42110 01 433 3 MN Chiefs of Police Dues 150 101 42110 01 433 4 Dakota Cty Chiefs of Police 50 101 42110 01 433 5 Wakota CAER Dues 20 101 42110 01 433 6 Metro Emergency Managers 25 101 42110 01 433 7 MN Ser Crimes Investigators 30 101 42110 01 433 8 Tri-County Investigators 50 101 42110 01 433 9 Miscellaneous 525 101 42110 01 433 10 P O 5 T Licenses 800 101 42110 01 435 Books 8 P amphlets 53 184 223 300 300 Statutes, Crime Prevention 101 42110 01 436 Towing Charges (31) 218 318 200 200 101 42110 01 437 Conferences 8 Seminars 8 692 10,200 9 435 12,000 12 000 101 42110 01 437 1 Firearms Training 1,500 101 42110 01 437 2 Chiefs Spring Training 500 101 42 01 437 3 Chiefs Fall Conference 200 101 42110 01 437 4 IACP Conference 400 101 42110 01 437 5 Emergency Management 400 101 42110 01 437 6 Miscellaneous 9,000 101 42110 01 439 Other Miscellaneous Charges 569 50 204 500 500 Contingencies 101 42110 01 580 Other Equipment Purchases 329 430 286 600 4 000 Digital Recorders PAGE TOTALS 510,066 $13 200 $12015 516 100 $20500 DEPARTMENT TOTALS $1,341,963 51 407 562 51,510,261 51,688,000 51,932,500 Page One July 10, 2002 Account 101 42210 101 42210 101 42210 101 42210 101 42210 101 42210 101 42210 2003 BUDGET WORKSHEETS FIRE Description 103 Salaries Benefits 1031 Salaries 103 2 T- aining Pay /Stipends 103 3 Call Pay/Stipends 103 4 Class Pay /Stipends 103 5 Fire Relief Pension Contnbutions 103 6 P/T Fire Marshal 101 42210 01 202 Duplicating Copying 101 42210 01 202 1 Copy Toner 101 42210 01 202 2 Laser Printer 101 42210 01 202 3 Fax Machine 101 42210 01 204 Envelopes Letterhead 101 42210 01 204 1 Envelopes 101 42210 01 204 2 Letterhead 101 42210 01 204 3 corms 101 42210 01 208 Miscellaneous Supplies 101 42210 01 208 1 Supplies Computer Support 101 42210 01 208 2 Film Developing 101 42210 01 208 3 Memberships 101 42210 01 208 4 Code Books 10' 42210 01 208 5 Training 101 42210 01 211 Cleaning Supplies 101 42210 01 211 1 Soap 101 42210 01 211 2 Chamois Towels, etc 101 42210 01 211 3 Sponges etc 101 42210 01 211 4 SCBA Cleaner 101 42210 01 218 Fire Department Clothing 101 42210 01 219 Other Operating Supplies 101 42210 01 219 1 Gloves 101 42210 01 219 2 Bandages 101 42210 01 219 3 Equipment 101 42210 01 219 4 Tyvek Suits 101 42210 01 219 5 Consummable Medical 101 42210 01 219 6 Oxygen 101 42210 01 229 Other Maintenance Supplies 101 42210 01 229 1 Aerial- Pumpers- Tanker 101 42210 01 229 2 Pickup Trucks 101 42210 01 229 3 Rescue Other 101 42210 01 229 4 Vehicle Modifications 101 42210 01 230 Equipment Repair Materials 101 42210 01 230 1 Light Bars 101 42210 01 230 2 Smoke Machines 101 42210 01 230 3 Lanterns 101 42210 01 230 4 Small Tool Repairs 101 42210 01 230 5 Opticom 101 42210 01 230 6 Station 101 42210 01 241 Small Tools 101 42210 01 241 1 Axes, Bars Other 101 42210 01 241 2 Grass Fire 101 42210 01 241 3 Hand Tools 101 4221001 305 101 42210 01 306 101 4221001 306 1 101 42210 01 306 2 101 4221001 306 3 101 42210 01 3064 101 42210 01 308 101 42210 01 308 1 101 4021001 308 2 101 4221001 308 3 101 42210 01 308 4 101 422100 308 5 101 42210 01 308 6 101 4221001 308 7 Medical Dental Fees Personnel Testing Recruitment New Physicals (4) Hepatitis Shots (4) Background Checks (4) Drug Testing (4) Instructors' Fees Fire Fighter 1 (4) Fire Fighter 1 Certificates (4) Fire Fighter Re- Certificates (7) First Responder (4) First Responder Refresher (112) Outside Schools ($12) Haz -Mal Training (4) PAGE TOTALS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $104 666 $123,789 $130 003 $194 500 138 132 113 100 108 103 61 100 2,281 3,367 2,675 4,500 80 123 156 493 174 300 222 300 564 521 2 256 1,000 12,351 4,178 13,032 2,900 1,441 834 634 1,465 1,500 439 491 700 6,632 4,784 5,141 10,800 18,100 2 000 13,750 150 135,000 30,600 1,500 100 300 500 1,000 100 100 25 75 300 80 100 70 800 150 2,300 200 200 200 100 150 150 500 300 300 150 250 300 1,000 500 100 500 1,200 140 180 1,000 1 400 5,900 1 000 25 25 50 25 25 50 10 800 131,612 142 379 158,647 221,400 227,800 All Salary Costs Inclusive of $199 600 Salary Taxes 'ERA Benefits Reduced Balance to Pension Reduced Balance to Pension Reduced Balance to Pension Reduced Balance to Pension $26 000 from Gen'I Govt Bal New 100 100 3,400 Supplies for Fire Marshal 300 300 5 Uniforms $60 Each 1,500 Medical Supplies 2 900 1,500 700 1,930 1,995 1 755 2 600 4 500 Annual Medical Tests 467 1,786 1,260 2,100 2 100 Page Two July 10, 2002 2003 BUDGET WORKSHEETS FIRE 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account 4 Description Actual Actual Actual Budget Amount Budget Comments 101 42210 01 310 Testing Services 1,776 1381 1,545 900 1,500 101 42210 01 310 1 Aerial (Next 2005) 0 101 42210 01 310 2 Ladders (Next 2005) 500 101 422'0 01 310 3 Pumpers (3) (Next 2004) 0 10 42210 01 310 4 3CBA Hyaro Testing (Next 2008) 1 000 10 42210 01 313 Temporary Service Fees 1,065 838 872 1,400 6 400 01 42210 0' 3131 SCBA Contract 400 01 42210 01 313 2 SCBA Maintenance 200 101 42210 01 313 3 Copier Contract 400 101 42210 01 313 4 Security Conrac 400 101 42210 01 313 5 Technical Team Joint Powers 5000 101 42210 01 319 Other Professional Services 1,712 7 870 2 232 2 300 2 500 Fire Prevention Education 101 42210 01 319 1 School Literature 350 101 42210 01 319 2 Door Prizes 250 101 42210 01 319 3 Fire Prevention Week Promos 1,300 101 42210 01 319 4 Food at Open House 150 101 42210 01 319 5 Adult Extension Classes 250 101 42210 01 319 6 Trading Cards 200 101 42210 01 321 Telepnone Costs 225 276 230 300 600 101 42210 01 321 1 Chief 150 101 42210 01 321 2 Assistant Chief 150 101 42210 01 321 3 Rescue 150 101 42210 01 321 4 Numenc Pagers 150 101 42210 01 322 Postage Costs 0 10 0 100 100 UPS Costs 101 42210 01 329 Other Communication Costs 391 820 1,100 1,000 1 000 101 42210 01 329 1 Base Repairs 200 10' 42210 01 329 2 Pager Repairs 200 101 42210 01 329 3 Hand Held Repairs 300 101 42210 01 329 4 Mobile Repairs 300 101 42210 01 331 Travel Expense 2115 3 942 4,613 7,800 7 600 101 42210 01 331 1 Minnesota Chiefs Conference 1,100 101 42210 01 331 2 Fire Department Association 900 101 42210 01 331 3 Outside Schools 5,800 101 42210 01 433 Dues 8 Subscriptions 541 475 545 700 900 101 42210 01 433 1 Capital City 35 101 42210 01 433 2 VFBA Insurance 160 101 42210 0 433 3 State Fire 170 101 42210 01 433 4 State Chiefs 250 101 42210 01 433 5 DCFC 30 101 42210 01 433 6 WAKOTA Mutual Aid 20 101 42210 01 433 7 Purchasing Consortium 35 101 42210 01 433 8 NFPA 100 101 42210 01 433 9 MN Assn Fire Marshals 100 Fire Marshal Dues 101 42210 01 437 Conferences 8 Seminars 270 405 405 700 700 101 42210 01 437 1 State Fire Conference 400 101 42210 01 437 2 State Chiefs Conference 300 101 42210 01 439 Other Miscellaneous Charges 706 759 981 1,200 1200 101 42210 01 439 1 Food 8 Coffee 190 101 42210 01 439 2 Extinguisher 400 101 42210 01 439 3 Plaques 20 101 42210 0^ 439 4 Paint 50 101 42210 01 439 5 Station Needs 540 101 42210 01 580 Other Equipment Purchases 12,358 18,312 10,138 17,000 15,000 101 42210 01 580 1 Bunker Gear (9) 9,000 101 42210 01 580 2 Pagers (6) 3,000 101 42210 01 580 3 Hose Replacement 2,000 101 42210 01 580 4 Replace Damaged Items 1,000 101 42210 01 581 Other Equipment Purchases 1,709 0 18,450 0 0 PAGE TOTALS $22 871 529 098 $41 108 $33 400 537 700 DEPARTMENT TOTALS 5154 482 5171 477 5199 755 5254,800 5265 500 Page One July 10 2002 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account# Descnpton Actual Actual Actual Budget Amount Budget Comments 101 41940 101 101 41940 79 101 101 41940 102 101 41940 01 208 101 41940 01 223 101 41940 01 225 101 41940 01 241 101 41940 01 242 101 41940 01 302 Architects' Fees 101 41940 01 318 Contract Engineer 101 41940 01 319 Other Professional Services 101 41940 01 319 1 Elevator Maintenance 101 41940 01 319 2 Heating /Cooling Maint Contract 101 41940 01 319 3 Annual RPZ Inspection 101 41940 01 319 4 Pest Control 101 41940 01 319 5 Fire Extinguishers 101 41940 01 319 6 Fire Suppression System Cheur 101 41940 01 319 7 Janitorial Service New Fire Station 101 41940 01 319 8 Janitorial Service -P W Building 101 41940 01 341 Employment Advertising 101 41940 01 381 Electric Utilities 101 41940 01 383 Gas Utilities 101 41940 01 384 Refuse Dispose 101 41940 01 384 1 General Buildings Parks 101 41940 01 384 2 Recycling /Cleanup 101 41940 01 389 Other Utility Services 101 41940 01 401 101 4194001 401 1 101 41940 01 401 2 101 41940 01 401 3 101 41940 01 412 101 41940 01 415 101 41940 01 439 101 41940 01 601 101 4 01 611 101 41940 01 621 2003 BUDGET WORKSHEETS GOVERNMENT BUILDINGS Salaries Benefits Maintenance Full -Time Overtime Miscellaneous Supplies Building Repair Supplies Landscaping Materials Small Tools Minor Equipment Contracted Bmldtng Repairs Electrical Repairs Miscellaneous Siren Repairs Miscellaneous Repairs Building Rental Other Equipment Rental Other Miscellaneous Charges Bond Principal Bond Interest Bond Paying Agent Fees PAGE TOTALS DEPARTMENT TOTALS 545,268 $37,215 $42,195 545,500 2 523 3,794 4,055 3,000 16 084 13,691 12,299 15,500 3 164 704 4 499 4 000 0 0 0 500 0 455 458 200 0 0 2,125 2 000 572 0 0 1,000 0 0 4,958 5,100 20,650 24,452 15,977 18,800 0 0 32,680 34,758 16 333 28,708 15 135 16,245 2,613 3,122 30,768 9 676 6,000 202 0 0 188 2,328 26,832 26,632 63 666 62 187 0 0 5282,277 5264,148 5282,277 $264 148 48,600 1,000 5,000 1,500 500 1 000 1,000 3,500 7 800 374 0 33 199 40 000 38710 40000 21,203 28,000 18,000 10,000 3,219 3,000 14,375 14,000 1,500 3,000 9,500 0 0 146 1 000 0 1,000 29 053 31 500 60,545 55 800 390 0 5287,780 $312,900 3287 780 $312 900 All Salary Costs Inclusive of 548,600 Salary, Taxes PERA Benefits 4 000 17,000 4,000 500 200 2 000 1 000 Estimates 5 100 Contracted Engineer for City 21 300 5321 800 5321 800 0 40,000 40 000 28 000 Cleaning Supplies Towels etc Trees Shrubs Hand Tools Bits Blades etc Carpet Cleaner Replacement 3,000 Floor Mats Monthly Charges 14,000 0 1 000 1 000 U 0' M Storage (To CIP) Scaffolding Cleaners Conttngenctes 33,900 MSABC Payment (2/1) 56,800 MSABC Payments (2/1 811) 400 Page One July 10, 2002 2003 BUDGET WORKSHEETS FLEET MAINTENANCE 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 43100 101 Salaries Benefits 5116 201 $122 333 5120,844 $127 B00 $135 400 Salary Taxes PERA Benefits 101 43100 77 101 Administrative 18,000 101 43100 79 101 Maintenance 117,400 101 43100 102 Full -Time Overtime 7,993 9,958 5 596 8,000 8 000 101 43100 99 103 Part-Time Salaries Benefits 0 0 0 4,000 0 101 43100 01 211 Cleaning Supplies 517 565 711 500 500 Shop Vehicles 101 43100 01 212 Motor Fuels 41,171 69,424 59 889 75,000 75 000 101 43100 01 213 Lubricants Additives 7 464 2 804 2 598 5,500 5 500 101 43100 01 215 Shop Materials 15 201 18,618 17 412 20 500 20 500 101 43 01 221 Equipment Parts 87 245 82 588 84 588 85 000 87 000 131 43 00 01 222 Tires 19 293 5 707 9 126 15 000 20 0000 101 43100 01 241 Small Tools 4 364 4 565 4,024 4 4 000 101 43100 01 242 Minor Equipment 14 254 487 3 857 4,000 6 000 101 43100 01 318 Contract Engineer 0 0 5,915 10,000 10,000 Contracted Engineer for City 43100 01 321 Telephone Costs 1,019 304 0 0 0 101 43100 01 323 Radio Units 1,612 1,079 737 2000 2000 Repair /Replace Units 101 43100 01 331 Travel Expense 5 0 0 500 500 Overnight Training 101 43100 01 341 Employment Advertising 333 0 718 0 0 101 43100 01 384 Refuse Disposal 417 1 036 1,518 1,000 1 000 Shop Hazardous Waste 101 43100 01 394 P 5 Software Purchases 485 1 173 252 500 500 General Software Support 101 43100 01 404 Contracted Mach Equip Repairs 22 428 32,493 17,304 30 000 35 000 101 43100 01 416 Machinery Rental 125 0 0 1,000 1000 101 43100 01 417 Uniforms Rental 83 112 118 0 0 101 43100 01 433 Dues Subscriptions 0 0 0 0 0 101 43100 01 435 Books Pamphlets 619 0 0 200 200 101 43100 01 437 Conferences Seminars 523 1,640 165 1,000 1 000 PAGE TOTALS 5341,352 5354,888 5335 171 $395 500 5413 100 DEPARTMENT TOTALS $341,352 $354 888 5335 171 $395 500 5413 100 Page One July 10 2002 101 43121 01 303 101 43121 01 304 101 43121 01 305 101 43121 01 310 101 43121 01 318 101 43121 01 319 101 43121 01 321 101 43121 01 324 101 43121 01 331 101 43121 01 341 101 43121 01 381 101 43121 01 381 1 101 43121 01 381 2 101 43121 01 384 101 43121 01 3841 101 43121 01 3842 101 43 21 01 384 3 101 43121 01 391 101 43121 01 391 1 101 43121 01 391 2 101 43121 0' 391 3 101 43121 01 392 101 43121 01 394 2003 BUDGET WORKSHEETS STREET MAINTENANCE 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account# Descnpbon Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 43121 101 Salaries Benefits $304,024 $313,463 $332 520 5405,800 $428,300 Salary Taxes PERA Benefits 101 43121 77 101 Administrative 73,700 101 43121 78 101 Technical /Clerical 68,300 101 43121 79 101 Maintenance 288 300 101 43121 102 Full -Time Overtime 10,772 17,614 13,931 18,000 18,000 Maintenance 101 43121 99 103 Part-Time Salaries Benefits 22,903 19,106 14,139 20 000 20,000 101 43121 01 201 Office Accessories 101 4 3121 C1 203 Printeo Forms 8 Paper 101 43121 01 203 1 RAN Permit Inspection Forms 101 43121 01 203 2 Work Orders 101 43121 01 205 Drafting Supplies 101 43121 01 205 1 Paper for Plan Reproductions 101 43121 01 205 2 Off Site Reproductions 101 43121 01 205 3 Fitm Developing 101 43121 01 205 4 Miscellaneous Tools 101 43121 01 209 Other Office Supplies 101 43121 01 216 Chemical Chemical Products 101 43121 01 224 Street Maintenance Materials 101 43121 01 224 1 Paint 101 43121 01 224 2 Mail Boxes 101 43121 01 224 3 Light Bulbs /Lenses 101 43121 01 225 Landscaping Materials 101 43121 01 225 1 Sod 101 43121 01 225 2 Seed 101 43121 01 225 3 Black Dirt 101 43121 01 225 4 Trees 101 43121 01 226 Sign Repair Materials 101 43121 01 231 Bituminous Patching Materials 101 43121 01 232 Crushed Rock 101 43121 01 233 Dust Control Materials 101 43121 01 234 De -Icing Sand 101 43121 01 235 Shouldering Gravel 101 43121 01 241 Small Tools 101 43121 01 242 Minor Equipment Engineering Fees Legal Fees Medical Dental Fees Testing Services Contract Engineer Other Professional Services Telephone Costs Messenger Services Travel Expense Employment Advertising Electric Utilities Street Lights Signal Lights 8 Sirens Refuse Disposal Hazardous Waste Disposal Roadside Garbage Tree Disposal P C Maintenance Gopher State One -Call State Aid Pavement Plus SAN Support P C Accessories 8 Supplies P S Software Purchases PAGE TOTALS 0 0 61 700 700 28 60 298 700 700 500 200 1,386 850 1,790 1 800 2,000 450 Inspection Equipment 20 31 61 200 200 Door Tags 18 576 19,114 13,861 25,000 25,000 De Chemicals (Salt) 62,592 1,173 514 1,500 1 500 3 003 2,664 547 6,300 6,300 3 000 300 2 000 1,000 5,6 13 66 3,51 38 33 67 27 33 2,37 76,42 900 450 200 500 500 500 2,656 6,362 5,000 5,000 22,907 17 826 25 000 27,000 16,991 19 046 18,000 25 000 19,006 24095 22,000 25000 7,380 8 543 8 000 8 000 313 1,681 3,000 3,000 834 895 1 000 1,000 Shovels Brooms etc 3,214 4,342 4,000 4 000 Safety Equipment 17,909 15,138 8,500 8 500 General Non Project Related 2 701 13 2,000 2,000 Appeals of Closed Projects 188 204 600 600 Employment Physicals 75 0 1200 1200 0 0 20,000 20 000 Contracted Engineer for City 558 402 1 500 1,500 Randor, Drug Testing 1,882 3 209 2 000 2 000 Cellular Phones Pagers 0 0 100 100 165 8 1,000 1,000 APWA Miscellaneous 5,900 1 673 1 000 1 000 87 283 95,210 90,000 100 000 95,000 5,000 306 867 351 2,600 2600 1 000 1,000 600 6,279 7,973 3 522 5,700 5 700 2,200 1 000 2 500 0 0 14 0 0 0 4,089 1 841 600 600 General Software Support 520 659 576 963 582,096 702 600 747 500 Page Two July 10 2002 Account 2003 BUDGET WORKSHEETS STREET MAINTENANCE Description 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 101 43121 01 402 Street Seal Coating 0 31 577 36 646 60,000 135,000 101 43121 01 402 1 General Seal Coating 115 000 8 to 9 Miles Added 101 43121 01 402 2 City Hall, Schwarz Connemara 20,000 Parking Lots 101 43121 01 403 Contracted Repair 8 Maintenance 145 260 2,487 0 7,000 7000 101 43121 01 403 1 Street Lights 6,000 101 43121 01 403 2 Signal Lights 500 101 43121 01 403 3 Light Replacements 500 1 D1 43121 01 405 Street Striping 15 941 13,214 19 000 26 000 131 43121 01 406 Street Sweeping 3 752 2 462 6,500 10 000 101 43121 01 407 Bituminous Overlays 16 338 45 000 25 000 0 101 43121 01 408 Street Crack Sealing 9 843 10 000 20 000 35 000 101 43121 01 409 Tree Trimming 48 10 546 6 342 10 000 10,000 101 43121 01 410 Concrete Sidewalk/Curb Repairs 3 585 4,316 5 000 133 000 101 43 21 01 410 1 General Repairs 8,000 101 43121 01 410 2 Pedestrian Imorovemenls 125,000 101 43121 01 411 Snow Removal Community Center 780 11,452 8,398 12,000 12,000 101 43121 01 415 Grader /Dozer Rental 0 0 4,047 2000 2000 101 43121 01 416 Snow Plow Loader Rental 18 391 7 840 18 202 13 000 13 000 101 43121 01 418 Snow Plow Rental 0 0 1 251 2,000 2 000 101 43121 01 420 Truck Rentals 0 3 691 2 423 2,000 2 000 101 43121 01 433 Dues 8 Subscriptions 604 670 830 900 900 101 43121 01 433 1 American Public Works Assn 225 (APWA) 101 43121 01 433 2 Reques for Mutual Aid Ass'n 10 (RMAA) 101 43121 01 433 3 City Engineers' Association 150 101 43121 01 433 4 Professional Secretaries 90 101 43121 01 433 5 MN Society for Professional Engineers 300 (MSPE) 101 43121 01 433 6 American Society of Civil Engineers 125 (ASCE) 101 43121 01 435 Books Pamphlets 216 184 163 800 800 101 43121 01 435 1 MUTCD 200 101 43121 01 435 1 MN Dot Updates 600 101 43121 01 437 Conferences Seminars 2 667 5 097 664 4 000 4 000 101 43121 01 437 1 APWA 1,050 10' 43121 0' 437 2 Computer Training 500 10' 43121 01 437 3 Clerical 150 101 43121 01 437 4 Gravel Road Maintenance 150 101 43121 01 437 5 City Management Training 500 101 43121 01 437 6 CEAM 500 101 43121 01 437 7 MN Pavement Management 400 101 43121 01 437 8 MN Dot 300 101 43121 01 437 9 Miscellaneous Training 450 Safety Training 101 43121 01 439 Other Miscellaneous Charges 25 245,147 200 2,000 2 000 7/00 Rain Storm -FEMA Reimb 101 43121 01 570 Office Equipment Furnishings 547 0 0 0 0 PAGE TOTALS $168,978 5368 152 $154 158 $191,200 $394 700 DEPARTMENT TOTALS $689,637 $945 115 5736 254 $893,800 $1 142 200 Page One July 10, 2002 2003 BUDGET WORKSHEETS PARKS 8 GROUNDS MAINTENANCE 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 45202 101 Salaries Benefits 5197,224 $223,002 $230,663 5286 700 $301 800 Salary Taxes PERA Benefits 101 45202 77 101 Administrative 18000 101 45202 79 101 Maintenance 283,800 '0' 45202 102 Full Time Overtime 10,780 12,842 8,575 15000 15,000 101 45202 99 103 Part Sataries Benefits 25,410 21,556 14,932 24,000 24 000 101 45202 01 205 Drafting Supplies 0 0 0 100 100 101 45202 01 216 Chemical Chemical Products 10,488 9,283 20,529 10,000 25,000 10' 45202 01 216 1 Herbicides(General Park Use) 15,000 101 45202 01 216 2 Fertilizer 10 000 101 45202 01 219 Other Operating Supplies 10,173 5 051 8,067 7 000 9,000 101 45202 01 219 1 Seed Sod etc 3,000 101 45202 01 219 2 Red Rock Sand Gravel, etc 6,000 10 45202 01 221 Equipment Parts 4 547 7,817 5,318 8 000 9,000 101 45202 01 221 1 Playground Equipment Repair 2 500 101 45202 01 221 2 Irnga0on Repair(Non Contract) 1,500 101 45202 01 221 3 Miscellaneous(Player Benches) 2500 101 45202 01 221 4 Park Sign Replacements 2,500 101 45202 01 223 Building Repair Supplies fi 375 5,244 2,306 7,000 7 000 101 45202 01 223 1 Paint Stain e c 1 500 101 45202 01 223 2 Shingles Boards, etc 2,000 101 45202 01 223 3 Miscellaneous 1,500 Calk, Hardware etc 101 45202 01 223 4 Shelter,Shed Repairs 2,000 101 45202 01 225 Landscaping Materials 5,408 874 3,505 3,600 5000 101 45202 01 225 1 Trees Shrubs Sod, etc 2 500 101 45202 01 225 2 Timbers, Fence etc 2,500 101 45202 C1 226 Sign Repair Materials 0 0 500 500 101 45202 01 229 Other Maintenance Supplies 4 22 2 3 47 4 4 000 Paint Chalk Bases, Field Dry etc 101 45202 01 241 Small Tools 4,84 2,1372 4,198 2 500 2 500 Hand Tools Blades Bits etc 101 45202 01 242 Minor Equipment 3,26 0 1 401 2,500 2,500 Safety Equipment 101 45202 01 303 Engrneering Fees 0 0 0 0 101 45202 01 318 Contract Engineer 0 2,958 5 100 5 100 Contracted Engineer for City 101 45202 01 321 Telephone Costs 107 417 500 500 Cellular Phone Bills 101 45202 01 323 Radio Units 0 0 500 500 Walkie- Talkies 101 45202 01 331 Travel Expense 4 0 100 100 Seminars Workshops 101 45202 01 341 Employment Advertising 0 389 0 0 101 45202 01 381 Electric Wattles 10,56 11,642 9,765 15 000 15 000 101 45202 01 381 1 Skating Rinks 6 000 101 45202 01 381 2 Softball Fields 6,000 101 45202 01 381 3 Irrigation 3,000 101 45202 01 383 Gas U0littes 1 155 1,701 2,023 3,000 3 000 101 45202 01 403 Contracted Repair Maintenance 15,052 3,903 3,342 4,000 4000 101 45202 01 403 1 Irrigation Repairs 1 500 101 45202 01 403 2 Electrical Reparrs 1,500 101 45202 01 403 3 Miscellaneous Repairs 1,000 101 45202 01 409 Other Contracted Repair Maint 0 4,665 4,124 8,000 8 000 Chemical Lawn Services 101 45202 01 416 Machinery Rental 14,869 8,898 11,390 15,000 15 000 101 45202 01 416 1 Mower Leases 14 000 101 45202 01 416 2 Miscellaneous Rentals 1,00 101 45202 01 433 Dues Subscriptions 35 150 25 200 200 101 45202 01 433 1 Memberships MRPA 100 101 45202 01 433 2 Miscellaneous Dues 100 101 45202 01 435 Books Pamphlets 0 0 0 100 100 101 45202 01 437 Conferences Seminars 593 2,062 474 500 500 101 45202 01 437 1 Seminars Wo kshops 300 101 45202 01 437 2 School 8 Tuition 200 101 45202 01 439 Other Miscellaneous Charges 0 0 0 200 200 Contingencies PAGE TOTALS 5325,014 5324,076 5337,879 $423 100 $457 600 DEPARTMENT TOTALS 5325 014 $324 076 $337 879 $423 100 $457,600 Page One July 10 2002 101 45100 101 10 45100 102 101 45100 103 101 4510008 103 101 45'0010 103 101 4510012 103 101 4510083 103 101 45100 94 103 101 4510099 103 101 4510001 205 101 4510001 207 101 4510001 208 101 45100 01 209 101 45100 01 211 101 45100 01 216 10, 4510001 219 101 45100 01 221 101 4510001 223 101 4510001 229 2003 BUDGET WORKSHEETS PARKS RECREATION 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Salaries Benefits Full -Time Overtime Part-Time Salaries Benefits P,T Secretary PT Receptionist Building Attendants Playgrounc Recreation Leaders Warming House Attendants Park Rec Committee Drafting Supplies Training Instructional Supplies Miscellaneous Supplies Other Office Supplies Cleaning Supplies Chemicals Chemical Products Other Operating Supplies Equipment Pars Building Reoair Supplies Other Maintenance Supplies 101 45100 01 305 Medical Dental Fees 101 45100 01 312 Contract Inspection Fees 101 4510C 01 315 Special Programs 101 45100 01 315 1 Sunday Night Specials 101 45100 01 315 2 Leprechaun Days 101 45100 01 315 3 Halloween 101 45100 01 315 4 Ground Pounders(Running) 101 45100 01 315 5 Nature Programs(Arbor Day, etc 101 45100 01 315 6 Puppet Programs 101 45100 01 315 7 Special Events 101 45100 01 315 8 Adopt -A -Park Program 101 45100 01 315 9 Miscellaneous Programs 101 45100 01 315 10 ADA Programs 101 45100 01 319 Other Professional Services 101 45100 01 321 Telephone Costs 101 45100 01 331 Travel Expense 101 45100 01 341 Employment Advertising 101 45100 01 349 Other Advertising 101 45100 01 349 1 Brochures 101 45100 01 349 2 Yellow Pages 101 45100 01 349 3 Special Marketing 101 45100 01 381 Electric Utilities 101 45100 01 383 Gas Utilities 101 45100 01 384 Refuse Disposal 101 45100 01 401 Contracted Building Repairs 101 45100 01 404 Contracted Mach Equip Repairs 101 45100 01 409 Other Contracted Repair Maint 101 45100 01 412 Building Rental 101 45100 01 415 Other Equipment Rental 101 45100 01 433 Dues Subscriptions 101 45100 01 433 1 MRPA Dues 101 45100 01 433 2 Miscellaneous 101 45100 01 435 Boons Pamphlets 101 45100 01 437 Conferences Seminars 101 45100 01 437 1 MRPA State Conference 101 45100 01 437 2 MIAMA State Conference 10 45100 01 437 3 Workshops Schools Tuition 101 45' 00 01 439 Other Miscellaneous Charges 101 45100 01 580 Other Equipment Purchases PAGE TOTALS Gene Operating DEPARTMENT TOTALS 5280,334 5321,900 $357 994 $430,300 2,117 2,129 5 801 4 700 103,625 102,223 101,190 143,900 437 507 932 1 000 0 0 113 200 730 517 314 500 909 764 1,029 1 000 4 341 5 402 4 239 5 500 1,765 1,109 1,203 1200 2030 3,585 4 221 3 500 3 710 4,955 4,153 5 500 4,433 5 829 3 159 5 500 1,312 1,488 0 0 0 415 159 800 0 9 622 6 250 5,600 5,121 5,007 5 327 9,700 34 100 27,500 33,000 16 500 13,000 2 500 $505,300 4 700 126 600 18,500 3,400 2 400 14,878 15,456 19,275 26,000 26 000 12,850 24 326 26 744 28 600 28 600 3 988 3 981 4 352 4 000 4 000 37 405 12,884 16 413 0 0 0 0 0 5545 017 $606,712 5658,696 5771,300 $545,017 5606 712 5658,896 5771,300 Comments All Salary Costs Inclusive of Salary Taxes PERA Benefits Add Rec Supervisor 1i2 BMW 1,000 Film Developing Laminating 200 Books Tapes etc 500 Meeting Supplies 1,200 Envelopes Forms Rulers etc 5 500 1 500 4,500 Rec P'agrarns 191 Aid Sup eta 9 500 New Chairs Tables 5 500 0 800 Employment Physicals 6 500 9 700 Custodial Services- Banquet Rm 2 500 Performances 500 Trophies Awards 500 Supplies 400 Ribbons Mailings 2000 Trees 500 Tapes Fuses Puppets, etc 1 000 Publicity Supplies 1 400 Flyers Trees Signs 500 Start Up Costs 400 ADA Program Supplies 8 153 435 1 939 500 1 500 ADA Services /Eng LA Sery Test 1,403 1,690 2,480 3,100 3100 Pagers Cellular Phones 390 0 114 500 500 4,227 1,969 2824 2,800 2800 General Employment Ads 13,531 15,906 17,163 22 300 22,300 City Newsletter Rec Ads New Program Flyers 5 485 9,834 8 305 6 000 8,000 5,377 6 795 6 301 5 000 6 000 0 16,713 25,320 17,000 17,000 Air Handler Maintenance Contract 13,200 16,800 16 800 16,800 16 800 Monthly Rent Payments to Guard 10 234 12,155 11 511 15 000 18,000 Portable Toilets Other Rentals 1,194 1,005 1,362 1,200 1,500 1,100 Minn Recreation Parks Assn 400 Paper Magazines JC Dues etc 144 0 0 100 100 1 694 1,310 1,911 3,500 4,000 1,500 300 2,200 0 Donation Account 0 $643,200 $843,200 Page Two July 10 2002 2003 BUDGET WORKSHEETS PARKS RECREATION 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Descnphon Actual Actual Actual Budget Amount Budget Comments 101 45100 71 Promise Program $0 50 50 $0 $2,100 101 45100 81 Softball 542 109 536 241 $40,299 $37 500 540,000 101 45100 82 Volleyball 5 327 4 566 2,393 9 400 2,500 101 45100 84 Tennis 930 834 758 1,300 1,300 101 45100 85 Tiny Tots 16,559 21 021 20,255 16 600 19 000 101 45100 86 Pom Poms 2 044 1 604 2 597 2 500 3 000 101 45100 87 Field Trips 3 131 2 327 2 042 2 800 2,800 101 45100 88 Broomball 1 055 555 600 0 0 101 45100 89 Skatirg Lessons 169 356 91 800 800 101 45'00 90 Fun Runs Walks Bike Rides 1 794 1 717 2,965 1 000 1 800 101 45100 91 Summer Camps 0 0 3622 3,000 3,000 101 45100 92 Adult Basketball 0 595 701 700 1 900 101 45100 93 Other Programs 5 984 9,841 4 992 3 500 5 500 101 45100 95 T Ball 0 0 5,931 3 200 3 500 101 45100 96 Teen Night 4 026 4 729 4,771 4 600 4 800 101 45100 98 Pistol Range 0 0 0 4 700 0 83 128 84,416 92 015 91 600 92,000 101 45100 71 103 101 45100 81 103 101 45100 81 219 101 45100 81 311 10' 45100 81 319 101 45100 82 103 101 45100 82 219 101 45100 82 311 101 45100 82 319 101 45100 84 103 101 45100 84 219 101 45100 85 103 101 45100 85 219 101 45100 86 103 101 45100 86 219 101 45100 67 219 101 45100 88 219 101 45100 88 311 101 45100 89 103 101 45100 89 219 101 45100 90 219 101 45100 91 103 101 45100 91 219 101 45100 92 219 101 45100 93 103 101 45100 93 219 101 45100 95 103 101 45100 95 219 101 45100 96 219 101 45100 96 103 101 45100 98 219 Part-Time Salaries Part -Time Salaries Operating Supplies Officiating Fees Other Professional Services Part -Time Salaries Operating Supplies Officiating Fees Other Professional Services Pah -Time Salaries Operating Supplies Part-Time Salaries Operating Suppl es Part -Time Salaries Operating Supplies Operating Supplies Operating Supplies Officiating Fees Pan -Time Salaries Operating Supplies Operating Supplies Part-Time Salaries Operating Supplies Operating Supplies Part -Time Salaries Operating Supplies Part-Time Salaries Operating Supplies Operating Supplies Part-Time Salanes Operating Supplies 0 21 190 13 478 3 842 3 600 429 664 3,836 399 755 175 15,834 630 1 408 636 2,879 132 923 169 0 1,794 1,023 4,981 4,02 SPECIAL PROGRAM TOTALS 8278 GRAND TOTAL PARK REC $627 79 0 0 0 0 0 0 2100 20,422 21,562 24300 24,300 7,294 8 787 11,000 11 000 5615 6622 0 0 2,909 3 328 2,200 4 700 948 609 1,000 1000 926 758 1,500 1,500 2,420 932 6,000 0 273 96 900 0 789 720 1 150 1,150 45 38 150 150 19,560 19 500 15 600 18 000 1462 754 1,000 1 000 1,189 1427 2000 2 200 415 1 170 500 800 2,089 2,042 2 800 2 800 0 0 0 0 585 600 0 0 356 91 740 740 0 0 60 60 1717 2965 1,000 1,800 0 1 646 1,000 1 000 0 1,975 2,000 2,000 595 701 700 1 900 1,661 0 0 2 000 818 4992 3500 3 500 4161 2,200 2,500 1 770 1,000 1 000 4,72 4,771 4,600 4 800 0 2 700 0 0 2 000 0 84,17 92,015 91,600 92000 5690,89 5750 910 5862 900 5935,200 592 000 Li E. o c 0 r m b, r c m S 0 0 0 c m c c a O m 0 m c L 3 9 €003 Jea), Reel resat 200'1 2003 2000 2003 2003 2003 2003 2003 na N N N 0 0 0 0 0 0 0 0 W (J W (J N N 0 0 0 0 Iu 4. N 0 0 W 2UU3 2003 I 2003 CUUJ 2003 7003 2003 2003 2003 2003 2003 2003 lolals water rower 114 meson (Rtplace 8339) Easemenl Sewer Cleaning Machine Structural Overlays on Older Streets Street Const- Biscayno BP 3rd to ConnemaraL_ I uiscayne Park Improvements Birch Palk Trails Improvements I JUBA Uml Replacements (1991 Units) Sun Sheller al Claret Park IPC Printer Itcpldcements (From 1998) IP( I de Server Replacements (Both From 1999) I nen Lease- rurcnase (1u- rears) 1996 Lease Purchase (10 Years) 1.__ uebeI ipiiull Pub Works Pub Works Pub Works Pub Works 'Pub Works Pub Works Pub Works Pub Works. Pub Works Poke Pub Works Pub Works Pollee Police Police Police Park R. Rec Park Rec Park Rec Fire Park Rec Finance Finance 'Council uepanment 24,0001 24 000' GIP Levy (73 00J 160 000 613 000 tar Levy 1 75 42 000 I 33 000 30 000 000 oe I 000 LZ 75,000 8000 49 000 85,000' 1 50,000 1 115,400 50 800 64 900 I GIP Levy 1,202,000 325 000 862,000 15 0001 I Assess 113 000 38 000 30 000 30 000 I Park Imp 1 675,000 675,000 r From I MSA L Funds 1 528 0001 180 000 I 13 000 320,000. 1 Water 35 0001 20.000 1 I I I Sewer I 726 000 726 000 I Storm 10,000 10,000 Water T 10,000 10 000 Utility I Sewer I I Ubety 1 Storm r 1,655,000 1 500,000 14c non 10000 I 1 'her 180 000 1,500,000 420001 b 33 (WW1 r 27 00C F 498 000 3 196 000 uuu um. 000'46 000 9L 8 000 ae nnn 15 0001 R Ail() 3a 0001 30 0001 85,000 I5 non 5n nnn I 20 000 All (Inn 11s arm I Total CosI Li E. o c 0 r m b, r c m S 0 0 0 c m c c a O m 0 m c L 3 9 €003 Jea), Reel resat N N O O O 0000000000 I a 2004 2004 2004 2004 N N 0 a a N N N 0 0 0 0 a a N 0 N O 1 2004 2004 N N O O ➢0 N I N O C N N O O CIO N N O O A d O 004 New Technobgy Updates 200414x4 Grass Rio Replacement ('91 Vehicle) N N O n alO i N N O pp 010 a L_2004 1495 Lease Purchase(10- Years) 2004 1096 Lease Purchase i1O- Years N O I Year Item Description j Totals Lireet Recon CR 33 CR 42 to 145th Street 'Street Const Boulder Avenue Extension [Shannon Park Budtivmy Hockey Rink )0/Lights j Iew Park Built Pub Works Pub Works 1 Pub Works Pub Works r Pub Works Pub Works Police Pub Works Pole e Police Park Rec Park Rec Park Rec Park Re( Park Rec.' Fore Park Rec [Council I Due Counu 'Oounmt Arena Council Depanmentl I 57,000 24,000 H i 15 0001 18 000, 1 Buddmgi k t 065,000 I 565,000 Street 550,100 40,000 9,000 33,000 75 000 15,000 L 49 000 6 000 6 000 I 12,000 L 15 0001 32,000 115 4001 50 600 64 900 CIP Levy Equipmnt 27,000 17 000 L 10 000 Assess 325,000 100 000 200 000 25 000 Fund f 350,000 350 000 Stale _MSA Funds From 1 20,000 20 000 Core Water Core Sewer Core Storm I 60,000 50 000 10,000 F-a Utility 1 Water 10,000 10,000 Ubhy Sewer 50,000 50,000 Storm Donattons1 4,220,000 1 1 150 000 3 000 000 50,000 to o0o is SI 10,000] ether 6 734,1001 N a O O 0 0 000 w (J 0 o 0 C w-• o o 0 0 0 C 00 m 0+ a 4' A 0 0 O 0 0 V a 0 0 0 0 N W p 0 O 0 0 0 T O 0 0 0 0 0 N 0 N a 0 0 0 b 01 0 000000000 w+ VIN 0 0 0 N 0 0 0 0 0 0 0 25 000 ooT tr c a' o D. Ce CO al C d C T 3 T y 9 O d N O d O 0 co co q O 0 0 o c N d 0 O_ m n 2005 IV o'o'o [nlcm 2005 'Loader (Replace #419) 20051 Paint Conncrnara Tower Structural Repairs 1 0 0 0 L 2005 Dump Truck (Replace #430) 1 L 2005 Dump I nick (Addition) 00 0 o 20051Street Recon Cambrian Avenue 2005 'Street Recon CR 73(Akron Ave) CR 42 to CR 31, o o 0 0 L 2005 Structural Overlays on Older Streets 2005 Street Recon Camera Lane 0 o 0 o O 2005 2 Squads (Sell Back 1 62110 New lnvesngator) 2005 PW Bldg Add n LeaseFPurch (Vi 7 of 20) 0 o o c N (TIN 2005 Video Cameras for 3 Squads 2005 MCD Replacements (6) o Ni o c VT 000° N V (T I Year_ Totals fetter Truck (Replace #435) Lew Fire Station #2 iAED Unit (Detbulator) 119961 ease Purchase (10 Years) 2001 Lease Purchase 00 Years) PC Printer Replacements (From 1999 2000 Item Description Pub Works Pub Works Pub Works Pub Works Pub Works Police tub Works Police Police Fire Park Rec Fire Fire Finance Finance Finance 1 'Council 'Council Department L 24 000 1 24,000 CIP Levy F Buidmji 496 000 52 000 400 000 CIP Levy Street L269 100 200 000 1 120000 120,000 50 000 15000 48 000 190 000 25 000 145 000 50 O 40 000 60,0001 1 115 400 20,000 50 6001 64,9001 CIP Levy '_Equipmnl. 406,000 96 000 225,000 17,000 66,000 Assess) 20o 000 200 000 Fund P ark Im 500 000 500,000 State Funds 1 From MSA 1 500 000 000 DOS Core 140,000 I 140 000 Core Core Storm 1 10,000 F 10 000 Utility1 Water 10,000 10,000 F utility uldity Donations' 12 925,000 1 675,000 50 000 1,000 000 Other L6,460 100 1 140 000' 1 200 000' T 500 000 000 000'c 000 091 000 Olt 000 L9 5n 000 44 000 15 000' 48 000 000 00000o L r 115,400 20 0001 so,600 64 900 Coe! 1 ooT tr c a' o D. Ce CO al C d C T 3 T y 9 O d N O d O 0 co co q O 0 0 o c N d 0 O_ m n c 0 0 saaT rasp 4201s Way SO 0 2006 2006 2006 2006 2006 2006 20061 2006 2006' 2006 0 0 010 Year Totals Swer per (Replace #443) 170KW Standby Generator(Replace #54 Qty Ralf) Picku {Replace 430b) Pickup (Replace 4307) PW Bldg Add'n Lease/Purch (Yr 8 of 20) Structural Overlayson Older Streets Video Cameras for 3 Squads Space Saver Storage Shelves Property Room RC/ eplace P/C Floor Scrubber C Ban uel Room Floor Work [1-101 Lease Purchase (10 Years) [Council Designated Designated Street Reserves Rem Description Pub Works Pub Works Pub Works Pub Works Pub Works Pub Works _Pub Works Putt Works Pub Works Pub Works Police Police Police Police 7 (Fire :Fire 1 Park 8 Res[ Park 8 Rec I Council Council Council Depadment 44,000 24,000 10,000 10 000 I Building C1PP Levy _1 1 940,000 r I Street SIP Levy 1 816,3001 377 000 1111 III 80,000 80 000 110,000 '30 000 33 000 33 000 t 17,000 360 000 30 000 115 0001 15 000 20 000 5,000 85 000 I 115 400 64,90d Eqtri runt CIP Levy Assess J 800 000 Fund L 500,000 E II r 500,000 Slate' L Core i 11 Core I Lore f 1 1 0, 00 0 10 O00 U 6th; 1 10,000 10,000 Utility 1 IN EOM UWit 1111 Il Donations] 50000 50 000 ther 3 547,3001 33,000 80 000 30 000 33 000 f 200 0001 r son non l I 10000 10 000 omi ts 40 0 400000 Cost c 0 0 saaT rasp 4201s Way SO (1) Other funding for Structural Overlays comes from SKB User Fees V 2 2 007 007' N O [out 2007 N O O N O 2007 2007 2007 2007 2007 2007 2007 2007 2007 p otals Snowblower for Loader (Replace #220) Dump Truck (Replace #427) Picku Repace 4336) Plckua(Replace 4338) r Street Recon Chinchilla Ave 127th Ct Street Recon 136th Ct Danville Ct Darnell CI IPC File Server Replacements Toth From 2005) 1PC WoIkstahon Upgrades (From 2003) Pub Works Pub Works Pub Works Pub Works Pub Works Pub Works Pub Works I Pub Works Pub Works Pub Works Pub Works Poke Police I Finance Finance Council Finance IDepadment 24 0001 L J 24,0001 CIP Levy 1,140 0001 I 200,0001 216 000 2 24 000 500,000; I CIP Levy Street 620 400 33,000 60,000 100,000'1 9 000 33 000 000 06 000s2 35,000 40,000 60 000 20,000 I CIP Levy_ F mpmnt 217,000'x. 90,000 1 54 000 56,000 000 L l I Assess Fund Park Imp 500 000 500,000 1 State Funds From r MSA Core 1 Water Core Sewer 1 Core Storm 110 000 100,000 10 000 tidily Water 110,000 100,000 r 10 000' 1 Utility I 70,000 70,000 Utility 1 Donatlonsl r 50 000 6n nnn Cher 2,641,400 33 000 60 000 100 000 F000 000 6 000 500.0001 uuu Vw' 000 0eZ 44 0001 F7 rum 25 000 on nnn 40 000 sn 0001 500 0001 on nnn Cost 115 Ann (1) Other funding for Structural Overlays comes from SKB User Fees co 5 El CO 7 gi 11 0 CD 2 N L 2008_ 2008 2008 2008 2008 1 2008 2008 ND �mm 2008 2008 ,000 00 2009 20081 2 L Totals Trailer (Restate #514) Reptace Fleet Vehicle (1998 Wedge( Van) Llre Rer on 155(8 Court Street Heron Claret Ave Cornell to 1551h PW Bletrodd n LeaseiPUrch (Vr 10 of 20) Sinrcturdt Overlays on Older Streets 2001 t ease Purchase 11D-YearsL Council Designated Street Reserves Pub Works Pub Works Pub Works Pub Works r ub Works Pub Works Pub Works 1I Pub Works Pub Works 'Pub Works Pub Works Police Police !Fite 1 Rre Arena Arena J 24 000 L L 24,000 CIP Levy l I�BUIdI11Q 900000' 861,4001 347,000 Il MI II II II In 80,000 110,000 25 0001 50,000 1 1125001 1 92,5001 292 500 117,500 i 20 000 15 000 137 500 37 500 137 500 67,500 F 17 000 I 50 000 55 000 6,0001 1 350 000' 115400 200 000 Streetj CtP Levy 1 Assess Eqm mn!J Fund 1 Park Impj I 500,000 r500 000 State _Funds From MSA 1 Care Water Core Sewer Core Storm 50, 1 10,000 10,0001 10,000 L 10,000 10, I Utility 1 Water 1 L 75,000 1 20 000 1 15 000 15,000 150001 10,0001 Sewer L 40,000 100e0 10 0001 10 000 Storm 1 Uhhty 70 000 E 50,0001 `Other E2 B67 400 I I 1_ 1100001 50 000 P 000 450 000 500 000 r 240 0001 240 000 44,000 67,000 50 0001 55 000 6 0001 I 350 000 000 01 J I 000 01 cam Total 11 co 5 El CO 7 gi 11 0 CD 2 N (1) Other funding for Structural Overlays smiles from SKB User Fees i 2009 1 9000 _20091 2009 2009 2009 2009 2009 2009_ 2009 onno N.) r0 C 000 I 1-4 NJ 0 0 0 1 111 Totals CR 421 US Hwy S2Year 4 of 4) Street Recon Danbury Way (South of CR 38) PC Printer Reeplacements (From 2005) PC File Server Replacements (Both From 2007) Pub W arks Pub Works ,Pub Works Police Pub Works Roane Finance Finance 1 I 94,000 70 000 1 Butldin CIP Levy 11,200,000 I 000 500 000 I Street CIP Levy I 496 400 110 000 25 000_1 60 000 30 000 1 16000 i i 20 000 50 000 70 000 115 4001 E ut mot CIP Levy I 192,000 I 175,000 17 000 Assess _Park Iro Fund 1 500,000 500,000 From 1 Stale MSA Funds L. II III Water 1 Core MI I I Sewer Core 1 IH I Storm 1 Core I 10,000 10, Wafer Uehty 10,000 III Sewer 1 Utility H storm Utility I Jonaions 50,000 1 50,000 other 1 110 000 500 000 I 875 000 9r, non LAM 60 000 44 000 ...,_...J._. 000 91 C00.000 0 C. 10 0 C C 1 8°° coo c,.... C t. 00 El (1) Other funding for Structural Overlays smiles from SKB User Fees 0 0 1 10 CI 0001o0000 b 0000 0 O J 11 l D 5 5 1 0 O JO C Totals 1 Street Recons See Below Connemara Parkway(Lverpass I 1 [pub Works] I_Pub WoI ks Pub Works 0 0000im�e 0 d o 0 0 0 0 o f liSunJ 24 000 o O Bmldln CIP Levy 11,192 500 577 5001 _1 200 0001 F 686 400 130,00 200 0001 33 000 120,000 90 001 115 401 F- l 1 459,500 175,001)1 11 0001 Assess E L Park Imp 1 Fund it OOg000 1,000 0001 From State MSA Funds Water Core J L_ Sewer Core 00,000 L 1100 0001 1 Storm 1 Core 240,000 I 130 000 '_10 000 Water 1 Utihly 1 210 000 0 0 0 0 0 0 0 0 0 0 0 0 Sewer 1 Utrldv 1_200 000 0 0 0 0 'o 0 o 0 Storm Uld.ty Donabonsl J soao 50,000 'Other 1 1 4164,400 I 1 120 0001 130 000 000 79 000 b> 200 0001 90.0001 115 4001 Total Cost 0 0 o to to 0 co 0 I II 100 M 0 II II i i I no in n m NI 1 1 in mon 1 1 mm 1 m 1 II ME II II 0 II 1 MI IM i o to to 0 co 0 0 as 0 0 0 (1) Other funding for Structural Overlays comes from SKB User Fees 2012 2012 20121 2012' 20121 N N N J Totals Item Description Council Designated Street Reserves IPub Works IPub Works Pub Works Pub Works Pub Works i Police 'Pub Works Department Council 1 24,000 24,0001 1 Butlding 1 800 000 CIP Levy] 1,800 boo Street 90 000 90,000 1 CIP Levy Equ 1 17,000 Assess J Park Imp] u Im Fund From State MSA_ Funds l Water COfe Sewer Core J _J Storm 1 Core 1 1 10,000 10 0001 Water 1 Utility I_ 1 1 10,000 10 0010 Utility 1 F Storm I Utility J I0ona 50,000 Vther L 2 001,000 F F rr 1 10000091 1 0 as 0 0 0 (1) Other funding for Structural Overlays comes from SKB User Fees 1 1 Totals 1 r ear Street Recon CSAH 36 -Hwy 3 to Bacardi North Central Sanitary Sewer Extension gem Description rub Works h Works Lpartment CIP Levy Budding 1 076,40 1 076 400 CIP Levy Street L_ Eui mnl CIP Levy 152,0001 152 000 Assess F und Park Imp H From Stale MSA Funds Water Core Se C ore Storm Core Water Uhhiv I I Sewer I I1hIW k Storm I lntiv I lnnaLnnc `rue. 1 1,226,400 I I I 1 276 400 Total r..„r tied, maL Anal mini Page One July 10, 2002 Account Description 206 31010 00 000 206 3310000 000 206 36210 00 000 206 36214 00 000 206 36215 00 000 206 36260 00 000 Account 206 49006 01 221 206 49006 01 304 206 49006 01 305 206 49006 01 317 206 49006 01 319 206 49006 01 365 206 49006 01 369 206 49006 01 409 206 49006 01 439 2003 BUDGET WORKSHEETS INSURANCE REVENUES Current Ad Valorem Taxes Federal Grants Aids Interest Earnings- Investments Net Change in PV- Investments Interest Earmngs Other Revenue FUND TOTALS INSURANCE EXPENDITURES Descnptlon Equipment Parts Legal Fees Medical Dental Fees General Fund Administrative Fees Other Professional Services Worker's Compensation Insurance Other tnsurance Other Contracted Repair Maint Other Miscellaneous Charges FUND TOTALS 1999 2000 Actual Actual $180,000 $185,000 $190 000 $200 000 0 32,487 0 0 20,911 26,303 22 831 10,000 (10,312) 7,156 0 0 475 601 504 200 36 200 31,111 23 392 20 800 227 274 282,658 236 727 231 000 1 999 Actual 2000 2001 Actual Actual $659 $866 $1,149 $2,000 129 45,590 0 2,500 6,135 11,075 10 478 15 000 2,500 2 500 2,500 2,500 9,667 17 450 15,900 20,000 28 784 28,585 37,339 50 000 114,805 105,349 113 442 130,000 7 565 7,900 6 630 9 000 1,084 9,377 0 0 171,329 228 691 187 438 231,000 NOTE Levy of $210,000 covers costs for consultant fees and all insurance premiums All other expenditures covered through interest earnings and insurance refunds/dividends 2002 2003 Object 2003 2001 Adopted Detail Proposed Actual Budget Amount Budget Comments $210 000 0 7/00 Ram Storms 10,000 0 Annual Market Value Changes 200 20 800 Insurance Refunds /Dlvtdends 241 000 2002 2003 Object 2003 Adopted Detail Proposed Budget Amount Budget Comments $2 000 Liability Auto Deductible Pymts 2,500 15,000 2 500 20 000 55 000 135 000 Unreimbursable Legal Fees Work Comp Deductible Pymts Yearly Fee Per Policy F -3 Risk Management Consultant Annual Premium Annual Premium- General Liability 9 000 Liability Auto Deductible Pymts 0 241 000 Page One July 10 2002 2003 BUDGET WORKSHEETS ARENA REVENUES 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 650 31010 00 000 Current Ad Valorem Taxes $114 900 $136,300 $0 50 $0 650 36210 00 000 Interest Earnings- Investments 0 0 1 898 200 200 650 36215 00 000 Interest Earnings 109 121 311 200 200 650 36260 00 000 Other Revenue 11 943 13 229 22,055 14 500 16,000 Learn to Skate Program (LTS) 650 36265 00 000 Use of Reserve Funds 0 0 0 25 400 35 800 650 38060 00 000 Pnme Time Ice Fees 229 097 214,245 229,574 230 500 232 500 650 38061 00 000 Non -Prime Time Ice Fees 0 0 0 0 0 650 38063 00 000 Open Skating ice Fees 4 834 5 395 6 145 6 300 6 300 65C 38065 00 000 Other Events -Arena 500 838 0 500 500 Dry Floor Events 650 38066 00 000 Advertising Revenue -Arena 9,275 11 138 14 450 14 000 14 000 650 38067 00 000 Skate Sharpening Revenue -Arena 2 823 4 532 4 965 2 800 3 500 650 38090 00 000 Concessions 3 196 3 600 3 410 5 000 3 500 650 38091 00 000 Vending Machine Revenues 10 684 10 450 9 659 11 000 11 000 650 38095 00 000 Pro Shop Revenues 721 985 1,320 1 100 1,100 Tape Laces, Mouthguards etc 650 39103 00 000 Gain or Loss from F/A Disposal 0 0 9 699 0 0 Sale of Old Ice Resurfacer 650 39201 00 000 Transfe• From General Fund 0 0 0 0 0 FUND TOTALS 388 062 400,832 303 486 314 500 324 600 Page One 2003 BUDGET WORKSHEETS ARENA EXPENDITURES July 10 2002 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account k Descnpuon Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 650 45130 101 Salaries Benefits $54,545 568,768 176,914 5104,300 $134 700 Salary 'axes IF ERA Benefits 650 45130 77 101 Admimstrauve 9,300 650 45'30 78 101 Technical /Clerical 38,400 650 45130 79 101 Mamtenance 87,000 Add 1 +2 Bldg Maint Worker 650 45130 79 102 Full -Time Overtime 1 766 380 2164 2,000 2 000 650 45130 103 Part -Time Salaries Benefits 38 828 39,265 33, 49,600 27 500 650 45130 89 103 1 Learn -To -Skate Program 12,500 650 45130 99 103 2 Building Skate Guard Attendants 15,000 850 45130 01 207 'Paining Instructional Supplies 0 0 0 200 200 650 45130 C1 208 Miscellaneous Supplies 855 33 0 1,000 1,000 650 45130 01 208 1 Skate Magnets 200 650 45130 01 208 2 Other Supplies 800 650 45130 01 209 Other Office Supplies 0 0 0 500 500 Learn to Skate Program Supplies 650 45130 01 211 Cleaning Supplies 2,562 2,870 3,086 3,000 3,000 650 45130 01 212 Motor °uels 1941 2,659 1,127 2400 2400 Batteries for Resurtacer 650 45130 01 216 Chemicals Chemical Products 642 222 1 251 800 2,000 Assorted Floor Products 650 45130 01 219 Other Operating Supplies 484 601 31 1,000 1 000 Events Supplies 650 45130 01 221 Equipment Parts 0 1,548 1 19 3 400 4 000 650 45130 01 223 Building Repair Supplies 3,294 1,561 2 51 4 000 4 000 650 45130 01 241 Small Tools 43 98 0 0 650 45130 01 242 Minor Equipment 0 79 0 0 650 45130 01 265 Other Items for Resale 723 411 56 800 800 Pro Shop Supplies 650 45130 01 305 Medical Denial Fees 0 500 500 650 45130 01 317 General Fund Admin Fees 6,000 6,00 6,00 6,000 6,000 Yearly Fee Per Admin Fee Policy 650 45130 01 321 Telephone Costs 1 000 1,00 1 00 1 000 1 000 650 45130 01 331 Travel Expense 100 100 100 650 45130 01 341 Employment Advertising 0 500 500 850 45130 01 349 Other Advertising 61 800 800 650 45130 01 365 Workers Comp Insurance 1136 1,08 1,35 2,000 2,000 650 45130 01 369 Other Insurance 5,729 4 87 5 771 13 000 13 000 650 45130 01 381 Electnc Utilities 34,465 59,41 96 915 64,500 64 500 650 45130 01 383 Gas Utilities 12,883 24,32 26 744 33 000 33 000 650 45130 01 384 Refuse Disposal 3,424 3 40 3 729 3 500 3,500 650 45130 01 401 Contracted Budding Repairs 2,116 5,30 5,045 5,000 5,000 650 45130 01 404 Contracted Mach Equip Repairs 5,581 6,31 10,630 6,000 6 000 650 45130 01 415 Other Equipment Rental 165 0 300 300 650 45130 01 433 Dues Subscnptions 734 69 444 900 900 MAMA Dues 650 45130 01 437 Conferences Seminars 400 10 90 400 400 MIAMA Seminars 650 45130 01 439 Other Miscellaneous Charges 0 0 500 500 Contingencies 650 45130 01 521 Building Structure Purchases 0 31 322 0 0 650 45130 01 601 Bond Principal 0 0 0 0 1999 Moved to Transfers 850 45130 01 611 Bond Interest 0 0 0 0 1999 Moved to Transfers 650 45130 01 621 Bond Paying Agent Fees 0 0 0 0 1999 Moved to Transfers 650 45130 01 710 Transfers 650 45130 01 710 1 Yearly Maintenance 650 45130 01 710 2 Bond P ncipal (1992E Issue) 650 45130 01 710 3 Bond Interest (1992E Issue) FUND TOTALS 183,428 191,50 3,500 3,500 3,500 0 0 3 500 362 923 422 521 314 754 314 500 324,600 2001 Moved to 0/5 for Arena 2001 Moved to D/S for Arena Page One July 2, 2002 Account 201 31050 00 000 201 33130 00 000 201 36105 00 000 20 36 0500 0001 201 3610500 000 2 201 3621000 000 201 36211 00 000 201 3621200 000 201 36215 00 000 201 36230 00 000 201 36260 00 000 201 36265 00 000 201 39101 00 000 Account 201 46300 101 201 46300 102 201 46300 99 103 201 46300 01 303 201 46300 01 304 201 4630001 317 201 4630001 319 201 46300 01 3191 201 46300 01 3192 201 46300 01 3193 201 46300 01 349 201 46300 01 351 201 46300 01 365 201 46300 01 369 201 4630001 381 201 4630001 383 201 46300 01 389 201 46300 01 433 201 46300 01 437 201 46300 01 439 201 46300 01 521 201 46300 01 530 2003 BUDGET WORKSHEETS PORT AUTHORITY REVENUES Description Tax Increments Federal Grants -CDBG Principal on Notes Blake L/T Note Loch L/T Note Interest Earnings Investments Interest Earnings Loch Interest Earnings Blake Interest Earnings C o n tr i b u ti o n s rD o n a do n s Other Revenue Use of Reserve Funds Sales of General Fixed Assets FUND TOTALS Description 201 46300 01 710 Transfers EXPENDITURES Salaries Benefits Full -Time Overtime Part-Time Salaries Benefits Engineering Fees Legal Fees General Fund Administrative Fees Other Professional Services Consulting Fees TIF Contribution to Endres County TIF Charges Other Advertising Legal Notices Publishing Workers Comp Insurance Other Insurance Electric Utilities Gas Utilities Other Utility Services Dues 8 Subscriptions Conferences 8 Seminars Other Miscellaneous Charges Building Structure Purchases Improvements Other Than BIdgs 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget 50 $0 50 50 0 127 684 0 0 77,241 86 291 73 834 100,600 7,103 11,05 8,451 7 454 6,81 6,124 9 742 9,33 29 479 404 36 278 0 0 2,811 235 0 0 0 0 $104 755 $241,54 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budgel Amount Budget 50 50 0 0 2,990 4 358 22,659 4,669 11,822 29,087 6,000 6,365 13 466 29,946 1,005 0 25 1,364 292 266 4,670 4,581 226 178 0 0 227 201 1,000 1,175 529 20 6 95 0 121,281 2,162 0 $118,401 $120 00 680 0 313 3,332 85 0 290 0 0 0 5 30 5 30 8 50 30 5,000 500 500 7,500 500 500 1,000 33,915 0 30,551 42,000 0 FUND TOTALS $67 080 5203 586 $150 612 $120 000 34,400 87 600 14,000 5,500 4 000 $0 Admin Fees Portion Only 0 102 000 5,30 4,50 8,10 30 $120 20 Comments interest Earned on CD's Loch L/T Lease Interest Blake L/T Lease Interest Checking Interest Miss Comments All Salary Costs Inclusive of 50 $0 50 Salary Taxes PERA 8 Benefits 0 0 0 3,884 4,500 4,500 Pon Authority Members 700 5000 5,000 Business Park 23 035 10,000 2D 000 6,000 6 000 6 000 Yearly Fee Per Policy F -3 46,273 33,500 23500 1,000 200 500 Commissioners 4 000 Property Insurance 500 Business Park Sign 0 1,000 Stormwater Fees General City Promotions 1,000 2 000 1,500 Prof Organizanons'Journals 139 1 000 1 000 Chamber of Commerce 8 Misc 414 500 500 Contingencies 0 51 000 Business Park etc 0 $120,200 Page One July2 2002 2003 BUDGET WORKSHEETS BUSINESS PARK DISTRICT(0080) REVENUES 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 243 31050 00 000 Tax Increments $130 419 $134,380 $142 975 $150,000 $125,000 Business Park District Only FUND TOTALS $130419 8134,380 $142,978 $150000 $125000 Account Descnption 243 49043 01 510 Land Purchases EXPENDITURES 243 49043 01 710 Transfers 243 49043 01 710 1 8/1/03 2/1/04 P/A Bond Pymts FUND TOTALS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget 80 $23,760 $0 80 130 419 110,820 142,978 150,000 $130419 $134,380 $142,978 8150,000 Note All TIF proceeds going towards payment on the 1993E, 1994A and 20008 band Issues Balance of bond payments coming from Pon Authonty tax levies 80 125,000 125,000 $125,000 Comments Page One July 2, 2002 Account 2003 BUDGET WORKSHEETS ENDRES PROCESSING DISTRICT)0089) REVENUES Description 244 31050 00 000 Tax Increments $15 328 553,546 $53,042 $60,000 $32,000 Endres Processing Distnct Only 244 36215 00 000 Interest Earnings 0 149 595 244 36260 00 000 Other Revenue 0 5,355 5 317 FUND TOTALS $15 328 $59 051 $58 953 560 000 $32,000 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 244 49044 01 530 Improvements Other Than Bldgs $15,328 $11 50 560,000 532 000 244 49044 01 530 1 Endres Processing -Pay as You Go 32,000 FUND TOTALS EXPENDITURES 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $15,328 511 50 560 000 532,000 Comments Page One Jury 8 2002 2003 BUDGET WORKSHEETS WATER UTILITY REVENUES 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 601 34108 00 000 Administrative Fees -Other Funds $57 544 $85,327 535,835 $40 000 $40 000 20% of 5% Fees -Const Projects 601 34109 00 000 Other Gen I Gut Chgs for Services 0 2,500 0 0 0 601 36101 00 000 Principal Special Assessments 10,753 11,538 13,554 10,000 10 000 601 36102 00 000 Penalties 8 Interest -5/A 216 77 416 0 0 601 36210 00 000 Interest Earnings- Investments 55 810 85,198 92 136 60 500 60,500 601 36214 DO 000 Net Change in =V- Investments (38 246) 15,195 (1 760) 0 0 Annual Market Value Changes 601 36215 00 000 Interest Earnings 460 268 630 500 500 601 36220 00 000 Rents B Royalties 51,283 48 022 27 455 50 000 50,000 Antenna Leases 60' 36260 00 000 Other Revenues 559 2,708 0 0 0 601 37110 00 000 Residential W a'er Revenues 377 532 477,353 533,176 460 000 510,000 601 37120 00 000 Apartment Water Revenues 43 916 51,393 37 418 50000 40 000 601 37125 00 000 Ins itudonai Vv ate" Revenues 24 213 27,486 32,550 25,000 25,000 601 3'130 00 000 Commercial Water Revenues 36 515 51 598 75,797 40 000 70 000 601 37140 00 000 Industrial Water Revenues 5 962 10,422 9,705 6 000 8,000 601 37 00 000 Penalties Water Revenues 4 070 5,011 5 276 4 000 5 000 601 37165 00 000 Meter Maint Water Revenues 18,300 17,175 5 709 3,000 3 000 801 37170 00 000 Other Water Revenues 0 0 0 0 0 60' 37180 00 000 Water Meter Sales Revenue 85,984 87,038 126,559 100 000 125,000 601 39103 00 000 Gain or Loss from F/A Disposal 0 0 (1 623) 0 0 601 39203 00 000 Transfer From 6,598 124,723 24 59B 0 0 FUND TOTALS 741 470 1,101 031 1,017 431 849 000 947 000 Page One July 8, 2002 Account t/ Description 601 49400 101 601 49400 77 101 601 49400 78 101 601 49400 79 101 601 49400 102 601 49400 103 601 49400 99 103 1 601 49400 99 103 2 601 49400 01 203 601 49400 01 209 601 49400 01 216 601 49400 01 219 601 49400 01 220 601 49400 01 220 1 601 49400 01 220 2 601 49400 01 221 601 4940001 224 601 4940001 225 60' 49400 01 227 60, 49400 01 228 601 49400 01 229 601 49400 01 2291 601 4940001 2292 601 4940001 2293 601 4940001 241 601 49400 01 242 601 49400 01 2421 601 49400 01 2422 601 49400 01 303 801 49400 01 3031 601 49400 01 303 2 601 4940001 303 3 601 4940001 304 601 4940001 310 601 49400 01 310 1 601 49400 01 310 2 601 49400 01 310 3 601 4940001 312 601 49400 01 318 601 4940001 319 601 4940001 319 1 601 49400 01 319 2 601 49400 01 319 3 601 49400 01 3194 601 49400 01 319 5 601 4940001 321 601 4940001 322 801 4940001 323 601 4940001 331 601 4940001 333 601 49400 01 341 601 49400 01 349 601 4940001 352 601 4940001 365 601 4940001 369 601 49400 01 391 601 49400 01 392 601 49400 01 393 601 49400 01 394 601 49400 01 395 2003 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES Salaries 8 Benefits Administrative Technical /C,encal Maintenance Full -Time Overtime Part-Time Salaries Benefits Utility Commission Wages (50 Maintenance Labor Printed Forms 8 Paper Other Office Supplies Chemicals Chemical Products Other Operating Supplies Water Meter Purchases For Replacements For New Homes Equipment Parts Street Maintenance Materials Landscaping Materials Utility System Maintenance Supplies Meter Repair Materials Other Maintenance Supplies Supplies for Hydrants Valve 8 Curb Boxes Valve Replacements (2) Small Tools Minor Equipment Locator GV Wrench GV Extension Wrench Engineenng Fees WTP SR Site Evaluations GIS Update of Asbuilts Miscellaneous Fees Legal Fees Testing Services Bacteria Water Duality V 0 C Pesticides, etc CU -PB Testing Contract Inspection Fees Contract Engineer Other Professional Services Thaw Pipes Check Leaks etc Supervisory Controls Hazardous Chemical Permits Meter Reading Charges Hazardous Chemical Inventory Telephone Costs Postage Costs Radio Units Travel Expense Freight& Express Expenses Employment Advertising Other Advertising General Notices 8 Public Info Workers Comp Insurance Other insurance P C Maintenance P C Accessories 8 Supplies P C Hardware Purchases P C Software Purchases P C Repairs PAGE TOTALS 1999 2000 2001 Actual Actual Actual $169,725 5157,518 $162,802 $194,500 $228,000 32,200 92,900 102,900 4,141 10,323 11 058 10 000 10 000 14 956 8,474 6,234 16 000 16 000 1,000 15 000 2 281 3 338 1,557 5,500 5 500 Inserts 8 Water Bill Statements 20 31 0 500 500 Disks Ribbons etc 20 910 30,501 38,482 33 000 40 000 Chlorine Flounde Polyphos 53 1,141 47 700 700 Maintenance Supplies 113,697 102,670 121,027 100,000 125,000 Meters MIU s CU Horns 5,000 120,000 1 911 283 436 0 0 0 0 2,558 2 000 2,000 Patching for Breaks 627 60 120 600 600 Topsoil Seed 8 Sod 466 0 2 063 2 500 2 500 Raise 6 Hydrants Per Year 40 0 0 300 300 Miscellaneous Meter Parts 4,791 4,109 5,655 7 500 7 500 4 000 1,300 GV Extensions 2,200 Sufficient for 2 Replacements 303 250 266 500 500 Wrenches Shovels, etc 2 157 1 734 1,600 3 000 3 000 1,500 1,500 9,721 19,391 28,707 12,000 12,000 5 000 5,000 2 000 0 0 0 1 000 1,000 19,258 21,926 22,920 25 000 25,000 2 000 1,000 22 000 0 0 1,777 2,000 2 000 0 0 0 20,000 20 000 3,992 3,131 8,096 9,600 9,600 1,500 3,000 500 4,000 600 810 75 1,939 3,73 83 23 1 1 1,95 1,78 1245 999 25 3,81 53 11,99 390,866 39418 46 3,72 46 2,21 11,17 25 53 434,42 2002 2003 Object 2003 Adopted Detail Proposed Budget Amount Budget Comments All Salary Costs Inclusive of Salary, Taxes °ERA Benefits 1,300 4 000 2 000 1 000 100 700 500 500 3,000 14 000 300 200 1 000 0 500 475,300 1,300 4 000 2,000 1 000 100 700 500 500 3 000 14 000 300 200 1 000 0 500 540 800 50% 601 50% -602 100% 601 Radon Tn -Chl $5 21 /Connection per Otr (M) Gopher State One -Call (M) Contracted Engineer for City MN Department of Public Safety RMR Services Lines for Telemetry Billings with Inserts Replace /Repair Radios 8 Phones AWWA National Seminar Mail-in Repairs PIT'ers Personnel Changes Newsletters Water's Share of Premiums Waters Share of Premiums Auto Read Software Support Page Two July B, 2002 Account Descripiron 601 49400 01 403 Contracted R M Other Impr 601 49400 01 415 Other Equipment Rental 601 49400 01 416 Machinery Rental 601 49400 01 433 Dues Subscriptions 601 49400 01 435 Books Pamphlets 601 49400 01 437 Conferences Seminars 601 49400 01 437 1 MN Health Department School 601 49400 01 437 2 AWWA Conference 601 49400 01 439 Other Miscellaneous Charges 601 49400 01 521 Building Structure Purchases 601 49400 01 530 Improvements Other Than Bldgs 601 49400 01 530 1 Annual Inspection of Wells 601 49400 01 530 2 South Rose Park Area Impr 601 49400 01 530 3 MXU Radio Meter Replacements 601 49400 01 560 Furniture Fixture Purchases 601 49400 01 570 Office Equipment Purchases 601 49400 01 586 Computer Equipment Purchases 601 49400 01 611 Interest on Lease Payments 601 49400 01 710 Transfers 601-49400-01 TOTALS 601 4940301 221 601 49403 01 223 601 4940301 319 601 4940301 321 601 4940301 381 601 49403 01 383 601 49403 01 409 601 49403 01 439 601 49407 01 221 601 49407 01 223 601 49407 01 319 601 49407 01 321 601 49407 01 381 601 49407 01 383 601 49407 01 409 601 49407 01 439 601 49407 01 530 601 49408 01 221 601 49408 01 223 601 49408 01 319 601 49408 01 321 601 49408 01 381 601 49408 01 383 601 49409 01 221 601 49409 01 223 601 49409 01 319 60' 49409 01 321 601 49409 01 381 601 49409 C1 383 601 49409 01 439 2003 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES Equipment Parts Building Repair Supplies Other Professional Services Telephone Costs Electric Utilities Gas Utilities Other Contracted Repairs Maint Other Miscellaneous Charges TOTAL WELL #3 Equipment Parts Building Repair Supplies Other Professional Services Teiephone Costs Electric Utilities Gas Uhlilies Other Contracted Repairs Maint Other Miscellaneous Charges Improvements Other Than Bldgs TOTAL WELL #7 Equipment Parts Building Repair Supplies Other Professional Services Telephone Costs Electric Utilities Gas Utilities TOTAL WELL #8 Equipment Parts Building Repair Supplies Other Professional Services Telephone Costs Electric Utilities Gas Utilities Other Miscellaneous Charges 1999 2000 2001 Actual Actual Actual 4,982 0 0 408 0 0 0 2,512 0 633 363 523 411 477 362 408 2 245 948 2002 Adopted Budget 2 023 2 414 2,685 4,000 0 0 0 10 000 8403 0 0 220,000 0 0 0 1 000 0 0 0 1 000 0 0 0 0 6,231 6,043 5 845 0 559 109,322 333,023 0 4,542 2,198 150 500 0 1,752 0 300 0 0 0 500 211 211 211 300 10,758 11,093 13,253 14 000 0 0 0 0 682 0 0 600 0 0 0 100 0 0 0 600 239 474 310 500 27 0 0 100 0 0 0 0 211 211 211 300 16 411 22,269 22 547 30 000 452 694 860 800 0 0 0 100 TOTAL WELL #9 17,340 23 647 23 928 31 B00 2003 Object 2003 Detail Proposed Amount Budget Comments 3 500 3,500 0 0 Moved to (416) 4,000 4 000 600 600 AWWA for 2 Members 300 300 Reference Materials 1 500 1 500 1 000 500 414,923 517,560 778013 721,200 786,700 830 265 1,179 1 000 1,000 1,182 1,620 0 500 500 0 0 0 1 000 1,000 211 211 211 0 0 2 875 4,606 7,043 7 500 7 500 490 2,089 761 2 000 2 000 292 0 1,356 25,000 25 000 0 0 0 100 100 5,879 8,791 10,550 37,100 37,100 16 445 14 136 17,200 17,200 17,200 (M) 4 000 DNR Annual Water Use (M) 10 000 Pymt on P W Building (4 of 20) 220 000 30,000 Each Well Done Every 7 Years 30 000 160,000 1.4 Total Estimated Cost 1,000 1 000 Chair Table 0 500 300 500 Independent Inspections 300 14 000 Pumping Lighting 0 600 RTU's Pump Motor etc 100 Contingencies 600 16 193 15,254 13,614 16 900 16 900 3,009 623 2 645 1 000 1 000 0 0 289 100 100 0 0 0 0 0 211 211 211 300 300 12 899 12,863 13 464 15,000 15 000 Pumping 8 Lighting 326 440 590 600 800 Heat Only 500 100 0 300 30 000 Pumping Lighting 800 Heat Only 100 Contingencies 31 600 0 P W Building Expansion(See 521) 0 Transfers for Other Improvements Independent Inspections Pumping Lighting Heal Engine Backup Increase Pumping Capacity Contingencies Page Three July 8, 2002 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 601 4941001 219 601 494'0 01 221 601 49410 01 223 601 4 01 321 601 49410 01 381 601 49410 01 409 60 49411 01 221 601 49411 01 381 601 49412 01 221 601 49412 01 223 601 49412 01 319 601 49412 01 321 601 49412 01 381 601 49412 01 383 601 49412 01 439 601 49415 01 221 601 49415 01 319 601 49415 Cl 381 801 49415 01 409 601 49415 01 439 601 49416 01 221 601 49416 01 319 601 49416 01 321 601 49416 01 381 601 49416 01 409 601 49416 01 439 601 49416 01 530 601 49418 01 221 601 49418 01 319 601 49418 01 321 601 49418 01 381 601 49418 01 409 601 49418 01 439 601 49418 01 530 2003 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES Other Operating Supplies Equipment Parts Building Repair Supplies Telephone Costs Electric Utilities Other Contracted Repairs Maint TOTAL WELL 410 Equipment Parts Electric Utilities TOTAL WELL #11 Equipment Parts Building Repair Supplies Other Professional Services Telephone Costs Electric Utilities Gas Utilities Other Miscellaneous Charges TOTAL WELL #12 Equipment Parts Other Professional Services Electric Utilities Other Contracted Repairs Maint Other Miscellaneous Charges TOTAL WATER TOWER #1 Equipment Parts Other Professional Services Telephone Costs Electric Utilities Other Contracted Repairs Maint Other Miscellaneous Charges Improvements Other Than Bldgs TOTAL WATER TOWER #2 TOTAL WATER TOWER #4 Equipment Parts Other Professional Services Telephone Costs Electric Utilities Other Contracted Repairs Maint Other Miscellaneous Charges Improvements Other Than Bldgs TOTAL WATER TOWER #3 (East Side Water Tower) GRAND TOTAL ALL DEPTS 0 34 0 1,000 28 0 17,587 0 45 0 0 100 1,063 972 976 1 000 6,023 5 388 6,379 7 000 0 0 531 5,000 7 159 6 39 25 47 14 100 0 1,000 0 1 00 211 21 810 1,26 1 021 1 47 3,45 3,45 3,48 21 1,12 4 82 2,0 50 50 50 20 1,70 50 50 30 1,00 50 20 50 3 50 1 000 0 100 1 000 7 000 5 000 14 100 1 000 1 000 2,000 500 100 0 300 30 000 Pumping Lighting 800 Heat Only 100 Contingencies 31 800 500 1,700 3,500 0 0 478,960 587,258 877,908 B49 000 946 300 Comments Pumping Lighting 500 Touch -up Paint 500 Tower Inspection 0 200 Contingencies 500 Touch -up Paint 500 Tower Inspection 300 1,000 500 200 Contingencies 500 601 49417 01 221 Equipment Parts 0 0 601 49417 01 321 Telephone Costs 0 0 601 49417 01 381 Electric Utilities 0 0 601 49417 01 439 Other Miscellaneous Charges 0 0 Contingencies 0 500 500 0 500 500 Tower Inspection 536 300 300 317 1,000 1 000 0 500 500 0 200 200 Contingencies 0 500 500 853 3,500 3 500 Page One July 8, 2002 2003 BUDGET WORKSHEETS SEWER UTILITY REVENUES 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Descrlphen Actual Actual Actual Budget Amount Budget Comments 602 34108 00 000 Administrative Fees -Other Funds 57,544 85 327 35 835 40,000 40 000 20% of 5% Fees -Const Projects 602 36101 00 000 Pnncroal Special Assessments 17 691 18,790 21 475 15,000 15 000 602 36102 00 000 Penalties Interest SIA 360 127 667 0 0 602 36210 00 000 Interest Earnings Investments 44,305 69 422 83,823 55,000 55 000 602 36214 00 000 Net Change in FV- Investments (17,374) 9,611 1 309 0 0 Annual Market Value Changes 602 36215 00 000 Interest Earnings 756 653 761 900 1,000 602 36260 00 000 Other Revenues 12,583 87 0 0 0 602 37210 00 000 ResIdenha' Sewer Revenues 633,326 756 186 824 112 762,000 800 000 602 37220 00 000 Apartment Sewer Revenues 61,354 69 747 54,307 70 D00 60 000 602 37225 00 000 Institutional Sewer Revenues 30 190 31,478 30,923 30 000 30 000 602 37230 00 000 Commercial Sewer Revenues 36 091 34 416 47,988 35 000 40,000 802 37240 00 000 Industrial Sewer Revenues 7 820 11,340 12 144 8,000 8 000 602 37260 00 000 Penalties Sewer Revenues 6,704 7,370 7 894 7,000 7 000 602 39103 00 000 Gain or Loss from F/A Disposal 0 0 (1 228) 0 0 602 39203-00 000 Transfer From 4 284 (87) 14 900 0 0 FUND TOTALS 895 633 1 094 465 1 134 912 1 022 900 1,056 000 Page One July 8, 2002 Account Description 602 49450 101 602 49450 77 101 602 49450 78 101 602 49450 79 101 602 49450 102 602 49450 103 602 49450 99 103 1 602 49450 99 103 2 602 49450 01 203 602 49450 01 209 602 49450 01 216 602 49450 01 219 602 49450 01 221 602 49450 01 224 602 49450 01 225 602 49450 01 227 602 49450 01 241 602 49450 01 242 602 49450 01 303 602 49450 01 304 602 49450 01 312 602 4945001 318 602 4945001 319 602 49450 01 3191 602 49450 01 319 2 602 49450 01 319 3 602 49450 01 3194 602 49450 01 321 602 49450 01 322 602 49450 01 323 602 49450 01 331 602 494500 333 602 4945001 341 802 49450 01 349 602 49450 01 365 602 49450 01 369 602 49450 01 391 602 49450 01 392 602 49450 01 393 602 49450 01 394 602 49450 01 395 602 49450 01 403 602 49450 01 415 602 49450 01 416 802 49450 01 433 602 49450 01 435 602 49450 01 437 602 49450 01 439 602 49450 01 521 602 49450 01 530 602 49450 01 530 1 602 49450 01 530 2 602 49450 01 530 3 602 49450 01 560 602 49450 01 570 2003 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES Salaries Benefits Administrative Technical /Clerical Maintenance Full Time Overtime Part Time Salaries Benefits Utility Commission Wages (50 Maintenance Labor Printed Forms Paper Other Office Supplies Chemicals Chemical Products Other Operating Supplies Egcipment Parts Slreel Maintenance Materials Landscaping Materials Utility System Maintenance Supplies Small Tools Minor Equipment Engineering Fees Legal Fees Contract Inspection Fees Contract Engineer Other Professional Services Televising Root Control Supervisory Conirols(Maint Cont) Meter Reading Charges Telephone Costs Postage Costs Radio Units Travel Expense Freight Express Expenses Employment Advertising Other Advertising Workers Comp Insurance Other Insurance P C Maintenance P C Accessories Supplies P C Hardware Purchases P C Software Purchases P C Repairs Contracted R M Other Impr Other Equipment Rental Machinery Rental Dues Subscriptions Books Pamphlets Conferences Seminars Other Miscellaneous Charges Budding Structure Purchases Improvements Other Than Bldgs South Rose Park Area Impr Misc Improvements /Repairs MXU Radio Meter Replacements Furniture Fixture Purchases Office Equipment Purchases 602 49450 01 602 Sewer Service Charges 602 49450 01 611 Interest on _ease Payments 802 49450 01 710 Transfers 602- 49450 -01 TOTALS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 5169 731 5157,516 5162,871 5194,500 5228,000 Salary Taxes, PERA Benefits 4 146 10 326 11,056 10 000 2 264 4 714 8 115 15,000 1 728 2,76 20 1 440 430 1 197 0 1,113 8 31 0 15 260 4,83 4 911 7,02 0 0 0 3143 3,52 81 1,94 1,944 9,37 3,65 51 56 6 1 39 4,000 0 0 0 0 3,514 14,900 621,569 650 396 1,44 49 35 6 95 16,244 0 1 ,777 0 4 834 75 465 2,06 2336 13 602 0 0 0 0 1,77 2203 7,37 8 680 25 250 0 53 0 10,49 534 0 148 0 0 1 41 0 2 69 5 2,05 1,930 91 0 0 5 500 200 500 500 0 2 500 400 1,000 500 3 000 5 000 500 2,000 20,000 12,000 600 3 000 1 000 1,000 100 300 500 3,000 12,000 300 200 1,000 0 500 2 000 200 2 000 500 300 2,000 100 0 10000 83 212,000 500 500 398 144 410,160 427,042 480,000 6 231 6,043 5,845 0 250 000 0 908,349 1,006,700 32 200 92,900 102,900 1,000 14 000 3 000 2 000 3,000 4,000 20,000 20,000 160,000 10 000 15 000 5,500 200 500 500 0 2 500 400 1 000 500 3 000 5 000 500 2 000 20 000 12 000 600 3,000 1 000 1 000 100 300 500 3,000 12 000 300 200 1,000 0 500 2,000 200 2 000 500 300 2,000 100 10 000 Pymt on P W Budding (3 of 20) 200,000 500 500 50% -602 50% -601 100% 602 Inserts Water Bit Stalements Disks Ribbons etc Root Killer Degreaser Patching Topsoil Seed Sod Manhole Castings Wrenches Shovels, etc GIS Update of Asbuilts Gopher State One -Call (M) Contracted Engineer for City SCADA System RMR Services Lines for Telemetry Billings with Inserts Replace /Repair Radios Phones National Conference Mail-in Repairs PfT'ers Personnel Changes Sewer's Share of Premiums Sewer's Share of Premiums Auto Read Software Support Reference Materials MPCA School Miscellaneous Contingencies 1/4 Total Estimated Cost 480 000 MWCC Charges 0 P W Building Expansion(See 521) 0 Transfers for Other Improvements 1,028 200 Page Two July 6, 2002 Account 602 49451 01 219 602 49451 01 221 602 49451 01 229 602 49451 01 321 602 49451 01 381 602 49451 01 403 602 49451 01 439 602 49452 01 219 602 49452 01 221 602 49452 01 229 602 49452 01 321 602 49452 01 361 602 49452 01 403 602 49452 01 439 602 49453 01 219 602 49453 01 221 602 49453 01 229 602 49453 01 321 602 49453 01 381 602 49453 01 403 602 49453 01 439 602 49454 01 219 602 49454 01 221 602 49454 01 229 602 49454 01 321 602 49454 01 381 602 49454 01 403 602 49454 01 439 802 49455 01 219 602 49455 01 221 602 49455 01 229 602 49455 01 321 602 49455 01 381 602 49455 01 403 602 49455 01 439 602 49456 01 219 602 49456 01 221 602 49456 01 229 602 49456 01 32 602 49456 01 381 602 49456 01 403 602 49456 01 439 2003 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES• Description Other Operating Supplies Equipment Parts Other Maintenance Supplies Telephone Cos's Electric Utilities Contracted R 8 M Other Impr Other Miscellaneous Charges TOTAL LIFT STATION 41 Other Operating Supplies Equipment Paris Other Maintenance Supplies Telephone Costs Electric Utilities Contractec R 8 M Other Impr Other Miscellaneous Charges TOTAL LIFT STATION 42 Other Operating Supplies Equipment Parts Other Maintenance Supplies Telephone Costs Electric Utilities Contracted R 8 M Other Impr Other Miscellaneous Charges TO LIFT STATION 43 Other Operating Supplies Equipment Parts Other Maintenance Supplies Telephone Costs Electric U6lihes Contracted R M Other Impr Other Miscellaneous Charges TOTAL LIFT STATION 44 Other Operating Supplies Equipment Parts Other Maintenance Supplies Telephone Costs Elecinc Utihbes Contracted R 8 M Other Impr Other Miscellaneous Charges TOTAL LIFT STATION 45 Other Operating Suppl,es Equipment Parts Other Maintenance Supplies Telephone Costs Elecinc Utilities Contracted R 8 M Other Impr Other Miscellaneous Charges TOTAL LIFT STATION #6 GRAND TOTAL ALL DEPTS 63641 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 0 0 0 100 100 0 179 0 500 500 0 0 0 200 200 211 211 211 0 0 564 489 573 800 800 189 0 0 200 200 0 0 0 100 100 Contingencies 963 879 784 1,900 1900 0 0 0 100 100 3,111 290 1,049 500 500 O 0 0 200 200 211 211 211 300 300 916 938 B2 1400 1400 102 0 200 200 0 0 100 100 Contingencies 4,340 1439 218 2800 2,600 O 0 100 100 3458 45 3,49 500 500 O 0 200 200 211 211 21 300 300 1,609 1 689 1,60 2,000 2 000 0 0 200 200 O 0 100 100 Contingencies 5278 1,944 5,30 3,400 3,400 0 0 100 100 120 852 81 50 500 0 0 1 50 500 211 211 21 30 300 1,249 1 48 1 36 2,00 2,000 Hawkins Pond O 20 200 0 10 100 Contingencies 1,58 2,54 2,40 370 3 700 10 33 1,64 23,41 50 20 21 21 21 30 1,81 1,94 2,45 300 52 20 10 268 3,80 2608 4,40 681,01 945 10 1 022,90 4 400 100 500 200 0 900 200 100 Contingencies 2 000 1,046,400 100 500 200 300 3,000 Country Hills 200 100 Contingencies Page One July 8, 2002 2003 BUDGET WORKSHEETS STORM WATER UTILITY REVENUES 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account it Descnptwn Actual Actual Actual Budget Amount Budget Comments 603 34108 00 000 Administrative Fees -Other Funds $57 544 $85 327 $35,835 $40,000 $40 000 20% of 5% Fees -Const Protects 603 36101 00 000 Principal Special Assessments 28 956 13,573 31 632 15 000 15 000 603 36102 00 000 Penalties Interest S/A 322 106 505 0 0 603 36210 00 000 Interest Earnings Investments 32,311 62 752 75,325 52 500 52 500 603 36214 00 000 Net Change in FV- investments (13 360) 11,066 6 231 0 0 Annual Market Value Changes 603 36215 00 000 Interest Earnings 493 348 525 700 700 6C3 36260 00 000 Other Revenues 0 7,188 0 0 0 603 3 00 000 Storm Water Utility Revenues 451 665 473,720 482 472 495 800 498,000 603 37360 00 000 Penalties Storm Water Utility 4 317 4 205 2 280 4 000 4 000 603 39203 00 000 Transfer From 67 308 110,612 69 144 0 0 FUND TOTALS 629 556 769 197 703 949 608,000 610,200 Page One July 8, 2002 Account 603 49500 101 603 49500 77 101 603 49500 78 101 603 49500 79 101 603 49500 102 603 49500 01 203 603 49500 01 204 603 49500 01 205 603 49500 01 208 603 49500 01 215 603 49500 01 219 603 49500 01 221 603 49500 01 224 603 49500 01 225 603 49500 01 225 1 603 49500 01 225 2 603 49500 01 225 3 603 49500 01 226 603 49500 01 230 603 49500 01 241 603 49500 01 242 603 49500 01 303 603 49500 01 304 603 4950C 01 310 603 49500 01 312 603 49500 01 318 603 49500 01 319 603 49500 01 322 603 49500 01 323 603 49500 01 331 603 49500 01 341 603 49500 01 352 603 49500 01 365 503 49500 01 369 603 49500 01 354 603 49500 01 389 603 49500 01 391 603 49500 01 393 603 49500 01 394 603 49500 01 530 603 49500 01 560 603 49500 01 580 603 49500 01 586 603 49500 01 710 603 49500 01 710 1 603 49500 01 710 2 603 49500 01 710 3 603 49500 01 710 4 603 49500 01 710 5 603 49500 01 710 5 603 49500 01 710 5 2003 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES• Description Salaries Benefits Administrative Technical/Clerical Maintenance Full -Time Overtime Printed Forms Paper Envelopes Letterhead Drafting Supplies Miscellaneous Supplies Shop Materials Other Operating Supplies Equipment Parts Street Maintenance Materials Lanescaping Materials Rip -Rap Matting Rock etc Black Dirt Seet Sod etc Wensmann Pond Restoration Sign Repair Materials Equipment Repair Material Small Tools Minor Equipment Engineering Fees Legal Fees Testing Services Contract Irspection Fees Contract Engineer Other Professional Services Postage Costs Radio Units Travel Expense Employment Advertising General Notices Public Info Workers Comp Insurance Other insurance Refuse Disposal Other Utility Services P C Maintenance P C Hardware Purchases P C Software Purchases 603 49500 01 403 Contracted R M Other Impr 603 49500 01 403 1 Ditching 603 49500 01 403 2 Miscellaneous Repairs 603 49500 01 404 Contracted Mach Equip Repairs 603 49500 01 416 Machinery Rental 603 49530 01 433 Dues 8 Subscriptions 603 49500 01 435 Books Pamphlets 603 49500 01 437 Conferences Seminars 603 49500 01 437 1 Storm Water Management 603 49500 01 437 2 Hydrocad Training 603 49500 01 437 3 W ellands Training 603 49500 01 439 Other Miscellaneous Charges Improvements Other Than Bidgs Furniture Fixture Purchases Other Equipment Purchases Computer Equipment Purchases Transfers 1/2 of 2003 P Payments(19948) 1/2 of 2003 P 1 Payments(19966) 1/2 of 2003 P I Payments(1999C) 1/2 of 2003 P I Payments(20018) 1/2 of 2003 F f Payments(2001D) 1/2 of 2003 P I Payments(20026) 1/2 of 2003 P I Payments(2002C) 603- 49500 -01 TOTALS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 5141,417 5126,113 $131,339 $161,300 1189,700 Salary Taxes PERA Benefits 19 700 81,800 88,200 3 656 9,372 9 71 212 705 0 0 6 0 384 37 0 0 222 106 0 0 219 0 943 203 27 19 1 42 43 1,94 1,39 4,54 11 6 33 0 62 303 65 29,854 5264 0 0 500 2 06 5 3 1 33 3,60 53 11,96 0 0 470 1,329 7,953 4,573 0 0 1,180 1,000 2 56 46 29 82 2,77 2 33 24 4 1 65 4 23 0 0 35 187 B05 10 000 600 1 000 1,000 0 10,000 2,000 1,000 500 20,000 0 3,000 1 200 200 0 1 000 3,000 5,000 600 1,000 300 1 000 0 25,000 1,000 10 000 20 000 2,000 2 000 449 17 8,650 0 0 0 43,141 80,000 0 0 0 500 0 0 0 2 000 0 0 0 500 149,049 170,496 185,000 217,000 500 500 0 0 800 800 Paper, Pens Reproduction 1 000 1,000 Stakes Ribbons Level, etc 200 200 1 500 1 500 500 500 Filters, Hoses Lignts etc 2,000 2,000 Blacktop Gravel Washouts 4 800 4,800 3 000 1 000 800 10 000 15,000 1,000 500 500 18,000 50,000 42 000 45 000 74,000 15 000 26,000 10,000 600 1,000 1 000 0 10,000 2,000 1 000 500 20 000 0 3,000 1200 200 0 1,000 3 000 5 000 600 1,000 300 1 000 0 25 000 1 000 10 000 20,000 2 000 2 000 322,812 366,344 445,210 595,000 596,400 0 0 500 2 000 500 270 000 Annual Seec Maml Costs Advance Warning Sign Rental Due to Breakdowns Shovels Rakes Picks etc Problem Area Investigations Water Quality Tests (M) 3rd Part Inspection Program (M) Contracted Engineer for City Billings Info Mailings Replacements Repairs Public Info Brochure Storm Water's Share of Premiums Storm Water's Share of Premiums Roadside Debris Hazardous Materials Disposal Auto Read Software Support Repairs Sent Out Backhoe, Loa boy Pumps etc Watershed Organization Utility Information Page Two July 8 2002 Account 603 49511 01 221 603 49511 01 321 603 49511 01 381 (Shannon Hills 6th) 603 49512 01 221 603 49512 01 321 603 49512 01 381 (Schwarz Pond) 603 49513 01 221 603 49513 01 321 603 49513 01 381 (Barger Pond) 603 49514 01 221 603 49514 01 321 603 49514 01 381 (Marcotte Pond) 603 49515 01 221 603 49515 01 321 603 49515 01 381 (Hawkins Pond) 2003 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES Description Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #1 Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #2 Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #3 Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #4 Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #5 GRAND TOTAL ALL DEPTS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 52 0 211 211 178 242 441 453 0 211 160 500 300 500 371 1,300 500 300 500 1,300 O 2 088 0 500 500 211 211 211 300 300 0 0 0 500 500 211 2,299 211 1,300 1,300 0 29 325 500 500 0 90 239 300 300 0 6 640 3 110 7,000 7 000 O 6,758 3,674 7 800 7 800 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 500 300 500 0 1 300 0 0 0 500 300 500 0 1,300 323,464 375,854 449 466 608,000 500 300 500 1,300 500 300 500 1,300 609,400