Loading...
HomeMy WebLinkAbout3.G. Utility Funds 3..G. CITY OF SHAKOPEE Memorandum TO: Mayor and Council Mark McNeill, City Administrator FROM: Gregg Voxland, Finance Director SUBJ: 2009 Sewer and Storm Utility Budgets and Rates DATE: October 22, 2008 Proposed for inclusion in the 2009 Fee Schedule are rate changes for the Sewer Fund and the Storm Fund. The city's operational budget for the two funds is similar to this year with increasing costs to maintain the storm drainage system. The capital expenditures for the funds were reviewed with the Capital Improvement Plan. Sewer It is recommended to increase the flow charge for sewer. The 2008 flow charge is $1.65 per thousand gallons and it is recommended to increase it to $1. 70. Forecasting revenue is difficult due to the effects of Rahr's flow and the effects of infiltration, inflow, growth and Rahr Malting. Metropolitan Council (MCES) is raising the treatment charge from $1.70 per thousand gallons to $1.75 per thousand gallons for an increase of 3.0%. Based on the cash position of the fund, the city flow rate was not changed for 2008 and therefore is a nickel less than the MCES rate. Also, we are changing the service life (depreciation) of new pipe from 50 to 75 years which slows the rate of increase in accumulated depreciation and the subsequent desired cash amount for replacement. It is proposed that the base fee of $7.50 per month would not change. The weighted average cost for 2006 for residential sewer service for cities served by the Metropolitan Council is $181 per year. Shakopee's cost was $180 per year. These figures are based on 5,000 gallons of water usage per month. This is the latest data available. With the proposed rate increases, an average residential user's bill would go from $16.00 per month to $16.25 total for both flat fee and flow fee. The rate for Whispering Oaks is higher because it flows to the Savage collection system. Metro SAC credits for Rahr coming off line are included in the 2009 budget. An estimated $230,000 is shown. Staff is exploring the best ways to use or not use this money. The city will be receiving this money ($3,000,000) over a number of years as sac charges are collected with building permits but because of the credit, the city keeps the money instead of sending it to the Met Council. The money is included in the Sewer Fund. Surface Water (Storm) No change in the rate is recommended at this time. The rate per month is $2.90 for a residence. 1 , . Alternatives 1. Maintain rates the same as 2008. 2. Adopt different rates. 3. Adopt rates proposed above. Recommendation Recommend is Alternative 3. Action requested Move to accept the Sewer and Surface Water Funds budget and direct staff to include in the 2009 Fee Schedule the rates of: $7.50 for the Sewer base rate. Sewer flow fee of $1.70 per 1,000 gallons of water use/flow and $2.98 for those accounts served by City of Savage sewer system. $26.32 per residential equivalent factor per acre per quarter for the Surface Water Fund. Gregg Voxland Finance Director 3 SANITARY SEWER FUND 2009 BUDGET ACTIVITY: Activity in this enterprise fund reflects the operations of the Municipal Sanitary Sewer System. OBJECT DESCRIPTION: Description of lines items: Salaries: Share of Public Works staff/Engineering staff. Supplies and Materials: Repair and maintain current sewer lines including; manhole replacement, repairing lines, GIS/CMMS software and hardware, motor fuels, safety equipment, GPS unit for vehicle and supplies, miscellaneous. Professional Services: Attorney, engineering consultant for projects, televising, foaming, lining of sewer mains, Lift Station Maintenance, Gopher State One Call, GIS/CMMS consultant. Rentals: Building rent and equipment rent. Utility Service: Lift stations, payment to Savage for Whispering Oaks sewer. MCES Treatment Cost: Metro Council Environmental Services. Depreciation: Includes equipment and infrastructure. Capital Expenditures: Easement sewer machine $15,000, projects per CIP Equipment in Sewer Fund: 1993 Ford high pres. Jetter $ 54,527 2000 Ford 1.5 T P/U w/Hoist 52,860 2002 Versa-Vac 60,300 2006 Ford F350 W/Plow 26,369 2007 Sterling Acterra - Jetter 127,612 5 R5509BUD [0"'15001 CITY OF S. . ,JPEE 10/~, .0812:49:42 Fiscal Period: 9 / 8 Budget Report Page - 1 Level Of Rollup 7 2005 2006 2007 9/30/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Req uested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 07100 SEWER FUND 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4100 SPECIAL ASSESSMENT 4110 SPECIAL ASSESSMENT PRINCIPAL 261- 26,369- 4111 SPEC ASSESSMENT INTEREST 29,503- 4120 SA PREPAY 1,104- 4100 SPECIAL ASSESSMENT 29,765- 27,473- 4200 LICENSES AND PERMITS 4250 PERMITS 4400 INTERGOVERNMENTAL 4410 FEDERAL GRANTS -....J 4500 CHARGES FOR SERVICE 4720 SEWER CHARGES 4721 SEWER CHARGES 2,229,920- 2,349,612- 2,610,312- 1,315,893- 2,488,000- 2,482,000- 2,482,000- 2,482,000- 4723 METRO SAC CHARGES 2,871- 10,720 26,914- 49,549- 230,000- 230,000- 230,000- 4725 CITY SAC CHARGES 458,100- 188,550- 135,825- 66,975- 50,000- 50,000- 50,000- 50,000- 4735 TRUNK CHARGE - SANITARY 280,711- 638,611- 28,295- 13,695- 50,000- 20,000- 20,000- 20,000- 4720 SEWER CHARGES 2,971,601- 3.166,053- 2,801,345- 1,446,112- 2,588,000- 2,782,000- 2,782,000- 2,782,000- 4750 REFUSE 4500 CHARGES FOR SERVICE 2,971,601- 3,166.053- 2,801,345- 1,446,112- 2,588,000- 2,782,000- 2,782,000- 2,782,000- 4830 MISCELLANEOUS 4832 INVESTMENT INCOME 4833 INTEREST 311,677- 686,190- 952,391- 136,980 400,000- 775,800- 775,800- 775,800- 4850 MISCELLANEOUS 1- 5,025- 40- 4832 INVESTMENT INCOME 311,677- 686,190- 957,416- 136,940 400,000- 775,800- 775,800- 775,800- 4830 MISCELLANEOUS 311,677- 686,190- 957,416- 136,940 400,000- 775,800- 775,800- 775,800- 4960 PROCEEDS FROM DEBT ISSUED 4970 CAPITAL CONTRIBUTIONS 4971 CAPITAL CONTRIBUTIONS 2,176,387- 1,762,782- 3,280,993- 4970 CAPITAL CONTRIBUTIONS 2,176,387- 1,762,782- 3,280,993- R5509BUD LOGIS001 CITY OF SHAKOPEE 10/27/200812:49:42 Fiscal Period: 9 / 8 Budget Report Page. 2 Level Of Rollup 7 2005 2006 2007 9/30/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 4001 REVENUES 5,459,665- 5,615,025- 7,069,519- 1,336,645- 2,988,000- 3,557,800- 3,557,800- 3,557,800- 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 46,968 78,455 84,279 134,201 101,700 131,070 131,070 131,070 6005 OVERTIME-FT 1,792 2,122 1,996 2,775 3,000 5,000 5,000 5,000 6010 PREMIUM PAY 295 150 4,000 4,000 4,000 6015 WAGES - PART TIMEfTEMP 538 975 1,258 2,551 5,000 7,000 7,000 7,000 6002 WAGES 49,298 81,847 87,683 139,528 109,700 147,070 147,070 147,070 6100 BENEFITS 6122 PERA 2,692 4,838 5,510 8,753 6,610 9,930 9,930 9,930 6124 FICA 3,511 5,763 6,363 9,821 7,780 11,250 11,250 11,250 6135 HEALTH 11,742 14,940 12.984 18,512 14,700 22,600 22,600 22,600 6139 POST EMPLOYMENT HEALTH PLAN 349 510 466 742 700 600 600 600 ex> 6140 L1FE/L TD 259 391 388 627 600 600 600 600 6145 DENTAL 401 622 584 997 800 960 960 960 6170 WORKERS COMPENSATION 1,781 2,347 4,125 5,148 4,000 6180 COMPENSATED ABS/OPEB 42,450 3,700 3,700 3,700 6100 BENEFITS 20,735 29,411 72,870 44,598 35,190 49,640 49,640 49,640 6001 WAGES & BENEFITS 70,033 111,258 160,554 184,126 144,890 196,710 196,710 196,710 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 8,193 23,526 20,947 7,013 30,000 30,000 30,000 30,000 6203 TOOLS 69 245 6210 OFFICE SUPPLIES 156 1,715 316 1,000 1,000 1,000 6212 UNIFORMS/CLOTHING 632 2,500 2,500 2,500 6215 MATERIALS 64 232 1,406 5,000 2,500 2,500 2,500 6222 MOTOR FUELS & LUBRICANTS 3,311 4,155 6,506 6,608 6,500 8,500 8,500 8,500 6240 EQUIPMENT MAINTENANCE 7,092 7,380 10,278 4,099 13,000 7,000 7,000 7,000 6245 UTILITY MAINT 1,200 6201 SUPPLIES & SERVICES 18,731 35,463 40,878 20,073 54,500 51,500 51,500 51,500 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 2,147 2,061 1,579 5,000 5,000 5,000 5,000 6312 ENGINEERING CONSULTANTS 5,855 18,063 27,474 20,634 80,000 30,000 30,000 30,000 6316 EQl)J"'~\=NT MAINTENANCE 3,196 2,139 17,517 10,000 14,000 14,000 14,000 R5509BUD L:D<5IS001 CITY OF S"" . _ .JPEE '10/~, .J812:49:42 Fiscal Period: 9 / 8 Budget Report Page - 3 Level Of Rollup 7 2005 2006 2007 9/30/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6322 PAVEMENT PRESERVATION 3,367 1,598 6,000 6,000 6,000 6327 OTHER PROF SERVICES 65,970 111,490 38,769 41,232 85,000 85,000 85,000 85,000 6300 PROFESSIONAL SERVICES 77.167 133,752 69,610 82,559 180,000 140,000 140,000 140,000 6330 COMMUNICATIONS 6334 TELEPHONE 538 1,187 1,193 978 1,500 1,500 1,500 1,500 6336 PRINTING/PUBLISHING 739 141 286- 900 500 500 500 500 6330 COMMUNICATIONS 1,277 1,328 1,479 1,878 2,000 2,000 2,000 2,000 6350 INSURANCE 6352 LIABILITY 3,557 4,151 16,078 21,574 5,000 21,000 21,000 21,000 6354 PROPERTY 1,146 4,000 4,000 4,000 6356 AUTO 1,461 1,794 2,731 2,000 3,000 2,500 2,500 2,500 6350 INSURANCE 5,018 5,945 18,809 24,720 8,000 27,500 27,500 27,500 6360 UTILITY SERVICE 8,000 (0 6362 ELECTRIC 953 6364 WATER 83 6365 GAS 2,044 6366 SEWER 23,251 50,848 60,972 32,744 60,000 62,000 62,000 62,000 6368 STORM 208 6369 CURRENT USE CHARGES 1,572,940 1,767,872 1,891,694 1,585,794 2,114,400 2,118,490 2,118,490 2,118,490 6360 UTILITY SERVICE 1,596,191 1,822,009 1,952,666 1,618,538 2,182,400 2,180,490 2,180,490 2,180,490 6400 RENTALS 6420 EQUIPMENT RENT 6,000 3,000 3,000 3,000 6430 BUILDING RENT (IS FUND) 9,660 9,972 8,154 12,000 15,000 15,000 15,000 6400 RENTALS 9,660 9,972 8,154 18,000 18,000 18,000 18,000 6470 DUESfTRAININGfTRAVEL 6472 CONFERENCE/SCHOOLITRAINING 1,548 2,098 3,949 1,831 5,000 6,000 6,000 6,000 6475 TRAVEUSUBSISTENCE 24 500 500 500 6480 DUES 150 200 200 200 6490 SUBSCRIPTIONS/PUBLICATIONS 70 59 100 100 100 6470 DUESfTRAININGfTRAVEL 1,548 2,098 4,043 2,040 5,000 6,800 6,800 6,800 6498 EXPENSE CHARGED BACK 9,000 32,479 15,400 17,000 17,000 17,000 6200 SUPPLIES AND SERVICES 1,708,933 2,042,733 2,112,856 1,757,962 2,449,900 2,443,290 2,443,290 2,443,290 6500 DEPRECIATION R5509BUD LOGIS001 CITY OF SHAKOPEE 10/27/200812:49:42 Fiscal Period: 9 / 8 Budget Report Page- 4 Level Of Rollup 7 2005 2006 2007 9/30/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6501 DEPRECIATION EXPENSE 6502 DEPRECIATION EXPENSE 559,332 602,904 665,545 750,000 885,000 885,000 885,000 6501 DEPRECIATION EXPENSE 559,332 602,904 665,545 750,000 885,000 885,000 885,000 6500 DEPRECIATION 559,332 602,904 665,545 750,000 885,000 885,000 885,000 6600 MISCELLANEOUS 6610 AWARDS & DAMAGES 10,750 6600 MISCELLANEOUS 10,750 6700 CAPITAL OUTLAY 6740 EQUIPMENT 26,000 15,000 15,000 15,000 6760 IMPROVEMENTS 29,339 1,676 6700 CAPITAL OUTLAY 29,339 1,676 26,000 15,000 15,000 15,000 6800 DEBT SERVICE ..... 6840 DEBT SERVICE INTEREST 0 6000 EXPENDITURES 2,349,048 2,786,235 2,938,954 1,943,764 3,370,790 3,540,000 3,540,000 3,540,000 8005 TOTAL TRANSFERS IN 8010 OPERATING TRANSFERS IN 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 8053 TRANSFERS OUT 245,892 25,000 50,000 50,000 50,000 8056 OPERATING TRANSFER/CAPITAL FD 1,427 1,175,525 8052 TRANSFERS OUT 1,427 1,175,525 245,892 25,000 50,000 50,000 50,000 8050 TOTAL TRANSFERS OUT 1,427 1,175,525 245,892 25,000 50.000 50,000 50,000 8100 GAIN/LOSS ON DISPOSAL OF ASSET 8101 PROCEEDS FROM SALE (GAIN/LOSS) 8102 NET BOOK VALUE 4,000 8101 PROCEEDS FROM SALE (GAIN/LOSS) 4,000 8100 GAIN/LOSS ON DISPOSAL OF ASSET 4,000 4000 REVENUES AND EXPENDITURES 3,109,191- 1,653,266- 3,884,673- 611,119 407,790 32,200 32,200 32,200 07100 SEWI?LE:;UND 3,109,191- 1,653,266- 3,884,~P-_._ 611,119 407,790 32,200 32,200 32,200 Sanitary Sewer Fund Projected Cash Levels 2009-2013 Capital Improvement Program City of Shakopee, Minnesota 2009 2010 2011 2012 2013 TRUNK: Cash Balance January 1 $ 1,008,835 $ 728,835 $ 798,835 $ 868,835 $ 738,835 Revenue - City SAC 50,000 50,000 50,000 50,000 50,001 Revenue - Trunk Charges 20,000 20,000 20,000 20,000 20,000 Expenditures per List-SEWER-T (350,000) (200,000) (580,000) Excess (Deficiency) (280,000) 70,000 70,000 (130,000) (509,999) Balance Available 12/31 728,835 798,835 868,835 738,835 228,836 --" BASE: --" Cash Balance January 1 9,176,761 9,339,571 8,952,679 8,853,324 9,209,926 Revenue - Monthly Flat Fee 865,200 891 ,156 917,891 945,427 973,790 Revenue - Flow charges 1,616,800 1,681,472 1,748,731 1,818,680 1,891,427 Revenue - Interest 775,810 402,740 390,060 388,890 397,950 Rahr SAC credit 230,000 230,000 230,000 230,000 230,000 Non-Operating Income Operation Expenses (521,510) (547,586) (574,965) (603,713) (633,899) MCES Expenses (2,118,490) (2,139,675) (2,161,072) (2,182,682) (2,204,509) Capital Equipment (15,000) Expenditures per List-SEWER-B (670,000) (905,000) (650,000) (240,000) (290,000) Excess (Deficiency) 162,810 (386,892) (99,355) 356,602 364,760 Balance Available 12/31 9,339,571 8,952,679 8,853,324 9,209,926 9,574,686 Total Balance 12/31 $ 10,068,406 $ 9,751,514 $ 9,722,159 $ 9,948,761 $ 9,803,522 Accumulated Depreciation $ 7,900,000 SURFACE WATER FUND 2009 BUDGET ACTIVITY: Activity in this enterprise fund reflects the operations of the Municipal Storm Drainage System. OBJECT DESCRIPTION: Description of lines items: Salaries: Share of Public Works staff/Engineering staff. Supplies and Services: Materials for maintaining/repairing storm sewer facilities, GIS/CMMS software and hardware, GPS unit for vehicle, motor fuels. Professional Services: Engineering consultant to update storm water plans, storm water mode 1 , review of storm water utility policy and procedures and rate study,. water quality monitoring study in infiltration areas and downtown area, GIS/CMMS consultant service, Gopher State One Call. Rentals: Building Rental ($15,000) and equipment rental. Utility Service: ($1,000) . Purchase of Right of Way Pond: $550,000 (MNDOT payment for TH 169 ponds) Depreciation: Includes equipment and infrastructure. Capital Expenditures: Sweeper $190,000, projects per CIP. Equipment in Storm Fundi 1996 Side Broom $ 27,228 2002 Leaf collection sys 30,507 2003 Street Sweeper 127,653 2005 Tanker truck 109,139 2005 Terratrac TT75 mower 90,268 2008 Bobcat S185 24,280 2008 JD 6430/mower 94,167 13 R5509BUD LOG1SOOl CITY OF $, ..~ .jpEE 10/" . Jv812:43:22 Fiscal Period: 9 / 8 Budget Report Page - 1 Level Of Rollup 7 2005 2006 2007 9/30/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 07300 SURFACE WATER FUND 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4010 PROPERTY TAX 4100 SPECIAL ASSESSMENT 4200 LICENSES AND PERMITS 4400 INTERGOVERNMENTAL 4450 STATE GRANTS & AIDS 4500 CHARGES FOR SERVICE 4670 PUBLIC WORKS 4680 MISC PUBLIC WORKS 195- ...... 4670 PUBLIC WORKS 195- c..n 4720 SEWER CHARGES 4740 STORM DRAINAGE 4745 STORM CHARGES 1,097,835- 1,171,063- 1,250,779- 722,119- 1,032,000- 1,279,600- 1,279,600- 1,279,600- 4746 TRUNK CHARGE - STORM 793,401- 688,849- 238,889- 114,447- 50,000- 20,000- 20,000- 20,000- 4740 STORM DRAINAGE 1,891,235- 1,859,912- 1,489,668- 836,566- 1,082,000- 1,299,600- 1,299,600- 1,299,600- 4500 CHARGES FOR SERVICE 1.891,430- 1,859,912- 1,489,668- 836,566- 1,082,000- 1,299,600- 1,299,600- 1,299,600- 4830 MISCELLANEOUS 4832 INVESTMENT INCOME 4833 INTEREST 237,145- 538,084- 872,871- 137,668 350,000- 509,000- 509,000- 509,000- 4845 CONTRIBUTIONS 15,579- 4850 MISCELLANEOUS 46,000- 0 4832 INVESTMENT INCOME 283,145- 538,084- 888,450- 137,668 350,000- 509,000- 509,000- 509,000- 4830 MISCELLANEOUS 283,145- 538,084- 888,450- 137,668 350,000- 509,000- 509,000- 509,000- 4960 PROCEEDS FROM DEBT ISSUED 4970 CAPITAL CONTRIBUTIONS '4971 CAPITAL CONTRIBUTIONS 3,587,434- 2,215,105- 693,194- 4970 CAPITAL CONTRIBUTIONS 3,587,434- 2,215,105- 693,194- R5509BUD LOGIS001 CITY OF SHAKOPEE 10/311200Bl2:43:22 Fiscal Period: 9 / 8 Budget Report Page - 2 Level Of Rollup 7 2005 2006 2007 9/30/2008 2008 2009 2009 2009 Actual Actual Actual YTO Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 4001 REVENUES 5,762,009- 4,613,101- 3,071,312- 698,898- 1,432,000- 1,808,600- 1,808,600- 1,808,600- 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 115,364 104,653 152,071 159,163 126,700 155,920 155,920 155,920 6005 OVERTIME-FT 3,268 1,559 699 1,884 3,000 4,000 4,000 4,000 6010 PREMIUM PAY 225 359 320 2,000 2,000 2,000 6015 WAGES - PART TIMEfTEMP 6,262 8,152 7,767 4,781 13,000 13,000 13,000 13,000 6002 WAGES 124,893 114,589 160,896 166,147 142,700 174,920 174,920 174,920 6100 BENEFITS 6122 PERA 6,557 6,382 9,632 10,392 8,240 11,810 11,810 11,810 6124 FICA 8,917 8,123 11,337 11,776 9,700 13,380 13,380 13,380 6135 HEALTH 17,405 14,336 19,251 20,898 18,150 18,130 18,130 18,130 6139 POST EMPLOYMENT HEALTH PLAN 728 623 890 981 1,000 600 600 600 .... 6140 lIFE/L TO 530 468 697 804 800 600 600 600 0) 6145 DENTAL 824 760 1,030 1,318 1,000 960 960 960 6170 WORKERS COMPENSATION 3,786 6,150 6,817 7,506 7,300 6180 COMPENSATED ABS/OPES 7,088 3,700 3,700 3,700 6100 BENEFITS 38,747 36,841 56,742 53,674 46,190 49,180 49,180 49,180 6001 WAGES & BENEFITS 163,640 151,431 217,638 219,822 188,890 224,100 224,100 224,100 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 8,178 33,307 28,445 11.436 20,000 20,000 20,000 20,000 6203 TOOLS 245 6210 OFFICE SUPPLIES 156 1,676 333 6212 UNIFORMS/CLOTHING 938 2,500 2,500 2,500 6215 MATERIALS 13,667 1,089 19,779 6,609 20,000 20,000 20,000 20,000 6222 MOTOR FUELS & LUBRICANTS 6,195 6,968 9,945 11,850 10,000 15,000 15,000 15,000 6240 EQUIPMENT MAINTENANCE 14,834 31.797 38,449 1,093 6245 UTILITY MAl NT 6,479 847- 6201 SUPPLIES & SERVICES 42,873 73,562 104,774 31,411 50,000 57,500 57,500 57,500 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 662 1,150 4,605 698 5,000 5,000 5,000 5,000 6312 ENGINEERING CONSULTANTS 65,273 140,915 66,224 17,098 75,000 75,000 75,000 75,000 6316 EQ~tIP1l.1ENT MAINTENANCE 69 59 1= 53,643 40,000 60,000 60,000 60,000 R5509BUD [tJ\515001 CITY OF $,,_.. .JPEE 10/::' . .v812:43:22 Fiscal Period: 9 / 8 Budget Report Page - 3 Level Of Rollup 7 2005 2006 2007 9/30/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6327 OTHER PROF SERVICES 37,192 18,086 150,936 269,655 60,000 6300 PROFESSIONAL SERVICES 103,195 160,211 221,912 341,094 180,000 140,000 140,000 140,000 6330 COMMUNICATIONS 6334 TELEPHONE 382 1,619 1,198 855 1,000 1,500 1,500 1,500 6336 PRINTING/PUBLISHING 534 736 286 374 1,000 1,000 1,000 1,000 6330 COMMUNICATIONS 915 2,355 1,484 1,229 2,000 2,500 2,500 2,500 6350 INSURANCE 6352 LIABILITY 1,797 4,482 6,434 3,481 6,000 6,500 6,500 6,500 6354 PROPERTY 806 692 513 1,124 800 1,200 1,200 1,200 6356 AUTO 1.283 834 887 818 2,000 2,000 2,000 2,000 6350 INSURANCE 3,886 6,008 7,834 5,423 8,800 9,700 9,700 9,700 6360 UTILITY SERVICE 12,800 1,000 1,000 1,000 6362 ELECTRIC 719 1,649 943 652 -' 6364 WATER 83 -...,J 6365 GAS 2,044 6366 SEWER 78 6367 REFUSE 75 6368 STORM 208 6360 UTILITY SERVICE 719 4,062 943 727 12,800 1,000 1,000 1,000 6400 RENTALS 6420 EQUIPMENT RENT 21,697 9,095 11.260 34 10,000 5,000 5,000 5,000 6430 BUILDING RENT (IS FUND) 9,660 9,972 8,154 12,000 15,000 15,000 15,000 6400 RENTALS 21,697 18,755 21,232 8,188 22,000 20,000 20,000 20,000 6470 DUESITRAININGITRAVEL 6472 CONFERENCElSCHOOL/TRAINING 1,664 560 3,000 3,500 3,500 3,500 6475 TRAVEUSUBSISTENCE 24 500 500 500 6480 DUES 895 20 300 300 300 6490 SUBSCRIPTIONS/PUBLICATIONS 70 59 100 100 100 6470 DUESITRAININGITRAVEL 895 1,778 619 3,000 4,400 4,400 4,400 6498 EXPENSE CHARGED BACK 18,000 23,679 15,400 17,000 17,000 17,000 6200 SUPPLIES AND SERVICES 191,286 289,526 375,357 388.691 278,600 252,100 252,100 252,100 6500 DEPRECIATION 6501 DEPRECIATION EXPENSE R5509BUD LOGIS001 CITY OF SHAKOPEE 10/31/200812:43:22 Fiscal Period: 9 I 8 Budget Report Page - 4 Level Of Rollup 7 2005 2006 2007 9/30/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Requested Approved Final Object Code I Description Amount Amount Amount Actual Budget Budget Budget Budget 6502 DEPRECIATION EXPENSE 636,071 723,721 759,083 750,000 800,000 800,000 800,000 6501 DEPRECIATION EXPENSE 636,071 723.721 759,083 750,000 800,000 600,000 800,000 6500 DEPRECIATION 636,071 723,721 759,083 750,000 800,000 800,000 800,000 6600 MISCELLANEOUS 6620 PROPERTY TAX/SPECIAL ASSESS 302 285 300 6600 MISCELLANEOUS 302 285 300 6700 CAPITAL OUTLAY 6740 EQUIPMENT 175,000 190,000 190,000 190,000 6760 IMPROVEMENTS 357,402 1,447 550,000 550,000 550,000 550,000 6700 CAPITAL OUTLAY 357,402 1,447 725,000 740,000 740,000 740,000 6800 DEBT SERVICE 6802 DEBT SERVICE PRINCIPAL ...I. ClO 6840 DEBT SERVICE INTEREST 6850 DEBT SERVICE INTEREST 7,801 605 6860 FISCAL AGENT FEES 750 375 6840 DEBT SERVICE INTEREST 8,551 980 6800 DEBT SERVICE 8,551 980 6000 EXPENDITURES 999,849 1,523,344 1,352,078 609,960 1,942,790 2,016,200 2,016,200 2,016,200 8005 TOTAL.~TRANSFERS IN 8010 OPERATING TRANSFERS IN 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 8053 TRANSFERS OUT 191,285 48,040 50,000 50,000 50,000 8056 OPERATING TRANSFER/CAPITAL FD 644 566,664 8052 TRANSFERS OUT 644 566,664 191,285 48,040 50,000 50,000 50,000 8050 TOTAL TRANSFERS OUT 644 566,664 191,285 48,040 50,000 50,000 50,000 8100 GAINILOSS ON DISPOSAL OF ASSET 8101 PROCEEDS FROM SALE (GAIN/LOSS) 4000 REVE!'I.lJ.~S AND EXPENDITURES 4,761,516- 2,523,092- 1,527,~l'-o-, 88,939- 558,830 257,600 257,600 257,600 R5509BUD U..J\.:iIS001 CITY OF S. '" .JPEE 10/3. _J812:43:22 Fiscal Period: 9 I 8 Budget Report Page - 5 Level Of Rollup 7 2005 2006 2007 9/30/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Requested Approved Final Object Code I Description Amount Amount Amount Actual Budget Budget Budget Budget 07300 SURFACE WATER FUND 4.761,516- 2,523,092- 1,527,949- 88,939- 558,830 257,600 257,600 257,600 ..... <.0 Surface Water Fund Projected Cash levels 2009-2013 Capital Improvement Program City of Shakopee, Minnesota TRUNK: 2009 2010 2011 2012 2013 Cash Balance January 1 $ 4,904,415 $ 4,599,415 $ 4,284,415 $ 4,304,415 $ 4,324,415 Revenue - Trunk Charges 20,000 20,000 20,000 20,000 20,000 Expenditures per List-Storm-T (325,000) (335,000) (250,000) Excess (Deficiency) (305,000) (315,000) 20,000 20,000 (230,000) Balance 12/31 4,599,415 4,284,415 4,304,415 4,324,415 4,094,415 BASE: Cash Balance January 1 8,008,785 8,858,715 9,258,891 9,909,391 10,498,744 Revenue - User Fees 1,279,600 1,292,396 1,305,320 1,318,373 1,331,557 I\) Revenue - Donations - - - - - ..... Revenue - Interest 516,530 183,980 171,380 172,180 172,980 Operation Expenses (476,200) (476,200) (476,200) (476,200) (476,200) Capital Equipment (190,000) (165,000) AP changes Expenditures per List (280,000) (600,000) (185,000) (425,000) (2,805,000) Expenditures per List - Donation Excess (Deficiency) 849,930 400,176 650,500 589,353 (1,776,663) Balance 12/31 8,858,715 9,258,891 9,909,391 10,498,744 8,722,081 Total Balance 12/31 $ 13,458,130 $ 13,543,306 $ 14,213,806 $ 14,823,159 $ 12,816,496 Accumulated Depreciation $ 8,400,000