Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION 08-19-2019
Information City of Elk) -�-1 River Memorandum TO: Mayor and City Council From: Lori Ziemer, Finance Director Date: August 19, 2019 Subject: July 2019 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund,the Ice Arena Special Revenue Fund, and the Enterprise Funds. These funds provide an important picture of the city's financial health. For the month of July, actual revenues (excluding property taxes and transfers in) and expenditures should run about 58% 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: ■ July revenue collections consist of the remaining first half property tax settlement. ■ Licenses and permits are 52% of budget estimate,with building-related permits comprising the majority of collections and are running 42% of budget. ■ Intergovernmental revenues for July consist of the second quarter Toward Zero Deaths grant and will be distributed to the participating agencies. Elk River's share of the grant is $3,826.78. ■ Charges for services are 64% of budget estimate,with the majority of July collections consisting of plan review and recreation fees. The annual fire contracts and semi-annual police contract account for the increase over budget estimate. ■ Fines and forfeits,which lag a month for collections,are running 45% of budget. ■ Transfers in are comprised of ERMU's 4% electric revenues through June and the majority of the budgeted transfers in to the General Fund were recorded in July. Expenditures: ■ Total departmental expenditures are about 52% of budget and most departments are within or below budget estimates. 2019 Monthly Expenditures $18,000 $16,000 $14,000 0 z $12,000 $10,000 ~ $8,000 v►. $6,000 $4,000 $2,000 0 Actual $944 $2,009 $3,314 $4,481 1 $6,014 $7,245 $8,468 Budget $1,352 $2,704 $4,055 $5,407 1 $6,759 $8,111 1 $9,462 $10,8141$12,166 $13,518$14,869 $16,221 ICE ARENA Through the end of July, expenditures of$401,692 exceed revenues of$394,621 by$7,071,with ice rental and breakaway hockey registrations making up the majority of revenues. Ice rental revenues are 40% of budget estimates. Demolition of the ice arena Barn will was early in August. ATTACHMENTS ■ General Fund Revenue &Expense Report ■ Enterprise Funds—Budget to Actual ■ Cash Report—All Funds 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND FINANCIAL SUMMARY 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ REVENUE SUMMARY General Fund 16,221,200.00 2,678,652.15 8,240,609.91 50.80 7,980,590.09 TOTAL REVENUES 16,221,200.00 2,678,652.15 8,240,609.91 50.80 7,980,590.09 ============= ============= ============= ======= ============= EXPENDITURE SUMMARY General Government Mayor & Council 149,050.00 5,488.63 54,770.45 36.75 94,279.55 Communications 326,350.00 27,779.61 150,656.11 46.16 175,693.89 Administrative Services 531,850.00 42,892.89 290,516.23 54.62 241,333.77 Human Resources 280,500.00 16,029.13 149,086.86 53.15 131,413.14 Elections 6,800.00 0.00 6,300.00 92.65 500.00 Finance 644,550.00 44,008.36 392,622.37 60.91 251,927.63 Information Technology 440,000.00 30,820.01 232,385.65 52.81 207,614.35 Legal 230,000.00 32,224.37 157,156.64 68.33 72,843.36 Community Development 162,750.00 12,571.88 88,514.93 54.39 74,235.07 Planning 352,550.00 26,612.43 181,476.80 51.48 171,073.20 Building Maintenance 726,550.00 60,798.54 390,362.40 53.73 336,187.60 TOTAL General Government 3,850,950.00 299,225.85 2,093,848.44 54.37 1,757,101.56 Public Safety Police Administration 850,250.00 60,436.78 500,393.96 58.85 349,856.04 Patrol 2,961,950.00 214,513.71 1,419,076.83 47.91 1,542,873.17 Investigations 1,086,550.00 86,867.32 563,647.85 51.88 522,902.15 Police Support Services 770,750.00 58,930.74 405,568.43 52.62 365,181.57 Police Reserves 16,850.00 1,391.12 3,708.36 22.01 13,141.64 Public safety building 170,300.00 18,134.44 87,859.21 51.59 82,440.79 Fire Administration 923,950.00 56,197.25 402,797.00 43.60 521,153.00 Fire Operations 408,150.00 20,680.47 229,475.48 56.22 178,674.52 Emergency Management 21,800.00 2,075.04 10,013.17 45.93 11,786.83 Building Safety 513,500.00 35,638.86 294,846.00 57.42 218,654.00 Code Enforcement 115,700.00 7,486.99 53,693.74 46.41 62,006.26 Environmental 32,450.00 3,682.19 17,810.72 54.89 14,639.28 TOTAL Public Safety 7,872,200.00 566,034.91 3,988,890.75 50.67 3,883,309.25 Public Works Street Maintenance 1,418,150.00 96,395.88 703,149.91 49.58 715,000.09 Snow Removal 279,600.00 0.00 229,204.85 81.98 50,395.15 Equipment Services 221,400.00 7,320.23 103,531.80 46.76 117,868.20 Engineering 357,750.00 30,144.03 167,908.78 46.93 189,841.22 TOTAL Public Works 2,276,900.00 133,860.14 1,203,795.34 52.87 1,073,104.66 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND FINANCIAL SUMMARY 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Culture & Recreation Parks Department 1,147,600.00 113,187.74 592,655.79 51.64 554,944.21 Parks & Rec Admin 657,000.00 50,382.72 358,355.76 54.54 298,644.24 Recreation Programs 135,000.00 39,019.88 79,044.97 58.55 55,955.03 Farmers Market 0.00 2,655.10 4,405.45 0.00 ( 4,405.45) Sr Citizen Programs 250,400.00 19,594.29 106,380.41 42.48 144,019.59 TOTAL Culture & Recreation 2,190,000.00 224,839.73 1,140,842.38 52.09 1,049,157.62 Economic Development Economic Development 0.00 ( 2,579.07) 25,430.96 0.00 ( 25,430.96) Energy City 31,150.00 2,111.71 14,742.57 47.33 16,407.43 TOTAL Economic Development 31,150.00 ( 467.36) 40,173.53 128.97 ( 9,023.53) General _____________ _____________ _____________ _______ _____________ TOTAL EXPENDITURES 16,221,200.00 1,223,493.27 8,467,550.44 52.20 7,753,649.56 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 1,455,158.88 ( 226,940.53) 226,940.53 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ General Fund ============ Taxes 101-3-0000-3111 Current Ad Valorem Taxes 11,187,400.00 1,708,248.00 5,690,812.51 50.87 5,496,587.49 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 23,647.48 23,647.48 0.00 ( 23,647.48) 101-3-0000-3121 Gravel Tax 150,000.00 0.00 14,740.24 9.83 135,259.76 101-3-0000-3131 Penalties/Interest 0.00 4,055.57 4,055.57 0.00 ( 4,055.57) TOTAL Taxes 11,337,400.00 1,735,951.05 5,733,255.80 50.57 5,604,144.20 Licenses & Permits 101-3-0000-3211 Liquor License 75,000.00 0.00 76,400.03 101.87 ( 1,400.03) 101-3-0000-3213 Cigarette License 3,000.00 0.00 0.00 0.00 3,000.00 101-3-0000-3214 Rental License 65,000.00 2,653.50 47,650.50 73.31 17,349.50 101-3-0000-3216 Mining License 25,000.00 0.00 24,836.15 99.34 163.85 101-3-0000-3217 Garbage Hauler License 2,000.00 0.00 120.00 6.00 1,880.00 101-3-0000-3218 Other Business License/Permit 14,000.00 20.00 8,960.00 64.00 5,040.00 101-3-0000-3229 NPDES Permit 18,000.00 1,225.00 13,125.00 72.92 4,875.00 101-3-0000-3231 Building Permit 480,000.00 24,203.00 209,602.35 43.67 270,397.65 101-3-0000-3232 Plumbing/Heating Permit 160,000.00 13,815.88 58,660.59 36.66 101,339.41 101-3-0000-3233 Permit Surcharge 1,000.00 ( 1,870.76) 1,908.61 190.86 ( 908.61) 101-3-0000-3235 Animal License 5,000.00 0.00 450.00 9.00 4,550.00 101-3-0000-3237 Other Non-Business Lic/Permit 9,000.00 1,635.00 7,015.00 77.94 1,985.00 TOTAL Licenses & Permits 857,000.00 41,681.62 448,728.23 52.36 408,271.77 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 182,000.00 0.00 2,000.00 1.10 180,000.00 101-3-0000-3324 PERA Aid 14,000.00 6,992.00 6,992.00 49.94 7,008.00 101-3-0000-3325 Police 2% Aid 275,000.00 0.00 0.00 0.00 275,000.00 101-3-0000-3326 Police Training Reimb 30,000.00 0.00 0.00 0.00 30,000.00 101-3-0000-3329 State Crime Prevention Grant 65,000.00 17,106.43 27,233.14 41.90 37,766.86 TOTAL Intergovernmental Rev 571,500.00 24,098.43 36,225.14 6.34 535,274.86 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 32,000.00 3,870.00 13,762.50 43.01 18,237.50 101-3-0000-3413 Plan Check Fee 200,000.00 14,732.85 104,521.07 52.26 95,478.93 101-3-0000-3415 Special Assessment Search 800.00 0.00 470.00 58.75 330.00 101-3-0000-3417 Copies 2,500.00 60.00 1,023.55 40.94 1,476.45 101-3-0000-3418 Other General Govt Services 1,500.00 38.00 690.00 46.00 810.00 101-3-0000-3430 Lockout Fees 6,000.00 640.00 3,540.00 59.00 2,460.00 101-3-0000-3431 Police Services 10,000.00 4,324.00 7,217.75 72.18 2,782.25 101-3-0000-3432 School Liaison 130,000.00 0.00 68,272.50 52.52 61,727.50 101-3-0000-3434 Animal Impound Fee 4,000.00 200.00 1,275.00 31.88 2,725.00 101-3-0000-3436 Fire Contracts 275,000.00 0.00 269,829.00 98.12 5,171.00 101-3-0000-3437 Fire Services 2,000.00 0.00 19.83 0.99 1,980.17 101-3-0000-3451 Street Services 12,000.00 1,795.00 10,918.00 90.98 1,082.00 101-3-0000-3452 Engineering Services Reimb 130,000.00 0.00 24,316.35 18.70 105,683.65 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-3-0000-3461 Recreation Fees 78,000.00 1,937.00 53,900.19 69.10 24,099.81 101-3-0000-3462 Sr Center Activities 44,000.00 3,805.00 23,547.01 53.52 20,452.99 101-3-0000-3463 Farmer's Market Fees 0.00 3,122.00 13,578.97 0.00 ( 13,578.97) 101-3-0000-3469 Other Sales - RiverFest 0.00 6,642.00 6,822.00 0.00 ( 6,822.00) 101-3-0000-3472 Park Use Fee 27,000.00 1,060.00 10,915.00 40.43 16,085.00 101-3-0000-3475 Building Rent 2,400.00 0.00 600.00 25.00 1,800.00 101-3-0000-3483 Sewer Inspection Fee 11,000.00 1,015.00 5,455.00 49.59 5,545.00 101-3-0000-3484 Contractor License Check 1,000.00 85.00 685.00 68.50 315.00 TOTAL Charges for Services 969,200.00 43,325.85 621,358.72 64.11 347,841.28 Fines & Forfeits 101-3-0000-3510 Court Fines 145,000.00 11,164.01 67,949.91 46.86 77,050.09 101-3-0000-3511 Parking Fines 9,500.00 0.00 1,260.00 13.26 8,240.00 TOTAL Fines & Forfeits 154,500.00 11,164.01 69,209.91 44.80 85,290.09 Special Assessments _____________ _____________ _____________ _______ _____________ Other Revenue 101-3-0000-3621 Interest Income 100,000.00 0.00 63,239.40 63.24 36,760.60 101-3-0000-3625 Refunds & Reimbursements 130,000.00 650.51 37.59 0.03 129,962.41 101-3-0000-3626 Contributions 23,000.00 0.00 24,000.00 104.35 ( 1,000.00) 101-3-0000-3629 Miscellaneous Revenue 6,500.00 1,386.75 3,404.30 52.37 3,095.70 TOTAL Other Revenue 259,500.00 2,037.26 90,681.29 34.94 168,818.71 Transfers In 101-3-0000-3921 Transfers 0.00 0.00 112.31 0.00 ( 112.31) 101-3-0000-3925 Transfer-Landfill 50,000.00 0.00 0.00 0.00 50,000.00 101-3-0000-3926 Transfer-Capital Outlay Reserv 14,000.00 0.00 0.00 0.00 14,000.00 101-3-0000-3929 Transfer-NSP/RDF Reserve 50,000.00 0.00 0.00 0.00 50,000.00 101-3-0000-3930 Transfer-Development 10,600.00 10,600.00 10,600.00 100.00 0.00 101-3-0000-3942 Transfer-WWTS 150,000.00 150,000.00 150,000.00 100.00 0.00 101-3-0000-3943 Transfer-Liquor 500,000.00 500,000.00 500,000.00 100.00 0.00 101-3-0000-3944 Transfer-Garbage 48,000.00 48,000.00 48,000.00 100.00 0.00 101-3-0000-3945 Transfer-Utilities 1,165,000.00 96,793.93 517,438.51 44.42 647,561.49 101-3-0000-3946 Transfer-Stormwater 15,000.00 15,000.00 15,000.00 100.00 0.00 101-3-0000-3948 Transfer-EDA 38,000.00 0.00 0.00 0.00 38,000.00 101-3-0000-3949 Transfer-HRA 31,500.00 0.00 0.00 0.00 31,500.00 TOTAL Transfers In 2,072,100.00 820,393.93 1,241,150.82 59.90 830,949.18 _____________________________________________________________________________ TOTAL General Fund 16,221,200.00 2,678,652.15 8,240,609.91 50.80 7,980,590.09 ___________________________________________________________________________________________________________________ TOTAL REVENUE 16,221,200.00 2,678,652.15 8,240,609.91 50.80 7,980,590.09 ============= ============= ============= ======= ============= 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Mayor & Council =============== Personal Services 101-4-1110-4103 Part-time Pay 38,500.00 3,208.36 22,458.48 58.33 16,041.52 101-4-1110-4104 PERA 1,300.00 100.01 730.07 56.16 569.93 101-4-1110-4105 FICA 1,000.00 74.92 561.62 56.16 438.38 101-4-1110-4107 Medicare 600.00 46.53 343.05 57.18 256.95 101-4-1110-4109 Workers Comp 100.00 0.00 35.00 35.00 65.00 TOTAL Personal Services 41,500.00 3,429.82 24,128.22 58.14 17,371.78 Supplies 101-4-1110-4201 Office Supplies 700.00 59.99 221.73 31.68 478.27 TOTAL Supplies 700.00 59.99 221.73 31.68 478.27 Other Services & Charges 101-4-1110-4319 Other Professional Services 10,500.00 857.52 2,905.04 27.67 7,594.96 101-4-1110-4322 Postage 50.00 18.51 85.33 170.66 ( 35.33) 101-4-1110-4331 Travel, Conferences & Schools 2,600.00 151.07 478.91 18.42 2,121.09 101-4-1110-4359 Publishing 3,700.00 696.00 1,448.00 39.14 2,252.00 101-4-1110-4361 Insurance 40,000.00 0.00 19,521.00 48.80 20,479.00 101-4-1110-4433 Dues & Subscriptions 19,550.00 0.00 0.00 0.00 19,550.00 101-4-1110-4440 Miscellaneous 30,450.00 275.72 5,982.22 19.65 24,467.78 TOTAL Other Services & Charges 106,850.00 1,998.82 30,420.50 28.47 76,429.50 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Mayor & Council 149,050.00 5,488.63 54,770.45 36.75 94,279.55 Communications ============== Personal Services 101-4-1120-4101 Regular Pay 203,450.00 15,187.55 96,062.85 47.22 107,387.15 101-4-1120-4103 Part-time Pay 19,400.00 698.44 5,218.53 26.90 14,181.47 101-4-1120-4104 PERA 17,300.00 1,191.46 7,596.08 43.91 9,703.92 101-4-1120-4105 FICA 13,800.00 968.49 6,135.70 44.46 7,664.30 101-4-1120-4107 Medicare 3,250.00 226.49 1,434.95 44.15 1,815.05 101-4-1120-4108 Insurance 30,550.00 2,545.50 16,905.00 55.34 13,645.00 101-4-1120-4109 Workers Comp 1,000.00 0.00 679.50 67.95 320.50 TOTAL Personal Services 288,750.00 20,817.93 134,032.61 46.42 154,717.39 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND General Government 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1120-4201 Office Supplies 4,500.00 59.56 5,663.71 125.86 ( 1,163.71) TOTAL Supplies 4,500.00 59.56 5,663.71 125.86 ( 1,163.71) Other Services & Charges 101-4-1120-4319 Other Professional Services 21,800.00 6,902.12 9,240.12 42.39 12,559.88 101-4-1120-4321 Telephone 1,300.00 0.00 180.00 13.85 1,120.00 101-4-1120-4331 Travel, Conferences & Schools 8,650.00 0.00 1,214.67 14.04 7,435.33 101-4-1120-4433 Dues & Subscriptions 1,350.00 0.00 325.00 24.07 1,025.00 TOTAL Other Services & Charges 33,100.00 6,902.12 10,959.79 33.11 22,140.21 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Communications 326,350.00 27,779.61 150,656.11 46.16 175,693.89 Administrative Services ======================= Personal Services 101-4-1210-4101 Regular Pay 354,700.00 27,699.70 194,286.35 54.77 160,413.65 101-4-1210-4102 Overtime Pay 0.00 0.00 146.88 0.00 ( 146.88) 101-4-1210-4103 Part-time Pay 56,100.00 4,118.04 28,971.88 51.64 27,128.12 101-4-1210-4104 PERA 30,800.00 2,386.33 16,755.38 54.40 14,044.62 101-4-1210-4105 FICA 25,500.00 1,948.96 13,868.97 54.39 11,631.03 101-4-1210-4107 Medicare 6,000.00 455.82 3,243.55 54.06 2,756.45 101-4-1210-4108 Insurance 22,000.00 3,131.00 17,268.20 78.49 4,731.80 101-4-1210-4109 Workers Comp 2,000.00 0.00 1,383.75 69.19 616.25 TOTAL Personal Services 497,100.00 39,739.85 275,924.96 55.51 221,175.04 Supplies 101-4-1210-4201 Office Supplies 5,300.00 206.33 4,248.47 80.16 1,051.53 TOTAL Supplies 5,300.00 206.33 4,248.47 80.16 1,051.53 Other Services & Charges 101-4-1210-4321 Telephone 900.00 134.23 475.38 52.82 424.62 101-4-1210-4322 Postage 800.00 137.89 457.77 57.22 342.23 101-4-1210-4331 Travel, Conferences & Schools 5,250.00 1,571.02 2,323.37 44.25 2,926.63 101-4-1210-4334 Car Allowance 4,800.00 400.00 2,800.00 58.33 2,000.00 101-4-1210-4361 Insurance 100.00 0.00 32.00 32.00 68.00 101-4-1210-4404 Equip Repair/Maint Services 15,350.00 512.61 2,434.52 15.86 12,915.48 101-4-1210-4433 Dues & Subscriptions 2,250.00 190.96 1,819.76 80.88 430.24 TOTAL Other Services & Charges 29,450.00 2,946.71 10,342.80 35.12 19,107.20 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND General Government 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Administrative Services 531,850.00 42,892.89 290,516.23 54.62 241,333.77 Human Resources =============== Personal Services 101-4-1220-4101 Regular Pay 152,800.00 12,037.35 83,146.20 54.42 69,653.80 101-4-1220-4104 PERA 11,450.00 902.80 6,235.92 54.46 5,214.08 101-4-1220-4105 FICA 9,500.00 728.05 5,032.66 52.98 4,467.34 101-4-1220-4107 Medicare 2,200.00 170.26 1,176.99 53.50 1,023.01 101-4-1220-4108 Insurance 14,750.00 1,780.00 12,460.00 84.47 2,290.00 101-4-1220-4109 Workers Comp 750.00 0.00 514.50 68.60 235.50 TOTAL Personal Services 191,450.00 15,618.46 108,566.27 56.71 82,883.73 Supplies 101-4-1220-4201 Office Supplies 6,200.00 71.65 1,360.99 21.95 4,839.01 TOTAL Supplies 6,200.00 71.65 1,360.99 21.95 4,839.01 Other Services & Charges 101-4-1220-4319 Other Professional Services 4,150.00 254.55 863.50 20.81 3,286.50 101-4-1220-4322 Postage 300.00 84.47 238.10 79.37 61.90 101-4-1220-4331 Travel, Conferences & Schools 6,200.00 0.00 464.00 7.48 5,736.00 101-4-1220-4359 Publishing 0.00 0.00 72.00 0.00 ( 72.00) 101-4-1220-4404 Equip Repair/Maint 72,000.00 0.00 37,307.00 51.82 34,693.00 101-4-1220-4433 Dues & Subscriptions 200.00 0.00 215.00 107.50 ( 15.00) TOTAL Other Services & Charges 82,850.00 339.02 39,159.60 47.27 43,690.40 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Human Resources 280,500.00 16,029.13 149,086.86 53.15 131,413.14 Elections ========= Personal Service s _____________ _____________ _____________ _______ _____________ Supplies _____________ _____________ _____________ _______ _____________ Other Services & Charges 101-4-1230-4404 Equip Repair/Maint Services 6,800.00 0.00 6,300.00 92.65 500.00 TOTAL Other Services & Charges 6,800.00 0.00 6,300.00 92.65 500.00 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND General Government 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Elections 6,800.00 0.00 6,300.00 92.65 500.00 Finance ======= Personal Services 101-4-1310-4101 Regular Pay 348,800.00 27,340.96 190,494.20 54.61 158,305.80 101-4-1310-4103 Part-time Pay 57,700.00 4,235.52 31,252.18 54.16 26,447.82 101-4-1310-4104 PERA 30,500.00 2,368.22 16,630.97 54.53 13,869.03 101-4-1310-4105 FICA 25,200.00 1,836.97 13,080.61 51.91 12,119.39 101-4-1310-4107 Medicare 5,900.00 429.60 3,059.17 51.85 2,840.83 101-4-1310-4108 Insurance 59,950.00 4,995.30 34,967.10 58.33 24,982.90 101-4-1310-4109 Workers Comp 2,000.00 0.00 1,368.75 68.44 631.25 TOTAL Personal Services 530,050.00 41,206.57 290,852.98 54.87 239,197.02 Supplies 101-4-1310-4201 Office Supplies 4,100.00 45.23 1,879.17 45.83 2,220.83 TOTAL Supplies 4,100.00 45.23 1,879.17 45.83 2,220.83 Other Services & Charges 101-4-1310-4301 Audit Fees 16,000.00 625.00 15,625.00 97.66 375.00 101-4-1310-4319 Other Professional Services 56,000.00 0.00 54,666.00 97.62 1,334.00 101-4-1310-4321 Telephone 900.00 90.00 292.64 32.52 607.36 101-4-1310-4322 Postage 2,900.00 1,046.15 2,106.43 72.64 793.57 101-4-1310-4331 Travel, Conferences & Schools 4,400.00 0.00 2,370.67 53.88 2,029.33 101-4-1310-4359 Publishing 200.00 0.00 0.00 0.00 200.00 101-4-1310-4404 Equip Repair/Maint Services 18,600.00 0.00 17,865.78 96.05 734.22 101-4-1310-4433 Dues & Subscriptions 1,600.00 0.00 655.00 40.94 945.00 101-4-1310-4438 Credit Card Fees 8,500.00 896.71 5,622.10 66.14 2,877.90 101-4-1310-4440 Miscellaneous 1,300.00 98.70 686.60 52.82 613.40 TOTAL Other Services & Charges 110,400.00 2,756.56 99,890.22 90.48 10,509.78 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Finance 644,550.00 44,008.36 392,622.37 60.91 251,927.63 Information Technology ====================== Personal Services 101-4-1350-4101 Regular Pay 223,900.00 17,865.19 123,663.99 55.23 100,236.01 101-4-1350-4104 PERA 16,800.00 1,339.90 9,274.78 55.21 7,525.22 101-4-1350-4105 FICA 13,900.00 1,094.51 7,486.51 53.86 6,413.49 101-4-1350-4107 Medicare 3,250.00 255.96 1,750.87 53.87 1,499.13 101-4-1350-4108 Insurance 25,050.00 3,047.67 21,511.23 85.87 3,538.77 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND General Government 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-4-1350-4109 Workers Comp 1,100.00 0.00 753.75 68.52 346.25 TOTAL Personal Services 284,000.00 23,603.23 164,441.13 57.90 119,558.87 Supplies 101-4-1350-4219 Operating Supplies 14,300.00 1,445.77 8,802.94 61.56 5,497.06 TOTAL Supplies 14,300.00 1,445.77 8,802.94 61.56 5,497.06 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 398.75 652.50 8.16 7,347.50 101-4-1350-4321 Telephone 2,200.00 0.00 500.83 22.77 1,699.17 101-4-1350-4331 Travel, Conferences & Schools 9,750.00 138.51 1,768.97 18.14 7,981.03 101-4-1350-4404 Equip Repair/Maint Services 121,750.00 5,233.75 56,219.28 46.18 65,530.72 TOTAL Other Services & Charges 141,700.00 5,771.01 59,141.58 41.74 82,558.42 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Information Technology 440,000.00 30,820.01 232,385.65 52.81 207,614.35 Legal ===== Other Services & Charges 101-4-1400-4304 Legal Fees 230,000.00 32,224.37 157,156.64 68.33 72,843.36 TOTAL Other Services & Charges 230,000.00 32,224.37 157,156.64 68.33 72,843.36 ___________________________________________________________________________________________________________________ TOTAL Legal 230,000.00 32,224.37 157,156.64 68.33 72,843.36 Community Development ===================== Personal Services 101-4-1500-4101 Regular Pay 125,400.00 9,767.68 68,813.64 54.88 56,586.36 101-4-1500-4104 PERA 9,400.00 732.58 5,160.99 54.90 4,239.01 101-4-1500-4105 FICA 7,800.00 593.23 4,183.60 53.64 3,616.40 101-4-1500-4107 Medicare 1,850.00 138.74 978.42 52.89 871.58 101-4-1500-4108 Insurance 14,000.00 1,169.50 8,186.50 58.48 5,813.50 101-4-1500-4109 Workers Comp 600.00 0.00 422.25 70.38 177.75 TOTAL Personal Services 159,050.00 12,401.73 87,745.40 55.17 71,304.60 Supplies 101-4-1500-4201 Office Supplies 500.00 31.66 152.29 30.46 347.71 TOTAL Supplies 500.00 31.66 152.29 30.46 347.71 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND General Government 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-1500-4321 Telephone 800.00 90.00 368.75 46.09 431.25 101-4-1500-4331 Travel, Conferences & Schools 1,850.00 48.49 48.49 2.62 1,801.51 101-4-1500-4433 Dues & Subscriptions 550.00 0.00 200.00 36.36 350.00 TOTAL Other Services & Charges 3,200.00 138.49 617.24 19.29 2,582.76 ___________________________________________________________________________________________________________________ TOTAL Community Development 162,750.00 12,571.88 88,514.93 54.39 74,235.07 Planning ======== Personal Services 101-4-1510-4101 Regular Pay 246,100.00 19,218.08 134,973.45 54.84 111,126.55 101-4-1510-4103 Part-time Pay 15,600.00 443.38 443.38 2.84 15,156.62 101-4-1510-4104 PERA 19,650.00 1,441.36 10,122.95 51.52 9,527.05 101-4-1510-4105 FICA 16,250.00 1,200.14 8,269.43 50.89 7,980.57 101-4-1510-4107 Medicare 3,800.00 280.68 1,933.98 50.89 1,866.02 101-4-1510-4108 Insurance 30,250.00 2,520.50 17,643.50 58.33 12,606.50 101-4-1510-4109 Workers Comp 950.00 0.00 684.00 72.00 266.00 TOTAL Personal Services 332,600.00 25,104.14 174,070.69 52.34 158,529.31 Supplies 101-4-1510-4201 Office Supplies 2,050.00 609.28 1,294.28 63.14 755.72 101-4-1510-4212 Fuels & Lubes 50.00 4.42 6.44 12.88 43.56 TOTAL Supplies 2,100.00 613.70 1,300.72 61.94 799.28 Other Services & Charges 101-4-1510-4321 Telephone 350.00 0.00 90.00 25.71 260.00 101-4-1510-4322 Postage 1,500.00 358.59 626.04 41.74 873.96 101-4-1510-4331 Travel, Conferences & Schools 3,400.00 0.00 126.01 3.71 3,273.99 101-4-1510-4359 Publishing 10,000.00 536.00 3,628.00 36.28 6,372.00 101-4-1510-4361 Insurance 100.00 0.00 32.00 32.00 68.00 101-4-1510-4404 Equip Repair/Maint Services 1,500.00 0.00 978.34 65.22 521.66 101-4-1510-4433 Dues & Subscriptions 500.00 0.00 579.00 115.80 ( 79.00) 101-4-1510-4440 Miscellaneous 500.00 0.00 46.00 9.20 454.00 TOTAL Other Services & Charges 17,850.00 894.59 6,105.39 34.20 11,744.61 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Planning 352,550.00 26,612.43 181,476.80 51.48 171,073.20 Building Maintenance ==================== 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND General Government 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Services 101-4-1600-4101 Regular Pay 408,050.00 31,684.75 221,754.36 54.34 186,295.64 101-4-1600-4102 Overtime Pay 3,000.00 357.51 3,635.04 121.17 ( 635.04) 101-4-1600-4103 Part-time Pay 3,850.00 706.58 1,946.70 50.56 1,903.30 101-4-1600-4104 PERA 30,850.00 2,403.17 16,904.21 54.79 13,945.79 101-4-1600-4105 FICA 25,750.00 2,094.12 14,222.49 55.23 11,527.51 101-4-1600-4107 Medicare 6,050.00 489.76 3,326.23 54.98 2,723.77 101-4-1600-4108 Insurance 56,850.00 4,730.50 33,113.50 58.25 23,736.50 101-4-1600-4109 Workers Comp 13,800.00 0.00 10,074.75 73.01 3,725.25 TOTAL Personal Services 548,200.00 42,466.39 304,977.28 55.63 243,222.72 Supplies 101-4-1600-4212 Fuels & Lubes 3,000.00 282.00 2,229.81 74.33 770.19 101-4-1600-4217 Uniform Allowance 2,850.00 1,176.00 2,200.00 77.19 650.00 101-4-1600-4219 Operating Supplies 29,950.00 1,731.45 13,457.61 44.93 16,492.39 TOTAL Supplies 35,800.00 3,189.45 17,887.42 49.96 17,912.58 Other Services & Charges 101-4-1600-4321 Telephone 13,850.00 1,105.84 7,872.26 56.84 5,977.74 101-4-1600-4331 Travel, Conferences & Schools 1,000.00 0.00 511.50 51.15 488.50 101-4-1600-4361 Insurance 5,100.00 0.00 2,412.00 47.29 2,688.00 101-4-1600-4389 Utilities 74,050.00 8,219.36 39,092.12 52.79 34,957.88 101-4-1600-4401 Bldg Repair/Maint Services 38,550.00 5,484.16 11,901.95 30.87 26,648.05 101-4-1600-4404 Equip Repair/Maint Services 6,000.00 0.00 3,374.49 56.24 2,625.51 101-4-1600-4460 Equip Replacement Charge 4,000.00 333.34 2,333.38 58.33 1,666.62 TOTAL Other Services & Charges 142,550.00 15,142.70 67,497.70 47.35 75,052.30 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Maintenance 726,550.00 60,798.54 390,362.40 53.73 336,187.60 Contingency =========== Personal Service s _____________ _____________ _____________ _______ _____________ Other Services & Charge s _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL General Government 3,850,950.00 299,225.85 2,093,848.44 54.37 1,757,101.56 Police Administration ===================== 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Public Safety 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Services 101-4-2110-4101 Regular Pay 413,400.00 33,370.56 223,280.75 54.01 190,119.25 101-4-2110-4102 Overtime Pay 1,500.00 0.00 0.00 0.00 1,500.00 101-4-2110-4104 PERA 64,700.00 5,215.42 34,815.04 53.81 29,884.96 101-4-2110-4105 FICA 3,800.00 305.39 2,106.41 55.43 1,693.59 101-4-2110-4107 Medicare 6,050.00 473.49 3,184.45 52.64 2,865.55 101-4-2110-4108 Insurance 34,800.00 2,899.00 20,293.00 58.31 14,507.00 101-4-2110-4109 Workers Comp 93,000.00 0.00 67,962.00 73.08 25,038.00 TOTAL Personal Services 617,250.00 42,263.86 351,641.65 56.97 265,608.35 Supplies 101-4-2110-4201 Office Supplies 11,000.00 804.60 6,778.83 61.63 4,221.17 101-4-2110-4217 Uniform Allowance 3,150.00 23.95 1,347.31 42.77 1,802.69 101-4-2110-4219 Operating Supplies 17,500.00 1,505.50 8,773.14 50.13 8,726.86 TOTAL Supplies 31,650.00 2,334.05 16,899.28 53.39 14,750.72 Other Services & Charges 101-4-2110-4319 Other Professional Services 4,600.00 2,175.00 4,632.76 100.71 ( 32.76) 101-4-2110-4321 Telephone 39,800.00 2,331.02 17,244.98 43.33 22,555.02 101-4-2110-4322 Postage 1,800.00 583.35 1,261.72 70.10 538.28 101-4-2110-4331 Travel, Conferences & Schools 17,300.00 1,299.50 8,271.72 47.81 9,028.28 101-4-2110-4361 Insurance 48,500.00 0.00 23,844.00 49.16 24,656.00 101-4-2110-4404 Equip Repair/Maint Services 73,600.00 9,450.00 64,390.61 87.49 9,209.39 101-4-2110-4433 Dues & Subscriptions 15,550.00 0.00 12,090.24 77.75 3,459.76 101-4-2110-4437 Taxes & Licenses 200.00 0.00 117.00 58.50 83.00 TOTAL Other Services & Charges 201,350.00 15,838.87 131,853.03 65.48 69,496.97 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Administration 850,250.00 60,436.78 500,393.96 58.85 349,856.04 Patrol ====== Personal Services 101-4-2120-4101 Regular Pay 1,926,300.00 137,345.33 962,581.33 49.97 963,718.67 101-4-2120-4102 Overtime Pay 100,000.00 6,889.73 25,895.13 25.90 74,104.87 101-4-2120-4104 PERA 334,450.00 24,447.88 163,831.14 48.99 170,618.86 101-4-2120-4107 Medicare 28,650.00 2,052.66 14,093.78 49.19 14,556.22 101-4-2120-4108 Insurance 192,750.00 14,658.50 101,231.00 52.52 91,519.00 TOTAL Personal Services 2,582,150.00 185,394.10 1,267,632.38 49.09 1,314,517.62 Supplies 101-4-2120-4212 Fuels & Lubes 100,000.00 6,568.48 44,092.45 44.09 55,907.55 101-4-2120-4217 Uniform Allowance 24,800.00 2,989.74 7,634.44 30.78 17,165.56 101-4-2120-4219 Operating Supplies 62,850.00 4,995.30 18,202.41 28.96 44,647.59 101-4-2120-4221 Equipment Parts 31,300.00 4,576.29 14,680.88 46.90 16,619.12 TOTAL Supplies 218,950.00 19,129.81 84,610.18 38.64 134,339.82 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Public Safety 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 33,350.00 2,190.00 18,658.20 55.95 14,691.80 101-4-2120-4404 Equip Repair/Maint Services 23,850.00 3,383.13 8,924.45 37.42 14,925.55 101-4-2120-4433 Dues & Subscriptions 650.00 0.00 300.00 46.15 350.00 101-4-2120-4440 Misc. - Grant Distribution 50,000.00 0.00 8,034.93 16.07 41,965.07 101-4-2120-4460 Equip Replacement Charge 53,000.00 4,416.67 30,916.69 58.33 22,083.31 TOTAL Other Services & Charges 160,850.00 9,989.80 66,834.27 41.55 94,015.73 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Patrol 2,961,950.00 214,513.71 1,419,076.83 47.91 1,542,873.17 Investigations ============== Personal Services 101-4-2130-4101 Regular Pay 741,500.00 59,667.48 388,537.46 52.40 352,962.54 101-4-2130-4102 Overtime Pay 55,000.00 3,351.16 19,354.31 35.19 35,645.69 101-4-2130-4104 PERA 135,000.00 10,681.68 69,111.08 51.19 65,888.92 101-4-2130-4107 Medicare 11,550.00 871.11 5,630.43 48.75 5,919.57 101-4-2130-4108 Insurance 87,350.00 7,999.94 58,288.58 66.73 29,061.42 TOTAL Personal Services 1,030,400.00 82,571.37 540,921.86 52.50 489,478.14 Supplies 101-4-2130-4217 Uniform Allowance 7,250.00 839.41 3,690.16 50.90 3,559.84 101-4-2130-4219 Operating Supplies 8,100.00 565.50 1,525.92 18.84 6,574.08 TOTAL Supplies 15,350.00 1,404.91 5,216.08 33.98 10,133.92 Other Services & Charges 101-4-2130-4319 Other Professional Services 5,000.00 12.50 217.13 4.34 4,782.87 101-4-2130-4331 Travel, Conferences & Schools 15,250.00 1,200.00 5,804.87 38.06 9,445.13 101-4-2130-4433 Dues & Subscriptions 3,550.00 261.87 1,571.22 44.26 1,978.78 101-4-2130-4460 Equip Replacement Charge 17,000.00 1,416.67 9,916.69 58.33 7,083.31 TOTAL Other Services & Charges 40,800.00 2,891.04 17,509.91 42.92 23,290.09 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Investigations 1,086,550.00 86,867.32 563,647.85 51.88 522,902.15 Police Support Services ======================= 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Public Safety 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Services 101-4-2150-4101 Regular Pay 494,100.00 38,538.28 270,372.93 54.72 223,727.07 101-4-2150-4102 Overtime Pay 8,500.00 76.26 2,203.98 25.93 6,296.02 101-4-2150-4103 Part-time Pay 49,600.00 3,720.91 24,370.52 49.13 25,229.48 101-4-2150-4104 PERA 50,700.00 3,897.13 27,475.31 54.19 23,224.69 101-4-2150-4105 FICA 28,150.00 2,105.36 14,683.42 52.16 13,466.58 101-4-2150-4107 Medicare 8,000.00 596.03 4,191.26 52.39 3,808.74 101-4-2150-4108 Insurance 85,700.00 7,201.00 50,407.00 58.82 35,293.00 TOTAL Personal Services 724,750.00 56,134.97 393,704.42 54.32 331,045.58 Supplies 101-4-2150-4201 Office Supplies 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2150-4217 Uniform Allowance 5,950.00 1,462.75 3,184.96 53.53 2,765.04 101-4-2150-4219 Operating Supplies 10,000.00 ( 338.26)( 1,261.25) 12.61- 11,261.25 TOTAL Supplies 16,950.00 1,124.49 1,923.71 11.35 15,026.29 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 5,000.00 0.00 579.00 11.58 4,421.00 101-4-2150-4409 Contractual Services 16,500.00 1,087.94 4,947.92 29.99 11,552.08 101-4-2150-4433 Dues & Subscriptions 550.00 0.00 330.00 60.00 220.00 101-4-2150-4460 Equip Replacement Charge 7,000.00 583.34 4,083.38 58.33 2,916.62 TOTAL Other Services & Charges 29,050.00 1,671.28 9,940.30 34.22 19,109.70 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Support Services 770,750.00 58,930.74 405,568.43 52.62 365,181.57 Police Reserves =============== Personal Services 101-4-2160-4103 Part-time Pay 3,000.00 964.37 1,276.25 42.54 1,723.75 101-4-2160-4105 FICA 200.00 59.79 79.11 39.56 120.89 101-4-2160-4107 Medicare 50.00 13.99 18.50 37.00 31.50 101-4-2160-4110 Re-employment Compensation 0.00 0.00 23.53 0.00 ( 23.53) TOTAL Personal Services 3,250.00 1,038.15 1,397.39 43.00 1,852.61 Supplies 101-4-2160-4217 Uniform Allowance 5,600.00 110.00 989.00 17.66 4,611.00 101-4-2160-4219 Operating Supplies 3,000.00 242.97 242.97 8.10 2,757.03 TOTAL Supplies 8,600.00 352.97 1,231.97 14.33 7,368.03 Other Services & Charges 101-4-2160-4319 Other Professional Services 1,800.00 0.00 179.00 9.94 1,621.00 101-4-2160-4331 Travel, Conferences & Schools 3,200.00 0.00 900.00 28.13 2,300.00 TOTAL Other Services & Charges 5,000.00 0.00 1,079.00 21.58 3,921.00 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Public Safety 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Reserves 16,850.00 1,391.12 3,708.36 22.01 13,141.64 Public safety building ====================== Personal Service s _____________ _____________ _____________ _______ _____________ Supplies 101-4-2190-4219 Operating Supplies 22,300.00 483.18 19,688.19 88.29 2,611.81 TOTAL Supplies 22,300.00 483.18 19,688.19 88.29 2,611.81 Other Services & Charges 101-4-2190-4361 Insurance 4,700.00 0.00 2,238.00 47.62 2,462.00 101-4-2190-4389 Utilities 91,300.00 13,127.18 52,676.69 57.70 38,623.31 101-4-2190-4401 Bldg Repair/Maint Services 52,000.00 4,524.08 13,256.33 25.49 38,743.67 TOTAL Other Services & Charges 148,000.00 17,651.26 68,171.02 46.06 79,828.98 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Public safety building 170,300.00 18,134.44 87,859.21 51.59 82,440.79 Fire Administration =================== Personal Services 101-4-2310-4101 Regular Pay 424,500.00 33,246.47 235,949.75 55.58 188,550.25 101-4-2310-4102 Overtime Pay 0.00 0.00 235.80 0.00 ( 235.80) 101-4-2310-4104 PERA 60,550.00 4,746.37 33,791.93 55.81 26,758.07 101-4-2310-4105 FICA 7,450.00 604.53 4,234.56 56.84 3,215.44 101-4-2310-4106 Other Retirement Contributions 212,000.00 0.00 2,000.00 0.94 210,000.00 101-4-2310-4107 Medicare 6,150.00 467.95 3,337.98 54.28 2,812.02 101-4-2310-4108 Insurance 51,450.00 5,246.50 36,725.50 71.38 14,724.50 101-4-2310-4109 Workers Comp 13,100.00 0.00 8,134.50 62.10 4,965.50 TOTAL Personal Services 775,200.00 44,311.82 324,410.02 41.85 450,789.98 Supplies 101-4-2310-4201 Office Supplies 1,300.00 0.00 121.26 9.33 1,178.74 101-4-2310-4212 Fuels & Lubes 9,000.00 347.42 3,442.21 38.25 5,557.79 101-4-2310-4217 Uniform Allowance 2,750.00 226.50 873.43 31.76 1,876.57 101-4-2310-4219 Operating Supplies 6,500.00 461.44 1,725.59 26.55 4,774.41 101-4-2310-4221 Equipment Parts 500.00 553.79 704.60 140.92 ( 204.60) TOTAL Supplies 20,050.00 1,589.15 6,867.09 34.25 13,182.91 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Public Safety 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-2310-4319 Other Professional Services 2,000.00 0.00 686.65 34.33 1,313.35 101-4-2310-4321 Telephone 4,600.00 288.56 2,042.77 44.41 2,557.23 101-4-2310-4322 Postage 700.00 136.80 350.98 50.14 349.02 101-4-2310-4331 Travel, Conferences & Schools 4,300.00 449.25 3,355.66 78.04 944.34 101-4-2310-4359 Publishing 200.00 0.00 0.00 0.00 200.00 101-4-2310-4361 Insurance 7,350.00 0.00 3,506.50 47.71 3,843.50 101-4-2310-4389 Utilities 19,000.00 1,664.41 11,561.19 60.85 7,438.81 101-4-2310-4401 Bldg Repair/Maint Services 12,000.00 236.76 4,167.64 34.73 7,832.36 101-4-2310-4404 Equip Repair/Maint Services 3,450.00 0.00 456.00 13.22 2,994.00 101-4-2310-4433 Dues & Subscriptions 3,100.00 1,520.50 3,392.50 109.44 ( 292.50) 101-4-2310-4460 Equip Replacement Charge 72,000.00 6,000.00 42,000.00 58.33 30,000.00 TOTAL Other Services & Charges 128,700.00 10,296.28 71,519.89 55.57 57,180.11 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Administration 923,950.00 56,197.25 402,797.00 43.60 521,153.00 Fire Operations =============== Personal Services 101-4-2320-4103 Part-time Pay 188,700.00 10,623.92 107,032.45 56.72 81,667.55 101-4-2320-4105 FICA 11,700.00 654.33 6,610.80 56.50 5,089.20 101-4-2320-4107 Medicare 2,750.00 153.02 1,545.40 56.20 1,204.60 101-4-2320-4108 Insurance 1,500.00 118.40 868.18 57.88 631.82 101-4-2320-4109 Workers Comp 36,000.00 0.00 26,819.50 74.50 9,180.50 TOTAL Personal Services 240,650.00 11,549.67 142,876.33 59.37 97,773.67 Supplies 101-4-2320-4201 Office Supplies 200.00 0.00 0.00 0.00 200.00 101-4-2320-4212 Fuels & Lubes 8,500.00 385.91 3,241.43 38.13 5,258.57 101-4-2320-4217 Uniform Allowance 7,300.00 29.00 1,467.00 20.10 5,833.00 101-4-2320-4219 Operating Supplies 77,700.00 323.38 39,632.80 51.01 38,067.20 101-4-2320-4221 Equipment Parts 10,000.00 526.30 1,930.06 19.30 8,069.94 TOTAL Supplies 103,700.00 1,264.59 46,271.29 44.62 57,428.71 Other Services & Charges 101-4-2320-4321 Telephone 4,600.00 47.34 1,761.79 38.30 2,838.21 101-4-2320-4331 Travel, Conferences & Schools 13,500.00 ( 910.17) 4,520.66 33.49 8,979.34 101-4-2320-4404 Equip Repair/Maint Services 38,700.00 8,729.04 29,558.41 76.38 9,141.59 101-4-2320-4409 Contractual Services 7,000.00 0.00 4,487.00 64.10 2,513.00 TOTAL Other Services & Charges 63,800.00 7,866.21 40,327.86 63.21 23,472.14 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Public Safety 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Operations 408,150.00 20,680.47 229,475.48 56.22 178,674.52 Emergency Management ==================== Personal Service s _____________ _____________ _____________ _______ _____________ Supplies 101-4-2330-4219 Operating Supplies 6,500.00 1,374.31 2,734.17 42.06 3,765.83 TOTAL Supplies 6,500.00 1,374.31 2,734.17 42.06 3,765.83 Other Services & Charges 101-4-2330-4321 Telephone 0.00 39.67 195.71 0.00 ( 195.71) 101-4-2330-4331 Travel, Conferences & Schools 3,900.00 0.00 0.00 0.00 3,900.00 101-4-2330-4389 Utilities 5,200.00 661.06 3,633.29 69.87 1,566.71 101-4-2330-4404 Equip Repair/Maint Services 5,950.00 0.00 3,450.00 57.98 2,500.00 101-4-2330-4433 Dues & Subscriptions 250.00 0.00 0.00 0.00 250.00 TOTAL Other Services & Charges 15,300.00 700.73 7,279.00 47.58 8,021.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Emergency Management 21,800.00 2,075.04 10,013.17 45.93 11,786.83 Building Safety =============== Personal Services 101-4-2410-4101 Regular Pay 363,650.00 25,267.54 212,792.90 58.52 150,857.10 101-4-2410-4102 Overtime Pay 0.00 0.00 1,263.40 0.00 ( 1,263.40) 101-4-2410-4104 PERA 27,300.00 1,895.06 14,753.54 54.04 12,546.46 101-4-2410-4105 FICA 22,550.00 1,477.49 12,472.83 55.31 10,077.17 101-4-2410-4107 Medicare 5,300.00 345.56 2,917.42 55.05 2,382.58 101-4-2410-4108 Insurance 69,250.00 4,119.00 35,836.56 51.75 33,413.44 101-4-2410-4109 Workers Comp 1,400.00 0.00 1,415.25 101.09 ( 15.25) TOTAL Personal Services 489,450.00 33,104.65 281,451.90 57.50 207,998.10 Supplies 101-4-2410-4201 Office Supplies 2,000.00 131.93 591.19 29.56 1,408.81 101-4-2410-4212 Fuels & Lubes 4,400.00 267.09 1,930.17 43.87 2,469.83 101-4-2410-4217 Uniform Allowance 1,700.00 488.00 1,077.99 63.41 622.01 101-4-2410-4219 Operating Supplies 700.00 1,224.49 2,304.35 329.19 ( 1,604.35) TOTAL Supplies 8,800.00 2,111.51 5,903.70 67.09 2,896.30 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Public Safety 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-2410-4321 Telephone 3,200.00 0.00 391.42 12.23 2,808.58 101-4-2410-4322 Postage 250.00 89.36 176.49 70.60 73.51 101-4-2410-4331 Travel, Conferences & Schools 2,650.00 0.00 2,032.61 76.70 617.39 101-4-2410-4361 Insurance 550.00 0.00 231.50 42.09 318.50 101-4-2410-4404 Equip Repair/Maint Services 4,000.00 0.00 2,090.00 52.25 1,910.00 101-4-2410-4433 Dues & Subscriptions 600.00 0.00 235.00 39.17 365.00 101-4-2410-4460 Equip Replacement Charge 4,000.00 333.34 2,333.38 58.33 1,666.62 TOTAL Other Services & Charges 15,250.00 422.70 7,490.40 49.12 7,759.60 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Safety 513,500.00 35,638.86 294,846.00 57.42 218,654.00 Code Enforcement ================ Personal Services 101-4-2420-4101 Regular Pay 76,100.00 5,852.80 42,140.16 55.37 33,959.84 101-4-2420-4103 Part-time Pay 16,200.00 0.00 0.00 0.00 16,200.00 101-4-2420-4104 PERA 5,700.00 438.96 3,160.51 55.45 2,539.49 101-4-2420-4105 FICA 5,750.00 374.78 2,705.91 47.06 3,044.09 101-4-2420-4107 Medicare 1,350.00 87.65 632.84 46.88 717.16 101-4-2420-4108 Insurance 3,700.00 302.26 2,115.82 57.18 1,584.18 101-4-2420-4109 Workers Comp 300.00 0.00 195.75 65.25 104.25 TOTAL Personal Services 109,100.00 7,056.45 50,950.99 46.70 58,149.01 Supplies 101-4-2420-4212 Fuels & Lubes 1,600.00 130.72 694.71 43.42 905.29 101-4-2420-4217 Uniform Allowance 350.00 0.00 131.00 37.43 219.00 101-4-2420-4219 Operating Supplies 600.00 0.00 248.84 41.47 351.16 TOTAL Supplies 2,550.00 130.72 1,074.55 42.14 1,475.45 Other Services & Charges 101-4-2420-4321 Telephone 850.00 0.00 54.59 6.42 795.41 101-4-2420-4322 Postage 1,200.00 216.48 466.23 38.85 733.77 101-4-2420-4331 Travel, Conferences & Schools 800.00 0.00 480.00 60.00 320.00 101-4-2420-4361 Insurance 200.00 0.00 84.00 42.00 116.00 101-4-2420-4460 Equip Replacement Charge 1,000.00 83.34 583.38 58.34 416.62 TOTAL Other Services & Charges 4,050.00 299.82 1,668.20 41.19 2,381.80 ___________________________________________________________________________________________________________________ TOTAL Code Enforcement 115,700.00 7,486.99 53,693.74 46.41 62,006.26 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Public Safety 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Environmental ============= Personal Services 101-4-2440-4101 Regular Pay 21,050.00 1,651.79 11,460.21 54.44 9,589.79 101-4-2440-4104 PERA 1,600.00 123.89 863.67 53.98 736.33 101-4-2440-4105 FICA 1,300.00 102.62 715.39 55.03 584.61 101-4-2440-4107 Medicare 300.00 24.00 167.32 55.77 132.68 101-4-2440-4108 Insurance 2,200.00 183.14 1,282.05 58.28 917.95 101-4-2440-4109 Workers Comp 300.00 0.00 180.00 60.00 120.00 TOTAL Personal Services 26,750.00 2,085.44 14,668.64 54.84 12,081.36 Supplies 101-4-2440-4201 Office Supplies 300.00 4.52 76.54 25.51 223.46 101-4-2440-4212 Fuels & Lubes 100.00 4.42 46.68 46.68 53.32 101-4-2440-4219 Operating Supplies 350.00 0.00 0.00 0.00 350.00 TOTAL Supplies 750.00 8.94 123.22 16.43 626.78 Other Services & Charges 101-4-2440-4321 Telephone 350.00 0.00 180.00 51.43 170.00 101-4-2440-4322 Postage 500.00 135.81 249.86 49.97 250.14 101-4-2440-4331 Travel, Conferences & Schools 1,400.00 0.00 420.00 30.00 980.00 101-4-2440-4359 Publishing 1,000.00 948.00 1,476.00 147.60 ( 476.00) 101-4-2440-4409 Contractual Services 1,500.00 504.00 693.00 46.20 807.00 101-4-2440-4433 Dues & Subscriptions 200.00 0.00 0.00 0.00 200.00 TOTAL Other Services & Charges 4,950.00 1,587.81 3,018.86 60.99 1,931.14 ___________________________________________________________________________________________________________________ TOTAL Environmental 32,450.00 3,682.19 17,810.72 54.89 14,639.28 ___________________________________________________________________________________________________________________ TOTAL Public Safety 7,872,200.00 566,034.91 3,988,890.75 50.67 3,883,309.25 Street Maintenance ================== Personal Services 101-4-3120-4101 Regular Pay 556,900.00 46,263.15 283,483.69 50.90 273,416.31 101-4-3120-4102 Overtime Pay 4,000.00 794.81 2,970.28 74.26 1,029.72 101-4-3120-4103 Part-time Pay 74,550.00 5,202.60 37,320.00 50.06 37,230.00 101-4-3120-4104 PERA 46,500.00 3,851.50 22,061.22 47.44 24,438.78 101-4-3120-4105 FICA 39,450.00 3,289.85 19,094.82 48.40 20,355.18 101-4-3120-4107 Medicare 9,300.00 769.39 4,465.67 48.02 4,834.33 101-4-3120-4108 Insurance 93,500.00 9,050.25 42,659.73 45.63 50,840.27 101-4-3120-4109 Workers Comp 35,500.00 0.00 25,749.00 72.53 9,751.00 101-4-3120-4110 Re-employment Compensation 0.00 0.00 4,191.46 0.00 ( 4,191.46) TOTAL Personal Services 859,700.00 69,221.55 441,995.87 51.41 417,704.13 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Public Works 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-3120-4201 Office Supplies 2,500.00 4.52 2,149.20 85.97 350.80 101-4-3120-4212 Fuels & Lubes 61,300.00 ( 18,143.66) 10,085.25 16.45 51,214.75 101-4-3120-4217 Uniform Allowance 6,650.00 2,541.74 5,857.50 88.08 792.50 101-4-3120-4219 Operating Supplies 59,500.00 12,052.42 39,214.07 65.91 20,285.93 101-4-3120-4221 Equipment Parts 53,000.00 8,933.18 45,940.02 86.68 7,059.98 101-4-3120-4226 Street Signs 32,500.00 1,720.10 10,794.81 33.21 21,705.19 TOTAL Supplies 215,450.00 7,108.30 114,040.85 52.93 101,409.15 Other Services & Charges 101-4-3120-4319 Other Professional Services 300.00 0.00 126.50 42.17 173.50 101-4-3120-4321 Telephone 7,300.00 126.57 1,770.30 24.25 5,529.70 101-4-3120-4322 Postage 100.00 5.25 113.95 113.95 ( 13.95) 101-4-3120-4331 Travel, Conferences & Schools 4,400.00 0.00 1,865.86 42.41 2,534.14 101-4-3120-4359 Publishing 200.00 0.00 82.00 41.00 118.00 101-4-3120-4361 Insurance 14,400.00 0.00 6,980.00 48.47 7,420.00 101-4-3120-4389 Utilities 89,700.00 4,265.24 34,249.45 38.18 55,450.55 101-4-3120-4401 Bldg Repair/Maint Services 26,250.00 3,209.90 17,282.29 65.84 8,967.71 101-4-3120-4404 Equip Repair/Maint Services 9,000.00 2,023.22 9,860.13 109.56 ( 860.13) 101-4-3120-4409 Contractual Services 72,500.00 769.18 6,713.52 9.26 65,786.48 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 402.50 115.00 ( 52.50) 101-4-3120-4437 Taxes & Licenses 500.00 0.00 0.00 0.00 500.00 101-4-3120-4460 Equip Replacement Charge 116,000.00 9,666.67 67,666.69 58.33 48,333.31 TOTAL Other Services & Charges 343,000.00 20,066.03 147,113.19 42.89 195,886.81 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Street Maintenance 1,418,150.00 96,395.88 703,149.91 49.58 715,000.09 Snow Removal ============ Personal Services 101-4-3130-4101 Regular Pay 109,300.00 0.00 67,008.49 61.31 42,291.51 101-4-3130-4102 Overtime Pay 20,000.00 0.00 55,971.77 279.86 ( 35,971.77) 101-4-3130-4103 Part-time Pay 0.00 0.00 2,040.00 0.00 ( 2,040.00) 101-4-3130-4104 PERA 9,450.00 0.00 9,314.68 98.57 135.32 101-4-3130-4105 FICA 8,000.00 0.00 7,798.92 97.49 201.08 101-4-3130-4107 Medicare 1,900.00 0.00 1,848.52 97.29 51.48 101-4-3130-4108 Insurance 14,950.00 0.00 9,367.52 62.66 5,582.48 101-4-3130-4109 Workers Comp 7,700.00 0.00 5,503.50 71.47 2,196.50 TOTAL Personal Services 171,300.00 0.00 158,853.40 92.73 12,446.60 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Public Works 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-3130-4219 Operating Supplies 108,300.00 0.00 70,351.45 64.96 37,948.55 TOTAL Supplies 108,300.00 0.00 70,351.45 64.96 37,948.55 Other Services & Charge s _____________ _____________ _____________ _______ _____________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Snow Removal 279,600.00 0.00 229,204.85 81.98 50,395.15 Equipment Services ================== Personal Services 101-4-3150-4101 Regular Pay 132,500.00 7,544.80 62,842.41 47.43 69,657.59 101-4-3150-4102 Overtime Pay 1,000.00 24.82 1,792.45 179.25 ( 792.45) 101-4-3150-4104 PERA 10,050.00 567.72 4,134.72 41.14 5,915.28 101-4-3150-4105 FICA 8,300.00 515.36 3,932.20 47.38 4,367.80 101-4-3150-4107 Medicare 1,950.00 120.53 919.60 47.16 1,030.40 101-4-3150-4108 Insurance 21,400.00 1,169.50 10,018.00 46.81 11,382.00 101-4-3150-4109 Workers Comp 3,350.00 0.00 2,404.50 71.78 945.50 TOTAL Personal Services 178,550.00 9,942.73 86,043.88 48.19 92,506.12 Supplies 101-4-3150-4212 Fuels & Lubes 8,000.00 905.20 7,701.88 96.27 298.12 101-4-3150-4217 Uniform Allowance 1,250.00 938.00 1,562.00 124.96 ( 312.00) 101-4-3150-4219 Operating Supplies 10,100.00 1,380.21 6,619.15 65.54 3,480.85 101-4-3150-4221 Equipment Parts 3,500.00 ( 6,639.94)( 2,660.04) 76.00- 6,160.04 TOTAL Supplies 22,850.00 ( 3,416.53) 13,222.99 57.87 9,627.01 Other Services & Charges 101-4-3150-4331 Travel, Conferences & Schools 1,500.00 0.00 258.07 17.20 1,241.93 101-4-3150-4404 Equip Repair/Maint Services 18,500.00 794.03 4,006.86 21.66 14,493.14 TOTAL Other Services & Charges 20,000.00 794.03 4,264.93 21.32 15,735.07 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Equipment Services 221,400.00 7,320.23 103,531.80 46.76 117,868.20 Engineering =========== 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Public Works 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Services 101-4-3300-4101 Regular Pay 278,100.00 22,262.93 127,572.50 45.87 150,527.50 101-4-3300-4102 Overtime Pay 0.00 49.72 472.39 0.00 ( 472.39) 101-4-3300-4104 PERA 20,850.00 1,673.46 9,603.40 46.06 11,246.60 101-4-3300-4105 FICA 17,250.00 1,389.84 8,023.15 46.51 9,226.85 101-4-3300-4107 Medicare 4,050.00 325.05 1,876.38 46.33 2,173.62 101-4-3300-4108 Insurance 23,350.00 1,525.50 7,626.00 32.66 15,724.00 101-4-3300-4109 Workers Comp 1,050.00 0.00 734.50 69.95 315.50 TOTAL Personal Services 344,650.00 27,226.50 155,908.32 45.24 188,741.68 Supplies 101-4-3300-4201 Office Supplies 150.00 40.05 170.44 113.63 ( 20.44) 101-4-3300-4212 Fuels & Lubes 1,000.00 100.04 462.19 46.22 537.81 101-4-3300-4219 Operating Supplies 3,500.00 750.22 4,550.42 130.01 ( 1,050.42) TOTAL Supplies 4,650.00 890.31 5,183.05 111.46 ( 533.05) Other Services & Charges 101-4-3300-4319 Other Professional Services 3,000.00 1,600.00 3,734.10 124.47 ( 734.10) 101-4-3300-4321 Telephone 1,450.00 0.00 245.84 16.95 1,204.16 101-4-3300-4322 Postage 200.00 343.88 362.08 181.04 ( 162.08) 101-4-3300-4331 Travel, Conferences & Schools 2,150.00 0.00 1,639.68 76.26 510.32 101-4-3300-4361 Insurance 150.00 0.00 66.00 44.00 84.00 101-4-3300-4404 Equip Repair/Maint Services 500.00 0.00 186.33 37.27 313.67 101-4-3300-4460 Equip Replacement Charge 1,000.00 83.34 583.38 58.34 416.62 TOTAL Other Services & Charges 8,450.00 2,027.22 6,817.41 80.68 1,632.59 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Engineering 357,750.00 30,144.03 167,908.78 46.93 189,841.22 ___________________________________________________________________________________________________________________ TOTAL Public Works 2,276,900.00 133,860.14 1,203,795.34 52.87 1,073,104.66 Parks Department ================ Personal Services 101-4-5110-4101 Regular Pay 431,050.00 32,578.60 232,770.63 54.00 198,279.37 101-4-5110-4102 Overtime Pay 6,500.00 998.09 6,107.08 93.96 392.92 101-4-5110-4103 Part-time Pay 70,000.00 15,058.31 35,635.73 50.91 34,364.27 101-4-5110-4104 PERA 32,850.00 3,815.12 18,769.93 57.14 14,080.07 101-4-5110-4105 FICA 30,850.00 3,034.69 16,624.24 53.89 14,225.76 101-4-5110-4107 Medicare 7,250.00 709.75 3,863.65 53.29 3,386.35 101-4-5110-4108 Insurance 83,600.00 5,992.09 42,002.49 50.24 41,597.51 101-4-5110-4109 Workers Comp 17,000.00 0.00 12,190.50 71.71 4,809.50 101-4-5110-4110 Re-employment Compensation 0.00 0.00 233.96 0.00 ( 233.96) TOTAL Personal Services 679,100.00 62,186.65 368,198.21 54.22 310,901.79 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Culture & Recreation 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-5110-4212 Fuels & Lubes 33,050.00 3,340.98 14,030.23 42.45 19,019.77 101-4-5110-4217 Uniform Allowance 5,050.00 1,481.96 3,982.57 78.86 1,067.43 101-4-5110-4219 Operating Supplies 108,150.00 7,975.44 44,187.48 40.86 63,962.52 101-4-5110-4221 Equipment Parts 28,000.00 3,173.17 14,227.90 50.81 13,772.10 TOTAL Supplies 174,250.00 15,971.55 76,428.18 43.86 97,821.82 Other Services & Charges 101-4-5110-4321 Telephone 3,700.00 123.91 980.26 26.49 2,719.74 101-4-5110-4322 Postage 100.00 0.00 0.00 0.00 100.00 101-4-5110-4331 Travel, Conferences & Schools 4,350.00 0.00 3,953.28 90.88 396.72 101-4-5110-4361 Insurance 33,400.00 0.00 16,244.00 48.63 17,156.00 101-4-5110-4389 Utilities 84,500.00 13,383.13 35,706.52 42.26 48,793.48 101-4-5110-4401 Bldg Repair/Maint Services 4,000.00 0.00 300.00 7.50 3,700.00 101-4-5110-4404 Equip Repair/Maint Services 18,000.00 881.61 21,586.24 119.92 ( 3,586.24) 101-4-5110-4409 Contractual Services 59,700.00 12,827.44 26,610.61 44.57 33,089.39 101-4-5110-4415 Equipment Rental 29,500.00 3,063.45 9,398.49 31.86 20,101.51 101-4-5110-4460 Equip Replacement Charge 57,000.00 4,750.00 33,250.00 58.33 23,750.00 TOTAL Other Services & Charges 294,250.00 35,029.54 148,029.40 50.31 146,220.60 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks Department 1,147,600.00 113,187.74 592,655.79 51.64 554,944.21 Parks & Rec Admin ================= Personal Services 101-4-5210-4101 Regular Pay 337,050.00 26,386.85 184,353.44 54.70 152,696.56 101-4-5210-4103 Part-time Pay 102,250.00 8,742.00 57,613.06 56.35 44,636.94 101-4-5210-4104 PERA 32,950.00 1,337.77 16,850.53 51.14 16,099.47 101-4-5210-4105 FICA 27,250.00 2,076.49 14,247.74 52.29 13,002.26 101-4-5210-4107 Medicare 6,400.00 485.64 3,332.14 52.06 3,067.86 101-4-5210-4108 Insurance 64,950.00 5,411.30 37,879.10 58.32 27,070.90 101-4-5210-4109 Workers Comp 3,600.00 0.00 2,586.00 71.83 1,014.00 TOTAL Personal Services 574,450.00 44,440.05 316,862.01 55.16 257,587.99 Supplies 101-4-5210-4219 Operating Supplies 7,800.00 186.38 2,273.09 29.14 5,526.91 TOTAL Supplies 7,800.00 186.38 2,273.09 29.14 5,526.91 Other Services & Charges 101-4-5210-4321 Telephone 3,450.00 0.00 926.17 26.85 2,523.83 101-4-5210-4322 Postage 1,000.00 125.29 273.66 27.37 726.34 101-4-5210-4331 Travel, Conferences & Schools 8,500.00 1,951.62 4,193.79 49.34 4,306.21 101-4-5210-4349 Advertising/Marketing 18,700.00 2,387.27 7,786.04 41.64 10,913.96 101-4-5210-4361 Insurance 900.00 0.00 416.00 46.22 484.00 101-4-5210-4389 Utilities 9,800.00 805.16 5,112.36 52.17 4,687.64 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Culture & Recreation 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-4-5210-4401 Bldg Repair/Maint Services 20,950.00 486.95 9,551.91 45.59 11,398.09 101-4-5210-4404 Equip Repair/Maint Services 8,800.00 0.00 8,479.73 96.36 320.27 101-4-5210-4433 Dues & Subscriptions 2,650.00 0.00 2,481.00 93.62 169.00 TOTAL Other Services & Charges 74,750.00 5,756.29 39,220.66 52.47 35,529.34 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks & Rec Admin 657,000.00 50,382.72 358,355.76 54.54 298,644.24 Recreation Programs =================== Personal Services 101-4-5220-4103 Part-time Pay 45,000.00 15,338.91 33,110.27 73.58 11,889.73 101-4-5220-4105 FICA 2,350.00 992.76 2,094.58 89.13 255.42 101-4-5220-4107 Medicare 650.00 232.18 489.88 75.37 160.12 TOTAL Personal Services 48,000.00 16,563.85 35,694.73 74.36 12,305.27 Supplies 101-4-5220-4219 Operating Supplies 20,000.00 9,747.06 12,135.47 60.68 7,864.53 TOTAL Supplies 20,000.00 9,747.06 12,135.47 60.68 7,864.53 Other Services & Charges 101-4-5220-4409 Contractual Services 62,000.00 12,333.00 27,574.50 44.48 34,425.50 101-4-5220-4412 Building Rent 1,400.00 0.00 1,098.00 78.43 302.00 101-4-5220-4438 Credit Card Fees 3,600.00 375.97 2,542.27 70.62 1,057.73 TOTAL Other Services & Charges 67,000.00 12,708.97 31,214.77 46.59 35,785.23 ___________________________________________________________________________________________________________________ TOTAL Recreation Programs 135,000.00 39,019.88 79,044.97 58.55 55,955.03 Farmers Market ============== Supplies 101-4-5230-4219 Operating Supplies 0.00 2,234.13 3,417.24 0.00 ( 3,417.24) TOTAL Supplies 0.00 2,234.13 3,417.24 0.00 ( 3,417.24) Other Services & Charges 101-4-5230-4409 Contractual Services 0.00 340.00 765.00 0.00 ( 765.00) 101-4-5230-4438 Credit Card Fees 0.00 80.97 223.21 0.00 ( 223.21) TOTAL Other Services & Charges 0.00 420.97 988.21 0.00 ( 988.21) ___________________________________________________________________________________________________________________ TOTAL Farmers Market 0.00 2,655.10 4,405.45 0.00 ( 4,405.45) 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Culture & Recreation 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Sr Citizen Programs =================== Personal Services 101-4-5510-4101 Regular Pay 128,300.00 5,161.39 36,850.23 28.72 91,449.77 101-4-5510-4103 Part-time Pay 10,550.00 2,603.25 15,452.25 146.47 ( 4,902.25) 101-4-5510-4104 PERA 10,400.00 387.10 2,763.75 26.57 7,636.25 101-4-5510-4105 FICA 8,600.00 500.00 3,349.70 38.95 5,250.30 101-4-5510-4107 Medicare 2,000.00 116.92 783.39 39.17 1,216.61 101-4-5510-4108 Insurance 11,000.00 304.50 2,131.50 19.38 8,868.50 101-4-5510-4109 Workers Comp 700.00 0.00 250.50 35.79 449.50 TOTAL Personal Services 171,550.00 9,073.16 61,581.32 35.90 109,968.68 Supplies 101-4-5510-4219 Operating Supplies 10,900.00 1,413.08 5,962.16 54.70 4,937.84 TOTAL Supplies 10,900.00 1,413.08 5,962.16 54.70 4,937.84 Other Services & Charges 101-4-5510-4321 Telephone 1,400.00 95.84 653.32 46.67 746.68 101-4-5510-4322 Postage 2,200.00 8.57 881.66 40.08 1,318.34 101-4-5510-4331 Travel, Conferences & Schools 2,050.00 21.87 566.21 27.62 1,483.79 101-4-5510-4361 Insurance 1,250.00 0.00 586.00 46.88 664.00 101-4-5510-4389 Utilities 22,650.00 2,925.41 11,865.37 52.39 10,784.63 101-4-5510-4401 Bldg Repair/Maint Services 24,850.00 1,676.04 10,207.08 41.07 14,642.92 101-4-5510-4409 Contractual Services 12,700.00 4,322.08 13,697.51 107.85 ( 997.51) 101-4-5510-4433 Dues & Subscriptions 850.00 58.24 379.78 44.68 470.22 TOTAL Other Services & Charges 67,950.00 9,108.05 38,836.93 57.16 29,113.07 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Sr Citizen Programs 250,400.00 19,594.29 106,380.41 42.48 144,019.59 ___________________________________________________________________________________________________________________ TOTAL Culture & Recreation 2,190,000.00 224,839.73 1,140,842.38 52.09 1,049,157.62 Economic Development ==================== Personal Services 101-4-6210-4101 Regular Pay 0.00 ( 2,256.45) 18,369.93 0.00 ( 18,369.93) 101-4-6210-4103 Part-time Pay 0.00 0.00 900.00 0.00 ( 900.00) 101-4-6210-4104 PERA 0.00 ( 169.23) 1,392.75 0.00 ( 1,392.75) 101-4-6210-4105 FICA 0.00 ( 131.04) 1,137.30 0.00 ( 1,137.30) 101-4-6210-4107 Medicare 0.00 ( 30.62) 270.32 0.00 ( 270.32) 101-4-6210-4108 Insurance 0.00 0.00 3,102.40 0.00 ( 3,102.40) 101-4-6210-4109 Workers Comp 0.00 ( 76.25) 0.00 0.00 0.00 TOTAL Personal Services 0.00 ( 2,663.59) 25,172.70 0.00 ( 25,172.70) 8-13-2019 03:51 PM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: JULY 31ST, 2019 101-GENERAL FUND Economic Development 58.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-6210-4322 Postage 0.00 199.24 199.24 0.00 ( 199.24) 101-4-6210-4440 Miscellaneous 0.00 ( 114.72) 59.02 0.00 ( 59.02) TOTAL Other Services & Charges 0.00 84.52 258.26 0.00 ( 258.26) ___________________________________________________________________________________________________________________ TOTAL Economic Development 0.00 ( 2,579.07) 25,430.96 0.00 ( 25,430.96) Energy City =========== Personal Services 101-4-6220-4101 Regular Pay 21,050.00 1,651.80 11,460.31 54.44 9,589.69 101-4-6220-4104 PERA 1,600.00 123.89 857.74 53.61 742.26 101-4-6220-4105 FICA 1,300.00 102.63 710.47 54.65 589.53 101-4-6220-4107 Medicare 300.00 24.00 166.17 55.39 133.83 101-4-6220-4108 Insurance 2,200.00 183.14 1,282.03 58.27 917.97 TOTAL Personal Services 26,450.00 2,085.46 14,476.72 54.73 11,973.28 Supplies 101-4-6220-4219 Operating Supplies 1,000.00 0.00 0.00 0.00 1,000.00 TOTAL Supplies 1,000.00 0.00 0.00 0.00 1,000.00 Other Services & Charges 101-4-6220-4331 Travel, Conferences & Schools 3,000.00 26.25 163.85 5.46 2,836.15 101-4-6220-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-6220-4361 Insurance 200.00 0.00 102.00 51.00 98.00 TOTAL Other Services & Charges 3,700.00 26.25 265.85 7.19 3,434.15 ___________________________________________________________________________________________________________________ TOTAL Energy City 31,150.00 2,111.71 14,742.57 47.33 16,407.43 ___________________________________________________________________________________________________________________ TOTAL Economic Development 31,150.00 ( 467.36) 40,173.53 128.97 ( 9,023.53) Transfers Out ============= Transfers Out _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL EXPENDITURES 16,221,200.00 1,223,493.27 8,467,550.44 52.20 7,753,649.56 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 1,455,158.88 ( 226,940.53) 226,940.53 o000 00000 N V h N N N N O W ON1 ON1 q¢ N M y L � � 9 � — U — c c c 0] 0] U3 q No6 D6 =7 =7O ^LJ Q W iV O O O O O O O O N O O O r V F O bL N M V O O — On O F N — .. .. z F 121 a+ o 0 0 0 0 0 0 0 0 0 c c c �9J' h O r GO v� GO m I m? N N v N Y � v nu — " G O � T 6 S F G y 6 u n 0. O '� W O � '✓� � L ,� vi 'A vi pG U C G O O A 'O u w v y O O •+�_ C= p O ti 0 6 ti ti N 8-13-2019 03:54 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: JULY 31ST, 2019 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE __________________________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 10,756.62 1,381.96 12,138.58 101-1010 Cash - General Fund 5,839,808.29 1,356,401.80 7,196,210.09 211-1010 Cash - Library 428,742.76 1,301.06 430,043.82 221-1010 Cash - Ice Arena 633,100.31 ( 45,324.16) 587,776.15 222-1010 Cash - Pinewood Golf Course ( 9,125.53) 0.00 ( 9,125.53) 225-1010 Cash - Park Dedication 365,195.25 62,740.92 427,936.17 228-1010 Cash - Landfill 196,459.48 ( 2,140.71) 194,318.77 231-1010 Cash - Landfill Const Debris 777,178.95 0.00 777,178.95 240-1010 Cash - Micro Loan Fund 945,541.57 2,970.36 948,511.93 242-1010 Cash - State DEED 77,888.25 4,529.15 82,417.40 245-1010 Cash - Development Fund 671,247.78 14,181.48 685,429.26 290-1010 Cash - Capital Outlay Reserve 863,474.97 4,238.43 867,713.40 291-1010 Cash - Insurance Reserve 95,811.74 ( 64,156.25) 31,655.49 292-1010 Cash - Govt Bldgs Reserve 2,179,826.88 241,520.41 2,421,347.29 294-1010 Cash - Drug Forfeiture 34,045.23 ( 981.07) 33,064.16 295-1010 Cash - Severance Pay Reserve 75,930.59 0.00 75,930.59 296-1010 Cash - GRE Reserve 2,119,511.85 ( 8,176.79) 2,111,335.06 333-1010 Cash - 2010A GO Cap Imp Bonds 545,377.78 72,609.29 617,987.07 345-1010 Cash - 2012A CIP Bonds-PW ( 500.00) 0.00 ( 500.00) 401-1010 Cash - Pavement Mgmt 4,573,785.43 ( 1,004,295.18) 3,569,490.25 403-1010 Cash - Street Improvement 730,496.39 26,628.87 757,125.26 406-1010 Cash - City Wide Trunk Util 4,270,729.79 1,165.00 4,271,894.79 410-1010 Cash - Equipment Replacement 557,950.07 6,641.41 564,591.48 440-1010 Cash - Park Improvement 205,406.21 ( 10,902.70) 194,503.51 463-1010 Cash - TIF #23 Pref Powder 3,475.32 53,861.15 57,336.47 464-1010 Cash - TIF #24 Beaudry Truck ( 4,445.84)( 34,123.17)( 38,569.01) 602-1010 Cash - Wastewater Treatment 4,780,792.92 ( 35,835.31) 4,744,957.61 603-1010 Cash - Liquor 4,487,165.79 ( 324,670.86) 4,162,494.93 605-1010 Cash - Garbage 306,586.73 ( 43,664.65) 262,922.08 607-1010 Cash - Storm Water 700,880.90 466.84 701,347.74 801-1010 Cash - Interest 0.00 75,542.35 75,542.35 821-1010 Cash - Developer Escrow 641,377.34 73,580.88 714,958.22 TOTAL CLAIM ON CASH 37,104,473.82 425,490.51 37,529,964.33 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 117,455,689.76 1,662,348.44 119,118,038.20 999-1001 PY BANK ACCOUNT (108,733,405.50)( 1,236,857.93)(109,970,263.43) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 37,104,473.82 425,490.51 37,529,964.33 WAGES PAYABLE ______________ ______________ ______________ TOTAL CASH IN BANK - POOLED CASH 37,104,473.82 425,490.51 37,529,964.33 ============== ============== ==============