Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 05-15-2017
Information Memorandum To: Mayor and City Council From: Jesse Dorn, Assistant Finance Director Date: May 15, 2017 Subject: April 2017 Monthly Financial Report _______________________________________________________________________ This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund, Ice Arena Special Revenue Fund, and Enterprise Funds. 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 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: Excluding transfers in, revenue collections are just over 8% of budget, with the first half property taxes to be collected in July. Licenses and permits collections are 65% of budget estimates, with building-related permit collections at 81% and rental licenses at 96% as of the end of April. A large portion of the building-related permit collections is related to the Sherburne County Government Center. Intergovernmental revenue collections consist of the first quarter “Toward Zero Deaths” grant. Charges for services are about 52% of budget estimates, with April collections consisting mainly of plan check fees and recreation fees. Although fines and forfeits collections lag a month, reported collections through March are about 32% of budget estimates. Transfers in reflect ERMU contributions through March and the remaining transfers in will be recorded mid-year. Actual$9,586$8,387$7,189$5,991$4,793$3,595$2,396$1,198Budget$4,018$3,021$1,896$831 $0$16,000$14,000$12,000$10,000$8,000$6,000$4,000$2,000$ THOUSANDS 2017 Monthly Expenditures Expenditures: Total departmental expenditures are 28% of budget and most departments are at or below budget estimates. ICE ARENA For the month ending April, revenues of $342,931 exceed expenditures of $203,717 by $139,214. Ice rental revenues of $188,919 are 35% of budget estimates. ATTACHMENTS General Fund Revenue & Expense Report Enterprise Funds – Budget to Actual Cash Report – All Funds 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND FINANCIAL SUMMARY 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ REVENUE SUMMARY General Fund 14,378,400.00 249,225.69 1,251,461.47 8.70 13,126,938.53 TOTAL REVENUES 14,378,400.00 249,225.69 1,251,461.47 8.70 13,126,938.53 ============= ============= ============= ======= ============= EXPENDITURE SUMMARY General Government Mayor & Council 148,800.00 3,766.98 39,067.65 26.26 109,732.35 Cable TV 111,300.00 7,154.19 27,448.99 24.66 83,851.01 Administrative Services 594,450.00 43,849.28 165,900.88 27.91 428,549.12 Human Resources 234,450.00 8,538.14 56,001.84 23.89 178,448.16 Elections 6,600.00 0.00 6,300.00 95.45 300.00 Finance 572,200.00 41,110.24 158,675.68 27.73 413,524.32 Information Technology 385,100.00 25,915.47 138,982.11 36.09 246,117.89 Legal 220,000.00 28,836.00 53,175.30 24.17 166,824.70 Community Development 223,400.00 17,285.93 64,855.97 29.03 158,544.03 Planning 297,450.00 20,761.19 83,866.90 28.20 213,583.10 City Hall Maintenance 638,850.00 43,849.22 181,378.53 28.39 457,471.47 TOTAL General Government 3,432,600.00 241,066.64 975,653.85 28.42 2,456,946.15 Public Safety Police Administration 762,900.00 37,314.65 242,736.97 31.82 520,163.03 Patrol 2,495,550.00 167,578.69 656,931.11 26.32 1,838,618.89 Investigations 1,029,350.00 70,897.97 262,204.38 25.47 767,145.62 Police Support Services 676,100.00 51,049.38 195,928.69 28.98 480,171.31 Police Reserves 21,450.00 1,117.00 2,706.70 12.62 18,743.30 Public safety building 156,900.00 9,892.04 43,807.70 27.92 113,092.30 Fire Administration 481,050.00 32,588.17 136,009.66 28.27 345,040.34 Fire Operations 400,200.00 35,646.81 133,912.73 33.46 266,287.27 Emergency Management 27,300.00 1,302.22 2,344.15 8.59 24,955.85 Building Safety 665,300.00 50,282.97 194,829.03 29.28 470,470.97 Code Enforcement 93,650.00 6,829.81 25,974.26 27.74 67,675.74 Environmental 47,000.00 3,407.81 7,762.02 16.51 39,237.98 TOTAL Public Safety 6,856,750.00 467,907.52 1,905,147.40 27.78 4,951,602.60 Public Works Street Maintenance 1,304,800.00 134,121.86 391,878.50 30.03 912,921.50 Snow Removal 305,950.00 125.72 99,637.09 32.57 206,312.91 Equipment Services 196,050.00 18,189.25 54,736.86 27.92 141,313.14 Engineering 218,500.00 16,895.31 67,069.05 30.70 151,430.95 TOTAL Public Works 2,025,300.00 169,332.14 613,321.50 30.28 1,411,978.50 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND FINANCIAL SUMMARY 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Culture & Recreation Parks Department 1,047,950.00 65,155.03 248,421.81 23.71 799,528.19 Parks & Rec Admin 557,950.00 38,005.16 156,505.24 28.05 401,444.76 Recreation Programs 174,450.00 4,541.11 19,858.23 11.38 154,591.77 Sr Citizen Programs 249,600.00 18,229.17 71,936.10 28.82 177,663.90 TOTAL Culture & Recreation 2,029,950.00 125,930.47 496,721.38 24.47 1,533,228.62 Economic Development Economic Development 0.00 ( 6,267.81) 21,604.78 0.00 ( 21,604.78) Energy City 33,800.00 1,655.89 5,667.64 16.77 28,132.36 TOTAL Economic Development 33,800.00 ( 4,611.92) 27,272.42 80.69 6,527.58 General _____________ _____________ _____________ _______ _____________ TOTAL EXPENDITURES 14,378,400.00 999,624.85 4,018,116.55 27.95 10,360,283.45 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 750,399.16)( 2,766,655.08) 2,766,655.08 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ General Fund ============ Taxes 101-3-0000-3111 Current Ad Valorem Taxes 9,969,250.00 0.00 0.00 0.00 9,969,250.00 101-3-0000-3121 Gravel Tax 140,000.00 7,992.73 7,992.73 5.71 132,007.27 TOTAL Taxes 10,109,250.00 7,992.73 7,992.73 0.08 10,101,257.27 Licenses & Permits 101-3-0000-3211 Liquor License 67,500.00 22,600.00 24,380.03 36.12 43,119.97 101-3-0000-3212 Amusement License 1,050.00 0.00 0.00 0.00 1,050.00 101-3-0000-3213 Cigarette License 3,100.00 0.00 300.00 9.68 2,800.00 101-3-0000-3214 Rental License 45,000.00 3,951.00 43,209.00 96.02 1,791.00 101-3-0000-3216 Mining License 23,000.00 2,407.65 3,917.85 17.03 19,082.15 101-3-0000-3217 Garbage Hauler License 1,800.00 0.00 465.00 25.83 1,335.00 101-3-0000-3218 Other Business License/Permit 13,000.00 310.00 1,980.00 15.23 11,020.00 101-3-0000-3229 NPDES Permit 12,000.00 1,050.00 5,075.00 42.29 6,925.00 101-3-0000-3231 Building Permit 415,000.00 24,092.06 242,854.79 58.52 172,145.21 101-3-0000-3232 Plumbing/Heating Permit 118,000.00 92,610.89 130,342.53 110.46 ( 12,342.53) 101-3-0000-3233 Permit Surcharge 1,500.00 ( 2,851.00) 4,109.17 273.94 ( 2,609.17) 101-3-0000-3235 Animal License 6,000.00 210.00 800.00 13.33 5,200.00 101-3-0000-3237 Other Non-Business Lic/Permit 8,000.00 1,575.00 4,625.00 57.81 3,375.00 TOTAL Licenses & Permits 714,950.00 145,955.60 462,058.37 64.63 252,891.63 Intergovernmental Rev 101-3-0000-3322 MV Credit 5,000.00 0.00 0.00 0.00 5,000.00 101-3-0000-3324 PERA Aid 14,000.00 0.00 0.00 0.00 14,000.00 101-3-0000-3325 Police 2% Aid 239,500.00 0.00 0.00 0.00 239,500.00 101-3-0000-3326 Police Training Reimb 10,000.00 0.00 0.00 0.00 10,000.00 101-3-0000-3329 State Crime Prevention Grant 25,000.00 6,566.33 6,566.33 26.27 18,433.67 TOTAL Intergovernmental Rev 293,500.00 6,566.33 6,566.33 2.24 286,933.67 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 30,000.00 475.00 7,019.70 23.40 22,980.30 101-3-0000-3413 Plan Check Fee 145,000.00 7,389.22 137,496.70 94.83 7,503.30 101-3-0000-3415 Special Assessment Search 500.00 0.00 50.00 10.00 450.00 101-3-0000-3417 Copies 1,700.00 181.00 1,237.62 72.80 462.38 101-3-0000-3418 Other General Govt Services 5,000.00 418.50 1,144.00 22.88 3,856.00 101-3-0000-3430 Lockout Fees 7,000.00 560.00 1,880.00 26.86 5,120.00 101-3-0000-3431 Police Services 8,000.00 130.00 1,311.00 16.39 6,689.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 550.00 1,200.00 40.00 1,800.00 101-3-0000-3436 Fire Contracts 234,000.00 0.00 137,963.00 58.96 96,037.00 101-3-0000-3437 Fire Services 2,000.00 218.70 259.20 12.96 1,740.80 101-3-0000-3438 Fire Inspections 5,000.00 0.00 0.00 0.00 5,000.00 101-3-0000-3450 Maintenance Facility Rent 13,800.00 1,156.50 4,626.00 33.52 9,174.00 101-3-0000-3451 Street Services 25,000.00 3,084.70 6,102.49 24.41 18,897.51 101-3-0000-3452 Engineering Services Reimb 125,000.00 0.00 33,901.83 27.12 91,098.17 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-3-0000-3461 Recreation Fees 96,000.00 6,773.50 32,366.91 33.72 63,633.09 101-3-0000-3462 Sr Center Activities 30,000.00 4,517.00 19,791.00 65.97 10,209.00 101-3-0000-3472 Park Use Fee 24,400.00 1,227.04 10,657.62 43.68 13,742.38 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 9,000.00 885.00 2,595.00 28.83 6,405.00 101-3-0000-3484 Contractor License Check 1,000.00 75.00 255.00 25.50 745.00 TOTAL Charges for Services 891,400.00 27,841.16 462,469.07 51.88 428,930.93 Fines & Forfeits 101-3-0000-3510 Court Fines 145,000.00 17,969.06 45,995.42 31.72 99,004.58 101-3-0000-3511 Parking Fines 10,000.00 300.00 2,080.00 20.80 7,920.00 TOTAL Fines & Forfeits 155,000.00 18,269.06 48,075.42 31.02 106,924.58 Special Assessments _____________ _____________ _____________ _______ _____________ Other Revenue 101-3-0000-3621 Interest Income 90,000.00 0.00 27,808.32 30.90 62,191.68 101-3-0000-3625 Refunds & Reimbursements 101,000.00 2,208.96 4,002.96 3.96 96,997.04 101-3-0000-3626 Contributions 20,000.00 0.00 16,000.00 80.00 4,000.00 101-3-0000-3629 Miscellaneous Revenue 6,500.00 750.44 1,562.59 24.04 4,937.41 TOTAL Other Revenue 217,500.00 2,959.40 49,373.87 22.70 168,126.13 Transfers In 101-3-0000-3925 Transfer-Landfill 56,000.00 0.00 0.00 0.00 56,000.00 101-3-0000-3926 Transfer-Capital Outlay Reserv 113,250.00 0.00 0.00 0.00 113,250.00 101-3-0000-3929 Transfer-NSP/RDF Reserve 45,000.00 0.00 0.00 0.00 45,000.00 101-3-0000-3930 Transfer-Development 14,000.00 0.00 0.00 0.00 14,000.00 101-3-0000-3942 Transfer-WWTS 130,000.00 0.00 0.00 0.00 130,000.00 101-3-0000-3943 Transfer-Liquor 482,850.00 0.00 0.00 0.00 482,850.00 101-3-0000-3944 Transfer-Garbage 46,150.00 0.00 0.00 0.00 46,150.00 101-3-0000-3945 Transfer-Utilities 1,035,000.00 39,641.41 214,925.68 20.77 820,074.32 101-3-0000-3946 Transfer-Stormwater 15,000.00 0.00 0.00 0.00 15,000.00 101-3-0000-3948 Transfer-EDA 34,800.00 0.00 0.00 0.00 34,800.00 101-3-0000-3949 Transfer-HRA 24,750.00 0.00 0.00 0.00 24,750.00 TOTAL Transfers In 1,996,800.00 39,641.41 214,925.68 10.76 1,781,874.32 _____________________________________________________________________________ TOTAL General Fund 14,378,400.00 249,225.69 1,251,461.47 8.70 13,126,938.53 ___________________________________________________________________________________________________________________ TOTAL REVENUE 14,378,400.00 249,225.69 1,251,461.47 8.70 13,126,938.53 ============= ============= ============= ======= ============= 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % 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 102.09 453.36 23.86 1,446.64 101-4-1110-4105 FICA 2,400.00 72.34 326.54 13.61 2,073.46 101-4-1110-4107 Medicare 550.00 46.52 203.50 37.00 346.50 101-4-1110-4109 Workers Comp 100.00 0.00 22.50 22.50 77.50 TOTAL Personal Services 43,450.00 3,429.27 13,839.18 31.85 29,610.82 Supplies 101-4-1110-4201 Office Supplies 800.00 32.91 343.67 42.96 456.33 TOTAL Supplies 800.00 32.91 343.67 42.96 456.33 Other Services & Charges 101-4-1110-4319 Other Professional Services 10,400.00 0.00 2,622.85 25.22 7,777.15 101-4-1110-4322 Postage 50.00 0.00 4.54 9.08 45.46 101-4-1110-4331 Travel, Conferences & Schools 2,600.00 20.85 466.11 17.93 2,133.89 101-4-1110-4359 Publishing 3,700.00 64.00 317.40 8.58 3,382.60 101-4-1110-4361 Insurance 40,800.00 0.00 17,905.00 43.88 22,895.00 101-4-1110-4433 Dues & Subscriptions 19,550.00 0.00 0.00 0.00 19,550.00 101-4-1110-4440 Miscellaneous 27,450.00 219.95 3,568.90 13.00 23,881.10 TOTAL Other Services & Charges 104,550.00 304.80 24,884.80 23.80 79,665.20 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Mayor & Council 148,800.00 3,766.98 39,067.65 26.26 109,732.35 Cable TV ======== Personal Services 101-4-1120-4101 Regular Pay 65,000.00 4,996.80 18,738.00 28.83 46,262.00 101-4-1120-4102 Overtime Pay 0.00 0.00 140.53 0.00 ( 140.53) 101-4-1120-4103 Part-time Pay 18,400.00 667.46 1,997.70 10.86 16,402.30 101-4-1120-4104 PERA 6,800.00 424.82 1,562.21 22.97 5,237.79 101-4-1120-4105 FICA 5,200.00 346.65 1,202.91 23.13 3,997.09 101-4-1120-4107 Medicare 1,200.00 81.08 281.33 23.44 918.67 101-4-1120-4108 Insurance 11,350.00 628.50 3,372.00 29.71 7,978.00 101-4-1120-4109 Workers Comp 400.00 0.00 133.50 33.38 266.50 TOTAL Personal Services 108,350.00 7,145.31 27,428.18 25.31 80,921.82 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND General Government 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1120-4201 Office Supplies 2,000.00 1.93 8.11 0.41 1,991.89 TOTAL Supplies 2,000.00 1.93 8.11 0.41 1,991.89 Other Services & Charges 101-4-1120-4331 Travel, Conferences & Schools 950.00 6.95 12.70 1.34 937.30 TOTAL Other Services & Charges 950.00 6.95 12.70 1.34 937.30 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Cable TV 111,300.00 7,154.19 27,448.99 24.66 83,851.01 Administrative Services ======================= Personal Services 101-4-1210-4101 Regular Pay 398,500.00 30,650.90 115,134.44 28.89 283,365.56 101-4-1210-4102 Overtime Pay 0.00 0.00 69.15 0.00 ( 69.15) 101-4-1210-4103 Part-time Pay 47,200.00 3,620.32 12,830.02 27.18 34,369.98 101-4-1210-4104 PERA 33,450.00 2,570.35 9,602.59 28.71 23,847.41 101-4-1210-4105 FICA 27,650.00 2,168.15 8,123.30 29.38 19,526.70 101-4-1210-4107 Medicare 6,450.00 507.07 1,899.80 29.45 4,550.20 101-4-1210-4108 Insurance 26,650.00 2,250.50 9,557.20 35.86 17,092.80 101-4-1210-4109 Workers Comp 2,100.00 0.00 947.50 45.12 1,152.50 TOTAL Personal Services 542,000.00 41,767.29 158,164.00 29.18 383,836.00 Supplies 101-4-1210-4201 Office Supplies 7,300.00 175.59 924.98 12.67 6,375.02 TOTAL Supplies 7,300.00 175.59 924.98 12.67 6,375.02 Other Services & Charges 101-4-1210-4319 Other Professional Services 13,000.00 0.00 341.00 2.62 12,659.00 101-4-1210-4321 Telephone 1,650.00 253.26 579.78 35.14 1,070.22 101-4-1210-4322 Postage 0.00 0.00 367.16 0.00 ( 367.16) 101-4-1210-4331 Travel, Conferences & Schools 7,750.00 781.55 1,447.42 18.68 6,302.58 101-4-1210-4334 Car Allowance 4,800.00 400.00 1,600.00 33.33 3,200.00 101-4-1210-4361 Insurance 100.00 0.00 32.00 32.00 68.00 101-4-1210-4404 Equip Repair/Maint Services 14,950.00 459.63 1,732.58 11.59 13,217.42 101-4-1210-4433 Dues & Subscriptions 2,900.00 11.96 711.96 24.55 2,188.04 TOTAL Other Services & Charges 45,150.00 1,906.40 6,811.90 15.09 38,338.10 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Administrative Services 594,450.00 43,849.28 165,900.88 27.91 428,549.12 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND General Government 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Human Resources =============== Personal Services 101-4-1220-4101 Regular Pay 127,050.00 5,906.46 26,113.09 20.55 100,936.91 101-4-1220-4102 Overtime Pay 0.00 0.00 474.58 0.00 ( 474.58) 101-4-1220-4103 Part-time Pay 0.00 857.76 5,008.35 0.00 ( 5,008.35) 101-4-1220-4104 PERA 9,550.00 507.31 2,206.71 23.11 7,343.29 101-4-1220-4105 FICA 7,900.00 408.15 1,891.51 23.94 6,008.49 101-4-1220-4107 Medicare 1,850.00 95.45 442.37 23.91 1,407.63 101-4-1220-4108 Insurance 15,850.00 668.50 3,628.50 22.89 12,221.50 101-4-1220-4109 Workers Comp 600.00 0.00 270.00 45.00 330.00 TOTAL Personal Services 162,800.00 8,443.63 40,035.11 24.59 122,764.89 Supplies 101-4-1220-4201 Office Supplies 1,200.00 94.51 137.80 11.48 1,062.20 TOTAL Supplies 1,200.00 94.51 137.80 11.48 1,062.20 Other Services & Charges 101-4-1220-4319 Other Professional Services 1,250.00 0.00 388.65 31.09 861.35 101-4-1220-4322 Postage 600.00 0.00 142.44 23.74 457.56 101-4-1220-4331 Travel, Conferences & Schools 7,200.00 0.00 903.92 12.55 6,296.08 101-4-1220-4404 Equip Repair/Maint 60,600.00 0.00 14,170.00 23.38 46,430.00 101-4-1220-4433 Dues & Subscriptions 800.00 0.00 223.92 27.99 576.08 TOTAL Other Services & Charges 70,450.00 0.00 15,828.93 22.47 54,621.07 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Human Resources 234,450.00 8,538.14 56,001.84 23.89 178,448.16 Elections ========= Personal Services _____________ _____________ _____________ _______ _____________ Supplies _____________ _____________ _____________ _______ _____________ Other Services & Charges 101-4-1230-4404 Equip Repair/Maint Services 6,600.00 0.00 6,300.00 95.45 300.00 TOTAL Other Services & Charges 6,600.00 0.00 6,300.00 95.45 300.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Elections 6,600.00 0.00 6,300.00 95.45 300.00 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND General Government 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Finance ======= Personal Services 101-4-1310-4101 Regular Pay 303,000.00 23,005.97 86,272.42 28.47 216,727.58 101-4-1310-4103 Part-time Pay 54,700.00 3,997.44 16,565.95 30.29 38,134.05 101-4-1310-4104 PERA 26,850.00 2,025.24 7,712.83 28.73 19,137.17 101-4-1310-4105 FICA 22,200.00 1,620.83 6,175.82 27.82 16,024.18 101-4-1310-4107 Medicare 5,200.00 379.08 1,444.36 27.78 3,755.64 101-4-1310-4108 Insurance 40,600.00 3,091.70 12,371.30 30.47 28,228.70 101-4-1310-4109 Workers Comp 1,700.00 0.00 760.50 44.74 939.50 TOTAL Personal Services 454,250.00 34,120.26 131,303.18 28.91 322,946.82 Supplies 101-4-1310-4201 Office Supplies 5,000.00 92.30 455.03 9.10 4,544.97 TOTAL Supplies 5,000.00 92.30 455.03 9.10 4,544.97 Other Services & Charges 101-4-1310-4301 Audit Fees 20,000.00 5,000.00 7,850.00 39.25 12,150.00 101-4-1310-4319 Other Professional Services 56,500.00 0.00 0.00 0.00 56,500.00 101-4-1310-4321 Telephone 1,350.00 39.99 119.97 8.89 1,230.03 101-4-1310-4322 Postage 2,800.00 0.00 949.15 33.90 1,850.85 101-4-1310-4331 Travel, Conferences & Schools 3,900.00 25.00 225.00 5.77 3,675.00 101-4-1310-4359 Publishing 450.00 0.00 0.00 0.00 450.00 101-4-1310-4404 Equip Repair/Maint Services 19,050.00 675.00 15,350.39 80.58 3,699.61 101-4-1310-4433 Dues & Subscriptions 1,600.00 330.00 450.00 28.13 1,150.00 101-4-1310-4438 Credit Card Fees 5,800.00 739.89 1,604.06 27.66 4,195.94 101-4-1310-4440 Miscellaneous 1,500.00 87.80 368.90 24.59 1,131.10 TOTAL Other Services & Charges 112,950.00 6,897.68 26,917.47 23.83 86,032.53 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Finance 572,200.00 41,110.24 158,675.68 27.73 413,524.32 Information Technology ====================== Personal Services 101-4-1350-4101 Regular Pay 196,400.00 14,990.62 56,300.82 28.67 140,099.18 101-4-1350-4104 PERA 14,750.00 1,124.30 4,222.57 28.63 10,527.43 101-4-1350-4105 FICA 12,200.00 825.56 3,098.34 25.40 9,101.66 101-4-1350-4107 Medicare 2,850.00 193.07 724.98 25.44 2,125.02 101-4-1350-4108 Insurance 34,400.00 2,890.50 11,562.00 33.61 22,838.00 101-4-1350-4109 Workers Comp 950.00 0.00 417.50 43.95 532.50 TOTAL Personal Services 261,550.00 20,024.05 76,326.21 29.18 185,223.79 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND General Government 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1350-4219 Operating Supplies 20,100.00 1,162.14 6,402.87 31.86 13,697.13 TOTAL Supplies 20,100.00 1,162.14 6,402.87 31.86 13,697.13 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 555.00 1,526.25 19.08 6,473.75 101-4-1350-4321 Telephone 2,800.00 160.71 482.13 17.22 2,317.87 101-4-1350-4331 Travel, Conferences & Schools 12,750.00 657.63 9,054.93 71.02 3,695.07 101-4-1350-4404 Equip Repair/Maint Services 79,900.00 3,355.94 45,189.72 56.56 34,710.28 TOTAL Other Services & Charges 103,450.00 4,729.28 56,253.03 54.38 47,196.97 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Information Technology 385,100.00 25,915.47 138,982.11 36.09 246,117.89 Legal ===== Other Services & Charges 101-4-1400-4304 Legal Fees 220,000.00 28,836.00 53,175.30 24.17 166,824.70 TOTAL Other Services & Charges 220,000.00 28,836.00 53,175.30 24.17 166,824.70 ___________________________________________________________________________________________________________________ TOTAL Legal 220,000.00 28,836.00 53,175.30 24.17 166,824.70 Community Development ===================== Personal Services 101-4-1500-4101 Regular Pay 175,100.00 13,555.67 50,697.57 28.95 124,402.43 101-4-1500-4102 Overtime Pay 0.00 215.02 215.02 0.00 ( 215.02) 101-4-1500-4104 PERA 13,150.00 1,032.80 3,818.43 29.04 9,331.57 101-4-1500-4105 FICA 10,850.00 816.08 3,015.18 27.79 7,834.82 101-4-1500-4107 Medicare 2,550.00 190.86 705.16 27.65 1,844.84 101-4-1500-4108 Insurance 15,850.00 1,337.00 5,348.00 33.74 10,502.00 101-4-1500-4109 Workers Comp 850.00 0.00 372.00 43.76 478.00 TOTAL Personal Services 218,350.00 17,147.43 64,171.36 29.39 154,178.64 Supplies 101-4-1500-4201 Office Supplies 1,100.00 13.51 84.20 7.65 1,015.80 TOTAL Supplies 1,100.00 13.51 84.20 7.65 1,015.80 Other Services & Charges 101-4-1500-4321 Telephone 800.00 124.99 194.97 24.37 605.03 101-4-1500-4331 Travel, Conferences & Schools 2,600.00 0.00 106.44 4.09 2,493.56 101-4-1500-4433 Dues & Subscriptions 550.00 0.00 299.00 54.36 251.00 TOTAL Other Services & Charges 3,950.00 124.99 600.41 15.20 3,349.59 ___________________________________________________________________________________________________________________ TOTAL Community Development 223,400.00 17,285.93 64,855.97 29.03 158,544.03 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND General Government 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Planning ======== Personal Services 101-4-1510-4101 Regular Pay 217,700.00 15,221.71 60,739.70 27.90 156,960.30 101-4-1510-4104 PERA 16,350.00 1,141.62 4,555.47 27.86 11,794.53 101-4-1510-4105 FICA 13,500.00 856.82 3,439.87 25.48 10,060.13 101-4-1510-4107 Medicare 3,150.00 200.38 804.48 25.54 2,345.52 101-4-1510-4108 Insurance 26,600.00 2,240.50 8,962.00 33.69 17,638.00 101-4-1510-4109 Workers Comp 1,100.00 0.00 348.50 31.68 751.50 TOTAL Personal Services 278,400.00 19,661.03 78,850.02 28.32 199,549.98 Supplies 101-4-1510-4201 Office Supplies 1,500.00 172.16 561.49 37.43 938.51 101-4-1510-4212 Fuels & Lubes 300.00 0.00 0.00 0.00 300.00 101-4-1510-4219 Operating Supplies 1,900.00 0.00 130.00 6.84 1,770.00 TOTAL Supplies 3,700.00 172.16 691.49 18.69 3,008.51 Other Services & Charges 101-4-1510-4321 Telephone 350.00 0.00 0.00 0.00 350.00 101-4-1510-4322 Postage 1,200.00 0.00 547.39 45.62 652.61 101-4-1510-4331 Travel, Conferences & Schools 2,950.00 0.00 116.00 3.93 2,834.00 101-4-1510-4359 Publishing 8,000.00 928.00 2,192.00 27.40 5,808.00 101-4-1510-4361 Insurance 100.00 0.00 32.00 32.00 68.00 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 1,000.00 0.00 538.00 53.80 462.00 101-4-1510-4440 Miscellaneous 250.00 0.00 0.00 0.00 250.00 TOTAL Other Services & Charges 15,350.00 928.00 4,325.39 28.18 11,024.61 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Planning 297,450.00 20,761.19 83,866.90 28.20 213,583.10 City Hall Maintenance ===================== Personal Services 101-4-1600-4101 Regular Pay 354,300.00 27,196.65 102,486.17 28.93 251,813.83 101-4-1600-4102 Overtime Pay 3,500.00 0.00 275.27 7.86 3,224.73 101-4-1600-4103 Part-time Pay 3,550.00 0.00 0.00 0.00 3,550.00 101-4-1600-4104 PERA 26,850.00 2,039.74 7,707.09 28.70 19,142.91 101-4-1600-4105 FICA 22,400.00 1,682.81 6,358.53 28.39 16,041.47 101-4-1600-4107 Medicare 5,250.00 393.56 1,487.07 28.33 3,762.93 101-4-1600-4108 Insurance 50,300.00 4,157.50 16,630.00 33.06 33,670.00 101-4-1600-4109 Workers Comp 12,450.00 0.00 5,505.00 44.22 6,945.00 TOTAL Personal Services 478,600.00 35,470.26 140,449.13 29.35 338,150.87 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND General Government 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1600-4212 Fuels & Lubes 3,000.00 118.24 476.15 15.87 2,523.85 101-4-1600-4217 Uniform Allowance 2,400.00 179.97 612.63 25.53 1,787.37 101-4-1600-4219 Operating Supplies 33,500.00 575.85 5,703.03 17.02 27,796.97 TOTAL Supplies 38,900.00 874.06 6,791.81 17.46 32,108.19 Other Services & Charges 101-4-1600-4321 Telephone 11,700.00 234.58 3,592.31 30.70 8,107.69 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 20.00 325.00 16.25 1,675.00 101-4-1600-4361 Insurance 5,150.00 0.00 2,536.50 49.25 2,613.50 101-4-1600-4389 Utilities 65,250.00 5,423.69 19,423.22 29.77 45,826.78 101-4-1600-4401 Bldg Repair/Maint Services 30,800.00 1,580.80 4,895.84 15.90 25,904.16 101-4-1600-4404 Equip Repair/Maint Services 3,500.00 0.00 2,381.40 68.04 1,118.60 101-4-1600-4460 Equip Replacement Charge 2,950.00 245.83 983.32 33.33 1,966.68 TOTAL Other Services & Charges 121,350.00 7,504.90 34,137.59 28.13 87,212.41 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL City Hall Maintenance 638,850.00 43,849.22 181,378.53 28.39 457,471.47 Contingency =========== Personal Services _____________ _____________ _____________ _______ _____________ Other Services & Charges _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL General Government 3,432,600.00 241,066.64 975,653.85 28.42 2,456,946.15 Police Administration ===================== Personal Services 101-4-2110-4101 Regular Pay 372,800.00 23,971.70 89,893.86 24.11 282,906.14 101-4-2110-4102 Overtime Pay 2,500.00 0.00 0.00 0.00 2,500.00 101-4-2110-4104 PERA 55,100.00 3,883.40 14,562.75 26.43 40,537.25 101-4-2110-4105 FICA 3,800.00 0.00 0.00 0.00 3,800.00 101-4-2110-4107 Medicare 5,400.00 332.03 1,245.08 23.06 4,154.92 101-4-2110-4108 Insurance 34,250.00 1,887.50 7,550.00 22.04 26,700.00 101-4-2110-4109 Workers Comp 66,500.00 0.00 37,316.50 56.12 29,183.50 TOTAL Personal Services 540,350.00 30,074.63 150,568.19 27.86 389,781.81 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Public Safety 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-2110-4201 Office Supplies 11,000.00 1,181.84 1,441.71 13.11 9,558.29 101-4-2110-4217 Uniform Allowance 3,000.00 69.98 457.98 15.27 2,542.02 101-4-2110-4219 Operating Supplies 23,500.00 26.78 5,520.05 23.49 17,979.95 TOTAL Supplies 37,500.00 1,278.60 7,419.74 19.79 30,080.26 Other Services & Charges 101-4-2110-4319 Other Professional Services 7,900.00 0.00 142.43 1.80 7,757.57 101-4-2110-4321 Telephone 34,700.00 2,191.42 7,293.77 21.02 27,406.23 101-4-2110-4322 Postage 2,400.00 0.00 483.67 20.15 1,916.33 101-4-2110-4331 Travel, Conferences & Schools 14,800.00 770.00 2,168.00 14.65 12,632.00 101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2110-4361 Insurance 42,000.00 0.00 20,633.00 49.13 21,367.00 101-4-2110-4404 Equip Repair/Maint Services 68,950.00 2,850.00 44,433.17 64.44 24,516.83 101-4-2110-4433 Dues & Subscriptions 13,600.00 150.00 9,562.00 70.31 4,038.00 101-4-2110-4437 Taxes & Licenses 200.00 0.00 33.00 16.50 167.00 TOTAL Other Services & Charges 185,050.00 5,961.42 84,749.04 45.80 100,300.96 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Administration 762,900.00 37,314.65 242,736.97 31.82 520,163.03 Patrol ====== Personal Services 101-4-2120-4101 Regular Pay 1,612,400.00 115,654.48 436,492.19 27.07 1,175,907.81 101-4-2120-4102 Overtime Pay 100,000.00 3,278.97 17,245.52 17.25 82,754.48 101-4-2120-4104 PERA 277,400.00 19,267.21 73,505.49 26.50 203,894.51 101-4-2120-4107 Medicare 24,850.00 1,669.74 6,377.41 25.66 18,472.59 101-4-2120-4108 Insurance 174,100.00 12,645.00 50,580.00 29.05 123,520.00 TOTAL Personal Services 2,188,750.00 152,515.40 584,200.61 26.69 1,604,549.39 Supplies 101-4-2120-4212 Fuels & Lubes 78,000.00 6,719.97 19,725.39 25.29 58,274.61 101-4-2120-4217 Uniform Allowance 35,600.00 1,148.49 1,836.11 5.16 33,763.89 101-4-2120-4219 Operating Supplies 73,900.00 2,396.59 10,407.22 14.08 63,492.78 101-4-2120-4221 Equipment Parts 23,300.00 1,534.11 2,690.53 11.55 20,609.47 TOTAL Supplies 210,800.00 11,799.16 34,659.25 16.44 176,140.75 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 27,050.00 ( 794.20) 7,824.97 28.93 19,225.03 101-4-2120-4404 Equip Repair/Maint Services 20,800.00 100.00 14,212.96 68.33 6,587.04 101-4-2120-4433 Dues & Subscriptions 650.00 0.00 200.00 30.77 450.00 101-4-2120-4460 Equip Replacement Charge 47,500.00 3,958.33 15,833.32 33.33 31,666.68 TOTAL Other Services & Charges 96,000.00 3,264.13 38,071.25 39.66 57,928.75 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Public Safety 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Patrol 2,495,550.00 167,578.69 656,931.11 26.32 1,838,618.89 Investigations ============== Personal Services 101-4-2130-4101 Regular Pay 696,700.00 49,638.40 186,003.64 26.70 510,696.36 101-4-2130-4102 Overtime Pay 55,000.00 3,304.72 6,872.76 12.50 48,127.24 101-4-2130-4104 PERA 121,800.00 8,576.78 31,245.87 25.65 90,554.13 101-4-2130-4107 Medicare 9,550.00 725.59 2,641.42 27.66 6,908.58 101-4-2130-4108 Insurance 93,950.00 5,685.36 25,095.52 26.71 68,854.48 TOTAL Personal Services 977,000.00 67,930.85 251,859.21 25.78 725,140.79 Supplies 101-4-2130-4217 Uniform Allowance 6,950.00 743.30 1,371.81 19.74 5,578.19 101-4-2130-4219 Operating Supplies 10,600.00 666.90 833.70 7.87 9,766.30 TOTAL Supplies 17,550.00 1,410.20 2,205.51 12.57 15,344.49 Other Services & Charges 101-4-2130-4319 Other Professional Services 7,500.00 0.00 494.00 6.59 7,006.00 101-4-2130-4331 Travel, Conferences & Schools 11,200.00 130.00 2,496.48 22.29 8,703.52 101-4-2130-4433 Dues & Subscriptions 2,100.00 260.25 482.50 22.98 1,617.50 101-4-2130-4460 Equip Replacement Charge 14,000.00 1,166.67 4,666.68 33.33 9,333.32 TOTAL Other Services & Charges 34,800.00 1,556.92 8,139.66 23.39 26,660.34 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Investigations 1,029,350.00 70,897.97 262,204.38 25.47 767,145.62 Police Support Services ======================= Personal Services 101-4-2150-4101 Regular Pay 437,350.00 33,116.91 124,538.38 28.48 312,811.62 101-4-2150-4102 Overtime Pay 7,500.00 2,009.90 6,523.94 86.99 976.06 101-4-2150-4103 Part-time Pay 40,500.00 2,853.08 11,426.70 28.21 29,073.30 101-4-2150-4104 PERA 44,700.00 3,354.68 12,877.66 28.81 31,822.34 101-4-2150-4105 FICA 24,200.00 1,846.87 6,844.69 28.28 17,355.31 101-4-2150-4107 Medicare 5,650.00 431.94 1,600.77 28.33 4,049.23 101-4-2150-4108 Insurance 72,200.00 6,077.00 24,308.00 33.67 47,892.00 TOTAL Personal Services 632,100.00 49,690.38 188,120.14 29.76 443,979.86 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Public Safety 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-2150-4201 Office Supplies 1,000.00 31.00 54.92 5.49 945.08 101-4-2150-4217 Uniform Allowance 5,350.00 114.35 220.31 4.12 5,129.69 101-4-2150-4219 Operating Supplies 14,600.00 ( 500.00) 2,462.27 16.86 12,137.73 TOTAL Supplies 20,950.00 ( 354.65) 2,737.50 13.07 18,212.50 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 6,900.00 908.65 1,834.05 26.58 5,065.95 101-4-2150-4404 Equip Repair/Maint Services 2,300.00 0.00 0.00 0.00 2,300.00 101-4-2150-4409 Contractual Services 7,000.00 280.00 962.00 13.74 6,038.00 101-4-2150-4433 Dues & Subscriptions 550.00 0.00 175.00 31.82 375.00 101-4-2150-4460 Equip Replacement Charge 6,300.00 525.00 2,100.00 33.33 4,200.00 TOTAL Other Services & Charges 23,050.00 1,713.65 5,071.05 22.00 17,978.95 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Support Services 676,100.00 51,049.38 195,928.69 28.98 480,171.31 Police Reserves =============== Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 0.00 343.52 6.25 5,156.48 101-4-2160-4105 FICA 350.00 0.00 21.30 6.09 328.70 101-4-2160-4107 Medicare 100.00 0.00 4.98 4.98 95.02 TOTAL Personal Services 5,950.00 0.00 369.80 6.22 5,580.20 Supplies 101-4-2160-4217 Uniform Allowance 5,500.00 542.00 1,761.90 32.03 3,738.10 101-4-2160-4219 Operating Supplies 4,700.00 0.00 0.00 0.00 4,700.00 TOTAL Supplies 10,200.00 542.00 1,761.90 17.27 8,438.10 Other Services & Charges 101-4-2160-4319 Other Professional Services 2,100.00 575.00 575.00 27.38 1,525.00 101-4-2160-4331 Travel, Conferences & Schools 3,200.00 0.00 0.00 0.00 3,200.00 TOTAL Other Services & Charges 5,300.00 575.00 575.00 10.85 4,725.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Reserves 21,450.00 1,117.00 2,706.70 12.62 18,743.30 Public safety building ====================== 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Public Safety 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Services _____________ _____________ _____________ _______ _____________ Supplies 101-4-2190-4219 Operating Supplies 18,100.00 1,866.92 6,718.58 37.12 11,381.42 TOTAL Supplies 18,100.00 1,866.92 6,718.58 37.12 11,381.42 Other Services & Charges 101-4-2190-4361 Insurance 5,200.00 0.00 2,462.00 47.35 2,738.00 101-4-2190-4389 Utilities 95,500.00 6,722.88 24,156.16 25.29 71,343.84 101-4-2190-4401 Bldg Repair/Maint Services 38,100.00 1,302.24 10,470.96 27.48 27,629.04 TOTAL Other Services & Charges 138,800.00 8,025.12 37,089.12 26.72 101,710.88 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Public safety building 156,900.00 9,892.04 43,807.70 27.92 113,092.30 Fire Administration =================== Personal Services 101-4-2310-4101 Regular Pay 246,050.00 18,662.03 69,982.62 28.44 176,067.38 101-4-2310-4104 PERA 36,150.00 2,747.92 10,304.70 28.51 25,845.30 101-4-2310-4105 FICA 2,650.00 214.82 805.56 30.40 1,844.44 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,550.00 258.63 969.85 27.32 2,580.15 101-4-2310-4108 Insurance 30,950.00 2,829.02 9,550.52 30.86 21,399.48 101-4-2310-4109 Workers Comp 9,650.00 0.00 5,251.00 54.41 4,399.00 TOTAL Personal Services 359,000.00 24,712.42 96,864.25 26.98 262,135.75 Supplies 101-4-2310-4201 Office Supplies 2,950.00 0.00 106.48 3.61 2,843.52 101-4-2310-4212 Fuels & Lubes 3,900.00 510.70 1,289.37 33.06 2,610.63 101-4-2310-4217 Uniform Allowance 3,500.00 0.00 654.77 18.71 2,845.23 101-4-2310-4219 Operating Supplies 1,200.00 344.46 1,005.37 83.78 194.63 101-4-2310-4221 Equipment Parts 500.00 0.00 0.00 0.00 500.00 TOTAL Supplies 12,050.00 855.16 3,055.99 25.36 8,994.01 Other Services & Charges 101-4-2310-4319 Other Professional Services 5,000.00 0.00 0.00 0.00 5,000.00 101-4-2310-4321 Telephone 2,750.00 127.69 752.52 27.36 1,997.48 101-4-2310-4322 Postage 650.00 0.00 190.68 29.34 459.32 101-4-2310-4331 Travel, Conferences & Schools 4,250.00 0.00 1,761.40 41.44 2,488.60 101-4-2310-4359 Publishing 750.00 0.00 0.00 0.00 750.00 101-4-2310-4361 Insurance 9,800.00 0.00 4,776.50 48.74 5,023.50 101-4-2310-4389 Utilities 17,750.00 1,793.57 6,765.32 38.11 10,984.68 101-4-2310-4401 Bldg Repair/Maint Services 7,500.00 391.00 1,002.68 13.37 6,497.32 101-4-2310-4404 Equip Repair/Maint Services 2,950.00 0.00 0.00 0.00 2,950.00 101-4-2310-4433 Dues & Subscriptions 2,100.00 0.00 2,007.00 95.57 93.00 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Public Safety 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-4-2310-4460 Equip Replacement Charge 56,500.00 4,708.33 18,833.32 33.33 37,666.68 TOTAL Other Services & Charges 110,000.00 7,020.59 36,089.42 32.81 73,910.58 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Administration 481,050.00 32,588.17 136,009.66 28.27 345,040.34 Fire Operations =============== Personal Services 101-4-2320-4103 Part-time Pay 188,700.00 18,686.08 53,505.46 28.35 135,194.54 101-4-2320-4105 FICA 11,700.00 1,119.53 3,213.90 27.47 8,486.10 101-4-2320-4107 Medicare 2,750.00 268.01 767.28 27.90 1,982.72 101-4-2320-4108 Insurance 0.00 130.09 449.96 0.00 ( 449.96) 101-4-2320-4109 Workers Comp 29,000.00 0.00 17,973.50 61.98 11,026.50 TOTAL Personal Services 232,150.00 20,203.71 75,910.10 32.70 156,239.90 Supplies 101-4-2320-4201 Office Supplies 300.00 0.00 75.30 25.10 224.70 101-4-2320-4212 Fuels & Lubes 7,200.00 786.34 1,421.47 19.74 5,778.53 101-4-2320-4217 Uniform Allowance 8,600.00 0.00 2,079.60 24.18 6,520.40 101-4-2320-4219 Operating Supplies 76,950.00 3,629.74 27,821.23 36.15 49,128.77 101-4-2320-4221 Equipment Parts 9,400.00 1,033.00 2,817.45 29.97 6,582.55 TOTAL Supplies 102,450.00 5,449.08 34,215.05 33.40 68,234.95 Other Services & Charges 101-4-2320-4321 Telephone 4,400.00 323.59 1,090.52 24.78 3,309.48 101-4-2320-4331 Travel, Conferences & Schools 19,700.00 4,743.02 7,114.49 36.11 12,585.51 101-4-2320-4404 Equip Repair/Maint Services 35,200.00 4,683.41 9,887.07 28.09 25,312.93 101-4-2320-4409 Contractual Services 6,300.00 244.00 5,695.50 90.40 604.50 TOTAL Other Services & Charges 65,600.00 9,994.02 23,787.58 36.26 41,812.42 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Operations 400,200.00 35,646.81 133,912.73 33.46 266,287.27 Emergency Management ==================== Personal Services _____________ _____________ _____________ _______ _____________ Supplies 101-4-2330-4219 Operating Supplies 7,200.00 884.00 884.00 12.28 6,316.00 TOTAL Supplies 7,200.00 884.00 884.00 12.28 6,316.00 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Public Safety 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-2330-4331 Travel, Conferences & Schools 10,400.00 0.00 0.00 0.00 10,400.00 101-4-2330-4389 Utilities 4,500.00 418.22 1,200.15 26.67 3,299.85 101-4-2330-4404 Equip Repair/Maint Services 4,950.00 0.00 0.00 0.00 4,950.00 101-4-2330-4433 Dues & Subscriptions 250.00 0.00 260.00 104.00 ( 10.00) TOTAL Other Services & Charges 20,100.00 418.22 1,460.15 7.26 18,639.85 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Emergency Management 27,300.00 1,302.22 2,344.15 8.59 24,955.85 Building Safety =============== Personal Services 101-4-2410-4101 Regular Pay 465,650.00 35,933.01 131,868.45 28.32 333,781.55 101-4-2410-4103 Part-time Pay 0.00 0.00 4,241.98 0.00 ( 4,241.98) 101-4-2410-4104 PERA 41,600.00 3,208.84 11,883.95 28.57 29,716.05 101-4-2410-4105 FICA 24,100.00 1,680.40 6,383.29 26.49 17,716.71 101-4-2410-4107 Medicare 6,750.00 465.90 1,773.95 26.28 4,976.05 101-4-2410-4108 Insurance 83,500.00 7,048.50 28,194.00 33.77 55,306.00 101-4-2410-4109 Workers Comp 2,250.00 0.00 795.00 35.33 1,455.00 TOTAL Personal Services 623,850.00 48,336.65 185,140.62 29.68 438,709.38 Supplies 101-4-2410-4201 Office Supplies 3,000.00 209.96 304.78 10.16 2,695.22 101-4-2410-4212 Fuels & Lubes 6,000.00 551.64 1,752.25 29.20 4,247.75 101-4-2410-4217 Uniform Allowance 1,750.00 0.00 14.35 0.82 1,735.65 101-4-2410-4219 Operating Supplies 9,650.00 356.75 449.71 4.66 9,200.29 TOTAL Supplies 20,400.00 1,118.35 2,521.09 12.36 17,878.91 Other Services & Charges 101-4-2410-4321 Telephone 5,350.00 423.48 1,130.62 21.13 4,219.38 101-4-2410-4322 Postage 700.00 0.00 119.60 17.09 580.40 101-4-2410-4331 Travel, Conferences & Schools 4,150.00 0.00 849.12 20.46 3,300.88 101-4-2410-4361 Insurance 450.00 0.00 278.00 61.78 172.00 101-4-2410-4404 Equip Repair/Maint Services 5,000.00 121.16 2,211.16 44.22 2,788.84 101-4-2410-4433 Dues & Subscriptions 2,000.00 0.00 1,445.50 72.28 554.50 101-4-2410-4460 Equip Replacement Charge 3,400.00 283.33 1,133.32 33.33 2,266.68 TOTAL Other Services & Charges 21,050.00 827.97 7,167.32 34.05 13,882.68 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Safety 665,300.00 50,282.97 194,829.03 29.28 470,470.97 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Public Safety 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Code Enforcement ================ Personal Services 101-4-2420-4101 Regular Pay 72,050.00 5,542.40 20,784.00 28.85 51,266.00 101-4-2420-4104 PERA 5,400.00 415.68 1,558.80 28.87 3,841.20 101-4-2420-4105 FICA 4,500.00 355.87 1,334.52 29.66 3,165.48 101-4-2420-4107 Medicare 1,050.00 83.23 312.10 29.72 737.90 101-4-2420-4108 Insurance 3,600.00 304.50 1,218.00 33.83 2,382.00 101-4-2420-4109 Workers Comp 350.00 0.00 115.50 33.00 234.50 TOTAL Personal Services 86,950.00 6,701.68 25,322.92 29.12 61,627.08 Supplies 101-4-2420-4212 Fuels & Lubes 2,000.00 92.76 272.28 13.61 1,727.72 101-4-2420-4217 Uniform Allowance 350.00 0.00 0.00 0.00 350.00 101-4-2420-4219 Operating Supplies 950.00 0.00 0.00 0.00 950.00 TOTAL Supplies 3,300.00 92.76 272.28 8.25 3,027.72 Other Services & Charges 101-4-2420-4321 Telephone 850.00 35.37 147.86 17.40 702.14 101-4-2420-4322 Postage 1,750.00 0.00 188.70 10.78 1,561.30 101-4-2420-4331 Travel, Conferences & Schools 700.00 0.00 0.00 0.00 700.00 101-4-2420-4361 Insurance 100.00 0.00 42.50 42.50 57.50 TOTAL Other Services & Charges 3,400.00 35.37 379.06 11.15 3,020.94 ___________________________________________________________________________________________________________________ TOTAL Code Enforcement 93,650.00 6,829.81 25,974.26 27.74 67,675.74 Environmental ============= Personal Services 101-4-2440-4101 Regular Pay 19,150.00 1,274.05 4,696.13 24.52 14,453.87 101-4-2440-4104 PERA 1,450.00 95.54 220.82 15.23 1,229.18 101-4-2440-4105 FICA 1,200.00 79.18 289.71 24.14 910.29 101-4-2440-4107 Medicare 300.00 18.49 67.72 22.57 232.28 101-4-2440-4108 Insurance 2,400.00 188.52 389.04 16.21 2,010.96 101-4-2440-4109 Workers Comp 300.00 0.00 106.00 35.33 194.00 TOTAL Personal Services 24,800.00 1,655.78 5,769.42 23.26 19,030.58 Supplies 101-4-2440-4201 Office Supplies 1,500.00 1.93 8.11 0.54 1,491.89 101-4-2440-4212 Fuels & Lubes 300.00 19.10 24.85 8.28 275.15 101-4-2440-4219 Operating Supplies 5,000.00 31.00 246.00 4.92 4,754.00 TOTAL Supplies 6,800.00 52.03 278.96 4.10 6,521.04 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Public Safety 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-2440-4321 Telephone 850.00 0.00 0.00 0.00 850.00 101-4-2440-4322 Postage 1,000.00 0.00 13.64 1.36 986.36 101-4-2440-4331 Travel, Conferences & Schools 1,400.00 900.00 900.00 64.29 500.00 101-4-2440-4359 Publishing 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2440-4409 Contractual Services 11,000.00 800.00 800.00 7.27 10,200.00 101-4-2440-4433 Dues & Subscriptions 150.00 0.00 0.00 0.00 150.00 TOTAL Other Services & Charges 15,400.00 1,700.00 1,713.64 11.13 13,686.36 ___________________________________________________________________________________________________________________ TOTAL Environmental 47,000.00 3,407.81 7,762.02 16.51 39,237.98 ___________________________________________________________________________________________________________________ TOTAL Public Safety 6,856,750.00 467,907.52 1,905,147.40 27.78 4,951,602.60 Street Maintenance ================== Personal Services 101-4-3120-4101 Regular Pay 502,550.00 45,257.56 143,350.37 28.52 359,199.63 101-4-3120-4102 Overtime Pay 4,000.00 215.02 215.02 5.38 3,784.98 101-4-3120-4103 Part-time Pay 81,400.00 6,698.84 27,045.60 33.23 54,354.40 101-4-3120-4104 PERA 42,450.00 3,704.49 12,168.50 28.67 30,281.50 101-4-3120-4105 FICA 36,450.00 3,107.73 10,302.74 28.27 26,147.26 101-4-3120-4107 Medicare 8,550.00 726.80 2,409.52 28.18 6,140.48 101-4-3120-4108 Insurance 79,650.00 6,741.26 25,779.66 32.37 53,870.34 101-4-3120-4109 Workers Comp 30,900.00 0.00 14,987.50 48.50 15,912.50 TOTAL Personal Services 785,950.00 66,451.70 236,258.91 30.06 549,691.09 Supplies 101-4-3120-4201 Office Supplies 1,500.00 1.93 64.94 4.33 1,435.06 101-4-3120-4212 Fuels & Lubes 45,000.00 18,237.61 27,940.26 62.09 17,059.74 101-4-3120-4219 Operating Supplies 56,500.00 2,923.66 13,244.86 23.44 43,255.14 101-4-3120-4221 Equipment Parts 52,000.00 7,445.07 14,960.74 28.77 37,039.26 101-4-3120-4226 Street Signs 31,500.00 18,258.65 19,531.62 62.01 11,968.38 TOTAL Supplies 186,500.00 46,866.92 75,742.42 40.61 110,757.58 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 7,300.00 504.38 1,792.79 24.56 5,507.21 101-4-3120-4322 Postage 100.00 0.00 29.10 29.10 70.90 101-4-3120-4331 Travel, Conferences & Schools 5,100.00 0.00 827.00 16.22 4,273.00 101-4-3120-4359 Publishing 200.00 0.00 0.00 0.00 200.00 101-4-3120-4361 Insurance 18,500.00 0.00 8,824.00 47.70 9,676.00 101-4-3120-4389 Utilities 92,800.00 7,510.45 23,316.19 25.13 69,483.81 101-4-3120-4401 Bldg Repair/Maint Services 20,000.00 0.00 1,440.50 7.20 18,559.50 101-4-3120-4404 Equip Repair/Maint Services 9,000.00 0.00 3,000.00 33.33 6,000.00 101-4-3120-4409 Contractual Services 63,500.00 1,291.76 1,725.51 2.72 61,774.49 101-4-3120-4415 Equipment Rental 3,000.00 2,392.75 2,542.75 84.76 457.25 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Public Works 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-4-3120-4417 Uniform Rental 5,800.00 270.57 638.51 11.01 5,161.49 101-4-3120-4433 Dues & Subscriptions 350.00 0.00 337.50 96.43 12.50 101-4-3120-4437 Taxes & Licenses 150.00 0.00 70.00 46.67 80.00 101-4-3120-4460 Equip Replacement Charge 106,000.00 8,833.33 35,333.32 33.33 70,666.68 TOTAL Other Services & Charges 332,350.00 20,803.24 79,877.17 24.03 252,472.83 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Street Maintenance 1,304,800.00 134,121.86 391,878.50 30.03 912,921.50 Snow Removal ============ Personal Services 101-4-3130-4101 Regular Pay 140,000.00 0.00 28,971.62 20.69 111,028.38 101-4-3130-4102 Overtime Pay 20,000.00 0.00 9,305.79 46.53 10,694.21 101-4-3130-4104 PERA 11,550.00 0.00 2,533.71 21.94 9,016.29 101-4-3130-4105 FICA 9,950.00 0.00 2,124.26 21.35 7,825.74 101-4-3130-4107 Medicare 2,300.00 0.00 502.96 21.87 1,797.04 101-4-3130-4108 Insurance 21,050.00 0.00 1,757.38 8.35 19,292.62 101-4-3130-4109 Workers Comp 8,800.00 0.00 4,176.00 47.45 4,624.00 TOTAL Personal Services 213,650.00 0.00 49,371.72 23.11 164,278.28 Supplies 101-4-3130-4219 Operating Supplies 92,300.00 125.72 50,265.37 54.46 42,034.63 TOTAL Supplies 92,300.00 125.72 50,265.37 54.46 42,034.63 Other Services & Charges _____________ _____________ _____________ _______ _____________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Snow Removal 305,950.00 125.72 99,637.09 32.57 206,312.91 Equipment Services ================== Personal Services 101-4-3150-4101 Regular Pay 117,150.00 8,896.00 33,340.42 28.46 83,809.58 101-4-3150-4102 Overtime Pay 3,000.00 0.00 0.00 0.00 3,000.00 101-4-3150-4104 PERA 9,000.00 667.20 2,500.53 27.78 6,499.47 101-4-3150-4105 FICA 7,450.00 535.38 2,007.59 26.95 5,442.41 101-4-3150-4107 Medicare 1,750.00 125.21 469.52 26.83 1,280.48 101-4-3150-4108 Insurance 15,900.00 1,337.00 5,348.00 33.64 10,552.00 101-4-3150-4109 Workers Comp 3,400.00 0.00 1,354.00 39.82 2,046.00 TOTAL Personal Services 157,650.00 11,560.79 45,020.06 28.56 112,629.94 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Public Works 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-3150-4212 Fuels & Lubes 5,100.00 4,419.89 3,401.70 66.70 1,698.30 101-4-3150-4219 Operating Supplies 11,150.00 1,144.68 3,052.29 27.37 8,097.71 101-4-3150-4221 Equipment Parts 4,500.00 115.66 ( 3.65) 0.08- 4,503.65 TOTAL Supplies 20,750.00 5,680.23 6,450.34 31.09 14,299.66 Other Services & Charges 101-4-3150-4331 Travel, Conferences & Schools 3,000.00 192.00 1,047.00 34.90 1,953.00 101-4-3150-4404 Equip Repair/Maint Services 12,500.00 499.00 1,962.23 15.70 10,537.77 101-4-3150-4417 Uniform Rental 2,150.00 257.23 257.23 11.96 1,892.77 TOTAL Other Services & Charges 17,650.00 948.23 3,266.46 18.51 14,383.54 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Equipment Services 196,050.00 18,189.25 54,736.86 27.92 141,313.14 Engineering =========== Personal Services 101-4-3300-4101 Regular Pay 170,400.00 13,105.73 49,146.47 28.84 121,253.53 101-4-3300-4104 PERA 12,800.00 982.93 3,685.98 28.80 9,114.02 101-4-3300-4105 FICA 10,550.00 796.11 2,985.37 28.30 7,564.63 101-4-3300-4107 Medicare 2,450.00 186.17 698.18 28.50 1,751.82 101-4-3300-4108 Insurance 7,200.00 1,532.00 6,128.00 85.11 1,072.00 101-4-3300-4109 Workers Comp 800.00 0.00 273.00 34.13 527.00 TOTAL Personal Services 204,200.00 16,602.94 62,917.00 30.81 141,283.00 Supplies 101-4-3300-4201 Office Supplies 150.00 3.86 48.23 32.15 101.77 101-4-3300-4212 Fuels & Lubes 1,000.00 70.15 203.34 20.33 796.66 101-4-3300-4219 Operating Supplies 2,500.00 0.00 1,813.64 72.55 686.36 TOTAL Supplies 3,650.00 74.01 2,065.21 56.58 1,584.79 Other Services & Charges 101-4-3300-4319 Other Professional Services 4,000.00 0.00 584.00 14.60 3,416.00 101-4-3300-4321 Telephone 1,400.00 93.36 279.86 19.99 1,120.14 101-4-3300-4322 Postage 350.00 0.00 80.48 22.99 269.52 101-4-3300-4331 Travel, Conferences & Schools 1,500.00 0.00 600.00 40.00 900.00 101-4-3300-4361 Insurance 100.00 0.00 42.50 42.50 57.50 101-4-3300-4404 Equip Repair/Maint Services 1,800.00 0.00 0.00 0.00 1,800.00 101-4-3300-4460 Equip Replacement Charge 1,500.00 125.00 500.00 33.33 1,000.00 TOTAL Other Services & Charges 10,650.00 218.36 2,086.84 19.59 8,563.16 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Public Works 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Engineering 218,500.00 16,895.31 67,069.05 30.70 151,430.95 ___________________________________________________________________________________________________________________ TOTAL Public Works 2,025,300.00 169,332.14 613,321.50 30.28 1,411,978.50 Parks Department ================ Personal Services 101-4-5110-4101 Regular Pay 405,150.00 31,380.96 117,825.94 29.08 287,324.06 101-4-5110-4102 Overtime Pay 6,600.00 60.20 1,288.90 19.53 5,311.10 101-4-5110-4103 Part-time Pay 68,250.00 0.00 0.00 0.00 68,250.00 101-4-5110-4104 PERA 30,900.00 2,358.09 8,934.02 28.91 21,965.98 101-4-5110-4105 FICA 29,250.00 1,797.61 6,832.04 23.36 22,417.96 101-4-5110-4107 Medicare 6,900.00 420.42 1,591.66 23.07 5,308.34 101-4-5110-4108 Insurance 79,300.00 6,476.50 25,906.00 32.67 53,394.00 101-4-5110-4109 Workers Comp 12,250.00 0.00 7,657.00 62.51 4,593.00 TOTAL Personal Services 638,600.00 42,493.78 170,035.56 26.63 468,564.44 Supplies 101-4-5110-4212 Fuels & Lubes 25,000.00 1,301.31 5,036.85 20.15 19,963.15 101-4-5110-4217 Uniform Allowance 3,800.00 518.98 981.08 25.82 2,818.92 101-4-5110-4219 Operating Supplies 97,000.00 7,537.06 15,258.51 15.73 81,741.49 101-4-5110-4221 Equipment Parts 27,000.00 1,038.24 3,513.08 13.01 23,486.92 TOTAL Supplies 152,800.00 10,395.59 24,789.52 16.22 128,010.48 Other Services & Charges 101-4-5110-4321 Telephone 5,050.00 237.52 859.18 17.01 4,190.82 101-4-5110-4322 Postage 100.00 0.00 0.00 0.00 100.00 101-4-5110-4331 Travel, Conferences & Schools 4,800.00 70.00 593.50 12.36 4,206.50 101-4-5110-4361 Insurance 33,500.00 0.00 16,425.50 49.03 17,074.50 101-4-5110-4389 Utilities 76,000.00 2,228.33 7,628.21 10.04 68,371.79 101-4-5110-4401 Bldg Repair/Maint Services 2,000.00 2,103.56 2,253.56 112.68 ( 253.56) 101-4-5110-4404 Equip Repair/Maint Services 16,500.00 770.25 1,046.78 6.34 15,453.22 101-4-5110-4409 Contractual Services 45,100.00 1,041.00 1,691.00 3.75 43,409.00 101-4-5110-4415 Equipment Rental 22,200.00 1,540.00 5,999.00 27.02 16,201.00 101-4-5110-4460 Equip Replacement Charge 51,300.00 4,275.00 17,100.00 33.33 34,200.00 TOTAL Other Services & Charges 256,550.00 12,265.66 53,596.73 20.89 202,953.27 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks Department 1,047,950.00 65,155.03 248,421.81 23.71 799,528.19 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Culture & Recreation 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Parks & Rec Admin ================= Personal Services 101-4-5210-4101 Regular Pay 304,750.00 23,323.46 87,585.52 28.74 217,164.48 101-4-5210-4102 Overtime Pay 0.00 0.00 1,067.37 0.00 ( 1,067.37) 101-4-5210-4103 Part-time Pay 51,150.00 3,843.41 14,050.06 27.47 37,099.94 101-4-5210-4104 PERA 26,700.00 2,037.53 7,702.76 28.85 18,997.24 101-4-5210-4105 FICA 22,050.00 1,603.45 6,064.24 27.50 15,985.76 101-4-5210-4107 Medicare 5,150.00 375.00 1,418.24 27.54 3,731.76 101-4-5210-4108 Insurance 41,700.00 3,508.00 14,032.00 33.65 27,668.00 101-4-5210-4109 Workers Comp 3,900.00 0.00 2,022.00 51.85 1,878.00 TOTAL Personal Services 455,400.00 34,690.85 133,942.19 29.41 321,457.81 Supplies 101-4-5210-4219 Operating Supplies 8,600.00 492.69 3,824.27 44.47 4,775.73 TOTAL Supplies 8,600.00 492.69 3,824.27 44.47 4,775.73 Other Services & Charges 101-4-5210-4321 Telephone 6,750.00 339.58 838.74 12.43 5,911.26 101-4-5210-4322 Postage 5,300.00 11.97 107.14 2.02 5,192.86 101-4-5210-4331 Travel, Conferences & Schools 8,850.00 61.90 288.94 3.26 8,561.06 101-4-5210-4349 Advertising/Marketing 33,200.00 195.00 744.50 2.24 32,455.50 101-4-5210-4361 Insurance 450.00 0.00 213.50 47.44 236.50 101-4-5210-4389 Utilities 11,300.00 599.94 2,776.28 24.57 8,523.72 101-4-5210-4401 Bldg Repair/Maint Services 17,200.00 1,596.48 4,986.44 28.99 12,213.56 101-4-5210-4404 Equip Repair/Maint Services 8,600.00 16.75 6,493.24 75.50 2,106.76 101-4-5210-4433 Dues & Subscriptions 2,300.00 0.00 2,290.00 99.57 10.00 TOTAL Other Services & Charges 93,950.00 2,821.62 18,738.78 19.95 75,211.22 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks & Rec Admin 557,950.00 38,005.16 156,505.24 28.05 401,444.76 Recreation Programs =================== Personal Services 101-4-5220-4103 Part-time Pay 82,000.00 2,526.93 11,444.84 13.96 70,555.16 101-4-5220-4104 PERA 1,900.00 171.57 613.99 32.32 1,286.01 101-4-5220-4105 FICA 5,100.00 156.67 709.57 13.91 4,390.43 101-4-5220-4107 Medicare 1,200.00 36.64 165.94 13.83 1,034.06 TOTAL Personal Services 90,200.00 2,891.81 12,934.34 14.34 77,265.66 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Culture & Recreation 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-5220-4219 Operating Supplies 25,000.00 827.84 1,180.94 4.72 23,819.06 TOTAL Supplies 25,000.00 827.84 1,180.94 4.72 23,819.06 Other Services & Charges 101-4-5220-4409 Contractual Services 54,000.00 240.50 4,850.50 8.98 49,149.50 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 580.96 892.45 24.79 2,707.55 TOTAL Other Services & Charges 59,250.00 821.46 5,742.95 9.69 53,507.05 ___________________________________________________________________________________________________________________ TOTAL Recreation Programs 174,450.00 4,541.11 19,858.23 11.38 154,591.77 Concessions =========== Personal Services _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ Sr Citizen Programs =================== Personal Services 101-4-5510-4101 Regular Pay 124,600.00 9,583.99 35,939.99 28.84 88,660.01 101-4-5510-4103 Part-time Pay 9,750.00 750.00 2,706.00 27.75 7,044.00 101-4-5510-4104 PERA 10,100.00 718.80 2,695.50 26.69 7,404.50 101-4-5510-4105 FICA 8,350.00 635.52 2,376.59 28.46 5,973.41 101-4-5510-4107 Medicare 1,950.00 148.63 555.81 28.50 1,394.19 101-4-5510-4108 Insurance 23,000.00 1,583.00 6,332.00 27.53 16,668.00 101-4-5510-4109 Workers Comp 650.00 0.00 285.50 43.92 364.50 TOTAL Personal Services 178,400.00 13,419.94 50,891.39 28.53 127,508.61 Supplies 101-4-5510-4219 Operating Supplies 10,750.00 726.53 2,192.80 20.40 8,557.20 TOTAL Supplies 10,750.00 726.53 2,192.80 20.40 8,557.20 Other Services & Charges 101-4-5510-4321 Telephone 2,400.00 23.36 335.11 13.96 2,064.89 101-4-5510-4322 Postage 3,000.00 0.00 874.91 29.16 2,125.09 101-4-5510-4331 Travel, Conferences & Schools 3,100.00 0.00 304.06 9.81 2,795.94 101-4-5510-4361 Insurance 1,350.00 0.00 646.00 47.85 704.00 101-4-5510-4389 Utilities 21,300.00 1,481.07 5,232.54 24.57 16,067.46 101-4-5510-4401 Bldg Repair/Maint Services 16,500.00 769.00 4,229.63 25.63 12,270.37 101-4-5510-4404 Equip Repair/Maint Services 100.00 16.75 16.75 16.75 83.25 101-4-5510-4409 Contractual Services 11,900.00 1,792.52 7,065.67 59.38 4,834.33 101-4-5510-4433 Dues & Subscriptions 800.00 0.00 147.24 18.41 652.76 TOTAL Other Services & Charges 60,450.00 4,082.70 18,851.91 31.19 41,598.09 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Culture & Recreation 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Sr Citizen Programs 249,600.00 18,229.17 71,936.10 28.82 177,663.90 ___________________________________________________________________________________________________________________ TOTAL Culture & Recreation 2,029,950.00 125,930.47 496,721.38 24.47 1,533,228.62 Economic Development ==================== Personal Services 101-4-6210-4101 Regular Pay 0.00 ( 4,513.07) 15,795.78 0.00 ( 15,795.78) 101-4-6210-4103 Part-time Pay 0.00 0.00 1,050.00 0.00 ( 1,050.00) 101-4-6210-4104 PERA 0.00 ( 323.48) 1,199.68 0.00 ( 1,199.68) 101-4-6210-4105 FICA 0.00 ( 279.79) 1,000.33 0.00 ( 1,000.33) 101-4-6210-4107 Medicare 0.00 ( 65.39) 238.31 0.00 ( 238.31) 101-4-6210-4108 Insurance 0.00 ( 649.20) 2,272.20 0.00 ( 2,272.20) 101-4-6210-4109 Workers Comp 0.00 ( 127.00) 0.00 0.00 0.00 TOTAL Personal Services 0.00 ( 5,957.93) 21,556.30 0.00 ( 21,556.30) Other Services & Charges 101-4-6210-4440 Miscellaneous 0.00 ( 309.88) 48.48 0.00 ( 48.48) TOTAL Other Services & Charges 0.00 ( 309.88) 48.48 0.00 ( 48.48) ___________________________________________________________________________________________________________________ TOTAL Economic Development 0.00 ( 6,267.81) 21,604.78 0.00 ( 21,604.78) Energy City =========== Personal Services 101-4-6220-4101 Regular Pay 19,150.00 1,274.09 4,696.21 24.52 14,453.79 101-4-6220-4104 PERA 1,450.00 95.56 222.84 15.37 1,227.16 101-4-6220-4105 FICA 1,200.00 79.16 291.33 24.28 908.67 101-4-6220-4107 Medicare 300.00 18.52 68.14 22.71 231.86 101-4-6220-4108 Insurance 2,400.00 188.56 389.12 16.21 2,010.88 TOTAL Personal Services 24,500.00 1,655.89 5,667.64 23.13 18,832.36 Supplies 101-4-6220-4219 Operating Supplies 300.00 0.00 0.00 0.00 300.00 TOTAL Supplies 300.00 0.00 0.00 0.00 300.00 Other Services & Charges 101-4-6220-4319 Other Professional Services 2,500.00 0.00 0.00 0.00 2,500.00 101-4-6220-4331 Travel, Conferences & Schools 5,500.00 0.00 0.00 0.00 5,500.00 101-4-6220-4359 Publishing 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL Other Services & Charges 9,000.00 0.00 0.00 0.00 9,000.00 ___________________________________________________________________________________________________________________ TOTAL Energy City 33,800.00 1,655.89 5,667.64 16.77 28,132.36 5-10-2017 02:08 PM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2017 101-GENERAL FUND Economic Development 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL Economic Development 33,800.00 ( 4,611.92) 27,272.42 80.69 6,527.58 Transfers Out ============= Transfers Out _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL EXPENDITURES 14,378,400.00 999,624.85 4,018,116.55 27.95 10,360,283.45 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 750,399.16)( 2,766,655.08) 2,766,655.08 Current Budget Year to Date Actual Budget Variance % of Budget Current Budget Year to Date Actual Budget Variance % of Budget Current Budget Year to Date Actual Budget Variance % of Budget Current Budget Year to Date Actual Budget Variance % of Budget Sales and cost of sales: Sales 7,004,150$ 2,005,297$ 4,998,853$ 28.63% Cost of sales (5,008,100) (1,046,509) (3,961,591) 20.90% Gross profit 1,996,050 958,788 1,037,262 48.03% Operating revenues: User charges - - - 0.00%1,915,000$ 478,214$ 1,436,786$ 24.97%1,366,000$ 333,805$ 1,032,195$ 24.44%445,000$ 114,011$ 330,989$ 25.62% Delinquency collections - - - 0.00%2,000 - 2,000 0.00%10,500 - 10,500 0.00%- - - 0.00% Other 1,700 1,300 400 76.47%2,000 - 2,000 0.00%2,500 364 2,136 14.56%- - - 0.00% Total operating revenues 1,700 1,300 400 76.47%1,919,000 478,214 1,440,786 24.92%1,379,000 334,169 1,044,831 24.23%445,000 114,011 330,989 25.62% Operating expenses: Personal services 663,300 198,180 465,120 29.88%555,800 165,467 390,333 29.77%24,450 5,667 18,783 23.18%86,000 22,597 63,403 26.28% Supplies 20,700 3,786 16,914 18.29%206,800 26,441 180,359 12.79%21,400 54 21,346 0.25%2,000 - 2,000 0.00% Other service charges 241,500 57,510 183,990 23.81%552,000 137,927 414,073 24.99%1,457,200 352,543 1,104,657 24.19%458,200 209,147 249,053 45.65% Depreciation *125,000 - 125,000 0.00%1,425,000 - 1,425,000 0.00%- - - 0.00%448,000 - 448,000 0.00% Total operating expenses 1,050,500 259,476 791,024 24.70%2,739,600 329,835 2,409,765 12.04%1,503,050 358,264 1,144,786 23.84%994,200 231,744 762,456 23.31% Operating income (loss)947,250 700,612 246,638 73.96%(820,600) 148,379 (968,979) -18.08%(124,050) (24,095) (99,955) 19.42%(549,200) (117,733) (431,467) 21.44% Nonoperating revenues (expenses): Interest income 35,000 16,566 18,434 47.33%80,000 16,857 63,143 21.07%8,000 1,473 6,527 18.41%4,000 2,067 1,933 51.68% Grant revenue - - - 0.00%- 40,887 (40,887) 0.00%- - - 0.00%- - - 0.00% Interest expense - - - 0.00%(264,350) (22,368) (241,982) 8.46%- - - 0.00%- - - 0.00% Total nonoperating revenues (expenses)35,000 16,566 18,434 47.33%(184,350) 35,376 (219,726) -19.19%8,000 1,473 6,527 18.41%4,000 2,067 1,933 51.68% Income (loss) before contributions and transfers 982,250 717,178 265,072 73.01%(1,004,950) 183,755 (1,188,705) -18.28%(116,050) (22,622) (93,428) 19.49%(545,200) (115,666) (429,534) 21.22% Contributions - connection fees - - - 0.00%500,000 373,705 126,295 74.74%- - - 0.00%53,000 27,837 25,163 52.52% Transfers in - - - 0.00%- - - 0.00%44,600 - 44,600 0.00%- - - 0.00% Transfers out (762,850) - (762,850) 0.00%(125,000) - (125,000) 0.00%(46,150) - (46,150) 0.00%(15,000) - (15,000) 0.00% NET INCOME (LOSS)219,400 717,178 (497,778) 326.88%(629,950) 557,460 (1,187,410) -88.49%(117,600) (22,622) (94,978) 19.24%(507,200) (87,829) (419,371) 17.32% Items reclassified to balance sheet at year end: Capital Outlay (100,500) (821,370) 720,870 817.28%(150,000) - (150,000) 0.00% Bond Payment (405,000) (405,000) - 100.00% Revenues over/(under) expenditures 219,400 717,178 (497,778) (1,135,450) (668,910) (466,540) (117,600) (22,622) (94,978) (657,200) (87,829) (569,371) 13.36% * Recorded at yearend Stormwater CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED APRIL 30, 2017 Liquor Sewer Garbage 5-10-2017 02:12 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: APRIL 30TH, 2017 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE ___________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 18,792.67 895.19 19,687.86 101-1010 Cash - General Fund 4,538,388.38 ( 692,703.76) 3,845,684.62 211-1010 Cash - Library 414,558.85 24,107.41 438,666.26 221-1010 Cash - Ice Arena 604,806.48 ( 8,916.29) 595,890.19 222-1010 Cash - Pinewood Golf Course ( 53.77) ( 2.73) ( 56.50) 225-1010 Cash - Park Dedication 116,516.49 0.00 116,516.49 228-1010 Cash - Landfill 419,187.67 511.05 419,698.72 231-1010 Cash - Landfill Const Debris 742,081.34 0.00 742,081.34 240-1010 Cash - Micro Loan Fund 611,427.17 7,085.56 618,512.73 242-1010 Cash - State DEED 126,138.03 1,886.49 128,024.52 245-1010 Cash - Development Fund 993,800.01 140,640.48 1,134,440.49 290-1010 Cash - Capital Outlay Reserve 766,755.83 26,350.54 793,106.37 291-1010 Cash - Insurance Reserve 188,767.02 ( 4,354.34) 184,412.68 292-1010 Cash - Govt Bldgs Reserve 1,785,866.16 ( 7,881.00) 1,777,985.16 294-1010 Cash - Drug Forfeiture 20,400.06 ( 5,053.02) 15,347.04 295-1010 Cash - Severance Pay Reserve 72,501.64 0.00 72,501.64 296-1010 Cash - GRE Reserve 1,977,644.70 ( 20,000.00) 1,957,644.70 313-1010 Cash - 2007C/2012B GO Bonds 112,134.67 ( 450.00) 111,684.67 333-1010 Cash - 2010A GO Cap Imp Bonds 299,487.23 0.00 299,487.23 345-1010 Cash - 2012A CIP Bonds-PW 0.00 ( 450.00) ( 450.00) 401-1010 Cash - Pavement Mgmt 3,993,162.86 348,667.17 4,341,830.03 403-1010 Cash - Street Improvement 1,022,914.91 0.00 1,022,914.91 406-1010 Cash - City Wide Trunk Util 3,734,027.54 0.00 3,734,027.54 410-1010 Cash - Equipment Replacement 949,875.74 ( 128,502.28) 821,373.46 440-1010 Cash - Park Improvement 410,401.77 ( 10.87) 410,390.90 463-1010 Cash - TIF #23 Pref Powder 1,194.07 0.00 1,194.07 602-1010 Cash - Wastewater Treatment 3,724,308.47 ( 366,993.42) 3,357,315.05 603-1010 Cash - Liquor 3,573,876.74 154,582.74 3,728,459.48 605-1010 Cash - Garbage 396,065.53 ( 11,098.31) 384,967.22 607-1010 Cash - Storm Water 336,236.74 29,643.26 365,880.00 801-1010 Cash - Interest 0.00 28,067.58 28,067.58 821-1010 Cash - Developer Escrow 341,637.04 ( 1,673.00) 339,964.04_ TOTAL CLAIM ON CASH 32,292,902.04 ( 485,651.55) 31,807,250.49 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 83,300,352.75 434,100.62 83,734,453.37 999-1001 PY BANK ACCOUNT (79,389,640.27) ( 919,752.17) (80,309,392.44) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56_ SUBTOTAL CASH IN BANK - POOLED CASH 32,292,902.04 ( 485,651.55) 31,807,250.49 WAGES PAYABLE _______________ ______________ ______________ TOTAL CASH IN BANK - POOLED CASH 32,292,902.04 ( 485,651.55) 31,807,250.49 =============== ============== ==============