INFORMATION 04-18-2011INF~®RMAT'I®l~T
KlVE',r MEMORANDUM
TO: Mayor and Council Members
FR®M: Tim Simon, d=inance Director
DATE: /~pril 18, 201
SUB.IECT: E~uarterly Investment Report (January-March, 201 IJ
INTIt®LBIJCTI®Nv
The purpose of this report is to update the City Council on the status of the various
investments that the City maintains. This report is as of March 31, 2011.
IiACKGROtJNI):
The City Council adopted the original investment policy on Apri128, 1998 with subsequent
modifications on February 5, 2007. The policy generally follows the Government Finance
Officers Association (GFOA) model and does comply with State Statutes.
The investment goals for the City of Elk River are passive in nature due to the allowable
investments permitted under State Statutes. The City has four objectives for investing in
order of importance. They are safety of principal, liquidity, return on investment, and
maintaining the public trust. This means we are focused on not losing on the original
investment,, having sufficient funds on hand to meet ongoing operating cash needs, getting a
market rate of return, and not purchasing speculative investments.
State Statutes limit the City's ability to invest in many risky types of investments. The City
does not purchase stocks or mutual funds. The CitS~ is generally limited to federal and state
government obligations or agencies backed by them. The City can invest in short-term
commercial paper (highly rated), Certificates of Deposit or money market accounts (with
collateralization if in excess of FDIC insurance amounts), and the rated debt of local
governments.
The City intends to hold investments until maturity, which means we will get the rate of
return for which we invest our funds. Our goal is not to extend our maturities beyond five
years unless we are matching cash flow to a specific debt sen~ice payment.
INF®RMATIC)N
The City makes sure we are sufficiently liquid by continually updating our forecast on the
anticipated cash flow needs over the next five year time horizon. We also build iri a reserve
balance incase of unexpected expenditures, these funds are maintained in money market
accounts through the 41~I Fund. We anticipate the fact that we will have two large tax
settlements each veer, along with the regularly scheduled debt service payments that occur
each year.
®ver the past couple of years the search for quality has been the goal, thus we have avoided
commercial paper for close to two years due to concerns over the credit quality issues that
have existed. In addition, for high quality commercial paper the yield is several basis points
below ashort-term CIS. The yield curve has remained relatively flat in the 30 day to year
range, but the longer side of the curve has showed some signs of an upward- sloping shape
which has meant long-term securities slightly exceed returns on short-term instruments.
This may also indicate that investors still prefer liquidity and will take a lower yield for short-
term and secure investments.
The City has to weigh the opportunity cost to invest in longer term investments or ride the
yield curve and reinvest at shorter maturity intervals. Most recent purchases have been
ageneies with callable provisions as interest rates step-up, these are somewhat predictable of
when they will be called and are aligned with our cash flow model Investing in shorter-term
investments has presented far fewer options since the decline in the commercial paper
market. Treasury yields are still around historical lows. Three month notes are yielding
Q.09°,% and the ten year notes are 3.47%. See graphical illustrati®n below:
http: / /w~t-v~~.t~streas.gov /offices /domestic-finance/debt-management! interest-
raie /yield_historical.shtml
Treasury Yields
6.00% ...._-..._..-------
4.00% __.._.._..-.---.._--
2.00% ... .. _ _...
0.00% ___-~~~
Imo. 3mo. 6mo. 1yr. 2yr. Syr. Syr. Tyr. 10yr. 30yr.
--r1--12/31/2010 -f-03/31/2010
Cities generally use a short horizon benchmark such as the two year Treasury Bill (3/31 -
.8(I% up fram .61% at 12/31) or some similar measure. Our current portfolio yield is
roughly 1.60% which is up from year-end. This is calculated by taking the yield times the
current value for each investment and dividing the resulting amount by the total portfolio
value. As investments purchased in earlier years mature we will be able to replace them and
lock into some longer term interest rates, but they may have to be reinvested at lower
interest rates as market conditions change. It is very typical to lag the market as interest rates
change. This will lead to more predictability in our interest earnings.
C-ur primartt resei-~Te account is our 4M Fund which is a money market account that various
cities pool their funds into. It currently yields .02°,% ~=ith daily withdrawal privileges. We are
currently maintaining a lower liquidity position as several investments will mature in the
INFORMATION
upcoming months and we have reinvested at higher rates and will be ready when the Federal
Reserve adjusts interest rates. The City strives to maintain a strong diversification portfolio
so liquidit~t and exposure risk are reduced.
The following is the summary of sector distribution, agency distribution, and interest rate
distribution as of 3~31~11.
~ _ _ _ _ __ _ _ _ E
I MM Sector Distribution
4%
i
f~c~ v
80%a
c ,,-=
15,000,000.00
10, 000, 000.00
k 5,000,000.00
' 20,000,000.00
15,000,000.00
10,000,000.00
5,000,000.00
0.00
Agency Distribution
INFORMATION
MEMORANDUM
TO: City Council
FROM: Justin Femrite, P.E., City Engineer
DATE: April 18, 201 I
SUBJECT: BNSF Quiet Zone Update
Over the last month I have reviewed the feasibility study and estimated costs that were presented
in December of 2007 for establishment of a quiet zone along the BNSF railroad through Elk
River. Mayor Dietz contacted me with information that Anoka is currently establishing a quiet
zone for far less cost than estimated in our 2007 study. I spoke to the City of Anoka who
directed me to TKDA, the consultant they hired to complete the quiet zone work through
Anoka. TKDA has expert staff with comprehensive understanding of the required
improvements in establishment of quiet zones. Anoka is working at establishing a quiet zone at
two crossings. TKDA indicated the improvements required to establish a quiet zone in Anoka
were very minor. The street crossings in Anoka had sufficient width to accommodate the
required median improvements, without need to widen the roadway or relocate the existing
crossing arms. In addition, the controls for the existing crossing gate systems are already
upgraded and in place. The cost for improvements at each intersection on Anoka's project is
estimated at $50,000 for a total project cost of $100,000.
TKDA attended a meeting with me to review the proposed improvements and associated costs
from the Elk River 2007 study. This review found the costs presented in the 2007 study were
accurate for that time period but have since increased due to current pricing structures of the
BNSF. The 2007 study estimated the full establishment of a quiet zone through Elk River would
cost about $4.3 million. These costs are now estimated at $5.0 million. The cost increase
reflects the higher price BNSF currently charges for the work they would be responsible to
complete including all controls work, gate installations and relocations, crossing surface
extensions and installation of vehicle presence detection systems.
As detailed in 2007, funding for the improvements would be 100% from local funds. TKDA
indicated funding opportunities for these improvements are not available from State, Federal, or
Rail sources because the establishment of a quiet zone is not classified as a safety improvement.
In 2007 Sherburne County indicated they would not participate in funding the quiet zone
improvements.
With no formal City Council direction on this project, we have not reopened any discussion with
the County or any other agencies that may be affected by this project. Our work to this point
has been limited to the review of our 2007 study and the estimated project costs. No costs have
been incurred for this review.
If you have any questions or would like additional work be completed on this issue please call.
N:\Public Bodies\Ciry Council\Counal RCA\Agenda Packet\0418-2011\Quiet Zones.docx
INFORMATION
.V~~"
MEMORANDUM
TO: Mayor and City Council
FROM: Tim Simon, Finance Director
DATE: April 18, 2011
SUBJECT: March 2011 Monthly Financial Report
This report is designed to provide surrunary information regarding the overall level of
revenues and expenditures in the General Fund and Pinewood Golf and Ice Arena special
revenue funds. These funds are the primary concern in analyzing the City's financial health.
For the month of March, actual revenues (except for property taxes and state aids) and
expenditures should run 25% of the annual budget. It is natural for some of the items to
vary from month to month, such as exceeding budget for Supplies but being significantly
below fox Services. This is not considered serious as long as the total expenditure budget
amount is not overspent. Significant variances from budget are highlighted below
accompanied with a general discussion for the variance.
General Fund
Kevenue.r:
• Excluding transfers, revenue collections axe about 4.3% of budget; however,
property taxes, our largest revenue source, will be received in July and December.
• Licenses and permits are 49% of budget due mainly to plumbing/heating permits
issued, which a significant amount is related to the data center expansion.
• Charges for services are 31% of budget estimates and are mainly comprised of the
semi-annual school liaison contract, Otsego fire contract, and spring/summer
recreation fees.
• The negative interest income is related to the reversal of the prior year's interest
receivable.
• The transfers in will be recorded mid-year.
Expenditures:
• Excluding transfers, the total departmental expenditures are about 19% and most
departments are well within or below budget.
• The second quarter liability insurance premium through June 30 was paid in March
as is reflected in the Mayor & Council budget.
• The Snow Removal budget reflects the seasonal expenditures for personal services
and road salt.
• The transfers out to the Ice Arena and Pinewood Golf are made at the end of the
year.
Ice Arena
Fox March, revenues exceeded expenditures by $130,607. Excluding transfers in, revenues
axe about 38% of budget due mainly to ice rental, hockey program registrations and
concessions, while expenditures axe about 16% of budget.
Pinewood Golf
Golf registrations axe starting to be received for the spring/summer programs.
Expenditures are about 10% of budget due mainly to personal services and insurance.
4-13-2011 09:56 AM
101-GENERAL FUND
FINANCIAL SUMMARY
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
PAGE: 1
INF+attMATIt?NI
25.OOo OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE a OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SUMMARY
General Fund 12,163,450.00 118,719.27 552,420.89 4.59 11,611,029.11
TOTAL REVENUES 12,163,450.00 118,719.27 552,420.89 4.59 11,611,029.11
------------- ------------- ------------ ------- -------------
------------- ------------- ------------ ------- -------------
EXPENDITURE SUMMARY
General Government
Mayor & Council 177,800.00 22,611.96 54,097.94 30.43 123,702.06
Cable TV 77,800.00 5,716.92 14,968.52 19.24 62,831.48
Administrative Services 473,650.00 33,202.65 94,067.51 19.86 379,582.49
Human Resources 150,750.00 12,761.27 32,461.59 21.53 118,288.41
Finance 454,700.00 28,841.37 87,946.55 19.34 366,753.45
Information Technology 266,600.00 21,390.67 59,111.59 20.30 212,488.41
Legal 240,000.00 26,223.45 44,003.45 18.33 195,996.55
Community Development 67,100.00 5,326.64 13,757.54 20.50 53,342.46
Planning 303,550.00 24,171.09 59,851.20 19.72 243,698.80
City Hall Maintenance 300,850.00 22,037.38 57,845.59 19.23 243,004.41
Contingency 75,000.00 0.00 0.00 0.00 75,000.00
TOTAL General Government 2,587,800.00 202,233.40 513,111.48 19.83 2,074,688.52
Public Safety
Police Administration 563,800.00 97,310.85 154,888.71 27.47 408,911.29
Patrol 2,252,800.00 154,589.82 402,498.80 17.87 1,850,301.20
Investigations 752,450.00 45,999.76 129,777.41 17.25 622,672.59
Police Support Services 491,700.00 35,302.61 95,115.66 19.34 396,584.34
Police Reserves 22,900.00 3,727.94 4,917.85 21.48 17,982.15
Public safety building 205,000.00 15,544.81 40,044.87 19.53 164,955.13
Fire Administration 589,600.00 43,994.69 121,715.91 20.64 467,884.09
Fire Inspections 184,850.00 13,502.45 34,478.63 18.65 150,371.37
Emergency Management 107,400.00 1,142.46 2,882.03 2.68 104,517.97
Building Safety 465,200.00 35,231.43 95,096.43 20.49 370,103.57
Environmental 56,950.00 4,646.93 11,267.97 19.79 45,682.03
TOTAL Public Safety 5,692,650.00 400,993.25 1,092,684.27 19.19 9,599,965.73
Public Works
Street Maintenance 1,524,450.00 64,366.16 167,791.21 11.01 1,356,658.79
Snow Removal 262,850.00 57,274.91 179,564.33 68.31 83,285.67
Equipment Services 245,950.00 16,569.88 39,899.05 16.22 206,050.95
Engineering 177,800.00 11,428.56 25,786.17 14.50 152,013.83
TOTAL Public Works 2,211,050.00 149,639.51 413,090.76 18.68 1,798,009.24
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
FINANCIAL SUMMARY
CURRENT CURRENT
BUDGET PERIOD
25.00$ OF YEAR COMP.
YEAR TO DATE $ OF BUDGET
ACTUAL BUDGET BALANCE
Culture & Recreation
Parks Department 790,350.00 57,399.47 193,130.34 18.11 647,219.66
Parks & Rec Admin 550,300.00 35,185.92 92,264.01 16.77 458,035.99
Recreation Programs 192,500.00 6,526.45 20,510.12 10.65 171,989.88
Concessions 14,100.00 33.32 33.32 0.24 14,066.68
Sr Citizen Programs 204,450.00 15,555.38 40,433.44 19.78 164,016.56
TOTAL Culture & Recreation 1,751,700.00 114,650.54 296,371.23 16.92 1,455,328.77
Economic Development
Economic Development 0.00 ( 2,545.05) 26,414.09 0.00 ( 26,414.09)
Energy City 51,650.00 99.13 3,619.97 7.01 48,030.03
TOTAL Economic Development 51,650.00 ( 2,950.92) 30,034.06 58.15 21,615.94
General
Transfers Out 205,200.00 0.00 0.00 0.00 205,200.00
TOTAL General 205,200.00 0.00 0.00 0.00 205,200.00
TOTAL EXPENDITURES 12,500,050.00 865,065.78 2,345,291.80 18.76 10,154,808.20
REVENUES OVER/(UNDER) EXPENDITURES ( 336,600.00)( 746,346.51)( 1,792,820.91) 1,456,220.91
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
25.00$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE
General Fund
Taxes
101-3-0000-3111 Current Ad Valorem Taxes 9,758,500.00 0.00 0.00 0.00 9,758,500.00
101-3-0000-3119 MV Reduction ( 221,100.00) 0.00 0.00 0.00 ( 221,100.00)
101-3-0000-3121 Gravel Tax 75,000.00 0.00 0.00 0.00 75,000.00
TOTAL Taxes 9,612,400.00 0.00 0.00 0.00 9,612,400.00
Licenses & Perm its
101-3-0000-3211 Liquor License 53,000.00 115.00 115.00 0.22 52,885.00
101-3-0000-3212 Amusement License 1,000.00 0.00 195.00 19.50 805.00
101-3-0000-3213 Cigarette License 3,000.00 0.00 112.50 3.75 2,887.50
101-3-0000-3214 Apartment License 16,000.00 3,395.00 5,130.00 32.06 10,870.00
101-3-0000-3216 Mining License 20,000.00 2,771.80 2,771.80 13.86 17,228.20
101-3-0000-3217 Garbage Hauler License 4,000.00 0.00 555.00 13.88 3,445.00
101-3-0000-3218 Other Business License/Permit 14,000.00 610.00 5,240.00 37.43 8,760.00
101-3-0000-3229 NPDES Permit 2,500.00 0.00 525.00 21.00 1,975.00
101-3-0000-3231 Building Permit 100,000.00 4,070.80 17,096.40 17.10 82,903.60
101-3-0000-3232 Plumbing/Heating Permit 25,000.00 1,308.76 88,804.95 355.22 ( 63,804.95)
101-3-0000-3233 Permit Surcharge 200.00 ( 1,600.30) 1,580.06 790.03 ( 1,380.06)
101-3-0000-3235 Animal License 3,000.00 254.00 988.00 32.93 2,012.00
101-3-0000-3236 Parking Permit 3,000.00 0.00 120.00 4.00 2,880.00
101-3-0000-3237 Other Non-Business Lic/Permit 8,000.00 300.00 740.00 9.25 7,260.00
TOTAL Licenses & Permits 252,700.00 11,175.06 123,973.71 99.06 128,726.29
Intergovernmental Rev
101-3-0000-3311 Federal Grant
101-3-0000-3324 PERA Aid
101-3-0000-3325 Police 2$ Aid
101-3-0000-3326 Police Training Reimb
101-3-0000-3327 State-Aid Street Maint
101-3-0000-3329 State Crime Prevention Grant
101-3-0000-3330 Other State Grants
101-3-0000-3391 County Reimb/Grant
TOTAL Intergovernmental Rev
4,000.00 0.00 0.00
14,000.00 0.00 0.00
205,000.00 0.00 0.00
12,000.00 0.00 0.00
254,050.00 0.00 137,742.55
35,000.00 0.00 0.00
4,000.00 0.00 0.00
0.00 0.00 5,125.00
528,050.00 0.00 142,867.55
0.00 9,000.00
0.00 19,000.00
0.00 205,000.00
0.00 12,000.00
54.22 116,307.45
0.00 35,000.00
0.00 4,000.00
0.00 ( 5,125.00)
27.06 385,182.45
Charges far Services
101-3-0000-3412 Planning & Zoning Fees 15,000.00 1,020.00 2,280.00 15.20 12,720.00
101-3-0000-3413 Plan Check Fee 30,000.00 715.52 4,267.87 14.23 25,732.13
101-3-0000-3415 Special Assessment Search 600.00 40.00 320.00 53.33 280.00
101-3-0000-3417 Copies 1,500.00 312.89 910.14 60.68 589.86
101-3-0000-3418 Other General Govt Services 4,000.00 436.13 807.88 20.20 3,192.12
101-3-0000-3430 Lockout Fees 7,500.00 890.00 2,265.00 30.20 5,235.00
101-3-0000-3431 Police Services 2,000.00 30.50 235.75 11.79 1,764.25
101-3-0000-3432 School Liaison 75,000.00 0.00 37,500.00 50.00 37,500.00
101-3-0000-3434 Animal Impound Fee 3,000.00 150.00 350.00 11.67 2,650.00
101-3-0000-3436 Fire Contracts 194,000.00 0.00 84,902.72 43.76 109,097.28
9-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 4
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
REVENUES
25.00$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
101-3-0000-3437 Fire Calls
101-3-0000-3451 Street Services
101-3-0000-3452 Engineering Services Reimb
101-3-0000-3461 Recreation Fees
101-3-0000-3467 Concessions
101-3-0000-3472 Park Use Fee
101-3-0000-3474 Facility Use Fee
101-3-0000-3475 Building Rent
101-3-0000-3483 Sewer Inspection Fee
101-3-0000-3484 Contractor License Check
TOTAL Charges for Services
Fines & Forfeits
101-3-0000-3510 Court Fines
101-3-0000-3511 Parking Fines
TOTAL Fines & Forfeits
Special Assessments
Other Revenue
101-3-0000-3621 Interest Income
101-3-0000-3625 Refunds & Reimbursements
101-3-0000-3626 Contributions
101-3-0000-3629 Miscellaneous Revenue
TOTAL Other Revenue
Transfers In
101-3-0000-3925 Transfer-Landfill
101-3-0000-3929 Transfer-NSP/RDF Reserve
101-3-0000-3942 Transfer-WWTS
101-3-0000-3943 Transfer-Liquor
101-3-0000-3944 Transfer-Garbage
101-3-0000-3945 Transfer-Utilities
101-3-0000-3948 Transfer-EDA
101-3-0000-3949 Transfer-HRA
TOTAL Transfers In
TOTAL General Fund
12,163,450.00 118,719.27 552,420.89 4.54 11,611,029.11
4,000.00 0.00
30,000.00 1,370.00
99,100.00 3,645.32
123,000.00 22,501.98
14,100.00 0.00
18,000.00 29.12
6,200.00 593.10
13,200.00 200.00
2,500.00 0.00
400.00 20.00
643,100.00 31,954.51
0.00 0.00 4,000.00
1,900.00 6.33 28,100.00
3,815.32 3.85 95,284.68
56,418.40 45.87 66,581.60
0.00 0.00 14,100.00
920.82 5.12 17,079.18
1,495.59 24.12 4,704.41
1,050.00 7.95 12,150.00
195.00 7.80 2,305.00
70.00 17.50 330.00
199,704.49 31.05 443,395.51
120,000.00 10,483.84 18,530.60 15.44 101,469.40
10,000.00 3,630.00 11,425.50 114.26 ( 1,425.50)
130,000.00 14,113.84 29,956.10 23.04 100,043.90
120,000.00 0.00 ( 9,400.17) 7.83- 129,400.17
65,000.00 ( 4.36) 251.49 0.39 64,748.51
23,700.00 414.00 2,888.00 12.19 20,812.00
4,000.00 1,611.22 2,724.72 68.12 1,275.28
212,700.00 2,020.86 ( 3,535.96) 1.66- 216,235.96
35,000.00 0.00 0.00 0.00 35,000.00
39,500.00 0.00 0.00 0.00 39,500.00
75,000.00 0.00 0.00 0.00 75,000.00
270,000.00 0.00 0.00 0.00 270,000.00
25,000.00 0.00 0.00 0.00 25,000.00
300,000.00 59,455.00 59,455.00 19.82 240,545.00
25,000.00 0.00 0.00 0.00 25,000.00
15,000.00 0.00 0.00 0.00 15,000.00
784,500.00 59,455.00 59,455.00 7.58 725,045.00
TOTAL REVENUE 12,163,450.00 118,719.27 552,420.89 9.54 11,611,029.11
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 5
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
~ 101-GENERAL FUND
' DEPARTMENTAL EXPENDITURES
25.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE °s OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Mayor & Council
Personal Services
101-4-1110-4103 Part-time Pay
101-4-1110-4104 PERA
101-4-1110-4105 FICA
101-4-1110-4107 Medicare
101-4-1110-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-1110-4201 Office Supplies
TOTAL Supplies
Other Services & Charges
101-4-1110-9319 Other Professional Services
101-4-1110-4322 Postage
101-4-1110-4331 Travel, Conferences & Schools
101-4-1110-4359 Publishing
101-4-1110-4361 Insurance
101-4-1110-4433 Dues & Subscriptions
101-4-1110-4440 Miscellaneous
TOTAL Other Services & Charges
TOTAL Mayor & Council
Cable TV
Personal Services
101-4-1120-4101 Regular Pay
101-4-1120-4103 Part-time Pay
101-4-1120-9109 PERA
101-4-1120-4105 FICA
101-4-1120-4107 Medicare
101-4-1120-9108 Insurance
101-4-1120-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-1120-4201 Office Supplies
TOTAL Supplies
38,500.00 3,366.48 10,099.44 26.23 28,400.56
1,900.00 100.41 301.23 15.85 1,598.77
2,400.00 120.89 362.67 15.11 2,037.33
550.00 48.81 146.43 26.62 403.57
50.00 16.50 93.25 186.50 ( 43.25)
43,400.00 3,653.09 11,003.02 25.35 32,396.98
3,400.00 0.00 10.67 0.31 3,389.33
3,400.00 0.00 10.67 0.31 3,389.33
11,050.00 0.00 3,395.39 30.73 7,654.61
400.00 149.31 144.31 36.08 255.69
2,600.00 61.20 304.04 11.69 2,295.96
17,700.00 0.00 3,028.55 17.11 14,671.45
74,800.00 16,135.75 32,271.50 43.14 42,528.50
16,000.00 0.00 0.00 0.00 16,000.00
8,450.00 2,617.61 3,940.46 46.63 4,509.54
131,000.00 18,958.87 93,089.25 32.89 87,915.75
177,800.00 22,611.96 54,097.94 30.43 123,702.06
54,150.00 4,083.20 10,208.00 18.85 43,942.00
6,500.00 318.76 762.51 11.73 5,737.49
3,950.00 296.04 888.12 22.48 3,061.88
3,750.00 298.39 738.57 19.70 3,011.43
900.00 58.08 172.71 19.19 727.29
5,800.00 670.00 2,010.00 34.66 3,790.00
200.00 37.25 37.25 18.63 162.75
75,250.00 5,711.72 14,817.16 19.69 60,432.84
700.00 5.20 129.99 18.56 570.06
700.00 5.20 129.94 18.56 570.06
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 6
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
General Government
DEPARTMENTAL EXPENDITURES
25.00$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Other Services & Charges
101-4-1120-4322 Postage
101-4-1120-4331 Travel, Conferences & Schools
101-4-1120-9404 Equip Repair/Maint Services
TOTAL Other Services & Charges
Capital Outlay
TOTAL Cable TV
Administrative Services
Personal Services
101-4-1210-4101 Regular Pay
101-4-1210-4103 Part-time Pay
101-4-1210-4104 PERA
101-4-1210-4105 FICA
101-4-1210-4106 Other Retirement Contributions
101-4-1210-4107 Medicare
101-4-1210-4108 Insurance
101-4-1210-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-1210-4201 Office Supplies
TOTAL Supplies
Other Services & Charges
101-4-1210-4319 Other Professional Services
101-4-1210-4321 Telephone
101-4-1210-4322 Postage
101-4-1210-4331 Travel, Conferences & Schools
101-4-1210-4361 Insurance
101-4-1210-4404 Equip Repair/Maint Services
101-4-1210-4433 Dues & Subscriptions
TOTAL Other Services & Charges
Capital Outlay
50.00 0.00 0.00 0.00 50.00
1,650.00 0.00 21.42 1.30 1,628.58
150.00 0.00 0.00 0.00 150.00
1,850.00 0.00 21.42 1.16 1,828.58
77,800.00 5,716.92 19,968.52 19.24 62,831.48
296,450.00 22,806.28 57,015.71 19.23 239,434.29
44,900.00 2,165.42 5,894.73 13.13 39,005.27
24,750.00 1,810.43 5,468.36 22.09 19,281.64
21,150.00 1,501.53 4,649.97 21.99 16,500.03
4,800.00 900.00 1,200.00 25.00 3,600.00
4,950.00 351.15 1,087.96 21.97 3,862.54
28,500.00 2,100.02 6,300.06 22.11 22,199.94
1,800.00 494.25 961.50 53.42 838.50
427,300.00 31,629.08 82,577.79 19.33 344,722.21
9,500.00 189.38 944.81 9.95 8,555.19
9,500.00 189.38 944.81 9.95 8,555.19
5,500.00 0.00 5,326.00 96.87 172.00
800.00 70.20 131.73 16.47 668.27
1,000.00 166.57 166.57 16.66 833.43
5,300.00 0.00 400.00 7.55 4,900.00
100.00 73.75 197.50 147.50 ( 47.50)
23,050.00 1,073.67 3,971.11 17.23 19,078.89
1,100.00 0.00 400.00 36.36 700.00
36,850.00 1,384.19 10,594.91 28.62 26,305.09
~ TOTAL Administrative Services 473,650.00 33,202.65 94,067.51 19.86 379,582.49
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 7
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
General Government
DEPARTMENTAL EXPENDITURES
25.00$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Human Resources
Personal Services
101-4-1220-4101 Regular Pay
101-4-1220-4103 Part-time Pay
101-4-1220-9104 PERA
101-4-1220-4105 FICA
101-4-1220-4107 Medicare
101-4-1220-4108 Insurance
101-4-1220-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-1220-4201 Office Supplies
TOTAL Supplies
Other Services & Charges
101-4-1220-4319 Other Professional Services
101-4-1220-4322 Postage
101-4-1220-4331 Travel, Conferences & Schools
101-4-1220-4433 Dues & Subscriptions
101-4-1220-4440 Miscellaneous
TOTAL Other Services & Charges
Capital Outlay
67,850.00 5,219.29 13,092.24 19.30 54,757.76
48,350.00 3,972.96 9,982.09 20.65 38,367.91
8,450.00 666.44 2,022.12 23.93 6,927.88
7,200.00 524.69 1,663.36 23.10 5,536.64
1,700.00 122.70 388.98 22.88 1,311.02
5,800.00 1,234.01 2,206.01 38.03 3,593.99
600.00 160.00 319.00 53.17 281.00
139,950.00 11,900.04 29,673.80 21.20 110,276.20
3,200.00 186.71 1,973.68 61.68 1,226.32
3,200.00 186.71 1,973.68 61.68 1,226.32
3,000.00 105.00 105.00 3.50 2,895.00
350.00 286.30 286.30 81.80 63.70
2,350.00 191.17 211.06 8.98 2,138.94
900.00 0.00 0.00 0.00 900.00
1,000.00 92.05 211.75 21.18 788.25
7,600.00 674.52 814.11 10.71 6,785.89
TOTAL Human Resources
Elections
Personal Services
Supplies
Other Services & Charges
Capital Outlay
150,750.00 12,761.27 32,461.59 21.53 118,288.41
I Finance
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 6
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
General Government
DEPARTMENTAL EXPENDITURES
25.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-1310-4101 Regular Pay 287,800.00 22,139.36 55,348.42 19.23 232,451.58
101-4-1310-4104 PERA 20,850.00 1,605.10 9,815.30 23.09 16,034.70
101-4-1310-4105 FICA 17,850.00 1,290.78 3,871.10 21.69 13,978.90
101-4-1310-4107 Medicare 4,200.00 301.86 905.30 21.55 3,299.70
101-4-1310-4108 Insurance 25,850.00 2,100.01 6,300.03 29.37 19,549.97
101-4-1310-4109 Workers Comp 1,500.00 403.75 797.50 53.17 702.50
TOTAL Person al Services 358,050.00 27,840.86 72,037.65 20.12 286,012.35
Supplies
101-4-1310-4201 Office Supplies 3,850.00 197.25 324.91 8.44 3,525.09
TOTAL Suppli es 3,850.00 197.25 324.91 8.44 3,525.09
Other Services & Charges
101-4-1310-4301 Audit Fees 18,300.00 0.00 3,480.00 19.02 14,820.00
101-4-1310-4319 Other Professional Services 53,500.00 0.00 0.00 0.00 53,500.00
101-4-1310-4321 Telephone 800.00 60.70 125.53 15.69 674.47
101-4-1310-4322 Postage 3,600.00 504.93 504.93 14.03 3,095.07
101-4-1310-4331 Travel, Conferences & Schools 2,500.00 12.63 394.32 15.77 2,105.68
101-4-1310-4359 Publishing 1,300.00 0.00 0.00 0.00 1,300.00
101-4-1310-4404 Equip Repair/Maint Services 11,300.00 0.00 10,344.21 91.54 955.79
101-4-1310-4433 Dues & Subscriptions 1,500.00 225.00 735.00 49.00 765.00
TOTAL Other Services & Charges 92,800.00 803.26 15,583.99 16.79 77,216.01
Capital Outlay
TOTAL Finance
Information Technology
454,700.00 28,841.37 87,996.55 19.34 366,753.45
Personal Services
101-4-1350-4101 Regular Pay 128,400.00 9,875.46 24,688.65 19.23 103,711.35
101-4-1350-4103 Part-time Pay 5,000.00 0.00 0.00 0.00 5,000.00
101-4-1350-4104 PERA 9,300.00 715.98 2,197.94 23.10 7,152.06
101-4-1350-4105 FICA 8,250.00 573.76 1,699.94 20.61 6,550.06
101-4-1350-4107 Medicare 1,950.00 134.19 397.58 20.39 1,552.42
101-4-1350-4108 Insurance 19,850.00 1,626.01 4,878.03 24.57 14,971.97
101-4-1350-4109 Workers Comp 650.00 197.50 380.00 58.46 270.00
TOTAL Personal Services 173,400.00 13,122.90 34,192.14 19.72 139,207.86
Supplies
101-4-1350-4219 Operating Supplies 25,100.00 183.60 896.01 3.57 29,203.99
TOTAL Supplies 25,100.00 183.60 896.01 3.57 29,203.99
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 9
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
General Government
DEPARTMENTAL EXPENDITURES
25.00$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Other Services & Charges
101-4-1350-4319 Other Professional Services 8,000.00 60.00 60.00 0.75 7,940.00
101-4-1350-4321 Telephone 1,450.00 58.80 108.07 7.95 1,341.93
101-4-1350-4331 Travel, Conferences & Schools 8,000.00 47.33 87.33 1.09 7,912.67
101-4-1350-4404 Equip Repair/Maint Services 19,750.00 7,868.09 7,868.04 39.84 11,881.96
TOTAL Other Services & Charges 37,200.00 8,034.17 8,123.44 21.84 29,076.56
Capital Outlay
101-4-1350-4560 Equipment 30,900.00 0.00 10,900.00 35.28 20,000.00
TOTAL Capital Outlay 30,900.00 0.00 10,900.00 35.28 20,000.00
TOTAL Information Technology
Legal
Supplies
Other Services & Charges
101-4-1400-4304 Legal Fees
TOTAL Other Services & Charges
266,600.00 21,390.67 54,111.59 20.30 212,488.41
240,000.00 26,223.45 44,003.45 18.33 195,996.55
240,000.00 26,223.45 44,003.45 18.33 195,996.55
TOTAL Legal
Community Development
240,000.00 26,223.45 44,003.45 18.33 195,996.55
Personal Services
101-4-1500-4101 Regular Pay 52,700.00 4,052.80 10,132.02 19.23 42,567.98
101-4-1500-4104 PERA 3,800.00 293.82 881.46 23.20 2,918.54
101-4-1500-4105 FICA 3,250.00 291.54 724.62 22.30 2,525.38
101-4-1500-4107 Medicare 750.00 56.48 169.44 22.59 580.56
101-4-1500-4108 Insurance 5,800.00 486.00 1,458.00 25.14 4,342.00
101-4-1500-4109 Workers Comp 250.00 196.00 392.00 156.80 ( 142.00)
TOTAL Personal Services 66,550.00 5,326.64 13,757.54 20.67 52,792.46
Supplies
101-4-1500-4201 Office Supplies 150.00 0.00 0.00 0.00 150.00
TOTAL Supplies 150.00 0.00 0.00 0.00 150.00
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 10
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
General Government
DEPARTMENTAL EXPENDITURES
25.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Other Services & Charges
101-4-1500-4331 Travel, Conferences & Schools 400.00 0.00
TOTAL Other Services & Charges 400.00 0.00
0.00 0.00 400.00
0.00 0.00 400.00
TOTAL Community Development
Planning
67,100.00 5,326.64 13,757.54 20.50 53,342.46
Personal Services
101-4-1510-4101 Regular Pay 211,900.00 16,301.68 40,754.20 19.23 171,145.80
101-4-1510-4104 PERA 15,350.00 1,181.88 3,545.69 23.10 11,804.36
101-4-1510-4105 FICA 13,150.00 922.90 2,768.70 21.05 10,381.30
101-4-1510-4107 Medicare 3,100.00 215.84 647.52 20.89 2,452.48
101-4-1510-4108 Insurance 28,300.00 2,324.03 6,972.09 24.69 21,327.91
101-4-1510-4109 Workers Comp 700.00 287.50 573.00 81.86 127.00
TOTAL Personal Services 272,500.00 21,233.83 55,261.15 20.28 217,238.85
Supplies
101-4-1510-4201 Office Supplies 4,750.00 952.18 1,158.16 24.38 3,591.84
101-4-1510-4212 Fuels & Lubs 1,850.00 187.91 287.75 15.55 1,562.25
101-4-1510-4219 Operating Supplies 0.00 175.00 175.00 0.00 ( 175.00)
TOTAL Supplies 6,600.00 1,315.09 1,620.91 24.56 4,979.09
Other Services & Charges
101-4-1510-4321 Telephone 1,150.00 50.82 125.92 10.95 1,024.08
101-4-1510-4322 Postage 3,200.00 469.60 469.60 19.68 2,730.40
101-4-1510-4331 Travel, Conferences & Schools 3,000.00 286.00 821.00 27.37 2,179.00
101-4-1510-4359 Publishing 8,000.00 165.00 262.50 3.28 7,737.50
101-4-1510-4361 Insurance 400.00 103.50 207.00 51.75 193.00
101-4-1510-4404 Equip Repair/Maint Services 6,900.00 342.59 665.14 9.64 6,234.86
101-4-1510-4933 Dues & Subscriptions 1,000.00 0.00 80.00 8.00 920.00
101-4-1510-4940 Miscellaneous 0.00 138.00 138.00 0.00 ( 138.00)
101-4-1510-4960 Equip Replacement Charge 800.00 66.66 199.98 25.00 600.02
TOTAL Other Services & Charges 24,450.00 1,622.17 2,969.19 12.14 21,480.86
Capital Outlay
TOTAL Planning
City Hall Maintenance
---------------------
---------------------
303,550.00 24,171.09 59,851.20 19.72 243,698.80
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 11
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
I 101-GENERAL FUND
General Government
I DEPARTMENTAL EXPENDITURES
CURRENT CURRENT YEAR TO DATE
BUDGET PERIOD ACTUAL
25.00$ OF YEAR COMP.
°s OF BUDGET
BUDGET BALANCE
Personal Services
101-4-1600-4101 Regular Pay
101-4-1600-9102 Overtime Pay
101-4-1600-4103 Part-time Pay
101-4-1600-4104 PERA
101-4-1600-4105 FICA
101-4-1600-4107 Medicare
101-4-1600-4108 Insurance
101-4-1600-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-1600-4212 Fuels & Lubs
101-4-1600-4217 Uniform Allowance
101-4-1600-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-1600-4321 Telephone
101-4-1600-4331 Travel, Conferences & Schools
101-4-1600-4361 Insurance
101-4-1600-4389 Utilities
101-9-1600-4401 Bldg Repair/Maint Services
101-4-1600-4904 Equip Repair/Maint Services
101-4-1600-4960 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
TOTAL City Hall Maintenance
Contingency
Other Services & Charges
101-4-1900-4440 Miscellaneous
TOTAL Other Services & Charges
104,350.00 7,757.46 19,466.84 18.66 84,883.16
2,500.00 0.00 0.00 0.00 2,500.00
19,050.00 1,172.00 2,944.65 15.46 16,105.35
9,150.00 647.39 2,045.77 22.36 7,104.23
7,800.00 565.57 1,756.60 22.52 6,043.40
1,800.00 132.28 410.85 22.83 1,389.15
17,200.00 1,173.58 4,078.72 23.71 13,121.28
5,850.00 1,229.00 2,458.00 42.02 3,392.00
167,700.00 12,677.28 33,161.43 19.77 134,538.57
3,450.00 327.63 540.28 15.66 2,909.72
1,700.00 322.30 631.69 37.16 1,068.31
28,900.00 747.60 4,619.80 15.99 24,280.20
34,050.00 1,397.53 5,791.77 17.01 28,258.23
12,250.00 1,151.45 3,325.49 27.15 8,924.51
1,500.00 0.00 200.00 13.33 1,300.00
4,850.00 1,186.25 2,372.50 48.92 2,477.50
43,800.00 4,423.48 8,747.89 19.97 35,052.11
30,600.00 1,109.72 3,971.50 12.98 26,628.50
5,000.00 0.00 0.00 0.00 5,000.00
1,100.00 91.67 275.01 25.00 824.99
99,100.00 7,962.57 18,892.39 19.06 80,207.61
300,850.00 22,037.38 57,845.59 19.23 243,004.41
75,000.00 0.00 0.00 0.00 75,000.00
75,000.00 0.00 0.00 0.00 75,000.00
I TOTAL Contingency
75,000.00 0.00 0.00 0.00 75,000.00
TOTAL General Government 2,587,800.00 202,233.40 513,111.48 19.83 2,074,688.52
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 12
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
Public Safety 25.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE °s OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Police Administration
Personal Services
101-4-2110-4101 Regular Pay 275,400.00 20,888.14 50,220.32 18.24 225,179.68
101-4-2110-4104 PERA 39,650.00 3,007.90 8,255.69 20.82 31,394.31
101-4-2110-4107 Medicare 2,750.00 191.10 496.66 18.06 2,253.34
101-4-2110-4108 Insurance 25,650.00 1,844.02 5,074.06 19..78 20,575.94
101-4-2110-4109 Workers Comp 59,350.00 14,919.25 29,294.50 49.36 30,055.50
TOTAL Personal Services 902,800.00 40,850.41 93,391.23 23.17 309,458.77
Supplies
101-4-2110-4201 Office Supplies 19,000.00 571.58 1,712.09 9.01 17,287.91
101-4-2110-4217 Uniform Allowance 2,250.00 763.69 990.75 44.03 1,259.25
101-4-2110-4219 Operating Supplies 9,600.00 61.25 141.80 3.08 4,458.20
TOTAL Supplies 25,850.00 1,396.52 2,844.64 11.00 23,005.36
Other Services & Charges
101-4-2110-4319 Other Professional Services 4,950.00 36.12 322.39 6.51 4,627.61
101-4-2110-4321 Telephone 29,300.00 1,817.56 4,079.89 13.91 25,225.11
101-4-2110-4322 Postage 2,200.00 442.82 452.24 20.56 1,747.76
101-4-2110-4331 Travel, Conferences & Schools 3,35D.00 276.25 1,251.25 37.35 2,098.75
101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00
101-4-2110-4361 Insurance 9,600.00 1,750.25 3,500.50 36.46 6,099.50
101-4-2110-4904 Equip Repair/Maint Services 75,250.00 740.92 44,391.57 58.99 30,858.43
101-4-2110-4433 Dues & Subscriptions 9,200.00 0.00 4,526.25 49.20 4,673.75
101-4-2110-4437 Taxes & Licenses 800.00 0.00 183.75 22.97 616.25
TOTAL Other Services & Charges 135,150.00 5,063.92 58,702.84 43.44 76,497.16
Capital Outlay
TOTAL Police Administration
Patrol
563,800.00 47,310.85 154,888.71 27.47 408,911.29
Personal Services
101-4-2120-4101 Regular Pay 1,444,350.00 104,892.43 258,811.42 17.92 1,185,538.58
101-4-2120-4102 Overtime Pay 90,000.00 1,191.56 5,575.63 6.20 84,424.37
101-4-2120-4104 PERA 220,950.00 15,075.02 45,553.22 20.62 175,396.78
101-4-2120-4107 Medicare 19,950.00 1,234.26 3,723.36 18.66 16,226.64
101-4-2120-4108 Insurance 171,450.00 13,516.64 40,795.12 23.79 130,654.88
TOTAL Personal Services 1,946,700.00 135,909.91 359,458.75 18.21 1,592,241.25
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 13
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
I 101-GENERAL FUND
Public Safety
' DEPARTMENTAL EXPENDITURES
CURRENT CURRENT YEAR TO DATE
BUDGET PERIOD ACTUAL
25.OOs OF YEAR COMP.
~ OF BUDGET
BUDGET BALANCE
Supplies
101-4-2120-4212 Fuels & Lubs
101-4-2120-9217 Uniform Allowance
101-4-2120-4219 Operating Supplies
101-4-2120-4221 Equipment Parts
TOTAL Supplies
Other Services & Charges
101-4-2120-4331 Travel, Conferences & Schools
101-4-2120-4404 Equip Repair/Maint Services
101-4-2120-4433 Dues & Subscriptions
101-4-2120-4460 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
108,500.00 9,431.81 17,250.86 15.90 91,249.14
23,900.00 767.42 1,758.66 7.36 22,141.34
58,650.00 1,350.75 10,953.38 17.82 48,196.62
28,000.00 974.19 1,547.39 5.53 26,452.61
219,050.00 12,524.17 31,010.29 14.16 188,039.71
15,650.00 2,105.37 2,185.98 13.97 13,464.02
26,700.00 371.20 3,466.27 12.98 23,233.73
550.00 0.00 340.00 61.82 210.00
44,150.00 3,679.17 11,037.51 25.00 33,112.49
87,050.00 6,155.74 17,029.76 19.56 70,020.24
TOTAL Patrol
Investigations
Personal Services
101-4-2130-4101 Regular Pay
101-4-2130-9102 Overtime Pay
101-4-2130-4104 PERA
101-4-2130-4107 Medicare
101-4-2130-4108 Insurance
TOTAL Personal Services
Supplies
101-4-2130-4217 Uniform Allowance
101-4-2130-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-2130-9319 Other Professional Services
101-4-2130-9331 Travel, Conferences & Schools
101-4-2130-4433 Dues & Subscriptions
101-4-2130-4460 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
2,252,800.00 159,589.82 402,498.80 17.87 1,850,301.20
505,600.00 32,452.80 86,820.01 17.17 418,779.99
45,000.00 1,019.10 2,215.95 4.92 42,784.05
79,300.00 4,819.93 15,500.71 19.55 63,799.29
5,850.00 348.67 1,128.88 19.30 4,721.12
70,100.00 5,434.07 17,373.35 24.78 52,726.65
705,850.00 44,074.57 123,038.90 17.43 582,811.10
5,150.00 488.97 593.12 11.52 9,556.88
8,700.00 404.09 817.50 9.40 7,882.50
13,850.00 892.56 1,410.62 10.18 12,439.38
11,900.00 260.13 730.39 6.14 11,169.61
5,550.00 ( 415.00) 885.00 15.95 4,665.00
1,050.00 0.00 150.00 14.29 900.00
14,250.00 1,187.50 3,562.50 25.00 10,687.50
32,750.00 1,032.63 5,327.89 16.27 27,422.11
TOTAL Investigations 752,450.00 95,999.76 129,777.41 17.25 622,672.59
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 19
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
Public Safety 25.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Police Support Services
Personal Services
101-4-2150-4101 Regular Pay 347,050.00 25,952.80 66,315.67 19.11 280,734.33
101-9-2150-4102 Overtime Pay 3,500.00 ( 178.02) 0.00 0.00 3,500.00
101-9-2150-4104 PERA 25,400.00 1,946.91 5,961.48 23.47 19,438.52
101-4-2150-4105 FICA 21,750.00 1,614.76 4,844.28 22.27 16,905.72
101-9-2150-4107 Medicare 5,100.00 380.10 1,151.62 22.58 3,948.38
101-4-2150-4108 Insurance 46,350.00 3,763.23 11,427.01 24.65 34,922.99
TOTAL Personal Services 449,150.00 32,979.78 89,700.06 19.97 359,449.94
Supplies
101-4-2150-4201 Office Supplies 1,000.00 260.71 260.71 26.07 739.29
101-4-2150-4217 Uniform Allowance 3,000.00 1.03 16.03 0.53 2,983.97
101-4-2150-4219 Operating Supplies 10,100.00 1,114.82 1,479.51 14.65 8,620.49
TOTAL Supplies 14,100.00 1,376.56 1,756.25 12.46 12,393.75
Other Services & Charges
101-4-2150-9331 Travel, Conferences & Schools 3,550.00 125.00 125.00 3.52 3,425.00
101-4-2150-4404 Equip Repair/Maint Services 1,850.00 0.00 0.00 0.00 1,850.00
101-4-2150-4409 Contractual Services 16,000.00 275.44 1,663.53 10.40 14,336.47
101-4-2150-4433 Dues & Subscriptions 500.00 0.00 233.33 46.67 266.67
101-4-2150-4460 Equip Replacement Charge 6,550.00 545.83 1,637.99 25.00 9,912.51
TOTAL Other Services & Charges 28,950.00 946.27 3,659.35 12.86 24,790.65
Capital Outlay
TOTAL Police Support Services
Police Reserves
---------------
---------------
491,700.00 35,302.61 95,115.66 19.34 396,584.34
Personal Services
101-9-2160-4103 Part-time Pay 5,500.00 1,708.80 2,753.44 50.06 2,746.56
101-4-2160-4105 FICA 350.00 105.95 223.68 63.91 126.32
101-4-2160-4107 Medicare 100.00 24.78 52.32 52.32 47.68
101-4-2160-4109 Workers Comp 0.00 1,026.00 1,026.00 0.00 ( 1,026.00)
TOTAL Personal Services 5,950.00 2,865.53 4,055.44 68.16 1,894.56
Supplies
101-4-2160-4217 Uniform Allowance 5,000.00 0.00 0.00 0.00 5,000.00
101-4-2160-4219 Operating Supplies 6,000.00 177.41 177.41 2.96 5,822.59
TOTAL Supplies 11,000.00 177.41 177.41 1.61 10,822.59
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 15
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
Public Safety 25.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Other Services & Charges
101-4-2160-4319 Other Professional Services 1,500.00 0.00 0.00 0.00 1,500.00
101-4-2160-4321 Telephone 1,600.00 0.00 0.00 0.00 1,600.00
101-4-2160-4331 Travel, Conferences & Schools 1,700.00 100.00 100.00 5.88 1,600.00
101-4-2160-4359 Publishing 150.00 0.00 D.00 0.00 150.00
101-4-2160-4433 Dues & Subscriptions 1,000.00 585.00 585.00 58.50 415.00
TOTAL Other Services & Charges 5,950.00 685.00 685.00 11.51 5,265.00
Capital Outlay
TOTAL Police Reserves 22,900.00 3,727.94 9,917.85 21.48 17,982.15
Public safety building
Personal Services
101-4-2190-4101 Regular Pay 101,850.00 7,313.20 18,280.98 17.95 83,569.02
101-4-2190-4104 PERA 7,400.00 530.19 1,567.69 21.19 5,832.31
101-4-2190-4105 FICA 6,300.00 443.34 1,304.75 20.71 4,995.25
101-4-2190-9107 Medicare 1,500.00 103.68 305.15 20.34 1,194.85
101-4-2190-4108 Insurance 13,300.00 1,076.61 3,119.28 23.45 10,180.72
101-4-2190-4109 Workers Comp 3,400.00 831.75 1,837.50 59.04 1,562.50
TOTAL Personal Services 133,750.00 10,298.77 26,415.35 19.75 107,334.65
Supplies
101-4-2190-4219 Operating Supplies 15,000.00 495.95 2,812.56 18.75 12,187.44
TOTAL Supplies 15,000.00 495.95 2,812.56 18.75 12,187.44
Other Services & Charges
101-4-2190-4361 Insurance 6,750.00 1,285.00 2,570.00 38.07 4,180.00
101-4-2190-4389 Utilities 18,200.00 3,490.56 6,560.67 36.05 11,639.33
101-4-2190-4401 Bldg Repair/Maint Services 31,300.00 24.53 1,686.29 5.39 29,613.71
TOTAL Other Services & Charges 56,250.00 4,800.09 10,816.96 19.23 45,433.04
Capital Outlay
TOTAL Public safety building 205,000.00 15,544.81 40,044.87 19.53 164,955.13
Fire Administration
Personal Services
101-4-2310-4101 Regular Pay 86,200.00 6,826.54 17,160.27 19.91 69,039.73
101-4-2310-4103 Part-time Pay 186,250.00 15,152.12 36,436.88 19.56 149,813.12
101-4-2310-4104 PERA 13,500.00 1,064.23 3,154.00 23.36 10,396.00
101-4-2310-4105 FICA 12,500.00 883.68 2,515.69 20.13 9,984.31
101-4-2310-4106 Other Retirement Contributions 38,500.00 0.00 0.00 0.00 38,500.00
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 16
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
Public Safety
DEPARTMENTAL EXPENDITURES
CURRENT CURRENT
BUDGET PERIOD
25.00$ OF YEAR COMP.
YEAR TO DATE $ OF BUDGET
ACTUAL BUDGET BALANCE
101-4-2310-4107 Medicare 3,950.00 284.18 820.84 20.78 3,129.16
101-4-2310-4108 Insurance 7,200.00 1,013.43 2,924.66 40.62 4,275.34
101-4-2310-4109 Workers Comp 20,200.00 4,793.50 10,039.00 49.70 10,161.00
TOTAL Personal Services 368,300.00 30,017.68 73,051.34 19.83 295,248.66
Supplies
101-9-2310-4201 Office Supplies 5,150.00 0.00 233.22 4.53 4,916.78
101-4-2310-4212 Fuels & Lubs 7,350.00 461.26 892.24 12.14 6,457.76
101-4-2310-4217 Uniform Allowance 4,400.00 25.99 25.99 0.59 4,374.01
101-9-2310-4219 Operating Supplies 26,150.00 1,453.45 3,035.57 11.61 23,114.43
101-4-2310-4221 Equipment Parts 7,400.00 958.68 958.68 12.96 6,441.32
TOTAL Supplies 50,450.00 2,899.38 5,145.70 10.20 45,304.30
Other Services & Charges
101-4-2310-9319 Other Professional Services 5,100.00 0.00 1,870.00 36.67 3,230.00
101-4-2310-9321 Telephone 4,950.00 158.84 440.81 8.91 4,509.19
101-4-2310-4322 Postage 500.00 83.64 83.69 16.73 416.36
101-4-2310-9331 Travel, Conferences & Schools 27,450.00 1,331.48 1,465.03 5.39 25,984.97
101-4-2310-9359 Publishing 300.00 0.00 0.00 0.00 300.00
101-4-2310-4361 insurance 17,500.00 3,733.75 7,467.50 42.67 10,032.50
101-4-2310-4389 Utilities 15,150.00 1,954.89 4,178.98 27.58 10,971.02
101-4-2310-4401 Bldg Repair/Maint Services 5,650.00 0.00 160.32 2.84 5,489.68
101-4-2310-4404 Equip Repair/Maint Services 31,550.00 1,020.25 8,826.15 27.98 22,723.85
101-4-2310-4433 Dues & Subscriptions 1,950.00 0.00 895.00 45.90 1,055.00
101-4-2310-4460 Equip Replacement Charge 29,650.00 2,470.83 7,412.49 25.00 22,237.51
TOTAL Other Services & Charges 139,750.00 10,753.68 32,799.92 23.47 106,950.08
Capital Outlay
101-4-2310-4560 Equipment 31,100.00 323.95 10,718.95 34.47 20,381.05
TOTAL Capital Outlay 31,100.00 323.95 10,718.95 34.47 20,381.05
TOTAL Fire Adm inistration 589,600.00 43,994.69 121,715.91 20.64 467,884.09
Fire Inspections
Personal Services
101-4-2320-4101 Regular Pay 129,400.00 9,940.08 24,850.20 19.20 104,599.80
101-4-2320-4104 PERA 14,850.00 1,141.60 3,424.80 23.06 11,425.20
101-4-2320-4105 FICA 3,250.00 278.02 847.22 26.07 2,402.78
101-4-2320-4107 Medicare 1,900.00 146.72 443.23 23.33 1,456.77
101-4-2320-4108 Insurance 14,850.00 1,195.86 3,587.58 24.16 11,262.42
TOTAL Personal Services 164,250.00 12,702.28 33,153.03 20.18 131,096.97
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 17
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
Public Safety
DEPARTMENTAL EXPENDITURES
25.00$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Supplies
101-4-2320-4201 Office Supplies
101-4-2320-4212 Fuels & Lubs
101-4-2320-4217 Uniform Allowance
101-4-2320-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-2320-4321 Telephone
101-4-2320-4331 Travel, Conferences & Schools
101-4-2320-4404 Equip Repair/Maint Services
101-4-2320-9433 Dues & Subscriptions
TOTAL Other Services & Charges
2,750.00 0.00 0.00 0.00 2,750.00
3,200.00 414.96 755.91 23.62 2,444.09
1,400.00 0.00 0.00 0.00 1,900.00
4,450.00 0.00 0.00 0.00 4,450.00
11,800.00 414.96 755.91 6.41 11,049.09
2,950.00 125.21 309.69 .10..50 2,640.31
2,500.00 260.00 260.00 10.40 2,240.00
2,000.00 0.00 0.00 0.00 2,000.00
1,350.00 0.00 0.00 0.00 1,350.00
8,800.00 385.21 569.69 6.47 8,230.31
TOTAL Fire Inspections
Emergency Management
Personal Services
101-4-2330-4101 Regular Pay
101-4-2330-4104 PERA
101-4-2330-4107 Medicare
101-4-2330-4108 Insurance
TOTAL Personal Services
Supplies
101-4-2330-4201 Office Supplies
101-4-2330-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-2330-4321 Telephone
101-4-2330-4331 Travel, Conferences & Schools
101-4-2330-4389 Utilities
101-4-2330-4404 Equip Repair/Maint Services
101-4-2330-4433 Dues & Subscriptions
TOTAL Other Services & Charges
Capital Outlay
101-4-2330-4560 Equipment
TOTAL Capital Outlay
184,850.00 13,502.45 34,478.63 18.65 150,371.37
8,900.00 668.04 1,670.10 18.77 7,229.90
1,300.00 96.20 288.60 22.20 1,011.40
150.00 9.70 29.10 19.40 120.90
600.00 39.84 119.52 19.92 480.48
10,950.00 813.78 2,107.32 19.24 8,842.68
500.00 0.00 0.00 0.00 500.00
9,150.00 0.00 0.00 0.00 9,150.00
9,650.00 0.00 0.00 0.00 9,650.00
1,650.00 26.00 75.43 4.57 1,574.57
9,000.00 40.80 40.80 1.02 3,959.20
1,500.00 106.88 211.10 14.07 1,288.90
7,800.00 155.00 347.38 4.45 7,452.62
100.00 0.00 100.00 100.00 0.00
15,050.00 328.68 774.71 5.15 14,275.29
71,750.00 0.00 0.00 0.00 71,750.00
71,750.00 0.00 0.00 0.00 71,750.00
TOTAL Emergency Management
107,400.00 1,142.46 2,882.03 2.68 104,517.97
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 18
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
Public Safety
DEPARTMENTAL EXPENDITURES
25.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Building Safety
Personal Services
101-4-2410-4101 Regular Pay
101-4-2410-4103 Part-time Pay
101-4-2410-4104 PERA
101-4-2410-4105 FICA
101-4-2410-4107 Medicare
101-4-2410-4108 Insurance
101-4-2410-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-2910-4201 Office Supplies
101-4-2410-4212 Fuels & Lubs
101-4-2410-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-2410-4321 Telephone
101-4-2410-4322 Postage
101-4-2410-9331 Travel, Conferences & Schools
101-4-2910-4361 Insurance
101-4-2410-4404 Equip Repair/Maint Services
101-4-2410-4433 Dues & Subscriptions
101-4-2410-4460 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
319,400.00 24,596.21 61,448.44 19.24 257,951.56
25,950.00 1,930.82 4,964.39 19.13 20,985.61
25,050.00 1,923.24 5,779.16 23.07 19,270.84
21,400.00 1,532.57 4,605.79 21.52 16,794.21
5,000.00 358.42 1,077.16 21.54 3,922.84
40,150.00 3,286.02 9,858.06 29.55 30,291.94
1,200.00 371.25 741.50 61.79 458.50
438,150.00 33,998.53 88,474.50 20.19 349,675.50
2,500.00 83.18 302.13 12.09 2,197.87
4,700.00 307.81 602.18 12.81 4,097.82
2,250.00 0.00 80.16 3.56 2,169.84
9,450.00 390.99 984.47 10.42 8,465.53
1,600.00 164.97 335.96 21.00 1,264.04
400.00 53.66 53.66 13.42 346.34
4,650.00 125.00 1,495.00 32.15 3,155.00
900.00 149.75 299.50 33.28 600.50
7,200.00 211.03 2,965.84 41.19 4,234.16
1,200.00 0.00 75.00 6.25 1,125.00
1,650.00 137.50 412.50 25.00 1,237.50
17,600.00 841.91 5,637.46 32.03 11,962.54
TOTAL Building Safety
Environmental
465,200.00 35,231.93 95,096.43 20.44 370,103.57
Personal Services
101-4-2440-4101 Reqular Pay 39,050.00 3,002.80 7,506.98' 19.22 31,543.02
101-4-2440-4104 PERA 2,850.00 217.70 644.14 22.60 2,205.86
101-4-2440-4105 FICA 2,400.00 160.96 475.21 19.80 1,924.79
101-4-2440-4107 Medicare 550.00 37.64 111.13 20.21 438.87
101-4-2440-4108 Insurance 4,850.00 479.59 1,438.78 29.67 3,411.22
101-4-2440-4109 Workers Comp 400.00 96.75 233.50 58.38 166.50
TOTAL Personal Services 50,100.00 3,995.44 10,409.74 20.78 39,690.26
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 19
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
Public Safety
DEPARTMENTAL EXPENDITURES
25.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE a OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Supplies
101-4-2440-4201 Office Supplies
101-4-2440-4212 Fuels & Lubs
TOTAL Supplies
Other Services & Charges
101-4-2440-4321 Telephone
101-4-2440-4322 Postage
101-4-2440-4331 Travel, Conferences & Schools
101-4-2440-4359 Publishing
101-4-2490-4361 Insurance
101-4-2440-4409 Contractual Services
101-4-2440-9433 Dues & Subscriptions
TOTAL Other Services & Charges
650.00 31.19 67.55 10.39 582.45
150.00 6.32 16.78 11.19 133.22
800.00 37.51 84.33 10.59 715.67
700.00 50.95 103.87 14.89 596.13
500.00 397.53 397.53 79.51 102.47
500.00 165.00 165.00 33.00 335.00
100.00 0.00 67.50 67.50 32.50
200.00 0.00 0.00 0.00 200.00
3,000.00 0.00 0.00 0.00 3,000.00
1,050.00 0.00 40.00 3.81 1,010.00
6,050.00 613.48 773.90 12.79 5,276.10
TOTAL Environmental
56,950.00 4,646.43 11,267.97 19.79 45,682.03
TOTAL Public Safety
Street Maintenance
5,692,650.00 400,993.25 1,092,684.27 19.19 4,599,965.73
Personal Services
101-4-3120-4101 Regular Pay 926,650.00 23,612.63 46,512.98 10.90 380,137.02
101-4-3120-4103 Part-time Pay 78,400.00 3,719.37 9,242.01 11.79 69,157.99
101-4-3120-4104 PERA 34,950.00 1,981.58 4,671.99 13.37 30,278.01
101-4-3120-4105 FICA 31,300.00 1,603.41 3,789.34 12.11 27,510.66
101-4-3120-4107 Medicare 7,350.00 374.98 886.21 12.06 6,463.79
101-4-3120-4108 Insurance 57,050.00 2,653.51 7,452.08 13.06 49,597.92
101-4-3120-9109 Workers Comp 25,050.00 7,068.00 13,188.00 52.65 11,862.00
TOTAL Person al Services 660,750.00 41,013.48 85,742.61 12.98 575,007.39
Supplies
101-4-3120-4201 Office Supplies 3,600.00 23.68 42.56 1.18 3,557.44
101-4-3120-4212 Fuels & Lubs 64,250.00 ( 7,025.22) 15,915.23 24.77 48,334.77
101-4-3120-4219 Operating Supplies 146,750.00 2,009.37 9,772.61 6.66 136,977.39
101-4-3120-4226 Street Signs 42,000.00 1,975.79 2,017.47 4.80 39,982.53
TOTAL Suppli es 256,600.00 ( 3,021.38) 27,747.87 10.81 228,852.13
Other Services & Charges
101-4-3120-4319 Other Professional Services 250.00 0.00 0.00 0.00 250.00
101-4-3120-4321 Telephone 8,950.00 455.17 1,033.07 11.59 7,916.93
101-4-3120-4322 Postage 200.00 24.07 16.15 8.08 183.85
101-4-3120-4331 Travel, Conferences & Schools 3,000.00 0.00 276.66 9.22 2,723.34
101-4-3120-4359 Publishing 500.00 0.00 0.00 0.00 500.00
101-4-3120-4361 Insurance 17,250.00 4,358.25 8,716.50 50.53 8,533.50
101-4-3120-4389 Utilities 36,000.00 4,539.17 8,368.88 23.25 27,631.12
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 20
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
Public Works
~ DEPARTMENTAL EXPENDITURES
101-4-3120-9401 Bldg Repair/Maint Services
101-4-3120-4404 Equip Repair/Maint Services
101-4-3120-4409 Contractual Services
101-4-3120-4415 Equipment Rental
101-4-3120-4417 Uniform Rental
101-4-3120-4433 Dues & Subscriptions
101-4-3120-4437 Taxes & Licenses
101-4-3120-4460 Equip Replacement Charge
TOTAL Other Services & Charges
I Capital Outlay
25.00$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
4,500.00 426.93 923.87 20.53 3,576.13
5,000.00 6.19 2,528.03 50.56 2,471.97
422,750.00 8,299.59 8,299.59 1.96 414,450.41
10,000.00 192.38 192.38 1.92 9,807.62
4,700.00 252.06 393.60 8.37 4,306.40
350.00 0.00 181.25 51.79 168.75
500.00 58.25 83.25 16.65 416.75
93,150.00 7,762.50 23,287.50 25.00 69,862.50
607,100.00 26,374.06 54,300.73 8.94 552,799.27
TOTAL Street Maintenance
I Snow-Removal
I Personal Services
101-4-3130-4101 Regular Pay
101-4-3130-4102 Overtime Pay
101-4-3130-4104 PERA
101-4-3130-4105 FICA
101-4-3130-4107 Medicare
101-4-3130-4108 Insurance
101-4-3130-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-3130-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
Capital Outlay
1,524,450.00 64,366.16 167,791.21 11.01 1,356,658.79
115,500.00 18,892.30 62,876.91 54.44 52,623.09
15,000.00 9,917.88 15,160.37 101.07 ( 160.37)
9,050.00 2,052.50 7,081.52 78.25 1,968.48
8,100.00 1,637.96 5,682.26 70.15 2,417.74
1,900.00 382.96 1,328.87 69.94 571.13
15,950.00 4,067.47 11,968.66 75.04 3,981.34
7,350.00 40.00 1,736.00 23.62 5,614.00
172,850.00 36,490.57 105,839.59 61.23 67,015.41
90,000.00 20,784.34 73,729.74 81.92 16,270.26
90,000.00 20,784.34 73,729.74 81.92 16,270.26
TOTAL Snow Removal
I Equipment-Services
Personal Services
101-4-3150-4101 Regular Pay
101-4-3150-4102 Overtime Pay
101-4-3150-4104 PERA
101-4-3150-4105 FICA
101-4-3150-4107 Medicare
101-4-3150-4108 Insurance
101-4-3150-4109 Workers Comp
TOTAL Personal Services
262,850.00 57,274.91 179,564.33 68.31 83,285.67
162,750.00 11,209.64 27,123.43 16.67 135,626.57
0.00 41.39 41.39 0.00 ( 41.39)
11,800.00 815.70 2,277.43 19.30 9,522.57
10,100.00 652.00 1,812.54 17.95 8,287.46
2,350.00 152.48 423.91 18.09 1,926.09
22,700.00 1,199.30 3,978.09 17.52 18,721.91
7,050.00 836.50 1,836.00 26.04 5,214.00
216,750.00 14,907.01 37,492.79 17.30 179,257.21
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 21
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
' 101-GENERAL FUND
Public Works
~ DEPARTMENTAL EXPENDITURES
Supplies
101-4-3150-4219 Operating Supplies
101-4-3150-4221 Equipment Parts
TOTAL Supplies
Other Services & Charges
101-4-3150-4404 Equip Repair/Maint Services
101-4-3150-4417 Uniform Rental
TOTAL Other Services & Charges
Capital Outlay
TOTAL Equipment Services
Engineering
Personal Services
101-4-3300-4101 Regular Pay
101-4-3300-9104 PERA
101-4-3300-4105 FICA
101-4-3300-4107 Medicare
101-4-3300-4108 Insurance
101-4-3300-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-3300-4201 Office Supplies
101-4-3300-4212 Fuels & Lubs
101-4-3300-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-3300-4319 Other Professional Services
101-4-3300-4321 Telephone
101-4-3300-4322 Postage
101-4-3300-4331 Travel, Conferences & Schools
101-4-3300-4361 Insurance
101-4-3300-4404 Equip Repair/Maint Services
101-4-3300-4460 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
TOTAL Engineering
25.00°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE °s OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
14,500.00 1,280.77 1,737.87 11.99 12,762.13
11,200.00 0.00 0.00 0.00 11,200.00
25,700.00 1,280.77 1,737.87 6.76 23,962.13
500.00 182.16 182.16 36.43 317.84
3,000.00 199.94 486.23 16.21 2,513.77
3,500.00 382.10 668.39 19.10 2,831.61
245,950.00 16,569.88 39,899.05 16.22 206,050.95
116,750.00 6,627.92 16,569.80 14.19 100,180.20
8,450.00 480.52 1,441.56 17.06 7,008.94
7,250.00 360.58 1,081.74 14.92 6,168.26
1,700.00 84.32 252.96 14.88 1,447.04
13,000.00 928.01 2,784.03 21.42 10,215.97
450.00 ( 266.00)( 143.00) 31.78- 593.00
147,600.00 8,215.35 21,987.09 14.90 125,612.91
1,000.00 0.00 0.00 0.00 1,000.00
700.00 70.30 102.25 14.61 597.75
9,800.00 0.00 0.00 0.00 9,800.00
11,500.00 70.30 102.25 0.89 11,397.75
10,000.00 2,676.00 2,676.00 26.76 7,324.00
1,150.00 3.32 3.84 0.33 1,146.16
200.00 8.89 8.89 4.45 191.11
5,850.00 155.00 155.00 2.65 5,695.00
200.00 46.00 92.00 46.00 108.00
500.00 187.03 561.09 112.22 ( 61.09)
800.00 66.67 200.01 25.00 599.99
18,700.00 3,142.91 3,696.83 19.77 15,003.17
177,800.00 11,428.56 25,786.17 19.50 152,013.83
TOTAL Public Works 2,211,050.00 149,639.51 413,040.76 18.68 1,798,009.24
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 22
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
Culture & Recreation 25.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Parks Department
Personal Services
101-4-5110-4101 Regular Pay 350,250.00 25,938.80 65,038.55 18.57 285,211.45
101-4-5110-4102 Overtime Pay 0.00 19.00 19.00 0.00 ( 19.00)
101-4-5110-4103 Part-time Pay 40,000.00 0.00 0.00 0.00 40,000.00
101-4-5110-4104 PERA 25,400.00 1,881.93 5,619.21 22.12 19,780.79
101-4-5110-9105 FICA 24,200.00 1,480.61 4,408.18 18.22 19,791.82
101-4-5110-4107 Medicare 5,650.00 346.29 1,031.02 18.25 4,618.98
101-4-5110-4108 Insurance 46,900.00 4,192.99 12,172.90 25.96 34,727.10
101-4-5110-4109 Workers Comp 9,000.00 2,753.50 5,163.00 57.37 3,837.00
TOTAL Person al Services 501,400.00 36,563.07 93,451.86 18.64 907,948.14
Supplies
101-4-5110-4212 Fuels & Lubs 33,200.00 1,811.89 4,873.01 14.68 28,326.99
101-4-5110-4217 Uniform Allowance 3,250.00 89.99 281.57 8.66 2,968.93
101-4-5110-4219 Operating Supplies 72,900.00 2,268.96 7,747.79 10.63 65,152.21
101-4-5110-4221 Equipment Parts 11,000.00 3,931.69 6,359.15 57.81 4,640.85
TOTAL Suppli es 120,350.00 8,102.53 19,261.52 16.00 101,088.48
Other Services & Charges
101-4-5110-4321 Telephone 4,400.00 234.64 503.91 11.45 3,896.09
101-4-5110-4322 Postage 100.00 0.00 0.00 0.00 100.00
101-4-5110-9331 Travel, Conferences & Schools 3,150.00 524.00 651.07 20.67 2,498.93
101-4-5110-4361 Insurance 26,700.00 6,407.25 12.,814.50 47.99 13,885.50
101-4-5110-4389 Utilities 27,800.00 192.62 266.51 0.96 27,533.49
101-4-5110-4401 Bldg Repair/Maint Services 4,000.00 0.00 0.00 0.00 4,000.00
101-4-5110-4409 Equip Repair/Maint Services 12,000.00 0.00 75.00 0.63 11,925.00
101-4-5110-4409 Contractual Services 7,550.00 0.00 0.00 0.00 7,550.00
101-4-5110-4415 Equipment Rental 25,000.00 500.36 1,630.97 6.52 23,369.03
101-4-5110-4960 Equip Replacement Charge 57,900.00 4,825.00 14,975.00 25.00 43,425.00
TOTAL Other Services & Charges 168,600.00 12,683.87 30,416.96 18.04 138,183.04
Capital Outlay
TOTAL Parks Department 790,350.00 57,399.47 143,130.34 18.11 647,219.66
Parks & Rec Admin
-----------------
-----------------
Personal Services
101-4-5210-4101 Regular Pay .338,950.00 19,027.00 47,603.47 14.04 291,346.53
101-4-5210-4103 Part-time Pay 20,850.00 2,709.94 7,089.64 34.00 13,760.36
101-4-5210-4104 PERA 26,100.00 1,575.97 4,735.66 18.14 21,364.34
101-4-5210-4105 FICA 22,300.00 1,236.81 3,714.25 16.66 18,585.75
101-4-5210-4107 Medicare 5,200.00 289.27 868.69 16.71 4,331.31
101-4-5210-4108 Insurance 45,600.00 2,920.59 8,787.43 19.27 36,812.57
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 23
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
Culture & Recreation
DEPARTMENTAL EXPENDITURES
CURRENT CURRENT
BUDGET PERIOD
25.00$ OF YEAR COMP.
YEAR TO DATE °s OF BUDGET
ACTUAL BUDGET BALANCE
101-4-5210-4109 Workers Comp 3,750.00 792.50 1,781.00 47.49 1,969.00
TOTAL Personal Services 462,750.00 28,552.08 74,580.14 16.12 388,169.86
Supplies
101-4-5210-4219 Operating Supplies 11,700.00 998.90 4,839.07 41.36 6,860.93
TOTAL Supplies 11,700.00 998.40 9,839.07 41.36 6,860.93
Other Services & Charges
101-4-5210-9321 Telephone 4,800.00 250.42 615.65 12.83 4,184.35
101-9-5210-4322 Postage 4,000.00 289.67 289.67 7.24 3,710.33
101-4-5210-4331 Travel, Conferences & Schools 6,950.00 64.56 253.04 3.64 6,696.96
101-4-5210-4349 Advertising/Marketing 26,400.00 140.87 1,706.87 6.47 29,693.13
101-4-5210-4361 Insurance 1,450.00 153.75 307.50 21.21 1,192.50
101-4-5210-4389 Utilities 8,500.00 669.95 1,402.87 16.50 7,097.13
101-4-5210-4401 Bldg Repair/Maint Services 12,850.00 2,401.93 4,370.78 34.01 8,479.22
101-4-5210-4404 Equip Repair/Maint Services 9,350.00 606.29 2,840.42 30.38 6,509.58
101-4-5210-4433 Dues & Subscriptions 1,550.00 1,058.00 1,058.00 68.26 492.00
TOTAL Other Services & Charges 75,850.00 5,635.94 12,894.80 16.93 63,005.20
Capital Outlay
TOTAL Parks & Rec Admin
Recreation Programs
Personal Services
101-4-5220-4103 Part-time Pay
101-4-5220-4104 PERA
101-4-5220-4105 FICA
101-4-5220-4107 Medicare
TOTAL Personal Services
Supplies
101-4-5220-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-5220-9404 Equip Repair/Maint Services
101-4-5220-4409 Contractual Services
101-4-5220-4412 Building Rent
101-4-5220-4438 Credit Card Fees
TOTAL Other Services & Charges
550,300.00 35,185.92 92,264.01 16.77 458,035.99
82,000.00 1,946.90 7,730.85 9.43 74,269.15
2,400.00 56.79 209.84 8.74 2,190.16
4,350.00 120.70 543.26 12.99 3,806.74
1,200.00 28.22 127.03 10.59 1,072.97
89,950.00 2,152.61 8,610.98 9.57 81,339.02
.31,000.00 2,785.17 4,753.10 15.33 26,296.90
31,000.00 2,785.17 4,753.10 15.33 26,246.90
500.00 0.00 0.00 0.00 500.00
64,050.00 1,200.98 6,480.75 10.12 57,569.25
3,000.00 0.00 0.00 0.00 3,000.00
4,000.00 387.69 665.29 16.63 3,334.71
71,550.00 1,588.67 7,146.04 9.99 64,403.96
TOTAL Recreation Programs
192,500.00 6,526.45 20,510.12 10.65 171,989.88
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 24
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
I 101-GENERAL FUND
Culture & Recreation
I DEPARTMENTAL EXPENDITURES
CURRENT CURRENT
BUDGET PERIOD
25.00$ OF YEAR COMP.
YEAR TO DATE $ OF BUDGET
ACTUAL BUDGET BALANCE
Concessions
Personal Services
101-4-5230- 9103 Part-time Pay 3,650.00 29.00
101-4-5230- 9104 PERA 150.00 2.10
101-4-5230- 4105 FICA 250.00 1.80
101-4-5230- 4107 Medicare 50.00 0.42
TOTAL Personal Services 4,100.00 33.32
Supplies
101-4-5230-4219 Operating Supplies 2,900.00
101-4-5230-4259 Other Merchandise For Resale 7,000.00
TOTAL Supplies 9,900.00
Other Services & Charges
0.00
0.00
I 101-4-5230-4401 Bldg Repair/Maint Services 100.00 0.00
TOTAL Other Services & Charges 100.00 0.00
29.00 0.79 3,621.00
2.10 1.40 147.90
1.80 0.72 248.20
0.42 0.84 49.58
33.32 0.81 4,066.68
0.00 0.00 2,900.00
0.00 0.00 7,000.00
0.00 0.00 9,900.00
0.00 0.00 100.00
0.00 0.00 100.00
TOTAL Concessions
Sr Citizen Programs
Personal Services
101-9-5510-4101 Regular Pay
101-4-5510-4103 Part-time Pay
101-4-5510-4104 PERA
101-4-5510-4105 FICA
101-4-5510-4107 Medicare
101-4-5510-4108 Insurance
101-4-5510-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-5510-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-5510-4321 Telephone
101-4-5510-4322 Postaqe
101-4-5510-4331 Travel, Conferences & Schools
101-4-5510-4361 Insurance
101-4-5510-4389 Utilities
101-4-5510-4401 Bldg Repair/Maint Services
101-4-5510-4404 Equip Repair/Maint Services
101-4-5510-4409 Contractual Services
101-4-5510-4433 Dues & Subscriptions
TOTAL Other Services & Charges
14,100.00 33.32 33.32 0.29 14,066.68
57,400.00 4,414.41 11,036.03 19.23 46,363.97
62,000.00 9,676.64 11,654.01 18.80 50,345.99
8,650.00 659.09 1,975.56 22.84 6,679.44
7,900.00 527.57 1,581.24 21.37 5,818.76
1,750.00 123.39 369.82 21.13 1,380.18
13,700.00 1,110.20 3,330.60 24.31 10,369.40
500.00 116.50 258.00 51.60 292.00
151,400.00 11,627.80 30,205.26 19.95 121,194.74
12,400.00 359.47 1,543.75 12.45 10,856.25
12,400.00 359.47 1,593.75 12.45 10,856.25
2,600.00 182.75 554.62 21.33 2,045.38
2,500.00 60.35 560.35 22.41 1,939.65
2,400.00 59.00 59.00 2.46 2,341.00
1,600.00 371.25 742.50 46.41 857.50
9,700.00 1,304.84 2,884.76 29.79 6,815.29
12,400.00 1,479.15 3,399.04 27.41 9,000.96
1,500.00 0.00 0.00 0.00 1,500.00
6,950.00 ( 140.00)( 91.00) 1.31- 7,041.00
1,000.00 250.77 575.16 57.52 424.84
40,650.00 3,568.11 8,684.43 21.36 31,965.57
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 25
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
Culture & Recreation
DEPARTMENTAL EXPENDITURES
25.00$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE °s OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Capital Outlay
TOTAL Sr Citizen Programs
204,450.00 15,555.38 40,433.44 19.78 164,016.56
TOTAL Culture & Recreation
Economic Development
Personal Services
101-4-6210-4101 Regular Pay
101-4-6210-4103 Part-time Pay
101-4-6210-4104 PERA
101-4-6210-4105 FICA
101-4-6210-4107 Medicare
101-4-6210-4108 Insurance
101-4-6210-4109 Workers Comp
TOTAL Personal Services
Other Services & Charges
10I-4-6210-4322 Postage
101-4-6210-4361 Insurance
101-4-6210-4440 Miscellaneous
TOTAL Other Services & Charges
1,751,700.00 114,650.54 296,371.23 16.92 1,455,328.77
0.00 ( 2,106.16) 18,955.40 0.00 ( 18,955.40)
0.00 ( 891.84) 891.84 0.00 ( 891.84)
0.00 ( 167.30) 1,388.86 0.00 ( 1,388.86)
0.00 ( 171.10) 1,132.79 0.00 ( 1,132.74)
0.00 ( 40.59) 268.69 0.00 ( 268.69)
0.00 ( 218.09) 1,725.91 0.00 ( 1,725.91)
0.00 ( 34.25) 161.00 0.00 ( 161.00)
0.00 ( 3,629.33) 24,524.44 0.00 ( 24,524.44)
0.00 421.04
0.00 716.50
0.00 ( 53.26)
0.00 1,084.28
421.04 0.00 ( 421.04)
1,433.00 0.00 ( 1,433.00)
35.61 0.00 ( 35.61)
1,889.65 0.00 ( 1,889.65)
TOTAL Economic Development
Energy City
Personal Services
101-4-6220-4101 Regular Pay
101-4-6220-4104 PERA
101-4-6220-4105 FICA
101-4-6220-4107 Medicare
101-4-6220-4108 Insurance
TOTAL Personal Services
Supplies
Other Services & Charges
101-4-6220-4319 Other Professional Services
101-4-6220-4331 Travel, Conferences & Schools
101-4-6220-4359 Publishing
TOTAL Other Services & Charges
0.00 ( 2,545.05) 26,414.09 0.00 ( 26,414.09)
28,700.00 2,208.32 5,520.80 19.24 23,179.20
2,100.00 160.12 469.15 22.34 1,630.85
1,800.00 123.14 359.83 19.99 1,440.17
400.00 28.80 84.16 21.04 315.84
3,150.00 249.51 748.53 23.76 2,401.47
36,150.00 2,769.89 7,182.47 19.87 28,967.53
5,000.00 38.67 38.67 0.77 4,961.33
7,500.00 ( 2,894.12)( 4,128.18) 55.09- 11,628.18
3,000.00 179.69 527.01 17.57 2,472.99
15,500.00 ( 2,675.76)( 3,562.50) 22.98- 19,062.50
TOTAL Energy City 51,650.00 94.13 3,619.97 7.01 48,030.03
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 26
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
101-GENERAL FUND
Economic Development
DEPARTMENTAL EXPENDITURES
25.00°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
TOTAL Economic Development 51,650.00 ( 2,450.92) 30,034.06 58.15 21,615.94
Transfers Out
Transfers Out
101-4-7000-4723 Transfer-Ice Arena 156,250.00 0.00 0.00 0.00 156,250.00
101-4-7000-4729 Transfer - Pinewood 48,950.00 0.00 0.00 0.00 48,950.00
TOTAL Transfers Out 205,200.00 0.00 0.00 0.00 205,200.00
TOTAL Transfers Out 205,200.00 0.00 0.00 0.00 205,200.00
TOTAL General 205,200.00 0.00 0.00 0.00 205,200.00
~ TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
12,500,050.00 865,065.78 2,345,241.80 18.76 10,154,808.20
( 336,600.00)( 746,346.51)( 1,792,820.91) 1,956,220.91
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
221-ICE ARENA
FINANCIAL SUMMARY
REVENUE SUMMARY
Ice Arena
Hockey
Skating
Concessions
TOTAL REVENUES
EXPENDITURE SUMMARY
Culture & Recreation
25.00$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
678,900.00 37,923.14 173,208.36 25.51 505,691.64
49,500.00 23,062.00 41,062.00 82.95 8,438.00
73,350.00 2,376.00 17,095.00 23.31 56,255.00
63,100.00 8,524.77 36,514.32 57.87 26,585.68
864,850.00 71,885.91 267,879.68 30.97 596,970.32
Ice Arena 756,500.00 51,806.43 111,741.40 14.77 644,758.60
Hockey 27,050.00 842.91 968.13 3.58 26,081.87
Skating 34,050.00 2,293.38 5,078.41 14.91 28,971.59
Arena Concessions 47,250.00 8,832.08 19,484.26 41.24 27,765.74
TOTAL Culture & Recreation 869,850.00 63,774.80 137,272.20 15.87 727,577.80
TOTAL EXPENDITURES 864,.850.00 63,774.80 137,272.20 15.87 727,577.80
REVENUES OVER/(UNDER) EXPENDITURES 0.00 8,111.11 130,607.48 ( 130,607.48)
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
221-ICE ARENA
REVENUES
25.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Ice Arena
Charges for Services
221-3-0000-3464 Ice Rental
221-3-0000-3465 Admissions
221-3-0000-3466 Dry Floor Events
221-3-0000-3468 Skate Sharpening
221-3-0000-3475 Building Rent
221-3-0000-3482 Advertising fee
TOTAL, Charges for Services
Other Revenue
221-3-0000-3622 Vending Machines
221-3-0000-3629 Miscellaneous Revenue
TOTAL Other Revenue
Sales
221-3-0000-3791 ATM Revenue
TOTAL Sales
Transfers In
221-3-0000-3922 Transfer-General Fund
TOTAL Transfers In
TOTAL Ice Arena
Hockey
Charges for Services
221-3-5410-3461 Recreation Fees
TOTAL Charges for Services
Other Revenue
TOTAL Hockey
Skating
443,000.00 33,592.81 145,367.53 32.81 297,632.97
22,900.00 0.00 15,917.75 69.51 6,982.25
14,600.00 1,003.00 2,067.45 14.16 12,532.55
4,100.00 660.00 2,080.00 50.73 2,020.00
2,600.00 0.00 0.00 0.00 2,600.00
17,000.00 600.00 2,374.00 13.96 14,626.00
504,200.00 35,855.81 167,806.73 33.28 336,393.27
16,650.00 1,843.30 4,571.08 27.45 12,078.92
1,800.00 183.78 710.50 39.47 1,089.50
18,450.00 2,027.08 5,281.58 28.63 13,168.42
0.00 40.25 120.05 0.00 ( 120.05)
0.00 40.25 120.05 0.00 ( 120.05)
156,250.00 0.00 0.00 0.00 156,250.00
156,250.00 0.00 0.00 0.00 156,250.00
678,900.00 37,923.14 173,208.36 25.51 505,691.64
49,500.00 23,062.00 41,062.00 82.95 8,438.00
49,500.00 23,062.00 41,062.00 82.95 8,438.00
49,500.00 23,062.00 41,062.00 82.95 8,438.00
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
221-ICE ARENA
REVENUES
25.00$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Charges for Services
221-3-5420-3461 Recreation Fees
221-3-5420-3465 Admissions
TOTAL Charges for Services
Other Revenue
221-3-5420-3629 Miscellaneous Revenue
TOTAL Other Revenue
TOTAL Skating
Concessions
Charges for Services
221-3-5430-3467 Concessions
TOTAL Charges for Services
TOTAL Concessions
TOTAL REVENUE
68,000.00 2,376.00 17,095.00 25.14 50,905.00
3,800.00 0.00 0.00 0.00 3,800.00
71,800.00 2,376.00 17,095.00 23.81 54,705.00
1,550.00 0.00 0.00 0.00 1,550.00
1,550.00 0.00 0.00 0.00 1,550.00
73,350.00 2,376.00 17,095.00 23.31 56,255.00
63,100.00 8,524.77 36,514.32 57.87 26,585.68
63,100.00 8,524.77 36,514.32 57.87 26,585.68
63,100.00 8,524.77 36,514.32 57.87 26,585.68
864,850.00 71,885.91 267,879.68 30.97 596,970.32
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 4
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
~ 221-ICE ARENA
' DEPARTMENTAL EXPENDITURES
CURRENT CURRENT YEAR TO DATE
BUDGET PERIOD ACTUAL
25.00% OF YEAR COMP.
OF BUDGET
BUDGET BALANCE
I Ice-Arena
Personal Services
221-4-5400-4101 Regular Pay
221-4-5900-4103 Part-time Pay
221-4-5400-4104 PERA
221-4-5400-4105 FICA
221-4-5900-4107 Medicare
221-4-5400-4108 Insurance
221-4-5900-4109 Workers Comp
TOTAL Personal Services
Supplies
221-4-5400-4212 Fuels & Lubs
221-4-5400-4217 Uniform Allowance
221-4-5400-4219 Operating Supplies
221-4-5400-4255 Soft Drinks/Misc
221-4-5400-4259 Other Merchandise For Resale
TOTAL Supplies
Other Services & Charges
221-4-5400-9321 Telephone
221-4-5400-4322,POStage
221-4-5400-4331 Travel, Conferences & Schools
221-4-5400-9359 Publishing
221-4-5400-4361 Insurance
221-4-5400-4389 Utilities
221-4-5400-4401 Bldg Repair/Maint Services
221-4-5400-4409 Contractual Services
221-4-5400-4415 Equipment Rental
221-4-5400-4433 Dues & Subscriptions
TOTAL Other Services & Charges
Capital Outlay
221-4-5400-4560 Equipment
TOTAL Capital Outlay
Transfers Out
221-4-5400-4730 Transfer-Debt Service
TOTAL Transfers Out
148,700.00 9,613.14 24,803.35 16.68 123,896.65
73,200.00 8,102.71 22,327.83 30.50 50,872.17
12,250.00 970.69 3,093.72 25.25 9,156.28
13,750.00 1,089.56 3,480.92 25.31 10,269.58
3,200.00 254.83 813.99 25.44 2,386.01
17,150.00 1,156.02 3,866.46 22.54 13,283.54
5,550.00 1,650.50 3,426.00 61.73 2,124.00
273,800.00 22,837.45 61,811.77 22.58 211,988.23
900.00 0.00 6.82 1.71 393.18
1,500.00 0.00 0.00 0.00 1,500.00
34,500.00 1,776.26 5,398.77 15.65 29,101.23
9,000.00 886.56 1,437.12 15.97 7,562.88
900.00 0.00 0.00 0.00 900.00
96,300.00 2,662.82 6,842.71 14.78 39,457.29
3,450.00 231.10 611.84 17.73 2,838.16
500.00 88.67 196.32 39.26 303.68
1,000.00 0.00 0.00 0.00 1,000.00
2,200.00 0.00 280.50 12.75 1,919.50
8,350.00 1,807.25 3,614.50 43.29 4,735.50
148,950.00 15,656.21 28,932.97 19.42 120,017.03
22,300.00 1,829.64 2,189.44 9.82 20,110.56
1,200.00 13.60 56.34 4.70 1,143.66
2,800.00 0.00 341.98 12.21 2,458.02
450.00 0.00 183.34 40.74 266.66
191,200.00 19,626.47 36,407.23 19.04 154,792.77
44,900.00 6,679.69 6,679.69 15.04 37,720.31
44,900.00 6,679.69 6,679.69 15.04 37,720.31
200,800.00 0.00 0.00 0.00 200,800.00
200,800.00 0.00 0.00 0.00 200,800.00
TOTAL Ice Arena 756,500.00 51,806.43 111,741.40 19.77 644,758.60
4-13-2011 09:56 AM
221-ICE ARENA
Culture & Recreation
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
25.00°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
PAGE: 5
Hockey
Personal Services
221-4-5410-4103 Part-time Pay 3,600.00 0.00 0.00 0.00 3,600.00
221-4-5410-4105 FICA 250.00 0.00 0.00 0.00 250.00
221-4-5410-4107 Medicare 50.00 0.00 0.00 0.00 50.00
TOTAL Personal Services 3,900.00 0.00 0.00 0.00 3,900.00
Supplies
221-4-5410-4219 Operating Supplies 14,050.00 0.00 0.00 0.00 14,050.00
TOTAL Supplies 14,050.00 0.00 0.00 0.00 14,050.00
Other Services & Charges
221-4-5410-4359 Publishing 500.00 0.00 0.00 0.00 500.00
221-4-5410-4409 Contractual Services 6,400.00 162.90 162.40 2.54 6,237.60
221-4-5410-4438 Credit Card Fees 2,200.00 680.51 805.73 36.62 1,394.27
TOTAL Other Services & Charges 9,100.00 842.91 968.13 10.64 8,131.87
TOTAL Hockey 27,050.00 842.91 968.13 3.58 26,081.87
Skating
Personal Services
221-4-5420-4103 Part-time Pay 20,000.00 1,482.17 2,982.92 14.91 17,017.08
221-4-5420-4104 PERA 1,000.00 39.61 79.85 7.99 920.15
221-4-5420-4105 FICA 1,250.00 91.90 198.13 15.85 1,051.87
221-4-5420-9107 Medicare 300.00 21.49 46.34 15.45 253.66
TOTAL Personal Services 22,550.00 1,635.17 3,307.24 19.67 19,242.76
Supplies
221-4-5420-4219 Operating Supplies 5,500.00 107.28 978.28 17.79 4,521.72
TOTAL Supplies 5,500.00 107.28 978.28 17.79 4,521.72
Other Services & Charges
221-4-5420-4359 Publishing 650.00 0.00 0.00 0.00 650.00
221-4-5420-4409 Contractual Services 2,550.00 195.20 195.20 7.65 2,354.80
221-4-5420-4438 Credit Card Fees 2,800.00 355.73 597.69 21.35 2,202.31
TOTAL Other Services & Charges 6,000.00 550.93 792.89 13.21 5,207.11
TOTAL Skating
34,050.00 2,293.38 5,078.41 14.91 28,971.59
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 6
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
221-ICE ARENA
Culture & Recreation
DEPARTMENTAL EXPENDITURES
25.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Arena Concessions
Personal Services
221-4-5430-4103 Part-time Pay 20,900.00 1,974.05 6,180.34 29.57 19,719.66
221-4-5430-4109 PERA 200.00 44.57 115.59 57.80 84.41
221-4-5430-4105 FICA 1,300.00 122.41 440.68 33.90 859.32
221-4-5430-4107 Medicare 300.00 28.63 103.05 34.35 196.95
TOTAL Personal Services 22,700.00 2,169.66 6,839.66 30.13 15,860.34
Supplies
221-4-5430-4219 Operating Supplies 3,550.00 83.07 927.37 26.12 2,622.63
221-4-5430-4259 Other Merchandise For Resale 21,000.00 6,579.35 11,717.23 55.80 9,282.77
TOTAL Supplies 24,550.00 6,662.42 12,644.60 51.51 11,905.40
TOTAL Arena Concessions
47,250.00 8,832.08 19,484.26 41.24 27,765.74
TOTAL Culture & Recreation
869,850.00 63,774.80 137,272.20 15.87 727,577.80
TOTAL EXPENDITURES 864,850.00 63,774.80 137,272.20 15.87 727,577.80
REVENUES OVER/(UNDER) EXPENDITURES 0.00 8,111.11 130,607.48 ( 130,607.48)
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
I 222-PINEWOOD GOLF COURSE
FINANCIAL SUMMARY
25.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
I REVENUE SUMMARY
Pinewood Golf Course
TOTAL REVENUES
I EXPENDITURE SUMMARY
Culture & Recreation
Golf Course
TOTAL Culture & Recreation
TOTAL EXPENDITURES
~ REVENUES OVER/(UNDER) EXPENDITURES
249,550.00 2,824.00 3,943.00 1.58 245,607.00
249,550.00 2,824.00 3,943.00 1.58 245,607.00
299,550.00 10,170.65 29,535.04 9.83 225,014.96
249,550.00 10,170.65 29,535.04 9.83 225,014.96
249,550.00 10,170.65 24,535.04 9.83 225,014.96
0.00 ( 7,346.65)( 20,592.04) 20,592.04
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
~ 222-PINEWOOD GOLF COURSE
I REVENUES
25.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
1 Pinewood Golf Course
Charges for Services
222-3-0000-3461 Recreation Fees
222-3-0000-3467 Concessions
222-3-0000-3469 Other Sales
222-3-0000-3475 Building Rent
222-3-0000-3476 Green Fees
222-3-0000-3477 Membership Fees
222-3-0000-3478 Golf Cart Rental
222-3-0000-3479 Tournaments
TOTAL Charges for Services
Sales
Other Financing Sources
Transfers In
222-3-0000-3922 Transfer-General Fund
TOTAL Transfers In
TOTAL Pinewood Golf Course
17,000.00 2,824.00 3,943.00 23.19 13,057.00
19,000.00 0.00 0.00 0.00 19,000.00
5,000.00 0.00 0.00 0.00 5,000.00
100.00 0.00 0.00 0.00 100.00
120,000.00 0.00 0.00 0.00 120,000.00
14,000.00 0.00 0.00 0.00 14,000.00
18,500.00 0.00 0.00 0.00 18,500.00
7,000.00 0.00 0.00 0.00 7,000.00
200,600.00 2,824.00 3,943.00 1.97 196,657.00
48,950.00 0.00 0.00 0.00 48,950.00
48,950.00 0.00 0.00 0.00 48,950.00
249,550.00 2,824.00 3,943.00 1.58 245,607.00
~ TOTAL REVENUE
249,550.00 2,824.00 3,943.00 1.58 245,607.00
4-13-2011 09:56 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2011
222-PINEWOOD GOLF COURSE
DEPARTMENTAL EXPENDITURES
25.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Golf Course
Personal Services
222-4-5300-9101 Regular Pay 93,650.00 5,149.35 11,997.71 12.81 81,652.29
222-4-5300-4103 Part-time Pay 29,900.00 0.00 0.00 0.00 29,900.00
222-4-5300-4104 PERA 8,950.00 372.96 1,034.05 11.55 7,915.95
222-4-5300-4105 FICA 7,650.00 313.13 866.85 11.33 6,783.15
222-4-5300-4107 Medicare 1,800.00 73.22 202.70 11.26 1,597.30
222-4-5300-4108 Insurance 10,150.00 458.01 1,374.03 13.54 8,775.97
222-4-5300-4109 Workers Comp 1,400.00 422.00 836.00 59.71 564.00
TOTAL Personal Services 153,500.00 6,783.67 16,311.34 10.63 137,188.66
Supplies
222-4-5300-4212 Fuels & Lubs 5,000.00 0.00 0.00 0.00 5,000.00
222-4-5300-4217 Uniform Allowance 500.00 0.00 0.00 0.00 500.00
222-4-5300-4219 Operating Supplies 30,900.00 184.52 467.04 1.54 29,932.96
222-4-5300-4259 Other Merchandise For Resale 14,500.00 264.79 264.79 1.83 14,235.21
TOTAL Supplies 50,400.00 449.31 731.83 1.45 49,668.17
Other Services & Charges
222-4-5300-4321 Telephone 2,500.00 154.52 306.90 12.28 2,193.10
222-4-5300-4331 Travel, Conferences & Schools 500.00 0.00 0.00 0.00 500.00
222-4-5300-4349 Advertising/Marketing 1,300.00 0.00 0.00 0.00 1,300.00
222-4-5300-4361 Insurance 11,900.00 2,648.25 5,296.50 94.51 6,603.50
222-4-5300-4389 Utilities 7,150.00 68.79 147.70 2.07 7,002.30
222-4-5300-4401 Bldg Repair/Maint Services 2,300.00 20.09 40.08 1.74 2,259.92
222-4-5300-4404 Equip Repair/Maint Services 3,000.00 20.80 1,215.80 40.53 1,784.20
222-4-5300-4415 Equipment Rental 2,000.00 0.00 0.00 0.00 2,000.00
222-4-5300-4437 Taxes & Licenses 1,000.00 6.18 404.18 40.42 595.82
222-4-5300-4438 Credit Card Fees 5,500.00 19.09 80.71 1.47 5,419.29
TOTAL Other Services & Charges 37,150.00 2,937.67 7,491.87 20.17 29,658.13
Capital Outlay
Debt Service
222-4-5300-4601 Principal 8,500.00 0.00 0.00 0.00 8,500.00
TOTAL Debt Service 8,500.00 0.00 0.00 0.00 8,500.00
TOTAL Golf Course 249,550.00 10,170.65 24,535.04 9.83 225,014.96
TOTAL Culture & Recreation 249,550.00 10,170.65 29,535.04 9.83 225,014.96
~ TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
249,550.00 10,170.65 24,535.04 9.83 225,014.96
0.00 ( 7,346.65)( 20,592.04) 20,592.04
4-13-2011 09:58 AM CITY OF ELK RIVER PAGE: 1
POOLED CASH REPORT (FUND 999)
AS OF: MARCH 31ST, 2011
FUND ACCOUNT# ACCOUNT NAME
BEGINNING CURRENT
BALANCE ACTIVITY
CURRENT
BALANCE
CLAIM ON CASH
002-1010 Cash - Section 125
101-1010 Cash - General Fund
211-1010 Cash - Library
221-1010 Cash - Ice Arena
222-1010 Cash - Pinewood Golf Course
223-1010 Cash - Sr Citizen Account
225-1010 Cash - Park Dedication
228-1010 Cash - Landfill
231-1010 Cash - Landfill Const Debris
240-1010 Cash - Micro Loan Fund
241-1010 Cash - DTED Loan
245-1010 Cash - Development Fund
290-1010 Cash - Capital Outlay Reserve
291-1010 Cash - Insurance Reserve
292-1010 Cash - Govt Bldgs Reserve
294-1010 Cash - Drug Forfeiture
295-1010 Cash - Severance Pay Reserve
296-1010 Cash - GRE Reserve
308-1010 Cash - 1999A GO Bonds
311-1010 Cash - 2003A GO Bonds
312-1010 Cash - 2005A GO Bonds
313-1010 Cash - 2007C GO Bonds
333-1010 Cash - 2002A Pub Safety Bonds
340-1010 Cash - Equipment Certificates
344-1010 Cash - 2006C Cap Imp Bonds Lby
375-1010 Cash - TIF #19 East Elk River
403-1010 Cash - Street Improvement
404-1010 Cash - Surface Water Managemnt
406-1010 Cash - City Wide Trunk Util
410-1010 Cash - Equipment Replacement
426-1010 Cash - YMCA
427-1010 Cash - 193rd Avenue
440-1010 Cash - Park Improvement
456-1010 Cash - TIF #16 King/Main
459-1010 Cash - TIF #19 Highway 169
602-1010 Cash - Wastewater Treatment
603-1010 Cash - Liquor
605-1010 Cash - Garbage
BO1-1010 Cash - Interest
821-1010 Cash - Developer Escrow
TOTAL CLAIM ON CASH
21,597.51 2,743.88 24,341.39
4,793,352.45 ( 722,664.98) 4,070,687.47
409,792.73 3,158.92 412,951.15
27,907.29 59,308.03 87,215.32
( 10,626.26) ( 7,346.65) ( 17,972.91)
8,834.17 1,167.85 10,002.02
11,201.75 0.00 11,201.75
1,010,590.95 ( 8,550.89) 1,002,040.06
685,332.08 0.00 685,332.08
1,037,821.85 3,872.80 1,041,694.65
277,684.95 4,828.04 282,512.99
364,969.86 ( 210.56) 364,759.30
1,304,759.21 ( 379.32) 1,309,379.89
423,321.39 ( 61,493.29) 361,828.10
3,667,420.33 75,451.25 3,742,871.58
5,838.45 ( 1,207.73) 4,630.72
142,624.58 0.00 142,624.58
1,442,077.15 0.00 1,442,077.15
25,000.00 0.00 25,000.00
46,156.87 0.00 46,156.87
115,469.96 ( 402.50) 115,067.46
148,385.54 3,468.75 151,859.29
166,967.25 0.00 166,967.25
6,613.11 ( 3,500.00) 3,113.11
( 353,805.00) ( 431.25) ( 354,236.25)
7,862.50 ( 425.00) 7,437.50
5,177,881.76 13,406.73 5,191,288.49
272,996.12 7,144.05 280,140.17
4,148,009.55 0.00 9,148,009.55
1,046,367.12 ( 152,802.91) 893,564.21
1,341,712.68 0.00 1,341,712.68
( 36,184.05) ( 924.46) ( 37,108.51)
78,528.83 806.88 79,335.71
43,994.06 0.00 93,994.06
456,439.15 0.00 456,439.15
4,483,557.62 25,465.90 4,509,023.52
4,012,471.22 63,203.91 4,075,675.13
495,083.58 ( 12,918.14) 482,165.44
0.00 51,026.56 51,026.56
89,390.38 ( 122.00) 89,268.38
37,397,398.69 ( 658,326.63) 36,739,072.06
CASH IN BANK - POOLED CASH
999-1000 A/P BANK ACCOUNTS
999-1001 PY BANK ACCOUNT
999-1002 POOLED INVESTMENTS
SUBTOTAL CASH IN BANK - POOLED CASH
20,550,476.91 94,637.69 20,645,114.60
(11,535,267.78) ( 752,964.32) (12,288,232.10)
28,382,189.56 0.00 28,382,189.56
37,397,398.69 ( 658,326.63) 36,739,072.06
Information
MEMORANDUM
TO: City Council
FROM: Tina Allard, City Clerk
DATE: April 18, 201 I
SUBJECT: City Newsletter
Awhile back Mayor Dietz attended a conference and learned that other cities were making a
profit from their community newsletter. Staff was directed to look at the issue and this
update is being provided.
I contacted Mayor Dietz to find out which cities are making a profit in order to learn more
information. Mayor Dietz mentioned the City of Ramsey and asked me to contact the
League of Minnesota Cities (LMC) regarding the other cities. I tried making contact with
Ramsey and the LMC Training and Conferences Manager. I didn't receive a response from
either group.
After doing some further research, I located the attached document regarding the City of
Ramsey and their newsletter.
It should be noted that it is more difficult to get ads in the Elk River newsletter because we
don't have the demographics to support it as much as a city like Maple Grove. It is easier fox
Maple Grove because they have many more businesses that axe in the area and willing to
advertise. Our current vendor hasn't been filling all the ad space fox Elk River and has
donated some ads.
There has been a lot of discussion with the Visioning Team and some discussion with the
Branding Subcommittee with regards to overall marketing/communications of the city. Staff
would like to continue to review this item but to wait and see how it will fit into the
decisions that are made with both the visioning and branding projects.
N:APublic Bodies\City Council\Council RCA\Communicadon~ANewslcttcr PmflLdoc
December 25.207.0
Tammy Sal¢y
Ramsey opts to renew contract for city
newsletter
by Tammy Sakrv
Staff writer
Last fall, the Ramsey City Council began a par-
tnership with Youth First Marketing (YFM) to sell
ads for and to produce the city newsletter.
Since then, the company has failed to turn in seve-
ral invoices, owes the city $8,180 for its 50 percent
share ofthe adrevenue andwas requiredto change
its business name.
Although the city is owed money, the councff voted
S-2 Dec.14 to continue the partnership with owner
Scott Robinson and his new business, Wheels of
Thunder, to produce the city newsletter.
Councilmembers David Jeffrey and John Dehen
voted no.
According to City Administrator Kurt IDrich, Ro-
binsonhas assumed all of the obligations of YFM
and the city will be handling the payments from
advertisers and dispensing the payments to Wheels
of Thunder of Anoka.
A
a
d
w
0
T
c
y
0
v
..
x
Wheels of Thunderwillproduce the newsletter and
work with advertisers for free until the amount
owed to the city has been paid, he said.
After that, Wheels of Thunder will receive SO percent
of the advertising revenue.
The $8,180 should be paid off with the February/
March newsletter advertising revenue, Robinson
said.
"I'm not a fan of going back in this direction," said
Jeffrey.
He is concerned that Wheels of Thunders will be
able to cut deals to get ads that are not consistent
the rate schedule set by the city, he said.
If Wheels of Thunders is out there doing business
for the city, he wants to make sure only the city has
the ability to cut the deals, Jeffrey said.
Robinson has agreed on a set ad rate with no de-
viations, i-rich said.
The city has had a negative historywith this vendor
and the company has not provided the information
on its ad sales as city has asked for, according to
Dehen.
While he can understand mistakes and computer
crashes, Dehen said it was more of an issue of trust
for him.
"When people don't show trustworthiness, it's time
to cut bait and move onto someone else," he said.
If the city does not sign a new contractwith Wheels
of Thunder, Mayor Bob Ramsey said he does not
knowhowthe citywill collect the $8,180 Robinson
owes the city.
A lot of businesses fell behind in paying for their
ads, Robinson said regarding why full payments
were not sent to the city.
According to the August 2009 contract, YFM was
supposed to sell the ads for the newsletter and SO
percent of the proceeds were to go to the city, 7 per-
cent to Youth First Community of Promise (YFCoP)
and the remaining 43 percent was to go to YFM.
http:/labcnewsp ape rs.com/2 0 1 011 2/2 5 /ramsey-opts-m-renew-contract-fnr-ciry-newsletter/
C' GIy €,' i'
Decem Uer 25, 2010
Ramsey opts to renew contract for city newsletter
During fund-raising of its own, YFCoP discovered
there was some affiliation confusion between it and
YFM. Tammy Sakry is at tmnntvsalnv(a)ecm-ineeom
When people were placing ads, they were under ea snare ~ save ~ _- c
the impression that they were donating to YFCoP,
said Bill Erhart, YFCoP boardmember and attorney
representing the organization.
YFCoP is a non-profit organization aimed at redu-
cing risky behaviors in youth in the communities
of Andover, Anoka and Ramsey.
YFCoP began a lawsuit to require YFM to change its
name to avoid the confusion, Erhart said.
Robinson and YFCoP setfled the issue this fall wi-
thout the lawsuit going forward.
Although the YFM contract required 7 percent to
go to YFCoP, the group has only received a fraction
the $1,385.74 city records indicate are due to the
non-profit.
In 2009, YFCoP received $222.67 from the Ramsey Re-
sidentproceeds, said Program Director Heidi Geiss.
In 2010, it received two payments from YFM totaling
$409.50.
A
a
v
T
c
a
0
v
..
x
Despite the earlierproblems, Ulrich sees some ad-
vantages tothe parmershipwith Wheels of Thunder.
The firm already has business contacts in the com-
munity and the city already has a familiarity wor-
kingwith this company, he said.
With the city taking over the accounting end of the
contract, it will be able to keep the accounts up-to-
date and see what revenues are coming in, Uh•ich
said.
U
The citywants to build a solid long-term relationship
with Wheels of Thunder, he said.
http://ab cnewspape rs.com/2010/12/25/ramsey-opts-to-renew-contract-fbr-city-newsletter/
°!S~t' u;