Loading...
HomeMy WebLinkAbout2.c. Proposed 2003 BudgetCITY OF ROSEMOUNT EXECUTIVE SUMMARY FOR ACTION COMMITTEE OF THE WHOLE DATE July 3, 2002 AGENDA ITEM: Proposed 2003 Budget AGENDA SECTION: PREPARED BY: Thomas D. Burt, City Administrator AGENDA NO. z, c, ATTACHMENTS: Draft 2003 Budget APPROVED BY: The 2003 proposed budget is completed and ready for Council review 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 MEMORANDUM DATE- July 2, 2002 TO Mayor City Council FROM Thomas D Burt, City Administrator SUBJECT 2003 Proposed Budget The following identifies e� ery 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 w ages that attribute approximately $420,000 of the proposed $837,000 increase The following full -tine 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 will be built over the next twelve months At that growth rate, the community still grows by 750 925 residents annually if an officer position is budgeted for Tuly 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 positron An additional patrol positron should reduce the amount of overtime spent Staffing levels will beset 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 positron 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 time position This was done in anticipation of the position being made FT in 2003 Sergeant Position There are currently four (4) supervisor /manager positions in the department with 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 during more hours of the day and on weekends The current scheduling of supervisors /managers results in 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 training 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 Planner will also assist the Building Department by reviewing applications all building 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 verification 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 budding 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 Supervisor but with 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 lob responsibilities will include handling park reservations, supervising contracted construction projects, handling park based programs such as Arbor Day, Adopt -a -Park and the Memorial Donation Program PI The positron would also handle all city rubbish and recycling and along with City Clean up Day The position will be a raison 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 -term benefit to the City and our residents The heavy use that our 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 +$2,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 Increased to League of Minnesota Cities dues. Total Department budget has increased by $4,900 or 5.5 Administration 101 41320 01 101 +20,500 Adjusted for salary and insurance increases. 101 41320 01 433 -$200 Added dues for Human Resources Total Department budget has increased by $20,700 or 6.46 Elections 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 $10,000 is encumbered for future electron equipment to offset future cost Total Department budget has decreased by $13,000 or 56.52 Finance 101 41520 01 101 +$10,900 Adjusted for salary and insurance increases. 101 41520 01 391 +$4,000 Increase in software and network support cost 101 41520 -01 -437 +$1,000 Management classes for supervisory position Total Department budget has increased by $15,900 or 6.23% 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 Increase in general office supplies to closer reflect history 101 41810 01 301 +14,000 Increase audit cost 101 41810 01 319 +$3,500 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 Authority meetings Total Department budget has increased by $71,300 or 23.87% Community Development 101 41910 01 t01 +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 -$500 Reflects needs -300 Reflects needs Total Department budget has increased by $99,800 or 14.58% 4 Police 101 42110 01 101 +$293,500 Adjusted for salary and insurance increases, in addition a part time receptionist is move to full time, 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 4211001 202 +300 Reflect history 101 4211001 316 +$1,200 As the population grows more animal complaints are being received 101 4211001 319 +4,000 Reflects cost increases due to population growth 101 42110 01 331 +$1,000 Based on history and expected costs in 2002 101 42110 01 396 testing +11,000 Increase in LOGIS costs. 101 42110 01 433 The increase is the added cost of participating in the Technical Team Joint +1,000 Increase is due to 9 officers' licenses being renewed 101 4211001 580 +3,400 Purchase digital recorders Total Department budget has increased by $320,000 or 18.96% Fire 101 422I0 01 103 +$5 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 +$1,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 +$5,000 The increase is the added cost of participating in the Technical Team Joint Powers 101 42210 01 319 +$200 Increase in fire prevention education materials E 101 42210 01 321 +$300 Reflects department needs for 2003 101 42210 01 433 +$200 Reflects department needs for 2003 101 42210 01 580 $2,000 Reflects department needs for 2003 Total Department budget has increased by $10,700 or 4.20% Public Works Government Buildings 101 41940 01 101 +$3,100 Adjusted for salary and insurance increases 101 41940 01 102 +$1,000 Reflects historical costs. 101 41940 01 208 +$1,500 Increased cost of cleaning materials for governmental buildings 101 41940 01 319 +$2,500 Reflects historical costs Total Department Division budget has increased by $8,900 or 2.84% Fleet Maintenance 101 43100 01 101 +$7,600 Adjusted for salary and insurance increases 101 43100 01 221 +$2,000 Budget reflects history of spending needs 101 43100 01 222 +$5,000 Increase is due to the grader needing tires replaced 101 43100 01 242 +$2,000 Reflects department needs for 2003 101 43100 01 404 +$5,000 Reflects department needs for 2003 Total Department Division budget has increased by $17,600 or 4.45% Street Maintenance 101 4312101 101 +$22,500 Adjusted for salary and insurance increases 101 43121 01 205 +400 Increased to reflect history 101 43121 01 231 +$2,000 As the city adds roads the amount budgeted for bituminous patching will increase proportionately 101 43121 01 233 +$3,000 Increased cost in dust control materials 101 43121 01 381 +$10,000 As a result of growth there is an increase in number of street lights 6 101 43121 01 391 +$2,000 Software support for pavement management program. 101 43121 01 402 +$75,000 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 v, e 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 seven years cycle 101 43121 01 405 +$7,000 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 101 43121 01 406 +$3,500 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 101 43121 01 407 $25,000 This line item was combined in Sidewalk improvements. 101 43121 01 408 +$15,000 Similar to above the city has not kept up with crack filling If cracks are not repaired in pavement, water gets under the pavement and will cause increased damage 101 43121 01 410 +$128,000 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 101 45202 01 101 +$15,100 Adjusted for salary and insurance increases 101 45202 01 216 +$15,000 Because additional parks have been added more chemicals are need for maintenance in addition it has been budget closer to what has lustoncally been spent 101 45202 01 219 +$2,000 Because additional parks have been added more supplies are need for maintenance 101 45202 01 221 +$1,000 As parks are added the cost of maintenance on playground equipment, etc is increasing 101 45202 01 225 +$900 Increase to reflect history Total Department Division budget has increased by $34500or 8.15% 6 Park Recreation 101 45100 01 101 +$75,000 Adjusted for salary and insurance increases The positron 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 positron was funded from part time salaries 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 4510001 312 +$900 Increased cost of contractual custodial maintenance 101 4510001 319 +$1,000 Increased to reflect history 101 45100 01 401 +$2,000 Increased to reflect history. 101 4510001 404 +$1,000 Increased to reflect history 101 4510001 415 +$2,000 As parks are added the need to rent additional portable toilets are added 101 4510001 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 positron Total Department budget has increased by $71,900 or 9.32% REVENUE At the time of writing 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 S66,013 because the city experienced 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 C 101 41110 01 307 Planning Consultant 12,000 101 4111001 329 Broadcast Port Authority Meetings 5,000 101 41110 01 329 Cable television programming 30,000 101 4191001 103 Planning Intern 17,500 101 42110 01 580 Digital Recorders 4,000 101 43121 01 410 Sidewalk improvements $125,000 101 45100 01 101 Parks Supervisor (wages insurance) S 71 $252,821 Capital Improvements Program PC's 50,000 Printers 20,000 Motor Pool Vehicle (305) 20,000 P &R Van 27,000 Roller Replacement 30,000 Skidster Replacement 30,000 2 Pickups 75,000 Total CIP $252,000 TOTAL REDUCTION $504,821 E FUNDING REQUIREMENTS -USES (INCLUDING FIRE STATION LEVY) q f Off.., July 10, 2002 Departments 2002 2003 Adopted Proposed Budget Budget +I- Difference Percentage Council Budget Administration Budget Elections Budget Finance Budget General Government Budget Community Development Budget Police Budget Fire Budget Public Works Operating Budgets Government Buildings Budget Fleet Maintenance Budget Street Maintenance Budget Parks Maintenance Budget Park Rec Budget General Operating Park Rec Budget Special Programs Total Operating Budgets General Fund Building CIP Requirements Street CIP Requirements Equipment CIP Requirements Insurance Budget Requirements Bonded Indebtedness Bonded Indebtedness Fire Station Levy Armory Anticipatory Levy (Value 2/21102) "$95,000 +($1,152,683,700 x 00798 Total Funding Requirements $88,600 $93,500 320,300 341,000 23,000 10,000 255,300 271,200 298,700 370,000 684,700 784,500 1,688,000 1,932,500 254,800 265,500 312,900 321,800 395,500 413,100 893,800 1,142,200 423,100 457,600 771,300 843,200 91,600 92,000 $6,501,600 $7,338,100 24,000 24,000 208,000 773,000 770,100 751,100 200,000 210,000 1,065,379 1,039,049 154,482 156,130 173,011 186,984 $4,900 553% 20,700 646% (13,000) -5652% 15,900 623% 71,300 2387% 99,800 1458% 244,500 1448% 10,700 420% 8,900 284% 17,600 445% 248,400 2779% 34,500 8 15% 71,900 932% 400 044% $836,500 1287% 0 000% 565,000 271 63% (19,000) -247% 10,000 500% (26,330) -247% 1,648 107% 13,973 808% $9,096,572 $10,478,363 $1,381,791 1519% �r NOTE Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies FUNDING REQUIREMENTS SOURCES (INCLUDING FIRE STATION LEVY) July 10, 2002 Levy Sources Special Levies 2002 2003 (10,709) -077% General Levy Adopted Proposed 1,265,628 Types Budget Budget Difference Percentage Local Government Aid (LGA) $394,723 $402,395 $7,672 194% Internal Revenue Generated Licenses and Permits 478,500 516,200 37,700 788% Intergovernmental 423,889 432,089 8,200 1 93% Charges for Services 481,400 539,400 58,000 1205% Fines Forfeits 90,000 90,000 0 000% Recreational Fees 203,900 208,800 4,900 240% Miscellaneous Revenues 130,400 140,800 10,400 798% Transfers In 3,500 3,500 0 000% Total Internal Revenues 1,811,589 1,930,789 119,200 658% Levy Sources Special Levies 1,392,872 1,382,163 (10,709) -077% General Levy 5,497,388 6,763,016 1,265,628 2302% Total Levy $6,890,260 $8,145,179 $1,254,919 1821% Total Revenue Sources $9,096,572 $10,478,363 $1,381,791 1519% NOTE Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies r r 2002 GENERAL PROPERTY TAX LEVY PAYABLE 2003 GENERALLEVY GENERAL FUND $5,004,916 BUILDING CIP FUND $24,000 STREET CIP FUND $773,000 EQUIPMENT CIP FUND $751,100 INSURANCE FUND $210,000 TOTAL GENERAL LEVY $6,763,016 BONDEDINDEBTEDNESS G O COMMUNITY CENTER BONDS 1992C (Authorized $101,927) $0 G 0 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 0 IMPROVEMENT BONDS 1995A (Authorized $16,026) $16,026 G O MUNICIPAL BUILDING REFUNDING BONDS 1998A (ICE ARENA) (Authorized $252,64 $252,644 G 0 IMPROVEMENT BONDS 1998C (Authorized $5,139) $5,139 G O IMPROVEMENT BONDS 1999B (Authorized $16,434) $16,434 G O BONDS 20008 (Port Authority) (Authorized $236 266) $236,266 G 0 IMPROVEMENT BONDS 2001A (Authorized $117,821) $0 G 0 PUBLIC FACILITY BONDS 2001 C (Port Authority) (Authorized $170,604) $170,604 G O COMMUNITY CENTER REFUNDING BONDS 2001 E (Authorized $93,447) $93,447 TOTAL BONDED INDEBTEDNESS $1,039,049 MARKET VALUE BASED REFERENDUM -1995 FIRE STATION LEVY G O FIRE STATION BONDS, 1996A (Authorized $156,130) $156,130 TOTAL FIRE STATION LEVY $156,130 PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($95,000 ($1,152,683,700 x 00798 $186,984 (AS OF 2121102) TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS $186,984 GRAND TOTAL 2002 PROPERTY TAX LEVY $8,145,179 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) Total Funding Requirements Less Internal Revenues Less Market Value Based Levy Fire Station (See Below) Equals Revenues Needed City Adjustments (All Subtractions) Local Government Aid (LGA) Homestead Agricultural Credit Aid (HACA) Levy Certified by City to County Auditor 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 (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 12131103 Last Update from Dakota County 2121102 Shows the Levy of $156,1301$1,130,070,450 1382 per $1,000 as our Estimate Last Update 6128102 8 (Proposed) 2000 2001 2002 2003 7,440,486 8,019,068 9,096,572 10,478,363 1,573,889 1,716,389 1,811,589 1,930,789 155,715 152,508 154,482 156,130 (4) 5,710,882 6,150,171 7,130,501 8,391,444 396,549 394,496 394,723 402,395 (2) 577,497 577,707 0 0 (2) 4,736,836 5,177,968 6,735,778 7,989,049 581,379 612,593 708,036 708,036 (3) 4,155,457 (1) 4,565,375 (1) 6,027,742 (1) 7,281,013 9 86% 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 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 12131103 Last Update from Dakota County 2121102 Shows the Levy of $156,1301$1,130,070,450 1382 per $1,000 as our Estimate Last Update 6128102 8 CITY OF ROSEMCUNT YAMKSNEET FOR ESTIMATING RESIDENTIAL PROPERTY TAXES OSO #196 FIGURES) Martel Vgue 100000 150000 200000 250000 Yea 2001 2W2 2003 Est 20U1 2002 2003 Est 201 21X2 2033 Ell 2001 2002 2003 Est Tax Capadly 1156 1000 1000 1981 1500 1500 2606 2000 2000 631 2500 25W Tax Capanly Rates City 36553% 59546% W002% 35553% 59546% 00092% 36551% 59548% 60W2°/ 36553% 59546% 60092% County 25320% 33102% 33102% 25320% 33102% 33102% 25320% 33102% 33102% 25320% 33102% 33101% Srhool Disinct 53249% 28883% 28083% 53249% 28083% 28083% 53249% 20883% 28883% 53249% 28883% 28003% Mxelldneois 6378% 5021% 5021% 5378% 5021% 5021% 6378% 5021% 5021% 6378'A 5021% 5021% TotaiS 121500% 126552% 127 098% 121500% 126552% 42]098% 121500% 126552% 12]098% 121500% 125552% 127006% City Market Referendum 00CV1WB 00001616 00(01382 00001000 00001616 001 00001800 00001816 00001382 00001006 00001616 OW01382 ISO #1915 Market Red 00010648 00017859 00017859 0MIW48 0 W47M9 0001]859 00010648 00011659 OW17MO 00010648 0M1]659 0 W1785 ProMp Taxes City 423 463 467 724 Tat 789 1026 1100 1111 1327 1419 1433 County 293 257 257 5U2 434 435 710 612 612 919 789 709 Smog District 312 224 225 665 379 379 1104 534 534 1543 BBB 689 4 mis- 11anmuc 74 39 39 126 W 66 179 93 93 232 IN 120 Total PrupeM Taxes 1101 903 989 2017 1661 1669 3019 2339 2350 4022 3016 3030 City Markel Referendum 10 16 14 27 24 21 36 32 20 45 40 35 ISO NIM Market Ref IW 179 179 160 268 268 213 357 357 266 446 446 Grand Total All Taxes $1225 $t 178 $1181 $2204 $1953 $1958 $3268 $2720 $2]34 $4333 $3503 $3511 Market Value 300000 350 DW Nlsles,of Actual Tas Capacity Raba (Using ISO #196 Rates) Yea 2001 2002 2003 Ell 2001 2002 2003 Est 1998 1999 20W 2001 2002 21X13 Est Tas Capacity 4456 3000 3000 5281 3500 35M Tax Capacity B ales CRY 38553% 59546% WW2% 36553% 59545% 600112% 40428% 41710% 39335% 36553% 59546% W092% (1) (2) County 25320% 33102% 33102% 25320% 33102% 33102% 27349% 20322% 2]24]% 25320% 33102% 33102% (2) School Distinct 53249% 2080% 25683% 53249% 28803% 28083% 50462% 56311% 53231% 53249% 20093% 28883% (2) Mscell.neous 6378% 5021% 5021% 6370% 5021% 5021% 5797% 6702% 6455% 63]0% 502t% 5021% (2) Tell 121500% 126552% 12]098% 121500% 126551% 12]098% 132036% 133045% 126269% 121500% 126552% 12]098% City Markel Referendum 00001 BOB 00m I at 00001382 00001008 00001616 00001302 00002532 00002342 00002142 00001BW 00001616 80001382 (2) ISO#iWMarkel Red 0001OPB O0 OW17859 OWIM48 UW17B59 00011659 0 000 00009074 0001191 00010640 00017859 00017859 (2) Property Taxes Copy 1629 t 7M 1 754 1 930 2057 2006 Net Tex Capacity Percentages County 112B 966 966 1337 1 144 1 144 For Residential llomeslerds Srnool District 1983 843 843 2422 990 998 Mlsrellaiwous 284 147 14] 337 173 173 First $76000 100% iW% 101 §76000 $500000 165% 165% 100% ToMlPmpeMTaxes 5024 3001 3711 6026 1372 4391 Over$500and, 100% 165% 125% City Markel Referendum 54 48 41 63 57 411 ISO 95 Markel Ref 319 536 536 373 625 625 Grand Total All Taxes $5396 $42]8 $4208 $6462 $5054 $5064 Tax Credit for Pedestaled! P roity (Fun 1998 nrn 2001 Gediz m ool Srn DISMCIS (0ased on Tax CapacM) (Fa 200 a 2 end d pi Credit Applied d 0 All All Oiganrzallos n Pmpp dwnalely) Less Than linsi Value of Tax Capacity 26274% Na No (2) Over (motif Value(MVImum Allowed) $390 $304 $300 (2) In14al Value Used to Calculate Credit $119000 $7600) 576000 (2) 11) This Figure De0ved Using Fi Provided by Dakota Count, (a) 2002 Pmiecost Levy Less Fiscal Dispari as of 2121102 7281013 I 12 116 403 0800922 (b) Net Tax Capacity Figure as of 2121102 13 627100 (6) Captured Tax Iaremenl Tax Capacity as of 11001 (319105) (d) ConlnbWOid to Fiscal Disparities as Of 1112/01 (1191592) 12116400 Last Updated 612810E ¢I Tnese Fl9ures Fronded W Dakota County tb ESRmateS AvaI1BbM at The Time Page One July 10, 2002 2003 BUDGET WORKSHEETS GENERAL FUND REVENUES Account# Description 101 31010 00 000 101 31040 00 000 101 33401 00 000 101 33402 00 000 101 33424 00 000 101 32110 00 000 101 32160 00 000 101 32161 00 000 101 32180 00 000 101 32210 00 000 101 32212 00 000 101 32220 00 000 101 32230 00 000 101 32240 00 000 101 32250 00 000 101 32255 00 000 101 32260 00 000 101 32290 00 000 101 31010 00 000 101 31010 00 000 1 101 31020 00 000 101 31030 00 000 101 31710 00 000 101 31810 00 000 101 31811 00 000 101 31920 00 000 101 33100 00 000 101 33403 00 000 101 33416 00 000 101 33416 00 000 1 101 33416 00 000 2 101 33418 00 000 101 33423 00 000 101 33425 00 000 101 33620 00 000 101 33630 00 000 101 33630 00 000 1 101 36101 00 000 101 36102 00 000 Current Ad Valorem Taxes Fiscal Disparities Total Taxes (Tax) Local Government Aid (LGA) Total LGA (Lga) Hstd Ag Credit 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) Electrical Permit Revenue (L) Plumbing Permit Revenue (L) Animal Licenses (L) Sewer Permit Revenue (L) County Recordirg Fee City's (L) HVAC Permit Revenue (L) Other Non -Bus Lic Permits (L) Total Licenses Permits (L) Current Ad Valorem Taxes (1) MSASC Armory Pavments Delinquent Ad Valorem Taxes (I) Mobile Home Taxes (p Gravel Taxes (1) Franchise Taxes Regular Fees (1) Franchise Taxes PEG Fees (1) Forfeited Tax Sale Apportionment Federal Grants Aids (I) Mobile Home HACA (I) Police Training Reimbursement (1) Post Board Training Reimb State Aid (Tied 10 PERA) MSA for Streets Maintenance (I) Ag Preserves Oredit (I) Other State Grants Aids Other County Grants Aids (1) Ponce Services Levy -ISD #196 (1) D A R E /Liaison Funding Principal Special Assessments (1) Penalties Interest S A (1) 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 1 42 $3 587 252 530,667 581 379 612 593 708 036 2,480,494 2 677 046 2,915,335 4 295 288 381988 396,549 394496 394,723 381988 396,549 394,496 394,723 550 493 577 497 577,707 0 $4 296 880 From County 708 036 From County 5,004,916 0 402,395 From State 402,395 0 0 From State Program Eliminated 550,493 577,497 577 707 0 0 15 466 0 0 0 0 From State Rolled into LGA, 15 466 0 0 0 0 14166 16840 21,540 17000 20,000 2 150 1,359 2 400 1,000 1 500 Garbage Haulers Ped Lic etc 50 75 75 0 0 0 0 0 0 0 479,029 461 126 632,696 373 000 400,000 2,275 4,030 1520 1,800 2,000 21,543 12 839 17,579 12 000 15,000 36 934 32,305 44,946 25,000 30 000 2 190 2,228 2,352 2000 2000 24,039 21 355 18,772 15 000 15,000 230 200 250 200 200 39 358 34 621 48 241 30 000 30,000 1 500 1,325 25 1,500 500 Alarm Permits 623 463 588,304 790 396 478 500 516 200 91,000 90,000 90 000 90 300 91 000 Included in Debt Levy Figure 90,300 36,624 27 003 43,974 20 000 20 000 From County 11 744 11,656 10,690 10 000 10,000 From County 7,003 7 673 9 222 7,000 8,000 From County 125,757 93 639 106 857 95 000 100,000 From Cable Company 0 9,253 12,331 10,000 10,000 From Cable Company 0 0 0 0 0 From County 21250 276,637 1099 0 0 22 987 23 060 23,060 0 0 From State Program Eliminated 94 847 94,280 90,942 93,000 93,000 From State 6,000 67,000 27,900 26,596 28 230 27,900 29,000 From Stale 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 B45 12 059 11 300 13,200 Dakota County Recycling Funds 35 091 36 979 40 045 40,000 45,000 45,000 From ISD 4198 0 0 65 0 0 From County 0 0 0 0 0 From County 516,055 722,568 486 526 423 889 432,089 4,567 959 4 961 964 5,164 461 5 592 400 6 355,600 r Page Two 2003 BUDGET WORKSHEETS GENERAL FUND REVENUES July 10, 2002 Account Description 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 101 3 34103 00 000 Z Zoning 8 Subdivision Fees (C) 8 8 068 1 18 592 2 20 245 1 12,000 101 3 34104 00 000 P Plan Checking Fees (C) 2 228 930 2 271,725 3 379 389 2 210,000 101 3 34105 00 000 S Sales of Maps 8 Ouolicabons (C) 4 404 5 542 1 1,704 5 500 101 3 3410600 000 D Deputy Registrar Fees (C) 3 31 418 3 30 652 3 34,738 3 35 000 101 3 34107 CO 000 A Assessment Searches (C) 3 327 6 60 1 10 1 100 101 3 34108 00 000 A Admm Fees Other Funds (C) 1 140 088 1 195 691 9 96,670 1 100 000 101 3 34108 00 000 1 A Applicable Funds Except Const 101 3 34108 00 0002 C Construction Funds 101 3 34109 00 000 O Other Charges for Service (C) 2 2,069 2 2 429 2 2 901 3 3,000 101 3 34110 00 000 S Service Cog on Returned Chks (C) 1 180 2 240 2 201 1 100 101 3 3411200 000 U Utility Permit Application Fee (C) 1 150 3 300 1 1 350 2 200 101 3 34160 00 000 N National Guard Mamt Fees (C) 1 16,000 8 80 700 7 72,296 7 71 300 101 3 3416000 000 1 S Shared Space Rental Agreement 101 3 34160 00 000 2 B Building Maintenance Contract 101 3 34201 00 000 S Special Police Services (C) 2 23,503 2 21,280 2 22,558 2 21 000 101 3 34202 00 000 F Fire Services- Burning Permits (C) 4 4183 3 3,723 3 3,393 3 3 500 101 3 3420300 000 A Accident Reports (C) 5 513 5 550 6 616 5 500 101 3 34204 00 000 D Day Care Inspection Fees (C) 2 292 5 504 2 252 2 200 101 3 34206 00 000 O Othe Police Services (C) 2 23 0 0 0 0 0 0 101 3 34207 00 000 O Other Fire Protection Services (C) 2 25,188 6 66,121 6 60 294 2 21,000 101 3 3420700 000 1 U U of M Fire Contract 101 3 3420700 000 2 C Coates Fire Contract 101 3 34207 00 000 3 O Other Billed Fire Calls 101 3 34303 00 000 M Mow Weeds (C) 5 529 3 3,258 0 0 0 0 101 3 34306 00 000 O Other Highway 8 Street Rev (C) 1 150 1 14,130 0 0 0 0 101 3 34407 00 000 C City Share of Metro SAC Chgs (C) 4 4 365 3 3 395 4 4,085 3 3,000 15,000 260 000 65% of Building Permit Fees 500 35,000 State Fee Increase 7/1101 100 125,000 25,000 100,000 3,000 100 200 44 300 16,000 28,300 26,000 Contractual Off for Officers 3 500 500 200 0 21,000 5,100 3 600 12,300 0 2,000 Street Light Bills Developers 3 000 539,400 90000 From County 90,000 1 500 40,000 2,500 1,300 19 000 3,000 2,800 0 800 1,800 1 900 5 500 3,000 3,500 2100 Promise Fellow Grant Program 54,000 12,600 22 000 0 24 000 2,000 700 0 4 800 Total Recreation Fees (R) 207 578 224 033 222 921 203 900 PAGE TOTALS 785,398 1,009 993 1 012 146 775,300 208 800 838 200 k Page Three 2003 BUDGET WORKSHEETS GENERAL FUND REVENUES July 10 2002 Account# Description 101 36210 00 000 Interest Earnings Investments (M) 101 36214 00 000 Net Change in FV- Investments (M) 101 3621500 000 Interest Earnings (M) 101 3622000 000 Rents Royalties (M) 101 36230 00 000 ContnbutionlDonatwns (M) 101 36260 00 000 Other Re+enue (M) Total Mist Revenues (M) 101 39202 00 000 Contribution from EMerpnses R) Total Transfers In (T) PAGE TOTALS DEPARTMENT TOTALS INTERNAL REVENUES 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 83 426 152 349 172,813 120,000 130,000 (31,095) 22 969 2,167 0 0 Annual Market Value Changes 1 532 1,432 1,643 1,000 1,000 From Checking Account 4056 4,394 4760 4,400 4,800 US West Antenna Rent 55 315 44,146 77 166 0 0 3 417 6 284 7 289 5 000 5 000 ._____.�.__.______v.�.. 116 651 231 574 265,639 130 400 140 800 3 500 3,500 3,500 3 500 3,500 Arena Bldg Grounds Mainl 3 500 3 500 3,500 3 500 3,500 $120151 $235,074 $269,139 $133,900 $144,300 $5 473 508 $6 207 031 $6,445 745 $6 501 600 $7,338,100 $2 045 066 S2 555,938 $2,558 208 $1 811,589 $1 930 789 Grand Total Less Ad Valorem, LGA HACA, LPA Fiscal Disparities r Page Four 2003 BUDGET WORKSHEETS GENERAL FUND REVENUES July 10 2002 Account# Description 101 34108 00 000 General Fund Admin Fees 101 34108 00 000 1 Fund 201 101 34108 00 000 2 Fund 202 101 34108 00 000 3 Fund 203 101 34108 00 000 4 Fund 206 101 34106 00 000 5 Fund 207 101 34108 00 000 8 Fund 605 101 34108 00 000 9 Fund 606 101 34108 00 000 11 Fund 607 101 34108 00 000 12 Fund 650 Admm Fees Breakdown Totals 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $25000 $25,000 $25,000 $25,000 $25,000 6,000 2 500 2 500 2 500 2 500 1,000 1 000 1 000 6 000 $25 000 $25,000 $25000 $25,000 $25000 $25 000 Comments 8 I Page One 2003 BUDGET WORKSHEETS COUNCIL July 10 2002 Account Description 101 41110 103 Salaries Benefits 101 4111001 307 Management Fees 101 4111001 307 1 Newsletter 101 41110 01 3072 Chamber of Commerce Directory 101 4111001 3073 Council Projects 101 41110 01 319 Other Professional Services 101 41110 01 319 1 Education Reimbursement 101 4111001 3192 Planning Consultant 101 41110 01 329 Other Communication Costs 101 4111001 331 Travel Expense 101 4111001 433 Dues Subscriptions 101 4111001 433 1 -MC Dues 101 4111001 4332 AMM Dues 101 4111001 4333 NDCC Dues 101 4111001 435 Books Pamphlets 101 4111001 437 Conferences Seminars 101 4111001 4371 Registration Hotel-1-MC Conf 101 41110 01 4372 Miscellaneous Conferences 101 41110 01 439 Other Miscellaneous Charges 101 41110 01 598 Council Designated 101 41110 01 5981 Yearly Contingencies PAGE TOTALS DEPARTMENT TOTALS I 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $18,781 $19,048 $25,533 $25700 $25,700 Salary, Taxes PERA Benefits 19,781 13,672 20,004 15,500 18,000 5 000 1,000 12,000 2 539 4,230 5,579 15,700 17,000 5 000 12,000 0 313 0 0 0 0 176 469 300 700 11,546 4,259 13106 13,800 14500 10,000 4 000 500 62 0 0 100 100 4 946 2 741 2,061 3,500 3,500 2000 1 500 19,294 16,123 36,524 0 0 21,160 2,767 11,199 14,000 14,000 14,000 $98,107 $63328 $114,475 $88,600 $93500 $98 107 $63328 $114475 $88,600 $93500 I I Page One 2003 BUDGET WORKSHEETS ADMINISTRATION July 10, 2002 Account# Description 101 41320 101 10141320 102 101 4132001 207 101 4132001 2071 101 4132001 207 2 101 41320 01 207 3 101 4132001 209 101 41320 01 307 101 4132001 331 101 41320 01 331 1 101 41320 01 331 2 101 4132001 331 3 101 41320 01 331 4 101 4132001 341 101 41320 01 353 101 4132001 394 101 4132001 433 101 4132001 4331 101 41320 01 4332 101 4132001 4333 101 4132001 4334 101 4132001 4335 101 4132001 4336 101 4132001 4337 101 4132001 435 101 4132001 437 101 4132001 437 1 101 41320 01 4372 101 41320 01 4373 101 4132001 4374 101 41320 01 4375 101 4132001 4376 101 4132001 4377 Salaries Benefits Fuli -Time Overtime Training Instructional Supplies Safety Committee Right to Know Employee Training Other Office Si Management Fees Travel Expense State Conference -MC State Conference MCMA Personnel Workshops ICMA Conference Employment Advertising Ordinance Publication P C Software Purchases Dues Subscriptions MCMA Dues MAMA Dues MCFOA Dues IIMC Dues IPMA Dues ICMA Dues SHRM Dues Books Pamphlets Conferences Seminars Registration Hotel LMC Registration Hotel MCMA Personnel Conferences Staff (1) Each Miscellaneous Seminars Registration Hotel ICMA Advanced Clerks School 101 41320 01 580 Other Equipment Purchases 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 $263673 $232,990 $273,533 $305,200 $325,700 Salary Taxes PERA Benefits 667 1867 0 1000 1,000 270 1,439 0 1,900 1,900 2D0 1,200 500 252 390 22 300 300 Miscellaneous Purchases 3,207 5627 3402 4,000 4000 Labor Consultant 11086 402 614 600 600 50 50 100 400 0 913 0 0 0 661 1 134 2,757 2,000 2 Codification of Code 0 3 111 2,061 0 0 11256 9,210 1,353 1,300 1 500 75 75 75 100 75 900 200 60 309 385 100 100 1 692 3 100 1,543 3,000 3 000 300 200 500 200 400 1,200 200 0 0 0 900 900 Typewriter Organizer $272822 $260,493 $285,670 $320,300 $341,000 $272822 $260493 $255,670 $320300 $341,000 i Page One 2003 BUDGET WORKSHEETS ELECTIONS July 10 2002 Account De5cnpnon 101 41410 103 Part-Time Salaries 101 41410 01 203 101 41410 01 208 101 41410 01 219 101 4141001 242 101 4141001 319 101 41410 01 321 101 41410 01 351 101 4141001 409 101 41410 01 412 101 4141001 439 Printed Forms Paper Miscellaneous Supplies Other Operating Supplies Minor Equipment Other Professional Services Telephone Costs Legal Notices Publishing Other Contracted Repair Mamt Building Rental Other Miscellaneous Charges 101 41410 01 560 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $0 $9,909 $0 $11,000 $0 Election Judges -2 New Precincts 0 332 0 600 0 Ballots Programming 0 1 082 0 1 000 0 Election Purchases 0 197 0 300 0 Rolls for Elector, Judges 0 1,551 0 2,000 0 Booths Signs 0 1,022 0 1000 0 0 10 0 0 0 0 54 0 100 0 Electon Publications 0 0 0 800 0 Maintenance for Optechs 0 0 0 500 0 Possible Rent for Locations a 0 0 0 0 0 1,136 10 200 5,700 10 000 Off -Year For Future Equipment $0 y $15293 $10,200 $23000 $10,000 $0 $15,293 $10200 $23,000 $10,000 E Page One 2003 BUDGET WORKSH SETS FINANCE July 10, 2002 Account# Description 101 41520 101 Salaries Benefits 101 41520 102 Full -Time Overtime 101 41520 01 319 Other Professional Services 101 41520 01 331 Travel Expense 101 4152001 331 1 Finance Director 101 4152001 331 2 Staff 101 4152001 391 P C Maintenance 101 4152001 391 1 Civic Systems Applications Support 101 4152001 391 2 Civic Systems System Support 101 4152001 391 3 General Network Suoport 101 41520 0 391 4 Motor Vehicle SIN Maint 101 4152001 391 5 Fixed Asset Mamt Contract 101 4152001 391 6 Miscellaneous P C Repairs 101 41520 01 392 P C Accessories Supplies 101 4152001 393 P C Hardware Purchases 101 4152001 394 P C Software Purchases 101 4152001 409 Other Contracted R M 101 4152001 433 Dues Subscriptions 101 4152001 433 1 MORA Annual Fees 101 4152001 4332 MGFOA Finance Director 101 4152001 433 3 MGFCA Staff 101 4152001 4334 GFOA Finance Director 101 4152001 4335 Magazine Subscriptions 101 4152001 435 Books Pamphlets 101 41520 01 435 1 Accounting Related Books 101 41520 01 435 2 Finance Related Books 101 41520 01 437 Conferences Seminars 101 41520 01 437 1 MDRA Conference (For 2) 101 4152001 437 2 MGFOA Annual Conf (F /D) 101 4152001 4373 GFOA National Conf (F/D) 101 41520 01 4374 Management Classes 101 41520 Cl 4375 Miscellaneous Seminars 101 4152001 439 Other Miscellaneous Charges 101 41520 01 570 Office Equipment Furnishings PAGE TOTALS DEPARTMENTTOTALS 28,324 24,539 36,564 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 25 000 All Salary Costs Inclusive of $104284 $119,814 $136004 $195400 1 000 $206,300 Salary Taxes PERA Benefits 164 307 1,910 500 1 000 500 5,800 0 0 10 000 10,000 F/A Reinventory Infrastructure 185 126 384 800 3 000 800 831 607 1,203 2,000 600 National Convention Misc 0 95 1,000 200 140 28,324 24,539 36,564 39,000 43,000 10 000 4 000 25 000 250 Hours of Support Time 1 000 1 000 2,000 1,077 2 384 1 133 3,000 3 000 City System Supplies 831 607 1,203 2,000 2000 2631 0 95 1,000 1,000 140 245 100 300 300 Cash Register Repairs 277 120 381 600 600 200 60 50 200 100 33 53 0 200 200 100 100 1,109 1,104 2,017 2,000 3,000 200 300 1,000 1,000 500 166 108 209 500 500 Contigenaes 0 417 0 0 0 $145,020 $149,825 $180,000 $255300 $271,200 $145020 $149,825 $180,000 $255300 $271,200 I Page One July 10, 2002 2003 BUDGET WORKSHEETS GENERAL GOVERNMENT Account N Description 101 4181001 202 101 4181001 202 1 101 4181001 2022 101 4181001 203 101 41810 01 203 1 101 41810 01 2032 101 4181001 2033 101 41810 01 2034 101 41810 01 2035 101 41810 01 2036 101 41810 01 204 101 4181001 2041 101 41810 01 2042 101 4181001 2043 101 4181001 2044 101 41810 01 2045 101 41810 01 209 101 41810 01 221 101 4181001 242 101 41810 01 2421 101 4181001 2422 101 4181001 2423 101 4181001 301 101 4181001 301 1 101 4181001 301 2 101 4181001 301 3 101 4181001 3014 101 4181001 304 101 4181001 319 101 4181001 3191 101 4181001 3192 101 4181001 3193 101 4181001 319 4 101 41810 01 320 101 41810 01 321 101 4181001 321 1 101 41810 01 321 2 101 41810 01 321 3 101 4181001 322 101 41810 01 328 101 41810 01 329 101 4181001 329 1 101 4181001 3292 101 4181001 3293 101 4181001 339 101 4181001 351 101 4181001 351 1 101 4181001 351 2 101 4181001 351 3 Duplicating Copying Records Retention Copying Costs Printed Farms Paper Copy Paper General Receipt Books Purchase Orders Payroll Checks AIR Checks Greenbar Computer(30 Boxes) Envelopes Letterheads Letterhead Plain Envelopes ArP Payroll Envelopes 10 x 13 Envelopes 10 x 15 Envelopes Other Office Supplies Equipment Parts Minor Equipment Slate Purchasing Program Fax Machine Mamt Agreement HP 5si Printer Maintenance Auditing Accounting Services 2001 Audit General Consulting Dakota County Assessment Fees Dak Cry Truth In Taxation Costs Printing of Budget Books Legal Fees Other Professional Services Fire Relief Association Flex Admm Plan Fees SW W C Cc- operative Dues Continuing Disclosure Fees Credit Card Activity Fees Telephone Costs General Phone Costs E -Mail Server Costs Web Server Costs Postage Costs Cable Supply Costs Other Communication Costs Cable JPA Payment General City Cable JPA Payment Port Authority Addition Cable TV Programming Other Transportation Expenses Legal Notices Publishing Costs for Public Notices Truth in Taxation Notices Budget Audit Publications 101 41810 01 439 Other Miscellaneous Charges 101 41810 01 580 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $8,627 $12,367 $20,180 $13,000 3,925 10,109 4,714 10,000 2 689 3,488 750 3,500 13 558 14 079 15,887 15 000 95 903 0 500 734 350 674 1 200 33,466 34,093 37,201 46,000 44,118 51,577 45,864 75,000 28,942 50,062 42,298 4,500 0 0 477 0 47,910 53,085 54,926 59,600 14,936 12,937 10,586 16 000 0 0 0 0 0 5,214 21,298 31,000 253 689 135 800 4,624 2,740 3,238 5 600 115 100 188 0 11 102 15,023 10,973 17 000 350 250 600 50,000 5,000 3,000 2000 0 2,500 500 5,000 55,000 4,000 1,000 35,000 5,000 30,000 3,400 1 000 1,200 $215094 $266,818 $209479 $298,700 $215094 $266818 $269,479 $298700 16000 $25,000 10,000 City Hall Equipment Repairs 15,000 10 000 2,500 1,200 Increased GASB Requirements 1 200 General City Legal Fees 1 100 2200 Moved to Fire Dept Budget 1,800 Insurance Plans 3,500 1 100 600 Monthly Billings 800 Insurance Plans 600 400 Tapes Reimbursable Costs 350 250 600 50,000 5,000 3,000 2000 0 2,500 500 5,000 55,000 4,000 1,000 35,000 5,000 30,000 3,400 1 000 1,200 $215094 $266,818 $209479 $298,700 $215094 $266818 $269,479 $298700 16000 General Office Supplies 500 City Hall Equipment Repairs 1 200 Yearly Fees for Program 60,000 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 Reimbursable Costs 70 000 Insurance Plans 800 General Costs 5,600 All Departments Billing from Dakota County State Mandated Publications 0 17,000 Copy Machine Leases All Bldgs (Fax Machine Postage Meter) $370,000 $370000 r Page One 0 2003 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT July 10, 2002 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 41910 101 Salaries Benefits $320369 $354,471 $459,553 $601,500 $700,700 Salary Taxes PERA Benefits 101 41910 102 Full -Time Overtime 968 1 507 438 3,000 3,000 Add Assistant Planner 101 41910 103 Part-Time Salaries Benefits 31,463 7,288 25,340 55,400 56,600 101 41910 103 1 Interns 17,500 10141910 1032 PIT Building Secretary 34,100 101 41910 1033 Planning Commission Members 5,000 101 4191001 201 Office Accessories 2020 0 223 400 400 Calendars Planners etc 101 41910 01 202 Duplicating Copying 99 0 0 500 200 Annual Codification -Zoning Ord 101 41910 01 203 Printed Forms Paper 1 057 736 1,060 2,200 1,200 Farms Stickers Tags etc 101 41910 01 205 Drafting Supplies 0 0 0 100 100 Zpatone Spray Mount 101 41910 01 208 Miscellaneous Supplies 0 59 121 200 200 Calculators 101 41910 01 209 Other Office Supplies 121 187 238 300 600 Dictation Devices Tapes 101 41910 01 219 Other Operating Supplies 143 22 1,246 500 900 Building Insoecton Supplies 101 4191001 241 Small Tools 250 0 490 400 400 Inspectors' Tools 101 4191001 305 Medical Dental Fees 0 227 76 0 0 101 4191001 312 Contract Inspection Fees 20 768 0 0 0 0 Fees for Contracted7emp Sery 101 4191001 319 Other P Services 1740 5077 3,346 1000 2000 Planning Consultant 101 41910 01 329 Other Communication Costs 863 213 1,288 1 500 1 500 Cellular Phone Pagers 101 41910 01 331 Tra,el Expense 305 228 191 500 500 101 41910 01 341 Emplovment Advertismg 8,737 4 883 906 1,000 1 000 101 4191001 391 P C Maintenance 80 3 980 2,016 6,000 6 000 S!W Maml, Perm4works Support 101 41910 01 392 P C Accessories Supplies 2016 1,495 65 1,000 500 101 4191001 433 Dues Subscriptions 1,021 1,083 1,311 1,900 1900 101 41910 01 433 1 APA/AICP 600 101 41910 01 433 2 ICBO 400 Dues for Additional Inspector 101 41910 01 433 3 North Star 200 101 41910 01 4334 Lake Country 150 101 4191001 4335 IAPMC National State 50 101 4191001 4336 Trade Magazines 150 101 41910 01 4337 Planner's Journal 100 101 4191001 4338 Sensible Land Use Coalition 150 101 4191001 433 9 Secretaries Association 100 101 4191001 435 Books Pamphlets 147 234 89 900 400 Manuals, References IBC Books 101 41910 01 437 Conferences Seminars 3 502 3,897 3,270 6,000 6,000 101 41910 01 437 1 State Bldg Official School 500 101 4191001 4372 Spring Fall Code Updates 300 101 4191001 4373 ICBO Seminars (2 Times/Year) 1,400 4 Persons Q $175 101 4191001 4374 Computer Training 400 101 4191001 437 5 Clerical Seminars 500 101 4191001 4376 Planning Seminars 500 101 41910 01 4377 ISTS Training 500 101 41910 01 437 8 State Planning Conference (2) 800 101 4191001 437 9 Planning Commissioner Training 300 101 4191001 437 10 Gen'I Seminars (Motivational) 400 Code Enforcement Seminars 101 4191001 437 11 Other Bldg Inspection Training 400 101 41910 01 439 Other Miscellaneous Charges 176 46 531 400 400 Contingencies 101 4191001 570 Office Equipment Furnishings 0 799 0 0 0 PAGE TOTALS $395,845 $386,431 $501797 $684,700 $784500 DEPARTMENT TOTALS $395845 $386,431 $501 797 $684,700 $784,500 0 Page One 2003 BUDGET WORKSHEETS POLICE July 10 2002 Account# Description 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 10142110 101 Salaries Benefits 1,069400 1108455 1,190,076 $1,363,500 101 42110 102 Full -Time Overtime 66,280 58,601 78 563 50 000 101 42110 1021 Regular Overtime Hours 101 42110 1022 Contracted 07 101 42110 103 Part-Time Salaries Benefits 23,161 22,000 26,722 42,400 101 4211001 202 Duplicating Copying 589 723 694 500 101 4211001 203 Punted Forms Paper 766 576 926 1,000 101 4211001 204 Envelopes Letterheads 108 48 230 200 101 42 01 207 Training& Instructional Supplies 3247 1,897 1568 2500 101 4211001 207 1 Practice Ammunition 101 4211001 207 2 Service Ammunition 101 4211001 208 Miscellaneous Supplies 4,007 6,464 6,273 0 101 4211001 209 Other Office Supplies 1,620 1,289 1,796 2,000 101 4211001 211 Cleaning Supplies 31 288 9 400 101 4211001 211 1 Blanket Cleaning 101 4211001 211 2 Squad Interior Cleaning 101 42110 01 217 Clothing Allowance 0 4,426 2,518 3,000 101 42110 01 219 Other Operating Supplies 2,613 927 1,171 1,000 101 42110 01 221 Equipment Parts 691 2,595 1,156 2,500 101 42110 01 241 Small Tools 339 1,253 1,313 1,500 101 4211001 242 Minor Equipment 0 0 5,761 1,500 101 4211001 304 Legal Fees 54,996 54,996 54,996 56,000 101 4211001 305 Medical Dental Fees 1,334 849 840 1,000 101 4211001 305 1 Miscellaneous Fees 101 4211001 305 2 Narcotic Testing 101 42'10 01 306 Personnel Testing Recruitment 2 657 300 4 732 4 500 101 4211001 316 Animal Care Services 13 293 16,097 12 074 14 000 101 4211001 316 1 Impound Care Fees 101 42110 01 316 2 Deer Inventory 101 4211001 319 Other Professional Services 55,344 63,678 54,950 61,000 101 4211001 319 1 Dispatch Services 101 4211001 3192 Radio Repeater Phone Lines 101 4211001 321 Telephone Costs 8,784 13,085 8,940 6,000 101 42110 01 321 1 Cell Phones 101 42110 01 321 2 Pagers 101 4211001 321 3 LOGIS Line 101 42110 01 323 Radio Units 1 903 2,303 1,389 3,000 101 4211001 331 Travel Expense 2,252 2 556 2,030 3,000 101 42110 01 331 1 MCPA Conference 101 4211001 331 2 IACP Conference 101 4211001 331 3 Outstate Investigations 8 Conferences 101 4211001 331 4 Juvenile Officers Conference 101 4211001 333 Freight Express Expenses 95 7 58 200 101 4211001 341 Employment Advertising 676 779 416 1,000 101 4211001 394 P C Software Purchases 0 0 0 1 200 101 4211001 396 Computer Maintenance 17 711 30,169 39,046 49 000 101 4211001 396 1 LOGIS Records CAD 101 4211001 3962 CJDN Connection Charges 101 4211001 3963 MCD Connection Charges 101 4211001 3964 1 Maintenance Charges PAGE TOTALS 1,331,897 1394,362 1498,247 1,671,900 All Salary Costs Inclusive of $1 581 500 Salary Taxes, PERA Benefits 70 000 Add Sergean Officer 45,000 25,000 28,000 Prr CSO's Total 50 HrsMk 800 Film Developing 1,000 Evidence Logs Animal Lic etc 200 2 500 2,000 500 0 Donated Forfeited Funds 2,000 Video Audio Tapes Mime 400 100 300 3 000 CSO /ReserveiChaplain Uniforms 1,000 Evidence Bags 1st Aid Drug Kits 2,500 Squad Emergency Equip Repairs 1,500 Crime Scene Kit Supplies 1,500 Less Lethal Supplies 56,000 Prosecution 1,000 500 500 4,500 Career /Recruiting Fairs Hiring 15 200 14 000 1,200 65,000 61 500 3,500 6,000 4,900 600 500 3,000 Radio Radar Repairs 3 000 500 1,500 700 300 200 Repairs 1 000 Officer Hiring 1,200 Criminal Justice Integration Pmj 60 000 43,000 3,000 4,000 10,000 Moved from (310) Above 1 912,000 a Page Two 2003 BUDGET WORKSHEETS POLICE July 10, 2002 Account# Description 101 42110 01 409 Other Contracted Repair 8 Mamt 101 4211001 415 Other Equipment Rental 101 4211001 433 Dues 8 Subscriptions 101 4211001 433 1 Mutual Aid Assistance Group 101 4211001 433 2 IACP Chiefs Dues 101 4211001 433 3 MN Chiefs of °ohce Dues 101 4211001 4334 Dakota Cty Chiefs of Police 101 4211001 433 5 W akota CAER Dues 101 4211001 433 6 Metro Emergency Managers 101 4211001 433 7 MN Sex Crimes Investigators 101 4211001 433 B Tri- County Investigators 101 4211001 4339 Miscellaneous 101 4211001 43310 P O S T Licenses 101 4211001 435 Books Pamphlets 101 4211001 436 Towing Charges 101 4211001 437 Conferences 8 Seminars 101 4211001 4371 Firearms Training 101 42110 01 4372 Cheers Spring Training 101 42110 01 437 3 Chiefs Fall Conference 101 42110 Cl 4374 IACP Conference 101 4211001 437 5 Emergency Management 101 4211001 437 6 Miscellaneous 101 4211001 439 Other Miscellaneous Charges 101 4211001 580 Other Equipment Purchases PAGETOTALS DEPARTMENT TOTALS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 0 0 0 0 0 0 0 0 500 500 453 2,118 1,548 2,000 3,000 1,200 53 184 223 300 (31) 218 318 200 8692 10,200 9,435 12000 569 50 204 500 329 430 286 600 150 150 50 20 25 30 50 525 800 300 Statutes Crime Prevention 200 12,000 1 500 500 200 400 400 9,000 500 Contingencies 4,000 Digital Recorders $10,066 $13,200 $12015 $16,100 $20,500 $1, 341 ,963$1,407,562$1510261$1686000 $1,932,500 t Page One 2003 BUDGET WORKSHEETS FIRE July 10, 2002 Account# Description 101 42210 103 10142210 1031 10142210 1032 10142210 1033 10142210 1034 101 42210 1035 101 42210 1036 101 4221001 202 101 42210 01 202 1 101 42210 01 2022 101 42210 01 2023 101 4221001 204 101 4221001 204 1 101 4221001 2042 101 4221001 2043 101 4221001 208 101 4221001 2081 101 4221001 2082 101 4221001 2083 101 4221001 2084 101 42210 01 2085 101 4221001 211 101 4221001 211 1 101 4221001 211 2 101 4221001 211 3 101 4221001 211 4 101 4221001 218 101 4221001 219 101 42210 01 219 1 101 4221001 2192 101 4221001 2193 101 4221001 2194 101 4221001 2195 101 4221001 219 6 101 4221001 229 101 4221001 229 1 101 4221001 2292 101 4221001 229 3 101 4221001 2294 101 4221001 230 101 4221001 2301 101 4221001 2302 101 4221001 2303 101 4221001 2304 101 4221001 2305 101 4221001 230 6 101 4221001 241 101 42210 01 241 1 101 4221001 241 2 101 4221001 241 3 Salaries Benefits Salaries Training Pay!Stipends Call Pay /Stipends Class PaylStipends Fire Relief Pension Contributions P/T Fire Marshal Duplicating Copying Copy Toner Laser Printer Fax Machine Envelopes Letterhead Envelopes Letterhead Forms Miscellaneous Supplies Supplies Computer Support Film Developing Memberships Code Books Training Cleaning Supplies Soap Chamois Towels, etc Sponges, etc SCBA Cleaner Fire Department Clothing Other Operating Supplies Gloves Bandages Equipment Tyvek Suits Consummable Medical Oxygen Other Maintenance Supplies Aerta I- Pumpers -Ta nke r Pickup Trucks Rescue Other Vehicle Modifications Equipment Repair Materials Light Bars Smoke Machines Lanterns Small Tool Repairs; Opticom Station Small Tools Axes Bars Other Grass Fire Hand Tools 101 4221001 305 101 4221001 306 101 4221001 306 1 101 4221001 3062 101 4221001 3063 101 4221001 306 4 101 4221001 308 101 4221001 308 1 101 4221001 3082 101 4221001 308 3 101 4221001 3084 101 4221001 3085 101 4221001 3086 101 4221001 3087 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) °ire Fighter Re- Certrt6cates (7) First Responder (4) First Responder Refresher (112) Outside Schools ($12) Haz -Mat Training (4) PAGE TOTALS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $104,666 $123,789 $130,003 $194500 $199,600 Salary Taxes PERA Benefits 18,100 Reduced Balance to Pension 2,000 Reduced Balance to Pension 13,750 Reduced Balance to Pension 150 Reduced Balance to Pension 135,000 $28 000 from Gen'; GcO, Bal New 30,600 138 132 113 100 100 25 25 50 108 103 61 100 100 25 25 50 2 281 3,367 2,675 4,500 3,400 Supplies for Fire Marshal 1 500 100 300 500 1,000 80 156 174 300 300 100 100 25 75 123 493 222 300 300 5 Uniforms Q $60 Each 564 521 2,256 1 000 1,500 Medical Supplies 300 80 100 70 800 150 12,351 4,178 13,032 2,900 2 2,300 200 200 200 1,441 634 1,465 1,500 1 500 100 150 150 500 300 300 834 439 491 700 700 150 250 300 1930 1 1755 2600 4,500 Annual Medical Tests 467 1,786 1,260 2,100 2,100 1,000 500 100 500 6 632 4,784 5 141 10,800 10,800 1,200 140 180 1,000 1,400 5,900 1,000 131,612 142379 158,647 221,400 227,800 r Page Two 2003 BUDGET WORKSHEETS FIRE July 10, 2002 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 101 4221001 310 Testing Services 1,778 1,391 1,545 900 1,500 101 4221001 310 1 Aerial (Next 2005) 0 101 4221001 310 2 Ladders (Next 2005) 500 101 4221001 3103 Pumpers (3) (Next 2004) 0 101 4221001 310 4 SCBA Hydro Testing (Next 2008) 1 000 101 4221001 313 Temporary Service Fees 1 065 838 872 1,400 6 400 101 4221001 313 1 SCBA Contract 400 101 4221001 313 2 SCBA Maintenance 200 101 4221001 313 3 Copier Contract 400 101 42210 01 3134 Security Contract 400 101 4221001 3135 Technical Team Joint Powers 5,000 101 4221001 319 Other Professional Services 1,712 1,870 2,232 2,300 2 500 Fire Prevention Education 101 4221001 319 1 School Literature 350 101 4221001 319 2 Door Prizes 250 101 4221001 319 3 Fire Prevention Week Promos 1,300 101 4221001 319 4 Food at Open House 150 101 4221001 3195 Adult Extension Classes 250 101 4221001 319 6 Trading Cards 200 101 4221001 321 Telephone Costs 225 276 230 300 600 101 4221C 01 321 1 Chief 150 101 4221001 321 2 Assistant Chief 150 101 4221001 321 3 Rescue 150 101 42210 01 321 4 Numeric Pagers 150 101 4221001 322 Postage Costs 0 10 0 100 100 UPS Casts 101 42210 01 329 Other Communication Costs 391 820 1,100 1,000 1,000 101 4221001 329 1 Base Repairs 200 101 42210 01 329 2 Pager Repairs 200 101 4221001 3293 Hand Held Repairs 300 101 4221001 3294 Mobile Repairs 300 101 4221001 331 Travel Expense 2,115 3942 4,813 7,800 7,800 101 4221001 331 1 Minnesota Chief's Conference 1 100 101 4221001 331 2 Fire Department Association 900 101 42210 01 331 3 Outside Schools 5,800 101 4221001 433 Dues Subscriptions 541 475 545 700 900 101 4221001 433 1 Capital City 35 101 4221001 4332 VFBA Insurance 160 101 4221001 433 3 Stale Fire 170 101 4221001 4334 State Chiefs 250 101 4221001 4335 DCFC 30 101 4221001 4336 WAKOTA Mutual Aid 20 101 4221001 433 7 Purchasing Consortium 35 101 4221001 4338 NFPA 100 101 4221001 4339 MN Ass'n Fire Marshals 100 Fire Marshal Dues 101 4221001 437 Conferences Seminars 270 405 405 700 700 101 42210 01 437 1 Slate Fire Conference 400 101 4221001 437 2 State Chiefs Conference 300 101 4221001 439 Other Miscellaneous Charges 706 759 981 1,200 1 101 42210 01 439 1 Food Coffee 190 101 42210 01 439 2 Extinguisher 400 101 42210 01 4393 Plaques 20 101 42210 01 439 4 Paint 50 101 4221001 439 5 Station Needs 540 101 4221001 580 Other Equipment Purchases 12 358 18,312 10,136 17,000 15,000 101 4221001 580 1 Bunker Gear (9) 9,000 101 42210 01 5802 Pagers (6) 3,000 101 42210 01 580 3 Hose Replacement 2000 101 4221001 5804 Replace Damaged Items 1 000 101 4221001 581 Other Equipment Purchases 1 709 0 18,450 0 0 PAGE TOTALS $22871 $29098 $41108 $33,400 $37700 DEPARTMENT TOTALS $154482 $171,477 $199,755 $254,800 $265,500 Page One PAGE TOTALS $282,277 $264148 $287780 $312900 $321 800 DEPARTMENT TOTALS $282277 $264,148 $287,780 $312900 $321800 I 2003 BUDGET WORKSHEETS GOVERNMENT BUILDINGS July 10 2002 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 41940 1D1 Salaries 8 Benefits $45 268 $37,215 $42,195 $45500 $48,800 Salary Taxes, PERA 8 Benefits 101 4194079 101 Maintenance 48,600 10141940 102 Fuli -Time Over4me 2,523 3,794 4,055 3,000 4000 101 4194001 208 Miscellaneous Supplies 16 084 13,691 12,299 15 500 17,000 Cleaning Supplies Towels etc 101 41940 01 223 Building Repair Supplies 3 164 704 4,499 4 000 4 000 101 41940 01 225 Landscaping Materials 0 0 0 500 500 Trees 8 Shrubs 101 41940 01 241 Small Tools 0 455 458 200 200 Hand'polls, Bits, Blades etc 101 41940 01 242 Minor Equipment 0 0 2,125 2,000 2,000 Carpet Cleaner Replacement 101 41940 01 302 Architects Fees 572 0 0 1 000 1,000 Estimates 101 41940 01 318 Contract Engineer 0 0 4,958 5,100 5,100 Contracted Engineer for City 101 4194001 319 Other Professional Services 20 650 24,452 15 977 18 800 21,300 101 41940 01 319 1 Elevator Maintenance 1000 101 4194001 319 2 Heating /Cooling Maint Contract 5 000 101 41940 01 3193 Annual RPZ Inspection 1,500 101 41940 01 3194 Pest Control 500 101 4194001 319 5 Fire Exhngushers 1,000 101 4194001 3196 Fire Suppression System Check 1 coo 101 4194001 319 7 Janitorial Seance -New Fire Station 3,500 101 4194001 3198 Janitorial Serv,ce -P W Building 7 800 101 41940 01 341 Employment Advertising 0 0 374 0 0 101 41940 01 381 Electric Utilities 32,680 34,758 33 199 40,000 40,000 101 4194001 383 Gas Utilities 16,333 28,708 38,710 40,000 40000 101 41940 01 384 Refuse Disposal 15 135 16 245 21 203 28 000 28,000 101 41940 01 3841 General Buildings 8 Parks 18,000 101 41940 01 3842 Recycling /Cleanup 10 000 101 4194001 389 Other Utility Services 2,613 3,122 3 219 3 000 3,000 Floor Mats Monthly Charges 101 4194001 401 Contracted Building Repairs 30 768 9 676 14,375 14,000 14,000 101 4194001 401 1 Electrical Repairs 1,500 101 41940 01 401 2 Miscellaneous Siren Repairs 3 000 101 41940 01 401 3 Miscellaneous Repairs 9 500 101 41940 01 412 Building Rental 6,000 202 0 0 0 U of M Storage (To CIP) 101 4194001 415 Other Equipment Rental 0 0 146 1,000 1,000 Scaffolding, Cleaners 101 4194001 439 Other Miscellaneous Charges 188 2,328 0 1,000 1,000 Contingencies 101 4194001 601 Bond Principal 26,632 26,632 29,053 31,500 33,90D MSABC Payment (2/1) 101 4194001 611 Band Interest 63 666 62,167 80,545 58 800 56,800 MSABC Payments (2/1 8 811) 101 4194001 621 Bond Paying Agent Fees 0 0 390 0 400 PAGE TOTALS $282,277 $264148 $287780 $312900 $321 800 DEPARTMENT TOTALS $282277 $264,148 $287,780 $312900 $321800 I Page One I I 2003 BUDGET WORKSHEETS FLEET MAINTENANCE July 10 2002 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 10143100 101 Salaries Benefits $116,201 $122,333 $120844 $127800 $135400 Salary, Taxes PERA Benefits 101 4310077 101 Administrative 18,000 101 4310079 101 Maintenance 117,400 101 43100 102 Full -Time Overtime 7,993 9 958 5 596 8 000 8 000 101 4310099 103 Part-Ttme Salaries Benefits 0 0 0 4,000 0 101 4310001 211 Cleaning Supplies 517 565 711 500 500 Shop Vehicles 101 4310001 212 Motor Fuels 41,171 69,424 59,689 75,000 75 000 101 4310001 213 Lbncanls &Additives 7464 2804 2,596 5,500 5,500 101 4310001 215 Shop Materials 15,201 18618 17412 20500 20,500 101 43100 01 221 Equipment Parts 87 245 82,588 84 588 85 000 87 000 101 43100 01 222 Tires 19 293 5 707 9 126 15 000 20 000 101 4310001 241 Sall Took 4,364 4,565 4 024 4,000 4,000 101 4310001 242 Minor Equipment 14254 487 3,857 4,000 6,000 101 4310001 318 Contract Engineer 0 0 5,915 10 000 10,000 Contracted Engineer for City 101 4310001 321 Telephone Casts 1,019 304 0 0 0 101 4310001 323 Radio Units 1,612 1 079 737 2 000 2,000 RepainReplace Units 101 4310001 331 `ravel Expense 5 0 0 500 500 Overnight Training 101 4310001 341 Employment Advertising 333 0 718 0 0 101 4310001 384 Refuse Disposal 417 1 036 1,518 1,000 1 000 Shop Hazardous Waste 101 4310001 394 P S Software Purchases 485 1 173 252 500 500 General Software Support 101 4310001 404 Contracted Mach Equip Repairs 22 428 32,493 17,304 30,000 35 000 101 4310001 416 Machinery Rental 125 0 0 1 000 1 000 101 4310001 417 Uniforms Rental 83 112 118 0 0 101 4310001 433 Dues Subscriptions 0 0 0 0 0 101 4310001 435 Books Pamphlets 619 0 0 200 200 101 4310001 437 Conferences Seminars 523 1 640 165 1 000 1 000 PAGE TOTALS $341,352 $354888 $335171 $395,500 $413100 DEPARTMENT TOTALS $341352 $354,888 $335171 $395,500 $413100 I Page One July 10 2002 2003 BUDGET WORKSHEETS STREET MAINTENANCE Account# Description 101 43121 101 Salaries Benefits 101 43121 77 101 Administrative 101 43121 78 101 Technical /Clerical 101 43121 79 101 Maintenance 101 43121 102 Full -Time Overtime 101 43121 99 103 Part -Time Salaries Benefits 101 43121 01 201 Office Accessories 101 43121 01 203 Printed Forms Paper 101 43121 01 203 1 RW Permit Inspection Forms 101 43121 01 2032 Work Orders 101 43121 01 205 Drafting Supplies 101 43121 01 205 1 Paper for Plan Reproductions 101 43121 01 2052 OR -Site Reproductions 101 43121 01 2053 Film Developing 101 43121 01 2054 Miscellaneous Tools 101 43121 01 209 Other Office Supphes 101 43121 01 216 Chemical Chemical Products 101 43121 01 224 Street Maintenance Materials 101 43121 01 224 1 Paint 101 43121 01 2242 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 2252 Seed 101 43121 01 225 3 Black Dirt 101 43121 01 2254 Trees 101 43121 01 226 Sign Repair Materials 101 43121 01 231 Bituminous Patching Materials 101 43121 01 232 Crusned Rock 101 43121 01 233 Dust Control Materials 101 43121 01 234 De -Icing Sand 101 43121 C1 235 Shouldering Gravel 101 43121 C1 241 Small Tools 101 43121 01 242 Minor Equipment 101 43121 01 303 Engineering Fees 101 43121 01 304 Legal Fees 101 43121 01 305 Medical Dental Fees 101 43121 01 310 Testing Services 101 43121 01 318 Contract Engineer 1D1 43121 01 319 Other Professional Services 101 43121 01 321 Telephone Casts 101 43121 01 324 Messenger Services 101 43121 01 331 Travel Expense 101 43121 01 341 Employment Advertising 101 43121 01 381 Electric Utilities 101 43121 01 381 1 Street Lights 101 43121 01 381 2 Signal Lights Sirens 101 43121 01 384 Refuse Disposal 101 43121 01 384 1 Hazardous Waste Disposal 101 43121 01 384 2 Roadside Garbage 101 43121 01 384 3 Tree Disposal 101 43121 01 391 P C Maintenance 101 43121 01 391 1 Gopher Stale One -Call 101 43121 01 391 2 State Aid 101 43121 01 391 3 Pavement Plus SAN Support 101 43121 01 392 P C Accessories Supplies 101 43121 01 394 P S Software Purchases PAGE TOTALS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $304,024 $313463 $332,520 $405,800 $428,300 Salary Taxes, PERA Benefits 73,700 66 300 288,300 10,772 17,614 13,931 18,000 18,000 Maintenance 22,903 19,106 14 139 20 000 20 000 0 0 61 700 700 28 60 298 700 700 500 200 1386 850 1790 1,600 2 900 450 200 450 Inspection Equipment 20 31 61 200 200 Door Tags 18 576 19,114 13,861 25,000 25,000 De -Icing Chemicals (Salt) 62,592 1173 514 1,500 1,500 500 500 500 3,003 2,664 547 6,300 6 300 3 000 300 2000 1,000 139 2,656 6,362 5 000 5 000 0 22,907 17 826 25 000 27,000 0 16,991 19,046 18 000 25,000 0 19 006 24,095 22 000 25,000 0 7 380 8,543 8,000 8,000 0 313 1,681 3,000 3,000 667 834 895 1,000 1,000 Shovels, Brooms, etc 5,629 3 214 4,342 4,000 4 000 Safety Equipment 3,517 17,909 15,138 8,500 8,500 General Non Protect Related 20 2,701 13 2,000 2000 Appeals of Closed Projects 380 188 204 600 600 Employment Physicals 334 75 0 1200 1,200 0 0 0 20 000 20,000 Contracted Engineer for City 670 556 402 1 500 1,500 Random Drug Testing 279 1,882 3,209 2,000 2,000 Cellular Phones Pagers 0 0 0 100 100 339 185 8 1000 1,000 APWA Miscellaneous 2375 5900 1,673 1,000 1,000 76,423 87 263 95,210 90 000 100,000 95,000 5,000 306 867 351 2,600 2 600 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 0 Page Two 2003 BUDGET WORKSHEETS STREET MAINTENANCE July 10, 2002 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account# Description 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 0 4021 General Seal Coating 115,000 8 to 9 Miles Added 101 43121 01 4022 City Hall Schwarz Connemara 20,000 Parking Lots 101 43121 01 403 Contracted Repair Maintenance 145,280 2,487 0 7,000 7,000 101 43121 01 403 1 Street Lights 6,000 101 43121 01 403 2 Signal Lights 500 101 43121 01 403 3 Light Replacement$ 500 101 43121 01 405 Stree' S aping 0 15,941 13,214 19,000 26,000 101 43121 01 406 Street Sweeoing 0 3 752 2 462 6 500 10 000 101 43121 01 407 Bituminous Overlays 0 16,338 45,000 25,000 0 101 43121 01 408 Street Crack Sealing 0 9 843 10 000 20 000 35 000 101 43121 01 409 Tree Tnmminc 489 10546 6,342 10000 10000 101 43121 01 410 Concrete Sidewalk Repairs 0 3,585 4 316 5,000 133 000 101 43121 01 410 1 General Repairs 8 000 101 43121 01 4102 Pedestnan Improvements 125 000 101 43121 01 411 Snow Removal Commumly Center 780 11 452 8,398 12,000 12,000 101 43121 01 415 Gradefrpozer Rental 0 0 4047 2000 2,000 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 2000 2000 101 43121 01 433 Dues Subscriptions 604 670 830 900 900 101 43121 01 433 1 American Public Works Ass'n 225 (APWA) 101 43121 01 433 2 Request for Mutual Aid Ass'n 10 (RMAA) 101 43121 01 4333 Cdv 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 164 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 101 43121 01 4372 Computer Training 500 101 43121 01 437 3 Clerical 150 101 43121 01 4374 Gravel Road Maintenance 150 101 43121 01 4375 City Management Training 500 101 43121 01 437 6 CEAM 500 101 43121 01 4377 MN Pavement Management 400 101 43121 01 4378 MN Dot 300 101 43121 01 4379 Miscellaneous Training 450 Safety Training 101 43121 01 439 Other Miscellaneous Charges 25 245,147 200 2,000 2,000 7100 Rain Storm-FEMA Reimb 101 43121 01 570 Office Equipment Furnishings 547 0 0 0 0 PAGE TOTALS $168978 $368152 $154158 $191200 $394,700 DEPARTMENT TOTALS $689,637 $945,115 $736,254 $893800 $1142,200 Page One July 10, 2002 2003 BUDGET WORKSHEETS PARKS GROUNDS MAINTENANCE Account* Description 101 45202 101 Salaries Benefits 101 4520277 101 Administrative 101 4520279 101 Maintenance 101 45202 102 Full -Time Overtime 101 45202 99 103 Part -Time Salaries Benefits 101 4520201 205 Drafting Supplies 101 4520201 216 Chemical Chemical Products 101 4520201 216 1 Herbicides(General Park Use) 101 45202 01 216 2 Fertilizer 101 45202 01 219 Other Operating Supplies 101 45202 01 219 1 Seed Sod etc 101 4520201 219 2 Red Rock Sand, Gravel etc 101 4520201 221 Equipment Parts 101 4520201 221 1 Playground Equipment Repair 101 4520201 221 2 Irrigation Reeair(Non- Contract) 101 4520201 221 3 Miscellaneous(Player Benches) 101 4520201 221 4 Park Sign Replacements 101 4520201 223 Building Repair Supplies 101 4520201 223 1 Paint Stain etc 101 45202 01 223 2 Shingles Boards etc 101 45202 01 2233 Miscellaneous 101 4520201 223 4 Shelter /Shed Repairs 101 4520201 225 Landscaping Materials 101 4520201 225 1 Tees Shrubs Sod etc 101 4520201 2252 Timbers, Fence etc 101 4520201 226 Sign Repair Materials 101 4520201 229 Other Maintenance Supplies 101 45202 01 241 Small Tools 101 45202 01 242 Minor Equipment 101 4520201 303 Engineering Fees 101 4520201 318 Contract Engineer 101 4520201 321 Telephone Costs 101 4520201 323 Radio Units 101 4520201 331 Travel Expense 101 4520201 341 Employment Advertising 101 45202 01 381 Electric Utilities 101 4520201 381 1 Skating Rinks 101 4520201 381 2 Softball Fields 101 4520201 381 3 Irrigation 101 4520201 383 Gas Utilities 101 4520201 403 Contracted Repair Maintenance 101 45202 01 403 1 Irrigation Repairs 101 4520201 4032 Electrical Repairs '01 4520201 4033 Miscellaneous Repairs 101 4620201 409 Other Contracted Repair Mamt 101 4520201 416 Machinery Rentai 101 4520201 416 1 Mower Leases 101 4520201 4162 Miscellaneous Rentals 101 4520201 433 Dues Subscriptions 101 4520201 433 1 Memberships MRPA 101 45202 01 4332 Miscellaneous Dues 101 4520201 435 Books Pamphlets 101 4520201 437 Conferences Seminars 101 4520201 437 1 Seminars Workshops 101 4520201 4372 School Tuition 101 4520201 439 Other Miscellaneous Charges 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 $197,224 $223,002 $230,663 $286 700 $301 800 Salary, Taxes PERA Benefits 18,000 283,800 10 780 12,842 8,575 15,000 15,000 25,410 21,556 14,932 24,000 24 000 0 0 0 100 100 10,488 9,283 20,529 10 000 25,000 15 000 10 000 10,173 5,051 8,067 7,000 9,000 3,000 6 000 4,547 7,817 5,318 8,000 9,000 2,500 1 500 2 500 2,500 6,375 5,244 2,308 7,000 7 000 1 500 2,000 1,500 Calk Hardware etc 2 000 5,408 674 3,505 3,600 5,000 2,500 2,500 0 0 0 500 500 4 222 2,603 3,478 4 000 4 000 Paint, Chalk Bases, Field Dry, etc 4 849 2,672 4,198 2,500 2,500 Hand Tools, Blades Bits, etc 3,269 0 1 401 2,500 2,500 Safety Equipment 0 0 0 0 0 0 0 2,958 5100 5,100 Contracted Engineer for City 0 107 417 500 500 Cellular Phone Bills 0 0 0 500 500 Walkle- Talkies 0 4 0 100 100 Seminars Workshops 0 0 389 0 0 10,564 11,842 9,765 15,000 15,000 6 000 6,000 3,000 1,155 1,701 2,023 3 000 3,000 15,052 3,903 3,342 4,000 4 000 1,500 1,500 1 000 0 4,665 4,124 8,000 8,000 Chemical Lawn Services 14,869 8,898 11,390 15 000 15,000 14 000 1,000 35 150 25 200 200 100 100 0 0 0 100 100 593 2,062 474 500 500 300 200 0 0 0 200 200 Contingencies $325,014 $324,076 $337679 $423,100 $457600 $325014 $324076 $337,879 $423100 $457600 Page One 2003 BUDGET WORKSHEETS PARKS RECREATION July 10 2002 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 45100 101 Salaries Benefits $280 334 $321,900 $357994 $430300 $505 300 Salary Taxes PERA Begefils 101 45100 102 Full -Time Overtime 2 117 2,129 5,801 4,700 4,700 Add Red Supervisor 112 BMW 101 45100 103 Part-Time Salaries Benefits 103 625 102,223 101,190 143 900 126,600 101 4510008 103 P,'T Secretary 34,100 10145'0010103 R'T Receptionist 27500 101 45100 12 103 Building Attendants 33,000 101 4510083 103 Playground Recreation Leaders 16 500 101 4510094 103 Warming House Attendants 13,000 101 4510099 103 Park Rea Committee 2,500 101 4510001 205 Drafting Supplies 437 507 932 1,000 1,000 Film, Developing Laminating 101 4510001 207 Training Instructional Supplies 0 0 113 200 200 Books Tapes etc 101 4510001 208 Miscellaneous Supphes 730 517 314 500 500 Meeting Supplies 101 4510001 209 Other Office Supplies 909 754 1,029 1 000 1,200 Envelopes, Forms Rulers etc 101 45100 01 211 Cleaning Supplies 4 341 5 402 4 239 5 500 5 500 101 4510001 216 Chemicals Chemical Products 1 765 1 109 1,203 1 200 1,500 101 4510001 219 Cther Operating Supplies 2030 3 585 4,221 3 500 4,500 Rec Programs 1st Aid Sup, etc 101 45100 01 221 Equipment Parts 3 710 4 955 4,153 5 500 9,500 New Chairs Tables 101 4510001 223 Building Repair Supplies 4433 5829 3,159 5500 5500 101 45100 01 229 Other Maintenance Supplies 1 312 1,488 0 0 0 101 4510001 305 Medical Dental Fees 0 415 159 800 800 Employment Physicals 101 4510001 312 Contract Inspection Fees 0 9,622 6,250 5 600 6 500 Custodial Services- Banquet Rm 101 4510001 315 Special Programs 5,121 5,007 5,327 9700 9700 101 4510001 315 1 Sunday Night Specials 2,500 Performances 101 4510001 3152 Leprechaun Days 500 Trophies Awards 101 4510001 3153 Halloween 500 Supplies 101 45100 01 315 4 Ground Pounders(Running) 400 Ribbons Mailings 101 4510001 315 5 Nature Programs(Arbor Day, etc) 2,00C Trees 101 45100 01 3156 Puppet Programs 500 Tapes Fuses, Puppets, etc 101 45100 01 315 7 Special Events 1 000 Publicity Supplies 101 4510001 315 8 Adapt -A -Park Program 1 400 Flyers, Trees Signs 101 4510001 315 9 Miscellaneous Programs 500 Start Up Costs 101 4510001 315 10 ADA Programs 400 ADA Program Supplies 101 4510001 319 Other Professional Services 8,153 435 1,939 500 1,500 ADA Services /Eng LA Sery Test 101 45100 01 321 Telephone Costs 1,403 1,690 2,480 3,100 3,100 Pagers Cellular Phones 101 4510001 331 Travel Expense 390 0 114 500 500 101 4510001 341 Employment Advertising 4,227 1,969 2 824 2,800 2 800 General Emplovment Ads 101 45100 01 349 Other Advertising 13,531 15,906 17,163 22,300 22,300 101 4510001 349 1 Brochures 16,500 City Newsletter 101 4510001 349 2 Yellow Pages 3 400 Rec Ads 101 4510001 349 3 Special Marketing 2,400 New Program Flyers 101 4510001 381 Electric Utilities 14,878 15,456 19,275 26,000 26,000 101 4510001 383 Gas Utilities 12 850 24,326 26,744 28,600 28,600 101 4510001 384 Refuse Disposal 3 988 3 981 4 352 4,000 4 000 101 4510001 401 Contracted Building Repairs 5 485 9,834 8,305 6 000 8,000 101 4510001 404 Contracted Mach Equip Repairs 5,377 6,795 6 301 5 000 6,000 101 4510001 409 Other Contracted Repair Mamt 0 16 713 25 320 17 000 17,000 Air Handler Maintenance Contract 101 4510001 412 Building Rental 13,200 16 800 16,800 16 800 16,800 Monthly Rent Payments to Guard 101 4510001 415 Other Equipment Rental 10,234 12,155 11,511 15 000 18,000 Portable Toilets Other Rentals 101 4510001 433 Dues Subscriptions 1,194 1,005 1,362 1,200 1,500 101 45100 01 433 1 MRPA Dues 1 100 Minn Recreation Parks Ass'n 101 45100 01 4332 Miscellaneous 400 Paper Magazines JC Dues etc 101 4510001 435 Books Pamphlets 144 0 0 100 100 101 4510001 437 Conferences Seminars 1 694 1,310 1,911 3 500 4 000 101 4510001 437 1 MRPA State Conference 1500 101 4510001 437 2 MAMA State Conference 300 101 4510001 4373 Workshops Schools &Tuition 2,200 101 4510001 439 Other Miscellaneous Charges 37405 12,884 16413 0 0 Donation Account 101 4510001 580 Other Equipment Purchases 0 0 0 0 0 PAGE TOTALS $545017 $606,712 $658896 $771,300 V $843200 General Operating DEPARTMENT TOTALS $545017 $606712 $658896 $771300 $843,200 Page Two 2003 BUDGET WORKSHEETS PARKS 8 RECREATION July 10, 2002 2002 2003 Object 2003 1999 2000 2001 Adapted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments $92,000 101 4510071 Promise Program $0 $0 $0 $0 $2100 101 4510081 Softball $42,109 $36241 $40299 $37,500 $40000 101 4510082 Volleyball 5,327 4 566 2 393 9 400 2 500 1014510084 Tennis 930 834 758 1300 1,300 101 45100 85 Tiny Tots 16 559 21,021 20,255 16 600 19,000 101 4510086 Penn Paris 2044 1 604 2 597 2 500 3 000 101 4510087 Field Trips 3 131 2 327 2,042 2 800 2,800 101 4510088 Broomball 1 055 585 600 0 0 101 45100 89 Skating Lessons 169 356 91 800 800 101 45100 90 Fun Runs Walks 8 Bike Rides 1 794 1,717 2,965 1,000 1 800 101 45100 91 Summer Camps 0 0 3622 3,000 3000 101 45100 92 Adult Baske' ball 0 595 701 700 1,900 101 457 00 93 Other Programs 5 984 9 841 4 992 3,500 5 500 10' 45100 95 T -Ball 0 0 5,931 3200 3 500 101 45100 96 Teen Night 4,026 4,729 4,771 4 600 4,800 1014513098 Pistol Range 0 0 0 4,700 0 83128 84,416 92015 91,600 92000 101 4510071 103 Part -Time Salaries 0 0 0 0 2,100 101 4510081 103 Part -Time Salaries 21,190 20,422 21,562 24,300 24,300 101 4610081 219 Operating Supplies 13478 7294 8787 11000 11,000 101 4510081 311 Officiating Fees 3 842 5 615 6,622 0 0 101 4510081 319 Other Professional Services 3 600 2 909 3 328 2,200 4,700 101 4510082 103 Part -Time Salaries 429 948 609 1000 1000 101 45100 82 219 Operating Supplies 664 926 756 1,500 1500 101 45100 82 311 Officiating Fees 3 836 2 420 932 6,000 0 101 45100 82 319 Other Professional Services 399 273 96 900 0 101 4510084 103 Part -Time Salaries 755 789 720 1 150 1,150 101 45100 84 219 Operating Supplies 175 45 38 150 150 101 4510085 103 Part -Time Salaries 15 834 19,560 19 500 15 600 18 000 101 4510085 219 Operating Supplies 630 1 462 754 1 000 1,000 10 45100 86 103 Part -Time Salaries 1 408 1 189 1,427 2000 2,200 101 45100 e6 219 Operating Supplies 636 415 1,170 500 800 101 4510087 219 Operating Supplies 2 879 2,089 2,042 2 800 2,800 101 45100 88 219 Operating Supplies 132 0 0 0 0 101 45100 88 311 Officiating Fees 923 585 600 0 0 101 4510089 103 Part -Time Salaries 169 356 91 740 740 101 45100 89 219 Operating Supplies 0 0 0 60 60 10 45100 90 219 Operating Supplies 1 794 1 717 2,965 1 000 1,800 101 4510091 103 Pan -Time Salaries 0 0 1,646 1,000 1000 101 4510091 219 Operating Supplies 0 0 1 975 2,000 2000 101 45100 92 219 Operating Supplies 0 595 701 700 1,900 101 45100 93 103 Part -Time Salaries 1,023 1,661 0 0 2,000 101 45100 93 219 Operating Supplies 4961 8,180 4,992 3,500 3500 101 45100 95 103 Part -Time Salaries 0 0 4,161 2200 2 500 101 4510095 219 Operating Supplies 0 0 1,770 1,000 1,000 101 45100 96 219 Operating Supplies 4,026 4,729 4,771 4 600 4 800 101 4510098 103 Part-lime Salaries 0 0 0 2 700 0 101 4510098 219 Operating Supplies 0 0 0 2,000 0 SPECIAL PROGRAM TOTALS 82,781 84,178 92015 91,600 92,000 GRAND TOTAL PARK 8 REC $627,707 $690 890 $750910 $862900 $935,200 Total Levy Year 2003 1,548 100 (1) Other funding for Emergency Equipment for the Squad Cars is from the DUI Forfeiture Fund to help pay for the equipment for the squads (2) Other funding for Structural Overlays comes from SKB User i ees (3) Other funding for Water Tower #4 would come from a Water Revenue bond issue MSA Funds Buiklmg Street m E m nt Park imp From Water Sewer Storm Water Sewer Storm Total Vear Item De scnpbon _Department CIP Levy CIP Lev CIP Lev Assess Fund State Care Care Gwe Ubbt Ubh1v Ubbt Donations Iher Cost 2003 1995 Lease-Purchase 10 Years 1996 LeasePurchase (10- Years) 2001 Lease Purchase 1L a Years) PC Printer Replacements (From 199 PC File Server Replacemen (Both Fr om 1999) Council Council 50 600 50,800 64 900 115 106 2003 64,900 115,400 2003 2003 2003 Counnl Finance Finance 20,000 40 000 20 000 40 D00 2003 PG Wofk staUOn Upg rades From 1998 1999 Finance 50,000 50 000 2003 SC Urnt rle piacements 1991 U nits) Fire 85,000 85 000 2003 S un Sheller a C laret Park Park Roo Park Rec 150007 15,000 30 000 2003 Bis cayn e Park I mprovement s 300001 2003 Birch Park Trails Impr Park Rec 30000, 30 000 2003 Pave Rink at Central Park Park Rao 38,000 3a 000 2003 Emer( ency Egmpme lcf Squads in sta l lation Police 5 000 10 000 15 U0o 2003 2003 2003 Mobile R adios for 3 Squ ads Electfom Ticket Wn ter Software Polire Rec CAD Mobile SMJ Pymt 2 of 3 lice_ P olice Police 6,000 6 000 8,000 6000 _49000 49000 2003 3 S ads (Se Back 3 #99 9970 2 030) 2003 PW Bldq Add n LeaselPurc (Yr 5 of 20) 2003 Structural O verlays an Olde Streets 2003 Street Cun B P 3rd to Connemara) 2003 Connemara Tr ail- TH 3 t o Bis cayne Powle 4th 2003 Mo tor Puol V (Replac 305) 2003 Van (Re lace #3 Park Ro Pol Pub Works Pub Works 75 000 75 000 24 000 10 000 10,000 44 OUo 15000 145,000 160000 498000 Pu W orks Pub Works Pub Works' Pub Works 160 000 325,000 13,000 613 000 862,000 675 000 320,000 726 000 3,196 000 20,000 27,0001 20 000 270w 2003 Roller Relent( 13�_ i Pub Works 30000 90000 2003 Skidster Re i 0 ace men t (8420) Pickup Re lai e #341 Pub Works 30 000 15,000 30 000 3000 0 2003 Pub Works 15,000 2003 Pickup (Additional Unit #344) Pub Works 33,000 33000 2003 Pickup Re lace #33 Pub Works 42,000 42 000 2003 Fasement Sewer Cleaning Machine Pub Works 20 000 20 000 2003 Repa &Recen Chippendale Water Towe Pub Works 160000 780000 2003 Wate Tower #4 Pub WOrhs 1500000 1 500 000 Tota 24 773,000 7511001,202,000 173,000 675000 528000 35,000 726,000 10000 10000 1655 6502,100 Total Levy Year 2003 1,548 100 (1) Other funding for Emergency Equipment for the Squad Cars is from the DUI Forfeiture Fund to help pay for the equipment for the squads (2) Other funding for Structural Overlays comes from SKB User i ees (3) Other funding for Water Tower #4 would come from a Water Revenue bond issue Total Levy Year 2004 1,672 100 (1) Compressor funding comes from Arena Fund operations/reserves (2) Generator funding comes from Arena Fund operations /reserves and Equipment CIP levy (3) Other funding for Structural Overlays comes from SKB User Fees (4) Other funding for County Road 33 protect from County share of project and City of Apple Valley share of project (5) Other funding for Boulder Avenue extension will come from a Port Authority bond issue MSA Funds Bui p Street E ui mot Park Im Water Sewer Storm Water Sewer Storm Total Year Item Descn De artmem CIP Levy CIP Lev CIP Levy Assess Fund State Core Core Care Uhld llitldy_ Utibl _Donations iher Cost 2004 Gty Records Mana S oftware Egm Atlmm_ 25 g00 25 000 2004 Compr ArT, 10,000_ 10,000 2004 2004 '19951 2004 �12001 1995 Le Pu rchase (1rl Years) ease-Purc (i0- Years) Lease Purchase 10 Year Counul D esgnated S h eet R eserves Counc�I 50,eD0 50,800 649D0 115400 500000 Council Council) Council 64900 115,400 2004 500,000 2004 2004 New Techn U pdates 04 Crass Rig Ropl ('91 Vehicle) Fire Fre 15 000 15000 32 000 32000 2004 Replace CI(' (_Lchng Replace Camhcid Par Shelter RI esurface Claret and Ch arlie's Tennis Courts Erickson Park Upgrad (ADA Up grades)__ Par Rec 15 000 15 000 18 000 2004 2004 2004 Park Rec Park &_Rec 18 000 12,000 1¢000 Park Rec 25 000 25 000 2004 Shannon Park Buh Hockey Rm k w /Lights Park Rec 100 000 100 000 2004 2004 New P ark Built Mobile Radios fo 3 Sguads 8 Hand I leld R l adi os (Re aremnls e Emerg ncy E qm rrimm for S quads Installati Polic Records CA D Mo 3 bile S/W (P ymt 3 of 3 S uads (Sell Back 3 #9850, 2040 2080)__ PW Bldg Add n Lea selPurc h (Yr 6 of 20) _Pub !Structur d Ovrrla on O lder Streets Street Recon Chippendale 145th l0 149th Street Recon CR 3 CR 4210 145th Street Street coca Boul Avenue Exte nsion Sho Hoist (Re place #1) Rec 200 000 200 000 Pobce Police 6 000 6 000 8,000 200 4 200 4 200 204 04 20D4 2004 2004 2004 2004 2004 8 000 Police 15 000 25 000 49 000 75 000 Police 49 000 Pare Works Pub Works Pub Works 75,000 24 000 10,000 70 000 44 000 17,000 50,000 67,000 565 000 10,000 50,000 50 000 675,000 Pub Works Pub Works Pub Works 1,150,000 1 500,000 3 000 000 9000 9,000 k 3500 3,000 000 2004 Picku #342 Pub Works 33,000 33000 2004 Paver Repla #1 Pub Works 40,000 40000 2004 Paint Inside of C onnemara Water T Pub Works 20,000 20,000 Totals 57. 000 1,065 000 550,100 27 000 325 ODO 350 U00 20 000 60 000 10,000 50 000 4,220 000 6 734,1001 Total Levy Year 2004 1,672 100 (1) Compressor funding comes from Arena Fund operations/reserves (2) Generator funding comes from Arena Fund operations /reserves and Equipment CIP levy (3) Other funding for Structural Overlays comes from SKB User Fees (4) Other funding for County Road 33 protect from County share of project and City of Apple Valley share of project (5) Other funding for Boulder Avenue extension will come from a Port Authority bond issue Year r 1001995 200511 2005 Item Descnption De ap rtmen Council Bm1tlm CIP LevL Street CIP Levy E m mot CIP Levy Assess Park lm Fund_ MSA Funds From State Water Core Sewer Core Storm Core Water Ultld Sewer Ubd Storm UtiM Donations Other Total Cost 50 800 L ease Pu rchase i6- Years) Lease Purchase (10 Year s 2001 lease Purcha,,, 110 Ye ars) 50,800 Council 64,900 415,400 64 900 Comr.d 115,400 2005 2005 200v 2005 2005 ares (From 1999 2000)_ PC Pnnter Re[�imcnt Pl, File Se rver Repla cements troth- From 2003)_ PC Workstation Upgrades From 7001) New Fir Station AED Unit (Oefibu Finance Finance Finance Fire F1re 20 000 40 000 60000 20 000 40 000 600 00 1 000,000 1 000 000 5,00 5 000 2005 Refurbis Unit #159 15 Years Old) Fire_ 25 000 WWO 25 000 2005 Rec Truck Fire 145 000 145 000 2005 Tanker (Admtrt.. Fire 1 0 W 9O 190000 2005'New Neig hborhood Par Built Park Rec 200,000 2005 Video C ameras f or 3 Squads Police 15 000 15 000 2005 MCD Replacements (6 2 Squads Back 1 #2110 New Inveshgalor) Sell Police Police 48 000 48000 50 00 2005 50 000 2005 PW Bldg Add, LeaseM (Yr 7 o f 20 Structural Oveilays on Older Streets Street Recon Gamem Lane Pub V f.d s Pub Works Pub Works 24,00 17,000 10,WO W 000 44 0 09 67 0 00 110,000 2005 50 000 2005 44,000 66 000 2005 Street Recon f embnan Avenue Pub Works 52,000 98 000 150,000 2005 2005'Du St reet Recon CR 73 Akmn A VeFCR 4210 CR 31 Pub Works 400,000 225,000 500,000 1 875 000 3,000 000 120 000 (r�u.k jRep lace #4301 Pub Works 120 000 2005 Dump Truck Addlu Pub Works 120,000 120000 2005 Lo ader (Repla #4 19) Pub Works 1 200,000 200 000 2005 P aint Connem Tower& S Repai Pub Works 500,000 _500,000 2005 J olter Truck (R eplace #435 Pub Works 140,000 140,000 Totals 24000 4961001219,100 406000 200000 500,000 500,000 140,000 10,000 10,000 2,925000 6 480100' Total Levy Year 2005 1,789 100 (1) Funding for the New Fire Station #2 will come If a referendum is passed on the Issue and bonds are issued (2) Other funding for Structural Overlays comes from SKIT User Fees (3) Other funding for County Road 73 project from County share of project and City of Inver Grove Heights share of project Total Levy Year 2006 1,800,300 (1) Other funding for Structural Overlays comes from SKIS User Fees MSA Bmldin Street E m mnt CIP Lev Assess _Park lm Fund Funds From Stale Wat er Core Sewer Core Storm Water Se r St orm Total Year 2006 2006 2006 Item D escnplion 1996 Lease Purchase Years) 2001 1 case Purcha (10- Years) Coun Design Street Rese Refurbish SCBA Compressor Radio Replacements (Re place Obsolete) Re lace C/C Floor Sc rubber C/C Banquet Roo Floor Work NPw Neighborhood Park Built Budd Comn af Pla field Video Cam 3 er as for 3 Squad Space De artmenl Council Council Council Fire_ Fire Park Bee Park &Rec Park &Rec Park &Rec Police Police P olice Police CIP Lev CIP Levy Core Bell Utility Ulnit Donations Cher_ Cost 10 000 10,000 400,000 64,900 115,400 5 000 85,000 _T5 000 20,000 30,000 715000 200,000 600,000 400000 175,400 5 000 85 000 10 000 10 000 200 000 600 000 15 000 29000 30,000 2006 2006 2006 2006 2006 2006 2006 06 2006 2006 save Storage Shelves Pro perty Room ima a Software for P olice Mug Shots 4 S uads (Sell B ack 4 #9860 320 330 370) 2006 2006 PW Bldg Ad n Lease /PUrch (Yr B o 20) ;hucturat O verlays on Omer Streets (,R 42 US Hwy 52 1 of 4) SU _Recon -D Blvd lvd 1 192n to 120th 70KW Slam Generalur( #54)(Gly Hall) Pickup (Rep #306) Pickup (Rep #307) Pub Works Pub Works Pub Works lWork 24 00_0 _5_40000 30000 17 000 36 500 000 10 10,000 50 000 115,000 44 000 67 000 500 000 900 000 30 000 33 000 80000 80 000 110,000 2006 2006 2006 2006 2006 33,000 33 000 80,000 80,000 110,000 2006Mower(Repla 200Mower 2006 #13) AddRion Sweeper (Rep 1/443) Totals 44 000 940,000 816 300 800 000 500 000 10 000 10,000 50,000 3547 300 377,000 Total Levy Year 2006 1,800,300 (1) Other funding for Structural Overlays comes from SKIS User Fees Total Levy Year 2007 1,784,400 (1) Other funding for Structural Overlays comes from SKB User Fees un Funds Year Item Descnphon Depadment Building CIP Lev Sireel CIP Le E ul mnl CIP Lev Assess Pm ark i Fund From State Water Core Sewer Core Storm__ Core Water Unlit Sewer Mill Storm Ublll Donahons ther Total Cost 2007 2007 2001 Leas Pu rchas e (10 Y ears) Counc ee Desig nated Strt Reserves _Council PC Printer R e rcenients From 2003 Fie Server Re placements moth From 200_5) PC WOrk station Uprq_ades From 2003)_ 4x4 Grass Ri Replaceme (D) Vehicle) C ommand P ost Vehicle (JO Purchase) 3 Squads Sell Rar k 3 #9 440 460) PW Bldg Add n I r ars /Purch (Yr 9 of 20) Structu Ovedoys on Older Streets Street Rr can Chm chlIla Ave 127 Ct Street Rccon 13 t Danville Ct C Darnell Ct CR 42 US H 52 (Year 2 of 4) BrscayneW� ReconUructi Co uncil Finance Finance fmance Fire Police Police 500,000 216 000 224,0 20Q,000 115400 20 000 400001 60000 35,000 _250 00 _90 000 9,000 33000 33000 60 000 100,000 70,000 50,000 115 400 500 000 20,000 40,000 60000 35000 250001 90 0001 44 000 67 000 270 000 280 000 500 000 560000 9060 33 000 33000 60 000 100 000 2007 200TPC 2007 2007 2007 2007 2007 2 0071 2007 2007 2007 24000 17 000 54,000 56,000 90000 500 000 10,000 100,000 10,000 100000 Pub Works Pub o ks W Pub Works Pub Works Pub Works Pub Works Pub Works Pub Works Pub Works Pub Works Pub Works 2007 2007 Compa (Replace tt1 Pickup (Repla #336 Pickup 2007 2007 2007 Snowblower Snowbower For Loader (Replace #220) 2007 Dum Truck (Re place #427) Totals Z4 1 140 000 620,400 217 000 56 0 000 110,000 110 000 70,000 50 000 2,841,400 Total Levy Year 2007 1,784,400 (1) Other funding for Structural Overlays comes from SKB User Fees Total Levy Year 2008 1,785,400 (1) Compressor and Refrigerator Concession Equipment funding comes from Arena Fund operatbnsheserves (2) Other funding for Structural Overlays comes from SKB User Fees MSA Department Arena Arena Council Counal__ Fie file police Police Pub Works Pub Works Pub Works Pub Works Pub Works Pub Works Pub Works Works Pub Works pub Works Pub Works Funds g Item De npbon s c pressor rigerator 8 C oncesson Equipment Bwltlin CIP Lev Street DIP Lev 200 000 E mpmnt CIP Levy Assess Park lm Fund F rom State Water Core Sewer _Core Storm Core Water ULIRy Sewer Uti4 Storm U Donations 'ether 10 000 Total Cost 10 000 115,400 6,000 S50000 50,000 55 000 10 000 10 000 115 400 200 000 6 000 1 Lease- Purchase 10 Years) nal Designated Street 1 2eserves 2UU81MD1 2008 e Replacement per Upgra (Sofhvare) 2 Squads (Sell Back 2 #5110 620) PW Bldg Add n Lease /Purch Y 10 0f 20) 24,000 17,000 15 000 37500 67,500 92 500 10 000 10,000 50 000 350,000 50000 55 000 44,000 67,000 35 000 210000 240 000 2008 2008 �Struclural O verlays on Older Stre ets 20081Street Recon 155th Court 2008 Recon Claret A ve Co rnelll0155th 2008 r Str Recon 156th St Claret to Chippendale 2008 Street Recon Cornell Tr 156 W to 156th E 2008 �Stre R econ Coniel1 Tr S/P to 156th St W 2008 42 US H S 2 m ar 3 014_ _Pub 20081 Tratler Gla d514) 2008 Replace Fleet Vehicle 1938 W r Va in tlstanL_ _2008 Tra ctor (Replace #406) 2008 Mower (Repl3re d66 2008 Dump Truck (Replace #431 20,000 137 137,500 112 500 20 000 25 000 10,000 10 000 t0,000i 10,000 75000 15,000 15000 20 000 10000 10,000 10,000 240000 29 2,500 117500 10000 450 000 500 000 500 000 20 000 25 000 50 UVO 8U UU0 110000 50000 80000 10,000 UPbWoks Totals 61400 347,000 500000 50,000 75,000 40,000 70,000 2867,400 Total Levy Year 2008 1,785,400 (1) Compressor and Refrigerator Concession Equipment funding comes from Arena Fund operatbnsheserves (2) Other funding for Structural Overlays comes from SKB User Fees Total Levy Year 2009 1 790,400 (1) Other funding for Structural Overlays comes from SKB User Fees MSA Year Item D escnpbon Department Budding CIP Lev Street CIP Lev Park lm Fund From State Water Core Savvier Core Storm Care Water tllit Donahons Iher Total Cost 2009 20V11 2 009 2009 ea se PUrchasejl0- Year Council UCSigoated Street(dese PC Ponler Replace (From 2 005 Z F'C F de Server Replacements {BOIh -From 2007) PC W orkst t)porade (From 200 4x4 Gr ass Riq Repla cement 00 Veh�cie) Resurface Tennis Court poi cede Holdmy Celts 8 In Roo ms 2 Squads (Self B ack 2 #630 670) Bldg Ad nLea /Purch (Vr 1 of 20)_ Struriw at Overlays on Older Sbce CR 42 US Hwy 52 Year 4 o f 4) Slreet Re con Danhw (S outh of CR 38� Pickup (Replace Building Department's Dump T ruck (Replace #4 32) Council Councl Finance finance Finance Fee Park Rec Police Pokce V j Funds 115400 500000 500,000 20 000 50 000 70 000 30 000 000 70 U00 60 000 7009 20091 200 26 9 9'U 2009 2 0aJI p W 2009 2009 70,000 24 000 16,000 60,00_0 Pub Works Pub Works Pub Works Pub Works Pub Works Pub Works 10 000 1 0,000 U VO 17,000 500,000 50,000 fi1,000 2009 2009 700,000 25 000 110000 175,000 500 000 675 000 25 000 110000 2009 iE T otals 94,0001200000 496,400 192000 500,000 10,000 10,000 50,000 2,552400 Total Levy Year 2009 1 790,400 (1) Other funding for Structural Overlays comes from SKB User Fees Total Levy Year 2010 1904,900 (1) Other fuming for Structural Overlays comes from SKB User Fees (2) Street Recons From Above 150in Street West, Damask Avenue, Damask Cowl Dallara Avenue South of Dodd VISA Funds From I tem Desc lion Bulklln CIP Levy Street E ui mnt Park lm Water Sewer Stomt Water Sewer Storm Total Year De arim GIP Levy CIP Lev Assess Fund Stale Core Cora Core _Ubld Utz Utility Donations iher Cost 2010 2010 2001 Lease Purchase 10 Years Cnenal Designated -Street Reserves 3 Squads (Sell Bark 3 #190 740 790 Counul_ Counctl Police 115,400 115 400 20 0,0_00 200 U 00 1010 90,000 2010, 2 010 PW Bldg Add n I ease,PUreh (Yr 12 of 201 Structural Overlays on Old Streets Street Recons Soc Be Pub Works Pub Works Pub Works 24 00 0 17 000 10,000 10 000 50,00_0 _90,000 44,00 6] 000 2010 415,000 175,000 100,000 700000 10_0,000_ 990000 2010 Connemara P=nkway Over ash Pub Works 1,000 000 _100000 1 000,000 2010 Slreet Recon Brob 2nd 3rd Add itions Pub Wniks 577 1 267 130,000_ 108000 100,0 1 000 2010 _2010 leku Repla Pce #3131 Dum Truck (Re place #433) Pub Works 3300u 33,000 120000 Pub Works 120000 2010 2010 Dump Tmak (Rep #434) Loader Re lace 1 Pub Works 130 000 130 000 200,000 Pub Works 200000 E Totals _240001,192500 688400 459500 1,000,000 100000 240000 21#000 200000 50000 4,164400 Total Levy Year 2010 1904,900 (1) Other fuming for Structural Overlays comes from SKB User Fees (2) Street Recons From Above 150in Street West, Damask Avenue, Damask Cowl Dallara Avenue South of Dodd Total Levy Year 2011 1 901 900 (1) Other funding for Structural Overlays comes from SKB User Fees MSA t b uilding Funds Street Equi mnt Park lm From Water Sewer Storm Water Sewer Storm Total Year I tem Descnpllon Department OF Lev CIP Lev CIP Lev Assess Fund Slate Core Core Core Ubldy Utiht Utility Donations Sher Cosl 20112001 Lease- Purchase 10- Years) PC Prin Replacemen (From 2007) Is Server@e plaocment s (Both Fro 2009) PC Wo Upgrades ¢Fmm 2007) Recrding Eg wpment Replaoenie 3 Squads (Self Back 3 #450 020 01 10) I'W Bldg Add n Le aselPUrch (Yr 12 of 20 Cowicil Finance Finance Finance _115400 115400 2011 20 000 20 000 20111PC 2011 2017 201 50000 bgo00 70 000 10,000 70 000 10 000 90 000 44 000 Police Police Pub Works 90 000 2011 24,000 10,000 2011 Cdy Shop Adchta Pub Works 250000 _1 250000 2011 Structural Oveday� on Older Streets Pub Works 17000 1 50 000 67000 2011 S treet Recon Ra s 1st 2nd 5th Addan s Pub Works 495 000 155 000 100 000 100,000 000 950 000 2011 Street Recon R ahn s 0t h 7th 8 8th Atl dihons Pub Works 737 500 _217,500 100 000 100,000 _100 100 000 1 255000 2071 Du Truck ArlJibon) Pub Works 120,000 120,000 2011 Vac Truck Repla cement (1995 Vehicl Pub Works 300,000 300,000 Totals 274 000 1 232,500 475,400 389,500 300,000 210,000 210 000 200,000 50,000 3,347,400 Total Levy Year 2011 1 901 900 (1) Other funding for Structural Overlays comes from SKB User Fees 44 Streets Total Levy Year 2012 1,913 00 X11 Outer Wridm9 fa SirucW(aI Overlays W.. from sKa User Fees A� 1076 4W 5otafs W ath sireatscR 38, 132od CO"R and Boa q Year t iwo ort the to110 00 St V`' Total Levy' o Ave Be al Ave, 129th rated ynth t A w 128th er wl Iraude eA30 51 IN, tscaYe sarsta IMa Ave, (11 Futuna costs assoo larva 124th St, 1251h St B ['psis and fu0d'� are avadahle at this "me Page One INSURANCE EXPENDITURES 2003 BUDGET WORKSHEETS 2002 2003 Object 2003 INSURANCE REVENUES 1999 2000 2001 Adopted Detail Proposed July 10, 2002 Description Actual Actual Actual Budget Amount Budget Comments 206 49006 01 221 Equipment Parts $659 $866 $1,149 2002 2003 Object 2003 Liability Auto Deductible Pymts 206 49006 01 304 Legal Fees 1999 2000 2001 Adapted Detail Proposed Unreimbursable Legal Fees Account# Description Actual Actual Actual Budget Amount Budget Comments 206 31010 00 000 Current Ad Valorem Taxes $180000 $185,000 $190,000 $200000 $210,000 Yearly Fee Per Policy F -3 206 33100 00 000 Federal Grants Aids 0 32 487 0 0 0 7100 Rain Stones 206 36210 00 000 Interest Earnings- Investments 20 911 26 303 22 831 10,000 10 000 Annual Premium 206 36214 00 000 Net Change in FV- Investments (10,312) 7 156 0 0 0 Annual Market Value Changes 206 3621500 000 Interest Earnings 475 601 504 200 200 Liability Auto Deductible Pymts 206 36260 00 000 Other Revenue 36,200 31 111 23 392 20,800 20 800 Insurance Refunds /Dividends FUND TOTALS 227 274 282 658 236 727 231 000 241 000 INSURANCE EXPENDITURES 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 I 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 206 49006 01 221 Equipment Parts $659 $866 $1,149 $2,000 $2.000 Liability Auto Deductible Pymts 206 49006 01 304 Legal Fees 129 45,590 0 2 500 2,500 Unreimbursable Legal Fees 206 49006 01 305 Medical Dental Fees 6 135 11,075 10,478 15 000 15,000 Work Camp Deductible Pymts 206 49006 01 317 General Fund Administrative Fees 2 500 2 500 2 500 2 500 2,500 Yearly Fee Per Policy F -3 206 49006 01 319 Other Professional Services 9 667 17,450 15,900 20 000 20 000 Risk Management Consultant 206 49006 01 365 Worker's Compensation Insurance 28 784 28 585 37,339 50 000 55 000 Annual Premium 206 49006 01 369 Other Insurance 114 805 105 349 113,442 130,000 135,000 Annual Premium General Liability 206 49006 01 409 Other Contracted Repair Mamt 7,565 7,900 6,630 9 000 9,000 Liability Auto Deductible Pymts 206 49006 01 439 Other Miscellaneous Charges 1 084 9,377 0 0 0 FUND TOTALS 171 329 228,691 187,438 231 000 241,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 I Page One 2003 BUDGET WORKSHEETS ARENA REVENUES July 10 2002 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 $0 $0 650 3621000 000 Interest Earnings- Investments 0 0 1,898 200 200 650 3621500 000 Interest Earnings 109 121 311 200 200 650 36260 OD 000 Other Revenue 11 943 13,229 22,055 14 500 16,000 Learn to Skate Program (STS) 650 3626500 000 Use of Reserve Funds 0 0 0 28 400 35 800 650 38060 00 000 Prime 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 3806300 ODO Open Skating Ice Fees 4,834 5 395 6,145 6 300 6,300 650 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 ODO 14,000 650 3806700 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 3809500 000 Pro Shop Revenues 721 985 1,320 1,11)0 1 100 Tape Laces, Mouthguards etc 650 39103 00 000 Gain or Loss from FiA Disposal 0 0 9 699 0 0 Sale of Old Ice Resurfacer 650 39201 00 000 Transfer From General Fund 0 0 0 0 0 FUND TOTALS 388,082 400 832 303 486 314 500 324 600 Page One July 10 2002 2003 BUDGET WORKSHEETS ARENA EXPENDITURES Account# Description 650 45130 101 650 45130 77 101 650 45130 78 101 650 45130 79 101 650 45130 79 102 650 45130 103 65045 59 103 1 650 45130 99 103 2 650 4513001 207 650 45130 01 208 650 45130 01 2081 650 45130 01 2082 650 45130 01 209 650 45130 01 211 650 45130 01 212 650 45130 01 216 660 45130 01 219 650 45130 01 221 650 45130 01 223 650 45130 01 241 650 45130 01 242 650 45 .30 01 265 Salaries Benefits Administrative Technical /Clerical Maintenance Full -Time Overtime Part-Time Salaries Benefits Learn -To -Skate Program Building Skate Guard Attendants Training Instructional Supplies Miscellaneous Supplies Skate Magnets Other Supplies Other Office Supplies Cleaning Supplies Motor Fuels Chemicals Chemical Products Other Operating Supplies Equipment Parts Building Repair Supplies Small Tools Minor Equipment Other Items for Resale 650 45130 01 305 650 45130 01 317 650 4513001 321 650 45130 01 331 650 45130 01 341 650 45130 01 349 650 45130 01 365 650 45130 01 369 650 45130 01 381 650 45130 01 383 650 45130 01 384 650 45130 01 401 850 45130 01 404 650 4513001 415 650 4513001 433 650 45130 01 437 650 45130 01 439 650 45130 01 521 650 45130 01 601 650 45130 01 611 650 45130 01 621 650 4513001 710 650 45130 01 7101 650 4513001 7102 650 45130 01 7103 Medical Dental Fees General Fund Admm Fees Telephone Costs Travel Expense Employment Advertising Other Advertising Workers Comp Insurance Otherinsurance Electric Utilities Gas Utilities Refuse Disposal Contracted Building Repairs Contracted Mach Equip Repairs Other Equipment Rental Dues Subscriptions Conferences Seminars Other Miscellaneous Charges Building Structure Purchases Bond Principal Bond Interest Bond Paying Agent Fees Transfers Yearly Maintenance Bond Principal (1992E Issue) Bond Interest (1992E Issue) FUND TOTALS 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $54,545 $68,768 $76,914 $104300 $134,700 Salary Taxes PERA Benefits 9,300 38,400 87 000 Add 1/2 Bldg Maint Worker 1,786 380 2,164 2000 2,000 38,828 39,265 33,073 49,600 27,500 12,500 15,000 0 0 0 200 200 855 33 0 1,000 1000 200 Bo0 0 0 0 500 500 Learn to Skate Program Supplies 2 562 2,870 3 086 3 000 3 000 1,941 2,659 1,127 2400 2,400 Batteries for Resurfacer 642 222 1,251 800 2000 Assorted Floor Products 484 601 319 1 000 1,000 Events Supplies 0 1548 1195 3,400 4000 3,294 1 561 2,514 4,000 4,000 43 98 0 0 0 0 79 0 0 0 723 411 566 800 800 Pro Shop Supplies 0 0 0 500 500 6,000 6 000 6,000 6 000 6,000 Yearly Fee Per Admin Fee Policy 1 000 1,000 1,000 1,000 1 000 100 0 0 100 100 0 0 0 500 500 61 0 0 800 800 1 136 1 084 1,352 2000 2,000 5,729 4,873 5,771 13 000 13,000 34465 59,415 96,915 64500 64,500 12 883 24,326 26 744 33,000 33 000 3 424 3,409 3 729 3 500 3,500 2 116 5,305 5,045 5,000 5,000 5,581 6 316 10,630 6 000 6,000 165 0 0 300 300 734 695 444 900 900 MIAMA Dues 400 100 90 400 400 MIAMA Seminars 0 0 0 500 500 Contingencies 0 0 31,322 0 0 0 0 0 0 0 1999 Moved to Transfers 0 0 0 0 0 1999 Moved to Transfers 0 0 0 0 0 1999 Moved to Transfers 183 428 191,500 3,500 3,500 3,500 3,500 0 2001 -Moved to D/S for Arena 0 2001 Moved to D/S for Arena 362 923 422,521 314,754 314 500 324 600 Page One July 2, 2002 2003 BUDGET WORKSHEETS PORT AUTHORITY REVENUES Account Description 201 31050 00 000 201 33130 00 000 201 36105 00 000 201 36105 00 000 1 201 3610500 0002 201 3621000 000 201 36211 00 000 201 36212 OC 000 201 36215 00 000 201 3623000 000 201 36260 00 000 201 36265 00 000 201 39101 00 000 Tax Increments Federal Grants -CDBG Principal on Notes Blake LT Note Loch LT Note Interest Earnings Investments Interest Earnings Loch Interest Earnings Blake Interest Earnings ContnbuGOns7Donations Other Revenue Use of Reserve Funds Sales of General Fixed Assets FUND TOTALS EXPENDITURES Account# Description 201 46300 101 201 46300 102 201 4630099 103 201 46300 01 303 201 4630001 304 201 4630001 317 201 4630001 319 201 4630001 319 1 201 4630001 3192 201 4630001 319 3 201 46300 01 349 201 4630001 351 201 4630001 365 201 46300 01 369 201 4630001 381 201 4630001 383 201 4630001 389 201 4630001 433 201 4630001 437 201 46300 01 439 201 4630001 521 201 4630001 530 Salaries Benefits Full -Time Overtime Part-Time Salaries Benefits Engineering Fees Legal Fees General Fund Administrative Fees Othe• 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 Subscriptions Conferences Seminars Other Miscellaneous Charges Building Structure Purchases Improvements Other Than Bldgs 201 46300 01 710 Transfers FUND TOTALS 2002 2003 Object 2003 1999 2000 2001 Adapted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $0 $0 SD $0 $0 Admin Fees Portion Only 0 127,684 0 0 0 77,241 86,291 73,834 100,600 102,000 34,400 67,600 7 103 11 058 8 451 5 300 5 300 Interest Earned on CD's 7 454 6 815 6,124 5 300 4 500 Loch LFF Lease Interest 9,742 9,331 29479 8500 8,100 Blake 17 Lease Interest 404 365 278 300 300 Checking Interest Misc 0 0 0 0 0 2,811 0 235 0 0 0 0 0 0 0 0 0 0 0 0 $104755 $241,545 $118,401 $120,000 $120200 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $0 $0 $0 $0 0 0 0 0 2,990 4,358 3 884 4,500 22,659 4,669 700 5,000 11 822 29 087 23 035 10 000 6 000 6 365 6,000 6 000 13 466 29 946 46,273 33 500 14,000 5,500 4,000 1,005 All Salary Costs Inclusive of $0 Salary Taxes, PERA Benefits 0 General City Promotions 4,500 Port Authority Members 5,000 Business Park 20,000 6 000 Yearly Fee Per Policy F -3 23,500 500 1,005 0 680 5000 1,000 General City Promotions 25 1,364 0 500 200 292 266 313 500 500 Commissioners 4,670 4,581 3,332 7,500 4 000 Property Insurance 226 178 85 500 500 B,rsness Park Sign 0 0 0 500 0 227 201 290 1 000 1,000 Stormwater Fees 1,000 1,175 1,000 2,000 1,500 Prof Organizations /Journals 529 20 139 1,000 1,000 Chamber of Commerce Misc 6 95 414 500 500 Contingencies 0 121,281 33915 D 0 2,162 0 30,551 42,000 51,000 Business Park etc 0 0 0 0 0 $67080 $203,586 $150,612 $120,000 $120200 r Page One 2003 BUDGET WORKSHEETS $134,380 $142,978 $150000 BUSINESS PARK DISTRICT(0080) REVENUES Business Park District Only $130419 $134,380 July 2, 2DO2 $150,000 $125,000 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 FUND TOTALS EXPENDITURES Account Description $130419 $134,380 $142,978 $150000 $125000 Business Park District Only $130419 $134,380 $142,978 $150,000 $125,000 2002 2003 Object 2003 1999 2000 2001 Adapted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 243 49043 01 510 Land Purchases $0 $23760 $0 $0 $0 243 49043 01 710 Transfers 130 419 110 620 142,978 150 000 125,000 243 49043 01 710 1 8/1/03 2/1104 P/A Bond Pymts 125,000 FUND TOTALS y $130419 $134,380 $142978 $150,000 $125000 Note All TIF proceeds going towards payment on the 1993E, 1994A and 29008 bond issues Balance of bond payments coming from Port Authority tax levies r Page One 2003 BUDGET WORKSHEETS ENDRES PROCESSING DISTRICT)0089) REVENUES July 2, 2002 Account# Description 244 31050 00 000 Tax Increments 244 36215 00 OW Interest Earnings 244 36260 00 000 Other Revenue FUND TOTALS EXPENDITURES 1999 2000 2001 Actual Actual Actual $15,328 $53,546 $53,042 0 149 595 0 5355 5317 $15,328 $59051 $58,953 2002 2003 Object 2003 Adopted Detail Proposed Budget Amount Budget Comments $60,000 $32,000 Endres Processing District Only $60000 V $32000 Comments r t 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 Slogs $15 328 $11 $0 $60000 $32,000 244 49044 01 530 1 Endres Processing -Pay as You Go 32,000 FUND TOTALS $15,328 $11 $0 $60000 $32,000 Comments r t Page One 2003 BUDGET WORKSHEETS WATER UTILITY -REVENUES July 8, 2002 2002 2003 Object 2003 1999 2000 2001 Adopted Dated Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 34108 00 000 Administrative Fees -Other Funds $57544 $85,327 $35,835 $40000 $40,000 20% Of 5% Fees -COnst Projects 601 34109 00 000 Other Gen'] Govt 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 Iniere5 SIA 216 77 416 0 0 601 3621000 000 Interest Earnings Investments 55 810 85 198 92,136 60 500 60 500 601 36214 00 000 Net Change in GV- Investments (38,246) 15,195 (1 760) 0 0 Annual Market Value Changes 601 3621500 000 Interest Earnings 460 268 630 500 500 601 36220 00 000 Rents Royalties 51 283 48,022 27,455 50 000 50,000 Antenna Leases 601 36260 00 000 Other Revenues 559 2 708 0 0 0 601 37110 00 000 Residential Water Revenues 377 532 477 353 533,176 460 000 510 000 601 37120 00 000 Apartment Water Revenues 43,916 51 393 37 418 50 000 40 000 601 3712500 000 Institutional Water Revenues 24 213 27 486 32 550 25 000 25 000 601 37130 00 000 Commercial Water Revenues 36,515 51,598 75,797 40000 70 000 601 37140 00 000 industrial Water Revenues 5 962 10,422 9 705 6,000 8 000 601 37160 00 000 Penalties Water Revenues 4 070 5,011 5,276 4 000 5,000 601 37165 00 000 Meter Mamt'Water Revenues 18,300 17,175 5 709 3 000 3 000 601 37170 00 000 Other Water Revenues 0 0 0 0 0 60'3718000000 Water Meter Sales Revenue 85,984 87,038 126,559 100000 125000 601 39103 00 000 Gain or Loss from FIA Disposal 0 0 (1 623) 0 0 601 3920300 000 Transfer From 6,598 124,723 24 598 0 0 FUND TOTALS 741 470 1 101,031 1 017,431 849 000 947,000 Page One 2003 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES July 8, 2002 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 601 49400 101 Salaries Benefits $169725 $157,516 $162,802 $194,500 $228,000 Salary Taxes PERA Benefits 601 4940077 101 Administrative 32,200 601 49400 78 101 Technical /Clencal 92,900 601 4940079 101 Maintenance 102900 601 49400 102 Full -Time Overtime 4 141 10,323 11,058 10,000 10 000 601 49400 103 Part-Time Salaries Benefits 14,956 8474 6,234 16 000 16,000 601 49400 99 103 1 Utility Commission Wages (50 1,000 50 601 50% 602 601 4940099 1032 Maintenance Labor 15,000 100% -601 601 4940001 203 Printed Forms Paper 2,281 3,338 1,557 5,500 5,500 Inserts Water Bill Statements 601 49400 01 209 Other Office Supplies 20 31 0 500 500 Disks Ribbons etc 601 49400 01 216 Chemicals Chemical Products 20 910 30 501 38,482 33 000 40,000 Chlorine Flounde Polyphas 601 4940001 219 Other Operating Supplies 53 1,141 47 700 700 Maintenance Supplies 501 4940001 220 Water Meter Purchases 113,697 102670 121,027 100,000 125,000 Meters MIU's CU Horns 601 4940001 220 1 For Replacements 5,000 601 4940001 2202 For New Homes 120,000 601 4940001 221 Equipment Parts 1.911 283 436 0 0 601 49400 01 224 Street Maintenance Materials 0 0 2558 2000 2,000 Patching for Breaks 601 4940001 225 Landscaping Materials 627 60 120 600 600 Topsoil Seed Sod 601 4940001 227 Utility System Maintenance Supplies 466 0 2063 2,500 2 500 Raise 6 Hydrants Per Year 601 4940001 228 Meter Repair Materials 40 0 0 300 300 Miscellaneous Meter Parts 601 49400 01 229 Other Maintenance Supplies 4,791 4 109 5,655 7,500 7 500 601 49400 01 229 1 Supplies for Hydrants 4,000 601 4940001 229 2 Valve &Curb Boxes 1,300 GV Extensions 601 4940001 2293 Valve Replacements (2) 2,200 Sufficient for 2 Replacements 601 4940001 241 Small Tools 303 250 260 500 500 Wrenches Shovels, etc 601 4940001 242 Minor Equipment 2 157 1,734 1,800 3,000 3 000 601 4940001 2421 Locator, GV Wrench 1 500 601 49400 01 2422 GV Extension Wrench 1,500 601 4940001 303 Engineering Fees 9,721 19,391 28 707 12,000 12,000 601 4940001 303 1 WTP SR Site Evaluations 5,000 601 4940001 3032 GIS Update of Asbuills 51000 601 49400 01 303 3 Miscellaneous Fees 2,000 601 4940001 304 Legal Fees 0 0 0 1,000 11000 601 4940001 310 Testing Services 19,258 21,926 22,920 25,000 25,000 601 4940001 310 1 Bacteria Water Quality 2,000 Radon Tn -Chl 601 4940001 310 2 V CC Pesticides etc 11000 601 4940001 310 3 CU -PB Testing 22 000 $5 21 /Connection per Qtr (M) 601 4940001 312 Contract Inspection Fees 0 0 1,777 2000 2,000 Gopher State One -Call (M) 601 49400 01 318 Contract Engineer 0 0 0 20 000 20 000 Contracted Engineer for City 601 4940001 319 Other Professional Services 3,992 3,131 8,096 9,600 9 600 601 4940001 319 1 Thaw Pipes, Check Leaks, etc 1,500 601 4940001 319 2 Supervisory Controls 3 000 601 4940001 3193 Hazardous Chemical Permits Soo MN Department of Public Safety 601 4S40001 3194 Meter Reading Charges 4,000 RMR Services 601 49400 01 319 5 Hazardous Chemical Inventory 600 601 4940001 321 Telephone Costs 810 753 465 1,300 1,300 Lines for Telemetry 601 4940001 322 Postage Costs 1 939 3,735 3 725 4,000 4 000 Billings with Inserts 601 4940001 323 Radio Units 031 232 462 2,000 2,000 Replace /Repair Radios Phones 601 4940001 331 Travel Expense 16 0 0 1,000 1 000 AWWA National Seminar 601 4940001 333 Freight Express Expenses 0 16 0 100 100 Mail-in Repairs 601 4940001 341 Employment Advertising 0 0 0 700 700 P/T'ers Personnel Changes 601 4940001 349 Other Advertising 0 0 0 500 500 601 4940001 352 General Notices Public Into 0 0 0 500 500 Newsletters 601 4940001 365 Workers Comp Insurance 1,956 1,789 2,215 3000 3000 Water's Share of Premiums 601 4940001 369 Other Insurance 12,453 9,997 11 172 14 000 14 000 Water's Share of Premiums 601 49400 01 391 P C Maintenance 0 253 250 300 300 Auto Read Software Support 601 4940001 392 P C Accessories Supplies 0 0 0 200 200 601 4940001 393 P C Hardware Purchases 3 810 539 0 1 000 1,000 601 4940001 394 P C Software Purchases 0 11,990 534 0 0 601 4940001 395 PC Repairs 0 0 0 500 500 PAGE TOTALS 390,866 394,183 434,427 475,300 540 800 Page Two July 8, 2002 2003 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES Account Description 601 4940001 403 601 4940001 415 601 4940001 416 601 4940001 433 601 49400 01 435 601 49400 01 437 601 49400 01 437 1 601 49400 01 437 2 601 4940001 439 601 4940001 521 601 4940001 530 601 4940001 530 1 601 4940001 530 2 601 4940001 5303 601 4940001 560 601 4940001 570 601 4940001 586 601 4940001 611 601 4940001 710 601 4940301 221 601 4940301 223 601 4940301 319 601 4940301 321 601 4940301 381 601 4940301 383 601 4940301 409 601 4940301 439 601 4940701 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 53C 601 4940801 221 601 4940801 223 601 4940801 319 601 4940801 321 601 4940801 381 601 4940801 383 601 4940901 221 601 4940901 223 601 4940901 319 601 4940901 321 601 49409 01 381 601 4940901 363 601 4940901 439 Contracted R M Other lmpr Other Equipment Rental Machinery Rental Dues Subscriptions Books Pamphlets Conferences Seminars MN Health Department School AW W A Conrerence Other Miscellaneous Charges Building Structure Purchases Improvements Other Than Bldgs Annual Inspection of Wells South Rose Park Area Impr MXU Radio Meter Replacements Furniture Fixture Purchases Office Equipment Purchases Computer Equipment Purchases Interest on Lease Payments Transfers 601-49400 -01 TOTALS 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 Telephone Costs Electric Utilities Gas Utilities Other Contracted Repairs Maint Other Miscellaneous Charges Improvements Other Than Bldgs TOTAL WELL #7 Equipment Parts Budding Repair Supplies Other Professional Services Telephone Casts Elecinc Utilities Gas Utilities TOTAL WELL #8 Equipment Parts Budding Repair Supplies Other Professional Services Telephone Costs Electric Utilities Gas Ubhhes Other Miscellaneous Charges TOTAL W ELL #g 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 4,982 0 0 3,500 3 500 408 0 0 0 0 Moved to (416) 0 2,512 0 4,000 4,000 633 363 523 600 600 AWWA for 2 Members 411 477 362 300 300 Reference Materials 408 2,245 948 1,500 1500 1,000 (M) 500 2,023 2,414 2,885 4,000 4 000 DNR Annual Water Use (M) 0 0 0 10,000 10 000 Pymt on P W Building (4 of 20) 8,403 0 0 220 000 220 000 30 000 Each Well Done Every 7 Years 30,000 160,000 114 Total Estimated Cost 0 0 0 1,000 1 000 0 0 0 1 000 1 000 Chair, Table 0 0 0 0 0 6,231 6,043 5,845 0 0 P W Building Expansion(See 521) 559 109,322 333,023 0 0 Transfers for Other Improvements 414,923 517,560 778 013 721 200 786,700 830 265 1,179 1,000 1,000 1182 1,620 0 500 500 0 0 0 1,000 1,000 Independent Inspections 211 211 211 0 0 2,875 4,606 7,043 7,500 7 500 Pumping Lighting 490 2,089 761 2000 2,000 Heat Engine Backup 292 0 1 356 25 000 25,000 Increase Pumping Capacity 0 0 0 100 100 Contingencies 5,879 8,791 10,550 37100 37,100 4,542 2,198 150 500 500 0 1,752 0 300 300 0 0 0 500 500 Independent Inspections 211 211 211 300 300 10,758 11,093 13,253 14 000 14 000 Pumping Lighting 0 0 0 0 0 682 0 0 600 600 RTU's Pump Motor etc 0 0 0 100 100 Contingencies 0 0 0 600 600 16,193 15,254 13 614 16 900 16 900 3,009 623 2,645 1,000 1,000 0 0 28B 100 100 0 0 0 0 0 211 211 211 300 300 12,899 12 863 13 464 15,000 15,000 Pumping Lighting 326 440 590 800 800 Heat Only 16 445 14 136 17,200 17,200 17,200 239 474 310 500 500 27 0 0 100 100 0 0 0 0 0 211 211 211 300 300 16 411 22,269 22,547 30 000 30,000 Pumping Lighting 452 694 860 800 800 Heat Only 0 0 0 100 100 Contingencies 17,340 23,647 23,928 31,800 31,800 r c Page Three 2003 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES July 8, 2002 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 4941001 219 Other Operating Supplies 0 34 0 1,000 1,000 601 4941001 221 Equipment Parts 28 0 17,587 0 0 601 4941001 223 Building Repair Supplies 45 0 0 100 100 601 4941001 321 Telephone Casts 1,063 972 976 1 000 1,000 601 49410 01 381 Electric Utilities 6,023 5,368 6,379 7,000 7,000 Pumping Lighting 601 49410 01 409 Other Contracted Repairs Maint 0 0 531 5 000 5 000 TOTAL WELL #10 7,159 6,394 25,473 14,100 14 100 601 49411 01 221 Equipment Parts 0 0 0 1000 1,000 601 49411 01 381 Electric Utilities 0 0 0 1,000 1,000 TOTAL WELL #11 0 0 0 2,000 2,000 601 4941201 221 Equipment Parts 0 0 0 0 500 601 4941201 223 Building Repair Supplies 0 0 D 0 100 601 4941201 319 Other Professional Services 0 0 0 0 0 601 4941201 321 Telephone Costs 0 0 D 0 300 601 4941201 381 Electric Joities 0 0 0 0 30,000 Pumping Lighting 601 4941201 383 Gas Utilities 0 0 0 0 800 Heat Only 601 4941201 439 Other Miscellaneous Charges 0 0 0 0 100 Contingencies TOTAL. WELL #12 0 0 0 0 31,800 601 4941501 221 Equipment Pans D 0 0 500 500 Touch -up Paint 601 4941501 319 Other Professional Services 0 0 3,455 500 500 Tower Inspection 601 4941501 381 Electric Utilities 0 0 0 0 0 601 4941501 409 Other Contracted Repairs Maint 0 0 0 500 500 601 4941501 439 Other Miscellaneous Charges 0 0 0 200 200 Contingencies TOTAL WATER TOWER #1 0 0 3,455 1700 1,700 601 49416 01 221 Equipment Parts 0 0 0 500 500 Touch -up Paint 601 4941601 319 Other Professional Services 0 0 3,482 500 500 Tower Inspection 601 4941601 321 Telephone Costs 211 211 211 300 300 601 4941601 381 Electric Utitibes 810 1,265 1,129 1,000 1,000 601 4941601 409 Other Contracted Repairs Maint 0 D 0 500 500 601 49416 01 439 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 001 4941601 530 Improvements Other Than Bldgs 0 0 0 500 500 TOTAL WATER TOWER #2 1021 1,476 4,822 3,500 3,500 601 4941701 221 Equipment Parts 0 0 0 0 0 601 4941701 321 Telephone Costs 0 0 0 0 0 601 4941701 381 Electric Utilities 0 0 0 0 0 601 4941701 439 Other Miscellaneous Charges 0 0 0 0 0 Contingencies TOTAL WATER TOWER #4 0 0 0 0 0 601 4941801 221 Equipment Parts 0 0 0 500 500 601 4941801 319 Other Professional Services 0 0 0 500 500 Tower Inspection 601 4941801 321 Telephone Costs 0 0 536 300 300 601 4941801 381 Electric Utilities 0 D 317 1,000 1 000 601 4941801 409 Other Contracted Repairs Merit 0 0 0 500 500 601 4941801 439 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 601 49418 01 530 Improvements Other Than Bldgs 0 0 0 500 50C TOTAL -WATER TOWER #3 V 0 0 853 3,500 3,500 (East Side Water Tower) GRAND TOTAL ALL DEPTS 478,960 587,258 877,908 849 000 946,300 Page One 2003 BUDGET WORKSHEETS SEWER UTILITY REVENUES- July 8, 2002 Account Description 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Actual Actual Actual Budget Amoum Budget Comments 602 34108 00 000 Administrative Fees -Other Funds 57,544 85 327 35 835 40,000 602 36101 00 000 Principal Special Assessments 17 691 18 790 21 475 15 000 602 3610200 000 Penalties Interest SiA 360 127 667 0 602 36210 00 000 Interest Earnings Investments 44 305 69 422 83,823 55,000 602 36214 00 000 Ne' Change in `V- Imeslments (17,374) 9 611 1,309 0 602 36215 00 000 Interest Earnings 756 653 761 900 602 36260 00 000 Other Revenues 12 583 87 0 0 602 37210 00 000 Residential Sewer Revenues 633 326 756186 824,112 762000 602 37227 00 000 Apartment Sewer Revenues 61 354 69,747 54 307 70 000 602 37225 00 000 Institutional Sewer Revenues 30 190 31,478 30 923 30 000 602 37230 00 000 Comrrercial Sewer Revenues 36 091 34 416 47 988 35 000 602 37240 00 000 Industna; Sewer Revenues 7 620 11,340 12 144 8 000 602 37260 00 000 Penalties Sewer Revenues 6 704 7,370 7,894 7,000 602 39103 00 000 Gain or Loss from `IA Disposal 0 0 (1,228) 0 602 39203-00 000 Transfer From 4,284 (87) 14 900 0 FUND TOTALS 895,633 1,094465 1134,912 1,022,900 40000 20% of 5 %Fees -Const Projects 15 000 0 55,000 0 Annual Market Value Changes 1,000 0 800,000 60 000 30 000 40 000 8 000 7,000 0 0 1 056,000 Page One 2003 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES July 8 2002 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account Descnption Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 602 49450 101 Salaries Benefits $169,731 $157,516 $162,871 $194,500 $228,000 Salary, Taxes, PERA Benefits 602 49450 77 101 Administrative 32 200 602 49450 78 101 Technical /Clerical 92,900 602 49450 79 101 Maintenance 102 900 502 49450 102 Full -Time Overime 4 148 10,326 11 058 10,000 10 000 602 49450 103 Part -Time Salaries Benefits 2 264 4,714 8,115 15,000 15,000 602 49450 99 103 1 Utility Commission Wages (50%) 1,000 50% -602 50% 601 602 49450 99 103 2 Maintenance Labor 14000 100 -602 602 49450 01 203 Printed Forms Paper 1,726 2,762 1,442 5,500 5,500 Inserts Water Bill Statements 602 49450 01 209 Other Office Supplies 20 0 0 200 200 Disks Ribbons etc 602 49450 01 216 Chemicals Chemical Products 1,440 0 492 500 500 Root Killer Degreaser 602 49450 01 219 Other Operating Supplies 430 10 0 500 500 602 49450 01 221 Equipment Parts 197 0 0 0 0 602 49450 01 224 Street Maintenance Materials 0 0 0 2500 2,500 Patching 602 49450 01 225 Landscaping Materials 1,113 80 0 400 400 Topsail Seed Sad 602 49450 01 227 Utility System Maintenance Supplies 31 0 359 1 000 1,000 Manhole Castings 602 49450 01 241 Small Tools 0 154 67 500 500 Wrenches Shovels, etc 602 49450 01 242 Minor Equipment 260 4,832 953 3,000 3,000 602 49450 01 303 Engineering Fees 4,911 7,020 16,244 5,000 5 000 GIS Update of Asbudts 602 49450 01 304 Legal Fees 0 0 0 500 500 602 4945001 312 Contract Inspection Fees 0 0 1,777 2,000 2,000 Gopher Slate One -Call (M) 602 4945001 318 Contract Engineer 0 0 0 20,000 20,000 Contracted Engineer for City 602 49450 01 319 Other Professional Services 3,143 3,520 4,834 12,000 12,000 602 49450 01 319 1 Televising 3,000 602 4945001 319 2 Root Control 2,000 602 49450 01 3193 Supervisory Controls(Mamt Cont) 3 000 SCADA System 602 49450 01 3194 Meter Reading Charges 4,000 RMR Services 602 49450 01 321 Telephone Costs B10 753 465 600 600 Lines for Telemetry 602 49450 01 322 Postage Costs 1 940 2,067 2,338 3 000 3 000 Billings with Inserts 602 49450 01 323 Radio Units 0 136 602 1 000 1 000 Replace /Repair Radios Phones 602 49450 01 331 Travel Expense 0 0 0 1,000 1,000 National Conference 602 49450 01 333 Freight Express Expenses 0 0 0 100 100 Mad -ir Repairs 602 49450 01 341 Emplovment Advertising 0 0 0 300 300 P/T'ers Personnel Changes 602 49450 01 349 Other Advertising 0 0 0 500 500 602 49450 01 365 Workers Comp Insurance 1,944 1,778 2,203 3,000 3,000 Sewer's Share of Premiums 602 49450 01 369 Other Insurance 9,374 7,370 8,680 12,000 12,000 Sewer's Share of Premiums 602 49450 01 391 P C Maintenance 0 253 250 300 300 Auto Read Sofware Support 602 49450 01 392 P C Accessories Supplies 0 0 0 200 200 602 49450 01 393 P C Hardware Purchases 3651 539 0 1,000 1 000 602 49450 01 394 P C Software Purchases 0 10,496 534 0 0 602 49450 01 395 P C Repairs 0 0 0 500 500 602 49450 01 403 Contracted R M Other Impr 518 1 480 0 2,000 2,000 602 49450 01 415 Other Equipment Rental 0 0 0 200 200 602 49450 01 416 Machinery Rental 567 1,415 0 2000 2,000 602 49450 01 433 Dues Subscriptions 69 23 69 500 500 602 49450 01 435 Books Pamphlets 0 0 5 300 300 Reference Materials 602 49450 01 437 Conferences Sommers 1,392 2050 1,930 2,000 2000 MPCA School Miscellaneous 602 49450 01 439 Other Miscellaneous Charges 0 0 91 100 100 Contingencies 602 49450 01 521 Building Structure Purchases 0 0 0 10 000 10 000 Pymt on P W Building (3 of 20) 602 49450 01 530 Improvements Other Than Bidgs 4,000 0 83 212 000 200 000 602 49450 01 530 1 South Rose Park Area Impr 20,000 602 49450 01 530 2 Misc Improvements /Repairs 20000 602 4945001 530 3 MXU Radio Meter Replacements 160 000 1/4 Total Estimated Cost 602 49450 01 560 Furniture Fixture Purchases 0 0 0 500 500 602 49450 01 570 Office Equipment Purchases 0 0 0 500 500 602 49450 01 602 Sewer Service Charges 398 144 410,160 427,042 480 000 480,000 M W CC Charges 602 49450 01 611 Interest on Lease Payments 6 231 6,043 5 845 0 0 P W Building Expansion(See 521) 602 49450 01 710 Transfers 3,514 14 900 250 000 0 0 Transfers for Other Improvements It 60249450 -01 TOTALS 621,569 650 396 908,349 1 006,700 1,028 200 Page Two r 2003 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES July 8 2002 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 49451 01 219 Other Operating Supplies 0 0 0 100 100 602 49451 01 221 Equipment Parts 0 179 0 500 500 602 49451 01 229 Other Maintenance Supplies 0 0 0 200 200 602 49451 01 321 Telephone Costs 211 211 211 0 0 602 49451 01 381 Electric Utilities 564 489 573 800 800 602 49451 01 403 Contracted R M Other Impr 189 0 0 200 200 602 49451 01 439 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL LIFT STATION #1 963 879 784 1,900 1,900 602 49452 01 219 Other Operating Supplies 0 0 0 100 100 602 49452 01 221 Equipment Parts 3,111 290 1049 500 500 602 49452 01 229 Other Maintenance Supplies 0 0 0 200 200 602 49452 01 321 Telephone Costs 211 211 211 300 300 602 49452 01 381 Electric Uhhhes 916 938 927 1,400 1,400 602 49452 01 403 Contracted R M Other Impr 102 0 0 200 200 602 49452 01 439 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL LIFT STATION #2 4 340 1 439 2,188 2 800 2,800 602 49453 01 219 Other Operating Supplies 0 0 0 100 100 602 49453 01 221 Equipment Parts 3,458 45 3,493 500 500 602 49453 01 229 Other Maintenance Supplies 0 0 0 200 200 602 49453 01 321 Telephone Costs 211 211 211 300 300 602 49453 01 381 Electric Utilities 1 609 1 689 1 600 2000 2,000 602 49453 01 403 Contracted R M Other Impr 0 0 0 200 200 602 49453 01 439 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL LIFT STATION 43 5 278 1,944 5,304 3,400 3,400 602 49454 01 219 Other Operating Supplies 0 0 0 100 100 602 49454 01 221 Equipment Parts 120 852 813 500 500 602 49454 01 229 Other Maintenance Supplies 0 0 17 500 500 602 49454 01 321 Telephone Costs 211 211 211 300 300 602 49454 01 381 Electric Utilities 1,249 1,487 1,364 2000 2,000 Hawkins Pond 602 49454 01 403 Contracted R M Other Impr 0 0 0 200 200 602 49454 01 439 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL LIFT STATION #4 1,580 2,549 2,405 3 700 3,700 602 49455 01 219 Other Operating Supplies 0 0 0 100 100 602 49455 01 221 Equipment Parts 330 1,645 23,415 500 500 602 49455 01 229 Other Maintenance Supplies 0 0 0 200 200 602 49455 01 321 Telephone Costs 211 211 211 300 300 602 4945501 381 Electric Utilities 1 618 1,949 2,454 3 000 3,000 Country Hills 602 49455 01 403 Contracted R M Other Impr 524 0 0 200 200 602 4945501 439 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL LIFT STATION #5 2 684 3,805 26 080 4 400 4,400 602 49456 01 219 Other Operating Supplies 0 0 0 0 100 602 49456 01 221 Equipment Parts 0 0 0 0 500 602 49456 01 229 Other Maintenance Supplies 0 0 0 0 200 602 49456 01 321 Telephone Casts 0 0 0 0 0 602 49456 01 381 E'ecaic Utilities 0 0 0 0 900 602 49456 01 403 Contracted R M Other Impr 0 0 0 0 200 602 49456 01 439 Other Miscellaneous Charges 0 0 0 0 100 Contingencies TOTAL LIFT STATION #6 0 0 0 0 W 2000 GRAND TOTAL ALL DEPTS 636414 661,012 945,109 1,022,900 1,046,400 r Page One 2003 BUDGET WORKSHEETS STORM WATER UTILITY -REVENUES July 8, 2002 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Accouri Description Actual Actual Actual Budget Amount Budget Comments 603 34108 00 000 Administrative Fees -Other Funds $57544 $85327 $35,835 $40,000 $40,000 20% of 5% Fees -Const Projects 603 36101 00 000 Principal Special Assessments 25,956 13,873 31,632 15 000 15 000 603 3610200 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 603 36260 00 000 Other Revenues 0 7 188 0 0 0 603 37300 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 4205 2 280 4 000 4 000 603 3920300 000 Transfer From 67 308 110 612 69,144 0 0 FUND TOTALS 629556 769,197 703,949 608000 610,200 Page One 2003 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES July 8 2002 2002 2003 Object 2003 1999 2000 2001 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 60349500 101 Salaries Benefits $141417 $128,113 $131,339 $161300 $189,700 Salary, Taxes PERA &Benefits 603 49500 77 101 Administrative 19,700 603 49500 78 101 Technical /Clerical 81 800 603 49500 79 101 Maintenance 88 200 60349500 102 Full -Time Overtime 3,656 9,372 9714 10000 10,000 603 49500 01 203 Printed Forms Paper 212 705 562 500 500 603 49500 01 204 Envelopes Letterhead 0 0 0 0 0 603 49500 01 205 Draftmg Supplies 5 0 0 500 800 Paper, Pens Reproduction 603 49500 01 208 Miscellaneous Supplies 384 37 0 1,000 1 000 Stakes Ribbons, Level, etc 603 49500 01 215 Shop Materials 0 0 0 200 200 603 49500 01 219 Other Operating Supplies 222 106 468 1,500 1,500 603 49500 01 221 Equipment Pads 0 0 293 500 500 Fliers Hoses, Lights etc 603 49500 01 224 Sheet Maintenance Materials 219 0 0 2 000 2,000 Blacktop Gravel Washouts 603 49500 01 225 Landscaping Materials 943 203 828 4,800 4 800 603 49500 01 225 1 Rip -Rap, Matting Rock etc 3,000 603 49500 01 2252 Black Dirt, Seel Sod etc 1 000 603 49500 01 225 3 Weissmann Pond Restoration 800 Annual Seed Mamt Costs 603 49500 01 226 Sign Repair Matenais 0 0 0 600 600 Advance Warning Sign Rental 603 49500 01 230 Equipment Repair Material 277 62 0 1,000 1 000 Due to Breakdowns 603 4950001 241 Small Tools 0 303 0 1 000 1 000 Shovels Rakes Picks, etc 603 49500 01 242 Minor Equipment 190 65 0 0 0 603 49500 01 303 Engineering Fees 1,423 29,654 52,645 10 000 10,000 Problem Area Investigations 603 4950C 01 304 Legal Fees 438 0 0 2 000 2000 603 49500 01 310 Testing Services 0 0 0 1,000 1 000 Water Quality Tests (M) 603 49500 01 312 Contract Inspection Fees 0 500 0 500 500 3rd Part Inspection Program (M) 603 49500 01 318 Contract Engineer 0 0 0 20,000 20,000 Contracted Engineer for City 603 49500 01 319 Other Professional Services 0 0 2,774 0 0 603 49500 01 322 Postage Costs 1,940 2,067 2 338 3 000 3,000 Billings Info Mailings 603 49500 01 323 Radio Units 0 51 246 1 200 1,200 Replacements Repairs 603 49500 01 331 Travel Expense 0 31 47 200 200 603 49500 01 341 Employment Advertising 0 0 0 0 0 60349500 01 352 General Nobces Public into 0 0 0 1,000 1,000 Public Info Brochure 603 49500 01 365 Workers Comp insurance 1 395 1,330 1,659 3 000 3,000 Storm Water's Share of Premiums 603 49500 01 369 Other insurance 4 544 3,609 4 230 5 000 5 000 Storm Water's Share of Premiums 603 49500 01 384 Refuse Disposal 0 0 0 600 600 Roadside Debris 603 49500 01 389 Other Utility Services 0 0 0 1,000 1 000 Hazardous Materials Disposal 603 49500 01 391 PC Maintenance 0 0 250 300 300 Auto Read Software Support 603 49500 01 393 PC Hardware Purchases 0 539 0 1000 1,000 603 49500 01 394 P C Software Purchases 114 11,985 0 0 0 603 49500 01 403 Contracted R M Other Impr 6 333 0 0 25,000 25,000 6034950001 4031 Dilchmg 10,000 603 49500 01 4032 Miscellaneous Repairs 15,000 603 49500 01 404 Contracted Mach Equip Repairs 0 0 0 1,000 1,000 Repairs Sent Out 603 49500 01 416 Machinery Rental 470 1,329 0 10 000 10 000 Sackhoe Lowboy Pumps, etc 60349500 01 433 Dues Subscriptions 7 953 4,573 35 20 000 20,000 Watershed Organization 603 49500 01 435 Books Pamphlets 0 0 187 2000 2000 Utility Information 6034950001 437 Conferences Seminars 1,180 1000 805 2000 2,000 603 49500 01 437 1 Storm Water Management 1,000 603 49500 01 4372 Hydrocad Training 500 6034950001 4373 Wetlands Training 500 603 49500 01 439 Other Miscetlaneous Charges 449 17 8,550 0 0 603 49500 01 530 Improvements Other Than Slugs 0 0 43,141 80 000 0 603 49500 01 560 Furniture Fixture Purchases 0 0 0 500 500 603 49500 01 580 Other Equipment Purchases 0 0 0 2 000 2000 603 49500 01 586 Computer Equipment Purchases 0 0 0 500 500 603 49500 01 710 Transfers 149,049 170,496 185,000 217,000 270,000 603 49500 01 710 1 1/2 of 2003 P I Payments(1994B) 18,000 603 49500 01 7102 1/2 of 2003 P I Payments(19966) 50,000 603 49500 01 7103 V2 of 2003 P 1 Payments(1999C) 42 000 603 49500 01 7104 1 /2 of 2003 P I Payments (20016) 45,000 S 603 49500 01 710 5 112 of 2003 P I Pavments(2601 D) 74,000 603 49500 01 710 5 1/2 of 2003 P I Pavments(20028) 15,000 603 49500 01 7105 112 of 2003 P I Payments(2002C) 26000 603- 49500 -01 TOTALS 322,812 366,344 445,210 595,000 596,400 Page Two 2003 BUDGET WORKSHEETS STORM WATER UTILITY .EXPENDITURES July 8, 2002 Account Description 603 49511 01 221 Equipment Parts 603 49511 01 321 Telephone Costs 603 49511 01 381 Electric Utilities (Shannon Hills 601) TOTAL LIFT STATION #1 603 49512 01 221 Equipment Parts 603 49512 01 321 Telephone Costs 603 49512 01 381 Electric Utilities (Schwarz Pond) TOTAL LIFT STATION #2 603 49513 01 221 Equipment Parts 6C3 49513 01 321 Telephone Costs 603 4951301 381 Electric Utilities (B&rger Pond) TOTAL LIFT STATION #3 603 49514 01 221 Equipment Parts 603 49514 01 321 Telephone Costs 603 49514 01 381 Electric Utilities (Marcotle Pond) TOTAL -LIFT STATION #4 603 49515 01 221 Equipment Parts 603 49515 01 321 Telephone Costs 603 49515 01 351 Electric Utilities (Hawkins Pond) 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 0 500 500 211 211 211 300 300 178 242 160 500 500 441 453 371 1300 X 1,300 0 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 0 6,758 3674 7,800 7,800 0 0 0 500 500 0 0 0 300 300 0 0 0 500 500 0 0 0 1300 1,300 0 0 0 500 500 0 0 0 300 300 0 0 0 500 500 0 0 0 1,300 1 300 323 464 375,854 449 466 608,000 609,400 t