Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 05-18-2015
INFORMATION City of Memorandum Elk River TO: Mayor and City Council From: Tim Simon, Finance Director Date: May 18, 2015 Subject: April 2015 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund and Ice Arena Special Revenue Fund. These funds provide an important picture of the city's financial health. For the month of April, actual revenues (except for property taxes and state aids) and expenditures should run about 33% 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. The first quarter gravel tax was received in April. ■ Licenses and permits collections are over 31% of budget estimates. ■ Charges for services are 40% of budget and consist mainly of engineering services reimbursement,Big Lake Township fire contract and recreation-related registrations. ■ Fine collections,which lag a month, are about 34% of budget. ■ The majority of transfers in will be recorded mid-year. Expenditures: • Total departmental expenditures are about 29% of budget and most departments are within or below budget. • The Finance Department expenditures for April include the annual appraisal services payment to the County. PIVEIEI IT NATURE 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,867 $2,896 $3,919 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 April, revenues exceed expenditures by$125,198. Revenues are over 39% of budget and expenditures are about 26% of budget. Ice rental revenues are about 35% of budget estimate. Attachments ■ General Fund Revenue & Expense Report ■ Enterprise Funds —Budget to Actual ■ Cash Report—All Funds 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 INFORMATION 101-GENERAL FUND FINANCIAL SUMMARY 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 13,312,800.00 329,269.41 793,249.95 5.96 12,519,550.05 TOTAL REVENUES 13,312,800.00 329,269.41 793,249.95 5.96 12,519,550.0E EXPENDITURE SUMMARY General Government Mayor & Council 141,050.00 3,689.70 42,087.31 29.84 98,962.69 Cable TV 108,400.00 7,497.49 29,335.83 27.06 79,064.17 Administrative Services 600,000.00 45,040.05 180,027.14 30.00 419,972.86 Human Resources 161,750.00 13,360.04 40,080.05 24.78 121,669.9E Elections 13,350.00 0.00 8,803.37 65.94 4,546.63 Finance 567,450.00 103,357.79 234,339.27 41.30 333,110.73 Information Technology 332,150.00 32,318.40 119,187.69 35.88 212,962.31 Legal 217,600.00 16,400.00 50,902.02 23.39 166,697.98 Community Development 339,600.00 26,013.00 103,602.04 30.51 235,997.96 Planning 195,550.00 14,333.89 57,484.18 29.40 138,065.82 City Hall Maintenance 569,200.00 49,590.05 180,466.24 31.71 388,733.76 Contingency 95,000.00) 0.00 0.00 O.00 ( 95,000.00) TOTAL General Government 3,151,100.00 311,600.41 1,046,315.14 33.20 2,104,784.86 Public Safety Police Administration 693,150.00 44,735.26 221,519.06 31.96 471,630.94 Patrol 2,493,300.00 169,492.47 668,864.32 26.83 1,824,435.68 Investigations 963,050.00 58,937.93 230,175.40 23.90 732,874.6C Police Support Services 555,750.00 33,686.51 154,934.58 27.88 400,815.42 Police Reserves 20,800.00 915.80 1,400.80 6.73 19,399.2C Public safety building 77,150.00 4,035.64 18,864.44 24.45 58,285.56 Fire Administration 407,600.00 29,124.65 117,614.47 28.86 289,985.53 Fire Operations 388,350.00 28,879.70 92,976.36 23.94 295,373.64 Emergency Management 21,400.00 1,408.91 2,517.96 11.77 18,882.04 Building Safety 628,950.00 47,338.84 192,695.82 30.64 436,254.18 Code Enforcement 89,300.00 6,751.80 26,854.44 30.07 62,445.56 Environmental 30,150.00 2,190.18 8,851.45 29.36 21,298.55 TOTAL Public Safety 6,368,950.00 427,497.69 1,737,269.10 27.28 4,631,680.9C Public Works Street Maintenance 1,187,300.00 107,187.01 345,732.00 29.12 841,568.00 Snow Removal 297,550.00 9,468.18 167,306.63 56.23 130,243.37 Equipment Services 196,550.00 12,744.62 51,386.65 26.14 145,163.35 Engineering 219,550.00 17,519.21 63,303.66 28.83 156,246.34 TOTAL Public Works 1,900,950.00 146,919.02 627,728.94 33.02 1,273,221.06 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND FINANCIAL SUMMARY 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Culture & Recreation Parks Department 967,150.00 65,034.85 253,444.84 26.21 713,705.16 Parks & Rec Admin 533,200.00 45,597.91 161,733.07 30.33 371,466.93 Recreation Programs 165,750.00 6,015.94 17,870.60 10.78 147,879.4C Sr Citizen Programs 215,600.00 16,360.49 58,850.77 27.3C 156,749.23 TOTAL Culture & Recreation 1,881,700.00 133,009.19 491,899.28 26.14 1,389,800.72 Economic Development Economic Development 0.00 3,341.21 14,134.70 0.00 ( 14,134.70) Energy City 10,100.00 521.96 1,977.43 19.58 8,122.57 TOTAL Economic Development 10,100.00 3,863.17 16,112.13 159.53 ( 6,012.13) General TOTAL EXPENDITURES 13,312,800.00 1,022,889.48 3,919,324.59 29.44 9,393,475.41 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 693,620.07) ( 3,126,074.64) 3,126,074.64 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE General Fund Taxes 101-3-0000-3111 Current Ad Valorem Taxes 9,420,750.00 0.00 1,547.05 0.02 9,419,202.95 101-3-0000-3121 Gravel Tax 125,000.00 9,696.08 9,696.08 7.76 115,303.92 TOTAL Taxes 9,545,750.00 9,696.08 11,243.13 0.12 9,534,506.87 Licenses & Permits 101-3-0000-3211 Liquor License 61,000.00 28,725.00 35,665.00 58.47 25,335.00 101-3-0000-3212 Amusement License 1,200.00 0.00 0.00 0.00 1,200.00 101-3-0000-3213 Cigarette License 3,500.00 0.00 0.00 0.00 3,500.00 101-3-0000-3214 Apartment License 30,000.00 5,131.00 32,405.00 108.02 ( 2,405.00) 101-3-0000-3216 Mining License 21,000.00 1,510.20 1,510.20 7.19 19,489.8C 101-3-0000-3217 Garbage Hauler License 2,000.00 0.00 360.00 18.00 1,640.00 101-3-0000-3218 Other Business License/Permit 11,000.00 1,740.00 3,700.00 33.64 7,300.00 101-3-0000-3229 NPDES Permit 10,000.00 1,750.00 2,800.00 28.00 7,200.00 101-3-0000-3231 Building Permit 350,000.00 23,876.85 58,349.15 16.67 291,650.8E 101-3-0000-3232 Plumbing/Heating Permit 92,000.00 19,074.81 46,820.59 50.89 45,179.41 101-3-0000-3233 Permit Surcharge 2,000.00 422.72 2,111.83 105.59 ( 111.83) 101-3-0000-3235 Animal License 6,000.00 60.00 1,182.00 19.70 4,818.00 101-3-0000-3236 Parking Permit 1,200.00 37.43 208.43 17.37 991.57 101-3-0000-3237 Other Non-Business Lic/Permit 8,500.00 1,150.00 3,300.00 38.82 5,200.00 TOTAL Licenses & Permits 599,400.00 83,478.01 188,412.20 31.43 410,987.8C Intergovernmental Rev 101-3-0000-3311 Federal Grant 3,600.00 0.00 0.00 0.00 3,600.00 101-3-0000-3322 MV Credit 4,000.00 0.00 0.00 0.00 4,000.00 101-3-0000-3324 PERA Aid 14,100.00 0.00 0.00 0.00 14,100.00 101-3-0000-3325 Police 20 Aid 225,000.00 0.00 0.00 0.00 225,000.00 101-3-0000-3326 Police Training Reimb 11,000.00 0.00 0.00 0.00 11,000.00 101-3-0000-3329 State Crime Prevention Grant 25,250.00 0.00 0.00 0.00 25,250.00 101-3-0000-3330 Other State Grants 3,600.00 0.00 0.00 O.00 3,600.00 TOTAL Intergovernmental Rev 286,550.00 0.00 0.00 0.00 286,550.00 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 12,000.00 3,825.00 8,640.00 72.00 3,360.00 101-3-0000-3413 Plan Check Fee 105,000.00 9,094.49 20,841.48 19.85 84,158.52 101-3-0000-3415 Special Assessment Search 1,000.00 60.00 220.00 22.00 780.00 101-3-0000-3417 Copies 2,000.00 52.42 337.01 16.85 1,662.99 101-3-0000-3418 Other General Govt Services 4,500.00 427.50 1,460.00 32.44 3,040.00 101-3-0000-3430 Lockout Fees 7,500.00 420.00 2,030.00 27.07 5,470.00 101-3-0000-3431 Police Services 6,000.00 0.00 90.00 1.50 5,910.00 101-3-0000-3432 School Liaison 123,600.00 0.00 61,812.00 50.01 61,788.00 101-3-0000-3434 Animal Impound Fee 3,000.00 250.00 600.00 20.00 2,400.00 101-3-0000-3436 Fire Contracts 206,000.00 22,258.00 121,042.00 58.76 84,958.00 101-3-0000-3437 Fire Services 3,000.00 34.95 81.35 2.71 2,918.6E 101-3-0000-3438 Fire Inspections 10,000.00 0.00 0.00 0.00 10,000.00 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-3-0000-3450 Maintenance Facility Rent 14,100.00 1,156.50 4,626.00 32.81 9,474.00 101-3-0000-3451 Street Services 38,900.00 5,307.52 10,828.46 27.84 28,071.54 101-3-0000-3452 Engineering Services Reimb 141,700.00 33,776.30 33,776.30 23.84 107,923.7C 101-3-0000-3461 Recreation Fees 95,000.00 16,718.28 45,230.86 47.61 49,769.14 101-3-0000-3462 Sr Center Activities 28,000.00 1,909.00 11,247.00 40.17 16,753.00 101-3-0000-3472 Park Use Fee 22,000.00 227.11 7,795.65 35.43 14,204.3E 101-3-0000-3475 Building Rent 2,400.00 200.00 800.00 33.33 1,600.00 101-3-0000-3483 Sewer Inspection Fee 5,000.00 605.00 1,210.00 24.20 3,790.00 101-3-0000-3484 Contractor License Check 500.00 115.00 190.00 38.00 310.00 TOTAL Charges for Services 831,200.00 96,437.07 332,858.11 40.05 498,341.89 Fines & Forfeits 101-3-0000-3510 Court Fines 115,000.00 12,445.64 33,509.71 29.14 81,490.29 101-3-0000-3511 Parking Fines 10,000.00 520.00 8,500.00 85.00 1,500.00 101-3-0000-3512 Ordinance Violations 0.00 0.00 200.00 O.00 ( 200.00) TOTAL Fines & Forfeits 125,000.00 12,965.64 42,209.71 33.77 82,790.29 Special Assessments Other Revenue 101-3-0000-3621 Interest Income 85,000.00 0.00 11,441.92 13.46 73,558.08 101-3-0000-3625 Refunds & Reimbursements 101,000.00 ( 136.12) 8.77 0.01 100,991.23 101-3-0000-3626 Contributions 25,000.00 0.00 14,000.00 56.00 11,000.00 101-3-0000-3629 Miscellaneous Revenue 6,000.00 1,869.47 2,743.07 45.72 3,256.93 TOTAL Other Revenue 217,000.00 1,733.35 28,193.76 12.99 188,806.24 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 124,959.26 190,333.04 25.69 550,566.96 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 124,959.26 190,333.04 11.14 1,517,566.96 TOTAL General Fund 13,312,800.00 329,269.41 793,249.95 5.96 12,519,550.0E TOTAL REVENUE 13,312,800.00 329,269.41 793,249.95 5.96 12,519,550.0E 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND 33.33° 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 12,833.28 33.33 25,666.72 101-4-1110-4104 PERA 1,900.00 100.01 400.04 21.05 1,499.96 101-4-1110-4105 FICA 2,400.00 74.92 299.68 12.49 2,100.32 101-4-1110-4107 Medicare 550.00 46.52 186.08 33.83 363.92 101-4-1110-4109 Workers Comp 100.00 0.00 39.00 39.00 61.00 TOTAL Personal Services 43,450.00 3,429.77 13,758.08 31.66 29,691.92 Supplies 101-4-1110-4201 Office Supplies 1,200.00 28.53 100.42 8.37 1,099.58 TOTAL Supplies 1,200.00 28.53 100.42 8.37 1,099.58 Other Services & Charges 101-4-1110-4319 Other Professional Services 10,400.00 0.00 3,789.61 36.44 6,610.39 101-4-1110-4322 Postage 300.00 0.00 0.48 0.16 299.52 101-4-1110-4331 Travel, Conferences & Schools 3,100.00 0.00 679.45 21.92 2,420.55 101-4-1110-4359 Publishing 3,700.00 80.00 1,319.72 35.67 2,380.28 101-4-1110-4361 Insurance 33,650.00 0.00 16,504.50 49.05 17,145.5C 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 151.40 5,935.05 21.82 21,264.95 TOTAL Other Services & Charges 96,400.00 231.40 28,228.81 29.28 68,171.19 Capital Outlay TOTAL Mayor & Council 141,050.00 3,689.70 42,087.31 29.84 98,962.69 Cable TV Personal Services 101-4-1120-4101 Regular Pay 62,150.00 4,779.20 18,399.93 29.61 43,750.07 101-4-1120-4103 Part-time Pay 17,600.00 757.68 2,921.14 16.60 14,678.86 101-4-1120-4104 PERA 6,000.00 358.44 1,609.44 26.82 4,390.56 101-4-1120-4105 FICA 4,950.00 292.28 1,325.82 26.78 3,624.18 101-4-1120-4107 Medicare 1,150.00 68.35 310.04 26.96 839.96 101-4-1120-4108 Insurance 13,900.00 1,102.01 4,408.04 31.71 9,491.96 101-4-1120-4109 Workers Comp 350.00 0.00 174.00 49.71 176.00 TOTAL Personal Services 106,100.00 7,357.96 29,148.41 27.47 76,951.59 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND General Government 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-1120-4201 Office Supplies 750.00 139.53 148.52 19.8C 601.48 TOTAL Supplies 750.00 139.53 148.52 19.80 601.48 Other Services & Charges 101-4-1120-4322 Postage 50.00 0.00 0.00 0.00 50.00 101-4-1120-4331 Travel, Conferences & Schools 1,350.00 0.00 38.90 2.88 1,311.1C 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 38.90 2.51 1,511.1C Capital Outlay TOTAL Cable TV 108,400.00 7,497.49 29,335.83 27.06 79,064.17 Administrative Services Personal Services 101-4-1210-4101 Regular Pay 381,100.00 29,316.28 112,867.59 29.62 268,232.41 101-4-1210-4103 Part-time Pay 43,000.00 2,930.40 11,593.73 26.96 31,406.27 101-4-1210-4104 PERA 31,800.00 2,418.50 10,909.42 34.31 20,890.58 101-4-1210-4105 FICA 26,300.00 1,947.78 8,812.27 33.51 17,487.73 101-4-1210-4107 Medicare 6,150.00 455.52 2,060.92 33.51 4,089.08 101-4-1210-4108 Insurance 38,450.00 2,860.01 11,995.24 31.20 26,454.76 101-4-1210-4109 Workers Comp 2,000.00 0.00 901.50 45.08 1,098.5C TOTAL Personal Services 528,800.00 39,928.49 159,140.67 30.09 369,659.33 Supplies 101-4-1210-4201 Office Supplies 13,000.00 234.96 5,190.85 39.93 7,809.15 TOTAL Supplies 13,000.00 234.96 5,190.85 39.93 7,809.1E Other Services & Charges 101-4-1210-4319 Other Professional Services 11,100.00 30.00 998.00 8.99 10,102.00 101-4-1210-4321 Telephone 1,100.00 173.98 346.48 31.50 753.52 101-4-1210-4322 Postage 800.00 0.00 469.73 58.72 330.27 101-4-1210-4331 Travel, Conferences & Schools 10,250.00 620.03 3,878.57 37.84 6,371.43 101-4-1210-4334 Car Allowance 4,800.00 400.00 1,600.00 33.33 3,200.00 101-4-1210-4359 Publishing 12,000.00 3,181.00 6,367.00 53.06 5,633.00 101-4-1210-4361 Insurance 100.00 0.00 53.00 53.00 47.00 101-4-1210-4404 Equip Repair/Maint Services 16,050.00 459.63 1,656.96 10.32 14,393.04 101-4-1210-4433 Dues & Subscriptions 2,000.00 11.96 325.88 16.29 1,674.12 TOTAL Other Services & Charges 58,200.00 4,876.60 15,695.62 26.97 42,504.38 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND General Government 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Administrative Services 600,000.00 45,040.05 180,027.14 30.00 419,972.86 Human Resources Personal Services 101-4-1220-4101 Regular Pay 116,300.00 8,846.26 28,144.02 24.20 88,155.98 101-4-1220-4104 PERA 8,700.00 663.46 2,382.02 27.38 6,317.98 101-4-1220-4105 FICA 7,200.00 553.57 1,951.92 27.11 5,248.08 101-4-1220-4107 Medicare 1,700.00 129.45 456.46 26.85 1,243.54 101-4-1220-4108 Insurance 17,400.00 889.01 2,956.02 16.99 14,443.98 101-4-1220-4109 Workers Comp 350.00 0.00 252.50 72.14 97.5C TOTAL Personal Services 151,650.00 11,081.75 36,142.94 23.83 115,507.06 Supplies 101-4-1220-4201 Office Supplies 4,650.00 1,977.82 3,323.53 71.47 1,326.47 TOTAL Supplies 4,650.00 1,977.82 3,323.53 71.47 1,326.47 Other Services & Charges 101-4-1220-4319 Other Professional Services 1,000.00 128.85 171.80 17.18 828.2C 101-4-1220-4322 Postage 500.00 0.00 183.29 36.66 316.71 101-4-1220-4331 Travel, Conferences & Schools 3,200.00 171.62 258.49 8.08 2,941.51 101-4-1220-4433 Dues & Subscriptions 750.00 0.00 0.00 O.00 750.00 TOTAL Other Services & Charges 5,450.00 300.47 613.58 11.26 4,836.42 Capital Outlay TOTAL Human Resources 161,750.00 13,360.04 40,080.05 24.78 121,669.9E Elections 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 3.37 1.12 296.63 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 8,800.00 99.44 50.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 8,803.37 81.51 1,996.63 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND General Government 33.33° 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 0.00 8,803.37 65.94 4,546.63 Finance Personal Services 101-4-1310-4101 Regular Pay 311,550.00 23,964.04 92,261.56 29.61 219,288.44 101-4-1310-4103 Part-time Pay 52,350.00 3,823.36 16,010.32 30.58 36,339.68 101-4-1310-4104 PERA 27,300.00 2,084.08 9,465.41 34.67 17,834.59 101-4-1310-4105 FICA 22,550.00 1,653.82 7,532.35 33.40 15,017.6E 101-4-1310-4107 Medicare 5,300.00 386.78 1,761.59 33.24 3,538.41 101-4-1310-4108 Insurance 33,550.00 3,054.23 12,216.92 36.41 21,333.08 101-4-1310-4109 Workers Comp 1,700.00 0.00 764.50 44.97 935.5C TOTAL Personal Services 454,300.00 34,966.31 140,012.65 30.82 314,287.3E Supplies 101-4-1310-4201 Office Supplies 4,650.00 332.85 1,125.34 24.2C 3,524.66 TOTAL Supplies 4,650.00 332.85 1,125.34 24.20 3,524.66 Other Services & Charges 101-4-1310-4301 Audit Fees 19,000.00 13,830.00 16,230.00 85.42 2,770.00 101-4-1310-4319 Other Professional Services 54,000.00 52,864.00 52,864.00 97.90 1,136.00 101-4-1310-4321 Telephone 500.00 30.28 101.08 20.22 398.92 101-4-1310-4322 Postage 2,500.00 0.00 1,226.21 49.05 1,273.79 101-4-1310-4331 Travel, Conferences & Schools 2,500.00 71.26 421.26 16.85 2,078.74 101-4-1310-4359 Publishing 1,050.00 0.00 240.00 22.86 810.00 101-4-1310-4404 Equip Repair/Maint Services 21,500.00 675.00 20,473.10 95.22 1,026.9C 101-4-1310-4433 Dues & Subscriptions 1,600.00 225.00 405.00 25.31 1,195.00 101-4-1310-4438 Credit Card Fees 4,500.00 282.99 914.28 20.32 3,585.72 101-4-1310-4440 Miscellaneous 1,350.00 80.10 326.35 24.17 1,023.65 TOTAL Other Services & Charges 108,500.00 68,058.63 93,201.28 85.90 15,298.72 Capital Outlay TOTAL Finance 567,450.00 103,357.79 234,339.27 41.30 333,110.73 Information Technology Personal Services 101-4-1350-4101 Regular Pay 182,150.00 13,903.60 53,528.86 29.39 128,621.14 101-4-1350-4104 PERA 13,650.00 1,042.78 4,682.24 34.30 8,967.76 101-4-1350-4105 FICA 11,300.00 801.42 3,602.73 31.88 7,697.27 101-4-1350-4107 Medicare 2,650.00 187.42 842.55 31.79 1,807.4E 101-4-1350-4108 Insurance 31,300.00 2,565.03 10,260.12 32.78 21,039.88 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND General Government 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-1350-4109 Workers Comp 850.00 0.00 383.00 45.06 467.00 TOTAL Personal Services 241,900.00 18,500.25 73,299.50 30.30 168,600.5C Supplies 101-4-1350-4219 Operating Supplies 12,500.00 1,071.86 4,311.94 34.5C 8,188.06 TOTAL Supplies 12,500.00 1,071.86 4,311.94 34.50 8,188.06 Other Services & Charges 101-4-1350-4319 Other Professional Services 5,000.00 370.00 1,267.50 25.35 3,732.5C 101-4-1350-4321 Telephone 2,500.00 227.68 520.55 20.82 1,979.4E 101-4-1350-4331 Travel, Conferences & Schools 10,950.00 4,920.01 5,583.32 50.99 5,366.68 101-4-1350-4404 Equip Repair/Maint Services 59,300.00 7,228.60 34,204.88 57.68 25,095.12 TOTAL Other Services & Charges 77,750.00 12,746.29 41,576.25 53.47 36,173.7E Capital Outlay TOTAL Information Technology 332,150.00 32,318.40 119,187.69 35.88 212,962.31 Legal Personal Services Supplies Other Services & Charges 101-4-1400-4304 Legal Fees 217,600.00 16,400.00 50,902.02 23.39 166,697.98 TOTAL Other Services & Charges 217,600.00 16,400.00 50,902.02 23.39 166,697.98 TOTAL Legal 217,600.00 16,400.00 50,902.02 23.39 166,697.98 Community Development Personal Services 101-4-1500-4101 Regular Pay 268,300.00 20,639.12 79,460.61 29.62 188,839.39 101-4-1500-4104 PERA 20,100.00 1,547.94 6,950.54 34.58 13,149.46 101-4-1500-4105 FICA 16,650.00 1,244.26 5,604.28 33.66 11,045.72 101-4-1500-4107 Medicare 3,900.00 290.98 1,310.63 33.61 2,589.37 101-4-1500-4108 Insurance 21,000.00 2,025.02 8,100.08 38.57 12,899.92 101-4-1500-4109 Workers Comp 1,250.00 0.00 564.00 45.12 686.00 TOTAL Personal Services 331,200.00 25,747.32 101,990.14 30.79 229,209.86 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: It REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND General Government 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-1500-4201 Office Supplies 1,200.00 200.13 686.75 57.23 513.25 TOTAL Supplies 1,200.00 200.13 686.75 57.23 513.2E Other Services & Charges 101-4-1500-4321 Telephone 1,400.00 65.55 197.41 14.10 1,202.59 101-4-1500-4331 Travel, Conferences & Schools 4,200.00 0.00 488.74 11.64 3,711.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 65.55 925.15 12.85 6,274.8E TOTAL Community Development 339,600.00 26,013.00 103,602.04 30.51 235,997.96 Planning Personal Services 101-4-1510-4101 Regular Pay 129,750.00 9,890.76 38,079.43 29.35 91,670.57 101-4-1510-4104 PERA 9,750.00 741.80 3,330.83 34.16 6,419.17 101-4-1510-4105 FICA 8,050.00 490.08 2,260.93 28.09 5,789.07 101-4-1510-4107 Medicare 1,900.00 114.62 528.78 27.83 1,371.22 101-4-1510-4108 Insurance 27,800.00 2,258.00 9,032.00 32.49 18,768.00 101-4-1510-4109 Workers Comp 650.00 0.00 314.00 48.31 336.00 TOTAL Personal Services 177,900.00 13,495.26 53,545.97 30.10 124,354.03 Supplies 101-4-1510-4201 Office Supplies 1,700.00 42.31 227.80 13.40 1,472.2C 101-4-1510-4212 Fuels & Lubes 300.00 2.67 2.67 0.89 297.33 101-4-1510-4219 Operating Supplies 1,350.00 175.45 175.45 13.00 1,174.55 TOTAL Supplies 3,350.00 220.43 405.92 12.12 2,944.08 Other Services & Charges 101-4-1510-4321 Telephone 50.00 26.20 82.98 165.96 ( 32.98) 101-4-1510-4322 Postage 2,500.00 0.00 171.81 6.87 2,328.19 101-4-1510-4331 Travel, Conferences & Schools 1,500.00 0.00 169.00 11.27 1,331.00 101-4-1510-4359 Publishing 8,000.00 592.00 1,792.00 22.40 6,208.00 101-4-1510-4361 Insurance 100.00 0.00 52.50 52.50 47.5C 101-4-1510-4404 Equip Repair/Maint Services 1,500.00 0.00 900.00 60.00 600.00 101-4-1510-4433 Dues & Subscriptions 400.00 0.00 318.00 79.50 82.00 101-4-1510-4440 Miscellaneous 250.00 0.00 46.00 18.4C 204.00 TOTAL Other Services & Charges 14,300.00 618.20 3,532.29 24.70 10,767.71 Capital Outlay TOTAL Planning 195,550.00 14,333.89 57,484.18 29.40 138,065.82 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND General Government 33.33° 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 337,550.00 25,574.27 98,460.91 29.17 239,089.09 101-4-1600-4102 Overtime Pay 3,500.00 266.02 594.68 16.99 2,905.32 101-4-1600-4103 Part-time Pay 3,400.00 0.00 0.00 0.00 3,400.00 101-4-1600-4104 PERA 25,600.00 1,938.01 8,662.72 33.84 16,937.28 101-4-1600-4105 FICA 21,350.00 1,628.46 7,297.76 34.18 14,052.24 101-4-1600-4107 Medicare 5,000.00 380.85 1,706.72 34.13 3,293.28 101-4-1600-4108 Insurance 42,350.00 3,202.03 12,808.12 30.24 29,541.88 101-4-1600-4109 Workers Comp 11,350.00 0.00 5,369.50 47.31 5,980.5C TOTAL Personal Services 450,100.00 32,989.64 134,900.41 29.97 315,199.59 Supplies 101-4-1600-4212 Fuels & Lubes 4,000.00 349.87 970.69 24.27 3,029.31 101-4-1600-4217 Uniform Allowance 2,400.00 0.00 479.86 19.99 1,920.14 101-4-1600-4219 Operating Supplies 32,350.00 3,491.90 12,848.82 39.72 19,501.18 TOTAL Supplies 38,750.00 3,841.77 14,299.37 36.90 24,450.63 Other Services & Charges 101-4-1600-4321 Telephone 11,500.00 244.40 2,994.22 26.04 8,505.78 101-4-1600-4331 Travel, Conferences & Schools 1,200.00 325.00 455.00 37.92 745.00 101-4-1600-4361 Insurance 5,550.00 0.00 2,724.00 49.08 2,826.00 101-4-1600-4389 Utilities 31,450.00 4,010.56 11,680.91 37.14 19,769.09 101-4-1600-4401 Bldg Repair/Maint Services 25,700.00 7,470.90 10,182.06 39.62 15,517.94 101-4-1600-4404 Equip Repair/Maint Services 3,500.00 586.95 2,746.95 78.48 753.05 101-4-1600-4460 Equip Replacement Charge 1,450.00 120.83 483.32 33.33 966.68 TOTAL Other Services & Charges 80,350.00 12,758.64 31,266.46 38.91 49,083.54 Capital Outlay TOTAL City Hall Maintenance 569,200.00 49,590.05 180,466.24 31.71 388,733.76 Contingency Personal Services 101-4-1900-4101 Regular Pay 95,000.00) 0.00 0.00 O.00 ( 95,000.00) TOTAL Personal Services 95,000.00) 0.00 0.00 0.00 ( 95,000.00) Other Services & Charges TOTAL Contingency 95,000.00) 0.00 0.00 0.00 ( 95,000.00) TOTAL General Government 3,151,100.00 311,600.41 1,046,315.14 33.20 2,104,784.86 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Public Safety 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Police Administration Personal Services 101-4-2110-4101 Regular Pay 358,000.00 26,339.54 85,566.38 23.90 272,433.62 101-4-2110-4104 PERA 52,800.00 3,942.52 15,114.73 28.63 37,685.27 101-4-2110-4105 FICA 3,700.00 191.88 880.85 23.81 2,819.1E 101-4-2110-4107 Medicare 3,600.00 359.46 1,352.92 37.58 2,247.08 101-4-2110-4108 Insurance 38,450.00 2,838.03 9,004.24 23.42 29,445.76 101-4-2110-4109 Workers Comp 59,100.00 0.00 28,139.50 47.61 30,960.5C TOTAL Personal Services 515,650.00 33,671.43 140,058.62 27.16 375,591.38 Supplies 101-4-2110-4201 Office Supplies 10,350.00 377.98 2,599.17 25.11 7,750.83 101-4-2110-4217 Uniform Allowance 2,900.00 0.00 1,205.78 41.58 1,694.22 101-4-2110-4219 Operating Supplies 5,350.00 1,869.69 2,454.79 45.88 2,895.21 TOTAL Supplies 18,600.00 2,247.67 6,259.74 33.65 12,340.26 Other Services & Charges 101-4-2110-4319 Other Professional Services 5,900.00 1,299.43 1,303.67 22.10 4,596.33 101-4-2110-4321 Telephone 22,950.00 2,024.27 6,491.70 28.29 16,458.3C 101-4-2110-4322 Postage 3,150.00 0.00 461.73 14.66 2,688.27 101-4-2110-4331 Travel, Conferences & Schools 6,800.00 650.00 1,285.00 18.90 5,515.00 101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2110-4361 Insurance 43,100.00 0.00 21,118.00 49.00 21,982.00 101-4-2110-4404 Equip Repair/Maint Services 71,300.00 3,122.46 41,432.60 58.11 29,867.46 101-4-2110-4433 Dues & Subscriptions 4,900.00 1,720.00 2,976.00 60.73 1,924.00 101-4-2110-4437 Taxes & Licenses 300.00 0.00 132.00 44.00 168.00 TOTAL Other Services & Charges 158,900.00 8,816.16 75,200.70 47.33 83,699.3C Capital Outlay TOTAL Police Administration 693,150.00 44,735.26 221,519.06 31.96 471,630.94 Patrol Personal Services 101-4-2120-4101 Regular Pay 1,598,350.00 111,109.46 430,981.72 26.96 1,167,368.28 101-4-2120-4102 Overtime Pay 90,000.00 5,042.28 15,246.09 16.94 74,753.91 101-4-2120-4104 PERA 273,500.00 18,816.57 84,810.27 31.01 188,689.73 101-4-2120-4107 Medicare 23,200.00 1,519.70 6,830.66 29.44 16,369.34 101-4-2120-4108 Insurance 195,200.00 13,417.11 56,016.32 28.7C 139,183.68 TOTAL Personal Services 2,180,250.00 149,905.12 593,885.06 27.24 1,586,364.94 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Public Safety 33.33° 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 100,000.00 6,938.93 32,785.22 32.79 67,214.78 101-4-2120-4217 Uniform Allowance 25,400.00 0.00 939.01 3.70 24,460.99 101-4-2120-4219 Operating Supplies 67,500.00 3,569.32 14,771.99 21.88 52,728.01 101-4-2120-4221 Equipment Parts 23,300.00 2,293.49 3,491.62 14.99 19,808.38 TOTAL Supplies 216,200.00 12,801.74 51,987.84 24.05 164,212.16 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 26,950.00 2,350.00 5,635.00 20.91 21,315.00 101-4-2120-4404 Equip Repair/Maint Services 25,700.00 806.44 2,639.74 10.27 23,060.26 101-4-2120-4433 Dues & Subscriptions 650.00 0.00 200.00 30.77 450.00 101-4-2120-4460 Equip Replacement Charge 43,550.00 3,629.17 14,516.68 33.33 29,033.32 TOTAL Other Services & Charges 96,850.00 6,785.61 22,991.42 23.74 73,858.58 Capital Outlay TOTAL Patrol 2,493,300.00 169,492.47 668,864.32 26.83 1,824,435.68 Investigations Personal Services 101-4-2130-4101 Regular Pay 654,450.00 40,744.01 156,780.26 23.96 497,669.74 101-4-2130-4102 Overtime Pay 50,000.00 1,841.29 5,601.79 11.20 44,398.21 101-4-2130-4104 PERA 114,100.00 6,898.83 30,626.93 26.84 83,473.07 101-4-2130-4107 Medicare 8,900.00 464.44 2,080.15 23.37 6,819.85 101-4-2130-4108 Insurance 88,950.00 6,470.25 25,881.00 29.1C 63,069.00 TOTAL Personal Services 916,400.00 56,418.82 220,970.13 24.11 695,429.87 Supplies 101-4-2130-4217 Uniform Allowance 6,600.00 412.50 412.50 6.25 6,187.5C 101-4-2130-4219 Operating Supplies 12,200.00 111.94 2,378.59 19.5C 9,821.41 TOTAL Supplies 18,800.00 524.44 2,791.09 14.85 16,008.91 Other Services & Charges 101-4-2130-4319 Other Professional Services 6,500.00 0.00 407.00 6.26 6,093.00 101-4-2130-4331 Travel, Conferences & Schools 6,350.00 915.50 1,690.50 26.62 4,659.5C 101-4-2130-4433 Dues & Subscriptions 2,050.00 0.00 0.00 0.00 2,050.00 101-4-2130-4460 Equip Replacement Charge 12,950.00 1,079.17 4,316.68 33.33 8,633.32 TOTAL Other Services & Charges 27,850.00 1,994.67 6,414.18 23.03 21,435.82 Capital Outlay TOTAL Investigations 963,050.00 58,937.93 230,175.40 23.90 732,874.6C 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Public Safety 33.33° 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 380,550.00 25,657.52 111,313.53 29.25 269,236.47 101-4-2150-4102 Overtime Pay 10,000.00 61.05 1,575.88 15.76 8,424.12 101-4-2150-4104 PERA 29,300.00 1,670.90 9,100.03 31.06 20,199.97 101-4-2150-4105 FICA 24,200.00 1,560.96 7,805.73 32.26 16,394.27 101-4-2150-4107 Medicare 5,650.00 365.08 1,825.59 32.31 3,824.41 101-4-2150-4108 Insurance 59,750.00 3,727.06 18,369.29 30.74 41,380.71 TOTAL Personal Services 509,450.00 33,042.57 149,990.05 29.44 359,459.9E Supplies 101-4-2150-4201 Office Supplies 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2150-4217 Uniform Allowance 3,850.00 0.00 133.60 3.47 3,716.4C 101-4-2150-4219 Operating Supplies 11,450.00 ( 235.23) 975.25 8.52 10,474.75 TOTAL Supplies 16,300.00 ( 235.23) 1,108.85 6.80 15,191.1E Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 3,700.00 255.00 703.00 19.00 2,997.00 101-4-2150-4404 Equip Repair/Maint Services 2,200.00 0.00 0.00 0.00 2,200.00 101-4-2150-4409 Contractual Services 16,900.00 70.00 696.00 4.12 16,204.00 101-4-2150-4433 Dues & Subscriptions 550.00 0.00 220.00 40.00 330.00 101-4-2150-4460 Equip Replacement Charge 6,650.00 554.17 2,216.68 33.33 4,433.32 TOTAL Other Services & Charges 30,000.00 879.17 3,835.68 12.79 26,164.32 Capital Outlay TOTAL Police Support Services 555,750.00 33,686.51 154,934.58 27.88 400,815.42 Police Reserves Personal Services 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 65.80 550.80 10.01 4,949.2C 101-4-2160-4219 Operating Supplies 4,000.00 0.00 0.00 O.00 4,000.00 TOTAL Supplies 9,500.00 65.80 550.80 5.80 8,949.2C 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 1F REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Public Safety 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 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 850.00 850.00 26.56 2,350.00 TOTAL Other Services & Charges 5,350.00 850.00 850.00 15.89 4,500.00 Capital Outlay TOTAL Police Reserves 20,800.00 915.80 1,400.80 6.73 19,399.2C Public safety building Personal Services Supplies 101-4-2190-4219 Operating Supplies 15,200.00 531.70 6,555.02 43.13 8,644.98 TOTAL Supplies 15,200.00 531.70 6,555.02 43.13 8,644.98 Other Services & Charges 101-4-2190-4361 Insurance 5,300.00 0.00 2,641.50 49.84 2,658.5C 101-4-2190-4389 Utilities 18,000.00 2,221.30 7,262.59 40.35 10,737.41 101-4-2190-4401 Bldg Repair/Maint Services 38,650.00 1,282.64 2,405.33 6.22 36,244.67 TOTAL Other Services & Charges 61,950.00 3,503.94 12,309.42 19.87 49,640.58 Capital Outlay TOTAL Public safety building 77,150.00 4,035.64 18,864.44 24.45 58,285.56 Fire Administration Personal Services 101-4-2310-4101 Regular Pay 187,400.00 14,281.54 54,983.93 29.34 132,416.07 101-4-2310-4103 Part-time Pay 28,100.00 0.00 3,854.95 13.72 24,245.05 101-4-2310-4104 PERA 32,450.00 2,313.60 10,777.60 33.21 21,672.4C 101-4-2310-4105 FICA 1,750.00 0.00 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 193.82 952.02 30.71 2,147.98 101-4-2310-4108 Insurance 17,400.00 1,846.01 7,320.04 42.07 10,079.96 101-4-2310-4109 Workers Comp 7,850.00 0.00 4,001.50 50.97 3,848.5C TOTAL Personal Services 308,050.00 18,634.97 82,211.67 26.69 225,838.33 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Public Safety 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2310-4201 Office Supplies 3,150.00 503.18 1,395.07 44.29 1,754.93 101-4-2310-4212 Fuels & Lubes 4,000.00 293.56 1,732.12 43.30 2,267.88 101-4-2310-4217 Uniform Allowance 1,500.00 399.18 869.42 57.96 630.58 101-4-2310-4221 Equipment Parts 450.00 0.00 0.00 O.00 450.00 TOTAL Supplies 9,100.00 1,195.92 3,996.61 43.92 5,103.39 Other Services & Charges 101-4-2310-4319 Other Professional Services 5,000.00 2,300.00 2,300.00 46.00 2,700.00 101-4-2310-4321 Telephone 3,750.00 247.17 949.08 25.31 2,800.92 101-4-2310-4322 Postage 500.00 0.00 174.12 34.82 325.88 101-4-2310-4331 Travel, Conferences & Schools 6,000.00 1,710.54 1,800.54 30.01 4,199.46 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 5,522.00 49.30 5,678.00 101-4-2310-4389 Utilities 12,000.00 1,823.55 5,286.45 44.05 6,713.5E 101-4-2310-4401 Bldg Repair/Maint Services 7,000.00 0.00 155.00 2.21 6,845.00 101-4-2310-4404 Equip Repair/Maint Services 3,950.00 0.00 1,035.00 26.20 2,915.00 101-4-2310-4433 Dues & Subscriptions 2,000.00 0.00 1,334.00 66.70 666.00 101-4-2310-4460 Equip Replacement Charge 38,550.00 3,212.50 12,850.00 33.33 25,700.00 TOTAL Other Services & Charges 90,450.00 9,293.76 31,406.19 34.72 59,043.81 Capital Outlay TOTAL Fire Administration 407,600.00 29,124.65 117,614.47 28.86 289,985.53 Fire Operations Personal Services 101-4-2320-4103 Part-time Pay 169,700.00 16,704.86 48,254.13 28.43 121,445.87 101-4-2320-4105 FICA 10,500.00 933.57 3,036.03 28.91 7,463.97 101-4-2320-4107 Medicare 2,450.00 218.37 710.14 28.99 1,739.86 101-4-2320-4109 Workers Comp 27,400.00 0.00 12,727.50 46.45 14,672.5C TOTAL Personal Services 210,050.00 17,856.80 64,727.80 30.82 145,322.2C Supplies 101-4-2320-4201 Office Supplies 1,200.00 0.00 99.05 8.25 1,100.9E 101-4-2320-4212 Fuels & Lubes 7,000.00 725.04 3,409.69 48.71 3,590.31 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 2,828.73 8,771.29 11.03 70,728.71 101-4-2320-4221 Equipment Parts 7,250.00 44.67 251.16 3.46 6,998.84 TOTAL Supplies 104,100.00 3,598.44 12,531.19 12.04 91,568.81 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Public Safety 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2320-4321 Telephone 2,950.00 160.47 610.90 20.71 2,339.1C 101-4-2320-4331 Travel, Conferences & Schools 26,000.00 2,864.16 6,445.24 24.79 19,554.76 101-4-2320-4404 Equip Repair/Maint Services 36,600.00 661.95 1,429.85 3.91 35,170.1E 101-4-2320-4409 Contractual Services 8,650.00 3,737.88 7,231.38 83.6C 1,418.62 TOTAL Other Services & Charges 74,200.00 7,424.46 15,717.37 21.18 58,482.63 Capital Outlay TOTAL Fire Operations 388,350.00 28,879.70 92,976.36 23.94 295,373.64 Emergency Management Personal Services Supplies 101-4-2330-4201 Office Supplies 800.00 0.00 0.00 0.00 800.00 101-4-2330-4219 Operating Supplies 10,600.00 857.47 1,504.52 14.19 9,095.48 TOTAL Supplies 11,400.00 857.47 1,504.52 13.20 9,895.48 Other Services & Charges 101-4-2330-4321 Telephone 250.00 26.00 78.00 31.20 172.00 101-4-2330-4331 Travel, Conferences & Schools 5,400.00 0.00 0.00 0.00 5,400.00 101-4-2330-4389 Utilities 700.00 62.50 187.50 26.79 512.5C 101-4-2330-4404 Equip Repair/Maint Services 3,450.00 462.94 462.94 13.42 2,987.06 101-4-2330-4433 Dues & Subscriptions 200.00 0.00 285.00 142.5C ( 85.00) TOTAL Other Services & Charges 10,000.00 551.44 1,013.44 10.13 8,986.56 Capital Outlay TOTAL Emergency Management 21,400.00 1,408.91 2,517.96 11.77 18,882.04 Building Safety Personal Services 101-4-2410-4101 Regular Pay 448,500.00 34,401.72 132,446.59 29.53 316,053.41 101-4-2410-4104 PERA 40,050.00 3,071.64 13,792.35 34.44 26,257.6E 101-4-2410-4105 FICA 23,250.00 1,649.38 7,469.51 32.13 15,780.49 101-4-2410-4107 Medicare 6,500.00 462.79 2,095.26 32.23 4,404.74 101-4-2410-4108 Insurance 59,150.00 5,923.04 23,692.16 40.05 35,457.84 101-4-2410-4109 Workers Comp 2,100.00 0.00 973.00 46.33 1,127.00 TOTAL Personal Services 579,550.00 45,508.57 180,468.87 31.14 399,081.13 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Public Safety 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2410-4201 Office Supplies 8,000.00 166.31 498.32 6.23 7,501.68 101-4-2410-4212 Fuels & Lubes 8,000.00 495.62 2,727.82 34.10 5,272.18 101-4-2410-4217 Uniform Allowance 2,000.00 247.75 257.75 12.89 1,742.25 101-4-2410-4219 Operating Supplies 10,150.00 0.00 646.01 6.36 9,503.99 TOTAL Supplies 28,150.00 909.68 4,129.90 14.67 24,020.1C Other Services & Charges 101-4-2410-4321 Telephone 5,100.00 338.92 1,035.70 20.31 4,064.3C 101-4-2410-4322 Postage 600.00 0.00 210.37 35.06 389.63 101-4-2410-4331 Travel, Conferences & Schools 3,500.00 340.00 2,206.30 63.04 1,293.7C 101-4-2410-4361 Insurance 500.00 0.00 232.50 46.50 267.5C 101-4-2410-4404 Equip Repair/Maint Services 5,000.00 0.00 2,090.00 41.80 2,910.00 101-4-2410-4433 Dues & Subscriptions 3,650.00 0.00 1,355.50 37.14 2,294.5C 101-4-2410-4460 Equip Replacement Charge 2,900.00 241.67 966.68 33.33 1,933.32 TOTAL Other Services & Charges 21,250.00 920.59 8,097.05 38.10 13,152.95 Capital Outlay TOTAL Building Safety 628,950.00 47,338.84 192,695.82 30.64 436,254.18 Code Enforcement Personal Services 101-4-2420-4101 Regular Pay 68,900.00 5,300.80 20,408.08 29.62 48,491.92 101-4-2420-4104 PERA 5,150.00 397.56 1,785.12 34.66 3,364.88 101-4-2420-4105 FICA 4,250.00 340.85 1,524.50 35.87 2,725.5C 101-4-2420-4107 Medicare 1,000.00 79.72 356.55 35.66 643.45 101-4-2420-4108 Insurance 3,600.00 300.01 1,200.04 33.33 2,399.96 101-4-2420-4109 Workers Comp 350.00 0.00 151.00 43.14 199.00 TOTAL Personal Services 83,250.00 6,418.94 25,425.29 30.54 57,824.71 Supplies 101-4-2420-4212 Fuels & Lubes 2,000.00 171.22 503.83 25.19 1,496.17 101-4-2420-4219 Operating Supplies 700.00 0.00 0.00 O.00 700.00 TOTAL Supplies 2,700.00 171.22 503.83 18.66 2,196.17 Other Services & Charges 101-4-2420-4321 Telephone 800.00 82.47 250.27 31.28 549.73 101-4-2420-4322 Postage 800.00 0.00 160.37 20.05 639.63 101-4-2420-4331 Travel, Conferences & Schools 700.00 0.00 140.00 20.00 560.00 101-4-2420-4361 Insurance 100.00 0.00 58.00 58.00 42.00 101-4-2420-4460 Equip Replacement Charge 950.00 79.17 316.68 33.33 633.32 TOTAL Other Services & Charges 3,350.00 161.64 925.32 27.62 2,424.68 TOTAL Code Enforcement 89,300.00 6,751.80 26,854.44 30.07 62,445.56 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Public Safety 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Environmental Personal Services 101-4-2440-4101 Regular Pay 21,400.00 1,611.70 6,205.04 29.00 15,194.96 101-4-2440-4104 PERA 1,600.00 120.88 542.77 33.92 1,057.23 101-4-2440-4105 FICA 1,350.00 99.92 448.66 33.23 901.34 101-4-2440-4107 Medicare 300.00 23.38 104.98 34.99 195.02 101-4-2440-4108 Insurance 1,400.00 307.18 1,228.72 87.77 171.28 101-4-2440-4109 Workers Comp 300.00 0.00 127.00 42.33 173.00 TOTAL Personal Services 26,350.00 2,163.06 8,657.17 32.85 17,692.83 Supplies 101-4-2440-4201 Office Supplies 900.00 3.53 24.40 2.71 875.6C 101-4-2440-4212 Fuels & Lubes 200.00 8.08 8.08 4.04 191.92 101-4-2440-4217 Uniform Allowance 100.00 0.00 0.00 O.00 100.00 TOTAL Supplies 1,200.00 11.61 32.48 2.71 1,167.52 Other Services & Charges 101-4-2440-4321 Telephone 350.00 0.00 1.64 0.47 348.36 101-4-2440-4322 Postage 700.00 0.00 46.27 6.61 653.73 101-4-2440-4331 Travel, Conferences & Schools 850.00 15.51 83.89 9.87 766.11 101-4-2440-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2440-4433 Dues & Subscriptions 200.00 0.00 30.00 15.00 170.00 TOTAL Other Services & Charges 2,600.00 15.51 161.80 6.22 2,438.2C TOTAL Environmental 30,150.00 2,190.18 8,851.45 29.36 21,298.5E TOTAL Public Safety 6,368,950.00 427,497.69 1,737,269.10 27.28 4,631,680.9C Street Maintenance Personal Services 101-4-3120-4101 Regular Pay 478,400.00 45,801.20 121,413.60 25.38 356,986.4C 101-4-3120-4102 Overtime Pay 4,000.00 660.09 688.88 17.22 3,311.12 101-4-3120-4103 Part-time Pay 72,700.00 4,863.78 22,333.76 30.72 50,366.24 101-4-3120-4104 PERA 40,000.00 3,741.09 11,340.50 28.35 28,659.5C 101-4-3120-4105 FICA 34,400.00 3,027.74 9,669.59 28.11 24,730.41 101-4-3120-4107 Medicare 8,050.00 708.04 2,261.37 28.09 5,788.63 101-4-3120-4108 Insurance 67,100.00 7,161.96 17,788.97 26.51 49,311.03 101-4-3120-4109 Workers Comp 28,100.00 0.00 13,258.00 47.18 14,842.00 TOTAL Personal Services 732,750.00 65,963.90 198,754.67 27.12 533,995.33 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 2C REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Public Works 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-3120-4201 Office Supplies 2,850.00 3.53 87.65 3.08 2,762.3H 101-4-3120-4212 Fuels & Lubes 75,000.00 ( 395.02) 22,067.89 29.42 52,932.11 101-4-3120-4219 Operating Supplies 39,500.00 7,610.40 18,720.07 47.39 20,779.93 101-4-3120-4221 Equipment Parts 54,800.00 5,898.83 20,153.74 36.78 34,646.26 101-4-3120-4226 Street Signs 24,000.00 7,343.22 7,743.71 32.27 16,256.29 TOTAL Supplies 196,150.00 20,460.96 68,773.06 35.06 127,376.94 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 653.16 2,225.28 36.48 3,874.72 101-4-3120-4322 Postage 100.00 22.39 29.17 29.17 70.83 101-4-3120-4331 Travel, Conferences & Schools 3,500.00 0.00 520.00 14.86 2,980.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 9,780.00 49.27 10,070.00 101-4-3120-4389 Utilities 54,000.00 5,372.80 22,021.04 40.78 31,978.96 101-4-3120-4401 Bldg Repair/Maint Services 14,500.00 3,083.41 3,615.12 24.93 10,884.88 101-4-3120-4404 Equip Repair/Maint Services 9,000.00 2,744.19 6,106.30 67.85 2,893.7C 101-4-3120-4409 Contractual Services 49,000.00 418.54 948.32 1.94 48,051.68 101-4-3120-4415 Equipment Rental 3,000.00 76.30 76.30 2.54 2,923.7C 101-4-3120-4417 Uniform Rental 5,800.00 699.69 1,812.31 31.25 3,987.69 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 30.00 20.00 120.00 101-4-3120-4460 Equip Replacement Charge 92,300.00 7,691.67 30,766.68 33.33 61,533.32 TOTAL Other Services & Charges 258,400.00 20,762.15 78,204.27 30.26 180,195.73 Capital Outlay TOTAL Street Maintenance 1,187,300.00 107,187.01 345,732.00 29.12 841,568.00 Snow Removal Personal Services 101-4-3130-4101 Regular Pay 133,550.00 619.72 60,055.16 44.97 73,494.84 101-4-3130-4102 Overtime Pay 20,000.00 0.00 4,665.46 23.33 15,334.54 101-4-3130-4104 PERA 11,050.00 46.48 6,228.59 56.37 4,821.41 101-4-3130-4105 FICA 9,500.00 36.13 4,985.89 52.48 4,514.11 101-4-3130-4107 Medicare 2,250.00 8.46 1,166.11 51.83 1,083.89 101-4-3130-4108 Insurance 17,800.00 212.08 11,556.31 64.92 6,243.69 101-4-3130-4109 Workers Comp 7,900.00 0.00 3,610.00 45.7C 4,290.00 TOTAL Personal Services 202,050.00 922.87 92,267.52 45.67 109,782.48 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Public Works 33.33° 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 8,545.31 75,039.11 78.57 20,460.89 TOTAL Supplies 95,500.00 8,545.31 75,039.11 78.57 20,460.89 Other Services & Charges Capital Outlay TOTAL Snow Removal 297,550.00 9,468.18 167,306.63 56.23 130,243.37 Equipment Services Personal Services 101-4-3150-4101 Regular Pay 119,150.00 9,166.40 35,290.64 29.62 83,859.36 101-4-3150-4102 Overtime Pay 3,000.00 0.00 0.00 0.00 3,000.00 101-4-3150-4104 PERA 9,150.00 687.48 3,086.88 33.74 6,063.12 101-4-3150-4105 FICA 7,550.00 532.30 2,422.41 32.08 5,127.59 101-4-3150-4107 Medicare 1,800.00 124.48 566.51 31.47 1,233.49 101-4-3150-4108 Insurance 14,150.00 1,178.01 4,593.72 32.46 9,556.28 101-4-3150-4109 Workers Comp 3,350.00 0.00 1,576.00 47.04 1,774.00 TOTAL Personal Services 158,150.00 11,688.67 47,536.16 30.06 110,613.84 Supplies 101-4-3150-4212 Fuels & Lubes 5,100.00 ( 296.66) ( 883.89) 17.33- 5,983.89 101-4-3150-4219 Operating Supplies 10,150.00 1,154.11 3,712.80 36.58 6,437.2C 101-4-3150-4221 Equipment Parts 10,000.00 2.37 ( 65.96) 0.66- 10,065.96 TOTAL Supplies 25,250.00 859.82 2,762.95 10.94 22,487.0E Other Services & Charges 101-4-3150-4331 Travel, Conferences & Schools 1,000.00 0.00 95.00 9.50 905.00 101-4-3150-4404 Equip Repair/Maint Services 10,000.00 0.00 450.00 4.50 9,550.00 101-4-3150-4417 Uniform Rental 2,150.00 196.13 542.54 25.23 1,607.46 TOTAL Other Services & Charges 13,150.00 196.13 1,087.54 8.27 12,062.46 Capital Outlay TOTAL Equipment Services 196,550.00 12,744.62 51,386.65 26.14 145,163.3E Engineering 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Public Works 33.33° 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 47,570.63 29.40 114,229.37 101-4-3300-4104 PERA 12,150.00 926.70 4,161.03 34.25 7,988.97 101-4-3300-4105 FICA 10,050.00 802.72 3,531.53 35.14 6,518.47 101-4-3300-4107 Medicare 2,350.00 187.73 825.93 35.15 1,524.07 101-4-3300-4108 Insurance 13,950.00 600.00 3,494.00 25.05 10,456.00 101-4-3300-4109 Workers Comp 800.00 0.00 354.00 44.25 446.00 TOTAL Personal Services 201,100.00 14,873.16 59,937.12 29.80 141,162.88 Supplies 101-4-3300-4201 Office Supplies 300.00 7.05 25.02 8.34 274.98 101-4-3300-4212 Fuels & Lubes 900.00 39.29 131.18 14.58 768.82 101-4-3300-4219 Operating Supplies 900.00 243.25 275.25 30.58 624.75 TOTAL Supplies 2,100.00 289.59 431.45 20.55 1,668.55 Other Services & Charges 101-4-3300-4319 Other Professional Services 9,500.00 2,100.00 2,216.00 23.33 7,284.00 101-4-3300-4321 Telephone 1,450.00 91.76 278.52 19.21 1,171.48 101-4-3300-4322 Postage 300.00 0.00 4.37 1.46 295.63 101-4-3300-4331 Travel, Conferences & Schools 2,000.00 89.70 89.70 4.49 1,910.3C 101-4-3300-4361 Insurance 100.00 0.00 46.50 46.50 53.5C 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 300.00 33.33 600.00 TOTAL Other Services & Charges 16,350.00 2,356.46 2,935.09 17.95 13,414.91 Capital Outlay TOTAL Engineering 219,550.00 17,519.21 63,303.66 28.83 156,246.34 TOTAL Public Works 1,900,950.00 146,919.02 627,728.94 33.02 1,273,221.06 Parks Department Personal Services 101-4-5110-4101 Regular Pay 400,800.00 31,049.46 116,785.76 29.14 284,014.24 101-4-5110-4102 Overtime Pay 6,600.00 380.84 1,510.75 22.89 5,089.25 101-4-5110-4103 Part-time Pay 68,250.00 0.00 46.71 0.07 68,203.29 101-4-5110-4104 PERA 30,550.00 2,357.26 10,567.91 34.59 19,982.09 101-4-5110-4105 FICA 29,000.00 1,827.46 8,752.48 30.18 20,247.52 101-4-5110-4107 Medicare 6,800.00 427.39 2,046.94 30.10 4,753.06 101-4-5110-4108 Insurance 61,600.00 5,148.03 19,880.00 32.27 41,720.00 101-4-5110-4109 Workers Comp 12,350.00 0.00 6,166.00 49.93 6,184.00 TOTAL Personal Services 615,950.00 41,190.44 165,756.55 26.91 450,193.4E 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Culture & Recreation 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-5110-4212 Fuels & Lubes 35,000.00 1,781.60 6,915.94 19.76 28,084.06 101-4-5110-4217 Uniform Allowance 3,800.00 115.60 364.58 9.59 3,435.42 101-4-5110-4219 Operating Supplies 92,650.00 13,305.99 28,700.75 30.98 63,949.25 101-4-5110-4221 Equipment Parts 21,000.00 1,875.97 9,684.37 46.12 11,315.63 TOTAL Supplies 152,450.00 17,079.16 45,665.64 29.95 106,784.36 Other Services & Charges 101-4-5110-4321 Telephone 4,500.00 213.40 812.33 18.05 3,687.67 101-4-5110-4322 Postage 100.00 0.00 0.00 0.00 100.00 101-4-5110-4331 Travel, Conferences & Schools 5,100.00 350.00 1,635.78 32.07 3,464.22 101-4-5110-4361 Insurance 27,350.00 0.00 15,217.00 55.64 12,133.00 101-4-5110-4389 Utilities 43,500.00 791.02 2,641.11 6.07 40,858.89 101-4-5110-4401 Bldg Repair/Maint Services 4,000.00 130.00 129.34 3.23 3,870.66 101-4-5110-4404 Equip Repair/Maint Services 16,500.00 335.00 1,311.27 7.95 15,188.73 101-4-5110-4409 Contractual Services 33,750.00 425.00 1,662.50 4.93 32,087.5C 101-4-5110-4415 Equipment Rental 13,000.00 275.00 1,630.00 12.54 11,370.00 101-4-5110-4460 Equip Replacement Charge 50,950.00 4,245.83 16,983.32 33.33 33,966.68 TOTAL Other Services & Charges 198,750.00 6,765.25 42,022.65 21.14 156,727.35 Capital Outlay TOTAL Parks Department 967,150.00 65,034.85 253,444.84 26.21 713,705.16 Parks & Rec Admin Personal Services 101-4-5210-4101 Regular Pay 285,750.00 21,570.54 83,901.25 29.36 201,848.7E 101-4-5210-4103 Part-time Pay 51,700.00 3,690.46 14,509.71 28.07 37,190.29 101-4-5210-4104 PERA 25,300.00 1,894.58 8,607.72 34.02 16,692.28 101-4-5210-4105 FICA 21,000.00 1,484.49 6,790.27 32.33 14,209.73 101-4-5210-4107 Medicare 4,900.00 347.18 1,588.05 32.41 3,311.9E 101-4-5210-4108 Insurance 41,700.00 3,405.03 13,620.12 32.66 28,079.88 101-4-5210-4109 Workers Comp 3,800.00 0.00 1,681.00 44.24 2,119.00 TOTAL Personal Services 434,150.00 32,392.28 130,698.12 30.10 303,451.88 Supplies 101-4-5210-4219 Operating Supplies 13,500.00 879.62 2,326.45 17.23 11,173.55 TOTAL Supplies 13,500.00 879.62 2,326.45 17.23 11,173.5E Other Services & Charges 101-4-5210-4321 Telephone 6,050.00 413.48 1,398.85 23.12 4,651.1E 101-4-5210-4322 Postage 5,100.00 1,579.70 1,706.68 33.46 3,393.32 101-4-5210-4331 Travel, Conferences & Schools 9,850.00 37.30 726.25 7.37 9,123.7E 101-4-5210-4349 Advertising/Marketing 34,700.00 8,778.73 8,857.73 25.53 25,842.27 101-4-5210-4361 Insurance 400.00 0.00 195.00 48.75 205.00 101-4-5210-4389 Utilities 5,450.00 522.45 1,729.97 31.74 3,720.03 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Culture & Recreation 33.33° OF YEAR COMP. 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 950.00 4,230.57 27.83 10,969.43 101-4-5210-4404 Equip Repair/Maint Services 7,000.00 44.35 7,618.45 108.84 ( 618.45) 101-4-5210-4433 Dues & Subscriptions 1,800.00 0.00 2,245.00 124.72 ( 445.00) TOTAL Other Services & Charges 85,550.00 12,326.01 28,708.50 33.56 56,841.5C Capital Outlay TOTAL Parks & Rec Admin 533,200.00 45,597.91 161,733.07 30.33 371,466.93 Recreation Programs Personal Services 101-4-5220-4103 Part-time Pay 82,000.00 4,083.74 9,365.25 11.42 72,634.75 101-4-5220-4104 PERA 0.00 249.34 390.71 0.00 ( 390.71) 101-4-5220-4105 FICA 4,300.00 253.19 609.89 14.18 3,690.11 101-4-5220-4107 Medicare 1,200.00 59.21 142.62 11.89 1,057.38 TOTAL Personal Services 87,500.00 4,645.48 10,508.47 12.01 76,991.53 Supplies 101-4-5220-4219 Operating Supplies 28,000.00 0.00 497.60 1.78 27,502.4C TOTAL Supplies 28,000.00 0.00 497.60 1.78 27,502.4C Other Services & Charges 101-4-5220-4409 Contractual Services 45,000.00 48.00 5,323.00 11.83 39,677.00 101-4-5220-4412 Building Rent 1,650.00 709.75 709.75 43.02 940.2E 101-4-5220-4438 Credit Card Fees 3,600.00 612.71 831.78 23.11 2,768.22 TOTAL Other Services & Charges 50,250.00 1,370.46 6,864.53 13.66 43,385.47 TOTAL Recreation Programs 165,750.00 6,015.94 17,870.60 10.78 147,879.4C Concessions Personal Services Sr Citizen Programs Personal Services 101-4-5510-4101 Regular Pay 111,400.00 8,369.60 32,222.96 28.93 79,177.04 101-4-5510-4103 Part-time Pay 5,700.00 180.00 311.26 5.46 5,388.74 101-4-5510-4104 PERA 8,350.00 627.72 2,818.56 33.76 5,531.44 101-4-5510-4105 FICA 7,250.00 503.20 2,241.79 30.92 5,008.21 101-4-5510-4107 Medicare 1,700.00 117.69 524.31 30.84 1,175.69 101-4-5510-4108 Insurance 20,950.00 1,691.02 6,764.08 32.29 14,185.92 101-4-5510-4109 Workers Comp 550.00 0.00 246.00 44.73 304.00 TOTAL Personal Services 155,900.00 11,489.23 45,128.96 28.95 110,771.04 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 2E REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Culture & Recreation 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-5510-4219 Operating Supplies 11,900.00 1,760.18 4,325.45 36.35 7,574.55 TOTAL Supplies 11,900.00 1,760.18 4,325.45 36.35 7,574.5E Other Services & Charges 101-4-5510-4321 Telephone 2,400.00 0.00 307.28 12.80 2,092.72 101-4-5510-4322 Postage 3,300.00 9.80 788.59 23.90 2,511.41 101-4-5510-4331 Travel, Conferences & Schools 3,050.00 31.34 93.45 3.06 2,956.5E 101-4-5510-4361 Insurance 1,400.00 0.00 694.50 49.61 705.5C 101-4-5510-4389 Utilities 9,950.00 906.54 2,626.90 26.40 7,323.1C 101-4-5510-4401 Bldg Repair/Maint Services 16,050.00 769.00 2,460.60 15.33 13,589.4C 101-4-5510-4404 Equip Repair/Maint Services 100.00 16.75 16.75 16.75 83.2E 101-4-5510-4409 Contractual Services 10,700.00 1,377.65 2,106.64 19.69 8,593.36 101-4-5510-4433 Dues & Subscriptions 850.00 0.00 301.65 35.49 548.35 TOTAL Other Services & Charges 47,800.00 3,111.08 9,396.36 19.66 38,403.64 Capital Outlay TOTAL Sr Citizen Programs 215,600.00 16,360.49 58,850.77 27.30 156,749.23 TOTAL Culture & Recreation 1,881,700.00 133,009.19 491,899.28 26.14 1,389,800.72 Economic Development Personal Services 101-4-6210-4101 Regular Pay 0.00 3,569.27 9,931.22 0.00 ( 9,931.22) 101-4-6210-4103 Part-time Pay 0.00 ( 1,542.00) 1,242.00 0.00 ( 1,242.00) 101-4-6210-4104 PERA 0.00 252.69 759.84 0.00 ( 759.84) 101-4-6210-4105 FICA 0.00 115.79 638.88 0.00 ( 638.88) 101-4-6210-4107 Medicare 0.00 22.70 153.74 0.00 ( 153.74) 101-4-6210-4108 Insurance 0.00 847.01 1,409.02 0.00 ( 1,409.02) 101-4-6210-4109 Workers Comp 0.00 75.75 0.00 0.0C 0.0C TOTAL Personal Services 0.00 31341.21 14,134.70 0.00 ( 14,134.70) Other Services & Charges TOTAL Economic Development 0.00 3,341.21 14,134.70 0.00 ( 14,134.70) Energy City 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 101-GENERAL FUND Economic Development 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-6220-4101 Regular Pay 4,500.00 339.30 1,306.30 29.03 3,193.7C 101-4-6220-4104 PERA 350.00 25.44 114.23 32.64 235.77 101-4-6220-4105 FICA 300.00 21.04 94.47 31.49 205.53 101-4-6220-4107 Medicare 50.00 4.92 22.09 44.18 27.91 101-4-6220-4108 Insurance 300.00 36.36 145.44 48.48 154.56 TOTAL Personal Services 5,500.00 427.06 1,682.53 30.59 3,817.47 Supplies 101-4-6220-4219 Operating Supplies 600.00 94.90 94.90 15.82 505.1C TOTAL Supplies 600.00 94.90 94.90 15.82 505.1C 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 200.00 13.33 1,300.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 200.00 5.00 3,800.00 TOTAL Energy City 10,100.00 521.96 1,977.43 19.58 8,122.57 TOTAL Economic Development 10,100.00 3,863.17 16,112.13 159.53 ( 6,012.13) Transfers Out Transfers Out TOTAL EXPENDITURES 13,312,800.00 1,022,889.48 3,919,324.59 29.44 9,393,475.41 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 693,620.07) ( 3,126,074.64) 3,126,074.64 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 221-ICE ARENA FINANCIAL SUMMARY 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Ice Arena 629,650.00 25,770.21 209,111.67 33.21 420,538.33 Hockey 37,000.00 195.00 49,827.50 134.67 ( 12,827.50) Skating 39,500.00 540.00 13,174.00 33.35 26,326.00 Concessions 79,000.00 634.40 35,027.56 44.34 43,972.44 TOTAL REVENUES 785,150.00 27,139.61 307,140.73 39.12 478,009.27 EXPENDITURE SUMMARY Culture & Recreation Ice Arena 597,550.00 34,045.41 145,794.57 24.40 451,755.43 Hockey 20,800.00 231.60 8,713.22 41.89 12,086.78 Skating 27,850.00 1,482.94 4,536.66 16.29 23,313.34 Arena Concessions 59,900.00 4,062.16 22,898.18 38.23 37,001.82 TOTAL Culture & Recreation 706,100.00 39,822.11 181,942.63 25.77 524,157.37 TOTAL EXPENDITURES 706,100.00 39,822.11 181,942.63 25.77 524,157.37 REVENUES OVER/(UNDER) EXPENDITURES 79,050.00 ( 12,682.50) 125,198.10 46,148.10) 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 221-ICE ARENA 33.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 525,000.00 23,941.40 182,395.58 34.74 342,604.42 221-3-0000-3465 Admissions 29,200.00 0.00 8,316.50 28.48 20,883.5C 221-3-0000-3466 Dry Floor Events 19,750.00 885.00 4,714.00 23.87 15,036.00 221-3-0000-3468 Skate Sharpening 4,300.00 144.00 1,700.00 39.53 2,600.00 221-3-0000-3475 Building Rent 2,600.00 0.00 0.00 0.00 2,600.00 221-3-0000-3482 Advertising fee 22,000.00 116.67 466.68 2.12 21,533.32 TOTAL Charges for Services 602,850.00 25,087.07 197,592.76 32.78 405,257.24 Other Revenue 221-3-0000-3621 Interest Income 2,200.00 0.00 725.88 32.99 1,474.12 221-3-0000-3622 Vending Machines 14,000.00 626.29 6,518.30 46.56 7,481.7C 221-3-0000-3626 Contributions 6,500.00 0.00 3,210.00 49.38 3,290.00 221-3-0000-3629 Miscellaneous Revenue 3,800.00 44.95 931.38 24.51 2,868.62 TOTAL Other Revenue 26,500.00 671.24 11,385.56 42.96 15,114.44 Sales 221-3-0000-3791 ATM Revenue 300.00 11.90 133.35 44.45 166.65 TOTAL Sales 300.00 11.90 133.35 44.45 166.65 Transfers In TOTAL Ice Arena 629,650.00 25,770.21 209,111.67 33.21 420,538.33 Hockey Charges for Services 221-3-5410-3461 Recreation Fees 37,000.00 195.00 49,827.50 134.67 ( 12,827.5C) TOTAL Charges for Services 37,000.00 195.00 49,827.50 134.67 ( 12,827.50) Other Revenue TOTAL Hockey 37,000.00 195.00 49,827.50 134.67 ( 12,827.50) Skating 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 221-ICE ARENA 33.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 380.00 10,974.00 30.91 24,526.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 380.00 10,974.00 27.78 28,526.00 Other Revenue 221-3-5420-3629 Miscellaneous Revenue 0.00 160.00 2,200.00 O.00 ( 2,200.00) TOTAL Other Revenue 0.00 160.00 2,200.00 0.00 ( 2,200.00) TOTAL Skating 39,500.00 540.00 13,174.00 33.35 26,326.00 Concessions Charges for Services 221-3-5430-3467 Concessions 79,000.00 634.40 35,027.56 44.34 43,972.44 TOTAL Charges for Services 79,000.00 634.40 35,027.56 44.34 43,972.44 TOTAL Concessions 79,000.00 634.40 35,027.56 44.34 43,972.44 TOTAL REVENUE 785,150.00 27,139.61 307,140.73 39.12 478,009.27 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 221-ICE ARENA 33.33° 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,751.94 37,091.48 20.58 143,108.52 221-4-5400-4103 Part-time Pay 61,450.00 4,396.30 25,690.16 41.81 35,759.84 221-4-5400-4104 PERA 18,100.00 1,013.19 4,813.65 26.59 13,286.3E 221-4-5400-4105 FICA 15,000.00 895.64 4,539.24 30.26 10,460.76 221-4-5400-4107 Medicare 3,550.00 209.47 1,061.57 29.90 2,488.43 221-4-5400-4108 Insurance 27,750.00 1,409.02 5,636.08 20.31 22,113.92 221-4-5400-4109 Workers Comp 8,000.00 0.00 4,454.50 55.68 3,545.5C TOTAL Personal Services 314,050.00 17,675.56 83,286.68 26.52 230,763.32 Supplies 221-4-5400-4212 Fuels & Lubes 300.00 0.00 73.30 24.43 226.7C 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 677.94 16,885.73 33.81 33,064.27 221-4-5400-4255 Soft Drinks/Misc 6,800.00 921.61 2,583.19 37.99 4,216.81 221-4-5400-4259 Other Merchandise For Resale 900.00 0.00 0.00 O.00 900.00 TOTAL Supplies 58,750.00 1,599.55 19,542.22 33.26 39,207.78 Other Services & Charges 221-4-5400-4321 Telephone 3,350.00 74.90 489.88 14.62 2,860.12 221-4-5400-4322 Postage 0.00 9.37 63.51 0.00 ( 63.51) 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 1,600.00 1,655.80 29.05 4,044.2C 221-4-5400-4361 Insurance 4,850.00 0.00 2,405.50 49.60 2,444.5C 221-4-5400-4389 Utilities 157,250.00 9,470.00 31,665.13 20.14 125,584.87 221-4-5400-4401 Bldg Repair/Maint Services 33,300.00 3,388.90 5,532.33 16.61 27,767.67 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 908.52 24.55 2,791.48 221-4-5400-4433 Dues & Subscriptions 750.00 0.00 245.00 32.67 505.00 TOTAL Other Services & Charges 213,250.00 14,770.30 42,965.67 20.15 170,284.33 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 34,045.41 145,794.57 24.40 451,755.43 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 221-ICE ARENA Culture & Recreation 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES 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 7,373.52 63.56 4,226.48 TOTAL Supplies 11,600.00 0.00 7,373.52 63.56 4,226.48 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 231.60 1,339.70 47.85 1,460.3C TOTAL Other Services & Charges 8,300.00 231.60 1,339.70 16.14 6,960.3C TOTAL Hockey 20,800.00 231.60 8,713.22 41.89 12,086.78 Skating Personal Services 221-4-5420-4103 Part-time Pay 17,800.00 536.36 2,343.63 13.17 15,456.37 221-4-5420-4104 PERA 1,000.00 6.50 27.49 2.75 972.51 221-4-5420-4105 FICA 1,100.00 33.25 154.25 14.02 945.7E 221-4-5420-4107 Medicare 250.00 7.80 36.10 14.44 213.9C TOTAL Personal Services 20,150.00 583.91 2,561.47 12.71 17,588.53 Supplies 221-4-5420-4219 Operating Supplies 5,100.00 865.71 1,694.45 33.22 3,405.55 TOTAL Supplies 5,100.00 865.71 1,694.45 33.22 3,405.5E 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 33.32 280.74 O.00 ( 280.74) TOTAL Other Services & Charges 2,600.00 33.32 280.74 10.80 2,319.26 TOTAL Skating 27,850.00 1,482.94 4,536.66 16.29 23,313.34 5-12-2015 11:04 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2015 221-ICE ARENA Culture & Recreation 33.33° OF YEAR COMP. CURRENT CURRENT YEAR TO DATE o OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Arena Concessions Personal Services 221-4-5430-4103 Part-time Pay 21,300.00 612.89 7,891.78 37.05 13,408.22 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 38.00 585.54 45.04 714.46 221-4-5430-4107 Medicare 300.00 8.89 136.98 45.66 163.02 TOTAL Personal Services 24,500.00 659.78 8,614.30 35.16 15,885.7C Supplies 221-4-5430-4219 Operating Supplies 5,800.00 52.23 807.83 13.93 4,992.17 221-4-5430-4259 Other Merchandise For Resale 29,600.00 3,350.15 13,476.05 45.53 16,123.95 TOTAL Supplies 35,400.00 3,402.38 14,283.88 40.35 21,116.12 TOTAL Arena Concessions 59,900.00 4,062.16 22,898.18 38.23 37,001.82 TOTAL Culture & Recreation 706,100.00 39,822.11 181,942.63 25.77 524,157.37 TOTAL EXPENDITURES 706,100.00 39,822.11 181,942.63 25.77 524,157.37 REVENUES OVER/(UNDER) EXPENDITURES 79,050.00 ( 12,682.50) 125,198.10 46,148.10) CITY OF ELK RIVER ENTERPRISE FUNDS-BUDGET TO ACTUAL MONTH ENDED APRIL,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 Sales and cost of sales: Sales $ 6,865,650 $ 1,969,877 $ 4,895,773 28.69% Cost of sales (4,898,950) (1,198,431) (3,700,519) 24.46% Gross profit 1,966,700 771,446 1,195,254 39.23% Operating revenues: User charges $ - $ - $ - 0.00% $ 1,758,200 $ 438,472 $ 1,319,728 24.94% $ 1,302,000 $ 324,164 $ 977,836 24.90% $ 418,000 $ - $ 418,000 0.00% Delinquency collections - - - 0.00% 1,300 - 1,300 0.00% 12,000 - 12,000 0.00% - - - Other 1,900 822 1,078 43.26% 2,000 500 1,500 25.00% 3,500 853 2,647 24.37% - - - Total operating revenues 1,900 822 1,078 43.26% 1,761,500 438,972 1,322,528 24.92% 1,317,500 325,017 992,483 24.67% 418,000 - 418,000 0.00% Operating expenses: Personal services 624,900 195,909 428,991 31.35% 526,560 132,321 394,239 25.13% 26,650 8,203 18,447 30.78% 87,150 22,387 64,763 25.69% Supplies 53,400 26,856 26,544 50.29% 217,700 15,869 201,831 7.29% 5,900 150 5,750 2.54% 14,600 1,103 13,497 7.55% Other service charges 221,250 56,969 164,281 25.75% 470,550 110,414 360,136 23.46% 1,315,250 308,098 1,007,152 23.43% 243,000 128,476 114,524 52.87% Depreciation* 123,000 - 123,000 0.00% 977,950 - 977,950 0.00% - - - 0.00% 433,750 - 433,750 0.00% Total operating expenses 1,022,550 279,734 742,816 27.36% 2,192,760 258,604 1,934,156 11.79% 1,347,800 316,451 1,031,349 23.48% 778,500 151,966 626,534 19.52% Operating income(loss) 946,050 492,534 453,516 52.06% (431,260) 180,368 (611,628) -41.82% (30,300) 8,566 (38,866) -28.27% (360,500) (151,966) (208,534) 42.15% Nonoperating revenues(expenses): Interest income 25,000 5,317 19,683 21.27% 100,000 13,762 86,238 13.76% 6,250 1,225 5,025 19.60% 900 489 411 54.33% Grant revenue - - - 0.00% 2,800,000 - 2,800,000 0.00% - - - 0.00% - - - 0.00% Interest expense - - - 0.00% (261,050) (23,364) (237,686) 8.95% - - - 0.00% - - - 0.00% Total nonoperating revenues(expenses) 25,000 5,317 19,683 21.27% 2,638,950 (9,602) 2,648,552 -0.36% 6,250 1,225 5,025 19.60% 900 489 411 54.33% Income(loss)before contributions and transfers 971,050 497,851 473,199 51.27% 2,207,690 170,766 2,036,924 7.74% (24,050) 9,791 (33,841) -40.71% (359,600) (151,477) (208,123) 42.12% Contributions-connection fees - - - 0.00% 630,700 77,940 552,760 12.36% - - - 0.00% 50,000 5,940 44,060 0.00% Transfers in - - - 0.00% 1,000,000 - 1,000,000 0.00% 14,600 - 14,600 0.00% - 280,761 (280,761) Transfers out (656,000) - (656,000) 0.00% (120,000) (20,000) (100,000) 16.67% (43,950) - (43,950) 0.00% - - - NET INCOME(LOSS) 315,050 497,851 (182,801) 158.02% 3,718,390 228,706 3,489,684 6.15% (53,400) 9,791 (63,191) -18.34% (309,600) 135,224 (444,824) -43.68% Items reclassified to balance sheet at year end: Bond Proceeds - - - Capital Outlay (10,875,100) (1,593,322) (9,281,778) 14.65% (180,000) - Bond Payment - - - Revenues over/(under)expenditures 315,050 497,851 (182,801) (7,156,710) (1,364,616) (5,792,094) (53,400) 9,791 (63,191) (489,600) 135,224 (444,824) *Recorded at year end 5-12-2015 11:05 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: APRIL 30TH, 201E INFORMATION BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE CLAIM ON CASH 002-1010 Cash - Section 125 18,653.06 716.36 19,369.42 101-1010 Cash - General Fund 3,693,878.96 719,596.72) 2,974,282.24 211-1010 Cash - Library 408,065.52 11,916.96) 396,148.56 221-1010 Cash - Ice Arena 430,575.33 149.59) 430,425.74 222-1010 Cash - Pinewood Golf Course 867.35 0.00 867.35 225-1010 Cash - Park Dedication 80,131.17 0.00 80,131.17 228-1010 Cash - Landfill 618,766.87 7,707.12 626,473.99 231-1010 Cash - Landfill Const Debris 719,040.85 0.00 719,040.85 240-1010 Cash - Micro Loan Fund 899,216.18 5,006.54 904,222.72 241-1010 Cash - Federal DEED 200,000.00 0.00 200,000.00 242-1010 Cash - State DEED 288,194.16 874.72 289,068.88 245-1010 Cash - Development Fund 358,039.85 5,480.00 363,519.85 290-1010 Cash - Capital Outlay Reserve 1,228,131.12 23,309.78) 1,204,821.34 291-1010 Cash - Insurance Reserve 239,547.89 1,889.16) 237,658.73 292-1010 Cash - Govt Bldgs Reserve 3,153,761.49 123,334.92 3,277,096.41 294-1010 Cash - Drug Forfeiture 35,055.87 56.34 35,112.21 295-1010 Cash - Severance Pay Reserve 70,250.60 0.00 70,250.6C 296-1010 Cash - GRE Reserve 2,785,108.03 0.00 2,785,108.03 313-1010 Cash - 2007C GO Bonds 95,949.89 2,150.00 98,099.89 333-1010 Cash - 2010A GO Cap Imp Bonds 486,964.55 0.00 486,964.55 344-1010 Cash - 2006C Cap Imp Bonds Lby 450.00) 0.00 450.00) 345-1010 Cash - 2012A CIP Bonds-PW 229.07 450.00) ( 220.93) 401-1010 Cash - Pavement Mgmt 2,380,153.08 342,053.05 2,722,206.13 403-1010 Cash - Street Improvement 1,845,236.17 288,708.56 2,133,944.73 406-1010 Cash - City Wide Trunk Util 4,276,555.03 0.00 4,276,555.03 410-1010 Cash - Equipment Replacement 771,142.53 220,280.32) 550,862.21 426-1010 Cash - YMCA 383,930.71 0.00 383,930.71 440-1010 Cash - Park Improvement 118,750.04 21,702.93 140,452.97 459-1010 Cash - TIF 419 Highway 169 369,291.55 0.00 369,291.55 602-1010 Cash - Wastewater Treatment 12,245,195.24 417,926.42) 11,827,268.82 603-1010 Cash - Liquor 2,648,435.41 62,772.38 2,711,207.79 605-1010 Cash - Garbage 611,873.85 2,106.70 613,980.55 607-1010 Cash - Storm Water 159,239.02 20,822.68) 138,416.34 801-1010 Cash - Interest 0.00 92,041.45 92,041.45 821-1010 Cash - Developer Escrow 94,230.89 4,140.00 98,370.89 TOTAL CLAIM ON CASH 41,714,011.33 457,490.56) 41,256,520.77 CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 68,868,288.69 399,262.28 69,267,550.97 999-1001 PY BANK ACCOUNT (55,536,466.92) ( 856,752.84) (56,393,219.76) 999-1002 POOLED INVESTMENTS 28,382,189.56 O.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 41,714,011.33 457,490.56) 41,256,520.77