Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 03-16-2015
Kive r To: From: Date: Subject: Memorandum Mayor and City Council Tim Simon, Finance Director March 16, 2015 February 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 February, actual revenues (except for property taxes and state aids) and expenditures should run slightly about 17% 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. ■ Licenses and permits collections are about 10% of budget estimates. ■ February charges for services collections include the semi - annual billing for the Otsego fire contract. ■ The transfers in will be recorded mid -year. Expenditures: • Total departmental expenditures are 14% of budget and most departments are within or below budget. • The Snow Removal budget reflects the seasonal expenditures for personal services and road salt. P0WI0E0 0Y AfUR 2015 Monthly Expenditures $14,000 $12,000 o $10,000 z a $8,000 0 �= $6,000 $4,000 $2,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Actual $884 1 $1,867 Budget $1,109 1 $2,219 1 $3,3281 $4,4381 $5,547 1 $6,6561 $7,7661 $8,875 1 $9,985 1$11,0941$12,2031$13,313 19-C ARCAIA For Februarys, revenues exceed expenditures by $96,390. Revenues are about 24% of budget and expenditures are about 13% of budget. Ice rental revenues are at 17% and are in line with the budget estimate. ATTACHMENTS ■ General Fund Revenue & Expense Report ■ Enterprise Funds — Budget to Actual ■ Cash Report — All Funds 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 INFORMATION 101- GENERAL FUND FINANCIAL SUMMARY 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 13,312,800.00 172,981.15 293,349.61 2.2C 13,019,450.39 TOTAL REVENUES 13,312,800.00 172,981.15 293,349.61 2.20 13,019,450.39 EXPENDITURE SUMMARY General Government Mayor & Council 141,050.00 5,460.80 17,892.32 12.69 123,157.68 Cable TV 108,400.00 7,285.13 14,210.75 13.11 94,189.2E Administrative Services 600,000.00 46,230.39 92,376.38 15.40 507,623.62 Human Resources 161,750.00 8,634.48 15,411.43 9.53 146,338.57 Elections 13,350.00 3.37 3.37 0.03 13,346.63 Finance 567,450.00 43,914.82 95,013.80 16.74 472,436.2C Information Technology 332,150.00 34,107.74 56,067.40 16.88 276,082.6C Legal 217,600.00 17,050.02 17,050.02 7.84 200,549.98 Community Development 339,600.00 26,592.80 51,297.98 15.11 288,302.02 Planning 195,550.00 15,658.64 28,588.08 14.62 166,961.92 City Hall Maintenance 569,200.00 44,017.67 84,182.33 14.79 485,017.67 Contingency 95,000.00) 0.00 0.00 O.00 ( 95,000.00) TOTAL General Government 3,151,100.00 248,955.86 472,093.86 14.98 2,679,006.14 Public Safety Police Administration 693,150.00 32,322.23 115,921.13 16.72 577,228.87 Patrol 2,493,300.00 172,240.74 321,208.77 12.88 2,172,091.23 Investigations 963,050.00 58,323.26 112,243.64 11.66 850,806.36 Police Support Services 555,750.00 41,413.73 79,208.48 14.25 476,541.52 Police Reserves 20,800.00 0.00 0.00 0.00 20,800.00 Public safety building 77,150.00 7,720.48 9,993.02 12.95 67,156.98 Fire Administration 407,600.00 28,331.81 56,284.60 13.81 351,315.4C Fire Operations 388,350.00 21,458.35 39,473.93 10.16 348,876.07 Emergency Management 21,400.00 373.50 373.50 1.75 21,026.5C Building Safety 628,950.00 51,496.31 96,489.35 15.34 532,460.65 Code Enforcement 89,300.00 6,813.37 13,014.51 14.57 76,285.49 Environmental 30,150.00 2,245.50 4,349.99 14.43 25,800.01 TOTAL Public Safety 6,368,950.00 422,739.28 848,560.92 13.32 5,520,389.08 Public Works Street Maintenance 1,187,300.00 69,800.16 122,791.22 10.34 1,064,508.78 Snow Removal 297,550.00 97,269.80 130,179.75 43.75 167,370.2E Equipment Services 196,550.00 12,147.86 24,145.78 12.28 172,404.22 Engineering 219,550.00 15,635.95 30,361.67 13.83 189,188.33 TOTAL Public Works 1,900,950.00 194,853.77 307,478.42 16.17 1,593,471.58 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND FINANCIAL SUMMARY 16.67° 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 55,748.98 110,476.14 11.42 856,673.86 533,200.00 36,542.77 78,733.63 14.77 454,466.37 165,750.00 8,268.61 10,584.34 6.39 155,165.66 215,600.00 14,617.18 26,883.82 12.47 188,716.18 1,881,700.00 115,177.54 226,677.93 12.05 1,655,022.07 0.00 821.29 11,076.17 0.00 ( 11,076.17) 10,100.00 427.06 828.41 8.2C 9,271.59 10,100.00 1,248.35 11,904.58 117.87 ( 1,804.58) 13,312,800.00 982,974.80 1,866,715.71 14.02 11,446,084.29 REVENUES OVER /(UNDER) EXPENDITURES 0.00 ( 809,993.65)( 1,573,366.10) 1,573,366.1C 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 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 16.67° OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE 9,420,750.00 36.48 36.48 0.00 9,420,713.52 125,000.00 0.00 0.00 0.0C 125,000.00 9,545,750.00 36.48 36.48 0.00 9,545,713.52 61,000.00 1,740.00 1,740.00 2.85 59,260.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 10,248.00 14,447.00 48.16 15,553.00 21,000.00 0.00 0.00 0.00 21,000.00 2,000.00 0.00 360.00 18.00 1,640.00 11,000.00 210.00 970.00 8.82 10,030.00 10,000.00 700.00 700.00 7.00 9,300.00 350,000.00 11,113.00 14,882.15 4.25 335,117.8E 92,000.00 17,425.36 25,245.24 27.44 66,754.76 2,000.00 819.72 1,352.15 67.61 647.8E 6,000.00 200.00 880.00 14.67 5,120.00 1,200.00 97.43 137.43 11.45 1,062.57 8,500.00 330.00 760.00 8.94 7,740.00 599,400.00 42,883.51 61,473.97 10.26 537,926.03 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 850.00 3,800.00 31.67 8,200.00 105,000.00 5,657.12 6,696.89 6.38 98,303.11 1,000.00 40.00 100.00 10.00 900.0C 2,000.00 36.17 157.92 7.90 1,842.08 4,500.00 435.00 560.00 12.44 3,940.00 7,500.00 640.00 1,130.00 15.07 6,370.00 6,000.00 0.00 30.00 0.50 5,970.00 123,600.00 0.00 61,812.00 50.01 61,788.00 3,000.00 100.00 300.00 10.00 2,700.00 206,000.00 98,784.00 98,784.00 47.95 107,216.00 3,000.00 ( 0.70) 30.70 1.02 2,969.3C 10,000.00 0.00 0.00 0.00 10,000.0C 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE 101 -3- 0000 -3450 Maintenance Facility Rent 101 -3- 0000 -3451 Street Services 101 -3- 0000 -3452 Engineering Services Reimb 101 -3- 0000 -3461 Recreation Fees 101 -3- 0000 -3462 Sr Center Activities 101 -3- 0000 -3472 Park Use Fee 101 -3- 0000 -3475 Building Rent 101 -3- 0000 -3483 Sewer Inspection Fee 101 -3- 0000 -3484 Contractor License Check TOTAL Charges for Services Fines & Forfeits 101 -3- 0000 -3510 Court Fines 101 -3- 0000 -3511 Parking Fines 101 -3- 0000 -3512 Ordinance Violations TOTAL Fines & Forfeits Special Assessments 101 -3- 0000 -3610 Special Assmts- County TOTAL Special Assessments Other Revenue 101 -3- 0000 -3621 Interest Income 101 -3- 0000 -3625 Refunds & Reimbursements 101 -3- 0000 -3626 Contributions 101 -3- 0000 -3629 Miscellaneous Revenue TOTAL Other Revenue Transfers In 101 -3- 0000 -3921 Transfers 101 -3- 0000 -3925 Transfer - Landfill 101 -3- 0000 -3929 Transfer- NSP /RDF Reserve 101 -3- 0000 -3930 Transfer- Development 101 -3- 0000 -3942 Transfer -WWTS 101 -3- 0000 -3943 Transfer - Liquor 101 -3- 0000 -3944 Transfer - Garbage 101 -3- 0000 -3945 Transfer - Utilities 101 -3- 0000 -3948 Transfer -EDA 101 -3- 0000 -3949 Transfer -HRA TOTAL Transfers In TOTAL General Fund 14,100.00 1,156.50 2,313.00 16.40 11,787.00 38,900.00 1,972.05 2,702.05 6.95 36,197.9E 141,700.00 0.00 0.00 0.00 141,700.00 95,000.00 4,973.52 7,252.36 7.63 87,747.64 28,000.00 3,173.00 6,103.00 21.80 21,897.00 22,000.00 964.94 3,219.94 14.64 18,780.06 2,400.00 200.00 400.00 16.67 2,000.00 5,000.00 260.00 475.00 9.50 4,525.00 500.00 35.00 45.00 9.0C 455.00 831,200.00 119,276.60 195,911.86 23.57 635,288.14 115,000.00 7,932.82 8,087.82 7.03 106,912.18 10,000.00 2,160.00 5,640.00 56.40 4,360.00 0.00 0.00 200.00 O.00 ( 200.00) 125,000.00 10,092.82 13,927.82 11.14 111,072.18 0.00 ( 3,485.95) 0.00 O.00 O.00 0.00 ( 3,485.95) 0.00 0.00 O.00 85,000.00 6,990.55 6,990.55 8.22 78,009.4E 101,000.00 ( 3,194.78) 19.22 0.02 100,980.78 25,000.00 0.00 14,500.00 58.00 10,500.00 6,000.00 381.92 489.71 8.16 5,510.29 217,000.00 4,177.69 21,999.48 10.14 195,000.52 212,700.00 0.00 0.00 0.00 212,700.00 53,950.00 0.00 0.00 0.00 53,950.00 39,500.00 0.00 0.00 0.00 39,500.00 62,600.00 0.00 0.00 0.00 62,600.00 100,000.00 0.00 0.00 0.00 100,000.0C 399,050.00 0.00 0.00 0.00 399,050.00 43,950.00 0.00 0.00 0.00 43,950.00 740,900.00 0.00 0.00 0.00 740,900.00 32,000.00 0.00 0.00 0.00 32,000.00 23,250.00 0.00 0.00 0.0C 23,250.00 1,707,900.00 0.00 0.00 0.00 1,707,900.00 13,312,800.00 172,981.15 293,349.61 2.20 13,019,450.39 TOTAL REVENUE 13,312,800.00 172,981.15 293,349.61 2.20 13,019,450.39 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: E REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Mayor & Council Personal Services 101 -4- 1110 -4103 Part -time Pay 38,500.00 3,208.32 6,416.64 16.67 32,083.36 101 -4- 1110 -4104 PERA 1,900.00 100.01 200.02 10.53 1,699.98 101 -4- 1110 -4105 FICA 2,400.00 74.92 149.84 6.24 2,250.16 101 -4- 1110 -4107 Medicare 550.00 46.52 93.04 16.92 456.96 101 -4- 1110 -4109 Workers Comp 100.00 0.00 19.50 19.5C 80.5C TOTAL Personal Services 43,450.00 3,429.77 6,879.04 15.83 36,570.96 Supplies 101 -4- 1110 -4201 Office Supplies 1,200.00 0.00 0.00 O.00 1,200.00 TOTAL Supplies 1,200.00 0.00 0.00 0.00 1,200.00 Other Services & Charges 101 -4- 1110 -4319 Other Professional Services 10,400.00 700.00 700.00 6.73 9,700.00 101 -4- 1110 -4322 Postage 300.00 0.48 0.48 0.16 299.52 101 -4- 1110 -4331 Travel, Conferences & Schools 3,100.00 0.00 630.00 20.32 2,470.00 101 -4- 1110 -4359 Publishing 3,700.00 1,047.72 1,047.72 28.32 2,652.28 101 -4- 1110 -4361 Insurance 33,650.00 0.00 8,252.25 24.52 25,397.75 101 -4- 1110 -4433 Dues & Subscriptions 18,050.00 0.00 0.00 0.00 18,050.00 101 -4- 1110 -4440 Miscellaneous 27,200.00 282.83 382.83 1.41 26,817.17 TOTAL Other Services & Charges 96,400.00 2,031.03 11,013.28 11.42 85,386.72 Capital Outlay TOTAL Mayor & Council 141,050.00 5,460.80 17,892.32 12.69 123,157.68 Cable TV Personal Services 101 -4- 1120 -4101 Regular Pay 62,150.00 4,779.20 8,841.52 14.23 53,308.48 101 -4- 1120 -4103 Part -time Pay 17,600.00 690.04 1,280.62 7.28 16,319.38 101 -4- 1120 -4104 PERA 6,000.00 358.44 892.56 14.88 5,107.44 101 -4- 1120 -4105 FICA 4,950.00 288.08 733.50 14.82 4,216.5C 101 -4- 1120 -4107 Medicare 1,150.00 67.36 171.53 14.92 978.47 101 -4- 1120 -4108 Insurance 13,900.00 1,102.01 2,204.02 15.86 11,695.98 101 -4- 1120 -4109 Workers Comp 350.00 0.00 87.00 24.86 263.00 TOTAL Personal Services 106,100.00 7,285.13 14,210.75 13.39 91,889.25 3 -10 -2015 02:13 PM 101- GENERAL FUND General Government DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 29,316.26 54,235.07 14.23 326,864.93 43,000.00 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 21,403.24 6,150.00 454.53 1,145.22 18.62 101 -4- 1120 -4322 Postage 50.00 0.00 0.00 0.00 50.00 101 -4- 1120 -4331 Travel, Conferences & Schools 1,350.00 0.00 0.00 0.00 1,350.00 101 -4- 1120 -4404 Equip Repair /Maint Services 150.00 0.00 0.00 O.00 150.00 TOTAL Other Services & Charges 1,550.00 0.00 0.00 0.00 1,550.00 Capital Outlay 8,580.54 11,100.00 408.00 743.00 6.69 10,357.00 1,100.00 86.51 86.51 7.86 TOTAL Cable TV Administrative Services Personal Services 101 -4- 1210 -4101 Regular Pay 101 -4- 1210 -4103 Part -time Pay 101 -4- 1210 -4104 PERA 101 -4- 1210 -4105 FICA 101 -4- 1210 -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 108,400.00 7,285.13 14,210.75 13.11 94,189.25 381,100.00 29,316.26 54,235.07 14.23 326,864.93 43,000.00 2,979.24 5,643.39 13.12 37,356.61 31,800.00 2,422.16 6,065.70 19.07 25,734.3C 26,300.00 1,943.55 4,896.76 18.62 21,403.24 6,150.00 454.53 1,145.22 18.62 5,004.78 38,450.00 2,860.01 5,720.02 14.88 32,729.98 2,000.00 0.00 450.75 22.54 1,549.25 528,800.00 39,975.75 78,156.91 14.78 450,643.09 13,000.00 4,299.46 4,419.46 34.00 8,580.54 13,000.00 4,299.46 4,419.46 34.00 8,580.54 11,100.00 408.00 743.00 6.69 10,357.00 1,100.00 86.51 86.51 7.86 1,013.49 800.00 469.73 469.73 58.72 330.27 10,250.00 578.98 2,988.98 29.16 7,261.02 4,800.00 400.00 800.00 16.67 4,000.00 12,000.00 0.00 3,186.00 26.55 8,814.00 100.00 0.00 26.50 26.50 73.5C 16,050.00 0.00 1,197.33 7.46 14,852.67 2,000.00 11.96 301.96 15.1C 1,698.04 58,200.00 1,955.18 9,800.01 16.84 48,399.99 3 -10 -2015 02:13 PM 101- GENERAL FUND General Government DEPARTMENTAL EXPENDITURES Capital Outlay TOTAL Administrative Services CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 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 TOTAL Human Resources Elections Personal Services Supplies 101 -4- 1230 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 1230 -4322 Postage 101 -4- 1230 -4331 Travel, Conferences & Schools 101 -4- 1230 -4359 Publishing 101 -4- 1230 -4404 Equip Repair /Maint Services 101 -4- 1230 -4415 Equipment Rental TOTAL Other Services & Charges 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE 600,000.00 46,230.39 92,376.38 15.40 507,623.62 116,300.00 5,649.46 10,451.50 8.99 105,848.5C 8,700.00 423.70 1,055.10 12.13 7,644.9C 7,200.00 337.48 846.66 11.76 6,353.34 1,700.00 78.92 198.00 11.65 1,502.00 17,400.00 589.00 1,178.00 6.77 16,222.00 350.00 0.00 126.25 36.07 223.75 151,650.00 7,078.56 13,855.51 9.14 137,794.49 4,650.00 1,282.81 1,282.81 27.59 3,367.19 4,650.00 1,282.81 1,282.81 27.59 3,367.19 1,000.00 42.95 42.95 4.30 957.0E 500.00 183.29 183.29 36.66 316.71 3,200.00 46.87 46.87 1.46 3,153.13 750.00 0.00 0.00 0.0C 750.00 5,450.00 273.11 273.11 5.01 5,176.89 161,750.00 8,634.48 15,411.43 9.53 146,338.57 2,550.00 0.00 0.00 0.0C 2,550.00 2,550.00 0.00 0.00 0.00 2,550.00 300.00 3.37 3.37 1.12 296.63 250.00 0.00 0.00 0.00 250.00 700.00 0.00 0.00 0.00 700.00 8,850.00 0.00 0.00 0.00 8,850.00 700.00 0.00 0.00 0.0C 700.00 10,800.00 3.37 3.37 0.03 10,796.63 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND General Government 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Elections 13,350.00 3.37 3.37 0.03 13,346.63 Finance Personal Services 13,903.60 25,721.66 14.12 156,428.34 13,650.00 101 -4- 1310 -4101 Regular Pay 311,550.00 23,964.04 44,333.47 14.23 267,216.53 101 -4- 1310 -4103 Part -time Pay 52,350.00 4,301.28 8,363.60 15.98 43,986.4C 101 -4- 1310 -4104 PERA 27,300.00 2,119.92 5,297.25 19.40 22,002.75 101 -4- 1310 -4105 FICA 22,550.00 1,678.01 4,230.15 18.76 18,319.8E 101 -4- 1310 -4107 Medicare 5,300.00 392.43 989.31 18.67 4,310.69 101 -4- 1310 -4108 Insurance 33,550.00 3,054.23 6,108.46 18.21 27,441.54 101 -4- 1310 -4109 Workers Comp 1,700.00 0.00 382.25 22.49 1,317.75 TOTAL Personal Services 454,300.00 35,509.91 69,704.49 15.34 384,595.51 Supplies 101 -4- 1310 -4201 Office Supplies 4,650.00 654.98 654.98 14.09 3,995.02 TOTAL Supplies 4,650.00 654.98 654.98 14.09 3,995.02 Other Services & Charges 101 -4- 1310 -4301 Audit Fees 19,000.00 0.00 2,400.00 12.63 16,600.00 101 -4- 1310 -4319 Other Professional Services 54,000.00 0.00 0.00 0.00 54,000.00 101 -4- 1310 -4321 Telephone 500.00 40.52 40.52 8.10 459.48 101 -4- 1310 -4322 Postage 2,500.00 1,226.21 1,226.21 49.05 1,273.79 101 -4- 1310 -4331 Travel, Conferences & Schools 2,500.00 300.00 300.00 12.00 2,200.00 101 -4- 1310 -4359 Publishing 1,050.00 240.00 240.00 22.86 810.00 101 -4- 1310 -4404 Equip Repair /Maint Services 21,500.00 5,385.00 19,798.10 92.08 1,701.9C 101 -4- 1310 -4433 Dues & Subscriptions 1,600.00 120.00 120.00 7.50 1,480.00 101 -4- 1310 -4438 Credit Card Fees 4,500.00 357.25 357.25 7.94 4,142.7E 101 -4- 1310 -4440 Miscellaneous 1,350.00 80.95 172.25 12.76 1,177.75 TOTAL Other Services & Charges 108,500.00 7,749.93 24,654.33 22.72 83,845.67 Capital Outlay TOTAL Finance Information Technology Personal Services 101 -4- 1350 -4101 Regular Pay 101 -4- 1350 -4104 PERA 101 -4- 1350 -4105 FICA 101 -4- 1350 -4107 Medicare 101 -4- 1350 -4108 Insurance 567,450.00 43,914.82 95,013.80 16.74 472,436.2C 182,150.00 13,903.60 25,721.66 14.12 156,428.34 13,650.00 1,042.78 2,596.68 19.02 11,053.32 11,300.00 791.80 2,009.17 17.78 9,290.83 2,650.00 185.17 469.88 17.73 2,180.12 31,300.00 2,565.03 5,130.06 16.39 26,169.94 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND General Government 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101 -4- 1350 -4109 Workers Comp TOTAL Personal Services Supplies 101 -4- 1350 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 1350 -4319 Other Professional Services 101 -4- 1350 -4321 Telephone 101 -4- 1350 -4331 Travel, Conferences & Schools 101 -4- 1350 -4404 Equip Repair /Maint Services TOTAL Other Services & Charges Capital Outlay TOTAL Information Technology Legal Personal Services Supplies Other Services & Charges 101 -4- 1400 -4304 Legal Fees TOTAL Other Services & Charges TOTAL Legal Community Development Personal Services 101 -4- 1500 -4101 Regular Pay 101 -4- 1500 -4104 PERA 101 -4- 1500 -4105 FICA 101 -4- 1500 -4107 Medicare 101 -4- 1500 -4108 Insurance 101 -4- 1500 -4109 Workers Comp TOTAL Personal Services 850.00 0.00 191.50 22.53 658.5C 241,900.00 18,488.38 36,118.95 14.93 205,781.0E 12,500.00 995.19 995.19 7.96 11,504.81 12,500.00 995.19 995.19 7.96 11,504.81 5,000.00 0.00 0.00 0.00 5,000.0C 2,500.00 151.17 151.17 6.05 2,348.83 10,950.00 663.31 663.31 6.06 10,286.69 59,300.00 13,809.69 18,138.78 30.59 41,161.22 77,750.00 14,624.17 18,953.26 24.38 58,796.74 332,150.00 34,107.74 56,067.40 16.88 276,082.6C 217,600.00 17,050.02 17,050.02 7.84 200,549.98 217,600.00 17,050.02 17,050.02 7.84 200,549.98 217,600.00 17,050.02 17,050.02 7.84 200,549.98 268,300.00 20,639.12 38,182.37 14.23 230,117.63 20,100.00 1,547.94 3,854.66 19.18 16,245.34 16,650.00 1,244.26 3,115.76 18.71 13,534.24 3,900.00 290.98 728.67 18.68 3,171.33 21,000.00 2,025.02 4,050.04 19.29 16,949.96 1,250.00 0.00 282.00 22.56 968.00 331,200.00 25,747.32 50,213.50 15.16 280,986.5C 3 -10 -2015 02:13 PM 101- GENERAL FUND General Government DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: It REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 339,600.00 26,592.80 51,297.98 15.11 288,302.02 101 -4- 1500 -4201 Office Supplies 1,200.00 415.43 415.43 34.62 784.57 TOTAL Supplies 1,200.00 415.43 415.43 34.62 784.57 Other Services & Charges 101 -4- 1510 -4101 Regular Pay 101 -4- 1500 -4321 Telephone 1,400.00 66.31 66.31 4.74 1,333.69 101 -4- 1500 -4331 Travel, Conferences & Schools 4,200.00 363.74 363.74 8.66 3,836.26 101 -4- 1500 -4433 Dues & Subscriptions 1,600.00 0.00 239.00 14.94 1,361.00 TOTAL Other Services & Charges 7,200.00 430.05 669.05 9.29 6,530.9E TOTAL Community Development 339,600.00 26,592.80 51,297.98 15.11 288,302.02 Planning Personal Services 101 -4- 1510 -4101 Regular Pay 129,750.00 9,890.76 18,297.91 14.10 111,452.09 101 -4- 1510 -4104 PERA 9,750.00 741.80 1,847.23 18.95 7,902.77 101 -4- 1510 -4105 FICA 8,050.00 490.08 1,280.77 15.91 6,769.23 101 -4- 1510 -4107 Medicare 1,900.00 114.62 299.54 15.77 1,600.46 101 -4- 1510 -4108 Insurance 27,800.00 2,258.00 4,516.00 16.24 23,284.00 101 -4- 1510 -4109 Workers Comp 650.00 0.00 157.00 24.15 493.00 TOTAL Personal Services 177,900.00 13,495.26 26,398.45 14.84 151,501.5E Supplies 101 -4- 1510 -4201 Office Supplies 1,700.00 0.00 0.00 0.00 1,700.00 101 -4- 1510 -4212 Fuels & Lubes 300.00 0.00 0.00 0.00 300.00 101 -4- 1510 -4219 Operating Supplies 1,350.00 0.00 0.00 O.00 1,350.00 TOTAL Supplies 3,350.00 0.00 0.00 0.00 3,350.00 Other Services & Charges 101 -4- 1510 -4321 Telephone 50.00 28.57 28.57 57.14 21.43 101 -4- 1510 -4322 Postage 2,500.00 171.81 171.81 6.87 2,328.19 101 -4- 1510 -4331 Travel, Conferences & Schools 1,500.00 25.00 25.00 1.67 1,475.00 101 -4- 1510 -4359 Publishing 8,000.00 720.00 720.00 9.00 7,280.00 101 -4- 1510 -4361 Insurance 100.00 0.00 26.25 26.25 73.7E 101 -4- 1510 -4404 Equip Repair /Maint Services 1,500.00 900.00 900.00 60.00 600.00 101 -4- 1510 -4433 Dues & Subscriptions 400.00 318.00 318.00 79.50 82.00 101 -4- 1510 -4440 Miscellaneous 250.00 0.00 0.00 O.00 250.00 TOTAL Other Services & Charges 14,300.00 2,163.38 2,189.63 15.31 12,110.37 Capital Outlay TOTAL Planning 195,550.00 15,658.64 28,588.08 14.62 166,961.92 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND General Government 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE City Hall Maintenance 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 TOTAL City Hall Maintenance Contingency Personal Services 101 -4- 1900 -4101 Regular Pay TOTAL Personal Services Other Services & Charges TOTAL Contingency 337,550.00 25,574.26 47,312.38 14.02 290,237.62 3,500.00 239.05 261.45 7.47 3,238.55 3,400.00 0.00 0.00 0.00 3,400.00 25,600.00 1,935.99 4,801.61 18.76 20,798.39 21,350.00 1,621.59 4,058.36 19.01 17,291.64 5,000.00 379.24 949.13 18.98 4,050.87 42,350.00 3,202.03 6,404.06 15.12 35,945.94 11,350.00 0.00 2,684.75 23.65 8,665.25 450,100.00 32,952.16 66,471.74 14.77 383,628.26 4,000.00 172.78 172.78 4.32 3,827.22 2,400.00 319.90 479.86 19.99 1,920.14 32,350.00 2,136.60 6,610.49 20.43 25,739.51 38,750.00 2,629.28 7,263.13 18.74 31,486.87 11,500.00 1,652.89 1,652.89 14.37 9,847.11 1,200.00 130.00 130.00 10.83 1,070.00 5,550.00 0.00 1,362.00 24.54 4,188.00 31,450.00 3,953.56 4,023.56 12.79 27,426.44 25,700.00 418.95 877.35 3.41 24,822.6E 3,500.00 2,160.00 2,160.00 61.71 1,340.00 1,450.00 120.83 241.66 16.67 1,208.34 80,350.00 8,436.23 10,447.46 13.00 69,902.54 569,200.00 44,017.67 84,182.33 14.79 485,017.67 95,000.00) 0.00 0.00 O.00 ( 95,000.00) 95,000.00) 0.00 0.00 0.00 ( 95,000.00) 95,000.00) 0.00 0.00 0.00 ( 95,000.00) TOTAL General Government 3,151,100.00 248,955.86 472,093.86 14.98 2,679,006.14 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES Police Administration 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 TOTAL Police Administration Patrol Personal Services 101 -4- 2120 -4101 Regular Pay 101 -4- 2120 -4102 Overtime Pay 101 -4- 2120 -4104 PERA 101 -4- 2120 -4107 Medicare 101 -4- 2120 -4108 Insurance TOTAL Personal Services CURRENT CURRENT BUDGET PERIOD 16.67° OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE 358,000.00 19,051.45 35,052.21 9.79 322,947.79 52,800.00 2,761.85 7,580.40 14.36 45,219.6C 3,700.00 191.88 497.09 13.43 3,202.91 3,600.00 267.26 660.13 18.34 2,939.87 38,450.00 1,991.02 3,982.04 10.36 34,467.96 59,100.00 0.00 14,069.75 23.81 45,030.25 515,650.00 24,263.46 61,841.62 11.99 453,808.38 10,350.00 497.49 497.49 4.81 9,852.51 2,900.00 197.98 197.98 6.83 2,702.02 5,350.00 249.00 164.00 3.07 5,186.00 18,600.00 944.47 859.47 4.62 17,740.53 5,900.00 0.00 0.00 0.00 5,900.00 22,950.00 2,190.17 2,190.17 9.54 20,759.83 3,150.00 461.73 461.73 14.66 2,688.27 6,800.00 635.00 635.00 9.34 6,165.00 500.00 0.00 0.00 0.00 500.00 43,100.00 0.00 10,559.00 24.50 32,541.00 71,300.00 3,025.40 38,190.14 53.56 33,109.86 4,900.00 802.00 1,052.00 21.47 3,848.00 300.00 0.00 132.00 44.00 168.00 158,900.00 7,114.30 53,220.04 33.49 105,679.96 693,150.00 32,322.23 115,921.13 16.72 577,228.87 1,598,350.00 113,562.32 211,881.68 13.26 1,386,468.32 90,000.00 3,604.11 5,173.30 5.75 84,826.7C 273,500.00 18,980.98 47,684.27 17.43 225,815.73 23,200.00 1,513.79 3,846.69 16.58 19,353.31 195,200.00 14,264.12 28,528.24 14.61 166,671.76 2,180,250.00 151,925.32 297,114.18 13.63 1,883,135.82 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND Public Safety 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 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 TOTAL Patrol Investigations Personal Services 101 -4- 2130 -4101 Regular Pay 101 -4- 2130 -4102 Overtime Pay 101 -4- 2130 -4104 PERA 101 -4- 2130 -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 100,000.00 9,846.85 9,846.85 9.85 90,153.15 25,400.00 496.75 496.75 1.96 24,903.2E 67,500.00 1,847.62 1,847.62 2.74 65,652.38 23,300.00 638.33 638.33 2.74 22,661.67 216,200.00 12,829.55 12,829.55 5.93 203,370.4E 26,950.00 2,685.00 2,685.00 9.96 24,265.00 25,700.00 1,121.70 1,121.70 4.36 24,578.3C 650.00 50.00 200.00 30.77 450.00 43,550.00 3,629.17 7,258.34 16.67 36,291.66 96,850.00 7,485.87 11,265.04 11.63 85,584.96 2,493,300.00 172,240.74 321,208.77 12.88 2,172,091.23 654,450.00 40,744.01 75,292.24 11.50 579,157.76 50,000.00 1,481.03 2,412.90 4.83 47,587.1C 114,100.00 6,840.48 16,909.25 14.82 97,190.7E 8,900.00 457.78 1,159.87 13.03 7,740.13 88,950.00 6,470.25 12,940.50 14.55 76,009.5C 916,400.00 55,993.55 108,714.76 11.86 807,685.24 6,600.00 0.00 0.00 0.00 6,600.00 12,200.00 188.54 188.54 1.55 12,011.46 18,800.00 188.54 188.54 1.00 18,611.46 6,500.00 407.00 407.00 6.26 6,093.00 6,350.00 655.00 775.00 12.20 5,575.00 2,050.00 0.00 0.00 0.00 2,050.00 12,950.00 1,079.17 2,158.34 16.67 10,791.66 27,850.00 2,141.17 3,340.34 11.99 24,509.66 TOTAL Investigations 963,050.00 58,323.26 112,243.64 11.66 850,806.36 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND Public Safety 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Police Support Services Personal Services 101 -4- 2150 -4101 Regular Pay 101 -4- 2150 -4102 Overtime Pay 101 -4- 2150 -4104 PERA 101 -4- 2150 -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 TOTAL Police Support Services Police Reserves Personal Services 101 -4- 2160 -4103 Part -time Pay 101 -4- 2160 -4105 FICA 101 -4- 2160 -4107 Medicare TOTAL Personal Services Supplies 101 -4- 2160 -4217 Uniform Allowance 101 -4- 2160 -4219 Operating Supplies TOTAL Supplies 380,550.00 29,947.47 54,543.07 14.33 326,006.93 10,000.00 336.04 1,218.27 12.18 8,781.73 29,300.00 2,164.76 5,485.88 18.72 23,814.12 24,200.00 1,805.63 4,479.16 18.51 19,720.84 5,650.00 422.30 1,047.57 18.54 4,602.43 59,750.00 5,163.08 10,326.16 17.28 49,423.84 509,450.00 39,839.28 77,100.11 15.13 432,349.89 1,000.00 0.00 0.00 0.00 1,000.0C 3,850.00 39.95 19.70 0.51 3,830.3C 11,450.00 398.33 398.33 3.48 11,051.67 16,300.00 438.28 418.03 2.56 15,881.97 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 362.00 362.00 2.14 16,538.00 550.00 220.00 220.00 40.00 330.00 6,650.00 554.17 1,108.34 16.67 5,541.66 30,000.00 1,136.17 1,690.34 5.63 28,309.66 555,750.00 41,413.73 79,208.48 14.25 476,541.52 5,500.00 0.00 0.00 0.00 5,500.00 350.00 0.00 0.00 0.00 350.00 100.00 0.00 0.00 0.0C 100.0C 5,950.00 0.00 0.00 0.00 5,950.00 5,500.00 0.00 0.00 0.00 5,500.00 4,000.00 0.00 0.00 0.0C 4,000.00 9,500.00 0.00 0.00 0.00 9,500.00 3 -10 -2015 02:13 PM 101- GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: lE REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 0.00 0.00 0.00 20,800.00 Public safety building 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 15,200.00 5,026.78 5,026.78 33.07 10,173.22 Other Services & Charges 101 -4- 2310 -4105 FICA 1,750.00 129.04 321.63 TOTAL Police Reserves 20,800.00 0.00 0.00 0.00 20,800.00 Public safety building Administration Personal Services Personal Services 101 -4- 2310 -4101 Regular Pay Supplies 14,281.54 26,420.85 14.10 160,979.1E 101 -4- 101 -4- 2190 -4219 Operating Supplies 15,200.00 5,026.78 5,026.78 33.07 10,173.22 TOTAL Supplies 15,200.00 5,026.78 5,026.78 33.07 10,173.22 Other Services & Charges 101 -4- 2310 -4105 FICA 1,750.00 129.04 321.63 101 -4- 2190 -4361 Insurance 5,300.00 0.00 1,320.75 24.92 3,979.25 101 -4- 2190 -4389 Utilities 18,000.00 2,475.75 2,545.75 14.14 15,454.2E 101 -4- 2190 -4401 Bldg Repair /Maint Services 38,650.00 217.95 1,099.74 2.85 37,550.26 TOTAL Other Services & Charges 61,950.00 2,693.70 4,966.24 8.02 56,983.76 Capital Outlay 7,850.00 0.00 2,000.75 25.49 5,849.25 TOTAL Personal Services 308,050.00 21,009.09 42,963.38 TOTAL Public safety building 77,150.00 7,720.48 9,993.02 12.95 67,156.98 Fire Administration Personal Services 101 -4- 2310 -4101 Regular Pay 187,400.00 14,281.54 26,420.85 14.10 160,979.1E 101 -4- 2310 -4103 Part -time Pay 28,100.00 2,081.20 3,854.95 13.72 24,245.0E 101 -4- 2310 -4104 PERA 32,450.00 2,469.70 6,150.40 18.95 26,299.6C 101 -4- 2310 -4105 FICA 1,750.00 129.04 321.63 18.38 1,428.37 101 -4- 2310 -4106 Other Retirement Contributions 30,000.00 0.00 0.00 0.00 30,000.00 101 -4- 2310 -4107 Medicare 3,100.00 224.00 564.38 18.21 2,535.62 101 -4- 2310 -4108 Insurance 17,400.00 1,823.61 3,650.42 20.98 13,749.58 101 -4- 2310 -4109 Workers Comp 7,850.00 0.00 2,000.75 25.49 5,849.25 TOTAL Personal Services 308,050.00 21,009.09 42,963.38 13.95 265,086.62 3 -10 -2015 02:13 PM REVENUE 101- GENERAL FUND Public Safety DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 CURRENT CURRENT BUDGET PERIOD YEAR TO DATE ACTUAL 16.67° OF o OF BUDGET PAGE: 16 YEAR COMP. BUDGET BALANCE Supplies 101 -4- 2320 -4103 Part -time Pay 169,700.00 10,779.28 21,321.89 12.56 101 -4- 2310 -4201 -4105 Office Supplies 3,150.00 0.00 0.00 0.00 3,150.00 101 -4- 2310 -4212 Medicare Fuels & Lubes 4,000.00 641.29 641.29 16.03 3,358.71 101 -4- 2310 -4217 27,400.00 Uniform Allowance 1,500.00 0.00 0.00 0.00 1,500.00 101 -4- 2310 -4221 14.08 Equipment Parts 450.00 0.00 0.00 O.00 450.00 TOTAL Supplies 101 -4- 2320 9,100.00 641.29 641.29 7.05 8,458.71 Other Services 101 & Charges -4212 Fuels & Lubes 7,000.00 463.86 463.86 101 -4- 2310 -4319 -4- 2320 Other Professional Services 5,000.00 0.00 0.00 0.00 5,000.00 101 -4 -2310 -4321 -4219 Telephone 3,750.00 413.38 413.38 11.02 3,336.62 101 -4- 2310 -4322 Equipment Parts Postage 500.00 174.12 174.12 34.82 325.88 101 -4- 2310 -4331 3,934.74 Travel, Conferences & Schools 6,000.00 90.00 90.00 1.50 5,910.00 101 -4- 2310 -4359 Publishing 500.00 0.00 0.00 0.00 500.00 101 -4- 2310 -4361 Insurance 11,200.00 0.00 2,761.00 24.65 8,439.00 101 -4- 2310 -4389 Utilities 12,000.00 1,797.43 1,822.43 15.19 10,177.57 101 -4- 2310 -4401 Bldg Repair /Maint Services 7,000.00 155.00 155.00 2.21 6,845.00 101 -4- 2310 -4404 Equip Repair /Maint Services 3,950.00 0.00 0.00 0.00 3,950.00 101 -4- 2310 -4433 Dues & Subscriptions 2,000.00 839.00 839.00 41.95 1,161.00 101 -4- 2310 -4460 Equip Replacement Charge 38,550.00 3,212.50 6,425.00 16.67 32,125.00 TOTAL Other Services & Charges 90,450.00 6,681.43 12,679.93 14.02 77,770.07 Capital Outlay TOTAL Fire Administration 407,600.00 28,331.81 56,284.60 13.81 351,315.4C Personal Services 101 -4- 2320 -4103 Part -time Pay 169,700.00 10,779.28 21,321.89 12.56 148,378.11 101 -4- 2320 -4105 FICA 10,500.00 625.30 1,524.23 14.52 8,975.77 101 -4- 2320 -4107 Medicare 2,450.00 146.25 356.54 14.55 2,093.46 101 -4- 2320 -4109 Workers Comp 27,400.00 0.00 6,363.75 23.23 21,036.25 TOTAL Personal Services 210,050.00 11,550.83 29,566.41 14.08 180,483.59 Supplies 101 -4- 2320 -4201 Office Supplies 1,200.00 0.00 0.00 0.00 1,200.00 101 -4- 2320 -4212 Fuels & Lubes 7,000.00 463.86 463.86 6.63 6,536.14 101 -4- 2320 -4217 Uniform Allowance 9,150.00 0.00 0.00 0.00 9,150.00 101 -4- 2320 -4219 Operating Supplies 79,500.00 3,470.88 3,470.88 4.37 76,029.12 101 -4- 2320 -4221 Equipment Parts 7,250.00 0.00 0.00 O.00 7,250.00 TOTAL Supplies 104,100.00 3,934.74 3,934.74 3.78 100,165.26 3 -10 -2015 02:13 PM CITY OF ELK RIVER 0.00 0.00 PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) 0.0C 10,600.00 11,400.00 0.00 AS OF: FEBRUARY 28TH, 2015 11,400.00 250.00 26.00 101- GENERAL FUND 10.40 224.00 5,400.00 0.00 0.00 Public Safety 5,400.00 700.00 62.50 16.67° OF YEAR COMP. 637.5C CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 373.50 3.74 9,626.5C 101 -4- 2320 -4321 Telephone 2,950.00 245.74 245.74 8.33 2,704.26 101 -4- 2320 -4331 Travel, Conferences & Schools 26,000.00 1,720.79 1,720.79 6.62 24,279.21 101 -4- 2320 -4404 Equip Repair /Maint Services 36,600.00 512.75 512.75 1.40 36,087.25 101 -4- 2320 -4409 Contractual Services 8,650.00 3,493.50 3,493.50 40.39 5,156.5C TOTAL Other Services & Charges 74,200.00 5,972.78 5,972.78 8.05 68,227.22 Capital Outlay TOTAL Fire Operations Emergency Management Personal Services Supplies 101 -4- 2330 -4201 Office Supplies 101 -4- 2330 -4219 Operating Supplies TOTAL Supplies Other Services & Charges 101 -4- 2330 -4321 Telephone 101 -4- 2330 -4331 Travel, Conferences & Schools 101 -4- 2330 -4389 Utilities 101 -4- 2330 -4404 Equip Repair /Maint Services 101 -4- 2330 -4433 Dues & Subscriptions TOTAL Other Services & Charges Capital Outlay TOTAL Emergency Management Building Safety 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 388,350.00 21,458.35 39,473.93 10.16 348,876.07 800.00 0.00 0.00 0.00 800.0C 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 26.00 26.00 10.40 224.00 5,400.00 0.00 0.00 0.00 5,400.00 700.00 62.50 62.50 8.93 637.5C 3,450.00 0.00 0.00 0.00 3,450.00 200.00 285.00 285.00 142.5C ( 85.0C) 10,000.00 373.50 373.50 3.74 9,626.5C 21,400.00 373.50 373.50 1.75 21,026.5C 448,500.00 34,401.71 63,643.16 14.19 384,856.84 40,050.00 3,071.64 7,649.07 19.10 32,400.93 23,250.00 1,645.02 4,169.18 17.93 19,080.82 6,500.00 461.77 1,169.31 17.99 5,330.69 59,150.00 5,923.04 11,846.08 20.03 47,303.92 2,100.00 0.00 486.50 23.17 1,613.5C 579,550.00 45,503.18 88,963.30 15.35 490,586.7C 3 -10 -2015 02:13 PM CITY OF ELK RIVER 9,806.48 14.23 PAGE: 18 5,150.00 REVENUE & EXPENSE REPORT (UNAUDITED) 4,160.00 4,250.00 340.85 842.80 19.83 AS OF: FEBRUARY 28TH, 2015 79.72 197.11 19.71 101- GENERAL FUND 3,600.00 300.01 600.02 16.67 2,999.98 350.00 Public Safety 75.50 21.57 274.5C 83,250.00 16.67° OF YEAR COMP. 15.03 70,738.09 CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES 322.86 BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101 -4- 2410 -4201 Office Supplies 8,000.00 144.19 144.19 1.80 7,855.81 101 -4- 2410 -4212 Fuels & Lubes 8,000.00 797.21 797.21 9.97 7,202.79 101 -4- 2410 -4217 Uniform Allowance 2,000.00 0.00 0.00 0.00 2,000.00 101 -4- 2410 -4219 Operating Supplies 10,150.00 443.67 443.67 4.37 9,706.33 TOTAL Supplies 28,150.00 1,385.07 1,385.07 4.92 26,764.93 Other Services & Charges 101 -4- 2410 -4321 Telephone 5,100.00 349.22 349.22 6.85 4,750.78 101 -4- 2410 -4322 Postage 600.00 210.37 210.37 35.06 389.63 101 -4- 2410 -4331 Travel, Conferences & Schools 3,500.00 461.30 1,536.30 43.89 1,963.7C 101 -4- 2410 -4361 Insurance 500.00 0.00 116.25 23.25 383.75 101 -4- 2410 -4404 Equip Repair /Maint Services 5,000.00 2,090.00 2,090.00 41.80 2,910.00 101 -4- 2410 -4433 Dues & Subscriptions 3,650.00 1,255.50 1,355.50 37.14 2,294.5C 101 -4- 2410 -4460 Equip Replacement Charge 2,900.00 241.67 483.34 16.67 2,416.66 TOTAL Other Services & Charges 21,250.00 4,608.06 6,140.98 28.90 15,109.02 Capital Outlay TOTAL Building Safety 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 628,950.00 51,496.31 96,489.35 15.34 532,460.6E 68,900.00 5,300.80 9,806.48 14.23 59,093.52 5,150.00 397.56 990.00 19.22 4,160.00 4,250.00 340.85 842.80 19.83 3,407.2C 1,000.00 79.72 197.11 19.71 802.89 3,600.00 300.01 600.02 16.67 2,999.98 350.00 0.00 75.50 21.57 274.5C 83,250.00 6,418.94 12,511.91 15.03 70,738.09 2,000.00 71.57 71.57 3.58 1,928.43 700.00 0.00 0.00 0.0C 700.00 2,700.00 71.57 71.57 2.65 2,628.43 800.00 83.32 83.32 10.42 716.68 800.00 160.37 160.37 20.05 639.63 700.00 0.00 0.00 0.00 700.00 100.00 0.00 29.00 29.00 71.00 950.00 79.17 158.34 16.67 791.66 3,350.00 322.86 431.03 12.87 2,918.97 89,300.00 6,813.37 13,014.51 14.57 76,285.49 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND Public Safety 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Environmental Personal Services 22,914.96 41,261.50 8.62 437,138.5C 4,000.00 101 -4- 2440 -4101 Regular Pay 21,400.00 1,611.70 2,981.64 13.93 18,418.36 101 -4- 2440 -4104 PERA 1,600.00 120.88 301.01 18.81 1,298.99 101 -4- 2440 -4105 FICA 1,350.00 99.92 248.82 18.43 1,101.18 101 -4- 2440 -4107 Medicare 300.00 23.38 58.22 19.41 241.78 101 -4- 2440 -4108 Insurance 1,400.00 307.18 614.36 43.88 785.64 101 -4- 2440 -4109 Workers Comp 300.00 0.00 63.50 21.17 236.5C TOTAL Personal Services 26,350.00 2,163.06 4,267.55 16.20 22,082.4E Supplies 101 -4- 2440 -4201 Office Supplies 900.00 0.00 0.00 0.00 900.00 101 -4- 2440 -4212 Fuels & Lubes 200.00 0.00 0.00 0.00 200.00 101 -4- 2440 -4217 Uniform Allowance 100.00 0.00 0.00 O.00 100.00 TOTAL Supplies 1,200.00 0.00 0.00 0.00 1,200.00 Other Services & Charges 101 -4- 2440 -4321 Telephone 350.00 1.64 1.64 0.47 348.36 101 -4- 2440 -4322 Postage 700.00 46.27 46.27 6.61 653.73 101 -4- 2440 -4331 Travel, Conferences & Schools 850.00 4.53 4.53 0.53 845.47 101 -4- 2440 -4359 Publishing 500.00 0.00 0.00 0.00 500.00 101 -4- 2440 -4433 Dues & Subscriptions 200.00 30.00 30.00 15.00 170.00 TOTAL Other Services & Charges 2,600.00 82.44 82.44 3.17 2,517.56 TOTAL Environmental 30,150.00 2,245.50 4,349.99 14.43 25,800.01 TOTAL Public Safety Street Maintenance Personal Services 101 -4- 3120 -4101 Regular Pay 101 -4- 3120 -4102 Overtime Pay 101 -4- 3120 -4103 Part -time Pay 101 -4- 3120 -4104 PERA 101 -4- 3120 -4105 FICA 101 -4- 3120 -4107 Medicare 101 -4- 3120 -4108 Insurance 101 -4- 3120 -4109 Workers Comp TOTAL Personal Services 6,368,950.00 422,739.28 848,560.92 13.32 5,520,389.08 478,400.00 22,914.96 41,261.50 8.62 437,138.5C 4,000.00 0.00 28.79 0.72 3,971.21 72,700.00 6,291.82 11,320.93 15.57 61,379.07 40,000.00 1,990.10 4,784.11 11.96 35,215.89 34,400.00 1,741.80 4,242.02 12.33 30,157.98 8,050.00 407.37 992.11 12.32 7,057.89 67,100.00 3,806.62 6,866.76 10.23 60,233.24 28,100.00 0.00 6,629.00 23.59 21,471.00 732,750.00 37,152.67 76,125.22 10.39 656,624.78 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 2C REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND Public Works 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101 -4- 3130 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 857.59 857.59 1.14 74,142.41 101 -4 -3120 -4219 Operating Supplies 39,500.00 4,052.00 4,052.00 10.26 35,448.00 101 -4- 3120 -4221 Equipment Parts 54,800.00 6,938.65 7,056.74 12.88 47,743.26 101 -4 -3120 -4226 Street Signs 24,000.00 670.35 670.35 2.79 23,329.65 -4108 TOTAL Supplies 17,800.00 196,150.00 12,518.59 12,636.68 6.44 183,513.32 Other Services & Charges 0.00 1,805.00 22.85 6,095.00 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 606.63 606.63 9.94 5,493.37 101 -4- 3120 -4322 Postage 100.00 6.78 6.78 6.78 93.22 101 -4- 3120 -4331 Travel, Conferences & Schools 3,500.00 405.00 500.00 14.29 3,000.00 101 -4- 3120 -4359 Publishing 200.00 0.00 0.00 0.00 200.00 101 -4- 3120 -4361 Insurance 19,850.00 0.00 4,890.00 24.63 14,960.00 101 -4- 3120 -4389 Utilities 54,000.00 6,952.41 7,902.41 14.63 46,097.59 101 -4- 3120 -4401 Bldg Repair /Maint Services 14,500.00 135.00 135.00 0.93 14,365.00 101 -4- 3120 -4404 Equip Repair /Maint Services 9,000.00 3,362.11 3,362.11 37.36 5,637.89 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 969.30 969.30 16.71 4,830.7C 101 -4- 3120 -4433 Dues & Subscriptions 350.00 0.00 273.75 78.21 76.25 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 15,383.34 16.67 76,916.66 TOTAL Other Services & Charges 258,400.00 20,128.90 34,029.32 13.17 224,370.68 Capital Outlay TOTAL Street Maintenance Snow Removal 1,187,300.00 69,800.16 122,791.22 10.34 1,064,508.78 Personal Services 101 -4- 3130 -4101 Regular Pay 133,550.00 25,526.56 45,919.33 34.38 87,630.67 101 -4- 3130 -4102 Overtime Pay 20,000.00 2,232.89 3,255.98 16.28 16,744.02 101 -4- 3130 -4104 PERA 11,050.00 2,061.86 5,078.09 45.96 5,971.91 101 -4- 3130 -4105 FICA 9,500.00 1,624.97 4,072.91 42.87 5,427.09 101 -4- 3130 -4107 Medicare 2,250.00 380.05 952.56 42.34 1,297.44 101 -4- 3130 -4108 Insurance 17,800.00 3,814.07 7,466.48 41.95 10,333.52 101 -4- 3130 -4109 Workers Comp 7,900.00 0.00 1,805.00 22.85 6,095.00 TOTAL Personal Services 202,050.00 35,640.40 68,550.35 33.93 133,499.65 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND Public Works 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101 -4- 3130 -4219 Operating Supplies 95,500.00 61,629.40 61,629.40 64.53 33,870.6C TOTAL Supplies 95,500.00 61,629.40 61,629.40 64.53 33,870.6C Other Services & Charges Capital Outlay TOTAL Snow Removal Equipment Services Personal Services 101 -4- 3150 -4101 Regular Pay 101 -4- 3150 -4102 Overtime Pay 101 -4- 3150 -4104 PERA 101 -4- 3150 -4105 FICA 101 -4- 3150 -4107 Medicare 101 -4- 3150 -4108 Insurance 101 -4- 3150 -4109 Workers Comp TOTAL Personal Services 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 TOTAL Equipment Services Engineering 297,550.00 97,269.80 130,179.75 43.75 167,370.2H 119,150.00 9,166.40 16,957.84 14.23 102,192.16 3,000.00 0.00 0.00 0.00 3,000.00 9,150.00 687.48 1,711.92 18.71 7,438.08 7,550.00 537.76 1,354.47 17.94 6,195.53 1,800.00 125.76 316.77 17.60 1,483.23 14,150.00 1,136.37 2,237.70 15.81 11,912.3C 3,350.00 0.00 788.00 23.52 2,562.00 158,150.00 11,653.77 23,366.70 14.78 134,783.3C 5,100.00 ( 530.80)( 530.80) 10.41- 5,630.80 10,150.00 769.91 959.90 9.46 9,190.10 10,000.00 62.53 62.53 0.63 9,937.47 25,250.00 301.64 491.63 1.95 24,758.37 1,000.00 0.00 95.00 9.50 905.00 10,000.00 0.00 0.00 0.00 10,000.00 2,150.00 192.45 192.45 8.95 1,957.55 13,150.00 192.45 287.45 2.19 12,862.5E 196,550.00 12,147.86 24,145.78 12.28 172,404.22 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND Public Works 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101 -4 -3300 -4101 Regular Pay 161,800.00 12,356.01 22,858.62 14.13 138,941.38 101 -4- 3300 -4104 PERA 12,150.00 926.70 2,307.63 18.99 9,842.37 101 -4 -3300 -4105 FICA 10,050.00 775.30 1,926.09 19.17 8,123.91 101 -4- 3300 -4107 Medicare 2,350.00 181.33 450.47 19.17 1,899.53 101 -4 -3300 -4108 Insurance 13,950.00 1,147.00 2,294.00 16.44 11,656.00 101 -4- 3300 -4109 Workers Comp 800.00 0.00 177.00 22.13 623.00 TOTAL Personal Services 201,100.00 15,386.34 30,013.81 14.92 171,086.19 Supplies 407.68 1,198.90 17.63 5,601.1C 101 -4- 5110 101 -4- 3300 -4201 Office Supplies 300.00 0.00 0.00 0.00 300.00 101 -4- 3300 -4212 Fuels & Lubes 900.00 45.25 45.25 5.03 854.75 101 -4- 3300 -4219 Operating Supplies 900.00 32.00 32.00 3.56 868.00 TOTAL Supplies 535,081.1C 2,100.00 77.25 77.25 3.68 2,022.75 Other Services & Charges 101 -4- 3300 -4319 Other Professional Services 9,500.00 0.00 0.00 0.00 9,500.00 101 -4- 3300 -4321 Telephone 1,450.00 92.99 92.99 6.41 1,357.01 101 -4- 3300 -4322 Postage 300.00 4.37 4.37 1.46 295.63 101 -4- 3300 -4331 Travel, Conferences & Schools 2,000.00 0.00 0.00 0.00 2,000.00 101 -4- 3300 -4361 Insurance 100.00 0.00 23.25 23.25 76.7E 101 -4- 3300 -4404 Equip Repair /Maint Services 2,100.00 0.00 0.00 0.00 2,100.00 101 -4 -3300 -4460 Equip Replacement Charge 900.00 75.00 150.00 16.67 750.00 TOTAL Other Services & Charges 16,350.00 172.36 270.61 1.66 16,079.39 Capital Outlay TOTAL Engineering 219,550.00 15,635.95 30,361.67 13.83 189,188.33 TOTAL Public Works Parks Department 1,900,950.00 194,853.77 307,478.42 16.17 1,593,471.58 Personal Services 101 -4- 5110 -4101 Regular Pay 400,800.00 30,002.03 54,947.33 13.71 345,852.67 101 -4- 5110 -4102 Overtime Pay 6,600.00 82.26 800.87 12.13 5,799.13 101 -4- 5110 -4103 Part -time Pay 68,250.00 46.71 46.71 0.07 68,203.29 101 -4- 5110 -4104 PERA 30,550.00 2,256.32 5,876.81 19.24 24,673.19 101 -4- 5110 -4105 FICA 29,000.00 1,743.16 5,126.33 17.68 23,873.67 101 -4- 5110 -4107 Medicare 6,800.00 407.68 1,198.90 17.63 5,601.1C 101 -4- 5110 -4108 Insurance 61,600.00 4,943.02 9,788.95 15.89 51,811.0E 101 -4- 5110 -4109 Workers Comp 12,350.00 254.75 3,083.00 24.96 9,267.00 TOTAL Personal Services 615,950.00 39,735.93 80,868.90 13.13 535,081.1C 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND Culture & Recreation DEPARTMENTAL EXPENDITURES 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 TOTAL Parks Department Parks & Rec Admin 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 CURRENT CURRENT BUDGET PERIOD 16.67° OF YEAR COMP. YEAR TO DATE o OF BUDGET ACTUAL BUDGET BALANCE 35,000.00 1,835.50 1,835.50 5.24 33,164.5C 3,800.00 268.95 248.98 6.55 3,551.02 92,650.00 5,202.62 5,872.45 6.34 86,777.5H 21,000.00 2,529.09 2,529.09 12.04 18,470.91 152,450.00 9,836.16 10,486.02 6.88 141,963.98 4,500.00 338.85 338.85 7.53 4,161.1E 100.00 0.00 0.00 0.00 100.0C 5,100.00 330.78 1,025.78 20.11 4,074.22 27,350.00 0.00 7,608.50 27.82 19,741.5C 43,500.00 150.89 545.89 1.25 42,954.11 4,000.00 20.04 20.04 0.50 3,979.96 16,500.00 495.50 495.50 3.00 16,004.5C 33,750.00 0.00 0.00 0.00 33,750.00 13,000.00 595.00 595.00 4.58 12,405.00 50,950.00 4,245.83 8,491.66 16.67 42,458.34 198,750.00 6,176.89 19,121.22 9.62 179,628.78 967,150.00 55,748.98 110,476.14 11.42 856,673.86 285,750.00 21,870.42 40,460.28 14.16 245,289.72 51,700.00 3,919.50 7,085.37 13.70 44,614.63 25,300.00 1,934.24 4,792.82 18.94 20,507.18 21,000.00 1,517.27 3,800.02 18.10 17,199.98 4,900.00 354.85 888.72 18.14 4,011.28 41,700.00 3,405.03 6,810.06 16.33 34,889.94 3,800.00 0.00 840.50 22.12 2,959.5C 434,150.00 33,001.31 64,677.77 14.90 369,472.23 13,500.00 250.85 250.85 1.86 13,249.15 13,500.00 250.85 250.85 1.86 13,249.1E 6,050.00 613.57 613.57 10.14 5,436.43 5,100.00 126.98 126.98 2.49 4,973.02 9,850.00 525.10 665.10 6.75 9,184.9C 34,700.00 49.00 49.00 0.14 34,651.00 400.00 0.00 97.50 24.38 302.5C 5,450.00 543.31 568.31 10.43 4,881.69 3 -10 -2015 02:13 PM CITY OF ELK RIVER 15,483.76 13.90 PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) 1.61 5,608.12 8,350.00 627.72 AS OF: FEBRUARY 28TH, 2015 6,786.88 7,250.00 495.57 101- GENERAL FUND 17.16 6,005.89 1,700.00 115.90 290.97 Culture & Recreation 1,409.03 20,950.00 1,691.02 16.67° OF YEAR COMP. 17,567.96 CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101 -4 -5210 -4401 Bldg Repair /Maint Services 15,200.00 972.65 1,865.45 12.27 13,334.5H 101 -4- 5210 -4404 Equip Repair /Maint Services 7,000.00 0.00 7,574.10 108.20 ( 574.10) 101 -4- 5210 -4433 Dues & Subscriptions 1,800.00 460.00 2,245.00 124.72 ( 445.00) TOTAL Other Services & Charges 85,550.00 3,290.61 13,805.01 16.14 71,744.99 Capital Outlay TOTAL Parks & Rec Admin 533,200.00 36,542.77 78,733.63 14.77 454,466.37 Recreation Programs Personal Services 101 -4- 5220 -4103 Part -time Pay 82,000.00 2,594.11 4,649.95 5.67 77,350.05 101 -4- 5220 -4104 PERA 0.00 53.46 119.99 0.00 ( 119.99) 101 -4- 5220 -4105 FICA 4,300.00 160.83 317.54 7.38 3,982.46 101 -4- 5220 -4107 Medicare 1,200.00 37.61 74.26 6.19 1,125.74 TOTAL Personal Services 87,500.00 2,846.01 5,161.74 5.90 82,338.26 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 5,275.00 5,275.00 11.72 39,725.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 147.60 147.60 4.1C 3,452.4C TOTAL Other Services & Charges 50,250.00 5,422.60 5,422.60 10.79 44,827.4C TOTAL Recreation Programs 165,750.00 8,268.61 10,584.34 6.39 155,165.66 Concessions Personal Services Sr Citizen Programs Personal Services 101 -4- 5510 -4101 Regular Pay 101 -4- 5510 -4103 Part -time Pay 101 -4- 5510 -4104 PERA 101 -4- 5510 -4105 FICA 101 -4- 5510 -4107 Medicare 101 -4- 5510 -4108 Insurance 101 -4- 5510 -4109 Workers Comp TOTAL Personal Services 111,400.00 8,369.60 15,483.76 13.90 95,916.24 5,700.00 56.88 91.88 1.61 5,608.12 8,350.00 627.72 1,563.12 18.72 6,786.88 7,250.00 495.57 1,244.11 17.16 6,005.89 1,700.00 115.90 290.97 17.12 1,409.03 20,950.00 1,691.02 3,382.04 16.14 17,567.96 550.00 0.00 123.00 22.36 427.00 155,900.00 11,356.69 22,178.88 14.23 133,721.12 3 -10 -2015 02:13 PM CITY OF ELK RIVER PAGE: 2E REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 101- GENERAL FUND Culture & Recreation 16.67° OF YEAR COMP. DEPARTMENTAL EXPENDITURES CURRENT BUDGET CURRENT PERIOD YEAR TO DATE ACTUAL o OF BUDGET BUDGET BALANCE Supplies 3,042.00 0.00 ( 3,042.00) 0.00 18.12 507.15 0.00 ( 507.15) 101 -4- 5510 -4219 Operating Supplies 11,900.00 1,155.89 1,155.89 9.71 10,744.11 TOTAL Supplies 0.00 562.01 11,900.00 1,155.89 1,155.89 9.71 10,744.11 Other Services 0.00 & Charges 11,008.78 0.00 ( 11,008.78) 0.00 67.39 101 -4- 5510 -4321 Telephone 2,400.00 225.55 225.55 9.40 2,174.4E 101 -4- 5510 -4322 Postage 3,300.00 178.79 178.79 5.42 3,121.21 101 -4- 5510 -4331 Travel, Conferences & Schools 3,050.00 0.00 0.00 0.00 3,050.00 101 -4- 5510 -4361 Insurance 1,400.00 0.00 347.25 24.80 1,052.7E 101 -4- 5510 -4389 Utilities 9,950.00 851.81 876.81 8.81 9,073.19 101 -4- 5510 -4401 Bldg Repair /Maint Services 16,050.00 597.20 1,144.40 7.13 14,905.6C 101 -4- 5510 -4404 Equip Repair /Maint Services 100.00 0.00 0.00 0.00 100.00 101 -4- 5510 -4409 Contractual Services 10,700.00 109.60 474.60 4.44 10,225.4C 101 -4- 5510 -4433 Dues & Subscriptions 850.00 141.65 301.65 35.49 548.35 TOTAL Other Services & Charges 47,800.00 2,104.60 3,549.05 7.42 44,250.9E Capital Outlay TOTAL Sr Citizen Programs 215,600.00 14,617.18 26,883.82 12.47 188,716.18 TOTAL Culture & Recreation Economic Development Personal Services 101 -4- 6210 -4101 Regular Pay 101 -4- 6210 -4103 Part -time Pay 101 -4- 6210 -4104 PERA 101 -4- 6210 -4105 FICA 101 -4- 6210 -4107 Medicare 101 -4- 6210 -4108 Insurance 101 -4- 6210 -4109 Workers Comp TOTAL Personal Services Other Services & Charges 101 -4- 6210 -4440 Miscellaneous TOTAL Other Services & Charges TOTAL Economic Development 1,881,700.00 115,177.54 226,677.93 12.05 1,655,022.07 0.00 41.57 6,361.95 0.00 ( 6,361.95) 0.00 936.00 3,042.00 0.00 ( 3,042.00) 0.00 18.12 507.15 0.00 ( 507.15) 0.00 42.02 541.35 0.00 ( 541.35) 0.00 14.19 135.32 0.00 ( 135.32) 0.00 0.00 562.01 0.00 ( 562.01) 0.00 ( 298.00)( 141.00) O.00 141.00 0.00 753.90 11,008.78 0.00 ( 11,008.78) 0.00 67.39 67.39 0.0C ( 67.39) 0.00 67.39 67.39 0.00 ( 67.39) 0.00 821.29 11,076.17 0.00 ( 11,076.17) 3 -10 -2015 02:13 PM 101- GENERAL FUND Economic Development DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Energy City Personal Services 101 -4- 6220 -4101 Regular Pay 4,500.00 339.30 627.70 13.95 3,872.3C 101 -4 -6220 -4104 PERA 350.00 25.44 63.35 18.10 286.65 101 -4- 6220 -4105 FICA 300.00 21.04 52.39 17.46 247.61 101 -4- 6220 -4107 Medicare 50.00 4.92 12.25 24.50 37.75 101 -4- 6220 -4108 Insurance 300.00 36.36 72.72 24.24 227.28 TOTAL Personal Services 5,500.00 427.06 828.41 15.06 4,671.59 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.0C 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 427.06 828.41 8.20 9,271.59 TOTAL Economic Development 10,100.00 1,248.35 11,904.58 117.87 ( 1,804.58) Transfers Out Transfers Out TOTAL EXPENDITURES 13,312,800.00 982,974.80 1,866,715.71 14.02 11,446,084.29 REVENUES OVER /(UNDER) EXPENDITURES 0.00 ( 809,993.65)( 1,573,366.10) 1,573,366.1C 3 -10 -2015 02:14 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) 50,402.03 74,302.36 12.43 523,247.64 AS OF: FEBRUARY 28TH, 2015 218.22 218.22 1.05 221 -ICE ARENA Skating 27,850.00 1,084.95 1,694.22 6.08 FINANCIAL SUMMARY Arena Concessions 59,900.00 10,341.53 16.67° OF YEAR COMP. 46,011.76 CURRENT CURRENT YEAR TO DATE o OF BUDGET 615,996.96 BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Ice Arena 629,650.00 97,358.20 109,582.29 17.40 520,067.71 Hockey 37,000.00 33,815.00 39,770.00 107.49 ( 2,770.00) Skating 39,500.00 8,278.00 10,316.00 26.12 29,184.00 Concessions 79,000.00 12,232.20 27,160.45 34.38 51,839.55 TOTAL REVENUES 785,150.00 151,683.40 186,828.74 23.80 598,321.26 EXPENDITURE SUMMARY Culture & Recreation Ice Arena 597,550.00 50,402.03 74,302.36 12.43 523,247.64 Hockey 20,800.00 218.22 218.22 1.05 20,581.78 Skating 27,850.00 1,084.95 1,694.22 6.08 26,155.78 Arena Concessions 59,900.00 10,341.53 13,888.24 23.19 46,011.76 TOTAL Culture & Recreation 706,100.00 62,046.73 90,103.04 12.76 615,996.96 TOTAL EXPENDITURES 706,100.00 62,046.73 90,103.04 12.76 615,996.96 REVENUES OVER /(UNDER) EXPENDITURES 79,050.00 89,636.67 96,725.70 17,675.70) 3 -10 -2015 02:14 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 221 -ICE ARENA 16.67° 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 89,208.78 90,479.02 17.23 434,520.98 29,200.00 1,391.50 8,316.50 28.48 20,883.5C 19,750.00 1,123.00 1,739.00 8.81 18,011.0C 4,300.00 360.00 1,068.00 24.84 3,232.00 2,600.00 0.00 0.00 0.00 2,600.00 22,000.00 233.34 233.34 1.06 21,766.66 602,850.00 92,316.62 101,835.86 16.89 501,014.14 2,200.00 335.35 335.35 15.24 1,864.6E 14,000.00 1,260.38 3,464.88 24.75 10,535.12 6,500.00 3,210.00 3,210.00 49.38 3,290.00 3,800.00 195.95 659.20 17.35 3,140.8C 26,500.00 5,001.68 7,669.43 28.94 18,830.57 300.00 39.90 77.00 25.67 223.00 300.00 39.90 77.00 25.67 223.00 629,650.00 97,358.20 109,582.29 17.40 520,067.71 37,000.00 33,815.00 39,770.00 107.49 ( 2,770.00) 37,000.00 33,815.00 39,770.00 107.49 ( 2,770.00) 37,000.00 33,815.00 39,770.00 107.49 ( 2,770.00) 3 -10 -2015 02:14 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 221 -ICE ARENA 16.67° 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 7,198.00 9,236.00 26.02 26,264.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 7,198.00 9,236.00 23.38 30,264.00 Other Revenue 221 -3- 5420 -3629 Miscellaneous Revenue 0.00 1,080.00 1,080.00 O.00 ( 1,080.00) TOTAL Other Revenue 0.00 1,080.00 1,080.00 0.00 ( 1,080.00) TOTAL Skating 39,500.00 8,278.00 10,316.00 26.12 29,184.00 Concessions Charges for Services 221 -3- 5430 -3467 Concessions 79,000.00 12,232.20 27,160.45 34.38 51,839.55 TOTAL Charges for Services 79,000.00 12,232.20 27,160.45 34.38 51,839.55 TOTAL Concessions 79,000.00 12,232.20 27,160.45 34.38 51,839.5E TOTAL REVENUE 785,150.00 151,683.40 186,828.74 23.80 598,321.26 3 -10 -2015 02:14 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 221 -ICE ARENA 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Personal Services 221 -4- 5400 -4101 Regular Pay 180,200.00 9,592.82 17,746.72 9.85 162,453.28 221 -4- 5400 -4103 Part -time Pay 61,450.00 8,301.13 15,149.33 24.65 46,300.67 221 -4- 5400 -4104 PERA 18,100.00 1,147.88 2,718.71 15.02 15,381.29 221 -4- 5400 -4105 FICA 15,000.00 1,093.22 2,675.06 17.83 12,324.94 221 -4- 5400 -4107 Medicare 3,550.00 255.64 625.58 17.62 2,924.42 221 -4- 5400 -4108 Insurance 27,750.00 1,409.02 2,818.04 10.16 24,931.96 221 -4- 5400 -4109 Workers Comp 8,000.00 0.00 2,227.25 27.84 5,772.75 TOTAL Personal Services 314,050.00 21,799.71 43,960.69 14.00 270,089.31 Supplies 221 -4- 5400 -4212 Fuels & Lubes 300.00 0.00 0.00 0.00 300.00 221 -4- 5400 -4217 Uniform Allowance 800.00 0.00 0.00 0.00 800.00 221 -4- 5400 -4219 Operating Supplies 49,950.00 14,462.24 14,534.21 29.10 35,415.79 221 -4- 5400 -4255 Soft Drinks /Misc 6,800.00 1,661.58 1,661.58 24.44 5,138.42 221 -4- 5400 -4259 Other Merchandise For Resale 900.00 0.00 0.00 O.00 900.00 TOTAL Supplies 58,750.00 16,123.82 16,195.79 27.57 42,554.21 Other Services & Charges 221 -4- 5400 -4321 Telephone 3,350.00 160.31 247.81 7.40 3,102.19 221 -4- 5400 -4322 Postage 0.00 54.14 54.14 0.00 ( 54.14) 221 -4- 5400 -4331 Travel, Conferences & Schools 2,450.00 0.00 0.00 0.00 2,450.00 221 -4- 5400 -4359 Publishing 5,700.00 0.00 0.00 0.00 5,700.00 221 -4- 5400 -4361 Insurance 4,850.00 0.00 1,202.75 24.80 3,647.2E 221 -4- 5400 -4389 Utilities 157,250.00 11,018.50 11,018.50 7.01 146,231.5C 221 -4- 5400 -4401 Bldg Repair /Maint Services 33,300.00 923.42 923.42 2.77 32,376.58 221 -4- 5400 -4409 Contractual Services 1,900.00 0.00 0.00 0.00 1,900.00 221 -4- 5400 -4415 Equipment Rental 3,700.00 227.13 454.26 12.28 3,245.74 221 -4- 5400 -4433 Dues & Subscriptions 750.00 95.00 245.00 32.67 505.00 TOTAL Other Services & Charges 213,250.00 12,478.50 14,145.88 6.63 199,104.12 Capital Outlay 221 -4- 5400 -4560 Equipment 11,500.00 0.00 0.00 0.0C 11,500.00 TOTAL Capital Outlay 11,500.00 0.00 0.00 0.00 11,500.00 Transfers Out TOTAL Ice Arena 597,550.00 50,402.03 74,302.36 12.43 523,247.64 3 -10 -2015 02:14 PM 221 -ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Hockey 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 218.22 218.22 7.79 2,581.78 TOTAL Other Services & Charges 8,300.00 218.22 218.22 2.63 8,081.78 TOTAL Hockey 20,800.00 218.22 218.22 1.05 20,581.78 Skating Personal Services 221 -4- 5420 -4103 Part -time Pay 17,800.00 544.29 1,092.03 6.14 16,707.97 221 -4- 5420 -4104 PERA 1,000.00 5.04 13.63 1.36 986.37 221 -4- 5420 -4105 FICA 1,100.00 33.74 76.65 6.97 1,023.3E 221 -4- 5420 -4107 Medicare 250.00 7.89 17.92 7.17 232.08 TOTAL Personal Services 20,150.00 590.96 1,200.23 5.96 18,949.77 Supplies 221 -4- 5420 -4219 Operating Supplies 5,100.00 424.27 424.27 8.32 4,675.73 TOTAL Supplies 5,100.00 424.27 424.27 8.32 4,675.73 Other Services & Charges 221 -4- 5420 -4359 Publishing 1,000.00 0.00 0.00 0.00 1,000.00 221 -4- 5420 -4409 Contractual Services 1,600.00 0.00 0.00 0.00 1,600.00 221 -4- 5420 -4438 Credit Card Fees 0.00 69.72 69.72 O.00 ( 69.72) TOTAL Other Services & Charges 2,600.00 69.72 69.72 2.68 2,530.28 TOTAL Skating 27,850.00 1,084.95 1,694.22 6.08 26,155.78 3 -10 -2015 02:14 PM 221 -ICE ARENA Culture & Recreation DEPARTMENTAL EXPENDITURES CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2015 16.67° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Arena Concessions 706,100.00 62,046.73 90,103.04 12.76 615,996.96 TOTAL EXPENDITURES Personal Services 62,046.73 90,103.04 12.76 615,996.96 REVENUES OVER /(UNDER) EXPENDITURES 221 -4- 5430 -4103 Part -time Pay 21,300.00 3,053.64 5,933.68 27.86 15,366.32 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 189.33 464.15 35.70 835.85 221 -4- 5430 -4107 Medicare 300.00 44.28 108.58 36.19 191.42 TOTAL Personal Services 24,500.00 3,287.25 6,506.41 26.56 17,993.59 Supplies 221 -4- 5430 -4219 Operating Supplies 5,800.00 207.59 357.59 6.17 5,442.41 221 -4- 5430 -4259 Other Merchandise For Resale 29,600.00 6,846.69 7,024.24 23.73 22,575.76 TOTAL Supplies 35,400.00 7,054.28 7,381.83 20.85 28,018.17 TOTAL Arena Concessions 59,900.00 10,341.53 13,888.24 23.19 46,011.76 TOTAL Culture & Recreation 706,100.00 62,046.73 90,103.04 12.76 615,996.96 TOTAL EXPENDITURES 706,100.00 62,046.73 90,103.04 12.76 615,996.96 REVENUES OVER /(UNDER) EXPENDITURES 79,050.00 89,636.67 96,725.70 17,675.70) wH i W x� W W � 0 Q H w uw z w a a w Q Q z x H O 3 a d a d a G u 0 a a o� 0 0 00000 e 0000 e e C � G G C R � � Ff3 U O b0 0 0 0 0 0 0 0 0 0 c b o 0 0 o c o 0 o c c a � oil r 1 � R � Ff3 s. b0 3 � w O b0 0 0 0 0 0 0 0 0 0 a o 0 0 o c o 0 o c o a L a � its r o cn 000 0000 00000 a 0000 a o0o e w L o = o s. [G ? U3 U3 Pill 1 e O a = j N n n � Ff3 sA a d � = U � e N LL-2 3 a d a d a G u 0 a a R C � G G C 3 a d a d a G u 0 a a 3 -10 -2015 02:15 PM FUND ACCOUNT# ACCOUNT NAME CLAIM ON CASH CITY OF ELK RIVER POOLED CASH REPORT (FUND 999) AS OF: FEBRUARY 28TH, 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 14,987.58 5,172,215.21 420,963.63 305,146.82 3,327.79) 76,262.04 622,062.82 717,594.09 892,960.27 200,000.00 413,464.58 212,391.93 1,334,876.60 254,317.97 3,890,236.90 32,963.67 82,629.32 2,779,504.28 236,354.31 852,244.82 2,357,438.71 2,043,194.90 301,629.35 4,591,901.20 882,819.78 383,158.23 150,521.64 368,548.49 1,328.25 13,774,282.60 2,639,343.67 603,488.52 2,477.00 43,405.79 93,314.89 46,744,702.07 PAGE: 1 INFORMATION CURRENT CURRENT ACTIVITY BALANCE 2,021.46 17,009.04 724,196.43) 4,448,018.78 4,555.51) 416,408.12 85,793.27 390,940.09 4,195.14 867.35 3,712.00 79,974.04 194.73) 621,868.09 788.65 718,382.74 3,931.41 896,891.68 0.00 200,000.00 454.40 413,918.98 266.60) 212,125.33 23,009.14 1,357,885.74 298.70) 254,019.27 736,715.99) 3,153,520.91 553.35) 32,410.32 12,443.03) 70,186.29 3,054.66 2,782,558.94 140,492.24) 95,862.07 366,625.90) 485,618.92 174,819.29 2,532,258.00 190,451.30) 1,852,743.6C 17,381.62) 284,247.73 310,042.15) 4,281,859.05 21,899.38 904,719.16 421.09 383,579.32 9,745.73) 140,775.91 405.05 368,953.54 1,328.25) O.00 888,895.20) 12,885,387.4C 77,417.12) 2,561,926.55 29,827.98 633,316.5C 119,077.87) ( 116,600.87) 39,189.32) 4,216.47 2,384.00) 90,930.89 3,287,922.12) 43,456,779.95 999 -1000 A/P BANK ACCOUNTS 72,196,958.41 2,430,052.15) 69,766,906.26 999 -1001 PY BANK ACCOUNT (53,834,445.90) ( 857,889.72) (54,692,335.62) 999 -1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 46,744,702.07 3,287,941.87) 43,456,760.2C