INFORMATION 02-18-2014 0
City
EIE)k Memorandum
..
RiVer
To: Mayor and City Council
From: Tim Simon, Finance Director
Date: February 18,2014
Subject: January 2014,Monthly Financial Report
This report is designed to provide summary information regarding the overall level of
revenues and expenditures in the General Fund and Ice Arena and Pinewood Golf Special
Revenue Funds. These funds provide an important picture of the city's financial health.
For the month of January, actual revenues (except for property taxes and state aids) and
expenditures should run slightly over 8% 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
Revenues.-
■ Property taxes, our largest revenue source,will be received in July and December.
■ Charges for services include the semiannual billing for the school liaison officer.
■ Contributions include the $14,000 donation by The Bank of Elk River for the 2014
parks and recreation programs.
■ The negative interest income is related to the reversal of the prior year's interest
receivable which was done as of January.
■ The transfers in will be recorded mid-year.
Expenditures:
• Excluding transfers, total departmental expenditures are about 7.5% of budget and
most departments are within or below budget.
• Many departments' expenditures include the first quarter allocation of liability and
workers comp insurance and annual software maintenance agreements, as is the case
for Mayor& Council, Finance and Police Administration.
■ The Snow Removal budget reflects the seasonal expenditures for personal services.
■ The Transfer Out to Pinewood Golf will be made at the end of the year.
W I HE0 8 P
2014 Monthly Expenditures
$14,000
$12,000
o $10,000 ...
z
vai $8,000
0 000
$6,000
$4,000
$2,000
$ an Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
iiiiiiiiiiiiiiiiiiiiiillillilillillillilI Actual $962
Budget $1,073 $2,146 $3,219 $4,292 $5,365 $6,438 $7,511 $8,584 $9,657 $10,730$11,803 $12,876
ICE ARENA
For January,revenues exceed expenditures by$4,744. Revenues are about 5% of budget
and consist mainly of hockey admissions,hockey registration fees and concessions. January
ice rentals will be billed in early February. Expenditures are 3.5% of budget and attributable
mainly to personal services and insurance.
PINEWOOD GOLF
Revenues consist of early recreation registration fees,but golf revenues will not be generated
until early spring. Expenditures are slightly over 3% of the budget due mainly to personal
services and insurance.
ATTACHMENTS
■ General Fund Revenue& Expense Report
■ Enterprise Funds—Budget to Actual
■ Cash Report—All Funds
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
FINANCIAL SUMMARY 08.33° OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SUMMARY
General Fund 12,870,500.00 57,718.19 57,718.19 0.45 12,812,781.81
TOTAL REVENUES 12,870,500.00 57,718.19 57,718.19 0.45 12,812,781.81
EXPENDITURE SUMMARY
General Government
Mayor & Council 150,550.00 13,639.83 13,639.83 9.06 136,910.17
Cable TV 93,000.00 6,657.87 6,657.87 7.16 86,342.13
Administrative Services 594,000.00 45,064.81 45,064.81 7.59 548,935.19
Human Resources 96,000.00 6,993.04 6,993.04 7.28 89,006.96
Elections 38,750.00 0.00 0.00 0.00 38,750.00
Finance 560,850.00 57,196.22 57,196.22 10.20 503,653.78
Information Technology 297,600.00 25,846.20 25,846.20 8.68 271,753.8C
Legal 218,000.00 0.00 0.00 0.00 218,000.00
Community Development 325,500.00 24,003.46 24,003.46 7.37 301,496.54
Planning 192,500.00 13,196.73 13,196.73 6.86 179,303.27
City Hall Maintenance 544,950.00 40,055.48 40,055.48 7.35 504,894.52
Contingency 47,500.00) 0.00 0.00 0.00 ( 47,500.00)
TOTAL General Government 3,064,200.00 232,653.64 232,653.64 7.59 2,831,546.36
Public Safety
Police Administration 629,650.00 95,353.52 95,353.52 15.14 534,296.48
Patrol 2,428,450.00 164,598.93 164,598.93 6.78 2,263,851.07
Investigations 807,050.00 54,019.87 54,019.87 6.69 753,030.13
Police Support Services 526,300.00 36,843.68 36,843.68 7.00 489,456.32
Police Reserves 20,700.00 967.97 967.97 4.68 19,732.03
Public safety building 63,050.00 2,437.25 2,437.25 3.87 60,612.7E
Fire Administration 372,450.00 20,918.69 20,918.69 5.62 351,531.31
Fire Operations 391,450.00 21,780.58 21,780.58 5.56 369,669.42
Emergency Management 24,150.00 ( 26.20) ( 26.20) 0.11- 24,176.2C
Building Safety 617,950.00 43,127.11 43,127.11 6.98 574,822.89
Code Enforcement 88,600.00 6,439.12 6,439.12 7.27 82,160.88
Environmental 31,800.00 149.50 149.50 0.47 31,650.5C
TOTAL Public Safety 6,001,600.00 446,610.02 446,610.02 7.44 5,554,989.98
Public Works
Street Maintenance 1,239,750.00 78,803.16 78,803.16 6.36 1,160,946.84
Snow Removal 277,750.00 51,520.98 51,520.98 18.55 226,229.02
Equipment Services 184,150.00 14,292.94 14,292.94 7.76 169,857.06
Engineering 166,850.00 14,545.60 14,545.60 8.72 152,304.4C
TOTAL Public Works 1,868,500.00 159,162.68 159,162.68 8.52 1,709,337.32
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
FINANCIAL SUMMARY 08.33° OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
Culture & Recreation
Parks Department 938,450.00 52,113.89 52,113.89 5.55 886,336.11
Parks & Rec Admin 531,800.00 40,869.72 40,869.72 7.69 490,930.28
Recreation Programs 200,200.00 4,133.04 4,133.04 2.06 196,066.96
Sr Citizen Programs 193,550.00 14,627.15 14,627.15 7.56 178,922.85
TOTAL Culture & Recreation 1,864,000.00 111,743.80 111,743.80 5.99 1,752,256.2C
Economic Development
Economic Development 0.00 12,067.19 12,067.19 0.00 ( 12,067.19)
Energy City 12,100.00 0.00 0.00 O.00 12,100.00
TOTAL Economic Development 12,100.00 12,067.19 12,067.19 99.73 32.81
General
Transfers Out 60,100.00 0.00 0.00 O.00 60,100.00
TOTAL General 60,100.00 0.00 0.00 O.00 60,100.00
TOTAL EXPENDITURES 12,870,500.00 962,237.33 962,237.33 7.48 11,908,262.67
REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 904,519.14) ( 904,519.14) 904,519.14
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
08.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,181,300.00 37.75 37.75 0.00 9,181,262.2E
101-3-0000-3121 Gravel Tax 125,000.00 0.00 0.00 0.0C 125,000.00
TOTAL Taxes 9,306,300.00 37.75 37.75 0.00 9,306,262.2E
Licenses & Permits
101-3-0000-3211 Liquor License 62,000.00 0.00 0.00 0.00 62,000.00
101-3-0000-3212 Amusement License 1,400.00 0.00 0.00 0.00 1,400.00
101-3-0000-3213 Cigarette License 3,000.00 0.00 0.00 0.00 3,000.00
101-3-0000-3214 Apartment License 27,000.00 650.00 650.00 2.41 26,350.00
101-3-0000-3216 Mining License 21,000.00 0.00 0.00 0.00 21,000.00
101-3-0000-3217 Garbage Hauler License 2,000.00 165.00 165.00 8.25 1,835.00
101-3-0000-3218 Other Business License/Permit 16,500.00 340.00 340.00 2.06 16,160.00
101-3-0000-3229 NPDES Permit 5,000.00 350.00 350.00 7.00 4,650.00
101-3-0000-3231 Building Permit 230,000.00 5,595.15 5,595.15 2.43 224,404.8E
101-3-0000-3232 Plumbing/Heating Permit 190,000.00 4,042.53 4,042.53 2.13 185,957.47
101-3-0000-3233 Permit Surcharge 2,000.00 507.69 507.69 25.38 1,492.31
101-3-0000-3235 Animal License 6,000.00 742.00 742.00 12.37 5,258.00
101-3-0000-3236 Parking Permit 1,500.00 420.00 420.00 28.00 1,080.00
101-3-0000-3237 Other Non-Business Lic/Permit 8,500.00 ( 20.00) ( 20.00) 0.24- 8,520.00
TOTAL Licenses & Permits 575,900.00 12,792.37 12,792.37 2.22 563,107.63
Intergovernmental Rev
101-3-0000-3324 PERA Aid 14,100.00 0.00 0.00 0.00 14,100.00
101-3-0000-3325 Police 20 Aid 220,000.00 0.00 0.00 0.00 220,000.00
101-3-0000-3326 Police Training Reimb 11,400.00 0.00 0.00 0.00 11,400.00
101-3-0000-3329 State Crime Prevention Grant 30,000.00 0.00 0.00 0.00 30,000.00
101-3-0000-3330 Other State Grants 2,400.00 0.00 0.00 O.00 2,400.00
TOTAL Intergovernmental Rev 277,900.00 0.00 0.00 0.00 277,900.00
Charges for Services
101-3-0000-3412 Planning & Zoning Fees 12,000.00 1,775.00 1,775.00 14.79 10,225.00
101-3-0000-3413 Plan Check Fee 90,000.00 2,220.83 2,220.83 2.47 87,779.17
101-3-0000-3415 Special Assessment Search 1,000.00 0.00 0.00 0.00 1,000.00
101-3-0000-3417 Copies 2,600.00 121.75 121.75 4.68 2,478.2E
101-3-0000-3418 Other General Govt Services 4,000.00 0.00 0.00 0.00 4,000.00
101-3-0000-3430 Lockout Fees 7,500.00 660.00 660.00 8.80 6,840.00
101-3-0000-3431 Police Services 4,000.00 40.00 40.00 1.00 3,960.00
101-3-0000-3432 School Liaison 99,300.00 37,500.00 37,500.00 37.76 61,800.00
101-3-0000-3434 Animal Impound Fee 3,500.00 150.00 150.00 4.29 3,350.00
101-3-0000-3436 Fire Contracts 201,000.00 0.00 0.00 0.00 201,000.00
101-3-0000-3437 Fire Services 4,000.00 38.20 38.20 0.96 3,961.8C
101-3-0000-3438 Fire Inspections 14,000.00 0.00 0.00 0.00 14,000.00
101-3-0000-3451 Street Services 29,000.00 685.00 685.00 2.36 28,315.00
101-3-0000-3452 Engineering Services Reimb 87,350.00 0.00 0.00 0.00 87,350.00
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 4
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
08.33° OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE
101-3-0000-3461 Recreation Fees 125,000.00 5,197.75 5,197.75 4.16 119,802.2E
101-3-0000-3462 Sr Center Activities 20,050.00 4,104.00 4,104.00 20.47 15,946.00
101-3-0000-3472 Park Use Fee 20,800.00 925.00 925.00 4.45 19,875.00
101-3-0000-3475 Building Rent 2,400.00 200.00 200.00 8.33 2,200.00
101-3-0000-3483 Sewer Inspection Fee 4,900.00 455.00 455.00 9.29 4,445.00
101-3-0000-3484 Contractor License Check 400.00 30.00 30.00 7.5C 370.00
TOTAL Charges for Services 732,800.00 54,102.53 54,102.53 7.38 678,697.47
Fines & Forfeits
101-3-0000-3510 Court Fines 110,000.00 0.00 0.00 0.00 110,000.00
101-3-0000-3511 Parking Fines 12,000.00 1,420.00 1,420.00 11.83 10,580.00
101-3-0000-3512 Ordinance Violations 200.00 0.00 0.00 O.00 200.00
TOTAL Fines & Forfeits 122,200.00 1,420.00 1,420.00 1.16 120,780.00
Special Assessments
101-3-0000-3610 Special Assmts-County 0.00 74.07 74.07 O.00 ( 74.07)
TOTAL Special Assessments 0.00 74.07 74.07 0.00 ( 74.07)
Other Revenue
101-3-0000-3621 Interest Income 85,000.00 ( 24,900.17) ( 24,900.17) 29.29- 109,900.17
101-3-0000-3625 Refunds & Reimbursements 101,000.00 0.00 0.00 0.00 101,000.00
101-3-0000-3626 Contributions 15,000.00 14,000.00 14,000.00 93.33 1,000.00
101-3-0000-3629 Miscellaneous Revenue 6,000.00 191.64 191.64 3.19 5,808.36
TOTAL Other Revenue 207,000.00 ( 10,708.53) ( 10,708.53) 5.17- 217,708.53
Transfers In
101-3-0000-3921 Transfers 222,850.00 0.00 0.00 0.00 222,850.00
101-3-0000-3925 Transfer-Landfill 53,150.00 0.00 0.00 0.00 53,150.00
101-3-0000-3929 Transfer-NSP/RDF Reserve 39,500.00 0.00 0.00 0.00 39,500.00
101-3-0000-3930 Transfer-Development 48,600.00 0.00 0.00 0.00 48,600.00
101-3-0000-3942 Transfer-WWTS 98,650.00 0.00 0.00 0.00 98,650.00
101-3-0000-3943 Transfer-Liquor 361,850.00 0.00 0.00 0.00 361,850.00
101-3-0000-3944 Transfer-Garbage 43,150.00 0.00 0.00 0.00 43,150.00
101-3-0000-3945 Transfer-Utilities 725,900.00 0.00 0.00 0.00 725,900.00
101-3-0000-3948 Transfer-EDA 31,900.00 0.00 0.00 0.00 31,900.00
101-3-0000-3949 Transfer-HRA 22,850.00 0.00 0.00 O.00 22,850.00
TOTAL Transfers In 1,648,400.00 0.00 0.00 0.00 1,648,400.00
TOTAL General Fund 12,870,500.00 57,718.19 57,718.19 0.45 12,812,781.81
TOTAL REVENUE 12,870,500.00 57,718.19 57,718.19 0.45 12,812,781.81
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE:
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
General Government 08.33° OF YEAR COMP.
Mayor & Council
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-1110-4103 Part-time Pay 38,500.00 3,207.99 3,207.99 8.33 35,292.01
101-4-1110-4104 PERA 1,900.00 70.84 70.84 3.73 1,829.16
101-4-1110-4105 FICA 2,400.00 147.24 147.24 6.14 2,252.76
101-4-1110-4107 Medicare 550.00 46.51 46.51 8.46 503.49
101-4-1110-4109 Workers Comp 100.00 19.00 19.00 19.00 81.00
TOTAL Personal Services 43,450.00 3,491.58 3,491.58 8.04 39,958.42
Supplies
101-4-1110-4201 Office Supplies 1,800.00 0.00 0.00 O.00 1,800.00
TOTAL Supplies 1,800.00 0.00 0.00 0.00 1,800.00
Other Services & Charges
101-4-1110-4319 Other Professional Services 10,400.00 0.00 0.00 0.00 10,400.00
101-4-1110-4322 Postage 400.00 0.00 0.00 0.00 400.00
101-4-1110-4331 Travel, Conferences & Schools 3,100.00 0.00 0.00 0.00 3,100.00
101-4-1110-4359 Publishing 3,700.00 0.00 0.00 0.00 3,700.00
101-4-1110-4361 Insurance 57,500.00 10,048.25 10,048.25 17.48 47,451.7E
101-4-1110-4433 Dues & Subscriptions 17,550.00 0.00 0.00 0.00 17,550.00
101-4-1110-4440 Miscellaneous 12,650.00 100.00 100.00 0.79 12,550.00
TOTAL Other Services & Charges 105,300.00 10,148.25 10,148.25 9.64 95,151.7E
Capital Outlay
TOTAL Mayor & Council 150,550.00 13,639.83 13,639.83 9.06 136,910.17
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 6
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
General Government 08.33° OF YEAR COMP.
Cable TV
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-1120-4101 Regular Pay 60,900.00 4,216.32 4,216.32 6.92 56,683.68
101-4-1120-4103 Part-time Pay 6,900.00 265.20 265.20 3.84 6,634.8C
101-4-1120-4104 PERA 4,400.00 506.16 506.16 11.50 3,893.84
101-4-1120-4105 FICA 4,200.00 402.14 402.14 9.57 3,797.86
101-4-1120-4107 Medicare 1,000.00 94.04 94.04 9.40 905.96
101-4-1120-4108 Insurance 13,200.00 1,102.01 1,102.01 8.35 12,097.99
101-4-1120-4109 Workers Comp 300.00 72.00 72.00 24.00 228.00
TOTAL Personal Services 90,900.00 6,657.87 6,657.87 7.32 84,242.13
Supplies
101-4-1120-4201 Office Supplies 750.00 0.00 0.00 O.00 750.00
TOTAL Supplies 750.00 0.00 0.00 0.00 750.00
Other Services & Charges
101-4-1120-4322 Postage 50.00 0.00 0.00 0.00 50.00
101-4-1120-4331 Travel, Conferences & Schools 1,150.00 0.00 0.00 0.00 1,150.00
101-4-1120-4404 Equip Repair/Maint Services 150.00 0.00 0.00 O.00 150.00
TOTAL Other Services & Charges 1,350.00 0.00 0.00 0.00 1,350.00
Capital Outlay
TOTAL Cable TV 93,000.00 6,657.87 6,657.87 7.16 86,342.13
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 7
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
General Government 08.33° OF YEAR COMP.
Administrative Services
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-1210-4101 Regular Pay 372,250.00 25,673.02 25,673.02 6.90 346,576.98
101-4-1210-4103 Part-time Pay 45,600.00 2,901.26 2,901.26 6.36 42,698.74
101-4-1210-4104 PERA 30,300.00 3,429.01 3,429.01 11.32 26,870.99
101-4-1210-4105 FICA 25,900.00 2,868.55 2,868.55 11.08 23,031.4E
101-4-1210-4107 Medicare 6,050.00 670.86 670.86 11.09 5,379.14
101-4-1210-4108 Insurance 33,650.00 3,064.05 3,064.05 9.11 30,585.9E
101-4-1210-4109 Workers Comp 1,750.00 432.25 432.25 24.7C 1,317.75
TOTAL Personal Services 515,500.00 39,039.00 39,039.00 7.57 476,461.00
Supplies
101-4-1210-4201 Office Supplies 10,250.00 0.00 0.00 O.00 10,250.00
TOTAL Supplies 10,250.00 0.00 0.00 0.00 10,250.00
Other Services & Charges
101-4-1210-4319 Other Professional Services 11,100.00 330.00 330.00 2.97 10,770.00
101-4-1210-4321 Telephone 1,100.00 1.00 1.00 0.09 1,099.00
101-4-1210-4322 Postage 1,000.00 0.00 0.00 0.00 1,000.00
101-4-1210-4331 Travel, Conferences & Schools 8,900.00 19.41 19.41 0.22 8,880.59
101-4-1210-4334 Car Allowance 4,800.00 400.00 400.00 8.33 4,400.00
101-4-1210-4359 Publishing 12,000.00 3,071.00 3,071.00 25.59 8,929.00
101-4-1210-4361 Insurance 200.00 30.25 30.25 15.13 169.7E
101-4-1210-4404 Equip Repair/Maint Services 27,400.00 1,904.15 1,904.15 6.95 25,495.8E
101-4-1210-4433 Dues & Subscriptions 1,750.00 270.00 270.00 15.43 1,480.00
TOTAL Other Services & Charges 68,250.00 6,025.81 6,025.81 8.83 62,224.19
Capital Outlay
TOTAL Administrative Services 594,000.00 45,064.81 45,064.81 7.59 548,935.19
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 8
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
General Government 08.33° OF YEAR COMP.
Human Resources
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-1220-4101 Regular Pay 72,000.00 4,984.83 4,984.83 6.92 67,015.17
101-4-1220-4104 PERA 5,200.00 631.70 631.70 12.15 4,568.3C
101-4-1220-4105 FICA 4,450.00 526.87 526.87 11.84 3,923.13
101-4-1220-4107 Medicare 1,050.00 123.22 123.22 11.74 926.78
101-4-1220-4108 Insurance 6,750.00 651.92 651.92 9.66 6,098.08
101-4-1220-4109 Workers Comp 300.00 74.50 74.50 24.83 225.5C
TOTAL Personal Services 89,750.00 6,993.04 6,993.04 7.79 82,756.96
Supplies
101-4-1220-4201 Office Supplies 850.00 0.00 0.00 O.00 850.00
TOTAL Supplies 850.00 0.00 0.00 0.00 850.00
Other Services & Charges
101-4-1220-4319 Other Professional Services 1,000.00 0.00 0.00 0.00 1,000.00
101-4-1220-4322 Postage 500.00 0.00 0.00 0.00 500.00
101-4-1220-4331 Travel, Conferences & Schools 3,000.00 0.00 0.00 0.00 3,000.00
101-4-1220-4433 Dues & Subscriptions 900.00 0.00 0.00 O.00 900.00
TOTAL Other Services & Charges 5,400.00 0.00 0.00 0.00 5,400.00
Capital Outlay
TOTAL Human Resources 96,000.00 6,993.04 6,993.04 7.28 89,006.96
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 9
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
General Government 08.33° OF YEAR COMP.
Elections
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-1230-4103 Part-time Pay 30,000.00 0.00 0.00 O.00 30,000.00
TOTAL Personal Services 30,000.00 0.00 0.00 0.00 30,000.00
Supplies
101-4-1230-4219 Operating Supplies 4,800.00 0.00 0.00 O.00 4,800.00
TOTAL Supplies 4,800.00 0.00 0.00 0.00 4,800.00
Other Services & Charges
101-4-1230-4322 Postage 600.00 0.00 0.00 0.00 600.00
101-4-1230-4331 Travel, Conferences & Schools 500.00 0.00 0.00 0.00 500.00
101-4-1230-4359 Publishing 1,400.00 0.00 0.00 0.00 1,400.00
101-4-1230-4404 Equip Repair/Maint Services 100.00 0.00 0.00 0.00 100.00
101-4-1230-4415 Equipment Rental 1,350.00 0.00 0.00 O.00 1,350.00
TOTAL Other Services & Charges 3,950.00 0.00 0.00 0.00 3,950.00
Capital Outlay
TOTAL Elections 38,750.00 0.00 0.00 0.00 38,750.00
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: It
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
General Government 08.33° OF YEAR COMP.
Finance
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-1310-4101 Regular Pay 305,450.00 21,144.69 21,144.69 6.92 284,305.31
101-4-1310-4103 Part-time Pay 51,300.00 4,216.32 4,216.32 8.22 47,083.68
101-4-1310-4104 PERA 25,850.00 3,011.15 3,011.15 11.65 22,838.8E
101-4-1310-4105 FICA 22,100.00 2,512.96 2,512.96 11.37 19,587.04
101-4-1310-4107 Medicare 5,200.00 587.71 587.71 11.30 4,612.29
101-4-1310-4108 Insurance 32,250.00 2,599.70 2,599.70 8.06 29,650.3C
101-4-1310-4109 Workers Comp 1,500.00 369.00 369.00 24.6C 1,131.00
TOTAL Personal Services 443,650.00 34,441.53 34,441.53 7.76 409,208.47
Supplies
101-4-1310-4201 Office Supplies 10,400.00 5,000.00 5,000.00 48.08 5,400.00
TOTAL Supplies 10,400.00 5,000.00 5,000.00 48.08 5,400.00
Other Services & Charges
101-4-1310-4301 Audit Fees 18,450.00 2,400.00 2,400.00 13.01 16,050.00
101-4-1310-4319 Other Professional Services 56,000.00 0.00 0.00 0.00 56,000.00
101-4-1310-4321 Telephone 400.00 14.57 14.57 3.64 385.43
101-4-1310-4322 Postage 2,300.00 0.00 0.00 0.00 2,300.00
101-4-1310-4331 Travel, Conferences & Schools 2,800.00 1,311.61 1,311.61 46.84 1,488.39
101-4-1310-4359 Publishing 600.00 0.00 0.00 0.00 600.00
101-4-1310-4404 Equip Repair/Maint Services 20,900.00 13,915.51 13,915.51 66.58 6,984.49
101-4-1310-4433 Dues & Subscriptions 1,500.00 0.00 0.00 0.00 1,500.00
101-4-1310-4438 Credit Card Fees 2,500.00 0.00 0.00 0.00 2,500.00
101-4-1310-4440 Miscellaneous 1,350.00 113.00 113.00 8.37 1,237.00
TOTAL Other Services & Charges 106,800.00 17,754.69 17,754.69 16.62 89,045.31
Capital Outlay
TOTAL Finance 560,850.00 57,196.22 57,196.22 10.20 503,653.78
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 11
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
General Government 08.33° OF YEAR COMP.
Information Technology
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-1350-4101 Regular Pay 178,500.00 9,777.20 9,777.20 5.48 168,722.8C
101-4-1350-4104 PERA 12,950.00 1,185.19 1,185.19 9.15 11,764.81
101-4-1350-4105 FICA 11,050.00 965.22 965.22 8.74 10,084.78
101-4-1350-4107 Medicare 2,600.00 225.73 225.73 8.68 2,374.27
101-4-1350-4108 Insurance 32,900.00 1,922.01 1,922.01 5.84 30,977.99
101-4-1350-4109 Workers Comp 650.00 165.25 165.25 25.42 484.75
TOTAL Personal Services 238,650.00 14,240.60 14,240.60 5.97 224,409.4C
Supplies
101-4-1350-4219 Operating Supplies 22,750.00 0.00 0.00 O.00 22,750.00
TOTAL Supplies 22,750.00 0.00 0.00 0.00 22,750.00
Other Services & Charges
101-4-1350-4319 Other Professional Services 6,000.00 0.00 0.00 0.00 6,000.00
101-4-1350-4321 Telephone 2,100.00 0.00 0.00 0.00 2,100.00
101-4-1350-4331 Travel, Conferences & Schools 6,900.00 0.00 0.00 0.00 6,900.00
101-4-1350-4404 Equip Repair/Maint Services 21,200.00 705.60 705.60 3.33 20,494.4C
TOTAL Other Services & Charges 36,200.00 705.60 705.60 1.95 35,494.4C
Capital Outlay
101-4-1350-4560 Equipment 0.00 10,900.00 10,900.00 0.0C ( 10,900.00)
TOTAL Capital Outlay 0.00 10,900.00 10,900.00 0.00 ( 10,900.00)
TOTAL Information Technology 297,600.00 25,846.20 25,846.20 8.68 271,753.8C
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 12
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
General Government 08.33° OF YEAR COMP.
Legal
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
Supplies
Other Services & Charges
101-4-1400-4304 Legal Fees 218,000.00 0.00 0.00 0.0C 218,000.00
TOTAL Other Services & Charges 218,000.00 0.00 0.00 0.00 218,000.00
TOTAL Legal 218,000.00 0.00 0.00 0.00 218,000.00
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 13
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
General Government 08.33° OF YEAR COMP.
Community Development
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-1500-4101 Regular Pay 259,150.00 17,672.90 17,672.90 6.82 241,477.1C
101-4-1500-4104 PERA 18,800.00 2,121.57 2,121.57 11.28 16,678.43
101-4-1500-4105 FICA 16,050.00 1,775.85 1,775.85 11.06 14,274.1E
101-4-1500-4107 Medicare 3,750.00 415.30 415.30 11.07 3,334.7C
101-4-1500-4108 Insurance 20,150.00 1,682.01 1,682.01 8.35 18,467.99
101-4-1500-4109 Workers Comp 1,100.00 268.00 268.00 24.36 832.00
TOTAL Personal Services 319,000.00 23,935.63 23,935.63 7.50 295,064.37
Supplies
101-4-1500-4201 Office Supplies 1,850.00 0.00 0.00 O.00 1,850.00
TOTAL Supplies 1,850.00 0.00 0.00 0.00 1,850.00
Other Services & Charges
101-4-1500-4321 Telephone 1,050.00 0.42 0.42 0.04 1,049.58
101-4-1500-4331 Travel, Conferences & Schools 2,950.00 67.41 67.41 2.29 2,882.59
101-4-1500-4433 Dues & Subscriptions 650.00 0.00 0.00 O.00 650.00
TOTAL Other Services & Charges 4,650.00 67.83 67.83 1.46 4,582.17
TOTAL Community Development 325,500.00 24,003.46 24,003.46 7.37 301,496.54
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 14
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
General Government 08.33° OF YEAR COMP.
Planning
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-1510-4101 Regular Pay 124,950.00 8,569.04 8,569.04 6.86 116,380.96
101-4-1510-4104 PERA 9,050.00 1,025.67 1,025.67 11.33 8,024.33
101-4-1510-4105 FICA 7,750.00 793.87 793.87 10.24 6,956.13
101-4-1510-4107 Medicare 1,800.00 185.66 185.66 10.31 1,614.34
101-4-1510-4108 Insurance 23,050.00 1,922.00 1,922.00 8.34 21,128.00
101-4-1510-4109 Workers Comp 800.00 106.00 106.00 13.25 694.00
TOTAL Personal Services 167,400.00 12,602.24 12,602.24 7.53 154,797.76
Supplies
101-4-1510-4201 Office Supplies 1,400.00 0.00 0.00 O.00 1,400.00
TOTAL Supplies 1,400.00 0.00 0.00 0.00 1,400.00
Other Services & Charges
101-4-1510-4321 Telephone 50.00 0.43 0.43 0.86 49.57
101-4-1510-4322 Postage 2,500.00 0.00 0.00 0.00 2,500.00
101-4-1510-4331 Travel, Conferences & Schools 1,150.00 8.81 8.81 0.77 1,141.19
101-4-1510-4359 Publishing 15,500.00 555.00 555.00 3.58 14,945.00
101-4-1510-4361 Insurance 200.00 30.25 30.25 15.13 169.7E
101-4-1510-4404 Equip Repair/Maint Services 3,650.00 0.00 0.00 0.00 3,650.00
101-4-1510-4433 Dues & Subscriptions 400.00 0.00 0.00 0.00 400.00
101-4-1510-4440 Miscellaneous 250.00 0.00 0.00 O.00 250.00
TOTAL Other Services & Charges 23,700.00 594.49 594.49 2.51 23,105.51
Capital Outlay
TOTAL Planning 192,500.00 13,196.73 13,196.73 6.86 179,303.27
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: lE
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
General Government 08.33° OF YEAR COMP.
City Hall Maintenance
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-1600-4101 Regular Pay 326,000.00 22,477.95 22,477.95 6.90 303,522.0E
101-4-1600-4102 Overtime Pay 3,500.00 0.00 0.00 0.00 3,500.00
101-4-1600-4103 Part-time Pay 3,350.00 0.00 0.00 0.00 3,350.00
101-4-1600-4104 PERA 24,100.00 2,661.93 2,661.93 11.05 21,438.07
101-4-1600-4105 FICA 20,650.00 2,294.03 2,294.03 11.11 18,355.97
101-4-1600-4107 Medicare 4,800.00 536.51 536.51 11.18 4,263.49
101-4-1600-4108 Insurance 40,850.00 2,586.04 2,586.04 6.33 38,263.96
101-4-1600-4109 Workers Comp 10,150.00 2,538.25 2,538.25 25.01 7,611.75
TOTAL Personal Services 433,400.00 33,094.71 33,094.71 7.64 400,305.29
Supplies
101-4-1600-4212 Fuels & Lubes 3,500.00 381.04 381.04 10.89 3,118.96
101-4-1600-4217 Uniform Allowance 1,700.00 0.00 0.00 0.00 1,700.00
101-4-1600-4219 Operating Supplies 29,000.00 4,222.08 4,222.08 14.56 24,777.92
TOTAL Supplies 34,200.00 4,603.12 4,603.12 13.46 29,596.88
Other Services & Charges
101-4-1600-4321 Telephone 11,500.00 631.32 631.32 5.49 10,868.68
101-4-1600-4331 Travel, Conferences & Schools 1,200.00 0.00 0.00 0.00 1,200.00
101-4-1600-4361 Insurance 4,900.00 1,192.00 1,192.00 24.33 3,708.00
101-4-1600-4389 Utilities 30,050.00 0.00 0.00 0.00 30,050.00
101-4-1600-4401 Bldg Repair/Maint Services 24,650.00 446.83 446.83 1.81 24,203.17
101-4-1600-4404 Equip Repair/Maint Services 4,000.00 0.00 0.00 0.00 4,000.00
101-4-1600-4460 Equip Replacement Charge 1,050.00 87.50 87.50 8.33 962.5C
TOTAL Other Services & Charges 77,350.00 2,357.65 2,357.65 3.05 74,992.3E
Capital Outlay
TOTAL City Hall Maintenance 544,950.00 40,055.48 40,055.48 7.35 504,894.52
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 16
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
General Government 08.33° OF YEAR COMP.
Contingency
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-1900-4101 Regular Pay 95,000.00) 0.00 0.00 O.00 ( 95,000.00)
TOTAL Personal Services 95,000.00) 0.00 0.00 0.00 ( 95,000.00)
Other Services & Charges
101-4-1900-4440 Miscellaneous 47,500.00 0.00 0.00 O.00 47,500.00
TOTAL Other Services & Charges 47,500.00 0.00 0.00 0.00 47,500.00
TOTAL Contingency 47,500.00) 0.00 0.00 0.00 ( 47,500.00)
TOTAL General Government 3,064,200.00 232,653.64 232,653.64 7.59 2,831,546.36
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 17
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Safety 08.33° OF YEAR COMP.
Police Administration
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-2110-4101 Regular Pay 341,150.00 23,328.52 23,328.52 6.84 317,821.48
101-4-2110-4104 PERA 48,250.00 5,497.00 5,497.00 11.39 42,753.00
101-4-2110-4105 FICA 3,050.00 277.93 277.93 9.11 2,772.07
101-4-2110-4107 Medicare 3,400.00 382.68 382.68 11.26 3,017.32
101-4-2110-4108 Insurance 33,350.00 3,066.03 3,066.03 9.19 30,283.97
101-4-2110-4109 Workers Comp 51,800.00 12,953.50 12,953.50 25.01 38,846.5C
TOTAL Personal Services 481,000.00 45,505.66 45,505.66 9.46 435,494.34
Supplies
101-4-2110-4201 Office Supplies 10,250.00 0.00 0.00 0.00 10,250.00
101-4-2110-4217 Uniform Allowance 2,800.00 805.00 805.00 28.75 1,995.00
101-4-2110-4219 Operating Supplies 5,250.00 0.00 0.00 O.00 5,250.00
TOTAL Supplies 18,300.00 805.00 805.00 4.40 17,495.00
Other Services & Charges
101-4-2110-4319 Other Professional Services 5,400.00 0.00 0.00 0.00 5,400.00
101-4-2110-4321 Telephone 22,950.00 109.23 109.23 0.48 22,840.77
101-4-2110-4322 Postage 3,000.00 0.00 0.00 0.00 3,000.00
101-4-2110-4331 Travel, Conferences & Schools 5,800.00 0.00 0.00 0.00 5,800.00
101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00
101-4-2110-4361 Insurance 9,300.00 10,813.00 10,813.00 116.27 ( 1,513.00)
101-4-2110-4404 Equip Repair/Maint Services 78,500.00 37,514.63 37,514.63 47.79 40,985.37
101-4-2110-4433 Dues & Subscriptions 4,600.00 450.00 450.00 9.78 4,150.00
101-4-2110-4437 Taxes & Licenses 300.00 156.00 156.00 52.00 144.00
TOTAL Other Services & Charges 130,350.00 49,042.86 49,042.86 37.62 81,307.14
Capital Outlay
TOTAL Police Administration 629,650.00 95,353.52 95,353.52 15.14 534,296.48
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 18
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Safety 08.33° OF YEAR COMP.
Patrol
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-2120-4101 Regular Pay 1,571,300.00 103,053.44 103,053.44 6.56 1,468,246.56
101-4-2120-4102 Overtime Pay 90,000.00 2,878.24 2,878.24 3.20 87,121.76
101-4-2120-4104 PERA 254,200.00 27,138.58 27,138.58 10.68 227,061.42
101-4-2120-4107 Medicare 22,850.00 2,310.72 2,310.72 10.11 20,539.28
101-4-2120-4108 Insurance 174,200.00 15,246.27 15,246.27 8.75 158,953.73
TOTAL Personal Services 2,112,550.00 150,627.25 150,627.25 7.13 1,961,922.7E
Supplies
101-4-2120-4212 Fuels & Lubes 125,000.00 10,433.88 10,433.88 8.35 114,566.12
101-4-2120-4217 Uniform Allowance 19,350.00 0.00 0.00 0.00 19,350.00
101-4-2120-4219 Operating Supplies 63,550.00 34.79 34.79 0.05 63,515.21
101-4-2120-4221 Equipment Parts 23,300.00 475.66 475.66 2.04 22,824.34
TOTAL Supplies 231,200.00 10,944.33 10,944.33 4.73 220,255.67
Other Services & Charges
101-4-2120-4331 Travel, Conferences & Schools 22,750.00 0.00 0.00 0.00 22,750.00
101-4-2120-4404 Equip Repair/Maint Services 25,700.00 60.68 60.68 0.24 25,639.32
101-4-2120-4433 Dues & Subscriptions 650.00 0.00 0.00 0.00 650.00
101-4-2120-4460 Equip Replacement Charge 35,600.00 2,966.67 2,966.67 8.33 32,633.33
TOTAL Other Services & Charges 84,700.00 3,027.35 3,027.35 3.57 81,672.6E
Capital Outlay
TOTAL Patrol 2,428,450.00 164,598.93 164,598.93 6.78 2,263,851.07
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 19
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Safety 08.33° OF YEAR COMP.
Investigations
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-2130-4101 Regular Pay 546,300.00 35,360.37 35,360.37 6.47 510,939.63
101-4-2130-4102 Overtime Pay 45,000.00 1,361.06 1,361.06 3.02 43,638.94
101-4-2130-4104 PERA 90,450.00 9,323.42 9,323.42 10.31 81,126.58
101-4-2130-4107 Medicare 7,300.00 694.79 694.79 9.52 6,605.21
101-4-2130-4108 Insurance 78,400.00 6,249.79 6,249.79 7.97 72,150.21
TOTAL Personal Services 767,450.00 52,989.43 52,989.43 6.90 714,460.57
Supplies
101-4-2130-4217 Uniform Allowance 5,650.00 ( 9.02) ( 9.02) 0.16- 5,659.02
101-4-2130-4219 Operating Supplies 9,200.00 0.00 0.00 O.00 9,200.00
TOTAL Supplies 14,850.00 ( 9.02) ( 9.02) 0.06- 14,859.02
Other Services & Charges
101-4-2130-4319 Other Professional Services 5,500.00 118.63 118.63 2.16 5,381.37
101-4-2130-4331 Travel, Conferences & Schools 6,250.00 0.00 0.00 0.00 6,250.00
101-4-2130-4433 Dues & Subscriptions 1,950.00 0.00 0.00 0.00 1,950.00
101-4-2130-4460 Equip Replacement Charge 11,050.00 920.83 920.83 8.33 10,129.17
TOTAL Other Services & Charges 24,750.00 1,039.46 1,039.46 4.20 23,710.54
Capital Outlay
TOTAL Investigations 807,050.00 54,019.87 54,019.87 6.69 753,030.13
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 2C
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Safety 08.33° OF YEAR COMP.
Police Support Services
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-2150-4101 Regular Pay 328,500.00 24,742.08 24,742.08 7.53 303,757.92
101-4-2150-4102 Overtime Pay 10,000.00 743.53 743.53 7.44 9,256.47
101-4-2150-4103 Part-time Pay 37,950.00 0.00 0.00 0.00 37,950.00
101-4-2150-4104 PERA 27,300.00 2,973.75 2,973.75 10.89 24,326.2E
101-4-2150-4105 FICA 23,350.00 2,453.78 2,453.78 10.51 20,896.22
101-4-2150-4107 Medicare 5,450.00 573.85 573.85 10.53 4,876.1E
101-4-2150-4108 Insurance 48,100.00 4,770.02 4,770.02 9.92 43,329.98
TOTAL Personal Services 480,650.00 36,257.01 36,257.01 7.54 444,392.99
Supplies
101-4-2150-4201 Office Supplies 950.00 0.00 0.00 0.00 950.00
101-4-2150-4217 Uniform Allowance 3,400.00 0.00 0.00 0.00 3,400.00
101-4-2150-4219 Operating Supplies 11,500.00 0.00 0.00 O.00 11,500.00
TOTAL Supplies 15,850.00 0.00 0.00 0.00 15,850.00
Other Services & Charges
101-4-2150-4331 Travel, Conferences & Schools 3,700.00 0.00 0.00 0.00 3,700.00
101-4-2150-4404 Equip Repair/Maint Services 2,200.00 0.00 0.00 0.00 2,200.00
101-4-2150-4409 Contractual Services 16,900.00 0.00 0.00 0.00 16,900.00
101-4-2150-4433 Dues & Subscriptions 500.00 45.00 45.00 9.00 455.00
101-4-2150-4460 Equip Replacement Charge 6,500.00 541.67 541.67 8.33 5,958.33
TOTAL Other Services & Charges 29,800.00 586.67 586.67 1.97 29,213.33
Capital Outlay
TOTAL Police Support Services 526,300.00 36,843.68 36,843.68 7.00 489,456.32
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 21
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Safety 08.33° OF YEAR COMP.
Police Reserves
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-2160-4103 Part-time Pay 5,500.00 899.16 899.16 16.35 4,600.84
101-4-2160-4105 FICA 350.00 55.75 55.75 15.93 294.2E
101-4-2160-4107 Medicare 100.00 13.06 13.06 13.06 86.94
TOTAL Personal Services 5,950.00 967.97 967.97 16.27 4,982.03
Supplies
101-4-2160-4217 Uniform Allowance 5,000.00 0.00 0.00 0.00 5,000.00
101-4-2160-4219 Operating Supplies 3,700.00 0.00 0.00 O.00 3,700.00
TOTAL Supplies 8,700.00 0.00 0.00 0.00 8,700.00
Other Services & Charges
101-4-2160-4319 Other Professional Services 2,100.00 0.00 0.00 0.00 2,100.00
101-4-2160-4321 Telephone 50.00 0.00 0.00 0.00 50.00
101-4-2160-4331 Travel, Conferences & Schools 3,200.00 0.00 0.00 0.00 3,200.00
101-4-2160-4433 Dues & Subscriptions 700.00 0.00 0.00 O.00 700.00
TOTAL Other Services & Charges 6,050.00 0.00 0.00 0.00 6,050.00
Capital Outlay
TOTAL Police Reserves 20,700.00 967.97 967.97 4.68 19,732.03
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 22
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Safety 08.33° OF YEAR COMP.
Public safety building
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
Supplies
101-4-2190-4219 Operating Supplies 17,200.00 452.00 452.00 2.63 16,748.00
TOTAL Supplies 17,200.00 452.00 452.00 2.63 16,748.00
Other Services & Charges
101-4-2190-4361 Insurance 4,850.00 1,129.00 1,129.00 23.28 3,721.00
101-4-2190-4389 Utilities 12,200.00 0.00 0.00 0.00 12,200.00
101-4-2190-4401 Bldg Repair/Maint Services 28,800.00 856.25 856.25 2.97 27,943.75
TOTAL Other Services & Charges 45,850.00 1,985.25 1,985.25 4.33 43,864.7E
Capital Outlay
TOTAL Public safety building 63,050.00 2,437.25 2,437.25 3.87 60,612.7E
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 23
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Safety 08.33° OF YEAR COMP.
Fire Administration
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-2310-4101 Regular Pay 144,300.00 7,189.20 7,189.20 4.98 137,110.8C
101-4-2310-4103 Part-time Pay 29,600.00 1,831.84 1,831.84 6.19 27,768.16
101-4-2310-4104 PERA 22,900.00 2,046.88 2,046.88 8.94 20,853.12
101-4-2310-4105 FICA 1,850.00 192.95 192.95 10.43 1,657.0E
101-4-2310-4106 Other Retirement Contributions 30,000.00 0.00 0.00 0.00 30,000.00
101-4-2310-4107 Medicare 2,500.00 216.38 216.38 8.66 2,283.62
101-4-2310-4108 Insurance 16,550.00 654.81 654.81 3.96 15,895.19
101-4-2310-4109 Workers Comp 5,450.00 1,362.25 1,362.25 25.00 4,087.75
TOTAL Personal Services 253,150.00 13,494.31 13,494.31 5.33 239,655.69
Supplies
101-4-2310-4201 Office Supplies 4,700.00 88.55 88.55 1.88 4,611.4E
101-4-2310-4212 Fuels & Lubes 4,800.00 181.29 181.29 3.78 4,618.71
101-4-2310-4217 Uniform Allowance 1,500.00 0.00 0.00 0.00 1,500.00
101-4-2310-4219 Operating Supplies 700.00 0.00 0.00 0.00 700.00
101-4-2310-4221 Equipment Parts 450.00 0.00 0.00 O.00 450.00
TOTAL Supplies 12,150.00 269.84 269.84 2.22 11,880.16
Other Services & Charges
101-4-2310-4319 Other Professional Services 15,000.00 0.00 0.00 0.00 15,000.00
101-4-2310-4321 Telephone 3,750.00 129.70 129.70 3.46 3,620.3C
101-4-2310-4322 Postage 1,000.00 0.00 0.00 0.00 1,000.00
101-4-2310-4331 Travel, Conferences & Schools 4,500.00 371.10 371.10 8.25 4,128.9C
101-4-2310-4359 Publishing 500.00 0.00 0.00 0.00 500.00
101-4-2310-4361 Insurance 13,900.00 2,761.00 2,761.00 19.86 11,139.00
101-4-2310-4389 Utilities 11,200.00 0.00 0.00 0.00 11,200.00
101-4-2310-4401 Bldg Repair/Maint Services 5,000.00 0.00 0.00 0.00 5,000.00
101-4-2310-4404 Equip Repair/Maint Services 7,900.00 359.41 359.41 4.55 7,540.59
101-4-2310-4433 Dues & Subscriptions 2,000.00 0.00 0.00 0.00 2,000.00
101-4-2310-4460 Equip Replacement Charge 42,400.00 3,533.33 3,533.33 8.33 38,866.67
TOTAL Other Services & Charges 107,150.00 7,154.54 7,154.54 6.68 99,995.46
Capital Outlay
TOTAL Fire Administration 372,450.00 20,918.69 20,918.69 5.62 351,531.31
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 24
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Safety 08.33° OF YEAR COMP.
Fire Operations
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-2320-4103 Part-time Pay 169,700.00 13,813.38 13,813.38 8.14 155,886.62
101-4-2320-4105 FICA 10,500.00 854.90 854.90 8.14 9,645.1C
101-4-2320-4107 Medicare 2,450.00 199.92 199.92 8.16 2,250.08
101-4-2320-4109 Workers Comp 24,150.00 6,042.00 6,042.00 25.02 18,108.00
TOTAL Personal Services 206,800.00 20,910.20 20,910.20 10.11 185,889.8C
Supplies
101-4-2320-4201 Office Supplies 4,100.00 0.00 0.00 0.00 4,100.00
101-4-2320-4212 Fuels & Lubes 7,000.00 704.88 704.88 10.07 6,295.12
101-4-2320-4217 Uniform Allowance 8,000.00 70.00 70.00 0.88 7,930.00
101-4-2320-4219 Operating Supplies 78,350.00 0.00 0.00 0.00 78,350.00
101-4-2320-4221 Equipment Parts 7,250.00 0.00 0.00 O.00 7,250.00
TOTAL Supplies 104,700.00 774.88 774.88 0.74 103,925.12
Other Services & Charges
101-4-2320-4321 Telephone 4,900.00 45.50 45.50 0.93 4,854.5C
101-4-2320-4331 Travel, Conferences & Schools 32,500.00 50.00 50.00 0.15 32,450.00
101-4-2320-4404 Equip Repair/Maint Services 35,550.00 0.00 0.00 0.00 35,550.00
101-4-2320-4409 Contractual Services 7,000.00 0.00 0.00 O.00 7,000.00
TOTAL Other Services & Charges 79,950.00 95.50 95.50 0.12 79,854.5C
Capital Outlay
TOTAL Fire Operations 391,450.00 21,780.58 21,780.58 5.56 369,669.42
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 2E
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Safety 08.33° OF YEAR COMP.
Emergency Management
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
Supplies
101-4-2330-4201 Office Supplies 300.00 0.00 0.00 0.00 300.00
101-4-2330-4219 Operating Supplies 11,900.00 ( 26.20) ( 26.20) 0.22- 11,926.2C
TOTAL Supplies 12,200.00 ( 26.20) ( 26.20) 0.21- 12,226.2C
Other Services & Charges
101-4-2330-4321 Telephone 250.00 0.00 0.00 0.00 250.00
101-4-2330-4331 Travel, Conferences & Schools 7,000.00 0.00 0.00 0.00 7,000.00
101-4-2330-4389 Utilities 500.00 0.00 0.00 0.00 500.00
101-4-2330-4404 Equip Repair/Maint Services 3,900.00 0.00 0.00 0.00 3,900.00
101-4-2330-4433 Dues & Subscriptions 300.00 0.00 0.00 O.00 300.00
TOTAL Other Services & Charges 11,950.00 0.00 0.00 0.00 11,950.00
Capital Outlay
TOTAL Emergency Management 24,150.00 ( 26.20) ( 26.20) 0.11- 24,176.2C
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 26
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Safety 08.33° OF YEAR COMP.
Building Safety
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-2410-4101 Regular Pay 399,300.00 27,116.71 27,116.71 6.79 372,183.29
101-4-2410-4103 Part-time Pay 43,400.00 1,830.92 1,830.92 4.22 41,569.08
101-4-2410-4104 PERA 37,250.00 4,139.64 4,139.64 11.11 33,110.36
101-4-2410-4105 FICA 23,000.00 2,412.18 2,412.18 10.49 20,587.82
101-4-2410-4107 Medicare 6,400.00 678.89 678.89 10.61 5,721.11
101-4-2410-4108 Insurance 59,250.00 4,424.03 4,424.03 7.47 54,825.97
101-4-2410-4109 Workers Comp 1,900.00 468.50 468.50 24.66 1,431.5C
TOTAL Personal Services 570,500.00 41,070.87 41,070.87 7.20 529,429.13
Supplies
101-4-2410-4201 Office Supplies 6,350.00 0.00 0.00 0.00 6,350.00
101-4-2410-4212 Fuels & Lubes 8,000.00 1,014.79 1,014.79 12.68 6,985.21
101-4-2410-4217 Uniform Allowance 2,000.00 0.00 0.00 0.00 2,000.00
101-4-2410-4219 Operating Supplies 6,600.00 0.00 0.00 O.00 6,600.00
TOTAL Supplies 22,950.00 1,014.79 1,014.79 4.42 21,935.21
Other Services & Charges
101-4-2410-4321 Telephone 4,750.00 8.33 8.33 0.18 4,741.67
101-4-2410-4322 Postage 600.00 0.00 0.00 0.00 600.00
101-4-2410-4331 Travel, Conferences & Schools 3,600.00 355.00 355.00 9.86 3,245.00
101-4-2410-4361 Insurance 1,250.00 142.50 142.50 11.40 1,107.5C
101-4-2410-4404 Equip Repair/Maint Services 7,400.00 189.79 189.79 2.56 7,210.21
101-4-2410-4433 Dues & Subscriptions 3,650.00 75.00 75.00 2.05 3,575.00
101-4-2410-4460 Equip Replacement Charge 3,250.00 270.83 270.83 8.33 2,979.17
TOTAL Other Services & Charges 24,500.00 1,041.45 1,041.45 4.25 23,458.5E
Capital Outlay
TOTAL Building Safety 617,950.00 43,127.11 43,127.11 6.98 574,822.89
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 27
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Safety 08.33° OF YEAR COMP.
Code Enforcement
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-2420-4101 Regular Pay 67,550.00 4,677.12 4,677.12 6.92 62,872.88
101-4-2420-4104 PERA 4,900.00 576.71 576.71 11.77 4,323.29
101-4-2420-4105 FICA 4,200.00 505.38 505.38 12.03 3,694.62
101-4-2420-4107 Medicare 1,000.00 118.19 118.19 11.82 881.81
101-4-2420-4108 Insurance 3,600.00 238.57 238.57 6.63 3,361.43
101-4-2420-4109 Workers Comp 300.00 72.00 72.00 24.00 228.00
TOTAL Personal Services 81,550.00 6,187.97 6,187.97 7.59 75,362.03
Supplies
101-4-2420-4212 Fuels & Lubes 2,500.00 149.63 149.63 5.99 2,350.37
101-4-2420-4219 Operating Supplies 700.00 0.00 0.00 O.00 700.00
TOTAL Supplies 3,200.00 149.63 149.63 4.68 3,050.37
Other Services & Charges
101-4-2420-4321 Telephone 900.00 0.00 0.00 0.00 900.00
101-4-2420-4322 Postage 750.00 0.00 0.00 0.00 750.00
101-4-2420-4331 Travel, Conferences & Schools 500.00 0.10 0.10 0.02 499.9C
101-4-2420-4361 Insurance 150.00 34.75 34.75 23.17 115.2E
101-4-2420-4404 Equip Repair/Maint Services 750.00 0.00 0.00 0.00 750.00
101-4-2420-4460 Equip Replacement Charge 800.00 66.67 66.67 8.33 733.33
TOTAL Other Services & Charges 3,850.00 101.52 101.52 2.64 3,748.48
TOTAL Code Enforcement 88,600.00 6,439.12 6,439.12 7.27 82,160.88
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 28
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Safety 08.33° OF YEAR COMP.
Environmental
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-2440-4101 Regular Pay 20,100.00 0.00 0.00 0.00 20,100.00
101-4-2440-4104 PERA 1,450.00 0.00 0.00 0.00 1,450.00
101-4-2440-4105 FICA 1,250.00 0.00 0.00 0.00 1,250.00
101-4-2440-4107 Medicare 300.00 0.00 0.00 0.00 300.00
101-4-2440-4108 Insurance 3,900.00 0.00 0.00 0.00 3,900.00
101-4-2440-4109 Workers Comp 600.00 149.50 149.50 24.92 450.5C
TOTAL Personal Services 27,600.00 149.50 149.50 0.54 27,450.5C
Supplies
101-4-2440-4201 Office Supplies 450.00 0.00 0.00 0.00 450.00
101-4-2440-4212 Fuels & Lubes 150.00 0.00 0.00 O.00 150.00
TOTAL Supplies 600.00 0.00 0.00 0.00 600.00
Other Services & Charges
101-4-2440-4321 Telephone 800.00 0.00 0.00 0.00 800.00
101-4-2440-4322 Postage 500.00 0.00 0.00 0.00 500.00
101-4-2440-4331 Travel, Conferences & Schools 2,150.00 0.00 0.00 0.00 2,150.00
101-4-2440-4359 Publishing 100.00 0.00 0.00 0.00 100.00
101-4-2440-4433 Dues & Subscriptions 50.00 0.00 0.00 O.00 50.00
TOTAL Other Services & Charges 3,600.00 0.00 0.00 0.00 3,600.00
TOTAL Environmental 31,800.00 149.50 149.50 0.47 31,650.5C
TOTAL Public Safety 6,001,600.00 446,610.02 446,610.02 7.44 5,554,989.98
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 29
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Works 08.33° OF YEAR COMP.
Street Maintenance
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-3120-4101 Regular Pay 464,300.00 18,138.19 18,138.19 3.91 446,161.81
101-4-3120-4102 Overtime Pay 4,000.00 1,292.64 1,292.64 32.32 2,707.36
101-4-3120-4103 Part-time Pay 69,500.00 2,908.00 2,908.00 4.18 66,592.00
101-4-3120-4104 PERA 37,400.00 2,585.94 2,585.94 6.91 34,814.06
101-4-3120-4105 FICA 33,350.00 2,161.53 2,161.53 6.48 31,188.47
101-4-3120-4107 Medicare 7,800.00 505.50 505.50 6.48 7,294.5C
101-4-3120-4108 Insurance 74,150.00 2,091.71 2,091.71 2.82 72,058.29
101-4-3120-4109 Workers Comp 26,500.00 6,630.00 6,630.00 25.02 19,870.00
TOTAL Personal Services 717,000.00 36,313.51 36,313.51 5.06 680,686.49
Supplies
101-4-3120-4201 Office Supplies 2,800.00 0.00 0.00 0.00 2,800.00
101-4-3120-4212 Fuels & Lubes 81,700.00 30,255.93 30,255.93 37.03 51,444.07
101-4-3120-4219 Operating Supplies 106,350.00 ( 60.54) ( 60.54) 0.06- 106,410.54
101-4-3120-4226 Street Signs 32,600.00 0.00 0.00 O.00 32,600.00
TOTAL Supplies 223,450.00 30,195.39 30,195.39 13.51 193,254.61
Other Services & Charges
101-4-3120-4319 Other Professional Services 550.00 0.00 0.00 0.00 550.00
101-4-3120-4321 Telephone 6,100.00 99.09 99.09 1.62 6,000.91
101-4-3120-4322 Postage 100.00 0.00 0.00 0.00 100.00
101-4-3120-4331 Travel, Conferences & Schools 3,500.00 0.00 0.00 0.00 3,500.00
101-4-3120-4359 Publishing 200.00 0.00 0.00 0.00 200.00
101-4-3120-4361 Insurance 18,450.00 4,508.25 4,508.25 24.43 13,941.7E
101-4-3120-4389 Utilities 53,400.00 15.81 15.81 0.03 53,384.19
101-4-3120-4401 Bldg Repair/Maint Services 10,450.00 0.00 0.00 0.00 10,450.00
101-4-3120-4404 Equip Repair/Maint Services 6,000.00 0.00 0.00 0.00 6,000.00
101-4-3120-4409 Contractual Services 100,000.00 0.00 0.00 0.00 100,000.00
101-4-3120-4415 Equipment Rental 4,800.00 0.00 0.00 0.00 4,800.00
101-4-3120-4417 Uniform Rental 5,800.00 ( 0.56) ( 0.56) 0.01- 5,800.56
101-4-3120-4433 Dues & Subscriptions 350.00 217.50 217.50 62.14 132.5C
101-4-3120-4437 Taxes & Licenses 150.00 0.00 0.00 0.00 150.00
101-4-3120-4460 Equip Replacement Charge 89,450.00 7,454.17 7,454.17 8.33 81,995.83
TOTAL Other Services & Charges 299,300.00 12,294.26 12,294.26 4.11 287,005.74
Capital Outlay
TOTAL Street Maintenance 1,239,750.00 78,803.16 78,803.16 6.36 1,160,946.84
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 3C
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Works 08.33° OF YEAR COMP.
Snow Removal
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-3130-4101 Regular Pay 121,650.00 23,010.67 23,010.67 18.92 98,639.33
101-4-3130-4102 Overtime Pay 20,000.00 12,976.93 12,976.93 64.88 7,023.07
101-4-3130-4104 PERA 9,850.00 4,443.16 4,443.16 45.11 5,406.84
101-4-3130-4105 FICA 8,800.00 3,772.33 3,772.33 42.87 5,027.67
101-4-3130-4107 Medicare 2,050.00 882.22 882.22 43.04 1,167.78
101-4-3130-4108 Insurance 19,500.00 4,809.67 4,809.67 24.66 14,690.33
101-4-3130-4109 Workers Comp 6,500.00 1,626.00 1,626.00 25.02 4,874.00
TOTAL Personal Services 188,350.00 51,520.98 51,520.98 27.35 136,829.02
Supplies
101-4-3130-4219 Operating Supplies 89,400.00 0.00 0.00 O.00 89,400.00
TOTAL Supplies 89,400.00 0.00 0.00 0.00 89,400.00
Other Services & Charges
Capital Outlay
TOTAL Snow Removal 277,750.00 51,520.98 51,520.98 18.55 226,229.02
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 31
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Works 08.33° OF YEAR COMP.
Equipment Services
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-3150-4101 Regular Pay 116,800.00 7,882.08 7,882.08 6.75 108,917.92
101-4-3150-4102 Overtime Pay 1,000.00 136.30 136.30 13.63 863.7C
101-4-3150-4104 PERA 8,450.00 1,022.46 1,022.46 12.10 7,427.54
101-4-3150-4105 FICA 7,250.00 841.60 841.60 11.61 6,408.4C
101-4-3150-4107 Medicare 1,700.00 196.83 196.83 11.58 1,503.17
101-4-3150-4108 Insurance 13,450.00 1,146.62 1,146.62 8.53 12,303.38
101-4-3150-4109 Workers Comp 3,000.00 745.25 745.25 24.84 2,254.75
TOTAL Personal Services 151,650.00 11,971.14 11,971.14 7.89 139,678.86
Supplies
101-4-3150-4219 Operating Supplies 22,250.00 2,289.02 2,289.02 10.29 19,960.98
101-4-3150-4221 Equipment Parts 5,600.00 0.00 0.00 O.00 5,600.00
TOTAL Supplies 27,850.00 2,289.02 2,289.02 8.22 25,560.98
Other Services & Charges
101-4-3150-4331 Travel, Conferences & Schools 1,500.00 0.00 0.00 0.00 1,500.00
101-4-3150-4404 Equip Repair/Maint Services 1,000.00 0.00 0.00 0.00 1,000.00
101-4-3150-4417 Uniform Rental 2,150.00 32.78 32.78 1.52 2,117.22
TOTAL Other Services & Charges 4,650.00 32.78 32.78 0.70 4,617.22
Capital Outlay
TOTAL Equipment Services 184,150.00 14,292.94 14,292.94 7.76 169,857.06
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 32
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Public Works 08.33° OF YEAR COMP.
Engineering
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-3300-4101 Regular Pay 118,500.00 10,744.49 10,744.49 9.07 107,755.51
101-4-3300-4104 PERA 8,600.00 1,289.81 1,289.81 15.00 7,310.19
101-4-3300-4105 FICA 7,350.00 1,131.22 1,131.22 15.39 6,218.78
101-4-3300-4107 Medicare 1,700.00 264.56 264.56 15.56 1,435.44
101-4-3300-4108 Insurance 6,300.00 600.02 600.02 9.52 5,699.98
101-4-3300-4109 Workers Comp 650.00 166.50 166.50 25.62 483.5C
TOTAL Personal Services 143,100.00 14,196.60 14,196.60 9.92 128,903.4C
Supplies
101-4-3300-4201 Office Supplies 200.00 0.00 0.00 0.00 200.00
101-4-3300-4212 Fuels & Lubes 1,000.00 68.57 68.57 6.86 931.43
101-4-3300-4219 Operating Supplies 950.00 0.00 0.00 O.00 950.00
TOTAL Supplies 2,150.00 68.57 68.57 3.19 2,081.43
Other Services & Charges
101-4-3300-4319 Other Professional Services 10,000.00 0.00 0.00 0.00 10,000.00
101-4-3300-4321 Telephone 1,450.00 2.40 2.40 0.17 1,447.6C
101-4-3300-4322 Postage 150.00 0.00 0.00 0.00 150.00
101-4-3300-4331 Travel, Conferences & Schools 2,750.00 0.00 0.00 0.00 2,750.00
101-4-3300-4361 Insurance 200.00 28.50 28.50 14.25 171.5C
101-4-3300-4404 Equip Repair/Maint Services 6,300.00 187.03 187.03 2.97 6,112.97
101-4-3300-4460 Equip Replacement Charge 750.00 62.50 62.50 8.33 687.5C
TOTAL Other Services & Charges 21,600.00 280.43 280.43 1.30 21,319.57
Capital Outlay
TOTAL Engineering 166,850.00 14,545.60 14,545.60 8.72 152,304.4C
TOTAL Public Works 1,868,500.00 159,162.68 159,162.68 8.52 1,709,337.32
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 33
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Culture & Recreation 08.33° OF YEAR COMP.
Parks Department
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-5110-4101 Regular Pay 390,100.00 23,623.97 23,623.97 6.06 366,476.03
101-4-5110-4102 Overtime Pay 6,600.00 1,037.93 1,037.93 15.73 5,562.07
101-4-5110-4103 Part-time Pay 68,250.00 1,111.51 1,111.51 1.63 67,138.49
101-4-5110-4104 PERA 30,200.00 3,138.15 3,138.15 10.39 27,061.8E
101-4-5110-4105 FICA 28,300.00 2,647.37 2,647.37 9.35 25,652.63
101-4-5110-4107 Medicare 6,650.00 619.14 619.14 9.31 6,030.86
101-4-5110-4108 Insurance 68,400.00 4,027.63 4,027.63 5.89 64,372.37
101-4-5110-4109 Workers Comp 10,900.00 2,728.75 2,728.75 25.03 8,171.25
TOTAL Personal Services 609,400.00 38,934.45 38,934.45 6.39 570,465.5E
Supplies
101-4-5110-4212 Fuels & Lubes 40,000.00 3,418.71 3,418.71 8.55 36,581.29
101-4-5110-4217 Uniform Allowance 4,250.00 ( 0.13) ( 0.13) 0.00 4,250.13
101-4-5110-4219 Operating Supplies 92,550.00 ( 959.85) ( 959.85) 1.04- 93,509.8E
101-4-5110-4221 Equipment Parts 13,050.00 438.00 438.00 3.36 12,612.00
TOTAL Supplies 149,850.00 2,896.73 2,896.73 1.93 146,953.27
Other Services & Charges
101-4-5110-4321 Telephone 4,900.00 37.88 37.88 0.77 4,862.12
101-4-5110-4322 Postage 50.00 0.00 0.00 0.00 50.00
101-4-5110-4331 Travel, Conferences & Schools 4,500.00 0.00 0.00 0.00 4,500.00
101-4-5110-4361 Insurance 25,600.00 5,626.25 5,626.25 21.98 19,973.7E
101-4-5110-4389 Utilities 33,000.00 0.00 0.00 0.00 33,000.00
101-4-5110-4401 Bldg Repair/Maint Services 3,000.00 0.00 0.00 0.00 3,000.00
101-4-5110-4404 Equip Repair/Maint Services 13,300.00 0.00 0.00 0.00 13,300.00
101-4-5110-4409 Contractual Services 27,800.00 45.25 45.25 0.16 27,754.7E
101-4-5110-4415 Equipment Rental 15,950.00 315.00 315.00 1.97 15,635.00
101-4-5110-4460 Equip Replacement Charge 51,100.00 4,258.33 4,258.33 8.33 46,841.67
TOTAL Other Services & Charges 179,200.00 10,282.71 10,282.71 5.74 168,917.29
Capital Outlay
TOTAL Parks Department 938,450.00 52,113.89 52,113.89 5.55 886,336.11
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 34
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Culture & Recreation 08.33° OF YEAR COMP.
Parks & Rec Admin
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-5210-4101 Regular Pay 277,350.00 19,103.69 19,103.69 6.89 258,246.31
101-4-5210-4103 Part-time Pay 53,900.00 3,390.96 3,390.96 6.29 50,509.04
101-4-5210-4104 PERA 23,700.00 2,715.90 2,715.90 11.46 20,984.1C
101-4-5210-4105 FICA 20,550.00 2,245.41 2,245.41 10.93 18,304.59
101-4-5210-4107 Medicare 4,800.00 525.16 525.16 10.94 4,274.84
101-4-5210-4108 Insurance 46,400.00 3,385.44 3,385.44 7.30 43,014.56
101-4-5210-4109 Workers Comp 3,300.00 817.50 817.50 24.77 2,482.5C
TOTAL Personal Services 430,000.00 32,184.06 32,184.06 7.48 397,815.94
Supplies
101-4-5210-4219 Operating Supplies 15,500.00 0.00 0.00 O.00 15,500.00
TOTAL Supplies 15,500.00 0.00 0.00 0.00 15,500.00
Other Services & Charges
101-4-5210-4321 Telephone 6,050.00 107.34 107.34 1.77 5,942.66
101-4-5210-4322 Postage 5,100.00 0.00 0.00 0.00 5,100.00
101-4-5210-4331 Travel, Conferences & Schools 9,850.00 214.89 214.89 2.18 9,635.11
101-4-5210-4349 Advertising/Marketing 31,150.00 0.00 0.00 0.00 31,150.00
101-4-5210-4361 Insurance 900.00 83.50 83.50 9.28 816.5C
101-4-5210-4389 Utilities 4,500.00 0.00 0.00 0.00 4,500.00
101-4-5210-4401 Bldg Repair/Maint Services 14,000.00 871.10 871.10 6.22 13,128.9C
101-4-5210-4404 Equip Repair/Maint Services 12,900.00 7,018.83 7,018.83 54.41 5,881.17
101-4-5210-4433 Dues & Subscriptions 1,850.00 390.00 390.00 21.08 1,460.00
TOTAL Other Services & Charges 86,300.00 8,685.66 8,685.66 10.06 77,614.34
Capital Outlay
TOTAL Parks & Rec Admin 531,800.00 40,869.72 40,869.72 7.69 490,930.28
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: H
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Culture & Recreation 08.33° OF YEAR COMP.
Recreation Programs
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-5220-4102 Overtime Pay 0.00 ( 55.50) ( 55.50) 0.00 55.5C
101-4-5220-4103 Part-time Pay 82,000.00 3,137.51 3,137.51 3.83 78,862.49
101-4-5220-4104 PERA 2,400.00 90.30 90.30 3.76 2,309.7C
101-4-5220-4105 FICA 4,350.00 292.38 292.38 6.72 4,057.62
101-4-5220-4107 Medicare 1,200.00 68.35 68.35 5.7C 1,131.65
TOTAL Personal Services 89,950.00 3,533.04 3,533.04 3.93 86,416.96
Supplies
101-4-5220-4219 Operating Supplies 32,600.00 0.00 0.00 O.00 32,600.00
TOTAL Supplies 32,600.00 0.00 0.00 0.00 32,600.00
Other Services & Charges
101-4-5220-4409 Contractual Services 71,400.00 600.00 600.00 0.84 70,800.00
101-4-5220-4412 Building Rent 1,650.00 0.00 0.00 0.00 1,650.00
101-4-5220-4438 Credit Card Fees 4,600.00 0.00 0.00 O.00 4,600.00
TOTAL Other Services & Charges 77,650.00 600.00 600.00 0.77 77,050.00
TOTAL Recreation Programs 200,200.00 4,133.04 4,133.04 2.06 196,066.96
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 36
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Culture & Recreation 08.33° OF YEAR COMP.
Concessions
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
Supplies
Other Services & Charges
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 37
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Culture & Recreation 08.33° OF YEAR COMP.
Sr Citizen Programs
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-5510-4101 Regular Pay 104,150.00 7,031.68 7,031.68 6.75 97,118.32
101-4-5510-4104 PERA 7,550.00 844.12 844.12 11.18 6,705.88
101-4-5510-4105 FICA 6,450.00 692.55 692.55 10.74 5,757.4E
101-4-5510-4107 Medicare 1,500.00 161.97 161.97 10.80 1,338.03
101-4-5510-4108 Insurance 16,550.00 1,664.01 1,664.01 10.05 14,885.99
101-4-5510-4109 Workers Comp 450.00 107.75 107.75 23.94 342.25
TOTAL Personal Services 136,650.00 10,502.08 10,502.08 7.69 126,147.92
Supplies
101-4-5510-4219 Operating Supplies 11,250.00 1,774.90 1,774.90 15.78 9,475.1C
TOTAL Supplies 11,250.00 1,774.90 1,774.90 15.78 9,475.1C
Other Services & Charges
101-4-5510-4321 Telephone 2,600.00 170.09 170.09 6.54 2,429.91
101-4-5510-4322 Postage 2,550.00 950.00 950.00 37.25 1,600.00
101-4-5510-4331 Travel, Conferences & Schools 3,050.00 0.00 0.00 0.00 3,050.00
101-4-5510-4361 Insurance 2,050.00 296.75 296.75 14.48 1,753.2E
101-4-5510-4389 Utilities 9,100.00 ( 75.85) ( 75.85) 0.83- 9,175.8E
101-4-5510-4401 Bldg Repair/Maint Services 12,950.00 814.90 814.90 6.29 12,135.1C
101-4-5510-4404 Equip Repair/Maint Services 2,800.00 144.28 144.28 5.15 2,655.72
101-4-5510-4409 Contractual Services 9,700.00 0.00 0.00 0.00 9,700.00
101-4-5510-4433 Dues & Subscriptions 850.00 50.00 50.00 5.88 800.00
TOTAL Other Services & Charges 45,650.00 2,350.17 2,350.17 5.15 43,299.83
Capital Outlay
TOTAL Sr Citizen Programs 193,550.00 14,627.15 14,627.15 7.56 178,922.8E
TOTAL Culture & Recreation 1,864,000.00 111,743.80 111,743.80 5.99 1,752,256.2C
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 38
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Economic Development 08.33° OF YEAR COMP.
Economic Development
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-6210-4101 Regular Pay 0.00 8,558.96 8,558.96 0.00 ( 8,558.96)
101-4-6210-4103 Part-time Pay 0.00 2,064.00 2,064.00 0.00 ( 2,064.00)
101-4-6210-4104 PERA 0.00 628.03 628.03 0.00 ( 628.03)
101-4-6210-4105 FICA 0.00 628.29 628.29 0.00 ( 628.29)
101-4-6210-4107 Medicare 0.00 146.95 146.95 0.00 ( 146.95)
101-4-6210-4108 Insurance 0.00 820.01 820.01 0.00 ( 820.01)
101-4-6210-4109 Workers Comp 0.00 160.00 160.00 O.00 ( 160.00)
TOTAL Personal Services 0.00 13,006.24 13,006.24 0.00 ( 13,006.24)
Other Services & Charges
101-4-6210-4440 Miscellaneous 0.00 ( 939.05) ( 939.05) O.00 939.05
TOTAL Other Services & Charges 0.00 ( 939.05) ( 939.05) 0.00 939.0E
TOTAL Economic Development 0.00 12,067.19 12,067.19 0.00 ( 12,067.19)
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 39
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
Economic Development 08.33° OF YEAR COMP.
Energy City
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
101-4-6220-4101 Regular Pay 4,250.00 0.00 0.00 0.00 4,250.00
101-4-6220-4104 PERA 300.00 0.00 0.00 0.00 300.00
101-4-6220-4105 FICA 250.00 0.00 0.00 0.00 250.00
101-4-6220-4107 Medicare 50.00 0.00 0.00 0.00 50.00
101-4-6220-4108 Insurance 800.00 0.00 0.00 O.00 800.00
TOTAL Personal Services 5,650.00 0.00 0.00 0.00 5,650.00
Supplies
101-4-6220-4219 Operating Supplies 950.00 0.00 0.00 O.00 950.00
TOTAL Supplies 950.00 0.00 0.00 0.00 950.00
Other Services & Charges
101-4-6220-4319 Other Professional Services 1,000.00 0.00 0.00 0.00 1,000.00
101-4-6220-4331 Travel, Conferences & Schools 3,000.00 0.00 0.00 0.00 3,000.00
101-4-6220-4359 Publishing 1,500.00 0.00 0.00 O.00 1,500.00
TOTAL Other Services & Charges 5,500.00 0.00 0.00 0.00 5,500.00
TOTAL Energy City 12,100.00 0.00 0.00 0.00 12,100.00
TOTAL Economic Development 12,100.00 12,067.19 12,067.19 99.73 32.81
2-11-2014 02:39 PM CITY OF ELK RIVER PAGE: 4C
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
101-GENERAL FUND
General 08.33° OF YEAR COMP.
Transfers Out
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Transfers Out
101-4-7000-4724 Transfer - Pinewood 60,100.00 0.00 0.00 O.00 60,100.00
TOTAL Transfers Out 60,100.00 0.00 0.00 0.00 60,100.00
TOTAL Transfers Out 60,100.00 0.00 0.00 0.00 60,100.00
TOTAL General 60,100.00 0.00 0.00 0.00 60,100.00
TOTAL EXPENDITURES 12,870,500.00 962,237.33 962,237.33 7.48 11,908,262.67
REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 904,519.14) ( 904,519.14) 904,519.14
2-11-2014 02:40 PM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
221-ICE ARENA
FINANCIAL SUMMARY 08.33° OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SUMMARY
Ice Arena 625,250.00 14,276.29 14,276.29 2.28 610,973.71
Hockey 34,000.00 9,435.00 9,435.00 27.75 24,565.00
Skating 42,000.00 2,762.00 2,762.00 6.58 39,238.00
Concessions 80,000.00 13,661.25 13,661.25 17.08 66,338.75
TOTAL REVENUES 781,250.00 40,134.54 40,134.54 5.14 741,115.46
EXPENDITURE SUMMARY
Culture & Recreation
Ice Arena 903,150.00 31,231.64 31,231.64 3.46 871,918.36
Hockey 19,050.00 0.00 0.00 0.00 19,050.00
Skating 30,250.00 1,169.29 1,169.29 3.87 29,080.71
Arena Concessions 52,100.00 2,989.35 2,989.35 5.74 49,110.65
TOTAL Culture & Recreation 1,004,550.00 35,390.28 35,390.28 3.52 969,159.72
TOTAL EXPENDITURES 1,004,550.00 35,390.28 35,390.28 3.52 969,159.72
REVENUES OVER/(UNDER) EXPENDITURES 223,300.00) 4,744.26 4,744.26 228,044.26)
2-11-2014 02:40 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
221-ICE ARENA
08.33° OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE
Ice Arena
Charges for Services
221-3-0000-3464 Ice Rental 520,000.00 2,802.00 2,802.00 0.54 517,198.00
221-3-0000-3465 Admissions 28,500.00 7,997.00 7,997.00 28.06 20,503.00
221-3-0000-3466 Dry Floor Events 19,500.00 1,108.00 1,108.00 5.68 18,392.00
221-3-0000-3468 Skate Sharpening 4,300.00 728.00 728.00 16.93 3,572.00
221-3-0000-3475 Building Rent 2,600.00 0.00 0.00 0.00 2,600.00
221-3-0000-3482 Advertising fee 24,500.00 0.00 0.00 O.00 24,500.00
TOTAL Charges for Services 599,400.00 12,635.00 12,635.00 2.11 586,765.00
Other Revenue
221-3-0000-3621 Interest Income 0.00 ( 500.00) ( 500.00) 0.00 500.00
221-3-0000-3622 Vending Machines 14,000.00 1,757.49 1,757.49 12.55 12,242.51
221-3-0000-3626 Contributions 7,800.00 0.00 0.00 0.00 7,800.00
221-3-0000-3629 Miscellaneous Revenue 3,800.00 326.75 326.75 8.6C 3,473.25
TOTAL Other Revenue 25,600.00 1,584.24 1,584.24 6.19 24,015.76
Sales
221-3-0000-3791 ATM Revenue 250.00 57.05 57.05 22.82 192.95
TOTAL Sales 250.00 57.05 57.05 22.82 192.9E
Transfers In
TOTAL Ice Arena 625,250.00 14,276.29 14,276.29 2.28 610,973.71
Hockey
Charges for Services
221-3-5410-3461 Recreation Fees 34,000.00 9,435.00 9,435.00 27.75 24,565.00
TOTAL Charges for Services 34,000.00 9,435.00 9,435.00 27.75 24,565.00
Other Revenue
TOTAL Hockey 34,000.00 9,435.00 9,435.00 27.75 24,565.00
Skating
2-11-2014 02:40 PM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
221-ICE ARENA
08.33° OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE
Charges for Services
221-3-5420-3461 Recreation Fees 38,000.00 2,762.00 2,762.00 7.27 35,238.00
221-3-5420-3465 Admissions 4,000.00 0.00 0.00 O.00 4,000.00
TOTAL Charges for Services 42,000.00 2,762.00 2,762.00 6.58 39,238.00
Other Revenue
TOTAL Skating 42,000.00 2,762.00 2,762.00 6.58 39,238.00
Concessions
Charges for Services
221-3-5430-3467 Concessions 80,000.00 13,661.25 13,661.25 17.08 66,338.75
TOTAL Charges for Services 80,000.00 13,661.25 13,661.25 17.08 66,338.7E
TOTAL Concessions 80,000.00 13,661.25 13,661.25 17.08 66,338.7E
TOTAL REVENUE 781,250.00 40,134.54 40,134.54 5.14 741,115.46
2-11-2014 02:40 PM CITY OF ELK RIVER PAGE: 4
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
221-ICE ARENA
Culture & Recreation 08.33° OF YEAR COMP.
Ice Arena
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
221-4-5400-4101 Regular Pay 171,300.00 11,772.00 11,772.00 6.87 159,528.00
221-4-5400-4102 Overtime Pay 0.00 1,919.89 1,919.89 0.00 ( 1,919.89)
221-4-5400-4103 Part-time Pay 60,150.00 7,118.42 7,118.42 11.83 53,031.58
221-4-5400-4104 PERA 16,000.00 1,997.98 1,997.98 12.49 14,002.02
221-4-5400-4105 FICA 14,400.00 1,960.99 1,960.99 13.62 12,439.01
221-4-5400-4107 Medicare 3,400.00 458.61 458.61 13.49 2,941.39
221-4-5400-4108 Insurance 25,800.00 2,202.02 2,202.02 8.53 23,597.98
221-4-5400-4109 Workers Comp 7,800.00 1,764.50 1,764.50 22.62 6,035.5C
TOTAL Personal Services 298,850.00 29,194.41 29,194.41 9.77 269,655.59
Supplies
221-4-5400-4212 Fuels & Lubs 400.00 0.00 0.00 0.00 400.00
221-4-5400-4217 Uniform Allowance 800.00 0.00 0.00 0.00 800.00
221-4-5400-4219 Operating Supplies 48,500.00 562.54 562.54 1.16 47,937.46
221-4-5400-4255 Soft Drinks/Misc 8,100.00 0.00 0.00 0.00 8,100.00
221-4-5400-4259 Other Merchandise For Resale 900.00 0.00 0.00 O.00 900.00
TOTAL Supplies 58,700.00 562.54 562.54 0.96 58,137.46
Other Services & Charges
221-4-5400-4321 Telephone 3,300.00 93.09 93.09 2.82 3,206.91
221-4-5400-4322 Postage 300.00 0.00 0.00 0.00 300.00
221-4-5400-4331 Travel, Conferences & Schools 1,500.00 0.00 0.00 0.00 1,500.00
221-4-5400-4359 Publishing 5,700.00 0.00 0.00 0.00 5,700.00
221-4-5400-4361 Insurance 8,100.00 1,085.50 1,085.50 13.40 7,014.5C
221-4-5400-4389 Utilities 153,500.00 0.00 0.00 0.00 153,500.00
221-4-5400-4401 Bldg Repair/Maint Services 23,800.00 0.00 0.00 0.00 23,800.00
221-4-5400-4409 Contractual Services 2,250.00 0.00 0.00 0.00 2,250.00
221-4-5400-4415 Equipment Rental 2,700.00 146.10 146.10 5.41 2,553.9C
221-4-5400-4433 Dues & Subscriptions 500.00 150.00 150.00 30.00 350.00
TOTAL Other Services & Charges 201,650.00 1,474.69 1,474.69 0.73 200,175.31
Capital Outlay
221-4-5400-4520 Buildings & Structures 145,550.00 0.00 0.00 0.00 145,550.00
221-4-5400-4530 Improvement Project Contract 198,400.00 0.00 0.00 O.00 198,400.00
TOTAL Capital Outlay 343,950.00 0.00 0.00 0.00 343,950.00
Transfers Out
TOTAL Ice Arena 903,150.00 31,231.64 31,231.64 3.46 871,918.36
2-11-2014 02:40 PM CITY OF ELK RIVER PAGE:
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
221-ICE ARENA
Culture & Recreation 08.33° OF YEAR COMP.
Hockey
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
221-4-5410-4103 Part-time Pay 850.00 0.00 0.00 0.00 850.00
221-4-5410-4105 FICA 50.00 0.00 0.00 0.0C 50.00
TOTAL Personal Services 900.00 0.00 0.00 0.00 900.00
Supplies
221-4-5410-4219 Operating Supplies 9,500.00 0.00 0.00 O.00 9,500.00
TOTAL Supplies 9,500.00 0.00 0.00 0.00 9,500.00
Other Services & Charges
221-4-5410-4359 Publishing 500.00 0.00 0.00 0.00 500.00
221-4-5410-4409 Contractual Services 5,350.00 0.00 0.00 0.00 5,350.00
221-4-5410-4438 Credit Card Fees 2,800.00 0.00 0.00 O.00 2,800.00
TOTAL Other Services & Charges 8,650.00 0.00 0.00 0.00 8,650.00
TOTAL Hockey 19,050.00 0.00 0.00 0.00 19,050.00
2-11-2014 02:40 PM CITY OF ELK RIVER PAGE: 6
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
221-ICE ARENA
Culture & Recreation 08.33° OF YEAR COMP.
Skating
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
221-4-5420-4103 Part-time Pay 17,800.00 1,042.54 1,042.54 5.86 16,757.46
221-4-5420-4104 PERA 1,000.00 13.37 13.37 1.34 986.63
221-4-5420-4105 FICA 1,100.00 91.91 91.91 8.36 1,008.09
221-4-5420-4107 Medicare 250.00 21.47 21.47 8.59 228.53
TOTAL Personal Services 20,150.00 1,169.29 1,169.29 5.80 18,980.71
Supplies
221-4-5420-4219 Operating Supplies 4,850.00 0.00 0.00 O.00 4,850.00
TOTAL Supplies 4,850.00 0.00 0.00 0.00 4,850.00
Other Services & Charges
221-4-5420-4359 Publishing 1,050.00 0.00 0.00 0.00 1,050.00
221-4-5420-4409 Contractual Services 2,200.00 0.00 0.00 0.00 2,200.00
221-4-5420-4438 Credit Card Fees 2,000.00 0.00 0.00 O.00 2,000.00
TOTAL Other Services & Charges 5,250.00 0.00 0.00 0.00 5,250.00
TOTAL Skating 30,250.00 1,169.29 1,169.29 3.87 29,080.71
2-11-2014 02:40 PM CITY OF ELK RIVER PAGE: 7
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
221-ICE ARENA
Culture & Recreation 08.33° OF YEAR COMP.
Arena Concessions
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
221-4-5430-4103 Part-time Pay 21,300.00 2,334.90 2,334.90 10.96 18,965.1C
221-4-5430-4104 PERA 200.00 0.00 0.00 0.00 200.00
221-4-5430-4105 FICA 1,300.00 243.75 243.75 18.75 1,056.2E
221-4-5430-4107 Medicare 300.00 57.00 57.00 19.00 243.00
TOTAL Personal Services 23,100.00 2,635.65 2,635.65 11.41 20,464.3E
Supplies
221-4-5430-4219 Operating Supplies 2,200.00 0.00 0.00 0.00 2,200.00
221-4-5430-4259 Other Merchandise For Resale 26,800.00 353.70 353.70 1.32 26,446.3C
TOTAL Supplies 29,000.00 353.70 353.70 1.22 28,646.3C
TOTAL Arena Concessions 52,100.00 2,989.35 2,989.35 5.74 49,110.6E
TOTAL Culture & Recreation 1,004,550.00 35,390.28 35,390.28 3.52 969,159.72
TOTAL EXPENDITURES 1,004,550.00 35,390.28 35,390.28 3.52 969,159.72
REVENUES OVER/(UNDER) EXPENDITURES 223,300.00) 4,744.26 4,744.26 228,044.26)
2-11-2014 02:40 PM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
222-PINEWOOD GOLF COURSE
FINANCIAL SUMMARY 08.33° OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
BUDGET PERIOD ACTUAL BUDGET BALANCE
REVENUE SUMMARY
Pinewood Golf Course 249,900.00 220.00 220.00 0.09 249,680.00
TOTAL REVENUES 249,900.00 220.00 220.00 0.09 249,680.00
EXPENDITURE SUMMARY
Culture & Recreation
Golf Course 249,900.00 8,156.18 8,156.18 3.26 241,743.82
TOTAL Culture & Recreation 249,900.00 8,156.18 8,156.18 3.26 241,743.82
TOTAL EXPENDITURES 249,900.00 8,156.18 8,156.18 3.26 241,743.82
REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 7,936.18) ( 7,936.18) 7,936.18
2-11-2014 02:40 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
222-PINEWOOD GOLF COURSE
08.33° OF YEAR COMP.
CURRENT CURRENT YEAR TO DATE o OF BUDGET
REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE
Pinewood Golf Course
Charges for Services
222-3-0000-3461 Recreation Fees 17,000.00 220.00 220.00 1.29 16,780.00
222-3-0000-3467 Concessions 16,800.00 0.00 0.00 0.00 16,800.00
222-3-0000-3469 Other Sales 4,500.00 0.00 0.00 0.00 4,500.00
222-3-0000-3476 Green Fees 110,000.00 0.00 0.00 0.00 110,000.00
222-3-0000-3477 Membership Fees 17,000.00 0.00 0.00 0.00 17,000.00
222-3-0000-3478 Golf Cart Rental 20,000.00 0.00 0.00 0.00 20,000.00
222-3-0000-3479 Tournaments 4,500.00 0.00 0.00 O.00 4,500.00
TOTAL Charges for Services 189,800.00 220.00 220.00 0.12 189,580.00
Other Revenue
Sales
Other Financing Sources
Transfers In
222-3-0000-3922 Transfer-General Fund 60,100.00 0.00 0.00 O.00 60,100.00
TOTAL Transfers In 60,100.00 0.00 0.00 0.00 60,100.00
TOTAL Pinewood Golf Course 249,900.00 220.00 220.00 0.09 249,680.00
TOTAL REVENUE 249,900.00 220.00 220.00 0.09 249,680.00
2-11-2014 02:40 PM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: JANUARY 31ST, 2014
222-PINEWOOD GOLF COURSE
Culture & Recreation 08.33° OF YEAR COMP.
Golf Course
CURRENT CURRENT YEAR TO DATE o OF BUDGET
DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
Personal Services
222-4-5300-4101 Regular Pay 67,550.00 4,677.57 4,677.57 6.92 62,872.43
222-4-5300-4103 Part-time Pay 54,250.00 0.00 0.00 0.00 54,250.00
222-4-5300-4104 PERA 8,850.00 561.51 561.51 6.34 8,288.49
222-4-5300-4105 FICA 7,550.00 472.98 472.98 6.26 7,077.02
222-4-5300-4107 Medicare 1,750.00 110.62 110.62 6.32 1,639.38
222-4-5300-4108 Insurance 6,750.00 562.00 562.00 8.33 6,188.00
222-4-5300-4109 Workers Comp 1,750.00 440.00 440.00 25.14 1,310.00
TOTAL Personal Services 148,450.00 6,824.68 6,824.68 4.60 141,625.32
Supplies
222-4-5300-4212 Fuels & Lubs 5,500.00 0.00 0.00 0.00 5,500.00
222-4-5300-4217 Uniform Allowance 700.00 0.00 0.00 0.00 700.00
222-4-5300-4219 Operating Supplies 29,050.00 0.00 0.00 0.00 29,050.00
222-4-5300-4259 Other Merchandise For Resale 9,500.00 0.00 0.00 O.00 9,500.00
TOTAL Supplies 44,750.00 0.00 0.00 0.00 44,750.00
Other Services & Charges
222-4-5300-4321 Telephone 2,500.00 0.00 0.00 0.00 2,500.00
222-4-5300-4331 Travel, Conferences & Schools 250.00 0.00 0.00 0.00 250.00
222-4-5300-4349 Advertising/Marketing 5,000.00 0.00 0.00 0.00 5,000.00
222-4-5300-4361 Insurance 11,550.00 918.50 918.50 7.95 10,631.5C
222-4-5300-4389 Utilities 6,700.00 0.00 0.00 0.00 6,700.00
222-4-5300-4401 Bldg Repair/Maint Services 10,700.00 0.00 0.00 0.00 10,700.00
222-4-5300-4404 Equip Repair/Maint Services 4,650.00 0.00 0.00 0.00 4,650.00
222-4-5300-4415 Equipment Rental 1,400.00 0.00 0.00 0.00 1,400.00
222-4-5300-4437 Taxes & Licenses 900.00 413.00 413.00 45.89 487.00
222-4-5300-4438 Credit Card Fees 5,000.00 0.00 0.00 0.00 5,000.00
222-4-5300-4460 Equip Replacement Charge 8,050.00 0.00 0.00 O.00 8,050.00
TOTAL Other Services & Charges 56,700.00 1,331.50 1,331.50 2.35 55,368.5C
Capital Outlay
Debt Service
TOTAL Golf Course 249,900.00 8,156.18 8,156.18 3.26 241,743.82
TOTAL Culture & Recreation 249,900.00 8,156.18 8,156.18 3.26 241,743.82
TOTAL EXPENDITURES 249,900.00 8,156.18 8,156.18 3.26 241,743.82
REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 7,936.18) ( 7,936.18) 7,936.18
O O O O O O O O O p O O O O p O O O p
y„ y O M al 7 O O N O M O O O O W O O O
O pp O O M al O O O O O M O O O O O O O O
.y
C = O O N O O O O O O N O O O O M O O O W
y Vi O N h O O Vi Vi � O O r O Vi N N
� U al O � Vi Vi O N n Vi Vi b 7 --i 7 7
pp C O M .-i Vi h Vi �O oo M Vi Vi t� 7 M \O \O
O O O O O O Vi Vi Vl O O O Vi O O
Cl
0 0 0 0 0 0 0 0 0 o 0 0 0 o 0 0 o 0 0
S
O O O
N
O 'n O Vi Vi Vi al O al 7 O O O O \O 7 O O O O O O O
U al Vi O 7 �O Vi Vi al n t� Vi O oo h 7 N O rO O O O O
pp C oo al N O �M O l 00 00 •• � � 01 01 O 00
'O �O oo h Vi N h N 7 0o O rl n N al O O
G �O
.-I
Vi Vl
Q � r r .ti �O oo Vi Vi h N N
O O O O O O O O O O O O O O O O O O O O O O O
L pp oo N N M o0 7 �O h �O M --i O O O l� 7 0 � 00 al al O
.y
'W A ss
wow
yO,y
F W 0 0 0 0 0 0 0 0 0 0 0 0 c o 0 0 o c o 0 o c
U W O on o � N o o ry ry a, a o a
p al m vi al al oo vi n 7 Vi a .ti rl 0 0o r r
Ao 00 � � a M oo co co co co
U 7 7 M M M M
O Vi Vi O O Vi O Vi O O Vl O O � � O O
d pp O oo M M M 7 h 7 al N � � W M Vi Vi
O O �O M N 7 N O M N N Vl Vi O O
i --I
i
44:
� � N
N
i
N
a
W � T � 6 � aUi � � ° bn � � � o � � �W4 � •° ,�v d >,
v U D �ls OP v �l O Z O OF F F o ao >
x°4
2-11-2014 02:43 PM CITY OF ELK RIVER PAGE: 1
POOLED CASH REPORT (FUND 999)
AS OF: JANUARY 31ST, 2014
BEGINNING CURRENT CURRENT
FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE
CLAIM ON CASH
002-1010 Cash - Section 125 26,760.34 7,933.55) 18,826.79
101-1010 Cash - General Fund 6,150,558.06 1,167,444.99) 4,983,113.07
211-1010 Cash - Library 447,254.57 3,030.02) 444,224.55
221-1010 Cash - Ice Arena 140,412.88 31,084.03) 109,328.85
222-1010 Cash - Pinewood Golf Course 41,538.45) ( 11,678.84) ( 53,217.29)
223-1010 Cash - Sr Citizen Account 929.71 0.00 929.71
225-1010 Cash - Park Dedication 0.00 15,670.60 15,670.6C
228-1010 Cash - Landfill 673,045.34 1,079.68 674,125.02
231-1010 Cash - Landfill Const Debris 710,441.91 0.00 710,441.91
240-1010 Cash - Micro Loan Fund 796,336.92 1,876.22 798,213.14
241-1010 Cash - Federal DEED 311,155.13 0.00 311,155.13
242-1010 Cash - State DEED 406,116.19 0.00 406,116.19
245-1010 Cash - Development Fund 581,246.35 15,826.79) 565,419.56
290-1010 Cash - Capital Outlay Reserve 1,630,691.32 9,545.61 1,640,236.93
291-1010 Cash - Insurance Reserve 236,402.45 77,594.94 313,997.39
292-1010 Cash - Govt Bldgs Reserve 4,003,048.33 64,276.46 4,067,324.79
294-1010 Cash - Drug Forfeiture 46,621.34 2,449.66 49,071.00
295-1010 Cash - Severance Pay Reserve 116,848.74 0.00 116,848.74
296-1010 Cash - GRE Reserve 1,963,823.28 218,586.75 2,182,410.03
311-1010 Cash - 2003A GO Bonds 61,200.00 0.00 61,200.00
313-1010 Cash - 2007C GO Bonds 386,736.18 5,364.51 392,100.69
333-1010 Cash - 2010A GO Cap Imp Bonds 695,029.10 111,507.80 806,536.9C
401-1010 Cash - Pavement Mgmt 685,351.64 174,517.61 859,869.25
403-1010 Cash - Street Improvement 1,930,307.18 30,485.86) 1,899,821.32
404-1010 Cash - Surface Water Managemnt 161,134.34 1,803.05) 159,331.29
406-1010 Cash - City Wide Trunk Util 4,311,668.01 101,244.41) 4,210,423.6C
410-1010 Cash - Equipment Replacement 877,888.21 55,785.10 933,673.31
426-1010 Cash - YMCA 628,153.24 0.00 628,153.24
440-1010 Cash - Park Improvement 101,331.06 25,640.12 126,971.18
459-1010 Cash - TIF 419 Highway 169 366,978.52 0.00 366,978.52
462-1010 Cash - TIF 422 Downtown Redev 0.00 63,664.75) ( 63,664.75)
602-1010 Cash - Wastewater Treatment 5,754,180.08 33,066.76 5,787,246.84
603-1010 Cash - Liquor 2,104,866.26 4,708.44) 2,100,157.82
605-1010 Cash - Garbage 640,370.07 4,741.10) 635,628.97
801-1010 Cash - Interest 0.00 3,848.10 3,848.1C
821-1010 Cash - Developer Escrow 41,737.55 3,407.64 45,145.19
TOTAL CLAIM ON CASH 36,947,085.85 639,428.27) 36,307,657.58
CASH IN BANK - POOLED CASH
999-1000 A/P BANK ACCOUNTS 49,900,048.86 594,948.16 50,494,997.02
999-1001 PY BANK ACCOUNT (41,335,152.57) ( 1,234,376.43) (42,569,529.00)
999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56
SUBTOTAL CASH IN BANK - POOLED CASH 36,947,085.85 639,428.27) 36,307,657.58