Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
INFORMATION #1 04-18-2016
Information J� City of Elk Memorandum River TO: Mayor and City Council From: Tim Simon, Finance Director Date: April 18, 2016 Subject: March 2016 Monthly Financial Report This report is designed to provide summary information regarding the overall level of revenues and expenditures in the General Fund, Ice Arena Special Revenue Fund, and Enterprise Funds. These funds provide an important picture of the city's financial health. For the month of March, actual revenues (except for property taxes and state aids) and expenditures should run 25% 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 significantly below 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: ■ Property taxes, our largest revenue source,will be received in July and December. ■ Licenses and permits collections are slightly over 15% of budget estimates and rental property licenses are at 97% of budget. ■ Charges for services are about 28% of budget,with the majority of March collections consisting of recreation registrations for spring/summer programs. ■ Fines and forfeits collections,which lag a month, are over 22% of budget estimates. ■ The transfers in will be recorded mid-year. Expenditures: ■ Total departmental expenditures are 21% of budget and most departments are within or below budget. ■ The quarterly premium for workers' comp insurance was paid in March. NAWREJ 2016 Monthly Expenditures $16,000 $14,000 N $12,000 0 a $10,000 CA p $8,000 ~ $6,000 $4,000 $2,000 $0 Jan OFbMa, Apr May Jun Jul Aug Sep Oct Nov Dec Actual $831 $1,859 $2,920 Budget $1,157 $2,314 $3,471 1$4,628 $5,785 $6,942 $8,099 1 $9,257 1$10,4141$11,5711$12,728$13,885 ICE ARENA For the month ending March,revenues of$314,004 exceed expenditures of$145,018 by $168,986. Ice rental revenues of$173,165 are about 33% of budget estimates. ATTACHMENTS ■ General Fund Revenue & Expense Report ■ Enterprise Funds—Budget to Actual ■ Cash Report—All Funds 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS 0 F: MARCH 31ST, 2016 101-GENERAL FUND FINANCIAL SUMMARY 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY General Fund 13,884,800.00 169,781.92 544,500.53 3.92 13,340,299.47 TOTAL REVENUES 13,884,800.00 169,781.92 544,500.53 3.92 13,340,299.47 EXPENDITURE SUMMARY General Government Mayor & Council 145,850.00 9,999.53 30,771.91 21.10 115,078.09 Cable TV 109,700.00 7,423.79 21,082.06 19.22 88,617.94 Administrative Services 605,500.00 42,065.74 128,366.05 21.20 477,133.95 Human Resources 178,400.00 12,271.54 35,150.13 19.70 143,249.87 Elections 20,500.00 6,300.00 6,300.00 30.73 14,200.00 Finance 583,550.00 39,266.95 125,782.17 21.55 457,767.83 Information Technology 346,350.00 25,185.25 78,629.53 22.70 267,720.47 Legal 214,600.00 19,772.60 37,198.20 17.33 177,401.80 Cormiunity Development 213,750.00 17,900.56 48,231.12 22.56 165,518.88 Planning 297,400.00 17,602.69 47,733.95 16.05 249,666.05 City Hall Maintenance 623,650.00 52,592.69 140,510.57 22.53 483,139.43 Contingency ( 95,000.00) 0.00 0.00 0.00 ( 95,000.00) TOTAL General Government 3,244,250.00 250,381.34 699,755.69 21.57 2,544,494.31 Public Safety Police Administration 713,700.00 54,813.93 188,856.00 26.46 524,844.00 Patrol 2,530,150.00 180,857.93 518,640.84 20.50 2,011,509.16 Investigations 994,000.00 94,554.77 208,653.25 20.99 785,346.75 Police Support Services 558,600.00 38,145.76 108,560.84 19.43 450,039.16 Police Reserves 23,250.00 2,115.00 2,423.78 10.42 20,826.22 Public safety building 156,000.00 9,848.58 22,901.68 14.68 133,098.32 Fire Administration 475,750.00 33,648.73 97,104.45 20.41 378,645.55 Fire Operations 381,300.00 41,986.00 87,507.12 22.95 293,792.88 Emergency Management 24,800.00 387.91 1,666.58 6.72 23,133.42 Building Safety 647,750.00 49,760.35 142,144.60 21.94 505,605.40 Code Enforcement 91,600.00 7,601.10 20,176.28 22.03 71,423.72 Environmental 39,100.00 3,605.67 8,742.97 22.36 30,357.03 TOTAL Public Safety 6,636,000.00 517,325.73 1,407,378.39 21.21 5,228,621.61 Public Works Street Maintenance 1,310,000.00 102,003.32 229,101.89 17.49 1,080,898.11 Snow Removal 281,550.00 57,847.00 124,425.83 44.19 157,124.17 Equipment Services 186,250.00 11,741.24 37,273.28 20.01 148,976.72 Engineering 217,950.00 16,136.83 45,291.12 20.78 172,658.88 TOTAL Public Works 1,995,750.00 187,728.39 436,092.12 21.85 1,559,657.88 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND FINANCIAL SUMMARY 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE Culture & Recreation Parks Department 1,038,100.00 62,903.27 175,593.77 16.91 862,506.23 Parks & Rec Admin 545,700.00 44,206.81 121,436.01 22.25 424,263.99 Recreation Programs 165,750.00 2,635.96 13,368.57 8.07 152,381.43 Sr Citizen Programs 242,950.00 15,683.29 48,753.61 20.07 194,196.39 TOTAL Culture & Recreation 1,992,500.00 125,429.33 359,151.96 18.03 1,633,348.04 Economic Development Economic Development 0.00 ( 13,932.41) 15,622.80 0.00 ( 15,622.80) Energy City 16,300.00 850.09 2,415.00 14.82 13,885.00 TOTAL Economic Development 16,300.00 ( 13,082.32) 18,037.80 110.66 ( 1,737.80) General TOTAL EXPENDITURES 13,884,800.00 1,067,782.47 2,920,415.96 21.03 10,964,384.04 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 898,000.55) ( 2,375,915.43) 2,375,915.43 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE General Fund ------------ Tames 101-3-0000-3111 Current Ad Valorem Tates 9,596,850.00 0.00 1,693.98 0.02 9,595,156.02 101-3-0000-3121 Gravel Tax 127,000.00 0.00 0.00 0.00 127,000.00 TOTAL Tames 9,723,850.00 0.00 1,693.98 0.02 9,722,156.02 Licenses & Permits 101-3-0000-3211 Liquor License 67,500.00 0.00 40.00 0.06 67,460.00 101-3-0000-3212 Amusement License 1,050.00 0.00 0.00 0.00 1,050.00 101-3-0000-3213 Cigarette License 3,100.00 100.00 100.00 3.23 3,000.00 101-3-0000-3214 Apartment License 35,000.00 11,438.00 33,972.00 97.06 1,028.00 101-3-0000-3216 Mining License 23,000.00 1,510.20 1,510.20 6.57 21,489.80 101-3-0000-3217 Garbage Hauler License 1,600.00 0.00 315.00 19.69 1,285.00 101-3-0000-3218 Other Business License/Permit 12,000.00 890.00 1,960.00 16.33 10,040.00 101-3-0000-3229 NPDES Permit 10,000.00 700.00 1,750.00 17.50 8,250.00 101-3-0000-3231 Building Permit 385,000.00 11,243.25 28,965.65 7.52 356,034.35 101-3-0000-3232 Plumbing/Heating Permit 92,000.00 18,800.16 25,756.19 28.00 66,243.81 101-3-0000-3233 Permit Surcharge 300.00 636.87 1,170.44 390.15 ( 870.44) 101-3-0000-3235 Animal License 6,500.00 190.00 1,020.00 15.69 5,480.00 101-3-0000-3236 Parking Permit 1,500.00 0.00 336.84 22.46 1,163.16 101-3-0000-3237 Other Non-Business Lic/Permit 8,000.00 310.00 2,360.00 29.50 5,640.00 TOTAL Licenses & Permits 646,550.00 45,818.48 99,256.32 15.35 547,293.68 Intergovernmental Rev 101-3-0000-3311 Federal Grant 1,800.00 0.00 0.00 0.00 1,800.00 101-3-0000-3322 MV Credit 4,000.00 0.00 0.00 0.00 4,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 20 Aid 230,000.00 0.00 0.00 0.00 230,000.00 101-3-0000-3326 Police Training Reimb 10,000.00 0.00 0.00 0.00 10,000.00 101-3-0000-3329 State Crime Prevention Grant 25,250.00 0.00 0.00 0.00 25,250.00 101-3-0000-3330 Other State Grants 3,300.00 900.00 900.00 27.27 2,400.00 TOTAL Intergovernmental Rev 288,350.00 900.00 900.00 0.31 287,450.00 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 16,000.00 4,325.00 7,505.00 46.91 8,495.00 101-3-0000-3413 Plan Check Fee 135,000.00 5,613.56 13,025.55 9.65 121,974.45 101-3-0000-3415 Special Assessment Search 500.00 140.00 200.00 40.00 300.00 101-3-0000-3417 Copies 1,700.00 251.94 498.92 29.35 1,201.08 101-3-0000-3418 Other General Govt Services 4,500.00 392.50 655.50 14.57 3,844.50 101-3-0000-3430 Lockout Fees 7,500.00 480.00 1,850.00 24.67 5,650.00 101-3-0000-3431 Police Services 6,000.00 450.00 460.00 7.67 5,540.00 101-3-0000-3432 School Liaison 123,600.00 0.00 61,812.00 50.01 61,788.00 101-3-0000-3434 Animal Impound Fee 3,000.00 150.00 700.00 23.33 2,300.00 101-3-0000-3436 Fire Contracts 220,000.00 0.00 106,343.36 48.34 113,656.64 101-3-0000-3437 Fire Services 3,000.00 0.00 79.45 2.65 2,920.55 101-3-0000-3438 Fire Inspections 10,000.00 0.00 0.00 0.00 10,000.00 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-3-0000-3450 Maintenance Facility Rent 14,500.00 1,156.50 3,469.50 23.93 11,030.50 101-3-0000-3451 Street Services 35,000.00 4,441.76 5,342.86 15.27 29,657.14 101-3-0000-3452 Engineering Services Reirnb 148,950.00 0.00 0.00 0.00 148,950.00 101-3-0000-3461 Recreation Fees 96,000.00 23,111.00 30,119.53 31.37 65,880.47 101-3-0000-3462 Sr Center Activities 29,000.00 2,730.97 8,029.55 27.69 20,970.45 101-3-0000-3472 Park Use Fee 24,400.00 3,624.88 7,015.49 28.75 17,384.51 101-3-0000-3475 Building Rent 2,400.00 200.00 600.00 25.00 1,800.00 101-3-0000-3483 Sewer Inspection Fee 9,000.00 325.00 605.00 6.72 8,395.00 101-3-0000-3484 Contractor License Check 1,000.00 55.00 110.00 11.00 890.00 TOTAL Charges for Services 891,050.00 47,448.11 248,421.71 27.88 642,628.29 Fines & Forfeits 101-3-0000-3510 Court Fines 117,000.00 15,869.20 27,272.43 23.31 89,727.57 101-3-0000-3511 Parking Fines 10,000.00 320.00 1,200.00 12.00 8,800.00 TOTAL Fines & Forfeits 127,000.00 16,189.20 28,472.43 22.42 98,527.57 Special Assessments Other Revenue 101-3-0000-3621 Interest Income 85,000.00 0.00 2,765.50 3.25 82,234.50 101-3-0000-3625 Refunds & Reimbursements 101,000.00 568.80 568.80 0.56 100,431.20 101-3-0000-3626 Contributions 20,000.00 0.00 16,000.00 80.00 4,000.00 101-3-0000-3629 Miscellaneous Revenue 7,500.00 346.63 1,050.39 14.01 6,449.61 TOTAL Other Revenue 213,500.00 915.43 20,384.69 9.55 193,115.31 Transfers In 101-3-0000-3921 Transfers 217,950.00 0.00 0.00 0.00 217,950.00 101-3-0000-3925 Transfer-Landfill 55,000.00 0.00 0.00 0.00 55,000.00 101-3-0000-3929 Transfer-NSP/RDF Reserve 45,000.00 0.00 0.00 0.00 45,000.00 101-3-0000-3930 Transfer-Development 62,600.00 0.00 0.00 0.00 62,600.00 101-3-0000-3942 Transfer-WWTS 100,000.00 0.00 0.00 0.00 100,000.00 101-3-0000-3943 Transfer-Liquor 438,950.00 0.00 0.00 0.00 438,950.00 101-3-0000-3944 Transfer-Garbage 45,000.00 0.00 0.00 0.00 45,000.00 101-3-0000-3945 Transfer-Utilities 970,450.00 58,510.70 145,371.40 14.98 825,078.60 101-3-0000-3948 Transfer-EDA 34,800.00 0.00 0.00 0.00 34,800.00 101-3-0000-3949 Transfer-HRA 24,750.00 0.00 0.00 0.00 24,750.00 TOTAL Transfers In 1,994,500.00 58,510.70 145,371.40 7.29 1,849,128.60 TOTAL General Fund 13,884,800.00 169,781.92 544,500.53 3.92 13,340,299.47 TOTAL REVENUE 13,884,800.00 169,781.92 544,500.53 3.92 13,340,299.47 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Mayor & Council --------------- Personal Services 101-4-1110-4103 Part-time Pay 38,500.00 3,207.99 9,623.97 25.00 28,876.03 101-4-1110-4104 PERA 1,900.00 102.09 306.27 16.12 1,593.73 101-4-1110-4105 FICA 2,400.00 72.32 216.96 9.04 2,183.04 101-4-1110-4107 Medicare 550.00 46.51 139.53 25.37 410.47 101-4-1110-4109 Workers Comp 100.00 20.75 41.50 41.50 58.50 TOTAL Personal Services 43,450.00 3,449.66 10,328.23 23.77 33,121.77 Supplies 101-4-1110-4201 Office Supplies 1,000.00 27.93 79.13 7.91 920.87 TOTAL Supplies 1,000.00 27.93 79.13 7.91 920.87 Other Services & Charges 101-4-1110-4319 Other Professional Services 10,400.00 3,499.22 4,449.22 42.78 5,950.78 101-4-1110-4322 Postage 200.00 0.00 0.00 0.00 200.00 101-4-1110-4331 Travel, Conferences & Schools 2,100.00 46.44 556.44 26.50 1,543.56 101-4-1110-4359 Publishing 3,700.00 0.00 447.72 12.10 3,252.28 101-4-1110-4361 Insurance 39,600.00 0.00 9,615.00 24.28 29,985.00 101-4-1110-4433 Dues & Subscriptions 18,550.00 0.00 0.00 0.00 18,550.00 101-4-1110-4440 Miscellaneous 26,850.00 2,976.28 5,296.17 19.73 21,553.83 TOTAL Other Services & Charges 101,400.00 6,521.94 20,364.55 20.08 81,035.45 Capital Outlay TOTAL Mayor & Council 145,850.00 9,999.53 30,771.91 21.10 115,078.09 Cable TV Personal Services 101-4-1120-4101 Regular Pay 63,350.00 4,875.20 13,650.57 21.55 49,699.43 101-4-1120-4103 Part-time Pay 17,950.00 690.00 2,110.71 11.76 15,839.29 101-4-1120-4104 PERA 6,100.00 417.39 1,266.41 20.76 4,833.59 101-4-1120-4105 FICA 5,050.00 314.18 954.30 18.90 4,095.70 101-4-1120-4107 Medicare 1,200.00 73.48 223.19 18.60 976.81 101-4-1120-4108 Insurance 14,250.00 861.00 2,583.00 18.13 11,667.00 101-4-1120-4109 Workers Cornp 350.00 94.75 189.50 54.14 160.50 TOTAL Personal Services 108,250.00 7,326.00 20,977.68 19.38 87,272.32 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND General Government 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-1120-4201 Office Supplies 500.00 97.79 104.38 20.88 395.62 TOTAL Supplies 500.00 97.79 104.38 20.88 395.62 Other Services & Charges 101-4-1120-4331 Travel, Conferences & Schools 950.00 0.00 0.00 0.00 950.00 TOTAL Other Services & Charges 950.00 0.00 0.00 0.00 950.00 Capital Outlay TOTAL Cable TV 109,700.00 7,423.79 21,082.06 19.22 88,617.94 Administrative Services ----------------------- Personal Services 101-4-1210-4101 Regular Pay 388,750.00 29,903.15 83,728.84 21.54 305,021.16 101-4-1210-4103 Part-time Pay 46,000.00 3,100.00 8,900.62 19.35 37,099.38 101-4-1210-4104 PERA 32,600.00 2,475.22 7,444.19 22.83 25,155.81 101-4-1210-4105 FICA 26,950.00 2,046.93 6,111.86 22.68 20,838.14 101-4-1210-4107 Medicare 6,300.00 478.70 1,429.34 22.69 4,870.66 101-4-1210-4108 Insurance 36,600.00 3,276.23 8,718.29 23.82 27,881.71 101-4-1210-4109 Workers Comp 1,900.00 487.50 975.00 51.32 925.00 TOTAL Personal Services 539,100.00 41,767.73 117,308.14 21.76 421,791.86 Supplies 101-4-1210-4201 Office Supplies 7,300.00 58.65 280.14 3.84 7,019.86 TOTAL Supplies 7,300.00 58.65 280.14 3.84 7,019.86 Other Services & Charges 101-4-1210-4319 Other Professional Services 11,600.00 0.00 336.00 2.90 11,264.00 101-4-1210-4321 Telephone 1,500.00 ( 253.12) ( 253.12) 16.87- 1,753.12 101-4-1210-4322 Postage 800.00 0.00 530.54 66.32 269.46 101-4-1210-4331 Travel, Conferences & Schools 10,550.00 80.52 552.52 5.24 9,997.48 101-4-1210-4334 Car Allowance 4,800.00 400.00 1,200.00 25.00 3,600.00 101-4-1210-4359 Publishing 13,000.00 0.00 3,261.00 25.08 9,739.00 101-4-1210-4361 Insurance 50.00 0.00 11.75 23.50 38.25 101-4-1210-4404 Equip Repair/Maint Services 14,950.00 0.00 4,825.16 32.28 10,124.84 101-4-1210-4433 Dues & Subscriptions 1,850.00 11.96 313.92 16.97 1,536.08 TOTAL Other Services & Charges 59,100.00 239.36 10,777.77 18.24 48,322.23 Capital Outlay TOTAL Administrative Services 605,500.00 42,065.74 128,366.05 21.20 477,133.95 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND General Government 25.00% 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 121,250.00 9,226.46 25,834.10 21.31 95,415.90 101-4-1220-4104 PERA 9,100.00 691.98 2,075.94 22.81 7,024.06 101-4-1220-4105 FICA 7,500.00 556.42 1,669.27 22.26 5,830.73 101-4-1220-4107 Medicare 1,750.00 130.14 390.42 22.31 1,359.58 101-4-1220-4108 Insurance 14,900.00 1,260.02 3,780.06 25.37 11,119.94 101-4-1220-4109 Workers Comp 550.00 136.00 272.00 49.45 278.00 TOTAL Personal Services 155,050.00 12,001.02 34,021.79 21.94 121,028.21 Supplies 101-4-1220-4201 Office Supplies 1,350.00 20.52 49.91 3.70 1,300.09 TOTAL Supplies 1,350.00 20.52 49.91 3.70 1,300.09 Other Services & Charges 101-4-1220-4319 Other Professional Services 1,250.00 250.00 421.80 33.74 828.20 101-4-1220-4322 Postage 600.00 0.00 196.86 32.81 403.14 101-4-1220-4331 Travel, Conferences & Schools 18,200.00 0.00 259.77 1.43 17,940.23 101-4-1220-4404 Equip Repair/Maint 1,200.00 0.00 0.00 0.00 1,200.00 101-4-1220-4433 Dues & Subscriptions 750.00 0.00 200.00 26.67 550.00 TOTAL Other Services & Charges 22,000.00 250.00 1,078.43 4.90 20,921.57 Capital Outlay TOTAL Human Resources 178,400.00 12,271.54 35,150.13 19.70 143,249.87 Elections Personal Services 101-4-1230-4103 Part-time Pay 15,000.00 0.00 0.00 0.00 15,000.00 TOTAL Personal Services 15,000.00 0.00 0.00 0.00 15,000.00 Supplies 101-4-1230-4219 Operating Supplies 1,300.00 0.00 0.00 0.00 1,300.00 TOTAL Supplies 1,300.00 0.00 0.00 0.00 1,300.00 Other Services & Charges 101-4-1230-4322 Postage 50.00 0.00 0.00 0.00 50.00 101-4-1230-4331 Travel, Conferences & Schools 150.00 0.00 0.00 0.00 150.00 101-4-1230-4359 Publishing 350.00 0.00 0.00 0.00 350.00 101-4-1230-4404 Equip Repair/Maint Services 3,300.00 6,300.00 6,300.00 190.91 ( 3,000.00) 101-4-1230-4415 Equipment Rental 350.00 0.00 0.00 0.00 350.00 TOTAL Other Services & Charges 4,200.00 6,300.00 6,300.00 150.00 ( 2,100.00) 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND General Government 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Elections 20,500.00 6,300.00 6,300.00 30.73 14,200.00 Finance Personal Services 101-4-1310-4101 Regular Pay 317,750.00 24,443.52 68,441.83 21.54 249,308.17 101-4-1310-4103 Part-time Pay 53,400.00 3,900.17 12,188.02 22.82 41,211.98 101-4-1310-4104 PERA 27,850.00 2,125.80 6,487.08 23.29 21,362.92 101-4-1310-4105 FICA 23,000.00 1,686.56 5,150.34 22.39 17,849.66 101-4-1310-4107 Medicare 5,400.00 394.44 1,204.53 22.31 4,195.47 101-4-1310-4108 Insurance 38,350.00 3,236.01 9,708.03 25.31 28,641.97 101-4-1310-4109 Workers Comp 1,650.00 416.25 832.50 50.45 817.50 TOTAL Personal Services 467,400.00 36,202.75 104,012.33 22.25 363,387.67 Supplies 101-4-1310-4201 Office Supplies 4,500.00 161.10 296.86 6.60 4,203.14 TOTAL Supplies 4,500.00 161.10 296.86 6.60 4,203.14 Other Services & Charges 101-4-1310-4301 Audit Fees 20,000.00 0.00 1,500.00 7.50 18,500.00 101-4-1310-4319 Other Professional Services 54,000.00 0.00 0.00 0.00 54,000.00 101-4-1310-4321 Telephone 350.00 0.00 0.00 0.00 350.00 101-4-1310-4322 Postage 2,600.00 0.00 1,003.08 38.58 1,596.92 101-4-1310-4331 Travel, Conferences & Schools 4,150.00 0.00 145.90 3.52 4,004.10 101-4-1310-4359 Publishing 200.00 0.00 240.00 120.00 ( 40.00) 101-4-1310-4404 Equip Repair/Maint Services 21,750.00 2,443.00 17,576.74 80.81 4,173.26 101-4-1310-4433 Dues & Subscriptions 1,600.00 120.00 180.00 11.25 1,420.00 101-4-1310-4438 Credit Card Fees 5,500.00 259.20 577.91 10.51 4,922.09 101-4-1310-4440 Miscellaneous 1,500.00 80.90 249.35 16.62 1,250.65 TOTAL Other Services & Charges 111,650.00 2,903.10 21,472.98 19.23 90,177.02 Capital Outlay TOTAL Finance 583,550.00 39,266.95 125,782.17 21.55 457,767.83 Information Technology ---------------------- Personal Services 101-4-1350-4101 Regular Pay 188,650.00 14,402.33 40,326.53 21.38 148,323.47 101-4-1350-4104 PERA 14,150.00 1,080.18 3,240.54 22.90 10,909.46 101-4-1350-4105 FICA 11,700.00 817.17 2,445.78 20.90 9,254.22 101-4-1350-4107 Medicare 2,750.00 191.11 571.99 20.80 2,178.01 101-4-1350-4108 Insurance 32,350.00 2,728.02 8,184.06 25.30 24,165.94 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND General Government 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-1350-4109 Workers Comp 850.00 211.50 423.00 49.76 427.00 TOTAL Personal Services 250,450.00 19,430.31 55,191.90 22.04 195,258.10 Supplies 101-4-1350-4219 Operating Supplies 15,800.00 116.50 1,555.93 9.85 14,244.07 TOTAL Supplies 15,800.00 116.50 1,555.93 9.85 14,244.07 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 0.00 462.50 5.78 7,537.50 101-4-1350-4321 Telephone 2,550.00 ( 506.24) ( 506.24) 19.85- 3,056.24 101-4-1350-4331 Travel, Conferences & Schools 8,950.00 0.00 0.00 0.00 8,950.00 101-4-1350-4404 Equip Repair/Maint Services 60,600.00 6,144.68 21,925.44 36.18 38,674.56 TOTAL Other Services & Charges 80,100.00 5,638.44 21,881.70 27.32 58,218.30 Capital Outlay TOTAL Information Technology 346,350.00 25,185.25 78,629.53 22.70 267,720.47 Legal Personal Services Supplies Other Services & Charges 101-4-1400-4304 Legal Fees 214,600.00 19,772.60 37,198.20 17.33 177,401.80 TOTAL Other Services & Charges 214,600.00 19,772.60 37,198.20 17.33 177,401.80 TOTAL Legal 214,600.00 19,772.60 37,198.20 17.33 177,401.80 Conununity Development --------------------- Personal Services 101-4-1500-4101 Regular Pay 170,850.00 13,141.06 36,794.95 21.54 134,055.05 101-4-1500-4104 PERA 12,800.00 985.58 2,956.74 23.10 9,843.26 101-4-1500-4105 FICA 10,600.00 796.12 2,388.34 22.53 8,211.66 101-4-1500-4107 Medicare 2,500.00 186.18 558.54 22.34 1,941.46 101-4-1500-4108 Insurance 11,050.00 1,260.02 3,780.06 34.21 7,269.94 101-4-1500-4109 Workers Comp 750.00 191.50 383.00 51.07 367.00 TOTAL Personal Services 208,550.00 16,560.46 46,861.63 22.47 161,688.37 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND General Government 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-1500-4201 Office Supplies 1,100.00 536.50 565.89 51.44 534.11 TOTAL Supplies 1,100.00 536.50 565.89 51.44 534.11 Other Services & Charges 101-4-1500-4321 Telephone 700.00 0.00 0.00 0.00 700.00 101-4-1500-4331 Travel, Conferences & Schools 2,850.00 803.60 803.60 28.20 2,046.40 101-4-1500-4433 Dues & Subscriptions 550.00 0.00 0.00 0.00 550.00 TOTAL Other Services & Charges 4,100.00 803.60 803.60 19.60 3,296.40 TOTAL Cormiunity Development 213,750.00 17,900.56 48,231.12 22.56 165,518.88 Planning Personal Services 101-4-1510-4101 Regular Pay 207,100.00 11,566.16 32,385.25 15.64 174,714.75 101-4-1510-4104 PERA 15,550.00 867.46 2,602.38 16.74 12,947.62 101-4-1510-4105 FICA 12,850.00 649.48 1,948.44 15.16 10,901.56 101-4-1510-4107 Medicare 3,000.00 151.90 455.70 15.19 2,544.30 101-4-1510-4108 Insurance 39,100.00 1,497.01 4,491.03 11.49 34,608.97 101-4-1510-4109 Workers Comp 950.00 256.50 513.00 54.00 437.00 TOTAL Personal Services 278,550.00 14,988.51 42,395.80 15.22 236,154.20 Supplies 101-4-1510-4201 Office Supplies 2,500.00 171.21 342.10 13.68 2,157.90 101-4-1510-4212 Fuels & Lubes 300.00 0.00 10.14 3.38 289.86 101-4-1510-4219 Operating Supplies 2,150.00 1,543.55 1,543.55 71.79 606.45 TOTAL Supplies 4,950.00 1,714.76 1,895.79 38.30 3,054.21 Other Services & Charges 101-4-1510-4321 Telephone 350.00 77.42 77.42 22.12 272.58 101-4-1510-4322 Postage 1,500.00 0.00 290.19 19.35 1,209.81 101-4-1510-4331 Travel, Conferences & Schools 1,500.00 0.00 0.00 0.00 1,500.00 101-4-1510-4359 Publishing 8,000.00 776.00 1,749.00 21.86 6,251.00 101-4-1510-4361 Insurance 50.00 0.00 11.75 23.50 38.25 101-4-1510-4404 Equip Repair/Maint Services 1,500.00 0.00 900.00 60.00 600.00 101-4-1510-4433 Dues & Subscriptions 750.00 0.00 368.00 49.07 382.00 101-4-1510-4440 Miscellaneous 250.00 46.00 46.00 18.40 204.00 TOTAL Other Services & Charges 13,900.00 899.42 3,442.36 24.77 10,457.64 Capital Outlay TOTAL Planning 297,400.00 17,602.69 47,733.95 16.05 249,666.05 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND General Government 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE City Hall Maintenance --------------------- Personal Services 101-4-1600-4101 Regular Pay 343,000.00 25,880.88 72,466.44 21.13 270,533.56 101-4-1600-4102 Overtime Pay 3,500.00 448.05 690.96 19.74 2,809.04 101-4-1600-4103 Part-time Pay 3,450.00 0.00 0.00 0.00 3,450.00 101-4-1600-4104 PERA 26,000.00 1,974.66 5,875.00 22.60 20,125.00 101-4-1600-4105 FICA 21,700.00 1,634.27 4,862.31 22.41 16,837.69 101-4-1600-4107 Medicare 5,100.00 382.22 1,137.18 22.30 3,962.82 101-4-1600-4108 Insurance 40,550.00 3,519.04 10,557.12 26.03 29,992.88 101-4-1600-4109 Workers Comp 11,500.00 2,900.50 5,801.00 50.44 5,699.00 TOTAL Personal Services 454,800.00 36,739.62 101,390.01 22.29 353,409.99 Supplies 101-4-1600-4212 Fuels & Lubes 2,000.00 167.41 578.17 28.91 1,421.83 101-4-1600-4217 Uniform Allowance 2,400.00 366.91 504.85 21.04 1,895.15 101-4-1600-4219 Operating Supplies 30,400.00 4,371.52 13,454.38 44.26 16,945.62 TOTAL Supplies 34,800.00 4,905.84 14,537.40 41.77 20,262.60 Other Services & Charges 101-4-1600-4321 Telephone 11,700.00 746.07 2,523.95 21.57 9,176.05 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 65.00 65.00 3.25 1,935.00 101-4-1600-4361 Insurance 5,350.00 0.00 1,301.00 24.32 4,049.00 101-4-1600-4389 Utilities 75,750.00 6,053.95 11,507.83 15.19 64,242.17 101-4-1600-4401 Bldg Repair/Maint Services 32,800.00 3,836.38 6,179.89 18.84 26,620.11 101-4-1600-4404 Equip Repair/Maint Services 3,500.00 0.00 2,268.00 64.80 1,232.00 101-4-1600-4460 Equip Replacement Charge 2,950.00 245.83 737.49 25.00 2,212.51 TOTAL Other Services & Charges 134,050.00 10,947.23 24,583.16 18.34 109,466.84 Capital Outlay TOTAL City Hall Maintenance 623,650.00 52,592.69 140,510.57 22.53 483,139.43 Contingency Personal Services 101-4-1900-4101 Regular Pay ( 95,000.00) 0.00 0.00 0.00 ( 95,000.00) TOTAL Personal Services ( 95,000.00) 0.00 0.00 0.00 ( 95,000.00) Other Services & Charges TOTAL Contingency ( 95,000.00) 0.00 0.00 0.00 ( 95,000.00) TOTAL General Government 3,244,250.00 250,381.34 699,755.69 21.57 2,544,494.31 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Public Safety 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Police Administration --------------------- Personal Services 101-4-2110-4101 Regular Pay 373,250.00 27,414.28 76,760.00 20.57 296,490.00 101-4-2110-4104 PERA 54,450.00 4,090.74 12,272.22 22.54 42,177.78 101-4-2110-4105 FICA 4,300.00 209.18 627.54 14.59 3,672.46 101-4-2110-4107 Medicare 5,400.00 373.70 1,121.10 20.76 4,278.90 101-4-2110-4108 Insurance 35,950.00 2,988.03 8,964.09 24.93 26,985.91 101-4-2110-4109 Workers Comp 61,500.00 15,257.75 30,515.50 49.62 30,984.50 TOTAL Personal Services 534,850.00 50,333.68 130,260.45 24.35 404,589.55 Supplies 101-4-2110-4201 Office Supplies 10,350.00 655.40 718.15 6.94 9,631.85 101-4-2110-4217 Uniform Allowance 2,950.00 273.99 480.09 16.27 2,469.91 101-4-2110-4219 Operating Supplies 1,300.00 622.35 1,995.29 153.48 ( 695.29) TOTAL Supplies 14,600.00 1,551.74 3,193.53 21.87 11,406.47 Other Services & Charges 101-4-2110-4319 Other Professional Services 6,900.00 ( 34.75) 0.00 0.00 6,900.00 101-4-2110-4321 Telephone 31,900.00 2,484.26 3,024.48 9.48 28,875.52 101-4-2110-4322 Postage 2,400.00 0.00 523.13 21.80 1,876.87 101-4-2110-4331 Travel, Conferences & Schools 10,200.00 0.00 255.00 2.50 9,945.00 101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2110-4361 Insurance 41,450.00 0.00 10,059.75 24.27 31,390.25 101-4-2110-4404 Equip Repair/Maint Services 65,050.00 275.00 40,263.66 61.90 24,786.34 101-4-2110-4433 Dues & Subscriptions 5,500.00 204.00 1,204.00 21.89 4,296.00 101-4-2110-4437 Tames & Licenses 350.00 0.00 72.00 20.57 278.00 TOTAL Other Services & Charges 164,250.00 2,928.51 55,402.02 33.73 108,847.98 Capital Outlay TOTAL Police Administration 713,700.00 54,813.93 188,856.00 26.46 524,844.00 Patrol Personal Services 101-4-2120-4101 Regular Pay 1,642,400.00 117,303.43 345,643.93 21.05 1,296,756.07 101-4-2120-4102 Overtime Pay 90,000.00 2,742.23 9,589.98 10.66 80,410.02 101-4-2120-4104 PERA 280,650.00 19,447.38 61,665.85 21.97 218,984.15 101-4-2120-4107 Medicare 23,800.00 1,562.99 4,980.15 20.93 18,819.85 101-4-2120-4108 Insurance 176,550.00 15,767.07 47,581.41 26.95 128,968.59 TOTAL Personal Services 2,213,400.00 156,823.10 469,461.32 21.21 1,743,938.68 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Public Safety 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-2120-4212 Fuels & Lubes 88,000.00 5,888.13 19,267.36 21.89 68,732.64 101-4-2120-4217 Uniform Allowance 35,100.00 0.00 318.83 0.91 34,781.17 101-4-2120-4219 Operating Supplies 75,550.00 9,057.76 9,023.74 11.94 66,526.26 101-4-2120-4221 Equipment Parts 23,300.00 820.31 1,145.96 4.92 22,154.04 TOTAL Supplies 221,950.00 15,766.20 29,755.89 13.41 192,194.11 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 28,300.00 3,246.00 6,476.00 22.88 21,824.00 101-4-2120-4404 Equip Repair/Maint Services 20,700.00 1,260.13 1,260.13 6.09 19,439.87 101-4-2120-4433 Dues & Subscriptions 650.00 0.00 400.00 61.54 250.00 101-4-2120-4460 Equip Replacement Charge 45,150.00 3,762.50 11,287.50 25.00 33,862.50 TOTAL Other Services & Charges 94,800.00 8,268.63 19,423.63 20.49 75,376.37 Capital Outlay TOTAL Patrol 2,530,150.00 180,857.93 518,640.84 20.50 2,011,509.16 Investigations -------------- Personal Services 101-4-2130-4101 Regular Pay 676,050.00 77,790.67 154,244.69 22.82 521,805.31 101-4-2130-4102 Overtime Pay 50,000.00 957.33 3,950.18 7.90 46,049.82 101-4-2130-4104 PERA 117,600.00 7,178.50 23,272.80 19.79 94,327.20 101-4-2130-4107 Medicare 9,200.00 556.81 1,518.94 16.51 7,681.06 101-4-2130-4108 Insurance 95,250.00 6,144.35 19,172.63 20.13 76,077.37 TOTAL Personal Services 948,100.00 92,627.66 202,159.24 21.32 745,940.76 Supplies 101-4-2130-4217 Uniform Allowance 6,800.00 399.24 968.81 14.25 5,831.19 101-4-2130-4219 Operating Supplies 7,600.00 34.37 53.84 0.71 7,546.16 TOTAL Supplies 14,400.00 433.61 1,022.65 7.10 13,377.35 Other Services & Charges 101-4-2130-4319 Other Professional Services 6,500.00 96.00 267.00 4.11 6,233.00 101-4-2130-4331 Travel, Conferences & Schools 9,700.00 297.50 1,822.50 18.79 7,877.50 101-4-2130-4433 Dues & Subscriptions 2,100.00 0.00 81.86 3.90 2,018.14 101-4-2130-4460 Equip Replacement Charge 13,200.00 1,100.00 3,300.00 25.00 9,900.00 TOTAL Other Services & Charges 31,500.00 1,493.50 5,471.36 17.37 26,028.64 Capital Outlay TOTAL Investigations 994,000.00 94,554.77 208,653.25 20.99 785,346.75 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Public Safety 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Police Support Services ----------------------- Personal Services 101-4-2150-4101 Regular Pay 342,950.00 24,404.81 68,333.47 19.93 274,616.53 101-4-2150-4102 Overtime Pay 10,000.00 93.91 482.49 4.82 9,517.51 101-4-2150-4103 Part-time Pay 37,600.00 2,638.35 7,481.76 19.90 30,118.24 101-4-2150-4104 PERA 29,300.00 2,035.28 6,135.63 20.94 23,164.37 101-4-2150-4105 FICA 24,200.00 1,626.83 5,790.47 23.93 18,409.53 101-4-2150-4107 Medicare 5,650.00 380.47 1,354.27 23.97 4,295.73 101-4-2150-4108 Insurance 60,900.00 4,779.03 14,337.09 23.54 46,562.91 TOTAL Personal Services 510,600.00 35,958.68 103,915.18 20.35 406,684.82 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 4,500.00 0.00 360.99 8.02 4,139.01 101-4-2150-4219 Operating Supplies 18,900.00 329.08 595.92 3.15 18,304.08 TOTAL Supplies 24,400.00 329.08 956.91 3.92 23,443.09 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 4,800.00 30.00 325.00 6.77 4,475.00 101-4-2150-4404 Equip Repair/Maint Services 2,250.00 0.00 445.75 19.81 1,804.25 101-4-2150-4409 Contractual Services 10,000.00 1,118.00 1,118.00 11.18 8,882.00 101-4-2150-4433 Dues & Subscriptions 550.00 210.00 300.00 54.55 250.00 101-4-2150-4460 Equip Replacement Charge 6,000.00 500.00 1,500.00 25.00 4,500.00 TOTAL Other Services & Charges 23,600.00 1,858.00 3,688.75 15.63 19,911.25 Capital Outlay TOTAL Police Support Services 558,600.00 38,145.76 108,560.84 19.43 450,039.16 Police Reserves --------------- Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 0.00 240.88 4.38 5,259.12 101-4-2160-4104 PERA 0.00 0.00 8.84 0.00 ( 8.84) 101-4-2160-4105 FICA 350.00 0.00 16.36 4.67 333.64 101-4-2160-4107 Medicare 100.00 0.00 3.82 3.82 96.18 TOTAL Personal Services 5,950.00 0.00 269.90 4.54 5,680.10 Supplies 101-4-2160-4217 Uniform Allowance 5,500.00 485.00 485.00 8.82 5,015.00 101-4-2160-4219 Operating Supplies 6,500.00 1,630.00 1,668.88 25.68 4,831.12 TOTAL Supplies 12,000.00 2,115.00 2,153.88 17.95 9,846.12 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Public Safety 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Other Services & Charges 101-4-2160-4319 Other Professional Services 2,100.00 0.00 0.00 0.00 2,100.00 101-4-2160-4331 Travel, Conferences & Schools 3,200.00 0.00 0.00 0.00 3,200.00 TOTAL Other Services & Charges 5,300.00 0.00 0.00 0.00 5,300.00 Capital Outlay TOTAL Police Reserves 23,250.00 2,115.00 2,423.78 10.42 20,826.22 Public safety building ---------------------- Personal Services Supplies 101-4-2190-4219 Operating Supplies 16,600.00 1,325.20 4,317.94 26.01 12,282.06 TOTAL Supplies 16,600.00 1,325.20 4,317.94 26.01 12,282.06 Other Services & Charges 101-4-2190-4361 Insurance 5,200.00 0.00 1,261.00 24.25 3,939.00 101-4-2190-4389 Utilities 97,500.00 6,961.93 13,686.70 14.04 83,813.30 101-4-2190-4401 Bldg Repair/Maint Services 36,700.00 1,561.45 3,636.04 9.91 33,063.96 TOTAL Other Services & Charges 139,400.00 8,523.38 18,583.74 13.33 120,816.26 Capital Outlay TOTAL Public safety building 156,000.00 9,848.58 22,901.68 14.68 133,098.32 Fire Administration ------------------- Personal Services 101-4-2310-4101 Regular Pay 233,350.00 17,692.84 49,539.95 21.23 183,810.05 101-4-2310-4104 PERA 34,450.00 2,618.34 7,855.02 22.80 26,594.98 101-4-2310-4105 FICA 2,400.00 177.68 533.05 22.21 1,866.95 101-4-2310-4106 Other Retirement Contributions 30,000.00 0.00 0.00 0.00 30,000.00 101-4-2310-4107 Medicare 3,400.00 243.13 729.40 21.45 2,670.60 101-4-2310-4108 Insurance 29,100.00 2,534.11 7,602.33 26.12 21,497.67 101-4-2310-4109 Workers Comp 8,800.00 2,221.50 4,443.00 50.49 4,357.00 TOTAL Personal Services 341,500.00 25,487.60 70,702.75 20.70 270,797.25 Supplies 101-4-2310-4201 Office Supplies 3,150.00 0.00 578.11 18.35 2,571.89 101-4-2310-4212 Fuels & Lubes 2,500.00 304.69 1,117.58 44.70 1,382.42 101-4-2310-4217 Uniform Allowance 6,500.00 0.00 97.70 1.50 6,402.30 101-4-2310-4219 Operating Supplies 1,000.00 558.11 558.11 55.81 441.89 101-4-2310-4221 Equipment Parts 700.00 0.00 0.00 0.00 700.00 TOTAL Supplies 13,850.00 862.80 2,351.50 16.98 11,498.50 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Public Safety 25.00% 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 10,000.00 0.00 0.00 0.00 10,000.00 101-4-2310-4321 Telephone 3,100.00 118.38 355.14 11.46 2,744.86 101-4-2310-4322 Postage 500.00 28.77 192.17 38.43 307.83 101-4-2310-4331 Travel, Conferences & Schools 7,500.00 0.00 0.00 0.00 7,500.00 101-4-2310-4359 Publishing 750.00 0.00 0.00 0.00 750.00 101-4-2310-4361 Insurance 12,000.00 0.00 2,905.50 24.21 9,094.50 101-4-2310-4389 Utilities 22,250.00 1,925.60 3,695.15 16.61 18,554.85 101-4-2310-4401 Bldg Repair/Maint Services 5,500.00 149.25 1,853.25 33.70 3,646.75 101-4-2310-4404 Equip Repair/Maint Services 2,950.00 0.00 0.00 0.00 2,950.00 101-4-2310-4433 Dues & Subscriptions 2,050.00 593.00 1,599.00 78.00 451.00 101-4-2310-4460 Equip Replacement Charge 53,800.00 4,483.33 13,449.99 25.00 40,350.01 TOTAL Other Services & Charges 120,400.00 7,298.33 24,050.20 19.98 96,349.80 Capital Outlay TOTAL Fire Administration 475,750.00 33,648.73 97,104.45 20.41 378,645.55 Fire Operations --------------- Personal Services 101-4-2320-4103 Part-time Pay 169,700.00 11,832.05 33,235.05 19.58 136,464.95 101-4-2320-4105 FICA 10,500.00 657.88 2,203.28 20.98 8,296.72 101-4-2320-4107 Medicare 2,450.00 153.88 515.32 21.03 1,934.68 101-4-2320-4109 Workers Comp 27,400.00 7,248.75 14,497.50 52.91 12,902.50 TOTAL Personal Services 210,050.00 19,892.56 50,451.15 24.02 159,598.85 Supplies 101-4-2320-4201 Office Supplies 300.00 7.53 37.22 12.41 262.78 101-4-2320-4212 Fuels & Lubes 8,700.00 681.80 2,059.09 23.67 6,640.91 101-4-2320-4217 Uniform Allowance 9,300.00 305.25 662.25 7.12 8,637.75 101-4-2320-4219 Operating Supplies 72,900.00 13,203.14 20,414.10 28.00 52,485.90 101-4-2320-4221 Equipment Parts 7,450.00 2,290.20 2,956.80 39.69 4,493.20 TOTAL Supplies 98,650.00 16,487.92 26,129.46 26.49 72,520.54 Other Services & Charges 101-4-2320-4321 Telephone 4,650.00 484.53 578.79 12.45 4,071.21 101-4-2320-4331 Travel, Conferences & Schools 26,000.00 2,320.29 3,607.04 13.87 22,392.96 101-4-2320-4404 Equip Repair/Maint Services 36,300.00 2,800.70 3,013.68 8.30 33,286.32 101-4-2320-4409 Contractual Services 5,650.00 0.00 3,727.00 65.96 1,923.00 TOTAL Other Services & Charges 72,600.00 5,605.52 10,926.51 15.05 61,673.49 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Public Safety 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Capital Outlay TOTAL Fire Operations 381,300.00 41,986.00 87,507.12 22.95 293,792.88 Emergency Management -------------------- Personal Services Supplies 101-4-2330-4219 Operating Supplies 7,100.00 0.00 0.00 0.00 7,100.00 TOTAL Supplies 7,100.00 0.00 0.00 0.00 7,100.00 Other Services & Charges 101-4-2330-4321 Telephone 0.00 93.75 93.75 0.00 ( 93.75) 101-4-2330-4331 Travel, Conferences & Schools 10,400.00 0.00 0.00 0.00 10,400.00 101-4-2330-4389 Utilities 3,650.00 294.16 683.83 18.74 2,966.17 101-4-2330-4404 Equip Repair/Maint Services 3,450.00 0.00 629.00 18.23 2,821.00 101-4-2330-4433 Dues & Subscriptions 200.00 0.00 260.00 130.00 ( 60.00) TOTAL Other Services & Charges 17,700.00 387.91 1,666.58 9.42 16,033.42 Capital Outlay TOTAL Emergency Management 24,800.00 387.91 1,666.58 6.72 23,133.42 Building Safety --------------- Personal Services 101-4-2410-4101 Regular Pay 450,050.00 34,632.02 96,969.66 21.55 353,080.34 101-4-2410-4104 PERA 40,300.00 3,098.74 9,296.22 23.07 31,003.78 101-4-2410-4105 FICA 23,250.00 1,607.91 4,829.85 20.77 18,420.15 101-4-2410-4107 Medicare 6,550.00 453.93 1,363.22 20.81 5,186.78 101-4-2410-4108 Insurance 78,600.00 6,588.05 19,764.15 25.15 58,835.85 101-4-2410-4109 Workers Comp 2,050.00 520.75 1,041.50 50.80 1,008.50 TOTAL Personal Services 600,800.00 46,901.40 133,264.60 22.18 467,535.40 Supplies 101-4-2410-4201 Office Supplies 7,700.00 52.36 1,034.91 13.44 6,665.09 101-4-2410-4212 Fuels & Lubes 5,000.00 484.99 1,347.75 26.96 3,652.25 101-4-2410-4217 Uniform Allowance 1,750.00 0.00 0.00 0.00 1,750.00 101-4-2410-4219 Operating Supplies 9,550.00 560.95 925.35 9.69 8,624.65 TOTAL Supplies 24,000.00 1,098.30 3,308.01 13.78 20,691.99 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Public Safety 25.00% 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 5,650.00 ( 86.90) ( 86.90) 1.54- 5,736.90 101-4-2410-4322 Postage 700.00 0.00 78.19 11.17 621.81 101-4-2410-4331 Travel, Conferences & Schools 3,800.00 171.72 1,161.96 30.58 2,638.04 101-4-2410-4361 Insurance 450.00 0.00 111.25 24.72 338.75 101-4-2410-4404 Equip Repair/Maint Services 5,600.00 0.00 2,090.00 37.32 3,510.00 101-4-2410-4433 Dues & Subscriptions 3,500.00 1,405.00 1,405.00 40.14 2,095.00 101-4-2410-4460 Equip Replacement Charge 3,250.00 270.83 812.49 25.00 2,437.51 TOTAL Other Services & Charges 22,950.00 1,760.65 5,571.99 24.28 17,378.01 Capital Outlay TOTAL Building Safety 647,750.00 49,760.35 142,144.60 21.94 505,605.40 Code Enforcement ---------------- Personal Services 101-4-2420-4101 Regular Pay 70,300.00 5,408.00 15,142.40 21.54 55,157.60 101-4-2420-4104 PERA 5,250.00 405.60 1,216.80 23.18 4,033.20 101-4-2420-4105 FICA 4,350.00 347.49 1,042.47 23.96 3,307.53 101-4-2420-4107 Medicare 1,000.00 81.27 243.81 24.38 756.19 101-4-2420-4108 Insurance 3,600.00 300.01 900.03 25.00 2,699.97 101-4-2420-4109 Workers Comp 300.00 81.75 163.50 54.50 136.50 TOTAL Personal Services 84,800.00 6,624.12 18,709.01 22.06 66,090.99 Supplies 101-4-2420-4212 Fuels & Lubes 2,000.00 130.81 326.83 16.34 1,673.17 101-4-2420-4217 Uniform Allowance 350.00 0.00 0.00 0.00 350.00 101-4-2420-4219 Operating Supplies 1,100.00 0.00 16.00 1.45 1,084.00 TOTAL Supplies 3,450.00 130.81 342.83 9.94 3,107.17 Other Services & Charges 101-4-2420-4321 Telephone 800.00 156.17 156.17 19.52 643.83 101-4-2420-4322 Postage 1,750.00 0.00 250.77 14.33 1,499.23 101-4-2420-4331 Travel, Conferences & Schools 700.00 690.00 690.00 98.57 10.00 101-4-2420-4361 Insurance 100.00 0.00 27.50 27.50 72.50 TOTAL Other Services & Charges 3,350.00 846.17 1,124.44 33.57 2,225.56 TOTAL Code Enforcement 91,600.00 7,601.10 20,176.28 22.03 71,423.72 Environmental 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Public Safety 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 101-4-2440-4101 Regular Pay 26,900.00 2,029.00 5,681.20 21.12 21,218.80 101-4-2440-4104 PERA 2,000.00 152.18 456.54 22.83 1,543.46 101-4-2440-4105 FICA 1,650.00 125.80 377.40 22.87 1,272.60 101-4-2440-4107 Medicare 400.00 29.42 88.26 22.07 311.74 101-4-2440-4108 Insurance 3,350.00 368.65 1,105.95 33.01 2,244.05 101-4-2440-4109 Workers Comp 300.00 69.50 139.00 46.33 161.00 TOTAL Personal Services 34,600.00 2,774.55 7,848.35 22.68 26,751.65 Supplies 101-4-2440-4201 Office Supplies 450.00 2.93 7.13 1.58 442.87 101-4-2440-4212 Fuels & Lubes 200.00 8.59 28.95 14.48 171.05 101-4-2440-4219 Operating Supplies 0.00 819.60 819.60 0.00 ( 819.60) TOTAL Supplies 650.00 831.12 855.68 131.64 ( 205.68) Other Services & Charges 101-4-2440-4321 Telephone 350.00 0.00 0.00 0.00 350.00 101-4-2440-4322 Postage 700.00 0.00 38.94 5.56 661.06 101-4-2440-4331 Travel, Conferences & Schools 1,150.00 0.00 0.00 0.00 1,150.00 101-4-2440-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2440-4409 Contractual Services 1,000.00 0.00 0.00 0.00 1,000.00 101-4-2440-4433 Dues & Subscriptions 150.00 0.00 0.00 0.00 150.00 TOTAL Other Services & Charges 3,850.00 0.00 38.94 1.01 3,811.06 TOTAL Environmental 39,100.00 3,605.67 8,742.97 22.36 30,357.03 TOTAL Public Safety 6,636,000.00 517,325.73 1,407,378.39 21.21 5,228,621.61 Street Maintenance ------------------ Personal Services 101-4-3120-4101 Regular Pay 493,750.00 36,102.41 83,590.45 16.93 410,159.55 101-4-3120-4102 Overtime Pay 4,000.00 0.00 0.00 0.00 4,000.00 101-4-3120-4103 Part-time Pay 77,000.00 4,703.66 16,246.88 21.10 60,753.12 101-4-3120-4104 PERA 41,450.00 2,970.46 7,485.84 18.06 33,964.16 101-4-3120-4105 FICA 35,650.00 2,394.03 6,256.25 17.55 29,393.75 101-4-3120-4107 Medicare 8,350.00 559.89 1,463.16 17.52 6,886.84 101-4-3120-4108 Insurance 75,050.00 4,482.56 13,230.12 17.63 61,819.88 101-4-3120-4109 Workers Comp 28,600.00 7,238.75 14,477.50 50.62 14,122.50 TOTAL Personal Services 763,850.00 58,451.76 142,750.20 18.69 621,099.80 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Public Works 25.00% 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,850.00 117.93 122.13 4.29 2,727.87 101-4-3120-4212 Fuels & Lubes 66,200.00 2,089.61 ( 2,615.39) 3.95- 68,815.39 101-4-3120-4219 Operating Supplies 60,000.00 2,026.72 7,570.10 12.62 52,429.90 101-4-3120-4221 Equipment Parts 50,000.00 4,348.66 9,824.48 19.65 40,175.52 101-4-3120-4226 Street Signs 30,500.00 16,393.35 16,696.35 54.74 13,803.65 TOTAL Supplies 209,550.00 24,976.27 31,597.67 15.08 177,952.33 Other Services & Charges 101-4-3120-4319 Other Professional Services 550.00 0.00 0.00 0.00 550.00 101-4-3120-4321 Telephone 6,100.00 383.08 603.58 9.89 5,496.42 101-4-3120-4322 Postage 100.00 0.00 11.17 11.17 88.83 101-4-3120-4331 Travel, Conferences & Schools 5,100.00 405.00 405.00 7.94 4,695.00 101-4-3120-4359 Publishing 200.00 48.00 48.00 24.00 152.00 101-4-3120-4361 Insurance 19,000.00 0.00 4,413.75 23.23 14,586.25 101-4-3120-4389 Utilities 102,800.00 7,673.41 17,342.04 16.87 85,457.96 101-4-3120-4401 Bldg Repair/Maint Services 20,000.00 929.75 1,064.75 5.32 18,935.25 101-4-3120-4404 Equip Repair/Maint Services 9,000.00 199.90 3,590.45 39.89 5,409.55 101-4-3120-4409 Contractual Services 63,500.00 0.00 0.00 0.00 63,500.00 101-4-3120-4415 Equipment Rental 3,000.00 0.00 0.00 0.00 3,000.00 101-4-3120-4417 Uniform Rental 5,800.00 523.65 1,293.78 22.31 4,506.22 101-4-3120-4433 Dues & Subscriptions 350.00 0.00 280.00 80.00 70.00 101-4-3120-4437 Tates & Licenses 150.00 0.00 464.00 309.33 ( 314.00) 101-4-3120-4460 Equip Replacement Charge 100,950.00 8,412.50 25,237.50 25.00 75,712.50 TOTAL Other Services & Charges 336,600.00 18,575.29 54,754.02 16.27 281,845.98 Capital Outlay TOTAL Street Maintenance 1,310,000.00 102,003.32 229,101.89 17.49 1,080,898.11 Snow Removal ------------ Personal Services 101-4-3130-4101 Regular Pay 137,650.00 11,574.32 51,487.37 37.40 86,162.63 101-4-3130-4102 Overtime Pay 20,000.00 728.03 4,226.28 21.13 15,773.72 101-4-3130-4104 PERA 11,400.00 916.66 4,487.62 39.37 6,912.38 101-4-3130-4105 FICA 9,750.00 722.27 3,550.66 36.42 6,199.34 101-4-3130-4107 Medicare 2,300.00 168.91 830.40 36.10 1,469.60 101-4-3130-4108 Insurance 19,850.00 3,164.50 9,705.00 48.89 10,145.00 101-4-3130-4109 Workers Comp 8,150.00 1,982.75 3,965.50 48.66 4,184.50 TOTAL Personal Services 209,100.00 19,257.44 78,252.83 37.42 130,847.17 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Public Works 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-3130-4219 Operating Supplies 72,450.00 38,589.56 46,173.00 63.73 26,277.00 TOTAL Supplies 72,450.00 38,589.56 46,173.00 63.73 26,277.00 Other Services & Charges Capital Outlay TOTAL Snow Removal 281,550.00 57,847.00 124,425.83 44.19 157,124.17 Equipment Services Personal Services 101-4-3150-4101 Regular Pay 113,250.00 8,289.61 23,151.16 20.44 90,098.84 101-4-3150-4102 Overtime Pay 3,000.00 0.00 0.00 0.00 3,000.00 101-4-3150-4104 PERA 8,700.00 621.72 1,860.68 21.39 6,839.32 101-4-3150-4105 FICA 7,200.00 496.34 1,485.75 20.64 5,714.25 101-4-3150-4107 Medicare 1,700.00 116.08 347.48 20.44 1,352.52 101-4-3150-4108 Insurance 14,850.00 1,178.02 3,530.93 23.78 11,319.07 101-4-3150-4109 Workers Comp 3,150.00 797.25 1,594.50 50.62 1,555.50 TOTAL Personal Services 151,850.00 11,499.02 31,970.50 21.05 119,879.50 Supplies 101-4-3150-4212 Fuels & Lubes 5,100.00 ( 548.63) 939.51 18.42 4,160.49 101-4-3150-4219 Operating Supplies 11,150.00 819.19 2,148.32 19.27 9,001.68 101-4-3150-4221 Equipment Parts 3,000.00 ( 900.89) 315.81 10.53 2,684.19 TOTAL Supplies 19,250.00 ( 630.33) 3,403.64 17.68 15,846.36 Other Services & Charges 101-4-3150-4331 Travel, Conferences & Schools 3,000.00 0.00 0.00 0.00 3,000.00 101-4-3150-4404 Equip Repair/Maint Services 10,000.00 650.00 650.00 6.50 9,350.00 101-4-3150-4415 Equipment Rental 0.00 0.00 784.00 0.00 ( 784.00) 101-4-3150-4417 Uniform Rental 2,150.00 222.55 465.14 21.63 1,684.86 TOTAL Other Services & Charges 15,150.00 872.55 1,899.14 12.54 13,250.86 Capital Outlay TOTAL Equipment Services 186,250.00 11,741.24 37,273.28 20.01 148,976.72 Engineering 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Public Works 25.00% 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 166,250.00 12,786.37 35,801.82 21.53 130,448.18 101-4-3300-4104 PERA 12,450.00 958.98 2,876.94 23.11 9,573.06 101-4-3300-4105 FICA 10,300.00 813.90 2,441.70 23.71 7,858.30 101-4-3300-4107 Medicare 2,400.00 190.36 571.08 23.80 1,828.92 101-4-3300-4108 Insurance 7,200.00 600.00 1,800.00 25.00 5,400.00 101-4-3300-4109 Workers Comp 750.00 193.75 387.50 51.67 362.50 TOTAL Personal Services 199,350.00 15,543.36 43,879.04 22.01 155,470.96 Supplies 101-4-3300-4201 Office Supplies 300.00 5.86 14.26 4.75 285.74 101-4-3300-4212 Fuels & Lubes 950.00 41.53 115.79 12.19 834.21 101-4-3300-4219 Operating Supplies 3,000.00 358.66 773.66 25.79 2,226.34 TOTAL Supplies 4,250.00 406.05 903.71 21.26 3,346.29 Other Services & Charges 101-4-3300-4319 Other Professional Services 7,000.00 0.00 0.00 0.00 7,000.00 101-4-3300-4321 Telephone 1,400.00 62.42 62.42 4.46 1,337.58 101-4-3300-4322 Postage 300.00 0.00 48.70 16.23 251.30 101-4-3300-4331 Travel, Conferences & Schools 1,850.00 0.00 0.00 0.00 1,850.00 101-4-3300-4361 Insurance 100.00 0.00 22.25 22.25 77.75 101-4-3300-4404 Equip Repair/Maint Services 2,200.00 0.00 0.00 0.00 2,200.00 101-4-3300-4460 Equip Replacement Charge 1,500.00 125.00 375.00 25.00 1,125.00 TOTAL Other Services & Charges 14,350.00 187.42 508.37 3.54 13,841.63 Capital Outlay TOTAL Engineering 217,950.00 16,136.83 45,291.12 20.78 172,658.88 TOTAL Public Works 1,995,750.00 187,728.39 436,092.12 21.85 1,559,657.88 Parks Department Personal Services 101-4-5110-4101 Regular Pay 409,900.00 30,572.66 84,616.30 20.64 325,283.70 101-4-5110-4102 Overtime Pay 6,600.00 628.54 2,009.13 30.44 4,590.87 101-4-5110-4103 Part-time Pay 68,250.00 0.00 0.00 0.00 68,250.00 101-4-5110-4104 PERA 31,250.00 2,340.09 6,953.18 22.25 24,296.82 101-4-5110-4105 FICA 30,050.00 1,733.95 5,148.96 17.13 24,901.04 101-4-5110-4107 Medicare 7,050.00 405.52 1,204.20 17.08 5,845.80 101-4-5110-4108 Insurance 73,500.00 6,135.05 18,414.34 25.05 55,085.66 101-4-5110-4109 Workers Comp 12,000.00 3,098.75 6,197.50 51.65 5,802.50 TOTAL Personal Services 638,600.00 44,914.56 124,543.61 19.50 514,056.39 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Culture & Recreation 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-5110-4212 Fuels & Lubes 29,750.00 1,259.97 4,145.30 13.93 25,604.70 101-4-5110-4217 Uniform Allowance 3,800.00 226.45 1,241.71 32.68 2,558.29 101-4-5110-4219 Operating Supplies 94,900.00 7,039.61 12,767.28 13.45 82,132.72 101-4-5110-4221 Equipment Parts 26,000.00 1,882.68 5,641.24 21.70 20,358.76 TOTAL Supplies 154,450.00 10,408.71 23,795.53 15.41 130,654.47 Other Services & Charges 101-4-5110-4321 Telephone 4,900.00 ( 222.79) ( 155.25) 3.17- 5,055.25 101-4-5110-4322 Postage 100.00 0.00 0.00 0.00 100.00 101-4-5110-4331 Travel, Conferences & Schools 4,600.00 0.00 1,556.95 33.85 3,043.05 101-4-5110-4361 Insurance 30,250.00 0.00 7,346.00 24.28 22,904.00 101-4-5110-4389 Utilities 75,250.00 2,326.96 4,629.44 6.15 70,620.56 101-4-5110-4401 Bldg Repair/Maint Services 4,150.00 0.00 0.00 0.00 4,150.00 101-4-5110-4404 Equip Repair/Maint Services 17,650.00 0.00 0.00 0.00 17,650.00 101-4-5110-4409 Contractual Services 45,150.00 1,095.00 1,095.00 2.43 44,055.00 101-4-5110-4415 Equipment Rental 14,150.00 310.00 570.00 4.03 13,580.00 101-4-5110-4460 Equip Replacement Charge 48,850.00 4,070.83 12,212.49 25.00 36,637.51 TOTAL Other Services & Charges 245,050.00 7,580.00 27,254.63 11.12 217,795.37 Capital Outlay TOTAL Parks Department 1,038,100.00 62,903.27 175,593.77 16.91 862,506.23 Parks & Rec Admin Personal Services 101-4-5210-4101 Regular Pay 294,400.00 22,531.18 63,087.30 21.43 231,312.70 101-4-5210-4103 Part-time Pay 48,450.00 3,769.84 10,443.25 21.55 38,006.75 101-4-5210-4104 PERA 25,700.00 1,972.57 5,911.32 23.00 19,788.68 101-4-5210-4105 FICA 21,250.00 1,556.76 4,665.00 21.95 16,585.00 101-4-5210-4107 Medicare 4,950.00 364.11 1,091.09 22.04 3,858.91 101-4-5210-4108 Insurance 42,700.00 3,284.03 9,852.09 23.07 32,847.91 101-4-5210-4109 Workers Comp 3,650.00 901.75 1,803.50 49.41 1,846.50 TOTAL Personal Services 441,100.00 34,380.24 96,853.55 21.96 344,246.45 Supplies 101-4-5210-4219 Operating Supplies 10,200.00 1,244.54 2,802.40 27.47 7,397.60 TOTAL Supplies 10,200.00 1,244.54 2,802.40 27.47 7,397.60 Other Services & Charges 101-4-5210-4321 Telephone 6,400.00 ( 1,012.56) ( 1,012.56) 15.82- 7,412.56 101-4-5210-4322 Postage 5,300.00 1,442.84 1,563.19 29.49 3,736.81 101-4-5210-4331 Travel, Conferences & Schools 9,850.00 ( 135.00) 250.95 2.55 9,599.05 101-4-5210-4349 Advertising/Marketing 33,200.00 6,072.79 6,135.79 18.48 27,064.21 101-4-5210-4361 Insurance 400.00 0.00 94.00 23.50 306.00 101-4-5210-4389 Utilities 11,300.00 669.00 1,310.89 11.60 9,989.11 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Culture & Recreation 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE 101-4-5210-4401 Bldg Repair/Maint Services 17,200.00 1,474.96 3,389.96 19.71 13,810.04 101-4-5210-4404 Equip Repair/Maint Services 8,400.00 0.00 7,767.84 92.47 632.16 101-4-5210-4433 Dues & Subscriptions 2,350.00 70.00 2,280.00 97.02 70.00 TOTAL Other Services & Charges 94,400.00 8,582.03 21,780.06 23.07 72,619.94 Capital Outlay TOTAL Parks & Rec Admin 545,700.00 44,206.81 121,436.01 22.25 424,263.99 Recreation Programs Personal Services 101-4-5220-4103 Part-time Pay 82,000.00 2,276.17 8,745.78 10.67 73,254.22 101-4-5220-4105 FICA 4,300.00 141.13 574.16 13.35 3,725.84 101-4-5220-4107 Medicare 1,200.00 33.01 134.28 11.19 1,065.72 TOTAL Personal Services 87,500.00 2,450.31 9,454.22 10.80 78,045.78 Supplies 101-4-5220-4219 Operating Supplies 28,000.00 18.11 34.11 0.12 27,965.89 TOTAL Supplies 28,000.00 18.11 34.11 0.12 27,965.89 Other Services & Charges 101-4-5220-4409 Contractual Services 45,000.00 0.00 3,579.00 7.95 41,421.00 101-4-5220-4412 Building Rent 1,650.00 0.00 0.00 0.00 1,650.00 101-4-5220-4438 Credit Card Fees 3,600.00 167.54 301.24 8.37 3,298.76 TOTAL Other Services & Charges 50,250.00 167.54 3,880.24 7.72 46,369.76 TOTAL Recreation Programs 165,750.00 2,635.96 13,368.57 8.07 152,381.43 Concessions Personal Services Sr Citizen Programs ------------------- Personal Services 101-4-5510-4101 Regular Pay 118,900.00 8,942.41 25,038.74 21.06 93,861.26 101-4-5510-4103 Part-time Pay 3,150.00 132.00 608.40 19.31 2,541.60 101-4-5510-4104 PERA 8,900.00 670.68 2,012.04 22.61 6,887.96 101-4-5510-4105 FICA 7,550.00 534.60 1,619.81 21.45 5,930.19 101-4-5510-4107 Medicare 1,750.00 125.03 378.85 21.65 1,371.15 101-4-5510-4108 Insurance 21,650.00 1,787.01 5,361.03 24.76 16,288.97 101-4-5510-4109 Workers Comp 550.00 137.00 274.00 49.82 276.00 TOTAL Personal Services 162,450.00 12,328.73 35,292.87 21.73 127,157.13 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Culture & Recreation 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Supplies 101-4-5510-4219 Operating Supplies 16,500.00 669.11 5,530.94 33.52 10,969.06 TOTAL Supplies 16,500.00 669.11 5,530.94 33.52 10,969.06 Other Services & Charges 101-4-5510-4321 Telephone 2,400.00 86.84 260.52 10.86 2,139.48 101-4-5510-4322 Postage 3,000.00 0.00 884.70 29.49 2,115.30 101-4-5510-4331 Travel, Conferences & Schools 3,050.00 0.00 55.89 1.83 2,994.11 101-4-5510-4361 Insurance 1,400.00 0.00 334.50 23.89 1,065.50 101-4-5510-4389 Utilities 25,550.00 1,820.79 3,627.50 14.20 21,922.50 101-4-5510-4401 Bldg Repair/Maint Services 16,050.00 769.00 2,427.00 15.12 13,623.00 101-4-5510-4404 Equip Repair/Maint Services 100.00 0.00 0.00 0.00 100.00 101-4-5510-4409 Contractual Services 11,600.00 8.82 32.45 0.28 11,567.55 101-4-5510-4433 Dues & Subscriptions 850.00 0.00 307.24 36.15 542.76 TOTAL Other Services & Charges 64,000.00 2,685.45 7,929.80 12.39 56,070.20 Capital Outlay TOTAL Sr Citizen Programs 242,950.00 15,683.29 48,753.61 20.07 194,196.39 TOTAL Culture & Recreation 1,992,500.00 125,429.33 359,151.96 18.03 1,633,348.04 Economic Development -------------------- Personal Services 101-4-6210-4101 Regular Pay 0.00 ( 10,568.68) 10,568.68 0.00 ( 10,568.68) 101-4-6210-4103 Part-time Pay 0.00 ( 1,050.00) 1,050.00 0.00 ( 1,050.00) 101-4-6210-4104 PERA 0.00 ( 396.32) 1,218.96 0.00 ( 1,218.96) 101-4-6210-4105 FICA 0.00 ( 311.34) 1,027.02 0.00 ( 1,027.02) 101-4-6210-4107 Medicare 0.00 ( 72.83) 248.92 0.00 ( 248.92) 101-4-6210-4108 Insurance 0.00 ( 1,491.01) 1,491.01 0.00 ( 1,491.01) 101-4-6210-4109 Workers Comp 0.00 63.25 71.75 0.00 ( 71.75) TOTAL Personal Services 0.00 ( 13,826.93) 15,676.34 0.00 ( 15,676.34) Other Services & Charges 101-4-6210-4322 Postage 0.00 ( 5.96) 0.00 0.00 0.00 101-4-6210-4361 Insurance 0.00 ( 22.25) 0.00 0.00 0.00 101-4-6210-4440 Miscellaneous 0.00 ( 77.27) ( 53.54) 0.00 53.54 TOTAL Other Services & Charges 0.00 ( 105.48) ( 53.54) 0.00 53.54 TOTAL Economic Development 0.00 ( 13,932.41) 15,622.80 0.00 ( 15,622.80) 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 101-GENERAL FUND Economic Development 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Energy City Personal Services 101-4-6220-4101 Regular Pay 9,000.00 676.34 1,893.75 21.04 7,106.25 101-4-6220-4104 PERA 700.00 50.72 152.16 21.74 547.84 101-4-6220-4105 FICA 550.00 41.94 125.82 22.88 424.18 101-4-6220-4107 Medicare 150.00 9.80 29.40 19.60 120.60 101-4-6220-4108 Insurance 1,100.00 71.29 213.87 19.44 886.13 TOTAL Personal Services 11,500.00 850.09 2,415.00 21.00 9,085.00 Supplies 101-4-6220-4219 Operating Supplies 1,800.00 0.00 0.00 0.00 1,800.00 TOTAL Supplies 1,800.00 0.00 0.00 0.00 1,800.00 Other Services & Charges 101-4-6220-4319 Other Professional Services 500.00 0.00 0.00 0.00 500.00 101-4-6220-4331 Travel, Conferences & Schools 1,000.00 0.00 0.00 0.00 1,000.00 101-4-6220-4359 Publishing 1,500.00 0.00 0.00 0.00 1,500.00 TOTAL Other Services & Charges 3,000.00 0.00 0.00 0.00 3,000.00 TOTAL Energy City 16,300.00 850.09 2,415.00 14.82 13,885.00 TOTAL Economic Development 16,300.00 ( 13,082.32) 18,037.80 110.66 ( 1,737.80) Transfers Out ------------- Transfers Out TOTAL EXPENDITURES 13,884,800.00 1,067,782.47 2,920,415.96 21.03 10,964,384.04 REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 898,000.55) ( 2,375,915.43) 2,375,915.43 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 221-ICE ARENA FINANCIAL SUMMARY 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE REVENUE SUMMARY Ice Arena 628,100.00 76,668.74 221,334.78 35.24 406,765.22 Hockey 43,500.00 3,260.00 49,530.00 113.86 ( 6,030.00) Skating 38,400.00 386.00 9,930.00 25.86 28,470.00 Concessions 80,750.00 5,933.00 33,209.34 41.13 47,540.66 TOTAL REVENUES 790,750.00 86,247.74 314,004.12 39.71 476,745.88 EXPENDITURE SUMMARY Culture & Recreation Ice Arena 845,600.00 41,286.15 115,798.19 13.69 729,801.81 Hockey 22,000.00 6,233.50 6,495.25 29.52 15,504.75 Skating 28,850.00 2,165.11 5,220.26 18.09 23,629.74 Arena Concessions 58,250.00 3,820.45 17,504.59 30.05 40,745.41 TOTAL Culture & Recreation 954,700.00 53,505.21 145,018.29 15.19 809,681.71 TOTAL EXPENDITURES 954,700.00 53,505.21 145,018.29 15.19 809,681.71 REVENUES OVER/(UNDER) EXPENDITURES ( 163,950.00) 32,742.53 168,985.83 ( 332,935.83) 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 221-ICE ARENA 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Charges for Services 221-3-0000-3464 Ice Rental 530,250.00 75,535.87 173,165.10 32.66 357,084.90 221-3-0000-3465 Admissions 25,850.00 0.00 8,432.50 32.62 17,417.50 221-3-0000-3466 Dry Floor Events 14,300.00 1,111.00 4,027.00 28.16 10,273.00 221-3-0000-3468 Skate Sharpening 4,300.00 252.00 1,200.00 27.91 3,100.00 221-3-0000-3475 Building Rent 2,600.00 0.00 0.00 0.00 2,600.00 221-3-0000-3482 Advertising fee 22,400.00 120.84 362.52 1.62 22,037.48 TOTAL Charges for Services 599,700.00 77,019.71 187,187.12 31.21 412,512.88 Other Revenue 221-3-0000-3621 Interest Income 2,500.00 0.00 153.51 6.14 2,346.49 221-3-0000-3622 Vending Machines 15,000.00 1,109.74 4,169.88 27.80 10,830.12 221-3-0000-3626 Contributions 6,700.00 0.00 2,930.00 43.73 3,770.00 221-3-0000-3629 Miscellaneous Revenue 3,900.00 ( 1,460.71) ( 780.98) 20.03- 4,680.98 TOTAL Other Revenue 28,100.00 ( 350.97) 6,472.41 23.03 21,627.59 Sales 221-3-0000-3791 ATM Revenue 300.00 0.00 75.25 25.08 224.75 TOTAL Sales 300.00 0.00 75.25 25.08 224.75 Other Financing Sources 221-3-0000-3910 Sale of Assets 0.00 0.00 27,600.00 0.00 ( 27,600.00) TOTAL Other Financing Sources 0.00 0.00 27,600.00 0.00 ( 27,600.00) Transfers In TOTAL Ice Arena 628,100.00 76,668.74 221,334.78 35.24 406,765.22 Hockey Charges for Services 221-3-5410-3461 Recreation Fees 43,500.00 3,260.00 49,530.00 113.86 ( 6,030.00) TOTAL Charges for Services 43,500.00 3,260.00 49,530.00 113.86 ( 6,030.00) Other Revenue TOTAL Hockey 43,500.00 3,260.00 49,530.00 113.86 ( 6,030.00) 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 221-ICE ARENA 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE Skating Charges for Services 221-3-5420-3461 Recreation Fees 35,800.00 ( 14.00) 7,810.00 21.82 27,990.00 221-3-5420-3465 Admissions 2,600.00 0.00 0.00 0.00 2,600.00 TOTAL Charges for Services 38,400.00 ( 14.00) 7,810.00 20.34 30,590.00 Other Revenue 221-3-5420-3629 Miscellaneous Revenue 0.00 400.00 2,120.00 0.00 ( 2,120.00) TOTAL Other Revenue 0.00 400.00 2,120.00 0.00 ( 2,120.00) TOTAL Skating 38,400.00 386.00 9,930.00 25.86 28,470.00 Concessions Charges for Services 221-3-5430-3467 Concessions 80,750.00 5,933.00 33,209.34 41.13 47,540.66 TOTAL Charges for Services 80,750.00 5,933.00 33,209.34 41.13 47,540.66 TOTAL Concessions 80,750.00 5,933.00 33,209.34 41.13 47,540.66 TOTAL REVENUE 790,750.00 86,247.74 314,004.12 39.71 476,745.88 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 221-ICE ARENA 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Ice Arena Personal Services 221-4-5400-4101 Regular Pay 179,950.00 10,368.82 34,452.88 19.15 145,497.12 221-4-5400-4103 Part-time Pay 61,900.00 5,731.75 19,220.21 31.05 42,679.79 221-4-5400-4104 PERA 18,150.00 1,124.71 3,927.80 21.64 14,222.20 221-4-5400-4105 FICA 15,050.00 1,010.76 3,534.23 23.48 11,515.77 221-4-5400-4107 Medicare 3,550.00 236.38 826.56 23.28 2,723.44 221-4-5400-4108 Insurance 28,800.00 1,531.02 6,395.06 22.21 22,404.94 221-4-5400-4109 Workers Comp 9,350.00 2,366.75 4,733.50 50.63 4,616.50 TOTAL Personal Services 316,750.00 22,370.19 73,090.24 23.08 243,659.76 Supplies 221-4-5400-4212 Fuels & Lubes 300.00 24.03 60.83 20.28 239.17 221-4-5400-4217 Uniform Allowance 850.00 0.00 ( 13.10) 1.54- 863.10 221-4-5400-4219 Operating Supplies 49,600.00 1,420.59 4,013.86 8.09 45,586.14 221-4-5400-4255 Soft Drinks/Misc 6,950.00 0.00 738.26 10.62 6,211.74 221-4-5400-4259 Other Merchandise For Resale 900.00 0.00 0.00 0.00 900.00 TOTAL Supplies 58,600.00 1,444.62 4,799.85 8.19 53,800.15 Other Services & Charges 221-4-5400-4321 Telephone 3,350.00 ( 102.16) 77.32 2.31 3,272.68 221-4-5400-4322 Postage 150.00 0.00 15.56 10.37 134.44 221-4-5400-4331 Travel, Conferences & Schools 1,900.00 0.00 0.00 0.00 1,900.00 221-4-5400-4359 Publishing 5,450.00 0.00 225.00 4.13 5,225.00 221-4-5400-4361 Insurance 4,950.00 0.00 1,144.75 23.13 3,805.25 221-4-5400-4389 Utilities 161,950.00 14,401.96 28,017.11 17.30 133,932.89 221-4-5400-4401 Bldg Repair/Maint Services 29,250.00 2,944.41 7,501.97 25.65 21,748.03 221-4-5400-4409 Contractual Services 2,650.00 0.00 0.00 0.00 2,650.00 221-4-5400-4415 Equipment Rental 3,700.00 227.13 681.39 18.42 3,018.61 221-4-5400-4433 Dues & Subscriptions 550.00 0.00 245.00 44.55 305.00 TOTAL Other Services & Charges 213,900.00 17,471.34 37,908.10 17.72 175,991.90 Capital Outlay 221-4-5400-4520 Buildings & Structures 128,500.00 0.00 0.00 0.00 128,500.00 221-4-5400-4560 Equipment 127,850.00 0.00 0.00 0.00 127,850.00 TOTAL Capital Outlay 256,350.00 0.00 0.00 0.00 256,350.00 Transfers Out TOTAL Ice Arena 845,600.00 41,286.15 115,798.19 13.69 729,801.81 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 221-ICE ARENA Culture & Recreation 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Hockey Personal Services 221-4-5410-4103 Part-time Pay 850.00 0.00 0.00 0.00 850.00 221-4-5410-4105 FICA 50.00 0.00 0.00 0.00 50.00 TOTAL Personal Services 900.00 0.00 0.00 0.00 900.00 Supplies 221-4-5410-4219 Operating Supplies 12,400.00 6,233.50 6,233.50 50.27 6,166.50 TOTAL Supplies 12,400.00 6,233.50 6,233.50 50.27 6,166.50 Other Services & Charges 221-4-5410-4409 Contractual Services 5,700.00 0.00 0.00 0.00 5,700.00 221-4-5410-4438 Credit Card Fees 3,000.00 0.00 261.75 8.73 2,738.25 TOTAL Other Services & Charges 8,700.00 0.00 261.75 3.01 8,438.25 TOTAL Hockey 22,000.00 6,233.50 6,495.25 29.52 15,504.75 Skating Personal Services 221-4-5420-4103 Part-time Pay 17,800.00 847.42 2,827.36 15.88 14,972.64 221-4-5420-4104 PERA 1,000.00 0.00 0.00 0.00 1,000.00 221-4-5420-4105 FICA 1,100.00 52.53 179.51 16.32 920.49 221-4-5420-4107 Medicare 250.00 12.28 41.99 16.80 208.01 TOTAL Personal Services 20,150.00 912.23 3,048.86 15.13 17,101.14 Supplies 221-4-5420-4219 Operating Supplies 4,900.00 24.33 24.33 0.50 4,875.67 TOTAL Supplies 4,900.00 24.33 24.33 0.50 4,875.67 Other Services & Charges 221-4-5420-4359 Publishing 1,200.00 0.00 0.00 0.00 1,200.00 221-4-5420-4409 Contractual Services 1,600.00 0.00 774.18 48.39 825.82 221-4-5420-4438 Credit Card Fees 1,000.00 1,228.55 1,372.89 137.29 ( 372.89) TOTAL Other Services & Charges 3,800.00 1,228.55 2,147.07 56.50 1,652.93 TOTAL Skating 28,850.00 2,165.11 5,220.26 18.09 23,629.74 Arena Concessions 4-11-2016 10:08 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 221-ICE ARENA Culture & Recreation 25.00% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE Personal Services 221-4-5430-4103 Part-time Pay 21,300.00 1,741.30 8,246.68 38.72 13,053.32 221-4-5430-4104 PERA 1,600.00 0.00 0.00 0.00 1,600.00 221-4-5430-4105 FICA 1,300.00 107.94 565.19 43.48 734.81 221-4-5430-4107 Medicare 300.00 25.26 132.21 44.07 167.79 TOTAL Personal Services 24,500.00 1,874.50 8,944.08 36.51 15,555.92 Supplies 221-4-5430-4219 Operating Supplies 3,250.00 33.72 117.07 3.60 3,132.93 221-4-5430-4259 Other Merchandise For Resale 30,500.00 1,912.23 8,443.44 27.68 22,056.56 TOTAL Supplies 33,750.00 1,945.95 8,560.51 25.36 25,189.49 TOTAL Arena Concessions 58,250.00 3,820.45 17,504.59 30.05 40,745.41 TOTAL Culture & Recreation 954,700.00 53,505.21 145,018.29 15.19 809,681.71 TOTAL EXPENDITURES 954,700.00 53,505.21 145,018.29 15.19 809,681.71 REVENUES OVER/(UNDER) EXPENDITURES ( 163,950.00) 32,742.53 168,985.83 ( 332,935.83) CITY OF ELK RIVER ENTERPRISE FUNDS-BUDGET TO ACTUAL MONTH ENDED MARCH,2016 Liquor', Sewer Garbage, Stormwater, Current Year to Date Budget %of Current Year to Date Budget %of Current Year to Date Budget %of Current Year to Date Budget %of Budget Actual Variance Budget Budget Actual Variance Budget Budget Actual Variance Budget Budget Actual Variance Budget Sales and cost of sales: Sales $ 6,934,000 $ 1,414,516 $ 5,519,484 20.40% Cost of sales (4,957,300) (728,063) (4,229,237) 14.69% Gross profit 1,976,700 686,453 1,290,247 34.73% Operating revenues: User charges $ - $ - $ - 0.00% $ 1,860,000 $ 305,589 $ 1,554,411 16.43% $ 1,310,000 $ 221,090 $ 1,088,910 16.88% $ 420,000 $ 74,707 $ 345,293 17.79% Delinquency collections - - - 0.00% 1,300 - 1,300 0.00% 13,000 - 13,000 0.00% - - - Other 1,700 734 966 43.18% 2,000 - 2,000 0.00% 3,500 416 3,084 11.89% - - - Total operating revenues 1,700 734 966 43.18% 1,863,300 305,589 1,557,711 16.40% 1,326,500 221,506 1,104,994 16.70% 420,000 74,707 345,293 17.79% Operating expenses: Personal services 659,850 143,777 516,073 21.79% 532,650 117,579 415,071 22.07% 22,900 4,830 18,070 21.09% 80,650 17,600 63,050 21.82% Supplies 53,700 6,928 46,772 12.90% 217,800 16,076 201,724 7.38% 6,300 - 6,300 0.00% 7,000 - 7,000 0.00% Other service charges 231,950 33,488 198,462 14.44% 517,200 59,527 457,673 11.51% 1,340,700 222,158 1,118,542 16.57% 403,150 66,898 336,252 16.59% Depreciation* 123,000 123,000 0.00% 1,424,350 - 1,424,350 0.00% - - - 0.00% 433,750 - 433,750 0.00% Total operating expenses 1,068,500 184,193 884,307 17.24% 2,692,000 193,182 2,498,818 7.18% 1,369,900 226,988 1,142,912 16.57% 924,550 84,498 840,052 9.14% Operating income(loss) 909,900 502,994 406,906 55.28% (828,700) 112,407 (941,107) -13.56% (43,400) (5,482) (37,918) 12.63% (504,550) (9,791) (494,759) 1.94% Nonoperating revenues(expenses): Interest income 25,000 1,201 23,799 4.80% 80,000 2,853 77,147 3.57% 6,250 222 6,028 3.55% 1,500 89 1,411 5.93% Grant revenue - - - 0.00% 800,000 45,807 754,193 5.73% - - - 0.00% - - - 0.00% Interest expense - - - 0.00% (272,400) (23,033) (249,367) 8.46% - - - 0.00% - - - 0.00% Total nonoperating revenues(expenses) 25,000 1,201 23,799 4.80% 607,600 25,627 581,973 4.22% 6,250 222 6,028 3.55% 1,500 89 1,411 5.93% Income(loss)before contributions and transfers 934,900 504,195 430,705 53.93% (221,100) 138,034 (359,134) -62.43% (37,150) (5,260) (31,890) 14.16% (503,050) (9,702) (493,348) 1.93% Contributions-connection fees - - - 0.00% 492,700 33,250 459,450 6.75% - - - 0.00% 51,500 5,506 45,994 10.69% Transfers in - - - 0.00% - - - 0.00% 36,600 - 36,600 0.00% - - - Transfers out (718,950) - (718,950) 0.00% (100,000) - (100,000) 0.00% 45,000 - 45,000 0.00% - - - NET INCOME(LOSS) 215,950 504,195 288,245 233.48% 171,600 171,284 316 99.82% 45,550 5,260 40,290 11.55% 4519550 4,196 447,354 0.93% Items reclassified to balance sheet at year end: Capital Outlay (5,012,000) (672,589) (4,339,411) 13.42% (180,000) - Bond Payment (400,000) (400,000) - 100.00% Revenues over/(under)expenditures 215,950 504,195 (288,245) (5,240,400) (901,305) (4,339,095) (45,550) (5,260) (40,290) (631,550) (4,196) (447,354) *Recorded ar yearend 4-11-2016 10:10 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS 0 F: MARCH 31ST, 2016 BEGINNING CURRENT CURRENT FUND ACCOUNT* ACCOUNT NAME BALANCE ACTIVITY BALANCE CLAIM ON CASH 002-1010 Cash - Section 125 20,352.31 2,753.91 23,106.22 101-1010 Cash - General Fund 5,007,490.25 ( 903,773.08) 4,103,717.17 211-1010 Cash - Library 405,283.91 23,395.51 428,679.42 221-1010 Cash - Ice Arena 380,114.07 41,191.37 421,305.44 225-1010 Cash - Park Dedication 75,800.82 ( 24,390.00) 51,410.82 228-1010 Cash - Landfill 525,176.36 ( 6,385.84) 518,790.52 231-1010 Cash - Landfill Const Debris 727,628.53 0.00 727,628.53 240-1010 Cash - Micro Loan Fund 964,453.19 4,875.35 969,328.54 241-1010 Cash - Federal DEED 200,000.00 0.00 200,000.00 242-1010 Cash - State DEED 99,404.50 1,886.49 101,290.99 245-1010 Cash - Development Fund 867,240.93 ( 1,000.00) 866,240.93 290-1010 Cash - Capital Outlay Reserve 993,078.80 ( 21,846.63) 971,232.17 291-1010 Cash - Insurance Reserve 272,759.14 ( 8,148.48) 264,610.66 292-1010 Cash - Govt Bldgs Reserve 1,217,178.70 49,837.69 1,267,016.39 294-1010 Cash - Drug Forfeiture 15,326.93 204.61 15,531.54 295-1010 Cash - Severance Pay Reserve 71,089.58 0.00 71,089.58 296-1010 Cash - GRE Reserve 2,981,867.56 0.00 2,981,867.56 313-1010 Cash - 2007C/2012B GO Bonds 114,797.16 0.00 114,797.16 333-1010 Cash - 2010A GO Cap Imp Bonds 265,294.37 0.00 265,294.37 344-1010 Cash - 2006C Cap Imp Bonds Lby 0.00 ( 450.00) ( 450.00) 401-1010 Cash - Pavement Mgmt 3,344,449.85 ( 482,525.63) 2,861,924.22 403-1010 Cash - Street Improvement 1,787,683.43 ( 476.00) 1,787,207.43 406-1010 Cash - City Wide Trunk Util 3,779,328.64 0.00 3,779,328.64 410-1010 Cash - Equipment Replacement 742,484.60 5,561.07 748,045.67 426-1010 Cash - YMCA 136,904.18 0.00 136,904.18 440-1010 Cash - Park Improvement 362,606.49 100.00 362,706.49 463-1010 Cash - TIF #23 Pref Powder 620.95 0.00 620.95 602-1010 Cash - Wastewater Treatment 6,331,538.38 ( 217,797.82) 6,113,740.56 603-1010 Cash - Liquor 3,027,532.67 89,728.19 3,117,260.86 605-1010 Cash - Garbage 548,310.00 ( 2,415.42) 545,894.58 607-1010 Cash - Storm Water 187,934.88 30,434.29 218,369.17 801-1010 Cash - Interest 83,638.76 29,713.06 113,351.82 821-1010 Cash - Developer Escrow 109,091.84 2,126.00 111,217.84 TOTAL CLAIM ON CASH 35,646,461.78 ( 1,387,401.36) 34,259,060.42 CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 73,556,011.25 ( 475,457.55) 73,080,553.70 999-1001 PY BANK ACCOUNT (66,291,739.03) ( 911,943.81) (67,203,682.84) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56 SUBTOTAL CASH IN BANK - POOLED CASH 35,646,461.78 ( 1,387,401.36) 34,259,060.42 WAGES PAYABLE TOTAL CASH IN BANK - POOLED CASH 35,646,461.78 ( 1,387,401.36) 34,259,060.42