Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
11 16 09 City Council Work Session
BUDGET WORKSHOP 11/16/2009 City of Prior Lake 2010 Proposed Budget . Budgeted Funds Total General Water & Sewer Water Quality Transit Enterprise Budgeted Fund Fund Fund Fund Funds Funds Revenues I Sources Property Taxes Levy - Tax Capacity $ 7,625,503 $ $ $ $ $ 7,625,503 Levy - Market Value 1,084,899 1,084,899 MVHC Aid (227,546) (227,546) Licenses & Permits 269,975 269,975 Fines & Forfeits 182,000 182,000 Intergovernmental 1,327,667 444,661 444,661 1,772,328 Charges for Services 1,382,131 4,619,188 425,000 90,000 5,134,188 6,516,319 Other Revenues 150,917 100,000 100,000 250,917 Transfers 325,000 325,000 Total Revenues I Sources $ 12.120,546 $ 4.719.188 $ 425.000 $ 534.661 $ 5.678.849 $17.799.395 Expenditures I Uses Employee Services $ 6,531,013 $ 1,186,060 $ 148,942 $ 91,206 $ 1,426,208 $ 7,957,221 Current Expenditures 3,431,033 2,519,701 69,425 772,820 3,361,946 6,792,979 Capital Outlay 308,900 24,000 24,000 332,900 Capital Improvements 765,000 225,000 280,636 1,270,636 1,270,636 Subtotal $ 10,270,946 $ 4,494,761 $ 443,367 $ 1,144,662 $ 6,082,790 $ 16,353,736 Transfers to other funds General Fund $ $ 325,000 $ $ $ 325,000 $ 325,000 . Maintenance Building 181,807 181,807 181,807 Treatment Plant 457,989 457,989 457,989 Equipment Fund 90,000 90,000 90,000 Park Equipment Fund 100,000 100,000 Debt Funds 1,680,600 1,680,600 Contingency 69,000 69,000 Subtotal $ 1,849,600 $ 1,054,796 $ $ $ 1,054,796 $ 2,904,396 Total Expenditures I Uses $ 12.120.546 $ 5.549.557 $ 443,367 $ 1.144.662 $ 7,137,586 $ 19.258.132 Change in Fund Balance $ $ (830,369) $ (18,367) $ (610,001) $ (1,458,737) $ (1,458,737) 2010 Proposed Property Tax Levy Change 09 -10 Property Taxes 2009 2010 Amount Percent Levy - Tax Capacity Budgeted Funds: General Fund - Operating $ 7,004,828 $ 7,020,503 $ 15,675 0.22% General Fund - Debt $ 586,120 $ 605,000 $ 18,880 3.22% Non-Budgeted Funds: Debt Service Funds 1,000,993 1,108,784 107,791 10.77% Equipment Fund 250.000 260,000 10,000 4.00% $ 8,841,941 $ 8,994,287 $ 152,346 1.72% Levy - Market Value - General Fund 1.039.614 1,084.899 45.285 4.36% Total Levy $ 9,881.555 $ 10.079.186 $ 197.631 2.00%1 2010 Proposed Budget Comparisons Total General Water & Sewer Water Quality Transit Enterprise Budgeted . Fund Fund Fund Fund Funds Funds 2010 Total Expenditures I Uses 12,120,546 5,549,557 443,367 1,144,662 7,137,586 19,258,132 2009 Total Expenditures I Uses 12,476.974 5.191.706 421.806 810.120 6,423.632 18,900,606 Change 2009 to 2010 ($) (356,428) 357,851 21,561 334,542 713,954 357,526 ChanQe 2009 to 2010 (%) -2.86% 6.89% 5.11% 41.30% 11.11% 1.89% 11/13/2009 BUDGET WORKSHOP 11/16/2009 City of Prior Lake 2010 Proposed Budget Non-Budgeted Funds Debt Revolving Maintenance Treatment Park Equip Service Equipment Building Plant Fund Non-Budgeted Budgeted Total Funds Fund Fund Fund (NEWl Funds Funds Funds Revenues I Sources Property Taxes Levy - Tax Capacity 1,108,784 260,000 1,368,784 7,625,503 8,994,287 Levy - Market Value Referendum 1,084,899 1,084,899 MVHC Aid (227,546) (227,546) Licenses & Permits 269,975 269,975 Fines & Forfeits 182,000 182,000 Intergovernmental 1,772,328 1,772,328 Charges for Services 6,516,319 6,516,319 Other Revenues 250,917 250,917 Transfers 1,680,600 90,000 181,807 457,989 100,000 2.510,396 325,000 2,835,396 Total Revenues I Sources 2.789.384 350.000 181,807 457,989 100.000 3.879.180 17,799.395 21.678,575 Expenditures I Uses Employee Services 7,957,221 7,957,221 Current Expenditures 6,792,979 6,792,979 Capital Outlay 332.900 332,900 Capital Improvements 1,270,636 1,270.636 Subtotal 16,353,736 16.353,736 Transfers to other funds General Fund 325,000 325.000 Maintenance Building 181,807 181,807 Treatment Plant 457,989 457,989 Equipment Fund 90,000 90,000 ~ p,,,, Eq";p~", '""' 100,000 100,000 Debt Funds 1,680,600 1,680,600 mgency 69,000 69,000 Subtotal 2,904,396 2,904,396 I Total Expenditures I Uses 19.258.132 19,258.132 I I Chan~e in Fund Balance 2.789,384 350.000 181,807 457,989 100,000 3,879.180 (1.458.737) 2.420.443 . 11/13/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 . 2010 Proposed Budget Revenue Summary 2009 2010 2009 2010 $ Change % Change %of %of General Fund Adopted Proposed 09 - 10 09 -10 Total Total Taxes 8,404,562 8,482,856 78,294 0.93% 67.36% 69.99% Licenses and permits 454,180 269,975 (184,205) -40.56% 3.64% 2.23% Intergovernmental 1,342,679 1,327,667 (15,012) -1.12% 10.76% 10.95% Charges for services 1,532,553 1,382,131 (150,422) -9.82% 12.28% 11.40% Fines and forfeitures 222,000 182,000 (40,000) -18.02% 1.78% 1.50% Interest on investments 120,000 90,000 (30,000) -25.00% 0.96% 0.74% Other 76,000 60,917 (15,083) 0.00% 0.61% 0.50% Transfers from other funds 325,000 325,000 0 0.00% 2.60% 2.68% Total General Fund 12,476,974 ,_._12.13.0,546 (356,428) -2.86% 100.00% 100.00% Water & Sewer Fund Charges for services - water 2,723,963 2,702,938 (21,026) 0.00% 55.82% 57.28% Charges for services - sewer 1,916,250 1,916,250 0.00% 39.27% 40.61% Interest on investments 240,000 100,000 (140,000) -58.33% 4.92% 2.12% Total Water & Sewer Fund 4.880,213 4,719,188 (161.02~ -3.30% 100.00% 100.00% Water Quality Fund ICharges for services - storm water 425,000 425,000 0.00% 100.00% 100.00% . I Total Water Quality Fund 425,000 425,000 0 0.00% 100.00% 100.00% Transit Fund I Charges for services - transit revenue 830,058 534,661 (295,397) -35.59% 100.00% 100.00% I Total Transit Fund 830.058 534,661 (295,397) -35.59% 100.00% 100.00%' GRAND TOTAL 18,612,245 17,799,395 (812,851 ) -4.37% . 11/13/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget . Fund/Department Expense Summary 2009 2010 2009 2010 $ Change % Change %of %of General Fund Adopted Proposed 09 - 10 09 - 10 Total Total 41110 Mayor & Council 70,131 65,453 (4,678) -6.67% 0.56% 0.54% 41130 Ordinance 11,000 7,000 (4,000) -36.36% 0.09% 0.06% 41320 Administration(1) 388,036 352,039 (35,997) -9.28% 3.11% 2.90% 41330 Boards & Commissions 12,369 12,474 105 0.84% 0.10% 0.10% 41410 Elections 5,600 7,167 1,567 27.98% 0.04% 0.06% 41520 Finance(2) 311,021 300,663 (10,358) -3.33% 2.49% 2.48% 41540 Internal Auditing 27,200 28,200 1,000 3.68% 0.22% 0.23% 41500 Assessing 105,200 108,200 3,000 2.85% 0.84% 0.89% 41610 Legal(3) 385,000 385,000 0 0.00% 3.09% 3.18% 41820 Personnel 135,314 131,792 (3,522) -2.60% 1.08% 1.09% 41830 Communications 119,113 107,466 (11,647) -9.78% 0.95% 0.89% 41910 Community Dev/Natural Resources 261,924 250,130 (11,794) -4.50% 2.10% 2.06% 41920 Technology(4) 160,815 146,597 (14,218) -8.84% 1.29% 1.21% 41940 Buildings & Plant 443,752 439,126 (4,626) -1.04% 3.56% 3.62% 42100 Police 3,117,749 3,073,415 (44,334) -1.42% 24.99% 25.36% 42200 Fire 780,878 861,411 80,533 10.31% 6.26% 7.11% 42400 Building Inspection(5) 360,328 364,111 3,783 1.05% 2.89% 3.00% 42500 Emergency Management 7,500 7,500 0 0.00% 0.06% 0.06% 42700 Animal Control 34,890 35,844 954 2.73% 0.28% 0.30% 43050 Engineering 493,165 375,400 (117,765) -23.88% 3.95% 3.10% 43100 Street 1,012,526 1,032,659 20,133 1.99% 8.12% 8.52% 43400 Central Garage 317,264 329,994 12,730 4.01% 2.54% 2.72% 45100 Recreation 437,498 403,754 (33,744) -7.71% 3.51% 3.33% 45200 Parks 1,384,317 1,310,084 (74,233) -5.36% 11.09% 10.81% . 45500 Libraries 106,067 91 ;067 (15,000) -14.14% 0.85% 0.75% 46500 Economic Development 62,583 44,401 (18,182) -29.05% 0.50% 0.37% 47000 Debt Service 1,625,734 1,680,600 54,866 3.37% 13.03% 13.87% 49999 Contingency 300,000 69,000 (231,000) -77.00% 2.40% 0.57% 49303 Transfers 100.000 100,000 0.00% 0.00% 0.83% Total General Fund 12,476.974 12.120.546 (356,428) -2.86% 100.00% 99.17% (1) 41320 formerly called City Manager (2) 41520 formerly called Director of Finance; 41520 and 41530 Accounting combined into 41520 Finance (3) 41610 formerly called City Attorney (4) 41920 formerly called Data Processing (5) 42400 formerly called Building & Transportation Services Water & Sewer Fund 41520 Finance 123,870 123,870 0.00% 0.00% 2.23% 49003 Lift Station Upgrade 165,000 (165,000) -100.00% 3.18% 0.00% 49005 CIPP Pipe Slip Lining 130,000 150,000 20,000 15.38% 2.50% 2.70% 49400 Water 1,761,003 1,994,293 233,290 13.25% 33.92% 35.94% 49450 Sewer 2,091,489 2,226,598 135,109 6.46% 40.29% 40.12% 49303 Transfers 1,044.214 1.054.796 10,582 1.01% 20.11 % Total Water & Sewer Fund 5.191.706 5.549.557 357.851 6.89% 100.00% 100.00% Water Quality Fund I 49420 Water Quality 421,806 443,367 21,561 5.11% 100.00% 100.00% 1 Total Water Quality Fund 421.806 443.367 21.561 5.11% 100.00% 100.00%J Transit Fund ., 49804 Transit Services 810,120 1,144,662 334,542 41.30% 100.00% 100.00% Total Water Transit Fund 810.120 1,144.662 334,542 41.30% 100.00% 100.00%) GRAND TOTAL 18,900,606 19,258,132 357,526 1.89% 11/13/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Revenue Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of %of %of %of Budget Proposed 09 -10 09 -10 Subtotal Subtotal Total Total General Fund Property taxes 31010 Current taxes 7,910,537 7,952,993 42,456 0.54% 94.12% 93.75% 31012 Market value credit aid (226,000) (227,546) (1,546) 0.68% -2.69% -2.68% 31020 Delinquent taxes 0 0.00% 0.00% 0.00% 31040 Fiscal disparities 720.025 757.409 37.384 5.19% 8.57% 8.93% 8.404,562 8.482.856 78.294 0.93% 100.00% 100.00% 67.36% 69.99% Licenses & permits 32100 Business licenses 800 1,300 500 62.50% 0.18% 0.48% 32110 Liquor licenses 57,680 57,000 (680) -1.18% 12.70% 21.11% 32160 Refuse haulers 4,200. 3,875 (325) -7.74% 0.92% 1.44% 32161 Plumbing registrations 1,250 875 (375) -30.00% 0.28% 0.32% 32170 Outdoor concert permits 1,250 1,100 (150) -12.00% 0.28% 0.41% 32180 Cigarette licenses 3,250 3,250 0.00% 0.72% 1.20% 32210 Building permits 330,000 166,750 (163,250) -49.47% 72.66% 61.76% 32215 Mechanical permits 24,850 14,900 (9,950) -40.04% 5.47% 5.52% 32230 Plumbing permits 19,900 12,425 (7,475) -37.56% 4.38% 4.60% 32231 Sewer/water inspection 5,000 2,500 (2,500) -50.00% 1.10% 0.93% 32240 Animal licenses 3,750 3,750 0.00% 0.83% 1.39% 32260 Burning permits 2.250 2.250 0.00% 0.50% 0.83% 454.180 269,975 (184.205) -40.56% 100.00% 100.00% 3.64% 2.23% Intergovernmental revenue 33401 Local government aid 11,905 11,905 0.00% 0.89% 0.90% 33416 State aid - police training 8,855 8,855 0.00% 0.66% 0.67% 33418 State road & bridge aid 238,000 230,000 (8,000) -3.36% 17.73% 17.32% 33420 State fire aid - ins premium 166,000 123,000 (43,000) -25.90% 12.36% 9.26% 33421 State police aid - ins premium 172,500 155,000 (17,500) -10.14% 12.85% 11.67% .3610 County/city aids & grants 1 0,455 13,800 3,345 31.99% 0.78% 1.04% 3620 Township fire & rescue aid 322,016 348,065 26,049 8.09% 23.98% 26.22% 33621 Liaison aid 52,948 54,042 1,094 2.07% 3.94% 4.07% 33631 Payment in lieu of taxes 360,000 380,000 20,000 5.56% 26.81 % 28.62% 33700 Miscellaneous grants 3.000 3.000 0.00% 0.00% 0.23% 1.342,679 1.327.667 (15,012) -1.12% 100.00% 100.00% 10.76% 10.95% Charges for services 34103 Zoning & subdivision fees 13,075 7,810 (5,265) -40.27% 0.85% 0.57% 34104 Plan check fees 220,750 83,250 (137,500) -62.29% 14.40% 6.02% 34105 Sale of maps/publications 500 2,500 2,000 400.00% 0.03% 0.18% 34107 Assessment searches 400 400 0.00% 0.03% 0.03% 34109 Project admin/eng fees 314,900 348,553 33,653 10.69% 20.55% 25.22% 34203 Accident/warrant reports 300 300 0.00% 0.02% 0.02% 34303 Franchise fees 536,944 537,000 56 0.01% 35.04% 38.85% 34304 PEG access fees 35,256 36,000 744 2.11% 2.30% 2.60% 34731 Softball fees 28,000 28,000 0.00% 1.83% 2.03% 34735 Recreation program fees 66,000 56,000 (10,000) -15.15% 4.31% 4.05% 34740 Beach concessions 13,000 13,000 0.00% 0.85% 0.94% 34760 Facility rental 86,526 68,166 (18,360) -21.22% 5.65% 4.93% 34761 Studio/pavilion rental 18,000 15,000 (3,000) -16.67% 1.17% 1.09% 34762 Park shelter rental 7,000 7,000 0.00% 0.46% 0.51% 34765 Tower leases 150,152 150,152 0.00% 9.80% 10.86% 34780 Park admission fees 28,000 29,000 1,000 3.57% 1.83% 2.10% 34782 Sign lease fees 13.750 (13.750) -100.00% 0.90% 0.00% 1.532.553 1.382.131 (150.422) -9.82% 100.00% 100.00% 12.28% 11.40% Fines & forfeitures 35101 County court fines 150,000 115,000 (35,000) -23.33% 67.57% 63.19% 35104 Prosecution restitution 72.000 67.000 {5.000) -6.94% 32.43% 36.81% 222.000 182.000 (40.000) -18.02% 100.00% 100.00% 1.78% 1.50% . Page 1 0'2 11/16/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Revenue Details 2009 2010 2009 2010 . 2009 2010 $ Change % Change %of %of %of %of Budget Proposed 09 -10 09 - 10 Subtotal Subtotal Total Total Miscellaneous revenues 36210 Interest earnings 120,000 90,000 (30,000) -25.00% 63.16% 62.07% 36211 Developer agreements 25,000 (25,000) -100.00% 13.16% 0.00% 36212 Miscellaneous revenue 30,000 30,000 0.00% 15.79% 20.69% 36230 Contributions & donations 15.000 25.000 10.000 66.67% 7.89% 17.24% 190.000 145.000 145.000) -23.68% 100.00% 100.00% 1.52% 1.20% Other financing sources 39102 Sale of property 6,000 5,917 (83) -1.38% 1.81% 1.79% 39203 Transfers from other funds 325.000 325.000 0.00% 98.19% 98.21% 331,000 330,917 (83) -0.03% 100.00% 100.00% 2.65% 2.73% GENERAL FUND TOTAL 12,476,974 12,120,546 (356,428) -2.86% 100.00% 100.00% 100.00% 100.00% WATER & SEWER FUND Charges for services 37100 Water utility revenue 2,138,750 2,138,750 0.00% 46.09% 46.30% 37102 Sewer utility revenue 1,916,250 1,916,250.00 0.00% 41.30% 41.48% 37110 Capital facility revenue 450,000 450,000.00 0.00% 9.70% 9.74% 37150 Disconnect charges 7,650 9,000.00 1,350 17.65% 0.16% 0.19% 37160 Penalties 70,963 70,963.00 0.00% 1.53% 1.54% 37170 Water meters 43,625 26,000.00 (17,625) -40.40% 0.94% 0.56% 37175 Pressure reducers 12.975 8,225.00 14.750) -36.61% 0.28% 0.18% 4.640.213 4.619.188 (21,025) -0.45% 100.00% 100.00% 95.08% 97.88% Miscellaneous revenues 36210 Interest earnings 240,000 100.000 (140.000) -58.33% 100.00% 100.00% 240.000 100.000 1140.000) -58.33% 100.00% 100.00% 4.92% 2.12% WATER & SEWER FUND TOTAL 4,880,213 4,719,188 (161,025) -3.30% 100.00% 100.00% 100.00% 100.00% . WATER QUALITY FUND Charges for services 37120 Storm water revenue 425,000 425.000 0.00% 100.00% 100.00% 425,000 425,000 0.00% 100.00% 100.00% 100.00% 100.00% WATER QUALITY FUND TOTAL 425,000 425,000 0.00% 100.00% 100.00% 100.00% 100.00% TRANSIT FUND Intergovernmental revenue 38422 State transit aid 718.058 444.661 (273,397) -38.07% 100.00% 100.00% 718,058 444.661 1273,397) -38.07% 100.00% 100.00% 86.51 % 83.17% Charges for services 38400 Bus fares 112.000 90.000 (22.000) -19.64% 100.00% 100.00% 112.000 90.000 122.000) -19.64% 100.00% 100.00% 13.49% 16.83% TRANSIT FUND TOTAL 830,058 534,661 (295,397) -35.59% 100.00% 100.00% 100.00% 100.00% GRAND TOTAL. ALL BUDGETED FUNDS 18,612,245 17,799,395 (812,850) -4.37% . Page 2 of 2 11/16/2009 BUDGET WORKSHOP 11/16/2009 City of Prior Lake 2010 Proposed Budget Budgeted Funds Total General Water & Sewer Water Quality Transit Enterprise Budgeted Fund Fund Fund Fund Funds Funds Revenues / Sources Property Taxes Levy - Tax Capacity $ 7,625,503 $ $ $ $ $ 7,625,503 Levy - Market Value 1,084,899 1,084,899 MVHC Aid (227,546) (227,546) Licenses & Permits 269,975 269,975 Fines & Forfeits 182,000 182,000 Intergovernmental 1,327,667 444,661 444,661 1,772,328 Charges for Services 1,382,131 4,619,188 425,000 90,000 5,134,188 6,516,319 Other Revenues 150,917 100,000 100,000 250,917 Transfers 325,000 325,000 Total Revenues / Sources $12.120.546 $ 4.719,188 $ 425,000 $ 534,661 $ 5,678,849 $17,799.395 Expenditures / Uses Employee Services $ 6,531,013 $ 1,186,060 $ 148,942 $ 91,206 $ 1,426,208 $ 7,957,221 Current Expenditures 3,431,033 2,519,701 69,425 772,820 3,361,946 6,792,979 Capital Outlay 308,900 24,000 24,000 332,900 Capital Improvements 765,000 225,000 280,636 1,270,636 1,270,636 Subtotal $ 10,270,946 $ 4,494,761 $ 443,367 $ 1,144,662 $ 6,082,790 $16,353,736 Transfers to other funds General Fund $ $ 325,000 $ $ $ 325,000 $ 325,000 Maintenance Building 181,807 181,807 181,807 Treatment Plant 457,989 457,989 457,989 Equipment Fund 90,000 90,000 90,000 Park Equipment Fund 100,000 100,000 Debt Funds 1,680,600 1,680,600 Contingency 69,000 69,000 Subtotal $ 1,849,600 $ 1,054,796 $ $ $ 1,054,796 $ 2,904,396 Total Expenditures / Uses $ 12,120.546 $ 5.549.557 $ 443,367 $ 1,144.662 $ 7.137,586 $19.258.132 Change in Fund Balance. $ $ (830,369) $ (18,367) $ (610,001) $ (1,458,737) $ (1,458,737) 2010 Proposed Property Tax Levy Change 09 - 10 Property Taxes 2009 2010 Amount Percent Levy - Tax Capacity Budgeted Funds: General Fund - Operating $ 7,004,828 $ 7,020,503 $ 15,675 0.22% General Fund - Debt $ 586,120 $ 605,000 $ 18,880 3.22% Non-Budgeted Funds: Debt Service Funds 1,000,993 1,108,784 107,791 10.77% Equipment Fund 250,000 260,000 10,000 4.00% $ 8,841,941 $ 8,994,287 $ 152,346 1.72% Levy - Market Value - General Fund 1,039.614 1,084,899 45.285 4.36% Total Levy $ 9.881.555 $ 10,079.186 $ 197.631 2.00% 2010 Proposed Budget Comparisons Total General Water & Sewer Water Quality Transit Enterprise Budgeted Fund Fund Fund Fund Funds Funds 2010 Total Expenditures / Uses 12,120,546 5,549,557 443,367 1,144,662 7,137,586 19,258,132 2009 Total Expenditures / Uses 12.476.974 5,191,706 421,806 810,120 6.423.632 18,900,606 Change 2009 to 2010 ($) (356,428) 357,851 21,561 334,542 713,954 357,526 ChanQe 2009 to 2010 (%) -2.86% 6.89% 5.11% 41.30% 11.11% 1.89% 11/13/2009 ------ BUDGETWORKSHOP1V1~2009 City of Prior Lake 2010 Proposed Budget Non-Budgeted Funds Debt Revolving Maintenance Treatment Park Equip Service Equipment Building Plant Fund Non-Budgeted Budgeted Total Funds Fund Fund Fund (NEW) Funds Funds Funds Revenues I Sources Property Taxes Levy - Tax Capacity 1,108,784 260,000 1,368,784 7,625,503 8,994,287 Levy - Market Value Referendum 1,084,899 1,084,899 MVHC Aid (227,546) (227,546) Licenses & Permits 269,975 269,975 Fines & Forfeits 182,000 182,000 Intergovernmental 1,772,328 1,772.328 Charges for Services 6,516,319 6,516,319 Other Revenues 250,917 250,917 Transfers 1,680,600 90,000 181,807 457,989 100,000 2,510,396 325,000 2,835,396 Total Revenues I Sources 2.789.384 350.000 181,807 457,989 100,000 3,879,180 17,799.395 21,678,575 Expenditures I Uses Employee Services 7,957,221 7,957,221 Current Expenditures 6,792,979 6,792,979 Capital Outlay 332,900 332,900 Capital Improvements 1,270,636 1,270,636 Subtotal 16,353,736 16,353,736 Transfers to other funds General Fund 325,000 325,000 Maintenance Building 181,807 181,807 Treatment Plant 457,989 457,989 Equipment Fund 90,000 90,000 Park Equipment Fund 100,000 100,000 Debt Funds 1,680,600 1,680,600 Contingency 69,000 69.000 Subtotal 2,904,396 2,904,396 Total Expenditures I Uses 19,258.132 19,258,132 Change in Fund Balance 2,789,384 350,000 181,807 457.989 100,000 3.879,180 (1.458,737) 2.420,443 11/1312009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Revenue Summary 2009 2010 2009 2010 $ Change % Change %of %of General Fund Adopted Proposed 09 -10 09 -10 Total Total Taxes 8,404,562 8,482,856 78,294 0.93% 67.36% 69.99% Licenses and permits 454,180 269,975 (184,205) -40.56% 3.64% 2.23% Intergovernmental 1,342,679 1,327,667 (15,012) -1.12% 10.76% 10.95% Charges for services 1,532,553 1,382,131 (150,422) -9.82% 12.28% 11.40% Fines and forfeitures 222,000 182,000 (40,000) -18.02% 1.78% 1.50% Interest on investments 120,000 90,000 (30,000) -25.00% 0.96% 0.74% Other 76,000 60,917 (15,083) 0.00% 0.61% 0.50% Transfers from other funds 325,000 325,000 0 0.00% 2.60% 2.68% Total General Fund 12.476,974 12,120,546 (356.428) -2.86% 100.00% 100.00% Water & Sewer Fund Charges for services - water 2,723,963 2,702,938 (21,026) 0.00% 55.82% 57.28% Charges for services - sewer 1,916,250 1,916,250 0.00% 39.27% 40.61 % Interest on investments 240,000 100,000 (140,000) -58.33% 4.92% 2.12% Total Water & Sewer Fund 4,880,213 4,719,188 (161,026) -3.30% 100.00% 100.00% Water Quality Fund Charges for services - storm water 425,000 425,000 0.00% 100.00% 100.00% Total Water Qualitv Fund 425,000 425.000 0 0.00% 100.00% 100.00% Transit Fund I Charges for services - transit revenue 830,058 534,661 (295,397) -35.59% 100.00% 100.00% . , Total Transit Fund 830,058 534,661 295,397) -35.59% 100.00% 100.00% GRAND TOTAL 18,612,245 17,799,395 (812,851) -4.37% 11/1312009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Fund/Department Expense Summary 2009 2010 2009 2010 $ Change % Change % of % of General Fund Adopted Proposed 09 - 10 09 - 10 Total Total 41110 Mayor & Council 70,131 65,453 (4,678) -6.67% 0.56% 0.54% 41130 Ordinance 11,000 7,000 (4,000) -36.36% 0.09% 0.06% 41320 Administration(1) 388,036 352,039 (35,997) -9.28% 3.11% 2.90% 41330 Boards & Commissions 12,369 12,474 105 0.84% 0.10% 0.10% 41410 Elections 5,600 7,167 1,567 27.98% 0.04% 0.06% 41520 Finance(2) 311,021 300,663 (10,358) -3.33% 2.49% 2.48% 41540 Internal Auditing 27,200 28,200 1,000 3.68% 0.22% 0.23% 41500 Assessing 105,200 108,200 3,000 2.85% 0.84% 0.89% 41610 Legal(3) 385,000 385,000 0 0.00% 3.09% 3.18% 41820 Personnel 135,314 131,792 (3,522) -2.60% 1.08% 1.09% 41830 Communications 119,113 107,466 (11,647) -9.78% 0.95% 0.89% 41910 Community Dev/Natural Resources 261,924 250,130 (11,794) -4.50% 2.10% 2.06% 41920 Technology(4) 160,815 146,597 (14,218) -8.84% 1.29% 1.21% 41940 Buildings & Plant 443,752 439,126 (4,626) -1.04% 3.56% 3.62% 42100 Police 3,117,749 3,073,415 (44,334) -1.42% 24.99% 25.36% 42200 Fire 780,878 861,411 80,533 10.31% 6.26% 7.11% 42400 Building Inspection(5) 360.328 364,111 3,783 1.05% 2.89% 3.00% 42500 Emergency Management 7,500 7,500 0 0.00% 0.06% 0.06% 42700 Animal Control 34,890 35,844 954 2.73% 0.28% 0.30% 43050 Engineering 493,165 375,400 (117,765) -23.88% 3.95% 3.10% 43100 Street 1,012,526 1,032,659 20,133 1.99% 8.12% 8.52% 43400 Central Garage 317,264 329,994 12,730 . 4.01% 2.54% 2.72% 45100 Recreation 437,498 403,754 (33,744) -7.71% 3.51% 3.33% 45200 Parks 1,384,317 1,310,084 (74,233) -5.36% 11.09% 10.81% 45500 Libraries 106,067 91,067 (15,000) -14.14% 0.85% 0.75% 46500 Economic Development 62,583 44,401 (18,182) -29.05% 0.50% 0.37% 47000 Debt Service 1,625,734 1,680,600 54,866 3.37% 13.03% 13.87% 49999 Contingency 300,000 69,000 (231,000) -77.00% 2.40% 0.57% 49303 Transfers 100,000 100.000 0.00% 0.00% 0.83% Total General Fund 12.476,974 1~ 120.546 (356,428) -2.86% 100.00% 100.00% (1) 41320 formerly called City Manager (2) 41520 formerly called Director of Finance; 41520 and 41530 Accounting combined into 41520 Finance (3) 41610 formerly called City Attorney (4) 41920 formerly called Data Processing (5) 42400 formerly called Building & Transportation Services Water & Sewer Fund 41520 Finance 123,870 123,870 0.00% 0.00% 2.230/; 49003 Lift Station Upgrade 165,000 (165,000) -100.00% 3.18% 0.00% 49005 CIPP Pipe Slip Lining 130,000 150,000 20,000 15.38% 2.50% 2.70% 49400 Water 1,761,003 1,994,293 233,290 13.25% 33.92% 35.94% 49450 Sewer 2,091,489 2,226,598 135,109 6.46% 40.29% 40.12% 49303 Transfers 1,044.214 1,054.796 10.582 1.01% 20.11 % 19.01 % Total Water & Sewer Fund 5,191.706 5.549,557 357,851 6.89% 100.00% 100.00% Water Quality Fund I 49420 Water Quality 421,806 443,367 21,561 5.11% 100.00% 100.00% 1 Total Water Qualitv Fund 421,806 443.367 21,561 5.11% 100.00% 100.00% Transit Fund 49804 Transit Services 810,120 1,144,662 334,542 41 .30% 100.00% 100.00%1 Total Water Transit Fund 810,120 1,144,662 334.542 41.30% 100.00% 100.00%1 GRAND TOTAL 18,900,606 19,258,132 357,526 1.89% 11/16/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Revenue Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of %of %of %of Budget Proposed 09 -10 09 - 10 Subtotal Subtotal Total Total General Fund Property taxes 31010 Current taxes 7,910,537 7,952,993 42,456 0.54% 94.12% 93.75% 31012 Market value credit aid (226,000) (227,546) (1,546) 0.68% -2.69% -2.68% 31020 Delinquent taxes 0 0.00% 0.00% 0.00% 31040 Fiscal disparities 720.025 757.409 37.384 5.19% 8.57% 8.93% 8.404.562 8.482.856 78.294 0.93% 100.00% 100.00% 67.36% 69.99% Licenses & permits 32100 Business licenses 800 1,300 500 62.50% 0.18% 0.48% 32110 Liquor licenses 57,680 57,000 (680) -1.18% 12.70% 21.11% 32160 Refuse haulers 4,200. 3,875 (325) -7.74% 0.92% 1.44% 32161 Plumbing registrations 1,250 875 (375) -30.00% 0.28% 0.32% 32170 Outdoor concert permits 1,250 1,100 (150) -12.00% 0.28% 0.41% 32180 Cigarette licenses 3,250 3,250 0.00% 0.72% 1.20% 32210 Building permits 330,000 166,750 (163,250) -49.47% 72.66% 61.76% 32215 Mechanical permits 24,850 14,900 (9,950) -40.04% 5.47% 5.52% 32230 Plumbing permits 19,900 12,425 (7,475) -37.56% 4.38% 4.60% 32231 Sewer/water inspection 5,000 2,500 (2,500) -50.00% 1.10% 0.93% 32240 Animal licenses 3,750 3,750 0.00% 0.83% 1.39% 32260 Burning permits 2.250 2,250 0.00% 0.50% 0.83% 454.180 269.975 (184.205) -40.56% 100.00% 100.00% 3.64% 2.23% Intergovernmental revenue 33401 Local government aid 11,905 11,905 0.00% 0.89% 0.90% 33416 State aid - police training 8,855 8,855 0.00% 0.66% 0.67% 33418 State road & bridge aid 238,000 230,000 (8,000) -3.36% 17.73% 17.32% 33420 State fire aid - ins premium 166,000 123,000 (43,000) -25.90% 12.36% 9.26% 33421 State police aid - ins premium 172,500 155,000 (17,500) -10.14% 12.85% 11.67% 33610 County/city aids & grants 10,455 13,800 3,345 31.99% 0.78% 1.04% 33620 Township fire & rescue aid 322,016 348,065 26,049 8.09% 23.98% 26.22% 33621 Liaison aid 52,948 54,042 1,094 2.07% 3.94% 4.07% 33631 Payment in lieu of taxes 360,000 380,000 20,000 5.56% 26.81% 28.62% 33700 Miscellaneous grants 3,000 3.000 0.00% 0.00% 0.23% 1,342.679 1,327.667 (15.012) -1.12% 100.00% 100.00% 10.76% 10.95% Charges for services 34103 Zoning & subdivision fees 13,075 7,810 (5,265) -40.27% 0.85% 0.57% 34104 Plan check fees 220,750 83,250 (137,500) -62.29% 14.40% 6.02% 34105 Sale of maps/publications 500 2,500 2,000 400.00% 0.03% 0.18% 34107 Assessment searches 400 400 0.00% 0.03% 0.03% 34109 Project admin/eng fees 314,900 348,553 33,653 10.69% 20.55% 25.22% 34203 Accident/warrant reports 300 300 0.00% 0.02% 0.02% 34303 Franchise fees 536,944 537,000 56 0.01% 35.04% 38.85% 34304 PEG access fees 35,256 36,000 744 2.11% 2.30% 2.60% 34731 Softball fees 28,000 28,000 0.00% 1.83% 2.03% 34735 Recreation program fees 66,000 56,000 (10,000) -15.15% 4.31% 4.05% 34740 Beach concessions 13,000 13,000 0.00% 0.85% 0.94% 34760 Facility rental 86,526 68,166 (18,360) -21.22% 5.65% 4.93% 34761 Studio/pavilion rental 18,000 15,000 (3,000) -16.67% 1.17% 1.09% 34762 Park shelter rental 7,000 7,000 0.00% 0.46% 0.51% 34765 Tower leases 150,152 150,152 0.00% 9.80% 10.86% 34780 Park admission fees 28,000 29,000 1,000 3.57% 1.83% 2.10% 34782 Sign lease fees 13.750 (13.750) -100.00% 0.90% 0.00% 1,532,553 1.382,131 (150.422) -9.82% 100.00% 100.00% 12.28% 11.40% Fines & forfeitures 35101 County court fines 150,000 115,000 (35,000) -23.33% 67.57% 63.19% 35104 Prosecution restitution 72.000 67.000 (5,000) -6.94% 32.43% 36.81 % 222.000 182.000 (40.000) -18.02% 100.00% 100.00% 1.78% 1.50% Page 1 0'2 11/16/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Revenue Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of %of %of %of Budget Proposed 09.10 09 -10 Subtotal Subtotal Total Total Miscellaneous revenues 36210 Interest earnings 120,000 90,000 (30,000) -25.00% 63.16% 62.07% 36211 Developer agreements 25,000 (25,000) -100.00% 13.16% 0.00% 36212 Miscellaneous revenue 30,000 30,000 0.00% 15.79% 20.69% 36230 Contributions & donations 15,000 25.000 10,000 66.67% 7.89% 17.24% 190.000 145.000 (45.000) -23.68% 100.00% 100.00% 1.52% 1.20% Other financing sources 39102 Sale of property 6,000 5,917 (83) -1.38% 1.81% 1.79% 39203 Transfers from other funds 325.000 325.000 0.00% 98.19% 98.21% 331.000 330.917 (83) -0.03% 100.00% 100.00% 2.65% 2.73% GENERAL FUND TOTAL 12,476,974 12,120,546 (356,428) -2.86% 100.00% 100.00% 100.00% 100.00% WATER & SEWER FUND Charges for services 37100 Water utility revenue 2,138,750 2,138,750 0.00% 46.09% 46.30% 37102 Sewer utility revenue 1,916,250 1,916,250.00 0.00% 41.30% 41.48% 37110 Capital facility revenue 450,000 450,000.00 0.00% 9.70% 9.74% 37150 Disconnect charges 7,650 9,000.00 1,350 17.65% 0.16% 0.19% 37160 Penalties 70,963 70,963.00 0.00% 1.53% 1.54% 37170 Water meters 43,625 26,000.00 (17,625) -40.40% 0.94% 0.56% 37175 Pressure reducers 12.975 8.225.00 (4.750) -36.61 % 0.28% 0.18% 4.640,213 4,619,188 (21 ,025) -0.45% 100.00% 100.00% 95.08% 97.88% Miscellaneous revenues 36210 Interest earnings 240.000 100.000 (140.000) -58.33% 100.00% 100.00% 240.000 100.000 (140.000) -58.33% 100.00% 100.00% 4.92% 2.12% WATER & SEWER FUND TOTAL 4,880,213 4,719,188 (161,025) -3.30% 100.00% 100.00% 100.00% 100.00% WATER QUALITY FUND Charges for services 37120 Storm water revenue 425.000 425,000 0.00% 100.00% 100.00% 425.000 425.000 0.00% 100.00% 100.00% 100.00% 100.00% WATER QUALITY FUND TOTAL 425,000 425,000 0.00% 100.00% 100.00% 100.00% 100.00% TRANSIT FUND Intergovernmental revenue 38422 State transit aid 718,058 444.661 (273.397) -38.07% 100.00% 100.00% 718,058 444,661 (273,397) -38.07% 100.00% 100.00% 86.51% 83.17% Charges for services 38400 Bus fares 112.000 90.000 (22.000) -19.64% 100.00% 100.00% 112.000 90.000 (22.000) -19.64% 100.00% 100.00% 13.49% 16.83% TRANSIT FUND TOTAL 830,058 534,661 (295,397) -35.59% 100.00% 100.00% 100.00% 100.00% GRAND TOTAL - ALL BUDGETED FUNDS 18,612,245 17,799,395 (812,850) -4.37% Page 20f2 11/16/2009 City of Prior Lake~ BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Expenditure Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of %of %of %of Budget Proposed 09 -10 09 -10 Subtotal Subtotal Total Total GENERAL FUND General Government 41110 Mayor & Council 111 Council Salaries 51,680 51,680 0 0.00% 73.69% 78.96% 121 PERA Contributions 2,584 2,584 0 0.00% 3.68% 3.95% 122 FICA Contributions 3,204 3,204 0 0.00% 4.57% 4.90% 123 MEDICARE Contributions 749 749 0 0.05% 1.07% 1.14% 131 Health Insurance 64 (64) -100.00% 0.09% 0.00% 151 Workers Comp -Insurance 136 136 0.00% 0.00% 0.21% 201 Office Supplies - General 500 500 0 0.00% 0.71% 0.76% 321 Communications - Telephone 3,500 3,500 0 0.00% 4.99% 5.35% 331 Training & Certification 5,750 1,750 (4,000) -69.57% 8.20% 2.67% 361 Insurance - General Liability 1,100 1,100 0 0.00% 1.57% 1.68% 437 Misc Expense - General 1.000 250 (750) -75.00% 1.43% 0.38% 70.131 65.453 (4,678) -6.67% 100.00% 100.00% 0.56% 0.54% 41130 Ordinance 351 Legal Notice 9,000 5,000 (4,000) -44.44% 81.82% 71.43% 352 Ordinance Publication 2,000 2.000 0 0.00% 18.18% 28.57% 11.000 7.000 (4,000) -36.36% 100.00% 100.00% 0.09% 0.06% 41320 Administration (City Manager) 101 Full Time Employees Regular 176,276 183,063 6,787 3.85% 45.43% 52.00% 103 Part Time Employees Regular 45,904 36.496 (9,408) -20.50% 11.83% 10.37% 112 Longevity 16,209 16,209 0 0.00% 4.18% 4.60% 113 Sick Leave 2,701 2,770 69 2.54% 0.70% 0.79% 121 PERA Contributions 16,115 16,497 382 2.37% 4.15% 4.69% 122 FICA Contributions 13,216 12,995 (221) -1.67% 3.41% 3.69% 123 MEDICARE Contributions 3,656 3,518 (138) -3.77% 0.94% 1.00% 126 Deferred Comp Contribution 4,097 4,097 0 0.00% 1.06% 1.16% 131 Health Insurance 15,600 16,008 408 2.62% 4.02% 4.55% 132 Dental Insurance 960 960 0 0.00% 0.25% 0.27% 133 Life Insurance 1,905 1,906 1 0.03% 0.49% 0.54% 135 HCSP Contributions 600 600 0 0.00% 0.15% 0.17% 151 Workers Comp -Insurance 1,530 1,841 311 20.33% 0.39% 0.52% 201 Office Supplies - General 1,000 1,000 0 0.00% 0.26% 0.28% 202 Office Supplies - Dup & Copy 2,860 2,710 (150) -5.24% 0.74% 0.77% 203 Office Supplies - Printed Forms 365 365 0 0.00% 0.09% 0.10% 314 Professional Services - General 41,780 21,780 (20,000) -47.87% 10.77% 6.19% 321 Communications - Telephone 900 900 0 0.00% 0.23% 0.26% 331 Training & Certification 4,750 1,250 (3,500) -73.68% 1.22% 0.36% 334 Car Allowance 6,600 (6,600) -100.00% 1.70% 0.00% 433 Misc Expense - Dues & Subscr 27,012 25,575 (1,437) -5.32% 6.96% 7.26% 437 Misc Expense - General 1,500 1,500 0 0.00% 0.39% 0.43% 570 Office Equipment & Furnishings 2.500 (2,500) -100.00% 0.64% 0.00% 388.036 352.039 (35.997) -9.28% 100.00% 100.00% 3.11% 2.90% 41330 Boards & Commissions 115 EDNPlanning Commission 11,025 11,025 0 0.00% 89.13% 88.39% 121 PERA Contributions 101 101 0.00% 0.00% 0.81% 122 FICA Contributions 684 684 (0) -0.07% 5.53% 5.48% 123 MEDICARE Contributions 160 160 (0) -0.09% 1.29% 1.28% 151 Workers Comp -Insurance 4 4 0.00% 0.00% 0.03% 331 Training & Certification 500 500 0 0.00% 4.04% 4.01% 12.369 12,474 105 0.84% 100.00% 100.00% 0.10% 0.10% 41410 Elections 116 Election Judge Salaries 2,650 3,787 1,137 42.91 % 47.32% 52.84% 210 Operating Supplies - General 2,800 3,080 280 10.00% 50.00% 42.97% 331 Training & Certification 150 300 150 100.00% 2.68% 4.19% 5,600 7,167 1,567 27.98% 100.00% 100.00% 0.04% 0.06% Page 1 of 14 11/1612009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Expenditure Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of %of %of %of Budget Proposed 09 -10 09 -10 Subtotal Subtotal Total Total 41520 Finance (Director of Finance) 101 Full Time Employees Regular 93,817 214,409 120,592 128.54% 72.74% 71.31% 104 Temporary Employees Regular 5,535 5,535 0.00% 0.00% 1.84% 113 Sick Leave 1,113 1,113 0.00% 0.00% 0.37% 121 PERA Contributions 6,333 15,164 8,831 139.45% 4.91% 5.04% 122 FICA Contributions 6,040 13,705 7,665 126.91 % 4.68% 4.56% 123 MEDICARE Contributions 1,413 3,205 1,792 126.84% 1.10% 1.07% 131 Health Insurance 10,200 21,516 11,316 110.94% 7.91% 7.16% 132 Dental Insurance 480 1,090 610 127.10% 0.37% 0.36% 133 Life Insurance 105 299 194 184.57% 0.08% 0.10% 135 HCSP Contributions 300 600 300 100.00% 0.23% 0.20% 151 Workers Comp -Insurance 750 1,687 937 124.91 % 0.58% 0.56% 201 Office Supplies - General 500 1,150 650 130.00% 0.39% 0.38% 203 Office Supplies - Printed Forms 2,550 3,500 950 37.25% 1.98% 1.16% 240 Small Tools & Equipment 250 250 0 0.00% 0.19% 0.08% 314 Professional Services - General 1,600 1,600 0 0.00% 1.24% 0.53% 316 BankService Charges 12,500 12,500 0.00% 0.00% 4.16% 321 Communications - Telephone 350 350 0.00% 0.00% 0.12% 331 Training & Certification 650 1,250 600 92.31% 0.50% 0.42% 334 Car Allowance 3,600 (3,600) -100.00% 2.79% 0.00% 433 Misc Expense - Dues & Subscr 140 240 100 71.43% 0.11% 0.08% 437 Misc Expense - General 250 1.500 1.250 500.00% 0.19% 0.50% 128.978 300.663 171,685 133.11 % 100.00% 100.00% 1.03% 2.48% 41530 Accounting 101 Full Time Employees Regular 117;894 (117,894) -100.00% 64.76% 0.00% 113 Sick Leave 1,085 (1,085) -100.00% 0.60% 0.00% 121 PERA Contributions 7,958 (7,958) -100.00% 4.37% 0.00% 122 FICA Contributions 7,384 (7,384) -100.00% 4.06% 0.00% 123 MEDICARE Contributions 1,727 (1,727) -100.00% 0.95% 0.00% 131 Health Insurance 15,600 (15,600) -100.00% 8.57% 0.00% 132 Dental Insurance 765 (765) -100.00% 0.42% 0.00% 133 Life Insurance 195 (195) -100.00% 0.11% 0.00% 135 HCSP Contributions 300 (300) -100.00% 0.16% 0.00% 151 Workers Comp - Insurance 815 (815) -100.00% 0.45% 0.00% 201 Office Supplies - General 1,000 (1,000) -100.00% 0.55% 0.00% 203 Office Supplies - Printed Forms 2,095 (2,095) -100.00% 1.15% 0.00% 240 Small Tools & Equipment 250 (250) -100.00% 0.14% 0.00% 316 BankService Charges 18,000 (18,000) -100.00% 9.89% 0.00% 331 Training & Certification 1,650 (1,650) -100.00% 0.91% 0.00% 334 Car Allowance 1,200 (1,200) -100.00% 0.66% 0.00% 433 Misc Expense - Dues & Subscr 290 (290) -100.00% 0.16% 0.00% 437 Misc Expense - General 2,585 (2,585) -100.00% 1.42% 0.00% 438 Petty Cash 1,250 (1.250) -100.00% 0.69% 0.00% 182,043 (182.043) -100.00% 100.00% 0.00% 1.46% 0.00% 41540 Internal Auditing 301 Audit 27,200 28.200 1,000 3.68% 100.00% 100.00% 0.22% 0.23% 41550 Assessing 310 Property Assessing 102,000 105,000 3,000 2.94% 96.96% 97.04% 314 Professional Services - General 3.200 3.200 0 0.00% 3.04% 2.96% 105,200 108,200 3.000 2.85% 100.00% 100.00% 0.84% 0.89% 41610 Legal (City Attorney) 304 Legal Fees 199,000 199,000 0 0.00% 51.69% 51.69% 305 Prosecution 186.000 186.000 0 0.00% 48.31% 48.31% 385.000 385,000 0 0.00% 100.00% 100.00% 3.09% 3.18% Page 2 of 14 11/16/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Expenditure Details 2009 2010 2009 2010 2009 2010 $ Change % Change 0/0 of %of %of %of Budget Proposed 09 -10 09 -10 Subtotal Subtotal Total Total 41820 Personnel 101 Full Time Employees Regular 78,858 86,025 7,167 9.09% 58.28% 65.27% 113 Sick Leave 1,855 2,000 145 7.80% 1.37% 1.52% 121 PERA Contributions 5,323 6,022 699 13.13% 3.93% 4.57% 122 FICA Contributions 5,112 5,458 346 6.76% 3.78% 4.14% 123 MEDICARE Contributions 1,196 1,276 80 6.72% 0.88% 0.97% 131 Health Insurance 5,400 5,508 108 2.00% 3.99% 4.18% 132 Dental Insurance 285 305 20 7.03% 0.21% 0.23% 133 Life Insurance 90 90 0 0.00% 0.07% 0.07% 135 HCSP Contributions 300 300 0 0.00% 0.22% 0.23% 151 Workers Comp -Insurance 495 659 164 33.03% 0.37% 0.50% 201 Office Supplies - General 500 500 0 0.00% 0.37% 0.38% 203 Office Supplies - Printed Forms 750 (750) -100.00% 0.55% 0.00% 314 Professional Services - General 14,500 12,500 (2,000) -13.79% 10.72% 9.48% 321 Communications - Telephone 350 350 0 0.00% 0.26% 0.27% 331 Training & Certification 800 800 0 0.00% 0.59% 0.61% 334 Car Allowance 3,600 (3,600) -100.00% 2.66% 0.00% 354 Public Information 5,000 5,000 0 0.00% 3.70% 3.79% 433 Misc Expense - Dues & Subscr 900 (900) -100.00% 0.67% 0.00% 437 Misc Expense - General 10.000 5,000 (5.000) -50.00% 7.39% 3.79% 135.314 131,792 (3,522) -2.60% 100.00% 100.00% 1.08% 1.09% 41830 Communications 101 Full Time Employees Regular 58,592 60,601 2,009 3.43% 49.19% 56.39% 103 Part Time Employees Regular 5,344 5,344 0 0.00% 4.49% 4.97% 121 PERA Contributions 3,955 4,242 287 7.26% 3.32% 3.95% 122 FICA Contributions 4,038 4,089 51 1.25% 3.39% 3.80% 123 MEDICARE Contributions 944 956 12 1.29% 0.79% 0.89% 131 Health Insurance 5,400 5,508 108 2.00% 4.53% 5.13% 132 Dental Insurance 285 305 20 7.03% 0.24% 0.28% 133 Life Insurance 105 106 1 0.57% 0.09% 0.10% 135 HCSP Contributions 300 300 0 0.00% 0.25% 0.28% 151 Workers Comp - Insurance 440 505 65 14.78% 0.37% 0.47% 201 Office Supplies - General 500 500 0 0.00% 0.42% 0.47% 203 Office Supplies - Printed Forms 1,000 1,000 0 0.00% 0.84% 0.93% 210 Operating Supplies - General 1,000 1,000 0 0.00% 0.84% 0.93% 314 Professional Services - General 1,000 1,000 0 0.00% 0.84% 0.93% 334 Car Allowance 1,200 (1,200) -100.00% 1.01% 0.00% 354 Public Information 28,000 18,000 (10,000) -35.71% 23.51 % 16.75% 404 Repair & Maint Service - Equipmen 2,000 1,000 (1,000) -50.00% 1.68% 0.93% 433 Misc Expense - Dues & Subscr 510 510 0 0.00% 0.43% 0.47% 437 Misc Expense - General 2,500 2,500 0 0.00% 2.10% 2.33% 580 General Equipment 2,000 f2.OOO) -100.00% 1.68% 0.00% 119,113 107,466 (11,647) -9.78% 100.00% 100.00% 0.95% 0.89% Page 3 of 14 11/16/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Expenditure Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of %of %of %of Budget Proposed 09 - 10 09 - 10 Subtotal Subtotal Total Total 41910 Comm Development/Natural Res 101 Full Time Employees Regular 189,651 187,195 (2,456) -1.30% 72.41% 74.84% 102 Full Time Employees Overtime 1,480 (1 ,480) -100.00% 0.57% 0.00% 121 PERA Contributions 12,901 13,431 530 4.11% 4.93% 5.37% 122 FICA Contributions 12,073 11,606 (467) -3.87% 4.61% 4.64% 123 MEDICARE Contributions 2,824 2,714 (110) -3.88% 1.08% 1.09% 131 Health Insurance 10,800 21,516 10,716 99.22% 4.12% 8.60% 132 Dental Insurance 855 1,090 235 27.49% 0.33% 0.44% 133 Life Insurance 265 281 16 5.96% 0.10% 0.11% 135 HCSP Contributions 300 300 0 0.00% 0.11% 0.12% 151 Workers Comp -Insurance 910 1,152 242 26.65% 0.35% 0.46% 201 Office Supplies - General 1,750 1,750 0 0.00% 0.67% 0.70% 202 Office Supplies - Dup & Copy 500 500 0 0.00% 0.19% 0.20% 203 Office Supplies - Printed Forms 100 100 0 0.00% 0.04% 0.04% 210 Operating Supplies - General 250 250 0 0.00% 0.10% 0.10% 240 Small Tools & Equipment 700 500 (200) -28.57% 0.27% 0.20% 313 Professional Services - Consultant 8,000 (8,000) -100.00% 3.05% 0.00% 314 Professional Services - General 920 920 0 0.00% 0.35% 0.37% 321 Communications - Telephone 205 205 0 0.00% 0.08% 0.08% 331 Training & Certification 1,650 500 (1,150) -69.70% 0.63% 0.20% 334 Car Allowance 3,600 (3,600) -100.00% 1.37% 0.00% 404 Repair & Maint Service - Equipmen 4,240 2,025 (2,215) -52.24% 1.62% 0.81% 413 Rentals - Office Equipment 1,950 2,045 95 4.87% 0.74% 0.82% 417 Community Events 3,500 (3,500) -100.00% 1.34% 0.00% 433 Misc Expense - Dues & Subscr 2,000 1,800 (200) -10.00% 0.76% 0.72% 437 Misc Expense - General 500 250 (250) -50.00% 0.19% 0.10% 261.924 250,130 (11.794) -4.50% 100.00% 100.00% 2.10% 2.06% 41920 Technology (Data Processing) 210 Operating Supplies - General 3,680 2,065 (1,615) -43.89% 2.29% 1.41% 306 Training Expenses 5,000 5,000 0 0.00% 3.11% 3.41% 309 Software Design 13,000 28,200 15,200 116.92% 8.08% 19.24% 313 Professional Services - Consultant 45,800 41,800 (4,000) -8.73% 28.48% 28.51% 321 Communications - Telephone 2,580 2,702 122 4.73% 1.60% 1.84% 407 Software Service Contract 25,180 27,855 2,675 10.62% 15.66% 19.00% 408 Hardware Service Contract 7,175 5,000 (2,175) -30.31% 4.46% 3.41% 580 General Equipment 58.400 33,975 (24.425) -41.82% 36.32% 23.18% 160.815 146,597 (14,218) -8.84% 100.00% 100.00% 1.29% 1.21% 41940 Buildings & Plant 151 Workers Comp -Insurance 223 Repair & Maint Supplies - Bldgs 6,000 6,000 0 0.00% 1.35% 1.37% 321 Communications - Telephone 15,300 15,300 0 0.00% 3.45% 3.48% 322 Communications - Postage 19,350 19,350 0 0.00% 4.36% 4.41% 361 Insurance - Liability 92,425 95,200 2,775 3.00% 20.83% 21.68% 362 Insurance - Property 124,000 128,000 4,000 3.23% 27.94% 29.15% 381 Utilities - Electric 50,000 50,000 0 0.00% 11.27% 11.39% 383 Utilities - Gas 52,000 52,000 0 0.00% 11.72% 11.84% 384 Refuse Disposal 1,327 1,327 0 0.00% 0.30% 0.30% 401 Repair & Maint Service - Bldgs 28,665 22,824 (5,841 ) -20.38% 6.46% 5.20% 404 Repair & Maint Service - Equipmen 11,600 11 ,205 (395) -3.41 % 2.61% 2.55% 406 Repair & Maint Service - Clean 22,555 22,555 0 0.00% 5.08% 5.14% 413 Rentals - Office Equipment 10,530 5,365 (5,165) -49.05% 2.37% 1.22% 570 Office Equipment & Furnishings 10,000 10,000 0 0.00% 2.25% 2.28% 443.752 439.126 (4,626) -1.04% 100.00% 100.00% 3.56% 3.62% Total General Government 2,436,475 2,341,306 (95,169) -3.91 % 100.00% 100.00% 19.53% 19.32% Page 4 of 14 11/16/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Expenditure Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of %of %of %of Budget Proposed 09 - 10 09 -10 Subtotal Subtotal Total Total Public Safety 42100 Police 101 Full Time Employees Regular 1,745,364 1,743,132 (2,232) -0.13% 55.98% 56.72% 102 Full Time Employees Overtime 152,629 132,418 (20,211 ) -13.24% 4.90% 4.31% 103 Part Time Employees Regular 92,684 96,462 3,778 4.08% 2.97% 3.14% 106 Training Overtime 9,211 9,211 0 0.00% 0.30% 0.30% 112 Longevity 76,107 84,877 8,770 11.52% 2.44% 2.76% 113 Sick Leave 11,401 13,608 2,207 19.36% 0.37% 0.44% 114 Educational Reimbursement 30,000 15,000 (15,000) -50.00% 0.96% 0.49% 119 Clothing Allowance 17,871 18,690 819 4.58% 0.57% 0.61% 121 PERA Contributions 278,214 274,415 (3,799) -1.37% 8.92% 8.93% 122 FICA Contributions 13,622 13,886 264 1.94% 0.44% 0.45% 123 MEDICARE Contributions 29,224 29,154 (70) -0.24% 0.94% 0.95% 131 Health Insurance 183,600 188,136 4,536 2.47% 5.89% 6.12% 132 Dental Insurance 9,950 10,206 256 2.57% 0.32% 0.33% 133 Life Insurance 2,585 2,632 47 1.80% 0.08% 0.09% 135 HCSP Contributions 5,040 2,970 (2,070) -41.07% 0.16% 0.10% 151 Workers Comp -Insurance 65,700 72,490 6,790 10.34% 2.11% 2.36% 201 Office Supplies - General 7,750 7,750 0 0.00% 0.25% 0.25% 202 Office Supplies - Dup & Copy 1,185 1,000 (185) -15.61% 0.04% 0.03% 203 Office Supplies - Printed Forms 2,000 2,000 0 0.00% 0.06% 0.07% 210 Operating Supplies - General 10,000 7,000 (3,000) -30.00% 0.32% 0.23% 212 Operating Supplies - Fuel 58,400 58,400 0 0.00% 1.87% 1.90% 217 Operating Supplies - Uniforms 6,700 10,950 4,250 63.43% 0.21% 0.36% 221 Repair & Maint Sup - Equipment 2,000 2,000 0 0.00% 0.06% 0.07% 223 Repair & Maint Sup - Bldgs 3,500 1,500 (2,000) -57.14% 0.11% 0.05% 228 Repair & Maint Sup - Vehicles 4,000 4,000 0 0.00% 0.13% 0.13% 240 Small Tools & Equipment 12,000 12,000 0 0.00% 0.38% 0.39% 306 Training Expenses 11,250 10,500 (750) -6.67% 0.36% 0.34% 314 Professional Services - General 25,120 25,120 0 0.00% 0.81% 0.82% 321 Communications - Telephone 9,480 11,000 1,520 16.03% 0.30% 0.36% 324 Communications - Ticketwriter 4,365 5,165 800 18.33% 0.14% 0.17% 325 Communications - State Terminal 1,080 1,080 0 0.00% 0.03% 0.04% 326 Communications - Computer 11,265 11,265 0 0.00% 0.36% 0.37% 331 Training & Certification 2,150 2,150 0 0.00% 0.07% 0.07% 334 Car Allowance 7,800 (7,800) .100.00% 0.25% 0.00% 363 Insurance - Auto 6,405 6,200 (205) -3.20% 0.21% 0.20% 381 Utilities - Electric 34,000 34,000 0 0.00% 1.09% 1.11% 383 Utilities - Gas 28,000 28,000 0 0.00% 0.90% 0.91% 384 Refuse Disposal 1,046 1,500 454 43.40% 0.03% 0.05% 401 Repair & Maint Service - Bldgs 15,786 12,500 (3,286) -20.82% 0.51% 0.41% 404 Repair & Maint Service - Equipmen 6,925 6,039 (886) -12.79% 0.22% 0.20% 406 Repair & Maint Service - Clean 8,140 8,140 0 0.00% 0.26% 0.26% 421 Special Response Team SRT 14,365 12,865 (1,500) -10.44% 0.46% 0.42% 433 Misc Expense - Dues & Subscr 3,440 3,080 (360) -10.47% 0.11% 0.10% 437 Misc Expense - General 4,000 2,000 (2,000) -50.00% 0.13% 0.07% 550 Motor Vehicles 75,790 72,000 (3,790) -5.00% 2.43% 2.34% 580 General Equipment 16,605 6,925 (9,680) -58.30% 0.53% 0.23% 3.117,749 3,073.415 (44.334) -1.42% 100.00% 100.00% 24.99% 25.36% Page 5 of 14 11/16/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Expenditure Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of %of 0/0 of 0/0 of Bud'ilet Proposed 09 -10 09 -10 Subtotal Subtotal Total Total 42200 Fire 101 Full Time Employees Regular 40,800 83,048 42,248 103.55% 5.22% 9.64% 117 Volunteer Compensation 178,880 174,210 (4,670) -2.61 % 22.91 % 20.22% 121 PERA Contributions 5,753 5,813 60 1.05% 0.74% 0.67% 122 FICA Contributions 11,091 15,950 4,859 43.81% 1.42% 1.85% 123 MEDICARE Contributions 3,185 3,730 545 17.12% 0.41% 0.43% 124 Pension Contribution 20,000 98,000 78,000 390.00% 2.56% 11.38% 125 Insurance Premium Contribution 166,000 123,000 (43,000) -25.90% 21.26% 14.28% 131 Health Insurance 10,200 10,500 300 2.94% 1.31% 1.22% 132 Dental Insurance 480 480 0 0.00% 0.06% 0.06% 133 Life Insurance 105 (105) -100.00% 0.01% 0.00% 135 HCSP Contributions 300 75 (225) -75.00% 0.04% 0.01% 151 Workers Comp - Insurance 18,350 18,703 353 1.92% 2.35% 2.17% 201 Office Supplies - General 500 450 (50) -10.00% 0.06% 0.05% 202 Office Supplies - Dup & Copy 185 145 (40) -21.62% 0.02% 0.02% 210 Operating Supplies - General 7,500 6,750 (750) -10.00% 0.96% 0.78% 212 Operating Supplies - Fuel 17,742 15,000 (2,742) -15.45% 2.27% 1.74% 217 Operating Supplies - Uniforms 21,500 21,500 0 0.00% 2.75% 2.50% 218 Operating Supplies - Medical 2,000 1,800 (200) -10.00% 0.26% 0.21% 221 Repair & Maint Sup - Equipment 6,000 5,400 (600) -10.00% 0.77% 0.63% 223 Repair & Maint Sup - Bldgs 10,000 9,000 (1,000) -10.00% 1.28% 1.04% 240 Small Tools & Equipment 6,000 5,400 (600) -10.00% 0.77% 0.63% 306 Training Expenses 20,000 20,000 0 0.00% 2.56% 2.32% 321 Communications - Telephone 7,860 8,860 1,000 12.72% 1.01% 1.03% 331 Training & Certification 4,950 4,950 0 0.00% 0.63% 0.57% 354 Public Information 6,500 5,850 (650) -10.00% 0.83% 0.68% 363 Insurance Auto 18,340 18,340 0 0.00% 2.35% 2.13% 381 Utilities - Electric 30,000 30,000 0 0.00% 3.84% 3.48% 383 Utilities - Gas 30,000 37,800 7,800 26.00% 3.84% 4.39% 384 Refuse Disposal 927 927 0 0.00% 0.12% 0.11% 401 Repair & Maint Service - Bldgs 40,620 40,620 0 0.00% 5.20% 4.72% 404 Repair & Maint Service - Equipmen 11,610 11,610 0 0.00% 1.49% 1.35% 406 Repair & Maint Service - Clean 8,000 8,000 0 0.00% 1.02% 0.93% 433 Misc Expense - Dues & Subscr 1,500 1,500 0 0.00% 0.19% 0.17% 437 Misc Expense - General 9,000 9,000 0 0.00% 1.15% 1.04% 520 Buildings & Structures 50,000 50,000 0 0.00% 6.40% 5.80% 580 General Equipment 15.000 15,000 0 0.00% 1.92% 1.74% 780.878 861,411 80,533 10.31% 100.00% 100.00% 6.26% 7.11% Page 6 of 14 11/16/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Expenditure Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of %of %of %of Budget Proposed 09 -10 09 -10 Subtotal Subtotal Total Total 42400 BuildinglTransportation Services 101 Full Time Employees Regular 253,146 272,997 19,851 7.84% 70.25% 74.98% 102 Full Time Employees Overtime 3,469 (3,469) , ':100.00% 0.96% 0.00% 113 Sick Leave 892 2,067 1,175 131.68% 0.25% 0.57% 121 PERA Contributions 17,322 19,674 2,352 13.58% 4.81% 5.40% 122 FICA Contributions 16,189 17,054 865 5.34% 4.49% 4.68% 123 MEDICARE Contributions 3,786 3,988 202 5.35% 1.05% 1.10% 131 Health Insurance 42,150 33,393 (8,757) -20.78% 11.70% 9.17% 132 Dental Insurance 1,990 1,821 (169) -8.48% 0.55% 0.50% 133 Life Insurance 390 375 (15) -3.77% 0.11% 0.10% 135 HCSP Contributions 375 375 0 0.00% 0.10% 0.10% 151 Workers Comp - Insurance 1,225 1,471 246 20.09% 0.34% 0.40% 201 Office Supplies - General 1,750 1,500 (250) -14.29% 0.49% 0.41% 203 Office Supplies - Printed Forms 2,100 1,000 (1,100) -52.38% 0.58% 0.27% 210 Operating Supplies - General 1 ,400 700 (700) -50.00% 0.39% 0.19% 212 Operating Supplies - Fuel 4,599 4,050 (549) -11.94% 1.28% 1.11% 217 Operating Supplies - Uniforms 200 100 (100) -50.00% 0.06% 0.03% 240 Small Tools & Equipment 750 500 (250) -33.33% 0.21% 0.14% 321 Communications - Telephone 720 720 0 0.00% 0.20% 0.20% 331 Training & Certification 1,050 900 (150) -14.29% 0.29% 0.25% 334 Car Allowance 4,500 (4,500) -100.00% 1.25% 0.00% 363 Insurance - Auto 525 525 0 0.00% 0.15% 0.14% 433 Misc Expense - Dues & Subscr 800 900 100 12.50% 0.22% 0.25% 437 Misc Expense - General 1.000 (1.000) -100.00% 0.28% 0.00% 360.328 364.111 3.783 1.05% 100.00% 100.00% 2.89% 3.00% 42500 Emergency Management 306 Training Expenses 500 500 0 0.00% 6.67% 6.67% 381 Utilities - Electric 1,500 1,500 0 0.00% 20.00% 20.00% 404 Repair & Maint Service - Bldgs 5.500 5.500 0 0.00% 73.33% 73.33% 7,500 7,500 0 0.00% 100.00% 100.00% 0.06% 0.06% 42700 Animal Control 311 Animal Control Contract 34.890 35.844 954 2.73% 100.00% 100.00% 0.28% 0.30% Total Public Safety 4,301.345 4,342,281 40,936 0.95% 100.00% 100.00% 34.47% 35.83% Page 7 of 14 11/16/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Expenditure Details 2009 2010 2009 2010 2009 2010 $ Change % Change % of %of %of %of Budget Proposed 09.10 09 - 10 Subtotal Subtotal Total Total Public Works 43050 Engineering 101 Full Time Employees Regular 308,774 233,996 (74,778) -24.22% 62.61% 62.33% 102 Full Time Employees Overtime 10,449 1,500 (8,949) -85.64% 2.12% 0.40% 103 Part Time Employees - Regular 26,910 27,375 465 1.73% 5.46% 7.29% 104 Temporary Employees - Regular 6,720 (6,720) -100.00% 1.36% 0.00% 113 Sick Leave 3,479 4,610 1,131 32.52% 0.71% 1.23% 121 PERA Contributions 21,548 18,714 (2,834) -13.15% 4.37% 4.99% 122 FICA Contributions 22,314 16,584 (5,730) -25.68% 4.52% 4.42% 123 MEDICARE Contributions 5,221 3,878 (1,343) -25.71% 1.06% 1.03% 131 Health Insurance 30,600 26,250 (4,350) -14.22% 6.20% 6.99% 132 Dental Insurance 1,725 1,353 (372) -21.59% 0.35% 0.36% 133 Life Insurance 385 290 (95) -24.73% 0.08% 0.08% 135 HCSP Contributions 600 450 (150) -25.00% 0.12% 0.12% 151 Workers Comp -Insurance 1,635 1,295 (340) -20.80% 0.33% 0.34% 201 Office Supplies - General 3,250 3,250 0 0.00% 0.66% 0.87% 202 Office Supplies - Dup & Copy 850 850 0 0.00% 0.17% 0.23% 205 Drafting Supplies 1,500 750 (750) -50.00% 0.30% 0.20% 210 Operating Supplies - General 600 2,700 2,100 350.00% 0.12% 0.72% 212 Operating Supplies - Fuel 5,180 3,000 (2,180) -42.08% 1.05% 0.80% 221 Repair & Maint Sup - Equipment 100 (100) -100.00% 0.02% 0.00% 240 Small Tools & Equipment 750 (750) -100.00% 0.15% 0.00% 303 Professional Service - Engineering 17,500 17,500 0 0.00% 3.55% 4.66% 321 Communications - Telephone 2,160 2,160 0 0.00% 0.44% 0.58% 331 Training & Certification 3,300 2,600 (700) -21.21% 0.67% 0.69% 334 Car Allowance 7,200 (7,200) -100.00% 1.46% 0.00% 363 Insurance - Auto 525 525 0 0.00% 0.11% 0.14% 404 Repair & Maint Service - Equipmen 4,240 2,025 (2,215) -52.24% 0.86% 0.54% 407 Software Service Contract 1,200 1,200 0 0.00% 0.24% 0.32% 413 Rentals - Office Equipment 2,450 2,545 95 3.88% 0.50% 0.68% 433 Misc Expense - Dues & Subscr 1,500 (1,500) -100.00% 0.30% 0.00% 437 Misc Expense - General 500 ~500) -100.00% 0.10% 0.00% 493.165 375.400 (117,765) -23.88% 100.00% 100.00% 3.95% 3.10% 43100 Street 101 Full Time Employees Regular 163,887 142,058 (21,829) -13.32% 16.19% 13.76% 102 Full Time Employees Overtime 27,980 23,000 (4,980) -17.80% 2.76% 2.23% 113 Sick Leave 1,172 410 (762) -65.05% 0.12% 0.04% 121 PERA Contributions 12,951 12,038 (913) -7.05% 1.28% 1.17% 122 FICA Contributions 11,896 10,259 (1,637) -13.76% 1.17% 0.99% 123 MEDICARE Contributions 2,782 2,399 (383) -13.76% 0.27% 0.23% 131 Health Insurance 18,900 23,334 4,434 23.46% 1.87% 2.26% 132 Dental Insurance 1,195 1,248 53 4.48% 0.12% 0.12% 133 Life Insurance 285 292 7 2.35% 0.03% 0.03% 151 Workers Comp -Insurance 15,685 13,817 (1,868) -11.91% 1.55% 1.34% 210 Operating Supplies - General 2,750 2,750 0 0.00% 0.27% 0.27% 212 Operating Supplies - Fuel 27,768 58,100 30,332 109.23% 2.74% 5.63% 215 Operating Supplies - Shop Material 4,000 4,000 0 0.00% 0.40% 0.39% 217 Operating Supplies - Uniforms 2,700 2,700 0 0.00% 0.27% 0.26% 219 Operating Supplies - Snow & Ice 57,600 67,340 9,740 16.91% 5.69% 6.52% 223 Repair & Maint Sup - Bldgs 1,100 1,100 0 0.00% 0.11% 0.11% 224 Repair & Maint Sup - General 92,080 100,080 8,000 8.69% 9.09% 9.69% 240 Small Tools & Equipment 4,000 4,000 0 0.00% 0.40% 0.39% 331 Training & Certification 3,700 3,000 (700) -18.92% 0.37% 0.29% 363 Insurance - Auto 3,550 3,550 0 0.00% 0.35% 0.34% 381 Utilities - Electric 1,900 1,900 0 0.00% 0.19% 0.18% 384 Refuse Disposal 900 900 0 0.00% 0.09% 0.09% 386 Street Lighting 190,300 190,500 200 0.11% 18.79% 18.45% 409 Dust Control 6,000 6,000 0 0.00% 0.59% 0.58% 412 Repair & Maint Service - General 342,700 343,000 300 0.09% 33.85% 33.22% 415 Rentals - Heavy Equipment 3,500 12,640 9,140 261.14% 0.35% 1.22% 433 Misc Expense - Dues & Subscr 745 745 0 0.00% 0.07% 0.07% 437 Misc Expense - General 500 500 0 0.00% 0.05% 0.05% Page 8 of 14 11/16/2009 ---- City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Expenditure Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of %of %of %of Budget Proposed 09 -10 09 - 10 Subtotal Subtotal Total Total 580 General Equipment 10.000 1.000 ~.OOO) -90.00% 0.99% 0.10% 1,012,526 1.032.659 20,133 1.99% 100.00% 100.00% 8.12% 8.52% 43400 Central Garage 101 Full Time Employees Regular 105,094 102,159 (2,935) -2.79% 33.13% 30.96% 102 Full Time Employees Overtime 3,026 3,026 0 0.00% 0.95% 0.92% 104 Temporary Employees Regular 9,600 9,600 0 0.00% 3.03% 2.91% 113 Sick Leave 213 213 0.00% 0.00% 0.06% 121 PERA Contributions 7,298 7,710 412 5.65% 2.30% 2.34% 122 FICA Contributions 7,299 7,130 (169) -2.32% 2.30% 2.16% 123 MEDICARE Contributions 1,707 1,667 (40) -2.32% 0.54% 0.51% 131 Health Insurance 20,400 21,000 600 2.94% 6.43% 6.36% 132 Dental Insurance 765 960 195 25.49% 0.24% 0.29% 133 Life Insurance 175 175 0 0.11% .0.06% 0.05% 151 Workers Comp -Insurance 6,100 7,452 1,352 22.16% 1.92% 2.26% 201 Office Supplies - General 500 500 0 0.00% 0.16% 0.15% 203 Office Supplies - Printed Forms 300 300 0 0.00% 0.09% 0.09% 210 Operating Supplies - General 6,000 6,000 0 0.00% 1.89% 1.82% 215 Operating Supplies - Shop Material 4,000 4,000 0 0.00% 1.26% 1.21% 217 Operating Supplies - Uniforms 1,500 1,500 0 0.00% 0.47% 0.45% 240 Small Tools & Equipment 5,500 6,500 1,000 18.18% 1.73% 1.97% 331 Training & Certification 4,000 4,000 0 0.00% 1.26% 1.21% 384 Refuse Disposal 500 500 0 0.00% 0.16% 0.15% 412 Repair & Maint Service - General 1,600 1,600 0 0.00% 0.50% 0.48% 433 Misc Expense - Dues & Subscr 2,900 2,900 0 0.00% 0.91% 0.88% 437 Misc Expense - General 900 900 0 0.00% 0.28% 0.27% 451 Repair Sup - Parts (P/S) 9,100 11,000 1,900 20.88% 2.87% 3.33% 452 Repair Sup - Parts (P/K) 8,000 9,500 1,500 18.75% 2.52% 2.88% 453 Repair Sup - Parts (PIW) 8,000 11,500 3,500 43.75% 2.52% 3.48% 454 Repair Sup - Parts (SIW) 2,000 2,000 0 0.00% 0.63% 0.61% 461 Repair Sup - Equip (P/S) 8,300 8,300 0 0.00% 2.62% 2.52% 462 Repair Sup - Equip (P/K) 22,000 22,000 0 0.00% 6.93% 6.67% 463 Repair Sup - Equip (PIW) 27,300 27,300 0 0.00% 8.60% 8.27% 464 Repair Sup - Equip (SIW) 4,500 4,500 0 0.00% 1.42% 1.36% 471 Batteries & Tires (P/S) 9,000 9,000 0 0.00% 2.84% 2.73% 472 Batteries & Tires (P/K) 4,600 8,500 3,900 84.78% 1.45% 2.58% 473 Batteries & Tires (PIW) 6,200 7,500 1,300 20.97% 1.95% 2.27% 474 Batteries & Tires (SIW) 2,000 2,000 0 0.00% 0.63% 0.61% 481 Minor Serv - Contract (P/S) 4,000 4,000 0 0.00% 1.26% 1.21% 482 Minor Serv - Contract (P/K) 1,700 1,700 0 0.00% 0.54% 0.52% 483 Minor Serv - Contract (PIW) 2,200 2,200 0 0.00% 0.69% 0.67% 484 Minor Serv - Contract (SIW) 1,000 1,000 0 0.00% 0.32% 0.30% 491 Major Serv - Contract (P/S) 4,700 4,700 0 0.00% 1.48% 1.42% 492 Major Serv - Contract (P/K) 1,500 1,500 0 0.00% 0.47% 0.45% 493 Major Serv - Contract (PIW) 1,000 1,000 0 0.00% 0.32% 0.30% 494 Major Serv - Contract (SIW) 1.000 1,000 0 0.00% 0.32% 0.30% 317.264 329.994 12,730 4.01% 100.00% 100.00% 2.54% 2.72% Total Public Works 1.822,955 1,738,053 (84.902) -4.66% 100.00% 100.00% 14.61% 14.34% Page 9 of 14 11/16/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Expenditure Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of % of %of %of Budget Proposed 09 -10 09 -10 Subtotal Subtotal Total Total Culture/Recreation 45100 Recreation 101 Full Time Employees Regular 63,229 67,495 4,266 6.75% 14.45% 16.72% 103 Part Time Emlpoyees - Regular 80,690 83,438 2,748 3.41% 18.44% 20.67% 104 Temporary Employees - Regular 97,641 89,697 (7,944) -8.14% 22.32% 22.22% 113 Sick Leave 773 488 (285) -36.86% 0.18% 0.12% 114 Educational Reimbursement 3,800 (3,800) -100.00% 0.87% 0.00% 121 PERA Contributions 9,715 10,565 850 8.75% 2.22% 2.62% 122 FICA Contributions 15,200 14,949 (251) -1.65% 3.47% 3.70% 123 MEDICARE Contributions 3,555 3,496 (59) -1.65% 0.81% 0.87% 131 Health Insurance 10,200 10,500 300 2.94% 2.33% 2.60% 132 Dental Insurance 480 480 0 0.00% 0.11% 0.12% 133 Life Insurance 105 106 1 0.57% 0.02% 0.03% 135 HCSP Contributions 300 300 0 0.00% 0.07% 0.07% 151 Workers Comp -Insurance 8,440 7,604 (836) -9.91 % 1.93% 1.88% 201 Office Supplies - General 1,000 1,000 0 0.00% 0.23% 0.25% 202 Office Supplies - Dup & Copy 250 250 0 0.00% 0.06% 0.06% 203 Office Supplies - Printed Forms 2,500 2,000 (500) -20.00% 0.57% 0.50% 207 Playground 15,000 15,000 0 0.00% 3.43% 3.72% 220 Operating Supplies - Playground 55,000 45,000 (10,000) -18.18% 12.57% 11 .15% 259 Concessions 10,000 10,000 0 0.00% 2.29% 2.48% 308 Instructor's Fees 15,000 15,000 0 0.00% 3.43% 3.72% 321 Communications - Telephone 3,840 2,280 (1,560) -40.63% 0.88% 0.56% 331 Training & Certification 1,100 1,100 0 0.00% 0.25% 0.27% 334 Car Allowance 3,600 (3,600) -100.00% 0.82% 0.00% 401 Repair & Maint Service - Bldgs 5,000 (5,000) -100.00% 1.14% 0.00% 404 Repair & Maint Service - Equipmen 2,275 1,800 (475) -20.88% 0.52% 0.45% 406 Repair & Maint Service - Clean 1,955 1,955 0 0.00% 0.45% 0.48% 417 Community Events 20,500 17,900 (2,600) -12.68% 4.69% 4.43% 433 Misc Expense - Dues & Subscr 350 350 0 0.00% 0.08% 0.09% 437 Misc Expense - General 1,000 1,000 0 0.00% 0.23% 0.25% 570 Office Equipment & Furnishings 5.000 (5.000) -100.00% 1.14% 0.00% 437,498 403,754 (33.744) -7.71% 100.00% 100.00% 3.51% 3.33% 45200 Parks 101 Full Time Employees Regular 460,581 416,688 (43,893) -9.53% 33.27% 31.81% 102 Full Time Employees Overtime 36,499 20,000 (16,499) -45.20% 2.64% 1.53% 103 Part Time Employees - Regular 40,791 41,490 699 1.71% 2.95% 3.17% 104 Temporary Employees - Regular 211,680 175,680 (36,000) -17.01 % 15.29% 13.41% 113 Sick Leave 2,342 1,034 (1,308) -55.86% 0.17% 0.08% 121 PERA Contributions 43,056 34,413 (8,643) -20.07% 3.11% 2.63% 122 FICA Contributions 46,472 40,603 (5,869) -12.63% 3.36% 3.10% 123 MEDICARE Contributions 10,868 9,496 (1,372) -12.62% 0.79% 0.72% 131 Health Insurance 63,000 59,040 (3,960) -6.29% 4.55% 4.51% 132 Dental Insurance 3,345 2,965 (380) -11.35% 0.24% 0.23% 133 Life Insurance 760 706 (54) -7.16% 0.05% 0.05% 135 HCSP Contributions 600 600 0 0.00% 0.04% 0.05% 151 Workers Comp - Insurance 23,585 23,147 (438) -1.86% 1.70% 1.77% 153 Mn Unemployment Insurance 17,500 17,500 0.00% 0.00% 1.34% 201 Office Supplies - General 1,000 1,000 0 0.00% 0.07% 0.08% 210 Operating Supplies - General 47,500 47,500 0 0.00% 3.43% 3.63% 212 Operating Supplies - Fuel 59,316 65,300 5,984 10.09% 4.28% 4.98% 215 Operating Supplies - Shop Material 2,000 2,000 0 0.00% 0.14% 0.15% 217 Operating Supplies - Uniforms 6,330 6,330 0 0.00% 0.46% 0.48% 223 Repair & Maint Sup - Bldgs 5,000 5,000 0 0.00% 0.36% 0.38% 224 Repair & Maint Sup - General 64,500 67,000 2,500 3.88% 4.66% 5.11% 240 Small Tools & Equipment 5,000 5,000 0 0.00% 0.36% 0.38% 313 Professional Services - Consultant 3,000 3,000 0 0.00% 0.22% 0.23% 321 Communications - Telephone 4,200 4,200 0 0.00% 0.30% 0.32% 331 Training & Certification 6,100 6,100 0 0.00% 0.44% 0.47% 343 Sign Advertising 7,850 7,850 0 0.00% 0.57% 0.60% 363 Insurance - Auto 4,545 4,545 0 0.00% 0.33% 0.35% 381 Utilities - Electric 11,000 11,000 0 0.00% 0.79% 0.84% Page 100f14 11/16/2009 ---~- City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Expenditure Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of % of %of % of Budget Proposed 09 -10 09 - 10 Subtotal Subtotal Total Total 383 Utilities - Gas 8,000 8,000 0 0.00% 0.58% 0.61% 384 Refuse Disposal 2,022 2,022 0 0.00% 0.15% 0.15% 387 Park Lighting 38,000 38,000 0 0.00% 2.75% 2.90% 401 Repair & Maint Service - Bldgs 2,000 2,000 0 0.00% 0.14% 0.15% 402 Repair & Maint Service - Trails 10,000 10,000 0 0.00% 0.72% 0.76% 403 Repair & Maint Service - Parks 33,500 33,500 0 0.00% 2.42% 2.56% 415 Rentals - Heavy Equipment 16,675 16,675 0 0.00% 1.20% 1.27% 433 Misc Expense - Dues & Subscr 700 700 0 0.00% 0.05% 0.05% 437 Misc Expense - General 2,500 (2,500) -100.00% 0.18% 0.00% 530 Improvements 100,000 120.000 20,000 20.00% 7.22% 9.16% 1,384,317 1.310,084 (74.233) -5.36% 100.00% 100.00% 11.09% 10.81% 45500 Libraries 223 Repair & Maint Sup - Bldgs 4,000 4,000 0 0.00% 3.77% 4.39% 321 Communications - Telephone 2,220 2,220 0 0.00% 2.09% 2.44% 381 Utilities - Electric 27,000 27,000 0 0.00% 25.46% 29.65% 383 Utilities - Gas 24,000 24,000 0 0.00% 22.63% 26.35% 384 Refuse Disposal 1,327 1,327 0 0.00% 1.25% 1.46% 401 Repair & Maint Service - Bldgs 21,700 21,700 0 0.00% 20.46% 23.83% 406 Repair & Maint Service - Clean 10,820 10,820 0 0.00% 10.20% 11.88% 520 Buildings & Structures 15,000 (15.000) -100.00% 14.14% 0.00% 106.067 91,067 (15.000) -14.14% 100.00% 100.00% 0.85% 0.75% Total Culture/Recreation 1,927,882 1,804,905 (122.977) -6.38% 100.00% 100.00% 15.45% 14.89% Urban & Economic Development 46500 Economic Development 101 Full Time Employees Regular 7,226 (7,226) -100.00% 11.55% 0.00% 121 PERA Contributions 488 (488) -100.00% 0.78% 0.00% 122 FICA Contributions 522 (522) -100.00% 0.83% 0.00% 123 MEDICARE Contributions 122 (122) -100.00% 0.19% 0.00% 132 Dental Insurance 285 (285) -100.00% 0.46% 0.00% 133 Life Insurance 105 (105) -100.00% 0.17% 0.00% 135 HCSP Contributions 300 (300) -100.00% 0.48% 0.00% 151 Workers Comp - Insurance 340 (340) -100.00% 0.54% 0.00% 201 Office Supplies - General 500 (500) -100.00% 0.80% 0.00% 203 Office Supplies - Printed Forms 1,000 1,000 0 0.00% 1.60% 2.25% 313 Professional Services - Consultant 18,654 15,000 (3,654) -19.59% 29.81% 33.78% 314 Professional Services - General 14,325 14,325 0 0.00% 22.89% 32.26% 331 Training & Certification 850 500 (350) -41.18% 1.36% 1.13% 334 Car Allowance 1,200 (1 ,200) -100.00% 1.92% 0.00% 433 Misc Expense - Dues & Subscr 700 1,610 910 130.00% 1.12% 3.63% 437 Misc Expense - General 11,966 11,966 0 0.00% 19.12% 26.95% 520 Buildings & Structures 4.000 (4.000) -100.00% 6.39% 0.00% 62,583 44,401 ( 18.182) -29.05% 100.00% 100.00% 0.50% 0.37% Total Urban/Economic Dev 62,583 44,401 (18.182) -29.05% 100.00% 100.00% 0.50% 0.37% 49303 Transfers to other funds 1,625,734 1,780,600 154.866 9.53% 100.00% 100.00% 13.03% 14.69% 49999 Contingency reserve 300,000 69,000 (231.000) -77.00% 100.00% 100.00% 2.40% 0.57% GENERAL FUND TOTAL 12,476,974 12,120,546 (356,428) -2.86% 100.00% 100.00% 100.00% 1 00.00% Page 11 of 14 11/16/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Expenditure Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of %of %of %of Budget Proposed 09 -10 09 -10 Subtotal Subtotal Total Total WATER & SEWER FUND 41520 Finance 101 Full Time Employees Regular 45,736 45,736 0.00% 0.00% 36.92% 1 03 Part Time Employees - Regular 23,484 23,484 0.00% 0.00% 18.96% 121 PERA Contributions 5,001 5,001 0.00% 0.00% 4.04% 122 FICA Contributions 4,292 4,292 0.00% 0.00% 3.46% 123 MEDICARE Contributions 1,004 1,004 0.00% 0.00% 0.81% 131 Health Insurance 10,500 10,500 0.00% 0.00% 8.48% 132 Dental Insurance 480 480 0.00% 0.00% 0.39% 133 Life Insurance 88 88 0.00% 0.00% 0.07% 151 Workers Comp - Insurance 540 540 0.00% 0.00% 0.44% 203 Office Supplies - Printed Forms 3,020 3,020 0.00% 0.00% 2.44% 316 BankService Charges 7,000 7,000 0.00% 0.00% 5.65% 322 Communications - Postage 15,876 15,876 0.00% 0.00% 12.82% 331 Training & Certification 100 100 0.00% 0.00% 0.08% 407 Software Service Contract 6.750 6.750 0.00% 0.00% 5.45% 123,870 123.870 0.00% 0.00% 100.00% 0.00% 2.23% 49400 Water 101 Full Time Employees Regular 359,253 347,860 (11,393) -3.17% 20.40% 17.44% 102 Full Time Employees Overtime 23,107 23,000 (107) -0.46% 1.31% 1.15% 104 Temporary Employees Regular 34,400 38,820 4,420 12.85% 1.95% 1.95% 113 Sick Leave 1,211 4,175 2,964 244.75% 0.07% 0.21% 121 PERA Contributions 25,809 26,783 974 3.78% 1.47% 1.34% 122 FICA Contributions 25,951 26,388 437 1.68% 1.47% 1.32% 123 MEDICARE Contributions 6,069 6,171 102 1.69% 0.34% 0.31% 131 Health Insurance 44,100 47,895 3,795 8.61% 2.50% 2.40% 132 Dental Insurance 2,350 1,919 (431) -18.35% 0.13% 0.10% 133 Life Insurance 580 557 (23) -3.95% 0.03% 0.03% 135 Health Savings Plan 450 525 75 16.67% 0.03% 0.03% 151 Workers Comp -Insurance 12,530 16,105 3,575 28.53% 0.71% 0.81% 201 Office Supplies 1,000 1,000 0 0.00% 0.06% 0.05% 202 Office Supplies - Dup & Copy 530 530 0 0.00% 0.03% 0.03% 203 Office Supplies - Printed Forms 4,120 6,700 2,580 62.62% 0.23% 0.34% 210 Operating Supplies - General 5,000 8,000 3,000 60.00% 0.28% 0.40% 212 Operating Supplies - Fuel 34,860 34,860 0 0.00% 1.98% 1.75% 216 Operating Supplies - Chemicals 120,000 125,000 5,000 4.17% 6.81% 6.27% 217 Operating Supplies - Uniforms 3,000 3,000 0 0.00% 0.17% 0.15% 221 Repair & Maint Sup - Equipment 3,500 3,500 0 0.00% 0.20% 0.18% 223 Repair & Maint Sup - Bldgs 15,000 19,000 4,000 26.67% 0.85% 0.95% 224 Repair & Maint Sup - General 68,300 77 ,700 9,400 13.76% 3.88% 3.90% 240 Small Tools & Equipment 5,000 5,000 0 0.00% 0.28% 0.25% 241 Computer/Data Services 6,500 6,500 0.00% 0.00% 0.33% 260 Water Meters 47,450 47,450 0 0.00% 2.69% 2.38% 261 Pressure Reducers 10,900 10,900 0 0.00% 0.62% 0.55% 303 Professional Service - Engineering 35,000 27,500 (7,500) -21.43% 1.99% 1.38% 312 Professional Service - Water Samp 7,400 22,700 15,300 206.76% 0.42% 1.14% 321 Communications - Telephone 19,415 21,415 2,000 10.30% 1.10% 1.07% 322 Communications - Postage 10,275 4,200 (6,075) -59.12% 0.58% 0.21% 325 Communications - Utility Locations 9,394 9,394 0 0.00% 0.53% 0.47% 331 Training & Certification 16,800 16,350 (450) -2.68% 0.95% 0.82% 334 Car Allowance 1,800 (1,800) -100.00% 0.10% 0.00% 354 Public Information 9,000 9,000 0 0.00% 0.51% 0.45% 363 Insurance - Auto 3,550 3,550 0 0.00% 0.20% 0.18% 381 Utilities - Electric 221,600 221,600 0 0.00% 12.58% 11.11% 383 Utilities - Gas 64,000 64,000 0 0.00% 3.63% 3.21% 384 Refuse Disposal 13,540 13,540 0 0.00% 0.77% 0.68% 401 Repair & Maint Service - Bldg 61,650 52,790 (8,860) -14.37% 3.50% 2.65% 404 Repair & Maint Service - Equip 2,525 1,850 (675) -26.73% 0.14% 0.09% 406 Repair & Maint Service - Cleaning 21,690 12,690 (9,000) -41.49% 1.23% 0.64% 407 Software Service Contract 11 ,369 5,950 (5,419) -47.66% 0.65% 0.30% 412 Repair & Maint Service - General 66,900 93,400 26,500 39.61 % 3.80% 4.68% 415 Rentals - Heavy Equipment 14,400 25,000 10,600 73.61 % 0.82% 1.25% 433 Misc Expense - Dues & Subscr 4,825 5,025 200 4.15% 0.27% 0.25% Page 12 of 14 11/16/2009 --- City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Expenditure Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of %of %of %of Budget Proposed 09 -10 09 -10 Subtotal Subtotal Total Total 437 Misc Expense - General 200 (200) -100.00% 0.01% 0.00% 530 Improvements 300,000 475,000 175,000 58.33% 17.04% 23.82% 580 General Equipment 11 ,200 20,000 8.800 78.57% 0.64% 1.00% 1.761,003 1.994,293 233.290 13.25% 100.00% 100.00% 33.92% 35.94% 49450 Sewer 101 Full Time Employees Regular 370,680 324,080 (46,600) -12.57% 17.72% 14.55% 102 Full Time Employees Overtime 29,422 23,000 (6,422) -21.83% 1.41% 1.03% 103 Part Time Employees - Regular 27,375 27,375 0.00% 0.00% 1.23% 104 Temporary Employees Regular 42,240 42,240 0 0.00% 2.02% 1.90% 113 Sick Leave 3,985 5,019 1,034 25.95% 0.19% 0.23% 121 PERA Contributions 27,007 27,011 4 0.01% 1.29% 1.21% 122 FICA Contributions 27,537 26,146 (1,391 ) -5.05% 1.32% 1.17% 123 MEDICARE Contributions 6,440 6,115 (325) -5.05% 0.31% 0.27% 131 Health Insurance 44,700 37,395 (7,305) -16.34% 2.14% 1.68% 132 Dental Insurance 2,440 2,224 (216) -8.86% 0.12% 0.10% 133 Life Insurance 650 542 (109) -16.69% 0.03% 0.02% 135 Health Savings Plan 450 525 75 16.67% 0.02% 0.02% 151 Workers Comp - Insurance 27,550 33,066 5,516 20.02% 1.32% 1.49% 201 Office Supplies 1,000 1,000 0 0.00% 0.05% 0.04% 203 Office Supplies - Printed Forms 3,950 2,600 (1,350) -34.18% 0.19% 0.12% 210 Operating Supplies - General 4,000 7,000 3,000 75.00% 0.19% 0.31 % 212 Operating Supplies - Fuel 34,860 34,860 0 0.00% 1.67% 1.57% 217 Operating Supplies - Uniforms 2,600 2,600 0 0.00% 0.12% 0.12% 224 Repair & Maint Sup - General 69,000 84,000 15,000 21.74% 3.30% 3.77% 240 Small Tools & Equipment 5,500 5,500 0 0.00% 0.26% 0.25% 241 ComputerlData Services 6,500 6,500 0.00% 0.00% 0.29% 303 Professional Service - Engineering 20,000 12,500 (7,500) -37.50% 0.96% 0.56% 321 Communications - Telephone 13,310 14,810 1,500 11.27% 0.64% 0.67% 322 Communications - Postage 6,075 (6,075) -100.00% 0.29% 0.00% 331 Training & Certification 14,750 15,650 900 6.10% 0.71% 0.70% 334 Car Allowance 1,800 (1,800) -100.00% 0.09% 0.00% 363 Insurance - Auto 3,550 3,550 0 0.00% 0.17% 0.16% 381 Utilities - Electric 45,000 45,000 0 0.00% 2.15% 2.02% 404 Repair & Maint Service - Equip 2,000 2,000 0 0.00% 0.10% 0.09% 407 Software Service Contract 4,450 4,450 0 0.00% 0.21% 0.20% 412 Repair & Maint Service - General 95,000 124,500 29,500 31.05% 4.54% 5.59% 415 Rentals - Heavy Equipment 3,000 10,500 7,500 250.00% 0.14% 0.47% 433 Misc Expense - Dues & Subscr 325 325 0 0.00% 0.02% 0.01% 437 Misc Expense - General 500 500 0 0.00% 0.02% 0.02% 440 MCES Installment 1,048,718 1,150,016 101,298 9.66% 50.14% 51.65% 530 Improvements 125,000 140,000 15,000 12.00% 5.98% 6.29% 580 General Equipment 4,000 4,000 0 0.00% 0.19% 0.18% 2,091,489 2.226.598 135.109 6.46% 100.00% 100.00% 40.29% 40.12% 49003 Lift Station Upgrade 224 Repair & Maint Supplies - Genl 75,000 (75,000) -100.00% 45.45% 0.00% 501 Contract Vouchers 75,000 (75,000) -100.00% 45.45% 0.00% 502 Engineering 15,000 (15.000) -100.00% 9.09% 0.00% 165.000 (165.000) -100.00% 100.00% 0.00% 3.18% 0.00% 49005 CIPP Slip Lining 501 Contract Vouchers 130,000 150,000 20.000 15.38% 100.00% 100.00% 130.000 150.000 20.000 15.38% 100.00% 100.00% 2.50% 2.70% 49303 Transfers to other funds 1,044,214 1,054,796 10.582 1.01% 100.00% 100.00% 20.11 % 19.01 % WATER & SEWER FUND TOTAL 5,191,706 5,549,557 357,851 6.89% 100.00% 100.00% 100.00% 100.00% Page 13 of 14 11/16/2009 City of Prior Lake BUDGET WORKSHOP 11/16/2009 2010 Proposed Budget Expenditure Details 2009 2010 2009 2010 2009 2010 $ Change % Change %of %of %of %of BUd'iJet Proposed 09 -10 09 - 10 Subtotal Subtotal Total Total WATER QUALITY FUND 49420 Water Quality 101 Full Time Employees Regular 90,411 103,076 12,665 14.01% 21.43% 23.25% 102 Full Time Employees Overtime 3,266 (3,266) -100.00% 0.77% 0.00% 104 Temporary Employees Regular 17,640 17,640 0 0.00% 4.18% 3.98% 113 Sick Leave 832 832 0.00% 0.00% 0.19% 121 PERA Contributions 6,323 7,565 1,242 19.65% 1.50% 1.71% 122 FICA Contributions 6,902 7,536 634 9.19% 1.64% 1.70% 123 MEDICARE Contributions 1,614 1,762 148 9.20% 0.38% 0.40% 131 Health Insurance 8,100 9,198 1,098 13.56% 1.92% 2.07% 132 Dental Insurance 430 627 197 45.73% 0.10% 0.14% 133 Life Insurance 125 146 21 17.03% 0.03% 0.03% 151 Workers Comp - Insurance 345 559 214 62.06% 0.08% 0.13% 201 Office Supplies 500 500 0 0.00% 0.12% 0.11% 203 Office Supplies - Printed Forms 2,000 2,000 0 0.00% 0.47% 0.45% 210 Operating Supplies - General 1,000 1,000 0 0.00% 0.24% 0.23% 224 Repair & Maint Sup - General 500 500 0 0.00% 0.12% 0.11% 314 Professional Service - General 20,250 25,625 5,375 26.54% 4.80% 5.78% 331 Training & Certification 1,000 1,000 0 0.00% 0.24% 0.23% 412 Repair & Maint Service - General 25,000 37,800 12,800 51.20% 5.93% 8.53% 433 Misc Expense - Dues & Subscr 400 (400) -100.00% 0.09% 0.00% 437 Misc Expense - General 1,000 1,000 0 0.00% 0.24% 0.23% 530 Improvements 235.000 225,000 (10,000) -4.26% 55.71% 50.75% 421.806 443,367 21,561 5.11% 100.00% 100.00% 100.00% 100.00% WATER QUALITY FUND TOTAL 421,806 443,367 21,561 5.11% 100.00% 100.00% 100.00% 100.00% TRANSIT FUND 49804 Transit 101 Full Time Employees Regular 70,323 73,391 3,068 4.36% 8.68% 6.41% 113 Sick Leave 1,631 1,715 84 5.15% 0.20% 0.15% 121 PERA Contributions 4,747 5,137 390 8.22% 0.59% 0.45% 122 FICA Contributions 4,527 4,657 130 2.86% 0.56% 0.41% 123 MEDICARE Contributions 1,059 1,089 30 2.84% 0.13% 0.10% 131 Health Insurance 4,050 4,131 81 2.00% 0.50% 0.36% 132 Dental Insurance 215 229 14 6.41% 0.03% 0.02% 133 Life Insurance 70 68 (3) -3.57% 0.01% 0.01% 135 Health Savings Plan 225 225 0 0.00% 0.03% 0.02% 151 Workers Comp - Insurance 505 565 60 11.84% 0.06% 0.05% 201 Office Supplies 500 500 0 0.00% 0.06% 0.04% 203 Office Supplies - Printed Forms 9,000 9,000 0 0.00% 1.11% 0.79% 314 Professional Service - General 7,500 25,200 17,700 236.00% 0.93% 2.20% 321 Communications - Telephone 240 1,620 1,380 575.00% 0.03% 0.14% 331 Training & Certification 2,880 2,000 (880) -30.56% 0.36% 0.17% 334 Car Allowance 2,700 (2,700) -100.00% 0.33% 0.00% 412 Repair & Maint Service - General 20,000 20,000 0 0.00% 2.47% 1.75% 418 Facility Rental 29,000 29,000 0 0.00% 3.58% 2.53% 425 Transit Contract Service 626,448 681,000 54,552 8.71% 77.33% 59.49% 433 Misc Expense - Dues & Subscr 500 500 0 0.00% 0.06% 0.04% 437 Misc Expense - General 4,000 4,000 0 0.00% 0.49% 0.35% 530 Improvements 20.000 280.636 260.636 1303.18% 2.47% 24.52% 810.120 1,144.662 334.542 41.30% 100.00% 100.00% 100.00% 100.00% TRANSIT FUND TOTAL 810,120 1,144,662 334,542 41.30% 100.00% 100.00% 100.00% 100.00% GRAND TOTAL - ALL BUDGETED FUNDS 18,900,606 19,258,133 357,527 1.89% Page 14 of 14 11/16/2009