Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
07-19-10 CC WS AgP
CITY OF SHOREWOOD CITY COUNCIL WORK SESSION MONDAY, JULY 19, 2010 AGENDA I. CONVENE CITY COUNCIL WORK SESSION A. Roll Call Mayor Lizee _ Bailey_ Turgeon _ Woodruff_ B. Review Agenda Zerby _ 2. 2011 BUDGET 3. CAPITAL IMPROVEMENT PROGRAM 5755 COUNTRY CLUB ROAD CITY HALL 5:30 P.M. Attachments Administrator's Memo, Budget CIP • I DATE: July 14, 2010 547BJEC'r: 2014 Budget Draft #3 Attached to this memorandum is the third revision of the 2011 General Fund Budget. I made the following changes: 1. Provided a sheet titled "Scenarios." This sheet shows the impact of a levy with no increase, a scenario with no increase and no transfer from the Liquor fund or use of reserves, and with levy increases of 1, 1.5, and 2 percent increases. This is the best tab to look at for a complete summary. 2. 1 included a draw down from the general fund reserves of $160,000 and kept the planned transfer from the Liquor funds at $40,000. 3. 1 removed the $30,000 for a City Hall monument sign and entry signs to the city; I placed $3,200 in Streets and Roads to cover standard highway signs per discussion at the 7/12 meeting. 4. 1 provided a separate line for Prosecuting and Civil attorney and researched past billings to arrive at actual amounts paid for 2007, 2008, 2009, and 2010 to date. I estimated the "budget" amount based on retainer and additional fees charged. 5. 1 separated the EFD costs from the Mound Fire costs again based on billings from each department. The 2011 Draft 3 is a bit more than other drafts as the majority of the 2011 costs initially indicated covered the EFD costs and not much was left to cover the Mound Contract. Overall, the anticipated 2011 amount for fire protection is just over 2 %. 6. 1 updated the Southshore center information. Based on current activity, the amount projected for revenue in 2011 is not out of line. In fact, if we were to remove the labor allocation, we would be very close to break even. 7. 1 reviewed each account and line and I am pretty sure all tie -out and represent current best estimates for expenditures based on current need in order to continue to provide our current level of service. I also reviewed and adjusted the year -end projections. If there are errors in formulas, I apologize. 8. 1 adjusted transfers to the capital funds as follows: a) I decreased the equipment fund for 2011 to $50,000 and increased it to $75,000 for'12, '13, and '14. 1 moved it back to $100,000 for the balance of the program. The balance hits a few low points during this time. To address this, staff needs to refine the program to stay within the allocation. b) I increased the local road fund by $50,000 in 2011 and another $25,000 in 2013 — 2014. 2015 and 2016 have $800,000 allocations and $825,000 for the balance of the 10 years. The fund hits a deficit in 2016 under this scenario. c) I kept the 2011 allocation to the parks at the current $42,000, although I do feel it should be increased back to $45,000. 1 bumped the amount to $45,000 for 2012 — 2015 and then to $50,000 for the balance of the 10 year period. One reason for doing this is the need to have funds available to reconstruct tennis courts. Badger, Manor and Cathcart all have tennis courts and to reconstruct a two court facility is at least $200,000. As the courts are all 25 — 30 years old, reconstruction in the next 10 years is very likely. The other option to funding these major projects in the park or on the road program is to access the community infrastructure fund, but that means adjusting (adding to) the transfer to cover the payment to the infrastructure fund. Outstanding Issues To use, or not to use reserves...., that is a really good question. If reserves are used, which fund(s) are tapped, how much is taken, and what are the dollars used to support? Based on current revenue and expenditure projections, a levy of $4,180,973 is needed. The current $4,774,672 levy covers all operations and leaves $599,824 for transfers to desired improvement funds. Considering our current plan calls for $842,000 in transfers, the city is a bit short. The possible use of various balances can fill this gap as can changes in programmed transfers or changes to planned projects. The Council has access to two main balances; the general fund undesignated reserve and the proceeds from the sale of the liquor stores. The fund balance policy requires the city maintain an undesignated reserve in the general fund between 55% and 60% of budgeted expenditures. For 2011 this means between $2,961,336 on the low end and $3,230,549 on the high end. The 2009 audited balance is $3,555,724 or 66% of the 2010 general fund budget and 66% of the current 2011 draft general fund budget. The liquor fund contains a balance of $868,476. The issue with this fund is what to do with it. As indicated in previous memos, the council is divided on the use of this money. Staff is willing to prepare a brief article along with a survey on the web page for residents to indicate their preference on the disposition of these funds if so directed by the Council. The past budgets include allocations from this fund in the amount of $40,000 based on the anticipated interest earnings. The 2010 budget provides an $18,000 allocation. 2. Levy increase, or not. Staff provided several scenarios for the Council to consider regarding the levy — from no increase to a 2% increase. Increasing the levy reduces the need to draw on other balances, unless there is a desire to increase the amount moved to dedicated improvement funds. What is the Councils desire on the 2011 levy? 3. Transfers to improvement funds. The city has three main improvement funds — Local Roads, Parks, and Equipment. The local road fund supports the reconstruction and on- going maintenance of local roads. The 20 year plan as currently programmed will deplete this fund by 2016 if no changes are made to the current transfer amount of $700,000; the city borrows from itself, or through bonding. Furthermore, if the 20 year plan continues, general maintenance will take the entire transfer amount. The equipment fund has a healthy balance at the present time and looks to be fully funded for the next several years. The question is if this fund can withstand a reduction in the amount transferred and still have adequate funds to replace needed equipment. Staff needs to be challenged to evaluate all the equipment in great detail and determine what equipment is essential so the department can deliver the required services. The current transfer amount to this fund is $100,000 and the prior year was $175,000. The park fund receives $42,000 per year to support improvements to the city's parks. The council increased the allocation from $15,000 to $45,000 for the 2009 budget and then decreased the transfer to $42,000 for the 2010 budget. The Park Commission developed an aggressive improvement plan that, in its present form, depletes the fund relatively quickly. As a result, the commission is revising and reprioritizing projects. Based on current balances, discussions at Council, and priorities, the council should consider increasing the transfers to the local road fund and I suggest the Council consider adding $3,000 to the park transfer bringing it back to the $45,000 allocated in 2009. BUDGET DRAFT 3 JULY 19, 2010 WORK SESSION Actual Budget Through June Projected No 1% levy 1.5% levy 2% levy No lncrase n,n vow. c.,a 1 - -- Inrraava Increase Increase No Transfers REVENUE SOURCE Taxes Licenses and permits Intergovernmental Aid Charges for Service Fines and Forfietures Miscellaneous Revenue Southshore Community Cntr Transfers TOTAL GENERAL FUND REVENUE 4,703,368 4,776,292 1,674,500 4,723,119 127,883 106,270 67,319 92,820 66,411 65,000 32,324 69,400 41,649 46,000 67,124 38,650 52,968 55,000 15,551 53,000 82,755 128,000 32,107 76,200 36,639 44,930 24,590 56,100 40,000 38,842 - 34,557 5,151,673 5,260,334 1,913,516 5,143,846 4,774,672 98,200 64,500 36,075 50,000 63,900 57,100 40,000 5,184,447 4,816,259 98,200 64,500 36,075 50,000 63,900 57,100 40,000 5,226,034 4,837,052 98,200 64,500 36,075 50,000 63,900 57,100 40,000 5,246,827 1 4,857,845 98,200 64,500 36,075 50,000 63,900 57,100 40,000 5,267,620 4,774,672 98,200 64,500 36,075 50,000 63,900 57,100 - 5,144,447 EXPENDITURES City Council 66,015 64,194 28,401 61,994 83,881 83,881 83,881 83,881 83,881 Administration 157,234 154,362 70,206 147,923 147,588 147,588 147,588 147,588 147,588 General Government 275,662 236,419 116,468 241,834 276,110 276,110 276,110 276,110 276,110 Elections 2,889 38,939 7,053 38,939 7,081 7,081 7,081 7,081 7,081 Finance 180,267 193,784 94,070 141,550 166,749 166,749 166,749 166,749 166,749 Professional Services 223,859 199,000 147,155 192,000 205,000 205,000 205,000 205,000 205,000 Planning 206,603 198,960 86,412 188,618 189,661 189,661 189,661 189,661 189,661 Municipal Buildings 263,476 373,800 55,277 369,713 292,261 292,261 292,261 292,261 292,261 Police 1,176,929 1,180,000 588,988 1,180,000 1,226,550 1,226,550 1,226,550 1,226,550 1,226,550 Fire 600,450 602,159 291,687 604,046 608,245 608,245 608,245 608,245 608,245 Protective Inspections 126,268 125,143 54,114 117,457 115,796 115,796 115,796 115,796 115,796 City Engineer 125,781 111,446 43,916 112,425 130,878 130,878 130,878 130,878 130,878 Public Works Service 558,945 512,985 176,324 472,278 350,747 350,747 350,747 350,747 300,547 Streets and Roads 850,247 904,107 71,282 899,582 982,459 982,459 982,459 982,459 232,459 Snow and Ice Control 74,452 85,974 39,422 85,974 101,684 101,684 101,684 101,684 101,684 Traffic Control 45,703 51,049 16,838 46,025 57,149 57,149 57,149 57,149 57,149 Sanitation /weeds/ waste 2,785 4,900 7,189 8,722 6,781 6,781 6,781 6,781 6,781 Tree Maintenance 17,450 33,479 15,216 29,213 28,695 28,695 28,695 28,695 28,695 Parks and Recreation 312,406 311,381 126,367 298,048 341,308 341,308 341,308 341,308 299,308 Southshore Community Cntr 93,372 70,356 32,157 65,675 68,200 68,200 68,200 68,200 68,200 TOTAL EXPENDITURES 5,360,793 5,452,437 2,068,540 5,302,016 5,386,823 5,386,823 5,386,823 5,386,823 4,544,623 Revenue over /(under) Expenditures (209,120) (192,103) (155,024) (158,170) (202,376) (160,790) (139,996) (119,203) 599,824 Planned use of Fund Balance 160,000 160,000 1 160,000 160,000 160,000 160,000 - Funds needed to Balance 1,830 (42,376) (790) 20,004 40,797 599,824 SOUTHSHORE COMM. CNTR Revenue 36,639 44,930 33,567 56,100 57,100 Expenses 81,130 57,156 37,434 78,677 68,400 4* N Revenue ever /(under) Expenditures (44,491) (12,226) (3,867) (22,577) (11,300) a BUDGET DRAFT 3 JULY 19, 2010 WORK SESSION Increase Actual Actual Actual Budget Through June Projected Draft 3 Percent Dollar 2007to join Imn v.,ar r'nd ?nil lo,reaae Increase 2011 REVENUESOURCE Taxes Licenses and permits Intergovernmental Aid Charges for Service Fines and Forfietures Miscellaneous Revenue Southshore Community Cntr Transfers TOTAL GENERAL FUND REVENUE 4,332,741 256,472 95,901 50,819 77,777 286,685 - 40,000 5,140,395 4,582,602 195,419 78,155 50,753 53,369 176,535 - 40,000 5,176,833 4,703,368 127,883 66,411 41,649 52,968 82,755 36,639 40,000 5,151,673 4,776,292 106,270 65,000 46,000 55,000 128,000 44,930 38,842 5,260,334 1,674,500 67,319 32,324 67,124 15,551 32,107 24,590 - 1,913,516 4,723,119 92,820 69,400 38,650 53,000 76,200 62,175 34,557 5,149,921 4,774,672 98,200 64,500 36,075 50,000 63,900 61,100 40,000 5,188,447 0.0% -7.6% -0.8% -21.6% -9.1% -50.1% 36.0% 3.0% -1.4% (1,620) (8,070) (500) (9,925) (5,000) (64,100) 16,170 1,158 (71,887) 10.20% - 61.71% - 32.74% - 29.01% - 35.71% - 77.71% 0.00% 0.00% EXPENDITURES City Council 63,319 69,721 66,015 64,194 28,401 61,994 83,881 30.7% 19,687 32.47% Administration 149,179 229,292 157,234 154,362 70,206 147,923 147,588 -4.4% (6,774) -1.07% General Government 243,848 225,969 275,662 236,419 116,468 241,834 276,110 16.8% 39,691 13.23% Elections 2,894 47,532 2,889 38,939 7,053 38,939 7,081 -81.8% (31,858) 144.68% Finance 174,495 164,651 180,267 193,784 94,070 141,550 166,749 -14.0% (27,035) -4.44% Professional Services 196,880 213,220 223,859 199,000 147,155 192,000 205,000 3.0% 6,000 4.12% Planning 184,855 206,595 206,603 198,960 86,412 188,618 189,661 -4.7% (9,299) 2.60% Municipal Buildings 316,646 201,372 263,476 373,800 55,277 369,713 292,261 -21.8% (81,539) -7.70% Police 1,072,529 1,139,063 1,176,929 1,180,000 588,988 1,180,000 1,226,550 3.9% 46,550 14.36% Fire 595,947 622,935 600,450 602,159 291,687 604,046 608,245 1.0% 6,086 2.06% Protective Inspections 128,142 137,784 126,268 125,143 54,114 117,457 115,796 -7.5% (9,347) -9.63% City Engineer 132,998 147,576 125,781 111,446 43,916 112,425 130,878 17.4% 19,432 -1.59% Public Works Service 605,007 588,605 558,945 512,985 176,324 472,278 350,747 -31.6% (162,238) - 42.03% Streets and Roads 516,221 842,434 850,247 904,107 71,282 899,582 982,459 8.7% 78,352 90.32% Snow and Ice Control 69,188 68,606 74,452 85,974 39,422 85,974 101,684 183% 15,710 46.97% Traffic Control 39,276 46,537 45,703 51,049 16,838 46,025 57,149 11.9% 6,100 45.51% Sanitation /weeds /waste 4,459 9,735 2,785 4,900 7,189 8,722 6,781 38.4% 1,881 52.07% Tree Maintenance 29,598 24,350 17,450 33,479 15,216 29,213 28,695 -14.3% (4,784) -3.05% Parks and Recreation 215,920 244,254 312,406 311,381 126,367 298,048 341,308 9.6% 29,927 58.07% Southshore Community Cntr - - 93,372 70,356 32,157 65,675 68,200 -3.1% (2,156) TOTAL EXPENDITURES 4,741,401 5,230,231 5,360,793 5,452,437 2,068,540 5,301,016 5,386,823 -1.2% (65,614) 13.61% Revenue over /(under) Expenditures 398,994 (53,398) (209,120) (192,103) (155,024) (152,095) (198,376) Planned use of Fund Balance 160,000 160,000 160,000 Funds needed to Balance (38,376) SOUTHSHORE COMM. CNTR Revenue - - 36,639 44,930 33,567 56,100 57,100 27.1% 12,170 5112% Expenses - - 81,130 57,156 37,434 78,677 68,400 193% 11,244 Revenue over /(under) Expenditures - - ( 44 . 491 ) (12,226) (3,867) (22,577) (11,300) BUDGET DRAFT 3 JULY 19, 2010 WORK SESSION Actual Actual Actual Budget To Date Projected Draft 3 Percent Dollar 2007 2008 2009 2010 2010 Year End 2011 Increase Increase EXPENDITURES CITYCOUNCIL Personnel 16,794 16,255 16,794 16,794 8,397 16,794 16,800 0.04% 6 Materials and Supplies 1,402 2,478 3,064 1,200 550 1,200 1,300 8.33% 100 Support Services and Charges 45,123 50,988 46,157 46,200 19,454 44,000 65,781 42.38% 19,581 Capital TotalCity Council - 63,319 - 69,721 - 66,015 - 64,194 - 28,401 - 61,994 - 83,881 0.00% 30.67% - 19,687 Administration Personnel 144,630 227,601 149,286 147,712 66,908 143,332 142,828 -3.31% (4,884) Materials and Supplies - 81 40 - - - - 0.00% - Support Services and Charges 4,549 1,610 7,908 4,150 1,667 2,960 4,760 14.70% 610 Capital - - 2,500 1,631 1,631 - - 100.00% (2,500) Total City Administration 149,179 229,292 157,234 154,362 70,206 147,923 147,588 -4.39% (6,774) GENERAL GOVERNMENT 192,411 177,187 219,755 181,639 94,353 189,434 225,860 24.35% 44,221 Personnel Materials and Supplies 18,753 20,049 17,861 19,975 7,420 20,500 17,900 -10.39% (2,075) Support Services and Charges 32,116 28,733 31,506 32,305 13,482 30,400 32,350 0.14% 45 Capital 568 - 6,540 2,500 1,213 1,500 - - 100.00% (2,500) Total General Government 243,848 225,969 275,662 236,419 116,468 241,834 276,110 16.79% 39,691 ELECTIONS 323 37,678 840 30,689 4,752 30,689 4,781 - 84.42% (25,908) Personnel Materials and Supplies 2,540 5,120 2,024 4,950 2,193 4,950 2,300 - 53.54% (2,650) Support Services and Charges 31 4,734 25 2,700 108 2,700 - - 100.00% (2,700) 600 - 600 - -100.00% (600) Capital Total Elections - 2,894 - 47,532 2,889 38,939 7,053 38,939 7,081 181.82% (31,858) FINANCE Personnel 139,037 154,684 166,032 178,584 85,802 127,000 153,224 -14.20% (25,360] Materials and Supplies 5,337 5,914 6,953 7,700 6,745 7,750 6,950 -9.74% (750) Support Services and Charges 3,082 4,053 4,799 7,500 1,523 6,800 6,575 - 12.33% (925) Capital 27,039 174,495 - 164,651 2,483 180,267 - 193,784 - 94,070 - 141,550 - 166,749 0.00% - 13.95% - (27,035) Total Finance PROFESSIONAL SERVICES 196,880 213,220 223,859 199,000 147,155 192,000 205,000 3.02% 6,000 Support Services and Charges 196,880 213,220 223,859 199,000 147,155 192,000 205,000 3.02% 6,000 Total professional services PLANNING 169,865 192,979 195,475 193,605 81,673 183,263 178,376 -7.87% (15,229) Personnel Materials and Supplies 1,659 1,310 2,139 655 54 655 655 0.00% - Support Services and Charges 13,331 9,986 8,989 4,700 4,685 4,700 10,630 126.17% 5,930 Capital - 2,320 - - - - 0.00% - Total Planning 184,855 206,595 206,603 198,960 86,412 188,618 189,661 .4.67% (9,299) MUNICIPAL BUILDINGS 34,519 26,532 34,321 54,800 31,014 54,800 23,511 - 57.10% (31,289) Materials and Supplies 100,228 116,950 123,957 133,000 8,550 133,200 157,750 18,61% 24,750 Support Services and Charges 20,000 15,713 15,713 - - 100.00% (20,000) Capital 23,999 47,900 - 7,890 5,425 106,000 - 106,000 111,000 4.72% 5,000 Bond Payments 110,000 50,000 99,773 60,000 - 60,000 - - 100.00% (60,000) Transfers Total Municipal Buildings 316,646 201,372 263,476 373,800 55,277 369,713 292,261 - 21.81% (81,539) POLICE - 0.00/ - Materials and Supplies 59 822,962 - 895,059 - 943,989 - 950,000 - 474,954 - 950,000 996,550 4.90% 46,550 Support Services and Charges 249,508 244,004 232,940 230,000 114,034 230,000 230,000 0.00% - Capital Total Police 1,072,529 1,139,063 1,176,929 1,180,000 588,988 1,180,000 1,226,550 3.94% 46,550 FIRE Support Services and Charges 291,368 319,411 323,180 322,535 155,372 324,422 337,548 4.65% 15,013 Capital 304,579 303,524 277,270 279,624 136,314 279,624 270,697 -3.19% (8,927) Total Fire 595,947 622,935 600,450 602,159 291,687 604,046 608,245 1.01% 6,086 PROTECTIVE INSPECTIONS 118,167 130,391 119,185 117,943 52,099 110,257 109,096 -7,50% (8,847) Personnel 291 5 139 400 22 400 300 - 25.00% (100) Materials and Supplies 9,684 7,388 5,646 6,800 1,993 6,800 6,400 -5.88% (400) Support Services and Charges Z_ BUDGET DRAFT JULY 19, 2010 WORK SESSION Actual Actual Actual Budget To Date Projected Draft 3 Percent Dollar 2007 2008 2009 2010 2010 Year End 2D 11 Increase Increase Capital - 1,298 - - - - 0.00% - Total Protective Inspections 128,142 137,784 126,268 125,143 54,114 117,457 115,796 -7.47% (9,347) CITY ENGINEER Personnel 119,803 124,018 114,547 94,875 40,494 95,854 111,103 17.10% 16,228 Materials and Supplies 1,485 688 742 425 44 425 1,255 195.29% 830 Support Services and Charges 9,184 7,505 7,638 15,145 3,334 15,146 12,820 - 15.36% (2,326) Capital 2,526 15,365 2,854 1,000 44 1,000 5,700 470.00% 4,700 Total City Engineer 132,998 147,576 125,781 111,446 43,916 112,425 130,878 17.44% 19,432 PUBLIC WORKS SERVICES Personnel 292,022 295,616 279,601 295,372 123,491 261,936 184,107 - 37.67% (111,265) Materials and Supplies 70,206 77,289 58,801 71,123 28,563 63,400 68,200 4.11% (2,923) Support Services and Charges 42,140 40,700 40,540 42,690 24,270 43,142 41,440 -2.93% (1,250) Capital 639 - 5,003 3,800 - 3,800 7,000 84.21% 3,200 Transfers 200,000 175,000 175,000 100,000 - 100,000 50,000 - 50.00% (50,000) Total Public Works Services 605,007 588,605 558,945 512,985 176,324 472,278 350,747 - 31.63% (162,238) STREETS AND ROADS Personnel 87,344 100,157 69,846 95,607 43,209 95,607 113,459 18.67% 17,852 Materials and Supplies 66,260 62,993 53,168 85,000 27,647 85,050 85,000 0.0D% - Support Services and Charges 17,617 14,284 27,233 23,500 42S 15,725 34,000 44.68% 10,500 Capital - - - - - 3,200 - 0.00% - Transfers 345,000 645,000 700,000 700,000 - 700,000 750,000 7.14% 50,000 Total Streets and Roads 516,221 842,434 850,247 904,107 71,282 899,582 982,459 8.67% 78,352 SNOW AND ICE CONTROL Personnel 33,959 33,875 35,995 40,857 26,828 40,857 56,567 38.45% 15,710 Materials and Supplies 35,229 34,731 38,457 45,117 12,594 45,117 45,117 0.00% - SupportServicesandCharges - - - - - - - D.00% - Capital - - - - - - - 0.00% - Total Snow and ice Control 69,188 68,606 74,452 85,974 39,422 85,974 101,684 18.27% 15,710 TRAFFIC CONTROL Personnel 356 - - - - - - 0.00% - Materials and Supplies 4,067 2,873 3,412 6,000 146 6,000 5,000 - 16.67% (1,000) Support Services and Charges 34,853 43,664 42,291 45,049 16,692 40,025 52,149 15.76% 7,100 Total Traffic Control 39,276 46,537 45,703 51,049 16,838 46,025 57,149 11.95% 6,100 SANfTATION /WEEDS /WASTE REMOVAL Personnel 2,668 2,005 2,764 - 3,979 4,322 2,281 0.00% 2,281 Materials and Supplies - 32 21 500 - - 100 - 80.00% (400) Support Services and Charges 1,791 7,698 - 4,400 3,210 4,400 4,400 0.00% - Total Sanitation /Weeds /Waste Removal 4,459 9,735 2,785 4,900 7,189 8,722 6,781 38.39% 1,881 TREE MAINTENANCE 17,801 19,042 7,512 17,279 9,056 16,288 14,020 - 18.86% (3,259) Personnel Materials and Supplies 502 333 437 2,700 34 675 1,425 - 47.22% (1,2751 Support Services and Charges 11,295 4,975 9,501 13,500 6,126 12,250 13,250 -1.85% (250) Total Tree Maintenance 29,598 24,350 17,450 33,479 15,216 29,213 28,695 - 14.29% 14,784) PARKS AND RECREATION Personnel 126,592 139,162 147,532 160,481 72,205 147,748 185,708 15.72% 25,227 Materials and Supplies 8,836 14,810 10,094 16,300 7,360 12,300 20,800 27.61% 4,500 Support Services and Charges 55,492 75,282 109,780 92,600 46,802 96,000 92,800 012% 200 Capital 10,000 - - - - - - 0.00% - Transfers 15,000 15,000 45,000 42,000 - 42,000 42,000 0.00% - Total Parks and Recreation 215,920 244,254 312,406 311,381 126,367 298,048 341,308 9.61% 29,927 Southshore Center Personnel - - - - 8,180 16,157 - Materials and Supplies - - 12,241 13,200 3,953 8,000 8,300 Support Services and Charges - - 55,203 43,956 25,302 54,520 60,100 Capital - - 13,686 - - - - TotalSouthshare Center - - 81,131 57,156 37,434 78,677 68,400 - GENERAL FUND TOTAL EXPENDITURES 4,741,401 5,230,231 5,348,551 5,439,137 2,073,817 5,315,018 5,387,023 -0.96% (52,214) REVENUE OVER / (UNDER) EXPENDITURES 398,994 (53,398) (196,878) 078,903) (151,324) (171,172) (202,576) 13.23% (23,673) _q_ city Council Fund! 303 General Department 41110 BUDGETCOMMENTS: MAYORANDCOUNCIL Code # 103 Council Salaries: Mayor $300 /mo, Council $2501mo 122 City's portion of FICA tax 245 Awards and raise. supplies; Council Photos Actual Actual 331 Actual Budget To Date Projected Draft PERSONAL SERVICES 2007 2008 2009 2010 2010 Year End 2011 PART -TIME Excelsior Chamber of Commerce July 4th 15,600 $ 15,100 $ 15,600 $ 15,600 $ 7,800 $ 15,600 $ 15,600 PERA CONTRIB - CITY SHARE $ - $ - $ S - $ $ - It FICA CONTRIB - CITY SHARE $ 1,194 $ 1,155 $ 1,194 S 1,194 $ 597 $ 1,194 $ 1,200 TOTAL PERSONAL SERVICES $ 16,794 $ 16,255 $ 16,794 $ 16,794 $ 8,397 $ 16,794 $ 16,800 MATERIALS & SUPPLIES GENERAL SUPPLIES $ 1,402 IS 2,478 $ 3,064 $ 1,200 $ 550 $ 1,200 $ 1,300 TOTAL MATERIALS & SUPPLIES $ 1,402 $ 2,478 $ 3,064 $ 1,200 $ 550 $ 1,200 $ 1,300 SUPPORT SERVICES /CHARGES CONSULTING FEES 5 - 5 - $ $ - $ S $ - TRAVEL,CONFERENCE &SCHOOLS $ 4,031 $ 4,931 $ 2,968 $ 3,500 $ 83 $ 1,500 5 3,500 PRINTING AND PUBLISHING $ - S 24 $ - $ CONTRACTUAL SERVICES $ - $ 3,640 $ - $ RENTALS S - S $ $ - $ DUES AND SUBSCRIPTIONS $ 41,092 $ 42,394 $ 43,190 $ 42,700 $ 19,371 $ 42,500 $ 43,169 MISC SERVICES /CONTINGENCY $ - 5 - 5 - $ - S - $ - $ 19,112 TOTAL SUPPORT SERVICES /CHARGES $ 45,123 $ 50,988 $ 46,157 $ 46,200 $ 19,454 $ 44,000 $ 65,781 TOTAL Council $ 63,319 $ 69,721 $ 66,015 $ 64,194 Is 28,401 $ 61,994 $ 83,881 BUDGETCOMMENTS: MAYORANDCOUNCIL Code # 103 Council Salaries: Mayor $300 /mo, Council $2501mo 122 City's portion of FICA tax 245 Awards and raise. supplies; Council Photos 302 Consulting 331 Travel, Conferences, Schools Appreciation Activities 351 400 433 Subscriptions & Memberships Lake Minnetonka Conservation District (LMCD) Assn of Metro Cities League of MN Cities Excelsior Chamber of Commerce July 4th AIS - Lake Weed Treatment (moved to Parks Ops) Metropolitan Mayors Other 440 Contingency for non -union wage adjustments DEPT 41110 2011 Budget 1,200 0 1,000 2,500 31,242 3,032 6,375 2,500 0 20 0 43,169 19,112 0 Percent Dollar increase Increase D.oO% 0 0.00% 0 050% 6 0.04% 6 8.33% 100 8.33% 100 0.00% 0.00% 0.00% 0,00% 0.00% 1.57% 0.00% 42.38% 0 0 0 0 0 469 19,112 19,581 30.67% 2010 Budget 1,200 0 1,000 2,500 31,026 3,032 6,415 2,200 0 0 100 42,773 0 19,687 0 r ADMINISTRATION Fund: General Department: 41300 PERSONAL SERVICES FULL -TIME REGULAR FULL -TIME OVERTIME PART -TIME OTHER SEVERANCE PAY PERA /ICMA CONTRIB - CITY SHARE FICA CONTRIB - CITY SHARE EMPLOYEE INSURANCE - CITY SHAR UNEMPLOYMENT COMPENSATION WORKERS COMPENSATION TOTAL PERSONAL SERVICES MATERIALS & SUPPLIES MAINTENANCE OF EQUIPMENT' GENERAL SUPPLIES TOTAL MATERIALS & SUPPLIES SUPPORT SERVICES /CHARGES COMMUNICATIONS - TELEPHONE TRAVEL, CONFERENCE & SCHOOLS CONTRACTUAL SERVICES DUES AND SUBSCRIPTIONS MISC SERVICES TOTAL SUPPORT SERVICES /CHARGES CAPITAL OUTLAY MACHINERY & EQUIPMENT FURNITURE AND FIXTURES OTHER IMPROVEMENTS TOTAL CAPITAL OUTLAY TOTAL Administration Actual Actual Actual Budget To Date Projected Draft 3 Percent Dollar 2007 2008 2009 2010 2010 Year End 2011 Increase Increase 116,182 178,219 115,076 113,537 53,075 113,537 113,539 0.00% 2 0.00% - _ - - - - - 0.00% _ - - - - - 0.00% 0.00% 7,091 10,519 7,767 7,948 3,700 7,948 8,232 3.57% 284 8,668 13,558 8,680 8,686 3,919 8,686 8,686 0.00% - 12,690 20,132 11,398 17,541 4,451 1.1,398 12,371. - 29.47% 973 - 5,173 6,365 - 1,763 1,763 - 0.00% (1,763) - - - - 0.00% - 144,630 227,601 149,286 147,712 66,908 143,332 142,828 -3.31% (504) 81 40 81 40 BCD% 0.00% 0.00% 356 78 944 1,000 3,975 1,035 1,618 2,200 49 125 4,305 - 169 372 1,042 950 4,549 1,610 7,908 4,150 - - - 2,500 - - - 2,500 149,180 229,292 157,234 154,362 480 960 960 -4.00% - 385 1,000 2,700 22.73% 1,700 - - 0.00% - 802 1,000 1,100 15.79% 100 - - - 0.00% - 1,667 2,960 4,760 14.70% 1,800 1,631 1,631 - - 100.00% (1,631) - - 0.00% - - 0.00% 1,631 1,631 - - 100.00% (1,631) 70,206 147,923 147,588 -0.23% (335) -6- BUDGET COMMENTS: ADMINISTRATION -7- DEPT 41300 Bud Bud Code 4 2011 2010 101 Personnel:1 ETE Administrator, .25 FTE Executive Scretary = Salary and benefits 142,828 147,712 No salary incrase, benefits increase included Salary performacned based part of merit pool located In Council Contingency Materials and Supplies 245 Books &Mist Supplies 0 0 No planned reimbursment request for books and materials General supplies allocated to General Govt Support services and charges 321 Cell Phone remibursment for base Blackberry Plan only, no fees or taxes included. 960 1000 Employee owns phone 331 Travel /conferneces and Schools: reimbursment for milage to meetings and events 2,700 2200 average about $55.00 per month in image. Conferences include LMC and MCMA annual conference, travel, meals, lodging approximatley 1200 1 regional or nataional conference approximately $1,900 400 Consulting Svcs. 0 0 433 Subscriptions & Memberships 1,100 950 ICMA = % based on salary approximately 800 MCMA = 125 MAMA = 40 IPMA = 150 540 Capital - no capital expenditures planned in 2011 0 2500 -7- GENERAL GOVERNMENT FUND: General Depanmem:41400 SLA GET COMMENTS: GENERAL GOVERNMEREI CLERK DEPT 41400 Code IS 2011 2010 101 d51 personnel =Full Time MCA, Clerk @JO RE and Rudeptionlst @.20 ME, Perfume ,,,IT =GS RE 225,860 381,639 Commumwtions /r ,ding coordinator and Web maintenance @ 4 FIE. Salaries d0 not iodide increase In 2031 as funds are Included in CounCll Contingenq PA, ..D Iodides miarellonmens asuctance as needed for front desk euverage and benefits for benefit eligible part -time staff. The mcrea.. is due to Inclusion of part-time Inf ill fine. 200 - Office Supplies Actual Attugl Arum Budget To Date Proretted Draft 3 Percent Due., PERSONAL SERVICES 2001 MILE MAO Md. 2010 Year PDo 2011 Incense locic... FULL -TIME REGULAR 126,663 10"582 124L4S6 138,134 54204 94,500 11$140 '14.84% (24SM) FULL -TIME OVERTIME 13NI 412 - 0.00% - PART -TIME_ 28,201 WAM 52,529 1100 20,978 47,500 58,156 5]]5.60% 9,756 TEMPORARY REGULAR 1,000 IPN Mdean $20 TMIP /2 J m $200Twfie /200 Pat /3501uI1ef350 Pamele 750 1,200 351-P6Dting and publliblng Legal NOficee - All General Fund 0'00°6 " OTHER except Capital ProjeRs 400 �C-1.1.1 5-Imced Council Packet Delivery &Video Tape 2,400 2,400 Council Recording Secretary SEVERANCE PAY 7,600 Newsletter Mall Sewire "Midwert Dealing ASm 4,500 COde Book Web Host 200 - PERACONTMEB CITY SHARE 6455 0 11520 9,J 83 5,215 12,000 12,825 31.12% 3,044 FICA CON IB -CITY SHARE 11942 ffmas ILL. 10,690 5,721 More 13,533 2659% 2,843 EMPLOYEE ! NSURANCE - CITY SHAR FARM 11,069 EPPM 2L43C 8,236 21434 22606 5.41% 1,112 UNE MPLOYMENT COMPENSATION 25 540- Capital Equipment Computers 0 2,500 Furniture & Here, 0 0 WORKERS COMPENSATION TOTAL PERSONAL SERVICES 192411 1]7,18] 219,755 381,639 9A353 389,934 se"BAL 24.35% 44,221 MATERIALS &FEMURS OFFICE SUPPLIES ASCII 7,223 4,276 qCW 1,146 6,500 6 'N19% (L0001 POSTAGE 11,389 11,910 10,650 11,9W 4,8(32 11,900 1'000 -'56°b 19001 MAINTENANCE OF EOUIPMEM 35T - 0 w " SMALL TOOLS AND MINOR EOUIPMEN OPT/ " GENERAL SUPPLIES 2181 916 "In I,OJS 1,472 2,10) 900 46 Me" Ill51 TOTAL MATERIALS PC SUPPLIES 1"753 20,049 17,061 19,975 7,420 M 37,900 "10.39h (MEM) SGRORTAPPICES /CHARGES CONSULTING FEES - To. COMMUNICATIONS " TELEPHONE - - - - 000% ' TRAVEL CONFERENCE IS SCHOOLS LBBS A030 3.529 2950 512 1,200 2950 0.00% - PRINTING AND PUBLISHING '948 1,632 090 Con, "325 1500 2100 0.00% CONTRACTUAL SERVICES 25568 22716 MACE 27,050 11,130 27,050 29,0,0" '018% 1501 DUES AND SUBSCRIPTIONS 320 ME 993 305 515 650 409 3"15% 95 TA%EDUCENSES - - 000% ' MISS SERVICES TOTAL SUPPORT SERVICES /CHARGES 32,116 2$733 3'506 32,305 13,482 SAGM Pg Me 014% 45 CAPITAL OUDAY MACHINERY EQUIPMENT 568 6540 2500 1,213 1,500 "IOO.00X RSWI FURNITURE AND FIPTURES OTHER IMPROVEMENTS - - - - 000% TOTAL CAPITAL OUTLAY 568 Aleds 2,500 '213 1,S00 - 300.00% (2,5001 TOTAL GMeRIa -le me nl 24'840 226969 275,663 23CMA 116,468 Mill 2MJM 16.79% 36,691 SLA GET COMMENTS: GENERAL GOVERNMEREI CLERK DEPT 41400 Code IS 2011 2010 101 d51 personnel =Full Time MCA, Clerk @JO RE and Rudeptionlst @.20 ME, Perfume ,,,IT =GS RE 225,860 381,639 Commumwtions /r ,ding coordinator and Web maintenance @ 4 FIE. Salaries d0 not iodide increase In 2031 as funds are Included in CounCll Contingenq PA, ..D Iodides miarellonmens asuctance as needed for front desk euverage and benefits for benefit eligible part -time staff. The mcrea.. is due to Inclusion of part-time Inf ill fine. 200 - Office Supplies C paper dip,le fi rall departments. 6,000 7,060 208 BASIN, postage meter fee's 5,000 5,000 Newsletter p..age lost $535 /m.( 6,000 6,900 221- MatDICT.Fce Copier and ARE. equipment maintenance 0 0 245 - Get ... I Supplies LMC Oirecrory -9 copies - otrline no lDnger needed. 0 450 Henn CO Pmpetty Tao books 0 25 Suffam eupgrades Lk- FGrigo, Illustrator, 900 600 An,... and Adobe Pbotoshop) 331 - Travel, Confer,[¢.& Schools State Clerks Con ference lean 550 550 Mileage MC FOA Mlsc Semi 200 200 Tuition eFOAMtgs Tuition $ / 0 1,000 IPN Mdean $20 TMIP /2 J m $200Twfie /200 Pat /3501uI1ef350 Pamele 750 1,200 351-P6Dting and publliblng Legal NOficee - All General Fund '500 1,500 except Capital ProjeRs 400 �C-1.1.1 5-Imced Council Packet Delivery &Video Tape 2,400 2,400 Council Recording Secretary 7,600 7,600 Newsletter Mall Sewire "Midwert Dealing ASm 4,500 COde Book Web Host 200 250 Code Book Update 1,500 1,500 Submarine Image Service 0 0 Document De.RUdlon 300 300 Newsletter Printing Service CH75 / mon!h) 10,500 10,500 27,040 27,050 433 - Dues and Subscriptions M60A Dues (Joan and Twila$40 eat so 80 IIM6 -int1. Clerks Assoc. Due,- Iaan125Rwi75 200 200 harkepals O'ni izatum 0... 25 25 540- Capital Equipment Computers 0 2,500 Furniture & Here, 0 0 M ELECTIONS Fund: General Department: 41410 Actual Actual Actual Budget To Date Projected Draft 3 Percent Dollar PERSONAL SERVICES 2007 2008 2009 2010 2010 Year End 2011 Increase Increase FULL -TIME REGULAR 166 21,511 655 15,134 3,944 15,134 3,784 -75% - 11,350 PART-TIME 124 10,720 - 11,000 - 1.1,000 - -100% - 11,000 PERA CONTRIB - CITY SHARE 10 1,398 44 1,059 276 1,059 274 -74% -785 FICA CONTRIB - CITY SHARE 22 1 ,644 50 1,158 300 1,158 289 -75% -869 EMPLOYEE INSURANCE - CITY SHARE - 2,404 91 2,338 232 2,338 434 -81% -1,904 TOTAL PERSONAL SERVICES 323 37,678 840 30,689 4,752 30,689 4,761 -84% 45,908 MATERIALS & SUPPLIES OFFICE SUPPLIES 357 459 280 250 117 250 - -100% (250) POSTAGE 180 362 157 500 - 500 250 -50% (250) MAINTENANCE OF EQUIPMENT 1,620 1,620 1,585 1,700 1,665 1,700 2,050 21% 350 ELECTIONS /GENERAL SUPPLIES 383 2,679 2 2,500 412 2,500 - -100% (2,500) TOTAL MATERIALS & SUPPLIES 2,540 5,120 2,024 4,950 2,193 4,950 2,300 -54% (2,650) SUPPORT SERVICES /CHARGES LEGAL FEES - 1,803 - - - - 0% TRAVEL, CONFERENCE & SCHOOLS 31 181 25 200 108 200 - -100% (200) PRINTING AND PUBLISHING - 2,274 - 2,500 - 2,500 - -100% (2,500) MISC SERVICES 476 - - - - 0% - TOTALSUPPORTSERVICES /CHARGES 31 4,734 25 2,700 108 2,700 - -100% (2,700) CAPITAL OUTLAY FURNITURE AND FIXTURES - - - 600 - 600 - -100% (600) TOTAL CAPITAL OUTLAY - - - 600 - 600 - -100% (600) TOTAL Elections 2,894 47,532 2,888 38,939 7,053 38,939 7,081 -82% (31,858) BUDGET COMMENTS: ELECTIONS DEPT 41410 Budget Budget 2011 2010 Code # 101 Personnel is .2 Executive Secretary /Deputy Clerk during election year and 4,781 19689 .05 Executive Secretary/Deputy Clerk - Non - Election Years - Includes all costs 103 Part-time personnel consists of Election Judges 0 11000 Est. 32 Judges working Primary; 44 Judges working General Est. 18 hrs /judge & extra training on equipment 200 Election Office Supplies (mist.) - 250 250 500 208 Postage 221 Equipment Maintenance -11 voting machines 2,050 1700 245 General supplies - forms, posters, rosters, etc. 0 2500 0 304 Legal Notices 331 Travel, Conferneces, schools - 200 351 Printing and publishing- ballots, envelopes, etc. 0 2500 560 Furniture and fixutres - election booths 0 600 FINANCE Fund. General Department, 41500 Actual Actual Actual Budget To Date Projected Draft 3 Percent Dollar PERSONAL SERVICES 2007 2008 2009 2010 2010 Year End 2011 Increase Increase FULL -TIME REGULAR 111,244 122,019 132,533 137,267 70,019 98,000 120,791 - 12.00% (16,476) - O OVERTIME - - - PART -TIME 55 745 - - - - - 0.00% - OTHER - - - - - - - 0.00% SEVERANCE PAY - - - - - 0'00% REBA CONTRIB - CITY SHARE 6,919 7,908 8,924 9,609 4,141 7,000 8,757 -8.87% (852) FICA CONTRIB - CITY SHARE 8,478 9,234 10,102 10,501 5,340 8,000 9,241 - 12.00% (1,260) EMPLOYEE INSURANCE- CITY SHARE 12,341 14,779 14,473 21,207 6,301 14,000 14,435 - 31.93% (6,772) UNEMPLOYMENT COMPENSATION - - - - - - - 0.00% WORKERS COMPENSATION - - - - - - 0.00% - TOTAL PERSONAL SERVICES 139,037 154,684 166,032 178,584 85,802 127,000 153,224 - 14.20% (25,360) MATERIALS & SUPPLIES OFFICE SUPPLIES 1,540 492 604 500 0 500 - - 100.00% (500) MAINTENANCE OF EQUIPMENT 3,654 4,463 6,183 7,000 6,521 7,000 6,700 -4.29% (300) GENERALSUPPLIES 144 959 165 200 224 250 250 25.00% 50 TOTAL MATERIALS & SUPPLIES 5,337 5,914 6,953 7,700 6,745 7750 6,950 -9.74% (750) SUPPORT SERVICES /CHARGES AUDITING& ACCOUNTING SERVICES - - - - - - - 0.00% - TRAVEL,CONFERENCE &SCHOOLS 531 1,230 2,166 3,800 596 3,800 3,300 - 13.16% (500) PRINTING AND PUBLISHING 699 700 720 500 50 500 500 0.00% - - 0.00% UNALLOCATED INS -LTD - - - - CONTRACTUAL SERVICES 491 692 719 1,000 721 1,000 1,000 0.00% - DUESANDSUBSCRIPTIONS 585 710 698 1,000 60 1,000 1,000 0.00% - - - - 0.00% - MISCSERVICES BANK SERVICE CHARGES 777 721 496 - 1,200 96 500 775 - 35.42% (425) TOTAL SUPPORT SERVICES /CHARGES 3,082 4,053 4,799 7,500 1,523 6,800 6,575 - 12.33% (925) CAPITAL OUTLAY MACHINERY & EQUIPMENT 1,161 - 1,678 - - - - 0.00% - FURNITURE AND RXTURES - - - - - - - 0.00% - OTHER IMPROVEMENTS 25,879 - 805 - - - - 0.00% - TOTAL CAPITAL OUTLAY 27,039 - 2,483 - - - - 0.00% - TOTAL Finance 174,495 164,651 180,267 193,784 94,070 141,550 166,749 . 13.95% (27,035) BUDGET COMMENTS: FINANCE DEPT 41500 Budget Budget Code# 2011 2010 101 Full Time Personnel includes 1.0 FTE Finance Director and .75 FTE Sr. Accounting Clerk 153,224 178,584 200 Computer Checks, Budget Supplies, etc 500 221 Finance software support & enhancements 7,000 Fund accounting, Payroll, Utll Bill Software 245 Books & Publications 200 331 Travel, Conferences & Schools: 3300 3800 GFOA Local 300 300 GFOA State 1000 1000 Mileage 1000 1500 Educational - Tuition Reimbusement 1000 1000 Nat'L GFOA Conference 0 0 351 Publish financial statements and budget 500 500 0 0 360 1,000 1000 400 433 GFOA - State and National 1,000 1000 Public Investor, Governing, Other Submittal fee - GFOA Cert, of Excellence Submittal fee - GFOA Distinguished Budget Award 450 Bank & Broker Service Charges 775 1200 540 Laser printer 0 0 Computer - Fin Dir 0 0 Mist Software needs 0 0 _10_ PROFESSIONAL SERVICES Fund: General Department: 41600 Actual Actual Actual Budget To Date Projected Draft 3 Percent Dollar SUPPORT SERVICES /CHARGES 2007 2008 2009 2010 2010 Year End 2011 Increase Increase AUDITING $ ACCOUNTING SERVICES 13,475 15,390 19,835 25,000 20,573 25,000 25,000 0% - CIVIL LEGAL CONTRACT 67,795 66,487 82,567 47,000 19,978 40,000 49,000 4% 2,000 PROSECUTION CONTRACT 22,475 28,622 30,224 33,000 13,112 33,000 35,000 6% 2,000 CONTRACTUAL ASSESSOR SERVICES 83,963 88,087 90,549 94,000 93,492 94,000 96,000 2% 2,000 MISC SERVICES 9,172 14,634 684 - - - - 0% TOTAL SUPPORT SERVICES /CHARGES 196,880 213,220 223,859 199,000 147,155 192,000 205,000 3% 6,000 TOTAL Professional Svcs 196,880 213,220 223,859 199,000 147,155 192,000 205,000 3% 6,000 Professional Services Detail Budget Budget 2011 2010 301 covers the annual audit this was bit In 2008 and is a three year agreement 25,000 25,000 304 contract for civil - retainer, mileage, coping, other civil cases 49,000 47,000 304 contract for prosecuting attorney retainer and forfeitures 35,000 33,000 400 contract for the assessor with Hennepin County 96,000 94,000 County Assessor, Auditor, and Attorney are at end of three year contract term on December 31, 2011 NOTE: 2009 City incurred significant fees related to Ran Johnson Litigation Civil retainer currenity $1,500 per month. Mileage, copying, etc, extra, Special civil work billed out separate e.g. Ron Johnson Prosecution retainer currenity $2,291.66 per month. forfeitures not Included in general retainer and billed separately at $1$kper hour V5 II_ PLANNING Fund: General Department: 41910 PERSONAL SERVICES FULL -TIME REGULAR OVERTIME PART -TIME OTHER SEVERANCE PAY PERA CONTRIB - CITY SHARE FICA CONTRIB - CITY SHARE EMPLOYEE INSURANCE - CITY SHAR UNEMPLOYMENT COMPENSATION WORKERS COMPENSATION TOTAL PERSONAL SERVICES MATERIALS & SUPPLIES OFFICE SUPPLIES MAINTENANCE OF EQUIPMENT GENERAL SUPPLIES TOTAL MATERIALS & SUPPLIES SUPPORT SERVICES /CHARGES LEGAL FEES COMMUNICATIONS - CELLULAR PHON TRAVEL, CONFERENCE & SCHOOLS PRINTING AND PUBLISHING CONTRACTUAL SERVICES DUES AND SUBSCRIPTIONS MISC SERVICES TOTAL SUPPORT SERVICES /CHARGES CAPITAL OUTLAY MACHINERY & EQUIPMENT FURNITURE AND FIXTURES OTHER IMPROVEMENTS TOTAL CAPITAL OUTLAY TOTAL Planning Actual Actual Actual Budget To Date Projected Draft 3 Percent Dollar 2007 2008 2009 2010 2010 Year End 2011 Increase Increase 124,736 138,219 141,729 88,048 64,033 142,500 139,709 59% 51,661 0% 12,381 15,900 15,027 60,765 1,142 1,142 - -100% (60,765) - - - - - 0% - 8,809 10,028 10,376 10,417 4,560 10,417 10,129 -3% (288) 9,383 10,669 11,106 11,384 4,362 11,384 10,688 0% 1696) 14,555 18,163 17,236 22,991 7,575 17,820 17,850 0% (5,141) ' 0% - - - - - - - - 0% - 169,865 192,979 195,475 193,605 81,673 183,263 178,376 -8% (15,229) 76 505 510 - - - 0% - - 405 405 405 - 405 405 0% - 1,583 400 1,223 250 54 250 250 0% - 1,659 1,310 2,139 655 54 655 655 0% - 0% 1,085 1,166 1,301 1,200 669 1,200 960 -20% (240) 6,409 3,771 1,904 1,900 3,010 1,900 6,820 259% 4,920 1,975 1,507 1,298 1,000 178 1,000 1,000 0% - 3,110 2,830 3,660 - - - 1,000 0% 1,000 751 711 827 600 829 600 850 42% 250 0% 13,331 9,986 8,989 4,700 4,685 4,700 10,630 126% 5,930 - 2,320 - - - - 0% - - - - - 0% - 2,320 - - - - 0% 184,854 206,595 206,603 198,960 86,412 188,618 189,661 -5% (9,299) BUDGET COMMENTS: PLANNING &ZONING DEPT 41910 Budget Budget Code M 2011 2010 . 101 Personnel consist of .95 Planning director and .9 planning assistant 178,376 193,605 includes all wages and benefits 245 - General Supplies Books 250 100 Graphics materials 0 100 Franklin Planner Supplies 0 50 Hennepin Co. Aerial Pictometry/Software 0 Microsoft Office Software 0 0 Total 321 Cellular phone 960 1200 331 Travel, Conferences and Schools 6820 1900 Computer Training (GIS Training) Misc.(planning commission )Conferences /Seminars passible in- housetraining 2000 0 Mileage 1000 500 Sensible Land Use Coalition Meetings 520 1000 GTS Training Session - 7 P.C. Members 700 0 Education 400 400 Nat. Conf 2200 0 351 Printing and publications 0 1000 0 400 Contract services 433 Subscriptions and memberships 850 600 APA MN APA APA Journal Zoning News Sensible Land Use Coalition 540 Capital outlay 0 0 Parcel database udate iv_ MUNICIPAL BUILDINGS Fund: General Department: 41940 MATERIALS & SUPPLIES MAINTENANCE OF EQUIPMENT MAINTENANCE OF BUILDINGS GENERALSUPPLIES TOTAL MATERIALS & SUPPLIES SO PROFIT SERVICES /CHARGES CONSULTING FEES COMMUNICATIONS - Warner Conn. TRAVEL, CONFERENCE & SCHOOLS INSURANCE UTILITY SERVICES CONTRACTUAL SERVICES RENTALS TAXES /LICENSES MISC SERVICES TOTAL SUPPORT SERVICES /CHARGES CAPITAL OUTLAY BUILDINGS & STRUCTURES MACHINERY & EQUIPMENT FURNITURE AND FIXTURES OTHER IMPROVEMENTS TOTAL CAPITAL OUTLAY EDA DEBT SERVICES BOND PRINCIPAL BON D INTEREST TOTAL EDA DEBT SERVICES TRANSFERS OPERATING TRANSFERS TOTALTRANSFERS TOTAL Municipal Buildings Actual Actual Actual Budget In Date Projected Draft 3 Percent Dollar 2007 2008 2009 2010 2010 year End 2011 Increase Increase 20,908 23,912 32,020 47,300 29,735 47,300 14,000 -70% (33,3W) 11,180 5 119 5,000 13 5,000 5,000 0% - 2,430 2,614 2,182 2,500 1,265 2,500 2,500 0% - 34,519 26,532 34,321 54,800 31,014 54,800 23,511 -57% (31,289) 0% 6,801 7,668 6,523 1,000 1,353 1,000 34,000 3300% 33,000 - - - - Soo 500 - 0% - 79,629 91,980 98,796 115,000 (382( 115,000 105,000 -9% (10,000( 7,189 8,976 10,671 9,000 3,514 9,000 11,000 22% 2,000 6,608 6,595 6,640 7,000 2,868 7,200 7,500 7% 500 - 1,731 1,328 1,000 698 Soo 250 -75% (750( 0% 0% 100,228 116,950 123,957 133,000 8,550 133,200 157,750 19% 24,750 20,249 3,750 23,999 33,732 14,168 47,900 20,000 15,713 15,71.3 20,000 15,713 15,713 - - 45,000 7,890 5,425 61,000 7,890 5,425 106,000 110,000 50,000 99,773 60,000 110,000 50,000 99,773 60,000 316,645 201,372 263,477 373,800 BUDGET COMMENTS: MUNICIPAL BLDG, CITY HALL DEPT 41940 Code # 221 Maintenance Contracts move Warner to Telecommuications Copier - Ricoh -new Copier- Ricoh Color Lased <he Software Assurance Plan office Printers / folding machine Postage machine lease & Taint 223 Building Maintenance Fire Extinguishers Painting & Supplies Ballast Repairs Relamping 245 General Supplies - cleaning supplies, ice control, paper, etc 321 Telecommunications - telephone and data through Warner Connect @ $2,800 month 360 - Insurance Property /Casualty, WC, etc. 380 Utilities 400 Contractual Services - janitorial, Carpet, and pest control 410 Rentals 437 Special Assessments - City owned property (includes mist. County charges) State Sales IS Use Tax 520 Buildings & Structures 540 Machinery -Equip - (2010= Copier) 560 PONT & Fixtures 580 Other Improve 601 Debt Service Payments (for City Hall public project bonds) 720 Transfer to Public Facilities Fund Trsfr to Swr End for residential debt svc pmt (2010 is the last year) 45,000 50,000 61,000 61,000 106,000 111,000 60,000 60,000 55,277 369,713 292,261 Budget 2011 14,000 5,000 2,500 33,600 105,000 11,000 7,500 103,950 0% - -100% (20,000) 0% 0% -100% (20,000) 11% 5,000 0% - 5% 5,000 -100% (60,000) -100% (60,000) -22% (81,539) Budget 2010 47,300 3,300 2,500 6,300 200 1,400 33,600 5,000 house next door 2,500 1,000 115,000 9,000 6,000 1,000 20,000 126,000 60,000 -14- POLICE MATERIALS & SUPPLIES GENERAL SUPPLIES TOTAL MATERIALS & SUPPLIES SUPPORT SERVICES /CHARGES UTILITY SERVICES CONTRACTUAL SERVICES MISC SERVICES TOTAL SUPPORT SERVICES /CHARGES CAPITAL OUTLAY BUILDINGS &STRUCTURES TOTAL CAPITAL OUTLAY TOTAL Police Protection Actual Actual Actual Budget To Date Projected Draft 3 Percent Dollar 2007 2008 2009 2010 2010 Year End 2011 Increase Increase 59 0% 59 - - - 05Y - 37 44 26 50 16 50 - -100% (50) 819,979 891,031 941,396 945,950 473,497 945,950 992,550 5% 46,600 2,946 3,984 2,567 4,000 1,440 4,000 4,000 0% - 822,962 895,059 943,989 950,000 414,954 950,000 996,550 5% 46,550 249,508 244,004 232,940 230,000 114,034 230,000 230,000 0% - 249,508 244,004 232,940 230,000 114,034 230,000 230,000 0% - 1,072,528 1,139,063 1,176,928 1,180,000 588,988 1,180,000 1,226,550 4% 46,550 Police Budget Detail Contractual services is the contribution to the SLMPD per the JPA. The percentage assessed is up for review for budget year 2012 Miscellaneous Services are charges associated with forfeiture vehicles (tow charges) Capital outlat covers the City's share of the bonds. 19 FIRE Fire Detail Support Services and charges covers the contract cost for Mound FD to cover the island and the city's share of the costs for the EFD JPA Buildings & Structures is the city's share of the building bonds and capital equipment. -16- Actual Actual Attual Budget To Date Projected Draft 3 Percent Dollar SUPPORT SERVICES /CHARGES 2007 2008 2009 2010 2010 Year End 2011 Increase Increase Excelsior Fire 268,112 294,154 298,175 298,113 149,267 300,000 312,548 4.84% $ 14,435 Mound Fire Contract 23,256 25,257 25,005 24,422 6,106 24,422 25,000 2.37% $ 578 TOTAL SUPPORT SERVICES /CHARGES 291,368 319,411 323,180 322,535 155,372 324,422 337,548 4.65% 15,013 CAPITAL OUTLAY BUILDINGS & STRUCTURES 304,579 303,524 277,270 279,624 136,314 279,624 270,697 TOTAL CAPITAL OUTLAY 304,579 303,524 277,270 279,624 136,314 279,624 270,697 -3.19% (8,927) TOTAL Fire Protection 595,947 622,934 600,450 595,482 291,687 604,046 608,245 2.14% 12,763 Fire Detail Support Services and charges covers the contract cost for Mound FD to cover the island and the city's share of the costs for the EFD JPA Buildings & Structures is the city's share of the building bonds and capital equipment. -16- PROTECTIVE INSPECTIONS PERSONAL SERVICES FULL -TIME REGULAR PART -TIME PERA CONTRIB - CITY SHARE FICA CONTRIB � CITY SHARE EMPLOYEE INSURANCE - CITY SHARE TOTAL PERSONAL SERVICES MATERIALS & SUPPLIES OFFICE SUPPLIES GENERAL SUPPLIES TOTAL MATERIALS & SUPPLIES SUPPORT SERVICES /CHARGES COMMUNICATIONS - CELLULAR PHONE TRAVEL, CONFERENCE & SCHOOLS PRINTING AND PUBLISHING CONTRACTUAL SERVICES DUES AND SUBSCRIPTIONS TOTAL SUPPORT SERVICES /CHARGES CAPITAL OUTLAY MACHINERY & EQUIPMENT FURNITURE AND FIXTURES TOTAL CAPITAL OUTLAY TOTAL Protective Inspections Actual Actual Actual 2007 2008 2009 86,530 94,037 88,521 9,318 10,427 7,275 5,994 6,795 6,267 6,661 7,162 6,646 9,663 11,969 10,475 118,167 130,391 119,185 Budget 2010 83,904 6,752 6,346 6,935 14,006 117,943 To Date 2010 40,448 1,285 2,921 2,756 4,689 52,099 Projected Year End 83,904 1,285 6,267 6,646 12,155 110,257 Draft 3 2011 83,433 1,500 6,050 6,383 11,730 109,096 Percent Dollar Increase Increase -0.56% (471) -77.78% (5,252) -4.66% (2961 -7.96% (552, - 16.25% (2,276', -7.50% (8,847', 48 - - - - - - 0.00% 243 5 139 400 22 400 300 - 25.00% 291 5 139 400 22 400 300 - 25.00% 642 406 470 450 3,445 3,634 2,799 3,400 388 299 668 300 5,110 2,950 1,610 2,500 100 100 100 1S0 9,684 7,388 5,646 6,800 331 - Travel, Conferences & Schools - 1,298 - - 1,298 - 128,141 137,784 126,268 125,143 BUDGET COMMENTS: PROTECTIVE INSPECTION DEPT 42400 211 450 450 0.00% 1,315 3,400 3,000 - 11.76% 82 300 300 0.00 385 2,500 2,500 0.00% - 150 150 0.00% 1,993 6,800 6,400 -5.88% (100) (100) (400) (400) 300 0.00% 300 0.00% - - 0.00% 54,114 117,457 115,796 -7.47% (9,347) t7_ 2011 2010 Code# Budget Budget 101 Personnel allocation includes 1 FTE Building official, .05 Planning Dir 109,096 117,943 .10 Planning assistant - costs all inclusive except for Increases for 2011 245 General Supplies Books and other reference material 300 400 321 Cellular Telephone - switch to "pay as you go" phone 450 450 Possibility to add wireless internet computer card for remote access in field 331 - Travel, Conferences & Schools 3000 3400 Inspect. classes 225 225 Conferences 275 275 Mileage 2500 2900 351 - Printing and publishing- more forms are generated in house and being taken 300 300 electronically 400 - Contractual services- covers contract inspections in the absence of Joe 2,500 2500 433 Subscriptions and memberhsips C B 0 100 100 Northstar Chapter - ICBO 50 50 540 - Capital Improvements Machinery and equipment - Potential to acquire a new "PDA" type item. 300 0 t7_ CITY ENGINEER Actual Actual Actual Budget To Date Projected Draft Percent Dollar PERSONAL SERVICES 2007 2008 2009 2010 2010 Year End 2011 Increase Increase FULL -TIME REGULAR 95,804 98,499 86,821 72,925 32,290 75,5SO 86,585 19% 13,660 PERA CONTRIB - CITY SHARE 5,991 6,408 4,826 5,105 2,240 5,287 6,277 23% 1,172 FICA CONTRIB - CITY SHARE 7,263 7,420 6,581 S,579 2,440 5,780 6,624 19% 1,045 EMPLOYEE INSURANCE - CITY SHARE 10,745 11,692 9,160 11,266 3,524 9,237 11,617 3% 351 TOTAL PERSONAL SERVICES 119,803 124,018 114,547 94,875 40,494 95,854 111,103 17% 16,228 MATERIALS & SUPPLIES OFFICE SUPPLIES 315 297 395 300 11 300 300 0% - MAINTENANCE OFEQUIPMENT 372 - - - - - 830 0% 830 GENERAL SUPPLIES 798 391 346 12S 33 12S 125 0% - TOTAL MATERIALS III SUPPLIES 1,485 688 742 425 44 425 1,255 195% 830 SUPPORT SERVICES /CHARGES ENGINEERING FEES 5,279 1,148 1,825 5,000 1,607 5,000 5,000 0% COMMUNICATIONS - CELLULAR PHONE 722 627 547 646 249 646 700 8% 54 TRAVEL, CONFERENCE & SCHOOLS 850 3,919 3,37S 4,000 384 4,000 3,000 -25% (1,000) PRINTING AND PUBLISHING 1,333 664 792 1,000 129 1,000 500 -50% (500) CONTRACTUAL SERVICES 1,000 - - 500 - 500 250 -50% (2SO) RENTAL - 200 267 2,000 - 2,000 1,000 -50% (1,000) DUES AND SUBSCRIPTIONS - 428 833 1,100 833 1,100 1,470 34% 370 TAXES /LICENSES - 520 - 900 132 900 900 0% - TOTAL SUPPORT SERVICES /CHARGES 9,184 7,505 7,638 15,146 3,334 15,146 12,820 -15% (2,326) CAPITAL OUTLAY MACHINERY & EQUIPMENT 2,334 15,340 2,854 1,000 44 1,000 5,700 470% 4,700 FURNITURE AND FIXTURES 192 25 - - - - 0% - OTHER IMPROVEMENTS - - - - - - 0% - TOTAL CAPITAL OUTLAY 2,526 15,365 2,854 1,000 44 1,000 5,700 470% 4,700 TOTAL City Engineer 132,998 147,576 125,782 111,446 43,916 112,425 130,878 17% 19,432 BUDGET COMMENTS: CITY ENGINEER DEPT 43010 2011 2010 Code# Budget Budget 101- Personnel consists Of .9 City Engineer, .20 FTE clerical - in 2010 only.10 111,103 94,875 Costs are all Inclusive of all wages and benefits. 200 - Office Supplies Covers general supplies specific to engineering 300 300 General supplies -Books and materials 125 125 Maintenance of Equipment- Covers software maintenance agreements, was in Subscriptions and memberships 830 303- Engineering - miscellaneous consulting and /or studies 5,000 5,000 321 - Cellular telephone for CPS Data 700 646 331 - Travel, Conference, & Schools 3,000 4,000 351 - Printing and publishing Soo 1,000 410 - Rentals - Survey grade GPS @$200 per day 1,000 2,000 433 - Subscriptions and memberships 1,470 1,100 900 900 437 Licenses PE and CE license 540- Machinery and Equipment 5,700 1,000 Including 6,800 for CIS compatible sign inventory software PUBLIC WORKS - SERVICES FUND. General Department: 43050 PERSONAL SERVICES FULL -TIME REGULAR OVERTIME PERA CONTRIB - CITY SHARE FICA CONTRIB - CITY SHARE EMPLOYEE INSURANCE - CITY SHARE TOTAL PERSONAL SERVICES MATERIALS & SUPPLIES OFFICE SUPPLIES MOTOR FUELS & LUBRICATION MAINTENANCE OF EQUIPMENT MAINTENANCE OF BUILDINGS SMALL TOOLS AND MINOR EQUIPMENT GENERAL SUPPLIES TOTAL MATERIALS & SUPPLIES SUPPORT SERVICES /CHARGES DRUG TESTING COMMUNICATIONS - TELEPHONE TRAVEL, CONFERENCE & SCHOOLS PRINTING AND PUBLISHING UTILITY SERVICES CONTRACTUAL SERVICES RENTALS DUES AND SUBSCRIPTIONS TAXES /LICENSES MISC SERVICES TOTAL SUPPORT SERVICES /CHARGES CAPITAL OUTLAY BUILDINGS & STRUCTURES MACHINERY & EQUIPMENT FURNITURE AND FIXTURES OTHER IMPROVEMENTS TOTAL CAPITAL OUTLAY TRANSFERS OPERATING TRANSFERS - EQUIPMENT TOTALTRANSFERS TOTAL Public Works Actual Actual Actual 2007 2008 2009 220,914 234,340 220,972 12,514 77 390 14,618 15,386 14,906 17,314 16,998 16,364 26,163 28,817 26,969 292,022 295,616 279,601 382 248 16 36,722 40,068 27,668 20,572 23,694 19,373 3,040 1,278 865 1,335 683 908 8,155 11,319 9,970 70,206 77,289 58,801 3,146 3,068 1,527 2,593 2,870 2,800 - 42 2,896 13,077 14,138 9,996 17,027 17,552 20,888 1,254 182 283 1,738 1,793 1,518 2,898 1,012 317 409 43 314 42,140 40,700 40,540 639 5,003 639 5,003 200,000 175,000 175,000 200,000 175,000 175,000 605,007 588,605 558,944 Budget To Date Projected 2010 2010 Year End 222,629 96,33.9 198,500 5,000 - 1,500 15,934 7,183 15,934 17,414 7,646 17,414 34,395 12,343 28,588 295,372 123,491 261,936 - 126 150 43,123 15,826 33,250 16,000 8,970 18,000 2,000 557 2,000 1,D00 372 1,000 9,000 2,712 9,000 71,123 28,563 63,400 1,300 - - 3,200 946 2,100 3,450 3,060 3,450 15,000 5,662 11,500 16,190 12,141 22,300 1,200 - 1,200 1,500 1,500 1,500 850 842 842 - 119 250 42,690 24,270 43,142 3,800 - 3,800 3,800 - 3,800 100,000 - 100,000 100,000 - 100,000 512,985 176,324 472,278 to- Draft 3 Percent Dollar 2011 increase Increase 142,390 -36.04% (80,239) 2,500 - 50.00% (2,500) 10,323 - 35.21% (5,611) 10,893 -37 45% (6,521) 18,001 - 47.66% (16,394) 184,107 - 37.67% (111,265) 200 0.00% 200 40,000 -7.24% (3,123) 16,000 0.00% - 2,000 0.00% - 1,000 0.00% 9,000 0.00% - 68,200 4.11% (2,923) 1,300 0.00% - 3,200 0.00% - 3,200 -7.25% (250) - 0.00% - 14,000 -6.67% (1,000) 16,190 0.00% - 1,000 - 16.67% (200) 1,500 0.00% - 850 0.00% - 200 0.00% 200 41,440 -2.93% (1,250) 7,000 84.21% 3,200 0.00% - 0.00% - 7,000 84.21% 3,200 50,000 - 50.00% (50,000) 50,000 - 50.00% (50,000) 350,747 - 31.63% (162,238, BUDGET COMMENTS: PUBLIC WORKS SERVICE DEPT 43050 Code# Budget Budget Laundry service - uniforms, towels- $170 wk x 52 wks 2011 2010 101 - Personnel was modified using actual time reports for last 6 months of 2009 & first 6 months of 2010 5940 5940 General Public works consists of .5 Director, .3 LEO, .1 Utiltly Lead 184,107 295,372 and .9 Shop Tech. Wages include 2% increase and all associated benefits. 850 212 - Gas and diesel fuel for trucks and other equipment 40,000 43,123 221- Equipment Maintenance 16,000 16,000 223 - Building Maintenance- general routine maintenance 2,000 2,000 240 - small tools 1,000 1,000 245 General equipment 9,000 9,000 305 - Drug monitoring and testing, including annual dues to LMCIT 1,300 1,300 321 - Telephones, pager &cable modem; internet weather, Alarm cell monitoring 3,200 3,200 331 - Travel, Conferences, & Schools Safety Training- SafeAssure(OSHA mandate) 3,200 3,450 (PW Dir -CEAM Trng -3200; DOT Vehicle Inspec Recertlfi -250 200 - 380 - Utilities - Gas & Electric 14,000 15,000 400 - Contractual Services 16190 16190 Laundry service - uniforms, towels- $170 wk x 52 wks 9100 9100 Janitorial Services 5940 5940 Pest Control D 300 300 Fire Suppression System Monitoring 850 Annual Crane Inspections (2) 850 410 - Rentals 1,000 1,200 433 - Dues and Subscriptions 1,500 1,500 Misc -150; All Data Automotive Tech Service -2000 437 - Licenses and Taxes 850 850 Hazardous Waste License- Dept of Rev Hennepin Co. Hazardous Waste Misc Licenses( Boiler ,lrrigation,FireExtinginsp) 440 Miscellaneous Charges e.g. mail box damage, damage to private property, etc. 200 - 540- Buildings - We need to repair the leaking roof of the PW building. - - 540 - Machinery and Equipment 7,000 3,800 720 - Transfer to Equipment Replacement fund 50,000 100,000 Reduced by 50 %. SNI111 STREETS AND ROADS FUND: General Department: 43100 Actual Actual Actual Personnel Services 2007 2008 2009 FULL -TIME REGULAR 68,576 78,161 S5,417 OVERTIME 1,027 896 223 PART -TIME - - 460 OTHER SEVERANCE PAY - " PERA CONTRA - CITY SHARE 4,351 5,139 3,730 FICA CONTRIB - CITY SHARE 5,215 5,898 4,206 EMPLOYEE INSURANCE - CITY SHARE 8,175 10,064 5,810 UNEMPLOYMENT COMPENSATION - - WORKERS COMPENSATION - - - TOTAL PERSONAL SERVICES 87,344 100,157 69,846 MATERIALS & SUPPLIES MAINTENANCE OF EQUIPMENT - 79 - SMALL TOOLS AND MINOR EQUIPMENT - - ' GENERAL SUPPLIES 66,260 82,914 53,168 TOTAL MATERIALS & SUPPLIES 66,260 82,993 53,168 SUPPORT SERVICES /CHARGES TRAVEL, CONFERENCE & SCHOOLS - - PRINTINGANDPUBLISHING - " CONTRACTUAL SERVICES 16,839 14,284 27,233 MISC SERVICES 778 - " TOTAL SUPPORT SERVICES /CHARGES 17,617 14,284 27,233 CAPITAL OUTLAY MACHINERY & EQUIPMENT - - OTHER IMPROVEMENTS " TOTAL CAPITAL OUTLAY - - TRANSFERS OPERATING TRANSFERS - STREETS 345,000 645,000 700,000 TOTALTRANSEERS 345,000 645,000 700,000 TOTAL Streets & Roadways 516,221 842,434 850,248 BUDGET COMMENTS: STREETS AND ROADWAYS Department 43100 101 Personnel Services Includes 1.2 FTE LEO and.3 FTE Utility Supervisor. Percent of time figured on first 6 months actual time sheet recording. Wages Include 2% wage increase and all associated benefits. 245 - General Supplies - Rock, gravel, black dirt & asphalt, Rock and Aggregates Black dirt, asphalt patching, castings & rings, etc. 331 Travel, Conferences, and Schoosl - safety training, refresher training, etc. 400 Contractual services includes roadway striping, street sweeping, etc. 720 - Transfer to Local Street Reconstruction Fund to support road program to cover general maintenance and reconstruction. 2010= $700,000 Budget To Date Projected Draft 3 Percent Dollar 2010 2010 Year End 2011 Increase Increase 73,048 34,805 73,048 87,832 2014% 14,784 500 - 500 500 0.00% - _ - 0.00% - 0.00% 0.00% 5,148 2,429 5,148 6,368 23.70% 1,220 5,626 2,589 5,626 6,719 19.43% 1,093 11,285 3,386 11,285 12,040 6.69% 755 0.00% - - 0.00% - 95,607 43,209 95,607 113,459 18.67% 17,852 0.00% - 45 50 - 0.00% 85,000 27,602 85,000 85,000 0.00% 85,000 27,647 85,050 85,000 0.00% - - - - 4,000 0.00% 4,000 - 0.00% - 23,500 219 15,500 30,000 27.66% 6,500 - 206 225 - 0.00% - 23,500 425 15,725 34,000 44.69% 10,500 - - 0.00% - 3,200 - 0.00% - 3,200 - 0.00°A - 700,000 - 700,000 750,000 7.14% 50,000 700,000 - 700,000 750,000 7.14% 50,000 904,107 71,282 899,582 982,459 11 _ 2011 2010 Budget Budget 113,459 95,607 85,000 85,000 4,000 0 30,000 23,500 750,000 700,000 SNOW AND ICE CONTROL FUND: General Department: 43125 PERSONAL SERVICES FULL -TIME REGULAR OVERTIME PART -TIME OTHER SEVERANCE PAY PERA CONTRIB - CITY SHARE FICA CONTRIB - CITY SHARE EMPLOYEE INSURANCE - CITY SHARE UNEMPLOYMENT COMPENSATION WORKERS COMPENSATION TOTAL PERSONAL SERVICES MATERIALS & SUPPLIES GENERALSUPPLIES TOTAL MATERIALS & SUPPLIES SUPPORT SERVICES /CHARGES TRAVEL, CONFERENCE & SCHOOLS TOTAL SUPPORT SERVICES /CHARGES CAPITAL OUTLAY MACHINERY & EQUIPMENT TOTAL CAPTAL OUTLAY TOTAL Ice & Snow Removal Actual Actual Actual Budget To Date Projected Draft 3 Percent Dollar 2007 2008 2009 2010 2010 Year End 2011 Increase Increase 18,068 19,934 23,995 26,998 13,211 26,998 38,238 41.63% 11,240 9,465 7,549 5,226 5,000 8,651 5,000 7,500 50.00% 2,500 2,240 - 2,240 - - 100.00% (2,240) 1,722 1,799 1,981 - 1,531 - 2,772 0.00% 2,772 2,051 1,993 2,178 2,448 1,587 2,448 2,925 19.49% 477 2,654 2,599 2,615 4,171 1,848 4,171 5,132 23.04% 961 33,959 33,875 35,995 40,857 26,828 40,857 56,567 38.45% 15,710 35,229 34,731 38,457 45,117 12,594 45,117 45,117 0.00% - 35,229 34,731 38,457 45,117 12,594 45,117 45,117 0.00% - - - 0.00% 0.00% 0.00% 0.00% - 69,189 68,606 74,452 85,974 39,422 85,974 101,684 18.27% 15,710 BUDGET COMMENTS: SNOW AND ICE REMOVAL Department 43125 Budget Budget 2 2010 101 - Personnel is refigured based on actual time sheet recording for the first 6 months and include the 2% increase and associated benefits. 56,567 40,857 Staffing allocation is equivalent to 1.4 FTE 245 - General Supplies covers the purchase of salt, sand, cutting blades, etc. 45,117 45,117 22- TRAFFIC CONTROL Fund: General Department 43160 Actual Actual Actual Budget To Date Projected Draft Percent Dollar PERSONAL SERVICES 2007 2008 2009 2010 2010 Year End 2011 Increase increase FULL -TIME REGULAR 294 - - - - - 0.00% - PART -TIME - - - - - 0.00% - PERACONTRIS - CITY SHARE 18 - - - - O.OD% - FICACONTRIB.CITYSHARE 21 - - - - - 000% - EMPLOYEEINSURANCE - CITY SHARE 22 - - - - - - 000% - TOTALPERSONALSERVICES 356 - - - - 0.00% MATERIALS & SUPPLIES MAI NTENANCE OF EQUIPMENT - - - - - GENERALSUPPLIES 4,067 2,873 3,412 6,000 146 6,000 5,000 - 166.67% (1,000) TOTAL MATERIALS& SUPPLIES 4,067 2,873 3,412 6,000 146 6,000 5,000 - 16.67% (1,000) SUPPORT SERVICES /CHARGES ENGINEERING FEES - - - - - - - 9.09% D UTILITY SERVICES 243 294 289 - 107 275 300 0.00% 300 UTILITIES - STREETLIGHTS 33,932 41,049 40,849 41,049 15,698 37,750 41,049 000% - CONTRACTUAL SERVICES 677 2,321 1,153 4,000 888 2,000 30,800 170.00% 6,800 signinventory MISC SERVICES - - - - - - - O 00% - TOTALSUPPORTSERVICES(CHARGES 34,853 43,664 42,291 45,049 16,692 40,025 52,149 15.76% 7,100 TOTALTraftic COntrol/Str Ught 39,276 46,537 45,703 51,049 16,838 46,025 57,149 11.95% 6,100 BUDGET COMMENTS: TRAFFIC CONTROL/STREETLIGHTING Department 43160 Budget Budget 2011 2010 This budget covers the operational cost of street lights, traffic signals and street signs. the major change in this budget is preparing for the new federal requirement for street signs. Dollars are budgeted to hire a consultant to conduct a comprehensive sign inventory. General Supplies covers the costs associated with light replacement for stop llghts. 5,000 6,000 380 - Utilities street light, 41,049 41,049 400 - Contractual Services 10,800 4,000 Adding $6,800 for consulting services to conduct the sign inventory and reflectivity study. 9'3_ SANITATION /WEEDS /WASTE REMOVAL Fund: General Department: 43200 -24- Actual Actual Actual Budget To Date Projected Draft 3 Percent Dollar PERSONAL SERVICES 2007 2008 2009 2010 2010 Year End 2011 Increase Increase FULL -TIME REGULAR 2,198 1,535 1,365 0 3,232 3,500 1,500 0.00% 1,500 OVERTIME - - 859 172 172 200 0.00% 200 PERA CONTRIB - CITY SHARE 137 100 150 238 250 245 0.00% 245 FICA CONTRIB - CITY SHARE 157 117 168 0 260 300 260 0.00% 260 EMPLOYEE INSURANCE - CITY SHARE 175 253 222 0 76 100 76 0.00% 76 UNEMPLOYMENT COMPENSATION - - - 0 - - - 0.00% - WORKERS COMPENSATION - - - - - - - 0.00% - TOTAL PERSONAL SERVICES 2,668 2,005 2,764 - 3,979 4,322 2,281 0.00% 2,281 MATERIALS & SUPPLIES GENERALSUPPLIES - 32 21 500 - 100 - 80.00% (400) TOTAL MATERIALS & SUPPLIES - 32 21 S00 - - 100 - 80.00% (400) SUPPORT SERVICES /CHARGES CONTRACTUAL SERVICES - 3,758 - 1,000 - 1,000 1,000 0.00% - MISCSERVICES 1,791 3,941 - 3,400 3,210 3,400 3,400 0.00% - TOTAL SUPPORT SERVICES/CHARGES 1,791 7,698 - 4,400 3,210 4,400 4,400 0.00% - TOTAL Sanitation /Weeds /Waste 4,460 9,736 2,785 4,900 7,189 8,722 6,781 38.39% 1,881 BUDGET COMMENTS: SANITATION /WASTE REMOVAL /WEEDS Department: 43200 Budget Budget 2011 2010 101 - Personnel consists of staff time to work the annual spring clean -up day 2,281 - 400 - Contractual Services - roadside spraying 1,000 1,000 -24- TREE MAINTENANCE Fund: General Department: 43250 400 - Contractual Services - covers the cost of trees. Replacement of trees is part of Parks budget, No funds presently allocated for tree inventory To Date Actual Actual Actual Budget PERSONAL SERVICES 2007 2008 2009 2010 FULL -TIME REGULAR 14,538 13,986 5,617 13,28i OVERTIME 159 793 378 - PART -TIME - - - - PERACONTRIB - CITY SHARE 920 961 405 930 FICA CONTRIB - CITY SHARE 1,120 1,117 456 1,016 EMPLOYEE INSURANCE - CITY SHARE 1,064 2,186 657 2,052 UNEMPLOYMENT COMPENSATION - - - - WORKERS COMPENSATION - - 0 % - TOTALPERSONALSERVICES 17,801 19,042 7,512 17,279 MATERIALS & SUPPLIES - 150 -50% (150) MAINTENANCE OF EQUIPMENT 129 - 75 300 SMALL TOOLS AND MINOR EQUIPMENT 373 - - 1,200 GENERALSUPPLIES - 333 362 1,200 TOTAL MATERIALS & SUPPLIES 502 333 437 2,700 SUPPORT SERVICES /CHARGES TRAVEL, CONFERENCE & SCHOOLS - - - 500 CONTRACTUAL SERVICES 11,295 4,975 9,501 13,000 TOTAL SUPPORT SERVICES /CHARGES 11,295 4,975 9,501 13,500 TOTAL Tree Maintenance 29,598 24,351 17,450 33,479 BUDGET COMMENTS: TREE MAINTENANCE Department: 43250 101- Personnel consists of a A FTE LEO and is based on actual time indicated in first 6 months of 2010 includes all increases and benefits, 400 - Contractual Services - covers the cost of trees. Replacement of trees is part of Parks budget, No funds presently allocated for tree inventory To Date Projected Draft 3 Percent Dollar 2010 Year End 2011 Increase Increase 7,394 13,275 10,837 -18% (2,444) 316 500 - 0% - - - 0 % - 540 964 786 -15% (144) 577 1,054 829 -18% (187) 230 495 1,568 -24% (484) 0 % 0 % 9,056 16,288 14,020 -19% (3,259) - - 150 -50% (150) - 500 775 -35% (425) 34 175 500 -58% (700) 34 675 1,425 -47% (1,275) 6,126 6,126 15,216 12,250 12,250 29,213 2011 Budget 14,020 250 13,000 13,250 28,695 50% 0% -2% 14% (250) (250) (4,784) 13,000 2010 Budget 17,279 13,000 95- PARKS AND RECREATION PERSONAL SERVICES FULL -TIME REGULAR OVERTIME PART -TIME TEMPORARY REGULAR OTHER SEVERANCE PAY PERA CONTRIB - CITY SHARE FICA CONTRIB - CITY SHARE EMPLOYEE INSURANCE - CITY SHARE UNEMPLOYMENT COMPENSATION WORKERS COMPENSATION TOTAL PERSONAL SERVICES MATERIALS & SUPPLIES MAINTENANCE OF EQUIPMENT MAINTENANCE OF BUILDINGS SMALL TOOLS AND MINOR EQUIPMENT GENERAL SUPPLIES TOTAL MATERIALS & SUPPLIES SUPPORT SERVICES /CHARGES CONSULTING FEES ENGINEERING FEES LEGAL FEES COMMUNICATIONS - TELEPHONE TRAVEL, CONFERENCE & SCHOOLS PRINTING AND PUBLISHING UTILITY SERVICES CONTRACTUAL SERVICES RENTALS DUES AND SUBSCRIPTIONS MISC SERVICES TOTAL SUPPORT SERVICES /CHARGES CAPITAL OUTLAY LAND PURCHASE MACHINERY & EQUIPMENT OTHER IMPROVEMENTS TOTAL CAPITAL OUTLAY TRANSFERS OPERATING TRANSFERS TOTALTRANSFERS TOTAL Parks & Recreation Actual Actual Actual Budget To Date Projected Draft 3 Percent Dollar 2007 2008 2DO9 2010 2010 Year End 2011 Increase Increase 84,582 90,462 95,949 105,017 46,343 95,950 124,702 18.74% 19,665 1,416 2,267 2,222 500 1,671 2,350 2,500 400.00% 2,000 17,832 22,121 22,100 20,306 12,47S 22,200 22,000 8.34% 1,694 - - - - 0,00% - 0.00% - - - - 0.00% - 5,323 6,160 6,773 8,808 3,411 6,775 9,041 2.65% 233 7,528 8,204 8,575 9,625 4,340 8,57S 9,540 -0.88% (85 9,905 9,947 11,913 16,225 3,966 11,896 17,92S 10.48% 1,700 6 0.00% 0.00% 126,592 139,162 147,532 160,481 72,205 147,748 185,708 15.72% 25,227 321 1,406 841 1,500 720 1,000 5,000 233.33% 3,500 686 207 284 4,000 360 500 5,000 25.00% 1,000 18 138 63 800 462 800 800 0.00% - 7,811 13,059 8,906 10,000 5,818 10,000 10,000 0.00% - 8,836 14,810 10,094 16,300 7,360 12,300 20,800 27.61% 4,500 - - - - 0.00% - 14,013 - - - - 0.00% - 0.00% 2,015 1,673 1,695 2,000 874 1,700 1,900 -5.00% (100) - 27 - 300 - - 300 0.00°% - 987 1,458 - 1,000 105 27S 1,000 0.00% - 7,665 9,873 8,179 9,000 3,958 8,250 9,000 0.00% 34,262 49,178 73,949 70,000 36,299 72,598 70,000 0.00% - 10,562 12,534 11,709 9,200 5,S67 11,150 9,500 3.26% 300 0.00% 538 236 1,100 - - 1,100 0.00% - 55,492 75,282 109,780 92,600 46,802 93,973 92,800 0.22% 200 10,000 10,000 15,000 15,000 45,000 42,000 - 42,000 42,000 15,000 15,000 45,000 42,000 - 42,000 42,000 215,920 244,255 312,405 311,381 126,367 296,021 341,308 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 9.615A 29,927 -26- BUDGET COMMENTS: PARKS & RECREATION /BEACHES DEPT 45200 Code# Budget 2011 Budget2010 101 Personnel FT consists of 1.7 FTE LEO and .6 FTE clerical covers all costs 119,473 140,175 including salary and benefits. 2010 included higher FTE load - 2011 more realistic 103 covers part -time employees including rink attendants and part-time 22,000 20,306 summer help 221 Maintenance to park equipment. Increse this line to accommodate general maintenance. 5,000 1,500 223 Park building maintenance 5,000 4,000 240 Small tools and supplies 800 800 245 General supplies e.g. seed, sand, dirt, rock, etc. 10,000 10,000 321 Telephone 1,900 2,000 331 Conferences, travel, and schools 300 300 380 Utilities 1,000 1,000 400 Contractual services and programming Park Coordinator Contract 56,600 53,000 Music in the park 2,500 2,500 Lifeguards 3,900 3,900 AIS Contribution 4,000 6,000 Other Programs - Fun Friday's, Music in the Park, safety camp, Arctic Fever, etc. 3,000 3,000 Buckthorn Removal - 1,600 70,000 70,000 410 Rental - porta - potties 9,500 9,200 440 Mlscellaneaous Services - 1,100 1,100 720Transferto Park Capital Improvement Fund 42,000 42,000 1 did not include a full -time park and rec./ SSCC supervisor position for this year. While I believe this is some thing for the city to consider, 1 think we need to wait until 2012 to see what happens with the SSCC. 77- Southshore Community Center FUND: Southshore Community Center -490 Department: 4800 Percent Increase 20.15% #DIV /0! #DIV /0! #DIV /0! -9.09% 27.09% Dollar Increase 8,720 2,500 100 1,000 (150) 12,170 Personnel FULL -TIME REGULAR PART -TIME PERA CONTRI B - CITY SHARE FICA CONTRI B - CITY SHARE EMPLOYEE INSURANCE - CITY SHARE Total Personnel 92 100 7,042 14,000 499 986 546 1,071 8,180 16,157 #DIV /0! #DIV /0! #DIV /0! #DIV /0! #DIV /0! #DIV /01 MATERIALS & SUPPLIES Actual Actual Actual Budget Year to date Projected Draft 3 REVENUE SOURCE 2007 2008 2009 2010 2010 2010 2011 Rentals 34,729 43,280 26,488 48,000 52,000 Class fees - - 1,928 2,500 2,500 Interest Income 344 - 60 100 100 Contributions /Donations 1,321 - 1,240 1,500 1,000 Miscellaneous Revenue 245 1,650 3,850 4,000 1,500 Totals - - 36,639 44,930 33 567 56 100 57,100 Percent Increase 20.15% #DIV /0! #DIV /0! #DIV /0! -9.09% 27.09% Dollar Increase 8,720 2,500 100 1,000 (150) 12,170 Personnel FULL -TIME REGULAR PART -TIME PERA CONTRI B - CITY SHARE FICA CONTRI B - CITY SHARE EMPLOYEE INSURANCE - CITY SHARE Total Personnel 92 100 7,042 14,000 499 986 546 1,071 8,180 16,157 #DIV /0! #DIV /0! #DIV /0! #DIV /0! #DIV /0! #DIV /01 MATERIALS & SUPPLIES 8,279 500 - Maintenance of Building 10,497 10,800 3,487 7,200 7,500 - 30.56% (3,300) General Supplies 1,744 2,400 466 800 800 - 66.67% (1,600) Total - - 12,241 13,200 3,953 8,000 8,300 - 37.12% (4,900) OTHER SERVICES Consulting Engineering Legal 8,279 500 - - - - 100.00% (500) Communication 75 1,500 18 20 100 - 93.33% (1,400) Print /Publish 2,025 5,000 111 1,000 1,000 - 80.00% (4,000) Insurance -Total 9,415 2,500 701 2,500 3,000 20.00% 500 Utilities 4,119 6,300 6,156 11,000 11,000 74.60% 4,700 Contractual 19,424 23,656 11,148 30,000 35,000 47.95% 11,344 Misc. Services 11,865 4,500 7,166 10,000 10,000 122.22% 5,500 Bank Service Charges - 1 - #DIV /01 - Total - - 55,203 43,956 25,302 54 ,520 60,100 36.73% 16,144 CAPITAL OUTLAY Building & Structures 13,686 - - - #DIV /01 - Total - - 13,686 - - - - #DIV /0! - TOTAL - - 81,130 57,156 37,434 78,677 68,400 19.67% 11,244 Revenue over /(under) Expenditure (44,491) (12,226) (3,867) (22,577) (11,300) SSCC Budget Notes Personnel - 2010 staff time allocated to SSCC. The idea was not to allocate time specifically to the SSCC. Current time allocated will be re- allocated to proper department and no allocation made in 2011- we will track time on time sheets. Maintenance of Building general custodial for regualr custodial maintenance General Supplies used for paper goods, cleaning supplies, etc. Communication - web hosting and telephone services Printing and Publishing covers marketing material for events and classes at the center. Contractual includes management contract with CRR, maintenance agreements, etc. Miscellaneous Services covers custodial for events and other miscellaneous costs related to rental Building Structures & Maintenance possible new sign for the Center and other general maintance for the building. Funds come from transfer from the Public Facilities fund, donations from other cities, and donations from others. -28- 9 CAPITAL IMPROVEMENT FUNDS Actual Actual Actual Budget To Date Projected Draft 3 Fund 2007 2008 2009 2010 2010 Year End 2011 401- Public Facilities Revenue 311,498 267,101 229,095 227,763 228,617 229,263 227,240 Expenditures 100,055 40,345 1,332 22,000 2,376 14,035 15,035 Fund Balance 211,443 226,756 227,763 205,763 226,240 215,228 212,205 402 - Park Improvements Revenue 364,630 309,008 310,876 335,431 294,494 442,631 205,131 Expenditures 80,423 46,297 17,445 218,800 7,104 281,000 212,200 Fund Balance 284,207 262,711 293,431 116,631 287,389 161,631 (7,069) 403 - Equipment Revenue 589,300 691,621 855,042 944,099 847,054 949,099 816,564 Expenditures 89,422 18,860 10,943 200,939 155,244 234,035 241,461 Fund Balance 499,878 672,761 844,099 743,160 691,810 715,064 575,103 404 - Local Streets Revenue 1,723,930 2,053,791 2,434,118 2,416,655 1,720,763 2,424,555 2,081,000 Expenditures 335,179 330,816 717,463 885,361 87,378 1,047,555 995,865 Fund Balance 1,388,751 1,722,975 1,716,655 1,531,294 1,633,384 1,377,000 1,085,135 408 - Technology Revenue 100,000 103,517 104,539 104,525 104,880 85,025 105,078 Expenditures - 17 14 20,000 3 35 35 Fund Balance 100,000 103,500 104,525 84,525 104,878 84,990 105,043 450 - Community infrastructure Revenue - - 1,000,000 1,000,000 1,002,521 1,006,000 1,007,521 Expenditures - - - - - Fund Balance 1,000,000 1,000,000 1,002,521 1,006,000 1,007,521 W PUBLIC FACILITIES FUND Note: Set aside $10,000 for potenial repair and maintenance to the SSCC -30- Actual Actual Actual Budget To Date Projected Draft 3 Revenue 2007 2008 2009 2010 2010 Year End 2011 Beginning Balance 249,068 211,443 226,756 227,763 227,763 227,763 226,240 Interest Earnings 12,430 5,657 2,339 - 854 1,500 1,000 Miscellaneous Income - - - - - Transfers in 50,000 50,000 - - - _ Total Revenue 311,498 267,101 229,095 227,763 228,617 229,263 227,240 Expenditures Support Services and Charges Contractual Services - - 132 - - _ Miscellaneous Services - - 1,176 - Bank Charges 55 41 24 - 5 35 35 Total 55 41 1,332 - 5 35 35 Capital Machinery and Equipment - 40,304 - - _ - Other Improvements - - - 22,000 2,371 14,000 15,000 Total - 40,304 - 22,000 2,371 14,000 15,000 Transfers out Operating Transfers - _ - - Residential House 100,000 Total 100,000 - - - _ Total Expenses 100,055 40,345 1,332 22,000 2,376 14,035 15,035 Revenue over /(under) 211,443 226,756 227,763 205,763 226,240 215,228 212,205 Note: Set aside $10,000 for potenial repair and maintenance to the SSCC -30- Parks Improvements Fund: Park CIP 402 Actual Actual Actual Budget To Date Projected Draft 3 Revenue 2007 2008 2009 2010 2010 Year End 2011 Beginning Fund Balance 319,907 284,207 262,711 293,431 293,431 293,431 161,631 Park Dedication Fees 8,000 2,000 - - _ - _ Interest Earnings 16,223 7,801 2,771 - 1,063 3,000 1,500 Contributions / donations 5,500 - _ _ - Concession Sales - - 394 - - _ - Grants - - - - - 104,200 - Miscellaneous revenue - _ - Transfers in 15,000 15,000 45,000 42,000 - 42,000 42,000 Total Revenue 364,630 309,008 310,876 335,431 294,494 442,631 205,131 Expenditures Support Services and Charges Engineering - Design 458 - - 750 1,000 - Contractrual Services 25,417 - 3,800 - - _ - Miscellaneous Charges 72 598 40 - - _ - Total 25,947 598 3,840 - 750 1,000 - Capital Machinery and Equipment 53,284 - - _ - - _ Other Improvements 1,192 45,699 13,605 218,800 6,354 280,000 212,200 Total 54,476 45,699 13,605 218,800 6,354 280,000 212,200 Total Expenditures 80,423 46,297 17,445 218,800 7,104 281,000 212,200 Revenue - Over /(under) 284,207 262,711 293,431 116,631 287,389 161,631 (7,069) Year End Balance 284,207 262,711 293,431 116,631 287,389 161,631 (7,069) EQUIPMENT FUND FUND 403 - Equipment CIP 32- Actual Actual Actual Budget To Date Projected Draft 3 Revenue 2007 2008 2009 2010 2010 Year End 2011 Beginning Balance 394,480 499,878 672,761 844,099 844,099 844,099 715,064 Interest Earnings 19,820 16,743 7,281 - 2,954 5,000 1,500 Miscellaneous Income - Transfers in 175,000 175,000 175,000 100,000 - 100,000 100,000 Total Revenue 589,300 691,621 855,042 944,099 847,054 949,099 816,564 Expenditures Support Services and Charges Engineering Fees 28,230 30,000 Contractual Services - 2,181 1,126 - _ - - Miscellaneous Services _ - Bank Charges 88 94 71 - 18 35 35 Total 88 2,275 1,197 - 28,248 30,035 35 Capital Machinery and Equipment 89,334 16,585 9,746 200,939 126,996 204,000 241,426 Other Improvements - - - _ Total 89,334 16,585 9,746 200,939 126,996 204,000 241,426 Transfers out Operating Transfers - - _ _ Total - Total Expenses 89,422 18,860 10,943 200,939 155,244 234,035 241,461 Revenue over /(under) 499,878 672,761 844,099 743,160 691,810 715,064 575,103 32- LOCAL STREETS FUND: 404 Local Street CIP Transfers out Operating Transfers - - - _ _ _ - Total - - Total Expenses 335,179 330,816 717,463 885,361 87,378 1,047,555 995,865 Revenue over /(under) 1,388,751 1,722,975 1,716,655 1,531,294 1,633,384 1,377,000 1,085,135 ca_ Actual Actual Actual Budget To Date Projected Draft 3 Revenue 2007 2008 2009 2010 2010 Year End 2011 Beginning Balance 1,322,926 1,388,751 1,722,975 1,716,655 1,716,655 1,716,655 1,377,000 MSA Maintenance Money - _ - _ - _ _ Interest Earnings 56,004 20,040 11,143 - 4,108 7,900 4,000 Miscellaneous Income - _ Transfers in 345,000 645,000 700,000 700,000 - 700,000 700,000 Total Revenue 1,723,930 2,053,791 2,434,118 2,416,655 1,720,763 2,424,555 2,081,000 Expenditures Materials and Supplies General Supplies 7,040 46,198 18,917 - - - Total 7,040 46,198 18,917 - - - - Support Services and Charges Engineering Fees 63,294 384 34,904 - 131 Legal Fees - - 889 _ - - Engineering Feasibility - - 5,323 - - - Engineering Design 24,810 - 123,696 - 75,597 100,000 Engineering Survey - 6,777 - - - _ Engineering Construction 141,059 274,630 378,730 885,361 - 900,000 995,830 Printing and Publishing 290 - 1,591 - 1,381 1,500 - Contractual Services 98,422 - 152,266 - 9,545 45,000 Taxes /License - - 475 - 452 500 Miscellaneous Services - 2,691 593 - 250 500 - Bank Charges 265 136 80 - 22 55 35 Total 328,139 284,618 698,546 885,361 87,378 1,047,555 995,865 Capital Machinery and Equipment - - - _ _ _ - Other Improvements - Total Transfers out Operating Transfers - - - _ _ _ - Total - - Total Expenses 335,179 330,816 717,463 885,361 87,378 1,047,555 995,865 Revenue over /(under) 1,388,751 1,722,975 1,716,655 1,531,294 1,633,384 1,377,000 1,085,135 ca_ TECHNOLOGY FUND FUND: 408 Technology ciP Revenue Beginning Balance Interest Earnings Miscellaneous Income Transfersin Total Revenue Expenditures Support Services and Charges Engineering Fees Contractual Services Miscellaneous Services Bank Charges Total Capital Machinery and Equipment Other Improvements Total Transfers out Operating Transfers Total Total Expenses Revenue over /(under) Actual Actual Actual Budget To Date Projected Draft 3 2007 20D8 2009 2010 2010 Year End 2011 100,000 100,000 103,500 104,525 104,525 84,525 104,878 - 3,517 1,039 - 356 500 200 100,000 103,517 104,539 104,525 104,880 85,025 105,078 17 14 17 14 3 3 35 35 35 35 - 17 14 100,000 103,500 104,525 20,000 20,000 - 20,000 3 84,525 104,878 16,000 16,000 - 16,035 35 68,990 105,043 34- COMMUNITY INFRASTRUCTURE FUND FUND: 450 Internal Loan Fund Transfers out Operating Transfers Total Total Expenses - - - - _ _ _ Revenue over /(under) - - 1,000,000 1,000,000 1,002,521 1,006,000 1,007,521 _q - Actual Actual Actual Budget To Date Projected Draft Revenue 2007 2008 2009 2010 2010 Year End 2011 Beginning Balance - - - 1,000,000 1,000,000 1,000,000 1,002,521 Interest Earnings - - - - 2,521 6,000 5,000 Miscellaneous Income Transfers in - - 1,000,000 - - _ Total Revenue - - 1,000,000 1,000,000 1,002,521 1,006,000 1,007,521 Expenditures Support Services and Charges Engineering Fees Contractual Services Miscellaneous Services Bank Charges Total Capital Machinery and Equipment Other Improvements Total Transfers out Operating Transfers Total Total Expenses - - - - _ _ _ Revenue over /(under) - - 1,000,000 1,000,000 1,002,521 1,006,000 1,007,521 _q - City of Shorewood, Minnesota Capital Improvement Program 2011 thru 2020 SOURCES AND USES OF FUNDS Source 2011 2012 2013 2014 . 2015 2016 2017 2018 2019 2020 Equipment Replacement Fund 100,000 100,000 Beginning Balance 842,786 651,360 515,040 376,485 279,971 115,430 196,187 152,648 221,131 281,750 Revenues and Other Fund Sources 50,000 75,000 Other Fund Sources 75,000 100,000 Transfers In 50,000 75,000 75,000 75,000 100,000 100,000 100,000 100,000 100,000 100,000 G, Total Revenues and Other Fund Sources m Total Funds Available Expenditures and Uses Capital Projects & Equipment Equipment Replacement Generac Mobile Generator w /trailer E -00 -71 F350 44 Pickup w /plow E -07 -55 Skid Steer - Bobcat 753 E -10 -63 Groundsmaster Mower- Toro 328D E -10 -75 Track Excavator E -11 -22 Dump Truck - Ford L8000 (1988) E -11 -33 Trailer 24'- Trail King E -12 -21 Trailer 12' Tops E -1241 Sand Pro 3000 E -12 -64 Dump Truck - Ford E -12-68 Mower - Toro Ground master 328D E -12 -84 Mower- Toro Walk Behind Proline 44 E -12 -95 Zonal 50,000 75,000 75,000 75,000 100,000 100,000 100,000 100,000 100,000 100,000 50,000 75,000 75,000 75,000 100,000 100,000 100,000 100,000 100,000 100,000 892,786 726,360 590,040 451,485 379,971 215,430 296,187 252,648 321,131 381,750 0 0 0 0 0 0 0 0 0 (97,395) 0 0 0 0 0 0 (63,305) 0 0 0 0 0 0 0 0 0 (40,668) 0 0 0 0 0 0 0 0 0 (39,566) 0 0 0 (100,000) 0 0 0 0 0 0 0 0 0 (141,426) 0 0 0 0 0 0 0 0 0 0 (15,017) 0 0 0 0 0 0 0 0 0 (3,716) 0 0 0 0 0 0 0 0 0 (13,159) 0 0 0 0 0 0 0 0 0 (148,930) 0 0 0 0 0 0 0 0 0 (27,092) 0 0 0 0 0 0 (39,381) 0 0 (3,406) 0 0 0 0 0 0 0 0 Source 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 F gmpment Replacement Fund (213,555) (171,514) (264,541) (19,243) (143,539) (31,517) (39,381) (307,768) Change in Fund Balance (191,426) (136,320) Air Compressor- Ingersoll Rand 185 E -13 -38 0 0 (12,715) 0 0 0 0 0 0 0 Dump Truck E -13-65 0 0 (156,824) 0 0 0 0 0 0 (210,373) Pick -up -4 x 4 Ford F150 E -13 -78 0 0 (30,974) 0 0 0 0 0 0 0 Attach- two(2) Cabs for Groundmaster E -13 -90 0 0 (13,042) 0 0 0 0 0 0 0 Mower -Toro Groundsmaster325D E -14 -70 0 0 0 (27,464) 0 0 0 0 0 0 Ford F450 Wity Truck -with crane &toolbox E -14 -76 0 0 0 (97,842) 0 0 0 0 0 0 Dodge Grand Caravan E -14 -77 0 0 0 (23,688) 0 0 0 0 0 0 Attach -Two (2) Blowers for Grndsmstr (1972 & 2000) E -14 -89 0 0 0 (15,654) 0 0 0 0 0 0 Attach -Cab for Groundsmaster (1985) E-14-92 0 0 0 (6,866) 0 0 0 0 0 0 Loader - Cat -IT28F E -15 -56 0 0 0 0 (197,000) 0 0 0 0 0 Pickup - 4 x 4 Ford F150 E -1580 0 0 0 0 (27,780) 0 0 0 0 0 Pickup - 4 x 4 Ford 350 E -15-81 0 0 0 0 (39,761) 0 0 0 0 0 AMT -John Deere 622 E -16 -99 0 0 0 0 0 (19,243) 0 0 0 0 Groundsmaster Mower E -18-67 0 0 0 n n n n n14171 n a J Total (241,426) (211,320) (213,555) (171,514) (264541) (19,243) (143,539) (31,517) (39,381 (307,768) Total Expenditures and Uses (241,426) (211,320) (213,555) (171,514) (264,541) (19,243) (143,539) (31,517) (39,381) (307,768) Change in Fund Balance (191,426) (136,320) (138,555) (96,514) (164,541) 80,757 (43,539) 68,483 60,619 (207,768) Ending Balance 651,360 515,040 376,485 279,971 115,430 196,187 152,648 221,131 281,750 73,982 City of Shorewood, Minnesota Capital Improvement Program 2011 thru 2020 SOURCES AND USES OF FUNDS Source 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 - -- 1 Local Stre Reconstruction 775,000 Beginning Balance 1,619,643 1,373,813 667,463 670,979 542,544 65,206 (63,790) (1,215,511) (1,660,364) (2,068,754) Revenues and Other Fund Sources 825,000 Other Fund Sources 825,000 Transfers In 750,000 775,000 775,000 775,000 800,000 800,000 825,000 625,000 825,000 825,000 Total 750,000 775,000 775,000 775,000 800,000 800,000 825,000 825,000 825,000 825,000 w Total Revenues and Other Fund Sources 750,000 775,000 775,000 775,000 800,000 800,000 825,000 825,000 825,000 825,000 m Total Funds Available 2,369,643 2,148,813 1,442,463 1,445,979 1,342,544 865,206 761,216 (390,511) (835,364) (1,243,754) Expenditures and Uses Capital Projects & Equipment Loral Street Reconstruction Star Roads (Circle &Lane) - Reconstruct LR -11 -01 (593,989) 0 0 0 0 0 0 0 0 0 Vine Hill Road: Mill & Overlay (Shorewood portion) LR -11 -02 (176,741) 0 0 0 0 0 0 0 0 0 Valleywood Circle &Lane - Reconstruct LR -12 -01 0 (1,055,850) 0 0 0 0 0 0 0 0 Afton Rd - Reclaim LR -13 -01 0 0 (196,013) 0 0 0 0 0 0 0 Sunnyvale Lane - Reclaim LR -13 -02 0 0 (128,696) 0 0 0 0 0 0 0 Club Valley - Reclaim LR -14 -01 0 0 0 (135,130) 0 0 0 0 0 0 Lake Virginia Drive - Reclaim LR -14 -02 0 0 0 (299,191) 0 0 0 0 0 0 Gillette Curve - Reclaim LR -15-01 0 0 0 0 (139,704) 0 0 0 0 0 Garden - Reconstruct LR -15 -02 0 0 0 0 (645,054) 0 0 0 0 0 Echo Rd LR -16 -01 0 0 0 0 0 (411,798) 0 0 0 0 Riviera Lane LR -17 -01 0 0 0 0 0 0 (1,022,134) 0 0 0 Mapie Recopstmcbon LR -17 -02 0 0 0 0 0 0 (265,930) 0 0 0 Source 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Local Street Reconstruction Mann Reclimation LR -17 -03 0 0 0 0 0 0 (145,600) 0 0 0 Strawberry Lane LR -18 -01 0 0 0 0 0 0 0 (699,642) 0 0 West reclimation LR -19 -01 0 0 0 0 0 0 0 0 (157,075) 0 Seamans reclimation LR -19 -02 0 0 0 0 0 0 0 0 (477,594) 0 Shady Island Point Reclimation LR -20 -01 0 0 0 0 0 0 0 0 0 (50,147) Shorewood Lane Reclimation LR -20 -02 0 0 0 0 0 0 0 0 0 (202,507) Maintenance - Bituminous Sealcoating LR -99 -100 (225,100) (236,300) (248,115) (260,521) (273,547) (287,224) (301,585) (316,665) (332,498) (349,123) Maintenance- Bituminous Overlays LR -99 -99 0 (189,200) (198,660) (208,593) (219,023) (229,974) (241.472) /253.546) (266.223) 1279.535) Total (995,830) (1,481,350) (771,484) (903,435) (1,277,338) (928,996) (1,976,721) (1,269,853) (1,233,390) (881,312) Total Expenditures and Uses Change in Fund Balance (995,830) (1,481,350) (771,484) (903,435) (1,277,338) (928,996) (1,976,721) (1,269,853) (1,233,390) (881,312) (245,830) (706,350) 3,516 (128,435) (477,338) (128,996) (1,151,721) (444,853) (408,390) (56,312) Ending Balance 1,373,813 667,463 670,979 542,544 65,206 (63,790) (1,215,511) (1,660,364) (2,068,754) (2,125,066) City of Shorewood, Minnesota Capital Improvement Program 2011 thru 2020 SOURCES AND USES OF FUNDS Source 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Park Fund 50,000 Beginning Balance 293,430 123,230 64,465 13,465 (270,535) (596,535) (801,535) (801,535) (1,086,535) (1,331,535) Revenues and Other Fund Sources 45,000 45,000 45,000 Other Fund Sources 50,000 50,000 50,000 Transfers In 42 000 45 000 45 000 45 000 45 000 50 000 50,000 50,000 50,000 50.0 Total 42,000 45,000 45,000 45,000 45,000 50,000 50,000 50,000 50,000 50,000 Total Revenues and Other Fund Sources a 42,000 45,000 45,000 45,000 45,000 50,000 50,000 50,000 50,000 50,000 0 Total Funds Available 335,430 168,230 109,465 58,465 (225,535) (546,535) (751,535) (751,535) (1,036,535) (1,281,535) Expenditures and Uses Capital Projects & Equipment Parks Badger Park - Tennis Court Resurface P -10 -04 0 0 (8,000) 0 0 0 0 0 0 0 All Parks- Tot Lot Equipment P -10 -12 0 (12,000) 0 (12,000) 0 0 0 0 0 0 Signage -All parks & entry points P -11 -01 (30,000) 0 0 0 0 0 0 0 0 0 Slivenvood Slide P -11 -02 (7,000) 0 0 0 0 0 0 0 0 0 Freeman South Play equipment P -11 -03 (60,000) 0 0 0 0 0 0 0 0 0 Cathcart Swing P -11 -05 (500) 0 0 0 0 0 0 0 0 0 Freeman Park- Picnic Shelter Re -roof P -11 -06 (2,200) 0 0 0 0 0 0 0 0 0 Badger Park- Warming House Rehab P -11 -08 (5,000) 0 0 0 0 0 0 0 0 0 Freeman Hockey Rink P -11 -09 (,90,000) 0 0 0 0 0 0 0 0 0 Freeman Sliding Hill P -11 -10 (1,000) 0 0 0 0 0 0 0 0 0 Badger Park Green Space P -12 -02 0 (20,000) 0 0 0 0 0 0 0 0 Badger Park - Install Rustic Trail P -12 -03 0 (7,500) 0 0 0 0 0 0 0 0 Source 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Park Fund y Silvenvood Park - benches P -12 -04 0 (765) 0 0 0 0 0 0 0 0 Badger Park - Benches P -12 -05 0 (7,500) 0 0 0 0 0 0 0 0 Silvenvood Park - Resurface 112 court P -12 -06 0 (2,000) 0 0 0 0 0 0 0 0 Manor Park- Resurface Tennis Courts P -12 -07 0 (6,000) 0 0 (6,000) 0 0 0 0 0 Cathcart Park- Resurface tennis Courts P -12 -08 0 (6,000) 0 0 0 0 0 0 0 0 Cathcart Park- New Rink Boards P -12 -09 0 (20,000) 0 0 0 0 0 0 0 0 Remove Hockey Rink - Badger Park P -12 -10 0 (10,000) 0 0 0 0 0 0 0 0 Silvenvood Park - Equipment P -13 -01 0 0 (60,000) 0 0 0 0 0 0 0 Skate Park - Shelter P -13 -04 0 0 (16,000) 0 0 0 0 0 0 0 Skate Park -Rehab P -14-02 0 0 0 (70,000) 0 0 0 0 0 0 Silvenvood Trail P -14 -03 0 0 0 (15,000) 0 0 0 0 0 0 Silvenvood Drinking Fountain P -14 -04 0 0 0 (7,000) 0 0 0 0 0 0 Manor Park Trail P -14 -05 0 0 0 (15,000) 0 0 0 0 0 0 Freeman Park Lot P -14 -07 0 0 0 (100,000) 0 0 0 0 0 0 Crescent Beach P -14 -08 0 0 0 (5,000) 0 0 0 0 0 0 P Cathcart Parking P -14 -09 0 0 0 (100,000) 0 0 0 0 0 0 Manor Parking Lot P -15 -01 0 0 0 0 (100,000) 0 0 0 0 0 Freeman Park Replacement Play Equipment -North P -15 -02 0 0 0 0 (60,000) 0 0 0 0 0 Manor Tennis Court P -15 -03 0 0 0 0 (200,000) 0 0 0 0 0 Silvenvood 112 court P -16 -01 0 0 0 0 0 (75,000) 0 0 0 0 Cathcart Park Shelter P -15 -02 0 0 0 0 0 (90,000) 0 0 0 0 Badger Park Equipment P -16 -03 0 0 0 0 0 (65,000) 0 0 0 0 Skate Park P16 -04 0 0 0 0 0 (25,000) 0 0 0 0 Tenn is Courts P -17 -02 0 0 0 0 0 0 (50,000) 0 0 0 Sliverwood Park P -18 -01 0 0 0 0 0 0 0 (50,000) 0 0 Cathcart Park Improvement P -18 -02 0 0 0 0 0 0 0 (100,000) 0 0 Play Structure P -18 -03 0 0 0 0 0 0 0 (60,000) 0 0 Badger Court lights P -18 -04 0 0 0 0 0 0 0 (45,000) 0 0 Badger Shelter P -18 -05 0 0 0 0 0 0 0 (80,000) 0 0 Freeman Park - Wetland Enhancement P -19 -01 0 0 0 0 0 0 0 0 (200,000) 0 Silvenvood improvement P -19 -02 0 0 0 0 0 0 0 0 (70,000) 0 Source 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 I y ark F und 0 0 Total (212,200) (103,765) (96,000) (329,000) (371,000) Performance "Green" P -19 -03 0 0 0 0 0 0 0 0 (20,000) 0 Freeman Plaza P -19 -04 0 0 0 0 0 0 0 0 (5,000) 0 Landscaping and trees P -99 -100 (5,000) (5,000) (5,000) (5,000) (5 0 0 0 0 0 Picnic Tables P -99 -99 (7000) /7 00(n 17 00(n 0 0 64,465 13,465 (270,535) N 0 0 0 0 0 Total (212,200) (103,765) (96,000) (329,000) (371,000) (255,000) (50,000) (335,000) (295,000) 0 Total Expenditures and Uses (212,200) (103,765) (96,000) (329,000) (371,000) (255,000) (50,000) (335,000) (295,000) 0 Change in Fund Balance (170,200) (58,765) (51,000) (284,000) (326,000) (205,000) 0 (285,000) (245,000) 50,000 Ending Balance 123,230 64,465 13,465 (270,535) (596,535) (801,535) (801,535) (1,086,535) (1,331,535) (1,281,535) N