Loading...
INFORMATION 03-18-2019 Information �i of Memorandum Memorandum cElk River TO: Mayor and City Council From: Jesse Dorn,Assistant Finance Director Date: March 18, 2019 Subject: February 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 February, actual revenues (excluding property taxes and transfers in) and expenditures should run about 17% 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 about 3% of budget. ■ Licenses and permits are 6% of budget estimates with building permits experiencing a slump due to winter weather. ■ Charges for services are 38% of budget estimates which includes billings for the school liaison and fire services contracts. Evenditures. ■ Total departmental expenditures are 12% of budget and most departments are within or below budget estimates. ■ The Snow Removal budget reflects the seasonal expenditures for personal services and road salt. p0WIeI1 0 NAWREJ 01 2019 Monthly Expenditures $18,000 $16,000 $14,000 0 a $12,000 o $10,000 $8,000 $6,000 $4,000 $2,000 0 Actual $944 $2,009 Budget $1,352 $2,704 $4,055 $5,407 $6,759 $8,111 $9,462 $10,8141$12,166 $13,518$14,869 $16,221 ICE ARENA Through the end of February,revenues of$214,380 exceed expenditures of$104,978 by $109,402,with ice rental and Breakaway Hockey registrations making up the majority of revenues. Ice rental revenues are in line with budget estimates at 17%. ATTACHMENTS ■ General Fund Revenue &Expense Report ■ Enterprise Funds—Budget to Actual ■ Cash Report—All Funds 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND FINANCIAL SUMMARY 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ REVENUE SUMMARY General Fund 16,221,200.00 386,181.74 446,968.22 2.76 15,774,231.78 TOTAL REVENUES 16,221,200.00 386,181.74 446,968.22 2.76 15,774,231.78 ============= ============= ============= ======= ============= EXPENDITURE SUMMARY General Government Mayor & Council 149,050.00 5,154.68 18,358.45 12.32 130,691.55 Communications 326,350.00 15,680.97 29,514.38 9.04 296,835.62 Administrative Services 531,850.00 38,624.67 68,507.42 12.88 463,342.58 Human Resources 280,500.00 35,405.01 46,732.55 16.66 233,767.45 Elections 6,800.00 0.00 0.00 0.00 6,800.00 Finance 644,550.00 45,425.25 92,200.41 14.30 552,349.59 Information Technology 440,000.00 46,235.16 70,683.13 16.06 369,316.87 Legal 230,000.00 19,842.30 19,842.30 8.63 210,157.70 Community Development 162,750.00 12,376.32 21,352.33 13.12 141,397.67 Planning 352,550.00 25,643.36 43,420.76 12.32 309,129.24 Building Maintenance 714,400.00 55,573.44 94,168.38 13.18 620,231.62 Contingency 153,100.00 0.00 0.00 0.00 153,100.00 TOTAL General Government 3,991,900.00 299,961.16 504,780.11 12.65 3,487,119.89 Public Safety Police Administration 850,250.00 44,683.47 160,934.96 18.93 689,315.04 Patrol 2,878,300.00 176,521.64 316,917.26 11.01 2,561,382.74 Investigations 1,068,250.00 74,561.45 129,017.21 12.08 939,232.79 Police Support Services 770,750.00 57,291.13 98,452.10 12.77 672,297.90 Police Reserves 16,850.00 0.00 0.00 0.00 16,850.00 Public safety building 170,300.00 11,784.16 19,741.78 11.59 150,558.22 Fire Administration 715,550.00 32,302.51 66,083.89 9.24 649,466.11 Fire Operations 408,150.00 35,884.51 60,411.51 14.80 347,738.49 Emergency Management 21,800.00 1,000.23 1,166.68 5.35 20,633.32 Building Safety 721,900.00 56,286.75 97,210.72 13.47 624,689.28 Code Enforcement 115,700.00 7,999.51 13,369.70 11.56 102,330.30 Environmental 32,450.00 2,176.32 3,703.31 11.41 28,746.69 TOTAL Public Safety 7,770,250.00 500,491.68 967,009.12 12.45 6,803,240.88 Public Works Street Maintenance 1,396,750.00 47,253.79 72,366.47 5.18 1,324,383.53 Snow Removal 279,600.00 55,951.72 144,560.80 51.70 135,039.20 Equipment Services 216,300.00 13,122.92 27,930.34 12.91 188,369.66 Engineering 357,750.00 19,215.20 32,518.86 9.09 325,231.14 TOTAL Public Works 2,250,400.00 135,543.63 277,376.47 12.33 1,973,023.53 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND FINANCIAL SUMMARY 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Culture & Recreation Parks Department 1,135,100.00 61,910.14 115,860.96 10.21 1,019,239.04 Parks & Rec Admin 657,000.00 47,764.72 91,433.37 13.92 565,566.63 Recreation Programs 135,000.00 3,226.13 5,106.86 3.78 129,893.14 Concessions 0.00 260.00 100.00 0.00 ( 100.00) Sr Citizen Programs 250,400.00 10,379.37 18,538.96 7.40 231,861.04 TOTAL Culture & Recreation 2,177,500.00 123,540.36 231,040.15 10.61 1,946,459.85 Economic Development Economic Development 0.00 6,853.22 25,483.60 0.00 ( 25,483.60) Energy City 31,150.00 2,005.12 3,510.99 11.27 27,639.01 TOTAL Economic Development 31,150.00 8,858.34 28,994.59 93.08 2,155.41 General _____________ _____________ _____________ _______ _____________ TOTAL EXPENDITURES 16,221,200.00 1,068,395.17 2,009,200.44 12.39 14,211,999.56 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 682,213.43)( 1,562,232.22) 1,562,232.22 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ General Fund ============ Taxes 101-3-0000-3111 Current Ad Valorem Taxes 11,187,400.00 0.00 0.00 0.00 11,187,400.00 101-3-0000-3121 Gravel Tax 150,000.00 0.00 0.00 0.00 150,000.00 TOTAL Taxes 11,337,400.00 0.00 0.00 0.00 11,337,400.00 Licenses & Permits 101-3-0000-3211 Liquor License 75,000.00 0.00 40.00 0.05 74,960.00 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 13,276.00 16,459.00 25.32 48,541.00 101-3-0000-3216 Mining License 25,000.00 0.00 0.00 0.00 25,000.00 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 330.00 975.00 6.96 13,025.00 101-3-0000-3229 NPDES Permit 18,000.00 700.00 1,575.00 8.75 16,425.00 101-3-0000-3231 Building Permit 480,000.00 10,286.65 24,909.75 5.19 455,090.25 101-3-0000-3232 Plumbing/Heating Permit 160,000.00 81.94 4,562.96 2.85 155,437.04 101-3-0000-3233 Permit Surcharge 1,000.00 471.80 1,330.25 133.03 ( 330.25) 101-3-0000-3235 Animal License 5,000.00 0.00 400.00 8.00 4,600.00 101-3-0000-3237 Other Non-Business Lic/Permit 9,000.00 1,035.00 1,380.00 15.33 7,620.00 TOTAL Licenses & Permits 857,000.00 26,181.39 51,751.96 6.04 805,248.04 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 0.00 0.00 182,000.00 101-3-0000-3324 PERA Aid 14,000.00 0.00 0.00 0.00 14,000.00 101-3-0000-3325 Police 2% Aid 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 0.00 0.00 0.00 65,000.00 TOTAL Intergovernmental Rev 571,500.00 0.00 0.00 0.00 571,500.00 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 32,000.00 275.00 1,200.00 3.75 30,800.00 101-3-0000-3413 Plan Check Fee 200,000.00 1,857.26 11,532.12 5.77 188,467.88 101-3-0000-3415 Special Assessment Search 800.00 30.00 80.00 10.00 720.00 101-3-0000-3417 Copies 2,500.00 135.47 381.17 15.25 2,118.83 101-3-0000-3418 Other General Govt Services 1,500.00 0.00 13.00 0.87 1,487.00 101-3-0000-3430 Lockout Fees 6,000.00 440.00 960.00 16.00 5,040.00 101-3-0000-3431 Police Services 10,000.00 80.00 110.00 1.10 9,890.00 101-3-0000-3432 School Liaison 130,000.00 68,272.50 68,272.50 52.52 61,727.50 101-3-0000-3434 Animal Impound Fee 4,000.00 0.00 150.00 3.75 3,850.00 101-3-0000-3436 Fire Contracts 275,000.00 269,829.00 269,829.00 98.12 5,171.00 101-3-0000-3437 Fire Services 2,000.00 45.00 65.00 3.25 1,935.00 101-3-0000-3451 Street Services 12,000.00 330.00 705.00 5.88 11,295.00 101-3-0000-3452 Engineering Services Reimb 130,000.00 0.00 0.00 0.00 130,000.00 101-3-0000-3461 Recreation Fees 78,000.00 1,888.00 4,319.90 5.54 73,680.10 101-3-0000-3462 Sr Center Activities 44,000.00 2,607.96 6,833.01 15.53 37,166.99 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-3-0000-3463 Farmer's Market Fees 0.00 1,570.00 3,070.00 0.00 ( 3,070.00) 101-3-0000-3472 Park Use Fee 27,000.00 960.00 2,335.00 8.65 24,665.00 101-3-0000-3475 Building Rent 2,400.00 200.00 400.00 16.67 2,000.00 101-3-0000-3483 Sewer Inspection Fee 11,000.00 195.00 455.00 4.14 10,545.00 101-3-0000-3484 Contractor License Check 1,000.00 45.00 95.00 9.50 905.00 TOTAL Charges for Services 969,200.00 348,760.19 370,805.70 38.26 598,394.30 Fines & Forfeits 101-3-0000-3510 Court Fines 145,000.00 11,089.79 11,089.79 7.65 133,910.21 101-3-0000-3511 Parking Fines 9,500.00 200.00 900.00 9.47 8,600.00 TOTAL Fines & Forfeits 154,500.00 11,289.79 11,989.79 7.76 142,510.21 Special Assessments _____________ _____________ _____________ _______ _____________ Other Revenue 101-3-0000-3621 Interest Income 100,000.00 0.00 11,020.91 11.02 88,979.09 101-3-0000-3625 Refunds & Reimbursements 130,000.00 ( 50.21)( 12.62) 0.01- 130,012.62 101-3-0000-3626 Contributions 23,000.00 0.00 1,000.00 4.35 22,000.00 101-3-0000-3629 Miscellaneous Revenue 6,500.00 0.58 300.17 4.62 6,199.83 TOTAL Other Revenue 259,500.00 ( 49.63) 12,308.46 4.74 247,191.54 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 0.00 0.00 0.00 10,600.00 101-3-0000-3942 Transfer-WWTS 150,000.00 0.00 0.00 0.00 150,000.00 101-3-0000-3943 Transfer-Liquor 500,000.00 0.00 0.00 0.00 500,000.00 101-3-0000-3944 Transfer-Garbage 48,000.00 0.00 0.00 0.00 48,000.00 101-3-0000-3945 Transfer-Utilities 1,165,000.00 0.00 0.00 0.00 1,165,000.00 101-3-0000-3946 Transfer-Stormwater 15,000.00 0.00 0.00 0.00 15,000.00 101-3-0000-3948 Transfer-EDA 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 0.00 112.31 0.01 2,071,987.69 _____________________________________________________________________________ TOTAL General Fund 16,221,200.00 386,181.74 446,968.22 2.76 15,774,231.78 ___________________________________________________________________________________________________________________ TOTAL REVENUE 16,221,200.00 386,181.74 446,968.22 2.76 15,774,231.78 ============= ============= ============= ======= ============= 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Mayor & Council =============== Personal Services 101-4-1110-4103 Part-time Pay 38,500.00 3,208.36 6,416.68 16.67 32,083.32 101-4-1110-4104 PERA 1,300.00 100.01 200.02 15.39 1,099.98 101-4-1110-4105 FICA 1,000.00 74.92 149.84 14.98 850.16 101-4-1110-4107 Medicare 600.00 46.53 93.05 15.51 506.95 101-4-1110-4109 Workers Comp 100.00 0.00 12.00 12.00 88.00 TOTAL Personal Services 41,500.00 3,429.82 6,871.59 16.56 34,628.41 Supplies 101-4-1110-4201 Office Supplies 700.00 33.42 33.42 4.77 666.58 TOTAL Supplies 700.00 33.42 33.42 4.77 666.58 Other Services & Charges 101-4-1110-4319 Other Professional Services 10,500.00 950.00 950.00 9.05 9,550.00 101-4-1110-4322 Postage 50.00 66.82 66.82 133.64 ( 16.82) 101-4-1110-4331 Travel, Conferences & Schools 2,600.00 225.00 225.00 8.65 2,375.00 101-4-1110-4359 Publishing 3,700.00 0.00 0.00 0.00 3,700.00 101-4-1110-4361 Insurance 40,000.00 0.00 9,762.00 24.41 30,238.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 449.62 449.62 1.48 30,000.38 TOTAL Other Services & Charges 106,850.00 1,691.44 11,453.44 10.72 95,396.56 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Mayor & Council 149,050.00 5,154.68 18,358.45 12.32 130,691.55 Communications ============== Personal Services 101-4-1120-4101 Regular Pay 203,450.00 10,567.78 17,965.23 8.83 185,484.77 101-4-1120-4103 Part-time Pay 19,400.00 791.82 1,311.73 6.76 18,088.27 101-4-1120-4104 PERA 17,300.00 851.96 1,445.76 8.36 15,854.24 101-4-1120-4105 FICA 13,800.00 675.43 1,146.11 8.31 12,653.89 101-4-1120-4107 Medicare 3,250.00 157.96 268.03 8.25 2,981.97 101-4-1120-4108 Insurance 30,550.00 2,241.00 4,482.00 14.67 26,068.00 101-4-1120-4109 Workers Comp 1,000.00 0.00 226.50 22.65 773.50 TOTAL Personal Services 288,750.00 15,285.95 26,845.36 9.30 261,904.64 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND General Government 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1120-4201 Office Supplies 4,500.00 2.42 2.42 0.05 4,497.58 TOTAL Supplies 4,500.00 2.42 2.42 0.05 4,497.58 Other Services & Charges 101-4-1120-4319 Other Professional Services 21,800.00 16.00 2,290.00 10.50 19,510.00 101-4-1120-4321 Telephone 1,300.00 0.00 0.00 0.00 1,300.00 101-4-1120-4331 Travel, Conferences & Schools 8,650.00 376.60 376.60 4.35 8,273.40 101-4-1120-4433 Dues & Subscriptions 1,350.00 0.00 0.00 0.00 1,350.00 TOTAL Other Services & Charges 33,100.00 392.60 2,666.60 8.06 30,433.40 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Communications 326,350.00 15,680.97 29,514.38 9.04 296,835.62 Administrative Services ======================= Personal Services 101-4-1210-4101 Regular Pay 354,700.00 26,866.96 45,673.82 12.88 309,026.18 101-4-1210-4103 Part-time Pay 56,100.00 3,952.71 6,717.52 11.97 49,382.48 101-4-1210-4104 PERA 30,800.00 2,311.47 3,929.35 12.76 26,870.65 101-4-1210-4105 FICA 25,500.00 1,928.09 3,277.64 12.85 22,222.36 101-4-1210-4107 Medicare 6,000.00 450.95 766.56 12.78 5,233.44 101-4-1210-4108 Insurance 22,000.00 1,830.00 3,660.00 16.64 18,340.00 101-4-1210-4109 Workers Comp 2,000.00 0.00 461.25 23.06 1,538.75 TOTAL Personal Services 497,100.00 37,340.18 64,486.14 12.97 432,613.86 Supplies 101-4-1210-4201 Office Supplies 5,300.00 210.38 1,115.27 21.04 4,184.73 TOTAL Supplies 5,300.00 210.38 1,115.27 21.04 4,184.73 Other Services & Charges 101-4-1210-4321 Telephone 900.00 34.23 34.23 3.80 865.77 101-4-1210-4322 Postage 800.00 319.88 319.88 39.99 480.12 101-4-1210-4331 Travel, Conferences & Schools 5,250.00 0.00 6.60 0.13 5,243.40 101-4-1210-4334 Car Allowance 4,800.00 400.00 800.00 16.67 4,000.00 101-4-1210-4361 Insurance 100.00 0.00 16.00 16.00 84.00 101-4-1210-4404 Equip Repair/Maint Services 15,350.00 0.00 1,409.30 9.18 13,940.70 101-4-1210-4433 Dues & Subscriptions 2,250.00 320.00 320.00 14.22 1,930.00 TOTAL Other Services & Charges 29,450.00 1,074.11 2,906.01 9.87 26,543.99 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Administrative Services 531,850.00 38,624.67 68,507.42 12.88 463,342.58 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND General Government 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Human Resources =============== Personal Services 101-4-1220-4101 Regular Pay 152,800.00 11,469.17 19,497.59 12.76 133,302.41 101-4-1220-4104 PERA 11,450.00 860.18 1,462.31 12.77 9,987.69 101-4-1220-4105 FICA 9,500.00 692.82 1,177.79 12.40 8,322.21 101-4-1220-4107 Medicare 2,200.00 162.03 275.45 12.52 1,924.55 101-4-1220-4108 Insurance 14,750.00 1,780.00 3,560.00 24.14 11,190.00 101-4-1220-4109 Workers Comp 750.00 0.00 171.50 22.87 578.50 TOTAL Personal Services 191,450.00 14,964.20 26,144.64 13.66 165,305.36 Supplies 101-4-1220-4201 Office Supplies 6,200.00 16.97 66.12 1.07 6,133.88 TOTAL Supplies 6,200.00 16.97 66.12 1.07 6,133.88 Other Services & Charges 101-4-1220-4319 Other Professional Services 4,150.00 250.00 347.95 8.38 3,802.05 101-4-1220-4322 Postage 300.00 82.84 82.84 27.61 217.16 101-4-1220-4331 Travel, Conferences & Schools 6,200.00 429.00 429.00 6.92 5,771.00 101-4-1220-4404 Equip Repair/Maint 72,000.00 19,447.00 19,447.00 27.01 52,553.00 101-4-1220-4433 Dues & Subscriptions 200.00 215.00 215.00 107.50 ( 15.00) TOTAL Other Services & Charges 82,850.00 20,423.84 20,521.79 24.77 62,328.21 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Human Resources 280,500.00 35,405.01 46,732.55 16.66 233,767.45 Elections ========= Personal Service s _____________ _____________ _____________ _______ _____________ Supplies _____________ _____________ _____________ _______ _____________ Other Services & Charges 101-4-1230-4404 Equip Repair/Maint Services 6,800.00 0.00 0.00 0.00 6,800.00 TOTAL Other Services & Charges 6,800.00 0.00 0.00 0.00 6,800.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Elections 6,800.00 0.00 0.00 0.00 6,800.00 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND General Government 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Finance ======= Personal Services 101-4-1310-4101 Regular Pay 348,800.00 26,315.04 44,735.57 12.83 304,064.43 101-4-1310-4103 Part-time Pay 57,700.00 4,235.52 7,956.82 13.79 49,743.18 101-4-1310-4104 PERA 30,500.00 2,291.29 3,951.93 12.96 26,548.07 101-4-1310-4105 FICA 25,200.00 1,803.47 3,112.80 12.35 22,087.20 101-4-1310-4107 Medicare 5,900.00 421.78 728.00 12.34 5,172.00 101-4-1310-4108 Insurance 59,950.00 4,995.30 9,990.60 16.66 49,959.40 101-4-1310-4109 Workers Comp 2,000.00 0.00 456.25 22.81 1,543.75 TOTAL Personal Services 530,050.00 40,062.40 70,931.97 13.38 459,118.03 Supplies 101-4-1310-4201 Office Supplies 4,100.00 31.24 31.24 0.76 4,068.76 TOTAL Supplies 4,100.00 31.24 31.24 0.76 4,068.76 Other Services & Charges 101-4-1310-4301 Audit Fees 16,000.00 2,750.00 2,750.00 17.19 13,250.00 101-4-1310-4319 Other Professional Services 56,000.00 0.00 0.00 0.00 56,000.00 101-4-1310-4321 Telephone 900.00 39.23 39.23 4.36 860.77 101-4-1310-4322 Postage 2,900.00 1,039.97 1,039.97 35.86 1,860.03 101-4-1310-4331 Travel, Conferences & Schools 4,400.00 776.60 776.60 17.65 3,623.40 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 15,075.85 81.05 3,524.15 101-4-1310-4433 Dues & Subscriptions 1,600.00 50.00 50.00 3.13 1,550.00 101-4-1310-4438 Credit Card Fees 8,500.00 588.51 1,317.75 15.50 7,182.25 101-4-1310-4440 Miscellaneous 1,300.00 87.30 187.80 14.45 1,112.20 TOTAL Other Services & Charges 110,400.00 5,331.61 21,237.20 19.24 89,162.80 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Finance 644,550.00 45,425.25 92,200.41 14.30 552,349.59 Information Technology ====================== Personal Services 101-4-1350-4101 Regular Pay 223,900.00 17,064.32 29,009.34 12.96 194,890.66 101-4-1350-4104 PERA 16,800.00 1,279.82 2,175.69 12.95 14,624.31 101-4-1350-4105 FICA 13,900.00 1,028.61 1,748.63 12.58 12,151.37 101-4-1350-4107 Medicare 3,250.00 240.56 408.95 12.58 2,841.05 101-4-1350-4108 Insurance 25,050.00 3,077.26 6,154.52 24.57 18,895.48 101-4-1350-4109 Workers Comp 1,100.00 0.00 251.25 22.84 848.75 TOTAL Personal Services 284,000.00 22,690.57 39,748.38 14.00 244,251.62 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND General Government 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1350-4219 Operating Supplies 14,300.00 10.73 45.88 0.32 14,254.12 TOTAL Supplies 14,300.00 10.73 45.88 0.32 14,254.12 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 0.00 0.00 0.00 8,000.00 101-4-1350-4321 Telephone 2,200.00 247.18 247.18 11.24 1,952.82 101-4-1350-4331 Travel, Conferences & Schools 9,750.00 0.00 24.00 0.25 9,726.00 101-4-1350-4404 Equip Repair/Maint Services 121,750.00 23,286.68 30,617.69 25.15 91,132.31 TOTAL Other Services & Charges 141,700.00 23,533.86 30,888.87 21.80 110,811.13 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Information Technology 440,000.00 46,235.16 70,683.13 16.06 369,316.87 Legal ===== Other Services & Charges 101-4-1400-4304 Legal Fees 230,000.00 19,842.30 19,842.30 8.63 210,157.70 TOTAL Other Services & Charges 230,000.00 19,842.30 19,842.30 8.63 210,157.70 ___________________________________________________________________________________________________________________ TOTAL Legal 230,000.00 19,842.30 19,842.30 8.63 210,157.70 Community Development ===================== Personal Services 101-4-1500-4101 Regular Pay 125,400.00 9,523.54 16,190.02 12.91 109,209.98 101-4-1500-4104 PERA 9,400.00 714.26 1,214.24 12.92 8,185.76 101-4-1500-4105 FICA 7,800.00 578.10 982.76 12.60 6,817.24 101-4-1500-4107 Medicare 1,850.00 135.20 229.84 12.42 1,620.16 101-4-1500-4108 Insurance 14,000.00 1,169.50 2,339.00 16.71 11,661.00 101-4-1500-4109 Workers Comp 600.00 0.00 140.75 23.46 459.25 TOTAL Personal Services 159,050.00 12,120.60 21,096.61 13.26 137,953.39 Supplies 101-4-1500-4201 Office Supplies 500.00 16.97 16.97 3.39 483.03 TOTAL Supplies 500.00 16.97 16.97 3.39 483.03 Other Services & Charges 101-4-1500-4321 Telephone 800.00 38.75 38.75 4.84 761.25 101-4-1500-4331 Travel, Conferences & Schools 1,850.00 0.00 0.00 0.00 1,850.00 101-4-1500-4433 Dues & Subscriptions 550.00 200.00 200.00 36.36 350.00 TOTAL Other Services & Charges 3,200.00 238.75 238.75 7.46 2,961.25 ___________________________________________________________________________________________________________________ TOTAL Community Development 162,750.00 12,376.32 21,352.33 13.12 141,397.67 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND General Government 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Planning ======== Personal Services 101-4-1510-4101 Regular Pay 246,100.00 18,645.47 31,697.30 12.88 214,402.70 101-4-1510-4103 Part-time Pay 15,600.00 0.00 0.00 0.00 15,600.00 101-4-1510-4104 PERA 19,650.00 1,398.40 2,377.28 12.10 17,272.72 101-4-1510-4105 FICA 16,250.00 1,137.15 1,933.16 11.90 14,316.84 101-4-1510-4107 Medicare 3,800.00 265.93 452.11 11.90 3,347.89 101-4-1510-4108 Insurance 30,250.00 2,520.50 5,041.00 16.66 25,209.00 101-4-1510-4109 Workers Comp 950.00 0.00 228.00 24.00 722.00 TOTAL Personal Services 332,600.00 23,967.45 41,728.85 12.55 290,871.15 Supplies 101-4-1510-4201 Office Supplies 2,050.00 68.46 68.46 3.34 1,981.54 101-4-1510-4212 Fuels & Lubes 50.00 0.00 0.00 0.00 50.00 TOTAL Supplies 2,100.00 68.46 68.46 3.26 2,031.54 Other Services & Charges 101-4-1510-4321 Telephone 350.00 0.00 0.00 0.00 350.00 101-4-1510-4322 Postage 1,500.00 267.45 267.45 17.83 1,232.55 101-4-1510-4331 Travel, Conferences & Schools 3,400.00 0.00 0.00 0.00 3,400.00 101-4-1510-4359 Publishing 10,000.00 440.00 440.00 4.40 9,560.00 101-4-1510-4361 Insurance 100.00 0.00 16.00 16.00 84.00 101-4-1510-4404 Equip Repair/Maint Services 1,500.00 900.00 900.00 60.00 600.00 101-4-1510-4433 Dues & Subscriptions 500.00 0.00 0.00 0.00 500.00 101-4-1510-4440 Miscellaneous 500.00 0.00 0.00 0.00 500.00 TOTAL Other Services & Charges 17,850.00 1,607.45 1,623.45 9.09 16,226.55 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Planning 352,550.00 25,643.36 43,420.76 12.32 309,129.24 Building Maintenance ==================== Personal Services 101-4-1600-4101 Regular Pay 398,650.00 29,969.16 50,924.31 12.77 347,725.69 101-4-1600-4102 Overtime Pay 3,000.00 1,246.11 1,340.21 44.67 1,659.79 101-4-1600-4103 Part-time Pay 3,850.00 0.00 0.00 0.00 3,850.00 101-4-1600-4104 PERA 30,150.00 2,341.15 3,919.84 13.00 26,230.16 101-4-1600-4105 FICA 25,150.00 1,935.42 3,240.53 12.88 21,909.47 101-4-1600-4107 Medicare 5,900.00 452.66 757.88 12.85 5,142.12 101-4-1600-4108 Insurance 55,550.00 4,730.50 9,461.00 17.03 46,089.00 101-4-1600-4109 Workers Comp 13,800.00 0.00 3,358.25 24.34 10,441.75 TOTAL Personal Services 536,050.00 40,675.00 73,002.02 13.62 463,047.98 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND General Government 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1600-4212 Fuels & Lubes 3,000.00 0.00 337.40 11.25 2,662.60 101-4-1600-4217 Uniform Allowance 2,850.00 212.00 212.00 7.44 2,638.00 101-4-1600-4219 Operating Supplies 29,950.00 5,828.55 5,911.85 19.74 24,038.15 TOTAL Supplies 35,800.00 6,040.55 6,461.25 18.05 29,338.75 Other Services & Charges 101-4-1600-4321 Telephone 13,850.00 1,221.64 2,142.05 15.47 11,707.95 101-4-1600-4331 Travel, Conferences & Schools 1,000.00 300.00 300.00 30.00 700.00 101-4-1600-4361 Insurance 5,100.00 0.00 1,206.00 23.65 3,894.00 101-4-1600-4389 Utilities 74,050.00 3,796.84 6,665.37 9.00 67,384.63 101-4-1600-4401 Bldg Repair/Maint Services 38,550.00 913.92 1,432.86 3.72 37,117.14 101-4-1600-4404 Equip Repair/Maint Services 6,000.00 2,625.49 2,625.49 43.76 3,374.51 101-4-1600-4460 Equip Replacement Charge 4,000.00 0.00 333.34 8.33 3,666.66 TOTAL Other Services & Charges 142,550.00 8,857.89 14,705.11 10.32 127,844.89 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Maintenance 714,400.00 55,573.44 94,168.38 13.18 620,231.62 Contingency =========== Personal Services 101-4-1900-4101 Regular Pay 153,100.00 0.00 0.00 0.00 153,100.00 TOTAL Personal Services 153,100.00 0.00 0.00 0.00 153,100.00 Other Services & Charge s _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Contingency 153,100.00 0.00 0.00 0.00 153,100.00 ___________________________________________________________________________________________________________________ TOTAL General Government 3,991,900.00 299,961.16 504,780.11 12.65 3,487,119.89 Police Administration ===================== Personal Services 101-4-2110-4101 Regular Pay 413,400.00 30,781.25 52,106.61 12.60 361,293.39 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 4,799.66 8,121.87 12.55 56,578.13 101-4-2110-4105 FICA 3,800.00 290.21 493.36 12.98 3,306.64 101-4-2110-4107 Medicare 6,050.00 435.95 737.91 12.20 5,312.09 101-4-2110-4108 Insurance 34,800.00 2,899.00 5,798.00 16.66 29,002.00 101-4-2110-4109 Workers Comp 93,000.00 0.00 22,654.00 24.36 70,346.00 TOTAL Personal Services 617,250.00 39,206.07 89,911.75 14.57 527,338.25 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-2110-4201 Office Supplies 11,000.00 272.46 382.36 3.48 10,617.64 101-4-2110-4217 Uniform Allowance 3,150.00 0.00 0.00 0.00 3,150.00 101-4-2110-4219 Operating Supplies 17,500.00 36.19 36.19 0.21 17,463.81 TOTAL Supplies 31,650.00 308.65 418.55 1.32 31,231.45 Other Services & Charges 101-4-2110-4319 Other Professional Services 4,600.00 0.00 0.00 0.00 4,600.00 101-4-2110-4321 Telephone 39,800.00 3,096.04 3,366.74 8.46 36,433.26 101-4-2110-4322 Postage 1,800.00 661.71 661.71 36.76 1,138.29 101-4-2110-4331 Travel, Conferences & Schools 17,300.00 1,170.00 1,170.00 6.76 16,130.00 101-4-2110-4361 Insurance 48,500.00 0.00 11,922.00 24.58 36,578.00 101-4-2110-4404 Equip Repair/Maint Services 73,600.00 0.00 42,965.21 58.38 30,634.79 101-4-2110-4433 Dues & Subscriptions 15,550.00 190.00 10,468.00 67.32 5,082.00 101-4-2110-4437 Taxes & Licenses 200.00 51.00 51.00 25.50 149.00 TOTAL Other Services & Charges 201,350.00 5,168.75 70,604.66 35.07 130,745.34 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Administration 850,250.00 44,683.47 160,934.96 18.93 689,315.04 Patrol ====== Personal Services 101-4-2120-4101 Regular Pay 1,861,300.00 125,044.46 214,093.16 11.50 1,647,206.84 101-4-2120-4102 Overtime Pay 100,000.00 4,086.38 5,978.24 5.98 94,021.76 101-4-2120-4104 PERA 323,400.00 21,887.66 37,302.07 11.53 286,097.93 101-4-2120-4107 Medicare 27,700.00 1,840.15 3,145.88 11.36 24,554.12 101-4-2120-4108 Insurance 186,100.00 14,352.50 28,705.00 15.42 157,395.00 TOTAL Personal Services 2,498,500.00 167,211.15 289,224.35 11.58 2,209,275.65 Supplies 101-4-2120-4212 Fuels & Lubes 100,000.00 0.00 8,303.39 8.30 91,696.61 101-4-2120-4217 Uniform Allowance 24,800.00 0.00 0.00 0.00 24,800.00 101-4-2120-4219 Operating Supplies 62,850.00 1,644.82 1,644.82 2.62 61,205.18 101-4-2120-4221 Equipment Parts 31,300.00 885.92 3,545.28 11.33 27,754.72 TOTAL Supplies 218,950.00 2,530.74 13,493.49 6.16 205,456.51 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 33,350.00 6,365.00 8,510.00 25.52 24,840.00 101-4-2120-4404 Equip Repair/Maint Services 23,850.00 174.75 1,032.75 4.33 22,817.25 101-4-2120-4433 Dues & Subscriptions 650.00 240.00 240.00 36.92 410.00 101-4-2120-4440 Misc. - Grant Distribution 50,000.00 0.00 0.00 0.00 50,000.00 101-4-2120-4460 Equip Replacement Charge 53,000.00 0.00 4,416.67 8.33 48,583.33 TOTAL Other Services & Charges 160,850.00 6,779.75 14,199.42 8.83 146,650.58 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Patrol 2,878,300.00 176,521.64 316,917.26 11.01 2,561,382.74 Investigations ============== Personal Services 101-4-2130-4101 Regular Pay 726,800.00 51,833.92 87,898.88 12.09 638,901.12 101-4-2130-4102 Overtime Pay 55,000.00 2,543.88 3,771.45 6.86 51,228.55 101-4-2130-4104 PERA 132,500.00 9,190.33 15,511.44 11.71 116,988.56 101-4-2130-4105 FICA 0.00 9.78 9.78 0.00 ( 9.78) 101-4-2130-4107 Medicare 11,350.00 744.62 1,258.13 11.08 10,091.87 101-4-2130-4108 Insurance 86,450.00 8,305.94 17,217.88 19.92 69,232.12 TOTAL Personal Services 1,012,100.00 72,628.47 125,667.56 12.42 886,432.44 Supplies 101-4-2130-4217 Uniform Allowance 7,250.00 0.00 0.00 0.00 7,250.00 101-4-2130-4219 Operating Supplies 8,100.00 0.00 0.00 0.00 8,100.00 TOTAL Supplies 15,350.00 0.00 0.00 0.00 15,350.00 Other Services & Charges 101-4-2130-4319 Other Professional Services 5,000.00 0.00 0.00 0.00 5,000.00 101-4-2130-4331 Travel, Conferences & Schools 15,250.00 1,932.98 1,932.98 12.68 13,317.02 101-4-2130-4433 Dues & Subscriptions 3,550.00 0.00 0.00 0.00 3,550.00 101-4-2130-4460 Equip Replacement Charge 17,000.00 0.00 1,416.67 8.33 15,583.33 TOTAL Other Services & Charges 40,800.00 1,932.98 3,349.65 8.21 37,450.35 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Investigations 1,068,250.00 74,561.45 129,017.21 12.08 939,232.79 Police Support Services ======================= Personal Services 101-4-2150-4101 Regular Pay 494,100.00 37,330.50 63,444.87 12.84 430,655.13 101-4-2150-4102 Overtime Pay 8,500.00 0.00 61.82 0.73 8,438.18 101-4-2150-4103 Part-time Pay 49,600.00 3,659.52 6,259.30 12.62 43,340.70 101-4-2150-4104 PERA 50,700.00 3,797.71 6,449.98 12.72 44,250.02 101-4-2150-4105 FICA 28,150.00 2,022.38 3,451.30 12.26 24,698.70 101-4-2150-4107 Medicare 8,000.00 578.23 984.60 12.31 7,015.40 101-4-2150-4108 Insurance 85,700.00 7,201.00 14,402.00 16.81 71,298.00 TOTAL Personal Services 724,750.00 54,589.34 95,053.87 13.12 629,696.13 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-2150-4201 Office Supplies 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2150-4217 Uniform Allowance 5,950.00 0.00 0.00 0.00 5,950.00 101-4-2150-4219 Operating Supplies 10,000.00 1,898.51 1,911.61 19.12 8,088.39 TOTAL Supplies 16,950.00 1,898.51 1,911.61 11.28 15,038.39 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 5,000.00 0.00 0.00 0.00 5,000.00 101-4-2150-4409 Contractual Services 16,500.00 803.28 803.28 4.87 15,696.72 101-4-2150-4433 Dues & Subscriptions 550.00 0.00 100.00 18.18 450.00 101-4-2150-4460 Equip Replacement Charge 7,000.00 0.00 583.34 8.33 6,416.66 TOTAL Other Services & Charges 29,050.00 803.28 1,486.62 5.12 27,563.38 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Support Services 770,750.00 57,291.13 98,452.10 12.77 672,297.90 Police Reserves =============== Personal Services 101-4-2160-4103 Part-time Pay 3,000.00 0.00 0.00 0.00 3,000.00 101-4-2160-4105 FICA 200.00 0.00 0.00 0.00 200.00 101-4-2160-4107 Medicare 50.00 0.00 0.00 0.00 50.00 TOTAL Personal Services 3,250.00 0.00 0.00 0.00 3,250.00 Supplies 101-4-2160-4217 Uniform Allowance 5,600.00 0.00 0.00 0.00 5,600.00 101-4-2160-4219 Operating Supplies 3,000.00 0.00 0.00 0.00 3,000.00 TOTAL Supplies 8,600.00 0.00 0.00 0.00 8,600.00 Other Services & Charges 101-4-2160-4319 Other Professional Services 1,800.00 0.00 0.00 0.00 1,800.00 101-4-2160-4331 Travel, Conferences & Schools 3,200.00 0.00 0.00 0.00 3,200.00 TOTAL Other Services & Charges 5,000.00 0.00 0.00 0.00 5,000.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Reserves 16,850.00 0.00 0.00 0.00 16,850.00 Public safety building ====================== 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Service s _____________ _____________ _____________ _______ _____________ Supplies 101-4-2190-4219 Operating Supplies 22,300.00 9,324.91 9,408.21 42.19 12,891.79 TOTAL Supplies 22,300.00 9,324.91 9,408.21 42.19 12,891.79 Other Services & Charges 101-4-2190-4361 Insurance 4,700.00 0.00 1,119.00 23.81 3,581.00 101-4-2190-4389 Utilities 91,300.00 2,212.30 7,964.75 8.72 83,335.25 101-4-2190-4401 Bldg Repair/Maint Services 52,000.00 246.95 1,249.82 2.40 50,750.18 TOTAL Other Services & Charges 148,000.00 2,459.25 10,333.57 6.98 137,666.43 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Public safety building 170,300.00 11,784.16 19,741.78 11.59 150,558.22 Fire Administration =================== Personal Services 101-4-2310-4101 Regular Pay 272,000.00 21,367.88 36,115.18 13.28 235,884.82 101-4-2310-4104 PERA 41,050.00 3,237.50 5,468.12 13.32 35,581.88 101-4-2310-4105 FICA 3,300.00 270.76 460.30 13.95 2,839.70 101-4-2310-4106 Other Retirement Contributions 212,000.00 0.00 0.00 0.00 212,000.00 101-4-2310-4107 Medicare 3,950.00 298.24 512.42 12.97 3,437.58 101-4-2310-4108 Insurance 30,300.00 3,645.59 7,291.18 24.06 23,008.82 101-4-2310-4109 Workers Comp 12,500.00 0.00 2,711.50 21.69 9,788.50 TOTAL Personal Services 575,100.00 28,819.97 52,558.70 9.14 522,541.30 Supplies 101-4-2310-4201 Office Supplies 1,300.00 121.26 121.26 9.33 1,178.74 101-4-2310-4212 Fuels & Lubes 4,800.00 0.00 407.82 8.50 4,392.18 101-4-2310-4217 Uniform Allowance 1,700.00 197.15 197.15 11.60 1,502.85 101-4-2310-4219 Operating Supplies 6,500.00 374.63 374.63 5.76 6,125.37 101-4-2310-4221 Equipment Parts 500.00 0.00 0.00 0.00 500.00 TOTAL Supplies 14,800.00 693.04 1,100.86 7.44 13,699.14 Other Services & Charges 101-4-2310-4319 Other Professional Services 2,000.00 0.00 0.00 0.00 2,000.00 101-4-2310-4321 Telephone 3,200.00 255.92 374.77 11.71 2,825.23 101-4-2310-4322 Postage 700.00 214.18 214.18 30.60 485.82 101-4-2310-4331 Travel, Conferences & Schools 4,000.00 200.00 200.00 5.00 3,800.00 101-4-2310-4359 Publishing 200.00 0.00 0.00 0.00 200.00 101-4-2310-4361 Insurance 7,000.00 0.00 1,668.00 23.83 5,332.00 101-4-2310-4389 Utilities 19,000.00 1,336.40 2,144.38 11.29 16,855.62 101-4-2310-4401 Bldg Repair/Maint Services 12,000.00 475.00 475.00 3.96 11,525.00 101-4-2310-4404 Equip Repair/Maint Services 3,450.00 0.00 0.00 0.00 3,450.00 101-4-2310-4433 Dues & Subscriptions 2,100.00 308.00 1,348.00 64.19 752.00 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-4-2310-4460 Equip Replacement Charge 72,000.00 0.00 6,000.00 8.33 66,000.00 TOTAL Other Services & Charges 125,650.00 2,789.50 12,424.33 9.89 113,225.67 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Administration 715,550.00 32,302.51 66,083.89 9.24 649,466.11 Fire Operations =============== Personal Services 101-4-2320-4103 Part-time Pay 188,700.00 20,114.89 28,853.98 15.29 159,846.02 101-4-2320-4105 FICA 11,700.00 1,245.51 1,785.99 15.26 9,914.01 101-4-2320-4107 Medicare 2,750.00 291.08 417.27 15.17 2,332.73 101-4-2320-4108 Insurance 1,500.00 0.00 0.00 0.00 1,500.00 101-4-2320-4109 Workers Comp 36,000.00 0.00 8,940.00 24.83 27,060.00 TOTAL Personal Services 240,650.00 21,651.48 39,997.24 16.62 200,652.76 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 4.84 505.69 5.95 7,994.31 101-4-2320-4217 Uniform Allowance 7,300.00 26.55 26.55 0.36 7,273.45 101-4-2320-4219 Operating Supplies 77,700.00 6,396.99 6,396.99 8.23 71,303.01 101-4-2320-4221 Equipment Parts 10,000.00 356.44 867.98 8.68 9,132.02 TOTAL Supplies 103,700.00 6,784.82 7,797.21 7.52 95,902.79 Other Services & Charges 101-4-2320-4321 Telephone 4,600.00 461.88 509.23 11.07 4,090.77 101-4-2320-4331 Travel, Conferences & Schools 13,500.00 ( 487.16) 3,622.84 26.84 9,877.16 101-4-2320-4404 Equip Repair/Maint Services 38,700.00 4,012.49 5,023.99 12.98 33,676.01 101-4-2320-4409 Contractual Services 7,000.00 3,461.00 3,461.00 49.44 3,539.00 TOTAL Other Services & Charges 63,800.00 7,448.21 12,617.06 19.78 51,182.94 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Operations 408,150.00 35,884.51 60,411.51 14.80 347,738.49 Emergency Management ==================== Personal Service s _____________ _____________ _____________ _______ _____________ Supplies 101-4-2330-4219 Operating Supplies 6,500.00 538.96 538.96 8.29 5,961.04 TOTAL Supplies 6,500.00 538.96 538.96 8.29 5,961.04 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-2330-4331 Travel, Conferences & Schools 3,900.00 0.00 0.00 0.00 3,900.00 101-4-2330-4389 Utilities 5,200.00 461.27 627.72 12.07 4,572.28 101-4-2330-4404 Equip Repair/Maint Services 5,950.00 0.00 0.00 0.00 5,950.00 101-4-2330-4433 Dues & Subscriptions 250.00 0.00 0.00 0.00 250.00 TOTAL Other Services & Charges 15,300.00 461.27 627.72 4.10 14,672.28 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Emergency Management 21,800.00 1,000.23 1,166.68 5.35 20,633.32 Building Safety =============== Personal Services 101-4-2410-4101 Regular Pay 516,150.00 38,918.80 66,161.97 12.82 449,988.03 101-4-2410-4104 PERA 46,800.00 3,760.01 6,229.17 13.31 40,570.83 101-4-2410-4105 FICA 26,700.00 1,886.80 3,207.80 12.01 23,492.20 101-4-2410-4107 Medicare 7,500.00 531.69 903.91 12.05 6,596.09 101-4-2410-4108 Insurance 90,400.00 7,017.26 14,034.52 15.52 76,365.48 101-4-2410-4109 Workers Comp 2,000.00 0.00 471.75 23.59 1,528.25 TOTAL Personal Services 689,550.00 52,114.56 91,009.12 13.20 598,540.88 Supplies 101-4-2410-4201 Office Supplies 2,000.00 29.09 175.87 8.79 1,824.13 101-4-2410-4212 Fuels & Lubes 8,600.00 0.00 728.29 8.47 7,871.71 101-4-2410-4217 Uniform Allowance 2,750.00 0.00 0.00 0.00 2,750.00 101-4-2410-4219 Operating Supplies 700.00 904.89 904.89 129.27 ( 204.89) TOTAL Supplies 14,050.00 933.98 1,809.05 12.88 12,240.95 Other Services & Charges 101-4-2410-4321 Telephone 4,600.00 261.08 261.08 5.68 4,338.92 101-4-2410-4322 Postage 250.00 87.13 87.13 34.85 162.87 101-4-2410-4331 Travel, Conferences & Schools 2,950.00 800.00 1,320.00 44.75 1,630.00 101-4-2410-4361 Insurance 900.00 0.00 201.00 22.33 699.00 101-4-2410-4404 Equip Repair/Maint Services 4,000.00 2,090.00 2,090.00 52.25 1,910.00 101-4-2410-4433 Dues & Subscriptions 1,600.00 0.00 100.00 6.25 1,500.00 101-4-2410-4460 Equip Replacement Charge 4,000.00 0.00 333.34 8.33 3,666.66 TOTAL Other Services & Charges 18,300.00 3,238.21 4,392.55 24.00 13,907.45 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Safety 721,900.00 56,286.75 97,210.72 13.47 624,689.28 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Public Safety 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Code Enforcement ================ Personal Services 101-4-2420-4101 Regular Pay 76,100.00 5,852.80 9,949.76 13.07 66,150.24 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 746.23 13.09 4,953.77 101-4-2420-4105 FICA 5,750.00 374.78 637.13 11.08 5,112.87 101-4-2420-4107 Medicare 1,350.00 87.65 149.01 11.04 1,200.99 101-4-2420-4108 Insurance 3,700.00 302.26 604.52 16.34 3,095.48 101-4-2420-4109 Workers Comp 300.00 0.00 65.25 21.75 234.75 TOTAL Personal Services 109,100.00 7,056.45 12,151.90 11.14 96,948.10 Supplies 101-4-2420-4212 Fuels & Lubes 1,600.00 0.00 149.40 9.34 1,450.60 101-4-2420-4217 Uniform Allowance 350.00 0.00 0.00 0.00 350.00 101-4-2420-4219 Operating Supplies 600.00 231.44 231.44 38.57 368.56 TOTAL Supplies 2,550.00 231.44 380.84 14.93 2,169.16 Other Services & Charges 101-4-2420-4321 Telephone 850.00 27.37 27.37 3.22 822.63 101-4-2420-4322 Postage 1,200.00 204.25 204.25 17.02 995.75 101-4-2420-4331 Travel, Conferences & Schools 800.00 480.00 480.00 60.00 320.00 101-4-2420-4361 Insurance 200.00 0.00 42.00 21.00 158.00 101-4-2420-4460 Equip Replacement Charge 1,000.00 0.00 83.34 8.33 916.66 TOTAL Other Services & Charges 4,050.00 711.62 836.96 20.67 3,213.04 ___________________________________________________________________________________________________________________ TOTAL Code Enforcement 115,700.00 7,999.51 13,369.70 11.56 102,330.30 Environmental ============= Personal Services 101-4-2440-4101 Regular Pay 21,050.00 1,582.00 2,689.40 12.78 18,360.60 101-4-2440-4104 PERA 1,600.00 118.64 205.87 12.87 1,394.13 101-4-2440-4105 FICA 1,300.00 98.29 170.56 13.12 1,129.44 101-4-2440-4107 Medicare 300.00 22.99 39.89 13.30 260.11 101-4-2440-4108 Insurance 2,200.00 183.14 366.33 16.65 1,833.67 101-4-2440-4109 Workers Comp 300.00 0.00 60.00 20.00 240.00 TOTAL Personal Services 26,750.00 2,005.06 3,532.05 13.20 23,217.95 Supplies 101-4-2440-4201 Office Supplies 300.00 57.21 57.21 19.07 242.79 101-4-2440-4212 Fuels & Lubes 100.00 0.00 0.00 0.00 100.00 101-4-2440-4219 Operating Supplies 350.00 0.00 0.00 0.00 350.00 TOTAL Supplies 750.00 57.21 57.21 7.63 692.79 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Public Safety 16.67% 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 0.00 0.00 350.00 101-4-2440-4322 Postage 500.00 114.05 114.05 22.81 385.95 101-4-2440-4331 Travel, Conferences & Schools 1,400.00 0.00 0.00 0.00 1,400.00 101-4-2440-4359 Publishing 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2440-4409 Contractual Services 1,500.00 0.00 0.00 0.00 1,500.00 101-4-2440-4433 Dues & Subscriptions 200.00 0.00 0.00 0.00 200.00 TOTAL Other Services & Charges 4,950.00 114.05 114.05 2.30 4,835.95 ___________________________________________________________________________________________________________________ TOTAL Environmental 32,450.00 2,176.32 3,703.31 11.41 28,746.69 ___________________________________________________________________________________________________________________ TOTAL Public Safety 7,770,250.00 500,491.68 967,009.12 12.45 6,803,240.88 Street Maintenance ================== Personal Services 101-4-3120-4101 Regular Pay 540,900.00 21,619.13 30,227.27 5.59 510,672.73 101-4-3120-4102 Overtime Pay 4,000.00 0.00 ( 2,557.81) 63.95- 6,557.81 101-4-3120-4103 Part-time Pay 74,550.00 5,546.66 9,257.28 12.42 65,292.72 101-4-3120-4104 PERA 45,300.00 1,966.98 2,699.04 5.96 42,600.96 101-4-3120-4105 FICA 38,450.00 1,693.44 2,283.55 5.94 36,166.45 101-4-3120-4107 Medicare 9,050.00 396.04 534.05 5.90 8,515.95 101-4-3120-4108 Insurance 90,550.00 3,071.87 6,296.73 6.95 84,253.27 101-4-3120-4109 Workers Comp 35,500.00 0.00 8,583.00 24.18 26,917.00 TOTAL Personal Services 838,300.00 34,294.12 57,323.11 6.84 780,976.89 Supplies 101-4-3120-4201 Office Supplies 2,500.00 119.83 119.83 4.79 2,380.17 101-4-3120-4212 Fuels & Lubes 61,300.00 ( 5,351.96)( 17,645.00) 28.78- 78,945.00 101-4-3120-4217 Uniform Allowance 6,650.00 163.91 338.91 5.10 6,311.09 101-4-3120-4219 Operating Supplies 59,500.00 5,399.94 5,424.94 9.12 54,075.06 101-4-3120-4221 Equipment Parts 53,000.00 3,106.88 3,632.92 6.85 49,367.08 101-4-3120-4226 Street Signs 32,500.00 291.35 197.94 0.61 32,302.06 TOTAL Supplies 215,450.00 3,729.95 ( 7,930.46) 3.68- 223,380.46 Other Services & Charges 101-4-3120-4319 Other Professional Services 300.00 0.00 0.00 0.00 300.00 101-4-3120-4321 Telephone 7,300.00 437.00 547.98 7.51 6,752.02 101-4-3120-4322 Postage 100.00 14.17 14.17 14.17 85.83 101-4-3120-4331 Travel, Conferences & Schools 4,400.00 430.00 430.00 9.77 3,970.00 101-4-3120-4359 Publishing 200.00 41.00 41.00 20.50 159.00 101-4-3120-4361 Insurance 14,400.00 0.00 3,490.00 24.24 10,910.00 101-4-3120-4389 Utilities 89,700.00 4,755.65 4,806.65 5.36 84,893.35 101-4-3120-4401 Bldg Repair/Maint Services 26,250.00 3,551.90 3,574.85 13.62 22,675.15 101-4-3120-4404 Equip Repair/Maint Services 9,000.00 0.00 0.00 0.00 9,000.00 101-4-3120-4409 Contractual Services 72,500.00 0.00 0.00 0.00 72,500.00 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Public Works 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 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 0.00 9,666.67 8.33 106,333.33 TOTAL Other Services & Charges 343,000.00 9,229.72 22,973.82 6.70 320,026.18 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Street Maintenance 1,396,750.00 47,253.79 72,366.47 5.18 1,324,383.53 Snow Removal ============ Personal Services 101-4-3130-4101 Regular Pay 109,300.00 22,159.13 44,432.47 40.65 64,867.53 101-4-3130-4102 Overtime Pay 20,000.00 17,391.22 24,462.85 122.31 ( 4,462.85) 101-4-3130-4103 Part-time Pay 0.00 1,140.00 1,140.00 0.00 ( 1,140.00) 101-4-3130-4104 PERA 9,450.00 2,912.83 5,113.70 54.11 4,336.30 101-4-3130-4105 FICA 8,000.00 2,490.78 4,279.69 53.50 3,720.31 101-4-3130-4107 Medicare 1,900.00 582.51 1,000.89 52.68 899.11 101-4-3130-4108 Insurance 14,950.00 3,071.88 6,296.76 42.12 8,653.24 101-4-3130-4109 Workers Comp 7,700.00 0.00 1,834.50 23.82 5,865.50 TOTAL Personal Services 171,300.00 49,748.35 88,560.86 51.70 82,739.14 Supplies 101-4-3130-4219 Operating Supplies 108,300.00 6,203.37 55,999.94 51.71 52,300.06 TOTAL Supplies 108,300.00 6,203.37 55,999.94 51.71 52,300.06 Other Services & Charge s _____________ _____________ _____________ _______ _____________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Snow Removal 279,600.00 55,951.72 144,560.80 51.70 135,039.20 Equipment Services ================== Personal Services 101-4-3150-4101 Regular Pay 128,650.00 9,768.00 16,484.14 12.81 112,165.86 101-4-3150-4102 Overtime Pay 1,000.00 183.15 85.55 8.56 914.45 101-4-3150-4104 PERA 9,750.00 746.34 1,242.73 12.75 8,507.27 101-4-3150-4105 FICA 8,050.00 607.40 1,009.24 12.54 7,040.76 101-4-3150-4107 Medicare 1,900.00 142.05 236.01 12.42 1,663.99 101-4-3150-4108 Insurance 20,750.00 1,779.95 3,560.00 17.16 17,190.00 101-4-3150-4109 Workers Comp 3,350.00 0.00 801.50 23.93 2,548.50 TOTAL Personal Services 173,450.00 13,226.89 23,419.17 13.50 150,030.83 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Public Works 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-3150-4212 Fuels & Lubes 8,000.00 942.09 5,436.06 67.95 2,563.94 101-4-3150-4217 Uniform Allowance 1,250.00 0.00 0.00 0.00 1,250.00 101-4-3150-4219 Operating Supplies 10,100.00 404.24 525.41 5.20 9,574.59 101-4-3150-4221 Equipment Parts 3,500.00 ( 1,450.30)( 1,450.30) 41.44- 4,950.30 TOTAL Supplies 22,850.00 ( 103.97) 4,511.17 19.74 18,338.83 Other Services & Charges 101-4-3150-4331 Travel, Conferences & Schools 1,500.00 0.00 0.00 0.00 1,500.00 101-4-3150-4404 Equip Repair/Maint Services 18,500.00 0.00 0.00 0.00 18,500.00 TOTAL Other Services & Charges 20,000.00 0.00 0.00 0.00 20,000.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Equipment Services 216,300.00 13,122.92 27,930.34 12.91 188,369.66 Engineering =========== Personal Services 101-4-3300-4101 Regular Pay 278,100.00 15,143.99 25,523.27 9.18 252,576.73 101-4-3300-4104 PERA 20,850.00 1,135.80 1,914.24 9.18 18,935.76 101-4-3300-4105 FICA 17,250.00 954.13 1,608.29 9.32 15,641.71 101-4-3300-4107 Medicare 4,050.00 223.15 376.13 9.29 3,673.87 101-4-3300-4108 Insurance 23,350.00 915.00 1,830.00 7.84 21,520.00 101-4-3300-4109 Workers Comp 1,050.00 0.00 245.00 23.33 805.00 TOTAL Personal Services 344,650.00 18,372.07 31,496.93 9.14 313,153.07 Supplies 101-4-3300-4201 Office Supplies 150.00 60.85 60.85 40.57 89.15 101-4-3300-4212 Fuels & Lubes 1,000.00 0.00 62.46 6.25 937.54 101-4-3300-4219 Operating Supplies 3,500.00 0.00 0.00 0.00 3,500.00 TOTAL Supplies 4,650.00 60.85 123.31 2.65 4,526.69 Other Services & Charges 101-4-3300-4319 Other Professional Services 3,000.00 0.00 0.00 0.00 3,000.00 101-4-3300-4321 Telephone 1,450.00 66.12 66.12 4.56 1,383.88 101-4-3300-4322 Postage 200.00 18.20 18.20 9.10 181.80 101-4-3300-4331 Travel, Conferences & Schools 2,150.00 697.96 697.96 32.46 1,452.04 101-4-3300-4361 Insurance 150.00 0.00 33.00 22.00 117.00 101-4-3300-4404 Equip Repair/Maint Services 500.00 0.00 0.00 0.00 500.00 101-4-3300-4460 Equip Replacement Charge 1,000.00 0.00 83.34 8.33 916.66 TOTAL Other Services & Charges 8,450.00 782.28 898.62 10.63 7,551.38 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Public Works 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Engineering 357,750.00 19,215.20 32,518.86 9.09 325,231.14 ___________________________________________________________________________________________________________________ TOTAL Public Works 2,250,400.00 135,543.63 277,376.47 12.33 1,973,023.53 Parks Department ================ Personal Services 101-4-5110-4101 Regular Pay 422,100.00 31,881.43 54,239.72 12.85 367,860.28 101-4-5110-4102 Overtime Pay 6,500.00 2,000.18 2,513.12 38.66 3,986.88 101-4-5110-4103 Part-time Pay 70,000.00 0.00 656.40 0.94 69,343.60 101-4-5110-4104 PERA 32,150.00 2,270.96 3,981.79 12.39 28,168.21 101-4-5110-4105 FICA 30,300.00 2,010.61 3,407.26 11.25 26,892.74 101-4-5110-4107 Medicare 7,100.00 470.22 797.11 11.23 6,302.89 101-4-5110-4108 Insurance 81,450.00 5,409.25 11,939.01 14.66 69,510.99 101-4-5110-4109 Workers Comp 17,000.00 0.00 4,063.50 23.90 12,936.50 TOTAL Personal Services 666,600.00 44,042.65 81,597.91 12.24 585,002.09 Supplies 101-4-5110-4212 Fuels & Lubes 33,050.00 0.00 1,584.61 4.79 31,465.39 101-4-5110-4217 Uniform Allowance 5,050.00 0.00 ( 16.03) 0.32- 5,066.03 101-4-5110-4219 Operating Supplies 108,150.00 2,050.71 3,307.21 3.06 104,842.79 101-4-5110-4221 Equipment Parts 28,000.00 1,961.65 2,200.04 7.86 25,799.96 TOTAL Supplies 174,250.00 4,012.36 7,075.83 4.06 167,174.17 Other Services & Charges 101-4-5110-4321 Telephone 3,700.00 317.72 351.58 9.50 3,348.42 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 2,070.00 2,070.00 47.59 2,280.00 101-4-5110-4361 Insurance 33,400.00 0.00 7,293.00 21.84 26,107.00 101-4-5110-4389 Utilities 84,500.00 2,907.41 4,162.64 4.93 80,337.36 101-4-5110-4401 Bldg Repair/Maint Services 4,000.00 0.00 0.00 0.00 4,000.00 101-4-5110-4404 Equip Repair/Maint Services 18,000.00 0.00 0.00 0.00 18,000.00 101-4-5110-4409 Contractual Services 59,700.00 7,900.00 7,900.00 13.23 51,800.00 101-4-5110-4415 Equipment Rental 29,500.00 660.00 660.00 2.24 28,840.00 101-4-5110-4460 Equip Replacement Charge 57,000.00 0.00 4,750.00 8.33 52,250.00 TOTAL Other Services & Charges 294,250.00 13,855.13 27,187.22 9.24 267,062.78 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks Department 1,135,100.00 61,910.14 115,860.96 10.21 1,019,239.04 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Culture & Recreation 16.67% 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 337,050.00 25,470.49 43,349.49 12.86 293,700.51 101-4-5210-4103 Part-time Pay 102,250.00 7,856.05 13,227.12 12.94 89,022.88 101-4-5210-4104 PERA 32,950.00 2,499.48 4,243.23 12.88 28,706.77 101-4-5210-4105 FICA 27,250.00 1,951.74 3,313.09 12.16 23,936.91 101-4-5210-4107 Medicare 6,400.00 456.46 774.84 12.11 5,625.16 101-4-5210-4108 Insurance 64,950.00 5,411.30 10,822.60 16.66 54,127.40 101-4-5210-4109 Workers Comp 3,600.00 0.00 862.00 23.94 2,738.00 TOTAL Personal Services 574,450.00 43,645.52 76,592.37 13.33 497,857.63 Supplies 101-4-5210-4219 Operating Supplies 7,800.00 1,463.66 1,463.66 18.76 6,336.34 TOTAL Supplies 7,800.00 1,463.66 1,463.66 18.76 6,336.34 Other Services & Charges 101-4-5210-4321 Telephone 3,450.00 312.94 312.94 9.07 3,137.06 101-4-5210-4322 Postage 1,000.00 148.37 148.37 14.84 851.63 101-4-5210-4331 Travel, Conferences & Schools 8,500.00 0.00 162.60 1.91 8,337.40 101-4-5210-4349 Advertising/Marketing 18,700.00 56.98 56.98 0.30 18,643.02 101-4-5210-4361 Insurance 900.00 0.00 208.00 23.11 692.00 101-4-5210-4389 Utilities 9,800.00 518.25 782.80 7.99 9,017.20 101-4-5210-4401 Bldg Repair/Maint Services 20,950.00 0.00 1,702.00 8.12 19,248.00 101-4-5210-4404 Equip Repair/Maint Services 8,800.00 0.00 8,384.65 95.28 415.35 101-4-5210-4433 Dues & Subscriptions 2,650.00 1,619.00 1,619.00 61.09 1,031.00 TOTAL Other Services & Charges 74,750.00 2,655.54 13,377.34 17.90 61,372.66 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks & Rec Admin 657,000.00 47,764.72 91,433.37 13.92 565,566.63 Recreation Programs =================== Personal Services 101-4-5220-4103 Part-time Pay 45,000.00 2,517.12 4,140.74 9.20 40,859.26 101-4-5220-4105 FICA 2,350.00 156.06 256.73 10.92 2,093.27 101-4-5220-4107 Medicare 650.00 36.49 60.04 9.24 589.96 TOTAL Personal Services 48,000.00 2,709.67 4,457.51 9.29 43,542.49 Supplies 101-4-5220-4219 Operating Supplies 20,000.00 0.00 0.00 0.00 20,000.00 TOTAL Supplies 20,000.00 0.00 0.00 0.00 20,000.00 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Culture & Recreation 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-5220-4409 Contractual Services 62,000.00 363.50 363.50 0.59 61,636.50 101-4-5220-4412 Building Rent 1,400.00 0.00 0.00 0.00 1,400.00 101-4-5220-4438 Credit Card Fees 3,600.00 152.96 285.85 7.94 3,314.15 TOTAL Other Services & Charges 67,000.00 516.46 649.35 0.97 66,350.65 ___________________________________________________________________________________________________________________ TOTAL Recreation Programs 135,000.00 3,226.13 5,106.86 3.78 129,893.14 Concessions =========== Supplies 101-4-5230-4219 Operating Supplies 0.00 245.00 70.00 0.00 ( 70.00) TOTAL Supplies 0.00 245.00 70.00 0.00 ( 70.00) Other Services & Charges 101-4-5230-4438 Credit Card Fees 0.00 15.00 30.00 0.00 ( 30.00) TOTAL Other Services & Charges 0.00 15.00 30.00 0.00 ( 30.00) ___________________________________________________________________________________________________________________ TOTAL Concessions 0.00 260.00 100.00 0.00 ( 100.00) Sr Citizen Programs =================== Personal Services 101-4-5510-4101 Regular Pay 128,300.00 5,024.23 8,462.63 6.60 119,837.37 101-4-5510-4103 Part-time Pay 10,550.00 663.00 1,261.00 11.95 9,289.00 101-4-5510-4104 PERA 10,400.00 376.82 634.70 6.10 9,765.30 101-4-5510-4105 FICA 8,600.00 368.12 629.22 7.32 7,970.78 101-4-5510-4107 Medicare 2,000.00 86.09 147.16 7.36 1,852.84 101-4-5510-4108 Insurance 11,000.00 304.50 609.00 5.54 10,391.00 101-4-5510-4109 Workers Comp 700.00 0.00 83.50 11.93 616.50 TOTAL Personal Services 171,550.00 6,822.76 11,827.21 6.89 159,722.79 Supplies 101-4-5510-4219 Operating Supplies 10,900.00 2,254.93 2,254.93 20.69 8,645.07 TOTAL Supplies 10,900.00 2,254.93 2,254.93 20.69 8,645.07 Other Services & Charges 101-4-5510-4321 Telephone 1,400.00 87.26 174.52 12.47 1,225.48 101-4-5510-4322 Postage 2,200.00 3.22 3.22 0.15 2,196.78 101-4-5510-4331 Travel, Conferences & Schools 2,050.00 139.00 139.00 6.78 1,911.00 101-4-5510-4361 Insurance 1,250.00 0.00 293.00 23.44 957.00 101-4-5510-4389 Utilities 22,650.00 779.67 1,934.98 8.54 20,715.02 101-4-5510-4401 Bldg Repair/Maint Services 24,850.00 0.00 1,428.00 5.75 23,422.00 101-4-5510-4409 Contractual Services 12,700.00 132.53 220.80 1.74 12,479.20 101-4-5510-4433 Dues & Subscriptions 850.00 160.00 263.30 30.98 586.70 TOTAL Other Services & Charges 67,950.00 1,301.68 4,456.82 6.56 63,493.18 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Culture & Recreation 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Sr Citizen Programs 250,400.00 10,379.37 18,538.96 7.40 231,861.04 ___________________________________________________________________________________________________________________ TOTAL Culture & Recreation 2,177,500.00 123,540.36 231,040.15 10.61 1,946,459.85 Economic Development ==================== Personal Services 101-4-6210-4101 Regular Pay 0.00 5,156.61 18,048.09 0.00 ( 18,048.09) 101-4-6210-4103 Part-time Pay 0.00 0.00 900.00 0.00 ( 900.00) 101-4-6210-4104 PERA 0.00 386.74 1,368.60 0.00 ( 1,368.60) 101-4-6210-4105 FICA 0.00 319.70 1,117.34 0.00 ( 1,117.34) 101-4-6210-4107 Medicare 0.00 74.75 265.65 0.00 ( 265.65) 101-4-6210-4108 Insurance 0.00 886.40 3,102.40 0.00 ( 3,102.40) 101-4-6210-4109 Workers Comp 0.00 0.00 190.50 0.00 ( 190.50) TOTAL Personal Services 0.00 6,824.20 24,992.58 0.00 ( 24,992.58) Other Services & Charges 101-4-6210-4361 Insurance 0.00 0.00 462.00 0.00 ( 462.00) 101-4-6210-4440 Miscellaneous 0.00 29.02 29.02 0.00 ( 29.02) TOTAL Other Services & Charges 0.00 29.02 491.02 0.00 ( 491.02) ___________________________________________________________________________________________________________________ TOTAL Economic Development 0.00 6,853.22 25,483.60 0.00 ( 25,483.60) Energy City =========== Personal Services 101-4-6220-4101 Regular Pay 21,050.00 1,582.02 2,689.43 12.78 18,360.57 101-4-6220-4104 PERA 1,600.00 118.66 199.92 12.50 1,400.08 101-4-6220-4105 FICA 1,300.00 98.30 165.62 12.74 1,134.38 101-4-6220-4107 Medicare 300.00 22.98 38.73 12.91 261.27 101-4-6220-4108 Insurance 2,200.00 183.16 366.29 16.65 1,833.71 TOTAL Personal Services 26,450.00 2,005.12 3,459.99 13.08 22,990.01 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 3-13-2019 08:35 AM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28TH, 2019 101-GENERAL FUND Economic Development 16.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-6220-4331 Travel, Conferences & Schools 3,000.00 0.00 0.00 0.00 3,000.00 101-4-6220-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-6220-4361 Insurance 200.00 0.00 51.00 25.50 149.00 TOTAL Other Services & Charges 3,700.00 0.00 51.00 1.38 3,649.00 ___________________________________________________________________________________________________________________ TOTAL Energy City 31,150.00 2,005.12 3,510.99 11.27 27,639.01 ___________________________________________________________________________________________________________________ TOTAL Economic Development 31,150.00 8,858.34 28,994.59 93.08 2,155.41 Transfers Out ============= Transfers Out _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL EXPENDITURES 16,221,200.00 1,068,395.17 2,009,200.44 12.39 14,211,999.56 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 682,213.43)( 1,562,232.22) 1,562,232.22 o000 0 0 0 pppp ppNp� NpN pp m N Q N e M � m O � Y � L b° 9 � — U — v � u O O O b b N O N n O bL W b m N N r — 'J L ' O O O O O O O O N O O O r V GO h N '/' '/' I O r r r V 0o c o.0 0o c o0 c c O O M V �D W O N p W V O� yQj O O N O Q m — �F� O O W W V W O O O r W O O Q r � n V O a�m bL O O V V GO � N N G] O 'J G] F r r a+ o 0 0 0 0 0 0 0 c c c 0] _ _ r M M 00 Y � U m 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 � O O •+� C� p � O � � ti 0 � 6 ti ti � y � z cv'�� � 3-13-2019 10:16 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: FEBRUARY 28TH, 2019 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE __________________________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 4,964.17 ( 1,554.86) 3,409.31 101-1010 Cash - General Fund 6,451,808.78 ( 994,654.29) 5,457,154.49 211-1010 Cash - Library 413,641.51 ( 2,600.46) 411,041.05 221-1010 Cash - Ice Arena 589,546.92 122,620.64 712,167.56 222-1010 Cash - Pinewood Golf Course ( 41,573.33)( 198.17)( 41,771.50) 225-1010 Cash - Park Dedication 327,740.24 0.00 327,740.24 228-1010 Cash - Landfill 205,570.51 ( 1,465.27) 204,105.24 231-1010 Cash - Landfill Const Debris 769,471.86 0.00 769,471.86 240-1010 Cash - Micro Loan Fund 823,092.08 7,398.76 830,490.84 242-1010 Cash - State DEED 54,560.67 4,529.15 59,089.82 245-1010 Cash - Development Fund 596,861.28 11,233.99 608,095.27 290-1010 Cash - Capital Outlay Reserve 950,632.78 ( 66,695.21) 883,937.57 291-1010 Cash - Insurance Reserve 154,372.25 ( 10,836.20) 143,536.05 292-1010 Cash - Govt Bldgs Reserve 2,400,705.68 ( 291,866.80) 2,108,838.88 294-1010 Cash - Drug Forfeiture 49,757.36 ( 7,441.50) 42,315.86 295-1010 Cash - Severance Pay Reserve 75,177.63 0.00 75,177.63 296-1010 Cash - GRE Reserve 2,388,117.33 ( 143,773.00) 2,244,344.33 333-1010 Cash - 2010A GO Cap Imp Bonds 911,962.63 ( 537,500.00) 374,462.63 401-1010 Cash - Pavement Mgmt 4,538,383.64 537,607.04 5,075,990.68 403-1010 Cash - Street Improvement 740,493.51 ( 255.00) 740,238.51 406-1010 Cash - City Wide Trunk Util 4,228,377.53 0.00 4,228,377.53 410-1010 Cash - Equipment Replacement 629,664.24 ( 117.19) 629,547.05 440-1010 Cash - Park Improvement 26,719.53 ( 6,954.37) 19,765.16 463-1010 Cash - TIF #23 Pref Powder 3,475.32 0.00 3,475.32 464-1010 Cash - TIF #24 Beaudry Truck ( 1,311.50)( 3,004.41)( 4,315.91) 602-1010 Cash - Wastewater Treatment 4,661,648.19 ( 594,595.60) 4,067,052.59 603-1010 Cash - Liquor 4,235,522.75 75,748.37 4,311,271.12 605-1010 Cash - Garbage 208,025.60 ( 112,299.30) 95,726.30 607-1010 Cash - Storm Water 816,096.78 ( 293,687.41) 522,409.37 801-1010 Cash - Interest 0.00 102,203.41 102,203.41 821-1010 Cash - Developer Escrow 700,053.79 ( 2,594.90) 697,458.89 TOTAL CLAIM ON CASH 37,913,559.73 ( 2,210,752.58) 35,702,807.15 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 112,636,397.94 ( 1,169,831.64) 111,466,566.30 999-1001 PY BANK ACCOUNT (103,105,027.77)( 1,040,920.94)(104,145,948.71) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 37,913,559.73 ( 2,210,752.58) 35,702,807.15 WAGES PAYABLE ______________ ______________ ______________ TOTAL CASH IN BANK - POOLED CASH 37,913,559.73 ( 2,210,752.58) 35,702,807.15 ============== ============== ==============