Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION #1 02-17-2015
City E K.iver TO: Mayor and City Council Memorandum From: Tim Simon, Finance Director Date: February 17, 2015 Subject: January 2015 Monthly Financial Report INFORMATION This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund and Ice Arena Special Revenue Fund. 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 semi - annual billing for the school liaison officer. ■ Contributions include the $14,500 donation by The Bank of Elk River for the 2015 parks and recreation programs. ■ The transfers in will be recorded mid -year. Expenditures: • Excluding transfers, total departmental expenditures are about 6.6% 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 • The Snow Removal budget reflects the seasonal expenditures for personal services. p 0 W I H L a 0 NAfURE] 2015 Monthly Expenditures $14,000 $12,000 o $10,000 z a $8,000 o � $6,000 $4,000 $2,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec FF Actual $884 Budget $1,109 $2,219 $3,328 $4,438 $5,547 $6,656 $7,766 $8,875 $9,985 $11,0941$12,203 $13,313 ICE ARENA For January, revenues exceed expenditures by $6,308. Revenues are about 4.4% of budget and consist mainly of hockey admissions, hockey registration fees and concessions. January ice rentals will be billed in early February. Expenditures are 4% of budget and attributable mainly to personal services and insurance. ATTACHMENTS ■ General Fund Revenue & Expense Report ■ Enterprise Funds — Budget to Actual ■ Cash Report — All Funds 2 -09 -2015 12:20 PM 101- GENERAL FUND FINANCIAL SUMMARY CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E CURRENT CURRENT BUDGET PERIOD PAGE: 1 INFORMATION 08.33° OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 13,312,800.00 120,211.46 120,211.46 0.9C 13,192,588.54 TOTAL REVENUES 13,312,800.00 120,211.46 120,211.46 0.90 13,192,588.54 EXPENDITURE SUMMARY General Government Mayor & Council 141,050.00 12,431.52 12,431.52 8.81 128,618.48 Cable TV 108,400.00 6,925.62 6,925.62 6.39 101,474.38 Administrative Services 600,000.00 46,145.99 46,145.99 7.69 553,854.01 Human Resources 161,750.00 6,776.95 6,776.95 4.19 154,973.0E Elections 13,350.00 0.00 0.00 0.00 13,350.00 Finance 567,450.00 51,098.98 51,098.98 9.01 516,351.02 Information Technology 332,150.00 21,959.66 21,959.66 6.61 310,190.34 Legal 217,600.00 0.00 0.00 0.00 217,600.00 Community Development 339,600.00 24,705.18 24,705.18 7.27 314,894.82 Planning 195,550.00 12,929.44 12,929.44 6.61 182,620.56 City Hall Maintenance 569,200.00 40,164.66 40,164.66 7.06 529,035.34 Contingency 95,000.00) 0.00 0.00 O.00 ( 95,000.00) TOTAL General Government 3,151,100.00 223,138.00 223,138.00 7.08 2,927,962.00 Public Safety Police Administration 693,150.00 83,598.90 83,598.90 12.06 609,551.1C Patrol 2,493,300.00 148,968.03 148,968.03 5.97 2,344,331.97 Investigations 963,050.00 53,920.38 53,920.38 5.60 909,129.62 Police Support Services 555,750.00 37,794.75 37,794.75 6.80 517,955.2E Police Reserves 20,800.00 0.00 0.00 0.00 20,800.00 Public safety building 77,150.00 2,272.54 2,272.54 2.95 74,877.46 Fire Administration 407,600.00 27,952.79 27,952.79 6.86 379,647.21 Fire Operations 388,350.00 18,015.58 18,015.58 4.64 370,334.42 Emergency Management 21,400.00 0.00 0.00 0.00 21,400.00 Building Safety 628,950.00 44,993.04 44,993.04 7.15 583,956.96 Code Enforcement 89,300.00 6,201.14 6,201.14 6.94 83,098.86 Environmental 30,150.00 2,104.49 2,104.49 6.98 28,045.51 TOTAL Public Safety 6,368,950.00 425,821.64 425,821.64 6.69 5,943,128.36 Public Works Street Maintenance 1,187,300.00 52,991.06 52,991.06 4.46 1,134,308.94 Snow Removal 297,550.00 32,909.95 32,909.95 11.06 264,640.0E Equipment Services 196,550.00 11,997.92 11,997.92 6.10 184,552.08 Engineering 219,550.00 14,725.72 14,725.72 6.71 204,824.28 TOTAL Public Works 1,900,950.00 112,624.65 112,624.65 5.92 1,788,325.3E 2 -09 -2015 12:20 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 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 Parks & Rec Admin Recreation Programs Sr Citizen Programs TOTAL Culture & Recreation Economic Development Economic Development Energy City TOTAL Economic Development General TOTAL EXPENDITURES 967,150.00 54,727.16 54,727.16 5.66 912,422.84 533,200.00 42,190.86 42,190.86 7.91 491,009.14 165,750.00 2,315.73 2,315.73 1.40 163,434.27 215,600.00 12,266.64 12,266.64 5.69 203,333.36 1,881,700.00 111,500.39 111,500.39 5.93 1,770,199.61 0.00 10,254.88 10,254.88 0.00 ( 10,254.88) 10,100.00 401.35 401.35 3.97 9,698.65 10,100.00 10,656.23 10,656.23 105.51 ( 556.23) 13,312,800.00 883,740.91 883,740.91 6.64 12,429,059.09 REVENUES OVER /(UNDER) EXPENDITURES 0.00 ( 763,529.45)( 763,529.45) 763,529.4E 2 -09 -2015 12:20 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 101- GENERAL FUND REVENUES General Fund saxes 101 -3- 0000 -3111 Current Ad Valorem Taxes 101 -3- 0000 -3121 Gravel Tax 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 -3235 Animal License 101 -3- 0000 -3236 Parking Permit 101 -3- 0000 -3237 Other Non - Business Lic /Permit TOTAL Licenses & Permits Intergovernmental Rev 101 -3- 0000 -3311 Federal Grant 101 -3- 0000 -3322 MV Credit 101 -3- 0000 -3324 PERA Aid 101 -3- 0000 -3325 Police 20 Aid 101 -3- 0000 -3326 Police Training Reimb 101 -3- 0000 -3329 State Crime Prevention Grant 101 -3- 0000 -3330 Other State Grants TOTAL Intergovernmental Rev Charges for Services 101 -3- 0000 -3412 Planning & Zoning Fees 101 -3- 0000 -3413 Plan Check Fee 101 -3- 0000 -3415 Special Assessment Search 101 -3- 0000 -3417 Copies 101 -3- 0000 -3418 Other General Govt Services 101 -3- 0000 -3430 Lockout Fees 101 -3- 0000 -3431 Police Services 101 -3- 0000 -3432 School Liaison 101 -3- 0000 -3434 Animal Impound Fee 101 -3- 0000 -3436 Fire Contracts 101 -3- 0000 -3437 Fire Services 101 -3- 0000 -3438 Fire Inspections CURRENT CURRENT BUDGET PERIOD 08.33° OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE 9,420,750.00 0.00 0.00 0.00 9,420,750.00 125,000.00 0.00 0.00 0.0C 125,000.00 9,545,750.00 0.00 0.00 0.00 9,545,750.00 61,000.00 0.00 0.00 0.00 61,000.00 1,200.00 0.00 0.00 0.00 1,200.00 3,500.00 0.00 0.00 0.00 3,500.00 30,000.00 4,199.00 4,199.00 14.00 25,801.00 21,000.00 0.00 0.00 0.00 21,000.00 2,000.00 360.00 360.00 18.00 1,640.00 11,000.00 760.00 760.00 6.91 10,240.00 10,000.00 0.00 0.00 0.00 10,000.0C 350,000.00 3,769.15 3,769.15 1.08 346,230.8E 92,000.00 7,819.88 7,819.88 8.50 84,180.12 2,000.00 532.43 532.43 26.62 1,467.57 6,000.00 680.00 680.00 11.33 5,320.00 1,200.00 40.00 40.00 3.33 1,160.00 8,500.00 430.00 430.00 5.06 8,070.0C 599,400.00 18,590.46 18,590.46 3.10 580,809.54 3,600.00 0.00 0.00 0.00 3,600.00 4,000.00 0.00 0.00 0.00 4,000.00 14,100.00 0.00 0.00 0.00 14,100.00 225,000.00 0.00 0.00 0.00 225,000.00 11,000.00 0.00 0.00 0.00 11,000.0C 25,250.00 0.00 0.00 0.00 25,250.00 3,600.00 0.00 0.00 0.0C 3,600.00 286,550.00 0.00 0.00 0.00 286,550.00 12,000.00 2,950.00 2,950.00 24.58 9,050.00 105,000.00 1,039.77 1,039.77 0.99 103,960.23 1,000.00 60.00 60.00 6.00 940.00 2,000.00 121.75 121.75 6.09 1,878.2E 4,500.00 125.00 125.00 2.78 4,375.00 7,500.00 490.00 490.00 6.53 7,010.0C 6,000.00 30.00 30.00 0.50 5,970.00 123,600.00 61,812.00 61,812.00 50.01 61,788.00 3,000.00 200.00 200.00 6.67 2,800.00 206,000.00 0.00 0.00 0.00 206,000.00 3,000.00 31.40 31.40 1.05 2,968.6C 10,000.00 0.00 0.00 0.00 10,000.0C 2 -09 -2015 12:20 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 101- GENERAL FUND 08.33° OF YEAR COMP. REVENUES CURRENT BUDGET CURRENT PERIOD YEAR TO DATE ACTUAL o OF BUDGET BUDGET BALANCE 101 -3- 0000 -3450 Maintenance Facility Rent 14,100.00 1,156.50 1,156.50 8.20 12,943.5C 101 -3- 0000 -3451 Street Services 38,900.00 730.00 730.00 1.88 38,170.00 101 -3- 0000 -3452 Engineering Services Reimb 141,700.00 0.00 0.00 0.00 141,700.00 101 -3- 0000 -3461 Recreation Fees 95,000.00 2,201.84 2,201.84 2.32 92,798.16 101 -3- 0000 -3462 Sr Center Activities 28,000.00 2,930.00 2,930.00 10.46 25,070.00 101 -3- 0000 -3472 Park Use Fee 22,000.00 2,255.00 2,255.00 10.25 19,745.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 5,000.00 215.00 215.00 4.30 4,785.00 101 -3- 0000 -3484 Contractor License Check 500.00 10.00 10.00 2.00 490.00 TOTAL Charges for Services 831,200.00 76,558.26 76,558.26 9.21 754,641.74 Fines & Forfeits 101 -3- 0000 -3510 Court Fines 115,000.00 155.00 155.00 0.13 114,845.00 101 -3- 0000 -3511 Parking Fines 10,000.00 3,400.00 3,400.00 34.00 6,600.00 101 -3- 0000 -3512 Ordinance Violations 0.00 200.00 200.00 O.00 ( 200.00) TOTAL Fines & Forfeits 125,000.00 3,755.00 3,755.00 3.00 121,245.00 Special Assessments 101 -3- 0000 -3610 Special Assmts- County 0.00 3,485.95 3,485.95 O.00 ( 3,485.95) TOTAL Special Assessments 0.00 3,485.95 3,485.95 0.00 ( 3,485.95) Other Revenue 101 -3- 0000 -3621 Interest Income 85,000.00 0.00 0.00 0.00 85,000.00 101 -3- 0000 -3625 Refunds & Reimbursements 101,000.00 3,214.00 3,214.00 3.18 97,786.00 101 -3- 0000 -3626 Contributions 25,000.00 14,500.00 14,500.00 58.00 10,500.00 101 -3- 0000 -3629 Miscellaneous Revenue 6,000.00 107.79 107.79 1.8C 5,892.21 TOTAL Other Revenue 217,000.00 17,821.79 17,821.79 8.21 199,178.21 Transfers In 101 -3- 0000 -3921 Transfers 212,700.00 0.00 0.00 0.00 212,700.00 101 -3- 0000 -3925 Transfer - Landfill 53,950.00 0.00 0.00 0.00 53,950.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 62,600.00 0.00 0.00 0.00 62,600.00 101 -3- 0000 -3942 Transfer -WWTS 100,000.00 0.00 0.00 0.00 100,000.00 101 -3- 0000 -3943 Transfer - Liquor 399,050.00 0.00 0.00 0.00 399,050.00 101 -3- 0000 -3944 Transfer - Garbage 43,950.00 0.00 0.00 0.00 43,950.00 101 -3- 0000 -3945 Transfer - Utilities 740,900.00 0.00 0.00 0.00 740,900.00 101 -3- 0000 -3948 Transfer -EDA 32,000.00 0.00 0.00 0.00 32,000.00 101 -3- 0000 -3949 Transfer -HRA 23,250.00 0.00 0.00 O.00 23,250.00 TOTAL Transfers In 1,707,900.00 0.00 0.00 0.00 1,707,900.00 TOTAL General Fund 13,312,800.00 120,211.46 120,211.46 0.90 13,192,588.54 TOTAL REVENUE 13,312,800.00 120,211.46 120,211.46 0.90 13,192,588.54 2 -09 -2015 12:20 PM 101- GENERAL FUND General Government Mayor & Council DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 1110 -4103 Part -time Pay 101 -4- 1110 -4104 PERA 101 -4- 1110 -4105 FICA 101 -4- 1110 -4107 Medicare 101 -4- 1110 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 1110 -4201 Office Supplies TOTAL Supplies Other Services & Charges 101 -4- 1110 -4319 Other Professional Services 101 -4- 1110 -4322 Postage 101 -4- 1110 -4331 Travel, Conferences & Schools 101 -4- 1110 -4359 Publishing 101 -4- 1110 -4361 Insurance 101 -4- 1110 -4433 Dues & Subscriptions 101 -4- 1110 -4440 Miscellaneous TOTAL Other Services & Charges Capital Outlay TOTAL Mayor & Council 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 38,500.00 3,208.32 3,208.32 8.33 35,291.68 1,900.00 100.01 100.01 5.26 1,799.99 2,400.00 74.92 74.92 3.12 2,325.08 550.00 46.52 46.52 8.46 503.48 100.00 19.50 19.50 19.5C 80.5C 43,450.00 3,449.27 3,449.27 7.94 40,000.73 1,200.00 0.00 0.00 0.0C 1,200.00 1,200.00 0.00 0.00 0.00 1,200.00 10,400.00 0.00 0.00 0.00 10,4OO.00 300.00 0.00 0.00 0.00 300.00 3,100.00 630.00 630.00 20.32 2,470.00 3,700.00 0.00 0.00 0.00 3,700.00 33,650.00 8,252.25 8,252.25 24.52 25,397.7E 18,050.00 0.00 0.00 0.00 18,050.00 27,200.00 100.00 100.00 0.37 27,100.00 96,400.00 8,982.25 8,982.25 9.32 87,417.7E 141,050.00 12,431.52 12,431.52 8.81 128,618.48 2 -09 -2015 12:20 PM 101- GENERAL FUND General Government Cable TV DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 1120 -4101 Regular Pay 101 -4- 1120 -4103 Part -time Pay 101 -4- 1120 -4104 PERA 101 -4- 1120 -4105 FICA 101 -4- 1120 -4107 Medicare 101 -4- 1120 -4108 Insurance 101 -4- 1120 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 1120 -4201 Office Supplies TOTAL Supplies Other Services & Charges 101 -4- 1120 -4322 Postage 101 -4- 1120 -4331 Travel, Conferences & Schools 101 -4- 1120 -4404 Equip Repair /Maint Services TOTAL Other Services & Charges Capital Outlay 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 62,150.00 4,062.32 4,062.32 6.54 58,087.68 17,600.00 590.58 590.58 3.36 17,009.42 6,000.00 534.12 534.12 8.90 5,465.88 4,950.00 445.42 445.42 9.00 4,504.58 1,150.00 104.17 104.17 9.06 1,045.83 13,900.00 1,102.01 1,102.01 7.93 12,797.99 350.00 87.00 87.00 24.86 263.00 106,100.00 6,925.62 6,925.62 6.53 99,174.38 750.00 0.00 0.00 0.0C 750.00 750.00 0.00 0.00 0.00 750.00 50.00 0.00 0.00 0.00 50.00 1,350.00 0.00 0.00 0.00 1,350.00 150.00 0.00 0.00 0.0C 150.00 1,550.00 0.00 0.00 0.00 1,550.00 TOTAL Cable TV 108,400.00 6,925.62 6,925.62 6.39 101,474.38 2 -09 -2015 12:20 PM 101- GENERAL FUND General Government Administrative Services DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 1210 -4101 Regular Pay 101 -4- 1210 -4103 Part -time Pay 101 -4- 1210 -4104 PERA 101 -4- 1210 -4105 FICA 101 -4- 1210 -4107 Medicare 101 -4- 1210 -4108 Insurance 101 -4- 1210 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 1210 -4201 Office Supplies TOTAL Supplies Other Services & Charges 101 -4- 1210 -4319 Other Professional Services 101 -4- 1210 -4321 Telephone 101 -4- 1210 -4322 Postage 101 -4- 1210 -4331 Travel, Conferences & Schools 101 -4- 1210 -4334 Car Allowance 101 -4- 1210 -4359 Publishing 101 -4- 1210 -4361 Insurance 101 -4- 1210 -4404 Equip Repair /Maint Services 101 -4- 1210 -4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 381,100.00 24,918.81 24,918.81 6.54 356,181.19 43,000.00 2,664.15 2,664.15 6.20 40,335.85 31,800.00 3,643.54 3,643.54 11.46 28,156.46 26,300.00 2,953.21 2,953.21 11.23 23,346.79 6,150.00 690.69 690.69 11.23 5,459.31 38,450.00 2,860.01 2,860.01 7.44 35,589.99 2,000.00 450.75 450.75 22.54 1,549.25 528,800.00 38,181.16 38,181.16 7.22 490,618.84 13,000.00 120.00 120.00 0.92 12,880.00 13,000.00 120.00 120.00 0.92 12,880.00 11,100.00 335.00 335.00 3.02 10,765.00 1,100.00 0.00 0.00 0.00 1,100.00 800.00 0.00 0.00 0.00 800.00 10,250.00 2,410.00 2,410.00 23.51 7,840.00 4,800.00 400.00 400.00 8.33 4,400.00 12,000.00 3,186.00 3,186.00 26.55 8,814.00 100.00 26.50 26.50 26.50 73.5C 16,050.00 1,197.33 1,197.33 7.46 14,852.67 2,000.00 290.00 290.00 14.5C 1,710.00 58,200.00 7,844.83 7,844.83 13.48 50,355.17 TOTAL Administrative Services 600,000.00 46,145.99 46,145.99 7.69 553,854.01 2 -09 -2015 12:20 PM 101- GENERAL FUND General Government Human Resources DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 1220 -4101 Regular Pay 101 -4- 1220 -4104 PERA 101 -4- 1220 -4105 FICA 101 -4- 1220 -4107 Medicare 101 -4- 1220 -4108 Insurance 101 -4- 1220 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 1220 -4201 Office Supplies TOTAL Supplies Other Services & Charges 101 -4- 1220 -4319 Other Professional Services 101 -4- 1220 -4322 Postage 101 -4- 1220 -4331 Travel, Conferences & Schools 101 -4- 1220 -4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 116,300.00 4,802.04 4,802.04 4.13 111,497.96 8,700.00 631.40 631.40 7.26 8,068.6C 7,200.00 509.18 509.18 7.07 6,690.82 1,700.00 119.08 119.08 7.00 1,580.92 17,400.00 589.00 589.00 3.39 16,811.00 350.00 126.25 126.25 36.07 223.75 151,650.00 6,776.95 6,776.95 4.47 144,873.0E 4,650.00 0.00 0.00 0.0C 4,650.00 4,650.00 0.00 0.00 0.00 4,650.00 1,000.00 0.00 0.00 0.00 1,000.00 500.00 0.00 0.00 0.00 500.00 3,200.00 0.00 0.00 0.00 3,200.00 750.00 0.00 0.00 0.0C 750.00 5,450.00 0.00 0.00 0.00 5,450.00 TOTAL Human Resources 161,750.00 6,776.95 6,776.95 4.19 154,973.05 2 -09 -2015 12:20 PM 101- GENERAL FUND General Government Elections DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Supplies 101 -4- 1230 -4219 Operating Supplies 2,550.00 0.00 0.00 O.00 2,550.00 TOTAL Supplies 2,550.00 0.00 0.00 0.00 2,550.00 Other Services & Charges 101 -4- 1230 -4322 Postage 300.00 0.00 0.00 0.00 300.00 101 -4- 1230 -4331 Travel, Conferences & Schools 250.00 0.00 0.00 0.00 250.00 101 -4- 1230 -4359 Publishing 700.00 0.00 0.00 0.00 700.00 101 -4- 1230 -4404 Equip Repair /Maint Services 8,850.00 0.00 0.00 0.00 8,850.00 101 -4- 1230 -4415 Equipment Rental 700.00 0.00 0.00 O.00 700.00 TOTAL Other Services & Charges 10,800.00 0.00 0.00 0.00 10,800.00 Capital Outlay TOTAL Elections 13,350.00 0.00 0.00 0.00 13,350.00 2 -09 -2015 12:20 PM 101- GENERAL FUND General Government Finance DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: It REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 1310 -4101 Regular Pay 101 -4- 1310 -4103 Part -time Pay 101 -4- 1310 -4104 PERA 101 -4- 1310 -4105 FICA 101 -4- 1310 -4107 Medicare 101 -4- 1310 -4108 Insurance 101 -4- 1310 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4 -1310 -4201 Office Supplies TOTAL Supplies Other Services & Charges 101 -4- 1310 -4301 Audit Fees 101 -4- 1310 -4319 Other Professional Services 101 -4 -1310 -4321 Telephone 101 -4- 1310 -4322 Postage 101 -4- 1310 -4331 Travel, Conferences & Schools 101 -4- 1310 -4359 Publishing 101 -4- 1310 -4404 Equip Repair /Maint Services 101 -4- 1310 -4433 Dues & Subscriptions 101 -4- 1310 -4438 Credit Card Fees 101 -4- 1310 -4440 Miscellaneous TOTAL Other Services & Charges Capital Outlay 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 311,550.00 20,369.43 20,369.43 6.54 291,180.57 52,350.00 4,062.32 4,062.32 7.76 48,287.68 27,300.00 3,177.33 3,177.33 11.64 24,122.67 22,550.00 2,552.14 2,552.14 11.32 19,997.86 5,300.00 596.88 596.88 11.26 4,703.12 33,550.00 3,054.23 3,054.23 9.10 30,495.77 1,700.00 382.25 382.25 22.49 1,317.75 454,300.00 34,194.58 34,194.58 7.53 420,105.42 4,650.00 0.00 0.00 0.0C 4,650.00 4,650.00 0.00 0.00 0.00 4,650.00 19,000.00 2,400.00 2,400.00 12.63 16,600.00 54,000.00 0.00 0.00 0.00 54,000.00 500.00 0.00 0.00 0.00 500.00 2,500.00 0.00 0.00 0.00 2,500.00 2,500.00 0.00 0.00 0.00 2,500.00 1,050.00 0.00 0.00 0.00 1,050.00 21,500.00 14,413.10 14,413.10 67.04 7,086.9C 1,600.00 0.00 0.00 0.00 1,600.00 4,500.00 0.00 0.00 0.00 4,500.00 1,350.00 91.30 91.30 6.76 1,258.7C 108,500.00 16,904.40 16,904.40 15.58 91,595.6C TOTAL Finance 567,450.00 51,098.98 51,098.98 9.01 516,351.02 2 -09 -2015 12:20 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 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 182,150.00 11,818.06 11,818.06 6.49 170,331.94 101 -4- 1350 -4104 PERA 13,650.00 1,553.90 1,553.90 11.38 12,096.1C 101 -4- 1350 -4105 FICA 11,300.00 1,217.37 1,217.37 10.77 10,082.63 101 -4- 1350 -4107 Medicare 2,650.00 284.71 284.71 10.74 2,365.29 101 -4- 1350 -4108 Insurance 31,300.00 2,565.03 2,565.03 8.19 28,734.97 101 -4- 1350 -4109 Workers Comp 850.00 191.50 191.50 22.53 658.5C TOTAL Personal Services 241,900.00 17,630.57 17,630.57 7.29 224,269.43 Supplies 101 -4- 1350 -4219 Operating Supplies 12,500.00 0.00 0.00 O.00 12,500.00 TOTAL Supplies 12,500.00 0.00 0.00 0.00 12,500.00 Other Services & Charges 101 -4- 1350 -4319 Other Professional Services 5,000.00 0.00 0.00 0.00 5,000.00 101 -4- 1350 -4321 Telephone 2,500.00 0.00 0.00 0.00 2,500.00 101 -4- 1350 -4331 Travel, Conferences & Schools 10,950.00 0.00 0.00 0.00 10,950.00 101 -4- 1350 -4404 Equip Repair /Maint Services 59,300.00 4,329.09 4,329.09 7.3C 54,970.91 TOTAL Other Services & Charges 77,750.00 4,329.09 4,329.09 5.57 73,420.91 Capital Outlay TOTAL Information Technology 332,150.00 21,959.66 21,959.66 6.61 310,190.34 2 -09 -2015 12:20 PM 101- GENERAL FUND General Government Legal DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Supplies Other Services & Charges 101 -4- 1400 -4304 Legal Fees 217,600.00 0.00 TOTAL Other Services & Charges 217,600.00 0.00 0.00 O.00 217,600.00 0.00 0.00 217,600.00 TOTAL Legal 217,600.00 0.00 0.00 0.00 217,600.00 2 -09 -2015 12:20 PM 101- GENERAL FUND General Government Community Development DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 1500 -4101 Regular Pay 101 -4- 1500 -4104 PERA 101 -4- 1500 -4105 FICA 101 -4- 1500 -4107 Medicare 101 -4- 1500 -4108 Insurance 101 -4- 1500 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 1500 -4201 Office Supplies TOTAL Supplies Other Services & Charges 101 -4- 1500 -4321 Telephone 101 -4- 1500 -4331 Travel, Conferences & Schools 101 -4- 1500 -4433 Dues & Subscriptions TOTAL Other Services & Charges 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 268,300.00 17,543.25 17,543.25 6.54 250,756.7E 20,100.00 2,306.72 2,306.72 11.48 17,793.28 16,650.00 1,871.50 1,871.50 11.24 14,778.5C 3,900.00 437.69 437.69 11.22 3,462.31 21,000.00 2,025.02 2,025.02 9.64 18,974.98 1,250.00 282.00 282.00 22.56 968.00 331,200.00 24,466.18 24,466.18 7.39 306,733.82 1,200.00 0.00 0.00 0.0C 1,200.00 1,200.00 0.00 0.00 0.00 1,200.00 1,400.00 0.00 0.00 0.00 1,400.00 4,200.00 0.00 0.00 0.00 4,200.00 1,600.00 239.00 239.00 14.94 1,361.00 7,200.00 239.00 239.00 3.32 6,961.00 TOTAL Community Development 339,600.00 24,705.18 24,705.18 7.27 314,894.82 2 -09 -2015 12:20 PM 101- GENERAL FUND General Government Planning DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 1510 -4101 Regular Pay 101 -4- 1510 -4104 PERA 101 -4- 1510 -4105 FICA 101 -4- 1510 -4107 Medicare 101 -4- 1510 -4108 Insurance 101 -4- 1510 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 1510 -4201 Office Supplies 101 -4- 1510 -4212 Fuels & Lubes 101 -4- 1510 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 1510 -4321 Telephone 101 -4- 1510 -4322 Postage 101 -4- 1510 -4331 Travel, Conferences & Schools 101 -4- 1510 -4359 Publishing 101 -4- 1510 -4361 Insurance 101 -4- 1510 -4404 Equip Repair /Maint Services 101 -4- 1510 -4433 Dues & Subscriptions 101 -4- 1510 -4440 Miscellaneous TOTAL Other Services & Charges Capital Outlay 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 129,750.00 8,407.15 8,407.15 6.48 121,342.8E 9,750.00 1,105.43 1,105.43 11.34 8,644.57 8,050.00 790.69 790.69 9.82 7,259.31 1,900.00 184.92 184.92 9.73 1,715.08 27,800.00 2,258.00 2,258.00 8.12 25,542.00 650.00 157.00 157.00 24.15 493.00 177,900.00 12,903.19 12,903.19 7.25 164,996.81 1,700.00 0.00 0.00 0.00 1,700.00 300.00 0.00 0.00 0.00 300.00 1,350.00 0.00 0.00 0.0C 1,350.00 3,350.00 0.00 0.00 0.00 3,350.00 50.00 0.00 0.00 0.00 50.00 2,500.00 0.00 0.00 0.00 2,500.00 1,500.00 0.00 0.00 0.00 1,500.00 8,000.00 0.00 0.00 0.00 8,000.0C 100.00 26.25 26.25 26.25 73.7E 1,500.00 0.00 0.00 0.00 1,500.00 400.00 0.00 0.00 0.00 400.00 250.00 0.00 0.00 0.0C 250.00 14,300.00 26.25 26.25 0.18 14,273.7E TOTAL Planning 195,550.00 12,929.44 12,929.44 6.61 182,620.56 2 -09 -2015 12:20 PM 101- GENERAL FUND General Government City Hall Maintenance DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: lE REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 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 & Lubes 101 -4- 1600 -4217 Uniform Allowance 101 -4- 1600 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 1600 -4321 Telephone 101 -4- 1600 -4331 Travel, Conferences & Schools 101 -4- 1600 -4361 Insurance 101 -4- 1600 -4389 Utilities 101 -4- 1600 -4401 Bldg Repair /Maint Services 101 -4- 1600 -4404 Equip Repair /Maint Services 101 -4- 1600 -4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 337,550.00 21,738.12 21,738.12 6.44 315,811.88 3,500.00 22.40 22.40 0.64 3,477.6C 3,400.00 0.00 0.00 0.00 3,400.00 25,600.00 2,865.62 2,865.62 11.19 22,734.38 21,350.00 2,436.77 2,436.77 11.41 18,913.23 5,000.00 569.89 569.89 11.40 4,430.11 42,350.00 3,202.03 3,202.03 7.56 39,147.97 11,350.00 2,684.75 2,684.75 23.65 8,665.25 450,100.00 33,519.58 33,519.58 7.45 416,580.42 4,000.00 0.00 0.00 0.00 4,000.00 2,400.00 159.96 159.96 6.67 2,240.04 32,350.00 4,473.89 4,473.89 13.83 27,876.11 38,750.00 4,633.85 4,633.85 11.96 34,116.1E 11,500.00 0.00 0.00 0.00 11,500.00 1,200.00 0.00 0.00 0.00 1,200.00 5,550.00 1,362.00 1,362.00 24.54 4,188.00 31,450.00 70.00 70.00 0.22 31,380.00 25,700.00 458.40 458.40 1.78 25,241.6C 3,500.00 0.00 0.00 0.00 3,500.00 1,450.00 120.83 120.83 8.33 1,329.17 80,350.00 2,011.23 2,011.23 2.50 78,338.77 TOTAL City Hall Maintenance 569,200.00 40,164.66 40,164.66 7.06 529,035.34 2 -09 -2015 12:20 PM 101- GENERAL FUND General Government Contingency DEPARTMENTAL EXPENDITURES Personal Services 101 -4- 1900 -4101 Regular Pay TOTAL Personal Services Other Services & Charges CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 95,000.00) 0.00 95,000.00) 0.00 0.00 O.00 ( 95,000.00) 0.00 0.00 ( 95,000.00) TOTAL Contingency 95,000.00) 0.00 0.00 0.00 ( 95,000.00) TOTAL General Government 3,151,100.00 223,138.00 223,138.00 7.08 2,927,962.00 2 -09 -2015 12:20 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 101- GENERAL FUND Public Safety Police Administration DEPARTMENTAL EXPENDITURES Personal Services 101 -4- 2110 -4101 Regular Pay 101 -4- 2110 -4104 PERA 101 -4- 2110 -4105 FICA 101 -4- 2110 -4107 Medicare 101 -4- 2110 -4108 Insurance 101 -4- 2110 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 2110 -4201 Office Supplies 101 -4- 2110 -4217 Uniform Allowance 101 -4- 2110 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 2110 -4319 Other Professional Services 101 -4- 2110 -4321 Telephone 101 -4- 2110 -4322 Postage 101 -4- 2110 -4331 Travel, Conferences & Schools 101 -4- 2110 -4359 Publishing 101 -4- 2110 -4361 Insurance 101 -4- 2110 -4404 Equip Repair /Maint Services 101 -4- 2110 -4433 Dues & Subscriptions 101 -4- 2110 -4437 Taxes & Licenses TOTAL Other Services & Charges Capital Outlay CURRENT CURRENT BUDGET PERIOD 08.33° OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE 358,000.00 16,000.76 16,000.76 4.47 341,999.24 52,800.00 4,818.55 4,818.55 9.13 47,981.4E 3,700.00 305.21 305.21 8.25 3,394.79 3,600.00 392.87 392.87 10.91 3,207.13 38,450.00 1,991.02 1,991.02 5.18 36,458.98 59,100.00 14,069.75 14,069.75 23.81 45,030.25 515,650.00 37,578.16 37,578.16 7.29 478,071.84 10,350.00 0.00 0.00 0.00 10,350.00 2,900.00 0.00 0.00 0.00 2,900.00 5,350.00 ( 85.00)( 85.00) 1.59- 5,435.00 18,600.00 ( 85.00)( 85.00) 0.46- 18,685.00 5,900.00 0.00 0.00 0.00 5,900.00 22,950.00 0.00 0.00 0.00 22,950.00 3,150.00 0.00 0.00 0.00 3,150.00 6,800.00 0.00 0.00 0.00 6,800.00 500.00 0.00 0.00 0.00 500.00 43,100.00 10,559.00 10,559.00 24.50 32,541.00 71,300.00 35,164.74 35,164.74 49.32 36,135.26 4,900.00 250.00 250.00 5.10 4,650.00 300.00 132.00 132.00 44.00 168.00 158,900.00 46,105.74 46,105.74 29.02 112,794.26 TOTAL Police Administration 693,150.00 83,598.90 83,598.90 12.06 609,551.1C 2 -09 -2015 12:20 PM 101- GENERAL FUND Public Safety Patrol DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 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 Supplies 101 -4- 2120 -4212 Fuels & Lubes 101 -4- 2120 -4217 Uniform Allowance 101 -4- 2120 -4219 Operating Supplies 101 -4- 2120 -4221 Equipment Parts TOTAL Supplies Other Services & Charges 101 -4- 2120 -4331 Travel, Conferences & Schools 101 -4- 2120 -4404 Equip Repair /Maint Services 101 -4- 2120 -4433 Dues & Subscriptions 101 -4- 2120 -4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 1,598,350.00 98,319.36 98,319.36 6.15 1,500,030.64 90,000.00 1,569.19 1,569.19 1.74 88,430.81 273,500.00 28,703.29 28,703.29 10.49 244,796.71 23,200.00 2,332.90 2,332.90 10.06 20,867.1C 195,200.00 14,264.12 14,264.12 7.31 180,935.88 2,180,250.00 145,188.86 145,188.86 6.66 2,035,061.14 100,000.00 0.00 0.00 0.00 100,000.0C 25,400.00 0.00 0.00 0.00 25,400.00 67,500.00 0.00 0.00 0.00 67,500.00 23,300.00 0.00 0.00 0.0C 23,300.00 216,200.00 0.00 0.00 0.00 216,200.00 26,950.00 0.00 0.00 0.00 26,950.00 25,700.00 0.00 0.00 0.00 25,700.00 650.00 150.00 150.00 23.08 500.00 43,550.00 3,629.17 3,629.17 8.33 39,920.83 96,850.00 3,779.17 3,779.17 3.90 93,070.83 TOTAL Patrol 2,493,300.00 148,968.03 148,968.03 5.97 2,344,331.97 2 -09 -2015 12:20 PM 101- GENERAL FUND Public Safety Investigations DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 2130 -4101 Regular Pay 101 -4- 2130 -4102 Overtime Pay 101 -4- 2130 -4104 PERA 101 -4- 2130 -4107 Medicare 101 -4- 2130 -4108 Insurance TOTAL Personal Services Supplies 101 -4- 2130 -4217 Uniform Allowance 101 -4- 2130 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 2130 -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 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 654,450.00 34,548.23 34,548.23 5.28 619,901.77 50,000.00 931.87 931.87 1.86 49,068.13 114,100.00 10,068.77 10,068.77 8.82 104,031.23 8,900.00 702.09 702.09 7.89 8,197.91 88,950.00 6,470.25 6,470.25 7.27 82,479.75 916,400.00 52,721.21 52,721.21 5.75 863,678.79 6,600.00 0.00 0.00 0.00 6,600.00 12,200.00 0.00 0.00 0.0C 12,200.00 18,800.00 0.00 0.00 0.00 18,800.00 6,500.00 0.00 0.00 0.00 6,500.00 6,350.00 120.00 120.00 1.89 6,230.00 2,050.00 0.00 0.00 0.00 2,050.00 12,950.00 1,079.17 1,079.17 8.33 11,870.83 27,850.00 1,199.17 1,199.17 4.31 26,650.83 TOTAL Investigations 963,050.00 53,920.38 53,920.38 5.60 909,129.62 2 -09 -2015 12:20 PM 101- GENERAL FUND Public Safety Police Support Services DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 2C REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 2150 -4101 Regular Pay 101 -4- 2150 -4102 Overtime Pay 101 -4- 2150 -4104 PERA 101 -4- 2150 -4105 FICA 101 -4- 2150 -4107 Medicare 101 -4- 2150 -4108 Insurance TOTAL Personal Services Supplies 101 -4- 2150 -4201 Office Supplies 101 -4- 2150 -4217 Uniform Allowance 101 -4- 2150 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 2150 -4331 Travel, Conferences & Schools 101 -4- 2150 -4404 Equip Repair /Maint Services 101 -4- 2150 -4409 Contractual Services 101 -4- 2150 -4433 Dues & Subscriptions 101 -4- 2150 -4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 380,550.00 24,595.60 24,595.60 6.46 355,954.4C 10,000.00 882.23 882.23 8.82 9,117.77 29,300.00 3,321.12 3,321.12 11.33 25,978.88 24,200.00 2,673.53 2,673.53 11.05 21,526.47 5,650.00 625.27 625.27 11.07 5,024.73 59,750.00 5,163.08 5,163.08 8.64 54,586.92 509,450.00 37,260.83 37,260.83 7.31 472,189.17 1,000.00 0.00 0.00 0.00 1,000.00 3,850.00 ( 20.25)( 20.25) 0.53- 3,870.2E 11,450.00 0.00 0.00 0.0C 11,450.00 16,300.00 ( 20.25)( 20.25) 0.12- 16,320.2E 3,700.00 0.00 0.00 0.00 3,700.00 2,200.00 0.00 0.00 0.00 2,200.00 16,900.00 0.00 0.00 0.00 16,900.00 550.00 0.00 0.00 0.00 550.00 6,650.00 554.17 554.17 8.33 6,095.83 30,000.00 554.17 554.17 1.85 29,445.83 TOTAL Police Support Services 555,750.00 37,794.75 37,794.75 6.80 517,955.2E 2 -09 -2015 12:20 PM 101- GENERAL FUND Public Safety Police Reserves DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Outlay TOTAL 101 -4- 2160 -4103 Part -time Pay 5,500.00 0.00 0.00 0.00 5,500.00 101 -4- 2160 -4105 FICA 350.00 0.00 0.00 0.00 350.00 101 -4- 2160 -4107 Medicare 100.00 0.00 0.00 O.00 100.00 TOTAL Personal Services 5,950.00 0.00 0.00 0.00 5,950.00 Supplies 101 -4- 2160 -4217 Uniform Allowance 5,500.00 0.00 0.00 0.00 5,500.00 101 -4- 2160 -4219 Operating Supplies 4,000.00 0.00 0.00 O.00 4,000.00 TOTAL Supplies 9,500.00 0.00 0.00 0.00 9,500.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 O.00 3,200.00 TOTAL Other Services & Charges 5,350.00 0.00 0.00 0.00 5,350.00 Capital Outlay TOTAL Police Reserves 20,800.00 0.00 0.00 0.00 20,800.00 2 -09 -2015 12:20 PM 101- GENERAL FUND Public Safety Public safety building DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Supplies 101 -4- 2190 -4219 Operating Supplies 15,200.00 TOTAL Supplies 15,200.00 Other Services & Charges 101 -4- 2190 -4361 Insurance 5,300.00 101 -4- 2190 -4389 Utilities 18,000.00 101 -4 -2190 -4401 Bldg Repair /Maint Services 38,650.00 TOTAL Other Services & Charges 61,950.00 Capital Outlay 0.00 0.00 O.00 15,200.00 0.00 0.00 0.00 15,200.00 1,320.75 1,320.75 24.92 3,979.2E 70.00 70.00 0.39 17,930.00 881.79 881.79 2.28 37,768.21 2,272.54 2,272.54 3.67 59,677.46 TOTAL Public safety building 77,150.00 2,272.54 2,272.54 2.95 74,877.46 2 -09 -2015 12:20 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 101- GENERAL FUND Public Safety Fire Administration DEPARTMENTAL EXPENDITURES 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 101 -4- 2310 -4107 Medicare 101 -4- 2310 -4108 Insurance 101 -4- 2310 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 2310 -4201 Office Supplies 101 -4- 2310 -4212 Fuels & Lubes 101 -4- 2310 -4217 Uniform Allowance 101 -4- 2310 -4221 Equipment Parts TOTAL Supplies Other Services & Charges 101 -4- 2310 -4319 Other Professional Services 101 -4- 2310 -4321 Telephone 101 -4- 2310 -4322 Postage 101 -4- 2310 -4331 Travel, Conferences & Schools 101 -4- 2310 -4359 Publishing 101 -4- 2310 -4361 Insurance 101 -4 -2310 -4389 Utilities 101 -4- 2310 -4401 Bldg Repair /Maint Services 101 -4- 2310 -4404 Equip Repair /Maint Services 101 -4- 2310 -4433 Dues & Subscriptions 101 -4 -2310 -4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay CURRENT CURRENT BUDGET PERIOD 08.33° OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE 187,400.00 12,139.31 12,139.31 6.48 175,260.69 28,100.00 1,773.75 1,773.75 6.31 26,326.2E 32,450.00 3,680.70 3,680.70 11.34 28,769.3C 1,750.00 192.59 192.59 11.01 1,557.41 30,000.00 0.00 0.00 0.00 30,000.00 3,100.00 340.38 340.38 10.98 2,759.62 17,400.00 1,826.81 1,826.81 10.50 15,573.19 7,850.00 2,000.75 2,000.75 25.49 5,849.25 308,050.00 21,954.29 21,954.29 7.13 286,095.71 3,150.00 0.00 0.00 0.00 3,150.00 4,000.00 0.00 0.00 0.00 4,000.00 1,500.00 0.00 0.00 0.00 1,500.00 450.00 0.00 0.00 0.0C 450.00 9,100.00 0.00 0.00 0.00 9,100.0C 5,000.00 0.00 0.00 0.00 5,000.00 3,750.00 0.00 0.00 0.00 3,750.00 500.00 0.00 0.00 0.00 500.00 6,000.00 0.00 0.00 0.00 6,000.00 500.00 0.00 0.00 0.00 500.00 11,200.00 2,761.00 2,761.00 24.65 8,439.00 12,000.00 25.00 25.00 0.21 11,975.00 7,000.00 0.00 0.00 0.00 7,000.00 3,950.00 0.00 0.00 0.00 3,950.00 2,000.00 0.00 0.00 0.00 2,000.00 38,550.00 3,212.50 3,212.50 8.33 35,337.5C 90,450.00 5,998.50 5,998.50 6.63 84,451.5C TOTAL Fire Administration 407,600.00 27,952.79 27,952.79 6.86 379,647.21 2 -09 -2015 12:20 PM 101- GENERAL FUND Public Safety Fire Operations DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 2320 -4103 Part -time Pay 101 -4- 2320 -4105 FICA 101 -4- 2320 -4107 Medicare 101 -4- 2320 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 2320 -4201 Office Supplies 101 -4- 2320 -4212 Fuels & Lubes 101 -4- 2320 -4217 Uniform Allowance 101 -4- 2320 -4219 Operating Supplies 101 -4- 2320 -4221 Equipment Parts 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 -4409 Contractual Services TOTAL Other Services & Charges Capital Outlay TOTAL Fire Operations 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 169,700.00 10,542.61 10,542.61 6.21 159,157.39 10,500.00 898.93 898.93 8.56 9,601.07 2,450.00 210.29 210.29 8.58 2,239.71 27,400.00 6,363.75 6,363.75 23.23 21,036.25 210,050.00 18,015.58 18,015.58 8.58 192,034.42 1,200.00 0.00 0.00 0.00 1,200.00 7,000.00 0.00 0.00 0.00 7,000.00 9,150.00 0.00 0.00 0.00 9,150.00 79,500.00 0.00 0.00 0.00 79,500.00 7,250.00 0.00 0.00 0.0C 7,250.00 104,100.00 0.00 0.00 0.00 104,100.00 2,950.00 0.00 0.00 0.00 2,950.00 26,000.00 0.00 0.00 0.00 26,000.00 36,600.00 0.00 0.00 0.00 36,600.00 8,650.00 0.00 0.00 0.0C 8,650.00 74,200.00 0.00 0.00 0.00 74,200.00 388,350.00 18,015.58 18,015.58 4.64 370,334.42 2 -09 -2015 12:20 PM 101- GENERAL FUND Public Safety Emergency Management DEPARTMENTAL EXPENDITURES Personal Services CITY OF ELK RIVER PAGE: 2E REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 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 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 800.00 0.00 0.00 0.00 800.00 10,600.00 0.00 0.00 0.0C 10,600.00 11,400.00 0.00 0.00 0.00 11,400.00 250.00 0.00 0.00 0.00 250.00 5,400.00 0.00 0.00 0.00 5,4OO.00 700.00 0.00 0.00 0.00 700.00 3,450.00 0.00 0.00 0.00 3,450.00 200.00 0.00 0.00 0.0C 200.00 10,000.00 0.00 0.00 0.00 10,000.00 TOTAL Emergency Management 21,400.00 0.00 0.00 0.00 21,400.00 2 -09 -2015 12:20 PM 101- GENERAL FUND Public Safety Building Safety DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 2410 -4101 Regular 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- 2410 -4201 Office Supplies 101 -4- 2410 -4212 Fuels & Lubes 101 -4- 2410 -4217 Uniform Allowance 101 -4- 2410 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 2410 -4321 Telephone 101 -4- 2410 -4322 Postage 101 -4- 2410 -4331 Travel, Conferences & Schools 101 -4- 2410 -4361 Insurance 101 -4- 2410 -4404 Equip Repair /Maint Services 101 -4- 2410 -4433 Dues & Subscriptions 101 -4- 2410 -4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 448,500.00 29,241.45 29,241.45 6.52 419,258.5E 40,050.00 4,577.43 4,577.43 11.43 35,472.57 23,250.00 2,524.16 2,524.16 10.86 20,725.84 6,500.00 707.54 707.54 10.89 5,792.46 59,150.00 5,923.04 5,923.04 10.01 53,226.96 2,100.00 486.50 486.50 23.17 1,613.5C 579,550.00 43,460.12 43,460.12 7.50 536,089.88 8,000.00 0.00 0.00 0.00 8,000.0C 8,000.00 0.00 0.00 0.00 8,000.0C 2,000.00 0.00 0.00 0.00 2,000.00 10,150.00 0.00 0.00 0.0C 10,150.00 28,150.00 0.00 0.00 0.00 28,150.00 5,100.00 0.00 0.00 0.00 5,100.00 600.00 0.00 0.00 0.00 600.00 3,500.00 1,075.00 1,075.00 30.71 2,425.00 500.00 116.25 116.25 23.25 383.7E 5,000.00 0.00 0.00 0.00 5,000.0C 3,650.00 100.00 100.00 2.74 3,550.00 2,900.00 241.67 241.67 8.33 2,658.33 21,250.00 1,532.92 1,532.92 7.21 19,717.08 TOTAL Building Safety 628,950.00 44,993.04 44,993.04 7.15 583,956.96 2 -09 -2015 12:20 PM 101- GENERAL FUND Public Safety Code Enforcement DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 27 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 2420 -4101 Regular Pay 101 -4- 2420 -4104 PERA 101 -4- 2420 -4105 FICA 101 -4- 2420 -4107 Medicare 101 -4- 2420 -4108 Insurance 101 -4- 2420 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 2420 -4212 Fuels & Lubes 101 -4- 2420 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 2420 -4321 Telephone 101 -4- 2420 -4322 Postage 101 -4- 2420 -4331 Travel, Conferences & Schools 101 -4- 2420 -4361 Insurance 101 -4- 2420 -4460 Equip Replacement Charge TOTAL Other Services & Charges TOTAL Code Enforcement 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 68,900.00 4,505.68 4,505.68 6.54 64,394.32 5,150.00 592.44 592.44 11.50 4,557.56 4,250.00 501.95 501.95 11.81 3,748.0E 1,000.00 117.39 117.39 11.74 882.61 3,600.00 300.01 300.01 8.33 3,299.99 350.00 75.50 75.50 21.57 274.5C 83,250.00 6,092.97 6,092.97 7.32 77,157.03 2,000.00 0.00 0.00 0.00 2,000.00 700.00 0.00 0.00 O.00 700.00 2,700.00 0.00 0.00 0.00 2,700.00 800.00 0.00 0.00 0.00 800.00 800.00 0.00 0.00 0.00 800.00 700.00 0.00 0.00 0.00 700.00 100.00 29.00 29.00 29.00 71.00 950.00 79.17 79.17 8.33 870.83 3,350.00 108.17 108.17 3.23 3,241.83 89,300.00 6,201.14 6,201.14 6.94 83,098.86 2 -09 -2015 12:20 PM 101- GENERAL FUND Public Safety Environmental DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 28 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 2440 -4101 Regular Pay 101 -4- 2440 -4104 PERA 101 -4- 2440 -4105 FICA 101 -4- 2440 -4107 Medicare 101 -4- 2440 -4108 Insurance 101 -4- 2440 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 2440 -4201 Office Supplies 101 -4- 2440 -4212 Fuels & Lubes 101 -4- 2440 -4217 Uniform Allowance TOTAL Supplies Other Services & Charges 101 -4- 2440 -4321 Telephone 101 -4- 2440 -4322 Postage 101 -4- 2440 -4331 Travel, Conferences & Schools 101 -4- 2440 -4359 Publishing 101 -4- 2440 -4433 Dues & Subscriptions TOTAL Other Services & Charges 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 21,400.00 1,369.94 1,369.94 6.40 20,030.06 1,600.00 180.13 180.13 11.26 1,419.87 1,350.00 148.90 148.90 11.03 1,201.1C 300.00 34.84 34.84 11.61 265.16 1,400.00 307.18 307.18 21.94 1,092.82 300.00 63.50 63.50 21.17 236.5C 26,350.00 2,104.49 2,104.49 7.99 24,245.51 900.00 0.00 0.00 0.00 900.00 200.00 0.00 0.00 0.00 200.00 100.00 0.00 0.00 0.0C 100.00 1,200.00 0.00 0.00 0.00 1,200.00 350.00 0.00 0.00 0.00 350.00 700.00 0.00 0.00 0.00 700.00 850.00 0.00 0.00 0.00 850.00 500.00 0.00 0.00 0.00 500.00 200.00 0.00 0.00 0.0C 200.00 2,600.00 0.00 0.00 0.00 2,600.00 TOTAL Environmental 30,150.00 2,104.49 2,104.49 6.98 28,045.51 TOTAL Public Safety 6,368,950.00 425,821.64 425,821.64 6.69 5,943,128.36 2 -09 -2015 12:20 PM 101- GENERAL FUND Public Works Street Maintenance DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 29 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Services & Charges 101 -4- 3120 -4101 Regular Pay 478,400.00 18,346.54 18,346.54 3.83 460,053.46 101 -4 -3120 -4102 Overtime Pay 4,000.00 28.79 28.79 0.72 3,971.21 101 -4- 3120 -4103 Part -time Pay 72,700.00 5,029.11 5,029.11 6.92 67,670.89 101 -4 -3120 -4104 PERA 40,000.00 2,794.01 2,794.01 6.99 37,205.99 101 -4- 3120 -4105 FICA 34,400.00 2,500.22 2,500.22 7.27 31,899.78 101 -4- 3120 -4107 Medicare 8,050.00 584.74 584.74 7.26 7,465.26 101 -4- 3120 -4108 Insurance 67,100.00 3,060.14 3,060.14 4.56 64,039.86 101 -4 -3120 -4109 Workers Comp 28,100.00 6,629.00 6,629.00 23.59 21,471.00 0.00 TOTAL Personal Services 732,750.00 38,972.55 38,972.55 5.32 693,777.4E Supplies 0.00 0.00 9,000.00 101 -4 -3120 -4409 Contractual Services 101 -4- 3120 -4201 Office Supplies 2,850.00 0.00 0.00 0.00 2,850.00 101 -4- 3120 -4212 Fuels & Lubes 75,000.00 0.00 0.00 0.00 75,000.00 101 -4- 3120 -4219 Operating Supplies 39,500.00 0.00 0.00 0.00 39,500.00 101 -4- 3120 -4221 Equipment Parts 54,800.00 118.09 118.09 0.22 54,681.91 101 -4- 3120 -4226 Street Signs 24,000.00 0.00 0.00 O.00 24,000.00 92,300.00 TOTAL Supplies 7,691.67 196,150.00 118.09 118.09 0.06 196,031.91 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 0.00 0.00 0.00 6,100.00 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 95.00 95.00 2.71 3,405.00 101 -4- 3120 -4359 Publishing 200.00 0.00 0.00 0.00 200.00 101 -4 -3120 -4361 Insurance 19,850.00 4,890.00 4,890.00 24.63 14,960.00 101 -4- 3120 -4389 Utilities 54,000.00 950.00 950.00 1.76 53,050.00 101 -4- 3120 -4401 Bldg Repair /Maint Services 14,500.00 0.00 0.00 0.00 14,500.00 101 -4- 3120 -4404 Equip Repair /Maint Services 9,000.00 0.00 0.00 0.00 9,000.00 101 -4 -3120 -4409 Contractual Services 49,000.00 0.00 0.00 0.00 49,000.00 101 -4- 3120 -4415 Equipment Rental 3,000.00 0.00 0.00 0.00 3,000.00 101 -4 -3120 -4417 Uniform Rental 5,800.00 0.00 0.00 0.00 5,800.00 101 -4- 3120 -4433 Dues & Subscriptions 350.00 273.75 273.75 78.21 76.2E 101 -4- 3120 -4437 Taxes & Licenses 150.00 0.00 0.00 0.00 150.00 101 -4- 3120 -4460 Equip Replacement Charge 92,300.00 7,691.67 7,691.67 8.33 84,608.33 TOTAL Other Services & Charges 258,400.00 13,900.42 13,900.42 5.38 244,499.58 Capital Outlay TOTAL Street Maintenance 1,187,300.00 52,991.06 52,991.06 4.46 1,134,308.94 2 -09 -2015 12:20 PM 101- GENERAL FUND Public Works Snow Removal DEPARTMENTAL EXPENDITURES Personal Services 101 -4- 3130 -4101 Regular Pay 101 -4- 3130 -4102 Overtime Pay 101 -4- 3130 -4104 PERA 101 -4 -3130 -4105 FICA 101 -4- 3130 -4107 Medicare 101 -4- 3130 -4108 Insurance 101 -4- 3130 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 3130 -4219 Operating Supplies TOTAL Supplies Other Services & Charges Capital Outlay CITY OF ELK RIVER PAGE: 3C REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 133,550.00 20,392.77 20,392.77 15.27 113,157.23 20,000.00 1,023.09 1,023.09 5.12 18,976.91 11,050.00 3,016.23 3,016.23 27.30 8,033.77 9,500.00 2,447.94 2,447.94 25.77 7,052.06 2,250.00 572.51 572.51 25.44 1,677.49 17,800.00 3,652.41 3,652.41 20.52 14,147.59 7,900.00 1,805.00 1,805.00 22.85 6,095.00 202,050.00 32,909.95 32,909.95 16.29 169,140.05 95,500.00 0.00 0.00 0.0C 95,500.00 95,500.00 0.00 0.00 0.00 95,500.00 TOTAL Snow Removal 297,550.00 32,909.95 32,909.95 11.06 264,640.0E 2 -09 -2015 12:20 PM 101- GENERAL FUND Public Works Equipment Services DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 31 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 3150 -4101 Regular Pay 101 -4- 3150 -4102 Overtime Pay 101 -4- 3150 -4104 PERA 101 -4 -3150 -4105 FICA 101 -4- 3150 -4107 Medicare 101 -4- 3150 -4108 Insurance 101 -4- 3150 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 3150 -4212 Fuels & Lubes 101 -4- 3150 -4219 Operating Supplies 101 -4- 3150 -4221 Equipment Parts TOTAL Supplies Other Services & Charges 101 -4- 3150 -4331 Travel, Conferences & Schools 101 -4- 3150 -4404 Equip Repair /Maint Services 101 -4- 3150 -4417 Uniform Rental TOTAL Other Services & Charges Capital Outlay 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 119,150.00 7,791.44 7,791.44 6.54 111,358.56 3,000.00 0.00 0.00 0.00 3,000.00 9,150.00 1,024.44 1,024.44 11.20 8,125.56 7,550.00 816.71 816.71 10.82 6,733.29 1,800.00 191.01 191.01 10.61 1,608.99 14,150.00 1,101.33 1,101.33 7.78 13,048.67 3,350.00 788.00 788.00 23.52 2,562.00 158,150.00 11,712.93 11,712.93 7.41 146,437.07 5,100.00 0.00 0.00 0.00 5,100.00 10,150.00 189.99 189.99 1.87 9,960.01 10,000.00 0.00 0.00 0.0C 10,000.0C 25,250.00 189.99 189.99 0.75 25,060.01 1,000.00 95.00 95.00 9.50 905.00 10,000.00 0.00 0.00 0.00 10,000.0C 2,150.00 0.00 0.00 0.0C 2,150.00 13,150.00 95.00 95.00 0.72 13,055.00 TOTAL Equipment Services 196,550.00 11,997.92 11,997.92 6.10 184,552.08 2 -09 -2015 12:20 PM 101- GENERAL FUND Public Works Engineering DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 32 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 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 -4201 Office Supplies 101 -4- 3300 -4212 Fuels & Lubes 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 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 161,800.00 10,502.61 10,502.61 6.49 151,297.39 12,150.00 1,380.93 1,380.93 11.37 10,769.07 10,050.00 1,150.79 1,150.79 11.45 8,899.21 2,350.00 269.14 269.14 11.45 2,080.86 13,950.00 1,147.00 1,147.00 8.22 12,803.00 800.00 177.00 177.00 22.13 623.00 201,100.00 14,627.47 14,627.47 7.27 186,472.53 300.00 0.00 0.00 0.00 300.00 900.00 0.00 0.00 0.00 900.0C 900.00 0.00 0.00 0.0C 900.0C 2,100.00 0.00 0.00 0.00 2,100.00 9,500.00 0.00 0.00 0.00 9,500.00 1,450.00 0.00 0.00 0.00 1,450.00 300.00 0.00 0.00 0.00 300.00 2,000.00 0.00 0.00 0.00 2,000.00 100.00 23.25 23.25 23.25 76.7E 2,100.00 0.00 0.00 0.00 2,100.00 900.00 75.00 75.00 8.33 825.00 16,350.00 98.25 98.25 0.60 16,251.7E TOTAL Engineering 219,550.00 14,725.72 14,725.72 6.71 204,824.28 TOTAL Public Works 1,900,950.00 112,624.65 112,624.65 5.92 1,788,325.35 2 -09 -2015 12:20 PM CITY OF ELK RIVER PAGE: 33 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 101- GENERAL FUND Culture & Recreation Parks Department DEPARTMENTAL EXPENDITURES 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 -4108 Insurance 101 -4- 5110 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 5110 -4212 Fuels & Lubes 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 -4460 Equip Replacement Charge TOTAL Other Services & Charges Capital Outlay CURRENT CURRENT BUDGET PERIOD 08.33° OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE 400,800.00 24,945.30 24,945.30 6.22 375,854.7C 6,600.00 718.61 718.61 10.89 5,881.39 68,250.00 0.00 0.00 0.00 68,250.00 30,550.00 3,620.49 3,620.49 11.85 26,929.51 29,000.00 3,383.17 3,383.17 11.67 25,616.83 6,800.00 791.22 791.22 11.64 6,008.78 61,600.00 4,845.93 4,845.93 7.87 56,754.07 12,350.00 2,828.25 2,828.25 22.9C 9,521.75 615,950.00 41,132.97 41,132.97 6.68 574,817.03 35,000.00 0.00 0.00 0.00 35,000.00 3,800.00 ( 19.97)( 19.97) 0.53- 3,819.97 92,650.00 669.83 669.83 0.72 91,980.17 21,000.00 0.00 0.00 0.0C 21,000.00 152,450.00 649.86 649.86 0.43 151,800.14 4,500.00 0.00 0.00 0.00 4,500.00 100.00 0.00 0.00 0.00 100.00 5,100.00 695.00 695.00 13.63 4,405.00 27,350.00 7,608.50 7,608.50 27.82 19,741.5C 43,500.00 395.00 395.00 0.91 43,105.00 4,000.00 0.00 0.00 0.00 4,000.00 16,500.00 0.00 0.00 0.00 16,500.00 33,750.00 0.00 0.00 0.00 33,750.00 13,000.00 0.00 0.00 0.00 13,000.00 50,950.00 4,245.83 4,245.83 8.33 46,704.17 198,750.00 12,944.33 12,944.33 6.51 185,805.67 TOTAL Parks Department 967,150.00 54,727.16 54,727.16 5.66 912,422.84 2 -09 -2015 12:20 PM 101- GENERAL FUND Culture & Recreation Parks & Rec Admin DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 34 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 5210 -4101 Regular Pay 101 -4- 5210 -4103 Part -time Pay 101 -4- 5210 -4104 PERA 101 -4 -5210 -4105 FICA 101 -4- 5210 -4107 Medicare 101 -4- 5210 -4108 Insurance 101 -4- 5210 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 5210 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 5210 -4321 Telephone 101 -4- 5210 -4322 Postage 101 -4 -5210 -4331 Travel, Conferences & Schools 101 -4- 5210 -4349 Advertising /Marketing 101 -4- 5210 -4361 Insurance 101 -4- 5210 -4389 Utilities 101 -4- 5210 -4401 Bldg Repair /Maint Services 101 -4- 5210 -4404 Equip Repair /Maint Services 101 -4- 5210 -4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 285,750.00 18,589.86 18,589.86 6.51 267,160.14 51,700.00 3,165.87 3,165.87 6.12 48,534.13 25,300.00 2,858.58 2,858.58 11.30 22,441.42 21,000.00 2,282.75 2,282.75 10.87 18,717.25 4,900.00 533.87 533.87 10.90 4,366.13 41,700.00 3,405.03 3,405.03 8.17 38,294.97 3,800.00 840.50 840.50 22.12 2,959.5C 434,150.00 31,676.46 31,676.46 7.30 402,473.54 13,500.00 0.00 0.00 0.0C 13,500.00 13,500.00 0.00 0.00 0.00 13,500.00 6,050.00 0.00 0.00 0.00 6,050.00 5,100.00 0.00 0.00 0.00 5,100.00 9,850.00 140.00 140.00 1.42 9,710.00 34,700.00 0.00 0.00 0.00 34,700.00 400.00 97.50 97.50 24.38 302.5C 5,450.00 25.00 25.00 0.46 5,425.00 15,200.00 892.80 892.80 5.87 14,307.2C 7,000.00 7,574.10 7,574.10 108.20 ( 574.10) 1,800.00 1,785.00 1,785.00 99.17 15.0C 85,550.00 10,514.40 10,514.40 12.29 75,035.6C TOTAL Parks & Rec Admin 533,200.00 42,190.86 42,190.86 7.91 491,009.14 2 -09 -2015 12:20 PM 101- GENERAL FUND Culture & Recreation Recreation Programs DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 3E REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101 -4- 5220 -4103 Part -time Pay 82,000.00 2,055.84 2,055.84 2.51 79,944.16 101 -4- 5220 -4104 PERA 0.00 66.53 66.53 0.00 ( 66.53) 101 -4- 5220 -4105 FICA 4,300.00 156.71 156.71 3.64 4,143.29 101 -4- 5220 -4107 Medicare 1,200.00 36.65 36.65 3.05 1,163.35 TOTAL Personal Services 87,500.00 2,315.73 2,315.73 2.65 85,184.27 Supplies 101 -4- 5220 -4219 Operating Supplies 28,000.00 0.00 0.00 O.00 28,000.00 TOTAL Supplies 28,000.00 0.00 0.00 0.00 28,000.00 Other Services & Charges 101 -4- 5220 -4409 Contractual Services 45,000.00 0.00 0.00 0.00 45,000.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 3,600.00 0.00 0.00 O.00 3,600.00 TOTAL Other Services & Charges 50,250.00 0.00 0.00 0.00 50,250.00 TOTAL Recreation Programs 165,750.00 2,315.73 2,315.73 1.40 163,434.27 2 -09 -2015 12:20 PM CITY OF ELK RIVER PAGE: 36 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 101- GENERAL FUND Culture & Recreation Concessions DEPARTMENTAL EXPENDITURES Personal Services CURRENT CURRENT BUDGET PERIOD 08.33° OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE 2 -09 -2015 12:20 PM 101- GENERAL FUND Culture & Recreation Sr Citizen Programs DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 37 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 101 -4- 5510 -4101 Regular Pay 101 -4- 5510 -4103 Part -time Pay 101 -4- 5510 -4104 PERA 101 -4- 5510 -4105 FICA 101 -4- 5510 -4107 Medicare 101 -4- 5510 -4108 Insurance 101 -4- 5510 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 5510 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 5510 -4321 Telephone 101 -4- 5510 -4322 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 -4409 Contractual Services 101 -4- 5510 -4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay TOTAL Sr Citizen Programs 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 111,400.00 7,114.16 7,114.16 6.39 104,285.84 5,700.00 35.00 35.00 0.61 5,665.00 8,350.00 935.40 935.40 11.20 7,414.6C 7,250.00 748.54 748.54 10.32 6,501.46 1,700.00 175.07 175.07 10.30 1,524.93 20,950.00 1,691.02 1,691.02 8.07 19,258.98 550.00 123.00 123.00 22.36 427.00 155,900.00 10,822.19 10,822.19 6.94 145,077.81 11,900.00 0.00 0.00 0.0C 11,900.0C 11,900.00 0.00 0.00 0.00 11,900.0C 2,400.00 0.00 0.00 0.00 2,400.00 3,300.00 0.00 0.00 0.00 3,300.00 3,050.00 0.00 0.00 0.00 3,050.00 1,400.00 347.25 347.25 24.80 1,052.7E 9,950.00 25.00 25.00 0.25 9,925.00 16,050.00 547.20 547.20 3.41 15,502.8C 100.00 0.00 0.00 0.00 100.0C 10,700.00 365.00 365.00 3.41 10,335.00 850.00 160.00 160.00 18.82 690.00 47,800.00 1,444.45 1,444.45 3.02 46,355.55 215,600.00 12,266.64 12,266.64 5.69 203,333.36 TOTAL Culture & Recreation 1,881,700.00 111,500.39 111,500.39 5.93 1,770,199.61 2 -09 -2015 12:20 PM 101- GENERAL FUND Economic Development Economic Development DEPARTMENTAL EXPENDITURES Personal Services 101 -4- 6210 -4101 Regular Pay 101 -4 -6210 -4103 Part -time Pay 101 -4- 6210 -4104 PERA 101 -4 -6210 -4105 FICA 101 -4- 6210 -4107 Medicare 101 -4- 6210 -4108 Insurance 101 -4- 6210 -4109 Workers Comp TOTAL Personal Services Other Services & Charges CITY OF ELK RIVER PAGE: 38 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 0.00 6,320.38 6,320.38 0.00 ( 6,320.38) 0.00 2,106.00 2,106.00 0.00 ( 2,106.00) 0.00 489.03 489.03 0.00 ( 489.03) 0.00 499.33 499.33 0.00 ( 499.33) 0.00 121.13 121.13 0.00 ( 121.13) 0.00 562.01 562.01 0.00 ( 562.01) 0.00 157.00 157.00 O.00 ( 157.00) 0.00 10,254.88 10,254.88 0.00 ( 10,254.88) TOTAL Economic Development 0.00 10,254.88 10,254.88 0.00 ( 10,254.88) 2 -09 -2015 12:20 PM 101- GENERAL FUND Economic Development Energy City DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 39 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services Energy City 10,100.00 401.35 401.35 3.97 101 -4- 6220 -4101 Regular Pay 4,500.00 288.40 288.40 6.41 4,211.6C 101 -4- 6220 -4104 PERA 350.00 37.91 37.91 10.83 312.09 101 -4- 6220 -4105 FICA 300.00 31.35 31.35 10.45 268.6E 101 -4 -6220 -4107 Medicare 50.00 7.33 7.33 14.66 42.67 101 -4- 6220 -4108 Insurance 300.00 36.36 36.36 12.12 263.64 TOTAL Personal Services 5,500.00 401.35 401.35 7.30 5,098.6E Supplies 101 -4- 6220 -4219 Operating Supplies 600.00 0.00 0.00 O.00 600.00 TOTAL Supplies 600.00 0.00 0.00 0.00 600.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 1,500.00 0.00 0.00 0.00 1,500.00 101 -4- 6220 -4359 Publishing 1,500.00 0.00 0.00 O.00 1,500.00 TOTAL Other Services & Charges 4,000.00 0.00 0.00 0.00 4,000.00 TOTAL Energy City 10,100.00 401.35 401.35 3.97 9,698.6E TOTAL Economic Development 10,100.00 10,656.23 10,656.23 105.51 ( 556.23) 2 -09 -2015 12:20 PM CITY OF ELK RIVER PAGE: 4C REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 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 TOTAL EXPENDITURES 13,312,800.00 883,740.91 883,740.91 6.64 12,429,059.09 REVENUES OVER /(UNDER) EXPENDITURES 0.00 ( 763,529.45)( 763,529.45) 763,529.45 2 -09 -2015 12:20 PM 221 -ICE ARENA FINANCIAL SUMMARY CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E CURRENT CURRENT BUDGET PERIOD YEAR TO DATE ACTUAL 08.33° OF o OF BUDGET PAGE: 1 YEAR COMP. BUDGET BALANCE REVENUE SUMMARY Ice Arena 629,650.00 12,224.09 12,224.09 1.94 617,425.91 Hockey 37,000.00 5,310.00 5,310.00 14.35 31,690.00 Skating 39,500.00 1,902.00 1,902.00 4.82 37,598.00 Concessions 79,000.00 14,928.25 14,928.25 18.9C 64,071.75 TOTAL REVENUES 785,150.00 34,364.34 34,364.34 4.38 750,785.66 EXPENDITURE SUMMARY Culture & Recreation Ice Arena 597,550.00 23,900.33 23,900.33 4.00 573,649.67 Hockey 20,800.00 0.00 0.00 0.00 20,800.00 Skating 27,850.00 609.27 609.27 2.19 27,240.73 Arena Concessions 59,900.00 3,546.71 3,546.71 5.92 56,353.29 TOTAL Culture & Recreation 706,100.00 28,056.31 28,056.31 3.97 678,043.69 TOTAL EXPENDITURES 706,100.00 28,056.31 28,056.31 3.97 678,043.69 REVENUES OVER /(UNDER) EXPENDITURES 79,050.00 6,308.03 6,308.03 72,741.97 2 -09 -2015 12:20 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 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 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 -3621 Interest Income 221 -3- 0000 -3622 Vending Machines 221 -3- 0000 -3626 Contributions 221 -3- 0000 -3629 Miscellaneous Revenue TOTAL Other Revenue Sales 221 -3- 0000 -3791 ATM Revenue TOTAL Sales Transfers In TOTAL Ice Arena Hockey Charges for Services 221 -3- 5410 -3461 Recreation Fees TOTAL Charges for Services Other Revenue TOTAL Hockey Skating 525,000.00 1,270.24 1,270.24 0.24 523,729.76 29,200.00 6,925.00 6,925.00 23.72 22,275.00 19,750.00 616.00 616.00 3.12 19,134.00 4,300.00 708.00 708.00 16.47 3,592.00 2,600.00 0.00 0.00 0.00 2,600.00 22,000.00 0.00 0.00 0.0C 22,000.00 602,850.00 9,519.24 9,519.24 1.58 593,330.76 2,200.00 0.00 0.00 0.00 2,200.00 14,000.00 2,204.50 2,204.50 15.75 11,795.5C 6,500.00 0.00 0.00 0.00 6,500.00 3,800.00 463.25 463.25 12.19 3,336.75 26,500.00 2,667.75 2,667.75 10.07 23,832.2E 300.00 37.10 37.10 12.37 262.9C 300.00 37.10 37.10 12.37 262.9C 629,650.00 12,224.09 12,224.09 1.94 617,425.91 37,000.00 5,310.00 5,310.00 14.35 31,690.00 37,000.00 5,310.00 5,310.00 14.35 31,690.00 37,000.00 5,310.00 5,310.00 14.35 31,690.00 2 -09 -2015 12:20 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 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 35,500.00 1,902.00 1,902.00 5.36 33,598.00 221 -3- 5420 -3465 Admissions 4,000.00 0.00 0.00 O.00 4,000.00 TOTAL Charges for Services 39,500.00 1,902.00 1,902.00 4.82 37,598.00 Other Revenue TOTAL Skating 39,500.00 1,902.00 1,902.00 4.82 37,598.00 Concessions Charges for Services 221 -3- 5430 -3467 Concessions 79,000.00 14,928.25 14,928.25 18.9C 64,071.75 TOTAL Charges for Services 79,000.00 14,928.25 14,928.25 18.90 64,071.7E TOTAL Concessions 79,000.00 14,928.25 14,928.25 18.90 64,071.7E TOTAL REVENUE 785,150.00 34,364.34 34,364.34 4.38 750,785.66 2 -09 -2015 12:20 PM 221 -ICE ARENA Culture & Recreation Ice Arena DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E Personal Services 221 -4- 5400 -4101 Regular Pay 221 -4- 5400 -4103 Part -time Pay 221 -4- 5400 -4104 PERA 221 -4- 5400 -4105 FICA 221 -4- 5400 -4107 Medicare 221 -4- 5400 -4108 Insurance 221 -4- 5400 -4109 Workers Comp TOTAL Personal Services Supplies 221 -4- 5400 -4212 Fuels & Lubes 221 -4- 5400 -4217 Uniform Allowance 221 -4- 5400 -4219 Operating Supplies 221 -4- 5400 -4255 Soft Drinks /Misc 221 -4- 5400 -4259 Other Merchandise For Resale TOTAL Supplies Other Services & Charges 221 -4- 5400 -4321 Telephone 221 -4- 5400 -4331 Travel, Conferences & Schools 221 -4- 5400 -4359 Publishing 221 -4- 5400 -4361 Insurance 221 -4- 5400 -4389 Utilities 221 -4- 5400 -4401 Bldg Repair /Maint Services 221 -4- 5400 -4409 Contractual Services 221 -4- 5400 -4415 Equipment Rental 221 -4- 5400 -4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay 221 -4- 5400 -4560 Equipment TOTAL Capital Outlay Transfers Out 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 180,200.00 8,153.90 8,153.90 4.52 172,046.1C 61,450.00 6,848.20 6,848.20 11.14 54,601.8C 18,100.00 1,570.83 1,570.83 8.68 16,529.17 15,000.00 1,581.84 1,581.84 10.55 13,418.16 3,550.00 369.94 369.94 10.42 3,180.06 27,750.00 1,409.02 1,409.02 5.08 26,340.98 8,000.00 2,227.25 2,227.25 27.84 5,772.75 314,050.00 22,160.98 22,160.98 7.06 291,889.02 300.00 0.00 0.00 0.00 300.00 800.00 0.00 0.00 0.00 800.00 49,950.00 71.97 71.97 0.14 49,878.03 6,800.00 0.00 0.00 0.00 6,800.00 900.00 0.00 0.00 0.0C 900.00 58,750.00 71.97 71.97 0.12 58,678.03 3,350.00 87.50 87.50 2.61 3,262.5C 2,450.00 0.00 0.00 0.00 2,450.00 5,700.00 0.00 0.00 0.00 5,700.00 4,850.00 1,202.75 1,202.75 24.80 3,647.2E 157,250.00 0.00 0.00 0.00 157,250.00 33,300.00 0.00 0.00 0.00 33,300.00 1,900.00 0.00 0.00 0.00 1,900.00 3,700.00 227.13 227.13 6.14 3,472.87 750.00 150.00 150.00 20.00 600.00 213,250.00 1,667.38 1,667.38 0.78 211,582.62 11,500.00 0.00 0.00 0.0C 11,500.00 11,500.00 0.00 0.00 0.00 11,500.00 TOTAL Ice Arena 597,550.00 23,900.33 23,900.33 4.00 573,649.67 2 -09 -2015 12:20 PM 221 -ICE ARENA Culture & Recreation Hockey DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET 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 11,600.00 0.00 0.00 O.00 11,600.00 TOTAL Supplies 11,600.00 0.00 0.00 0.00 11,600.00 Other Services & Charges 221 -4- 5410 -4359 Publishing 300.00 0.00 0.00 0.00 300.00 221 -4- 5410 -4409 Contractual Services 5,200.00 0.00 0.00 0.00 5,200.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,300.00 0.00 0.00 0.00 8,300.00 TOTAL Hockey 20,800.00 0.00 0.00 0.00 20,800.00 2 -09 -2015 12:20 PM 221 -ICE ARENA Culture & Recreation Skating DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 221 -4- 5420 -4103 Part -time Pay 17,800.00 547.74 547.74 3.08 17,252.26 221 -4- 5420 -4104 PERA 1,000.00 8.59 8.59 0.86 991.41 221 -4- 5420 -4105 FICA 1,100.00 42.91 42.91 3.90 1,057.09 221 -4- 5420 -4107 Medicare 250.00 10.03 10.03 4.01 239.97 TOTAL Personal Services 20,150.00 609.27 609.27 3.02 19,540.73 Supplies 221 -4- 5420 -4219 Operating Supplies 5,100.00 0.00 0.00 O.00 5,100.00 TOTAL Supplies 5,100.00 0.00 0.00 0.00 5,100.00 Other Services & Charges 221 -4- 5420 -4359 Publishing 1,000.00 0.00 0.00 0.00 1,000.0C 221 -4- 5420 -4409 Contractual Services 1,600.00 0.00 0.00 O.00 1,600.00 TOTAL Other Services & Charges 2,600.00 0.00 0.00 0.00 2,600.00 TOTAL Skating 27,850.00 609.27 609.27 2.19 27,240.73 2 -09 -2015 12:20 PM 221 -ICE ARENA Culture & Recreation Arena Concessions DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 201E 08.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 59,900.00 3,546.71 3,546.71 5.92 56,353.29 TOTAL Culture & Recreation 221 -4- 5430 -4103 Part -time Pay 21,300.00 2,880.04 2,880.04 13.52 18,419.96 221 -4- 5430 -4104 PERA 1,600.00 0.00 0.00 0.00 1,600.00 221 -4- 5430 -4105 FICA 1,300.00 274.82 274.82 21.14 1,025.18 221 -4- 5430 -4107 Medicare 300.00 64.30 64.30 21.43 235.7C TOTAL Personal Services 24,500.00 3,219.16 3,219.16 13.14 21,280.84 Supplies 221 -4- 5430 -4219 Operating Supplies 5,800.00 150.00 150.00 2.59 5,650.00 221 -4- 5430 -4259 Other Merchandise For Resale 29,600.00 177.55 177.55 0.6C 29,422.45 TOTAL Supplies 35,400.00 327.55 327.55 0.93 35,072.4E TOTAL Arena Concessions 59,900.00 3,546.71 3,546.71 5.92 56,353.29 TOTAL Culture & Recreation 706,100.00 28,056.31 28,056.31 3.97 678,043.69 TOTAL EXPENDITURES 706,100.00 28,056.31 28,056.31 3.97 678,043.69 REVENUES OVER /(UNDER) EXPENDITURES 79,050.00 6,308.03 6,308.03 72,741.97 Sales and cost of sales: Sales Cost of sales Gross profit Operating revenues: User charges Delinquency collections Other Total operating revenues Operating expenses: Personal services Supplies Other service charges Depreciation Total operating expenses Operating income (loss Nonoperating revenues (expenses): Interest income Grant revenue Interest expense Total nonoperating revenues (expenses) Income (loss) before contributions and transfers Contributions - connection fees Transfers in Transfers out NET INCOME (LOSS) Items reclassified to balance sheet at year end: Capital Outlay Revenues over /(under) expenditures * Recorded ar yearend CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED JANUARY, 2015 Liquor Sewer Garbage Stormwater Current Year to Date Budget % of Current Year to Date Budget % of Current Year to Date Budget % of Current Year to Date Budget % of Budget Actual Variance Budget Budget Actual Variance Budget Budget Actual Variance Budget Budget Actual Variance Budget $ 6,865,650 $ 488,259 $ 6,377,391 7.11% (4,898,950) (17,748) (4,881,202) 0.36% $ 1,758,200 $ - $ 1,758,200 0.00% $ 1,302,000 $ 4 $ 1,301,996 0.00% $ 418,000 $ - $ 418,000 0.00% 1,966,700 470,511 1,496,189 23.92% $ - $ - $ - 0.00% - - - 0.00% 1,300 - 1,300 0.00% 12,000 - 12,000 0.00% - - - 1,900 522 1,378 27.47% 2,000 - 2,000 0.00% 3,500 460 3,040 13.14% - - - 1,900 522 1,378 27.47% 1,761,500 - 1,761,500 0.00% 1,317,500 464 1,317,036 0.04% 418,000 - 418,000 0.00% 624,900 48,130 576,770 7.70% 526,560 33,726 492,834 6.40% 26,650 1,957 24,693 7.34% 87,150 3,243 83,907 3.72% 53,400 39 53,361 0.07% 217,700 16 217,684 0.01% 5,900 - 5,900 0.00% 14,600 - 14,600 0.00% 221,250 3,498 217,752 1.58% 470,550 6,241 464,309 1.33% 1,315,250 200 1,315,050 0.02% 243,000 - 243,000 0.00% 123,000 - 123,000 0.00% 977,950 - 977,950 0.00% - - - 0.00% 433,750 - 433,750 0.00% 1,022,550 51,667 970,883 5.05% 2,192,760 39,983 2,152,777 1.82% 1,347,800 2,157 1,345,643 0.16% 778,500 3,243 775,257 0.42% 946,050 419,366 526,684 44.33% (431,260) (39,983) (391,277) 9.27% (30,300) (1,693) (28,607) 5.59% (360,500) (3,243) (357,257) 0.90% 25,000 - 25,000 0.00% 100,000 604 99,396 0.60% 6,250 - 6,250 0.00% 900 - 900 0.00% - - - 0.00% 2,800,000 - 2,800,000 0.00% - - - 0.00% - - - 0.00% - - - 0.00% (261,050) - (261,050) 0.00% - - - 0.00% - - - 0.00% 25,000 - 25,000 0.00% 2,638,950 604 2,638,346 0.02% 6,250 - 6,250 0.00% 900 - 900 0.00% 971,050 419,366 551,684 43.19% 2,207,690 (39,379) 2,247,069 -1.78% (24,050) (1,693) (22,357) 7.04% (359,600) (3,243) (356,357) 0.90% - - - 0.00% 630,700 13,185 617,515 2.09% - - - 0.00% 50,000 5,720 44,280 0.00% - - - 0.00% 1,000,000 - 1,000,000 0.00% 14,600 - 14,600 0.00% - - - (656,000) - (656,000) 0.00% (120,000) - (120,000) 0.00% (43,950) - (43,950) 0.00% - - - 315,050 419,366 104,316 133.11% 3,718,390 (26,194) 3,744,584 -0.70% 53,400 1,693 51,707 3.17% 3099600 2,477 3129077 -0.80% (10,875,100) - (10,875,100) 0.00% (180,000) - 3159050 4199366 (1049316) (791569710) (269194) (791309516) (539400) (19693) (519707) (4899600) 29477 (3129077) 2 -09 -2015 12:21 PM FUND ACCOUNT# ACCOUNT NAME CLAIM ON CASH CITY OF ELK RIVER POOLED CASH REPORT (FUND 999) AS OF: JANUARY 31ST, 2015 002 -1010 Cash - Section 125 101 -1010 Cash - General Fund 211 -1010 Cash - Library 221 -1010 Cash - Ice Arena 222 -1010 Cash - Pinewood Golf Course 225 -1010 Cash - Park Dedication 228 -1010 Cash - Landfill 231 -1010 Cash - Landfill Const Debris 240 -1010 Cash - Micro Loan Fund 241 -1010 Cash - Federal DEED 242 -1010 Cash - State DEED 245 -1010 Cash - Development Fund 290 -1010 Cash - Capital Outlay Reserve 291 -1010 Cash - Insurance Reserve 292 -1010 Cash - Govt Bldgs Reserve 294 -1010 Cash - Drug Forfeiture 295 -1010 Cash - Severance Pay Reserve 296 -1010 Cash - GRE Reserve 313 -1010 Cash - 2007C GO Bonds 333 -1010 Cash - 2010A GO Cap Imp Bonds 401 -1010 Cash - Pavement Mgmt 403 -1010 Cash - Street Improvement 404 -1010 Cash - Surface Water Managemnt 406 -1010 Cash - City Wide Trunk Util 410 -1010 Cash - Equipment Replacement 426 -1010 Cash - YMCA 440 -1010 Cash - Park Improvement 459 -1010 Cash - TIF 419 Highway 169 462 -1010 Cash - TIF 422 Downtown Redev 602 -1010 Cash - Wastewater Treatment 603 -1010 Cash - Liquor 605 -1010 Cash - Garbage 607 -1010 Cash - Storm Water 801 -1010 Cash - Interest 821 -1010 Cash - Developer Escrow TOTAL CLAIM ON CASH CASH IN BANK - POOLED CASH BEGINNING BALANCE 30,343.84 6,152,480.88 424,842.73 266,262.29 48,300.09) 56,879.44 618,552.64 717,594.09 890,773.63 200,000.00 413,464.58 424,401.50 1,576,372.58 166,991.01 3,787,741.50 29,256.10 118,025.06 2,569,810.28 232,549.96 737,164.10 2,013,468.25 1,535,655.48 369,361.32 4,854,551.62 934,221.23 383,158.23 151,270.22 368,548.49 0.00 14,483,733.52 2,621,683.97 604,954.18 0.00 0.00 91,831.89 47,777,644.52 PAGE: 1 INFORMATION CURRENT CURRENT ACTIVITY BALANCE 14,606.26) 15,737.58 1,195,840.13) 4,956,640.75 3,879.10) 420,963.63 38,103.53 304,365.82 12,819.53) ( 61,119.62) 19,382.60 76,262.04 11,691.70 630,244.34 0.00 717,594.09 2,186.64 892,960.27 0.00 200,000.00 0.00 413,464.58 12,009.57) 412,391.93 41,495.98) 1,534,876.6C 87,326.96 254,317.97 102,495.40 3,890,236.9C 3,707.57 32,963.67 35,395.74) 82,629.32 209,694.00 2,779,504.28 3,804.35 236,354.31 115,080.72 852,244.82 343,970.46 2,357,438.71 5,747.31) 1,529,908.17 67,731.97) 301,629.35 51,614.61 4,906,166.23 51,401.45) 882,819.78 0.00 383,158.23 748.58) 150,521.64 0.00 368,548.49 1,328.25 1,328.25 638,669.93) 13,845,063.59 17,688.66 2,639,372.63 9,647.18) 595,307.00 2,477.00 2,477.00 43,405.79 43,405.79 2,183.00 94,014.89 1,033,851.49) 46,743,793.03 999 -1000 A/P BANK ACCOUNTS 71,914,276.73 281,772.64 72,196,049.37 999 -1001 PY BANK ACCOUNT (52,518,821.77) ( 1,315,624.13) (53,834,445.90) 999 -1002 POOLED INVESTMENTS 28,382,189.56 O.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 47,777,644.52 1,033,851.49) 46,743,793.03 2 -09 -2015 12:21 PM CITY OF ELK RIVER PAGE: 2 POOLED CASH REPORT (FUND 999) AS OF: JANUARY 31ST, 2015 FUND ACCOUNT# ACCOUNT NAME WAGES PAYABLE TOTAL CASH IN BANK - POOLED CASH DUE TO OTHER FUNDS - POOLED CASH 999 -2000 DUE TO OTHER FUNDS TOTAL DUE TO OTHER FUNDS BEGINNING CURRENT BALANCE ACTIVITY CURRENT BALANCE 47,777,644.52 ( 1,033,851.49) 46,743,793.03 47,777,644.52 1,033,851.49) 46,743,793.03 47,777,644.52 1,033,851.49) 46,743,793.03 2 -09 -2015 12:21 PM CITY OF ELK RIVER PAGE: 3 POOLED CASH REPORT (FUND 999) AS OF: JANUARY 31ST, 2015 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE DUE TO POOLED CASH 1,861,445.34) 148,233.4C 002 -2020 A/P - Section 125 750.00 0.00 750.00 101 -2020 A/P - General Fund 288,811.56 247,807.26) 41,004.3C 211 -2020 A/P - Library 1,793.38 1,793.38) O.00 221 -2020 A/P - Ice Arena 31,893.46 32,140.33) ( 246.87) 222 -2020 A/P - Pinewood Golf Course 306.67 252.65) 54.02 228 -2020 A/P - Landfill 3,888.58 3,888.58) O.00 245 -2020 A/P - Development Fund 8,402.50 7,902.50) 500.00 290 -2020 A/P - Capital Outlay Reserve 54,659.46 52,219.09) 2,440.37 291 -2020 A/P - Insurance Reserve 3,590.53 3,491.93) 98.6C 292 -2020 A/P - Govt Bldgs Reserve 10,700.00 10,700.00) O.00 294 -2020 A/P - Drug Forfeiture 1,122.43 1,122.43) O.00 401 -2020 A/P - Capital Projects 32,111.51 5,633.00) 26,478.51 403 -2020 A/P - Street Improvement 24,300.75 12,998.00) 11,302.75 404 -2020 A/P - Surface Water Management 86,158.74 68,445.62) 17,713.12 406 -2020 A/P - City Wide Trunk Utilits 2,419.50 2,419.50) O.00 410 -2020 A/P - Equip Replacement 132,237.43 132,237.43) O.00 440 -2020 A/P - Park Improvement Fund 11,001.58 853.58) 10,148.00 462 -2020 A/P - TIF 422 Downtown Redev 1,261.84 0.00 1,261.84 602 -2020 A/P - Wastewater Treatment 781,328.30 744,150.25) 37,178.05 603 -2020 A/P - Liquor 420,762.29 421,211.58) ( 449.29) 605 -2020 A/P - Garbage 110,178.23 110,178.23) O.00 821 -2020 A/P - Developer Escrow 2,000.00 2,000.00) 0.00 TOTAL DUE TO POOLED CASH 2,009,678.74 1,861,445.34) 148,233.4C DUE FROM OTHER FUNDS 999 -1100 DUE FROM OTHER FUNDS 1,973,888.66 1,852,133.77) 121,754.89 TOTAL DUE FROM OTHER FUNDS 1,973,888.66 1,852,133.77) 121,754.89 ACCOUNTS PAYABLE - POOLED CASH 999 -2020 A/P - POOLED CASH 1,973,888.66 1,852,133.77) 121,754.89 TOTAL ACCOUNTS PAYABLE POOLED CASH 1,973,888.66 1,852,133.77) 121,754.89 "* END OF REPORT "*