INFORMATION 08-15-2011tNFt~RMA'Tlt'~N
ver
MEMORANDUM
TO: Mayor and City Council
FROM: Tim Simon, Finance Director
DATE: August 15, 2011
SUBJECT: July 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 July, actual revenues (except for property taxes and state aids) and
expenditures should run about 58% of the annual budget. It is natural for some of the items
to vary from month to month, such as exceeding budget fox 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
Revenuer:
• Excluding transfers in, revenue collections are 54% of budget. The remaining first
half property taxes were received in July and collections are at 48%.
• License and permit collections exceed the annual budget at 124%.
• Charges for services axe over 71% of budget due to the second half billing of the
police and fire contracts.
• Intergovernmental revenues and fines and forfeits are within budget estimates.
• Transfers in are reflected in the July report.
E.xpenditure.r:
• Excluding transfers out, the total departmental expenditures are about 51% of
budget estimates and most departments are well within or below budget.
• The Administrative Services expenditures are at 74% of budget due to the severance
payout.
• The Finance expenditures are slightly over the budget benchmark at 61 % due to the
final payment of the annual audit contract.
• The Police Reserve expenditures at 66% of budget reflect the increase in personal
services used to fill in for the community service officer.
• The Emergency Management expenditures are slightly below 67% and include the
capital outlay purchase of the warning siren upgrades.
• Recreation Program expenditures exceed the budget benchmark at 68% due to the
extent of the programs offered during the summer.
• 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 July, revenues exceed expenditures by $21,290. Excluding transfers in,
revenue collections of $380,686 axe 54% of budget and expenditures of $359,396 axe 42% of
budget.
Pinewood Golf
For the month ended July, expenditures exceed revenues by $10,681 due to the hot humid
weather conditions this summer. Excluding transfers in, golf revenues collected through
July of $112,810 account for about 56% of budget estimates and expenditures of $123,491
are about 49% of budget.
8-10-2011 07:57 AM
I 101-GENERAL FUND
FINANCIAL SUMMARY
CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
56.33 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE °s OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
I REVENUE SUMMARY
General Fund
TOTAL REVENUES
' EXPENDITURE SUMMARY
General Government
Mayor & Council
Cable TV
Administrative Services
Human Resources
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 2,291,929.76 6,867,557.21 56.46 5,295,892.79
12,163,450.00 2,291,924.76 6,867,557.21 56.46 5,295,892.79
177,800.00 6,608.47 76,377.99 42.96 101,422.01
77,800.00 5,965.29 40,445.05 51.99 37,359.95
473,650.00 85,375.92 350,164.14 73.93 123,985.86
150,750.00 11,384.55 83,525.54 55.91 67,224.46
454,700.00 33,181.21 277,700.04 61.07 176,999.96
266,600.00 13,347.61 127,280.09 47.74 139,319.91
240,000.00 14,043.00 128,499.21 53.54 111,500.79
67,100.00 5,130.65 36,804.48 54.85 30,295.52
303,550.00 21,895.35 158,796.70 52.31 144,753.30
300,850.00 18,886.67 138,753.98 46.12 162,096.02
75,000.00 2,698.29 2,698.29 3.60 72,301.71
2,587,800.00 218,517.01 1,421,045.51 54.91 1,166,754.49
563,800.00 30,258.49 307,310.75 54.51 256,489.25
2,252,800.00 162,932.49 1,102,419.08 48.94 1,150,380.92
752,450.00 55,398.78 358,501.52 47.64 393,948.48
491,700.00 30,950.40 251,804.06 51.21 239,895.94
22,900.00 3,916.84 15,235.89 66.53 7,664.16
205,000.00 12,903.07 99,305.16 48.44 105,694.89
589,600.00 78,255.51 334,114.24 56.67 255,485.76
184,850.00 14,082.66 97,126.37 52.54 87,723.63
107,400.00 53,056.17 73,819.34 68.73 33,580.66
465,200.00 35,350.94 250,471.71 53.84 214,728.29
56,950.00 4,001.89 29,422.29 51.66 27,527.71
5,692,650.00 481,107.24 2,919,530.36 51.29 2,773,119.64
1,524,450.00 102,925.16 565,391.61 37.09 959,058.39
262,850.00 55.41 195,530.51 74.39 67,319.49
245,950.00 16,569.85 117,793.16 47.89 128,156.84
177,800.00 8,931.54 63,340.17 35.62 119,459.83
2,211,050.00 128,481.96 992,055.95 42.61 1,268,994.55
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
I 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
58.33°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
790,350.00 73,822.40 413,278.70 52.29 377,071.30
550,300.00 34,636.47 250,912.48 45.60 299,387.52
192,500.00 45,394.53 130,957.07 68.03 61,542.93
14,100.00 1,300.24 4,754.35 33.72 9,345.65
204,450.00 14,977.12 103,767.53 50.75 100,682.97
1,751,700.00 172,630.76 903,670.13 51.59 848,029.87
0..00 8,988.77 19,798.09 0.00 ( 19,798.09)
51,650.00 2,778.84 22,106.82 42.80 29,593.18
51,650.00 11,767.61 41,904.91 81.13 9,745.09
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,012,509.58 6,228,206.36 49.83 6,271,843.64
( 336,600.00) 1,279,420.18 639,350.85 ( 975,950.85)
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
101-GENERAL FUND
REVENUES
General Fund
Taxes
101-3-0000-3111 Current Ad Valorem Taxes
101-3-0000-3112 Delinquent Ad Valorem Taxes
101-3-0000-3119 MV Reduction
101-3-0000-3121 Gravel Tax
101-3-0000-3123 Franchise Tax
101-3-0000-3131 Penalties/Interest
TOTAL Taxes
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-Op00-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
CURRENT
BUDGET
9,758,500.00
0.00
( 221,100.00)
75,000.00
0.00
9,612,400.00
53,000.00
1,000.00
3,000.00
16,000.00
20,000.00
4,000.00
14,000.00
2,500.00
100,000.00
25,000.00
200.00
0.00
3,000.00
3,000.00
8,000.00
252,700.00
4,000.00
14,000.00
205,000.00
12,000.00
254,050.00
35,000.00
4,000.00
0.00
528,050.00
CURRENT
PERIOD
58.33% OF YEAR COMP.
YEAR TO DATE °s OF BUDGET
ACTUAL BUDGET BALANCE
1,434,547.99 4,707,883.07
156,308.66 156,308.66
0.00 0.00
0.00 9,867.14
0.00 45,338.42
14,325.99 14,325.99
1,605,182.64 4,928,723.28
48.29 5,050,616.93
0.00 ( 156,308.66)
0.00 ( 221,100.00)
6.49 70,132.86
0.00 ( 45,338.42)
0.00 ( 14,325.99)
51.27 4,683,676.72
80.00 54,895.00 103.58 ( 1,895.00)
0.00 195.00 19.50 805.00
0.00 112.50 3.75 2,887.50
675.00 20,115.00 125.72 ( 4,115.00)
0.00 20,805.25 104.03 ( 805.25)
0.00 555.00 13.88 3,945.00
20.00) 7,745.00 55.32 6,255.00
40.00 915.00 36.60 1,585.00
11,319.06 85,337.81 85.34 14,662.19
6,928.52 110,389.29 441.56 ( 85,389.29)
1,102.29) 2,210.58 1,105.29 ( 2,010.58)
1,050.00 1,050.00 0.00 ( 1,050.00)
700.00 4,220.00 140.67 ( 1,220.00)
0.00 411.70 13.72 2,588.30
510.00 4,565.00 57.06 3,435.00
20,180.29 313,522.13 124.07 ( 60,822.13)
322.00 1,507.25 37.68 2,492.75
0.00 0.00 0.00 14,000.00
0.00 0.00 0.00 205,000.00
0.00 0.00 0.00 12,000.00
0.00 275,485.11 108.44 ( 21,435.11)
0.00 4,101.74 11.72 30,898.26
0.00 0.00 0.00 4,000.00
23,902.95 29,027.95 0.00 ( 29,027.95)
24,224.95 310,122.05 58.73 217,927.95
Char ges for Services
101- 3-0000-3412 Planning & Zoning Fees 15,000.00 1,555.00 8,505.00 56.70 6,495.00
101- 3-0000-3413 Plan Check Fee 30,000.00 2,378.00 22,484.98 74.95 7,515.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 173.25 1,535.12 102.34 ( 35.12)
101- 3-0000-3418 Other General Govt Services 4,000.00 358.75 1,.993.26 49.83 2,006.74
101- 3-0000-3430 Lockout Fees 7,500.00 520.00 4,585.00 61.13 2,915.00
8-10-2011 07:57 AM
~ 101-GENERAL FUND
1 REVENUES
58.33 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE g OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
101-3-0000-3431 Police Services
101-3-0000-3932 School Liaison
101-3-0000-3434 Animal Impound Fee
101-3-0000-3436 Fire Contracts
101-3-0000-3437 Fire Calls
101-3-0000-3951 Street Services
101-3-0000-3452 Engineering Services Reimb
101-3-0000-3461 Recreation Fees
101-3-0000-3467 Concessions
101-3-0000-3472 Park Use Fee
101-3-0000-3474 Facility Use Fee
101-3-0000-3475 Building Rent
101-3-0000-3483 Sewer Inspection Fee
101-3-0000-3484 Contractor License Check
TOTAL Charges for Services
I Fines & Forfeits
I 101-3-0000-3510 Court Fines
101-3-0000-3511 Parking Fines
TOTAL Fines & Forfeits
' Special Assessments
Other Revenue
101-3-0000-3621 Interest Income
101-3-0000-3625 Refunds & Reimbursements
101-3-0000-3626 Contributions
101-3-0000-3629 Miscellaneous Revenue
TOTAL Other Revenue
Transfers In
101-3-0000-3925 Transfer-Landfill
101-3-0000-3929 Transfer-NSP/RDF Reserve
101-3-0000-3942 Transfer-WWTS
101-3-0000-3943 Transfer-Liquor
101-3-0000-3944 Transfer-Garbage
101-3-0000-3945 Transfer-Utilities
101-3-0000-3948 Transfer-EDA
101-3-0000-3949 Transfer-HRA
TOTAL Transfers In
TOTAL General Fund
~ TOTAL REVENUE
CITY OF ELK RIVER PAGE: 4
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
2,000.00 580.00 1,326.50 66.33
75,000.00 37,500.00 75,000.00 100.00
3,000.00 525.00 2,150.00 71.67
194,000.00 84,902.72 193,403.44 99.69
4,000.00 0.00 0.00 0.00
30,000.00 400.00 8,806.71 29.36
99,100.00 9,419.52 21,121.56 21.31
123,000.00 2,658.00 94,734.43 77.02
14,100.00 1,641.25 3,823.22 27.12
18,000.00 540.00 12,476.25 69.31
6,200.00 ( 207.50) 2,035.43 32.83
13,200.00 650.00 4,100.00 31.06
2,500.00 395.00 1,370.00 54.80
400.00 45.00 235.00 58.75
643,100.00 144,033.99 460,285.90 71.57
182,814.10
120,000.00 8,526.54 60,094.36 50.08 59,905.64
10,000.00 300.00 13,445.50 134.46 ( 3,445.50)
130,000.00 8,826.54 73,539.86 56.57 56,460.14
120,000.00 0.00 20,726.57 17.27 99,273.43
65,000.00 ( 137.17) 888.36 1.37 64,111.64
23,700.00 7,079.50 10,289.50 43.42 13,410.50
4,000.00 2,554.02 4,959.58 123.99 ( 959.58)
212,700.00 9,496.35 36,864.01 17.33 175,835.99
35,000.00 35,000.00 35,000.00 100.00 0.00
39,500.00 39,500.00 39,500.00 100.00 0.00
75,000.00 75,000.00 75,000.00 100.00 0.00
270,000.00 270,000.00 270,000.00 100.00 0.00
25,000.00 25,000.00 25,000.00 100.00 0.00
300,000.00 35,980.00 299,999.98 100.00 0.02
25,000.00 0.00 0.00 0.00 25,000.00
15,000.00 0.00 0.00 0.00 15,000.00
784,500.00 479,980.00 749,499.98 94.90 40,000.02
12,163,450.00 2,291,924.76 6,867,557.21 56.46 5,295,892.79
12,163,450.00 2,291,924.76 6,867,557.21 56.46 5,295,892.79
673.50
0.00
850.00
596.56
4,000.00
21,193.29
77,978.44
28,265.57
10,276.78
5,523.75
4,164.57
9,100.00
1,130.00
165.00
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 5
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
1 101-GENERAL FUND
I DEPARTMENTAL EXPENDITURES
58.33 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE a OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Mayor & Council
Personal Services
101-4-1110-4103 Part-time Pay
101-4-1110-4104 PERA
101-4-1110-4105 FICA
101-4-1110-4107 Medicare
101-4-1110-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-1110-4201 Office Supplies
TOTAL Supplies
Other Services & Charges
101-4-1110-9319 Other Professional Services
101-4-1110-4322 Postage
101-4-1110-4331 Travel, Conferences & Schools
101-4-1110-4359 Publishing
101-4-1110-4361 Insurance
101-4-1110-4433 Dues & Subscriptions
101-4-1110-4440 Miscellaneous
TOTAL Other Services & Charges
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-9201 Office Supplies
TOTAL Supplies
38,500.00 2,101.96 22,300.84 57.92 16,199.16
1,900.00 100.01 702.47 36.97 1,197.53
2,400.00 111.09 836.43 39.85 1,563.57
550.00 46.53 339.39 61.71 210.61
50.00 0.00 109.75 219.50 ( 59.75)
43,400.00 2,359.59 24,288.88 55.97 19,111.12
3,400.00 0.00 456.72 13.43 2,943.28
3,400.00 0.00 456.72 13.43 2,943.28
11,050.00 1,192.70 4,849.56 43.89 6,200.44
400.00 0.00 289.64 72.41 110.36
2,600.00 40.00 564.49 21.71 2,035.51
17,700.00 2,856.28 8,945.57 50.54 8,754.43
74,800.00 0.00 32,271.50 43.14 42,528.50
16,000.00 0.00 500.00 3.13 15,500.00
8,450.00 159.90 4,211.63 49.84 4,238.37
131,000.00 4,248.88 51,632.39 39.41 79,367.61
177,800.00 6,608.47 76,377.99 42.96 101,422.01
54,150.00 4,173.16 28,672.36 52.95 25,477.64
6,500.00 390.63 2,031.27 31.25 4,468.73
3,950.00 302.56 2,226.82 56.38 1,723.18
3,750.00 258.42 1,863.88 49.70 1,886.12
900.00 60.44 435.87 48.43 464.13
5,800.00 670.00 4,690.00 80.86 1,110.00
200.00 0.00 97.50 98.75 102.50
75,250.00 5,855.21 40,017.70 53.18 35,232.30
700.00 110.08 384.00 54.86 316.00
700.00 110.08 384.00 54.86 316.00
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 6
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
I 101-GENERAL FUND
General Government
I DEPARTMENTAL EXPENDITURES
58.33°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Other Services & Charges
101-4-1120-9322 Postage 50.00 0.00 0.00 0.00 50.00
101-4-1120-4331 Travel, Conferences & Schools 1,650.00 0.00 93.35 2.63 1,606.65
101-4-1120-4404 Equip Repair/Maint Services 150.00 0.00 0.00 0.00 150.00
TOTAL Other Services & Charges 1,850.00 0.00 43.35 2.34 1,806.65
Capital Outlay
TOTAL Cable TV 77,800.00 5,965.29 40,445.05 51.99 37,354.95
Administrative Services
Personal Services
101-4-1210-4101 Regular Pay 296,450.00 75,687.53 262,682.54 88.61 33,767.46
101-4-1210-4103 Part-time Pay 49,900.00 2,839.78 20,101.24 44.77 24,798.76
101-4-1210-4104 PERA 24,750.00 1,194.89 12,975.94 52.43 11,774.06
101-4-1210-4105 FICA 21,150.00 1,155.20 14,398.70 68.08 6,751.30
101-4-1210-4106 Other Retirement Contributions 4,800.00 0.00 2,400.00 50.00 2,400.00
101-4-1210-4107 Medicare 4,950.00 1,133.46 4,237.72 85.61 712.28
101-4-1210-4108 Insurance 28,500.00 1,402.01 14,002.13 49.13 14,497.87
101-4-1210-4109 Workers Comp 1,800.00 0.00 1,428.75 79.38 371.25
TOTAL Personal Services 427,300.00 83,407.87 332,227.02 77.75 95,072.98
Supplies
101-4-1210-4201 Office Supplies 9,500.00 572.79 2,040.34 21.48 7,459.66
TOTAL Supplies 9,500.00 572.79 2,040.34 21.48 7,459.66
Other Services & Charges
101-4-1210-4319 Other Professional Services 5,500.00 0.00 5,328.00 96.87 172.00
101-4-1210-4321 Telephone 800.00 4.28 265.61 33.20 539.39
101-4-1210-4322 Postage 1,000.00. 0.00 242.74 24.27 757.26
101-4-1210-4331 Travel, Conferences & Schools 5,300.00 292.05 939.82 17.73 9,360.18
101-9-1210-4361 Insurance 100.00 0.00 147.50 147.50 ( 47.50)
101-4-1210-4904 Equip Repair/Maint Services 23,050.00 1,098.93 8,468.11 36.74 14,581.89
.101-4-1210-4433 Dues & Subscriptions 1,100.00 0.00 505.00 45.91 595.00
TOTAL Other Services & Charges 36,850.00 1,395.26 15,896.78 43.14 20,953.22
Capital Outlay
TOTAL Administrative Services 473,650.00 85,375.92 350,169.14 73.93 123,485.86
1 8-10-2011 07:57 AM
I 101-GENERAL FUND
General Government
1 DEPARTMENTAL EXPENDITURES
1 Human Resources
CITY OF ELK RIVER PAGE: 7
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
58.33$ OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ° OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
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-4-1220-4331 Travel, Conferences & Schools
101-4-1220-4433 Dues & Subscriptions
101-4-1220-4440 Miscellaneous
TOTAL Other Services & Charges
Capital Outlay
67,850.00 5,219.24 36,799.54 59.24 31,050.46
48,350.00 3,531.52 25,653.22 53.06 22,696.78
8,450.00 634.44 4,877.10 57.72 3,572.90
7,200.00 527.13 3,955.11 54.93 3,244.89
1,700.00 123.28 924.92 54.41 775.08
5,800.00 1,234.01 7,085.06 122.16 ( 1,285.06)
600.00 0.00 478.00 79.67 122.00
139,950.00 11,269.62 79,772.95 57.00 60,177.05
3,200.00 49.22 2,200.58 68.77 999.42
3,200.00 49.22 2,200.58 68.77 999.42
3,000.00 0.00 311.25 10.38 2,688.75
350.00 0.61 564.70 161.34 ( 214.70)
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 65.10 465.00 46.50 535.00
7,600.00 65.71 1,552.01 20.42 6,047.99
TOTAL Human Resources
Elections
Supplies
Other Services & Charges
Capital Outlay
150,750.00 11,384.55 83,525.54 55.41 67,224.46
~ Finance
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 8
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
I 101-GENERAL FUND
General Government
CURRENT
BUDGET
CURRENT YEAR TO DATE
PERIOD ACTUAL
58.33 OF YEAR COMP.
o OF BUDGET
BUDGET BALANCE
~ DEPARTMENTAL EXPENDITURES
Personal Services
101-4-1310-4101 Regular Pay
101-4-1310-4104 PERA
101-4-1310-9105 FICA
101-9-1310-4107 Medicare
101-4-1310-4108 Insurance
101-4-1310-9109 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-9322 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.37 154,975.57 53.85 132,824.43
20,850.00 1,605.10 12,038.25 57.74 8,811.75
17,850.00 1,290.78 9,720.55 54.46 8,129.45
4,200.00 301.86 2,273.25 54.13 1,926.75
25,850.00 2,100.01 14,700.07 56.87 11,149.93
1,500.00 0.00 1,191.25 79.42 308.75
358,050.00 27,437.12 199,898.94 54.43 163,151.06
3,850.00 100.83 1,259.09 32.70 2,590.91
3,850.00 100.83 1,259.09 32.70 2,590.91
18,300.00 4,530.00 18,030.00 98.52 270.00
53,500.00 0.00 48,816.50 91.25 4,683.50
800.00 1.53 244.97 30.62 555.03
3,600.00 18.30 983.26 27.31 2,616.74
2,500.00 0.43 477.00 19.08 2,023.00
1,300.00 450.00 450.00 34.62 850.00
11,300.00 138.00 11,254.28 99.60 45.72
1,500.00 505.00 1,240.00 82.67 260.00
0.00 0.00 46.00 0.00 ( 96.00)
92,800.00 5,643.26 81,542.01 87.87 11,257.99
TOTAL Finance
Information Technology
Personal Services
101-4-1350-9101 Regular Pay
101-9-1350-4103 Part-time Pay
101-4-1350-9104 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
Supplies
101-4-1350-4219 Operating Supplies
TOTAL Supplies
954,700.00 33,181.21 277,700.04 61.07 176,999.96
128,400.00 9,875.45 69,128.15 53.84 59,271.85
5,000.00 0.00 1,000.00 20.00 4,000.00
9,300.00 715.98 5,369.85 57.74 3,930.15
8,250.00 546.88 4,293.55 52.04 3,956.45
1,950.00 127.90 1,004.15 51.49 945.85
19,850.00 1,626.01 11,382.07 57.34 8,467.93
650.00 0.00 562.50 86.54 87.50
173,400.00 12,892:22 92,740.27 53.48 80,659.73
25,100.00 386.11 9,688.92 18.68 20,411.08
25,100.00 386.11 4,688.92 18.68 20,411.08
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 9
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
I 101-GENERAL FUND
General Government
I DEPARTMENTAL EXPENDITURES
58.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-9321 Telephone 1,450.00 69.28 400.03 27.59 1,049.97
101-9-1350-4331 Travel, Conferences & Schools 8,000.00 0.00 183.72 2.30 7,816.28
101-4-1350-4404 Equip Repair/Maint Services 19,750.00 0.00 8,073.25 40.88 11,676.75
TOTAL Other Services & Charges 37,200.00 69.28 8,717.00 23.43 28,983.00
Capital Outlay
101-4-1350-4560 Equipment 30,900.00 0.00 21,133.90 68.39 9,766.10
TOTAL Capital 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 13,347.61 127,280.09 47.74 139,319.91
240,000.00 14,043.00 128,499.21 53.54 111,500.79
240,000.00 14,043.00 128,499.21 53.54 111,500.79
TOTAL Legal
Community Development
Personal Services
101-4-1500-4101 Regular Pay
101-4-1500-9104 PERA
101-4-1500-4105 FICA
101-9-1500-4107 Medicare
101-4-1500-4108 Insurance
101-4-1500-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-1500-9201 Office Supplies
TOTAL Supplies
240,000.00 14,043.00 128,499.21 53.54 111,500.79
52,700.00 4,052.81 28,369.67 53.83 24,330.33
3,800.00 293.82 2,203.65 57.99 1,596.35
3,250.00 241.54 1,816.42 55.89 1,433.58
750.00 56.48 429.74 56.63 325.26
5,800.00 486.00 3,402.00 58.66 2,398.00
250.00 0.00 588.00 235.20 ( 338.00)
66,550.00 5,130.65 36,804.48 55.30 29,745.52
150.00 0.00 0.00 0.00 150.00
150.00 0.00 0.00 0.00 150.00
8-10-2011 07:57 AM
101-GENERAL FUND
General Government
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
PAGE: 10
58.33 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Other Services & Charges
101-4-1500-4331 Travel, Conferences & Schools
TOTAL Other Services & Charges
400.00
400.00
0.00
0.00
0.00
0.00
0.00
0.00
900.00
400.00
TOTAL Community Development 67,100.00 5,130.65 36,804.48 59.85 30,295.52
Planning
Personal Services
101-4-1510-4101 Regular Pay 211,900.00 16,301.70 114,111.82 53.85 97,788.18
101-4-1510-4104 PERA 15,350.00 1,181.88 8,864.10 57.75 6,485.90
101-4-1510-4105 FICA 13,150.00 922.90 6,965.66 52.97 6,184.34
101-4-1510-4107 Medicare 3,100.00 215.84 1,629.07 52.55 1,470.93
101-4-1510-4108 Insurance 28,300.00 2,324.03 16,268.21 57.48 12,031.79
101-9-1510-4109 Workers Comp 700.00 0.00 858.50 122.64 ( 158.50)
TOTAL Personal Services 272,500.00 20,946.35 148,697.36 54.57 123,802.64
Supplies
101-4-1510-4201 Office Supplies 4,750.00 73.54 1,757.11 36.99 2,992.89
101-4-1510-4212 Fuels & Lubs 1,850.00 190.19 996.35 53.86 853.65
101-4-1510-4219 Operating Supplies 0.00 0.00 175.00 0.00 ( 175.00)
TOTAL Supplies 6,600.00 263.73 2,928.46 44.37 3,671.54
Other Services & Charges
101-4-1510-4321 Telephone 1,150.00 ( 28.05) 251.76 21.89 898.24
101-4-1510-4322 Postage 3,200.00 0.00 800.89 25.03 2,399.11
101-4-1510-4331 Travel, Conferences & Schools 3,000.00 5.00 934.00 31.13 2,066.00
101-4-1510-4359 Publishing 8,000.00 277.50 1,698.25 21.23 6,301.75
101-4-1510-4361 Insurance 400.00 0.00 207.00 51.75 193.00
101-4-1510-4404 Equip Repair/Maint Services 6,900.00 360.86 2,126.06 30.81 4,773.94
101-4-1510-4433 Dues & Subscriptions 1,000.00 0.00 545.00 54.50 955.00
101-4-1510-4440 Miscellaneous 0.00 3.30 141.30 0.00 ( 141.30)
101-4-1510-4460 Equip Replacement Charge 800.00 66.66 466.62 58.33 333.38
TOTAL Other Services & Charges 24,450.00 685.27 7,170.88 29.33 17,279.12
Capital Outlay
TOTAL Planning 303,550.00 21,895.35 158,796.70 52.31 144,753.30
City Hall Maintenance
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 11
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
I 101-GENERAL FUND
General Government
I DEPARTMENTAL EXPENDITURES
CURRENT CURRENT YEAR TO DATE
BUDGET PERIOD ACTUAL
58.33°s OF YEAR COMP.
o OF BUDGET
BUDGET BALANCE
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
i01-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-9-1600-4389 Utilities
101-4-1600-4401 Bldg Repair/Maint Services
101-4-1600-4404 Equip Repair/Maint Services
101-4-1600-4960 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
TOTAL City Hall Maintenance
Contingency
Other Services & Charges
101-4-1900-4490 Miscellaneous
TOTAL Other Services & Charges
104,350.00 8,053.66 55,036.22 52.74 49,313.78
2,500.00 0.00 0.00 0.00 2,500.00
19,050.00 2,194.80 9,881.16 51.87 9,168.84
9,150.00 673.01 5,009.96 54.75 9,140.04
7,800.00 631.28 4,389.55 56.28 3,410.45
1,800.00 14.7.64 1,026.66 57.04 773.34
17,200.00 1,242.73 8,994.66 52.29 8,205.34
5,850.00 0.00 3,687.00 63.03 2,163.00
167,700.00 12,993.12 88,025.21 52.49 79,674.79
3,450.00 319.61 1,561.74 45.27 1,888.26
1,700.00 127.75 759.44 44.67 940.56
28,900.00 1,425.10 11,716.88 40.54 17,183.12
34,050.00 1,867.46 14,038.06 41.23 20,011.94
12,250.00 414.38 6,211.10 50.70 6,038.90
1,500.00 0.00 733.20 48.88 766.80
4,850.00 0.00 2,372.50 48.92 2,977.50
43,800.00 1,953.71 19,131.71 43.68 24,668.29
30,600.00 1,616.33 7,287.97 23.82 23,312.03
5,000.00 0.00 312.54 6.25 4,687.46
1,100.00 91.67 641.69 58.34 958.31
99,100.00 4,076.09 36,690.71 37.02 62,409.29
300,850.00 18,886.67 138,753.98 46.12 162,096.02
75,000.00 2,698.29 2,698.29 3.60 72,301.71
75,000.00 2,698.29 2,698.29 3.60 72,301.71
TOTAL Contingency 75,000.00 2,698.29 2,698.29 3.60 72,301.71
TOTAL General Government 2,587,800.00 218,517.01 1,421,045.51 54.91 1,166,754.49
8-10-2011 07:57 AM
101-GENERAL FUND
Public Safety
~ DEPARTMENTAL EXPENDITURES
I Police-Administration
Personal Services
101-4-2110-4101 Regular Pay
101-4-2110-9104 PERA
101-4-2110-9107 Medicare
101-4-2110-4108 Insurance
101-4-2110-9109 Workers Comp
TOTAL Personal Services
CITY OF ELK RIVER PAGE: 12
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
58.33 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
275,400.00 20,888.14 144,216.95 52.37 131,183.05
39,650.00 3,007.90 21,791.24 54.96 17,858.76
2,750.00 191.10 1,357.72 49.37 1,392.28
25,650.00 1,844.02 12,450.19 48.54 13,199.86
59,350.00 0.00 43,669.75 73.58 15,680.25
402,800.00 25,931.16 223,485.80 55.98 179,314.20
Supplies
101-4-2110-4201 Office Supplies 19,000.00 441.08 3,792.32 19.96 15,207.68
101-4-2110-9217 Uniform Allowance 2,250.00 0.00 1,627.27 72.32 622.73
101-4-2110-4219 Operating Supplies 4,600.00 0.00 2,878.96 62.59 1,721.04
TOTAL Suppli es 25,850.00 441.08 8,298.55 32.10 17,551.45
Other Services & Charges
101-4-2110-4319 Other Professional Services 4,950.00 36.81 469.97 9.99 4,480.03
101-9-2110-4321 Telephone 29,300.00 101.22 9,156.73 31.25 20,143.27
101-4-2110-4322 Postage 2,200.00 14.76 1,272.01 57.82 927.99
101-4-2110-4331 Travel, Conferences & Schools 3,350.00 165.00 2,218.25 66.22 1,131.75
101-4-2110-4359 Publishing 500.00 0.00 57.00 11.40 943.00
101-4-2110-4361 Insurance 9,600.00 0.00 3,500.50 36.46 6,099.50
101-4-2110-4404 Equip Repair/Maint Services 75,250.00 3,568.46 53,021.99 70.46 22,228.06
101-4-2110-4433 Dues & Subscriptions 9,200.00 0.00 5,640.25 61.31 3,559.75
101-4-2110-4437 Taxes & Licenses 800.00 0.00 189.75 23.72 610.25
TOTAL Other Services & Charges 135,150.00 3,886.25 75,526.90 55.88 59,623.60
Capital Outlay
TOTAL Police Administration
1 Patrol
Personal Services
101-4-2120-4101 Regular Pay
101-4-2120-4102 Overtime Pay
101-4-2120-4104 PERA
101-4-2120-4107 Medicare
101-4-2120-4108 Insurance
TOTAL Personal Services
563,800.00 30,258.99 307,310.75 54.51 256,989.25
1,444,350.00 105,651.62 712,864.43 49.36 731,485.57
90,000.00 4,748.58 30,436.01 33.82 59,563.99
220,950.00 15,897.55 114,516.40 51.83 106,933.60
19,950.00 1,308.28 9,393.12 47.08 10,556.88
171,450.00 13,494.28 95,230.24 55.54 76,219.76
1,946,700.00 141,100.31 962,440.20 49.44 984,259.80
8-10-2011 07:57 AM
I 101-GENERAL FUND
Public Safety
I DEPARTMENTAL EXPENDITURES
58.33 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Supplies
101-4-2120-4212 Fuels & Lubs
101-9-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-9-2120-9433 Dues & Subscriptions
101-4-2120-4460 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
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-9217 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
CITY OF ELK RIVER PAGE: 13
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
108,500.00 7,471.78 52,049.02 47.97 56,450.98
23,900.00 697.55 6,068.21 25.39 17,831.79
58,650.00 7,995.66 30,089.22 51.30 28,560.78
28,000.00 448.82 7,104.39 25.37 20,895.61
219,050.00 16,563.81 95,310.84 43.51 123,739.16
15,650.00 1,265..00 8,332.45 53.24 7,317.55
26,700.00 324.20 10,241.40 38.36 16,958.60
550.00 0.00 340.00 61.82 210.00
44,150.00 3,679.17 25,754.19 58.33 18,395.81
87,050.00 5,268.37 44,668.04 51.31 42,381.96
2,252,800.00 162,932.49 1,102,419.08 48.94 1,150,380.92
505,600.00 39,609.87 250,758.69 49.60 254,841.31
45,000.00 1,402.25 8,791.35 19.43 36,258.65
79,300.00 5,905.74 40,047.44 50.50 39,252.56
5,850.00 458.74 2,993.36 51.17 2,856.64
70,100.00 5,499.63 38,913.87 55.51 31,186.13
705,850.00 52,876.23 341,454.71 48.37 364,395.29
5,150.00 631.89 2,822.88 54.81 2,327.12
8,700.00 246.28 1,834.16 21.08 6,865.84
13,850.00 878.17 4,657.04 33.62 9,192.96
11,900.00 106.88 1,408.69 11.84 10,491.31
5,550.00 350.00 2,518.58 45.38 3,031.42
1,050.00 0.00 150.00 14.29 900.00
14,250.00 1,187.50 8,312.50 58.33 5,937.50
32,750.00 1,694.38 12,389.77 37.83 20,360.23
TOTAL Investigations 752,450.00 55,398.78 358,501.52 47.64 393,948.48
I 8-10-2011 07:57 AM
101-GENERAL FUND
Public Safety
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER PAGE: 14
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
58.33 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
I Police-Support-Services
Personal Services
101-4-2150-4101 Regular Pay
101-4-2150-4102 Overtime Pay
101-4-2150-4104 PERA
101-4-2150-9105 FICA
101-4-2150-4107 Medicare
101-4-2150-4108 Insurance
TOTAL Personal Services
Supplies
101-4-2150-9201 Office Supplies
101-4-2150-4217 Uniform Allowance
101-4-2150-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-2150-9331 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 22,848.05 185,696.14 53.51 161,353.86
3,500.00 0.00 0.00 0.00 3,500.00
25,400.00 1,656.49 14,257.14 56.13 11,142.86
21,750.00 1,900.46 12,021.03 55.27 9,728.97
5,100.00 327.53 2,830.05 55.49 2,269.95
46,350.00 3,262.02 25,391.11 54.78 20,958.89
449,150.00 29,494.55 240,195.47 53.48 208,954.53
1,000.00 0.00 453.77 45.38 596.23
3,000.00 309.55 704.87 23.50 2,295.13
10,100.00 ( 377.05) 1,498.45 14.34 8,651.55
14,100.00 ( 67.50). 2,607.09 18.49 11,492.91
3,550.00 0.00 229.53 6.47 3,320.47
1,850.00 0.00 0.00 0.00 1,850.00
16,000.00 977.52 4,717.83 29.49 11,282.17
500.00 0.'00 233.33 46.67 266.67
6,550.00 545.83 3,820.81 58.33 2,729.19
28,450.00 1,523.35 9,001.50 31.64 19,448.50
TOTAL Police Support Services
1 Police Reserves
491,700..00 30,950.40 251,804.06 51.21 239,895.94
Personal Services
101-4-2160-4103 Part-time Pay 5,500.00 2,337.83 8,889.35 161.62 ( 3,389.35)
101-4-2160-4104 PERA 0.00 134.65 208.20 0.00 ( 208.20)
101-4-2160-4105 FICA 350.00 194.94 604.10 172.60 ( 259.10)
101-4-2160-9107 Medicare 100.00 33.90 141.29 141.29 ( 41.29)
101-4-2160-4109 Workers Comp 0.00 0.00 1,026.00 0.00 ( 1,026.00)
101-4-2160-4110 Re-employment Compensation 0.00 10.97 10.97 0.00 ( 10.97)
TOTAL Personal Services 5,950.00 2,662.29 10,879.91 182.86 ( 4,929.91)
Supplies
101-4-2160-4217 Uniform Allowance 5,000.00 109.85 1,666.62 33.33 3,333.38
101-4-2160-4219 Operating Supplies 6,000.00 749.70 1,609.31 26.82 4,390.69
TOTAL Supplies 11,000.00 859.55 3,275.93 29.78 7,724.07
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 15
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
101-GENERAL FUND
Public Safety
~ DEPARTMENTAL EXPENDITURES
Other Services & Charges
101-4-2160-9319 Other Professional Services
101-9-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
CURRENT
BUDGET CURRENT
PERIOD
1,500.00 395.00
1,600.00 0.00
1,700.00 0.00
150.00 0.00
1,000.00 0.00
5,950.00 395.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-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 3,916.84 15,235.84 66.53 7,664.16
101,850.00 7,595.23 51,818.67 50.88 50,031.33
7,400.00 550.64 3,997.73 54.02 3,902.27
6,300.00 449.28 3,317.32 52.66 2,982.68
1,500.00 105.06 775.81 51.72 724.19
13,300.00 1,174.06 7,645.29 57.48 5,654.71
3,400.00 0.00 2,843.25 83.63 556.75
133,750.00 9,874.27 70,398.07 52.63 63,351.93
15,000.00 811.83 7,737.87 51.59 7,262.13
15,000.00 811.83 7,737.87 51.59 7,262.13
6,750.00 0.00 2,570.00 38.07 4,180.00
18,200.00 823.91 13,135.03 72.17 5,064.97
31,300.00 1,393.06 5,464.19 17.46 25,835.81
56,250.00 2,216.97 21,169.22 37.63 35,080.78
TOTAL Public safety building
Fire Administration
Personal Services
101-4-2310-4101 Regular Pay
101-4-2310-4103 Part-time Pay
101-4-2310-4104 PERA
101-4-2310-4105 FICA
101-4-2310-4106 Other Retirement Contributions
205,000.00 12,903.07 99,305.16 48.44 105,694.84
86,200.00 6,902.00 47,937.20 55.61
186,250.00 13,094.36 90,211.20 48.49
13,500.00 1,084.81 7,962.19 58.98
12,500.00 852.00 5,917.98 47.34
38,500.00 38,500.00 38,500.00 100.00
58.33°s OF YEAR COMP.
YEAR TO DATE $ OF BUDGET
ACTUAL BUDGET BALANCE
38,262.80
96,038.80
5,537.81
6,582.02
0.00
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 16
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
101-GENERAL FUND
Public Safety
58.33°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE °s OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
101-4-2310-9107 Medicare 3,950.00 278.58 1,967.07 49.80 1,982.93
101-9-2310-4108 Insurance 7,200.00 1,095.96 7,366.51 102.31 ( 166.51)
101-4-2310-4109 Workers Comp 20,200.00 0.00 15,284.50 75.67 4,915.50
TOTAL Personal Services 368,300.00 61,807.71 215,146.65 58.42 153,153.35
Supplies
101-4-2310-4201 Office Supplies 5,150.00 117.05 4,215.02 81.85 934.98
101-4-2310-4212 Fuels & Lubs 7,350.00 1,003.79 4,147.95 56.43 3,202.05
101-4-2310-4217 Uniform Allowance 4,400.00 0.00 631.47 14.35 3,768.53
101-4-2310-4219 Operating Supplies 26,150.00 2,422.96 11,562.37 44.22 14,587.63
101-4-2310-4221 Equipment Parts 7,400.00 596.19 2,528.62 34.17 4,871.38
TOTAL Supplies 50,450.00 4,139.99 23,085.43 45.76 27,364.57
Other Services & Charges
101-4-2310-4319 Other Professional Services 5,100.00 0.00 2,330.99 45.71 2,769.01
101-4-2310-4321 Telephone 4,950.00 96.82 940.57 19.00 4,009.93
101-4-2310-9322 Postage 500.00 0.00 203.41 40.68 296.59
101-4-2310-4331 Travel, Conferences & Schools 27,450.00 ( 3,437.60) 8,549.38 31.15 18,900.62
101-4-2310-4359 Publishing 300.00 0.00 0.00 0.00 300.00
101-4-2310-4361 Insurance 17,500.00 0.00 7,967.50 42.67 10,032.50
101-4-2310-4389 Utilities 15,150.00 281.28 8,295.84 54.76 6,854.16
101-4-2310-4401 Bldg Repair/Maint Services 5,650.00 1,172.91 3,166.23 56.04 2,483.77
101-4-2310-4404 Equip Repair/Maint Services 31,550.00 3,526.07 17,240.49 54.64 14,309.51
101-4-2310-4433 Dues ~ Subscriptions 1,950.00 0.00 1,351.00 69.28 599.00
101-4-2310-4960 Equip Replacement Charge 29,650.00 2,470.83 17,295.81 58.33 12,354.19
TOTAL Other Services & Charges 139,750.00 9,110.31 66,841.22 47.83 72,908.78
Capital Outlay
101-4-2310-4560 Equipment 31,100.00 8,197.50 29,040.94 93.38 2,059.06
TOTAL Capital Outlay 31,100.00 8,197.50 29,040.94 93.38 2,059.06
TOTAL Fire Adm inistration 589,600.00 78,255.51 334,114.24 56.67 255,485.76
I Fire-Inspections
I Personal Services
101-4-2320-4101 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
129,900.00 9,955.61 69,960.59 54.07 59,439.41
14,850.00 1,143.83 8,590.66 57.85 6,259.34
3,250.00 267.42 2,056.82 63.29 1,193.18
1,900.00 194.47 1,095.83 57.68 804.17
14,850.00 1,195.86 8,371.02 56.37 6,478.98
164,250.00 12,707.19 90,074.92 54.84 74,175.08
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 17
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
I 101-GENERAL FUND
Public Safety
I DEPARTMENTAL EXPENDITURES
58.33°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Supplies
101-4-2320-9201 Office Supplies
101-4-2320-4212 Fuels & Lubs
101-4-2320-4217 Uniform Allowance
101-9-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
TOTAL Fire Inspections
Emergency Management
Personal Services
101-4-2330-4101 Regular Pay
101-9-2330-4104 PERA
101-4-2330-4107 Medicare
101-4-2330-4108 Insurance
TOTAL Personal Services
Supplies
101-4-2330-4201 Office Supplies
101-4-2330-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-2330-4321 Telephone
101-4-2330-4331 Travel, Conferences & Schools
101-4-2330-4389 Utilities
101-4-2330-4404 Equip Repair/Maint Services
101-4-2330-4433 Dues & Subscriptions
TOTAL Other Services & Charges
Capital Outlay
101-4-2330-4560 Equipment
TOTAL Capital Outlay
TOTAL Emergency Management
2,750.00 0.00 461.69 16.79 2,288.31
3,200.00 356.39 2,964.72 77.02 735.28
1,400.00 0.00 0.00 0.00 1,400.00
4,450.00 0.00 701.31 15.76 3,748.69
11,800.00 356.39 3,627.72 30.79 8,172.28
2,950.00 341.60 1,148.59 38.94 1,801.41
2,500.00 677.48 1,062.48 42.50 1,437.52
2,000.00 0.00 230.16 11.51 1,769.84
1,350.00 0.00 982.50 72.78 367.50
8,800.00 1,019.08 3,423.73 38.91 5,376.27
184,850.00 14,082.66 97,126.37 52.54 87,723.63
8,900.00 683.57 4,691.81 52.72 9,208.19
1,300.00 98.43 723.73 55.67 576.27
150.00 9.92 72.97 48.65 77.03
600.00 39.84 278.88 46.48 321.12
10,950.00 831.76 5,767.39 52.67 5,182.61
500.00 0.00 57.94 11.59 442.06
9,150.00 0.00 1,260.79 13.78 7,889.21
9,650.00 0.00 1,318.73 13.67 8,331.27
1,650.00 ( 60.01) 93.42 5.66 1,556.58
4,000.00 0.00 40.80 1.02 3,959.20
1,500.00 97.35 600.55 40.04 899.45
7,800.00 96.19 561.19 7.19 7,238.86
100.00 0.00 100.00 100.00 0.00
15,050.00 133.53 1,395.91 9.28 13,654.09
71,750.00 52,090.88 65,337.31 91.06 6,412.69
71,750.00 52,090.88 65,337.31 91.06 6,412.69
107,400.00 53,056.17 73,819.39 68.73 33,580.66
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 18
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
101-GENERAL FUND
Public Safety
DEPARTMENTAL EXPENDITURES
58.33°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
~ Building Safety
Personal Services
101-4-2410-4101 Regular Pay
101-4-2910-4103 Part-time Pay
101-4-2410-4104 PERA
101-4-2410-4105 FICA
101-4-2410-4107 Medicare
101-4-2410-4108 Insurance
101-4-2410-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-2910-4201 Office Supplies
101-4-2410-4212 Fuels & Lubs
101-4-2410-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-2410-4321 Telephone
101-4-2410-4322 Postage
101-4-2.410-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-4460 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
I TOTAL Building Safety
Environmental
Personal Services
101-4-2490-4101 Regular Pay
101-4-2440-4104 PERA
101-4-2940-4105 FICA
101-4-2440-4107 Medicare
101-4-2440-4108 Insurance
101-4-2440-4109 Workers Comp
TOTAL Personal Services
319,900.00 24,568.16 171,570.14 53.72 147,829.86
25,950.00 2,462.14 14,319.74 55.18 11,630.26
25,050.00 1,959.72 14,441.35 57.65 10,608.65
21,400.00 1,563.77 11,567.16 54.05 9,832.84
5,000.00 365.72 2,705.21 54.10 2,294.79
40,150.00 3,286.02 22,870.54 56.96 17,279.46
1,200.00 0.00 1,111.75 92.65 88.25
438,150.00 34,205.53 238,585.89 54.45 199,564.11
2,500.00 152.00 788.60 31.54 1,711.90
4,700.00 933.05 2,144.11 45.62 2,555.89
2,250.00 0.00 142.24 6.32 2,107.76
9,450.00 585.05 3,074.95 32.54 6,375.05
1,600.00 161.23 985.21 61.58 614.79
400.00 0.00 131.92 32.98 268.08
4,650.00 40.00 1,535.00 33.01 3,115.00
900.00 0.00 299.50 33.28 600.50
7,200.00 221.63 9,581.74 63.64 2,618.26
1,200.00 0.00 315.00 26.25 885.00
1,650.00 137.50 962.50 58.33 687.50
17,600.00 560.36 8,810.87 50.06 8,789.13
465,200.00 35,350.94 250,471.71 53.84 214,728.29
39,050.00 3,002.80 21,019.58 53.83 18,030.42
2,850.00 217.70 1,623.79 56.98 1,226.21
2,400.00 160.96 1,212.14 50.51 1,187.86
550.00 37.64 283.46 51.54 266.54
4,850.00 479.59 3,357.14 69.22 1,492.86
400.00 0.00 370.25 92.56 29.75
50,100.00 3,898.69 27,866.36 55.62 22,233.64
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 19
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
101-GENERAL FUND
Public Safety
DEPARTMENTAL EXPENDITURES
58.330 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Supplies
101-4-2440-4201 Office Supplies
101-4-2440-4212 Fuels & Lubs
TOTAL Supplies
Other Services & Charges
101-4-2940-4321 Telephone
101-4-2440-4322 Postage
101-4-2440-4331 Travel, Conferences & Schools
101-4-2440-4359 Publishing
101-4-2490-4361 Insurance
101-4-2440-4409 Contractual Services
101-4-2940-4433 Dues & Subscriptions
TOTAL Other Services & Charges
650.00 12.26 188.83 29.05 461.17
150.00 59.00 149.65 99.77 0.35
800.00 71.26 338.48 42.31 461.52
700.00 31.94 187.44 26.78 512.56
500.00 0.00 574.85 114.97 ( 74.85)
500.00 0.00 263.66 52.73 236.34
100.00 0.00 67.50 67.50 32.50
200.00 0.00 0.00 0.00 200.00
3,000.00 0.00 84.00 2.80 2,916.00
1,050.00 0.00 40.00 3.81 1,010.00
6,050.00 31.94 1,217.45 20.12 4,832.55
I TOTAL Environmental
56,950.00 9,001.89 29,422.29 51.66 27,527.71
TOTAL Public Safety
Street Maintenance
Personal Services
101-4-3120-4101 Regular Pay
101-4-3120-9103 Part-time Pay
101-4-3120-4104 PERA
101-4-3120-4105 FICA
101-4-3120-4107 Medicare
101-4-3120-4108 Insurance
101-4-3120-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-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-4321 Telephone
101-4-3120-4322 Postage
101-4-3120-9331 Travel, Conferences & Schools
101-4-3120-4359 Publishing
101-4-3120-4361 Insurance
101-4-3120-4389 Utilities
5,692,650.00 481,107.24 2,919,530.36 51.29 2,773,119.64
426,650.00 38,019.98 210,822.55 49.41 215,827.45
78,400.00 8,044.57 33,704.15 42.99 44,695.85
34,950.00 2,725.95 16,617.99 47.55 18,332.01
31,300.00 2,668.02 14,782.61 47.23 16,517.39
7,350.00. 623.97 3,457.18 47.04 3,892.82
57,050.00 5,450.04 27,376.57 47.99 29,673.43
25,050.00 0.00 19,308.00 77.08 5,742.00
660,750.00 57,532.53 326,069.05 49.35 334,680.95
3,600.00 29.63 376.48 10.46 3,223.52
64,250.00 18,399.41 64,904.69 101.02 ( 654.69)
146,750.00 7,188.04 39,331.64 26.80 107,418.36
42,000.00 4,356.19 10,985.30 26.16 31,014.70
256,600.00 29,973.27 115,598.11 45.05 141,001.89
250.00 0.00 0.00 0.00 250.00
8,950.00 444.92 2,794.99 30.67 6,205.01
200.00 0.00 31.22 15.61 168.78
3,000.00 399.70 1,176.36 39.21 1,823.64
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 2,553.48 21,550.13 59.86 14,449.87
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 20
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
101-GENERAL FUND
Public Works 58.33s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE a OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
101-4-3120-4401 Bldg Repair/Maint Services 4,500.00 0.00 1,123.87 24.97 3,376.13
101-4-3120-4404 Equip Repair/Maint Services 5,000.00 464.77 3,336.86 66.74 1,663.14
101-4-3120-4409 Contractual Services 422,750.00 2,700.00 28,103.62 6.65 394,646.3$
101-4-3120-4415 Equipment Rental 10,000.00 409.19 890.14 8.90 9,109.86
101-4-3120-4417 Uniform Rental 4,700.00 663.55 1,357.51 28.88 3,342.49
101-4-3120-4433 Dues & Subscriptions 350.00 0.00 251.25 71.79 98.75
101-4-3120-4437 Taxes & Licenses 500.00 21.25 104.50 20.90 395.50
101-4-3120-4960 Equip Replacement Charge 93,150.00 7,762.50 54,337.50 58.33 38,812.50
TOTAL Other Services & Charges 607,100.00 15,419.36 123,729.45 20.38 983,375.55
Capital Outlay
TOTAL Street Maintenance 1,524,450.00 102,925.16 565,391.61 37.09 959,058.39
Snow Removal
Personal Services
101-4-3130-4101 Regular Pay 115,500.00 0.00 69,593.29 60.25 45,906.71
101-4-3130-4102 Overtime Pay 15,000.00 0.00 17,367.13 115.78 ( 2,367.13)
101-4-3130-9104 PERA 9,050.00 0.00 7,728.45 85.40 1,321.55
101-4-3130-9105 FICA 8,100.00 0.00 6,190.07 76.42 1,909.93
101-4-3130-4107 Medicare 1,900.00 0.00 1,447.62 76.19 452.38
101-4-3130-4108 Insurance 15,950.00 0.00 14,176.21 88.88 1,773.79
101-4-3130-4109 Workers Comp 7,350.00 0.00 3,932.00 46.69 3,918.00
TOTAL Personal Services 172,850.00 0.00 119,934.77 69.39 52,915.23
Supplies
101-4-3130-4219 Operating Supplies 90,000.00 55.41 75,595.74 84.00 14,404.26
TOTAL Supplies 90,000.00 55.41 75,595.74 84.00 14,404.26
Other Services & Charges
Capital Outlay
TOTAL Snow Removal 262,850.00 55.41 195,530.51 74.39 67,319.49
Equipment Services
Personal Services
101-4-3150-4101 Regular Pay 162,750.00 12,520.00 82,799.45 50.88 79,950.55
101-4-3150-4102 Overtime Pay 0.00 0.00 91.39 0.00 ( 41.39)
101-4-3150-4104 PERA 11,800.00 907.68 6,313.88 53.51 5,486.12
101-4-3150-4105 FICA 10,100.00 716.10 5,031.21 49.81 5,068.79
101-4-3150-4107 Medicare 2,350.00 167.48 1,176.68 50.07 1,173.32
101-4-3150-4108 Insurance 22,700.00 1,882.01 11,088.20 48.85 11,611.80
101-4-3150-4109 Workers Comp 7,050.00 0.00 2,835.50 40.22 4,214.50
TOTAL Personal Services 216,750.00 16,193.27 109,286.31 50.42 107,463.69
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 21
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
101-GENERAL FUND
Public Works
DEPARTMENTAL EXPENDITURES
58.33$ 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-9-3150-4404 Equip Repair/Maint Services
101-4-3150-4417 Uniform Rental
TOTAL Other Services & Charges
Capital Outlay
14,500.00 123.98 6,979.62 98.19 7,520.38
11,200.00 0.00 0.00 0.00 11,200.00
25,700.00 123.98 6,979.62 27.16 18,720.38
500.00 0.00 182.16 36.43 317.84
3,000.00 252.60 1,345.07 44.84 1,654.93
3,500.00 252.60 1,527.23 43.64 1,972.77
TOTAL Equipment Services
Engineering
Personal Services
101-4-3300-4101 Regular Pay
101-4-3300-4104 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-9201 Office Supplies
101-4-3300-4212 Fuels & Lubs
101-4-3300-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-3300-4319 Other Professional Services
101-4-3300-4321 Telephone
101-4-3300-4322 Postage
101-4-3300-4331 Travel, Conferences & Schools
101-4-3300-4361 Insurance
101-4-3300-4404 Equip Repair/Maint Services
101-4-3300-4460 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
245,950.00 16,569.85 117,793.16 47.89 128,156.89
116,750.00 6,775.79 46,543.26 39.87 70,206.74
8,450.00 491.24 3,614.62 42.78 4,835.38
7,250.00 369.75 2,738.70 37.78 4,511.30
1,700.00 86.47 640.44 37.67 1,059.56
13,000.00 928.01 6,496.07 49.97 6,503.93
450.00 0.00 ( 20.00) 4.44- 470.00
147,600.00 8,651.21 60,013.09 40.66 87,586.91
1,000.00 26.29 26.29 2.63 973.71
700.00 0.00 260.16 37.17 439.84
9,800.00 0.00 68.17 0.70 9,731.83
11,500.00 26.29 354.62 3.08 11,145.38
10,000.00 0.00 852.81 8.53 9,147.19
1,150.00 0.34 6.63 0.58 1,143.37
200.00 0.00 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,309.21 261.84 ( 809.21)
800.00 66.67 466.69 58.34 333.31
18,700.00 254.04 2,972.46 15.90 15,727.54
TOTAL Engineering 177,800.00 8,931.54 63,340.17 35.62 114,459.83
~ TOTAL Public Works 2,211,050.00 128,481.96 942,055.45 42.61 1,268,994.55
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 22
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
101-GENERAL FUND
Culture & Recreation
~ DEPARTMENTAL EXPENDITURES
58.330 OF YEAR COMP.
CURRENT CURRENT
BUDGET PERIOD
YEAR TO DATE o OF BUDGET
ACTUAL BUDGET BALANCE
~ Parks Department
Personal Services
101-4-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-9108 Insurance
101-4-5110-9109 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-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-9460 Equip Replacement Charge
TOTAL Other Services & Charges
Capital Outlay
TOTAL Parks Department
Parks & Rec Admin
350,250.00 32,352.08 187,679.36 53.58 162,570.64
0.00 0.00 19.00 0.00 ( 19.00)
40,000.00 8,486.51 19,626.01 49.07 20,373.99
25,900.00 2,045.56 14,582.00 57.41 10,818.00
24,200.00 2,389.07 12,680.63 52.40 11,519.37
5,650.00 558.75 2,965.75 52.49 2,689.25
46,900.00 5,226.56 29,097.00 62.04 17,803.00
9,000.00 0.00 7,572.50 84.14 1,427.50
0.00 764.00 3,247.00 0.00 ( 3,297.00)
501,400.00 51,822.53 277,469.25 55.34 223,930.75
33,200.00 5,237.29 16,941.73 49.52 16,758.27
3,250.00 212.20 1,418.48 43.65 1,831.52
72,900.00 3,575.55 37,057.63 50.83 35,842.37
11,000.00 1,129.76 11,156.87 101.43 ( 156.87)
120,350.00 10,154.80 66,074.71 54.90 54,275.29
4,400.00 388.49 1,552.65 35.29 2,847.35
100.00 10.22 10.22 10.22 89.78
3,150.00 391.36 1,097.43 34.84 2,052.57
26,700.00 0.00 12,814.50 47.99 13,885.50
27,800.00 2,283.97 4,380.71 15.76 23,419.29
9,000.00 0.00 0.00 0.00 4,000.00
12,000.00 898.20 5,949.58 49.58 6,050.42
7,550.00 1,642.34 4,416.41 58.50 3,133.59
25,000.00 1,405.99 5,738.24 22.95 19,261.76
57,900.00 9,825.00 33,775.00 58.33 24,125.00
168,600.00 11,845.07 69,734.74 41.36 98,865.26
790,350.00 73,822.40 413,278.70 52.29 377,071.30
Personal Services
101-4-5210 -4101 Regular Pay 338,950.00 19,331.22 133,681.18 39.44 205,268.82
101-4-5210 -4103 Part-time Pay 20,850.00 2,884.48 19,570.26 93.86 1,279.74
101-4-5210 -4104 PERA 26,100.00 1,610.65 11,880.65 45.52 14,219.35
101-4-5210 -4105 FICA 22,300.00 1,281.04 9,427.58 42.28 12,872.42
101-4-5210 -4107 Medicare 5,200.00 299.62 2,204.94 42.40 2,995.06
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 23
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
101-GENERAL FUND
Culture & Recreation
DEPARTMENTAL EXPENDITURES
CURRENT
BUDGET
CURRENT
PERIOD
YEAR TO DATE
ACTUAL
58.330
~ OF
BUDGET
OF YEAR COMP.
BUDGET
BALANCE
101-4-5210-4108 Insurance 45,600.00 2,793.15 19,931.43 43.71 25,668.57
101-4-5210-9109 Workers Comp 3,750.00 0.00 2,769.50 73.85 980.50
TOTAL Personal Services 462,750.00 28,150.16 199,465.54 43.10 263,284.46
Supplies
101-4-5210-4219 Operating Supplies 11,700.00 971.76 8,697.70 74.34 3,002.30
TOTAL Supplies 11,700.00 971.76 8,697.70 79.34 3,002.30
Other Services & Charges
101-4-5210-9321 Telephone 4,800.00 318.73 1,742.59 36.30 3,057.46
101-4-5210-4322 Postage 4,000.00 0.00 1,950.12 48.75 2,049.88
101-4-5210-4331 Travel, Conferences & Schools 6,950.00 842.50 2,584.27 37.18 9,365.73
101-4-5210-4349 Advertising/Marketing 26,400.00 2,069.76 16,399.13 62.12 10,000.87
101-4-5210-4361 Insurance 1,450.00 0.00 307.50 21.21 1,142.50
101-4-5210-9389 Utilities 8,500.00 218.50 3,122.08 36.73 5,377.92
101-4-5210-9401 Bldg Repair/Maint Services 12,850.00 1,139.39 9,131.79 71.06 3,718.21
101-4-5210-4404 Equip Repair/Maint Services 9,350.00 925.67 6,428.81 68.76 2,921.19
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 5,519.55 92,749.29 56.36 33,100.76
Capital Outlay
TOTAL Parks & Rec Admin
Recreation Programs
Personal Services
101-4-5220-9102 Overtime Pay
101-4-5220-4103 Part-time Pay
101-4-5220-4104 PERA
101-4-5220-4105 FICA
101-4-5220-4107 Medicare
TOTAL Personal Services
Supplies
101-4-5220-4219 Operating Supplies
TOTAL Supplies
Other Services & Charges
101-4-5220-9404 Equip Repair/Maint Services
101-4-5220-4409 Contractual Services
101-4-5220-4412 Building Rent
101-4-5220-4438 Credit Card Fees
TOTAL Other Services & Charges
550,300.00 34,636.97 250,912.48 45.60 299,387.52
0.00 146.25 687.00 0.00 ( 687.00)
82,000.00 18,092.50 50,827.59 61.98 31,172.41
2,400.00 209.36 935.10 38.96 1,464.90
4,350.00 1,139.87 3,257.92 74.89 1,092.08.
1,200.00 266.62 761.97 63.50 438.03
89,950.00 19,854.60 56,469.58 62.78 33,480.42
31,000.00 11,894.81 26,572.30 85.72 4,927.70
31,000.00 11,894.81 26,572.30 85.72 4,427.70
500.00 0.00 0.00 0.00 500.00
64,050.00 16,143.30 43,036.10 67.19 21,013.90
3,000.00 0.00 1,445.00 48.17 1,555.00
4,000.00 501.82 3,434.09 85.85 565.91
71,550.00 16,645.12 47,915.19 66.97 23,634.81
TOTAL Recreation Programs 192,500.00 48,394.53 130,957.07 68.03 61,542.93
8-10-2011 07:57 AM CITY OF ELK RIVER PAGE: 24
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
101-GENERAL FUND
Culture & Recreation
DEPARTMENTAL EXPENDITURES
CURRENT CURRENT YEAR TO DATE
BUDGET PERIOD ACTUAL
58.33$ OF YEAR COMP.
% OF BUDGET
BUDGET BALANCE
Concessions
Personal Services
101-4-5230-4103 Part-time Pay 3,650.00 504.63 1,434.88 39.31 2,215.12
101-4-5230-4104 PERA 150.00 0.00 22.44 14.96 127.56
101-4-5230-4105 FICA 250.00 31.29 88.98 35.59 161.02
101-4-5230-4107 Medicare 50.00 7.32 20.81 41.62 29.19
TOTAL Personal Services 4,100.00 543.29 1,567.11 38.22 2,532.89
Supplies
101-4-5230-4219 Operating Supplies 2,900.00 174.16 208.98 7.21 2,691.02
101-4-5230-4259 Other Merchandise For Resale 7,000.00 582.84 2,978.26 42.55 9,021.74
TOTAL Supplies 9,900.00 757.00 3,187.24 32.19 6,712.76
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
Sr Citizen Programs
Personal Services
101-4-5510-4101 Regular Pay
101-4-5510-4103 Part-time Pay
101-4-5510-4104 PERA
101-4-5510-9105 FICA
101-4-5510-4107 Medicare
101-4-5510-4108 Insurance
101-4-5510-4109 Workers Comp
TOTAL Personal Services
Supplies
101-4-5510-9219 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-4401 Bldg Repair/Maint Services
101-4-5510-4404 Equip Repair/Maint Services
101-4-5510-9409 Contractual Services
101-4-5510-4433 Dues & Subscriptions
TOTAL Other Services & Charges
14,100.00 1,300.24 4,754.35 33.72 9,345.65
57,400.00 4,414.41 30,900.89 53.83 26,499.11
62,000.00 4,737.89 32,572.16 52.54 29,427.84
8,650.00 663.53 4,932.28 57.02 3,717.72
7,400.00 531.37 3,965.47 53.59 3,934.53
1,750.00 124.28 927.45 53.00 822.55
13,700.00 1,110.20 7,771.40 56.73 5,928.60
500.00 0.00 399.50 79.90 100.50
151,400.00 11,581.68 81,469.15 53.81 69,930.85
12,400.00 859.18 4,117.17 33.20 8,282.83
12,900.00 859.18 4,117.17 33.20 8,282.83
2,600.00 152.52 1,221.58 46.98 1,378.42
2,500.00 190.00 1,320.07 52.80 1,179.93
2,900.00 0.00 453.82 18.91 1,996.18
1,600.00 0.00 742.50 46.41 857.50
9,700.00 591.44 6,395.85 65.94 3,304.15
12,400.00 940.22 6,801.15 54.85 5,598.85
1,500.00 239.08 239.08 15.94 1,260.92
6,950.00 ( 101.00) 263.00 3.78 6,687.00
1,000.00 24.00 744.16 74.42 255.84
40,650.00 2,036.26 18,181.21 44.73 22,468.79
8-10-2011 07:57 AM
101-GENERAL FUND
Culture & Recreation
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
PAGE: 25
58.33$ 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,477.12 103,767.53 50.75 100,682.47
TOTAL Culture & Recreation 1,751,700.00 172,630.76 903,670.13 51.59 848,029.87
Economic Development
Personal Services
101-4-6210-4101 Regular Pay 0.00 5,256.62 13,398.42 0.00 ( 13,398.42)
101-4-6210-4103 Part-time Pay 0.00 2,156.36 3,048.20 0.00 ( 3,048.20)
101-4-6210-4104 PERA 0.00 396.10 821.49 0.00 ( 821.49)
101-4-6210-4105 FICA 0.00 371.38 911.84 0.00 ( 911.84)
101-4-6210-4107 Medicare 0.00 89.02 217.60 0.00 ( 217.60)
101-4-6210-4108 Insurance 0.00 486.00 972.00 0.00 ( 972.00)
101-4-6210-4109 Workers Comp 0.00 0.00 195.25 0.00 ( 195.25)
TOTAL Personal Services 0.00 8,755.48 19,564.80 0.00 ( 19,564.80)
Other Services & Charges
101-4-6210-4490 Miscellaneous 0.00 233.29 233.29 0.00 ( 233.29)
TOTAL Other Services & Charges 0.00 233.29 233.29 0.00 ( 233.29)
TOTAL Economic Development 0.00 8,988.77 19,798.09 0.00 ( 19,798.09)
Energy City
Personal Services
101-4-6220-4101 Regular Pay 28,700.00 2,208.32 15,458.24 53.86 13,241.76
101-4-6220-4109 PERA 2,100.00 160.12 1,189.69 56.65 910.31
101-4-6220-4105 FICA 1,800.00 123.14 920.85 51.16 879.15
101-4-6220-4107 Medicare 400.00 28.80 215.37 53.84 184.63
101-4-6220-4108 Insurance 3,150.00 249.51 1,746.57 55.95 1,403.43
TOTAL Personal Services 36,150.00 2,769.89 19,530.72 54.03 16,619.28
Supplies
Other Services & Charges
101-4-6220-4319 Other Professional Services 5,000.00 0.00 1,809.00 36.18 3,191.00
101-4-6220-4331 Travel, Conferences 6 Schools 7,500.00 0.00 ( 820.71) 10.94- 8,320.71
101-4-6220-4359 Publishing 3,000.00 8.95 1,587.81 52.93 1,412.19
TOTAL Other Services & Charges 15,500.00 8.95 2,576.10 16.62 12,923.90
TOTAL Energy City 51,650.00 2,778.84 22,106.82 42.80 29,543.18
8-10-2011 07:57 AM
101-GENERAL FUND
Economic Development
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
PAGE: 26
58.330 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE % OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
TOTAL Economic Development 51,650.00 11,767.61 41,904.91 81.13 9,745.09
Transfers Out
Transfers Out
101-4-7000-4723 Transfer-Ice Arena 156,250.00 0.00 0.00 0.00 156,250.00
101-4-7000-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,012,504.58 6,228,206.36 49.83 6,271,843.64
REVENUES OVER/(UNDER) EXPENDITURES ( 336,600.00) 1,279,420.18 639,350.85 ( 975,950.85)
B-10-2011 07:58 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
221-ICE ARENA
FINANCIAL SUMMARY
58.33°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE ° 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 9,399.37 266,815.52 39.30 412,084.48
49,500.00 13,765.00 35,650.00 72.02 13,850.00
73,350.00 4,138.50 37,276.63 50.82 36,073.37
63,100.00 0.00 40,944.09 64.89 22,155.91
864,850.00 27,297.87 380,686.24 44.02 484,163..76
756,500.00 48,680.24 310,785.38 41.08 445,714.62
27,050.00 5.60 7,452.99 27.55 19,597.01
34,050.00 474.30 14,102.25 41.42 19,947.75
47,250.00 241.94 27,055.19 57.26 20,194.86
864,850.00 49,402.08 359,395.76 41.56 505,954.24
864,850.00 49,402.08 359,395.76 41.56 505,454.24
0.00 ( 22,104.21) .21,290.48 ( 21,290.48)
8-10-2011 07:58 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
I 221-ICE ARENA
REVENUES
58.33 OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE °s OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
~ Ice Arena
Charges for Services
221-3-0000-3464 Ice Rental
221-3-0000-3465 Admissions
221-3-0000-3466 Dry Floor Events
221-3-0000-3468 Skate Sharpening
221-3-0000-3475 Building Rent
221-3-0000-3482 Advertising fee
TOTAL Charges for Services
Other Revenue
221-3-0000-3622 Vending Machines
221-3-0000-3629 Miscellaneous Revenue
TOTAL Other Revenue
Sales
221-3-0000-3791 ATM Revenue
TOTAL Sales
Transfers In
221-3-0000-3922 Transfer-General Fund
TOTAL Transfers In
TOTAL Ice Arena
Hockey
Charges for Services
221-3-5410-3461 Recreation Fees
TOTAL Charges for Services
443,000.00 8,608.46 226,153.65 51.05 216,846.35
22,900.00 0.00 17,666.25 77.15 5,233.75
14,600.00 394.00 11,656.07 79.84 2,943.93
4,100.00 28.00 2,920.00 59.02 1,680.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 9,030.46 259,469.97 51.46 244,730.03
16,650.00 331.66 5,984.17 35.94 10,665.83
1,800.00 32.25 1,169.23 69.96 630.77
18,450.00 363.91 7,153.40 38.77 11,296.60
0.00 0.00 192.15 0.00 ( 192.15)
0.00 0.00 192.15 0.00 ( 192.15)
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 9,394.37 266,815.52 39.30 412,084.48
49,500.00 13,765.00 35,650.00 72.02 13,850.00
49,500.00 13,765.00 35,650.00 72.02 13,850.00
TOTAL Hockey
Skating
49,500.00 13,765.00 35,650.00 72.02 13,850.00
8-10-2011 07:58 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
221-ICE ARENA
REVENUES
58.33°s OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE $ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Charges for Services
221-3-5420-3461 Recreation Fees 68,000.00 9,138.50 33,818.50 49.73 34,181.50
221-3-5420-3465 Admissions 3,800.00 0.00 3,455.13 91.00 341.87
TOTAL Charges for Services 71,800.00 4,138.50 37,276.63 51.92 39,523.37
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 4,138.50 37,276.63 50.82 36,073.37
Concessions
Charges for Services
221-3-5430-3467 Concessions 63,100.00 0.00 40,949.09 64.89 22,155.91
TOTAL Charges for Services 63,100.00 0.00 40,944.09 64.89 22,155.91
TOTAL Concessions 63,100.00 0.00 40,944.09 64.89 22,155.91
TOTAL REVENUE 864,850.00 27,297.87 380,686.24 44.02 984,163.76
8-10-2011 07:58 AM CITY OF ELK RIVER PAGE: 4
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
221-ICE ARENA
DEPARTMENTAL EXPENDITURES
58.33$ OF YEAR COMP.
CURRENT CURRENT YEAP. TO DATE ~ OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
I Ice Arena
Personal Services
221-4-5400-4101 Regular Pay 148,700.00 7,125.23
221-4-5400-4103 Part-time Pay 73,200.00 3,524.16
221-4-5400-4104 PERA 12,250.00 867.42
221-4-5900-4105 FICA 13,750.00 646.52
221-4-5400-4107 Medicare 3,200.00 151.21
221-4-5400-4108 Insurance 17,150.00 284.52
221-4-5400-4109 Workers Comp 5,550.00 0.00
221-4-5400-4110 Re-employment Compensation 0.00 ( 0.59)
TOTAL Personal Services 273,800.00 12,598.47
Supplies
221-4-5400-4212 Fue.1s & Lubs 400.00 16.26
221-4-5400-4217 Uniform Allowance 1,500.00 0.00
221-4-5400-4219 Operating Supplies 34,500.00 4,208.69
221-4-5400-4255 Soft Drinks/Misc 9,000.00 0.00
221-4-5400-4259 Other Merchandise For Resale 900.00 0.00
TOTAL Supplies 46,300.00 4,224.95
Other Services & Charges
221-4-5400-9319 Other Professional Services 0.00 3,930.00
221-4-5400-4321 Telephone 3,450.00 280.42
221-4-5400-4322 Postage 500.00 0.00
221-4-5400-4331 Travel, Conferences & Schools 1,000.00 0.00
221-4-5400-4359 Publishing 2,200.00 0.00
221-4-5400-4361 Insurance 8,350.00 0.00
221-4-5900-4389 Utilities 148,950.00 9,754.53
221-4-5400-4401 Bldg Repair/Maint Services 22,300.00 2,989.27
221-4-5400-4409 Contractual Services 1,200.00 17.60
221-4-5400-9415 Equipment Rental 2,800.00 0.00
221-4-5400-4433 Dues & Subscriptions 950.00 0.00
TOTAL Other Services & Charges 191,200.00 16,466.82
Capital Outla
71,636.91 98.18 77,063.09
40,513.34 55.35 32,686.66
7,051.19 57.56 5,198.86
7,432.98 54.06 6,317.02
1,738.36 54.32 1,461.64
8,376.00 48.84 8,774.00
5,201.50 93.72 348.50
369.48 0.00 ( 369.48)
142,319.71 51.98 131,480.29
23.08 5.77 376.92
266.50 17.77 1,233.50
16,942.3 9 99.11 17,557.61
1,871.09 20.79 7,128.96
0.00 0.00 900.00
19,103.01 41.26 27,196.99
3,930.00 0.00 ( 3,930.00)
1,489.48 43.17 1,960.52
268.86 53.77 231.14
44.98 4.50 955.02
1,605.89 73.00 594.11
3,614.50 43.29 4,735.50
76,637.27 51.45 72,312.73
8,840.69 39.64 13,459.31
204.00 17.00 996.00
683.96 24.43 2,116.04
183.34 40.74 266.66
97,502.97 51.00 93,697.03
221-4-5400-4560 Equipment 44,400.00 0.00 36,469.69 82.14 7,930.31
TOTAL Capital Outlay 44,400.00 0.00 36,469.69 82.14 7,930.31
Transfers Out
221-4-5400-4730 Transfer-Debt Service 200,800.00 15,390.00 15,390.00 7.66 185,410.00
TOTAL Transfers Out 200,800.00 15,390.00 15,390.00 7.66 185,410.00
TOTAL Ice Arena 756,500.00 48,680.24 310,785.38 41.08 445,714.62
8-10-2011 07:58 AM
221-ICE ARENA
Culture & Recreation
DEPARTMENTAL EXPENDITURES
CITY OF ELK RIVER
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
PAGE: 5
58.33% OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Hockey
Personal Services
221-9-5410-4103 Part-time Pay 3,600.00 0.00 0.00 0.00 3,600.00
221-4-5410-4105 FICA 250.00 0.00 0.00 0.00 250.00
221-4-5410-4107 Medicare 50.00 0.00 0.00 0.00 50.00
TOTAL Personal Services 3,900.00 0.00 0.00 0.00 3,900.00
Supplies
221-9-5410-4219 Operating Supplies 19,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-5410-9359 Publishing 500.00 0.00 0.00 0.00 500.00
221-4-5410-4409 Contractual Services 6,400.00 5.60 2,843.90 44.43 3,556.60
221-4-5410-4438 Credit Card Fees 2,200.00 0.00 1,655.64 75.26 544.36
TOTAL Other Services & Charges 9,100.00 5.60 9,499.04 49.44 4,600.96
TOTAL Hockey 27,050.00 5.60 7,952.99 27.55 19,597.01
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 469.95 37.20 785.05
221-4-5420-4107 Medicare 300.00 0.00 108.76 36.25 191.24
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 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 49.00 331.51
221-4-5420-4409 Contractual Services 2,550.00 124.00 723.00 28.35 1,827.00
221-4-5920-4438 Credit Card Fees 2,800.00 350.30 1,087.95 38.86 1,712.05
TOTAL Other Services & Charges 6,000.00 474.30 2,129.44 35.49 3,870.56
I TOTAL Skating 34,050.00 474.30 14,102.25 41.42 19,947.75
8-10-2011 07:58 AM CITY OF ELK RIVER PAGE: 6
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
221-ICE ARENA
Culture & Recreation
DEPARTMENTAL EXPENDITURES
58.33a OF YEAR COMP.
CURRENT CURRENT YEP.R TO DATE °s OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
I Arena Concessions
Personal Services
221-4-5430-4103 Part-time Pay 20,900.00 224.75 9,651.40 46.18 11,248.60
221-4-5930-4104 PERA 200.00 0.00 176.50 88.25 23.50
221-4-5430-4105 FICA 1,300.00 13.93 655.88 50.45 644.12
221-4-5430-4107 Medicare 300.00 3.26 153.40 51.13 146.60
TOTAL Personal Services 22,700.00 241.94 10,637.18 46.86 12,062.82
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 0.00 15,988.82 73.76 5,511.18
TOTAL Supplies 24,550.00 0.00 16,917.96 66.88 8,132.04
~ TOTAL Arena Concessions
TOTAL Culture & Recreation
47,250.00 241.94 27,055.14 57.26 20,194.86
864,850.00 49,402.08 359,395.76 41.56 505,954.24
~ TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
864,850.00 49,402.08 359,395.76 41.56 505,459.24
0.00 ( 22,104.21) 21,290.48 ( 21,290.48)
8-10-2011 07:58 AM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
222-PINEWOOD GOLF COURSE
FINANCIAL SUMMARY
REVENUE SUMMARY
Pinewood Golf Course
TOTAL REVENUES
EXPENDITURE SUMMARY
Culture & Recreation
Golf Course
TOTAL Culture & Recreation
TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
CURRENT CURRENT
BUDGET PERIOD
58.33$ OF YEAR COMP.
YEAR TO DATE °s OF BUDGET
ACTUAL BUDGET BALANCE
249,550.00 26,001.78 112,809.95 45.21 136,740.05
249,550.00 26,001.78 112,809.95 45.21 136,790.05
249,550.00 22,196.36 123,491.43 49.99 126,058.57
249,550.00 22,196.36 123,491.43 49.49 126,058.57
249,550.00 22,196.36 123,491.43 49.49 126,058.57
0.00 3,805.92 ( 10,681.48) 10,681..48
B-10-2011 07:58 AM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
222-PINEWOOD GOLF COURSE
REVENUES
58.33°s 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-3975 Building Rent
222-3-0000-3976 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 113.00 16,774.50 98.67 225.50
19,000.00 3,269.38 8,485.75 44.66 10,519.25
5,000.00 671.30 1,878.47 37.57 3,121.53
100.00 0.00 0.00 0.00 100.00
120,000.00 17,296.50 55,740.00 46.45 64,260.00
14,000.00 0.00 16,740.03 119.57 ( 2,740.03)
18,500.00 4,226.00 11,277.50 60.96 7,222.50
7,000.00 289.12 1,550.44 22.15 5,949.56
200,600.00 25,865.30 112,446.69 56.06 88,153.31
0.00 100.00 100.00 0.00 ( 100.00)
0.00 100.00 100.00 0.00 ( 100.00)
0.00 36.98 263.26 0.00 ( 263.26)
0.00 36.48 263.26 0.00 ( 263.26)
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 26,001.78 112,809.95 45.21 136,740.05
TOTAL REVENUE 249,550.00 26,001.78 112,809.95 45.21 136,740.05
8-10-2011 07:58 AM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JULY 31ST, 2011
222-PINEWOOD GOLF COURSE
DEPARTMENTAL EXPENDITURES
CURRENT CURRENT
BUDGET PERIOD
58.33$ OF YEAR COMP.
YEAR TO DATE $ OF BUDGET
ACTUAL BUDGET BALANCE
Golf Course
Personal Services
222-4-5300-9101 Regular Pay 93,650.00 7,031.20 46,229.59 49.36 47,425.91
222-9-5300-9103 Part-time Pay 29,900.00 6,244.40 13,420.85 44.89 16,979.15
222-4-5300-4104 PERA 8,950.00 756.61 3,894.86 43.52 5,055.14
222-4-5300-4105 FICA 7,650.00 817.27 3,797.75 49.64 3,852.25
222-4-5300-4107 Medicare 1,800.00 191.13 888.14 49.34 911.86
222-4-5300-4108 Insurance 10,150.00 958.01 3,206.07 31.59 6,943.93
222-9-5300-4109 Workers Comp 1,400.00 0.00 1,250.00 89.29 150.00
222-4-5300-4110 Re-employment Compensation 0.00 202.41 5,044.66 0.00 ( 5,049.66)
TOTAL Personal Services 153,500.00 15,701.03 77,726.92 50.64 75,773.08
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-4219 Operating Supplies 30,900.00 2,878.59 19,109.08 62.86 11,290.92
222-4-5300-4259 Other Merchandise For Resale 14,500.00 1,236.49 5,113.59 35.27 9,386.91
TOTAL Supplies 50,400.00 9,115.03 26,325.46 52.23 24,074.54
Other Services & Charges
222-4-5300-4321 Telephone 2,500.00 199.63 1,031.05 91.24 1,468.95
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 639.40 1,289.00 99.15 11.00
222-4-5300-4361 Insurance 11,900.00 0.00 5,296.50 44.51 6,603.50
222-4-5300-4389 Utilities 7,150.00 533.89 1,731.27 24.21 5,418.73
222-4-5300-4401 Bldg Repair/Maint Services 2,300.00 20.04 1,402.30 60.97 897.70
222-4-5300-4909 Equip Repair/Maint Services 3,000.00 122.40 2,051.83 68.39 998.17
222-4-5300-4415 Equipment Rental 2,000.00 385.58 1,029.09 51.45 970.91
222-4-5300-4437 Taxes & Licenses 1,000.00 ( 1,744.16)( 2,686.75) 268.68- 3,686.75
222-4-5300-4438 Credit Card Fees 5,500.00 807.52 2,422.49 44.05 3,077.51
TOTAL Other Services & Charges 37,150.00 964.30 13,775.05 37.08 23,374.95
Capital Outlay
Debt Service
222-4-5300-4601 Principal 8,500.00 1,416.00 5,664.00 66.64 2,836.00
TOTAL Debt S ervice 8,500.00 1,416.00 5,664.00 66.64 2,836.00
TOTAL Golf Course 249,550.00 22,196.36 123,491.43 49.49 126,058.57
TOTAL Culture & Recreation
249,550.00 22,196.36 123,491.43 49.49 126,058.57
~ TOTAL EXPENDITURES
REVENUES OVER/(UNDER) EXPENDITURES
249,550.00 22,196.36 123,491.43 49.49 126,058.57
0.00 3,805.42 ( 10,681.48) 10,681.48
~ .-. ~ .-. n
01 r 01 01 W l11 W Ol O VI Ill ~O r M N H M Ul O lp d' N N O O M 01 N N W W Ifl lp M O N lD r W N II .-.
O y~ lD N
H tp H r d' d' l0 d' 0 0 l0 M H N r O W O1 O M W W N O 1f1 r W N M W r W H dI ~0 C C N M N II M ~D Ill N
E...I W
U
7 II
r M d' ~D N Ifl lfl O O W r If1 ~D '-1 W N 01 l0 O M N N N O r N r O~ Ifl N N r r-I O W N C' O ~-1 O~ II
W W O~ 01
.
[~ [~] r Ol r IO 01 H r M 01 ~O r If1 O N O Ol W .-1 O O Ul W Ol M M r 0 Ifl N r r W If1 Ol 01 O H N O II l0 d' W O
~
~ Ik 10 O to W Ifl lD N M C Ill N H O N r Ol d' 01 O r M r N [M d' 01 01 r W 0~ H H M W W M O' Ill II
II W Lft H N
(Nc~
a / W r H T W O H 1f1 QI N M d' r 1D d' r M~ U1 O1 W H O r V) H M O Q~ N 01 W M N H W O N ~1 II 1f1 W N al
U P7 N N M H H M H W C O H O N C H C H N N r H W H W r l0 Ol H d' ~O dl W 111 O d' Ol r II W W W r
s>' C Ol lO H M C M M r H Vl H M S C N N W O N H Vl ~O H 111 d' II
II W r M d~
-
~ ,i ri rn ,-1 vi c ~-i m y o n r vi W o
C II N H N C
_ _ _ _ _ _ II
M H r l0 01 01 D H O W W N N .-I d' N 0 0 0 01 M d' W o o r N 01 l0 O d' M lf1 O N ~D M r 0 H II
Ifl d' O H
t0 l11 Ol Ol r W O r 0 H O M O lp lp N O O O d' H C' O O O N O r lfl O W 1f) H 0~ C N lp N O C II N W O C
~~--II ~
7.1 H 11
H N H Lf1 Ill 01 O W O O lp M N N 01 Ifl O O O l0 N lp M O O C' W N W O If1 O7 0 ID cM lD d' O O 0~ II
O O O 0~
,
W H 01 r C' Ol Vl W N d' 111 W d' r H H O l0 01 O In O1 W If1 N H O H C N~ H H r H r M II r M M
',] N H W lp M N M lp N M r N 01 Ifl N Ol W O M N H l0 O O M W Ol W W O N M M N II
it r Ifl N
H
H M lf1 r M H M O 01 N N N M C N M M W C N N d~ Ol 111 O H M M O 01 lf1 O ~ II C' O d'
U lp N ~0 H O W C' H M H H H r H 01 d' l11 N W W M C M II r C M
a' N H M H H H N 41 II
• II r W Ol
-
~ H II
... ~ ~ ~ ~. .... .... ._. .... `. -.. ~ II N H
_ _ II
N lfl r l0 W O O r r W O1 V' H O1 M 111 O r H W cr O O 10 H M lp W C W H M N H O1 O W H II
~
N O lp H
U' D
N
W r~i N r N 1f1 l0 N O W Ill lp H W H r W Ol O W r M H O If1 V' Ol w r W 01 M O If1 O r O O M W II
II O W Ifl W
z W
H U ~ ~
W H N N W Ifl N O1 O r H W W M 01 01 01 lp O lp O lp 01 O r W N \0 10 N \D r H M M W O1 O H O1 II W r Q~ 01
~D N M l0 d' N r N 01 N N M d' N W r W H O M l0 r M Ol M d' M W M Ifi N N ~O If1 H O r Ol l0 II
r W d' r N N N W W N 41 d' M O H O d' V' O W M 41 N M d' H H N r W r M N N N~ 0 r N II Ol H W lD
O O H N
01 H
01 H C~ - - - - - - - - - - - - - - - - - - - - - 11
W M ~O r N O1 H W 01 If) M l0 41 01 H M M N N lp W N l0 Ifl r M l0 C N 01 H H dI 01 M O C N Ill II
H W N Ill
01 H W W N 41 N dI H M r W M Ol H O If1 ~D H C r N C C Ol lD H O' Ol r H dI H If1 C lf1 N Ol H 01 C II H C W d'
(Z O CQ H C Ol l0 H N Ill M M ~0 rl H H H M N N H W M N H V' r H 111 lf1 II
- - - - II H Ol M 1f1
- - -
r.' N
5 -
1f7 r.l ~-i M rl U1 C rl C yI W II N VI W W
H M I I N H N M
a w r' _. ~ ., ~. 11
N
x H M
a a
w o r
a
x ~
o v N S+
~ N N O C R b1 a N m C
m Sr
>~
ry w
H U O i
N W O !Y, ~ Itl a~ E io N
Sa u A ui
N
u p
p
w x aCi m u u al ~.~+ ~~ 3
O 7 A ro a 9 H v >
q rn .
a
U O C ro
£ x
O x
W a
p f%I N E N N ~
~ >r N W S
W m N m N G W N
a
ro ro ro ro w O > 3a ~ a E~ 3 ~+ u
u~ m~ (ll
w F
p w
W b w v 7 ?I
ro ~ R!; +~ C W ~-I N u: +~ rt C C C C 16 Sa u O N YI N N N trl A H rn U
a In O rt O 1f al !L' _~ a N 0 0 0 0 vl cC m Sa u H a' 7> C b1 W W
N 7 U' C O U C C C uI N > W W LT! al A a7 W E 3 v ,! N~ x x a~i 1+
m a v o v b1 w v L O F W
w H w m v _~
I
a ro N ro ~+,-1 o ro E u ro s+ v v q
o q
~ a H
of ro v N a
H
~~ ~
~°
~
u °u w o
Z u
u
O1
i
o
v
a
a~ >, v o .,, v ~+ .~ a o a~ c~ o m u
v
°
H
C°w
~
w
Q
°
a
°
~
~
O
U~ v o m s
+
a ro
, ~
s,a~Cal¢uau~v rt
i
li
ww o
,-
° ~ road 3~ a
~
Z
l~ v S1 N U X ro ro fa Q U) ~rl ~ J-I bl N Ol M If/ r N lp N w >. ~ri 2i l1 ?G 1J ~ A O) N
w w m >a ll >
~
u '.>". x H
x
M
.I
u a .n v q >~ a a u w> a m>~> w m o 0 0 0 0, w >a ~+ „ ~r
I H v ro g o ++ v [>: m o 0 0 o m H 1.1 p •.a m ro H H rt ~~+ m q v
~
+
~
+ l
ro ro ro ~ ~ a
~
v v
.
u
.
+
~
v1 c~ a H a cn a a a E ca Q u H c~ Q m c~ H N N N N H H m Ul U w~ H a H H S a C~ H (] v w
a x
o a
~
v I
I I I I I I I I I I I I I I I I I I I I I I I I I
a w
a a °
~ x ~x c,c,C,Cxx~x.c.c.,~.~ Cx.c.c.ax >~ C c~ C.cx.c~ C.a ~x~.cx.~ ~ x
N N
/ O a
~C
d (
a
N N W N UI W VI N N W W f11 N N W N U] W W W Vl N N N Vl W U] N W Ul W W Ul W UI Ul W
~ p ~
m i u u u u u u v u u u v u v u u u v
u u u u u u u u u u u u u u u v u u u u u ~ c a
~
,~
z
I ~
O x o
~
x
z
o H N u
o 0 0
~
H FC O O O
H O
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 0 0 0 o W H H H
H
O U 2 'i H H H H H H H H H H rl r-1 H H H H r-1 H .-+ H H H H H H H H .~ H H H H H H H H H H
' I I I H
N RC O O O 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 Zi m m of O
O H H H H H H H H H ~-+ H H .-1 H H H H r-1 H H H H H H H H H H H H H H H H H H H H H
~ I I 1 I 1 I I I 1 I I 1 I I I I I I I I I i I I I I I I 1 I I 1 I I I I I I II--~~
01 N M N H H RC
l
r O l
I H
~
' 01 O1 01 H
01 Ol Ol
H (] D
p
lp O
H N H H H N M Ifl W H O H Ifl O H N dl l71 ~D W H N M M M Ifl M V
Ifl N O O O O N H
i
N
'
I .
~lJ (1f
I
jZ r O O O r
O O i-1 N N N N N M d' C C 01 01 a1 Ul a1 O~ O rl .-I r-1 M V
N
C
y
N N N N N N N N N N N N N N N M M M M M M M C C d' d' d' C d' dl d' l0 l0 lD W W O
H
~ R
C
[
y
W O
N U