INFORMATION 07-18-2011INFORMATION
MEMORANDUM
~~
TO: Mayor and City Council
FROM: Bob Thistle, Interim City Administrator
DATE: July 18, 201 I
SUBJECT: State Shutdown Impacts on Elk River
I have requested staff to provide Council an update regarding the impacts on Elk River due
to the State shutdown. This should assist Council in answering questions that may be raised
by citizens or members of the business community.
Administration
^ Liquor licenses -most liquor licenses require city approval but are ultimately issued
by the State. With the Minnesota Department of Public Safety, Alcohol and
Gambling Division (AGED) shutdown, no new liquor licenses, with the exception
of 3.2. on and off-sale licenses, can be issued. This includes temporary liquor
licenses.
^ Gambling permits -these also require city approval but are ultimately issued by the
State. With the shutdown of AGED, no new gambling permits may be issued.
Building Division
^ Electrical inspections are conducted by a contract inspector with the State. All
current construction projects in Elk River could be affected if electrical inspections
are not conducted. The Spectrum School and UHG projects are the largest that will
be affected at this time. (Issue addressed by Emergency Ordinance.)
^ Commercial plumbing plan reviews are performed at the State level with permits and
inspections conducted on a local level. Several projects are immediately affected.
They include El Amigo's, Jo-Ann Fabrics and Pizza Ranch. (Issue addressed by
Emergency Ordinance.)
The State Fire Marshal conducts fire sprinkler plan review on projects involving
more than 20 sprinkler heads. This could affect the Pizza Ranch and Jo-Ann Fabrics
project in the near future
N:\Public Bodies\Ciry Council\Administrator\2011\State Shutdown Impacts 07 18 l l.docx
Economic Development
Business Subsidy reporting -Two industrial businesses have not yet reached their job
creation requirements as related to their abatement agreement; both require State
reporting and are requesting extensions. There is some question regarding the
definition of permanent job creation. One business has been contracting with a
management firm to handle payroll, benefits, etc. to save money. I know there are
other businesses as well doing this. I need to get clarification from the State
regarding this. I am able to hold the required public hearings regarding the
extensions, however will be unable to get final approval from the State regarding the
requested extensions
Retail Trade Analysis -The EDA has obtained a Retail Trade Analysis report from
the U of M Extension Service. Interpretation and a future joint Chamber/City event
presenting this information is on hold contingent upon my meeting with the
Extension facilitator
^ Development Projects -There are a few projects which axe on hold because of final
approval of plumbing, electrical and public health inspections. They include: Pizza
Ranch, Spectrum School, El Amigos and potentially United Healthcare data center
expansion contingent upon the length of the shutdown.
Engineering Division
^ 2011 Street Improvement Project -The Department of Health did not complete the
review of our plans prior to the shutdown. This results in us not having a
Department of Health permit to construct the watermain portion of the project.
While we can get started on other aspects of the project, the shutdown has the
potential to delay the construction by the middle of August if we cannot procure the
permit.
^ Maintenance of State Right of Ways -The State will likely not have sufficient
personnel to complete routine mowing, and patching of TH 10 and TH 169. In
addition there is no State Staff available to adjust the timing of the signal systems if
they are needed. Unless it is an emergency situation all work within the State right of
way will be halted.
^ Traffic Signal System Painting on TH 169 - We have 3 systems along TH 169
scheduled for painting in August. We will be forced to delay this work if the
shutdown continues that long.
^ State Aid Payments -all requests for State Aid Payments including the final
installment of the 193rd Avenue project and any requests for the 2011 Street project
will not be made during the shutdown.
^ MPCA Grant for Wastewater Effluent Reuse -The work we are completing on the
Wastewater Effluent Reuse project will not be reimbursed through the MPCA during
the shutdown. While we have been directed that we can continue with engineering
work, we cannot make request for our 50% reimbursement of the cost until the
MPCA is back up and running.
N:\Public Bodies\Ciry Council\Administrator\2011\State Shutdown Impacts 07 18 l l.docx
Any private project requiring a NPDES permit (General Stormwater permit) from
the MPCA for construction projects will not be able to start work. This includes any
proposed project that will disturb more than one acre of land. Based on where
private developments are at in the approval process this would first affect the
proposed Crossing Church expansion project and potentially the Pizza Ranch project
if they did not secure their permits prior to the shutdown.
Environmental Division
^ Wetland decision making with BWSR and DNR members of the TEP out.
^ Wetland and shoreland back-up enforcement for city staff.
^ Solid waste issues that relate to State level enforcement... landfill, Hazardous waste,
spills, organics (grant), recycling assistance (MPCA).
^ MPCA review of landfill application.
^ Permits for removal of Curly Leaf Pondweed (or other aquatic issues) are suspended
while they are closed... also can't get new permits.
^ Floodplain decisions (we can't adopt the revised ordinance until the DNR has had
time to review), variances also.
^ NPDES stuff (Stormwater).
^ State websites are inaccessible so can't review rules & regulations or download
permit applications.
^ Grant reimbursements from MPCA and Dept of Commerce have been suspended.
Fire Department
^ At the present time, the Fire Department is not being directly affected by the State
shutdown although a number of State agencies which the department works closely
with, including the State Fire Marshal's office, are closed. This could impact on
facilities that are licensed through the State, such as daycare centers. It also leaves a
void for answering code enforcement inquiries and a few joint code enforcement
projects have since ceased. The department does not expect to receive investigative
support for fire cause/determination unless there is a significant loss or death.
^ Fire and EMS licensing are closed but there is no impact at this time.
^ The department expects delays in receiving State assistance for large scale events or
disasters due to the State Department of Homeland Security operating at partial
staffing. State level coordination among agencies will also be disrupted due to the
lack of staffing in other areas of State government. Access to State resources,
N:\Public Bodies\City Council\Administrator\2011\State Shutdown Impacts 07 18 ll.docx
including secure intranets fox incident coordination, is also down or limited The city
will rely on local and regional coordination.
Parks and Recreation Department
^ The department has applied for two grants, one for Hillside City Park and one for
the Youth Athletic Complex, through the Department of Natural Resources and
with the shutdown there may be a delay in the decision of the two grants.
Elk River Municipal Utilities
^ State licenses -Commercial Driver's Licenses, Electrical Contractor, Power Limited
Technician, etc...
Social Services - TriCAP (Tri-County Action Program)
State permitting -Minnesota Department of Health
N:\Public Bodies\Ciry Council\Administrator\2011\State Shutdown Impacts 07 18 l l.docx
INFORMATION
Springsted Incorporated
380 Jackson Street, Suite 300
Saint Paul, MN 55101-2887
~' ~ ~ ' Tel: 651-223-3000
Fax: 651-223-3002
wuvw.springsted.com
MEMORANDUM
T0: Elk River City Council
FROM: Sharon Klumpp
DATE; July 15, 2011
SUBJECT: Search Update
Recruitment efforts are moving forward on the City Administrator search. Ads were placed with the following
organizations on June 29: League of Minnesota Cities, International CitylCounty Management Association, Illinois
CitylCounty Management Association, League of Wisconsin Municipalities, Iowa League of Cities, and the Wisconsin
City/County Management Association. Additionally, the Minnesota City/County Management Association sent the job
announcement to each of its members earlier this week.
Outreach efforts have included contacts with 14 individuals advising them of the opening and/or responding to
questions.
To date, we have received 23 applications.
Please feel free to contact me at sklum,~pra7.sorinasted.com if you have any questions.
Public Sectar Advisors
INFQRMATION
fiver
MEMORANDUM
TO: Mayor and City Council
FROM: Tim Simon, Finance Director
DATE: July 18, 2011
SUBJECT: June 2011 Monthly Financial Report
This report is designed to provide summary 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 June, actual revenues (except for property taxes and state aids) and
expenditures should run 50% 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 for 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.c:
• Excluding transfers in, revenue collections are slightly below 38% of budget. 70% of
the first half property taxes were received in June and the remainder of the first half
will be collected in July.
• Collection of the cable franchise tax from Sherburne-Wright Cable Commission was
also received in June; indications are this will be a one-time payment in 2011.
• Licenses and permits are over budget estimates due mainly to business license annual
renewals and several larger building-related permits.
• Charges for services and fines & forfeits are about 49% of budget and within the
budget benchmark
• The second-half state-aid street maintenance payment was received in June.
• Transfers in will be reflected in the July report.
Expenditures:
• Excluding transfers out, the total departmental expenditures are about 42% of
budget estimates and most departments are well within or below budget.
• The transfers out to the Ice Arena and Pinewood Golf are made at the end of the
year.
Ice Arena
As of the end of June, revenues exceed expenditures by $43,390. Excluding transfers,
revenue collections of $353,388 are 50% of budget and expenditures of $309,998 are 47% of
budget; both within the budget benchmarks.
Pinewood Golf
For the month ended June, expenditures exceed revenues by $14,797. Excluding transfers,
golf revenues collected through June of $86,829 account for about 43% of budget estimates
and expenditures of $101,626 are about 41% of budget.
I 7-13-2011 10:50 AM
101-GENERAL FUND
FINANCIAL SUMMARY
CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011 ~~~~~~~~~~~
SO.OOa OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE °s OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SUMMARY
General Fund
~ TOTAL REVENUES
I EXPENDITURE SUMMARY
General Government
Mayor & Council
Cable TV
Administrative Services
Human Resources
Elections
Finance
Information Technology
Legal
Community Development
Planning
City Hall Maintenance
Contingency
TOTAL General Government
Public Safety
Police Administration
Patrol
Investigations
Police Support Services
Police Reserves
Public safety building
Fire Administration
Fire Inspections
Emergency Management
Building Safety
Environmental
TOTAL Public Safety
Public Works
Street Maintenance
Snow Removal
Equipment Services
Engineering
TOTAL Public Works
12,163,450.00 3,595,275.34 4,557,699.25 37.47 7,605,750.75
12,163,450.00 3,595,275.34 4,557,699.25 37.47 7,605,750.75
177,800.00 4,036.03 69,769.52 39.24 108,030.48
77,800.00 5,627.07 34,479.76 44.32 43,320.24
973,650.00 87,785.30 264,768.19 55.90 208,881.86
150,750.00 11,801.32 72,190.99 47.85 78,609.01
0.00 3,510.00 0.00 0.00 0.00
454,700.00 29,108.11 244,518.83 53.78 210,181.17
266,600.00 13,233.18 113,932.48 42.74 152,667.52
240,000.00 28,657.36 114,456.21 47.69 125,543.79
67,100.00 5,326.64 31,673.83 97.20 35,426.17
303,550.00 22,524.35 136,901.35 45.10 166,698.65
300,850.00 19,880.18 119,867.31 39.84 180,982.69
75,000.00 0.00 0.00 0.00 75,000.00
2,587,800.00 231,489.54 1,202,508.42 46.47 1,385,291.58
563,800.00 48,103.76 278,158.25 49.34 285,641.75
2,252,800.00 162,069.36 939,486.59 91.70 1,313,313.41
752,450.00 51,608.83 303,102.74 40.28 449,347.26
991,700.00 38,411.92 219,747.67 44.69 271,952.33
22,900.00 2,243.13 11,319.00 49.43 11,581.00
205,000.00 14,383.09 86,402.09 42.15 118,597.91
589,600.00 40,149.35 255,155.54 43.28 339,444.46
184,850.00 13,527.88 83,043.71 44.92 101,806.29
107,400.00 1,108.24 20,763.17 19.33 86,636.83
965,200.00 35,475.99 215,120.77 46.24 250,079.23
56,950.00 4,472.87 25,420.40 44.64 31,529.60
5,692,650.00 411,554.37 2,437,719.93 42.82 3,254,930.07
1,524,450.00 87,623.73 462,966.45 30.37 1,061,483.55
262,850.00 1,871.00 195,475.10 74.37 67,374.90
245,950.00 18,302.96 101,223.31 41.16 144,726.69
177,800.00 10,079.20 54,408.63 30.60 123,391.37
2,211,050.00 117,876.89 814,073.49 36.82 1,396,976.51
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
101-GENERAL FUND
FINANCIAL SUMMARY 50.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Culture & Recreation
Parks Department
Parks & Rec Admin
Recreation Programs
Concessions
Sr Citizen Programs
TOTAL Culture & Recreation
Economic Development
Economic Development
Energy City
TOTAL Economic Development
General
Transfers Out
TOTAL General
TOTAL EXPENDITURES
~ REVENUES OVER/(UNDER) EXPENDITURES
790,350.00 67,998.38 339,456.30 42.95 450,893.70
550,300.00 35,887.08 216,276.01 39.30 339,023.99
192,500.00 41,862.84 82,562.54 42.89 109,937.46
14,100.00 872.43 3,454.11 24.50 10,645.89
204,450.00 14,717.78 89,310.49 43.68 115,139.51
1,751,700.00 161,338.51 731,059.45 41.73 1,020,640.55
0.00 ( 38,646.32) 10,809.32 0.00 ( 10,809.32)
51,650.00 5,369.17 19,327.98 37.42 32,322.02
51,650.00 ( 33,277.15) 30,137.30 58.35 21,512.70
205,200.00 0.00 0.00 0.00 205,200.00
205,200.00 0.00 0.00 0.00 205,200.00
12,500,050.00 888,982.16 5,215,498.59 41.72 7,284,551.41
( 336,600.00) 2,706,293.18 ( 657,799.39) 321,199.34
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
101-GENERAL FUND
REVENUES
50.00$ OF YEAR COMP.
CURRENT CURRENT
BUDGET PERIOD
YEAR TO DATE ~ OF BUDGET
ACTUAL BUDGET BALANCE
General Fund
Taxes
101-3- 0000-3111 Current Ad Valorem Taxes 9,758,500.00 3,273,335.08 3,273,335.08 33.54 6,485,164.92
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 4,867.14 6.49 70,132.86
101-3- 0000-3123 Franchise Tax 0.00 45,338.92 45,338.42 0.00 ( 45,338.42)
TOTAL Taxes 9,612,400.00 3,318,673.50 3,323,540.64 34.58 6,288,859.36
Licenses & Permits
101-3-0000-3211 Liquor License
101-3-0000-3212 Amusement License
101-3-0000-3213 Cigarette License
101-3-0000-3214 Apartment License
101-3-0000-3216 Mining License
101-3-0000-3217 Garbage Hauler License
101-3-0000-3218 Other Business License/Permit
101-3-0000-3229 NPDES Permit
101-3-0000-3231 Building Permit
101-3-0000-3232 Plumbing/Heating Permit
101-3-0000-3233 Permit Surcharge
101-3-0000-3235 Animal License
101-3-0000-3236 Parking Permit
101-3-0000-3237 Other Non-Business Lic/Permit
TOTAL Licenses & Permits
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-3341 County Reimb/Grant
TOTAL Intergovernmental Rev
53,000.00 5,200.00 54,815.00 103.42 ( 1,815.00)
1,000.00 0.00 195.00 19.50 805.00
3,000.00 0.00 112.50 3.75 2,887.50
16,000.00 9,005.00 19,440.00 121.50 ( 3,940.00)
20,000.00 11,835.00 20,805.25 104.03 ( 805.25)
4,000.00 0.00 555.00 13.88 3,945.00
14,000.00 595.00 7,765.00 55.46 6,235.00
2,500.00. 175.00 875.00 35.00 1,625.00
100,000.00 25,546.80 74,018.75 74.02 25,981.25
25,000.00 11,273.40 103,460.77 413.84 ( 78,460.77)
200.00 103.67 3,312.87 1,656.49 ( 3,112.87)
3,000.00 500.00 3,520.00 117.33 ( 520.00)
3,000.00 ( 28.30) 411.70 13.72 2,588.30
8,000.00 1,020.00 4,055.00 50.69 3,945.00
252,700.00 60,225.57 293,341.84 116.08 ( 40,641.84)
9,000.00 428.80 1,185.25 29.63 2,814.75
14,000.00 0.00 D.00 0.00 14,000.00
205,000.00 0.00 0.00 0.00 205,000.00
12,000.00 0.00 0.00 0.00 12,000.00
254,050.00 137,742.56 275,485.11 108.44 ( 21,435.11)
35,000.00 0.00 4,101.74 11.72 30,898.26
4,000.00 0.00 0.00 0.00 9,000.00
0.00 0.00 5,125.00 0.00 ( 5,125.00)
528,050.00 138,171.36 285,897.10 54.14 242,152.90
Charges for Services
101-3-0000-3412 Planning & Zoning Fees 15,000.00 2,460.00 6,950.00 46.33 8,050.00
101-3-0000-3413 Plan Check Fee 30,000.00 4,436.72 20,106.98 67.02 9,893.02
101-3-0000-3415 Special Assessment Search 600.00 0.00 600.00 100.00 0.00
101-3-0000-3417 Copies 1,500.00 259.62 1,361.87 90.79 138.13
101-3-0000-3418 Other General Govt Services 9,000.00 320.00 1,634.51 40.86 2,365.49
101-3-0000-3430 Lockout Fees 7,500.00 700.00 4,065.00 54.20 3,435.00
101-3-0000-3431 Police Services 2,000.00 270.00 746.50 37.33 1,253.50
101-3-0000-3432 School Liaison 75,000.00 0.00 37,500.00 50.00 37,500.00
101-3-0000-3934 Animal Impound Fee 3,000.00 600.00 1,625.00 54.17 1,375.00
I 7-13-2011 10:50 AM
101-GENERAL FUND
REVENUES
CITY OF ELK RIVER PAGE: 4
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
SO.OOo OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
101-3-0000-3436 Fire Contracts
101-3-0000-3437 Fire Calls
101-3-0000-3451 Street Services
i01-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-3974 Facility Use Fee
101-3-0000-3975 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
I Special Assessments
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-3999 Transfer-HRA
TOTAL Transfers In
TOTAL General Fund
12,163,450.00 3,595,275.34 4,557,699.25 37.47 7,605,750.75
~ TOTAL REVENUE
194,000.00 ( 1,100.00) 108,500.72 55.93 85,499.28
4,000.00 0.00 0.00 0.00 9,000.00
30,000.00 260.00 8,406.71 28.02 21,593.29
99,100.00 0.00 11,702.04 11.81 87,397.96
123,000.00 11,486.65 92,046.43 74.83 30,953.57
14,100.00 940.63 2,181.97 15.47 11,918.03
18,000.00 768.13 11,936.25 66.31 6,063.75
6,200.00 ( 1,399.15) 2,242.93 36.18 3,957.07
13,200.00 650.00 3,450.00 26.14 9,750.00
2,500.00 390.00 975.00 39.00 1,525.00
400.00 55.00 190.00 47.50 210.00
643,100.00 21,092.60 316,221.91 49.17 326,878.09
120,000.00 8,325.49 51,567.82 92.97 68,432.18
10,000.00 160.00 13,195.50 131.46 ( 3,195.50)
130,000.00 8,485.49 64,713.32 49.78 65,286.68
120,000.00 0.00 3,526.56 2.94 116,473.44
65,000.00 ( 936.50) 322.34 0.50 64,677.66
23,700.00 45.00 3,210.00 13.54 20,490.00
4,000.00 ( 515.63) 2,405.56 60.14 1,594.44
212,700.00 ( 1,407.13) 9,464.96 4.45 203,235.54
35,000.00 0.00
39,500.00 0.00
75,000.00 0.00
270,000.00 0.00
25,000.00 0.00
300,000.00 50,034.00
25,000.00 0.00
15,000.00 0.00
784,500.00 50,034.00
0.00 0.00 35,000.00
0.00 0.00 39,500.00
0.00 0.00 75,000.00
0.00 0.00 270,000.00
0.00 0.00 25,000.00
264,519.98 88.17 35,980.02
0.00 0.00 25,000.00
0.00 0.00 15,000.00
264,519.98 33.72 519,980.02
12,163,450.00 3,595,275.34 4,557,699.25 37.47 7,605,750.75
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 5
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
~ 101-GENERAL FUND
~ DEPARTMENTAL EXPENDITURES
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-4319 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
50.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
38,500.00 3,366.48
1,900.00 100.41
2,400.00 120.89
550.00 48.81
50.00 16.50
43,400.00 3,653.09
3,400.00 63.99
3,400.00 63.99
11,050.00 61.47 3,656.86 33.09 7,393.14
400.00 145.33 289.64 72.41 110.36
2,600.00 112.15 524.49 20.17 2,075.51
17,700.00 0.00 6,089.29 34.40 11,610.71
74,800.00 0.00 32,271.50 43.14 92,528.50
16,000.00 0.00 500.00 3.13 15,500.00
8,450.00 0.00 4,051.73 47.95 4,398.27
131,000.00 318.95 47,383.51 36.17 83,616.49
20,198.88 52.46 18,301.12
602.46 31.71 1,297.54
725.34 30.22 1,674.66
292.86 53.25 257.14
109.75 219.50 ( 59.75)
21,929.29 50.53 21,470.71
456.72 13.43 2,943.28
456.72 13.43 2,943.28
I TOTAL Mayor & Council
Cable TV
Personal Services
101-4-1120-4101 Regular Pay
101-4-1120-4103 Part-time Pay
101-4-1120-4104 PERA
101-4-1120-4105 FICA
101-4-1120-4107 Medicare
101-4-1120-4108 Insurance
101-4-1120-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-1120-4201 Office Supplies
TOTAL Supplies
177,800.00 4,036.03 69,769.52 39.24 108,030.48
54,150.00 4,083.20 24,499.20 45.24 29,650.80
6,500.00 218.75 1,640.64 25.24 4,859.36
3,950.00 296.04 1,924.26 48.72 2,025.74
3,750.00 292.19 1,605.46 42.81 2,194.54
900.00 56.64 375.43 41.71 524.57
5,800.00 670.00 4,020.00 69.31 1,780.00
200.00 60.25 97.50 48.75 102.50
75,250.00 5,627.07 34,162.49 45.40 41,087.51
700.00 0.00 273.92 39.13 426.08
700.00 0.00 273.92 39.13 426.08
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 6
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 101-GENERAL FUND
General Government
I DEPARTMENTAL EXPENDITURES
50.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE a 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-4409 Equip Repair/Maint Services
TOTAL Other Services & Charges
Capital Outlay
50.00 0.00 0.00 0.00 50.00
1,650.00 0.00 43.35 2.63 1,606.65
150.00 0.00 0.00 0.00 150.00
1,850.00 0.00 43.35 2.34 1,806.65
I 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-9-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
77,800.00 5,627.07 34,479.76 44.32 43,320.24
296,450.00 72,963.57 186,995.01 63.08 109,454.99
44,900.00 2,987.69 17,266.46 38.46 27,633.54
24,750.00 1,571.22 11,781.05 47.60 12,968.95
21,150.00 4,632.16 13,243.50 62.62 7,906.50
4,800.00 400.00 2,400.00 50.00 2,400.00
4,950.00 1,090.36 3,104.26 62.71 1,845.74
28,500.00 2,100.02 12,600.12 49.21 15,899.58
1,800.00 967.25 1,428.75 79.38 371.25
927,300.00 86,212.27 248,819.15 58.23 178,980.85
9,500.00 174.51 1,467.55 15.95 8,032.45
9,500.00 174.51 1,467.55 15.45 8,032.45
5,500.00 0.00 5,328.00 96.87 172.00
800.00 2.39 261.33 32.67 538.67
1,000.00 76.17 242.74 24.27 757.26
5,300.00 78.03 627.69 11.84 9,672.31
100.00 0.00 147.50 197.50 ( 47.50)
23,050.00 1,136.93 7,369.18 31.97 15,680.82
1,100.00 105.00 505.00 45.91 595.00
36,850.00 1,398.52 14,481.49 39.30 22,368.56
' TOTAL Administrative Services 473,650.00 87,785.30 264,768.14 55.90 208,881.86
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 7
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 101-GENERAL FUND
General Government
DEPARTMENTAL EXPENDITURES
50.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-4104 PERA
101-4-1220-4105 FICA
101-4-1220-4107 Medicare
101-4-1220-4108 Insurance
101-4-1220-9109 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-9-1220-9331 Travel, Conferences & Schools
101-4-1220-9433 Dues & Subscriptions
101-4-1220-9440 Miscellaneous
TOTAL Other Services & Charges
Capital Outlay
67,850.00 5,219.24 31,580.30 96.54 36,269.70
98,350.00 3,531.53 22,121.70 45.75 26,228.30
8,450.00 634.44 9,242.66 50.21 4,207.34
7,200.00 497.32 3,427.98 97.61 3,772.02
1,700.00 116.30 801.64 47.16 898.36
5,800.00 1,234.01 5,851.05 100.88 ( 51.05)
600.00 159.00 478.00 79.67 122.00
139,950.00 11,391.84 68,503.33 48.95 71,446.67
3,200.00 69.19 2,151.36 67.23 1,048.64
3,200.00 69.19 2,151.36 67.23 1,048.64
3,000.00 0.00 311.25 10.38 2,688.75
350.00 277.79 564.09 161.17 ( 214.09)
2,350.00 0.00 211.06 8.98 2,138.94
900.00 0.00 0.00 0.00 900.00
1,000.00 62.50 399.90 39.99 600.10
7,600.00 340.29 1,486.30 19.56 6,113.70
TOTAL Human Resources
Elections
Personal Services
Supplies
Other Services & Charges
101-4-1230-4404 Equip Repair/Maint Services
TOTAL Other Services & Charges
Capital Outlay
150,750.00 11,801.32 72,140.99 47.85 78,609.01
0.00 3,510.00 0.00 0.00 0.00
0.00 3,510.00 0.00 0.00 0.00
TOTAL Elections
0.00 3,510.00 0.00 0.00 0.00
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 8
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 101-GENERAL FUND
General Government
I DEPARTMENTAL EXPENDITURES
CURRENT CURRENT
BUDGET PERIOD
50.00 OF YEAR COMP.
YEAR TO DATE °s OF BUDGET
ACTUAL BUDGET BALANCE
' Finance
Personal Services
101-4-1310-4101 Regular Pay
101-4-1310-4104 PERA
101-4-1310-4105 FICA
101-4-1310-4107 Medicare
101-4-1310-4108 Insurance
101-4-1310-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-1310-4201 Office Supplies
TOTAL Supplies
Other Services & Charges
101-4-1310-4301 Audit Fees
101-4-1310-4319 Other Professional Services
101-4-1310-4321 Telephone
101-4-1310-4322 Postage
101-4-1310-4331 Travel, Conferences & Schools
101-4-1310-4359 Publishing
101-4-1310-4404 Equip Repair/Maint Services
101-4-1310-4433 Dues & Subscriptions
101-4-1310-4440 Miscellaneous
TOTAL Other Services & Charges
Capital Outlay
287,800.00 22,139.36 132,836.20 46.16 154,963.80
20,850.00 1,605.10 10,433.15 50.04 10,416.85
17,850.00 1,290.78 8,429.77 47.23 9,920.23
4,200.00 301.86 1,971.39 46.94 2,228.61
25,850.00 2,100.01 12,600.06 48.74 13,249.94
1,500.00 393.75 1,191.25 79.92 308.75
358,050.00 27,830.86 167,461.82 46.77 190,588.18
3,850.00 764.23 1,158.26 30.08 2,691.79
3,850.00 764.23 1,158.26 30.08 2,691.74
18,300.00 0.00 13,500.00 73.77 9,800.00
53,500.00 0.00 48,816.50 91.25 4,683.50
800.00 2.67 243.44 30.93 556.56
3,600.00 460.03 964.96 26.80 2,635.04
2,500.00 4.32 476.57 19.06 2,023.43
1,300.00 0.00 0.00 0.00 1,300.00
11,300.00 0.00 11,116.28 98.37 183.72
1,500.00 0.00 735.00 49.00 765.00
0.00 46.00 46.00 0.00 ( 96.00)
92,800.00 513.02 75,898.75 81.79 16,901.25
TOTAL Finance
Information Technology
Personal Services
101-4-1350-4101 Regular Pay
101-9-1350-4103 Part-time Pay
101-4-1350-4109 PERA
101-4-1350-4105 FICA
101-4-1350-4107 Medicare
101-4-1350-4108 Insurance
101-4-1350-4109 Workers Comp
TOTAL Personal Services
454,700.00 29,108.11 294,518.83 53.78 210,181.17
128,400.00 9,875.45 59,252.70 46.15 69,147.30
5,000.00 0.00 1,000.00 20.00 4,000.00
9,300.00 715.98 4,653.87 50.04 4,646.13
8,250.00 551.20 3,746.67 45.91 4,503.33
1,950.00 128.90 876.25 44.94 1,073.75
19,850.00 1,626.01 9,756.06 49.15 10,093.94
650.00 182.50 562.50 86.54 87.50
173,400.00 13,080.04 79,898.05 46.05 93,551.95
7-13-2011 10:50 AM CITY OE ELK RIVER PAGE: 9
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 101-GENERAL FUND
General Government
~ DEPARTMENTAL EXPENDITURES
Supplies
101-9-1350-4219 Operating Supplies 25,100.00
TOTAL Supplies 25,100.00
Other Services & Charges
101-4-1350-4319 Other Professional Services 8,000.00
101-4-1350-4321 Telephone 1,450.00
101-9-1350-4331 Travel, Conferences & Schools 8,000.00
101-4-1350-4404 Equip Repair/Maint Services 19,750.00
TOTAL Other Services & Charges 37,200.00
Capital Outlay
101-4-1350-4560 Equipment 30,900.00
TOTAL Capital Outlay 30,900.00
TOTAL Information Technology
Legal
Personal Services
Supplies
Other Services & Charges
101-4-1900-4304 Legal Fees
TOTAL Other Services & Charges
50.00$ OF YEAR COMP.
CURRENT YEAR TO DATE ~ OF BUDGET
PERIOD ACTUAL BUDGET BALANCE
CURRENT
BUDGET
30.57 4,302.81 17.14 20,797.19
30.57 4,302.81 17.14 20,797.19
0.00 60.00 0.75 7,940.00
54.74 330.75 22.81 1,119.25
67.83 183.72 2.30 7,816.28
0.00 8,073.25 40.88 11,676.75
122.57 8,697.72 23.25 28,552.28
0.00 21,133.90 68.39 9,766.10
0.00 21,133.90 68.39 9,766.10
266,600.00 13,233.18 113,932.48 42.79 152,667.52
240,000.00 28,657.36 114,456.21 47.69 125,543.79
240,000.00 28,657.36 114,456.21 47.69 125,543.79
TOTAL Legal
Community Development
Personal Services
101-4-1500-4101 Regular Pay
101-4-1500-4104 PERA
101-4-1500-4105 FICA
101-4-1500-4107 Medicare
101-4-1500-4108 Insurance
101-4-1500-4109 Workers Comp
TOTAL Personal Services
290,000.00 28,657.36 114,956.21 47.69 125,543.79
52,700.00 4,052.80
3,800.00 293.82
3,250.00 241.54
750.00 56.48
5,800.00 486.00
250.00 196.00
66,550.00 5,326.64
24,316.86 46.14 28,383.14
1,909.83 50.26 1,890.17
1,574.88 48.46 1,675.12
368.26 49.10 381.74
2,916.00 50.28 2,884.00
588.00 235.20 ( 338.00)
31,673.83 47.59 34,876.17
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 10
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 101-GENERAL FUND
General Government
I DEPARTMENTAL EXPENDITURES
50.00°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Supplies
101-9-1500-4201 Office Supplies 150.00
TOTAL Supplies 150.00
Other Services & Charges
101-4-1500-4331 Travel, Conferences & Schools 400.00
TOTAL Other Services & Charges 400.00
0.00 0.00 0.00 150.00
0.00 0.00 0.00 150.00
0.00 0.00 0.00 400.00
0.00 0.00 0.00 900.00
TOTAL Community Development
Planning
Personal Services
101-4-1510-4101 Regular Pay
101-4-1510-4104 PERA
101-4-1510-4105 FICA
101-4-1510-4107 Medicare
101-4-1510-4108 Insurance
101-4-1510-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-1510-4201 Office Supplies
101-4-1510-9212 Fuels & Lubs
101-4-1510-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-1510-4321 Telephone
101-4-1510-4322 Postage
101-4-1510-4331 Travel, Conferences & Schools
101-4-1510-4359 Publishing
101-4-1510-4361 Insurance
101-4-1510-4404 Equip Repair/Maint Services
101-9-1510-4433 Dues & Subscriptions
101-4-1510-4490 Miscellaneous
101-4-1510-4460 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
67,100.00 5,326.64 31,673.83 47.20 35,426.17
211,900.00 16,301.69 97,810.12 46.16 114,089.88
15,350.00 1,181.88 7,682.22 50.05 7,667.78
13,150.00 922.90 6,042.76 45.95 7,107.24
3,100.00 215.84 1,413.23 45.59 1,686.77
28,300.00 2,324.03 13,944.18 49.27 19,355.82
700.00 285.50 858.50 122.64 ( 158.50)
272,500.00 21,231.84 127,751.01 46.88 194,748.99
4,750.00 226.66 1,683.57 35.44 3,066.43
1,850.00 125.27 806.16 43.58 1,043.84
0.00 0.00 175.00 0.00 ( 175.00)
6,600.00 351.93 2,664.73 40.37 3,935.27
1,150.00 51.78 279.81 24.33 870.19
3,200.00 331.29 800.89 25.03 2,399.11
3,000.00 48.00 929.00 30.97 2,071.00
8,000.00 100.75 1,420.75 17.76 6,579.25
400.00 0.00 207.00 51.75 193.00
6,900.00 342.10 1,765.20 25.58 5,134.80
1,000.00 0.00 545.00 54.50 455.00
0.00 0.00 138.00 0.00 ( 138.00)
800.00 66.66 399.96 50.00 400.09
24,450.00 940.58 6,485.61 26.53 17,964.39
I TOTAL Planning 303,550.00 22,524.35 136,901.35 95.10 166,648.65
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 11
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 101-GENERAL FUND
General Government
I DEPARTMENTAL EXPENDITURES
50.00°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE °s OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
City Hall Maintenance
Personal Services
101-4-1600-4101 Regular Pay
101-4-1600-9102 Overtime Pay
101-4-1600-9103 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-9109 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-9321 Telephone
101-4-1600-4331 Travel, Conferences & Schools
101-4-1600-4361 Insurance
101-4-1600-4389 Utilities
101-4-1600-4401 Bldg Repair/Maint Services
101-4-1600-4404 Equip Repair/Maint Services
101-4-1600-4460 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
104,350.00 7,921.93 46,982.56 45.02 57,367.44
2,500.00 0.00 0.00 0.00 2,500.00
19,050.00 1,715.15 7,686.36 90.35 11,363.64
9,150.00 659.33 9,336.95 47.40 4,813.05
7,800.00 602.04 3,758.27 98.18 4,041.73
1,800.00 140.82 879.02 98.83 920.98
17,200.00 1,251.12 7,751.93 45.07 9,448.07
5,850.00 1,229.00 3,687.00 63.03 2,163.00
167,700.00 13,519.39 75,082.09 44.77 92,617.91
3,450.00 147.74 1,247.13 36.15 2,202.87
1,700.00 0.00 631.69 37.16 1,068.31
28,900.00 2,628.60 10,291.78 35.61 18,608.22
34,050.00 2,776.34 12,170.60 35.74 21,879.40
12,250.00 176.14 5,796.72 47.32 6,453.28
1,500.00 493.20 733.20 98.88 766.80
4,850.00 0.00 2,372.50 48.92 2,477.50
43,800.00 2,091.50 17,178.00 39.22 26,622.00
30,600.00 731.94 5,671.64 18.53 24,928.36
5,000.00 0.00 312.54 6.25 4,687.96
1,100.00 91.67 550.02 50.00 549.98
99,100.00 3,584.45 32,614.62 32.91 66,485.38
TOTAL City Hall Maintenance
Contingency
Other Services & Charges
101-4-1900-4440 Miscellaneous
TOTAL Other Services & Charges
300,850.00 19,880.18 119,867.31 39.84 180,982.69
75,000.00 0.00 0.00 0.00 75,000.00
75,000.00 0.00 0.00 0.00 75,000.00
TOTAL Contingency 75,000.00 0.00 0.00 0.00 75,000.00
TOTAL General Government 2,587,800.00 231,489.54 1,202,508.92 46.47 1,385,291.58
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 12
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 101-GENERAL FUND
Public Safety
~ DEPARTMENTAL EXPENDITURES
' Police-Administration
Personal Services
101-9-2110-4101 Regular Pay
101-4-2110-4104 PERA
101-4-2110-4105 FICA
101-4-2110-9107 Medicare
101-4-2110-4108 Insurance
101-4-2110-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-2110-4201 Office Supplies
101-4-2110-4217 Uniform Allowance
101-4-2110-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-2110-4319 Other Professional Services
101-4-2110-4321 Telephone
101-4-2110-4322 Postage
101-4-2110-4331 Travel, Conferences & Schools
101-4-2110-4359 Publishing
101-4-2110-4361 Insurance
101-4-2110-4404 Equip Repair/Maint Services
101-4-2110-4433 Dues & Subscriptions
101-4-2110-4937 Taxes & Licenses
TOTAL Other Services & Charges
' Capital Outlay
50.00$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
275,900.00 21,850.70 124,291.37 45.13 151,108.63
39,650.00 3,077.69 18,853.13 47.55 20,796.87
0.00 59.68 59.68 0.00 ( 59.68)
2,750.00 205.06 1,180.58 92.93 1,569.42
25,650.00 1,844.02 10,606.12 91.35 15,043.88
59,350.00 14,375.25 43,669.75 73.58 15,680.25
402,800.00 41,412.40 198,660.63 49.32 204,139.37
19,000.00 517.49 3,351.24 17.64 15,648.76
2,250.00 395.33 1,627.27 72.32 622.73
4,600.00 2,388.86 2,878.96 62.59 1,721.04
25,850.00 3,301.68 7,857.47 30.40 17,992.53
4,950.00
29,300.00
2,200.00
3,350.00
500.00
9,600.00
75,250.00
9,200.00
800.00
135,150.00
36.98 433.16 8.75
1,754.77 9,055.51 30.91
805.01 1,257.25 57.15
0.00 2,053.25 61.29
0.00 57.00 11.40
0.00 3,500.50 36.46
672.92 49,453.48 65.72
120.00 5,640.25 61.31
0.00 189.75 23.72
3,389.68 71,640.15 53.01
63,509.85
TOTAL Police Administration
Patrol
Personal Services
101-4-2120-9101 Regular Pay
101-4-2120-9102 Overtime Pay
101-4-2120-4104 PERA
101-4-2120-4107 Medicare
101-4-2120-4108 Insurance
TOTAL Personal Services
563,800.00 48,103.76 278,158.25 49.34 285,641.75
1,444,350.00 100,531.73 607,212.81 42.04 837,137.19
90,000.00 10,506.74 25,687.43 28.54 64,312.57
220,950.00 15,989.49 98,618.85 44.63 122,331.15
19,950.00 1,308.93 8,084.84 40.53 11,865.16
171,450.00 13,494.28 81,735.96 47.67 89,714.09
1,946,700.00 141,831.17 821,339.89 42.19 1,125,360.11
4,516.84
20,244.49
942.75
1,296.75
443.00
6,099.50
25,796.52
3,559.75
610.25
7-13-2011 10:50 AM
I 101-GENERAL FUND
Public Safety
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER PAGE: 13
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
50.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Supplies
101-4-2120-4212 Fuels & Lubs
101-4-2120-4217 Uniform Allowance
101-4-2120-9219 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-9433 Dues & Subscriptions
101-9-2120-4460 Equip Replacement Charge
TOTAL Other Services & Charges
I Capital Outlay
108,500.00 8,692.45 44,577.24 41.09 63,922.76
23,900.00 1,750.83 5,370.66 22.47 18,529.39
58,650.00 2,025.23 22,143.56 37.76 36,506.49
28,000.00 1,421.71 6,655.57 23.77 21,344.43
219,050.00 13,890.22 78,747.03 35.95 140,302.97
15,650.00 1,628.47 7,067.45 45.16 8,582.55
26,700.00 1,040.33 9,917.20 37.14 16,752.80
550.00 0.00 340.00 61.82 210.00
44,150.00 3,679.17 22,075.02 50.00 22,074.98
87,050.00 6,347.97 39,399.67 45.26 47,650.33
TOTAL Patrol
Investigations
Personal Services
101-4-2130-4101 Regular Pay
101-4-2130-4102 Overtime Pay
101-4-2130-4104 PERA
101-4-2130-9107 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-4319 Other Professional Services
101-4-2130-4331 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 162,069.36 939,986.59 41.70 1,313,313.41
505,600.00 36,244.80 211,148.82 41.76 294,451.18
45,000.00 1,884.15 7,339.10 16.31 37,660.90
79,300.00 5,990.53 34,141.70 43.05 45,158.30
5,850.00 416.95 2,534.62 43.33 3,315.38
70,100.00 5,499.63 33,419.24 47.67 36,685.76
705,850.00 49,536.06 288,578.48 40.88 417,271.52
5,150.00 622.70 2,190.99 42.59 2,959.01
8,700.00 182.57 1,587.88 18.25 7,112.12
13,850.00 805.27 3,778.87 27.28 10,071.13
11,900.00 80.00 1,301.81 10.94 10,598.19
5,550.00 0.00 2,168.58 39.07 3,381.42
1,050.00 0.00 150.00 14.29 900.00
14,250.00 1,187.50 7,125.00 50.00 7,125.00
32,750.00 1,267.50 10,745.39 32.81 22,004.61
TOTAL Investigations 752,450.00 51,608.83 303,102.74 40.28 449,347.26
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 19
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 101-GENERAL FUND
Public Safety
~ DEPARTMENTAL EXPENDITURES
I Police-Support-Services
Personal Services
101-4-2150-4101 Regular Pay
101-4-2150-9102 Overtime Pay
101-4-2150-4104 PERA
101-4-2150-4105 FICA
101-4-2150-4107 Medicare
101-4-2150-4108 Insurance
TOTAL Personal Services
Supplies
101-4-2150-4201 Office Supplies
101-4-2150-9217 Uniform Allowance
101-9-2150-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-2150-4331 Travel, Conferences & Schools
101-9-2150-4404 Equip Repair/Maint Services
101-4-2150-4409 Contractual Services
101-4-2150-4433 Dues & Subscriptions
101-4-2150-4460 Equip Replacement Charge
TOTAL Other Services & Charges
' Capital Outlay
50.00$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
347,050.00 29,357.83 161,885.53 46.65 185,164.47
3,500.00 0.00 0.00 0.00 3,500.00
25,900.00 1,768.98 12,530.86 99.33 12,869.14
21,750.00 1,699.99 10,560.89 98.56 11,189.11
5,100.00 397.58 2,488.56 98.80 2,611.94
46,350.00 3,262.02 22,129.09 47.74 24,220.91
449,150.00 36,486.40 209,594.93 46.66 239,555.07
1,000.00 0.00 453.77 95.38 546.23
3,000.00 234.40 395.32 13.18 2,604.68
10,100.00 169.48 1,825.50 18.07 8,274.50
14,100.00 903.88 2,674.59 18.97 11,425.41
3,550.00 36.72 229.53 6.47 3,320.47
1,850.00 0.00 0.00 0.00 1,850.00
16,000.00 939.09 3,740.31 23.38 12,259.69
500.00 0.00 233.33 46.67 266.67
6,550.00 545.83 3,274.98 50.00 3,275.02
28,450.00 1,521.64 7,478.15 26.29 20,971.85
TOTAL Police Support Services
~ Police Reserves
Personal Services
101-4-2160-4103 Part-time Pay
101-4-2160-4104 PERA
101-4-2160-4105 FICA
101-4-2160-4107 Medicare
101-9-2160-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-2160-4217 Uniform Allowance
101-4-2160-4219 Operating Supplies
TOTAL Supplies
491,700.00 38,411.92 219,747.67 49.69 271,952.33
5,500.00 587.40 6,551.52 119.12 ( 1,051.52)
0.00 30.97 73.55 0.00 ( 73.55)
350.00 36.41 459.16 131.19 ( 109.16)
100.00 8.52 107.39 107.39 ( 7.39)
0.00 0.00 1,026.00 0.00 ( 1,026.00)
5,950.00 663.30 8,217.62 138.11 ( 2,267.62)
5,000.00 961.49 1,556.77 31.14 3,443.23
6,000.00 618.34 859.61 14.33 5,190.39
11,000.00 1,579.83 2,416.38 21.97 8,583.62
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 15
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 101-GENERAL FUND
Public Safety
~ DEPARTMENTAL EXPENDITURES
Other Services & Charges
101-4-2160-9319 Other Professional Services
101-4-2160-4321 Telephone
101-4-2160-4331 Travel, Conferences & Schools
101-4-2160-4359 Publishing
101-4-2160-4433 Dues & Subscriptions
TOTAL Other Services & Charges
Capital Outlay
TOTAL Police Reserves
Public safety building
Personal Services
101-4-2190-4101 Regular Pay
101-4-2190-4104 PERA
101-4-2190-4105 FICA
101-4-2190-4107 Medicare
101-4-2190-4108 Insurance
101-4-2190-9109 Workers Comp
TOTAL Personal Services
Supplies
101-4-2190-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-2190-4361 Insurance
101-4-2190-4389 Utilities
101-4-2190-4401 Bldg Repair/Maint Services
TOTAL Other Services & Charges
Capital Outlay
CURRENT CURRENT YEAR TO DATE
BUDGET PERIOD ACTUAL
50.00$ OF YEAR COMP.
~ OF BUDGET
BUDGET BALANCE
1,500.00 0.00 0.00 0.00 1,500.00
1,600.00 0.00 0.00 0.00 1,600.00
1,700.00 0.00 100.00 5.88 1,600.00
150.00 0.00 0.00 0.00 150.00
1,000.00 0.00 585.00 58.50 415.00
5,950.00 0.00 685.00 11.51 5,265.00
22,900.00 2,243.13 11,319.00 49.43 11,581.00
101,850.00 7,431.80 44,223.94 43.42 57,626.56
7,400.00 538.79 3,447.09 96.58 3,952.91
6,300.00 450.55 2,868.04 45.52 3,431.96
1,500.00 105.37 670.75 44.72 829.25
13,300.00 1,148.93 6,471.23 48.66 6,828.77
3,900.00 1,005.75 2,843.25 83.63 556.75
133,750.00 10,681.19 60,523.80 45.25 73,226.20
15,000.00 1,359.86 6,926.04 96.17 8,073.96
15,000.00 1,359.86 6,926.04 46.17 8,073.96
6,750.00 0.00 2,570.00 38.07 4,180.00
18,200.00 1,310.19 12,311.12 67.64 5,888.88
31,300.00 1,031.85 4,071.13 13.01 27,228.87
56,250.00 2,341.99 18,952.25 33.69 37,297.75
TOTAL Public safety building
Fire Administration
205,000.00 14,383.04 86,402.09 42.15 118,597.91
Personal Services
101- 9-2310 -4101 Regular Pay 86,200.00 6,859.18 41,035.20 47.60 45,164.80
101- 4-2310 -4103 Part-time Pay 186,250.00 11,810.69 77,116.84 41.41 109,133.16
101- 4-2310 -4104 PERA 13,500.00 1,066.60 6,877.38 50.94 6,622.62
101- 4-2310 -4105 FICA 12,500.00 725.86 5,065.98 40.53 7,434.02
101- 9-2310 -4106 Other Retirement Contributions 38,500.00 0.00 0.00 0.00 38,500.00
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 16
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
101-GENERAL FUND
Public Safety
~ DEPARTMENTAL EXPENDITURES
50.00$ OF YEAR COMP.
CURRENT CURRENT
BUDGET PERIOD
YEAR TO DATE °s OF BUDGET
ACTUAL BUDGET BALANCE
101-4-2310-4107 Medicare
101-4-2310-4108 Insurance
101-4-2310-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-2310-9201 Office Supplies
101-4-2310-4212 Fuels & Lubs
101-4-2310-4217 Uniform Allowance
101-4-2310-4219 Operating Supplies
101-9-2310-4221 Equipment Parts
TOTAL Supplies
Other Services & Charges
101-4-2310-9319 Other Professional Services
101-4-2310-4321 Telephone
101-4-2310-4322 Postage
101-4-2310-4331 Travel, Conferences & Schools
101-4-2310-4359 Publishing
101-4-2310-4361 Insurance
101-4-2310-4389 Utilities
101-4-2310-9401 Bldg Repair/Maint Services
101-4-2310-4404 Equip Repair/Maint Services
101-4-2310-4433 Dues & Subscriptions
101-4-2310-4460 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
101-4-2310-4560 Equipment
TOTAL Capital Outlay
TOTAL Fire Administration
Fire Inspections
--------------
--------------
Personal Services
101-4-2320-9101 Regular Pay
101-4-2320-4104 PERA
101-4-2320-4105 FICA
101-4-2320-4107 Medicare
101-4-2320-4108 Insurance
TOTAL Personal Services
3,950.00 247.24 1,688.49 42.75 2,261.51
7,200.00 1,112.71 6,270.55 87.09 929.45
20,200.00 5,245.50 15,284.50 75.67 4,915.50
368,300.00 27,067.78 153,338.94 41.63 214,961.06
5,150.00 237.30 4,097.97 79.57 1,052.03
7,350.00 411.53 3,144.16 42.78 4,205.84
4,400.00 145.35 631.47 14.35 3,768.53
26,150.00 927.85 9,139.41 34.95 17,010.59
7,400.00 133.89 1,932.43 26.11 5,967.57
50,450.00 1,855.92 18,945.44 37.55 31,504.56
5,100.00 0.00 2,330.99 45.71 2,769.01
4,950.00 95.86 843.75 17.05 4,106.25
500.00 119.77 203.41 40.68 296.59
27,450.00 3,604.02 11,283.79 41.11 16,166.21
300.00 0.00 0.00 0.00 300.00
17,500.00 0.00 7,467.50 42.67 10,032.50
15,150.00 701.38 8,014.56 52.90 7,135.44
5,650.00 1,678.87 1,993.32 35.28 3,656.68
31,550.00 2,554.92 13,714.92 43.47 17,835.58
1,950.00 0.00 1,351.00 69.28 599.00
29,650.00 2,470.83 14,824.98 50.00 14,825.02
139,750.00 11,225.65 62,027.72 44.38 77,722.28
31,100.00 0.00 20,843.44 67.02 10,256.56
31,100.00 0.00 20,843.94 67.02 10,256.56
589,600.00 40,149.35 255,155.54 43.28 334,444.46
129,400.00 9,940.08 60,004.98 46.37 69,395.02
14,850.00 1,141.60 7,446.83 50.15 7,403.17
3,250.00 261.59 1,789.40 55.06 1,960.60
1,900.00 142.86 951.36 50.07 948.64
14,850.00 1,195.86 7,175.16 48.32 7,674.84
164,250.00 12,681.94 77,367.73 47.10 86,882.27
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 17
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
101-GENERAL FUND
Public Safety
I DEPARTMENTAL EXPENDITURES
50.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-9-2320-4321 Telephone
101-4-2320-4331 Travel, Conferences & Schools
101-4-2320-4404 Equip Repair/Maint Services
101-4-2320-4433 Dues & Subscriptions
TOTAL Other Services & Charges
TOTAL Fire Inspections
Emergency Management
Personal Services
101-4-2330-4101 Regular Pay
101-4-2330-4109 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
2,750.00 42.51 461.69 16.79 2,288.31
3,200.00 335.64 2,108.33 65.89 1,091.67
1,400.00 0.00 0.00 0.00 1,400.00
4,450.00 101.61 701.31 15.76 3,748.69
11,800.00 479.76 3,271.33 27.72 8,528.67
2,950.00 236.02 806.99 27.36 2,143.01
2,500.00 125.00 385.00 15.40 2,115.00
2,000.00 5.16 230.16 11.51 1,769.89
1,350.00 0.00 982.50 72.78 367.50
8,800.00 366.18 2,404.65 27.33 6,395.35
184,850.00 13,527.88 83,043.71 44.92 101,806.29
8,900.00 668.04 4,008.24 45.04 4,891.76
1,300.00 96.20 625.30 98.10 679.70
150.00 9.70 63.05 42.03 86.95
600.00 39.84 239.04 39.84 360.96
10,950.00 813.78 4,935.63 95.07 6,019.37
500.00 0.00 57.94 11.59 442.06
9,150.00 77.99 1,260.79 13.78 7,889.21
9,650.00 77.99 1,318.73 13.67 8,331.27
1,650.00 26.00 153.43 9.30 1,496.57
9,000.00 0.00 40.80 1.02 3,959.20
1,500.00 94.28 503.20 33.55 996.80
7,800.00 96.19 464.95 5.96 7,335.05
100.00 0.00 100.00 100.00 0.00
15,050.00 216.47 1,262.38 8.39 13,787.62
71,750.00 0.00 13,246.43 18.96 58,503.57
71,750.00 0.00 13,246.43 18.46 58,503.57
I TOTAL Emergency Management 107,400.00 1,108.24 20,763.17 19.33 86,636.83
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 18
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
101-GENERAL FUND
Public Safety
I DEPARTMENTAL EXPENDITURES
50.00$ OF YEAR COMP.
CURRENT CURRENT Y"EAR TO DATE °s OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Building Safety
Personal Services
101-4-2410-4101 Regular Pay
101-4-2910-4103 Part-time Pay
101-4-2410-4104 PERA
101-4-2410-4105 FICA
101-4-2410-9107 Medicare
101-4-2410-4108 Insurance
101-4-2410-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-2410-4201 Office Supplies
101-4-2410-9212 Fuels & Lubs
101-4-2910-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-2910-4321 Telephone
101-4-2410-4322 Postage
101-4-2410-4331 Travel, Conferences & Schools
101-4-2410-4361 Insurance
101-4-2410-4404 Equip Repair/Maint Services
101-4-2410-4433 Dues & Subscriptions
101-4-2410-4960 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
I TOTAL Building Safety
Environmental
319,400.00 29,568.17 147,001.98 96.02 172,398.02
25,950.00 2,021.05 11,857.60 45.69 14,092.40
25,050.00 1,927.74 12,481.63 49.83 12,568.37
21,400.00 1,536.43 10,003.39 46.74 11,396.61
5,000.00 359.32 2,339.49 46.79 2,660.51
40,150.00 3,286.02 19,584.52 48.78 20,565.48
1,200.00 370.25 1,111.75 92.65 88.25
438,150.00 34,068.98 204,380.36 46.65 233,769.64
2,500.00 165.46 636.60 25.46 1,863.90
4,700.00 411.48 1,711.06 36.41 2,988.94
2,250.00 0.00 142.24 6.32 2,107.76
9,450.00 576.94 2,489.90 26.35 6,960.10
1,600.00 165.23 823.98 51.50 776.02
400.00 78.26 131.92 32.98 268.08
4,650.00 0.00 1,495.00 32.15 3,155.00
900.00 0.00 299.50 33.28 600.50
7,200.00 324.08 4,360.11 60.56 2,839.89
1,200.00 125.00 315.00 26.25 885.00
1,650.00 137.50 825.00 50.00 825.00
17,600.00 830.07 8,250.51 46.88 9,349.49
465,200.00 35,475.99 215,120.77 46.24 250,079.23
Personal Services
101-4-2490-4101 Regular Pay 39,050.00 3,002.80 18,016.78 46.14
101-4-2440-4104 PERA 2,850.00 217.70 1,406.09 49.34
101-4-2440-4105 FICA 2,400.00 160.96 1,051.18 43.80
101-4-2440-4107 Medicare 550.00 37.64 245.82 44.69
101-4-2440-4108 Insurance 4,850.00 479.59 2,877.55 59.33
101-9-2440-4109 Workers Comp 400.00 136.75 370.25 92.56
TOTAL Personal Services 50,100.00 4,035.44 23,967.67 47.84
21,033.22
1,493.91
1,348.82
304.18
1,972.45
26,132.33
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 19
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 101-GENERAL FUND
Public Safety
I DEPARTMENTAL EXPENDITURES
50.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Supplies
101-4-2490-4201 Office Supplies
101-4-2940-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-2440-4361 Insurance
101-4-2440-4409 Contractual Services
101-4-2940-4433 Dues & Subscriptions
TOTAL Other Services & Charges
650.00 69.09 176.57 27.16 473.43
150.00 34.60 90.65 60.43 59.35
800.00 103.69 267.22 33.40 532.78
700.00
500.00
500.00
100.00
200.00
3,000.00
1,050.00
24.42
177.32
48.00
0.00
0.00
89.00
0.00
155.50 22.21 544.50
574.85 114.97 ( 74.85)
263.66 52.73 236.34
67.50 67.50 32.50
0.00 0.00 200.00
84.00 2.80 2,916.00
40.00 3.81 1,010.00
1,185.51 19.60 9,864.49
6,050.00
333.74
TOTAL Environmental
56,950.00 4,472.87 25,420.40 44.64 31,529.60
TOTAL Public Safety
Street Maintenance
Personal Services
101-4-3120-4101 Regular Pay
101-4-3120-4103 Part-time Pay
101-4-3120-4104 PERA
101-4-3120-4105 FICA
101-4-3120-4107 Medicare
101-4-3120-9108 Insurance
101-4-3120-4109 Workers Comp
TOTAL Personal Services
Supplies
101-9-3120-4201 Office Supplies
101-4-3120-4212 Fuels & Lubs
101-4-3120-4219 Operating Supplies
101-4-3120-4226 Street Signs
TOTAL Supplies
Other Services & Charges
101-4-3120-4319 Other Professional Services
101-4-3120-9321 Telephone
101-4-3120-4322 Postage
101-4-3120-4331 Travel, Conferences & Schools
101-4-3120-4359 Publishing
101-4-3120-4361 Insurance
101-4-3120-9389 Utilities
5,692,650.00 911,554.37 2,437,719.93 42.82 3,254,930.07
426,650.00 38,050.10 173,358.57 40.63 253,291.43
78,400.00 6,551.96 25,659.58 32.73 52,740.42
34,950.00 2,688.67 13,892.09 39.75 21,057.96
31,300.00 2,560.11 12,114.59 38.70 19,185.41
7,350.00 598.72 2,833.21 38.55 4,516.79
57,050.00 5,422.05 21,870.53 38.34 35,179.47
25,050.00 6,120.00 19,308.00 77.08 5,792.00
660,750.00 61,991.61 269,036.52 40.72 391,713.48
3,600.00 134.85 346.85 9.63 3,253.15
64,250.00 4,847.60 46,505.28 72.38 17,744.72
146,750.00 8,057.82 32,143.60 21.90 114,606.40
42,000.00 600.79 6,629.11 15.78 35,370.89
256,600.00 13,641.01 85,624.84 33.37 170,975.16
250.00 0.00 0.00 0.00 250.00
8,950.00 369.52 2,300.07 25.70 6,649.93
200.00 15.07 31.22 15.61 168.78
3,000.00 0.00 776.66 25.89 2,223.34
500.00 0.00 0.00 0.00 500.00
17,250.00 0.00 8,716.50 50.53 8,533.50
36,000.00 3,013.65 18,996.65 52.77 17,003.35
I 7-13-2011 10:50 AM
101-GENERAL FUND
Public Works
DEPARTMENTAL EXPENDITURES
50.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
101-4-3120-4401 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-9-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
4,500.00 200.00 1,123.87 24.97 3,376.13
5,000.00 344.06 2,872.09 57.44 2,127.91
422,750.00 90.00 25,403.62 6.01 397,346.38
10,000.00 96.19 480.95 4.81 9,519.05
4,700.00 100.12 693.96 19.77 4,006.09
350.00 0.00 251.25 71.79 98.75
500.00 0.00 83.25 16.65 416.75
93,150.00 7,762.50 46,575.00 50.00 46,575.00
607,100.00 11,991.11 108,305.09 17.84 498,794.91
TOTAL Street Maintenance
1 Snow Removal
Personal Services
101-4-3130-4101 Regular Pay
101-4-3130-4102 Overtime Pay
101-9-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-9-3130-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
Capital Outlay
1,524,950.00 87,623.73 462,966.95 30.37 1,061,483.55
115,500.00 0.00 69,593.29 60.25 45,906.71
15,000.00 0.00 17,367.13 115.78 ( 2,367.13)
9,050.00 0.00 7,728.95 85.40 1,321.55
8,100.00 0.00 6,190.07 76.42 1,909.93
1,900.00 0.00 1,447.62 76.19 452.38
15,950.00 0.00 14,176.21 88.88 1,773.79
7,350.00 1,696.00 3,432.00 46.69 3,918.00
172,850.00 1,696.00 119,934.77 69.39 52,915.23
90,000.00 175.00 75,540.33 83.93 14,459.67
90,000.00 175.00 75,540.33 83.93 19,459.67
TOTAL Snow Removal
' 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
CITY OF ELK RIVER PAGE: 20
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
262,850.00 1,871.00 195,975.10 74.37 67,374.90
162,750.00 12,520.00 70,279.45 43.18 92,470.55
0.00 0.00 41.39 0.00 ( 41.39)
11,800.00 907.68 5,406.20 45.82 6,393.80
10,100.00 716.10 4,315.11 42.72 5,784.89
2,350.00 167.48 1,009.20 42.94 1,340.80
22,700.00 1,882.01 9,206.19 40.56 13,493.81
7,050.00 999.50 2,835.50 40.22 4,214.50
216,750.00 17,192.77 93,093.04 42.95 123,656.96
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 21
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
101-GENERAL FUND
Public Works
DEPARTMENTAL EXPENDITURES
50.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Supplies
101-4-3150-4219 Operating Supplies
101-4-3150-4221 Equipment Parts
TOTAL Supplies
Other Services & Charges
101-4-3150-9404 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-4109 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-9404 Equip Repair/Maint Services
101-4-3300-4460 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
14,500.00 908.11 6,855.64 47.28 7,644.36
11,200.00 0.00 0.00 0.00 11,200.00
25,700.00 908.11 6,855.64 26.68 18,844.36
500.00 0.00 182.16 36.43 317.84
3,000.00 202.08 1,092.47 36.42 1,907.53
3,500.00 202.08 1,274.63 36.42 2,225.37
245,950.00 18,302.96 101,223.31 91.16 144,726.69
116,75G.00 6,627.92 39,767.52 34.06 76,982.48
8,450.00 480.52 3,123.38 36.96 5,326.62
7,250.00 360.58 2,368.95 32.68 4,881.05
1,700.00 84.32 553.97 32.59 1,146.03
13,000.00 928.01 5,568.06 42.83 7,431.94
450.00 123.00 ( 20.00) 9.44- 470.00
147,600.00 8,604.35 51,361.88 34.80 96,238.12
1,000.00 0.00 0.00 0.00 1,000.00
700.00 94.95 260.16 37.17 439.84
9,800.00 44.66 68.17 0.70 9,731.83
11,500.00 139.61 328.33 2.86 11,171.67
10,000.00 1,020.00 852.81 8.53 9,147.19
1,150.00 0.31 6.29 0.55 1,193.71
200.00 61.23 70.12 35.06 129.88
5,850.00 0.00 175.00 2.99 5,675.00
200.00 0.00 92.00 46.00 108.00
500.00 187.03 1,122.18 224.44 ( 622.18)
800.00 66.67 400.02 50.00 399.98
18,700.00 1,335.24 2,718.42 14.54 15,981.58
TOTAL Engineering
177,800.00 10,079.20 54,408.63 30.60 123,391.37
TOTAL Public Works 2,211,050.00 117,876.89 819,073.49 36.82 1,396,976.51
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 22
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 101-GENERAL FUND
Culture & Recreation
~ DEPARTMENTAL EXPENDITURES
' Parks-Department
Personal Services
101-4-5110-9101 Regular Pay
101-4-5110-9102 Overtime Pay
101-4-5110-4103 Part-time Pay
101-4-5110-4104 PERA
101-4-5110-4105 FICA
101-4-5110-4107 Medicare
101-4-5110-4108 Insurance
101-4-5110-4109 Workers Comp
101-4-5110-4110 Re-employment Compensation
TOTAL Personal Services
Supplies
101-4-5110-4212 Fuels & Lubs
101-4-5110-4217 Uniform Allowance
101-4-5110-4219 Operating Supplies
101-4-5110-4221 Equipment Parts
TOTAL Supplies
Other Services & Charges
101-4-5110-4321 Telephone
101-4-5110-4322 Postage
101-4-5110-4331 Travel, Conferences & Schools
101-4-5110-4361 Insurance
101-4-5110-9389 Utilities
101-4-5110-4401 Bldg Repair/Maint Services
101-4-5110-4909 Equip Repair/Maint Services
101-4-5110-4409 Contractual Services
101-4-5110-4415 Equipment Rental
101-4-5110-4460 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
TOTAL Parks Department
Parks & Rec Admin
790,350.00 67,998.38 339,456.30 42.95 450,893.70
Personal Services
101-4 -5210-9101 Regular Pay 338,950.00 19,096.28 114,349.96 33.74 224,600.04
101-4 -5210-4103 Part-time Pay 20,850.00 2,684.75 16,685.78 80.03 9,164.22
101-4 -5210-4104 PERA 26,100.00 1,579.14 10,270.00 39.35 15,830.00
101-4 -5210-4105 FICA 22,300.00 1,258.50 8,146.54 36.53 14,153.46
101-4 -5210-4107 Medicare 5,200.00 294.34 1,905.32 36.69 3,294.68
SO.OOo OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
350,250.00 25,535.64 155,327.28 44.35 194,922.72
0.00 0.00 19.00 0.00 ( 19.00)
40,000.00 7,278.00 11,139.50 27.85 28,860.50
25,400.00 2,017.75 12,536.44 49.36 12,863.56
24,200.00 1,894.16 10,291.56 42.53 13,908.94
5,650.00 442.99 2,407.00 42.60 3,243.00
46,900.00 3,996.48 23,870.44 50.90 23,029.56
9,000.00 2,409.50 7,572.50 84.14 1,427.50
0.00 0.00 2,483.00 0.00 ( 2,483.00)
501,400.00 43,579.52 225,646.72 45.00 275,753.28
33,200.00 1,501.65 11,204.44 33.75 21,995.56
3,250.00 394.77 1,206.28 37.12 2,043.72
72,900.00 12,419.46 33,482.08 45.93 39,417.92
11,000.00 555.20 10,027.11 91.16 972.89
120,350.00 14,871.08 55,919.91 46.46 64,930.09
4,400.00 289.83 1,164.16 26.46 3,235.84
100.00 0.00 0.00 0.00 100.00
3,150.00 0.00 706.07 22.41 2,443.93
26,700.00 0.00 12,814.50 47.99 13,885.50
27,800.00 .1,366.60 2,096.74 7.54 25,703.26
4,000.00 0.00 0.00 0.00 4,000.00
12,000.00 1,160.63 5,051.38 42.09 6,948.62
7,550.00 374.07 2,774.07 36.74 4,775.93
25,000.00 1,536.65 4,332.75 17.33 20,667.25
57,900.00 4,825.00 28,950.00 50.00 28,950.00
168,600.00 9,552.78 57,889.67 34.39 110,710.33
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 23
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
101-GENERAL FUND
Culture & Recreation
DEPARTMENTAL EXPENDITURES
CURRENT
BUDGET
CURRENT
PERIOD
YEAR TO DATE
ACTUAL
SO.OOo
~ OF
BUDGET
OF YEAR COMP.
BUDGET
BALANCE
101-4-5210-4108 Insurance 45,600.00 2,743.15 17,188.28 37.69 28,411.72
101-4-5210-4109 Workers Comp 3,750.00 988.50 2,769.50 73.85 980.50
TOTAL Personal Services 462,750.00 28,644.66 171,315.38 37.02 291,934.62
Supplies
101-4-5210-4219 Operating Supplies 11,700.00 423.56 7,725.94 66.03 3,974.06
TOTAL Supplies 11,700.00 423.56 7,725.94 66.03 3,974.06
Other Services & Charges
101-4-5210-4321 Telephone 4,800.00 205.70 1,423.81 29.66 3,376.19
101-4-5210-4322 Postage 4,000.00 45.29 1,950.12 48.75 2,049.88
101-4-5210-4331 Travel, Conferences & Schools 6,950.00 1,239.31 1,741.77 25.06 5,208.23
101-4-5210-4349 Advertising/Marketing 26,400.00 2,713.34 14,329.37 54.28 12,070.63
101-4-5210-4361 Insurance 1,950.00 0.00 307.50 21.21 1,142.50
101-4-5210-4389 Utilities 8,500.00 312.50 2,903.58 34.16 5,596.42
101-4-5210-9401 Bldg Repair/Maint Services 12,850.00 1,744.64 7,992.40 62.20 4,857.60
101-9-5210-4404 Equip Repair/Maint Services 9,350.00 558.13 5,503.14 58.86 3,846.86
101-4-5210-4433 Dues & Subscriptions 1,550.00 0.00 1,083.00 69.87 467.00
TOTAL Other Services & Charges 75,850.00 6,818.86 37,239.69 49.09 38,615.31
Capital Outlay
TOTAL Parks & Rec Admin
Recreation Programs
Personal Services
101-4-5220-4102 Overtime Pay
101-4-5220-4103 Part-time Pay
101-4-5220-9104 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-4404 Equip Repair/Maint Services
101-4-5220-9409 Contractual Services
101-4-5220-4412 Building Rent
101-4-5220-4438 Credit Card Fees
TOTAL Other Services & Charges
550,300.00 35,887.08 216,276.01 39.30 334,023.99
0.00 540.75 540.75 0.00 ( 540.75)
82,000.00 17,088.40 32,735.09 39.92 49,264.91
2,400.00 239.09 725.74 30.24 1,674.26
4,350.00 1,083.99 2,118.05 48.69 2,231.95
1,200.00 253.51 495.35 41.28 704.65
89,950.00 19,205.74 36,614.98 40.71 53,335.02
31,000.00 5,126.93 14,677.49 47.35 16,322.51
31,000.00 5,126.93 14,677.49 47.35 16,322.51
500.00 0.00 0.00 0.00 500.00
69,050.00 15,536.05 26,892.80 41.99 37,157.20
3,000.00 1,945.00 1,445.00 48.17 1,555.00
4,000.00 549.12 2,932.27 73.31 1,067.73
71,550.00 17,530.17 31,270.07 43.70 40,279.93
TOTAL Recreation Programs 192,500.00 41,862.84 82,562.54 42.89 109,937.46
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 24
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 101-GENERAL FUND
Culture & Recreation
I DEPARTMENTAL EXPENDITURES
CURRENT CURRENT
BUDGET PERIOD
50.00$ OF YEAR COMP.
YEAR TO DATE o OF BUDGET
ACTUAL BUDGET BALANCE
~ Concessions
Personal Services
101-4-5230-4103 Part-time Pay 3,650.00 378.75 930.25 25.49 2,719.75
101-4-5230-4104 PERA 150.00 1.24 22.44 14.96 127.56
101-4-5230-4105 FICA 250.00 23.49 57.69 23.08 192.31
101-4-5230-4107 Medicare 50.00 5.50 13.49 26.98 36.51
TOTAL Personal Services 4,100.00 408.98 1,023.87 24.97 3,076.13
Supplies
101-4-5230-4219 Operating Supplies 2,900.00 13.14 34.82 1.20 2,865.18
101-4-5230-4259 Other Merchandise For Resale 7,000.00 450.31 2,395.92 34.22 4,604.58
TOTAL Supplies 9,900.00 463.45 2,930.24 24.55 7,469.76
Other Services & Charges
101-4-5230-9401 Bldg Repair/Maint Services 100.00 0.00 0.00 0.00 100.00
TOTAL Other Services & Charges 100.00 0.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-4109 PERA
101-4-5510-4105 FICA
101-4-5510-9107 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 Postage
101-4-5510-4331 Travel, Conferences & Schools
101-4-5510-4361 Insurance
101-4-5510-4389 Utilities
101-4-5510-9401 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 872.43 3,454.11 24.50 10,645.89
57,400.00 4,414.41 26,486.48 46.14 30,913.52
62,000.00 4,676.64 27,834.27 44.89 34,165.73
8,650.00 659.09 4,268.75 49.35 4,381.25
7,400.00 527.57 3,434.10 96.41 3,965.90
1,750.00 123.39 803.17 45.90 946.83
13,700.00 1,110.20 6,661.20 48.62 7,038.80
500.00 141.50 399.50 79.90 100.50
151,400.00 11,652.80 69,887.47 46.16 81,512.53
12,400.00 714.41 3,278.07 26.44 9,121.93
12,400.00 714.41 3,278.07 26.44 9,121.93
2,600.00 150.10 1,069.06 41.12 1,530.94
2,500.00 57.84 1,130.07 45.20 1,369.93
2,400.00 199.82 453.82 18.91 1,946.18
1,600.00 0.00 742.50 46.41 857.50
9,700.00 559.65 5,804.91 59.84 3,895.59
12,400.00 1,151.16 5,860.93 97.27 6,539.07
1,500.00 0.00 0.00 0.00 1,500.00
6,950.00 97.00 369.00 5.29 6,586.00
1,000.00 145.00 720.16 72.02 279.84
90,650.00 2,350.57 16,144.95 39.72 24,505.05
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 25
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
101-GENERAL FUND
Culture & Recreation
DEPARTMENTAL EXPENDITURES
50.00$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Capital Outlay
TOTAL Sr Citizen Programs 204,450.00 14,717.78 89,310.49 43.68 115,139.51
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
101-4-6210-4440 Miscellaneous
TOTAL Other Services & Charges
1,751,700.00 161,338.51 731,059.45 41.73 1,020,640.55
0.00 ( 30,191.73) 8,141.80 0.00 ( 8,141.80)
0.00 ( 1,783.68) 891.84 0.00 ( 891.84)
0.00 ( 2,313.01) 925.39 0.00 ( 425.39)
0.00 ( 1,790.25) 540.46 0.00 ( 540.96)
0.00 ( 411.34) 128.58 0.00 ( 128.58)
0.00 ( 2,390.52) 486.00 0.00 ( 486.00)
0.00 195.25 195.25 0.00 ( 195.25)
0.00 ( 38,635.28) 10,809.32 0.00 ( 10,809.32)
0.00 ( 11.04) 0.00 0.00 0.00
0.00 ( 11.09) 0.00 0.00 0.00
TOTAL Economic Development
Energy City
0.00 ( 38,646.32) 10,809.32 0.00 ( 10,809.32)
Personal Services
101-4-6220-4101 Regular Pay 28,700.00
101-4-6220-4109 PERA 2,100.00
101-4-6220-4105 FICA 1,800.00
101-4-6220-4107 Medicare 400.00
101-4-6220-4108 Insurance 3,150.00
TOTAL Person al Services 36,150.00
Supplies
Other Services & Charges
101-4-6220-4319 Other Professional Services 5,000.00
101-4-6220-4331 Travel, Conferences & Schools 7,500.00
101-4-6220-4359 Publishing 3,000.00
TOTAL Other Services & Charges 15,500.00
2,208.32 13,249.92 46.17 15,450.08
160.12 1,029.57 49.03 1,070.93
123.14 797.71 44.32 1,002.29
28.80 186.57 46.64 213.43
249.51 1,497.06 47.53 1,652.94
2,769.89 16,760.83 46.36 19,389.17
1,770.33 1,809.00 36.18 3,191.00
50.00 ( 820.71) 10.94- 8,320.71
778.95 1,578.86 52.63 1,421.14
2,599.28 2,567.15 16.56 12,932.85
I TOTAL Energy City 51,650.00 5,369.17 19,327.98 37.42 32,322.02
7-13-2011 10:50 AM CITY OF ELK RIVER PAGE: 26
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 101-GENERAL FUND
Economic Development
I DEPARTMENTAL EXPENDITURES
50.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
TOTAL Economic Development
Transfers Out
Transfers Out
101-4-7000-4723 Transfer-Ice Arena
101-4-7000-9724 Transfer - Pinewood
TOTAL Transfers Out
51,650.00 ( 33,277.15) 30,137.30 58.35 21,512.70
156,250.00 0.00 0.00 0.00 156,250.00
48,950.00 0.00 0.00 0.00 48,950.00
205,200.00 0.00 0.00 0.00 205,200.00
^ TOTAL Transfers Out
^ TOTAL General
^ TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
205,200.00 0.00 0.00 0.00 205,200.00
205,200.00 0.00 0.00 0.00 205,200.00
12,500,050.00 888,982.16 5,215,498.59 41.72 7,284,551.41
( 336,600.00) 2,706,293.18 ( 657,799.34) 321,199.34
7-13-2011 10:51 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
221-ICE ARENA
FINANCIAL SUMMARY
CURRENT CURRENT
BUDGET PERIOD
50.00$ OF YEAR COMP.
YEAR TO DATE $ OF BUDGET
ACTUAL BUDGET BALANCE
REVENUE SUMMARY
Ice Arena
Hockey
Skating
Concessions
TOTAL REVENUES
EXPENDITURE SUMMARY
Culture & Recreation
Ice Arena
Hockey
Skating
Arena Concessions
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
678,900.00 15,282.01 257,421.15 37.92 421,478.85
49,500.00 ( 22,872.00) 21,885.00 44.21 27,615.00
73,350.00 9,198.13 33,138.13 45.18 40,211.87
63,100.00 ( 255.70) 40,994.09 64.89 22,155.91
864,850.00 1,352.44 353,388.37 40.86 511,461.63
756,500.00 69,350.70 262,109.64 34.65 494,390.36
27,050.00 2,505.39 7,947.39 27.53 19,602.61
34,050.00 866.78 13,627.95 40.02 20,422.05
47,250.00 1,501.97 26,813.20 56.75 20,936.80
864,850.00 74,229.84 309,998.18 35.84 554,851.82
864,850.00 74,224.84 309,998.18 35.84 554,851.82
0.00 ( 72,872.40) 43,390.19 ( 43,390.19)
7-13-2011 10:51 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
~ 221-ICE ARENA
REVENUES
50.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-3965 Admissions
221-3-0000-3466 Dry Floor Events
221-3-0000-3468 Skate Sharpening
221-3-0000-3475 Building Rent
221-3-0000-3982 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 14,895.23 217,545.19 49.11 225,454.81
22,900.00 0.00 17,666.25 77.15 5,233.75
14,600.00 26.66 11,262.07 77.14 3,337.93
4,100.00 64.00 2,392.00 58.34 1,708.00
2,600.00 0.00 0.00 0.00 2,600.00
17,000.00 0.00 1,574.00 9.26 15,426.00
504,200.00 14,985.89 250,439.51 49.67 253,760.49
16,650.00 261.61 5,652.51 33.95 10,997.49
1,800.00 15.26 1,136.98 63.17 663.02
18,450.00 276.87 6,789.49 36.80 11,660.51
0.00 19.25
0.00 19.25
156,250.00 0.00
156,250.00 0.00
192.15 0.00 ( 192.15)
192.15 0.00 ( 192.15)
0.00 0.00 156,250.00
0.00 0.00 156,250.00
678,900.00 15,282.01 257,421.15 37.92 421,478.85
49,500.00 ( 22,872.00) 21,885.00 44.21 27,615.00
49,500.00 ( 22,872.00) 21,885.00 44.21 27,615.00
49,500.00 ( 22,872.00) 21,885.00 44.21 27,615.00
7-13-2011 10:51 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
221-ICE ARENA
REVENUES
50.00 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE °s OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Charges for Services
221-3-5920-3461 Recreation Fees 68,000.00 9,329.00 29,680.00 43.65 38,320.00
221-3-5420-3465 Admissions 3,800.00 ( 130.87) 3,458.13 91.00 341.87
TOTAL Charges for Services 71,800.00 9,198.13 33,138.13 46.15 38,661.87
Other Revenue
221-3-5420-3629 Miscellaneous Revenue 1,550.00 0.00 0.00 0.00 1,550.00
TOTAL Other Revenue 1,550.00 0.00 0.00 0.00 1,550.00
TOTAL Skating 73,350.00 9,198.13 33,138.13 95.18 40,211.87
Concessions
Charges for Services
221-3-5430-3467 Concessions 63,100.00 ( 255.70) 40,944.09 64.89 22,155.91
TOTAL Charges for Services 63,100.00 ( 255.70) 40,944.09 64.89 22,155.91
TOTAL Concessions 63,100.00 ( 255.70) 40,944.09 64.89 22,155.91
TOTAL REVENUE 864,850.00 1,352.49 353,388.37 40.86 511,461.63
7-13-2011 10:51 AM CITY OF ELK RIVER PAGE: 9
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
~ 221-ICE ARENA
I DEPARTMENTAL EXPENDITURES
50.00$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
I Ice_Arena
Personal Services
221-4-5900-4101 Regular Pay 148,700.00 12,771.07 69,511.68 43.38 84,188.32
221-4-5400-4103 Part-time Pay 73,200.00 2,655.97 36,989.18 50.53 36,210.82
221-4-5400-4104 PERA 12,250.00 824.50 6,183.72 50.48 6,066.28
221-4-5400-4105 FICA 13,750.00 941.98 6,786.46 49.36 6,963.54
221-4-5400-4107 Medicare 3,200.00 220.28 1,587.15 49.60 1,612.85
221-4-5400-4108 Insurance 17,150.00 1,514.58 8,095.98 47.21 9,054.02
221-4-5400-4109 Workers Comp 5,550.00 1,775.50 5,201.50 93.72 348.50
221-4-5400-4110 Re-employment Compensation 0.00 0.00 370.07 0.00 ( 370.07)
TOTAL Personal Services 273,800.00 20,703.88 129,725.79 47.38 144,074.26
Supplies
221-4-5400-4212 Fuels & Lubs 400.00 0.00 6.82 1.71
221-4-5400-9217 Uniform Allowance 1,500.00 0.00 266.50 17.77
221-4-5400-9219 Operating Supplies 34,500.00 5,639.94 12,733.70 36.91
221-4-5400-4255 Soft Drinks/Misc 9,000.00 0.00 1,871.04 20.79
221-4-5400-4259 Other Merchandise For Resale 900.00 0.00 0.00 0.00
TOTAL Supplies 46,300.00 5,639.94 19,878.06 32.13
Other Services & Charges
31,421.94
221-4-5400-4321 Telephone 3,450.00 132.95 1,209.06 35.05 2,240.99
221-4-5400-4322 Postage 500.00 72.54 268.86 53.77 231.14
221-4-5400-4331 Travel, Conferences & Schools 1,000.00 44.98 44.98 4.50 955.02
221-4-5400-4359 Publishing 2,200.00 352.69 1,605.89 73.00 594.11
221-4-5400-4361 Insurance 8,350.00 0.00 3,614.50 43.29 4,735.50
221-9-5900-4389 Utilities 148,950.00 10,237.27 66,882.74 44.90 82,067.26
221-4-5400-4901 Bldg Repair/Maint Services 22,300.00 2,322.02 6,356.42 28.50 15,943.58
221-4-5900-4409 Contractual Services 1,200.00 54.40 186.40 15.53 1,013.60
221-4-5400-4415 Equipment Rental 2,800.00 0.00 683.96 24.43 2,116.04
221-4-5400-9433 Dues & Subscriptions 450.00 0.00 183.39 40.74 266.66
TOTAL Other Services & Charges 191,200.00 13,216.88 81,036.15 42.38 110,163.85
Capital Outlay
221-4-5400-4560 Equipment 44,400.00 29,790.00 36,469.69 82.14 7,930.31
TOTAL Capita l Outlay 44,400.00 29,790.00 36,469.69 82.14 7,930.31
Transfers Out
221-4-5400-4730 Transfer-Debt Service 200,800.00 0.00 0.00 0.00 200,800.00
TOTAL Transfers Out 200,800.00 0.00 0.00 0.00 200,800.00
393.18
1,233.50
21,766.30
7,128.96
900.00
TOTAL Ice Arena 756,500.00 69,350.70 262,109.64 34.65 494,390.36
7-13-2011 10:51 AM CITY OF ELK RIVER PAGE: 5
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
221-ICE ARENA
Culture & Recreation 50.00°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE a OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
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-5910-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 2,953.95 21.02 11,096.05
TOTAL Supplies 14,050.00 0.00 2,953.95 21.02 11,096.05
Other Services & Charges
221-4-5910-4359 Publishing 500.00 0.00 0.00 0.00 500.00
221-4-5410-4409 Contractual Services 6,400.00 2,496.20 2,837.80 44.34 3,562.20
221-4-5410-4438 Credit Card Fees 2,200.00 9.19 1,655.64 75.26 544.36
TOTAL Other Services & Charges 9,100.00 2,505.39 9,493.44 49.38 4,606.56
TOTAL Hockey 27,050.00 2,505.39 7,447.39 27.53 19,602.61
Skating
Personal Services
221-4-5420-4103 Part-time Pay 20,000.00 0.00 7,286.69 36.43 12,713.31
221-4-5420-4104 PERA 1,000.00 0.00 253.97 25.40 746.03
221-4-5420-4105 FICA 1,250.00 0.00 464.95 37.20 785.05
221-4-5420-4107 Medicare 300.00 0.00 108.76 36.25 191.29
TOTAL Personal Services 22,550.00 0.00 8,114.37 35.98 14,435.63
Supplies
221-4-5420-4219 Operating Supplies 5,500.00 87.66 3,858.44 70.15 1,641.56
TOTAL Supplies 5,500.00 87.66 3,858.44 70.15 1,641.56
Other Services & Charges
221-4-5420-4359 Publishing 650.00 318.49 318.49 49.00 331.51
221-4-5420-4409 Contractual Services 2,550.00 363.80 599.00 23.49 1,951.00
221-4-5420-9438 Credit Card Fees 2,800.00 96.83 737.65 26.34 2,062.35
TOTAL Other Services & Charges 6,000.00 779.12 1,655.14 27.59 4,394.86
TOTAL Skating 34,050.00 866.78 13,627.95 40.02 20,422.05
7-13-2011 10:51 AM CITY OF ELK RIVER PAGE: 6
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 221-ICE ARENA
Culture & Recreation
DEPARTMENTAL EXPENDITURES
50.00% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
~ Arena Concessions
Personal Services
221-4-5930-4103 Part-time Pay 20,900.00 195.75 9,426.65 45.10 11,473.35
221-4-5430-4104 PERA 200.00 0.00 176.50 88.25 23.50
221-9-5430-4105 FICA 1,300.00 12.13 641.95 49.38 658.05
221-4-5930-9107 Medicare 300.00 2.84 150.14 50.05 149.86
TOTAL Personal Services 22,700.00 210.72 10,395.29 95.79 12,304.76
Supplies
221-4-5430-4219 Operating Supplies 3,550.00 0.00 929.14 26.17 2,620.86
221-4-5430-4259 Other Merchandise For Resale 21,000.00 1,291.25 15,488.82 73.76 5,511.18
TOTAL Supplies 24,550.00 1,291.25 16,417.96 66.88 8,132.04
I TOTAL Arena Concessions
47,250.00 1,501.97 26,813.20 56.75 20,436.80
' TOTAL Culture & Recreation
869,850.00 74,224.84 309,998.18 35.84 554,851.82
~ TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
864,850.00 74,224.84 309,998.18 35.84 554,851.82
0.00 ( 72,872.40) 43,390.19 ( 43,390.19)
7-13-2011 10:51 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
I 222-PINEWOOD GOLF COURSE
FINANCIAL SUMMARY
SO.OOo OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
I REVENUE SUMMARY
Pinewood Golf Course
TOTAL REVENUES
I EXPENDITURE SUMMARY
I Culture & Recreation
Golf Course
TOTAL Culture & Recreation
TOTAL EXPENDITURES
~ REVENUES OVER/(UNDER) EXPENDITURES
249,550.00 29,893.77 86,829.51 34.79 162,720.49
249,550.00 29,893.77 86,829.51 34.79 162,720.49
249,550.00 23,282.01 101,626.29 40.72 147,923.71
249,550.00 23,282.01 101,626.29 40.72 147,923.71
299,550.00 23,282.01 101,626.29 90.72 147,923.71
0.00 6,611.76 ( 14,796.78) 19,796.78
7-13-2011 10:51 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
~ 222-PINEWOOD GOLF COURSE
I REVENUES
50.OOo OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
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
Other Revenue
Sales
222-3-0000-3792 Cash Over
TOTAL Sales
Other Financing Sources
Transfers In
222-3-0000-3922 Transfer-General Fund
TOTAL Transfers In
~ TOTAL Pinewood Golf Course
~ TOTAL REVENUE
17,000.00 3,293.50 16,661.50 98.01 338.50
19,000.00 2,958.20 5,216.37 27.95 13,783.63
5,000.00 635.61 1,207.17 24.14 3,792.83
100.00 0.00 0.00 0.00 100.00
120,000.00 17,211.50 38,493.50 32.04 81,556.50
19,000.00 1,030.00 16,740.03 119.57 ( 2,740.03)
18,500.00 3,355.00 7,051.50 38.12 11,448.50
7,000.00 1,292.54 1,292.54 18.46 5,707.46
200,600.00 29,776.35 86,612.61 93.18 113,987.39
0.00
0.00
117.42
117.42
216.90 0.00 ( 216.90)
216.90 0.00 ( 216.90)
48,950.00 0.00
48,950.00 0.00
0.00 0.00 48,950.00
0.00 0.00 48,950.00
249,550.00 29,893.77 86,829.51 34.79 162,720.49
249,550.00 29,893.77 86,829.51 34.79 162,720.49
7-13-2011 10:51 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JUNE 30TH, 2011
~ 222-PINEWOOD GOLF COURSE
I DEPARTMENTAL EXPENDITURES
CURRENT CURRENT
BUDGET PERIOD
50.00 OF YEAR COMP.
YEAR TO DATE o OF BUDGET
ACTUAL BUDGET BALANCE
I Golf-Course
Personal Services
222-4-5300-4101 Regular Pay 93,650.00 6,930.24 39,193.39 41.85 54,456.61
222-4-5300-4103 Part-time Pay 29,900.00 4,294.41 7,176.95 29.00 22,723.55
222-4-5300-4104 PERA 8,950.00 718.52 3,138.25 35.06 5,811.75
222-4-5300-4105 FICA 7,650.00 687.00 2,980.48 38.96 4,669.52
222-4-5300-4107 Medicare 1,800.00 160.67 697.01 38.72 1,102.99
222-4-5300-9108 Insurance 10,150.00 458.01 2,748.06 27.07 7,401.94
222-4-5300-4109 Workers Comp 1,400.00 414.00 1,250.00 89.29 150.00
222-4-5300-4110 Re-employment Compensation 0.00 0.00 9,842.25 0.00 ( 4,842.25)
TOTAL Person al Services 153,500.00 13,612.85 62,025.89 40.41 91,974.11
Supplies
222-4-5300-4212 Fuels & Lubs 5,000.00 0.00 1,689.39 33.79 3,310.61
222-4-5300-4217 Uniform Allowance 500.00 0.00 413.40 82.68 86.60
222-4-5300-9219 Operating Supplies 30,400.00 3,429.24 16,530.54 54.38 13,869.46
222-4-5300-4259 Other Merchandise For Resale 14,500.00 1,529.51 3,877.10 26.74 10,622.90
TOTAL Suppli es 50,400.00 4,958.75 22,510.43 44.66 27,889.57
Other Services & Charges
222-4-5300-4321 Telephone 2,500.00 209.13 831.42 33.26 1,668.58
222-4-5300-4331 Travel, Conferences & Schools 500.00 0.00 208.27 41.65 291.73
222-4-5300-4349 Advertising/Marketing 1,.300.00 454.60 649.60 49.97 650.90
222-4-5300-4361 Insurance 11,900.00 0.00 5,296.50 94.51 6,603.50
222-9-5300-9389 Utilities 7,150.00 395.61 1,197.38 16.75 5,952.62
222-4-5300-9401 Bldg Repair/Maint Services 2,300.00 1,131.60 1,382.26 60.10 917.74
222-4-5300-4404 Equip Repair/Maint Services 3,000.00 98.94 1,929.43 64.31 1,070.57
222-4-5300-4415 Equipment Rental 2,000.00 34.84 643.51 32.18 1,356.49
222-4-5300-4437 Taxes & Licenses 1,000.00 67.71 ( 911.37) 91.14- 1,911.37
222-4-5300-4438 Credit Card Fees 5,500.00 901.98 1,614.97 29.36 3,885.03
TOTAL Other Services & Charges 37,150.00 3,294.41 12,841.97 34.57 24,308.03
Capital Outlay
Debt Service
222-4-5300-4601 Principal 8,500.00 1,416.00 9,248.00 49.98 4,252.00
TOTAL Debt S ervice 8,500.00 1,416.00 4,248.00 49.98 4,252.00
TOTAL Golf Course 249,550.00 23,282.01 101,626.29 40.72 197,923.71
TOTAL Culture & Recreation
^ TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
249,550.00 23,282.01 101,626.29 40.72 147,923.71
299,550.00 23,282.01 101,626.29 40.72 147,923.71
0.00 6,611.76 ( 14,796.78) 14,796.78
7-13-2011 10:52 AM CITY OF ELK RIVER PAGE: 1
POOLED CASH REPORT (FUND 999)
AS OF: JUNE 30TH, 2011
FUND ACCOUNT# ACCOUNT NAME
BEGINNING CURRENT
BALANCE ACTIVITY
CURRENT
BALANCE
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
290-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
343-1010 Cash - 1996C Ice Arena Bonds
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
801-1010 Cash - Interest
821-1010 Cash - Developer Escrow
TOTAL CLAIM ON CASH
27,196.35 1,572.47 28,768.82
2,455,737.31 2,720,858.39 5,176,595.65
407,677.15 17,387.29 425,064.44
107,337.05 ( 59,578.80) 47,758.25
( 19,140.34) 6,891.81 ( 12,248.53)
9,699.62 ( 504.78) 9,199.84
( 31,275.68) 0.00 ( 31,275.68)
980,857.17 ( 5,188.21) 975,668.96
687,246.97 0.00 687,246.97
1,128,030.46 3,508.23 1,131,538.69
292,965.45 0.00 292,965.45
363,698.14 151,229.96 514,928.10
1,308,378.51 ( 3,293.59) 1,305,084.97
392,579.52 ( 34,762.60) 357,816.92
3,578,059.69 71,298.88 3,649,358.57
13,822.08 ( 785.72) 13,036.36
143,023.06 0.00 143,023.06
1,168,602.88 0.00 1,168,602.88
25,000.00 0.00 25,000.00
46,285.83 0.00 96,285.83
115,388.96 28,534.10 143,923.06
152,278.58 40,114.99 192,393.57
167,008.82 198,261.06 365,269.88
( 15,390.00) 0.00 ( 15,390.00)
7,437.50 0.00 7,437.50
5,234,308.35 ( 8,225.95) 5,226,082.40
279,210.77 15,979.62 295,190.39
4,160,625.41 0.00 4,160,625.41
827,153.89 ( 14,086.66) 813,067.23
1,345,461.56 0.00 1,345,461.56
( 211,756.94) 0.00 ( 211,756.99)
82,995.71 67,965.54 150,911.25
94,117.02 0.00 44,117.02
457,735.29 0.00 457,735.29
4,714,159.40 ( 6,313.83) 4,707,840.57
4,251,882.15 ( 74,690.96) 4,177,191.19
508,778.63 3,632.18 512,410.81
40,791.50 90,328.74 131,120.24
89,751.38 3,040.00 92,791.38
35,337,664.20 3,213,172.16 38,550,836.36
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
21,071,508.27 4,045,156.33 25,116,664.60
(14,116,033.63) ( 831,984.17) (14,948,017.80)
28,382,189.56 0.00 28,382,189.56
35,337,664.20 3,213,172.16 38,550,836.36