Loading...
HomeMy WebLinkAboutCity Council - 12/07/1998 EDEN PRAIRIE CITY COUNCIL AGENDA DATE: 12/7/98 SECTION: Public Hearing ITEM NO. SERVICE AREA: ITEM DESCRIPTION: City Manager - Christopher Enger Truth-in-Taxation Public Hearing Requested Council Action: Move we close the Truth-in-Taxation public hearing and set Tuesday, December 15 at 7:30 p.m. as the date and time of the formal budget and levy adoption. Background The following actions are required at the Truth-in-Taxation public hearing: 1. The proposed Pay 1999 property tax levy and the 1999 proposed budget must be discussed. 2. The public must be given a reasonable amount of time to comment on and ask questions about the proposed property tax levy and budget. 3. The date, time, and place for the Levy Adoption hearing must be announced. Staff's presentation meets these requirements. . f ?:' S F3' akyy " % "! i • ,..1_,,„ ,, ■ ei11113 don orairie ■ ■ III IN ■ / 4E 1 Pf k . General Fund Expenditures 1998 1999 Public Safety $ 6,392 $5,939 Public Works 3,704 3,677 Parks & Recreation 3,994 3,834 General Government 4,413 4,332 Shared Services 3,747 4,434 Total Operations $22,250 $22,216 CIP Transfer 491 Vehicles & Equipment 638 652 Debt Service Funds 2,466 2,169 Total Expenditures $25,354 $25,528 (In thousands) 25 Fund ExpendituresGenera General Government - 17% Parks & Recreation - 15% Debt Service - 9% Vehicles & Public Works -14% ` Equipment - 3% Public Safety - 23% Shared Services - 17% CIP Transfer - 2% 24 General Fund Revenues 1998 1999 Licenses and Permit Fees $ 2,165 $2,318 Intergovernmental Revenue 725 691 Charges for Services 1 ,869 1 ,954 Other Financing Sources 1 ,091 492 Other Revenue 970 869 Property Taxes 18,534 19,204 Total Revenues $25,354 $25,528 (in thousands) 23 General Fund Revenues Intergovernmental Revenue - 3% Other Financing Sources - 2% Charges for Services - 8% Other Revenue - 3% Licenses, Fees - 9% Property Taxes - 75% 22 Total Tax - Residential Homestead 97 Pay 98 98 Pay 99* Pay 98 Pay 99 %Ch.ch . $Chg $96,700 $100,000 $1 ,568 $1,476 (5.92) (93) 106,400 110,000 1 ,802 1 ,695 (5.94) (107) 116,100 120,000 2,035 1,942 (4.56) (93) 135,400 140,000 2,505 2,437 (2.69) (67) 145,100 150,000 2,760 2,685 (2.73) (75) 171 ,200 177,000 3,447 3,353 (2.73) (94) 193,400 200,000 4,032 3,923 (2.71) (109) 241 ,800 250,000 5,307 5,161 (2.76) (146) 290,100 300,000 6,579 6,398 (2.74) (180) 386,800 400,000 9,125 8,874 (2.76) (252) 483,600 500,000 11 ,675 11 ,350 (2.79) (325) 725,300 750,000 18,040 17,539 (2.78) (501) *Average Value Increase of 3.4% 21 Cost of Tax-Supported Services 1998* 1999* Public Safety $13.70 12.66 Public Works 7.94 7.84 Parks & Recreation 8.56 8.17 Facilities 3.97 3.72 General Government 5.48 5.51 Shared Services 8.03 9.45 Equipment Revolving Fund 1 .37 1 .39 Transfer to CIP 0 1 .06 Debt Service 5.28 4.62 Totals $54.33 $54.42 Annual Cost $652 $653 *Monthly cost - median value home 20 City Tax - Residential Homestead Mkt Value Mkt Value* 97 pay 98 98 pay 99 Pay 98 Pay 99 % Chi $ Chg $96,700 $100,000 $300 $311 3.73 $11 106,400 110,000 346 355 2.80 10 116,100 120,000 392 400 2.09 8 135,400 140,000 483 488 1 .17 6 145,100 150,000 529 533 .79 4 154,700 160,000 574 577 .54 3 164,400 170,000 620 622 .26 2 171 ,200 177,000 652 653 .08 1 183,800 190,000 712 710 (.19) (1) 193,400 200,000 757 755 (.32) (2) 483,600 500,000 2,129 2,086 (2.05) (44) 725,300 750,000 3,273 3,195 (2.37) (77) 967,100 1 ,000,000 4,416 4,304 (2.53) (112) 19 *Average Value Increase of 3.4% Distribution of PropertyTax Dollars* Eden Prairie - 19.5% SWMT - 2.2% /, -.. ....„,....t,V :::r4., Other - 4.3% � �' 'ateltAks Y� District 272 - 42.5% Hennepin County - 31.4\ , / ,,, i 18 *Median Vale 1 ' . nie Budget Process . Dec. 7 . Truth-in-Taxation Public Hearing Held . Dec. 15 . Continue Public Hearing if Needed . Council Adopts Budget . By Dec. 28 . Certify Tax Levy with the County 17 Budget Process . May to Sept. . Budget Requests Submitted by Service Areas . Council/Staff Budget Workshops Held • Sept. 15 . Proposed Budget Adopted . Nov. 10-24 . Proposed Tax Statements Sent 16 1999 Proposed Budget • Complies with Levy Limits • Reflects Reduction in Debt Service • Provides Minimum Additional Staff • Includes Transfer of $490,000 to a Capital Improvement Fund 15 Budget Objectives . Minimize Tax Impacts . Maintain Current Service Levels . Ensure Balanced Budget Model . Provide Funding for the Capital Improvements Program 14 • 1111Ki;S rProposed1999 Gene a I Fund ,&Y�d' xE�4. • and • e • Debt Budget • . . • • OPocimn • prairie ss# k 1999 Objectives . Leisure . Begin Construction of Purgatory Creek Recreation Area . Implement On-line Park Program Registration System . Management/Leadership . Begin 2-Year Budgeting and Strategic Planning Cycle . Boards and Commission Alignment 12 1999 Objectives . Economic Growth . Implement City-wide Fiber Optics Plan . Eden Prairie Center Redevelopment . Natural Resources . Update Park and Open Space System Plan . Full Use of Environmental Learning Center 11 1999 Objectives • Transportation • Construction of TH 212 - Stage II & Ill • Construction of CSAH 1 • Public Safety • Complete Installation of Integrated CAD/ MDT and Records Management System • Fire Station #1 Opening 10 1998 Accomplishments . Leisure . Improved Recreational Facilities at Ten Park Locations . Finished Community. Center Pool and Locker Room Improvements . Management/Leadership . Leadership Transition and Service Area Alignment . 2001 Strategic Planning 9 1998 Accomplishments . Economic Growth . Water Plant Expansion . Issued $55.6 M in Residential and $18 M in Commllnd Building Permit Value . Natural Resources . Completed Wetland Protection and Management Plan . Updated 5 Year CIP for Parks and Recreation 8 II 1998 Accomplishments • Transportation • Began .Construction of TH 212 - Stage 1 • Completed Southwest Metro Transit Hub • Public Safety • Increased Traffic Enforcement Contacts • Began Construction of Fire Station #1 Service Areas 6 FOCUS AREAS . Transportation . Public Safety . Economic Growth . Natural & Cultural Resources . Leisure 5 VALUES . We will make decisions that support the long term needs and vision of the community. . We will foster a safe and caring community that welcomes and enhances economic, ethnic, cultural, and life-cycle diversity. 4 VALUES • We will actively seek information through an open process, and make decisions only after careful consideration . • We will balance competing needs/ interests within the framework of community resources. • We will make decisions that are fiscally sound and sustainable. 3 VISION Eden Prairie is a vibrant city characterized by the thoughtful integration of natural beauty with physical development. Respect for the past, planning for the future and delivery of public services contributes to a strong sense of community where people live, work, shop, and play. 2 -.-„...-.,.,_,„-s,.,...-.-,,,.,.r:,,,t .L ykk `t V.,;,,.,:„,.:4t,..-,,,. j-..., ETI E • 1 ,,,„.,.„.1..,..:„:.,-,;',:-i,„-,:,..,....'„,_.::,„:!:t: ...,:„.,q.,.,k,t,14:,..,„:,,..,,,.-4i..,,.„,f"...,..,,,:,,1,-.,,,:,c„-1,,.,,.:,i4,,..,7,,.,,„,::,„ ,; •EP '. Truth n OTaF Public ,.id,...i.1,4,,.,,,.,..;„,..;,,s,,,i.-.,. :. ...:„„..:.,,,„,.:,,...,„,,.7.3.,..,.4..,..,...1-., :,,'kr,,,:..,.., HearingE . . ■ . ■ December7 , 1998 . . _. ......_.........._........ ....... . . . ........._............._......_.......................... .... ......................_...._........._............... ... ........... .._........._..._......................... '.r,..„.J.?sI.4-it.'''op',''''fi-'''''''4 d0n f prairie . City of Eden Prairie 1999 Proposed Budget December 7, 1998 City Council Dr. Jean L. Harris, Mayor Sherry Butcher-Younghans Ronald Case Ross L. Thorfinnson, Jr. Nancy Tyra-Lukens City Manager Christopher M. Enger ePeden prairie Shared Services General Shared Services 49 Risk Management&Customer Service 50 Information Technology 51 Legal Counsel 53 Employee Benefits&Training 54 Contingency 55 . Vehicles and Related Equipment • 56 Capital Budget(included in General Fund Budget) Capital Budget Summary(other than vehicles and related equipment) 57 Computers 58 Software 59 Office Furniture 60 Communication Equipment 61 Capital Improvements 62 Additional Capital 63 ENTERPRISE FUNDS Utility Fund Water Summary 65 Sewer Summary 69 Water& Sewer Proposed Budget 71 Storm Summary 73 Storm Proposed Budget 74 Capital Budget Summary 75 Liquor Fund Liquor Summary 77 Liquor Fund Proposed Budget 78 Den Road 79 Prairie Village 80 Prairie View 81 Capital Budget Summary 82 City of Eden Prairie City Offices .Al 14 -..�5.� 8080 Mitchell Road • Eden Prairie, MN 55344-4485 �w - Phone (612) 949-8300 • TDD (612) 949-8399 • Fax (612) 949-8390 ;• Honorable Mayor, Council Members, and Citizens: Staff is pleased to submit the 1999 Proposed Budget for the City of Eden Prairie for the December 7 Truth-in-Taxation hearing. As part of the lengthy and comprehensive budgeting process,the City Council and the Management Team prioritized the City's needs and then balanced the allocation of the City's human and financial resources against those needs. In summary,the 1999 General Fund Proposed Budget totals$25.5 million including Debt Service and Vehicles and Equipment. This is an increase over the 1998 Budget of$173,682 or less than 1%. Expenditures for Debt Service decreased $297,000 or 12% and Vehicles and Equipment increased slightly in 1999. Overall,the cost of City services to the individual taxpayer is only $653 annually or $54 per month. Considering the range of services provided,this is an exceptional value. City Staff will continue to strive to provide the best service possible at the least cost to the taxpayer. We have accomplished that with the 1999 Budget. This document also contains budgets for the City's Utility and Liquor Enterprise Funds. The 1999 Water and Sewer budget is similar to 1998 with$6.5 million budgeted in revenues and $6.2 million budgeted for operating expenses. The Storm Drainage Fund has $565,000 budgeted for revenues III and$344,582 of budgeted expenses. A transfer to the general fund of$60,000 is proposed. Sales in the Liquor Enterprise for 1999 are expected to increase 7%to $6.1 million due to strong financial performance at the Den Road Store. Expenses including costs of goods sold of$5.65 million have been budgeted resultingin operating income of $435,016. The 1999 transfer to the g P g general fund is budgeted at$420,000. Changes in the 1999 budget include the following: g g • An Information Technologies division was created and includes data processing(computers, software, and related contracted services)and wireless communications(pagers and radios). Data processing and wireless communications items budgeted by each department are shown in their budgets for comparison purposes to the 1998 budget. These amounts will be transferred to the Information Technologies division budget for purchasing purposes. These changes were made to take advantage of the expertise in these departments and to more efficiently use these resources. *. recyciedipoper • A capital improvements fund was created. Instead of budgeting significant capital expenditures in the General Fund, $491,376 was budgeted as a transfer to the Capital Improvement Fund. When the Capital Improvement Plan is completed early next year, amounts will be allocated to projects with the highest priority. This process will allow the City to more effectively use resources. A mission of the City of Eden Prairie is to deliver cost effective and quality services to our customers. The major objectives of the 1999 budget are designed to help the City accomplish this mission. These budget objectives include the following: 1. Minimize the tax on the median value home. 2. Maintain departmental operating budgets at 1998 spending levels except certain inflationary adjustments. 3. Budget capital items separately and fund a capital maintenance and improvement plan. 4. Provide for additional staff to maintain the current level of service. The City's annual budget is our primary means of allocating resources and accounting for revenues and expenditures. This budget complies with the Council's major budgeting objective's that evolved from our Council/Staff workshops during 1998. Res ectful ly y submitted, Christophe . Enger Donald R. Uram City Manager Director of Community Development&Financial Services 2 City of Eden Prairie Calculation of City Tax Rate Adjusted Tax Levy+Park Bond Levy=Total Pay 99 City Tax Levy $18,611,991 (Adjusted Tax Levy+Park Bond Levy=Total Pay 98 City Tax Levy $17,878,492 Change99_vv98`,,„,.42 4.103% w ACTUAL ACTUAL TAX CAPACITY TAX CAPACITY 97 PAY 98 98 PAY 99 $Change %Change REAL ESTATE $80,049,210 $81,429,291 $1,380,081 1.72% PERSONAL PROPERTY $1,695,496 $1,661,275 ($34,221) -2.02% NET TAX CAPACITY $81,744,706 $83,090,566 $1,345,860 1.65% less FISCAL DISPARITY CONTRIBUTION $11,570,702 $11,558,827 ($11,875) -0.10% less TIF CAPTURED TAX CAPACITY $266,344 $266,344 $0 0.00% ADJUSTED NET TAX CAPACITY $69,907,660 $71,265,395, $1,357,735 1.94% TAX LEVY $18,681,684 $19,453,015 $771,331 4.13% less FISCAL DISPARITY DISTRIBUTION $764,992 $787,152 $22,160 2.90% less HACA $646,200 $645,872 ($328) -0.05% ADJUSTED TAX LEVY $17,270,492 $18,019,991 $749,499 4.34% k,.au aY.,. a .., .,+7':+a'm't :.. -:. <. ` =€s..ZEL Jig- ADJUSTED TAX LEVY $17,270,492 $18,019,991 $749,499 4.34% DIVIDED BY ADJUSTED NET TAX CAPACITY $69,907,660 $71,265,395 $1,357,735 1.94% EQUALS CITY TAX RATE 24.7070% 25.2790% 0.5720% 2.32% PARK BOND REFERENDUM LEVY $608,000 $592,000 ($16,000) -2.63% DIVIDED BY TAXABLE MARKET VALUE $3,839,918,282 $4,241,314,230 $401,395,948 10.45% EQUALS REFERENDUM LEVY RATE 0.01583% 0.01396% -0.002% -11.81% 2 y. i $ 3 PROJECTED CITY TAX-RES HOMESTEAD- Single Family Average Value Increase of 3.4.%. Pay 98 class rate= 1st$75,000@1.0%+balance @ 1.85% Pay 99 class rate= 1st$75,000@1.0%+balance @ 1.70% Market Value Market Value City Tax City Tax % $ 97 PAY 98 98 PAY 99 PAY 1998 PAY 1999 CHANGE CHANGE $96,700 $100,000 $300 $311 3.73% $11 $106,400 $110,000 $346 $355 2.80% $10 $116,100 $120,000 $392 $400 2.09% $8 $135,400 $140,000 $483 $488 1.17% $6 $145,100 $150,000 $529 $533 0.79% $4 $154,700 $160,000 $574 $577 0.54% $3 $164,400 $170,000 $620 $622 0.26% $2 $174,100 $180,000 $666 $666 0.02% $0 $183,800 $190,000 $712 $710 -0.19% ($1) $193,400 $200,000 $757 $755 -0.32% ($2) $483,600 $500,000 $2,129 $2,086 -2.05% ($44) $725,300 $750,000 $3,273 $3,195 -2.37% ($77) $967,100 $1,000,000 $4,416 $4,304 -2.53% ($112) PROJECTED CITY TAX-Commercial/Industrial Property with Preferred Commercial Class Average Value Increase of 10.7% Pay 98 class rate= 1st$150,000@2.70%+balance @ 4.0% Pay 99 class rate= 1st$150,000@2.45%+balance @ 3.5% Note: City tax excludes fiscal disparity portion. 66.5267%City&33.4733% FD-Pay 98 66.00%City&34.00%FD-Pay 99 Market Value Market Value City Tax City Tax 97 PAY 98 98 PAY 99 PAY 1998 PAY 1999 %CHANGE $CHANGE $150,000 $166,000 $689 $730 5.85% $40 $903,000 $1,000,000 $5,759 $5,716 -0.75% ($43) $1,807,000 $2,000,000 $11,846 $11,695 -1.27% ($151) $4,517,000 $5,000,000 $30,092 $29,632 -1.53% ($460) $9,033,000 $10,000,000 $60,499 $59,528 -1.60% ($971) $13,550,000 $15,000,000 $90,912 $89,423 -1.64% ($1,489) $18,067,000 $20,000,000 $121,325 $119.318 -1.65% ($2,006) PROJECTED CITY TAX-Market Rate Apartment Average Value Increase of 10.9% Pay 98 class rate=2.9% Pay 99 class rate=2.5% Market Value Market Value City Tax City Tax % $ 97 PAY 98 98 PAY 99 PAY 1998 PAY 1999 CHANGE CHANGE $90,000 $100,000 $659 $646 -2.00% ($13) $902,000 $1,000,000 $6,606 $6,459 -2.21% ($146) $4,509,000 $5,000,000 $33,021 $32,297 -2.19% ($724) $9,017,000 $10,000,000 $66,034 $64,594 -2.18% ($1,441) $13,526,000 $15,000,000 $99,055 $96,890 -2.19% ($2,165) $18,034,000 $20,000,000 $132,069 $1292187 -2.18% ($2,882) • City of Eden Prairie Projected Tax Capacities, Tax Levies And Tax Rates BUDGET BUDGET BUDGET BUDGET 95/96 96/97 97/98 i 98/99 TOTAL MARKET VALUE 3,097,807,900 3,497,309,000 3,839,918,282 4,241,314,230 TAX CAPACITY REAL PROPERTY 70,738,620 79,962,259 80,049,210 81,429,291 PERSONAL PROPERTY 1,819,293 1,932,846 1,695,496 1,661,275 GROSS VALUE 72,557,913 81,895,105 81,744,706 83,090,566 FISCAL DISPARITY CONTRIBUTION (11,308,612) (12,017,326) (11,570,702) (11,558,827) TIF CAPTURED VALUE (156,302) (185,039) (266,344) (266,344) NET TAX CAPACITY 61,092,999 69,692,740 69,907,660 71,265,395 TAX LEVIES GENERAL FUND $12,929,612 $15,265,000 $16,274,034 $17,313,215 EQUIPMENT REVOLVING FUND 480,000 551,600 549,400 562,800 DEBT SERVICE 2,342,100 1,768,500 1,858,250 1,577,000 Gross Levy on Tax Capacity $15,751,712 $17,585,100 $18,681,684 $19,453,015 HACA (588,226) (645,970) (646,200) (645,872) FISCAL DISPARITY DISTRIBUTION (675,876) (712,246) (764,992) (787,152) Net Levy on Tax Capacity $14,487,610 $16,226,884 $17,270,492 $18,019,991 DEBT SERVICE 1992& 1993 Park Bonds 290,700 298,000 442,000 432,000 1994 Open Space Bonds 144,600 157,000 166,000 160,000 Levy on Market Value 435,300 455,000 608,000 592,000 TOTAL NET LEVY $14,922,910 $16,681,884 $17,878,492 $18,611,991 TAX RATES GENERAL FUND 19.465% 20.212% 21.521% 22.504% EQUIPMENT REVOLVING FUND 0.723% 0.730% 0.727% 0.732% DEBT SERVICE 3.526% 2.342% 2.457% 2.050% TAX CAPACITY RATE 23.714% 23.4215% 24.7022% 25.294% 1992& 1993 Park Bonds 0.0094% 0.0085% 0.0115% 0.0102% 1994 Open Space Bonds 0.0047% 0.0045% 0.0043% 0.0038% MARKET VALUE RATE 0.0141% 0.0130% 0.01583% 0.0140% 5 City of Eden Prairie 1999 Proposed Budget General Fund Revenues and Debt Service 1998 Actual 1999 1997 1998 10/31/98 Proposed Actual Budget (Unaudited) Budget General Property Taxes Current 15,085,470 16,274,034 8,028,624 17,313,215 Delinquency and Abatement (7,252) (800,000) 70,869 (863,878) Net Current 15,078,218 15,474,034 8,099,493 16,449,337 Delinquent Collections Penalty and Interest 30,925 70,000 12,018 50,000 Total Taxes 15,109,143 15,544,034 8,111,511 16,499,337 Licenses and Permits Liquor and Beer 144,969 160,000 122,510 170,000 Building Contractors 5,565 4,500 3,290 5,500 Vending and Business Licenses 21,619 21,700 34,972 25,000 Dog Registration 11,884 13,500 12,698 12,000 Building Permits 2,049,500 1,700,000 1,779,689 1,800,000 Cable TV 423,077 242,500 148,946 275,000 Other Permits 34,793 22,750 54,290 30,000 Total Licenses and Permits 2,691,407 2,164,950 2,156,395 2,317,500 Intergovernmental Revenue Police Pension Aid 243,394 300,000 295,318 243,000 Fire Relief Association Aid 188,773 178,000 200,834 193,000 State Street Aid 49,293 110,000 109,595 110,000 School Liaison 70,748 54,000 0 65,000 Police Training 14,629 15,000 15,508 15,000 COPS Grant 42,200 0 0 0 Civil Defense 5,000 5,000 0 5,000 Local Performance Aid 52,216 63,400 31,705 59,500 PERA Aid 26,192 0 26,192 0 Other 1,408 0 0 0 Total Intergovernmental Revenue 693,853 725,400 679,152 690,500 Charges for Services General Government Planning and Zoning 129,664 70,000 100,034 70,000 Engineering 239,782 101,000 165,230 150,000 Public Safety Prints,Reports,and Alarms 68,603 57,250 44,023 70,000 Impound Fees 4,130 2,575 3,542 4,000 Recreation Youth Programs 204,074 203,600 175,456 209,500 Organized Athletics 216,825 216,200 211,192 216,200 Community Center 702,357 692,600 389,772 691,070 2nd Ice Arena 238,827 284,500 286,050 315,300 Oak Point Pool 74,331 115,360 62,040 99,600 Beaches 3,277 8,425 3,709 5,000 Special Events 22,881 28,680 19,356 28,665 Arts 8,368 7,450 9,910 7,000 Adult Program/Adaptive Recreation 35,930 50,500 28,644 51,900 Park Facilities 35,385 30,400 34,930 36,100 Total Charges for Services 1,984,434 1,868,540 1,533,888 1,954,335 7 City of Eden Prairie 1999 Proposed Budget General Fund Revenues and Debt Service 1998 Actual 1999 1997 1998 10/31/98 Proposed Actual Budget (Unaudited) Budget Court Fines 188,301 200,000 156,248 200,000 Investment Earnings 189,558 150,000 0 170,000 Other Revenue Special Assessments 223,852 125,000 79,810 118,000 IDR Charges 186,113 90,000 88,189 90,000 Street Lighting 23,402 25,000 16,168 25,000 Tenant Rental Income 0 125,000 0 0 Miscellaneous 335,562 140,416 87,381 150,000 Total Other Revenue 768,929 505,416 271,548 383,000 Other Financing Sources Transfers in(out) Utility Fund 60,000 60,000 0 60,000 T.I.F.Capital Project Fund 8,239 11,500 6,062 12,000 Liquor Fund 0 420,000 0 420,000 Other 97,948 0 0 0 Equipment Certificates 0 600,000 0 0 Note Proceeds 210,397 0 0 0 Total Other Financing Sources 376,584 1,091,500 6,062 492,000 Total Revenues 22,002,209 22,249,840 12,914,804 22,706,672 Vehicles and Equipment Property Taxes Current 545,112 549,400 271,040 562,800 Delinquency and Abatement 2,973 (26,000) 2,406 (26,800) Net Current 548,085 523,400 _ 273,446 536,000 Sale of Property 105,916 114,500 109,787 116,000 Total Vehicle and Equipment 654,001 637,900 383,233 652,000 Total General Fund 22,656,210 22,887,740 13,298,037 23,358,672 Debt Levies Tax Capacity Levies 1,768,500 1,858,250 929,125 1,577,000 Market Value Levies 455,000 608,000 304,000 592,000 Total Debt Levies 2,223,500 2,466,250 1,233,125 2,169,000 Grand Total 24,879,710 25,353,990 14,531,162 25,527,672 8 City of Eden Prairie 1999 Proposed Budget General Fund Expenditures and Debt Service 1998 Actual 1999 1997 1998 10/31/98 Proposed Actual Budget (Unaudited) Budget General Government Legislative $ 141,303 $ 145,400 $ 116,449 $ 145,400 Elections 34,832 88,966 48,392 56,666 City Manager 178,546 182,026 205,277 189,526 Assessing 437,060 445,180 336,188 431,680 Finance 400,575 486,515 341,427 471,323 Human Resources 252,896 281,575 210,257 283,245 Communication Services 243,998 312,016 224,133 378,516 Housing Transportation and Human Services 130,385 149,415 78,220 155,600 Community Development 443,092 469,566 336,072 473,566 Facilities 1,942,122 1,852,570 788,757 1,746,410 Subtotal 4,204,809 4,413,229 2,685,172 4,331,932 Parks and Recreation Park Administration 142,190 150,842 105,722 147,842 Park Maintenance 1,117,575 1,168,755 1,001,537 1,153,755 • Parks Capital Outlay 50,497 88,400 79,178 17,400 Recreation Programming 1,003,802 1,051,178 821,738 1,078,131 Oak Point Pool 188,108 223,901 95,571 222,244 Community Center 1,303,652 1,311,166 786,079 1,214,345 Subtotal 3,805,824 3,994,242 2,889,825 3,833,717 Public Safety Police 3,742,445 4,523,120 3,144,434 4,067,287 Civil Defense 16,185 19,450 4,910 22.060 Animal Control 90,838 98,798 69,022 98,798 Fire 930,957 1,057,240 570,254 1,062,140 Inspections 627,157 693,394 495,941 688,794 Subtotal 5,407,582 6,392,002 4,284,561 5,939,079 Public Works Engineering 681,246 748,539 522,829 757,064 Streets and Traffic 1,458,690 1,593,902 1,208,291 1,534,832 Fleet Services 668,248 749,500 621,090 768,500 Street Lighting 579,136 611,500 442,408 616,500 Subtotal 3,387,320 3,703,441 2,794,618 3,676,896 Shared Services General Shared Services 557,933 577,644 513,824 .. 301,682 Risk Management&Customer Service 24,438 0 0 307,900 Information Technology 285,737 366,400 166,002 333,500 Legal Counsel 242,058 275,000 152,246 275,000 Employee Benefits and Training 2,173,283 2,387,882 1,826,857 3,061,590 Contingency 141,537 140,000 10,235 154,000 Subtotal 3,424,986 3,746,926 2,669,164 4,433,672 Transfer to Capital Improvement Program 491,376 Subtotal operations 20,230,521 22,249,840 15,323,340 22,706,672 Vehicles and Equipment General Government 15,140 50,587 40,555 18,000 Parks and Recreation 251,090 156,555 191,445 158,000 Public Safety 201,984 230,538 338,320 190,000 Public Works 109,208 200,220 28,963 286,000 Subtotal 577,422 637,900 599,283 652,000 Total General Fund S 20,807,943 S 22,887,740 $ 15,922,623 S 23,358,672 Debt Obligations 2,223,500 2,466,250 2,466,250 2,169,000 Grand Total S 23,031,443 S 25,353,990 S 18,388,873 $ 25,527,672 9 LEGISLATIVE Activity Description The City of Eden Prairie operates under the statutory Plan B form of government. Under this plan,a council-manager system operates within parameters set by State statute. The Council makes policy decisions for the City. The City Manager is responsible for implementing these policy decisions. The City Council consists of a mayor and four council members. The mayor serves a four year term and council members are elected to four-year terms with two positions open every two years. Elections are held in even-numbered years and coincide with general elections conducted in November. All Council positions are representatives' at-large. Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $61,175 $66,200 $66,200 $0 0.00% Commodities $300 $0 $0 $0 Contractual Services $79,828 $79,200 $79,200 $0 0.00% Capital Outlay $0 $0 $0 $0 Total $141,303 $145,400 $145,400 $0 0.00% 11 ELECTIONS Activity Description As required by State law,the City is responsible for the registration of voters and the conduct of all elections(except School District elections where the City does provide equipment and administrative support). The activities are the responsibility of the City Clerk. These activities include: maintenance of voter registration files,preparation of ballots, preparation of legal notices for publication and posting,conduction of absentee ballot process,preparation of candidate materials and monitoring of campaign fmancial reporting,training of judges,testing and validating election equipment, delivery of equipment and materials to polling places,and verification and canvass of election results. In February 1998 Precinct 9 was divided increasing Eden Prairie's voting precincts to 18. Objectives for coming year • Obtain necessary equipment and software to connect with the state's database of statewide registration. • Coordinate efforts with Hennepin County election division to prepare for redistricting process. • Prepare new election judge training manuals to reflect new electronic voting equipment and legislation. • Continue to systematically purge registration files to comply with MN Statute 201.081. Selected workload measures 1996 1997 1998 1999 Registered Voters 34,115 29,157 35,000 35,000 Absentee Voters 1,562 0 1,200 0 Budget Highlights Personnel services decreases since 1999 is not an election year but does reflect the possibility of a referendum. New election equipment will be provided by Hennepin County in exchange for the current Optech III-P electronic tabulators. The state's computerized voter registration system will be accessible in 1999 in time for the presidential primary in 2000. Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $27,735 $68,916 $39,716 ($29,200) -42.37% Commodities $0 $3,400 $100 ($3,300) -97.06% Contractual Services $7,097 $16,650 $6,850 ($9,800) -58.86% Capital Outlay $0 $0 $10,000 $10,000 Total $34,832 $88,966 $56,666 ($32,300) -36.31% 12 ADMINISTRATION Activity Description The City Manager is the chief executive officer of the City. It is the City Manager's duty to enforce all City ordinances and to expend funds according to the budget adopted by the City Council. The City Manager's office provides general administrative services for the management of the City to ensure that all Council policies and directives are accomplished. Activities involve coordinating the work of all City service areas; preparing reports and making recommendations to the Council on financial, legislative, and management issues, and providing liaison between the Council,advisory boards and commissions,staff,other levels of government,the media,and the public. Objectives for coming year • Complete the Capital Improvement Plan(CIP) • Implement the 2001 Strategic Plan • Build on"cross-functional"provision of services to maximize resources Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $161,597 $162,726 $162,726 $0 0.00% Commodities $426 $4,000 $2,000 ($2,000) -50.00% Contractual Services $9,054 $14,800 $22,300 $7,500 50.68% Capital Outlay $7,469 $500 $2,500 $2,000 400.00% Total $178,546 $182,026 $189,526 $7,500 4.12% Transfers $2,500 Total After Transfers $187,026 13 ASSESSING Activity Description The Assessing Division is responsible for establishing valuations and classifications of all real properties in the City for purposes of taxation as of January 2,the statutory date of assessment each year. By State law, the City must establish valuations for all new construction; physically view and appraise other existing properties at least once every four years;and annually adjust valuations of properties,if necessary,based on sales studies and other pertinent information to ensure uniformity with those properties actually viewed and appraised. The Assessing Department performs these functions plus processing homestead classification applications,assembling information for the annual Board of Review,representing the City in Tax Court matters relating to property valuation,and disseminating tax and real estate information to the public and other government agencies. The number of parcels, appraisals, and homestead applications processed continues to increase as the City develops. Volume is up 15%from the January 2, 1995 assessment to the January 2, 1999 assessment. Objectives for coming year • Complete the state mandated appraisals of new and existing properties • Meet state market value standard as measured by median sales ratio between 90%and 105%for all types of property • Complete assessment of residential properties with a coefficient of dispersion(COD)of less than 6.0 • Begin process of storing and retrieving appraisal sketches and photos to computer. (The City must implement a document imaging system to accomplish this). Selected workload measures ASSESSMENT YEAR 1995 1996 1997 1998 1999 Total Parcels 17,106 17,456 18,118 18,937 19,700 Homesteads 13,750 14,400 14,731 15,788 16,500 Board of Review Appeals 100 54 60 25 40 Tax Court Appeals 65 43 50 54 65 Estimated Market Values $3.1 Billion $3.5 Billion $3.8 Billion $4.2 Billion $4.5 Billion APPRAISALS 1995 1996 1997 1998 1999 COMPLETED Comm/Ind/Apartment 202 515 567 502 500 Residential 4,750 5,061 5,326 5,509 5,700 Land 681 1,446 577 661 900 Exempt(Every 6 years) 0 0 0 666 0 Personal Property 126 126 126 126 126 TOTAL 5,760 , 7,148 6,596 7,251 7,226 15 Budget Highlights The 1999 budget is similar to the 1998 budget. Because of a decrease in capital requests there is a slight decrease in the budget. Postage was increased to reflect actual costs incurred in 1998. The volume of required appraisals and the difficulty of appraisals continues to increase. Increase/Decrease 1997 1998 1999 Object Actual Budget Budget Amount Percent Personal Services $397,301 $408,480 $408,480 $0 0.00% Commodities $2,660 $7,600 $7,600 $0 0.00% Contractual Services $8,127 $10,800 $12,800 $2,000 18.52% Capital Outlay $28,973 $18,300 $2,800 ($15,500) -84.70% Total $437,061 $445,180 $431,680 ($13,500) -3.03% Transfers $2,800 Total After Transfers $428,880 16 FINANCE Activity Description The Finance Division is responsible for the financial management of the City. This includes establishing and maintaining effective controls over the City's financial activities and providing accurate financial information. Finance is also responsible for coordinating the annual budget, managing debt, investment of city funds, accounts receivable and payable, water and sewer billings, payroll, licensing, insurance and risk management, financial reporting, and elections. The Division also directs the City's off-sale liquor operations. Objectives for comina year • Prepare the City's Comprehensive Annual Financial Report and receive the Governmental Finance Officers Association(GFOA) Certificate of Achievement in Financial Reporting • Coordinate the budget process, improve the process and document, and receive the GFOA Budget Award • Implement new financial system through LOGIS • Complete RFP for banking services and implement new financial institution(s) Selected workload measures 1996 1997 1998 1999 Number of vendor checks issued 10,266 10,594 10,922 11,500 Number of payroll checks issued 9,779 10,644 11,200 11,900 Number of utility bills mailed 62,000 65,000 67,000 68,000 Number of receipts 2,751 2,853 2,955 ' 3,100 Number of purchase orders issued 995 450* 450 450 Date audit complete 5/30 5/15 5/1 5/1 Budget Highlights Services and expenditures for 1999 are similar to 1998. There is a small decrease in the budget due to decreased capital requests and to decreased temporary personnel services. Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $349,727 $430,815 $421,015 ($9,800) -2.27% Commodities $1,059 $6,000 $4,000 ($2,000) -33.33% Contractual Services $32,679 $42,200 $46,308 $4,108 9.73% Capital Outlay $19,113 $7,500 $0 ($7,500) -100.00% Total $402,578 $486,515 $471,323 ($15,192) -3.12% Transfers $108 Total After Transfers $471,215 17 HUMAN RESOURCES Activity Description The Human Resources Division ensures that personnel policies and practices are developed that provide for fair and equitable treatment of employees and meet legal standards established by State and Federal governments. This division is responsible for labor relations, employee relations, contract negotiations, compensation, benefit programs and administration, employment, training and organization development. Staff also provide support and guidance to the City's Human Rights and Diversity Commission. Objectives for coming year • Revise City's Personnel Resolution for 2000 • Complete a City wide personnel review audit Selected workload measures 1996 1997 1998 1999 Number of personnel transactions: Additions to staff/Terminations and retirements 16/13 22/17 20/15 N/A N/A not yet available Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $170,743 $198,410 $193,580 ($4,830) -2.43% Commodities $5,515 $10,000 $200 ($9,800) -98.00% Contractual Services $68,534 $73,165 $89,465 $16,300 22.28% Capital Outlay $8,103 $0 $0 $0 Total $252,895 $281,575 $283,245 $1,670 0.59% 18 COMMUNICATION SERVICES Activity Description The Communication Services area is responsible for a broad range of public information activities including: the Community Newsletter,written publications,press releases, Community bulletin board, cable TV, community surveys and forums, and the development and maintenance of the City's Web site. Staff is also responsible for coordinating internal communications. Objectives for coming year • Focus on coordinating public communications for all service areas • Establish an internal communicators committee to help identify and plan public information programs and communication materials • Produce promotional materials highlighting city services and the balanced use of property tax dollars • Produce informational/promotional materials for the vision 2001 celebration Selected workload measures 1996 1997 1998 1999 Files available on Web Site N/A N/A 143 175 Number of monthly website visits N/A N/A 1,000 1,500 Number of website hits(request)a month N/A N/A 4,200 9,000 N/A--not applicable Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $134,542 $183,266 $183,266 $0 0.00% Commodities $2,382 $1,200 $1,000 ($200) -16.67% Contractual Services $107,075 $126,550 $169,200 $42,650 33.70% Capital Outlay $0 $1,000 $25,050 $24,050 2405.00% Subtotal $243,999 $312,016 $378,516 $66,500 21.31% Transfers $10,000 Total After Transfers $368,516 19 Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $0 $0 $0 $0 Commodities $0 $0 $0 $0 Contractual Services $130,385 $149,415 $155,600 $6,185 4.14% Capital Outlay $0 $0 $0 $0 Total $130,385. $149,415 $155,600 $6,185 4.14% 22 COMMUNITY AND ECONOMIC DEVELOPMENT Activity Description The Community and Economic Development division is responsible for evaluating and regulating development in the City according to its Comprehensive Guide Plan,City ordinances,and metropolitan policies. It provides staff services to the City Council, Planning Commission, Board of Appeals & Adjustments, Flying Cloud Airport Advisory Commission, and Watershed Districts. These services include the implementation of the Comprehensive Guide Plan, administration of zoning ordinances and development agreements,review of development plans,gathering and evaluating information relating to individual development proposals and to development in general,preparation of notices of public hearings according to State law and Council policy, proactive and special study projects in community planning and development,housing studies,and administration of the Community Development Block Grant(CDBG)Program. This department has a significant amount of public contact. Staff members respond to inquiries from residents and reactors about development proposals and zoning regulations, and from developers and prospective businesses about demographic trends and development possibilities. The Department annually updates a community profile to provide the most up-to-date information. It also has numerous contacts with other units of government. The department is also responsible for the Historical Preservation activities of the City. The Eden Prairie Heritage Preservation Commission advises the City Council,and they coordinate events and activities of historical interest to the community. Through the Commission,the City supports Sunbonnet Day and the restoration of historical sites. Objectives for coming year • Prepare the Comprehensive Guide Plan Update • Update the land use and zoning maps • Support Web page for service areas • Structure a data base to move from paper files to optic and hard disk • Move processes from labor intensive to some self-serve Selected workload measures 1996 1997 - 1998 1999 Board of App.&Adj.Cases 40 54 22 22 Zoning Administration Cases 575 550 600 600 Development Proposals Reviewed 53 50 40 30 Residential Units Reviewed 808 475 500 600 Comm./Ind.Sq.Feet Reviewed 400,000 500,000 500,000 750,000 Development Agreements Prepared 40 35 35 20 Sign Permits 78 118 115 100 23 Budget Highlights The 1999 budget is similar to the 1998 budget. There is a slight increase in capital expenditures for furniture to replace the filing system and to add a work station. Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $410,852 $428,871 $428,871 $0 0.00% Commodities $5,666 $6,400 $6,400 $0 0.00% Contractual Services $10,331 $20,175 $20,175 $0 0.00% Capital Outlay $4,752 $8,000 $12,000 $4,000 50.00% Other Financing Uses $11,491 $6,120 $6,120 $0 0.00% Total $443,092 $469,566 $473,566 $4,000 0.85% Transfers $12,000 Total After Transfers $461,566 24 FACILITIES Activity Description The Facility Management Division has responsibilities that can be divided in four basic functions. These are described as follows: • Property Management Facility Operation and Maintenance •Lease Management •Utility Operations •Tenant Management and Relations •Repair •Property Management •Grounds Maintenance •Capital Budgeting •Custodial Services •ADA Compliance •Maintenance Management •Preventive Maintenance Program •Energy Operations Management Facilities Planning Facilities Support Services •Energy Management Planning •Food Service Management •Architectural and Engineering Services •Building Security •Construction and Renovation •Building Rentals •Space Planning and Management The Facility Management Division manages many of the City facilities. Consolidation of these functions allows greater efficiency and consistency of quality for public buildings. The following buildings and budget amounts are under this division for 1999: •City Center -8080 Mitchell Road •Police Building- 7900 Mitchell Road(vacant) •Public Works/Park Maintenance Building- 15150 Technology Dr. •Fire Stations No. 1 -7801 Mitchell Road(new station-14800 Scenic Heights Road will be completed in 1999) No.2- 12100 Sunnybrook Road No.3-7350 Eden Prairie Road No.5- 11800 Technology Drive •Senior Center-8950 Eden Prairie Road •Park Buildings(cleaning only) Miller Park Outdoor Center Staring Lake Park Round Lake Park Homeward Hills Park •Water Plant(cleaning only) •Den Road Building-8018 and 8020 Den Road(property management only) Objectives for coming year •Develop capital improvement,and capital maintenance plan for facilities •Complete construction of Fire Station#1 •Complete design,plans,bidding and construction of City Center Parking Deck •Plan and implement physical space reorganization at City Center to reflect organizational changes •Renegotiate lease with CH Robinson •Continue to provide quality services while monitoring selected workload measures 25 Selected workload measures 1996 1997 1998 1999 Square feet of custodial service 278,700 528,900 619,400 624,400 Square feet of maintenance and operation 247,100 487,200 500,200 605,200 Square feet of property management 320,000 320,000 333,000 333,000 Room rentals hours of use 7,100 9,000 9,000 plus 6,000* *Decline reflects construction impact on City Center Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $294,713 $362,819 $362,819 $0 0.00% Commodities $83,455 $77,300 $92,300 $15,000 19.40% Contractual Services $1,690,092 $1,886,310 $1,688,750 ($197,560) -10.47% Capital Outlay $482,905 $139,600 $215,000 $75,400 54.01% Total $2,551,165 $2,466,029 $2,358,869 ($107,160) -4.35% CAM Revenue ($580,419) ($613,459) ($612,459) ($1,000) -0.16% Net Expenditures $1,970,746 $1,852,570 $1,746,410 ($107,160) -5.73% Transfers $52,690 Total After Transfer $1,799,100 26 PARKS AND RECREATION Activity Description The Parks and Recreation Department provides a wide range of services including the planning, development, and maintenance of the trail system and park and recreation facilities.Other areas of responsibility include: forestry,recreation and athletic programs,Community Center,Outdoor Center,and the Senior Center. The City has acquired more than 1,900 acres of open space land,of which nearly 900 have been developed into 42 parks and conservation areas of varying sizes and functions. More than 70 miles of trails for biking, hiking and jogging have been constructed,which is three-fourths of the total planned off-road trail system.The department staff provide liaison services to the Parks,Recreation and Natural Resources Commission,the Heritage Preservation Commission,the Arts Commission,and the Community Education Board,and the various athletic associations and sport clubs within the community. PARK ADMINISTRATION Objectives for coming year • Complete design plans for the access road&parking lots at Flying Cloud Field • Renovate Preserve Park,replace play structure at Round Lake and Preserve Parks • Construct bike trail along Bryant Lake Drive,construct bike access and pedestrian access to Richard T.Anderson Conservation Area,and extend Smetana Lake Trail • Construct new park shelters at Miller,Riley and Preserve Parks • Develop first phase of new park-Crestwood Park • Complete concept site plan and management plan for the Richard T.Anderson Conservation Area • Complete management plans for the conservation areas Selected workload measures 1996 1997 1998 1999 Park plans-New parks/renovation 1 1 1 4 Install new or replace play structures 1 4 1 2 Construct/renovate bike trails(miles) 1 2 2 3 Construct/renovate park shelter 1 0 - - 1 4 Develop new parks 1 0 1 1 Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $126,294 $122,542 $122,542 $0 0.00% Commodities $570 $2,100 $2,600 $500 23.81% Contractual Services $15,326 $22,900 $22,700 ($200) -0.87% Capital Outlay $0 $3,300 $0 ($3,300) -100.00% Total $142,190 $150,842 $147,842 ($3,000) -1.99% 27 PARK MAINTENANCE Activity Description The Park Maintenance Division is responsible for the maintenance of nearly 900 acres of parkland in the City's 42 park areas. Recreational facilities that are maintained include two public beaches,three fishing piers,24 play stations,seven hockey rinks and open skating areas,51 baseball/softball fields,40 soccer fields,eight sand volleyball courts,four bocce courts,six horseshoe pits,47 tennis courts, 12 football fields,three rental picnic areas,two community garden sites, a lighted sledding hill,a marina,and more than 65 miles of bituminous bike trails. The passive areas of the park system include 1,000 acres of property that is not formally maintained. Maintenance is limited to removal of diseased and hazardous trees, periodic mowing of areas next to roads/homes, and periodically checking boundaries. Forestry activities within the City's 18,000-acre control zone include inspection of trees for such diseases as Dutch elm and oak wilt and coordination of removal of diseased trees from private and public properties. The Division also runs the reforestation program and supervises the City's tree nurseries. The City has received the Tree City USA award from the National Arbor Day foundation each year since 1981. Property management activities relate to posting park boundary markers,managing properties rented out by the City, and administering relocation assistance when necessary. Park maintenance staff manages the Pleasant Hill Cemetery on Pioneer Trail following transfer from private ownership in 1988. Objectives for comingyear • Evaluate park maintenance turf program and develop plan for turf management • Upgrade Nesbitt Preserve Park play area and park facilities • Work with DNR to manage milfoil infestation in Round Lake Park • Work with DNR and the MN Department of Agriculture on biological controls of leafy spurge Selected workload measures 1995 1996 1997 1998 1999 Diseased Trees-Elms 1,585 1,500 1,500 1,400 1,400 Diseased Trees-Oaks 77 40 40 50 40 Weed Violation Notices 45 50 60 60 50 29 Budget Highlights The 1999 budget is allocated to the following areas: Park maintenance $1,056,905 Tree disease 29,300 Tree removal 19,500 Deer Consultant 30,750 Reforestation 17,300 Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $738,667 $768,455 $753,455 ($15,000) -1.95% Commodities $109,806 $120,550 $120,550 $0 0.00% Contractual Services $257,341 $274,750 $279,750 $5,000 1.82% Capital Outlay $11,759 $5,000 $0 ($5,000) Total $1,117,573 $1,168,755 $1,153,755 ($15,000) -1.28% 30 PARKS CAPITAL OUTLAY Activity Description This division accounts for the capital improvement and capital equipment needs of the park system. Objectives for coming year • Replace Nesbitt Preserve Park play structure • Repair/overlay 3,000 feet of bike trails • Upgrade spraying equipment/accessories to improve fertilization/weed control of park turf areas. Budget Highlights Expenditures significantly decreased because budget requests of$67,000 were moved to the capital improvement program. These requests included park playground equipment and parking lot overlay projects. Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $0 $0 Commodities $0 $0 Contractual Services $54 $0 $0 $0 Capital Outlay $50,443 $88,400 $17,400 ($71,000) -80.32% Total $50,497 $88,400 $17,400 ($71,000) -80.32% 31 RECREATION PROGRAMMING Activity Description and Workload Measures All of the recreation program budgets(except the Community Center)have been combined for presentation in the budget. Recreation programming includes the following service areas: adaptive recreation,adult recreation,arts,beaches, Oak Point Pool, organized athletics, park facilities, recreation administration, special events, and youth recreation. The following describes the various recreation program service areas. Adaptive Recreation:The City serves approximately 300 registrants with disabilities;a third of those are Eden Prairie residents through adaptive recreation programs each year. Swimming,youth programs, skating, and special events are accessed by individuals with disabilities through inclusion services for a total of 200 registrations; 195 of those are Eden Prairie residents. Eden Prairie provides these services through a four city cooperative with Bloomington,Edina, and Richfield. Adult Recreation:The City serves approximately 8,500 adults/seniors each year through programs offered at the Senior Center,leisure and educational classes,special events,Senior Awareness Week,trips,and social services. This division primarily consists of Senior Center operations and adult/senior programs. Arts: The City serves approximately 12,200 individuals each year through arts programs. This division consists of programs and activities sponsored by the Eden Prairie Arts Commission. Through the Arts Commission, the City supports cultural arts programs such as the Staring Lake Concert Series,the Performing Arts Ensemble,the Community Band,Art on City Walls,and the annual arts festival. Beaches & Marina: The City operates two swimming beaches and a marina which are staffed by seasonal personnel. The City serves approximately 114,000 swimmers each year through the beaches at Round Lake Park and Riley Lake Park and the Round Lake marina. Oak Point Pool: This pool operates as a joint effort between the City and the School District. The City provides programming and staffing of the pool during non-school hours and non-school days. The City serves approximately 15,000 swimmers through the Oak Point Pool. Organized Athletics:The City serves approximately 630 teams and over 11,000 participants each year through adult athletic programs. Organized athletics provides a series of comprehensive sports programs to meet the needs of all interested residents and persons working full-time in Eden Prairie. This division assists local youth athletic associations and clubs with the use and maintenance of City outdoor athletic facilities for practices,games and tournaments. Park Facilities: This program consists of Outdoor Center operations and programs,and rental services for the Outdoor Center and other park facilities. The City serves approximately 1,000 participants each year through outdoor recreation and environmental education programs, and 300 rental groups through the Outdoor Center and other park rental facilities. Recreation Administration: This function coordinates the programs of the other recreation program service areas listed here and the Community Center operations and programs. Special Events: This program coordinates the special events of the City including the July 4th Celebration,DiverseCity on the Prairie,Oktoberfest,and numerous other special events offered by the City throughout the community during the year. The City serves approximately 35,500 individuals through community special events each year. Youth Recreation:The City serves approximately 15,000 participants each year through youth and family programs. In addition,over 27,000 skaters enjoy skating on the City's seven outdoor skating rinks or sliding on the Staring Lake sliding hill. 33 Objectives for Coming Year: • Establish touch tone registration for City recreation programs. • Establish a new lesson/practice golf facility on the north side of the Cummins Grill house. • Increase the use of the Outdoor Center and the Homeward Hills Park Building through public rentals to community and corporate groups. Budget Highlights . 1997 1998 1999 Program Actual Budget Budget Recreation Administration 93,915 104,272 101,972 Special Events 41,688 75,756 75,756 Beach&Marina 72,465 78,449 78,469 Oak Point Pool 188,108 223,902 222,244 Organized Athletics 223,611 195,809 196,909 Park Facilities 49,746 48,250 68,890 Recreation-Youth 246,284 253,794 237,094 Recreation-Adaptive 98,309 50,311 69,465 Recreation-Adult 145,120 181,005 179,345 Arts 32,664 63,531 70,231 Total $1,191,910 $1,275,079 $1,300,375 Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $689,271 $695,171 $705,245 $10,074 1.45% Commodities $72,074 $87,625 $87,825 $200 0.23% Contractual Services $383,886 $446,983 $451,225 $4,242 0.95% Capital Outlay $16,679 $14,300 $28,380 $14,080 98.46% Other Financing Uses $30,000 $31,000 $27,700 ($3,300) -10.65% Total $1,191,910 $1,275,079 $1,300,375 $28,596 1.98% Transfers $10,540 Total After Transfers $1,289,835 34 COMMUNITY CENTER Activity Description The Community Center offers a variety of facilities to the community including two ice arenas, swimming pool, fitness center,three racquetball courts and four meeting rooms. Swimming and skating lessons and pool and ice rentals are provided. The community center is also the site for numerous park and recreation programs. The Community Center is the main information and registration site for all city parks and recreation programs. Objectives for coming year • Implement Touch Tone Registration system • Implement the"Class"registration program to on-line operations(eliminate hard copy procedures)for more efficient and effective operations • Implement a facility preventative maintenance plan • Implement two community special events utilizing the entire facility to promote and bring traffic to the facility • Develop a youth open hockey program during the summer for better utilization of off peak ice time • Increase selections of food items in concessions for maximum profit • Develop a more competitive adult hockey league and adult racquetball league that will increase interest and revenue • Plan and implement swim and skate lesson marketing program • Maintain accurate usage counts for facility usage of members, non-members and rentals • Conduct comprehensive water safety programming • Establish adult wally ball leagues for increased racquetball court rental Selected workload measures 1996 1997 1998 1999 Number of Skate Lesson 1,474 1,500 1,500 1,500 Participants Number of Swim Lesson 2,720 3,000 3,000 3,000 Participants Number of Memberships Sold 315 325 - .325 400 Total Ice Rental Revenue $433,819 $442,770 $455,770 $514,200 Total Pool Rental Revenue $48,925 $32,000 $40,000 $42,000 Total Facility Revenue $879,488 $919,070 $967,100 $1,000,420 35 Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $493,695 $509,791 $485,095 ($24,696) -4.84% Commodities $144,893 $98,800 $105,200 $6,400 6.48% Contractual Services $267,290 $312,800 $311,300 ($1,500) -0.48% Capital Outlay $96,646 $98,575 $16,500 ($82,075) -83.26% Other Financing Uses $263,935 $269,200 $271,250 $2,050 0.76% Cost of Goods Sold $37,193 $22,000 $25,000 $3,000 13.64% Total $1,303,652 $1,311,166 $1,214,345 ($96,821) -7.38% 36 POLICE Activity Description It is the mission of the Police Department,in the interests of public safety,to protect and serve the community of Eden Prairie through: • The provision of quality services and law enforcement customized to meet the needs of the community,and • The application of discretion and fairness as a fundamental principle of the delivery of services and enforcement,and • The recognition that Department members are critical to the delivery of quality services. Professional development of members through leadership,education,training,and motivation will be critical to ensuring that a high quality of police service continues as the community changes and grows Objectives for comina year Traffic • Increase enforcement contacts by 10%with concentration on accident and complaint areas Visibility/Communications • Begin customer evaluation process • Implement Citizens'Academy Community Resource Network • Develop COP action plan • Develop"Senior Residents"action plan Training/Staff Development • Professional development program management • Supervisor in-service training • Conduct compliance audit and develop in-service training for mandates Response Strategies • Highway construction liaison • Identification and utilization of"outpost"locations to maximize response time • Technology upgrades(MDTs,traffic preemption) • Monitor and evaluate response times 37 Selected workload measures 1995 1996 1997 1998 1999 Part I Crimes 1,687 1,681 1,626 1,648 1,670 Part II Crimes 2,077 1,660 1,583 1,485 1,393 Arrests 2,267 2,545 2,666 2,708 2,750 Investigation Cases 1,634 1,580 *2,149 2,278 2,414 Cases Cleared 982 895 1,083 1,108 1,133 DWI Arrests 216 147 154 148 142 Medicals 1,001 1,002 1,065 1,135 1,210 Calls for Service 29,750 30,284 30,313 30,883 31,464 Citations/Warnings 7,016 5,945 7,662 7,826 7,993 *=This number reflects cases investigated and self-generated C.O.P.activities. Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $3,336,708 $3,421,745 $3,451,745 $30,000 0.88% Commodities $73,122 $111,425 $193,500 $82,075 73.66% Contractual Services $212,838 $287,400 $303,742 $16,342 5.69% Capital Outlay $119,777 $702,550 $118,300 ($584,250) -83.16% Total $3,742,445 $4,523,120 $4,067,287 ($455,833) -2.94% Transfers $287,392 Total After Transfers $3,779,895 38 CIVIL DEFENSE Activity Description The purpose of Civil Defense(Emergency Disaster Planning)is to prepare the community to meet any emergency that may occur from man-made or natural disasters. Activities include preparing contingency plans and training City employees and other persons in the various activities and operations necessary to save lives and property, minimize damage,and restore the community in the event of such disasters. Objectives for coming year • Add one siren to the outdoor warning siren program • Continue to work on certification of additional staff through State of Minnesota training program • Conduct a training session on Emergency Preparedness for Police/Fire/Public Works supervisory personnel Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $0 $0 $0 $0 Commodities $944 $3,000 $3,000 $0 0.00% Contractual Services $6,132 $16,450 $16,560 $110 0.67% Capital Outlay $9,109 $0 $2,500 $2,500 Total $16,185 $19,450 $22,060 $2,610 13.42% Transfers $2,500 Total After Transfers $19,560 39 ANIMAL CONTROL Activity Description Animal control activities are performed by the City to safeguard the public health and safety from diseases and nuisances which may be borne by animals.This enforcement function is structurally within the Police Department. Objectives for coming year • Increase public education on animal laws/ordinance • Increase public awareness of wildlife management issues(geese and deer) • Review and update current animal control ordinances Selected workload measures 1996 1997 1998 1999 Calls for service 1,956 1,963 1,975 1,985 Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $78,340 $79,573 $79,573 $0 0.00% Commodities $2,693 $2,500 $2,500 $0 0.00% Contractual Services $9,804 $16,725 $16,725 $0 0.00% Capital Outlay $0 $0 $0 $0 Total $90,837 $98,798 $98,798 $0 0.00% 40 FIRE Activity Description The Fire Department is responsible for the protection of life and property from the hazards of fire. This responsibility includes fire suppression and prevention. The City has authorized a complement of 75 volunteer firefighters and one full-time position within the Fire Department. The City also maintains mutual aid agreements with neighboring communities which provide Eden Prairie with additional personnel and equipment capabilities for fighting major fires and meeting the demands of a natural disaster. Objectives for coming year • Construct new Station 1 (relocation due to Highway 212)and integrate into neighborhood • Continued development/implementation of targeted recruitment(daytime responders) • Continue development of strategies to reduce response times Selected workload measures 1997 1998 1999 Fire,explosion 150 103 101 Over pressure rupture 8 7 7 Rescue calls 370 411 416 Hazardous condition 80 82 96 Service call 65 76 87 Good intent call 130 128 128 False call 400 406 425 Budget Highlights • Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $530,027 $558,440 $558,440 $0 0.00% Commodities $51,614 $68,300 $69,300 $1,000 1.46% Contractual Services $292,330 $355,500 $350,000 ($5,500) -1.55% Capital Outlay $56,985 $75,000 $84,400 $9,400 12.53% Total $930,956 $1,057,240 $1,062,140 $4,900 0.46% Transfers $26,400 Total After Transfers $1,035,740 41 INSPECTIONS Activity Description The Inspections Division provides a public safety function by ensuring that residential and non-residential buildings are constructed safely in accordance with a number of State and local Building and Fire Codes. The objective of the building, plumbing, mechanical and fire codes is to provide for minimum safety and construction standards so as to safeguard life, limb, health, property, and public welfare. The division's activities include plan review, on-site inspections,approvals for occupancy,permit issuance,collection of fees,and providing information to the public. It also issues water meters for new buildings and additional service lines. Objectives for coming year • Install new Logis program and computerize inspection scheduling by May 1999 • Issue 90%of all single family home permits with six working days • Issue 90%of all mail in permits within 24 hours of receipt • Issue 95%of all permits for decks,porches and basement finishes over the counter Selected workload measures 1996 1997 1998 1999 Building Permits 1,711 1,600 1,750 1,800 Other Permits 4,315 4,000 4,250 4,300 Total Permits 6,026 5,600 6,000 6,100 Construction Value $179,000,000 $115,000,000 $130,000,000 $135,000,000 Fees Collected $1,893,000 $1,545,000 $1,700,000 $1,800,000 Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $587,494 $674,294 $667,794 ($6,500) -0.96% Commodities $5,017 $5,600 $6,500 $900 16.07% Contractual Services $6,722 $9,000 $8,500 ($500) -5.56% Capital Outlay $27,924 $4,500 $6,000 $1,500 Total $627,157 $693,394 $688,794 ($4,600) -0.66% Transfers $5,900 Total After Transfers $682,894 42 ENGINEERING Activity Description The Engineering Division is responsible for all engineering relating to the design, construction, maintenance and operation of the City's physical facilities. Activities include the preparation of plans and inspection of construction for street,water,sewer,street lighting,street paving,traffic control,and other improvements in the City. The division also calculates special assessments for improvements which have benefits to private properties. It enforces subdivision ordinances by inspections and bonding requirements. In those instances where consultants provide engineering services, such work is supervised and under the direction of the Engineering Division. Objectives for coming year • Improve erosion control on construction sites • Completion of a comprehensive Public Works Capital Improvement Plan • Develop a proactive approach to traffic and transportation issues • Develop a time record keeping system to allow measurement of work tasks in the division • Continue a high focus on development review process Selected workload measures DESCRIPTION 1994 1995 1996 1997 1998 1999 Grading Permits Issued 20 20 25 25 25 25 Budget Highlights The 1998 budget reallocated funding for a vacant full time position into larger budget categories for overtime and consulting fees. The focus of the 1999 budget is a plan to bring the division back to full staffing by creating a traffic engineer position to provide emphasis in traffic management and transportation planning. Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $619,303 $669,914 $697,414 $27,500 4.11% Commodities $6,670 $11,500 $11,500 $0 0.00% Contractual Services $13,672 $50,100 $18,900 ($31,200) -62.28% Capital Outlay $41,601 $17,025 $29,250 $12,225 71.81% Total $681,246 $748,539 $757,064 $8,525 1.14% Transfers $16,750 Total After Transfers $740,314 43 STREETS AND TRAFFIC Activity Description The Street Maintenance and Traffic Division is responsible for the maintenance and repair of City streets and roads as well as the City's traffic control system. Activities include asphalt overlays,application of sealcoats,crack sealing,street sweeping,laying gravel,operation of traffic signals,snow/ice control,roadside mowing,trail/sidewalk maintenance,sign installation/replacement,pothole patching,and many miscellaneous as-needed services such as election polling site set- up. Objectives for coming year • Fill cracks in all streets that are to be seal coated by July 4 and complete pavement overlay by September 1 • Complete spring sweeping in ten to twelve days • Develop a relamping and preventative maintenance program for the signal system • Incorporate the Pavement Management System into the decision process for street maintenance • Commence a three year program to complete installation of Emergency Vehicle Pre-emption system on all signals in the City Selected workload measures DESCRIPTION 1995 1996 1997 1998 1999 Miles of City Streets&Roads 205 206 207 208 208 Patching Materials(tons) 1,500 1,600 2,200 2,000 2,000 Overlays(tons) 10,064 9,366 17,340* 7,075 8,000 Crack Filling Material(lbs) 32,700 40,000 0 42,265 40,000 Plow&Sanding(hrs) 2,270 5,232 3,786 3,500 3,500 Seal Coating(sq yds) 330,371 441,489 0 _ 400,000 400,000 *=Deleted sealcoat in 1997 and approximately doubled overlays 45 Budget Highlights Increases in commodities include $7,000 for street maintenance and $6,000 for snow & ice control. Increases in contractual services include amounts for asphalt overlay, contracted crack filling and seal coating. Capital outlay includes $81,000 for emergency vehicle preemption installations, $40,000 for an elevator in the Parks/Public Works Building,$12,000 for a card entrance system on eight doors,and$15,000 for a concreted saw and blades. Increase/Decrease 1997 1998 1999 Category Actual Budget Estimated Amount Percent Personal Services $651,056 $656,032 $656,032 $0 0.00% Commodities $146,207 $148,095 $164,800 $16,705 11.28% Contractual Services $611,977 $650,450 $689,800 $39,350 6.05% Capital Outlay $49,450 $139,325 $24,200 ($115,125) -82.63% Total $1,458,690 $1,593,902 $1,534,832 ($59,070) -3.71% Transfers $5,100 Total After Transfers $1,529,732 46 FLEET SERVICES Activity Description The Fleet Services Division provides a program of preventive maintenance,repair,and operational supplies for the City's fleet of over 240 vehicles and equipment. The division also manages the purchase,sale,and trade in of the fleet(See Vehicles and Related Equipment). Objectives for coming year • Increase hours of equipment availability by completing preventative maintenance before or after operating hours. • Decrease lost time due to trailer"break-downs"by completing yearly inspection on all trailers. • Increase spending on vehicle body repairs to improve image,driver pride,and salvage value. Selected workload measures 1996 1997 1998 1999 Preventive maintenance performed after operating hours. 219 300 350 400 Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $237,082 $294,000 $294,000 $0 0.00% Commodities $314,690 $338,500 $342,500 $4,000 1.18% Contractual Services $77,300 $89,000 $94,000 $5,000 5.62% Capital Outlay $39,177 $35,500 $45,500 - $10,000 28.17% Other Financing Uses $0 ($7,500) ($7,500) $0 0.00% Total $668,249 $749,500 $768,500 $19,000 2.54% Transfers $13,000 Total After Transfers $755,500 47 STREET LIGHTING Activity Description Street lighting in the City is the responsibility of the Public Works Department. Over 95%of the City's street lighting system is provided and operated by Northern States Power Company. This budget reflects the City's contractual cost for NSP to operate and maintain this system as well as for the several small systems owned by the City. In new subdivisions, developers are required to pay for the first three years of street lighting costs. After that,this cost becomes a City responsibility. Some older subdivisions in the City do not have complete street lighting. Accordingly, an amount is included in each year's budget to cover additional street lights for existing neighborhoods,which are then installed on a petition basis. Objectives for coming year • Maintain and operate City owned light systems which includes Viking Drive,Golden Triangle Drive,City West Parkway,and Prairie Lakeside. • Check street lights twice per year for system failures and notify NSP as appropriate. Selected workload measures 1996 1997 1998 1999 City owned&maintained 121 121 121 121 NSP owned&maintained 2,678 2,734 2,777 3,000 City owned,NSP maintained 72 72 73 73 Purchase option,NSP maintained 109 108 121 121 Total 2,980 3,035 3,092 3,315 Budget Hijghlights A small increase is budgeted for street lighting in existing neighborhoods. - Increase/Decrease 1997 1998 1999 Amount Percent Category Actual Budget Proposed Personal Services $1,834 $0 $0 $0 Commodities $2,093 $3,000 $3,000 $0 0.00% Contractual Services $575,210 $608,500 $613,500 $5,000 0.82% Capital Outlay $0 $0 $0 $0 Total $579,137 , $611,500 $616,500 $5,000 0.82% 48 GENERAL SHARED SERVICES Activity Description The City uses the concept of"shared services"program budgets for activities which serve the City organization as a whole,and/or are too cumbersome or costly to assign to the individual budgets within the Budget document. General Shared Services includes miscellaneous items related to the operation of the City including telephone operations,rental of office machines, postage, office supplies, publication of legal notices, centralized copying and floating secretarial coverage. Objectives for coming year • Integrate water plant and liquor stores into the City phone system • Provide floating secretarial coverage of offsite locations and other clerical support functions • Consolidate printing needs from all service areas to maximize in-house service utilization and coordinate cost effective outsourcing Selected workload measures 1996 1997 1998 1999 Postage utilization 43,716 40,000 41,250 43,000 Amount spent on bulk vs 1st class mail 15,815/40,000 12,455/40,000 13,500/40,000 15,000/42,000 Copies generated in-house 1,669,111 1,365,776 1,500,000 1,650,000 Budget Highlights Risk management activity of$307,900 was moved to a newly created risk management division. Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $57,383 $52,402 $52,402 $0 0.00% Commodities $60,036 $47,000 $48,400 $1,400 2.98% Contractual Services $439,445 $478,242 $199,380 ($278,862) -58.31% Capital Outlay $1,070 $0 $1,500 $1,500 Total $557,934 $577,644 $301,682 ($275,962) -47.77% Transfers $400 Total After Transfers $301,282 49 RISK MANAGEMENT AND CUSTOMER SERVICE Activity Description The Customer Service and Risk Management Division is responsible for the City Center and Police Customer Service Desks,PrairieLine hotline,phone and voicemail administration,the Employee/Management Safety Committee,Liability Insurance,Workers Compensation and related employee health and safety programs. Objectives for coming year • Conduct request for proposal(RFP)and evaluation for City's liability insurance provider Selected workload measures 1996 1997 1998 1999 Number workers comp claims managed 33 40 Varies Varies Number of lost time claims managed 3 3 Varies Varies Number of drug tests administered 54 63 60 plus 60 plus Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $23,140 $0 $0 $0 Commodities $461 $0 $10,000 $10,000 Contractual Services $837 $0 $297,900 $297,900 Capital Outlay $0 $0 $0 $0 Total $24,438 $0 $307,900 $307,900 50 INFORMATION TECHNOLOGY Activity Description The Information Technology Division includes data processing and communication equipment and services. Data Processing The City of Eden Prairie is a member of LOGIS(Local Government Information Systems),a consortium of 29 cities and other entities,most of which are metropolitan-area suburbs. Mainframe computers are housed at LOGIS headquarters in Brooklyn Center. Under this shared-time and shared-resource system,the City is able to have data processing and equipment procurement at very favorable rates. LOGIS has several data processing modules. Among those modules used by the City and shown in this budget are: Financial Systems,Fixed Assets,Accounts Receivable and Payable,Payroll,Property Data,Special Assessments,Human Resources, Internet Access,Park/Recreation Scheduling and WAN/LAN network services. Not included in this budget are the police records and dispatch systems,utility billing system(utility billing is provided by Logis but budgeted to Utilities),fire department,or systems for the various enterprise fund activities. 1999 is the first year data processing purchasing for hardware,software,and contracted services will be centralized to take advantage of data processing personnel expertise and to more efficiently use data processing resources City-wide. Communications Communications includes the purchase and maintenance of the City's pagers and radio systems. Obiectives for coming year • Complete Year 2000 compliance process • Implement new software suite city wide • Investigate and implement Imaging system • Connect new fire station and liquor stores in Eden Prairie to cities'wide area network • Complete hardware and software replacement plan • Implement Groupwise Library system for users to access files remotely • Investigate and determine schedule the"roll out"of Windows 98 • Upgrade existing Novell 4.11 Server to Netware 5 and upgrade RAM memory in existing Novell Server • Research and implement electronic packet • Complete a data security audit to include workstations,local area network and wide area network • Implement Information Systems Policies and Procedures • Work with school district on video conferencing project and other technology related projects 51 Budget Highlights The 1999 budget reflects a ten percent increase for LOGIS,the addition of the Park and Recreation dial-in registration system,and amount budgeted for year 2000 compliance issues. Capital expenditures shows a significant decrease. Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $0 $48,400 $48,400 $0 Commodities $0 $0 $0 Contractual Services $164,585 $198,000 $276,600 $78,600 39.70% Capital Outlay $121,152 $120,000 $8,500 ($111,500) -92.92% Subtotal $285,737 $366,400 $333,500 ($32,900) -8.98% Transfers $342,700 Total After Transfers $676,200 • 52 LEGAL COUNSEL Activity Description State law requires that each City have a City Attorney. Under the Plan B form of government, the City Attorney is appointed by the City Manager with the consent of the Council. Since 1978,the City has retained the services of Lang,Pauly,Gregerson,&Rosow Ltd.to handle the City's legal affairs. The firm provides assistance to the City Manager, City Council, and staff on questions of law,represents the City in court actions,and prosecution. Objectives for Coming Year: • Review general legal services • Increase use of technology to enhance communications and to transfer information between the City and Attorney's office. Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $0 Commodities $0 Contractual Services 0% General $108,271 $150,000 $150,000 $0 Contractual Services 0% Prosecution $133,787 $125,000 $125,000 $0 Capital Outlay $0 Total $242,058 $275,000 $275,000 $0 0% 53 • EMPLOYEE BENEFITS AND TRAINING Activity Description Employee Benefits & Training includes the operating costs associated with managing and developing the City's workforce. Expenses include: • Wage adjustments based on maintenance of the Merit and Step programs,an economic adjustment to the pay structure and compliance with the pay equity mandate of the State of Minnesota. • The mandated program costs of Workers Compensation, Social Security, FICA, Unemployment and Public Employees Retirement Association. • The City's contribution toward the Employee Benefit program (health, basic life, dental reimbursement and long-term disability insurance). • Management and employee training and development,including conferences,workshops and in-house training. • Business meeting expenses for Council and staff and professional organization membership dues. Objectives for coming year • Implement a software tracking&reporting system for the dental reimbursement program • Implement a police uniform purchase program • Investigate feasibility of PEBSCO-post employment health plan Selected workload measures 1996 1997 1998 1999 Avg.training expenditure per employee 245 256 293 300 Budget Highlights Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Personal Services $2,033,546 $2,262,532 $2,447,942 $185,410 8.19% Commodities $3 $500 $1,000 $500 Contractual Services $139,735 $124,850 $134,485 $9,635 7.72% Capital Outlay $0 $0 $0 $0 Total $2,173,284 $2,387,882 $2,583,427 $195,545 8.19% Wage Adjustments $365,000 $426,617 $478,163 $51,546 12.08% Total Budget $2,538,284 $2,814,499 $3,061,590 $247,091 8.78% 54 CONTINGENCY Activity Description A contingency fund is established to provide for unanticipated opportunities and expenses which may be authorized during the budget year. Objectives for coming year • Manage contingency account and authorize expenditures as necessary Budget Highlights A small contingency is budgeted for unexpected essential purchases throughout the year. Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent Commodities $0 Contractual Services $0 Capital Outlay $0 Contingency $141,537 $140,000 $154,000 $14,000 10.00% Total $141,537 $140,000 $154,000 $14,000 10.00% 55 VEHICLES AND RELATED EQUIPMENT Activity Description The Fleet Services Division of Public works administers the purchase and replacement of a fleet of over 240 vehicles and related pieces of equipment for the City,except major pieces of fire equipment. Based on original purchase prices, the fleet is worth over $5 million. Centralizing management of fleet purchases and operations provides greater opportunity to gain the maximum economic use of vehicles and equipment. Eventually, this function should become an"internal enterprise,"with costs assigned against City departments based on their use of the fleet. Vehicles and related equipment are rotated through the fleet so that the annual appropriation is stable and predictable- approximately$550,000 to$610,000 in net costs projected through 2003. Objectives for coming year • Continue reallocation of vehicles between departments to balance mileage and age to optimize salvage value • Decrease number of assigned vehicles in general government by increasing shared use of the motor pool • Develop a plan for departmental assignment of user fees for replacement, operation, and maintenance of assigned vehicles • Work with Public Safety to develop a replacement schedule for major equipment for the Fire Division. Selected workload measures 1996 1997 1998 1999 Miles driven in pool vehicles 7,500 9,000 9,000 12,000 Budget Highlights In 1999,21 vehicle/pieces of equipment will be replaced. Disposal of used vehicles will be in accordance with State mandated guidelines with City Council authorization. A salvage value estimate is included in the replacement schedule. Due to hail damage to 63 City vehicles,salvage values are expected to be lowered over the next three to five years. Increase/Decrease 1997 1998 1999 Category Actual Budget Budget Amount Percent General Government $15,140 $50,600 $18,000 ($32,600) -64.43% Parks&Recreation $251,090 $156,500 $158,000 $1,500 0.96% Public Safety $201,984 $230,600 $190,000 ($40,600) -17.61% Public Works $109,208 $200,200 $286,000 $85,800 42.86% Sub-total $577,422 $637,900 $652,000 $14,100 2.21% Salvage ($27,096) ($114,500) ($116,000) ($1,500) 1.31% Total $550,326 $523,400 $536,000 $26,700 2.41% 56 City of Eden Prairie 1999 General Fund Proposed Budget Summary of Capital by Department Department Total General Government Elections $10,000 City Manager 2,500 Assessing 2,800 Communication Services 25,050 Community Development 12,000 Facilities 15,000 Parks and Recreation Parks Capital Outlay 17,400 Recreation Programming 28,180 Oak Point Pool 200 Community Center 16,500 Public Safety Police 118,300 Civil Defense 2,500 Fire 84,400 Inspections 6,000 Public Works Engineering 29,250 Streets and Traffic 24,200 Fleet Services 45,500 Shared Services General Shared Services 1,500 Information Technologies 8,500 Total $449,780 57 City of Eden Prairie 1999 General Fund Proposed Budget Computer Budget Department Department Description Request City Manager Replace computer 2,000 Communication Services Laptop/speakers for portable presentations 2,500 Multimedia workstation PC/speakers/ZIP drive/monitor 5,000 RAM for printer in HR/Communications 200 Economic Development Computer replacement 2,000 Counter computer for customers 2,000 Police 2 HP Laser printers 4,000 Scanner 300 Color photo printer 300 Replace 4 personal computers 5,400 Novell LAN upgrade 3,800 Fire Computer for admin/department secretary 2,000 Building Inspections HP Vectra computer 2,000 Engineering Color printer photo quality 600 Four new computers 8,000 Information Technologies Laptop computer 2,500 GIS equipment and software 6,000 Total S48,600 58 City of Eden Prairie 1999 General Fund Proposed Budget Software Budget Department Department Description Request Assessing Hennepin County connection charges 2,800 Communication Services Upgrade to Pagemaker or Quark 1,000 Police CD Rom resource for phone numbers and address 1,500 Link to Hennepin County Court system 2,000 Engineering Crystal reports software 600 ITC road reporter software 750 SITE survey upgrade 750 Traffic analysis software 2,500 Fleet Services Engine analyzer software update 5,000 Total $16,900 59 City of Eden Prairie 1999 General Fund Proposed Budget Office Furniture Budget Department Department Description Request City Manager Shelves for record room 500 Community and Economic Development Replace file cabinets 6,500 Add work station 1,500 Parks-Adult Recreation 2 wooden unfinished bookcases 650 Parks-Adult Recreation Elba table on costers 340 Parks-Adult Recreation 4 Tolleson side chairs 550 Parks-Parks Facilities Replace lounge furniture 6,600 Parks-Parks Facilities 10 6'conference tables 1,500 Parks-Parks Facilities Window blinds 700 Parks-Oak Point Pool Replace broken chairs and table in lobby area 200 Police New office chairs-Police 10,000 Police Resource room furniture-chairs,table,filing cabinet 1,500 Police Chairs 5,000 Police Training storage cabinet 6,000 Facilities Blinds for exterior windows 10,000 Facilities Plan and file storage 5,000 Civil Defense Modular furniture 2,500 Fire Six chairs to replace in Communications rooms 2,400 Building Inspections Replace two existing desk chairs 900 Reconfigure three computer stations 2,100 Engineering Two chairs to replace worn units 850 Modular work surface 1,200 Streets and Traffic Overhead cabinets&office chair 1,200 Total $67,690 60 City of Eden Prairie 1999 General Fund Proposed Budget Communication Equipment Budget Department Department Description Request Police Radar equipment 5,250 Radios 29,050 Three cellular phones 600 Two portable radios 2,800 Twelve fire pagers 4,900 Tools and test equipment 30,000 Fire Radios 22,000 Total $94,600 61 City of Eden Prairie 1999 General Fund Proposed Budget Capital Improvements Budget Department Description Amount Parks-Community Center Pool Lane lines 5,000 Parks-Community Center Electric garage door in Rink 1 4,000 Parks-Community Center Racquetball courts reline/resurface 3,000 Parks-Community Center Redo 10 door lock tumblers for security 1,500 Parks-Community Center Entrance door into players bench(west side)Rink 2 1,500 Parks-Community Center Concession stand cash register 1,500 Total $16,500 62 City of Eden Prairie 1999 General Fund Proposed Budget Additional Capital Budget Department Description Amount Elections 40 voting booths 10,000 Communication Services Two VCR's 600 Communication Services One color TV monitor 450 Communication Services One document white board 3,000 Communication Services Misc.camera/lens equipment 1,000 Communication Services Data/video projector 5,800 Communication Services Video camera replacement of Council Chambers 5,500 Parks-Capital Outlay Panel saw 2,000 Parks-Capital Outlay Bale chopper/mulcher 6,000 Parks-Capital Outlay Hoist-woodshop 1,500 Parks-Capital Outlay Eight BBQ grills 900 Parks-Capital Outlay Pressure washer 2,100 Parks-Capital Outlay Parts cleaner 500 Parks-Capital Outlay Insty grader 3,500 Parks-Capital Outlay Automatic(spray control) 500 Parks-Capital Outlay Hydraulic ram for tractor 400 Parks -Organized Athletics Four volleyball referee stands 1,000 Parks -Youth Programs Gymnastic equipment 300 Parks-Beaches 5 horse power motor 1,000 Parks-Art Lighting equipment for Theater productions 2,700 Parks-Parks Facilities Audio/visual and meeting room equipment 2,500 Parks-Parks Facilities 2'Refrigerators 2,000 Parks-Parks Facilities 2 Microwaves 340 Parks-Parks Facilities 8-12 Picnic tables 6,000 Parks-Parks Facilities 4 picnic grills 2,000 Police Softbody armor 5,900 Fire Copier for Station 1 8,000 48,000 Misc fire equipment 2,000 Building Inspection Fax machine 1,000 Engineering Plan size Xerox to replace aging unit 12,000 Misc.survey equipment 1,000 Digital camera 1,000 Streets and Traffic Concrete saw and blades 15,000 Streets and Traffic Trailer(to haul saw) 4,000 Streets and Traffic Sign truck equipment Streets and Traffic (Generator,air compressor,bucket) 4,000 Fleet Services Replace oil filter crusher 2,000 Replace bandsaw 3,500 New car equipment 35,000 General Services Laminator 1,500 Total S205,490 63 WATER ENTERPRISE Activity Description The City of Eden Prairie's water enterprise consists of the following main areas: Water Sampling Water Treatment Plant and Residuals Water Wells Water Storage Meter Reading and Repair System Maintenance Water Sampling and Inspections Inspections of construction sites determine that finished work complies with the City construction standards and sampling occurs prior to allowing the project to be activated and used to convey water for consumption. In other words,free from bacteria and safe to drink. Water system sampling is similar to the construction sampling function, except that it deals with our existing water distribution system. There are 64 sampling points in the community that are representative of our entire water system collectively. Each site is sampled monthly and tested for coliform bacteria. Each day,one of these sites is sampled and tested for fluoride and chlorine content as required by the Minnesota Department of Health. Water Treatment Plant and Residuals The City of Eden Prairie operates a lime-softening water plant with a capacity of 28 million gallons per day. The plant is operated on two schedules. During winter months,from November to April,the plant operates with two shifts of eight hours each. Water production during this time averages 5 million gallons per day. During the summer months from May to October,the shifts are expanded to 12 hours each. The production rates vary during this time of the year from 6 to 18 million gallons per day,all weather related. The expansion to the plant was operational in April, 1998. The operation of a water treatment plant and the product,water,is a very highly regulated industry utilizing a complex process and associated equipment. In addition to water production,operators perform daily chemical analysis to verify compliance with regulatory requirements and perform much of the preventative maintenance and repairs on equipment in the plant and at our 11 wells. High housekeeping standards are maintained throughout all facilities. The by-product of a lime-softening plant process--residuals--has been stored in lagoons in the past. Mechanical dewatering equipment installed in the plant began operating in the spring of 1998. Residuals disposal is now a seven- day-a-week activity being performed on a contract basis. Water Wells The City currently has 12 wells to supply water needs. At least one additional well will be constructed in 1999. Two of the wells have natural gas-fired engines to mechanically pump water directly to the system during emergencies. After the initial costs to construct the wells and houses,the primary annual costs are electric service to power them and a five- year preventative maintenance cycle on each well pump and motor.An aquifer management system will be completed in 1998 that will provide reliable data on which to base pumping schedules and preventative maintenance. 65 Water Storage The City's three gravity(above ground)storage reservoirs are located on Baker Road at Townline Road(Baker Road) 2 million gallons,Dell Road at Twilight Trail(Hidden Ponds) 1 million gallons,and Glen Lane(Marketcenter)2 million gallons. These facilities"float"on the water system and are filled during off-peak times and supply a reserve to the City during peak usage times or fire flows when demand exceeds pumping levels. During the winter schedule,the reservoirs supply water to the City when the treatment plant is shut down from 11:00 p.m.to the following morning start up. Water Meter Reading and Repair The City of Eden Prairie has approximately 16,000 utility accounts. Historically,utility staff read each meter quarterly for billing purposes. This is an activity that occurred in a two week window each month. Council awarded a contract to RMR for reading residential meters in 1998. The primary expenditure for meter repair is for replacement parts(meters)and purchase of meters for resale. Staff time to install meters in new homes and change out existing meters to the new SENSUS touchpad and commercial/industrial radio read system is included in this budget category. In 1999,$8,000 is budgeted to do meter changeouts to replace more older meters than can be accomplished with city staff alone. System Maintenance System maintenance includes most of the non-plant function of the water enterprise fund. It includes inspection of newly constructed watermains,flushing of the distribution system to maintain water quality,exercise fire hydrants, repair to fire hydrants, operating water main valves annually, leak detection, water main isolation for system repairs, utility locations,water service turn-on/turn-offs and water quality investigation. Objectives for coming year • Meet or exceed Safe Drinking Water Standards • Develop and train new utility operators to reach Step Level C • Computerize a data system to monitor project status • Complete an exercise and assessment on valves in 50%of the distribution system • Flush entire distribution system,maintain and•repair fire hydrants • • Implement a preventative maintenance program/schedule for hydrant painting,air relief manholes,well houses, reservoirs and leak detection 66 Selected workload measures 1995 1996 1997 1998 1999 Water pumped(million gallons) 2,266 2,662 2,481 N/A 2,600 Number of customer accounts N/A N/A N/A 15,761 16,000 (Active meters-fire meters) Customer generated work orders 390 433 416 N/A 450 Miles of watermain/Number of hydrants 218/3,079 223/3,197 227/3,307 N/A 230/3,400 Meter repairs/change outs/new 1,627 1,543 1585 N/A 1,800 installations Hydrant repairs 117 120 85 N/A 100 Gopher State One-Calls 190 312 350 N/A 400 N/A=not yet available Budget Highlights • Replacement of tractor backhoe to be financed equally from the water utility and storm water utility($33,000 each) • Replacement of the meter van($25,000) • Replacement of the meter reading instruments($23,000). The new instruments will be able to read meters from more than one vendor. • Nine of our existing wells will be retrofitted with Variable Frequency Drive's(VFD's)($135,000). This will allow all our wells to be operated at a peak efficiency at variable pumping rates. It is expected that this cost can be recovered in a five-seven year time frame through reduced electrical costs. Additionally,the ability to vary pumping rates is an integral part of the aquifer management program being installed in 1998. • Wells 8, 11 and 12 are scheduled for inspection and preventative rehabilitation in 1999($108,000). This is a planned five-year rotating schedule. 67 SEWER ENTERPRISE Activity Description The City of Eden Prairie's sewer enterprise consist of the following operations: General Lift Stations System Maintenance Accounting General This program identifies those features of the sewer collection function that have common elements such as uniforms, employee benefits,and the primary element of the budget--waste disposal. Waste disposal costs are established by the Metropolitan Council Environmental Services(MCES)at a metropolitan-wide basis. Sewer Lift Stations Lift stations are mechanical devices that pump sewage from low-lying areas into the gravity sewer system. This program is identified separately to monitor the cost of operation and maintenance of these facilities. Sewer System Maintenance This program accounts for the majority of the staffing effort necessary to maintain the sanitary sewer collection system. Duties include inspection of newly completed sewers prior to acceptance by the City,cleaning and repairing existing sewer lines and manholes. Most of the effort in this area is spent on preventive maintenance and inspection of the existing facility. Sewer Accounting This program is performed concurrently with water utility accounting but is listed separately for budget tracking purposes. Objectives for coming year • Complete a manhole assessment for 50%of system • Clean 25%of the system annually • Implement a preventative maintenance program/schedule for re-occurring"trouble spots" • Continue preventative maintenance program for 16 lift stations • Develop and organize a parts maintenance inventory for lift station 69 Selected workload measures 1995 1996 1997 1998 1999 Miles of sewer 198 203 208 N/A 212 Number of lift stations 14 14 16 16 16 Miles of sewer cleaned 24 19 8 N/A 35 N/A=not available Budget Highlights • Purchase of a mini-inspection camera to allow remote inspection of sewer lines to facilitate maintenance and reports($10,000). • Upgrade the alarm system for all 16 lift stations($24,000). • In 1998,MCES began a new billing process. Instead of paying a monthly bill based on 1/12 of estimated flow, the monthly billing is 1/3 of actual quarterly flows on a three-month lag(i.e.,the June, 1998 bill was 1/3 of actual flows for January,February and March, 1998). Estimating disposal costs for 1999 are therefore more susceptible to weather conditions. The amount for 1999 was maintained at 1998 levels due to a proposed reduction in MCES budget of 10%for 1999. 70 City of Eden Prairie 1999 Water&Sewer Proposed Budget 1998 Actual 1999 1997 1998 10/31/98 Proposed Actual Budget (Unaudited) Budget Operating Revenues: Sales $ 5,757,369 $ 6,422,772 $ 4,491,825 $ 6,450,000 System access charges(1%SAC) 9,965 10,000 0 10,000 Sale of meters 18,437 15,000 0 15,000 Penalty charges 22,547 19,000 0 20,000 Other 37,853 1,000 3,310 1,000 Total Operating Revenues 5,846,171 6,467,772 4,495,135 6,496,000 Operating Expenses: Personal services 1,254,492 1,422,300 1,084,236 1,415,732 Chemicals and supplies 361,312 454,400 320,590 390,020 Contractual services 687,079 655,370 536,884 660,000 Repairs and maintenance • 480,630 609,600 360,174 660,930 Disposal charges 2,638,734 2,700,000 2,050,683 2,700,000 Utilities 373,943 372,850 350,470 393,850 Total Operating Expenses 5,796,190 6,214,520 4,703,037 6,220,532 Operating income(loss)before depreciation 49,981 253,252 (207,902) 275,468 Depreciation: Equipment 116,556 82,000 0 115,000 Infrastructure 1,020,303 0 0 0 Total Depreciation 1,136,859 82,000 0 115,000 Operating income(loss) (1,086,878) 171,252 (207,902) 160,468 Nonoperating Revenues(Expenses): Interest on investments 75,489 65,000 0 65,000 Special assessments 10,497 0 58,640 0 Loss on investment 0 0 0 0 Gain on sale of fixed assets 7,696 0 0 0 Total Nonoperating Revenues(Expenses) 93,682 65,000 58,640 65,000 Income(loss)before Operating Transfers (993,196) 236,252 (149,262) 225,468 Operating Transfers Out (50,000) (50,000) 0 (50,000) Net income(loss) (1,043,196) 186,252 (149,262) 175,468 Add back: for depreciation charged to contributions in aid to construction 1,020,303 0 0 0 Increase(decrease)in Retained Earnings (22,893) $ 186,252 (149,262) $ 175,468 Retained Earnings,January 1 1,172,599 1,149,706 Retained Earnings,(deficit)December 31 $ 1,149,706 $ 1,000,444 71 72 STORM DRAINAGE ENTERPRISE Activity Description In advance of a Water Quality plan,projects are scheduled on an as needed basis. A final list for 1998 has not been developed. However,the demand for repairs and maintenance has typically approached the budget amount of$50,000. Objectives for coming year • Implement a priority system for additional street sweeping in addition to spring clean-up(Street Division) • Assess and repair structures in advance of seal coat and overlay projects(Streets and Utilities) • Review and revise storm sewer lift station specifications(Utilities and Engineering) • Complete storm water plan and local water management plan • Develop a capital improvements program based on results of the completed Local Water Management Plan. Selected workload measures 1995 1996 1997 1998 1999 Number of sump catch basins/c.y. 449/548 477/589 502/429 N/A 520/600 removal Miles of sewer 121 126 131 N/A 135 Structures repaired 51 57 63 N/A 100 N/A=not available Budget Highlights • Replacement of tractor backhoe--shared with water enterprise($33,000). 73 City of Eden Prairie 1999 Storm Drainage Fund Proposed Budget 1998 Actual 1999 1997 1998 10/31/98 Proposed Actual Budget (Unaudited) Budget Operating Revenues: Sales $ 522,974 $ 550,000 $ 410,955 $ 565,000 Penalty charges 2,058 0 Other 57,874 0 Total Operating Revenues 582,906 550,000 410,955 565,000 Operating Expenditures: Personal services 94,622 154,000 132,567 126,582 Chemicals and supplies 11,577 0 5,680 100 Contractual services 146,012 356,000 43,444 126,400 Repairs and maintenance 72,029 90,000 69,118 90,000 Utilities 1,035 0 918 1,500 Total Operating Expenses 325,275 600,000 251,727 344,582 Operating income (loss) before Depreciation 257,631 (50,000) 159,228 220,418 Depreciation: Equipment 36646 0 0 35,000 Operating income (loss) 220,985 (50,000) 159,228 185,418 Nonoperating Revenues(Expenses): Special assessments 13,177 0 28,062 Gain on sale of fixed asset 0 0 Total Nonoperating Revenues(Expenses) 13,177 0 28,062 0 Income(loss) before Operating Transfers 234,162 (50,000) 187,290 185,418 Operating Transfer Out (10,000) (10,000) - 0 (10,000) Net income(loss) 224,162 $ (60,000) 187,290 $ 175,418 Retained Earnings (deficit), January 1, 536,130 760,292 Retained Earnings December 31 $ 760,292 947,582 74 City of Eden Prairie 1999 Capital Budget Summary Utilities Fund Department Description Amount Water Software $17,500 Other equipment 15,000 Inspection camera, leak detector 12,650 Cargo van replacement, 1/2 Tractor backhoe 58,000 Furniture 1,500 Office equipment 500 Other equipment 5,000 Subtotal Water $110,150 Sewer 0 Subtotal Sewer $0 Storm Drainage Software 1,500 1/2 Tractor backhoe 33,000 Subtotal Storm Drainage $34,500 Grand Total $144,650 75 LIOUOR STORES Activity Description The City currently operates three municipal liquor stores;they were established in 1977, 1992,and 1997. As planned, the City closed the Preserve Liquor store at the end of June 1997 when the Den Road liquor store opened for business. It is the City's policy that profits generated by municipal liquor operations be transferred to the General Fund for use in park and recreation and/or public safety improvements. Eden Prairie continues to have one of the largest municipal off-sale operations in the State. During 1997 sales were$4,977,938,an increase of about 3.0%more than 1996 sales of$4,813,208. Preliminary figures from the end of October 1998 totaled$4,915,928. 1999 Adopted Budget-All Liquor Stores Because of the strategic location of the new Den Road store,strong financial performance is expected in 1999. On an overall basis,sales have been estimated at$6,100,000. Operating income of$435,016 is projected for 1999. The 1999 transfer to the general fund is adopted in the General Fund at $420,000. Expenses totaling $1,039,584 have been estimated. Objectives for coming year • Implement perpetual inventory system • Review merchandising/store presentation • Adjust staffing levels. Add a liquor operations manager position to manage all stores,hire an inventory control clerk,review part-time employee status • Upgrade the level of customer service by training and appropriate policies • Increase the use of technology • Implement performance measures 77 City of Eden Prairie 1999 Liquor Fund Proposed Budget 1998 Actual 1999 1997 1998 10/31/98 Proposed Actual Budget (Unaudited) Budget Sales 4,977,938 $ 5,700,000 $ 4,915,928 $ 6,100,000 Cost of Sales (3,788,777) (4,326,300) (3,708,244) (4,625,400) Operating Revenues 1,189,161 1,373,700 1,207,684 1,474,600 23.9% 24.1% 24.6% 24.2% Operating Expenses: Personal Services 463,330 489,402 424,508 551,675 Commodities and Supplies 28,455 37,577 25,295 28,600 Contractual Services 258,266 337,769 194,286 346,231 Repairs and Maintenance 38,862 31,024 29,844 43,500 Utilities 34,603 32,023 34,377 44,491 Depreciation 15,181 25,905 0 25,087 Total Operating Expenses 838,697 953,700 708,310 1,039,584 Operating Income 350,464 420,000 499,374 435,016 Nonoperating revenues(expenses) Interest on Investments 11,501 13,000 0 13,000 Loss on Investments 0 0 0 0 Loss on Disposition of Fixed Assets 0 0 0 0 Total nonoperating revenues(expenses) 11,501 13,000 0 13,000 Income(loss)before operating transfers 361,965 433,000 499,374 448,016 Transfers in(out) (273,504) (420,000) 0 (420,000) Net Income(Loss) 88,461 $ 13,000 $ 499,374 $ 28,016 78 City of Eden Prairie 1999 Liquor Fund Proposed Budget Den Road Liquor Store 1998 Actual 1999 1997 1997 10/31/98 Proposed Actual Budget (Unaudited) Budget Sales 1,329,042 1,295,000 2,459,177 3,300,000 Cost of Sales (991,498) (975,000) (1,844,383) (2,475,000) Operating Revenues $ 337,544 $ 320,000 $ 614,794 $ 825,000 25.4% 24.7% 25.0% 25.0% Operating Expenses: Personal Services 115,365 107,300 166,861 221,675 Commodities and Supplies 13,510 7,200 13,015 12,800 Contractual Services 59,830 94,800 23,838 130,107 Repairs and Maintenance 5,458 1,000 4,878 9,700 Utilities 7,827 6,300 12,322 15,800 Depreciation 3,168 7,000 10,000 Total Operating Expenses 205,158 223,600 220,914 400,082 Operating Income 132,386 96,400 393,880 424,918 Nonoperating revenues(expenses) Interest on Investments (394) 5,000 Loss on Investments Loss on Disposition of Fixed Assets Total nonoperating revenues(expenses) (394) 0 0 5,000 Income(loss)before operating transfers 131,992 96,400 393,880 429,918 Transfers in(out) (98,461) (55,000) (340,000) Net Income $ 33,531 $ 41,400 $ 393,880 $ 89,918 • 79 City of Eden Prairie 1999 Liquor Fund Proposed Budget Prairie Village Liquor Store 1998 Actual 1999 1997 1997 10/31/98 Proposed Actual Budget (Unaudited) Budget Sales $ 1,542,299 $ 1,686,000 1,183,203 1,600,000 Cost of Sales (1,197,288) (1,306,000) (908,700) (1,228,800) Operating Revenues 345,011 380,000 274,503 371,200 22.4% 22.5% 23.2% 23.2% Operating Expenses: Personal Services 136,781 156,800 121,517 170,000 Commodities and Supplies 5,586 10,700 5,352 5,700 Contractual Services 70,245 68,732 60,400 84,174 Repairs and Maintenance 15,188 18,200 11,032 16,300 Utilities 13,071 12,300 10,771 14,438 Depreciation 3,214 2,500 3,087 Total Operating Expenses 244,085 269,232 209,072 293,699 Operating Income 100,926 110,768 65,431 77,501 Nonoperating revenues(expenses) Interest on Investments 4,064 4,000 Loss on Investments Loss on Disposition of Fixed Assets Total nonoperating revenues(expenses) 4,064 0 0 4,000 Income(loss)before operating transfers 104,990 110,768 65,431 81,501 Transfer to the General Fund (79,316) (110,000) (80,000) Net Income $ 25,674 $ 768 65,431 $ 1,501 80 City of Eden Prairie 1999 Liquor Fund Proposed Budget Prairie View Mall Liquor Store 1998 Actual 1999 1997 1997 10/31/98 Proposed Actual Budget (Unaudited) Budget Sales $ 2,106,597 $ 2,300,000 $ 1,273,548 1,200,000 Cost of Sales (1,599,991) (1,725,000) (955,161) (921,600) Operating Revenues 506,606 575,000 318,387 278,400 24.0% 25.0% 25.0% 23.2% Operating Expenses: Personal Services 211,184 185,600 136,130 160,000 Commodities and Supplies 9,359 16,700 6,928 10,100 Contractual Services 128,191 149,475 110,048 131,950 Repairs and Maintenance 18,216 8,500 13,934 17,500 Utilities 13,705 10,700 11,284 14,253 Depreciation 8,799 15,000 12,000 Total Operating Expenses 389,454 385,975 278,324 345,803 Operating Income 117,152 189,025 40,063 (67,403) Nonoperating revenues(expenses) Interest on Investments 7,831 4,000 Loss on Investments Loss on Disposition of Fixed Assets Total nonoperating revenues(expenses) 7,831 0 0 4,000 Income(loss)before operating transfers 124,983 189,025 40,063 (63,403) Transfers in(out) (95,727) (185,000) 0 Net Income $ 29,256 $ 4,025 $ 40,063 $ (63,403) 81 City of Eden Prairie 1999 Capital Budget Summary Liquor Fund Department Description Amount Prairie View Three computers $6,000 Inventory software 4,000 Laser printer 500 Fax machine 500 Surveillance camera 8,000 Prairie Village Three computers 6,000 Inventory software 4,000 Laser printer 500 Fax machine 500 Surveillance camera 8,000 Remodel store 20,000 Den Road One new computer 2,000 Laser printer 500 Fax machine 500 Surveillance camera 8,000 Total $69,000 82 City of Eden Prairie 1999 Proposed Budget Detail December 7, 1998 City Council Dr. Jean L. Harris, Mayor Sherry Butcher-Younghans Ronald Case Ross L. Thorfinnson, Jr. Nancy Tyra-Lukens City Manager Christopher M. Enger essacian prairie TABLE OF CONTENTS GENERAL FUND Budget Summary Pane General and Other Tax Supported Fund Revenues 1 General Fund Expenditures 3 Budget Detail General Government Legislative 5 Elections 6 City Manager 7 Assessing 8 Finance 9 Human Resources and Safety 11 Community Information and Services 13 Housing, Transportation,and Human Services . 14 Community and Economic Development 15 Historical Cultural 16 Facilities: Facilities 17 City Center 19 ADA 21 Parks,Recreation&Natural Resources Park Administration 22 Park Maintenance 23 Parks Capital Outlay 25 Recreation Programing: Recreation Administration 26 Special Events 27 Beaches 28 Oak Point Pool 29 Organized Athletics 30 Park Facilities 31 Youth Recreation 33 Adaptive Recreation 35 Adult Recreation 37 Arts 39 Community Center 41 Public Safety Police 43 Telecommunicators 45 Police Administration 46 Civil Defense 47 Animal Control 48 Fire 49 Building Inspection 51 Public Works Engineering 53 Streets and Traffic 55 Fleet Services 57 Street Lighting 59 Shared Services General Shared Services 60 Risk Management& Customer Service 61 Information Technology 62 Legal Counsel 63 Employee Benefits and Training 64 Contingency 65 Vehicles and Equipment 66 ENTERPRISE FUNDS-UTILITY FUND Budget Summary Water and Sewer 67 Storm Drainage 68 Budget Detail Water 69 Sewer 73 Storm Drainage 75 ENTERPRISE FUNDS -LIQUOR FUND Budget Summary Liquor Fund 77 Cub Foods 78 Prairie Village 79 Prairie View 80 Budget Detail Cub Foods 81 Prairie Village 83 Prairie View 85 City of Eden Prairie 1999 Proposed Budget General Fund Revenues and Debt Service 1998 Actual 1999 1997 1998 10/31/98 Proposed Actual Budget (Unaudited) Budget General Property Taxes Current 15,085,470 16,274,034 8,028,624 17,313,215 Delinquency and Abatement (7,252) (800,000) 70,869 (863,878) Net Current 15,078,218 15,474,034 8,099,493 16,449,337 Delinquent Collections Penalty and Interest 30,925 70,000 12,018 50,000 Total Taxes 15,109,143 15,544,034 8,111,511 16,499,337 Licenses and Permits Liquor and Beer 144,969 160,000 122,510 170,000 Building Contractors 5,565 4,500 3,290 5,500 Vending and Business Licenses 21,619 21,700 34,972 25,000 Dog Registration 11,884 13,500 12,698 12,000 Building Permits 2,049,500 1,700,000 1,779,689 1,800,000 Cable TV 423,077 242,500 148,946 275,000 Other Permits 34,793 22,750 54,290 30,000 Total Licenses and Permits 2,691,407 2,164,950 2,156,395 2,317,500 Intergovernmental Revenue Police Pension Aid 243,394 300,000 295,318 243,000 Fire Relief Association Aid 188,773 178,000 200,834 193,000 State Street Aid 49,293 110,000 109,595 110,000 School Liaison 70,748 54,000 65,000 Police Training 14,629 15,000 15,508 15,000 COPS Grant 42,200 0 0 0 Civil Defense 5,000 5,000 5,000 Local Performance Aid 52,216 63,400 31,705 59,500 PERA Aid 26,192 0 26,192 0 Other 1,408 0 0 0 Total Intergovernmental Revenue 693,853 725,400 679,152 690,500 Charges for Services General Government Planning and Zoning 129,664 70,000 100,034 70,000 Engineering 239,782 101,000 165,230 150,000 Public Safety Prints,Reports,and Alarms 68,603 57,250 44,023 70,000 Impound Fees 4,130 2,575 3,542 4,000 Recreation Youth Programs 204,074 203,600 175,456 209,500 Organized Athletics 216,825 216,200 211,192 216,200 Community Center 702,357 692,600 389,772 691,070 2nd Ice Arena 238,827 284,500 286,050 315,300 Oak Point Pool 74,331 115,360 62,040 99,600 Beaches 3,277 8,425 3,709 5,000 Special Events 22,881 28,680 19,356 28,665 Arts 8,368 7,450 9,910 7,000 Adult Program/Adaptive Recreation 35,930 50,500 28,644 51,900 Park Facilities 35,385 30,400 34,930 36,100 Total Charges for Services 1,984,434 1,868,540 1,533,888 1,954,335 1 City of Eden Prairie 1999 Proposed Budget General Fund Revenues and Debt Service 1998 Actual 1999 1997 1998 10/31/98 Proposed Actual Budget (Unaudited) Budget Court Fines 188,301 200,000 156,248 200,000 Investment Earnings 189,558 150,000 0 170,000 Other Revenue Special Assessments 223,852 125,000 79,810 118,000 IDR Charges 186,113 90,000 88,189 90,000 Street Lighting .23,402 25,000 16,168 25,000 Tenant Rental Income 0 125,000 0 0 Miscellaneous 335,562 140,416 87,381 150,000 Total Other Revenue 768,929 505,416 271,548 383,000 Other Financing Sources Transfers in(out) Utility Fund 60,000 60,000 60,000 T.I.F.Capital Project Fund 8,239 11,500 6,062 12,000 Liquor Fund 0 420,000 0 420,000 Other 97,948 0 0 0 Equipment Certificates 0 600,000 0 0 Note Proceeds 210,397 0 0 0 Total Other Financing Sources 376,584 1,091,500 6,062 492,000 Total Revenues 22,002,209 22,249,840 12,914,804 22,706,672 Vehicles and Equipment Property Taxes Current 545,112 549,400 271,040 562,800 Delinquency and Abatement 2,973 (26,000) 2,406 (26,800) Net Current 548,085 523,400 _ 273,446 536,000 Sale of Property 105,916 114,500 109,787 116,000 Total Vehicle and Equipment 654,001 637,900 383,233 652,000 Total General Fund 22,656,210 22,887,740 13,298,037 23,358,672 Debt Levies Tax Capacity Levies 1,768,500 1,858,250 929,125 1,577,000 Market Value Levies 455,000 608,000 304,000 592,000 Total Debt Levies 2,223,500 2,466,250 1,233,125 2,169,000 Grand Total 24,879,710 25,353,990 14,531,162 25,527,672 2 City of Eden Prairie 1999 Proposed Budget General Fund Expenditures and Debt Service 1998 Actual 1999 1997 1998 10/31/98 Proposed Actual Budget (Unaudited) Budget General Government Legislative $ 141,303 $ 145,400 $ 116,449 $ 145,400 Elections 34,832 88,966 48,392 56,666 City Manager 178,546 182,026 205,277 189,526 Assessing 437,060 445,180 336,188 431,680 Finance 400,575 486,515 341,427 471,323 Human Resources 252,896 281,575 210,257 283,245 Communication Services 243,998 312,016 224,133 378,516 Housing Transportation and Human Services 130,385 149,415 78,220 155,600 Community Development 443,092 469,566 336,072 473,566 Facilities 1,942,122 1,852,570 788,757 1,746,410 Subtotal 4,204,809 4,413,229 2,685,172 4,331,932 Parks and Recreation Park Administration 142,190 150,842 105,722 147,842 Park Maintenance 1,117,575 1,168,755 1,001,537 1,153,755 Parks Capital Outlay 50,497 88,400 79,178 17,400 Recreation Programming 1,003,802 1,051,178 821,738 1,078,131 Oak Point Pool 188,108 223,901 95,571 222,244 Community Center 1,303,652 1,311,166 786,079 1,214,345 Subtotal 3,805,824 3,994,242 2,889,825 3,833,717 Public Safety Police 3,742,445 4,523,120 3,144,434 4,067,287 Civil Defense 16,185 19,450 4,910 22,060 Animal Control 90,838 98,798 69,022 98,798 Fire 930,957 1,057,240 570,254 1,062,140 Inspections 627,157 693,394 495,941 688,794 Subtotal 5,407,582 6,392,002 4,284,561 5,939,079 Public Works Engineering 681,246 748,539 522,829 757,064 Streets and Traffic 1,458,690 1,593,902 1,208,291 1,534,832 Fleet Services 668,248 749,500 621,090 768,500 Street Lighting 579,136 611,500 442,408 616,500 Subtotal 3,387,320 3,703,441 2,794,618 3,676,896 Shared Services General Shared Services 557,933 577,644 • - 513,824 301,682 Risk Management&Customer Service 24,438 0 0 307,900 Information Technology 285,737 366,400 166,002 333,500 Legal Counsel 242,058 275,000 152,246 275,000 Employee Benefits and Training 2,173,283 2,387,882 1,826,857 3,061,590 Contingency 141,537 140,000 10,235 154,000 Subtotal 3,424,986 3,746,926 2,669,164 4,433,672 Transfer to Capital Improvement Program 491,376 Subtotal operations 20,230,521 22,249,840 15,323,340 22,706,672 Vehicles and Equipment General Government 15,140 50,587 40,555 18,000 Parks and Recreation 251,090 156,555 191,445 158,000 Public Safety 201,984 230,538 338,320 190,000 Public Works 109,208 200,220 28,963 286,000 Subtotal 577,422 637,900 599,283 652,000 Total General Fund $ 20,807,943 $ 22,887,740 $ 15,922,623 $ 23,358,672 Debt Obligations 2,223,500 2,466,250 2,466,250 2,169,000 Grand Total S 23,031,443 $ 25,353,990 $ 18,388,873 $ 25,527,672 3 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 010 LEGISLATIVE ACTUAL BUDGET 10/31/98 BUDGET 4130 WAGES NO BENEFITS 61,175 66,200 47,311 66,200 PERSONAL SERVICES $61,175 $66,200 $47,311 $66,200 4220 OPERATING SUPPLIES-GENERAL 142 0 76 0 4250 PHOTO SUPPLIES 159 0 0 0 COMMODITIES & SUPPLIES $300 $0 $76 $0 4320 COMMUNICATIONS 107 0 568 0 4321 POSTAGE 51 0 0 0 4334 MILEAGE AND PARKING 944 300 0 300 4410 MISCELLANEOUS 42 0 62 0 4411 CONFERENCE 175 2,000 1,430 2,000 4412 TRAVEL 325 2,000 5,467 2,000 4413 DUES & SUBSCRIPTIONS 70,842 70,300 54,683 70,300 4415 AWARDS 6,792 4,600 6,132 4,600 4420 OTHER CONTRACTED SERVICES 550 0 430 0 CONTRACTED SERVICES $79,828 $79,200 $68,771 $79,200 OPERATING EXPENDITURES $141,303 $145,400 $116,158 $145,400 4551 OFFICE EQUIPMENT 0 0 290 0 CAPITAL OUTLAY $0 $0 $290 $0 DIVISION TOTAL $141,303 $145,400 $116,449 $145,400 5 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 020 ELECTIONS ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 21,144 29,716 19,661 29,716 4112 OVERTIME-REG 0 5,400 2.064 0 4130 WAGES NO BENEFITS 0 33,300 12.261 10,000 4131 OVERTIME-PART TIME 0 500 0 0 4132 LEAVE TIME 6,591 0 2,153 0 PERSONAL SERVICES $27,735 $68,916 $36,138 $39,716 4220 OPERATING SUPPLIES-GENERAL 0 3,400 516 100 COMMODITIES & SUPPLIES $0 $3,400 $516 $100 4321 POSTAGE 1,936 6,300 5,323 1,800 4334 MILEAGE AND PARKING 0 50 0 50 4350 PRINTING 391 2,500 1,639 0 4380 CONTRACTED REPAIR & MAINT 4.770 4,800 4,752 5,000 4412 TRAVEL 0 3,000 23 0 CONTRACTED SERVICES $7,097 $16,650 $11,737 $6,850 OPERATING EXPENDITURES $34,832 $88,966 $48.392 $46,666 4552 OTHER EQUIPMENT 0 0 0 10,000 CAPITAL OUTLAY $0 $0 $0 $10,000 DIVISION TOTAL $34,832 $88.966 $48.392 $56,666 6 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 015 CITY MANAGER ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 135,374 159,326 112,160 159,326 4112 OVERTIME-REG 134 400 166 400 4130 WAGES NO BENEFITS 0 3,000 0 3,000 4132 LEAVE TIME 26,088 0 86,008 . 0 PERSONAL SERVICES $161,597 $162,726 $198,334 $162,726 4210 OFFICE SUPPLIES 399 0 63 0 4220 OPERATING SUPPLIES-GENERAL 27 4,000 307 2,000 COMMODITIES & SUPPLIES $426 $4,000 $371 $2,000 4320 COMMUNICATIONS 291 0 306 0 4334 MILEAGE AND PARKING 4,943 5,300 4,597 5,300 4350 PRINTING 355 0 158 0 4380 CONTRACTED REPAIR & MAINT 0 0 0 500 4410 MISCELLANEOUS 0 1,500 23 1,500 4413 DUES & SUBSCRIPTIONS 318 0 256 0 4420 OTHER CONTRACTED SERVICES 1,928 3,000 0 3,000 4430 MICROFILMING SERVICE 1,217 5,000 1,232 12,000 4434 MUDJACKING CURBS 3 0 0 0 CONTRACTED SERVICES $9,054 $14,800 $6,572 $22.300 OPERATING EXPENDITURES $171,077 $181,526 $205,277 $187,026 4265 SOFTWARE 161 0 0 0 4266 OFFICE EQUIPMENT 0 500 0 0 4542 COMPUTERS 5,764 0 0 2,000 4550 FURNITURE & FIXTURES 452 0 0 500 4551 OFFICE EQUIPMENT 1,092 0 0 0 CAPITAL OUTLAY $7,469 $500 $0 $2,500 DIVISION TOTAL $178,546 $182,026 $205,277 $189,526 7 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 040 ASSESSING ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 329,708 401,480 243,110 401,480 4112 OVERTIME-REG 199 6,000 1,002 6,000 4130 WAGES NO BENEFITS 0 1,000 1,260 1,000 4132 LEAVE TIME 67,393 0 47,608 0 PERSONAL SERVICES $397,301 $408,480 $292,980 $408,480 4210 OFFICE SUPPLIES 0 0 13 0 4220 OPERATING SUPPLIES-GENERAL 1,789 5,300 1,908 5,300 4250 PHOTO SUPPLIES 870 2,300 600 2,300 COMMODITIES & SUPPLIES $2,660 $7,600 $2,521 $7,600 4320 COMMUNICATIONS 434 1,000 551 1,000 4321 POSTAGE 3,492 4,000 5,728 6,000 4334 MILEAGE AND PARKING 2,413 2,600 2,111 2,600 4350 PRINTING 1,024 1,600 1,068 1,600 4380 CONTRACTED REPAIR & MAINT 0 0 135 0 4412 TRAVEL 14 0 0 0 4414 LICENSES & TAXES 0 0 125 0 4420 OTHER CONTRACTED SERVICES 750 1,600 3,076 1,600 CONTRACTED SERVICES $8,127 $10,800 $12,793 $12,800 OPERATING EXPENDITURES $408,087 $426,880 $308,293 $428,880 4265 SOFTWARE 266 0 689 2,800 4266 OFFICE EQUIPMENT 0 300 0 0 4269 OTHER EQUIPMENT 0 500 83 0 4542 COMPUTERS 3,882 14,500 26,850 0 4550 FURNITURE & FIXTURES 23,420 3,000 0 0 4551 OFFICE EQUIPMENT 1,405 0 272 0 CAPITAL OUTLAY $28,973 $18,300 $27,894 $2,800 DIVISION TOTAL $437,060 $445,180 $336,188 $431,680 8 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 017 FINANCE ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 287,300 396,015 220,172 396,015 4112 OVERTIME-REG 5,132 0 701 0 4130 WAGES NO BENEFITS 9,704 34,800 6,472 25,000 4132 LEAVE TIME 47,591 0 62,259 0 PERSONAL SERVICES $349,727 $430,815 $289,605 $421,015 4210 OFFICE SUPPLIES 366 0 0 0 4220 OPERATING SUPPLIES-GENERAL 660 6,000 953 4,000 4248 TRAINING SUPPLIES 34 0 117 0 COMMODITIES & SUPPLIES $1,059 $6,000 $1,070 $4,000 4310 PROFESSIONAL SERVICES 576 0 120 5,000 4313 AUDIT & FINANCIAL 8,461 35,000 5,700 20,000 4320 COMMUNICATIONS 0 0 0 108 4321 POSTAGE 0 0 18 0 4334 MILEAGE AND PARKING 2,427 2,700 1,800 2,700 4350 PRINTING 1,139 1,500 1,141 1,500 4380 CONTRACTED REPAIR & MAINT 1,006 1,000 45 1,000 4410 MISCELLANEOUS 2,366 0 340 0 4413 DUES & SUBSCRIPTIONS 170 0 0 0 4415 AWARDS 690 0 915 1,000 4420 OTHER CONTRACTED SERVICES 3,331 0 31,437 0 4430 MICROFILMING SERVICE 0 2,000 0 0 CONTRACTED SERVICES $20,167 $42,200 $41,516 $31,308 OPERATING EXPENDITURES $370,953 $479,015 $332,191 $456,323 4265 SOFTWARE 844 0 78 0 4267 FURNITURE & FIXTURES 108 0 356 0 4542 COMPUTERS 13,682 0 689 0 4550 FURNITURE & FIXTURES 1,539 1,000 1,265 0 4551 OFFICE EQUIPMENT 2,939 6,500 5,873 0 CAPITAL OUTLAY $19,113 $7,500 $8,261 $0 9 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 017 FINANCE ACTUAL BUDGET 10/31/98 BUDGET 4750 BANK CHGS & S/C 12,512 0 975 15,000 OTHER FINANCING USES $12,512 $0 $975 $15,000 DIVISION TOTAL $402,578 $486,515 $341,427 $471,323 10 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 018 HUMAN RESOURCES ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 128,969 184,130 131,268 184,130 4112 OVERTIME-REG 735 1,800 410 2,250 4130 WAGES NO BENEFITS 8,169 12.480 0 7,200 4131 OVERTIME-PART TIME 242 0 0 0 4132 LEAVE TIME 32,628 0 24,451 0 PERSONAL SERVICES $170,743 $198,410 $156,130 $193,580 4210 OFFICE SUPPLIES 168 0 42 0 4220 OPERATING SUPPLIES-GENERAL (97) 0 111 200 4248 TRAINING SUPPLIES 3,763 6.500 3,243 0 4249 SAFETY SUPPLIES 1,447 3,500 325 0 4250 PHOTO SUPPLIES 234 0 23 0 COMMODITIES & SUPPLIES $5,515 $10,000 $3,744 $200 4140 COMPARABLE WORTH MAINT 145 600 135 900 4141 PHYSICAL & PSYCO EXAM 7,185 7,700 4,512 15,200 4144 EMPLOYEE AWARD 12.301 16,000 5,778 17,000 4310 PROFESSIONAL SERVICES 9,373 15,700 9,056 25,000 4311 PERSONNEL TESTING 657 0 0 0 4320 COMMUNICATIONS 148 0 262 0 4322 TELEPHONE 263 0 246 0 4334 MILEAGE AND PARKING 2,607 2,865 2,010 2,865 4341 EMPLOYMENT ADVERTISING 29,982 20,200 25,482 22,500 4342 CONTROLLED SUBSTANCE-ALCOHOL T 0 8,000 0 ' 0 4380 CONTRACTED REPAIR & MAINT 0 0 178 0 4410 MISCELLANEOUS 30 0 0 0 4412 TRAVEL 27 0 0 0 4413 DUES & SUBSCRIPTIONS 914 900 753 0 4414 LICENSES & TAXES 20 0 0 0 4420 OTHER CONTRACTED SERVICES 4,883 1,200 0 6,000 CONTRACTED SERVICES $68,534 $73,165 $48,410 $89,465 OPERATING EXPENDITURES $244,793 $281,575 $208,284 $283.245 11 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 018 HUMAN RESOURCES ACTUAL BUDGET 10/31/98 BUDGET 4229 MISC FIRE EQUIPMENT 133 0 0 0 4247 POLICE EQUIPMENT 142 0 0 0 4265 SOFTWARE 757 0 48 0 4267 FURNITURE & FIXTURES 0 0 252 0 4269 OTHER EQUIPMENT 292 0 0 0 4542 COMPUTERS 5,394 0 1,673 0 4550 FURNITURE & FIXTURES 1,385 0 0 0 CAPITAL OUTLAY $8.103 $0 $1,973 $0 DIVISION TOTAL $252,896 $281,575 $210,257 $283,245 12 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 019 COMMUNITY SERV ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 114,068 167,786 115,964 167,786 4112 OVERTIME-REG 649 1,500 310 1,500 4130 WAGES NO BENEFITS 10,922 12,480 580 12,480 4131 OVERTIME-PART TIME 17 1,500 0 1,500 4132 LEAVE TIME 8,885 0 14,375 0 PERSONAL SERVICES $134,542 $183,266 $131,228 $183,266 4210 OFFICE SUPPLIES 31 0 0 0 4220 OPERATING SUPPLIES-GENERAL 530 200 150 0 4246 VIDEO SUPPLIES 1,334 1,000 2,041 1,000 4250 PHOTO SUPPLIES 487 0 575 0 COMMODITIES & SUPPLIES $2,382 $1,200 $2,766 $1,000 4143 EMPLOYEE NEWSLETTER 3,829 1,500 950 1,500 4310 PROFESSIONAL SERVICES 16,300 27,300 7,575 13,800 4320 COMMUNICATIONS 65 0 64 0 4321 POSTAGE 9,609 20,250 14,319 24,000 4334 MILEAGE AND PARKING 27 0 5 0 4340 ADVERTISING 1,710 1,000 1,479 2,000 4350 PRINTING 39,396 45,000 45,490 51,600 4351 LEGAL NOTICES PUBLISHING 0 0 0 12,000 4380 CONTRACTED REPAIR & MAINT 0 0 65 1,300 4400 CABLE TV 26,343 31,500 13,009 33,000 4412 TRAVEL 0 0 16 0 4420 OTHER CONTRACTED SERVICES 9,794 0 7,166 30,000 CONTRACTED SERVICES $107,075 $126,550 $90,138 $169,200 OPERATING EXPENDITURES $243,998 $311,016 $224,133 $353,466 4542 COMPUTERS 0 0 0 8,700 4552 OTHER EQUIPMENT 0 1,000 0 16,350 CAPITAL OUTLAY $0 $1,000 $0 $25,050 DIVISION TOTAL $243,998 $312,016 $224,133 $378,516 13 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 021 HUMAN SERV ACTUAL BUDGET 10/31/98 BUDGET 4310 PROFESSIONAL SERVICES 130,385 149,415 78,220 155,600 CONTRACTED SERVICES $130,385 $149,415 $78,220 $155,600 OPERATING EXPENDITURES $130,385 $149,415 $78,220 $155,600 DIVISION TOTAL $130,385 $149,415 $78,220 $155,600 14 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 060 COMMUNITY DEV ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 322,798 391,701 249,890 391,701 4130 WAGES NO BENEFITS 3,560 10,000 0 10,000 4132 LEAVE TIME 58,466 0 45,199 0 PERSONAL SERVICES $384,823 $401,701 $295,089 $401,701 4210 OFFICE SUPPLIES 32 0 0 0 4220 OPERATING SUPPLIES-GENERAL 3,865 2,700 3,695 2,700 4250 PHOTO SUPPLIES 654 1,200 778 1,200 COMMODITIES & SUPPLIES $4,550 $3,900 $4,473 $3,900 4322 TELEPHONE 0 0 305 0 4334 MILEAGE AND PARKING 2,730 2,800 1,689 2,800 • 4340 ADVERTISING 846 0 160 0 4350 PRINTING 57 5,000 0 5,000 4380 CONTRACTED REPAIR & MAINT 353 0 0 0 4412 TRAVEL (34) 0 0 0 4420 OTHER CONTRACTED SERVICES 100 0 1,035 0 CONTRACTED SERVICES $4,052 $7,800 $3,189 $7,800 OPERATING EXPENDITURES $393,426 $413,401 $302,750 $413,401 4265 SOFTWARE 0 0 96 0 4267 FURNITURE & FIXTURES 0 0 409 0 4542 COMPUTERS 0 0 346 4,000 4550 FURNITURE & FIXTURES 4,752 4,500 2,555 8,000 CAPITAL OUTLAY $4,752 $4,500 $3,405 $12,000 DIVISION TOTAL $398,177 $417,901 $306,155 $425,401 15 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 063 HISTORICAL ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 21,025 27,170 18,452 27,170 4132 LEAVE TIME 5,004 0 3,359 0 PERSONAL SERVICES $26,029 $27,170 $21,811 $27,170 4220 OPERATING SUPPLIES-GENERAL 208 500 160 500 4233 BLDG REPAIR & MAINT 0 1,000 0 1,000 4238 REC EQUIP & SUPPLIES 908 1,000 377 1,000 COMMODITIES & SUPPLIES $1,116 $2,500 $537 $2,500 4334 MILEAGE AND PARKING 0 300 0 300 4350 PRINTING 459 1,000 0 1,000 4383 CONTRACTED BLDG REPAIRS 5,730 10,000 0 10,000 4413 DUES & SUBSCRIPTIONS 90 75 0 75 4420 OTHER CONTRACTED SERVICES 0 1,000 3,300 1,000 CONTRACTED SERVICES $6,279 $12,375 $3,300 $12,375 OPERATING EXPENDITURES $33.424 $42,045 $25,647 $42,045 4500 OTHER CAPITAL 0 500 0 0 4542 COMPUTERS 0 3,000 0 0 CAPITAL OUTLAY $0 $3,500 $0 $0 • 4710 PERMANENT TRANSFER 11,491 6,120 4,270 6,120 OTHER FINANCING USES $11,491 $6,120 $4,270 $6,120 DIVISION TOTAL $44,915 $51,665 $29,917 $48,165 16 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 037 FACILITIES ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 167,819 246,215 147,737 246,215 4112 OVERTIME-REG 2,587 7,000 2,439 7,000 4130 WAGES NO BENEFITS 0 0 411 0 4132 LEAVE TIME 33,050 0 33,168 0 PERSONAL SERVICES $203,456 $253,215 $183,755 $253,215 4220 OPERATING SUPPLIES-GENERAL 2,373 3,200 4,179 3,200 4223 CLEANING SUPPLIES 17,338 13,000 12,757 14,500 4224 CLOTHING & UNIFORMS 2,959 3,000 1,850 3,000 4230 REPAIR & MAINT SUPPLIES 2,976 5,300 4,349 5,800 4233 BLDG REPAIR & MAINT 1,034 4,800 340 4,800 4240 SMALL TOOLS 370 4,000 4,034 4,000 4250 PHOTO SUPPLIES 284 0 0 500 4257 SALES TAX EXPENSES 11 0 0 0 COMMODITIES & SUPPLIES $27,346 $33,300 $27,509 $35,800 4310 PROFESSIONAL SERVICES 0 12,000 3,304 20,000 4319 JANITOR SERVICE 0 0 0 5,000 4320 COMMUNICATIONS 1,769 2,600 1,735 4,600 4322 TELEPHONE 1,039 5,000 283 2,000 4334 MILEAGE AND PARKING 0 1,200 802 1,200 4371 ELECTRIC 77,456 72,350 59,070 74,300 4372 GAS 62,329 86,600 23,792 54,200 4373 WATER SOFTNER 453 0 0 0 4375 WASTE DISPOSAL 6,491 14,400 7,561 14,400 4380 CONTRACTED REPAIR & MAINT 1,573 26,100 2,599 21,100 4382 CONTRACTED EQUIP REPAIR 1,918 27,900 155 14,100 4383 CONTRACTED BLDG REPAIRS 20,105 34,600 11,239 26,500 4393 EQUIPMENT RENTAL (75) 0 0 1,500 4410 MISCELLANEOUS 0 0 6,461 9,000 4412 TRAVEL 0 0 18 0 4413 DUES & SUBSCRIPTIONS 0 500 498 500 4414 LICENSES & TAXES 30 500 40 500 4420 OTHER CONTRACTED SERVICES 589 9,000 80 9,000 4421 CONTRACTED BLDG MAINT 10,055 19,800 2,606 15,600 4422 GROUNDS MAINTENANCE 2,242 5,400 1,830 14,400 CONTRACTED SERVICES $185.973 $317,950 $122,072 $287,900 OPERATING EXPENDITURES $416,775 $604,465 $333,336 $576,915 17 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 037 FACILITIES ACTUAL BUDGET 10/31/98 BUDGET 4267 FURNITURE & FIXTURES 81 0 0 0 4517 RADIOS 0 0 2,123 0 4520 BUILDING 17,760 10,000 17,437 0 4542 COMPUTERS 1,963 0 0 0 4550 FURNITURE & FIXTURES 7,216 3,500 1,426 0 4552 OTHER EQUIPMENT 1,166 0 0 0 CAPITAL OUTLAY $28.186 $13,500 $20,987 $0 DIVISION TOTAL $444,961 $617,965 $354,322 $576,915 18 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 095 CITY CENTER ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 85,362 89,304 72,956 89,304 4112 OVERTIME-REG 3,322 4,300 2,690 4,300 4130 WAGES NO BENEFITS 2,573 16,000 0 16,000 PERSONAL SERVICES $91,257 $109,604 $75,645 $109,604 4220 OPERATING SUPPLIES-GENERAL 945 0 2,460 1,500 4223 CLEANING SUPPLIES 13,687 15,800 9,430 15,800 4230 REPAIR & MAINT SUPPLIES 33,790 26,700 21,857 27,200 4233 BLDG REPAIR & MAINT 6,569 0 1,000 10,500 4236 SIGNS 1,109 1,500 567 1,500 4240 SMALL TOOLS 0 0 280 0 4257 SALES TAX EXPENSES 9 0 0 0 COMMODITIES & SUPPLIES $56,109 $44,000 $35,595 $56,500 4133 WAGES CONTRACTED 64,189 63,300 39,445 65,300 4310 PROFESSIONAL SERVICES 24,000 24,000 19,800 24,000 4319 JANITOR SERVICE 72,100 93,300 51,563 96,000 4370 UTILITIES 14,449 23,100 10,331 23,100 4371 ELECTRIC 346,536 347,500 278,602 360,000 4372 GAS 36,694 36,300 16,599 37,500 4375 WASTE DISPOSAL 12,014 10,200 7,810 10,200 4380 CONTRACTED REPAIR& MAINT 6,934 6,700 6,981 6,700 4382 CONTRACTED EQUIP REPAIR 29,026 30.000 18,984 58,000 4383 CONTRACTED BLDG REPAIRS 120.773 103,000 57,488 33,000 4390 RENTALS . 11,950 16,175 9,550 16,175 4392 BLDG RENTAL 455,000 480,000 0 305,000 4400 CABLE TV 375 0 0 0 4410 MISCELLANEOUS 2,379 0 15,737 26,600 4414 LICENSES & TAXES 192,625 215,000 179,163 215,000 4420 OTHER CONTRACTED SERVICES 2,715 0 25,299 0 4421 CONTRACTED BLDG MAINT 700 12,600 2,155 12,600 4422 GROUNDS MAINTENANCE 39,921 40,510 34,794 43,000 4438 CONTRACT SNOW PLOWING 64,621 53,000 37,573 55,000 4439 SEAL COATING CONTRACTED 6,862 13,675 17,142 13,675 CONTRACTED SERVICES $1,503,863 $1,568,360 $829,016 $1,400,850 OPERATING EXPENDITURES $1,651,229 $1,721,964 $940,256 $1,566,954 19 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 095 CITY CENTER ACTUAL BUDGET 10/31/98 BUDGET 4267 FURNITURE & FIXTURES 105 0 3,227 0 4520 BUILDING 87,841 46,100 12,527 200,000 4530 IMPROVEMENT CONTRACTS 339,657 0 (10,000) 0 4550 FURNITURE & FIXTURES 2,991 0 0 15,000 4551 OFFICE EQUIPMENT 1,776 0 0 0 4552 OTHER EQUIPMENT 0 0 879 0 CAPITAL OUTLAY $432,369 $46,100 $6,632 $215,000 DIVISION TOTAL $2,083,598 $1,768,064 $946,888 $1,781,954 20 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 181 ADA ACTUAL BUDGET 10/31/98 BUDGET 4220 OPERATING SUPPLIES-GENERAL 0 0 256 0 COMMODITIES & SUPPLIES $0 $0 $256 $0 4412 TRAVEL 0 0 30 0 4413 DUES & SUBSCRIPTIONS 256 0 0 0 CONTRACTED SERVICES $256 $0 $30 $0 OPERATING EXPENDITURES $256 $0 $286 $0 4520 BUILDING 0 80,000 0 0 4530 IMPROVEMENT CONTRACTS 8,013 0 0 0 4542 COMPUTERS 784 0 0 0 CAPITAL OUTLAY $8,797 $80,000 $0 $0 4710 PERMANENT TRANSFER 13,553 0 0 0 OTHER FINANCING USES $13,553 $0 $0 $0 DIVISION TOTAL $22,606 $80,000 $286 $0 21 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 049 PARK ADMIN ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 96,843 121,542 78,356 121,542 4130 WAGES NO BENEFITS 0 1,000 578 1,000 4131 OVERTIME-PART TIME 0 0 102 0 4132 LEAVE TIME 29,450 0 20,369 0 PERSONAL SERVICES $126,294 $122,542 $99,404 $122,542 4220 OPERATING SUPPLIES-GENERAL 570 2,100 52 2,100 4250 PHOTO SUPPLIES 0 0 0 500 COMMODITIES & SUPPLIES $570 $2,100 $52 $2,600 4334 MILEAGE AND PARKING 2,400 2,500 2,000 2,500 . 4350 PRINTING 0 200 0 0 4351 LEGAL NOTICES PUBLISHING 106 200 29 200 4420 OTHER CONTRACTED SERVICES 12,820 20,000 2,114 20,000 CONTRACTED SERVICES $15,326 $22,900 $4,143 $22,700 OPERATING EXPENDITURES $142.190 $147,542 $103,599 $147,842 4265 SOFTWARE 0 300 0 0 4542 COMPUTERS - 0 2,000 2,123 0 4550 FURNITURE & FIXTURES 0 1,000 0 0 CAPITAL OUTLAY $0 $3,300 $2,123 $0 DIVISION TOTAL $142,190 $150,842 $105,722 $147,842 22 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 051 PARK MAINTENANCE ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 480,901 604,455 426,486 604,455 4112 OVERTIME-REG 46,092 44,000 31,134 44,000 4130 WAGES NO BENEFITS 100,400 120,000 118,880 105,000 4131 OVERTIME-PART TIME 2,954 0 2,741 0 4132 LEAVE TIME 108,321 0 85,028 0 PERSONAL SERVICES $738,667 •$768,455 $664,270 $753,455 4210 OFFICE SUPPLIES 327 0 0 0 4219 RECORDING DOCUMENT FEE 0 150 0 150 4220 OPERATING SUPPLIES-GENERAL 32,098 32,300 31,621 32,300 4224 CLOTHING & UNIFORMS 6,503 6,500 2,999 6,500 4226 CHEMICALS 12,066 30,000 6,295 30,000 4227 BUILDING MATERIALS 14,400 9,000 10,037 9,000 4230 REPAIR & MAINT SUPPLIES 15,351 9,500 8,578 9,500 4233 BLDG REPAIR & MAINT 1,484 9,500 6,362 9,500 4235 LANDSCAPE MILS & AG SUPPL 25,897 20,600 31,735 20,600 4238 REC EQUIP & SUPPLIES 373 0 3 0 4240 SMALL TOOLS 1,121 3,000 1,253 3,000 4250 PHOTO SUPPLIES 150 0 0 0 4257 SALES TAX EXPENSES 37 0 0 0 COMMODITIES & SUPPLIES $109,806 $120,550 $98,883 $120,550 4320 COMMUNICATIONS 340 0 1,199 0 4322 TELEPHONE 15,748 • 15,500 13,298 15,500 4334 MILEAGE AND PARKING 1,594 1,600 1,420 1,600 4350 PRINTING 402 2,000 207 2,000 4371 ELECTRIC 36,649 33,900 21,662 33,900 4372 GAS 6,789 28,700 2,865 28,700 4373 WATER SOFTNER 266 500 158 500 4375 WASTE DISPOSAL 62,294 69,000 54,301 69,000 4380 CONTRACTED REPAIR & MAINT 4,097 3,000 7,542 3,000 4382 CONTRACTED EQUIP REPAIR 3,337 10,000 5,998 10,000 4390 RENTALS 500 0 0 0 4391 LAND RENTAL 1,257 600 0 600 4392 BLDG RENTAL 3,500 0 0 0 23 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 051 PARK MAINTENANCE ACTUAL BUDGET 10/31/98 BUDGET 4393 EQUIPMENT RENTAL 6,833 10,000 5,269 10,000 4410 MISCELLANEOUS 0 0 20 0 4414 LICENSES & TAXES 4,586 5,000 2,881 5,000 4419 AERIAL PHOTO SUPPLIES 0 200 0 200 4420 OTHER CONTRACTED SERVICES 95,449 72,750 95,617 77,750 4439 SEAL COATING CONTRACTED 13,703 22,000 17,700 22,000 CONTRACTED SERVICES $257,341 $274,750 $230,136 $279,750 OPERATING EXPENDITURES $1,105,814 $1,163,755 $993,289 $1,153,755 4267 FURNITURE & FIXTURES 0 0 573 0 4531 SA ON LAND 298 0 (42) 0 4552 OTHER EQUIPMENT 0 5,000 0 0 4553 PARK EQUIPMENT 12,021 0 7,717. 0 CAPITAL OUTLAY $12,319 $5,000 $8,248 $0 4980 REFUNDS (560) 0 0 0 OTHER FINANCING USES $(560) $0 $0 $0 DIVISION TOTAL $1,117,574 $1,168,755 $1,001,537 $1,153,755 24 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 052 PARKS CAPITAL OUTLAY ACTUAL BUDGET 10/31/98 BUDGET 4230 REPAIR & MAINT SUPPLIES 0 0 127 0 COMMODITIES & SUPPLIES $0 $0 $127 $0 4340 ADVERTISING 0 0 55 0 4375 WASTE DISPOSAL 54 0 0 0 CONTRACTED SERVICES $54 $0 $55 $0 OPERATING EXPENDITURES $54 $0 $182 $0 4511 IMPROVEMENTS TO LAND 0 0 2,990 0 4520 BUILDING 0 4,500 7,250 0 4540 MACHINERY EQUIPMENT 0 0 11,487 0 4541 AUTOS 0 0 47 0 4552 OTHER EQUIPMENT 0 18,900 12,842 17,400 4553 PARK EQUIPMENT 50,443 65,000 44,379 0 CAPITAL OUTLAY $50,443 $88,400 $78,995 $17,400 DIVISION TOTAL $50,498 $88,400 $79,178 $17,400 • 25 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 067 RECREATION ADMIN ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 72,817 91,872 64,123 91,872 4112 OVERTIME-REG 1,326 2,000 622 1,500 4130 WAGES NO BENEFITS 0 1,000 243 1,000 4132 LEAVE TIME 15,025 0 10,501 0 PERSONAL SERVICES $89,168 $94,872 $75,489 $94,372 4210 OFFICE SUPPLIES 244 500 0 500 4220 OPERATING SUPPLIES-GENERAL 799 500 347 500 4250 PHOTO SUPPLIES 100 200 0 100 COMMODITIES & SUPPLIES $1,143 $1,200 $347 $1,100 4310 PROFESSIONAL SERVICES 0 500 0 1,000 4321 POSTAGE 22 500 0 700 4322 TELEPHONE 171 0 247 0 4334 MILEAGE AND PARKING 896 1,000 698 1,000 4340 ADVERTISING 1,343 1,500 0 1,500 4350 PRINTING 0 2,000 0 2,000 4410 MISCELLANEOUS 85 200 76 200 4412 TRAVEL 72 200 0 100 4415 AWARDS 25 0 0 0 4426 SPECIAL EVENTS FEES 0 0 13 0 CONTRACTED SERVICES $2,615 $5,900 $1,033 $6,500 OPERATING EXPENDITURES $92,925 $101,972 $76,870 $101,972 4265 SOFTWARE 0 300 0 0 4269 OTHER EQUIPMENT 121 0 0 0 4542 COMPUTERS 0 2,000 0 0 4550 FURNITURE & FIXTURES 870 0 0 0 CAPITAL OUTLAY $990 $2,300 $0 $0 DIVISION TOTAL $93,915 $104,272 $76,870 $101,972 26 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 065 SPECIAL EVENTS ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 39 23,031 15,607 23,031 4130 WAGES NO BENEFITS 100 2,050 8 0 PERSONAL SERVICES $139 $25,081 $15,615 $23,031 4210 OFFICE SUPPLIES 0 0 0 50 4220 OPERATING SUPPLIES-GENERAL 3,514 4,300 2,597 3,750 4224 CLOTHING & UNIFORMS 1,820 300 2,057 2,300 4250 PHOTO SUPPLIES 37 125 122 75 COMMODITIES & SUPPLIES $5,371 $4,725 $4,776 $6,175 4330 TRANSPORTATION 0 400 0 0 4334 MILEAGE AND PARKING 0 0 236 400 4340 ADVERTISING 3,334 3,350 3,686 4,100 4350 PRINTING 4,207 9.700 6,454 7,000 4393 EQUIPMENT RENTAL 3,391 6,450 3,244 4,300 4420 OTHER CONTRACTED SERVICES 24,976 24,450 29,825 30,750 4426 SPECIAL EVENTS FEES 270 1,600 0 0 CONTRACTED SERVICES $36,178 $45,950 $43,446 $46,550 OPERATING EXPENDITURES $41,688 $75,756 $63,838 $75,756 4520 BUILDING 0 0 32,750 0 4530 IMPROVEMENT CONTRACTS 0 0 (32,750) 0 CAPITAL OUTLAY $0 $0 $0 $0 DIVISION TOTAL $41,688 $75,756 $63,838 $75,756 27 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 062 BEACHES ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 6,556 5,719 3,074 5,719 4130 WAGES NO BENEFITS 62,771 67,830 63,779 66,850 PERSONAL SERVICES $69,327 $73,549 $66,853 $72,569 4220 OPERATING SUPPLIES-GENERAL 784 1,100 171 1,100 4224 CLOTHING & UNIFORMS 1.261 1,500 1,233 1,500 4230 REPAIR & MAINT SUPPLIES 128 700 93 700 4249 SAFETY SUPPLIES 511 1,200 812 1,200 4257 SALES TAX EXPENSES 8 0 0 0 COMMODITIES & SUPPLIES $2,692 $4,500 $2,309 $4,500 4334 MILEAGE AND PARKING 446 400 383 400 CONTRACTED SERVICES $446 $400 $383 $400 OPERATING EXPENDITURES $72,465 $78,449 $69,546 $77,469 4553 PARK EQUIPMENT 0 0 0 1,000 CAPITAL OUTLAY $0 $0 $0 $1,000 DIVISION TOTAL $72,465 $78,449 $69,546 $78,469 28 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 071 OAK POINT POOL ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 10,717 13,344 7,038 13,344 4130 WAGES NO BENEFITS 111,234 122,000 83,990 124,400 PERSONAL SERVICES $121,952 $135,344 $91,028 $137,744 4220 OPERATING SUPPLIES-GENERAL 804 2,200 361 2,200 4224 CLOTHING & UNIFORMS 1,042 1,000 931 1,000 4238 REC EQUIP & SUPPLIES 1,991 5,000 335 3,000 4248 TRAINING SUPPLIES 1,047 900 1,022 900 4249 SAFETY SUPPLIES 207 300 0 300 4257 SALES TAX EXPENSES 1 0 0 0 COMMODITIES & SUPPLIES $5,092 $9,400 $2,650 $7,400 4310 PROFESSIONAL SERVICES 0 1,000 400 1,000 4350 PRINTING 533 700 61 700 4380 CONTRACTED REPAIR & MAINT 0 0 312 0 4420 OTHER CONTRACTED SERVICES 60,532 75,158 0 75,200 CONTRACTED SERVICES $61,065 $76,858 $772 $76,900 OPERATING EXPENDITURES $188,108 $221,602 $94,450 $222,044 4265 SOFTWARE 0 300 0 0 4542 COMPUTERS 0 2,000 125 0 4550 FURNITURE & FIXTURES 0 0 0 200 4551 OFFICE EQUIPMENT 0 _ _ 0 997 0 CAPITAL OUTLAY $0 $2,300 $1,121 $200 DIVISION TOTAL $188,108 $223,902 $95,571 $222,244 29 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 059 ORGANIZED ATHLETICS ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 40,955 48,609 35,708 48,609 4130 WAGES NO BENEFITS 17,778 0 3,196 0 4132 LEAVE TIME 5,774 0 5,401 0 PERSONAL SERVICES $64,507 $48,609 $44,304 $48,609 4220 OPERATING SUPPLIES-GENERAL 955 900 329 900 4238 REC EQUIP & SUPPLIES 16,389 15,600 14,243 15,900 4250 PHOTO SUPPLIES 10 0 0 0 COMMODITIES & SUPPLIES $17,354 $16,500 $14,572 $16,800 4320 COMMUNICATIONS 0 0 255 0 4334 MILEAGE AND PARKING 1,073 800 679 1,100 4350 PRINTING 0 300 0 0 4395 GYM RENTAL 15,263 10,100 3,347 10,100 4397 ICE TIME RENTAL 0 400 613 400 4410 MISCELLANEOUS 1,230 900 0 1,300 4415 AWARDS 11,734 8,950 9,935 9,850 4420 OTHER CONTRACTED SERVICES 76,238 73,900 68,863 73,900 4426 SPECIAL EVENTS FEES 6,212 6,650 5,724 6,150 CONTRACTED SERVICES $111,750 $102,000 $89,414 $102,800 OPERATING EXPENDITURES $193,611 $167,109 $148,291 $168,209 4552 OTHER EQUIPMENT 0 1,000 0 1,000 CAPITAL OUTLAY $0 $1,000 $0 $1,000 4710 PERMANENT TRANSFER 30,000 27,700 0 27,700 OTHER FINANCING USES $30,000 $27,700 $0 $27,700 DIVISION TOTAL $223,611 $195,809 $148,291 $196,909 30 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 081 PARK FACILITIES ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 18,988 31,950 25,869 31,950 4130 WAGES NO BENEFITS 3,865 0 0 0 4132 LEAVE TIME 7,210 0 1,172 0 PERSONAL SERVICES $30,063 $31,950 $27,042 $31,950 4220 OPERATING SUPPLIES-GENERAL 3,145 1,000 1,351 1,000 4224 CLOTHING & UNIFORMS 0 400 0 400 4238 REC EQUIP & SUPPLIES 503 500 263 500 4240 SMALL TOOLS 213 200 14 200 4249 SAFETY SUPPLIES 307 300 0 300 4250 PHOTO SUPPLIES 0 0 0 100 4257 SALES TAX EXPENSES 16 0 0 0 COMMODITIES & SUPPLIES $4,185 $2,400 $1,628 $2,500 4310 PROFESSIONAL SERVICES 0 0 266 0 4334 MILEAGE AND PARKING 321 500 233 500 4350 PRINTING 384 1,000 860 1,100 4380 CONTRACTED REPAIR & MAINT 86 200 358 200 4393 EQUIPMENT RENTAL 1,352 500 70 500 4418 LOGIS SERVICE 0 400 0 0 4420 OTHER CONTRACTED SERVICES 3,372 6,500 3,905 5,500 4426 SPECIAL EVENTS FEES 692 0 0 0 4428 INSTRUCTOR SERVICE 5,325 4,000 4,641 5,000 CONTRACTED SERVICES $11,532 $13,100 $10,334 $12,800 OPERATING EXPENDITURES $45,780 $47,450 $39,004 $47,250 4267 FURNITURE & FIXTURES 483 800 176 0 4269 OTHER EQUIPMENT 0 0 126 0 4542 COMPUTERS 748 0 0 0 4550 FURNITURE & FIXTURES 0 0 0 8,800 4551 OFFICE EQUIPMENT 265 0 0 0 4552 OTHER EQUIPMENT 2,470 0 0 12,840 CAPITAL OUTLAY $3,966 $800 $302 $21,640 DIVISION TOTAL $49,746 $48,250 $39,306 $68,890 31 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 064 YOUTH RECREATION ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 52,904 36,394 27,850 36,394 4112 OVERTIME-REG 158 0 1,064 0 4130 WAGES NO BENEFITS 101,626 112,300 103,490 102,200 4131 OVERTIME-PART TIME 6 0 0 0 . 4132 LEAVE TIME 7,110 0 3,338 0 PERSONAL SERVICES $161,804 $148,694 $135,742 $138,594 4220 OPERATING SUPPLIES-GENERAL 15,693 16,100 10,543 16,300 4224 CLOTHING & UNIFORMS 9,324 10,100 . 7,076 8,800 4238 REC EQUIP & SUPPLIES 2,529 11,200 1,407 10,900 4250 PHOTO SUPPLIES 138 0 0 0 4257 SALES TAX EXPENSES 122 0 0 0 COMMODITIES & SUPPLIES $27,807 $37,400 $19,026 $36,000 4310 PROFESSIONAL SERVICES (60) 0 0 0 4320 COMMUNICATIONS 0 0 255 0 4321 POSTAGE 0 400 0 400 4322 TELEPHONE 432 450 246 0 4330 TRANSPORTATION 5,350 7,800 2,952 7,800 4334 MILEAGE AND PARKING 1,133 2,100 452 1,900 4350 PRINTING 1,170 3,300 772 3,300 4393 EQUIPMENT RENTAL 0 400 0 400 4395 GYM RENTAL 4,962 2,600 1,496 3,900 4414 LICENSES & TAXES. 18 0 0 0 4415 AWARDS 3,067 3,900 0 3,300 4420 OTHER CONTRACTED SERVICES 13,128 11,700 14,618 9,500 4426 SPECIAL EVENTS FEES 14,200 17;900 11,108 18,400 4428 INSTRUCTOR SERVICE 12,684 10,900 14,096 13,300 CONTRACTED SERVICES • $56,084 $61,450 $45,995 $62,200 OPERATING EXPENDITURES $245,694 $247,544 $200,763 $236,794 4265 SOFTWARE 0 300 11 0 4267 FURNITURE & FIXTURES 483 0 0 0 4269 OTHER EQUIPMENT 107 0 0 0 4542 COMPUTERS 0 2,000 0 0 4552 OTHER EQUIPMENT 0 650 43 300 CAPITAL OUTLAY $590 $2,950 $54 $300 33 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 064 YOUTH RECREATION ACTUAL BUDGET 10/31/98 BUDGET 4910 EXP TO OTHER GOVT UNITS 0 800 0 0 OTHER FINANCING USES $0 $800 $0 $0 4940 MERCHANDISE FOR RESALE 0 2,500 0 0 COST OF GOODS SOLD $0 $2,500 $0 $0 DIVISION TOTAL $246,284 $253,794 $200,817 $237,094 34 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 070 ADAPTIVE REC ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 31,922 36,540 21,928 36,540 4130 WAGES NO BENEFITS 43,273 4,696 25,017 25,000 4131 OVERTIME-PART TIME 90 0 0 0 4132 LEAVE TIME 11,976 0 4,347 0 PERSONAL SERVICES $87,261 $41,236 $51,291 $61,540 4210 OFFICE SUPPLIES 11 200 109 200 4220 OPERATING SUPPLIES-GENERAL 1,079 1,200 356 1,200 4223 CLEANING SUPPLIES 0 0 10 0 4224 CLOTHING & UNIFORMS 180 250 162 250 4249 SAFETY SUPPLIES 0 50 0 50 4250 PHOTO SUPPLIES 77 100 11 100 4257 SALES TAX EXPENSES 3 0 0 0 COMMODITIES & SUPPLIES $1,350 $1,800 $648 $1,800 4330 TRANSPORTATION 193 800 5 500 4334 MILEAGE AND PARKING 1,168 1,200 684 1,200 4350 PRINTING 744 1,200 1,463 1,200 4392 BLDG RENTAL 20 400 275 400 4393 EQUIPMENT RENTAL 0 150 0 150 4395 GYM RENTAL 348 0 0 0 4411 CONFERENCE 110 50 0 50 4413 DUES & SUBSCRIPTIONS 20 0 0 0 4420 OTHER CONTRACTED SERVICES 3,243 3,025 1,572 2,525 4426 SPECIAL EVENTS FEES 85 100 103 100 CONTRACTED SERVICES $5,932 $6;925 s $4,102 $6,125 OPERATING EXPENDITURES $94,542 $49,961 $56,041 $69,465 4267 FURNITURE & FIXTURES 483 0 105 0 4552 OTHER EQUIPMENT 3,284 350 0 0 CAPITAL OUTLAY $3,767 $350 $105 $0 DIVISION TOTAL $98,309 $50,311 $56,146 $69,465 35 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 066 ADULT RECREATION ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 50,120 65,005 45,868 65,005 4130 WAGES NO BENEFITS 1,420 7,400 2,882 8,800 4132 LEAVE TIME 12,811 0 7,587 0 PERSONAL SERVICES $64,350 $72,405 $56,337 $73,805 4210 OFFICE SUPPLIES 332 400 222 400 4220 OPERATING SUPPLIES-GENERAL 1,908 4,600 1,391 4,400 4238 REC EQUIP & SUPPLIES 169 300 52 300 4249 SAFETY SUPPLIES 41 200 37 200 4250 PHOTO SUPPLIES 74 200 57 200 COMMODITIES & SUPPLIES $2,524 $5,700 $1,758 $5,500 4310 PROFESSIONAL SERVICES 0 400 0 400 4321 POSTAGE 10,974 16,300 9,171 16,300 4322 TELEPHONE 1,081 1,200 942 1,200 4330 TRANSPORTATION 491 2,900 711 2,900 4334 MILEAGE AND PARKING 565 1,200 361 1,200 4340 ADVERTISING 34 0 0 0 4350 PRINTING 28,745 43,900 21,003 43,900 4380 CONTRACTED REPAIR & MAINT 0 0 110 0 4382 CONTRACTED EQUIP REPAIR 46 700 122 700 4392 BLDG RENTAL 25 500 0 500 4410 MISCELLANEOUS 0 1,000 107 1,000 4411 CONFERENCE 0 0 0 100 4412 TRAVEL 150 0 2 0 4413 DUES & SUBSCRIPTIONS 119 100 95 300 4414 LICENSES & TAXES 40 0 0 0 4417 SCHOOLS 0 600 0 500 4420 OTHER CONTRACTED SERVICES 8,085 1,200 5,431 1,200 4426 SPECIAL EVENTS FEES 19,065 24,800 12,640 25,800 4428 INSTRUCTOR SERVICE 1,460 3,500 1,356 2,500 CONTRACTED SERVICES $70,880 $98,300 $52,051 $98,500 37 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 066 ADULT RECREATION ACTUAL BUDGET 10/31/98 BUDGET OPERATING EXPENDITURES $137,754 $176,405 $110,146 $177,805 4267 FURNITURE & FIXTURES 3,946 0 0 0 4542 COMPUTERS 0 2,800 2,215 0 4550 FURNITURE& FIXTURES 2,763 0 1,231 1,540 4551 OFFICE EQUIPMENT 657 0 (1,230) 0 4553 PARK EQUIPMENT 0 1,800 0 0 CAPITAL OUTLAY $7,366 $4,600 $2,215 $1,540 DIVISION TOTAL $145,120 $181,005 $112,361 $179,345 38 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 080 ARTS ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 0 23,031 15,607 23,031 4130 WAGES NO BENEFITS 700 400 0 0 4132 LEAVE TIME 0 0 2,206 0 PERSONAL SERVICES $700 $23,431 $17,813 $23,031 4210 OFFICE SUPPLIES 0 0 0 50 4220 OPERATING SUPPLIES-GENERAL 2,275 4,000 5,463 5,100 4224 CLOTHING & UNIFORMS 2,254 0 0 800 4250 PHOTO SUPPLIES 5 0 0 100 4257 SALES TAX EXPENSES 25 0 0 0 COMMODITIES & SUPPLIES $4,559 $4,000 $5,463 $6,050 4321 POSTAGE 16 0 0 0 4334 MILEAGE AND PARKING 0 0 153 400 4340 ADVERTISING 951 500 633 1,100 4350 PRINTING 1,459 3,300 3,470 2,450 4392 BLDG RENTAL 923 800 595 800 4393 EQUIPMENT RENTAL 738 800 1,533 1,000 4410 MISCELLANEOUS 296 200 0 100 4412 TRAVEL 77 100 0 100 4420 OTHER CONTRACTED SERVICES 22,945 30,300 24,886 32,400 4426 SPECIAL EVENTS FEES 0 100 0 100 CONTRACTED SERVICES $27,405 $36,100 $31,269 $38,450 OPERATING EXPENDITURES $32,664 $63,531 $54,546 $67,531 4265 SOFTWARE 0 0 17 0 4553 PARK EQUIPMENT 0 0 0 2,700 CAPITAL OUTLAY $0 $0 $17 $2,700 DIVISION TOTAL $32,664 $63,531 $54,563 $70,231 39 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 061 COMMUNITY CENTER ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 252,688 291,730 214,354 291,730 4112 OVERTIME-REG 3,368 5,500 2,352 5,500 4130 WAGES NO BENEFITS 200,680 212,561 164,677 187,865 4131 OVERTIME-PART TIME 297 0 264 0 4132 LEAVE TIME 36,662 0 33,596 0 4151 HOSPITALIZATION INS 0 0 1,616 0 4159 DISABILITY INS 0 0 39 0 4170 PENSION PLANS 0 0 226 0 PERSONAL SERVICES $493,695 $509,791 $417,124 $485,095 4210 OFFICE SUPPLIES 714 1,300 408 1,300 4220 OPERATING SUPPLIES-GENERAL 9,098 17,950 7,505 17,650 4221 MOTOR FUELS 4,943 3,800 2,617 3,800 4223 CLEANING SUPPLIES 7,669 7,000 7,872 7,000 4224 CLOTHING & UNIFORMS 8,494 8,600 6,904 8,950 4226 CHEMICALS 10,281 8,000 4,807 10,000 4230 REPAIR & MAINT SUPPLIES 100,233 43,950 76,714 49,000 4231 EQUIPMENT PARTS 0 500 0 500 4238 REC EQUIP & SUPPLIES 1,547 5,000 5,556 4,000 4248 TRAINING SUPPLIES 594 1,000 1,194 1,100 4249 SAFETY SUPPLIES 1,306 1,700 627 1,800 4250 PHOTO SUPPLIES 0 0 48 100 4257 SALES TAX EXPENSES 12 0 0 0 COMMODITIES & SUPPLIES $144,893 $98,800 $114,251 $105,200 4320 COMMUNICATIONS 460 0 706 0 4322 TELEPHONE 0 ` 800 609 800 4334 MILEAGE AND PARKING 1,045 1,600 526 1,800 4340 ADVERTISING 1,256 4,000 2,043 4,000 4350 PRINTING 965 1,700 587 1,700 4371 ELECTRIC 131,586 125,000 110,631 125,000 4372 GAS 80,923 87,000 36,193 87,000 4375 WASTE DISPOSAL 3,418 3,500 3,100 3,500 4380 CONTRACTED REPAIR & MAINT 6,758 18,200 5,900 18,200 4382 CONTRACTED EQUIP REPAIR 0 1,000 0 1,000 4396 COURT TIME RENTAL 0 1,500 0 0 4397 ICE TIME RENTAL 0 23,500 0 23,500 4410 MISCELLANEOUS 72 0 0 0 4412 TRAVEL 163 200 26 200 4413 DUES & SUBSCRIPTIONS 200 0 213 100 4414 LICENSES & TAXES 1,559 1,800 855 1,600 4415 AWARDS 1,063 1,100 620 1,100 4417 SCHOOLS 397 0 161 0 41 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 061 COMMUNITY CENTER ACTUAL BUDGET 10/31/98 BUDGET 4420 OTHER CONTRACTED SERVICES 22,770 15,900 10,569 15,800 4428 INSTRUCTOR SERVICE 14,656 26,000 15,710 26,000 CONTRACTED SERVICES $267,290 $312,800 $188,448 $311,300 OPERATING EXPENDITURES $905,878 $921,391 $719,823 $901,595 4265 SOFTWARE 1,272 0 465 0 4267 FURNITURE & FIXTURES 3,571 0 0 0 4520 BUILDING 41,850 51,750 10,369 12,000 4540 MACHINERY EQUIPMENT 0 0 0 1,500 4542 COMPUTERS 0 7,225 3,015 0 4550 FURNITURE & FIXTURES 14,490 0 0 0 4551 OFFICE EQUIPMENT 805 0 0 0 4552 OTHER EQUIPMENT 34,658 39,600 28,918 3,000 CAPITAL OUTLAY $96,646 $98,575 $42,767 $16,500 4710 PERMANENT TRANSFER 259,170 266,000 0 268,050 4750 BANK CHGS & S/C 4,765 3,200 3,209 3,200 OTHER FINANCING USES $263,935 $269,200 $3,209 $271,250 4940 MERCHANDISE FOR RESALE 37,193 22,000 20,280 25,000 COST OF GOODS SOLD $37,193 $22,000 $20,280 $25,000 DIVISION TOTAL $1,303,652 $1,311,166 $786,079 $1,214,345 42 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 045 POLICE ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 1,983,654 2,370,106 1,721,190 2,370,106 4112 OVERTIME-REG 119,155 120,000 94,468 120,000 4130 WAGES NO BENEFITS 14,988 30,000 15,411 30,000 4131 OVERTIME-PART TIME 51 0 24 0 4132 LEAVE TIME 284,682 0 230,023 0 PERSONAL SERVICES $2,402,530 $2,520,106 $2,061,117 $2,520,106 4210 OFFICE SUPPLIES 18,381 12,400 12,209 12,400 4211 CANINE SUPPLIES 2,220 5,000 1,233 5,000 4220 OPERATING SUPPLIES-GENERAL 138 10,350 8,063 35,350 4224 CLOTHING & UNIFORMS 25,661 56,400 14,035 67,800 4225 PROTECTIVE CLOTHING 695 0 0 0 4246 VIDEO SUPPLIES 2,848 3,250 372 3,250 4248 TRAINING SUPPLIES 12,613 14,225 12,193 57,400 4250 PHOTO SUPPLIES 4,755 5,500 4,266 5,500 4254 RESERVE EQUIPMENT 4,571 4,300 2,425 6,800 4257 SALES TAX EXPENSES 41 0 0 0 COMMODITIES & SUPPLIES $71,922 $111,425 $54,797 $193,500 4310 PROFESSIONAL SERVICES 12,425 15,050 5,476 10,050 4312 LEGAL SERVICE 580 0 10,529 0 4320 COMMUNICATIONS 33,391 36,750 22,668 83,392 4321 POSTAGE 9 0 0 0 4322 TELEPHONE 8,721 11,000 9,611 14,000 4331 INVESTIGATION TRAVEL 861 2,000 1,112 2,000 4334 MILEAGE AND PARKING 161 0 0 0 4350 PRINTING 14,707 15,000 4,820 15,000 4380 CONTRACTED REPAIR & MAINT 45,833 71,100 45,421 12,300 4386 CONTRACTED COMM MAINT 29,084 38,000 35,586 71,500 4390 RENTALS 2,951 7,700 3,508 5,200 4393 EQUIPMENT RENTAL 4,740 5,000 4,500 5,000 4410 MISCELLANEOUS 490 500 1,288 1,000 4411 CONFERENCE 2,312 4,000 4,457 4,000 4412 TRAVEL 650 500 1,896 500 4413 DUES & SUBSCRIPTIONS 2,875 3,500 2,838 3,500 43 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 045 POLICE ACTUAL BUDGET 10/31/98 BUDGET 4414 LICENSES & TAXES 277 2,300 2,310 1,300 4415 AWARDS 22 0 0 0 4417 SCHOOLS 23,202 30,000 16,879 30,000 4425 BOARD OF PRISONERS SVC 43,052 45,000 38,521 45,000 4431 KENNEL SERVICE 0 0 260 0 CONTRACTED SERVICES $226,340 $287,400 $211,678 $303,742 OPERATING EXPENDITURES $2,700,792 $2,918,931 $2,327,593 $3,017,348 4247 POLICE EQUIPMENT 30,982 0 9 0 4265 SOFTWARE 723 0 429 0 4266 OFFICE EQUIPMENT 575 0 0 0 4269 OTHER EQUIPMENT 0 0 4,385 0 4513 PAGERS & RADAR EQUIP 11,953 5,000 0 5,250 4517 RADIOS 4,923 15,000 14,636 67,350 4527 SOFTBODY ARMOR 7,538 7,900 395 5,900 4542 COMPUTERS 9,170 610,000 29,528 17,300 4550 FURNITURE & FIXTURES 8,927 16,000 9,280 22,500 4552 OTHER EQUIPMENT 44,987 48,650 19,257 0 CAPITAL OUTLAY $119,777 $702,550 $77,919 $118,300 4980 REFUNDS (13,502) 0 (18,423) 0 OTHER FINANCING USES $(13,502) $0 $(18,423) $0 DIVISION TOTAL $2,807,067 $3,621,481 $2,387,088 $3,135,648 44 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 042 TELECOMMUNICATORS ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 239,405 311,049 210,536 311,049 4112 OVERTIME-REG 15,037 15,000 15,210 15,000 4130 WAGES NO BENEFITS 0 0 0 30,000 4132 LEAVE TIME 61,965 0 29,569 0 PERSONAL SERVICES $316,407 $326,049 $255,315 $356,049 DIVISION TOTAL $316,407 $326,049 $255,315 $356,049 45 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 043 POLICE ADMIN ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 461,065 571,590 424,641 571,590 4112 OVERTIME-REG 3,968 4,000 3,133 4,000 4132 LEAVE TIME 152,739 0 74,257 0 PERSONAL SERVICES $617,771 $575,590 $502,031 $575,590 4334 MILEAGE AND PARKING 1,200 0 0 0 CONTRACTED SERVICES $1,200 $0 $0 $0 OPERATING EXPENDITURES $618,971 $575,590 $502,031 $575,590 DIVISION TOTAL $618,971 $575,590 $502,031 $575,590 46 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 044 CIVIL DEFENSE ACTUAL BUDGET 10/31/98 BUDGET 4220 OPERATING SUPPLIES-GENERAL 944 1,000 38 1,000 4231 EQUIPMENT PARTS 0 2,000 459 2,000 COMMODITIES & SUPPLIES $944 $3,000 $496 $3,000 4334 MILEAGE AND PARKING 0 200 0 200 4371 ELECTRIC 603 700 452 800 4380 CONTRACTED REPAIR & MAINT 5,424 15,000 9,586 15,000 4411 CONFERENCE 45 500 0 500 4413 DUES & SUBSCRIPTIONS 60 50 20 60 CONTRACTED SERVICES $6,132 $16,450 $10,058 $16,560 OPERATING EXPENDITURES $7,076 $19.450 $10,554 $19,560 4517 RADIOS 9,109 0 0 0 4550 FURNITURE & FIXTURES 0 0 0 2,500 CAPITAL OUTLAY $9,109 $0 $0 $2,500 4980 REFUNDS 0 0 (5,644) 0 OTHE., FINANCING USES $0 $0 $(5,644) $0 DIVISION TOTAL $16,185 $19,450 $4,910 $22,060 • 47 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 048 ANIMAL CONTROL ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 50,474 60,573 42,739 60,573 4112 OVERTIME-REG 13,213 7,000 9,718 7,000 4130 WAGES NO BENEFITS 6,849 12,000 4,392 12,000 4132 LEAVE TIME 7,804 0 7,154 0 PERSONAL SERVICES $78,340 $79,573 $64,003 $79,573 4220 OPERATING SUPPLIES-GENERAL 1,403 1,000 555 1,000 4224 CLOTHING & UNIFORMS 1,291 1,500 80 1,500 COMMODITIES & SUPPLIES $2,693 $2,500 $635 $2,500 4310 PROFESSIONAL SERVICES 2,229 9,700 1,195 9,700 4409 DONATIONS/CONTRIBUTIONS 0 1,000 0 1,000 4413 DUES & SUBSCRIPTIONS 25 25 0 25 4431 KENNEL SERVICE 7,550 6,000 3,190 6,000 CONTRACTED SERVICES $9,804 $16,725 $4,385 $16,725 OPERATING EXPENDITURES $90,838 $98,798 $69,022 $98,798 DIVISION TOTAL $90,838 $98,798 $69,022 $98,798 48 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 046 FIRE ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 23,567 28,940 13,486 28,940 4112 OVERTIME-REG 1,120 1,500 260 1,500 4132 LEAVE TIME 5,340 0 10,021 0 4170 PENSION PLANS 500,000 528,000 264,000 528,000 PERSONAL SERVICES $530,027 $558,440 $287,766 $558,440 4210 OFFICE SUPPLIES 1,617 2,000 641 2,000 4220 OPERATING SUPPLIES-GENERAL 21,766 15,000 12,438 15,000 4224 CLOTHING & UNIFORMS 3,393 12,000 5,614 12,000 4225 PROTECTIVE CLOTHING 8,689 20,500 13,963 20,000 4230 REPAIR & MAINT SUPPLIES 203 0 142 0 4248 TRAINING SUPPLIES 4,241 8,000 1,868 8,000 4249 SAFETY SUPPLIES 6,138 5;000 3,353 5,000 4250 PHOTO SUPPLIES 272 800 247 800 4251 FIRE PREVENTION SUPPLIES 5,290 5,000 4,860 6,500 4252 EQUIPMENT TESTING & CERT 0 0 6,258 0 4257 SALES TAX EXPENSES 5 0 0 0 COMMODITIES & SUPPLIES $51,614 $68,300 $49,383 $69,300 4133 WAGES CONTRACTED (2,118) 0 0 0 4135 VOLUNTEER WAGES 213,349 250,000 125,316 250,000 4310 PROFESSIONAL SERVICES 1,384 4,000 246 4,000 4311 PERSONNEL TESTING 3,681 5,000 3,116 5,000 4312 LEGAL SERVICE 2,844 4,000 150 3,000 I 4320 COMMUNICATIONS 1,235 0 2,000 0 4321 POSTAGE 16 0 3,067 0 4322 TELEPHONE 12,355 15,000 10,308 15,000 4334 MILEAGE AND PARKING 2,218 3,000 632 3,000 4350 PRINTING 1,959 2,000 0 2,000 4380 CONTRACTED REPAIR & MAINT 26,139 35,000 23,378 35,000 4390 RENTALS 680 1,500 606 1,000 4410 MISCELLANEOUS 0 1,000 0 0 4411 CONFERENCE 3,446 6,000 2,905 6,000 4412 TRAVEL 3,801 0 4,654 0 4413 DUES & SUBSCRIPTIONS 2,912 3,000 1,844 3,000 49 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 046 FIRE ACTUAL BUDGET 10/31/98 BUDGET 4414 LICENSES & TAXES 3,707 1,000 860 1,000 4417 SCHOOLS 9,664 15,000 2,805 15,000 4420 OTHER CONTRACTED SERVICES 100 3,000 775 0 4432 EQUIP TESTING & CERTIFICATION 4,226 7,000 0 7,000 4437 MOWING 731 0 0 0 CONTRACTED SERVICES $292,330 $355,500 $182,661 $350,000 OPERATING EXPENDITURES $873,971 $982,240 $519,811 $977,740 4229 MISC FIRE EQUIPMENT 3,730 2,000 3,433 2,000 4266 OFFICE EQUIPMENT 907 0 0 0 4269 OTHER EQUIPMENT 20,451 0 4,385 0 4513 PAGERS & RADAR EQUIP 1,913 0 0 0 4517 RADIOS 0 22,000 21,370 22,000 4528 FIRE PORTABLE EQUIP 25,350 0 0 0 4542 COMPUTERS 2,602 2,000 1,747 2,000 4550 FURNITURE & FIXTURES 0 0 0 2,400 4551 OFFICE EQUIPMENT 2,032 0 0 • 8,000 4552 OTHER EQUIPMENT 0 49,000 19,508 48,000 CAPITAL OUTLAY $56,985 $75,000 $50,443 $84,400 DIVISION TOTAL $930,957 $1,057,240 $570,254 $1,062,140 50 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 035 INSPECTIONS ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 455,689 639,794 405,862 639,794 4112 OVERTIME-REG 8,014 12,500 7,107 8,000 4130 WAGES NO BENEFITS 36,124 22,000 0 20,000 4131 OVERTIME-PART TIME 1,436 0 0 0 4132 LEAVE TIME 86,232 0 67,162 0 PERSONAL SERVICES $587,494 $674,294 $480,132 $667,794 4210 OFFICE SUPPLIES 139 0 0 0 4220 OPERATING SUPPLIES-GENERAL 2,991 3,000 1,440 4,000 4224 CLOTHING & UNIFORMS 1,847 2,200 2,074 2,200 4250 PHOTO SUPPLIES 40 400 74 300 COMMODITIES & SUPPLIES $5,017 $5,600 $3,588 $6,500 4320 COMMUNICATIONS 848 1,600 1,247 900 4322 TELEPHONE 1,109 1,200 796 1,900 4334 MILEAGE AND PARKING 2,599 2,700 2,031 2,700 4350 PRINTING 2,024 3,500 1,319 3,000 4380 CONTRACTED REPAIR & MAINT 141 0 406 0 CONTRACTED SERVICES $6,722 $9,000 $5,799 $8,500 OPERATING EXPENDITURES $599,233 $688,894 $489,518 $682,794 4265 SOFTWARE 999 0 683 0 4267 FURNITURE & FIXTURES 200 0 442 0 4542 COMPUTERS 25,465 0 0 2,000 4550 FURNITURE & FIXTURES 0 2,500 1,006 3,000 4551 OFFICE EQUIPMENT 1,259 2,000 4,292 1,000 CAPITAL OUTLAY $27,924 $4,500 $6,423 $6,000 4940 MERCHANDISE FOR RESALE 0 0 0 0 COST OF GOODS SOLD $0 $0 $0 $0 DIVISION TOTAL $627,157 $693,394 $495,941 $688,794 51 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 030 ENGINEERING ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 507,132 652,414 408,019 696,414 4112 OVERTIME-REG 3,205 7,500 1,147 1,000 4130 WAGES NO BENEFITS 13,144 10,000 12,928 0 4131 OVERTIME-PART TIME 140 0 0 0 4132 LEAVE TIME 95,682 0 71,389 0 PERSONAL SERVICES $619,303 $669,914 $493,483 $697,414 4219 RECORDING DOCUMENT FEE 1,383 3,000 825 3,000 4220 OPERATING SUPPLIES-GENERAL 5,265 8,500 2,181 8,500 4250 PHOTO SUPPLIES 21 0 24 0 COMMODITIES & SUPPLIES $6,670 $11,500 $3,031 $11,500 4320 COMMUNICATIONS 156 200 115 0 4322 TELEPHONE 0 0 248 0 4334 MILEAGE AND PARKING 4,900 5,000 4,166 5,000 4351 LEGAL NOTICES PUBLISHING 0 0 287 0 4380 CONTRACTED REPAIR & MAINT 925 2,400 0 3,700 4411 CONFERENCE 0 0 315 0 4412 TRAVEL 15 0 284 0 4413 DUES & SUBSCRIPTIONS 55 0 155 0 4414 LICENSES & TAXES 0 0 140 0 4420 OTHER CONTRACTED SERVICES 6,764 37,500 4,586 10,200 4430 MICROFILMING SERVICE 858 5,000 8,866 0 CONTRACTED SERVICES $13,672 $50,100 $19,162 $18,900 OPERATING EXPENDITURES $639,645 $731,514 $515,675 $727,814 53 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 030 ENGINEERING ACTUAL BUDGET 10/31/98 BUDGET 4265 SOFTWARE 119 0 0 0 4266 OFFICE EQUIPMENT 646 0 0 0 4267 FURNITURE & FIXTURES 146 425 159 0 4269 OTHER EQUIPMENT 0 200 0 0 4542 COMPUTERS 31,253 8,400 5,044 13,200 4550 FURNITURE & FIXTURES 4,039 4,800 1,751 2,050 4551 OFFICE EQUIPMENT 5,398 1,700 200 12,000 4552 OTHER EQUIPMENT 0 1,500 0 2,000 CAPITAL OUTLAY $41,601 $17,025 $7,154 $29,250 DIVISION TOTAL $681,246 $748,539 $522,829 $757,064 54 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 050 STREETS/TRAFFIC ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 488,931 583,032 414,894 583,032 4112 OVERTIME-REG 37,181 40,000 28,908 40,000 4130 WAGES NO BENEFITS 21,475 33,000 29,789 33,000 4131 OVERTIME-PART TIME 402 0 749 0 4132 LEAVE TIME 103,067 0 91,339 0 PERSONAL SERVICES $651,056 $656,032 $565,679 $656,032 4210 OFFICE SUPPLIES 3 500 0 0 4220 OPERATING SUPPLIES-GENERAL 12,089 12,295 10,059 12,600 4224 CLOTHING & UNIFORMS 12,329 7,500 1,760 7,500 4226 CHEMICALS 0 500 38 0 4227 BUILDING MATERIALS 1,216 1,500 1,619 2,000 4230 REPAIR & MAINT SUPPLIES 7,400 0 4,881 0 4235 LANDSCAPE MTLS & AG SUPPL 1,475 1,000 1,279 2,000 4236 SIGNS 18,352 22,000 15,626 24,000 4240 SMALL TOOLS 650 2,000 1,459 7,500 4249 SAFETY SUPPLIES 0 600 612 0 4250 PHOTO SUPPLIES 244 200 25 200 4252 EQUIPMENT TESTING & CERT 234 0 0 0 4257 SALES TAX EXPENSES 13 0 0 0 4259 SALT 30,448 39,000 18,767 45,000 4261 GRAVEL 5,577 4,000 3,666 4,000 4262 SAND 9,308 11,000 6,021 11,000 4263 PATCHING ASPHALT 50,846 45,000 32,173 48,000 4264 WASTE BLACKTOP/CONCRETE 756 1,000 1,842 1,000 COMMODITIES & SUPPLIES $150,939 $148,095 $99,830 $164,800 4260 ASPHALT OVERLAY 215,284 200,000 30,521 220,000 4310 PROFESSIONAL SERVICES 0 0 2,556 0 4316 DESIGN & CONST 0 0 2,051 0 4320 COMMUNICATIONS 440 1,000 1,192 0 4322 TELEPHONE 1,019 1,200 973 0 4334 MILEAGE AND PARKING 7 0 0 0 4350 PRINTING 260 500 99 500 4351 LEGAL NOTICES PUBLISHING 0 0 91 0 4371 ELECTRIC 64,541 65,000 51,663 65,000 4375 WASTE DISPOSAL 648 500 265 1,000 4380 CONTRACTED REPAIR & MAINT 20,300 43,500 130,006 60,600 4382 CONTRACTED EQUIP REPAIR 488 0 0 0 4386 CONTRACTED COMM MAINT (204) 0 (208) 0 4390 RENTALS 500 0 0 0 4392 BLDG RENTAL 3,500 0 0 0 4393 EQUIPMENT RENTAL 14,605 15,000 13,461 11,800 55 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 050 STREETS/TRAFFIC ACTUAL BUDGET 10/31/98 BUDGET 4394 OFFICE EQUIP MAINT 415 500 0 0 4411 CONFERENCE 0 0 95 0 4413 DUES & SUBSCRIPTIONS 16 200 0 0 4414 LICENSES & TAXES 0 300 114 300 4420 OTHER CONTRACTED SERVICES 2,095 42,300 1,350 32,200 4427 FIREWORKS SERVICE 324 0 0 0 4433 DUST COATING 357 1,000 500 500 4434 MUDJACKING CURBS 3,000 3,000 3,000 5,000 4435 SWEEPING 13,704 0 671 0 4437 MOWING 5,001 0 0 0 4439 SEAL COATING CONTRACTED 222,764 234,450 187,311 244,900_ 4440 CONTRACTED STRIPING 42,916 42,000 35,029 48,000 CONTRACTED SERVICES $611,977 $650,450 $460,740 $689,800 OPERATING EXPENDITURES $1,413,973 $1,454,577 $1,126,248 $1,510,632 4265 SOFTWARE 4,290 0 557 0 4267 FURNITURE & FIXTURES (218) 0 367 0 4500 OTHER CAPITAL (5,672) 0 0 0 4530 IMPROVEMENT CONTRACTS 37,331 125,000 70,945 0 4542 COMPUTERS 0 6,000 6,649 0 4550 FURNITURE & FIXTURES 437 1,200 2,087 1,200 4552 OTHER EQUIPMENT 13,282 7,125 1.437 23,000 CAPITAL OUTLAY $49,450 $139,325 $82,042 $24,200 4980 REFUNDS (4,732) 0 0 0 OTHER FINANCING USES $(4,732) $0 $0 $0 DIVISION TOTAL $1,458,690 $1,593,902 $1,208,291 $1,534,832 56 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 054 FLEET SERVICES ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 187,806 289,000 182,380 289,000 4112 OVERTIME-REG 4,520 5,000 2,969 5,000 4130 WAGES NO BENEFITS 625 0 0 0 4132 LEAVE TIME 44,130 0 42,091 0 PERSONAL SERVICES $237,082 $294,000 $227,439 $294,000 4220 OPERATING SUPPLIES-GENERAL 2,361 2,500 1,975 2,500 4221 MOTOR FUELS 109,753 120,000 94,022 120,000 4222 LUBRICANTS & ADDITIVES 21,759 20,000 14,527 22,000 4224 CLOTHING & UNIFORMS 2,474 3,000 699 3,000 4225 PROTECTIVE CLOTHING 0 0 654 0 4230 REPAIR & MAINT SUPPLIES 2,129 0 0 0 4231 EQUIPMENT PARTS 118,385 131,000 132,083 130,000 4232 TIRES 28,468 30,000 18,045 32,000 - 4233 BLDG REPAIR & MAINT 720 0 47 0 4240 SMALL TOOLS 26,855 30,000 22,432 28,000 4248 TRAINING SUPPLIES 39 0 0 0 4249 SAFETY SUPPLIES 286 0 3,167 3,000 4252 EQUIPMENT TESTING & CERT 1,411 2,000 0 2,000 4257 SALES TAX EXPENSES 52 0 0 0 4259 SALT 0 0 115 0 COMMODITIES & SUPPLIES $314,690 $338,500 $287,766 $342,500 4320 COMMUNICATIONS 437 0 684 0 4321 POSTAGE 0 0 10 0 4322 TELEPHONE 356 0 290 0 4334 MILEAGE AND PARKING 960 1,000 695 1,500 4340 ADVERTISING 0 0 198 0 4375 WASTE DISPOSAL 1,178 1,000 861 1,500 4380 CONTRACTED REPAIR & MAINT 71,611 85,000 60,038 80,000 4386 CONTRACTED COMM MAINT 0 0 35 0 4413 DUES & SUBSCRIPTIONS 0 0 350 0 4414 LICENSES & TAXES 423 1,000 468 1,000 4417 SCHOOLS 150 0 0 4420 OTHER CONTRACTED SERVICES 1,241 1,000 32 9,000 4432 EQUIP TESTING & CERTIFICATION 945 0 0 1,000 CONTRACTED SERVICES $77,300 $89,000 $63,661 $94,000 OPERATING EXPENDITURES $629,072 $721,500 $578,866 $730,500 57 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 054 FLEET SERVICES ACTUAL BUDGET 10/31/98 BUDGET 4229 MISC FIRE EQUIPMENT 0 0 476 0 4255 NEW CAR EQUIPMENT 33,088 27,500 29,596 35,000 4265 SOFTWARE 2,431 0 0 0 4266 OFFICE EQUIPMENT 0 0 703 0 4267 FURNITURE & FIXTURES 426 0 439 0 4269 OTHER EQUIPMENT 0 0 383 0 4542 COMPUTERS 1,963 8,000 8,328 5,000 4550 FURNITURE & FIXTURES 0 0 523 0 4551 OFFICE EQUIPMENT 0 0 505 0 4552 OTHER EQUIPMENT 1,269 0 1,272 5,500 CAPITAL OUTLAY $39,177 $35,500 $42,224 $45,500 4980 REFUNDS 0 (7,500) 0 (7,500) OTHER FINANCING USES $0 $(7,500) $0 $(7.500) DIVISION TOTAL $668,248 $749,500 $621,090 $768,500 58 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 053 STREET LIGHTING ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 1,761 0 1,006 0 4112 OVERTIME-REG 73 0 0 0 PERSONAL SERVICES $1,834 $0 $1,006 $0 4220 OPERATING SUPPLIES-GENERAL 2,093 3,000 2,086 3,000 COMMODITIES & SUPPLIES $2,093 $3,000 $2,086 $3,000 4371 ELECTRIC 568,593 600,000 436,089 600,000 4380 CONTRACTED REPAIR & MAINT 4,768 3,500 812 3,500 4420 OTHER CONTRACTED SERVICES 1,849 5,000 2,415 10,000 CONTRACTED SERVICES $575,210 $608,500 $439,316 $613,500 OPERATING EXPENDITURES $579,136 $611,500 $442,408 $616,500 DIVISION TOTAL $579,136 $611,500 $442,408 $616,500 59 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 012 GENERAL SERVICES ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 42,055 49,152 41,163 49,152 4112 OVERTIME-REG 73 750 58 750 4130 WAGES NO BENEFITS 9,582 2,500 10,148 2,500 4131 OVERTIME-PART TIME 155 0 42 0 4132 LEAVE TIME 5,518 0 7,620 0 PERSONAL SERVICES $57,383 $52,402 $59,031 $52,402 4210 OFFICE SUPPLIES 58,873 47,000 42,299 48,400 4220 OPERATING SUPPLIES-GENERAL 502 0 659 0 4249 SAFETY SUPPLIES 605 0 0 0 4257 SALES TAX EXPENSES 56 0 0 0 COMMODITIES & SUPPLIES $60,036 $47,000 $42,958 $48,400 4321 POSTAGE 48,632 41,250 41,851 42,540 4322 TELEPHONE 86,771 104,632 88,352 111,290 4334 MILEAGE AND PARKING 0 0 25 0 4340 ADVERTISING 0 0 335 0 4350 PRINTING 148 0 4,232 500 4351 LEGAL NOTICES PUBLISHING 13,410 12,000 7,376 0 4360 INSURANCE 248,814 270,000 239,531 0 4375 WASTE DISPOSAL 0 0 32 0 4380 CONTRACTED REPAIR & MAINT 29,129 25,390 18,690 26,950 4390 RENTALS 6,203 14,970 7,698 7,900 4393 EQUIPMENT RENTAL 206 0 0 0 4400 CABLE TV 0 0 65 0 4420 OTHER CONTRACTED SERVICES 6,133 10,000 0 10,200 CONTRACTED SERVICES $439,445 $478,242 $408,187 $199,380 OPERATING EXPENDITURES $556,864 $577,644 $510,175 $300,182 4267 FURNITURE & FIXTURES 1,070 0 490 0 4551 OFFICE EQUIPMENT 0 0 3,159 1,500 CAPITAL OUTLAY $1,070 $0 $3,648 $1,500 DIVISION TOTAL $557,933 $577,644 $513,824 $301,682 60 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 022 RISK MANAGEMENT/CUST ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 20,277 0 0 0 4132 LEAVE TIME 2,863 0 0 0 PERSONAL SERVICES $23,140 $0 $0 $0 4248 TRAINING SUPPLIES 505 0 0 0 4249 SAFETY SUPPLIES (50) 0 0 10,000 4257 SALES TAX EXPENSES 6 0 0 0 COMMODITIES & SUPPLIES $461 $0 $0 $10,000 4310 PROFESSIONAL SERVICES 0 0 0 15,700 4320 COMMUNICATIONS 1 0 0 0 4350 PRINTING 0 0 0 3,200 4360 INSURANCE 0 0 0 275,000 4410 MISCELLANEOUS 0 0 0 4,000 4414 LICENSES & TAXES 50 0 0 0 4417 SCHOOLS 786 0 0 0 CONTRACTED SERVICES $837 $0 $0 $297,900 OPERATING EXPENDITURES $24,438 $0 $0 $307,900 DIVISION TOTAL $24,438 $0 $0 $307,900 61 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 014 INFORMATION TECHNOLO ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 0 48,400 37,977 48,400 4132 LEAVE TIME 0 0 1,669 0 PERSONAL SERVICES $0 $48,400 $39,646 $48,400 4220 OPERATING SUPPLIES-GENERAL 0 0 56 0 COMMODITIES & SUPPLIES $0 $0 $56 $0 4310 PROFESSIONAL SERVICES 0 0 0 1,600 4380 CONTRACTED REPAIR & MAINT 14,126 12,000 28,166 10,000 4418 LOGIS SERVICE 150,459 176,000 89,698 235,000 4420 OTHER CONTRACTED SERVICES 0 10,000 0 30,000 CONTRACTED SERVICES $164,585 $198,000 $117,863 $276,600 OPERATING EXPENDITURES $164,585 $246,400 $157,566 $325,000 4265 SOFTWARE 4,335 0 1,681 0 4266 OFFICE EQUIPMENT 2,558 0 0 • 0 4267 FURNITURE & FIXTURES 0 0 61 0 4542 COMPUTERS 111,266 115,000 6,593 8,500 4550 FURNITURE & FIXTURES 2,993 5,000 102 0 CAPITAL OUTLAY $121,152 $120,000 $8,437 $8,500 DIVISION TOTAL $285,737 $366,400 $166,002 $333,500 62 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 011 LEGAL COUNSEL ACTUAL BUDGET 10/31/98 BUDGET 4312 LEGAL SERVICE 242,208 275,000 151,526 275,000 4413 DUES & SUBSCRIPTIONS (150) 0 0 0 4431 KENNEL SERVICE 0 0 720 0 CONTRACTED SERVICES $242,058 $275.000 $152,246 $275,000 OPERATING EXPENDITURES $242,058 $275,000 $152.246 $275,000 DIVISION TOTAL $242,058 $275,000 $152,246 $275,000 63 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 013 EMPLOYEE BENEFITS ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 0 43,780 0 545,665 4120 FUNDING OF SEVERANCE 0 40,000 0 40,000 4132 LEAVE TIME (734) 0 0 0 4151 HOSPITALIZATION INS 661,700 722,652 574,942 787,700 4152 COBRA COSTS/REV 786 0 6,097 0 4154 WORKMANS COMP INS 143,988 200,000 108,924 180,000 4156 UNEMPLOYMENT COMP 11,322 9,000 5,286 11,000 4158 DENTAL REIMBURSEMENT 47,089 63,000 38,068 65,000 4159 DISABILITY INS 24,740 37,000 21,200 37,000 4160 LIFE EMPLOYERS SHARE 0 13,500 0 14,400 4170 PENSION PLANS 1,144,655 1,133,600 1,005,180 1,245,340 PERSONAL SERVICES $2,033,546 $2,262,532 $1,759,696 $2,926,105 4210 OFFICE SUPPLIES 3 0 0 0 4248 TRAINING SUPPLIES 0 500 1,530 1,000 COMMODITIES & SUPPLIES $3 $500 $1,530 $1,000 4142 EMPLOYEE ASSISTANCE 7,859 8,000 2,750 5,000 4310 PROFESSIONAL SERVICES 7,854 2,200 2,774 1,200 4321 POSTAGE 67 0 0 0 4334 MILEAGE AND PARKING 0 0 12 13,235 4350 PRINTING 791 750 0 750 4410 MISCELLANEOUS 20,279 0 1,201 0 4411 CONFERENCE 56,020 75,100 27,827 75,500 4412 TRAVEL 19,643 13,500 9,538 13,500 4413 DUES & SUBSCRIPTIONS 20,352 17,000 18,869 17,000 4414 LICENSES & TAXES 155 - 300 0 300 4415 AWARDS 0 0 207 0 4417 SCHOOLS 6,714 8,000 2,455 8,000 CONTRACTED SERVICES $139,735 $124,850 $65,632 $134,485 OPERATING EXPENDITURES $2,173,283 $2,387,882 $1,826,857 $3,061,590 DIVISION TOTAL $2,173,283 $2,387,882 $1,826,857 $3,061,590 64 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 009 CONTINGENCY ACTUAL BUDGET 10/31/98 BUDGET 4310 PROFESSIONAL SERVICES 5,310 0 0 0 4410 MISCELLANEOUS 1,371 0 0 0 4420 OTHER CONTRACTED SERVICES 122,000 0 0 0 4431 KENNEL SERVICE 2,404 0 0 0 CONTRACTED SERVICES $131,085 $0 $0 $0 OPERATING EXPENDITURES $131,085 $0 $0 $0 4552 OTHER EQUIPMENT 0 0 4,736 0 CAPITAL OUTLAY $0 $0 $4,736 $0 4710 PERMANENT TRANSFER 7,662 0 0 0 4995 CONTINGENCY 2,790 140,000 5,500 154,000 - OTHER FINANCING USES $10,452 $140,000 $5,500 $154,000 DIVISION TOTAL $141,537 $140,000 $10,235 $154,000 65 City of Eden Prairie 1999 Proposed Budget Vehicles and Equipment-Detailed Listing Department Description Cost Public Works Single Axle Dump Truck 87,863 Sign Truck 75,615 20 Ton Trailer 15,000 Roller 17,000 1 Ton Dump Truck 37,541 3/4 4x4 Pickup 26,519 3/4 4x4 Pickup 26,519 Subtotal 286,057 Police/Fire Crown Victoria 21,500 Crown Victoria 21,500 Crown Victoria 21,500 Crown Victoria 21,500 Crown Victoria 21,500 Crown Victoria 21,500 Mid-size 17,812 Setup 5,000 Suburban 38,000 Subtotal 189,812 Parks .Holder 69,997 Toro 325d 19,000 Cushman 19,000 3/4 ton 4x4 Pickup 25,001 3/4 ton 4x4 Pickup 25,001 Subtotal 157,999 Mid-size 18,132 18,132 Total $652,000 66 City of Eden Prairie 1999 Water&Sewer Proposed Budget 1998 Actual 1999 1997 1998 10/31/98 Proposed Actual Budget (Unaudited) Budget Operating Revenues: Sales $ 5,757,369 $ 6,422,772 $ 4,491,825 $ 6,450,000 System access charges(1% SAC) 9,965 10,000 0 10,000 Sale of meters 18,437 15,000 0 15,000 Penalty charges 22,547 19,000 0 20,000 Other 37,853 1,000 3,310 1,000 Total Operating Revenues 5,846,171 6,467,772 4,495,135 6,496,000 Operating Expenses: Personal services 1,254,492 1,422,300 1,084,236 1,415,732 Chemicals and supplies 361,312 454,400 320,590 390,020 Contractual services 687,079 655,370 536,884 660,000 Repairs and maintenance 480,630 609,600 360,174 660,930 Disposal charges 2,638,734 2,700,000 2,050,683 2,700,000 Utilities 373,943 372,850 350,470 393,850 Total Operating Expenses 5,796,190 6,214,520 4,703,037 6,220,532 Operating income(loss)before depreciation 49,981 253,252 (207,902) 275,468 Depreciation: Equipment 116,556 82,000 0 115,000 Infrastructure 1,020,303 0 0 0 Total Depreciation 1,136,859 82,000 0 115,000 Operating income(loss) (1,086,878) 171,252 (207,902) 160,468 Nonoperating Revenues(Expenses): Interest on investments 75,489 65,000 0 65,000 Special assessments 10,497 ' 0 58,640 0 Loss on investment 0 0 0 0 Gain on sale of fixed assets 7,696 0 0 0 Total Nonoperating Revenues(Expenses) 93,682 65,000 58,640 65,000 Income(loss)before Operating Transfers (993,196) 236,252 (149,262) 225,468 Operating Transfers Out (50,000) (50,000) 0 (50,000) Net income(loss) (1,043,196) 186,252 (149,262) 175,468 Add back: for depreciation charged to contributions in aid to construction 1,020,303 0 0 0 Increase(decrease)in Retained Earnings (22,893) $ 186,252 (149,262) $ 175,468 Retained Earnings,January 1 1,172,599 1,149,706 Retained Earnings,(deficit)December 31 $ 1,149,706 $ 1,000,444 67 City of Eden Prairie 1999 Storm Drainage Fund Proposed Budget 1998 Actual 1999 1997 1998 10/31/98 Proposed Actual Budget (Unaudited) Budget Operating Revenues: Sales $ 522,974 $ 550,000 $ 410,955 $ 565,000 Penalty charges 2,058 0 Other 57,874 0 Total Operating Revenues 582,906 550,000 410,955 565,000 Operating Expenditures: Personal services 94,622 154,000 132,567 126,582 Chemicals and supplies 11,577 0 5,680 100 Contractual services 146,012 356,000 43,444 126,400 Repairs and maintenance 72,029 90,000 69,118 90,000 Utilities 1,035 0 918 1,500 Total Operating Expenses 325,275 600,000 251,727 344,582 Operating income (loss) before Depreciation 257,631 (50,000) 159,228 220,418 1 Depreciation: Equipment 36646 0 0 35,000 Operating income (loss) 220,985 (50,000) 159,228 185,418 Nonoperating Revenues(Expenses): Special assessments 13,177 0 28,062 Gain on sale of fixed asset 0 0 Total Nonoperating Revenues(Expenses) 13,177 0 28,062 0 Income(loss)before Operating Transfers 234,162 (50,000) 187,290 185,418 Operating Transfer Out (10,000) (10,000) 0 (10,000) Net income (loss) 224,162 $ (60,000) 187,290 $ 175,418 Retained Earnings (deficit),January 1, 536,130 760,292 Retained Earnings December 31 $ 760,292 947,582 68 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 152 WATER DEPT ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 622,440 807,900 548,469 762,104 4112 OVERTIME-REG 83,298 95,500 121,615 55,500 4120 FUNDING OF SEVERANCE 5,844 0 0 0 4121 FUNDING OF VACATION PAYOUT 4,131 0 0 0 4130 WAGES NO BENEFITS 21,639 20,300 15,172 35,833 4131 OVERTIME-PART TIME 105 500 175 0 4132 LEAVE TIME 115,046 0 78,103 0 4151 HOSPITALIZATION INS 60,068 62,000 66,653 91,532 4154 WORKMANS COMP INS 25,035 30,000 0 23,851 4158 DENTAL REIMBURSEMENT 4,174 3,000 3,471 6,600 4159 DISABILITY INS 1,723 2,500 1,966 1,243 4170 PENSION PLANS 91,310 90,000 98,677 95,354 PERSONAL SERVICES $1,034,815 $1,111,700 $934,300 $1,072,017 4210 OFFICE SUPPLIES 5,513 7,200 9,294 6,000 4220 OPERATING SUPPLIES-GENERAL 26,191 34,600 18,192 46,600 4221 MOTOR FUELS 11,947 10,000 136 12,000 4222 LUBRICANTS & ADDITIVES 0 0 1,135 0 4223 CLEANING SUPPLIES 6,892 8,300 13,084 10,420 4224 CLOTHING & UNIFORMS 9,905 8,300 4,688 8,300 4225 PROTECTIVE CLOTHING 93 0 1,961 200 4226 CHEMICALS 260,767 275,000 238,408 275,000 4227 BUILDING MATERIALS 889 0 2,251 1,000 4230 REPAIR & MAINT SUPPLIES 70,882 67,600 46,403 66,250 4231 EQUIPMENT PARTS 134,446 169,000 95,411 146,330 4233 BLDG REPAIR & MAINT 14,467 3,500 31,909 7,500 4235 LANDSCAPE MTLS & AG SUPPL 0 0 1,285 0 4240 SMALL TOOLS 2,877 3,700 5,481 9,550 4246 VIDEO SUPPLIES 189 1,000 354 1,000 4248 TRAINING SUPPLIES 7,220 10,300 4,023 6,300 4249 SAFETY SUPPLIES 5,158 2,000 5,692 2,000 4250 PHOTO SUPPLIES 1,503 1,500 376 500 4252 EQUIPMENT TESTING & CERT 210 0 0 0 4253 COMPUTER MAINT 68 200 1,228 200 4257 SALES TAX EXPENSES 503 9,500 0 0 4261 GRAVEL 1,033 1,000 1,058 1,000 4262 SAND 0 0 30 0 COMMODITIES & SUPPLIES $560,752 $612,700 $482,396 $600,150 69 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 152 WATER DEPT ACTUAL BUDGET 10/31/98 BUDGET 4310 PROFESSIONAL SERVICES 52,288 0 6,605 0 4313 AUDIT & FINANCIAL 2,700 2,700 2,700 2,700 4317 CONST TESTING-SOIL BORING 7,425 0 9,150 0 4320 COMMUNICATIONS 1,290 650 1,396 1,200 4321 POSTAGE 15,143 15,350 12.917 15,000 4322 TELEPHONE 1,850 2,000 4,807 2,000 4334 MILEAGE AND PARKING 18 150 3 150 4340 ADVERTISING 319 0 0 0 4351 LEGAL NOTICES PUBLISHING 176 0 0 0 4360 INSURANCE 22,120 45,000 0 40,000 4363 BOILER & MACHINERY 0 500 0 500 4371 ELECTRIC 318,765 326,400 319,718 344,100 4372 GAS 41,681 35,950 21,841 39,250 4375 WASTE DISPOSAL 3,531 3,500 2,879 3,500 4380 CONTRACTED REPAIR & MAINT 124,255 203,800 93,192 209,300 4382 CONTRACTED EQUIP REPAIR 35,591 56,900 38,322 137,100 4383 CONTRACTED BLDG REPAIRS 2,179 10,000 15,397 9,500 4390 RENTALS 2,556 0 129 0 4393 EQUIPMENT RENTAL 2,903 4,000 229 5,000 4394 OFFICE EQUIP MAINT 1,709 1,100 2,130 1,400 4410 MISCELLANEOUS 74,445 75,000 57,283 76,000 4411 CONFERENCE 1,135 1,500 4,156 4,000 4412 TRAVEL 566 250 866 250 4413 DUES & SUBSCRIPTIONS 9,286 10,000 10,895 10,000 4414 LICENSES & TAXES 25,260 12,520 1,107 12,000 4417 SCHOOLS 2,597 2,000 0 2,000 4418 LOGIS SERVICE 21,406 23,000 11.739 22,000 4420 OTHER CONTRACTED SERVICES 393,693 408,000 369,196 411,000 4421 CONTRACTED BLDG MAINT 996 0 0 0 4430 MICROFILMING SERVICE 0 2,500 0 2,500 4450 STATION IMPROVEMENTS 0 ' 0 324 0 CONTRACTED SERVICES $1,165,883 $1,242,770 $986,979 $1,350,450 OPERATING EXPENDITURES $2,761,450 $2,967,170 $2,403,675 $3,022,617 4265 SOFTWARE 215 0 196 17,500 4266 OFFICE EQUIPMENT 171 0 0 0 4267 FURNITURE & FIXTURES 0 0 4,405 0 4268 MACHINERY & EQUIPMENT 1,112 0 2,814 0 4269 OTHER EQUIPMENT 740 0 795 27,650 70 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 152 WATER DEPT ACTUAL BUDGET 10/31/98 BUDGET 4500 OTHER CAPITAL 0 85,477 0 0 4517 RADIOS 0 0 7,257 0 4530 IMPROVEMENT CONTRACTS 0 0 2,590 0 4540 MACHINERY EQUIPMENT 0 0 5,421 0 4541 AUTOS 0 0 92,892 58,000 4542 COMPUTERS 0 0 15,793 0 4550 FURNITURE & FIXTURES 0 0 12,665 1,500 4551 OFFICE EQUIPMENT 0 0 10,955 500 4552 OTHER EQUIPMENT 0 0 44,325 5,000 CAPITAL OUTLAY $2,239 $85,477 $200,108 $110,150 4710 PERMANENT TRANSFER 50,000 50,000 0 50,000 4730 DEPRECIATION EXPENSE 80,650 62,000 0 80,000 4980 REFUNDS 0 0 6,120 0 OTHER FINANCING USES $130,650 $112,000 $6,120 $130,000 4940 MERCHANDISE FOR RESALE 93,740 70,000 48,428 70,000 COST OF GOODS SOLD $93,740 $70,000 $48,428 $70,000 DIVISION TOTAL $2,988,078 $3,234,647 $2,658,331 $3,332,767 71 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 153 SEWER DEPT ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 128,271 238,000 93,589 272,660 4112 OVERTIME-REG 1,939 4,200 4,773 4,200 4120 FUNDING OF SEVERANCE 3,134 0 0 0 4121 FUNDING OF VACATION PAYOUT (216) 0 0 0 4130 WAGES NO BENEFITS 3,912 6,500 192 8,490 4132 LEAVE TIME 31,815 0 19,283 0 4151 HOSPITALIZATION INS 22,493 23,000 14,818 24,252 4154 WORKMANS COMP INS 5,279 8,000 0 7,222 4158 DENTAL REIMBURSEMENT 1,606 1,500 493 1,800 4159 DISABILITY INS 708 900 424 339 4170 PENSION PLANS 20,738 28,500 16,363 24,752 PERSONAL SERVICES $219,679 $310,600 $149,935 $343,715 4210 OFFICE SUPPLIES 220 500 1,769 500 4220 OPERATING SUPPLIES-GENERAL 1,344 2,500 486 2,500 4221 MOTOR FUELS 11,028 6,500 64 11,000 4223 CLEANING SUPPLIES 897 0 159 200 4224 CLOTHING & UNIFORMS 2.678 3,000 758 3,000 4225 PROTECTIVE CLOTHING 0 0 482 0 4227 BUILDING MATERIALS 668 0 2,030 0 4230 REPAIR & MAINT SUPPLIES 32,850 13,000 6,993 12,000 4231 EQUIPMENT PARTS 22,692 8,500 14,889 4,500 4233 BLDG REPAIR & MAINT 301 0 416 0 4240 SMALL TOOLS 276 0 1,396 1,500 4248 TRAINING SUPPLIES 1,029 3,000 672 1,000 • 4249 SAFETY SUPPLIES 2,656 0 2,802 1,500 4250 PHOTO SUPPLIES 103 0 33 0 4252 EQUIPMENT TESTING rCERT 466 0 0 0 4261 GRAVEL 475 0 168 0 COMMODITIES & SUPPLIES $77,682 $37,000 $33,117 $37,700 4310 PROFESSIONAL SERVICES 1,117 0 0 0 4312 LEGAL SERVICE (10,364) 0 0 0 4313 AUDIT & FINANCIAL 3,000 3,000 3,000 3,000 4320 COMMUNICATIONS 1,071 600 879 600 4321 POSTAGE 9 0 0 0 4322 TELEPHONE 6,416 5,950 6,348 6,200 4360 INSURANCE 12,558 10,000 0 13,000 4371 ELECTRIC 9,966 7,000 6,032 7,000 4375 WASTE DISPOSAL 2,638,734 2,700,000 2,050,683 2,700,000 4380 CONTRACTED REPAIR & MAINT 20,966 55,000 4,585 25,000 4382 CONTRACTED EQUIP REPAIR 17,073 17,500 3,650 26,500 4383 CONTRACTED BLDG REPAIRS 65 0 0 4,500 73 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 153 SEWER DEPT ACTUAL BUDGET 10/31/98 BUDGET 4390 RENTALS 782 0 84 0 4392 BLDG RENTAL 3,500 0 0 0 4393 EQUIPMENT RENTAL 3,515 4,000 1,072 4,000 4394 OFFICE EQUIP MAINT 488 0 0 0 4411 CONFERENCE 0 500 500 500 4412 TRAVEL 0 0 11 0 4413 DUES & SUBSCRIPTIONS 2,095 2,000 883 2,000 4414 LICENSES & TAXES 124 0 291 0 4417 SCHOOLS 1,490 1,200 0 1,200 4418 LOGIS SERVICE 21,406 22,000 25,810 22,000 4420 OTHER CONTRACTED SERVICES 1,632 1,000 1,011 1,000 CONTRACTED SERVICES $2,735,642 $2,829,750 $2,104,840 $2,816,500 OPERATING EXPENDITURES $3,033,003 $3,177,350 $2,287,891 $3,197,915 4267 FURNITURE & FIXTURES 0 0 667 0 4500 OTHER CAPITAL 0 191,990 0 0 4511 IMPROVEMENTS TO LAND 0 0 102 0 4550 FURNITURE & FIXTURES 0 0 1,363 0 4551 OFFICE EQUIPMENT 0 0 623 0 4552 OTHER EQUIPMENT 0 15,000 1,983 0 CAPITAL OUTLAY $0 $206,990 $4,738 $0 4730 DEPRECIATION EXPENSE 1,056,209 20,000 0 35,000 4980 REFUNDS (3,060) 0 0 0 OTHER FINANCING USES $1,053,149 $20,000 $0 $35,000 DIVISION TOTAL $4,086,152 $3,404,340 $2,292,629 $3,232,915 74 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 154 STORM DRAINAGE ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 70,977 125,000 112,357 101,827 4112 OVERTIME-REG 1,441 4,000 6,728 4,000 4130 WAGES NO BENEFITS 4,778 1,500 3,268 1,500 4131 OVERTIME-PART TIME 0 0 428 0 4151 HOSPITALIZATION INS 1,517 0 0 9,389 4154 WORKMANS COMP INS 4,560 3,500 0 1,688 4158 DENTAL REIMBURSEMENT 0 0 0 600 4159 DISABILITY INS 77 0 0 113 4170 PENSION PLANS 11,272 20,000 9,786 7,465 PERSONAL SERVICES $94,621 $154,000 $132,568 $126,582 4220 OPERATING SUPPLIES-GENERAL 519 0 822 100 4230 REPAIR & MAINT SUPPLIES 23,988 20,000 57,028 20,000 4231 EQUIPMENT PARTS 1,215 0 1,077 0 4235 LANDSCAPE MTLS & AG SUPPL 80 0 663 0 4240 SMALL TOOLS 91 0 766 0 4249 SAFETY SUPPLIES 1,168 0 608 0 4250 PHOTO SUPPLIES 103 0 6 0 4257 SALES TAX EXPENSES 28 0 0 0 4261 GRAVEL 1,355 0 1,310 0 COMMODITIES & SUPPLIES $28,546 $20,000 $62,280 $20,100 4310 PROFESSIONAL SERVICES 80,821 3,000 1,412 8,000 4316 DESIGN & CONST 5,919 0 7,487 0 4350 PRINTING 150 0 0 0 4351 LEGAL NOTICES PUBLISHING 73 0 0 0 4371 ELECTRIC 1,035 ' 500 713 1,500 4375 WASTE DISPOSAL 0 0 205 0 4380 CONTRACTED REPAIR & MAINT 46,735 70,000 10,247 70,000 4390 RENTALS 67 0 284 0 4393 EQUIPMENT RENTAL 6,089 9,000 5,269 4,500 4413 DUES & SUBSCRIPTIONS 130 0 346 400 4418 LOGIS SERVICE 0 3,500 0 3,500 4420 OTHER CONTRACTED SERVICES 27,564 80,000 200 80,000 4435 SWEEPING 10,793 30,000 27,690 30,000 CONTRACTED SERVICES $179,375 $196,000 $53,852 $197,900 OPERATING EXPENDITURES $302,542 $370,000 $248,700 $344,582 75 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 154 STORM DRAINAGE ACTUAL BUDGET 10/31/98 BUDGET 4265 SOFTWARE 2,405 0 2,271 1,500 4500 OTHER CAPITAL 0 332,500 0 0 4530 IMPROVEMENT CONTRACTS 0 0 756 0 4541 AUTOS 0 0 1,401 33,000 4552 OTHER EQUIPMENT 0 0 1,811 0 CAPITAL OUTLAY $2,405 $332,500 $6,239 $34,500 4710 PERMANENT TRANSFER 10,000 10,000 0 10,000 4730 DEPRECIATION EXPENSE 36,646 0 0 35,000 OTHER FINANCING USES $46,646 $10,000 $0 $45,000 DIVISION TOTAL $351,593 $712,500 $254,939 $424,082 76 City of Eden Prairie 1999 Liquor Fund Proposed Budget 1998 Actual 1999 1997 1998 10/31/98 Proposed Actual Budget (Unaudited) Budget Sales 4,977,938 $ 5,700,000 $ 4,915,928 $ 6,100,000 Cost of Sales (3,788,777) (4,326,300) (3,708,244) (4,625,400) Operating Revenues 1,189,161 1,373,700 1,207,684 1,474,600 23.9% 24.1% 24.6% 24.2% Operating Expenses: Personal Services 463,330 489,402 424,508 551,675 Commodities and Supplies 28,455 37,577 25,295 28,600 Contractual Services 258,266 337,769 194,286 346,231 Repairs and Maintenance 38,862 31,024 29,844 43,500 Utilities 34,603 32,023 34,377 44,491 Depreciation 15,181 25,905 0 25,087 Total Operating Expenses 838,697 953,700 708,310 1,039,584 Operating Income 350,464 420,000 499,374 435,016 Nonoperating revenues(expenses) Interest on Investments 11,501 13,000 0 13,000 Loss on Investments 0 0 0 0 Loss on Disposition of Fixed Assets 0 0 0 0 Total nonoperating revenues(expens 11,501 13,000 0 13,000 Income(loss)before operating transfe 361,965 433,000 499,374 448,016 Transfers in(out) (273,504) (420,000) 0 (420,000) Net Income.(Loss) 88,461 $ 13,000 $ 499,374 $ 28,016 77 City of Eden Prairie 1999 Liquor Fund Proposed Budget Cub Foods Liquor Store 1998 Actual 1999 1997 1997 10/31/98 Proposed Actual Budget (Unaudited) Budget Sales 1,329,042 1,295,000 2,459,177 3,300,000 Cost of Sales (991,498) (975,000) (1,844,383) (2,475,000) Operating Revenues $ 337,544 $ 320,000 $ 614,794 $ 825,000 25.4% 24.7% 25.0% 25.0% Operating Expenses: Personal Services 115,365 107,300 166,861 221,675 Commodities and Supplies 13,510 7,200 13,015 12,800 Contractual Services 59,830 94,800 23,838 130,107 Repairs and Maintenance 5,458 1,000 4,878 9,700 Utilities 7,827 6;300 12,322 15,800 Depreciation 3,168 7,000 10,000 Total Operating Expenses 205,158 223,600 220,914 400,082 Operating Income 132,386 96,400 393,880 424,918 Nonoperating revenues(expenses) Interest on Investments (394) 5,000 Loss on Investments Loss on Disposition of Fixed Assets Total nonoperating revenues(expenses) (394) 0 0 5,000 Income(loss)before operating transfers 131,992 96,400 393,880 429,918 Transfers in(out) (98,461) (55,000) (340,000) Net Income $ 33,531 $ 41,400 $ 393,880 $ 89,918 78 City of Eden Prairie 1999 Liquor Fund Proposed Budget Prairie Village Liquor Store 1998 Actual 1999 1997 1997 10/31/98 Proposed Actual Budget (Unaudited) Budget Sales $ 1,542,299 $ 1,686,000 1,183,203 1,600,000 Cost of Sales (1,197,288) (1,306,000) (908,700) (1,228,800) Operating Revenues 345,011 380,000 274,503 371,200 22.4% 22.5% 23.2% 23.2% Operating Expenses: Personal Services 136,781 156,800 121,517 170,000 Commodities and Supplies 5,586 10,700 5,352 5,700 Contractual Services 70,245 68,732 60,400 84,174 Repairs and Maintenance 15,188 18,200 11,032 16,300 Utilities 13,071 12,300 10,771 14,438 Depreciation 3,214 2,500 3,087 Total Operating Expenses 244,085 269,232 209,072 293,699 Operating Income 100,926 110,768 65,431 77,501 Nonoperating revenues(expenses) Interest on Investments 4,064 4,000 Loss on Investments Loss on Disposition of Fixed Assets Total nonoperating revenues(expenses) 4,064 0 0 4,000 Income(loss)before operating transfers 104,990 110,768 65,431 81,501 Transfer to the General Fund (79,316) (110,000) (80,000) Net Income $ 25,674 $ 768 65,431 $ 1,501 79 City of Eden Prairie 1999 Liquor Fund Proposed Budget Prairie View Mall Liquor Store 1998 Actual 1999 1997 1997 10/31/98 Proposed Actual Budget (Unaudited) Budget Sales $ 2,106,597 $ 2,300,000 $ 1,273,548 1,200,000 Cost of Sales (1,599,991) (1,725,000) (955,161) (921,600) Operating Revenues 506,606 575,000 318,387 278,400 24.0% 25.0% 25.0% 23.2% Operating Expenses: Personal Services 211,184 185,600 136,130 160,000 Commodities and Supplies 9,359 16,700 6,928 10,100 Contractual Services 128,191 149,475 110,048 131,950 Repairs and Maintenance 18,216 8,500 13,934 17,500 Utilities 13,705 10,700 11,284 14,253 Depreciation 8,799 15,000 12,000 Total Operating Expenses 389,454 385,975 278,324 345,803 Operating Income 117,152 189,025 40,063 (67,403) Nonoperating revenues(expenses) Interest on Investments 7,831 4,000 Loss on Investments Loss on Disposition of Fixed Assets Total nonoperating revenues(expenses) 7,831 0 0 4,000 Income(loss)before operating transfers 124,983 189,025 40,063 (63,403) Transfers in(out) (95,727) (185,000) 0 Net Income $ 29,256 $ 4,025 $ 40,063 $ (63,403) 80 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 123 CUB FOODS ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 45,044 56,000 62,053 122,000 4112 OVERTIME-REG 2,101 2,000 3,874 4,500 4120 FUNDING OF SEVERANCE 13,111 0 0 0 4121 FUNDING OF VACATION PAYOUT 5,120 300 0 0 4130 WAGES NO BENEFITS 32,501 33,000 62,902 64,800 4131 OVERTIME-PART TIME 858 0 5,529 0 4132 LEAVE TIME 7,387 0 14,712 14,000 4151 HOSPITALIZATION INS 0 4,900 0 0 4154 WORKMANS COMP INS 1,094 2,200 0 2,375 4158 DENTAL REIMBURSEMENT 1,299 500 1,299 0 4159 DISABILITY INS 0 200 0 0 4170 PENSION PLANS 6,850 8,200 16,492 14,000 PERSONAL SERVICES $115,365 $107,300 $166,860 $221,675 4210 OFFICE SUPPLIES 155 0 0 300 4220 OPERATING SUPPLIES-GENERAL 7,077 6,000 7,192 10,000 4224 CLOTHING & UNIFORMS 4,915 1,200 4,877 2,500 4230 REPAIR & MAINT SUPPLIES 550 0 0 0 4233 BLDG REPAIR & MAINT 0 1,000 0 0 4249 SAFETY SUPPLIES 0 0 170 0 COMMODITIES & SUPPLIES $12,697 $8,200 $12,239 $12,800 4310 PROFESSIONAL SERVICES 0 0 0 11,732 4313 AUDIT & FINANCIAL 1,900 1,900 1,900 2,500 4322 TELEPHONE 2,020 1,400 3,002 4,000 4330 TRANSPORTATION 9,639 0 15,065 20,000 4334 MILEAGE AND PARKING 0 ' 0 117 500 4340 ADVERTISING 1,489 4,000 3,941 10,000 4360 INSURANCE 5,036 0 358 10,000 4361 PROPERTY INSURANCE 0 400 0 0 4362 GENERAL LIABILITY INS 0 6,600 0 0 4370 UTILITIES 0 1,200 0 0 4371 ELECTRIC 4,775 1,800 8,014 8,400 4372 GAS 1,032 800 641 2,000 4375 WASTE DISPOSAL 0 1,100 665 1,400 4380 CONTRACTED REPAIR & MAINT 1,610 0 178 3,200 4392 BLDG RENTAL 45,000 75,100 0 95,000 4411 CONFERENCE 137 0 (68) 150 4412 TRAVEL 0 0 13 0 81 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 123 CUB FOODS ACTUAL BUDGET 10/31/98 BUDGET 4413 DUES & SUBSCRIPTIONS 20 0 338 100 4414 LICENSES & TAXES 125 0 270 125 4420 OTHER CONTRACTED SERVICES 3,298 3,000 4,700 6,500 4421 CONTRACTED BLDG MAINT 0 0 333 0 4460 SEAL COATING SERVICE 0 3,000 0 0 CONTRACTED SERVICES $76,081 $100,300 $39,467 $175,607 OPERATING EXPENDITURES $204,143 $215,800 $218,566 $410,082 4267 FURNITURE & FIXTURES 1,114 0 763 0 4268 MACHINERY & EQUIPMENT 249 0 0 0 CAPITAL OUTLAY $1,363 $0 $763 $0 4710 PERMANENT TRANSFER 98,461 60,000 0 340,000 4730 DEPRECIATION EXPENSE 3,168 7,000 0 10,000 4750 BANK CHGS & S/C 6,300 800 16,649 0 OTHER FINANCING USES $107,929 $67,800 $16,649 $350,000 4940 MERCHANDISE FOR RESALE 282,342 975,000 507,613 692,235 4950 BEER 6/12 350,620 0 725,843 0 4951 BEER CASES 5,448 0 3,968 893,461 4955 WINE IMPORTED 50,956 0 90,595 134,173 4956 WINE DOMESTIC 263,330 0 472,068 650,183 4960 MISC TAXABLE 13,721 ' 0 33,359 32,299 4961 MISC NON-TAXABLE 5,270 0 9,889 13,306 4962 TOBACCO PRODUCTS 14,811 0 30,904 39,338 COST OF GOODS SOLD $986,497 $975,000 $1,874,238 $2,454,995 DIVISION TOTAL $1,299,931 $1,258,600 $2,110,215 $3,215,077 82 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 121 PRAIRIE VILLAGE ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 60,740 83,400 60,726 84,593 4112 OVERTIME-REG 1,917 1,600 1,671 2,500 4120 FUNDING OF SEVERANCE (515) 2,500 0 0 4121 FUNDING OF VACATION PAYOUT (2,013) 1,300 0 0 4130 WAGES NO BENEFITS 49,458 46,000 33,405 64,000 . 4131 OVERTIME-PART TIME 0 0 1,083 0 4132 LEAVE TIME 9,805 0 7,626 0 4151 HOSPITALIZATION INS 5,569 6,500 6,239 5,624 4154 WORKMANS COMP INS 1,576 3,100 0 1,600 4158 DENTAL REIMBURSEMENT 0 500 0 500 4159 DISABILITY INS 182 200 189 183 4170 PENSION PLANS 10,063 11,700 10,578 11,000 PERSONAL SERVICES $136,782 $156,800 $121,517 $170,000 4220 OPERATING SUPPLIES-GENERAL 4,528 9,000 4,194 4,500 4224 CLOTHING & UNIFORMS 689 1,700 823 1,200 4230 REPAIR & MAINT SUPPLIES 3,734 0 2,658 0 4233 BLDG REPAIR & MAINT 243 7,200 0 3,800 4249 SAFETY SUPPLIES 0 0 322 0 4257 SALES TAX EXPENSES 5 0 0 0 COMMODITIES & SUPPLIES $9,198 $17,900 $7,998 $9,500 4313 AUDIT & FINANCIAL 2,500 2,500 2,500 2,500 4319 JANITOR SERVICE 1,597 1,700 1,367 1,863 4322 TELEPHONE 1,455 1,400 1,234 1,924 4330 TRANSPORTATION 9,208 0 7,317 8,563 4334 MILEAGE AND PARKING 419 ' 0 0 600 4340 ADVERTISING 4,106 4,000 3,941 4,100 4360 INSURANCE 5,939 0 838 5,939 4362 GENERAL LIABILITY INS 0 8,600 0 0 4370 UTILITIES 1,557 1,600 1,488 1,816 4371 ELECTRIC 8,098 7,000 6,640 8,425 4372 GAS 577 900 343 629 4375 WASTE DISPOSAL 1,384 1,400 1,066 1,644 4380 CONTRACTED REPAIR & MAINT 6,342 7,000 2,646 6,500 4392 BLDG RENTAL 35,321 38,532 35,761 45,000 4393 EQUIPMENT RENTAL 29 0 0 100 4411 CONFERENCE 98 0 (29) 100 4412 TRAVEL 0 0 13 0 83 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 121 PRAIRIE VILLAGE ACTUAL BUDGET 10/31/98 BUDGET 4413 DUES & SUBSCRIPTIONS 1,367 1,600 1,475 1,400 4414 LICENSES & TAXES 9,909 10,500 7,846 11,345 4420 OTHER CONTRACTED SERVICES 4,869 4,000 5,818 6,000 4421 CONTRACTED BLDG MAINT 553 0 0 1,227 CONTRACTED SERVICES $95,329 $90,732 $80,265 $109,675 OPERATING EXPENDITURES $241,309 $265,432 $209,780 $289,175 4267 FURNITURE & FIXTURES 115 0 0 0 4268 MACHINERY & EQUIPMENT 249 0 0 0 4552 OTHER EQUIPMENT 0 0 482 0 CAPITAL OUTLAY $364 $0 $482 $0 4710 PERMANENT TRANSFER 79,316 124,000 0 80,000 4730 DEPRECIATION EXPENSE 3,214 2,500 0 3,087 4750 BANK CHGS & S/C 8,106 1,300 6,701 10,000 OTHER FINANCING USES $90,635 $127,800 $6,701 $93,087 4939 LIQUOR 25,786 0 0 0 4940 MERCHANDISE FOR RESALE 302,485 1,306,000 273,079 333,582 4950 BEER 6/12 382,067 0 379,665 295,707 4951 BEER CASES 139,324 0 2,073 247,250 4955 WINE IMPORTED 41,689 0 48,237 37,489 4956 WINE DOMESTIC 249,771 - 0 183,528 253,174 4960 MISC TAXABLE 23,088 0 15,599 20,434 4961 MISC NON-TAXABLE 4,405 0 2,918 7,820 4962 TOBACCO PRODUCTS 23,253 0 17,491 24,782 COST OF GOODS SOLD $1,191,869 $1,306,000 $922,591 $1,220,238 DIVISION TOTAL $1,524,177 $1,699,232 $1,139,555 $1,602,500 84 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 122 PRAIRIEVIEW ACTUAL BUDGET 10/31/98 BUDGET 4100 WAGES-BENEFITS 80,946 121,000 53,799 83,400 4112 OVERTIME-REG 4,690 8,600 1,097 2,000 4120 FUNDING OF SEVERANCE 2,714 2,300 0 0 4121 FUNDING OF VACATION PAYOUT 7,346 1,800 0 0 4130 WAGES NO BENEFITS 73,360 22,000 49,201 28,800 4131 OVERTIME-PART TIME 1,092 0 2,596 1,000 4132 LEAVE TIME 12,864 0 11,235 13,000 4151 HOSPITALIZATION INS 10,197 9,000 6,878 11,000 4154 WORKMANS COMP INS 2,215 3,400 0 2,500 4158 DENTAL REIMBURSEMENT 353 200 166 3,000 4159 DISABILITY INS 314 300 195 300 4170 PENSION PLANS 15,093 17,000 10,963 15,000 PERSONAL SERVICES $211,184 $185,600 $136,132 $160,000 4210 OFFICE SUPPLIES 81 0 0 100 4220 OPERATING SUPPLIES-GENERAL 8,590 15,000 3,877 8,000 4224 CLOTHING & UNIFORMS 0 1,700 823 2,000 4227 BUILDING MATERIALS 260 0 0 0 4230 REPAIR & MAINT SUPPLIES 4,372 0 3,835 3,500 4233 BLDG REPAIR & MAINT 362 1,400 767 1,000 4240 SMALL TOOLS 0 0 2,215 0 COMMODITIES & SUPPLIES $13,665 $18,100 $11,516 $14,600 4313 AUDIT & FINANCIAL 2,500 2,500 2,500 2,500 4319 JANITOR SERVICE 132 0 0 0 4322 TELEPHONE 1,859 1,600 1,802 1,700 4330 TRANSPORTATION 12,343 0 7,412 12,500 4334 MILEAGE AND PARKING 297 400 0 0 4340 ADVERTISING 4,346 3,700 4,491 5,000 4360 INSURANCE 8,022 700 1,253 7,000 4361 PROPERTY INSURANCE 0 400 0 0 4362 GENERAL LIABILITY INS 0 11,600 0 0 4370 UTILITIES 968 500 617 960 4371 ELECTRIC 9,902 7,600 8,176 10,617 4372 GAS 976 1,000 689 976 4380 CONTRACTED REPAIR & MAINT 7,435 6,800 4,580 7,500 4383 CONTRACTED BLDG REPAIRS 0 300 199 0 4392 BLDG RENTAL 69,296 54,175 69,914 75,800 4393 EQUIPMENT RENTAL 129 0 0 150 4411 CONFERENCE 98 0 16 0 4412 TRAVEL 0 0 13 0 4413 DUES & SUBSCRIPTIONS 494 500 180 500 4414 LICENSES & TAXES 27,413 21,500 23,108 28,000 85 CITY OF EDEN PRAIRIE EXPENDITURES BY ACCOUNT 1998 1999 1997 1998 ACTUAL PROPOSED 122 PRAIRIEVIEW ACTUAL BUDGET 10/31/98 BUDGET 4420 OTHER CONTRACTED SERVICES 6,047 2,000 4,554 5,500 4421 CONTRACTED BLDG MAINT 0 0 213 0 CONTRACTED SERVICES $152,259 $115,275 $129,718 $158,703 OPERATING EXPENDITURES $377,107 $318,975 $277,367 $333.303 4267 FURNITURE & FIXTURES 493 0 0 0 CAPITAL OUTLAY $493 $0 $0 $0 4710 PERMANENT TRANSFER 95,727 235,000 0 0 4730 DEPRECIATION EXPENSE 8,799 15,000 0 12,000 4750 BANK CHGS & S/C 13,035 2,000 8,373 13,000 OTHER FINANCING USES $117,561 $252.000 $8,373 $25,000 4939 LIQUOR 1,283 0 0 0 4940 MERCHANDISE FOR RESALE 448,160 1,725,000 272.062 256,423 4950 BEER 6/12 517,027 0 421,263 388,344 4951 BEER CASES 163,649 0 1,484 0 4955 WINE IMPORTED 44,331 0 41,478 25,291 4956 WINE DOMESTIC 355,281 0 211,240 202.697 4960 MISC TAXABLE 27,763 0 18,487 15,840 4961 MISC NON-TAXABLE 8,721 0 3,117 4,976 4962 TOBACCO PRODUCTS 27,218 0 17,749 15,529 COST OF GOODS SOLD $1,593,432 $1,725,000 $986,880 $909,100 DIVISION TOTAL $2,088,593 $2,295,975 $1,272,619 $1,267,403 86