HomeMy WebLinkAbout6.d. 2007 BudgetAGENDA ITEM: 2007 Budget
AGENDA SECTION:
Discussion
PREPARED BY: Jamie Verbrugge, City Administrator
AGENDA NO. 2.D.
ATTACHMENTS: 1 2007 City Budget Report
2 Health Insurance Information
3 Pavement Management Program
Memo
APPROVED BY:
RECOMMENDED ACTION: Discussion
r 1 LOSE lOUNT
CITY COUNCIL
City Council Work Session October 11, 2006
ISSUE
The City Council set the preliminary levy for 2007 at its meeting on Tuesday, September 5. The total levy
adopted by Council represented an 11 10% increase over the 2006 spread levy. The adopted levy included
$166,000 of needed reductions, which were unidentified at the time, in the various departmental and
capital budgets The effect of the adopted levy to the City's tax rate was a 2.03% reduction.
The issues intended for discussion at the Work Session include an overview of the recommended
adjustments to the budget, review of the City Administrator's recommendation to change health insurance
carriers, and a review of the Pavement Management Program.
BACKGROUND
EXECUTIVE SUMMARY
Btedret Ad mtments
Attached for Council's review are the updated respective departmental summaries accompanying their
operating and capital requests for 2007 Staff has also received updated information from Dakota County
on the preliminary levies adopted by the other taxing jurisdictions that allows us to show a more complete
picture of the overall taxing effect of preliminary decisions for 2007 property tax statements.
The preliminary levies set by other jurisdictions, combined with amendments to the City's budget since
September 5, show a total tax rate reduction of 6.46 The City's respective share of that is a 2.97%
decrease in City tax rate after proposed reductions. The actual dollar impact to the average residential
taxpayer (one experiencing a 5.5% increase in taxable market valuation, a number provided by the Dakota
County Assessor) of combined preliminary levies and amended City budget recommendations is a $37
decrease in taxes payable.
The recommended adjustments to the City's budget are summanzed below:
A reduction of $30,000 in the Capital Improvement Plan for the purchase of new computers.
A reduction of $10,100 in the Police Department budget resulting from the elimination of funding
for software that was being investigated as part of a collaborative county -wide review of police
squad equipment.
A reduction of $40,000 in the Parks Ground Maintenance division of Public Works resulting
from the elimination of funding to repave the parking lot at Schwarz Pond Park.
A reduction of approximately $70,000 in the Administration budget to add an Administrative
Assistant position.
Staffing adjustments recommended include elimination of two positions, reduced funding for a
currently vacant position, and a small increase for temporary help.
For the past two years the City budgets have included funding for a Staff Engineer (a
revised job description following the departure of the Water Resources Engineer) and a
Public Works Supervisor Recniitnent for the Staff Engineer did not result in desirably
qualified candidates. The work associated with this position has largely been
accomplished in shared reassignment of duties to other positions The Public Works
Supervisor was one of two supervisor positions that had previously been approved by
the City, but the determination by Council was to only fill one position. Staff has not
requested filling the second supervisor position.
The Code Enforcement position is currently vacant. Responsibilities have been
managed by reallocating duties to the building inspections division of Community
Development. The Administrator's recommendation is that this budget be funded at .5
FTE for 2007. The decision to fill this position will largely be driven by the pace of new
residential development; i.e an increase in new housing starts would require more time
of the inspector currently performing the duties and necessitate filling the code
enforcement position. It is not anticipated that such a change in new housing starts
would be apparent until summer 2007. The budget effect of this action is that filling the
position in 2007 would tngger a .5 FTE increase in the 2008 budgeting process to staff
the position full time.
An additional $7,000 line item for temporary /part-time staffing has been added to the
Administration budget for coverage of the Receptionist position Most often during the
year, coverage is provided through interdepartmental cooperation and shared staffing.
There are times during the year when extended absences, vacations, and especially busy
seasonal work requires that someone is brought in from outside.
The financial impact of a recommended change in health insurance carners (a total reduction of
nearly $50,000 split between the general fund and utility budgets) is also included in the budget.
This item is more thoroughly summanzed later in this memo.
An addition of $13,000 in the Council budget to increase the City's newsletter from a quarterly
distribution to bi- monthly. The Parks Recreation brochure would also be spun off and achieves
cost savings as a result.
The net effect of these recommended changes is a reduction in the previously calculated overall spread
levy, so that the proposed spread levy for 2007 would now be an increase of 10.05 Discussion by
Council Members at the August 23 Special Work Session seemed to indicate a consensus of opinion that a
10% increase in the levy was the most taxpayers could reasonably be expected to accept. The budget
adjustments recommended herein land squarely on that number
Health Insurance Change
The City currently purchases its health insurance benefits through the Southwest Services Cooperative
(SWSC), a pool of public sector organizations that work with the Appletree Institute to collectively
negotiate insurance plans and premiums. SWSC contracts with Blue Cross -Blue Shield of Minnesota as its
insurance career
The benefit of being in a cooperative is that organizations, especially smaller ones, can pool their
experiences to better negotiate favorable insurance rates. This has the advantage of buffering premium
increases to some extent when an organization experiences higher than anticipated utilization. The
disadvantage, as witnessed by the City of Rosemount for 2007, is that when an organization has one or
several years of very favorable experience ratings it does not always translate into the savings that would
otherwise he anticipated to accompany those good years. For 2007, Rosemount falls into the category of
organizations that would need an Increase of less than 1 °-o but is sell being given an increase of 7.5 in
premiums.
The City changed its health insurance plan a couple of years ago to a high deductible VEBA plan The
change was made because of the cost containment potentia] of the VE13A plan compared to the double
digit increase that would have been experienced if the City had continued its high premium plan The
VEBA plan is what is referred to as a "consumer- dnven" plan that places a greater emphasis on employees
to manage costs and health care decisions It is (I shared cost structure between the employer and
employee that provides lower premiums and includes a City contribution to the employees VEBA health
management investment account.
A committee of employees was formed last year to evaluate benefits and wellness programs. Two months
ago, the committee requested that .a Request for Proposals be prepared by the City's insurance broker
(Amy Dtednch of CBIZ) to determine if more favorable rates would he achieved if the City were to leave
SWSC and purchase health insurance on its own Proposals were received from Medica, HealthParmers,
and Preferred One. The Preferred One proposal was the closest in plan design to the current plan and
also offered the most competitive cost structure.
Staff is recommending that we leave SWSC and engage Preferred One as the City's insurance carrier. The
plan design and funding structure developed by Preferred One, CBIZ, and staff would result in total
annual reduction in health insurance costs of $13,861 for employees (premiums paid) and $49,632 for the
City in 2007.
The primary issue of discussion for the City Council regarding the change in carrier is an evaluation of
whether the future risk of purchasing health insurance independently of the cooperative is in the City's
best financial interests In an attempt to understand that nsk equation, CBIZ prepared a three -year
projection scenano that tnes to cost out premium changes through SWSC with changes in the Preferred
One proposal Those projection scenanos are attached for your review. Staff will explain the projection
scenarios in greater detail at the meeting, but believes the potentia] costs to the City over a three year
period justify the recommendation to leave the cooperative and contract independentywith another
health insurance carrier.
Pavement Management Program
City Engineer Brotzler has prepared the attached memo discussing the City's Pavement Management
Program (PMP). The Council has annually re-viewed the PIMP objectives and funding formula as part of
the budget process since developing the program
SUMMARY
Staff requests that Council discuss the items detailed above and give direction to continue moving toward
final budget and levy adoption in early December. Based on previous work session discussions, staff has
revised the calendar for budget review. Staff requests further direction on the calendar as well.
October 11 Council Work Session
Review budget adjustments since September 5 action to set preliminary levy
Review recommendation to change health insurance carrier
Review the Pavement Management Program
October 25 Special Work Session
Update year -to -date and year -end fiscal forecast
Update key financial strategies Financial Management Plan
Review 10 -year capital improvement plan
November 8 Special Work Session (if necessary)
Items of interest to Council
November 15 Regular Work Session
Final budget discussion
December 4 Special Council Meeting
Truth in taxation hearing
December 5 City Council Meeting
Final budget and levy adoption
4
20O7
CITY BUDGET REPORT
(70/77/06 Draft)
4ROSE&
OUNT
MINNESOTA
October 11, 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%
Administration Budget 518600 521,400 5,800 1 12%
Elections Budget 38.900 61,000 21100 58 81%
Finance Budget 308,900 331,200 22,300 7 22%
General Government Budget 361,700 374,100 12,400 3.43%
Community Development Budget 888000 884,100 (1,900) -0 21%
Police Budget 2,339,700 2,607,200 267,500 11 43%
Fire Budget 283,400 291,800 8,400 2 96%
Public Works Operating Budgets
Government Buildings Budget 390,500 428,100 37,600 9 63%
Fleet Maintenance Budget 478,000 525,400 47,400 9 92%
Street Maintenance Budget 1,153,700 1,159,200 5,500 0 48%
Parks Maintenance Budget 532,800 555,000 21200 4 17%
Park 8 Rec Budget General Operating 967 700 1,034500 62800 6 49%
Park 8 Rec Budget Special Programs 91,500 102 500 11,000 12 02%
Total Operating Budgets General Fund 58,516,300 $9,168,600 5652,300 7.66%
Building CIP Requirements 24,000 24,000 0 0 00%
Street CIP Requirements 1,100,000 1,050000 (54000) -4 55%
Equipment CIP Requirements 250,900 303,000 52,100 20 77%
Insurance Budget Requirements 260,000 260,000 0 0 00%
Port Authority Operating Levy 60,000 0 (60000) -100 00%
Bonded Indebtedness 1.599,360 1,545,364 (53,996) -3 38%
Bonded Indebtedness Fire Stabon Levy 154,308 142,527 (11,781) -7 63%
Armory Anticipatory Levy (Value 7/18106) 248,422 269,428 21,006 8 46%
"$95,000 ($2,185,821,500 x 00798
Water Enterprise Fund 1,258400 1,832,100 573,700 45 59%
Sewer Enterprise Fund 1,432,000 1,457,500 28500 1 78%
Storm Water Enterprise Fund 748,000 781,700 33,700 4 51%
Arena Enterprise Fund 421,200 439,600 18,400 4 37%
Total Funding Requirements $16,072,890 517,273,819 $1,200,929 7 47%
NOTE Special Levies include (1)Bonded Indebtedness, (2)Fire Station Levy and (3)Armory Anticipatory Levies
October 11, 2006
Types
Internal Revenue Generated
Licenses and Permits 859,700 651,100 (208,600) -24 26%
Intergovernmental 525,000 556,000 31,000 590%
Charges for Services 1,160,700 911,900 (248,800) -21 44%
Fines F. Forfeits 90,000 90,000 0 0 00%
Recreational Fees 236,200 228,000 (8,200) -347%
Miscellaneous Revenues 152,000 182,500 30,500 2007%
Transfers In 3,500 3,500 0 000%
Enterprise Revenues 3,859,600 4,510,900 651,300 16 87%
Total Internal Revenues 6,886 700 7,133,900 24 359%
MVHC Cuts Made Later To Include in Levy 350,330 350,330
Levy Sources
Special Levies 2,002,090 1,957,319 (44,771) -2 24%
General Levy 7,534,430 8,532,930 998,500 1325%
Total Levy $9,536,520 510,490,249 $953,729 1000%
Loss of MVHC from State Funding $350,330 5350,330 $0 n/a
Total Revenue Sources $16,072,890 $17,273,819 $1,200,929 74796
NOTE Special Levies include (1)Bonded Indebtedness, (2)Fire Stabon Levy and (3)Armory Anticipatory Levies
FUNDING REQUIREMENTS SOURCES
(INCLUDING FIRE STATION LEVY)
2006 2007
Adopted Proposed
Budget Budget Difference Percentage
2006 GENERAL PROPERTY TAX LEVY PAYABLE 2007
GENERAL LEVY
GENERAL FUND $6,895,930
BUILDING CIP FUND $24,000
STREET CIP FUND $1,050,000
EQUIPMENT CIP FUND $303,000
INSURANCE FUND $260,000
PORT AUTHORITY OPERATING LEVY $0
TOTAL GENERAL LEVY $8,532,930
BONDED INDEBTEDNESS
G 0 MUNICIPAL BUILDING REFUNDING BONDS 1998A (ICE ARENA) (Authorized $258,957) $258,957
G 0 IMPROVEMENT BONDS 1999B (Authorized $19,533) $19,533
G 0 IMPROVEMENT BONDS 2001A (Authorized $119,604) $0
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 (Authonzed $210,737) $210,737
G 0 EQUIPMENT CERTIFICATES 2005E (Authorized $349 198) $349,198
G 0 EQUIPMENT CERTIFICATES 2006A (Authorized $87,955) $87,955
G 0 IMPROVEMENT BONDS 20066 (Authorized $75,081) $0
MARKET VALUE BASED REFERENDUM 1995 FIRE STATION LEVY
0.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 (As of 7 /18/06)
TOTAL PRINCIPAL AND INTEREST ON ARMORY BONDS
GRAND TOTAL 2006 PROPERTY TAX LEVY
Last Updated 10/5106
TOTAL BONDED INDEBTEDNESS $1,545,364
$142,527
$142,527
$269,428
$269,428
$10,490,249
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 Distributuwn 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 1015106
SPREAD LEVY COMPUTATIONAL WORKSHEET
(INCLUDING FIRE STATION LEVY)
2004 2005 2006
14,088,248 14,809,814 16,072,890
6,165,131 6,258,800 6,886,700
152,193 153,426 154,308
7,770,922 8,397,588 9,031,882
350,330 nfa 350,330
8,121,252 8,397,588 9,382 212
844,509 804,414 770,288
7,276,743 (1) 7,593,174 (1) 8,611,924 (1)
4 35% 13.42%
152,193 153,426 154,308
(Proposed)
2007
17,273,819 (4)
7,133,900
142,527 (3)
9,997,392
350,330
10,347,722
(1) Actual Spread Levy Based on Numbers from Dakota County
(2) 2007 Number Provided by Dakota County as of 8/09/06
(3) Market Value Based Levy for Fire Station Based on 5142,527 Levy Spread to Taxable Market Value on 12/31/06
Last Update from Dakota County 7118/06 Shows the Levy of 5142,5271 52,185,821,500 $.0652 per $1,000 as our Estimate
(4) In 2004 Started Including the Water, Sewer, Storm Water Arena Enterpnse Funds in These Figures
870,514 (2)
9,477,208
10.05%
142,527 (3)
69
N
N.)
69
CO
CO
o cn n cn7,nn
AF Z1s A,� 0 ac.<
a 0 N O CD y n a 0
m m m a m m 0 -7 .g
a O a a 3 K G9 a.) CD
j m
f 0 f N 1 a N O d
a
RI m N C 7" m
N `G N 0 d 0 0 N
3 d n
d d o N N
CD
N N O VI co
a Ci S
T d
3 f N N
O y VI O
n 4 1
O
O j N
co
N
-a CO Cl N (0
O) co N a
N
49 C 69 a
A U) CO J
EA
N
et
CO N V
N O) (0 W
69
N W A
69 7 4
V
g 69
69 N
N (9
4,
6
69 W M 01
0)
69
69 69 69
J
61
69 69 6) 0
N CO W
4,
69 69 0) j
N Cr) 0) A
0 U) O) N
f
E9 f9
O W W
69 '69
69 O) 69 W
(9 A CO N
69 61
EA 02 A (00
N
N
0 t
49 C N t D
co NJ O 0
01 O
O 0
O
O: aD
m x J 0 9 Pp
69 F C) m -O c X
d
CD O c m a
m
D
N r
y
0 V O C
dx-a
-69 03 7 0
Ea
N o N 8 g O 2
N °mo on
O
o m
D
cn
d N O cn
d O
N S w N 0
5 Z 52
O
m
Cv 0 3 U)
8 K N n
co 5 N N
p s N N
7
N a) N a 0
Page One
October 11, 2006
Account
101 32110 00
101 3216000
101 3216' 00
101 32210 00
101 32212 00
101 32220 00
101 32221 00
101 32230 00
101 32240 CO
101 32250 CO
101 32255 00
101 32260 00
101 32290 00
101 31010 00
101 31010 01
101 31020 00
101 31030 00
101 3171000
101 3181000
101 31811 00
101 31920 00
101 33100 00
101 3341600
101 33416 01
101 33416 02
101 33418 00
101 33423 00
101 33425 00
101 33620 00
101 33630 00
101 33630 00
2007 BUDGET WORKSHEETS
GENERAL FUND REVENUES
Description
101 31010 00 Current Ad Valorem Taxes
101 31040 00 Fiscal Dispartes
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)
Electrcal Permit Revenue (L)
Admen Fee Electr cal 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 Lic 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 (1)
Franchise Taxes Regular Fees (I)
Franchise Taxes PEG Fees (I)
Forfeited Tax Sale Apportionment (I)
Federai Grants Ads (t)
Police Training Reimbursement (I)
Post Board Training Reimb
State Aid (Tied to PERA)
MSA for Streets Maintenance (I)
Ag Preserves Credit (1)
Other State Grants Ads
Other County Grants Ads (I)
Police Services Levy -ISD #196 (I)
D A R E iLiaison Funding
Total Intergovernmental (1)
2006 2007 Object 2007
2003 2004 2005 Adopted Detail Proposed
Actual Actual Actual Budget Amount Budge'
$3,989,670 $3,949105 $3,872,826 35,069,242
771,998 844 509 804,4 770 288
4,751,668 4,793,614 4,677,240 5,839,530
64,117
10,768
14,055
107,540
9,747
2,183
0
102,805
29,445
2,538
16,353
17,328
45,767
99,711
10,792
9,594
121,479
10,570
0
0
112,834
79,338
8,675
29,690
131,522
12,506
0
60,000
122,641
28,300 26,715
0 1,197
16,952 17,668
13,810 15,000
46 936 48,512
(350,330)
5,489,200
19,160 27,637 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,'88 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 815502 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 608 91 801 50,000 34,000
345 770 1 700 1,000 1,000 Alarm Permits Fireworks Permits
915,589 1,295,164 1,194,106 859,700
91,000 91,000 91,000 91,000
60,000
10,000
10,000
120,000
10,000
0
0
7,000
110,000
29,000
a
13,000
15,000
50,000
513,648 561 978 644,465 525,000
PAGE TOTALS 6 190 903 6,650 756 6,515,811 6 873,900
91,000
7,000
120,000
62,000
$6,125 842 From County
770 298 From County
6,895 930 Total Property Tax Levy for Fund 101
(350,330) State Cuts in MVHC Permanent''rr
6,545,500 Actual Property Taxes to Receive
651,100
91,000 Included in Debt Levy Figure
60,000
10,000
15,000
125 000
12 000
0
0
127,000
26,000
0
13,000
15,000
62,000
556,000
7,752 700
From County
From County
From County
From Cable Company
From Cable Company
From County
From State
From State
From State
From State -PERA Aid Safe Sober
Dakota County Recycling Funds
From ISD #196
Page TWO
October 11, 2006
2007 BUDGET WORKSHEETS
GENERAL FUND REVENUES
2006 2007 Object 2007
2003 2004 2005 Adooted Detail Proposed
Account Descnpbon 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 (C1 413,876 444 950 405,606 368,700 350 65 of Building Perri; fees
101 34105 00 Sales of Maps Pubacations (C) 2,816 2 311 2,632 3000 1500 Moos Spec Books
101 34106 00 Deputy Registrar Fees (C) 48,438 49 392 52406 50,000 50350
101 34107 00 Assessment Searches (C) 20 0 0 100 0
101 34108 00 Admm Fees Other Funds (C) 199,254 337,753 341,127 125.000
101 34105 01 Applicable Funds Except Const 25,000 25 000
101 34108 02 Construction Funds 225,000 100 O00
101 34 00 Other Charges for Service (C) 6,127 9,853 11,370 5 000 5,000
101 34110 00 Service Chg on Returned Chks (C) 345 240 210 200 200
101 3411200 Utility Permit Application Fee (C) 450 1,525 575 1,000 500
101 34150 00 User Fees SKB 0 95,092 255,923 300,000 250 C00 SKB Fees from New Cells C D
101 34151 00 User Fees /Host Agreements SKB 0 25,000 25,000 25,000 25,000 Landscaping Agreement (Yr 4 of 10)
101 34150 00 National Guard Maint Fees (C) 45,808 46,362 46,715 46,000 46,500
101 34150 00 Shared Space Rental Agreement 16
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 O/T for Officers
101 34202 00 Fire Services Burning Permits (C) 5,500 1,188 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 1,645 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,000
101 34301 00 Street, Sidewalk Curb Repairs (C) 0 10,973 0 0 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,688 90,000 90,000 From County
Total Fines Forfeits (F) 89,752 96,902 87,888 90,000 90,000
101 34720 00 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,480 1,445 1,120 1,500 1,500
101 34724 00 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,000 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 for 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,831 14 3 6,000 6,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 38080 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,308 12 000 12,000
101 38082 00 Gymnasium Fees (11) 20 321 20,890 24,363 21 000 21,000
101 36086 00 Classroom Fees (R) 30 037 21 591 9,361 28,000 16 Loss of ECFE
101 38096 00 Liquor Provider Fees (R) 1,050 1,170 1,050 1,500 1 500
101 38097 00 AN Rental Fees (R) 1,706 1,342 1 587 1 500 1 500
101 38154 00 Teen Night Revenues (R) 5 670 6,222 6 092 6 000 6 000
Total Recreation Fees (R)
PAGE TOTALS
243,777 247,706 247,942 236,200 228,000
1,170,430 1,566,821 1,619,489 1,486, 900 1,229 900
Comments
Page Three
October 11, 2006
2007 BUDGET WORHSHEETS
GENERAL FUND REVENUES
2006 2007 Object 2007
2003 2004 2005 Adoped Delall P•oposed
Account Description Actual Actual Actual Budget Amount Budget
Comments
101 36101 00 Principal Special Assessments (M) 23,655 41,114 14,063 20,000 20,000 From County 101 Funded Prolecs
101 36102 00 Penalties Interest SIA (M) 82 69 101 0 0 From County
101 36213 30 Interest Earnings- Investments (M) 100,891 147 176951 120,000 150400
10 36214 00 Net Charge in FM (M) 6432 (6,326) (34 218) 0 0 Ar nual Market Value Cranges
101 36215 00 Interest Earnings (M) 1,434 1 226 722 1,500 1 OCO From Checking Ascounl
'01 35220 00 Rents Royalties LM) 4 394 5,383 5,712 5400 5,500 LS' West Artenna Rent
101 36230 00 Contribution/Donations (M) 77,884 44633 33,765 0 0
101 36260 00 Other Revenue (M) 1,570 18 734 4,531 2,000 2000
101 36265 oo Use of Reserve Furds (M) 0 0 0 0 0
101 38090 00 City Concessions (M) 3,506 3 662 4,574 3,500 4,000
Total Misc. Revenues (M) 219,848 255,502 206,201 152,000 182,500
101 39202 00 Contribution from Enterpnses (T) 3,500 3,500 3,500 3,500 3,500 Arena Building Grounds Mamt
101 39203 00 Transfer From (T) 0 0 0 0 0 Funds Returned from Protect
Total Transfers In (T) 3,500 3,500 3,500 3,500 3,500
PAGE TOTALS $223,348 $259,002 $209,701 $155,500 $188,000
DEPARTMENT TOTALS $7,584 681 $8,476,579 $8 345 001 $8,516,300 $9,168,600
INTERNAL REVENUES $2 823 013 $3,682,965 $3,567,761 $3 027,100 $2,623,000 Grand Total Less Ad Valorem
Fiscal Disparities
Page Four
October 11 2008
2007 BUDGET WORKSHEETS
GENERAL FUND REVENUES
20G6 2007 Object 2007
2003 2004 2005 Adopted Cetal Proposed
Account DescnpLcn Actual Actual Actual Budget Amount Budget
101 34108 00
101 34108 01
101 34108 02
101 34108 03
101 04108 04
101 34108 05
101 34108 06
101 3410807
101 34108 08
101 34108 09
General Fund Adman Fees
Fund 201
Fund 202
Fund 203
Fund 206
Fund 207
Fund 605
Fund 606
Fund 607
Fund 8 850
525,000 $25,000 $25,000 $25,000 $25,000
6,000
2,500
2,500
2,500
2,500
1 000
1,000
1 000
6 000
Adman Fees Breakdown Totals $25,000 $25,000 $25,000 $25,000 $25 000 $25,000
Comments
The City Council is responsible for establishing the mission and vision for the City of Rosemount.
The Council also establishes community goals and supervises the activities of the City
Administrator
POLICY DEVELOPMENT
Provides for the legislative and policy -making activities for all of municipal
government
Provides for the planning and control of all City expenditures through the adopuon
of the City's annual budget.
Provides for the definition of the City's tax structure through the levying of taxes and
approval of user fees and rate structures.
Provides for citizen input to policy making process by establishing, appointing and
managing advisory commissions, ad hoc committees and community groups
GENERAL OPERATIONS
CITY COUNCIL
Provides funding for general government projects and needs such as:
City Newsletter
Chamber of Commerce Directory
Key Financial Strategies
Page One
October 11, 2006
2007 BUDGET WORKSHEETS
COUNCIL
2006 2007 Object 2007
2003 2004 2005 Adopted Detail Pr000sed
Account Description Actual Actual Actual Budge' Amount Budget
Comments
All Salary Costs Inc uswe of
101 41110 103 00 Salaries Benefits $26,820 $25,695 $28550 $26,400 $33 900 Salary Taxes, PERA Benefits
101 41110 01 225 OC Landscaping Materials 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 18,000 16,500 9,000 20 000
101 41110 01 310 00 Temporary Service Fees 0 0 5,034 0 0
101 41110 Cl 319 00 Other Professional Services 6,402 1,925 11,114 12,000
101 41110 01 319 01 Education Reimoursement 7,000 7,000
101 41110 01 319 02 HIPP Initiatives 5,000 5,000
101 4111C 01 319 03 Community Forums 10,000 0
101 4'110 01 321 00 Telephone Costs 0 0 0 0 1,000
101 41110 01 32 01 Mayors Pager 400
101 41110 01 321 02 Mayor's Cell Phone 800
101 41110 01 329 00 Other Communication Costs 180 128 263 1,000 1,000 Newspaper Ads r 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,9 52 5 000 5,500
101 41110 01 433 03 NOCC Dues 519 1,086 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,835 1,421 4,000 4000
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 119504 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 100500 Arena Operating Subsidy
PAGE TOTALS $95,590 $365,634 $392,134 $167,900 $297,100
DEPARTMENT TOTALS $95,590 $365,634 $392 134 5167,900 $297 100
GENERAL ADMINISTRATION
RECEPTION
ADMINISTRATION DEPARTMENT
The Administration Department is responsible for the overall management of all departments within
the City and for assuring that departmental activmes are consistent with the goals established by the
City Council.
Provides overall management admuustratton and coordination of activities in all City
departments including Community Development, Finance, Fire, Police, Public
Works and Parks Recreation
Provides for preparation and overall management of the City's budgets.
Provides project management for projects that are umque and therefore not
assignable to any other department
Provides overall coordination of City consultants.
Provides for the execution of all policies as adopted by the City Council.
Provides administrative and clerical support to the City Council including the
preparation, distribution and maintenance of City Council meeting documents
RECORDS MANAGEMENT
Provides for the preparation and maintenance of official records for the City
including Council, Port Authority and Comrrussion minutes.
Prepares and assures publication and posting of official notices.
Provtdes public information on ordinances, contracts and policies.
Adtmmsters the collection, storage and dissemination of data
Provides General Government /City Hall reception administration.
LICENSING
ADMINISTRATION DEPARTMENT- Page 2
Provides for the issuance and renewal of the following hcenses:
Liquor and beer
Peddlers, sohcitors and transient merchants
Gambling permits
Kennel hcenses
Block party street closures
PERSONNEL ADMINISTRATION
STAFFING
Provides human resources services to improve the recruitment and retention of City
employees.
Administers the City's personnel pohcies and procedures, assures comphance with
union contract language, as well as state and federal labor regulations.
Admuusters employee compensation and benefit plans, assuring comphance with
state and federal regulations.
PUBLIC INFORMATION AND MARKETING
Prepares communications to residents about City government activities.
Creates and coordinates marketing publications directed to business sectors outside
of the community for economic development.
Assists in preparing messages and collateral material for internal communications.
For 2007, the department will consist of five positions
City Adminstrator
Assistant City Administrator
Communications Coordinator
City Clerk
Receptionist
Page One
October 11, 2006
2007 BUDGET WORKSHEETS
ADMINISTRATION
2006 2007 Object 2007
2003 2004 2005 Adopted Derail Proposed
Account A Description Actual Actual Actual Buaget Amount Budget Comments
101 41320
101 41320
101 41320
101 00 Salaries Benefits
10200 Fu I-7 me Osertime
103 00 Par Salaries 9e0efrts
101 41320 01 209 00 Other Office Supplies
101 41320 01 306 00 Personnel Testing Recruitment 12,795 650 0 0
101 41320 01 319 30 Other Professional Services 3,624 16,279 4 119 2000 Locating KFS Medals
101 41320 01 321 00 Telephone Casts 193 1 194 1 347 80 1,000 Administration Cell Phones
101 41320 31 331 00 Travel Expense 407 1,600
101 41320 0 331 01 NLC Conference 298 669 80 800
101 41320 01 331 02 ICMA Conference 429 0 80 800
101 41320 01 331 03 Miscellaneous Travel 292 51 0
101 41323 01 353 00 Ordinance Pubrication 0 2,815 0 0 Moved to General Government
101 41320 01 394 00 0 Software Purcnases 1,600 0 0 0
101 4 01 433 00 Dues Subscriptions
101 41320 01 433 01 MCMA Dues
101 41320 01 433 02 MAMA Dues
101 41320 01 433 03 MCFOA Dues
101 41320 01 433 04 IIMC Dues
101 41320 01 433 05 IPMA Dues
101 41320 01 433 06 ICMA Dues
101 41320 01 433 07 APMP Dues
101 41320 01 435 00 Books Pamphlets
101 41320 01 437 00 Conferences Seminars
101 41320 01 437 01 Registration Hotel LMC
101 41320 01 437 02 Registration lotel MCMA
101 41320 01 437 03 Personnel Conferences
101 41320 01 437 04 Staff (1) Each
101 41320 01437 05 Miscellaneous Seminars
101 41320 01 437 06 Registration Hotel ICMA
101 41320 01 437 07 Advanced Glees School
101 41320 01 437 08 Registration Ho'el NLC
101 41320 01 437 09 Miscellaneous Meetings
101 41320 01 439 00 Other Miscellaneous Charges
101 41320 01 580 00 Other Equipment Purchases
101 41320 31 305 00 Medical Dental Fees
101 41320 31 315 00 Special Programs
101 41320 31 315 01 Employee Training
101 41320 31 315 02 HIPP Initiatives
101 41320 31 319 00 Other Professional Services
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 05 Flex,'VEBA Administrative Fees
101 41320 31 319 06 SWWC Ca- Operative Dues
101 41320 31 331 00 Travel Expense
101 41320 31 341 00 Employment Advertwng
0
101 41320 31 433 00 Cues 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 CO 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 00 Specal 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 Cabe JPA Payment-General City
101 41320 41 329 32 Video Streaming Council Meetings
101 41320 41 329 03 Bulk E -Mail System
101 41320 41 331 00 Travel Expenses 0
$265,539 5322 450 $347,771 $367,00
12 2738 67 2,00
0 0 0
550 998 669 30
1,490 2,200
93 180 200 200
50 50 100 100
35 35 150 150
100 120 150 150
395 0 0 0 Moved Below to H/R
742 1 420 1,500 1600
160 0 100 100
386 1,285 915 1,000 1600
2,555 9 000
47
44
12
1,16
1,02
19
0
0 5
0
0
0
3,5
0
1,398 65
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 $290,550 5358,61
DEPARTMENT TOTALS 3290 550 $358,61
101 41320 41 315 00 General Marketing, Special Mailings, Changeover of Gay Siqnage
0 500 500
491 800 800
0 0 0 Moved Below to HrR
250 200 200
2 287 2,300 2300
1,080 2,500 2,500
0 200 200
1,835 2,000 2,500
72 0 0
20 0 100
266 900 900
0 0 300 Employee Drug Testng
4,498 7,000
15,000 5,000 Addaianal Training for 2006
8,200 2,000 Wellness Health Management
4,302 4,500 2,000
808 900 900
5 400 5,400 5,400
0 1,000 1,000
4,172 3 000 3 300
0 500 500
520 400 400
4,852 6,000 6,000 Vacancies
310 45 450
160 25 250
300 20 400
233 50
300 50 500
255 40 400
315 50 500
39,936 4000
14,920 5 00
5,39 90
32,49 34,00
10
11
2
60
$483,52
$483,52
200
200
400
900
3515,600
$515 600
37,400
8,400
4,200
All Salary Costs Inclusive of
5377 300 Salary Taxes PERA Benefits
2 000
7,000 Terrp Receptionist Coverage
13 100
800 Miscellaneous Purchases
1 100
Risk Management
500 Books Training Materials
1 400
25,000 See Below for Description
5,000 Consultants Cable TV
3,000 Cable Supplies, Software
50,000
200
$521 400
$521 400
200 MAGC
400 Technical Courses
900
ELECTIONS
The responsible execution of electrons is a crucial function of local government. Federal, state and
local elections assure the popular representation of citizens and that the community's mission, vision
and goals are consistent with the wishes of the electorate
GENERAL ADMINISTRATIVE
Provides for conducting all local, state and federal elections.
VOTER REGISTRATION
STAFFING
Provides for the maintenance and execution of procedures for voter registration.
SUPPLIES EQUIPMENT
Provides for the necessary supplies and minor equipment necessary to conduct the
elections.
CONTRACTED SERVICES
Provides for the maintenance agreement for service and repair of the ballot counters.
Provides for continued use of polling locations.
Provides for the appointment and training of election judges to work at the City's six
precinct polling places
Page One
October 11, 2005
2007 BUDGET WORKSHEETS
ELECTIONS
2006 2007 Object 2007
2003 2004 2005 Adopted Detail Proposed
Account Description Actual Actual Actual Budget Amount Budget
Comments
101 41410 01 103 00 Part-Time Salaries $0 $27,500 $0 $29 000 $15 000 Election Judges
101 414'0 01 203 CO Printed Forms Paper 0 445 0 500 300 Ballets Programming
101 41410 01 208 00 Mrscellareous Supplies 0 371 0 400 300
101 41410 01 219 00 Other Operating Supplies 0 809 0 900 400 Food for Elect on wages
101 41410 01 242 CO Minor Equipment 0 2,839 105 2,900 1,500 Booths Signs
101 41410 01 319 00 Other P•ofessonal Services 0 0 0 0 0
101 41410 01 32' 00 Telephone Costs 0 300 303 400 400
101 4141C 01 351 00 Legal Notices Publishing 0 18 0 300 100 Election Publications
101 41410 01 409 00 Other Contracted Repair Maint 0 1,349 0 1,500 1,500 Maintenance for AutoMARK
101 41410 01 412 00 Building Rental 0 2,800 0 3,000 1,500 Passible 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 $36430 854 408 $36900 $61,000
TREASURY
The Finance Department is responsible to work with all departments of the City, especially the
Administration Department, to ensure that all activities of the City are conducted in a fiscally
responsible manner
GENERAL ADMINISTRATIVE
Provides for the fiscal management, processing and maintenance of all accounting
transactions for all funds of the City, including budgetary controls, preparation of
interim accounting reports and the Comprehensive Annual Financial Report.
DATA PROCESSING
FINANCE DEPARTMENT
Provides for evaluation of appropriate computer hardware and software on a
continuing basis.
Coordinates efforts between departments to assure an integrated information system.
Acts as an in -house consultant providing technical assistance when possible, and if
not possible, coordmatng the procurement of outside technical assistance when
needed
Fund Management Collects and deposits revenues and manages the investment of
idle funds
Budgetary Compiles historical and current expenditure and revenue data to
facilitate budget preparation.
Bonding Assists m the issuance, sale and record maintenance of indebtedness.
Insurance Maintains records for property and worker's comp insurance
requirements, handles all claims and prepares all documents for yearly renewals of
pohcies.
PAYROLL
ACCOUNTS PAYABLE
Receives employee time sheets, coordinates insurance, pay rates and other applicable
payroll information with personnel, prepares payroll checks, prepares all Federal and
State required reports, prepares all employee withheld and employer promised
obligation funds for disbursement to applicable organizations, and prepares all
reports as needed, both internally and externally
UTILITY BILLING
FINANCE DEPARTMENT Page 2
Coordinates the automated reading of all City water meters and the mailing and
collection of all utility bills Handles on the computer system, the preparation of
final bills and the setup of new accounts Fields and responds to utility billing
questions and complaints Compiles operating statistical information which is
available to other departments as needed
Processes purchase orders prepared by all departments, checking for accuracy and
matching with invoices and all other supportmg documentation so payments can be
made in a timely manner. Also, prepares all checks and supporting reports that
accompany each check run Coordinates the review of bills by Council by providing
applicable reports and supporting documentation
ACCOUNTS RECEIVABLE/ CASH RECEIPTS
Prepares invoices for all departments for items /services that must be billed to
outside sources Maintains records that allow for the timely collection of invoiced
items /sen Receipts monies on a daily basis and deposits those monies daily in
designated banking msntutions. Maintains a system that allows for the appropriate
reporting of all monies collected within the accounting system.
DEPUTY REGISTRAR
FIXED ASSETS
STAFFING
FINANCE DEPARTMENT- Page 3
Maintains an office that handles vehicle license renewals, vehicle license transfers
and DNA licensing transactions, consistent with the requirements of the State.
Responsible for the maintenance of the fixed asset system. This includes all
additions, deletions and changes in fixed assets for the City. Also responsible for the
corresponding reporting requirements that go along with the system, including year-
end information, insurance renewal information and Individual department
information.
SPECIAL ASSESSMENTS
Responsible for the maintenance of the special assessments records Works with the
Engineering Department for additions to the special assessment system
Responsible for coordinating all deletions and changes to the system as well as all
collections of special assessment payments. Must work with Dakota County to
ensure that all assessment balances are correct.
In 2007, the department will consist of seven positions:
Finance Director
Accounting Supervisor
Payroll Clerk
Accounts Payable Clerk
Utility Billing /Deputy Registrar Clerks (2 Full-Time and 1 Part -Time)
Page One
October 11, 2006
2007 BUDGET WORKSHEETS
FINANCE
2006 2007 Object 2007
2003 2004 2005 Adopted De`aii Proposed
Account A Description Actual Actual ALuaI Budget Amount Budget
101 41520 101 00 Salaries Benefits
101 41520 102 00 Full -Time Overtime
$193,071 3191,982 $219 263 $230,900
2,211 2,260 1,484 3,000
101 41520 01 319 00 Other Professional Services 10,000 0 0 0 0 FA Now Dore 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 CO 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 C,tnx Maintenance Renewal 0 0 0 1
101 41522 01 391 03 Incode Sortware Maintenance 5,643 5,858 8,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 SAN Maint 306 0 500 500
101 41520 01 391 06 Fixed Asset Maint Contract 805 1,211 1000 1,200
101 41520 01 391 07 Miscellaneous P C Repairs 575 1,350 3,500 2 800
101 41520 01 391 06 Anti Virus Software Renewal 426 4,205 4,000 4,500
101 41520 01 392 00 P C Accessories 3 Supplies 1,817 1,042 3,699 3,000 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 S/W 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 Suoscnp6ons 265 700
101 41520 01 433 01 MORA Annual Fees 0 0 100 0
101 41520 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 4'520 01 433 05 Magazine Subscriptions 0 0 100 100
101 41522 01 435 00 Books Pamphlets 0 200
10' 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 (FID) 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 Seminars 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 5255,914 5242,352 $277,222 $308,900 $331,200
DEPARTMENT TOTALS $255 914 $242,352 $277,222 $308,900 $331 200
Comments
All Salary Coals Inclusive of
$243,600 Salary, Taxes °ERA Benefits
3,000
GENERAL GOVERNMENT
DUPLICATING COPYING
Provides for maintenance agreements and expenses to operate copy machines at all
City facilities Also provides for microfilming laserfiche costs.
PRINTED FORMS PAPER
Provides for copy paper utilized by all departments and provides for forms utilized
by the Finance Department
ENVELOPES LETTERHEADS
Provides for letterhead utilized by all departments and for various types and sizes of
envelopes.
OTHER OFFICE SUPPLIES
EQUIPMENT PARTS
LEGAL FEES
Provides for general office supplies utilized by all City departments.
Provides for the maintenance and repair of general office equipment.
AUDITING ACCOUNTING SERVICES
Provides for the annual audit of the City's accounnng transactions for all funds of
the City and for the preparation of the Annual Financial Report .Also provides for
other services as required of the City's financial and accounung consultants
Provides for general legal and special legal services provided by the City Attorney or
other law firms utilized by the City for such services.
GENERAL GOVERNMENT- Page 2
OTHER PROFESSIONAL SERVICES
Provides for the adrrurustrauon costs of the City's code updates, code web fees,
annual updates to the user fee study, preparation of the State building report and
continuing disclosure fees.
TELEPHONE COSTS
Provides for the rental costs of the City's telephone system, monthly service fees,
long distance calls and miscellaneous installation costs Also, provides for fees
associated with the City's e -mail and web services
POSTAGE COSTS
Provides for postage costs for all departments and maintenance agreements for the
postage machine and postage allocator
OTHER TRANSPORTATION EXPENSES
Provides for two -year renewals of City vehicle hcense plates, emission fees and
duplicate plates, titles or tags, if needed.
LEGAL GENERAL NOTICES PUBLISHING
Provides for the pubhcanon of legal documents from all departments except when
publication costs are charged to specific projects
LEASE AGREEMENTS
Provides for leasing of copy machines at City Hall, Community Center and the
Police Department
Page One
October 11, 2006
Account
2007 BUDGET WORKSHEETS
GENERAL GOVERNMENT
Description
101 41810 01 202 00 Duplicating Copying
101 41810 01 202 01 Records Retention
101 4'810 01 202 02 Copying Costs
101 41810 01 203 0C Printed Forms Paper
101 41810 01 203 CI Copy Paper
101 41810 CI 203 02 General Receipt Books
101 4'810 0' 203 03 Purchase Orders
101 41813 01 203 04 Payroll Checks
10 41810 31 203 05 AP Checks
101 41810 01 203 05 Miscellaneous Forms
101 41810 01 204 00 Envelopes Letterheads
101 418 01 204 01 Letterhead
101 41810 01 204 02 Plan Envelopes
101 41810 01 204 03 At Payroll Envelopes
101 41810 01 204 C4 10 x 13 Envelopes
101 41810 01 204 05 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 418 01 242 01 State Purchasing Program
101 41810 01 242 02 Credit Card Equipment
101 41810 01 301 00 Auditing Accounting Services
10 41810 01 301 01 Audit General Consulting Fees
Dakota County Assessment Fees
Dak Cry Truth In Taxation Costs
Pnntmg of Budget Books
101 41810 01 301 02
101 41810 01 301 03
101 41810 01 301 04
101 41810 01 301 05
101 41810 01 303 00 Engineering Fees
101 41810 01 304 00 Legal Fees
101 41810 01 319 00 Other Professional Services
101 41810 01 319 01 City Code Update
101 41610 01 319 02 City Code Web Fees
101 41810 01 319 03 State Building Report (Springsteds)
101 41810 01 319 04 Continuing Disclosure Fees
101 41810 01 319 05 Annual User Fee Study Update
101 41810 01 319 06 Arbitrage :Rebate Calculations
101 41810 01 320 00 Credit Card Activity Fees
101 41810 01 321 00 Telephone Costs
101 41810 01 321 01 General Phone Costs
101 41810 01 321 02 E -Mail Server Costs
101 41810 01 321 03 Web Server Costs
101 41810 01 322 00 Postage Costs
101 41810 01 328 00 Cable Supply Costs
101 41810 01 329 00 Other Communication Costs
101 41810 01 339 00 Other Transportation Expenses
101 41810 01 351 00 Legal Notices Publishing
101 41810 01 351 01 Costs for Public Notices
101 41810 01 351 02 Truth in Taxation Notices
101 41810 01 351 03 Budget Audtt Publications
101 41310 01 391 00 P C Maintenance
101 41810 01 393 00 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
2003 2004 2005
Actual Actual Actual
$10,126
2,255
15525
3
78
48,510
41,864 57,226
1,653 1,941
1,590 1,579
529 243
5,500 0
0 3,828 0
42,552 53,749 50,459
9,105
505
1,647
0
29,750
6 223
10,350
862 1,711
59,672 979
59,547 62,821
0 0
0 285
18,678 15,837 20,036
0 153 0
30,538 30,538
113 744 75
3,739
3,478
0
507
5 250 1,500
0 22,000
90 220
O 40
0 0
18,549 14,259 29,824 23,000
O 1 862 0 0
$273,123 5355,871 5333,097 $361,700
$273,123 5355571 $333 097 $361,700
2006 2007 Object 2007
Adopted Detail P•opdsed
Budget Amount Budget
7,766 9 624 7,000 7 000
9,419 9,487 15,000 15,000
7,480 56
4,592 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
O 0 0 0
O 3,458 0 500
963 773 1,500 1,500
796 2,355 900 900
649 0 800 800
O 845 600 600
0 0 400 400
17,057 19 079 17,000
403 532 800
0 0 350 350
0 0 250 250
80,000
5,000
3,000
2,000
0
0
75,000
65,000
0
0
18,000
0
800
70,000
5,000
3,000
2,000
0
65,000
0
0
522,000
9 500
4,200
80,000
16,000
0
0
800
5,600
25,000
0
$374,100
$374,100
Comments
Business Cards etc
18,000 General Office Supplies
B00 City Hall Equipment Repairs
600
Yearly Fees for Program
Increased GASB Requirements
Moved to Administration
0
75,000 General City Legal Fees
39,800
540 2,300 2,300 Moved from Administration
0 1,500 1,500 Moved from Administration
8,453 5,000 5,000 Fees Paid to Springsted
4 050 5,000 5,000 Fees Paid to Springsted (Bonds)
6,075 6,000 6 000 Fees Paid to Springsted
6,500 24,000 20,000 Fees Paid to Springsted
2,300 3 000 5,000 Ado I Services at City Hall
65,000 Monthly Billings
Merged with 01 in 2006
Merged with 01 in 2006
Moved to Administration
Moved to Administration
General Costs
3,806 3,400 3,400 All Departments
156 1 000 1,000 Billing from Dakota County
428 1,200 1,200 State Mandated Publications
3,750 6,000 6,000 Oocuware Service Hours
0 0 0 Docuware Scanners
120 0 300 Newspapers
473 500 500 Direct Deposit Filing Fees
19,853 0 0 Sales Tax Audit
Copy Machine Leases All Bldgs
Mercury Spill
(Fax Machine Postage Meter)
OVERVIEW: MISSION, VISION AND GOALS
COMMUNITY DEVELOPMENT
The Community Development Department plays an important role as the City moves toward its
trussion of providing a safe, healthy and pleasant community in a fiscally responsible manner
The Building Inspection and Planning Divisions play a key role in making Rosemount a safe and
pleasant community These divisions are also involved m reaching the City Council's goals m
affordable housing and property maintenance
The Economic Development Division addresses the City's vision statement by fostenng
opportunities to live, work and shop. The division helps the City enhance its hometown character
and pride, for example, through downtown redevelopment The division, along with the
Rosemount Port Authority, plays a vital role to meeting goals of the City Council such as
commercial enhancement and business growth
BUILDING INSPECTIONS
Is responsible for providing the services of building pert-rut review, building
inspection, code administration, consultation and review on new and existing
buildings and structures within the City
Is responsible for the maintenance and enforcement of city ordinances and codes
relating to building, health, life safety and environmental conditions and to assure
local comphance with county, state and federal regulauons relaung to the same
activities
Is responsible for the successful implementation of all structural development and
assuring regulated and controlled standards within Rosemount
Is responsible for momtonng and permitting all individual sewage treatment systems
within the City.
Is responsible for reports submitted to all appropriate mnsdictions concerning
building activities
CODE ENFORCEMENT
PLANNING
COMMUNITY DEVELOPMENT— Page 2
Is responsible for enforcement of city ordinances and codes relating to health, hfe
safety, environmental, and nuisance conditions and assure local compliance with
county, state and federal regulanons relating to the same activities
Is responsible for sign ordinance implementation and permitting.
Is responsible for drafting of code text amendments to carry out Council goals and
City Initiatives.
Is responsible for reviewing proposed developments for compliance with the zoning
and subdivision ordinance and coordinating interdepartmental staff review of all
residential, commercial, insututional and industrial developments
Is tesponsible for providing recommendations to Planning Commission and City
Council on all deliberations concerning land use, zoning, variances, site plan reviews,
platting and special permits (interim use permits, mining permits, etc.).
Is responsible for maintaining zoning and subdivision ordinances and the City's
Comprehensive plan in compliance with county, state and federal requirements
(statutes and rules).
Is responsible for long -range planning and special studies that guide the physical
development of the community.
Is involved with state and regional activities affecting the City, including, but not
hrruted to, land use, transportation, mining, housing and environmental services.
Includes active participation by departmental staff in various committees and
organizations
Is involved with issuance of development related permits such as grading and
building permits
ECONOMIC DEVELOPMENT
COMMUNITY DEVELOPMENT— Page 3
Is responsible for marketing development opportunities within the City and creating
an interest to Rosemount
Is responsible for creating and coordinating the establishment of tax increment
districts and other economic incentives
Is responsible for coordinating the state, county and local approval processes to
insure the proponent's requests are met in a timely fashion
Is responsible for staffing the majority of functions of the Rosemount Port
Authority
Is involved with state and regional economic development organizations and
functions.
Page One
October 11, 2006
Account
2007 BUDGET WORKSHEETS
COMMUNITY DEVELOPMENT
Descnphan
101 41910 101 00 Salaries Benefits
101 41910 102 00 Full -Time Overtime
101 4'910 99 103 00 Part-Time Salaries Benefits
101 41910 99 103 01 Planning Cot"mtsston Members
101 41910 01 201 CO Office Accessories
101 41910 01 202 00 Duplicating Copying
101 419 01 203 OC Printed Forms Paper
101 41910 01 2C5 00 Drafting Supplies
101 41910 01 206 90 Miscellaneous Supplies
101 41910 01 209 00 Other Office SLoplies
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 APM'AICP
101 41910 01 433 02 CC
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 AACEOIMAHCO
101 41910 01 433 10 Other Dues Subscriptions
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 06 State Planning Conference (2)
101 41910 01 437 09 Planning Commissioner Training
101 41910 01 437 10 Gen'I Seminars
101 41910 01 437 11 Code Enforcement Training
101 41910 01 439 00 Other Miscellaneous Charges
101 41910 01 570 00 Office Equipment 8. Furnishings
PAGE TOTALS
DEPARTMENT TOTALS
2006 2007 Object 2007
2003 2004 2005 Adopted Detail Proposed
Actual Actual Actual Budget Pmcdnt Budget
Alt Salary Costs nclusive of
$610,751 5706,897 $771,360 $850,700 $848,800 Salary Taxes PERA Benefts
75 1,473 0 3,000 3,00C
43 757 12,565 11,820 5,000
5,00C 5,000
0
69
1,308
0
0
244
0
0
0
358
98
1,000
463
3,085
2,016
389
0
2,063
36 30
472 11,469
1,697 1 163
0 0
195 81
666 252
773 1,657
30 53
0 0
439 0
1,015 14
1,487 1,475
720 653
802 0
5,811 2 016
0 0
2,081 0
1,341 1,37
100 10
480 20
175 5
0
115 18
0 4
200
0
30
947 328 35
3,339 15
380 28
179 27
0 4
0
40 27
1,138 69
892 40
629 63
358
84 49
130 40
10 145 14
0
0
400 400 Calendars, Planners, em
3 000 3,000 Codification of Zonirg Ordinance
2,000 3,000 Forms Sticker Tags etc
100 100 Zioatcne Sprat Mount
200 200 Calculators
600 600 Dictation Devices Tapes
1,500 1,500 Bwldmg Inspection Supplies
400 400 Inspectors' Tools
0
0
2,000
2,000
600
0
3 000
500
0
1,500
200
500
200
0
150
100
200
300
50
700
500
300
1,000
400
500
1,200
500
1 200
300
400
400
400
0
5569,971 5743,936 5807,810 5886,000
1,500
200
300
150
0
200
100
200
300
50
500
300
1,000
400
500
1,200
500
1,400
300
400
400
0
C
1 000
2 000
600
0
3,000
500
0
3 000
$884 100
$669 971 $743,936 $807 810 $866,000 $884100
400 Contingencies
0
Comments
Fees for Contracted/ Temp Sery
Planning Consultant
Cellular Phone Pagers
Permfworks Support
700 Manuals, References, BC Books
6,900
ADMINISTRATION AND MANAGEMENT
This budget provides for the overall planning, coordination and management of personnel and
administration of activities within the Police Department Tins i_gcludcs the collection, preparation
and filing of crane dam and miscellaneous reports with the State of Minnesota, preparation and
oversight of the operating and capital improvements budgets; and strategic planning for the future
needs of the Department and the community
PATROL
Provides for the protection of hfe and property and an atmosphere of community
security through the deterrence of criminal activity by visible patrols; the
enforcement of traffic laws and accident investigation, the apprehension of criminal
offenders; and the delivery of other non emergency community services.
CRIMINAL INVESTIGATION
POLICE DEPARTMENT
Responsible for the investigation of crmunal incidents through the gathering, analysis
and presentation of evidence and testimony. Coordinates investigations with other
agencies, such as County Attorney's Office, Child Protection, vtctun services and
other federal, state and local law enforcement agencies.
CRIME PREVENTION AND COMMUNITY EDUCATION PROGRAMS
The implementation of the community policing philosophy has led to the pohce and community
members working together to identify and solve problems It is a philosophy that should be utilized
by all officers while completing that daily tasks. A significant effort is made by the police
department to inform residents of crime within the community, methods that citizens can take to
help prevent crimes and building relauonships with community members.
There are specific programs that are frequently associated with community pohcing and that
emphasize the need for the pohce and citizens to work together to prevent criminal activity and
reduce the opportunities for cruunals to commit crimes.
POLICE DEPARTMENT— Page 2
Drug Abuse Resistance and Education (D A R E. Students are taught skills to
resist the temptations to use illegal drugs and alcohol. A pohce officer instructs the
seventeen -week program to all fifth grade students at Rosemount and Shannon Park
Elementary Schools as well as students at St Joseph's Cathohc School. D A R.E.
also works to build up the students' self- confidence and to develop a positive
relationship between the students and police officers.
School Liaison One officer serves as a liaison to the Rosemount Middle and High
Schools The officer spends tune at each school as their needs dictate. The haison
officer investigates criminal incidents that occur at the schools or that involve
students at the schools. In addition, the liaison works with the school staff to
enhance the safety and secunry for both staff and students. Presentations on a
variety of topics are made by the liaison to classes at all grade levels
Community Education In order to work together with the community, police must
share information concerning criminal activity and crime prevention with the
community Officers are available to make presentations to community groups and
organizations on a variety of topics In addition, officers provide prevention ups to
persons on a daily basis whom report crmnnal activity Several events are also held
throughout the year m an effort to build rclanonships with the residents and business
persons. These include National Night Out block parties and gatherings,
Neighborhood Watch meetings and Public Safety in the Park events
Reserve Officer Program Reserve officers are volunteers whom supplement the
staff of sworn officers of the Department The reserve officers are utilized to handle
traffic and crowd control duties during city festivals and celebrations or emergencies,
such as hazardous materials spills or leaks, damage resulting from tornadoes or other
severe weather and major cnimnal incidents. Reserve officers patrol on some
evenings and handle service calls, for example, assisting stalled motorists and animal
complaints They are also utilized regularly to provide crime prevention information
to citizens at community events or through other programs
Chaplain Program The Police Chaplains are used by officers to assist in a vanety of
situations in which individuals or families are having difficulties Chaplains are able to
provide support to persons that are experiencing stress as a result of the death of a
loved one, marital or family problems, financial struggles or any other event. By
utrhzing the chaplains to console and counsel persons in crisis, police officers are able
to get back to other duties, while the chaplains are able to remain with the persons
involved in the crisis
ANIMAL CONTROL
POLICE DEPARTMENT— Page 3
The Police Department is responsible for the enforcement of ordinances related to
the control and care of domestic animals These tasks are mainly handled by
Community Sen Officers Their duues include the hcensmg of dogs, cats and
ferrets, assisting in the handling of stray, lost of tripled animals and other e.ompiamts
of animals causing a nuisance by barking, howling ox being allowed to roam off the
owner's property
CODE ENFORCEMENT
The Police Department assists the Community Development Department's Code
Enforcement Official in the enforcement of city ordinances related to property
maintenance and outside storage. The department's Comiunity Service Officers
primarily handle this effort Property owneis that are observed to be in violation of
an ordinance are noufied of the violation and explained how to rectify the offense
The enforcement of city ordinances is important to maintain community standards,
which help the City attain its mission of providing a safe, healthy and pleasant
community.
EMERGENCY MANAGEMENT
Responsible fox the development of emergency plans in the event of a technical or
natural disaster m the community, e.g. tornado, flooding or hazardous materials
release. This function is the local contribution to homeland security of the state and
nation.
STAFFING
POLICE DEPARTMENT— Page 4
This department is comprised of nineteen police officers. A records supervisor, a
full -tune and a part -tine secretary and a receptionist handle support responsibilities,
such as transcription, filing, reception and other secietanal dunes Community
service officers continue to fulfill a support role for many duties, including
equipment maintenance, evidence transport, office support, code enforcement and
anunal control duties As the community continues to grow, additional officers and
other staff will be added to the department to meet the needs and expectations of
the community and work towards the City's mission of providing a safe. healthy and
pleasant community in a fiscally responsible manner The positions within the
department are distributed as follows.
OFFICERS SUPPORT
Chief of Police Records Supervisor
Lieutenant Secretary (1 F/T 1 P /T)
Sergeant (3) Receptionist
Investigator (2) Community Service Officers
School Liaison Officer
D.A R.E /Crone Prevention Officer
Patrol Officer (12)
Page One
October 11, 2008
Account
2007 BUDGET WORKSHEETS
POLICE
Descnpbon
101 42110 101 00 Salaries Benefits
101 42110 102 00 Full -Time Overtime
101 42'10 102 D1 Regular CJertime Hours
101 42110 102 02 Contracted OTT
101 421 103 00 Part- T ,me Salanes Benefits
101 42110 23 103 00 Par-Time Secretary
101 42110 99 103 00 Part-Time CSO's
101 42110 01 202 00 Duplicating Copying
101 42110 01 203 CO Printed Forms Paoer
101 42110 01 204 00 Enve,opes Letterheads
101 42110 01 207 OC 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 V1 00 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 Accunnt Datahas& Services
101 42110 C1 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
2008 2007 Object 2007
2003 2004 2005 Adopted Detail Proposed
Actual Actual Actual Budget A maur t Budget
1,469,144 1,635,501 1,764,519 $1,911 000
60,931 55,102 62,916 65 000
25,505
706
225
227
1,928
1,882 3,429 2,000
285 0 400
0 64 100
6,055 5,050
O 2,091 0
O 63 395 0
941 874 564 1,000
481
PAGE TOTALS 1,745,523 1,898,432
156 242 200
372 1,043 800
O 0 200
40 000
25,000
7,031 7,469 17,900 20,600
30,009 31,500 35,500 35,600
2,500
400
100
0
0
0 0 100 100
181 0 300 300
2,160 3,281
0 500 1,000 1,000
O 2,434 1,500 1,500
0 26 500 500
1,082 955 2,006 2,000
2,000
3,055 1,170 2,488 2,500
1,227 1,435
0 523 750
O 514 500
0 589 750
1,249 701
O 849 1,500 1,500
0 456 500 500
750
500
750
101 42110 01 304 00 Legal Fees 54,996 54,996 54,996 56 000
101 42110 01 305 00 Medical Dental Fees 1,058
101 42110 01 305 01 Employee Drug Testing (Amended)
101 42110 01 305 02 Seized Narcotic Testing
101 42110 01 306 00 Personnel Testing Recruitment 730
101 42110 01 313 00 Temporary Service Fees 0
101 42110 01 316 00 Animal Care Services 13,727
101 42110 01 316 01 Impound Care Fees
101 42110 01 316 02 Deer Inventory
101 42110 01 319 00 Other Professional Services 89,588
101 42110 01 319 01 Dispatch Services Operations 55,802 68,124 93,000 232,400
101 42110 01 319 02 Dispatch Services Startup Costs 5,551 4,422 4,000 15,000
101 42110 01 321 00 Telepnone Costs 6,483
101 42110 91 321 01 Cell Phones
101 421 10 01 321 02 Pagers
101 42110 01 321 03 LOGIS Communications Line
101 42110 01 323 00 Radio Units 2,881
101 42110 01 323 01 Radios
101 42110 01 323 02 Radars
101 42110 01 331 00 Travel Expense 1,184
101 42110 01 331 01 MN Chief's Spnng 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 06 Juvenile Officers Conference
101 42110 01 331 07 Meeting Reimbursements
441 1 255 1,500 1,500
204 368 500 500
2,608 700 1,500
0 0 0
11,314 9,590 14,000 14,000
0 0 500 0
4,885 5,132 5,000 5,000
749 134 400 0
444 481 500 500
1,942
0 1,103 2,000 4,000
0 0 1,000 500
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
2,096,106
All Salary Costs Inclusive or
$2,038,200 Salary Taxes, PERA Benefits
55,000
56 200
200 Fitm ana Developing
800 Evidence Logs Animal Lic, etc
0
3,000
1,000 Video CO's M,scellaneous
400
3 000
2,300
300 Digital Recorders
2,500 Squad Emergency Equip Repairs
2,000 Crime Scene Kit Supplies
2 000
58,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 709
2,229600 2,512,400
Comments
P1' Secretary 16 Hours:N /k
CSO's Total 50 HoursNVk
0 Donated Forfeited Funds
Digital Recorders
Training Supplies
Radio Repeater Phone Lines 27
Page Two
October 11, 2006
2007 BUDGET WORKSHEETS
POLICE
2006 2007 Object 2007
2003 2004 2005 Adopted Detail Proposed
Account Description Actual Actual Actual Budget Amc nt Budget
101 42110 01 333 00 Freight 8 Express Expenses
101 42110 01 341 00 Employment Advertising
101 42110 01 394 00 P 0 Sofware P rcrases
101 421 0' 394 01 Automated Pawn System
101 42110 01 394 02 Pictametry
101 42119 01 394 03 CJIIN System
101 42110 01 396 00 Computer Maintenance
101 42110 01 396 0 Recores Management
101 42110 0 396 02 CJDN Connection Charges
101 42110 01 396 03 MCD Connection Charges
101 42110 01 390 04 MCD Maintenance Cellular
101 42110 31 396 05 LCGIS Annual Fees
101 42110 01 396 06 LOGIS Security and Back Up Site
101 42110 01 580 00 Other Equipment Purchases
PAGE TOTALS
DEPARTMENT TOTALS
68
0
613
51,794
5,590
12
1,27
1,72 3,091
$71,287 $77 916 8108,856 $110,100
$1,816810 $1,974,347 $2204,962 $2,339,700
Comments
147 200 200 Repairs
797 500 0
13 000
432 500 503
1,988 2 000 2,300
8 421 10,500 10,500
64,000
39,77 42,252 41,000 29 300
2,52 2 351 3,000 3,000
3,03 2,464 4,000 3,000
16,37 19,652 21 22,800
7,875 8,000 5,900
3,593 0 0
101 42110 01 433 00 Dues 8 Subscriptions 2,813 3,600
101 42110 01 433 01 Mutual Aid Assistance Group -MAAG 1,65 2,000 2,100 2,200
101 42110 01 43 3 02 IACP Chiefs 10 100 100 100
101 42110 01 433 03 MN Chiefs of Police 225 150 250
10' 42110 31 433 04 Dakota Cty Chiefs of Police 5 50 50 50
101 42110 01 433 05 Waxota CAER 0 20 20
101 42110 C1 433 06 Metro Emergency Managers 0 25 0
101 42110 01 433 07 MN Sex Crimes investigators 1 16 25 25
101 42110 01 433 08 Tri -County Investigators 6 60 60 60
101 42110 01 433 09 MN Crime Prevention Association 36 0 25 50
101 42 01 433 10 P 0 S T Licenses 54 460 750 700
101 42110 01 433 11 FBI Nat'l Academy Association 60 60 60
101 42110 01 433 12 Miscellaneous 55 35 85
101 42110 01 435 00 Books Pamphlets 68 9 297 300 300 Statutes Crime Prevention
101 42110 01 436 00 Towing Charges 69 14 88 200 200
101 42110 01 437 00 Conferences Seminars 10 206 13,000
101 42110 01 437 01 Firearms -Range Rental 40 3,896 2,000 2,000
101 42110 01 437 02 Chiefs Spring Conference 45 345 500 500
101 42110 01 437 03 investigations 361 1,500 1,500
101 42110 01 437 04 IACP Conference 22 0 250 250
101 42110 01 437 05 Supervision 15 650 1 000 1,000
101 42110 01 43 06 Use of Force 8,36 1,625 600 600
101 42110 01 437 37 Emergency Driving 1365 1,400 1,400
101 42110 01 437 08 First Aid 1690 2,000 2,000
101 42110 01 437 09 Narcotic Enforcement 100 750 750
101 42110 01 437 10 Tactical 670 1,000 1,000
101 42110 01 437 11 Support Services 40 500 500
101 42110 01 437 12 Patrol 1,228 1 500 1,500
101 42110 01 439 00 Other Miscellaneous Charges 264 44 412 500 500 Snacks Beverages for Mtgs
2,000
0
$94,800
$2,607,200
CAC Included m DCC
MISSION VISION GOALS
FIRE DEPARTMENT
The Rosemount Fire Department's mission is an intricate component of the overall mission of the
City of Rosemount in that the Fire Department is dedicated to the saving of hfe and property This
component which the Fire Department provides compliments and provides a necessary service so
that the City may reach its broader mission of providing a safe, healthy and pleasant cominunity w
which to live and work Tilts service is provided by paid on-call firefighters, which is the most
fiscally sound method of delivery at this point in Rosemount's development
The Rosemount Fire Department enhances the overall vision that is set for the City of Rosemount
in that it provides the opportunity for individuals to demonstrate then pride in the community by
serving on a "volunteer" fire department and assisung their neighbors The "volunteer" fire
department has histoncally been associated with the kind of small to n character that Rosemount is
striving to maintain.
ADMINISTRATIVE/ MANAGEMENT
Provides for the overall administration and management of the Fire Department.
Included is the collection, preparation and disserninaaon of information, the
preparation of operating budgets, CIP budgets and state reports, and planning for
the long and short term needs with respect to training, fire protection, emergency
medical response, facilities, staffing, and the acquisition and maintenance of
equipment, along with the coordination of efforts between other emergency
response agencies and those of the City of Rosemount.
FIRE SUPPRESSION INVESTIGATION
Provides for the controlling and extinguishing of all types of fires in order to
tnuiinvze injury, loss of hfe and loss of property within the City of Rosemount, both
to its citizens and visitors.
Provides for the controlling and extinguishing of all types of tires in order to
minimize injury, loss of fife and loss of property within the contracted areas of
Coates and the University of Minnesota, along with the railroad right -of -ways
Provides for the provision of all of these fire services to all the cities of Dakota
County and many of Washington County via a mutual aid agreement by which these
services can be reciprocated on an as needed basis.
FIRE DEPARTMENT— Page 2
Provides for the investigation of fires by the local Fire Marshal. Also provides For
the coordmauon of joint investigations by the local Fire Marshal and the State Fire
Marshal.
RESCUE SQUAD
Provides for emergency operations pertainmg to bodily mlury or serious illness
requiring emergency services within the City of Rosemount, both to its citizens and
visitors.
Provtdes for emergency operations pertaining to bodily injury or serious illness
requiring emergency services within the contracted areas of Coates and the
University of Minnesota.
Provides for the provision of all of these emergency operations to all the cities of
Dakota County and many of Washington County via a mutual aid agreement by
which these services can be reciprocated on an as needed basis.
HAZARDOUS MATERIAL RESPONSE CONFINED SPACE RESPONSE
Provides a team of Operations Level, Technician Level and Specialists framed to
respond to hazardous material accidents, identify, secure and coordinate the efforts
of outside agencies that are trained to contain, trutigate and clean up the spill.
Trams all firefighters to respond to confined space incidents, evaluate the situation
and mitigate or coordinate the rescue effort.
TRAINING EDUCATION
Provides for the necessary monthly and annual training requirements.
Allows for training in areas above those that are required, in order that fire and
rescue personnel may sharpen existing skills and acquire new skills.
Allows for training of fire fighters to prepare themselves for the acceptance of a
position of leadership within the Fire Department.
Provides for the training of the City Fire Marshal.
HEALTH TESTING
EQUIPMENT/ MAINTENANCE
STAFFING
FIRE DEPARTMENT— Page 3
Provides for the screening and medical certification of potential new fire fighters.
Allows for the continuous health monitonng of exisung personnel.
Provides for the protection of personnel from blood -borne pathogens and
communicable disease.
Allows for the replacement or addition of equipment necessary for fire and medical
response, including both consumable and nonconsumable items.
Provides for the emergency contracting with outside providers for repairs of fire
vehicles and specialized equipment
In 2006, the Fire Department consisted of 40 paid on -call firefighters serving m
various capacities within the department. This number is constantly changing due to
retirements and new additions. We have 5 people who have reached or exceeded
full retirement requirements, but often tune's people retire pnor to the full 20 years.
We hope to end 2007 with a department of not less than 44 firefighters and one fue
marshal.
Page One
October 11, 2006
Account#
2007 BUDGET WORKSHEETS
FIRE
Description
101 42210 01 305 00 Medical Dental Fees 2,829 2,47
101 42210 01 306 00 Personnel Testing Recruitment 1,031
101 42210 01 306 01 New Physicals 14)
101 42210 01 306 02 Hepatitis Shots (4) 34
101 42210 01 306 03 Background Checks (4)
101 42210 01 306 04 Drug Testing (4)
101 42210 01 308 00 Instructors' Fees 8,965
101 42210 01 308 01 Fire Fighter 1 (4)
101 42210 01 308 02 Fire Fighter 1 Certificates (4)
101 42210 01 308 03 Fire Fighter Re- Certificates (6) 9
101 42210 01 308 04 First Responder (4)
101 42210 01 308 05 First Responder Refresher (1/2) 1,65
101 42210 01 308 06 Outside Schools ($/2) 7,00
101 42210 01 308 07 Haz -Mal Training (4) 1,73
101 42210 01 308 08 Apparatus Re- Certificates (0)
PAGE TOTALS 92,696 101204
2006 2007 Object 2007
2003 2004 2005 Adopted Detail Proposed
Actual Actual Actual Budget Amount Budget
Commrts
All Salary Coss 'nclusive of
101 42210 103 00 Salaries Benefits $73,285 S74 520 982 244 $81,700 $84,400 Salary, Taxes PERA Benefits
101 42210 103 01 Salaries 26,300
101 42210 103 02 Training Pay/Stipends 3 300
101 42210 103 03 Call Pay/Stipends 20,000
101 42210 103 04 Class Pay /Stipends 100
101 42210 103 05 P/T Fire Marshal 34,700
101 42210 01 202 00 Duplicating Copying 0 100
101 42210 31 202 01 Copy Toner 0 50 50
101 42210 01 202 02 Computer Printers 0 50 50
101 42210 01 204 00 Envelopes Letterhead 0 100
101 42210 01 204 01 Envelopes 0 25 25
101 42210 01 204 02 Letterhead 0 25 25
101 42210 01 204 03 Forms 25 42 50 50
101 42210 01 207 CO Traimng Instructional Supplies 929 0 0 0
101 42210 01 208 00 Miscellaneous Supplies 1 2,100 Supplies for Fire Marshal
101 42210 01 208 01 Supplies Computer Support 91 731 1,500 700
101 42210 01 206 02 Flm Developing 0 100 100
101 42210 01 208 03 Memberships 4 35 300 300
101 42210 01 208 04 Code Books 15 210 500 200
101 42210 01 208 05 Training 595 1,000 800
101 42210 01 211 00 Cleaning Supplies 251 300
101 42210 01 211 01 Soaps 46 1,044 100 150
101 42210 01 211 02 Chamois, Towels, etc 0 100 50
101 42210 01 211 03 Sponges, etc 0 25 25
101 42210 01 211 04 SCBA Cleaner 0 75 75
101 42210 01 213 00 Fire Department Clothing 1,535 8 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,33 0 800 800
101 42210 01 219 02 Bandages 0 100 100
101 42210 01 219 03 Equipment 1,21 494 500 500
101 42210 01 219 04 Tyvek Suits 0 100 100
101 42210 01 219 05 Consummable Medical 35 280 1,800 1,800
101 42210 01 219 06 Oxygen 5 111 200 200
101 42210 01 229 00 Other Maintenance Supplies 262 1 100
101 42210 01 229 01 Aerial- Pumpers- Tanker 3,19 0 800 800
101 42210 01 229 02 Pickup Trucks 0 100 100
101 42210 01 229 03 Rescue Other 0 100 100
101 42210 01 229 04 Vehicle Modifications 12 100 100
101 42210 01 230 00 Equpment Repau Matenats 2,030 1 800
101 42210 01 230 01 Light Bars 0 100 100
101 42210 01 230 02 Smoke Machines 0 250 250
101 42210 01 230 03 Lanterns Miscellaneous 0 250 250
101 42210 01 230 04 Small Tool Repairs 1,08 205 600 600
101 42210 01 230 05 Opticom 0 300 300
101 42210 01 230 06 Station 3,91 0 300 300
101 42210 01 241 00 Small Tools 683 700
101 42210 01 241 01 Axes, Bars Other 14 126 150 150
101 42210 01 241 02 Grass Fire 66 250 250
101 42210 01 241 03 Hand Tools 16 782 300 300
2,741 3,500
1,133 1,000 1,000
29 500 500
96 100 100
0 500 500
0 1 200 1,200
0 150 150
315 200 100
0 1,000 1,000
2,040 1 500 2,000
6 430 3,850 2,250
0 1,000 1,000
0 0 0
99,900 107,500
3,500 Annual Medical Tests
2,100
7 700
107 700
Page Two
October 11, 2006
Account
101 4221001 310 00
101 42210 0 310 01
101 42210 01 313 02
101 42210 01 310 03
101 42210 01 310 04
101 42210 01 313 CO
101 42210 01 313 01
101 42213 01 313 02
101 42210 31 313 03
101 42210 01 313 04
101 42210 01 313 05
101 42210 01 314 00
101 42210 01 319 00
101 42210 01 319 01
101 42210 01 31902
101 42210 01 319 03
101 42210 0 319 04
101 42210 01 319 05
101 42210 01 31906
101 42210 01 321 00
101 422'0 01 321 01
101 42210 01 321 02
101 4221001 321 03
101 42210 01 321 04
101 42210 01 322 00
101 42210 01 329 CO
101 42210 01 329 01
101 42210 01 329 02
101 42210 01 32903
101 42210 01 329 04
101 42210 01 329 05
101 42210 01 331 00
101 42210 01 331 01
101 42210 01 331 02
101 42210 01 331 03
2007 BUDGET WORKSHEETS
FIRE
Description
Testing Services
Aerial (Next 2009)
Ladders ;Next 2009)
Pumpers (3) ;Next 2008)
SCSA Hydro Testing (Next 2010)
Temporary Service Fees
SCBA Contract
SCBA Maintenance
Copier Fax Contract
Security Contract
SOT Joint Powers
Annual F1re Relief Contribution
Other Professional Services
School Literature
Door Prrzes
Fire Prevention Week Promos
Food at Open House
Summer Park Education
National Night Out
Telephone Costs
Chief
Assistant Chief
Rescue
Numeric Pagers
Postage Costs
Other Communication Costs
Base Repairs
Pager Repairs
Hand Held Repairs
Mobile Repairs
800 MHZ User Fee
Travel Expense
Minnesota Chief's Conference
Fire Department Association
Outside Schools
101 42210 01 433 00 Dues Subscriptions
101 42210 01 433 01 Capital Ctty
101 42210 01 433 02 VFBA Insurance
101 42210 01 433 03 State Fire
101 42210 01 433 04 State Chiefs
101 42210 01 433 05 DCFC
101 42210 01 433 06 WAKOTA Mutual Aid
101 42210 01 433 07 Purchasing Consortium
101 42210 01 433 08 NFPA
101 42210 01 433 09 MN Assn Fire Marshals
101 42210 01 437 00 Conferences Seminars
101 42210 01 437 01 State Fire Conference
101 42210 01 437 02 State Chiefs Conference
101 42210 01 439 00 Other Miscellaneous Charges
101 42210 01 439 01 Food Coffee
101 42210 01 439 02 Extinguisher
101 42210 01 439 03 Plaques
101 42210 01 439 04 Paint
101 42210 01 439 05 Station Needs
101 42210 01 580 00 Other Equipment Purchases
101 42210 01 580 01 Bunker Gear (9)
101 42210 01 580 02 Pagers (6)
101 42210 01 580 03 Hose Replacement
101 42210 01 580 04 Replace Damaged Items
101 42210 01 581 00 Other Equipment Purchases
PAGE TOTALS
DEPARTMENT TOTALS
2003 2004
Actual Actual
1,534
259
540 388 400 400
0 209 200 200
1,011 0 400 400
278 286 500 700
0 1,381 2 C00 2,300
135,000 135,000 139,100 143,300
2,713
700
521
3,877
1,214
519
1,293
15,708
1 285
7,472
1,036
2,291
0 0
2006 2007 Object 2007
2005 Prompted Delad Proposed
Ac'ual Budget Amount Budget
0 795 0 1,000
0 0 0 500
870 0 900 900
0 1,450 0 1,000
0 0 350 250
200 0 250 150
2,001 2,897 1,300 900
185 0 150 150
0 0 250 200
0 0 200 150
0 0 200 200
474 915 200 200
344 364 300 300
120 323 300 300
0 0 0 2,500
1,309 2,882 1,500 1,500
289 817 900 900
0 589 3,500 2,000
5 0 35 50
25 30 260 350
30 300 200 250
16 0 250 250
50 40 40
2 25 30 40
35 50 50
O 185 185
O 150 185
40
26
4
80
0 400 450
450 300 350
328 190 250
O 400 400
85 20 40
0 50 70
564 540 840
$163,138 $157,681 $158,920 3175,900
3255635 $258,885 $258 821 3283,400
3 400
4 000
147,600 Moved From Sa lanes Above
1,600 Fire Prevention Education
500
557 382 300 250
15 17 100 100
7 41 100 100
70 83 100 50
0 0 1a 100 100 UPS Costs
3 500
4 400
1 400
800
2,803 9,000 9,000
0 3,000 3 000
0 2,000 2,000
1,238 t,000 1,000
0 0 0
$184,100
3291,800
Comments
Fire Marshal Dues
1 600
15 000
Government Buildings
Fleet Maintenance
Street Maintenance
Parks Maintenance
Water Operating
Sewer Operating
Storm Water Operating
PUBLIC WORKS
In pursuit of providing a safe, healthy and pleasant community, the Public Works Department
maintains and builds the Cirv's mfrastructute This is done through four (4) maintenance funds and
three (3) enterprise funds. A summary of the Department is as follows:
The Public Works Department consists of the Engineering and Public Works Divisions. The
maintenance personnel maintain the streets, storm drainage, sanitary sewer and potable water
systems, along with all government buildings. parks and all City grounds The budgets administered
by the Public Works Department are as follows.
Separate Enterprise Fund Budgets from those included here under the
advisement of the Utility Commission of the City of Rosemount.
The Pubhc Works Department currently has a combined permanent work force of 26 positions for
the areas of engineering, buildings, fleet maintenance, streets, parks and the enterprise- funded
utilities, Also, the City employs up to 14 seasonal part -tune people to help during periods that
require higher levels of maintenance The Public Works budget also incorporates the contract for
consulting services currently held to fill the position of City Engineer
PUBLIC WORKS— Page 2
RESPECTIVE BUDGETS
GOVERNMENT BUILDINGS
This budget provides for the management, operation, maintenance and repair of the City's buildings.
This includes City Hall, the NIN DOT garage, the Public Works building and garage, and two Fire
Halls (the second one to open in 2006) It also includes three (3) park shelters, St Joe's Church, and
the Family Resource Center Nlamtenance and operation of the Community Center Ice Arena is
not included m this budget
FLEET MAINTENANCE
This budget provides for the maintenance of all City-owned vehicles and over 250 pieces of large
and small equipment. It provides funding for all fuels, oils, parts, tires, shop supplies, and
contracted vehicle maintenance The City-owned vehicles include
Police Department (10 cars, 3 trucks, 1 ATV)
Fire Department (6 pickup trucks, 6 fire trucks)
Parks and Recreation (1 truck, 1 van, 1 car, 1 ice resurfacer)
Admuustrauon Community Development (4 cars, 1 truck, 1 van)
Utility Department (1 Jetter, 1 Vactor, 2 trucks)
Streets and Parks Maintenance (2 sweepers, 3 tractors, 2 loaders, 2 skidsters, 7 dump trucks,
5 mowers, 13 trucks, 2 compactors, 1 roller, 1 ATV, 4 snow blowers)
4 large trailers
STREET MAINTENANCE
This budget provides for the maintenance and preservation of over 120 miles of City roads, over 30
miles of sidewalks and bike trails, and 12 City parking lots Standard maintenance Includes grading,
graveling, patching, sealing and overlays This budget also provides for pavement markings, street
signs, street lighting, signal light maintenance and power, snow and ice control, and street sweeping
PARKS MAINTENANCE
This budget provides for the maintenance of over 300 acres of City park areas in 23 locations,
including 11 parks with athletic fields and 10 parks with shelters or pavilions. It Includes the
maintenance of all park trails and 10 other municipal areas, including City Hall, the Fire Stauon and
the Community Center. It also includes the installation of playground equipment, landscaping
projects, ice rink construction and maintenance (4 hockey rinks, 6 pleasure rinks), and other
miscellaneous construction activities
Page One
October 11, 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 Scat(
101 41940 102 OC FLII Tme Overtime
101 41940 0 208 00 Miscellaneous Supplies
101 41940 01 223 00 Building Repair Supplies
101 41940 01 225 OC Landscaping Materials
101 41940 01 24" 30 Small Tools
101 41940 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 Suparessicn System Check
131 41940 01 319 07 Janitorial Service -Fire Stations
101 41940 01 319 08 Janitorial Service -P W Building
10 41940 31 381 00 Electric Utilities
101 41940 01 383 00 Gas UtiIltles
101 41940 01 384 3O Refuse Disposal
101 41940 01 384 01 General Buildings Parks
101 41940 01 384 02 Recyc'inglCleanup
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 Suen 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 OG good 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
All Salary Costs Incvsive of
$46,600 $49,000 Salary Taxes, PERA Benefits
0 0 8,500 0
49,257 46,046 47,500 49,000
2214 4180 2,869 4,000
9,604 13,317 15,483 17,000
4,899 5,186 6 499 5 000
652 469 1 316 500
366 46 115 200
1,060 1,025 2,038 2,000
0
1 500
31,467
1,153 1,206 1,000 1,000
2,116 1,553 5,000 5,000
110 1,015 1,500 1,500
1,502 1,570 1,500 1,500
706 1,750 1,000 1,000
844 2,350 1,000 2,500
3,515 3,515 5,300 7,000
10,288 10,288 10,500 10,500
44,107 45,362 76 312 50 000
44,612 45,617 54,161 67,500
24,025 944
10 430 11,502 20,000 20,000
13,725 14,893 15,000 15,000
3,800 3,800 3,790 3,800
11,685
1,665 456 2,000
10000 8,979 10,000
15,855 12,871 13,000
1,234 142 397 1,000
0 0 0 1,000
33,895
53,142
585
0 0 0 0
$315,449 $322,574 $361,796 $390,500
$315,449 $322,574 3361,796 $390,500 $428,100
0 0 1 000
750 1,500 3,000
36,316 38,737 41,200
43,190 39,811 49,900
1,063 775 600
2,000
10,000
13,000
4 000
17 000
5 000
500
200
2,000
0 Estimates
3,000 Contracted Engineer for City (5
30 000
75,000
75,000
35 000
Added Parks
2 Cleanup Days per Year
3,800 Floor Mats Monthly Charges
25 000
$428 100
Comments
Cleaning Suoptes Towels etc
Trees Shrubs
Hand Tools Sits Blades, etc
Equipment Replacement
Fire Stations #2
Price Increases
Fire Station #2
1,000 Scaffoltlmg, Cleaners
1,000 Contingencies
10,000 Fence at St Joseph's
43,600 MSABC Payment (2/1)
47,400 MSABC Payments (2/1 8/1)
600
Page One
October 11, 2006
2007 BUDGET WORKSHEETS
FLEET MAINTENANCE
2006 2007 Object 2007
2003 2004 2005 Adopted Oeta4 Proposed
Account 4 Description Actual Actual Actaal Budget AmcJnt Budget
101 43100 101 00 Salaries Benefits
101 43100 77 101 00 Administrative
101 43100 79 101 00 Maintenance
101 43100 102 00 Full -T,me Overtime
101 43100 01 211 CO Clear Supplies 548 709 735 1,000 1,00
101 43100 01 212 00 Motor Fuels 65 730 75,983 115,276 137,500 187,50
101 43100 01 213 00 Lubricants Additives 2,566 5 093 3,636 5,500 5,50
101 43100 01 215 30 Shop Materials 15714 12,106 11,937 20530 170
101 43100 01 221 00 Equipment Parts 86,235 87,101 92,730 89 C00 95,00
101 43100 0' 222 03 Tires 12 474 10,213 11 258 15 000 16 00
101 43100 01 241 00 Small Tools 4 262 2,662 3,633 4,000 4 00
101 43100 01 242 00 Minor Equipment 6,163 6,935 4,528 6,000 6 00
101 43100 01 318 00 Contract Engineer 3,000 1,500 3,000 4 500
101 43100 01 321 00 Telepnane Costs 0 0 0 0
101 43100 01 323 00 Rama Units 1,999 1,058 473 2,000
101 43100 01 331 00 Travel Expense 0 0 0 0
101 43100 G1 341 0O Employment Advertising 0 38 0 0
101 43100 01 384 00 Refuse Disposal 190 557 151 500
101 43100 01 394 00 P S Software Purchases 0 354 0 500
101 43100 01 404 00 Contracted Mach Equip Repairs 32,136 31,179 27,680 35,000
101 43100 01 416 00 Machinery Rental 252 0 0 1,000
101 43100 01 417 00 Uniforms Rent& 118 59 83 0
101 43100 01 433 00 Dues 8 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
DEPARTMENT TOTALS
All Salary Costs Inclusive of
$132,369 $141,400 Salary Taxes PERA Benefits
9,396 10 976 10,200 10,500
122 753 123,318 136,100 139,900
5,799 1,226 1 601 7,500 7,50
4,50
2 00
50
50
35 00
1 00
1 00
PAGE TOTALS $369,629 $369,245 $411,281 $478,000 $525,400
$369629 $369,245 $411 281 $478 000 $525400
Shop Vehicles
Price Increases
Comments
Contracted Engineer for CIty(10
RepairrReplace Units
Shop Hazardous Waste
General Sortware Support
Page One
October 11, 2006
2007 BUDGET WORKSHEETS
STREET MAINTENANCE
2006 2007 Object 2007
2003 2004 2005 Adopted Detail Proposed
Account Description Actual Actual Actual Budge Amount Budget
Comments
All Salary Costs Inclusive of
101 43121 101 00 Salaries Benefits $392,557 $448,700 Salary, Taxes PERA Benefits
101 43121 77 101 CO Administrative 28,188 32 930 30 500 31,400
10' 43121 78 101 00 Techrica:0 erica) 52,017 44 643 71,400 57,600
101 43121 79 101 00 Maintenance 296,489 326,704 355,700 359,700
101 43121 102 GO Full -Time Overtime 12 296 8,392 7,396 18 000 16,000 Maintenance
101 43121 99 103 00 Part-Time Salaries Benefits 12,469 12,078 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,658 700
101 43121 01 203 0' RiW Permit Inspection Forms 28 0 500 500
10143'21 01 203 02 Work Orders 145 51 200 200
101 43121 01 203 03 Cry Specification Books 378 2,953 3,500 0
101 43121 Ot 205 CO Drafting Supplies 1.014 80 306 2 100
101 43121 01 205 01 Paper for Plan Reproductions 1,412 900 900
101 43121 01 205 02 Off -S■e Reproductions 0 450 450
101 43121 01 205 03 Film Developing 0 200 200
101 43121 01 205 C4 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 Chemtcal Chemical Products 32,183 27,017 59,193 37 000 60 000 De -Icirg Chemicals (Added Miles)
101 43121 01 224 00 Street Maintenance Ma,eriais 674 1,500
101 43121 01 224 C1 Paint 473 475 500 500
101 43121 01 224 02 Mad Boxes 93 261 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 D1rt 243 72 2 000 2,000 000
101 43121 01 225 04 Trees 498 0 1000 1,000
101 43121 01 226 00 Sign Repair Materials
8 350 8,646 7941 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 38
101 43121 01 233 00 Dust Control Materals 24,686 22 660 18 460 30000 30 000 Add County Road 38
101 43121 01 234 GO De -Icing Sand 10,136 5,801 3,742 12,000
63 000
101 43121 01 235 00 Shouldering Gravel 2,488 3,534 2,543 3,000 000
101 4312' 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 3063 3,000 3,000 Safety 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 6,000 3.000 6,000 9,000 9,000 Contracted Engineer for C1ty(20
101 43121 01 319 00 Other Professional Services 568 1,489 5,887 1,500 1,500 Random Drug Testing
101 43121 01 321 00 Telephone Costs 2,266 2.171 1 842 3,000 3 000 Cellular Phones Pagers
101 43121 01 324 00 Messenger Services 0 0 80 100 100
10143'21 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 8. Sirens 3,630 3,740 10,000 10,000
101 43121 01 384 00 Refuse Disposal 201 2,800
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 800
101 43121 01 391 00 P C Maintenance 2,500 8,500
101 43121 01 391 01 Gophe' 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 850,000
Page Two
October 11, 2006
Account
101 43121 01 402 00
101 43'21 01 402 00
101 43121 01 403 00
101 43121 01 40301
101 43121 01 403 02
10' 43121 01 403 03
101 43121 71 405 00
101 43121 01 406 CO
101 43121 01 407 CO
10 43121 01 408 00
101 43121 01 40000
101 43121 01 410 00
101 43121 01 410 01
101 43121 01 410 02
101 43121 01 411 00
101 43121 01 411 01
101 43121 01 411 02
101 43121 01 411 02
101 43121 01 415 00
101 43121 01 416 00
101 43121 01 418 00
101 43121 01 420 00
101 43121 01 433 00
101 43121 01 43301
101 43121 01 433 02
101 43121 01 433 03
101 43121 01 433 04
101 43121 01 433 05
101 43121 01 433 06
101 43121 01 435 00
101 43121 01 435 01
101 43121 01 435 02
101 43121 01 43700
101 43121 01 437 01
101 43121 01 437 02
101 43121 01 437 03
101 43121 01 437 04
101 43121 01 437 05
101 43121 01 43706
101 43121 01 437 07
101 43121 01 437 08
101 43121 01 43709
101 43121 01 43900
101 43121 01 570 00
2007 BUDGET WORKSHEETS
STREET MAINTENANCE
Description
Street Seal Coating
General Seal Coanng
Contracted Repair Maintenance 5,472
Street Lghts
Signal Lights
Light Replacements
Street S:nomg 14,084
Street Sweeomg 5,491
&luminous Overlays 0
Street Crack Seating 33,332
Tree Trimming 4,703
Concrete 8 dewalk /Curb Repairs 133,374
General Repairs
Pedestrian Improvements
Contracted Snow Removal 7,215
Community Center
St Joseph s
Genz -Ryan
Equipment Rental 0
Snow Plow Loader Rental 9,260
Snow Plow Rental 0
Truck Rentals /Sidewalk Blower 1,820
Dues Subscriptions 961
American Pubic Works Assn
Request for MJluai Aid Assn
City Engineers' Association
Professional Secretaries
MN Society for Professional Engineers
American Society of Cull Engineers
Books Pamphlets 131
MUTCD
MN Dot Updates
Conferences Seminars 1,303
APWA
Computer Training
Clerical
Gravel Road Maintenance
City Management Training
CEAM
MN Pavement Management
MN Dot
Miscellaneous Training
Other Miscellaneous Charges
Office Equipment Furnishings
PAGE TOTALS
DEPARTMENT TOTALS
2003 2004
Actual Actual
136,226 137,841
10,439
494
1,675
14,324
6,468
0
30,165
3 179
14,202
0
118,327
4,192
16,383
0
0
2,130
0
20 811
29
115
15,652
3,160
0
19 891
4,979
28,50
50
50
30 00
5 00
35,0
5,00
424 8 00 8,000
124,615 125 00 125,000
15 686
12,00 12,000
6,00 6,000
6,000
4.452 45,00
7.199
0
0
340 429 22 225
500 0 1 10
0 0 15 150
80 100 9 90
375 375 30 300
0 0 12 125
39 0 20 200
15 121 60 600
225 989 1,05 1,050
0 251 50 500
90 10 15 150
112 15 150
0 50 500
0 50 500
12 40 400
0 30 300
380 55 45 450
5 469 2,091 2,00 2,000
0 0 0 0
$353,377 $362,457 $222,024 $308,200
$1,048,618 $1067,818 $1 045 241 $1,153,700
2006 2007 Object 2007
2005 Adopted Detail Proposed
Actual Budget Amount Budget
0
0
28,500
500
500
29 500
25,000
5,000
0
35,000
5,000
133 000
24 000
45,000
0
0
0
900
4 000
$309,200
$1,159 200
0 Moved to Street CIP Part of
Pavemen• Management Program
Repair 9 Street Lights tAnnua'lyl
Paver Rental
(APWA)
(RMAA)
(MSPE)
(ASCE)
800
Safety Training
Comments
Page One
October 11, 2006
2007 BUDGET WORKSHEETS
PARKS 8 GROUNDS MAINTENANCE
2006 2007 Object 2007
2003 2004 2005 Adopted Detail Proposed
Account Description Actual Actual Actual Budget Amount Budge;
M Salary Costs Inc usive of
101 45202 101 00 Salaries Benefits $259,401 5375,500 Salary Taxes, PERA Benefits
101 45202 77 101 00 Administrative 9,396 10 977 10,200 10 500
10 45202 79 1 01 00 Maintenance 291,950 310,226 354,600 368,000
ICI 45202 10200 Full -Time Overtime 2,655 5,174 5,578 14 000 14,000
101 45202 99 103 00 Part-Time Salaries Benefits 12,434 19,574 31,516 15,000 15,000
101 45202 01 205 00 Drafting Supplies 0 0 0 100 100
101 45202 01 216 00 Chemical Chemical Products 13,141 34 000
101 45202 01 216 01 Herbicdes(General Park Use) 4,727 8,027 12,000 12,000
131 45202 0 216 02 Fertilizer 10,833 18 780 17,000 22,000 And Meadows Innisfree &Harmory
101 45202 01 219 00 Other Operating Supplies 9,105 12,000
101 45202 01 219 01 Seed, Sod, etc 878 2,561 3000 3,000
101 45202 01 219 02 Red Rock Sand Gravel, etc 1,227 2,222 6 000 6,000
101 45202 01 219 03 Repair Supplies 2,129 0 3,000 3,000 Bloomfield Bircn Parks Online
101 45202 01 219 04 Bituminous 0 0 0 0 Repave Schwarz Parking Lot
101 45202 01 221 00 Equipment Parts 70,526 15,000 Add Meadows Innisfree
101 45202 01 221 01 Playground Equipment Repair 3,151 4,464 2,500 7,500 Woodchips
101 45202 01 221 02 Irrigation Repair(Non- Contract) 3,184 2,707 3,000 5,000
101 45202 01 221 03 Miscellaneous(Player Benches) 4,843 843 2,500 2,500
101 45202 01 221 04 Park Sign Replacements 0 4,290 5,500 0
101 45202 01 223 00 Building Repair Supplies 5,245 10 000
101 45202 01 223 01 Pant, Stain, etc 1, 1,270 1,500 1500
101 45202 01 223 02 Shingles Boards, etc 599 1,998 2,000 2,000
10' 45202 01 223 03 Miscellaneous 1,639 784 1,100 1,500 Caulk, Hardware, etc
'01 45202 01 223 04 ShelteUShed Repairs 0 7238 5 000 5,000
101 45202 07 225 00 Landscaping Matenas 1,370 7,000
101 45202 01 225 01 Trees, Shrubs, Sod etc 3,181 2,301 3,500 3,500 Landscaping Around Park Signs
101 45202 01 225 02 Timbers, Fence, etc 307 2,302 3,500 3,500
101 45202 01 226 00 Sign Repair Materials 0 14 264 500 500
101 45202 01 229 00 Other Maintenance Supplies 1,540 1,907 3,982 4,000 4,000 Paint, Chalk, Bases, Field Dry etc
101 45202 01 241 00 Small Tools 2,786 2,430 1,660 2,500 2,500 Hand Tools, Blades, Bits, etc
101 45202 01 242 00 Minor Equipment 2,585 450 1,326 2,500 2,500 Safety Equipment
101 45202 01 303 00 Engineering Fees 0 0 0 0 0
101 45202 01 305 00 Medical and Dental Fees 207 0 0 0 0
101 45202 01 318 00 Contract Engineer 1,375 750 1,500 3,000 3,000 Contracted Engineer for City (5
101 45202 01 321 00 Telephone Costs 1,532 2,017 1,773 500 500 Cellular Phone Bills
101 45202 01 323 00 Radio Units 0 0 0 500 500 Walkie- Talkies
101 45202 01 331 00 Travel Expense 0 0 0 100 100 Seminars Workshops
101 45202 01 341 00 Employment Advertising 0 0 0 0 0
101 45202 01 381 00 Electric Utilities 12,811 15,500
101 45202 01 381 01 Skating Rinks 4,088 4,031 6,000 8,000
101 45202 01 381 02 SoROall Fields 6,163 6 506 6,500 6,500
101 45202 01 381 03 Irrigation 1,965 2,138 3,000 3 000
101 45202 01 383 00 Gas Utilities 2,200 2,210 2,487 3,300 3,300
101 45202 01 403 00 Contracted Repair 8 Maintenance 2 570
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 160 5 000 5,000
101 45202 01 409 00 Other Contracted Repair Maint 0 2,335 3,913 8,000
101 45202 01 416 00 Macninery Rental 11,876
101 45202 01 416 01 Mower Leases 12,235 14 100 17,000 17
101 45202 01 416 02 Miscellaneous Rentals 4,663 973 1,000 1,000
101 45202 01 433 00 Clues Subscriptions 45
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
101 45202 01 437 00 Conferences 8 Seminars 882
101 45202 01 437 01 Seminars Workshops 383 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
PAGE TOTALS
DEPARTMENT TOTALS
8,000
Roof Jaycee Park Shelter
8 000 Chemical Lawn Services
18 000
200
100
2,500
5354,072 $409,966 5467,288 $532,800 $555 000
$354,072 $409,966 $467,286 $532,600 $555,000
Price Increases
200 Contingencies
Comments
The Parks and Recreation Department works together with citizens to provide a
safe, healthy and pleasant community. Parks and recreation is an essential
service, one that can impact health, crime prevention, the environment, the
economy and the quality of life for Rosemount residents.
ADMINISTRATION
RECREATION
PARKS AND RECREATION
Provides for overall planning, coordination, management of personnel and
adrruustration of activities within the department of Parks and Recreation. This
department provides a diversified range of programs for the residents of Rosemount.
The long range planning, development and budget preparauon of parks and
coordination with other service agencies are ongoing acuvines Administrative
services also provide the residents of Rosemount an opportunity to teseiz e facihues
and register for programs.
Provides the Rosemount resident a variety of recreational activities serving all ages
Program offerings are based on the needs of residents as determined and evaluated
by the Parks and Recreation Commission and staff Coordination with other service
agencies encourages a comprehensive, quahry and efficient base of programs.
COMMUNITY CENTER
Provides for operation of a multi- purpose Community Center, which offers facilities
for recreational programs, banquets, meetings, events, theatrical productions,
serrunars and exercise. The Community Center provides services in the form of
meeting space, gym space for community groups and sponsorship of community
events The Parks and Recreation Department provides ongoing, preventive
maintenance and Janitorial services of the Community Center and Nauonal Guard
factliues.
Page One
October 11, 2006
Account
2007 BUDGET WORKSHEETS
PARKS RECREATION
Description
101 45100 101 00 Salaries Benefits
101 45100 102 00 Full -Time Overtime
101 45100 103 00 Par.T,me Salaries Benefits
101 45100 xx 103 00 PIT Secretary
101 45103 10 103 CO P/T Receptionist
101 45100 '2 103 00 Eu Idmg Attendants
101 45100 53 '03 00
101 45100 94 103 00
101 45100 99 133 00
101 45100 71 103 00
Playground Recreation Leaders
Warming House Attendants
Park Rec Committee
PIT Horticulturist
101 45100 01 203 00 Printed Forms Paper
101 45100 01 205 00 Draf'ing Supplies
101 45100 01 207 00 Training Instructional Supplies
101 45100 01 208 00 Miscellaneous Supplies
101 45100 01 209 00 Other Office Suoplies
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 Equipment 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 01 321 00 Telephone Costs
101 45100 01 331 00 Traeel 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 45100 01 349 03 Special Marketing
101 45100 01 381 00 Electric Utilities
101 45100 01 383 CO Gas Utilities
101 45100 01 384 00 Refuse Disposal
101 45100 01 391 00 P C Maintenance
101 45100 01 391 01 Annual Online Fee
101 45100 01 391 02 Annual Online Maintenance
101 45100 01 394 00 P C Software Purchases
101 45100 01 401 00 Contracted Budding Repairs
101 45100 01 404 CO Contracted Mach Equip Repairs
101 45100 01 409 00 Other Contracted Repair 8 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
2003 2004 2005
Actual Actual Actual
5392,557 5475,475 5576 211 $628 800
11 770 11,215 9,458 4 700
31 908
22,625
81,185
19,370
8 272
1,912
0
35 834 0
26,707 23,770
71 617 50 603
20,923 16 262
9,852 9,442
1,912 2 396
0 14
268 0 285 0 0
215 983 408 1,000 1,000 Film, Developing Laminating
0 0 0 200 200 Books, Tapes, etc
576 438 0 500 500 Meeting Supplies
1,622 1,161 437 1,600 1,500 Envelopes, Forms, Rulers, etc
5,846 4,845 4,254 5,500 5,500
924 941 1,181 1,500 1 500
5 208 5,224 4,903 7,000 7 000 Rec Programs 1st Aid Sup, etc
5,560 10,115 9,424 9,500 9,500
4,624 5,284 4 194 5,500 5 500
53 0 0 0 0
153 0 0 0 0
374 481 0 800 800 Employment Physicals
5,969 5,983 4,899 6500 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,804 2 500 2,500 ADA Services /Eng LA Sery Test
1,736 2,751 2,425 3,100 3 100 Pagers Cellular Phones
16 46 149 500 500
2,092 2,310 1 602 2,500 2 800 General Employment Ads
20,473 192 25 800
17,734 24,600 City Newsletter
3,408 3 692 Rec Ads
473 1,753 New Program Flyers
19,948 18,726 23,240
23,465 26 823 34,957
3,783 3,180 3,106
0
0
13,855
8,702
18,948
16,800
14,135
2,684
497
0 0
0 0
0 0
5,908 7,862
5 816 4,810
19 908 19,389
17 071 16 800
12,984 14 060
1,321 1,259
978 787
50 19 0
1.230 1,721
0 0
805 463
59,887 35,281 25,004
2006 2007 Object 2007
Adopted Detail Proposed
Budget Amount Budget
0
30,200
33,000
20,000
13 000
2 500
5,000
21,500
3 400
2,400
26,000
33,600
4,000
10,000
8 000
20,000
16,800
18,000
2,000
300
2,200
0
0
31 200
49 000
20,000
13,000
2,500
6,500
20 000
3,400
2,400
0 6,000
0 1,500
0
1,100 1,500
400 400
100
2,000
300
2,200
Comments
26,000
33 600
4,000
7,500
$814,625 5872,360 5914,988 $967,700 $1,030,500
$814625 $872,360 $914,988 $967,700 $1030,500
All Salary Costs Inclusive cf
$545,400 Salary, Taxes, PERA Benefits
10,500
122 200
Moved Above to Furl -Time
15 000 Purchase Online Registration Prg
10,000
8 000
20 000
16 800
18 000
1,900
100
4,500
Air Handler Maintenance Contract
Monthly Rent Payments to Guard
Portable Toilets 8 Other Rentals
Minn Recreation Parxs Assn
Paper, Magazines, JC Dues etc
0 Donation Account
Page Two
October 11, 2008
2007 BUDGET WORKSHEETS
PARKS RECREATION
2006 2007 Object 2007
2903 2904 2905 Adopted Detail Proposed
Account Description Actual Actual Actual Budget Amount Buaget
101 45100 71 Horticulturist $2,584 $0 80 $0 $0
101 45100 81 Softball 44 322 46,211 47,639 40 000 51,000
101 45100 82 Volleyball 575 335 40 900 900
101 45100 84 Tennis 955 803 1,042 800 600
101 45 85 Tiny Tots 16,419 18,406 18,739 19 000 19,000
101 45100 36 Rosettes 958 1,230 784 2,000 2,000
101 45100 87 Trips 2,873 9,055 10,737 3,000 3,000
101 45100 98 Brcomball 0 0 0 0 0
101 45'00 39 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 46100 91 Camps 3,884 8,292 13 634 4,000 4,000
101 45100 92 Adult Basketball 74 0 178 1,900 1,900
101 45100 93 Other Programs 6,487 8,553 11,331 6,500 6,500
101 45100 95 T -Ball 5,546 4,171 4,354 5900 5900
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 Salanes 2,58
101 45100 81 103 00 Part-Time Salaries 24,27
101 45100 81 219 00 Operating Supplies 8 09
101 45100 81 311 00 Officiating Fees 6,57
101 45100 81 319 00 Other Professional Services 3,37
101 45100 82 103 00 Pan -Time Salaries
101 45100 82 219 00 Operating Supplies 57
101 45100 82 311 00 OHiclatng 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,26
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
101 45100 87 219 00 Operating Su°plies 2,87
101 45100 88 219 00 Operating Supplies
101 45100 88 311 00 Officiating Fees
101 45100 89 103 00 Part-Time Salaries
101 45100 89 219 00 Operatng Supplies
101 45100 90 219 00 Operating Supplies 2,90
101 45100 91 103 00 Part -Time Salaries 1,98
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,10
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,88
101 45100 98 103 00 Part-Time Salaries
101 45100 98 229 00 Operating Supplies
92 47 108,481 119,205 91 500 102,500
SPECIAL PROGRAM TOTALS 92,475 108,481 119 205 91,500
GRAND TOTAL PARK 8 REC
51:2,500
See Abode
Comments
0 0 0 0 See Above
22,834 25 910 24,300 7 000
11,912 9,178 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
0 0 0 0
803 998 650 650
0 45 150 150
14,170 16,289 18 000 18 000
2,236 2,451 1,000 1 000
566 247 1,200 1,200
684 537 800 800
1,151 769 0 0
7,905 9,969 3 000 3 000
0 0 0 0
0 0 0 0
73 135 400 400
0 0 0 0
3,203 2,655 3,000 3 000
5.877 6 772 2,000 2 000
2,415 6,862 2,000 2,000
0 176 1,900 1,909
3,019 2,750 2,000 2,000
5 534 8,581 4,500 4 500
3,106 3,103 4,000 4 000
1.065 1,251 1 000 1 000
453 1,220 0 0
5,087 6 355 5,000 5,000
0 0 0 0
4,608 365 0 0
102 500
$907 100 $980,641 51 034,194 $1059200 $1,133 000
GENERAL ADMINISTRATIVE
CAPITAL IMPROVEMENT PLAN (CIP)
Provides for specific funding of items, the nature of which are not considered
"current" m their use or life expectancy These items are genera of a higher
estimated cost than $5,000 and will have a life expectancy of 3 years or greater.
The source of funding for these expenditures is typically the general tax levy In
some instances, other funding is utilized For example, beginning in 1996, revenues
received from user fees have been designated in the CIP funds for capital equipment
purchases or for street projects such as gravel road resurfacing If these revenues are
realized, the equipment or project will be completed and if the revenue is not
realized the equipment or project will not be completed Individual departments are
designated for each item proposed for purchase in this plan.
Included are three separate funds to isolate and better track the types of capital
Improvements being planned for. The following briefly describes each of the three:
Building CIP Fund This fund is used to account for the on -going capital
improvements and possible addttons to government builduigs
Street CIP Fund This fund is used to account for the on -going street construction
and reconstruction projects within the City and all other major maintenance items
related to both paved and unpaved streets Including, but not limited to, street lights,
signal lights, sidewalks and gravel road resurfacing
Equipment CIP Fund This fund is used to account for the on -going replacement
of and additions to City equipment.
The CIP budgets included with this document are for the year 2006 only As part of
a long -range planning process, a 10 -year CIP working plan has been adopted for the
years 2006 through 2015 This is a working plan only, with the current y ear (2006 in
this case) being approved as part of the formal budget process.
ca
N
r
2001
]00)
2007
]007
2007
20117
2001
1 1007
2007
2007
29111
2001
F2007
2007
.00/
2007
2007
1007 4007
21)07
20117
1
L
nlela
1
1
I no ierWean Vehicle (Reidne a loof
5117 veTo rtmnare rinm
Emelyenry
Erupment fun Squad: 11 Installation
Emnpment fur New ;mlad
r Pmke Mosier rile LlUdafe
Construct'on el Parkins Lol for 0157 Golf Course
10115men1 r'erte¢a YearsZ
2000 Fgmpincnt Certificate; (5-Years)
Item Description
SWOM 9nd
Sv,JOM qnd
Pub Weer,
Pub Works
Vn Nb1 1
_1; Works
Pub Work;
Yn11Le
Pollrp
I P011ce
Pollee
Ponce
Park Re=
Park Rec
Park Rea
Park Stec
t rue
Can I Gov'
Fnanre
Irrnanre
Count!
Council
Arena
Comm Dov
De arMenl
6mldlne
CIP Levy
1,050,000
300,0000
50,000
Street
OR Levy
303,000
1
93 000
uuu al
000 9r
11111114
r 50,000_
000 04 1
000 01
Equlpmnt
CIP Levy
1,000,0001
1000,000
F-
Assess
468,000
000004
000 00
8,000
15,000
15 000
Park Imp
Fund
600 000
600 0001
MSA
Funds
From
Slate
1 250,0001
1 250 000
01
1,050,00
950,0011 I
200 0001
766,000
c /6,000
o
15,0001
100,1100
10 000
T J
141 0001
16 000
15,0001
+00000_1
I0 0001
H
Sewer
Uuey
131,000
16 001
15 000
100,0001
437,153
1
1 349 198
11,930,5001
160 00
45 000 1
200,0
1 670 000
140,000
9 660
H
5 000
7 500
1 108,000
Other
48 000
160,000
45 0001
45 inn
000 0LL 0_
0oo'o0z 1
1400001
1 92 00 01
e
5,007,000
7550
000'009
000338
6003.0
8,000
15,000
4(1 099
108,000
no ono
11(,900
10 000
L 20,400
349
Total
Cost
ca
GENERAL ADMINISTRATIVE
INSURANCE
Provides for the funding of the City's Worker's Compensation Insurance and
General Liability Insurance Currently, both insurances are provided through the
League of Minnesota Clues Insurance Trust This agency allows the City to have
thorough, yet affordable insurance
In 1995, we set up a separate Internal Service Fund for insurance purposes. The
amount levied was, and will be, the same as it would have been if the Insurance
budget had been in the General Fund, as it has been in the past. But, this allows us
to build a special fund for Insurance purposes that will allow the C¢y to move
towards self insurance, and ultimately, lower rates We do not anticipate ever being
totally self insured, but by raising our deductibles we approach that point and allow
ourselves to save substantially on our annual insurance premiums Doing so will
allow the City to operate more efficiently and save the taxpayers money without
taking undue risks
Page One
October 11, 2006
Account
206 31010 00
206 33100 00
206 36210 00
256 36214 00
206 36215 00
206 36260 00
2007 BUDGET WORKSHEETS
INSURANCE REVENUES
Description
Current Ad Valorem Taxes
Federal Grants Aids
Interest Earnings -In +estments
Net Charge in FV- Investments
Interest Earrings
Other Revenue
FUND TOTALS
Account Description
206 49006 01 221 00 Equipment Parts
INSURANCE EXPENDITURES
206 49006 01 304 00 Legal Fees
206 49006 01 305 00 Medical Dental Fees
206 49006 01 317 00 General Fund Administrative Fees
206 49006 01 319 00 Other Professional Services
206 49006 01 365 00 Worker's Compensation Insurance
206 49006 01 369 00 Other Insurance
206 49006 01 409 00 Other Contracted Repair Mainl
206 49006 01 439 00 Other Miscellaneous Charges
FUND TOTALS
2003
Actual
5210,000 3225,000
0 0
8 735 4,044
0 0
240 397
30,749 34,443
2003
Actual
$1,096
0
3,489
2 500
23,010
77,887
141,688
2036 2007 Object 2007
2004 2005 Adopted Detail Proposed
Actual Actual Budget Amount Budget
$255,000
0
12,452
0
401
40,083
$260 000
0
5,200
a
500
25,000
249,724 263,884 307.936 291,500
2004 2005
Actual Actual
$77 $232 $2,000
3,981 0 3,000
3,916 3,517 15 000
2,500 2 500 2,500
16560 16,970 25,000
76,884 61,648 80,000
131,841 133,147 155.000
11,445 6,431 11,677 9,000
0 0 0 0
261,114 242,189 229,691 291 500
NOTE Levy of $260,000 covers costs for consultant fees and all insurance premiums
All other expenditures covered through interest earnings and insurance refunds /dividends
28
2006 2007 Object 2007
Adopted Detail Proposed
Budget Amount Budget
267,500
Comments
$26C,000
0
5 000
0 Annual Market Value Crarges
500
22 000 insurance Refundsr0midenas
Comments
$2,000 Liability Auto Deductible Pymts
3,000 Unreimbursable Legal Fees
10,000 Work Comp Deductible Pymts
2,500 Yearly Fee Per Policy F -3
20 000 Risk Management Consultant
75 000 Annual Premium
165 000 Annual Premium- General Liability
10,000 Liability Auto Deductible Pymts
0
GENERAL 1 ADMINISTRATIVE
PORT AUTHORITY
The Rosemount Port Authonty is the successor to the Rosemount Housing and
Redevelopment Authority (1 [PtA) and the Rosemount Economic Development
Authonry (EDA). As such, the Port Authority is responsible for both
redevelopment and economic development activities in the City.
The Port Authority concentrates much of its activity on the development of the
Rosemount Business Park and on the redevelopment of downtown Rosemount.
The Port Authonty will continue to work on other development and redevelopment
projects related to commercial and industrial development.
Page One
September 19, 2008
Account
201 31010 00
201 31050 00
201 3313000
201 33425 00
201 34109 00
201 36105 00
201 3621000
201 36211 00
201 36212 00
201 36215 00
201 3623000
201 36250 00
201 36265 00
201 39101 00
Account
2007 BUDGET WORKSHEETS
PORT AUTHORITY REVENUES
Description
Current Ad Valorem Taxes
Tax Increments
Federal Grants -CDBG
Ctne• State Grants Aids
Other Charges for Services
Pnnclpal on Notes
Interer Earnings Invesrments
interest Earnings Loch
Interest Ear ^ings Blake
Interest Earnings
Contrbudons!Donatioos
(Diner Revenue
Use of Reserve Funds
Sales of General Fixed Assets
FUND TOTALS
EXPENDITURES
2003 2004 2005
Description Actual Actual Actual
201 46300 99 103 00 Part-Time Salanes Benefits
201 46300 01 303 00 Engmeenng 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 Ptammmg Consultant
201 46300 01 315 02 Downtown Communications Plan
201 46300 01 315 03 Downtown Ombudsman
201 46300 01 315 04 Downtown Des,gn Standards
201 46300 01 315 05 Downtown Market 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 0 319 04 P/A 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 Pnnting Boding Costs
201 46300 01 365 00 Workers Comp Insurance
201 46300 01 369 00 Other Insurance
201 46300 01 381 00 E,ectric Utilities
201 46300 01 389 00 Other Utility Services
201 46300 01 433 00 Dues Subscriptions
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 46300 01 439 00 Other Miscellaneous Charges
201 46300 01 521 00 Building Structure Purchases
201 46300 01 525 00 Build trig Structure Purchases
201 46300 01 530 00 Improvements Other Than Btdgs
201 46300 01 710 00 Transfers
FUND TOTALS
2003
Actual
$0
0
13 403
0 50,00
0
433,041 39,83
5,002 4,2
1 966
5,066 7,50
286 30
0
16 000
0
0
2004 2005
Actual Actual
$60,00
41 51
281
6,99
27
15,00
2006 2007 Object 2007
Adopted Detail Proposed
Budget Amount Budget
560 00
42,30
2,00
6 30
40
18,90
$477,754 5101,910 $126 599 5129,900
2006
Adopted
Budget
$3,18 $3,713 53,14 $5,00
3,479 5,00
8,58 3,384 4,74 25,00
0 52
36 28,453
1,19 30,929
7,173
5,040
9,55 0
0
6,00 6,000 6,00 6,00
69 36 338
3,01 8,536 98 25,00
9,903 11,48 10 00
41 930 3,24 4,00
943 88
0 3,00
0 11,00
0 20
0 19 10,00
51 481 36 50
2,13 2 721 2 22 4,00
11 143 17 20
28 508 66 1,00
0 425.532 0 0
0 0 87,000 0
9.950 4,398 0 0
0
0
0
0
0
15,000
10,000
4,000
0
49 15,402
448 1,500 1,500
15,000 15,000 15,000
528 3,043 4,403 3 000
1 229 0 457 500
5
36 40
2,00
6,00
40
11510
$159,900
2007 Object 2007
Detail Proposed
Amount Budget
0 o to o 0
5114,911 $561,048 5121,943 $129,900 $159,900
5,000
15 000
50,000 (EIS) or (AUAR)
0
0
29,000
Comments
Cpe'ating Levy
Acmm Fees Portion Only
LCDA Downtown Grant
Blake L/T Lease
Interes, Earned on CD's
Pad Off In 2003
Blarte •L T Lease Interest
Checking Interest M,sc
Comments
All Salary Costs Inclusive of
$5,000 Salary, Taxes, PERA Benefits
Port Authority Members
6,000 Yearly Fee Per Policy F -3
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
Page One
September 19, 2006
Account
244 31050 00
244 36215 00
244 36260 00
2007 BUDGET WORKSHEETS
ENDRES PROCESSING DISTRICT/0089) REVENUES
Descnpnon
Tax Increments
Interest Earnings
Other Revenue
FUND TOTALS
Account Description
FUND TOTALS
EXPENDITURES
2003 2004
Actual Actual
531,039 527,193
0 0
0 0
321 039 327,193 324 730 $27,000
2003 2004
Actual Actual
2008 2007 Object 2007
2005 Adopted Dated Proposed
Actual Budget Amount Budget
524,780 527,000 $25,000 Endres Processing District Only
0
0
2008 2007 Object 2007
2005 Adopted Detail Proposed
Actual Budget Amount Budget
244 49044 01 530 00 Improvements Other Than Bldgs $31,039 $27,193 $24,780 527,000 525 000
244 49044 01 530 00 Endres Processing -Pay as You Go 27,000
531 039 527,193 $24,780 527,000 $25,000
525,000
Commems
Comments
Page One
September 19 2006
Account
242 31050 00
242 36210 CO
242 36215 00
Account 0
2007 BUDGET WORKSHEETS
DOWNTOWN /BROCKWAY DIS TRIO T(0108) REVENUES
Description
Tax Increments
Interest Earnings Investments
Interest Earnings
FUND TOTALS
Description
FUND TOTALS
EXPENDITURES
242 49042 01 319 00 Other Professional Services
242 49042 01 522 00 Buddng Structure Purchases
242 49042 01 530 00 Improvements Other Tnan Buildings
242 49042 01 611 00 Interest on Internal Loan
2006 2007 Object 2007
2003 2004 2005 Adapted Detail Proposed
Actual Actual Actual Buaget Amount Budget
50 50
0 152
0 75
$0
1,217
157
$0 $227 51 374
$0 515,659
0 181,491
0 0
0 0
556 880
194,590
0
17,785
50
0
0
50
$50 000
0
0
$50,000
$0 $197,151 $269,255 $0
Comments
2008 2007 Object 2007
2003 2004 2005 Adopted Detail Proposed
Actual Actual Actual Budget Amount Budget Comments
80 50
0 0
0 50,000 Pay -As -You Go to CP DC
0 0
$50,000
GENERAL ADMINISTRATIVE
DEBT SERVICE FUNDS
Debt Service Funds are Governmental Funds set up to provide for the repayment of
debt of the City This debt is normallv accomplished through the issuance of bonds
secured by the full faith and credit of the City Repat ment of the debt is usually
accomplished through the collection of special assessments, general levies of the,City
collected through property taxes, tax increment funds, core funds, transfers from
Enterprise Funds (Revenue Debt Issues) and transfers from other areas.
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 614 G 0 STORM WATER REVENUE BONDS, 19968
REVENUES
September 5, 2006
2006 2007
2003 2004 2005 Adopted Proposed
Account At Description Actual Actual Actual Budget Budget Comments
614 31010 00
614 36101 00
614 36102 CO
614 36210 00
614 36215 00
614 36265 00
614 37145 00
614 37160 00
614 39202 00
614 39203 00
614 39204 00
614 39205 00
614 39206 00
614 39207 00
614 39310 00
Current As Valorem Taxes
Principal Special Assessments
Penalties Enterest S/A
interest Earnings Investments
Interest Earnings
Use cf Reserve Funds
Surcharge on Water Revenues
Penalties Surcharge Revenues
CantrioLtion From Enterprises
Transfer From
Transfer From Water Core
Transfer From Sewer Core
Transfer From Storm Core
Transfer From Port Authonty
Bond Proceeds
EXPENDITURES
614 47000 01 317 00 General Fund Admn Fees
614 47000 01 319 00 Other Professional Servces
2,07
6
50,00
128,39
50,00
2,56 5,46
3 4
51,00 50,00
51,00 50,00
50,50 52 00
50,50 52,00
FUND TOTALS $230,553 $104,606 $105,514 $101,000 $104,00
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
614 47000 01 601 00 Bond Principal 60,000 65,000 65,000 70,000 75 000
614 47000 01 611 00 Bond Interest 38,498 35,273 31,964 29,900 26 100
614 47000 01 614 00 Amortization of Bond Discount 817 817 817 900 900
614 47000 01 621 00 Bond Paying Agent Fees 193 193 193 200 200
614 47000 01 710 00 Transfers 0 0 0 0 0
FUND TOTALS $99,509 $101,284 $97,974 $101 000 $102 200
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 384 G.0 PORT AUTHORITY MUNICIPAL BUILDING REFUNDING BONDS, 19984
REVENUES
September 5, 2006
Account#
384 31010 00
384 36101 00
384 36102 30
384 36210 00
384 36215 00
384 36265 00
384 37145 00
384 39101 00
384 39202 30
384 39203 00
384 39204 00
384 39205 00
384 39206 00
384 39207 00
384 39310 00
Account#
384 47000 01 317 00
384 47000 01 319 00
384 47000 01 601 00
384 4700001 6 00
384 47000 01 621 00
364 47000 01 710 00
Descnpnon
Current Ad Valorem Taxes
Principal Special Assessments
Penates 8 Interest SrA
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
Transfers
FUND TOTALS
EXPENDITURES
Descnption
General Fund Admm Fees
Other Professional Services
Bond Principal
Bond Interest
Bond Paying Agent Fees
2006 2007
2003 2004 2005 Adopted Proposed
Actual Actual Actual Budget Budget
$348,50 5368,18 5383,516 $255,38 $258,95
58,47
3
156,65
$563 663 $372 563 5391,576 $255,384 $258,957
2003
4 34
3
2004 2005
Actual Actual Actual
6,02
3
2006 2007
Adopted Proposed
Budget Budget
Comments
Comments
$0 $0 $0 $0 $0
0 0 0 0 0
1 620,000 125,000 135,000 135,000 145,000 Refunding for 1992E Paid 2!1/03
115,663 112,925 107,268 101,300 95,000
705 0 0 0 0
0 0 0 0 0
$1,736,368 $237,925 5242,268 $236,300 $240,000
Page One
Account
332 31010 00
332 36101 00
332 36162 00
332 35210 00
332 35215 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
2007 BUDGET WORKSHEETS
DEBT SERV FUND 332 G 0 IMPROVEMENT BONDS, 1998A
REVENUES
September 5, 2006
Account# Descnpton
332 47000 01 710 00 Transfers
Description
Current Ad Valorem Taxes
Principal Soecal Assessments
Penalties Interest S/A
Interest Earnings Investments
Interest Earnings
Use of Reserve Funds
Surcnarge on Water Revenues
Penalties Surcharge Revenues
Contnbunon 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
332 47000 01 317 00 General Fund Admin Fees
332 47000 01 319 00 Other Professional Services
332 47000 01 601 00 Bond Pnnapal
332 47000 01 611 00 Bond Interest
332 47000 01 621 00 Bond Paying Agent Fees
FUND TOTALS
2003
Actual
2006 2007
2004 2005 Adopted Proposed
Actual Actual Budget Budget Comments
$0
103,34 116,066 64,69
25 6,898 1,94
12,05 17,092 12,38
16 4 2
94,10
$209,911 $140,10 $79,250 $226000 $212,000
2003 2003 2005
Actual Actual Actual
so 50
0 0
5
226,00
5
212 00
0 0 0 0
5261,591 5248,261 $234,200 $226 000 $212,000
2006 2007
Adopted Proposed
Budget Budget Comments
$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
Page One
335 31010 CO
335 36101 00
335 36102 00
335 36210 00
335 36215 CO
335 36260 00
335 36265 00
335 37 145 00
335 37160 00
335 39202 00
335 39203 00
335 39204 CO
335 39205 00
335 39206 00
335 39207 00
335 39310 00
2007 BUDGET WORKSHEETS
DEBT SERV FUND 335 G O. IMPROVEMENT BONDS, 1999A
REVENUES
September 5, 2006
2003 2004 2005
Account Description Actual Actual Actual
Account# Description
335 47000 01 317 00 General Fund Admrn Fees
335 47000 01 319 00 Other Professional Services
335 47000 01 601 00 Bond Principal
335 47000 01 611 00 Bond Interest
335 47000 01 621 00 Band Paying Agent Fees
335 47000 01 710 00 Transfers
Current Ad Valorem Taxes
Principal Specral Assessments
Penalties Interest S/A
Interest Earnings Investments
Interest Earnings
Other Revenue
Use of Reserve Funds
Surcharge on Water Revenues
Penalties Surcharge Revenues
Contribution From Enterprises
Transfer From
Transter From Water Core
Transfer From Sewer Core
Transfer From Storm Core
Transfer From Port Authority
Bond Proceeds
FUND TOTALS
FUND TOTALS
EXPENDITURES
5
696 96
36
30,95
57
$0
33,914 32,36
0
24 564 30,99
43 4
386
328,60
9728,860 558,907 $63,411 $328 600 5312 200
2006
2003 2004 2005 Adopted
Actual Actual Actual Budget
$616 170 $585,100 $554460 5328,600 $312,200
2006 2007
Adapted Proposed
Budget Sucget Comments
312 20
2007
Proposed
Budget Comments
$0 $0 $0 $0 $0
0 0 0 0 0
495,000 485,000 475,000 265,000 260,000
120,768 99,698 79,058 63200 51 800
403 403 403 400 400
0 0 0 0 0
Page One
September 5, 2006
2003
Account 4 Description Actual
336 31010 00
336 36101 00
336 361C2 00
336 36210 00
336 36215 00
336 36265 00
336 37145 00
336 37160 00
336 39202 00
336 39203 00
336 39204 00
336 39205 00
336 39206 00
336 39208 00
336 39310 00
Account
2007 BUDGET WORKSHEETS
DEBT SERV FUND 336 G 0 IMPROVEMENT BONDS, 19998
REVENUES
336 47000 01 317 00
336 47000 01 319 00
336 47000 01 601 00
336 47000 01 611 00
336 47000 01 621 00
336 47000 01 710 00
Current Ad Valorem Taxes
Pnncipal Special Assessments
Penalties Interest S/A
Interest Earnings Investments
Interest Earnings
Use cf .Reserve Funds
Surcharge on Water Revenues
Penalties Si.rcharge Revenues
Contribution From Enterprises
Transfer From
Transfer From W Water Core
Transfer From Sewer Core
Transfer From Storm Core
Transfer From Street CIF
Bond Proceeds
FUND TOTALS
Description
Transfers
EXPENDITURES
General Fund Admin Fees
Other Professional Services
Bond Principal
Bond Interest
Bond Paying Agent Fees
FUND TOTALS
2004 2005
Actual Actuam
516.43 $1905 $1961
21,29 69,94 99,25
17 1 3,82
72,46 67,89 44,41
25 6 5
192 63
2006
Adopted
B Jayet
$14,88
747,71
2007
Proposed
eucge'
$19,53
261,96
$110.640 $349,631 $167,155 $762,600 $281,500
2003 2004
Actual Actual
Comments
2006 2007
2005 Adopted Proposed
Actual Budget Budget Comments
$0 $0
0 0 0 0 0
600,000 625,000 655,000 685,000 225,000
162 868 136,218 107 730 77,300 56,200
306 316 316 300 300
0 0 0 0 0
$763,173 5761,534 $763,046 $762,600 $281,500
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 616 G 0 STORM WATER REVENUE BONDS, 1999C
REVENUES
September 5, 2006
2006 2007
2003 2004 2005 Adcnled Proposed
Account Descnpton Actual Actual Actual Budget Budget Comments
816 31010 00
616 36101 00
616 36102 00
616302/000
616 36215 00
616 36260 00
616 36265 00
616 37145 00
616 37160 00
616 39202 00
616 39203 00
616 39204 00
616 39205 00
616 39206 00
616 39207 00
616 39310 00
616 47000 01 317 00 General Fund Admin Fees
616 47000 01 319 00 Other Professional Services
618 47000 01 601 00 Bond Pnncpal
616 47000 01 611 00 Bond Interest
616 47000 01 614 00 Amortization of Bond Discount
616 47000 01 621 00 Bond Paying Agent Fees
616 47000 01 710 00 Transfers
Current Ad Valorem Taxes
Pnncpal Special Assessments
Penalties B Interest- S/A
Interest Earnings Investments
Interest Earnings
Other Revenue
Use of Reserve Funds
Surcharge cn Water Revenues
Penalties Surcharge Revenues
Contrioi,tion From Enterprises
Transfer From
Transfer From Water Core
Transfer From Sewer Core
Transfer From Storm Core
Transfer From Pon Authority
Bond Proceeds
FUND TOTALS
EXPENDITURES
6,16
6
42 00
42,00
4,94
3
7
41,00
41 00
10 31
4
42,00 41,50 43 00
42.00 41,50 4300
FUND TOTALS $90,226 367,062 $94 356 383,000 586,000
2006 2007
2003 2004 2005 Adopted Proposed
Account Descnptian Actual Actual Actual Budget Budget Comments
$0 $0 $o $o $o
0 0 0 0 0
45,000 45 000 50,000 50,000 55,000
36,944 34,829 32,498 31,200 28,700
1,103 1,103 1,103 1 100 1,100
403 403 403 700 400
0 0 0 0 0
583,450 $81,334 $84,004 $83 000 $85,200
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 617 G 0 WATER REVENUE BONDS, 20004
REVENUES
September 5, 2006
Account Descnption
617 31010 00
617 36101 00
517 36102 00
617 36210 00
617 36215 00
617 36265 00
617 37145 00
617 37160 00
617 39202 00
617 39203 00
8'7 39204 00
617 39205 00
617 39206 00
617 39207 00
617 39310 00
817 47000 01 317 00
617 47000 01 319 00
Current Ad Valorem Taxes
Principal Special Assessments
Penalties Interest S/A
interest Earnings Investments
Interes: Earrings
Use of Reserve Funds
Surcharge on Water Revenues
Penalties Surcharge Revenues
Ccntnou'ion 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
General Fund Admm Fees
Other Professional Services
617 47000 01 601 00 Bond Principal
617 47000 01 611 00 Bond Interest
617 47000 01 614 00 Amortization of Bond Dscount
617 47000 01 621 00 Bond Paying Agent Fees
617 47000 01 710 00 Transfers
FUND TOTALS
2003 2004
Actual Actual
5
22
3
98,41
111 00
2003 2004
Account Description Actual Actual
60
2
112,00
2006
2005 Adopted
Actual Budget
2,65
42
115,00
113,00
2007
Proposed
Budget
115,00
5209,671 $112,825 $118,092 9113,000 $115,000
2006
2005 Adopted
Actual Budget
Comments
2007
Proposed
Budget Comments
$0 SO $0 50 50
0 0 0 0 0
55,000 60, 000 65,000 65,000 70 000
53,465 50,785 47,819 46,100 43 000
1,351 1,351 1,351 1,400 1 400
316 316 316 500 600
0 0 0 0 0
5110,132 $112,452 $114,487 $113,000 $115,000
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 337 G 0 IMPROVEMENT BONDS, 2001A
REVENUES
September 5, 2006
2006 2007
2003 2004 2005 Adcoled Proposed
Account Description Actual Actual Actual Budget Bucget
337 31010 00
337 36 00
337 36 00
337 3621C 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
Current Ad Valorem Taxes
Principal Specral Assessments
Penalt es Interest S,A
Interest Earnings Investments
Interest Earnings
Use of Reserve Funds
Surcharge on Water Revenues
Penalties Surcharge Revenues
Contribution From Eterpnses
Transfer From
Transfer From Water Core
Transfer From Sewer Core
Transfer From Storm Core
Transfer From Street CIP
Bond Proceeds
$0 $116,066
72248 14,161
141 11
2 361 4,58
5 2
141,68
154,00
170,00
13,53
12,45
3
166,00
168,00
163,0
FUND TOTALS $370,491 $304,854 5192,016 $168,000 $163,000
EXPENDITURES
2006 2007
2003 2004 2005 Adopted Proposed
Account Descnption Actual Actual Actual Budget Budget
337 47000 01 317 00 General Fund Admin Fees
337 47000 01 319 00 Other Professional Services
so so 50 $0 $0
0 0 0 0 0
Comments
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 0
FUND TOTALS $154,254 3170,676 $166,520 $168,000 $162,300
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUNO 612 G 0 STORM WATER REVENUE BONDS, 2001B
REVENUES
September 5, 2006
Account
612 31010 00
612 36101 00
612 36102 00
612 36210 00
612 36215 30
612 36265 00
612 37145 00
612 37160 00
612 39202 00
612 39203 00
612 39204 CO
612 39205 00
612 39206 00
612 39207 00
612 39310 00
612 47000 01 710 00 Transfers
Description
Current Ad Valorem Taxes
Principal Special Assessments
Penalties :merest 5/A
Interest Earrings Investments
Interest Earn,ngs
Use of Reserve Funds
Surcnarge on Water Revenues
Penalties Surcharce Revenues
Contribution From Enerorises
Transfer From
Transfer From Water Cote
Transfer From Sewer Core
Transfer From Storm Core
Transfer From Port Aulhonty
Bond Proceeds
FUND TOTALS
612 47000 01 317 00 General Fund Admm Fees
612 47000 01 319 00 Other Professional Services
FUND TOTALS
EXPENDITURES
2006 2007
2003 2004 2005 Adopted Prooased
Actual Actual Actual Budget Bucget
$0
0
0
12 11 2,805
4 3 12
45,00 54,00 53,00 55,00 5300
153,76
45,00 54,00 53,00 55,00 53,00
$90,162 5261,912 5108,817 $110,000 $106,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
612 47000 01 601 00 Bond Principal 40,000 60,000 60,000 65,000 65 000
612 47000 01 611 CO 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
0 0 0 0 0
589,862 $107,959 $105 156 5110000 $106,000
Comments
Page One
2007 BUDGET WCRKSHEETS
DEBT SERV FUND 382 G 0 PORT AUTHORITY PUBLIC FACILITY BONDS, 2001C
REVENUES
September 5, 2006
2003 2004
Account Descnption Actual Actual
382 31010 00
382 36101 00
382 36102 00
382 36210 00
352 36215 00
382 36265 00
382 37145 00
382 39101 00
382 39202 00
382 39203 00
382 39204 CO
382 39205 00
382 39206 00
382 39207 00
382 39310 00
Account
382 47000 01 317 00
382 47000 01 319 00
382 47000 01 601 00
382 47000 01 611 00
382 47000 01 621 00
382 47000 01 710 00
Current Ad Valorem Taxes
Principal Special Assessments
Penalt es 8, Interest SCA
Interest Earnings investments
Interest Earrings
Use of Reserve Funds
Surcharge on 'Water Revenues
Sale of General Fixed Assets
Contnoutan From Enterprises
Transfer From
Transfer From Water Core
Transfer From Sewer Core
Transfer From Storm Core
Transfer From Pon Authority
Bond Proceeds
FUND TOTALS
Description
General Fund Admm Fees
Other Professional Services
Bond Pnncipal
Bond Interest
Bond Paying Agent Fees
Transfers
FUND TOTALS
EXPENDITURES
$170,60 $172,91
1,84
2,18
2
2006 2007
2005 Adopted Proposed
Actual Budget Budge
$169,764 $171,86 $168,50
0
0
3,071
3
$172,473 $175,119 $172,865 $171,86 $168 504
$0
0
50
0
$0
0
Comments
2006 2007
2003 2004 2005 Adopted Proposed
Actual Actual Actual Budget Budget Comments
$0
0
25,000 70,000 75,000 75,000 80 000
92,980 91,080 88,180 85,200 82,100
374 403 403 400 400
0 0 0 0 0
$118,354 $161 483 $163 583 $160,600 $162 500
50
0
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 618 G 0. STORM WATER REVENUE REFUNDING BONDS, 2001D
REVENUES
September 5, 2006
2006 2007
2003 2004 2005 Adopted Proposed
Account Description Actual Actual Actual Badge[ Budget
618 31010 00
618 36101 00
618 36102 00
618362/000
618 36215 00
618 36265 00
618 37145 00
518 39101 00
618 39202 00
618 39203 00
618 39204 00
618 39205 00
618 39206 00
616 39207 00
618 39310 00
Current Ad Valorem Taxes
Principal Specal Assessments
Penalties 3 Interest 5 %A
Interest Earnings Inaestmenrs
Interest Earnings
Use of Reserve Funds
Surcharge on Water Revenues
Sale of General F xed Assets
Contribution From Enterprses
Transfer From
Transfer From Water Core
Transfer From Sewer Core
Transfer From Storm Core
Transfer From Port Authonty
Bond Proceeds
EXPENDITURES
610 47000 01 317 00 General Fund Admin Fees
618 47000 01 319 00 Other Professional Services
74,00
74,00
so
0
0
30
51
FUND TOTALS $148,082 $154,07
3 4
4 5
77,00 75,00
77,00 75,00
5
5
77,50 7500
77,50 75 00
$150,098 5155 000 5150 000
2006 2007
2003 2004 2005 Adopted Proposed
Account Descnption Actual Actual Actual Budget Budget
Comments
Comments
SO 30 $0 $0 50
0 0 0 0 0
618 47000 01 601 00 Bond Pnncpal 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 8 600
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 3145,244 $151,419 3147,042 5155 000 5149,000
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 304 G 0 COMMUNITY CENTER REFUNDING BONDS, 2001E
REVENUES
September 5, 2006
Account AI
304 31010 00
304 36101 00
304 36102 00
304 36210 00
304 36 00
304 36265 CO
304 37145 00
304 3910 00
304 39202 00
304 39203 00
304 39204 00
304 39205 00
304 39206 00
304 39207 00
304 39310 00
Account Description
304 47000 01 317 00
304 47000 01 319 00
304 47000 01 601 00
304 47000 01 611 00
304 47000 01 621 00
FUND TOTALS
304 47000 01 710 00 Transfers
2006 2007
2003 2004 2005 Adopted Proposed
Descnpbon Actual Actual Actual B ucget Budget Comments
Current Ad Valorem Taxes
Principal Specal Assessments
Penalties nterest S!A
Interest Earrings Investments
Interest Earnings
Use of Reserve Furds
Surcharge or Water Revenues
Sale of General Fixaa Assets
Contribution From Enterprises
Transfer From
Transter Frorn Water Care
Transfer Fom Sewer Core
Transfer From Storm Core
Transfer From Port Authority
Bond Proceeds
EXPENDITURES
General Fund Admm Fees
Other Professional Services
Bond Principal
Bond Interest
Bond Paying Agent Fees
FUND TOTALS
$93,44
8 49
1
59,87
$96,74
1 24
3
$99,87
1,46
4
$91,94
2,35
5947
$161,835 $98,022 5101 389 $94,300 $94 704
2003
Actual
0
28,998
374
2006 2007
2004 2005 Adopted Proposed
Actual Actual Budget Budget Comments
50 $0 50 50 50
0 0 0 0 0
60,000
28,068
374
65,000
26,130
374
70,000
23,900
400
65 000
21 400
400
0 0 0 0 0
529,371 588 441 591,504 $94 300 586,800
Page One
Account
338 31010 00
338 36101 00
338 36102 00
338 36210 00
338 36215 00
338 36265 00
338 37'45 00
338 37160 00
338 39202 00
338 39203 00
338 39204 00
338 39205 00
338 39206 00
338 39208 00
338 39310 00
2007 BUDGET WORKSHEETS
DEBT SERV FUND 338 G 0 IMPROVEMENT BONDS, 2002A
REVENUES
September 5, 2006
338 47000 01 710 00 Transfers
2006 2007
2003 2004 2CO5 Adopted Pr000sed
Oescnpnon Actual ActJaI Actual BAget Budget Comments
Current Ad Valorem Taxes
Pnncrpal Special Assessments
Penalties 8 Interest S/A
Interest Earnings Investments
Interest Earnings
Use or 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 Steel CIP
Bond Proceeds
FUND TOTALS
EXPENDITURES
338 47000 01 317 00 General Fund Minn Fees
338 47000 01 319 00 Other Professional Services
$0
623,681 681,79
12 58
1,99 3,74
4 2
154,28
50 56,91
672930
2,381
6,75'
5
688 98
$10 77
650 52
FUND TOTALS $780 012 $686,157 $682115 $695 900 $661,300
2006 2007
2003 2004 2005 Adopted Proposed
Account# Descnptien Actual Actual Actual Budget Budget
Comments
$0 $0 $0 so $0
0 0 0 0 0
338 47000 01 601 00 Bond Principal 0 630,000 655,000 635,000 620,000
338 47000 01 611 00 Bond Interest 110,649 95,050 78,956 60 500 40,900
338 47000 01 621 00 Bond Paying Agent Fees 374 374 374 400 400
0 0 0 0 0
$111,023 $725,424 $734,330 $695,900 $661 300
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 619 G 0 WATER STORM WATER REVENUE BONDS, 20023
REVENUES
September 5, 2006
2006 2007
2003 2004 2005 Pdop'ed Propes =_d
Account Description Actual Actual Actual Budget Budget Comments
619 31010 00
619 36101 00
619 36102 00
619 36210 00
619 36215 00
619 36265 00
619 37145 00
619 37 160 00
619 39202 CO
619 39203 00
619 39204 00
619 39205 00
619 39206 00
519 39207 00
619 39310 00
Current Ad Valorem Taxes
Principal Special Assessments
Penalties 8 Interest SiA
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
Transer From S•orm Core
Transfer From Port Authority
Bond Proceeds
FUND TOTALS
EXPENDITURES
$0
28,26 (12,190) 7,85
42 1
18 223 72
4 23 5
15 00 17,00 19,00
26,00 64,00 58,00
15,00 17,00 19,00
29,00
57,00
29 00
56,00
29,000 29 00
0
0
$84 490 686,098 $104,651 $115,000 $114,000
2006 2007
2003 2004 2005 Adopted Proposed
Account DescnpUOn Actual Actual Actual Budget Budget Comments
619 47000 01 317 00 General Fund Admin Fees
619 47000 01 319 00 Other Professional Services
s 50 $0 $0 $0
0 0 0 0 0
619 47000 01 601 00 Bond Principal 0 40,000 50000 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 0 0 0 0 0
FUND TOTALS $48,623 $87,522 $96,047 $115,000 $113,000
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 385 G.0 PORT AUTHORITY BONDS (HIGHWAY 3), 2002C
REVENUES
September 5, 2006
Account Descnplon
385 31010 00
385 36101 00
385 36102 00
385 36210 00
385 36215 00
385 36265 00
385 37145 00
385 39101 00
385 39202 00
385 39203 00
385 39204 00
385 39205 00
385 39206 00
385 39207 00
385 39310 00
Account Desorption
385 47000 01 710 00 Transfers
Curent Ad Valorem Taxes
Pnncipal Special Assessments
Penalties 8 Interest SSA
Interest Earrings Investments
Interest Earnings
Use of Reserve Funds
Surcharge on Water Revenues
Sate of Genera' Fixed Assets
Conti buticn Frcrr Enterprises
Transfer F
Transfer From Water Care
Transfer From Sewer Core
Transfer From Storm Core
Transfer From Part Authority
Bond Proceeds
FUND TOTALS
EXPENDITURES
385 47000 01 317 00 General Fund Admin Fees
385 47000 01 319 00 Other Professional Services
385 47000 01 601 00 Bond Principal
385 47000 01 611 00 Bond Interest
385 47000 01 621 00 Bond Paying Agent Fees
FUND TOTALS
2003 2004
Actual Actual
$283,15 $272 94
31,97 30,18
12
1,26 4,15
2 4
26,00 26,00
252,20
26,00 26,00
2006 2007
2005 Adopted Proposed
Actual Budget Budget Commens
$267,02
36,42
8
11,30
2
$265,81
$258,65
26,00 25,00 25 00
26,00 25,00 25,00
$368,441 $611,653 $366863 $315,816 $308650
2006 2007
2003 2004 2005 Adopted Proposed
Actual Actual Actual Budget Budget Comments
S O $o $0 $0 $0
0 0 0 0 0
0 210,000 205,000 205,000 210,000
64,643 57,308 52,126 46,300 39,800
374 374 374 400 400
0 0 0 0 0
$65,016 $267,681 $257 500 $251 700 5250200
Page One
339 31010 00
339 36101 00
339 36102 00
339 36210 00
33S 36215 CO
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
September 5, 2006
2003 2004
Account Descnptton Actual Actual
Account Descnption
339 47000 01 317 00 General Fund Admin Fees
339 47000 01 319 00 Other Professional Services
339 47000 01 601 00
339 47000 01 611 00
339 47000 01 621 00
339 47000 01 710 00
Current Ad Valorem Taxes
Principal Special Assessments
Penalties 4 Interest SIA
Interest Earnings Investments
Interest Earnings
Use of Reserve Funds
Surcharge an Water Revenues
Penalt es Surcharge Revenues
Contnbuticn From Erterpnses
Transfer From
Transrer From Water Core
Transfer From Sewer Core
Transfer From Storm Core
Transfer From Street CIP
Bond Proceeds
FUND TOTALS
Transfers
FUND TOTALS
EXPENDITURES
Bond Principal
Bond Interest
Bond Paying Agent Fees
2003
$0
0
0
0
27
154,94
1 45
82
1
43,00
43,00
2006
2005 Adopted
Actual Budget
234 86
51
2,68
44,00
44,00
57,58
$57,0611 $243,235 $326,131 $329,354 $238 200
2004 2005
Actual Actual Actual
$86,35
155,00
44,00
44,00
2007
Proposed
Budget
$86,35
63 84
44,00
44 00
$0 558,066 5261,530 $243,000 5238,200
Comments
Levy for St Joe's Assumed SIA
2006 2007
Adopted Proposed
Budget Budget Comments
$0 $0 $0 $0 $0
0 0 0 0 0
O 0 210,000 195,000 195,000
0 57,663 51,128 47,100 42700
O 403 403 900 500
O 0 0 0 0
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 613 G 0 WATER REVENUE BONDS, 20038
REVENUES
September 5, 2006
Account Description
613 31010 00
613 36101 00
5133610200
513 36210 00
613 36215 00
613 36265 00
613 37145 00
613 37160 00
613 39202 00
613 39203 CO
613 39204 00
613 39205 00
613 39206 00
613 39207 00
613 39310 00
Account
613 47000 01 710 00 Transfers
Current Ad Valorem Taxes
Pnncipal Special Assessments
PenaNles Interest S/A
Interest Earnings Investments
Interest Earnings
Use of Reserve Funds
Sum 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
613 47000 01 317 00 General Fund Admin Fees
613 47000 01 319 00 Other Professional Services
32,00
2003 2004
Description Actual Actual
613 47000 01 601 00 Bond Pnncipal
613 47000 01 611 00 Bond Interest
613 47000 01 614 00 Amortization of Bond Discount
613 47000 01 621 00 Bond Paying Agent Fees
FUND TOTALS
2006 2007
2003 2004 2005 Adopted Proposed
Actual Actual Actual Budge! Budget Comments
3
4
5
14
3
134,00
134,00
5
138 00
2,97
52,982 532,07 5134,176 $134,000 $138,000
2006 2007
2005 Adopted Proposed
Actual Budget Budget Comments
50 $0 $0 $0 $0
0 0 0 0 0
0 0 0 105,000 110,000
14,338 28,675 27,568 26,700 25,000
926 1,852 1 852 1,900 1,900
0 0 403 400 400
0 0 0 0 0
515,263 $30 527 $29,822 5134,000 5137,300
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 301 G.D CAPITAL IMPROVEMENT PLAN (CIP) BONDS, 2005A
REVENUES
September 5, 2006
2006 2007
2003 2004 2005 Adapted Proposed
Account Descnpton Actual Actual Actual Bucget Budget
301 31010 00
301 36101 00
301 36102 00
301 36210 00
301 36215 00
301 36265 00
301 37145 00
301 3716000
301 39202 00
301 39203 00
301 39204 CO
301 39205 00
301 39206 00
301 39207 00
301 39310 00
301 47000 01 710 00 Transfers
Current Ac Valorem Taxes
Principal Special Assessments
Penalties Interest 3M
Interest Earnings Investments
Interest Earnings
Use of Reserve Funds
Surcharge on Water Reverues
Penalties Surcharge Revenues
Contribution From Enterprises
Transfer From
Transfer From Water Core
Transfer From Sewer Core
Transfer From Storm Core
Transfer From Port Authonty
Bond Proceeds
FUND TOTALS
FUND TOTALS
EXPENDITURES
301 47000 01 317 00 General Fund Admin Fees
301 47000 01 319 00 Other Professional Services
5
$0 $65,457 $208,978 $210,737
5
12
2
65,30
5208,97
$210 73
2006 2007
2003 2004 2005 Adopted Proposed
Account Descnption Actual Actual Actual Budget Budget
5 5 5 $0 50
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
0 0 0 0 0
50 50 $0 5118,000 $198,000
Comments
Comments
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 302 G 0 EQUIPMENT CERTIFICATES, 2005B
REVENUES
September 5, 2006
2006 2007
2003 2004 2005 Adopted Proposed
Account Descrpton Actual Actual Actual Budget Budget
302 31010 00
302 36101 00
302 36102 00
302 36210 00
302 36215 00
302 36265 00
302 37145 00
302 37160 00
302 39202 00
302 39203 00
302 39204 00
302 39205 00
302 39206 00
302 39207 00
302 39310 00
Account If
Current Ad Valorem Taxes
Principal Special Assessments
Penalties Interest SA
Interest Earnings- Investments
Interest Earnings
Use of Reserve Funds
Surcharge on Water Revenues
Penalties Surcta gs Revenues
Conti From Enterprises
Transfer From
Transre' From Water Core
Transfer From Sewer Core
Transfer From Storm Cora
Transfer From Port Authority
Bond Proceeds
FUND TOTALS
EXPENDITURES
$0
$347 21
1,75
$1,764 5347,21
$349,19
$349,19
2006 2007
2003 2004 2005 Adopted Proposed
Description Actual Actual Actual Budget Budget
302 47000 01 317 00 General Fund Admm Fees $0 $0 $0 $0 $0
302 47000 01 319 00 Other Professional Services 0 0 0 0 0
302 47000 01 601 00 Bond Principal 0 0 0 290,000 300,000
302 47000 01 611 00 Bond Interest 0 0 20,566 40,700 32,600
302 47000 01 621 00 Band Paying Agent Fees 0 0 0 300 400
302 47000 01 710 00 Transfers 0 0 0 0 0
FUND TOTALS $0 $0 $20,566 $331,000 $333,000
Comments
Comments
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 610 G 0 WATER REVENUE BONDS, 2005C
REVENUES
September 5, 2006
2006 2007
2003 2004 2305 Adopted Proposed
Account Description Actual Actual Actual Budget Bucge•
610 31010 00
610 36'01 00
6'0 36132 00
610'_62 00
610 36215 00
610 36265 00
610 37145 00
610 37160 00
6 3920200
610 39203 00
610 39204 00
610 39205 00
610 39206 00
610 39207 00
810 39310 00
Current Ad Valorem Taxes
Principal Specral Assessments
Penalties 6 Interest SIA
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
610 47000 01 317 00 General Fund Admin Fees
610 47000 01 319 00 Other Professional Seneces
10, 05
60
5,70
8
233 68
1,8
22,11
5
240,000
5
338,00
50 30 5274,066 5240,000 $338,000
2006 2007
2003 2004 2005 Adopted Proposed
Account Description Actual Actual Actual Budget Budget
FUND TOTALS $0 50 $159,381 $80,000 $338,000
Comments
For 111/07 Used for WTP
Comments
$0 $0 SO $0 50
0 0 0 0 0
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,610 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
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 303 G 0 FIRE STATION REFUNDING BONDS, 20050 (Old 1996A)
REVENUES
September 5, 2006
2006 2007
2003 2004 2CO5 Adopted Proposed
Account Desorption Actual Actual Actual Budget Budget
303 31010 00
303 36101 00
303 36102 CO
303 36210 00
303 36215 00
303 36265 00
303 37145 00
303 37160 CO
303 39202 00
303 39203 00
303 39204 00
303 39205 00
303 39206 00
303 39207 00
303 39310 00
Current Ad Valorem Taxes
Principal Special Assessments
Penaities interest SiA
Interest Earrings Investments
Interest Earrings
Use of Reserve Funds
Surcharge on Wate• Revenues
Pena,t es Surcnarge Revenues
Contr.buticn From Enterprises
Transfer From
Transfer From Water Core
Transfer F Sewer Core
Transfer From Storm Core
Transfer From Port Authority
Bond Proceeds
FUND TOTALS
303 47000 01 317 00 General Fund Admm Fees
303 47000 01 319 00 Other Professional Services
303 47000 01 710 00 Transfers
FUND TOTALS
EXPENDITURES
$156,13
73
5
1,109,24
$156,912 $153,733 $1,264,542 $1,304,308 $142,527
$152,19
1,52
$153,42
1,83
3
$154,30
1,150 00
$142 52
Comments
2006 2007
2003 2004 2005 Adopted Proposed
Account Descnption Actual Actual Actual Budget Budget Comments
SO $0 $0 SO $0
0 0 4,999 0 0
303 47000 01 601 00 Bond Principal 70,000 75,000 75,000 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
0 0 0 0 0
5145,603 $147 013 $161 554 $1,227,200 $122,500
Page One
2007 BUDGET WORKSHEETS
DEBT SERV FUND 321 G.O EQUIPMENT CERTIFICATES, 2006A
REVENUES
September 5, 2006
2006 2007
2003 2004 2005 Adopted Proocsed
Account Description Actual Actual Actual Budget Budget
321 31010 00
321 36101 00
321 3610200
321 362'0 00
32' 36215 00
321 36265 00
321 3714500
321 37160 CO
321 39202 00
321 39203 00
321 39204 00
321 3920500
321 39206 00
321 39207 00
321 39310 00
Current Ad Valorem Taxes
P nnvpal Special Assessments
Penalties Interest SlA
Interest Earnings Investments
Interest Earnings
Use cf Reserve Funds
Surcnarge or Water Revenues
Penalties Surcharge Revenues
Contribution From Enterprises
Transfer From
Transfer From Water Core
Transfer From Sewer Core
Transfer From Storm Core
Transfer Fom Port Authority
Bond Proceeds
FUND TOTALS
EXPENDITURES
3
$0 50 50 $0 $94 155
587,95
6,20
2006 2007
2003 2004 2005 Adopted Proposed
Account Description Actual Actual Actual Budget Budget
Comments
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 01 601 00 Bond Pnncipal 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
September 5, 2006
2006 2007
2003 2004 2005 Acopted Proposed
Account Description Actual Actual Actual Budget Bdage'
326 31010 00
526 36101 00
326 36102 00
326 36210 00
326 36215 00
326 36265 00
326 37145 00
326 37150 00
326 39202 00
326 39203 00
326 39204 00
326 39205 00
326 39206 00
326 39208 00
326 39310 00
Currant Ad Valorem Taxes
Principal Soecial Assessments
Penalties 5 Interest S!A
Interest Earner gs Investments
Interest Earrings
Use of Reserve Funds
Surcharge on Water Revenues
Penaities Surcnarge Revenues
Contnoution From Enteronses
Transfer From
Transte• From Water Core
Transfer F Sewer Core
Transfer From Storm Core
Transfer From Street CIP
Bond Proceeds
FUND TOTALS
326 47000 01 710 00 Transfers
FUND TOTALS
EXPENDITURES
so $0 s 5206,000
5
5
2006 2007
2003 2004 2005 Adopted Proposed
Account# Description Actual Actual Actual Budget Budget
326 47000 01 317 00 General Fund Admen Fees 50 $0 10 50 $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
0 0 0 0 0
$0 $0 50 50 $206,000
5
5
10,00
196 00
Comments
Comments
WATER OPERATING FUND
This is an Enterprise Fund consisting of revenues from water sales that provides for the operation
and maintenance of the City's wells, towers and distribution system. The City currently has three
water towers (with one more under construction) and six wells (with two more under construction)
This fund covers the operation of over 870 fire hi drants, 460 gate valves and 97 miles of
watermam.
Page One
August 7, 2006
2007 BUDGET WORKSHEETS
WATER UTILITY
REVENUES
2006 2007 OClect 2007
2003 2004 2005 Adopted Detail Proposed
Account p Description Actual Actual Actual Budget Amount Budget
601 33425 00 Other Sate Grants Aids $1,570 $0 so
601 34108 00 Administrative Fees -aher Funds 87,127 18,103 18,595 17,00
601 34109 CO Other Gen 'I Gcvt Chgs for Services 0 2,330 0
5C' 36'01 00 Pr ncipal Soecial Assessments 42,083 31 578 29,049 30,00
6013510200 Penalties &Interest SA 4,780 (1 202) 1330
601 38210 00 Interest Earnings Investments 45,288 55,429 86,611 60,00
601 3E214 00 Net Change in FV- Investments (2 148) 1,128 (5,141)
601 36215 00 Interest Earnings 394 329 291 40
601 36220 00 Rents Royalties 58,266 59,983 50,841 60,00
6013526000 Other Revenues 0 0 100
601 36265 00 Use of Reserve Funds 0 0 0 170 00
601 37110 00 Residennal Water Revenues 897,730 892,800 722,666 620 00
601 37120 00 Apartment Water Revenues 36 815 44,666 58 756 45,00
601 37125 30 Institutional Water Revenues 31,120 96,302 33 635 30,00
601 37130 00 Commercial Water Revenues 50,542 49,647 50509 50,00
601 37140 00 Industrial Water Revenues 41,836 31,946 41,678 40 00
601 37160 00 Penalties Water Revenues 6 826 8,273 7,652 6,00
60/3716500 Meter Maint Water Revenues 0 0 0
601 37170 00 Other Water Revenues 0 0 0
601 37180 00 Water Meter Sales Revenue 136,115 185,063 121,369 130,00
601 39103 00 Gain or Lass from F/A Disposal 3,160 0 (6,898)
6013920300 Transfer From 0 0 109,536
FUND TOTALS
5
5,00
30 00
80 00
40
80,00
670 7
700 00
60 00
30,00
50 00
40 00
6 00
100 00
1,241,505 1,276,402 1,320 579 1258,400 1,832,100
Antenna Leases
Comments
5% of 5% Fees -Const Projects
Annual Market Value Granges
Page One
August 7, 2008
Account
2007 BUDGET WORKSHEETS
WATER UTILITY
EXPENDITURES
Descnpban
601 49400 101 00 Salaries Benefits
601 49400 77 1 01 00 Administrative
601 49400 78 101 CO Tecnnical /Clerical
601 49400 79 101 00 Maintenance
601 49400 102 OC Fill-Time Overtime
601 49400 103 00 Part-Time Salaries Benefits
601 49400 99 103 01 Utility Commission Wages (50
601 49430 99 103 02 Maintenance Labor
601 49400 01 203 00 Printed Forms Paper
601 49400 01 209 00 Other Office Supplies
601 49430 01 216 00 Chemicals Chemical Products
601 49400 01 219 CO Other Opera'ng 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 00 Utility System Maintenance Supplies
601 49400 01 228 00 Meter Repair Materials
601 49400 01 229 00 Otner Maintenance Supplies
601 49400 01 229 01 Supplies for Hydrants
601 49400 0 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 CO 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
801 49400 01 303 02 GIS Update of Asbuilts
801 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 8 Water Quality
601 49400 01 310 02 V 0 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
801 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
801 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
801 49400 01 349 00 Other Advertising
PAGE TOTALS
2003
Actual
5222,229
10,444
14,228
2,076
25
42,372
0
171,902
6,437
0
4,671
1,879
4,750
36,003
25,336
1,654
13,348
12,722
4,349 4 438
0 15,500
603
891 2,35
0
0
0
6,000 3,000 6,00
11,692
43
3,41
64
133
0
0
2004 2005
Actual Actual
81,216
113,592
118,556
7,178
13,126
2 954
314
44,068
657
86 685
125,743
0
0
5,458
0
1,358
0
0
0
1,154
953
2,133
174
13,116
0
3,505
0
0 2,830
6,196
2,439
525
2,438
0
432
3,989
544
0
18
0
0
89,591
106,348
122,362
12,674
10,253
2,750 2,500
146 200
37,013 45,000
0 200
29,325
79,457
141
0
5,130
17
1,330
85
2,229
0
1,381
2 478
1,479 1,500
93,86
5,01
1,30
28,
4,77
20 03
21,06
208
3 50
61
52
97
4,08
56
2006 2007 Object 2007
Adopted Detail Proposed
Budget Amount Sueget
98,000
164,900
151,500
10,000
16,000
130,000
2,000
500
0
300
4,000
1,300
2 200
5,000
1,000
1,500 3,000
25,000
7,000
0
6,000
1,000
2,000
1,000
22,000
5,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
0
101,600
145,400
129,10C
1,000
15,000
130,000
4,000
1,300
2,200
5,000
0
0
7,000
0
12,000
2,000
1,000
35,000
0
5,500
5,000
1 000
50 000
1,500
3,000
500
7,500
600
0
All Salary Costs bolus ve of
$376,100 Salary Taxes, PERA 3 Benefits
10,000
16 000
2,500
200
55,000
200
130,000
2,000 Patching or Breaks
500 Topsoil, Seed Sod
0
300 Miscellaneous Meter Parts
12,500
2,000 Wrenches, Shovels, etc
3,000
19,000
1,000
38,000
$6 36 /Connection Annual Fee (M)
7,000 Gopher State One -Call (M)
0
61,500 Wellhead Protection Plan
9,000 Contracted Engineer for City(20
13 100
0
6,000
2 000
1,000
100
700
500
569,022 693,703 701,119 791,000 759,200
Inserts Water Bill Statements
Disks, Ribbons, etc
Chlorine, Flour de Polyohos
Maintenance Supplies
Meters MIU's CU Horns
50% -60 500 -602
100% 601
Radon, Tn -Chl
Comments
MN Department of Public Safety
Billings with Inserts
ReplacerRepair Radios Phones
AWWA National Seminar
Mail -in Repairs
PIT'ers Personnel Changes
Page Two
August7, 2006
Account
2007 BUDGET WORKSHEETS
WATER UTILITY
EXPENDITURES
Description
601 49400 01 352 00 General Notes Public Info
601 49400 0 365 00 Workers Como Insurance
601 49400 01 369 30 Other Insurance
601 49400 01 391 00 P C Maintenance
6C1 49400 01 392 CO P C Accessories Supplies
60 49400 01 393 00 P C Hardware Purchases
601 49400 31 394 00 P C Software Purchases
601 49400 01 395 00 P C Repairs
601 49400 01 403 00 Contracted R M Other Impr
601 49400 01 418 00 Machinery Rental
601 49400 01 433 00 Dues Subscriptions
601 49400 01 435 CO 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 521 00 Building Structure Purchases
601 49400 01 530 00 Improvements Other Than Bldgs
601 49400 01 53C 01 Annual Inspection of Wells
601 49400 01 530 02 Miscellaneous Improvements
601 49400 01 530 03 CRP of Watermam
601 49400 01 530 04 Replace Pickup #344
601 49400 01 530 05 Survey Grade GPS
801 49400 01 530 06 Crane Box for Pickup #342
601 49400 01 560 00 Furniture Fixture Purchases
601 49400 01 570 00 Office Equipment Purchases
601 49400 01 586 00 Computer Equipment Purchases
601 49400 01 611 00 Interest on Lease Payments
801 49400 01 710 00 Transfers
601- 49400 -01 TOTALS
601 49403 01 221 00 Equipment Parts
601 49403 01 223 00 Building Repair Supplies
601 49403 01 319 00 Other Professional Services
601 49403 01 321 00 Telephone Costs
601 49403 01 381 00 Electric Utilities
601 49403 31 383 00 Gas Utilities
601 49403 01 409 00 Other Contracted Repairs Maint
601 49403 01 439 CO 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 WrM VAULT
601 49407 01 221 00 Equipment Parts
601 49407 01 223 00 Building Repair Supplies
601 49407 01 319 00 Other Professional Services
601 49407 01 321 00 Telephone Costs
601 49407 01 381 00 Electric Utilities
601 49407 01 383 00 Gas Utilities
601 49407 01 409 00 Other Contracted Repairs Maint
601 49407 01 439 00 Other Miscellaneous Charges
501 49407 01 530 00 Improvements Other Than elogs
TOTAL WELL #7
2003 2004 2005
Actual Actual Actual
410
4 107
13,306
507
0
0
2,130
0
0
0
686
0
1,320
63
2
6,330 5,6
0
16,806
0
0
0
5,42
15,75
33
39
1,94
19,02
42
5,419 5,19
0 110,52
602 1,188
1.724 0
0 0
211 211
9,983 10,271
696 656
0 0
0 0
0
0
0
0
1,867
0
4,6
16,75
29
53
30
42
69
40
9,96
9,87
165,46
62,25
58
18
4,94
91,84 0 0 Transfers for Other Improvements
620,042 859,029 1,070,296 1,052,800 1,027,000
5,190
0
0
211
7,139
913
2,050
0
311
0
0
0
1,801
0
2006 2007 Object 2007
Adapted Detail Proposed
Budget Amount Budget
500
4,500
14,000
500
200
4,000
2,500
500
1,000
500
6,000
30,000
30,000
100 000
22 500
25,000
0
1,000
1 000
0
0
1,000
500
1,000
300
7,500
2,000
25,000
100
13,21 12,328 15,503 37,400
3,000 3 000
4 000 4 000
800 6G0 AWWA for 2 Member
300 300 Reference Materials
1 500
10,000 10,000 Pymt on P W Building (8 of 20)
203,500
1,000
0
1,000
300
1,000
0
0 1,887 2,112 3,300
1,000
500
30,000
30,000
100,000
15 000
12,500
16,000
1,996 652 1,092 500
1724 0 0 300
O 6 0 500
211 211 211 300
11,755 13,325 20,307 18,000
O 0 0 0
753 120 0 600
O 0 0 100
O 0 0 0
16,439 14,308 21,610 20,300
500
4 500
14 000
500
200
4 ,000
2 500
500
Newsletters
Water's Share of Premiums
Water's Share of Premiums
Auto Read Software Support
Laptops
(M)
Comments
6,000 ONR Annual Water Use (M)
Each Well Done Every 7 Years
Annual Pavement Management
113 of Total Estimated Cost
50% of Total Estimated Cost
1/3 of Total Estimated Cost
1 000
1,000 Chair, Table
0
0 P W Building Expansion(See 521)
1,000
500
1,000 Independent inspections
300
7 500 Pumping Lighting
2,000 Heat Engine Backup
0
100 Contingencies
12,400
1,000
0
1,000
300
1 000 Pumping Lighting
0 Heat Only
3,300
500
300
500 Independent Inspections
300
18,000 Pumping Lighting
0
600 RTU's Pump Motor etc
100 Contingencies
0
20,300
Page Three
August 7, 2006
2007 BUDGET WORKSHEETS
WATER UTILITY
EXPENOITLRES
2006 2007 Otiect 2007
2003 2004 2005 Adopted Detail Proposed
Account# Description Actual Actual Actual Budget Amount Budget
601 49408 01 221 00 Ecwpment Parts 932 220 8,959 1,000 1 000
601 49408 0" 223 00 Building Repair Supplies 0 0 0 100 100
601 49408 01 319 OC Other Proressional Services 0 0 0 0 0
601 49408 01 321 00 Telephone Costs 211 211 211 300 300
601 49408 01 381 CO 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 Oily
TOTAL WELL #8 18,964 16,743 23987 20,000 20,000
601 49409 01 221 00 Equipment Parts 1,411 0 2,929 500 500
601 49409 01 223 00 Budding Repair Supplies 0 0 0 100 100
601 49409 01 319 00 Other Professional Services 0 0 0 0 0
601 49409 01 321 CO Telephone Costs 211 211 211 300 300
601 49409 01 361 00 Electric Utilities 24,048 24,041 28 475 30,000 30,000 Pumping Lighting
601 49409 01 383 00 Gas Utilities 849 840 1 042 1,500 1 500 Heat Only
601 49409 01 439 00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies
TOTAL WELL #9 26,519 25,09 32,656 32,500 32,500
601 49410 01 219 00 Other Operating Supplies 0 0 1,000 1,000
801 49410 01 221 G0 Equipment Parts 4,424 156 0 0
601 49410 01 223 00 Building Repair Supplies 164 0 100 100
601 49410 01 321 00 Telephone Casts 935 92 935 1,000 1,000
601 49410 01 381 00 Electric Utilities 8,716 8,49 7,961 9,000 9 000 Pumping Lighting
601 49410 01 409 00 Other Contracted Repairs Maint 0 1,80 1,189 2,900 2 900
TOTAL WELL #10 14,240 11,220 10,241 14,000 14,000
601 49411 01 221 00 Equipment Parts 1,245 0 0
601 49411 01 381 00 Electric Utilities 0 0 0 Pumping Lighting
TOTAL WELL #11 1,24
601 49412 01 221 00 Equipment Parts
601 49412 01 223 00 Building Repair Supplies
601 49412 01 319 00 Other Professional Services
601 49412 01 321 00 Telephone Costs
601 49412 01 381 00 Electric Utilities
601 49412 01 383 00 Gas Utilities
801 49412 01 439 00 Other Miscellaneous Charges
TOTAL WELL #12
801 49414 01 221 00 Equipment Parts
601 49414 O1 223 00 Building 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 363 00 Gas Utilities
601 49414 01 439 00 Other Miscellaneous Charges
TOTAL WELL #14
39
1,01
1,41
0 0
500 500
100 100
1,000 1 000
300 300
30,000 30,000 Pumping Lighting
1,500 1,500 Heat Only
100 100 Contingences
33,500 33,500
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
33,000 33,000
Commonis
Page Four
August 7, 2006
2007 BUDGET WORKSHEETS
WATER UTILITY
EXPENDITURES
2006 2007 Object 2007
2003 2004 2005 Adopted Detail Proposed
Account Description Actual Actual Actual Budget Amount Budget
601 49415 01 221 00 Equipment Parts 0 0 0 500 500 Touch -up Pam*
601 49415 01 319 00 Other Professional Services 0 0 0 500 500 Tower Inspection
6014941_ Electrc Utilities 0 0 0 0 0
601 49415 01 409 00 Other Contracted Repairs Maint 0 0 0 500 500
601 49415 01 439 00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies
TOTAL WATER TOWER #1 0 0 0 1,700 1,700
601 49416 01 221 00 Equipment Parts 0 1,790 0 500 500 Touch Paint
49418 01 319 00 Other Professional Services 0 0 0 50 500 Tower Inspection
601 49416 01 32 00 Telephone Costs 211 211 211 300 300
601 49416 01 381 00 Electric Utilities 612 765 1,25 1,400 1 400
601 49416 01 409 00 Other Contracted Repairs Maint 0 0 0 500 500
601 494'6 01 439 CO Other Miscellaneous Crarges 0 0 0 200 200 Contingencies
601 49415 01 530 00 Imprcvemens Other Than Bldgs 0 0 0 500 625 000 Paint Tower Structural Repairs
TOTAL WATER TOWER #2
TOTAL WATER TOWER #4
(Bacardi Water Tower)
TOTAL WATER TOWER #3
(East Side Water Tower)
GRAND TOTAL ALL DEPTS
823 2,766 1,470 3,900 625,400
Comments
601 49417 01 221 00 Equipment Parts 0 0 0 0 0
801 49417 01 321 00 Telephone Costs 0 0 0 0 0
601 49417 01 381 00 Electric Utilities 0 0 0 0 0
601 49417 01 439 00 Other Miscellaneous Charges 0 0 0 0 0 Contingences
0 0 0 0 0
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
601 49419 01 381 00 Electric Utitihes 1,757 1,856 1,647 2,000 2 000
601 49418 01 409 00 Other Contracted Repairs Maint 0 0 3,200 500 500
601 49418 01 439 00 Other Miscellaneous Charges 0 0 75 200 200 Contingencies
601 49418 01 530 00 Improvements Other Than Bides 0 0 0 300 300
3,629 3,729 6,796 6,000 6,000
715,115 947,079 1,186,089 1,258,400 1,832,100
SEWER OPERATING FUND
This is an Enterprise Fund consisting of revenues from sewer charges which provides for the
operation and maintenance of 8 lift stations, over 70 miles of sanitary sewer lines and over 5,555
service connections for the collection and treatment of sewage. $732,000 covers one line item of
the Sever Fund budget for the charges paid to the Metropolitan Council for the City's share of the
operations and debt for wastewater treatment plants within the metropolitan area These charges,
which make up approximately 50''0 of the Sewer Fund budget, are based on sewage Mows into the
Metropolitan Council's Rosemount and Empire treatment plants
Page One
August 7, 2006
Account
2007 BUDGET WORKSHEETS
SEWER UflUTY
REVENUES
Description
2006 2007 Object 2007
2003 2004 2005 Adopted Detail Proposed
Actual Actual Actual Budge! Amount Bucget
602 33425 00 Other State Grants Aids 930 0 0 0 0
602 34108 00 Administrative ees-Other Funds 87,127 18,103 18,595 17,000 5,000 5% of 5% Fees -Const Projects
802 36101 00 Principal Special Assessments 64,803 49,669 44,888 40,000 40 000
602 36132 00 Penalties Interest SiA 7,029 (1,496) 2,077 0 0
6C2 36210 00 Interest Earnings Investments 69 345 73,386 98 5 80,000 90 000
502 36214 00 Net Change in FV- Investments (18,017) (1,438) (18 832) 0 0 Annual Markel Value Changes
602 36215 00 Interest Earrings 490 476 273 600 600
602 36260 00 Other Revenues 0 0 0 0 0
602 36265 00 Use of Reserve Funds 0 0 0 235 400 166 900
602 37210 00 Reslcentiai Sewer Revenues 972,190 970,562 1,011,697 900,000 1,000 000
602 37220 00 Apartment Sewer Revenues 45,720 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,689 50,547 52,136 55,000 55 000
602 37240 00 Industral 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 G0 Gain or Loss frcm FA 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,457,500
Comments
Page One
August 7, 2006
Account it
502 49450 101 00 Salaries Benefits
602 4 9450 77 ^01 00 Administrative
602 49450 79 1 01 00 Technical /Clerical
602 49450 79 101 OC Maintenance
602 49450 1 02 00 Full -Time Overtime
602 49450 103 00 Part-Time Salanes Benefits
602 49450 99 103 01 Utility Commission Wages (50
602 49450 99 103 C2 Maintenance Lanai
602 49450 01 203 00 Pr nted Forms Paper
602 49450 01 209 00 Omer Office Supplies
602 49450 01 216 00 Chemicals Chemical Products
602 49450 01 219 00 Other Operating Supplies
602 49450 01 224 00 Street Maintenance Matenals
602 49450 01 225 00 Landscaping Materials
602 49450 01 227 00 Utility System Maintenance Supplies
602 49450 01 241 00 Small Tools
602 49450 01 242 00 Minor Equipment
602 49450 01 303 00 Engineering Fees
602 49450 01 303 01 GIS Update of Ashuilts
602 49450 01 303 02 Rate Study
602 49450 01 303 03 42 Sewer Study
602 49450 0 304 00 Legal Fees
602 49450 01 312 00 Gopher State One -Cali
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
602 49450 01 319 02 Root Control
602 49450 01 319 03 Supervisory Controls(Maint Cont)
602 49450 01 319 04
602 49450 01 321 00
602 49450 01 322 00
602 49450 01 323 00
602 49450 01 331 00
602 49450 01 333 00
602 49450 01 341 00
602 49450 01 349 00
602 49450 01 365 00
602 49450 01 369 00
602 49450 01 391 00
602 49450 01 392 00
602 49450 01 393 00
602 49450 01 394 00
602 49450 01 395 00
602 49450 01 403 00 Contracted R M Other Impr
602 49450 01 415 00 Omer Equipment Rental
602 49450 01 416 00 Machinery Rental
602 49450 01 433 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
602 49450 01 521 00 Building Structure Purchases
602 49450 01 530 00 Improvements Other Than Trigs
602 49450 0 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 06 Crash Attenuator
602 49450 01 530 07 Crane Box for Pickup #342
602 49450 01 540 00 Heavy Machinery Purchases
602 49450 01 560 00 Furniture Fixture Purchases
602 49450 01 570 00 Office Equipment Purchases
602 49450 01 602 00 Sewer Service Charges
602 49450 01 611 00 Interest on Lease Payments
602 49450 01 710 00 Transfers
2007 BUDGET WORKSHEETS
SEWER UTILITY
EXPENDITURES
2006
2003 2004 2005 Adopted
Descnption Actual Actual Actual Budget
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 Software Purchases
P C Repairs
602 49450 -01 TOTALS
5222,228
10,444
14,496
1,385
0
0
0
33
1 35
1,82
54
4,18
8,90
16
4,34
6,00
10,77
43
2,81
64
4,08
9,17
50
2,13
1,31
131
0
15,667
81,215 89,591
113,591 108,348
118,556 122 362
7,178 12,674
19,545 9,289
1,50 2,10
11
2,66
33
1,51
25
2 24
4 43
15,50
80
3,00
2,43
43
3,04
54
5,4
9,26
33
8
1,06
12
1 94
14,26
0
0
0
510,640 546,45
5,419 5,19
0 18 35
839,964 981,43
31
15
64
10,06
15
4,76
20,03
21,06
6,00
3,50
1,40
61
49
3,23
55
4,81
9,34
29
17
1,30
12
108,59
82,25
40,19
28
597,24
4,94
185 98
1,432,73
98,000
164,900
15 ",500
10,000
15,000
1,500
200
500
200
2,500
400
1,500
500
3,000
7,000
0
15 000
500
5,000
1,409,800
0
3 000
2,000
3,000
0
600
3,000
1,000
1,000
100
300
500
4,500
12,000
300
200
4,000
2 500
500
2,000
200
2 000
500
300
2,000
100
2007 Object 2007
Detail Proposed
Amount Budget
101,600
145,400
129 100
1,000
14,000
7,000
0
15,000
0
3,000
2,000
3,000
0
All Salary Costs Inclus,ve of
5375,100 Salary Taxes PERA 8enents
10 000
15 000
1,500
200
500
200
2 500
400
1,500
500
6,000
22,000
1,430,900
Comments
50% 502 50% 601
100% b02
Inserts Water Bill Statements
Disks, Rlobons etc
Root Killer Degreaser
Patching
Topsoil, Seed Sod
Manhole Castings
Wrenches Shovels, etc
Jetter Attachment
500
7,000 Gopher State One -Call (M)
0
9,000 9,000 Contracted Engineer nor Cdy(20
8,000
2,000
200
2,000
500
300
2 000
100
SCADA System
0
3,000 Billings with Inserts
1,000 Replace'Repair Radios Phones
1,000 National Conference
100 Mail -in Repairs
300 P/T'ers 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
Reference Matenals
MPCA School Miscellaneous
Contrngencies
10,000 10,000 Pymt on P W Budding (8 of 20)
190 000
20,000 20,000
20 000 20 000
100,000 100 000 Annual Pavement Management
22 500 15 000 1/3 of Total Estimated Cost
25 000 12,500 50% of Total Estimated Cost
6,500 6,500 50% of Total Estimated Cost
0 16,000 1i3 of Total Estimated Cost
0 0
500 500
500 500
673 000 732,000 MWCC Charges
0 0 P W Budding Exoansion(See 521)
0 0 Transfers for Other Improvements
Page Two
August 7, 2006
2007 BUDGET WORKSHEETS
SEWER UTILITY
EXPENDITURES-
2006 2007 Object 2007
2003 2004 2005 Ado oted Detail Proposed
Account Description Actual Actual Actual Budget Amount Budget
602 49451 01 219 00 Other Operatng Supplies 0 0 0 100 100
602 49451 01 221 CO Ecuipment Parts 0 1,302 2,764 500 500
6C2 49451 01 229 00 Other Maintenance Supplies 0 0 0 200 200
602 49451 01 32' 00 Telephone Costs 211 211 211 300 300
602 49451 C1 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
(City Hall) TOTAL LIFT STATION #1 749 2,090 3,540 2,200 2,200
602 49452 01 219 00 Other Operating Supplies 0 0 0 100 100
602 49452 01 221 00 Equipment Pars 0 5,344 0 500 500
602 49452 01 229 00 Other Maintenance Supplies 0 0 0 200 200
602 49452 01 321 00 Telephone Casts 211 211 211 300 300
602 49452 01 381 00 Electric Unhhes 26 289 377 ',000 1 000
602 49452 01 403 00 Contracted R 8 M Other Impr 0 0 0 200 200
602 49452 01 439 00 Other Miscellaneous Charges 0 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 8. 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,162 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 Electric 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
802 49454 01 439 00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies
(Country Hills) TOTAL LIFT STATION #4
(LeForet Add'n) TOTAL LIFT STATION #5
602 49456 01 219 00 Other Operating Supplies
602 49456 01 221 00 Equipment Parts
602 4945E 01 229 00 Other Maintenance Supplies
602 49456 01 321 00 Telephone Costs
602 49456 01 381 00 Electric Utilities
602 49456 01 403 00 Contracted R M Other Impr
602 49456 01 439 00 Other Miscellaneous Charges
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 300 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 8 M Other Impr 0 0 0 200 200
602 49455 01 439 00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies
3,34
9
11,692 4 228
0 0 100 100
134 700 500 500
O 0 200 200
189 169 300 300
794 709 800 800
4,900 4,900
O 0 200 200
O 0 100 100 Contingences
(Drumcliffe) TOTAL LIFT STATION #6 95 1 097 1,578 2,200 2,200
Comments
Page Three
August 7, 2006
2007 BUDGET WORKSHEETS
SEWER UTILITY
EXPENCITURES
2006 2007 Object 2007
2003 2004 2005 Adopted Detail Proposed
Account Description Actual Actual Acual Budget Amount Budget
602 49457 01 219 OC Other Operating Supplies
602 49457 01 221 00 Equipment Parts
602 49457 01 229 CO Other Maintenance Supplies
602 43457 01 321 03 Telephone Costs
602 49457 31 38" 00 Electric Uti.ities
602 49457 01 403 00 Contracted R M Other Impr
602 49457 01 439 00 Other Miscellaneous Charges
(Glendalougn 5111) TOTAL LIFT STATION #9
602 49458 01 219 00 Other Operating Supplies
602 48458 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 0' 403 CO Contracted R M Other Impr
602 49458 01 439 00 Other Miscellaneous Charges
(Meadows of
(Bloomfield)
TOTAL LIFT STATION #8
602 49460 01 219 00 Other Operating Supplies
602 49460 01 221 00 Equipment Parts
602 49460 01 229 00 Otner Maintenance Supplies
602 49460 0' 321 00 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
220
0
0
100
500
200
300
800
200
100
2,200
2,200
2200
851,400 1,015,529 1,461,504 1,432,000 1,457,500
Contingencies
100
500
200
300
800
200
100 Contingencies
100
500
200
300
800
200
100 Contingencies
Comments
STORM WATER OPERATING FUND
This is an Enterprise Fund consisting of revenues from storm water utility charges that provides for
the operation and maintenance of the City's storm water facihues, which includes.
5 hft stations
more than 1,900 catch basins
more than 50 miles of storm sewer
mote than 65 storm water treatment ponds
This fund pays for cleaning storm dram sumps m manholes and catch basins and for ditching in
rural areas It funds wetland investigations and the assimilation of a wetland inventors- for the City.
Most of the remaining operating budget is used to pay for Large projects in which debt is issued
Repayment of this debt is accomplished through fund transfers to the appropriate debt service
funds.
Page One
August 7, 2006
2007 BUDGET WORKSHEETS
STORM WATER UTILITY
REVENUES-
2006 2007 Object 2007
2003 2004 2005 Adooted Doted Proposed
Account Descrp4cn Actual Actual Actual Budget Amount 3Age
603 34108 00 Admimstrauve Fees -Other F unds $87,127 $18,103 $16,595 $17,000 $5,000 5% of 5% Fees-Const Projects
603 36101 00 Prlrcpal- Special Assessments 48,032 22,844 8,111 30,000 30000
6033510200 Penalies Interest- S/A 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 Cnange :n FV- Invesments (8,187) 1,140 (6 472) 0 0 Annual Menet Value Changes
603 36215 00 Interest Earnings 514 382 183 500 500
603 36250 00 Other Revenues 0 0 0 0 0
603 36265 00 Use of Reserve Funds 0 0 0 0 22200
603 37300 00 Storm Water Utility Revenues 522,250 583,636 624,529 636 500 660 000
603 37360 00 Penalties Storm Wate' Utility 2,183 4,432 2,959 4,000 4 000
603 39203 00 Transfer From 0 0 47,845 0 0
FUND TOTALS
701,391 680,031 753,103 748,000 781,700
Comments
Page One
August 7, 2006
Account
6034950C 101 00
603 49500 7710100
60349500'3101 00
603 49500 79 101 00
603 49500 10200
803 49500 01203 00
603 49500 01 204 00
603 49500 01 205 00
603 49500 01 208 00
603 49500 01 215 00
60349500012
603 49500 01 221 00
603 49500 01 224 00
603 49500 01 225 30
603 49500 01 225 01
603 49500 01 225 02
603 49500 01 225 03
603 49500 01 226 00
603 49500 01 230 00
603 49500 01 241 00
603 49500 01 242 00
603 49500 01 303 00
603 49500 01 303 01
603 49500 01 303 02
603 49500 01 303 03
603 49500 01 304 00
603 49500 01 310 00
603 49500 01 312 00
603 49500 0131300
603 49500 01 313 01
603 49500 01315 00
603 49500 01 318 00
603 49500 01 319 00
603 49500 01 322 00
603 49500 01 323 00
603 49500 01 331 00
603 49500 01 352 00
603 49500 01 365 00
603 49500 01 369 00
603 49500 01 384 00
603 49500 D1 389 00
603 49500 01 391 00
603 49500 01 393 00
603 49500 01 394 00
2007 BUDGET WORKSHEETS
STORM WATER UT'LITY
EXPENCITURES
Description
Salaries 3 Benefits
Administrative
7ec't ricaJCler cal
Maintenance
Full -Time Overtime
Printed Forms Paper
Envelopes Letterhead
Drafting Supp'ies
Miscellaneous Supplies
Shop Mater ais
ONer Operatng Supplies
Equipment Parts
Street Maintenance Materials
Landscaping Materials
Rip -Rap Matting, Rock, etc
Black Dirt Seel Soo, etc
Sign Repair Materials
Equipment Repair Material
Small Tools
Minor Equipment
Engineerng Fees
Problem Area Investigations
NPDES Phase II
CSMP Update
Legal Fees
Testing Seances
Contract Inspection Fees
Temporary Service Fees
Temporary Service Fees
Special Programs (County Program)
Contract Engineer
Other Professional Services
Postage Costs
Radio Units
Travel Expense
General Notices 8 Public Info
Workers Comp Insurance
Other Insurance
Refuse Disposal
Other Utility Services
P C Maintenance
P C Hardware Purchases
P C Software Purchases
603 49500 01 403 00 Contracted R 8 M Other Impr
603 49500 01 403 01 Ditching
603 49500 01 403 02 Miscellaneous Repays
603 49500 01 404 00 Contracted Mach 8 Equip Repays
603 49500 01 416 00 Machinery Rental
603 49500 01 433 00 Dues 8 Subscriptions
603 49500 01 435 00 Books 8 Pamphlets
603 49500 01 437 00 Conferences 8 Seminars
603 49500 01 437 01 Stonn 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 Bidgs
603 49500 01 530 01 CRP of Storm Sewer
603 49500 01 530 02 Crash Attenuator
603 49500 01 530 33 Replace Pickup 4344
603 49500 01 530 04 Crane 8 Box for Pickup 4342
603 49500 01 540 00 Heavy Machinery Purchases
603 49500 01 560 0C Furniture Fixture Purchases
503 49500 01 580 00 Other Equipment Purchases
803 49500 01 586 00 Computer Equipment Purchases
603 49500 01 710 00
603 49500 01 710 01
603 49500 01 710 02
603 49500 01 710 03
603 49500 01 710 04
603 49500 01 710 05
603 49500 01 710 06
603 49500 01 710 07
603 49500 01 710 10
Transfers
1'2 of 2007 P 8 I Payments(1996B)
1/2 of 2007 P 81 Payments(1999C)
1/2 of 2007 P 8 I Payments(20015)
1/2 of 2007 P 1 Paymentsl20010)
112 of 2007 P 8 I Paymenis(20029)
1/2 of 2007 P 8 I Payments(2002C)
1/2 of 2007 P 8 I Payments(2003A)
Protects
803- 49500.01 TOTALS
2003
Actual
$161,193
9,82
1,38
18
2,20
541
60,944
54
6,00
2,81
23
29
2 ea
5,43
2,13
0
0
101
0
6,160
131
0
0
0
0
270,000
0
2004 2005
Actual Actual
6415
59,27
4,38
1,50
22
14
2,08
6,03
33
8
31
3,26
25,98
45
17
53
3,85
3,00
5,63
3 04
61
0
149
0
0
101
179
72,807 1,391
335 24
0
0
126 12
0 0
60 657 97 600
70,57 80,000
6,93 10,000
151 91
40,19
74
19
191
332
0
0
668
156
0
42,41
2,52
27
14 04
3,65
6,00
3,23
40
1,81
5,07
29
10
2006 2007 Object 2007
Adopted Detail Proposed
Budge' 4 mocnl Budget Comments
All Salary Costs Incicsae of
5149000 Smar, Taxes PEPA 8 Benefits
1,500 1 500
0 0
200 200 Paper Pens 3 Peproauc4on
200 200 Stakes, Ribocns Levet erg
200 200
500 500
500 500 Filters Hoses, Lights, etc
2 000 2,000 Blacktop Gravel `Washouts
4 000
3,000
1,000
0
500
1200
1200
0
10 000
10 000
0
2,000
1,000
500
0
5,000
9,000
0
3 000
1,200
200
1 000
3 500
6,000
600
500
300
4,000
2,500
1,000
500
500
0
100 00
6 50
50
2,00
50
d4 400
64 600
3 000
1,000
0
10,000
30,000
30 000
1,000
500
500
100 000
6 500
15,000
16 000
51 000 50,000 50,000 52 000
41 000 42,000 41,000 43 000
54000 53,000 54,000 53000
77,000 75 000 77,000 75 000
17,000 19,000 29 000 29 000
26 000 26,000 26,000 25,000
43 000 44 000 44,000 44,000
95670 80,797 0 0
0
0
10 000
500
1,000
1,000
C
70 000
5,000
9,000
0
3,000
1200
200
1,000
3,500
6,000
600
500
300
4,000
2,500
15 000
5,000 5,000
10,000 10,000
1 000 1 000
5 000 5 000
20,000 0
1,000 1 000
2,000
2,000
1200 Water Quality Tests (MI
500 3rd Part Inspection Program (M)
0
0
137,500
0
500
2 000
500
321 000
605,802 592,068 802 749 734,000 766,400
Advance Warnng 3 gn Rental
Due to Breakdowns
Shovels Rakes Picks etc
Wetland Heaeh 8 Evaluation Pro)
Contracted Engineer for C4y(20
Billings 81nfo Mailings
Replacements 8 Repairs
Public Info Brochure
Storm Waters Share of Premiums
Storm Water's Share of Premiums
Roadside Debris
Hazardous Materials Disposal
Auto Read Software Support
Laptops
Repairs Sent Out
Backhoe Lowboy Pumps, etc
Utility Information
Annual Pavement Management
50% of Total Estimated Cost
1/3 of Total Eshmalec Cost
1/3 of Total Estimated Cost
Storm Share of WatenStorm Issue
Storm Share of Hwy 3 Protect
Storm Share of Connemara Pro)
Page Two
August 7 2006
2007 BUDGET WORKSHEETS
STORM WATER UTILITY
EXPENDITURES
2006 2007 Object 2007
2003 2004 2005 Adopted Detail Proposed
Account Descnpton Actual Actual Actual Budget Amount Budge*
603 49511 01 221 00 Equipment Parts 0 0 0 500 500
603 49511 01 321 00 Teiepnore Costs 211 211 211 300 300
603 49511 01 381 00 Electric Utilities 183 167 210 500 500
(Copper Pond) TOTAL LIFT STATION #1 394 378 421 1 300 1,300
603 49512 01 22* 00 Equipment Parts 0 0 0 500 500
603 49512 01 321 00 Telephone Costs 211 211 211 300 300
603 49512 01 381 CO Elect!' c Utilities 0 0 0 500 500
(Schwarz Pond) TOTAL LIFT STATION #2 211 211 211 1,300 1,300
603 49513 01 221 00 Egwpment Parts 581 216 350 500 500
603 49513 01 321 00 Telephone Costs 422 422 422 300 300
803 49513 01 381 00 Electric Utilities 2,834 3,374 5 151 5 000 5,000
(Birger Pond) TOTAL LIFT STATION #3 3,836 4,011 5,922 5,800 5,800
603 49514 01 221 00 Equipment Parts 0 0 0 500 500
603 49514 01 321 00 Telephone Costs 211 42 42 300 300
603 49514 01 381 00 Electric Utilities 3,098 198 177 3,500 3,500
(Marcotte Pond) TOTAL LIFT STATION #4 3,309 241 220 4,300 4,300
603 49515 01 221 00 Equipment Parts 0 0 0 500 500
603 49515 01 321 00 Telephone Costs 0 0 0 300 300
603 49515 01 381 00 Electric Utilities 0 0 0 500 500
(Hawkins Pond) TOTAL LIFT STATION #5 0 0 0 1,300 1,300
Comments
803 49516 01 221 00 Equipment Parts 0 0 0 0 500
603 49516 01 321 00 Telephone Costs 0 0 0 0 300
603 49516 01 381 00 Electric Utilities 0 0 0 0 500
(Glendalough 7th) TOTAL LIFT STATION #6 0 0 0 0 1,300
GRAND TOTAL ALL DEPTS
513 552 596,908 809,523 748,000 781,700
ADMINISTRATION
MAINTENANCE
ICE ARENA
The Parks and Recreation Department administer the Ice Arena. Scheduling and
invoicing of ice are the main administrative duties of ice arena operations 1 he
scheduling of prime time ice is coordinated vkith Independent School District #196
and Rosemount Area Hockey Association for pracuces, games and tournament play.
The Parks and Recreation Department provides overall planiung, coordination,
management of personnel and administration of ice arena activities.
COMMUNITY USE
Provides recreational open skating for the residents of Rosemount as well as learning
to skate and figure skating programs
Provides ongoing and preventative maintenance of the ice arena butldmg structure
and its mechanical components Ensures ice is maintained at optimal efficiency
Page One
October 11, 2006
2007 BUDGET WORKSHEETS
ARENA REVENUES
2006 2007 Object 2007
2003 2004 2005 Adopted Detail Proposed
Account Descripuan Actual Actual Actual Budget Amount Budget
650 31010 00 Current Ad Valorem Taxes 50 $0 $0 $0 $0
6503621000 Interest Earnings Investments 385 103 243 200 0
650 362'5 00 Interest Earmngs 120 109 76 200 200
850 3b260 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
65C 38061 00 Non -Prime T Ice Fees 0 0 45,571 0 50 000
650 38063 CO Open Skating Ice Fees 7,998 8 244 8 973 7 000 9 00C
650 33064 00 Breen Revenues 0 0 0 0 6 000
650 38065 30 Other Events Arena 0 0 0 500 0 Dry Floor Events
65C 38066 00 Advertising Reverue Arena 6,970 18,200 11,650 14,000 14 000
65038067 CO Skate Sharpening Revenue Arena 4 362 5,244 4,817 4,000 5 000
650 38090 00 Concessions 3 300 3224 3 900 3,500 3 900
850 38091 00 Vending Machine Revenues 12,839 10,761 10,425 12,000 12,000
650 36095 00 Pro Shop Revenues 1,440 1,409 1,133 1,100 1 100 Tape, Laces, Mouthguards, etc
850 39103 00 Gan or Loss from PA 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
Comments
Page One
Octooer 11, 2006
Account k
2007 BUDGET WORKSHEETS
ARENA EXPENDITURES
Description
550 45130 101 CO Salaries Bene its
650 45130 77 101 00 Acmin strahve
650 45130 78 101 00 Technical/Clerical
650 45130 79 101 00 Maintenance
650 45130 79 102 C0 Full -Time Overtime
65C 45130 103 00 Part-Time Salaries Benefits
650 45130 59 103 00 Learn -To -Skate Program
650 45130 99 103 00 Building Skate Guard Attendants
650 45130 01 207 00 Training Instructional Supplies
650 45130 01 208 00 Miscellaneous Supples
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 00 Cleaning Supplies
650 45130 01 212 00 Motor Fuels
650 45130 01 216 GO Chemicals Chemical Products
650 45 01 219 00 Other Operating Supplies
650 45130 01 221 00 Equipment Pars
650 45130 01 223 00 Building Repair Supplies
650 45130 01 241 00 Small Tools
650 45130 31 242 00 Minor Equipment
650 45130 01 265 00 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 D0 Telephone Costs
650 45130 01 331 00 Travel Expense
650 45130 01 341 00 Employment Advertising
650 45130 01 349 DO Other Advertising
650 45130 01 365 00 Workers Comp Insurance
650 45130 01 369 00 Other Insurance
650 45130 01 381 00 Electric Utilities
650 45130 01 383 00 Gas Uh60es
850 45130 01 384 00 Refuse Disposal
650 45130 01 401 00 Contracted Building Repairs
650 45130 01 404 0D Contracted Mach Equip Repairs
650 45130 01 415 00 Other Equipment Rental
650 45130 01 433 00 Dues Subscriptions
650 45130 01 437 CO Conferences Seminars
650 45130 01 439 00 Other Miscellaneous Charges
650 45130 01 521 00 Building Structure Purchases
650 45130 01 580 00 Other Equipment Purchases
650 45130 01 710 00 Transfers
650 45130 01 710 01 Yearly Maintenance
650 45130 01 710 02
650 45130 01 710 03
FUND TOTALS
2003 2004
Actual Actual
$106,672
2006 2007 Object 2007
2005 Adopted Detail Proposed
Actual Budget Amount Bucget
10,665 12,281 32.500 33,600
42,316 44,193 26,300 26,900
69,357 87 352 94 800 97,100
3,565 4,48 4,642 4,000
36,120
24,48 25,290 24,000 25,000
7,79 15,245 15,000 15,000
4 000
40 000
0 0 200 200
0 15 1 000
234 200 200
0 800 800
25 31 110 500 500 Learn to Skate Program Supplies
3,83 3,05 3,139 3,500 3 500
1,03 2,323 2,400 2 400 Battery 'or Maintenance
3,58 2,39 2,483 3 200 3 200 Assorted Products
30 16 29 1,000 1,000 Events Sup olies
2 08 1,55 1,600 4,000 4 000
1,77 1,47 535 4,000 4 000
0 0 0
O 0 0
81 78 662 600 800 Pro Shop Supplies
0 500 500
O 0 2400 Brccmball Leagues Referees
6,00 8,00 8,000 6,000 6,000 Yearly Fee Per Admin Fee Pclicv
1,00 1,00 1,000 1,000 1,000
0 100 100
0 500 500
93 800 800
2,30 2,55 2,091 2,000 2 000
8,32 6,43 6,552 13,000 13 000
84,161 87,05 101,374 85,000 87 000
23,465 26,82 34,957 33,000 33 000
2,940 2,94 2,881 3,500 3 500
5,702 3,97 6,212 5,000 5 000
8,951 4,18 26,933 10,000 10 000
0 0 300 300
453 50 592 900 900 MIAMA Dues
O 24 0 400 400 MIAMA Seminars
O 0 500 500 Contingencies
7,208 25,49 0 32,000 47,000 Paint Ceiling and Duct Work
0 0 8,000 0
14,458 3 500
3,500 3,500 3,500 3,500
7,400 7,800 0 0
3 600 3 200 0 0
320,292 351,735 403,301 421,200 439,500
Comments
All Salary Costs Inclusive of
$157,600 Salary, Taxes 'ERA Benefits
RENEWAL FORMULA.
For Coverage Year January 1 December 31, 2007
Membership of the Minnesota Cities /Counties /Other Governmental Units' Group Insurance Pool has elected a nine-
member Executive Committee. The purpose of the Committee is to respond to the needs of the pool membership; to
request and review data, to advise and to make recommendations to the pool members, to administration and to the
Appletree Institute Board of Directors; and to act on behalf of the pool membership m the interim of annual meetings.
In Executive Committee session on August 8, 2006, the following formula was approved by Committee members for
presentation to pool membership. This formula proposes the renewal rate increases which will be apphed to rates for
member units purchasing health /hospitalization insurance for the coverage year beginning January 1, 2007.
If Needed Increase is less than (10.00)% Give 6.90% Increase
1- If Needed Increase is less than 1 00% Give 7.50% Increase
If Needed Increase is less than 6 00% Give 8.00% Increase
If Needed Increase is less than 9.20% Give 9.10% Increase
If Needed Increase is less than 10.00% Give 10.00% Increase
If Needed Increase is less than 13.00% Give Actual
Renewal Formula for January 1— December 31, 2007
Renewal Rate Increase for
CITY OF ROSEMOUNT
Group Number C1017
e4ric,tvr al- 1
HANDOUT 7
If Needed Increase is less than 15.00% Give 13 00% Increase
If Needed Increase is less than 16.00% Give 15.00% Increase
If Needed Increase is less than 18 00% Give 16.00% Increase
If Needed Increase is less than 20 00% Give 17.75% Increase
If Needed Increase is less than 25 00% Give 20 00% Increase
If Needed Increase is less than 30.00% Give 24.00% Increase
If Needed Increase is 34 00% or more Give 32 50% Increase
1/1/07 Needed Increase as Identified by Carrier (0.50)%
1/1/07 Adjustment Due to High Cases (020)%
1/1/07 Actual Increase Applied According to Formula 7.50%
Premmms
Single
Family
(11 Remiss surgery fells has separaie out of pocket limit
Premium' tropkiyee
Change from CurrentVESA Net
Man Name out efPeclkef Renewal rultleig Exposure
Current
Single $1,200 50 $530 $670
Family $2,400 so $530 11,870
Renewal
Single 51,200 000 8805 5395
Family $2,400 520790 51,205 11,403
Pre errarOne Option la
Lumen/
$316 50
$972 50
$340 00
51,045 50
Single 11,200 000 1000 8400
Family $2,400 19462 04) 1800 11,138
$278 95
$857 13
City ofRosembt1Rt CUrtenVRefievtart
Prefer{adOM DPtian tar 11150)
Plan Design Summary
In- Network f Out -of- Network
in- Network
Odt -of- Network
Lifetime Maximum
5 million
Unlimited
1,000000
Annual Deductible (1)
$1,2001$2,400 I $1,200/$2 400
$1,200
$2,4000
Annual Out -of- Pocket Maximum
$1200 $2 400
$3,500 $6,500
$1,200 $2400
$3,500/$7,500
Office Visits Physician
100% after deductible
80% after deductible
100% after deductible
80% after deductible
Allergy injections
100% after deductible
80% after deductible
100%
B0 after deductible
Office Visits Specialists
100% after deductible
80% after deductible
100% after deductible
80% after deductible
Preventive Care
Routine physicals
100% to a rnax of $350
80% after deductible
100%
Not Covered
Routine cancer screening
100%
100%
100%
Not Covered
Routine hearing exams
100%
80% after deductible
100%
Not Covered
Lab and x -ray
100%
80% after deductible
100%
Not Covered
Immunizations
100%
B0% after deductible
100%
Not Covered
Routine vision exams
100% to a max of $350
100% to a max of $35C
100%
Not Covered
Well -child care(up to age 18)
100%
80% after deductible
100%
Not Covered
Immunizaticns(up to age 18)
100%
80% after deductible
100%
Not Covered
Prenatal care
100%
80% after deductible
100%
80% after deductible
Hospital Outpatient
100% after deductible
80% after deductible
100% after deductible
80% after deductible
Hospital Inpatient
100% after deductible
80% after deductible
100% after deductible
80% after deductible
Mental Health /Chem Dep Outpatient
100% after deductible
80% after deductible
1 D0% after deductible
80% after deductible
Mental Health /Chem Dep Inpatient
100% after deductible
80% after deductible
100% after deductible
80% after deductible
Emergency Room Care
Emergency room
100% after deductible
100% after deductible
100% after deductible
100% after deductible
Physician services
100% after deductible
80% after deductible
100% after deductible
100% after deductible
Rehabilitative care
Physical, occupational, and speech therapy
100 after deductible
80% after deductible
100% after deductible
80% after deductible
Chiropractic care
100% after deductible
80% after deductible
100°k after deductible
80% after deductible (15
Medical equipment and supplies
100% aftei deductible
80% after deductible
100% after deductible
80% after deductible
Retail Prescription Drugs 30 days)
Generic
1 DO% after deductible
100% after deductible
100% after deductible
60%
Brand Formulary
100% after deductible
100% after deductible
100% after deductible
60%
Brand Non- Formulary
100% after deductible
100% after deductible
100% after deductible
60%
Mail Order Prescription Drugs 90 days)
Generic
100% after deductible
100% after deductible
100% after deductible
N/A
Brand Formulary
100% after deductible
100% after deductible
100% after deductible
N/A
Brand Non- Formulary
100% after deductible
100% after deductible
100% after deductible
N/A
Premmms
Single
Family
(11 Remiss surgery fells has separaie out of pocket limit
Premium' tropkiyee
Change from CurrentVESA Net
Man Name out efPeclkef Renewal rultleig Exposure
Current
Single $1,200 50 $530 $670
Family $2,400 so $530 11,870
Renewal
Single 51,200 000 8805 5395
Family $2,400 520790 51,205 11,403
Pre errarOne Option la
Lumen/
$316 50
$972 50
$340 00
51,045 50
Single 11,200 000 1000 8400
Family $2,400 19462 04) 1800 11,138
$278 95
$857 13
Cost Comparison of Preferred One to SWSC Renewal
4r a-3
2006 Current
2006 Current
1
2007 Renewal
1
Employee Monthly Cost
Preferred One
1
Enrollment (As of 9!2006)
0.00 $208 42
Employer Monthly Cost
$316 50 $742.90
$340 00 $798 58
$287 30 $674 37
Single
$44 17 $44 17
49
49
Coop VEBA Contribution
49
Family
30
30
$33,725
30
Employee Annual Cost
Total
79
79
Employer Annual Total Cost
79
Monthly Costs
$479,645
Single Family
Single Family
$487, 407
Single Family
Premium
$41,870
$316.50 $972 50
$340 00 $1,045
50
$287 30 $882 79
Change
2nd year cap of 15%
7.5%
-15.5%
Annual Cost
$536,202
$576,300
$486,737
Cost Comparison of Preferred One to SWSC Renewal
4r a-3
2006 Current
2007 Renewal
Preferred One
Employee Monthly Cost
0 00 $229 60
0 00 $246 93
0.00 $208 42
Employer Monthly Cost
$316 50 $742.90
$340 00 $798 58
$287 30 $674 37
Employer Monthly VEBA Cost
$44 17 $44 17
$44 17 $44 17
$66 67 $66 67
Coop VEBA Contribution
$0.00 $0.00
$22 92 $56 25
Coop Annual VEBA Dollars
$0
$33,725
Employee Annual Cost
$82,656
$88,893
$75,032
Employer Annual Total Cost
$495,416
$529,277
$479,645
Employer Premium Costs
$453, 546
$487, 407
$411,705
Employer VEBA Costs
$41,870
$41,870
$67,940
Rate Guarantee
N/A
12 months
2nd year cap of 15%
Cost Comparison of Preferred One to SWSC Renewal
4r a-3
2006 Current
From Current
From Renewal
Shared Cost Ratio
Employee Annual Change
Employer Annual Change
16.68%
16.80%
$6,237
$33, 861
15 64%
($13.861)
($49, 632)
Cost Comparison of Preferred One to SWSC Renewal
4r a-3
Remain in Appletree Co-op
Contracts
Premium
Employee
Employer Cost
City VEBA pay
Full Premium
Employee Cost
Employer Cost
Switch to PreferredOne
Option la
Contracts
Premium
Employee
Employer Cost
City VEBA pay
Full Premium
Employee Cost
Employer Cost
Switch to PreferredOne
Option la
Contracts
Premium
Employee
Employer Cost
City VEBA pay
Full Premium
Employee Cost
Employer Cost
Current
Single Family
49 30
$316 50 $972.50
$0 00 $229 60
$316.50 $742 90
$530 00 $530.00
$536,202
$82,656
$495,416
$536,202
$82,656
$495,416
Current
Single Family
49 30
5316 50 $972 50
50 00 $229 60
$316 50 $742 90
$536,202
$82,656
$495,416
Renewal
Single Family
49 30
$340 00 $1,045 50
$0.00 $246 93
$340 00 $798 58
5530 00 I $530.00
$576,300
$88 893
$529,277
Currenf 2
Single Family Sin Fart(
49 30 49 30
$316 50 $972 50 $287 30 $882 79
50.00 $229 60 $0 00 $208.42
$316 50 $742 90 $287 30 $674 37
$800 00 $800 00
$486,737
$75,032
$474,905
Full Premium
Employee Cost
Employer Cost
2007
Single Family
49 30
5287 30 $882.79
50.00 $208 42
$287 30 $674 37
5800 00 5800 00
$486,737
$75,032
$474,905
Full Premium
Employee Cost
Employer Cost
assume 750%
2048
Single Family
49 30
$365 50 $1,123 91
$0 00 $265 44
$365 50 $858 47
$530.00 I $530.00
The 7 5% increase from the co -op was based on the City of Rosemount
needng a rate decrease mdwdualy
assume i5.00%
2008
tn.le Parini
49
$330 40
$0 00
$330.40
$800 00
3 Year Difference
Total Per Contract
($171,616) ($2,172)
($26,632) ($337)
($80,993) (51,025)
Single
49
$301.67
$0 00
5301.67
5800 00
Total
($327.371)
($50.542)
(5212,739)
$619,523
$95,560
$565,833
$559,747
$86,287
$536,661
assume 500%
2008
$511,074
$78,783
$495,490
30
$1,015.21
$239 68
$775.52
$800.00
Fa mily
30
$926 93
$218 84
$708 09
$800.00
3 Year Difference
Per Contract
($4,144)
(5641)
($2,693)
,Jrr. -74
assume 750%
2009
Single Family
49 30
5392.91 $1,20821
50 00 $285 35
$392 91 5922 85
5530 00 I $530 00
$665,987
$102,727
$605,130
assume 15.00%
2009
Sin .(e Famt
49 30
$379.95 $1,167 49
SO 00 $275 64
$379 95 $891 85
$800 00 5800.00
$643,709
$99,229
$607,680
assume 5 00%
2009
Single Family
49 30
$31675 $97328
$000 $22978
5316.75 $74349
$80000 5800 00
$536,627
$82,722
$517,105
irrAelgeu 3
4 ROSEMOUNT
PUBLIC WORKS DEPARTMENT
M E M O R A N D U M
To: Honorable Mayor and City Council Members
Jamie Verbrugge, City Administrator
From: Andrew J. Brotzler, P.E., City Engineer
Date: October 5, 2006
Re: Pavement Management Program
In 2003, the City initiated the development of a pavement management program (PMP) as a
tool to efficiently and cost effectively maintain the City's street system. With the initial
development of the PMP, an average pavement condition index (PCI) of 75 was set for the
program. Based on this parameter, several funding scenarios were developed for a 20 -year
program. The funding scenario initially targeted by Council was a "Jump -Up" to $1.5
million per year with another `Jump -Up" to $3 million per year in 2020 as shown on the
attached Exhibit A This budget amount was used for the PMP in 2004 and 2005. This
budget amount for the PMP included $1,000,000 Street CIP Levy; $200,000 SKB Funds; and
the balance derived from special assessments.
During the 2006 budget preparation, the funding level and associated PCI parameter was
reviewed by Council. In September 2005, Council reviewed several scenarios for differing
PCI parameters and associated funding requirements. From this review, Council targeted
the establishment of the following new parameters for the PMP:
Local Streets Average Pavement Condmon Index (PCI) of 60
Collector Streets Average Pavement Condition Index (PCI) of 75
Based on these new parameters, the Street CIP Levy for PMP was reduced from $1,000,000
to $700,000 for the 2006 budget. This budget number of $700,000 has been carried forward
to the proposed 2007 budget.
The PMP has been updated with field raungs completed in 2006. Attached for Council
information is a map idennfvmg the PCI ranges for the City's street system. Also attached is
a full listing of the individual street segment PCI values.
Based on the current PCI values and parameters for the PMP, the attached budget report
has been run for Scenario: 75 Collector /60 Local. As shown on the attached budget
report.
No improvements are proposed for 2007 and 2008
The annual budget requirements fluctuate sigmificandy over the 20 -year penod
G \Pavement Managemcnc\101106.PNIP Council memo For 07 Budget doc
Throughout the 20 -year program, a higher percentage of budget dollars are spent on
reconstrucuon projects
The 20 -year total funding requirement is $33,120,000
The average weighted PCI is projected to drop to 66 by 2026
The 20 -year backlog is projected to be $22,746,670
For comparative purposes only, a second scenario has been run for Scenario: Average
Out. As shown on the attached budget report
The annual funding amount of $1,656,000 is a per year avenge of the 20 -year total
m Scenario: 75 Collector /60 Local
The average weighted PCI is projected to drop to 74 by 2026
At year 2014 thru 2026, 100°,1, of the annual funding amount is projected to be
allocated to maintenance operations consisting of seal coats and bituminous
overlays
The 20 -year backlog is projected to be $4,753,520
As there are a number of streets with a PCI of 35 or less that are candidates for
reconstruction, an option for Council consideration is to inmate a mule -year program to
reconstruct streets with a PCI of 35 or less. With this option, it is proposed to prepare a
feasibility report to evaluate the reconstrucuon of these identified streets The completion
of the report would occur after Council adoption of the 2007 budget with project
recommendations based on street prionnzatton and available funding. With this approach,
those select streets with a low PCI would be reconstructed, reducing future funding level
requirements.
The one street m specific that Public Works staff rates as a high priority for improvement is
Biscayne Way between Biscayne Avenue and 145 Street. This street is currently a rural
street section with ditches prone to flooding and a deteriorated sanitary sewer mainline.
Improvement to this street would include the replacement of the existing sanitary sewer and
water mains, along with the upgrade of the street to an urban section with storm sewer and
curb and gutter
Should Council concur with the above, Staff will present a resolution to Council at the next
Council meeting to authorize the preparauon of a feasibility report.
\Palemem Management 101106 PMP Council memo for 07 Budgecdoc 1
Exhereirr .4
a aoaoaoo 0aaora00000oaa
c+ n e�oscaotmmta�aarvsv ;AOOxa[t.r�saorrracomvf
rn2 co
o..n.r>mo�co oaav -nr us.t ;'O
3�jjL- .KL�.,-'I..oi uJ•al,=...:.. a a a�C>CQfV�'M'uifQm
-?G WMnronet'COo]'o f6coNaDtoOMaaNal:
.Nkarta C OQVCfk orm,-gotsgC ono CON
ca. a 'M.M.s t n mo.. Eg comoinvoi wdo 2.-• metawfinam
U
o des' 'Mgc nene awn
a00000ONaoaO0000O000Orn0
MNKNNMWOoMe OVMKNNNNN NMMN
G t T eu�o�o�0� 0 enc 0 0
oo ,iat 00000 ;0O0C000OOO
e*g..0 0.* *(COOo OO
e
OeNtOOQOMeNNOe000vONewM W
Q NNMMCM430eMNOOTIOMMMW00NNNee
O 0000 oo'O 000O00000
tote ir»s»wstennmotowuifir woom63fftr»
M
o.
a0000aooaoa0000000000a000
C oOOOOOo Oao0NOQCOO00000O00
OI' QOOOOOOOareO 00000gO000O
ae odoadoodoof0C7000O00000doo
N o 0000 0000a(.000doOo o O Oocoo
a+� waKYRe t00000N a 0gIngo
ooaoaa0000000000000
0 000 o 0 o 0 o000000 O 00000 O 0000 0 00 00 0
arcamotou �cculococoo000oOOOo
w,l renrre r. rs,�'r c' M to s MM n MM
ff3fl 4AHtH>Ci>4SSWiSHfAM U3SShc SS3
in
o cane O e M. er.:it NibAaOQAW Weer
O ■t�A A00. AAAAAAAAnAn
9
caRmSO -No 't'0(OAaQa0'NMt «CDna
00000. N N N N N N N N N
NNNNNNNNNNKNNNNNNMNNNNNNN
O
O
0
0
0
r-
re
is t Q F
r•
CPHCREWS RC
(CSAH JSI( 9
Al
5T W CR42
Legend
N o 35 Reconstruct
eV 36 60 Overlay
"V 61 90 Sealcoat
At 100 Do Nothing
_v Not Maintained by City
Not in PMP
45TH 5T E (C
142RC ST E
r
Current Pavement Condition Index (P(
4 ugust 2006
4 osemount, MN
9Nfe-it
G
Nit
sF
e
0. 3
ti
STREET PCI MAP
121ST ST
AKRON AVE END 100 1
124 CT
AKRON WEST 49 2
126TH ST
BISCAYNE BACARDI 48 3
127TH COURT
CHINCHILLA EAST END 29 4
128TH
BACARDI BENGAL 41 5
130TH
HWY 3 130TH WAY 99 6
130TH WAY
130TH BENGAL 40 7
131ST
DODD BLVD WEST END 98 8
133 RD CT
SHANNON WEST END 92 9
137TH COURT
137TH STREET SOUTH END 82 10
137TH STREET
DANUBE LANE SHANNON PARKWAY 82 11
138TH COURT
DIAMOND PATH E/N END 48 12
140TH ST
BLAINE AVE RAILROAD TRACKS 23
CSAH 42 CONLEY AVENUE 53 13
RAILROAD TRACKS HWY 52 23 14
1415T COURT
SHANNON PKWY END 84 15
143RD
SHANNON PKWY EAST LOT LINE 4086 100 16
143RD ST
CHILI AVE CANTATA AVE 82 17
SHANNON PARKWAY COBBLER AVE 56 19
ST HWY 3 WEST END 99 20
STREET PCI MAP
143RD STREET WEST
DAVENPORT AVENUE EAST LOT LINE 4173 98 21
EAST LOT LINE 4173 EAST LOT LINE 4086 99 22
WEST END DAVENPORT AVENUE 99 23
144TH ST
CAMEO AVE CANADA AVE 95 24
CANADA AVE CHILI AVE 88
CHILI AVE CIMARRON AVE 63 25
SHANNON PKWY COBBLER AVE 91 26
144TH STREET WEST
DEKALB AVENUE DAVENPORT AVENUE 99 27
145TH ST
CAMEO AVE HWY 3 91 28
CHIPPENDALE AVE CAMEO AVE 79 29
CIMMARRON AVE CHIPPENDALE AVE 88
DAIMOND PATH SHANNON PARKWAY 77 30
SHANNON PKWY CIMMARRON AVE 91 31
145TH STREET
337' EAST OF BLOOMFIELD PATH CSAH 42 100 32
BISCAYNE AVENUE BISCAYNE WAY 100 33
BISCAYNE WAY BLOOMFIELD PATH 100 34
BLOOMFIELD PATH 33T EAST 100 35
BURNLEY AVENUE EAST C/L OF RAILROAD TRACKS 94 36
EAST C/L OF RAILROAD TRACKS EAST DRIVEWAY C/L OF GRIEF 92 37
EAST DRIVEWAY C/L OF GRIEF EAST DRIVEWAY OF PEOPLES C/L 92 38
EAST DRIVEWAY OF PEOPLES C/L BISCAYNE AVENUE 100 39
T.H. 3 BURNLEY AVENUE 69 40
146TH ST
BURMA AVE BURNLEY AVE 89
CANADA AVE CAMEO AVE 100
CHIPPENDALE AVE CANADA AVE 100
41
DANBURY AVE DANVILLE AVE 100 43
ST HWY 3 BURMA AVE 97 44
STREET PCI MAP
147TH ST
CANADA AVE CHIPPENDALE AVE 100 45
CHIPPENDALE AVE CIMMARRON AVE 55 46
CRESTVIEW AVE COLORADO AVE 91 47
DANBURY AVE DAHOMEY 100 48
148TH ST
CANADA AVE CHILI AVE 100 49
CHIPPENDALE AVE CIMMARRON AVE 61 50
UNKNOWN UNKNOWN 100 404
149TH ST
CANADA AVE CHARLSTON AVE 100 51
CHORLEY AVE CHRYSLER AVE 30 52
CRESTVIEW AVE SHANNON PKWY 65 53
151ST COURT WEST
BISCAYNE AVENUE END 97 55
151ST ST
CARROUSEL WAY CANADA AVE 100 56
CHIPPENDALE AVE CANADA AVE 100 57
DANBURY AVE SHANNON PKWY 90 58
151ST STREET WEST
SHANNON PARKWAY CHIPPENDALE AVE 83 65
152ND CT
DANBURY AVENUE END 95 66
152ND ST
APPLE VALLEY LINE DANVILLE AVE 91 67
CLARET AVE CHIPPENDALE AVE 82 68
153RD ST
CHOKECHERRY AVE CLARET AVE 86 69
SHANNON PARKWAY CLARET AVENUE 94 71
154TH CT
DANBURY AVE END
154TH ST
CLARET AVE CHOKECHERRY AVE
CLARET AVENUE WEST END
155TH CT
155TH ST
AZALEA COURT
END
86 73
86 74
88 75
65 76
STREET PCI MAP
155TH ST
APPLE VALLEY BORDER DANBURY AVE 87 77
CHIPPENDALE AVE CLARET AVE 60 78
CLARET AVENUE SHANNON PARKWAY 74 79
156TH ST
CHIPPENDALE AVE CLARET AVE 39 80
CLARET AVE SHANNON PARKWAY 87 81
DARLING PATH DANVILLE AVE 83 82
157TH CT W
DANVILLE AVE END 33 85
157TH ST
90 WEST OF CENTER OF BULB CENTER OF BULB 98 83
DANVILLE AVE 90 W OF CENTER OF BULB 94 84
158TH CT
DANVILLE AVE END 90 86
158TH ST
DANVILLE AVE END 41 87
158TH STREET WEST
CHIPPENDALE AVENUE CICERONE PATH 89 88
WEST LOT LINE 3555 WEST LOT LINE 3640 89 89
WEST LOT LINE 3640 CICERONE PATH 89 90
159TH CT W
DANVILLE AVE END 76 91
APPALACHIAN TRAIL
121ST STREET WEST END 94 92
AZALEA PATH
AZALEA PATH
BLOOMFIELD PATH
BANYAN LANE
BLOOMFIELD PATH
BAYBERRY COURT
BAYBERRY TRAIL
BAYBERRY TRAIL
AZALEA PATH
BAYBERRY COURT
SOUTH LOT LINE 14200
STREET
BEECH STREET
BISCAYNE AVENUE
BELFAST COURT
BELFAST STREET
BELFAST STREET WEST
BISCAYNE AVENUE
BELLE COURT
BLOOMFIELD PATH
BELMONT COURT
BIRCH STREET WEST
BELMONT TRAIL
BIRCH STREET
BENGAL AVE
130TH ST
BENTLEY WAY
BLOOMFIELD PATH
BIRCH STREET WEST
BELMONT TRAIL
BIRCHWOOD AVENUE
BIRCH STREET
BISCAYNE AVE
130TH ST
145TH ST
660' NORTH OF RR TRACKS
END 98 95
SOUTH LOT LINE 14191 100 96
BLOOMFIELD PATH 94 99
END 100 102
AURORA AVE 99 103
175' EAST 100 104
BAYBERRY COURT 100 105
PCI MAP
BANYAN LANE 100 108
END 94 109
BELMONT TRAIL 94 111
TO END 94 114
END 88 115
NORTH LOT LINE 14017 100 117
128TH ST 98 121
BLOOMFIELD PATH 94 122
BISCAYNE AVENUE 98 125
CONNEMARA TRAIL 100 129
NORTH END 47 130
660' N OF RR TRACKS 82 131
1600' NORTH OF TRACKS 88 132
CSAH 42 145TH ST 100 133
END CSAH 42 100 134
BISCAYNE WAY
145TH ST BISCAYNE AVE 35 135
BLANCA AVE
148TH ST 145TH ST 100 407
BLOOMFIELD PATH
145TH STREET AUBURN AVENUE 100 136
BISCAYNE AVE 145TH ST 98 408
BLANCA AVE BISCAYNE AVE 100 409
BLOOMFIELD CIRCLE NORTHEAST LOT LINE OF 14626 87 139
NORTH LOT LINE 14602 145TH STREET WEST 100 142
NORTHEAST LOT LINE OF 14626 NORTH LOT LINE 14602 100 143
STREET PCI MAP
BLUEBERRY CT
BLANCA AVE END 100 410
BOISE CIRCLE
148TH ST END 100 411
BOSTON CIRCLE
148TH ST END 100 412
BOULDER AVE
345' W OF CL BUS PKWY 80' E OF CL BUS PKWY 91 145
BOULDER TRAIL
80' E OF CL BUS PKWY BISCAYNE AVENUE 92 147
BOYSENBERRY CT
BLANCA AVE END 100 414
BRENNER COURT
BUSINESS PARKWAY END 100 415
BURMA AVE
145TH ST 146TH ST 100 149
146TH ST LOWER 147TH ST 100
BURNLEY AVE
146TH ST 145TH ST 27 150
BUSINESS PARKWAY
CSAH 42 148TH ST 100 416
G.R. 42 FRONTAGE ROAD
COUNTY ROAD 42 COUNTY ROAD 42 95 152
CAMBRIAN AVE
LOWER 147TH ST ST HWY 3 26 153
CAMEO AVE
143RD ST 145TH ST 99 154
LOWER 147TH ST 145TH ST 99 155
CAMERO LANE
CAMBRIAN AVE END 25 156
CAMFIELD CIR
LOWER 150TH ST END 100 157
CANADA AVE
144TH STREET WEST NORTH END 44
145TH ST 144TH STREET WEST 76 158
CSAH 42 ST HWY 3 100 159
LOWER 147TH ST 145TH ST 100
LOWER 150TH ST LOWER 147TH ST 100 160
STREET PCI MAP
CANADA COURT
CITY DUMP DRIVEWAY C/L END 100 161
TH 3 END 100 162
CANTATA AVE
143RD ST 144TH ST 83 163
CARDINAL CIR
CARDINAL ST END 91 164
CARDINAL CT
CARDINAL ST END 91 165
CARDINAL ST
CRYSTAL PATH CARDINAL CIR 88 166
CARROUSEL WAY
151ST ST CHIPPENDALE AVE 100 167
CASCADE PATH
160TH STREET W CINNAMON WAY 89 168
FROM EAST LOT LINE 15968 WEST LOT LINE 15936 88 169
WEST LOT LINE 15936 CINNAMON WAY 92 170
CHARLSTON AVE
LOWER 150TH ST
CHARLSTON COURT
CHARLESTON WAY
CHARLSTON WAY
DODD BLVD
CHEVELLE CT
UPPER 149TH ST
CHIANTI AVE
LOWER 147TH ST
CHILI AVE
145TH ST
LOWER 147TH ST
CHINCHILLA AVE
MCANDREWS
STREET
CHIPPENDALE
151ST STREET
153RD STREET WEST
155TH STREET WEST
156TH STREET WEST
158TH STREET WEST
160TH STREET WEST
CARROUSEL WAY
CHIPPENDALE AVE
148TH ST
CSAH 42
UPPER 149TH ST
148TH ST
NORTH END
131ST
END
145TH ST
NORTH END
148TH ST
SOUTH END
CSAH 42
CARROUSEL WAY
153RD STREET WEST
155TH STREET WEST
156TH STREET WEST
158TH STREET WEST
151ST STREET
145TH ST
UPPER 149TH ST
148TH ST
100 171
85 172
94 173
100 174
100 175
93 176
100 177
24 178
PCI MAP
87 186
100 185
89 180
89 181
89 182
89 183
100 179
100 187
94
94
CHOKECHERRY AVE
152ND ST
154TH ST
CHORLEY AVE
UPPER 148TH ST
CHROME AVE
146TH ST
CHRYSLER AVE
149TH ST
CICERONE COURT
CICERONE PATH
CICERONE PATH
15720 (150' N. OF 158TH ST.)
C/L CICERONE COURT
CICERONE COURT
CORNELL TRAIL
S.L.L. 15728 (220' S. OF 158TH ST.)
S.L.L. 15748 (115' S. OF CARDINAL
WEST LOT LINE 15847
WEST LOT LINE 15875
CIMARRON
148TH ST
STREET
CIMARRON AVE
143RD ST
145TH ST
DODD BLVD
CIMMARON AVENUE
CO RD 42
CINNAMON WAY
SHANNON PARKWAY
CIRCLE AVE
153RD ST
153RD ST
155TH ST
UPPER 149TH ST
DODD BLVD
UPPER 148TH ST
CENTER OF BULB
S.L.L. 15728 (220' S. OF 158TH ST.)
EAST LOT LINE 15812
158TH ST
15720 (150' N. OF 158TH ST.)
S.L.L. 15748 (115' S. OF CARDINAL
C/L CICERONE COURT
WET LOT LINE 15875
158TH STREET W
U 149TH ST
144TH ST
DODD BLVD
147TH ST
151ST STREET
154TH ST
PCI
83
100
32
90 188
63 189
20 190
30 191
18 192
89 193
92 197
86 194
94 196
15 195
88 198
89 199
94 200
94 201
36 202
94
MAP
203
204
205
206
90' EAST OF CASCADE PATH 89 209
88 210
CLARET AVE
154TH STREET 155TH STREET WEST 61 417
155TH STREET WEST CORNELL TRAIL 38 211
CLARET AVENUE
CSAH 42 151ST ST 100 213
CLARK ROAD
117TH HWY 52 53 214
CLOVER LANE
COBBLER AVE 14015 CLOVER LANE 94 215
COBALT AVE
DODD BLVD 145TH ST 99 216
COBBLER AVE
143RD ST 144TH ST 81
SHANNON PARKWAY 143RD ST 81 217
COBBLESTONE COURT
COBBLESTONE LANE WEST END 92 218
COBBLESTONE LANE
MCANDREWS NORTH END 91 219
COFFEE TRAIL
1090' NORTH OF MCANDREWS NORTH END 100 220
CO RD 38 544' NORTH 89 222
COLORADO AVE
147TH ST U 149TH ST 94 223
COLUMBARY CIR
153RD ST END 59 224
COLUMBARY CT
156TH ST END 57 225
COLUMBIA CT
156TH ST END 87 226
STREET PCI MAP
COLUMBIA WAY
153RD ST 155TH ST 71 227
CONLEY AVENUE
CSAH 42 140TH STREET 94 230
CONNEMARA PARK
EAST DRIVE EAST END 6 403
WEST DRIVE EAST DRIVE 100 402
CONNE ?.1ARA TRAIL
DAPHNE LANE SHANNON PKWY 100
DIAMOND PATH DAPHNE LANE 100 233
EAST SIDE OF 13908 PROPERTY TH 3 95
SHANNON PKWY EAST SIDE OF 13908 PROPERTY 91
COPPER COURT
CONNEMARA TRAIL END 62 234
CORMACK CIRCLE
EVERMOOR PARKWAY END 100 235
CORMORANT WAY
COBBLER AVE COBBLER AVE 78 236
CORNELL CT N
CORNELL TRAIL END 84 237
CORNELL CT S
CORNELL TRAIL END 76 238
CORNELL TRAIL
156TH ST EAST END 156TH ST 14 239
CLARET AVE 156TH STREET WEST 36 418
SHANNON PKWY CLARET AVE 64 240
COVINGTON AVE
1 U 149TH ST DODD BLVD 90 241
CRANBERRY WAY
143RD ST SHANNON PKWY 79 242
CRANDALL AVE
147TH ST U 149TH ST 92 243
CRANFORD CIRCLE
EVERMOOR PARKWAY END 100 244
CREGGS CIRCLE
EVERMOOR PARKWAY END 100 245
CRESCENT CIR
144TH ST END 84 246
STREET
CRESTONE AVENUE
151ST STREET W
CRESTONE CT
CORNELL TRAIL
PCI MAP
CSAH 42 89 248
END 83 249
CRESTONE PATH
156TH ST CORNELL TRAIL 87 250
CRESTVIEW
147TH ST U 149TH ST 91 251
CROCUS AVE
156TH ST CRYSTAL PATH 100 252
CROCUS CT
CROCUS AVE END 97 253
CROCUS WAY
CRANBERRY WAY COBBLER AVE 84 254
CROFTON CT
143RD ST END 76 255
CROLLY COURT
CROLLY PATH END 100 256
CROLLY PATH
EVERMOOR PARKWAY END 99 259
CROOKHAVEN COURT
EVERMOOR PARKWAY END 98 260
CRUSHEEN COURT
EVERMOOR PARKWAY END 99 262
CRYSTAL CT
CRYSTAL PATH END 100 263
CRYSTAL PATH
CROCUS AVE DANVILLE 100 264
SHANNON PKWY CARDINAL ST 100 265
CUMBERLAND AVE
CRYSTAL PATH 156TH ST 100 267
CURRANT CIRCLE
SHANNON PKWY END 82 268
DAFFODIL PATH
SHANNON PARKWAY DANUBE LANE 61 269
DAHLIA CT
SHANNON PARKWAY WEST END 78 271
DAHOMEY AVE
UPPER 145TH ST 147TH ST 100 272
$TREET PCI MAP
DAISY COURT
DAFFODIL SOUTH END 100 273
DAKOTA DR
DANVILLE AVE Midblock 80 274
Midblock Dakota Lane 98 275
Dakota Lane
160th Street 158th Street 98 276
DALLARA AVE
150TH ST DODD BLVD 19 277
DODD BLVD 145TH ST 100 278
DALLAS AVE
CONNEMARATRAIL DARTMOUTN PATH 79 279
DALLAS COURT
CONNEMARATRAIL END 97 280
DALTON LANE
SHANNON PARKWAY DAFFODIL 76 281
DAMASK AVE
147TH ST U 145TH ST 100 282
DODD BLVD 150TH ST 28 283
DAMASK CT
DODD BLVD END 37 284
DANBURY AVE
147TH ST U 145TH ST 100 285
155TH ST DARLING PATH 100 419
DANBURY AVENUE
151ST STREET 156TH ST 95 289
DANBURY CT
DANBURY PATH NORTH END 75 290
DANBURY PATH
DAPHNE 137TH STREET 83 291
DANBURY WAY
125TH ST (CR 38) 125TH ST (CR 38) 12 292
MCANDREWS NORTH END 84 293
DANDER COURT
SHANNON PKWY END 43 294
DANE AVE
DEARBORN PATH EAST END 69 295
DANNER PATH
EVERMOOR PARKWAY DANUBE LANE 98 296
STREET PCI MAP
DANUBE CIRCLE
DANUBE LANE END 100 299
DANUBE COURT
DANUBE LANE END 94 301
DANUBE LANE
SOUTH LOT LINE 13421 SOUTH END 91 305
WEST END SOUTH LOT LINE 13421 100 311
DANVILLE AVE
146TH ST U 145TH ST 100
153RD ST DECEMBER TRAIL 88 312
155TH ST DARJEELING PATH 87 313
160TH UPPER 156TH ST 79 314
DECEMBER TRAIL 15137 SOUTH PROP LINE 66 315
DODD BLVD 146TH ST 100 316
UPPER 156TH ST 156TH ST 100 317
DANVILLE CT
138TH NORTH END 36 318
DAPHNE LANE
CONNEMARA NORTH END 92 319
DAPPLE CIR
UPPER 156TH ST END 90 320
DAPPLE CT
UPPER 156TH ST END 91 321
DARJEELING CT
153RD ST END 86 322
DARJEELING PATH
156TH ST 152ND ST 90 323
DARLING PATH
156TH ST CURVE 96 325
CURVE DARJEELING PATH 99 420
DANVILLE AVE 156TH ST 100 326
DARJEELING PATH DANBURY AVE 97 327
DARNELL COURT
138TH SOUTH END 40 328
DARTMOOR CT
DECEMBER TRAIL. END 97 329
DARTMOUTH
DELTA DANE 76 330
STREET PCI MAP
DARWIN WAY
CONNEMARA DANBURY PATH 99 331
DAVENPORT
DEARBORN DEKALB 80 332
DAVENPORT AVENUE
145TH STREET WEST 143RD STREET WEST 100 334
DAVENPORT COURT
DAVENPORT PATH NORTH END 73 336
DAVY COURT
CONNEMARA TRAIL END 71 337
DAWSON CT
143RD SOUTH END 100 338
DAWSON PLACE
DAWSON CT EAST END 97 339
DAYBREAK AVE
152ND ST DECEMBER TRAIL 73 340
DAYTONNA WAY
DALLAS AVE DARTMOUTH PATH 88 341
DEARBORN PATH
DANE AVE WEST END 82
SHANNON PKWY DANE AVE 72 342
DECEMBER CT
DECEMBER TRAIL END 92 343
DECEMBER TRAIL
SHANNON PARKWAY DANVILLE AVENUE 99 345
DEEPWOODS COURT
MCANDREWS SOUTH END 81 346
DEKALB
DEARBORN 100FT NORTH OF 143RD 76 347
DEKALB AVENUE
144TH ST 100FT NORTH OF 143RD 82 348
DELFT AVE
145TH ST U 145TH ST 98 351
DODD BLVD UPPER 145TH ST 97 352
DELLWOOD CT
DELLWOOD WAY NORTH END 58 353
DELLWOOD WAY
SHANNON PARKWAY DAFFODIL 88 354
DELMAR COURT
NORTH LOT LINE 14774 C/L OF BULB 90 355
STREET PCI MAP
DELTA AVENUE
CONNEMARA TRAIL DEARBORN PATH 70 357
DELTA COURT
DELTA AVENUE END 66 358
DELTA PLACE
CONNEMARA TRAIL END 67 359
DENVER COURT
DELFT AVENUE SOUTH TO C/L OF BULB 94 360
DEWBERRY CT
152ND ST END 84 361
DODD BLVD
CIMARRON AVE CHIPPENDALE AVE 100
DELFT AVE SHANNON PARKWAY 100 362
SHANNON PARKWAY CIMARRON AVE 100
DODD COURT
DODD BLVD WEST END 100 363
DOYLE PATH
HWY 52 END 79 364
DRUMCLIFFE PATH
EVERMOOR PARKWAY EAST END EVERMOOR PARKWAY EAST END 98 366
EVERMOOR PARKWAY
SHANNON PARKWAY COUCHTOWN PATH 99 378
WESTERN CITY LIMITS SHANNON PARKWAY 98 379
LOWER 147TH ST
BURMA AVE ST HWY 3 99 380
CANADA AVE CHILI AVE 100 381
LOWER 150TH ST
CHARLSTON AVE CAMFIELD CIR 100 383
RINE BEND TRAIL
HWY 52 GRAVEL 75 384
SHANNON PKWY
145TH STREET WEST CONNEMARA TRAIL 81
160TH ST CO RD 42 99 385
CONNEMARA TRAIL DAFFODIL PATH 67
CSAH 42 145TH ST 88 421
DAFFODIL PATH EVERMOOR PARKWAY 84
EVERMOOR PARKWAY CR 38- MCANDREWS 60
STREET PCI MAP
U 145TH ST
DALLARA AVE DAMASK AVE 100 386
DELFT AVE (EAST LEG) DANVILLE AVE 100 423
DELFT AVE (WEST LEG) DELFT AVE (EAST LEG) 100 387
U 149TH ST
COLORADO AVE CRESTVIEW AVE 88 388
UPPER 143RD ST
CHILI AVE CANTATA AVE 81 389
UPPER 145TH CT
U 145TH ST END 100 391
UPPER 145TH ST
DALLARA AVE DAHOMEY AVE 100 392
UPPER 147TH ST
CANADA AVE CHILI AVE 100 393
UPPER 148TH ST
CHORLEY AVE CIMMARRON AVE 40 394
DELFT AVE DIAMOND PATH 82 395
UPPER 149TH CT
UPPER 149TH ST END 100 396
UPPER 149T1-1 ST
CHIPPENDALE AVE CHARLESTON AVE 100 397
CHORLEY AVE CIMMARRON AVE 41 399
CIMMARRON AVE END 44 400
UPPER 156TH CT
DANVILLE AVE END 99 424
UPPER 156TH ST
DARLING PATH DANVILLEAVE 89 401
Backlog
(dollars)
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
N 0 CO d' co N- CO N N LO CO CO O 0 IT- CO r CO LO N.
W N u) CJ r LO CO 0 CO LO co m V to (N cr co Co r (0
CO d' N- O N LO (0 r LO O V c0 N N N O`. CO r (O co
CO CO O O r 00 N N ti 0 CO CO t CO r r CO N
JJ CD LC) t N- N 0) LC) O) N CO r O (0 0 0-- CO V CO N-
C0 r C) r N O
CO C) (0 (0 C0 r (0 (0 N— (0 N` I: O c ol
EA EA 69 r r N N
EA EA EA EA 69 64 EA EA EA EA 69 EA 69 69 69 CA E9
Seal Coat
0 0 o e 0 0 0 0 0 0 0 0 0 0 0 0
O O O O O co T- V- NI V- r N N c- r N CO T- N
Reconstruct
0 0) p o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O O O O N N O) LO CO CO (P CO CO ct I CD CO N(0 N... C) r
r r N` M I. CO V r O
hepaAO
0 0 0 0 0 0 0 0
O N CO t- M OO O CD V r N r 0) N (O
O O O O N V N CO O N r CV CO LO N LO
r.
Unspent
(dollars)
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
EA EA CO- EA EA EA EA 69 69 69 69 E EA 69 EA 69 69 EA (A EA
Budget Spent
(dollars)
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
(A EA CO CO V N C) OO CO CO N V O (O LO (O CO O) V N
O CO O) O) <Y N N r O O C) co N O O 7
V 0 cO (0 LO (0 O) N O O co (0 r LO CO (O r N
r u) N LO 't co co V co co co co N r O) O N CO
CO CO LO N 0 (0 r N CO LO CO CO 0 r (P CO CO LO
69 r N r N r N r N r co- N r r N N-
U* EA EA EA 69 EA EA EA 69 EA 69 EA EA EA 63
Budget Allocated
(dollars)
0 0 0 O 0 0 0 O 0 0 0 0 0 0 0 0 O 0 0 0
69 69 CO CO V N CO DJ OD CO N V 0 CO LO CD C) O) d' N
CO CO 0) O V N N N. O't 0 CO V CA N CO 0 V
V N co O In O O) N (D CO O O N- LC) O O r N
L0 N (f) V co (D V (D CO 0 CO N r CD O N C)
CO N LO r O (D r I` CO CO_ CO CO O r CT CD CO LO
696969 r N r N r N r N,- C) N r r N N
EA 6969 CA EA EA-EA EA CA EA EA 69 E9 CA EA
Average
Weighted
PCI
0- C) N O) N to LO CO LO LO LO LO I- LO CO CD LO LO L0 CO
0- n I` (D (D (D (D CO CD (D (D CO CO CD O CD CO CO CD CO
JeaA
r CO 0) O r N C) V LO CO I` CO O) O N CO V (O CO
0 0 0 0 0 0 0 0 0 0 0 0 0 0 N CV 0 0 0 0 0 0
N N N N N N N N N N N N N N N N N N N N
N
L
0
0
0
69
0
0
N
0
to
O
O
CD 0
CO 0
N 0
r
co N
Cfl
O 0
O
O LO
co
N r
ca
69
J
0
I—
average per year
0
N
O a
d
U
N
w
d
N D1
w
m
0
co
CO
1-
h
s cn
o a
o
m m
El
O O O O O
O O O O O
O O O O O
O O O O O
O 10 O
N N r r Hi
E3 S S to
Si elloa
0
0
0 0 0 0 0
f- c0 V M
IOd pa34 a6eJany
0
04
0
0
8ZOZ
LZOZ
Backlog
(dollars)
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O C) r- r O 60 N r f9 E9 E9 EA C) O CO CO L') r r N
O' O N- r N- LO O CO r n O (D O LD co L()
C) CO r 0 N- CO N 00 C) O r r I 0) 0 C)
CD r LID r O CO r (O r N CO N-- O 0 U)
CO O c) LD CO 0 N N CO to 07 CO co N C) r
r r C) N 69 69 69 69 64 E9 E9 r N r r
6 9 6964 Eft C9 0 U3 69 9
woo IeGS
o 8Q o 0 O o 8 Q 82 0 0 0 8Q 0 82 0e- 8Q 0 0 0
0 0 0 0 0 o a o 0 0 0 co O
cv N O O m r) r C C) O 0 te CO <<0 'Cl" N N N 0 0 0 CV CV CV
Reconstruct
o a a o 0 0 0 0 0 0 0 0 0 0 0 0
CD V O r 7 N LSD 000 go 00 0 000
Aelaano
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a 0
O O N CO r 0 r r N LD O N■ O O CD CO 0 0 0
M CO CO CO CO r CO O N r N r CD 0 CO r CO CO CO
Unspent
(dollars)
0 0 0 O 0 O O O O 0 O O 0 O O O O O O O
E9 E9 69 69 0 O 69 69 0 0 O O E9 69 0 69 69 69 69 69
0 0 0 0 0 0
CO LD vi O LD cv
E9 64 co r CO r
69696969
Budget Spent
(dollars)
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 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
co (0 (0 (fl N (0 CO 41 r (fl r (D (D (D (D (D (D (0 C6
LOO CD LC LCD C4 N LSD LC) r C) CO CO LID CO L() N LID ll) LID in
(0 c0 (D (D (D (D (D CO 0 O ti N (D (D (D (D CO (0 CD (D
69 E9 E9 69 6900 069 E9 69 0 69 64 E9 E9 E9 69
Budget Allocated
(dollars)
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O O O O O O O O O 0 O O O O O O O 0 O O
O O O O 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0
(0 (0 (0 (0 (0 (0 (o (0 (0 (o (6 (6 (0 (6 (0 (0 (0 (6 (0 co
in LI) Ln in in LO in L') in CO Ln L0 LCD Ln CO LI) Ln LID LO 0
CO (0 (D (O CD (0 (0 CO (D CO CO (D (D (O (D CO CO CO (D CD
r r r r r r r r r r r r r r r r r r r n-
69 0 69 E9 69 6969 63 E9 CO (A 69 69 69 H) 69 6964 c969
Average
Weighted
PCI
N CO r LD (D (O r (D r CO N r O O (P co r (0 r
co co co co co co co CO CO CO CO CO 0 CO CO r N- N N- r
.1eaA
r O O) O r N CO r LD CO N- CO CI) O N co r in (D
0 0 0 CD 0 0 0 0 0 0 0 0 0 0 0 0 0 CV 0 0 0 0 CV
N N N N N N N Cl N N N N N N N N N N N N
t
0
on
LL
0)
0
U O
as y
m
6
Q
0 O
0) C
U
CO Cn
O
O
O
0
cv
C)
(0
69
O
O
O
O
O
O
O
O
O
O CU
o
U D
O n
07 m
L ❑71
O
O
O
O
O
O
O
O
O
O
ER
0
N
O
N
N
O
N
M
N
O
04
04
N
0
N
N
O
N
O
N
0
N
O
O
N
CO
O
N
r-
0 4
O
0
N
N
O
N
V
O
N
0
N
N
0
N
O
N
0
0
N
m
0
0
N
0
N
O
O
N
0
r I
I 1
c
="t` "x n� ";.e :gyp
re. 01 %Iv_
VIA n
o-
O
O
O
O
O
O
O
O
O
O CU
o
U D
O n
07 m
L ❑71
O
O
O
O
O
O
O
O
O
O
ER
0
N
O
N
N
O
N
M
N
O
04
04
N
0
N
N
O
N
O
N
0
N
O
O
N
CO
O
N
r-
0 4
O
0
N
N
O
N
V
O
N
0
N
N
0
N
O
N
0
0
N
m
0
0
N
0
N
O
O
N
0
0
O
0) co ti V �O 0
IOd pa1y6iaM a5eJany
0
O
9Z0Z
LZOZ
9303
SZOZ
4ZOZ
£ZOZ
ZZOZ
IZOZ
OZOZ
6lOZ
9103
L IOZ
9102
L
91.03 m
b10Z
£1OZ
z1.0Z
1.1.02
01.02
6003
2003
LOOZ
900Z
9002
P002
£003
ZOOZ