Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2.d. Budget Expenditure Line Item Changes
FUNDING REQUIREMENTS - USES (INCLUDING FIRE STATION LEVY) July 31, 2001 NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. 2001 2002 Adopted Proposed +/- Departments --------------------------------------------------------- - - - - Budget -- ----------------------------------------------------------------------- Budget Difference Percentage - - - - -- Council Budget $85,500 $88,600 $3,100 3.63% Administration Budget 284,900 320,300 35,400 12.43% Elections Budget 10,000 23,000 13,000 130.00% Finance Budget 186,800 252,000 65,200 34.90% General Government Budget 294,800 295,600 800 0.27% Community Development Budget 571,700 677,100 105,400 18.44% Police Budget 1,495,400 1,685,700 190,300 12.73% Fire Budget 192,400 250,300 57,900 30.09% Public Works Operating Budgets: Government Buildings Budget 286,700 312,900 26,200 9.14% Fleet Maintenance Budget 357,900 395,500 37,600 10.51% Street Maintenance Budget 789,300 893,200 103,900 13.16% Parks Maintenance Budget 367,500 423,000 55,500 15.10% Park & Rec Budget - General Operating 650,800 762,900 112,100 17.22% Park & Rec Budget - Special Programs 89,500 ------------------------------------------------------------------------------ 91,600 2,100 2.35% Total Operating Budgets - General Fund $5,663,200 $6,471,700 $808,500 14.28% Building CIP Requirements 202,000 24,000 (178,000) - 88.12% Street CIP Requirements 570,000 315,000 (255,000) - 44.74% Equipment CIP Requirements 280,700 661,100 380,400 135.52% Insurance Budget Requirements 190,000 200,000 10,000 5.26% Bonded Indebtedness 798,179 1,070,248 272,069 34.09% Bonded Indebtedness - Fire Station Levy 152,508 154,482 1,974 1.29% Armory Anticipatory Levy (Value 7/25/01) 162,481 173,011 10,530 6.48% "$95,000 + ($977,576,500 x .00798 %) Total Funding Requirements --------------------------------------------------------------------- $8,019,068 $9,069,541 $1,050,473 13.10% NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. FUNDING REQUIREMENTS - SOURCES (INCLUDING FIRE STATION LEVY) July 31, 2001 2001 2001 Adopted Proposed Types Budget Budget Difference Percentage ---------------------------------------------------- ----- -- - --- ---------------------------------------------------------------------------- Local Government Aid (LGA) $394,496 $394,621 $125 0.03% Homestead & Agricultural Aid (HACA) 577,707 0 (577,707) - 100.00% Internal Revenue Generated: Licenses and Permits Intergovernmental Charges for Services Fines & Forfeits Recreational Fees Miscellaneous Revenues Transfers In Total Internal Revenues Levy Sources: Special Levies General Levy Total Levy Total Revenue Sources 461,700 478,500 413,089 423,889 456,100 481,400 100,000 90,000 201,600 203,900 80,400 130,400 3,500 ----------------------------------- 3,500 1,716,389 1,811,589 16,800 3.64% 10,800 2.61% 25,300 5.55% (10,000) - 10.00% 2,300 1.14% 50,000 62.19% 0 0.00% 95,200 5.55% 1,113,168 1,397,741 284,573 25.56% 4,217,308 ----------------------------------------------------------------------- 5,465,590 1,248,282 29.60% $5,330,476 $6,863,331 $1,532,855 28.76% $8,019,068 $9,069,541 $1,050,473 13.10% NOTE: Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies. 0�- 2001 GENERAL PROPERTY TAX LEVY PAYABLE 2002 GENERAL LEVY GENERALFUND BUILDING CIP FUND STREET CIP FUND EQUIPMENT CIP FUND INSURANCE FUND TOTAL GENERAL LEVY BONDEDINDEBTEDNESS G.O. COMMUNITY CENTER BONDS 1992C (Authorized - $101,927) G.O. IMPROVEMENT BONDS 1992D (Authorized - $7,178) G.O. MUNICIPAL BUILDING BONDS 1992E (ICE ARENA) (Authorized - $264,141) G.O. IMPROVEMENT BONDS 1993A (Authorized - $3,314) G.O. BONDS 1993E (Port Authority) (Authorized - $64,166) G.O. BONDS 1994A (Port Authority) (Authorized - $171,610) G.O. IMPROVEMENT BONDS 1995A (Authorized - $20,687) G.O. IMPROVEMENT BONDS 1998C (Authorized - $7,314) G.O. IMPROVEMENT BONDS 1999B (Authorized - $17,274) G.O. BONDS 2000B (Port Authority) (Authorized - $238,104) G.O. PUBLIC FACILITY BONDS 2001C (Port Authority) (Authorized - $174,533) TOTAL BONDED INDEBTEDNESS MARKET VALUE BASED REFERENDUM - 1995 FIRE STATION LEVY G.O. FIRE STATION BONDS, 1996A (Authorized - $154,482) TOTAL FIRE STATION LEVY PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($95,000 + ($977,576,500 x.00798%)) (AS OF 7/25/01) TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS GRAND TOTAL 2001 PROPERTY TAX LEVY $4,265,490 $24,000 $315,000 $661,100 $200,000 $5,465,590 $101,927 $7,178 $264,141 $3,314 $64,166 $171,610 $20,687 $7,314 $17,274 $238,104 $174,533 $1,070,248 $154,482 $154,482 $173,011 $173,011 --------------------- - - - - -- $6,863,331 --------- - - - - -- --------------- —5. 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) Local Performance Aid (LPA) Levy Certified by City to County Auditor County Auditor Adjustments (All Subtractions): Fiscal Disparities Distributuion 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 530,667 581,379 612,593 612,593 (3) --- ---- ---- - -- -- --- ------ -- -- -- -- --------- - - ---- --------------- - -- 3,958,419 (1) 4,155,457 (1) 4,565,375 (1) 6,096,256 4.98% 9.86% 33.53% 153,363 155,715 152,508 154,482 (4) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2001 Numbers Provided by Minnesota Department of Revenue (Years 2000, 2001 & 2002 LPA are rolled into LGA as the LPA was repealed by the legislature) (Year 2002 HACA is removed as the HACA was repeated by the legislature) (3) 2002 Number Provided by Dakota County (At this time unavailable so just using 2001's number) (4) Market Value Based Levy for Fire Station - Based on $154,482 Levy Spread to Taxable Market Value on 12/31/01 Last Update from Dakota County 7/25/01 Shows the Levy of $154,482 / $977,576,500 = $.1580 per $1,000 as our Estimate Last Update - 7/31101 (Proposed) 1999 -- --- --------- 2000 ----- ----- -- - ----- 2001 - -- ------ --- ------ 2002 --------------- --- 6,995,146 7,440,486 8,019,068 9,069,541 1,404,750 1,573,889 1,716,389 1,811, 589 153,363 155,715 152,508 154,482 (4) -------- - - - - -- 5,437,033 ---------- - - - - -- 5,710,882 ------- ----------- 6,150,171 --------------- - -- 7,103,470 381,988 396,549 394,496 394,621 (2) 550,493 577,497 577,707 0 (2) 15,466 0 0 0 (2) •-------- - - - - -- 4,489,086 ------------ - - - - -- 4,736,836 ---- ---- --- --- - --- 5,177,968 --------------- - -- 6,708,849 530,667 581,379 612,593 612,593 (3) --- ---- ---- - -- -- --- ------ -- -- -- -- --------- - - ---- --------------- - -- 3,958,419 (1) 4,155,457 (1) 4,565,375 (1) 6,096,256 4.98% 9.86% 33.53% 153,363 155,715 152,508 154,482 (4) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2001 Numbers Provided by Minnesota Department of Revenue (Years 2000, 2001 & 2002 LPA are rolled into LGA as the LPA was repealed by the legislature) (Year 2002 HACA is removed as the HACA was repeated by the legislature) (3) 2002 Number Provided by Dakota County (At this time unavailable so just using 2001's number) (4) Market Value Based Levy for Fire Station - Based on $154,482 Levy Spread to Taxable Market Value on 12/31/01 Last Update from Dakota County 7/25/01 Shows the Levy of $154,482 / $977,576,500 = $.1580 per $1,000 as our Estimate Last Update - 7/31101 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) (Proposed) 1999 2000 2001 2002 Total Funding Requirements 6,995,146 7,440,486 8,019,068 9,069,541 Less: Internal Revenues 1,404,750 1,573,889 1,716,389 1,811,589 Less: Market Value Based Levy - Fire Station (See Below) 153,363 --- -- -- --- -- - --- -- 155,715 ----- 152,508 154,482 (4) Equals: Revenues Needed 5,437,033 ------ - - ----- 5,710,882 --- --- -- ---- - -- --- 6,150,171 --------------- - -- 7,103,470 City Adjustments (All Subtractions): Local Government Aid (LGA) 381,988 396,549 394,496 394 621 2 Homestead & Agricultural Credit Aid (HACA) 550,493 577,497 577,707 599,707 (2) Local Performance Aid (LPA) 15,466 0 0 2) Levy Certified by City to County Auditor ------ ------------ 4,489,086 -- -- -- ------ - -- - -- 4,736,836 -- ---------- - ----- 5,177,968 --------------- --- 6,109,142 County Auditor Adjustments (All Subtractions): Fiscal Disparities Distributuion Levy (Metro Area) Spread Levy Used to Compute Local Tax Rate Increase from Previous Year in Spread Levy 530,667 581,379 612,593 612,593 (3) ----- -- - -- ---- ------- -- --------- ----- -- --- -- - - -- -- --------------- - -- 3,958,419 (1) 4,155,457 (1) 4,565,375 (1) 5496549 4.98% 9.86% Market Value Based Referendum Levy - Fire Station 153,363 155,715 152,508 154,482 (4) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2001 Numbers Provided by Minnesota Department of Revenue (Years 2000, 2001 & 2002 LPA are rolled into LGA as the LPA was repealed by the legislature) (Year 2002 HACA is removed as the HACA was repealed by the legislature) (3) 2002 Number Provided by Dakota County (At this time unavailable so just using 2001's number) (4) Market Value Based Levy for Fire Station - Based on $154,482 Levy Spread to Taxable Market Value on 12/31/01 Last Update from Dakota County 7125101 Shows the Levy of $154,482 / $977,576,500 = $.1580 per $1,000 as our Estimate Last Update - 7/31101 Lo s I /4 , , rc A --,k- i L F�J wt t ovi V� 5 MINNESOTA Department of Revenue Property Tax Division 2002 LOCAL GOVERNMENT AID NOTICE ROSEMOUNT CITY OF CLERK CITY HALL 2875 145TH ST W ROSEMOUNT, MN 55068 Mail Station 3340 St. Paul, MN 55146 -3340 Phone (651) 296 - 5141 Fax (65 1) 297 - 2166 July 25, 2001 THE 2002 LOCAL GOVERNMENT AID FOR YOUR CITY IS: $ 394,621 THE FOLLOWING IS A LISTING OF THE FACTORS USED IN THE CALCULATION OF YOUR CITY'S 2002 LOCAL GOVERNMENT AID. SEE THE ENCLOSED LETTER FOR AN EXPLANATION OF THESE FACTORS AND FOR ADDITIONAL_ INFORMATION 1 Ir '-rte. ..� . -- .� ra.�rv�iivv TnC DE i ER;0;NA ;0N yr YOUR CI T * (7 LOCAL Qi0VL I AIU. 1. PRE -1940 HOUSING UNITS: 158 2. TOTAL HOUSING UNITS: 2,866 3. PRE -1940 HOUSING PERCENTAGE: 5.51 % 4. 1990 POPULATION: 8,622 5. 2000 POPULATION: 14,619 6. POPUL, "ATION DECLINE PERCENTAGE: 0.00 % 7. 2000 TOTAL CLASS 3 REAL PROPERTY MARKET VALUE: $ 141,235,545 8. 2000 TOTAL REAL AND PERSONAL MARKET VALUE: $ 845,495,473 9. COMMERCIAL /INDUSTRIAL PERCENTAGE: 16.70 % 10. TRANSFORMED POPULATION: 729.03 11. CITY REVENUE NEED: $ 259.80 12. PAYABLE 2001 CITY NET LEVY: $ 5,330,586 13. PAYABLE 2001 CITY NET TAX CAPACITY: $ 15,573,391 14. TAX EFFORT RATE: 0.303763 15. NEED INCREASE PERCENTAGE: 0.479363 % 16. CITY AID BASE: $ 394,966 17. CITY FORMULA AID (15x(11x5)- (13x14)): $ 0 18. PRELIMINARY AID (16 +17): It 1QA OR 19. 2001 LOCAL GOVERNMENT AID: $ 394,966 19a. 2001 HOMESTEAD AND AGRICULTURAL CREDIT AID: $ 577,831 20 *. 2002 MAXIMUM AID (.4x(12 +19a) +19): $ 2,758,333 21. 2002 LGA BEFORE REDUCTIONS (LESSER OF 18 OR 20): $ 394,966 22. REDUCTION FOR STATE COSTS: $ 345 23. FINAL 2002 LOCAL GOVERNMENT AID AFTER REDUCTIONS (21 -22): $ 394,621 * PLEASE NOTE: Effective for aids payable in 2002, the Homestead and Agricultural Credit Aid (HACA) for cities has been eliminated. Your city's 2001 HACA is now used as a factor in determining your local government aid (see description for Line 20 - -2002 Maximum Aid). 1rr eyrvul n/rpnrnurrh ivrr /rinrc�r 7'00 (0/) 297 - 2 /90 Y MINNESOTA Department of Revenue Property Tax Division Mail Station 3340 St. Paul, MN 55146 -3340 Phone (651) 296 -5141 Fax (651) 297 -2166 July 25, 2001 TO: CITIES RE: NOTICE OF 2002 LOCAL GOVERNMENT AID The amount of your city's 2002 local government aid has been determined and is shown on the enclosed notice. The notice also lists the factors used to determine your city's 2002 local government aid. Following is an explanation of these factors. PLEASE NOTE: Effective for aids payable in 2002, the Homestead and Agricultural Credit Aid (HACA) for cities has been eliminated per First Special Session Laws, Chapter 5, Article 3, Section 40. Your city's 2001 HACA is now used as a factor in determining your city's local government aid (see description for Line 20 - -2002 Maximum Aid). 1. PRE -1940 HOUSING UNITS: This is the total number of housing units in your city that were constructed before 1940 according to the 1990 Federal Census (2000 Federal Census data for pre -1940 housing units is not available). 2. TOTAL HOUSING UNITS: This is the total number of all housing units in your city (both vacant and occupied) according to'the 1990 Federal Census. 3. PRE -1940 HOUSING PERCENTAGE: This is the result of dividing the total number of pre -1940 housing units (line 1) by the total number of housing units (line 2), multiplied by 100. 4. 1990 POPULATION: This is the 1990 population estimate for your city as determined by the Federal Census for 1990. 5, 2000 POPULATION: This is the 2000 population estimate for your city as determined by the Federal Census for 2000. 6. POPULATION DECLINE PERCENTAGE: If your city's 1990 population (line 4) is greater than your city's 2000 population (line 5), this is the result of subtracting line 5 from line 4 and dividing the difference by line 4, multiplied by 100. If your city's 2000 population is greater than your city's 1990 population, your population decline percentage is zero. 7. 2000 TOTAL CLASS 3 REAL PROPERTY MARKET VALUE: This is the total 2000 (taxes payable 2001) Class 3 market value of all commercial, industrial, and employment properties in your city, before any adjustments for fiscal disparities and excluding public utility properties. These values are not equalized. 8. 2000 TOTAL REAL AND PERSONAL MARKET VALUE: This is the total 2000 (taxes payable 2001) real and personal market value of your city before any adjustments for fiscal disparities, but after any limited market value adjustments. These values are not equalized. (continued) An equal opportimaYemplover TDI). (651) 11 )' - 1 !96 7. 9. COMMERCIAL /INDUSTRIAL PERCENTAGE: This is the result of dividing your city's total Class 3 market value (line 7) by your city's total real and personal market value (line 8), and multiplying the result by 100. 10. TRANSFORMED POPULATION: This is the result of multiplying your city's population (line 5), raised to the .3308 power, by 30.5485. 11. CITY REVENUE NEED: If your city's population is less than 2,500 your city's revenue need is the result of. a) 1.795919 times the pre -1940 housing percentage (line 3), plus b) 1.562138 times the commercial /industrial percentage (line 9), Plus c) 4.177568 times the population decline percentage (line 6), plus d) 1.04013 times the transformed population (line 10), minus e) 107.475. If your city's population is 2,500 or greater your city's revenue need is the result of a) 3.462312 times the pre -1940 housing percentage (line 3), plus b) 2.093826 times the commercial /industrial percentage (line 9), plus c) 6.862552 times the population decline percentage (line 6), plus d) .00026 times the city population (line 5), PILLS e) 152.0141. The city revenue need is then multiplied by the ratio of the most recent implicit price deflator for state and local government purchases of goods and services to the 1993 implicit price deflator for state and local government purchases of good and services. (The March, 2001 and March, 1993 indices were used to compute this ratio). For determination of 2002 local government aid, this ratio is 1.237971. 12. PAYABLE 2001 CITY NET LEVY: This is your city's payable 2001 levy excluding your city's 2001 homestead and agricultural credit aid (HACA). If your city is located in the seven - county metropolitan area or the iron range area, the net levy for your city includes the fiscal disparities distribution levy. 13. PAYABLE 2001 CITY NET TAX CAPACITY: This is your city's 2000 (payable 2001) equalized net tax capacity. The net tax capacity excludes any tax increment financing (TIF) district value and any power line value. If your city is located in the seven - county metropolitan area or the iron range area, the net tax capacity excludes any fiscal disparities contribution value and includes any fiscal disparities distribution value. For cities that received a TIF aid reduction for 2001 LGA, this value is adjusted by the amount of the city's payable 2000 qualified captured net tax capacity (see line 23 below). (continued) 14. TAX EFFORT RATE: This is the result of dividing the sum of the statewide total payable 2001 net levy for all cities plus the statewide total HACA for cities by the statewide total payable 2001 equalized net tax capacity for all cities. The tax effort rate is the same for all cities. 15. NEED INCREASE PERCENTAGE: This is the percentage that is needed to increase the total 2002 local government aid for all cities to the amount of local government aid appropriated for cities in 2002. The need increase percentage is the Same for all cities. 16. CITY AID BASE: This is the total of your city's 1993 local government aid, 1993 equalization aid, 1993 disparity reduction aid, and 1999 local performance aid. 17. CITY FORMULA AID: This is the result of multiplying the need increase percentage (line 15) times the difference between a) the city's revenue need (line 11) multiplied by the city's population (line 5) and b) the city's net tax capacity (line 13) multiplied by the tax effort rate (line 14). 18. PRELIMINARY AID: This is your city's formula aid (line 17) plus your city's city aid base (line 16). 19. 2001 LOCAL GOVERNMENT AID: This is the total amount of local government aid your city was certified to receive in calendar year 2001, before the reduction for state costs or tax increment financing aid reductions. 19a. 2001 HOMESTEAD AND AGRICULTURAL CREDIT AID: This i-s the total of your city's 2001 Homestead and Agricultural Credit Aid before reduction for local impact note costs or tax increment financing aid reductions. 20. 2002 MAXIMUII AID: For cities of the first class (Minneapolis, St. Paul, and Duluth) The maximum aid is limited to the city's 2001 local government aid (line 19) plus the city's 2001 HACA (line 19a), multiplied by 1.025. For all other cities The maximum aid is limited to 40 percent of the sum of the city's net levy for the taxes payable year 2001 (line 12) and the city's 2001 HACA (line 19a), plus the city's 2001 local government aid (line 19). 21. 2002 LOCAL GOVERNMENT AID BEFORE STATE COSTS: This is the lesser of your city's preliminary aid (line 18) or your city's maximum aid (line 20). 22. REDUCTION FOR STATE COSTS: Minnesota Statutes, Section 477A.014, Subdivision 4 provides for reductions in local government aid to finance certain state costs. All cities receiving local government aid in 2002 receive a reduction for state costs based on their prorated share of the following amounts: Calendar Year 2002 State Demographer $ 16,000 State Auditor (Government Information Division) 217,000 Department of Administration (I1SAC) 205,800 Department of Employee Relations (Pay Equity) 55,000 TOTAL $ 493,800 3 23. FINAL 2002 LOCAL GOVERNMENT AID AFTER REDUCTIONS: This is the total amount of your city's 2002 aid distribution (line 21) minus the reduction for state costs (line 22). Your city's 2002 local government aid will be paid in two equal installments. The first half installment will be paid on or before July 20, 2002, and the second half installment will be paid on or before December 26, 2002. Minnesota Statutes, Section 477A.014 provides that a governmental unit may object to the amount of aid that the Department of Revenue has determined for it. No objection may be raised later than 60 days after receipt of this notice. Such objection should be addressed to Director, Property Tax Division, Minnesota Department of Revenue, Mail Station 3340, St. Paul, MN 55146 -3340. If you have any questions regarding this letter, please call me at (651) 296 -5141. Sincerely, Larry IJ'�: Bewley Research Analysis Specia ist Enclosure 4 /� Page One 2002 BUDGET WORKSHEETS GENERAL FUND REVENUES July 31, 2001 Account # Description 101 31010 00 000 Current Ad Valorem Taxes 101 31040 00 000 Fiscal Disparities Total Taxes (fax) 101 33401 00 000 Local Government Aid (LGA) Total LGA (Lga) 101 33402 00 000 Hstd & Ag Credit Aid (HACA) 2001 2002 Object 2002 1998 1999 2000 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $2,046,035 $1,949,827 $2,095,667 $2,362,015 Total HACA (Hasa) 101 3342400 000 Local Performance Aid (LPA) 475,045 Total LPA (Lpa) 101 3211000 000 Alcoholic Beverage Licenses (L) 101 3216000 000 Licenses to do Business (L) 101 32161 00 000 Licenses to do Bus - Kennels (L) 101 3218000 000 Cigarette Licenses (L) 101 3221000 000 Building Permit Revenue (L) 101 32211 00 000 Coates Bldg Official Reimb (L) 101 3221200 000 Mineral Extraction Permit (L) 101 3222000 000 Electrical Permit Revenue (L) 101 3223000 000 Plumbing Permit Revenue (L) 101 3224000 000 Animal Licenses (L) 101 3225000 000 Sewer Permit Revenue (L) 101 3225500 000 County Recording Fee - City's (L) 101 3226000 000 HVAC Permit Revenue (L) 101 3229000 000 Other Non -Bus Lic & Permits (L) 577,497 Total Licenses & Permits (L) 101 3101000 000 Current Ad Valorem Taxes (1) 101 3101000 000.1 MSABC Armory Payments 101 3102000 000 Delinquent Ad Valorem Taxes (1) 101 3103000 000 Mobile Home Taxes (1) 101 3171000 000 Gravel Taxes (1) 101 3181000 000 Franchise Taxes - Regular Fees (1) 101 31811 00 000 Franchise Taxes - PEG Fees (1) 101 3192000 000 Forfeited Tax Sale Apportionment 101 3310000 000 Federal Grants & Aids (1) 101 3340300 000 Mobile Home HACA (1) 101 3341600 000 Police Training Reimbursement (I) 101 3341600 000.1 Post Board Training Reimb 101 3341600 000.2 State Aid (Tied to PERA) 101 3341800 000 MSA for Streets - Maintenance (1) 101 3342300 000 Ag Preserves Credit (1) 101 3342500 000 Other State Grants & Aids 101 3342500 000.1 PERA Aid 101 3342500 000.2 Safe & Sober Grant 101 3362000 000 Other County Grants & Aids (1) 101 3363000 000 Police Services Levy -ISD #196 (1) 101 3363000 000.1 D.A.R.E. /Liaison Funding 101 36101 00 000 Principal - Special Assessments (I) 101 3610200 000 Penalties & Interest - S/A (1) 0 Total Intergovernmental (1) 0 PAGE TOTALS 2001 2002 Object 2002 1998 1999 2000 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $2,046,035 $1,949,827 $2,095,667 $2,362,015 $3,652,897 From County 475,045 530,667 - --- 581,379 - ----- 612,593 --------------------------- 612,593 From County 2,521,080 2,480,494 2,677,046 2,974,608 4,265,490 380,488 381,988 396,549 394,496 394,621 From State 380,488 381,988 396,549 394,496 394,621 550,561 550,493 ------------------------------------ 577,497 577,707 0 From State - Program Eliminated 550,561 550,493 577,497 577,707 0 16,266 15,466 0 0 0 From State - Rolled into LGA 16,266 15,466 0 0 0 12,792 14,166 16,840 15,000 17,000 1,900 2,150 1,359 1,000 1,000 Garbage Haulers, Ped Lic, etc 25 50 75 0 0 192 0 0 0 0 273,322 479,029 461,126 355,000 373,000 0 0 0 0 0 1,640 2,275 4,030 1,500 1,800 10,114 21,543 12,839 15,000 12,000 20,475 36,934 32,305 25,000 25,000 3,407 2,190 2,228 2,500 2,000 12,014 24,039 21,355 15,000 15,000 150 230 200 200 200 25,082 39,358 34,621 30,000 30,000 2,125 1,500 ---------------------------------------------------- 1,325 1,500 1,500 Alarm Permits 363,238 623,463 588,304 461,700 478,500 90,000 91,000 90,000 90,000 90,300 Included in Debt Levy Figure 90,300 60,197 36,624 27,003 20,000 20,000 From County 11,196 11,744 11,656 10,000 10,000 From County 10,432 7,003 7,673 7,000 7,000 From County 45,965 125,757 93,639 75,000 95,000 From Cable Company 0 0 9,253 9,000 10,000 From Cable Company 200 0 0 0 0 From County 79,487 21,250 276,637 0 0 Grant for 1 Officer 22,463 22,987 23,060 22,000 0 From State - Program Eliminated 93,936 94,847 94,280 90,000 93,000 From State 6,000 87,000 27,900 27,900 26,596 27,900 27,900 From State 944 0 1,059 0 0 From State 14,091 30,233 12,889 12,889 19,389 From State 12,889 6,500 11,341 11,619 11,845 11,300 11,300 Dakota County Recycling Funds 30,930 35,091 36,979 38,000 40,000 40,000 From ISD #196 165 0 0 0 0 42 0 0 0 0 From County 499,290 ------------------------------------------------ 516,055 722,568 413,089 423,889 4,330,923 ------------------------------------------ 4,567,959 4,961,964 4,821,600 5,562,500 Page Two 2002 BUDGET WORKSHEETS GENERAL FUND REVENUES July 31, 2001 Account # Description 101 34103 00 000 Zoning & Subdivision Fees (C) 101 3410400 000 Plan Checking Fees (C) 101 3410500 000 Sales of Maps & Publications (C) 101 3410600 000 Deputy Registrar Fees (C) 101 3410700 000 Assessment Searches (C) 101 3410800 000 Admin Fees - Other Funds (C) 101 34108 00 000.1 Applicable Funds Except Const. 101 3410800 000.2 Construction Funds 101 3410900 000 Other Charges for Service (C) 101 3411000 000 Service Chg on Returned Chks (C) 101 3411200 000 Utility Permit Application Fee (C) 101 34160 00 000 National Guard Maint Fees (C) 101 3416000 000.1 Shared Space Rental Agreement 101 3416000 000.2 Building Maintenance Contract 101 3420100 000 Special Police Services (C) 101 34202 00 000 Fire Services - Burning Permits (C) 101 3420300 000 Accident Reports (C) 101 34204 00 000 Day Care Inspection Fees (C) 101 3420600 000 Other Police Services (C) 101 3420700 000 Other Fire Protection Services (C) 101 3420700 000.1 U of M Fire Contract 101 3420700 000.2 Coates Fire Contract 101 3420700 000.3 Other Billed Fire Calls 101 34303 00 000 Mow Weeds (C) 101 3430600 000 Other Highway & Street Rev (C) 101 3440700 000 City Share of Metro SAC Chgs (C) Total Charges for Services (C) 101 35101 00.000 Court Fines (F) 3,169 Total Fines & Forfeits (F) 101 3472000 000 Park Reservations (R) 101 34721 00 000 Softball Revenues (R) 101 3472200 000 Volleyball Revenues (R) 101 34724 00 000 Tennis Revenues (R) 101 3472500 000 Tiny Tot Revenues (R) 101 3472600 000 Pom Porn Revenues (R) 101 34727 00 000 Field Trip Revenues (R) 101 3472800 000 Broomball Revenues (R) 101 3472900 000 Skating Lesson Revenues (R) 101 34730 00 000 Fun Runs, Walks & Bike Rides (R) 101 3473200 000 Adult Basketball (R) 101 34733 00 000 Other Programs Revenues (R) 101 3473500 000 Summer Camps (R) 101 3473600 000 T -Ball (R) 101 34790 00 000 Other Recreation Revenues (R) 101 38080 00 000 Banquet Room Fees (R) 101 38081 00 000 Auditorium Fees (R) 101 3808200 000 Gymnasium Fees (R) 101 3808400 000 Pistol Range Fees (R) 101 38086 00 000 Classroom Fees (R) 101 3809600 000 Liquor Provider Fees (R) 101 3809700 000 A/V Rental Fees (R) 101 3815000 000 Open Gym Fees (R) 101 3815200 000 Jazzercise Fees (R) 101 3815400 000 Teen Night Revenues (R) Total Recreation Fees (R) PAGE TOTALS 2001 2002 Object 2002 1998 1999 2000 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 16,751 8,068 18,592 10,000 12,000 127,574 228,930 271,726 200,000 210,000 65% of Building Permit Fees 1,130 404 542 500 500 26,284 31,418 30,652 27,000 35,000 State Fee Increase 7/1101 85 327 60 200 100 106,754 140,088 195,691 100,000 100,000 25,000 75,000 3,169 2,069 2,429 4,000 3,000 180 180 240 100 100 150 150 300 200 200 0 16,000 80,700 68,600 71,300 16,000 55,300 New Agreement for 2000 17,874 23,503 21,280 20,000 21,000 Contractual O(T for Officers 3,787 4,183 3,723 3,000 3,500 462 513 550 500 500 588 292 504 200 200 0 23 0 0 0 20,373 25,188 66,121 20,000 21,000 4,800 3,200 13,000 294 529 3,258 0 0 24,492 150 14,130 0 0 1,704 4,365 3,395 1,800 3,000 351,650 486,379 713,892 456,100 481,400 72,084 91,441 72,067 100,000 90,000 From County 72,084 91,441 72,067 100,000 90,000 1,123 890 1,175 1,100 1,500 42,031 44,138 44,701 37,500 37,500 7,431 6,717 4,780 9,500 9,400 957 1,375 1,148 1,300 1,300 11,413 12,506 15,240 16,000 16,600 2,538 2,307 1,916 2,500 2,500 3,442 4,534 2,524 2,200 2,800 2,350 1,170 780 0 0 336 602 450 800 800 2,152 1,714 1,717 1,000 1,000 1,080 1,020 1,260 800 700 7,198 9,218 11,154 2,800 3,500 0 0 0 3,000 3,000 0 0 0 3,200 3,200 45 0 0 0 0 51,003 55,499 60,228 52,500 52,500 13,462 12,200 13,351 12,600 12,600 17,269 17,470 24,538 20,000 20,000 2,516 3,750 3,775 4,700 4,700 27,364 25,108 28,834 22,000 22,000 1,790 1,540 1,440 2,000 2,000 808 835 663 700 700 805 0 0 1,000 1,000 201 0 0 0 0 4,040 4,985 4,358 4,400 4,600 201,352 207,578 224,033 201,600 203,900 625,086 785,398 1,009,993 757,700 775,300 1a. Page Three 2002 BUDGET WORKSHEETS GENERAL FUND REVENUES July 31, 2001 Account # Description 101 3621000 000 Interest Earnings - Investments (M) 101 3621400 000 Net Change in FV- Investments (M) 101 3621500 000 Interest Earnings (M) 101 36220 00 000 Rents & Royalties (M) 101 3623000 000 Contribution /Donations (M) 101 3626000 000 Other Revenue (M) Amount Budget Total Misc Revenues (M) 101 39202 00 000 Contribution from Enterprises (T) 152,349 Total Transfers In (T) 120,000 PAGE TOTALS 2,104 DEPARTMENT TOTALS 22,969 INTERNAL REVENUES 3,500 3,500 3,500 3,500 3,500 -- -- - - - - -- ----- --- -- - - - - -- - -- $143,938 $120,151 $235,074 $83,900 $133,900 $5,099,947 $5,473,508 $6,207,031 $5,663,200 $6,471,700 $1,631,552 $2,045,066 $2,555,938 $1,716,389 $1,811,589 Grand Total Less: Ad Valorem, LGA, HACA, LPA & Fiscal Disparities /2. 2001 2002 Object 2002 1998 1999 2000 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 76,015 83,426 152,349 70,000 120,000 2,104 (31,095) 22,969 0 0 Annual Market Value Changes 1,543 1,532 1,432 1,000 1,000 From Checking Account 3,380 4,056 4,394 4,400 4,400 US West Antenna Rent 51,032 55,315 44,146 0 0 6,365 3,417 6,284 5,000 5,000 140,438 116,651 231,574 80,400 - 130,400 3,500 3,500 3,500 3,500 3,500 Arena - Bldg & Grounds Maint 3,500 3,500 3,500 3,500 3,500 -- -- - - - - -- ----- --- -- - - - - -- - -- $143,938 $120,151 $235,074 $83,900 $133,900 $5,099,947 $5,473,508 $6,207,031 $5,663,200 $6,471,700 $1,631,552 $2,045,066 $2,555,938 $1,716,389 $1,811,589 Grand Total Less: Ad Valorem, LGA, HACA, LPA & Fiscal Disparities /2. Page Four 2002 BUDGET WORKSHEETS GENERAL FUND REVENUES July 31, 2001 Account # Description 2001 2002 Object 2002 1998 1999 2000 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 101 3410800 000 General Fund Admin Fees $25,000 $25,000 $25,000 $25,000 $25,000 101 3410800 000.1 Fund 201 6,000 101 3410800 000.2 Fund 202 2,500 101 3410800 000.3 Fund 203 2,500 101 3410800 000.4 Fund 206 2,500 101 3410800 000.5 Fund 207 2,500 101 3410800 000.8 Fund 605 1,000 101 3410800 000.9 Fund 606 1,000 101 3410800 000.11 Fund 607 1,000 101 3410800 000.12 Fund 650 6,000 Admin Fees Breakdown Totals $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 T Page One 2002 BUDGET WORKSHEETS COUNCIL July 31, 2001 Account # Description 101 41110 103 Salaries & Benefits 101 4111001 307 Management Fees 101 4111001 307.1 Newsletter 101 4111001 307.2 Chamber of Commerce Directory 101 4111001 307.3 Council Projects 101 4111001 319 Other Professional Services 101 4111001 319.1 Education Reimbursement 101 4111001 319.2 Long -Range Planning Consultant 101 4111001 329 Other Communication Costs 101 4111001 331 Travel Expense 101 4111001 433 Dues & Subscriptions 101 4111001 433.1 LMC Dues 101 41110 01 433.2 AMM Dues 101 41110 01 433.3 NDCC Dues 101 4111001 435 Books & Pamphlets 101 4111001 437 Conferences & Seminars 101 4111001 437.1 Registration & Hotel -LMC Conf 101 4111001 437.2 Miscellaneous Conferences 101 4111001 439 Other Miscellaneous Charges 101 4111001 598 Council Designated 101 4111001 598.1 Yearly Contingencies PAGE TOTALS DEPARTMENT TOTALS 1998 Actual 1999 Actual 2000 Actual 2001 Adopted Budget 2002 Object Detail Amount 2002 Proposed Budget Comments All Salary Costs Inclusive of $20,513 $18,781 $19,048 $25,400 $25,700 Salary, Taxes, PERA & Benefits 13,509 19,781 13,672 15,500 15,500 3,000 500 12,000 2,024 2,539 4,230 15,700 15,700 3,700 12,000 12,333 0 313 0 0 1998 - Resident Packets Costs 130 0 176 300 300 10,833 11,546 4,259 11,500 13,800 9,300 4,000 500 0 62 0 100 100 2,926 4,946 2,741 3,000 3,500 2,000 1,500 14,600 19,294 16,123 0 0 129,695 21,160 2,767 14,000 14,000 1998- Encumbrances 14,000 - $206,563 ------------------------------------------------- $98,107 $63,328 $85,500 $88,600 $206,563 $98,107 $63,328 $85,500 $88,600 /J Page One 2002 BUDGET WORKSHEETS ADMINISTRATION July 31, 2001 Account # Description 101 41320 101 Salaries & Benefits 101 41320 102 Full -Time Overtime 101 4132001 207 Training & Instructional Supplies 101 4132001 207.1 Safety Committee 101 4132001 207.2 Right to Know 101 41320 01 207.3 Employee Training 101 4132001 209 Other Office Supplies 101 4132001 307 Management Fees 101 41320 01 331 Travel Expense 101 4132001 331.1 State Conference - LMC 101 41320 01 331.2 State Conference - MCMA 101 4132001 331.3 Personnel Workshops 101 41320 01 331.4 ICMA Conference 101 4132001 341 Employment Advertising 101 41320 01 353 Ordinance Publication 101 4132001 394 P.C. Software Purchases 101 4132001 433 Dues & Subscriptions 101 4132001 433.1 MCMA Dues 101 4132001 433.2 MAMA Dues 101 4132001 433.3 MCFOA Dues 101 4132001 433.4 IIMC Dues 101 4132001 433.5 IPMA Dues 101 4132001 433.6 ICMA Dues 101 4132001 435 Books & Pamphlets 101 4132001 437 Conferences & Seminars 101 4132001 437.1 Registration & Hotel - LMC 101 4132001 4 ,37.2 Registration & Hotel - MCMA 101 4132001 437.3 Personnel Conferences 101 41320 01 437.4 Staff (1) Each 101 41320 01 437.5 Miscellaneous Seminars 101 4132001 437.6 Registration & Hotel - ICMA 101 4132001 437.7 Advanced Clerks School 101 4132001 580 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS A0. 2001 2002 Object 2002 1998 1999 2000 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of $233,962 $263,673 $232,990 $270,500 $305,200 Salary, Taxes, PERA & Benefits 1,286 667 1,867 2,000 1,000 704 270 1,439 1,900 1,900 200 1,200 500 284 252 390 300 300 Miscellaneous Purchases 3,114 3,207 5,627 4,000 4,000 Labor Consultant 53 1,086 402 600 600 50 50 100 400 0 0 913 0 0 3,432 661 1,134 1,500 2,000 Codification of Code 0 0 3,111 0 0 960 1,256 9,210 1,200 1,300 75 75 75 100 75 900 48 60 309 100 100 2,191 1,692 3,100 2,800 3,000 300 200 500 _ 200 400 1,200 200 0 0 0 0 900 Typewriter & Organizer - - -------- $246,035 - - - - - - $272,822 ------- - - - - ------------- $260,493 - ------- $284,900 - - - - $320,300 $246,035 $272,822 $260,493 $284,900 $320,300 A0. Page One 2002 BUDGET WORKSHEETS ELECTIONS July 31, 2001 Account # Description 101 41410 103 Part-Time Salaries 101 4141001 203 Printed Forms & Paper 101 4141001 208 Miscellaneous Supplies 101 4141001 219 Other Operating Supplies 101 4141001 242 Minor Equipment 101 4141001 319 Other Professional Services 101 4141001 321 Telephone Costs 101 4141001 351 Legal Notices Publishing 101 4141001 409 Other Contracted Repair & Maint 101 4141001 412 Building Rental 101 4141001 439 Other Miscellaneous Charges 101 4141001 580 Other Equipment Purchases 300 PAGE TOTALS 0 DEPARTMENT TOTALS 2001 2002 Object 2002 1998 1999 2000 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $7,658 $0 $9,909 $0 $11,000 Election Judges -2 New Precincts 423 0 332 0 600 Ballots & Programming 450 0 1,082 0 1,000 Election Purchases 332 0 197 0 300 Rolls for Election Judges 0 0 1,551 0 2,000 Booths & Signs 0 0 1,022 0 1,000 0 0 10 0 0 41 0 54 0 100 Election Publications 2,640 0 0 0 800 Maintenance for Optechs 0 0 0 0 500 Possible Rent for Locations 0 0 0 0 0 0 0 1,136 10,000 5,700 2 New Machines(Actual - $13,200) -------------------------- ------------------------ (Balance from 2001 Encumbrance) $11,543 $0 $15,293 $10,000 $23,000 $11,543 $0 $15,293 $10,000 $23,000 /7 Page One 2002 BUDGET WORKSHEETS FINANCE July 31, 2001 Account # Description 101 41520 101 Salaries & Benefits 101 41520 102 Full -Time Overtime 101 4152001 319 Other Professional Services 101 4152001 331 Travel Expense 101 4152001 331.1 Finance Director 101 4152001 331.2 Staff 101 41520 01 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 Support 101 4152001 391.4 Motor Vehicle S/W Maint 101 4152001 391.5 Fixed Asset Maint Contract 101 4152001 391.6 Miscellaneous P.C. Repairs 101 4152001 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 MDRA Annual Fees 101 4152001 433.2 MGFOA - Finance Director 101 4152001 433.3 MGFOA - Staff 101 4152001 433.4 GFOA - Finance Director 101 4152001 433.5 Magazine Subscriptions 101 4152001 435 Books & Pamphlets 101 4152001 435.1 Accounting Related Books 101 4152001 435.2 Finance Related Books 101 4152001 437 Conferences & Seminars 101 4152001 437.1 MDRA Confe[ence (For 2) 101 4152001 437.2 MGFOA Annual Conf (F /D) 101 4152001 437.3 GFOA National Conf (F /D) 101 4152001 437.4 Miscellaneous Seminars 101 4152001 439 Other Miscellaneous Charges 101 41520 01 570 Office Equipment & Furnishings PAGE TOTALS DEPARTMENT TOTALS 1998 Actual 1999 Actual 2000 Actual 2001 Adopted Budget 2002 Object Detail Amount 2002 Proposed Budget Comments All Salary Costs Inclusive of $98,038 $104,284 $119,814 $140,100 $192,100 Salary, Taxes, PERA & Benefits 65 164 307 500 500 6,850 5,800 0 5,800 10,000 F/A Reinventory & Infrastructure 438 185 126 800 800 600 National Convention & Misc 200 23,392 28,324 24,539 30,000 39,000 7,500 3,500 24,000 250 Hours of Support Time 1,000 1,000 2,000 3,552 1,077 2,384 3,000 3,000 City System Supplies 0 831 607 2,000 2.000 1,342 2,631 0 1,000 1,000 318 140 245 300 300 Cash Register Repairs 483 277 120 600 600 200 50 50 200 100 172 33 53 200 200 100 100 2,213 1,109 1,104 2,000 2.000 200 300 1,000 500 48 166 108 500 500 Contigencies 0 0 417 0 0 $136,909 $145,020 $149,825 $186,800 $252.000 $136,909 $145,020 $149,825 $186,800 $252,000 I� Page One 2002 BUDGET WORKSHEETS GENERAL GOVERNMENT July 31, 2001 Account # Description 101 41810 01 202 Duplicating & Copying 101 41810 01 202.1 Microfilming /Laserfiche 101 41810 01 202.2 Copying Costs 101 41810 01 203 Printed Forms & Paper 101 41810 01 203.1 Copy Paper 101 41810 01 203.2 General Receipt Books 101 4181001 203.3 Purchase Orders 101 41810 01 203.4 Payroll Checks 101 41810 01 203.5 A/P Checks 101 4181001 203.6 Greenbar Computer(30 Boxes) 101 4181001 204 Envelopes & Letterheads 101 4181001 204.1 Letterhead 101 41810 01 204.2 Plain Envelopes 101 41810 01 204.3 A/P & Payroll Envelopes 101 41810 01 204.4 10 x 13 Envelopes 101 41810 01 204.5 10 x 15 Envelopes 101 41810 01 209 Other Office Supplies 101 4181001 221 Equipment Parts 101 4181001 242 Minor Equipment 101 4181001 242.1 State Purchasing Program 101 41810 01 242.2 Fax Machine Maint Agreement 101 4181001 242.3 HP 5si Printer Maintenance 101 4181001 301 Auditing & Accounting Services 101 4181001 301.1 2001 Audit & General Consulting 101 4181001 301.2 Dakota County Assessment Fees 101 4181001 301.3 Dak Cty Truth In Taxation Costs 101 4181001 301.4 Printing of Budget Books 101 4181001 304 Legal Fees 101 4181001 319 Other Professional Services 101 4181001 319.1 Fire Relief Association 101 4181001 319.2 Flex Admin Plan Fees 101 41810 01 319.3 SWWC Co- operative Dues 101 4181001 319.4 Continuing Disclosure Fees 101 4181001 321 Telephone Costs 101 4181001 321.1 General Phone Costs 101 41810 01 321.2 E -Mail Server Costs 101 4181001 321.3 Web Server Costs 101 4181001 322 Postage Costs 101 4181001 329 Other Communication Costs 101 4181001 339 Other Transportation Expenses 101 4181001 351 Legal Notices Publishing 101 4181001 351.1 Costs for Public Notices 101 41810 01 351.2 Truth in Taxation Notices 101 4181001 351.3 Budget & Audit Publications 101 41810 01 439 Other Miscellaneous Charges 101 41810 01 580 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS 2001 2002 Object 2002 1998 1999 2000 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $4,913 $8,627 $12,367 $11,000 $13,000 4,000 9,000 9,034 3,925 10,109 9,600 10,000 2,500 1,200 1,200 1,100 2,200 1,800 1,737 2,689 3,488 3,100 3,500 1,100 600 800 600 400 11,355 13,558 14,079 15,000 15,000 General Office Supplies 314 95 903 500 500 City Hall Equipment Repairs 1,621 734 350 1,200 1,200 350 Yearly Fees for Program 250 600 28,357 33,466 34,093 36,000 46,000 40,000 Increased GASB Requirements 3,000 2,000 1,000 73,909 44,118 51,577 75,000 75,000 General City Legal Fees 29,077 28,942 50,062 30,300 4,500 0 Moved to Fire Dept. Budget 1,000 500 Insurance Plans 3,000 Fees Paid to Springsted (Bonds) 41,642 47,910 53,085 49,000 59,600 Monthly Billings 55,000 4,000 600 Insurance Plans 16,322 14,936 12,937 16,000 16,000 0 0 5,214 28,400 31,000 Cable JPA Payment 1,120 253 689 800 800 General Costs 3,804 4,624 2,740 5,600 5,600 3,400 All Departments 1,000 Billing from Dakota County 1,200 State Mandated Publications 23,113 115 100 0 0 1998 - Escrow Refunds 5,725 11,102 15,023 13,300 13,900 Copy Machine Leases - All Bldgs (Fax Machine &Postage Meter) $252,043 $215,094 $266,818 $294,800 $295,600 $252,043 $215,094 $266,818 $294,800 $295,600 19. Page One 2002 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT July 31, 2001 Account # Description 101 41910 101 Salaries & Benefits 101 41910 102 Full -Time Overtime 101 41910 103 Part-Time Salaries & Benefits 101 41910 103.1 Interns 101 41910 103.2 P/T Building Secretary 101 41910 103.3 Planning Commission Members 101 4191001 201 Office Accessories 101 4191001 202 Duplicating & Copying 101 41910 01 203 Printed Forms & Paper 101 4191001 205 Drafting Supplies 101 4191001 208 Miscellaneous Supplies 101 41910 01 209 Other Office Supplies 101 4191001 219 Other Operating Supplies 101 41910 01 241 Small Tools 101 41910 01 305 Medical & Dental Fees 101 4191001 312 Contract Inspection Fees 101 4191001 319 Other Professional Services 101 4191001 329 Other Communication Costs 101 4191001 331 Travel Expense 101 4191001 341 Employment Advertising 101 41910 01 391 P.C. Maintenance 101 41910 01 392 P.C. Accessories & Supplies 101 4191001 393 P.C. Hardware Purchases 101 4191001 394 P.C. Software Purchases 101 4191001 433 Dues & Subscriptions 101 4191001 433.1 APA/AICP 101 41910 01 433.2 ICBO 101 4191001 433.3 North Star 101 4191001 433.4 Lake Country 101 41910 01 433.5 IAPMO - National & State 101 4191001 433.6 Trade Magazines 101 4191001 433.7 Planner's Journal 101 4191001 433.8 Sensible Land Use Coalition 101 4191001 433.9 Secretaries Association 101 4191001 435 Books & Pamphlets 101 4191001 437 Conferences & Seminars 101 4191001 437.1 State Bldg Official School 101 4191001 437.2 Spring & Fall Code Updates 101 41910 01 437.3 ICBO Seminars (2 Times/Year) 101 4191001 437.4 Computer Training 101 41910 01 437.5 Clerical Seminars 101 4191001 437.6 Planning Seminars 101 41910 01 437.7 ISTS Training 101 4191001 437.8 State Planning Conference (2) 101 4191001 437.9 Planning Commissioner Training 101 4191001 437.10 Gen'I Seminars (Motivational) 101 4191001 437.11 Other Bldg. Inspection Training 101 4191001 439 Other Miscellaneous Charges 101 41910 01 570 Office Equipment & Furnishings PAGE TOTALS DEPARTMENT TOTALS 1998 1999 2000 Actual Actual Actual 2001 2002 Object 2002 Adopted Detail Proposed Budget Amount Budget Comments $317,010 $320,369 $354,471 $494,200 0 968 1,507 3,000 38,039 31,463 7,288 49,200 0 2,020 0 500 16 99 0 500 446 1,057 736 2,500 72 0 0 200 12 0 59 200 27 121 187 300 85 143 22 300 0 250 0 500 0 0 227 0 0 20,768 0 0 4,621 1,740 5,077 1,000 280 863 213 1,500 847 305 228 500 664 8,737 4,883 1,000 0 80 3,980 6,000 0 2,016 26 1,000 0 0 1,369 0 0 0 101 0 1,536 1,021 1,083 1,700 981 147 234 1,200 1,910 3,502 3,897 5,400 357 176 46 500 374 0 799 500 17,500 31,600 5,000 600 400 200 150 50 150 100 150 100 500 300 1,400 400 500 500 500 800 300 400 400 $595,200 3,000 54,100 400 500 2,200 100 200 300 500 400 0 0 1,000 1,500 500 1,000 6,000 1,000 0 0 1,900 All Salary Costs Inclusive of Salary, Taxes, PERA & Benefits Add Buitding Inspector Calendars, Planners, etc. Annual Codification- Zoning Ord Forms, Stickers, Tags, etc. Zipatone, Spray Mount Calculators Dictation Devices & Tapes Building Inspection Supplies Inspectors' Tools Fees for Contracted/Temp Sery Planning Consultant Cellular Phone & Pagers Maintenance of New Programs; Permitworks Tech Support Dues for AdditiDnal Inspector 900 6,000 Manuals, References, IBC Books 4 Persons @ $175 Code Enforcement Seminars 400 Contingencies 0 $367,274 $395,845 $386,431 $571,700 $677,100 $367,274 $395,845 $386,431 $571,700 $677,100 Page One 2002 BUDGET WORKSHEETS POLICE July 31, 2001 Account # Description 101 42110 101 Salaries & Benefits 101 42110 102 Full -Time Overtime 101 42110 102.1 Regular Overtime Hours 101 42110 102.2 Contracted O!T 101 42110 103 Part-Time Salaries & Benefits 101 42110 01 202 Duplicating & Copying 101 42110 01 203 Printed Forms & Paper 101 4211001 204 Envelopes & Letterheads 101 4211001 207 Training & Instructional Supplies 101 42110 01 207.1 Practice Ammunition 101 42110 01 207.2 Service Ammunition 101 42110 01 208 Miscellaneous Supplies 101 4211001 209 Other Office Supplies 101 42110 01 211 Cleaning Supplies 101 4211001 211.1 Blanket Cleaning 101 4211001 211.2 Squad Interior Cleaning 101 42110 01 217 Clothing Allowance 101 4211001 219 Other Operating Supplies 101 4211001 221 Equipment Parts 101 42110 01 241 Small Tools 101 42110 01 242 Minor Equipment 101 42110 01 304 Legal Fees 101 4211001 305 Medical & Dental Fees 101 42110 01 305.1 Miscellaneous Fees 101 4211001 305.2 Narcotic Testing 101 4211001 306 Personnel Testing & Recruitment 101 42110 01 316 Animal Care Services 101 4211001 319 Other Professional Services 101 4211001 319.1 Dispatch. Services 101 42110 01 319.2 MCD's 101 4211001 319.3 Radio Repeater Phone Lines 101 42110 01 321 Telephone Costs 101 42110 01 321.1 Cell Phones 101 4211001 321.2 Pagers 101 42110 01 321.3 LOGIS Line 101 4211001 323 Radio Units 101 4211001 331 Travel Expense 101 42110 01 331.1 MCPA Conference 101 42110 01 331.2 IACP Conference 101 4211001 331.3 Outstate Investigations & Conferences 101 4211001 331.4 Juvenile Officers Conference 101 4211001 333 Freight & Express Expenses 101 42110 01 341 Employment Advertising 101 4211001 394 P.C. Software Purchases 101 4211001 396 Computer Maintenance 101 42110 01 396.1 LOGIS Records & CAD 101 4211001 396.2 CJDN Connection Charges 101 42110 01 396.3 MCD Connection Charges 101 42110 01 396.4 MCD Maintenance Charges PAGE TOTALS 1998 Actual 1999 Actual 2000 Actual 2001 Adopted Budget 2002 Object Detail Amount 2002 Proposed Budget Comments All Salary Costs Inclusive of 1,050,757 1,069,400 1,108,455 $1,192,500 $1,361,200 Salary, Taxes, PERA & Benefits 41,699 66,280 58,601 47,000 50,000 26,000 24,000 18,051 23,161 22,000 31,700 42,400 P/T CSO's Total 60 Hrs/Wk 334 589 723 500 500 Film Developing 408 766 576 500 1,000 Evidence Logs, Animal Lic, etc. 167 108 48 200 200 2,022 3,247 1,897 2,500 2,500 2,000 500 7,570 4,007 6,464 0 0 Donated & Forfeited Funds 1,144 1,620 1,289 2,000 2,000 Video & Audio Tapes 434 31 288 400 400 100 300 0 0 4,426 3,000 3,000 CSO /Reserve /Chaplain Uniforms 1,025 2,613 927 1,000 1,000 Evidence Bags, 1st Aid, Drug Kits 2,531 691 2,595 2,500 2,500 Squad Emergency Equip Repairs 0 339 1,253 1,500 1,500 Crime Scene Kit Supplies 0 0 0 1,500 1,500 Entry Tool, <Than Lethal Equip 54,996 54,996 54,996 56,000 56,000 Prosecution 567 1,334 849 1,000 1,000 500 500 0 2,657 300 4,500 4,500 Career /Recruiting Fairs; Hiring 0 13,293 16,097 14,000 14,000 Impound & Care Fees 50,296 55,344 63,678 57,500 61,000 58,000 0 Moved to (396) Below 3,000 4,019 8,784 13,085 14,500 6,000 4,900 600 500 2,903 1,903 2,303 3,000 3,000 Radio & Radar Repairs 1,230 2,252 2,556 2,000 3,000 500 1,500 700 300 65 95 7 200 200 Repairs 0 676 779 1,000 1,000 Officer Hiring 0 0 0 1,200 1,200 Criminal Justice Integration Proj. 14,779 17,711 30,169 40,000 49,000 34,500 2,500 3,000 9,000 1,254,996 1 1,394,362 1,481,700 1,669,600 Moved from (319) Above Page Two 2002 BUDGET WORKSHEETS POLICE July 31, 2001 Account # Description 101 4211001 409 Other Contracted Repair & Maint 101 4211001 415 Other Equipment Rental 101 4211001 433 Dues & Subscriptions 101 42110 01 433.1 Mutual Aid Assistance Group 101 42110 01 433.2 IACP Chiefs Dues 101 4211001 433.3 MN Chiefs of Police Dues 101 4211001 433.4 Dakota Cty Chiefs of Police 101 4211001 433.5 Wakota CAER Dues 101 4211001 433.6 Metro Emergency Managers 101 4211001 433.7 MN Sex Crimes Investigators 101 4211001 433.8 Tri- County Investigators 101 42110 01 433.9 Miscellaneous 101 42110 01 433.10 P.O.S.T. Licenses 101 42110 01 435 Books & Pamphlets 101 4211001 436 Towing Charges 101 4211001 437 Conferences & Seminars 101 4211001 437.1 DCTC Contracted Training 101 4211001 437.2 Firearms Training 101 4211001 437.3 Chiefs Spring Training 101 4211001 437.4 Chiefs Fall Conference 101 4211001 437.5 IACP Conference 101 4211001 437.6 Emergency Management 101 4211001 437.7 Miscellaneous 101 4211001 439 Other Miscellaneous Charges 101 4211001 580 Other Equipment Purchases PAGE TOTALS DEPARTMENT TOTALS JA. 2001 2002 Object 2002 1998 1999 2000 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments 2,571 0 0 0 0 15,615 0 0 500 500 1,363 453 2,118 1,600 2,000 800 100 150 50 20 25 30 50 375 400 475 53 184 300 300 Statutes, Crime Prevention 569 (31) 218 200 200 8,404 8,692 10,200 10,000 12,000 4,800 15 Officers @ $300 Each 1,500 500 200 400 400 4,200 0 569 50 500 500 Food & Beverages - Meetings 0 329 430 600 600 Copies /Fax ------------------------------------------ $28,997 $10,066 $13,200 $13,700 $16,100 $1,283,993 $1,341,963 $1,407,562 $1,495,400 $1,685,700 JA. Page One 2002 BUDGET WORKSHEETS FIRE July 31, 2001 2001 2002 Object 2002 1998 1999 2000 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 42210 103 Salaries & Benefits $99,117 $104,666 $123,789 $136,600 $190,000 Salary, Taxes, PERA & Benefits 101 42210 103.1 Salaries 18,100 Reduced - Balance to Pension 101 42210 103.2 Training Pay /Stipends 2,000 Reduced - Balance to Pension 101 42210 103.3 Call Pay /Stipends 9,750 Reduced - Balance to Pension 101 42210 103.4 Class Pay /Stipends 150 Reduced - Balance to Pension 101 42210 103.5 Fire Relief Pension Contributions 135,000 $28,000 from Gen'I Govt; Bal New 101 42210 103.6 P/T Fire Marshal 25,000 101 42210 01 202 Duplicating & Copying 66 136 132 100 100 101 42210 01 202.1 Copy Toner 25 101 4221001 202.2 Laser Printer 25 101 42210 01 202.3 Fax Machine 50 101 42210 01 204 Envelopes & Letterhead 39 108 103 100 100 101 42210 01 204.1 Envelopes 25 101 42210 01 204.2 Letterhead 25 101 42210 01 204.3 Forms 50 101 4221001 208 Miscellaneous Supplies 1,951 2,281 3,367 3,400 4,500 Supplies for Fire Marshal 1014221001 208.1 Camera 1,300 101 42210 01 208.2 Film Developing 100 101 42210 01 208.3 Memberships 300 101 42210 01 208.4 Code Books 500 101 42210 01 208.5 Portable Data Terminal 600 101 42210 01 208.6 Training 700 101 42210 01 208.7 Office Equipment 1,000 101 4221001 211 Cleaning Supplies 197 80 156 200 300 101 42210 01 211.1 Soap 100 101 4221001 211.2 Chamois, Towels, etc. 100 101 4221001 211.3 Sponges, etc. 25 101 42210 01 211.4 SCBA Cleaner 75 101 42210 01 218 Fire Department Clothing 733 123 493 300 300 5 Uniforms @ $60 Each 101 42210 01 219 Other Operating Supplies 625 564 521 800 1,0 Medical Supplies 101 42210 01 219.1 Gloves 200 101 42210 01 219.2 Bandages 80 101 42210 01 219.3 Equipment 100 101 4221001 219.4 Tyvek Suits 70 101 4221001 219.5 Consummable Medical 400 101 42210 01 219.6 Oxygen 150 101 4221001 229 Other Maintenance Supplies 8,461 12,351 4,178 5,100 2,900 101 42210 01 229.1 Aerial- Pumpers- Tanker 2,300 101 4221001 229.2 Pickup Trucks 200 101 4221001 229.3 Rescue & Other 200 101 42210 01 229.4 Vehicle Modifications 200 101 4221001 230 Equipment Repair Materials 1,468 1,441 634 1,500 1,500 101 4221001 230.1 Light Bars 100 101 42210 01 230.2 Smoke Machines 150 101 4221001 230.3 Lanterns 150 101 42210 01 2304 Small Tool Repairs 500 101 42210 01 230.5 Opticom 300 101 4221001 230.6 Station 300 101 42210 01 241 Small Tools 522 834 439 700 700 101 42210 01 241.1 Axes, Bars & Other 150 101 42210 01 241.2 Grass Fire 250 101 4221001 241.3 Miscellaneous 300 101 42210 01 305 Medical & Dental Fees 2,890 1,930 1,995 1,800 2,600 Ann Medical Tests(30 @ $55 -85) 101 42210 01 306 Personnel Testing & Recruitment 740 467 1,786 2,600 2,100 101 4221001 306.1 New Physicals (4) 1,000 101 4221001 306.2 Hepatitis Shots (4) 500 101 4221001 306.3 Background Checks (4) 100 101 4221001 306.4 Drug Testing (4) 500 101 4221001 308 Instructors' Fees 9,272 6,632 4,784 8,300 10,800 101 4221001 308.1 Fire Fighter 1 (4) 1,200 101 42210 01 308.2 Fire Fighter 1 Certificates (4) 140 101 42210 01 308.3 Fire Fighter Re- Certificates (16) 160 101 4221001 308.4 First Responder (4) 1,000 101 4221001 308.5 First Responder Refresher (1/2) 1,400 101 42210 01 308.6 Outside Schools ($/2) 5,830 101 42210 01 308.7 Haz -Mat Training (4) 1,000 101 4221001 308.8 Apparatus Re- Certify (7) 70 PAGE TOTALS 126,081 131,612 142,379 161,500 216,900 ,�3. Page Two 2002 BUDGET WORKSHEETS FIRE July 31, 2001 2000 2001 Object 2001 1998 1999 2000 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments 101 4221001 310 Testing Services 869 1,778 1,391 1,100 900 101 42210 01 310.1 Aerial (Next 2003) 0 101 4221001 310.2 Ladders (Next 2003) 0 101 4221001 310.3 Pumpers (3) (Next 2004) 900 101 42210 01 310.4 SCBA Hydro Testing (Next 2003) 0 1014221001 313 Temporary Service Fees 981 1,065 838 1,400 1,400 101 42210 01 313.1 SCBA Contract 400 101 4221001 313.2 SCBA Maintenance 200 101 4221001 313.3 Copier Contract 400 101 4221001 313.4 Security Contract 400 101 4221001 319 Other Professional Services 1,950 1,712 1,870 1,900 2,300 Fire Prevention Education 101 4221001 319.1 School Literature 350 101 42210 01 319.2 Door Prizes 250 101 42210 01 319.3 Fire Prevention Week Promos 1,100 101 42210 01 319.4 Food at Open House 150 101 4221001 319.5 Adult Extension Classes 250 101 4221001 319.6 Trading Cards 200 101 4221001 321 Telephone Costs 214 225 276 300 300 101 42210 01 321.1 Chief 40 101 4221001 321.2 Assistant Chief 40 101 4221001 321.3 Rescue 70 101 42210 01 321.4 Numeric Pagers 150 101 4221001 322 Postage Costs 104 0 10 100 100 UPS Costs 101 4221001 329 Other Communication Costs 1,078 391 820 1,000 1,000 101 4221001 329.1 Base Repairs 200 101 4221001 329.2 Pager Repairs 200 101 4221001 329.3 Hand Held Repairs 300 101 42210 01 329.4 Mobile Repairs 300 101 4221001 331 Travel Expense 3,313 2,115 3,942 5,500 7,800 101 4221001 331.1 Minnesota Chiefs Conference 1,100 101 4221001 331.2 Fire Department Association 900 101 4221001 331.3 Outside Schools 5,800 101 4221001 433 Dues & Subscriptions 525 541 475 700 700 101 4221001 433.1 Capital City 35 101 42210 01 433.2 VFBA Insurance 160 101 4221001 433.3 State Fire 120 101 4221001 433.4 State Chiefs 100 101 4221001 433.5 DCFC 30 101 4221001 433.6 WAKOTA Mutual Aid 20 101 4221001 433.7 Purchasing Consortium 35 101 4221001 433.8 NFPA 100 101 4221001 433.9 MN Ass'n Fire Marshals 100 Fire Marshal Dues 101 4221001 437 Conferences & Seminars 530 270 405 700 700 101 4221001 437.1 State Fire Conference 400 101 42210 01 437.2 State Chiefs Conference 300 101 42210 01 439 Other Miscellaneous Charges 1,097 706 759 1,200 1,200 101 4221001 439.1 Food & Coffee 190 101 4221001 439.2 Extinguisher 400 101 42210 01 439.3 Plaques 20 101 4221001 439.4 Paint 50 101 4221001 439.5 Station Needs 540 101 4221001 580 Other Equipment Purchases 16,012 12,358 18,312 17,000 17,000 101 4221001 580.1 Bunker Gear (9) 9,000 101 42210 01 580.2 Pagers (6) 3,000 101 42210 01 580.3 Hose Replacement 2,000 101 42210 01 580.4 Replace as Damaged Items 1,000 101 4221001 580.5 Fan, Chain Saw, Rescue Dummy 2,000 101 42210 01 581 Other Equipment Purchases 5,906 1,709 0 0 0 1998 - Sign Outside Station PAGE TOTALS $32,578 $22,871 $29,098 $30,900 $33,400 DEPARTMENT TOTALS $158,659 $154,482 $171,477 $192,400 $250,300 Page One 2002 BUDGET WORKSHEETS GOVERNMENT BUILDINGS July 31, 2001 Account # Description 101 41940 101 Salaries & Benefits 101 4194077 101 Administrative 101 4194079 101 Maintenance 101 41940 102 Full -Time Overtime 101 4194001 208 Miscellaneous Supplies 101 4194001 223 Building Repair Supplies 101 4194001 225 Landscaping Materials 101 4194001 241 Small Tools 101 4194001 242 Minor Equipment 101 4194001 302 Architects' Fees 101 4194001 319 Other Professional Services 101 4194001 319.1 Elevator Maintenance 101 4194001 319.2 Heating /Cooling Maint Contract 101 41940 01 319.3 Annual RPZ Inspection 101 4194001 319.4 Pest Control 101 4194001 319.5 Fire Extinguishers 101 4194001 319.6 Fire Suppression System Check 101 4194001 319.7 Janitorial Service -New Fire Station 101 4194001 319.8 Janitorial Service -P.W. Building 101 4194001 381 Electric Utilities 101 4194001 383 Gas Utilities 101 4194001 384 Refuse Disposal 101 4194001 384.1 General Buildings & Parks 101 4194001 384.2 Recycling /Cleanup 101 4194001 389 Other Utility Services 101 4194001 401 Contracted Building Repairs 101 4194001 401.1 MNDot Garage Exterior Repairs 101 4194001 401.2 City Hall HVAC 101 4194001 401.3 Electrical Repairs 101 4194001 401.4 Miscellaneous Siren Repairs 101 4194001 401.5 Miscellaneous Repairs 101 4194001 412 Building Rental 101 4194001 415 Other Equipment Rental 101 4194001 439 Other Miscellaneous Charges 101 4194001 601 Bond Principal 101 4194001 611 Bond Interest 101 4194001 621 Bond Paying Agent Fees PAGE TOTALS DEPARTMENT TOTALS 1998 Actual 1999 Actual 2000 Actual 2001 Adopted Budget 2002 Object Detail Amount 2002 Proposed Budget Comments All Salary Costs Inclusive of $41,982 $45,268 $37,215 $48,900 $50,600 Salary, Taxes, PERA & Benefits 5,100 45,500 3,671 2,523 3,794 3,000 3,000 13,542 16,084 13,691 15,500 15,500 Cleaning Supplies, Towels, etc. 656 3,164 704 4,000 4,000 0 0 0 500 500 Trees & Shrubs 0 0 455 200 200 Hand Tools, Bits, Blades, etc. 0 0 0 2,000 2,000 Carpet Cleaner Replacement 0 572 0 1,000 1,000 Estimates 17,072 20,650 24,452 18,800 18,800 1,000 2,500 1,500 500 1.000 1,000 3,500 7,800 32,233 32,680 34,758 34,000 40,000 10,544 16,333 28,708 24,000 40,000 15,278 15,135 16,245 28,000 28,000 18,000 10,000 2,847 2,613 3,122 3,000 3,000 Floor Mats - Monthly Charges 26,832 30,768 9,676 12,000 14,000 7,000 2,000 1,500 1,500 2,000 12,000 6,000 202 0 0 U of M Storage (To CIP) 107 0 0 1,000 1,000 Scaffolding, Cleaners 0 188 2,328 1,000 1,000 Contingencies 24,210 26,632 26,632 29,100 31,500 MSABC Payment (2/1) 65,035 63,666 62,167 60,600 58,800 MSABC Payments (2/1 & 8/1) 0 0 0 100 0 $266,009 ---- -- $282,277 - - -- $264,148 $286,700 --------------- -- $312,900 $266,009 $282,277 $264,148 $286,700 $312,900 Cs Page One 2002 BUDGET WORKSHEETS FLEET MAINTENANCE July 31, 2001 Account # Description 101 43100 101 Salaries & Benefits 101 4310077 101 Administrative 101 4310079 101 Maintenance 101 43100 102 Full -Time Overtime 101 4310099 103 Part-Time Salaries & Benefits 101 4310001 211 Cleaning Supplies 101 4310001 212 Motor Fuels 101 4310001 213 Lubricants & Additives 101 4310001 215 Shop Materials 101 4310001 221 Equipment Parts 101 4310001 222 Tires 101 4310001 241 Small Tools 101 4310001 242 Minor Equipment 101 4310001 321 Telephone Costs 101 4310001 323 Radio Units 101 4310001 331 Travel Expense 101 4310001 341 Employment Advertising 101 4310001 384 Refuse Disposal 101 4310001 394 P.S. Software Purchases 101 4310001 404 Contracted Mach & Equip Repairs 101 4310001 416 Machinery Rental 101 4310001 417 Uniforms Rental 101 4310001 433 Dues & Subscriptions 101 4310001 435 Books & Pamphlets 101 4310001 437 Conferences & Seminars 517 PAGE TOTALS 500 DEPARTMENT TOTALS 1998 Actual 1999 Actual 2000 Actual 2001 Adopted Budget 2002 Object Detail Amount 2002 Proposed Budget Comments All Salary Costs Inclusive of $110,067 $116,201 $122,333 $131,200 $137,800 Salary, Taxes, PERA & Benefits 27,200 110,600 4,324 7,993 9,958 7,000 8,000 0 0 0 4,000 4,000 550 517 565 500 500 Shop & Vehicles 41,275 41,171 69,424 60,000 75,000 2,949 7,464 2,804 5,500 5,500 8,265 15,201 18,618 10,500 20,500 73,791 87,245 82,588 80,000 85,000 10,061 19,293 5,707 15,000 15,000 1,707 4,364 4,565 4,000 4,000 3,539 14,254 487 4,000 4,000 321 1,019 304 0 0 175 1,612 1,079 2,000 2,000 Repair /Replace Units 0 5 0 500 500 Overnight Training 0 333 0 0 0 51 417 1,036 1,000 1,000 Shop Hazardous Waste 0 485 1,173 500 500 General Software Support 26.578 22,428 32,493 30,000 30,000 0 125 0 1,000 1,000 78 83 112 0 0 88 0 0 0 0 352 619 0 200 200 180 - - --- - 523 - -- -- 1,640 1,000 1,000 $284,352 $341,352. ---------------------------------------------- $354,888 $357,900 $395,500 $284,352 $341,352 $354,888 $357,900 $395,500 41.�/ Page One 2002 BUDGET WORKSHEETS STREET MAINTENANCE July 31, 2001 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 R/W Permit & Inspection Forms 101 43121 01 203.2 Work Orders 101 43121 01 205 Drafting Supplies 101 43121 01 205.1 Paper for Plan Reproductions 101 43121 01 205.2 Off -Site Reproductions 101 43121 01 205.3 Film & Developing 101 43121 01 205.4 Miscellaneous Tools 101 43121 01 209 Other Office Supplies 101 43121 01 216 Chemical & Chemical Products 101 43121 01 224 Street Maintenance Materials 101 43121 01 224.1 Paint 101 43121 01 224.2 Mail Boxes 101 43121 01 224.3 Light Bulbs/Lenses 101 43121 01 225 Landscaping Materials 101 43121 01 225.1 Sod 101 43121 01 225.2 Seed 101 43121 01 225.3 Black Dirt 101 43121 01 225.4 Trees 101 43121 01 226 Sign Repair Materials 101 43121 01 231 Bituminous Patching Materials 101 43121 01 232 Crushed Rock 101 4312101 233 Dust Control Materials 101 43121 01 234 De -Icing Sand 101 43121 01 235 Shouldering Gravel 101 43121 01 241 Small Tools 101 43121 01 242 Minor Equipment 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 319 Other Professional Services 101 43121 01 321 Telephone Costs 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 State One -Call 101 43121 01 391.2 State Aid 101 43121 01 391.3 Pavement Plus S/W Support 101 43121 01 392 P.C. Accessories & Supplies 101 43121 01 394 P.S. Software Purchases PAGE TOTALS 1998 Actual 1999 Actual 2000 Actual 2001 Adopted Budget 2002 Object Detail Amount 2002 Proposed Budget Comments All Salary Costs Inclusive of $297,483 $304,024 $313,463 $377,100 $425,200 Salary, Taxes, PERA & Benefits 90,000 62,400 272,800 10,375 10,772 17,614 15,000 18,000 Maintenance 26,513 22,903 19,106 19,000 20,000 16 0 0 700 700 27 28 60 700 700 500 200 1,806 1,386 850 1,600 1,600 800 350 100 350 Inspection Equipment 7 20 31 200 200 Door Tags 11,313 18,576 19,114 25,000 25,000 De -Icing Chemicals (Salt) 71,164 62,592 1,173 1,500 1,500 500 500 500 824 3,003 2,664 6,300 6,300 3,000 300 2,000 1,000 337 139 2,656 5,000 5,000 0 0 22,907 15,000 25,000 0 0 16,991 18,000 18,000 0 0 19,006 20,000 22,000 0 0 7,380 5,000 8,000 0 0 313 3,000 3,000 729 667 834 1,000 1,000 Shovels, Brooms, etc. 3,519 5,629 3,214 2,700 4,000 Safety Equipment 3,309 3,517 17,909 18,500 8,500 General Non - Project Related 246 20 2,701 2,000 2,000 Appeals of Closed Projects 0 380 188 600 600 Employment Physicals 58 334 75 1,200 1,200 700 670 556 1,500 1,500 Random Drug Testing 641 279 1,882 1,200 2,000 Cellular Phones & Pagers 24 0 0 100 100 22 339 185 1,000 1,000 APWA & Miscellaneous 901 2,375 5,900 1,000 1,000 73,365 76,423 87,263 75,000 90,000 71,000 4,000 361 306 867 2,600 2,600 1,000 1,000 600 4,011 6,279 7,973 3,700 5,700 2,200 1,000 2,500 0 0 0 300 0 591 0 -------------------------------------- 4,089 600 600 General Software Support 508,341 520,659 576,963 626,100 702,000 ,X q7- Page Two 2001 BUDGET WORKSHEETS STREET MAINTENANCE July 31, 2001 Account # Description 101 43121 01 402 Street Seal Coating 101 43121 01 402.1 General Seal Coating 101 43121 01 402.2 Community Center Parking Lot 101 43121 01 403 Contracted Repair & Maintenance 101 43121 01 403.1 Street Lights 101 43121 01 403.2 Signal Lights 101 43121 01 403.3 Light Replacements 101 43121 01 405 Street Striping 101 43121 01 406 Street Sweeping 101 43121 01 407 Bituminous Overlays 101 43121 01 408 Street Crack Sealing 101 43121 01 409 Tree Trimming 101 43121 01 410 Concrete Sidewalk/Curb Repairs 101 43121 01 411 Snow Removal- Community Center 101 43121 01 415 Grader /Dozer Rental 101 43121 01 416 Snow Plow Loader Rental 101 43121 01 418 Snow Plow Rental 101 43121 01 420 Truck Rentals 101 43121 01 433 Dues & Subscriptions 101 43121 01 433.1 American Public Works Ass'n 101 43121 01 433.2 Request for Mutual Aid Ass'n 101 43121 01 433.3 City Engineers' Association 101 43121 01 433.4 Professional Secretaries 101 43121 01 433.5 MN Society for Professional Engine 101 43121 01 433.6 American Society of Civil Engineers 101 43121 01 435 Books & Pamphlets 101 43121 01 435.1 MUTCD 101 43121 01 435.1 MN Dot Updates 101 43121 01 437 Conferences & Seminars 101 43121 01 437,1 APWA 101 43121 01 437.2 Computer Training 101 43121 01 437.3 Clerical 101 43121 01 437.4 Gravel Road Maintenance 101 43121 01 437.5 City Management Training 101 43121 01 437.6 CEAM 101 43121 01 437.7 MN Pavement Management 101 43121 01 437.8 MN Dot 101 43121 01 437.9 Miscellaneous Training 101 43121 01 439 Other Miscellaneous Charges 101 43121 01 570 Office Equipment & Furnishings PAGE TOTALS DEPARTMENT TOTALS 1998 1 1999 2 2000 A 2000 2 2001 Object 2 2001 Comments 0 0 0 3 31,577 3 30,000 6 60,000 50,000 10,000 71,353 1 145,260 2 2,487 7 7,000 7 7,000 6,000 500 500 0 0 0 1 15,941 1 19,000 1 19,000 0 0 0 3 3,752 6 6,500 6 6,500 0 0 0 1 16,338 4 45,000 2 25,000 A Annual Bike Trail Overlays 0 0 0 9 9,843 1 10,000 2 20,000 0 4 489 1 10,546 5 5,000 1 10,000 0 0 0 3 3,585 5 5,000 5 5,000 0 7 780 1 11,452 6 6,000 1 12,000 0 0 0 0 0 2 2,000 2 2,000 0 1 18,391 7 7,840 1 13,000 1 13,000 0 0 0 0 0 2 2,000 2 2,000 0 0 0 3 3,691 2 2,000 2 2,000 385 6 604 6 670 9 900 9 900 225 ( (APWA) 10 ( (RMAA) 150 90 00• Page One 2002 BUDGET WORKSHEETS PARKS & GROUNDS MAINTENANCE July 31, 2001 Account # Description 101 45202 101 Salaries & Benefits 101 4520277 101 Administrative 101 4520279 101 Maintenance 101 45202 102 Full -Time Overtime 101 4520299 103 Part-Time Salaries & Benefits 101 4520201 205 Drafting Supplies 101 45202 01 216 Chemical & Chemical Products 101 4520201 216.1 Herbicides(General Park Use) 101 4520201 216.2 Fertilizer 101 4520201 219 Other Operating Supplies 101 4520201 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 Repair(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 4520201 223.2 Shingles, Boards, etc. 101 4520201 223.3 Miscellaneous 101 4520201 223.4 Shelter /Shed Repairs 101 4520201 225 Landscaping Materials 101 4520201 225.1 Trees, Shrubs, Sod, etc. 101 4520201 225.2 Timbers, Fence, etc. 101 4520201 226 Sign Repair Materials 101 4520201 229 Other Maintenance Supplies 101 4520201 241 Small Tools 101 4520201 242 Minor Equipment 101 4520201 303 Engineering Fees 101 4520201 321 Telephone Costs 101 4520201 323 Radio Units 101 4520201 331 Travel Expense 101 4520201 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 4520201 403.1 Irrigation Repairs 101 4520201 403.2 Electrical Repairs 101 4520201 403.3 Miscellaneous Repairs 101 4520201 409 Other Contracted Repair & Maint 101 4520201 416 Machinery Rental 101 45202 01 416.1 Mower Leases 101 4520201 4161 Miscellaneous Rentals 101 4520201 433 Dues & Subscriptions 101 4520201 433.1 Memberships - MRPA 101 4520201 433.2 Miscellaneous Dues 101 4520201 435 Books & Pamphlets 101 4520201 437 Conferences & Seminars 101 4520201 437.1 Seminars & Workshops 101 4520201 437.2 School & Tuition 101 4520201 439 Other Miscellaneous Charges PAGE TOTALS DEPARTMENT TOTALS 1998 Actual 1999 Actual 2000 Actual 2001 Adopted Budget 2002 Object Detail Amount 2002 Proposed Budget Comments All Salary Costs Inclusive of $206,398 $197,224 $223,002 $254,700 $291,700 Salary, Taxes, PERA & Benefits 22,200 269,500 9,033 10,780 12,842 15,000 15,000 17,234 25,410 21,556 24,000 24,000 0 0 0 100 100 6,453 10,488 9,283 5,000 10,000 5,000 5,000 4,814 10,173 5,051 7,000 7,000 2,000 5,000 11,789 4,547 7,817 5,000 8,000 2,000 1,000 3,000 2,000 4,520 6,375 5,244 5,000 7,000 1,500 2,000 1,500 Calk, Hardware, etc. 2,000 1,670 5,408 674 3,600 3,600 1,600 2,000 0 0 0 500 500 3,134 4,222 2,603 3,000 4,000 Paint, Chalk, Bases, Field Dry, etc. 2,751 4,849 2,672 2,000 2,500 Hand Tools, Blades, Bits, etc. 0 3,269 0 2,500 2,500 Safety Equipment 1,096 0 0 0 0 0 0 107 500 500 Cellular Phone Bills 0 0 0 500 500 Walkie- Talkies 0 0 4 100 100 Seminars & Workshops 11,287 10,564 11,842 13,000 15,000 6,000 6,000 3,000 1,210 1,155 1,701 0 3,000 3,551 15,052 3,903 4,000 4,000 1,500 1,500 1,000 0 0 4,665 8,000 8,000 Chemical Lawn Services 13,370 14,869 8,898 13,000 15,000 14,000 1,000 150 35 150 200 200 100 100 129 0 0 100 100 445 593 2,062 500 500 300 200 0 0 0 200 200 Contingencies $299,036 --- - - -- -- $325,014 ---------------- $324,076 $367,500 -- - -- - -- - - - - --- $423,000 $299,036 $325,014 $324,076 $367,500 $423,000 a9. Page One July 31, 2001 Account # 2002 BUDGET WORKSHEETS PARKS & RECREATION Description 1998 Actual 1999 Actual 2000 Actual 2001 Adopted Budget 2002 Object Detail Amount 2002 Proposed Budget Comments All Salary Costs Inclusive of 101 45100 101 Salaries & Benefits $276,010 $280,334 $321,900 $360,100 $426,800 Salary, Taxes, PERA & Benefits 101 45100 102 Full -Time Overtime 1,534 2,117 2,129 4,700 4,700 101 45100 103 Part-Time Salaries & Benefits 107,075 103,625 102,223 126,500 138,800 101 4510008 103 Pff Secretary 27,800 101 4510010 103 P/T Receptionist 26,500 101 4510012 103 Building Attendants 57,000 101 45100 83 103 Playground Recreation Leaders 16,500 101 45100 94 103 Warming House Attendants 8,500 101 45100 99 103 Park & Rec Committee 2,500 101 45100 01 205 Drafting Supplies 872 437 507 1,000 1,000 Film, Developing & Laminating 101 4510001 207 Training & Instructional Supplies 0 0 0 200 200 Books, Tapes, etc. 101 45100 01 208 Miscellaneous Supplies 582 730 517 500 500 Meeting Supplies 101 4510001 209 Other Office Supplies 1,192 909 764 1,000 1,000 Envelopes, Forms, Rulers, etc. 101 4510001 211 Cleaning Supplies 3,472 4,341 5,402 4,500 5,500 101 45100 01 216 Chemicals & Chemical Products 838 1,765 1,109 1,200 1,200 101 4510001 219 Other Operating Supplies 2,277 2,030 3,585 3,500 3,500 Rec Programs, 1 st Aid Sup, etc. 101 4510001 221 Equipment Parts 2,646 3,710 4,955 5,500 5,500 101 45100 01 223 Building Repair Supplies 2,687 4,433 5,829 5,500 5,500 101 4510001 229 Other Maintenance Supplies 1,281 1,312 1,488 0 0 101 45100 01 305 Medical & Dental Fees 292 0 415 800 800 Employment Physicals 101 4510001 312 Contract Inspection Fees 0 0 9,622 4,500 5,600 Custodial Services- Banquet Rm 1014510001 315 Special Programs 5,651 5,121 5,007 6,500 9,900 101 4510001 315.1 Sunday Night Specials 2,500 Performances 101 45100 01 315.2 Leprechaun Days 200 Trophies & Awards 101 4510001 315.3 Halloween 1,000 Supplies 101 45100 01 315.4 Ground Pounders(Running) 400 Ribbons & Mailings 101 4510001 315.5 Nature Programs(Arbor Day, etc.) 2,000 Trees 101 4510001 315.6 Puppet Programs 500 Tapes, Fuses, Puppets, etc. 101 4510001 315.7 Special Events 1,000 Publicity & Supplies 101 45100 01 315.8 Adopt -A -Park Program 1,400 Flyers, Trees, Signs 101 4510001 315.9 Miscellaneous Programs 500 Start Up Costs 101 45100 01 315.10 ADA Programs 400 ADA Program Supplies 101 4510001 319 Other Professional Services 2,458 8,153 435 500 500 ADA Services 101 45100 01 321 Telephone Costs 1,255 1,403 1,690 1,600 3,100 Pagers & Cellular Phones 101 45100 01 331 Travel Expense 413 390 0 200 500 101 45100 01 341 Employment Advertising 2,369 4,227 1,969 2,800 2,800 General Employment Ads 101 4510001 349 Other Advertising 16,284 13,531 15,906 22,300 22,300 101 4510001 349.1 Brochures 16,500 City Newsletter 101 45100 01 349.2 Yellow Pages 3,400 Rec Ads 101 4510001 349.3 Special Marketing 2,400 New Program Flyers 101 4510001 381 Electric Utilities 15,204 14,878 15,456 20,000 26,000 101 45100 01 383 Gas Utilities 11,511 12,850 24,326 13,000 28,600 101 45100 01 384 Refuse Disposal 4,063 3,988 3,981 4,000 4,000 101 45100 01 401 Contracted Building Repairs 6,142 5,485 9,834 6,000 6,000 101 45100 01 404 Contracted Mach & Equip Repairs 4,437 5,377 6,795 5,000 5,000 101 4510001 409 Other Contracted Repair & Maint 0 0 16,713 17,000 17,000 Air Handler Maintenance Contract 101 4510001 412 Building Rental 17,000 13,200 16,800 16,800 16,800 Monthly Rent Payments to Guard 101 4510001 415 Other Equipment Rental 12,254 10,234 12,155 12,300 15,000 Portable Toilets & Other Rentals 101 45100 01 433 Dues & Subscriptions 964 1,194 1,005 1,200 1,200 101 45100 01 433.1 MRPA Dues 800 Minn Recreation & Parks Ass'n 101 45100 01 433.2 Miscellaneous 400 Paper, Magazines, JC Dues, etc. 101 4510001 435 Books & Pamphlets 0 144 0 100 100 101 45100 01 437 Conferences & Seminars 1,548 1,694 1,310 2,000 3,500 101 4510001 437.1 MRPA State Conference 1,500 101 45100 01 437.2 MIAMA State Conference 300 101 4510001 437.3 Workshops, Schools, & Tuition 1,700 101 45100 01 439 Other Miscellaneous Charges 20,984 37,405 12,884 0 0 Donation Account 101 4510001 580 Other Equipment Purchases 562 0 0 0 0 PAGE TOTALS $523,854 $545,017 $606,712 $650,800 $762,900 General Operating DEPARTMENT TOTALS $523,854 $545,017 $606,712 $650,800 $762,900 �Q . Page Two 13/ 2002 BUDGET WORKSHEETS PARKS & RECREATION July 31, 2001 2001 2002 Object 2002 1998 1999 2000 Adopted Detail Proposed Account # Description Actual Actual Actual Budget Amount Budget Comments $91,600 ----- - - - - -- _ 101 4510081 Softball $33,718 $42,109 $36,241 $37,500 $37,500 101 4510082 Volleyball 6,405 5,327 4,566 9,400 9,400 1014510084 Tennis 738 930 834 1,300 1,300 101 4510085 Tiny Tots 13,527 16,559 21,021 16,000 16,600 101 4510086 Pom Poms 2,661 2,044 1,604 2,500 2,500 101 4510087 Field Trips 2,757 3,131 2,327 2,200 2,800 101 4510088 Broomball 2,093 1,055 585 0 0 101 4510089 Skating Lessons 405 169 356 800 800 101 4510090 Fun Runs, Walks & Bike Rides 1,966 1,794 1,717 1,000 1,000 101 45100 91 Summer Camps 0 0 0 3,000 3,000 101 4510092 Adult Basketball 767 0 595 700 700 101 4510093 Other Programs 7,375 5,984 9,841 2,800 3,500 101 4510095 T -Ball 0 0 0 3,200 3,200 101 4510096 Teen Night 4,107 4,026 4,729 4,400 4,600 101 4510098 Pistol Range 0 0 0 4,700 4,700 76,521 -- 83,128 84,416 ------------------------------ 89,500 91,600 101 4510081 103 Part-Time Salaries 15,973 21,190 20,422 24,300 24,300 101 4510081 219 Operating Supplies 9,813 13,478 7,294 11,000 11,000 101 4510081 311 Officiating Fees 5,098 3,842 5,615 0 0 101 4510081 319 Other Professional Services 2,834 3,600 2,909 2,200 2,200 101 4510082 103 Part-Time Salaries 479 429 948 1,000 1,000 101 4510082 219 Operating Supplies 1,724 664 926 1,500 1,500 101 4510082 311 Officiating Fees 4,005 3.836 2,420 6,000 6,000 101 4510082 319 Other Professional Services 198 399 273 900 900 101 4510084 103 Part-Time Salaries 608 755 789 1,150 1,150 101 4510084 219 Operating Supplies 131 175 45 150 150 101 4510085 103 Part-Time Salaries 12,539 15,834 19,560 15,000 15,600 101 4510085 219 Operating Supplies 988 630 1,462- 1,000 1,000 101 4510086 103 Part-Time Salaries 1,984 1,408 1,189 2,000 2,000 101 4510086 219 Operating Supplies 678 636 415 500 500 101 4510087 219 Operating Supplies 1,100 2,879 2,089 2,200 2,800 101 4510088 219 Operating Supplies 72 132 0 0 0 101 4510088 311 Officiating Fees 2,021 923 585 0 0 101 4510089 103 Part-Time Salaries 405 169 356 740 740 101 4510089 219 Operating Supplies 0 0 0 60 60 101 4510090 219 Operating Supplies 1,966 1,794 1,717 1,000 1,000 101 4510091 103 Part-Time Salaries 0 0 0 1,000 1,000 101 4510091 219 Operating Supplies 0 0 0 2,000 2,000 101 4510092 219 Operating Supplies 767 0 595 700 700 101 4510093 103 Part -Time Salaries 1,901 1,023 1,661 0 0 1014510093 219 Operating Supplies 5,474 4,961 8,180 2,800 3,500 101 4510095 103 Part-Time Salaries 0 0 0 2,200 2,200 101 4510095 219 Operating Supplies 0 0 0 1,000 1,000 101 4510096 219 Operating Supplies 4,107 4,026 4,729 4,400 4,600 101 4510098 103 Part-Time Salaries 0 0 0 2,700 2,700 101 4510098 219 Operating Supplies 0 0 0 2,000 2,000 SPECIAL PROGRAM TOTALS 74,863 - - - 82,781 - - - -- 84,178 -------------------------- 89,500 91,600 GRAND TOTAL - PARK & REC $598,717 $627,797 $690,890 $740,300 $854,500 13/ ci M Total Levy - Year 2002 1,000,100 (1) Other funding for the Commercial Streetscape - Phase 3 is coming from a MN /DOT contribution to the project, other assessment and core funds(undetermined in amounts at this time) and from a Port Authority debt issue. (2) Other funding for Police Squad Cars is from the DUI Forfeiture Fund to pay for the radars for the new squads. (3) Other funding for Structural Overlays comes from SKB User Fees. (4) Other funding for the Chippendale Street Reconstruction Project comes from the County for their share of the project. (5) Other funding for the South Rose Park Area Improvements comes from SKB User Fees and County contributions. MSA Funds Building Street E ui mnt Park Imp From Water Sewer Storm Water Sewer Storm Total Year Item - Description De artment CIP Levy CIP Levy CIP Levy Assess Fund State Core Core Core Utility utility Utility Donations Other Cost 2001 Commercial Streetscape - Phase 3 Comm Dev 50,800 2,000,000 2,000,000 2002 1995 Lease - Purchase 10- Years) Council' 50,800 2002 _ 1996 Lease - Purchase 10 -Years Council _ 64,900 _ _ _ 64,900 2002 2001 Lease - Purchase 10 -Years Council 115,400 _ 115,400 2002 _ _ Council Designated - Street Reserves Council _ 315,000 _ 315,000 2002 Hurst Tool Attachments Fire 28,000 _ 28,000 2002 Community Center Audi Visual Equipment _ Replace Dallara Park Basketball Court Park & Rec Park & Rec _ _ _ 9,000 16,000 _ _ - _ _ _ _ _ _ _ _ 9,000 16,000 2002 2002 Replace 7 Cellular Phones in Squad Cars Police 3,000 3 ,000 3,000 2002 Mobile Radios for 2 Squads (9970 & Ne Police 4,000 4,000 2002 U rade Police Disp Receiver Site P olice - 8,000 _ _ - _ _ _ _ 8,000 2002 Police Records, CAD & Mobile Software Police _ 49,000 _ _ _ _ _ 49,000 2002 3 S uads Sell Back 1 - Replace #9970 & 1 New Police 58,000 1 _ 8,000 66,000 20 02 PW Bldg Add'n Lease/Purch Yr 4 of 20 Pub Works 24,000 _ 225,000 _ _ _ 10,000_ . 10,000 _ _ _ 50,000 44,000 6 7,000 2002 Structur Overlays on Older Streets Pub Works _ _ 17,000 50,000 2002 Street Recon - Chippendale @ CSAH 42 Pub Works 100,000 375,000 2002 2002 2002 South Rose Park Area Improvemen Street Const -Bisca ne -Conn to RR Tracks Street Construction - Conn Trai _ _ -- Pub Pickup (Replace #332 1989 Vehicle) Pub Works _ _ - _ 22,000 140,000 - 300,000 20,000 100,000 20,000 80,000 60,000 420,000 Pub Works _ 200,000 3,000,000 _ _ _ _ _ 500,000 Works Pub Works 3,000,00 2002 22,000 2002 Van (Replace #320- Irrigation) Pub Works 27,000 _ 2 7,000 2002 Pickup ( Replace #337) _ Pub Works ___ 33,000 _ _ _ 3 3,000 2002 Pickup ( Replace #340) Pub Works 33,000 33,000 _ 2002 Municipal Tractor (Replace #408 ) Pub Works 70,000 70,000 2002 Mower (Replace #68 Pub Works 70,000 70,000 315,000 Totals 661,100 3,407,000 525,000 20,000 100,000 10,000 30,000 80,000 2,218,000 7,390,100 24,000 Total Levy - Year 2002 1,000,100 (1) Other funding for the Commercial Streetscape - Phase 3 is coming from a MN /DOT contribution to the project, other assessment and core funds(undetermined in amounts at this time) and from a Port Authority debt issue. (2) Other funding for Police Squad Cars is from the DUI Forfeiture Fund to pay for the radars for the new squads. (3) Other funding for Structural Overlays comes from SKB User Fees. (4) Other funding for the Chippendale Street Reconstruction Project comes from the County for their share of the project. (5) Other funding for the South Rose Park Area Improvements comes from SKB User Fees and County contributions. Page One 2002 BUDGET WORKSHEETS INSURANCE - REVENUES July 31, 2001 Account # Description 206 31010 00 000 Current Ad Valorem Taxes 206 33100 00 000 Federal Grants & Aids 206 36210 00 000 Interest Earnings- Investments 2063621400 000 Net Change in FV- Investments 206 36215 00 000 Interest Earnings 206 36260 00 000 Other Revenue 206 49006 01 409 FUND TOTALS INSURANCE - EXPENDITURES Account # Description 206 49006 01 221 Equipment Parts 206 49006 01 304 Legal Fees 206 49006 01 305 Medical & Dental Fees 206 49006 01 317 General Fund Administrative Fees 206 49006 01 319 Other Professional Services 206 49006 01 365 Worker's Compensation Insurance 206 49006 01 369 Other losurance 206 49006 01 409 Other Contracted Repair & Maint 206 49006 01 439 Other Miscellaneous Charges 10,000 FUND TOTALS 2001 2002 Object 2002 1998 1999 2000 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $187,000 $180,000 $185,000 $190,000 $200,000 0 0 32,487 0 0 7/01 Rain Storms 16,971 20,911 26,303 10,000 10,000 Comments 1,283 (10,312) 7,156 0 0 Annual Market Value Changes 329 475 601 200 200 Unreimbursable Legal Fees 34,585 36,200 31,111 20,800 20,800 Insurance Refunds /Dividends 240,168 227,274 282,658 221,000 - -- 231,000 Yearly Fee Per Policy F -3 NOTE: Levy of $200,000 covers costs for consultant fees and all insurance premiums. All other expenditures covered through interest earnings and insurance refunds /dividends. '33. 2001 2002 Object 2002 1998 1999 2000 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $1,125 $659 $866 $2,000 $2,000 Liability & Auto Deductible Pymts 10,248 129 45,590 2,500 2,500 Unreimbursable Legal Fees 1,225 6,135 11,075 7,000 15,000 Work Comp Deductible Pymts 2,500 2,500 2,500 2,500 2,500 Yearly Fee Per Policy F -3 10,000 9,667 17,450 15,000 20,000 Risk Management Consultant 34,343 28,784 28,585 50,000 50,000 Annual Premium 112,111 114,805 105,349 125,000 1.30,000 Annual Premium - General Liability 4,129 7,565 7,900 8,000 9,000 Liability & Auto Deductible Pymts 14,119 1,084 9,377 0 0 1998 -Storm Damages 189,799 171,329 228,691 212,000 231,000 NOTE: Levy of $200,000 covers costs for consultant fees and all insurance premiums. All other expenditures covered through interest earnings and insurance refunds /dividends. '33. Page One 2002 BUDGET WORKSHEETS ARENA - REVENUES July 31, 2001 Account # Description 650 31010 00 000 650 36210 00 000 650 36215 00 000 650 36260 00 000 650 36265 00 000 650 38060 00 000 650 38061 00 000 650 38063 00 000 650 38065 00 000 650 38066 00 000 650 38067 00 000 650 38090 00 000 650 38091 00 000 650 38095 00 000 650 39103 00 000 650 39201 00 000 Current Ad Valorem Taxes Interest Earnings- Investments Interest Earnings Other Revenue Use of Reserve Funds Prime Time Ice Fees Non -Prime Time Ice Fees Open Skating Ice Fees Other Events -Arena Advertising Revenue -Arena Skate Sharpening Revenue -Arena Concessions Vending Machine Revenues Pro Shop Revenues Gain or Loss from F/A Disposal Transfer From General Fund FUND TOTALS 2001 2002 Object 2002 1998 1999 2000 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $109,200 $114,900 $136,300 $0 $0 0 0 0 200 200 19 109 121 200 200 13,355 11,943 13,229 13,000 14,500 Learn to Skate Program (LTS) 0 0 0 0 26,500 229,855 229,097 214,245 230,500 230,500 0 0 0 0 0 5,628 4,834 5,395 6,300 6,300 0 500 838 5,500 500 Dry Floor Events 11,800 9,275 11,138 13,100 14,000 3,288 2,823 4,532 2,800 2,800 4,860 3,196 3,600 5,000 5,000 11,484 10,684 10,450 9,900 11,000 904 721 985 1,100 1,100 Tape, Laces, Mouthguards, etc. 1,536 0 0 0 0 0 0 0 0 0 ---------- ----------- --------------- - - - -- 391,929 388,082 400,832 287,600 312,600 --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --------- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- _3'� Page One 2002 BUDGET WORKSHEETS ARENA - EXPENDITURES July 31, 2001 Account # Description 650 45130 101 Salaries & Benefits 650 45130 77 101 Administrative 650 45130 78 101 Technical /Clerical 650 45130 79 101 Maintenance 650 45130 79 102 Full -Time Overtime 650 45130 103 Part-Time Salaries & Benefits 650 45130 89 103.1 Learn -To -Skate Program 650 45130 99 103.2 Building & Skate Guard Attendants 650 45130 01 207 Training & Instructional Supplies 650 45130 01 208 Miscellaneous Supplies 650 45130 01 208.1 Skate Magnets 650 45130 01 208.2 Other Supplies 650 45130 01 209 Other Office Supplies 650 45130 01 211 Cleaning Supplies 650 45130 01 212 Motor Fuels 650 45130 01 216 Chemicals & Chemical Products 650 45130 01 219 Other Operating Supplies 650 45130 01 221 Equipment Parts 650 45130 01 223 Building Repair Supplies 650 45130 01 241 Small Tools 650 45130 01 242 Minor Equipment 650 45130 01 265 Other Items for Resale 650 45130 01 305 Medical & Dental Fees 650 45130 01 317 General Fund Admin Fees 650 45130 01 321 Telephone Costs 650 45130 01 331 Travel Expense 650 45130 01 341 Employment Advertising 650 45+30 01 349 Other Advertising 650 45130 01 365 Workers Comp Insurance 650 45130 01 369 Other Insurance 650 45130 01 381 Electric Utilities 650 45130 01 383 Gas Utilities 650 45130 01 384 Refuse Disposal 650 45130 01 401 Contracted Building Repairs 650 45130 01 404 Contracted Mach & Equip Repairs 650 45130 01 415 Other Equipment Rental 650 45130 01 433 Dues & Subscriptions 650 45130 01 437 Conferences & Seminars 650 45130 01 439 Other Miscellaneous Charges 650 45130 01 521 Building & Structure Purchases 650 45130 01 601 Bond Principal 650 45130 01 611 Bond Interest 650 45130 01 621 Bond Paying Agent Fees 650 45130 01 710 Transfers 650 45130 01 710.1 Yearly Maintenance 650 45130 01 710.2 Bond Principal (1992E Issue) 650 45130 01 710.3 Bond Interest (1992E Issue) FUND TOTALS 1998 Actual 1999 Actual 2000 Actual 2001 Adopted Budget 2002 Object Detail Amount 2002 Proposed Budget Comments All Salary Costs Inclusive of $54,431 $54,545 $68,768 $75,300 $102,400 Salary, Taxes, PERA & Benefits 8,800 35,600 58,000 1,234 1,786 380 2,000 2,000 51,167 38,828 39,265 46,600 49,600 11,500 38,100 50 0 0 200 200 155 855 33 1,500 1,000 200 800 0 0 0 0 500 Learn to Skate Program Supplies 3,121 2,562 2,870 3,000 3,000 2,008 1,941 2,659 2,400 2,400 Batteries for Resurfacer 387 642 222 800 800 Assorted Floor Products 1,238 484 601 1,000 1,000 Events Supplies 1,324 0 1,548 3,400 3,400 1,766 3,294 1,561 4,000 4,000 332 43 98 0 0 69 0 79 0 0 734 723 411 800 800 Pro Shop Supplies 70 0 0 500 500 6,000 6,000 6,000 6,000 6,000 Yearly Fee Per Policy F -3 1,000 1,000 1,000 1,000 1,000 0 100 0 100 100 0 0 0 500 500 75 61 0' 800 800 1,219 1,136 1,084 2,000 2,000 7,341 5,729 4,873 13,000 13,000 32,257 34,465 59,415 43,000 64,500 11,511 12,883 24,326 15,000 33,000 3,499 3,424 3,409 3,500 3,500 4,850 2,116 5,305 5,000 5,000 14,244 5,581 6,318 5,000 6,000 168 165 0 300 300 600 734 695 900 900 MIAMA Dues 0 400 100 400 400 MIAMA Seminars 553 0 0 500 500 Contingencies 0 0 0 28,000 0 30,000 0 0 0 0 1999 - Moved to Transfers 146,515 0 0 0 0 1999 - Moved to Transfers 0 0 0 0 0 1999 - Moved to Transfers 3,500 183,428 191,500 3,500 3,500 3,500 0 2001 - Moved to D/S for Arena 0 2001 - Moved to D/S for Arena 381,417 362,923 422,521 270,000 312,600