Loading...
HomeMy WebLinkAbout2007 Budget BookCITY OF STILLWATER, MINNESOTA 216 North 4th Street Stillwater, MN 55082 Phone: 651.430.8800 Web Address: www.ci.stillwater.mn.us PREPARED BY THE FINANCE DEPARTMENT 2007 BUDGET 1 CITY (7F STII I WLITFR MINNFS[~TO TABLE OF CONTENTS 2007 BUDGET I. INTRODUCTION City Officials ............................................................................................... ' Mission Statement ....................................................................................... Organizational Chart .................................................................................... Certified Levy ............................................................................................. ' Budget Overview ......................................................................................... Property Tax Calculation ............................................................................... Property Tax Payers (Who pays the Property Tax Levy) ...................................... ' Trend Information: Total Certified Levy (past 10 years) .............................................................. City Tax Rate (past 10 years) ...................................................................... t Local Government Aid & General Tax Levy (past 10 years) ............................... Operating Revenues (past 10 years) ............................................................. Operating Expenditures (past 10 years) ......................................................... ' 2007 Operating Revenues ............................................................................. 2007 Operating Expenditures ............................ L II. BUDGET SCHEDULES B. SPECIAL REVENUE FUNDS 3 5 6 7-9 10-11 12 13 14 15 16 17 18 19 25 27 28-29 30-31 32-33 34-35 36-37 38-39 40-41 42-43 44-45 46-47 48-49 50-51 52-53 54-55 56-57 Special Revenue Funds Summary ............................................................ 61 Special Events ..................................................................................... 62-63 St Croix Valley Rec Center ...................................................................... 64-65 Library ................................................................................................ 66-67 CITY OF STILLWATER, MINNESOTA TABLE OF CONTENTS ~con~t> B. SPECIAL REVENUE FUNDS (CON'T) Parks .................................................................................................. 68-69 ' Washington County Recycling Grant ......................................................... 70-71 DARE ................................................................................................. 72-73 C. DEBT SERVICE FUNDS Levy Obligations ................................................................................... 76 Debt Service Funds Summary ................................................................. 77 GO Capital Outlay Bonds ........................................................................ 78-79 GO Improvement Bonds ......................................................................... 80-81 GO Tax Increment Financing Bonds ......................................................... 82-83 GO Revenue Bonds .............................................................................. 84-85 Other Long-Term Debt ........................................................................... 86-87 D. CAPITAL PROJECT FUNDS Capital Project Funds Summary ............................................................... 91 Tax Increment Financing District #1 .......................................................... 92-93 Tax Increment Financing District #4 .......................................................... 94-95 Tax Increment Financing District #6 .......................................................... 96-97 Tax Increment Financing District #8 .......................................................... 98-99 Tax Increment Financing District #9 .......................................................... 100-101 Tax Increment Financing District #10 ........................................................ 102-103 E. ENTERPRISE FUNDS Enterprise Funds Summary ..................................................................... 107 Sanitary Sewer ..................................................................................... 108-109 Storm Sewer ........................................................................................ 110-111 Signs &Lighting .................................................................................... 112-113 Parking ............................................................................................... 114-115 III. OTHER SCHEDULES Capital Outlay ............................................................................................. 119-123 ' Interfund Transfers ...................................................................................... 125 Benefited Personnel ..................................................................................... 126-127 C C ~ INTRODUCTION I~ 7 CITY OF STILLWATER, MINNESOTA CITY OFFICIALS January 1, 2007 ELECTED OFFICIALS Mayor Ken Harycki Term Expires: January 2011 Councilmember's Ward 1 Robert Gag Term Expires: January 2011 Ward 2 To Be Appointed Term Expires: January 2009 Ward 3 Wally Milbrandt Term Expires: January 2009 Ward 4 Mike Polehna Term Expires: January 2011 APPOINTED OFFICIALS Larry D. Hansen, City Administrator/Treasurer David T. Magnuson, City Attorney Sharon Harrison, Finance Director Chantell Knauss, Director of Administration Larry Dauffenbach, Police Chief Stuart Glaser, Fire Chief Shawn Sanders, Public Works Director/City Engineer Bill Turnblad, Community Development Director Lynne Bertalmio, Library Director 3 CITY OF STILLWATER, MINNESOTA MISSION STATEMENT To provide the community with a quality living environment and quality public services and facilities while protecting cultural, historical and natural resources through fair and open government, careful planning, effective management and efficient fiscal policy. Adopted by the City Council in 1995 4 CITY ATTORNEY FIRE POLICE ST CROIX VALLEY CIVIL DEFENSE RECREATION CENTER DARE PARKS PARKING STORM SEWER ~ LI CITY OF STILLWATER, MINNESOTA ORGANIZATIONAL CHART CITIZENS OF STILLWATER CITY COUNCIL BOARDS AND COMMISSIONS LIBRARY CITY ADMINISTRATOR/ TREASURER ADMINISTRATION COMMUNITY FINANCE I DEVELOPMENT L PLANT/CITY HALL BUILDING PUBLIC INSPECTIONS WORKS ELECTIONS ENGINEERING STREET MIS WASHINGTON CO SANITARY SEWER RECYCLING GRANT 5 CITY OF STILLWATER, MINNESOTA ZOO7 CERTIFIED LEVY Pursuant to Resolution 2006-269, on December 19, 2006 the City Council adopted the final certified tax levy of certified tax levy of $9,386,631 for taxes collected in the year 2007. This levy consists of the General Operating Levy and the Debt Service Levy. GENERAL OPERATING LEVY The General Operating Levy is levied against all of the taxable properties of the City and is a major funding source for general City operations. The General Operating Levy for taxes collected in the 2007 is $6,102,192. DEBT SERVICE LEVY The Debt Service Levy is levied against all of the taxable properties of the City and provides funding for those bond issues requiring property tax support. The Debt Service Levy for taxes collected in the year 2007 is $3,284,439 and consists of the following Debt Service Obligations: FUND # CURRENT REQUIRED LEVY AMOUNT Existing Debt 304 G.O. Capital Outlay 20048 $ 102,296 305 G.O. Capital Outlay 2005A 226,354 315 G.O. Capital Outlay 20056 (Refunding) 281,109 316 G.O. Capital Outlay 2006A 581,587 320 G.O. Capital Outlay 2003A 195,549 321 G.O. Capital Outlay 2005MZ 115,500 323 G.O. Capital Outlay 2002A 818,404 324 G.O. Capital Outlay 2000C 115,815 328 G.O. Capital Outlay 19986 169,358 340 G.O. Improvement Bonds 2004A 293,805 385" G.O. Sports Center 2005C 159,662 Subtotal $ 3,059,439 New Debt 307 G.O. Capital Outlay 2007 225,000 TOTAL $ 3,284,439 DEBT SERVICE LEVIES CANCELLED The following d ebt service levy's were cancelled due to sufficient funding a lready available: 303 G.O. Capital Outlay 20003HS $ 34,965 314 G.O. Capital Outlay 2004P 37,852 381 G.O. Sport Facility Revenue 2000D 187,328 Notes: 385* G. O. Sports Center 2005C Original Levy Amount Less: Funding from TIF District #4 Funding from St Croix Valley Recreation Center Result $ 360,210 (75,000) (125,548) $ 159,662 i CSI C r i (:I I Y OF S I ILLWA I tK, MINNESU I A BUDGET OVERVIEW General Description and Form of Government The City of Stillwater, incorporated in 1894, is a growing community located on the St Croix River in central Washington County, approximately 20 miles east of Minneapolis/St. Paul metropolitan area. Stillwater encompasses an area of approximately 7.65 miles and serves a population of 17,429. The City of Stillwater operates under the "Home Rule Charter" form of government under the provisions of State of Minnesota Law. The Mayor is the president of the Council and together with the four-member City Council comprises the governing body of the City. The City Council is responsible, among other things, for passing ordinances, adopting the budget, appointing committees, and hiring a City Administrator. The City Administrator has the responsibility of carrying out the policies and ordinances of the City Council and of overseeing the day-to-day operations of the City. The Mayor is elected at-large and the Council Members are elected by Wards to serve four-year overlapping terms of office. The City provides a full range of municipal services. These services include: general government, public safety (police & fire), public works (streets & fleet), parks and recreation, public improvements, and providing and maintaining sanitary sewer, storm sewer, signs & lighting and parking infrastructure. Fund Accounting The accounts of the City are organized on the basis of funds, each of which is considered a separate accounting entity. The operations of each fund are accounted for with a separate set of self-balancing accounts that comprise its assets, liabilities, fund equity, revenues and expenditures/expenses. Government resources are allocated to and accounted for in individual funds based upon the purposes for which they are to be spent and the means by which spending activities are controlled. The budgeted funds of the City are grouped into two broad categories as follows: Governmental Funds -Governmental Funds are used to account for the "governmental-type" activities of the ' City (e.g. activities that receive a significant portion of their funding from property taxes, state aids, and various grants). The Governmental Funds budgeted for the City are the General Fund, Special Revenue Funds, Debt Service Funds, and Capital Project Funds. ' Proprietary Funds -Proprietary Funds are used to account for the "business-type" activities of the City (e.g. activities that receive significant portion of their funding through user charges). The Proprietary Funds budgeted by the City are the Enterprise Funds. ' Basis of Accounting and Budgeting ' The Governmental Funds are budgeted and accounted for on a modified accrual basis. Under this method, revenues are recognized when they are measurable and available. "Measurable" means the amount of the transaction can be determined and "available" means collectible within the current period or soon enough thereafter (usually within 60 days ' after the end of the year) to pay liabilities of the current period. Expenditures are recognized when a transaction is expected to draw upon current spendable resources, rather than future resources. The Proprietary Funds are budgeted and accounted for on a full accrual basis. Under this method, revenues are ' recorded when earned and expenses are recorded at the time the liabilities are incurred. C CITY OF STILLWATER, MINNESOTA BUDGET OVERVIEW (con't) Budget Process Section 7.01 of the Stillwater City Charter sets forth the requirement that the City Administrator must prepare and submit an annual budget to the City Council which accurately reflects the financial needs for the City_ The City Administrator is also required to enforce the provisions of the budget upon adoption. The budget is prepared on an annual basis and follows the calendar year, January 1st to December 31st. The City Administrator and City staff address the Council's concerns in the preparation of the budget and evaluate the financial costs of the implementation of these policies and include them in the budget where economically feasible. 2007 Budget Calendar: 2006 May Finance Department begins budget process by preparing projected wages, benefits and insurance costs for the upcoming fiscal budget year. May 2 The proposed budget calendar, the budget workshop meeting dates, and the date for the adoption of the proposed budget, tax levy and the setting of the truth-n-taxation hearing dates are considered and approved by Council. June 1 Budget worksheets are distributed to Department Heads/Division Supervisors for completion. July 3 Completed budget worksheets are due to the Finance Department. The Finance Department assembles the preliminary (requested) budget information. July 24 -August 4 The City Administrator reviews requested budget, meets with Department Heads to review budget requests, and makes recommendations regarding the budget. August 7 Finance Department makes adjustments and prepares City Administrator's preliminary proposed budget. August 11 City Administrator's preliminary proposed budget is distributed to the City Council for review. August 8 and 15 Council meets during a budget workshop session with the City Administrator and Department Heads to review the City Administrator's proposed budget. August 16 The Finance Department makes budget revisions and prepares the final proposed budget for Council adoption. September 5 Council adopts the proposed budget, the proposed tax levy and sets the Truth-n-Taxation hearing dates. Prior to State Statutes require that the proposed budget, the proposed property tax levy and the Truth-n- September 15 Taxation hearing dates MUST BE certified to the County Auditor no later than September 15, 2006. November The County to send out Truth-in-Taxation parcel specific notices based on the proposed budgeUlevy certified to the County Auditor prior to September 15. November 30 Notice of the Truth-in-Taxation public hearing date is published. December 5 City to hold the Truth-n-Taxation public hearing. December 19 City Council adopts final budget and final property tax levy. Prior to Finance Department certifies the final property tax levy and the final budget to the County Auditor. December 30 NOTE: Minnesota State Statutes require that a preliminary property tax levy resolution be certified to the County Auditor by September 15 of each year. Once the City adopts the proposed tax levy, the final tax levy can ONLY remain the same or be decreased, not increased. 8 0 n i i C LI I Y OF 51 ILLWA I tK, MINNtSU I A BUDGET OVERVIEW (con't) Budgeted Funds The City of Stillwater prepares a budget for the General Fund, certain Special Revenue Funds (Special Events Fund, St. Croix Valley Recreation Center Fund, Library Fund, Parks Fund, DARE Fund and the Washington County Recycling Grant Fund), Debt Service Funds, certain Capital Project Funds (TIF Districts) and its Enterprise Funds, but only legally adopts, by resolution, the budget for the General Fund and the budgets for the Special Revenue Funds. Revenue Estimation Revenue estimation is a key component in preparing the City's annual budget. The general intent is make conservative and objective projections. The City's approach to estimating revenues is to consider each individual revenue sources' history of predictability, stability or volatility. The estimation methods used are a combination of trend analysis and forecasting from information provided by prior years actuals and City departments. Capital Improvement Program The City of Stillwater's Capital Improvement program is intended to provide the City Council and staff with a process for identifying and prioritizing capital projects and capital equipment purchases in order to coordinate the financing and timing of improvements, which maximizes the return to the public. The process enables the City to evaluate long-term cost and benefits of each project/equipment and uses this information when preparing the annual budget. Property Tax Lew The City of Stillwater levies property taxes for its General Fund operations (General Tax Levy) and certain Debt Service obligations (Debt Service Tax Levy). See 2007 Certified Levy on page 6. The levies are allowed by State Statutes, and are collected from property owners by Washington County and distributed to the City in July, December, and January. Truth-in-Taxation Public Hearing Each year in November and early December, State Statutes require all counties, school districts, and cities with a population over 2,500 hold a public hearing to discuss the proposed budget and property tax levies. As part of this process, each property is sent by the County aTruth-in-Taxation notice, which shows the impacts of the proposed levies on their individual property. The public hearing is set up as a forum for citizens to come and discuss their views on the proposed budget and property tax levies with the public officials of each jurisdiction. Cities are exempt from this public hearing requirement if their property tax levy increase increased by a factor less than the inflation factor within the Levy Limit Law. The City of Stillwater 2007 proposed levy was not exempt from this requirement and held its public hearing on Monday, December 4, 2006 at 7:00 p.m. Questions Any questions regarding the content of the City's budget document can be discussed with the City Administrator or the Finance Director by contacting City Hall at (651) 430-8800. 9 CITY OF STILLWATER, MINNESOTA PROPERTY TAX CALCULATION HOW CITY PROPERTY TAXES ARE CALCULATED Step 1. Calculate the City's Property Tax Rate Box 1 Total Proposed City Budget -minus Box 2 All Non-Properly Tax Revenues, eg: - State Aid, Fees, etc. = equals Box 3 Properly Tax Revenue Needed (Levy)* - Less: Fiscal Disparity Contribution 7 divided by City-Wide Assessor's Market Value x times c5 State Mandated Class Rates =equals Total City-Wide Taxable "Tax Capacity" City's Property Tax Rate Calculation of Proposed Payable 2007 City Propert y Tax Rate: City Budget: Governmental Funds Budget $ 15,688,921 Debt Service Budget 3,284,439 Box 1 Total City Budget $ 18,973,360 Box 2 Less Non-Property tax revenues 9,598,729 Certified Levy $ 9,374,631 Less Fiscal Disparity Contribution 819,600 Box 3 City Levy $ 8,555,031 Box 4-6 City Taxable Tax Capacity $ 18,432,325 Box 7 City Tax Rate (Proposed) 46.413% 10 u CITY OF STILLWATER, MINNESOTA PROPERTY TAX CALCULATION HOW CITY PROPERTY TAXES ARE CALCULATED (Con't) Step 2. Calculate Individual Parcel's City Property Tax Formula: Property's Net Tax Capacity x City Property Tax Rate =Property's City Property Tax Net Tax Capacity The Net Tax Capacity is calculated by multiplying the Taxable Market Value of the parcel by the appropriate assigned Class Rate of the parcel. - the Taxable Market Value (TMV) refers to the amount of value of the parcel that is used in calculating taxes. The TMV is determined by the Washington County Assessor's office. - the Class Rate is based on the assigned use or classification of the parcel. Class Rates are determined by the MN Legislature and are as follows: Property Class Payable Taxable Market Value 2007 Residential Homestead First $500,000 of value 1.00% Over $500,000 of value 1.25% Residential Non-Homestead Single Unit First $500,000 of value 1.00% Over $500,000 of value 1.25% Market-rate Apartments Regular 1.80% Commercial Industrial First $150,000 of value 1.50% Over $150,000 of value 2.00% Actual City Property Tax Calculation* Taxable Market Value $100,000 $150,000 $250,000 $500,000 $750,000 Parcel Tax Capacity: First $500,000 @ 1.00% Over $500,000 @ 1.25% Total Tax Capacity: City Tax Rate City Property Tax 1,000 1,500 2,500 5,000 5,000 0 0 0 0 3,125 1,000 1,500 2,500 5,000 8,125 49.053% 49.053% 49.053% 49.053% 49.053% $490.53 $735.80 $1,226.33 $2,452.65 $3,985.56 *Note: Property Tax Calculations do not include reduction for homestead credit. 11 CITY OF STILLWATER, MINNESOTA PROPERTY TAX PAYERS City of Stillwater Who pays the Property Tax Levy Local levy -Residential taxpayers Fiscal Disparity portion of levy Taxes proposed in 2007: Total Levy ............................... Fiscal Disparity portion Local portion Breakdown of Local portion: Residential Commercial/Industrial/Utility Notes: Local levy -Comm/Ind/Util taxpayers of tots I $9,374,631 100.0% $819,600 8.6% $8,112,349 91.4% $6,619,677 81.6% $795,010 9.8% (1) For taxes proposed in 2007, 13.5% of the total tax capacity in the City of Stillwater is captured by TIF Districts. The tax generated by the captured value is not available to fund the local levy, so that can shift the local levy to other classifications. (2) A portion of the value of each commercial-industrial parcel is "contributed" to the metropolitan fiscal disparity pool and is not available to fund the local levy. The value in the metro-wide pool is redistributed back to the taxing districts based on relative fiscal capacity. The tax generated by that "distribution" value is considered the fiscal disparity portion of the levy. It is not directly attributable to the parcels in the City, it is based on the metro-wide pool. Information provided by Washington County 12 CITY OF STILLWATER, MINNESOTA TREND INFORMATION (Past 10 Years) TOTAL CERTIFIED LEVY $10,000,000 $9,000,000 $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $0 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 The Certified Levy consists of the General Tax Levy (General Fund operations) and the Debt Service Levy (Debt Service obligations). Year GENERAL TAX LEVY DEBT SERVICE LEVY TOTAL CERTIFIED LEVY 1998 $2,557,684 $1,659,302 $4,216,986 1999 $2,737,793 $1,499,592 $4,237,385 2000 $2,794,420 $1,520,689 $4,315,109 2001 $3,098,928 $1,601,657 $4,700,585 2002 $4,034,297 $1,890,540 $5,924,837 2003 $4,261,183 $2,342,774 $6,603,957 2004 $4,713,214 $2,583,083 $7,296,297 2005 $5,579,500 $2,811,379 $8,390,879 2006 $5,580,145 $3,305,610 $8,885,755 2007 $6,102,192 $3,284,439 $9,386,631 For the budget year 2006, the debt service levy increased over 2005 by 494,231, due primarily to the issuance of the Capital Outlay Bond issue for the Library Remodeling/Renovation Project. 13 CITY OF STILLWATER, MINNESOTA TREND INFORMATION (Past 10 Years) CITY TAX RATE 60% 50% 40% 30% 20% 10% 0% 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 Year TOTAL CERTIFIED LEVY FISCAL DISPARITY CONTRIBUTION* CITY LEVY CITY-WIDE TAXABLE TAX CAPACITY CITY TAX RATE 1998 $4,216,986 $648,223 $3,568,763 $9,574,099 37.148% 1999 $4,237,385 $631,505 $3,605,880 $9,327,260 38.560% 2000 $4,315,109 $663,188 $3,651,921 $10,215,272 35.750% 2001 $4,700,585 $649,419 $4,051,166 $11,348,752 35.697% 2002** $5,924,837 $658,560 $5,266,277 $9,858,886 53.417% 2003 $6,603,957 $624,031 $5,979,926 $11,334,107 52.761 2004 $7,296,297 $689,524 $6,606,773 $12,717,343 51.951 2005 $8,390,879 $751,237 $7,639,642 $14,797,188 51.629% 2006 $8,885,755 $794,406 $8,091,349 $16,431,705 49.243% 2007 $9,386,631 $819,600 $8,567,031 $18,432,325 46.478% The City Tax Rate is calculated by dividing the City Levy by the City-Wide Taxable Tax Capacity. * The Fiscal Disparity Contribution is the City's contribution to the Metropolitan Fiscal Disparities pool (property tax base sharing program) which in turn reduces the Total Certified Levy. ** The Property Tax Reform of 2001 changed the payable 2002 Class Rates which resulted in a reduction of Taxable Tax Capacity. 14 CITY OF STILLWATER, MINNESOTA TREND INFORMATION (Past 10 Years) LOCAL GOVERNMENT AID & GENERAL TAX LEVY $7,000,000 ., ,. , ~. _ ~ .~_, ..r. r. . . ~n ~i ~.,- '- ,~ ,... $6,000,000 _ - ___ _- . i 1 $5,000,000 _ _____-_ ---_ ____ i $4,000,000 -- -- -- - I $3,000,000 --- -- -- i $2,000,000 - - - __ ___ $1,000,000 ~ - _ ~ i $0 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 ^ Local Government Aid ^ General Tax Levy Year Local Government Aid General Tax Levy 1998 $1,989,846 $2,557,684 1999 $2,034,775 $2,737,793 2000 $2,128,009 $2,794,420 2001 $2,135,657 $3,098,928 2002 $1,400,432 $4,034,297 2003 $656,737 $4,261,183 2004 $656,737 $4,713,214 2005 $955,355 $5,579,500 2006 $911,838 $5,601,145 2007 $722,075 $6,102,192 The Property Tax Reform- Bill of 2001 shifted the tax burden directly to the property tax levy by reducing State Aids (LGA & HACA) to cities. The above graph shows the direct correlation between the reduction in State Aids and the increase in the General Tax Levy. 15 CITY OF STILLWATER, MINNESOTA TREND INFORMATION (Past 10 Years) OPERATING REVENUES'` $14,000,000 $12,000,000 -- _ $10,000,000 _.-_..-_- _-- 'z $8,000,000 `~ $6,000,000 :_ - _ _ _ - $4,000,000 - - --- - $2,000,000 -- - $0 \ \ ~ \ \ ~ ~ \ ~~3 ~~~ ~J@ ~Ja ~~a ~~~ ~~a ~J~ aka ~~a Q.~ Q.~ Q,~ Q.~ Q,~ Q.~ Q.~ Q.~ ~~ aoQ ~°~°~ ~°~°~ ~0~ ~0~ ADO ADO ~~O ~~O ~OO~P `L~O~ ^ Property Taxes ^ Franchise Fees ^ Licenses/Permits ^ Intergovernmental ^ Charges for Services ^ Fines & Forfeits ^ Miscellaneous * Includes the General Fund and budgeted Special Revenue funds. Excludes Capital Outlay bond proceeds and Interfund Transfers. 16 CITY OF STILLWATER, MINNESOTA TREND INFORMATION (Past 10 Years) OPERATING EXPENDITURES* $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 ^ General Government ^ Public Safety ^ Public Works ^ Culture and Recreation * Includes the General Fund and budgeted Special Revenue funds. Excludes Capital Outlay and Interfund Transfers. 17 ~Ja ~J~ ~~~ ~~~ ~Jra aka ~~a ~p0 tipp~ tipp~ tipp~ tipp~ pppP~ ~pplP ti CITY OF STILLWATER. MINNESOTA ZOO7 OPERATING REVENUES* Miscellaneous 3% Fines & Forfeits 1% , Charges for Services 23% Revenue Type Property Taxes Franchise Fees Licenses & Permits Intergovernmental Charges for Services Fines & Forfeits Miscellaneous Total: Amount $ 6,122,892 410,000 853,365 1,247,827 2,660,501 100,700 304,830 $ 11,700,115 Property Taxes 51% Franchise Fees '~ Includes the General Fund and budgeted Special Revenue funds. Excludes Capital Outlay bond proceeds and Interfund Transfers. 18 C:I 1 Y Ur 51 ILLWA I tK, MINNESOTA ZOO7 OPERATING EXPENDITURES* Mayor & City Council $ 149,856 Engineering $ 401,999 Elections 11,347 Streets 1,183,659 MIS Support Services 175,237 Wash Co Recycling Grant 33,378 Finance 399,797 Public Works $ 1,619,036 Administration 594,490 Law/City Attorney 285,401 Special Events $ 62,500 Plant/City Hall 207,042 St Croix Valley Rec Center 1,125,341 Community Development 355,290 Library 1,066,475 Unallocated 652,751 Parks 741,064 General Government $ 2,831,211 Culture & Recreation $ 2,995,380 Police $ 2,535,542 Total Budgeted Expenditures $ 11,355,597 Fire 1,074,880 Inspection 291,482 Civil Defense 5,066 DARE 3,000 Public Safety $ 3,909,970 * Includes the General Fund and budgeted Special Revenues Funds Excludes Capital Outlay and Interfund Transfers 19 THIS PAGE INTENTIALLY LEFT BLANK ~ BUDGET 1 1 SCHEDULES THIS PAGE INTENTIALLY LEFT BLANK ~ General Fund The General Fund is the general operating fund for the City. It is used to account for all financial resources except those required to be accounted for in another fund. ~~ THIS PAGE INTENTIALLY LEFT BLANK U 0 CITY OF STILLWATER, MINNESOTA GENERAL FUND SUMMARY OF REVENUES AND EXPENDITURES REVENUES: Property Taxes Franchise Fees Licenses & Permits Special Assessments Intergovernmental Charges for Services Fines & Forfeits Miscellaneous Revenue Totals EXPENDITURES: General Government Mayor & City Council Elections MIS Support Services Finance Administration Legal/City Attorney Plant/City Hall Community Development Unallocated General Government Total Public Safety Police Fire Inspection Civil Defense Public Safety Total Public Works Engineering Street Public Works Total Expenditure Totals Revenues over (under) Expenditures Other Financing Sources (Uses): ' Transfers in Sale of Property Transfers (out): Special Events Fund Library Fund Park Fund 1 DARE Fund Capital Projects Fund Total Other Financing Sources (Uses) Net increase in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) $ 5,290,346 $ 5,601,045 $ 6,122,892 $ 521,847 404,448 400,000 410,000 10,000 941,330 692,730 851,865 159,135 7,532 4,500 4,500 - 1,732,018 1,409,062 1,214,449 (194,613) 1,190,384 1,194,767 1,231,284 36,517 106,774 101,500 100,700 (800) 219,524 133,500 164,830 31,330 $ 9,892,356 $ 9,537,104 $ 10,100,520 $ 563,416 $ 144,224 $ 150,850 $ 149,856 $ (994) 6,306 42,337 15,347 (26,990) 149,682 195,672 247,437 51,765 379,881 403,006 420,097 17,091 556,604 578,160 613,190 35,030 269,699 269,389 285,401 16,012 247,616 274,042 328,184 54,142 272,152 314,031 363,990 49,959 584,961 612,695 652,751 40,056 $ 2,611,125 $ 2,840,182 $ 3,076,253 $ 236,071 $ 2,392,616 $ 2,630,618 $ 2,753,842 $ 123,224 971,634 1,176,094 1,264,380 88,286 307,453 320,629 320,182 (447) 2,317 15,066 5,066 (10,000) $ 3,674,020 $ 4,142,407 $ 4,343,470 $ 201,063 $ 375,122 $ 381,623 $ 416,199 $ 34,576 1,369,269 1,313,493 1,574,138 260,645 $ 1,744,391 $ 1,695,116 $ 1,990,337 $ 295,221 $ 8,029,536 $ 8,677,705 $ 9,410,060 $ 732,355 $ 1,862,820 $ 859,399 $ 690,460 $ (168,939) $ 607,009 $ 742,050 $ 1,042,579 $ 300,529 12,323 - 12,000 12,000 (17,750) (17,500) (17,500) - (883,901) (926,447) (1,009,475) (83,028) (630,758) (654,002) (715,564) (61,562) (4,000) (3,500) (2,500) 1,000 (635,932) $ (1,553,009) $ (859,399) $ (690,460) $ 168,939 $ 309,811 $ - $ - $ - 3,359,752 3,669,563 3,669,563 - $ 3,669,563 $ 3,669,563 $ 3,669,563 $ - 25 ~, 1 CITY OF STILLWATER, MINNESOTA REVENUES Fund: General Fund Number: 100 2006 2007 2005 AMENDED ADOPTED $ Increase SUMMARY OF REVENUES ACTUAL BUDGET BUDGET (Decrease) TAXES: $ 5,290,346 $ 5,601,045 $ 6,122,892 $ 521,847 FRANCHISE FEES: $ 404,448 $ 400,000 $ 410,000 $ 10,000 LICENSES ~ PERMITS: $ 941,330 $ 692,730 $ 851,865 $ 159,135 SPECIAL ASSESSMENTS: $ 7,532 $ 4,500 $ 4,500 $ - INTERGOVERNMENTAL: Federal: SAFR Grant $ - $ 36,000 $ - $ (36,000) Miscellaneous 29,860 7,500 27,500 20,000 State: Local Government Aid 955,891 911,838 722,075 (189,763) Market Value Homestead Credit 286,677 - - - PERA State Aid 15,874 15,874 15,874 - State Grant 6,172 2,500 2,500 - Police State Aid 122,326 115,000 120,000 5,000 Police Training Aid 7,050 9,000 9,000 - Fire State Aid 162,719 165,000 165,000 - MSA 115,807 115,000 115,000 - Other 29,642 - - - Local: Highway Aid - 2,000 2,500 500 Juvenile Officer - 29,350 35,000 5,650 Intergovernmental Total $ 1,732,018 $ 1,409,062 $ 1,214,449 $ (194,613) CHARGES FOR SERVICE: Fire Contracts $ 264,862 $ 263,286 $ 271,200 $ 7,914 Admin Charges 90,563 93,281 82,236 (11,045) Other Fees 834,959 838,200 877,848 39,648 Charges for Service Total $ 1,190,384 $ 1,194,767 $ 1,231,284 $ 36,517 FINES & FORFEITS: $ 106,774 $ 101,500 $ 100,700 $ (800) MISCELLANEOUS: Interest $ 63,372 $ 50,000 $ 65,000 $ 15,000 Other 156,152 83,500 99,830 16,330 Miscellaneous Total $ 219,524 $ 133,500 $ 164,830 $ 31,330 Total Revenues $ 9,892,356 $ 9,537,104 $ 10,100,520 $ 563,416 27 CITY OF STILLWATER, MINNESOTA MAYOR & CITY COUNCIL Fund: General Account Number: 100-4040 Department Description: The City Council, which consists of the Mayor and four Council Members, is the governing body responsible for directing the activities of the City. The Council meets in a open forum on the first and third Tuesday of every month. 2007 Staffing Level: Part-Time (Benefited) 5.0 Number of Positions 2007 Budget Impacts: - Personnel costs include a 16.0% increase in health insurance rates, and a 0% increase on dental insurance rates. - Contractual services consist of contracted lobbyist services. - Memberships 8 Dues include memberships to the League of MN Cities (LMC), Sister Cities, National League of Cities (NLC) and the Greater Area Chamber of Commerce. 28 CITY OF STILLWATER, MINNESOTA MAYOR & CITY COUNCIL Fund: General /account Number: 100-4000 2005 SUMMARY OF EXPENDITURES ACTUAL PERSONNEL SERVICES: Salaries -Part Time Benefits Personnel Services Total SERVICES AND CHARGES: Contractual Other Total Services and Charges MISCELLANEOUS: Memberships & Dues Other Total Miscellaneous Total Expenditures 2006 2007 AMENDED ADOPTED $ Increase BUDGET BUDGET (Decrease) $ 37,524 $ 37,800 $ 37,800 $ - 28,899 31,159 30,403 (756) $ 66,423 $ 68,959 $ 68,203 $ (756) $ 46,578 $ 46,000 $ 46,000 $ - 15,285 18,461 17,453 (1,008) $ 61,863 $ 64,461 $ 63,453 $ (1,008) $ 13,171 12,930 $ 13,700 $ 770 2,767 4,500 4,500 - $ 15,938 $ 17,430 $ 18,200 $ 770 $ 144,224 $ 150,850 $ 149,856 $ (994) 29 CITY OF STILLWATER, MINNESOTA ELECTIONS Fund: General Account Number: 100-4010 Department Description: The Elections Department administers required primary, general and special elections held in the City. 2007 Staffing Level: Part Time Seasonal 110.0 Number of Positions 2007 Budget Impacts: - 2007 is a school board election year. Washington County will reimburse the City for the costs of this election. Reimbursement of these costs are recorded under Refund 8 Reimbursements in the revenue section of the General Fund. - Personnel costs include new judges for the splitting of Ward 1 into two precincts. 30 CITY OF STILLWATEFt, MINNESOTA ELECTIONS Fund: Genera] Account Number: 100-4010 2005 SUMMARY OF EXPENDITURES ACTUAL PERSONNEL SERVICES: Salaries -Full Time Salaries -Part Time Benefits Personnel Services Total SUPPLIES: SERVICE AND CHARGES: MISCELLANEOUS: CAPITAL OUTLAY: Machinery & Equipment Total Capital Outlay Total Expenditures 2006 2007 AMENDED ADOPTED $ Increase BUDGET BUDGET (Decrease) $ - $ 1,400 $ 1,500 $ 100 4,850 27,650 5,500 (22,150) - 191 630 439 $ 4,850 $ 29,241 $ 7,630 $ (21,611) $ - $ 1,200 $ - $ (1,200) $ 1,087 $ 4,496 $ 3,267 $ (1,229) $ 369 $ 1,400 $ 450 $ (950) $ - $ 6,000 $ 4,000 $ (2,000) $ - $ 6,000 $ 4,000 $ (2,000) $ 6,306 $ 42,337 $ 15,347 $ (26,990) 31 CITY OF STILLWATER, MINNESOTA MIS SUPPORT SERVICES Fund: General Account Number: 100-4020 Department Description: MIS Support Services provides the for purchasing, installation, and support of communication and information systems. 2007 Staffing Level: Full Time 1.8 FTE (Full Time Equivalents) 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan. - Personnel includes 80% of an additional full-time position. The remaining 20% is allocated to the Library Fund. Cost for this position, wages and benefits, for this department is $46,747. 32 7 r J ii r C 7 I~ CITY OF STILLWATER, MINNESOTA MIS SUPPORT SERVICES Fund: General Account Number: 100-4020 2006 2007 2005 AMENDED ADOPTED $ Increase SUMMARY OF EXPENDITURES ACTUAL BUDGET BUDGET (Decrease) PERSONNEL SERVICES: Salaries -Full Time Benefits Personnel Services Total SUPPLIES: Software Other Supplies Total SERVICES AND CHARGES: Internet Professional Services Maintenance Agreements Other Total Services and Charges MISCELLANEOUS: CAPITAL OUTLAY: Computer Equipment Total Capital Outlay Total Expenditures $ 55,601 $ 23,782 _ $ 79,383 $ 64,992 $ 102,300 $ 37,308 17,859 30,598 12,739 82,851 $ 132,898 $ 50,047 $ 2,461 $ 6,600 $ 6,000 $ (600) 3,780 5,000 4,500 (500) $ 6,241 $ 11,600 $ 10,500 $ (1,100) $ 2,639 $ 6,640 $ 4,800 $ (1,840) 8,397 10,500 10,500 - 8,517 14,500 11,000 (3,500) 13,748 5,181 5,439 258 $ 33,301 $ 36,821 $ 31,739 $ (5,082) $ 1,234 $ 100 $ 100 $ - $ 29,523 $ 64,300 $ 72,200 $ 7,900 $ 29,523 $ 64,300 $ 72,200 $ 7,900 $ 149,682 $ 195,672 $ 247,437 $ 51,765 33 CITY OF STILLWATER, MINNESOTA i FINANCE Fund: General ' Account Number: 100-4030 Department Description: The Finance Department accounts for the financial operations of the City and assists the City Treasurer with treasury operations and debt management. 2007 Staffing Level: Full Time 4.5 FTE (Full Time Equivalents) 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan. -Professional Services funds will be used for the implementation (actuarial study) of GASB Statement No. 45 Accounting and Financial Reporting by employers for Post employment Benefits Other Than Pensions. u 34 ' CITY OF STILLWATER, MINNESOTA FINANCE Fund: General Fund-Department Number: 100-4030 SUMMARY OF EXPENDITURES PERSONNEL SERVICES: Salaries -Full Time Benefits Personnel Services Total SUPPLIES: SERVICES AND CHARGES: Auditing Professional Services Maintenance Agreements Other Total Services and Charges MISCELLANEOUS: CAPITAL OUTLAY: Computer Equipment Total Capital Outlay Total Expenditures 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) $ 207,601 $ 242,758 $ 257,164 $ 14,406 96,140 60,239 64,962 4,723 $ 303,741 $ 302,997 $ 322,126 $ 19,129 $ 16,673 $ 10,500 $ 9,500 $ (1,000) $ 27,308 $ 29,700 $ 29,700 $ - 2,774 7,000 7,000 - 12,975 17,000 15,000 (2,000) 11,392 14,709 .14,221 (488) $ 54,449 $ 68,409 $ 65,921 $ (2,488) $ 1,882 $ 1,100 $ 2,250 $ 1,150 $ 3,136 $ 20,000 $ 20,300 $ 300 $ 3,136 $ 20,000 $ 20,300 $ 300 $ 379,881 $ 403,006 $ 420,097 $ 17,091 35 CITY OF STILLWATER, MINNESOTA ADMINISTRATION Fund: General Account Number: 100-4040 Department Description: The Administration Department is responsible for carrying out the policies and actions of the City Council. ' The City Administrator also act as the City Treasurer. 2007 Staffing Level: Full Time 4.9 FTE (Full Time Equivalents) Part Time 2.0 Number of Positions 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan. - Printing and Publishing costs provide for 4 quarterly City newsletters. -Assessing costs are property valuation services provided by Washington County. These valuations are then used during the property taxation process. - Professional Services include services fees provided to the City for an actuarial study (Medicare Part B), Safety Training and the Employee Assistance Program. 36 L ~i i~ J u CITY OF STILLWATER, MINNESOTA ADMINISTRATION Fund: Genera] Account Number: 100-4040 i~ SUMMARY OF EXPENDITURES PERSONNEL SERVICES: Salaries -Full Time Salaries -Part Time Benefits Personnel Services Toiai SUPPLIES: SERVICES AND CHARGES: Assessing Professional Services Printing and Publishing Other Total Services and Charges MISCELLANEOUS: CAPITAL OUTLAY: Machinery & Equipment Computer Equipment Total Capital Outlay Total Expenditures 2005 ACTUAL 2006 AMENDED BUDGET 296,244 $ 3,779 98,204 _ 398,227 $ 3,795 $ 422,655 $ 5,350 $ 2007 ADOPTED $ Increase BUDGET (Decrease) 345,960 $ 10,361 5,500 (4,500) 81,139 4,083 432,599 $ 9,944 6,200 $ 850 $ 80,231 $ 85,000 $ 84,242 $ (758) 14,325 15,000 20,000 5,000 11,624 10,000 13,500 3,500 17,779 22,805 32,449 9,644 $ 123,959 $ 132,805 $ 150,191 $ 17,386 $ 3,738 $ 5,950 $ 5,500 $ (450) $ 1,726 $ - $ - $ - 25,159 11,400 18,700 7,300 $ 26,885 $ 11,400 $ 18,700 $ 7,300 $ 556,604 $ 578,160 $ 613,190 $ 35,030 37 335,599 $ 10,000 77,056 CITY OF STILLWATER, MINNESOTA LEGAL/CITY ATTORNEY Fund: General Account Number: 100-4045 Department Description: The City has on retainer (paid through payroll with PERA benefits deducted) a law firm that provides prosecution services and legal counsel to the City Council and the City Staff for City related issues. 2007 Staffing Level: Part-Time (Benefited) 1.0 Number of Positions 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan. Notes: - Legal/Prosecution costs are partially recovered through restitution fees. These fees are recorded as Fines and Forfeits-Ordinance Violations in the revenue section of the General Fund. ~i 38 CITY OF STILLWATER, MINNESOTA LEGAL/CITY ATTORNEY Fund: General Account Number: 100-4045 2005 SUMMARY OF EXPENDITURES ACTUAL PERSONNEL SERVICES: Retainer Benefits Personnel Services Total SUPPLIES: SERVICES AND CHARGES: Legal/Prosecution Other Total Services and Charges MISCELLANEOUS: Total Expenditures 2006 AMENDED BUDGET 2007 ADOPTED BUDGET $ Increase (Decrease) $ 80,000 $ 92,400 $ 95,634 $ 3,234 18,418 21,535 22,327 792 $ 98,418 $ 113,935 $ 117,961 $ 4,026 $ 2,658 $ 3,600 $ 3,600 $ - $ 147,321 $ 135,000 $ 145,000 $ 10,000 19,934 14,854 16,840 1,986 $ 167,255 $ 149,854 $ 161,840 $ 11,986 $ 1,368 $ 2,000 $ 2,000 $ - $ 269,699 $ 269,389 $ 285,401 $ 16,012 39 CITY OF STILLWATER, MINNESOTA PLANT/CITY HALL Fund: General ' Account Number: 100-4050 Department Description: Plant/City Hall provides boiler, HVAC, and general building maintenance including janitorial services for City Hall. 2007 Staffing Level: Full Time 1.0 FTE (Full Time Equivalents) 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan. - Natural Gas costs reflects a possible 4% increase in rates. - A water leak investigation in 2006 revealed some solutions to the ongoing water leak problem that has been reoccurring since 1997. Solutions include $75,000 expenditure for waterproofing. This expenditure is reflected in Capital Outlay - Improvements . J r 40 CITY OF STILLWATER, MINNESOTA PLANT/CITY HALL Fund: General Account Number: 100-4050 2006 2007 2005 AMENDED ADOPTED $ Increase SUMMARY OF EXPENDITURES ACTUAL BUDGET BUDGET (Decrease) PERSONNEL SERVICES: Salaries -Full Time $ 37,597 $ 41,424 $ 42,849 $ 1,425 Benefits 8,459 6,139 6,441 302 Personnel Services Total $ 46,056 $ 47,563 $ 49,290 $ 1,727 SUPPLIES: $ 18,248 $ 18,800 $ 24,100 $ 5,300 SERVICES AND CHARGES: Electricity $ 33,278 $ 35,000 $ 35,000 $ - Natural Gas 33,648 42,000 44,000 2,000 Maintenance Agreements 16,547 19,200 21,000 1,800 Other 50,418 42,679 55,294 12,615 Total Services and Charges $ 133,891 $ 138,879 $ 155,294 $ 16,415 MISCELLANEOUS: $ 1,659 $ 1,800 $ 2,000 $ 200 CAPITAL OUTLAY: Improvements $ 47,762 $ 67,000 $ 97,500 $ 30,500 Total Capital Outlay $ 47,762 $ 67,000 $ 97,500 $ 30,500 Total Expenditures $ 247,616 $ 274,042 $ 328,184 $ 54,142 41 CITY OF STILLWATER, MINNESOTA COMMUNITY DEVELOPMENT Fund: General Account Number: 100-4055 Department Description: The Community Development Department is responsible for zoning administration, comprehensive planning, historic preservation and economic development/redevelopment. The department assists the citizen committees of the Planning Commission, Parks Board, Heritage Preservation Commission, Downtown Parking Commission and Joint Stillwater Township City Planning Board in carrying out their responsibilities. 2007 Staffing Level: Full Time 2.5 FTE (Full Time Equivalents) Part Time 1.0 Number of Positions 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan. - Part Time Salaries include an additional Assistant Planner/Permit Tech position. The cost of this additional position, salary and benefits, is $23,721. - Professional Services includes: (1) $50,000 for the Downtown Plan - 2nd half of a two year commitment ;and (2) $60,000 for the Comp Plan update - 1st half of a two year commitment. State Statutes require that the City's Comp Plan be updated and submitted to Met Council for review by September 2008. 42 CITY OF STILLWATER, MINNESOTA COMMUNITY DEVELOPMENT Fund: General Account Number: 100-4055 2006 2007 2005 AMENDED ADOPTED $ Increase SUMMARY OF EXPENDITURES ACTUAL BUDGET BUDGET (Decrease) PERSONNEL SERVICES: Salaries -Full Time $ 145,718 $ 166,252 $ 162,884 $ (3,368) Salaries -Part Time - 16,944 7,500 (9,444) Benefits 59,573 51,937 42,054 (9,883) Personnel Services Total $ 205,291 $ 235,133 $ 212,438 $ (22,695) SUPPLIES: $ 5,188 $ 7,525 $ 8,750 $ 1,225 SERVICES AND CHARGES: Professional Services $ 37,622 $ 50,000 $ 110,000 $ 60,000 Other 17,179 17,123 21,552 4,429 Total Services and Charges $ 54,801 $ 67,123 $ 131,552 $ 64,429 MISCELLANEOUS: $ 1,569 $ 2,450 $ 2,550 $ 100 CAPITAL OUTLAY: Computer Equipment 5,303 1,800 8,700 6,900 Total Capital Outlay $ 5,303 $ 1,800 $ 8,700 $ 6,900 Total Expenditures $ 272,152 $ 314,031 $ 363,990 $ 49,959 43 CITY OF STILLWATER, MINNESOTA POLICE Fund: General Account Number: 100-4060 Department Description: The Police Department provides law enforcement services and education to its citizens. 2007 Staffing Level: Full Time 25.5 FTE (Full Time Equivalents) Part Time 2.0 Number of Positions 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan and from 10.50% to 11.70% for the Police and Fire Plan. -Salaries -Full Time Salaries include $26,000 for overtime costs associated with the Lumberjack Days festival. These costs are refunded by the event coordinator and recorded as Refunds and Reimbursements in the revenue section of the General Fund. - Salaries -Full Time Salaries include $8,500 for overtime costs associated with the Safe & Sober program. These costs are refunded by a federal grant and recorded as Miscellaneous Grants-Federal in the revenue section of the General Fund. - Terminal Access Charge -include costs for access to the County and State record system. -Radio Maintenance - $9,000 for radio maintenance on the 800MHz radio system. - Capital Outlay-Machinery 8 Equipment includes $70,000 for the implementation of the State-Wide 800 MHz Public Safety Radio system. An additional $70,000 will be needed to complete this project and will be budgeted in 2008. r I u 44 i~ CITY OF STILLWATER, MINNESOTA POLICE Fund: General Account Number: 100-4060 SUMMARY OF EXPENDITURES PERSONNEL SERVICES: Salaries -Full Time Salaries -Part Time Benefits Personnel Services Total SUPPLIES: Automotive Fuel Other Supplies Total SERVICES AND CHARGES: Terminal Access Charges Maintenance Agreements General Insurance Other Total Services and Charges MISCELLANEOUS: CAPITAL OUTLAY: Machinery & Equipment Computer Equipment Automotive Equipment Total Capital Outlay Total Expenditures 2006 2005 AMENDED ACTUAL BUDGET 2007 ADOPTED BUDGET $ Increase (Decrease} $ 1,331,088 $ 1,583,767 $ 1,694,393 $ 110,626 34,656 40,000 60,000 20,000 563,659 546,617 482,581 (64,036) $ 1,929,403 $ 2,170,384 $ 2,236,974 $ 66,590 45,044 $ 45,000 $ 50,000 $ 44,106 30,500 34,000 _ 89,150 $ 75,500 $ 84,000 $ $ 15,786 $ 1,274 65,747 75,612 26,500 $ 12,000 70,334 65,900 $ 158,419 $ 174,734 $ $ 20,167 $ 16,000 $ 5,000 3,500 8,500 26,500 $ - 12,000 - 76,568 6,234 83,500 17,600 198,568 $ 23,834 16,000 $ - $ 27,537 $ 10,000 $ 25,000 $ 15,000 53,236 63,000 93,300 30,300 114,704 121,000 100,000 (21,000} $ 195,477 $ 194,000 $ 218,300 $ 24,300 $ 2,392,616 $ 2,630,618 $ 2,753,842 $ 123,224 45 CITY OF STILLWATER, MINNESOTA Flx~ Fund: General Account Number: 100-4070 Department Description: The Fire Department provides fire protection services and education to its residents along with Stillwater Township and a portion of the residents of City of Grant and May Township. 2007 Staffing Level: Full Time 9.5 FTE (Full Time Equivalents) Part Time 34.0 Number of Positions 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan and from 10.50% to 11.70% for the Police and Fire Plan. - Capital Outlay-Machinery 8 Equipment includes $60,000 for the implementation of the State-Wide 800 MHz Public Safety Radio system. An additional $60,000 will be needed to complete this project and will be budgeted in 2008. Late 2006, the City was awarded a grant by the Department of Homeland Security in the amount of $65,000 to assist with funding of this project . A portion (because this project overlaps to budget years, 2007 and 2008), $20,000, of this grant is recorded as Miscellaneous Federal Grants under the revenue section of the General Fund. - Capital Outlay-Automotive Equipment includes $75,000 for the purchase of a fire engine in or around 2009. These funds will be placed in reserves along with additional funds that will be budgeted in 2008 and 2009. Notes: -The Stillwater Fire Department also provides fire protection services to Stillwater Township and to portions of City of Grant and May Township. Reimbursement for these services is provided by a contractual agreement and recorded as Charges for Services-Fire Contracts in the revenue section of the General Fund. 46 0 ii n L CITY OF STILLWATER, MINNESOTA Flx~ Fund: General Account Number: 100-4070 2005 SUMMARY OF EXPENDITURES ACTUAL 2006 AMENDED BUDGET 2007 ADOPTED BUDGET PERSONNEL SERVICES: Salaries -Full Time Salaries -Part Time Benefits Personnel Services Total SUPPLIES: SERVICES AND CHARGES: Vehicle Repair Charges General Insurance Other Total Services and Charges MISCELLANEOUS: CAPITAL OUTLAY: Improvements Machinery & Equipment Computer Equipment Automotive Equipment Total Capital Outlay Total Expenditures $ Increase (Decrease) $ 489,634 $ 572,545 $ 597,927 $ 25,382 91,498 115,000 110,000 (5,000) 174,236 208,575 188,561 (20,014) $ 755,368 $ 896,120 $ 896,488 $ 368 $ 36,361 $ 46,650 $ 48,670 $ 2,020 $ 18,753 $ 22,500 $ 22,500 $ - 48,767 53,264 55,957 2,693 46,309 38,510 44,965 6,455 $ 113,829 $ 114,274 $ 123,422 $ 9,148 $ 5,961 $ 6,100 $ 6,300 $ 200 $ - $ - $ 25,000 $ 25,000 52,543 19,750 16,000 (3,750) 7,572 13,200 67,700 54,500 - 80,000 80,800 800 $ 60,115 $ 112,950 $ 189,500 $ 76,550 $ 971,634 $ 1,176,094 $ 1,264,380 $ 88,286 47 CITY OF STILLWATER, MINNESOTA INSPECTIONS Fund: General Account Number: 100-4080 Department Description: The Inspections Department provides technical assistance, plan review services and plumbing, ' mechanical and building inspections services for code compliance- 2007 Staffing Level: Full Time 3.5 FTE (Full Time Equivalents) fl 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, ' 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan. Notes: - The Building Permit Surcharge expenditure line item is the disbursement of the mandatory fees collected with building permits to the State of Minnesota. These fees collected are recorded as Charges for Services-Building Permit Surcharge in the revenue section of the General Fund. 48 CITY OF STILLWATER, MINNESOTA INSPECTIONS Fund: General Account Number: 100-4080 SUMMARY OF EXPENDITURES PERSONNEL SERVICES: Salaries -Full Time Benefits Personnel Services Total SUPPLIES: SERVICES AND CHARGES: Building Permit Surcharge Other Total Services and Charges MISCELLANEOUS: CAPITAL OUTLAY: Machinery & Equipment Computer Equipment Total Capital Outlay Total Expenditures 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) $ 159,231 $ 185,838 $ 188,706 $ 2,868 71,957 57,322 54,666 (2,656) $ 231,188 $ 243,160 $ 243,372 $ 212 $ 6,223 $ 7,300 $ 8,500 $ 1,200 $ 34,344 $ 28,000 $ 15,000 $ (13,000) 27,295 20,319 23,760 3,441 $ 61,639 $ 48,319 $ 38,760 $ (9,559) $ 590 $ 550 $ 850 $ 300 $ 2,510 $ - $ - $ - 5,303 21,300 28,700 7,400 $ 7,813 $ 21,300 $ 28,700 $ 7,400 $ 307,453 $ 320,629 $ 320,182 $ (447) 49 CITY OF STILLWATER, MINNESOTA CIVIL DEFENSE Fund: General Account Number: 100-4085 Department Description: The Civil Defense Department provides for the maintenance of the City's civil defense warning system. Notes: - The City maintain 5 civil defense sirens located at: (1) 1419 4th Street; (2) 116 Willard Street W; (3) 900 Nightengale Blvd; (4) 2001 Willard Street W; and (5) 13300 McKusick Rd Ln N. 50 CITY OF STILLWATER, MINNESOTA CIVIL DEFENSE Fund: General Account Number: 100-4085 2005 SUMMARY OF EXPENDITURES ACTUAL SUPPLIES: SERVICES AND CHARGES: MISCELLANEOUS: CAPITAL OUTLAY: Machinery 8~ Equipment Total Capital Outlay Total Expenditures $ - $ $ 1,913 $ $ 404 $ 2006 2007 AMENDED ADOPTED $ Increase BUDGET BUDGET (Decrease) 50 $ 50 $ - 4,766 $ 4,466 $ (300) 250 $ 550 $ 300 $ - $ 10,000 $ $ - $ 10,000 $ $ 2,317 $ 15,066 $ - $ (10,000) - $ (10,000) 5,066 $ (10,000) 51 CITY OF STILLWATER, MINNESOTA ENGINEERING Fund: General Account Number: 100-4090 Department Description: The Engineering Department provides for the coordination, administration, and engineering of the City's transportation and utility infrastructure. The Department is supported by fees charged to developers and City projects. 2007 Staffing Level: Full Time 4.1 FTE (Full Time Equivalents) Part Time (Seasonal) 1.0 Number of Positions 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan. Notes: - Reimbursement of fees charged to projects are recorded as Engineering Charges in the revenue section of the General Fund. 52 r L J u u CITY OF STILLWATER, MINNESOTA ENGINEERING Fund: General Account Number: 100-4090 SUMMARY OF EXPENDITURES PERSONNEL SERVICES: Salaries -Full Time Salaries -Part Time Benefits Personnel Services Total SUPPLIES: SERVICES AND CHARGES: MISCELLANEOUS: CAPITAL OUTLAY: Improvements Machinery & Equipment Computer Equipment Total Capital Outlay Total Expenditures 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) $ 238,311 $ 261,744 $ 273,119 $ 11,375 1,421 6,000 6,000 - 85,769 66,731 72,132 5,401 $ 325,501 $ 334,475 $ 351,251 $ $ 9,088 $ 11,900 $ 15,900 $ $ 20,131 $ 30,198 $ 31,598 $ $ 1,957 $ 3,250 $ 3,250 $ $ 8,993 $ - $ - $ 500 - - 8,952 1,800 14,200 _ $ 18,445 $ 1,800 $ 14,200 $ $ 375,122 $ 381,623 $ 416,199 $ 16,776 4,000 1,400 12,400 12,400 34,576 53 CITY OF STILLWATER, MINNESOTA STREETS Fund: General Account Number: 100-4100 Department Description: The Streets Department provides ongoing maintenance of the City's street system and City vehicles and equipment. ~uui stamng Levei: Full Time 9.55 FTE (Full Time Equivalents) Part Time (Seasonal) 3.0 Number of Positions 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and 0% increase on dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 26, 2007, the employers contribution to the plan increase from 6.00% to 6.25% for the Coordinated Plan. - Seal coating/patching of $150,000 will seal coat roughly 7-8 miles of streets. Seal coating is a common preventive maintenance tool that extends the life of the street. The City's goal is to seal coat a street every 7 years. With the City having 80 miles of streets, an estimated 11.5 miles of streets needs to be seal coated every year. The goal of the City Council is to gradually increase the budget amount of seal coating every year to get to the 11.5 miles of seal coating every year. 54 11 11 ~i n ~i ~i G CITY OF STILLWATER, MINNESOTA STREETS Fund: General Account Number: 100-4100 SUMMARY OF EXPENDITURES PERSONNEL SERVICES: Salaries -Full Time Salaries -Part Time Benefits Personnel Services Total SUPPLIES: Asphalt Salt & Sand Automotive Fuel Equipment Repair Supplies Other Supplies Total SERVICES AND CHARGES: Contractual Seal coating/Patching General Insurance Other Total Services and Charges MISCELLANEOUS: CAPITAL OUTLAY: Improvements Machinery & Equipment Computer Equipment Automotive Equipment Total Capital Outlay Total Expenditures 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) $ 405,071 $ 456,371 $ 471,527 $ 15,156 - 21,200 2,120 (19,080) 170,443 129,462 156,895 27,433 $ 575,514 $ 607,033 $ 630,542 $ 23,509 $ 21,219 $ 30,000 $ 32,000 $ 2,000 92,504 65,000 72,000 7,000 41,447 32,000 35,000 3,000 26,492 28,000 28,000 - 47,462 49,500 55,000 5,500 $ 229,124 $ 204,500 $ 222,000 $ 17,500 $ 81,345 $ 30,000 $ 30,000 $ - 83,692 100,000 150,000 50,000 47,417 49,660 51,167 1,507 63,002 84,500 93,650 9,150 $ 275,456 $ 264,160 $ 324,817 $ 60,657 $ 2,832 $ 6,300 $ 6,300 $ - $ 10,118 $ - $ - $ - 14,580 10,000 66,804 56,804 4,489 4,500 3,800 (700) 257,156 217,000 319,875 102,875 $ 286,343 $ 231,500 $ 390,479 $ 158,979 $ 1,369,269 $ 1,313,493 $ 1,574,138 $ 260,645 55 UNALLOCATED Fund: General Account Number: 100-4140 Department Description: Unallocated expenditures are those expenditures that can not be specifically assigned to a certain department. 2007 Budget Impacts: - Retiree Hospital/Medical benefits include a 16% increase in health insurance rates. - Miscellaneous Other includes a $20,000 contribution to the St. Croix Valley Athletic Partnership (Lucy Winten Bell Foundation). This contribution is a four year commitment that was approved by the City Council on December 16, 2003. The contribution began with the budget year 2004 and ends in 2007. The contribution commitment is for $20,000 per year for a total of $80,000. - The Fire Re/iefAssociation line item expenditure is the disbursement of the State of Minnesota's minimum support rate to the Stillwater Fire ReliefAssociation's pension plan. Support rates are established by the State Legislature. Receipt of these funds from the State are recorded as Intergovernmental-Fire State Aid in the revenue section of the General Fund. Notes: - Retiree Hospital/Medical benefits are post health care benefits available to employees who were hired prior to December 31, 1988, are eligible for PERA retirement benefits, and have been employed with the City for 10 years or more. 56 n 0 u i C! CITY OF STILLWATER, MINNESOTA UNALLOCATED Fund: General Account Number: 100-4140 2006 2007 2005 AMENDED ADOPTED $ Increase SUMMARY OF EXPENDITURES ACTUAL BUDGET BUDGET (Decrease) PERSONNEL SERVICES: Retiree Hospital/Medical $ 324,984 $ 340,080 $ 380,136 $ 40,056 COBRA 29 - - - Personnel Services Total $ 325,013 $ 340,080 $ 380,136 $ 40,056 SERVICES AND CHARGES: Community Volunteer Services $ 15,000 $ 15,750 $ 15,750 $ - Youth Service Bureau 32,000 35,000 35,000 - Fire Relief Association 162,719 165,000 165,000 - Other 2,430 5,000 5,000 - Total Services and Charges $ 212,149 $ 220,750 $ 220,750 $ - MISCELLANEOUS: Contribution to St Croix Valley Athletic Association $ - $ 20,000 $ 20,000 $ - Other 47,799 31,865 31,865 - Total Miscellaneous $ 47,799 $ 51,865 51,865 $ - Total Expenditures $ 584,961 $ 612,695 $ 652,751 $ 40,056 57 n u L n t ~I~, Special Revenue Funds Special Revenue Funds are used by the City to account for revenues derived from specific revenue sources. They are usually required by state statute, charter provisions, or local ordinance to finance particular functions or activities of government. 7 CITY OF STILLWATER, MINNESOTA SPECIAL REVENUE FUNDS SUMMARY OF REVENUES AND EXPENDITURES REVENUES: Licenses & Permits Intergovernmental Charges for Services Interest Earnings Miscellaneous Revenue Totals EXPENDITURES: Public Safety DARE Public Works Washington County Recycling Grant Culture 8~ Recreation Special Events St Croix Valley Recreation Center Library Parks Culture & Recreation Total Total Expenditures 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) $ 972 $ 1,000 $ 1,500 $ 500 36,926 30,000 33,378 3,378 1,287,447 1,254,900 1,366,500 111,600 25,824 20,000 25,000 5,000 182,048 356,800 173,217 (183,583) $ 1,533,217 $ 1,662,700 $ 1,599,595 $ (63,105) $ 2,306 $ 4,500 $ 3,000 $ (1,500) $ 23,465 $ 30,000 $ 33,378 $ 3,378 $ 48,423 $ 60,000 $ 62,500 $ 2,500 1,077,870 1,259,385 1,346,341 86,956 952,512 1,277,497 1,116,475 (161,022) 997,635 1,636,272 1,671,252 34,980 $ 3,076,440 $ 4,233,154 $ 4,196,568 $ (36,586) $ 3,102,211 $ 4,267,654 $ 4,232,946 $ (34,708) Revenues over (under) Expenditures $ (1,568,994) $ (2,604,954) $ (2,633,351) $ (28,397) Other Financing Sources (Uses): Transfers in $ 1,908,852 $ 2,887,769 $ 2,946,227 $ 58,458 Transfers (out) (187,406) (282,815} (312,876) (30,061) Other Financing Sources (Uses) Total $ 1,721,446 $ 2,604,954 $ 2,633,351 $ 28,397 Net increase in fund balance $ 152,452 $ - $ - $ - Fund Balance -Jan 1 1,193,957 1,346,409 1,346,409 - Fund Balance -Dec 31 $ " „;? ~~ ,~~?~ $ 1,346,409 $ 1,346,409 $ - 61 CITY OF STILLWATER, MINNESOTA SPECIAL EVENTS Fund Type: Special Revenue Fund Fund Number: 200 Fund Description: The Special Events Fund accounts for special events held within the City. Funding: Primarily financed with donations, reimbursement of services and a transfer (operating) from the General Fund. 2007 Budget Impacts: - Policing services are services provided by outside Police Departments for major events held within the City limits. These services are sometime reimbursed by the event holders. - Fireworks consists of a City contribution of $15,000 and contributions from other sources of $10,000. - Contribution is a contribution to the Art Reach program. 62 CITY OF STILLWATER, MINNESOTA SPECIAL EVENTS Fund Type: Special Revenue Fund Fund Number: 200 SUMMARY OF REVENUES AND EXPENDITURES REVENUES: Miscellaneous: Donations Refunds & Reimbursements Revenue Total EXPENDITURES: Services and Charges: Policing/Fire Services Other Services and Charges Total Miscellaneous: Fireworks Contributions Miscellaneous Total Total Expenditures Revenues over (under) expenditures Other Financing Sources Transfer In: General Fund Net increase in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) $ 10,000 $ 10,000 $ 20,690 32,500 _ $ 30,690 $ 42,500 $ 10,000 $ 35,000 _ 45,000 $ 2,500 $ 20,684 $ 32,500 $ 35,000 $ 2,500 739 500 500 - $ 21,423 $ 33,000 $ 35,500 $ 2,500 $ 25,000 $ 25,000 $ 25,000 $ - 2,000 2,000 2,000 - $ 27,000 $ 27,000 $ 27,000 $ - $ 48,423 $ 60,000 $ 62,500 $ 2,500 $ (17,733) $ (17,500) $ (17,500) $ - $ 17,750 $ 17,500 $ 17,500 $ - 4,765 4,782 4,782 $ - $ 4,782 $ 4,782 $ 4,782 $ - 2,500 63 CITY OF STILLWATER, MINNESOTA ST CROIX VALLEY .RECREATION CENTER Fund Type: Special Revenue Fund Fund Number: 202 Fund Description: The St. Croix Valley Recreation Center provides recreational opportunities for all ages and skill levels to participate in various indoor recreational activities, such as ice skating, hockey and walking. The City contracts with an outside vendor to staff and manage the complex. Funding: Financing is provided by the fees generated by the facility. Capital Outlay purchases are financed with General Obligation Capital Outlay Bonds. 2006 Budget Impacts: - All donations and net revenues (revenues less expenditures) are transferred out to the Recreation Center's debt service funds ($2,135,000 GO Rev Bonds, Series 2000D and $2,695,000 GO Rev Bonds, Series 2005C). - On July 18, 2006 the City Council approved a rate increase at the Recreation Center as follows: $5 per hour for ice time, $10 per hour for field house rental, & $1 per hour increase for open skate/open field house. These rates continue to keep the rates at or below the fees charged by other communities in the area for similar facilities. This increase in rates is reflected within the revenue classification of Charges for Services . - Capital Outlay-Improvements includes $60,000 for the purchase of new turf for the field house in 2010. It is estimated that the new turf will cost $300,000. $60,000 was also budgeted and set in reserves in 2006. An additional $60,000 will be budgeted for 2008, 2009 and 2010. 64 ~'~ i~ n CITY OF STILLWATER, MINNESOTA ST CROIX VALLEY REC CENTER hund Type: Special Revenue Fund Fund Number: 202 2006 2007 SUMMARY OF REVENUES 2005 AMENDED ADOPTED $ Increase AND EXPENDITURES ACTUAL BUDGET BUDGET (Decrease) REVENUES: Charges for Service: Charges for Service $ 1,274,040 $ 1,244,400 $ 1,350,500 $ 106,100 Interest Earnings 25,824 20,000 25,000 5,000 Donations 68,382 68,000 62,717 (5,283) Revenue Total $ 1,368,246 $ 1,332,400 $ 1,438,217 $ 105,817 EXPENDITURES: St Croix Vallev Rec Center Supplies Services & Charges Miscellaneous Capital Outlay Rec Center Total St Croix Vallev Fieldhouse Supplies Services & Charges Miscellaneous Capital Outlay Fieldhouse Total Lilt/ Lake Ice Arena Supplies Services & Charges Miscellaneous Capital Outlay Lily Lake Ice Arena Total Total Expenditures Revenues over (under) expenditures Other Financing Sources (Uses) Transfer In Capital Outlay Bond Proceeds Transfer (Out) Debt Service Other Financing Sources (Uses) Total Net increase in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 $ 121,875 $ 100,500 $ 112,500 $ 12,000 535,176 552,173 572,126 19,953 6,679 18,500 18,500 - 23,430 9,800 21,000 11,200 $ 687,160 $ 680,973 $ 724,126 $ 43,153 $ 4,065 $ 6,200 $ 6,200 $ - 186,225 226,224 239,950 13,726 2,406 3,100 3,200 100 29,675 60,000 60,000 - $ 222,371 $ 295,524 $ 309,350 $ 13,826 $ 8,458 $ 8,700 $ 9,700 $ 1,000 159,881 133,088 162,015 28,927 - 1,100 1,150 50 - 140,000 140,000 - $ 168,339 $ 282,888 $ 312,865 $ 29,977 $ 1,077,870 $ 1,259,385 $ 1,346,341 $ 86,956 $ 290,376 $ 73,015 $ 91,876 $ 18,861 $ 23,430 $ 209,800 $ 221,000 $ 11,200 (187,406) (282,815) (312,876) (30,061) $ (163,976) $ (73,015) $ (91,876) $ (18,861) $ 126,400 $ - $ - $ - 809,254 935,654 935,654 - $ 935,654 $ 935,654 $ 935,654 $ - 65 CITY OF STILLWATER, MINNESOTA LIBRARY Fund Type: Special Revenue Fund Fund Number: 230 Fund Description: The Stillwater Public Library provides a wide variety of library services to the City's residents and surrounding communities. This fund accounts for service operations of the library and the maintenance of the library building. 2007 Staffing Level: Full Time 4.2 FTE (Full Time Equivalents) Part Time (Benefited) 6.5 FTE (Full Time Equivalents) Part Time (Non-Benefited) 14.0 Number of Positions Funding: Primarily funded by a transfer (operating) from the General Fund. Capital Outlay purchases are financed primarily with General Obligation Capital Outlay Bonds. 2007 Budget Impacts: - in 2006, the City issued a Capital Outlay bond for the remodeling/renovation of the current library building. Construction began in 2005, using contributions from outside sources to fund a portion of the construction costs. Construction was completed in September 2006. Increased operating costs have been reflected in this budget. - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan. - Personnel includes 20% of an additional full-time position. The remaining 80% is allocated to the MIS department of the General Fund. Cost for this position, wages and benefits, for this department is $11,687. 66 f r CITY OF STILLWATER, MINNESOTA LIBRARY Fund Type: Special Revenue Fund Fund Number: 230 2006 2007 SUMMARY OF REVENUES 2005 AMENDED ADOPTED $ Increase AND EXPENDITURES ACTUAL BUDGET BUDGET (Decrease) REVENUES: Charges for Service $ 4,576 $ - $ 4,000 $ 4,000 Donations 198 200,000 25,000 (175,000) Miscellaneous 8,740 30,000 28,000 (2,000) Revenue Total $ 13,514 $ 230,000 $ 57,000 $ (173,000) EXPENDITURES: Operations: Personnel Services $ 629,501 $ 669,861 $ 732,208 $ 62,347 Supplies 106,186 111,300 118,560 7,260 Services & Charges 48,016 40,476 34,239 (6,237) Miscellaneous 2,980 3,025 3,350 325 Capital Outlay 62,896 291,800 50,000 (241,800) Operations Total $ 849,579 $ 1,116,462 $ 938,357 $ (178,105) Plant Personnel Services $ 39,400 $ 57,541 $ 77,518 $ 19,977 Supplies 2,873 5,200 7,550 2,350 Services 8~ Charges 59,095 67,044 91,050 24,006 Miscellaneous 1,565 2,000 2,000 - CapitalOutlay - 29,250 - (29,250) Plant Total $ 102,933 $ 161,035 $ 178,118 $ 17,083 Total Expenditures $ 952,512 $ 1,277,497 $ 1,116,475 $ (161,022) Revenues over (under) expenditures $ (938,998) $ (1,047,497} $ (1,059,475) $ (11,978) Other Financing Sources Transfer In: General Fund $ 883,901 $ 926,447 $ 1,009,475 $ 83,028 Capital Outlay Bond Proceeds 60,656 121,050 50,000 (71,050) Sale of Property 85 - - - Other Financing Sources Total $ 944,642 $ 1,047,497 $ 1,059,475 $ 11,978 Net increase in fund balance $ 5,644 $ - $ - $ - Fund Balance -Jan 1 44,223 49,867 49,867 - Fund Balance -Dec 31 $ 49,867 $ 49,867 $ 49,867 $ - 67 CITY OF STILLWATER, MINNESOTA PARKS Fund Type: Special Revenue Fund Fund Number: 244 Fund Description: The Parks Department/Fund provides for maintenance of City owned parks. cuur atamng ~evei: Full Time 7.5 FTE (Full Time Equivalents) Part Time (Seasonal) 3.0 Number of Positions Funding: Primarily funded by a transfer (operating} from the General Fund. Capital Outlay purchases are financed with General Obligation Capital Outlay Bonds. 2007 Budget Impacts: - Park Fees include $1,000 in additional revenue for Teddy Bear Park. - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan. - Full-Time Overtime includes an additional $3,000 for Teddy Bear Park cleanup. - Contractual includes weed control services for $27,000 and forester services for $7,000. - Tree Removal is for the removal of trees due to Dutch Elm & Oak W ilt diseases. - Misc Charges-Teddy Bear Park are additional expenditures estimated to be needed for Teddy Bear Park. Actual type of expenditures is unknown due to lack of historical data. ~i 68 CITY OF STILLWATER, MINNESOTA PARKS ' Fund Type: Special Revenue Fund Fund Number: 240 SUMMARY OF REVENUES AND EXPENDITURES REVENUES: Licenses and Permits Charges for Service Miscellaneous Revenue Total EXPENDITURES: Personnel Services: Salaries -Full Time Salaries -Part Time Benefits Personnel Services Total Supplies: Services and Charges: Contractual Services Tree Removal Other Total Service and Charges Miscellaneous: Capital Outlay: Land Improvements Machinery & Equipment Computer Equipment Automotive Equipment Capital Outlay Total Total Expenditures Revenues over (under) expenditures Other Financing Sources Transfer In: General Fund Capital Outlay Bond Proceeds Sale of Property Other Financing Sources Total Net increase in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 2006 2005 AMENDED ACTUAL BUDGET $ 972 $ 1,000 $ 8,831 10,500 72,277 15,300 _ $ 82,080 $ 26,800 $ 2007 ADOPTED $ Increase BUDGET (Decrease) 1,500 $ 500 12,000 1,500 12,000 (3,300) 25,500 $ (1,300) $ 281,402 $ 356,674 $ 372,051 $ 15,377 8,203 21,200 21,700 500 150,742 105,676 116,686 11,010 $ 440,347 $ 483,550 $ 510,437 $ 26,887 $ 55,251 $ 55,900 $ 60,200 $ 4,300 $ 5,156 $ 30,000 $ 34,000 $ (4,000) $ 3,406 20,000 15,000 5,000 96,391 86,052 96,127 (10,075) $ 104,953 $ 136,052 $ 145,127 $ (9,075) $ 44,715 $ 5,300 $ 25,300 $ 20,000 $ - $ 200,000 $ - $ 221,327 723,670 877,688 85,655 30,000 25,000 - 1,800 2,500 45,387 - 25,000 _ $ 352,369 $ 955,470 $ 930,188 $ (200,000) 154,018 (5,000) 700 25,000 (25,282) $ 997,635 $ 1,636,272 $ 1,671,252 $ $ (915,555) $ (1,609,472) $ (1,645,752) $ $ 919,030 $ 1,609,472 $ 715,564 $ - - 930,188 3,848 - - _ $ 922,878 $ 1,609,472 $ 1,645,752 $ $ 7,323 $ - $ - $ 268,878 276,201 276,201 _ $ 276,201 $ 276,201 $ 276,201 $ 25,905 (27,205) (893,908) 930,188 36,280 69 CITY OF STILLWATER, MINNESOTA WASHINGTON CO RECYCLING GRANT Fund Type: Special Revenue Fund Fund Number: 255 Fund Description: The Washington County Recycling Grant Fund accounts for the recycling grants received from Washington County. The funds from this grant can only be used for purposes specified by the grant agreement. Funding: Funded exclusively with grant funds received from Washington County and interest earned on investments (the fund's prorated share). 2007 Budget Impacts: - Services and Charges-Other costs include updating the Resident Recycling Guide. 70 CITY OF STILLWATER, MINNESOTA WASHINGTON CO RECYCLING GRANT Fund Type: Special Revenue Fund Fund Number: 255 2006 2007 SUMMARY OF REVENUES 2005 AMENDED ADOPTED $ Increase AND EXPENDITURES ACTUAL BUDGET BUDGET (Decrease) REVENUES: Miscellaneous: Intergovernmental Interest Revenue Total EXPENDITURES: Services and Charges: Miscellaneous: Total Expenditures Net increase in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 $ 36,926 $ 30,000 $ 33,378 $ 3,378 1, 587 - - - $ 38,513 $ 30,000 $ 33,378 $ 3,378 $ 9,745 $ 12,075 $ 10,700 $ (1,375) $ 13,720 $ 17,925 $ 22,678 $ 4,753 $ 23,465 $ 30,000 $ 33,378 $ 3,378 $ 15,048 $ - $ - $ - 58,174 73,222 73,222 - $ 73,222 $ 73,222 $ 73,222 $ - 71 CITY OF STILLWATER, MINNESOTA D 1~ 1~.L' Fund Type: Special Revenue Fund Fund Number: 263 Fund Description: The DARE Fund accounts all receipts and expenditures associated with the drug awareness program Pursuant to State mandate, funds received for this program are used exclusively for this program. Funding: Funding is provided by donations and a contribution from the General Fund. 72 CITY OF STILLWATER, MINNESOTA DARE Fund Type: Special Revenue Fund Fund Number: 263 SUMMARY OF REVENUES AND EXPENDITURES REVENUES: Miscellaneous: Donations Interest Revenue Total EXPENDITURES: Supplies: Revenues Over (Under) Expenditures Other Financing Sources Transfer In: General Fund Net increase in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) $ - $ 1,000 $ 500 $ (500) 174 - - - $ 174 $ 1,000 $ 500 $ (500) $ 2,306 $ 4,500 $ 3,000 $ (1,500) $ (2,132) $ (3,500) $ (2,500) $ 1,000 $ 4,000 $ 3,500 $ 2,500 $ (1,000) $ 1,868 $ - $ - $ - 8,663 10,531 10,531 - $ 10,531 $ 10,531 $ 10,531 $ - 73 THIS PAGE INTENTIALLY LEFT BLANK u ~ Debt Service ~ Funds i Debt Service Funds are used by the City to account for the accumulation of resources and ' the payment of general obligation debt and other long-term debt. 1.1 I T Ut J 1 ILLWA I thC, MINNtJV I A LEVY OBLIGATIONS Debt Service Levy Obligations $4,000,000 ------ _..__._ _~.~_~ $3,500,000 - w, $3,000,000 -- -- _._. - - ---- C ~ $2,500,000 -- Q $2,000,000 _- - --- ---- $1,500,000 _ - _ _ - --_ - _ ------ - - -_ _.. ---_ J $1,000,000 --- $500,000 ---- ---- $0 2007 2009 2011 2013 2015 2017 2019 2021 2023 2025 Budget Year The above graph shows the amount of debt service required to be levied for each budget year beginning with 2007. The amount of levy can be reduced or "cancelled" if there are sufficient funds available to pay the required debt service. Year Capital Outlay Bonds Revenue Bonds Improvement Bonds Total 2007 $2,678,790 $547,538 $293,805 $3,520,133 2008 $2,602,553 $525,357 $297,447 $3,425,357 2009 $2,382,456 $529,247 $299,829 $3,211,532 2010 $2,350,693 $532,252 $300,920 $3,183,865 2011 $2,127,645 $534,202 $295,832 $2,957,679 2012 $1,671,868 $424,626 $300,456 $2,396,950 2013 $1,430,376 $422,575 $298,696 $2,151,647 2014 $1,199,993 $419,729 $301,398 $1,921,120 2015 $1,186,320 $431,773 $303,109 $1,921,202 2016 $1,176,864 $437,141 $298,761 $1,912,766 2017 $1,160,627 $436,127 $0 $1,596,754 2018 $1,153,834 $439,233 $0 $1,593,067 2019 $1,024,469 $189,033 $0 $1,213,502 2020 $1,004,118 $0 $0 $1,004,118 2021 $714,522 $0 $0 $714,522 2022 $387,450 $0 $0 $387,450 2023 $389,970 $0 $0 $389,970 2024 $391,860 $0 $0 $391,860 2025 $393,120 $0 $0 $393,120 Note: The above levy amounts do not include amounts for any anticipated 2007 bond issues. 76 CITY OF STILLWATER, MINNESOTA DEBT SERVICE FUNDS SUMMARY OF REVENUES AND EXPENDITURES REVENUES: Property Taxes Special Assessments: Market Value Homestead Credit Interest Miscellaneous Revenue Total EXPENDITURES: Debt Service: Principal Interest Paying Agent Fees Bond Issuance Fees Professional Services Other Expenditure Total Revenues over expenditures Other Financing Sources Bond Proceeds Transfer In Transfer Out Other Financing Sources Total Net increase in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) $ 2,650,171 $ 3,545,762 $ 3,284,439 $ (261,323) 565,939 367,000 265,000 (102,000) 144,453 - - - 143,533 - - - - 405 405 - $ 3,504,096 $ 3,912,762 $ 3,549,844 $ (363,323} $ 3,898,534 $ 8,736,000 $ 3,925,000 $ (4,811,000) 1, 345, 239 1, 035, 725 1,230, 685 194, 960 6,482 6,740 7,273 533 73,610 - - - 5, 765 - - - 73,745 - - - $ 5,403,375 $ 9,778,465 $ 5,162,958 $ (4,615,507) $ (1,899,279) $ (5,865,703) $ (1,613,114) $ 4,252,184 $ 5,871,691 $ 6,400,000 $ - $ (6,400,000) 1,548,580 1,064,930 1,548,478 483,548 (117,370) - - - $ 7,302,901 $ 7,464,930 $ 1,548,478 $ (5,916,452) $ 5,403,622 $ 1,599,227 $ (64,636) $ (1,663,863) 5,970,718 11,374,340 12,973,567 1,599,227 $ 11,374,340 $ 12,973,567 $ 12,908,931 $ (64,636). 77 CITY OF STILLWATER, MINNESOTA GO CAPITAL OUTLAY BONDS Fund Type: Debt Service Funds Fund Numbers: 300 - 329 Funds Description: These funds record the receipt of property taxes generated by the debt service levy and the payment of ~. principal, interest and paying agent fees for outstanding General Obligation Capital Outlay Bonds (GO CO Bonds issued by the City. Funding: Primarily financed with property taxes through an annual debt service levy. 2007 Budget Impacts: Fund Number Bond Issue Balance as of 12/31/06 Principal Due in 2007 Interest Due in 2007 Levy Amount for Payable 2007 Existing Debt: 303 $200,000 GO CO Bonds, Series 2003HS $80,000 $30,000 $2,400 Cancelled 304 $755,000 GO CO Bonds, Series 2004B $550,000 $85,000 $13,275 $102,296 305 $1,480,000 GO CO Bonds, Series 2005A $1,345,000 $180,000 $38,275 $226,354 315 $3,160,000 GO CO Bonds, Series 20056 $3,160,000 $260,000 $100,973 $281,109 316 $6,400,000 GO CO Bonds, Series 2006A $6,400,000 $410,000 $236,580 $581,587 320 $1,345,000 GO CO Bonds, Series 2003A $870,000 $165,000 $23,300 $195,549 321 $260,000 GO CO Bonds, Series 2005MZ $169,000 $100,000 $10,000 $115,500 323 $7,840,000 GO CO Bonds, Series 2002A $6,175,000 $525,000 $259,276 $818,404 324 $990,000 GO CO Bonds, Series 2000C $385,000 $90,000 $17,348 $115,815 328 $2,500,000 GO CO Bonds, Series 19986 $1,365,000 $100,000 $58,518 $169,358 New Debt: 307 GO Bonds of 2007 $30,000 $225,000 Totals $1,945,000 $789,945 $2,830,972 Notes: - General Obligation Bonds are backed with the full faith and credit, and taxing power of the City. - Fund balance is reserved for debt service payments, both current and future. 78 CITY OF STILLWATER, MINNESOTA GO CAPITAL OUTLAY BONDS Fund Type: Debt Service Funds Fund Numbers: 300 - 329 2006 2007 SUMMARY OF REVENUES 2005 AMENDED ADOPTED $ Increase AND EXPENDITURES ACTUAL BUDGET BUDGET (Decrease) REVENUES: Property Taxes: Current $ 2,037,593 $ 2,803,424 $ 2,830,972 $ 27,548 Delinquent 31,653 - - - Market Value Homestead Credit 112,728 - - - Interest 32,857 - - - Revenue Total $ 2,214,831 $ 2,803,424 $ 2,830,972 $ 27,548 EXPENDITURES: Debt Service: Principal Interest Paying Agent Fees Bond Issuance Fees Professional Services Other Expenditure Total Revenues over expenditures Other Financing Sources/Uses Bond Proceeds Premium Issued on Debt Transfer In Transfer Out Other Financing Sources Total Net increase in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 $ 1,755,000 $ 4,311,000 $ 1,945,000 $ (2,366,000) 696,964 543,624 789,945 246,321 3,035 3,020 4,106 1,086 73,610 - - - 1,815 - - - 3,867 - - - $ 2,534,291 $ 4,857,644 $ 2,739,051 $ (2,118,593) $ (319,460) $ (2,054,220) $ 91,921 $ 2,146,141 $ 3,171,848 $ 6,400,000 $ - $ (6,400,000) 1,655 - - - 89,554 131,600 32,400 (99,200) (38,550) - - - $ 3,224,507 $ 6,531,600 $ 32,400 $ (6,499,200) $ 2,905,047 $ 4,477,380 $ 124,321 $ (4,353,059) 2,485,953 5,391,000 9,868,380 4,477,380 $ 5,391,000 $ 9,868,380 $ 9,992,701 $ 124,321 79 CITY OF STILLWATER, MINNESOTA GO IMPROVEMENT BONDS Fund Type: Debt Service Funds Fund Numbers: 330 - 359 Funds Description: These funds record the receipt of special assessment payments, property taxes and the payment of principal, interest and paying agent fees for outstanding General Obligation Improvement Bonds (GO Imp Bonds) issued by the City. Funding: Primarily financed with special assessments and property taxes when necessary. 2007 Budget Impacts: Fund Number Bond Issue Balance as of 12/31/06 Principal Due in 2007 Interest Due in 2007 Levy Amount for Payable 2007 Existing Debt: 339 $1,390,000 GO Im Bonds, Series 2000A $515,000 $135,000 $22,654 N/A 340 $4,695,000 GO Imp Bonds, Series 2004A $4,205,000 $360,000 $123,910 $293,805 Totals $495,000 $146,564 $293,805 Notes: - General Obligation Bonds are backed with the full faith and credit, and taxing power of the City. - Fund balance is reserved for debt service payments, both current and future. 80 i~ i~ CITY OF STILLWATER, MINNESOTA GO IMPROVEMENT BONDS ' Fund Type: Debt Service Funds Fund Numbers: 330 - 359 SUMMARY OF REVENUES AND EXPENDITURES REVENUES: Property Taxes Special Assessments: Current Delinquent Prepayments Market Value Homestead Credit Interest Revenue Total EXPENDITURES: Debt Service: Principal Interest Paying Agent Fees Professional Services Other Expenditure Total OTHER FINANCING SOURCES Operating Transfer In (out) Net increase in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) $ 283,390 $ 295,034 $ 293,805 $ (1,229) 532,537 367,000 265,000 (102,000} 9,627 - - - 23,775 - - - 15,518 - - - 28,206 - - - $ 893,053 $ 662,034 $ 558,805 $ (103,229) $ 490,000 $ 595,000 $ 495,000 $ (100,000) 189,079 170,317 146,564 (23,753) 806 1,055 806 (249) 3,950 - - - 4,166 - - - $ 688,001 $ 766,372 $ 642,370 $ (124,002) $ 33,928 $ - $ - $ - $ 238,980 $ (104,338} $ (83,565) $ 20,773 1,381,332 1,620,312 1,515,974 (104,338) $ 1,620,312 $ 1,515,974 $ 1,432,409 $ (83,565) i ~ a, CITY OF STILLWATER, MINNESOTA GO TIF BONDS Fund Type: Debt Service Funds Fund Numbers: 360 - 379 Funds Description: These funds record the receipt of tax increment and the payment of principal, interest and paying agent fees for outstanding General Obligation Tax Increment Financing Bonds (GO TIF Bonds) issued by the City. Funding: Primarily financed with tax increment transferred in from the obligating TIF District. 2007 Budget Impacts: Fund Number Bond Issue TIF District Obligation Balance as of 12/31/06 Principal Due in 2007 Interest Due in 2007 Existing Debt: 360 $2,265,000 GO TIF Bonds, Series 2000E TIF #1 $425,000 $425,000 $9,881 366 $1,000,000 GO TIF Bonds, Series 1993A TIF #6 $105,000 $105,000 $2,678 374 $3,435,000 GO TIF Bonds, Series 2003B TIF #4 $2,490,000 $320,000 $69,493 Totals $850,000 $82,052 Notes: - General Obligation Bonds are backed with the full faith and credit, and taxing power of the City. - Fund balance is reserved for debt service payments, both current and future. 82 CITY OF STILLWATER, MINNESOTA GO TIF BoNns Fund Type: Debt Service Funds Fund Numbers: 360 - 379 SUMMARY OF REVENUES 2005 AND EXPENDITURES ACTUAL REVENUES: Interest EXPENDITURES: Debt Service: Principal Interest Paying Agent Fees Other Expenditure Total Revenues Over (Under) Expenditures Other Financing Sources Transfer In Transfer Out Other Financing Sources Totals Net increase in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 2006 AMENDED BUDGET 2007 ADOPTED BUDGET $ 8,175 $ - $ $ Increase (Decrease) - $ - $ 905,000 $ 820,000 $ 850,000 $ 30,000 142,570 112,225 82,052 (30,173) 1,085 1,105 1,150 45 1,142 - - - $ 1,049,797 $ 933,330 $ 933,202 $ (128) $ (1,041,622) $ (933,330) $ (933,202) $ 128 $ 937,158 $ 933,330 $ 933,202 $ (128) (78,820) - - - $ 858,338 $ 933,330 $ 933,202 $ (128) $ (183,284) $ - $ - $ - 1,153,730 970,446 970,446 - $ 970,446 $ 970,446 $ 970,446 $ - 83 CITY OF STILLWATER, MINNESOTA GO REVENUE BONDS Fund Type: Debt Service Funds Fund Numbers: 380 - 389 Funds Description: These funds record the revenues received and the payment of principal, interest and paying agent fees for outstanding General Obligation Revenue Bonds (GO Rev Bonds) issued by the City. Funding: $2,135,000 GO Rev Bonds, Series 20000 Funding is provided by donations and net revenues (revenues less expenditures) from St Croix Valley Recreation Center operations and property taxes (when needed). 2,695,000 GO Rev Bonds, Series 2005C This bond issue is a refunding bond of the $4,610,000 GO Revenue Bonds, Series 1998A. Funding is provided by donations and net revenues (revenues less expenditures) from the St. Croix Valley Recreation Center operations, tax increment from TIF District #4 and property taxes (when needed). 2007 Budget Impacts: Fund Number Bond Issue Balance as of 12/31/06 Principal Due in 2007 Interest Due in 2007 Levy Amount for Payable 2007 Existing Debt: 381 $2,135,000 GO Rev Bonds, Series 20000 $1,755,000 $90,000 $92,908 Cancelled 385 $2,695,000 GO Rev Bonds, Series 2005C $2,695,000 $260,000 $79,808 $159,662 Totals $350,000 $172,716 $159,662 Other Debt: The following bond issue was issued by the City for Board of Water Commissioners. For that reason, accounting of the bond issue is found in the financial statement of the Board of Water Commissioners. Presentation of this bond issue appears here only for informational purposes. Fund Number Bond Issue Balance as of 12/31/06 Principal Due in 2007 Interest Due in 2007 Levy Amount for Payable 2007 380 $1,330,000 GO Rev Bonds, Series 20006 $790,000 $90,000 $39,408 N/A Funding: X1,330,000 GO Rev Bonds, Series 20006 This bond issue was issued by the City for the Board of Water Commission (City's Component Unit). Funding is provided by the Board of Water Commission through water user fees. Notes: ', -General Obligation Bonds are backed with the full faith and credit, and taxing power of the City. - Fund balance is reserved for debt service payments, both current and future. 7 J C 0 0 u u 84 ' CITY OF STILLWATER, MINNESOTA GO REVENUE BONDS Fund Type: Debt Service Funds Fund Numbers: 380 - 389 2006 2007 SUMMARY OF REVENUES 2005 AMENDED ADOPTED $ Increase AND EXPENDITURES ACTUAL BUDGET BUDGET (Decrease) REVENUES: Property Taxes: Current $ 293,076 $ 447,304 $ 159,662 $ (287,642) Delinquent 4,459 - - - Market Value Homestead Credit 16,207 - - - Interest 74,295 - - - Miscellaneous - 405 405 - Revenue Totals $ 388,037 $ 447,709 $ 160,067 $ (287,642) EXPENDITURES: Debt Service: Principal $ 330,000 $ 2,815,000 $ 440,000 $ (2,375,000) Interest 305,963 209,559 212,124 2,565 Paying Agent Fees 1,556 1,560 1,211 (349) Other 64,570 - - - Expenditure Total $ 702,089 $ 3,026,119 $ 653,335 $ (2,372,784) Revenues Over (Under) Expenditures $ (314,052) $ (2,578,410) $ (493,268) $ 2,085,142 Other Financing Sources: Transfers In: St Croix Valley Recreation Center $ 187,406 $ 282,815 $ 312,876 $ 30,061 TIF District #4 75,000 75,000 75,000 - Bond Proceeds 2,695,000 - - - Premium Issued on Debt 3,188 - - - Other Financing Sources Total $ 2,960,594 $ 357,815 $ 387,876 $ 30,061 Net increase in fund balance $ 2,646,542 $ (2,220,595) $ (105,392) $ 2,115,203 Fund Balance -Jan 1 746,040 3,392,582 1,171,987 (2,220,595) Fund Balance -Dec 31 $ 3,392,582 $ 1,171,987 $ 1,066,595 $ (105,392) 85 CITY OF STILLWATER, MINNESOTA OTHER LONG-TERM DEBT Fund Type: Debt Service Funds Fund Numbers: 390 - 399 Funds Description: These funds record the revenues received and the payment of principal and interest for other outstanding long-term debt issued by the City. Funding: $1,100,000 Stafe Stream Protection and Improvement Loan Funding is provided by impact fees paid by developers who develop in the annexation area benefiting from the Trout Stream Mitigation Project. $850,000 State Stream Protection and Improvement Loan Funding is provided by impact fees paid by developers who develop in the annexation area benefiting from the Trout Stream Mitigation Project. 2007 Budget Impacts: Fund Number Bond Issue Balance as of 12/31/06 Principal Due in 2007 Interest Due in 2007 Existing Debt: 390 $1,100,000 State Stream Protection & Imp Loan $495,000 $110,000 $0 390 $850,000 State Stream Protection & Imp Loan $552,500 $85,000 $0 Totals $195,000 $0 Notes: - Fund balance is reserved for debt service payments, both current and future. t J 86 CITY OF STILLWATER, MINNESOTA OTHER LONG-TERM DEBT Fund Type: Debt Service Funds Fund Numbers: 390 - 399 2006 2007 SUMMARY OF REVENUES 2005 AMENDED ADOPTED $ Increase AND EXPENDITURES ACTUAL BUDGET BUDGET (Decrease) REVENUES: Interest $ - $ - $ - $ - EXPENDITURES: Debt Service: Principal $ 418,534 $ 195,000 $ 195,000 $ - Interest 10,663 - - - Expenditure Total $ 429,197 $ 195,000 $ 195,000 $ - Revenues Over (Under) Expenditures $ (429,197) $ (195,000) $ (195,000) $ - Other Financing Sources: Transfers In: Permanent Improvement Fund $ 225,534 $ 195,000 $ 195,000 $ - Net increase in fund balance $ (203,663) $ - $ - $ - Fund Balance -Jan 1 203,663 - - - Fund Balance -Dec 31 $ - $ - $ - $ - 87 THIS PAGE INTENTIALLY LEFT BLANK r 1 r Capital Project Funds Capital Project Funds are used by the City to account fior the construction/acquisition of capital projects within the City's Tax Increment Financing Districts. THIS PAGE INTENTIALLY LEFT BLANK CITY OF STILLWATER, MINNESOTA CAPITAL PROJECT FUNDS SUMMARY OF REVENUES AND EXPENDITURES REVENUES: Tax Increment Market Value Homestead Credit Charges for Services Interest Other Revenue Total EXPENDITURES: Contractual Professional Services Legal Interest on Notes Other Expenditure Total Revenues over (under) expenditures Other Financing Uses Transfer Out Net increase (decrease) in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) $ 1,623,139 $ 2,170,000 $ 2,117,000 $ (53,000) 9,554 - - - (51,252) - - - 47,522 - - - 6,881 - - - $ 1,635,844 $ 2,170,000 $ 2,117,000 $ (53,000) $ 1,245,610 $ 393,400 $ 309,406 $ (83,994) 71,727 - - - 25,088 - - - 62,986 62,460 61,394 (1,066) 18,555 146,300 334,293 187,993 $ 1,423,966 $ 602,160 $ 705,093 $ 102,933 $ 211,878 $ 1,567,840 $ 1,411,907 $ (155,933) $ (934,688) $ (1,008,330) $ (1,008,202) $ 128 $ (722,810) $ 559,510 $ 403,705 $ (155,805) 2,171,474 1,448,664 2,008,174 559,510 $ 1,448,664 $ 2,008,174 $ 2,411,879 $ 403,705 91 CITY OF STILLWATER, MINNESOTA TIF DISTRICT #1 Fund Type: Capital Project Fund Fund Number: 461 Fund Description: The City is the administering authority for Development District #1, Tax Increment District #1, Downtown and Industrial Park Scattered Sites (TIF District #1). The district is a redevelopment district established in 1985 and has a 25-year duration upon the receipt of the first tax increment. 1986 was the date of the first tax increment receipt. December 31, 2011 is the required date of decertification. Debt Obligation: $2,265,000 General Obligation Tax Increment Refunding Bond, Series 2000E (Original issue: $3,400,000 General Obligation Tax Increment Bond, Series 1991 C). This debt obligation was issued to fund public improvements in the downtown. These improvements included: (1) Storm sewer separation -separate roof leaders and springs from the sanitary sewer system; (2) Rebuild the collapsed sanitary sewer main; (3) Street improvements -curb, gutter, sidewalk; (4) Move electrical utilities underground; (5) Street lights; and, (6) Install pressure stubs for fire fighting. Total amount outstanding as of December 31, 2006: $425,000 (see page 82 for more information on the debt service obligation). 2007 Budget Impacts: - Transfer Out represents funds transferred to $2,265,000 Tax Increment Refunding Bond, Series 2005 debt service fund for payment of current year debt service obligations. Projects/Pay-as-you-go Obligations within this district are as follows: Development Property 1st Scheduled Payment Date Duration of Payments Available Tax Increment* Not to Exceed a Payment of Maximum Total Obligation Payments to Date Expected 2007 Payment ABS Com an 1998 Life of District 50% N/A $71,968 $29,998 $4,200 Biici~field Deveiopment `~~ ;` Life of District 100% NSA ~t~33,489 $133,48) $0' Desch - Phase I 1992 2007 100% $20,000 $562,139 $433,202 $20,000 Lumber Baron Hotel 2003 Life of District 50% N/A $835,000 $23,435 $2,000 Mainstream 2001 2011 100% $37,500 $787,800 $228,033 $40,000 Readex 1997 2010 100% $8,600 $172,000 $103,599 $9,000 Schoonover 19 9 ;~ 2 0 0 3 1 0 0°i6 11,917 $ ~~^:43, 0 0 0 $7 2 ,5 05 $ 0 y~i E.In~'t ~ p 1 3~ iY P , p 2003 ~1 1qp BtlfA x ^ y71 ~, a ~'1J yy +?~~ ~9 ~ .`'s)? ~~y\J UtN ppT , ~ ~1 UJ,li~i'9y q ~~ l9 UBC 1997 2010 100% $27,138 $560,000 $144,442 $13,800 Obligations have been fulfilled as of December 31, 2006. *Available Tax Increment is defined as a percentage of the tax increment derived from the development property less the School District's (District #834) share of the increment. -Tax Increment is recorded at net of the School District's (District #834) share. The School District's share of the increment is 10.972% of the tax increment collected by the City. This sharing obligation was established at the time of district certification. This City remits this increment directly to the school District by March 31st following the payable year. 92 ~,I~ CITY OF STILLWATER, MINNESOTA TIF DISTRICT #1 Fund Type: Capital Projects Fund Fund Number: 46l 2006 SUMMARY OF REVENUES 2005 AMENDED AND EXPENDITURES ACTUAL BUDGET REVENUES: Tax Increment Market Value Homestead Credit Interest Note Receivable (MN Zephyr) Revenue Total EXPENDITURES: Contractual: Lumber Barons Hotel Readex Mainstream/Maple Island Desch Development UBC/Lanoga ABS Company Blichfield Development Contractual Total Legal Other Expenditure Total Revenues over expenditures Other Financing Uses Transfer Out Net increase in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 $ 665, 050 $ 3,415 20,796 6,881 _ $ 696,142 $ 750,000 $ 750,000 $ $ 2,744 $ 2,600 $ 2,000 $ 8,770 8,800 9,000 39,112 40,000 40,000 19,582 19,600 20,000 13,373 13,400 13,800 4,013 4,000 4,200 $ 87,594 $ $ 1,844 $ 2,979 $ 92,417 _ $ $ 603,725 $ 88,400 $ 89,000 $ 600 661,600 $ 621,000 $ (40,600) $ (438,753) $ (434,428) $ (435,231) $ (803) $ 164,972 $ 227,172 $ 185,769 (41,403) 471,576 636,548 863,720 227,172 $ 636,548 $ 863,720 $ 1,049,489 $ 185,769 88,400 $ 89,000 $ - $ - $ 2007 ADOPTED $ Increase BUDGET (Decrease} 710,000 $ (40,000) 710,000 $ (40,000) (600) 200 400 400 200 600 93 CITY OF STILLWATER, MINNESOTA TIF DISTRICT #4 Fund Type: Capital Project Fund Fund Number: 464 Fund Description: The City is the administering authority for Development District #1, Tax Increment District #4, Woodland Lake Project (TIF District #4). The district is a redevelopment district established in 1986 and has a 25- yearduration upon the receipt of the first tax increment. 1987 was the date of the first tax increment receipt. December 31, 2012 is the required date of decertification. Debt Obligation: $3,435,000 General Obligation Tax Increment Refunding Bonds, Series 20038 (Original Issue: $4,800,000 General Obligation Tax Increment Bonds, Series 1994C). This debt obligation was issued to: (1) Construct Frontage Road West from Curve Crest Boulevard to Northwestern Avenue; (2) Extend Curve Crest Boulevard from Washington Avenue to County Road 5; and (3) Install stop lights at the intersection of Frontage Road West and Curve Crest Boulevard.. Total amount outstanding as of December 31, 2006: $2,490,000 (see page 82 for more information on the debt service obligation). 2007 Budget Impacts: - Transfer Out represents funds being transferred out to debt service funds for the payment of current year debt service obligations. These obligations are as follows: (1) $389,493 to $3,435,000 General Obligation Tax Increment Refunding Bond, Series 20036 debt service fund ;and (2) $75,000 to $2,695,000 General Obligation Sports Center Refunding Bonds, Series 2005C debt service fund. Projects/Pay-as-you-qo Obligations within this district are as follows: TARGET/SUPERVALU MARKET PLACE This project was a redevelopment of the site into a marketplace with a grocery store and retail shops. No tax increment obligation is due to the developer. Notes: - The $75,000 transfer out to the $3,435,000 General Obligation Tax Increment Refunding Bond, Series 20036 debt service fund was approved by the City Council starting in 1998 through the life of the district. -Tax Increment is recorded at net of the School District's (District #834) share. The School District's share of the increment is 5.486% of the tax increment collected by the City. This sharing obligation was established at the time of district certification. This City remits this increment directly to the School District by March 31st following the payable year. 94 CITY OF STILLWATER, MINNESOTA TIF DISTRICT #4 Fund Type: Capital Projects Fund Fund Number: 464 SUMMARY OF REVENUES AND EXPENDITURES REVENUES: Tax Increment Interest Revenue Total EXPENDITURES: Other Professional Services Expenditures Total Revenues over (under) expenditures Other Financing Uses Transfer Out Net increase in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease} $ 662,105 $ 740,000 $ 710,000 $ (30,000) 20,622 - - - $ 682,727 $ 740,000 $ 710,000 $ (30,000} $ 640 $ - $ - $ - $ 640 $ - $ - $ - $ 682,087 $ 740,000 $ 710,000 $ (30,000) $ (465,385) $ (465,696) $ (464,943) $ 753 $ 216,702 $ 274,304 $ 245,057 $ (29,247) 852,466 1,069,168 1,343,472 274,304 $ 1,069,168 $ 1,343,472 $ 1,588,529 $ 245,057 95 CITY OF STILLWATER, MINNESOTA TIF DISTRICT #6 Fund Type: Capital Project Fund Fund Number: 466 Fund Description: The City is the administering authority for Development District #1, Tax Increment District #6, Jr. High (TIF District #6). The district is a redevelopment district established in 1993 and has a 25-year duration upon the receipt of the tax increment. 1995 was the date of the first tax increment receipt. December 31, 2019 is the required date of decertification. Debt Obligation: $1,000,000 General Obligation Tax Increment Refunding Bonds, 9993A . This debt obligation was issued to pay for the construction of the public parking lot. This parking lot is a permit parking lot with revenues going to the Parking Fund . Total amount outstanding as of December 31, 2006: $105,000 (see page 82 for more information on the debt service obligation). 2007 Budget Impacts: - Transfer Out represents funds transferred to $1,000,000 General Obligation Tax Increment Bond, Series 1993A debt service fund for payment of current year debt service obligations Projects/Pay-as-you-qo Obligations within this district are as follows: CUB/Jr High This project was a redevelopment of the old Stillwater Junior High site into corporate headquarters for CUB Foods and a public parking lot. No tax increment obligation is due to the developer. 96 J 0 CITY OF STILLWATER, MINNESOTA - TIF DISTRICT #6 Fund Type: Capital Projects Fund Fund Number: 466 2006 2007 SUMMARY OF REVENUES 2005 AMENDED ADOPTED $ Increase AND EXPENDITURES ACTUAL BUDGET BUDGET (Decrease) REVENUES: Tax Increment $ 91,529 $ 100,000 $ 90,000 $ (10,000) Interest 5,499 - - - Revenue Total $ 97,028 $ 100,000 $ 90,000 $ (10,000) EXPENDITURES: Other Professional Services $ 240 $ - $ - $ - Expenditures Totals $ 240 $ - $ - $ - Revenues over (under) expenditures $ 96,788 $ 100,000 $ 90,000 $ (10,000) Other Financing Uses Transfer Out $ (108,020) $ (108,206) $ (108,028) $ 178 Net increase (decrease) in fund balance $ (11,232) $ (8,206) $ (18,028) $ (9,822) Fund Balance -Jan 1 216,350 205,118 196,912 (8,206) Fund Balance -Dec 31 $ 205,118 $ 196,912 $ 178,884 $ (18,028) 97 CITY OF STILLWATER, MINNESOTA TIF DISTRICT #8 Fund Type: Capital Project Fund Fund Number: 468 Fund Description: The City is the administering authority for Development District #2, Tax Increment District #S, anchobaypro, Inc (TIF District #8}. The district is a housing district established in 2000 and has a 25-year duration upon the receipt of the first tax increment. 2002 was the date of the first tax increment receipt. December 31, 2027 is the required date of decertification. Projects/Pay-as-you-qo Obligations within this district are as follows: LONG LAKE VILLAS Long Lake Villas is a low to moderate income multifamily housing project. The City entered into any agreement with Long Lake Limited Partnership to aid in financing a portion of tax increment eligible costs of the project. The agreement is special and limited and not a general obligation of the City. Payments are made on the first day of each August and February commencing on August 1, 2002 and ending on February 1, 2026. Payments are made solely from Available Tax Increment. Available Tax Increment is defined as 90% of the tax increment derived from the development property (Long Lake Villas). Expected 2007 payment: $ 87,300 98 C u CITY OF STILLWATER, MINNESOTA TIF DISTRICT #8 Fund Type: Capital Projects Fund Fund Number: 468 SUMMARY OF REVENUES AND EXPENDITURES REVENUES: Tax Increment Market Value Homestead Credit Interest Revenue Total EXPENDITURES: Contractual: Long Lake Villas Legal City Engineer Charges Miscellaneous Expenditure Total Net increase (decrease) in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 2006 2007 2005 AMENDED ADOPTED ACTUAL BUDGET BUDGET 92,923 $ 100,000 $ 97,000 6,104 - - 605 - - 99,632 $ 100,000 $ 97,000 $ Increase (Decrease) $ (3,000) $ (3,000) $ 83,457 $ 90,000 $ 87,300 $ (2,700) 250 - - - 1,449 - - - 1,001 - - - $ 86,157 $ 90,000 $ 87,300 $ (2,700) $ 13,475 $ 10,000 $ 9,700 $ (300) 17,673 31,148 41,148 10,000 $ 31,148 $ 41,148 $ 50,848 $ 9,700 99 CITY OF STILLWATER, MINNESOTA TIF DISTRICT #9 Fund Type: Capital Project Fund Fund Number: 469 Fund Description: The City is the administering authority for Development District #1, Tax Increment District #9, Curve Crest Villas (TIF District #9). The district is a housing district established in 2002 and has a 25-year duration upon the receipt of the first tax increment. 2004 was the date of the first increment receipt. December 31, 2029 is the required date of decertification. Projects/Pay-as-you-qo Obligations within this district are as follows: CURVE CREST VILLAS Curve Crest Villas is a low to moderate income multifamily rental project. Two (2) notes were issued in the relation to this project to reimburse the developer for tax increment eligible costs. These notes are as follows: Note Issue Note Number Issue Amount Date of Issuance Balance Principal as of Due in 12/31/06 2007 Interest Due in 2007 $445,000 TIF Revenue Note R-1 $445,000 06/14/02 $430,000 $7,500 $30,697 $445,000 TIF Revenue Note R-2 $445,000 06/14/02 $430,000 $7,500 $30,697 Totals $15,000 $61,394 Payments on these notes are payable solely from 1/2 of Available Tax Increment. The City has no obligation to pay principal and interest on these Notes from any other sources than Available Tax Increment. Available Tax Increment is defined as 90% of the tax increment derived from the development property (Curve Crest Villas) and received by the City in the six months preceding the payment date. u u 0 100 CITY OF STILLWATER, MINNESOTA TIF DISTRICT #9 Fund Type: Capital Projects Fund Fund Number: 469 SUMMARY OF REVENUES AND EXPENDITURES REVENUES: Tax Increment Total Revenue EXPENDITURES: Contractual: Curve Crest Villas Legal Interest on Notes Other Expenditure Total Net increase (decrease) in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 2006 2005 AMENDED ACTUAL BUDGET $ 93,635 $ 95,000 $ 93,635 $ 95,000 $ 15,000 $ 15,000 $ 1,606 $ (13,394) 250 - - - 62,986 62,460 61,394 (1,066) 220 - - - $ 78,456 $ 77,460 $ 63,000 $ (14,460) $ 15,179 $ 17,540 $ 7,000 $ (10,540) (19,949) (4,770) 12,770 17,540 3 (?,770) $ 12,770 $ 19,770 $ 7,000 2007 ADOPTED $ Increase BUDGET (Decrease) 70,000 $ (25,000) 70,000 $ $ $ (25,000) 101 CITY OF STILLWATER, MINNESOTA TIF DISTRICT #10 Fund Type: Capital Project Fund Fund Number: 470 Fund Description: The City is the administering authority for Development District #7, Tax Increment District #10, Scattered Site Housing Projects (TIF District #10). The district is a redevelopment district established in 2004 and has a 25-year duration upon the receipt of the first increment. 2005 is the date of the first increment receipt. December 31, 2030 is the required date of decertification. Projects/Pay-as-you-go Obligations within this district are as follows: TERRA SPRINGS Terra Springs is a residential and commercial development project consisting of 5 buildings. Two (2) Tax Increment Revenue Notes were issued in relation to this project to reimburse the developer for tax increment eligible costs. These notes and the buildings they relate to are as follows: Note Issue Building Number Issue Amount Date of Issuance Balance as of 12/31/06 Principal Interest Due in Due in 2007 2007 $3,255,000 TIF Revenue Note 1,2,4 $3,255,000 12/10/03 $3,234,000 $43,000 $187,931 $2,923,000 TIF Revenue Note 3,5 $2,923,000 09/15/04 $2,923,000 $19,000 $196,816 Totals $62,000 $384,747 Payments on these notes are payable solely from of Available Tax Increment. The City has no obligation to pay principal and interest on these Notes from any other sources than Available Tax Increment. Available Tax Increment is defined as 95% of the tax increment derived from the development property (building number of the Terra Springs development) and received by the City in the six months preceding the payment date. LOFTS OF STILLWATER Balance Issue Date of as of Available Bond Issue Amount Issuance 12/31/06 Increment $2,390,000 TIF Revenue Bonds $2,390,000 07/20/06 $2,390,000 $69,500 Payments on these bonds are payable solely from Available Tax Increment. The City has no obligation to pay principal and interest on these bonds from any other sources than Available Tax Increment. All available increment is forwarded to a trust account. Funds in the trust are used to make the principal and interest payments on the bonds. Available Tax Increment is defined as 95% of the tax increment derived from the development property (Lofts of Stillwater) and received by the City in the six months preceding the payment date. 102 7 I~ u CITY OF STILLWATER, MINNESOTA TIF DISTRICT #10 Fund Type: Capital Projects Fund Fund Number: 470 SUMMARY OF REVENUES AND EXPENDITURES REVENUES: Current Property Taxes Market Value Homestead Credit Charges for Services Total Revenue EXPENDITURES: Contractual: Terra Springs Lofts of Stillwater Legal Other Professional Services Other Expenditure Total MISCELLANEOUS Net increase (decrease) in fund balance Fund Balance -Jan 1 Fund Balance -Dec 31 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) $ 17,897 $ 385,000 $ 440,000 $ 55,000 35 - - - (51,252) - - - $ (33,320) $ 385,000 $ 440,000 $ 55,000 $ 332,516 $ 200,000 $ 62,000 $ (138,000) - - 69,500 69,500 22,744 - - - 69, 398 - - - 14, 355 - - - $ 439,013 $ 200,000 $ 131,500 $ (68,500) $ - $ 146,300 $ 334,293 $ 187,993 $ (472,333) $ 38,700 $ (25,793) $ (64,493) (16,215) (488,548) (449,848) 38,700 $ (488,548) $ (449,848) $ (475,641) $ (25,793) 103 THIS PAGE INTENTIALLY LEFT BLANK ~ Enterprise Funds Enterprise Funds are used by the City to account for the operations that are financed primarily by user fees. THIS PAGE INTENTIALLY LEFT BLANK CITY OF STILLWATER, MINNESOTA ENTERPRISE FUNDS 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) OPERATING REVENUES $ 2,522,680 $ 2,605,000 $ 2,792,600 $ 187,600 OPERATING EXPENSES: Personnel Services $ 566,418 $ 570,774 $ 589,395 $ 18,621 Supplies 47,479 54,100 57,500 3,400 Service and Charges 1,742,859 1,818,935 1,898,951 80,016 Miscellaneous 19,045 15,000 33,500 18,500 Depreciation 244,491 281,200 226,900 (54,300) Operating Expenses Total $ 2,620,292 $ 2,740,009 $ 2,806,246 $ 66,237 Operating Income $ (97,612) $ (135,009) $ (13,646) $ 121,363 NONOPERATING REVENUES: Interest Income $ 58,248 $ 51,000 $ 65,000 $ 14,000 Miscellaneous 86,773 84,000 70,000 (14,000) Nonoperating Revenues Total $ 145,021 $ 135,000 $ 135,000 $ - Net Income (Loss) $ 47,409 $ (9) $ 121,354 $ 121,363 OTHER INCREASES Capital Contributions $ 23,600 $ - $ - $ - Transfer Out - (135,000) (168,364) (33,364) Other Increases Total $ 23,600 $ (135,000) $ (168,364) $ (33,364) Net increase (decrease) in net assets $ 71,009 $ (135,009) $ (47,010) $ 87,999 Net Assets -Jan 1 9,527,315 9,598,888 9,463,879 (135,009) Net Assets -Dec 31 $ 9,598,324 $ 9,463,879 $ 9,416,869 $ (47,010) 107 CITY OF STILLWATER, MINNESOTA SANITARY SEWER Fund Type: Enterprise Fund Fund Number: 700 Fund Description: The Sanitary Sewer Fund was established to account for the operation and maintenance of the City's sanitary sewer utility system. Funding Source: Expenses are solely supported by service fees charged to users. Rates: Minimum usage charge: $39.00 (Rate established by Ordinance No. 693, 02/07/1989) Overage charge: $3.70 per 1,000 gallons (Rate established by Resolution No. 2006-153, 07/11/2006) ~uui stamng ~evei: Full Time 3.95 FTE (Full Time Equivalents) Part Time 2.0 Number of Positions 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan. - Service Charges includes an estimated increase of $137,000 from a rate increase of $.50 in the overage charge starting with the third quarter billing of 2006. - Metropolitan Council The Metropolitan Council provides water treatment services for the wastewater collected by the City's sanitary sewer system. -1/I Surcharge is a program setup by the Metropolitan Council to cut inflow and Infiltration of clear water into the sanitary sewer system. The Metropolitan Council requires communities with excessive inflow and infiltration inputs into the sanitary sewer system to pay a surcharge. The surcharge will be returned as the City eliminates sources of the excess. The City's surcharge is $84,000 for the next five years (beginning in 2007) for a total cost of $420,000. For 2007, the City expects to appeal for a credit against the surcharge by showing that the City is attempting to eliminate some of excess input. Notes: -The new overage charge rate that was adopted on July 11, 2006 and went into effect on the 3rd quarter utility billing. The new rate was based on the results of the 2005 audited financial statements. - An annual review of the rates will be done to assure the financial integrity of this fund. 108 ' , CITY OF STILLWATER, MINNESOTA SAN ITARY SEWER ' Fund Type: Enterprise Fund Fund Number: 700 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) OPERATING REVENUES: Charges for Services $ 1,710,281 $ 1,793,000 $ 1,901,000 $ 108,000 I & I Surcharge - - 84,000 84,000 $ 1,710,281 $ 1,793,000 $ 1,985,000 $ 192,000 OPERATING EXPENSES: Personnel Services: Salaries -Full Time $ 187,637 $ 216,640 $ 220,478 $ 3,838 Salaries -Part Time 23,025 13,800 13,800 - Benefits 85,831 71,601 73,201 1,600 Personnel Services Total $ 296,493 $ 302,041 $ 307,479 $ 5,438 Supplies: $ 17,599 $ 22,700 $ 24,000 $ 1,300 Service and Charges: Consulting Engineer $ - $ 20,000 $ 6,000 $ (14,000) Lift Station Repairs 26,395 50,000 40,000 (10,000) Sewer Line Repairs 65,029 40,000 40,000 - Metropolitan Council 1,141,363 1,176,000 1,200,000 24,000 I & I Surcharge - - 84,000 84,000 Other 158,937 151,400 174,337 22,937 Services and Charges Total $ 1,391,724 $ 1,437,400 $ 1,544,337 $ 106,937 Miscellaneous: $ 4,324 $ 1,500 $ 2,000 $ 500 Depreciation: $ 217,213 $ 250,000 $ 225,000 $ (25,000) Operating Expenses Total $ 1,927,353 $ 2,013,641 $ 2,102,816 $ 89,175 Operating Loss $ (217,072) $ (220,641) $ (117,816) $ 102,825 NONOPERATING REVENUES: Interest Income $ 35,865 $ 35,000 $ 40,000 $ 5,000 Penalty 33,240 32,000 33,000 1,000 Other 53,533 52,000 37,000 (15,000} Nonoperating Revenues Total $ 122,638 $ 119,000 $ 110,000 $ (9,000) Net Income (Loss) $ (94,434) $ (101,641) $ (7,816) $ 93,825 OTHER INCREASES: Capital Contributions $ 23,600 $ - $ - $ - Transfer (Out) - (40,000) (40,000) Other Increases Total $ 23,600 $ - $ (40,000) $ (40,000) Net increase (decrease) in net assets $ (70,834) $ (101,641) $ (47,816) $ 53,825 Net Assets -Jan 1 8,357,319 8,286,485 8,184,844 {101,641) Net Assets -Dec 31 $ 8,286,485 $ 8,184,844 $ 8,137,028 $ (47,816) 109 CITY OF STILLWATER, MINNESOTA STORM SEWER Fund Type: Enterprise Fund Fund Number: 705 Fund Description: The Storm Sewer Fund was established to account for the operation and maintenance of the City's storm water utility system. Funding Source: Expenses are solely supported by service fees charged to users. Rates: Single-Family and Duplexes: $4.50 per dwelling Multi-Family: $4.50 per unit Active Open Space: $4.50 per acre Institutional: $27.00 per acre Commercial/Industrial: $54.00 per acre Central Business District: $72.00 per acre 2007 Staffing Level: I Full Time I 1.151FTE (Full Time Eouivalents) I 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan. - Consulting Engineer costs include services for the City's Storm Water Management Plan (analyzes the City's needs for storm water management) and the setup the City's Municipal Separated Storm Sewer Service (MS$) permit. - Contractual includes costs for a wetland inventory. - Transfer Out includes $100,000 for the Storm Sewer Fund's share of the current years street project (see CIP). - Membership 8 Dues is dues to the Middle St Croix WMO. Notes: - An annual review of the rates will be done to assure the financial integrity of this fund. 110 n CITY OF STILLWATER, MINNESOTA STORM SEWER Fund Type: Enterprise Fund Fund Number: 705 2006 2007 2005 AMENDED ADOPTED ACTUAL BUDGET BUDGET OPERATING REVENUES: Charges for Services OPERATING EXPENSES: Personnel Services: Salaries -Full Time Benefits Personnel Services Total Service and Charges: Consulting Engineer Contractual Storm Sewer Repairs Other Services and Charges Total Miscellaneous: Supplies: Depreciation: Operating Expenses Total Operating Income NONOPERATING REVENUES: Interest Income OTHER INCREASES: Transfer Out Net Income Net Assets -Jan 1 Net Assets -Dec 31 $ 210,708 $ 210,000 $ 213,600 $ Increase (Decrease) $ 3,600 $ 78,148 $ 70,853 $ 75,881 $ 5,028 23,638 16,671 19,057 2,386 $ 101,786 $ 87,524 $ 94,938 $ 7,414 $ 76,000 $ 37,291 10,000 2,974 10,000 43,550 21,090 83,815 _ $ 117,090 $ 10,854 $ 12,000 $ 40,000 $ (36,000) 10,000 - 10,000 - 17,030 (4,060) 77,030 $ (40,060) 30,000 $ 18,000 $ 4,102 $ 500 $ 500 $ - $ 1,621 $ - $ 1,600 $ 1,600 $ 202,178 $ 217,114 $ 204,068 $ (13,046) $ 8,530 $ (7,114) $ 9,532 $ 16,646 $ 14,968 $ 10,000 $ 16,000 $ 6,000 $ - $ (135,000) $ (100,000) $ 35,000 $ 23,498 $ (132,114) $ (74,468) $ 57,646 618,371 641,869 509,755 (132,114) $ 641,869 $ 509,755 $ 435,287 $ (74,468) 111 CITY OF STILLWATER, MINNESOTA SIGNS & LIGHTING Fund Type: Enterprise Fund Fund Number: 710 Fund Description: The Signs ~ Lighting Fund was established to account for the operation and maintenance of the City's sign and lighting system. Funding Source: Expenses are solely supported by service fees charged to users. Rates (established by Resolution No. 2003-151, 07/01/2003): Single-Family and Duplexes: $8 per dwelling Multi-Family: $6 per unit Institutional: $24 per acre Commercial: $96 per acre Commercial with System: $128 per acre Active Open Space: $2 per acre Interfund Obligation On August 5, 2003, Resolution Number 2003-173, the City Council approved the funding of the Industrial Park Lighting Project (Engineering Project #2000-13} by the Sign & Lighting Fund. There were insufficient funds, at that time, in the Sign & Lighting Fund to fund the $265,000 project. The Council authorized an interfund borrowing, pledging future cash to be used to repay the interfund borrowing. In 2004, when the project was complete, the Capital Project fund borrowed $165,470 to the Sign & Lighting Fund to cover the negative cash amount of the fund. The balance of the interfund borrowing is as follows: Original Amount Balance Projected Loan Paid* as of Amount to Interfund Obligation Amount to Date 12/31/06 be Paid in 2007 Due to Ca ital Projects Fund $165,470 $45,234 $120,236 $ - *Yearly payments are not calculated until the closing of the fiscal year. In other words, the annual payment for fiscal year 2006 will not be available until March of 2007. 2007 Staffing Level: Full Time 1.25 FTE (Full Time Equivalents) 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan. Notes: - An annual review of the rates will be done to assure the financial integrity of this fund. 112 1 0 n CITY OF STILLWATER, MINNESOTA SIGNS & LIGHTING Fund Type: Enterprise Fund Fund Number: 710 OPERATING REVENUES: Charges for Services OPERATING EXPENSES: Personnel Services: Salaries -Full Time Benefits Personnel Services Total Supplies: Service and Charges: Contractual Electricity Other Services and Charges Total Depreciation: Miscellaneous: Operating Expenses Total Operating Income NONOPERATING REVENUES; Interest Income Other Decreases: Transfer Out -Perm Improv Operating Income Net Assets -Jan 1 Net Assets -Dec 31 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (Decrease) $ 357,612 $ 350,000 $ 362,000 $ 12,000 $ 57,358 $ 23,543 _ $ 80,901 $ $ 15,405 $ 62,452 $ 19,758 _ 82,210 $ 17,200 $ 86,100 $ 3,890 17,800 $ 600 $ 177 $ 3,000 $ 3,000 $ - 196,654 188,000 200,000 12,000 18,591 22,708 25,817 3,109 $ 215,422 $ 213,708 $ 228,817 $ 15,109 $ 321 $ 200 $ 300 $ 100 $ 317 $ 500 $ 500 $ - $ 312,366 $ 313,818 $ 333,517 $ 19,699 $ 45,246 $ 36,182 $ 28,483 $ (7,699) $ 564 $ - $ - $ - $ - $ - $ (28,364) $ (28,364) $ 45,810 $ 36,182 $ 119 $ (36,063) (156,498) (110,688) (74,506) 36,182 $ (110,688) $ (74,506) $ (74,387) $ 119 65,606 $ 3,154 20,494 736 113 CITY OF STILLWATER, MINNESOTA PARKING Fund Type: Enterprise Fund Fund Number: 720 Fund Description: The Parking Fund was established to account for the operation and maintenance of the City's downtown parking program. The parking program consists of 14 parking lots which include free parking with hour limits, pay parking and permit parking. Funding Source: Expenses are solely supported by parking fees charged to users. Major revenues include pay parking fees, permit parking fees and parking enforcement fines. :uur starnng ~evei: Full Time 1.10 FTE (Full Time Equivalents) Part Time 6.0 Number of Positions 2007 Budget Impacts: - Personnel costs include 3.0% COLA on wages, a 16% increase in health insurance rates, and a 0% increase in dental insurance rates. - Personnel costs include a State mandated contribution rate increase to PERA . Beginning January 1, 2007, the employers contribution to the plan will increase from 6.00% to 6.25% for the Coordinated Plan. Notes: At the recommendation of the Parking Commission, on December 17, 2002, the City Council instituted the City's management of the Downtown Parking program for 2003. Prior to 2003, the City contracted out the management of this program. 114 CITY OF STILLWATER, MINNESOTA PARKING Fund Type: Enterprise Fund Fund Number: 720 2006 2007 2005 AMENDED ADOPTED $ Increase ACTUAL BUDGET BUDGET (D ecrease) OPERATING REVENUES: Parking Permits $ 23,585 $ 35,000 $ 24,000 $ (11,000) Parking Meters 133,179 146,000 133,000 (13,000) Parking Fines/Tickets 87,315 71,000 75,000 4,000 Operating Revenues Total $ 244,079 $ 252,000 $ 232,000 $ (20,000) OPERATING EXPENSES: Personnel Services: Salaries -Full Time $ 39,295 $ 47,342 $ 48,310 $ 968 Salaries -Part Time 30,170 36,000 36,000 - Benefits 17,773 15,657 16,568 911 Personnel Services Total $ 87,238 $ 98,999 $ 100,878 $ 1,879 Supplies: $ 10,373 $ 13,700 $ 15,200 $ 1,500 Service and Charges: $ 51,898 $ 50,737 $ 48,767 $ (1,970) Miscellaneous: $ 3,550 $ 1,000 $ 1,000 $ - Depreciation: $ 25,336 $ 31,000 $ - $ (31,000) Operating Expenses Total $ 178,395 $ 195,436 $ 165,845 $ (29,591} Operating Income $ 65,684 $ 56,564 $ 66,155 $ 9,591 NONOPERATING REVENUES (EXPENSES): Interest Income (Expense) $ 7,415 $ 6,000 $ 9,000 $ 3,000 Nonoperating Revenues Total $ 7,415 $ 6,000 $ 9,000 $ 3,000 Net Income $ 73,099 $ 62,564 $ 75,155 $ 12,591 Net increase in net assets $ 73,099 $ 62,564 $ 75,155 $ 12,591 Net Assets -Jan 1 708,123 781,222 843,786 62,564 Net Assets -Dec 31 $ 781,222 $ 843,786 $ 918,941 $ 75,155 115 THIS PAGE INTENTIALLY LEFT BLANK i OTHER SCHEDULES THIS PAGE INTENTIALLY LEFT BLANK L CITY OF STILLWATER, MINNESOTA 2007 CAPITAL OUTLAY ' DEPARTMENT 2007 APPROVEC ACCOUNT NAME FUNDING SOURCE GENERAL FUND ' Elections Voting Booths (20) 4,000 Machinery & Equipment 2007 CO Bonds Total Elections $ 4,000 MIS ' Wireless Network (2005 Unspent) 20,000 Computer Equipment 2005 CO Bonds Website Upgrades (2005 Unspent) 3,500 Computer Equipment 2005 CO Bonds Servers 4,000 Computer Equipment 2007 CO Bonds Anti-Virus Software 3,000 Computer Equipment 2007 CO Bonds Microsoft Licensing 12,200 Computer Equipment 2007 CO Bonds Surf Control Licensing 4,000 Computer Equipment 2007 CO Bonds Event Log Correlation Software 3,500 Computer Equipment 2007 CO Bonds Firewall 4,000 Computer Equipment 2007 CO Bonds Switches 2,600 Computer Equipment 2007 CO Bonds Hard Drives 5,400 Computer Equipment 2007 CO Bonds Update Phone/VM System/Software 10,000 Computer Equipment 2007 CO Bonds ' Total MIS $ 72,200 Finance Springbrook Software (2006 Unspent) 8,300 Computer Equipment 2006 CO Bonds ' Interface for Springbrook/Laserfiche 6,500 Computer Equipment 2007 CO Bonds High Speed Scanner 2,500 Computer Equipment 2007 CO Bonds Records Management Edition Module (50% split wit 3,000 Computer Equipment 2007 CO Bonds Administration) ' Total Finance $ 20,300 Administration ' Computer Replacement Records Management Edition Module (50% split wii 1,500 3,000 Computer Equipment Computer Equipment 2007 CO Bonds 2007 CO Bonds Administration) Bar Codes & Lookup 2,000 Computer Equipment 2007 CO Bonds ' Color Scanner Laser Printer 7,000 1,200 Computer Equipment Computer Equipment 2007 CO Bonds 2007 CO Bonds Digital Recording System 4,000 Computer Equipment 2007 CO Bonds Total Administration $ 18,700 Plant/City Hall Upgrade 2nd floor carpet 15,000 Improvements 2007 CO Bonds 2nd Floor Asbestos Removal 7,500 Improvements 2007 CO Bonds City Hall waterproofing 75,000 Improvements 2007 CO Bonds Total PIanUCity Hall $ 97,500 Community Development Inspections/Planning Software (50% split with 6,000 Computer Equipment 2007 CO Bonds Inspections) Computer Replacement 1,500 Computer Equipment 2007 CO Bonds Color Laser (Split with Community Development/ 1,200 Computer Equipment 2007 CO Bonds Engineering/Inspections) ' Total Community Development $ 8,700 Police Ruggedized Laptop (2006 Unspent) 4,500 Computer Equipment 2006 CO Bonds Digital Cameras (10) 8,000 Computer Equipment 2007 CO Bonds Copier 10,000 Computer Equipment 2007 CO Bonds Ruggedized Laptop 8,000 Computer Equipment 2007 CO Bonds ' Printer 1,800 Computer Equipment 2007 CO Bonds ' 119 CITY OF STILLWATER. MINNESOTA 2007 CAPITAL OUTLAY (Con't) DEPARTMENT Police Continued Computers (6) Marked Patrol Cars (3) 800 MHZ Public Safety Radio System Less Lethal Total Police Fire Digital Video Camera (2006 Unspent) Fire Equipment (2006 Unspent) Computer Replacement (2) Monitor V Radio Pagers Turn Out Gear Washing Machine/Extractor Fire Engine Fire Station/Public Safety Facility 800 MHZ Public Safety Radio System Total Fire Building Inspections Building Permit Software (2006 Unspent) Ruggedized Laptop (2006 Unspent) Ruggedized Laptop (2005 Unspent) Inspections/Planning Software (50% split with Community Development) Workgroup Laser Printer Color Laser (Split with Community Development/ Engineering/Inspections) Total Building Inspections Engineering Computer Replacement (2) Color Laser (Split with Community Development/ Engineering/Inspections) AutoCAD Total Public Works/Engineering Streets Street Automotive (2006 Unspent) Street Equipment (2006 Unspent) Time Sheet Software (25% split with Parks/ Sewer/Signs & Lighting) Switch Bobcat Skidsteer Skidsteer Trailer Snow Plow Truck 1 Ton Truck with Plow & Sander 1 Ton Truck with Plow & Sander 24" Asphalt Planer for Skidsteer A/C Recycler Solvent Recycler Total Street TOTAL GENERAL FUND 2007 APPROVEC ACCOUNT NAME FUNDING SOURCE 9,000 Computer Equipment 2007 CO Bonds 100,000 Automotive Equipment 2007 CO Bonds 70,000 Machinery & Equipment 2007 CO Bonds 7,000 Machinery & Equipment 2007 CO Bonds $ 218,300 1,000 Computer Equipment 2006 CO Bonds 5,800 Machinery 8 Equipment 2006 CO Bonds 3,000 Computer Equipment 2007 CO Bonds 3,700 Machinery & Equipment 2007 CO Bonds 8,000 Machinery & Equipment 2007 CO Bonds 8,000 Machinery & Equipment 2007 CO Bonds 75,000 Automotive Equipment 2007 CO Bonds 25,000 Improvements 2007 CO Bonds 60,000 Machinery & Equipment 2007 CO Bonds/Fire Grant $ 189,500 13,500 Computer Equipment 2006 CO Bonds 1,000 Computer Equipment 2006 CO Bonds 5,000 Computer Equipment 2005 CO Bonds 6,000 Computer Equipment 2007 CO Bonds 2,000 Computer Equipment 2007 CO Bonds 1,200 Computer Equipment 2007 CO Bonds $ 28,700 3,000 Computer Equipment 2007 CO Bonds 1,200 Computer Equipment 2007 CO Bonds 10,000 Computer Equipment 2007 CO Bonds $ 14,200 29,875 Automotive Equipment 2006 CO Bonds 6,804 Machinery 8 Equipment 2006 CO Bonds 2,500 Computer Equipment 2007 CO Bonds 1,300 Computer Equipment 2007 CO Bonds 35,000 Machinery & Equipment 2007 CO Bonds 4,500 Machinery & Equipment 2007 CO Bonds 190,000 Automotive Equipment 2007 CO Bonds 50,000 Automotive Equipment 2007 CO Bonds 50,000 Automotive Equipment 2007 CO Bonds 14,000 Machinery & Equipment 2007 CO Bonds 3,500 Machinery & Equipment 2007 CO Bonds 3,000 Machinery & Equipment 2007 CO Bonds $ 390,479 $ 1,062,579 ~I 0 u u n 120 ' CITY OF STILLWATER, MINNESOTA ZOO7 CAPITAL OUTLAY (Con't) ' DEPARTMENT 2007 APPROVEC ACCOUNT NAME ST CROIX VALLEY RECREATION CENTER FUND Rec Center Ice Arena ' POS Terminal 2,500 Computer Equipment Computer 1,500 Computer Equipment Server Upgrades 2,500 Computer Equipment Auto Scrubber for cleaning floors 8,000 Machinery & Equipment ' Cart used for painting and flooding ice surfaces 6,500 Machinery & Equipment Total Ice Arena $ 21,000 Rec Center Fieldhouse ' New Turf for Field House in 2010 60,000 Improvements $ 60,000 u FUNDING SOURCE 2007 CO Bonds 2007 CO Bonds 2007 CO Bonds 2007 CO Bonds 2007 CO Bonds 2007 CO Bonds Lilt/ Lake Ice Arena Parking lot overlay $ storm sewer (2006 Unspen 105,000 Machinery & Equipment 006 CO Bonds/Storm Sewer $ 105,000 TOTAL ST CROIX VALLEY RECREATION CENTER $ 186,000 LIBRARY FUND Operations Public Computer Stations (5) Computer Replacemnt Program System Software Printer Replacement Program AV Equipment Children's Program Equipment Children's Homework Center Map Files Portable Book Return Total Library-Operations TOTAL LIBRARY FUND PARKS FUND Nature Preserve Trail System (2000 Unspent) Nature Preserve Trail (Land Sale) Lowell Park (2001 Unspent) Lowell Park (2002 Unspent) Lowell Park (2003 Unspent) Trail maintenance improvement Trail System (2006 Unspent) Munke/witz Park Improvements (2006 Unspent) Park Improvements (2004 Unspent) Park Equipment (2004 Unspent) Hard court rehabilitation (2006 Unspent) Lowell Park Bathrooms (2006 Unspent) Time Sheet Software (25% split with Parks/ Sewer/Signs & Lighting) Pickup Truck (1) Riding Lawn Mower Park Improvements -various Munkelwitz Park TOTAL PARKS FUND 5,000 Computer Equipment 2007 CO Bonds 15,000 Computer Equipment 2007 CO Bonds 6,500 Computer Equipment 2007 CO Bonds 3,000 Computer Equipment 2007 CO Bonds 7,500 Machinery & Equipment 2007 CO Bonds 3,500 Machinery & Equipment 2007 CO Bonds 6,500 Machinery & Equipment 2007 CO Bonds 1,500 Machinery & Equipment 2007 CO Bonds 1,500 Machinery& Equipment 2007 CO Bonds $ 50,000 $ 50,000 22,670 Improvements 2000 CO Bonds 82,404 Improvements Fund Balance 180,000 Improvements 2001 CO Bonds 175,000 Improvements 2002 CO Bonds 165,000 Improvements 2003 CO Bonds 50,000 Improvements 2006 CO Bonds 86,112 Improvements 2006 CO Bonds 40,000 Improvements 2005 CO Bonds 25,000 Machinery & Equipment 2004 CO Bonds 5,130 Improvements 2006 CO Bonds 3,776 Improvements 2006 CO Bonds 2,500 Computer Equipment 2007 CO Bonds 25,000 Automotive Equipment 2007 CO Bonds 25,000 Machinery & Equipment 2007 CO Bonds 50,000 Improvements 2007 CO Bonds 75,000 Improvements 2007 CO Bonds $ 1,012,592 ' 121 CITY OF STILLWATER. MINNESOTA 2007 CAPITAL OUTLAY (Con't) DEPARTMENT 2007 APPROVEC ACCOUNT NAME FUNDING SOURCE SEWER FUND Lift Station Improvements (2004 Unspent) 107,145 Improvements Sewer Fund Lift Station Improvements (2005 Unspent) 18,000 Improvements Sewer Fund Time Sheet Software (25% split with Parks/ 2,500 Computer Equipment Sewer Fund Sewer/Signs & Lighting) Cartegraph Software Modules 4,700 Computer Equipment Sewer Fund Computer 1,500 Computer Equipment Sewer Fund Maintenance Software/Equipment for Lift Stations 60,000 Computer Equipment Sewer Fund Reline Sanitary Trunk Sewers 200,000 Improvements Sewer Fund TOTAL SEWER FUND $ 393,845 Storm Sewer Lily Lake Storm Sewer $ 35,000 Improvements Storm Sewer Fund Total Storm Sewer $ 35,000 SIGNS & LIGHTING Time Sheet Software (25% split with Parks/ 2,500 Computer Equipment Signs & Lighting Fund Sewer/Signs & Lighting) TOTAL SIGNS & LIGHTING $ 2,500 TOTAL 2007 CAPITAL OUTLAY $ 2,742,516 122 r ~~ n n n ~~ CITY OF STILLWATER, MINNESOTA ZOO7 CAPITAL OUTLAY Financing FINANCING for Capital Outlay Bonded GO Capital Outlay (2007 Bond Issuel: General Fund 943,300 St Croix Valley Rec Center 81,000 Library Fund 50,000 Parks Fund 177,500 Total GO Capital Outlay 2006 Bonds $ 1,251,800 Bonded GO Capital Outlay (2006 Bond Issuel: General Fund 70,778 St Croix Valley Rec Center 105,000 Parks Fund 145,018 Total GO Capital Outlay 2006 Bonds $ 320,797 Bonded GO Capital Outlay (2005 Bond Issuel General Fund $ 28,500 Bonded GO Capital Outlay (2004 Bond Issuel Parks Fund $ 65,000 Bonded GO Capital Outlay (2003 Bond Issuel Parks Fund $ 165,000 Bonded GO Capital Outlay (2002 Bond Issuel Parks Fund $ 175,000 Bonded GO Capital Outlay (2001 Bond Issuel Parks Fund $ 180,000 Bonded GO Capital Outlay (2000 Bond Issuel Parks Fund $ 22,670 Total Bonded Capital Outlay $ 2,208,767 Non-Bonded Funding Sources for Capital Outlay: Fire Fighters Act Grant 20,000 Parks Fund (Land Sale) 82,404 Sewer Fund 393,845 Storm Sewer 35,000 Signs & Lighting 2,500 Total Non-Bonded Capital Outlay $ 533,749 TOTAL BONDED &NON-BONDED CAPITAL OUTLAY $ 2,742,516 123 THIS PAGE INTENTIALLY LEFT BLANK CITY OF STILLWATER, MINNESOTA ZOO7 INTERFUND TRANSFERS Fund OPERATING TRANSFERS General Operating Transfers 100 General Fund 200 Special Events Fund 230 Library Fund 240 Park Fund 263 DARE Fund Debt Service Transfers 202 St Croix Valley Rec Center 381 $2,135,000 2000D GO Bonds 385 $2715 Sports Ctr 2005C 451 Permanent Improvement Fund 390 Program Loans 303 $200 CO CO Bonds - 2003 461 TIF District #1 360 $2,265,000 2000E TIF Bonds 464 TIF District #4 374 $3,435,000 Tax Increment 20036 382 $4,610,000 1998A Sports Arena Bonds 466 TIF District #6 366 $1,000,000 1993A TIF Bonds Other Transfers 700 Sewer Fund 705 Storm Sewer Fund 710 Signs & Lighting Fund 451 Permanent Improvement Fund CAPITAL OUTLAY TRANSFERS 424 2000 Capital Outlay 423 2001 Capital Outlay 423 2002 Capital Outlay 420 2003 Capital Outlay 404 2004 Capital Outlay 405 2005 Capital Outlay 416 2006 Capital Outlay 407 2007 Capital Outlay 100 General Fund 202 St Croix Valley Recreation Center Fund 230 Library Fund 240 Park Fund TRANSFERS TRANSFERS IN OUT $ 1,745,039 $ 17,500 1,009,475 715,564 2,500 $ 312,876 $ 187,328 125,548 $ 227,400 $ 195,000 32,400 $ 435,231 $ 435,231 $ 464,943 $ 389,943 75,000 $ 108,028 $ 108,028 $ 40,000 100,000 28,364 $ 168,364 $ 22,670 180,000 175,000 165,000 65,000 28,500 355,797 1,251,800 $ 1,042,579 221, 000 50,000 930,188 125 CITY OF STILLWATER, MINNESOTA ZOO7 BENEFITED PERSONNEL DEPARTMENT/Position Title FTE DEPARTMENT/Position Title GENERAL FUND Public Safety (Con't) Fire 1.00 Fire Chief 4.00 Deputy Fire Chief 5.00 Fire Captain Fire-Engineer Firefighter-Engineer 1.00 Secretary/Dispatcher I 0.80 Total Fire 1.80 Building Inspection Building Official 1.00 Building Inspector 1.00 Secretary 1.50 Total Building Inspection 1.00 4.50 Total Public Safety Public Works 1.00 Engineering 1.00 City Engineer/Public Works Director 1.00 Assistant City Engineer 1.90 Project Coordinator 4.90 Engineering Technician III Secretary Total Engineering 1.00 1.00 Sfreets Public Works Superintendent Assistant Public Works Super 1.00 Lead Worker 1.00 Maintenance Worker IV Maintenance Worker III Maintenance Worker II 1.00 Chief Mechanic 1.00 Total Streets 0.50 2.50 Total Public Works 20.70 TOTAL GENERAL FUND FTE General Government Mayor and City Council Mayor' Councilmembers' Total Mayor and City Council MIS MIS Specialist PC Technician Total MIS Finance Finance Director Accountant Senior Account Clerk Payroll/HR Technician Total Finance Administration City Administrator Director of Administration City Clerk Secretary Total Administration Legal/City Attorney City Attorney' Total Legal/City Attorney Plant/City Hall Building Maintenance II Total Plant/City Hall Community Development Community Development Director Planner II Secretary Total Community Development Total General Government Public Safety Police Police Chief Police Captain Police Sergeant Investigator Police Officers Community Service Officer Secretary/Dispatcher I Total Police 1.00 1.00 4.00 3.00 14.00 1.00 1.50 25.50 126 1.00 1.00 3.00 2.00 2.00 0.50 9.50 1.00 2.00 0.50 3.50 38.50 0.75 0.50 0.50 1.85 0.50 4.10 0.50 0.25 0.30 4.00 2.50 1.00 1.00 9.55 13.65 72.85 CITY OF STILLWATER, MINNESOTA ZOO7 BENEFITED PERSONNEL DEPARTMENT/Position Title Library Operations Library Director Secretary Library Assistant I PC Technician Assistant Library Director Supervisory Librarian Library Assistant II Library Assistant I Librarian Librarian Associate Total Library Operations PARKS FUND Public Works Superintendent Lead Worker Maintenance Worker IV Maintenance Worker III Secretary TOTAL PARKS FUND FTE DEPARTMENT/Position Title LIBRARY FUND Library Plant 1.00 Building Maintenance 1.00 Janitor 1.00 Total Library Plant 0.20 0.75 TOTAL LIBRARY FUND 1.50 0.75 0.75 0.75 1.50 9.20 SANITARY SEWER FUND 0.50 City Engineer/Public Works Director 1.00 Assistant City Engineer 1.00 Assistant Public Works Superintendent 4.50 Lead Worker 0.50 Maintenance Worker IV 7.50 Senior Account Clerk TOTAL SANITARY SEWER FUND STORM SEWER FUND Assistant City Engineer 0.25 Assistant Public Works Superintendent 0.25 Project Coordinator 0.50 Senior Account Clerk 0.15 TOTAL STORM SEWER FUND 1.15 PARKING Community Service Officer 1.00 Secretary 0.10 TOTAL PARKING FUND 1.10 GRAND TOTAL 98.50 Part-time positions receiving full-time benefits. SIGNS 8 LIGHTING FUND Assistant Public Works Superintendent Engineering Tech III Lead Worker Senior Account Clerk TOTAL SIGNS & LIGHTING FUND 127 FTE 1.00 0.50 1.50 0.25 0.25 0.25 1.00 2.00 0.20 3.95 0.25 0.15 0.70 0.15 1.25