Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 02-20-2018
Information �i of Memorandum Memorandum cElk River TO: Mayor and City Council From: Jesse Dorn,Assistant Finance Director Date: February 20, 2018 Subject: January 2018 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund, the Ice Arena Special Revenue Fund, and the Enterprise Funds. These funds provide an important picture of the city's financial health. For the month of January, actual revenues (excluding property taxes and transfers in) and expenditures should run about 8% of the annual budget. It is natural for some of the items to vary from month to month, such as exceeding budget for Supplies but being below budget 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 property taxes and transfers in,revenue collections are 6% of budget. ■ Licenses and permits collections are 4% of budget and are anticipated to ramp up with the spring construction season. ■ Intergovernmental revenue collections are 2% of budget, consisting of the water tower grant from the MN Historical Society. ■ Charges for services are 9% of budget estimates,most of that coming from the semi- annual payment for school liaison services. ■ Fines and forfeits collections consist of parking fines since court fine collections lag a month. ■ Other revenues include the Bank of Elk River's 2018 sponsorship of$16,000 to support the summer concert programming. p 0 W I R L a N' AfURE] Expenditures: ■ Total departmental expenditures are about 6% of budget and most departments are below budget estimates. ■ Reflected in many departments'budgets are the quarterly worker's comp and liability insurance premiums, as well as the renewal of annual software maintenance contracts that were paid in January. 01 2018 Monthly Expenditures $16,000 — $14,000 o $12,000 Q $10,000 D z $8,000 $6,000 $4,000 $2,000 Actual $947 Budget $1,269 $2,538 $3,807 $5,077 $6,346 $7,615 1$8,884 $10,153$11,422$12,691$13,960$15,230 ICE ARENA As of the end of January,revenues of$32,443 exceeded expenditures of$28,437 by$4,006. January revenues consist mainly of recreation fees for hockey and skating, as well as concessions. ATTACHMENTS ■ General Fund Revenue &Expense Report ■ Enterprise Funds—Budget to Actual ■ Cash Report—All Funds 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND FINANCIAL SUMMARY 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ REVENUE SUMMARY General Fund 15,229,550.00 146,878.84 146,878.84 0.96 15,082,671.16 TOTAL REVENUES 15,229,550.00 146,878.84 146,878.84 0.96 15,082,671.16 ============= ============= ============= ======= ============= EXPENDITURE SUMMARY General Government Mayor & Council 155,300.00 14,149.27 14,149.27 9.11 141,150.73 Cable TV 306,900.00 5,280.53 5,280.53 1.72 301,619.47 Administrative Services 511,900.00 30,531.32 30,531.32 5.96 481,368.68 Human Resources 250,550.00 9,518.48 9,518.48 3.80 241,031.52 Elections 42,250.00 0.00 0.00 0.00 42,250.00 Finance 586,250.00 42,794.06 42,794.06 7.30 543,455.94 Information Technology 431,300.00 14,770.98 14,770.98 3.42 416,529.02 Legal 230,000.00 0.00 0.00 0.00 230,000.00 Community Development 150,050.00 9,829.88 9,829.88 6.55 140,220.12 Planning 405,800.00 22,586.82 22,586.82 5.57 383,213.18 City Hall Maintenance 668,250.00 35,332.96 35,332.96 5.29 632,917.04 Contingency 53,450.00 0.00 0.00 0.00 53,450.00 TOTAL General Government 3,792,000.00 184,794.30 184,794.30 4.87 3,607,205.70 Public Safety Police Administration 796,650.00 118,362.14 118,362.14 14.86 678,287.86 Patrol 2,721,300.00 151,046.22 151,046.22 5.55 2,570,253.78 Investigations 1,053,850.00 56,143.54 56,143.54 5.33 997,706.46 Police Support Services 711,500.00 38,582.56 38,582.56 5.42 672,917.44 Police Reserves 19,750.00 48.77 48.77 0.25 19,701.23 Public safety building 167,000.00 9,216.57 9,216.57 5.52 157,783.43 Fire Administration 507,200.00 32,951.53 32,951.53 6.50 474,248.47 Fire Operations 420,800.00 30,740.38 30,740.38 7.31 390,059.62 Emergency Management 27,000.00 134.91 134.91 0.50 26,865.09 Building Safety 678,450.00 34,188.45 34,188.45 5.04 644,261.55 Code Enforcement 98,750.00 5,479.79 5,479.79 5.55 93,270.21 Environmental 48,400.00 1,413.81 1,413.81 2.92 46,986.19 TOTAL Public Safety 7,250,650.00 478,308.67 478,308.67 6.60 6,772,341.33 Public Works Street Maintenance 1,333,250.00 67,653.06 67,653.06 5.07 1,265,596.94 Snow Removal 298,700.00 61,532.66 61,532.66 20.60 237,167.34 Equipment Services 205,650.00 9,322.80 9,322.80 4.53 196,327.20 Engineering 234,200.00 12,538.30 12,538.30 5.35 221,661.70 TOTAL Public Works 2,071,800.00 151,046.82 151,046.82 7.29 1,920,753.18 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND FINANCIAL SUMMARY 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Culture & Recreation Parks Department 1,103,800.00 58,037.46 58,037.46 5.26 1,045,762.54 Parks & Rec Admin 595,450.00 43,674.00 43,674.00 7.33 551,776.00 Recreation Programs 131,350.00 440.98 440.98 0.34 130,909.02 Sr Citizen Programs 251,500.00 11,875.23 11,875.23 4.72 239,624.77 TOTAL Culture & Recreation 2,082,100.00 114,027.67 114,027.67 5.48 1,968,072.33 Economic Development Economic Development 0.00 17,098.84 17,098.84 0.00 ( 17,098.84) Energy City 33,000.00 1,356.10 1,356.10 4.11 31,643.90 TOTAL Economic Development 33,000.00 18,454.94 18,454.94 55.92 14,545.06 General _____________ _____________ _____________ _______ _____________ TOTAL EXPENDITURES 15,229,550.00 946,632.40 946,632.40 6.22 14,282,917.60 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 799,753.56)( 799,753.56) 799,753.56 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND 08.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 10,497,800.00 0.00 0.00 0.00 10,497,800.00 101-3-0000-3121 Gravel Tax 150,000.00 0.00 0.00 0.00 150,000.00 TOTAL Taxes 10,647,800.00 0.00 0.00 0.00 10,647,800.00 Licenses & Permits 101-3-0000-3211 Liquor License 70,000.00 180.00 180.00 0.26 69,820.00 101-3-0000-3213 Cigarette License 2,800.00 0.00 0.00 0.00 2,800.00 101-3-0000-3214 Rental License 65,000.00 3,768.00 3,768.00 5.80 61,232.00 101-3-0000-3216 Mining License 23,000.00 0.00 0.00 0.00 23,000.00 101-3-0000-3217 Garbage Hauler License 1,600.00 75.00 75.00 4.69 1,525.00 101-3-0000-3218 Other Business License/Permit 13,000.00 540.00 540.00 4.15 12,460.00 101-3-0000-3229 NPDES Permit 12,000.00 700.00 700.00 5.83 11,300.00 101-3-0000-3231 Building Permit 480,000.00 22,141.59 22,141.59 4.61 457,858.41 101-3-0000-3232 Plumbing/Heating Permit 195,000.00 3,836.55 3,836.55 1.97 191,163.45 101-3-0000-3233 Permit Surcharge 1,000.00 1,759.02 1,759.02 175.90 ( 759.02) 101-3-0000-3235 Animal License 5,500.00 560.00 560.00 10.18 4,940.00 101-3-0000-3237 Other Non-Business Lic/Permit 9,000.00 520.00 520.00 5.78 8,480.00 TOTAL Licenses & Permits 877,900.00 34,080.16 34,080.16 3.88 843,819.84 Intergovernmental Rev 101-3-0000-3322 MV Credit 5,500.00 0.00 0.00 0.00 5,500.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 270,000.00 0.00 0.00 0.00 270,000.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 0.00 0.00 0.00 25,000.00 101-3-0000-3330 Other State Grants 0.00 7,250.00 7,250.00 0.00 ( 7,250.00) TOTAL Intergovernmental Rev 324,500.00 7,250.00 7,250.00 2.23 317,250.00 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 32,000.00 2,087.50 2,087.50 6.52 29,912.50 101-3-0000-3413 Plan Check Fee 200,000.00 12,645.11 12,645.11 6.32 187,354.89 101-3-0000-3415 Special Assessment Search 800.00 0.00 0.00 0.00 800.00 101-3-0000-3417 Copies 2,500.00 321.75 321.75 12.87 2,178.25 101-3-0000-3418 Other General Govt Services 5,000.00 13.00 13.00 0.26 4,987.00 101-3-0000-3430 Lockout Fees 6,500.00 540.00 540.00 8.31 5,960.00 101-3-0000-3431 Police Services 9,000.00 20.00 20.00 0.22 8,980.00 101-3-0000-3432 School Liaison 130,000.00 61,812.00 61,812.00 47.55 68,188.00 101-3-0000-3434 Animal Impound Fee 4,000.00 150.00 150.00 3.75 3,850.00 101-3-0000-3436 Fire Contracts 255,000.00 0.00 0.00 0.00 255,000.00 101-3-0000-3437 Fire Services 2,000.00 7.85 7.85 0.39 1,992.15 101-3-0000-3451 Street Services 20,000.00 210.00 210.00 1.05 19,790.00 101-3-0000-3452 Engineering Services Reimb 125,000.00 0.00 0.00 0.00 125,000.00 101-3-0000-3461 Recreation Fees 75,000.00 2,160.91 2,160.91 2.88 72,839.09 101-3-0000-3462 Sr Center Activities 35,000.00 3,174.00 3,174.00 9.07 31,826.00 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-3-0000-3472 Park Use Fee 24,000.00 2,655.00 2,655.00 11.06 21,345.00 101-3-0000-3475 Building Rent 2,400.00 200.00 200.00 8.33 2,200.00 101-3-0000-3483 Sewer Inspection Fee 9,000.00 345.00 345.00 3.83 8,655.00 101-3-0000-3484 Contractor License Check 700.00 45.00 45.00 6.43 655.00 TOTAL Charges for Services 937,900.00 86,387.12 86,387.12 9.21 851,512.88 Fines & Forfeits 101-3-0000-3510 Court Fines 145,000.00 0.00 0.00 0.00 145,000.00 101-3-0000-3511 Parking Fines 6,000.00 2,080.00 2,080.00 34.67 3,920.00 TOTAL Fines & Forfeits 151,000.00 2,080.00 2,080.00 1.38 148,920.00 Special Assessments 101-3-0000-3610 Special Assmts-County 0.00 73.38 73.38 0.00 ( 73.38) TOTAL Special Assessments 0.00 73.38 73.38 0.00 ( 73.38) Other Revenue 101-3-0000-3621 Interest Income 90,000.00 0.00 0.00 0.00 90,000.00 101-3-0000-3625 Refunds & Reimbursements 110,000.00 32.85 32.85 0.03 109,967.15 101-3-0000-3626 Contributions 20,000.00 16,000.00 16,000.00 80.00 4,000.00 101-3-0000-3629 Miscellaneous Revenue 6,500.00 975.33 975.33 15.01 5,524.67 TOTAL Other Revenue 226,500.00 17,008.18 17,008.18 7.51 209,491.82 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 13,600.00 0.00 0.00 0.00 13,600.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 150,000.00 0.00 0.00 0.00 150,000.00 101-3-0000-3943 Transfer-Liquor 492,000.00 0.00 0.00 0.00 492,000.00 101-3-0000-3944 Transfer-Garbage 46,750.00 0.00 0.00 0.00 46,750.00 101-3-0000-3945 Transfer-Utilities 1,165,000.00 0.00 0.00 0.00 1,165,000.00 101-3-0000-3946 Transfer-Stormwater 15,000.00 0.00 0.00 0.00 15,000.00 101-3-0000-3948 Transfer-EDA 36,600.00 0.00 0.00 0.00 36,600.00 101-3-0000-3949 Transfer-HRA 30,000.00 0.00 0.00 0.00 30,000.00 TOTAL Transfers In 2,063,950.00 0.00 0.00 0.00 2,063,950.00 _____________________________________________________________________________ TOTAL General Fund 15,229,550.00 146,878.84 146,878.84 0.96 15,082,671.16 ___________________________________________________________________________________________________________________ TOTAL REVENUE 15,229,550.00 146,878.84 146,878.84 0.96 15,082,671.16 ============= ============= ============= ======= ============= 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND 08.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 3,208.32 8.33 35,291.68 101-4-1110-4104 PERA 1,500.00 100.01 100.01 6.67 1,399.99 101-4-1110-4105 FICA 1,000.00 74.92 74.92 7.49 925.08 101-4-1110-4107 Medicare 600.00 46.52 46.52 7.75 553.48 101-4-1110-4109 Workers Comp 100.00 13.50 13.50 13.50 86.50 TOTAL Personal Services 41,700.00 3,443.27 3,443.27 8.26 38,256.73 Supplies 101-4-1110-4201 Office Supplies 750.00 0.00 0.00 0.00 750.00 TOTAL Supplies 750.00 0.00 0.00 0.00 750.00 Other Services & Charges 101-4-1110-4319 Other Professional Services 10,500.00 350.00 350.00 3.33 10,150.00 101-4-1110-4322 Postage 50.00 0.00 0.00 0.00 50.00 101-4-1110-4331 Travel, Conferences & Schools 2,600.00 0.00 0.00 0.00 2,600.00 101-4-1110-4359 Publishing 3,700.00 0.00 0.00 0.00 3,700.00 101-4-1110-4361 Insurance 42,000.00 10,156.00 10,156.00 24.18 31,844.00 101-4-1110-4433 Dues & Subscriptions 19,550.00 0.00 0.00 0.00 19,550.00 101-4-1110-4440 Miscellaneous 34,450.00 200.00 200.00 0.58 34,250.00 TOTAL Other Services & Charges 112,850.00 10,706.00 10,706.00 9.49 102,144.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Mayor & Council 155,300.00 14,149.27 14,149.27 9.11 141,150.73 Cable TV ======== Personal Services 101-4-1120-4101 Regular Pay 192,700.00 3,841.20 3,841.20 1.99 188,858.80 101-4-1120-4103 Part-time Pay 18,850.00 545.56 545.56 2.89 18,304.44 101-4-1120-4104 PERA 16,450.00 329.00 329.00 2.00 16,121.00 101-4-1120-4105 FICA 13,300.00 259.37 259.37 1.95 13,040.63 101-4-1120-4107 Medicare 3,050.00 60.65 60.65 1.99 2,989.35 101-4-1120-4108 Insurance 20,950.00 4.50 4.50 0.02 20,945.50 101-4-1120-4109 Workers Comp 500.00 240.25 240.25 48.05 259.75 TOTAL Personal Services 265,800.00 5,280.53 5,280.53 1.99 260,519.47 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND General Government 08.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 12,600.00 0.00 0.00 0.00 12,600.00 TOTAL Supplies 12,600.00 0.00 0.00 0.00 12,600.00 Other Services & Charges 101-4-1120-4319 Other Professional Services 19,750.00 0.00 0.00 0.00 19,750.00 101-4-1120-4321 Telephone 850.00 0.00 0.00 0.00 850.00 101-4-1120-4331 Travel, Conferences & Schools 6,750.00 0.00 0.00 0.00 6,750.00 101-4-1120-4433 Dues & Subscriptions 1,150.00 0.00 0.00 0.00 1,150.00 TOTAL Other Services & Charges 28,500.00 0.00 0.00 0.00 28,500.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Cable TV 306,900.00 5,280.53 5,280.53 1.72 301,619.47 Administrative Services ======================= Personal Services 101-4-1210-4101 Regular Pay 335,350.00 20,035.70 20,035.70 5.97 315,314.30 101-4-1210-4103 Part-time Pay 49,850.00 2,533.74 2,533.74 5.08 47,316.26 101-4-1210-4104 PERA 28,900.00 1,692.69 1,692.69 5.86 27,207.31 101-4-1210-4105 FICA 24,000.00 1,438.92 1,438.92 6.00 22,561.08 101-4-1210-4107 Medicare 5,600.00 336.52 336.52 6.01 5,263.48 101-4-1210-4108 Insurance 28,250.00 1,508.00 1,508.00 5.34 26,742.00 101-4-1210-4109 Workers Comp 1,850.00 499.50 499.50 27.00 1,350.50 TOTAL Personal Services 473,800.00 28,045.07 28,045.07 5.92 445,754.93 Supplies 101-4-1210-4201 Office Supplies 7,300.00 0.00 0.00 0.00 7,300.00 TOTAL Supplies 7,300.00 0.00 0.00 0.00 7,300.00 Other Services & Charges 101-4-1210-4321 Telephone 1,950.00 0.00 0.00 0.00 1,950.00 101-4-1210-4322 Postage 800.00 0.00 0.00 0.00 800.00 101-4-1210-4331 Travel, Conferences & Schools 5,250.00 300.00 300.00 5.71 4,950.00 101-4-1210-4334 Car Allowance 4,800.00 400.00 400.00 8.33 4,400.00 101-4-1210-4361 Insurance 100.00 13.00 13.00 13.00 87.00 101-4-1210-4404 Equip Repair/Maint Services 15,750.00 1,773.25 1,773.25 11.26 13,976.75 101-4-1210-4433 Dues & Subscriptions 2,150.00 0.00 0.00 0.00 2,150.00 TOTAL Other Services & Charges 30,800.00 2,486.25 2,486.25 8.07 28,313.75 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Administrative Services 511,900.00 30,531.32 30,531.32 5.96 481,368.68 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND General Government 08.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,400.00 7,270.61 7,270.61 5.71 120,129.39 101-4-1220-4104 PERA 9,550.00 545.29 545.29 5.71 9,004.71 101-4-1220-4105 FICA 7,900.00 441.48 441.48 5.59 7,458.52 101-4-1220-4107 Medicare 1,850.00 103.25 103.25 5.58 1,746.75 101-4-1220-4108 Insurance 17,250.00 599.00 599.00 3.47 16,651.00 101-4-1220-4109 Workers Comp 600.00 160.25 160.25 26.71 439.75 TOTAL Personal Services 164,550.00 9,119.88 9,119.88 5.54 155,430.12 Supplies 101-4-1220-4201 Office Supplies 3,500.00 0.00 0.00 0.00 3,500.00 TOTAL Supplies 3,500.00 0.00 0.00 0.00 3,500.00 Other Services & Charges 101-4-1220-4319 Other Professional Services 3,750.00 198.60 198.60 5.30 3,551.40 101-4-1220-4322 Postage 400.00 0.00 0.00 0.00 400.00 101-4-1220-4331 Travel, Conferences & Schools 4,200.00 0.00 0.00 0.00 4,200.00 101-4-1220-4404 Equip Repair/Maint 73,300.00 0.00 0.00 0.00 73,300.00 101-4-1220-4433 Dues & Subscriptions 850.00 200.00 200.00 23.53 650.00 TOTAL Other Services & Charges 82,500.00 398.60 398.60 0.48 82,101.40 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Human Resources 250,550.00 9,518.48 9,518.48 3.80 241,031.52 Elections ========= Personal Services 101-4-1230-4103 Part-time Pay 30,000.00 0.00 0.00 0.00 30,000.00 TOTAL Personal Services 30,000.00 0.00 0.00 0.00 30,000.00 Supplies 101-4-1230-4219 Operating Supplies 3,600.00 0.00 0.00 0.00 3,600.00 TOTAL Supplies 3,600.00 0.00 0.00 0.00 3,600.00 Other Services & Charges 101-4-1230-4322 Postage 200.00 0.00 0.00 0.00 200.00 101-4-1230-4331 Travel, Conferences & Schools 150.00 0.00 0.00 0.00 150.00 101-4-1230-4359 Publishing 700.00 0.00 0.00 0.00 700.00 101-4-1230-4404 Equip Repair/Maint Services 6,800.00 0.00 0.00 0.00 6,800.00 101-4-1230-4415 Equipment Rental 800.00 0.00 0.00 0.00 800.00 TOTAL Other Services & Charges 8,650.00 0.00 0.00 0.00 8,650.00 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND General Government 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Elections 42,250.00 0.00 0.00 0.00 42,250.00 Finance ======= Personal Services 101-4-1310-4101 Regular Pay 314,700.00 18,143.35 18,143.35 5.77 296,556.65 101-4-1310-4103 Part-time Pay 55,850.00 3,815.59 3,815.59 6.83 52,034.41 101-4-1310-4104 PERA 27,800.00 1,646.92 1,646.92 5.92 26,153.08 101-4-1310-4105 FICA 23,000.00 1,282.92 1,282.92 5.58 21,717.08 101-4-1310-4107 Medicare 5,400.00 300.03 300.03 5.56 5,099.97 101-4-1310-4108 Insurance 40,100.00 2,629.50 2,629.50 6.56 37,470.50 101-4-1310-4109 Workers Comp 1,700.00 466.00 466.00 27.41 1,234.00 TOTAL Personal Services 468,550.00 28,284.31 28,284.31 6.04 440,265.69 Supplies 101-4-1310-4201 Office Supplies 7,000.00 0.00 0.00 0.00 7,000.00 TOTAL Supplies 7,000.00 0.00 0.00 0.00 7,000.00 Other Services & Charges 101-4-1310-4301 Audit Fees 19,250.00 0.00 0.00 0.00 19,250.00 101-4-1310-4319 Other Professional Services 54,000.00 0.00 0.00 0.00 54,000.00 101-4-1310-4321 Telephone 900.00 0.00 0.00 0.00 900.00 101-4-1310-4322 Postage 2,900.00 0.00 0.00 0.00 2,900.00 101-4-1310-4331 Travel, Conferences & Schools 4,300.00 0.00 0.00 0.00 4,300.00 101-4-1310-4359 Publishing 450.00 0.00 0.00 0.00 450.00 101-4-1310-4404 Equip Repair/Maint Services 18,550.00 14,357.95 14,357.95 77.40 4,192.05 101-4-1310-4433 Dues & Subscriptions 1,850.00 50.00 50.00 2.70 1,800.00 101-4-1310-4438 Credit Card Fees 7,000.00 0.00 0.00 0.00 7,000.00 101-4-1310-4440 Miscellaneous 1,500.00 101.80 101.80 6.79 1,398.20 TOTAL Other Services & Charges 110,700.00 14,509.75 14,509.75 13.11 96,190.25 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Finance 586,250.00 42,794.06 42,794.06 7.30 543,455.94 Information Technology ====================== Personal Services 101-4-1350-4101 Regular Pay 202,800.00 8,644.96 8,644.96 4.26 194,155.04 101-4-1350-4104 PERA 15,200.00 648.37 648.37 4.27 14,551.63 101-4-1350-4105 FICA 12,600.00 508.76 508.76 4.04 12,091.24 101-4-1350-4107 Medicare 2,950.00 118.99 118.99 4.03 2,831.01 101-4-1350-4108 Insurance 33,250.00 596.76 596.76 1.79 32,653.24 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND General Government 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-4-1350-4109 Workers Comp 950.00 255.00 255.00 26.84 695.00 TOTAL Personal Services 267,750.00 10,772.84 10,772.84 4.02 256,977.16 Supplies 101-4-1350-4219 Operating Supplies 19,300.00 507.58 507.58 2.63 18,792.42 TOTAL Supplies 19,300.00 507.58 507.58 2.63 18,792.42 Other Services & Charges 101-4-1350-4319 Other Professional Services 11,000.00 0.00 0.00 0.00 11,000.00 101-4-1350-4321 Telephone 2,800.00 0.00 0.00 0.00 2,800.00 101-4-1350-4331 Travel, Conferences & Schools 12,750.00 0.00 0.00 0.00 12,750.00 101-4-1350-4404 Equip Repair/Maint Services 117,700.00 3,490.56 3,490.56 2.97 114,209.44 TOTAL Other Services & Charges 144,250.00 3,490.56 3,490.56 2.42 140,759.44 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Information Technology 431,300.00 14,770.98 14,770.98 3.42 416,529.02 Legal ===== Other Services & Charges 101-4-1400-4304 Legal Fees 230,000.00 0.00 0.00 0.00 230,000.00 TOTAL Other Services & Charges 230,000.00 0.00 0.00 0.00 230,000.00 ___________________________________________________________________________________________________________________ TOTAL Legal 230,000.00 0.00 0.00 0.00 230,000.00 Community Development ===================== Personal Services 101-4-1500-4101 Regular Pay 118,350.00 6,828.40 6,828.40 5.77 111,521.60 101-4-1500-4104 PERA 8,900.00 512.13 512.13 5.75 8,387.87 101-4-1500-4105 FICA 7,350.00 410.98 410.98 5.59 6,939.02 101-4-1500-4107 Medicare 1,700.00 96.12 96.12 5.65 1,603.88 101-4-1500-4108 Insurance 8,650.00 1,549.50 1,549.50 17.91 7,100.50 101-4-1500-4109 Workers Comp 550.00 148.75 148.75 27.05 401.25 TOTAL Personal Services 145,500.00 9,545.88 9,545.88 6.56 135,954.12 Supplies 101-4-1500-4201 Office Supplies 600.00 0.00 0.00 0.00 600.00 TOTAL Supplies 600.00 0.00 0.00 0.00 600.00 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND General Government 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-1500-4321 Telephone 800.00 0.00 0.00 0.00 800.00 101-4-1500-4331 Travel, Conferences & Schools 2,600.00 135.00 135.00 5.19 2,465.00 101-4-1500-4433 Dues & Subscriptions 550.00 149.00 149.00 27.09 401.00 TOTAL Other Services & Charges 3,950.00 284.00 284.00 7.19 3,666.00 ___________________________________________________________________________________________________________________ TOTAL Community Development 150,050.00 9,829.88 9,829.88 6.55 140,220.12 Planning ======== Personal Services 101-4-1510-4101 Regular Pay 290,500.00 16,595.79 16,595.79 5.71 273,904.21 101-4-1510-4103 Part-time Pay 9,350.00 0.00 0.00 0.00 9,350.00 101-4-1510-4104 PERA 21,800.00 1,244.68 1,244.68 5.71 20,555.32 101-4-1510-4105 FICA 18,600.00 982.99 982.99 5.28 17,617.01 101-4-1510-4107 Medicare 4,350.00 229.89 229.89 5.28 4,120.11 101-4-1510-4108 Insurance 37,250.00 3,043.00 3,043.00 8.17 34,207.00 101-4-1510-4109 Workers Comp 1,100.00 296.25 296.25 26.93 803.75 TOTAL Personal Services 382,950.00 22,392.60 22,392.60 5.85 360,557.40 Supplies 101-4-1510-4201 Office Supplies 2,500.00 0.00 0.00 0.00 2,500.00 101-4-1510-4212 Fuels & Lubes 300.00 7.22 7.22 2.41 292.78 101-4-1510-4219 Operating Supplies 2,000.00 0.00 0.00 0.00 2,000.00 TOTAL Supplies 4,800.00 7.22 7.22 0.15 4,792.78 Other Services & Charges 101-4-1510-4321 Telephone 350.00 0.00 0.00 0.00 350.00 101-4-1510-4322 Postage 1,300.00 0.00 0.00 0.00 1,300.00 101-4-1510-4331 Travel, Conferences & Schools 3,300.00 174.00 174.00 5.27 3,126.00 101-4-1510-4359 Publishing 10,000.00 0.00 0.00 0.00 10,000.00 101-4-1510-4361 Insurance 100.00 13.00 13.00 13.00 87.00 101-4-1510-4404 Equip Repair/Maint Services 1,500.00 0.00 0.00 0.00 1,500.00 101-4-1510-4433 Dues & Subscriptions 1,000.00 0.00 0.00 0.00 1,000.00 101-4-1510-4440 Miscellaneous 500.00 0.00 0.00 0.00 500.00 TOTAL Other Services & Charges 18,050.00 187.00 187.00 1.04 17,863.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Planning 405,800.00 22,586.82 22,586.82 5.57 383,213.18 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND General Government 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ City Hall Maintenance ===================== Personal Services 101-4-1600-4101 Regular Pay 357,600.00 20,635.21 20,635.21 5.77 336,964.79 101-4-1600-4102 Overtime Pay 3,500.00 0.00 0.00 0.00 3,500.00 101-4-1600-4103 Part-time Pay 3,650.00 0.00 0.00 0.00 3,650.00 101-4-1600-4104 PERA 27,100.00 1,547.63 1,547.63 5.71 25,552.37 101-4-1600-4105 FICA 22,600.00 1,285.40 1,285.40 5.69 21,314.60 101-4-1600-4107 Medicare 5,300.00 300.63 300.63 5.67 4,999.37 101-4-1600-4108 Insurance 50,950.00 2,959.10 2,959.10 5.81 47,990.90 101-4-1600-4109 Workers Comp 12,050.00 3,346.25 3,346.25 27.77 8,703.75 TOTAL Personal Services 482,750.00 30,074.22 30,074.22 6.23 452,675.78 Supplies 101-4-1600-4212 Fuels & Lubes 3,000.00 285.25 285.25 9.51 2,714.75 101-4-1600-4217 Uniform Allowance 2,200.00 0.00 0.00 0.00 2,200.00 101-4-1600-4219 Operating Supplies 33,500.00 0.00 0.00 0.00 33,500.00 TOTAL Supplies 38,700.00 285.25 285.25 0.74 38,414.75 Other Services & Charges 101-4-1600-4321 Telephone 12,850.00 0.00 0.00 0.00 12,850.00 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 0.00 0.00 0.00 2,000.00 101-4-1600-4361 Insurance 5,500.00 1,228.00 1,228.00 22.33 4,272.00 101-4-1600-4389 Utilities 75,750.00 2,916.97 2,916.97 3.85 72,833.03 101-4-1600-4401 Bldg Repair/Maint Services 40,800.00 503.52 503.52 1.23 40,296.48 101-4-1600-4404 Equip Repair/Maint Services 6,000.00 0.00 0.00 0.00 6,000.00 101-4-1600-4460 Equip Replacement Charge 3,900.00 325.00 325.00 8.33 3,575.00 TOTAL Other Services & Charges 146,800.00 4,973.49 4,973.49 3.39 141,826.51 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL City Hall Maintenance 668,250.00 35,332.96 35,332.96 5.29 632,917.04 Contingency =========== Personal Services 101-4-1900-4101 Regular Pay 53,450.00 0.00 0.00 0.00 53,450.00 TOTAL Personal Services 53,450.00 0.00 0.00 0.00 53,450.00 Other Services & Charges _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Contingency 53,450.00 0.00 0.00 0.00 53,450.00 ___________________________________________________________________________________________________________________ TOTAL General Government 3,792,000.00 184,794.30 184,794.30 4.87 3,607,205.70 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Public Safety 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Police Administration ===================== Personal Services 101-4-2110-4101 Regular Pay 382,900.00 21,425.85 21,425.85 5.60 361,474.15 101-4-2110-4102 Overtime Pay 2,500.00 0.00 0.00 0.00 2,500.00 101-4-2110-4104 PERA 57,550.00 3,210.19 3,210.19 5.58 54,339.81 101-4-2110-4105 FICA 3,500.00 199.80 199.80 5.71 3,300.20 101-4-2110-4107 Medicare 5,600.00 303.70 303.70 5.42 5,296.30 101-4-2110-4108 Insurance 28,250.00 618.00 618.00 2.19 27,632.00 101-4-2110-4109 Workers Comp 86,600.00 24,952.50 24,952.50 28.81 61,647.50 TOTAL Personal Services 566,900.00 50,710.04 50,710.04 8.95 516,189.96 Supplies 101-4-2110-4201 Office Supplies 11,000.00 51.06 51.06 0.46 10,948.94 101-4-2110-4217 Uniform Allowance 3,050.00 0.00 0.00 0.00 3,050.00 101-4-2110-4219 Operating Supplies 25,500.00 8,716.83 8,716.83 34.18 16,783.17 TOTAL Supplies 39,550.00 8,767.89 8,767.89 22.17 30,782.11 Other Services & Charges 101-4-2110-4319 Other Professional Services 7,900.00 0.00 0.00 0.00 7,900.00 101-4-2110-4321 Telephone 34,600.00 0.00 0.00 0.00 34,600.00 101-4-2110-4322 Postage 2,400.00 0.00 0.00 0.00 2,400.00 101-4-2110-4331 Travel, Conferences & Schools 17,200.00 0.00 0.00 0.00 17,200.00 101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2110-4361 Insurance 40,500.00 9,768.00 9,768.00 24.12 30,732.00 101-4-2110-4404 Equip Repair/Maint Services 71,800.00 39,175.21 39,175.21 54.56 32,624.79 101-4-2110-4433 Dues & Subscriptions 15,100.00 9,897.00 9,897.00 65.54 5,203.00 101-4-2110-4437 Taxes & Licenses 200.00 44.00 44.00 22.00 156.00 TOTAL Other Services & Charges 190,200.00 58,884.21 58,884.21 30.96 131,315.79 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Administration 796,650.00 118,362.14 118,362.14 14.86 678,287.86 Patrol ====== Personal Services 101-4-2120-4101 Regular Pay 1,782,350.00 93,408.72 93,408.72 5.24 1,688,941.28 101-4-2120-4102 Overtime Pay 100,000.00 2,035.62 2,035.62 2.04 97,964.38 101-4-2120-4104 PERA 304,900.00 15,461.96 15,461.96 5.07 289,438.04 101-4-2120-4107 Medicare 27,250.00 1,376.21 1,376.21 5.05 25,873.79 101-4-2120-4108 Insurance 173,100.00 13,765.00 13,765.00 7.95 159,335.00 TOTAL Personal Services 2,387,600.00 126,047.51 126,047.51 5.28 2,261,552.49 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Public Safety 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-2120-4212 Fuels & Lubes 95,000.00 6,730.95 6,730.95 7.09 88,269.05 101-4-2120-4217 Uniform Allowance 21,000.00 0.00 0.00 0.00 21,000.00 101-4-2120-4219 Operating Supplies 79,700.00 0.00 0.00 0.00 79,700.00 101-4-2120-4221 Equipment Parts 23,300.00 0.00 0.00 0.00 23,300.00 TOTAL Supplies 219,000.00 6,730.95 6,730.95 3.07 212,269.05 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 28,250.00 0.00 0.00 0.00 28,250.00 101-4-2120-4404 Equip Repair/Maint Services 20,800.00 1,201.09 1,201.09 5.77 19,598.91 101-4-2120-4433 Dues & Subscriptions 650.00 0.00 0.00 0.00 650.00 101-4-2120-4460 Equip Replacement Charge 50,000.00 4,166.67 4,166.67 8.33 45,833.33 TOTAL Other Services & Charges 99,700.00 5,367.76 5,367.76 5.38 94,332.24 Capital Outlay 101-4-2120-4560 Equipment 15,000.00 12,900.00 12,900.00 86.00 2,100.00 TOTAL Capital Outlay 15,000.00 12,900.00 12,900.00 86.00 2,100.00 ___________________________________________________________________________________________________________________ TOTAL Patrol 2,721,300.00 151,046.22 151,046.22 5.55 2,570,253.78 Investigations ============== Personal Services 101-4-2130-4101 Regular Pay 721,150.00 38,404.08 38,404.08 5.33 682,745.92 101-4-2130-4102 Overtime Pay 55,000.00 1,158.50 1,158.50 2.11 53,841.50 101-4-2130-4104 PERA 125,750.00 6,409.14 6,409.14 5.10 119,340.86 101-4-2130-4107 Medicare 11,250.00 553.91 553.91 4.92 10,696.09 101-4-2130-4108 Insurance 81,850.00 6,321.24 6,321.24 7.72 75,528.76 TOTAL Personal Services 995,000.00 52,846.87 52,846.87 5.31 942,153.13 Supplies 101-4-2130-4217 Uniform Allowance 7,100.00 0.00 0.00 0.00 7,100.00 101-4-2130-4219 Operating Supplies 9,800.00 0.00 0.00 0.00 9,800.00 TOTAL Supplies 16,900.00 0.00 0.00 0.00 16,900.00 Other Services & Charges 101-4-2130-4319 Other Professional Services 7,500.00 0.00 0.00 0.00 7,500.00 101-4-2130-4331 Travel, Conferences & Schools 15,250.00 2,005.00 2,005.00 13.15 13,245.00 101-4-2130-4433 Dues & Subscriptions 3,700.00 0.00 0.00 0.00 3,700.00 101-4-2130-4460 Equip Replacement Charge 15,500.00 1,291.67 1,291.67 8.33 14,208.33 TOTAL Other Services & Charges 41,950.00 3,296.67 3,296.67 7.86 38,653.33 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Public Safety 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Investigations 1,053,850.00 56,143.54 56,143.54 5.33 997,706.46 Police Support Services ======================= Personal Services 101-4-2150-4101 Regular Pay 459,300.00 25,863.52 25,863.52 5.63 433,436.48 101-4-2150-4102 Overtime Pay 7,500.00 409.34 409.34 5.46 7,090.66 101-4-2150-4103 Part-time Pay 43,500.00 2,125.16 2,125.16 4.89 41,374.84 101-4-2150-4104 PERA 46,550.00 2,607.74 2,607.74 5.60 43,942.26 101-4-2150-4105 FICA 25,750.00 1,378.64 1,378.64 5.35 24,371.36 101-4-2150-4107 Medicare 7,400.00 399.40 399.40 5.40 7,000.60 101-4-2150-4108 Insurance 77,850.00 5,197.75 5,197.75 6.68 72,652.25 TOTAL Personal Services 667,850.00 37,981.55 37,981.55 5.69 629,868.45 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 5,900.00 0.00 0.00 0.00 5,900.00 101-4-2150-4219 Operating Supplies 13,400.00 0.00 0.00 0.00 13,400.00 TOTAL Supplies 20,300.00 0.00 0.00 0.00 20,300.00 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 6,400.00 11.01 11.01 0.17 6,388.99 101-4-2150-4404 Equip Repair/Maint Services 2,400.00 0.00 0.00 0.00 2,400.00 101-4-2150-4409 Contractual Services 8,000.00 0.00 0.00 0.00 8,000.00 101-4-2150-4433 Dues & Subscriptions 550.00 90.00 90.00 16.36 460.00 101-4-2150-4460 Equip Replacement Charge 6,000.00 500.00 500.00 8.33 5,500.00 TOTAL Other Services & Charges 23,350.00 601.01 601.01 2.57 22,748.99 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Support Services 711,500.00 38,582.56 38,582.56 5.42 672,917.44 Police Reserves =============== Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 45.30 45.30 0.82 5,454.70 101-4-2160-4105 FICA 350.00 2.81 2.81 0.80 347.19 101-4-2160-4107 Medicare 100.00 0.66 0.66 0.66 99.34 TOTAL Personal Services 5,950.00 48.77 48.77 0.82 5,901.23 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Public Safety 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-2160-4217 Uniform Allowance 5,500.00 0.00 0.00 0.00 5,500.00 101-4-2160-4219 Operating Supplies 3,000.00 0.00 0.00 0.00 3,000.00 TOTAL Supplies 8,500.00 0.00 0.00 0.00 8,500.00 Other Services & Charges 101-4-2160-4319 Other Professional Services 2,100.00 0.00 0.00 0.00 2,100.00 101-4-2160-4331 Travel, Conferences & Schools 3,200.00 0.00 0.00 0.00 3,200.00 TOTAL Other Services & Charges 5,300.00 0.00 0.00 0.00 5,300.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Reserves 19,750.00 48.77 48.77 0.25 19,701.23 Public safety building ====================== Personal Services _____________ _____________ _____________ _______ _____________ Supplies 101-4-2190-4219 Operating Supplies 23,600.00 0.00 0.00 0.00 23,600.00 TOTAL Supplies 23,600.00 0.00 0.00 0.00 23,600.00 Other Services & Charges 101-4-2190-4361 Insurance 5,200.00 1,195.00 1,195.00 22.98 4,005.00 101-4-2190-4389 Utilities 98,000.00 7,049.54 7,049.54 7.19 90,950.46 101-4-2190-4401 Bldg Repair/Maint Services 40,200.00 972.03 972.03 2.42 39,227.97 TOTAL Other Services & Charges 143,400.00 9,216.57 9,216.57 6.43 134,183.43 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Public safety building 167,000.00 9,216.57 9,216.57 5.52 157,783.43 Fire Administration =================== Personal Services 101-4-2310-4101 Regular Pay 259,200.00 14,750.63 14,750.63 5.69 244,449.37 101-4-2310-4104 PERA 37,900.00 2,161.69 2,161.69 5.70 35,738.31 101-4-2310-4105 FICA 2,900.00 176.36 176.36 6.08 2,723.64 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,750.00 208.79 208.79 5.57 3,541.21 101-4-2310-4108 Insurance 30,050.00 2,448.50 2,448.50 8.15 27,601.50 101-4-2310-4109 Workers Comp 11,850.00 3,250.25 3,250.25 27.43 8,599.75 TOTAL Personal Services 375,650.00 22,996.22 22,996.22 6.12 352,653.78 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Public Safety 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-2310-4201 Office Supplies 1,950.00 0.00 0.00 0.00 1,950.00 101-4-2310-4212 Fuels & Lubes 4,500.00 328.95 328.95 7.31 4,171.05 101-4-2310-4217 Uniform Allowance 1,500.00 0.00 0.00 0.00 1,500.00 101-4-2310-4219 Operating Supplies 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2310-4221 Equipment Parts 500.00 0.00 0.00 0.00 500.00 TOTAL Supplies 9,450.00 328.95 328.95 3.48 9,121.05 Other Services & Charges 101-4-2310-4319 Other Professional Services 7,500.00 0.00 0.00 0.00 7,500.00 101-4-2310-4321 Telephone 3,100.00 0.00 0.00 0.00 3,100.00 101-4-2310-4322 Postage 650.00 0.00 0.00 0.00 650.00 101-4-2310-4331 Travel, Conferences & Schools 5,000.00 0.00 0.00 0.00 5,000.00 101-4-2310-4359 Publishing 750.00 0.00 0.00 0.00 750.00 101-4-2310-4361 Insurance 8,300.00 1,903.00 1,903.00 22.93 6,397.00 101-4-2310-4389 Utilities 16,250.00 722.93 722.93 4.45 15,527.07 101-4-2310-4401 Bldg Repair/Maint Services 10,000.00 0.00 0.00 0.00 10,000.00 101-4-2310-4404 Equip Repair/Maint Services 3,450.00 960.76 960.76 27.85 2,489.24 101-4-2310-4433 Dues & Subscriptions 2,100.00 623.00 623.00 29.67 1,477.00 101-4-2310-4460 Equip Replacement Charge 65,000.00 5,416.67 5,416.67 8.33 59,583.33 TOTAL Other Services & Charges 122,100.00 9,626.36 9,626.36 7.88 112,473.64 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Administration 507,200.00 32,951.53 32,951.53 6.50 474,248.47 Fire Operations =============== Personal Services 101-4-2320-4103 Part-time Pay 188,700.00 16,914.85 16,914.85 8.96 171,785.15 101-4-2320-4105 FICA 11,700.00 1,035.14 1,035.14 8.85 10,664.86 101-4-2320-4107 Medicare 2,750.00 244.77 244.77 8.90 2,505.23 101-4-2320-4108 Insurance 0.00 123.69 123.69 0.00 ( 123.69) 101-4-2320-4109 Workers Comp 38,750.00 10,853.25 10,853.25 28.01 27,896.75 TOTAL Personal Services 241,900.00 29,171.70 29,171.70 12.06 212,728.30 Supplies 101-4-2320-4201 Office Supplies 300.00 0.00 0.00 0.00 300.00 101-4-2320-4212 Fuels & Lubes 7,800.00 480.68 480.68 6.16 7,319.32 101-4-2320-4217 Uniform Allowance 9,000.00 0.00 0.00 0.00 9,000.00 101-4-2320-4219 Operating Supplies 85,150.00 58.08 58.08 0.07 85,091.92 101-4-2320-4221 Equipment Parts 10,000.00 0.00 0.00 0.00 10,000.00 TOTAL Supplies 112,250.00 538.76 538.76 0.48 111,711.24 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Public Safety 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-2320-4321 Telephone 4,400.00 0.00 0.00 0.00 4,400.00 101-4-2320-4331 Travel, Conferences & Schools 20,750.00 0.00 0.00 0.00 20,750.00 101-4-2320-4404 Equip Repair/Maint Services 35,200.00 1,029.92 1,029.92 2.93 34,170.08 101-4-2320-4409 Contractual Services 6,300.00 0.00 0.00 0.00 6,300.00 TOTAL Other Services & Charges 66,650.00 1,029.92 1,029.92 1.55 65,620.08 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Operations 420,800.00 30,740.38 30,740.38 7.31 390,059.62 Emergency Management ==================== Personal Services _____________ _____________ _____________ _______ _____________ Supplies 101-4-2330-4219 Operating Supplies 7,500.00 0.00 0.00 0.00 7,500.00 TOTAL Supplies 7,500.00 0.00 0.00 0.00 7,500.00 Other Services & Charges 101-4-2330-4331 Travel, Conferences & Schools 8,100.00 0.00 0.00 0.00 8,100.00 101-4-2330-4389 Utilities 4,200.00 134.91 134.91 3.21 4,065.09 101-4-2330-4404 Equip Repair/Maint Services 6,950.00 0.00 0.00 0.00 6,950.00 101-4-2330-4433 Dues & Subscriptions 250.00 0.00 0.00 0.00 250.00 TOTAL Other Services & Charges 19,500.00 134.91 134.91 0.69 19,365.09 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Emergency Management 27,000.00 134.91 134.91 0.50 26,865.09 Building Safety =============== Personal Services 101-4-2410-4101 Regular Pay 477,300.00 24,558.21 24,558.21 5.15 452,741.79 101-4-2410-4103 Part-time Pay 0.00 529.16 529.16 0.00 ( 529.16) 101-4-2410-4104 PERA 42,650.00 2,276.59 2,276.59 5.34 40,373.41 101-4-2410-4105 FICA 24,700.00 1,227.50 1,227.50 4.97 23,472.50 101-4-2410-4107 Medicare 6,900.00 348.88 348.88 5.06 6,551.12 101-4-2410-4108 Insurance 86,900.00 2,752.00 2,752.00 3.17 84,148.00 101-4-2410-4109 Workers Comp 1,800.00 485.50 485.50 26.97 1,314.50 TOTAL Personal Services 640,250.00 32,177.84 32,177.84 5.03 608,072.16 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Public Safety 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-2410-4201 Office Supplies 4,200.00 0.00 0.00 0.00 4,200.00 101-4-2410-4212 Fuels & Lubes 7,200.00 591.61 591.61 8.22 6,608.39 101-4-2410-4217 Uniform Allowance 1,750.00 0.00 0.00 0.00 1,750.00 101-4-2410-4219 Operating Supplies 7,250.00 0.00 0.00 0.00 7,250.00 TOTAL Supplies 20,400.00 591.61 591.61 2.90 19,808.39 Other Services & Charges 101-4-2410-4321 Telephone 4,600.00 0.00 0.00 0.00 4,600.00 101-4-2410-4322 Postage 350.00 0.00 0.00 0.00 350.00 101-4-2410-4331 Travel, Conferences & Schools 4,150.00 1,060.00 1,060.00 25.54 3,090.00 101-4-2410-4361 Insurance 600.00 109.00 109.00 18.17 491.00 101-4-2410-4404 Equip Repair/Maint Services 3,500.00 0.00 0.00 0.00 3,500.00 101-4-2410-4433 Dues & Subscriptions 1,600.00 0.00 0.00 0.00 1,600.00 101-4-2410-4460 Equip Replacement Charge 3,000.00 250.00 250.00 8.33 2,750.00 TOTAL Other Services & Charges 17,800.00 1,419.00 1,419.00 7.97 16,381.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Safety 678,450.00 34,188.45 34,188.45 5.04 644,261.55 Code Enforcement ================ Personal Services 101-4-2420-4101 Regular Pay 73,850.00 4,261.20 4,261.20 5.77 69,588.80 101-4-2420-4104 PERA 5,550.00 319.59 319.59 5.76 5,230.41 101-4-2420-4105 FICA 4,600.00 272.32 272.32 5.92 4,327.68 101-4-2420-4107 Medicare 1,100.00 63.68 63.68 5.79 1,036.32 101-4-2420-4108 Insurance 3,650.00 304.50 304.50 8.34 3,345.50 101-4-2420-4109 Workers Comp 250.00 70.75 70.75 28.30 179.25 TOTAL Personal Services 89,000.00 5,292.04 5,292.04 5.95 83,707.96 Supplies 101-4-2420-4212 Fuels & Lubes 1,750.00 92.75 92.75 5.30 1,657.25 101-4-2420-4217 Uniform Allowance 350.00 0.00 0.00 0.00 350.00 101-4-2420-4219 Operating Supplies 3,250.00 0.00 0.00 0.00 3,250.00 TOTAL Supplies 5,350.00 92.75 92.75 1.73 5,257.25 Other Services & Charges 101-4-2420-4321 Telephone 850.00 0.00 0.00 0.00 850.00 101-4-2420-4322 Postage 1,750.00 0.00 0.00 0.00 1,750.00 101-4-2420-4331 Travel, Conferences & Schools 800.00 0.00 0.00 0.00 800.00 101-4-2420-4361 Insurance 100.00 20.00 20.00 20.00 80.00 101-4-2420-4404 Equip Repair/Maint Services 900.00 0.00 0.00 0.00 900.00 101-4-2420-4460 Equip Replacement Charge 0.00 75.00 75.00 0.00 ( 75.00) TOTAL Other Services & Charges 4,400.00 95.00 95.00 2.16 4,305.00 ___________________________________________________________________________________________________________________ TOTAL Code Enforcement 98,750.00 5,479.79 5,479.79 5.55 93,270.21 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Public Safety 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Environmental ============= Personal Services 101-4-2440-4101 Regular Pay 18,100.00 1,022.64 1,022.64 5.65 17,077.36 101-4-2440-4104 PERA 1,350.00 76.70 76.70 5.68 1,273.30 101-4-2440-4105 FICA 1,100.00 63.52 63.52 5.77 1,036.48 101-4-2440-4107 Medicare 250.00 14.86 14.86 5.94 235.14 101-4-2440-4108 Insurance 2,600.00 178.34 178.34 6.86 2,421.66 101-4-2440-4109 Workers Comp 250.00 57.75 57.75 23.10 192.25 TOTAL Personal Services 23,650.00 1,413.81 1,413.81 5.98 22,236.19 Supplies 101-4-2440-4201 Office Supplies 300.00 0.00 0.00 0.00 300.00 101-4-2440-4212 Fuels & Lubes 200.00 0.00 0.00 0.00 200.00 101-4-2440-4219 Operating Supplies 5,350.00 0.00 0.00 0.00 5,350.00 TOTAL Supplies 5,850.00 0.00 0.00 0.00 5,850.00 Other Services & Charges 101-4-2440-4321 Telephone 350.00 0.00 0.00 0.00 350.00 101-4-2440-4331 Travel, Conferences & Schools 1,400.00 0.00 0.00 0.00 1,400.00 101-4-2440-4359 Publishing 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2440-4409 Contractual Services 16,000.00 0.00 0.00 0.00 16,000.00 101-4-2440-4433 Dues & Subscriptions 150.00 0.00 0.00 0.00 150.00 TOTAL Other Services & Charges 18,900.00 0.00 0.00 0.00 18,900.00 ___________________________________________________________________________________________________________________ TOTAL Environmental 48,400.00 1,413.81 1,413.81 2.92 46,986.19 ___________________________________________________________________________________________________________________ TOTAL Public Safety 7,250,650.00 478,308.67 478,308.67 6.60 6,772,341.33 Street Maintenance ================== Personal Services 101-4-3120-4101 Regular Pay 504,500.00 29,679.62 29,679.62 5.88 474,820.38 101-4-3120-4102 Overtime Pay 4,000.00 ( 109.85)( 109.85) 2.75- 4,109.85 101-4-3120-4103 Part-time Pay 84,650.00 4,299.45 4,299.45 5.08 80,350.55 101-4-3120-4104 PERA 42,800.00 898.58 898.58 2.10 41,901.42 101-4-3120-4105 FICA 36,800.00 2,212.97 2,212.97 6.01 34,587.03 101-4-3120-4107 Medicare 8,600.00 517.57 517.57 6.02 8,082.43 101-4-3120-4108 Insurance 75,600.00 1,490.74 1,490.74 1.97 74,109.26 101-4-3120-4109 Workers Comp 33,000.00 8,791.25 8,791.25 26.64 24,208.75 TOTAL Personal Services 789,950.00 47,780.33 47,780.33 6.05 742,169.67 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Public Works 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-3120-4201 Office Supplies 4,500.00 0.00 0.00 0.00 4,500.00 101-4-3120-4212 Fuels & Lubes 61,200.00 6,394.93 6,394.93 10.45 54,805.07 101-4-3120-4217 Uniform Allowance 6,600.00 ( 34.99)( 34.99) 0.53- 6,634.99 101-4-3120-4219 Operating Supplies 55,300.00 71.82 71.82 0.13 55,228.18 101-4-3120-4221 Equipment Parts 52,000.00 92.93 92.93 0.18 51,907.07 101-4-3120-4226 Street Signs 31,000.00 0.00 0.00 0.00 31,000.00 TOTAL Supplies 210,600.00 6,524.69 6,524.69 3.10 204,075.31 Other Services & Charges 101-4-3120-4319 Other Professional Services 300.00 0.00 0.00 0.00 300.00 101-4-3120-4321 Telephone 7,550.00 0.00 0.00 0.00 7,550.00 101-4-3120-4322 Postage 100.00 0.00 0.00 0.00 100.00 101-4-3120-4331 Travel, Conferences & Schools 5,100.00 0.00 0.00 0.00 5,100.00 101-4-3120-4359 Publishing 200.00 0.00 0.00 0.00 200.00 101-4-3120-4361 Insurance 15,000.00 3,623.00 3,623.00 24.15 11,377.00 101-4-3120-4389 Utilities 92,800.00 50.00 50.00 0.05 92,750.00 101-4-3120-4401 Bldg Repair/Maint Services 23,000.00 22.95 22.95 0.10 22,977.05 101-4-3120-4404 Equip Repair/Maint Services 9,000.00 0.00 0.00 0.00 9,000.00 101-4-3120-4409 Contractual Services 65,500.00 0.00 0.00 0.00 65,500.00 101-4-3120-4415 Equipment Rental 2,000.00 0.00 0.00 0.00 2,000.00 101-4-3120-4417 Uniform Rental 0.00 ( 17.91)( 17.91) 0.00 17.91 101-4-3120-4433 Dues & Subscriptions 350.00 395.00 395.00 112.86 ( 45.00) 101-4-3120-4437 Taxes & Licenses 500.00 0.00 0.00 0.00 500.00 101-4-3120-4460 Equip Replacement Charge 111,300.00 9,275.00 9,275.00 8.33 102,025.00 TOTAL Other Services & Charges 332,700.00 13,348.04 13,348.04 4.01 319,351.96 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Street Maintenance 1,333,250.00 67,653.06 67,653.06 5.07 1,265,596.94 Snow Removal ============ Personal Services 101-4-3130-4101 Regular Pay 134,700.00 17,956.55 17,956.55 13.33 116,743.45 101-4-3130-4102 Overtime Pay 20,000.00 5,553.14 5,553.14 27.77 14,446.86 101-4-3130-4104 PERA 11,200.00 1,703.39 1,703.39 15.21 9,496.61 101-4-3130-4105 FICA 9,600.00 1,336.12 1,336.12 13.92 8,263.88 101-4-3130-4107 Medicare 2,250.00 312.46 312.46 13.89 1,937.54 101-4-3130-4108 Insurance 18,900.00 1,490.76 1,490.76 7.89 17,409.24 101-4-3130-4109 Workers Comp 9,050.00 2,485.50 2,485.50 27.46 6,564.50 TOTAL Personal Services 205,700.00 30,837.92 30,837.92 14.99 174,862.08 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Public Works 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-3130-4219 Operating Supplies 93,000.00 30,694.74 30,694.74 33.01 62,305.26 TOTAL Supplies 93,000.00 30,694.74 30,694.74 33.01 62,305.26 Other Services & Charges _____________ _____________ _____________ _______ _____________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Snow Removal 298,700.00 61,532.66 61,532.66 20.60 237,167.34 Equipment Services ================== Personal Services 101-4-3150-4101 Regular Pay 120,100.00 6,874.83 6,874.83 5.72 113,225.17 101-4-3150-4102 Overtime Pay 1,000.00 0.00 0.00 0.00 1,000.00 101-4-3150-4104 PERA 9,100.00 518.53 518.53 5.70 8,581.47 101-4-3150-4105 FICA 7,500.00 427.69 427.69 5.70 7,072.31 101-4-3150-4107 Medicare 1,750.00 100.03 100.03 5.72 1,649.97 101-4-3150-4108 Insurance 16,050.00 599.00 599.00 3.73 15,451.00 101-4-3150-4109 Workers Comp 3,000.00 808.50 808.50 26.95 2,191.50 TOTAL Personal Services 158,500.00 9,328.58 9,328.58 5.89 149,171.42 Supplies 101-4-3150-4212 Fuels & Lubes 5,100.00 ( 340.65)( 340.65) 6.68- 5,440.65 101-4-3150-4219 Operating Supplies 20,650.00 334.87 334.87 1.62 20,315.13 101-4-3150-4221 Equipment Parts 5,000.00 0.00 0.00 0.00 5,000.00 TOTAL Supplies 30,750.00 ( 5.78)( 5.78) 0.02- 30,755.78 Other Services & Charges 101-4-3150-4331 Travel, Conferences & Schools 3,000.00 0.00 0.00 0.00 3,000.00 101-4-3150-4404 Equip Repair/Maint Services 12,500.00 0.00 0.00 0.00 12,500.00 101-4-3150-4417 Uniform Rental 900.00 0.00 0.00 0.00 900.00 TOTAL Other Services & Charges 16,400.00 0.00 0.00 0.00 16,400.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Equipment Services 205,650.00 9,322.80 9,322.80 4.53 196,327.20 Engineering =========== 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Public Works 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Services 101-4-3300-4101 Regular Pay 174,650.00 10,074.91 10,074.91 5.77 164,575.09 101-4-3300-4104 PERA 13,100.00 755.62 755.62 5.77 12,344.38 101-4-3300-4105 FICA 10,850.00 648.36 648.36 5.98 10,201.64 101-4-3300-4107 Medicare 2,550.00 151.64 151.64 5.95 2,398.36 101-4-3300-4108 Insurance 20,000.00 609.00 609.00 3.05 19,391.00 101-4-3300-4109 Workers Comp 600.00 167.00 167.00 27.83 433.00 TOTAL Personal Services 221,750.00 12,406.53 12,406.53 5.59 209,343.47 Supplies 101-4-3300-4201 Office Supplies 150.00 32.00 32.00 21.33 118.00 101-4-3300-4212 Fuels & Lubes 1,000.00 4.77 4.77 0.48 995.23 101-4-3300-4219 Operating Supplies 1,500.00 0.00 0.00 0.00 1,500.00 TOTAL Supplies 2,650.00 36.77 36.77 1.39 2,613.23 Other Services & Charges 101-4-3300-4319 Other Professional Services 4,000.00 0.00 0.00 0.00 4,000.00 101-4-3300-4321 Telephone 1,450.00 0.00 0.00 0.00 1,450.00 101-4-3300-4322 Postage 200.00 0.00 0.00 0.00 200.00 101-4-3300-4331 Travel, Conferences & Schools 1,650.00 0.00 0.00 0.00 1,650.00 101-4-3300-4361 Insurance 100.00 20.00 20.00 20.00 80.00 101-4-3300-4404 Equip Repair/Maint Services 1,500.00 0.00 0.00 0.00 1,500.00 101-4-3300-4460 Equip Replacement Charge 900.00 75.00 75.00 8.33 825.00 TOTAL Other Services & Charges 9,800.00 95.00 95.00 0.97 9,705.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Engineering 234,200.00 12,538.30 12,538.30 5.35 221,661.70 ___________________________________________________________________________________________________________________ TOTAL Public Works 2,071,800.00 151,046.82 151,046.82 7.29 1,920,753.18 Parks Department ================ Personal Services 101-4-5110-4101 Regular Pay 431,900.00 24,540.19 24,540.19 5.68 407,359.81 101-4-5110-4102 Overtime Pay 6,500.00 726.70 726.70 11.18 5,773.30 101-4-5110-4103 Part-time Pay 68,250.00 0.00 0.00 0.00 68,250.00 101-4-5110-4104 PERA 32,900.00 1,868.95 1,868.95 5.68 31,031.05 101-4-5110-4105 FICA 30,900.00 1,506.18 1,506.18 4.87 29,393.82 101-4-5110-4107 Medicare 7,250.00 352.24 352.24 4.86 6,897.76 101-4-5110-4108 Insurance 78,850.00 6,438.25 6,438.25 8.17 72,411.75 101-4-5110-4109 Workers Comp 16,800.00 4,572.25 4,572.25 27.22 12,227.75 TOTAL Personal Services 673,350.00 40,004.76 40,004.76 5.94 633,345.24 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Culture & Recreation 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-5110-4212 Fuels & Lubes 30,050.00 1,527.67 1,527.67 5.08 28,522.33 101-4-5110-4217 Uniform Allowance 3,800.00 ( 9.21)( 9.21) 0.24- 3,809.21 101-4-5110-4219 Operating Supplies 106,550.00 1,081.81 1,081.81 1.02 105,468.19 101-4-5110-4221 Equipment Parts 27,000.00 1,194.61 1,194.61 4.42 25,805.39 TOTAL Supplies 167,400.00 3,794.88 3,794.88 2.27 163,605.12 Other Services & Charges 101-4-5110-4321 Telephone 4,700.00 0.00 0.00 0.00 4,700.00 101-4-5110-4322 Postage 100.00 0.00 0.00 0.00 100.00 101-4-5110-4331 Travel, Conferences & Schools 3,350.00 299.00 299.00 8.93 3,051.00 101-4-5110-4361 Insurance 33,500.00 8,034.00 8,034.00 23.98 25,466.00 101-4-5110-4389 Utilities 76,500.00 1,446.49 1,446.49 1.89 75,053.51 101-4-5110-4401 Bldg Repair/Maint Services 3,000.00 0.00 0.00 0.00 3,000.00 101-4-5110-4404 Equip Repair/Maint Services 20,000.00 0.00 0.00 0.00 20,000.00 101-4-5110-4409 Contractual Services 44,200.00 0.00 0.00 0.00 44,200.00 101-4-5110-4415 Equipment Rental 24,200.00 0.00 0.00 0.00 24,200.00 101-4-5110-4460 Equip Replacement Charge 53,500.00 4,458.33 4,458.33 8.33 49,041.67 TOTAL Other Services & Charges 263,050.00 14,237.82 14,237.82 5.41 248,812.18 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks Department 1,103,800.00 58,037.46 58,037.46 5.26 1,045,762.54 Parks & Rec Admin ================= Personal Services 101-4-5210-4101 Regular Pay 313,900.00 18,105.40 18,105.40 5.77 295,794.60 101-4-5210-4103 Part-time Pay 93,000.00 4,765.20 4,765.20 5.12 88,234.80 101-4-5210-4104 PERA 30,500.00 1,715.28 1,715.28 5.62 28,784.72 101-4-5210-4105 FICA 25,250.00 1,365.94 1,365.94 5.41 23,884.06 101-4-5210-4107 Medicare 5,900.00 319.44 319.44 5.41 5,580.56 101-4-5210-4108 Insurance 45,000.00 3,998.00 3,998.00 8.88 41,002.00 101-4-5210-4109 Workers Comp 3,500.00 904.75 904.75 25.85 2,595.25 TOTAL Personal Services 517,050.00 31,174.01 31,174.01 6.03 485,875.99 Supplies 101-4-5210-4219 Operating Supplies 10,050.00 1,231.77 1,231.77 12.26 8,818.23 TOTAL Supplies 10,050.00 1,231.77 1,231.77 12.26 8,818.23 Other Services & Charges 101-4-5210-4321 Telephone 3,450.00 96.18 96.18 2.79 3,353.82 101-4-5210-4322 Postage 5,300.00 0.00 0.00 0.00 5,300.00 101-4-5210-4331 Travel, Conferences & Schools 8,850.00 592.01 592.01 6.69 8,257.99 101-4-5210-4349 Advertising/Marketing 13,200.00 0.00 0.00 0.00 13,200.00 101-4-5210-4361 Insurance 450.00 101.00 101.00 22.44 349.00 101-4-5210-4389 Utilities 8,500.00 491.09 491.09 5.78 8,008.91 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Culture & Recreation 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-4-5210-4401 Bldg Repair/Maint Services 17,200.00 0.00 0.00 0.00 17,200.00 101-4-5210-4404 Equip Repair/Maint Services 8,800.00 8,172.94 8,172.94 92.87 627.06 101-4-5210-4433 Dues & Subscriptions 2,600.00 1,815.00 1,815.00 69.81 785.00 TOTAL Other Services & Charges 68,350.00 11,268.22 11,268.22 16.49 57,081.78 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks & Rec Admin 595,450.00 43,674.00 43,674.00 7.33 551,776.00 Recreation Programs =================== Personal Services 101-4-5220-4103 Part-time Pay 43,000.00 1,803.06 1,803.06 4.19 41,196.94 101-4-5220-4105 FICA 2,200.00 111.78 111.78 5.08 2,088.22 101-4-5220-4107 Medicare 650.00 26.14 26.14 4.02 623.86 TOTAL Personal Services 45,850.00 1,940.98 1,940.98 4.23 43,909.02 Supplies 101-4-5220-4219 Operating Supplies 25,000.00 ( 1,500.00)( 1,500.00) 6.00- 26,500.00 TOTAL Supplies 25,000.00 ( 1,500.00)( 1,500.00) 6.00- 26,500.00 Other Services & Charges 101-4-5220-4409 Contractual Services 55,000.00 0.00 0.00 0.00 55,000.00 101-4-5220-4412 Building Rent 1,900.00 0.00 0.00 0.00 1,900.00 101-4-5220-4438 Credit Card Fees 3,600.00 0.00 0.00 0.00 3,600.00 TOTAL Other Services & Charges 60,500.00 0.00 0.00 0.00 60,500.00 ___________________________________________________________________________________________________________________ TOTAL Recreation Programs 131,350.00 440.98 440.98 0.34 130,909.02 Concessions =========== Personal Services _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ Sr Citizen Programs =================== Personal Services 101-4-5510-4101 Regular Pay 127,700.00 7,366.80 7,366.80 5.77 120,333.20 101-4-5510-4103 Part-time Pay 10,150.00 290.63 290.63 2.86 9,859.37 101-4-5510-4104 PERA 10,350.00 552.51 552.51 5.34 9,797.49 101-4-5510-4105 FICA 8,550.00 484.74 484.74 5.67 8,065.26 101-4-5510-4107 Medicare 2,000.00 113.37 113.37 5.67 1,886.63 101-4-5510-4108 Insurance 20,950.00 899.00 899.00 4.29 20,051.00 101-4-5510-4109 Workers Comp 650.00 173.50 173.50 26.69 476.50 TOTAL Personal Services 180,350.00 9,880.55 9,880.55 5.48 170,469.45 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Culture & Recreation 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-5510-4219 Operating Supplies 10,900.00 48.69 48.69 0.45 10,851.31 TOTAL Supplies 10,900.00 48.69 48.69 0.45 10,851.31 Other Services & Charges 101-4-5510-4321 Telephone 1,300.00 0.00 0.00 0.00 1,300.00 101-4-5510-4322 Postage 2,200.00 0.00 0.00 0.00 2,200.00 101-4-5510-4331 Travel, Conferences & Schools 3,050.00 0.00 0.00 0.00 3,050.00 101-4-5510-4361 Insurance 1,350.00 314.00 314.00 23.26 1,036.00 101-4-5510-4389 Utilities 22,650.00 1,151.99 1,151.99 5.09 21,498.01 101-4-5510-4401 Bldg Repair/Maint Services 16,700.00 0.00 0.00 0.00 16,700.00 101-4-5510-4404 Equip Repair/Maint Services 100.00 0.00 0.00 0.00 100.00 101-4-5510-4409 Contractual Services 12,000.00 90.00 90.00 0.75 11,910.00 101-4-5510-4433 Dues & Subscriptions 900.00 390.00 390.00 43.33 510.00 TOTAL Other Services & Charges 60,250.00 1,945.99 1,945.99 3.23 58,304.01 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Sr Citizen Programs 251,500.00 11,875.23 11,875.23 4.72 239,624.77 ___________________________________________________________________________________________________________________ TOTAL Culture & Recreation 2,082,100.00 114,027.67 114,027.67 5.48 1,968,072.33 Economic Development ==================== Personal Services 101-4-6210-4101 Regular Pay 0.00 12,025.86 12,025.86 0.00 ( 12,025.86) 101-4-6210-4103 Part-time Pay 0.00 1,050.00 1,050.00 0.00 ( 1,050.00) 101-4-6210-4104 PERA 0.00 916.94 916.94 0.00 ( 916.94) 101-4-6210-4105 FICA 0.00 765.60 765.60 0.00 ( 765.60) 101-4-6210-4107 Medicare 0.00 183.41 183.41 0.00 ( 183.41) 101-4-6210-4108 Insurance 0.00 2,144.00 2,144.00 0.00 ( 2,144.00) 101-4-6210-4109 Workers Comp 0.00 79.50 79.50 0.00 ( 79.50) TOTAL Personal Services 0.00 17,165.31 17,165.31 0.00 ( 17,165.31) Other Services & Charges 101-4-6210-4440 Miscellaneous 0.00 ( 66.47)( 66.47) 0.00 66.47 TOTAL Other Services & Charges 0.00 ( 66.47)( 66.47) 0.00 66.47 ___________________________________________________________________________________________________________________ TOTAL Economic Development 0.00 17,098.84 17,098.84 0.00 ( 17,098.84) 2-14-2018 11:53 AM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31ST, 2018 101-GENERAL FUND Economic Development 08.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Energy City =========== Personal Services 101-4-6220-4101 Regular Pay 18,100.00 1,022.67 1,022.67 5.65 17,077.33 101-4-6220-4104 PERA 1,350.00 76.69 76.69 5.68 1,273.31 101-4-6220-4105 FICA 1,100.00 63.52 63.52 5.77 1,036.48 101-4-6220-4107 Medicare 250.00 14.86 14.86 5.94 235.14 101-4-6220-4108 Insurance 2,600.00 178.36 178.36 6.86 2,421.64 TOTAL Personal Services 23,400.00 1,356.10 1,356.10 5.80 22,043.90 Supplies 101-4-6220-4219 Operating Supplies 1,800.00 0.00 0.00 0.00 1,800.00 TOTAL Supplies 1,800.00 0.00 0.00 0.00 1,800.00 Other Services & Charges 101-4-6220-4331 Travel, Conferences & Schools 4,500.00 0.00 0.00 0.00 4,500.00 101-4-6220-4359 Publishing 1,500.00 0.00 0.00 0.00 1,500.00 101-4-6220-4404 Equip Repair/Maint Svcs 1,800.00 0.00 0.00 0.00 1,800.00 TOTAL Other Services & Charges 7,800.00 0.00 0.00 0.00 7,800.00 ___________________________________________________________________________________________________________________ TOTAL Energy City 33,000.00 1,356.10 1,356.10 4.11 31,643.90 ___________________________________________________________________________________________________________________ TOTAL Economic Development 33,000.00 18,454.94 18,454.94 55.92 14,545.06 Transfers Out ============= Transfers Out _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL EXPENDITURES 15,229,550.00 946,632.40 946,632.40 6.22 14,282,917.60 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 799,753.56)( 799,753.56) 799,753.56 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,101,300$ 468,705$ 6,632,595$ 6.60% Cost of sales (5,059,100) (36,502) (5,022,598) 0.72% Gross profit 2,042,200 432,203 1,609,997 21.16% Operating revenues: User charges - - - 0.00%2,020,000$ -$ 2,020,000$ 0.00%1,550,000$ 6$ 1,549,994$ 0.00%468,000$ -$ 468,000$ 0.00% Delinquency collections - - - 0.00%2,000 22 1,978 1.10%8,000 491 7,509 6.14%- (42) 42 0.00% Other 1,700 - 1,700 0.00%100,000 14,000 86,000 14.00%- - - 0.00%- - - 0.00% Total operating revenues 1,700 - 1,700 0.00%2,122,000 14,022 2,107,978 0.66%1,558,000 497 1,557,503 0.03%468,000 (42) 468,042 -0.01% Operating expenses: Personal services 729,050 44,326 684,724 6.08%640,500 36,470 604,030 5.69%23,400 1,356 22,044 5.79%84,100 4,885 79,215 5.81% Supplies 20,400 166 20,234 0.81%195,000 2,625 192,375 1.35%21,400 - 21,400 0.00%2,000 - 2,000 0.00% Other service charges 259,550 5,413 254,137 2.09%626,950 30,921 596,029 4.93%1,553,650 4,400 1,549,250 0.28%187,050 - 187,050 0.00% 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,134,000 49,905 1,084,095 4.40%2,887,450 70,016 2,817,434 2.42%1,598,450 5,756 1,592,694 0.36%721,150 4,885 716,265 0.68% Operating income (loss)909,900 382,298 527,602 42.02%(765,450) (55,994) (709,456) 7.32%(40,450) (5,259) (35,191) 13.00%(253,150) (4,927) (248,223) 1.95% Nonoperating revenues (expenses): Interest income 35,000 - 35,000 0.00%80,000 - 80,000 0.00%8,000 - 8,000 0.00%5,000 - 5,000 0.00% Interest expense - - - 0.00%(256,150) - (256,150) 0.00%- - - 0.00%- - - 0.00% Total nonoperating revenues (expenses)35,000 - 35,000 0.00%(176,150) - (176,150) 0.00%8,000 - 8,000 0.00%5,000 - 5,000 0.00% Income (loss) before contributions and transfers 944,900 382,298 562,602 40.46%(941,600) (55,994) (885,606) 5.95%(32,450) (5,259) (27,191) 16.21%(248,150) (4,927) (243,223) 1.99% Contributions - connection fees - - - 0.00%500,000 20,250 479,750 4.05%- - - 0.00%27,000 - 27,000 0.00% Transfers in - - - 0.00%- - 0.00%46,500 - 46,500 0.00%- - - 0.00% Transfers out (742,000) - (742,000) 0.00%(150,000) - (150,000) 0.00%(46,750) - (46,750) 0.00%(35,000) - (35,000) 0.00% NET INCOME (LOSS)202,900 382,298 (179,398) 188.42%(591,600) (35,744) (555,856) 6.04%(32,700) (5,259) (27,441) 16.08%(256,150) (4,927) (251,223) 1.92% Items reclassified to balance sheet at year end: Capital Outlay (366,250) (41,107) (325,143) 11.22% Bond Payment (415,000) - (415,000) 0.00% Revenues over/(under) expenditures 202,900 382,298 (179,398) (1,372,850) (76,851) (1,295,999) (32,700) (5,259) (27,441) (256,150) (4,927) (251,223) 1.92% * Recorded at yearend Stormwater CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED JANUARY 31, 2018 Liquor Sewer Garbage 2-14-2018 11:57 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: JANUARY 31ST, 2018 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE ___________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 13,316.48 ( 6,810.07) 6,506.41 101-1010 Cash - General Fund 7,152,176.31 ( 1,020,822.03) 6,131,354.28 211-1010 Cash - Library 438,050.37 ( 6,222.46) 431,827.91 221-1010 Cash - Ice Arena 436,155.09 64,457.48 500,612.57 222-1010 Cash - Pinewood Golf Course 40.57 0.00 40.57 225-1010 Cash - Park Dedication 99,348.12 0.00 99,348.12 228-1010 Cash - Landfill 360,220.35 ( 1,191.53) 359,028.82 231-1010 Cash - Landfill Const Debris 752,640.92 0.00 752,640.92 240-1010 Cash - Micro Loan Fund 681,278.25 8,124.96 689,403.21 242-1010 Cash - State DEED 211,379.77 1,886.49 213,266.26 245-1010 Cash - Development Fund 762,013.90 ( 30,440.99) 731,572.91 290-1010 Cash - Capital Outlay Reserve 928,560.77 ( 44,930.49) 883,630.28 291-1010 Cash - Insurance Reserve 187,266.67 ( 12,961.59) 174,305.08 292-1010 Cash - Govt Bldgs Reserve 2,249,767.27 90,294.91 2,340,062.18 294-1010 Cash - Drug Forfeiture 23,067.94 3,321.20 26,389.14 295-1010 Cash - Severance Pay Reserve 73,533.21 0.00 73,533.21 296-1010 Cash - GRE Reserve 1,958,804.40 194,672.86 2,153,477.26 313-1010 Cash - 2007C/2012B GO Bonds 210,720.98 3,507.30 214,228.28 333-1010 Cash - 2010A GO Cap Imp Bonds 855,871.63 5,469.67 861,341.30 401-1010 Cash - Pavement Mgmt 2,637,684.76 431,145.17 3,068,829.93 403-1010 Cash - Street Improvement 857,883.11 ( 8,976.06) 848,907.05 406-1010 Cash - City Wide Trunk Util 3,829,524.54 0.00 3,829,524.54 410-1010 Cash - Equipment Replacement 1,050,982.25 76,975.29 1,127,957.54 440-1010 Cash - Park Improvement 346,811.49 ( 23,228.00) 323,583.49 463-1010 Cash - TIF #23 Pref Powder 2,343.23 0.00 2,343.23 602-1010 Cash - Wastewater Treatment 3,892,550.82 ( 76,174.27) 3,816,376.55 603-1010 Cash - Liquor 3,867,159.21 3,156.13 3,870,315.34 605-1010 Cash - Garbage 207,103.78 ( 9,923.65) 197,180.13 607-1010 Cash - Storm Water 600,354.14 31,329.95 631,684.09 801-1010 Cash - Interest 0.00 47,708.63 47,708.63 821-1010 Cash - Developer Escrow 1,099,252.79 ( 1,152.50) 1,098,100.29_ TOTAL CLAIM ON CASH 35,785,863.12 ( 280,783.60) 35,505,079.52 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 96,434,537.61 727,467.11 97,162,004.72 999-1001 PY BANK ACCOUNT (89,031,875.82) ( 1,008,250.71) (90,040,126.53) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56_ SUBTOTAL CASH IN BANK - POOLED CASH 35,784,851.35 ( 280,783.60) 35,504,067.75 WAGES PAYABLE _______________ ______________ ______________ TOTAL CASH IN BANK - POOLED CASH 35,784,851.35 ( 280,783.60) 35,504,067.75 =============== ============== ==============