Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 06-18-2018
Information �i of Memorandum Memorandum cElk River TO: Mayor and City Council From: Jesse Dorn,Assistant Finance Director Date: June 18, 2018 Subject: May 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 and Pinewood Golf Special Revenue Funds, and the Enterprise Funds. These funds provide an important picture of the city's financial health. For the month of May, actual revenues (excluding property taxes and transfers in) and expenditures should run about 42% 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 34% of budget. The first half property taxes will be received in June/July and the majority of transfers in will be recorded mid-year. ■ Licenses/permits collections are 40% of budget,with May collections consisting of liquor license renewals. ■ Charges for services are in line with budget estimates at 42%,with plan check fees comprising the majority of May collections. ■ Fines and forfeits collections are 32% of budget estimates,with court fine collections lagging a month. p0WIeI1 0 NAWREJ Expenditures: ■ Total departmental expenditures are about 34% of budget and most departments are below budget estimates. 2018 Monthly Expenditures $16,000 $14,000 o $12,000 z � < $10,000 D _ $8,000 $6,000 $4,000 tl $2,000 �n -1 j jai Actual $947 $1,942 $3,088 $4,192 $5,272 Budget $1,269 $2,538 $3,807 $5,077 $6,346 $7,615 1 $8,884 1$10,1531$11,4221$12,6911$13,960$15,230 ICE ARENA As of the end of May,revenues of$331,546 exceeded expenditures of$269,501 by$62,145. Ice rental revenues of$201,224 are about 36% of budget. Revenues and expenditures overall are consistent with budgeted amounts. PINEWOOD GOLF Through the end of May, overall revenues of$28,096 exceed expenditures of$19,416 by $8,680. The net income recognized by ERGC as of the end of May is $13,818. ATTACHMENTS ■ General Fund Revenue & Expense Report ■ Enterprise Funds—Budget to Actual ■ Cash Report—All Funds ■ Pinewood Revenue&Expense -May 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND FINANCIAL SUMMARY 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ REVENUE SUMMARY General Fund 15,229,550.00 297,201.01 1,223,790.47 8.04 14,005,759.53 TOTAL REVENUES 15,229,550.00 297,201.01 1,223,790.47 8.04 14,005,759.53 ============= ============= ============= ======= ============= EXPENDITURE SUMMARY General Government Mayor & Council 155,300.00 4,160.44 55,751.84 35.90 99,548.16 Communications 306,900.00 18,631.22 77,340.43 25.20 229,559.57 Administrative Services 511,900.00 37,922.92 170,070.31 33.22 341,829.69 Human Resources 250,550.00 32,531.90 102,227.57 40.80 148,322.43 Elections 42,250.00 425.04 6,725.04 15.92 35,524.96 Finance 586,250.00 43,501.31 219,681.89 37.47 366,568.11 Information Technology 431,300.00 26,832.66 136,510.07 31.65 294,789.93 Legal 230,000.00 21,227.48 66,158.07 28.76 163,841.93 Community Development 150,050.00 12,132.33 59,073.39 39.37 90,976.61 Planning 405,800.00 23,404.97 135,006.82 33.27 270,793.18 Building Maintenance 679,750.00 51,168.16 240,448.73 35.37 439,301.27 TOTAL General Government 3,750,050.00 271,938.43 1,268,994.16 33.84 2,481,055.84 Public Safety Police Administration 796,650.00 46,457.82 338,447.19 42.48 458,202.81 Patrol 2,721,300.00 195,352.84 899,168.63 33.04 1,822,131.37 Investigations 1,053,850.00 71,798.28 349,133.99 33.13 704,716.01 Police Support Services 711,500.00 54,582.89 251,283.66 35.32 460,216.34 Police Reserves 19,750.00 885.00 1,678.64 8.50 18,071.36 Public safety building 167,000.00 16,250.96 62,427.06 37.38 104,572.94 Fire Administration 507,200.00 33,651.21 189,151.52 37.29 318,048.48 Fire Operations 420,800.00 33,716.25 167,286.57 39.75 253,513.43 Emergency Management 27,000.00 2,348.52 5,263.64 19.49 21,736.36 Building Safety 678,450.00 50,984.45 238,457.16 35.15 439,992.84 Code Enforcement 98,750.00 7,065.92 35,073.69 35.52 63,676.31 Environmental 48,400.00 20,718.11 27,608.80 57.04 20,791.20 TOTAL Public Safety 7,250,650.00 533,812.25 2,564,980.55 35.38 4,685,669.45 Public Works Street Maintenance 1,355,450.00 73,112.35 355,066.91 26.20 1,000,383.09 Snow Removal 298,700.00 20,958.87 230,755.06 77.25 67,944.94 Equipment Services 210,400.00 16,861.35 75,654.70 35.96 134,745.30 Engineering 234,200.00 17,100.84 79,023.45 33.74 155,176.55 TOTAL Public Works 2,098,750.00 128,033.41 740,500.12 35.28 1,358,249.88 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND FINANCIAL SUMMARY 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Culture & Recreation Parks Department 1,118,800.00 76,163.26 340,669.17 30.45 778,130.83 Parks & Rec Admin 595,450.00 45,546.59 222,463.67 37.36 372,986.33 Recreation Programs 131,350.00 2,705.11 15,819.38 12.04 115,530.62 Sr Citizen Programs 251,500.00 19,160.31 85,940.24 34.17 165,559.76 TOTAL Culture & Recreation 2,097,100.00 143,575.27 664,892.46 31.71 1,432,207.54 Economic Development Economic Development 0.00 31.97 23,671.12 0.00 ( 23,671.12) Energy City 33,000.00 1,898.79 8,602.87 26.07 24,397.13 TOTAL Economic Development 33,000.00 1,930.76 32,273.99 97.80 726.01 General _____________ _____________ _____________ _______ _____________ TOTAL EXPENDITURES 15,229,550.00 1,079,290.12 5,271,641.28 34.61 9,957,908.72 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 782,089.11)( 4,047,850.81) 4,047,850.81 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND 41.67% 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 6,954.21 6,954.21 4.64 143,045.79 TOTAL Taxes 10,647,800.00 6,954.21 6,954.21 0.07 10,640,845.79 Licenses & Permits 101-3-0000-3211 Liquor License 70,000.00 75,125.00 75,545.00 107.92 ( 5,545.00) 101-3-0000-3213 Cigarette License 2,800.00 0.00 75.00 2.68 2,725.00 101-3-0000-3214 Rental License 65,000.00 3,747.00 38,162.00 58.71 26,838.00 101-3-0000-3216 Mining License 23,000.00 15,725.80 17,236.00 74.94 5,764.00 101-3-0000-3217 Garbage Hauler License 1,600.00 0.00 75.00 4.69 1,525.00 101-3-0000-3218 Other Business License/Permit 13,000.00 1,430.00 3,465.00 26.65 9,535.00 101-3-0000-3229 NPDES Permit 12,000.00 1,750.00 8,050.00 67.08 3,950.00 101-3-0000-3231 Building Permit 480,000.00 59,923.00 166,017.94 34.59 313,982.06 101-3-0000-3232 Plumbing/Heating Permit 195,000.00 10,994.24 33,429.22 17.14 161,570.78 101-3-0000-3233 Permit Surcharge 1,000.00 2,030.10 4,602.26 460.23 ( 3,602.26) 101-3-0000-3235 Animal License 5,500.00 1,160.00 2,380.00 43.27 3,120.00 101-3-0000-3237 Other Non-Business Lic/Permit 9,000.00 1,225.00 4,085.00 45.39 4,915.00 TOTAL Licenses & Permits 877,900.00 173,110.14 353,122.42 40.22 524,777.58 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 20,796.34 83.19 4,203.66 101-3-0000-3330 Other State Grants 0.00 0.00 7,250.00 0.00 ( 7,250.00) TOTAL Intergovernmental Rev 324,500.00 0.00 28,046.34 8.64 296,453.66 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 32,000.00 2,475.00 13,842.50 43.26 18,157.50 101-3-0000-3413 Plan Check Fee 200,000.00 24,549.09 80,273.62 40.14 119,726.38 101-3-0000-3415 Special Assessment Search 800.00 25.00 75.00 9.38 725.00 101-3-0000-3417 Copies 2,500.00 221.12 1,668.47 66.74 831.53 101-3-0000-3418 Other General Govt Services 5,000.00 825.00 890.00 17.80 4,110.00 101-3-0000-3430 Lockout Fees 6,500.00 420.00 2,140.00 32.92 4,360.00 101-3-0000-3431 Police Services 9,000.00 110.00 220.00 2.44 8,780.00 101-3-0000-3432 School Liaison 130,000.00 0.00 61,812.00 47.55 68,188.00 101-3-0000-3434 Animal Impound Fee 4,000.00 500.00 1,575.00 39.38 2,425.00 101-3-0000-3436 Fire Contracts 255,000.00 0.00 150,580.00 59.05 104,420.00 101-3-0000-3437 Fire Services 2,000.00 15.00 39.50 1.98 1,960.50 101-3-0000-3451 Street Services 20,000.00 1,719.47 6,651.53 33.26 13,348.47 101-3-0000-3452 Engineering Services Reimb 125,000.00 0.00 12,129.27 9.70 112,870.73 101-3-0000-3461 Recreation Fees 75,000.00 6,876.75 35,166.98 46.89 39,833.02 101-3-0000-3462 Sr Center Activities 35,000.00 1,704.00 13,119.00 37.48 21,881.00 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND 41.67% 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 480.00 10,568.30 44.03 13,431.70 101-3-0000-3475 Building Rent 2,400.00 200.00 1,000.00 41.67 1,400.00 101-3-0000-3483 Sewer Inspection Fee 9,000.00 755.00 3,590.00 39.89 5,410.00 101-3-0000-3484 Contractor License Check 700.00 100.00 400.00 57.14 300.00 TOTAL Charges for Services 937,900.00 40,975.43 395,741.17 42.19 542,158.83 Fines & Forfeits 101-3-0000-3510 Court Fines 145,000.00 12,300.22 41,067.50 28.32 103,932.50 101-3-0000-3511 Parking Fines 6,000.00 820.00 7,240.00 120.67 ( 1,240.00) TOTAL Fines & Forfeits 151,000.00 13,120.22 48,307.50 31.99 102,692.50 Special Assessments _____________ _____________ _____________ _______ _____________ Other Revenue 101-3-0000-3621 Interest Income 90,000.00 0.00 39,030.40 43.37 50,969.60 101-3-0000-3625 Refunds & Reimbursements 110,000.00 ( 25,245.00) 2,107.56 1.92 107,892.44 101-3-0000-3626 Contributions 20,000.00 4,319.44 20,319.44 101.60 ( 319.44) 101-3-0000-3629 Miscellaneous Revenue 6,500.00 251.61 2,127.12 32.72 4,372.88 TOTAL Other Revenue 226,500.00 ( 20,673.95) 63,584.52 28.07 162,915.48 Transfers In 101-3-0000-3921 Transfers 0.00 0.00 421.68 0.00 ( 421.68) 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 83,714.96 327,612.63 28.12 837,387.37 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 83,714.96 328,034.31 15.89 1,735,915.69 _____________________________________________________________________________ TOTAL General Fund 15,229,550.00 297,201.01 1,223,790.47 8.04 14,005,759.53 ___________________________________________________________________________________________________________________ TOTAL REVENUE 15,229,550.00 297,201.01 1,223,790.47 8.04 14,005,759.53 ============= ============= ============= ======= ============= 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND 41.67% 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 16,041.60 41.67 22,458.40 101-4-1110-4104 PERA 1,500.00 100.01 500.05 33.34 999.95 101-4-1110-4105 FICA 1,000.00 74.91 374.58 37.46 625.42 101-4-1110-4107 Medicare 600.00 46.53 232.64 38.77 367.36 101-4-1110-4109 Workers Comp 100.00 0.00 27.00 27.00 73.00 TOTAL Personal Services 41,700.00 3,429.77 17,175.87 41.19 24,524.13 Supplies 101-4-1110-4201 Office Supplies 750.00 3.47 210.18 28.02 539.82 TOTAL Supplies 750.00 3.47 210.18 28.02 539.82 Other Services & Charges 101-4-1110-4319 Other Professional Services 10,500.00 0.00 11,259.15 107.23 ( 759.15) 101-4-1110-4322 Postage 50.00 0.00 25.47 50.94 24.53 101-4-1110-4331 Travel, Conferences & Schools 2,600.00 0.00 67.71 2.60 2,532.29 101-4-1110-4359 Publishing 3,700.00 248.00 429.90 11.62 3,270.10 101-4-1110-4361 Insurance 42,000.00 0.00 20,312.00 48.36 21,688.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 479.20 6,271.56 18.20 28,178.44 TOTAL Other Services & Charges 112,850.00 727.20 38,365.79 34.00 74,484.21 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Mayor & Council 155,300.00 4,160.44 55,751.84 35.90 99,548.16 Communications ============== Personal Services 101-4-1120-4101 Regular Pay 192,700.00 9,823.14 46,659.92 24.21 146,040.08 101-4-1120-4103 Part-time Pay 18,850.00 732.25 3,293.31 17.47 15,556.69 101-4-1120-4104 PERA 16,450.00 791.66 3,746.52 22.78 12,703.48 101-4-1120-4105 FICA 13,300.00 656.24 3,105.62 23.35 10,194.38 101-4-1120-4107 Medicare 3,050.00 153.47 726.31 23.81 2,323.69 101-4-1120-4108 Insurance 20,950.00 1,389.00 6,945.00 33.15 14,005.00 101-4-1120-4109 Workers Comp 500.00 0.00 480.50 96.10 19.50 TOTAL Personal Services 265,800.00 13,545.76 64,957.18 24.44 200,842.82 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND General Government 41.67% 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 4,032.65 6,722.44 53.35 5,877.56 TOTAL Supplies 12,600.00 4,032.65 6,722.44 53.35 5,877.56 Other Services & Charges 101-4-1120-4319 Other Professional Services 19,750.00 100.00 4,661.00 23.60 15,089.00 101-4-1120-4321 Telephone 850.00 274.46 274.46 32.29 575.54 101-4-1120-4331 Travel, Conferences & Schools 6,750.00 0.00 0.00 0.00 6,750.00 101-4-1120-4359 Publishing 0.00 0.00 47.00 0.00 ( 47.00) 101-4-1120-4433 Dues & Subscriptions 1,150.00 678.35 678.35 58.99 471.65 TOTAL Other Services & Charges 28,500.00 1,052.81 5,660.81 19.86 22,839.19 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Communications 306,900.00 18,631.22 77,340.43 25.20 229,559.57 Administrative Services ======================= Personal Services 101-4-1210-4101 Regular Pay 335,350.00 25,438.30 115,351.00 34.40 219,999.00 101-4-1210-4102 Overtime Pay 0.00 0.00 17.44 0.00 ( 17.44) 101-4-1210-4103 Part-time Pay 49,850.00 4,415.48 17,578.42 35.26 32,271.58 101-4-1210-4104 PERA 28,900.00 2,239.02 9,970.94 34.50 18,929.06 101-4-1210-4105 FICA 24,000.00 1,882.93 8,421.95 35.09 15,578.05 101-4-1210-4107 Medicare 5,600.00 440.37 1,969.64 35.17 3,630.36 101-4-1210-4108 Insurance 28,250.00 1,798.00 8,356.20 29.58 19,893.80 101-4-1210-4109 Workers Comp 1,850.00 0.00 999.00 54.00 851.00 TOTAL Personal Services 473,800.00 36,214.10 162,664.59 34.33 311,135.41 Supplies 101-4-1210-4201 Office Supplies 7,300.00 69.51 1,206.68 16.53 6,093.32 TOTAL Supplies 7,300.00 69.51 1,206.68 16.53 6,093.32 Other Services & Charges 101-4-1210-4321 Telephone 1,950.00 ( 80.96) 399.96 20.51 1,550.04 101-4-1210-4322 Postage 800.00 0.00 282.25 35.28 517.75 101-4-1210-4331 Travel, Conferences & Schools 5,250.00 46.31 407.74 7.77 4,842.26 101-4-1210-4334 Car Allowance 4,800.00 400.00 2,000.00 41.67 2,800.00 101-4-1210-4361 Insurance 100.00 0.00 26.00 26.00 74.00 101-4-1210-4404 Equip Repair/Maint Services 15,750.00 0.00 1,773.25 11.26 13,976.75 101-4-1210-4433 Dues & Subscriptions 2,150.00 1,273.96 1,309.84 60.92 840.16 TOTAL Other Services & Charges 30,800.00 1,639.31 6,199.04 20.13 24,600.96 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND General Government 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Administrative Services 511,900.00 37,922.92 170,070.31 33.22 341,829.69 Human Resources =============== Personal Services 101-4-1220-4101 Regular Pay 127,400.00 9,694.16 46,047.25 36.14 81,352.75 101-4-1220-4104 PERA 9,550.00 727.06 3,453.53 36.16 6,096.47 101-4-1220-4105 FICA 7,900.00 587.27 2,791.92 35.34 5,108.08 101-4-1220-4107 Medicare 1,850.00 137.34 652.94 35.29 1,197.06 101-4-1220-4108 Insurance 17,250.00 1,189.00 7,021.00 40.70 10,229.00 101-4-1220-4109 Workers Comp 600.00 0.00 320.50 53.42 279.50 TOTAL Personal Services 164,550.00 12,334.83 60,287.14 36.64 104,262.86 Supplies 101-4-1220-4201 Office Supplies 3,500.00 62.82 3,270.63 93.45 229.37 TOTAL Supplies 3,500.00 62.82 3,270.63 93.45 229.37 Other Services & Charges 101-4-1220-4319 Other Professional Services 3,750.00 52.20 602.70 16.07 3,147.30 101-4-1220-4322 Postage 400.00 0.00 102.82 25.71 297.18 101-4-1220-4331 Travel, Conferences & Schools 4,200.00 0.00 524.23 12.48 3,675.77 101-4-1220-4404 Equip Repair/Maint 73,300.00 19,408.00 36,566.00 49.89 36,734.00 101-4-1220-4433 Dues & Subscriptions 850.00 674.05 874.05 102.83 ( 24.05) TOTAL Other Services & Charges 82,500.00 20,134.25 38,669.80 46.87 43,830.20 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Human Resources 250,550.00 32,531.90 102,227.57 40.80 148,322.43 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 345.04 345.04 9.58 3,254.96 TOTAL Supplies 3,600.00 345.04 345.04 9.58 3,254.96 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND General Government 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 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 80.00 80.00 11.43 620.00 101-4-1230-4404 Equip Repair/Maint Services 6,800.00 0.00 6,300.00 92.65 500.00 101-4-1230-4415 Equipment Rental 800.00 0.00 0.00 0.00 800.00 TOTAL Other Services & Charges 8,650.00 80.00 6,380.00 73.76 2,270.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Elections 42,250.00 425.04 6,725.04 15.92 35,524.96 Finance ======= Personal Services 101-4-1310-4101 Regular Pay 314,700.00 24,191.13 114,907.91 36.51 199,792.09 101-4-1310-4103 Part-time Pay 55,850.00 4,097.28 20,204.70 36.18 35,645.30 101-4-1310-4104 PERA 27,800.00 2,121.64 10,133.48 36.45 17,666.52 101-4-1310-4105 FICA 23,000.00 1,654.13 7,806.46 33.94 15,193.54 101-4-1310-4107 Medicare 5,400.00 386.86 1,825.70 33.81 3,574.30 101-4-1310-4108 Insurance 40,100.00 4,837.50 24,187.50 60.32 15,912.50 101-4-1310-4109 Workers Comp 1,700.00 0.00 932.00 54.82 768.00 TOTAL Personal Services 468,550.00 37,288.54 179,997.75 38.42 288,552.25 Supplies 101-4-1310-4201 Office Supplies 7,000.00 2,267.80 3,121.48 44.59 3,878.52 TOTAL Supplies 7,000.00 2,267.80 3,121.48 44.59 3,878.52 Other Services & Charges 101-4-1310-4301 Audit Fees 19,250.00 1,500.00 14,600.00 75.84 4,650.00 101-4-1310-4319 Other Professional Services 54,000.00 0.00 50.00 0.09 53,950.00 101-4-1310-4321 Telephone 900.00 39.99 159.96 17.77 740.04 101-4-1310-4322 Postage 2,900.00 0.00 963.20 33.21 1,936.80 101-4-1310-4331 Travel, Conferences & Schools 4,300.00 0.00 66.73 1.55 4,233.27 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 1,013.11 17,072.22 92.03 1,477.78 101-4-1310-4433 Dues & Subscriptions 1,850.00 330.00 705.00 38.11 1,145.00 101-4-1310-4438 Credit Card Fees 7,000.00 932.07 2,448.55 34.98 4,551.45 101-4-1310-4440 Miscellaneous 1,500.00 129.80 497.00 33.13 1,003.00 TOTAL Other Services & Charges 110,700.00 3,944.97 36,562.66 33.03 74,137.34 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Finance 586,250.00 43,501.31 219,681.89 37.47 366,568.11 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND General Government 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Information Technology ====================== Personal Services 101-4-1350-4101 Regular Pay 202,800.00 14,318.61 60,195.81 29.68 142,604.19 101-4-1350-4104 PERA 15,200.00 1,073.90 4,514.70 29.70 10,685.30 101-4-1350-4105 FICA 12,600.00 870.05 3,596.92 28.55 9,003.08 101-4-1350-4107 Medicare 2,950.00 203.47 841.21 28.52 2,108.79 101-4-1350-4108 Insurance 33,250.00 2,029.26 9,232.80 27.77 24,017.20 101-4-1350-4109 Workers Comp 950.00 0.00 510.00 53.68 440.00 TOTAL Personal Services 267,750.00 18,495.29 78,891.44 29.46 188,858.56 Supplies 101-4-1350-4219 Operating Supplies 19,300.00 507.13 3,800.71 19.69 15,499.29 TOTAL Supplies 19,300.00 507.13 3,800.71 19.69 15,499.29 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 108.50 8,892.45 317.59 ( 6,092.45) 101-4-1350-4331 Travel, Conferences & Schools 12,750.00 1,653.06 1,653.06 12.97 11,096.94 101-4-1350-4404 Equip Repair/Maint Services 117,700.00 6,068.68 43,272.41 36.77 74,427.59 TOTAL Other Services & Charges 144,250.00 7,830.24 53,817.92 37.31 90,432.08 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Information Technology 431,300.00 26,832.66 136,510.07 31.65 294,789.93 Legal ===== Other Services & Charges 101-4-1400-4304 Legal Fees 230,000.00 21,227.48 66,158.07 28.76 163,841.93 TOTAL Other Services & Charges 230,000.00 21,227.48 66,158.07 28.76 163,841.93 ___________________________________________________________________________________________________________________ TOTAL Legal 230,000.00 21,227.48 66,158.07 28.76 163,841.93 Community Development ===================== Personal Services 101-4-1500-4101 Regular Pay 118,350.00 9,104.54 43,246.56 36.54 75,103.44 101-4-1500-4104 PERA 8,900.00 682.84 3,243.49 36.44 5,656.51 101-4-1500-4105 FICA 7,350.00 547.98 2,602.88 35.41 4,747.12 101-4-1500-4107 Medicare 1,700.00 128.16 608.74 35.81 1,091.26 101-4-1500-4108 Insurance 8,650.00 1,549.50 7,747.50 89.57 902.50 101-4-1500-4109 Workers Comp 550.00 0.00 297.50 54.09 252.50 TOTAL Personal Services 145,500.00 12,013.02 57,746.67 39.69 87,753.33 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND General Government 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1500-4201 Office Supplies 600.00 24.32 96.81 16.14 503.19 TOTAL Supplies 600.00 24.32 96.81 16.14 503.19 Other Services & Charges 101-4-1500-4321 Telephone 800.00 94.99 289.96 36.25 510.04 101-4-1500-4331 Travel, Conferences & Schools 2,600.00 0.00 689.95 26.54 1,910.05 101-4-1500-4433 Dues & Subscriptions 550.00 0.00 250.00 45.45 300.00 TOTAL Other Services & Charges 3,950.00 94.99 1,229.91 31.14 2,720.09 ___________________________________________________________________________________________________________________ TOTAL Community Development 150,050.00 12,132.33 59,073.39 39.37 90,976.61 Planning ======== Personal Services 101-4-1510-4101 Regular Pay 290,500.00 17,390.50 99,719.52 34.33 190,780.48 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,304.28 7,261.22 33.31 14,538.78 101-4-1510-4105 FICA 18,600.00 1,028.51 5,914.69 31.80 12,685.31 101-4-1510-4107 Medicare 4,350.00 240.55 1,383.28 31.80 2,966.72 101-4-1510-4108 Insurance 37,250.00 2,448.50 14,026.00 37.65 23,224.00 101-4-1510-4109 Workers Comp 1,100.00 0.00 592.50 53.86 507.50 TOTAL Personal Services 382,950.00 22,412.34 128,897.21 33.66 254,052.79 Supplies 101-4-1510-4201 Office Supplies 2,500.00 41.69 147.72 5.91 2,352.28 101-4-1510-4212 Fuels & Lubes 300.00 0.00 7.22 2.41 292.78 101-4-1510-4219 Operating Supplies 2,000.00 0.00 1,919.77 95.99 80.23 TOTAL Supplies 4,800.00 41.69 2,074.71 43.22 2,725.29 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 75.94 338.48 26.04 961.52 101-4-1510-4331 Travel, Conferences & Schools 3,300.00 0.00 366.42 11.10 2,933.58 101-4-1510-4359 Publishing 10,000.00 875.00 1,811.00 18.11 8,189.00 101-4-1510-4361 Insurance 100.00 0.00 26.00 26.00 74.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 547.00 54.70 453.00 101-4-1510-4440 Miscellaneous 500.00 0.00 46.00 9.20 454.00 TOTAL Other Services & Charges 18,050.00 950.94 4,034.90 22.35 14,015.10 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Planning 405,800.00 23,404.97 135,006.82 33.27 270,793.18 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND General Government 41.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Building Maintenance ==================== Personal Services 101-4-1600-4101 Regular Pay 364,600.00 28,042.96 133,547.83 36.63 231,052.17 101-4-1600-4102 Overtime Pay 3,500.00 384.12 770.24 22.01 2,729.76 101-4-1600-4103 Part-time Pay 3,650.00 126.00 126.00 3.45 3,524.00 101-4-1600-4104 PERA 27,650.00 2,132.03 10,073.84 36.43 17,576.16 101-4-1600-4105 FICA 23,050.00 1,771.18 8,361.56 36.28 14,688.44 101-4-1600-4107 Medicare 5,400.00 414.23 1,955.54 36.21 3,444.46 101-4-1600-4108 Insurance 54,150.00 4,609.50 20,992.88 38.77 33,157.12 101-4-1600-4109 Workers Comp 12,250.00 0.00 6,692.50 54.63 5,557.50 TOTAL Personal Services 494,250.00 37,480.02 182,520.39 36.93 311,729.61 Supplies 101-4-1600-4212 Fuels & Lubes 3,000.00 285.26 1,257.30 41.91 1,742.70 101-4-1600-4217 Uniform Allowance 2,200.00 781.05 1,270.93 57.77 929.07 101-4-1600-4219 Operating Supplies 33,500.00 2,592.51 10,511.77 31.38 22,988.23 TOTAL Supplies 38,700.00 3,658.82 13,040.00 33.70 25,660.00 Other Services & Charges 101-4-1600-4321 Telephone 12,850.00 257.52 4,650.60 36.19 8,199.40 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 0.00 305.00 15.25 1,695.00 101-4-1600-4361 Insurance 5,500.00 0.00 2,456.00 44.65 3,044.00 101-4-1600-4389 Utilities 75,750.00 8,584.85 28,627.10 37.79 47,122.90 101-4-1600-4401 Bldg Repair/Maint Services 40,800.00 861.95 4,724.17 11.58 36,075.83 101-4-1600-4404 Equip Repair/Maint Services 6,000.00 0.00 2,500.47 41.67 3,499.53 101-4-1600-4460 Equip Replacement Charge 3,900.00 325.00 1,625.00 41.67 2,275.00 TOTAL Other Services & Charges 146,800.00 10,029.32 44,888.34 30.58 101,911.66 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Maintenance 679,750.00 51,168.16 240,448.73 35.37 439,301.27 Contingency =========== Personal Service s _____________ _____________ _____________ _______ _____________ Other Services & Charge s _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL General Government 3,750,050.00 271,938.43 1,268,994.16 33.84 2,481,055.84 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Public Safety 41.67% 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 28,567.82 135,697.08 35.44 247,202.92 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 4,280.26 20,331.23 35.33 37,218.77 101-4-2110-4105 FICA 3,500.00 266.40 1,265.41 36.15 2,234.59 101-4-2110-4107 Medicare 5,600.00 404.96 1,923.49 34.35 3,676.51 101-4-2110-4108 Insurance 28,250.00 2,826.00 14,130.00 50.02 14,120.00 101-4-2110-4109 Workers Comp 86,600.00 0.00 49,905.00 57.63 36,695.00 TOTAL Personal Services 566,900.00 36,345.44 223,252.21 39.38 343,647.79 Supplies 101-4-2110-4201 Office Supplies 11,000.00 176.76 1,863.77 16.94 9,136.23 101-4-2110-4217 Uniform Allowance 3,050.00 0.00 837.38 27.46 2,212.62 101-4-2110-4219 Operating Supplies 25,500.00 119.97 8,922.75 34.99 16,577.25 TOTAL Supplies 39,550.00 296.73 11,623.90 29.39 27,926.10 Other Services & Charges 101-4-2110-4319 Other Professional Services 7,900.00 92.43 5,753.92 72.83 2,146.08 101-4-2110-4321 Telephone 34,600.00 2,190.49 9,992.28 28.88 24,607.72 101-4-2110-4322 Postage 2,400.00 18.08 475.08 19.80 1,924.92 101-4-2110-4331 Travel, Conferences & Schools 17,200.00 424.25 2,969.25 17.26 14,230.75 101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2110-4361 Insurance 40,500.00 0.00 19,373.00 47.83 21,127.00 101-4-2110-4404 Equip Repair/Maint Services 71,800.00 6,615.00 53,509.11 74.53 18,290.89 101-4-2110-4433 Dues & Subscriptions 15,100.00 453.40 11,410.44 75.57 3,689.56 101-4-2110-4437 Taxes & Licenses 200.00 22.00 88.00 44.00 112.00 TOTAL Other Services & Charges 190,200.00 9,815.65 103,571.08 54.45 86,628.92 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Administration 796,650.00 46,457.82 338,447.19 42.48 458,202.81 Patrol ====== Personal Services 101-4-2120-4101 Regular Pay 1,782,350.00 129,839.75 580,248.01 32.56 1,202,101.99 101-4-2120-4102 Overtime Pay 100,000.00 3,902.15 18,347.27 18.35 81,652.73 101-4-2120-4104 PERA 304,900.00 21,666.19 96,972.42 31.80 207,927.58 101-4-2120-4107 Medicare 27,250.00 1,916.64 8,589.40 31.52 18,660.60 101-4-2120-4108 Insurance 173,100.00 14,954.00 70,610.25 40.79 102,489.75 TOTAL Personal Services 2,387,600.00 172,278.73 774,767.35 32.45 1,612,832.65 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Public Safety 41.67% 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 7,447.55 33,305.66 35.06 61,694.34 101-4-2120-4217 Uniform Allowance 21,000.00 826.65 4,776.33 22.74 16,223.67 101-4-2120-4219 Operating Supplies 79,700.00 8,058.05 10,977.14 13.77 68,722.86 101-4-2120-4221 Equipment Parts 23,300.00 588.87 2,523.86 10.83 20,776.14 TOTAL Supplies 219,000.00 16,921.12 51,582.99 23.55 167,417.01 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 28,250.00 1,881.37 13,566.37 48.02 14,683.63 101-4-2120-4404 Equip Repair/Maint Services 20,800.00 44.95 7,149.83 34.37 13,650.17 101-4-2120-4433 Dues & Subscriptions 650.00 60.00 210.00 32.31 440.00 101-4-2120-4440 Misc. - Grant Distribution 0.00 0.00 18,158.74 0.00 ( 18,158.74) 101-4-2120-4460 Equip Replacement Charge 50,000.00 4,166.67 20,833.35 41.67 29,166.65 TOTAL Other Services & Charges 99,700.00 6,152.99 59,918.29 60.10 39,781.71 Capital Outlay 101-4-2120-4560 Equipment 15,000.00 0.00 12,900.00 86.00 2,100.00 TOTAL Capital Outlay 15,000.00 0.00 12,900.00 86.00 2,100.00 ___________________________________________________________________________________________________________________ TOTAL Patrol 2,721,300.00 195,352.84 899,168.63 33.04 1,822,131.37 Investigations ============== Personal Services 101-4-2130-4101 Regular Pay 721,150.00 51,099.20 242,486.64 33.62 478,663.36 101-4-2130-4102 Overtime Pay 55,000.00 986.91 7,389.29 13.44 47,610.71 101-4-2130-4104 PERA 125,750.00 8,437.94 40,479.88 32.19 85,270.12 101-4-2130-4107 Medicare 11,250.00 725.06 3,482.74 30.96 7,767.26 101-4-2130-4108 Insurance 81,850.00 6,811.24 34,646.20 42.33 47,203.80 TOTAL Personal Services 995,000.00 68,060.35 328,484.75 33.01 666,515.25 Supplies 101-4-2130-4217 Uniform Allowance 7,100.00 1,066.25 2,095.39 29.51 5,004.61 101-4-2130-4219 Operating Supplies 9,800.00 654.01 898.49 9.17 8,901.51 TOTAL Supplies 16,900.00 1,720.26 2,993.88 17.72 13,906.12 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 726.00 10,724.97 70.33 4,525.03 101-4-2130-4433 Dues & Subscriptions 3,700.00 0.00 472.04 12.76 3,227.96 101-4-2130-4460 Equip Replacement Charge 15,500.00 1,291.67 6,458.35 41.67 9,041.65 TOTAL Other Services & Charges 41,950.00 2,017.67 17,655.36 42.09 24,294.64 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Public Safety 41.67% 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 71,798.28 349,133.99 33.13 704,716.01 Police Support Services ======================= Personal Services 101-4-2150-4101 Regular Pay 459,300.00 34,741.04 164,378.76 35.79 294,921.24 101-4-2150-4102 Overtime Pay 7,500.00 209.40 3,199.98 42.67 4,300.02 101-4-2150-4103 Part-time Pay 43,500.00 3,038.40 13,514.92 31.07 29,985.08 101-4-2150-4104 PERA 46,550.00 3,477.78 16,590.11 35.64 29,959.89 101-4-2150-4105 FICA 25,750.00 1,859.03 8,849.45 34.37 16,900.55 101-4-2150-4107 Medicare 7,400.00 533.86 2,545.60 34.40 4,854.40 101-4-2150-4108 Insurance 77,850.00 7,404.00 36,423.75 46.79 41,426.25 TOTAL Personal Services 667,850.00 51,263.51 245,502.57 36.76 422,347.43 Supplies 101-4-2150-4201 Office Supplies 1,000.00 0.00 756.54 75.65 243.46 101-4-2150-4217 Uniform Allowance 5,900.00 538.73 887.13 15.04 5,012.87 101-4-2150-4219 Operating Supplies 13,400.00 1,189.28 ( 368.39) 2.75- 13,768.39 TOTAL Supplies 20,300.00 1,728.01 1,275.28 6.28 19,024.72 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 6,400.00 981.37 1,011.81 15.81 5,388.19 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 110.00 694.00 8.68 7,306.00 101-4-2150-4433 Dues & Subscriptions 550.00 0.00 300.00 54.55 250.00 101-4-2150-4460 Equip Replacement Charge 6,000.00 500.00 2,500.00 41.67 3,500.00 TOTAL Other Services & Charges 23,350.00 1,591.37 4,505.81 19.30 18,844.19 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Support Services 711,500.00 54,582.89 251,283.66 35.32 460,216.34 Police Reserves =============== Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 0.00 228.78 4.16 5,271.22 101-4-2160-4105 FICA 350.00 0.00 14.19 4.05 335.81 101-4-2160-4107 Medicare 100.00 0.00 3.32 3.32 96.68 TOTAL Personal Services 5,950.00 0.00 246.29 4.14 5,703.71 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Public Safety 41.67% 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 547.35 18.25 2,452.65 TOTAL Supplies 8,500.00 0.00 547.35 6.44 7,952.65 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 885.00 885.00 27.66 2,315.00 TOTAL Other Services & Charges 5,300.00 885.00 885.00 16.70 4,415.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Reserves 19,750.00 885.00 1,678.64 8.50 18,071.36 Public safety building ====================== Personal Service s _____________ _____________ _____________ _______ _____________ Supplies 101-4-2190-4219 Operating Supplies 23,600.00 2,165.63 12,467.20 52.83 11,132.80 TOTAL Supplies 23,600.00 2,165.63 12,467.20 52.83 11,132.80 Other Services & Charges 101-4-2190-4361 Insurance 5,200.00 0.00 2,390.00 45.96 2,810.00 101-4-2190-4389 Utilities 98,000.00 13,563.88 41,601.25 42.45 56,398.75 101-4-2190-4401 Bldg Repair/Maint Services 40,200.00 521.45 5,968.61 14.85 34,231.39 TOTAL Other Services & Charges 143,400.00 14,085.33 49,959.86 34.84 93,440.14 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Public safety building 167,000.00 16,250.96 62,427.06 37.38 104,572.94 Fire Administration =================== Personal Services 101-4-2310-4101 Regular Pay 259,200.00 19,295.32 93,048.41 35.90 166,151.59 101-4-2310-4104 PERA 37,900.00 2,821.97 13,630.44 35.96 24,269.56 101-4-2310-4105 FICA 2,900.00 235.16 1,116.98 38.52 1,783.02 101-4-2310-4106 Other Retirement Contributions 30,000.00 0.00 1,000.00 3.33 29,000.00 101-4-2310-4107 Medicare 3,750.00 272.99 1,316.90 35.12 2,433.10 101-4-2310-4108 Insurance 30,050.00 2,448.50 12,613.57 41.98 17,436.43 101-4-2310-4109 Workers Comp 11,850.00 0.00 6,500.50 54.86 5,349.50 TOTAL Personal Services 375,650.00 25,073.94 129,226.80 34.40 246,423.20 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Public Safety 41.67% 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 21.09 87.18 4.47 1,862.82 101-4-2310-4212 Fuels & Lubes 4,500.00 364.82 1,649.36 36.65 2,850.64 101-4-2310-4217 Uniform Allowance 1,500.00 0.00 1,992.72 132.85 ( 492.72) 101-4-2310-4219 Operating Supplies 1,000.00 0.00 2,158.90 215.89 ( 1,158.90) 101-4-2310-4221 Equipment Parts 500.00 0.00 0.00 0.00 500.00 TOTAL Supplies 9,450.00 385.91 5,888.16 62.31 3,561.84 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 34.99 918.13 29.62 2,181.87 101-4-2310-4322 Postage 650.00 0.00 278.63 42.87 371.37 101-4-2310-4331 Travel, Conferences & Schools 5,000.00 0.00 2,136.97 42.74 2,863.03 101-4-2310-4359 Publishing 750.00 0.00 0.00 0.00 750.00 101-4-2310-4361 Insurance 8,300.00 0.00 3,806.00 45.86 4,494.00 101-4-2310-4389 Utilities 16,250.00 2,584.70 10,189.29 62.70 6,060.71 101-4-2310-4401 Bldg Repair/Maint Services 10,000.00 155.00 5,417.93 54.18 4,582.07 101-4-2310-4404 Equip Repair/Maint Services 3,450.00 0.00 2,033.26 58.94 1,416.74 101-4-2310-4433 Dues & Subscriptions 2,100.00 0.00 2,173.00 103.48 ( 73.00) 101-4-2310-4460 Equip Replacement Charge 65,000.00 5,416.67 27,083.35 41.67 37,916.65 TOTAL Other Services & Charges 122,100.00 8,191.36 54,036.56 44.26 68,063.44 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Administration 507,200.00 33,651.21 189,151.52 37.29 318,048.48 Fire Operations =============== Personal Services 101-4-2320-4103 Part-time Pay 188,700.00 15,221.61 71,286.50 37.78 117,413.50 101-4-2320-4105 FICA 11,700.00 940.63 4,366.98 37.32 7,333.02 101-4-2320-4107 Medicare 2,750.00 219.90 1,030.49 37.47 1,719.51 101-4-2320-4108 Insurance 0.00 126.89 250.58 0.00 ( 250.58) 101-4-2320-4109 Workers Comp 38,750.00 0.00 21,706.50 56.02 17,043.50 TOTAL Personal Services 241,900.00 16,509.03 98,641.05 40.78 143,258.95 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 659.23 3,075.12 39.42 4,724.88 101-4-2320-4217 Uniform Allowance 9,000.00 1,772.60 2,732.05 30.36 6,267.95 101-4-2320-4219 Operating Supplies 85,150.00 5,348.20 32,879.03 38.61 52,270.97 101-4-2320-4221 Equipment Parts 10,000.00 530.43 925.85 9.26 9,074.15 TOTAL Supplies 112,250.00 8,310.46 39,612.05 35.29 72,637.95 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Public Safety 41.67% 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 523.08 1,978.37 44.96 2,421.63 101-4-2320-4331 Travel, Conferences & Schools 20,750.00 1,204.32 4,657.27 22.44 16,092.73 101-4-2320-4404 Equip Repair/Maint Services 35,200.00 7,169.36 18,417.83 52.32 16,782.17 101-4-2320-4409 Contractual Services 6,300.00 0.00 3,980.00 63.17 2,320.00 TOTAL Other Services & Charges 66,650.00 8,896.76 29,033.47 43.56 37,616.53 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Operations 420,800.00 33,716.25 167,286.57 39.75 253,513.43 Emergency Management ==================== Personal Service s _____________ _____________ _____________ _______ _____________ Supplies 101-4-2330-4219 Operating Supplies 7,500.00 1,326.66 2,861.90 38.16 4,638.10 TOTAL Supplies 7,500.00 1,326.66 2,861.90 38.16 4,638.10 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 496.86 1,876.74 44.68 2,323.26 101-4-2330-4404 Equip Repair/Maint Services 6,950.00 525.00 525.00 7.55 6,425.00 101-4-2330-4433 Dues & Subscriptions 250.00 0.00 0.00 0.00 250.00 TOTAL Other Services & Charges 19,500.00 1,021.86 2,401.74 12.32 17,098.26 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Emergency Management 27,000.00 2,348.52 5,263.64 19.49 21,736.36 Building Safety =============== Personal Services 101-4-2410-4101 Regular Pay 477,300.00 36,597.02 163,344.14 34.22 313,955.86 101-4-2410-4103 Part-time Pay 0.00 0.00 4,481.01 0.00 ( 4,481.01) 101-4-2410-4104 PERA 42,650.00 3,271.50 14,856.18 34.83 27,793.82 101-4-2410-4105 FICA 24,700.00 1,760.77 8,177.33 33.11 16,522.67 101-4-2410-4107 Medicare 6,900.00 497.93 2,311.89 33.51 4,588.11 101-4-2410-4108 Insurance 86,900.00 7,172.50 32,609.00 37.52 54,291.00 101-4-2410-4109 Workers Comp 1,800.00 0.00 971.00 53.94 829.00 TOTAL Personal Services 640,250.00 49,299.72 226,750.55 35.42 413,499.45 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Public Safety 41.67% 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 41.69 184.42 4.39 4,015.58 101-4-2410-4212 Fuels & Lubes 7,200.00 675.34 2,964.24 41.17 4,235.76 101-4-2410-4217 Uniform Allowance 1,750.00 0.00 146.75 8.39 1,603.25 101-4-2410-4219 Operating Supplies 7,250.00 0.00 189.17 2.61 7,060.83 TOTAL Supplies 20,400.00 717.03 3,484.58 17.08 16,915.42 Other Services & Charges 101-4-2410-4321 Telephone 4,600.00 352.70 1,425.85 31.00 3,174.15 101-4-2410-4322 Postage 350.00 0.00 25.00 7.14 325.00 101-4-2410-4331 Travel, Conferences & Schools 4,150.00 0.00 2,202.72 53.08 1,947.28 101-4-2410-4361 Insurance 600.00 0.00 218.00 36.33 382.00 101-4-2410-4404 Equip Repair/Maint Services 3,500.00 300.00 2,785.46 79.58 714.54 101-4-2410-4433 Dues & Subscriptions 1,600.00 65.00 315.00 19.69 1,285.00 101-4-2410-4460 Equip Replacement Charge 3,000.00 250.00 1,250.00 41.67 1,750.00 TOTAL Other Services & Charges 17,800.00 967.70 8,222.03 46.19 9,577.97 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Safety 678,450.00 50,984.45 238,457.16 35.15 439,992.84 Code Enforcement ================ Personal Services 101-4-2420-4101 Regular Pay 73,850.00 5,681.60 26,987.60 36.54 46,862.40 101-4-2420-4104 PERA 5,550.00 426.12 2,024.07 36.47 3,525.93 101-4-2420-4105 FICA 4,600.00 365.04 1,732.47 37.66 2,867.53 101-4-2420-4107 Medicare 1,100.00 85.37 405.17 36.83 694.83 101-4-2420-4108 Insurance 3,650.00 304.50 1,522.50 41.71 2,127.50 101-4-2420-4109 Workers Comp 250.00 0.00 141.50 56.60 108.50 TOTAL Personal Services 89,000.00 6,862.63 32,813.31 36.87 56,186.69 Supplies 101-4-2420-4212 Fuels & Lubes 1,750.00 103.66 499.33 28.53 1,250.67 101-4-2420-4217 Uniform Allowance 350.00 0.00 487.97 139.42 ( 137.97) 101-4-2420-4219 Operating Supplies 3,250.00 0.00 143.95 4.43 3,106.05 TOTAL Supplies 5,350.00 103.66 1,131.25 21.14 4,218.75 Other Services & Charges 101-4-2420-4321 Telephone 850.00 24.63 94.03 11.06 755.97 101-4-2420-4322 Postage 1,750.00 0.00 155.10 8.86 1,594.90 101-4-2420-4331 Travel, Conferences & Schools 800.00 0.00 465.00 58.13 335.00 101-4-2420-4361 Insurance 100.00 0.00 40.00 40.00 60.00 101-4-2420-4460 Equip Replacement Charge 900.00 75.00 375.00 41.67 525.00 TOTAL Other Services & Charges 4,400.00 99.63 1,129.13 25.66 3,270.87 ___________________________________________________________________________________________________________________ TOTAL Code Enforcement 98,750.00 7,065.92 35,073.69 35.52 63,676.31 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Public Safety 41.67% 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,363.54 6,476.82 35.78 11,623.18 101-4-2440-4104 PERA 1,350.00 107.31 490.83 36.36 859.17 101-4-2440-4105 FICA 1,100.00 88.87 406.47 36.95 693.53 101-4-2440-4107 Medicare 250.00 20.80 95.10 38.04 154.90 101-4-2440-4108 Insurance 2,600.00 178.40 891.77 34.30 1,708.23 101-4-2440-4109 Workers Comp 250.00 0.00 115.50 46.20 134.50 TOTAL Personal Services 23,650.00 1,758.92 8,476.49 35.84 15,173.51 Supplies 101-4-2440-4201 Office Supplies 300.00 3.47 12.31 4.10 287.69 101-4-2440-4212 Fuels & Lubes 200.00 0.00 38.05 19.03 161.95 101-4-2440-4219 Operating Supplies 5,350.00 0.00 19.44 0.36 5,330.56 TOTAL Supplies 5,850.00 3.47 69.80 1.19 5,780.20 Other Services & Charges 101-4-2440-4321 Telephone 350.00 0.00 0.00 0.00 350.00 101-4-2440-4322 Postage 0.00 0.00 16.71 0.00 ( 16.71) 101-4-2440-4331 Travel, Conferences & Schools 1,400.00 3,955.72 4,045.80 288.99 ( 2,645.80) 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 15,000.00 15,000.00 93.75 1,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 18,955.72 19,062.51 100.86 ( 162.51) ___________________________________________________________________________________________________________________ TOTAL Environmental 48,400.00 20,718.11 27,608.80 57.04 20,791.20 ___________________________________________________________________________________________________________________ TOTAL Public Safety 7,250,650.00 533,812.25 2,564,980.55 35.38 4,685,669.45 Street Maintenance ================== Personal Services 101-4-3120-4101 Regular Pay 518,000.00 30,257.53 99,948.67 19.30 418,051.33 101-4-3120-4102 Overtime Pay 4,000.00 324.66 324.66 8.12 3,675.34 101-4-3120-4103 Part-time Pay 84,650.00 5,332.32 26,234.99 30.99 58,415.01 101-4-3120-4104 PERA 43,800.00 2,585.54 9,037.83 20.63 34,762.17 101-4-3120-4105 FICA 37,650.00 2,171.89 7,700.74 20.45 29,949.26 101-4-3120-4107 Medicare 8,800.00 512.75 1,805.80 20.52 6,994.20 101-4-3120-4108 Insurance 81,450.00 4,969.87 16,772.23 20.59 64,677.77 101-4-3120-4109 Workers Comp 33,800.00 0.00 17,582.50 52.02 16,217.50 TOTAL Personal Services 812,150.00 46,154.56 179,407.42 22.09 632,742.58 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Public Works 41.67% 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 3.47 202.54 4.50 4,297.46 101-4-3120-4212 Fuels & Lubes 61,200.00 ( 4,896.39) 29,646.78 48.44 31,553.22 101-4-3120-4217 Uniform Allowance 6,600.00 834.02 1,421.16 21.53 5,178.84 101-4-3120-4219 Operating Supplies 55,300.00 2,431.47 16,043.57 29.01 39,256.43 101-4-3120-4221 Equipment Parts 52,000.00 4,894.56 12,418.79 23.88 39,581.21 101-4-3120-4226 Street Signs 31,000.00 ( 66.70) 5,895.70 19.02 25,104.30 TOTAL Supplies 210,600.00 3,200.43 65,628.54 31.16 144,971.46 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 417.76 2,226.16 29.49 5,323.84 101-4-3120-4322 Postage 100.00 0.00 30.88 30.88 69.12 101-4-3120-4331 Travel, Conferences & Schools 5,100.00 1,144.14 3,156.49 61.89 1,943.51 101-4-3120-4359 Publishing 200.00 0.00 0.00 0.00 200.00 101-4-3120-4361 Insurance 15,000.00 0.00 7,246.00 48.31 7,754.00 101-4-3120-4389 Utilities 92,800.00 4,548.94 25,578.91 27.56 67,221.09 101-4-3120-4401 Bldg Repair/Maint Services 23,000.00 6,784.52 12,121.66 52.70 10,878.34 101-4-3120-4404 Equip Repair/Maint Services 9,000.00 1,575.00 10,999.78 122.22 ( 1,999.78) 101-4-3120-4409 Contractual Services 65,500.00 0.00 1,377.07 2.10 64,122.93 101-4-3120-4415 Equipment Rental 2,000.00 0.00 0.00 0.00 2,000.00 101-4-3120-4433 Dues & Subscriptions 350.00 0.00 395.00 112.86 ( 45.00) 101-4-3120-4437 Taxes & Licenses 500.00 12.00 524.00 104.80 ( 24.00) 101-4-3120-4460 Equip Replacement Charge 111,300.00 9,275.00 46,375.00 41.67 64,925.00 TOTAL Other Services & Charges 332,700.00 23,757.36 110,030.95 33.07 222,669.05 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Street Maintenance 1,355,450.00 73,112.35 355,066.91 26.20 1,000,383.09 Snow Removal ============ Personal Services 101-4-3130-4101 Regular Pay 134,700.00 10,139.27 89,395.55 66.37 45,304.45 101-4-3130-4102 Overtime Pay 20,000.00 6,408.95 42,477.35 212.39 ( 22,477.35) 101-4-3130-4104 PERA 11,200.00 1,266.73 9,829.46 87.76 1,370.54 101-4-3130-4105 FICA 9,600.00 1,029.98 8,080.27 84.17 1,519.73 101-4-3130-4107 Medicare 2,250.00 236.09 1,884.94 83.78 365.06 101-4-3130-4108 Insurance 18,900.00 1,656.63 13,459.06 71.21 5,440.94 101-4-3130-4109 Workers Comp 9,050.00 0.00 4,971.00 54.93 4,079.00 TOTAL Personal Services 205,700.00 20,737.65 170,097.63 82.69 35,602.37 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Public Works 41.67% 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 221.22 60,657.43 65.22 32,342.57 TOTAL Supplies 93,000.00 221.22 60,657.43 65.22 32,342.57 Other Services & Charge s _____________ _____________ _____________ _______ _____________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Snow Removal 298,700.00 20,958.87 230,755.06 77.25 67,944.94 Equipment Services ================== Personal Services 101-4-3150-4101 Regular Pay 123,100.00 9,353.60 44,845.39 36.43 78,254.61 101-4-3150-4102 Overtime Pay 1,000.00 79.70 119.38 11.94 880.62 101-4-3150-4104 PERA 9,350.00 707.50 3,378.00 36.13 5,972.00 101-4-3150-4105 FICA 7,700.00 578.27 2,763.73 35.89 4,936.27 101-4-3150-4107 Medicare 1,800.00 135.25 646.36 35.91 1,153.64 101-4-3150-4108 Insurance 17,250.00 1,727.00 8,635.00 50.06 8,615.00 101-4-3150-4109 Workers Comp 3,050.00 0.00 1,617.00 53.02 1,433.00 TOTAL Personal Services 163,250.00 12,581.32 62,004.86 37.98 101,245.14 Supplies 101-4-3150-4212 Fuels & Lubes 5,100.00 2,900.71 2,778.36 54.48 2,321.64 101-4-3150-4219 Operating Supplies 20,650.00 1,358.45 6,681.13 32.35 13,968.87 101-4-3150-4221 Equipment Parts 5,000.00 20.87 869.60 17.39 4,130.40 TOTAL Supplies 30,750.00 4,280.03 10,329.09 33.59 20,420.91 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 3,320.75 26.57 9,179.25 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 3,320.75 20.25 13,079.25 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Equipment Services 210,400.00 16,861.35 75,654.70 35.96 134,745.30 Engineering =========== 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Public Works 41.67% 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 13,433.22 63,807.78 36.53 110,842.22 101-4-3300-4104 PERA 13,100.00 1,007.50 4,785.61 36.53 8,314.39 101-4-3300-4105 FICA 10,850.00 864.48 4,106.28 37.85 6,743.72 101-4-3300-4107 Medicare 2,550.00 202.18 960.34 37.66 1,589.66 101-4-3300-4108 Insurance 20,000.00 609.00 3,045.00 15.23 16,955.00 101-4-3300-4109 Workers Comp 600.00 0.00 334.00 55.67 266.00 TOTAL Personal Services 221,750.00 16,116.38 77,039.01 34.74 144,710.99 Supplies 101-4-3300-4201 Office Supplies 150.00 6.95 56.63 37.75 93.37 101-4-3300-4212 Fuels & Lubes 1,000.00 77.38 113.32 11.33 886.68 101-4-3300-4219 Operating Supplies 1,500.00 0.00 35.43 2.36 1,464.57 TOTAL Supplies 2,650.00 84.33 205.38 7.75 2,444.62 Other Services & Charges 101-4-3300-4319 Other Professional Services 4,000.00 608.00 608.00 15.20 3,392.00 101-4-3300-4321 Telephone 1,450.00 94.63 376.25 25.95 1,073.75 101-4-3300-4322 Postage 200.00 0.00 3.79 1.90 196.21 101-4-3300-4331 Travel, Conferences & Schools 1,650.00 122.50 376.02 22.79 1,273.98 101-4-3300-4361 Insurance 100.00 0.00 40.00 40.00 60.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 375.00 41.67 525.00 TOTAL Other Services & Charges 9,800.00 900.13 1,779.06 18.15 8,020.94 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Engineering 234,200.00 17,100.84 79,023.45 33.74 155,176.55 ___________________________________________________________________________________________________________________ TOTAL Public Works 2,098,750.00 128,033.41 740,500.12 35.28 1,358,249.88 Parks Department ================ Personal Services 101-4-5110-4101 Regular Pay 440,600.00 31,560.70 146,601.86 33.27 293,998.14 101-4-5110-4102 Overtime Pay 6,500.00 2,365.83 5,030.17 77.39 1,469.83 101-4-5110-4103 Part-time Pay 68,250.00 960.00 960.00 1.41 67,290.00 101-4-5110-4104 PERA 33,550.00 2,544.47 11,346.32 33.82 22,203.68 101-4-5110-4105 FICA 31,450.00 2,066.44 9,022.06 28.69 22,427.94 101-4-5110-4107 Medicare 7,350.00 483.26 2,109.97 28.71 5,240.03 101-4-5110-4108 Insurance 83,550.00 7,516.50 35,799.00 42.85 47,751.00 101-4-5110-4109 Workers Comp 17,100.00 0.00 9,144.50 53.48 7,955.50 101-4-5110-4110 Re-employment Compensation 0.00 1,794.00 1,794.00 0.00 ( 1,794.00) TOTAL Personal Services 688,350.00 49,291.20 221,807.88 32.22 466,542.12 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Culture & Recreation 41.67% 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 2,419.83 8,529.72 28.39 21,520.28 101-4-5110-4217 Uniform Allowance 3,800.00 237.80 1,075.88 28.31 2,724.12 101-4-5110-4219 Operating Supplies 106,550.00 8,705.95 28,408.25 26.66 78,141.75 101-4-5110-4221 Equipment Parts 27,000.00 2,419.15 7,716.65 28.58 19,283.35 TOTAL Supplies 167,400.00 13,782.73 45,730.50 27.32 121,669.50 Other Services & Charges 101-4-5110-4321 Telephone 4,700.00 416.65 1,731.62 36.84 2,968.38 101-4-5110-4322 Postage 100.00 0.00 30.36 30.36 69.64 101-4-5110-4331 Travel, Conferences & Schools 3,350.00 67.04 1,178.90 35.19 2,171.10 101-4-5110-4361 Insurance 33,500.00 0.00 16,068.00 47.96 17,432.00 101-4-5110-4389 Utilities 76,500.00 3,801.12 14,120.56 18.46 62,379.44 101-4-5110-4401 Bldg Repair/Maint Services 3,000.00 0.00 1,126.80 37.56 1,873.20 101-4-5110-4404 Equip Repair/Maint Services 20,000.00 1,069.49 4,110.41 20.55 15,889.59 101-4-5110-4409 Contractual Services 44,200.00 1,611.70 4,915.49 11.12 39,284.51 101-4-5110-4415 Equipment Rental 24,200.00 1,665.00 7,557.00 31.23 16,643.00 101-4-5110-4460 Equip Replacement Charge 53,500.00 4,458.33 22,291.65 41.67 31,208.35 TOTAL Other Services & Charges 263,050.00 13,089.33 73,130.79 27.80 189,919.21 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks Department 1,118,800.00 76,163.26 340,669.17 30.45 778,130.83 Parks & Rec Admin ================= Personal Services 101-4-5210-4101 Regular Pay 313,900.00 24,140.54 114,667.51 36.53 199,232.49 101-4-5210-4103 Part-time Pay 93,000.00 7,568.80 34,706.89 37.32 58,293.11 101-4-5210-4104 PERA 30,500.00 2,312.18 11,082.82 36.34 19,417.18 101-4-5210-4105 FICA 25,250.00 1,896.61 8,931.69 35.37 16,318.31 101-4-5210-4107 Medicare 5,900.00 443.57 2,088.87 35.40 3,811.13 101-4-5210-4108 Insurance 45,000.00 3,998.00 19,990.00 44.42 25,010.00 101-4-5210-4109 Workers Comp 3,500.00 0.00 1,809.50 51.70 1,690.50 TOTAL Personal Services 517,050.00 40,359.70 193,277.28 37.38 323,772.72 Supplies 101-4-5210-4219 Operating Supplies 10,050.00 461.20 3,417.51 34.01 6,632.49 TOTAL Supplies 10,050.00 461.20 3,417.51 34.01 6,632.49 Other Services & Charges 101-4-5210-4321 Telephone 3,450.00 318.52 1,370.31 39.72 2,079.69 101-4-5210-4322 Postage 5,300.00 0.00 136.47 2.57 5,163.53 101-4-5210-4331 Travel, Conferences & Schools 8,850.00 280.97 972.98 10.99 7,877.02 101-4-5210-4349 Advertising/Marketing 13,200.00 1,898.61 2,857.96 21.65 10,342.04 101-4-5210-4361 Insurance 450.00 0.00 202.00 44.89 248.00 101-4-5210-4389 Utilities 8,500.00 1,262.59 4,379.51 51.52 4,120.49 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Culture & Recreation 41.67% 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 965.00 5,619.96 32.67 11,580.04 101-4-5210-4404 Equip Repair/Maint Services 8,800.00 0.00 8,414.69 95.62 385.31 101-4-5210-4433 Dues & Subscriptions 2,600.00 0.00 1,815.00 69.81 785.00 TOTAL Other Services & Charges 68,350.00 4,725.69 25,768.88 37.70 42,581.12 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks & Rec Admin 595,450.00 45,546.59 222,463.67 37.36 372,986.33 Recreation Programs =================== Personal Services 101-4-5220-4103 Part-time Pay 43,000.00 1,238.32 8,156.34 18.97 34,843.66 101-4-5220-4105 FICA 2,200.00 76.79 505.68 22.99 1,694.32 101-4-5220-4107 Medicare 650.00 17.95 118.25 18.19 531.75 TOTAL Personal Services 45,850.00 1,333.06 8,780.27 19.15 37,069.73 Supplies 101-4-5220-4219 Operating Supplies 25,000.00 160.47 ( 5,285.98) 21.14- 30,285.98 TOTAL Supplies 25,000.00 160.47 ( 5,285.98) 21.14- 30,285.98 Other Services & Charges 101-4-5220-4409 Contractual Services 55,000.00 629.00 10,353.00 18.82 44,647.00 101-4-5220-4412 Building Rent 1,900.00 0.00 692.75 36.46 1,207.25 101-4-5220-4438 Credit Card Fees 3,600.00 582.58 1,279.34 35.54 2,320.66 TOTAL Other Services & Charges 60,500.00 1,211.58 12,325.09 20.37 48,174.91 ___________________________________________________________________________________________________________________ TOTAL Recreation Programs 131,350.00 2,705.11 15,819.38 12.04 115,530.62 Concessions =========== Personal Service s _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ Sr Citizen Programs =================== Personal Services 101-4-5510-4101 Regular Pay 127,700.00 9,822.40 46,656.40 36.54 81,043.60 101-4-5510-4103 Part-time Pay 10,150.00 656.50 2,872.13 28.30 7,277.87 101-4-5510-4104 PERA 10,350.00 736.68 3,499.23 33.81 6,850.77 101-4-5510-4105 FICA 8,550.00 662.99 3,133.95 36.65 5,416.05 101-4-5510-4107 Medicare 2,000.00 155.05 732.94 36.65 1,267.06 101-4-5510-4108 Insurance 20,950.00 899.00 4,495.00 21.46 16,455.00 101-4-5510-4109 Workers Comp 650.00 0.00 347.00 53.38 303.00 TOTAL Personal Services 180,350.00 12,932.62 61,736.65 34.23 118,613.35 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Culture & Recreation 41.67% 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 592.39 4,005.85 36.75 6,894.15 TOTAL Supplies 10,900.00 592.39 4,005.85 36.75 6,894.15 Other Services & Charges 101-4-5510-4321 Telephone 1,300.00 24.63 447.57 34.43 852.43 101-4-5510-4322 Postage 2,200.00 0.00 805.13 36.60 1,394.87 101-4-5510-4331 Travel, Conferences & Schools 3,050.00 287.94 915.94 30.03 2,134.06 101-4-5510-4361 Insurance 1,350.00 0.00 628.00 46.52 722.00 101-4-5510-4389 Utilities 22,650.00 2,830.46 8,755.48 38.66 13,894.52 101-4-5510-4401 Bldg Repair/Maint Services 16,700.00 819.00 4,263.00 25.53 12,437.00 101-4-5510-4404 Equip Repair/Maint Services 100.00 0.00 310.50 310.50 ( 210.50) 101-4-5510-4409 Contractual Services 12,000.00 1,558.74 3,353.06 27.94 8,646.94 101-4-5510-4433 Dues & Subscriptions 900.00 114.53 719.06 79.90 180.94 TOTAL Other Services & Charges 60,250.00 5,635.30 20,197.74 33.52 40,052.26 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Sr Citizen Programs 251,500.00 19,160.31 85,940.24 34.17 165,559.76 ___________________________________________________________________________________________________________________ TOTAL Culture & Recreation 2,097,100.00 143,575.27 664,892.46 31.71 1,432,207.54 Economic Development ==================== Personal Services 101-4-6210-4101 Regular Pay 0.00 0.00 16,836.19 0.00 ( 16,836.19) 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 0.00 1,277.72 0.00 ( 1,277.72) 101-4-6210-4105 FICA 0.00 ( 0.01) 1,052.68 0.00 ( 1,052.68) 101-4-6210-4107 Medicare 0.00 0.02 250.57 0.00 ( 250.57) 101-4-6210-4108 Insurance 0.00 0.00 3,001.60 0.00 ( 3,001.60) TOTAL Personal Services 0.00 0.01 23,468.76 0.00 ( 23,468.76) Other Services & Charges 101-4-6210-4361 Insurance 0.00 ( 53.00) 0.00 0.00 0.00 101-4-6210-4440 Miscellaneous 0.00 84.96 202.36 0.00 ( 202.36) TOTAL Other Services & Charges 0.00 31.96 202.36 0.00 ( 202.36) ___________________________________________________________________________________________________________________ TOTAL Economic Development 0.00 31.97 23,671.12 0.00 ( 23,671.12) 6-13-2018 04:20 PM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31ST, 2018 101-GENERAL FUND Economic Development 41.67% 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,363.54 6,476.85 35.78 11,623.15 101-4-6220-4104 PERA 1,350.00 100.10 483.59 35.82 866.41 101-4-6220-4105 FICA 1,100.00 82.91 400.51 36.41 699.49 101-4-6220-4107 Medicare 250.00 19.39 93.67 37.47 156.33 101-4-6220-4108 Insurance 2,600.00 178.32 891.72 34.30 1,708.28 TOTAL Personal Services 23,400.00 1,744.26 8,346.34 35.67 15,053.66 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-4319 Other Professional Services 0.00 0.00 47.00 0.00 ( 47.00) 101-4-6220-4331 Travel, Conferences & Schools 4,500.00 154.53 209.53 4.66 4,290.47 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 154.53 256.53 3.29 7,543.47 ___________________________________________________________________________________________________________________ TOTAL Energy City 33,000.00 1,898.79 8,602.87 26.07 24,397.13 ___________________________________________________________________________________________________________________ TOTAL Economic Development 33,000.00 1,930.76 32,273.99 97.80 726.01 Transfers Out ============= Transfers Out _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL EXPENDITURES 15,229,550.00 1,079,290.12 5,271,641.28 34.61 9,957,908.72 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 782,089.11)( 4,047,850.81) 4,047,850.81 o000 0 0 0 m — 'J � m v Q ml 1 h h h M V N W m Y � U c c c O bL O N 00 G — O O O SR z3 Y � i nu — - co M co o co N �� N N L O r. N N r O� •S IK Q c c c M V M N W M O O o r M r a+ r O Q _ To Ir V1 O� V1 h G] F L � r U N c c c 0 0 0 V V O O O O O 0] M v r u ^ _ V V O h N h y •S q 0 r r r O 'J l� N W h r �D v� M �D M W v� N O O O ^LJ Q N v bL — L O r N M a\ O r V N N r N M O M Q V O O 'J m U G O � T 6 S F G y 6 u n 0. O '� W O � '✓� � L ,� 121 lw lw vi 'A vi pG U C G O O A 'O u W w v y L � _,� A.F G 6-13-2018 04:24 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: MAY 31ST, 2018 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE ___________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 6,524.32 1,280.48 7,804.80 101-1010 Cash - General Fund 3,848,430.48 ( 797,441.24) 3,050,989.24 211-1010 Cash - Library 434,455.36 ( 7,313.29) 427,142.07 221-1010 Cash - Ice Arena 639,132.76 ( 404.59) 638,728.17 222-1010 Cash - Pinewood Golf Course 40.57 ( 5,138.28) ( 5,097.71) 225-1010 Cash - Park Dedication 202,778.24 0.00 202,778.24 228-1010 Cash - Landfill 314,408.77 ( 1,296.61) 313,112.16 231-1010 Cash - Landfill Const Debris 757,531.90 0.00 757,531.90 240-1010 Cash - Micro Loan Fund 714,781.62 7,188.06 721,969.68 242-1010 Cash - State DEED 220,327.12 1,886.49 222,213.61 245-1010 Cash - Development Fund 741,782.02 ( 850.50) 740,931.52 290-1010 Cash - Capital Outlay Reserve 953,409.43 ( 11,413.76) 941,995.67 291-1010 Cash - Insurance Reserve 157,354.05 ( 7,324.55) 150,029.50 292-1010 Cash - Govt Bldgs Reserve 1,890,613.63 ( 2,120.00) 1,888,493.63 294-1010 Cash - Drug Forfeiture 19,015.80 ( 707.13) 18,308.67 295-1010 Cash - Severance Pay Reserve 74,011.07 0.00 74,011.07 296-1010 Cash - GRE Reserve 2,167,471.48 0.00 2,167,471.48 333-1010 Cash - 2010A GO Cap Imp Bonds 336,463.67 ( 500.00) 335,963.67 345-1010 Cash - 2012A CIP Bonds-PW ( 500.00) 0.00 ( 500.00) 401-1010 Cash - Pavement Mgmt 3,625,381.01 117,787.07 3,743,168.08 403-1010 Cash - Street Improvement 761,076.93 ( 7,576.40) 753,500.53 406-1010 Cash - City Wide Trunk Util 4,038,344.00 0.00 4,038,344.00 410-1010 Cash - Equipment Replacement 330,538.48 35,963.09 366,501.57 440-1010 Cash - Park Improvement 252,019.17 ( 94,914.38) 157,104.79 463-1010 Cash - TIF #23 Pref Powder 2,343.23 0.00 2,343.23 464-1010 Cash - TIF #24 Beaudry Truck ( 320.00) ( 2,355.74) ( 2,675.74) 602-1010 Cash - Wastewater Treatment 3,588,338.42 200,412.39 3,788,750.81 603-1010 Cash - Liquor 4,096,752.74 104,582.37 4,201,335.11 605-1010 Cash - Garbage 255,146.00 5,175.83 260,321.83 607-1010 Cash - Storm Water 591,350.25 4,716.21 596,066.46 801-1010 Cash - Interest 0.00 87,005.25 87,005.25 821-1010 Cash - Developer Escrow 1,067,441.65 8,891.00 1,076,332.65_ TOTAL CLAIM ON CASH 32,086,444.17 ( 364,468.23) 31,721,975.94 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 96,612,119.93 610,370.69 97,222,490.62 999-1001 PY BANK ACCOUNT (92,907,865.32) ( 974,838.92) (93,882,704.24) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56_ SUBTOTAL CASH IN BANK - POOLED CASH 32,086,444.17 ( 364,468.23) 31,721,975.94 WAGES PAYABLE _______________ ______________ ______________ TOTAL CASH IN BANK - POOLED CASH 32,086,444.17 ( 364,468.23) 31,721,975.94 =============== ============== ============== 222-PINEWOOD GOLF COURSE MONTH OF YTD REVENUES: MAY ACTUAL ERGC CITY Charges for Services 222-3-0000-3467 Concessions 1,859.59 2,063.52 2,063.52 - 222-3-0000-3469 Other Sales 403.93 698.81 698.81 - 222-3-0000-3476 Green Fees 12,592.03 14,285.58 14,285.58 - 222-3-0000-3477 Membership Fees 2,095.00 7,007.64 7,007.64 - 222-3-0000-3478 Golf Cart Rental 3,364.61 4,044.90 4,044.90 - 222-3-0000-3792 Cash Over 26.78 (4.92) (4.92) - TOTAL Charges for Services 20,341.94 28,095.53 28,095.53 - TOTAL REVENUE 20,341.94 28,095.53 28,095.53 - EXPENDITURES: Supplies 222-4-5300-4219 Operating Supplies 143.70 407.05 407.05 - 222-4-5300-4259 Other Merchandise For Resale 814.74 3,365.44 3,365.44 - TOTAL Supplies 958.44 3,772.49 3,772.49 - Other Services & Charges 222-4-5300-4319 Management Fee 4,000.00 4,000.00 - 4,000.00 222-4-5300-4349 Advertising/Marketing 159.00 684.00 684.00 - 222-4-5300-4389 Utilities 421.18 594.24 339.96 254.28 222-4-5300-4401 Building Maintenance - 27.85 27.85 - 222-4-5300-4404 Grounds Maintenance 1,427.70 1,427.70 543.70 884.00 222-4-5300-4409 Contractual Svcs - Wages/Taxes 7,884.54 8,474.74 8,474.74 - 222-4-5300-4437 Taxes & Licenses 225.00 225.00 225.00 - 222-4-5300-4438 Bank/Credit Card Fees 128.90 209.60 209.60 - TOTAL Other Services & Charges 14,246.32 15,643.13 10,504.85 5,138.28 TOTAL EXPENDITURES 15,204.76 19,415.62 14,277.34 5,138.28 REVENUES OVER/(UNDER) EXPENDITURES 5,137.18 8,679.91 13,818.19 (5,138.28) CITY OF ELK RIVER REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MAY 31, 2018