Loading...
INFORMATION #1 12-19-2016 Information �i of Memorandum Memorandum cElk River TO: Mayor and City Council From: Lori Ziemer,Finance Director Date: December 19, 2016 Subject: November 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 November, actual revenues (except for property taxes and state aids) and expenditures should run about 92% 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: ■ Excluding transfers in,revenue collections are about 60% of budget,with the second half property taxes to be collected in December. ■ Licenses and permits collections are 95% of budget estimates,with building-related permit collections slightly below estimates at 88% of budget as of the end of November. ■ Intergovernmental revenue collections and charges for services are 94% of budget estimates. ■ Fines and forfeits collections,which lag a month,are 105% of budget estimates. Expenditures: ■ Total departmental expenditures are 83% of budget and most departments are within or below budget. ■ The quarterly renewal premium for workers comp insurance is reflected in many departments' expenditures. p0WIeI1 0 NAWREJ 2016 Monthly Expenditures $16,000 $14,000 $12,000 0 Z $10,000 Ln p $8,000 x ~ $6,000 $4,000 $2,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Actual $831 $1,859 $2,920 $3,933 $4,945 $5,993 $7,450 $8,533 $9,532 $10,554 $11,568 Budget $1,157 $2,314 $3,471 $4,628 $5,785 $6,942 $8,099 $9,2571'$10,414 $11,571 $12,728 $13,885 ICE ARENA For the month ending November,revenues of$610,799 exceed expenditures of$519,546 by $91,253. Ice rental revenues are at$390,477 or 74% of budget estimates,which will continue to ramp up with the start of the high school hockey season. ATTACHMENTS ■ General Fund Revenue & Expense Report ■ Enterprise Funds-Budget to Actual ■ Cash Report-All Funds 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND FINANCIAL SUMMARY 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ REVENUE SUMMARY General Fund 13,884,800.00 299,351.91 8,821,976.19 63.54 5,062,823.81 TOTAL REVENUES 13,884,800.00 299,351.91 8,821,976.19 63.54 5,062,823.81 ============= ============= ============= ======= ============= EXPENDITURE SUMMARY General Government Mayor & Council 145,850.00 5,211.12 130,516.58 89.49 15,333.42 Cable TV 109,700.00 7,340.84 83,010.77 75.67 26,689.23 Administrative Services 605,500.00 42,287.88 512,264.00 84.60 93,236.00 Human Resources 178,400.00 12,346.05 139,715.02 78.32 38,684.98 Elections 20,500.00 17,570.99 40,584.10 197.97 ( 20,084.10) Finance 583,550.00 28,835.52 498,204.17 85.37 85,345.83 Information Technology 346,350.00 24,140.23 291,760.38 84.24 54,589.62 Legal 214,600.00 29,951.30 183,763.55 85.63 30,836.45 Community Development 213,750.00 16,633.55 188,844.10 88.35 24,905.90 Planning 297,400.00 21,743.91 235,283.60 79.11 62,116.40 City Hall Maintenance 623,650.00 45,552.56 532,824.27 85.44 90,825.73 Contingency ( 95,000.00) 0.00 0.00 0.00 ( 95,000.00) TOTAL General Government 3,244,250.00 251,613.95 2,836,770.54 87.44 407,479.46 Public Safety Police Administration 713,700.00 58,954.12 613,470.22 85.96 100,229.78 Patrol 2,530,150.00 182,726.72 2,020,333.57 79.85 509,816.43 Investigations 994,000.00 70,067.99 810,707.96 81.56 183,292.04 Police Support Services 558,600.00 43,935.03 448,393.27 80.27 110,206.73 Police Reserves 23,250.00 545.00 11,175.91 48.07 12,074.09 Public safety building 156,000.00 16,410.90 135,496.70 86.86 20,503.30 Fire Administration 475,750.00 34,848.25 410,350.01 86.25 65,399.99 Fire Operations 381,300.00 25,760.70 346,572.79 90.89 34,727.21 Emergency Management 24,800.00 2,981.66 13,888.00 56.00 10,912.00 Building Safety 647,750.00 48,619.32 551,769.16 85.18 95,980.84 Code Enforcement 91,600.00 6,738.45 78,377.83 85.57 13,222.17 Environmental 39,100.00 2,866.64 35,058.66 89.66 4,041.34 TOTAL Public Safety 6,636,000.00 494,454.78 5,475,594.08 82.51 1,160,405.92 Public Works Street Maintenance 1,310,000.00 106,553.53 1,099,679.96 83.95 210,320.04 Snow Removal 281,550.00 2,171.96 153,177.48 54.41 128,372.52 Equipment Services 186,250.00 15,916.02 150,471.39 80.79 35,778.61 Engineering 217,950.00 16,555.68 184,312.64 84.57 33,637.36 TOTAL Public Works 1,995,750.00 141,197.19 1,587,641.47 79.55 408,108.53 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND FINANCIAL SUMMARY 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Culture & Recreation Parks Department 1,038,100.00 74,845.81 851,797.16 82.05 186,302.84 Parks & Rec Admin 545,700.00 42,389.99 448,989.87 82.28 96,710.13 Recreation Programs 165,750.00 7,330.24 140,677.21 84.87 25,072.79 Sr Citizen Programs 242,950.00 18,658.11 200,692.73 82.61 42,257.27 TOTAL Culture & Recreation 1,992,500.00 143,224.15 1,642,156.97 82.42 350,343.03 Economic Development Economic Development 0.00 ( 15,441.70) 15,210.46 0.00 ( 15,210.46) Energy City 16,300.00 905.69 11,026.85 67.65 5,273.15 TOTAL Economic Development 16,300.00 ( 14,536.01) 26,237.31 160.97 ( 9,937.31) General _____________ _____________ _____________ _______ _____________ TOTAL EXPENDITURES 13,884,800.00 1,015,954.06 11,568,400.37 83.32 2,316,399.63 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 716,602.15)( 2,746,424.18) 2,746,424.18 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND 91.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 9,596,850.00 0.00 4,993,540.13 52.03 4,603,309.87 101-3-0000-3112 Delinquent Ad Valorem Taxes 0.00 0.00 25,697.32 0.00 ( 25,697.32) 101-3-0000-3121 Gravel Tax 127,000.00 0.00 116,074.78 91.40 10,925.22 101-3-0000-3131 Penalties/Interest 0.00 0.00 2,276.37 0.00 ( 2,276.37) TOTAL Taxes 9,723,850.00 0.00 5,137,588.60 52.83 4,586,261.40 Licenses & Permits 101-3-0000-3211 Liquor License 67,500.00 0.00 65,795.00 97.47 1,705.00 101-3-0000-3212 Amusement License 1,050.00 600.00 600.00 57.14 450.00 101-3-0000-3213 Cigarette License 3,100.00 2,250.00 2,650.00 85.48 450.00 101-3-0000-3214 Rental License 35,000.00 3,360.00 56,931.00 162.66 ( 21,931.00) 101-3-0000-3216 Mining License 23,000.00 0.00 22,135.34 96.24 864.66 101-3-0000-3217 Garbage Hauler License 1,600.00 495.00 810.00 50.63 790.00 101-3-0000-3218 Other Business License/Permit 12,000.00 5,450.00 11,830.00 98.58 170.00 101-3-0000-3229 NPDES Permit 10,000.00 1,050.00 11,550.00 115.50 ( 1,550.00) 101-3-0000-3231 Building Permit 385,000.00 38,714.05 285,233.68 74.09 99,766.32 101-3-0000-3232 Plumbing/Heating Permit 92,000.00 6,390.76 135,193.56 146.95 ( 43,193.56) 101-3-0000-3233 Permit Surcharge 300.00 1,335.17 5,993.17 1,997.72 ( 5,693.17) 101-3-0000-3235 Animal License 6,500.00 820.00 3,795.00 58.38 2,705.00 101-3-0000-3236 Parking Permit 1,500.00 0.00 355.55 23.70 1,144.45 101-3-0000-3237 Other Non-Business Lic/Permit 8,000.00 4,060.00 12,770.00 159.63 ( 4,770.00) TOTAL Licenses & Permits 646,550.00 64,524.98 615,642.30 95.22 30,907.70 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 2,878.12 71.95 1,121.88 101-3-0000-3324 PERA Aid 14,000.00 0.00 6,992.00 49.94 7,008.00 101-3-0000-3325 Police 2% Aid 230,000.00 0.00 239,795.40 104.26 ( 9,795.40) 101-3-0000-3326 Police Training Reimb 10,000.00 1,000.00 9,754.52 97.55 245.48 101-3-0000-3329 State Crime Prevention Grant 25,250.00 ( 16,061.26) 10,936.11 43.31 14,313.89 101-3-0000-3330 Other State Grants 3,300.00 0.00 900.00 27.27 2,400.00 TOTAL Intergovernmental Rev 288,350.00 ( 15,061.26) 271,256.15 94.07 17,093.85 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 16,000.00 2,480.00 33,470.00 209.19 ( 17,470.00) 101-3-0000-3413 Plan Check Fee 135,000.00 20,518.46 121,597.42 90.07 13,402.58 101-3-0000-3415 Special Assessment Search 500.00 0.00 920.00 184.00 ( 420.00) 101-3-0000-3417 Copies 1,700.00 119.79 2,776.88 163.35 ( 1,076.88) 101-3-0000-3418 Other General Govt Services 4,500.00 435.00 4,752.50 105.61 ( 252.50) 101-3-0000-3430 Lockout Fees 7,500.00 440.00 6,180.00 82.40 1,320.00 101-3-0000-3431 Police Services 6,000.00 350.00 9,287.48 154.79 ( 3,287.48) 101-3-0000-3432 School Liaison 123,600.00 0.00 123,624.00 100.02 ( 24.00) 101-3-0000-3434 Animal Impound Fee 3,000.00 500.00 4,250.00 141.67 ( 1,250.00) 101-3-0000-3436 Fire Contracts 220,000.00 0.00 234,655.72 106.66 ( 14,655.72) 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-3-0000-3437 Fire Services 3,000.00 35.85 1,212.35 40.41 1,787.65 101-3-0000-3438 Fire Inspections 10,000.00 0.00 0.00 0.00 10,000.00 101-3-0000-3450 Maintenance Facility Rent 14,500.00 1,156.50 12,721.50 87.73 1,778.50 101-3-0000-3451 Street Services 35,000.00 4,023.96 19,766.24 56.47 15,233.76 101-3-0000-3452 Engineering Services Reimb 148,950.00 91,905.92 129,855.26 87.18 19,094.74 101-3-0000-3461 Recreation Fees 96,000.00 ( 84.00) 68,821.54 71.69 27,178.46 101-3-0000-3462 Sr Center Activities 29,000.00 4,613.00 33,095.96 114.12 ( 4,095.96) 101-3-0000-3472 Park Use Fee 24,400.00 3,833.80 23,745.30 97.32 654.70 101-3-0000-3475 Building Rent 2,400.00 200.00 2,200.00 91.67 200.00 101-3-0000-3483 Sewer Inspection Fee 9,000.00 865.00 7,765.00 86.28 1,235.00 101-3-0000-3484 Contractor License Check 1,000.00 55.00 685.00 68.50 315.00 TOTAL Charges for Services 891,050.00 131,448.28 841,382.15 94.43 49,667.85 Fines & Forfeits 101-3-0000-3510 Court Fines 117,000.00 10,791.60 129,406.21 110.60 ( 12,406.21) 101-3-0000-3511 Parking Fines 10,000.00 340.00 4,380.00 43.80 5,620.00 TOTAL Fines & Forfeits 127,000.00 11,131.60 133,786.21 105.34 ( 6,786.21) Special Assessments _____________ _____________ _____________ _______ _____________ Other Revenue 101-3-0000-3621 Interest Income 85,000.00 0.00 74,223.14 87.32 10,776.86 101-3-0000-3625 Refunds & Reimbursements 101,000.00 8,307.50 1,260.76 1.25 99,739.24 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 1,024.98 7,118.58 94.91 381.42 TOTAL Other Revenue 213,500.00 9,332.48 98,602.48 46.18 114,897.52 Transfers In 101-3-0000-3925 Transfer-Landfill 55,000.00 0.00 55,000.00 100.00 0.00 101-3-0000-3926 Transfer-Capital Outlay Reserv 212,950.00 0.00 12,950.00 6.08 200,000.00 101-3-0000-3929 Transfer-NSP/RDF Reserve 45,000.00 0.00 45,000.00 100.00 0.00 101-3-0000-3930 Transfer-Development 62,600.00 0.00 62,600.00 100.00 0.00 101-3-0000-3942 Transfer-WWTS 100,000.00 0.00 100,000.00 100.00 0.00 101-3-0000-3943 Transfer-Liquor 438,950.00 0.00 438,950.00 100.00 0.00 101-3-0000-3944 Transfer-Garbage 45,000.00 0.00 45,000.00 100.00 0.00 101-3-0000-3945 Transfer-Utilities 970,450.00 97,975.83 899,668.30 92.71 70,781.70 101-3-0000-3946 Transfer-Stormwater 5,000.00 0.00 5,000.00 100.00 0.00 101-3-0000-3948 Transfer-EDA 34,800.00 0.00 34,800.00 100.00 0.00 101-3-0000-3949 Transfer-HRA 24,750.00 0.00 24,750.00 100.00 0.00 TOTAL Transfers In 1,994,500.00 97,975.83 1,723,718.30 86.42 270,781.70 _____________________________________________________________________________ TOTAL General Fund 13,884,800.00 299,351.91 8,821,976.19 63.54 5,062,823.81 ___________________________________________________________________________________________________________________ TOTAL REVENUE 13,884,800.00 299,351.91 8,821,976.19 63.54 5,062,823.81 ============= ============= ============= ======= ============= 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Mayor & Council =============== Personal Services 101-4-1110-4103 Part-time Pay 38,500.00 3,208.32 35,290.28 91.66 3,209.72 101-4-1110-4104 PERA 1,900.00 117.09 1,190.49 62.66 709.51 101-4-1110-4105 FICA 2,400.00 90.93 814.18 33.92 1,585.82 101-4-1110-4107 Medicare 550.00 55.24 520.42 94.62 29.58 101-4-1110-4109 Workers Comp 100.00 11.25 73.50 73.50 26.50 TOTAL Personal Services 43,450.00 3,482.83 37,888.87 87.20 5,561.13 Supplies 101-4-1110-4201 Office Supplies 1,000.00 0.62 508.51 50.85 491.49 TOTAL Supplies 1,000.00 0.62 508.51 50.85 491.49 Other Services & Charges 101-4-1110-4319 Other Professional Services 10,400.00 0.00 9,683.09 93.11 716.91 101-4-1110-4322 Postage 200.00 0.00 30.61 15.31 169.39 101-4-1110-4331 Travel, Conferences & Schools 2,100.00 48.60 1,327.92 63.23 772.08 101-4-1110-4359 Publishing 3,700.00 0.00 751.72 20.32 2,948.28 101-4-1110-4361 Insurance 39,600.00 0.00 37,135.00 93.78 2,465.00 101-4-1110-4433 Dues & Subscriptions 18,550.00 0.00 18,701.00 100.81 ( 151.00) 101-4-1110-4440 Miscellaneous 26,850.00 1,679.07 24,489.86 91.21 2,360.14 TOTAL Other Services & Charges 101,400.00 1,727.67 92,119.20 90.85 9,280.80 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Mayor & Council 145,850.00 5,211.12 130,516.58 89.49 15,333.42 Cable TV ======== Personal Services 101-4-1120-4101 Regular Pay 63,350.00 4,875.21 55,089.79 86.96 8,260.21 101-4-1120-4103 Part-time Pay 17,950.00 690.00 8,502.31 47.37 9,447.69 101-4-1120-4104 PERA 6,100.00 417.39 4,853.73 79.57 1,246.27 101-4-1120-4105 FICA 5,050.00 314.18 3,672.95 72.73 1,377.05 101-4-1120-4107 Medicare 1,200.00 73.47 858.99 71.58 341.01 101-4-1120-4108 Insurance 14,250.00 861.00 9,471.00 66.46 4,779.00 101-4-1120-4109 Workers Comp 350.00 66.75 351.00 100.29 ( 1.00) TOTAL Personal Services 108,250.00 7,298.00 82,799.77 76.49 25,450.23 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND General Government 91.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 500.00 42.84 211.00 42.20 289.00 TOTAL Supplies 500.00 42.84 211.00 42.20 289.00 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 Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Cable TV 109,700.00 7,340.84 83,010.77 75.67 26,689.23 Administrative Services ======================= Personal Services 101-4-1210-4101 Regular Pay 388,750.00 29,903.15 337,905.65 86.92 50,844.35 101-4-1210-4103 Part-time Pay 46,000.00 3,398.60 36,674.48 79.73 9,325.52 101-4-1210-4104 PERA 32,600.00 2,497.62 28,590.37 87.70 4,009.63 101-4-1210-4105 FICA 26,950.00 1,643.34 23,498.24 87.19 3,451.76 101-4-1210-4107 Medicare 6,300.00 493.81 5,605.02 88.97 694.98 101-4-1210-4108 Insurance 36,600.00 2,160.00 25,930.88 70.85 10,669.12 101-4-1210-4109 Workers Comp 1,900.00 473.75 1,936.25 101.91 ( 36.25) TOTAL Personal Services 539,100.00 40,570.27 460,140.89 85.35 78,959.11 Supplies 101-4-1210-4201 Office Supplies 7,300.00 359.43 1,966.21 26.93 5,333.79 TOTAL Supplies 7,300.00 359.43 1,966.21 26.93 5,333.79 Other Services & Charges 101-4-1210-4319 Other Professional Services 11,600.00 89.96 6,968.28 60.07 4,631.72 101-4-1210-4321 Telephone 1,500.00 211.34 1,397.74 93.18 102.26 101-4-1210-4322 Postage 800.00 0.00 827.77 103.47 ( 27.77) 101-4-1210-4331 Travel, Conferences & Schools 10,550.00 54.92 3,687.97 34.96 6,862.03 101-4-1210-4334 Car Allowance 4,800.00 400.00 4,400.00 91.67 400.00 101-4-1210-4359 Publishing 13,000.00 0.00 13,044.00 100.34 ( 44.00) 101-4-1210-4361 Insurance 50.00 0.00 55.50 111.00 ( 5.50) 101-4-1210-4404 Equip Repair/Maint Services 14,950.00 0.00 17,235.04 115.28 ( 2,285.04) 101-4-1210-4433 Dues & Subscriptions 1,850.00 601.96 2,540.60 137.33 ( 690.60) TOTAL Other Services & Charges 59,100.00 1,358.18 50,156.90 84.87 8,943.10 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Administrative Services 605,500.00 42,287.88 512,264.00 84.60 93,236.00 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND General Government 91.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 121,250.00 9,464.05 105,363.05 86.90 15,886.95 101-4-1220-4104 PERA 9,100.00 709.80 8,040.58 88.36 1,059.42 101-4-1220-4105 FICA 7,500.00 571.16 6,475.18 86.34 1,024.82 101-4-1220-4107 Medicare 1,750.00 133.58 1,514.36 86.53 235.64 101-4-1220-4108 Insurance 14,900.00 1,260.00 13,860.12 93.02 1,039.88 101-4-1220-4109 Workers Comp 550.00 135.00 543.00 98.73 7.00 TOTAL Personal Services 155,050.00 12,273.59 135,796.29 87.58 19,253.71 Supplies 101-4-1220-4201 Office Supplies 1,350.00 18.46 360.08 26.67 989.92 TOTAL Supplies 1,350.00 18.46 360.08 26.67 989.92 Other Services & Charges 101-4-1220-4319 Other Professional Services 1,250.00 0.00 842.95 67.44 407.05 101-4-1220-4322 Postage 600.00 0.00 322.02 53.67 277.98 101-4-1220-4331 Travel, Conferences & Schools 18,200.00 54.00 506.68 2.78 17,693.32 101-4-1220-4404 Equip Repair/Maint 1,200.00 0.00 1,082.00 90.17 118.00 101-4-1220-4433 Dues & Subscriptions 750.00 0.00 805.00 107.33 ( 55.00) TOTAL Other Services & Charges 22,000.00 54.00 3,558.65 16.18 18,441.35 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Human Resources 178,400.00 12,346.05 139,715.02 78.32 38,684.98 Elections ========= Personal Services 101-4-1230-4103 Part-time Pay 15,000.00 16,088.88 32,252.26 215.02 ( 17,252.26) TOTAL Personal Services 15,000.00 16,088.88 32,252.26 215.02 ( 17,252.26) Supplies 101-4-1230-4219 Operating Supplies 1,300.00 57.65 321.51 24.73 978.49 TOTAL Supplies 1,300.00 57.65 321.51 24.73 978.49 Other Services & Charges 101-4-1230-4322 Postage 50.00 0.00 170.61 341.22 ( 120.61) 101-4-1230-4331 Travel, Conferences & Schools 150.00 24.46 59.72 39.81 90.28 101-4-1230-4359 Publishing 350.00 600.00 680.00 194.29 ( 330.00) 101-4-1230-4404 Equip Repair/Maint Services 3,300.00 0.00 6,300.00 190.91 ( 3,000.00) 101-4-1230-4415 Equipment Rental 350.00 800.00 800.00 228.57 ( 450.00) TOTAL Other Services & Charges 4,200.00 1,424.46 8,010.33 190.72 ( 3,810.33) 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Elections 20,500.00 17,570.99 40,584.10 197.97 ( 20,084.10) Finance ======= Personal Services 101-4-1310-4101 Regular Pay 317,750.00 16,640.68 257,255.25 80.96 60,494.75 101-4-1310-4102 Overtime Pay 0.00 0.00 3,374.70 0.00 ( 3,374.70) 101-4-1310-4103 Part-time Pay 53,400.00 4,022.04 52,123.52 97.61 1,276.48 101-4-1310-4104 PERA 27,850.00 1,549.72 21,181.98 76.06 6,668.02 101-4-1310-4105 FICA 23,000.00 1,230.40 19,105.48 83.07 3,894.52 101-4-1310-4107 Medicare 5,400.00 287.77 4,468.21 82.74 931.79 101-4-1310-4108 Insurance 38,350.00 2,335.00 30,092.33 78.47 8,257.67 101-4-1310-4109 Workers Comp 1,650.00 380.25 1,629.00 98.73 21.00 TOTAL Personal Services 467,400.00 26,445.86 389,230.47 83.28 78,169.53 Supplies 101-4-1310-4201 Office Supplies 4,500.00 1,555.24 3,376.56 75.03 1,123.44 TOTAL Supplies 4,500.00 1,555.24 3,376.56 75.03 1,123.44 Other Services & Charges 101-4-1310-4301 Audit Fees 20,000.00 0.00 20,100.00 100.50 ( 100.00) 101-4-1310-4319 Other Professional Services 54,000.00 0.00 54,615.00 101.14 ( 615.00) 101-4-1310-4321 Telephone 350.00 39.99 387.80 110.80 ( 37.80) 101-4-1310-4322 Postage 2,600.00 0.00 2,809.33 108.05 ( 209.33) 101-4-1310-4331 Travel, Conferences & Schools 4,150.00 0.00 375.90 9.06 3,774.10 101-4-1310-4359 Publishing 200.00 0.00 337.00 168.50 ( 137.00) 101-4-1310-4404 Equip Repair/Maint Services 21,750.00 0.00 19,170.66 88.14 2,579.34 101-4-1310-4433 Dues & Subscriptions 1,600.00 0.00 1,495.00 93.44 105.00 101-4-1310-4438 Credit Card Fees 5,500.00 698.83 5,209.70 94.72 290.30 101-4-1310-4440 Miscellaneous 1,500.00 95.60 1,096.75 73.12 403.25 TOTAL Other Services & Charges 111,650.00 834.42 105,597.14 94.58 6,052.86 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Finance 583,550.00 28,835.52 498,204.17 85.37 85,345.83 Information Technology ====================== 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Services 101-4-1350-4101 Regular Pay 188,650.00 14,624.73 164,617.10 87.26 24,032.90 101-4-1350-4102 Overtime Pay 0.00 0.00 140.13 0.00 ( 140.13) 101-4-1350-4104 PERA 14,150.00 1,096.86 12,572.89 88.85 1,577.11 101-4-1350-4105 FICA 11,700.00 824.60 9,542.07 81.56 2,157.93 101-4-1350-4107 Medicare 2,750.00 192.85 2,231.62 81.15 518.38 101-4-1350-4108 Insurance 32,350.00 2,728.00 29,976.26 92.66 2,373.74 101-4-1350-4109 Workers Comp 850.00 208.75 843.25 99.21 6.75 TOTAL Personal Services 250,450.00 19,675.79 219,923.32 87.81 30,526.68 Supplies 101-4-1350-4219 Operating Supplies 15,800.00 381.66 7,763.83 49.14 8,036.17 TOTAL Supplies 15,800.00 381.66 7,763.83 49.14 8,036.17 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 566.00 3,948.50 49.36 4,051.50 101-4-1350-4321 Telephone 2,550.00 160.84 229.78 9.01 2,320.22 101-4-1350-4331 Travel, Conferences & Schools 8,950.00 0.00 2,202.60 24.61 6,747.40 101-4-1350-4404 Equip Repair/Maint Services 60,600.00 3,355.94 57,692.35 95.20 2,907.65 TOTAL Other Services & Charges 80,100.00 4,082.78 64,073.23 79.99 16,026.77 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Information Technology 346,350.00 24,140.23 291,760.38 84.24 54,589.62 Legal ===== Other Services & Charges 101-4-1400-4304 Legal Fees 214,600.00 29,951.30 183,763.55 85.63 30,836.45 TOTAL Other Services & Charges 214,600.00 29,951.30 183,763.55 85.63 30,836.45 ___________________________________________________________________________________________________________________ TOTAL Legal 214,600.00 29,951.30 183,763.55 85.63 30,836.45 Community Development ===================== Personal Services 101-4-1500-4101 Regular Pay 170,850.00 13,141.03 148,539.71 86.94 22,310.29 101-4-1500-4102 Overtime Pay 0.00 41.96 41.96 0.00 ( 41.96) 101-4-1500-4104 PERA 12,800.00 988.73 11,340.77 88.60 1,459.23 101-4-1500-4105 FICA 10,600.00 791.39 9,115.12 85.99 1,484.88 101-4-1500-4107 Medicare 2,500.00 185.09 2,131.76 85.27 368.24 101-4-1500-4108 Insurance 11,050.00 1,260.00 13,860.12 125.43 ( 2,810.12) 101-4-1500-4109 Workers Comp 750.00 186.00 760.50 101.40 ( 10.50) TOTAL Personal Services 208,550.00 16,594.20 185,789.94 89.09 22,760.06 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND General Government 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1500-4201 Office Supplies 1,100.00 4.36 805.33 73.21 294.67 TOTAL Supplies 1,100.00 4.36 805.33 73.21 294.67 Other Services & Charges 101-4-1500-4321 Telephone 700.00 34.99 591.70 84.53 108.30 101-4-1500-4331 Travel, Conferences & Schools 2,850.00 0.00 1,050.13 36.85 1,799.87 101-4-1500-4433 Dues & Subscriptions 550.00 0.00 607.00 110.36 ( 57.00) TOTAL Other Services & Charges 4,100.00 34.99 2,248.83 54.85 1,851.17 ___________________________________________________________________________________________________________________ TOTAL Community Development 213,750.00 16,633.55 188,844.10 88.35 24,905.90 Planning ======== Personal Services 101-4-1510-4101 Regular Pay 207,100.00 16,148.40 168,317.68 81.27 38,782.32 101-4-1510-4104 PERA 15,550.00 1,211.12 12,797.26 82.30 2,752.74 101-4-1510-4105 FICA 12,850.00 931.35 9,817.38 76.40 3,032.62 101-4-1510-4107 Medicare 3,000.00 217.81 2,295.99 76.53 704.01 101-4-1510-4108 Insurance 39,100.00 2,087.00 21,187.09 54.19 17,912.91 101-4-1510-4109 Workers Comp 950.00 174.25 943.75 99.34 6.25 TOTAL Personal Services 278,550.00 20,769.93 215,359.15 77.31 63,190.85 Supplies 101-4-1510-4201 Office Supplies 2,500.00 7.47 1,986.85 79.47 513.15 101-4-1510-4212 Fuels & Lubes 300.00 5.11 68.66 22.89 231.34 101-4-1510-4219 Operating Supplies 2,150.00 0.00 1,949.07 90.65 200.93 TOTAL Supplies 4,950.00 12.58 4,004.58 80.90 945.42 Other Services & Charges 101-4-1510-4321 Telephone 350.00 25.75 314.37 89.82 35.63 101-4-1510-4322 Postage 1,500.00 0.00 1,124.62 74.97 375.38 101-4-1510-4331 Travel, Conferences & Schools 1,500.00 0.00 1,388.00 92.53 112.00 101-4-1510-4359 Publishing 8,000.00 888.00 10,949.00 136.86 ( 2,949.00) 101-4-1510-4361 Insurance 50.00 0.00 55.50 111.00 ( 5.50) 101-4-1510-4404 Equip Repair/Maint Services 1,500.00 0.00 1,425.98 95.07 74.02 101-4-1510-4433 Dues & Subscriptions 750.00 0.00 476.75 63.57 273.25 101-4-1510-4440 Miscellaneous 250.00 47.65 185.65 74.26 64.35 TOTAL Other Services & Charges 13,900.00 961.40 15,919.87 114.53 ( 2,019.87) Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Planning 297,400.00 21,743.91 235,283.60 79.11 62,116.40 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND General Government 91.67% 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 24,962.23 296,011.63 86.30 46,988.37 101-4-1600-4102 Overtime Pay 3,500.00 0.00 1,365.89 39.03 2,134.11 101-4-1600-4103 Part-time Pay 3,450.00 286.38 2,424.24 70.27 1,025.76 101-4-1600-4104 PERA 26,000.00 1,893.65 22,873.29 87.97 3,126.71 101-4-1600-4105 FICA 21,700.00 1,559.09 18,924.91 87.21 2,775.09 101-4-1600-4107 Medicare 5,100.00 364.61 4,425.97 86.78 674.03 101-4-1600-4108 Insurance 40,550.00 3,802.50 41,774.65 103.02 ( 1,224.65) 101-4-1600-4109 Workers Comp 11,500.00 2,752.50 11,454.00 99.60 46.00 TOTAL Personal Services 454,800.00 35,620.96 399,254.58 87.79 55,545.42 Supplies 101-4-1600-4212 Fuels & Lubes 2,000.00 165.78 1,874.30 93.72 125.70 101-4-1600-4217 Uniform Allowance 2,400.00 559.65 1,062.43 44.27 1,337.57 101-4-1600-4219 Operating Supplies 30,400.00 496.04 24,519.36 80.66 5,880.64 TOTAL Supplies 34,800.00 1,221.47 27,456.09 78.90 7,343.91 Other Services & Charges 101-4-1600-4321 Telephone 11,700.00 1,135.59 10,115.88 86.46 1,584.12 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 0.00 532.57 26.63 1,467.43 101-4-1600-4361 Insurance 5,350.00 0.00 5,138.50 96.05 211.50 101-4-1600-4389 Utilities 75,750.00 5,554.76 53,418.04 70.52 22,331.96 101-4-1600-4401 Bldg Repair/Maint Services 32,800.00 1,773.95 31,936.48 97.37 863.52 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 2,704.13 91.67 245.87 TOTAL Other Services & Charges 134,050.00 8,710.13 106,113.60 79.16 27,936.40 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL City Hall Maintenance 623,650.00 45,552.56 532,824.27 85.44 90,825.73 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 251,613.95 2,836,770.54 87.44 407,479.46 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Police Administration ===================== Personal Services 101-4-2110-4101 Regular Pay 373,250.00 27,638.24 311,827.75 83.54 61,422.25 101-4-2110-4102 Overtime Pay 0.00 39.86 59.79 0.00 ( 59.79) 101-4-2110-4104 PERA 54,450.00 4,110.53 47,278.63 86.83 7,171.37 101-4-2110-4105 FICA 4,300.00 225.54 2,501.48 58.17 1,798.52 101-4-2110-4107 Medicare 5,400.00 377.53 4,348.14 80.52 1,051.86 101-4-2110-4108 Insurance 35,950.00 2,988.00 32,761.93 91.13 3,188.07 101-4-2110-4109 Workers Comp 61,500.00 18,658.25 64,431.50 104.77 ( 2,931.50) TOTAL Personal Services 534,850.00 54,037.95 463,209.22 86.61 71,640.78 Supplies 101-4-2110-4201 Office Supplies 10,350.00 351.16 7,870.79 76.05 2,479.21 101-4-2110-4217 Uniform Allowance 2,950.00 148.83 2,594.12 87.94 355.88 101-4-2110-4219 Operating Supplies 1,300.00 171.33 3,012.62 231.74 ( 1,712.62) TOTAL Supplies 14,600.00 671.32 13,477.53 92.31 1,122.47 Other Services & Charges 101-4-2110-4319 Other Professional Services 6,900.00 11.25 2,945.03 42.68 3,954.97 101-4-2110-4321 Telephone 31,900.00 2,668.52 24,041.89 75.37 7,858.11 101-4-2110-4322 Postage 2,400.00 0.00 1,562.24 65.09 837.76 101-4-2110-4331 Travel, Conferences & Schools 10,200.00 1,205.08 7,456.64 73.10 2,743.36 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 40,752.50 98.32 697.50 101-4-2110-4404 Equip Repair/Maint Services 65,050.00 0.00 55,655.17 85.56 9,394.83 101-4-2110-4433 Dues & Subscriptions 5,500.00 360.00 4,239.00 77.07 1,261.00 101-4-2110-4437 Taxes & Licenses 350.00 0.00 131.00 37.43 219.00 TOTAL Other Services & Charges 164,250.00 4,244.85 136,783.47 83.28 27,466.53 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Administration 713,700.00 58,954.12 613,470.22 85.96 100,229.78 Patrol ====== Personal Services 101-4-2120-4101 Regular Pay 1,642,400.00 119,637.67 1,344,907.74 81.89 297,492.26 101-4-2120-4102 Overtime Pay 90,000.00 6,626.93 51,777.30 57.53 38,222.70 101-4-2120-4104 PERA 280,650.00 20,454.91 230,355.00 82.08 50,295.00 101-4-2120-4107 Medicare 23,800.00 1,669.85 18,684.46 78.51 5,115.54 101-4-2120-4108 Insurance 176,550.00 13,853.00 163,131.64 92.40 13,418.36 TOTAL Personal Services 2,213,400.00 162,242.36 1,808,856.14 81.72 404,543.86 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-2120-4212 Fuels & Lubes 88,000.00 5,438.69 65,475.67 74.40 22,524.33 101-4-2120-4217 Uniform Allowance 35,100.00 704.39 12,092.01 34.45 23,007.99 101-4-2120-4219 Operating Supplies 75,550.00 6,419.74 47,836.44 63.32 27,713.56 101-4-2120-4221 Equipment Parts 23,300.00 1,614.09 10,889.97 46.74 12,410.03 TOTAL Supplies 221,950.00 14,176.91 136,294.09 61.41 85,655.91 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 28,300.00 2,465.00 25,708.51 90.84 2,591.49 101-4-2120-4404 Equip Repair/Maint Services 20,700.00 79.95 7,632.33 36.87 13,067.67 101-4-2120-4433 Dues & Subscriptions 650.00 0.00 455.00 70.00 195.00 101-4-2120-4460 Equip Replacement Charge 45,150.00 3,762.50 41,387.50 91.67 3,762.50 TOTAL Other Services & Charges 94,800.00 6,307.45 75,183.34 79.31 19,616.66 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Patrol 2,530,150.00 182,726.72 2,020,333.57 79.85 509,816.43 Investigations ============== Personal Services 101-4-2130-4101 Regular Pay 676,050.00 48,729.60 569,319.94 84.21 106,730.06 101-4-2130-4102 Overtime Pay 50,000.00 2,364.93 29,909.16 59.82 20,090.84 101-4-2130-4104 PERA 117,600.00 8,277.32 94,720.34 80.54 22,879.66 101-4-2130-4107 Medicare 9,200.00 695.56 7,427.90 80.74 1,772.10 101-4-2130-4108 Insurance 95,250.00 7,341.07 73,927.84 77.61 21,322.16 TOTAL Personal Services 948,100.00 67,408.48 775,305.18 81.77 172,794.82 Supplies 101-4-2130-4217 Uniform Allowance 6,800.00 402.72 5,211.26 76.64 1,588.74 101-4-2130-4219 Operating Supplies 7,600.00 134.95 6,707.32 88.25 892.68 TOTAL Supplies 14,400.00 537.67 11,918.58 82.77 2,481.42 Other Services & Charges 101-4-2130-4319 Other Professional Services 6,500.00 391.84 1,449.84 22.31 5,050.16 101-4-2130-4331 Travel, Conferences & Schools 9,700.00 520.00 8,783.00 90.55 917.00 101-4-2130-4433 Dues & Subscriptions 2,100.00 110.00 1,151.36 54.83 948.64 101-4-2130-4460 Equip Replacement Charge 13,200.00 1,100.00 12,100.00 91.67 1,100.00 TOTAL Other Services & Charges 31,500.00 2,121.84 23,484.20 74.55 8,015.80 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Investigations 994,000.00 70,067.99 810,707.96 81.56 183,292.04 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Public Safety 91.67% 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 25,798.58 281,274.28 82.02 61,675.72 101-4-2150-4102 Overtime Pay 10,000.00 695.68 3,784.59 37.85 6,215.41 101-4-2150-4103 Part-time Pay 37,600.00 3,049.60 30,319.63 80.64 7,280.37 101-4-2150-4104 PERA 29,300.00 2,215.78 24,101.61 82.26 5,198.39 101-4-2150-4105 FICA 24,200.00 1,776.04 20,141.24 83.23 4,058.76 101-4-2150-4107 Medicare 5,650.00 415.36 4,717.09 83.49 932.91 101-4-2150-4108 Insurance 60,900.00 4,779.00 52,569.18 86.32 8,330.82 TOTAL Personal Services 510,600.00 38,730.04 416,907.62 81.65 93,692.38 Supplies 101-4-2150-4201 Office Supplies 1,000.00 183.14 289.72 28.97 710.28 101-4-2150-4217 Uniform Allowance 4,500.00 294.07 3,310.06 73.56 1,189.94 101-4-2150-4219 Operating Supplies 18,900.00 997.67 10,398.27 55.02 8,501.73 TOTAL Supplies 24,400.00 1,474.88 13,998.05 57.37 10,401.95 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 4,800.00 1,995.11 3,666.43 76.38 1,133.57 101-4-2150-4404 Equip Repair/Maint Services 2,250.00 0.00 1,749.92 77.77 500.08 101-4-2150-4409 Contractual Services 10,000.00 1,190.00 6,086.25 60.86 3,913.75 101-4-2150-4433 Dues & Subscriptions 550.00 45.00 485.00 88.18 65.00 101-4-2150-4460 Equip Replacement Charge 6,000.00 500.00 5,500.00 91.67 500.00 TOTAL Other Services & Charges 23,600.00 3,730.11 17,487.60 74.10 6,112.40 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Support Services 558,600.00 43,935.03 448,393.27 80.27 110,206.73 Police Reserves =============== Personal Services 101-4-2160-4103 Part-time Pay 5,500.00 0.00 1,386.12 25.20 4,113.88 101-4-2160-4105 FICA 350.00 0.00 87.37 24.96 262.63 101-4-2160-4107 Medicare 100.00 0.00 20.43 20.43 79.57 TOTAL Personal Services 5,950.00 0.00 1,493.92 25.11 4,456.08 Supplies 101-4-2160-4217 Uniform Allowance 5,500.00 0.00 1,370.30 24.91 4,129.70 101-4-2160-4219 Operating Supplies 6,500.00 0.00 6,371.69 98.03 128.31 TOTAL Supplies 12,000.00 0.00 7,741.99 64.52 4,258.01 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Public Safety 91.67% 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 545.00 1,090.00 51.90 1,010.00 101-4-2160-4331 Travel, Conferences & Schools 3,200.00 0.00 850.00 26.56 2,350.00 TOTAL Other Services & Charges 5,300.00 545.00 1,940.00 36.60 3,360.00 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Reserves 23,250.00 545.00 11,175.91 48.07 12,074.09 Public safety building ====================== Personal Services _____________ _____________ _____________ _______ _____________ Supplies 101-4-2190-4219 Operating Supplies 16,600.00 2,240.38 16,589.00 99.93 11.00 TOTAL Supplies 16,600.00 2,240.38 16,589.00 99.93 11.00 Other Services & Charges 101-4-2190-4361 Insurance 5,200.00 0.00 4,984.00 95.85 216.00 101-4-2190-4389 Utilities 97,500.00 7,366.04 76,406.59 78.37 21,093.41 101-4-2190-4401 Bldg Repair/Maint Services 36,700.00 6,804.48 37,517.11 102.23 ( 817.11) TOTAL Other Services & Charges 139,400.00 14,170.52 118,907.70 85.30 20,492.30 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Public safety building 156,000.00 16,410.90 135,496.70 86.86 20,503.30 Fire Administration =================== Personal Services 101-4-2310-4101 Regular Pay 233,350.00 18,207.29 202,501.37 86.78 30,848.63 101-4-2310-4104 PERA 34,450.00 2,680.94 30,423.91 88.31 4,026.09 101-4-2310-4105 FICA 2,400.00 223.88 2,149.52 89.56 250.48 101-4-2310-4106 Other Retirement Contributions 30,000.00 0.00 30,000.00 100.00 0.00 101-4-2310-4107 Medicare 3,400.00 257.94 2,847.65 83.75 552.35 101-4-2310-4108 Insurance 29,100.00 2,534.29 27,384.19 94.10 1,715.81 101-4-2310-4109 Workers Comp 8,800.00 2,625.50 9,290.00 105.57 ( 490.00) TOTAL Personal Services 341,500.00 26,529.84 304,596.64 89.19 36,903.36 Supplies 101-4-2310-4201 Office Supplies 3,150.00 35.25 2,968.88 94.25 181.12 101-4-2310-4212 Fuels & Lubes 2,500.00 240.97 3,308.04 132.32 ( 808.04) 101-4-2310-4217 Uniform Allowance 6,500.00 0.00 1,861.85 28.64 4,638.15 101-4-2310-4219 Operating Supplies 1,000.00 993.67 2,949.94 294.99 ( 1,949.94) 101-4-2310-4221 Equipment Parts 700.00 0.00 0.00 0.00 700.00 TOTAL Supplies 13,850.00 1,269.89 11,088.71 80.06 2,761.29 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Public Safety 91.67% 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 1,697.50 16.98 8,302.50 101-4-2310-4321 Telephone 3,100.00 355.14 2,801.05 90.36 298.95 101-4-2310-4322 Postage 500.00 0.00 705.29 141.06 ( 205.29) 101-4-2310-4331 Travel, Conferences & Schools 7,500.00 184.08 2,160.69 28.81 5,339.31 101-4-2310-4359 Publishing 750.00 149.00 609.00 81.20 141.00 101-4-2310-4361 Insurance 12,000.00 0.00 10,587.50 88.23 1,412.50 101-4-2310-4389 Utilities 22,250.00 1,133.97 14,236.65 63.98 8,013.35 101-4-2310-4401 Bldg Repair/Maint Services 5,500.00 743.00 9,876.35 179.57 ( 4,376.35) 101-4-2310-4404 Equip Repair/Maint Services 2,950.00 0.00 840.00 28.47 2,110.00 101-4-2310-4433 Dues & Subscriptions 2,050.00 0.00 1,834.00 89.46 216.00 101-4-2310-4460 Equip Replacement Charge 53,800.00 4,483.33 49,316.63 91.67 4,483.37 TOTAL Other Services & Charges 120,400.00 7,048.52 94,664.66 78.63 25,735.34 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Administration 475,750.00 34,848.25 410,350.01 86.25 65,399.99 Fire Operations =============== Personal Services 101-4-2320-4103 Part-time Pay 169,700.00 10,424.49 147,125.53 86.70 22,574.47 101-4-2320-4105 FICA 10,500.00 641.92 8,862.64 84.41 1,637.36 101-4-2320-4107 Medicare 2,450.00 150.09 2,072.68 84.60 377.32 101-4-2320-4108 Insurance 0.00 117.29 592.85 0.00 ( 592.85) 101-4-2320-4109 Workers Comp 27,400.00 8,986.75 30,733.00 112.16 ( 3,333.00) TOTAL Personal Services 210,050.00 20,320.54 189,386.70 90.16 20,663.30 Supplies 101-4-2320-4201 Office Supplies 300.00 107.77 144.99 48.33 155.01 101-4-2320-4212 Fuels & Lubes 8,700.00 558.35 6,048.25 69.52 2,651.75 101-4-2320-4217 Uniform Allowance 9,300.00 0.00 5,361.15 57.65 3,938.85 101-4-2320-4219 Operating Supplies 72,900.00 1,600.97 71,738.05 98.41 1,161.95 101-4-2320-4221 Equipment Parts 7,450.00 837.31 15,557.17 208.82 ( 8,107.17) TOTAL Supplies 98,650.00 3,104.40 98,849.61 100.20 ( 199.61) Other Services & Charges 101-4-2320-4321 Telephone 4,650.00 300.69 3,313.93 71.27 1,336.07 101-4-2320-4331 Travel, Conferences & Schools 26,000.00 1,516.49 15,021.86 57.78 10,978.14 101-4-2320-4404 Equip Repair/Maint Services 36,300.00 518.58 35,553.44 97.94 746.56 101-4-2320-4409 Contractual Services 5,650.00 0.00 4,447.25 78.71 1,202.75 TOTAL Other Services & Charges 72,600.00 2,335.76 58,336.48 80.35 14,263.52 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Operations 381,300.00 25,760.70 346,572.79 90.89 34,727.21 Emergency Management ==================== Personal Services _____________ _____________ _____________ _______ _____________ Supplies 101-4-2330-4219 Operating Supplies 7,100.00 1,471.00 4,706.66 66.29 2,393.34 TOTAL Supplies 7,100.00 1,471.00 4,706.66 66.29 2,393.34 Other Services & Charges 101-4-2330-4331 Travel, Conferences & Schools 10,400.00 0.00 752.00 7.23 9,648.00 101-4-2330-4389 Utilities 3,650.00 310.46 3,449.85 94.52 200.15 101-4-2330-4404 Equip Repair/Maint Services 3,450.00 1,200.20 4,719.49 136.80 ( 1,269.49) 101-4-2330-4433 Dues & Subscriptions 200.00 0.00 260.00 130.00 ( 60.00) TOTAL Other Services & Charges 17,700.00 1,510.66 9,181.34 51.87 8,518.66 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Emergency Management 24,800.00 2,981.66 13,888.00 56.00 10,912.00 Building Safety =============== Personal Services 101-4-2410-4101 Regular Pay 450,050.00 35,056.03 393,461.86 87.43 56,588.14 101-4-2410-4104 PERA 40,300.00 3,130.54 35,794.51 88.82 4,505.49 101-4-2410-4105 FICA 23,250.00 1,644.68 18,883.45 81.22 4,366.55 101-4-2410-4107 Medicare 6,550.00 462.53 5,314.68 81.14 1,235.32 101-4-2410-4108 Insurance 78,600.00 6,588.00 72,468.30 92.20 6,131.70 101-4-2410-4109 Workers Comp 2,050.00 397.50 1,959.75 95.60 90.25 TOTAL Personal Services 600,800.00 47,279.28 527,882.55 87.86 72,917.45 Supplies 101-4-2410-4201 Office Supplies 7,700.00 35.64 2,731.83 35.48 4,968.17 101-4-2410-4212 Fuels & Lubes 5,000.00 456.09 5,390.45 107.81 ( 390.45) 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 143.28 3,060.59 32.05 6,489.41 TOTAL Supplies 24,000.00 635.01 11,182.87 46.60 12,817.13 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Public Safety 91.67% 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 346.20 2,263.08 40.05 3,386.92 101-4-2410-4322 Postage 700.00 0.00 335.63 47.95 364.37 101-4-2410-4331 Travel, Conferences & Schools 3,800.00 88.00 2,500.40 65.80 1,299.60 101-4-2410-4361 Insurance 450.00 0.00 500.50 111.22 ( 50.50) 101-4-2410-4404 Equip Repair/Maint Services 5,600.00 0.00 2,465.00 44.02 3,135.00 101-4-2410-4433 Dues & Subscriptions 3,500.00 0.00 1,660.00 47.43 1,840.00 101-4-2410-4460 Equip Replacement Charge 3,250.00 270.83 2,979.13 91.67 270.87 TOTAL Other Services & Charges 22,950.00 705.03 12,703.74 55.35 10,246.26 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Safety 647,750.00 48,619.32 551,769.16 85.18 95,980.84 Code Enforcement ================ Personal Services 101-4-2420-4101 Regular Pay 70,300.00 5,408.00 61,110.40 86.93 9,189.60 101-4-2420-4102 Overtime Pay 0.00 0.00 12.68 0.00 ( 12.68) 101-4-2420-4104 PERA 5,250.00 405.60 4,665.35 88.86 584.65 101-4-2420-4105 FICA 4,350.00 347.50 4,004.31 92.05 345.69 101-4-2420-4107 Medicare 1,000.00 81.27 936.49 93.65 63.51 101-4-2420-4108 Insurance 3,600.00 300.00 3,300.06 91.67 299.94 101-4-2420-4109 Workers Comp 300.00 57.75 303.00 101.00 ( 3.00) TOTAL Personal Services 84,800.00 6,600.12 74,332.29 87.66 10,467.71 Supplies 101-4-2420-4212 Fuels & Lubes 2,000.00 83.92 1,041.38 52.07 958.62 101-4-2420-4217 Uniform Allowance 350.00 0.00 216.65 61.90 133.35 101-4-2420-4219 Operating Supplies 1,100.00 0.00 288.33 26.21 811.67 TOTAL Supplies 3,450.00 83.92 1,546.36 44.82 1,903.64 Other Services & Charges 101-4-2420-4321 Telephone 800.00 54.41 604.10 75.51 195.90 101-4-2420-4322 Postage 1,750.00 0.00 1,027.58 58.72 722.42 101-4-2420-4331 Travel, Conferences & Schools 700.00 0.00 770.00 110.00 ( 70.00) 101-4-2420-4361 Insurance 100.00 0.00 97.50 97.50 2.50 TOTAL Other Services & Charges 3,350.00 54.41 2,499.18 74.60 850.82 ___________________________________________________________________________________________________________________ TOTAL Code Enforcement 91,600.00 6,738.45 78,377.83 85.57 13,222.17 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Public Safety 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Environmental ============= Personal Services 101-4-2440-4101 Regular Pay 26,900.00 2,111.29 23,325.68 86.71 3,574.32 101-4-2440-4104 PERA 2,000.00 156.88 1,776.93 88.85 223.07 101-4-2440-4105 FICA 1,650.00 129.69 1,468.91 89.02 181.09 101-4-2440-4107 Medicare 400.00 30.33 343.52 85.88 56.48 101-4-2440-4108 Insurance 3,350.00 283.46 3,629.32 108.34 ( 279.32) 101-4-2440-4109 Workers Comp 300.00 53.00 261.50 87.17 38.50 TOTAL Personal Services 34,600.00 2,764.65 30,805.86 89.03 3,794.14 Supplies 101-4-2440-4201 Office Supplies 450.00 0.62 63.80 14.18 386.20 101-4-2440-4212 Fuels & Lubes 200.00 5.11 115.88 57.94 84.12 101-4-2440-4219 Operating Supplies 0.00 0.00 930.42 0.00 ( 930.42) TOTAL Supplies 650.00 5.73 1,110.10 170.78 ( 460.10) Other Services & Charges 101-4-2440-4321 Telephone 350.00 0.00 180.00 51.43 170.00 101-4-2440-4322 Postage 700.00 0.00 86.54 12.36 613.46 101-4-2440-4331 Travel, Conferences & Schools 1,150.00 96.26 1,902.14 165.40 ( 752.14) 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 974.02 97.40 25.98 101-4-2440-4433 Dues & Subscriptions 150.00 0.00 0.00 0.00 150.00 TOTAL Other Services & Charges 3,850.00 96.26 3,142.70 81.63 707.30 ___________________________________________________________________________________________________________________ TOTAL Environmental 39,100.00 2,866.64 35,058.66 89.66 4,041.34 ___________________________________________________________________________________________________________________ TOTAL Public Safety 6,636,000.00 494,454.78 5,475,594.08 82.51 1,160,405.92 Street Maintenance ================== Personal Services 101-4-3120-4101 Regular Pay 493,750.00 47,188.70 483,696.23 97.96 10,053.77 101-4-3120-4102 Overtime Pay 4,000.00 35.66 1,299.41 32.49 2,700.59 101-4-3120-4103 Part-time Pay 77,000.00 3,773.13 56,907.54 73.91 20,092.46 101-4-3120-4104 PERA 41,450.00 3,824.79 40,004.88 96.51 1,445.12 101-4-3120-4105 FICA 35,650.00 3,013.58 32,662.36 91.62 2,987.64 101-4-3120-4107 Medicare 8,350.00 704.78 7,638.77 91.48 711.23 101-4-3120-4108 Insurance 75,050.00 7,797.00 76,141.68 101.45 ( 1,091.68) 101-4-3120-4109 Workers Comp 28,600.00 7,493.75 29,210.00 102.13 ( 610.00) TOTAL Personal Services 763,850.00 73,831.39 727,560.87 95.25 36,289.13 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Public Works 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-3120-4201 Office Supplies 2,850.00 60.62 1,969.17 69.09 880.83 101-4-3120-4212 Fuels & Lubes 66,200.00 1,334.65 11,752.23 17.75 54,447.77 101-4-3120-4219 Operating Supplies 60,000.00 2,510.85 47,992.54 79.99 12,007.46 101-4-3120-4221 Equipment Parts 50,000.00 7,270.27 45,103.09 90.21 4,896.91 101-4-3120-4226 Street Signs 30,500.00 643.81 30,264.84 99.23 235.16 TOTAL Supplies 209,550.00 11,820.20 137,081.87 65.42 72,468.13 Other Services & Charges 101-4-3120-4319 Other Professional Services 550.00 0.00 140.54 25.55 409.46 101-4-3120-4321 Telephone 6,100.00 560.20 4,415.59 72.39 1,684.41 101-4-3120-4322 Postage 100.00 11.64 54.50 54.50 45.50 101-4-3120-4331 Travel, Conferences & Schools 5,100.00 300.00 1,993.83 39.09 3,106.17 101-4-3120-4359 Publishing 200.00 80.00 128.00 64.00 72.00 101-4-3120-4361 Insurance 19,000.00 0.00 17,850.75 93.95 1,149.25 101-4-3120-4389 Utilities 102,800.00 4,921.55 71,670.42 69.72 31,129.58 101-4-3120-4401 Bldg Repair/Maint Services 20,000.00 2,505.00 12,538.58 62.69 7,461.42 101-4-3120-4404 Equip Repair/Maint Services 9,000.00 0.00 5,275.95 58.62 3,724.05 101-4-3120-4409 Contractual Services 63,500.00 3,400.00 23,076.91 36.34 40,423.09 101-4-3120-4415 Equipment Rental 3,000.00 0.00 659.81 21.99 2,340.19 101-4-3120-4417 Uniform Rental 5,800.00 711.05 3,925.84 67.69 1,874.16 101-4-3120-4433 Dues & Subscriptions 350.00 0.00 280.00 80.00 70.00 101-4-3120-4437 Taxes & Licenses 150.00 0.00 489.00 326.00 ( 339.00) 101-4-3120-4460 Equip Replacement Charge 100,950.00 8,412.50 92,537.50 91.67 8,412.50 TOTAL Other Services & Charges 336,600.00 20,901.94 235,037.22 69.83 101,562.78 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Street Maintenance 1,310,000.00 106,553.53 1,099,679.96 83.95 210,320.04 Snow Removal ============ Personal Services 101-4-3130-4101 Regular Pay 137,650.00 0.00 52,468.97 38.12 85,181.03 101-4-3130-4102 Overtime Pay 20,000.00 0.00 4,226.28 21.13 15,773.72 101-4-3130-4104 PERA 11,400.00 0.00 4,560.68 40.01 6,839.32 101-4-3130-4105 FICA 9,750.00 0.00 3,608.48 37.01 6,141.52 101-4-3130-4107 Medicare 2,300.00 0.00 843.93 36.69 1,456.07 101-4-3130-4108 Insurance 19,850.00 0.00 9,884.63 49.80 9,965.37 101-4-3130-4109 Workers Comp 8,150.00 2,088.00 8,036.25 98.60 113.75 TOTAL Personal Services 209,100.00 2,088.00 83,629.22 39.99 125,470.78 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Public Works 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-3130-4219 Operating Supplies 72,450.00 83.96 69,548.26 95.99 2,901.74 TOTAL Supplies 72,450.00 83.96 69,548.26 95.99 2,901.74 Other Services & Charges _____________ _____________ _____________ _______ _____________ Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Snow Removal 281,550.00 2,171.96 153,177.48 54.41 128,372.52 Equipment Services ================== Personal Services 101-4-3150-4101 Regular Pay 113,250.00 8,749.71 96,674.68 85.36 16,575.32 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 656.23 7,374.94 84.77 1,325.06 101-4-3150-4105 FICA 7,200.00 526.61 5,923.40 82.27 1,276.60 101-4-3150-4107 Medicare 1,700.00 123.16 1,385.31 81.49 314.69 101-4-3150-4108 Insurance 14,850.00 1,260.00 13,798.70 92.92 1,051.30 101-4-3150-4109 Workers Comp 3,150.00 677.00 3,068.75 97.42 81.25 TOTAL Personal Services 151,850.00 11,992.71 128,225.78 84.44 23,624.22 Supplies 101-4-3150-4212 Fuels & Lubes 5,100.00 2,865.16 6,153.07 120.65 ( 1,053.07) 101-4-3150-4219 Operating Supplies 11,150.00 564.89 7,148.60 64.11 4,001.40 101-4-3150-4221 Equipment Parts 3,000.00 321.62 3,281.47 109.38 ( 281.47) TOTAL Supplies 19,250.00 3,751.67 16,583.14 86.15 2,666.86 Other Services & Charges 101-4-3150-4331 Travel, Conferences & Schools 3,000.00 0.00 695.12 23.17 2,304.88 101-4-3150-4404 Equip Repair/Maint Services 10,000.00 0.00 3,013.02 30.13 6,986.98 101-4-3150-4417 Uniform Rental 2,150.00 171.64 1,954.33 90.90 195.67 TOTAL Other Services & Charges 15,150.00 171.64 5,662.47 37.38 9,487.53 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Equipment Services 186,250.00 15,916.02 150,471.39 80.79 35,778.61 Engineering =========== 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Public Works 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Services 101-4-3300-4101 Regular Pay 166,250.00 12,786.36 144,485.90 86.91 21,764.10 101-4-3300-4104 PERA 12,450.00 958.98 11,028.27 88.58 1,421.73 101-4-3300-4105 FICA 10,300.00 772.09 9,182.02 89.15 1,117.98 101-4-3300-4107 Medicare 2,400.00 180.57 2,147.41 89.48 252.59 101-4-3300-4108 Insurance 7,200.00 1,457.00 10,028.00 139.28 ( 2,828.00) 101-4-3300-4109 Workers Comp 750.00 136.50 717.75 95.70 32.25 TOTAL Personal Services 199,350.00 16,291.50 177,589.35 89.08 21,760.65 Supplies 101-4-3300-4201 Office Supplies 300.00 1.25 82.69 27.56 217.31 101-4-3300-4212 Fuels & Lubes 950.00 47.18 628.09 66.11 321.91 101-4-3300-4219 Operating Supplies 3,000.00 0.00 1,624.74 54.16 1,375.26 TOTAL Supplies 4,250.00 48.43 2,335.52 54.95 1,914.48 Other Services & Charges 101-4-3300-4319 Other Professional Services 7,000.00 0.00 1,460.13 20.86 5,539.87 101-4-3300-4321 Telephone 1,400.00 90.75 852.65 60.90 547.35 101-4-3300-4322 Postage 300.00 0.00 97.75 32.58 202.25 101-4-3300-4331 Travel, Conferences & Schools 1,850.00 0.00 515.24 27.85 1,334.76 101-4-3300-4361 Insurance 100.00 0.00 87.00 87.00 13.00 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 1,375.00 91.67 125.00 TOTAL Other Services & Charges 14,350.00 215.75 4,387.77 30.58 9,962.23 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Engineering 217,950.00 16,555.68 184,312.64 84.57 33,637.36 ___________________________________________________________________________________________________________________ TOTAL Public Works 1,995,750.00 141,197.19 1,587,641.47 79.55 408,108.53 Parks Department ================ Personal Services 101-4-5110-4101 Regular Pay 409,900.00 31,061.34 372,156.73 90.79 37,743.27 101-4-5110-4102 Overtime Pay 6,600.00 20.94 5,002.21 75.79 1,597.79 101-4-5110-4103 Part-time Pay 68,250.00 1,485.00 33,510.00 49.10 34,740.00 101-4-5110-4104 PERA 31,250.00 2,331.17 26,744.96 85.58 4,505.04 101-4-5110-4105 FICA 30,050.00 1,851.78 23,726.46 78.96 6,323.54 101-4-5110-4107 Medicare 7,050.00 433.08 5,548.91 78.71 1,501.09 101-4-5110-4108 Insurance 73,500.00 6,342.00 70,410.45 95.80 3,089.55 101-4-5110-4109 Workers Comp 12,000.00 3,828.50 13,124.75 109.37 ( 1,124.75) 101-4-5110-4110 Re-employment Compensation 0.00 0.00 2,108.00 0.00 ( 2,108.00) TOTAL Personal Services 638,600.00 47,353.81 552,332.47 86.49 86,267.53 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Culture & Recreation 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-5110-4212 Fuels & Lubes 29,750.00 1,154.33 19,411.78 65.25 10,338.22 101-4-5110-4217 Uniform Allowance 3,800.00 0.00 2,532.28 66.64 1,267.72 101-4-5110-4219 Operating Supplies 94,900.00 4,578.72 69,986.09 73.75 24,913.91 101-4-5110-4221 Equipment Parts 26,000.00 317.28 17,080.41 65.69 8,919.59 TOTAL Supplies 154,450.00 6,050.33 109,010.56 70.58 45,439.44 Other Services & Charges 101-4-5110-4321 Telephone 4,900.00 279.11 1,615.87 32.98 3,284.13 101-4-5110-4322 Postage 100.00 0.00 86.66 86.66 13.34 101-4-5110-4331 Travel, Conferences & Schools 4,600.00 0.00 3,039.92 66.09 1,560.08 101-4-5110-4361 Insurance 30,250.00 0.00 31,117.50 102.87 ( 867.50) 101-4-5110-4389 Utilities 75,250.00 6,786.43 58,566.16 77.83 16,683.84 101-4-5110-4401 Bldg Repair/Maint Services 4,150.00 150.00 192.50 4.64 3,957.50 101-4-5110-4404 Equip Repair/Maint Services 17,650.00 4,620.00 11,411.01 64.65 6,238.99 101-4-5110-4409 Contractual Services 45,150.00 4,185.30 19,738.40 43.72 25,411.60 101-4-5110-4415 Equipment Rental 14,150.00 1,350.00 19,906.98 140.69 ( 5,756.98) 101-4-5110-4460 Equip Replacement Charge 48,850.00 4,070.83 44,779.13 91.67 4,070.87 TOTAL Other Services & Charges 245,050.00 21,441.67 190,454.13 77.72 54,595.87 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks Department 1,038,100.00 74,845.81 851,797.16 82.05 186,302.84 Parks & Rec Admin ================= Personal Services 101-4-5210-4101 Regular Pay 294,400.00 22,755.18 255,722.34 86.86 38,677.66 101-4-5210-4102 Overtime Pay 0.00 0.00 255.73 0.00 ( 255.73) 101-4-5210-4103 Part-time Pay 48,450.00 3,587.12 41,946.11 86.58 6,503.89 101-4-5210-4104 PERA 25,700.00 1,975.67 22,743.13 88.49 2,956.87 101-4-5210-4105 FICA 21,250.00 1,559.31 17,997.13 84.69 3,252.87 101-4-5210-4107 Medicare 4,950.00 364.67 4,209.01 85.03 740.99 101-4-5210-4108 Insurance 42,700.00 3,284.00 36,040.84 84.40 6,659.16 101-4-5210-4109 Workers Comp 3,650.00 1,011.00 3,716.25 101.82 ( 66.25) TOTAL Personal Services 441,100.00 34,536.95 382,630.54 86.74 58,469.46 Supplies 101-4-5210-4219 Operating Supplies 10,200.00 66.87 6,616.40 64.87 3,583.60 TOTAL Supplies 10,200.00 66.87 6,616.40 64.87 3,583.60 Other Services & Charges 101-4-5210-4321 Telephone 6,400.00 249.84 61.36 0.96 6,338.64 101-4-5210-4322 Postage 5,300.00 1,555.95 4,961.15 93.61 338.85 101-4-5210-4331 Travel, Conferences & Schools 9,850.00 1,500.25 5,618.09 57.04 4,231.91 101-4-5210-4349 Advertising/Marketing 33,200.00 2,667.92 18,999.80 57.23 14,200.20 101-4-5210-4361 Insurance 400.00 0.00 401.50 100.38 ( 1.50) 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Culture & Recreation 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-4-5210-4389 Utilities 11,300.00 622.21 7,200.50 63.72 4,099.50 101-4-5210-4401 Bldg Repair/Maint Services 17,200.00 1,190.00 11,694.96 67.99 5,505.04 101-4-5210-4404 Equip Repair/Maint Services 8,400.00 0.00 8,310.57 98.94 89.43 101-4-5210-4433 Dues & Subscriptions 2,350.00 0.00 2,495.00 106.17 ( 145.00) TOTAL Other Services & Charges 94,400.00 7,786.17 59,742.93 63.29 34,657.07 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks & Rec Admin 545,700.00 42,389.99 448,989.87 82.28 96,710.13 Recreation Programs =================== Personal Services 101-4-5220-4102 Overtime Pay 0.00 0.00 169.00 0.00 ( 169.00) 101-4-5220-4103 Part-time Pay 82,000.00 1,424.43 63,081.42 76.93 18,918.58 101-4-5220-4105 FICA 4,300.00 88.33 3,989.24 92.77 310.76 101-4-5220-4107 Medicare 1,200.00 20.67 932.96 77.75 267.04 TOTAL Personal Services 87,500.00 1,533.43 68,172.62 77.91 19,327.38 Supplies 101-4-5220-4219 Operating Supplies 28,000.00 1,247.17 18,374.42 65.62 9,625.58 TOTAL Supplies 28,000.00 1,247.17 18,374.42 65.62 9,625.58 Other Services & Charges 101-4-5220-4409 Contractual Services 45,000.00 4,419.50 49,944.50 110.99 ( 4,944.50) 101-4-5220-4412 Building Rent 1,650.00 0.00 1,164.50 70.58 485.50 101-4-5220-4438 Credit Card Fees 3,600.00 130.14 3,021.17 83.92 578.83 TOTAL Other Services & Charges 50,250.00 4,549.64 54,130.17 107.72 ( 3,880.17) ___________________________________________________________________________________________________________________ TOTAL Recreation Programs 165,750.00 7,330.24 140,677.21 84.87 25,072.79 Concessions =========== Personal Services _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ Sr Citizen Programs =================== Personal Services 101-4-5510-4101 Regular Pay 118,900.00 9,350.40 103,089.16 86.70 15,810.84 101-4-5510-4103 Part-time Pay 3,150.00 144.00 3,140.40 99.70 9.60 101-4-5510-4104 PERA 8,900.00 701.28 7,865.82 88.38 1,034.18 101-4-5510-4105 FICA 7,550.00 560.66 6,394.94 84.70 1,155.06 101-4-5510-4107 Medicare 1,750.00 131.12 1,495.59 85.46 254.41 101-4-5510-4108 Insurance 21,650.00 1,787.00 19,657.06 90.79 1,992.94 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Culture & Recreation 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-4-5510-4109 Workers Comp 550.00 142.75 553.75 100.68 ( 3.75) TOTAL Personal Services 162,450.00 12,817.21 142,196.72 87.53 20,253.28 Supplies 101-4-5510-4219 Operating Supplies 16,500.00 436.36 12,096.94 73.31 4,403.06 TOTAL Supplies 16,500.00 436.36 12,096.94 73.31 4,403.06 Other Services & Charges 101-4-5510-4321 Telephone 2,400.00 107.51 1,045.53 43.56 1,354.47 101-4-5510-4322 Postage 3,000.00 0.00 1,832.29 61.08 1,167.71 101-4-5510-4331 Travel, Conferences & Schools 3,050.00 16.20 1,289.64 42.28 1,760.36 101-4-5510-4361 Insurance 1,400.00 0.00 1,315.00 93.93 85.00 101-4-5510-4389 Utilities 25,550.00 1,670.61 16,904.06 66.16 8,645.94 101-4-5510-4401 Bldg Repair/Maint Services 16,050.00 2,112.28 10,574.03 65.88 5,475.97 101-4-5510-4404 Equip Repair/Maint Services 100.00 0.00 16.75 16.75 83.25 101-4-5510-4409 Contractual Services 11,600.00 1,400.70 12,677.81 109.29 ( 1,077.81) 101-4-5510-4433 Dues & Subscriptions 850.00 97.24 743.96 87.52 106.04 TOTAL Other Services & Charges 64,000.00 5,404.54 46,399.07 72.50 17,600.93 Capital Outla y _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Sr Citizen Programs 242,950.00 18,658.11 200,692.73 82.61 42,257.27 ___________________________________________________________________________________________________________________ TOTAL Culture & Recreation 1,992,500.00 143,224.15 1,642,156.97 82.42 350,343.03 Economic Development ==================== Personal Services 101-4-6210-4101 Regular Pay 0.00 ( 11,007.47) 11,007.60 0.00 ( 11,007.60) 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 ( 825.56) 825.56 0.00 ( 825.56) 101-4-6210-4105 FICA 0.00 ( 714.98) 677.79 0.00 ( 677.79) 101-4-6210-4107 Medicare 0.00 ( 175.95) 158.51 0.00 ( 158.51) 101-4-6210-4108 Insurance 0.00 ( 1,491.00 ) 1,491.00 0.00 ( 1,491.00) TOTAL Personal Services 0.00 ( 15,264.96) 15,210.46 0.00 ( 15,210.46) Other Services & Charges 101-4-6210-4440 Miscellaneous 0.00 ( 176.74 ) 0.00 0.00 0.00 TOTAL Other Services & Charges 0.00 ( 176.74) 0.00 0.00 0.00 ___________________________________________________________________________________________________________________ TOTAL Economic Development 0.00 ( 15,441.70) 15,210.46 0.00 ( 15,210.46) 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 101-GENERAL FUND Economic Development 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Energy City =========== Personal Services 101-4-6220-4101 Regular Pay 9,000.00 703.77 7,775.26 86.39 1,224.74 101-4-6220-4104 PERA 700.00 53.18 594.04 84.86 105.96 101-4-6220-4105 FICA 550.00 43.96 491.16 89.30 58.84 101-4-6220-4107 Medicare 150.00 10.28 114.80 76.53 35.20 101-4-6220-4108 Insurance 1,100.00 94.50 900.24 81.84 199.76 TOTAL Personal Services 11,500.00 905.69 9,875.50 85.87 1,624.50 Supplies 101-4-6220-4219 Operating Supplies 1,800.00 0.00 574.64 31.92 1,225.36 TOTAL Supplies 1,800.00 0.00 574.64 31.92 1,225.36 Other Services & Charges 101-4-6220-4319 Other Professional Services 500.00 0.00 528.50 105.70 ( 28.50) 101-4-6220-4331 Travel, Conferences & Schools 1,000.00 0.00 48.21 4.82 951.79 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 576.71 19.22 2,423.29 ___________________________________________________________________________________________________________________ TOTAL Energy City 16,300.00 905.69 11,026.85 67.65 5,273.15 ___________________________________________________________________________________________________________________ TOTAL Economic Development 16,300.00 ( 14,536.01) 26,237.31 160.97 ( 9,937.31) Transfers Out ============= Transfers Ou t _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL EXPENDITURES 13,884,800.00 1,015,954.06 11,568,400.37 83.32 2,316,399.63 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 716,602.15)( 2,746,424.18) 2,746,424.18 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 221-ICE ARENA FINANCIAL SUMMARY 91.67% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ REVENUE SUMMARY Ice Arena 628,100.00 91,541.85 477,746.38 76.06 150,353.62 Hockey 43,500.00 ( 17,264.22) 39,925.93 91.78 3,574.07 Skating 38,400.00 6,380.00 31,084.50 80.95 7,315.50 Concessions 80,750.00 13,197.19 62,042.07 76.83 18,707.93 TOTAL REVENUES 790,750.00 93,854.82 610,798.88 77.24 179,951.12 ============= ============= ============= ======= ============= EXPENDITURE SUMMARY Culture & Recreation Ice Arena 845,600.00 46,635.76 452,361.47 53.50 393,238.53 Hockey 22,000.00 0.00 17,332.82 78.79 4,667.18 Skating 28,850.00 1,057.87 14,399.15 49.91 14,450.85 Arena Concessions 58,250.00 6,074.09 35,452.63 60.86 22,797.37 TOTAL Culture & Recreation 954,700.00 53,767.72 519,546.07 54.42 435,153.93 TOTAL EXPENDITURES 954,700.00 53,767.72 519,546.07 54.42 435,153.93 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES ( 163,950.00) 40,087.10 91,252.81 ( 255,202.81) 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 221-ICE ARENA 91.67% 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 79,768.99 390,477.06 73.64 139,772.94 221-3-0000-3465 Admissions 25,850.00 4,568.50 13,001.00 50.29 12,849.00 221-3-0000-3466 Dry Floor Events 14,300.00 3,555.02 20,450.01 143.01 ( 6,150.01) 221-3-0000-3468 Skate Sharpening 4,300.00 455.00 2,101.00 48.86 2,199.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 1,329.24 5.93 21,070.76 TOTAL Charges for Services 599,700.00 88,468.35 427,358.31 71.26 172,341.69 Other Revenue 221-3-0000-3621 Interest Income 2,500.00 0.00 4,813.38 192.54 ( 2,313.38) 221-3-0000-3622 Vending Machines 15,000.00 2,449.22 12,177.76 81.19 2,822.24 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 624.28 2,722.63 69.81 1,177.37 TOTAL Other Revenue 28,100.00 3,073.50 22,643.77 80.58 5,456.23 Sales 221-3-0000-3791 ATM Revenue 300.00 0.00 144.30 48.10 155.70 TOTAL Sales 300.00 0.00 144.30 48.10 155.70 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 91,541.85 477,746.38 76.06 150,353.62 Hockey ====== Charges for Services 221-3-5410-3461 Recreation Fees 43,500.00 ( 17,264.22 ) 39,925.93 91.78 3,574.07 TOTAL Charges for Services 43,500.00 ( 17,264.22) 39,925.93 91.78 3,574.07 Other Revenu e _____________ _____________ _____________ _______ _____________ _____________________________________________________________________________ TOTAL Hockey 43,500.00 ( 17,264.22) 39,925.93 91.78 3,574.07 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 221-ICE ARENA 91.67% 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 6,380.00 27,335.50 76.36 8,464.50 221-3-5420-3465 Admissions 2,600.00 0.00 2,999.00 115.35 ( 399.00) TOTAL Charges for Services 38,400.00 6,380.00 30,334.50 79.00 8,065.50 Other Revenue 221-3-5420-3629 Miscellaneous Revenue 0.00 0.00 750.00 0.00 ( 750.00) TOTAL Other Revenue 0.00 0.00 750.00 0.00 ( 750.00) _____________________________________________________________________________ TOTAL Skating 38,400.00 6,380.00 31,084.50 80.95 7,315.50 Concessions =========== Charges for Services 221-3-5430-3467 Concessions 80,750.00 13,197.19 62,042.07 76.83 18,707.93 TOTAL Charges for Services 80,750.00 13,197.19 62,042.07 76.83 18,707.93 _____________________________________________________________________________ TOTAL Concessions 80,750.00 13,197.19 62,042.07 76.83 18,707.93 ___________________________________________________________________________________________________________________ TOTAL REVENUE 790,750.00 93,854.82 610,798.88 77.24 179,951.12 ============= ============= ============= ======= ============= 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 221-ICE ARENA 91.67% 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 13,853.62 144,841.91 80.49 35,108.09 221-4-5400-4103 Part-time Pay 61,900.00 6,510.25 57,116.94 92.27 4,783.06 221-4-5400-4104 PERA 18,150.00 1,403.65 14,591.48 80.39 3,558.52 221-4-5400-4105 FICA 15,050.00 1,240.84 12,825.61 85.22 2,224.39 221-4-5400-4107 Medicare 3,550.00 290.21 2,999.53 84.49 550.47 221-4-5400-4108 Insurance 28,800.00 2,121.00 22,183.13 77.02 6,616.87 221-4-5400-4109 Workers Comp 9,350.00 3,492.25 10,592.50 113.29 ( 1,242.50) 221-4-5400-4110 Re-employment Compensation 0.00 0.00 18.84 0.00 ( 18.84) TOTAL Personal Services 316,750.00 28,911.82 265,169.94 83.72 51,580.06 Supplies 221-4-5400-4212 Fuels & Lubes 300.00 30.85 243.28 81.09 56.72 221-4-5400-4217 Uniform Allowance 850.00 20.00 694.70 81.73 155.30 221-4-5400-4219 Operating Supplies 49,600.00 1,806.11 26,579.31 53.59 23,020.69 221-4-5400-4255 Soft Drinks/Misc 6,950.00 1,119.12 4,514.56 64.96 2,435.44 221-4-5400-4259 Other Merchandise For Resale 900.00 0.00 0.00 0.00 900.00 TOTAL Supplies 58,600.00 2,976.08 32,031.85 54.66 26,568.15 Other Services & Charges 221-4-5400-4321 Telephone 3,350.00 249.44 1,055.72 31.51 2,294.28 221-4-5400-4322 Postage 150.00 0.00 120.76 80.51 29.24 221-4-5400-4331 Travel, Conferences & Schools 1,900.00 0.00 1,450.28 76.33 449.72 221-4-5400-4359 Publishing 5,450.00 0.00 4,712.29 86.46 737.71 221-4-5400-4361 Insurance 4,950.00 0.00 4,548.00 91.88 402.00 221-4-5400-4389 Utilities 161,950.00 11,820.79 114,157.20 70.49 47,792.80 221-4-5400-4401 Bldg Repair/Maint Services 29,250.00 2,450.50 23,501.81 80.35 5,748.19 221-4-5400-4409 Contractual Services 2,650.00 0.00 2,870.19 108.31 ( 220.19) 221-4-5400-4415 Equipment Rental 3,700.00 227.13 2,498.43 67.53 1,201.57 221-4-5400-4433 Dues & Subscriptions 550.00 0.00 245.00 44.55 305.00 TOTAL Other Services & Charges 213,900.00 14,747.86 155,159.68 72.54 58,740.32 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 Ou t _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Ice Arena 845,600.00 46,635.76 452,361.47 53.50 393,238.53 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 221-ICE ARENA Culture & Recreation 91.67% 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 0.00 12,336.25 99.49 63.75 TOTAL Supplies 12,400.00 0.00 12,336.25 99.49 63.75 Other Services & Charges 221-4-5410-4409 Contractual Services 5,700.00 0.00 3,040.00 53.33 2,660.00 221-4-5410-4438 Credit Card Fees 3,000.00 0.00 1,956.57 65.22 1,043.43 TOTAL Other Services & Charges 8,700.00 0.00 4,996.57 57.43 3,703.43 ___________________________________________________________________________________________________________________ TOTAL Hockey 22,000.00 0.00 17,332.82 78.79 4,667.18 Skating ======= Personal Services 221-4-5420-4103 Part-time Pay 17,800.00 646.33 7,865.81 44.19 9,934.19 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 40.09 496.34 45.12 603.66 221-4-5420-4107 Medicare 250.00 9.38 116.08 46.43 133.92 TOTAL Personal Services 20,150.00 695.80 8,478.23 42.08 11,671.77 Supplies 221-4-5420-4219 Operating Supplies 4,900.00 206.25 3,171.63 64.73 1,728.37 TOTAL Supplies 4,900.00 206.25 3,171.63 64.73 1,728.37 Other Services & Charges 221-4-5420-4359 Publishing 1,200.00 49.57 508.57 42.38 691.43 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 106.25 1,466.54 146.65 ( 466.54) TOTAL Other Services & Charges 3,800.00 155.82 2,749.29 72.35 1,050.71 ___________________________________________________________________________________________________________________ TOTAL Skating 28,850.00 1,057.87 14,399.15 49.91 14,450.85 Arena Concessions ================= 12-15-2016 08:55 AM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30TH, 2016 221-ICE ARENA Culture & Recreation 91.67% 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 2,474.54 15,097.27 70.88 6,202.73 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 153.42 993.05 76.39 306.95 221-4-5430-4107 Medicare 300.00 35.87 232.30 77.43 67.70 TOTAL Personal Services 24,500.00 2,663.83 16,322.62 66.62 8,177.38 Supplies 221-4-5430-4219 Operating Supplies 3,250.00 305.00 436.05 13.42 2,813.95 221-4-5430-4259 Other Merchandise For Resale 30,500.00 3,105.26 18,693.96 61.29 11,806.04 TOTAL Supplies 33,750.00 3,410.26 19,130.01 56.68 14,619.99 ___________________________________________________________________________________________________________________ TOTAL Arena Concessions 58,250.00 6,074.09 35,452.63 60.86 22,797.37 ___________________________________________________________________________________________________________________ TOTAL Culture & Recreation 954,700.00 53,767.72 519,546.07 54.42 435,153.93 ___________________________________________________________________________________________________________________ TOTAL EXPENDITURES 954,700.00 53,767.72 519,546.07 54.42 435,153.93 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES ( 163,950.00) 40,087.10 91,252.81 ( 255,202.81) Current Budget Year to Date Actual Budget Variance % of Budget Current Budget Year to Date Actual Budget Variance % of Budget Current Budget Year to Date Actual Budget Variance % of Budget Current Budget Year to Date Actual Budget Variance % of Budget Sales and cost of sales: Sales 6,934,000$ 6,246,370$ 687,630$ 90.08% Cost of sales (4,957,300) (4,225,768) (731,532) 85.24% Gross profit 1,976,700 2,020,602 (43,902) 102.22% Operating revenues: User charges -$ -$ -$ 0.00%1,860,000$ 1,590,349$ 269,651$ 85.50%1,310,000$ 1,117,458$ 192,542$ 85.30%420,000$ 376,031$ 43,969$ 89.53% Delinquency collections - - - 0.00%1,300 1,479 (179) 113.77%13,000 4,584 8,416 35.26%- 544 (544) 0.00% Other 1,700 1,947 (247) 114.53%2,000 - 2,000 0.00%3,500 1,407 2,093 40.20%- 11 (11) 0.00% Total operating revenues 1,700 1,947 (247) 114.53%1,863,300 1,591,828 271,472 85.43%1,326,500 1,123,449 203,051 84.69%420,000 376,586 43,414 89.66% Operating expenses: Personal services 659,850 572,658 87,192 86.79%532,650 461,954 70,696 86.73%22,900 19,751 3,149 86.25%80,650 70,021 10,629 86.82% Supplies 53,700 15,955 37,745 29.71%217,800 70,076 147,724 32.17%6,300 2,046 4,254 32.48%7,000 6,149 851 87.84% Other service charges 231,950 216,015 15,935 93.13%517,200 437,228 79,972 84.54%1,340,700 1,206,713 133,987 90.01%403,150 91,700 311,450 22.75% 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 804,628 263,872 75.30%2,692,000 969,258 1,722,742 36.01%1,369,900 1,228,510 141,390 89.68%924,550 167,870 756,680 18.16% Operating income (loss)909,900 1,217,921 (308,021) 133.85%(828,700) 622,570 (1,451,270) -75.13%(43,400) (105,061) 61,661 242.08%(504,550) 208,716 (713,266) -41.37% Nonoperating revenues (expenses): Interest income 25,000 40,863 (15,863) 163.45%80,000 72,651 7,349 90.81%6,250 6,545 (295) 104.72%1,500 3,659 (2,159) 243.93% Grant revenue - - - 0.00%800,000 425,934 374,066 53.24%- - - 0.00%- - - 0.00% Interest expense - - - 0.00%(272,400) (157,686) (114,714) 57.89%- - - 0.00%- - - 0.00% Total nonoperating revenues (expenses)25,000 40,863 (15,863) 163.45%607,600 340,899 266,701 56.11%6,250 6,545 (295) 104.72%1,500 3,659 (2,159) 243.93% Income (loss) before contributions and transfers 934,900 1,258,784 (323,884) 134.64%(221,100) 963,469 (1,184,569) -435.76%(37,150) (98,516) 61,366 265.18%(503,050) 212,375 (715,425) -42.22% Contributions - connection fees - - - 0.00%492,700 488,082 4,618 99.06%- - - 0.00%51,500 12,362 39,138 24.00% Sale of assets - - - 0.00%- 36,500 (36,500) 0.00%- - - 0.00%- - - 0.00% Transfers in - - - 0.00%- - - 0.00%36,600 - 36,600 0.00%- - - 0.00% Transfers out (718,950) (704,567) (14,383) 98.00%(100,000) (100,000) - 100.00%(45,000) (45,000) - 100.00%(5,000) (5,000) - 100.00% NET INCOME (LOSS)215,950 554,217 (338,267) 256.64%171,600 1,388,051 (1,216,451) 808.89%(45,550) (143,516) 97,966 315.07%(456,550) 219,737 (676,287) -48.13% Items reclassified to balance sheet at year end: Capital Outlay (5,012,000) (3,479,903) (1,532,097) 69.43% Bond Payment (400,000) (400,000) - 100.00% Revenues over/(under) expenditures 215,950 554,217 (338,267) (5,240,400) (2,491,852) (2,748,548) (45,550) (143,516) 97,966 (456,550) 219,737 (676,287) * Recorded at yearend Stormwater CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED NOVEMBER 30, 2016 Liquor Sewer Garbage 12-15-2016 09:26 AM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: NOVEMBER 30TH, 2016 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE ___________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 31,696.98 ( 48.38) 31,648.60 101-1010 Cash - General Fund 4,443,377.22 ( 719,653.26) 3,723,723.96 211-1010 Cash - Library 417,417.29 ( 12,268.47) 405,148.82 221-1010 Cash - Ice Arena 297,108.77 ( 4,018.45) 293,090.32 225-1010 Cash - Park Dedication 50,901.08 ( 199,811.80) ( 148,910.72) 228-1010 Cash - Landfill 453,564.17 ( 3,098.31) 450,465.86 231-1010 Cash - Landfill Const Debris 736,869.72 0.00 736,869.72 240-1010 Cash - Micro Loan Fund 666,035.17 7,389.48 673,424.65 242-1010 Cash - State DEED 115,843.95 1,886.49 117,730.44 245-1010 Cash - Development Fund 880,263.06 ( 10,905.20) 869,357.86 290-1010 Cash - Capital Outlay Reserve 893,658.72 ( 6,356.83) 887,301.89 291-1010 Cash - Insurance Reserve 123,680.15 ( 10,216.58) 113,463.57 292-1010 Cash - Govt Bldgs Reserve 1,758,675.43 ( 26,175.00) 1,732,500.43 294-1010 Cash - Drug Forfeiture 11,584.28 ( 386.50) 11,197.78 295-1010 Cash - Severance Pay Reserve 71,992.45 0.00 71,992.45 296-1010 Cash - GRE Reserve 1,823,614.55 0.00 1,823,614.55 313-1010 Cash - 2007C/2012B GO Bonds 179,498.80 2,021.50 181,520.30 333-1010 Cash - 2010A GO Cap Imp Bonds 642,269.20 0.00 642,269.20 401-1010 Cash - Pavement Mgmt 3,539,854.91 160,721.77 3,700,576.68 403-1010 Cash - Street Improvement 1,324,024.65 ( 41,421.07) 1,282,603.58 406-1010 Cash - City Wide Trunk Util 3,829,497.95 159,523.21 3,989,021.16 410-1010 Cash - Equipment Replacement 761,890.07 18,105.64 779,995.71 440-1010 Cash - Park Improvement 425,310.81 ( 487.80) 424,823.01 462-1010 Cash - TIF #22 Downtown Redev ( 600.00) 0.00 ( 600.00) 463-1010 Cash - TIF #23 Pref Powder 607.51 0.00 607.51 602-1010 Cash - Wastewater Treatment 4,656,873.84 ( 133,678.36) 4,523,195.48 603-1010 Cash - Liquor 3,121,669.77 53,725.75 3,175,395.52 605-1010 Cash - Garbage 415,595.40 ( 7,957.66) 407,637.74 607-1010 Cash - Storm Water 417,893.56 24,408.13 442,301.69 801-1010 Cash - Interest 0.00 40,635.31 40,635.31 821-1010 Cash - Developer Escrow 239,107.04 ( 49,673.00) 189,434.04_ TOTAL CLAIM ON CASH 32,329,776.50 ( 757,739.39) 31,572,037.11 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 78,009,069.59 162,205.94 78,171,275.53 999-1001 PY BANK ACCOUNT (74,061,482.65) ( 919,945.33) (74,981,427.98) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56_ SUBTOTAL CASH IN BANK - POOLED CASH 32,329,776.50 ( 757,739.39) 31,572,037.11 WAGES PAYABLE _______________ ______________ ______________ TOTAL CASH IN BANK - POOLED CASH 32,329,776.50 ( 757,739.39) 31,572,037.11 =============== ============== ==============