Loading...
INFORMATION 05-16-2016Information Memorandum To: Mayor and City Council From: Lori Ziemer, Interim Finance Director Date: May 16, 2016 Subject: April 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 April, actual revenues (except for property taxes and state aids) and expenditures should run about 33% 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 about 25% of budget estimates and building- related permit collections are 19% of budget.  Charges for services are slightly below budget estimates at 32% of budget.  Fines and forfeits collections, which lag a month, are over 35% of budget estimates.  The transfers in will be recorded mid-year. Expenditures:  Total departmental expenditures are 28% of budget and most departments are within or below budget.  The April-June quarterly premium for liability insurance was paid in April. 2016 Monthly Expenditures $16,000 $14,000 $12,000 $ THOUSANDS $10,000 $8,000 $6,000 $4,000 $2,000 $0 JanFebMarAprMayJunJulAugSepOctNovDec Actual $831$1,859$2,920$3,933 Budget $1,157$2,314$3,471$4,628$5,785$6,942$8,099$9,257$10,414$11,571$12,728$13,885 ICE ARENA For the month ending April, revenues of $343,402 exceed expenditures of $188,741 by $154,661. Ice rental revenues of $195,168 are about 37% of budget estimates. ATTACHMENTS  General Fund Revenue & Expense Report  Enterprise Funds – Budget to Actual  Cash Report – All Funds 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND FINANCIAL SUMMARY 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ REVENUE SUMMARY General Fund 13,884,800.00 198,105.15 756,934.64 5.45 13,127,865.36 TOTAL REVENUES 13,884,800.00 198,105.15 756,934.64 5.45 13,127,865.36 ============= ============= ============= ======= ============= EXPENDITURE SUMMARY General Government Mayor & Council 145,850.00 13,604.72 44,376.63 30.43 101,473.37 Cable TV 109,700.00 7,346.26 28,428.32 25.91 81,271.68 Administrative Services 605,500.00 44,905.04 173,271.09 28.62 432,228.91 Human Resources 178,400.00 12,219.58 47,369.71 26.55 131,030.29 Elections 20,500.00 0.00 6,300.00 30.73 14,200.00 Finance 583,550.00 51,200.23 176,982.40 30.33 406,567.60 Information Technology 346,350.00 30,957.18 109,586.71 31.64 236,763.29 Legal 214,600.00 3,815.10 41,013.30 19.11 173,586.70 Community Development 213,750.00 16,550.99 64,782.11 30.31 148,967.89 Planning 297,400.00 20,732.28 68,466.23 23.02 228,933.77 City Hall Maintenance 623,650.00 45,422.52 185,933.09 29.81 437,716.91 Contingency ( 95,000.00) 0.00 0.00 0.00 ( 95,000.00) TOTAL General Government 3,244,250.00 246,753.90 946,509.59 29.17 2,297,740.41 Public Safety Police Administration 713,700.00 55,082.99 243,938.99 34.18 469,761.01 Patrol 2,530,150.00 163,045.22 681,686.06 26.94 1,848,463.94 Investigations 994,000.00 69,365.07 278,018.32 27.97 715,981.68 Police Support Services 558,600.00 34,359.92 142,920.76 25.59 415,679.24 Police Reserves 23,250.00 4,748.00 7,171.78 30.85 16,078.22 Public safety building 156,000.00 12,600.59 35,502.27 22.76 120,497.73 Fire Administration 475,750.00 36,402.43 133,506.88 28.06 342,243.12 Fire Operations 381,300.00 24,319.06 111,826.18 29.33 269,473.82 Emergency Management 24,800.00 384.70 2,051.28 8.27 22,748.72 Building Safety 647,750.00 47,664.24 189,808.84 29.30 457,941.16 Code Enforcement 91,600.00 6,735.21 26,911.49 29.38 64,688.51 Environmental 39,100.00 2,755.77 11,498.74 29.41 27,601.26 TOTAL Public Safety 6,636,000.00 457,463.20 1,864,841.59 28.10 4,771,158.41 Public Works Street Maintenance 1,310,000.00 120,154.83 349,256.72 26.66 960,743.28 Snow Removal 281,550.00 21,500.96 145,926.79 51.83 135,623.21 Equipment Services 186,250.00 12,638.37 49,911.65 26.80 136,338.35 Engineering 217,950.00 15,837.96 61,129.08 28.05 156,820.92 TOTAL Public Works 1,995,750.00 170,132.12 606,224.24 30.38 1,389,525.76 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND FINANCIAL SUMMARY 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Culture & Recreation Parks Department 1,038,100.00 66,522.44 242,116.21 23.32 795,983.79 Parks & Rec Admin 545,700.00 35,124.40 156,560.41 28.69 389,139.59 Recreation Programs 165,750.00 2,499.14 15,867.71 9.57 149,882.29 Sr Citizen Programs 242,950.00 18,400.79 67,154.40 27.64 175,795.60 TOTAL Culture & Recreation 1,992,500.00 122,546.77 481,698.73 24.18 1,510,801.27 Economic Development Economic Development 0.00 14,667.06 30,289.86 0.00 ( 30,289.86) Energy City 16,300.00 856.79 3,271.79 20.07 13,028.21 TOTAL Economic Development 16,300.00 15,523.85 33,561.65 205.90 ( 17,261.65) General _____________ _____________ _____________ _______ _____________ TOTAL EXPENDITURES 13,884,800.00 1,012,419.84 3,932,835.80 28.32 9,951,964.20 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 814,314.69)( 3,175,901.16) 3,175,901.16 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ General Fund ============ Taxes 101-3-0000-3111 Current Ad Valorem Taxes 9,596,850.00 0.00 1,693.98 0.02 9,595,156.02 101-3-0000-3121 Gravel Tax 127,000.00 8,233.35 8,233.35 6.48 118,766.65 TOTAL Taxes 9,723,850.00 8,233.35 9,927.33 0.10 9,713,922.67 Licenses & Permits 101-3-0000-3211 Liquor License 67,500.00 16,055.00 16,095.00 23.84 51,405.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 0.00 100.00 3.23 3,000.00 101-3-0000-3214 Apartment License 35,000.00 2,533.00 36,505.00 104.30 ( 1,505.00) 101-3-0000-3216 Mining License 23,000.00 1,494.05 3,004.25 13.06 19,995.75 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 810.00 2,770.00 23.08 9,230.00 101-3-0000-3229 NPDES Permit 10,000.00 525.00 2,275.00 22.75 7,725.00 101-3-0000-3231 Building Permit 385,000.00 31,214.75 60,180.40 15.63 324,819.60 101-3-0000-3232 Plumbing/Heating Permit 92,000.00 4,567.85 30,324.04 32.96 61,675.96 101-3-0000-3233 Permit Surcharge 300.00 1,233.41 2,403.85 801.28 ( 2,103.85) 101-3-0000-3235 Animal License 6,500.00 240.00 1,260.00 19.38 5,240.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 1,200.00 3,560.00 44.50 4,440.00 TOTAL Licenses & Permits 646,550.00 59,873.06 159,129.38 24.61 487,420.62 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 2% 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 0.00 900.00 27.27 2,400.00 TOTAL Intergovernmental Rev 288,350.00 0.00 900.00 0.31 287,450.00 Charges for Services 101-3-0000-3412 Planning & Zoning Fees 16,000.00 2,150.00 9,655.00 60.34 6,345.00 101-3-0000-3413 Plan Check Fee 135,000.00 12,408.30 25,433.85 18.84 109,566.15 101-3-0000-3415 Special Assessment Search 500.00 240.00 440.00 88.00 60.00 101-3-0000-3417 Copies 1,700.00 164.95 663.87 39.05 1,036.13 101-3-0000-3418 Other General Govt Services 4,500.00 411.25 1,066.75 23.71 3,433.25 101-3-0000-3430 Lockout Fees 7,500.00 540.00 2,390.00 31.87 5,110.00 101-3-0000-3431 Police Services 6,000.00 197.48 667.48 11.12 5,332.52 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 225.00 925.00 30.83 2,075.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 15.70 95.15 3.17 2,904.85 101-3-0000-3438 Fire Inspections 10,000.00 0.00 0.00 0.00 10,000.00 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND 33.33% 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 4,626.00 31.90 9,874.00 101-3-0000-3451 Street Services 35,000.00 3,906.05 9,248.91 26.43 25,751.09 101-3-0000-3452 Engineering Services Reimb 148,950.00 0.00 0.00 0.00 148,950.00 101-3-0000-3461 Recreation Fees 96,000.00 12,181.50 42,301.03 44.06 53,698.97 101-3-0000-3462 Sr Center Activities 29,000.00 2,557.00 10,586.55 36.51 18,413.45 101-3-0000-3472 Park Use Fee 24,400.00 1,326.27 8,341.76 34.19 16,058.24 101-3-0000-3475 Building Rent 2,400.00 200.00 800.00 33.33 1,600.00 101-3-0000-3483 Sewer Inspection Fee 9,000.00 970.00 1,575.00 17.50 7,425.00 101-3-0000-3484 Contractor License Check 1,000.00 80.00 190.00 19.00 810.00 TOTAL Charges for Services 891,050.00 38,730.00 287,161.71 32.23 603,888.29 Fines & Forfeits 101-3-0000-3510 Court Fines 117,000.00 15,650.29 42,922.72 36.69 74,077.28 101-3-0000-3511 Parking Fines 10,000.00 580.00 1,780.00 17.80 8,220.00 TOTAL Fines & Forfeits 127,000.00 16,230.29 44,702.72 35.20 82,297.28 Special Assessments _____________ _____________ _____________ _______ _____________ Other Revenue 101-3-0000-3621 Interest Income 85,000.00 0.00 17,084.46 20.10 67,915.54 101-3-0000-3625 Refunds & Reimbursements 101,000.00 0.00 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 536.86 1,587.25 21.16 5,912.75 TOTAL Other Revenue 213,500.00 536.86 35,240.51 16.51 178,259.49 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 74,501.59 219,872.99 22.66 750,577.01 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 74,501.59 219,872.99 11.02 1,774,627.01 _____________________________________________________________________________ TOTAL General Fund 13,884,800.00 198,105.15 756,934.64 5.45 13,127,865.36 ___________________________________________________________________________________________________________________ TOTAL REVENUE 13,884,800.00 198,105.15 756,934.64 5.45 13,127,865.36 ============= ============= ============= ======= ============= 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Mayor & Council =============== Personal Services 101-4-1110-4103 Part-time Pay 38,500.00 3,207.99 12,831.96 33.33 25,668.04 101-4-1110-4104 PERA 1,900.00 102.09 408.36 21.49 1,491.64 101-4-1110-4105 FICA 2,400.00 72.32 289.28 12.05 2,110.72 101-4-1110-4107 Medicare 550.00 46.51 186.04 33.83 363.96 101-4-1110-4109 Workers Comp 100.00 0.00 41.50 41.50 58.50 TOTAL Personal Services 43,450.00 3,428.91 13,757.14 31.66 29,692.86 Supplies 101-4-1110-4201 Office Supplies 1,000.00 214.97 294.10 29.41 705.90 TOTAL Supplies 1,000.00 214.97 294.10 29.41 705.90 Other Services & Charges 101-4-1110-4319 Other Professional Services 10,400.00 0.00 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 0.00 556.44 26.50 1,543.56 101-4-1110-4359 Publishing 3,700.00 64.00 511.72 13.83 3,188.28 101-4-1110-4361 Insurance 39,600.00 9,615.00 19,230.00 48.56 20,370.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 281.84 5,578.01 20.77 21,271.99 TOTAL Other Services & Charges 101,400.00 9,960.84 30,325.39 29.91 71,074.61 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Mayor & Council 145,850.00 13,604.72 44,376.63 30.43 101,473.37 Cable TV ======== Personal Services 101-4-1120-4101 Regular Pay 63,350.00 4,875.21 18,525.78 29.24 44,824.22 101-4-1120-4103 Part-time Pay 17,950.00 786.60 2,897.31 16.14 15,052.69 101-4-1120-4104 PERA 6,100.00 424.64 1,691.05 27.72 4,408.95 101-4-1120-4105 FICA 5,050.00 320.17 1,274.47 25.24 3,775.53 101-4-1120-4107 Medicare 1,200.00 74.88 298.07 24.84 901.93 101-4-1120-4108 Insurance 14,250.00 861.00 3,444.00 24.17 10,806.00 101-4-1120-4109 Workers Comp 350.00 0.00 189.50 54.14 160.50 TOTAL Personal Services 108,250.00 7,342.50 28,320.18 26.16 79,929.82 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND General Government 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-1120-4201 Office Supplies 500.00 3.76 108.14 21.63 391.86 TOTAL Supplies 500.00 3.76 108.14 21.63 391.86 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,346.26 28,428.32 25.91 81,271.68 Administrative Services ======================= Personal Services 101-4-1210-4101 Regular Pay 388,750.00 29,903.14 113,631.98 29.23 275,118.02 101-4-1210-4103 Part-time Pay 46,000.00 3,100.00 12,000.62 26.09 33,999.38 101-4-1210-4104 PERA 32,600.00 2,475.22 9,919.41 30.43 22,680.59 101-4-1210-4105 FICA 26,950.00 2,092.86 8,204.72 30.44 18,745.28 101-4-1210-4107 Medicare 6,300.00 489.44 1,918.78 30.46 4,381.22 101-4-1210-4108 Insurance 36,600.00 2,160.03 10,878.32 29.72 25,721.68 101-4-1210-4109 Workers Comp 1,900.00 0.00 975.00 51.32 925.00 TOTAL Personal Services 539,100.00 40,220.69 157,528.83 29.22 381,571.17 Supplies 101-4-1210-4201 Office Supplies 7,300.00 76.85 356.99 4.89 6,943.01 TOTAL Supplies 7,300.00 76.85 356.99 4.89 6,943.01 Other Services & Charges 101-4-1210-4319 Other Professional Services 11,600.00 130.00 466.00 4.02 11,134.00 101-4-1210-4321 Telephone 1,500.00 ( 100.24)( 353.36) 23.56- 1,853.36 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 248.40 800.92 7.59 9,749.08 101-4-1210-4334 Car Allowance 4,800.00 400.00 1,600.00 33.33 3,200.00 101-4-1210-4359 Publishing 13,000.00 3,261.00 6,522.00 50.17 6,478.00 101-4-1210-4361 Insurance 50.00 11.75 23.50 47.00 26.50 101-4-1210-4404 Equip Repair/Maint Services 14,950.00 459.63 5,284.79 35.35 9,665.21 101-4-1210-4433 Dues & Subscriptions 1,850.00 196.96 510.88 27.62 1,339.12 TOTAL Other Services & Charges 59,100.00 4,607.50 15,385.27 26.03 43,714.73 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Administrative Services 605,500.00 44,905.04 173,271.09 28.62 432,228.91 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 7 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND General Government 33.33% 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 35,060.56 28.92 86,189.44 101-4-1220-4104 PERA 9,100.00 691.98 2,767.92 30.42 6,332.08 101-4-1220-4105 FICA 7,500.00 556.42 2,225.69 29.68 5,274.31 101-4-1220-4107 Medicare 1,750.00 130.14 520.56 29.75 1,229.44 101-4-1220-4108 Insurance 14,900.00 1,260.02 5,040.08 33.83 9,859.92 101-4-1220-4109 Workers Comp 550.00 0.00 272.00 49.45 278.00 TOTAL Personal Services 155,050.00 11,865.02 45,886.81 29.59 109,163.19 Supplies 101-4-1220-4201 Office Supplies 1,350.00 26.32 76.23 5.65 1,273.77 TOTAL Supplies 1,350.00 26.32 76.23 5.65 1,273.77 Other Services & Charges 101-4-1220-4319 Other Professional Services 1,250.00 229.35 651.15 52.09 598.85 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 98.89 358.66 1.97 17,841.34 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 328.24 1,406.67 6.39 20,593.33 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Human Resources 178,400.00 12,219.58 47,369.71 26.55 131,030.29 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 0.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 0.00 6,300.00 150.00 ( 2,100.00) 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 8 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND General Government 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Elections 20,500.00 0.00 6,300.00 30.73 14,200.00 Finance ======= Personal Services 101-4-1310-4101 Regular Pay 317,750.00 24,199.80 92,641.63 29.16 225,108.37 101-4-1310-4103 Part-time Pay 53,400.00 4,387.68 16,575.70 31.04 36,824.30 101-4-1310-4104 PERA 27,850.00 2,144.08 8,631.16 30.99 19,218.84 101-4-1310-4105 FICA 23,000.00 1,706.03 6,856.37 29.81 16,143.63 101-4-1310-4107 Medicare 5,400.00 398.99 1,603.52 29.69 3,796.48 101-4-1310-4108 Insurance 38,350.00 3,236.01 12,944.04 33.75 25,405.96 101-4-1310-4109 Workers Comp 1,650.00 0.00 832.50 50.45 817.50 TOTAL Personal Services 467,400.00 36,072.59 140,084.92 29.97 327,315.08 Supplies 101-4-1310-4201 Office Supplies 4,500.00 37.60 334.46 7.43 4,165.54 TOTAL Supplies 4,500.00 37.60 334.46 7.43 4,165.54 Other Services & Charges 101-4-1310-4301 Audit Fees 20,000.00 13,250.00 14,750.00 73.75 5,250.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 111.87 111.87 31.96 238.13 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 25.00 170.90 4.12 3,979.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 675.00 18,251.74 83.92 3,498.26 101-4-1310-4433 Dues & Subscriptions 1,600.00 555.00 735.00 45.94 865.00 101-4-1310-4438 Credit Card Fees 5,500.00 0.00 577.91 10.51 4,922.09 101-4-1310-4440 Miscellaneous 1,500.00 473.17 722.52 48.17 777.48 TOTAL Other Services & Charges 111,650.00 15,090.04 36,563.02 32.75 75,086.98 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Finance 583,550.00 51,200.23 176,982.40 30.33 406,567.60 Information Technology ====================== Personal Services 101-4-1350-4101 Regular Pay 188,650.00 14,402.33 54,728.86 29.01 133,921.14 101-4-1350-4104 PERA 14,150.00 1,080.18 4,320.72 30.54 9,829.28 101-4-1350-4105 FICA 11,700.00 816.87 3,262.65 27.89 8,437.35 101-4-1350-4107 Medicare 2,750.00 191.04 763.03 27.75 1,986.97 101-4-1350-4108 Insurance 32,350.00 2,728.02 10,912.08 33.73 21,437.92 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 9 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND General Government 33.33% 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 0.00 423.00 49.76 427.00 TOTAL Personal Services 250,450.00 19,218.44 74,410.34 29.71 176,039.66 Supplies 101-4-1350-4219 Operating Supplies 15,800.00 1,661.26 3,217.19 20.36 12,582.81 TOTAL Supplies 15,800.00 1,661.26 3,217.19 20.36 12,582.81 Other Services & Charges 101-4-1350-4319 Other Professional Services 8,000.00 40.00 502.50 6.28 7,497.50 101-4-1350-4321 Telephone 2,550.00 ( 436.46)( 942.70) 36.97- 3,492.70 101-4-1350-4331 Travel, Conferences & Schools 8,950.00 1,750.00 1,750.00 19.55 7,200.00 101-4-1350-4404 Equip Repair/Maint Services 60,600.00 8,723.94 30,649.38 50.58 29,950.62 TOTAL Other Services & Charges 80,100.00 10,077.48 31,959.18 39.90 48,140.82 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Information Technology 346,350.00 30,957.18 109,586.71 31.64 236,763.29 Legal ===== Personal Services _____________ _____________ _____________ _______ _____________ Supplies _____________ _____________ _____________ _______ _____________ Other Services & Charges 101-4-1400-4304 Legal Fees 214,600.00 3,815.10 41,013.30 19.11 173,586.70 TOTAL Other Services & Charges 214,600.00 3,815.10 41,013.30 19.11 173,586.70 ___________________________________________________________________________________________________________________ TOTAL Legal 214,600.00 3,815.10 41,013.30 19.11 173,586.70 Community Development ===================== Personal Services 101-4-1500-4101 Regular Pay 170,850.00 13,141.04 49,935.99 29.23 120,914.01 101-4-1500-4104 PERA 12,800.00 985.58 3,942.32 30.80 8,857.68 101-4-1500-4105 FICA 10,600.00 792.44 3,180.78 30.01 7,419.22 101-4-1500-4107 Medicare 2,500.00 185.33 743.87 29.75 1,756.13 101-4-1500-4108 Insurance 11,050.00 1,260.02 5,040.08 45.61 6,009.92 101-4-1500-4109 Workers Comp 750.00 0.00 383.00 51.07 367.00 TOTAL Personal Services 208,550.00 16,364.41 63,226.04 30.32 145,323.96 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 10 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND General Government 33.33% 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 26.32 592.21 53.84 507.79 TOTAL Supplies 1,100.00 26.32 592.21 53.84 507.79 Other Services & Charges 101-4-1500-4321 Telephone 700.00 160.26 160.26 22.89 539.74 101-4-1500-4331 Travel, Conferences & Schools 2,850.00 0.00 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 160.26 963.86 23.51 3,136.14 ___________________________________________________________________________________________________________________ TOTAL Community Development 213,750.00 16,550.99 64,782.11 30.31 148,967.89 Planning ======== Personal Services 101-4-1510-4101 Regular Pay 207,100.00 15,459.71 47,844.96 23.10 159,255.04 101-4-1510-4104 PERA 15,550.00 1,159.48 3,761.86 24.19 11,788.14 101-4-1510-4105 FICA 12,850.00 885.90 2,834.34 22.06 10,015.66 101-4-1510-4107 Medicare 3,000.00 207.19 662.89 22.10 2,337.11 101-4-1510-4108 Insurance 39,100.00 2,087.02 6,578.05 16.82 32,521.95 101-4-1510-4109 Workers Comp 950.00 0.00 513.00 54.00 437.00 TOTAL Personal Services 278,550.00 19,799.30 62,195.10 22.33 216,354.90 Supplies 101-4-1510-4201 Office Supplies 2,500.00 45.12 387.22 15.49 2,112.78 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 0.00 1,543.55 71.79 606.45 TOTAL Supplies 4,950.00 45.12 1,940.91 39.21 3,009.09 Other Services & Charges 101-4-1510-4321 Telephone 350.00 56.11 133.53 38.15 216.47 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 728.00 2,477.00 30.96 5,523.00 101-4-1510-4361 Insurance 50.00 11.75 23.50 47.00 26.50 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 92.00 138.00 55.20 112.00 TOTAL Other Services & Charges 13,900.00 887.86 4,330.22 31.15 9,569.78 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Planning 297,400.00 20,732.28 68,466.23 23.02 228,933.77 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 11 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND General Government 33.33% 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.87 98,347.31 28.67 244,652.69 101-4-1600-4102 Overtime Pay 3,500.00 127.38 818.34 23.38 2,681.66 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,950.61 7,825.61 30.10 18,174.39 101-4-1600-4105 FICA 21,700.00 1,614.72 6,477.03 29.85 15,222.97 101-4-1600-4107 Medicare 5,100.00 377.65 1,514.83 29.70 3,585.17 101-4-1600-4108 Insurance 40,550.00 3,519.04 14,076.16 34.71 26,473.84 101-4-1600-4109 Workers Comp 11,500.00 0.00 5,801.00 50.44 5,699.00 TOTAL Personal Services 454,800.00 33,470.27 134,860.28 29.65 319,939.72 Supplies 101-4-1600-4212 Fuels & Lubes 2,000.00 183.57 761.74 38.09 1,238.26 101-4-1600-4217 Uniform Allowance 2,400.00 0.00 504.85 21.04 1,895.15 101-4-1600-4219 Operating Supplies 30,400.00 1,734.59 15,188.97 49.96 15,211.03 TOTAL Supplies 34,800.00 1,918.16 16,455.56 47.29 18,344.44 Other Services & Charges 101-4-1600-4321 Telephone 11,700.00 543.34 3,067.29 26.22 8,632.71 101-4-1600-4331 Travel, Conferences & Schools 2,000.00 0.00 65.00 3.25 1,935.00 101-4-1600-4361 Insurance 5,350.00 1,301.00 2,602.00 48.64 2,748.00 101-4-1600-4389 Utilities 75,750.00 5,251.76 16,759.59 22.12 58,990.41 101-4-1600-4401 Bldg Repair/Maint Services 32,800.00 2,692.16 8,872.05 27.05 23,927.95 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 983.32 33.33 1,966.68 TOTAL Other Services & Charges 134,050.00 10,034.09 34,617.25 25.82 99,432.75 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL City Hall Maintenance 623,650.00 45,422.52 185,933.09 29.81 437,716.91 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 246,753.90 946,509.59 29.17 2,297,740.41 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 12 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Public Safety 33.33% 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 104,174.28 27.91 269,075.72 101-4-2110-4104 PERA 54,450.00 4,090.74 16,362.96 30.05 38,087.04 101-4-2110-4105 FICA 4,300.00 209.18 836.72 19.46 3,463.28 101-4-2110-4107 Medicare 5,400.00 373.70 1,494.80 27.68 3,905.20 101-4-2110-4108 Insurance 35,950.00 2,988.03 11,952.12 33.25 23,997.88 101-4-2110-4109 Workers Comp 61,500.00 0.00 30,515.50 49.62 30,984.50 TOTAL Personal Services 534,850.00 35,075.93 165,336.38 30.91 369,513.62 Supplies 101-4-2110-4201 Office Supplies 10,350.00 2,274.31 2,992.46 28.91 7,357.54 101-4-2110-4217 Uniform Allowance 2,950.00 0.00 480.09 16.27 2,469.91 101-4-2110-4219 Operating Supplies 1,300.00 57.35 2,052.64 157.90 ( 752.64) TOTAL Supplies 14,600.00 2,331.66 5,525.19 37.84 9,074.81 Other Services & Charges 101-4-2110-4319 Other Professional Services 6,900.00 79.95 79.95 1.16 6,820.05 101-4-2110-4321 Telephone 31,900.00 3,855.57 6,880.05 21.57 25,019.95 101-4-2110-4322 Postage 2,400.00 120.13 643.26 26.80 1,756.74 101-4-2110-4331 Travel, Conferences & Schools 10,200.00 710.00 965.00 9.46 9,235.00 101-4-2110-4359 Publishing 500.00 0.00 0.00 0.00 500.00 101-4-2110-4361 Insurance 41,450.00 10,059.75 20,119.50 48.54 21,330.50 101-4-2110-4404 Equip Repair/Maint Services 65,050.00 2,850.00 43,113.66 66.28 21,936.34 101-4-2110-4433 Dues & Subscriptions 5,500.00 0.00 1,204.00 21.89 4,296.00 101-4-2110-4437 Taxes & Licenses 350.00 0.00 72.00 20.57 278.00 TOTAL Other Services & Charges 164,250.00 17,675.40 73,077.42 44.49 91,172.58 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Administration 713,700.00 55,082.99 243,938.99 34.18 469,761.01 Patrol ====== Personal Services 101-4-2120-4101 Regular Pay 1,642,400.00 111,504.94 457,148.87 27.83 1,185,251.13 101-4-2120-4102 Overtime Pay 90,000.00 3,824.91 13,414.89 14.91 76,585.11 101-4-2120-4104 PERA 280,650.00 18,683.48 80,349.33 28.63 200,300.67 101-4-2120-4107 Medicare 23,800.00 1,501.23 6,481.38 27.23 17,318.62 101-4-2120-4108 Insurance 176,550.00 14,450.16 62,031.57 35.14 114,518.43 TOTAL Personal Services 2,213,400.00 149,964.72 619,426.04 27.99 1,593,973.96 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 13 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Public Safety 33.33% 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,727.02 24,994.38 28.40 63,005.62 101-4-2120-4217 Uniform Allowance 35,100.00 817.63 1,136.46 3.24 33,963.54 101-4-2120-4219 Operating Supplies 75,550.00 962.48 9,986.22 13.22 65,563.78 101-4-2120-4221 Equipment Parts 23,300.00 84.69 1,230.65 5.28 22,069.35 TOTAL Supplies 221,950.00 7,591.82 37,347.71 16.83 184,602.29 Other Services & Charges 101-4-2120-4331 Travel, Conferences & Schools 28,300.00 1,591.23 8,067.23 28.51 20,232.77 101-4-2120-4404 Equip Repair/Maint Services 20,700.00 79.95 1,340.08 6.47 19,359.92 101-4-2120-4433 Dues & Subscriptions 650.00 55.00 455.00 70.00 195.00 101-4-2120-4460 Equip Replacement Charge 45,150.00 3,762.50 15,050.00 33.33 30,100.00 TOTAL Other Services & Charges 94,800.00 5,488.68 24,912.31 26.28 69,887.69 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Patrol 2,530,150.00 163,045.22 681,686.06 26.94 1,848,463.94 Investigations ============== Personal Services 101-4-2130-4101 Regular Pay 676,050.00 47,447.56 201,692.25 29.83 474,357.75 101-4-2130-4102 Overtime Pay 50,000.00 869.93 4,820.11 9.64 45,179.89 101-4-2130-4104 PERA 117,600.00 7,827.44 31,100.24 26.45 86,499.76 101-4-2130-4107 Medicare 9,200.00 632.81 2,151.75 23.39 7,048.25 101-4-2130-4108 Insurance 95,250.00 7,341.14 26,513.77 27.84 68,736.23 TOTAL Personal Services 948,100.00 64,118.88 266,278.12 28.09 681,821.88 Supplies 101-4-2130-4217 Uniform Allowance 6,800.00 678.26 1,647.07 24.22 5,152.93 101-4-2130-4219 Operating Supplies 7,600.00 465.93 519.77 6.84 7,080.23 TOTAL Supplies 14,400.00 1,144.19 2,166.84 15.05 12,233.16 Other Services & Charges 101-4-2130-4319 Other Professional Services 6,500.00 150.00 417.00 6.42 6,083.00 101-4-2130-4331 Travel, Conferences & Schools 9,700.00 2,852.00 4,674.50 48.19 5,025.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 4,400.00 33.33 8,800.00 TOTAL Other Services & Charges 31,500.00 4,102.00 9,573.36 30.39 21,926.64 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Investigations 994,000.00 69,365.07 278,018.32 27.97 715,981.68 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 14 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Public Safety 33.33% 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 92,738.28 27.04 250,211.72 101-4-2150-4102 Overtime Pay 10,000.00 160.31 642.80 6.43 9,357.20 101-4-2150-4103 Part-time Pay 37,600.00 2,745.60 10,227.36 27.20 27,372.64 101-4-2150-4104 PERA 29,300.00 2,048.30 8,183.93 27.93 21,116.07 101-4-2150-4105 FICA 24,200.00 1,637.61 7,428.08 30.69 16,771.92 101-4-2150-4107 Medicare 5,650.00 382.99 1,737.26 30.75 3,912.74 101-4-2150-4108 Insurance 60,900.00 4,779.03 19,116.12 31.39 41,783.88 TOTAL Personal Services 510,600.00 36,158.65 140,073.83 27.43 370,526.17 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 475.20 836.19 18.58 3,663.81 101-4-2150-4219 Operating Supplies 18,900.00 ( 2,905.56)( 2,309.64) 12.22- 21,209.64 TOTAL Supplies 24,400.00 ( 2,430.36)( 1,473.45) 6.04- 25,873.45 Other Services & Charges 101-4-2150-4331 Travel, Conferences & Schools 4,800.00 21.63 346.63 7.22 4,453.37 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 110.00 1,228.00 12.28 8,772.00 101-4-2150-4433 Dues & Subscriptions 550.00 0.00 300.00 54.55 250.00 101-4-2150-4460 Equip Replacement Charge 6,000.00 500.00 2,000.00 33.33 4,000.00 TOTAL Other Services & Charges 23,600.00 631.63 4,320.38 18.31 19,279.62 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Support Services 558,600.00 34,359.92 142,920.76 25.59 415,679.24 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 0.00 485.00 8.82 5,015.00 101-4-2160-4219 Operating Supplies 6,500.00 3,353.00 5,021.88 77.26 1,478.12 TOTAL Supplies 12,000.00 3,353.00 5,506.88 45.89 6,493.12 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 15 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Public Safety 33.33% 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 545.00 25.95 1,555.00 101-4-2160-4331 Travel, Conferences & Schools 3,200.00 850.00 850.00 26.56 2,350.00 TOTAL Other Services & Charges 5,300.00 1,395.00 1,395.00 26.32 3,905.00 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Police Reserves 23,250.00 4,748.00 7,171.78 30.85 16,078.22 Public safety building ====================== Personal Services _____________ _____________ _____________ _______ _____________ Supplies 101-4-2190-4219 Operating Supplies 16,600.00 864.24 5,182.18 31.22 11,417.82 TOTAL Supplies 16,600.00 864.24 5,182.18 31.22 11,417.82 Other Services & Charges 101-4-2190-4361 Insurance 5,200.00 1,261.00 2,522.00 48.50 2,678.00 101-4-2190-4389 Utilities 97,500.00 6,524.65 20,211.35 20.73 77,288.65 101-4-2190-4401 Bldg Repair/Maint Services 36,700.00 3,950.70 7,586.74 20.67 29,113.26 TOTAL Other Services & Charges 139,400.00 11,736.35 30,320.09 21.75 109,079.91 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Public safety building 156,000.00 12,600.59 35,502.27 22.76 120,497.73 Fire Administration =================== Personal Services 101-4-2310-4101 Regular Pay 233,350.00 17,692.84 67,232.79 28.81 166,117.21 101-4-2310-4104 PERA 34,450.00 2,618.34 10,473.36 30.40 23,976.64 101-4-2310-4105 FICA 2,400.00 177.68 710.73 29.61 1,689.27 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 972.53 28.60 2,427.47 101-4-2310-4108 Insurance 29,100.00 2,534.11 10,136.44 34.83 18,963.56 101-4-2310-4109 Workers Comp 8,800.00 0.00 4,443.00 50.49 4,357.00 TOTAL Personal Services 341,500.00 23,266.10 93,968.85 27.52 247,531.15 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 287.79 1,405.37 56.21 1,094.63 101-4-2310-4217 Uniform Allowance 6,500.00 130.00 227.70 3.50 6,272.30 101-4-2310-4219 Operating Supplies 1,000.00 0.00 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 417.79 2,769.29 19.99 11,080.71 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 16 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Public Safety 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-2310-4319 Other Professional Services 10,000.00 1,697.50 1,697.50 16.98 8,302.50 101-4-2310-4321 Telephone 3,100.00 473.14 828.28 26.72 2,271.72 101-4-2310-4322 Postage 500.00 0.00 192.17 38.43 307.83 101-4-2310-4331 Travel, Conferences & Schools 7,500.00 1,393.45 1,393.45 18.58 6,106.55 101-4-2310-4359 Publishing 750.00 0.00 0.00 0.00 750.00 101-4-2310-4361 Insurance 12,000.00 2,905.50 5,811.00 48.43 6,189.00 101-4-2310-4389 Utilities 22,250.00 1,745.62 5,440.77 24.45 16,809.23 101-4-2310-4401 Bldg Repair/Maint Services 5,500.00 0.00 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 20.00 1,619.00 78.98 431.00 101-4-2310-4460 Equip Replacement Charge 53,800.00 4,483.33 17,933.32 33.33 35,866.68 TOTAL Other Services & Charges 120,400.00 12,718.54 36,768.74 30.54 83,631.26 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Fire Administration 475,750.00 36,402.43 133,506.88 28.06 342,243.12 Fire Operations =============== Personal Services 101-4-2320-4103 Part-time Pay 169,700.00 13,853.17 47,088.22 27.75 122,611.78 101-4-2320-4105 FICA 10,500.00 754.65 2,957.93 28.17 7,542.07 101-4-2320-4107 Medicare 2,450.00 176.50 691.82 28.24 1,758.18 101-4-2320-4109 Workers Comp 27,400.00 0.00 14,497.50 52.91 12,902.50 TOTAL Personal Services 210,050.00 14,784.32 65,235.47 31.06 144,814.53 Supplies 101-4-2320-4201 Office Supplies 300.00 0.00 37.22 12.41 262.78 101-4-2320-4212 Fuels & Lubes 8,700.00 621.30 2,680.39 30.81 6,019.61 101-4-2320-4217 Uniform Allowance 9,300.00 529.50 1,191.75 12.81 8,108.25 101-4-2320-4219 Operating Supplies 72,900.00 5,607.94 26,022.04 35.70 46,877.96 101-4-2320-4221 Equipment Parts 7,450.00 339.90 3,296.70 44.25 4,153.30 TOTAL Supplies 98,650.00 7,098.64 33,228.10 33.68 65,421.90 Other Services & Charges 101-4-2320-4321 Telephone 4,650.00 329.40 908.19 19.53 3,741.81 101-4-2320-4331 Travel, Conferences & Schools 26,000.00 374.17 3,981.21 15.31 22,018.79 101-4-2320-4404 Equip Repair/Maint Services 36,300.00 1,732.53 4,746.21 13.07 31,553.79 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 2,436.10 13,362.61 18.41 59,237.39 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 17 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Public Safety 33.33% 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 24,319.06 111,826.18 29.33 269,473.82 Emergency Management ==================== Personal Services _____________ _____________ _____________ _______ _____________ Supplies 101-4-2330-4219 Operating Supplies 7,100.00 11.04 11.04 0.16 7,088.96 TOTAL Supplies 7,100.00 11.04 11.04 0.16 7,088.96 Other Services & Charges 101-4-2330-4321 Telephone 0.00 25.23 118.98 0.00 ( 118.98) 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 348.43 1,032.26 28.28 2,617.74 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 373.66 2,040.24 11.53 15,659.76 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Emergency Management 24,800.00 384.70 2,051.28 8.27 22,748.72 Building Safety =============== Personal Services 101-4-2410-4101 Regular Pay 450,050.00 34,632.02 131,601.68 29.24 318,448.32 101-4-2410-4104 PERA 40,300.00 3,098.74 12,394.96 30.76 27,905.04 101-4-2410-4105 FICA 23,250.00 1,606.20 6,436.05 27.68 16,813.95 101-4-2410-4107 Medicare 6,550.00 453.53 1,816.75 27.74 4,733.25 101-4-2410-4108 Insurance 78,600.00 6,588.05 26,352.20 33.53 52,247.80 101-4-2410-4109 Workers Comp 2,050.00 0.00 1,041.50 50.80 1,008.50 TOTAL Personal Services 600,800.00 46,378.54 179,643.14 29.90 421,156.86 Supplies 101-4-2410-4201 Office Supplies 7,700.00 45.12 1,080.03 14.03 6,619.97 101-4-2410-4212 Fuels & Lubes 5,000.00 440.38 1,788.13 35.76 3,211.87 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 252.11 1,177.46 12.33 8,372.54 TOTAL Supplies 24,000.00 737.61 4,045.62 16.86 19,954.38 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 18 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Public Safety 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Other Services & Charges 101-4-2410-4321 Telephone 5,650.00 ( 34.04)( 120.94) 2.14- 5,770.94 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 80.05 1,242.01 32.68 2,557.99 101-4-2410-4361 Insurance 450.00 111.25 222.50 49.44 227.50 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 120.00 1,525.00 43.57 1,975.00 101-4-2410-4460 Equip Replacement Charge 3,250.00 270.83 1,083.32 33.33 2,166.68 TOTAL Other Services & Charges 22,950.00 548.09 6,120.08 26.67 16,829.92 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Building Safety 647,750.00 47,664.24 189,808.84 29.30 457,941.16 Code Enforcement ================ Personal Services 101-4-2420-4101 Regular Pay 70,300.00 5,408.00 20,550.40 29.23 49,749.60 101-4-2420-4104 PERA 5,250.00 405.60 1,622.40 30.90 3,627.60 101-4-2420-4105 FICA 4,350.00 347.49 1,389.96 31.95 2,960.04 101-4-2420-4107 Medicare 1,000.00 81.27 325.08 32.51 674.92 101-4-2420-4108 Insurance 3,600.00 300.01 1,200.04 33.33 2,399.96 101-4-2420-4109 Workers Comp 300.00 0.00 163.50 54.50 136.50 TOTAL Personal Services 84,800.00 6,542.37 25,251.38 29.78 59,548.62 Supplies 101-4-2420-4212 Fuels & Lubes 2,000.00 84.01 410.84 20.54 1,589.16 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 84.01 426.84 12.37 3,023.16 Other Services & Charges 101-4-2420-4321 Telephone 800.00 81.33 237.50 29.69 562.50 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 0.00 690.00 98.57 10.00 101-4-2420-4361 Insurance 100.00 27.50 55.00 55.00 45.00 TOTAL Other Services & Charges 3,350.00 108.83 1,233.27 36.81 2,116.73 ___________________________________________________________________________________________________________________ TOTAL Code Enforcement 91,600.00 6,735.21 26,911.49 29.38 64,688.51 Environmental ============= 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 19 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Public Safety 33.33% 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,015.50 7,696.70 28.61 19,203.30 101-4-2440-4104 PERA 2,000.00 151.16 607.70 30.39 1,392.30 101-4-2440-4105 FICA 1,650.00 124.96 502.36 30.45 1,147.64 101-4-2440-4107 Medicare 400.00 29.22 117.48 29.37 282.52 101-4-2440-4108 Insurance 3,350.00 368.65 1,474.60 44.02 1,875.40 101-4-2440-4109 Workers Comp 300.00 0.00 139.00 46.33 161.00 TOTAL Personal Services 34,600.00 2,689.49 10,537.84 30.46 24,062.16 Supplies 101-4-2440-4201 Office Supplies 450.00 3.76 10.89 2.42 439.11 101-4-2440-4212 Fuels & Lubes 200.00 12.90 41.85 20.93 158.15 101-4-2440-4219 Operating Supplies 0.00 0.00 819.60 0.00 ( 819.60) TOTAL Supplies 650.00 16.66 872.34 134.21 ( 222.34) 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 49.62 49.62 4.31 1,100.38 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 49.62 88.56 2.30 3,761.44 ___________________________________________________________________________________________________________________ TOTAL Environmental 39,100.00 2,755.77 11,498.74 29.41 27,601.26 ___________________________________________________________________________________________________________________ TOTAL Public Safety 6,636,000.00 457,463.20 1,864,841.59 28.10 4,771,158.41 Street Maintenance ================== Personal Services 101-4-3120-4101 Regular Pay 493,750.00 45,623.04 129,213.49 26.17 364,536.51 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,310.81 20,557.69 26.70 56,442.31 101-4-3120-4104 PERA 41,450.00 3,685.59 11,171.43 26.95 30,278.57 101-4-3120-4105 FICA 35,650.00 2,932.70 9,188.95 25.78 26,461.05 101-4-3120-4107 Medicare 8,350.00 685.86 2,149.02 25.74 6,200.98 101-4-3120-4108 Insurance 75,050.00 7,262.42 20,492.54 27.31 54,557.46 101-4-3120-4109 Workers Comp 28,600.00 0.00 14,477.50 50.62 14,122.50 TOTAL Personal Services 763,850.00 64,500.42 207,250.62 27.13 556,599.38 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 20 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Public Works 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-3120-4201 Office Supplies 2,850.00 3.76 125.89 4.42 2,724.11 101-4-3120-4212 Fuels & Lubes 66,200.00 19,167.01 16,551.62 25.00 49,648.38 101-4-3120-4219 Operating Supplies 60,000.00 1,662.22 9,232.32 15.39 50,767.68 101-4-3120-4221 Equipment Parts 50,000.00 6,825.49 16,649.97 33.30 33,350.03 101-4-3120-4226 Street Signs 30,500.00 6,764.57 23,460.92 76.92 7,039.08 TOTAL Supplies 209,550.00 34,423.05 66,020.72 31.51 143,529.28 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 39.80 643.38 10.55 5,456.62 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 20.00 425.00 8.33 4,675.00 101-4-3120-4359 Publishing 200.00 0.00 48.00 24.00 152.00 101-4-3120-4361 Insurance 19,000.00 4,613.00 9,026.75 47.51 9,973.25 101-4-3120-4389 Utilities 102,800.00 6,775.40 24,117.44 23.46 78,682.56 101-4-3120-4401 Bldg Repair/Maint Services 20,000.00 944.30 2,009.05 10.05 17,990.95 101-4-3120-4404 Equip Repair/Maint Services 9,000.00 0.00 3,590.45 39.89 5,409.55 101-4-3120-4409 Contractual Services 63,500.00 245.11 245.11 0.39 63,254.89 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 181.25 1,475.03 25.43 4,324.97 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 464.00 309.33 ( 314.00) 101-4-3120-4460 Equip Replacement Charge 100,950.00 8,412.50 33,650.00 33.33 67,300.00 TOTAL Other Services & Charges 336,600.00 21,231.36 75,985.38 22.57 260,614.62 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Street Maintenance 1,310,000.00 120,154.83 349,256.72 26.66 960,743.28 Snow Removal ============ Personal Services 101-4-3130-4101 Regular Pay 137,650.00 981.60 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 73.06 4,560.68 40.01 6,839.32 101-4-3130-4105 FICA 9,750.00 57.82 3,608.48 37.01 6,141.52 101-4-3130-4107 Medicare 2,300.00 13.53 843.93 36.69 1,456.07 101-4-3130-4108 Insurance 19,850.00 179.63 9,884.63 49.80 9,965.37 101-4-3130-4109 Workers Comp 8,150.00 0.00 3,965.50 48.66 4,184.50 TOTAL Personal Services 209,100.00 1,305.64 79,558.47 38.05 129,541.53 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 21 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Public Works 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-3130-4219 Operating Supplies 72,450.00 20,195.32 66,368.32 91.61 6,081.68 TOTAL Supplies 72,450.00 20,195.32 66,368.32 91.61 6,081.68 Other Services & Charges _____________ _____________ _____________ _______ _____________ Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Snow Removal 281,550.00 21,500.96 145,926.79 51.83 135,623.21 Equipment Services ================== Personal Services 101-4-3150-4101 Regular Pay 113,250.00 8,289.60 31,440.76 27.76 81,809.24 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 2,482.40 28.53 6,217.60 101-4-3150-4105 FICA 7,200.00 496.34 1,982.09 27.53 5,217.91 101-4-3150-4107 Medicare 1,700.00 116.08 463.56 27.27 1,236.44 101-4-3150-4108 Insurance 14,850.00 1,178.02 4,708.95 31.71 10,141.05 101-4-3150-4109 Workers Comp 3,150.00 0.00 1,594.50 50.62 1,555.50 TOTAL Personal Services 151,850.00 10,701.76 42,672.26 28.10 109,177.74 Supplies 101-4-3150-4212 Fuels & Lubes 5,100.00 ( 352.49) 587.02 11.51 4,512.98 101-4-3150-4219 Operating Supplies 11,150.00 665.78 2,814.10 25.24 8,335.90 101-4-3150-4221 Equipment Parts 3,000.00 292.69 608.50 20.28 2,391.50 TOTAL Supplies 19,250.00 605.98 4,009.62 20.83 15,240.38 Other Services & Charges 101-4-3150-4331 Travel, Conferences & Schools 3,000.00 659.99 659.99 22.00 2,340.01 101-4-3150-4404 Equip Repair/Maint Services 10,000.00 499.00 1,149.00 11.49 8,851.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 171.64 636.78 29.62 1,513.22 TOTAL Other Services & Charges 15,150.00 1,330.63 3,229.77 21.32 11,920.23 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Equipment Services 186,250.00 12,638.37 49,911.65 26.80 136,338.35 Engineering =========== 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 22 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Public Works 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Personal Services 101-4-3300-4101 Regular Pay 166,250.00 12,786.37 48,588.19 29.23 117,661.81 101-4-3300-4104 PERA 12,450.00 958.98 3,835.92 30.81 8,614.08 101-4-3300-4105 FICA 10,300.00 813.90 3,255.60 31.61 7,044.40 101-4-3300-4107 Medicare 2,400.00 190.36 761.44 31.73 1,638.56 101-4-3300-4108 Insurance 7,200.00 600.00 2,400.00 33.33 4,800.00 101-4-3300-4109 Workers Comp 750.00 0.00 387.50 51.67 362.50 TOTAL Personal Services 199,350.00 15,349.61 59,228.65 29.71 140,121.35 Supplies 101-4-3300-4201 Office Supplies 300.00 7.52 21.78 7.26 278.22 101-4-3300-4212 Fuels & Lubes 950.00 33.95 149.74 15.76 800.26 101-4-3300-4219 Operating Supplies 3,000.00 0.00 773.66 25.79 2,226.34 TOTAL Supplies 4,250.00 41.47 945.18 22.24 3,304.82 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 161.39 223.81 15.99 1,176.19 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 138.24 138.24 7.47 1,711.76 101-4-3300-4361 Insurance 100.00 22.25 44.50 44.50 55.50 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 500.00 33.33 1,000.00 TOTAL Other Services & Charges 14,350.00 446.88 955.25 6.66 13,394.75 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Engineering 217,950.00 15,837.96 61,129.08 28.05 156,820.92 ___________________________________________________________________________________________________________________ TOTAL Public Works 1,995,750.00 170,132.12 606,224.24 30.38 1,389,525.76 Parks Department ================ Personal Services 101-4-5110-4101 Regular Pay 409,900.00 31,168.08 115,784.38 28.25 294,115.62 101-4-5110-4102 Overtime Pay 6,600.00 84.33 2,093.46 31.72 4,506.54 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,343.93 9,297.11 29.75 21,952.89 101-4-5110-4105 FICA 30,050.00 1,730.12 6,879.08 22.89 23,170.92 101-4-5110-4107 Medicare 7,050.00 404.62 1,608.82 22.82 5,441.18 101-4-5110-4108 Insurance 73,500.00 6,340.06 24,754.40 33.68 48,745.60 101-4-5110-4109 Workers Comp 12,000.00 0.00 6,197.50 51.65 5,802.50 TOTAL Personal Services 638,600.00 42,071.14 166,614.75 26.09 471,985.25 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 23 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Culture & Recreation 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ Supplies 101-4-5110-4212 Fuels & Lubes 29,750.00 884.77 5,030.07 16.91 24,719.93 101-4-5110-4217 Uniform Allowance 3,800.00 4.50 1,246.21 32.80 2,553.79 101-4-5110-4219 Operating Supplies 94,900.00 8,562.05 21,329.33 22.48 73,570.67 101-4-5110-4221 Equipment Parts 26,000.00 757.70 6,398.94 24.61 19,601.06 TOTAL Supplies 154,450.00 10,209.02 34,004.55 22.02 120,445.45 Other Services & Charges 101-4-5110-4321 Telephone 4,900.00 ( 352.27)( 507.52) 10.36- 5,407.52 101-4-5110-4322 Postage 100.00 14.85 14.85 14.85 85.15 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 7,346.00 14,692.00 48.57 15,558.00 101-4-5110-4389 Utilities 75,250.00 2,525.67 7,155.11 9.51 68,094.89 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 307.70 307.70 1.74 17,342.30 101-4-5110-4409 Contractual Services 45,150.00 0.00 1,095.00 2.43 44,055.00 101-4-5110-4415 Equipment Rental 14,150.00 329.50 899.50 6.36 13,250.50 101-4-5110-4460 Equip Replacement Charge 48,850.00 4,070.83 16,283.32 33.33 32,566.68 TOTAL Other Services & Charges 245,050.00 14,242.28 41,496.91 16.93 203,553.09 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks Department 1,038,100.00 66,522.44 242,116.21 23.32 795,983.79 Parks & Rec Admin ================= Personal Services 101-4-5210-4101 Regular Pay 294,400.00 22,531.19 85,618.49 29.08 208,781.51 101-4-5210-4103 Part-time Pay 48,450.00 3,898.56 14,341.81 29.60 34,108.19 101-4-5210-4104 PERA 25,700.00 1,982.23 7,893.55 30.71 17,806.45 101-4-5210-4105 FICA 21,250.00 1,564.74 6,229.74 29.32 15,020.26 101-4-5210-4107 Medicare 4,950.00 365.97 1,457.06 29.44 3,492.94 101-4-5210-4108 Insurance 42,700.00 3,284.03 13,136.12 30.76 29,563.88 101-4-5210-4109 Workers Comp 3,650.00 0.00 1,803.50 49.41 1,846.50 TOTAL Personal Services 441,100.00 33,626.72 130,480.27 29.58 310,619.73 Supplies 101-4-5210-4219 Operating Supplies 10,200.00 200.81 3,003.21 29.44 7,196.79 TOTAL Supplies 10,200.00 200.81 3,003.21 29.44 7,196.79 Other Services & Charges 101-4-5210-4321 Telephone 6,400.00 ( 799.96)( 1,812.52) 28.32- 8,212.52 101-4-5210-4322 Postage 5,300.00 0.00 1,563.19 29.49 3,736.81 101-4-5210-4331 Travel, Conferences & Schools 9,850.00 154.98 405.93 4.12 9,444.07 101-4-5210-4349 Advertising/Marketing 33,200.00 49.00 6,184.79 18.63 27,015.21 101-4-5210-4361 Insurance 400.00 94.00 188.00 47.00 212.00 101-4-5210-4389 Utilities 11,300.00 677.10 1,987.99 17.59 9,312.01 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 24 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Culture & Recreation 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ 101-4-5210-4401 Bldg Repair/Maint Services 17,200.00 950.00 4,339.96 25.23 12,860.04 101-4-5210-4404 Equip Repair/Maint Services 8,400.00 16.75 7,784.59 92.67 615.41 101-4-5210-4433 Dues & Subscriptions 2,350.00 155.00 2,435.00 103.62 ( 85.00) TOTAL Other Services & Charges 94,400.00 1,296.87 23,076.93 24.45 71,323.07 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Parks & Rec Admin 545,700.00 35,124.40 156,560.41 28.69 389,139.59 Recreation Programs =================== Personal Services 101-4-5220-4103 Part-time Pay 82,000.00 1,538.68 10,284.46 12.54 71,715.54 101-4-5220-4105 FICA 4,300.00 95.40 669.56 15.57 3,630.44 101-4-5220-4107 Medicare 1,200.00 22.32 156.60 13.05 1,043.40 TOTAL Personal Services 87,500.00 1,656.40 11,110.62 12.70 76,389.38 Supplies 101-4-5220-4219 Operating Supplies 28,000.00 69.60 103.71 0.37 27,896.29 TOTAL Supplies 28,000.00 69.60 103.71 0.37 27,896.29 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 773.14 1,074.38 29.84 2,525.62 TOTAL Other Services & Charges 50,250.00 773.14 4,653.38 9.26 45,596.62 ___________________________________________________________________________________________________________________ TOTAL Recreation Programs 165,750.00 2,499.14 15,867.71 9.57 149,882.29 Concessions =========== Personal Services _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ Sr Citizen Programs =================== Personal Services 101-4-5510-4101 Regular Pay 118,900.00 8,942.41 33,981.15 28.58 84,918.85 101-4-5510-4103 Part-time Pay 3,150.00 390.00 998.40 31.70 2,151.60 101-4-5510-4104 PERA 8,900.00 670.68 2,682.72 30.14 6,217.28 101-4-5510-4105 FICA 7,550.00 550.60 2,170.41 28.75 5,379.59 101-4-5510-4107 Medicare 1,750.00 128.78 507.63 29.01 1,242.37 101-4-5510-4108 Insurance 21,650.00 1,787.01 7,148.04 33.02 14,501.96 101-4-5510-4109 Workers Comp 550.00 0.00 274.00 49.82 276.00 TOTAL Personal Services 162,450.00 12,469.48 47,762.35 29.40 114,687.65 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 25 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Culture & Recreation 33.33% 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 477.19 6,008.13 36.41 10,491.87 TOTAL Supplies 16,500.00 477.19 6,008.13 36.41 10,491.87 Other Services & Charges 101-4-5510-4321 Telephone 2,400.00 107.63 368.15 15.34 2,031.85 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 183.87 239.76 7.86 2,810.24 101-4-5510-4361 Insurance 1,400.00 334.50 669.00 47.79 731.00 101-4-5510-4389 Utilities 25,550.00 1,669.32 5,296.82 20.73 20,253.18 101-4-5510-4401 Bldg Repair/Maint Services 16,050.00 714.00 3,141.00 19.57 12,909.00 101-4-5510-4404 Equip Repair/Maint Services 100.00 16.75 16.75 16.75 83.25 101-4-5510-4409 Contractual Services 11,600.00 2,428.05 2,460.50 21.21 9,139.50 101-4-5510-4433 Dues & Subscriptions 850.00 0.00 307.24 36.15 542.76 TOTAL Other Services & Charges 64,000.00 5,454.12 13,383.92 20.91 50,616.08 Capital Outlay _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ TOTAL Sr Citizen Programs 242,950.00 18,400.79 67,154.40 27.64 175,795.60 ___________________________________________________________________________________________________________________ TOTAL Culture & Recreation 1,992,500.00 122,546.77 481,698.73 24.18 1,510,801.27 Economic Development ==================== Personal Services 101-4-6210-4101 Regular Pay 0.00 10,568.68 21,137.36 0.00 ( 21,137.36) 101-4-6210-4103 Part-time Pay 0.00 1,050.00 2,100.00 0.00 ( 2,100.00) 101-4-6210-4104 PERA 0.00 807.64 2,026.60 0.00 ( 2,026.60) 101-4-6210-4105 FICA 0.00 669.18 1,696.20 0.00 ( 1,696.20) 101-4-6210-4107 Medicare 0.00 160.88 409.80 0.00 ( 409.80) 101-4-6210-4108 Insurance 0.00 1,491.01 2,982.02 0.00 ( 2,982.02) 101-4-6210-4109 Workers Comp 0.00 ( 71.75) 0.00 0.00 0.00 TOTAL Personal Services 0.00 14,675.64 30,351.98 0.00 ( 30,351.98) Other Services & Charges 101-4-6210-4440 Miscellaneous 0.00 ( 8.58)( 62.12) 0.00 62.12 TOTAL Other Services & Charges 0.00 ( 8.58)( 62.12) 0.00 62.12 ___________________________________________________________________________________________________________________ TOTAL Economic Development 0.00 14,667.06 30,289.86 0.00 ( 30,289.86) 5-09-2016 05:32 PM CITY OF ELK RIVER PAGE: 26 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 101-GENERAL FUND Economic Development 33.33% 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 671.84 2,565.59 28.51 6,434.41 101-4-6220-4104 PERA 700.00 50.38 202.54 28.93 497.46 101-4-6220-4105 FICA 550.00 41.66 167.48 30.45 382.52 101-4-6220-4107 Medicare 150.00 9.74 39.14 26.09 110.86 101-4-6220-4108 Insurance 1,100.00 71.29 285.16 25.92 814.84 TOTAL Personal Services 11,500.00 844.91 3,259.91 28.35 8,240.09 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 11.88 11.88 1.19 988.12 101-4-6220-4359 Publishing 1,500.00 0.00 0.00 0.00 1,500.00 TOTAL Other Services & Charges 3,000.00 11.88 11.88 0.40 2,988.12 ___________________________________________________________________________________________________________________ TOTAL Energy City 16,300.00 856.79 3,271.79 20.07 13,028.21 ___________________________________________________________________________________________________________________ TOTAL Economic Development 16,300.00 15,523.85 33,561.65 205.90 ( 17,261.65) Transfers Out ============= Transfers Out _____________ _____________ _____________ _______ _____________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ ___________________________________________________________________________________________________________________ TOTAL EXPENDITURES 13,884,800.00 1,012,419.84 3,932,835.80 28.32 9,951,964.20 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 814,314.69)( 3,175,901.16) 3,175,901.16 5-09-2016 05:33 PM CITY OF ELK RIVER PAGE: 1 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 221-ICE ARENA FINANCIAL SUMMARY 33.33% OF YEAR COMP. CURRENT CURRENT YEAR TO DATE % OF BUDGET BUDGET PERIOD ACTUAL BUDGET BALANCE ___________________________________________________________________________________________________________________ REVENUE SUMMARY Ice Arena 628,100.00 23,553.43 245,786.71 39.13 382,313.29 Hockey 43,500.00 377.00 51,517.00 118.43 ( 8,017.00) Skating 38,400.00 51.00 12,087.00 31.48 26,313.00 Concessions 80,750.00 801.98 34,011.32 42.12 46,738.68 TOTAL REVENUES 790,750.00 24,783.41 343,402.03 43.43 447,347.97 ============= ============= ============= ======= ============= EXPENDITURE SUMMARY Culture & Recreation Ice Arena 845,600.00 38,706.06 154,504.25 18.27 691,095.75 Hockey 22,000.00 77.40 7,680.37 34.91 14,319.63 Skating 28,850.00 1,313.64 5,426.18 18.81 23,423.82 Arena Concessions 58,250.00 3,625.81 21,130.40 36.28 37,119.60 TOTAL Culture & Recreation 954,700.00 43,722.91 188,741.20 19.77 765,958.80 TOTAL EXPENDITURES 954,700.00 43,722.91 188,741.20 19.77 765,958.80 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES ( 163,950.00)( 18,939.50) 154,660.83 ( 318,610.83) 5-09-2016 05:33 PM CITY OF ELK RIVER PAGE: 2 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 221-ICE ARENA 33.33% 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 22,002.79 195,167.89 36.81 335,082.11 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 973.00 5,000.00 34.97 9,300.00 221-3-0000-3468 Skate Sharpening 4,300.00 52.00 1,252.00 29.12 3,048.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 483.36 2.16 21,916.64 TOTAL Charges for Services 599,700.00 23,148.63 210,335.75 35.07 389,364.25 Other Revenue 221-3-0000-3621 Interest Income 2,500.00 0.00 1,052.01 42.08 1,447.99 221-3-0000-3622 Vending Machines 15,000.00 348.60 4,518.48 30.12 10,481.52 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 39.40 ( 741.58) 19.01- 4,641.58 TOTAL Other Revenue 28,100.00 388.00 7,758.91 27.61 20,341.09 Sales 221-3-0000-3791 ATM Revenue 300.00 16.80 92.05 30.68 207.95 TOTAL Sales 300.00 16.80 92.05 30.68 207.95 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 23,553.43 245,786.71 39.13 382,313.29 Hockey ====== Charges for Services 221-3-5410-3461 Recreation Fees 43,500.00 377.00 51,517.00 118.43 ( 8,017.00) TOTAL Charges for Services 43,500.00 377.00 51,517.00 118.43 ( 8,017.00) Other Revenue _____________ _____________ _____________ _______ _____________ _____________________________________________________________________________ TOTAL Hockey 43,500.00 377.00 51,517.00 118.43 ( 8,017.00) 5-09-2016 05:33 PM CITY OF ELK RIVER PAGE: 3 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 221-ICE ARENA 33.33% 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 71.00 9,987.00 27.90 25,813.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 71.00 9,987.00 26.01 28,413.00 Other Revenue 221-3-5420-3629 Miscellaneous Revenue 0.00 ( 20.00) 2,100.00 0.00 ( 2,100.00) TOTAL Other Revenue 0.00 ( 20.00) 2,100.00 0.00 ( 2,100.00) _____________________________________________________________________________ TOTAL Skating 38,400.00 51.00 12,087.00 31.48 26,313.00 Concessions =========== Charges for Services 221-3-5430-3467 Concessions 80,750.00 801.98 34,011.32 42.12 46,738.68 TOTAL Charges for Services 80,750.00 801.98 34,011.32 42.12 46,738.68 _____________________________________________________________________________ TOTAL Concessions 80,750.00 801.98 34,011.32 42.12 46,738.68 ___________________________________________________________________________________________________________________ TOTAL REVENUE 790,750.00 24,783.41 343,402.03 43.43 447,347.97 ============= ============= ============= ======= ============= 5-09-2016 05:33 PM CITY OF ELK RIVER PAGE: 4 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 221-ICE ARENA 33.33% 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 44,821.70 24.91 135,128.30 221-4-5400-4103 Part-time Pay 61,900.00 4,668.29 23,888.50 38.59 38,011.50 221-4-5400-4104 PERA 18,150.00 1,096.45 5,024.25 27.68 13,125.75 221-4-5400-4105 FICA 15,050.00 978.46 4,512.69 29.98 10,537.31 221-4-5400-4107 Medicare 3,550.00 228.83 1,055.39 29.73 2,494.61 221-4-5400-4108 Insurance 28,800.00 1,531.02 7,926.08 27.52 20,873.92 221-4-5400-4109 Workers Comp 9,350.00 0.00 4,733.50 50.63 4,616.50 TOTAL Personal Services 316,750.00 18,871.87 91,962.11 29.03 224,787.89 Supplies 221-4-5400-4212 Fuels & Lubes 300.00 13.47 74.30 24.77 225.70 221-4-5400-4217 Uniform Allowance 850.00 55.80 42.70 5.02 807.30 221-4-5400-4219 Operating Supplies 49,600.00 3,240.45 7,254.31 14.63 42,345.69 221-4-5400-4255 Soft Drinks/Misc 6,950.00 599.58 1,337.84 19.25 5,612.16 221-4-5400-4259 Other Merchandise For Resale 900.00 0.00 0.00 0.00 900.00 TOTAL Supplies 58,600.00 3,909.30 8,709.15 14.86 49,890.85 Other Services & Charges 221-4-5400-4321 Telephone 3,350.00 ( 229.39)( 152.07) 4.54- 3,502.07 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 1,984.00 2,209.00 40.53 3,241.00 221-4-5400-4361 Insurance 4,950.00 1,144.75 2,289.50 46.25 2,660.50 221-4-5400-4389 Utilities 161,950.00 12,737.95 40,755.06 25.17 121,194.94 221-4-5400-4401 Bldg Repair/Maint Services 29,250.00 55.95 7,557.92 25.84 21,692.08 221-4-5400-4409 Contractual Services 2,650.00 4.50 4.50 0.17 2,645.50 221-4-5400-4415 Equipment Rental 3,700.00 227.13 908.52 24.55 2,791.48 221-4-5400-4433 Dues & Subscriptions 550.00 0.00 245.00 44.55 305.00 TOTAL Other Services & Charges 213,900.00 15,924.89 53,832.99 25.17 160,067.01 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 38,706.06 154,504.25 18.27 691,095.75 5-09-2016 05:33 PM CITY OF ELK RIVER PAGE: 5 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 221-ICE ARENA Culture & Recreation 33.33% 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 6,233.50 50.27 6,166.50 TOTAL Supplies 12,400.00 0.00 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 77.40 1,446.87 48.23 1,553.13 TOTAL Other Services & Charges 8,700.00 77.40 1,446.87 16.63 7,253.13 ___________________________________________________________________________________________________________________ TOTAL Hockey 22,000.00 77.40 7,680.37 34.91 14,319.63 Skating ======= Personal Services 221-4-5420-4103 Part-time Pay 17,800.00 685.35 3,512.71 19.73 14,287.29 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 42.50 222.01 20.18 877.99 221-4-5420-4107 Medicare 250.00 9.93 51.92 20.77 198.08 TOTAL Personal Services 20,150.00 737.78 3,786.64 18.79 16,363.36 Supplies 221-4-5420-4219 Operating Supplies 4,900.00 572.26 596.59 12.18 4,303.41 TOTAL Supplies 4,900.00 572.26 596.59 12.18 4,303.41 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 3.60 268.77 26.88 731.23 TOTAL Other Services & Charges 3,800.00 3.60 1,042.95 27.45 2,757.05 ___________________________________________________________________________________________________________________ TOTAL Skating 28,850.00 1,313.64 5,426.18 18.81 23,423.82 Arena Concessions ================= 5-09-2016 05:33 PM CITY OF ELK RIVER PAGE: 6 REVENUE & EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30TH, 2016 221-ICE ARENA Culture & Recreation 33.33% 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,065.36 9,312.04 43.72 11,987.96 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 66.06 631.25 48.56 668.75 221-4-5430-4107 Medicare 300.00 15.46 147.67 49.22 152.33 TOTAL Personal Services 24,500.00 1,146.88 10,090.96 41.19 14,409.04 Supplies 221-4-5430-4219 Operating Supplies 3,250.00 0.00 117.07 3.60 3,132.93 221-4-5430-4259 Other Merchandise For Resale 30,500.00 2,478.93 10,922.37 35.81 19,577.63 TOTAL Supplies 33,750.00 2,478.93 11,039.44 32.71 22,710.56 ___________________________________________________________________________________________________________________ TOTAL Arena Concessions 58,250.00 3,625.81 21,130.40 36.28 37,119.60 ___________________________________________________________________________________________________________________ TOTAL Culture & Recreation 954,700.00 43,722.91 188,741.20 19.77 765,958.80 ___________________________________________________________________________________________________________________ TOTAL EXPENDITURES 954,700.00 43,722.91 188,741.20 19.77 765,958.80 ============= ============= ============= ======= ============= REVENUES OVER/(UNDER) EXPENDITURES ( 163,950.00)( 18,939.50) 154,660.83 ( 318,610.83) CITY OF ELK RIVER ENTERPRISE FUNDS - BUDGET TO ACTUAL MONTH ENDED APRIL, 2016 LiquorSewerGarbageStormwater 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,991,480 $ 4,942,520 28.72% Cost of sales (4,957,300) (1,075,429) (3,881,871)21.69% 1,976,700 916,051 Gross profit 1,060,649 46.34% Operating revenues: User charges$ - $ - $ - 0.00%$ 1,860,000 $ 463,432 $ 1,396,568 24.92%$ 1,310,000 $ 332,071 $ 977,929 25.35%$ 420,000 $ 112,208 $ 307,792 26.72% Delinquency collections - - -0.00% 1,300 - 1,3000.00% 13,000 - 13,000 0.00% - - -0.00% Other 1,700 734 96643.18% 2,000 - 2,0000.00% 3,500 625 2,87517.86% - - -0.00% 1,700 734 1,863,300 463,432 1,326,500 332,696 420,000 112,208 Total operating revenues 96643.18% 1,399,868 24.87% 993,804 25.08% 307,792 26.72% Operating expenses: Personal services 659,850 193,600 466,250 29.34% 532,650 156,422 376,228 29.37% 22,900 6,520 16,380 28.47% 80,650 23,711 56,939 29.40% Supplies 53,700 7,314 46,386 13.62% 217,800 22,062 195,738 10.13% 6,300 1,884 4,41629.90% 7,000 - 7,0000.00% Other service charges 231,950 52,214 179,736 22.51% 517,200 105,527 411,673 20.40% 1,340,700 346,758 993,942 25.86% 403,150 71,098 332,052 17.64% Depreciation * 123,000 - 123,000 0.00% 1,424,350 - 1,424,350 0.00% - - -0.00% 433,750 - 433,750 0.00% 1,068,500 253,128 2,692,000 284,011 1,369,900 355,162 924,550 94,809 Total operating expenses 815,372 23.69% 2,407,989 10.55% 1,014,738 25.93% 829,741 10.25% 909,900 663,657 (828,700) 179,421 (43,400) (22,466) (504,550) 17,399 Operating income (loss) 246,243 72.94% (1,008,121)-21.65% (20,934)51.76% (521,949)-3.45% Nonoperating revenues (expenses): Interest income 25,000 8,288 16,712 33.15% 80,000 17,675 62,325 22.09% 6,250 1,506 4,74424.10% 1,500 529 97135.27% Grant revenue - - -0.00% 800,000 187,020 612,980 23.38% - - -0.00% - - -0.00% Interest expense - - -0.00% (272,400) (23,033) (249,367)8.46% - - -0.00% - - -0.00% 25,000 8,288 607,600 181,662 6,250 1,506 1,500 529 Total nonoperating revenues (expenses) 16,712 33.15% 425,938 29.90% 4,74424.10% 97135.27% Income (loss) before contributions and transfers 934,900 671,945 262,955 71.87% (221,100) 361,083 (582,183)-163.31% (37,150) (20,960) (16,190)56.42% (503,050) 17,928 (520,978)-3.56% Contributions - connection fees - - -0.00% 492,700 79,325 413,375 16.10% - - -0.00% 51,500 5,506 45,994 10.69% Transfers in - - -0.00% - - -0.00% 36,600 - 36,600 0.00% - - -0.00% Transfers out (718,950) - (718,950)0.00% (100,000) - (100,000)0.00% (45,000) - (45,000)0.00% - - -0.00% NET INCOME (LOSS) 215,950 671,945 (455,995)311.16% 171,600 440,408 (268,808)256.65% (45,550) (20,960) (24,590)46.02% (451,550) 23,434 (474,984)-5.19% Items reclassified to balance sheet at year end: Capital Outlay (5,012,000) (1,324,731) (3,687,269)26.43% (180,000) - Bond Payment (400,000) (400,000) -100.00% Revenues over/(under) expenditures 215,950 671,945 (455,995) (5,240,400) (1,284,323) (3,956,077) (45,550) (20,960) (24,590) (631,550) 23,434 (474,984) * Recorded ar yearend 5-10-2016 12:57 PM CITY OF ELK RIVER PAGE: 1 POOLED CASH REPORT (FUND 999) AS OF: APRIL 30TH, 2016 BEGINNING CURRENT CURRENT FUND ACCOUNT# ACCOUNT NAME BALANCE ACTIVITY BALANCE ___________________________________________________________________________________________________ CLAIM ON CASH 002-1010 Cash - Section 125 23,106.22 744.85 23,851.07 101-1010 Cash - General Fund 4,118,046.13 ( 810,119.74) 3,307,926.39 211-1010 Cash - Library 429,628.19 ( 4,570.42) 425,057.77 221-1010 Cash - Ice Arena 425,919.94 ( 5,531.61) 420,388.33 225-1010 Cash - Park Dedication 51,588.26 0.00 51,588.26 228-1010 Cash - Landfill 520,019.93 ( 1,315.12) 518,704.81 231-1010 Cash - Landfill Const Debris 729,331.87 0.00 729,331.87 240-1010 Cash - Micro Loan Fund 971,586.27 1,576.73 973,163.00 241-1010 Cash - Federal DEED 200,000.00 0.00 200,000.00 242-1010 Cash - State DEED 101,523.68 1,886.49 103,410.17 245-1010 Cash - Development Fund 868,271.11 ( 1,925.00) 866,346.11 290-1010 Cash - Capital Outlay Reserve 973,556.93 ( 82,998.70) 890,558.23 291-1010 Cash - Insurance Reserve 265,249.17 ( 48,512.86) 216,736.31 292-1010 Cash - Govt Bldgs Reserve 1,269,865.76 180,184.25 1,450,050.01 294-1010 Cash - Drug Forfeiture 15,567.46 722.12 16,289.58 295-1010 Cash - Severance Pay Reserve 71,255.99 0.00 71,255.99 296-1010 Cash - GRE Reserve 2,988,847.89 0.00 2,988,847.89 313-1010 Cash - 2007C/2012B GO Bonds 115,065.85 ( 450.00) 114,615.85 333-1010 Cash - 2010A GO Cap Imp Bonds 265,915.38 0.00 265,915.38 344-1010 Cash - 2006C Cap Imp Bonds Lby ( 450.00) 0.00 ( 450.00) 345-1010 Cash - 2012A CIP Bonds-PW 0.00 ( 450.00) ( 450.00) 401-1010 Cash - Pavement Mgmt 2,869,753.36 189,302.36 3,059,055.72 403-1010 Cash - Street Improvement 1,791,392.31 ( 815.00) 1,790,577.31 406-1010 Cash - City Wide Trunk Util 3,788,175.81 0.00 3,788,175.81 410-1010 Cash - Equipment Replacement 749,783.76 ( 30,649.62) 719,134.14 426-1010 Cash - YMCA 137,224.64 0.00 137,224.64 440-1010 Cash - Park Improvement 363,555.30 ( 13,543.93) 350,011.37 463-1010 Cash - TIF #23 Pref Powder 620.95 0.00 620.95 602-1010 Cash - Wastewater Treatment 6,128,562.31 ( 397,839.64) 5,730,722.67 603-1010 Cash - Liquor 3,124,348.12 167,930.08 3,292,278.20 605-1010 Cash - Garbage 547,178.16 ( 16,984.63) 530,193.53 607-1010 Cash - Storm Water 218,809.09 27,191.38 246,000.47 801-1010 Cash - Interest 29,856.81 35,671.79 65,528.60 821-1010 Cash - Developer Escrow 111,217.84 3,800.00 115,017.84_ TOTAL CLAIM ON CASH 34,264,374.49 ( 806,696.22) 33,457,678.27 =============== ============== ============== CASH IN BANK - POOLED CASH 999-1000 A/P BANK ACCOUNTS 73,085,867.77 77,530.09 73,163,397.86 999-1001 PY BANK ACCOUNT (67,203,682.84) ( 884,226.31) (68,087,909.15) 999-1002 POOLED INVESTMENTS 28,382,189.56 0.00 28,382,189.56_ SUBTOTAL CASH IN BANK - POOLED CASH 34,264,374.49 ( 806,696.22) 33,457,678.27