The URL can be used to link to this page

Home My WebLink About11-029CITY OF LAKEVILLE RESOLUTION NO. 11 -29 RESOLUTION AMENDING THE 2011 BUDGETS BE IT HEREBY RESOLVED that the 2011 General Fund, Communications Fund, Environmental Resources Fund, Equipment Fund, Liquor Fund, and Utility Fund budgets are hereby approved and amended for the fiscal year ending December 31, 2011 as per Exhibits A, B, C, D, E and F, respectively, as attached hereto. APPROVED by the Lakeville City Council this 21st day of March, 2011. CITY OF LAKEVILLE, MINNESOTA Mark Bellows, Mayor ATTEST: L Charlene Friedges, 9ty Clerk Exhibit A 2011 GENERAL FUND BUDGET Revenues General property taxes Licenses and permits Intergovernmental revenue Charges for services Court fines Investment income Miscellaneous Total revenues Expenditures Mayor and Council Committees and Commissions City administration City Clerk Legal Planning Community and economic development Inspection General government facilities Finance Information systems Human resources Insurance Police Fire Engineering Streets Parks Recreation Arts Center Other Total expenditures Other financing sources Transfers from other funds Net change in fund balance Fund balance, January 1 Fund balance, December 31 2011 2011 ADOPTED AMENDED BUDGET ADJUST BUDGET NOTES $ 16,145,897 $ - $ 16,145,897 1,131,081 - 1,131,081 961,415 - 961,415 1,221,772 - 1,221,772 294,026 - 294,026 125,175 - 125,175 81,707 4,332 86,039 1 19,961,073 4,332 19,965,405 109,245 (16,537) 92,708 2 84,991 (500) 84,491 3 324,397 (901) 323,496 4 115,569 (601) 114,968 5 65,132 - 65,132 355,776 (3,996) 351,780 6 271,643 (601) 271,042 7 940,930 (8,003) 932,927 8 502,975 (4,701) 498,274 9 570,747 - 570,747 468,698 (6,943) 461,755 10 305,390 (901) 304,489 11 289,532 - 289,532 8,503,589 27,982 8,531,571 12 1,313,579 (13,404) 1,300,175 13 759,688 (3,933) 755,755 14 2,445,319 - 2,445,319 2,160,919 (1,610) 2,159,309 15 599,531 (1,802) 597,729 15 440,600 (601) 439,999 15 211,864 - 211,864 20,840,114 (37,052) 20,803,062 655,652 - 655,652 (223,389) 41,384 (182,005) 8,615,197 - 8,615,197 $ 8,391,808 $ 41,384 $ 8,433,192 Exhibit A(Cont.) General Fund Notes Note Program and services Impact of program or service reduction or Effective elimination I April l 2011 Revenues The Police Department Records Technician ($27,982) to 1 Council Member Salary Donation be hired effective July 1, 2011. Financing to be provided 4,332 by a donation by Council Member Matt Little ($4,332) and General Fund balance ($23,650). Mayor and Council Drop Membership - Metro Cities Reduction in advocacy at Met Council and TAB 12,287 2 Miscellaneous Reduced from $1,350 to $500 per Council Member. 4,250 Committees and Commissions 3 Dues and subscriptions for Parks, Recreation and Spring bus tour 500 Natural Resource Committee City Administration 4 Microsoft upgrade Purchase deferred contingent upon outcome of comparison 901 with open systems. City Clerk 5 Microsoft upgrade Purchase deferred contingent upon outcome of comparison 601 with open systems. Planning Microsoft upgrade Purchase deferred contingent upon outcome of comparison 1,201 with open systems. With the transfer of sign administration to the Police Capital outlay - equipment Departments CSO, safety equipment acquisition can be 370 eliminated. 6 Eliminate 100% of meeting expenses. 50 Eliminate 100% of miscellaneous expenses 200 Operations adjustments Professional services reduced for County Recorder fees. 500 Reduction in operation supplies 1,675 Community and Economic Development 7 Microsoft upgrade Purchase deferred contingent upon outcome of comparison 601 with open systems. Exhibit A(Cont.) General Fund Notes Note Program and services Impact of program or service reduction or Effective elimination I April l 2011 Inspections card fees (Eliminate issuance of permits on line requiring contractors 1,500 and residents to come to City Hall for routine permits. General Government Facilities Microsoft upgrade Purchase deferred contingent upon outcome of comparison 901 with open systems. Postal delivery of Welcome Packet - eliminated. Approximately 900 "Welcome Packets" are sent out each year to new residents. The packets contain Resident Guidebook, Park and Rec information, City utility and "Welcome Packet" water conservation information, voter registration 1,500 application, Dakota County information and other topical information. Instead of mailing the information, new residents can obtain the information from the City web -site 9 or picking it up at City Hall during normal business hours. Notifications to employment applicants. The City of Lakeville, like other business, sends rejection letters to persons who have applied for employment with the City of it applications Lakeville. If the practice is discontinued, the applicants 600 would receive an email notification or visit the web -site for such information. Staff to research joint venture with Chamber of Commerce. adjustments Reduction in operating supplies 1,700 As an option, City Council to consider a user fee for on- line payments Purchase deferred contingent upon outcome of comparison 2,403 Microsoft upgrade with open systems. 8 Office supplies. Hold off buying large item office 600 supplies until 2012. Forms printing. Delay purchase of permit stock until 500 2012. Operating Supplies. Delay buying new code books until 600 Operations adjustments 2012. Motor Fuels. Reduce budget to reflect purchasing 1,000 economical vehicles. Equipment Parts. Reduce 2011 budget to $1000. 1,000 Miscellaneous expenses 100 Computer Supplies. 2010 actual: $151. Reduce 2011 300 budget to $200. General Government Facilities Microsoft upgrade Purchase deferred contingent upon outcome of comparison 901 with open systems. Postal delivery of Welcome Packet - eliminated. Approximately 900 "Welcome Packets" are sent out each year to new residents. The packets contain Resident Guidebook, Park and Rec information, City utility and "Welcome Packet" water conservation information, voter registration 1,500 application, Dakota County information and other topical information. Instead of mailing the information, new residents can obtain the information from the City web -site 9 or picking it up at City Hall during normal business hours. Notifications to employment applicants. The City of Lakeville, like other business, sends rejection letters to persons who have applied for employment with the City of it applications Lakeville. If the practice is discontinued, the applicants 600 would receive an email notification or visit the web -site for such information. Staff to research joint venture with Chamber of Commerce. adjustments Reduction in operating supplies 1,700 Exhibit A(Cont.) General Fund Notes Note Program and services Impact of program or service reduction or Effective elimination I April l 2011 Information Systems Software replaced by Spice Works. IT staff has been Track -IT annual support maintenance working with an open source application to replace Track- 1,320 IT Used to access network while working in remote area of Cellular Air Card IT Laptop facilities without network connectivity. Most facilities are 1,137 covered and impact on operations is negligible. Express Meter License Monitoring software Recent upgrade to Class application now monitors license 113 usage. Fleet International annual maintenance Software replaced by CarteGraph mid 2011 695 Net Tracker has become problematic with providing 10 Net Tracker annual maintenance accurate web site statistics. Switched to AWStats which is 348 maintained and supported by in house staff. Current Police budget includes funding for Police Officer Speed Shift annual support and maintenance Scheduling Software (POSS) which will replace this 180 application. Current support agreement expires on 07 -31 -11 and will VeriPic annual support and maintenance not be renewed as Police are no longer using the 2,011 application. Pervasive software annual maintenance Upgrade to SQL version of the CounterPoint application 530 no longer uses this software. Quark Express annual maintenance InDesign application provides this functionality 422 Front Page annual maintenance InDesign application provides this functionality 187 Human Resources 11 Microsoft upgrade Purchase deferred contingent upon outcome of comparison 901 with open systems. Exhibit A (Cont.) General Fund Notes Note Program and services Impact of program or service reduction or Effective elimination I Aril 1, 2011 Police The Police Department Records Technician ($27,982) to 12 Records Technician be hired effective July 1, 2011. Financing to be provided (27,982) by a donation by Council Member Matt Little ($4,332) and General Fund balance ($23,650). Fire Operations adjustments Waste disposal. Reduce Fire Station 3 waste costs by 355 reducing to a 90 gallon service verses a one yard dumpster. Operations adjustments Reduce Fire Station 4 waste costs by reducing to a 90 355 gallon service verses a one yard dumpster. Assistant Fire Chief is not filled currently with a change in department command structure. The duties and responsibilities have been reassigned to the three district Assistant Fire Chief Pay chief positions. The Assistant Fire Chief position will not 7,610 be filled currently but will be a position to be filled as a 13 fulltime position when department training, operation, and budeet demonstrate the need. Position Currently not filled/ Position is not being filled Assistant Training Officer Position with change in department organization duties reassigned 3,803 �to Station Lieutenants Public Information Officer position was reduced to On Public Information Officer position change Call Host with a reduction in pay scale to an engineer 1,281 Engineering Microsoft upgrade Purchase deferred contingent upon outcome of comparison 2,403 with open systems. Car washes is 100% eliminated. 50 Print Public Information 850 14 Office Supplies reduced by 30% 300 Operations adjustments Miscellaneous expenses 100% eliminated. 100 Safety supplies used by inspectors in the field will be 100 100% eliminated. Protective clothing for field inspections will be 100% 130 Exhibit A (Cont.) General Fund Notes Note Program and services Impact of program or service reduction or Effective elimination I April l 2011 Parks, Recreation and Arts Center Purchase deferred contingent upon outcome of comparison 1,802 with open systems. (Recreations) Microsoft upgrade Purchase deferred contingent upon outcome of comparison 601 with open systems. (Arts) MPSA (MN Park Supervisors Assoc.) & MSTMA (MN Sports Turf Managers Assoc.) No dues 115 required this year as the two groups merged. 15 Office supplies 500 Operations adjustments Forms / printing 25 Computer supplies 250 Print public information 220 Professional Services were used for survey questions. No 500 surveys are proposed in 2011 or 2012. Grand Total Exhibit B 2011 COMMUNICATIONS FUND BUDGET Revenues Franchise fee State -aid pensions Charges for services Investment income Total Revenues Expenditures Personnel services Commodities Other charges and services Capital outlay Total Expenditures Transfers Transfer to General Fund Transfer to Compensation Liability Fund Total Transfers Net Change in Fund Balance Fund Balance, January 1 Fund Balance, December 31 2011 2011 ADOPTED AMENDED BUDGET ADJUST BUDGET NOTES $ 582,215 $ - $ 582,215 516 516 12,000 12,000 3,338 - 3,338 598,069 - 598,069 316,847 316,847 9,216 9,216 81,505 (3,078) 78,427 2 21,281 (1,502) 19,779 1 428,849 (4,580) 424,269 (42,551) - (42,551) (14,456) - (14,456) (57,007) - 57,007 112,213 4,580 116,793 663,555 - 663,555 $ 775,768 $ 4,580 $ 780,348 Exhibit B (Copt.) Communications Fund Notes Note Program and services Impact of program or service reduction or Effective elimination April l 2011 1 Microsoft upgrade Home cable TV service for Telecommunications 2 Commission members Purchase deferred contingent upon outcome of comparison with open systems. $ 1,502 City no longer provides this service. Reduction represents budget $(3,400) less actual expenses incurred 3,078 thru 3/31/2011. Grand Total $ 4,580 Exhibit C 2011 ENVIRONMENTAL RESOURCES FUND BUDGET Revenues Intergovernmental revenue State -aid pensions Dakota County Landfill Abatement grant Surface water fees Investment income Total Revenues Expenditures Personnel services Commodities Other charges and services Capital outlay Total Expenditures Transfers Transfer from Liquor Fund Transfer to General Fund Transfer to Compensation Liability Fund Transfer to Utility Fund Water Operation (Utility billing admin) Sanitary Sewer Operation (Utility billing admin) Sanitary Sewer Operation (vactor overhead) Total Transfers Net Change in Fund Balance Fund Balance, January 1 Fund Balance, December 31 2011 2011 ADOPTED AMENDED BUDGET ADJUST BUDGET NOTES $ 292 $ - $ 292 41,900 41,900 667,895 667,895 2,010 - 2,010 712,097 - 712,097 203,740 203,740 29,760 29,760 419,844 419,844 3,947 (601) 3,346 1 657,291 (601) 656,690 976 (151,991) (810) 976 (151,991) (810) (26,248) (26,248) (16,460) (16,460) (2,236) - (2,236) (196,769) - 196,769 (141,963) 601 (141,362) 500,565 - 500,565 $ 358,602 $ 601 $ 359,203 Exhibit C (Cont.) Environmental Resources Fund Notes Note Program and services Impact of program or service reduction or Effective elimination April l 2011 1 Microsoft upgrade Purchase deferred contingent upon outcome of $ 601 comparison with open systems. Grand Total $ 601 Exhibit D 2011 EQUIPMENT FUND BUDGET 2011 ADOPTED BUDGET Revenues General property taxes ALF Ambulance distribution Investment income Miscellaneous Total Revenues $ 554,377 $ 39,628 5,000 73,625 672,630 Expenditures Information systems Police Fire Streets Parks Total Expenditures Transfers Transfer from Liquor Fund Net Increase /(Decrease) Fund Balance, January 1 Fund Balance, December 31 2011 AMENDED ADJUST BUDGET NOTES $ 554,377 39,628 5,000 73,625 672,630 87,407 87,407 716,328 (15,031) 701,297 1 225,279 (4,505) 220,774 2 974,601 (3,003) 971,598 3 376,097 (2,703) 373,394 4 2,379,712 (25,242) 2,354,470 685,329 - 685,329 (1,021,753) 25,242 (996,511) 1,579,384 - 1,579,384 $ 557,631 $ 25,242 $ 582,873 Exhibit D (Coat.) Capital Projects - Equipment Fund Notes Note Program services 2 3 4 MS Office purchase deferred contingent upon outcome of comparison with Open Systems Department Effective April 1, 2011 Police $ 15,031 Fire 4,505 Streets 3,003 Parks 2,703 Grand Total $ 25,242 Exhibit E 2011 LIQUOR FUND BUDGET Sales and cost of sales Sales Cost of sales Gross profit Operating expenses Personnel services Commodities Other charges and services Total Expenditures Non - operating items Intergovernmental revenue Investment income Bond current principal Interest and bond expense Capital outlay Transfers to General Fund Special Revenue Enviro Res. Fund Debt Service: Property Taxes Fund HRA Lease Rev. Fund Capital Projects Equipment Fund Total non - operating (net) Change in working capital Working capital, January 1 Working capital, December 31 2011 2011 ADOPTED AMENDED BUDGET ADJUST BUDGET $ 14,913,405 $ - $ 14,913,405 11,164,822 - 11,164,822 3,748,583 - 3,748,583 1,313,785 1,313,785 57,794 (933) 56,861 847,286 (3,078) 844,208 2,218,865 (4,011) 2,214,854 3,900 3,900 63,600 63,600 (150,000) (150,000) (178,254) (178,254) (14,000) (14,000) (144,950) (144,950) (976) (976) (100,000) (100,000) (185,320) (185,320) (685,329) - (685,329) (1,391,329) - (1,391,329) 138,389 4,011 142,400 6,073,242 - 6,073,242 $ 6,211,631 $ 4,011 $ 6,215,642 NOTES 2 1,3 Exhibit E (Coa) Liquor Fund Notes Note I Program and services Impact of program or service reduction or elimination Effective April 1, 2011 Microsoft upgrade Purchase deferred contingent upon outcome of comparison with open systems. This has been an on -going reward we have been Elimination of suckers we hand out to children handing out for more than 25 years. While it doesn't increase business, it is a manner in which we have used to attain children's attention awav from class Elimination of advertisement in Chamber booklet This would have very little affect on the Liquor business. 2,403 933 675 Grand Total $ 4,011 Exhibit F 2011 UTILITYFUND WATER, SANITARYSEWEk AND STREET LIGHT OPERATING BUDGET Operating revenues User charges for services Other Total operating revenues Operating expenses Personnel services Commodities Other charges and services Disposal charges Total Expenditures Operating income Non - operating items Intergovernmental revenue Investment income Capital outlay Transfers from (to) Special Revenue Enviro. Res. Fund General Fund Capital Projects Water Fund Total non - operating (net) Change in working capital Working capital, January 1 Working capital, December 31 2011 2011 ADOPTED AMENDED BUDGET ADJUST BUDGET NOTES $ 8,121,475 $ - $ 8,121,475 204,309 - 204,309 8,325,784 - 8,325,784 1,548,861 1,548,861 389,755 389,755 2,842,196 2,842,196 2,950,490 - 2,950,490 7,731,302 - 7,731,302 594,482 - 594,482 3,264 3,264 130,727 130,727 (146,979) 56,504 (90,475) 1,2 44,944 44,944 (271,725) (271,725) (1,200,000) - (1,200,000) (1,439,769) 56,504 (1,383,265) (845,287) 56,504 (788,783) 10,133,572 - 10,133,572 $ 9,288,285 $ 56,504 $ 9,344,789 Exhibit F (cont.) Utility Water and Sanitary Sewer Operating Fund Capital Outlay - Building & Equipment Notes Effective Note Factors to Consider April 1, 2011 Funds are for improvements and updates to the WTF meeting room. These improvements may include ceiling tile to replace those damaged by 1 Water Treatment Facility (WTF) water, carpeting to replace the 14 year old stained and worn carpeting, $ 50 000 meeting room improvements tables and chairs to replace the 14 year old tables and chairs, overhead ' lights to improve energy efficiency, and/or audio visual equipment to update the facility's capabilities. Project deferred until 2012. Purchase deferred contingent upon outcome of comparison with open 2 Microsoft Office Upgrade - 6,504 Grand Total $ 56,504