Loading...
INFORMATION 10-15-2018Information #1 Memorandum To: Mayor and City Council From: Jesse Dorn, Assistant Finance Director Date: October 15, 2018 Subject: September 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 September, actual revenues (excluding property taxes and transfers in) and expenditures should run 75% 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 transfers in, overall general fund revenues are 59% of budget with the second half property taxes to be collected in December.  Licenses and permits collections are in line with budget estimates at 73%.  Intergovernmental revenue collections for September consist of the police and fire state aid. The fire state aid will be remitted to the Elk River Fire Relief Association.  Charges for services are 87% of budget and are comprised mainly of plan review fees and police/fire service contracts.  Fines and forfeits collections are 66% of budget estimates, with court fine collections lagging a month. Expenditures:  Total departmental expenditures are about 68% of budget and most departments are below budget estimates.  Reflected in many departments’ budgets is the liability insurance premium for July- December. Actual$8,884$7,615$6,346$5,077$3,807$2,538$1,269Budget$9,232$8,045$6,785$5,272$4,192$3,088$1,942$947 $0$16,000$14,000$12,000$10,000$8,000$6,000$4,000$2,000$ THOUSANDS 2018 Monthly Expenditures ICE ARENA Through the end of September, expenditures of $587,070 exceed revenues of $474,699 by $112,371. With the hockey season right around the corner, overall revenues and expenditures are in line with budget estimates. PINEWOOD GOLF September financials are not yet available for Pinewood Golf Course. ATTACHMENTS  General Fund Revenue & Expense Report  Enterprise Funds – Budget to Actual  Cash Report – All Funds 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND FINANCIAL SUMMARY 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ REVENUE SUMMARY General Fund 15,229,550.00 700,044.89 9,471,904.28 62.19 5,757,645.72 TOTAL REVENUES 15,229,550.00 700,044.89 9,471,904.28 62.19 5,757,645.72 ============= ============= ============= ======= ============= EXPENDITURE SUMMARY General Government Mayor & Council 155,300.00 44,165.64 130,841.38 84.25 24,458.62 Communications 306,900.00 20,860.15 167,922.06 54.72 138,977.94 Administrative Services 511,900.00 47,261.68 346,963.97 67.78 164,936.03 Human Resources 250,550.00 14,619.18 180,793.53 72.16 69,756.47 Elections 42,250.00 806.65 20,821.85 49.28 21,428.15 Finance 586,250.00 40,449.86 452,759.35 77.23 133,490.65 Information Technology 431,300.00 29,989.93 251,322.98 58.27 179,977.02 Legal 230,000.00 18,510.14 170,265.63 74.03 59,734.37 Community Development 150,050.00 11,875.40 114,448.35 76.27 35,601.65 Planning 405,800.00 26,076.65 250,019.50 61.61 155,780.50 Building Maintenance 679,750.00 49,684.78 474,528.33 69.81 205,221.67 TOTAL General Government 3,750,050.00 304,300.06 2,560,686.93 68.28 1,189,363.07 Public Safety Police Administration 796,650.00 71,974.74 601,184.73 75.46 195,465.27 Patrol 2,721,300.00 192,960.05 1,797,611.15 66.06 923,688.85 Investigations 1,053,850.00 74,751.42 697,921.66 66.23 355,928.34 Police Support Services 711,500.00 55,919.27 491,544.27 69.09 219,955.73 Police Reserves 19,750.00 244.78 7,651.20 38.74 12,098.80 Public safety building 167,000.00 5,611.14 108,391.83 64.91 58,608.17 Fire Administration 507,200.00 33,458.44 372,520.20 73.45 134,679.80 Fire Operations 420,800.00 39,149.34 308,529.80 73.32 112,270.20 Emergency Management 27,000.00 349.38 7,859.16 29.11 19,140.84 Building Safety 678,450.00 59,509.68 478,273.41 70.50 200,176.59 Code Enforcement 98,750.00 7,329.36 67,398.69 68.25 31,351.31 Environmental 48,400.00 2,520.55 34,570.03 71.43 13,829.97 TOTAL Public Safety 7,250,650.00 543,778.15 4,973,456.13 68.59 2,277,193.87 Public Works Street Maintenance 1,355,450.00 92,665.55 782,933.29 57.76 572,516.71 Snow Removal 298,700.00 0.00 216,760.76 72.57 81,939.24 Equipment Services 210,400.00 16,849.79 139,041.19 66.08 71,358.81 Engineering 234,200.00 21,366.96 160,478.11 68.52 73,721.89 TOTAL Public Works 2,098,750.00 130,882.30 1,299,213.35 61.90 799,536.65 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND FINANCIAL SUMMARY 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Culture & Recreation Parks Department 1,118,800.00 108,357.50 802,697.26 71.75 316,102.74 Parks & Rec Admin 595,450.00 45,148.57 439,240.39 73.77 156,209.61 Recreation Programs 131,350.00 12,821.26 105,897.31 80.62 25,452.69 Sr Citizen Programs 251,500.00 16,495.23 167,485.43 66.59 84,014.57 TOTAL Culture & Recreation 2,097,100.00 182,822.56 1,515,320.39 72.26 581,779.61 Economic Development Economic Development 0.00 828.53 25,187.92 0.00 ( 25,187.92) Energy City 33,000.00 2,049.16 22,603.72 68.50 10,396.28 TOTAL Economic Development 33,000.00 2,877.69 47,791.64 144.82 ( 14,791.64) General _____________ _____________ _____________ _______ _____________ TOTAL EXPENDITURES 15,229,550.00 1,164,660.76 10,396,468.44 68.27 4,833,081.56 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 464,615.87)( 924,564.16) 924,564.16 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND 75.00% 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 5,498,167.07 52.37 4,999,632.93 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 27,799.23 0.00 ( 27,799.23) 101-3-0000-3121 Gravel Tax 150,000.00 0.00 42,925.74 28.62 107,074.26 101-3-0000-3131 Penalties/Interest 0.00 0.00 2,537.36 0.00 ( 2,537.36) TOTAL Taxes 10,647,800.00 0.00 5,571,429.40 52.32 5,076,370.60 Licenses & Permits 101-3-0000-3211 Liquor License 70,000.00 40.00 76,090.00 108.70 ( 6,090.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 1,340.00 48,125.00 74.04 16,875.00 101-3-0000-3216 Mining License 23,000.00 0.00 25,227.15 109.68 ( 2,227.15) 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 250.00 5,595.00 43.04 7,405.00 101-3-0000-3229 NPDES Permit 12,000.00 1,925.00 19,600.00 163.33 ( 7,600.00) 101-3-0000-3231 Building Permit 480,000.00 34,119.90 374,700.89 78.06 105,299.11 101-3-0000-3232 Plumbing/Heating Permit 195,000.00 7,284.71 78,327.06 40.17 116,672.94 101-3-0000-3233 Permit Surcharge 1,000.00 ( 2,174.20) 2,595.65 259.57 ( 1,595.65) 101-3-0000-3235 Animal License 5,500.00 70.00 2,970.00 54.00 2,530.00 101-3-0000-3237 Other Non-Business Lic/Permit 9,000.00 1,410.00 11,355.00 126.17 ( 2,355.00) TOTAL Licenses & Permits 877,900.00 44,265.41 644,735.75 73.44 233,164.25 Intergovernmental Rev 101-3-0000-3322 MV Credit 5,500.00 0.00 0.00 0.00 5,500.00 101-3-0000-3323 Fire State Aid 0.00 187,502.01 187,502.01 0.00 ( 187,502.01) 101-3-0000-3324 PERA Aid 14,000.00 0.00 6,992.00 49.94 7,008.00 101-3-0000-3325 Police 2% Aid 270,000.00 269,702.99 269,702.99 99.89 297.01 101-3-0000-3326 Police Training Reimb 10,000.00 0.00 30,624.13 306.24 ( 20,624.13) 101-3-0000-3329 State Crime Prevention Grant 25,000.00 0.00 39,851.51 159.41 ( 14,851.51) 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 457,205.00 541,922.64 167.00 ( 217,422.64) Charges for Services 101-3-0000-3412 Planning & Zoning Fees 32,000.00 3,037.50 22,332.50 69.79 9,667.50 101-3-0000-3413 Plan Check Fee 200,000.00 19,085.91 182,725.55 91.36 17,274.45 101-3-0000-3415 Special Assessment Search 800.00 0.00 100.00 12.50 700.00 101-3-0000-3417 Copies 2,500.00 10.32 2,596.81 103.87 ( 96.81) 101-3-0000-3418 Other General Govt Services 5,000.00 0.00 916.00 18.32 4,084.00 101-3-0000-3430 Lockout Fees 6,500.00 480.00 3,920.00 60.31 2,580.00 101-3-0000-3431 Police Services 9,000.00 30.00 7,444.00 82.71 1,556.00 101-3-0000-3432 School Liaison 130,000.00 0.00 130,084.50 100.07 ( 84.50) 101-3-0000-3434 Animal Impound Fee 4,000.00 500.00 3,575.00 89.38 425.00 101-3-0000-3436 Fire Contracts 255,000.00 0.00 274,936.00 107.82 ( 19,936.00) 101-3-0000-3437 Fire Services 2,000.00 7.85 4,290.55 214.53 ( 2,290.55) 101-3-0000-3451 Street Services 20,000.00 1,190.00 10,137.53 50.69 9,862.47 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-3-0000-3452 Engineering Services Reimb 125,000.00 21,776.27 52,088.38 41.67 72,911.62 101-3-0000-3461 Recreation Fees 75,000.00 4,449.31 55,402.03 73.87 19,597.97 101-3-0000-3462 Sr Center Activities 35,000.00 1,459.52 20,353.52 58.15 14,646.48 101-3-0000-3469 Other Sales 0.00 0.00 7,460.57 0.00 ( 7,460.57) 101-3-0000-3472 Park Use Fee 24,000.00 1,696.50 27,314.80 113.81 ( 3,314.80) 101-3-0000-3475 Building Rent 2,400.00 200.00 1,800.00 75.00 600.00 101-3-0000-3483 Sewer Inspection Fee 9,000.00 780.00 9,135.00 101.50 ( 135.00) 101-3-0000-3484 Contractor License Check 700.00 95.00 920.00 131.43 ( 220.00) TOTAL Charges for Services 937,900.00 54,798.18 817,532.74 87.17 120,367.26 Fines & Forfeits 101-3-0000-3510 Court Fines 145,000.00 12,862.37 88,765.28 61.22 56,234.72 101-3-0000-3511 Parking Fines 6,000.00 440.00 9,820.00 163.67 ( 3,820.00) 101-3-0000-3512 Ordinance Violations 0.00 75.00 575.00 0.00 ( 575.00) TOTAL Fines & Forfeits 151,000.00 13,377.37 99,160.28 65.67 51,839.72 Special Assessments _____________ _____________ _____________ _______ _____________ Other Revenue 101-3-0000-3621 Interest Income 90,000.00 0.00 91,452.15 101.61 ( 1,452.15) 101-3-0000-3625 Refunds & Reimbursements 110,000.00 718.57 3,659.44 3.33 106,340.56 101-3-0000-3626 Contributions 20,000.00 16.00 20,335.44 101.68 ( 335.44) 101-3-0000-3629 Miscellaneous Revenue 6,500.00 ( 177.88) 6,538.96 100.60 ( 38.96) TOTAL Other Revenue 226,500.00 556.69 121,985.99 53.86 104,514.01 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 56,000.00 100.00 0.00 101-3-0000-3926 Transfer-Capital Outlay Reserv 13,600.00 0.00 13,600.00 100.00 0.00 101-3-0000-3929 Transfer-NSP/RDF Reserve 45,000.00 0.00 45,000.00 100.00 0.00 101-3-0000-3930 Transfer-Development 14,000.00 0.00 14,000.00 100.00 0.00 101-3-0000-3942 Transfer-WWTS 150,000.00 0.00 150,000.00 100.00 0.00 101-3-0000-3943 Transfer-Liquor 492,000.00 0.00 492,000.00 100.00 0.00 101-3-0000-3944 Transfer-Garbage 46,750.00 0.00 46,750.00 100.00 0.00 101-3-0000-3945 Transfer-Utilities 1,165,000.00 129,842.24 775,765.80 66.59 389,234.20 101-3-0000-3946 Transfer-Stormwater 15,000.00 0.00 15,000.00 100.00 0.00 101-3-0000-3948 Transfer-EDA 36,600.00 0.00 36,600.00 100.00 0.00 101-3-0000-3949 Transfer-HRA 30,000.00 0.00 30,000.00 100.00 0.00 TOTAL Transfers In 2,063,950.00 129,842.24 1,675,137.48 81.16 388,812.52 _____________________________________________________________________________ TOTAL General Fund 15,229,550.00 700,044.89 9,471,904.28 62.19 5,757,645.72 ___________________________________________________________________________________________________________________ TOTAL REVENUE 15,229,550.00 700,044.89 9,471,904.28 62.19 5,757,645.72 ============= ============= ============= ======= ============= 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND 75.00% 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 28,874.88 75.00 9,625.12 101-4-1110-4104 PERA 1,500.00 100.01 900.09 60.01 599.91 101-4-1110-4105 FICA 1,000.00 74.92 674.25 67.43 325.75 101-4-1110-4107 Medicare 600.00 46.52 418.72 69.79 181.28 101-4-1110-4109 Workers Comp 100.00 0.00 40.50 40.50 59.50 TOTAL Personal Services 41,700.00 3,429.77 30,908.44 74.12 10,791.56 Supplies 101-4-1110-4201 Office Supplies 750.00 6.40 308.05 41.07 441.95 TOTAL Supplies 750.00 6.40 308.05 41.07 441.95 Other Services & Charges 101-4-1110-4319 Other Professional Services 10,500.00 0.00 14,659.67 139.62 ( 4,159.67) 101-4-1110-4322 Postage 50.00 0.00 26.10 52.20 23.90 101-4-1110-4331 Travel, Conferences & Schools 2,600.00 108.46 677.63 26.06 1,922.37 101-4-1110-4359 Publishing 3,700.00 0.00 693.90 18.75 3,006.10 101-4-1110-4361 Insurance 42,000.00 19,524.00 39,836.00 94.85 2,164.00 101-4-1110-4433 Dues & Subscriptions 19,550.00 18,958.00 18,958.00 96.97 592.00 101-4-1110-4440 Miscellaneous 34,450.00 2,139.01 24,773.59 71.91 9,676.41 TOTAL Other Services & Charges 112,850.00 40,729.47 99,624.89 88.28 13,225.11 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Mayor & Council 155,300.00 44,165.64 130,841.38 84.25 24,458.62 Communications ============== Personal Services 101-4-1120-4101 Regular Pay 192,700.00 11,509.42 102,540.75 53.21 90,159.25 101-4-1120-4103 Part-time Pay 18,850.00 703.25 6,327.43 33.57 12,522.57 101-4-1120-4104 PERA 16,450.00 915.94 8,165.13 49.64 8,284.87 101-4-1120-4105 FICA 13,300.00 712.58 6,650.74 50.01 6,649.26 101-4-1120-4107 Medicare 3,050.00 166.66 1,555.42 51.00 1,494.58 101-4-1120-4108 Insurance 20,950.00 3,253.50 18,399.00 87.82 2,551.00 101-4-1120-4109 Workers Comp 500.00 0.00 720.75 144.15 ( 220.75) TOTAL Personal Services 265,800.00 17,261.35 144,359.22 54.31 121,440.78 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND General Government 75.00% 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 333.60 7,433.75 59.00 5,166.25 TOTAL Supplies 12,600.00 333.60 7,433.75 59.00 5,166.25 Other Services & Charges 101-4-1120-4319 Other Professional Services 19,750.00 1,849.00 13,468.21 68.19 6,281.79 101-4-1120-4321 Telephone 850.00 157.28 638.61 75.13 211.39 101-4-1120-4331 Travel, Conferences & Schools 6,750.00 1,258.92 1,258.92 18.65 5,491.08 101-4-1120-4433 Dues & Subscriptions 1,150.00 0.00 763.35 66.38 386.65 TOTAL Other Services & Charges 28,500.00 3,265.20 16,129.09 56.59 12,370.91 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Communications 306,900.00 20,860.15 167,922.06 54.72 138,977.94 Administrative Services ======================= Personal Services 101-4-1210-4101 Regular Pay 335,350.00 26,083.86 231,760.03 69.11 103,589.97 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 3,824.80 35,346.11 70.90 14,503.89 101-4-1210-4104 PERA 28,900.00 2,243.14 20,034.15 69.32 8,865.85 101-4-1210-4105 FICA 24,000.00 1,877.04 16,854.99 70.23 7,145.01 101-4-1210-4107 Medicare 5,600.00 438.99 3,941.90 70.39 1,658.10 101-4-1210-4108 Insurance 28,250.00 1,798.00 15,548.20 55.04 12,701.80 101-4-1210-4109 Workers Comp 1,850.00 0.00 1,498.50 81.00 351.50 TOTAL Personal Services 473,800.00 36,265.83 325,001.32 68.59 148,798.68 Supplies 101-4-1210-4201 Office Supplies 7,300.00 156.02 2,283.96 31.29 5,016.04 TOTAL Supplies 7,300.00 156.02 2,283.96 31.29 5,016.04 Other Services & Charges 101-4-1210-4321 Telephone 1,950.00 112.57 836.65 42.91 1,113.35 101-4-1210-4322 Postage 800.00 0.00 653.56 81.70 146.44 101-4-1210-4331 Travel, Conferences & Schools 5,250.00 3.30 490.12 9.34 4,759.88 101-4-1210-4334 Car Allowance 4,800.00 400.00 3,600.00 75.00 1,200.00 101-4-1210-4361 Insurance 100.00 32.00 58.00 58.00 42.00 101-4-1210-4404 Equip Repair/Maint Services 15,750.00 10,280.00 12,512.88 79.45 3,237.12 101-4-1210-4433 Dues & Subscriptions 2,150.00 11.96 1,527.48 71.05 622.52 TOTAL Other Services & Charges 30,800.00 10,839.83 19,678.69 63.89 11,121.31 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND General Government 75.00% 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 47,261.68 346,963.97 67.78 164,936.03 Human Resources =============== Personal Services 101-4-1220-4101 Regular Pay 127,400.00 11,135.03 93,993.59 73.78 33,406.41 101-4-1220-4102 Overtime Pay 0.00 0.00 113.98 0.00 ( 113.98) 101-4-1220-4104 PERA 9,550.00 835.12 7,058.03 73.91 2,491.97 101-4-1220-4105 FICA 7,900.00 685.91 5,725.88 72.48 2,174.12 101-4-1220-4107 Medicare 1,850.00 160.41 1,339.11 72.38 510.89 101-4-1220-4108 Insurance 17,250.00 1,727.00 12,315.00 71.39 4,935.00 101-4-1220-4109 Workers Comp 600.00 0.00 480.75 80.13 119.25 TOTAL Personal Services 164,550.00 14,543.47 121,026.34 73.55 43,523.66 Supplies 101-4-1220-4201 Office Supplies 3,500.00 75.71 3,402.07 97.20 97.93 TOTAL Supplies 3,500.00 75.71 3,402.07 97.20 97.93 Other Services & Charges 101-4-1220-4319 Other Professional Services 3,750.00 0.00 654.90 17.46 3,095.10 101-4-1220-4322 Postage 400.00 0.00 189.91 47.48 210.09 101-4-1220-4331 Travel, Conferences & Schools 4,200.00 0.00 1,176.26 28.01 3,023.74 101-4-1220-4404 Equip Repair/Maint 73,300.00 0.00 53,470.00 72.95 19,830.00 101-4-1220-4433 Dues & Subscriptions 850.00 0.00 874.05 102.83 ( 24.05) TOTAL Other Services & Charges 82,500.00 0.00 56,365.12 68.32 26,134.88 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Human Resources 250,550.00 14,619.18 180,793.53 72.16 69,756.47 Elections ========= Personal Services 101-4-1230-4101 Regular Pay 0.00 148.08 148.08 0.00 ( 148.08) 101-4-1230-4103 Part-time Pay 30,000.00 0.00 12,613.88 42.05 17,386.12 101-4-1230-4104 PERA 0.00 7.30 7.30 0.00 ( 7.30) 101-4-1230-4105 FICA 0.00 6.00 6.00 0.00 ( 6.00) 101-4-1230-4107 Medicare 0.00 1.40 1.40 0.00 ( 1.40) 101-4-1230-4108 Insurance 0.00 0.15 0.15 0.00 ( 0.15) TOTAL Personal Services 30,000.00 162.93 12,776.81 42.59 17,223.19 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND General Government 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1230-4219 Operating Supplies 3,600.00 623.80 1,299.04 36.08 2,300.96 TOTAL Supplies 3,600.00 623.80 1,299.04 36.08 2,300.96 Other Services & Charges 101-4-1230-4322 Postage 200.00 0.00 5.42 2.71 194.58 101-4-1230-4331 Travel, Conferences & Schools 150.00 19.92 64.58 43.05 85.42 101-4-1230-4359 Publishing 700.00 0.00 376.00 53.71 324.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 19.92 6,746.00 77.99 1,904.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Elections 42,250.00 806.65 20,821.85 49.28 21,428.15 Finance ======= Personal Services 101-4-1310-4101 Regular Pay 314,700.00 25,548.58 227,840.40 72.40 86,859.60 101-4-1310-4103 Part-time Pay 55,850.00 4,112.63 38,784.92 69.44 17,065.08 101-4-1310-4104 PERA 27,800.00 2,224.58 19,996.92 71.93 7,803.08 101-4-1310-4105 FICA 23,000.00 1,761.45 15,583.47 67.75 7,416.53 101-4-1310-4107 Medicare 5,400.00 411.94 3,644.51 67.49 1,755.49 101-4-1310-4108 Insurance 40,100.00 4,837.50 43,537.50 108.57 ( 3,437.50) 101-4-1310-4109 Workers Comp 1,700.00 0.00 1,398.00 82.24 302.00 TOTAL Personal Services 468,550.00 38,896.68 350,785.72 74.87 117,764.28 Supplies 101-4-1310-4201 Office Supplies 7,000.00 64.01 3,434.53 49.06 3,565.47 TOTAL Supplies 7,000.00 64.01 3,434.53 49.06 3,565.47 Other Services & Charges 101-4-1310-4301 Audit Fees 19,250.00 0.00 15,450.00 80.26 3,800.00 101-4-1310-4319 Other Professional Services 54,000.00 0.00 54,070.00 100.13 ( 70.00) 101-4-1310-4321 Telephone 900.00 39.15 410.33 45.59 489.67 101-4-1310-4322 Postage 2,900.00 0.00 1,716.92 59.20 1,183.08 101-4-1310-4331 Travel, Conferences & Schools 4,300.00 210.00 1,041.73 24.23 3,258.27 101-4-1310-4359 Publishing 450.00 0.00 152.00 33.78 298.00 101-4-1310-4404 Equip Repair/Maint Services 18,550.00 0.00 17,072.22 92.03 1,477.78 101-4-1310-4433 Dues & Subscriptions 1,850.00 0.00 1,210.00 65.41 640.00 101-4-1310-4438 Credit Card Fees 7,000.00 1,152.12 6,551.10 93.59 448.90 101-4-1310-4440 Miscellaneous 1,500.00 87.90 864.80 57.65 635.20 TOTAL Other Services & Charges 110,700.00 1,489.17 98,539.10 89.01 12,160.90 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND General Government 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Finance 586,250.00 40,449.86 452,759.35 77.23 133,490.65 Information Technology ====================== Personal Services 101-4-1350-4101 Regular Pay 202,800.00 16,328.87 129,971.77 64.09 72,828.23 101-4-1350-4102 Overtime Pay 0.00 0.00 26.18 0.00 ( 26.18) 101-4-1350-4104 PERA 15,200.00 1,224.66 9,749.85 64.14 5,450.15 101-4-1350-4105 FICA 12,600.00 994.69 7,853.87 62.33 4,746.13 101-4-1350-4107 Medicare 2,950.00 232.64 1,836.80 62.26 1,113.20 101-4-1350-4108 Insurance 33,250.00 2,029.26 17,349.84 52.18 15,900.16 101-4-1350-4109 Workers Comp 950.00 0.00 765.00 80.53 185.00 TOTAL Personal Services 267,750.00 20,810.12 167,553.31 62.58 100,196.69 Supplies 101-4-1350-4219 Operating Supplies 19,300.00 1,795.71 9,218.01 47.76 10,081.99 TOTAL Supplies 19,300.00 1,795.71 9,218.01 47.76 10,081.99 Other Services & Charges 101-4-1350-4319 Other Professional Services 11,000.00 0.00 3,517.58 31.98 7,482.42 101-4-1350-4321 Telephone 2,800.00 283.97 5,601.44 200.05 ( 2,801.44) 101-4-1350-4331 Travel, Conferences & Schools 12,750.00 0.00 4,662.91 36.57 8,087.09 101-4-1350-4404 Equip Repair/Maint Services 117,700.00 7,100.13 60,769.73 51.63 56,930.27 TOTAL Other Services & Charges 144,250.00 7,384.10 74,551.66 51.68 69,698.34 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Information Technology 431,300.00 29,989.93 251,322.98 58.27 179,977.02 Legal ===== Other Services & Charges 101-4-1400-4304 Legal Fees 230,000.00 18,510.14 170,265.63 74.03 59,734.37 TOTAL Other Services & Charges 230,000.00 18,510.14 170,265.63 74.03 59,734.37 ___________________________________________________________________________________________________________________ TOTAL Legal 230,000.00 18,510.14 170,265.63 74.03 59,734.37 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND General Government 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Community Development ===================== Personal Services 101-4-1500-4101 Regular Pay 118,350.00 9,246.16 84,641.85 71.52 33,708.15 101-4-1500-4104 PERA 8,900.00 693.46 6,348.13 71.33 2,551.87 101-4-1500-4105 FICA 7,350.00 561.24 5,112.33 69.56 2,237.67 101-4-1500-4107 Medicare 1,700.00 131.26 1,195.63 70.33 504.37 101-4-1500-4108 Insurance 8,650.00 1,132.50 13,111.50 151.58 ( 4,461.50) 101-4-1500-4109 Workers Comp 550.00 0.00 446.25 81.14 103.75 TOTAL Personal Services 145,500.00 11,764.62 110,855.69 76.19 34,644.31 Supplies 101-4-1500-4201 Office Supplies 600.00 72.81 209.56 34.93 390.44 TOTAL Supplies 600.00 72.81 209.56 34.93 390.44 Other Services & Charges 101-4-1500-4321 Telephone 800.00 37.97 524.15 65.52 275.85 101-4-1500-4331 Travel, Conferences & Schools 2,600.00 0.00 2,449.95 94.23 150.05 101-4-1500-4433 Dues & Subscriptions 550.00 0.00 409.00 74.36 141.00 TOTAL Other Services & Charges 3,950.00 37.97 3,383.10 85.65 566.90 ___________________________________________________________________________________________________________________ TOTAL Community Development 150,050.00 11,875.40 114,448.35 76.27 35,601.65 Planning ======== Personal Services 101-4-1510-4101 Regular Pay 290,500.00 18,101.39 180,109.44 62.00 110,390.56 101-4-1510-4103 Part-time Pay 9,350.00 1,819.00 7,370.00 78.82 1,980.00 101-4-1510-4104 PERA 21,800.00 1,357.60 13,290.44 60.97 8,509.56 101-4-1510-4105 FICA 18,600.00 1,208.60 11,191.84 60.17 7,408.16 101-4-1510-4107 Medicare 4,350.00 282.64 2,617.44 60.17 1,732.56 101-4-1510-4108 Insurance 37,250.00 2,448.50 23,820.00 63.95 13,430.00 101-4-1510-4109 Workers Comp 1,100.00 0.00 888.75 80.80 211.25 TOTAL Personal Services 382,950.00 25,217.73 239,287.91 62.49 143,662.09 Supplies 101-4-1510-4201 Office Supplies 2,500.00 206.82 592.21 23.69 1,907.79 101-4-1510-4212 Fuels & Lubes 300.00 0.00 16.95 5.65 283.05 101-4-1510-4219 Operating Supplies 2,000.00 64.13 1,983.90 99.20 16.10 TOTAL Supplies 4,800.00 270.95 2,593.06 54.02 2,206.94 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND General Government 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-1510-4321 Telephone 350.00 0.00 180.00 51.43 170.00 101-4-1510-4322 Postage 1,300.00 0.00 679.14 52.24 620.86 101-4-1510-4331 Travel, Conferences & Schools 3,300.00 35.97 576.39 17.47 2,723.61 101-4-1510-4359 Publishing 10,000.00 520.00 4,867.00 48.67 5,133.00 101-4-1510-4361 Insurance 100.00 32.00 58.00 58.00 42.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 331.00 66.20 169.00 TOTAL Other Services & Charges 18,050.00 587.97 8,138.53 45.09 9,911.47 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Planning 405,800.00 26,076.65 250,019.50 61.61 155,780.50 Building Maintenance ==================== Personal Services 101-4-1600-4101 Regular Pay 364,600.00 29,547.43 264,396.69 72.52 100,203.31 101-4-1600-4102 Overtime Pay 3,500.00 1,789.71 3,198.32 91.38 301.68 101-4-1600-4103 Part-time Pay 3,650.00 644.00 3,080.00 84.38 570.00 101-4-1600-4104 PERA 27,650.00 2,350.29 20,069.60 72.58 7,580.40 101-4-1600-4105 FICA 23,050.00 1,985.10 16,888.74 73.27 6,161.26 101-4-1600-4107 Medicare 5,400.00 464.26 3,949.78 73.14 1,450.22 101-4-1600-4108 Insurance 54,150.00 4,609.50 39,430.88 72.82 14,719.12 101-4-1600-4109 Workers Comp 12,250.00 0.00 10,038.75 81.95 2,211.25 TOTAL Personal Services 494,250.00 41,390.29 361,052.76 73.05 133,197.24 Supplies 101-4-1600-4212 Fuels & Lubes 3,000.00 211.65 2,153.37 71.78 846.63 101-4-1600-4217 Uniform Allowance 2,200.00 0.00 1,920.27 87.29 279.73 101-4-1600-4219 Operating Supplies 33,500.00 3,171.83 21,766.62 64.97 11,733.38 TOTAL Supplies 38,700.00 3,383.48 25,840.26 66.77 12,859.74 Other Services & Charges 101-4-1600-4321 Telephone 12,850.00 269.34 9,682.98 75.35 3,167.02 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 0.00 428.00 21.40 1,572.00 101-4-1600-4361 Insurance 5,500.00 2,412.00 4,868.00 88.51 632.00 101-4-1600-4389 Utilities 75,750.00 762.28 50,842.33 67.12 24,907.67 101-4-1600-4401 Bldg Repair/Maint Services 40,800.00 1,142.39 16,098.28 39.46 24,701.72 101-4-1600-4404 Equip Repair/Maint Services 6,000.00 0.00 2,790.72 46.51 3,209.28 101-4-1600-4460 Equip Replacement Charge 3,900.00 325.00 2,925.00 75.00 975.00 TOTAL Other Services & Charges 146,800.00 4,911.01 87,635.31 59.70 59,164.69 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND General Government 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Maintenance 679,750.00 49,684.78 474,528.33 69.81 205,221.67 Contingency =========== Personal Service s _____________ _____________ _____________ _______ _____________ Other Services & Charge s _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL General Government 3,750,050.00 304,300.06 2,560,686.93 68.28 1,189,363.07 Police Administration ===================== Personal Services 101-4-2110-4101 Regular Pay 382,900.00 29,576.59 268,789.78 70.20 114,110.22 101-4-2110-4102 Overtime Pay 2,500.00 0.00 298.39 11.94 2,201.61 101-4-2110-4104 PERA 57,550.00 4,418.08 40,272.76 69.98 17,277.24 101-4-2110-4105 FICA 3,500.00 284.65 2,528.38 72.24 971.62 101-4-2110-4107 Medicare 5,600.00 419.58 3,820.51 68.22 1,779.49 101-4-2110-4108 Insurance 28,250.00 2,826.00 25,434.00 90.03 2,816.00 101-4-2110-4109 Workers Comp 86,600.00 0.00 74,857.50 86.44 11,742.50 TOTAL Personal Services 566,900.00 37,524.90 416,001.32 73.38 150,898.68 Supplies 101-4-2110-4201 Office Supplies 11,000.00 930.58 3,333.58 30.31 7,666.42 101-4-2110-4217 Uniform Allowance 3,050.00 441.90 1,705.13 55.91 1,344.87 101-4-2110-4219 Operating Supplies 25,500.00 1,689.80 13,385.35 52.49 12,114.65 TOTAL Supplies 39,550.00 3,062.28 18,424.06 46.58 21,125.94 Other Services & Charges 101-4-2110-4319 Other Professional Services 7,900.00 3,249.00 17,524.23 221.83 ( 9,624.23) 101-4-2110-4321 Telephone 34,600.00 2,701.03 21,895.60 63.28 12,704.40 101-4-2110-4322 Postage 2,400.00 11.53 1,142.23 47.59 1,257.77 101-4-2110-4331 Travel, Conferences & Schools 17,200.00 299.00 5,130.35 29.83 12,069.65 101-4-2110-4359 Publishing 500.00 0.00 234.00 46.80 266.00 101-4-2110-4361 Insurance 40,500.00 23,844.00 43,217.00 106.71 ( 2,717.00) 101-4-2110-4404 Equip Repair/Maint Services 71,800.00 0.00 63,063.30 87.83 8,736.70 101-4-2110-4433 Dues & Subscriptions 15,100.00 1,283.00 14,431.64 95.57 668.36 101-4-2110-4437 Taxes & Licenses 200.00 0.00 121.00 60.50 79.00 TOTAL Other Services & Charges 190,200.00 31,387.56 166,759.35 87.68 23,440.65 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND Public Safety 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Administration 796,650.00 71,974.74 601,184.73 75.46 195,465.27 Patrol ====== Personal Services 101-4-2120-4101 Regular Pay 1,782,350.00 130,990.02 1,176,641.62 66.02 605,708.38 101-4-2120-4102 Overtime Pay 100,000.00 1,122.34 41,408.77 41.41 58,591.23 101-4-2120-4104 PERA 304,900.00 20,906.06 196,511.78 64.45 108,388.22 101-4-2120-4107 Medicare 27,250.00 1,895.75 17,500.39 64.22 9,749.61 101-4-2120-4108 Insurance 173,100.00 14,359.50 128,187.00 74.05 44,913.00 TOTAL Personal Services 2,387,600.00 169,273.67 1,560,249.56 65.35 827,350.44 Supplies 101-4-2120-4212 Fuels & Lubes 95,000.00 6,781.47 63,279.13 66.61 31,720.87 101-4-2120-4217 Uniform Allowance 21,000.00 2,229.88 10,578.03 50.37 10,421.97 101-4-2120-4219 Operating Supplies 79,700.00 2,984.31 35,927.05 45.08 43,772.95 101-4-2120-4221 Equipment Parts 23,300.00 3,884.40 11,999.64 51.50 11,300.36 TOTAL Supplies 219,000.00 15,880.06 121,783.85 55.61 97,216.15 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 28,250.00 1,101.00 18,620.37 65.91 9,629.63 101-4-2120-4404 Equip Repair/Maint Services 20,800.00 2,538.65 14,532.31 69.87 6,267.69 101-4-2120-4433 Dues & Subscriptions 650.00 0.00 210.00 32.31 440.00 101-4-2120-4440 Misc. - Grant Distribution 0.00 0.00 31,815.03 0.00 ( 31,815.03) 101-4-2120-4460 Equip Replacement Charge 50,000.00 4,166.67 37,500.03 75.00 12,499.97 TOTAL Other Services & Charges 99,700.00 7,806.32 102,677.74 102.99 ( 2,977.74) 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 192,960.05 1,797,611.15 66.06 923,688.85 Investigations ============== Personal Services 101-4-2130-4101 Regular Pay 721,150.00 51,461.76 496,647.70 68.87 224,502.30 101-4-2130-4102 Overtime Pay 55,000.00 2,277.66 19,863.51 36.12 35,136.49 101-4-2130-4104 PERA 125,750.00 8,705.79 80,051.64 63.66 45,698.36 101-4-2130-4107 Medicare 11,250.00 743.01 7,058.87 62.75 4,191.13 101-4-2130-4108 Insurance 81,850.00 8,056.24 62,711.91 76.62 19,138.09 TOTAL Personal Services 995,000.00 71,244.46 666,333.63 66.97 328,666.37 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND Public Safety 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-2130-4217 Uniform Allowance 7,100.00 715.80 5,193.37 73.15 1,906.63 101-4-2130-4219 Operating Supplies 9,800.00 1,394.50 2,872.09 29.31 6,927.91 TOTAL Supplies 16,900.00 2,110.30 8,065.46 47.72 8,834.54 Other Services & Charges 101-4-2130-4319 Other Professional Services 7,500.00 75.00 125.00 1.67 7,375.00 101-4-2130-4331 Travel, Conferences & Schools 15,250.00 29.99 11,300.50 74.10 3,949.50 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 11,625.03 75.00 3,874.97 TOTAL Other Services & Charges 41,950.00 1,396.66 23,522.57 56.07 18,427.43 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Investigations 1,053,850.00 74,751.42 697,921.66 66.23 355,928.34 Police Support Services ======================= Personal Services 101-4-2150-4101 Regular Pay 459,300.00 35,764.41 319,575.65 69.58 139,724.35 101-4-2150-4102 Overtime Pay 7,500.00 950.11 6,985.75 93.14 514.25 101-4-2150-4103 Part-time Pay 43,500.00 1,776.96 26,496.34 60.91 17,003.66 101-4-2150-4104 PERA 46,550.00 3,521.53 32,122.40 69.01 14,427.60 101-4-2150-4105 FICA 25,750.00 1,903.73 17,339.81 67.34 8,410.19 101-4-2150-4107 Medicare 7,400.00 544.70 4,981.03 67.31 2,418.97 101-4-2150-4108 Insurance 77,850.00 7,403.85 62,940.60 80.85 14,909.40 TOTAL Personal Services 667,850.00 51,865.29 470,441.58 70.44 197,408.42 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 580.96 2,696.81 45.71 3,203.19 101-4-2150-4219 Operating Supplies 13,400.00 565.67 5,733.59 42.79 7,666.41 TOTAL Supplies 20,300.00 1,146.63 9,186.94 45.26 11,113.06 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 6,400.00 315.00 1,626.81 25.42 4,773.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 2,092.35 5,488.94 68.61 2,511.06 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 4,500.00 75.00 1,500.00 TOTAL Other Services & Charges 23,350.00 2,907.35 11,915.75 51.03 11,434.25 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND Public Safety 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Support Services 711,500.00 55,919.27 491,544.27 69.09 219,955.73 Police Reserves =============== Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 162.54 1,362.24 24.77 4,137.76 101-4-2160-4105 FICA 350.00 10.08 84.48 24.14 265.52 101-4-2160-4107 Medicare 100.00 2.36 19.76 19.76 80.24 TOTAL Personal Services 5,950.00 174.98 1,466.48 24.65 4,483.52 Supplies 101-4-2160-4217 Uniform Allowance 5,500.00 69.80 2,787.20 50.68 2,712.80 101-4-2160-4219 Operating Supplies 3,000.00 0.00 2,512.52 83.75 487.48 TOTAL Supplies 8,500.00 69.80 5,299.72 62.35 3,200.28 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 885.00 27.66 2,315.00 TOTAL Other Services & Charges 5,300.00 0.00 885.00 16.70 4,415.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Reserves 19,750.00 244.78 7,651.20 38.74 12,098.80 Public safety building ====================== Personal Service s _____________ _____________ _____________ _______ _____________ Supplies 101-4-2190-4219 Operating Supplies 23,600.00 1,287.51 20,731.61 87.85 2,868.39 TOTAL Supplies 23,600.00 1,287.51 20,731.61 87.85 2,868.39 Other Services & Charges 101-4-2190-4361 Insurance 5,200.00 2,238.00 4,628.00 89.00 572.00 101-4-2190-4389 Utilities 98,000.00 381.20 65,336.54 66.67 32,663.46 101-4-2190-4401 Bldg Repair/Maint Services 40,200.00 1,704.43 17,695.68 44.02 22,504.32 TOTAL Other Services & Charges 143,400.00 4,323.63 87,660.22 61.13 55,739.78 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND Public Safety 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Public safety building 167,000.00 5,611.14 108,391.83 64.91 58,608.17 Fire Administration =================== Personal Services 101-4-2310-4101 Regular Pay 259,200.00 18,773.34 185,885.51 71.72 73,314.49 101-4-2310-4102 Overtime Pay 0.00 0.00 ( 1.94) 0.00 1.94 101-4-2310-4104 PERA 37,900.00 1,674.22 22,458.93 59.26 15,441.07 101-4-2310-4105 FICA 2,900.00 263.43 2,250.69 77.61 649.31 101-4-2310-4106 Other Retirement Contributions 30,000.00 0.00 31,000.00 103.33 ( 1,000.00) 101-4-2310-4107 Medicare 3,750.00 268.18 2,644.12 70.51 1,105.88 101-4-2310-4108 Insurance 30,050.00 1,974.49 21,959.41 73.08 8,090.59 101-4-2310-4109 Workers Comp 11,850.00 0.00 9,750.75 82.28 2,099.25 TOTAL Personal Services 375,650.00 22,953.66 275,947.47 73.46 99,702.53 Supplies 101-4-2310-4201 Office Supplies 1,950.00 0.00 87.18 4.47 1,862.82 101-4-2310-4212 Fuels & Lubes 4,500.00 140.96 2,473.31 54.96 2,026.69 101-4-2310-4217 Uniform Allowance 1,500.00 0.00 663.02 44.20 836.98 101-4-2310-4219 Operating Supplies 1,000.00 207.98 2,412.79 241.28 ( 1,412.79) 101-4-2310-4221 Equipment Parts 500.00 0.00 47.44 9.49 452.56 TOTAL Supplies 9,450.00 348.94 5,683.74 60.15 3,766.26 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 79.93 1,831.97 59.10 1,268.03 101-4-2310-4322 Postage 650.00 0.00 642.29 98.81 7.71 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 34.00 74.00 9.87 676.00 101-4-2310-4361 Insurance 8,300.00 3,336.00 7,142.00 86.05 1,158.00 101-4-2310-4389 Utilities 16,250.00 207.39 14,984.64 92.21 1,265.36 101-4-2310-4401 Bldg Repair/Maint Services 10,000.00 1,081.85 9,960.83 99.61 39.17 101-4-2310-4404 Equip Repair/Maint Services 3,450.00 0.00 3,063.26 88.79 386.74 101-4-2310-4433 Dues & Subscriptions 2,100.00 0.00 2,303.00 109.67 ( 203.00) 101-4-2310-4460 Equip Replacement Charge 65,000.00 5,416.67 48,750.03 75.00 16,249.97 TOTAL Other Services & Charges 122,100.00 10,155.84 90,888.99 74.44 31,211.01 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Administration 507,200.00 33,458.44 372,520.20 73.45 134,679.80 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND Public Safety 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Fire Operations =============== Personal Services 101-4-2320-4103 Part-time Pay 188,700.00 18,761.54 140,704.96 74.57 47,995.04 101-4-2320-4105 FICA 11,700.00 1,158.83 8,648.08 73.92 3,051.92 101-4-2320-4107 Medicare 2,750.00 270.91 2,031.31 73.87 718.69 101-4-2320-4109 Workers Comp 38,750.00 0.00 32,559.75 84.03 6,190.25 TOTAL Personal Services 241,900.00 20,191.28 183,944.10 76.04 57,955.90 Supplies 101-4-2320-4201 Office Supplies 300.00 0.00 69.93 23.31 230.07 101-4-2320-4212 Fuels & Lubes 7,800.00 685.33 5,961.72 76.43 1,838.28 101-4-2320-4217 Uniform Allowance 9,000.00 1,525.69 6,886.04 76.51 2,113.96 101-4-2320-4219 Operating Supplies 85,150.00 8,496.21 63,637.45 74.74 21,512.55 101-4-2320-4221 Equipment Parts 10,000.00 2,306.54 4,084.81 40.85 5,915.19 TOTAL Supplies 112,250.00 13,013.77 80,639.95 71.84 31,610.05 Other Services & Charges 101-4-2320-4321 Telephone 4,400.00 454.48 3,943.62 89.63 456.38 101-4-2320-4331 Travel, Conferences & Schools 20,750.00 1,564.23 9,710.11 46.80 11,039.89 101-4-2320-4404 Equip Repair/Maint Services 35,200.00 3,925.58 25,575.86 72.66 9,624.14 101-4-2320-4409 Contractual Services 6,300.00 0.00 4,716.16 74.86 1,583.84 TOTAL Other Services & Charges 66,650.00 5,944.29 43,945.75 65.94 22,704.25 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Operations 420,800.00 39,149.34 308,529.80 73.32 112,270.20 Emergency Management ==================== Personal Service s _____________ _____________ _____________ _______ _____________ Supplies 101-4-2330-4219 Operating Supplies 7,500.00 0.00 3,658.40 48.78 3,841.60 TOTAL Supplies 7,500.00 0.00 3,658.40 48.78 3,841.60 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 349.38 3,555.88 84.66 644.12 101-4-2330-4404 Equip Repair/Maint Services 6,950.00 0.00 644.88 9.28 6,305.12 101-4-2330-4433 Dues & Subscriptions 250.00 0.00 0.00 0.00 250.00 TOTAL Other Services & Charges 19,500.00 349.38 4,200.76 21.54 15,299.24 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND Public Safety 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Emergency Management 27,000.00 349.38 7,859.16 29.11 19,140.84 Building Safety =============== Personal Services 101-4-2410-4101 Regular Pay 477,300.00 37,784.19 331,592.24 69.47 145,707.76 101-4-2410-4102 Overtime Pay 0.00 40.86 40.86 0.00 ( 40.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,380.72 29,899.48 70.10 12,750.52 101-4-2410-4105 FICA 24,700.00 1,834.51 16,430.79 66.52 8,269.21 101-4-2410-4107 Medicare 6,900.00 518.04 4,639.10 67.23 2,260.90 101-4-2410-4108 Insurance 86,900.00 7,291.26 62,193.28 71.57 24,706.72 101-4-2410-4109 Workers Comp 1,800.00 0.00 1,456.50 80.92 343.50 TOTAL Personal Services 640,250.00 50,849.58 450,733.26 70.40 189,516.74 Supplies 101-4-2410-4201 Office Supplies 4,200.00 76.82 2,872.51 68.39 1,327.49 101-4-2410-4212 Fuels & Lubes 7,200.00 592.32 5,566.96 77.32 1,633.04 101-4-2410-4217 Uniform Allowance 1,750.00 810.05 956.80 54.67 793.20 101-4-2410-4219 Operating Supplies 7,250.00 4,611.07 5,337.28 73.62 1,912.72 TOTAL Supplies 20,400.00 6,090.26 14,733.55 72.22 5,666.45 Other Services & Charges 101-4-2410-4321 Telephone 4,600.00 326.71 2,788.88 60.63 1,811.12 101-4-2410-4322 Postage 350.00 70.63 124.32 35.52 225.68 101-4-2410-4331 Travel, Conferences & Schools 4,150.00 0.00 2,267.44 54.64 1,882.56 101-4-2410-4361 Insurance 600.00 402.00 620.00 103.33 ( 20.00) 101-4-2410-4404 Equip Repair/Maint Services 3,500.00 0.00 2,785.46 79.58 714.54 101-4-2410-4433 Dues & Subscriptions 1,600.00 1,520.50 1,970.50 123.16 ( 370.50) 101-4-2410-4460 Equip Replacement Charge 3,000.00 250.00 2,250.00 75.00 750.00 TOTAL Other Services & Charges 17,800.00 2,569.84 12,806.60 71.95 4,993.40 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Safety 678,450.00 59,509.68 478,273.41 70.50 200,176.59 Code Enforcement ================ 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND Public Safety 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Services 101-4-2420-4101 Regular Pay 73,850.00 5,681.60 52,537.04 71.14 21,312.96 101-4-2420-4102 Overtime Pay 0.00 0.00 26.63 0.00 ( 26.63) 101-4-2420-4104 PERA 5,550.00 426.12 3,942.28 71.03 1,607.72 101-4-2420-4105 FICA 4,600.00 365.04 3,372.83 73.32 1,227.17 101-4-2420-4107 Medicare 1,100.00 85.37 788.80 71.71 311.20 101-4-2420-4108 Insurance 3,650.00 304.50 2,740.50 75.08 909.50 101-4-2420-4109 Workers Comp 250.00 0.00 212.25 84.90 37.75 TOTAL Personal Services 89,000.00 6,862.63 63,620.33 71.48 25,379.67 Supplies 101-4-2420-4212 Fuels & Lubes 1,750.00 68.60 891.75 50.96 858.25 101-4-2420-4217 Uniform Allowance 350.00 122.00 609.97 174.28 ( 259.97) 101-4-2420-4219 Operating Supplies 3,250.00 87.86 231.81 7.13 3,018.19 TOTAL Supplies 5,350.00 278.46 1,733.53 32.40 3,616.47 Other Services & Charges 101-4-2420-4321 Telephone 850.00 29.27 200.71 23.61 649.29 101-4-2420-4322 Postage 1,750.00 0.00 382.12 21.84 1,367.88 101-4-2420-4331 Travel, Conferences & Schools 800.00 0.00 663.00 82.88 137.00 101-4-2420-4361 Insurance 100.00 84.00 124.00 124.00 ( 24.00) 101-4-2420-4460 Equip Replacement Charge 900.00 75.00 675.00 75.00 225.00 TOTAL Other Services & Charges 4,400.00 188.27 2,044.83 46.47 2,355.17 ___________________________________________________________________________________________________________________ TOTAL Code Enforcement 98,750.00 7,329.36 67,398.69 68.25 31,351.31 Environmental ============= Personal Services 101-4-2440-4101 Regular Pay 18,100.00 1,535.92 13,129.94 72.54 4,970.06 101-4-2440-4104 PERA 1,350.00 115.20 989.82 73.32 360.18 101-4-2440-4105 FICA 1,100.00 95.38 819.59 74.51 280.41 101-4-2440-4107 Medicare 250.00 22.30 191.70 76.68 58.30 101-4-2440-4108 Insurance 2,600.00 178.35 1,605.17 61.74 994.83 101-4-2440-4109 Workers Comp 250.00 0.00 173.25 69.30 76.75 TOTAL Personal Services 23,650.00 1,947.15 16,909.47 71.50 6,740.53 Supplies 101-4-2440-4201 Office Supplies 300.00 6.40 48.72 16.24 251.28 101-4-2440-4212 Fuels & Lubes 200.00 0.00 74.32 37.16 125.68 101-4-2440-4219 Operating Supplies 5,350.00 0.00 26.44 0.49 5,323.56 TOTAL Supplies 5,850.00 6.40 149.48 2.56 5,700.52 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND Public Safety 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-2440-4321 Telephone 350.00 0.00 180.00 51.43 170.00 101-4-2440-4331 Travel, Conferences & Schools 1,400.00 0.00 380.08 27.15 1,019.92 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 567.00 16,951.00 105.94 ( 951.00) 101-4-2440-4433 Dues & Subscriptions 150.00 0.00 0.00 0.00 150.00 TOTAL Other Services & Charges 18,900.00 567.00 17,511.08 92.65 1,388.92 ___________________________________________________________________________________________________________________ TOTAL Environmental 48,400.00 2,520.55 34,570.03 71.43 13,829.97 ___________________________________________________________________________________________________________________ TOTAL Public Safety 7,250,650.00 543,778.15 4,973,456.13 68.59 2,277,193.87 Street Maintenance ================== Personal Services 101-4-3120-4101 Regular Pay 518,000.00 37,494.40 278,779.50 53.82 239,220.50 101-4-3120-4102 Overtime Pay 4,000.00 11.80 1,670.43 41.76 2,329.57 101-4-3120-4103 Part-time Pay 84,650.00 4,590.48 50,551.60 59.72 34,098.40 101-4-3120-4104 PERA 43,800.00 3,157.24 24,036.67 54.88 19,763.33 101-4-3120-4105 FICA 37,650.00 2,544.31 20,263.62 53.82 17,386.38 101-4-3120-4107 Medicare 8,800.00 595.05 4,743.88 53.91 4,056.12 101-4-3120-4108 Insurance 81,450.00 6,322.00 42,973.73 52.76 38,476.27 101-4-3120-4109 Workers Comp 33,800.00 0.00 26,373.75 78.03 7,426.25 TOTAL Personal Services 812,150.00 54,715.28 449,393.18 55.33 362,756.82 Supplies 101-4-3120-4201 Office Supplies 4,500.00 249.18 531.92 11.82 3,968.08 101-4-3120-4212 Fuels & Lubes 61,200.00 ( 3,628.00) 39,952.55 65.28 21,247.45 101-4-3120-4217 Uniform Allowance 6,600.00 0.00 1,421.16 21.53 5,178.84 101-4-3120-4219 Operating Supplies 55,300.00 7,771.80 45,295.03 81.91 10,004.97 101-4-3120-4221 Equipment Parts 52,000.00 5,324.90 35,601.09 68.46 16,398.91 101-4-3120-4226 Street Signs 31,000.00 668.92 7,646.92 24.67 23,353.08 TOTAL Supplies 210,600.00 10,386.80 130,448.67 61.94 80,151.33 Other Services & Charges 101-4-3120-4319 Other Professional Services 300.00 0.00 123.00 41.00 177.00 101-4-3120-4321 Telephone 7,550.00 328.71 4,163.92 55.15 3,386.08 101-4-3120-4322 Postage 100.00 78.70 118.52 118.52 ( 18.52) 101-4-3120-4331 Travel, Conferences & Schools 5,100.00 0.00 3,583.59 70.27 1,516.41 101-4-3120-4359 Publishing 200.00 41.00 88.00 44.00 112.00 101-4-3120-4361 Insurance 15,000.00 6,980.00 14,226.00 94.84 774.00 101-4-3120-4389 Utilities 92,800.00 7,561.35 50,960.95 54.91 41,839.05 101-4-3120-4401 Bldg Repair/Maint Services 23,000.00 3,298.71 16,383.67 71.23 6,616.33 101-4-3120-4404 Equip Repair/Maint Services 9,000.00 0.00 13,597.89 151.09 ( 4,597.89) 101-4-3120-4409 Contractual Services 65,500.00 0.00 14,477.90 22.10 51,022.10 101-4-3120-4415 Equipment Rental 2,000.00 0.00 729.00 36.45 1,271.00 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND Public Works 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-4-3120-4433 Dues & Subscriptions 350.00 0.00 640.00 182.86 ( 290.00) 101-4-3120-4437 Taxes & Licenses 500.00 0.00 524.00 104.80 ( 24.00) 101-4-3120-4460 Equip Replacement Charge 111,300.00 9,275.00 83,475.00 75.00 27,825.00 TOTAL Other Services & Charges 332,700.00 27,563.47 203,091.44 61.04 129,608.56 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Street Maintenance 1,355,450.00 92,665.55 782,933.29 57.76 572,516.71 Snow Removal ============ Personal Services 101-4-3130-4101 Regular Pay 134,700.00 0.00 89,395.55 66.37 45,304.45 101-4-3130-4102 Overtime Pay 20,000.00 0.00 42,477.35 212.39 ( 22,477.35) 101-4-3130-4104 PERA 11,200.00 0.00 9,829.46 87.76 1,370.54 101-4-3130-4105 FICA 9,600.00 0.00 8,080.27 84.17 1,519.73 101-4-3130-4107 Medicare 2,250.00 0.00 1,884.94 83.78 365.06 101-4-3130-4108 Insurance 18,900.00 0.00 13,459.06 71.21 5,440.94 101-4-3130-4109 Workers Comp 9,050.00 0.00 7,456.50 82.39 1,593.50 TOTAL Personal Services 205,700.00 0.00 172,583.13 83.90 33,116.87 Supplies 101-4-3130-4219 Operating Supplies 93,000.00 0.00 44,177.63 47.50 48,822.37 TOTAL Supplies 93,000.00 0.00 44,177.63 47.50 48,822.37 Other Services & Charge s _____________ _____________ _____________ _______ _____________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Snow Removal 298,700.00 0.00 216,760.76 72.57 81,939.24 Equipment Services ================== Personal Services 101-4-3150-4101 Regular Pay 123,100.00 9,768.00 88,115.39 71.58 34,984.61 101-4-3150-4102 Overtime Pay 1,000.00 0.00 131.38 13.14 868.62 101-4-3150-4104 PERA 9,350.00 732.60 6,624.15 70.85 2,725.85 101-4-3150-4105 FICA 7,700.00 598.19 5,430.71 70.53 2,269.29 101-4-3150-4107 Medicare 1,800.00 139.89 1,270.08 70.56 529.92 101-4-3150-4108 Insurance 17,250.00 1,727.00 15,543.00 90.10 1,707.00 101-4-3150-4109 Workers Comp 3,050.00 0.00 2,425.50 79.52 624.50 TOTAL Personal Services 163,250.00 12,965.68 119,540.21 73.23 43,709.79 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND Public Works 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-3150-4212 Fuels & Lubes 5,100.00 2,021.83 3,132.63 61.42 1,967.37 101-4-3150-4219 Operating Supplies 20,650.00 1,056.62 9,956.20 48.21 10,693.80 101-4-3150-4221 Equipment Parts 5,000.00 ( 98.22) 1,251.03 25.02 3,748.97 TOTAL Supplies 30,750.00 2,980.23 14,339.86 46.63 16,410.14 Other Services & Charges 101-4-3150-4331 Travel, Conferences & Schools 3,000.00 0.00 35.14 1.17 2,964.86 101-4-3150-4404 Equip Repair/Maint Services 12,500.00 903.88 4,799.63 38.40 7,700.37 101-4-3150-4417 Uniform Rental 900.00 0.00 326.35 36.26 573.65 TOTAL Other Services & Charges 16,400.00 903.88 5,161.12 31.47 11,238.88 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Equipment Services 210,400.00 16,849.79 139,041.19 66.08 71,358.81 Engineering =========== Personal Services 101-4-3300-4101 Regular Pay 174,650.00 18,230.94 130,474.94 74.71 44,175.06 101-4-3300-4104 PERA 13,100.00 843.35 9,261.69 70.70 3,838.31 101-4-3300-4105 FICA 10,850.00 1,148.91 8,353.10 76.99 2,496.90 101-4-3300-4107 Medicare 2,550.00 268.69 1,953.55 76.61 596.45 101-4-3300-4108 Insurance 20,000.00 304.50 5,176.50 25.88 14,823.50 101-4-3300-4109 Workers Comp 600.00 0.00 501.00 83.50 99.00 TOTAL Personal Services 221,750.00 20,796.39 155,720.78 70.22 66,029.22 Supplies 101-4-3300-4201 Office Supplies 150.00 12.81 272.11 181.41 ( 122.11) 101-4-3300-4212 Fuels & Lubes 1,000.00 75.73 303.04 30.30 696.96 101-4-3300-4219 Operating Supplies 1,500.00 260.01 295.44 19.70 1,204.56 TOTAL Supplies 2,650.00 348.55 870.59 32.85 1,779.41 Other Services & Charges 101-4-3300-4319 Other Professional Services 4,000.00 0.00 1,467.12 36.68 2,532.88 101-4-3300-4321 Telephone 1,450.00 81.02 1,257.18 86.70 192.82 101-4-3300-4322 Postage 200.00 0.00 5.42 2.71 194.58 101-4-3300-4331 Travel, Conferences & Schools 1,650.00 0.00 376.02 22.79 1,273.98 101-4-3300-4361 Insurance 100.00 66.00 106.00 106.00 ( 6.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 675.00 75.00 225.00 TOTAL Other Services & Charges 9,800.00 222.02 3,886.74 39.66 5,913.26 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND Public Works 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Engineering 234,200.00 21,366.96 160,478.11 68.52 73,721.89 ___________________________________________________________________________________________________________________ TOTAL Public Works 2,098,750.00 130,882.30 1,299,213.35 61.90 799,536.65 Parks Department ================ Personal Services 101-4-5110-4101 Regular Pay 440,600.00 35,181.55 302,043.83 68.55 138,556.17 101-4-5110-4102 Overtime Pay 6,500.00 426.75 7,611.81 117.10 ( 1,111.81) 101-4-5110-4103 Part-time Pay 68,250.00 5,277.00 49,149.96 72.01 19,100.04 101-4-5110-4104 PERA 33,550.00 2,670.63 23,185.92 69.11 10,364.08 101-4-5110-4105 FICA 31,450.00 2,439.08 21,512.05 68.40 9,937.95 101-4-5110-4107 Medicare 7,350.00 570.43 5,031.01 68.45 2,318.99 101-4-5110-4108 Insurance 83,550.00 7,516.50 65,865.00 78.83 17,685.00 101-4-5110-4109 Workers Comp 17,100.00 0.00 13,716.75 80.21 3,383.25 101-4-5110-4110 Re-employment Compensation 0.00 0.00 2,556.00 0.00 ( 2,556.00) TOTAL Personal Services 688,350.00 54,081.94 490,672.33 71.28 197,677.67 Supplies 101-4-5110-4212 Fuels & Lubes 30,050.00 2,647.75 20,892.92 69.53 9,157.08 101-4-5110-4217 Uniform Allowance 3,800.00 363.99 2,697.22 70.98 1,102.78 101-4-5110-4219 Operating Supplies 106,550.00 8,255.74 73,141.69 68.65 33,408.31 101-4-5110-4221 Equipment Parts 27,000.00 2,438.53 28,116.93 104.14 ( 1,116.93) TOTAL Supplies 167,400.00 13,706.01 124,848.76 74.58 42,551.24 Other Services & Charges 101-4-5110-4321 Telephone 4,700.00 403.87 4,094.64 87.12 605.36 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 656.50 2,325.43 69.42 1,024.57 101-4-5110-4361 Insurance 33,500.00 16,244.00 32,312.00 96.45 1,188.00 101-4-5110-4389 Utilities 76,500.00 12,824.01 63,606.00 83.15 12,894.00 101-4-5110-4401 Bldg Repair/Maint Services 3,000.00 0.00 2,660.12 88.67 339.88 101-4-5110-4404 Equip Repair/Maint Services 20,000.00 378.75 8,015.20 40.08 11,984.80 101-4-5110-4409 Contractual Services 44,200.00 1,374.09 9,800.45 22.17 34,399.55 101-4-5110-4415 Equipment Rental 24,200.00 4,230.00 24,207.00 100.03 ( 7.00) 101-4-5110-4460 Equip Replacement Charge 53,500.00 4,458.33 40,124.97 75.00 13,375.03 TOTAL Other Services & Charges 263,050.00 40,569.55 187,176.17 71.16 75,873.83 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks Department 1,118,800.00 108,357.50 802,697.26 71.75 316,102.74 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND Culture & Recreation 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Parks & Rec Admin ================= Personal Services 101-4-5210-4101 Regular Pay 313,900.00 24,728.51 225,166.72 71.73 88,733.28 101-4-5210-4102 Overtime Pay 0.00 0.00 724.19 0.00 ( 724.19) 101-4-5210-4103 Part-time Pay 93,000.00 7,810.88 69,808.69 75.06 23,191.31 101-4-5210-4104 PERA 30,500.00 2,440.46 22,057.25 72.32 8,442.75 101-4-5210-4105 FICA 25,250.00 1,900.18 17,630.63 69.82 7,619.37 101-4-5210-4107 Medicare 5,900.00 444.39 4,123.29 69.89 1,776.71 101-4-5210-4108 Insurance 45,000.00 5,238.50 38,463.00 85.47 6,537.00 101-4-5210-4109 Workers Comp 3,500.00 0.00 2,714.25 77.55 785.75 TOTAL Personal Services 517,050.00 42,562.92 380,688.02 73.63 136,361.98 Supplies 101-4-5210-4219 Operating Supplies 10,050.00 284.30 7,010.94 69.76 3,039.06 TOTAL Supplies 10,050.00 284.30 7,010.94 69.76 3,039.06 Other Services & Charges 101-4-5210-4321 Telephone 3,450.00 355.74 2,515.69 72.92 934.31 101-4-5210-4322 Postage 5,300.00 0.00 262.76 4.96 5,037.24 101-4-5210-4331 Travel, Conferences & Schools 8,850.00 908.10 4,861.12 54.93 3,988.88 101-4-5210-4349 Advertising/Marketing 13,200.00 173.67 14,713.80 111.47 ( 1,513.80) 101-4-5210-4361 Insurance 450.00 416.00 618.00 137.33 ( 168.00) 101-4-5210-4389 Utilities 8,500.00 307.84 7,175.96 84.42 1,324.04 101-4-5210-4401 Bldg Repair/Maint Services 17,200.00 80.00 10,954.41 63.69 6,245.59 101-4-5210-4404 Equip Repair/Maint Services 8,800.00 0.00 8,564.69 97.33 235.31 101-4-5210-4433 Dues & Subscriptions 2,600.00 60.00 1,875.00 72.12 725.00 TOTAL Other Services & Charges 68,350.00 2,301.35 51,541.43 75.41 16,808.57 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks & Rec Admin 595,450.00 45,148.57 439,240.39 73.77 156,209.61 Recreation Programs =================== Personal Services 101-4-5220-4103 Part-time Pay 43,000.00 2,322.55 45,470.23 105.74 ( 2,470.23) 101-4-5220-4105 FICA 2,200.00 143.99 2,843.00 129.23 ( 643.00) 101-4-5220-4107 Medicare 650.00 33.68 664.89 102.29 ( 14.89) TOTAL Personal Services 45,850.00 2,500.22 48,978.12 106.82 ( 3,128.12) 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND Culture & Recreation 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-5220-4219 Operating Supplies 25,000.00 5,802.59 4,060.87 16.24 20,939.13 TOTAL Supplies 25,000.00 5,802.59 4,060.87 16.24 20,939.13 Other Services & Charges 101-4-5220-4409 Contractual Services 55,000.00 4,160.00 48,682.00 88.51 6,318.00 101-4-5220-4412 Building Rent 1,900.00 0.00 1,445.00 76.05 455.00 101-4-5220-4438 Credit Card Fees 3,600.00 358.45 2,731.32 75.87 868.68 TOTAL Other Services & Charges 60,500.00 4,518.45 52,858.32 87.37 7,641.68 ___________________________________________________________________________________________________________________ TOTAL Recreation Programs 131,350.00 12,821.26 105,897.31 80.62 25,452.69 Sr Citizen Programs =================== Personal Services 101-4-5510-4101 Regular Pay 127,700.00 11,367.01 92,984.39 72.81 34,715.61 101-4-5510-4102 Overtime Pay 0.00 366.95 366.95 0.00 ( 366.95) 101-4-5510-4103 Part-time Pay 10,150.00 741.00 5,884.88 57.98 4,265.12 101-4-5510-4104 PERA 10,350.00 645.02 6,766.31 65.37 3,583.69 101-4-5510-4105 FICA 8,550.00 786.76 6,269.03 73.32 2,280.97 101-4-5510-4107 Medicare 2,000.00 184.00 1,466.15 73.31 533.85 101-4-5510-4108 Insurance 20,950.00 899.00 8,091.00 38.62 12,859.00 101-4-5510-4109 Workers Comp 650.00 0.00 520.50 80.08 129.50 TOTAL Personal Services 180,350.00 14,989.74 122,349.21 67.84 58,000.79 Supplies 101-4-5510-4219 Operating Supplies 10,900.00 230.48 6,135.95 56.29 4,764.05 TOTAL Supplies 10,900.00 230.48 6,135.95 56.29 4,764.05 Other Services & Charges 101-4-5510-4321 Telephone 1,300.00 29.27 902.45 69.42 397.55 101-4-5510-4322 Postage 2,200.00 0.00 1,801.67 81.89 398.33 101-4-5510-4331 Travel, Conferences & Schools 3,050.00 148.24 1,237.49 40.57 1,812.51 101-4-5510-4361 Insurance 1,350.00 586.00 1,214.00 89.93 136.00 101-4-5510-4389 Utilities 22,650.00 154.79 14,585.97 64.40 8,064.03 101-4-5510-4401 Bldg Repair/Maint Services 16,700.00 243.04 10,466.91 62.68 6,233.09 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 113.67 7,617.22 63.48 4,382.78 101-4-5510-4433 Dues & Subscriptions 900.00 0.00 864.06 96.01 35.94 TOTAL Other Services & Charges 60,250.00 1,275.01 39,000.27 64.73 21,249.73 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Sr Citizen Programs 251,500.00 16,495.23 167,485.43 66.59 84,014.57 ___________________________________________________________________________________________________________________ TOTAL Culture & Recreation 2,097,100.00 182,822.56 1,515,320.39 72.26 581,779.61 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND Economic Development 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Economic Development ==================== Personal Services 101-4-6210-4101 Regular Pay 0.00 ( 22.11) 17,566.63 0.00 ( 17,566.63) 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 ( 1.65) 1,332.50 0.00 ( 1,332.50) 101-4-6210-4105 FICA 0.00 ( 1.36) 1,097.97 0.00 ( 1,097.97) 101-4-6210-4107 Medicare 0.00 ( 0.38) 261.11 0.00 ( 261.11) 101-4-6210-4108 Insurance 0.00 3.20 3,004.80 0.00 ( 3,004.80) TOTAL Personal Services 0.00 ( 22.30) 24,313.01 0.00 ( 24,313.01) Other Services & Charges 101-4-6210-4361 Insurance 0.00 818.00 818.00 0.00 ( 818.00) 101-4-6210-4440 Miscellaneous 0.00 32.83 56.91 0.00 ( 56.91) TOTAL Other Services & Charges 0.00 850.83 874.91 0.00 ( 874.91) ___________________________________________________________________________________________________________________ TOTAL Economic Development 0.00 828.53 25,187.92 0.00 ( 25,187.92) Energy City =========== Personal Services 101-4-6220-4101 Regular Pay 18,100.00 1,535.93 13,129.98 72.54 4,970.02 101-4-6220-4104 PERA 1,350.00 115.20 982.58 72.78 367.42 101-4-6220-4105 FICA 1,100.00 95.38 813.63 73.97 286.37 101-4-6220-4107 Medicare 250.00 22.30 190.28 76.11 59.72 101-4-6220-4108 Insurance 2,600.00 178.35 1,605.13 61.74 994.87 TOTAL Personal Services 23,400.00 1,947.16 16,721.60 71.46 6,678.40 Supplies 101-4-6220-4219 Operating Supplies 1,800.00 0.00 47.00 2.61 1,753.00 TOTAL Supplies 1,800.00 0.00 47.00 2.61 1,753.00 Other Services & Charges 101-4-6220-4331 Travel, Conferences & Schools 4,500.00 0.00 4,008.50 89.08 491.50 101-4-6220-4359 Publishing 1,500.00 0.00 0.00 0.00 1,500.00 101-4-6220-4361 Insurance 0.00 102.00 102.00 0.00 ( 102.00) 101-4-6220-4404 Equip Repair/Maint Svcs 1,800.00 0.00 1,724.62 95.81 75.38 TOTAL Other Services & Charges 7,800.00 102.00 5,835.12 74.81 1,964.88 ___________________________________________________________________________________________________________________ TOTAL Energy City 33,000.00 2,049.16 22,603.72 68.50 10,396.28 ___________________________________________________________________________________________________________________ TOTAL Economic Development 33,000.00 2,877.69 47,791.64 144.82 ( 14,791.64) 10-10-2018 04:26 PM CITY OF ELK RIVER PAGE: 27 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2018 101-GENERAL FUND General 75.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Transfers Out ============= Transfers Out _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL EXPENDITURES 15,229,550.00 1,164,660.76 10,396,468.44 68.27 4,833,081.56 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 464,615.87)( 924,564.16) 924,564.16 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$ 5,218,705$ 1,882,595$ 73.49% Cost of sales (5,059,100) (3,437,088) (1,622,012) 67.94% Gross profit 2,042,200 1,781,617 260,583 87.24% Operating revenues: User charges - - - 0.00%2,020,000$ 1,411,141$ 608,859$ 69.86%1,550,000$ 1,031,999$ 518,001$ 66.58%468,000$ 322,513$ 145,487$ 68.91% Delinquency collections - - - 0.00%2,000 354 1,646 17.70%8,000 1,276 6,724 15.95%- 224 (224) 0.00% Other 1,700 1,522 178 89.53%100,000 165,909 (65,909) 165.91%1,500 480 1,020 0.00%- - - 0.00% Total operating revenues 1,700 1,522 178 89.53%2,122,000 1,577,404 544,596 74.34%1,559,500 1,033,755 525,745 66.29%468,000 322,737 145,263 68.96% Operating expenses: Personal services 729,050 523,958 205,092 71.87%640,500 417,287 223,213 65.15%23,400 16,721 6,679 71.46%84,100 59,142 24,958 70.32% Supplies 20,400 9,411 10,989 46.13%195,000 177,598 17,402 91.08%21,400 15,791 5,609 73.79%2,000 130 1,870 6.50% Other service charges 259,550 183,354 76,196 70.64%626,950 453,317 173,633 72.31%1,553,650 1,024,897 528,753 65.97%187,050 37,745 149,305 20.18% 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 716,723 417,277 63.20%2,887,450 1,048,202 1,839,248 36.30%1,598,450 1,057,409 541,041 66.15%721,150 97,017 624,133 13.45% Operating income (loss)909,900 1,066,416 (156,516) 117.20%(765,450) 529,202 (1,294,652) -69.14%(38,950) (23,654) (15,296) 60.73%(253,150) 225,720 (478,870) -89.16% Nonoperating revenues (expenses): Interest income 35,000 58,779 (23,779) 167.94%80,000 56,248 23,752 70.31%8,000 3,430 4,570 42.88%5,000 8,768 (3,768) 175.36% Interest expense - - - 0.00%(256,150) (148,195) (107,955) 57.85%- - - 0.00%- - - 0.00% Total nonoperating revenues (expenses)35,000 58,779 (23,779) 167.94%(176,150) (91,947) (84,203) 52.20%8,000 3,430 4,570 42.88%5,000 8,768 (3,768) 175.36% Income (loss) before contributions and transfers 944,900 1,125,195 (180,295) 119.08%(941,600) 437,255 (1,378,855) -46.44%(30,950) (20,224) (10,726) 65.34%(248,150) 234,488 (482,638) -94.49% Contributions - connection fees - - - 0.00%500,000 917,241 (417,241) 183.45%- - - 0.00%27,000 34,688 (7,688) 128.47% Transfers in - - - 0.00%- - - 0.00%45,000 - 45,000 0.00%- - - 0.00% Transfers out (742,000) (689,174) (52,826) 92.88%(150,000) (150,000) - 100.00%(46,750) (46,750) - 100.00%(35,000) (35,000) - 100.00% NET INCOME (LOSS)202,900 436,021 (233,121) 214.89%(591,600) 1,204,496 (1,796,096) -203.60%(32,700) (66,974) 34,274 204.81%(256,150) 234,176 (490,326) -91.42% Items reclassified to balance sheet at year end: Capital Outlay (366,250) (248,994) (117,256) 67.98% Bond Payment (415,000) (415,000) - 100.00% Revenues over/(under) expenditures 202,900 436,021 (233,121) (1,372,850) 540,502 (1,913,352) (32,700) (66,974) 34,274 (256,150) 234,176 (490,326) -91.42% * Recorded at yearend Stormwater CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED SEPTEMBER 30, 2018 Liquor Sewer Garbage 10-10-2018 04:25 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: SEPTEMBER 30TH, 2018 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE ___________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 12,233.46 1,321.29 13,554.75 101-1010 Cash - General Fund 6,620,674.99 ( 459,934.55) 6,160,740.44 211-1010 Cash - Library 434,425.25 ( 8,412.51) 426,012.74 221-1010 Cash - Ice Arena 489,358.21 ( 31,112.36) 458,245.85 222-1010 Cash - Pinewood Golf Course ( 30,361.33) ( 4,028.37) ( 34,389.70) 225-1010 Cash - Park Dedication 299,790.09 0.00 299,790.09 228-1010 Cash - Landfill 250,468.52 3,090.79 253,559.31 231-1010 Cash - Landfill Const Debris 763,881.19 0.00 763,881.19 240-1010 Cash - Micro Loan Fund 732,764.52 60,098.57 792,863.09 242-1010 Cash - State DEED 33,570.46 4,166.65 37,737.11 245-1010 Cash - Development Fund 850,182.41 ( 10,890.00) 839,292.41 290-1010 Cash - Capital Outlay Reserve 932,107.65 43,123.01 975,230.66 291-1010 Cash - Insurance Reserve 131,381.04 17,910.36 149,291.40 292-1010 Cash - Govt Bldgs Reserve 1,884,125.40 96,700.10 1,980,825.50 294-1010 Cash - Drug Forfeiture 29,202.17 ( 6,357.04) 22,845.13 295-1010 Cash - Severance Pay Reserve 74,631.40 0.00 74,631.40 296-1010 Cash - GRE Reserve 2,140,447.55 0.00 2,140,447.55 333-1010 Cash - 2010A GO Cap Imp Bonds 732,416.58 0.00 732,416.58 401-1010 Cash - Pavement Mgmt 4,159,057.75 115,797.33 4,274,855.08 403-1010 Cash - Street Improvement 723,898.02 ( 18,901.18) 704,996.84 406-1010 Cash - City Wide Trunk Util 4,197,656.21 0.00 4,197,656.21 410-1010 Cash - Equipment Replacement 481,920.69 6,969.41 488,890.10 440-1010 Cash - Park Improvement 109,061.71 ( 54,409.28) 54,652.43 463-1010 Cash - TIF #23 Pref Powder 2,909.27 0.00 2,909.27 464-1010 Cash - TIF #24 Beaudry Truck ( 43,844.02) ( 4,850.60) ( 48,694.62) 602-1010 Cash - Wastewater Treatment 4,188,645.12 ( 68,290.63) 4,120,354.49 603-1010 Cash - Liquor 3,826,386.23 102,981.03 3,929,367.26 605-1010 Cash - Garbage 181,015.93 ( 4,632.29) 176,383.64 607-1010 Cash - Storm Water 689,613.80 28,419.46 718,033.26 801-1010 Cash - Interest 0.00 35,504.15 35,504.15 821-1010 Cash - Developer Escrow 802,528.68 ( 25,281.50) 777,247.18_ TOTAL CLAIM ON CASH 35,700,148.95 ( 181,018.16) 35,519,130.79 =============== ============== ============== Information Memorandum To: Mayor and City Council From: Lori Ziemer, Finance Director Date: October 15, 2018 Subject: Quarterly Investment Report (July September, 2018) _______________________________________________________________________ Introduction The purpose of this report is to update the City Council on the status of the various investments the city maintains as of September 30, 2018. Background The investment policy, originally adopted in 1998 with subsequent modifications in 2007 and 2014, complies with state statutes and generally follows the Government Finance Officers Association (GFOA) model. The investment goals for the City of Elk River are passive in nature due to the allowable investments permitted under state statutes. The city has four objectives for investing, in order of importance, they are; 1) safety of principal, 2) liquidity, 3) return on investment, and 4)maintaining the public trust. This means we are focused on not losing on the original investment, having sufficient funds on hand to meet ongoing operating cash needs, getting a market rate of return, and not purchasing speculative investments. generally limited to federal and state government obligations or agencies backed by them, rated debt of local governments, short-term highly rated commercial paper, certificates of deposit, and money market accounts (with collateralization if in excess of FDIC insurance amounts). The city intends to hold investments until maturity, which means we will get the rate of return for which we invest our funds. Our goal is not to extend our maturities beyond 10 years unless we are matching cash flow to a specific debt service payment. The finance staff makes sure the city is sufficiently liquid by continually updating our forecast on the anticipated cash flow needs over the next five-year time horizon. We anticipate two large tax settlements each year along with the regularly-scheduled debt service payments. We also build in a reserve balance maintained in money market accounts in case of unexpected expenditures. The Treasury yield curve has increased from June 29, 2018 pretty evenly across all terms. although agency yields are beginning to climb. Three-month notes are yielding 2.19% and the 10-year notes are 3.05%. Cities generally use a short-horizon benchmark such as the two-year Treasury Bill or some similar measure, currently at 2.81% which is an increase from 2.52% the previous quarter. Our current portfolio yield is roughly 2.4%, which is slightly less than the treasury yield benchmark. Our primary reserve account is our 4M Fund which is a money market account where many cities pool their funds. It currently yields 1.84% with daily withdrawal privileges. The city strives to maintain a strong diversification portfolio so liquidity and exposure risk are reduced. Attachments Investment summary Bond summary