Loading...
HomeMy WebLinkAbout3.B. 2007 Sewer and Storm Utility Budgets and Rates d.~ . CITY OF SHAKOPEE Memorandum TO: Mayor and Council Mark McNeill, City Administrator FROM: Gregg Voxland, Finance Director SUBJ: 2007 Sewer and Storm utility Budgets and Rates DATE: October 18, 2006 Proposed for inclusion in the 2007 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 2006 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 2006 flow charge is $1.60 per thousand gallons and it is recommended to increase it to $1.65. Forecasting revenue is difficult due to the effects of Rahr's flow and the effects of infiltration, inflow and growth. Metropolitan Council is raising the treatment charge from $1,543 per million gallons to $1,527 per million gallons for a decrease of 1.0%. It is proposed that the base fee of $7.00 per month would increase .to $7.50. There are increasing costs for depreciation and cash outlay for sewer line replacement. The weighted average cost for 2006 for residential sewer service for cities served by the Metropolitan Council is $181 per year. Shakopee's cost is $180 per year. These figures are based on 5,000 gallons of water usage per month. With the proposed rate increases, an average residential user's bill would go from $8.00 per month to $8.75. Storm The increasing size of the system leads to increasing maintenance and depreciation and the need to have cash available for replacement. A three percent increase in the rate from $25.55 to $26.32 per Residential Equivalent Factor per quarter is recommended at this time. With the proposed rate increases, an residential bill would go from $2.84 per month to $2.90. Alternatives 1. Maintain rates the same as 2006. 2. Adopt different rates. 3. Adopt rates proposed above. Recommendation Recommend is Alternative 3. Action requested Move to accept the Sewer and Storm Funds budget and direct staff to include in the 2006 Fee Schedule the rates of: $7.50 for the Sewer base rate. Sewer flow fee of $1.65 per 1,000 gallons of water use/flow and $2.93 for those accounts served by City of Savage sewer system. $26.32 per residential equivalent factor per acre per quarter for the Storm Fund. Gregg Voxland Finance Director CITY OF SHAKOPEE, MINNESOTA Enterprise Funds 2007 Budget 2007 2006 Sanitary Storm Total Total Electric Water Sewer Drainage Enterprise Enterprise Fund Fund Fund Fund Budgets Budgets Revenues Operating Revenue $ 2,488,000 $1,032,000 $ 3,520,000 $44,303,000 Expenses Operating Expenses 2,456,660 402,960 2,859,620 29,875,690 Depreciation 700,000 750,000 1,450,000 3,563,000 Operating Income - - (668,660) (120,960) (789,620) 10,864,310 Non-Operating Income 700,000 479,260 1,179,260 732,000 Non-Operating Expense - (501,000) Net Income (Loss) Before Operating Transfers - - 31 ,340 358,300 389,640 11,095,310 Operating Transfers (18,400) (48,040) (66,440) (1,655,000) Net Income (Loss) $ - $ - $ 12,940 $ 310,260 $ 323,200 $ 9,440,310 SANITARY SEWER FUND 2007 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 including GIS Supplies and Materials: Repair and maintain current sewer lines including; manhole replacement, repairing lines, GIS/asset management software and hardware, motor fuels. Professional Services: Attorney, engineering consultant for projects, televising, foaming, lining of sewer mains, Gopher State One Call. Rentals: Building rent and equipment rent. Utility Service: Capital Equipment: Wireless lift station monitoring equipment ($8,000 and software) , Sewer Jetter ($130,000) . Capital Improvements: Per CIP MCES Treatment Cost: Metro Council Environmental Services. Depreciation: Includes equipment and infrastructure. Sanitary Sewer Fund Projected Cash. Levels 2007 -2011 Capital Improvement Program City of Shakopee, Minnesota 2006 2007 2008 2009 2010 2011 TRUNK: Cash Balance January 1 $ (477,880) $ (1,244,630) $ (1,394,630) $ (1,188,630) $ (1,176,450) $ (957,905) Revenue - City SAC 400,000 200,000 200,000 200,000 400,000 400,000 Revenue - Trunk Charges 283,250 200,000 206,000 212,180 218,545 225,102 Expenditures per List-SEWER-T (1,050,000) (350,000) (200,000) Excess (Deficiency) (766,750) (150,000) 206,000 12,180 218,545 225,102 Balance Available 12/31 (1,244,630) (1,394,630) (1,188,630) (1,176,450) (957,905) (732,803) BASE: Cash. Balance January 1 $ 10,600,819 10,892,699 6,628,039 5,757,886 5,410,319 5,345,542 Revenue - Monthly Flat Fee 691,000 832,000 856,960 882,669 909,149 936,423 Revenue - Flow charges 2,070,000 1,656,000 1,722,240 1 ,791 ,130 1,862,775 1,937,286 Revenue - Interest 303,690 300,000 209,340 182,770 169,350 175,510 Non-Operating Income Operation Expenses (269,810) (484,660) (508,893) (534,338) (561,055) (589,107) MCES Expenses (1,768,000) (1,980,000) (1,999,800) (2,019,798) (2,039,996) (2,060,396) Capital Equipment (35,000) (138,000) (300,000) (55,000) Expenditures per List-SEWER-B (700,000) (4,450,000) (850,000) (650,000) (350,000) (150,000) Excess (Deficiency) 291,880 (4,264,660) (870,153) (347,567) (64,777) 249,716 Balance Available 12/31 10,892,699 6,628,039 5,757,886 5,410,319 5,345,542 5,595,258 Total Balance 12/31 $ 9,648,069 $ 5,233,409 $ 4,569,256 $ 4,233,869 $ 4,387,637 $ 4,862,455 Accumulated Depreciation $ 5,044,574 $ 5,544,574 191% 94% R5509BUD LOGIS001 CITY OF SHAKOPEE 10/18/200612:55:05 Fiscal Period: 9 / 06 Budget Report Page - 1 Level Of Rollup 7 2003 2004 2005 9/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 07100 SEWER FUND 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4200 LICENSES AND PERMITS 4250 PERMITS 4400 INTERGOVERNMENTAL 4410 FEDERAL GRANTS 4500 CHARGES FOR SERVICE 4720 SEWER CHARGES 4721 SEWER CHARGES 1,734,666- 2,186,873- 2,229,920- 1,373,669- 2,761,000- 2,488,000- 2,488,000- 2,488,000- 4723 METRO SAC CHARGES 13,136- 2,871- 109,058- 4725 CITY SAC CHARGES 534,160- 438,300- 458,100- 136,800- 400,000- 200,000- 200,000- 200,000e 4735 TRUNK CHARGE - SANITARY 382,738- 365,131- 280,711- 447,853- 283,000- 200,000- 200,000- 200,000- 4720 SEWER CHARGES 2,651,564- 3,003,440- 2,971,601- 2,067,380- 3,444,000- 2,888,000- 2,888,000- 2,888,000- 4750 REFUSE 4500 CHARGES FOR SERVICE 2,651,564- 3,003,440- 2,971,601- 2,067,380- 3,444,000- 2,888,000- 2,888,000- 2,888,000- 4830 MISCELLANEOUS 4832 INVESTMENT INCOME 4833 INTEREST 331,423- 311,802- 311,677- 181,908- 304,000- 300,000- 300,000- 300,000- 4832 INVESTMENT INCOME 331,423- 311,802- 311,677- 181,908- 304,000- 300,000- 300,000- 300,000- 4850 MISCELLANEOUS 1- 4830 MISCELLANEOUS 331,423- 311,802- 311,677- 181,908- 304,000- 300,000- 300,000- 300,000- 4960 PROCEEDS FROM DEBT ISSUED 4970 CAPITAL CONTRIBUTIONS 4971 CAPITAL CONTRIBUTIONS 2,073,620- 3,399,873- 2,176,387- 4970 CAPITAL CONTRIBUTIONS 2,073,620- 3,399,873- 2,176,387- 4001 REVENUES 5,056,607- 6,715,115- 5,459,665- 2,249,289- 3,748,000- 3,188,000- 3,188,000- 3,188,000- 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 27,048 28,249 46,968 46,603 45,000 95,390 86,700 86,700 6005 OVERTIME-FT 520 234 1,792 1,954 1,500 3,000 3,000 3,000 6015 WAGES - PART TIMEfTEMP 1,403 2,340 538 870 750 5,000 5,000 5,000 6002 WAGES 28,971 30,823 49,298 49,427 47,250 103,390 94,700 94,700 . . . R5509BUD LOGISOO1 CITY OF SHAKOPEE 10/18/200612:55:05 Fiscal Period: 9 / 06 Budget Report Page - 2 Level Of Rollup 7 2003 2004 2005 9/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested APproved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6100 BENEFITS 6122 PERA 1,558 1,688 2,692 2,900 2,590 6,460 5,920 5,920 6124 FICA 2,085 2,150 3,511 3,490 3,610 7,910 7,240 7,240 6135 HEALTH 5,119 6,531 11,742 9,716 8,000 16,000 16,000 16,000 6139 POST EMPLOYMENT HEALTH PLAN 179 176 349 319 340 700 700 700 6140 L1FE/L TO 167 177 259 244 280 600 600 600 6145 DENTAL 248 279 401 391 340 700 700 700 6170 WORKERS COMPENSATION 1,013 1,709 1,781 2,347 2,000 4,000 4,000 4,000 6100 BENEFITS 10,369 12,711 20,735 19,407 17,160 36,370 35,160 35,160 6001 WAGES & BENEFITS 39,340 43,534 70,033 68,834 64,410 139,760 129,860 129,860 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 4,957 1,203 8,193 6,533 4,000 25,000 25,000 25,000 6203 TOOLS 69 6210 OFFICE SUPPLIES 156 6215 MATERIALS 63 64 10,000 5,000 5,000 5,000 6222 MOTOR FUELS & LUBRICANTS 2,197 1,745 3,311 2,966 5,000 6,000 6,000 6,000 6240 EQUIPMENT MAINTENANCE 5,618 8,382 7,092 5,791 8,000 16,000 16,000 16,000 6201 SUPPLIES & SERVICES 12,836 11,330 18,731 15,446 27,000 52,000 52,000 52,000 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 2,147 5,421 5,000 5,000 5,000 5,000 6312 ENGINEERING CONSULTNTS 1,133 40,473- 5,855 191,747 120,000 120,000 120,000 6316 EQUIPMENT MAINTENANCE 8,373 700 3,196 2,139 10,000 800 800 800 6318 FILING FEES 46 6327 OTHER PROF SERVICES 52,275 28,828 65,970 51,201 85,000 85,000 85,000 85,000 6300 PROFESSIONAL SERVICES 61,781 10,945- 77,167 250,555 100,000 210,800 210,800 210,800 6330 COMMUNICATIONS 6332 POSTAGE 750 1,000 1,000 1,000 6334 TELEPHONE 538 815 500 1,000 1,000 1,000 6336 PRINTING/PUBLISHING 739 960 1,000 1,000 1,000 1,000 6330 COMMUNICATIONS 1,277 1,774 2,250 3,000 3,000 3,000 6350 INSURANCE 6352 LIABILITY 9,595 10,078 3,557 4,151 25,000 5,000 5,000 5,000 6356 AUTO 1,832 1,603 1,461 1,794 2,000 2,000 2,000 . . . R5509BUD LOGIS001 CITY OF SHAKOPEE 10/18/200612:55:05 Fiscal Period: 9 / 06 Budget Report Page - 3 Level Of Rollup 7 2003 2004 2005 9/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6350 INSURANCE 11,427 11,681 5,018 5,945 25,000 7,000 7,000 7,000 6360 UTILITY SERVICE 14,400 8,000 8,000 8,000 6362 ELECTRIC 953 6364 WATER 83 6365 GAS 2,044 6366 SEWER 3,573 23,251 37,459 46,000 46,000 46,000 6368 STORM 208 6369 CURRENT USE CHARGES 1,259,960 1,439,160 1,572,940 1,325,904 1,768,000 1,980,000 1,980,000 1,980,000 6360 UTILITY SERVICE 1,259,960 1,442,733 1,596,191 1,366,651 1,782,400 2,034,000 2,034,000 2,034,000 6400 RENTALS 6420 EQUIPMENT RENT 3,000 3,000 3,000 3,000 6425 EQUIPMENT RENT (IS FUND) 22,476 27,204 6430 BUILDING RENT (IS FUND) 7,245 9,950 12,000 12,000 12,000 6400 RENTALS 22,476 27,204 7,245 12,950 15,000 15,000 15,000 6470 DUESITRAININGITRAVEL 6472 CONFERENCE/SCHOOLlTRAINING 1,200 1,200 1,548 2,098 3,000 5,000 5,000 5,000 6470 DUESITRAININGfTRAVEL 1,200 1,200 1,548 2,098 3,000 5,000 5,000 5,000 6498 EXPENSE CHARGED BACK 20,000 20,800 9,000 20,800 6200 SUPPLIES AND SERVICES 1,389,680 1,504,002 1,708,933 1,649,714 1,973,400 2,326,800 2,326,800 2,326,800 6500 DEPRECIATION 6501 DEPRECIATION EXPENSE 6502 DEPRECIATION EXPENSE 406,222 461,930 559,332 500,000 700,000 700,000 700,000 6501 DEPRECIATION EXPENSE 406,222 461,930 559,332 500,000 700,000 700,000 700,000 6500 DEPRECIATION 406,222 461,930 559,332 500,000 700,000 700,000 700,000 6600 MISCELLANEOUS 6610 AWARDS & DAMAGES 10,750 6600 MISCELLANEOUS 10,750 6700 CAPITAL OUTLAY 6720 ROW 50,000 6740 EQUIPMENT 138,000 138,000 138,000 6760 IMPROVEMENTS 325,006 6700 CAPITAL OUTLAY 375,006 138,000 138,000 138,000 . . . R5509BUD LOGIS001 CITY OF SHAKOPEE 10/18/200612:55:05 Fiscal Period: 9 / 06 Budget Report Page - 4 Level Of Rollup 7 2003 2004 2005 9/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6800 DEBT SERVICE 6840 DEBT SERVICE INTEREST 6000 EXPENDITURES 1,835,242 2,009,466 2,349,048 2,093,554 2,537,810 3,304,560 3,294,660 3,294,660 8005 TOTAL TRANSFERS IN 8010 OPERATING TRANSFERS IN 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 8053 TRANSFERS OUT 159,694 18,400 18,400 18,400 8056 OPERATING TRANSFER/CAPITAL FD 65,356 1,427 141,231 8052 TRANSFERS OUT 225,049 1,427 141,231 18,400 18,400 18,400 8050 TOTAL TRANSFERS OUT 225,049 1,427 141,231 18,400 18,400 18,400 8100 GAIN/LOSS ON DISPOSAL OF ASSET 8101 PROCEEDS FROM SALE (GAIN/LOSS) 4000 REVENUES AND EXPENDITURES 3,221,365- 4,480,599- 3,109,191- 14,504- 1,210,190- 134,960 125,060 125,060 07100 SEWER FUND 3,221,365- 4,480,599- 3,109,191- 14,504- 1,210,190- 134,960 125,060 125,060 . . . STORM DRAINAGE FUND 2007 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 including GIS. Supplies and Services: Materials for maintaining/repairing storm sewer facilities, GIS software and hardware, motor fuels, concrete saw. Professional Services: Engineering consultant to update storm water plans, storm water model, review of storm water utility policy and procedures, Gopher State One Call. Rentals: Building Rental ($12,000) and equipment rental (Track Hoe $5,000). Utility Service: ($12,800) . Capital Equipment: Large Tractor ($85,000) . Capital Improvements: Per CIP. Purchase of Right of Way Pond: $550,000 Depreciation: Includes equipment and infrastructure. Storm Drainage Fund Projected Cash Levels 2007 -2011 Capital Improvement Program City of Shakopee, Minnesota TRUNK: 2006 2007 2008 2009 2010 2011 Cash Balance January 1 $ 4,508,508 $ 4,481,508 $ 3,709,008 $ 3,459,008 $ 3,594,008 $ 3,649,008 Revenue - Trunk Charges 600,000 300,000 300,000 300,000 400,000 400,000 Expenditures per List-Storm-T (627,000) (1,072,500) (550,000) (165,000) (345,000) (81,000) Excess (Deficiency) (27,000) (772,500) (250,000) 135,000 55,000 319,000 Balance 12/31 4,481,508 3,709,008 3,459,008 3,594,008 3,649,008 3,968,008 BASE: Cash Balance January 1 5,699,978 5,993,358 6,194,248 5,874,411 6,022,347 6,338,950 Revenue - User Fees 1,198,000 1,032,000 1,062,960 1,094,849 1,138,643 1,184,188 Revenue - Donations - - - - - - Revenue - Interest 135,260 179,260 148,360 138,360 143,760 145,960 Operation Expenses (447,880) (582,870) (641,157) (705,273) (775,800) (853,380) Capital Equipment - (85,000) (160,000) (55,000) ( 165,000) AP changes Debt Service (149,000) Expenditures per List (443,000) (342,500) (730,000) (325,000) (190,000) (700,000) Expenditures per List - Donation Excess (Deficiency) 293,380 200,890 (319,837) 147,936 316,603 (388,232) Balance 12/31 5,993,358 6,194,248 5,874,411 6,022,347 6,338,950 5,950,718 Total Balance 12/31 $ 10,474,866 $ 9,903,256 $ 9,333,419 $ 9,616,355 $ 9,987,958 $ 9,918,726 Accumulated Depreciation $ 6,500,000 $ 7,150,000 $ 7,850,000 161% 139% 119% R5509BUD LOGIS001 CITY OF SHAKOPEE 10/18/200612:35:26 Fiscal Period: 9 / 06 Budget Report Page - 1 Level Of Rollup 7 2003 2004 2005 9/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 07300 STORM FUND 4000 REVENUES AND EXPENDITURES 4001 REVENUES 4005 TAXES 4010 PROPERTY TAX 4011 CURRENT PROPERTY TAX 156,309- 4010 PROPERTY TAX 156,309- 4005 TAXES 156,309- 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- 4720 SEWER CHARGES 4740 STORM DRAINAGE 4745 STORM CHARGES 926,774- 1,134,073- 1,097,835- 674,812- 1,198,000- 1,032,000- 1,032,000- 1,032,000- 4746 TRUNK CHARGE - STORM 844,153- 466,759- 793,401- 325,953- 600,000- 300,000- 300,000- 300,000- 4740 STORM DRAINAGE 1,770,927- 1,600,832- 1,891,235- 1,000,765- 1,798,000- 1,332,000- 1,332,000- 1,332,000- 4500 CHARGES FOR SERVICE 1,770,927- 1,600,832- 1,891,430- 1,000,765- 1,798,000- 1,332,000- 1,332,000- 1,332,000- 4830 MISCELLANEOUS 4832 INVESTMENT INCOME 4833 INTEREST 249,923- 235,624- 237,145- 137,939- 135,000- 179,260- 179,260- 179,260- 4832 INVESTMENT INCOME 249,923- 235,624- 237,145- 137,939- 135,000- 179,260- 179,260- 179,260- 4850 MISCELLANEOUS 0- 46,000c 0- 4850 MISCELLANEOUS 46,000- 4830 MISCELLANEOUS 249,923- 235,624- 283,145- 137,939- 135,000- 179,260- 179,260- 179,260- 4960 PROCEEDS FROM DEBT ISSUED . . . R5509BUD LOGIS001 CITY OF SHAKOPEE 10/18/200612:35:26 Fiscal Period: 9 1 06 Budget Report Page - 2 Level Of Rollup 7 2003 2004 2005 9/30/2006 2006 2007 2007 2007 Actual Actual Actual YTO Final Requested Approved Final Object Code 1 Description Amount Amount Amount Actual Budget Budget Budget Budget 4970 CAPITAL CONTRIBUTIONS 4971 CAPITAL CONTRIBUTIONS 2,654,574- 2,812,721- 3,587,434- 4970 CAPITAL CONTRIBUTIONS 2,654,574- 2,812,721- 3,587,434- 4001 REVENUES 4,675,423- 4,805,485- 5,762,009- 1,138,704- 1,933,000- 1,511,260- 1,511,260- 1,511,260- 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 110,431 99,014 115,364 74,108 120,000 120,390 111,700 111,700 6005 OVERTIME-FT 4,190 1,854 3,268 1,467 6,000 6,000 6,000 6,000 225 -- 6010 PREMIUM PAY 6015 WAGES - PART TIMEITEMP 5,301 7,762 6,262 8,070 6,500 6,500 6,500 6,500 6002 WAGES 119,922 108,631 124,893 83,870 132,500 132,890 124,200 124,200 6100 BENEFITS 6122 PERA 6,371 5,692 6,557 4,545 6,700 8,310 7,760 7,760 6124 FICA 8,523 7,675 8,917 5,969 9,180 10,170 9,500 9,500 6135 HEALTH 16,523 16,993 17,405 8,895 19,000 19,000 19,000 19,000 6139. POST EMPLOYMENT HEALTH PLAN 810 783 728 400 800 800 800 800 6140 L1FEIL TO 542 496 530 303 600 600 600 600 6145 DENTAL 849 776 824 490 800 800 800 800 6170 WORKERS COMPENSATION 2,363 3,797 3,786 6,150 2,500 7,000 7,000 7,000 6100 BENEFITS 35,982 36,212 38,747 26,752 39,580 46,680 45,460 45,460 6001 WAGES & BENEFITS 155,904 144,843 163,640 110,622 172,080 179,570 169,660 169,660 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 5,876 11,933 8,178 20,110 10,000 18,000 18,000 18,000 6210 OFFICE SUPPLIES 156 6215 MATERIALS 3,343 1,547 13,667 1,089 15,000 12,000 12,000 12,000 6222 MOTOR FUELS & LUBRICANTS 1,915 2,931 6,195 5,568 7,000 8,500 8,500 8,500 6240 EQUIPMENT MAINTENANCE 12,486 18,065 14,834 16,638 20,000 30,000 30,000 30,000 6201 SUPPLIES & SERVICES 23,619 34,476 42,873 43,561 52,000 68,500 68,500 68,500 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 232 27 662 90 5,000 5,000 5,000 5,000 6312 ENGINEERING CONSULTNTS 24,035 31,064 65,273 110,554 50,000 75,000 75,000 75,000 6316 EQUIPMENT MAINTENANCE 69 34 . . . R5509BUD LOGIS001 CITY OF SHAKOPEE 10/18/200612:35:26 Fiscal Period: 9 / 06 Budget Report Page - 3 Level Of Rollup 7 2003 2004 2005 9/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6327 OTHER PROF SERVICES 13,991 42,043 37,192 7,353 96,000 40,000 40,000 40,000 6300 PROFESSIONAL SERVICES 38.258 73,134 103,195 118,031 151,000 120,000 120,000 120,000 6330 COMMUNICATIONS 6332 POSTAGE 76 750 1,000 1,000 1,000 6334 TELEPHONE 100 382 1,238 500 1,000 1,000 1,000 6336 PRINTING/PUBLISHING 185 534 2,651 1,000 2,000 2,000 2,000 6330 COMMUNICATIONS 76 285 915 3,889 2,250 4,000 4,000 4,000 6350 INSURANCE 6352 LIABILITY 6,335 2,030 1,797 4,482 8,200 6,000 6,000 6,000 6354 PROPERTY 1,048 1,000 806 692 6356 AUTO 438 434 1,283 834 2,000 2,000 2,000 6350 INSURANCE 7,821 3,464 3,886 6,008 8,200 8,000 8,000 8,000 6360 UTILITY SERVICE 488 433 14,400 12,800 12,800 12,800 6362 ELECTRIC 309 719 1,462 6364 WATER 83 6365 GAS 2,044 6366 SEWER 78 6367 REFUSE 210 162 6368 STORM 208 6360 UTILITY SERVICE 698 904 719 3,875 14,400 12,800 12,800 12,800 6400 RENTALS 6420 EQUIPMENT RENT 12,327 23,077 21,697 5,516 20,000 5,000 5,000 5,000 6425 EQUIPMENT RENT (IS FUND) 22,332 40,248 6430 BUILDING RENT (IS FUND) 7,245 9,950 12,000 12,000 12,000 6400 RENTALS 34,659 63,325 21,697 12,761 29,950 17,000 17,000 17,000 6470 DUESITRAININGITRAVEL 6472 CONFERENCE/SCHOOLlTRAINING 3,000 3,000 3,000 3,000 6480 DUES 20 6470 DUESITRAININGITRAVEL 20 3,000 3,000 3,000 3,000 6498 EXPENSE CHARGED BACK 24,000 28,200 18,000 12,000 6200 SUPPLIES AND SERVICES 129,131 203,788 191,286 188,146 272,800 233,300 233,300 233,300 6500 DEPRECIATION 6501 DEPRECIATION EXPENSE . . . R5509BUD LOGIS001 CITY OF SHAKOPEE 10/18/200612:35:26 Fiscal Period: 9 / 06 Budget Report Page - 4 Level Of Rollup 7 2003 2004 2005 9/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6502 DEPRECIATION EXPENSE 493,453 578,131 636,071 650,000 750,000 750,000 750,000 6501 DEPRECIATION EXPENSE 493,453 578,131 636,071 650,000 750,000 750,000 750,000 6500 DEPRECIATION 493,453 578,131 636,071 650,000 750,000 750,000 750,000 6600 MISCELLANEOUS 6620 PROPERTY TAX/SPECIAL ASSESS 335 325 302 285 3,000 6600 . MISCELLANEOUS 335 325 302 285 3,000 6700 CAPITAL OUTLAY 6740 EQUIPMENT 85,000 85,000 85,000 6760 IMPROVEMENTS 304,520 550,000 550,000 550,000 6700 CAPITAL OUTLAY 304,520 635,000 635,000 635,000 6800 DEBT SERVICE 6802 DEBT SERVICE PRINCIPAL 6810 DEBT SERVICE PRINCIPAL 145,000 6802 DEBT SERVICE PRINCIPAL 145,000 6840 DEBT SERVICE INTEREST 6850 DEBT SERVICE INTEREST 20,519 14,380 7,801 605 4,000 6860 FISCAL AGENT FEES 750 375 750 375 6840 DEBT SERVICE INTEREST 21,269 14,755 8,551 980 4,000 6800 DEBT SERVICE 21,269 14,755 8,551 145,980 4,000 6000 EXPENDITURES 800,092 941,841 999,849 749,554 1,101,880 1,797,870 1,787,960 1,787,960 8005 TOTAL TRANSFERS IN 8010 OPERATING TRANSFERS IN 159,694- 8010 OPERATING TRANSFERS IN 159,694- 8005 TOTAL TRANSFERS IN 159,694- 8050 TOTAL TRANSFERS OUT 8052 TRANSFERS OUT 8053 TRANSFERS OUT 156,309 48,040 48,040 48,040 8056 OPERATING TRANSFER/CAPITAL FD 200,000 672,755 644 63,712 8052 TRANSFERS OUT 200,000 829,064 644 63,712 48,040 48,040 48,040 8050 TOTAL TRANSFERS OUT 200,000 829,064 644 63,712 48,040 48,040 48,040 . . . R5509BUD LOGIS001 CITY OF SHAKOPEE 10/18/200612:35:26 Fiscal Period: 9 1 06 Budget Report Page - 5 Level Of Rollup 7 2003 2004 2005 9/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code 1 Description Amount Amount Amount Actual Budget Budget Budget Budget 8100 GAINILOSS ON DISPOSAL OF ASSET 8101 PROCEEDS FROM SALE (GAIN/LOSS) 4000 REVENUES AND EXPENDITURES 3,675,331- 3,194,274- 4,761,516- 325,438- 831,120- 334,650 324,740 324,740 07300 STORM FUND 3,675,331- 3,194,274- 4,761,516- 325,438- 831,120- 334,650 324,740 324,740 . . .