INFORMATION 11-21-2011INFORMATION
~~~~ ~~ MEMORANDUM
Elk -~
River
TO: HRA and City Council
FROM: Bob Ruprecht, Building Official
DATE: November 15, 201 I
SUBJECT: Snow Removal Policy for 716 and 720 Main Street
On October 3, 2011, the HRA authorized staff to move forward with obtaining quotes for
the demolition of 716 and 720 Main Street. On October 31, 2011, the HRA entered into
contract with the Schumacher Group, LLC for project management for the removal of the
two buildings. Staff has created a snow removal plan as outlined below:
PURPOSE
Due to concerns regarding truss failures in the building at 720 Main Street in Elk River, this
Snow Removal Policy for 716 and 720 Main Street is intended to minimize the threat of
structural failure which may endanger building occupants and/or result in damage to the
adjacent building at 724 Main Street.
POLICY
1. B&B Sheet Metal and Roofing is contracted on a will call basis for snow removal.
2. The City of Elk River Building Official or his designee is responsible for contacting
B&B Sheet Metal and Roofing
3. Predicted Snow Event greater than three (3) inches - B&B will be put on call for a
predicted snow event of three inches or more.
4. Actual Accumulation exceeding four (4) inches - B&B will be called for removal of a
combined accumulation of snow exceeding four inches.
a. Only one team shall be present on the structure at any given time unless
directed by the Ciry of Elk River Building Official.
b. Ciry of Elk River Street Department will be contacted by the Building
Official or his designee to close the parking area adjacent to the north side of
716/20 Main for equipment placement.
c. City of Elk River Street Superintendent will determine whether to store snow
on site or off site.
d. Upon execution of this policy, the Director of Economic Development or
hex designee shall communicate the policy execution to Elk River Historic
Downtown business operators. The following information shall be included:
^ Time/date of work
POMEREI BC
Notice of parking lot closure
Snow storage plan
RATES
B&B Sheet Metal and Roofing have agreed to the following rates for the duration of this
policy.
1. $87.00 per hour per person for shoveling time
2. $175.00 per hour per crane (includes operator) for snow removal
C:\Users\jjohnson\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Chitlook\SFWAYSNS\snow removal
(3).docx
INFORMATION
ver
MEMORANDUM
TO: Mayor and City Council
FROM: Tim Simon, Finance Director
DATE: November 21, 2011
SUBJECT: October 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 October, actual revenues (except for property taxes and state aids) and
expenditures should run about 83% 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
Revenue.r.•
• Excluding transfers in, revenue collections are 58% of budget. Third quarter gravel
tax collections were received in October. The second half property taxes will be
received in December.
• License & permit collections exceed budget projections by over $142,600.
• Charges for services are slightly over the budget benchmark at about 85%.
• Fines and forfeits are over 76% of budget; however, court fine collections lag a
month.
• All revenue transfers in have been recorded.
Expenditures:
• Excluding transfers out, the total departmental expenditures are about 78°/n 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 October, expenditures exceed revenues $40,812. Excluding transfers in,
revenue collections of $462,246 are about 65% of budget and expenditures of $503,058 are
58% of budget. Ice rental revenues in October reflect ice usage for the month of
September, in which increased revenues will be reflected in the next two months.
Pinewood Golf
For the month ended October, expenditures exceed revenues by $28,827. Excluding
transfers in, golf revenues collected through October of $168,468 account for about 84% of
budget estimates and expenditures of $197,295 are 79% of budget. With the golf season
winding down, green fees account for almost 76% of budget estimates.
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED) 1 ly F O RM AT 1 O N
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
FINANCIAL SUMMARY
83.33$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE °s OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SiTMMARY
General Fund 12,163,450.00 117,446.02 7,444,898.84 61.21 4,718,551.16
TOTAL REVENUES 12,163,450.00 117,446.02 7,499,898.84 61.21 4,718,551.16
EXPENDITURE SUMMARY
General Government
800.00
177
7,735.46
107,358.29
60.38
70,441.71
Mayor & Council ,
77,800.00 6,181.80 61,011.88 78.42 16,788.12
Cable TV 650.00
473 35,086.55 462,526.36 97.65 11,123.64
Administrative Services ,
150,750.00 12,013.25 123,804.86 82..13 26,945.14
Human Resources 454,700.00 28,402.22 376,230.04 82.74 78,469.96
Finance 600.00
266 18,202.80 179,082.87 67.17 87,517.13
Information Technology ,
240,000.00 17,960.63 208,231.95 86.76 31,768.05
Legal 100.00
67 5,205.39 54,599.51 81.37 12,500.49
Community Development ,
303,550.00 22,599.24 236,451.78 77.90 67,098.22
Planning 300,850.00 21,954.88 210,998.46 70.13 89,851.54
City Hall Maintenance 75,000.00 22,719.93 25,418.22 33.89 49,581:78
Contingency 800.00
587
2 197,562.15 2,045,714.22 79.05 542,085.78
TOTAL General Government ,
,
Public Safety
800.00
563
47,317.42
429,531.81
76.19
134,268.19
Police Administration ,
2,252,800.00 159,971.60 1,649,508.67 73.00 608,291.33
Patrol 752,450.00 51,312.49 537,609.60 71.45 214,840.40
Investigations 700.00
491 38,270.02 385,106.42 78.32 106,593.58
Police Support Services ,
22,900.00 234.10 16,848.91 73.58 6,051.09
Police Reserves 000.00
205 14,245.78 143,497.26 69.97 61,552.74
Public safety building ,
600.00
589 151,358.17 468,508.66 79.46 121,091.34
Fire Administration ,
184,850.00 19,370.57 144,849.47 78.36 40,000.53
Fire Inspections 400.00
107 1,683.32 84,914.53 79.06 22,485.47
Emergency Management ,
465,200.00 36,385.43 372,872.87 80.15 92,327.13
Building Safety 56,950.00 9,305.21 93,947.84 77.17 13,002.16
Environmental 650.00
692
5 519,459.11 4,272,146.09 75.05 1,420,503.96
TOTAL Public Safety ,
,
Public Works
524,450.00
1
96,482.87
1,285,426.92
84.32
239,023.08
Street Maintenance ,
262,850.00 2,048.63 197,579.14 75.17 65,270.86
Snow Removal 245,950.00 18,026.33 181,914.58 73.96 64,035.42
Equipment Services 177,800.00 9,240.42 95,301.45 53.60 82,498.55
Engineering 00
050
211
2 125,798.25 1,760,222.09 79.61 450,827.91
TOTAL Public Works .
,
,
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
FINANCIAL SUMMARY
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
83.330 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATEv OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
790,350.00 76,078.75 661,637.18 83.71 128,712.82
550,300.00 39,594.04 378,357.81 68.75 171,992.19
192,500.00 11,026.61 189,860.72 98.63 2,639.28
14,100.00 310.90 8,452.98 59.95 5,647.02
204,450.00 15,731.46 153,148.31 74.91 51,301.69
1,751,700.00 142,741.76 1,391,457.00 79.43 360,243.00
0.00 13,468.16 30,813.26 0.00 ( 30,813.26)
51,650.00 2,789.89 34,753.34 67.29 16,896.66
51,650.00 16,258.00 65,566.60 126.94 ( 13,916.60)
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 1,001,814.27 9,535,105.95 76.28 2,964,944.05
( 336,600.00)( 884,368.25)( 2,090,207.11) 1,753,607.11
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
83.33$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o 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 4,707,939.32 48.24 5,050,560.68
101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 156,308.66 0.00 ( 156,308.66)
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 37,040.78 62,806.24 83.79 12,193.76
101-3-0000-3123 Franchise Tax 0.00 0.00 45,338.42 0.00 ( 45,338.42)
101-3-0000-3131 Penalties/Interest 0.00 0.00 14,325.99 0.00 ( 14,325.99)
TOTAL Taxes 9,612,900.00 37,040.78 4,986,718.63 51.88 4,625,681.37
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-3234 Electric Permit
101-3-0000-3235 Animal License
101-3-0000-3236 Parking Permit
101-3-0000-3237 Other Non-Business Lic/Permit
TOTAL Licenses & Permits
53,000.00 0.00 55,105.00 103.97 ( 2,105.00)
1,000.00 255.00 950.00 45.00 550.00
3,000.00 900.00 1,012.50 33.75 1,987.50
16,000.00 1,860.00 22,845.00 142.78 ( 6,845.00)
20,000.00 0.00 21,095.25 105.48 ( 1,095.25)
4,000.00 0.00 555.00 13.88 3,495.00
14,000.00 ( 95.00) 8,395.00 59.96 5,605.00
2,500.00 0.00 1,480.00 59.20 1,020.00
100,000.00 20,203.15 144,672.24 144.67 ( 44,672.24)
25,000.00 2,593.93 122,358.07 489.43 ( 97,358.07)
200.00 395.15 3,183.87 1,591.94 ( 2,983.87)
0.00 0.00 475.00 0.00 ( 475.00)
3,000.00 130.00 4,860.00 162.00 ( 1,860.00)
3,000.00 20.00 469.13 15.64 2,530.87
8,000.00 1,925.00 8,400.00 105.00 ( 400.00)
252,700.00 28,137.23 395,356.06 156.45 ( 142,656.06)
Intergovernmental Rev
101-3-0000-3311 Federal Grant 4,000.00 0.00 1,765.25 44.13 2,234.75
101-3-0000-3324 PERA Aid 14,000.00 0.00 6,992.00 49.94 7,008.00
101-3-0000-3325 Police 20 Aid 205,000.00 0.00 206,770.00 100.86 ( 1,770.00)
101-3-0000-3326 Police Training Reimb 12,000.00 0.00 11,361.68 94.68 638.32
101-3-0000-3327 State-Aid Street Maint 254,050.00 0.00 275,485.11 108.94 ( 21,435.11)
101-3-0000-3329 State Crime Prevention Grant 35,000.00 21,658.58 34,850.87 99.57 149.13
101-3-0000-3330 Other State Grants 4,000.00 0.00 0.00 0.00 4,000.00
101-3-0000-3341 County Reimb/Grant 0.00 0.00 5,125.00 0.00 ( 5,125.00)
TOTAL Intergovernmental Rev 528,050.00 21,658.58 542,349.91 102.71 ( 14,299.91)
Charges for Services
101-3-0000-3412 Planning & Zoning Fees 15,000.00 815.00 9,890.00 65.93 5,110.00
101-3-0000-3413 Plan Check Fee 30,000.00 7,861.95 40,697.82 135.66 ( 10,697.82)
101-3-0000-3415 Special Assessment Search 600.00 60.00 760.00 126.67 ( 160.00)
101-3-0000-3417 Copies 1,500.00 123.93 2,229.82 148.65 ( 729.82)
101-3-0000-3418 Other General Govt Services 4,000.00 207.50 2,672.01 66.80 1,327.99
101-3-0000-3430 Lockout Fees 7,500.00 580.00 6,595.00 87.93 905.00
11-17-2011 05:01
101-GENERP.L FUND
REVENUES PM
REVENUE CITY OF ELK RIVER
& EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
CURRENT CURRENT
BUDGET PERIOD
EAR TO DATE
ACTUAL
3.33% OF
°s OF
BUDGET PAGE: 4
EAR COMP.
BUDGET
BALANCE
101-3-0000-3431 Police Services 2,000.00 916.00 6,440.75 322.04 ( 4,440.75)
101-3-0000-3432 School Liaison 75,000.00 0.00 75,000.00 100.00 0.00
101-3-0000-3434 Animal Impound Fee 3,000.00 400.00 2,950.00 98.33 50.00
101-3-0000-3436 Fire Contracts 194,000.00 0.00 193,403.44 99.69 596.56
101-3-0000-3437 Fire Calls 4,000.00 0.00 1,275.00 31.88 2,725.00
101-3-0000-3451 Street Services 30,000.00 380.00 15,434.81 51.45 14,565.19
101-3-0000-3952 Engineering Services Reimb 99,100.00 0.00 32,519.62 32.81 66,580.38
101-3-0000-3461 Recreation Fees 123,000.00 4,115.11 121,949.54 99.15 1,D50.46
i01-3-0000-3467 Concessions 19,100.00 310.97 5,637.14 39.98 8,462.86
101-3-0000-3472 Park Use Fee 18,000.00 183.45 19,953.16 83.07 3,096.89
101-3-0000-3474 Facility Use Fee 6,200.00 425.64 2,928.98 47.24 3,271.02
101-3-0000-3475 Building Rent 13,200.00 225.00 5,900.00 90.91 7,800.00
101-3-0000-3483 Sewer Inspection Fee 2,500.00 880.00 2,840.00 113.60 ( 340.00)
101-3-0000-3484 Contractor License Check 400.00 15.00 350.00 87.50 50.00
TOTAL Charges for Services 643,100.00 17,499.55 543,927.09 84.58 99,172.91
Fines & Forfeits
101-3-0000-3510 Court Fines 120,000.00 7,752.95 84,905.05 70.75 35,094.95
101-3-0000-3511 Parking Fines 10,000.00 520.00 14,545.50 145.46 ( 4,545.50)
TOTAL Fines & Forfeits 130,000.00 8,272.95 99,450.55 76.50 30,549.45
Special Assessments
Other Revenue
101-3-0000-3621 Interest Income 120,000.00 4,689.78 48,897.47 40.71 71,152.53
101-3-0000-3625 Refunds & Reimbursements 65,000.00 ( 228.48) 20,764.85 31.95 44,235.15
101-3-0000-3626 Contributions 23,700.00 14.00 17,367.50 73.28 6,332.50.
101-3-0000-3629 Miscellaneous Revenue 4,000.00 361.63 5,616.78 140.42 ( 1,616.78)
TOTAL Other Revenue 212,700.00 4,836.93 92,596.60 43.53 120,103.40
Transfers In
101-3-0000-3925 Transfer-Landfill 35,000.00 0.00 35,000.00 100.00 0.00
101-3-0000-3929 Transfer-NSP/RDF Reserve 39,500.00 0.00 39,500.00 100.00 0.00
101-3-0000-3942 Transfer-WWTS 75,000.00 0.00 75,000.00 100.00 0.00
101-3-0000-3943 Transfer-Liquor 270,000.00 0.00 270,000.00 100.00 0.00
101-3-0000-3944 Transfer-Garbage 25,000.00 0.00 25,000.00 100.00 0.00
101-3-0000-3945 Transfer-Utilities 300,000.00 0.00 300,000.00 100.00 0.00
101-3-0000-3948 Transfer-EDA 25,000.00 0.00 25,000.00 100.00 0.00
101-3-0000-3949 Transfer-HRA 15,000.00 0.00 15,000.00 100.00 0.00
TOTAL Transf ers In 784,500.00 0.00 784,500.0.0 100.00 0.00
TOTAL General Fund 12,163,450.00 117,496.02 7,444,898.84 61.21 4,718,551.16
TOTAL REVENUE 12,163,450.00 117,446.02 7,444,898.84 61.21 4,718,551.16
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 5
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
I 101-GENERAL FUND
DEPARTMENTAL EXPENDITURES
83.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ 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-9105 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-4933 Dues & Subscriptions
101-4-1110-4940 Miscellaneous
TOTAL Other Services & Charges
38,500.00
1,900.00
2,400.00
550.00
50.00
93,400.00
3,400.00
3,900.00
3,208.45 31,926.19 82.93 6,573.81
100.01 1,002.50 52.76 897.50
111.09 1,169.70 48.74 1,230.30
46.53 478.98 87.09 71.02
16.25 126.00 252.00 ( 76.00)
3,482.33 34,703.37 79.96 8,696.63
153.29
153.29
651.92 19.17 2,748.08
651.92 19.17 2,748.08
11,050.00 0.00 4,849.56 43.89 6,200.94
400.00 0.00 313.10 78.28 86.90
2,600.00 322.12 1,111.76 42.76 1,488.24
17,700.00 2,888.12 11,833.69 66.86 5,866.31
74,800.00 0.00 32,271.50 43.14 42,528.50
16,000.00 0.00 15,896.00 99.04 154.00
8,450.00 889.60 5,777.39 68.37 2,672.61
131,000.00 4,099.84 72,003.00 54.96 58,997.00
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 7,735.46 107,358.29 60.38 70,491.71
54,150.00 4,249.60 43,545.96 80.42 10,604.04
6,500.00 487.50 3,256.28 50.10 3,243.72
3,950.00 308.10 3,305.17 83.68 644.83
3,750.00 269.17 2,788.41 79.36 961.59
900.00 62.95 652.08 72.45 247.92
5,800.00 670.00 6,700.00 115.52 ( 900.00)
200.00 64.25 161.75 80.88 38.25
75,250.00 6,111.57 60,409.65 80.28 19,890.35
700.00 70.23 522.93 79.70 177.07
700.00 70.23 522.93 74.70 177.07
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 6
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
General Government 83.33a OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Other Services & Charges
101-4-1120-4322 Postage 50.00 0.00
101-4-1120-4331 Travel, Conferences & Schools 1,650.00 0.00
101-4-1120-9404 Equip Repair/Maint Services 150.00 0.00
TOTAL Other Services & Charges 1,850.00 0.00
Capital Outlay
30.05 60.10
49.25 2.98
0.00 0.00
79.30 4.29
19.95
1,600.75
TOTAL Cable TV
Administrative Services
Personal Services
101-4-1210-4101 Regular Pay
101-4-1210-4103 Part-time Pay
101-4-1210-4109 PERA
101-4-1210-4105 FICA
101-4-1210-9106 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-4334 Car Allowance
101-4-1210-9361 Insurance
101-4-1210-4404 Equip Repair/Maint Services
101-4-1210-4433 Dues & Subscriptions
TOTAL Other Services & Charges
Capital Outlay
77,800.00 6,181.80 61,011.88 78.42 16,788.12
296,450.00 25,114.32 342,730.67 115.61 ( 46,280.67)
44,900.00 2,807.21 30,079.37 66.99 14,820.63
24,750.00 1,366.38 17,335.64 70.04 7,914.36
21,150.00 1,720.77 19,926.36 94.21 1,223.69
4,800.00 0.00 2,400.00 50.00 2,400.00
4,950.00 402.93 5,530.93 111.73 ( 580.43)
28,500.00 1,402.01 18,878.16 66.24 9,621.84
1,800.00 467.50 1,896.25 105.35 ( 96.25)
427,300.00 33,280.62 438,776.88 102.69 ( 11,476.88)
9,500.00 391.46 3,470.85 36.54 6,029.15
9,500.00 391.46 3,470.85 36.54 6,029.15
5,500.00 0.00 5,534.25 100.62 ( 34.25)
800.00 11.55 283.72 35.47 516.28
1,000.00 0.00 399.95 40.00 600.05
5,300.00 0.00 1,248.71 23.56 4,051.29
0.00 184.62 184.62 0.00 ( 184.62)
100.00 0.00 147.50 147.50 ( 47.50)
23,050.00 1,068.30 11,824.88 51.30 11,225.12
1,100.00 150.00 655.00 59.55 445.00
36,850.00 1,414.47 20,278.63 55.03 16,571.37
I TOTAL Administrative Services 973,650.00 35,086.55 462,526.36 97.65 11,123.64
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 7
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
I 101-GENERAL FUND
General Government
I DEPARTMENTAL EXPENDITURES
83.33 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-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-9490 Miscellaneous
TOTAL Other Services & Charges
Capital Outlay
TOTAL Human Resources
Elections
Supplies
Other Services & Charges
Capital Outlay
67,850.00 5,219.24 55,122.06 81.24 12,727.94
48,350.00 3,945.37 38,454.98 79.53 9,895.02
8,450.00 664.44 7,133.64 84.42 1,316.36
7,200.00 539.27 5,825.81 80.91 1,374.19
1,700.00 126.12 1,362.41 80.14 337.59
5,800.00 1,092.40 9,584.65 165.25 ( 3,7.84.65)
600.00 164.50 692.50 107.08 ( 42.50)
139,950.00 11,751.34 118,126.05 89.41 21,823.95
3,200.00 139.26 2,591.87 81.00 608.13
3,200.00 139.26 2,591.87 81.00 608.13
3,000.00 0.00 541.05 18.04 2,458.95
350.00 0.00 634.12 181.18 ( 284.12)
2,350.00 0.00 338.17 14.39 2,011.83
900.00 56.65 880.65 97.85 19.35
1,000.00 66.00 692.95 69.30 307.05
7,600.00 122.65 3,086.94 40.62 4,513.06
150,750.00 12,013.25 123,804.86 82.13 26,945.14
~ Finance
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 8
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
General Government
I DEPARTMENTAL EXPENDITURES
CURRENT CURRENT YEAR TO DATE
BUDGET PERIOD ACTUAL
83.33a OF YEAR COMP.
~ OF BUDGET
BUDGET BALANCE
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-9201 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-9-1310-4433 Dues & Subscriptions
TOTAL Other Services & Charges
Capital Outlay
287,800.00 22,139.36 232,463.35 80.77 55,336.65
20,850.00 1,605.10 17,656.10 84.68 3,193.90
17,850.00 1,290.78 14,279.22 80.00 3,570.78
4,200.00 301.86 3,339.34 79.51 860.66
25,850.00 2,100.01 21,000.10 81.24 4,849.90
1,500.00 407.75 1,599.00 106.60 ( 99.00)
358,050.00 27,844.86 290,337.11 81.09 67,712.89
3,850.00 121.36 2,069.15 53.74 1,780.85
3,850.00 121.36 2,069.15 53.74 1,780.85
18,300.00 0.00 18,030.00 98.52 270.00
53,500.00 0.00 49,026.50 91.64 4,473.50
800.00 2.00 251.62 31.45 598.38
3,600.00 0.00 1,350.00 37.50 2,250.00
2,500.00 434.00 1,551.38 62.06 948.62
1,300.00 0.00 540.00 91.54 760.00
11,300.00 0.00 11,619.28 102.83 ( 319.28)
1,500.00 0.00 1,455.00 97.00 45.00
92,800.00 936.00 83,823.78 90.33 8,976.22
TOTAL Finance
Information Technology
Personal Services
101-4-1350-4101 Regular Pay
101-4-1350-4103 Part-time Pay
101-4-1350-4104 PERA
101-4-1350-4105 FICA
101-9-1350-4107 Medicare
101-4-1350-9108 Insurance
101-4-1350-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-1350-4219 Operating Supplies
TOTAL Supplies
454,700.00 28,402.22 376,230.09 82.74 78,469.96
128,400.00 9,875.46 103,692.21 80.76 24,707.79
5,000.00 0.00 1,000.00 20.00 4,000.00
9,300.00 715.98 7,875.78 84.69 1,424.22
8,250.00 552.21 6,314.90 76.54 1,935.60
1,950.00 129.15 1,476.76 75.73 473.24
19,850.00 1,626.01 16,260.10 81.91 3,589.90
650.00 189.00 751.50 115.62 ( 101.50)
173,900.00 13,087.81 137,370.75 79.22 36,029.25
25,100.00 2,884.27 8,026.75 31.98 17,073.25
25,100.00 2,884.27 8,026.75 31.98 17,073.25
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 9
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
General Government
I DEPARTMENTAL EXPENDITURES
83.33% 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 0.00 60.00 0.75 7,940.00
101-4-1350-4321 Telephone 1,450.00 54.47 537.88 37.10 912.12
101-4-1350-4331 Travel, Conferences & Schools 8,000.00 652.50 1,428.37 17.85 6,571.63
101-4-1350-4904 Equip Repair/Maint Services 19,750.00 1,523.75 10,525.22 53.29 9,224.78
TOTAL Other Services & Charges 37,200.00 2,230.72 12,551.47 33.74 24,648.53
Capital Outlay
101-4-1350-4560 Equipment 30,900.00 0.00 21,133.90 68.39 9,766.10
TOTAL Capita l Outlay 30,900.00 0.00 21,133.90 68.39 9,766.10
TOTAL Information Technology
Legal
Personal Services
Supplies
Other Services & Charges
101-4-1400-4304 Legal Fees
TOTAL Other Services & Charges
266,600.00 18,202.80 179,082.87 67.17 87,517.13
240,000.00 17,960.63 208,231.95 86.76 31,768.05
240,000.00 17,960.63 208,231.95 86.76 31,768.05
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-9107 Medicare
101-4-1500-4108 Insurance
101-4-1500-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-1500-4201 Office Supplies
TOTAL Supplies
240,000.00 17,960.63 208,231.95 86.76 31,768.05
52,700.00 4,052.80 42,554.50 80.75 10,145.50
3,800.00 293.82 3,232.02 85.05 567.98
3,250.00 241.54 2,666.68 82.05 583.32
750.00 56.48 623.56 83.14 126.44
5,800.00 486.00 9,860.00 83.79 940.00
250:00 74.75 662.75 265.10 ( 412.75)
66,550.00 5,205.39 54,599.51 82.04 11,950.49
150.00 0.00 0.00 0.00 150:00
150.00 0.00 0.00 0.00 150.00
~ 11-17-2011 05:01 PM
I 101-GENERAL FUND
General Government
~ DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER PAGE: 10
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
83.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE a OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Other Services & Charges
101-9-1500-4331 Travel, Conferences & Schools 900.00 0.00
TOTAL Other Services 5 Charges 400.00 0.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-4212 Fuels & Lubs
101-4-1510-9219 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-9361 Insurance
101-4-1510-4404 Equip Repair/Maint Services
101-4-1510-4433 Dues & Subscriptions
101-4-1510-4440 Miscellaneous
101-4-1510-4960 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
TOTAL Planning
City Hall Maintenance
0.00 0.00 400.00
0.00 0.00 400.00
67,100.00 5,205.39 54,599.51 81.37 12,500.49
211,900.00 16,301.68 171,167.70 80.78 40,732.30
15,350.00 1,181.88 13,000.68 89.69 2,349.32
13,150.00 922.90 10,239.72 77.87 2,910.28
3,100.00 215.84 2,394.78 77.25 705.22
28,300.00 2,324.03 23,240.30 82.12 5,059.70
700.00 229.25 1,087.75 155.39 ( 387.75)
272,500.00 21,175.58 221,130.93 81.15 51,369.07
9,750.00 372.90 2,318.46 48.81 2,431.54
1,850.00 186.64 1,323.80 71.56 526.20
0.00 0.00 702.31 0.00 ( 702.31)
6,600.00 559.54 4,344.57 65.83 2,255.43
1,150.00 50.06 572.25 49.76 577.75
3,200.00 0.00 1,186.28 37.07 2,013.72
3,000.00 199.00 1,498.47 49.95 1,501.53
8,000.00 180.00 2,988.25 37.35 5,011.75
400.00 0.00 207.00 51.75 193.00
6,900.00 368.40 3,171.13 45.96 3,728.87
1,000.00 0.00 545.00 54.50 455.00
0.00 0.00 141.30 0.00 ( 141.30)
800.00 66.66 666.60 83.33 133.40
24,450.00 864.12 10,976.28 44.89 13,473.72
303,550.00 22,599.24 236,451.78 77.90 67,098.22
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 11
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
General Government
~ DEPARTMENTAL EXPENDITURES
Personal Services
101-4-1600-4101 Regular Pay
101-4-1600-4102 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-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
TOTAL City Hall Maintenance
Contingency
Other Services & Charges
101-4-1900-4440 Miscellaneous
TOTAL Other Services & Charges
83.33a OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
104,350.00 8,076.00 83,585.86 80.10 20,764.14
2,500.00 0.00 302.44 12.10 2,197.56
19,050.00 1,276.00 16,788.98 88.13 2,261.02
9,150.00 678.03 7,421.41 81.11 1,728.59
7,800.00 578.97 6,621.31 84.89 1,178.69
1,800.00 135.41 1,548.65 86.04 251.35
17,200.00 1,180.50 12,660.62 73.61 9,539.38
5,850.00 1,508.50 5,195.50 88.81 654.50
167,700.00 13,433.41 134,124.77 79.98 33,575.23
3,450.00 276.96 2,098.77 60.83 1,351.23
1,700.00 0.00 759.44 44.67 940.56
28,900.00 1,142.88 14,339.71 49.62 14,560.29
34,050.00 1,419.84 17,197.92 50.51 16,852.08
12,250.00 1,396.72 8,605.76 70.25 3,644.24
1,500.00 0.00 767.11 51.14 732.89
4,850.00 0.00 2,372.50 48.92 2,477.50
43,800.00 2,009.90 29,695.93 56.38 19,104.07
30,600.00 3,087.06 21,902.29 71.58 8,697.71
5,000.00 16.28 415.48 8.31 4,584.52
1,100.00 91.67 916.70 83.34 183.30
99,100.00 6,601.63 59,675.77 60.22 39,424.23
300,850.00 21,454.88 210,998.46 70.13 89,851.54
75,000.00 22,719.93 25,418.22 33.89 99,581.78
75,000.00 22,719.93 25,418.22 33.89 49,581.78
TOTAL Contingency 75,000.00 22,719.93 25,418.22 33.89 49,581.78
TOTAL General Government 2,587,800.00 197,562.15 2,045,714.22 79.05 542,085.78
1 11-17-2011 05:01 PM
I 101-GENERAL FUND
Public Safety
1 DEPARTMENTAL EXPENDITURES
' Police-Administration
Personal Services
101-4-2110-4101 Regular Pay
101-4-2110-4109 PERA
101-4-2110-4107 Medicare
101-4-2110-4108 Insurance
101-4-2110-9109 Workers Comp
TOTAL Personal Services
Supplies
101-4-2110-4201 Office Supplies
101-4-2110-4217 Uniform Allowance
101-9-2110-4219 Operating Supplies
TOTAL Supplies
CITY OF ELK RIVER PAGE: 12
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
Other Services & Charges
101-4-2110-4319 Other Professional Services
101-4-2110-4321 Telephone
101-4-2110-9322 Postage
101-4-2110-4331 Travel, Conferences & Schools
101-4-2110-9359 Publishing
101-4-2110-4361 Insurance
101-4-2110-4404 Equip Repair/Maint Services
101-4-2110-4433 Dues & Subscriptions
101-4-2110-4437 Taxes & Licenses
TOTAL Other Services & Charges
Capital Outlay
TOTAL Police Administration
~ Patrol
Personal Services
101-4-2120-4101 Regular Pay
101-4-2120-4102 Overtime Pay
101-4-2120-4104 PERA
101-4-2120-9107 Medicare
101-4-2120-4108 Insurance
TOTAL Personal Services
83.33$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
275,900.00 20,888.14 217,325.44 78.91 58,074.56
39,650.00 3,007.90 32,318.89 81.51 7,331.11
2,750.00 191.10 2,027.68 73.73 722.32
25,650.00 1,894.02 17,982.20 70.11 7,667.80
59,350.00 14,593.50 58,263.25 98.17 1,086.75
402,800.00 40,524.66 327,917.46 81.41 74,882.54
19,000.00 272.07 5,310.41 27.95 13,689.59
2,250.00 10.65 1,846.78 82.08 403.22
4,600.00 60.86 3,385.89 73.61 1,214.11
25,850.00 343.58 10,543.08 40.79 15,306.92
4,950.00 97.71 641.16 12.95 9,308.84
29,300.00 1,495.17 13,100.23 44.71 16,199.77
2,200.00 13.02 1,779.39 80.65 925.61
3,350.00 0.00 2,218.25 66.22 1,131.75
500.00 0.00 57.00 11.90 443.00
9,600.00 0.00 3,500.50 36.46 6,099.50
75,250.00 4,632.18 62,741.12 83.38 12,508.88
9,200.00 211.10 6,848.87 74.44 2,351.13
800.00 0.00 189.75 23.72 610.25
135,150.00 6,449.18 91,071.27 67.39 44,078.73
563,800.00 47,317.42 429,531.81 76.19 134,268.19
1,444,350.00 100,982.60 1,065,359.48 73.76 378,990.52
90,000.00 8,358.61 52,889.09 58.76 37,115.91
220,950.00 15,745.10 168,508.03 76.27 52,441.97
19,950.00 1,300.82 13,855.98 69.45 6,094.02
171,450.00 13,630.35 135,849.15 79.24 35,600.85
1,946,700.00 140,017.48 1,436,456.73 73.79 510,243.27
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 13
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
I 101-GENERAL FUND
Public Safety
I DEPARTMENTAL EXPENDITURES
CURRENT CURRENT YEAR TO DATE
BUDGET PERIOD ACTUAL
83.33°s OF YEAR COMP.
OF BUDGET
BUDGET BALANCE
Supplies
101-4-2120-9212 Fuels & Lubs
101-4-2120-4217 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 8,677.41 72,840.28 67.13 35,659.72
23,900.00 1,918.51 10,703.25 44.78 13,196.75
58,650.00 2,500.28 48,716.42 83.06 9,933.58
28,000.00 869.21 11,018.15 39.35 16,981.85
219,050.00 13,965.41 143,278.10 65.41 75,771.90
15,650.00 366.30 11,305.75 72.29 4,344.25
26,700.00 1,943.24 16,336.39 61.18. 10,363.61
550.00 0.00 390.00 61.82 210.00
44,150.00 3,679.17 36,791.70 83.33 7,358.30
87,050.00 5,988.71 64,773.84 74.41 22,276.16
TOTAL Patrol
Investigations
Personal Services
101-4-2130-4101 Regular Pay
101-4-2130-4102 Overtime Pay
101-4-2130-4109 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-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 159,971.60 1,644,508.67 73.00 608,291.33
505,600.00 36,367.15 378,268.42 74.82 127,331.58
45,000.00 2,105.13 17,205.27 38.23 27,794.73
79,300.00 5,539.98 59,627.57 75.19 19,672.43
5,850.00 411.91 4,500.53 76.93 1,349.47
70,100.00 5,151.56 54,852.69 78.25 15,247.31
705,850.00 49,575.73 514,454.98 72.88 191,395.52
5,150.00 0.00 3,394.52 65.91 1,755.48
8,700.00 28.28 2,921.29 33.58 5,778.71
13,850.00 28.28 6,315.81 45.60 7,534.19
11,900.00 279.34 1,823.76 15.33 10,076.24
5,550.00 241.64 2,790.55 50.28 2,759.45
1,050.00 0.00 350.00 33.33 700.00
14,250.00 1,187.50 11,875.00 83.33 2,375.00
32,750.00 1,708.48 16,839.31 51.42 15,910.69
TOTAL Investigations 752,450.00 51,312.49 537,609.60 71.95 214,840.40
1 11-17-2011 05:01 PM
I 101-GENERAL FUND
Public Safety
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER PAGE: 14
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
83.33°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Police Support Services
I Personal Services
101-4-2150-9101 Regular Pay
101-4-2150-4102 Overtime Pay
101-4-2150-4104 PERA
101-4-2150-4105 FICA
101-4-2150-4107 Medicare
i01-4-2150-4108 Insurance
TOTAL Personal Services
Supplies
101-4-2150-4201 Office Supplies
101-4-2150-4217 Uniform Allowance
101-4-2150-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-2150-4331 Travel, Conferences & Schools
101-4-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
I Capital Outlay
347,050.00 26,289.52 275,741.72 79.45 71,308.28
3,500.00 0.00 263.45 7.53 3,236.55
25,400.00 1,752.26 20,650.80 81.30 4,749.20
21,750.00 1,592.51 17,512.68 80.52 4,237.32
5,100.00 372.44 4,114.39 80.67 985.61
46,350.00 3,502.02 36,813.17 79.42 9,536.83
949,150.00 33,508.75 355,096.21 79.06 99,053.79
1,000.00 0.00 453.77 45.38 546.23
3,000.00 950.97 1,632.88 54.43 1,367.12
10,100.00 1,884.94 7,904.27 78.26 2,195.73
14,100.00 2,335.91 9,990.92 70.86 4,109.08
3,550.00 170.00 924.53 26.04 2,625.47
1,850.00 0.00 1,126.50 60.89 723.50
16,000.00 1,709.53 12,136.63 75.85 3,863.37
500.00 0.00 373.33 74.67 126.67
6,550.00 545.83 5,958.30 83.33 1,091.70
28,450.00 2,425.36 20,019.29 70.37 8,430.71
TOTAL Police Support Services
1 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-4-2160-4109 Workers Comp
101-4-2160-4110 Re-employment Compensation
TOTAL Personal Services
Supplies
101-4-2160-4217 Uniform Allowance
101-4-2160-4219 Operating Supplies
TOTAL Supplies
491,700.00 38,270.02 385,106.42 78.32 106,593.58
5,500.00 46.73 9,054.58 164.63 ( 3,554.58)
0.00 0.00 212.92 0.00 ( 212.92)
350.00 2.90 613.89 175.40 ( 263.89)
100.00 0.68 143.58 143.SS ( 93.58)
0.00 0.00 1,026.00 0.00 ( 1,026.00)
0.00 0.00 10.97 0.00 ( 10.97)
5,950.00 50.31 11,061.94 185.91 ( 5,111.94)
5,000.00 58.95 2,524.01 50.48 2,975.99
6,000.00 124.89 2,182.96 36.38 3,817.04
11,000.00 183.79 4,706.97 42.79 6,293.03
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 15
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
I 101-GENERAL FUND
Public Safety
I DEPARTMENTAL EXPENDITURES
83.33°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE °s OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Other Services & Charges
101-4-2160-4319 Other Professional Services
101-4-2160-4321 Telephone
101-9-2160-4331 Travel, Conferences & Schools
101-4-2160-4359 Publishing
101-4-2160-4433 Dues & Subscriptions
TOTAL Other Services & Charges
Capital Outlay
1,500.00 0.00
1,600.00 0.00
1,700.00 0.00
150.00 0.00
1,000.00 0.00
5,950.00 0.00
395.00 26.33 1,105.00
0.00 0.00 1,600.00
100.00 5.88 1,600.00
0.00 0.00 150.00
585.00 58.50 415.00
1,080.00 18.15 4,870.00
TOTAL Police Reserves
Public safety building
Personal Services
101-4-2190-4101 Regular Pay
101-4-2190-4102 Overtime Pay
101-4-2190-4104 PERA
101-4-2190-4105 FICA
101-4-2190-4107 Medicare
101-4-2190-4108 Insurance
101-4-2190-4109 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
22,900.00 234.10 16,848.91 73.58 6,051.09
101,850.00 7,443.97 78,183.40 76.76 23,666.60
0.00 0.00 175.54 0.00 ( 175.54)
7,400.00 539.67 5,926.50 80.09 1,473.50
6,300.00 444.31 4,991.54 78.44 1,358.46
1,500.00 103.91 1,155.63 77.04 344.37
13,300.00 1,098.49 11,091.64 83.02 2,258.36
3,400.00 812.25 3,655.50 107.51 ( 255.50)
133,750.00 10,442.60 105,079.75 78.56 28,670.25
15,000.00 1,962.34 10,926.57 72.84 4,073.43
15,000.00 1,462.34 10,926.57 72.84 4,073.93
6,750.00 0.00 2,570.00 38.07 4,180.00
18,200.00 807.83 14,768.82 81.15 3,431.18
31,300.00 1,533.01 10,102.12 32.28 21,197.88
56,250.00 2,340.84 27,490.94 48.78 28,809.06
TOTAL Public safety building
Fire Administration
205,000.00 14,245.78 143,447.26 69.97 61,552.74
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 16
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
Public Safety
DEP.n,RTMENTAL EXPENDITURES
83.33$ OF YEAR COMP.
CURRENT CURRENT
BUDGET PERIOD
YEAR TO DATE % OF BUDGET
ACTUAL BUDGET BALANCE
Personal Services
101-4-2310-4101 Regular Pay
i01-4-2310-4102 Overtime Pay
101-4-2310-4103 Part-time Pay
101-4-2310-4104 PERA
101-9-2310-4105 FICA
101-4-2310-4106 Other Retirement Contributions
101-4-2310-4107 Medicare
101-4-2310-4108 Insurance
101-4-2310-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-2310-4201 Office Supplies
101-4-2310-9212 Fuels & Lubs
101-4-2310-4217 Uniform Allowance
101-4-2310-9219 Operating Supplies
101-4-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-9331 Travel, Conferences & Schools
101-4-2310-4359 Publishing
101-4-2310-4361 Insurance
101-4-2310-4389 Utilities
101-4-2310-4901 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
86,200.00 7,064.74 72,641.66 84.27 13,558.34
0.00 0.00 16.72 0.00 ( 16.72)
186,250.00 8,413.46 135,347.97 72.67 50,902.03
13,500.00 910.47 11,558.10 85.62 1,941.90
12,500.00 537.23 8,664.53 69.32 3,835.47
38,500.00 116,902.00 38,500.00 100.00 0.00
3,950.00 206.42 2,892.16 73.22 1,057.84
7,200.00 732.75 10,341.44 143.63 ( 3,141.44)
20,200.00 7,635.75 22,920.25 113.47 ( 2,720.25)
368,300.00 142,402.82 302,882.83 82.29 65,417.17
5,150.00 0.00 4,306.55 83.62 843.45
.7,350.00 928.85 6,998.13 94.53 401.87
4,400.00 0.00 986.14 22.41 3,413.86
26,150.00 443.12 14,593.55 55.81 11,556.45
7,400.00 278.94 6,266.82 89.69 1,133.18
50,450.00 1,650.91 33,101.19 65.61 17,348.81
5,100.00 1,267.00 3,597.99 70.55 1,502.01
4,950.00 184.90 2,012.17 40.65 2,937.83
500.00 0.00 276.34 55.27 223.66
27,450.00 341.25 11,950.99 43.54 15,499.01
300.00 39.00 39.00 13.00 261.00
17,500.00 0.00 7,467.50 42.67 10,032.50
15,150.00 284.27 8,907.35 58.79 6,242.65
5,650.00 328.25 9,106.30 72.68 1,543.70
31,550.00 2,159.94 38,687.76 122.62 ( 7,137.76)
1,950.00 229.00 1,730.00 88.72 220.00
29,650.00 2,470.83 24,708.30 83.33 4,941.70
139,750.00 7,304.44 103,483.70 74.05 36,266.30
31,100.00 0.00 29,040.94 93.38 2,059.06
31,100.00 0.00 29,040.94 93.38 2,059.06
589,600.00 151,358.17 468,508.66 79.46 121,091.34
Fire Inspections
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 17
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
I 101-GENERAL FUND
Public Safety
I DEPARTMENTAL EXPENDITURES
83.33$ OF YEAR-COMP.
CURRENT CURRENT YEAR TO DATE a OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-2320-4101 Regular Pay
101-4-2320-4104 PERA
101-4-2320-4105 FICA
101-4-2320-4107 Medicare
101-9-2320-4108 Insurance
TOTAL Personal Services
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-4433 Dues & Subscriptions
TOTAL Other Services & Charges
129,400.00 9,968.32 104,849.71 81.03 29,550.29
14,850.00 1,145.66 12,600.47 84.85 2,249.53
3,250.00 257.68 2,983.69 91.81 266.31
1,900.00 142.39 1,601.96 84.31 298.04
14,850.00 1,195.86 11,958.60 80.53 2,891.40
164,250.00 12,709.91 133,994.43 81.58 30,255.57
2,750.00 14.83 558.12 20.30 2,191.88
3,200.00 203.20 2,940.73 91.90 259.27
1,400.00 0.00 0.00 0.00 1,400.00
9,450.00 1,234.81 3,163.44 71.09 1,286.56
11,800.00 1,452.84 6,662.29 56.46 5,137.71
2,950.00 190.11
2,500.00 0.00
2,000.00 17.71
1,350.00 0.00
8,800.00 207.82
1,582.36 53.64 1,367.64
1,122.48 44.90 1,377.52
505.41 25.27 1,494.59
982.50 72.78 367.50
4,192.75 47.64 4,607.25
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-9108 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
184,850.00 14,370.57 144,849.47 78.36 40,000.53
8,900.00 696.28 7,128.79 80.10 1,771.21
1,300.00 100.26 1,074.64 82.66 225.36
150.00 10.10 108.32 72.21 41.68
600.00 39.84 398.40 66.40 201.60
10,950.00 846.48 8,710.15 79.54 2,239.85
500.00 0.00 97.68 19.54 402.32
9,150.00 637.94 6,673.08 72.93 2,476.92
9,650.00 637.94 6,770.76 70.16 2,879.24
1,650.00 26.00 157.43 9.54 1,492.57
4,000.00 0.00 70.80 1.77 3,929.20
1,500.00 76.71 855.38 57.03 644.62
7,800.00 96.19 1,151.46 14.76 6,648.54
100.00 0.00 100.00 100.00 0.00
15,050.00 198.90 2,335.07 15.52 12,714.93
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 18
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
I 101-GENERAL FUND
Public Safety
I DEPARTMENTAL EXPENDITURES
83.33 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Capital Outlay
TO1-4-2330-4560 Equipment
TOTAL Capital Outlay
71,750.00 0.00 67,098.55 93.52 4,651.45
71,750.00 0.00 67,098.55 93.52 4,651.45
TOTAL Emergency Management
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-9105 FICA
101-4-2410-9107 Medicare
101-4-2410-4108 Insurance
101-4-2410-4109 Workers Comp
TOTAL Personal Services
Supplies
101-9-2410-4201 Office Supplies
101-4-2410-4212 Fuels & Lubs
101-4-2410-9219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-2910-4319 Other Professional Services
101-4-2410-4321 Telephone
101-4-2410-4322 Postage
101-4-2410-4331 Travel, Conferences & Schools
101-4-2410-9361 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
I TOTAL Building Safety
Environmental
107,900.00 1,683.32 84,914.53 79.06 22,485.47
319,400.00 24,568.15 257,558.67 80.64 61,841.33
25,950.00 2,111.27 21,650.03 83.93 4,299.97
25,050.00 1,934.28 21,207.05 84.66 3,842.95
21,400.00 1,542.02 17,016.63 79.52 4,383.37
5,000.00 360.63 3,979.67 79.59 1,020.33
40,150.00 3,286.02 32,728.60 81.52 7,421.40
1,200.00 382.25 1,994.00 124.50 ( 294.00)
438,150.00 34,184.62 355,634.65 81.17 82,515.35
2,500.00 327.57 1,592.29 63.69 907.71
9,700.00 295.09 3,083.32 65.60 1,616.68
2,250.00 199.0.5 641.40 28.51 1,608.60
9,450.00 821.71 5,317.01 56.26 4,132.99
0.00 0.00 340.00 0.00 ( 340.00)
1,600.00 100.91 1,248.09 78.01 351.91
400.00 0.00 522.06 130.52 ( 122.06)
4,650.00 930.00 2,465.00 53.01 2,185.00
900.00 0.00 299.50 33.28 600.50
7,200.00 210.69 5,331.56 74.05 1,868.44
1,200.00 0.00 340.00 28.33 860.00
1,650.00 137.50 1,375.00 83.33 275.00
17,600.00 1,379.10 11,921.21 67.73 5,678.79
465,200.00 36,385.43 372,872.87 80.15 92,327.13
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 19
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
Public Safety
DEPARTMENTAL EXPENDITURES
CURRENT CURRENT
BUDGET PERIOD
83.33a OF YEAR COMP.
YEAR TO DATE a OF BUDGET
ACTUAL BUDGET BALANCE
Personal Services
101-4-2440-4101 Regular Pay
101-4-2440-4104 PERA
101-4-2440-4105 FICA
101-4-2440-4107 Medicare
101-4-2940-4108 Insurance
101-4-2440-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-2440-4201 Office Supplies
101-9-2490-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-2440-4433 Dues & Subscriptions
TOTAL Other Services & Charges
39,050.00 3,002.80
2,850.00 217.70
2,400.00 160.96
550.00 37.64
4,850.00 979.59
900.00 140.75
50,100.00 4,039.49
650.00 33.95
150.00 0.00
800.00 33.95
700.00 3.82
500.00 0.00
500.00 228.00
100.00 0.00
200.00 0.00
3,000.00 0.00
1,050.00 0.00
6,050.00 231.82
31,529.38 80.74 7,520.62
2,385.74 83.71 464.26
1,788.76 74.53 611.24
418.31 76.06 131.69
4,795.91 98.88 54.09
511.00 127.75 ( 111.00)
41,429.10 82.69 8,670.90
322.61 49.63 327.39
212.15 141.43 ( 62.15)
534.76 66.85 265.24
193.72 27.67 506.28
665.78 133.16 ( 165.78)
491.66 98.33 8.34
67.50 67.50 32.50
0.00 0.00 200.00
525.32 17.51 2,474.68
40.00 3.81 1,010.00
1,983.98 32.79 4,066.02
TOTAL Environmental 56,950.00 4,305.21 43,947.84 77.17 13,002.16
TOTAL Public Safety
Street Maintenance
Personal Services
101-4-3120-4101 Regular Pay
101-4-3120-4102 Overtime Pay
101-4-3120-4103 Part-time Pay
101-4-3120-4104 PERA
101-9-3120-4105 FICA
101-4-3120-4107 Medicare
101-4-3120-4108 Insurance
101-4-3120-4109 Workers Comp
TOTAL Personal Services
5,692,650.00 519,454.11 4,272,146.04 75.05 1,420,503.96
426,650.00 38,469.72 341,595.99 80.06 85,054.01
0.00 0.00 75.99 0.00 ( 75.99)
78,400.00 5,447.62 57,894.29 73.78 20,555.71
34,950.00 2,879.32 26,163.30 74.86 8,786.70
31,300.00 2,536.71 23,870.22 76.26 7,429.78
7,350.00 593.25 5,582.47 75.95 1,767.53
57,050.00 5,864.00 49,140.66 77.37 12,909.34
25,050.00 6,191.25 25,499.25 101.79 ( 449.25)
660,750.00 61,976.87 529,772.17 79.42 135,977.83
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 20
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
Public Works
DEPARTMENTAL EXPENDITURES
83.33°s OF YEAR COMP.
CURRENT CURRENT
BUDGET PERIOD
YEAR TO DATE $ OF BUDGET
ACTUAL BUDGET BALANCE
Supplies
101-4-3120-4201 Office Supplies
101-4-3120-4212 Fuels & Lubs
101-4-3120-4219 Operating Supplies
101-9-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-4389 Utilities
101-4-3120-4401 Bldg Repair/Maint Services
101-4-3120-4404 Equip Repair/Maint Services
101-4-3120-9409 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
Capital Outlay
3,600.00 141.19 823.50 22.88 2,776.50
64,250.00 7,234.96 72,869.35 113.92 ( 8,619.35)
146,750.00 3,274.50 73,659.67 50.19 73,090.33
42,000.00 1,621.39 40,390.28 96.17 1,609.72
256,600.00 12,272.04 187,742.80 73.17 68,857.20
250.00 0.00 0.00 0.00 250.00
8,950.00 450.67 3,854.67 43.07 5,095.33
200.00 0.00 61.76 30.88 138.24
3,000.00 0.00 1,176.36 39.21 1,823.64
500.00 0.00 80.00 16.00 420.00
17,250.00 0.00 8,716.50 50.53 8,533.50
36,000.00 2,675.37 29,134.23 80.93 6,865.77
4,500.00 200.00 2,726.49 60.59 1,773.51
5,000.00 21.95 3,798.89 75.98 1,201.11
422,750.00 9,643.94 941,057.76 104.33 ( 18,307.76)
10,000.00 1,211.43 2,473.66 29.74 7,526.34
9,700.00 243.10 1,825.88 38.85 2,874.12
350.00 0.00 251.25 71.79 98.75
500.00 25.00 129.50 25.90 370.50
93,150.00 7,762.50 77,625.00 83.33 15,525.00
607,100.00 22,233.96 572,911.95 94.37 34,188.05
TOTAL Street Maintenance
Snow Removal
Personal Services
101-9-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-9-3130-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-3130-4219 Operating Supplies
TOTAL Supplies
1,524,450.00 96,482.87 1,285,426.92 89.32 239,023.08
115,500.00 369.12 69,962.41 60.57 45,537.59
15,000.00 0.00 17,367.13 115.78 ( 2,367.13)
9,050.00 26.77 7,755.22 85.69 1,294.78
8,100.00 22.88 6,212.95 76.70 1,887.05
1,900.00 5.35 1,452.97 76.47 447.03
15,950.00 94.76 14,270.97 89.47 1,679.03
7,350.00 1,529.75 4,961.75 67.51 2,388.25
172,850.00 2,098.63 121,983.40 70.57 50,866.60
90,000.00 0.00 75,595.79 84.00 19,404.26
90,000.00 0.00 75,595.74 84.00 14,404.26
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 21
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
Public Works
DEPARTMENTAL EXPENDITURES
83.330 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Other Services & Charges
Capital Outlay
TOTAL Snow Removal
Equipment Services
Personal Services
101-4-3150-9101 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
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
262,850.00 2,048.63 197,579.14 75.17 65,270.86
162,750.00 12,520.02 126,619.49 77.80 36,130.51
0.00 0.00 41.39 0.00 ( 41.39)
11,800.00 907.68 9,490.76 80.43 2,309.24
10,100.00 716.10 7,567.64 74.93 2,532.36
2,350.00 167.48 1,769.88 75.31 580.12
22,700.00 1,882.01 16,734.23 73.72 5,965.77
7,050.00 1,027.25 3,862.75 54.79 3,187.25
216,750.00 17,220.54 166,086.14 76.63 50,663.86
14,500.00 601.79 13,625.52 93.97 874.48
11,200.00 0.00 0.00 0.00 11,200.00
25,700.00 601.79 13,625.52 53.02 12,079.48
500.00 0.00 182.16 36.93 317.84
3,000.00 204.00 2,020.76 67.36 979.24
3,500.00 209.00 2,202.92 62.94 1,297.08
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-9-3300-4109 Workers Comp
TOTAL Personal Services
295,950.00 18,026.33 181,914.58 73.96 64,035.42
116,750.00 6,896.62 70,681.43 60.54 46,068.57
8,450.00 500.00 5,364.62 63.49 3,085.38
7,250.00 377.24 4,084.22 56.33 3,165.78
1,700.00 88.22 955.10 56.18 744.90
13,000.00 928.01 9,280.10 71.39 3,719.90
450.00 144.25 124.25 27.61 325.75
147,600.00 8,934.39 90,489.72 61.31 57,110.28
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 22
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
Public Works
DEPARTMENTAL EXPENDITURES
83.33$ OF YEAR COMP.
YEAR TO DATE % OF BUDGET
P.CTUAL BUDGET BALANCE
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-9319 Other Professional Services
101-4-3300-9321 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
CURRENT
BUDGET CURRENT
PERIOD
1,000.00 22.64
700.00 27.60
9,800.00 0.00
11,500.00 50.24
10,000.00
1,150.00
200.00
5,850.00
200.00
500.00
800.00
18,700.00
60.53 6.05 939.47
351.12 50.16 348.88
68.17 0.70 9,731.83
479.82 4.17 11,020.18
0.00 1,302.81 13.03
2.19 17.79 1.54
0.00 207.36 103.68
0.00 175.00 2.99
0.00 92.00 46.00
187.03 1,870.30 374.06
66.67 666.70 83.34
255.89 4,331.91 23.17
14,368.09
TOTAL Engineering
177,800.00 9,240.42 95,301.45 53.60 82,498.55
TOTAL Public Works
Parks Department
Personal Services
101-9-5110-4101 Regular Pay
101-4-5110-4102 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
2,211,050.00 125,798.25 1,760,222.09 79.61 450,827.91
350,250.00 30,060.14 292,613.04 83.54 57,636.96
0.00 0.00 19.00 0.00 ( 19.00)
40,000.00 3,022.00 38,996.65 97.99 1,003.35
25,400.00 2,103.27 21,884.96 86.16 3,515.04
24,200.00 1,938.59 20,196.72 83.46 9,003.28
5,650.00 453.40 4,723.60 83.60 926.40
46,900.00 4,136.97 92,070.70 89.70 9,829.30
9,000.00 2,582.00 10,154.50 112.83 ( 1,154.50)
0.00 O.OD 3,247.00 0.00 ( 3,247.00)
501,400.00 94,296.37 433,906.17 86.54 67,493.83
33,200.00 9,541.00 29,470.68 88.77 3,729.32
3,250.00 428.14 2,272.16 69.91 977.84
72,900.00 9,212.23 66,230.75 90.85 6,669.25
11,000.00 973.35 15,544.43 141.31 ( 4,544.43)
120,350.00 15,159.72 113,518.02 94.32 6,831.98
8,697.19
1,132.26
7.36)
5,675.00
108.00
1,370.30)
133.30
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 23
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
Culture & Recreation
DEPARTMENTAL EXPENDITURES
83.33% OF YEAR COMP.
CURRENT CURRENT
BUDGET PERIOD
YEAR TO DATE % OF BUDGET
ACTUAL BUDGET BALANCE
Other Services & Charaes
101-4-5110-4321 Telephone
101-4-5110-4322 Postage
101-4-5110-4331 Travel, Conferences ~ Schools
101-4-5110-9361 Insurance
101-4-5110-4389 Utilities
101-4-5110-4401 Bldg Repair/Maint Services
101-4-5110-4404 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
4,400.00 237.76 2,245.32 51.03 2,154.68
100.00 0.00 10.22 10.22 89.78
3,150.00 0.00 1,101.77 34.98 2,048.23
26,700.00 0.00 12,814.50 47.99 13,885.50
27,800.00 5,115.49 17,544.95 63.11 10,255.05
4,000.00 3,650.00 4,375.00 109.38 ( 375.00)
12,000.00 503.07 9,415.31 78.46 2,584.69
7,550.00 1,088.66 8,307.01 110.03 ( 757.01)
25,000.00 1,207.73 10,148.91 40.60 14,851.09
57,900.00 4,825.00 48,250.00 83.33 9,650.00
168,600.00 16,627.66 114,212.99 67.74 54,387.01
TOTAL Parks Department
Parks & Rec Admin
Personal Services
101-4-5210-4101 Regular Pay
101-4-5210-4102 Overtime Pay
101-4-5210-4103 Part-time Pay
101-4-5210-4104 PERA
101-4-5210-4105 FICA
101-4-5210-4107 Medicare
101-4-5210-9108 Insurance
101-9-5210-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-5210-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-5210-4321 Telephone
101-4-5210-4322 Postage
101-4-5210-4331 Travel, Conferences & Schools
101-4-5210-4349 Advertising/Marketing
101-4-5210-4361 Insurance
101-4-5210-4389 Utilities
101-4-5210-4401 Bldg Repair/Maint Services
101-4-5210-4404 Equip Repair/Maint Services
101-4-5210-4433 Dues & Subscriptions
TOTAL Other Services & Charges
790,350.00 76,078.75 661,637.18 83.71 128,712.82
338,950.00 24,658.68 207,188.63 61.13 131,761.37
0.00 0.00 75.23 0.00 ( 75.23)
20,850.00 2,970.41 29,566.53 141.81 ( 8,716.53)
26,100.00 2,003.10 17,942.07 68.74 8,157.93
22,300.00 1,618.29 19,372.07 69.45 7,927.93
5,200.00 378.49 3,361.36 64.64 1,838.64
45,600.00 2,717.96 28,135.70 61.70 17,464.30
3,750.00 1,026.00 3,795.50 101.21 ( 45.50)
462,750.00 35,372.93 304,437.09 65.79 158,312.91
11,700.00 410.81 10,920.58 93.34 779.42
11,700.00 410.81 10,920.58 93.34 779.92
4,800.00 356.79 3,019.96 62.92 1,780.04
4,000.00 0.00 3,309.25 82.73 690.75
6,950.00 118.77 4,490.13 64.61 2,459.87
26,400.00 1,431.70 24,208.26 91.70 2,191.74
1,950.00 0.00 307.50 21.21 1,142.50
8,500.00 208.78 3,791.04 44.60 4,708.96
12,850.00 1,139.39 12,815.96 99.74 34.04
9,350.00 554.87 9,975.04 106.68 ( 625.04)
1,550.00 0.00 1,083.00 69.87 467.00
75,850.00 3,810.30 63,000.14 83.06 12,849.86
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 24
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
Culture & Recreation
DEPARTMENTAL EXPENDITURES
83.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
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-4104 PERA
101-4-5220-4105 FICA
101-4-5220-4107 Medicare
101-4-5220-4110 Re-employment Compensation
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-4409 Contractual Services
101-4-5220-4412 Building Rent
101-4-5220-4938 Credit Card Fees
TOTAL Other Services & Charges
TOTAL Recreation Programs
Concessions
550,300.00 39,594.04 378,357.81 68.75 171,992.19
0.00 0.00 4,484.26 0.00 ( 4,484.26)
82,000.00 6,250.56 85,184.53 103.88 ( 3,184.53)
2,400.00 114.47 1,466.95 61.12 933.05
4,350.00 387.59 5,744.27 132.05 ( 1,394.27)
1,200.00 90.62 1,343.42 111.95 ( 143.92)
0.00 121.62 121.62 0.00 ( 121.62)
89,950.00 6,964.81 98,395.05 109.33 ( 8,395.05)
31,000.00 628.75 32,332.58 104.30 ( 1,332.58)
31,000.00 628.75 32,332.58 104.30 ( 1,332.58)
500.00 0.00 0.00 0.00 500.00
64,050.00 3,270.49 53,442.26 83.44 10,607.74
3,000.00 0.00 1,544.34 51.48 1,455.66
4,000.00 162.56 4,196.49 109.91 ( 196.99)
71,550.00 3,433.05 59,153.09 82.72 12,366.91
192,500.00 11,026.61 189,860.72 98.63 2,639.28
Personal Services
101-4-5230-4103 Part-time Pay 3,650.00 286.50
101-4-5230-4104 PERA 150.00 2.47
101-4-5230-4105 FICA 250.00 17.77
101-4-5230-4107 Medicare 50.00 4.16
TOTAL Personal Services 4,100.00 310.90
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
3,894.27 106.69 ( 244.27)
24.91 16.61 125.09
193.29 77.32 56.71
45.23 90.46 4.77
9,157.70 101.41 ( 57..70)
0.00 208.98 7.21 2,691.02
0.00 4,086.30 58.38 2,913.70
0.00 9,295.28 43.39 5,604.72
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 25
REVENUE & EXPENSE REPOR T (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
Culture & Recreation 83.330 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Other Services & Charges
101-4-5230-4401 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 14,100.00 310.90 8,452.98 59.95 5,647.02
Sr Citizen Programs
Personal Services
101-4-5510-4101 Regular Pay 57,400.00 4,414.41 96,351.32 80.75 11,048.68
101-4-5510-4103 Part-time Pay 62,000.00 4,701.44 99,117.45 79.22 12,882.55
101-4-5510-4104 PERA 8,650.00 660.90 7,251.96 83.84 1,398.04
101-4-5510-4105 FICA 7,400.00 529.10 5,840.97 78.93 1,559.03
101-4-5510-4107 Medicare 1,750.00 123.76 1,366.12 78.06 383.88
101-4-5510-4108 Insurance 13,700.00 1,110.20 11,102.00 81.04 2,598.00
101-4-5510-4109 Workers Comp 500.00 145.25 544.75 108.95 ( 44.75)
TOTAL Personal Services 151,400.00 11,685.06 121,574.57 80.30 29,825.43
Supplies
101-4-5510-4219 Operating Supplies 12,400.00 1,480.47 6,396.49 51.58 6,003.51
TOTAL Supplies 12,400.00 1,480.47 6,396.49 51.58 6,003.51
Other Services & Charges
101-4-5510-4321 Telephone 2,600.00 157.06 1,683.87 64.76 916.13
101-4-5510-4322 Postage 2,500.00 405.70 2,260.13 90.41 239.87
101-4-5510-4331 Travel, Conferences & Schools 2,400.00 172.61 761.07 31.71 1,638.93
101-4-5510-4361 Insurance 1,600.00 0.00 742.50 46.41 857.50
101-4-5510-9389 Utilities 9,700.00 620.36 7,586.72 78.21 2,113.28
101-4-5510-4401 Bldg Repair/Maint Services 12,400.00 944.66 9,956.07 80.29 2,443.93
101-4-5510-4404 Equip Repair/Maint Services 1,500.00 179.54 765.83 51.06 734.17
101-4-5510-4409 Contractual Services 6,950.00 86.00 599.15 8.62 6,350.85
101-4-5510-4433 Dues & Subscriptions 1,000.00 0.00 821.91 82.19 178.09
TOTAL Other Services & Charges 40,650.00 2,565.93 25,177.25 61.94 15,472.75
Capital Outlay
TOTAL Sr Citizen Programs 204,450.00 15,731.46 153,148.31 74.91 51,301.69
TOTAL Culture & Recreation 1,751,700.00 142,741.76 1,391,457.00 79.43 360,243.00
11-17-2011 05:01 PM CITY OF ELK RIVER PAGE: 26
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
101-GENERAL FUND
Economic Development
DEPARTMENTAL EXPENDITURES
83.33a OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE a OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
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-9105 FICA
101-4-6210-4107 Medicare
101-4-6210-4108 Insurance
TOTAL Personal Services
Other Services & Charges
101-4-6210-4940 Miscellaneous
TOTAL Other Services & Charges
0.00 9,419.54 22,091.84 0.00 ( 22,091.84)
0.00 1,049.87 2,099.74 0.00 ( 2,099.74)
0.00 697.92 1,631.66 0.00 ( 1,631.66)
0.00 572.60 1,384.80 0.00 ( 1,384.80)
0.00 136.08 328.19 0.00 ( 328.19)
0.00 1,386.00 2,772.00 0.00 ( 2,772.00)
0.00 13,262.01 30,308.23 0.00 ( 30,308.23)
0.00 206.15 505.03 0.00 ( 505.03)
0.00 206.15 505.03 0.00 ( 505.03)
TOTAL Economic Development
Energy City
0.00 13,468.16 30,813.26 0.00 ( 30,813.26)
Personal Services
101-4-6220-4101 Regular Pay 28,700.00 2,208.32 23,187.36 80.79 5,512.64
101-4-6220-4104 PERA 2,100.00 160.12 1,750.11 83.34 349.89
101-4-6220-9105 FICA 1,800.00 123.14 1,358.98 75.50 441.02
101-4-6220-4107 Medicare 400.00 28.80 317.84 79.46 82.16
101-4-6220-9108 Insurance 3,150.00 249.51 2,995.10 79.21 654.90
TOTAL Personal Services 36,150.00 2,769.89 29,109.39 80.52 7,040.61
Supplies
Other Services & Charges
101-4-6220-4319 Other Professional Services 5,000.00 0.00 4,634.00 92.68 366.00
101-4-6220-4331 Travel, Conferences & Schools 7,500.00 0.00 ( 626.71) 8.36- 8,126.71
101-4-6220-4359 Publishing 3,000.00 19.95 1,636.66 54.56 1,363.34
TOTAL Other Services & Charges 15,500.00 19.95 5,643.95 36.41 9,856.05
TOTAL Energy City 51,650.00 2,789.84 34,753.34 67.29 16,896.66
TOTAL Economic Development 51,650.00 16,258.00 65,566.60 126.94 ( 13,916.60)
11-17-2011 05:01 PM
101-GENERAL FUND
General
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
PAGE: 27
83.330 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Transfers Out
Transfers Out
101-4-7000-9723 Transfer-Ice Arena 156,250.00 0.00 0.00 0.00 156,250.00
101-4-7000-4724 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 12,500,050.00 1,001,814.27 9,535,105.95 76.28 2,964,944.05
REVENUES OVER/(UNDER) EXPENDITURES ( 336,600.00)( 884,368.25)( 2,090,207.11) 1,753,607.11
11-17-2011 05:02 PM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
221-ICE ARENA
FINANCIAL SUMMARY
83.330 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE g OF BUDGET
BUDGET PERIOD 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 26,264.11 321,535.19 97.36 357,364.81
49,500.00 0.00 44,600.00 90.10 4,900.00
73,350.00 1,108.00 46,764.40 63.76 26,585.60
63,100.00 5,454.83 49,346.36 78.20 13,753.69
864,850.00 32,826.94 462,245.95 53.45 402,604.05
756,500.00 53,311.78 942,186.89 58.45 314,313.11
27,050.00 86.40 12,856.45 47.53 14,193.55
39,050.00 909.91 16,559.66 48.63 17,490.34
47,250.00 5,244.75 31,454.72 66.57 15,795.28
864,850.00 59,552.84 503,057.72 58.17 361,792.28
864,850.00 59,552.84 503,057.72 58.17 361,792.28
0.00 ( 26,725.90)( 40,811.77) 40,811.77
11-17-2011 05:02 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
221-ICE ARENA
REVENUES
Ice Arena
Charges for Services
221-3-0000-3464 Ice Rental
221-3-0000-3465 Admissions
221-3-0000-3966 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
TOTAL Hockey
Skating
83.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
443,000.00 23,849.45 269,887.03 60.92 173,112.97
22,900.00 0.00 17,666.25 77.15 5,233.75
14,600.00 0.00 17,168.07 117.59 ( 2,568.07)
4,100.00 336.00 3,016.00 73.56 1,084.00
2,600.00 2,600.00 2,600.00 100.00 0.00
17,000.00 ( 1,340.00) 934.00 5.49 16,066.00
504,200.00 25,445.45 311,271.35 61.74 192,928.65
16,650.00 625.57 8,420.36 50.57 8,229.64
1,800.00 188.59 1,646.78 91.49 153.22
18,450.00 814.11 10,067.14 54.56 8,382.86
0.00 4.55 196.70 0.00 ( 196.70)
0.00 4.55 196.70 0.00 ( 196.70)
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 26,264.11 321,535.19 97.36 357,364.81
49,500.00 0.00 44,600.00 90.10 4,900.00
49,500.00 0.00 44,600.00 90.10 4,900.00
49,500.00 0.00 44,600.00 90.10 4,900.00
11-17-2011 05:02 PM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
221-ICE ARENA
REVENUES
83.330 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUP.L BUDGET BALANCE
Charges for Services
221-3-5420-3461 Recreation Fees 68,000.00 1,108.00 43,312.70 63.70 24,687.30
221-3-5420-3465 Admissions 3,800.00 0.00 3,451.70 90.83 348.30
TOTAL Charges for Services 71,800.00 1,108.00 46,764.40 65.13 25,035.60
Other Revenue
221-3-5420-3629 MiscellaneoLS 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 1,108.00 46,764.40 63.76 26,585.60
Concessions
Charges for Services
221-3-5430-3467 Concessions 63,100.00 5,454.83 49,346.36 78.20 13,753.64
TOTAL Charges for Services 63,100.00 5,454.83 49,396.36 78.20 13,753.64
TOTAL Concessions 63,100.00 5,459.83 49,346.36 78.20 13,753.64
TOTAL REVENUE 864,850.00 32,826.94 462,245.95 53.45 402,604.05
11-17-2011 05:02 PM CITY OF ELK RIVER PAGE: 4
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
~ 221-ICE ARENA
I DEPARTMENTAL EXPENDITURES
83.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Ice Arena
Personal Services
221-4-5400-4101 Regular Pay 148,700.00 9,593.72 105,491.77 70.99 43,208.23
221-4-5900-4103 Part-time Pay 73,200.00 7,546.58 60,822.13 83.09 12,377.87
221-4-5400-4104 PERA 12,250.00 1,094.65 10,569.51 86.24 1,685.49
221-4-5400-4105 FICA 13,750.00 1,023.05 10,757.64 78.24 2,992.36
221-9-5400-4107 Medicare 3,200.00 239.28 2,515.91 78.62 684.09
221-4-5400-9108 Insurance 17,150.00 1,826.02 12,175.42 70.99 4,974.58
221-4-5400-4109 Workers Comp 5,550.00 1,789.75 6,991.25 125.97 ( 1,441.25)
221-4-5400-4110 Re-employment Compensation 0.00 0.00 369.48 0.00 ( 369.48)
TOTAL Person al Services 273,800.00 23,113.05 209,688.11 76.58 64,111.89
Supplies
221-4-5400-4212 Fuels & Lubs 400.00 0.00 44.55 11.14 355.45
221-4-5400-4217 Uniform Allowance 1,500.00 0.00 266.50 17.77 1,233.50
221-4-5400-4219 Operating Supplies 34,500.00 2,642.21 26,138.31 75.76 8,361.69
221-4-5900-4255 Soft Drinks/Misc 9,000.00 1,232.20 3,812.44 42.36 5,187.56
221-4-5400-4259 Other Merchandise For Resale 900.00 0.00 0.00 0.00 900.00
TOTAL Suppli es 46,300.00 3,874.41 30,261.80 65.36 16,038.20
Other Services & Charges
221-9-5900-4319 Other Professional Services 0.00 3,993.55 8,816.01 0.00 ( 8,816.01)
221-9-5900-4321 Telephone 3,450.00 168.16 1,817.58 52.68 1,632.42
221-4-5400-4322 Postage 500.00 0.00 344.96 68.99 155.09
221-4-5400-4331 Travel, Conferences & Schools 1,000.00 737.00 873.39 87.34 126.61
221-4-5400-4359 Publishing 2,200.00 653.00 3,688.26 167.65 ( 1,488.26)
221-4-5400-4361 Insurance 8,350.00 0.00 3,614.50 43.29 4,735.50
221-4-5400-4389 Utilities 148,950.00 10,662.68 108,383.63 72.77 40,566.37
221-4-5400-4401 Bldg Repair/Maint Services 22,300.00 5,382.73 15,103.29 67.73 7,196.71
221-4-5400-4409 Contractual Services 1,200.00 280.00 1,737.84 144.82 ( 537.84)
221-4-5900-4915 Equipment Rental 2,800.00 0.00 1,367.29 48.83 1,432.71
221-4-5900-4433 Dues & Subscriptions 450.00 0.00 183.34 40.74 266.66
TOTAL Other Services & Charges 191,200.00 21,877.12 145,930.09 76.32 95,269.91
Capital Outlay
221-4-5400-4560 Equipment 44,400.00 9,447.20 40,916.89 92.16 3,483.11
TOTAL Capita l Outlay 44,400.00 4,447.20 40,916.89 92.16 3,483.11
Transfers Out
221-4-5400-4730 Transfer-Debt Service 200,800.00 0.00 15,390.00
TOTAL Transfers Out 200,800.00 0.00 15,390.00
7.66 185,410.00
7.66 185,410.00
TOTAL Ice Arena 756,500.00 53,311.78 442,186.89 58.45 314,313.11
11-17-2011 05:02 PM
221-ICE ARENA
Culture & Recreation
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED).
AS OF: OCTOBER 31ST, 2011
PAGE: 5
83.33$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Hockey
Personal Services
221-4-5410-4103 Part-time Pay 3,600.00 0.00 480.00 13.33 3,120.00
221-4-5410-4105 FICA 250.00 0.00 29.76 11.90 220.24
221-4-5910-4107 Medicare 50.00 0.00 6.96 13.92 43.04
TOTAL Personal Services 3,900.00 0.00 516.72 13.25 3,383.28
Supplies
221-4-5410-4219 Operating Supplies 14,050.00 0.00 6,668.85 97.97 7,381.15
TOTAL Supplies 14,050.00 0.00 6,668.85 97.47 7,381.15
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 86.90 3,065.00 47.89 3,335.00
221-4-5410-4438 Credit Card Fees 2,200.00 0.00 2,605.88 118.45 ( 405.88)
TOTAL Other Services & Charges 9,100.00 86.40 5,670.88 62.32 3,429.12
TOTAL Hockey 27,050.00 86.40 12,856.95 47.53 14,193.55
Skating
Personal Services
221-4-5420-9103 Part-time Pay 20,000.00 566.00 8,859.29 44.30 11,140.71
221-4-5420-9104 PERA 1,000.00 16.10 313.32 31.33 686.68
221-4-5420-4105 FICA 1,250.00 35.10 562.46 45.00 687.54
221-4-5420-4107 Medicare 300.00 8.22 131.58 43.86 168.42
TOTAL Personal Services 22,550.00 625.42 9,866.65 43.75 12,683.35
Supplies
221-4-5420-4219 Operating Supplies 5,500.00 0.00 3,858.44 70.15 1,641.56
TOTAL Supplies 5,500.00 0.00 3,858.44 70.15 1,641.56
Other Services & Charges
221-4-5420-4359 Publishing 650.00 0.00 318.49 99.00 331.51
221-4-5420-9409 Contractual Services 2,550.00 108.00 896.60 35.16 1,653.40
221-4-5420-4438 Credit Card Fees 2,800.00 176.49 1,619.48 57.84 1,180.52
TOTAL Other Services & Charges 6,000.00 284.49 2,834.57 47.24 3,165.43
I TOTAL Skating 34,050.00 909.91 16,559.66 48.63 17,490.34
11-17-2011 05:02 PM CITY OF ELK RIVER PAGE: 6
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
I 221-ICE ARENA
Culture & Recreation
~ DEPARTMENTAL EXPENDITURES
Arena Concessions
83.33$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE a OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
221-4-5430-4103 Part-time Pay 20,900.00 1,899.20 12,908.74 61.76 7,991.26
221-4-5430-4104 PERA 200.00 43.01 249.85 124.93 ( 49.85)
221-4-5430-4105 FICA 1,300.00 117.94 857.82 65.99 942.18
221-4-5430-4107 Medicare 300.00 27.46 200.63 66.88 99.37
TOTAL Personal Services 22,700.00 2,082.11 14,217.04 62.63 8,982.96
Supplies
221-4-5930-4219 Operating Supplies 3,550.00 5.34 994.83 28.02 2,555.17
221-4-5430-4259 Other Merchandise For Resale 21,000.00 3,157.30 16,242.85 77.35 4,757.15
TOTAL Supplies 24,550.00 3,162.64 17,237.68 70.21 7,312.32
~ TOTAL Arena Concessions
I TOTAL Culture & Recreation
47,250.00 5,249.75 31,954.72 66.57 15,795.28
864,850.00 59,552.84 503,057.72 58.17 361,792.28
1 TOTAL EXPENDITURES
864,850.00 59,552.84 503,057.72 58.17 361,792.28
REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 26,725.90)( 40,811.77) 40,811.77
11-17-2011 05:02 PM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
I 222-PINEWOOD GOLF COURSE
FINANCIAL SUMIviARY
CURRENT CURRENT
BUDGET PERIOD
83.33°s OF YEAR COMP.
YEAR TO DATE a OF BUDGET
ACTUAL BUDGET BALANCE
REVENUE SUMMARY
Pinewood Golf Course
TOTAL REVENUES
' EXPENDITURE SUMMARY
Culture & Recreation
Golf Course
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
249,550.00 9,456.00 168,467.99 67.51 81,082.06
249,550.00 9,456.00 168,467.94 67.51 81,082.06
249,550.00 16,635.55 197,294.71 79.06 52,255.29
249,550.00 16,635.55 197,294.71 79.06 52,255.29
249,550.00 16,635.55 197,294.71 79.06 52,255.29
0.00 ( 7,179.55)( 28,826.77) 28,826.77
11-17-2011 05:02 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
222-PINEWOOD GOLF COURSE
REVENUES
83.33$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ 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
222-3-0000-3629 Miscellaneous Revenue
TOTAL 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
17,000.00 0.00 16,974.50 99.85 25.50
19,000.00 1,063.33 19,730.89 77.53 9,269.11
5,000.00 134.59 3,935.28 68.71 1,564.72
100.00 0.00 0.00 0.00 loo.oo
120,000.00 5,396.00 90,838.75 75.70 29,161.25
14,000.00 0.00 16,740.03 119.57 ( 2,740.03)
18,500.00 1,428.50 19,799.50 107.02 ( 1,299.50)
7,000.00 1,436.08 5,204.68 74.35 1,795.32
200,600.00 9,458.50 167,723.63 83.61 32,876.37
0.00 0.00 400.00 0.00 ( 400.00)
0.00 0.00 400.00 0.00 ( 400.00)
0.00 ( 2.50) 349.31 0.00 ( 344.31)
0.00 ( 2.50) 344.31 0.00 ( 344.31)
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 9,456.00 168,467.94 67.51 81,082.06
TOTAL REVENUE 249,550.00 9,456.00 168,467.94 67.51 81,082.06
11-17-2011 05:02 PM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: OCTOBER 31ST, 2011
222-PINEWOOD GOLF COURSE
DEPARTMENTAL EXPENDITURES
CURRENT CURRENT
BUDGET PERIOD
83.33 OF YEAR COMP.
YEAR TO DATE °s OF BUDGET
ACTUAL BUDGET BALANCE
Golf Course
Personal Services
222-4-5300-4101 Regular Pay 93,650.00 7,113.84 71,123.03 75.95 22,526.97
222-4-5300-4103 Part-time Pay 29,900.00 2,098.40 27,437.33 91.76 2,462.67
222-4-5300-4104 PERA 8,950.00 626.02 6,369.63 71.17 2,580.37
222-4-5300-4105 FICA 7,650.00 565.36 6,222.77 81.34 1,927.23
222-4-5300-4107 Medicare 1,800.00 132.23 1,455.27 80.85 344.73
222-4-5300-4108 Insurance 10,150.00 458.01 9,580.10 45.12 5,569.90
222-4-5300-4109 Workers Comp 1,400.00 398.50 1,648.50 117.75 ( 248.50)
222-4-5300-9110 Re-employment Compensation 0.00 0.00 5,044.66 0.00 ( 5,044.66)
TOTAL Person al Services 153,500.00 11,392.36 123,881.29 80.70 29,618.71
Supplies
222-4-5300-4212 Fuels & Lubs 5,000.00 1,211.82 4,767.58 95.35 232.42
222-4-5300-4217 Uniform Allowance 500.00 0.00 413.40 82.68 86.60
222-4-5300-4219 Operating Supplies 30,400.00 1,681.88 28,357.93 93.28 2,042.07
222-4-5300-4259 Other Merchandise For Resale 19,500.00 296.77 7,901.46 54.49 6,598.54
TOTAL Suppli es 50,400.00 3,190.47 41,940.37 82.22 8,959.63
Other Services & Charges
222-4-5300-9321 Telephone 2,500.00 212.37 1,707.28 68.29 792.72
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 0.00 1,914.97 147.31 ( 619.97)
222-4-5300-9361 Insurance 11,900.00 0.00 5,296.50 44.51 6,603.50
222-4-5300-4389 Utilities 7,150.00 927.32 4,536.26 63.44 2,613.74
222-4-5300-4401 Bldg Repair/Maint Services 2,300.00 20.04 1,540.07 66.96 759.93
222-4-5300-4404 Equip Repair/Maint Services 3,000.00 4.00 2,241.08 74.70 758.92
222-4-5300-4415 Equipment Rental 2,000.00 48.29 1,501.15 75.06 498.85
222-4-5300-4937 Taxes & Licenses 1,000.00 417.40 124.00 12.40 876.00
222-4-5300-4438 Credit Card Fees 5,500.00 423.30 4,406.97 80.12 1,093.53
TOTAL Other Services & Charges 37,150.00 2,052.72 23,476.05 63.19 13,673.95
Capital Outlay
Debt Service
222-4-5300-4601 Principal 8,500.00 0.00 8,497.00 99.96 3.00
TOTAL Debt S ervice 8,500.00 0.00 8,497.00 99.96 3.00
~ TOTAL Golf Course
~ TOTAL Culture & Recreation
~ TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
249,550.00 16,635.55 197,294.71 79.06 52,255.29
249,550.00 16,635.55 197,294.71 79.06 52,255.29
249,550.00 16,635.55 197,299.71 79.06 52,255.29
0.00 ( 7,179.55)( 28,826.77) 28,826.77
INFORMATION
H .~ ~ .-. .~ ~ II
m H O 01 M O M 01 O Ifl M d~ N M lfl Q~ N M H H M T O M lp r r m a' 01 O 0~ N N O O N II
O H l0 lI)
d' c r lf) r to O~ M M N O r M O O r N 0 0~ 01 l0 M O d' d' lp N Ifl M m O O M r r C tD II lfl d' l11 lD
F W
'7-. U II
~ N l0 M m tp r lfl d' l0 M lp 0~ H m H d' H H d' r N U1 N to N lD m M 0~ 01 lfl r O O r o II
d' M O~ O
W W ~j- O r C lD O r m M M H r 01 H H M m C H U1 lp d' m N C r l0 01 10 m tp ~ M C H 01 1p H II r lfl m H
C~ a FL d' ~O ~O m M m l0 f-I l0 M ~ W C Ifl m r .-1 W rl N H .-I C' M CO .-1 O m N M l0 N lf1 r-I .-I M II r l0 rl M
a
(y '.7 ~ II
l0 ~~ r lp 01 lp N N N 01 ~p N N ~0 d' C q' M O d' N O r H r C N M Ifl 0~ tD ~ N H II
O~ O N H
U 0.l M d' H to N H O 0~ O~ H 0~ r M N H d' H 1p r r r N In N O O H H d' r r H 1f1 01 II lf) Ifl m 0~
~p d~ H O~ l0 H M M N M tI) H Ifl H N M O~ N M O H N H lfl r d' lf1 01 II
_ _ II O~ M T
_ _ _
_ _ _ _ _
M H H lp H d' d' H H d' H 10 II r m m ip
M I I N H N M
m O~ m 01 If1 O M M l0 O r to lfl d' 01 m m N C lD H O N N O r H O r H N M~ In O O II N H O O
r d~ d' M r M O UI M H C ~D M l11 m d' r N 01 L(1 H O O O~ N d' m H O M H l0 N N ~O O 01 II 0~ O~ O 0~
F >I n
'
z F N N r 10 N cM O 0~ t!1 r H N O O~ N d' ~0 N l0 O 0~ 0~ O N Ifl O d' N O m O N H N O O N II r O N
d
W H
a~ d~ r [r H 01 O H O lD m m M 1p N M I cr lD M r r H r 0 Ol N 01 N H Ul N H m II
O r d' N N t!1 Ifl r M Ol l0 0~ O r d' .-1 In M O H M N N sT d' H Ol Lfl N If1 0~ N d' II r 0 m
r r d'
a H
'.7 F _ _ _ _ _ _ _ _ _ _ _ _ II
M N M m r M Ifl 0~ O M m H H H C m d' m H ~0 r M m i0 Ifl II _ _
O~ O Lfl
U U lD M N H N O N H Ul Ifl N M II i0 r M
~ ~ In io II
n
,~ a m r ~o
.-~
n
o H c .~ a In m N r m M r r m m m c vl M r r m o In m r o r a io rn r m .~ In o In n
m o ~o In
U r m H N~ m O~ Ot 0~ O ip O ~0 lIl m N d' d' m M~ M O M ~p N O q' M N m C' Ul 0 0 d' Ul II
I d' N IP Ifl
,
2 W
H U I
M C d' r lfl O r d' m 01 H d' T O O l0 r m m d' m M Ifl m O N N M M m m 0~ m M O r M II O~ Ifl O'~ M
H ,7. tp <M O~ C r-V W W ifl N C ~ ti C m lp ri O~ i0 H M ~p O N If1 V1 ~D O C ro l0 ~ r Ifl l0 r r 0~ II C d' ro i ~
~
H 'jy M y~ O l0 O M lp 1D O~ 0~ C' N ~'1 Ifl N N 0~ N lf1 N O~ m y~ U1 d' f ~ r N m O V' O N M r II Ifl 6~ .-I ~ r
01 O H
0~ N C7 ~ _ _ _ _ _ _ ~ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ II
M N M O~ 0~ O lp Ifl H lD 01 l0 l0 O m N M M M 0~ O~ H m m lp m M N O N t0 O O H lO II
d' O~ N ~D
01 W (A M H N H H H H O O~ m O r m lp N H d' H lp \O lp r N lfl H r O H M ~ M M H m N II N r m N
a p7 lp ci, H 0~ tp H M M N M 1f1 H lf) H N M d' N M O~ H N H Ifl m Lfl lfl lp II ~ l0 M lp
W ~ F
> m _ _ _ _ _ _ _ II
a H H io ~ In w H a~ m II _ _ _
r r m m
H H II N .a N M
a w M
v `- ~ .. .~ - u
a
x F w
a a w
w o 0
w F
wao +~
0
b v
>
cxn .. +~
m
v
N ~•1 ll > C > W ~ C a.l
>~ ~ w m s+ v ~+ o .+ rn .+ v rn G
Fuo ~~ A m v v ma,~ ro,J s ~ v
H
U Q c/l 7 U) N N> u! G C D v C H E
O~ q T1 a~ 1a W a ?G N ro U rJ .~ +-1 3
W FC U O C 'd v v a E H E~ .k rd C N ?~ ro O x
a >, v ro~ m v w H w v a H v E ro v s,
ro ro b > >a ~ a E~ 3 ~+ v
w u° m~ w ro v v~ > m cn
m F a
°o ,
b .-+ rC u a w .H v a ,~ ro C a G a >J o v >~ v v v rn c F v F z u
a ~ a o rt o r, „ a .+ a v o 0 o ro w ~, ,~ F a ~> a rn w ~
~
N C C7 C U U C C 7 W N > pl W W U N a N C O ~.+ .,~ fa ~
q
w ~+ w ro v ~+ m a v o v rn w v ~+ w E 3 v ,J v ~, x x v sa
a ro N 'CJ H H o ro E u b s, u v o 0 0 o H ro c > a u v o F w
u o cn a
C H >, 4J 0 ~.~ v ~-+ .H a o a ~-+ C ~-+ O C~ O O O O~ v .,~ O 1 E~~ ro v a U u W 0
o ro S I La O a~ Q .I .I a O ro ro fA w ro v H +-+ u 3 E H .~ H 3 YI Ln o FC U~ O
z .+ s, ro Q 3 ~+ w w o H ,~ s, N a rs Q u 4 a v ro a b u xs v O ro .-+ 1 a
a~ N H N U ~G 'L5 'd }-1 q N -.+ C rJ Q~ N Ifl r o N >. ~-I 2 Sa X a, C .O N
U C A N C ~+ g C U W> a U1 > C> W o 0 o H w S~ 1+ a~ a U M N w w v~ O' ~+ > x
Ul x H
x
~
~ ``
N w .,~ U ~-+ >a ro rt ro ~~+ F N ro C O H v a o 0 0 o H a~ C ~.~ b" g m ro H H ro .ti N N
7 U q
U W >+ H a F F~
F Vl [
'
' 1
U q
jjam~
W /j W
'k
n
i-
Q cn C
1 N N N N
!/~ (7 .] H W U7 a s i-7 £ Q Q U H U !
a o
q
a a a °
w
~ ~ ~ .a .~ .c ~ c c .a ~ c .a ~ c ~ ~ ~ .a .a c ~ c c n .a c .a .c ~ ~ .a c c c ~ >~ c x a
'
G4 Vl N U1 N N VI N Vl UI UJ W N U1 N N N Ul W 11 W UI Ul N N N to N W N Ul N N UI N Ul N ~V[j O
° Z.
Oi U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U U V 0.
i
,~ x
u
m
w
P °
£ x
z o H N u
o 0 0
°
U H FC
o 0 0 l
,~
-+ U o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o a] H H H 1
.
O U .7, ,-~ H H H H H H H H H H H H H H H H H H H H H H H H H .-+ H H .-1 H H H ,-+ H H i i I F
N FC O O O O O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 U 'Z m m~ 0
H H H H H H H H H H H H H ry H H H H H H H H H H H H H H r1 H H H H H H H
a
H H Ol Ol Ol F
m m m W
'
H
~ N H H H N M 1f1 m H O H Ifl O H N C to O H N M M Ifl M d' ~D O ~p r O l0 0~ N M to H ~(
f~ O O H N N N N N M d' d~ d' O~ 0~ 0~ O~ 01 O~ .-1 .-I H M r 0 0 0 H N N C Ifl Lfl O P O N F ~
t17 J
~ V1
H a O H N N N N N N N N N N N N N N N N M M M M M d~ d' C d' C d' d' d' C l9 tp ~O m 0 U
H w U