Loading...
HomeMy WebLinkAbout2. 2007 Budget and Levy Presentationr AGENDA ITEM: 2007 Budget and Levy Presentation AGENDA SECTION: Public Hearing PREPARED BY: Jeff May, Finance Director AGENDA NO. 2. ATTACHMENTS: Draft 2007 Budget Document, PowerPoint Presentation, Draft Resolutions APPROVED BY: ,r RECOMMENDED ACTION: If the Council is comfortable that the public has bin given ample opportunity to speak, the motion would be to close the public hearing. If Council feels additional testimony is required, the motion would be to continue the public hearing to Monday, December 11 2006, at 6 p m ROSEMOUNT CITY COUNCIL City Council Meeting Date: December 4, 2006 EXECUTIVE SUMMARY ISSUE Comply with the Truth -In- Taxation requirements that call for the City to hold a special budget hearing for the pubhc that allows them to speak on the coming year's budgets and levies BACKGROUND Attached for your consideration is the 2007 budget, containing all of the budget documents and resolutions necessary for closing out the 2007 budget process Tonight the budget will be presented and the public will be allowed to give their input If necessary, a continuation hearing has been scheduled for December 11 and you will have to formally call for that continuation hearing prior to the completion of this evening's meeting. If you are comfortable that the public has been given ample opportunity to speak on the budget, you will close the public hearing tonight and no formal action will be taken. Then on Tuesday, December 5` at the regular Council meeting, you will pass the appropriate resolutions closing out your responsibihues in the budget process. Staff will then fill out the necessary forms and documents and file the necessary information with the County and the State prior to the deadlines that these agencies have set. If you do not close the pubhc hearing this evening, and the continuation hearing is held on December 11 you will have to pass the resolutions for the budget on December 19` which is the last meeting that the City has before we have to certify our levy to the County. This is a requirement of Truth -In- Taxation that states that budgets and levies must be approved at a meeting subsequent to the budget hearing or the continuation hearing. I will give the formal budget presentation and be available to answer any questions that you may have. The Council is asked to bang their three ring binders from the 2006 budget books to the meeting to be recycled for the 2007 books. The final 2007 budgets will be returned to you m the three ring binders when completed for your use. Also, if you would like your 2006 pages saved let me know and I will make sure that they are returned to you. SUMMARY Recommend one of the above motions dependmg on the outcome of tonight's discussion. d 2007 CITY BUDGET REPORT 4ROSEMOUNT MINNESOTA December 4, 2006 Departments FUNDING REQUIREMENTS USES (INCLUDING FIRE STATION LEVY) 2006 2007 Adopted Proposed +1- Budget Budget Difference Percentage Council Budget $167,900 $297,100 $129,200 76 95% Admrmstration Budget 515,600 524,200 8,600 1 67% Elections Budget 38,900 61,000 22,100 56 81% Finance Budget 308,900 333,200 24,300 7 87% General Government Budget 361,700 378,100 16,400 4 53% Community Development Budget 886,000 893,300 7,300 0 82% Police Budget 2,339,700 2,623,400 283,700 12 13% Fire Budget 283,400 291,800 8,400 2 96% Public Works Operating Budgets Government Buildings Budget 390,50D 413,400 22,900 5 86% Fleet Maintenance Budget 478,000 527,100 49,100 10 27% Street Maintenance Budget 1,153,700 1,162,900 9,200 0 80% Parks Maintenance Budget 532,800 559,700 26,90D 5 05% Park Rec Budget General Operating 967,700 1,013,400 45,700 4 72% Park Rec Budget- Special Programs 91,500 102,500 11,000 12 02% Total Operating Budgets General Fund $8,516,300 59,181,100 $664,800 7.81% Building CIP Requirements 24,000 24,000 0 0 00% Street CIP Requirements 1,100,000 1,050,000 (54000) -4 55% Equipment CIP Requirements 250,900 303,000 52,100 20 77% Insurance Budget Requirements 264000 260,000 0 0 DO% Port Authority Operating Levy 60,000 0 (60,000) -100 00% Bonded Indebtedness 1,599,360 1,545,364 (53,996) -3 38% Bonded Indebtedness Fire Station Levy 154,308 142,527 (11,781) -7 63% Armory Anticipatory Levy (Value 7/18/06) 248,422 269,428 21,006 8 46% *$95,000 ($2,185,821,500 x 00798 Water Enterprise Fund 1,258,400 1,858,200 599,800 47 66% Sewer Enterprise Fund 1,432,000 1,483,600 51,600 3 60% Storm Water Enterprise Fund 748 000 783,200 35,200 4 71% Arena Enterpnse Fund 421,200 441,300 20,100 4 77% Total Funding Requirements $16,072,890 $17,341,719 $1,268,829 7.89% NOTE Special Levies Include (1)Sonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies December 4, 2006 Types FUNDING REQUIREMENTS SOURCES (INCLUDING FIRE STATION LEVY) 2006 2007 Adopted Proposed Budget Budget Difference Percentage Internal Revenue Generated Licenses and Permits 859,700 651,100 (208,600) -24 26% Intergovernmental 525,000 556,000 31,000 5 90% Charges for Services 1,160,700 911,900 (248,800) -21 44% Fines Forfeits 90,000 90,000 0 0 00% Recreational Fees 236,200 228,000 (8,200) -3 47% Miscellaneous Revenues 152,000 182,500 30,500 20 07% Transfers In 3,500 3,500 0 0 00% Enterprise Revenues 3,859,600 4,566,300 706,700 18 31% Total Internal Revenues 6,886,700 7,189,300 302,600 4 39% MVHC Cuts Made Later To Include in Levy 35Q330 350,330 Levy Sources Special Levies 2,002,090 1,957,319 (44,771) -2 24% General Levy 7,534,430 8,545,430 1,011,000 13 42% Total Levy $9,536,520 510,502,749 $966,229 10 13% Loss of MVHC from State Funding $350,330 5350,330 $0 nla Total Revenue Sources $16,072,890 $17,341,719 $1,268,829 7 89% NOTE Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies 2006 GENERAL PROPERTY TAX LEVY PAYABLE 2007 GENERAL LEVY GENERAL FUND $6,908,430 BUILDING CIP FUND $24,000 STREET CIP FUND $1,050,000 EQUIPMENT CIP FUND $303,000 INSURANCE FUND $260,000 PORT AUTHORITY OPERATING LEVY TOTAL GENERAL LEVY $8,545,430 BONDED INDEBTEDNESS G 0 MUNICIPAL BUILDING REFUNDING BONDS 1998A (ICE ARENA) (Authonzed $258,957) $258,957 G 0 IMPROVEMENT BONDS 1999B (Authorized $19,533) $19,533 G 0 IMPROVEMENT BONDS 2001A (Authorized $119,604) G 0 PUBLIC FACILITY BONDS 2001C (Port Authority) (Authorized $168,504) $168,504 G 0 COMMUNITY CENTER REFUNDING BONDS 2001E (Authorized $94,704) $94,704 G 0 IMPROVEMENT BONDS 2002A (Authorized $10,772) $10,772 G 0 PORT AUTHORITY BONDS 2002C (Authorized $258,650) $258,650 G 0 IMPROVEMENT BONDS 2003A (Authorized $86,354) (City Assumed Special Assessments) $86,354 G 0 CAPITAL IMPROVEMENT PLAN (CIP) BONDS 2005A (Authorized $210,737) $210,737 G 0 EQUIPMENT CERTIFICATES 2005B (Authorized $349,198) $349,198 G 0. EQUIPMENT CERTIFICATES 2006A (Authorized $87,955) $87,955 G 0 IMPROVEMENT BONDS 2006B (Authorized $75,081) TOTAL BONDED INDEBTEDNESS $1,545,364 MARKET VALUE BASED REFERENDUM 1995 FIRE STATION LEVY G 0 FIRE STATION REFUNDING BONDS, 2005D (Authorized $142,527) TOTAL FIRE STATION LEVY PRINCIPAL AND INTEREST ON ARMORY BONDS ARMORY ANTICIPATORY LEVIES ($95,000 ($2,185,821,500 x 00798°/x)) (As of 7/18/06) TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS GRAND TOTAL 2006 PROPERTY TAX LEVY Last Updated 11/8/06 $142,527 $142,527 $269,428 $269,428 $10,502,749 O O •0A C A D c O o Z cn G) m z m o 00 c W A G) W O m 7 is O m n W m in n m i" co co Al z m G) 0 Z rn o m z m 1 e y m z 1 z D 1 F 0 z m Z 1 m O N m D c m y Z �7 o m 00 C m oz-1 o m 73 O m D D m m o m Z D o Z —1 m o m z 73 Nm Zm1 N 0 73 co 71 m N J m m C Z 0 I N O O r m O C 0 Z v-I Z Z 73 0 C mg m zm co 1 0000 N) O N O Cn N) O1 V N J -4 CT O A CO O CO O) N J co op co co 0 0 0 0 O N CJ Cl 03 U' 0 0 0 W -4 N V O O 0 CO A 0 0 0 0 0 0 O O N N A cm Cn O co 6) -4 N 0 0)) A 1 01 6) 1 J 1 0 0 0 0 0 O N N A N Cn J 6) 0 03 N CT CJ J CO 01 01 CT 0) CO A CO CT 0 0000 O O N N A CA CT CJ CT N CJ 0 O) 1 Cn 0 CT 0 N 0) CO J CO A N 0 D wm r m O 7) e' m O 0 O g 0 D g O cn CO m o D z O Z1 _i m N n Z O 0) D 3 N 0 D 0) CO r in 15 Total Funding Requirements Less: Internal Revenues Less: Market Value Based Levy Fire Station (See Below) Equals' Revenues Needed Add Back in State MVHC Cuts to Reflect Actual Levy Levy Certified by City to County Auditor County Auditor Adjustments (All Subtractions)' Fiscal Disparities Distributuion Levy (Metro Area) Spread Levy Used to Compute Local Tax Rate Increase from Previous Year in Spread Levy Market Value Based Referendum Levy Fire Station Last Updated 1118106 SPREAD LEVY COMPUTATIONAL WORKSHEET (INCLUDING FIRE STATION LEVY) (Proposed) 2004 2005 2006 2007 14,088,246 6,165,131 152,193 14,809,814 6,258,800 153,426 7,770,922 8,397,588 9,031,882 10,009,892 350,330 nla 350,330 350,330 8,121,252 8,397,568 9,382,212 10,360,222 844,509 804,414 4 35% 16,072,890 6,886,700 154,308 17,341,719 (4) 7,189,300 142,527 (3) 770,288 870,514 (2) 7,276,743 (1) 7,593,174 (1) 8,611,924 (1) 9,489,708 1342% 10.19% 152,193 153,426 154,308 142,527 (3) (1) Actual Spread Levy Based on Numbers from Dakota County (2) 2007 Number Provided by Dakota County as of 8/09106 (3) Market Value Based Levy for Fire Station Based on $142,527 Levy Spread to Taxable Market Value on 12/31/06 Last Update from Dakota County 7/18/06 Shows the Levy of $142,5271$2,185,821,500 0665 per $1,000 as our Estimate (4) In 2004 Started Including the Water, Sewer, Storm Water Arena Enterprise Funds in These Figures g P F en r m 2 0 a Om rail ma So v c z. a 1 I; EA N N EA W 0 (n n rn�nc) A% A2 A.< O (D �c.< O O 0 N m mm m0 m m 0�3 Fri o e p 3 w -1 00)2 n 0 a m a 3 x (n N C C C i C S -9 0 3 ,2 3 a 3 m fl ID O Cy CDC f O- p O d y G N 3 N O d' U X N N n y N N (m (D O mm O D m N 3 3 m 3 0) CO 0 o D m 0 0 0 CD 0 N m O di 0) 0) W N O N !A 0 EA a N co a (1 CO 01 EA N EA co W 01 m (0 EA -4 N W A ((11 69 fA fA A W [O W A W A fA fA W <A 01 u -1. .s 0) EA 0) W m W (0 0) W (0 0 O fAE >0100 N ((0 J 01J 0101 4 W W 0 0) i W W J A 0) 0 0) A -t6969 69 O W W W EA M M W a A W MCP-,0 N c N W ,,,Emil D ry D 0) O 0)0 m �"'I o O O I' E m a> D x 0 -9 p fA C 0D A U M" o a m m 0rna 2-1 o Q OD N y r -10-0 p C g;0,--la g m N No E CD W30 3 0 p 0 O Z 1 p_ E' o. x.770 o 0 m 91 D �N 005' c m <om00 00 W g O (D S M to y sz T z 0_ O N a J u) <5 N n 0 2 2 00 _5 N N m N 5 A N fA 0 0) 0 (n c O0 (D O F (D p (D y 9. 4t O m o m O `Dm v s o_ aµ a 3 X pa om m 3, 3 3 o o r w r w r a O_ m X N_ `.G m 3 N D 91 N 3 3 aX y 0) N N 0 co 0 O (nw a a T d 3 3 m N D) (n Oa o o N o O j co N EA CO EA N CO CO 69 -94 N (O O a EA CO EA E; 0 N J (D 0 A N EA W N CO J 0) to CO (0 0) v EA -a 01 D CO O EA W A J EA (D N CO CO N EA 69 m EA R (D 0 01 0 (D EA EA EA EA O 0 (T Co 01 CO N 0) W EA EA EA EA N 0 O J O A O O CO J OD T 413 69 EA OA) EA fl EA EA 01 N W CO D] J EA 69 EA EA N (D 0 -4 T N CO 0 E 0 <d° n EA m T y co D co a cm N O 7 0 —1 3 O K V 0 O O N D d CO m a T XI 69 E N T co D m a 0 N m 0 -0 O m U m a f7 O -G N O �D N y r <m T o C m x a m A N T O O O �p6 m Z W 7 CD a d o F 7, 0 0 N cad °s cm <ax cn c 'a (D S CO N J z 2- (D Z O 5 a x O n rrl D N N M N 7 (D cp 7 ID co CD CO 0 Co 0 N) ND xp CI °an 0 al MI 2 y 9 co 93 fa) 5A0 Cu Li o 5 CO D ID tn SS f I 69 0 CS e R -1 I= =a CA la el CO Ea 0 Co -Ca 69 69 01 0.4 63 N3 C11 a A Ca 69 69 69 a 63 01 0 CD <J) -0 0 0 g t ®o \f CD a _e) a }k %K 0 ca e o `m o e q cri <3 0 0 9! It December 4, 2006 Departments FUNDING REQUIREMENTS USES (INCLUDING FIRE STATION LEVY) City Taxes City Taxes City Taxes $250,000 $250,000 $250,000 2007 Percentage Home Home Home Proposed Of Total Yearly Monthly Daily Budget Funding $998.00 $83 17 $2 73 Council Budget $297,100 2 35% $23 47 $1 98 $0 06 Administration Budget $524,200 4 15% $41 41 $3 45 $0 11 Elections Budget $61,000 0 48% $4 82 $0 40 $0 01 Finance Budget $333.200 2 64% $26 32 $2 19 $0 07 General Government Budget $376,100 2 99% $29 87 $2 49 $0 GB Community Development Budget $893,300 7 07% $70 57 $5 8B $0 19 Police Budget $2,623,400 20 77% $207 25 $17 27 $0 57 Fire Budget $291,800 2 31% $23 05 $1 92 $0 06 Public Works Operating Budgets Government Buildings Budget $413,400 3 27% $32 66 $2 72 $0 09 Fleet Maintenance Budget $527,100 4 17% $41 64 $3 47 $0 11 Street Maintenance Budget $1,162,900 9 21% $91 87 $7 66 $0 25 Parks Maintenance Budget $559,700 4 43% $44 22 $3 68 $0 12 Park Rec Budget- General Operating $1,013,400 8 02% $80.06 $6 67 $0 22 Park Rec Budget Special Programs $102,500 0 81 $8 10 $0 67 SO 02 Total Operating Budgets General Fund $9,181,100 72.68% $725 31 $60 44 $1 99 Building CIP Requirements $24,000 0 19% 51 90 $0 16 $0 01 Street CIP Requirements $1,050.000 8 31% $82 95 $6 91 $0 23 Equipment CIP Requirements $303,000 2 40% $23 94 $1 99 $0 07 Insurance Budget Requirements $260,000 2 06% $20 54 $1.71 $0 06 Port Authority Authority Operating Levy Bonded Indebtedness $1,545,364 12 $12208 $1017 $033 Bonded Indebtedness Fire Station Levy $142,527 n/a $17 OD $1 42 $0 05 Armory Anticipatory Levy (Value 7/18/06) $269,428 2 13% $21 28 $1 77 $0 06 "$95,000 +($2,185,821,500 x 00798%)** Total Funding Requirements $12,775,419 100 00% 51,015 00 $84 58 $2.78 NOTE Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies Fire Station Levy is a Market Value Based Levy That is why that figure is an addition to the dollar figure given in the Yearly, Monthly Daily figures above 1)- December 4, 2006 TYPES TOTAL GENERAL FUND REVENUES GENERAL FUND REVENUES 2006 ADOPTED 2007 PROPOSED BUDGET BUDGET DIFFERENCE PERCENTAGE GENERAL FUND REVENUES General Property Taxes $5,489,200 $6,558,100 1,068,900 1947% Licenses and Permits 859,700 651,100 (208,600) -24 26% Intergovernmental 525,000 556,000 31,000 5 90% Charges for Services 1,160,700 911,900 (248,800) -21 44% Fines and Forfeits 90,000 90,000 0 0 00% Recreational Fees 236,200 228,000 (8,200) -3 47% Miscellaneous Revenues 152,000 182,500 30,500 20 07% Transfers In 3,500 3,500 0 0 00% $8,516,300 $9,181,100 $664,800 7 81% Page One December 4, 2006 Account 101 31010 00 101 31040 00 101 32110 00 101 32160 00 101 32161 00 101 32210 00 101 32212 00 101 32220 00 101 32221 00 101 32230 00 101 32240 00 101 32250 00 101 32255 00 101 32260 00 101 32290 00 101 31010 00 101 31010 01 101 31020 00 101 31030 00 101 31710 00 101 31810 00 101 31811 00 101 31920 00 101 33100 00 101 33416 00 101 33416 01 101 3341602 101 3341800 101 33423 00 101 3342500 101 33620 00 101 33630 00 101 3363000 2007 BUDGET WORKSHEETS GENERAL FUND REVENUES Description Current Ad Valorem Taxes Fiscal Disparities Total Taxes (Tax) Alcoholic Beverage Licenses (L) Licenses to do Business (L) Licenses to do Bus Kennels (L) Building Permit Revenue (L) Mineral Extraction Permit (L) Electrical Permit Revenue (L) Admen Fee Electrical Permits (L) Plumbing Permit Revenue (L) Animal Licenses (L) Sewer Permit Revenue (L) County Recording Fee City's (L) HVAC Permit Revenue (L) Other Non -Bus Lie Permits (L) Total Licenses Permits (L) Current Ad Valorem Taxes (I) MSABC Armory Payments Delinquent Ad Valorem Taxes (I) Mobile Home Taxes (I) Gravel Taxes (0 Franchise Taxes Regular Fees (1) Franchise Taxes PEG Fees (I) Forfeited Tax Sate Apportionment (I) Federal Grants Aids (I) Police Training Reimbursement (I) Post Board Training Reimb State Aid (Tied to PERA) MSA for Streets Maintenance (I) Ag Preserves Credit (I) Other State Grants 8 Aids Other County Grants Ards (I) Police Services Levy -ISD #196 (I) DARE /Liaison Funding Total Intergovernmental (I) 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $3,989,670 $3,949,105 $3,872,826 $5 069,242 771 998 844,509 804,414 770,288 4,761,668 4793,614 4,677,240 5,839,530 64,117 99,711 10,768 10,792 14,055 9,594 107,540 121,479 9,747 10,570 2,183 0 0 0 102,805 112,834 79,338 8,675 29 690 131,522 12,506 0 60,000 122,641 (350,330) 5,489,200 915,589 1,295,164 1,194,106 859,700 651,100 91,000 91,000 91,000 91,000 60,000 10,000 10,000 120,000 10,000 0 0 PAGE TOTALS 6,190,903 6,650,756 6,515,811 6,873,900 91,000 513,646 561,978 644,465 525,000 556,000 From County 770,288 From County $6,138,142 6,908,430 Total Property Tax Levy for Fund 101 (350,330) State Cuts in MVHC Permanent 6,558,100 Actual Property Taxes to Receive 19,160 27,837 32,583 25,000 30,000 1,400 11,130 7,360 5,000 7,000 Garbage Haulers, Ped Licenses etc 0 0 0 0 0 752,405 1,022,025 908,188 675,000 500,000 3,445 9,155 2,695 5,000 4,000 17,004 24,149 25,628 17,000 15,000 3,369 13,316 12,616 12,000 12,000 50,252 82,981 86,502 50,000 34,000 2,450 1,690 2,214 2,500 2,000 18,847 25,583 22,699 17,000 12,000 250 120 120 200 100 46,661 76,606 91,801 50,000 34,000 345 770 1700 1,000 1600 Alarm Permits 8 Fireworks Permits 91,000 Included in Debt Levy Figure 60,000 10,000 15,000 125,000 12,000 0 0 127,000 From County From County From County From Cable Company From Cable Company From County From State 7,000 7,000 110,000 120,000 29,445 28,300 26,715 29,000 28,000 From State 2,538 0 1,197 0 0 From State 16,353 16,952 17,668 13600 13,000 From State -PERA Aid Safe Sober 17,328 13,810 15,000 15,000 15,000 Dakota County Recycling Funds 45,767 46,936 48,512 50,000 82,000 82,000 From ISD #196 7,765,200 4� Page Two December 4, 2006 2007 BUDGET WORKSHEETS GENERAL FUND REVENUES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget 101 34103 00 Zoning Subdivision Fees (C) 33,560 70,824 72,304 50,000 50 000 101 34104 00 Plan Checking Fees (C) 413,876 444,950 405,606 368300 300,000 65% of Building Permit Fees 101 341 05 00 Sales of Maps Publications (C) 2,816 2,311 2,632 3,000 2500 Maps Spec Books 101 34106 00 Deputy Registrar Fees (C) 48,438 49,392 52,406 50,000 50 000 101 34107 00 Assessment Searches (C) 20 0 0 100 0 101 34106 00 Admin Fees Other Funds (C) 199,254 337,753 341,127 125,000 101 34108 01 App icable Funds Except Const 25,000 25.000 101 34108 02 Construction Funds 226000 100,000 101 34109 00 Other Charges for Service (C) 6,127 9,853 11,370 5000 5,000 101 34110 00 Service Chg on Returned Chks (C) 345 240 210 200 200 101 34112 00 Utility Permit Application Fee (C) 450 1,525 575 1,000 500 101 34150 00 User Fees SKB 0 98,092 255,923 300,000 250,000 SKB Fees from New Cells C 0 101 34151 00 User Fees/Host Agreements SKB 0 25,000 25,000 25000 25,000 Landscaping Agreement (Yr 4 of 10) 101 34160 00 National Guard Maint Fees (C) 45,508 46,362 46315 46,000 46,000 101 34160 00 Shared Space Rental Agreement 16,000 101 34160 00 Building Maintenance Contract 30,000 101 34201 00 Special Police Services (C) 23,171 22,962 18,285 24,000 20,000 Contractual OTT for Officers 101 34202 00 Fire Seances Burning Permits (C) 5,500 1,168 435 0 0 No Longer Charge for Permits 101 34203 00 Accident Reports (C) 1,019 778 266 500 500 101 34204 00 Day Care Inspection Fees (C) 490 250 658 200 200 101 34206 00 Other Police Services (C) 121 30 1645 0 0 101 34207 00 Other Fire Protection Services (C) 10,528 13,583 11,005 12,000 101 34207 01 U of M Fire Contract 5,500 5 500 101 34207 02 Coates Fire Contract 3,500 3 500 101 34207 03 Other Billed Fire Calls 3,000 3, 101 34301 00 Street, Sidewalk Curb Repairs (C) 0 10,973 0 D 0 101 34303 00 Mow Weeds (C) 191 3,844 1,815 0 0 101 34306 00 Other Highway Street Rev (C) 37,882 74,361 27,676 20,000 20,000 Street Light Bills Developers 101 34407 00 City Share of Metro SAC Chgs (C) 5,303 7,962 8,007 5,000 5,000 Total Charges for Services (C) 836,900 1,222,213 1,283,660 1,160,700 911,900 101 35101 00 Court Fines (F) 89,752 96,902 87,888 90,000 90,000 From County Total Fines Forfeits (F) 89,752 96,902 87,888 90,000 90,000 101 3472000 Park Reservations (R) 3,390 4,170 2,455 3,200 1,500 Loss of Church 101 34721 00 Softball Revenues (R) 55,296 59,246 62,931 57,000 60,000 101 34722 00 Volleyball Revenues (R) 1,460 1,445 1,120 1,500 1,500 101 3472400 Tennis Revenues (R) 1,211 1,283 1,659 1,300 1,300 101 34725 00 Tiny Tot Revenues (R) 21,551 20,029 20,630 21,000 21 000 101 34726 00 Rosettes Revenues (R) 1,447 1,463 748 1,000 1 200 101 34727 00 Field Trip Revenues (R) 2,692 8,725 10,777 3 4,000 101 34728 00 Broomball Revenues (R) 0 0 0 0 0 101 34729 00 Skating Lesson Revenues (R) 217 244 299 300 300 101 34730 00 Run `or the Gold Revenues (R) 2,960 3,250 3,636 3 000 3,000 101 34732 00 Adult Basketball Revenues (R) 1 935 1,700 1,326 1,900 1,900 101 34733 00 Other Programs Revenues (R) 8,719 10,631 14,310 6,000 8,000 101 34735 00 Camps Revenues (R) 3,888 9,442 13,314 4,000 4,000 101 34736 00 T -Ball Lessons (R) 3,654 4,266 4,675 5,000 4,300 101 34737 00 Leprechaun Days Revenues (R) 0 4,970 0 0 0 101 34790 00 Other Recreation Revenues (R) 6,351 0 0 0 0 101 38030 00 Banquet Room Fees (R) 58,641 56,244 58,281 58,000 58,000 101 38081 00 Auditorium Fees (R) 11,563 9,085 7 12 12,000 101 3806200 Gymnasium Fees (R) 20,321 20,890 24,363 21,000 21,000 101 38066 00 Classroom Fees (R) 30,037 21,691 9,351 26 000 16,000 Lcss of ECFE 101 36096 00 Liquor Provider Fees (R) 1 050 1,170 1,050 1,500 1,500 101 38097 00 A/V Rental Fees (R) 1,706 1,342 1,587 1,500 1,500 101 38154 00 Teen Night Revenues (R) 5,670 6,222 8,092 6,000 6,000 Total Recreation Fees (R) PAGE TOTALS 243 777 247,706 247,942 236,200 226,000 1,170,430 1,566,821 1,819,489 1,486,900 1,229,900 Comments 15 Page Three December4, 2006 Account* Descripton 101 36101 00 101 3610200 101 3621000 101 3621400 101 3621500 101 3622000 101 3623000 101 3626000 101 3626500 101 3809000 2007 BUDGET WORKSHEETS GENERAL FUND REVENUES Principal Special Assessments (M) Penalties Interest S/A (M) Interest Earnings Investments (M) Net Change in FV- Investments (M) Interest Earnings (M) Rents Royalties (M) Contribution/Donations (M) Other Revenue (M) Use of Reserve Funds (M) City Concessions (M) Total Misc Revenues (M) 101 39202 00 Contribution from Enterprises (T) 101 39203 00 Transfer From (T) Total Transfers In (T) PAGE TOTALS DEPARTMENT TOTALS INTERNAL REVENUES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $223,348 $259,002 $209,701 $155,500 $7,584,681 $8,476,579 98,345,001 $8,516,300 62,823,013 $3682,965 53,667,761 $3,027,100 Comments 23,655 41,114 14 063 20,000 20,000 From County 101 Funded Projects 82 69 101 0 0 From County 100,891 147,009 176,951 120,000 150,000 6,432 ;6,326) (34,218) 0 0 Annual Market Value Changes 1,434 1,226 722 1,500 1,000 From Checking Account 4,394 5,383 5,712 5,000 5,500 US West Antenna Rent 77,884 44,633 33,765 0 0 1,570 18,734 4,531 2,000 2,000 0 0 0 0 0 3,506 3,662 4,574 3,500 4,000 219,848 255,502 206,201 152,000 182,500 3,500 3,500 3,500 3,500 3,500 Arena Building 8 Grounds Maint 0 0 0 0 0 Funds Returned from Project 3,500 3,500 3,500 3,500 3,500 $186,000 $9,181,100 $2,523,000 Grand Total Less Ad Valorem Fiscal Dispanbes (tP Page Four December 4, 2006 Account Description Actual Actual Actual Budget Amount Budget 2007 BUDGET WORKSHEETS GENERAL FUND REVENUES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed 101 34108 00 General Fund Admin Fees $25000 $25,000 $25,000 $25,000 $25,000 101 34108 01 Fund 201 8,000 101 34108 02 Fund 202 2,50D 101 34108 03 Fund 203 2,500 101 34108 04 Fund 206 2,500 101 34108 05 Fund207 2,500 101 34108 06 Fund 605 1,000 101 34106 07 Fund 606 1,000 101 34106 08 Fund 607 1,000 101 34108 09 Fund 65D 6,000 Admin Fees Breakdown Totals $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 Comments 11 December 4, 2006 2006 ADOPTED 2007 PROPOSED CLASSIFICATIONS /DEPARTMENTS BUDGET BUDGET DIFFERENCE PERCENTAGE GENERAL GOVERNMENT Council $167,900 $297,100 $129,200 76 95% Administration 515,600 524200 8,600 1 67% Electrons 38,900 61,000 22,100 56 81% Finance 308,900 333200 24,300 7 87% General Government 361,700 378,100 16,400 4 53% Community Development 886,000 893,300 7,300 0 82% TOTAL GENERAL GOVERNMENT $2,279,000 PUBLIC SAFETY Police $2,339,700 $2,623,400 $283,700 12 13% Fire 283,400 291,800 8,400 2 96% TOTAL PUBLIC SAFETY $2,623,100 $2,915,200 $292,100 1114/0 PUBLIC WORKS Government Buildings $390,500 $413,400 $22,900 5 86% Fleet Maintenance 478,000 527,100 49,100 10 27% Street Maintenance 1,153 700 1,162,900 9,200 080% Parks Maintenance 532,800 559,700 26,900 5 05% TOTAL PUBLIC WORKS PARKS RECREATION Park Rec- General $967,700 Park Rec- Revenue Producing Programs 91,500 TOTAL PARKS RECREATION GRAND TOTALS GENERAL FUND GENERAL FUND EXPENDITURES $2,555,000 $2,663,100 $2,486,900 $207,900 9 12% $1,013,400 102,500 $108,100 423% $45,700 472% 11,000 12 02% $1,059,200 $1,115,900 $56,700 5 35% $8,516,300 59,181,100 $664,800 7 81% Page One December 4, 2006 2007 BUDGET WORKSHEETS COUNCIL 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget PAGE TOTALS $95,590 $365,634 $392,134 5167,900 $297,100 DEPARTMENT TOTALS $95,590 $365,634 $392,134 5167,900 $297,100 Comments All Salary Costs Inclusive of 101 41110 103 00 Salaries Benefits 526,820 $25,695 $26,850 $26,400 $33,900 Salary, Taxes, PERA Benefits 101 41110 01 225 00 Landscaping Matenals 0 24,370 41,220 25,000 25,000 SKB Landscaping Agreement 101 41110 01 307 00 Management Fees 21,013 48,100 101 41110 01 307 01 Newsletter 7,071 12,830 8,000 27,000 101 41110 01 307 02 Chamber of Commerce Directory 1 000 1,065 1,000 1 100 101 41110 01 307 03 Community Survey 15 000 16,500 9,000 20,000 101 41110 01 310 00 Temporary Service Fees 0 0 5 034 0 0 101 41110 01 319 00 Other Professional Services 6,402 1,925 11,114 12,000 101 41110 01 319 01 Education Reimbursement 7,000 7,000 101 41110 01 319 02 HIPP Initiatives 5,000 5,000 101 41110 01 319 03 Community Forums 10,000 0 101 41110 01 321 00 Telephone Costs 0 0 0 0 1,000 101 41110 01 321 01 Mayor's Pager 400 101 41110 01 321 02 Mayor's Cell Phone 600 101 41110 01 329 00 Other Communication Costs 180 128 263 1,000 1,000 Newspaper Ads Open Houses 101 41110 01 331 00 Travel Expense 846 1,025 184 2,200 101 41110 01 331 01 NLC Conference 894 1,500 1,500 101 41110 01 331 02 Miscellaneous Travel 459 700 700 101 41110 01 433 00 Dues Subscriptions 14,445 20,300 101 41110 01 433 01 LMC Dues 10,334 11,203 12,500 12,500 101 41110 01 433 02 AMM Dues 4,407 4,952 5,000 5,500 101 41110 01 433 03 NDCC Dues 519 1,066 600 600 101 41110 01 433 04 NLC Dues 918 1,273 1,300 1,400 101 41110 01 433 05 Miscellaneous Dues 0 0 300 300 101 41110 01 435 00 Books Pamphlets 119 40 0 100 100 101 41110 01 437 00 Conferences Seminars 2,602 8,000 101 41110 01 437 01 Registration Hotel -LMC Conf 557 0 2,000 2,000 101 41110 01 437 02 Registration Hotel -NLC Conf 1,635 1,421 4,000 4,000 101 41110 01 437 03 Miscellaneous Conferences 582 1,669 2,000 2,000 101 41110 01 439 00 Other Miscellaneous Charges 15,005 38 5,066 0 0 101 41110 01 510 00 Land Purchases 0 0 119,604 0 0 101 41110 01 525 00 Building Structure Purchases 0 0 13,000 0 0 101 41110 01 598 00 Council Designated 5,695 263,898 108,899 40,000 40,000 Yearly Contingencies 101 41110 01 599 00 Employee Recognition Costs 2,463 3,292 7,549 101 41110 01 599 01 Employee Recognition Costs 2,500 2,500 101 41110 01 599 02 Vending Machine Costs 3,000 3,000 Offset by Revenue from Machines 101 49300 01 710 00 Transfers 0 0 0 0 100,000 Arena Operating Subsidy Page One December 4, 2006 2007 BUDGET WORKSHEETS ADMINISTRATION Account Description Actual Actual Actual Budget Amount Budget 101 41320 101 41320 101 41320 101 00 Salanes Benefits 102 00 Full -Time Overtime 103 D0 Part-Time Salaries Benefits 101 41320 01 209 D0 Other Office Supplies 101 41320 01 306 00 Personnel Testing Recrudment 12,795 650 0 101 41320 01 319 00 Other Professional Services 3,624 15,279 4,119 101 41320 01 321 00 Telephone Costs 193 1,194 1,347 80 101 41320 01 331 00 Travel Expense 407 101 41320 01 331 01 NLC Conference 298 101 41320 01 331 02 ICMA Conference 429 101 41320 01 331 D3 Miscellaneous Travel 292 101 41320 01 353 00 Ordinance Publication 0 2,815 101 41320 01 394 00 P C Software Purchases 1,600 0 101 41320 01 433 00 Dues Subscriptions 101 41320 01 433 01 MCMA Dues 101 41320 01 433 02 MAMA Dues 101 41320 01433 03 MCFOA Dues 101 41320 01 433 D4 IIMC Dues 101 41320 01433 D5 IPMA Dues 101 41320 01 433 06 ICMA Dues 101 41320 01 433 07 APMP Dues 101 41320 01 435 D0 Books Pamphlets 101 41320 01 437 00 Conferences Seminars 101 41320 01 437 D1 Registration Hotel LMC 101 41320 01 437 02 Registration Hotel MCMA 101 41320 01 437 03 Personnel Conferences 101 41320 01 437 04 Staff(1)Each 101 41320 01 437 05 Miscellaneous Seminars 101 41320 01 437 06 Registration Hotel ICMA 101 41320 01 437 07 Advanced Clerks School 101 41320 01 437 08 Registration Hotel NLC 101 41320 01 437 09 Miscellaneous Meetings 101 41320 01439 00 Other Miscellaneous Charges 101 41320 01 580 D0 Other Equipment Purchases 1,490 9 5 3 10 39 74 15 386 1,28 2,555 47 44 12 1,16 1,02 19 0 O 5 0 101 41320 31 305 D0 Medical Dental Fees 0 101 41320 31 315 00 Special Programs 0 101 41320 31 315 01 Employee Training 101 41320 31 315 02 HIPP Ingots/es 101 41320 31 319 00 Other Professional Services 0 101 41320 31 319 01 Labor Consultant 101 41320 31 319 02 Labor Legal Issues 101 41320 31 319 03 CHESS Consultant 101 41320 31 319 04 COBRA Consultant 101 41320 31 319 D5 FIexA/EBA Administrative Fees 101 41320 31 319 06 SWWC Co- Operative Dues 101 41320 31 331 00 Travel Expense 0 101 41320 31 341 00 Employment Advertising 1,398 65 101 41320 31 433 00 Dues Subscriptions 0 101 41320 31 433 01 PRIMA Dues 101 41320 31 433 02 IPMA Dues 101 41320 31 433 03 MPELRA Dues 101 41320 31 435 00 Books Pamphlets 0 101 41320 31 437 00 Conferences Seminars 0 101 41320 31 437 01 MPELRA State Conference 101 41320 31 437 02 Personnel Seminars 101 41320 31 437 03 Safety, Supervisor, Policy 101 41320 41 315 0D Special Programs 0 101 41320 41 319 00 Other Professional Services 0 101 41320 41 328 00 Cable Supply Costs 0 101 41320 41 329 00 Other Communication Costs 0 101 41320 41 329 01 Cable JPA Payment General Crty 101 41320 41 329 02 Video Streaming Council Meetings 101 41320 41 329 03 Bulk E -Mail System 101 41320 41 331 00 Travel Expenses 0 101 41320 41 433 00 Dues Subscriptions 0 101 41320 41 437 00 Conferences Seminars 0 101 41320 41 580 00 Other Equipment Purchases 0 PAGE TOTALS DEPARTMENT TOTALS $265,539 $322,450 $347,771 $367,00 12 2,738 67 2,00 O 0 0 550 998 669 30 3,50 5290,550 $358 61 $290,550 $358,61 101 41320 41 315 00 General Marketing, Special Mailings, Changeover of Crty Signage 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed $483,52 $483,52 669 80 800 O 80 B00 51 0 0 0 180 200 200 50 100 100 35 150 150 120 150 150 O 0 0 1,420 1,500 1,500 O 100 100 915 1,000 30 50 500 25 40 400 31 50 500 39,93 40,00 14,92 5,00 5,39 90 32,49 34,00 10 11 2 60 20 37,400 8,400 4,200 All Salary Costs Inclusive of 5380,100 Salary, Taxes, PERA Benefits 2,000 7,000 Temp Receptionist Coverage 800 Miscellaneous Purchases 0 2,000 Updating KFS Models 1,000 Administration Cell Phones 1 600 2 200 1 000 9,000 Comments 0 Moved to General Government 0 Moved Below to H/R O 500 500 491 800 800 O 0 0 Moved Below to H!R 250 200 200 2,287 2,300 2,300 1,080 2,500 2,500 O 200 20D 1,835 2,000 2,500 72 0 0 20 0 100 266 900 900 O 0 300 Employee Drug Testing 4,498 7 000 15,000 5,000 Add Atonal Training for 2006 8,200 2,000 Wellness Health Management 13,100 4,302 4,500 2,000 608 900 900 5,400 5,400 5,400 O 1,000 1,000 4,172 3,000 3,300 O 500 500 520 400 400 4 852 8,000 8,000 Vacancies 1,100 31 45 450 Risk Management 16 25 250 30 20 400 23 50 500 Books Training Materials 1A00 200 200 200 MAGC 400 400 Technical Courses 900 900 5515,600 $524,200 $515,800 $524,200 25,000 See Below for Description 5,000 Consultants Cable TV 3,000 Cable Supplies, Software 50,000 Page One 2007 BUDGET WORKSHEETS ELECTIONS December 4, 2006 Account Description 101 41410 01 103 00 Part-Time Salaries 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $0 527,500 $0 $29,000 $15,000 Election Judges 101 41410 01 203 00 Printed Forms Paper 0 445 0 500 300 Ballots Programming 101 41410 01 208 00 Miscellaneous Supplies 0 371 0 400 300 101 41410 01 219 00 Other Operating Supplies 0 809 0 900 400 Food for Election Judges 101 41410 01 242 00 Minor Equipment 0 2,839 105 2,900 1,500 Booths 8 Signs 101 41410 01 319 00 Other Professional Services 0 0 0 0 0 101 41410 01 321 00 Telephone Costs 0 300 303 400 400 101 41410 01 351 00 Legal Notices Publishing 0 18 0 300 100 Election Publications 101 41410 01 409 00 Other Contracted Repair Mamt 0 1,349 0 1,500 1500 Maintenance for AutoMARK 101 41410 01 412 00 Building Rental 0 2,800 0 3,000 1500 Possible Rent for Locations 101 41410 01 439 00 Other Miscellaneous Charges 0 0 0 0 0 101 41410 01 580 00 Other Equipment Purchases 0 0 54,000 0 40,000 PAGE TOTALS $0 $36 430 $54,408 $38,900 $61,000 DEPARTMENT TOTALS $0 $36,430 $54,408 $38,900 $61,000 Comments Page One December 4, 2006 2007 BUDGET WORKSHEETS FINANCE Account Description Actual Actual Actual Budget Amount Budget 101 41520 101 00 Salaries Benefits 101 41520 102 00 Full -Time Overtime 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed All Salary Costs Inclusive of $193,071 $191,982 $219,263 $230,900 $245,600 Salary, Taxes, PERA Benefits 2,211 2,260 1,484 3,000 3,000 101 41520 01 319 00 Other Professional Services 10,000 0 0 0 0 FA Now Done Internally 101 41520 01 331 00 Travel Expense 135 1,500 101 41520 01 331 01 Finance Director 905 997 1,000 1,200 National Convention Misc 101 41520 01 331 02 Staff 5 16 500 300 101 41520 01 341 00 Employment Advertising 0 988 0 0 0 101 41520 01 391 00 P C Maintenance 46,795 61,200 101 41520 01 391 01 Civic Systems Applications Support 4,376 4,595 5 000 5,000 101 41520 01 391 02 Chnx Maintenance Renewal 0 0 0 1,200 101 41520 01 391 03 Incode Software Maintenance 5,643 5,855 6,000 6,000 101 41520 01 391 04 General Network Support 28,800 30,000 30,000 40,000 400 Hours of Support Time 101 41520 01 391 05 Motor Vehicle SIW Maint 306 0 500 500 101 41520 01 391 06 Fixed Asset Maint Contract 805 1,211 1,000 1,200 101 41520 01 391 D7 Miscellaneous P C Repairs 575 1,350 3,500 2,800 101 41520 01 391 08 Anti -Virus Software Renewal 426 4,205 4,000 4,500 101 41520 01 392 00 P C Accessones Supplies 1,817 1,042 3,699 3,00D 3,000 City System Supplies 101 41520 01 393 00 P C Hardware Purchases 138 497 1,198 2,000 2,000 101 41520 01 394 00 P C Software Purchases 0 793 11,000 101 41520 01 394 01 Annual Microsoft Office Payment 0 11,200 10,000 Annual Payment Thru 2011 101 41520 01 394 02 Miscellaneous SiW Purchases 0 1,000 1,000 101 41520 01 409 00 Other Contracted R M 50 50 60 300 300 Cash Register Repairs Maint 101 41520 01 433 00 Dues Subscriptions 265 700 101 4152D 01 433 01 MDRA Annual Fees 0 0 100 0 101 41523 01 433 02 MnGFOA Finance Director 40 40 50 50 101 41520 01 433 03 MnGFOA Staff 160 200 200 200 101 41520 01 433 04 GFOA Finance Director Asst 160 295 350 350 101 41520 01 433 05 Magazine Subscriptions 0 0 100 100 101 41520 01 435 0D Books Pamphlets 0 200 101 41520 01 435 01 Accounting Related Books 0 127 100 100 101 41520 01 435 02 Finance Related Books 19 0 100 100 101 41520 01 437 00 Conferences Seminars 1,159 4,200 101 41520 01 437 01 MDRA Conference (For 2) 0 0 300 0 101 41520 01 437 02 MnGFOA Annual Conf (F /D Ass't) 550 526 1,000 1,000 101 41520 01 437 03 GFOA National Conf (FD) 1,058 986 1,500 1,500 101 41520 01 437 04 Staff Development 0 0 1,000 1,000 101 41520 01 437 05 Miscellaneous Sernmars 567 922 700 700 101 41520 01 439 00 Other Miscellaneous Charges 273 344 191 500 500 Contigencies 101 41520 01 570 00 Office Equipment Furnishings 0 0 0 0 0 PAGE TOTALS $255,914 $242,352 $277,222 $308,900 $333,200 DEPARTMENT TOTALS $255,914 $242,352 $277,222 $306,900 $333,200 Comments Page One December 4, 2006 Account 101 41810 01 202 DO Duplicating Copying 101 41810 01 202 01 Records Retention 101 41810 01 202 02 Copying Costs 101 41810 01 203 00 Printed Forms Paper 101 41810 01 203 01 Copy Paper 101 41810 01 203 02 General Receipt Books 101 41810 01 203 03 Purchase Orders 101 41810 01 203 04 Payroll Checks 101 41810 01 203 05 A/P Checks 101 41810 01 203 06 Miscellaneous Forms 101 41810 01 204 DO Envelopes Letterheads 101 41810 01 204 01 Letterhead 101 41810 01 204 02 Plain Envelopes 101 41810 01 204 03 A!P Payroll Envelopes 101 41810 01 204 04 10 x 13 Envelopes 101 41810 01 204 D5 10 x 15 Envelopes 101 41810 01 209 00 Other Office Supplies 101 41810 01 221 00 Equipment Parts 101 41810 01 242 00 Minor Equipment 101 41610 01 242 01 State Purchasing Program 101 41810 01 242 02 Credit Card Equipment 101 41610 01 301 00 Auditing Accounting Services 101 41810 01 301 01 Audit General Consulting Fees 101 41810 01 301 02 Dakota County Assessment Fees 101 41810 01 301 03 Dak Cty Truth In Taxation Costs 101 41810 01 301 04 Printing of Budget Books 101 41510 01 301 05 101 41610 01 303 00 101 4181001 30400 101 4181001 319 00 101 41810 01 319 01 101 4181001 319 02 101 4181001 31903 101 4181001 319 D4 101 4181001 319 05 101 4181001 319 06 101 4181001 320 DO 101 4181001 321 DO 101 4181001 321 01 101 4181001 321 02 101 4181001 321 D3 101 4181001 322 00 101 4181001 326 00 101 4181001 329 00 101 41810 01 339 00 101 4181001 351 00 101 4181001 351 01 101 4181001 351 02 101 41810 01 351 03 101 41810 01 391 00 101 41810 01 393 00 2007 BUDGET WORKSHEETS GENERAL GOVERNMENT Description Engineering Fees Legal Fees Other Professional Services City Code Update City Code Web Fees State Building Report (Springsteds) Continuing Disclosure Fees Annual User Fee Study Update Arbitrage /Rebate Calculations Credit Card Activity Fees Telephone Costs General Phone Costs E -Mail Server Costs Web Server Costs Postage Costs Cable Supply Costs Other Communication Costs Other Transportation Expenses Legal Notices Publishing Costs for Public Notices Truth in Taxation Notices Budget Audit Publications P C Maintenance P C Hardware Purchases 101 41810 01 433 00 Dues Subscriptions 101 41810 01 439 00 Other Miscellaneous Charges 101 41810 01 450 00 Sales Tax on Purchases 101 41810 01 580 00 Other Equipment Purchases 101 41810 01 598 00 Emergency Operations Cost PAGE TOTALS DEPARTMENT TOTALS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $10,126 $22,000 Comments 7,766 9,624 7,000 7,000 9,419 9,487 15,000 15,000 7,480 56 9,500 4,692 5,596 2,700 3,300 690 0 1,200 1,200 1,461 0 1,500 1,500 1,356 355 3,000 3,000 0 0 0 0 0 3,458 0 500 Business Cards, etc 2,255 4,200 15,525 3 78 963 773 1,500 1,500 796 2,355 900 900 649 0 800 800 0 845 600 600 0 0 400 400 17,057 19,079 17,000 403 532 800 0 0 350 350 0 0 250 250 48,510 80,000 41,864 57,226 60,000 70,000 Increased GASB Requirements 1,653 1,941 5,000 5,000 1,590 1,579 3,000 3,000 529 243 2,000 2,000 5,500 0 0 0 Moved to Administration O 3,828 0 0 0 42,552 53,749 50,459 75,000 75,000 General City Legal Fees 9,105 39,800 505 540 2,300 2,300 Moved from Administration 1,647 0 1500 1500 Moved from Administration 0 8,453 5,000 5,000 Fees Paid to Springsted 29,750 4,050 5,000 5,000 Fees Paid to Springsted (Bonds) 6,223 6,075 6,000 6,000 Fees Paid to Springsted 10,350 5,500 24,000 20,000 Fees Paid to Springsted 862 1,711 2,300 3,000 5,000 Add'I Services at City Hall 59,672 979 65,000 Monthly Billings 59,547 62,821 65,000 65,000 0 0 0 0 Merged with 01 in 2006 0 285 0 0 Merged with 01 in 2006 18,678 15,837 20,036 16,000 16,000 0 153 0 0 0 Moved to Administration 30,538 30,538 0 Moved to Administration 113 744 75 800 800 General Costs 3,739 5,600 3,478 3,806 3,400 3,400 All Departments 0 156 1,000 1,000 Billing from Dakota County 507 428 1,200 1,200 State Mandated Publications 5,250 1500 3,750 8,000 6,000 Docuware Service Hours O 22,000 0 0 0 Docuware Scanners 90 220 120 0 O 40 473 500 O 0 19,853 0 18,549 14259 29,824 23,000 O 1662 0 0 $273,123 $355,871 $333,097 $361,700 $273,123 $355 871 $333,097 $361,700 5378,100 18,000 General Office Supplies 800 City Hall Equipment Repairs 600 Yearly Fees for Program 300 Newspapers 500 Direct Deposit Filing Fees 0 Sales Tax Audit 29,000 Copy Machine Leases All Bldgs 0 Mercury Spill (Fax Machine Postage Meter) $378,100 Page One December 4, 2006 Account 2007 BUDGET WORKSHEETS COMMUNITY DEVELOPMENT Description 101 41910 101 00 Salaries Benefits 101 41910 102 00 Full -Time Overtime 101 41910 99 103 00 Part-Time Salaries Benefits 101 41910 99 103 01 Planning Commission Members 101 41910 01 201 00 Office Accessories 101 41910 01 202 DO Duplicating Copying 101 41910 01 203 OD Printed Forms 8 Paper 101 41910 01 205 00 Drafting Supplies 101 41910 01 208 00 Miscellaneous Supplies 101 41910 01 209 00 Other Office Supplies 101 41910 01 219 00 Other Operating Supplies 101 41910 01 241 00 Small Tools 101 41910 01 305 00 Medical Dental Fees 101 41910 01 312 00 Contract Inspection Fees 101 41910 01 319 00 Other Professional Services 101 41910 01 329 00 Other Communication Costs 101 41910 01 331 00 Travel Expense 101 41910 01 341 00 Employment Advertising 101 41910 01 391 00 P C Maintenance 101 41910 01 392 00 P C Accessories Supplies 101 41910 01 393 00 P C Hardware Purchases 101 41910 01 433 00 Dues Subscriptions 101 41910 01 433 01 APANAICP 101 41910 01 433 02 ICC 101 41910 01 433 03 AMBO 101 41910 01 433 04 10 000 Lakes 101 41910 01 433 05 "Future Use 101 41910 01 433 06 Trade Magazines 101 41910 01 433 07 Planner's Journal 101 41910 01 433 08 Sensible Land Use Coalition 101 41910 01 433 09 AACEO'MAHCO 101 41910 01 433 10 Other Dues Subscripbons 101 41910 01 435 00 Books Pamphlets 101 41910 01 437 00 Conferences 8 Seminars 101 41910 01 437 01 State Bldg Official School 101 41910 01 437 02 Spring Fall Code Updates 101 41910 01 437 03 Building Inspector Training 101 41910 01 437 04 Computer Training 101 41910 01 437 05 Clerical Seminars 101 41910 01 437 06 Planning Seminars 101 41910 01 437 07 ISTS Training 101 41910 01 437 08 State Planning Conference (2) 101 41910 01 437 09 Planning Commissioner Training 101 41910 01 437 10 Gen'1 Seminars 101 41910 01 437 11 Code Enforcement Train ng 101 41910 01 439 00 Other Miscellaneous Charges 101 41910 01 570 00 Office Equipment Furnishings PAGE TOTALS DEPARTMENT TOTALS 2008 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget All Salary Costs Inclusive of $610,751 $706,897 $771,360 $850,700 $858,000 Salary, Taxes, PERA Benefits 75 1,473 0 3,000 3,000 43,757 12,585 11,620 5,000 5,000 5,000 0 36 30 400 69 472 11,489 3,000 1,308 1,897 1,163 2,000 0 0 0 100 0 195 B1 200 244 666 252 600 0 773 1,657 1,500 O 30 53 400 O 0 0 0 358 439 0 0 98 1,015 14 2,000 1,000 1,487 1,475 2,000 463 720 653 600 3,085 802 0 0 2,016 5,811 2,016 3,000 389 0 0 500 0 2,081 0 0 2,063 1,341 1,37 1,500 100 10 200 480 20 500 175 5 200 O 0 115 18 150 O 4 100 200 200 O 300 30 50 947 328 35 700 3,339 15 380 28 500 179 27 300 0 4 1,000 0 400 40 27 500 1,136 69 1,200 892 40 500 629 63 1,200 358 300 84 49 400 130 40 400 10 145 14 400 O 0 0 $669,971 $743,936 $607 810 $686,000 5669,971 $743,936 5607,610 $886,000 1,500 200 300 150 0 200 100 200 300 50 500 300 1,000 400 500 1200 500 1,400 300 400 400 Comments 400 Calendars, Planners, etc 3,000 Codification of Zoning Ordinance 3,000 Forms, Stickers, Tags, etc 100 Zipatone, Spray Mount 200 Calculators 600 Dictation Devices Tapes 1,500 Building Inspection Supplies 400 Inspectors' Tools 0 0 Fees for Contracted/Temp Sery 1,000 Planning Consultant 2,000 Cellular Phone Pagers 600 0 3,000 Permltworks Support 500 0 3,000 700 Manuals, References, IBC Books 6,900 400 Contingencies 0 $893,300 $893,300 0 Page One December 4, 2008 Account 2007 BUDGET WORKSHEETS POLICE Description 101 42110 101 00 Salaries Benefits 101 42110 102 00 Full -Time Overtime 101 42110 102 01 Regular Overtime Hours 101 42110 102 02 Contracted O/F 101 42110 103 00 Part-Time Salaries Benefits 101 42110 23 103 00 Part-Time Secretary 101 42110 99 103 00 Part-Time CSO's 101 42110 01 202 OD Duplicating Copying 101 42110 01 203 00 Printed Forms Paper 101 42110 01 204 00 Envelopes Letterheads 1 01 42110 01 207 00 Training Instructional Supplies 101 42110 01 207 01 Practice Ammunition 101 42110 01 207 02 Service Ammunition 101 42110 01 207 03 Other Supplies 101 42110 01 208 00 Miscellaneous Supplies 101 42110 01 208 01 DARE Donations 101 42110 01 208 02 Equipment Donations /Forfeitures 101 42110 01 209 00 Other Office Supplies 101 42110 01 211 D0 Cleaning Supplies 101 42110 01 211 01 Blanket Cleaning 101 42110 01 211 02 Squad Interior Cleaning 101 42110 01 217 00 Clothing Allowance 101 42110 01 217 01 CSO's 101 42110 01 217 02 Reserves 101 42110 01 217 03 Other Supplies 101 42110 01 219 00 Other Operating Supplies 101 42110 01 219 01 Evidence Bags, Drug Kits, Misc 101 42110 01 219 02 Accuunt Database Services 101 42110 01 221 00 Equipment Parts 101 42110 01 241 00 Small Tools 101 42110 01 241 01 Evidence Processing Equipment 101 42110 01 241 02 Camera and Video Supplies 101 42110 01 241 03 Other Supplies 101 42110 01 242 00 Minor Equipment 101 42110 01 242 01 Less Lethal Tactical Equipment 101 42110 01 242 02 MAAG Equipment 101 42110 01 304 00 Legal Fees 101 42110 01 305 00 Medical Dental Fees 101 42110 01 305 01 Employee Drug Testing (Amended) 101 42110 01 305 D2 Seized Narcotic Testing 101 42110 01 306 DO Personnel Testing Recruitment 101 42110 01 313 00 Temporary Service Fees 101 42110 01 316 00 Animal Care Services 101 42110 01 316 01 Impound Care Fees 101 42110 01 316 02 Deer Inventory 101 42110 01 319 00 Other Professional Services 101 42110 01 319 01 Dispatch Services Operations 101 42110 01 319 02 Dispatch Services Startup Costs 101 42110 01 321 00 Telephone Costs 101 42110 01 321 01 Cell Phones 101 42110 01 321 02 Pagers 101 42110 01 321 03 LOGIS Communications Line 101 42110 01 323 00 Radio Units 101 42110 01 323 01 Radios 101 42110 01 323 02 Radars 101 42110 01 331 00 Travel Expense 101 42110 01 331 01 MN Chiefs Spring Conference 101 42110 01 331 02 IACP Conference 101 42110 01 331 03 Outstate Investigations Conferences 101 42110 01 331 04 MAAG Conference 101 42110 01 331 05 CAN -AM Narcotic Conference 101 42110 01 331 D6 Juvenile Officers Conference 101 42110 01 331 07 Meeting Reimbursements PAGE TOTALS 2006 2007 Object 2007 2003 2004 2005 Adopted Detad Proposed Actual Actual Actual Budget Amount Budget 1,489,144 1,635,501 1,764,519 $1,911,000 60,931 55,102 62,916 65,000 25,505 7,03 30,00 706 1 225 37 227 1,928 1,88 28 6,055 6,05 941 8 481 18 2,160 3,26 1,082 95 3,055 1,170 1,227 1,435 0 0 0 1,249 701 0 0 56,200 7,469 17,900 20,600 P/F Secretary 16 Hours/Wk 31,500 35,500 35,600 CSO's Total 50 Hours/VVk 242 200 200 Film and Developing 1,043 800 800 Evidence Logs, Animal Lic, etc 0 200 0 3,000 3,429 0 64 2,091 63,395 564 0 0 500 2,434 26 2,006 523 514 569 456 2,000 400 100 0 0 1,000 100 300 1,000 1,500 500 2,000 750 500 750 500 40,000 25,000 2,500 400 100 0 0 100 300 1,000 1,500 500 2,000 300 Digital Recorders 2,488 2,500 2,500 Squad Emergency Equip Repairs 2,000 Crime Scene Kit Supplies 750 500 750 849 1,500 1,500 500 54,996 54,996 54,998 58,000 1,058 441 1,255 1,500 1,500 204 368 500 500 730 2,608 700 1,500 0 0 0 0 13,727 11,314 9,590 14,000 14,000 0 0 500 0 69,588 65,802 68,124 93,000 232,400 5,551 4,422 4,000 15,000 6,483 4,885 5,132 5,000 5,000 749 134 400 0 444 481 500 500 2,861 1,942 0 1,103 2,000 4,000 0 0 1,000 500 1,184 71 401 260 500 500 1,159 0 1,400 1,400 443 711 500 500 457 450 400 400 0 412 400 400 0 249 300 300 0 121 200 200 1,745,523 1,896,432 2,096,106 2,229,600 2,528,600 Comments All Salary Costs Inclusive of $2,054,400 Salary, Taxes PERA Benefits 65,000 0 Donated Forfeited Funds 1,000 Video, CD's Miscellaneous 400 3,000 2,300 Digital Recorders 2,000 Training Supplies 56,000 Prosecution 2,000 1,500 Medical Psychological 1,200 Interpreter Services 14,000 247,400 5,500 4,500 Radio Radar Repairs Subscriber Fees 3,700 Radio Repeater Phone Lines 7? Page Two December 4, 2006 2007 BUDGET WORKSHEETS POLICE 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 101 42110 01 333 00 Freight Express Expenses 101 42110 01 341 00 Employment Advertising 101 42110 01 394 00 P C Software Purchases 101 42110 01 394 01 Automated Pawn System 101 42110 01 394 02 Pictamelry 101 42110 01 394 03 CJIIN System 101 42110 01 396 00 Computer Maintenance 101 42110 01 396 01 Records Management 101 42110 01 396 02 CJDN Connection Charges 101 42110 01 396 03 MCD Connection Charges 101 42110 01 396 04 MCD Maintenance Cellular 101 42110 01 396 05 LOGIS Annual Fees 101 42110 01 396 05 LOGIS Securty and Back Up Site 68 0 813 51,794 1 1,27 39,77 2,52 3,03 18,37 101 42110 01 433 00 Dues Subscriptions 2,613 101 42110 01 433 01 Mutual Aid Assistance Group -MAAG 1,6 101 42110 01 433 02 IACP Chiefs 10 101 42110 01 433 03 MN Chiefs of Police 101 42110 01 433 04 Dakota Cy Chiefs of Police 5 101 42110 01 433 05 Wakota CAER 101 42110 01 433 06 Metro Emergency Managers 101 42110 01 433 07 MN Sex Crimes Investigators 1 101 42110 01 433 08 Tn- County Investigators 6 101 42110 01 433 09 MN Crime Prevention Association 36 101 42110 01 433 10 P 0 S T Licenses 54 101 42110 01 433 11 FBI Nat'l Academy Association 101 42110 01 433 12 Miscellaneous 101 42110 01 435 00 Books Pamphlets 68 9 101 42110 01 436 00 Towing Charges 69 14 101 42110 01 437 00 Conferences Seminars 10 208 101 42110 01 437 01 Firearms -Range Rental 40 101 42110 01 437 02 Chiefs Spring Conference 45 101 42110 01 437 03 Investigations 101 42110 01 437 04 IACP Conference 22 101 42110 01 437 05 Supervision 15 101 42110 01 437 06 Use of Force 8,36 101 42110 01 437 07 Emergency Driving 101 42110 01 437 08 First Aid 101 42110 01 437 09 Narcotic Enforcement 101 42110 01 437 10 Tactical 101 42110 01 437 11 Support Services 101 42110 01 437 12 Patrol 101 42110 01 439 00 Other Miscellaneous Charges 264 44 147 200 200 Repairs 797 500 0 13,000 432 500 500 1,986 2,000 2,000 8,421 10,500 10,500 64,000 42 252 41,000 29,300 CAD Included in DCC 2,351 3,000 3,000 2,464 4,000 3,000 19,652 21,000 22,800 7,875 8,000 5,900 3,593 0 0 3,896 2,000 2,000 345 500 500 361 1,500 1,500 0 250 250 650 1,000 1,000 1,625 600 600 1,365 1 400 1,400 1,690 2,000 2,000 100 750 750 670 1,000 1,000 40 500 500 1,228 1,500 1,500 412 500 101 42110 01 580 00 Other Equipment Purchases 5,590 1,72 3,091 2,000 0 PAGE TOTALS $71,287 $77,916 3108,856 $110,100 $94,800 DEPARTMENT TOTALS $1,816,810 $1,974,347 $2,204,962 $2,339,700 $2,623,400 Comments 3,600 2,000 2,100 2,200 100 100 100 225 150 250 50 50 50 0 20 20 0 25 0 18 25 25 60 60 60 0 25 50 460 750 700 60 60 60 55 35 85 297 300 300 Statutes, Cnme Prevention 86 200 200 13,000 500 Snacks Beverages for Mtgs ao Page One December 4, 2006 Account 2007 BUDGET WORKSHEETS FIRE Description 101 42210 103 00 Salaries Benefits 101 42210 103 01 Salaries 101 42210 103 02 Training Pay /Stipends 101 42210 103 03 Call Pay/SLpends 101 42210 103 04 Class Pay,Stipends 101 42210 103 05 P/T Fire Marshal PAGE TOTALS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $73,285 $74,520 $82,244 $81,700 Comments All Salary Costs Inclusive of $84400 Salary, Taxes, PERA Benefits 26,300 3,300 20 000 100 34 700 101 42210 01 202 00 Duplicating Copying 0 100 101 42210 01 202 01 Copy Toner 0 0 50 50 101 42210 01 202 02 Computer Printers 0 0 50 50 1 01 42210 01 204 00 Envelopes Letterhead 0 100 1D1 42210 01 204 01 Envelopes 0 0 25 25 101 42210 01 204 02 Letterhead 0 0 25 25 101 42210 01 204 03 Forms 258 42 50 50 101 42210 01 207 00 Training Instructional Supphes 929 0 0 0 0 101 42210 01 208 00 Miscellaneous Supplies 1203 2,100 Supplies for Fire Marshal 101 42210 01 208 01 Supplies, Computer Support 917 731 1,500 700 101 42210 01 208 02 Film Developing 0 0 100 100 101 42210 01 208 03 Memberships 45 35 300 300 101 42210 01 208 04 Code Books 152 210 500 200 101 42210 01 208 05 Training 0 595 1,000 500 101 42210 01 211 00 Cleaning Supplies 251 300 101 42210 01 211 01 Soaps 468 1,044 100 150 101 42210 01 211 02 Chamois, Towels, etc 0 0 100 50 101 4221D 01 211 03 Sponges, etc 0 0 25 25 101 4221 D 01 211 04 SCBA Cleaner 0 0 75 75 101 42210 01 218 00 Fire Department Clothing 1,535 83 140 300 300 5 Uniforms 560 Each 101 42210 01 219 00 Other Operating Supplies 1,695 3,500 Medical Supplies 101 42210 01 219 01 Gloves 1,336 0 800 800 101 42210 01 219 02 Bandages 0 0 100 100 101 42210 01 219 03 Equipment 1219 494 500 500 101 42210 01 219 04 Tyvek Suits 0 0 100 100 101 42210 01 219 05 Consummable Medical 354 280 1,800 1,800 101 42210 01 219 06 Oxygen 53 111 200 200 101 42210 01 229 00 Other Maintenance Supplies 262 1,100 101 42210 01 229 01 Aerial- Pumpers- Tanker 3,197 0 800 800 101 42210 01 229 02 Pickup Trucks 0 0 100 100 101 42210 01 229 03 Rescue Other 0 0 100 100 101 42210 01 229 04 Vehicle Modifications 0 12 100 100 101 42210 01 230 00 Equipment Repair Materials 2,030 1,600 101 42210 01 230 01 Light Bars 0 0 100 100 101 42210 01 230 D2 Smoke Machines 0 0 250 250 101 42210 01 230 03 Lanterns Miscellaneous 0 0 250 250 101 42210 01 230 04 Small Tool Repairs 1,087 205 600 600 101 42210 01 230 05 Opticom 0 0 300 300 101 42210 01 230 06 Station 3,912 0 300 300 101 42210 01 241 00 Small Tools 683 700 101 42210 01 241 D1 Axes, Bars Other 140 126 150 150 101 42210 01 241 02 Grass Fire 0 66 250 250 101 42210 01 241 03 Hand Tools 169 782 300 300 101 42210 01 305 00 Medical Dental Fees 2,829 2,470 2,741 3,500 3,500 Annual Medical Tests 101 42210 01 306 00 Personnel Testing Recruitment 1,031 2,100 101 42210 01 306 01 New Physicals (4) 0 1,133 1,000 1,000 101 42210 01 306 02 Hepatitis Shots (4) 341 29 500 500 101 42210 01 306 03 Background Checks (4) 0 96 100 100 1 01 42210 01 306 04 Drug Testing (4) 0 0 500 500 101 42210 01 308 00 Instructors' Fees 6,965 7,700 101 42210 01 308 01 Fire Fighter 1 (4) 0 0 1200 1,200 101 42210 01 308 02 Fire Fighter 1 Certfcates (4) 0 0 150 150 101 42210 01 308 03 Fire Fighter Re- Certificates (6) 90 315 200 100 101 42210 01 308 04 First Responder (4) 0 0 1,000 1,000 101 42210 01 308 05 First Responder Refresher (1/2) 1,656 2,040 1,500 2,000 101 42210 01 308 06 Outside Schools ($/2) 7,007 6,430 3 850 2,250 101 42210 01 308 07 Haz -Mat Training (4) 1,730 0 1 000 1,000 101 42210 01 308 08 Apparatus Re-Certificates (0) 0 0 0 0 92,696 101,204 99,900 107,500 107,700 Page Two December 4, 2006 2007 BUDGET WORKSHEETS FIRE 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 101 42210 01 310 00 Testing Services 1,534 3,400 101 42210 01 310 01 Aerial (Next 2009) 0 795 0 1,000 101 42210 01 310 02 Ladders (Next 2009) 0 0 0 500 101 42210 01 310 03 Pumpers (3) (Next 2008) 870 0 900 900 101 42210 01 310 04 SCBA Hydro Testing (Next 2010) 0 1,450 0 1,000 101 42210 01 313 00 Temporary Service Fees 259 4,000 101 42210 01 313 01 SCBA Contract 540 388 400 400 101 42210 01 313 D2 SCBA Maintenance 0 209 200 200 101 42210 01 313 D3 Copier 8, Fax Contract 1,011 0 400 400 101 42210 01 313 04 Security Contract 278 286 500 700 101 42210 01 313 05 SOT Joint Powers 0 1,381 2,000 2,300 101 42210 01 314 00 Annual Fire Relief Contribution 135,000 135,000 139,100 143,300 147,600 Moved From Salaries Above 101 42210 01 319 00 Other Professional Services 2,713 1,800 Fire Prevention Education 101 42210 01 319 01 School Literature 0 0 350 250 101 42210 01 319 02 Door Prizes 200 0 250 150 101 42210 01 319 03 Fire Prevention Week Promos 2,001 2,897 1,300 900 101 42210 01 319 04 Food at Open House 186 0 150 150 101 42210 01 319 05 Summer Park Education 0 0 250 20D 101 42210 01 319 06 National Night Out 0 0 200 150 101 42210 01 321 OD Telephone Costs 700 500 101 42210 01 321 01 Chief 557 382 300 250 101 42210 01 321 02 Assistant Chief 15 17 100 100 101 42210 01 321 03 Rescue 7 41 100 100 101 42210 01 321 04 Numeric Pagers 70 83 100 50 101 42210 01 322 00 Postage Costs 0 0 14 100 100 UPS Costs 101 42210 01 329 00 Other Communication Costs 521 3,500 101 42210 01 329 01 Base Repairs 0 0 200 200 101 42210 01 329 02 Pager Repairs 474 915 200 200 101 42210 01 329 03 Hand Held Repairs 344 364 300 300 101 42210 01 329 04 Mobile Repairs 120 323 300 300 101 42210 01 329 05 600 MHZ User Fee 0 0 0 2,500 101 42210 01 331 00 Travel Expense 3,677 4,400 101 42210 01 331 01 Minnesota Chiefs Conference 1,309 2,882 1,500 1,500 101 42210 01 331 02 Fire Department Association 289 817 900 900 101 42210 01 331 D3 Outside Schools 0 589 3,500 2,000 101 42210 01 433 00 Dues Subscnptions 1,214 1,400 101 42210 01 433 01 Capital City 5 0 35 50 101 42210 01 433 02 VFBA Insurance 25 30 260 350 101 42210 01 433 33 State Fire 30 300 200 250 101 42210 01 433 04 State Chefs 16 0 250 250 101 42210 01 433 05 DCFC 50 40 40 101 42210 01 433 06 WAKOTA Mutual Aid 2 25 30 40 101 42210 01 433 07 Purchasing Consortium 35 50 50 101 42210 01 433 08 NFPA 0 185 185 101 42210 01 433 09 MN Ass'n Fire Marshals 0 150 185 Fire Marshal Dues 101 42210 01 437 00 Conferences Seminars 519 800 101 42210 01 437 01 State Fire Conference 40 0 400 450 101 42210 01 437 02 State Chiefs Conference 450 300 350 101 42210 01 439 00 Other Miscellaneous Charges 1,293 1,600 101 42210 01 439 01 Food Coffee 26 328 190 250 101 42210 01 439 02 Extinguisher 0 400 400 101 42210 01 439 03 Plaques 4 65 20 40 101 42210 01 439 04 Paint 0 50 70 101 42210 01 439 05 Station Needs 80 684 540 840 101 42210 01 580 00 Other Equipment Purchases 15,708 15,000 101 42210 01 580 01 Bunker Gear (9) 1,285 2,803 9,000 9,000 101 42210 01 580 02 Pagers (6) 7,472 0 3,000 3,000 101 42210 01 580 03 Hose Replacement 1,036 0 2,000 2,000 101 42210 01 580 04 Replace Damaged Items 2,291 1,238 1,000 1,000 101 42210 01 581 00 Other Equipment Purchases 0 0 0 0 0 PAGE TOTALS $163,138 5157,661 5158,920 $175,900 5184,100 DEPARTMENT TOTALS $255,835 $258,885 $258,821 $283,400 $291,800 Page One December 4, 2006 Account 2007 BUDGET WORKSHEETS GOVERNMENT BUILDINGS Description 101 41940 101 00 Salaries Benefits 101 41940 79 101 01 Maintenance -P W Sup #2 101 41940 79 101 02 Maintenance Staff 101 41940 102 00 Full -Time Overtime 101 41940 01 208 00 Miscellaneous Supplies 101 41940 01 223 00 Building Repair Supplies 101 41940 01 225 00 Landscaping Materials 101 41940 01 241 00 Small Tools 101 4194D 01 242 00 Minor Equipment 101 41940 01 302 00 Architects' Fees 101 41940 01 318 00 Contract Engineer 101 41940 01 319 00 Other Professional Services 101 41940 01 319 01 Elevator Maintenance 101 41940 01 319 02 Heating /Cooling Maint Contract 101 41940 01 319 03 Annual Boiler Inspections 101 41940 01 319 04 Pest Control 101 41940 01 319 05 Fire Extinguishers 101 41940 01 319 06 Fire Suppression System Check 101 41940 01 319 07 Janitorial Service -Fire Stations 101 41940 01 319 08 Janitorial Service -P W Building 101 41940 01 361 00 Electric Utili'ies 101 41940 01 383 00 Gas Utilities 101 41940 01 384 00 Refuse Disposal 101 41940 01 384 01 General Buildings Parks 101 41940 01 384 D2 Recycling /Cleanup 101 41940 01 389 00 Other Utility Services 101 41940 01 401 00 Contracted Building Repairs 101 41940 01 401 01 Electrical Repairs 101 41940 01 401 02 Siren Replacement Program 101 41940 01 401 03 Miscellaneous Repairs 101 41940 01 415 00 Other Equipment Rental 101 41940 01 439 00 Other Miscellaneous Charges 101 41940 01 530 00 Improvements Other Than Buildings 101 41940 01 601 00 Bond Principal 101 41940 01 611 00 Bond Interest 101 41940 01 621 00 Bond Paying Agent Fees PAGE TOTALS DEPARTMENT TOTALS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $46,600 0 49257 2,214 4,180 1,153 2,116 110 1,502 706 844 3,515 10,288 44,107 45,362 44,612 45,617 24,025 944 10,430 13,725 3,800 3,800 11,685 1,234 1,665 10,000 15,855 142 0 0 0 0 0 46,046 2,869 456 8,979 12,871 397 0 0 8,500 47,500 4,000 9,604 13,317 15,483 17,000 17,000 Cleaning Supplies, Towels, etc 4,699 5,186 6,499 5,000 5,070 652 469 1,316 500 500 Trees Shrubs 366 46 115 200 200 Hand Tools, Bits, Blades, etc 1,060 1,025 2,038 2,00D 2,000 Equipment Replacement 0 0 0 1,000 0 Estimates 1,500 750 1,500 3,000 3,000 Contracted Engineer for City (5 31,467 30,000 1,206 1,553 1,015 1,570 1,750 2,350 3,515 10,288 76,312 54,161 1,000 5,000 1,500 1,500 1,000 1 ,000 5,300 10,500 50,000 67,500 11,502 20,000 20,000 Added Parks 14,893 15,000 15,000 2 Cleanup Days per Year 3,790 3,800 3,800 Floor Mats Monthly Charges 2,000 10,000 13,000 1,000 1,000 0 2,000 10,000 13,000 4 000 1,000 5,000 1 500 1 500 1,000 2 500 7,000 Fire Stations #2 10,500 25,000 33,895 36,316 38,737 41,200 43,600 MSABC Payment (2/1) 53,142 43,190 39,811 49,900 47,400 MSABC Payments (2/1 e/1) 585 1,063 775 600 600 $315,449 $322,574 $361,796 $390,500 $413,400 $315,449 $322574 $361,796 $390,500 $413,400 75,000 Price Increases 60,000 Fire Station #2 35,000 Comments All Salary Costs Inclusive of $49,300 Salary, Taxes, PERA Benefits 0 49,300 1,000 Scaffolding, Cleaners 1,000 Contingencies 10,000 Fence at St Joseph's Page One December4, 2006 2007 BUDGET WORKSHEETS FLEET MAINTENANCE Account Description Actual Actual Actual Budget Amount Budget 101 43100 101 00 Salaries Benefits 101 43100 77 101 00 Administrative 101 43100 79 101 00 Maintenance 101 43100 102 00 all-Time Overtime 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Comments All Salary Costs Inclusive of $132,369 $143,100 Salary, Taxes, PERA Benefits 9,396 10,976 10,200 10,600 122,763 123,318 136,100 132,500 5,799 1,226 1 601 7,500 7,50 101 43100 01 211 00 Cleaning Supplies 548 709 735 1,000 1 00 Shop Vehicles 101 43100 01 212 00 Motor Fuels 65,730 75,983 115,276 137,500 167,50 Price Increases 101 43100 01 213 00 Lubricants Additives 2,566 5,093 3 038 5,500 5,50 101 43100 01 215 00 Shop Materials 15,714 12,106 11,937 20,500 17,00 101 43100 01 221 00 Equipment Parts 86,235 87,101 92,730 89,000 95 00 101 43100 01 222 00 Tires 12,474 10,213 11,258 18000 16,00 101 43100 01 241 00 Small Tools 4,262 2,662 3,633 4,000 4,00 101 43103 01 242 00 Minor Equipment 8,163 6,935 4,528 6,000 6,00 101 43100 01 318 00 Contract Engineer 3,000 1,500 3,000 4,500 4,50 Contracted Engineer for City(10 101 43100 01 321 00 Telephone Costs 0 0 0 0 101 43100 01 323 00 Radio Units 1,999 1,058 473 2,000 2,00 Repair /Replace Units 101 43100 01 331 00 Travel Expense 0 0 0 0 101 43100 01 341 00 Employment Advertising 190 557 0 151 500 50 Shop Hazardous Waste 101 43100 01 384 00 Refuse Disposal 101 43100 01 394 00 P 5 Software Purchase 0 354 0 500 50 General Softwre Support 101 43100 01 404 00 Contracted Mach Equip Repair• 32,136 31,179 27,680 35,000 35,00 101 43100 01 416 00 Machinery Rental 252 0 0 1,000 1 00 101 43100 01 417 00 Uniforms Rental 118 59 83 0 101 43100 01 433 00 Dues Subscriptions 0 95 0 0 101 43100 01 435 00 Books Pamphlets 0 0 190 200 101 43100 01 437 00 Conferences Seminars 75 220 75 1,000 1,00 PAGE TOTALS $369,629 8389,245 $411,281 $478,000 $527,100 DEPARTMENT TOTALS $369,629 $369,245 $411 281 $478000 $527,100 3 0 Page One December 4, 2006 Account 2007 BUDGET WORKSHEETS STREET MAINTENANCE Description 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 101 43121 101 00 Salaries Benefits $392557 $452,400 Salay, Taxes, PERA Benefits 101 43121 77 101 00 Administrative 28,188 32,930 30,600 31,700 101 43121 78 101 00 Technical /Clerical 52,017 44,643 71,400 58,200 101 43121 79 101 00 Maintenance 296,489 326,704 355,700 362,500 101 43121 102 00 Full -Time Overtime 12,298 8,392 7,396 16,000 16,000 Maintenance 101 43121 99 103 00 Part-Time Salaries Benefits 12,469 12,076 16,833 15,000 15 000 101 43121 01 201 00 Office Accessories 0 72 79 700 700 101 43121 01 203 00 Printed Forms Paper 1,656 700 101 43121 01 203 01 R!W Permit Inspection Forms 28 0 500 500 101 43121 01 203 02 Work Orders 145 51 200 200 101 43121 01 203 03 City Specification Books 378 2,953 3,500 0 101 43121 01 205 00 Drafting Supplies 1,014 60 306 2,100 101 43121 01 205 01 Paper for Plan Reproductions 1,412 900 900 101 43121 01 205 02 Off-Site Reproductions 0 450 450 101 43121 01 205 03 Film Developing 0 200 200 101 43121 01 205 04 Miscellaneous Tools 13 50 550 550 Inspection Equipment 101 43121 01 209 00 Other Office Supplies 82 0 279 500 500 101 43121 01 216 00 Chemical Chemical Products 32,183 27,017 59,193 37,000 80,000 De -Icing Chemicals (Added Miles) 101 43121 01 224 00 Street Maintenance Materials 674 1,500 101 43121 01 224 01 Paint 473 475 500 500 101 43121 01 224 02 Mail Boxes 93 281 500 500 101 43121 01 224 03 Light Bulbs /Lenses 163 85 500 500 101 43121 01 225 00 Landscaping Materials 1,147 6,300 101 43121 01 225 01 Sod 94 35 3,000 3,000 101 43121 01 225 02 Seed 474 0 300 300 101 43121 01 225 03 Black Dirt 243 72 2,000 2,000 101 43121 01 225 04 Trees 498 0 1,000 1,000 101 43121 01 226 00 Sign Repair Materials 8,350 8,846 7,941 10,000 10,000 101 43121 01 231 00 Bituminous Patching Materials 25,684 23,845 26,433 27,000 27,000 101 43121 01 232 00 Crushed Rock 24,761 25 950 33 061 30,000 30,000 Add County Road 36 101 43121 01 233 00 Dust Control Materials 24,686 22,660 18,460 30,000 30,000 Add County Road 38 101 43121 01 234 00 De -Icing Sand 10,138 5,801 3,742 12,000 6,000 101 43121 01 235 00 Shouldering Gravel 2,488 3,534 2,543 3,000 3,000 101 43121 01 241 00 Small Tools 1,342 2,023 1,125 1,500 1,500 Shovels, Brooms, etc 101 43121 01 242 00 Minor Equipment 2,823 9,860 3,063 3,000 3,000 Safely Equipment 101 43121 01 303 00 Engineering Fees 20,537 38,399 62,545 8,500 8,500 General Non- Project Related 101 43121 01 304 00 Legal Fees 2,528 6,729 12,183 2,000 2,000 Appeals of Closed Projects 101 43121 01 305 00 Medical Dental Fees 207 0 0 600 600 Employment Physicals 101 43121 01 310 00 Testing Services 0 954 537 1,200 1,200 101 43121 01 313 01 Temporary Service Fees 0 535 14,043 0 0 101 43121 01 318 00 Contract Engineer 8,000 3,000 6,000 9,000 9,000 Contracted Engineer for Cily(20 101 43121 01 319 00 Other Professional Services 566 1,469 5,887 1,500 1,500 Random Drug Testing 101 43121 01 321 00 Telephone Costs 2,268 2,171 1,842 3,000 3,000 Cellular Phones Pagers 101 43121 01 324 00 Messenger Services 0 0 80 100 100 101 43121 01 331 00 Travel Expense 5 5 110 1,000 1,000 APWA Miscellaneous 101 43121 01 341 00 Employment Advertising 501 0 1,949 0 0 101 43121 01 381 00 Electric Utilities 105,575 22 8 145,000 101 43121 01 381 01 Street Lights 113,185 124,546 135,000 135,000 Added Lights Price Increases 101 43121 01 381 02 Signal Lights Sirens 3,630 3,740 10,000 10,000 101 43121 01 384 00 Refuse Disposal 201 2,600 101 43121 01 384 01 Hazardous Waste Disposal 0 0 1,000 1,000 101 43121 01 384 02 Roadside Garbage 252 542 1,000 1,000 101 43121 01 384 03 Tree Disposal 91 0 600 600 101 43121 01 391 00 P C Maintenance 2,500 8,500 101 43121 01 391 01 Gopher State One -Call 0 0 0 0 101 43121 01 391 02 State Aid 0 0 1,000 1,000 101 43121 01 391 03 Pavement Management Syst Supp 4,053 194 7,500 7,500 101 43121 01 392 00 P C Accessories Supplies 0 0 0 0 0 101 43121 01 394 00 P 5 Software Purchases 0 0 298 5,000 5,000 General Software Support PAGE TOTALS 695,241 705,361 823,217 845,500 853,700 Page Two December 4, 2006 2007 BUDGET WORKSHEETS STREET MAINTENANCE 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 101 43121 01 402 00 Street Seal Coating 136,226 137,841 0 0 0 Moved to Street CIP Part of 101 43121 01 402 00 General Seal Coating 0 Pavement Management Program 101 43121 01 403 00 Contracted Repair Maintenance 5,472 29,500 101 43121 01 403 01 Street Lights 10,439 20,811 28,50 28,500 Repair 9 Street Lights (Annually) 101 43121 01 403 02 Signal Lights 494 29 50 500 101 43121 01 403 03 Light Replacements 1,675 115 50 500 101 43121 01 405 00 Street Striping 14,084 14,324 15,652 30,00 25,000 101 43121 01 406 00 Street Sweeping 5,491 6,468 3,160 5,00 5,000 101 43121 01 407 DO Bituminous Overlays 0 0 0 0 101 43121 01 408 00 Street Crack Sealing 33,332 30,165 19 891 35,00 35,000 101 43121 01 409 0D Tree Trimming 4,703 3,179 4,979 5,00 5,000 101 43121 01 410 00 Concrete Sidewalk /Curb Repairs 133,374 14,202 133,000 101 43121 01 410 01 General Repairs 0 424 8,00 8,000 101 43121 01 410 02 Pedestrian Improvements 118,327 124,615 125,00 125,000 101 43121 01 411 D0 Contracted Snow Removal 7,215 4,192 15,686 24 000 101 43121 01 411 01 Community Center 12,00 12,000 101 43121 01 411 02 St Joseph's 6,00 6,000 101 43121 01 411 02 Genz -Ryan 6,000 101 43121 01 415 00 Equipment Rental 0 16,383 4 452 45,00 45,000 Paver Rental 101 43121 01 416 00 Snow Plow Loader Rental 9,260 0 7 199 0 101 43121 01 415 00 Snow Plow Rental 0 0 0 0 101 43121 01 420 00 Truck Rentals /Sidewalk Blower 1,820 2,130 0 0 101 43121 01 433 00 Dues Subscriptions 961 900 101 43121 01 433 01 American Public Works Ass'n 340 429 22 225 (APWA) 101 43121 01 433 02 Request for Mutual Aid Assn 500 0 1 10 (RMAA) 101 43121 01 433 03 City Engineers' Association 0 0 1 150 101 43121 01 433 04 Professional Secretaries 80 100 9 90 101 43121 01 433 05 MN Society for Professional Engineers 375 375 30 300 (MSPE) 101 43121 01 433 06 American Society of Civil Engineers 0 0 12 125 (ASCE) 101 43121 01 435 00 Books Pamphlets 131 800 101 43121 01 435 01 MUTCD 39 0 20 200 101 43121 01 435 02 MN Dot Updates 15 121 60 600 101 43121 01 437 00 Conferences Seminars 1,303 4 000 101 43121 01 437 01 APWA 225 989 1,05 1,050 101 43121 01 437 02 Computer Training 0 251 50 500 101 43121 01 437 D3 Clerical 90 10 15 150 101 43121 01 437 04 Gravel Road Maintenance 112 15 150 101 43121 01 437 05 City Management Training 0 50 500 101 43121 01 437 06 CEAM 0 50 500 101 43121 01 437 07 MN Pavement Management 12 40 400 101 43121 01 437 06 MN Dot 0 30 300 101 43121 01 437 09 Miscellaneous Training 380 55 45 450 Safely Training 101 43121 01 439 D0 Other Miscellaneous Charges 5 469 2,091 2,00 2,000 101 43121 01 570 OD Office Equipment Furnishings 0 0 0 0 PAGE TOTALS $353,377 $362,457 $222,024 $308,200 $309,200 DEPARTMENT TOTALS $1,048,615 51,067818 $1,045,241 51,153,700 $1,162,900 Page One December 4, 2006 2007 BUDGET WORKSHEETS PARKS GROUNDS MAINTENANCE 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 101 45202 101 00 Salaries Benefits 101 45202 77 101 00 Administrative 101 45202 79 101 00 Maintenance 101 45202 102 00 Full -Time Overtime 101 45202 99 103 00 Part-Time Salaries Benefits 101 45202 01 205 00 Drafting Supplies 0 0 101 45202 01 216 00 Chemical Chemical Products 13,141 101 45202 01 216 01 Herbicdes(General Park Use) 4,727 8,02 101 45202 01 216 02 Fertilizer 10,833 18,78 101 45202 01 219 0D Other Operating Supplies 9,105 101 45202 01 219 01 Seed, Sod, etc 876 2,58 101 45202 01 219 02 Red Rock, Sand, Gravel, etc 1,227 2 22 101 45202 01 219 03 Repair Supplies 2,129 101 45202 01 219 04 Bituminous 0 101 45202 01 221 00 Equipment Parts 10,528 101 45202 01 221 01 Playground Equipment Repair 3,151 4,46 101 45202 01 221 02 Irrigation Repair(Non- Contract) 3,184 2,70 101 45202 01 221 D3 M'scellaneous(Player Benches) 4,843 84 101 45202 01 221 04 Park Sign Replacements 0 4,29 101 45202 01 223 00 Building Repair Supplies 5,245 101 45202 01 223 01 Paint, Stain, etc 1,548 1,27 101 45202 01 223 02 Shingles, Boards, etc 599 1,99 101 45202 01 223 03 Miscellaneous 1,639 78 101 45202 01 223 04 Shelter /Shed Repairs 0 7 23 131 45202 01 225 00 Landscaping Materials 1,370 101 45202 01 225 01 Trees, Shrubs, Sod, etc 3,181 2,30 101 45202 01 225 02 Timbers, Fence, etc 307 2,30 101 45202 01 226 00 Sign Repair Materials 0 14 28 101 45202 01 229 00 Other Maintenance Supplies 1,540 1,907 3,96 101 45202 01 241 00 Small Tools 2,786 2,430 1,66 101 45202 01 242 00 Minor Equipment 2,565 450 1,32 101 45202 01 303 00 Engineering Fees 0 0 101 45202 01 305 00 Medical and Dental Fees 207 0 101 45202 01 318 00 Contract Engineer 1,375 750 1 50 101 45202 01 321 00 Telephone Costs 1,532 2,017 1,77 101 45202 01 323 00 Radio Units 0 0 101 45202 01 331 00 Travel Expense 0 0 101 45202 01 341 00 Employment Advertising 0 0 101 45202 01 361 00 Electric Utilities 12,811 101 45202 01 361 01 Skating Rinks 4,088 4,03 101 45202 01 381 02 Softball Fields 6,163 6,50 101 45202 01 381 03 Irrigation 1,965 2,13 101 45202 01 383 00 Gas Utilities 2,200 2,210 2,48 All Salary Costs Inclusive of $259,401 $383,200 Salary, Taxes, PERA Benefits 9,396 10,97 10,200 10,600 291950 310,22 354,600 372,600 2,655 5,174 5,57 14,000 14,000 12,434 19,574 31,51 15,000 15,000 100 10D 34,000 12,000 12,000 17,000 22,000 3,000 3,000 6,000 6,000 3 000 3,000 Bloomfield Birch Parks Online 0 D Repave Schwarz Parking Lot 15,000 Add Meadows Inmsfree 2,500 7,500 Woodchips 3,000 5,000 2,500 2,500 5,500 0 1,500 1,500 2,000 2,000 1,500 1,500 5,000 5,000 7,000 3,500 3,500 Landscaping Around Park Signs 3,500 3,500 500 500 4,000 4,000 Paint, Chalk, Bases, Field Dry, etc 2,500 2,500 Hand Tools, Blades, Bits, etc 2,500 2,500 Safety Equipment 0 0 0 0 3,000 3,000 Contracted Engineer for City (5 500 500 Cellular Phone Bills 500 500 Walkie- Talkies 100 100 Seminars Workshops 0 0 15,500 6,000 6,000 6,500 6,500 3,000 3,000 3,300 12,000 Add Meadows Innisfree&Harrnony 10,000 Caulk, Hardware, etc 3 300 101 45202 01 403 OD Contracted Repair Maintenance 2,570 8,000 101 45202 01 403 01 Irrigation Repairs 364 0 1,500 1,500 101 45202 01 403 02 Electrical Repairs 801 1,860 1,500 1,500 101 45202 01 403 03 Miscellaneous Repairs 2,601 150 5,000 5,000 Roof Jaycee Park Shelter 101 45202 01 409 00 Other Contracted Repair Maint 0 2,335 3,913 8,000 18,000 Chemical Lawn Services 101 45202 01 416 00 Machinery Rental 11,878 101 45202 01 416 01 Mower Leases 12,235 14,100 17,000 17,000 Price Increases 101 45202 01 416 02 Miscellaneous Rentals 4,663 973 1,000 1,000 101 45202 01 433 00 Dues Subscriptions 45 200 101 45202 01 433 01 Memberships MRPA 0 35 100 100 101 45202 01 433 02 Miscellaneous Dues 0 0 100 100 101 45202 01 435 00 Books Pamphlets 0 0 152 100 100 101 45202 01 437 00 Conferences Seminars 662 2 500 101 45202 01 437 01 Seminars Workshops 363 1,085 300 0 101 45202 01 437 02 School Tuition 270 891 200 0 101 45202 01 439 00 Other Miscellaneous Charges 0 0 348 200 200 Contingencies PAGE TOTALS $354,072 $409,966 $467,286 $532,800 $559,700 DEPARTMENT TOTALS $354,072 $409,966 $467,286 $532,800 $559,700 Page One December 4, 2006 Account N Description 2007 BUDGET WORKSHEETS PARKS RECREATION 101 45100 101 00 Salaries Benefits 101 45100 102 00 Full -Time Overtime 101 45100 103 00 Part-Time Salaries Benefits 101 45100 xx 103 00 P/T Secretary 101451001D 10300 P/1 Receptronist 101 45100 12 103 00 Building Attendants 101 45100 83 103 00 Playground Recreation Leaders 101 45100 94 103 00 Warming House Attendants 101 45100 99 103 00 Park Rec Committee 101 45100 71 103 00 Pff Horticultursl 101 45100 01 203 00 Printed Forms Paper 101 45100 01 205 00 Drafting Supplies 101 45100 01 207 00 Training Instructional Supplies 101 45100 01 208 00 Miscellaneous Supplies 101 45100 01 209 00 Other Office Supplies 101 45100 01 211 00 Cleaning Supplies 101 45100 01 216 00 Chemicals Chemical Products 101 45100 01 219 00 Other Operating Supplies 101 45100 01 221 00 Egwpment Parts 101 45100 01 223 00 Building Repair Supplies 101 45100 01 229 00 Other Maintenance Supplies 101 45100 01 303 00 Engineering Fees 101 45100 01 305 00 Medical Dental Fees 101 45100 01 312 00 Custodial Services 101 45100 01 315 00 Special Programs 101 45100 01 315 01 Sunday Night Specials 101 45100 01 315 02 Leprechaun Days 101 45100 01 315 03 Halloween 101 45100 01 315 04 Ground Pounders(Running) 101 45100 01 315 05 Nature Programs(Arbor Day, etc 101 45100 01 315 06 Puppet Programs 101 45100 01 315 07 Special Events 101 45100 01 315 08 Adopt -A -Park Program 101 45100 01 315 09 Miscellaneous Programs 101 45100 01 315 10 ADA Programs 101 45100 01 319 00 Other Professional Services 101 45100 31 321 00 Telephone Costs 101 45100 01 331 00 Travel Expense 101 45100 01 341 00 Employment Advertising 101 45100 01 349 00 Other Advertising 101 45100 01 349 01 Brochures 101 45100 01 349 02 Yellow Pages 101 4510D 01 349 03 Special Marketing 101 45100 01 381 00 Electric Utilities 101 45100 01 363 00 Gas Utilities 101 45100 01 354 00 Refuse Disposal 101 45100 01 401 00 Contracted Building Repairs 101 45100 01 404 00 Contracted Mach Equip Repairs 101 45100 01 409 00 Other Contracted Repair Maint 101 45100 01 412 00 Building Rental 101 45100 01 415 00 Other Equipment Rental 101 45100 01 433 00 Dues Subscriptions 101 45100 01 433 01 MRPA Dues 101 45100 01 433 02 Miscellaneous 101 45100 01 435 00 Books Pamphlets 101 45100 01 437 00 Conferences Seminars 101 45100 01 437 01 MRPA State Conference 101 45100 01 437 02 MIAMA State Conference 101 45100 01 437 03 Workshops, Schools, Tuition 101 45100 01 439 00 Other Miscellaneous Charges PAGE TOTALS General Operating DEPARTMENT TOTALS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget All Salary Costs Inclusive of $392,557 $475,475 $576,211 $628,800 $650,800 Salary, Taxes, PERA Benefits 11,770 11,218 9,455 4,700 10,500 122 200 31,908 35,634 0 0 0 Moved Above to Full -Time 22 625 28,707 23770 30,200 31,200 81,185 71,617 50,603 33,000 49,000 19,07C 20,923 16 262 20,000 20 000 8 272 9,652 9 442 13,000 13,000 1,912 1,912 2,396 2,500 2,500 0 0 14 5,000 6,500 268 0 215 983 0 0 576 438 1,622 1,161 5,846 4,845 924 941 5,208 5,224 5,560 10,115 4,624 5,264 53 0 285 408 0 0 437 4,254 1,181 4,903 9,424 4,194 0 0 1,000 200 500 1,600 5,500 1,500 7,000 9,500 5,500 0 Comm 0 1,000 Film, Developing Laminating 200 Books, Tapes, etc 500 Meeting Supplies 1,600 Envelopes, Forms, Rulers, etc 5,500 1,500 7,000 Rec Programs, 1st Aid Sup, etc 9,500 5 500 0 153 0 0 0 0 374 481 0 800 800 Employment Physicals 5,969 5,983 4,899 6,500 6,500 Custodial Services- Banquet Rm 6,935 12,700 2,500 2,295 3,000 3,000 Performances 84 600 600 600 Trophies Awards 459 204 500 500 Supplies 0 46 400 400 Ribbons Mailings 1,655 2,157 2,000 2,500 Trees 60 291 500 500 Tapes, Fuses, Puppets, etc 339 601 1,000 1,000 Publicity Supplies 374 172 1 400 1 400 Flyers, Trees, Signs 848 827 2 000 2,000 Start Up Costs 0 0 800 800 ADA Program Supplies 347 478 1, 2 500 2,500 ADA Services /Eng LA Sery Test 1,736 2,751 2,425 3,100 3,100 Pagers Cellular Phones 15 46 149 500 500 2,092 2,310 1,602 2,800 2,800 General Employment Ads 20,473 192 25,800 17,734 24,600 21,500 20,000 Qty Newsletter 3,408 3,692 3,400 3,400 Rec Ads 473 1,753 2,400 2,400 New Program Flyers 19,946 18,726 23,240 26,000 26,000 23,465 26,823 34,957 33,600 33 600 3,783 3,160 3,106 4,000 4,000 13,655 5,908 8,702 5,816 18,948 19,908 16,800 17,071 14,135 12,984 2,684 1,321 978 50 19 497 1,230 0 805 59,667 35,281 7,862 10,000 10,000 4,810 8,000 8 000 19,389 20,000 20,000 Air Handler Maintenance Contract 16,800 16,800 16,800 Monthly Rent Payments to Guard 14,060 18,000 18,000 Portable Toilets Other Rentals 1,900 1259 1,100 1,500 Minn Recreation Parks Assn 767 400 400 Paper, Magazines, JC Dues, etc 0 100 100 4,500 1,721 0 463 25,004 $814,625 $872,360 $914,988 $967,700 2,000 300 2,200 0 2,000 300 2,200 $1,013,400 $814,625 $872,360 $914,988 $967,700 $1,013,400 0 Donation Account Page Two December4, 2006 2007 BUDGET WORKSHEETS PARKS RECREATION Account# Description Actual Actual Actual Budget Amount Budget 101 45100 71 Horticulturist $2,584 $0 $0 $0 $0 101 45100 81 Softball 44,322 48,211 47,639 40,000 51,000 101 45100 82 Volleyball 575 335 40 900 900 101 45100 84 Tennis 956 603 1,042 600 B00 101 45100 85 Tiny Tots 16,419 16 405 18,739 19,000 19,000 101 45100 86 Rosettes 988 1,230 784 2,000 2,000 101 45100 87 Trips 2,878 9,055 10,737 3,000 3,000 101 45100 88 Broomball 0 0 0 0 0 1 01 4510D 89 Outdoor Skating Lessons 0 73 135 400 400 101 45100 90 Run for the Gold 2,902 3,203 2,655 3,000 3,000 101 45100 91 Camps 3,884 8,292 13,634 4,000 4,000 101 45100 92 Adult Basketball 74 0 176 1,900 1,900 101 45100 93 Other Programs 8,487 8,553 11,331 6,500 6,500 101 45100 95 T -BalI 5,546 4,171 4,354 5,000 5,000 101 45100 96 Teen Night 4,861 5,540 7,575 5,000 5,000 101 45100 98 Soccer Lessons 0 4,608 365 0 0 101 45100 71 103 00 Part -Time Salaries 2,58 101 45100 81 103 00 Part -Time Salaries 24,27 101 451D0 81 219 00 Operating Supplies 8 101 45100 81 311 00 Officiating Fees 8,57 101 45100 81 319 00 Other Professional Services 3,37 101 45100 82 103 00 Part-Time Salaries 101 45100 B2 219 00 Operating Supplies 57 101 45100 82 311 00 Officiating Fees 101 45100 82 319 00 Other Professional Services 101 45100 84 103 00 Part-Time Salaries 90 101 45100 84 219 00 Operating Supplies 5 101 45100 85 103 00 Part-Time Salaries 15,13 101 45100 85 219 00 Operating Supplies 1,28 101 45100 86 103 00 Part-Time Salaries 62 101 45100 86 219 00 Operating Supplies 36 101 45100 87 103 00 Part-Time Salaries 1 01 45100 87 219 00 Operating Supplies 2,87 101 45100 88 219 00 Operating Supplies 101 45100 88 311 00 Officiating Fees 101 45100 89 103 00 Part-Time Sa'anes 101 45100 89 219 DO Operating Supplies 101 45100 90 219 00 Operating Supplies 2,90 101 45100 91 103 00 Part-Time Salaries 1,96 101 45100 91 219 00 Operating Supplies 1,91 101 45100 92 219 00 Operating Supplies 7 101 45100 93 103 00 Part-Time Salaries 2 101 45100 93 219 00 Operating Supplies 4,37 101 45100 95 103 00 Part-Time Salaries 4,34 101 45100 95 219 00 Operating Supplies 1,20 101 45100 96 103 00 Part-Time Salaries 101 45100 96 219 00 Operating Supplies 4,86 101 45100 98 103 00 Part-Time Salaries 101 45100 98 229 00 Operating Supplies SPECIAL PROGRAM TOTALS GRAND TOTAL PARK REC 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed 92,47 $102,500 See Above Comments 108,481 119,205 91,500 102,500 0 0 0 0 See Above 22,834 25,910 24,300 7,000 11,912 9,176 11,000 11,000 6,273 8,784 0 28 000 5,393 3,767 4,700 5,000 0 0 0 0 335 40 900 900 0 0 0 0 O 0 0 0 803 998 650 650 0 45 150 150 14,170 16,289 18,000 16 000 2,236 2,451 1,000 1,000 566 247 1,200 1,200 664 537 800 600 1,151 769 0 0 7,905 9,969 3,000 3,000 0 0 0 0 O 0 0 0 73 135 400 400 O 0 0 0 3,203 2,655 3,000 3 000 5,877 6,772 2,00D 2000 2,415 6,862 2,000 2 000 0 176 1,900 1,900 3,019 2,750 2,000 2,000 5,534 8,581 4,500 4 500 3,106 3,103 4000 4000 1,065 1251 1,000 1 000 453 1,220 0 0 5,067 6,355 5,000 5,000 0 0 0 0 4,608 365 0 0 92,475 108,481 119,205 91,500 102,500 $907,100 $980,641 $1,034,194 $1,059,200 $1,115,900 Page One December 4, 2006 2007 BUDGET WORKSHEETS BUILDING CIP REVENUES 2003 Account# Description Actual 202 31010 00 Current Ad Valorem Taxes $24,00 202 31610 00 Franchise Taxes 202 34151 00 User Fees /Host Agreements 202 36101 00 Principal Special Assessments 202 36102 00 Penalties Interest S/A 202 36210 00 Interest Earnings Investments 2,79 202 36214 OD Net Change in FV- Investments 202 36215 00 Interest Earnings 19 202 36230 OD Contributions/Donations 202 36260 0D Other Revenue 202 36265 00 Use of Reserve Funds FUND TOTALS EXPENDITURES 202 49002 01 317 00 General Fund Administrative Fees $2,50 202 49002 01 510 00 Land Purchases 202 49002 01 521 00 Building Structure Purchases 202 49002 01 522 00 Building Structure Purchases 202 49002 01 523 00 Building Structure Purchases 202 49002 01 524 00 Building Structure Purchases 202 49002 01 525 00 Building Structure Purchases 202 49002 01 526 00 Building Structure Purchases 202 49002 01 530 00 Improvements Other Than Bldgs 202 49002 01 598 00 Council Designated 202 49002 01 611 D0 Interest on Lease Payments 202 49002 01 710 00 Transfers FUND TOTALS 914,00 10,99 13,00 2006 2007 Object 2007 2004 2005 Adopted Detail Proposed Actual Actual Budget Amount Budget $39,00 10,06 54 $2,50 11,54 14,10 590,00 12,45 $940,500 $630,60 $46,00 16,59 1,12 500,00 $24,00 2,40 $24,00 2,40 10 $28,992 $49,609 $565,714 $26,500 $26,500 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget $2,500 $2,50 0 12,150 12,75 26,424 0 0 500,914 0 0 0 11,676 11,25 0 $553,666 $26,500 NOTE 2007'5 Proposed Budget Includes $2,500 for General Fund Admin Fees Not Included in Levy Amount (Covered by Interest Earnings) 2007's Proposed Budget has a Total of $24,000 for the Levy Amount $2,50 13,35 10,65 $26,500 Comments SKB Donation for St Joseph's Comments Yearly Fee Per Policy F -3 2003- Encumbered for Library Year 9 of 20 PW Budding Add'n 2004- Encumbered for Future 2005 -St Joseph's Purchase Year 9 of 20 PW Building Add'n Page One December 4, 2006 203 49003 01 710 00 Transfers 2007 BUDGET WORKSHEETS STREET CIP REVENUES FUND TOTALS 203 31010 00 Current Ad Valorem Taxes $160,000 $750,000 $1250,00 203 33419 00 MSA for Streets Construction 2,360 0 203 34150 00 SKB User Fees Base Charges 124,926 140,934 131,92 203 34151 00 SKB User Fees Excess Trust Fund 0 0 101,57 203 34152 00 SKB User Fees MSW Ash 32,440 32,182 29,87 203 36101 00 Principal Special Assessments 15,288 140,130 208,23 203 36102 00 Penalties Interest S!A 19 73 10 203 3621D 00 Interest Earnings Investments 16,753 9,723 24,66 203 36214 00 Net Change in FV- Investments 0 0 203 36215 00 Interest Earnings 403 380 29 203 36260 00 Other Revenue 0 0 203 36265 00 Use of Reserve Funds 0 0 203 39203 00 Transfer From 132,029 132,509 2007's Proposed Budget has a Total of $1,050,000 for the Levy Amount FUND TOTALS EXPENDITURES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget $1,100,00 150,00 100,00 50,00 10,00 50 NOTE 2007's Proposed Budget Includes $2,500 for General Fund Admin Fees Not Included in Levy Amount (Covered by Interest Earnings) $1,050 00 150,00 100 00 50,00 10 00 50 $484,237 $1,155,931 $1,746,660 $1,410,500 $1,360,500 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments Comments 203 49003 01 303 00 Engineering Fees 534,693 $3,979 $1 000 SO $0 203 49003 01 317 00 General Fund Admmistrative Fees 2,500 2,500 2,500 2,500 2,500 Yearly Fee Per Policy F -3 203 49003 01 530 00 Improvements Other Than Bldgs 0 0 250,000 280,000 50 000 203 49003 01 530 00 CR 42 US Hwy 52 Design Costs 50,000 City Portion of Project Only 203 49003 01 531 00 Improvements Other Than Bldgs 0 0 67,960 900,000 900 000 203 49003 01 531 00 Pavement Management Program 900,000 Levy SKB Portions Only 203 49003 01 532 00 Improvements Other Than Bldgs 8,510 0 0 120,000 300,000 203 49003 01 532 00 CR 73 (CR 42 to 135th Street) 300,000 203 49003 01 533 00 Improvements Other Than Bldgs 0 0 0 0 0 203 49003 01 533 00 0 203 49003 01 534 00 Improvements Other Than Bldgs 0 0 0 0 0 203 49003 01 534 00 0 203 49003 01 598 00 Council Designated 0 0 0 0 0 164,933 766,057 1,438,848 0 0 $210 635 $772 535 $1,760,308 $1,302,500 $1,252,500 Page One December 4, 2006 2003 2004 2005 Account Description Actual Actual Actual 207 31010 00 207 34151 00 207 36101 00 207 36102 00 207 36210 00 207 36214 00 207 36215 00 207 36260 00 207 36265 00 207 39101 00 207 39202 00 207 39203 Do 207 39310 00 2007 BUDGET WORKSHEETS EQUIPMENT CIP REVENUES Current Ad Valorem Taxes User Fees /Host Agreements Principal Special Assessments Penalties Interest S/A Interest Earnings Investments Net Change in FV- Investments Interest Earnings Other Revenue Use of Reserve Funds Sale of General Fixed Assets Contribution from Enterprises Transfer From Bond Proceeds FUND TOTALS EXPENDITURES 207 49007 01 317 00 General Fund Administrative Fees 207 49007 01 319 00 Other Professional Services 207 49007 01 530 00 Improvements Other Than Bldgs 207 49007 01 531 DO Improvements Other Than Bldgs 207 49007 01 540 00 Heavy Machinery Purchases 207 49007 01 541 00 Heavy Machinery Purchases 207 49007 01 545 00 Equipment Certificate Purchases 207 49007 01 546 00 Equipment Certificate Purchases 207 49007 01 547 00 Equipment Certificate Purchases 207 49007 01 550 00 Motor Vehicle Purchases 207 49007 01 551 00 Motor Vehicle Purchases 207 49007 01 552 00 Motor Vehicle Purchases 207 49007 01 553 00 Motor Vehicle Purchases 207 49007 01 554 00 Motor Vehicle Purchases 207 49007 01 555 00 Motor Vehicle Purchases 207 49007 01 580 00 Other Equipment Purchases 207 49007 01 581 00 Other Equipment Purchases 207 49007 01 582 00 Other Equipment Purchases 207 49007 01 583 00 Other Equipment Purchases 207 49007 01 584 00 Other Equipment Purchases 207 49007 01 585 00 Other Equipment Purchases 207 49007 01 586 00 Computer Equipment Purchases 207 49007 01 587 00 Computer Equipment Purchases 207 49007 01 588 00 Computer Equipment Purchases 207 49007 01 589 00 Computer Equipment Purchases 207 49007 01 590 00 Computer Equipment Purchases 207 49007 01 601 00 Principal on Lease Payments 207 49007 01 601 01 1995 10 -Year Equipment Lease 207 49007 01 601 02 1996 10 -Year Aerial Truck Lease 207 49007 01 601 03 2001 10 -Year Equipment Lease 207 49007 01 611 00 Interest on Lease Payments 207 49007 01 611 01 1995 10 -Year Equipment Lease 207 49007 01 611 02 1996 10 -Year Aerial Truck Lease 207 49007 01 611 03 2001 10 -Year Equipment Lease FUND TOTALS $721,10 4,16 47 30 34,07 10,95 $541,10 4,73 301 877 0 6,350 11,000 0 $433,600 $250,90 0 0 0 19,745 4,70 0 509 40 500 0 2,650 6 00 11,000 0 0 1,526,557 335,00 $771,089 $564,364 $1 994,561 $597,000 2003 2004 2005 Account Description Actual Actual Actual $2,50 $2,50 29,71 60,00 24,53 1,82 74,87 68,54 27,28 20,47 27,87 44,29 85,00 5,68 4,02 5,00 7,13 5,87 5,26 36,32 12,81 10,10 5,00 50,87 50,53 49,99 39,99 8,00 167,94 23,05 22,34 54,48 77,78 63,018 2,30 3,01 10,40 37,56 $2,5 5,32 25,00 832,25 39,33 $2,50 335,00 46,00 13,30 5,00 10,00 2,86 22,00 4,62 4,00 5,82 10,00 6,92 50,00 70,23 50,00 2006 2007 Object 2007 Adopted Detail Proposed Budget Amount Budget 48,369 0 0 57,758 61,225 0 670,765 0 0 2,349 0 0 7,139 3,675 0 40,684 0 0 $710,080 $517,865 $1,840,259 $594,400 NOTE 2007's Proposed Budget Includes $2,500 for General Fund Admin Fees Not Included in Levy Amount (Covered by Interest Earnings) 2007'5 Proposed Budget has a Total of $303,000 for the Levy Amount $303 00 4,70 30 9,00 524,00 $841 000 2006 2007 Object 2007 Adopted Detail Proposed Budget Amount Budget $2,50 524,00 92,00 20,00 7,00 18,00 15,00 60,00 10,00 40,00 50,00 5838,500 Comments 4 Squads (Sell Back 3) Equipment Certificate Issue Comments Yearly Fee Per Policy F -3 2005 Equipment Certificate Issue 2006 Equipment Certificate Issue 2007 Equipment Certificate Issue 2 Squads (Sell Back 2) "Welcome to Rosemount" Signs Department Issued Handguns Equipment for New Squad Emergency Equip for Squads DCC Capital Costs (Year 1 of 7) PC Printer Replacements PC Workstation Upgrades City-Wide Software Paid off in 2005 Paid off in 2006 Paid off in 2005 Equip Cert 0 Paid off in 2005 Paid off in 2006 Paid off in 2005 Equip Cert Savings of 5115,400 for 2001 L/F i 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007 2007! 200/ 2007 2007 20071 2007 2007 2007 1 20 2007 2007 2007 g v ww »NNN�.,w N cio Totals Well #15 Construction Grano Box for Utility Vehicle #942) Sweeper(Replace #443) Pavement Management Program Street Reconstruction County Road 73 (CR 42 to 135th Street) Inspection Vehicle (Replace #308) Inspection Vehicle (Replace #300) Pickup (Replace #345) 1 -Ton Pickup (Replace #344) 1 -1 on PickuL(Replace #342) PW Butldinq Addition Lease/Purchase (Year 9 of 20) County Road 42 US Highway 52 (Design Costs) Nadia Communications Upgrades 600 MI IZ 4 Squads (Sell Back 3 #320, 440 480 1 New) Equipment New Squad DCCCs UGC Capital Cm(s Year 1 of 7) !Department tssued l handguns Umergency Equipment for Squads Installation Construct Athletic Complex 3 New Padv Units Parks Master Plan Update 0ons(ruchan at Parking Lot for Disc Golf Course New Neighborhood Park Design (N -1) Misrellaneous Park Improvements Radio Replacements (Replace Obsolete) 1 City -Wide Software LPC Workstation Upgrades (From 2003) "Welcome to Rosemount" Signs 2005 Equipment Certificates (5- Years) `Paint Ceding item- Description Pub Works Pub Works Pub Works Pub Works Pub Works nonn gggg I Pub Works_ Pub Works Police Poore Police Police Police Police Police Park Rec Park Rec Park Rec Park Rec Park Roc Park Rec an eitMOU acueuy liaallo'J Comm Dev Council (Arena De anent 24,000 24POo ow. 1 1,050,000 Pc SE 1 50,000 n 9 it 303 000 03,000 16,0001 60,000 7,000 15,0001 50 000 10 000 40,000 on 9C 3 1,000,000 o Assess 488,000 30,0001 420,000 15,000 15,000 Park Imp_, Fund 600,000 i m3 °D 1,250,000 1,250,000 0 03 000 I I 850,000 ci Storm Core 766,500 625,000 15,000 o 10,000 183,500 16 000 00 1 0 10,coa I 131,000 16,000 0 CN 5 431,1')3 349,195 87 955 0 IF,' 2 11,957,500 I 160,000 88882 140,000 I 9,000 5,000,000 7,500 4,500,000 135,000 Other 47,000' 1 x1111 =1111 MEM 19,242,653 1,250,000 I 625,000 1 850,000 48,000 160,000 WO.... 44,000 i 50 000 1 15,000 18,000 60,000 140,000 92,000 5 000,000 7,500 7,000 000 000'0Zb 000 00 15,00 15,000 Total Cost 47 000 20,000 349,108 87,9551 10,000 40,000 135,000 50 000 0,000 Page One December 4, 2006 2003 2004 Account Description Actual Actual 206 31010 00 206 33100 00 206 36210 00 206 36214 00 206 36215 00 206 36260 00 Account Current Ad Valorem Taxes Federal Grants Ads Interest Earnings- Investments Net Change in FV- Investments Interest Earnings Other Revenue FUND TOTALS Description 206 49006 01 221 00 Equipment Pails 2007 BUDGET WORKSHEETS INSURANCE REVENUES INSURANCE EXPENDITURES 206 49006 01 304 00 Legal Fees 206 49006 01 305 00 Medical Dental Fees 205 49006 01 317 00 General Fund Administrative Fees 206 49006 01 319 00 Other Professional Services 206 49006 01 355 00 Worker's Comoensatron Insurance 206 49006 01 359 00 Other Insurance 206 49006 01 409 00 Other Contracted Repair Kant 206 49006 01 439 00 Other Miscellaneous Charges FUND TOTALS $210,000 $225,000 $255000 $260,000 $260 000 0 0 0 0 0 6,735 4,044 12,452 5,000 5,000 0 0 0 0 0 Annual Market Value Changes 240 397 401 500 500 30,749 34,443 40,083 26,000 22,000 Insurance Refunds /Drvrdends 249,724 263,884 307,936 291,500 287,500 2003 2004 2005 Actual Actual Actual $1,096 577 $232 $2,000 0 3,981 0 3,000 3,489 3,916 3,517 15 000 2,500 2,500 2,500 2500 23 010 16560 16,970 25,000 77,887 76,884 61,648 80,000 141,686 131,841 133,147 155000 2006 2007 Object 2007 2005 Adopted Detail Proposed Actual Budget Amount Budget NOTE Levy of $260,000 covers costs for consultant fees and all insurance premiums All other expenditures covered through interest earnings and insurance refundsldrvidends 2006 2007 Object 2007 Adopted Detail Proposed Budget Amount Budget $,000 10,000 2, 500 20,000 75,000 165,000 Comments Comments $2,000 Liability Auto Deductible Pymts Unreimbursable Legal Fees Work Comp Deductible Pymts Yearly Fee Per Policy F -3 Risk Management Consultant Annual Premium Annual Premium General Liability 11,445 6,431 11677 9,000 10 000 Liability Auto Deductible Pymts 0 0 0 0 0 261,114 242,169 229,691 291,500 287,500 Page One September 19, 2006 Account Description 201 31010 00 201 31050 00 201 33130 00 201 33425 00 201 34109 00 201 36105 00 201 36210 00 201 36211 00 201 36212 00 201 36215 00 201 36230 00 201 3626000 201 36265 00 201 39101 00 Account 2007 BUDGET WORKSHEETS PORT AUTHORITY REVENUES Current Ad Valorem Taxes Tax Increments Federal Grants -CDBG Other Stale Grants Aids Other Charges for Services Principal on Notes Interest Earnings Investments Interest Earnings Loch Interest Earnings Blake Interest Earnings Contribution /Donations Other Revenue Use of Reserve Funds Sales of General Fixed Assets FUND TOTALS Description EXPENDITURES 201 46300 99 103 00 Part -Time Salaries Benefits 201 46300 01 303 00 Engineenng Fees 201 46300 01 304 00 Legal Fees 201 46300 01 307 00 Managment Fees Air Cargo 201 46300 01 313 00 Temporary Service Fees 201 46300 01 315 00 Special Programs Downtown 201 46300 01 315 01 Downtown Planning Consultant 201 46300 01 315 02 Downtown Communications Plan 201 46300 01 315 03 Downtown Ombudsman 201 46300 01 315 04 Downtown Design Standards 201 46300 01 315 05 Downtown Markel Study Update 201 46300 01 317 00 General Fund Administrative Fees 201 46300 01 319 00 Other Professional Services 201 46300 01 319 01 Project Management Consultant 201 46300 01 319 02 Marketing 201 46300 01 319 03 County TIF Charges 201 46300 01 319 04 PIA Property Tax Payments 201 46300 01 322 00 Postage Costs 201 46300 01 349 00 Other Advertising 201 46300 01 351 00 Legal Notices Publishing 201 46300 01 359 00 Other Printing Binding Costs 201 46300 01 365 00 Workers Comp Insurance 201 46300 01 369 D0 Other Insurance 201 46300 01 381 D0 Electric Utilities 201 46300 01 389 00 Other Util,ty Services 201 46300 01 521 00 Building Structure Purchases 201 46300 01 525 00 Building Structure Purchases 201 46300 01 530 OD Improvements Other Than Bldgs 201 46300 01 710 00 Transfers FUND TOTALS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $0 0 13,403 0 50,00 0 433,041 39,83 5,002 4,26 1,966 8,066 7,50 286 30 0 18,000 0 0 5477,764 $101,910 5128,599 $129,900 $159,900 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $3,18 6,58 36 1,19 9,55 6,00 69,36 3,01 41 $3,71 3,47 3,3 28,45 30,92 7,17 5,04 6,00 33 8,53 9,90 93 94 51 48 2,13 2,72 11 14 28 50 201 46300 01 433 00 Dues Subscriptions 49 15,40 201 46300 01 433 01 Professional Organizations /Journals 201 46300 01 433 02 Foreign Trade Zone Commission 201 46300 01 437 00 Conferences Seminars 201 46303 01 439 00 Other Miscellaneous Charges 528 3,043 1,229 0 0 425,532 0 0 9,950 4,398 0 0 $60,00 41,51 42,30 2,81 2,00 6,99 6,30 $3,14 27 40 15,00 18,90 4,74 52 6,00 98 1148 3,24 88 19 36 2,22 17 66 448 15,000 4,403 457 0 67,000 0 0 $60,00 $5,00 5,00 25,00 6,00 25,00 10,00 4,00 3,00 11,00 20 10,00 50 4,00 20 1,00 1,500 15,000 3,000 500 0 0 0 0 0 0 0 0 0 15,000 10,000 4,000 0 1,500 15,000 36,40 2,00 6,00 40 115,10 $114,911 $561,048 $121,943 $129900 $159,900 Comments Operating Levy Admin Fees Portion Only LCDA Downtown Grant Blake DT Lease Interest Earned on CD's Paid Off in 2003 Blake L/T Lease Interest Checking Interest Misc Comments All Salary Costs Inclusive of $5,000 Salary, Taxes, PERA Benefits Port Authority Members 5,000 15 000 50,000 (EIS) or (AUAR) 0 0 6,000 Yearly Fee Per Policy F -3 29,000 3,000 11,000 Additional Marketing 200 10,000 500 Commissioners 4,000 Property Insurance 200 Business Park Sign 1,000 Stormwater Fees 16,500 Prof Organizations /Journals 3,000 Development/TIF/Miscellaneous 500 Contingencies 0 0 0 Special Downtown Projects 0 Page One September 19, 2008 Account 2007 BUDGET WORKSHEETS ENDRES PROCESSING DISTRICT(0089) REVENUES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Description Actual Actual Actual Budget Amount Budget EXPENDITURES Comments 244 31050 00 Tax Increments $31,039 $27,193 $24,780 $27,000 $25,000 Endres Processing District Only 244 36215 00 Interest Earnings 0 0 0 244 36260 00 Other Revenue 0 0 0 FUND TOTALS $31,039 $27,193 $24,780 $27,000 $25,000 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 244 49044 01 530 00 Improvements Other Than Bldgs $31,039 $27,193 $24,780 $27,000 $25,000 244 49044 01 530 00 Endres Processing -Pay as You Go 27,000 FUND TOTALS $31 039 $27,193 $24 780 $27,000 $25,000 Page One September 19, 2006 Account 242 31050 00 242 36210 00 242 36215 00 2007 BUDGET WORKSHEETS DOWNTOWN /BROCKWAY DISTRICT(0108) REVENUES Description Tax Increments Interest Earnings Investments Interest Earnings FUND TOTALS Account Description 242 49042 01 319 00 Other Professional Services 242 49042 01 522 00 Building Structure Purchases 242 49042 01 530 00 Improvements Other Than Buildings 242 49342 D1 611 00 Interest on Internal Loan FUND TOTALS EXPENDITURES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget Comments $0 $o $0 $0 $50,000 0 152 1,217 0 0 0 75 157 0 0 SD $227 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget 50 515,659 556,880 $0 50 0 161,491 194,590 0 0 0 0 0 0 50,000 Pay -As -You Go to CPDC 0 0 17,785 0 0 50 $197,151 $269,255 $0 $1,374 $0 550,000 550,000 Comments 49) Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 614 G 0 STORM WATER REVENUE BONDS, 1996B REVENUES- December 4, 2006 Account Description Actual Actual Actual Budget Budget 614 31010 00 Current Ad Valorem Taxes 614 36101 00 Principal Special Assessments 614 36102 00 Penalties Interest S/A 614 36210 0D Interest Earnings Investments 2,07 614 36215 00 Interest Earnings 6 614 36265 00 Use of Reserve Funds 614 37145 00 Surcharge on Water Revenues 614 37160 00 Penalties Surcharge Revenues 614 39202 00 Contribution From Enterprises 50,00 614 39203 00 Transfer From 128,39 614 39204 00 Transfer From Water Core 614 39205 00 Transfer From Sewer Core 614 39206 00 Transfer From Storm Core 50,00 614 39207 00 Transfer From Port Authority 614 39310 00 Bond Proceeds 614 47000 01 710 00 Transfers FUND TOTALS $230,553 3104,606 $105,514 $101,000 $104,000 FUND TOTALS EXPENDITURES 614 47000 01 317 00 General Fund Admin Fees 614 47000 01 319 D0 Other Professional Services 2006 2007 2003 2004 2005 Adopted Proposed 2,56 5,46 3 4 51,00 50,00 51,00 50,00 50,50 52,00 50,50 52,00 Comments 2006 2007 2003 2004 2005 Adopted Proposed Account# Descnption Actual Actual Actual Budget Budget Comments $o $0 $0 $0 $0 0 0 0 0 0 614 47000 01 601 00 Bond Principal 60 000 65,000 65,000 70,000 75,000 614 47000 01 611 DO Bond Interest 38,496 35,273 31,964 29,900 26,100 614 47000 01 614 00 Amortization of Bond Discount 817 817 617 900 900 614 47000 01 621 00 Bond Paying Agent Fees 193 193 193 200 200 0 0 0 0 0 $99,509 $101,284 $97,974 $101,000 $102,200 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 384 G O. PORT AUTHORITY MUNICIPAL BUILDING REFUNDING BONDS, 1996A REVENUES December 4, 2006 Account Description Actual Actual Actual Budget Budget 384 31010 00 384 36101 OD 384 36102 OD 384 36210 00 384 36215 00 384 36265 00 384 37145 00 384 39101 00 364 39202 00 384 39203 00 384 39204 00 384 39205 00 384 39206 00 384 39207 00 384 39310 00 384 47000 01 317 00 General Fund Admin Fees 384 47000 01 319 00 Other Professional Services 384 47000 01 710 00 Transfers Current Ad Valorem Taxes Principal Special Assessments Penalties Interest S/A Interest Earnings Investments Interest Earnings Use of Reserve Funds Surcharge on Water Revenues Sale of General Fixed Assets Contribution From Enterprises Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Port Authority Bond Proceeds FUND TOTALS EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed $348,50 58,47 3 156,65 $368,18 4,34 3 $383,51 8,02 3 $255,3 $258,95 FUND TOTALS $563,663 $372,563 $391,576 $255,384 $258 957 2006 2007 2003 2004 2005 Adopted Proposed Account# Description Actual Actual Actual Budget Budget o o $o $0 0 0 0 0 0 384 47000 01 601 OD Bond Principal 1,620,000 125,000 135,000 135,000 145,000 Refunding for 1992E Paid 2/1103 384 47000 01 611 00 Bond Interest 115,663 112,925 107,268 101,300 95 000 384 47000 01 621 00 Bond Paying Agent Fees 705 0 0 0 0 0 0 0 0 0 $1,736368 $237,925 $242,268 $236,300 $240,000 Comments Comments Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 332 G 0 IMPROVEMENT BONDS, 1998A REVENUES- December 4, 2006 Account Descrip'ion 332 31010 0D 332 36101 00 332 36102 00 332 36210 00 332 36215 00 332 36265 00 332 37145 00 332 37160 00 332 39202 00 332 39203 00 332 39204 00 332 39205 00 332 39206 00 332 39207 00 332 39310 00 Account# 332 47000 01 317 00 332 47000 01 319 00 332 47000 01 601 00 332 47000 01 611 00 332 47000 01 621 03 332 4700D 01 710 00 Current Ad Valorem Taxes Pnncipal Special Assessments Penalties 8 Interest S/A Interest Earnings Investments Interest Earnings Use of Reserve Funds Surcharge on Water Revenues Penalties Surcharge Revenues Contrbution From Enterprises Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Pon Authordy Bond Proceeds FUND TOTALS FUND TOTALS EXPENDITURES Descnption General Fund Admin Fees Other Professional Services Bond Principal Bond Interest Bond Paying Agent Fees Transfers 2003 Actual 103,34 116,06 64,89 25 6,89 1,94 12,05 17,09 12,36 16 4 2 94,10 $209,91 2006 2007 2004 2005 Adopted Proposed Actual Actual Budget Budget 226,00 5 212 00 $140,103 579,250 5226,00 $212,000 2006 2003 2003 2005 Adopted Actual Actual Actual Budget Comments 2007 Proposed Budget Comments 0 $0 $0 $0 $0 0 0 0 0 0 205,000 200,000 195,000 195,000 190,000 55,820 47,215 38,674 30,100 21,500 771 1,046 526 900 500 0 D 0 0 0 5261,591 $246,261 $234,200 $226,000 $212,000 Page One December 4, 2006 Account 335 31010 00 Current Ad Valorem Taxes 335 36101 00 Principal Special Assessments 696,96 335 36102 00 Penalties Interest SIA 36 335 36210 00 Interest Earrings Investments 30,95 335 36215 00 Interest Earnings 57 335 36260 00 Other Revenue 335 36265 00 Use of Reserve Funds 335 37145 00 Surcharge on Water Revenues 335 37160 00 Penalties Surcharge Revenues 335 39202 00 Contnbuuon From Enterprises 335 39203 00 Transfer From 335 39204 00 Transfer From Water Core 335 39205 00 Transfer From Sewer Core 335 39206 00 Transfer From Storm Core 335 39207 00 Transfer From Port Authority 335 39310 00 Bond Proceeds Account 2007 BUDGET WORKSHEETS DEBT SERV FUND 335 G 0 IMPROVEMENT BONDS, 1999A REVENUES FUND TOTALS Descrpton 335 47000 01 317 00 General Fund Admin Fees 335 47000 01 319 00 Other Professional Services 335 47000 01 710 00 Transfers 2006 2007 2003 2004 2005 Adopted Proposed Description Actual Actual Actual Budget Budget Comments FUND TOTALS EXPENDITURES 33,91 24,56 4 36 32,36 30,99 4 328,60 $728,860 $58,907 $63,411 $328,600 $312,200 312,20 2006 2007 2003 2004 2005 Adopted Proposed Actual Actual Actual Budget Budget Comments $0 $0 $0 $0 $0 0 0 0 0 0 335 47000 01 601 00 Bond Principal 495,000 485,000 475,000 265,000 260,000 335 47000 01 611 00 Bond Interest 120,768 99,698 79,058 63,200 51,800 335 47000 01 621 00 Bond Paying Agent Fees 403 403 403 400 400 0 0 0 0 0 $616,170 $585,100 $554,460 $328 600 $312,200 tr. Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 336 G 0 IMPROVEMENT BONDS, 19990 REVENUES December 4, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 336 31010 00 Current Ad Valorem Taxes $16,43 $19,05 $19,61 336 36101 00 Pnnapal Special Assessments 21,29 69,94 99,25 336 36102 00 Penalties Interest S!A 17 1 3,82 336 36210 00 Interest Earnings Investments 72,48 67 89 44,41 336 36215 00 Interest Earnings 25 8 5 336 36265 0D Use of Reserve Funds 336 37145 00 Surcharge on Water Revenues 336 37160 00 Penalties Surcharge Revenues 336 39202 00 Contribution From Enterprises 336 39203 00 Transfer From 192,63 336 39204 00 Transfer From Water Core 336 39205 00 Transfer From Sewer Core 336 39206 00 Transfer From Storm Core 336 39208 00 Transfer From Street CIP 336 39310 00 Bond Proceeds FUND TOTALS $110,64 EXPENDITURES 336 47000 01 317 00 General Fund Admin Fees 336 47000 01 319 00 Other Professional Services $349,631 $167 15 $14,86 747,71 $762,60 $19,53 261,96 $261,500 2006 2007 2003 2004 2005 Adopted Proposed Account Descnption Actual Actual Actual Budget Budget $0 $0 $0 $0 $0 0 0 0 0 0 336 47000 01 601 00 Bond Pnncopal 600,000 625,000 655,000 685,000 225,000 336 47000 01 611 00 Bond Interest 162,868 136,218 107,730 77,300 56,200 336 47000 01 621 00 Bond Paying Agent Fees 306 316 316 300 300 336 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $763,173 $761,534 $763,046 $762,600 $281,500 Comments Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 616 G.0 STORM WATER REVENUE BONDS, 1999C REVENUES- December 4, 2006 Account 616 31010 00 616 36101 00 616 36102 00 616 36210 00 616 36215 00 616 36260 00 616 36265 00 616 37145 00 616 37160 00 616 39202 00 616 39203 DO 616 39204 00 616 39205 00 616 39206 00 616 39207 00 616 39310 00 Account 616 47000 01 317 00 616 47000 01 319 00 616 47000 01 601 00 616 47000 01 611 00 616 47000 01 61400 616 47000 01 621 00 616 47000 01 710 00 Description Current Ad Valorem Taxes $0 Principal Special Assessments 0 Penalties Interest S/A 0 Interest Earnings Investments 6,165 10,31 Interest Earnings 61 4 Other Revenue Use of Reserve Funds Surcharge on Water Revenues Penalties Surcharge Revenues Contribution From Enterprises 42,00 41,00 42,00 41,50 43,00 Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core 42,00 41,00 42,00 41,50 43,00 Transfer From Port Authority Bond Proceeds FUND TOTALS $90,22 $87,06 $94 356 $83,000 $86 000 Description General Fund Admin Fees Other Professional Services Bond Pnncipal Bond Interest Amortization of Bond Discount Bond Paying Agent Fees Transfers FUND TOTALS EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed Actual Actual Actual Budget Budget Comments 2006 2007 2003 2004 2005 Adopted Proposed Actual Actual Actual Budget Budget $o 0 4,94 3 7 $o 0 $0 0 Comments 0 $0 0 0 45,000 45,000 50,000 50,000 55,000 36,944 34,829 32,498 31,200 26,700 1,103 1,103 1,103 1,100 1,100 403 403 403 700 400 0 0 0 0 0 $83,450 $81,334 $64,004 $83,000 $85,200 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 617 G 0 WATER REVENUE BONDS, 2000A REVENUES- December 4, 2006 Account# Description Actual Actual Actual Budget Budget Comments 617 31010 DO 617 36101 00 617 36102 D0 617 36210 00 617 36215 00 617 36265 00 617 37145 00 617 37160 00 617 39202 00 617 39203 00 617 39204 00 617 39205 00 617 39206 00 617 39207 00 617 39310 00 617 47000 01 317 00 General Fund Admin Fees 617 47000 01 319 00 Other Professional Services 617 47000 01 710 D0 Transfers Current Ad Valorem Taxes Principal Special Assessments Penalties Interest S/A Interest Earnings Investments Interest Earnings Use of Reserve Funds Surcharge on Water Revenues Penalties Surcharge Revenues Contribution From Erterprises Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Port Authority Bond Proceeds FUND TOTALS EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed 2 3 98,41 111,00 FUND TOTALS $209,67 6 2 112,00 2,65 42 115,00 113,00 115 00 $112 825 $116,092 $113,00 $115,000 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments $0 $0 $0 $0 $0 0 0 0 0 0 617 47000 01 601 00 Bond Principal 55,000 60,000 65,000 65,000 70,000 617 47000 01 611 00 Bond Interest 53,465 50,755 47,819 46,100 43,000 617 47000 01 614 00 Amortization of Bond Discount 1,351 1,351 1,351 1,400 1,400 617 47000 01 621 D0 Bond Paying Agent Fees 316 316 316 500 600 0 0 0 0 0 $110,132 $112,452 $114,487 $113,000 $115,000 Page One December 4, 2006 Account Description Actual Actual Actual Budget Budget 337 31010 00 337 36101 00 337 36102 00 337 36210 00 337 36215 00 337 36265 00 337 37145 00 337 37160 00 337 39202 00 337 39203 00 337 39204 00 337 39205 00 337 39206 00 337 39208 00 337 39310 00 2007 BUDGET WORKSHEETS DEBT SERV FUND 337 G.O IMPROVEMENT BONDS, 2001A REVENUES Account# Current Ad Valorem Taxes $0 $116,06 Principal Special Assessments 72,248 14,16 Penalties Interest SA 141 1 Interest Earnings Investments 2,361 4,56 Interest Earnings 57 2 Use of Reserve Funds 0 Surcharge on Water Revenues 0 Penalties Surcharge Revenues 0 Contribution From Enterprises 0 Transfer From 141,684 Transfer From Water Core 154,000 170,00 Transfer From Sewer Core 0 Transfer From Storm Core 0 Transfer From Street CIP 0 Bond Proceeds 0 EXPENDITURES 337 47000 01 317 00 General Fund Admin Fees 337 47000 01 319 00 Other Professional Services 2006 2007 2003 2004 2005 Adopted Proposed 13,53 12,45 3 166,00 168,00 FUND TOTALS $370,491 $304,854 $192,016 $166 00 2006 2007 2003 2004 2005 Adopted Proposed Descnpbon Actual Actual Actual Budget Budget Comments 337 47000 01 601 00 Bond Principal 105,000 125,000 125,000 130,000 130,000 337 47000 01 611 00 Bond Interest 48,880 45,274 41,118 36,700 31 900 337 47000 01 621 00 Bond Paying Agent Fees 374 403 403 1,300 400 337 47000 01 710 00 Transfers 0 0 0 0 163,00 $163,000 Comments $0 $0 $0 $0 $0 0 0 0 0 0 0 FUND TOTALS $154,254 $170,676 $166,520 $168,000 $162,300 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 612 G O. STORM WATER REVENUE BONDS, 2001B REVENUES December 4, 2006 Account Description Actual Actual Actual Budget Budget 612 31010 00 612 36101 00 612 36102 00 612 36213 00 612 36215 00 612 36265 00 612 37145 00 612 37160 00 612 39202 00 612 39203 OD 612 39204 00 612 39205 00 612 39206 00 612 39207 00 612 39310 00 Current Ad Valorem Taxes Principal Special Assessments Penalties Interest S/A Interest Earnings Investments Interest Earnings Use of Reserve Funds Surcharge on Wa'er Revenues Penalties Surcharge Revenues Contribution From Enterprises Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Port Authority Bond Proceeds FUND TOTALS 2006 2007 2003 2004 2005 Adopted Proposed Account# Descnption Actual Actual Actual Budget Budget Comments 612 47000 01 317 00 General Fund Admin Fees 612 47000 01 319 00 Other Professional Services 612 47000 01 601 00 Bond Pnncipal 40,000 60,000 60,000 65,000 65,000 612 47000 01 611 00 Bond Interest 48,185 45,851 43,451 42,000 39,400 612 47000 01 614 00 Amortization of Bond Discount 1,303 1 303 1,303 1,300 1,300 612 47000 01 621 00 Bond Paying Agent Fees 374 805 403 1,700 300 612 47000 01 710 00 Transfers FUND TOTALS EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed 12 11 2,60 4 3 1 45,00 54,0D 53,00 153,76 45,00 54,00 53,00 55,00 53,00 55,00 53,00 $90,16 $261,912 $108,81 $110 00 6106,000 Comments so so $o $o $0 0 0 0 0 0 0 0 0 0 0 $89,662 $107,959 $105,156 $110,000 $106,000 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 382 G 0 PORT AUTHORITY PUBLIC FACILITY BONDS, 2001C REVENUES December 4, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account# Description Actual Actual Actual Budget Budget Comments 382 31010 00 Current Ad Valorem Taxes 382 36101 DO Principal Special Assessments 382 36102 00 Penalties Interest SIA 382 36210 DO Interest Earnings Investments 382 36215 OD Interest Earnings 382 36265 00 Use of Reserve Funds 382 37145 00 Surcharge on Water Revenues 382 39101 00 Sale of General Fixed Assets 382 39202 00 Contribution From Enterpnses 382 39203 00 Transfer From 382 39204 00 Transfer From Water Core 382 39205 00 Transfer From Sewer Core 382 39206 00 Transfer From Storm Core 382 39207 00 Transfer From Port Authority 382 39310 00 Bond Proceeds EXPENDITURES $170,60 1,84 2 $172, 2,18 2 $169,764 $171,06 3,07 3 $168,50 FUND TOTALS $172,473 $175,119 $172,665 $171,864 $168 504 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget 362 47000 01 317 00 General Fund Admin Fees 382 47000 01 319 00 Other Professional Services $D $0 $0 $0 $0 0 0 0 0 0 382 47000 01 601 00 Bond Principal 25,000 70,000 75,000 75,000 60,000 382 47000 01 611 00 Bond Interest 92,980 91,080 86,180 85,200 62,100 382 47000 01 621 00 Bond Paying Agent Fees 374 403 403 400 400 382 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $118,354 $161,483 5163,583 $160,600 $162,500 Comments Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 618 G 0 STORM WATER REVENUE REFUNDING BONDS, 2001D REVENUES- December 4, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 618 31010 00 Current Ad Valorem Taxes 618 36101 00 Pnncipal Special Assessments 618 36102 D0 Penalties Interest S/A 618 36210 00 Interest Earnings Investments 3 3 4 616 36215 00 Interest Earnings 5 4 5 618 36265 00 Use of Reserve Funds 618 37145 00 Surcharge on Water Revenues 618 39101 00 Sale of General Fixed Assets 618 39202 00 Contribution From Enterprises 74,00 77,00 75,00 77,50 75,00 618 39203 00 Transfer From 618 39204 00 Transfer From Water Core 618 39205 00 Transfer From Sewer Core 618 39206 00 Transfer From Storm Core 74,00 77,00 75,00 77,50 75,00 618 39207 00 Transfer From Port Authonty 618 39310 00 Bond Proceeds FUND TOTALS $148,082 $154,07 $150 09 $155,00 5150,000 EXPENDITURES 616 47000 01 317 00 General Fund Admin Fees 618 47000 01 319 00 Other Professional Services 2008 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments $0 $0 $0 $0 50 0 0 0 0 0 618 47000 01 601 00 Bond Principal 120,000 130,000 130,000 140,000 140,000 618 47000 01 611 00 Bond Interest 24,870 21,045 16,668 13,800 8600 618 47000 01 621 00 Bond Paying Agent Fees 374 374 374 1,200 400 618 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS 5145,244 5151 419 $147,042 $155,000 5149,000 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 304 G O. COMMUNITY CENTER REFUNDING BONDS, 2001E REVENUES December 4, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 304 31010 00 Current Ad Valorem Taxes 304 36101 00 Principal Special Assessments 304 35102 00 Penalties Interest S/A 304 36210 OD Interest Earrings Investments 304 36215 00 Interest Earnings 304 36265 00 Use of Reserve Funds 304 37145 00 Surcharge on Water Revenues 304 391 01 00 Sale of General Fixed Assets 304 39202 00 Contrbution From Enterprises 304 39203 00 Transfer From 304 39204 00 Transfer From Water Core 304 39205 00 Transfer From Sewer Core 304 39206 00 Transfer From Storm Core 304 39207 00 Transfer From Port Authonty 304 39310 00 Bond Proceeds FUND TOTALS EXPENDITURES 304 47000 01 317 DO General Fund Admin Fees 304 47000 01 319 00 Other Professional Services $93,44 8,49 1 59,87 $96,744 $99,87 0 0 1,241 1,46 3 4 $91,94 2,35 FUND TOTALS $161,835 $98,022 $101,389 $94,30 $94,70 $94,704 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget $o $o $o $o $o 0 0 0 0 0 304 47000 01 601 00 Bond Principal 0 60,000 65,000 70,000 65,000 304 47000 01 611 00 Bond Interest 26,998 28,068 26,130 23,900 21 400 304 47000 01 621 00 Bond Paying Agent Fees 374 374 374 400 400 304 47000 01 710 00 Transfers 0 0 0 0 0 $29,371 $86,441 $91,504 $94,300 $66,800 Comments Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 338 G 0 IMPROVEMENT BONDS, 2002A REVENUES- December 4, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 338 31010 00 Current Ad Valorem Taxes $0 $0 338 36101 00 Principal Special Assessments 623,681 661,799 672,93 338 36102 00 Penalties Interest S/A 12 581 2,38 338 36210 00 Interest Earnings Investments 1,991 3,74 6,75 338 36215 00 Interest Earnings 4 2 5 338 36265 00 Use of Reserve Funds 338 37145 00 Surcharge on Water Revenues 336 37160 00 Penalties Surcharge Revenues 338 39202 00 Contribution From Enterprises 338 39203 00 Transfer From 154,26 338 39204 OD Transfer From Water Core 338 39205 00 Transfer From Sewer Core 336 39206 OD Transfer From Storm Core 336 39208 00 Transfer From Street CIP 338 39310 00 Bond Proceeds FUND TOTALS $780,012 $686,15 EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget 338 47000 01 317 00 General Fund Admin Fees 338 47000 01 319 D0 Other Professional Services $6,91 688,98 $10,77 650,52 $682,115 $695,900 $661,300 Comments $o $o $o $o so 0 0 0 0 0 338 47000 01 601 00 Bond Principal 0 630,000 655,000 635,000 620,000 336 47000 01 611 00 Bond Interest 110,649 95,050 78,956 60,500 40 900 336 47000 01 621 00 Bond Paying Agent Fees 374 374 374 400 400 338 47000 01 710 00 Transfers D 0 0 0 0 FUND TOTALS $111023 $725,424 $734,330 $695,900 $661,300 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 619 G 0 WATER 8 STORM WATER REVENUE BONDS, 20028 REVENUES- December 4, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 619 31010 00 Current Ad Valorem Taxes 619 36101 00 Principal Special Assessments 28,26 619 36102 00 Penalties Interest S.'A 619 36210 00 Interest Earnings Investments 1 8 619 36215 00 Interest Earnings 4 619 36265 00 Use of Reserve Funds 619 37145 00 Surcharge on Water Revenues 619 37160 00 Penalties Surcharge Revenues 619 39202 00 Contribution From Enterprises 15,00 619 39203 0D Transfer From 619 39204 00 Transfer From Water Core 26,00 619 39205 00 Transfer From Sewer Core 619 39206 00 Transfer From Storm Core 15,0 619 39207 00 Transfer From Port Authority 619 39310 00 Bond Proceeds FUND TOTALS 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 619 47000 01 317 00 General Fund Admin Fees 619 47000 01 319 00 Other Professional Services 619 47000 01 601 00 Bond Principal 0 40,000 50,000 70,000 70 000 619 47000 01 611 00 Bond Interest 46,809 45,708 44,233 43,100 41,000 619 47000 01 614 00 Amortization of Bond Discount 1,441 1,441 1,441 1,500 1,500 619 47000 01 621 00 Bond Paying Agent Fees 374 374 374 400 500 619 47000 01 710 00 Transfers FUND TOTALS EXPENDITURES $0 (12,19) 7,658 4 15 22 725 2 54 17,00 19,00 29,00 29,00 64,00 56,00 57,00 56,0 17,00 19,00 29,00 29,00 $84,490 $66,098 $104,651 $115,000 $114,000 $0 $0 $0 $0 $0 0 0 0 0 0 0 0 0 0 0 $45,623 $67,522 $96,047 $115,000 $113,000 61 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 385 G 0 PORT AUTHORITY BONDS (HIGHWAY 31, 2002C REVENUES December 4, 2006 2005 2007 2003 2004 2005 Adopted Proposed Account Descnption Actual Actual Actual Budget Budget Comments 385 31010 00 Current Ad Valorem Taxes $283,15 $272,94 385 36101 00 Principal Special Assessments 31,97 30,18 385 36102 00 Penalties Interest S/A 12 385 36210 00 Interest Earnings Investments 1,28 4,15 385 36215 00 Interest Earnings 2 4 385 36265 00 Use of Reserve Funds 385 37145 00 Surcharge on Water Revenues 385 39101 00 Sale of General Fixed Assets 385 39202 00 Contribution From Enterprises 26,00 26,00 385 39203 00 Transfer From 252,20 365 39204 00 Transfer From Water Core 385 39205 00 Transfer From Sewer Core 385 39206 00 Transfer From Storm Core 385 39207 00 Transfer From Port Authonty 385 39310 00 Bond Proceeds FUND TOTALS $368,441 $611 653 $366,86 $315,816 $308,650 EXPENDITURES 385 47000 01 317 00 General Fund Admin Fees 365 47000 01 319 00 Other Professional Services 26,00 26,000 0 0 $267,02 36,42 B 11,30 2 26,00 25,00 25 00 26,00 25,00 25,00 $265,81 $258 65 2006 2007 2003 2004 2005 Adopted Proposed Account# Description Actual Actual Actual Budget Budget 10 $0 $0 $0 $0 0 0 0 0 0 385 47000 01 601 00 Bond Principal 0 210,000 205,000 205,000 210,000 385 47000 01 611 00 Bond Interest 64,643 57,308 52,126 46,300 39,800 385 47000 01 621 00 Bond Paying Agent Fees 374 374 374 400 400 385 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $65,016 $267,681 $257,500 $251,700 $250,200 Comments Page One 339 31010 00 339 36101 00 339 36102 00 339 36210 00 339 36215 00 339 36265 00 339 37145 00 339 37160 00 339 39202 00 339 39203 00 339 39204 00 339 39205 00 339 39206 00 339 39208 00 339 39310 00 2007 BUDGET WORKSHEETS DEBT SERV FUND 339 G 0. IMPROVEMENT BONDS, 2003A REVENUES December 4, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Descnption Actual Actual Actual Budget Budget Comments Current Ad Valorem Taxes Pnncipal Special Assessments Penaltes 8 Interest S/A Interest Earnings Investments Interest Earnings Use cf Reserve Funds Surcharge on Water Revenues Penalties Surcharge Revenues Contribution From Enterprises Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer from Street CIP Bond Proceeds FUND TOTALS Account Descnpbon EXPENDITURES 339 47000 01 317 00 General Fund Admin Fees 339 47000 01 319 00 Other Professional Services 339 47000 01 601 00 Bond Principal 339 47000 01 611 00 Bond Interest 339 47000 01 621 00 Bond Paying Agent Fees 339 47000 01 710 00 Transfers FUND TOTALS 2 154,94 234,56 1 45 51 82 2,68 1 5 43,00 44,00 43,00 44,00 57,58 $57,611 $243,235 $326,131 $329,35 $86,35 $66,35 155,00 63,84 44,00 44,00 44,00 44 00 $236,200 Levy for St Joe's Assumed S/A 2006 2007 2003 2004 2005 Adopted Proposed Actual Actual Actual Budget Budget Comments 0 $0 50 $0 $0 0 0 0 0 0 0 0 210,000 195,000 195 000 0 57,663 51,128 47,100 42700 0 403 403 900 500 0 0 0 0 0 $0 358,066 $261,530 $243,000 5238,200 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 613 G 0 WATER REVENUE BONDS, 20038 REVENUES December4, 2006 Account 613 31010 00 613 36101 00 613 36102 00 613 36210 00 613 36215 00 613 36265 00 613 37145 00 613 37160 00 613 39202 00 613 39203 00 613 39204 00 613 39205 00 613 39206 00 613 39207 00 613 39310 00 EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed Descnptron Actual Actual Actual Budget Budget Comments Current Ad Valorem Taxes Principal Soecial Assessments Penalies Interest S. /A Interest Earnings Investments Interest Earnings Use of Reserve Funds Surcharge on Water Revenues Penalties Surcharge Revenues Contribution From Enterprises Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Port Authority Bond Proceeds 613 47000 01 317 00 General Fund Admin Fees 613 47000 01 319 00 Other Professional Services 1 2,97 3 4 32,00 FUND TOTALS $2,982 $32,07 14 3 134,00 $134,17 ro- 134,00 138,00 $134,000 $136,000 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments $0 $0 $0 $0 $0 0 0 0 0 0 613 47000 01 601 00 Bond Principal 0 0 0 105,000 110,000 613 47000 01 611 00 Bond Interest 14,338 26,675 27,568 26,700 25,000 613 47000 01 614 00 Amortization of Bond Discount 926 1,652 1 852 1,900 1,900 613 47000 01 621 00 Bond Paying Agent Fees 0 0 403 400 400 613 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $15,263 $30,527 $29,522 $134,000 $137,300 kbo Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 301 G 0 CAPITAL IMPROVEMENT PLAN (CIP) BONDS, 2005A REVENUES December 4, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Descnption Actual Actual Actual Budget Budget Comments 301 31010 00 301 36101 00 301 36102 00 301 36210 00 301 36215 00 301 36265 00 301 37145 00 301 37160 00 301 39202 00 301 39203 00 301 39204 00 301 39205 00 301 39206 00 301 39207 00 301 39310 00 Account Current Ad Valorem Taxes Principal Special Assessments Penalties Interest S/A Interest Earnings Investments Interest Earnings Use of Reserve Funds Surcharge on Water Revenues Penalties Surcharge Revenues Contribution From Enterprises Transfer From Transfer From Water Core Transfer From Sewer Core Transfer From Storm Core Transfer From Port Authority Bond Proceeds FUND TOTALS EXPENDITURES 301 47000 01 317 00 General Fund Admm Fees 301 47000 01 319 00 Other Professional Services 12 2 $208,97 65,30 $0 $65,457 $208,97 $210,73 $210,737 2006 2007 2003 2004 2005 Adopted Proposed Description Actual Actual Actual Budget Budget Comments $0 $0 $0 $0 $0 0 0 0 0 0 301 47000 01 601 00 Bond Principal 0 0 0 0 95,000 301 47000 01 611 00 Bond Interest 0 0 0 117,400 102,400 301 47000 01 621 00 Bond Paying Agent Fees 0 0 0 600 600 301 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS SO SO $0 $118,000 $198,000 b l Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 302 G 0 EQUIPMENT CERTIFICATES, 2005B REVENUES December 4, 2006 Account Descnption Actual Actual Actual Budget Budget 302 31010 00 Current Ad Valorem Taxes 302 36101 00 Pnncipal Special Assessments 302 36102 00 Penalties Interest S/A 302 36210 00 Interest Earnings Investments 302 36215 00 Interest Earnings 302 36265 00 Use of Reserve Funds 302 37145 00 Surcharge on Water Revenues 302 37160 00 Penalties Surcharge Revenues 302 39202 00 Contribution From Enterpnses 302 39203 00 Transfer From 302 39204 00 Transfer From Water Core 302 39205 00 Transfer From Sewer Core 302 39205 00 Transfer From Sto-m Core 302 39207 00 Transfer From Port Authority 302 39310 00 Bond Proceeds FUND TOTALS EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed $347,21 1,75 $1,764 $347,21 $349,19 $349,198 Comments 2006 2007 2003 2004 2005 Adopted Proposed Account Descnption Actual Actual Actual Budget Budget Comments 302 47000 01 317 00 General Fund Admin Fees 302 47000 01 319 00 Other Professional Services 302 47000 01 601 00 Bond Pnnapal 0 0 0 290,000 300,000 302 47000 01 611 00 Bond Interest 0 0 20,566 40700 32,600 302 47000 01 621 00 Bond Paying Agent Fees 0 0 0 300 400 302 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS so $0 SO $0 $0 0 0 0 0 0 $0 $0 $20,566 $331,000 $333,000 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 610 G 0 WATER REVENUE BONDS, 2005C REVENUES December k 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Descnption Actual Actual Actual Budget Budget Comments 610 31010 00 610 36101 00 610 36102 00 610 362W 00 610 36215 00 610 36265 00 610 37145 00 610 37160 00 610 39202 00 610 39203 00 610 39204 00 610 39205 00 610 39206 00 610 39207 00 610 39310 00 Current Ad Valorem Taxes Principal Special Assessments Penalties Interest S/A Interest Earnings Investments Interest Earnings Use of Reserve Funds Surcharge on Water Revenues Penalties Surcharge Revenues Contribution From Enterpnses Transfer From Transfer From Water Core Transfer From Sewer Care Transfer From Storm Core Transfer From Port Authonty Bond Proceeds FUND TOTALS EXPENDITURES 610 47000 01 317 00 General Fund Admin Fees 610 47000 01 319 00 Other Professional Services $0 10,052 606 5,704 8 233,68 1,81 240,00 338,00 22,11 $0 $0 $274,066 $240,000 8338,000 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget $0 $0 $0 $0 $0 6 0 0 0 0 For 1/1/07 Used for WTP Comments 610 47000 01 601 00 Bond Principal 0 0 140,000 0 235,000 (2005) Final Pymt on 1993C Issue 610 47000 01 611 00 Bond Interest 0 0 14,810 79,800 102 300 610 47000 01 614 00 Amortization of Bond Discount 0 0 658 0 0 610 47000 01 621 00 Bond Paying Agent Fees 0 0 3,913 200 700 610 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $0 $0 $159,381 $80,000 $338,000 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 303 G 0, FIRE STATION REFUNDING BONDS, 2005D (Old 1996A) REVENUES- December 4, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 303 31010 00 Current Ad Valorem Taxes $156,13 $152,19 $153,42 $154,30 $142,52 303 36101 00 Principal Special Assessments 303 36102 00 Penalties 8 Interest S/A 303 36210 00 Interest Earnings Investments 73 1,52 1,83 303 36215 00 Interest Earnings 5 1 3 303 36265 00 Use of Reserve Funds 1,150,00 303 37145 00 Surcharge on Water Revenues 303 37160 00 Penalties Surcharge Revenues 303 39202 00 Contribution From Enterprises 303 39203 00 Transfer From 303 39204 00 Transfer From Water Core 303 39205 00 Transfer From Sewer Core 303 39206 00 Transfer From Storm Core 303 39207 00 Transfer From Port Authority 303 39310 00 Bond Proceeds 1.109,24 FUND TOTALS $156,912 $153,73 $1,264,54 31,304,305 $142,527 EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 303 47000 01 317 00 General Fund Admin Fees 303 47000 01 319 00 Other Professional Services $o $o $o so $o 0 0 4,999 0 0 303 47000 01 601 00 Bend Principal 70,000 75,000 75000 1,165,000 85,000 303 47000 01 611 00 Bond Interest 75,410 71,820 68,033 62,000 37,100 303 47000 01 621 00 Bond Paying Agent Fees 193 193 13,553 200 400 303 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $145,603 $147,013 6161,584 $1,227,200 $122,500 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 321 G 0. EQUIPMENT CERTIFICATES, 2006A REVENUES December 4, 2006 321 31010 00 Current Ad Valorem Taxes 321 36101 00 Principal Special Assessments 321 36102 DO Penalties Interest S/A 321 36210 00 Interest Earnings Investments 321 36215 00 Interest Earnings 321 36265 00 Use of Reserve Funds 321 37145 00 Surcharge on Water Revenues 321 37160 00 Penalties Surcharge Revenues 321 39202 00 Contribution From Enterprises 321 39203 00 Transfer From 321 39204 00 Transfer From Water Core 321 39205 00 Transfer From Sewer Core 321 39206 00 Transfer From Storm Core 321 39207 00 Transfer From Port Authority 321 39310 00 Bond Proceeds FUND TOTALS EXPENDITURES 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget $87 95 6,20 $0 $0 $0 $94,155 Comments 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 321 47000 01 317 00 General Fund Admin Fees $0 $0 $0 $0 $0 321 47000 01 319 00 Other Professional Services 0 0 0 0 0 321 47000 D1 601 00 Bond Principal 0 0 0 0 0 321 47000 01 611 00 Bond Interest 0 0 0 0 16,100 321 47000 01 621 00 Bond Paying Agent Fees 0 0 0 0 400 321 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $0 $0 $0 $0 $16,500 Page One 2007 BUDGET WORKSHEETS DEBT SERV FUND 326 G 0 IMPROVEMENT BONDS, 2006B REVENUES December 4, 2006 2006 2007 2003 2004 2005 Adopted Proposed Account Description Actual Actual Actual Budget Budget Comments 326 31010 00 Current Ad Valorem Taxes 326 36101 00 Pnncipal Special Assessments 326 36102 00 Penalties Interest S/A 326 36210 00 Interest Earnings Investments 326 36215 00 Interest Earnings 326 36265 00 Use of Reserve Funds 326 37145 00 Surcharge on Water Revenues 326 37160 00 Penalties Surcharge Revenues 326 39202 00 Contnbution From Enterprises 326 39203 00 Transfer From 326 39204 00 Transfer From Water Core 326 39205 00 Transfer From Sewer Core 326 39206 00 Transfer From Storm Core 326 39208 00 Transfer From Street CIP 326 39310 00 Bond Proceeds FUND TOTALS EXPENDITURES- $0 $0 $0 $206,00 2006 2007 2003 2004 2005 Adopted Proposed Account Descnption Actual Actual Actual Budget Budget 326 47000 01 317 00 General Fund Admin Fees $0 $0 $0 $0 $0 326 47000 01 319 00 Other Professional Services 0 0 0 0 0 326 47000 01 601 00 Bond Principal 0 0 0 0 0 326 47000 01 611 00 Bond Interest 0 0 0 0 205,600 326 47000 01 621 00 Bond Paying Agent Fees 0 0 0 0 400 326 47000 01 710 00 Transfers 0 0 0 0 0 FUND TOTALS $0 $0 $0 $0 $206,000 196,00 10,00 Comments Page One August 7, 2008 2007 BUDGET WORKSHEETS WATER UTILITY REVENUES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget 601 33425 00 Other State Grants Aids $1,570 $0 601 34108 00 Administrative Fees -Other Funds 87,127 18,10 18,595 17,00 5,00 601 34109 00 Other Gen'I Govt Chgs for Services 0 2,33 0 601 36101 00 Principal Special Assessments 42.083 31,57 29,049 30.00 30,00 601 36102 00 Penalties B Interest SIA 4.780 (1,20) 1,330 601 36210 00 Interest Earnings Investments 45,288 55.42 86,611 60.00 80,00 601 36214 00 Net Change in FV- Investments (2.148) 1,12 (5,141) 601 36215 00 Interest Earnings 394 32 291 40 40 601 36220 00 Rents Royalties 58 266 59,98 50,841 60.00 60,00 Antenna Leases 601 36260 00 Other Revenues 0 100 601 36265 00 Use of Reserve Funds 0 0 170,00 696,80 601 37110 00 Residential Water Revenues 697,730 692,80 722,666 620,00 70000 601 37120 00 Apartment Water Revenues 36.815 44,66 58.756 45,00 60,00 601 37 +25 00 Institutional Water Revenues 31,120 96,30 33.635 30.0 30,00 601 37130 00 Commercial Water Revenues 50,542 49,64 50,509 50,00 50,00 60137'4000 Industrial Water Revenues 41,836 31,94 41,678 4000 40.00 601 37160 DO Penalties Water Revenues 6,826 8,27 7,652 6 00 6.00 601 37165 00 Meter Maint Water Revenues 0 0 601 37170 00 Other Water Revenues 0 0 601 37180 00 Water Meter Sales Revenue 136,115 185.08 121,369 130,00 100,00 601 39103 00 Gain or Loss from F/A Disposal 3,160 (6,898) 601 39203 00 Transfer From 0 109, 536 FUND TOTALS 1,241,505 1,276 402 1,320,579 1,258,400 1,858,200 Comments 5% of 5% Fees Const Projects Annual Market Value Changes (in Page One August 7, 2006 Account 2007 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES Description 601 49400 101 00 Salaries Benefits 601 49400 77 101 00 Administrative 601 49400 78 101 00 Technical /Clerical 601 49400 79 101 00 Maintenance 601 49400 102 00 Full -Time Overtime 601 49400 103 00 Part-Time Salaries Benefits 601 49400 99 103 01 Utility Commission Wages (50 601 49400 99 103 02 Maintenance Labor 601 49400 01 203 00 Printed Forms Paper 601 49400 01 209 00 Other Office Supplies 601 49400 01 216 00 Chemicals Chemical Products 601 4 3400 01 219 00 Other Operating Supplies 601 49400 01 220 00 Water Meter Purchases 601 49400 01 220 01 For Replacements 601 49400 01 220 02 For New Homes 601 49400 01 224 00 Street Maintenance Materials 601 49400 01 225 00 Landscaping Materials 601 49400 01 227 OD Utility System Maintenance Supplies 601 49400 01 228 00 Meter Repair Materials 601 49400 01 229 00 Other Maintenance Supplies 601 49400 01 229 01 Supplies for Hydrants 601 49400 01 229 02 Valve Curb Boxes 601 49400 01 229 03 Valve Replacements (2) 601 49400 01 229 04 Miscellaneous Supplies 601 49400 01 241 00 Small Tools 601 49400 01 242 00 Minor Equipment 601 49400 01 242 01 Miscellaneous Purchases 601 49400 01 242 02 601 49400 01 303 00 Engineering Fees 601 49400 01 303 01 601 49400 01 303 02 GIS Update of Asbuilts 601 49400 01 303 03 601 49400 01 303 04 Miscellaneous Fees 601 49400 01 304 00 Legal Fees 601 49400 01 310 00 Testing Services 601 49400 01 310 01 Bacteria Water Quality 601 49400 01 310 02 V O C Pesticides, etc 601 49400 01 310 03 CU -PB Testing (07 Price Increase) 601 49400 01 312 00 Gopher State One -Call 601 49400 01 313 00 Temporary Service Fees 601 49400 01 313 01 Temp Service Fees 601 49400 01 315 00 Special Programs 601 49400 01 315 01 Public Information 601 49400 01 315 02 Plan Amendments 601 49400 01 315 03 Seminars 601 49400 01 315 04 Vulnerability Assessment Imp 601 49400 01 318 00 Contract Engineer 601 49400 01 319 00 Other Professional Services 601 49400 01 319 01 Thaw Pipes, Check Leaks, etc 601 49400 01 319 02 Supervisory Controls 601 49400 01 319 03 Hazardous Chemical Permits 601 49400 01 319 04 Annual Drinking Water Report 601 49400 01 319 05 Hazardous Chemical Inventory 601 49400 01 321 00 Telephone Costs 601 49400 01 322 00 Postage Costs 601 49400 01 323 00 Radio Units 601 49400 01 331 00 Travel Expense 601 49400 01 333 00 Freight Express Expenses 601 49400 01 341 00 Employment Advertising 601 49400 01 349 00 Other Advertising PAGE TOTALS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $222,229 81,216 89,591 98,000 113,592 108,348 164,900 118,556 122,362 151,500 10 444 7,178 12,674 10,000 14,228 13,126 10,253 16,000 2,076 2,954 2,750 25 314 146 42,372 44,068 37,013 0 657 0 171,902 86,685 29,325 125,743 79,457 133 0 141 0 0 0 6,437 5,458 5,130 0 0 17 4,671 1,358 1,330 O 85 O 2,229 O 0 1,879 1,154 1,381 4,750 953 2,133 2,476 174 1,479 36,003 13,116 93,86 0 3,505 0 0 2,830 5,01 25,336 1,654 1,30 13,348 28,16 12,722 4,349 4,438 4,77 0 15 500 20,03 603 21,06 0 891 2,35 0 0 0 6,000 3,000 6,00 11,692 6,196 2,08 2,439 3,50 525 2,436 61 0 52 438 432 97 3,415 3,989 4,08 645 544 56 D 0 0 18 0 0 0 0 2,500 200 45,000 200 0 1 30,000 2,000 500 0 300 4,000 1,300 2,200 5,000 1,000 0 5,500 5,000 1,000 50,000 9,000 1,500 3,000 500 0 600 0 4 000 2,000 1,000 100 700 500 102,500 146,700 130,500 1,000 15,000 0 130,000 4,000 1,300 2 200 5,000 1,500 3,000 1,500 0 0 5,500 5,000 1,000 50,000 1 500 3,000 500 7,500 600 All Salary Costs Inclusive of 5379,700 Salary, Taxes, PERA Benefits 10,000 16,000 2,500 200 55,000 200 130,000 569,022 693,703 701,119 791,000 772,800 Comments 50% -601, 50% -602 100% 601 Inserts Water B41 Statements Disks, Ribbons, etc Chlorine, Flounde, Polyphos Maintenance Supplies Meters, MIU's CU Horns 2,000 Patching for Breaks 500 Topsoil, Seed Sod 0 300 Miscellaneous Meter Parts 12,500 2,000 Wrenches, Shovels, etc 3,000 19,000 25,000 0 7 000 7,000 0 0 6 000 12,000 1,000 1,000 38,000 2,000 2,000 Radon, In-Chi 1,000 1,000 22 000 35,000 $6 36 /Connection Annual Fee (M) 5,000 7,000 Gopher State One -Call (M) 0 61,500 Wellhead Protection Plan 9,000 Contracted Engineer for City(20 13,100 MN Department of Public Safety 0 6,000 Billings with Inserts 2,000 Replace /Repair Radios Phones 1,000 AWWA National Seminar 100 Mail -in Repairs 700 P/Pers Personnel Changes 500 Page Two August 7, 2006 Account 2007 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES Description 601 49400 01 352 00 General Notices Public Into 601 49400 01 365 00 Workers Comp Insurance 601 49400 01 369 00 Other Insurance 601 49400 01 391 00 P C Maintenance 601 49400 01 392 00 P C Accessories Supplies 601 49400 01 393 00 P C Hardware Purchases 6D1 49400 01 394 00 P C Software Purchases 601 49400 01 395 00 P C Repairs 601 49400 01 403 D0 Contracted R M Other Impr 601 49400 01 416 00 Machinery Rental 601 49400 01 433 00 Dues Subscriptions 601 49400 01 435 00 Books Pamphlets 601 49400 01 437 00 Conferences Seminars 601 49400 01 437 01 MN Health Department School 601 49400 01 437 02 AWWA Conference 601 49400 01 439 00 Other Miscellaneous Charges 601 49400 01 611 00 Interest an Lease Payments 601 49400 01 710 00 Transfers 601-49400-01 TOTALS 601 49403 01 221 00 Equipment Parts 601 49403 01 223 00 Budding Repair Supplies 601 49403 Di 319 00 Other Professional Services 601 49403 01 321 00 Telephone Costs 601 49403 01 381 00 Electric Utilities 601 49403 01 383 DO Gas Utilities 601 49403 01 409 00 Other Contracted Repairs Maint 601 49403 01 439 00 Other Miscellaneous Charges TOTAL WELL #3 601 49406 01 221 00 Equipment Parts 601 49406 01 223 00 Building Repair Supplies 601 49406 01 319 00 Other Professional Services 601 49406 01 321 00 Telephone Costs 601 49406 01 381 00 Electric Utilities 601 49406 01 383 00 Gas Utilities TOTAL EAST SIDE W/M VAULT 601 49407 01 221 00 Equipment Parts 601 49407 01 223 00 Building Repair Supplies 601 49407 01 319 DO Other Professional Services 601 49407 01 321 00 Telephone Costs 601 49407 01 381 00 Electric Utilities 601 494D7 01 383 00 Gas Utilities 601 49407 01 409 00 Other Contracted Repairs Maint 601 49407 01 439 00 Other Miscellaneous Charges 601 49407 01 530 00 Improvements Other Than Bldgs TOTAL WELL #7 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget 410 4,107 13,306 507 0 0 2,130 0 0 0 686 0 1,320 601 49400 01 521 00 Building Structure Purchases 0 601 49400 01 530 00 Improvements Other Than Bldgs 16,806 601 49400 01 530 01 Annual Inspection of Wells 601 49400 01 530 02 Miscellaneous Improvements 601 49400 01 530 03 CRP of Watermain 601 49400 01 530 04 Replace Pickup #344 601 49400 01 530 05 Survey Grade GPS 601 49400 01 530 06 Crane Box for Pickup #342 601 49400 01 530 07 Replace Pickup #342(Carry from 2006) 601 49400 01 560 OD Furniture FI #Jre Purchases 0 601 49400 01 570 OD Office Equipment Purchases 0 601 49400 01 586 00 Computer Equipment Purchases 0 63 2 6,330 5,64 1,996 1,724 0 211 11,755 0 753 0 0 5,42 15,75 33 39 1,94 19,02 421 0 0 0 0 0 1,667 0 652 0 0 211 13,325 0 120 0 0 4,63 16,75 29 53 30 42 69 40 9,96 9,87 165,46 62,25 58 18 5,419 5,190 4,94 0 110,528 91,84 31 1,80 1,092 0 0 211 20,307 0 0 0 0 500 500 Newsletters 4,500 4,500 Water's Share of Premiums 14,000 14,000 Water's Share of Premiums 500 500 Auto Read Software Support 200 200 4,000 4,000 Laptops 2,500 2,500 500 500 3,000 3,000 4,000 4,000 800 800 AWWA for 2 Members 300 300 Reference Materials 1,500 1,000 500 6,000 10,000 10,000 Pymt on P W Building (8 of 20) 226,000 30,000 30,000 Each Well Done Every 7 Years 30,000 30,000 100,000 100,000 Annuat Pavement Management 22,500 15 000 1/3 of Total Estimated Cost 25,000 12 500 50% of Total Estimated Cost O 16 000 1/3 of Total Estimated Cost 0 22,500 50% of Total Estimated Cost 1,000 1,000 1,000 1,000 Chair, Table O 0 0 0 620,042 859,029 1,070,296 1,052,800 602 1,188 5,190 1,000 1,724 0 0 500 0 0 0 1,000 211 211 211 300 9,983 10,271 7,139 7,500 696 656 913 2,000 0 0 2,050 25,000 0 0 0 100 13,21 12,326 15,50 37,400 0 1,867 2,112 3,300 500 300 500 300 18,000 0 600 100 0 1,000 500 6,000 DNR Annual Water Use (M) 1,053,100 1,000 500 1 000 Independent Inspections 300 7,500 Pumping Lighting 2,000 Heat Engine Backup 0 100 Contingencies 12,400 3,300 18,439 14,308 21,610 20,300 20,300 (M) Comments D P W Building Expansion(See 521) 0 Transfers for Other Improvements 1,000 1,000 O 0 1,000 1 000 300 300 1,000 1,000 Pumping Lighting O 0 Heat Only 500 300 500 Independent Inspections 300 18,000 Pumping Lighting 0 600 RTU's, Pump Motor etc 100 Contingencies 0 Page Three August7, 2008 2007 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES Account Description Actual Actual Actual Budget Amount Budget 601 49408 01 221 00 Equipment Parts 932 220 6,959 1,000 1,000 601 49408 01 223 00 Building Repair Supplies 0 0 0 100 100 601 49408 01 319 00 Other Professional Services 0 0 0 0 0 601 49408 01 321 00 Telephone Costs 211 211 211 300 300 601 49408 01 381 00 Electric Utilities 17,375 15,816 16,367 18,000 18,000 Pumping Lighting 601 49408 01 383 00 Gas Utilities 447 496 450 600 600 Heat Only TOTAL WELL #8 18,964 16,74 601 49409 01 221 00 Equipment Parts 1,411 601 49409 01 223 00 Building Repair Supplies 0 601 49409 01 319 00 Other Professional Services 0 601 49409 01 321 00 Telephone Costs 211 21 601 49409 01 381 00 Electric Utilities 24,048 24,04 601 49409 01 383 00 Gas Utilities 849 84 601 49409 01 439 00 Other Miscellaneous Charges 0 TOTAL WELL #9 601 49410 01 219 00 Other Operating Supplies 0 0 0 1,000 1,000 601 49410 01 221 00 Equipment Parts 4,424 0 158 0 0 601 49410 01 223 00 Building Repair Supplies 164 0 0 100 100 601 49410 01 321 00 Telephone Costs 936 92B 935 1 000 1,000 601 49410 01 381 00 Electric Utilities 8,716 8 492 7,961 9,000 9,000 Pumping Lighting 601 49410 01 409 00 Other Contracted Repairs Maint 0 1,800 1,189 2,900 2,900 TOTAL WELL #10 601 49411 01 221 00 Equipment Pads 1,245 601 49411 01 381 00 Electric Utilities 0 TOTAL WELL #11 1,24 601 49412 01 221 00 Equipment Parts 601 49412 01 223 00 Building Repair Supplies 601 49412 01 319 OD Other Professional Services 601 49412 01 321 00 Telephone Costs 601 49412 01 381 00 Electric Utilities 601 49412 01 383 00 Gas Utilities 601 49412 01 439 00 Other Miscellaneous Charges TOTAL WELL #12 601 49414 01 221 00 Equipment Parts 601 49414 01 223 00 Braiding Repair Supplies 601 49414 01 319 00 Other Professional Services 601 49414 01 321 00 Telephone Costs 601 49414 01 381 00 Electric Utilities 601 49414 01 383 00 Gas Utilities 601 49414 01 439 00 Other Miscellaneous Charges TOTAL- WELL #14 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed 23,987 20,000 20,000 2,929 500 500 O 100 100 O 0 0 211 300 300 28,475 30,000 30,000 Pumping Lighting 1,042 1,500 1,500 Heat Only O 100 100 Contingencies 26,519 25,092 32,658 32,500 32,500 14,240 11,220 10,241 14,000 14,000 39 1,01 1,41 0 0 0 0 33,500 33,500 33 000 33,000 Comments 0 Pumping Lighting 0 500 500 100 100 1,000 1,000 300 300 30,000 30,000 Pumping Lighting 1,500 1,500 Heat Only 100 10D Contingencies 500 500 100 100 1 000 1,000 300 300 30,000 30,000 Pumping Lighting 1,000 1,000 Heat Only 100 100 Contingencies 90 Page Four 2007 BUDGET WORKSHEETS WATER UTILITY EXPENDITURES August 7, 2006 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Descnpbon Actual Actual Actual Budget Amount Budget 601 49415 01 221 00 Equipment Parts 0 601 49415 01 319 00 Other Professional Services 0 601 49415 01 381 00 Electric Utilities 0 601 49415 01 409 00 Other Contracted Repairs Maint 0 601 49415 01 439 00 Other Miscellaneous Charges 0 TOTAL WATER TOWER #1 0 601 49416 01 221 00 Equipment Parts 0 1,79 601 49415 01 319 00 Other Professional Services 0 601 49415 01 321 00 Telephone Costs 211 21 601 49416 01 381 00 Electric Utilities 612 76 601 49416 01 409 00 Other Contracted Repairs Maint 0 601 49416 01 439 00 Other Miscellaneous Charges 0 601 49416 01 530 00 Improvements Other Than Bldgs 0 TOTAL WATER TOWER #2 601 49417 01 221 00 Equipment Parts 0 0 0 0 0 601 49417 01 321 00 Telephone Costs 0 0 0 D 0 601 49417 01 381 00 Electric Utilities D 0 0 0 0 601 49417 01 439 00 Other Miscellaneous Charges 0 0 0 0 0 Contingencies TOTAL WATER TOWER #4 0 0 0 0 0 (Bacardi Water Tower) 601 49418 01 221 00 Equipment Parts 0 0 0 500 500 601 49418 01 319 00 Other Professional Services 0 0 0 500 500 Tower Inspection 601 49418 01 321 00 Telephone Costs 1,873 1,873 1,874 2,000 2,000 501 49418 01 381 00 Electric Utilities 1,757 1,856 1,647 2,000 2,000 601 49418 01 409 00 Other Contracted Repairs Maint 0 0 3,20D 500 500 601 49418 01 439 00 Other Miscellaneous Charges 0 0 75 200 200 Contingencies 601 49418 01 530 00 Improvements Other Than Bldgs 0 0 0 300 300 TOTAL WATER TOWER 43 3,629 3,729 6,796 6,000 6,000 (East Side Water Tower) GRAND TOTAL ALL DEPTS 823 2,766 1,470 3,900 0 500 500 Touch -up Paint 0 500 500 Tower Inspection 0 0 0 0 500 500 0 200 200 Contingencies 0 1,700 1700 0 500 500 Touch -up Paint 0 500 500 Tower Inspection 211 300 300 1,259 1,400 1 400 0 500 500 0 200 200 Contingencies 0 500 625,000 Paint Tower Structural Repairs 628,400 715,115 947,079 1,186,089 1,258,400 1,658,200 Comments it Page One August 7, 2006 2007 BUDGET WORKSHEETS SEWER UTILITY REVENUES- 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 602 33425 00 Other Stale Grants Aids 930 0 0 0 0 602 34108 00 Administrative Fees -Other Funds 87 127 18,103 18,595 17,000 5,000 5% of 5% Fees -Const Projects 602 36101 00 Principal Special Assessments 64,803 48,669 44,888 40,000 40,000 602 36102 00 Penalties Interest- SIA 7,029 (1,496) 2,077 0 0 602 36210 00 Interest Earnings Investments 69,345 73,386 98,577 80,000 90 000 602 36214 00 Net Change in FV- Investments (18,017) (1,438) (18,832) 0 0 Annual Market Value Changes 602 36215 00 Interest Earnings 490 476 273 600 600 602 36260 DO Other Revenues 0 0 0 0 0 602 36265 00 Use of Reserve Funds 0 0 0 235,400 193,000 602 37210 00 Residential Sewer Revenues 972,190 970,562 1,011,697 900,000 1,000 000 602 37220 00 Apartment Sewer Revenues 45720 49,364 53,042 55,000 55 000 602 37225 00 Institutional Sewer Revenues 31,058 30,548 27,870 35,000 30,000 602 37230 00 Commercial Sewer Revenues 48,669 50,547 52,136 55,000 55,000 602 3724D 00 Industrial Sewer Revenues 4,980 5,274 4,966 6,000 6,000 602 37260 00 Penalties Sewer Revenues 9,345 11,786 9,829 8,000 9 000 602 39103 00 Gain or Loss from FIA Disposal 352 0 (32,940) 0 0 602 39203 00 Transfer From 0 0 17,355 0 0 FUND TOTALS 1,324,041 1,255 782 1,289,532 1,432,000 1,483,600 Page One August 7, 2006 Account 2007 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES Descnption 60249450 101 00 Salanes Benefits 802 49450 77 101 00 Administrative 602 49450 78101 00 Technical /Clerical 602 49450 79101 00 Maintenance 602 4945D 102 00 Full -Time Overtime 602 4945D 103 00 Part -Time Salaries Benefits 602 4945D 99103 01 Utility Commission Wages (50 6024945D 99103 02 Maintenance Labor 602 4945D 01203 DO Printed Forms Paper 602 4945D 01 209 D0 Other Office Supplies 602 4945D D1216 DO Chemicals Chemical Products 602 49450 01 219 DO Other Operating Supplies 602 49450 01 224 DO Street Maintenance Materials 602 49450 01 225 DO Landscaping Materials 602 49450 01 227 DO Utility System Maintenance Supplies 602 49450 01241 00 S m all Tools 602 49450 01 242 00 Minor Equipment 602 49450 01 303 00 Engineering Fees 602 49450 01 303 01 GIS Update of Asbuilts 602 49450 01 303 02 Rate Study 602 49450 01 303 03 42/52 Sewer Study 602 49450 01 304 00 Legal Fees 602 49450 01 312 00 Gopher State One -Call 602 49450 01 313 00 Temporary Service Fees 602 49450 01 313 01 Temp Service Fees 602 49450 01 318 00 Contract Engineer 602 49450 01 319 00 Other Professional Services 602 49450 01 319 01 Televising 6D2 49450 01319 02 Root Control 602 49450 01319 03 Supervisory Controls(Maint Cont) 602 49450 01319 04 Telephone Costs Postage Costs Radio Units Travel Expense Freight Express Expenses Employment Advertising Other Advertising Workers Comp Insurance Other Insurance P C Maintenance P C Accessories Supplies P C Hardware Purchases P C Sofware Purchases P C Repairs 602 49450 01 321 00 602 49450 01 322 00 602 49450 01 323 00 602 49450 01 331 DD 602 49450 01 333 00 602 49450 01 341 DD 602 49450 01 349 00 602 49450 01 365 00 602 49450 01 369 00 602 49450 01 391 0D 602 49450 01 392 00 602 49450 01 393 00 602 49450 01 394 00 602 49450 01 395 00 602 4945D D1403 00 Contracted R M Other Impr 602 4945D 01415 00 Other Equipment Rental 602 4945D 01416 00 Machinery Rental 602 4945D 01433 00 Dues Subscriptions 602 49450 01 435 00 Books Pamphlets 602 49450 01 437 00 Conferences Seminars 602 49450 01 439 00 Other Miscellaneous Charges 2003 Actual $222,228 10,444 14,496 1,38 33 1,35 1 62 54 4,18 8,90 16 4,34 6,00 10,77 43 2,81 64 4,08 9,17 5D 2,13 1,31 13 602 49450 01 521 00 Building Structure Purchases 602 49450 01 530 00 Improvements Other Than Bldgs 15,66 602 49450 01 530 01 Miscellaneous Improvements 602 49450 01 530 02 Misc Improvements /Repairs 602 49450 01 530 03 CRP of Sewermain 602 49450 01 530 04 Replace Pickup #344 602 49450 01 530 05 Survey Grade GPS 602 49450 01 530 D6 Crash Attenuator 602 49450 01 530 07 Crane Box for Pickup #342 602 49450 01 530 08 Replace Pickup #342(Carry from 2008) 602 49450 01 540 00 Heavy Machinery Purchases 602 49450 0156D 00 Furniture Fixture Purchases 602 49450 01 570 00 Office Equipment Purchases 0 0 0 2006 2007 Object 2007 2004 2005 Adopted Detail Proposed Actual Actual Budget Amount Budget 81,215 113,591 118,556 7,178 19,545 1,50 11 2,66 33 1,51 25 2,24 4,43 15,50 80 3,00 2,43 43 3,04 54 1 5,40 9,26 33 6 1,08 12 1,94 14,26 602 49450 01 602 00 Sewer Service Charges 510,840 548,45 602 49450 01 611 00 Interest on Lease Payments 5,419 5,19 602 49450 01710 00 Transfers 0 18,35 185,98 89,591 98,000 108,348 164,900 122,362 151,500 12,674 10,000 9,289 15,000 2,10 1,500 200 500 200 2,50D 400 31 1,500 15 500 64 3,000 7,00 10,0 15,00 15 50 4,76 5,00 20,03 21,06 6,00 9,00 3,00 3,50 2,00 1,40 3,00 61 49 6 3,23 3,0 55 1,0 1,0 1 0 3 0 5 0 4,61 4,5 9,34 12,0 3 0 2 0 4,0 29 2,5 5 0 17 2,0 2 0 2,0 5 0 30 1,30 2,0 12 1 10,0 20,0 20,0 108,59 100,00 62,25 22,50 25,00 6,50 40,19 28 5 5 597,24 673,00 4,94 602- 49450 -01 TOTALS 839,964 981,43 1,432,73 1,409,80 102 500 146,700 130,50D 10 000 15 000 1,000 50 602, 50% -601 14,00D 100% -602 7,000 0 15,000 0 3,000 2,000 3,000 0 20,000 20,000 100,000 15,000 12,500 6,500 16,000 22,500 All Salary Costs Inclusive of 5379,700 Salary, Taxes, PERA Benefits 1,500 Inserts Water Bill Statements 200 Disks, Ribbons etc 500 Root Killer, Degreaser 200 2,500 Patching 400 Topsoil, Seed Sod 1,500 Manhole Castings 500 Wrenches, Shovels etc 6,000 fetter Attachment 22 000 Comments 500 7,000 Gopher State One -Call (M) 0 9,000 Contracted Engineer for City(20 8 000 SCADA System 0 3,000 Billings with Inserts 1,000 Replace /Repair Radios Phones 1,000 National Conference 100 Mail -in Repairs 300 Filers Personnel Changes 500 4,500 Sewer's Share of Premiums 12,000 Sewer's Share of Premiums 300 Auto Read Software Support 200 4,000 Laptops 2 500 500 2,000 200 2,000 500 300 Reference Materials 2 000 MPCA School Miscellaneous 100 Contingencies 10,00D Pymt on P W Building (8 of 20) 212,50D Annual Pavement Management 1/3 of Total Estimated Cost 50% of Total Estimated Cost 50% of Total Estimated Cost 1/3 of Total Estimated Cost 50% of Total Estimated Cost 0 500 500 732,000 MWCC Charges 0 P W Building Expansion(See 521) 0 Transfers for Other Improvements 1,457,000 197 Page Two August 7, 2008 2007 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES- 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget Comments 602 49451 01 219 00 Other Operating Supplies 0 0 0 100 100 602 49451 01 221 00 Equipment Parts 0 1,302 2,764 500 500 602 49451 01 229 00 Other Maintenance Supplies 0 0 0 200 200 602 49451 01 321 00 Telephone Costs 211 211 211 300 300 602 49451 01 381 00 Electric Utilities 538 577 565 800 800 602 49451 01 403 00 Contracted R M Other Impr 0 0 0 200 200 602 49451 01 439 00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Crly Hall) TOTAL LIFT STATION #1 74 2,090 3,540 2,200 2,200 602 49452 01 219 00 Other Operating Supplies 0 0 100 100 602 49452 01 221 00 Equipment Parts 5,344 0 500 500 602 49452 01 229 00 Other Maintenance Supplies 0 0 200 200 602 49452 C1 321 00 Telephone Costs 21 211 211 300 300 602 49452 01 381 00 Electric Ut.ites 2 289 377 1,000 1,000 602 49452 01 403 00 Contracted R M Other Impr 0 0 200 200 602 49452 01 439 00 Other Miscellaneous Charges 0 0 100 100 Contingencies (Bloomfield 5th) TOTAL LIFT STATION #7 237 5,844 588 2,400 2,400 602 49453 01 219 00 Other Operating Supplies 0 0 0 100 100 602 49453 01 221 00 Equipment Parts 0 506 3,979 500 500 602 49453 01 229 00 Other Maintenance Supplies 0 0 0 200 200 602 49453 01 321 00 Telephone Costs 211 211 211 300 300 602 49453 01 381 00 Electric Utilities 1,804 2,457 2,904 2,000 2,000 602 49453 01 403 00 Contracted R M Other Impr 0 0 0 200 200 602 49453 01 439 00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Shannon Pond) TOTAL LIFT STATION #3 2,014 3,174 7,095 3,400 3,400 602 49454 01 219 00 Other Operating Supplies 0 0 0 100 100 602 49454 01 221 00 Equipment Parts 1,950 7,182 7,925 500 500 602 49454 01 229 00 Other Maintenance Supplies 0 0 0 500 500 602 49454 01 321 00 Telephone Costs 211 211 211 300 300 602 49454 01 381 00 Elecric Utilities 2,835 2,822 3,612 3,200 3,200 Hawkins Pond 602 49454 01 403 00 Contracted R M Other Impr 0 0 0 200 200 602 49454 01 439 00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Country Hills) TOTAL LIFT STATION #4 4,996 10,195 11,748 4,900 4,900 602 49455 01 219 00 Other Operating Supplies 0 0 0 100 100 602 49455 01 221 00 Equipment Parts 0 8,014 230 500 500 602 49455 01 229 00 Other Maintenance Supplies 0 0 0 200 200 602 49455 01 321 00 Telephone Costs 211 211 211 30D 300 602 49455 01 381 00 Electric Utilities 3,134 3,467 3,785 3,500 3,500 Country Hills 602 49455 01 403 00 Contracted R M Other Impr 0 0 0 200 200 602 49455 01 439 00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (LeForet Add'n) TOTAL LIFT STATION #5 3,34 11,692 4,226 4,900 4,900 602 49458 01 219 00 Other Operating Supplies 0 0 100 100 602 49456 01 221 00 Equipment Parts 134 700 500 500 602 49456 01 229 00 Other Maintenance Supplies 0 0 200 200 602 49456 01 321 00 Telephone Costs 169 169 300 300 602 49456 01 381 00 Electric Utilities 9 794 709 800 800 602 49456 01 403 00 Contracted R M Other Impr 0 0 200 200 602 49456 01 439 00 Other Miscellaneous Charges 0 0 100 100 Contingencies (Drumcliffe) TOTAL LIFT STATION #6 95 1,097 1,578 2,200 2,200 7* Page Three 2007 BUDGET WORKSHEETS SEWER UTILITY EXPENDITURES August 7, 2006 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account Description Actual Actual Actual Budget Amount Budget 602 49457 01 219 00 Other Operating Supplies 602 49457 01 221 00 Equipment Parts 602 49457 01 229 00 Other Maintenance Supplies 602 49457 01 321 00 Telephone Costs 602 49457 01 381 00 Electric Utilities 602 49457 01 403 00 Contracted R M Other Impr 602 49457 01 439 00 Other Miscellaneous Charges (Glendalough 5th) TOTAL LIFT STATION #9 602 49458 01 219 00 Other Operating Supplies 602 49458 01 221 00 Equipment Parts 602 49458 01 229 00 Other Maintenance Supplies 602 49458 01 321 00 Telephone Costs 602 49458 01 361 00 Electric Utilities 602 49458 01 403 00 Contracted R M Other Impr 602 49458 01 439 DO Other Miscellaneous Charges (Meadows of TOTAL LIFT STATION #8 (Bloomfield) 602 49460 01 219 00 Other Operating Supplies 602 49460 01 221 00 Equipment Parts 602 49460 01 229 00 Other Maintenance Supplies 602 49460 01 321 OD Telephone Costs 602 49460 01 381 00 Electric Utilities 602 49460 01 403 00 Contracted R M Other Impr 602 49460 01 439 00 Other Miscellaneous Charges (Glen Rose) TOTAL LIFT STATION #10 GRAND TOTAL ALL DEPTS 100 500 200 300 800 200 100 2,20 0 2,200 100 500 200 300 800 200 100 Contingencies n 0 0 0 2,200 851,400 1,015, 529 1,461,504 1,432,000 1,483,600 100 500 200 300 800 200 100 Contingencies 2,200 100 500 200 300 800 200 100 Contingencies Comments 15 Page One August 7, 2006 2007 BUDGET WORKSHEETS STORM WATER UTILITY REVENUES 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 603 34108 00 Administrative Fees -Other Funds $87,127 $18,103 $18,595 $17,000 $5,000 5% of 5% Fees-Const Projects 603 36101 00 Principal Special Assessments 48,032 22,844 8,111 30,000 30,000 603 36102 00 Penalties Interest SlA 1,997 1,933 (115) 0 0 603 36210 00 Interest Earnings Investments 47,475 47,560 57,468 60,000 60 000 603 36214 00 Net Change in FV- Investments (8,187) 1,140 (6,472) 0 0 Annual Market Value Changes 603 36215 00 Interest Earnings 514 382 183 500 500 603 36260 00 Other Revenues 0 0 0 0 0 603 36265 00 Use of Reserve Funds 0 0 0 0 23 700 603 37300 00 Storm Water Utility Revenues 522,250 583,636 624,529 636,500 660,000 603 37360 00 Penalties Storm Water Utility 2,163 4,432 2,959 4,000 4 000 603 39203 00 Transfer From 0 0 47,845 0 0 FUND TOTALS 701,391 660,031 753,103 748,000 763,200 Page One August 7, 2006 Account 603 49500 101 00 603 49500 77101 00 603 49500 78 101 00 603 49500 79 101 00 693 49500 102 00 603 49500 01 226 00 603 49500 01 230 00 603 4950D 01 241 00 603 49500 01 242 00 2007 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES Description Salaries Benefits Administrative TeohmcaUClencal Maintenance Full -Time Overtime 603 49500 01 203 00 Panted Forms Paper 603 49500 01 204 00 Envelopes Letterhead 603 49500 01 205 00 Drafting Supplies 603 49500 01 208 00 Miscellaneous Supplies 603 49500 01 215 00 Shop Materials 603 49500 01 219 00 Other Operating Supplies 603 49500 01 221 00 Equipment Pans 603 49500 01 224 00 Street Maintenance Materials 603 49500 01 225 00 Landscaping Materials 603 49500 01 225 01 Rip -Rap, Matting, Rock, etc 603 49500 01 225 02 Black Din, Seat, Sod, etc 603 49500 01 225 03 Sign Repair Materials Equipment Repair Material Small Tools Minor Equipment 603 49500 01 303 00 Engineering Fees 603 49500 01 303 01 Problem Area Investigations 603 49500 01 303 02 NPDES Phase II 603 49500 01 303 03 CSMP Update 603 49500 01 304 00 Legal Fees 603 49500 01 310 00 Testing Services 603 49500 01 312 00 Contract Inspection Fees 603 49500 01 313 00 Temporary Service Fees 603 49500 01 313 01 Temporary Service Fees 603 49500 01 315 DO Special Programs (County Program) 603 49500 01 318 00 Cant-act Engineer 603 49500 01 319 00 Other Professional Services 603 49500 01 322 00 Postage Costs 603 49500 01 323 00 Radio Units 603 49500 01 331 00 Travel Expense 603 49500 01 352 00 General Notices Public Info 603 49500 01 365 00 Workers Comp Insurance 603 49500 01 369 00 Other Insurance 603 49500 01 384 00 Refuse Disposal 603 49500 01 389 00 Other Utility Services 603 49500 01 391 00 P C Maintenance 603 49500 01 393 00 P C Hardware Purchases 603 49500 01 394 00 P C Software Purchases 603 49500 01 403 00 Contracted R M Other Impr 603 49530 01 403 01 Ditching 603 49500 01 403 02 Miscellaneous Repairs 603 49530 01 404 00 Contracted Mach Equip Repass 603 49500 01 416 00 Machinery Rental 603 49500 01 433 00 Dues Subscriptions 603 49500 01 435 00 Books Pamphlets 603 49500 01 437 00 Conferences Seminars 603 49500 01 437 01 Storm Water Management 603 49500 01 437 02 Hydrocad Training 603 49500 01 437 03 Wetlands Training 603 49500 01 439 00 Other Miscellaneous Charges 603 49500 01 530 00 Improvements Other Than Bldgs 603 49500 01 530 01 CRP of Storm Sewer 603 49500 01 530 02 Crash Attenuator 603 49500 01 530 03 Replace Pickup #344 603 49500 01 530 04 Crane 8 Box for Pickup #342 603 49500 01 540 00 Heavy Machinery Purchases 603 49500 01 560 00 Furniture Fixture Purchases 603 49500 01 580 00 Other Equipment Purchases 603 49500 01 586 00 Computer Equipment Purchases 603 49500 01 710 00 Transfers 603 49500 01 710 01 1(2 of 2007 P I Payments(1996B) 603 49500 01 710 02 112 of 2007 P 8 I Payments(1999C) 603 49500 01 710 03 1/2 of 2007 P 8 I Payments(2001B) 603 49500 01 710 04 1/2 of 2007 P I Payments(2001D) 603 49500 01 710 05 1/2 of 2007 P I Payments(20028) 603 49500 01 710 06 1/2 of 2007 P I Payments(2002C) 603 49500 01 710 07 1/2 of 2007 P I Payments(2003A) 603 49500 01 710 10 Projects 60349500 -01 TOTALS 2003 Actual $161,193 2006 2007 Object 2007 2004 2005 Adopted Detail Proposed Actual Actual Budget Amount Budget Comments 6415 60,65 59,27 7097 9,821 4,38 6,63 1,385 1,50 74 1,500 1 500 O 0 0 O 200 200 Paper, Pens Reproduction O 200 200 Stakes, Ribbons, Level, etc 0 200 200 184 500 500 O 500 500 Filters, Hoses, Lights, etc O 22 191 2,000 2,000 Blacktop Gravel Washouts 2,200 4,000 191 3900 3900 8 332 1900 1,000 0 0 0 O 0 500 500 Advance Warning Sign Rental O 666 1,000 1 000 Due to Breakdowns O 156 1 000 1,000 Shovels, Rakes, Picks, etc 541 31 0 0 0 60,944 3,26 2598 42,41 45 2,62 54 17 27 53 14,04 3,85 3,85 690 3,000 6,00 5,639 2,81 3,046 3,2 23 612 40 0 29 140 2,88 2086 1,81 5,43 6,033 5,07 0 0 337 2,13 0 2 14 0 0 101 10 O 17 6,160 33 131 12 72,807 1,39 0 0 0 0 270,000 51,000 41,000 54,000 77,000 17,000 26,000 43,000 95,670 0 101 0 240 0 0 122 0 97,600 80,000 10,000 10 000 10 000 0 2 000 1 000 500 0 5,000 10,000 1900 5,000 20,000 1,000 1,000 500 500 0 151,919 O 100,00 O 6,50 0 0 40,193 O 50 O 200 0 50 50,000 42,000 53,000 75000 19,000 26,000 44,000 80,797 50,000 41 000 54,000 77,000 29,000 26 000 44,000 0 All Salary Costs Inclusive of $150,500 Salary, Taxes, PERA Benefits 0 65,200 65,300 10,000 30,000 30,000 0 5,000 5,000 Wetland Health Evaluation Proj 9,000 9,000 Contracted Engineer for Cly(20 0 0 3900 3,000 Billings Info Mailings 1200 1,200 Replacements Repairs 200 200 1900 1 000 Public Info Brochure 3 500 3,500 Storm Waters Share of Premiums 6 000 6,000 Storm Waters Share of Premiums 600 600 Roadside Debris 500 500 Hazardous Materials Disposal 300 300 Auto Read Software Support 4900 4,000 Laptops 2,500 2,500 5,000 10,000 1,000 500 500 137,500 100,000 Annual Pavement Management 6,500 50% of Total Estimated Cost 15,000 1/3 of Total Estimated Cost 16,000 113 of Total Estimated Cost 0 500 2 000 500 52,000 43 000 53,000 75,000 29,000 25,000 44,000 0 10,000 605,802 592,068 802,749 734,000 767,900 70,000 2 000 1 000 Water Quality Tests (M) 500 3rd Part Inspection Program (M) 0 15,000 1,000 Repairs Sent Out 5,000 Backhoe, Lowboy, Pumps, etc 0 1,000 Utility Information 2,000 321,000 0 Storm Share of Water /Stone Issue Storm Share of Hwy 3 Project Storm Share of Connemara Proj 11 Page Two August 7, 2006 Account Descnption Actual Actual Actual Budget Amount Budget 603 49511 01 221 00 Equipment Parts 603 49511 01 321 00 Telephone Costs 603 49511 01 381 00 Electric Utilities (Copper Pond) TOTAL LIFT STATION #1 603 49512 01 221 00 603 49512 01 321 00 603 49512 01 381 00 (Schwarz Pond) 603 49513 01 221 00 603 49513 01 321 00 603 49513 01 381 00 (Birger Pond) 603 49514 01 221 00 603 49514 01 321 00 603 49514 01 381 OD (Marcotte Pond) 603 49515 01 221 00 603 49515 01 321 00 603 49515 01 381 00 (Hawkins Pond) 603 49516 01 221 00 603 49516 01 321 00 603 49516 01 381 00 (Glendalough 7th) 2007 BUDGET WORKSHEETS STORM WATER UTILITY EXPENDITURES Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #2 Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #3 Equipment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #4 Equipment Parts Telephone Costs Elec'nc Utilities TOTAL LIFT STATION #5 Equrpment Parts Telephone Costs Electric Utilities TOTAL LIFT STATION #6 GRAND TOTAL ALL DEPTS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed 0 0 0 500 500 211 211 211 300 300 183 167 210 500 500 394 378 421 1,300 1,300 0 0 0 500 500 211 211 211 300 300 0 0 0 500 500 211 211 211 1,300 1,300 581 216 350 500 500 422 422 422 300 300 2834 3,374 5,151 5,000 5,000 3,836 4,011 5,922 5,800 5800 D 0 0 500 500 211 42 42 300 300 3,098 198 177 3,500 3,500 3,309 241 220 4,300 4,300 Comments 0 0 0 500 500 0 0 0 300 300 0 0 0 500 500 0 0 0 1,300 1,300 0 0 0 0 500 0 0 0 0 300 0 0 0 0 500 0 0 0 0 1,300 613,552 596,908 809,523 748,000 783,200 153 Page One December 4, 2006 2007 BUDGET WORKSHEETS ARENA REVENUES Account Description Actual Actual Actual Budget Amount Budget 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Comments 650 31010 00 Current Ad Valorem Taxes $0 $0 $0 $0 $0 650 36210 00 Interest Earnings Investments 365 103 243 200 0 650 36215 00 Interest Earnings 120 109 76 200 200 650 36260 00 Other Revenue Learn to Skate 21,410 26,448 33,440 27,000 32,000 Learn to Skate Program (LTS) 650 36265 00 Use of Reserve Funds 0 0 0 101,700 0 650 38060 00 Prime Time Ice Fees 250,143 266 383 211,297 250,000 212,000 650 38061 00 Non -Prime Time Ice Fees 0 0 45,571 0 50,000 650 38063 00 Open Skating Ice Fees 7,998 6 244 8,973 7,000 9,000 650 38064 00 Broomball Revenues D 0 0 0 5,000 650 38065 00 Other Events Arena 0 0 0 500 0 Dry Floor Events 650 38066 00 Advertising Revenue Arena 6,970 16 200 11,650 14,000 14,000 650 38067 00 Skate Sharpening Revenue Arena 4,362 5,244 4,817 4,000 5,00D 6503609000 Concessions 3,300 3,224 3,900 3,500 3 90D 650 36C91 00 Vending Machine Revenues 12,839 10,761 10,425 12,000 12 000 650 38095 00 Pro Shop Revenues 1,440 1,409 1,133 1,100 1,100 Tape, Laces, Mouthguards, etc 650 39103 00 Gain or Loss from FIA Disposal 0 0 0 0 0 650 39201 00 Transfer From General Fund 0 0 0 0 100,000 Subsidy for Operations FUND TOTALS 308,947 338,124 331,524 421,200 445,200 11 Page One December 4, 2006 Account 2007 BUDGET WORKSHEETS ARENA EXPENDITURES Description 650 45130 101 00 Salaries Benefits 650 45130 77 101 00 Administrative 650 45130 78 101 00 Technical /Clencal 650 45130 79 101 00 Maintenance 650 45130 79 102 00 Full -Time Overtime 650 45130 103 00 Part -Time Salaries Benefits 650 45130 89 1G3 00 Learn -To -Skate Program 650 45130 99 103 00 Building Skate Guard Attendants 650 45130 01 207 00 Training Instructtonal Supplies 650 45130 01 208 00 Miscellaneous Supplies 650 45130 01 208 01 Skate Magnets 650 45130 01 208 02 Other Supplies 650 45130 01 209 00 Other Office Supplies 650 45130 01 211 DO Cleaning Supplies 650 45130 01 212 00 Motor Fuels 650 45130 01 216 00 Chemicals Chemical Products 650 45130 01 219 00 Other Operating Supplies 650 45130 01 221 00 Equipment Parts 650 45130 01 223 00 Building Repair Supplies 650 45130 01 241 00 Small Tools 650 45130 01 242 00 Minor Equipment 650 45130 01 265 DO Other Items for Resale 650 45130 01 305 00 Medical Dental Fees 650 45130 01 311 00 Officiating Fees 650 45130 01 317 00 General Fund Admin Fees 650 45130 01 321 00 Telephone Costs 650 45130 01 331 00 Travel Expense 550 45130 01 341 00 Employment Advertising 650 45130 01 349 00 Other Advertising 650 45130 01 365 00 Workers Comp Insurance 650 45130 01 369 00 Other Insurance 650 45130 01 381 00 Electric Utilities 6504513D 01 383 00 Gas Utilities 65D 45130 01 384 00 Refuse Disposal 650 45130 01 401 00 Contracted Building Repairs 650 45130 01 404 00 Contracted Mach Equip Repairs 650 45130 01 415 00 Other Equipment Rental 650 45130 01 433 00 Dues Subscriptions 650 45130 01 437 00 Conferences Seminars 650 45130 D1 439 00 Other Miscellaneous Charges 650 45130 01 521 00 Building Structure Purchases 650 45130 01 580 00 Other Equipment Purchases 650 45130 DI 710 00 Transfers 650 45130 01 710 01 Yearly Maintenance 650 45130 01 710 02 650 45130 01 710 03 FUND TOTALS 2006 2007 Object 2007 2003 2004 2005 Adopted Detail Proposed Actual Actual Actual Budget Amount Budget $106,672 10,66 42,31 69,35 3,865 4,46 36,120 25 3,83 3,58 30 2,08 1,77 81 6,00 1,00 2,30 6,32 84,16 23,465 2,940 5,702 6,951 0 453 0 0 0 14,458 24,48 7,79 15 31 3,05 1,03 2,39 18 1,55 1,47 78 6,00 1,00 2,55 6,43 87,05 26,82 2,94 3,97 4,18 50 24 7,208 25,49 3,500 7,400 3,600 12,281 44,193 87,352 4,642 32,500 26 300 94 800 4,000 34,000 27,200 98,100 25,290 24,000 25,000 15,245 15,000 15,000 Comments All Salary Costs Inclusive of $159,300 Salary Taxes, PERA Benefits 4,000 40,000 O 200 200 1,000 234 200 200 0 800 800 110 500 500 Learn to Skate Program Supplies 3,139 3,500 3 500 2,323 2,400 2 400 Battery for Maintenance 2,483 3 200 3 200 Assorted Products 29 1,000 1 000 Events Supplies 1,600 4,000 4 000 535 4,000 4,000 0 0 0 0 0 0 662 800 800 Pro Shop Supplies 0 500 500 0 0 2,400 Broomball Leagues Referees 6,000 6,000 6,000 Yearly Fee Per Admin Fee Policy 1 000 1,000 1,000 0 100 100 0 500 500 93 800 800 2,091 2,000 2,000 6 552 13,000 13,000 101,374 85,000 87000 34 957 33,000 33,000 2,881 3,500 3,500 6,212 5,000 5,000 26,933 10,000 10,000 0 300 300 592 900 900 MAMA Dues O 400 400 MAMA Seminars 0 500 500 Contingencies 3,500 7,800 3,200 O 32,000 47,000 Paint Ceiling and Duct Work O 6,000 0 3,500 3,500 0 0 3,500 0 0 320292 351,735 403,301 421,200 441,300 W V z Q z L 8 a) CO L 2 4- a) N U g c LL 0) -0 0) s 0 v) 0) a m 03 c 0 L 0 0 5) 0 v a) v 'it .a CU o E L co L a ai 0 cm 12 0 W om CIS 0 L ii 1 al 5 C R3 0 CD it RS 1 F CO •0 3 cn a) a) o s 0) tr: 03 I i i cn 0 a I E v Pa 0 S i Si c 0 (1) a) 0. 0) 0 .0 0 0. 0 a 6 1 4 0 0 Zil i 0 m c c 0 0 Z 0 s 0 0 0 C7 CO co L O o Q O to r a a) 3 o. a n o o v O •L CD O L co -c Q O 0 a) m O v 0 g c• vca i v0 1 o 8 '(7) y L. E 2" ad, -C2 o n E m i l 'a 8 8 co 0O z o.� I co '0 (0 0 0 0 0 N 0 N o Q o 0 O 00 EO o 0 2 co LLJ 00 0) a N IL X N o G c0 4 azi 4- O 0 H N CO t U 0 11 ID 4 5 Z M fa N Q O 0 QO• O Q O X M o O Ln L CO in CO CO LO In r Om Y �n X CO M 0 CI I— 1 co 1 13 CD 0 O 0 0 U) 0 N O 2 c N N. Qco d' 2 re V W N co N r F CO N .c F- a N em a) r U U 00 W H te o C7 o�' xti g U) -C no ca Z N NN�N a' o_ o .a r- W 13 o v M U) a) O X co r J cc >i r o a U ti 0 en n a O o z 0 0 rn Q ti CL p X w O I m r d co co o CL in m .r, N x R ca cri o c) c F-'' m 000000000 CD O O I� I-- O r 0 0 g N O O O O CO Cr) 00 04 4 0 N N N O O O O O e 0 0 p Li) I` CD r O CO N O Cr) 00 00 CO O O V N ff N Eft 69 69- e, -a O O O O O O O O O O O O O O O O O O N r 0 0 0 0 LO Ln M O 0) r CD r 00 N M CD CA O. 1.0 N CO EA- CD CO EA ff} EA- e a e r c. CO EA 69- ti O O N O O O O O O O O O O O O O O a 0 0 0 0 0 0 0 0 0 CD C O N CO Q) I` O N O N O LO Cfl r- O to co co a 0 O Lei O O co N M d) co N CD O N O a In CD O ML O a I.0 CO O CO Cr) I.0 f'- a CO LO r EA- N r CO 00 O LO L i M0 Q m Ef} Ef3 r e s M CO I` O s CD CO EA 69- a te- e e EA- O O N H} O CD 6) Ef} a) O M I` co ca N O O Ef 3 N d co C‘ A 0 co Q cts 0 ca H o 0 0 0 0 c 0, o 0 0 0 0 0 0 0 0 to O to O ui O tri O N N r r 0 0 0) 0) r r r r r r N- O 0 N CD 0 0 N 11) 0 0 N O 0 N M 0 0 N W H a rl 1--- U Q a_ Q U X Q CO 0 0 N LO 0 0 N '1t 0 0 0 N Tr CO ti rn co r N 0 Ln O Ln 'v— co O co N Ln co Ln Co it (NI N O a) O O O O O 1 co LL() LL() co d' N N- O LO O O O O O r r N- CO Ln CD In O N N N N- CO co CO Ln co d' N N O O O O O O r co co co O ti N O N. co co co cp r 0 co N CO cr) O CO O O O o co co co co N- N d' CD Ln N. in co N O N O 0 0 0 U N O c� N 3 a b c U 0 0 0 U N 0) 2 ?)(.Z0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 LC) I- r- CO N CO CO CO N- O LO N N r O CO 00 CO LO CO r (3) 00 N CO O N- O 00 o CO r CO IC 4 O N N Ln O O In 4 N I: LO 0) U O O O O O O O O O O O O O O 0 O 0 0 0 0 0 0 0 0 O O O O O O 0 N CO r CO CO f` Nr O) r N O) I- O 00 C O) 00 N CO I` M 00 N O) O) CO LO r CO N 69 N N r 03 CO 64 N 'Cr 69 N r CO Z r 56464 N SS Ss CO 0 6g e EP> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 t r N O N r CO 00 r O) I` d• LO r N r 00 M r N O) N a^ ti M M co M r O7 N CO co N- O) N O) r N CO LO r O 00 N LO 69 CO CO 00 CO N Ln r Lo O r r vaa CO 63 03 69 69 63 64 634 69 N 0 0) o C 42 E a) o 3 C o a) O O U a) o E (t C C a) L vJ 0) O i O C U U 0 N C� g D c� O O N 0 a) O O C9 a U) ca 03 C) UJ D 0 EL LE a a 0_ O O 0 p O O ca p Ln ti p O M CO U p N p M I CO I 6F} G1 O O O O r CO O O O O CO O C p O p O O ti m S O N e O cri r to in 0 Eft ER S E9 v 0 O O O O co N co M O O O O In d- so tri O CO O j Lo O co 69 'CI- d' NI CSC CO O r CO 0 a 69 CO e s 69 ER S N O 4.+ p O 0 0 O co CO N O CO 8 0 0 0 0 M ist O O O O O O N M N r In CO C In r ER S CO U) LL a) t c N 1 E N N (0 vi N 0 O N u) C 5 N N c c CD CT V D E N N I as n N V a c 0 c J 0 U U D D o c Q ca Q a) a� P 0) D D c c t m w w S o m c O 0) CO ti O N CO CO CO N O O CO N ti O CO H Z 0 Z W U. J a 1 W O II 1- CO LO O C) a) CO N- N N N CO CO N- N. d• ca O Od•d•r V' OONO N co co CD O O f` r M O N N sr; IC r- N M N M CD O O I- O r EA EA 69 S. 64 EA r 69- EA EA 6F} 69- EA 69 co 4 N 2 I` r- N N ti r- in LO CO d• I- N CD O r x00 NI' d•COCO COLQN O CD CO CO N O r CO co 0 C)r d•CO a)ONfl Nr-rd• O 00 O i Nd'EANNI.ON cr) -4 a)d• co EA N c O d 69 EA EA EA EA NN EA 6g EA EA EA EA t in CA Va li 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O_ CO r d• O O I` CO N r N d• O 00 co CO =N ON NI.NN ct to, 00 O ti O 0 0 0 0 0 0 0 0 O O O O 0 0 0 0 0 0 0 0 0 0 0 O O O O 0 0 O r N O N r- CO 'Cr CO d' r- O I` d• LO r a) r` d r co co co co r- M N. N a) co- (-4 r O N CO CO f- a) N O) r- N CO LO O CO r CD 0 N D. 3 EA EA 69- 6 64 EA E s s LO EA EA- r 0 CO e e s Eft a c 0 a) z c co N c C' 1 Q c Lira o> v).c .c c cQ 0 o ce a) E2 o 22 (1 a) a) c_ �m aw t o c' 711 o v o cotS oes.w OC. c4 c6= c i C) a) a) L Y Y o O a) O 0 0 c a) o O s- 0 Ii co w m O- c6 E. D OO Qw1: CDUwIi a a 0 a.w I— ca CO r- r- I- 00 O N O O r- LO N N N O O r- O O O r- l!) O O r- N r- N 0 O 0 0 0 0 0 0 0 0 O O O O O O w- e 69 EA 6F} EA EA EA 6F} EA EA EA EA Ef} Ef) 40 (0 r d) r N O r 0) C3) ti O r N X o ti o (0 r r o 6 r p r Efl E� Ef3 Ef} ER EH ER o c) c LO 03 0 U N Eft a c E t co r CO I` CO O CO (0 '1) 0 N O 0 0 CO O 0 EH ER EA S S ER EH LO 0 O CO N O N M O O N r ti e s e r Ha ER O 0 O O O O co o o Co CO co O O N C O o0 N N 6 r G 3 o LL 0 O O O O O "a 0 O 0 0 CO O t) O (0 flr e O EA LO N r r s.. m e CL co c CO ti N N if) CO S EA} o) N c O L_ .pa 2 1 f1 Q 0 1 o_c c0c co :c N N y N 0 0 c C' U N 5 a 0 C) N U 0 E 0 C 3 0 U) a 0 r) Q 0 -D stu La a920 a t E 0 o CU N o o t L o 0 0 00 o (n o W fY c CL 03 C< J 03 J c 0 co (0 o CO 0 tC) r O r H? O O O O Itc r O ti ti N O (1) Z 0 W z 2 CL W J O W H 0 a C al H CITY OF ROSEMOUNT DAKOTA COUNTY, MINNESOTA RESOLUTION 2006 A RESOLUTION APPROVING THE 2007 GENERAL FUND OPERATING BUDGET, THE 2007 CAPITAL IMPROVEMENT PROGRAM (CIP) BUDGETS, THE 2007 INSURANCE BUDGET AND THE 2007 LEVY REQUIRED BY THE CITY OF ROSEMOUNT WHEREAS, the City Council of the City of Rosemount has determined that budgets and special needs for the year 2007 will be in the amount of $15,384,400 for the General Operating Fund, the three CIP funds, the Insurance Fund levy and the Enterprise funds; and WHEREAS, the City Council has determined that special levies for Bonded Indebtedness (including $142,527 for the market value based referendum levy for the fire station) and the Armory Project total $1,957,319; and WHEREAS, the City Council has determined that actual incomes, fund transfers and anticipated aids will total $7,189,300, and WHEREAS, the City Council has determined that budgets for all Debt Service Funds total $4,628,700; and WHEREAS, the City Council has determined the budget for the Arena Fund to be $441,300, and WHEREAS, the City Council has received the Port Authority and the Utility Fund budgets approved by the Rosemount Port Authority and the Utility Commission NOW, THEREFORE BE IT RESOLVED, that the total levy certified to the Dakota County Auditor shall be $10,360,222 for the regular levy and $142,527 for the market value based referendum levy, and BE IT FURTHER RESOLVED, that the City Council approves the 2007 General Fund departmental budgets as presented to them at the Budget Hearing held December 4, 2006; and BE IT FURTHER RESOLVED, that the City Council approves the three 2007 CIP Fund budgets, the 2007 Insurance Fund budget and the 2007 Arena Fund budget as presented to them at the Budget Hearing held December 4, 2006. ADOPTED this 5th day of December, 2006. ATTEST: Amy Domeier, City Clerk CERTIFICATION I hereby certify that the foregoing is a true and correct copy of a resolution presented to and adopted by the City Council of Rosemount at a duly authorized meeting thereof, held on the 5 day of December, 2006, as disclosed by the records of said City in my possession (SEAL) William H Droste, Mayor RESOLUTION 2006 Amy Domeier, Rosemount City Clerk Motion by: Seconded by: Voted in Favor: Voted Against: Members Absent: CITY OF ROSEMOUNT DAKOTA COUNTY, MINNESOTA RESOLUTION 2006 A RESOLUTION LEVYING A TAX FOR CONSTRUCTION OF A STATE ARMORY BUILDING WHEREAS, the City Council of the City of Rosemount has entered into an agreement with the Minnesota Army National Guard to construct an Army National Guard Armory within the City of Rosemount. WHEREAS, Minnesota Statutes, Section 193.145, Subdivision 2, provides in part, that a municipality in which an armory has been constructed or is to be constructed hereunder may by resolution of its governing body irrevocably provide for levying and collecting annually for a specified period, not exceeding 40 years, a tax which, unless levied by a county, shall not exceed 0 00798 percent of taxable market value NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Rosemount as follows 1. In accordance with Minnesota Statutes, Section 193 145, Subdivision 2, there is hereby levied upon all of the taxable property in the City a direct annual ad valorem tax in the amount of 0.00798 percent of that taxable market value spread upon the tax rolls and collected with and as part of other general property taxes in the City of Rosemount beginning in 1993 and continuing until all funding requirements for the construction of the armory have been satisfied 2. The proceeds of the levy shall be used for the purpose of funding the construction of a new state armory. 3. The obligation of the City to levy, collect, and pay over the taxes shall not be deemed to constitute an indebtedness of the City within the meaning of any provision of law or of its charter limiting its total or net indebtedness, and such taxes may be levied and collected without regard to any statutory or charter provision limiting the amount or rate of taxes which such county or municipality is otherwise authorized to levy. 4. The Clerk is hereby directed to file a certified copy of this resolution with the County Auditor of Dakota County, Minnesota, together with such other information as the Auditor shall require, and to obtain the Auditor's certificate that the tax levy has been made ADOPTED this 5th day of December, 2006. ATTEST: Amy Domeier, City Clerk RESOLUTION 2006 William H. Droste, Mayor CERTIFICATION I hereby certify that the foregoing is a true and correct copy of a resolution presented to and adopted by the City Council of Rosemount at a duly authorized meeting thereof, held on the 5th day of December, 2006, as disclosed by the records of said City in my possession. (SEAL) Amy Domeier, Rosemount City Clerk Motion by. Seconded by. Voted in Favor: Voted Against Members Absent CITY OF ROSEMOUNT DAKOTA COUNTY, MINNESOTA RESOLUTION 2006 A RESOLUTION APPROVING A SPECIAL TAX LEVY FOR FUNDING OF AN ARMORY WHEREAS, the Minnesota Army National Guard has selected the City of Rosemount as the location of an Army National Guard Armory; and WHEREAS, the City Council of the City of Rosemount, by its Resolution No. 1990 -24, adopted March 20, 1990, approved the establishment of an Armory within the City and is desirous of seeing this project completed; and WHEREAS, Minnesota Statutes Section 275 50, subdivision 5, clause (d) authorizes the City of Rosemount to levy an amount up to $95,000 for taxes levied beginning in 1990 for the purpose of acquiring an armory and to be serviced by the levy without regard to the limits on debt service and debt otherwise provided by Minnesota Statutes, chapter 193 or 475; and WHEREAS, the Rosemount City Council has held the required public hearing and met all public notice requirements for this special levy as set out in Minnesota Statute Section 275.50, subdivision 5, clause (d). NOW, THEREFORE, BE IT RESOLVED, that the City Council of the City of Rosemount hereby authorizes a special tax levy to be levied in 2006 and collected in 2007 in the amount of $95,000 for the purpose of meeting funding requirements for the construction of an Army National Guard Armory ADOPTED this 5 day of December, 2006. ATTEST: Amy Domeier, City Clerk William H. Droste, Mayor RESOLUTION 2006 CERTIFICATION I hereby certify that the foregoing is a true and correct copy of a resolution presented to and adopted by the City Council of Rosemount at a duly authorized meeting thereof, held on the 5 day of December, 2006, as disclosed by the records of said City in my possession. (SEAL) Amy Domeier, Rosemount City Clerk Motion by: Seconded by: Voted in Favor Voted Against Members Absent. a.+ O N CU O "0 NI CC O V W V z z LL prz r0 5 (n w w CA 0 S a 0 w y n E a 6 ry O 0 j S w 0- 7 07 s a C 0 S a P y ,0 ti C Ni in P R a P R O a. r d 0 c a w T b 0 N o Q 0o W O m (0 Q w n 69 N 0 A 00 O rn w m P 69 be J 0 0 o o 0 0 o• 0 c 0- 0 N 00 00 NIP J A 0 O O EA O be N 00 a\ 00 .o ON In w 0 0 O o W J 00 D ID O O 0 W O 00 W Cr, NJ 00 fA 00 En 69 69 N 0 0 0 0 in CO O A 00 00 W W A 00 J 'd o'o <n �Lc .7 a- ti O 5 O C n 0 a o" N a C n v c- n 0 Q m R w c a (D a n n w O o 0 w. a 0 'a y v, G o c. n -4 ,4 (D w a F'� '0 a Po 0.°G 2 C O 0 o n w m G Q' R 0 R 0 D r, C (D 0 C.; 0 a 0 U n Q co (D a Ln h C a c o Q a to n n .0 7 (1 0. n0 n m N 0. C C "A H ti n w (0 o o n m K 'Q in G., a n (J0 6 0 G a N n n n o c y w d 0 G ca up O 0 gag n y w a. n 2 0 c --t 5 o o w S_ o 0 a CO 0 fl- S 2 c (0 Q n CA (D a W ti (D 'l" a G 2 N o O N w N a rt w' 7 N O N N 00 W O O. 0 D o e e Czel 00 00 U N 0 0 J N 0 O 0 y m 0 (n co r9 ���C F. a 0 r° m -D c a 2 .n a .n .c 9- -E' f P. C c y C C G a n z n a rt v.< o. ,aa, C] a a ro El Ft- w o 29 Hi Vi EIS fa9 b3 V N W A O 0 co O A w O 0 0 O 0. 0 0 0 0 A 0 0 0 0 0 fA O K o o< 0 Q n w< 0 Q n O C 0 Y o Q p Co C Po n In CD Po (D w `II .j a C 3 Q rro w d r b H. a (D nw u. 0 K M .0 ry 0 7— O o g O `C n e N n ".'C R O w N f W 0 N w G �n w 0 N -r (J U a s v a 0 n 0 2 n 0 2 E ri 4 c! 0. '2^ w 0 w w" n a N v n 0. 00 -•0 d N C p w n (n n 0 o-0 n D, a n 0 0 o CD a y Q' w O 'd '_'i r C 2 N C a p n Vi (D a CD w W v N G a o n N p cc Cfv .Qy N W G y o a- O 0 w '."3 a W b Q< TS N 0 CD 0 v M (D o p n Q t c. co 1) n w a 0 o w Q rn u .-1 Q n v t" w n o o a &D w' 0 L0 -a 7 p (0 0 0 a s p w 0 3 v, 0 o w w (D n o w O" M u, o o v/ 0 bi 21 Q, (D n (a a' Q. 0 a 0 1n (D `G (D as a A N a .w+ 0. w o w 10- v �1 0.- CD 0 wcs Ci i< x N Q y" n w n 05 Z' v N m w rio w �-n Co N f° co CD 0 0 o O Q a 0- (0 Q v n 2 n a' Q y G O 0 a 's n v: o o' o a o a CD CD a 0. 0. n (D 'I 0 Y c F D o s a: p.) w n 7, n o a m a a N G N W w 2.t_.• 'O tl o w o-0 O S 8 w n Cf0 o n S Q O w n p a n a p rp 0 (D w n 'c n w c: o CD N" C h n C w n o m w II0 w 3 h v P x Q Q Q I P o 0' n r tl0 o v N a 0 iD 0,. 02 c n 9 w d o w` o ,"-r o a a O a1 a O O X (I r q N g- v N O O '"d (D n 1n 0 0 A Co 0 a n (/1 a- on n 0 0 G w w F. a O 0 �0 10 QD 0 c a n n 0 M O 00 00 1 'ov 'c?1^uno'?ftn>n Re G o°< p r a o ,a K 7r) r00 •0 CA 70' a 00 c c N Ur a o- w F m c Qb7w a p' a 7 N Q" rn a o ac 0 0o c W el "I N y 0 rn o ,w-. n a a P bO 69 0/1 69 29 EA A. 0 (M (1' A O O` N N W D N J W n A J ■0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 A .0 A w 00 0 A 1y 04 N W J J 0 o a c o 00 A D A w 00 O A 0 N N 00 O, y1 0 O. N J A oo G N 0 X n w b, M .69 49 b' 45 E0 69 N C V 01 O NJ 6 O O a a 6 N O. 00 W W V, N C. w '0 O0 N A J 00 A W N 0 N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N N 0 J N 1J 0 A N W J 0 .0 0' A W J J .0 A 00 Vi v e c o 0 0 o c N 40 N O J N N A 0 N V, pp w 00 A A la la J J N N A J